APPS.IBE_DSPMGRVALIDATION_GRP dependencies on FND_MESSAGE

Line 70: FND_MESSAGE.set_name('IBE','IBE_DSP_ATH_NOT_EXISTS');

66: EXCEPTION
67:
68: WHEN l_ath_not_exists_exception THEN
69: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
70: FND_MESSAGE.set_name('IBE','IBE_DSP_ATH_NOT_EXISTS');
71: FND_MESSAGE.set_token('ID', TO_CHAR(p_attachment_id));
72: FND_MSG_PUB.ADD;
73: END IF;
74: RETURN l_return_status;

Line 71: FND_MESSAGE.set_token('ID', TO_CHAR(p_attachment_id));

67:
68: WHEN l_ath_not_exists_exception THEN
69: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
70: FND_MESSAGE.set_name('IBE','IBE_DSP_ATH_NOT_EXISTS');
71: FND_MESSAGE.set_token('ID', TO_CHAR(p_attachment_id));
72: FND_MSG_PUB.ADD;
73: END IF;
74: RETURN l_return_status;
75:

Line 125: FND_MESSAGE.set_name('IBE','IBE_DSP_ATH_NOT_EXISTS');

121: EXCEPTION
122:
123: WHEN l_ath_not_exists_exception THEN
124: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
125: FND_MESSAGE.set_name('IBE','IBE_DSP_ATH_NOT_EXISTS');
126: FND_MESSAGE.set_token('ID', TO_CHAR(p_attachment_id));
127: FND_MSG_PUB.ADD;
128: END IF;
129: RETURN NULL;

Line 126: FND_MESSAGE.set_token('ID', TO_CHAR(p_attachment_id));

122:
123: WHEN l_ath_not_exists_exception THEN
124: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
125: FND_MESSAGE.set_name('IBE','IBE_DSP_ATH_NOT_EXISTS');
126: FND_MESSAGE.set_token('ID', TO_CHAR(p_attachment_id));
127: FND_MSG_PUB.ADD;
128: END IF;
129: RETURN NULL;
130:

Line 166: FND_MESSAGE.set_name('IBE','IBE_DSP_CONTEXT_NOT_EXISTS');

162: FETCH context_type_cur INTO l_type_code;
163:
164: IF context_type_cur%NOTFOUND
165: THEN
166: FND_MESSAGE.set_name('IBE','IBE_DSP_CONTEXT_NOT_EXISTS');
167: FND_MESSAGE.set_token('ID', p_context_id);
168: FND_MSG_PUB.ADD;
169: END IF;
170: CLOSE context_type_cur;

Line 167: FND_MESSAGE.set_token('ID', p_context_id);

163:
164: IF context_type_cur%NOTFOUND
165: THEN
166: FND_MESSAGE.set_name('IBE','IBE_DSP_CONTEXT_NOT_EXISTS');
167: FND_MESSAGE.set_token('ID', p_context_id);
168: FND_MSG_PUB.ADD;
169: END IF;
170: CLOSE context_type_cur;
171:

Line 226: FND_MESSAGE.set_name('IBE','IBE_DSP_CONTEXT_NOT_EXISTS');

222: OPEN context_cur(p_context_id ,l_context_type);
223: FETCH context_cur INTO l_exists;
224: IF context_cur%NOTFOUND
225: THEN
226: FND_MESSAGE.set_name('IBE','IBE_DSP_CONTEXT_NOT_EXISTS');
227: FND_MESSAGE.set_token('ID', p_context_id);
228: FND_MSG_PUB.ADD;
229: ELSE
230: l_return_status := true;

Line 227: FND_MESSAGE.set_token('ID', p_context_id);

223: FETCH context_cur INTO l_exists;
224: IF context_cur%NOTFOUND
225: THEN
226: FND_MESSAGE.set_name('IBE','IBE_DSP_CONTEXT_NOT_EXISTS');
227: FND_MESSAGE.set_token('ID', p_context_id);
228: FND_MSG_PUB.ADD;
229: ELSE
230: l_return_status := true;
231: END IF;

Line 238: FND_MESSAGE.set_name('IBE','IBE_DSP_CONTEXT_NOT_EXISTS');

234: OPEN context_version_cur(p_context_id ,l_context_type, p_object_version_number);
235: FETCH context_version_cur INTO l_exists;
236: IF context_version_cur%NOTFOUND
237: THEN
238: FND_MESSAGE.set_name('IBE','IBE_DSP_CONTEXT_NOT_EXISTS');
239: FND_MESSAGE.set_token('ID', p_context_id);
240: FND_MSG_PUB.ADD;
241: ELSE
242: l_return_status := true;

Line 239: FND_MESSAGE.set_token('ID', p_context_id);

235: FETCH context_version_cur INTO l_exists;
236: IF context_version_cur%NOTFOUND
237: THEN
238: FND_MESSAGE.set_name('IBE','IBE_DSP_CONTEXT_NOT_EXISTS');
239: FND_MESSAGE.set_token('ID', p_context_id);
240: FND_MSG_PUB.ADD;
241: ELSE
242: l_return_status := true;
243: END IF;

Line 285: FND_MESSAGE.set_name('IBE','IBE_DSP_CONTEXT_TYPE_INVLD');

281: OPEN valid_context_cur(l_context_type);
282: FETCH valid_context_cur into l_exists;
283:
284: IF valid_context_cur%NOTFOUND then
285: FND_MESSAGE.set_name('IBE','IBE_DSP_CONTEXT_TYPE_INVLD');
286: FND_MESSAGE.set_token('TYPE', l_context_type);
287: FND_MESSAGE.set_token('ID', to_char(null));
288: FND_MSG_PUB.ADD;
289: l_return_status := false;

Line 286: FND_MESSAGE.set_token('TYPE', l_context_type);

282: FETCH valid_context_cur into l_exists;
283:
284: IF valid_context_cur%NOTFOUND then
285: FND_MESSAGE.set_name('IBE','IBE_DSP_CONTEXT_TYPE_INVLD');
286: FND_MESSAGE.set_token('TYPE', l_context_type);
287: FND_MESSAGE.set_token('ID', to_char(null));
288: FND_MSG_PUB.ADD;
289: l_return_status := false;
290: ELSE

Line 287: FND_MESSAGE.set_token('ID', to_char(null));

283:
284: IF valid_context_cur%NOTFOUND then
285: FND_MESSAGE.set_name('IBE','IBE_DSP_CONTEXT_TYPE_INVLD');
286: FND_MESSAGE.set_token('TYPE', l_context_type);
287: FND_MESSAGE.set_token('ID', to_char(null));
288: FND_MSG_PUB.ADD;
289: l_return_status := false;
290: ELSE
291: l_return_status := true;

Line 350: FND_MESSAGE.set_name('IBE','IBE_DSP_LGLCTNT_OBJTYPE_INVLD');

346:
347: OPEN valid_object_cur(l_object_type_code);
348: FETCH valid_object_cur into l_exists;
349: IF valid_object_cur%NOTFOUND then
350: FND_MESSAGE.set_name('IBE','IBE_DSP_LGLCTNT_OBJTYPE_INVLD');
351: FND_MESSAGE.set_token('TYPE', l_object_type_code);
352: FND_MSG_PUB.ADD;
353: l_return_status := false;
354: ELSE

Line 351: FND_MESSAGE.set_token('TYPE', l_object_type_code);

347: OPEN valid_object_cur(l_object_type_code);
348: FETCH valid_object_cur into l_exists;
349: IF valid_object_cur%NOTFOUND then
350: FND_MESSAGE.set_name('IBE','IBE_DSP_LGLCTNT_OBJTYPE_INVLD');
351: FND_MESSAGE.set_token('TYPE', l_object_type_code);
352: FND_MSG_PUB.ADD;
353: l_return_status := false;
354: ELSE
355: l_return_status := true;

Line 432: FND_MESSAGE.set_name('IBE','IBE_DSP_CONTEXT_ACCNAME_EXISTS');

428: CLOSE context_accessname_id_cur;
429: end if;
430:
431: if not l_return_status then
432: FND_MESSAGE.set_name('IBE','IBE_DSP_CONTEXT_ACCNAME_EXISTS');
433: FND_MESSAGE.set_token('ACC_NAME', l_context_accessname);
434: FND_MSG_PUB.ADD;
435: end if;
436:

Line 433: FND_MESSAGE.set_token('ACC_NAME', l_context_accessname);

429: end if;
430:
431: if not l_return_status then
432: FND_MESSAGE.set_name('IBE','IBE_DSP_CONTEXT_ACCNAME_EXISTS');
433: FND_MESSAGE.set_token('ACC_NAME', l_context_accessname);
434: FND_MSG_PUB.ADD;
435: end if;
436:
437: return l_return_status;

Line 518: FND_MESSAGE.set_name('IBE','IBE_DSP_CATEGORY_NOT_EXISTS');

514: OPEN category_cur(p_category_id );
515: FETCH category_cur INTO l_exists;
516: IF category_cur%NOTFOUND
517: THEN
518: FND_MESSAGE.set_name('IBE','IBE_DSP_CATEGORY_NOT_EXISTS');
519: FND_MESSAGE.set_token('ID',p_category_id);
520: FND_MSG_PUB.ADD;
521: ELSE
522: l_return_status := true;

Line 519: FND_MESSAGE.set_token('ID',p_category_id);

515: FETCH category_cur INTO l_exists;
516: IF category_cur%NOTFOUND
517: THEN
518: FND_MESSAGE.set_name('IBE','IBE_DSP_CATEGORY_NOT_EXISTS');
519: FND_MESSAGE.set_token('ID',p_category_id);
520: FND_MSG_PUB.ADD;
521: ELSE
522: l_return_status := true;
523: END IF;

Line 565: FND_MESSAGE.set_name('IBE','IBE_DSP_ITEM_NOT_EXISTS');

561: OPEN item_cur(p_item_id );
562: FETCH item_cur INTO l_exists;
563: IF item_cur%NOTFOUND
564: THEN
565: FND_MESSAGE.set_name('IBE','IBE_DSP_ITEM_NOT_EXISTS');
566: FND_MESSAGE.set_token('ID',p_item_id);
567: FND_MSG_PUB.ADD;
568: ELSE
569: l_return_status := true;

Line 566: FND_MESSAGE.set_token('ID',p_item_id);

562: FETCH item_cur INTO l_exists;
563: IF item_cur%NOTFOUND
564: THEN
565: FND_MESSAGE.set_name('IBE','IBE_DSP_ITEM_NOT_EXISTS');
566: FND_MESSAGE.set_token('ID',p_item_id);
567: FND_MSG_PUB.ADD;
568: ELSE
569: l_return_status := true;
570: END IF;

Line 611: FND_MESSAGE.set_name('IBE','IBE_DSP_SECTION_NOT_EXISTS');

607: OPEN section_cur(p_section_id );
608: FETCH section_cur INTO l_exists;
609: IF section_cur%NOTFOUND
610: THEN
611: FND_MESSAGE.set_name('IBE','IBE_DSP_SECTION_NOT_EXISTS');
612: FND_MESSAGE.set_token('ID',p_section_id);
613:
614: FND_MSG_PUB.ADD;
615: ELSE

Line 612: FND_MESSAGE.set_token('ID',p_section_id);

608: FETCH section_cur INTO l_exists;
609: IF section_cur%NOTFOUND
610: THEN
611: FND_MESSAGE.set_name('IBE','IBE_DSP_SECTION_NOT_EXISTS');
612: FND_MESSAGE.set_token('ID',p_section_id);
613:
614: FND_MSG_PUB.ADD;
615: ELSE
616: l_return_status := true;

Line 655: FND_MESSAGE.set_name('IBE','IBE_MSITE_RSECID_INVLD');

651: OPEN section_cur(p_root_section_id );
652: FETCH section_cur INTO l_exists;
653: IF section_cur%NOTFOUND
654: THEN
655: FND_MESSAGE.set_name('IBE','IBE_MSITE_RSECID_INVLD');
656: FND_MESSAGE.set_token('ID',p_root_section_id);
657: FND_MSG_PUB.ADD;
658: ELSE
659: l_return_status := true;

Line 656: FND_MESSAGE.set_token('ID',p_root_section_id);

652: FETCH section_cur INTO l_exists;
653: IF section_cur%NOTFOUND
654: THEN
655: FND_MESSAGE.set_name('IBE','IBE_MSITE_RSECID_INVLD');
656: FND_MESSAGE.set_token('ID',p_root_section_id);
657: FND_MSG_PUB.ADD;
658: ELSE
659: l_return_status := true;
660: END IF;

Line 789: FND_MESSAGE.set_name('IBE','IBE_DSP_DLV_TYPE_NOT_EXISTS');

785: CLOSE deliverable_type_app_cur;
786: end if;
787:
788: if l_return_status = false then
789: FND_MESSAGE.set_name('IBE','IBE_DSP_DLV_TYPE_NOT_EXISTS');
790: FND_MESSAGE.set_token('ID', p_deliverable_id);
791: FND_MESSAGE.set_token('TYPE', p_item_type);
792: FND_MSG_PUB.add;
793: end if;

Line 790: FND_MESSAGE.set_token('ID', p_deliverable_id);

786: end if;
787:
788: if l_return_status = false then
789: FND_MESSAGE.set_name('IBE','IBE_DSP_DLV_TYPE_NOT_EXISTS');
790: FND_MESSAGE.set_token('ID', p_deliverable_id);
791: FND_MESSAGE.set_token('TYPE', p_item_type);
792: FND_MSG_PUB.add;
793: end if;
794:

Line 791: FND_MESSAGE.set_token('TYPE', p_item_type);

787:
788: if l_return_status = false then
789: FND_MESSAGE.set_name('IBE','IBE_DSP_DLV_TYPE_NOT_EXISTS');
790: FND_MESSAGE.set_token('ID', p_deliverable_id);
791: FND_MESSAGE.set_token('TYPE', p_item_type);
792: FND_MSG_PUB.add;
793: end if;
794:
795: return l_return_status;

Line 876: FND_MESSAGE.set_name('IBE','IBE_DSP_DLV_NOT_EXISTS');

872: EXCEPTION
873:
874: WHEN l_dlv_not_exists_exception THEN
875: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
876: FND_MESSAGE.set_name('IBE','IBE_DSP_DLV_NOT_EXISTS');
877: FND_MESSAGE.set_token('ID', TO_CHAR(p_deliverable_id));
878: FND_MSG_PUB.add;
879: END IF;
880: RETURN l_return_status;

Line 877: FND_MESSAGE.set_token('ID', TO_CHAR(p_deliverable_id));

873:
874: WHEN l_dlv_not_exists_exception THEN
875: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
876: FND_MESSAGE.set_name('IBE','IBE_DSP_DLV_NOT_EXISTS');
877: FND_MESSAGE.set_token('ID', TO_CHAR(p_deliverable_id));
878: FND_MSG_PUB.add;
879: END IF;
880: RETURN l_return_status;
881:

Line 929: FND_MESSAGE.set_name('IBE','IBE_DSP_LGLCTNT_ID_NOT_EXISTS');

925: OPEN lgl_ctnt_cur(p_lgl_ctnt_id );
926: FETCH lgl_ctnt_cur INTO l_exists;
927: IF lgl_ctnt_cur%NOTFOUND
928: THEN
929: FND_MESSAGE.set_name('IBE','IBE_DSP_LGLCTNT_ID_NOT_EXISTS');
930: FND_MESSAGE.set_token('ID',p_lgl_ctnt_id);
931: FND_MSG_PUB.ADD;
932: ELSE
933: l_return_status := true;

Line 930: FND_MESSAGE.set_token('ID',p_lgl_ctnt_id);

926: FETCH lgl_ctnt_cur INTO l_exists;
927: IF lgl_ctnt_cur%NOTFOUND
928: THEN
929: FND_MESSAGE.set_name('IBE','IBE_DSP_LGLCTNT_ID_NOT_EXISTS');
930: FND_MESSAGE.set_token('ID',p_lgl_ctnt_id);
931: FND_MSG_PUB.ADD;
932: ELSE
933: l_return_status := true;
934: END IF;

Line 941: FND_MESSAGE.set_name('IBE','IBE_DSP_LGLCTNT_ID_NOT_EXISTS');

937: OPEN lgl_ctnt_version_cur(p_lgl_ctnt_id ,p_object_version_number);
938: FETCH lgl_ctnt_version_cur INTO l_exists;
939: IF lgl_ctnt_version_cur%NOTFOUND
940: THEN
941: FND_MESSAGE.set_name('IBE','IBE_DSP_LGLCTNT_ID_NOT_EXISTS');
942: FND_MESSAGE.set_token('ID',p_lgl_ctnt_id);
943: FND_MSG_PUB.ADD;
944: ELSE
945: l_return_status := true;

Line 942: FND_MESSAGE.set_token('ID',p_lgl_ctnt_id);

938: FETCH lgl_ctnt_version_cur INTO l_exists;
939: IF lgl_ctnt_version_cur%NOTFOUND
940: THEN
941: FND_MESSAGE.set_name('IBE','IBE_DSP_LGLCTNT_ID_NOT_EXISTS');
942: FND_MESSAGE.set_token('ID',p_lgl_ctnt_id);
943: FND_MSG_PUB.ADD;
944: ELSE
945: l_return_status := true;
946: END IF;

Line 1000: FND_MESSAGE.set_name('IBE', 'IBE_DSP_ATH_FILENAME_REQ');

996: BEGIN
997:
998: IF TRIM(p_file_name) IS NULL THEN
999: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1000: FND_MESSAGE.set_name('IBE', 'IBE_DSP_ATH_FILENAME_REQ');
1001: FND_MSG_PUB.add;
1002: END IF;
1003:
1004: ELSE

Line 1033: FND_MESSAGE.set_name('IBE','IBE_DSP_ATH_FILENAME_EXISTS');

1029: EXCEPTION
1030:
1031: WHEN l_dup_file_exception THEN
1032: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1033: FND_MESSAGE.set_name('IBE','IBE_DSP_ATH_FILENAME_EXISTS');
1034: FND_MESSAGE.set_token('FILE_NAME', p_file_name);
1035: FND_MSG_PUB.ADD;
1036: END IF;
1037: RETURN l_return_status;

Line 1034: FND_MESSAGE.set_token('FILE_NAME', p_file_name);

1030:
1031: WHEN l_dup_file_exception THEN
1032: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1033: FND_MESSAGE.set_name('IBE','IBE_DSP_ATH_FILENAME_EXISTS');
1034: FND_MESSAGE.set_token('FILE_NAME', p_file_name);
1035: FND_MSG_PUB.ADD;
1036: END IF;
1037: RETURN l_return_status;
1038:

Line 1118: FND_MESSAGE.set_name('IBE', 'IBE_MSITE_NOT_EXISTS');

1114: EXCEPTION
1115:
1116: WHEN l_msite_not_exists_exception THEN
1117: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1118: FND_MESSAGE.set_name('IBE', 'IBE_MSITE_NOT_EXISTS');
1119: FND_MESSAGE.set_token('ID', TO_CHAR(p_msite_id));
1120: FND_MSG_PUB.add;
1121: END IF;
1122: RETURN l_return_status;

Line 1119: FND_MESSAGE.set_token('ID', TO_CHAR(p_msite_id));

1115:
1116: WHEN l_msite_not_exists_exception THEN
1117: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1118: FND_MESSAGE.set_name('IBE', 'IBE_MSITE_NOT_EXISTS');
1119: FND_MESSAGE.set_token('ID', TO_CHAR(p_msite_id));
1120: FND_MSG_PUB.add;
1121: END IF;
1122: RETURN l_return_status;
1123:

Line 1176: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_NOT_EXISTS');

1172: EXCEPTION
1173:
1174: WHEN l_map_not_exists_exception THEN
1175: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1176: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_NOT_EXISTS');
1177: FND_MESSAGE.set_token('ID', TO_CHAR(p_lgl_phys_map_id));
1178: FND_MSG_PUB.add;
1179: END IF;
1180: RETURN l_return_status;

Line 1177: FND_MESSAGE.set_token('ID', TO_CHAR(p_lgl_phys_map_id));

1173:
1174: WHEN l_map_not_exists_exception THEN
1175: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1176: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_NOT_EXISTS');
1177: FND_MESSAGE.set_token('ID', TO_CHAR(p_lgl_phys_map_id));
1178: FND_MSG_PUB.add;
1179: END IF;
1180: RETURN l_return_status;
1181:

Line 1229: FND_MESSAGE.set_name('IBE', 'IBE_DSP_DLV_ACCNAME_REQ');

1225: BEGIN
1226:
1227: IF TRIM(p_access_name) IS NULL THEN
1228: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1229: FND_MESSAGE.set_name('IBE', 'IBE_DSP_DLV_ACCNAME_REQ');
1230: FND_MSG_PUB.add;
1231: END IF;
1232:
1233: ELSE

Line 1263: FND_MESSAGE.set_name('IBE', 'IBE_DSP_DLV_ACCNAME_EXISTS');

1259: EXCEPTION
1260:
1261: WHEN l_dup_access_exception THEN
1262: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1263: FND_MESSAGE.set_name('IBE', 'IBE_DSP_DLV_ACCNAME_EXISTS');
1264: FND_MESSAGE.set_token('ACC_NAME', p_access_name);
1265: FND_MSG_PUB.add;
1266: END IF;
1267: RETURN l_return_status;

Line 1264: FND_MESSAGE.set_token('ACC_NAME', p_access_name);

1260:
1261: WHEN l_dup_access_exception THEN
1262: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1263: FND_MESSAGE.set_name('IBE', 'IBE_DSP_DLV_ACCNAME_EXISTS');
1264: FND_MESSAGE.set_token('ACC_NAME', p_access_name);
1265: FND_MSG_PUB.add;
1266: END IF;
1267: RETURN l_return_status;
1268:

Line 1327: FND_MESSAGE.set_name('IBE', 'IBE_MSITE_LANG_NOT_SUPP' );

1323: EXCEPTION
1324:
1325: WHEN l_lang_not_supp_exception THEN
1326: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1327: FND_MESSAGE.set_name('IBE', 'IBE_MSITE_LANG_NOT_SUPP' );
1328: FND_MESSAGE.set_token('ID', TO_CHAR(p_msite_id));
1329: FND_MESSAGE.set_token('LANG', p_language_code);
1330: FND_MSG_PUB.add;
1331: END IF;

Line 1328: FND_MESSAGE.set_token('ID', TO_CHAR(p_msite_id));

1324:
1325: WHEN l_lang_not_supp_exception THEN
1326: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1327: FND_MESSAGE.set_name('IBE', 'IBE_MSITE_LANG_NOT_SUPP' );
1328: FND_MESSAGE.set_token('ID', TO_CHAR(p_msite_id));
1329: FND_MESSAGE.set_token('LANG', p_language_code);
1330: FND_MSG_PUB.add;
1331: END IF;
1332: return l_return_status;

Line 1329: FND_MESSAGE.set_token('LANG', p_language_code);

1325: WHEN l_lang_not_supp_exception THEN
1326: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1327: FND_MESSAGE.set_name('IBE', 'IBE_MSITE_LANG_NOT_SUPP' );
1328: FND_MESSAGE.set_token('ID', TO_CHAR(p_msite_id));
1329: FND_MESSAGE.set_token('LANG', p_language_code);
1330: FND_MSG_PUB.add;
1331: END IF;
1332: return l_return_status;
1333:

Line 1374: FND_MESSAGE.set_name('IBE', 'IBE_DSP_ITEM_DLV_INVLD');

1370:
1371: CLOSE item_dlv_cur;
1372:
1373: if l_return_status = false then
1374: FND_MESSAGE.set_name('IBE', 'IBE_DSP_ITEM_DLV_INVLD');
1375: FND_MESSAGE.set_token('ITEM_ID', p_item_id);
1376: FND_MESSAGE.set_token('ID', p_deliverable_id);
1377: FND_MSG_PUB.add;
1378: END IF;

Line 1375: FND_MESSAGE.set_token('ITEM_ID', p_item_id);

1371: CLOSE item_dlv_cur;
1372:
1373: if l_return_status = false then
1374: FND_MESSAGE.set_name('IBE', 'IBE_DSP_ITEM_DLV_INVLD');
1375: FND_MESSAGE.set_token('ITEM_ID', p_item_id);
1376: FND_MESSAGE.set_token('ID', p_deliverable_id);
1377: FND_MSG_PUB.add;
1378: END IF;
1379: else

Line 1376: FND_MESSAGE.set_token('ID', p_deliverable_id);

1372:
1373: if l_return_status = false then
1374: FND_MESSAGE.set_name('IBE', 'IBE_DSP_ITEM_DLV_INVLD');
1375: FND_MESSAGE.set_token('ITEM_ID', p_item_id);
1376: FND_MESSAGE.set_token('ID', p_deliverable_id);
1377: FND_MSG_PUB.add;
1378: END IF;
1379: else
1380: FND_MESSAGE.set_name('IBE', 'IBE_DSP_ITEM_DLV_REQ');

Line 1380: FND_MESSAGE.set_name('IBE', 'IBE_DSP_ITEM_DLV_REQ');

1376: FND_MESSAGE.set_token('ID', p_deliverable_id);
1377: FND_MSG_PUB.add;
1378: END IF;
1379: else
1380: FND_MESSAGE.set_name('IBE', 'IBE_DSP_ITEM_DLV_REQ');
1381: FND_MSG_PUB.add;
1382: END IF;
1383:
1384:

Line 1426: FND_MESSAGE.set_name('IBE', 'IBE_DSP_CATEGORY_DLV_INVLD');

1422: open category_dlv_cur(p_category_id,p_deliverable_id);
1423: FETCH category_dlv_cur INTO l_exists;
1424: IF category_dlv_cur%NOTFOUND THEN
1425: CLOSE category_dlv_cur;
1426: FND_MESSAGE.set_name('IBE', 'IBE_DSP_CATEGORY_DLV_INVLD');
1427: FND_MESSAGE.set_token('CATEGORY_ID', p_category_id);
1428: FND_MESSAGE.set_token('ID', p_deliverable_id);
1429: FND_MSG_PUB.add;
1430: l_return_status := false;

Line 1427: FND_MESSAGE.set_token('CATEGORY_ID', p_category_id);

1423: FETCH category_dlv_cur INTO l_exists;
1424: IF category_dlv_cur%NOTFOUND THEN
1425: CLOSE category_dlv_cur;
1426: FND_MESSAGE.set_name('IBE', 'IBE_DSP_CATEGORY_DLV_INVLD');
1427: FND_MESSAGE.set_token('CATEGORY_ID', p_category_id);
1428: FND_MESSAGE.set_token('ID', p_deliverable_id);
1429: FND_MSG_PUB.add;
1430: l_return_status := false;
1431: else

Line 1428: FND_MESSAGE.set_token('ID', p_deliverable_id);

1424: IF category_dlv_cur%NOTFOUND THEN
1425: CLOSE category_dlv_cur;
1426: FND_MESSAGE.set_name('IBE', 'IBE_DSP_CATEGORY_DLV_INVLD');
1427: FND_MESSAGE.set_token('CATEGORY_ID', p_category_id);
1428: FND_MESSAGE.set_token('ID', p_deliverable_id);
1429: FND_MSG_PUB.add;
1430: l_return_status := false;
1431: else
1432: CLOSE category_dlv_cur;

Line 1436: FND_MESSAGE.set_name('IBE', 'IBE_DSP_CATEGORY_DLV_REQ');

1432: CLOSE category_dlv_cur;
1433: l_return_status := true;
1434: END IF;
1435: else
1436: FND_MESSAGE.set_name('IBE', 'IBE_DSP_CATEGORY_DLV_REQ');
1437: FND_MSG_PUB.add;
1438: END IF;
1439:
1440: return l_return_status;

Line 1473: FND_MESSAGE.set_name('IBE', 'IBE_MSITE_MASTER_NOT_EXISTS');

1469: FETCH msite_cur INTO l_msite_id;
1470: close msite_cur;
1471:
1472: if l_msite_id is null then
1473: FND_MESSAGE.set_name('IBE', 'IBE_MSITE_MASTER_NOT_EXISTS');
1474: FND_MSG_PUB.add;
1475: END IF;
1476:
1477: return l_msite_id;

Line 1629: FND_MESSAGE.set_name('IBE','IBE_DSP_DLV_ATH_INVLD');

1625: END IF;
1626:
1627: IF NOT l_return_status THEN
1628: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1629: FND_MESSAGE.set_name('IBE','IBE_DSP_DLV_ATH_INVLD');
1630: FND_MESSAGE.set_token('ID', TO_CHAR(p_deliverable_id));
1631: FND_MESSAGE.set_token('ATH_ID', TO_CHAR(p_attachment_id));
1632: FND_MSG_PUB.ADD;
1633: END IF;

Line 1630: FND_MESSAGE.set_token('ID', TO_CHAR(p_deliverable_id));

1626:
1627: IF NOT l_return_status THEN
1628: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1629: FND_MESSAGE.set_name('IBE','IBE_DSP_DLV_ATH_INVLD');
1630: FND_MESSAGE.set_token('ID', TO_CHAR(p_deliverable_id));
1631: FND_MESSAGE.set_token('ATH_ID', TO_CHAR(p_attachment_id));
1632: FND_MSG_PUB.ADD;
1633: END IF;
1634: END IF;

Line 1631: FND_MESSAGE.set_token('ATH_ID', TO_CHAR(p_attachment_id));

1627: IF NOT l_return_status THEN
1628: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1629: FND_MESSAGE.set_name('IBE','IBE_DSP_DLV_ATH_INVLD');
1630: FND_MESSAGE.set_token('ID', TO_CHAR(p_deliverable_id));
1631: FND_MESSAGE.set_token('ATH_ID', TO_CHAR(p_attachment_id));
1632: FND_MSG_PUB.ADD;
1633: END IF;
1634: END IF;
1635:

Line 1708: FND_MESSAGE.set_name('IBE','IBE_MSITE_DUP_ACCNAME');

1704: Fetch C_Exists INTO l_exists;
1705: If C_Exists%FOUND Then
1706: l_status := FALSE ;
1707: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1708: FND_MESSAGE.set_name('IBE','IBE_MSITE_DUP_ACCNAME');
1709: FND_MESSAGE.set_token('ACCNAME',p_access_name);
1710: FND_MSG_PUB.ADD;
1711: END IF;
1712: Else

Line 1709: FND_MESSAGE.set_token('ACCNAME',p_access_name);

1705: If C_Exists%FOUND Then
1706: l_status := FALSE ;
1707: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1708: FND_MESSAGE.set_name('IBE','IBE_MSITE_DUP_ACCNAME');
1709: FND_MESSAGE.set_token('ACCNAME',p_access_name);
1710: FND_MSG_PUB.ADD;
1711: END IF;
1712: Else
1713: l_status := TRUE ;