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

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

63:
64: EXCEPTION
65:
66: WHEN l_ath_not_exists_exception THEN
67: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
68: FND_MESSAGE.set_name('JTF','JTF_DSP_ATH_NOT_EXISTS');
69: FND_MESSAGE.set_token('ID', TO_CHAR(p_attachment_id));
70: FND_MSG_PUB.ADD;
71: END IF;

Line 70: FND_MSG_PUB.ADD;

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

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

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

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

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

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

118:
119: EXCEPTION
120:
121: WHEN l_ath_not_exists_exception THEN
122: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
123: FND_MESSAGE.set_name('JTF','JTF_DSP_ATH_NOT_EXISTS');
124: FND_MESSAGE.set_token('ID', TO_CHAR(p_attachment_id));
125: FND_MSG_PUB.ADD;
126: END IF;

Line 125: FND_MSG_PUB.ADD;

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

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

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

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

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

Line 166: FND_MSG_PUB.ADD;

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

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

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

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

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

Line 224: FND_MSG_PUB.ADD;

220: IF context_cur%NOTFOUND
221: THEN
222: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_NOT_EXISTS');
223: FND_MESSAGE.set_token('ID', p_context_id);
224: FND_MSG_PUB.ADD;
225: ELSE
226: l_return_status := true;
227: END IF;
228: CLOSE context_cur;

Line 236: FND_MSG_PUB.ADD;

232: IF context_version_cur%NOTFOUND
233: THEN
234: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_NOT_EXISTS');
235: FND_MESSAGE.set_token('ID', p_context_id);
236: FND_MSG_PUB.ADD;
237: ELSE
238: l_return_status := true;
239: END IF;
240: CLOSE context_version_cur;

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

242: return l_return_status;
243:
244: EXCEPTION
245: WHEN OTHERS THEN
246: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
247: THEN
248: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
249: END IF;
250: return l_return_status;

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

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

Line 284: FND_MSG_PUB.ADD;

280: IF valid_context_cur%NOTFOUND then
281: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_TYPE_INVLD');
282: FND_MESSAGE.set_token('TYPE', l_context_type);
283: FND_MESSAGE.set_token('ID', to_char(null));
284: FND_MSG_PUB.ADD;
285: l_return_status := false;
286: ELSE
287: l_return_status := true;
288: end if;

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

291: return l_return_status;
292:
293: EXCEPTION
294: WHEN OTHERS THEN
295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
296: THEN
297: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
298: END IF;
299: return l_return_status;

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

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

Line 347: FND_MSG_PUB.ADD;

343: FETCH valid_object_cur into l_exists;
344: IF valid_object_cur%NOTFOUND then
345: FND_MESSAGE.set_name('JTF','JTF_DSP_LGLCTNT_OBJTYPE_INVLD');
346: FND_MESSAGE.set_token('TYPE', l_object_type_code);
347: FND_MSG_PUB.ADD;
348: l_return_status := false;
349: ELSE
350: l_return_status := true;
351: end if;

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

353: return l_return_status;
354:
355: EXCEPTION
356: WHEN OTHERS THEN
357: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
358: THEN
359: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
360: END IF;
361: return l_return_status;

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

355: EXCEPTION
356: WHEN OTHERS THEN
357: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
358: THEN
359: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
360: END IF;
361: return l_return_status;
362: END check_valid_object_type;
363: ----------------------------------------------------------------------------------------

Line 427: FND_MSG_PUB.ADD;

423:
424: if not l_return_status then
425: FND_MESSAGE.set_name('JTF','JTF_DSP_CONTEXT_ACCNAME_EXISTS');
426: FND_MESSAGE.set_token('ACC_NAME', l_context_accessname);
427: FND_MSG_PUB.ADD;
428: end if;
429:
430: return l_return_status;
431:

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

430: return l_return_status;
431:
432: EXCEPTION
433: WHEN OTHERS THEN
434: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
435: THEN
436: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
437: END IF;
438: return l_return_status;

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

432: EXCEPTION
433: WHEN OTHERS THEN
434: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
435: THEN
436: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
437: END IF;
438: return l_return_status;
439: END check_context_accessname;
440: ----------------------------------------------------------------------------------------

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

469: return l_return_status;
470:
471: EXCEPTION
472: WHEN OTHERS THEN
473: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
474: THEN
475: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
476: END IF;
477: return l_return_status;

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

471: EXCEPTION
472: WHEN OTHERS THEN
473: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
474: THEN
475: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
476: END IF;
477: return l_return_status;
478: END check_ctg_tpl_relation_exists;
479:

Line 508: FND_MSG_PUB.ADD;

504: IF category_cur%NOTFOUND
505: THEN
506: FND_MESSAGE.set_name('JTF','JTF_DSP_CATEGORY_NOT_EXISTS');
507: FND_MESSAGE.set_token('ID',p_category_id);
508: FND_MSG_PUB.ADD;
509: ELSE
510: l_return_status := true;
511: END IF;
512: CLOSE category_cur;

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

514: return l_return_status;
515:
516: EXCEPTION
517: WHEN OTHERS THEN
518: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
519: THEN
520: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
521: END IF;
522: return l_return_status;

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

516: EXCEPTION
517: WHEN OTHERS THEN
518: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
519: THEN
520: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
521: END IF;
522: return l_return_status;
523: END check_category_exists;
524:

Line 554: FND_MSG_PUB.ADD;

550: IF item_cur%NOTFOUND
551: THEN
552: FND_MESSAGE.set_name('JTF','JTF_DSP_ITEM_NOT_EXISTS');
553: FND_MESSAGE.set_token('ID',p_item_id);
554: FND_MSG_PUB.ADD;
555: ELSE
556: l_return_status := true;
557: END IF;
558: CLOSE item_cur;

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

560: return l_return_status;
561:
562: EXCEPTION
563: WHEN OTHERS THEN
564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
565: THEN
566: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
567: END IF;
568: return l_return_status;

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

562: EXCEPTION
563: WHEN OTHERS THEN
564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
565: THEN
566: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
567: END IF;
568: return l_return_status;
569: END check_item_exists;
570:

Line 600: FND_MSG_PUB.ADD;

596: THEN
597: FND_MESSAGE.set_name('JTF','JTF_DSP_SECTION_NOT_EXISTS');
598: FND_MESSAGE.set_token('ID',p_section_id);
599:
600: FND_MSG_PUB.ADD;
601: ELSE
602: l_return_status := true;
603: END IF;
604: CLOSE section_cur;

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

606: return l_return_status;
607:
608: EXCEPTION
609: WHEN OTHERS THEN
610: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
611: THEN
612: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
613: END IF;
614: ---dbms_output.put_line('returning false status error');

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

608: EXCEPTION
609: WHEN OTHERS THEN
610: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
611: THEN
612: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
613: END IF;
614: ---dbms_output.put_line('returning false status error');
615: return l_return_status;
616: END check_section_exists;

Line 642: FND_MSG_PUB.ADD;

638: IF section_cur%NOTFOUND
639: THEN
640: FND_MESSAGE.set_name('JTF','JTF_MSITE_RSECID_INVLD');
641: FND_MESSAGE.set_token('ID',p_root_section_id);
642: FND_MSG_PUB.ADD;
643: ELSE
644: l_return_status := true;
645: END IF;
646: CLOSE section_cur;

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

648: return l_return_status;
649:
650: EXCEPTION
651: WHEN OTHERS THEN
652: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
653: THEN
654: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
655: END IF;
656: ---dbms_output.put_line('returning false status error');

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

650: EXCEPTION
651: WHEN OTHERS THEN
652: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
653: THEN
654: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
655: END IF;
656: ---dbms_output.put_line('returning false status error');
657: return l_return_status;
658: END check_root_section_exists;

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

698: return l_return_status;
699:
700: EXCEPTION
701: WHEN OTHERS THEN
702: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
703: THEN
704: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
705: END IF;
706: return l_return_status;

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

700: EXCEPTION
701: WHEN OTHERS THEN
702: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
703: THEN
704: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
705: END IF;
706: return l_return_status;
707: END check_lgl_object_exists;
708:

Line 770: FND_MSG_PUB.add;

766: if l_return_status = false then
767: FND_MESSAGE.set_name('JTF','JTF_DSP_DLV_TYPE_NOT_EXISTS');
768: FND_MESSAGE.set_token('ID', p_deliverable_id);
769: FND_MESSAGE.set_token('TYPE', p_item_type);
770: FND_MSG_PUB.add;
771: end if;
772:
773: return l_return_status;
774:

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

774:
775: EXCEPTION
776:
777: WHEN OTHERS THEN
778: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
779: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
780: END IF;
781: return l_return_status;
782:

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

775: EXCEPTION
776:
777: WHEN OTHERS THEN
778: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
779: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
780: END IF;
781: return l_return_status;
782:
783: END check_deliverable_type_exists;

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

847:
848: EXCEPTION
849:
850: WHEN l_dlv_not_exists_exception THEN
851: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
852: FND_MESSAGE.set_name('JTF','JTF_DSP_DLV_NOT_EXISTS');
853: FND_MESSAGE.set_token('ID', TO_CHAR(p_deliverable_id));
854: FND_MSG_PUB.add;
855: END IF;

Line 854: FND_MSG_PUB.add;

850: WHEN l_dlv_not_exists_exception THEN
851: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
852: FND_MESSAGE.set_name('JTF','JTF_DSP_DLV_NOT_EXISTS');
853: FND_MESSAGE.set_token('ID', TO_CHAR(p_deliverable_id));
854: FND_MSG_PUB.add;
855: END IF;
856: RETURN l_return_status;
857:
858: WHEN OTHERS THEN

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

855: END IF;
856: RETURN l_return_status;
857:
858: WHEN OTHERS THEN
859: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
860: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
861: END IF;
862: return l_return_status;
863:

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

856: RETURN l_return_status;
857:
858: WHEN OTHERS THEN
859: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
860: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
861: END IF;
862: return l_return_status;
863:
864: END check_deliverable_exists;

Line 905: FND_MSG_PUB.ADD;

901: IF lgl_ctnt_cur%NOTFOUND
902: THEN
903: FND_MESSAGE.set_name('JTF','JTF_DSP_LGLCTNT_ID_NOT_EXISTS');
904: FND_MESSAGE.set_token('ID',p_lgl_ctnt_id);
905: FND_MSG_PUB.ADD;
906: ELSE
907: l_return_status := true;
908: END IF;
909: CLOSE lgl_ctnt_cur;

Line 917: FND_MSG_PUB.ADD;

913: IF lgl_ctnt_version_cur%NOTFOUND
914: THEN
915: FND_MESSAGE.set_name('JTF','JTF_DSP_LGLCTNT_ID_NOT_EXISTS');
916: FND_MESSAGE.set_token('ID',p_lgl_ctnt_id);
917: FND_MSG_PUB.ADD;
918: ELSE
919: l_return_status := true;
920: END IF;
921: CLOSE lgl_ctnt_version_cur;

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

924: return l_return_status;
925:
926: EXCEPTION
927: WHEN OTHERS THEN
928: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
929: THEN
930: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
931: END IF;
932: return l_return_status;

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

926: EXCEPTION
927: WHEN OTHERS THEN
928: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
929: THEN
930: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
931: END IF;
932: return l_return_status;
933: END check_lgl_ctnt_id_exists;
934:

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

967:
968: BEGIN
969:
970: IF TRIM(p_file_name) IS NULL THEN
971: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
972: FND_MESSAGE.set_name('JTF', 'JTF_DSP_ATH_FILENAME_REQ');
973: FND_MSG_PUB.add;
974: END IF;
975:

Line 973: FND_MSG_PUB.add;

969:
970: IF TRIM(p_file_name) IS NULL THEN
971: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
972: FND_MESSAGE.set_name('JTF', 'JTF_DSP_ATH_FILENAME_REQ');
973: FND_MSG_PUB.add;
974: END IF;
975:
976: ELSE
977: IF p_attachment_id IS NOT NULL THEN

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

1000:
1001: EXCEPTION
1002:
1003: WHEN l_dup_file_exception THEN
1004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1005: FND_MESSAGE.set_name('JTF','JTF_DSP_ATH_FILENAME_EXISTS');
1006: FND_MESSAGE.set_token('FILE_NAME', p_file_name);
1007: FND_MSG_PUB.ADD;
1008: END IF;

Line 1007: FND_MSG_PUB.ADD;

1003: WHEN l_dup_file_exception THEN
1004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1005: FND_MESSAGE.set_name('JTF','JTF_DSP_ATH_FILENAME_EXISTS');
1006: FND_MESSAGE.set_token('FILE_NAME', p_file_name);
1007: FND_MSG_PUB.ADD;
1008: END IF;
1009: RETURN l_return_status;
1010:
1011: WHEN OTHERS THEN

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

1008: END IF;
1009: RETURN l_return_status;
1010:
1011: WHEN OTHERS THEN
1012: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1013: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1014: END IF;
1015: RETURN l_return_status;
1016:

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

1009: RETURN l_return_status;
1010:
1011: WHEN OTHERS THEN
1012: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1013: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1014: END IF;
1015: RETURN l_return_status;
1016:
1017: END check_attachment_filename;

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

1083:
1084: EXCEPTION
1085:
1086: WHEN l_msite_not_exists_exception THEN
1087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1088: FND_MESSAGE.set_name('JTF', 'JTF_MSITE_NOT_EXISTS');
1089: FND_MESSAGE.set_token('ID', TO_CHAR(p_msite_id));
1090: FND_MSG_PUB.add;
1091: END IF;

Line 1090: FND_MSG_PUB.add;

1086: WHEN l_msite_not_exists_exception THEN
1087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1088: FND_MESSAGE.set_name('JTF', 'JTF_MSITE_NOT_EXISTS');
1089: FND_MESSAGE.set_token('ID', TO_CHAR(p_msite_id));
1090: FND_MSG_PUB.add;
1091: END IF;
1092: RETURN l_return_status;
1093:
1094: WHEN OTHERS THEN

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

1091: END IF;
1092: RETURN l_return_status;
1093:
1094: WHEN OTHERS THEN
1095: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1096: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1097: END IF;
1098: return l_return_status;
1099:

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

1092: RETURN l_return_status;
1093:
1094: WHEN OTHERS THEN
1095: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1096: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1097: END IF;
1098: return l_return_status;
1099:
1100: END check_msite_exists;

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

1140:
1141: EXCEPTION
1142:
1143: WHEN l_map_not_exists_exception THEN
1144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1145: FND_MESSAGE.set_name('JTF', 'JTF_DSP_PHYSMAP_NOT_EXISTS');
1146: FND_MESSAGE.set_token('ID', TO_CHAR(p_lgl_phys_map_id));
1147: FND_MSG_PUB.add;
1148: END IF;

Line 1147: FND_MSG_PUB.add;

1143: WHEN l_map_not_exists_exception THEN
1144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1145: FND_MESSAGE.set_name('JTF', 'JTF_DSP_PHYSMAP_NOT_EXISTS');
1146: FND_MESSAGE.set_token('ID', TO_CHAR(p_lgl_phys_map_id));
1147: FND_MSG_PUB.add;
1148: END IF;
1149: RETURN l_return_status;
1150:
1151: WHEN OTHERS THEN

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

1148: END IF;
1149: RETURN l_return_status;
1150:
1151: WHEN OTHERS THEN
1152: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1153: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1154: END IF;
1155: return l_return_status;
1156:

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

1149: RETURN l_return_status;
1150:
1151: WHEN OTHERS THEN
1152: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1153: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1154: END IF;
1155: return l_return_status;
1156:
1157: END check_physicalmap_exists;

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

1191:
1192: BEGIN
1193:
1194: IF TRIM(p_access_name) IS NULL THEN
1195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1196: FND_MESSAGE.set_name('JTF', 'JTF_DSP_DLV_ACCNAME_REQ');
1197: FND_MSG_PUB.add;
1198: END IF;
1199:

Line 1197: FND_MSG_PUB.add;

1193:
1194: IF TRIM(p_access_name) IS NULL THEN
1195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1196: FND_MESSAGE.set_name('JTF', 'JTF_DSP_DLV_ACCNAME_REQ');
1197: FND_MSG_PUB.add;
1198: END IF;
1199:
1200: ELSE
1201: IF p_deliverable_id IS NOT NULL THEN

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

1225:
1226: EXCEPTION
1227:
1228: WHEN l_dup_access_exception THEN
1229: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1230: FND_MESSAGE.set_name('JTF', 'JTF_DSP_DLV_ACCNAME_EXISTS');
1231: FND_MESSAGE.set_token('ACC_NAME', p_access_name);
1232: FND_MSG_PUB.add;
1233: END IF;

Line 1232: FND_MSG_PUB.add;

1228: WHEN l_dup_access_exception THEN
1229: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1230: FND_MESSAGE.set_name('JTF', 'JTF_DSP_DLV_ACCNAME_EXISTS');
1231: FND_MESSAGE.set_token('ACC_NAME', p_access_name);
1232: FND_MSG_PUB.add;
1233: END IF;
1234: RETURN l_return_status;
1235:
1236: WHEN OTHERS THEN

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

1233: END IF;
1234: RETURN l_return_status;
1235:
1236: WHEN OTHERS THEN
1237: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1238: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1239: END IF;
1240: RETURN l_return_status;
1241:

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

1234: RETURN l_return_status;
1235:
1236: WHEN OTHERS THEN
1237: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1238: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1239: END IF;
1240: RETURN l_return_status;
1241:
1242: END check_deliverable_accessname;

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

1290:
1291: EXCEPTION
1292:
1293: WHEN l_lang_not_supp_exception THEN
1294: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1295: FND_MESSAGE.set_name('JTF', 'JTF_MSITE_LANG_NOT_SUPP' );
1296: FND_MESSAGE.set_token('ID', TO_CHAR(p_msite_id));
1297: FND_MESSAGE.set_token('LANG', p_language_code);
1298: FND_MSG_PUB.add;

Line 1298: FND_MSG_PUB.add;

1294: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1295: FND_MESSAGE.set_name('JTF', 'JTF_MSITE_LANG_NOT_SUPP' );
1296: FND_MESSAGE.set_token('ID', TO_CHAR(p_msite_id));
1297: FND_MESSAGE.set_token('LANG', p_language_code);
1298: FND_MSG_PUB.add;
1299: END IF;
1300: return l_return_status;
1301:
1302: WHEN OTHERS THEN

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

1299: END IF;
1300: return l_return_status;
1301:
1302: WHEN OTHERS THEN
1303: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1304: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1305: END IF;
1306: return l_return_status;
1307:

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

1300: return l_return_status;
1301:
1302: WHEN OTHERS THEN
1303: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1304: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1305: END IF;
1306: return l_return_status;
1307:
1308: END check_language_supported;

Line 1344: FND_MSG_PUB.add;

1340: if l_return_status = false then
1341: FND_MESSAGE.set_name('JTF', 'JTF_DSP_ITEM_DLV_INVLD');
1342: FND_MESSAGE.set_token('ITEM_ID', p_item_id);
1343: FND_MESSAGE.set_token('ID', p_deliverable_id);
1344: FND_MSG_PUB.add;
1345: END IF;
1346: else
1347: FND_MESSAGE.set_name('JTF', 'JTF_DSP_ITEM_DLV_REQ');
1348: FND_MSG_PUB.add;

Line 1348: FND_MSG_PUB.add;

1344: FND_MSG_PUB.add;
1345: END IF;
1346: else
1347: FND_MESSAGE.set_name('JTF', 'JTF_DSP_ITEM_DLV_REQ');
1348: FND_MSG_PUB.add;
1349: END IF;
1350:
1351:
1352: return l_return_status;

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

1352: return l_return_status;
1353:
1354: EXCEPTION
1355: WHEN OTHERS THEN
1356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1357: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1358: END IF;
1359: return false;
1360: */

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

1353:
1354: EXCEPTION
1355: WHEN OTHERS THEN
1356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1357: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1358: END IF;
1359: return false;
1360: */
1361: end check_item_deliverable;

Line 1395: FND_MSG_PUB.add;

1391: CLOSE category_dlv_cur;
1392: FND_MESSAGE.set_name('JTF', 'JTF_DSP_CATEGORY_DLV_INVLD');
1393: FND_MESSAGE.set_token('CATEGORY_ID', p_category_id);
1394: FND_MESSAGE.set_token('ID', p_deliverable_id);
1395: FND_MSG_PUB.add;
1396: l_return_status := false;
1397: else
1398: CLOSE category_dlv_cur;
1399: l_return_status := true;

Line 1403: FND_MSG_PUB.add;

1399: l_return_status := true;
1400: END IF;
1401: else
1402: FND_MESSAGE.set_name('JTF', 'JTF_DSP_CATEGORY_DLV_REQ');
1403: FND_MSG_PUB.add;
1404: END IF;
1405:
1406: return l_return_status;
1407:

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

1406: return l_return_status;
1407:
1408: EXCEPTION
1409: WHEN OTHERS THEN
1410: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1411: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1412: END IF;
1413: return false;
1414:

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

1407:
1408: EXCEPTION
1409: WHEN OTHERS THEN
1410: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1411: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1412: END IF;
1413: return false;
1414:
1415: end check_category_deliverable;

Line 1440: FND_MSG_PUB.add;

1436: close msite_cur;
1437:
1438: if l_msite_id is null then
1439: FND_MESSAGE.set_name('JTF', 'JTF_MSITE_MASTER_NOT_EXISTS');
1440: FND_MSG_PUB.add;
1441: END IF;
1442:
1443: return l_msite_id;
1444:

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

1444:
1445: EXCEPTION
1446:
1447: WHEN OTHERS THEN
1448: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1449: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1450: END IF;
1451: return l_msite_id;
1452:

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

1445: EXCEPTION
1446:
1447: WHEN OTHERS THEN
1448: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1449: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1450: END IF;
1451: return l_msite_id;
1452:
1453: END check_master_msite_exists;

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

1475:
1476: EXCEPTION
1477:
1478: WHEN OTHERS THEN
1479: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1480: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1481: END IF;
1482: RETURN NULL;
1483:

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

1476: EXCEPTION
1477:
1478: WHEN OTHERS THEN
1479: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1480: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1481: END IF;
1482: RETURN NULL;
1483:
1484: END check_attachment_exists;

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

1524:
1525: EXCEPTION
1526:
1527: WHEN OTHERS THEN
1528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1529: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1530: END IF;
1531: RETURN NULL;
1532:

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

1525: EXCEPTION
1526:
1527: WHEN OTHERS THEN
1528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1529: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1530: END IF;
1531: RETURN NULL;
1532:
1533: END check_attachment_exists;

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

1565: CLOSE attachment_cur;
1566: END IF;
1567:
1568: IF NOT l_return_status THEN
1569: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1570: FND_MESSAGE.set_name('JTF','JTF_DSP_DLV_ATH_INVLD');
1571: FND_MESSAGE.set_token('ID', TO_CHAR(p_deliverable_id));
1572: FND_MESSAGE.set_token('ATH_ID', TO_CHAR(p_attachment_id));
1573: FND_MSG_PUB.ADD;

Line 1573: FND_MSG_PUB.ADD;

1569: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1570: FND_MESSAGE.set_name('JTF','JTF_DSP_DLV_ATH_INVLD');
1571: FND_MESSAGE.set_token('ID', TO_CHAR(p_deliverable_id));
1572: FND_MESSAGE.set_token('ATH_ID', TO_CHAR(p_attachment_id));
1573: FND_MSG_PUB.ADD;
1574: END IF;
1575: END IF;
1576:
1577: RETURN l_return_status;

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

1578:
1579: EXCEPTION
1580:
1581: WHEN OTHERS THEN
1582: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1583: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1584: END IF;
1585: RETURN l_return_status;
1586:

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

1579: EXCEPTION
1580:
1581: WHEN OTHERS THEN
1582: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1583: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1584: END IF;
1585: RETURN l_return_status;
1586:
1587: END check_attachment_deliverable;

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

1616:
1617: EXCEPTION
1618:
1619: WHEN OTHERS THEN
1620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1621: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1622: END IF;
1623: RETURN FALSE;
1624:

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

1617: EXCEPTION
1618:
1619: WHEN OTHERS THEN
1620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1621: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1622: END IF;
1623: RETURN FALSE;
1624:
1625: END check_default_attachment;

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

1643: Open C_Exists(p_access_name);
1644: Fetch C_Exists INTO l_exists;
1645: If C_Exists%FOUND Then
1646: l_status := FALSE ;
1647: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1648: FND_MESSAGE.set_name('JTF','JTF_MSITE_DUP_ACCNAME');
1649: FND_MESSAGE.set_token('ACCNAME',p_access_name);
1650: FND_MSG_PUB.ADD;
1651: END IF;

Line 1650: FND_MSG_PUB.ADD;

1646: l_status := FALSE ;
1647: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1648: FND_MESSAGE.set_name('JTF','JTF_MSITE_DUP_ACCNAME');
1649: FND_MESSAGE.set_token('ACCNAME',p_access_name);
1650: FND_MSG_PUB.ADD;
1651: END IF;
1652: Else
1653: l_status := TRUE ;
1654: End If;