eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_PG_NOTIF_UTILITY_PVT dependencies on FND_MESSAGE

Line 775: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');

771: p_item_id IS NULL ) THEN
772:
773: error_flag := TRUE;
774: x_return_status := FND_API.G_RET_STS_ERROR;
775: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
776: FND_MESSAGE.SET_TOKEN('ITEM_NAME', p_item_name);
777: FND_MSG_PUB.Add;
778: END IF;
779:

Line 776: FND_MESSAGE.SET_TOKEN('ITEM_NAME', p_item_name);

772:
773: error_flag := TRUE;
774: x_return_status := FND_API.G_RET_STS_ERROR;
775: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
776: FND_MESSAGE.SET_TOKEN('ITEM_NAME', p_item_name);
777: FND_MSG_PUB.Add;
778: END IF;
779:
780:

Line 1071: FND_MESSAGE.SET_NAME('PV', 'PV_ENRL_REQ_NOT_EXIST');

1067: x_return_status => x_return_status);
1068:
1069: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1070: THEN
1071: FND_MESSAGE.SET_NAME('PV', 'PV_ENRL_REQ_NOT_EXIST');
1072: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);
1073: FND_MSG_PUB.Add;
1074: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1075: RAISE FND_API.G_EXC_ERROR;

Line 1072: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);

1068:
1069: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1070: THEN
1071: FND_MESSAGE.SET_NAME('PV', 'PV_ENRL_REQ_NOT_EXIST');
1072: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);
1073: FND_MSG_PUB.Add;
1074: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1075: RAISE FND_API.G_EXC_ERROR;
1076: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1103: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');

1099:
1100: /* Check for Procedure's x_return_status */
1101: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1102: THEN
1103: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
1104: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);
1105: FND_MSG_PUB.Add;
1106: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1107: RAISE FND_API.G_EXC_ERROR;

Line 1104: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);

1100: /* Check for Procedure's x_return_status */
1101: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1102: THEN
1103: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
1104: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);
1105: FND_MSG_PUB.Add;
1106: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1107: RAISE FND_API.G_EXC_ERROR;
1108: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1124: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');

1120:
1121: /* Check for Procedure's x_return_status */
1122: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1123: THEN
1124: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
1125: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);
1126: FND_MSG_PUB.Add;
1127: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1128: RAISE FND_API.G_EXC_ERROR;

Line 1125: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);

1121: /* Check for Procedure's x_return_status */
1122: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1123: THEN
1124: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
1125: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);
1126: FND_MSG_PUB.Add;
1127: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1128: RAISE FND_API.G_EXC_ERROR;
1129: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1143: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');

1139: x_return_status => x_return_status ) ;
1140:
1141: /* Check for Procedure's x_return_status */
1142: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1143: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');
1144: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);
1145: FND_MSG_PUB.Add;
1146: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1147: RAISE FND_API.G_EXC_ERROR;

Line 1144: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);

1140:
1141: /* Check for Procedure's x_return_status */
1142: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1143: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');
1144: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);
1145: FND_MSG_PUB.Add;
1146: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1147: RAISE FND_API.G_EXC_ERROR;
1148: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1171: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');

1167: );
1168:
1169: /* Check for Procedure's x_return_status */
1170: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1171: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');
1172: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);
1173: FND_MSG_PUB.Add;
1174: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1175: RAISE FND_API.G_EXC_ERROR;

Line 1172: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);

1168:
1169: /* Check for Procedure's x_return_status */
1170: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1171: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');
1172: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);
1173: FND_MSG_PUB.Add;
1174: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1175: RAISE FND_API.G_EXC_ERROR;
1176: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1191: fnd_message.set_name('PV', 'PV_VENDOR_NM');

1187: /* Set all the entity attributes by replacing the supplyied parameters.*/
1188: -- WF_Notification.SetAttrText(l_notif_id,'DOCUMENT_ID', 'PVXNUTIL:'||l_notif_id);
1189: /* Set the Vendor Name */
1190: /*
1191: fnd_message.set_name('PV', 'PV_VENDOR_NM');
1192: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
1193: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
1194: */
1195:

Line 1192: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);

1188: -- WF_Notification.SetAttrText(l_notif_id,'DOCUMENT_ID', 'PVXNUTIL:'||l_notif_id);
1189: /* Set the Vendor Name */
1190: /*
1191: fnd_message.set_name('PV', 'PV_VENDOR_NM');
1192: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
1193: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
1194: */
1195:
1196: -- Set the subject line

Line 1193: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);

1189: /* Set the Vendor Name */
1190: /*
1191: fnd_message.set_name('PV', 'PV_VENDOR_NM');
1192: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
1193: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
1194: */
1195:
1196: -- Set the subject line
1197: fnd_message.set_name('PV', 'PV_NTF_THANKYOU_SUBJECT');

Line 1197: fnd_message.set_name('PV', 'PV_NTF_THANKYOU_SUBJECT');

1193: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
1194: */
1195:
1196: -- Set the subject line
1197: fnd_message.set_name('PV', 'PV_NTF_THANKYOU_SUBJECT');
1198: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
1199: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
1200:
1201:

Line 1198: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);

1194: */
1195:
1196: -- Set the subject line
1197: fnd_message.set_name('PV', 'PV_NTF_THANKYOU_SUBJECT');
1198: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
1199: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
1200:
1201:
1202: -- Set the Message Header

Line 1199: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);

1195:
1196: -- Set the subject line
1197: fnd_message.set_name('PV', 'PV_NTF_THANKYOU_SUBJECT');
1198: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
1199: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
1200:
1201:
1202: -- Set the Message Header
1203: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');

Line 1203: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');

1199: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
1200:
1201:
1202: -- Set the Message Header
1203: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
1204: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);
1205: l_message_hdr := fnd_message.get || l_newline;
1206:
1207:

Line 1204: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);

1200:
1201:
1202: -- Set the Message Header
1203: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
1204: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);
1205: l_message_hdr := fnd_message.get || l_newline;
1206:
1207:
1208: l_message_body := fnd_message.get_string('PV', 'PV_NTF_THANKYOU_GREETINGS') || l_newline;

Line 1205: l_message_hdr := fnd_message.get || l_newline;

1201:
1202: -- Set the Message Header
1203: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
1204: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);
1205: l_message_hdr := fnd_message.get || l_newline;
1206:
1207:
1208: l_message_body := fnd_message.get_string('PV', 'PV_NTF_THANKYOU_GREETINGS') || l_newline;
1209: l_message_body := l_message_body || l_newline;

Line 1208: l_message_body := fnd_message.get_string('PV', 'PV_NTF_THANKYOU_GREETINGS') || l_newline;

1204: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);
1205: l_message_hdr := fnd_message.get || l_newline;
1206:
1207:
1208: l_message_body := fnd_message.get_string('PV', 'PV_NTF_THANKYOU_GREETINGS') || l_newline;
1209: l_message_body := l_message_body || l_newline;
1210: l_message_body := l_message_body || fnd_message.get_string('PV', 'PV_NTF_ENRL_PROCESSING')|| l_newline ;
1211: l_message_body := l_message_body || l_newline;
1212:

Line 1210: l_message_body := l_message_body || fnd_message.get_string('PV', 'PV_NTF_ENRL_PROCESSING')|| l_newline ;

1206:
1207:
1208: l_message_body := fnd_message.get_string('PV', 'PV_NTF_THANKYOU_GREETINGS') || l_newline;
1209: l_message_body := l_message_body || l_newline;
1210: l_message_body := l_message_body || fnd_message.get_string('PV', 'PV_NTF_ENRL_PROCESSING')|| l_newline ;
1211: l_message_body := l_message_body || l_newline;
1212:
1213: -- Set the Partner Company Name
1214: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');

Line 1214: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');

1210: l_message_body := l_message_body || fnd_message.get_string('PV', 'PV_NTF_ENRL_PROCESSING')|| l_newline ;
1211: l_message_body := l_message_body || l_newline;
1212:
1213: -- Set the Partner Company Name
1214: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');
1215: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
1216: l_message_body := l_message_body ||fnd_message.get|| l_newline ;
1217:
1218: -- Set the requestor name

Line 1215: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);

1211: l_message_body := l_message_body || l_newline;
1212:
1213: -- Set the Partner Company Name
1214: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');
1215: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
1216: l_message_body := l_message_body ||fnd_message.get|| l_newline ;
1217:
1218: -- Set the requestor name
1219: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');

Line 1216: l_message_body := l_message_body ||fnd_message.get|| l_newline ;

1212:
1213: -- Set the Partner Company Name
1214: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');
1215: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
1216: l_message_body := l_message_body ||fnd_message.get|| l_newline ;
1217:
1218: -- Set the requestor name
1219: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
1220: fnd_message.set_token('PV_REQUESTOR_NM', rtrim(l_source_name));

Line 1219: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');

1215: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
1216: l_message_body := l_message_body ||fnd_message.get|| l_newline ;
1217:
1218: -- Set the requestor name
1219: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
1220: fnd_message.set_token('PV_REQUESTOR_NM', rtrim(l_source_name));
1221: l_message_body := l_message_body || fnd_message.get || l_newline ;
1222:
1223: -- Set the request submission date

Line 1220: fnd_message.set_token('PV_REQUESTOR_NM', rtrim(l_source_name));

1216: l_message_body := l_message_body ||fnd_message.get|| l_newline ;
1217:
1218: -- Set the requestor name
1219: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
1220: fnd_message.set_token('PV_REQUESTOR_NM', rtrim(l_source_name));
1221: l_message_body := l_message_body || fnd_message.get || l_newline ;
1222:
1223: -- Set the request submission date
1224: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');

Line 1221: l_message_body := l_message_body || fnd_message.get || l_newline ;

1217:
1218: -- Set the requestor name
1219: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
1220: fnd_message.set_token('PV_REQUESTOR_NM', rtrim(l_source_name));
1221: l_message_body := l_message_body || fnd_message.get || l_newline ;
1222:
1223: -- Set the request submission date
1224: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');
1225: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);

Line 1224: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');

1220: fnd_message.set_token('PV_REQUESTOR_NM', rtrim(l_source_name));
1221: l_message_body := l_message_body || fnd_message.get || l_newline ;
1222:
1223: -- Set the request submission date
1224: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');
1225: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);
1226: l_message_body := l_message_body || fnd_message.get|| l_newline;
1227:
1228: -- Set the partner program name

Line 1225: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);

1221: l_message_body := l_message_body || fnd_message.get || l_newline ;
1222:
1223: -- Set the request submission date
1224: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');
1225: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);
1226: l_message_body := l_message_body || fnd_message.get|| l_newline;
1227:
1228: -- Set the partner program name
1229: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');

Line 1226: l_message_body := l_message_body || fnd_message.get|| l_newline;

1222:
1223: -- Set the request submission date
1224: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');
1225: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);
1226: l_message_body := l_message_body || fnd_message.get|| l_newline;
1227:
1228: -- Set the partner program name
1229: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
1230: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);

Line 1229: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');

1225: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);
1226: l_message_body := l_message_body || fnd_message.get|| l_newline;
1227:
1228: -- Set the partner program name
1229: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
1230: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
1231: l_message_body := l_message_body || fnd_message.get || l_newline;
1232:
1233: -- Set the enrollment duration

Line 1230: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);

1226: l_message_body := l_message_body || fnd_message.get|| l_newline;
1227:
1228: -- Set the partner program name
1229: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
1230: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
1231: l_message_body := l_message_body || fnd_message.get || l_newline;
1232:
1233: -- Set the enrollment duration
1234: fnd_message.set_name('PV', 'PV_NTF_ENRL_DURATION');

Line 1231: l_message_body := l_message_body || fnd_message.get || l_newline;

1227:
1228: -- Set the partner program name
1229: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
1230: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
1231: l_message_body := l_message_body || fnd_message.get || l_newline;
1232:
1233: -- Set the enrollment duration
1234: fnd_message.set_name('PV', 'PV_NTF_ENRL_DURATION');
1235: fnd_message.set_token('PV_ENRL_DURATION', l_enrollment_duration);

Line 1234: fnd_message.set_name('PV', 'PV_NTF_ENRL_DURATION');

1230: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
1231: l_message_body := l_message_body || fnd_message.get || l_newline;
1232:
1233: -- Set the enrollment duration
1234: fnd_message.set_name('PV', 'PV_NTF_ENRL_DURATION');
1235: fnd_message.set_token('PV_ENRL_DURATION', l_enrollment_duration);
1236: l_message_body := l_message_body || fnd_message.get || l_newline;
1237:
1238: -- Set the enrollment type

Line 1235: fnd_message.set_token('PV_ENRL_DURATION', l_enrollment_duration);

1231: l_message_body := l_message_body || fnd_message.get || l_newline;
1232:
1233: -- Set the enrollment duration
1234: fnd_message.set_name('PV', 'PV_NTF_ENRL_DURATION');
1235: fnd_message.set_token('PV_ENRL_DURATION', l_enrollment_duration);
1236: l_message_body := l_message_body || fnd_message.get || l_newline;
1237:
1238: -- Set the enrollment type
1239: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');

Line 1236: l_message_body := l_message_body || fnd_message.get || l_newline;

1232:
1233: -- Set the enrollment duration
1234: fnd_message.set_name('PV', 'PV_NTF_ENRL_DURATION');
1235: fnd_message.set_token('PV_ENRL_DURATION', l_enrollment_duration);
1236: l_message_body := l_message_body || fnd_message.get || l_newline;
1237:
1238: -- Set the enrollment type
1239: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');
1240: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);

Line 1239: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');

1235: fnd_message.set_token('PV_ENRL_DURATION', l_enrollment_duration);
1236: l_message_body := l_message_body || fnd_message.get || l_newline;
1237:
1238: -- Set the enrollment type
1239: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');
1240: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);
1241: l_message_body := l_message_body || fnd_message.get || l_newline;
1242:
1243: -- Get the values for all message attributes from the message list for Message Footer

Line 1240: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);

1236: l_message_body := l_message_body || fnd_message.get || l_newline;
1237:
1238: -- Set the enrollment type
1239: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');
1240: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);
1241: l_message_body := l_message_body || fnd_message.get || l_newline;
1242:
1243: -- Get the values for all message attributes from the message list for Message Footer
1244: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;

Line 1241: l_message_body := l_message_body || fnd_message.get || l_newline;

1237:
1238: -- Set the enrollment type
1239: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');
1240: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);
1241: l_message_body := l_message_body || fnd_message.get || l_newline;
1242:
1243: -- Get the values for all message attributes from the message list for Message Footer
1244: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
1245: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;

Line 1244: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;

1240: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);
1241: l_message_body := l_message_body || fnd_message.get || l_newline;
1242:
1243: -- Get the values for all message attributes from the message list for Message Footer
1244: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
1245: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
1246: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
1247:
1248: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);

Line 1245: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;

1241: l_message_body := l_message_body || fnd_message.get || l_newline;
1242:
1243: -- Get the values for all message attributes from the message list for Message Footer
1244: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
1245: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
1246: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
1247:
1248: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
1249: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);

Line 1246: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;

1242:
1243: -- Get the values for all message attributes from the message list for Message Footer
1244: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
1245: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
1246: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
1247:
1248: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
1249: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
1250: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);

Line 1268: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');

1264: x_pgp_notif_rec => l_pgp_notif_rec );
1265:
1266: /* Check for Procedure's x_return_status */
1267: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1268: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
1269: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
1270: FND_MSG_PUB.Add;
1271: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1272: RAISE FND_API.G_EXC_ERROR;

Line 1269: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);

1265:
1266: /* Check for Procedure's x_return_status */
1267: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1268: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
1269: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
1270: FND_MSG_PUB.Add;
1271: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1272: RAISE FND_API.G_EXC_ERROR;
1273: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1292: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');

1288: x_party_notification_id => x_party_notification_id );
1289:
1290: /* Check for Procedure's x_return_status */
1291: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1292: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
1293: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
1294: FND_MSG_PUB.Add;
1295: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1296: RAISE FND_API.G_EXC_ERROR;

Line 1293: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);

1289:
1290: /* Check for Procedure's x_return_status */
1291: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1292: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
1293: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
1294: FND_MSG_PUB.Add;
1295: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1296: RAISE FND_API.G_EXC_ERROR;
1297: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1327: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');

1323: x_msg_data => x_msg_data );
1324:
1325: /* Check for Procedure's x_return_status */
1326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1327: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');
1328: FND_MESSAGE.SET_TOKEN('ID',p_enrl_request_id);
1329: FND_MSG_PUB.Add;
1330: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1331: RAISE FND_API.G_EXC_ERROR;

Line 1328: FND_MESSAGE.SET_TOKEN('ID',p_enrl_request_id);

1324:
1325: /* Check for Procedure's x_return_status */
1326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1327: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');
1328: FND_MESSAGE.SET_TOKEN('ID',p_enrl_request_id);
1329: FND_MSG_PUB.Add;
1330: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1331: RAISE FND_API.G_EXC_ERROR;
1332: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1542: FND_MESSAGE.SET_NAME('PV','PV_MBRSHIP_NOT_EXIST');

1538: x_return_status => x_return_status);
1539:
1540:
1541: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1542: FND_MESSAGE.SET_NAME('PV','PV_MBRSHIP_NOT_EXIST');
1543: FND_MESSAGE.SET_TOKEN('MEMBERSHIP_ID',p_membership_id);
1544: FND_MSG_PUB.Add;
1545: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1546: RAISE FND_API.G_EXC_ERROR;

Line 1543: FND_MESSAGE.SET_TOKEN('MEMBERSHIP_ID',p_membership_id);

1539:
1540:
1541: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1542: FND_MESSAGE.SET_NAME('PV','PV_MBRSHIP_NOT_EXIST');
1543: FND_MESSAGE.SET_TOKEN('MEMBERSHIP_ID',p_membership_id);
1544: FND_MSG_PUB.Add;
1545: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1546: RAISE FND_API.G_EXC_ERROR;
1547: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1573: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');

1569:
1570:
1571: /* Check for Procedure's x_return_status */
1572: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1573: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
1574: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',l_enrl_request_id);
1575: FND_MSG_PUB.Add;
1576: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1577: RAISE FND_API.G_EXC_ERROR;

Line 1574: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',l_enrl_request_id);

1570:
1571: /* Check for Procedure's x_return_status */
1572: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1573: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
1574: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',l_enrl_request_id);
1575: FND_MSG_PUB.Add;
1576: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1577: RAISE FND_API.G_EXC_ERROR;
1578: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1592: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');

1588: x_user_name => l_user_name,
1589: x_return_status => x_return_status);
1590:
1591: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1592: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
1593: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);
1594: FND_MSG_PUB.Add;
1595: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1596: RAISE FND_API.G_EXC_ERROR;

Line 1593: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);

1589: x_return_status => x_return_status);
1590:
1591: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1592: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
1593: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);
1594: FND_MSG_PUB.Add;
1595: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1596: RAISE FND_API.G_EXC_ERROR;
1597: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1611: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');

1607: x_return_status => x_return_status ) ;
1608:
1609: /* Check for Procedure's x_return_status */
1610: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1611: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');
1612: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);
1613: FND_MSG_PUB.Add;
1614: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1615: RAISE FND_API.G_EXC_ERROR;

Line 1612: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);

1608:
1609: /* Check for Procedure's x_return_status */
1610: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1611: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');
1612: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);
1613: FND_MSG_PUB.Add;
1614: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1615: RAISE FND_API.G_EXC_ERROR;
1616: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1641: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');

1637:
1638: /* Check for Procedure's x_return_status */
1639: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1640: THEN
1641: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');
1642: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);
1643: FND_MSG_PUB.Add;
1644: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1645: RAISE FND_API.G_EXC_ERROR;

Line 1642: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);

1638: /* Check for Procedure's x_return_status */
1639: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1640: THEN
1641: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');
1642: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);
1643: FND_MSG_PUB.Add;
1644: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1645: RAISE FND_API.G_EXC_ERROR;
1646: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1661: fnd_message.set_name('PV', 'PV_NTF_WELCOME_SUBJECT');

1657:
1658: WF_Notification.SetAttrText(l_notif_id,'NOTIF_DOC_ID', 'PVXNUTIL:'||l_notif_id); -- passing the doc id
1659:
1660: /* Set the subject line */
1661: fnd_message.set_name('PV', 'PV_NTF_WELCOME_SUBJECT');
1662: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
1663: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
1664:
1665: /* Set the Message Header */

Line 1662: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);

1658: WF_Notification.SetAttrText(l_notif_id,'NOTIF_DOC_ID', 'PVXNUTIL:'||l_notif_id); -- passing the doc id
1659:
1660: /* Set the subject line */
1661: fnd_message.set_name('PV', 'PV_NTF_WELCOME_SUBJECT');
1662: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
1663: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
1664:
1665: /* Set the Message Header */
1666: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');

Line 1663: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);

1659:
1660: /* Set the subject line */
1661: fnd_message.set_name('PV', 'PV_NTF_WELCOME_SUBJECT');
1662: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
1663: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
1664:
1665: /* Set the Message Header */
1666: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
1667: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);

Line 1666: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');

1662: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
1663: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
1664:
1665: /* Set the Message Header */
1666: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
1667: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);
1668: l_message_hdr := fnd_message.get || l_newline;
1669:
1670: /* Set all the entity attributes by replacing the supplied parameters. */

Line 1667: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);

1663: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
1664:
1665: /* Set the Message Header */
1666: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
1667: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);
1668: l_message_hdr := fnd_message.get || l_newline;
1669:
1670: /* Set all the entity attributes by replacing the supplied parameters. */
1671:

Line 1668: l_message_hdr := fnd_message.get || l_newline;

1664:
1665: /* Set the Message Header */
1666: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
1667: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);
1668: l_message_hdr := fnd_message.get || l_newline;
1669:
1670: /* Set all the entity attributes by replacing the supplied parameters. */
1671:
1672: /* Set the Vendor Name

Line 1673: fnd_message.set_name('PV', 'PV_VENDOR_NM');

1669:
1670: /* Set all the entity attributes by replacing the supplied parameters. */
1671:
1672: /* Set the Vendor Name
1673: fnd_message.set_name('PV', 'PV_VENDOR_NM');
1674: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
1675: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
1676: */
1677:

Line 1674: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);

1670: /* Set all the entity attributes by replacing the supplied parameters. */
1671:
1672: /* Set the Vendor Name
1673: fnd_message.set_name('PV', 'PV_VENDOR_NM');
1674: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
1675: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
1676: */
1677:
1678: /* Set the welcome greeting Line */

Line 1675: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);

1671:
1672: /* Set the Vendor Name
1673: fnd_message.set_name('PV', 'PV_VENDOR_NM');
1674: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
1675: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
1676: */
1677:
1678: /* Set the welcome greeting Line */
1679: fnd_message.set_name('PV', 'PV_NTF_WELCOME_GREETINGS');

Line 1679: fnd_message.set_name('PV', 'PV_NTF_WELCOME_GREETINGS');

1675: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
1676: */
1677:
1678: /* Set the welcome greeting Line */
1679: fnd_message.set_name('PV', 'PV_NTF_WELCOME_GREETINGS');
1680: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
1681: l_message_body := fnd_message.get || l_newline;
1682: l_message_body := l_message_body || l_newline;
1683:

Line 1680: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);

1676: */
1677:
1678: /* Set the welcome greeting Line */
1679: fnd_message.set_name('PV', 'PV_NTF_WELCOME_GREETINGS');
1680: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
1681: l_message_body := fnd_message.get || l_newline;
1682: l_message_body := l_message_body || l_newline;
1683:
1684: /* Set the Partner Company Name */

Line 1681: l_message_body := fnd_message.get || l_newline;

1677:
1678: /* Set the welcome greeting Line */
1679: fnd_message.set_name('PV', 'PV_NTF_WELCOME_GREETINGS');
1680: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
1681: l_message_body := fnd_message.get || l_newline;
1682: l_message_body := l_message_body || l_newline;
1683:
1684: /* Set the Partner Company Name */
1685: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');

Line 1685: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');

1681: l_message_body := fnd_message.get || l_newline;
1682: l_message_body := l_message_body || l_newline;
1683:
1684: /* Set the Partner Company Name */
1685: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');
1686: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
1687: l_message_body := l_message_body || fnd_message.get || l_newline;
1688:
1689: /* Set the Requestor Name */

Line 1686: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);

1682: l_message_body := l_message_body || l_newline;
1683:
1684: /* Set the Partner Company Name */
1685: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');
1686: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
1687: l_message_body := l_message_body || fnd_message.get || l_newline;
1688:
1689: /* Set the Requestor Name */
1690: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');

Line 1687: l_message_body := l_message_body || fnd_message.get || l_newline;

1683:
1684: /* Set the Partner Company Name */
1685: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');
1686: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
1687: l_message_body := l_message_body || fnd_message.get || l_newline;
1688:
1689: /* Set the Requestor Name */
1690: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
1691: fnd_message.set_token('PV_REQUESTOR_NM', l_source_name);

Line 1690: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');

1686: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
1687: l_message_body := l_message_body || fnd_message.get || l_newline;
1688:
1689: /* Set the Requestor Name */
1690: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
1691: fnd_message.set_token('PV_REQUESTOR_NM', l_source_name);
1692: l_message_body := l_message_body || fnd_message.get || l_newline;
1693:
1694: /* Set the Request Submission Date */

Line 1691: fnd_message.set_token('PV_REQUESTOR_NM', l_source_name);

1687: l_message_body := l_message_body || fnd_message.get || l_newline;
1688:
1689: /* Set the Requestor Name */
1690: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
1691: fnd_message.set_token('PV_REQUESTOR_NM', l_source_name);
1692: l_message_body := l_message_body || fnd_message.get || l_newline;
1693:
1694: /* Set the Request Submission Date */
1695: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');

Line 1692: l_message_body := l_message_body || fnd_message.get || l_newline;

1688:
1689: /* Set the Requestor Name */
1690: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
1691: fnd_message.set_token('PV_REQUESTOR_NM', l_source_name);
1692: l_message_body := l_message_body || fnd_message.get || l_newline;
1693:
1694: /* Set the Request Submission Date */
1695: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');
1696: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);

Line 1695: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');

1691: fnd_message.set_token('PV_REQUESTOR_NM', l_source_name);
1692: l_message_body := l_message_body || fnd_message.get || l_newline;
1693:
1694: /* Set the Request Submission Date */
1695: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');
1696: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);
1697: l_message_body := l_message_body || fnd_message.get || l_newline;
1698:
1699: /* Set the Partner Program Name */

Line 1696: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);

1692: l_message_body := l_message_body || fnd_message.get || l_newline;
1693:
1694: /* Set the Request Submission Date */
1695: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');
1696: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);
1697: l_message_body := l_message_body || fnd_message.get || l_newline;
1698:
1699: /* Set the Partner Program Name */
1700: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');

Line 1697: l_message_body := l_message_body || fnd_message.get || l_newline;

1693:
1694: /* Set the Request Submission Date */
1695: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');
1696: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);
1697: l_message_body := l_message_body || fnd_message.get || l_newline;
1698:
1699: /* Set the Partner Program Name */
1700: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
1701: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);

Line 1700: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');

1696: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);
1697: l_message_body := l_message_body || fnd_message.get || l_newline;
1698:
1699: /* Set the Partner Program Name */
1700: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
1701: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
1702: l_message_body := l_message_body || fnd_message.get || l_newline;
1703:
1704: /* Set the Enrollment Start Date */

Line 1701: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);

1697: l_message_body := l_message_body || fnd_message.get || l_newline;
1698:
1699: /* Set the Partner Program Name */
1700: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
1701: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
1702: l_message_body := l_message_body || fnd_message.get || l_newline;
1703:
1704: /* Set the Enrollment Start Date */
1705: fnd_message.set_name('PV', 'PV_NTF_ENRL_START_DT');

Line 1702: l_message_body := l_message_body || fnd_message.get || l_newline;

1698:
1699: /* Set the Partner Program Name */
1700: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
1701: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
1702: l_message_body := l_message_body || fnd_message.get || l_newline;
1703:
1704: /* Set the Enrollment Start Date */
1705: fnd_message.set_name('PV', 'PV_NTF_ENRL_START_DT');
1706: fnd_message.set_token('PV_ENRL_START_DT', l_enrollment_start_date);

Line 1705: fnd_message.set_name('PV', 'PV_NTF_ENRL_START_DT');

1701: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
1702: l_message_body := l_message_body || fnd_message.get || l_newline;
1703:
1704: /* Set the Enrollment Start Date */
1705: fnd_message.set_name('PV', 'PV_NTF_ENRL_START_DT');
1706: fnd_message.set_token('PV_ENRL_START_DT', l_enrollment_start_date);
1707: l_message_body := l_message_body || fnd_message.get || l_newline;
1708:
1709: /* Set the Enrollment End Date */

Line 1706: fnd_message.set_token('PV_ENRL_START_DT', l_enrollment_start_date);

1702: l_message_body := l_message_body || fnd_message.get || l_newline;
1703:
1704: /* Set the Enrollment Start Date */
1705: fnd_message.set_name('PV', 'PV_NTF_ENRL_START_DT');
1706: fnd_message.set_token('PV_ENRL_START_DT', l_enrollment_start_date);
1707: l_message_body := l_message_body || fnd_message.get || l_newline;
1708:
1709: /* Set the Enrollment End Date */
1710: fnd_message.set_name('PV', 'PV_NTF_ENRL_END_DT');

Line 1707: l_message_body := l_message_body || fnd_message.get || l_newline;

1703:
1704: /* Set the Enrollment Start Date */
1705: fnd_message.set_name('PV', 'PV_NTF_ENRL_START_DT');
1706: fnd_message.set_token('PV_ENRL_START_DT', l_enrollment_start_date);
1707: l_message_body := l_message_body || fnd_message.get || l_newline;
1708:
1709: /* Set the Enrollment End Date */
1710: fnd_message.set_name('PV', 'PV_NTF_ENRL_END_DT');
1711: fnd_message.set_token('PV_ENRL_END_DT', l_enrollment_end_date);

Line 1710: fnd_message.set_name('PV', 'PV_NTF_ENRL_END_DT');

1706: fnd_message.set_token('PV_ENRL_START_DT', l_enrollment_start_date);
1707: l_message_body := l_message_body || fnd_message.get || l_newline;
1708:
1709: /* Set the Enrollment End Date */
1710: fnd_message.set_name('PV', 'PV_NTF_ENRL_END_DT');
1711: fnd_message.set_token('PV_ENRL_END_DT', l_enrollment_end_date);
1712: l_message_body := l_message_body || fnd_message.get || l_newline;
1713:
1714: /* Set the Enrollment Type */

Line 1711: fnd_message.set_token('PV_ENRL_END_DT', l_enrollment_end_date);

1707: l_message_body := l_message_body || fnd_message.get || l_newline;
1708:
1709: /* Set the Enrollment End Date */
1710: fnd_message.set_name('PV', 'PV_NTF_ENRL_END_DT');
1711: fnd_message.set_token('PV_ENRL_END_DT', l_enrollment_end_date);
1712: l_message_body := l_message_body || fnd_message.get || l_newline;
1713:
1714: /* Set the Enrollment Type */
1715: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');

Line 1712: l_message_body := l_message_body || fnd_message.get || l_newline;

1708:
1709: /* Set the Enrollment End Date */
1710: fnd_message.set_name('PV', 'PV_NTF_ENRL_END_DT');
1711: fnd_message.set_token('PV_ENRL_END_DT', l_enrollment_end_date);
1712: l_message_body := l_message_body || fnd_message.get || l_newline;
1713:
1714: /* Set the Enrollment Type */
1715: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');
1716: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);

Line 1715: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');

1711: fnd_message.set_token('PV_ENRL_END_DT', l_enrollment_end_date);
1712: l_message_body := l_message_body || fnd_message.get || l_newline;
1713:
1714: /* Set the Enrollment Type */
1715: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');
1716: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);
1717: l_message_body := l_message_body || fnd_message.get || l_newline;
1718: l_message_body := l_message_body || l_newline;
1719:

Line 1716: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);

1712: l_message_body := l_message_body || fnd_message.get || l_newline;
1713:
1714: /* Set the Enrollment Type */
1715: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');
1716: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);
1717: l_message_body := l_message_body || fnd_message.get || l_newline;
1718: l_message_body := l_message_body || l_newline;
1719:
1720: --kvattiku Oct 31, 05 Commented out and modified code so that the URL is obtained from profile.

Line 1717: l_message_body := l_message_body || fnd_message.get || l_newline;

1713:
1714: /* Set the Enrollment Type */
1715: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');
1716: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);
1717: l_message_body := l_message_body || fnd_message.get || l_newline;
1718: l_message_body := l_message_body || l_newline;
1719:
1720: --kvattiku Oct 31, 05 Commented out and modified code so that the URL is obtained from profile.
1721: --/* Set the Log-in portal line */

Line 1734: fnd_message.set_name('PV', 'PV_NTF_LOGIN_PORTAL');

1730: p_responsibility_id => 23073,
1731: p_security_group_id => fnd_global.security_group_id );
1732: */
1733:
1734: fnd_message.set_name('PV', 'PV_NTF_LOGIN_PORTAL');
1735: fnd_message.set_token('PV_LOGIN_PORTAL', l_prtner_portal_url);
1736: --fnd_message.set_token('PV_LOGIN_PORTAL', '');
1737: l_message_body := l_message_body || fnd_message.get || l_newline;
1738:

Line 1735: fnd_message.set_token('PV_LOGIN_PORTAL', l_prtner_portal_url);

1731: p_security_group_id => fnd_global.security_group_id );
1732: */
1733:
1734: fnd_message.set_name('PV', 'PV_NTF_LOGIN_PORTAL');
1735: fnd_message.set_token('PV_LOGIN_PORTAL', l_prtner_portal_url);
1736: --fnd_message.set_token('PV_LOGIN_PORTAL', '');
1737: l_message_body := l_message_body || fnd_message.get || l_newline;
1738:
1739:

Line 1736: --fnd_message.set_token('PV_LOGIN_PORTAL', '');

1732: */
1733:
1734: fnd_message.set_name('PV', 'PV_NTF_LOGIN_PORTAL');
1735: fnd_message.set_token('PV_LOGIN_PORTAL', l_prtner_portal_url);
1736: --fnd_message.set_token('PV_LOGIN_PORTAL', '');
1737: l_message_body := l_message_body || fnd_message.get || l_newline;
1738:
1739:
1740: /* Get the values for all message attributes from the message list for Message Footer */

Line 1737: l_message_body := l_message_body || fnd_message.get || l_newline;

1733:
1734: fnd_message.set_name('PV', 'PV_NTF_LOGIN_PORTAL');
1735: fnd_message.set_token('PV_LOGIN_PORTAL', l_prtner_portal_url);
1736: --fnd_message.set_token('PV_LOGIN_PORTAL', '');
1737: l_message_body := l_message_body || fnd_message.get || l_newline;
1738:
1739:
1740: /* Get the values for all message attributes from the message list for Message Footer */
1741: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;

Line 1741: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;

1737: l_message_body := l_message_body || fnd_message.get || l_newline;
1738:
1739:
1740: /* Get the values for all message attributes from the message list for Message Footer */
1741: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
1742: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
1743: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
1744:
1745:

Line 1742: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;

1738:
1739:
1740: /* Get the values for all message attributes from the message list for Message Footer */
1741: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
1742: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
1743: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
1744:
1745:
1746: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);

Line 1743: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;

1739:
1740: /* Get the values for all message attributes from the message list for Message Footer */
1741: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
1742: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
1743: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
1744:
1745:
1746: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
1747: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);

Line 1766: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');

1762: x_pgp_notif_rec => l_pgp_notif_rec );
1763:
1764: /* Check for Procedure's x_return_status */
1765: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1766: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
1767: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
1768: FND_MSG_PUB.Add;
1769: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1770: RAISE FND_API.G_EXC_ERROR;

Line 1767: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);

1763:
1764: /* Check for Procedure's x_return_status */
1765: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1766: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
1767: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
1768: FND_MSG_PUB.Add;
1769: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1770: RAISE FND_API.G_EXC_ERROR;
1771: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1791: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');

1787: x_party_notification_id => x_party_notification_id );
1788:
1789: /* Check for Procedure's x_return_status */
1790: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1791: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
1792: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
1793: FND_MSG_PUB.Add;
1794: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1795: RAISE FND_API.G_EXC_ERROR;

Line 1792: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);

1788:
1789: /* Check for Procedure's x_return_status */
1790: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1791: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
1792: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
1793: FND_MSG_PUB.Add;
1794: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1795: RAISE FND_API.G_EXC_ERROR;
1796: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1826: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');

1822: x_msg_data => x_msg_data );
1823:
1824: /* Check for Procedure's x_return_status */
1825: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1826: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');
1827: FND_MESSAGE.SET_TOKEN('ID',p_membership_id);
1828: FND_MSG_PUB.Add;
1829: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1830: RAISE FND_API.G_EXC_ERROR;

Line 1827: FND_MESSAGE.SET_TOKEN('ID',p_membership_id);

1823:
1824: /* Check for Procedure's x_return_status */
1825: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1826: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');
1827: FND_MESSAGE.SET_TOKEN('ID',p_membership_id);
1828: FND_MSG_PUB.Add;
1829: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1830: RAISE FND_API.G_EXC_ERROR;
1831: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2038: FND_MESSAGE.SET_NAME('PV', 'PV_ENRL_REQ_NOT_EXIST');

2034: x_prtnr_vndr_relship_id => l_prtnr_vndr_relship_id,
2035: x_return_status => x_return_status);
2036:
2037: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2038: FND_MESSAGE.SET_NAME('PV', 'PV_ENRL_REQ_NOT_EXIST');
2039: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);
2040: FND_MSG_PUB.Add;
2041: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2042: RAISE FND_API.G_EXC_ERROR;

Line 2039: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);

2035: x_return_status => x_return_status);
2036:
2037: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2038: FND_MESSAGE.SET_NAME('PV', 'PV_ENRL_REQ_NOT_EXIST');
2039: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);
2040: FND_MSG_PUB.Add;
2041: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2042: RAISE FND_API.G_EXC_ERROR;
2043: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2068: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');

2064: x_return_status => x_return_status);
2065:
2066: /* Check for API return status */
2067: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2068: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
2069: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);
2070: FND_MSG_PUB.Add;
2071: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2072: RAISE FND_API.G_EXC_ERROR;

Line 2069: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);

2065:
2066: /* Check for API return status */
2067: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2068: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
2069: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);
2070: FND_MSG_PUB.Add;
2071: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2072: RAISE FND_API.G_EXC_ERROR;
2073: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2112: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');

2108: x_user_name => l_user_name,
2109: x_return_status => x_return_status);
2110:
2111: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2112: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
2113: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);
2114: FND_MSG_PUB.Add;
2115: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2116: RAISE FND_API.G_EXC_ERROR;

Line 2113: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);

2109: x_return_status => x_return_status);
2110:
2111: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2112: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
2113: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);
2114: FND_MSG_PUB.Add;
2115: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2116: RAISE FND_API.G_EXC_ERROR;
2117: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2130: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');

2126: x_user_count => l_user_count,
2127: x_return_status => x_return_status ) ;
2128:
2129: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2130: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');
2131: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);
2132: FND_MSG_PUB.Add;
2133: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2134: RAISE FND_API.G_EXC_ERROR;

Line 2131: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);

2127: x_return_status => x_return_status ) ;
2128:
2129: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2130: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');
2131: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);
2132: FND_MSG_PUB.Add;
2133: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2134: RAISE FND_API.G_EXC_ERROR;
2135: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2157: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');

2153: x_return_status => x_return_status
2154: );
2155:
2156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2157: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');
2158: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);
2159: FND_MSG_PUB.Add;
2160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2161: RAISE FND_API.G_EXC_ERROR;

Line 2158: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);

2154: );
2155:
2156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2157: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');
2158: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);
2159: FND_MSG_PUB.Add;
2160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2161: RAISE FND_API.G_EXC_ERROR;
2162: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2177: fnd_message.set_name('PV', 'PV_VENDOR_NM');

2173: /* Set all the entity attributes by replacing the supplyied parameters. */
2174: -- WF_Notification.SetAttrText(l_notif_id,'DOCUMENT_ID', 'PVXNUTIL:'||l_notif_id);
2175: /* Set the Vendor Name */
2176: /*
2177: fnd_message.set_name('PV', 'PV_VENDOR_NM');
2178: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
2179: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
2180: */
2181:

Line 2178: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);

2174: -- WF_Notification.SetAttrText(l_notif_id,'DOCUMENT_ID', 'PVXNUTIL:'||l_notif_id);
2175: /* Set the Vendor Name */
2176: /*
2177: fnd_message.set_name('PV', 'PV_VENDOR_NM');
2178: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
2179: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
2180: */
2181:
2182: /* Set the subject line */

Line 2179: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);

2175: /* Set the Vendor Name */
2176: /*
2177: fnd_message.set_name('PV', 'PV_VENDOR_NM');
2178: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
2179: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
2180: */
2181:
2182: /* Set the subject line */
2183: fnd_message.set_name('PV', 'PV_NTF_REJECTION_SUBJECT');

Line 2183: fnd_message.set_name('PV', 'PV_NTF_REJECTION_SUBJECT');

2179: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
2180: */
2181:
2182: /* Set the subject line */
2183: fnd_message.set_name('PV', 'PV_NTF_REJECTION_SUBJECT');
2184: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
2185: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
2186:
2187: /* Set the Message Header */

Line 2184: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);

2180: */
2181:
2182: /* Set the subject line */
2183: fnd_message.set_name('PV', 'PV_NTF_REJECTION_SUBJECT');
2184: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
2185: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
2186:
2187: /* Set the Message Header */
2188: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');

Line 2185: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);

2181:
2182: /* Set the subject line */
2183: fnd_message.set_name('PV', 'PV_NTF_REJECTION_SUBJECT');
2184: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
2185: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
2186:
2187: /* Set the Message Header */
2188: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
2189: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);

Line 2188: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');

2184: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
2185: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
2186:
2187: /* Set the Message Header */
2188: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
2189: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);
2190: l_message_hdr := fnd_message.get || l_newline;
2191: -- WF_Notification.SetAttrText (l_notif_id, 'MESSAGE_HEADER', l_message_hdr);
2192:

Line 2189: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);

2185: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
2186:
2187: /* Set the Message Header */
2188: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
2189: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);
2190: l_message_hdr := fnd_message.get || l_newline;
2191: -- WF_Notification.SetAttrText (l_notif_id, 'MESSAGE_HEADER', l_message_hdr);
2192:
2193: /* Set the Message Body */

Line 2190: l_message_hdr := fnd_message.get || l_newline;

2186:
2187: /* Set the Message Header */
2188: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
2189: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);
2190: l_message_hdr := fnd_message.get || l_newline;
2191: -- WF_Notification.SetAttrText (l_notif_id, 'MESSAGE_HEADER', l_message_hdr);
2192:
2193: /* Set the Message Body */
2194: fnd_message.set_name('PV', 'PV_NTF_REJECTION_MESG');

Line 2194: fnd_message.set_name('PV', 'PV_NTF_REJECTION_MESG');

2190: l_message_hdr := fnd_message.get || l_newline;
2191: -- WF_Notification.SetAttrText (l_notif_id, 'MESSAGE_HEADER', l_message_hdr);
2192:
2193: /* Set the Message Body */
2194: fnd_message.set_name('PV', 'PV_NTF_REJECTION_MESG');
2195: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
2196: l_message_body := fnd_message.get || l_newline;
2197: l_message_body := l_message_body || l_newline;
2198:

Line 2195: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);

2191: -- WF_Notification.SetAttrText (l_notif_id, 'MESSAGE_HEADER', l_message_hdr);
2192:
2193: /* Set the Message Body */
2194: fnd_message.set_name('PV', 'PV_NTF_REJECTION_MESG');
2195: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
2196: l_message_body := fnd_message.get || l_newline;
2197: l_message_body := l_message_body || l_newline;
2198:
2199: /* Set the Partner Company Name */

Line 2196: l_message_body := fnd_message.get || l_newline;

2192:
2193: /* Set the Message Body */
2194: fnd_message.set_name('PV', 'PV_NTF_REJECTION_MESG');
2195: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
2196: l_message_body := fnd_message.get || l_newline;
2197: l_message_body := l_message_body || l_newline;
2198:
2199: /* Set the Partner Company Name */
2200: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');

Line 2200: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');

2196: l_message_body := fnd_message.get || l_newline;
2197: l_message_body := l_message_body || l_newline;
2198:
2199: /* Set the Partner Company Name */
2200: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');
2201: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
2202: l_message_body := l_message_body || fnd_message.get || l_newline;
2203:
2204: /* Set the requestor name */

Line 2201: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);

2197: l_message_body := l_message_body || l_newline;
2198:
2199: /* Set the Partner Company Name */
2200: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');
2201: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
2202: l_message_body := l_message_body || fnd_message.get || l_newline;
2203:
2204: /* Set the requestor name */
2205: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');

Line 2202: l_message_body := l_message_body || fnd_message.get || l_newline;

2198:
2199: /* Set the Partner Company Name */
2200: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');
2201: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
2202: l_message_body := l_message_body || fnd_message.get || l_newline;
2203:
2204: /* Set the requestor name */
2205: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
2206: fnd_message.set_token('PV_REQUESTOR_NM', rtrim(l_source_name));

Line 2205: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');

2201: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
2202: l_message_body := l_message_body || fnd_message.get || l_newline;
2203:
2204: /* Set the requestor name */
2205: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
2206: fnd_message.set_token('PV_REQUESTOR_NM', rtrim(l_source_name));
2207: l_message_body := l_message_body || fnd_message.get || l_newline;
2208:
2209: /* Set the request submission date */

Line 2206: fnd_message.set_token('PV_REQUESTOR_NM', rtrim(l_source_name));

2202: l_message_body := l_message_body || fnd_message.get || l_newline;
2203:
2204: /* Set the requestor name */
2205: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
2206: fnd_message.set_token('PV_REQUESTOR_NM', rtrim(l_source_name));
2207: l_message_body := l_message_body || fnd_message.get || l_newline;
2208:
2209: /* Set the request submission date */
2210: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');

Line 2207: l_message_body := l_message_body || fnd_message.get || l_newline;

2203:
2204: /* Set the requestor name */
2205: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
2206: fnd_message.set_token('PV_REQUESTOR_NM', rtrim(l_source_name));
2207: l_message_body := l_message_body || fnd_message.get || l_newline;
2208:
2209: /* Set the request submission date */
2210: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');
2211: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);

Line 2210: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');

2206: fnd_message.set_token('PV_REQUESTOR_NM', rtrim(l_source_name));
2207: l_message_body := l_message_body || fnd_message.get || l_newline;
2208:
2209: /* Set the request submission date */
2210: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');
2211: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);
2212: l_message_body := l_message_body || fnd_message.get || l_newline;
2213:
2214: /* Set the partner program name */

Line 2211: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);

2207: l_message_body := l_message_body || fnd_message.get || l_newline;
2208:
2209: /* Set the request submission date */
2210: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');
2211: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);
2212: l_message_body := l_message_body || fnd_message.get || l_newline;
2213:
2214: /* Set the partner program name */
2215: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');

Line 2212: l_message_body := l_message_body || fnd_message.get || l_newline;

2208:
2209: /* Set the request submission date */
2210: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');
2211: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);
2212: l_message_body := l_message_body || fnd_message.get || l_newline;
2213:
2214: /* Set the partner program name */
2215: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
2216: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);

Line 2215: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');

2211: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);
2212: l_message_body := l_message_body || fnd_message.get || l_newline;
2213:
2214: /* Set the partner program name */
2215: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
2216: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
2217: l_message_body := l_message_body || fnd_message.get || l_newline;
2218:
2219: /* Set the enrollment type */

Line 2216: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);

2212: l_message_body := l_message_body || fnd_message.get || l_newline;
2213:
2214: /* Set the partner program name */
2215: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
2216: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
2217: l_message_body := l_message_body || fnd_message.get || l_newline;
2218:
2219: /* Set the enrollment type */
2220: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');

Line 2217: l_message_body := l_message_body || fnd_message.get || l_newline;

2213:
2214: /* Set the partner program name */
2215: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
2216: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
2217: l_message_body := l_message_body || fnd_message.get || l_newline;
2218:
2219: /* Set the enrollment type */
2220: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');
2221: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);

Line 2220: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');

2216: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
2217: l_message_body := l_message_body || fnd_message.get || l_newline;
2218:
2219: /* Set the enrollment type */
2220: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');
2221: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);
2222: l_message_body := l_message_body || fnd_message.get|| l_newline;
2223:
2224: /* Get the values for all message attributes from the message list for Message Footer */

Line 2221: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);

2217: l_message_body := l_message_body || fnd_message.get || l_newline;
2218:
2219: /* Set the enrollment type */
2220: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');
2221: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);
2222: l_message_body := l_message_body || fnd_message.get|| l_newline;
2223:
2224: /* Get the values for all message attributes from the message list for Message Footer */
2225: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;

Line 2222: l_message_body := l_message_body || fnd_message.get|| l_newline;

2218:
2219: /* Set the enrollment type */
2220: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');
2221: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);
2222: l_message_body := l_message_body || fnd_message.get|| l_newline;
2223:
2224: /* Get the values for all message attributes from the message list for Message Footer */
2225: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
2226: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;

Line 2225: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;

2221: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);
2222: l_message_body := l_message_body || fnd_message.get|| l_newline;
2223:
2224: /* Get the values for all message attributes from the message list for Message Footer */
2225: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
2226: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
2227: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
2228:
2229: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);

Line 2226: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;

2222: l_message_body := l_message_body || fnd_message.get|| l_newline;
2223:
2224: /* Get the values for all message attributes from the message list for Message Footer */
2225: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
2226: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
2227: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
2228:
2229: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
2230: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);

Line 2227: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;

2223:
2224: /* Get the values for all message attributes from the message list for Message Footer */
2225: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
2226: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
2227: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
2228:
2229: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
2230: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
2231: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);

Line 2248: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');

2244: x_return_status => x_return_status ,
2245: x_pgp_notif_rec => l_pgp_notif_rec );
2246:
2247: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2248: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
2249: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
2250: FND_MSG_PUB.Add;
2251: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2252: RAISE FND_API.G_EXC_ERROR;

Line 2249: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);

2245: x_pgp_notif_rec => l_pgp_notif_rec );
2246:
2247: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2248: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
2249: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
2250: FND_MSG_PUB.Add;
2251: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2252: RAISE FND_API.G_EXC_ERROR;
2253: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2272: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');

2268: p_pgp_notif_rec => l_pgp_notif_rec,
2269: x_party_notification_id => x_party_notification_id );
2270:
2271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2272: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
2273: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
2274: FND_MSG_PUB.Add;
2275: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2276: RAISE FND_API.G_EXC_ERROR;

Line 2273: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);

2269: x_party_notification_id => x_party_notification_id );
2270:
2271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2272: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
2273: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
2274: FND_MSG_PUB.Add;
2275: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2276: RAISE FND_API.G_EXC_ERROR;
2277: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2308: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');

2304: x_msg_data => x_msg_data );
2305:
2306: /* if any error happens rollback only this row, and proceed to next record. otherwise commit */
2307: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2308: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');
2309: FND_MESSAGE.SET_TOKEN('ID',p_enrl_request_id);
2310: FND_MSG_PUB.Add;
2311: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2312: RAISE FND_API.G_EXC_ERROR;

Line 2309: FND_MESSAGE.SET_TOKEN('ID',p_enrl_request_id);

2305:
2306: /* if any error happens rollback only this row, and proceed to next record. otherwise commit */
2307: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2308: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');
2309: FND_MESSAGE.SET_TOKEN('ID',p_enrl_request_id);
2310: FND_MSG_PUB.Add;
2311: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2312: RAISE FND_API.G_EXC_ERROR;
2313: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2520: FND_MESSAGE.SET_NAME('PV', 'PV_ENRL_REQ_NOT_EXIST');

2516: x_prtnr_vndr_relship_id => l_prtnr_vndr_relship_id,
2517: x_return_status => x_return_status);
2518:
2519: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2520: FND_MESSAGE.SET_NAME('PV', 'PV_ENRL_REQ_NOT_EXIST');
2521: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);
2522: FND_MSG_PUB.Add;
2523: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2524: RAISE FND_API.G_EXC_ERROR;

Line 2521: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);

2517: x_return_status => x_return_status);
2518:
2519: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2520: FND_MESSAGE.SET_NAME('PV', 'PV_ENRL_REQ_NOT_EXIST');
2521: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);
2522: FND_MSG_PUB.Add;
2523: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2524: RAISE FND_API.G_EXC_ERROR;
2525: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2550: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');

2546: x_return_status => x_return_status);
2547:
2548: /* Check the Procedure's x_return_status */
2549: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2550: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
2551: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);
2552: FND_MSG_PUB.Add;
2553: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2554: RAISE FND_API.G_EXC_ERROR;

Line 2551: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);

2547:
2548: /* Check the Procedure's x_return_status */
2549: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2550: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
2551: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_enrl_request_id);
2552: FND_MSG_PUB.Add;
2553: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2554: RAISE FND_API.G_EXC_ERROR;
2555: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2570: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');

2566: x_return_status => x_return_status);
2567:
2568: /* Check the Procedure's x_return_status */
2569: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2570: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
2571: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);
2572: FND_MSG_PUB.Add;
2573: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2574: RAISE FND_API.G_EXC_ERROR;

Line 2571: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);

2567:
2568: /* Check the Procedure's x_return_status */
2569: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2570: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
2571: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);
2572: FND_MSG_PUB.Add;
2573: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2574: RAISE FND_API.G_EXC_ERROR;
2575: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2589: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');

2585: x_return_status => x_return_status ) ;
2586:
2587: /* Check the Procedure's x_return_status */
2588: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2589: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');
2590: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);
2591: FND_MSG_PUB.Add;
2592: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2593: RAISE FND_API.G_EXC_ERROR;

Line 2590: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);

2586:
2587: /* Check the Procedure's x_return_status */
2588: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2589: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');
2590: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);
2591: FND_MSG_PUB.Add;
2592: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2593: RAISE FND_API.G_EXC_ERROR;
2594: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2616: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');

2612: );
2613:
2614: /* Check the Procedure's x_return_status */
2615: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2616: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');
2617: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);
2618: FND_MSG_PUB.Add;
2619: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2620: RAISE FND_API.G_EXC_ERROR;

Line 2617: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);

2613:
2614: /* Check the Procedure's x_return_status */
2615: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2616: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');
2617: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);
2618: FND_MSG_PUB.Add;
2619: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2620: RAISE FND_API.G_EXC_ERROR;
2621: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2636: fnd_message.set_name('PV', 'PV_NTF_CONTRACT_SUBJECT');

2632: /* Set all the entity attributes by replacing the supplied parameters. */
2633: -- WF_Notification.SetAttrText(l_notif_id,'DOCUMENT_ID', 'PVXNUTIL:'||l_notif_id);
2634:
2635: /* Set the subject line */
2636: fnd_message.set_name('PV', 'PV_NTF_CONTRACT_SUBJECT');
2637: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
2638: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
2639:
2640: /* Set the Message Header */

Line 2637: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);

2633: -- WF_Notification.SetAttrText(l_notif_id,'DOCUMENT_ID', 'PVXNUTIL:'||l_notif_id);
2634:
2635: /* Set the subject line */
2636: fnd_message.set_name('PV', 'PV_NTF_CONTRACT_SUBJECT');
2637: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
2638: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
2639:
2640: /* Set the Message Header */
2641: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');

Line 2638: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);

2634:
2635: /* Set the subject line */
2636: fnd_message.set_name('PV', 'PV_NTF_CONTRACT_SUBJECT');
2637: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
2638: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
2639:
2640: /* Set the Message Header */
2641: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
2642: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);

Line 2641: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');

2637: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
2638: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
2639:
2640: /* Set the Message Header */
2641: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
2642: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);
2643: l_message_hdr := fnd_message.get || l_newline;
2644:
2645: /* Set the Vendor Name */

Line 2642: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);

2638: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
2639:
2640: /* Set the Message Header */
2641: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
2642: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);
2643: l_message_hdr := fnd_message.get || l_newline;
2644:
2645: /* Set the Vendor Name */
2646: /*

Line 2643: l_message_hdr := fnd_message.get || l_newline;

2639:
2640: /* Set the Message Header */
2641: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
2642: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);
2643: l_message_hdr := fnd_message.get || l_newline;
2644:
2645: /* Set the Vendor Name */
2646: /*
2647: fnd_message.set_name('PV', 'PV_VENDOR_NM');

Line 2647: fnd_message.set_name('PV', 'PV_VENDOR_NM');

2643: l_message_hdr := fnd_message.get || l_newline;
2644:
2645: /* Set the Vendor Name */
2646: /*
2647: fnd_message.set_name('PV', 'PV_VENDOR_NM');
2648: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
2649: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
2650: */
2651:

Line 2648: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);

2644:
2645: /* Set the Vendor Name */
2646: /*
2647: fnd_message.set_name('PV', 'PV_VENDOR_NM');
2648: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
2649: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
2650: */
2651:
2652: l_message_body := fnd_message.get_string('PV', 'PV_NTF_CONTRACT_MESG')|| l_newline;

Line 2649: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);

2645: /* Set the Vendor Name */
2646: /*
2647: fnd_message.set_name('PV', 'PV_VENDOR_NM');
2648: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
2649: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
2650: */
2651:
2652: l_message_body := fnd_message.get_string('PV', 'PV_NTF_CONTRACT_MESG')|| l_newline;
2653: l_message_body := l_message_body || l_newline;

Line 2652: l_message_body := fnd_message.get_string('PV', 'PV_NTF_CONTRACT_MESG')|| l_newline;

2648: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
2649: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
2650: */
2651:
2652: l_message_body := fnd_message.get_string('PV', 'PV_NTF_CONTRACT_MESG')|| l_newline;
2653: l_message_body := l_message_body || l_newline;
2654:
2655: /* Set the Partner Company Name */
2656: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');

Line 2656: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');

2652: l_message_body := fnd_message.get_string('PV', 'PV_NTF_CONTRACT_MESG')|| l_newline;
2653: l_message_body := l_message_body || l_newline;
2654:
2655: /* Set the Partner Company Name */
2656: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');
2657: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
2658: l_message_body := l_message_body || fnd_message.get || l_newline;
2659:
2660: /* Set the Requestor Name */

Line 2657: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);

2653: l_message_body := l_message_body || l_newline;
2654:
2655: /* Set the Partner Company Name */
2656: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');
2657: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
2658: l_message_body := l_message_body || fnd_message.get || l_newline;
2659:
2660: /* Set the Requestor Name */
2661: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');

Line 2658: l_message_body := l_message_body || fnd_message.get || l_newline;

2654:
2655: /* Set the Partner Company Name */
2656: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');
2657: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
2658: l_message_body := l_message_body || fnd_message.get || l_newline;
2659:
2660: /* Set the Requestor Name */
2661: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
2662: fnd_message.set_token('PV_REQUESTOR_NM', l_source_name);

Line 2661: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');

2657: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
2658: l_message_body := l_message_body || fnd_message.get || l_newline;
2659:
2660: /* Set the Requestor Name */
2661: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
2662: fnd_message.set_token('PV_REQUESTOR_NM', l_source_name);
2663: l_message_body := l_message_body || fnd_message.get || l_newline;
2664:
2665: /* Set the request submission date */

Line 2662: fnd_message.set_token('PV_REQUESTOR_NM', l_source_name);

2658: l_message_body := l_message_body || fnd_message.get || l_newline;
2659:
2660: /* Set the Requestor Name */
2661: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
2662: fnd_message.set_token('PV_REQUESTOR_NM', l_source_name);
2663: l_message_body := l_message_body || fnd_message.get || l_newline;
2664:
2665: /* Set the request submission date */
2666: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');

Line 2663: l_message_body := l_message_body || fnd_message.get || l_newline;

2659:
2660: /* Set the Requestor Name */
2661: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
2662: fnd_message.set_token('PV_REQUESTOR_NM', l_source_name);
2663: l_message_body := l_message_body || fnd_message.get || l_newline;
2664:
2665: /* Set the request submission date */
2666: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');
2667: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);

Line 2666: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');

2662: fnd_message.set_token('PV_REQUESTOR_NM', l_source_name);
2663: l_message_body := l_message_body || fnd_message.get || l_newline;
2664:
2665: /* Set the request submission date */
2666: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');
2667: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);
2668: l_message_body := l_message_body || fnd_message.get || l_newline;
2669:
2670: /* Set the Partner Program Name */

Line 2667: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);

2663: l_message_body := l_message_body || fnd_message.get || l_newline;
2664:
2665: /* Set the request submission date */
2666: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');
2667: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);
2668: l_message_body := l_message_body || fnd_message.get || l_newline;
2669:
2670: /* Set the Partner Program Name */
2671: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');

Line 2668: l_message_body := l_message_body || fnd_message.get || l_newline;

2664:
2665: /* Set the request submission date */
2666: fnd_message.set_name('PV', 'PV_NTF_REQ_SUBMIT_DT');
2667: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);
2668: l_message_body := l_message_body || fnd_message.get || l_newline;
2669:
2670: /* Set the Partner Program Name */
2671: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
2672: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);

Line 2671: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');

2667: fnd_message.set_token('PV_REQ_SUBMIT_DT', l_req_submission_date);
2668: l_message_body := l_message_body || fnd_message.get || l_newline;
2669:
2670: /* Set the Partner Program Name */
2671: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
2672: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
2673: l_message_body := l_message_body || fnd_message.get || l_newline;
2674:
2675: /* Set the Enrollment Type */

Line 2672: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);

2668: l_message_body := l_message_body || fnd_message.get || l_newline;
2669:
2670: /* Set the Partner Program Name */
2671: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
2672: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
2673: l_message_body := l_message_body || fnd_message.get || l_newline;
2674:
2675: /* Set the Enrollment Type */
2676: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');

Line 2673: l_message_body := l_message_body || fnd_message.get || l_newline;

2669:
2670: /* Set the Partner Program Name */
2671: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
2672: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
2673: l_message_body := l_message_body || fnd_message.get || l_newline;
2674:
2675: /* Set the Enrollment Type */
2676: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');
2677: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);

Line 2676: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');

2672: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
2673: l_message_body := l_message_body || fnd_message.get || l_newline;
2674:
2675: /* Set the Enrollment Type */
2676: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');
2677: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);
2678: l_message_body := l_message_body || fnd_message.get || l_newline;
2679: l_message_body := l_message_body || l_newline;
2680:

Line 2677: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);

2673: l_message_body := l_message_body || fnd_message.get || l_newline;
2674:
2675: /* Set the Enrollment Type */
2676: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');
2677: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);
2678: l_message_body := l_message_body || fnd_message.get || l_newline;
2679: l_message_body := l_message_body || l_newline;
2680:
2681: /* Get the values for all message attributes from the message list */

Line 2678: l_message_body := l_message_body || fnd_message.get || l_newline;

2674:
2675: /* Set the Enrollment Type */
2676: fnd_message.set_name('PV', 'PV_NTF_ENRL_TYPE');
2677: fnd_message.set_token('PV_ENRL_TYPE', l_enrollment_type);
2678: l_message_body := l_message_body || fnd_message.get || l_newline;
2679: l_message_body := l_message_body || l_newline;
2680:
2681: /* Get the values for all message attributes from the message list */
2682: l_message_body := l_message_body || fnd_message.get_string('PV', 'PV_NTF_CONTRACT_ADDL_MESG')|| l_newline;

Line 2682: l_message_body := l_message_body || fnd_message.get_string('PV', 'PV_NTF_CONTRACT_ADDL_MESG')|| l_newline;

2678: l_message_body := l_message_body || fnd_message.get || l_newline;
2679: l_message_body := l_message_body || l_newline;
2680:
2681: /* Get the values for all message attributes from the message list */
2682: l_message_body := l_message_body || fnd_message.get_string('PV', 'PV_NTF_CONTRACT_ADDL_MESG')|| l_newline;
2683:
2684: /* Get the values for all message attributes from the message list for Message Footer */
2685: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
2686: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;

Line 2685: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;

2681: /* Get the values for all message attributes from the message list */
2682: l_message_body := l_message_body || fnd_message.get_string('PV', 'PV_NTF_CONTRACT_ADDL_MESG')|| l_newline;
2683:
2684: /* Get the values for all message attributes from the message list for Message Footer */
2685: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
2686: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
2687: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
2688:
2689: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);

Line 2686: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;

2682: l_message_body := l_message_body || fnd_message.get_string('PV', 'PV_NTF_CONTRACT_ADDL_MESG')|| l_newline;
2683:
2684: /* Get the values for all message attributes from the message list for Message Footer */
2685: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
2686: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
2687: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
2688:
2689: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
2690: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);

Line 2687: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;

2683:
2684: /* Get the values for all message attributes from the message list for Message Footer */
2685: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
2686: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
2687: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
2688:
2689: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
2690: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
2691: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);

Line 2709: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');

2705: x_pgp_notif_rec => l_pgp_notif_rec );
2706:
2707: /* Check the Procedure's x_return_status */
2708: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2709: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
2710: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
2711: FND_MSG_PUB.Add;
2712: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2713: RAISE FND_API.G_EXC_ERROR;

Line 2710: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);

2706:
2707: /* Check the Procedure's x_return_status */
2708: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2709: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
2710: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
2711: FND_MSG_PUB.Add;
2712: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2713: RAISE FND_API.G_EXC_ERROR;
2714: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2734: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');

2730: x_party_notification_id => x_party_notification_id );
2731:
2732: /* Check the Procedure's x_return_status */
2733: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2734: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
2735: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
2736: FND_MSG_PUB.Add;
2737: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2738: RAISE FND_API.G_EXC_ERROR;

Line 2735: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);

2731:
2732: /* Check the Procedure's x_return_status */
2733: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2734: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
2735: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
2736: FND_MSG_PUB.Add;
2737: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2738: RAISE FND_API.G_EXC_ERROR;
2739: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2770: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');

2766: x_msg_data => x_msg_data );
2767:
2768: /* Check for x_return_status */
2769: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2770: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');
2771: FND_MESSAGE.SET_TOKEN('ID',p_enrl_request_id);
2772: FND_MSG_PUB.Add;
2773: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2774: RAISE FND_API.G_EXC_ERROR;

Line 2771: FND_MESSAGE.SET_TOKEN('ID',p_enrl_request_id);

2767:
2768: /* Check for x_return_status */
2769: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2770: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');
2771: FND_MESSAGE.SET_TOKEN('ID',p_enrl_request_id);
2772: FND_MSG_PUB.Add;
2773: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2774: RAISE FND_API.G_EXC_ERROR;
2775: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2989: FND_MESSAGE.SET_NAME('PV','PV_MBRSHIP_NOT_EXIST');

2985: x_return_status => x_return_status);
2986:
2987: /* Check Procedure's x_return_status */
2988: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2989: FND_MESSAGE.SET_NAME('PV','PV_MBRSHIP_NOT_EXIST');
2990: FND_MESSAGE.SET_TOKEN('MEMBERSHIP_ID',p_membership_id);
2991: FND_MSG_PUB.Add;
2992: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2993: RAISE FND_API.G_EXC_ERROR;

Line 2990: FND_MESSAGE.SET_TOKEN('MEMBERSHIP_ID',p_membership_id);

2986:
2987: /* Check Procedure's x_return_status */
2988: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2989: FND_MESSAGE.SET_NAME('PV','PV_MBRSHIP_NOT_EXIST');
2990: FND_MESSAGE.SET_TOKEN('MEMBERSHIP_ID',p_membership_id);
2991: FND_MSG_PUB.Add;
2992: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2993: RAISE FND_API.G_EXC_ERROR;
2994: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3019: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');

3015: x_return_status => x_return_status);
3016:
3017: /* Check for Procedure's x_return_status */
3018: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3019: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
3020: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',l_enrl_request_id);
3021: FND_MSG_PUB.Add;
3022: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3023: RAISE FND_API.G_EXC_ERROR;

Line 3020: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',l_enrl_request_id);

3016:
3017: /* Check for Procedure's x_return_status */
3018: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3019: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
3020: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',l_enrl_request_id);
3021: FND_MSG_PUB.Add;
3022: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3023: RAISE FND_API.G_EXC_ERROR;
3024: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3063: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');

3059: x_return_status => x_return_status);
3060:
3061: /* Check the Procedure's x_return_status */
3062: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3063: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
3064: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);
3065: FND_MSG_PUB.Add;
3066: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3067: RAISE FND_API.G_EXC_ERROR;

Line 3064: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);

3060:
3061: /* Check the Procedure's x_return_status */
3062: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3063: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
3064: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);
3065: FND_MSG_PUB.Add;
3066: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3067: RAISE FND_API.G_EXC_ERROR;
3068: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3082: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');

3078: x_return_status => x_return_status ) ;
3079:
3080: /* Check the Procedure's x_return_status */
3081: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3082: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');
3083: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);
3084: FND_MSG_PUB.Add;
3085: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3086: RAISE FND_API.G_EXC_ERROR;

Line 3083: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);

3079:
3080: /* Check the Procedure's x_return_status */
3081: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3082: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');
3083: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);
3084: FND_MSG_PUB.Add;
3085: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3086: RAISE FND_API.G_EXC_ERROR;
3087: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3110: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');

3106: );
3107:
3108: /* Check the Procedure's x_return_status */
3109: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3110: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');
3111: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);
3112: FND_MSG_PUB.Add;
3113: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3114: RAISE FND_API.G_EXC_ERROR;

Line 3111: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);

3107:
3108: /* Check the Procedure's x_return_status */
3109: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3110: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');
3111: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);
3112: FND_MSG_PUB.Add;
3113: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3114: RAISE FND_API.G_EXC_ERROR;
3115: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3129: fnd_message.set_name('PV', 'PV_NTF_EXPIRY_SUBJECT');

3125:
3126: WF_Notification.SetAttrText(l_notif_id,'NOTIF_DOC_ID', 'PVXNUTIL:'||l_notif_id); -- passing the doc id
3127:
3128: /* Set the subject line */
3129: fnd_message.set_name('PV', 'PV_NTF_EXPIRY_SUBJECT');
3130: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
3131: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
3132:
3133: /* Set the Message Header */

Line 3130: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);

3126: WF_Notification.SetAttrText(l_notif_id,'NOTIF_DOC_ID', 'PVXNUTIL:'||l_notif_id); -- passing the doc id
3127:
3128: /* Set the subject line */
3129: fnd_message.set_name('PV', 'PV_NTF_EXPIRY_SUBJECT');
3130: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
3131: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
3132:
3133: /* Set the Message Header */
3134: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');

Line 3131: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);

3127:
3128: /* Set the subject line */
3129: fnd_message.set_name('PV', 'PV_NTF_EXPIRY_SUBJECT');
3130: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
3131: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
3132:
3133: /* Set the Message Header */
3134: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
3135: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);

Line 3134: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');

3130: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
3131: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
3132:
3133: /* Set the Message Header */
3134: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
3135: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);
3136: l_message_hdr := fnd_message.get || l_newline;
3137:
3138: /* Set all the entity attributes by replacing the supplied parameters. */

Line 3135: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);

3131: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
3132:
3133: /* Set the Message Header */
3134: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
3135: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);
3136: l_message_hdr := fnd_message.get || l_newline;
3137:
3138: /* Set all the entity attributes by replacing the supplied parameters. */
3139:

Line 3136: l_message_hdr := fnd_message.get || l_newline;

3132:
3133: /* Set the Message Header */
3134: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
3135: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);
3136: l_message_hdr := fnd_message.get || l_newline;
3137:
3138: /* Set all the entity attributes by replacing the supplied parameters. */
3139:
3140: /* Set the Vendor Name */

Line 3142: fnd_message.set_name('PV', 'PV_VENDOR_NM');

3138: /* Set all the entity attributes by replacing the supplied parameters. */
3139:
3140: /* Set the Vendor Name */
3141: /*
3142: fnd_message.set_name('PV', 'PV_VENDOR_NM');
3143: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
3144: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
3145: */
3146:

Line 3143: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);

3139:
3140: /* Set the Vendor Name */
3141: /*
3142: fnd_message.set_name('PV', 'PV_VENDOR_NM');
3143: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
3144: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
3145: */
3146:
3147: l_message_body := fnd_message.get_string('PV', 'PV_NTF_EXPIRY_MESG')|| l_newline;

Line 3144: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);

3140: /* Set the Vendor Name */
3141: /*
3142: fnd_message.set_name('PV', 'PV_VENDOR_NM');
3143: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
3144: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
3145: */
3146:
3147: l_message_body := fnd_message.get_string('PV', 'PV_NTF_EXPIRY_MESG')|| l_newline;
3148: l_message_body := l_message_body || l_newline;

Line 3147: l_message_body := fnd_message.get_string('PV', 'PV_NTF_EXPIRY_MESG')|| l_newline;

3143: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
3144: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
3145: */
3146:
3147: l_message_body := fnd_message.get_string('PV', 'PV_NTF_EXPIRY_MESG')|| l_newline;
3148: l_message_body := l_message_body || l_newline;
3149:
3150: /* Set the Partner Company Name */
3151: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');

Line 3151: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');

3147: l_message_body := fnd_message.get_string('PV', 'PV_NTF_EXPIRY_MESG')|| l_newline;
3148: l_message_body := l_message_body || l_newline;
3149:
3150: /* Set the Partner Company Name */
3151: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');
3152: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
3153: l_message_body := l_message_body || fnd_message.get || l_newline;
3154:
3155: /* Set the Requestor Name */

Line 3152: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);

3148: l_message_body := l_message_body || l_newline;
3149:
3150: /* Set the Partner Company Name */
3151: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');
3152: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
3153: l_message_body := l_message_body || fnd_message.get || l_newline;
3154:
3155: /* Set the Requestor Name */
3156: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');

Line 3153: l_message_body := l_message_body || fnd_message.get || l_newline;

3149:
3150: /* Set the Partner Company Name */
3151: fnd_message.set_name('PV', 'PV_NTF_PARTNER_NM');
3152: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
3153: l_message_body := l_message_body || fnd_message.get || l_newline;
3154:
3155: /* Set the Requestor Name */
3156: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
3157: fnd_message.set_token('PV_REQUESTOR_NM', l_source_name);

Line 3156: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');

3152: fnd_message.set_token('PV_PARTNER_NM', l_partner_comp_name);
3153: l_message_body := l_message_body || fnd_message.get || l_newline;
3154:
3155: /* Set the Requestor Name */
3156: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
3157: fnd_message.set_token('PV_REQUESTOR_NM', l_source_name);
3158: l_message_body := l_message_body || fnd_message.get || l_newline;
3159:
3160: /* Set the Partner Program Name */

Line 3157: fnd_message.set_token('PV_REQUESTOR_NM', l_source_name);

3153: l_message_body := l_message_body || fnd_message.get || l_newline;
3154:
3155: /* Set the Requestor Name */
3156: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
3157: fnd_message.set_token('PV_REQUESTOR_NM', l_source_name);
3158: l_message_body := l_message_body || fnd_message.get || l_newline;
3159:
3160: /* Set the Partner Program Name */
3161: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');

Line 3158: l_message_body := l_message_body || fnd_message.get || l_newline;

3154:
3155: /* Set the Requestor Name */
3156: fnd_message.set_name('PV', 'PV_NTF_REQUESTOR_NM');
3157: fnd_message.set_token('PV_REQUESTOR_NM', l_source_name);
3158: l_message_body := l_message_body || fnd_message.get || l_newline;
3159:
3160: /* Set the Partner Program Name */
3161: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
3162: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);

Line 3161: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');

3157: fnd_message.set_token('PV_REQUESTOR_NM', l_source_name);
3158: l_message_body := l_message_body || fnd_message.get || l_newline;
3159:
3160: /* Set the Partner Program Name */
3161: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
3162: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
3163: l_message_body := l_message_body || fnd_message.get || l_newline;
3164:
3165: /* Set the Enrollment Start Date */

Line 3162: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);

3158: l_message_body := l_message_body || fnd_message.get || l_newline;
3159:
3160: /* Set the Partner Program Name */
3161: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
3162: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
3163: l_message_body := l_message_body || fnd_message.get || l_newline;
3164:
3165: /* Set the Enrollment Start Date */
3166: fnd_message.set_name('PV', 'PV_NTF_ENRL_START_DT');

Line 3163: l_message_body := l_message_body || fnd_message.get || l_newline;

3159:
3160: /* Set the Partner Program Name */
3161: fnd_message.set_name('PV', 'PV_NTF_PARTNER_PRGM');
3162: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
3163: l_message_body := l_message_body || fnd_message.get || l_newline;
3164:
3165: /* Set the Enrollment Start Date */
3166: fnd_message.set_name('PV', 'PV_NTF_ENRL_START_DT');
3167: fnd_message.set_token('PV_ENRL_START_DT', l_enrollment_start_date);

Line 3166: fnd_message.set_name('PV', 'PV_NTF_ENRL_START_DT');

3162: fnd_message.set_token('PV_PARTNER_PRGM', l_partner_program);
3163: l_message_body := l_message_body || fnd_message.get || l_newline;
3164:
3165: /* Set the Enrollment Start Date */
3166: fnd_message.set_name('PV', 'PV_NTF_ENRL_START_DT');
3167: fnd_message.set_token('PV_ENRL_START_DT', l_enrollment_start_date);
3168: l_message_body := l_message_body || fnd_message.get || l_newline;
3169:
3170: /* Set the Enrollment End Date */

Line 3167: fnd_message.set_token('PV_ENRL_START_DT', l_enrollment_start_date);

3163: l_message_body := l_message_body || fnd_message.get || l_newline;
3164:
3165: /* Set the Enrollment Start Date */
3166: fnd_message.set_name('PV', 'PV_NTF_ENRL_START_DT');
3167: fnd_message.set_token('PV_ENRL_START_DT', l_enrollment_start_date);
3168: l_message_body := l_message_body || fnd_message.get || l_newline;
3169:
3170: /* Set the Enrollment End Date */
3171: fnd_message.set_name('PV', 'PV_NTF_ENRL_END_DT');

Line 3168: l_message_body := l_message_body || fnd_message.get || l_newline;

3164:
3165: /* Set the Enrollment Start Date */
3166: fnd_message.set_name('PV', 'PV_NTF_ENRL_START_DT');
3167: fnd_message.set_token('PV_ENRL_START_DT', l_enrollment_start_date);
3168: l_message_body := l_message_body || fnd_message.get || l_newline;
3169:
3170: /* Set the Enrollment End Date */
3171: fnd_message.set_name('PV', 'PV_NTF_ENRL_END_DT');
3172: fnd_message.set_token('PV_ENRL_END_DT', l_enrollment_end_date);

Line 3171: fnd_message.set_name('PV', 'PV_NTF_ENRL_END_DT');

3167: fnd_message.set_token('PV_ENRL_START_DT', l_enrollment_start_date);
3168: l_message_body := l_message_body || fnd_message.get || l_newline;
3169:
3170: /* Set the Enrollment End Date */
3171: fnd_message.set_name('PV', 'PV_NTF_ENRL_END_DT');
3172: fnd_message.set_token('PV_ENRL_END_DT', l_enrollment_end_date);
3173: l_message_body := l_message_body || fnd_message.get || l_newline;
3174:
3175: /* Set the Expiry in # of days */

Line 3172: fnd_message.set_token('PV_ENRL_END_DT', l_enrollment_end_date);

3168: l_message_body := l_message_body || fnd_message.get || l_newline;
3169:
3170: /* Set the Enrollment End Date */
3171: fnd_message.set_name('PV', 'PV_NTF_ENRL_END_DT');
3172: fnd_message.set_token('PV_ENRL_END_DT', l_enrollment_end_date);
3173: l_message_body := l_message_body || fnd_message.get || l_newline;
3174:
3175: /* Set the Expiry in # of days */
3176: fnd_message.set_name('PV', 'PV_NTF_EXPIRY_IN_DAYS');

Line 3173: l_message_body := l_message_body || fnd_message.get || l_newline;

3169:
3170: /* Set the Enrollment End Date */
3171: fnd_message.set_name('PV', 'PV_NTF_ENRL_END_DT');
3172: fnd_message.set_token('PV_ENRL_END_DT', l_enrollment_end_date);
3173: l_message_body := l_message_body || fnd_message.get || l_newline;
3174:
3175: /* Set the Expiry in # of days */
3176: fnd_message.set_name('PV', 'PV_NTF_EXPIRY_IN_DAYS');
3177: --fnd_message.set_token('PV_ENRL_EXPIRY_IN_DAYS', trunc(to_date(l_enrollment_end_date) - sysdate) );

Line 3176: fnd_message.set_name('PV', 'PV_NTF_EXPIRY_IN_DAYS');

3172: fnd_message.set_token('PV_ENRL_END_DT', l_enrollment_end_date);
3173: l_message_body := l_message_body || fnd_message.get || l_newline;
3174:
3175: /* Set the Expiry in # of days */
3176: fnd_message.set_name('PV', 'PV_NTF_EXPIRY_IN_DAYS');
3177: --fnd_message.set_token('PV_ENRL_EXPIRY_IN_DAYS', trunc(to_date(l_enrollment_end_date) - sysdate) );
3178: fnd_message.set_token('PV_ENRL_EXPIRY_IN_DAYS', trunc( to_date( l_enrollment_end_date,'DD-MM-YY' ) - to_date( sysdate,'DD-MM-YY') ) );
3179: l_message_body := l_message_body || fnd_message.get || l_newline;
3180:

Line 3177: --fnd_message.set_token('PV_ENRL_EXPIRY_IN_DAYS', trunc(to_date(l_enrollment_end_date) - sysdate) );

3173: l_message_body := l_message_body || fnd_message.get || l_newline;
3174:
3175: /* Set the Expiry in # of days */
3176: fnd_message.set_name('PV', 'PV_NTF_EXPIRY_IN_DAYS');
3177: --fnd_message.set_token('PV_ENRL_EXPIRY_IN_DAYS', trunc(to_date(l_enrollment_end_date) - sysdate) );
3178: fnd_message.set_token('PV_ENRL_EXPIRY_IN_DAYS', trunc( to_date( l_enrollment_end_date,'DD-MM-YY' ) - to_date( sysdate,'DD-MM-YY') ) );
3179: l_message_body := l_message_body || fnd_message.get || l_newline;
3180:
3181: /* Get the values for all message attributes from the message list */

Line 3178: fnd_message.set_token('PV_ENRL_EXPIRY_IN_DAYS', trunc( to_date( l_enrollment_end_date,'DD-MM-YY' ) - to_date( sysdate,'DD-MM-YY') ) );

3174:
3175: /* Set the Expiry in # of days */
3176: fnd_message.set_name('PV', 'PV_NTF_EXPIRY_IN_DAYS');
3177: --fnd_message.set_token('PV_ENRL_EXPIRY_IN_DAYS', trunc(to_date(l_enrollment_end_date) - sysdate) );
3178: fnd_message.set_token('PV_ENRL_EXPIRY_IN_DAYS', trunc( to_date( l_enrollment_end_date,'DD-MM-YY' ) - to_date( sysdate,'DD-MM-YY') ) );
3179: l_message_body := l_message_body || fnd_message.get || l_newline;
3180:
3181: /* Get the values for all message attributes from the message list */
3182: /* Set the Log-in portal line */

Line 3179: l_message_body := l_message_body || fnd_message.get || l_newline;

3175: /* Set the Expiry in # of days */
3176: fnd_message.set_name('PV', 'PV_NTF_EXPIRY_IN_DAYS');
3177: --fnd_message.set_token('PV_ENRL_EXPIRY_IN_DAYS', trunc(to_date(l_enrollment_end_date) - sysdate) );
3178: fnd_message.set_token('PV_ENRL_EXPIRY_IN_DAYS', trunc( to_date( l_enrollment_end_date,'DD-MM-YY' ) - to_date( sysdate,'DD-MM-YY') ) );
3179: l_message_body := l_message_body || fnd_message.get || l_newline;
3180:
3181: /* Get the values for all message attributes from the message list */
3182: /* Set the Log-in portal line */
3183: /* l_prtner_portal_url := icx_sec.createRFURL(

Line 3193: fnd_message.set_name('PV', 'PV_NTF_EXPIRY_ADDL_MESG');

3189: /* Set the Log-in portal line */
3190: l_login_url := FND_PROFILE.VALUE('PV_WORKFLOW_RESPOND_URL');
3191: l_prtner_portal_url := ''|| l_partner_program || '';
3192:
3193: fnd_message.set_name('PV', 'PV_NTF_EXPIRY_ADDL_MESG');
3194: fnd_message.set_token('PV_PARTNER_PORTAL_URL', l_prtner_portal_url);
3195: l_message_body := l_message_body ||fnd_message.get || l_newline;
3196:
3197: /* Get the values for all message attributes from the message list for Message Footer */

Line 3194: fnd_message.set_token('PV_PARTNER_PORTAL_URL', l_prtner_portal_url);

3190: l_login_url := FND_PROFILE.VALUE('PV_WORKFLOW_RESPOND_URL');
3191: l_prtner_portal_url := ''|| l_partner_program || '';
3192:
3193: fnd_message.set_name('PV', 'PV_NTF_EXPIRY_ADDL_MESG');
3194: fnd_message.set_token('PV_PARTNER_PORTAL_URL', l_prtner_portal_url);
3195: l_message_body := l_message_body ||fnd_message.get || l_newline;
3196:
3197: /* Get the values for all message attributes from the message list for Message Footer */
3198: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;

Line 3195: l_message_body := l_message_body ||fnd_message.get || l_newline;

3191: l_prtner_portal_url := ''|| l_partner_program || '';
3192:
3193: fnd_message.set_name('PV', 'PV_NTF_EXPIRY_ADDL_MESG');
3194: fnd_message.set_token('PV_PARTNER_PORTAL_URL', l_prtner_portal_url);
3195: l_message_body := l_message_body ||fnd_message.get || l_newline;
3196:
3197: /* Get the values for all message attributes from the message list for Message Footer */
3198: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
3199: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;

Line 3198: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;

3194: fnd_message.set_token('PV_PARTNER_PORTAL_URL', l_prtner_portal_url);
3195: l_message_body := l_message_body ||fnd_message.get || l_newline;
3196:
3197: /* Get the values for all message attributes from the message list for Message Footer */
3198: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
3199: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
3200: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
3201:
3202: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);

Line 3199: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;

3195: l_message_body := l_message_body ||fnd_message.get || l_newline;
3196:
3197: /* Get the values for all message attributes from the message list for Message Footer */
3198: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
3199: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
3200: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
3201:
3202: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
3203: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);

Line 3200: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;

3196:
3197: /* Get the values for all message attributes from the message list for Message Footer */
3198: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
3199: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
3200: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
3201:
3202: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
3203: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
3204: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);

Line 3222: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');

3218: x_pgp_notif_rec => l_pgp_notif_rec );
3219:
3220: /* Check the Procedure's x_return_status */
3221: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3222: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
3223: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
3224: FND_MSG_PUB.Add;
3225: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3226: RAISE FND_API.G_EXC_ERROR;

Line 3223: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);

3219:
3220: /* Check the Procedure's x_return_status */
3221: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3222: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
3223: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
3224: FND_MSG_PUB.Add;
3225: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3226: RAISE FND_API.G_EXC_ERROR;
3227: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3247: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');

3243: x_party_notification_id => x_party_notification_id );
3244:
3245: /* Check the Procedure's x_return_status */
3246: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3247: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
3248: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
3249: FND_MSG_PUB.Add;
3250: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3251: RAISE FND_API.G_EXC_ERROR;

Line 3248: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);

3244:
3245: /* Check the Procedure's x_return_status */
3246: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3247: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
3248: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
3249: FND_MSG_PUB.Add;
3250: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3251: RAISE FND_API.G_EXC_ERROR;
3252: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3282: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');

3278: x_msg_data => x_msg_data );
3279:
3280: /* Check for x_return_status */
3281: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3282: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');
3283: FND_MESSAGE.SET_TOKEN('ID',p_membership_id);
3284: FND_MSG_PUB.Add;
3285: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3286: RAISE FND_API.G_EXC_ERROR;

Line 3283: FND_MESSAGE.SET_TOKEN('ID',p_membership_id);

3279:
3280: /* Check for x_return_status */
3281: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3282: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');
3283: FND_MESSAGE.SET_TOKEN('ID',p_membership_id);
3284: FND_MSG_PUB.Add;
3285: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3286: RAISE FND_API.G_EXC_ERROR;
3287: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3499: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');

3495: x_return_status => x_return_status);
3496:
3497: /* Check the Procedure's x_return_status */
3498: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3499: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
3500: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',p_mbrship_chng_rec.resource_id);
3501: FND_MSG_PUB.Add;
3502: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3503: RAISE FND_API.G_EXC_ERROR;

Line 3500: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',p_mbrship_chng_rec.resource_id);

3496:
3497: /* Check the Procedure's x_return_status */
3498: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3499: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
3500: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',p_mbrship_chng_rec.resource_id);
3501: FND_MSG_PUB.Add;
3502: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3503: RAISE FND_API.G_EXC_ERROR;
3504: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3520: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');

3516:
3517:
3518: /* Check the Procedure's x_return_status */
3519: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3520: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');
3521: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);
3522: FND_MSG_PUB.Add;
3523: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3524: RAISE FND_API.G_EXC_ERROR;

Line 3521: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);

3517:
3518: /* Check the Procedure's x_return_status */
3519: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3520: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_USER_EXIST');
3521: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_prtnr_vndr_relship_id);
3522: FND_MSG_PUB.Add;
3523: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3524: RAISE FND_API.G_EXC_ERROR;
3525: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3547: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');

3543: );
3544:
3545: /* Check the Procedure's x_return_status */
3546: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3547: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');
3548: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);
3549: FND_MSG_PUB.Add;
3550: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3551: RAISE FND_API.G_EXC_ERROR;

Line 3548: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);

3544:
3545: /* Check the Procedure's x_return_status */
3546: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3547: FND_MESSAGE.SET_NAME('PV','PV_RES_ROLE_NOT_EXIST');
3548: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',l_user_resource_id);
3549: FND_MSG_PUB.Add;
3550: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3551: RAISE FND_API.G_EXC_ERROR;
3552: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3586: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');

3582:
3583:
3584: /* Check the Procedure's x_return_status */
3585: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3586: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
3587: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
3588: FND_MSG_PUB.Add;
3589: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3590: RAISE FND_API.G_EXC_ERROR;

Line 3587: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);

3583:
3584: /* Check the Procedure's x_return_status */
3585: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3586: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
3587: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
3588: FND_MSG_PUB.Add;
3589: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3590: RAISE FND_API.G_EXC_ERROR;
3591: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3611: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');

3607: x_party_notification_id => x_party_notification_id );
3608:
3609: /* Check the Procedure's x_return_status */
3610: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3611: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
3612: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
3613: FND_MSG_PUB.Add;
3614: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3615: RAISE FND_API.G_EXC_ERROR;

Line 3612: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);

3608:
3609: /* Check the Procedure's x_return_status */
3610: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3611: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
3612: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notif_id);
3613: FND_MSG_PUB.Add;
3614: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3615: RAISE FND_API.G_EXC_ERROR;
3616: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3659: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');

3655: x_msg_data => x_msg_data );
3656:
3657: -- Check for x_return_status
3658: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3659: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');
3660: FND_MESSAGE.SET_TOKEN('ID',p_mbrship_chng_rec.id);
3661: FND_MSG_PUB.Add;
3662: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3663: RAISE FND_API.G_EXC_ERROR;

Line 3660: FND_MESSAGE.SET_TOKEN('ID',p_mbrship_chng_rec.id);

3656:
3657: -- Check for x_return_status
3658: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3659: FND_MESSAGE.SET_NAME('PV','PV_CR_HISTORY_LOG');
3660: FND_MESSAGE.SET_TOKEN('ID',p_mbrship_chng_rec.id);
3661: FND_MSG_PUB.Add;
3662: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3663: RAISE FND_API.G_EXC_ERROR;
3664: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3781: FND_MESSAGE.SET_NAME('PV','PV_API_ERROR_MESSAGE');

3777: x_msg_data => x_msg_data ,
3778: p_membership_id => l_mbrship_id );
3779:
3780: IF (X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS ) THEN
3781: FND_MESSAGE.SET_NAME('PV','PV_API_ERROR_MESSAGE');
3782: FND_MESSAGE.SET_TOKEN('PROC_NAME','PVX_Utility_PVT.send_ini_rmdr_notif');
3783: FND_MESSAGE.SET_TOKEN('ITEM_NAME','MEMBERSHIP_ID');
3784: FND_MESSAGE.SET_TOKEN('ITEM_ID',l_mbrship_id);
3785: FND_MSG_PUB.Add;

Line 3782: FND_MESSAGE.SET_TOKEN('PROC_NAME','PVX_Utility_PVT.send_ini_rmdr_notif');

3778: p_membership_id => l_mbrship_id );
3779:
3780: IF (X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS ) THEN
3781: FND_MESSAGE.SET_NAME('PV','PV_API_ERROR_MESSAGE');
3782: FND_MESSAGE.SET_TOKEN('PROC_NAME','PVX_Utility_PVT.send_ini_rmdr_notif');
3783: FND_MESSAGE.SET_TOKEN('ITEM_NAME','MEMBERSHIP_ID');
3784: FND_MESSAGE.SET_TOKEN('ITEM_ID',l_mbrship_id);
3785: FND_MSG_PUB.Add;
3786: END IF;

Line 3783: FND_MESSAGE.SET_TOKEN('ITEM_NAME','MEMBERSHIP_ID');

3779:
3780: IF (X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS ) THEN
3781: FND_MESSAGE.SET_NAME('PV','PV_API_ERROR_MESSAGE');
3782: FND_MESSAGE.SET_TOKEN('PROC_NAME','PVX_Utility_PVT.send_ini_rmdr_notif');
3783: FND_MESSAGE.SET_TOKEN('ITEM_NAME','MEMBERSHIP_ID');
3784: FND_MESSAGE.SET_TOKEN('ITEM_ID',l_mbrship_id);
3785: FND_MSG_PUB.Add;
3786: END IF;
3787:

Line 3784: FND_MESSAGE.SET_TOKEN('ITEM_ID',l_mbrship_id);

3780: IF (X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS ) THEN
3781: FND_MESSAGE.SET_NAME('PV','PV_API_ERROR_MESSAGE');
3782: FND_MESSAGE.SET_TOKEN('PROC_NAME','PVX_Utility_PVT.send_ini_rmdr_notif');
3783: FND_MESSAGE.SET_TOKEN('ITEM_NAME','MEMBERSHIP_ID');
3784: FND_MESSAGE.SET_TOKEN('ITEM_ID',l_mbrship_id);
3785: FND_MSG_PUB.Add;
3786: END IF;
3787:
3788:

Line 3808: FND_MESSAGE.SET_NAME('PV','PV_API_ERROR_MESSAGE');

3804: x_msg_data => x_msg_data ,
3805: p_enrl_request_id => l_enrl_req_id );
3806:
3807: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3808: FND_MESSAGE.SET_NAME('PV','PV_API_ERROR_MESSAGE');
3809: FND_MESSAGE.SET_TOKEN('PROC_NAME','PVX_Utility_PVT.send_ini_rmdr_notif');
3810: FND_MESSAGE.SET_TOKEN('ITEM_NAME','ENRL_REQUEST_ID');
3811: FND_MESSAGE.SET_TOKEN('ITEM_ID',l_enrl_req_id);
3812: FND_MSG_PUB.Add;

Line 3809: FND_MESSAGE.SET_TOKEN('PROC_NAME','PVX_Utility_PVT.send_ini_rmdr_notif');

3805: p_enrl_request_id => l_enrl_req_id );
3806:
3807: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3808: FND_MESSAGE.SET_NAME('PV','PV_API_ERROR_MESSAGE');
3809: FND_MESSAGE.SET_TOKEN('PROC_NAME','PVX_Utility_PVT.send_ini_rmdr_notif');
3810: FND_MESSAGE.SET_TOKEN('ITEM_NAME','ENRL_REQUEST_ID');
3811: FND_MESSAGE.SET_TOKEN('ITEM_ID',l_enrl_req_id);
3812: FND_MSG_PUB.Add;
3813: END IF;

Line 3810: FND_MESSAGE.SET_TOKEN('ITEM_NAME','ENRL_REQUEST_ID');

3806:
3807: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3808: FND_MESSAGE.SET_NAME('PV','PV_API_ERROR_MESSAGE');
3809: FND_MESSAGE.SET_TOKEN('PROC_NAME','PVX_Utility_PVT.send_ini_rmdr_notif');
3810: FND_MESSAGE.SET_TOKEN('ITEM_NAME','ENRL_REQUEST_ID');
3811: FND_MESSAGE.SET_TOKEN('ITEM_ID',l_enrl_req_id);
3812: FND_MSG_PUB.Add;
3813: END IF;
3814:

Line 3811: FND_MESSAGE.SET_TOKEN('ITEM_ID',l_enrl_req_id);

3807: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3808: FND_MESSAGE.SET_NAME('PV','PV_API_ERROR_MESSAGE');
3809: FND_MESSAGE.SET_TOKEN('PROC_NAME','PVX_Utility_PVT.send_ini_rmdr_notif');
3810: FND_MESSAGE.SET_TOKEN('ITEM_NAME','ENRL_REQUEST_ID');
3811: FND_MESSAGE.SET_TOKEN('ITEM_ID',l_enrl_req_id);
3812: FND_MSG_PUB.Add;
3813: END IF;
3814:
3815: END IF;

Line 4768: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');

4764:
4765:
4766: /* Check the Procedure's x_return_status */
4767: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4768: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
4769: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notification_id);
4770: FND_MSG_PUB.Add;
4771: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4772: RAISE FND_API.G_EXC_ERROR;

Line 4769: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notification_id);

4765:
4766: /* Check the Procedure's x_return_status */
4767: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4768: FND_MESSAGE.SET_NAME('PV','PV_SET_NOTIF_REC');
4769: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notification_id);
4770: FND_MSG_PUB.Add;
4771: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4772: RAISE FND_API.G_EXC_ERROR;
4773: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 4794: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');

4790: );
4791:
4792: /* Check the Procedure's x_return_status */
4793: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4794: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
4795: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notification_id);
4796: FND_MSG_PUB.Add;
4797: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4798: RAISE FND_API.G_EXC_ERROR;

Line 4795: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notification_id);

4791:
4792: /* Check the Procedure's x_return_status */
4793: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4794: FND_MESSAGE.SET_NAME('PV','PV_GE_PARTY_NOTIF_REC');
4795: FND_MESSAGE.SET_TOKEN('NOTIFICATION_ID',l_notification_id);
4796: FND_MSG_PUB.Add;
4797: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4798: RAISE FND_API.G_EXC_ERROR;
4799: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 4966: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');

4962: l_itemKey := l_itemKey || l_val;
4963: -- check for null
4964: /**
4965: IF ( p_context_code = FND_API.G_MISS_CHAR OR p_context_code IS NULL ) THEN
4966: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
4967: FND_MESSAGE.SET_TOKEN('ITEM_NAME', p_context_code);
4968: RAISE FND_API.G_EXC_ERROR;
4969: END IF;
4970:

Line 4967: FND_MESSAGE.SET_TOKEN('ITEM_NAME', p_context_code);

4963: -- check for null
4964: /**
4965: IF ( p_context_code = FND_API.G_MISS_CHAR OR p_context_code IS NULL ) THEN
4966: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
4967: FND_MESSAGE.SET_TOKEN('ITEM_NAME', p_context_code);
4968: RAISE FND_API.G_EXC_ERROR;
4969: END IF;
4970:
4971: IF ( p_target_ctgry = FND_API.G_MISS_CHAR OR p_target_ctgry IS NULL ) THEN

Line 4972: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');

4968: RAISE FND_API.G_EXC_ERROR;
4969: END IF;
4970:
4971: IF ( p_target_ctgry = FND_API.G_MISS_CHAR OR p_target_ctgry IS NULL ) THEN
4972: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
4973: FND_MESSAGE.SET_TOKEN('ITEM_NAME', p_target_ctgry);
4974: RAISE FND_API.G_EXC_ERROR;
4975: END IF;
4976:

Line 4973: FND_MESSAGE.SET_TOKEN('ITEM_NAME', p_target_ctgry);

4969: END IF;
4970:
4971: IF ( p_target_ctgry = FND_API.G_MISS_CHAR OR p_target_ctgry IS NULL ) THEN
4972: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
4973: FND_MESSAGE.SET_TOKEN('ITEM_NAME', p_target_ctgry);
4974: RAISE FND_API.G_EXC_ERROR;
4975: END IF;
4976:
4977: IF ( p_entity_code = FND_API.G_MISS_CHAR OR p_entity_code IS NULL ) THEN

Line 4978: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');

4974: RAISE FND_API.G_EXC_ERROR;
4975: END IF;
4976:
4977: IF ( p_entity_code = FND_API.G_MISS_CHAR OR p_entity_code IS NULL ) THEN
4978: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
4979: FND_MESSAGE.SET_TOKEN('ITEM_NAME', p_entity_code);
4980: RAISE FND_API.G_EXC_ERROR;
4981: END IF;
4982:

Line 4979: FND_MESSAGE.SET_TOKEN('ITEM_NAME', p_entity_code);

4975: END IF;
4976:
4977: IF ( p_entity_code = FND_API.G_MISS_CHAR OR p_entity_code IS NULL ) THEN
4978: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
4979: FND_MESSAGE.SET_TOKEN('ITEM_NAME', p_entity_code);
4980: RAISE FND_API.G_EXC_ERROR;
4981: END IF;
4982:
4983:

Line 4985: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');

4981: END IF;
4982:
4983:
4984: IF ( p_notif_event_code = FND_API.G_MISS_CHAR OR p_notif_event_code IS NULL ) THEN
4985: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
4986: FND_MESSAGE.SET_TOKEN('ITEM_NAME', p_notif_event_code);
4987: RAISE FND_API.G_EXC_ERROR;
4988: END IF;
4989:

Line 4986: FND_MESSAGE.SET_TOKEN('ITEM_NAME', p_notif_event_code);

4982:
4983:
4984: IF ( p_notif_event_code = FND_API.G_MISS_CHAR OR p_notif_event_code IS NULL ) THEN
4985: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
4986: FND_MESSAGE.SET_TOKEN('ITEM_NAME', p_notif_event_code);
4987: RAISE FND_API.G_EXC_ERROR;
4988: END IF;
4989:
4990: */

Line 4999: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');

4995: ,p_lookup_code => p_target_ctgry
4996: );
4997:
4998: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
4999: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
5000: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_ENTITY_NOTIF_CATEGORY' );
5001: FND_MESSAGE.set_token('LOOKUP_CODE', p_target_ctgry );
5002: fnd_msg_pub.Add;
5003: RAISE FND_API.G_EXC_ERROR;

Line 5000: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_ENTITY_NOTIF_CATEGORY' );

4996: );
4997:
4998: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
4999: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
5000: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_ENTITY_NOTIF_CATEGORY' );
5001: FND_MESSAGE.set_token('LOOKUP_CODE', p_target_ctgry );
5002: fnd_msg_pub.Add;
5003: RAISE FND_API.G_EXC_ERROR;
5004: END IF;

Line 5001: FND_MESSAGE.set_token('LOOKUP_CODE', p_target_ctgry );

4997:
4998: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
4999: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
5000: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_ENTITY_NOTIF_CATEGORY' );
5001: FND_MESSAGE.set_token('LOOKUP_CODE', p_target_ctgry );
5002: fnd_msg_pub.Add;
5003: RAISE FND_API.G_EXC_ERROR;
5004: END IF;
5005:

Line 5013: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');

5009: ,p_lookup_type => 'PV_NOTIFICATION_EVENT_TYPE'
5010: ,p_lookup_code => p_notif_event_code
5011: );
5012: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
5013: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
5014: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_NOTIFICATION_EVENT_TYPE' );
5015: FND_MESSAGE.set_token('LOOKUP_CODE', p_notif_event_code );
5016: fnd_msg_pub.Add;
5017: RAISE FND_API.G_EXC_ERROR;

Line 5014: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_NOTIFICATION_EVENT_TYPE' );

5010: ,p_lookup_code => p_notif_event_code
5011: );
5012: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
5013: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
5014: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_NOTIFICATION_EVENT_TYPE' );
5015: FND_MESSAGE.set_token('LOOKUP_CODE', p_notif_event_code );
5016: fnd_msg_pub.Add;
5017: RAISE FND_API.G_EXC_ERROR;
5018: END IF;

Line 5015: FND_MESSAGE.set_token('LOOKUP_CODE', p_notif_event_code );

5011: );
5012: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
5013: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
5014: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_NOTIFICATION_EVENT_TYPE' );
5015: FND_MESSAGE.set_token('LOOKUP_CODE', p_notif_event_code );
5016: fnd_msg_pub.Add;
5017: RAISE FND_API.G_EXC_ERROR;
5018: END IF;
5019:

Line 5027: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');

5023: ,p_lookup_type => 'PV_ENTITY_TYPE'
5024: ,p_lookup_code => p_entity_code
5025: );
5026: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
5027: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
5028: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_ENTITY_TYPE' );
5029: FND_MESSAGE.set_token('LOOKUP_CODE', p_entity_code );
5030: fnd_msg_pub.Add;
5031: RAISE FND_API.G_EXC_ERROR;

Line 5028: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_ENTITY_TYPE' );

5024: ,p_lookup_code => p_entity_code
5025: );
5026: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
5027: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
5028: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_ENTITY_TYPE' );
5029: FND_MESSAGE.set_token('LOOKUP_CODE', p_entity_code );
5030: fnd_msg_pub.Add;
5031: RAISE FND_API.G_EXC_ERROR;
5032: END IF;

Line 5029: FND_MESSAGE.set_token('LOOKUP_CODE', p_entity_code );

5025: );
5026: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
5027: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
5028: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_ENTITY_TYPE' );
5029: FND_MESSAGE.set_token('LOOKUP_CODE', p_entity_code );
5030: fnd_msg_pub.Add;
5031: RAISE FND_API.G_EXC_ERROR;
5032: END IF;
5033:

Line 5042: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');

5038: ,p_lookup_type => 'PV_ENTITY_TYPE'
5039: ,p_lookup_code => p_context_code
5040: );
5041: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
5042: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
5043: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_ENTITY_TYPE' );
5044: FND_MESSAGE.set_token('LOOKUP_CODE', p_context_code );
5045: RAISE FND_API.G_EXC_ERROR;
5046: END IF;

Line 5043: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_ENTITY_TYPE' );

5039: ,p_lookup_code => p_context_code
5040: );
5041: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
5042: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
5043: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_ENTITY_TYPE' );
5044: FND_MESSAGE.set_token('LOOKUP_CODE', p_context_code );
5045: RAISE FND_API.G_EXC_ERROR;
5046: END IF;
5047: */

Line 5044: FND_MESSAGE.set_token('LOOKUP_CODE', p_context_code );

5040: );
5041: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
5042: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
5043: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_ENTITY_TYPE' );
5044: FND_MESSAGE.set_token('LOOKUP_CODE', p_context_code );
5045: RAISE FND_API.G_EXC_ERROR;
5046: END IF;
5047: */
5048: IF p_entity_code IN ( 'GLOBAL', 'SUBSIDIARY', 'STANDARD' ) THEN

Line 5116: FND_MESSAGE.SET_NAME('PV', 'PV_ENRL_REQ_NOT_EXIST');

5112:
5113:
5114: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
5115: THEN
5116: FND_MESSAGE.SET_NAME('PV', 'PV_ENRL_REQ_NOT_EXIST');
5117: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_entity_id);
5118: FND_MSG_PUB.Add;
5119: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5120: RAISE FND_API.G_EXC_ERROR;

Line 5117: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_entity_id);

5113:
5114: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
5115: THEN
5116: FND_MESSAGE.SET_NAME('PV', 'PV_ENRL_REQ_NOT_EXIST');
5117: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_entity_id);
5118: FND_MSG_PUB.Add;
5119: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5120: RAISE FND_API.G_EXC_ERROR;
5121: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 5142: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');

5138:
5139: /* Check for Procedure's x_return_status */
5140: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
5141: THEN
5142: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
5143: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_entity_id);
5144: FND_MSG_PUB.Add;
5145: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5146: RAISE FND_API.G_EXC_ERROR;

Line 5143: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_entity_id);

5139: /* Check for Procedure's x_return_status */
5140: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
5141: THEN
5142: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
5143: FND_MESSAGE.SET_TOKEN('ENRL_REQUEST_ID',p_entity_id);
5144: FND_MSG_PUB.Add;
5145: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5146: RAISE FND_API.G_EXC_ERROR;
5147: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 5165: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');

5161:
5162:
5163: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
5164: THEN
5165: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
5166: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);
5167: FND_MSG_PUB.Add;
5168: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5169: RAISE FND_API.G_EXC_ERROR;

Line 5166: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);

5162:
5163: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
5164: THEN
5165: FND_MESSAGE.SET_NAME('PV','PV_REQUESTOR_NOT_EXIST');
5166: FND_MESSAGE.SET_TOKEN('REQ_RESOURCE_ID',l_req_resource_id);
5167: FND_MSG_PUB.Add;
5168: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5169: RAISE FND_API.G_EXC_ERROR;
5170: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 5205: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_CNTCT_FOR_INVITE');

5201: IF x_return_status IN ( FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR ) THEN
5202:
5203: -- raise error if its an invitation. else.. log it and return without sending any notification
5204: IF p_notif_event_code IN ( 'PG_INVITE','VAD_INVITE_IMP') THEN
5205: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_CNTCT_FOR_INVITE');
5206: FND_MSG_PUB.Add;
5207: RAISE FND_API.G_EXC_ERROR;
5208: ELSE
5209: fnd_message.set_name ('PV', 'PV_NO_PRIMARY_USER_EXIST');

Line 5209: fnd_message.set_name ('PV', 'PV_NO_PRIMARY_USER_EXIST');

5205: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_CNTCT_FOR_INVITE');
5206: FND_MSG_PUB.Add;
5207: RAISE FND_API.G_EXC_ERROR;
5208: ELSE
5209: fnd_message.set_name ('PV', 'PV_NO_PRIMARY_USER_EXIST');
5210: fnd_message.set_token ('PARTNER_ID',l_notif_targeted_ptr_id);
5211: FND_MSG_PUB.Add;
5212: l_string := SUBSTR(fnd_message.get,1,1000);
5213: WRITE_TO_FND_LOG(l_api_name,l_string );

Line 5210: fnd_message.set_token ('PARTNER_ID',l_notif_targeted_ptr_id);

5206: FND_MSG_PUB.Add;
5207: RAISE FND_API.G_EXC_ERROR;
5208: ELSE
5209: fnd_message.set_name ('PV', 'PV_NO_PRIMARY_USER_EXIST');
5210: fnd_message.set_token ('PARTNER_ID',l_notif_targeted_ptr_id);
5211: FND_MSG_PUB.Add;
5212: l_string := SUBSTR(fnd_message.get,1,1000);
5213: WRITE_TO_FND_LOG(l_api_name,l_string );
5214: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5212: l_string := SUBSTR(fnd_message.get,1,1000);

5208: ELSE
5209: fnd_message.set_name ('PV', 'PV_NO_PRIMARY_USER_EXIST');
5210: fnd_message.set_token ('PARTNER_ID',l_notif_targeted_ptr_id);
5211: FND_MSG_PUB.Add;
5212: l_string := SUBSTR(fnd_message.get,1,1000);
5213: WRITE_TO_FND_LOG(l_api_name,l_string );
5214: x_return_status := FND_API.G_RET_STS_SUCCESS;
5215: IF x_msg_count is null THEN
5216: x_msg_count := 0;

Line 5543: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');

5539: , x_return_status => x_return_status
5540: );
5541: /* Check for Procedure's x_return_status */
5542: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5543: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
5544: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_partner_id );
5545: FND_MSG_PUB.Add;
5546: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5547: RAISE FND_API.G_EXC_ERROR;

Line 5544: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_partner_id );

5540: );
5541: /* Check for Procedure's x_return_status */
5542: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5543: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
5544: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_partner_id );
5545: FND_MSG_PUB.Add;
5546: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5547: RAISE FND_API.G_EXC_ERROR;
5548: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 5631: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

5627: raise FND_API.G_EXC_ERROR;
5628: end if;
5629:
5630: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
5631: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
5632: fnd_message.Set_token('TEXT', 'After Checkforerror');
5633: fnd_msg_pub.Add;
5634: END IF;
5635: */

Line 5632: fnd_message.Set_token('TEXT', 'After Checkforerror');

5628: end if;
5629:
5630: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
5631: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
5632: fnd_message.Set_token('TEXT', 'After Checkforerror');
5633: fnd_msg_pub.Add;
5634: END IF;
5635: */
5636: END IF;

Line 5797: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_CNTCT_FOR_INVITE');

5793: ) ;
5794:
5795: /* Check for Procedure's x_return_status */
5796: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5797: FND_MESSAGE.SET_NAME('PV','PV_NO_PRIMARY_CNTCT_FOR_INVITE');
5798: FND_MSG_PUB.Add;
5799: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5800: RAISE FND_API.G_EXC_ERROR;
5801: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 5877: fnd_message.set_name ('PV', 'PV_PRGM_DISCOUNT_MSG');

5873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5874: END IF;
5875: l_discount_str:= p_discount_value || ' ' || l_discount_meaning ;
5876: END IF;
5877: fnd_message.set_name ('PV', 'PV_PRGM_DISCOUNT_MSG');
5878: fnd_message.set_token ('DISCOUNT', l_discount_str);
5879: fnd_message.set_token ('END_DATE', p_end_date);
5880: l_string := SUBSTR(fnd_message.get,1,1000);
5881:

Line 5878: fnd_message.set_token ('DISCOUNT', l_discount_str);

5874: END IF;
5875: l_discount_str:= p_discount_value || ' ' || l_discount_meaning ;
5876: END IF;
5877: fnd_message.set_name ('PV', 'PV_PRGM_DISCOUNT_MSG');
5878: fnd_message.set_token ('DISCOUNT', l_discount_str);
5879: fnd_message.set_token ('END_DATE', p_end_date);
5880: l_string := SUBSTR(fnd_message.get,1,1000);
5881:
5882: END IF;

Line 5879: fnd_message.set_token ('END_DATE', p_end_date);

5875: l_discount_str:= p_discount_value || ' ' || l_discount_meaning ;
5876: END IF;
5877: fnd_message.set_name ('PV', 'PV_PRGM_DISCOUNT_MSG');
5878: fnd_message.set_token ('DISCOUNT', l_discount_str);
5879: fnd_message.set_token ('END_DATE', p_end_date);
5880: l_string := SUBSTR(fnd_message.get,1,1000);
5881:
5882: END IF;
5883:

Line 5880: l_string := SUBSTR(fnd_message.get,1,1000);

5876: END IF;
5877: fnd_message.set_name ('PV', 'PV_PRGM_DISCOUNT_MSG');
5878: fnd_message.set_token ('DISCOUNT', l_discount_str);
5879: fnd_message.set_token ('END_DATE', p_end_date);
5880: l_string := SUBSTR(fnd_message.get,1,1000);
5881:
5882: END IF;
5883:
5884: wf_engine.SetItemAttrText

Line 5973: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');

5969: , x_return_status => x_return_status
5970: );
5971: /* Check for Procedure's x_return_status */
5972: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5973: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
5974: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_partner_id );
5975: FND_MSG_PUB.Add;
5976: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5977: RAISE FND_API.G_EXC_ERROR;

Line 5974: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_partner_id );

5970: );
5971: /* Check for Procedure's x_return_status */
5972: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5973: FND_MESSAGE.SET_NAME('PV','PV_PRTNR_VNDR_NOT_EXIST');
5974: FND_MESSAGE.SET_TOKEN('PARTNER_ID',l_partner_id );
5975: FND_MSG_PUB.Add;
5976: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5977: RAISE FND_API.G_EXC_ERROR;
5978: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN