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.IBE_DSPMGRVALIDATION_GRP dependencies on FND_MSG_PUB

Line 69: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

65:
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;

Line 72: FND_MSG_PUB.ADD;

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:
76: WHEN OTHERS THEN

Line 77: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

73: END IF;
74: RETURN l_return_status;
75:
76: WHEN OTHERS THEN
77: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
78: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
79: END IF;
80: RETURN l_return_status;
81:

Line 78: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

74: RETURN l_return_status;
75:
76: WHEN OTHERS THEN
77: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
78: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
79: END IF;
80: RETURN l_return_status;
81:
82: END check_attachment_exists;

Line 124: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

120:
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;

Line 127: FND_MSG_PUB.ADD;

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:
131: WHEN OTHERS THEN

Line 132: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

128: END IF;
129: RETURN NULL;
130:
131: WHEN OTHERS THEN
132: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
133: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
134: END IF;
135: RETURN NULL;
136:

Line 133: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

129: RETURN NULL;
130:
131: WHEN OTHERS THEN
132: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
133: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
134: END IF;
135: RETURN NULL;
136:
137: END check_attachment_deliverable;

Line 168: FND_MSG_PUB.ADD;

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:
172: return l_type_code;

Line 176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

172: return l_type_code;
173:
174: EXCEPTION
175: WHEN OTHERS THEN
176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
177: THEN
178: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
179: END IF;
180: return l_type_code;

Line 178: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

174: EXCEPTION
175: WHEN OTHERS THEN
176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
177: THEN
178: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
179: END IF;
180: return l_type_code;
181: END check_context_type_code;
182:

Line 228: FND_MSG_PUB.ADD;

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;
232: CLOSE context_cur;

Line 240: FND_MSG_PUB.ADD;

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;
244: CLOSE context_version_cur;

Line 250: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

246: return l_return_status;
247:
248: EXCEPTION
249: WHEN OTHERS THEN
250: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
251: THEN
252: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
253: END IF;
254: return l_return_status;

Line 252: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

248: EXCEPTION
249: WHEN OTHERS THEN
250: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
251: THEN
252: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
253: END IF;
254: return l_return_status;
255: END check_context_exists;
256: ----------------------------------------------------------------------------------------

Line 288: FND_MSG_PUB.ADD;

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;
292: end if;

Line 299: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

295: return l_return_status;
296:
297: EXCEPTION
298: WHEN OTHERS THEN
299: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
300: THEN
301: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
302: END IF;
303: return l_return_status;

Line 301: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

297: EXCEPTION
298: WHEN OTHERS THEN
299: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
300: THEN
301: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
302: END IF;
303: return l_return_status;
304: END check_valid_context_type;
305:

Line 352: FND_MSG_PUB.ADD;

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;
356: end if;

Line 362: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

358: return l_return_status;
359:
360: EXCEPTION
361: WHEN OTHERS THEN
362: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
363: THEN
364: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
365: END IF;
366: return l_return_status;

Line 364: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

360: EXCEPTION
361: WHEN OTHERS THEN
362: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
363: THEN
364: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
365: END IF;
366: return l_return_status;
367: END check_valid_object_type;
368: ----------------------------------------------------------------------------------------

Line 434: FND_MSG_PUB.ADD;

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;
438:

Line 441: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

437: return l_return_status;
438:
439: EXCEPTION
440: WHEN OTHERS THEN
441: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
442: THEN
443: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
444: END IF;
445: return l_return_status;

Line 443: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

439: EXCEPTION
440: WHEN OTHERS THEN
441: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
442: THEN
443: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
444: END IF;
445: return l_return_status;
446: END check_context_accessname;
447: ----------------------------------------------------------------------------------------

Line 483: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

479: return l_return_status;
480:
481: EXCEPTION
482: WHEN OTHERS THEN
483: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
484: THEN
485: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
486: END IF;
487: return l_return_status;

Line 485: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

481: EXCEPTION
482: WHEN OTHERS THEN
483: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
484: THEN
485: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
486: END IF;
487: return l_return_status;
488: END check_ctg_tpl_relation_exists;
489:

Line 520: FND_MSG_PUB.ADD;

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;
524: CLOSE category_cur;

Line 530: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

526: return l_return_status;
527:
528: EXCEPTION
529: WHEN OTHERS THEN
530: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
531: THEN
532: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
533: END IF;
534: return l_return_status;

Line 532: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

528: EXCEPTION
529: WHEN OTHERS THEN
530: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
531: THEN
532: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
533: END IF;
534: return l_return_status;
535: END check_category_exists;
536:

Line 567: FND_MSG_PUB.ADD;

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;
571: CLOSE item_cur;

Line 577: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

573: return l_return_status;
574:
575: EXCEPTION
576: WHEN OTHERS THEN
577: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
578: THEN
579: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
580: END IF;
581: return l_return_status;

Line 579: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

575: EXCEPTION
576: WHEN OTHERS THEN
577: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
578: THEN
579: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
580: END IF;
581: return l_return_status;
582: END check_item_exists;
583:

Line 614: FND_MSG_PUB.ADD;

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;
617: END IF;
618: CLOSE section_cur;

Line 624: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

620: return l_return_status;
621:
622: EXCEPTION
623: WHEN OTHERS THEN
624: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
625: THEN
626: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
627: END IF;
628: ---dbms_output.put_line('returning false status error');

Line 626: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

622: EXCEPTION
623: WHEN OTHERS THEN
624: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
625: THEN
626: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
627: END IF;
628: ---dbms_output.put_line('returning false status error');
629: return l_return_status;
630: END check_section_exists;

Line 657: FND_MSG_PUB.ADD;

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;
661: CLOSE section_cur;

Line 667: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

663: return l_return_status;
664:
665: EXCEPTION
666: WHEN OTHERS THEN
667: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
668: THEN
669: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
670: END IF;
671: ---dbms_output.put_line('returning false status error');

Line 669: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

665: EXCEPTION
666: WHEN OTHERS THEN
667: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
668: THEN
669: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
670: END IF;
671: ---dbms_output.put_line('returning false status error');
672: return l_return_status;
673: END check_root_section_exists;

Line 717: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

713: return l_return_status;
714:
715: EXCEPTION
716: WHEN OTHERS THEN
717: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
718: THEN
719: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
720: END IF;
721: return l_return_status;

Line 719: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

715: EXCEPTION
716: WHEN OTHERS THEN
717: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
718: THEN
719: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
720: END IF;
721: return l_return_status;
722: END check_lgl_object_exists;
723:

Line 792: FND_MSG_PUB.add;

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;
796:

Line 800: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

796:
797: EXCEPTION
798:
799: WHEN OTHERS THEN
800: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
801: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
802: END IF;
803: return l_return_status;
804:

Line 801: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

797: EXCEPTION
798:
799: WHEN OTHERS THEN
800: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
801: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
802: END IF;
803: return l_return_status;
804:
805: END check_deliverable_type_exists;

Line 875: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

871:
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;

Line 878: FND_MSG_PUB.add;

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:
882: WHEN OTHERS THEN

Line 883: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

879: END IF;
880: RETURN l_return_status;
881:
882: WHEN OTHERS THEN
883: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
884: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
885: END IF;
886: return l_return_status;
887:

Line 884: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

880: RETURN l_return_status;
881:
882: WHEN OTHERS THEN
883: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
884: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
885: END IF;
886: return l_return_status;
887:
888: END check_deliverable_exists;

Line 931: FND_MSG_PUB.ADD;

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;
935: CLOSE lgl_ctnt_cur;

Line 943: FND_MSG_PUB.ADD;

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;
947: CLOSE lgl_ctnt_version_cur;

Line 954: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

950: return l_return_status;
951:
952: EXCEPTION
953: WHEN OTHERS THEN
954: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
955: THEN
956: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
957: END IF;
958: return l_return_status;

Line 956: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

952: EXCEPTION
953: WHEN OTHERS THEN
954: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
955: THEN
956: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
957: END IF;
958: return l_return_status;
959: END check_lgl_ctnt_id_exists;
960:

Line 999: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

995:
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:

Line 1001: FND_MSG_PUB.add;

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
1005: IF p_attachment_id IS NOT NULL THEN

Line 1032: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1028:
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;

Line 1035: FND_MSG_PUB.ADD;

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:
1039: WHEN OTHERS THEN

Line 1040: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1036: END IF;
1037: RETURN l_return_status;
1038:
1039: WHEN OTHERS THEN
1040: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1041: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1042: END IF;
1043: RETURN l_return_status;
1044:

Line 1041: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1037: RETURN l_return_status;
1038:
1039: WHEN OTHERS THEN
1040: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1041: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1042: END IF;
1043: RETURN l_return_status;
1044:
1045: END check_attachment_filename;

Line 1117: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1113:
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;

Line 1120: FND_MSG_PUB.add;

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:
1124: WHEN OTHERS THEN

Line 1125: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1121: END IF;
1122: RETURN l_return_status;
1123:
1124: WHEN OTHERS THEN
1125: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1126: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1127: END IF;
1128: return l_return_status;
1129:

Line 1126: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1122: RETURN l_return_status;
1123:
1124: WHEN OTHERS THEN
1125: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1126: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1127: END IF;
1128: return l_return_status;
1129:
1130: END check_msite_exists;

Line 1175: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1171:
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;

Line 1178: FND_MSG_PUB.add;

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:
1182: WHEN OTHERS THEN

Line 1183: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1179: END IF;
1180: RETURN l_return_status;
1181:
1182: WHEN OTHERS THEN
1183: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1184: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1185: END IF;
1186: return l_return_status;
1187:

Line 1184: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1180: RETURN l_return_status;
1181:
1182: WHEN OTHERS THEN
1183: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1184: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1185: END IF;
1186: return l_return_status;
1187:
1188: END check_physicalmap_exists;

Line 1228: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1224:
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:

Line 1230: FND_MSG_PUB.add;

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
1234: IF p_deliverable_id IS NOT NULL THEN

Line 1262: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1258:
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;

Line 1265: FND_MSG_PUB.add;

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:
1269: WHEN OTHERS THEN

Line 1270: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1266: END IF;
1267: RETURN l_return_status;
1268:
1269: WHEN OTHERS THEN
1270: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1271: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1272: END IF;
1273: RETURN l_return_status;
1274:

Line 1271: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1267: RETURN l_return_status;
1268:
1269: WHEN OTHERS THEN
1270: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1271: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1272: END IF;
1273: RETURN l_return_status;
1274:
1275: END check_deliverable_accessname;

Line 1326: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1322:
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;

Line 1330: FND_MSG_PUB.add;

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:
1334: WHEN OTHERS THEN

Line 1335: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1331: END IF;
1332: return l_return_status;
1333:
1334: WHEN OTHERS THEN
1335: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1336: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1337: END IF;
1338: return l_return_status;
1339:

Line 1336: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1332: return l_return_status;
1333:
1334: WHEN OTHERS THEN
1335: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1336: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1337: END IF;
1338: return l_return_status;
1339:
1340: END check_language_supported;

Line 1377: FND_MSG_PUB.add;

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');
1381: FND_MSG_PUB.add;

Line 1381: FND_MSG_PUB.add;

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:
1385: return l_return_status;

Line 1389: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1385: return l_return_status;
1386:
1387: EXCEPTION
1388: WHEN OTHERS THEN
1389: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1390: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1391: END IF;
1392: return false;
1393: */

Line 1390: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1386:
1387: EXCEPTION
1388: WHEN OTHERS THEN
1389: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1390: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1391: END IF;
1392: return false;
1393: */
1394: end check_item_deliverable;

Line 1429: FND_MSG_PUB.add;

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;
1433: l_return_status := true;

Line 1437: FND_MSG_PUB.add;

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;
1441:

Line 1444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1440: return l_return_status;
1441:
1442: EXCEPTION
1443: WHEN OTHERS THEN
1444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1445: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1446: END IF;
1447: return false;
1448:

Line 1445: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1441:
1442: EXCEPTION
1443: WHEN OTHERS THEN
1444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1445: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1446: END IF;
1447: return false;
1448:
1449: end check_category_deliverable;

Line 1474: FND_MSG_PUB.add;

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;
1478:

Line 1482: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1478:
1479: EXCEPTION
1480:
1481: WHEN OTHERS THEN
1482: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1483: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1484: END IF;
1485: return l_msite_id;
1486:

Line 1483: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1479: EXCEPTION
1480:
1481: WHEN OTHERS THEN
1482: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1483: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1484: END IF;
1485: return l_msite_id;
1486:
1487: END check_master_msite_exists;

Line 1513: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1509:
1510: EXCEPTION
1511:
1512: WHEN OTHERS THEN
1513: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1514: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1515: END IF;
1516: RETURN NULL;
1517:

Line 1514: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1510: EXCEPTION
1511:
1512: WHEN OTHERS THEN
1513: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1514: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1515: END IF;
1516: RETURN NULL;
1517:
1518: END check_attachment_exists;

Line 1586: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1582:
1583: EXCEPTION
1584:
1585: WHEN OTHERS THEN
1586: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1587: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1588: END IF;
1589: RETURN NULL;
1590:

Line 1587: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1583: EXCEPTION
1584:
1585: WHEN OTHERS THEN
1586: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1587: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1588: END IF;
1589: RETURN NULL;
1590:
1591: END check_attachment_exists;

Line 1628: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1624: CLOSE attachment_cur;
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;

Line 1632: FND_MSG_PUB.ADD;

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:
1636: RETURN l_return_status;

Line 1641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1637:
1638: EXCEPTION
1639:
1640: WHEN OTHERS THEN
1641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1642: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1643: END IF;
1644: RETURN l_return_status;
1645:

Line 1642: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1638: EXCEPTION
1639:
1640: WHEN OTHERS THEN
1641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1642: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1643: END IF;
1644: RETURN l_return_status;
1645:
1646: END check_attachment_deliverable;

Line 1680: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1676:
1677: EXCEPTION
1678:
1679: WHEN OTHERS THEN
1680: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1681: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1682: END IF;
1683: RETURN FALSE;
1684:

Line 1681: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1677: EXCEPTION
1678:
1679: WHEN OTHERS THEN
1680: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1681: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1682: END IF;
1683: RETURN FALSE;
1684:
1685: END check_default_attachment;

Line 1707: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1703: Open C_Exists(p_access_name);
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;

Line 1710: FND_MSG_PUB.ADD;

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 ;
1714: End If;