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_PHYSICALMAP_GRP dependencies on FND_MSG_PUB

Line 78: FND_MSG_PUB.initialize;

74: END IF;
75:
76: -- Initialize message list if p_init_msg_list is set to TRUE
77: IF FND_API.to_boolean(p_init_msg_list) THEN
78: FND_MSG_PUB.initialize;
79: END IF;
80:
81: -- Initialize API rturn status to success
82: x_return_status := FND_API.g_ret_sts_success;

Line 224: IF FND_MSG_PUB.check_msg_level(

220: ROLLBACK TO save_one_physicalmap_grp;
221: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
222: x_return_status := FND_API.g_ret_sts_error;
223: END IF;
224: IF FND_MSG_PUB.check_msg_level(
225: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
226: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
227:
228: IF l_default_msite = g_yes THEN

Line 225: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

221: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
222: x_return_status := FND_API.g_ret_sts_error;
223: END IF;
224: IF FND_MSG_PUB.check_msg_level(
225: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
226: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
227:
228: IF l_default_msite = g_yes THEN
229: FND_MESSAGE.set_name(

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

222: x_return_status := FND_API.g_ret_sts_error;
223: END IF;
224: IF FND_MSG_PUB.check_msg_level(
225: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
226: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
227:
228: IF l_default_msite = g_yes THEN
229: FND_MESSAGE.set_name(
230: 'JTF',

Line 249: FND_MSG_PUB.add;

245: END IF;
246: FND_MESSAGE.set_token(
247: 'ID',
248: TO_CHAR(l_deliverable_id));
249: FND_MSG_PUB.add;
250: END IF;
251:
252: WHEN OTHERS THEN
253: ROLLBACK TO save_one_physicalmap_grp;

Line 256: IF FND_MSG_PUB.check_msg_level(

252: WHEN OTHERS THEN
253: ROLLBACK TO save_one_physicalmap_grp;
254: x_return_status := FND_API.g_ret_sts_unexp_error ;
255:
256: IF FND_MSG_PUB.check_msg_level(
257: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
258: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
259: END IF;
260:

Line 257: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

253: ROLLBACK TO save_one_physicalmap_grp;
254: x_return_status := FND_API.g_ret_sts_unexp_error ;
255:
256: IF FND_MSG_PUB.check_msg_level(
257: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
258: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
259: END IF;
260:
261: END;

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

254: x_return_status := FND_API.g_ret_sts_unexp_error ;
255:
256: IF FND_MSG_PUB.check_msg_level(
257: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
258: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
259: END IF;
260:
261: END;
262: END LOOP;

Line 274: FND_MSG_PUB.count_and_get(

270: COMMIT;
271: END IF;
272:
273: -- Standard call to get message count and if count is 1, get message info
274: FND_MSG_PUB.count_and_get(
275: p_encoded => FND_API.g_false,
276: p_count => x_msg_count,
277: p_data => x_msg_data
278: );

Line 286: FND_MSG_PUB.count_and_get(

282:
283: WHEN FND_API.g_exc_error THEN
284: ROLLBACK TO save_physicalmap_grp;
285: x_return_status := FND_API.g_ret_sts_error;
286: FND_MSG_PUB.count_and_get(
287: p_encoded => FND_API.g_false,
288: p_count => x_msg_count,
289: p_data => x_msg_data
290: );

Line 295: FND_MSG_PUB.count_and_get(

291:
292: WHEN FND_API.g_exc_unexpected_error THEN
293: ROLLBACK TO save_physicalmap_grp;
294: x_return_status := FND_API.g_ret_sts_unexp_error;
295: FND_MSG_PUB.count_and_get(
296: p_encoded => FND_API.g_false,
297: p_count => x_msg_count,
298: p_data => x_msg_data
299: );

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

300:
301: WHEN dup_val_on_index THEN
302: ROLLBACK TO save_physicalmap_grp;
303: x_return_status := FND_API.g_ret_sts_error;
304: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
305: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
306:
307: IF l_default_msite = g_no THEN
308: FND_MESSAGE.set_name('JTF', 'JTF_DSP_PHYSMAP_ALL_ALL_EXISTS');

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

301: WHEN dup_val_on_index THEN
302: ROLLBACK TO save_physicalmap_grp;
303: x_return_status := FND_API.g_ret_sts_error;
304: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
305: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
306:
307: IF l_default_msite = g_no THEN
308: FND_MESSAGE.set_name('JTF', 'JTF_DSP_PHYSMAP_ALL_ALL_EXISTS');
309: ELSE

Line 314: FND_MSG_PUB.add;

310: FND_MESSAGE.set_name('JTF', 'JTF_DSP_PHYSMAP_STE_ALL_EXISTS');
311: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));
312: END IF;
313: FND_MESSAGE.set_token('ID', TO_CHAR(l_deliverable_id));
314: FND_MSG_PUB.add;
315: END IF;
316:
317: FND_MSG_PUB.count_and_get(
318: p_encoded => FND_API.g_false,

Line 317: FND_MSG_PUB.count_and_get(

313: FND_MESSAGE.set_token('ID', TO_CHAR(l_deliverable_id));
314: FND_MSG_PUB.add;
315: END IF;
316:
317: FND_MSG_PUB.count_and_get(
318: p_encoded => FND_API.g_false,
319: p_count => x_msg_count,
320: p_data => x_msg_data
321: );

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

323: WHEN OTHERS THEN
324: ROLLBACK TO save_physicalmap_grp;
325: x_return_status := FND_API.g_ret_sts_unexp_error ;
326:
327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
328: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
329: END IF;
330:
331: FND_MSG_PUB.count_and_get(

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

324: ROLLBACK TO save_physicalmap_grp;
325: x_return_status := FND_API.g_ret_sts_unexp_error ;
326:
327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
328: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
329: END IF;
330:
331: FND_MSG_PUB.count_and_get(
332: p_encoded => FND_API.g_false,

Line 331: FND_MSG_PUB.count_and_get(

327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
328: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
329: END IF;
330:
331: FND_MSG_PUB.count_and_get(
332: p_encoded => FND_API.g_false,
333: p_count => x_msg_count,
334: p_data => x_msg_data
335: );

Line 412: FND_MSG_PUB.initialize;

408: END IF;
409:
410: -- Initialize message list if p_init_msg_list is set to TRUE
411: IF FND_API.to_boolean(p_init_msg_list) THEN
412: FND_MSG_PUB.initialize;
413: END IF;
414:
415: -- Initialize API rturn status to success
416: x_return_status := FND_API.g_ret_sts_success;

Line 528: FND_MSG_PUB.count_and_get(

524: COMMIT;
525: END IF;
526:
527: -- Standard call to get message count and if count is 1, get message info
528: FND_MSG_PUB.count_and_get(
529: p_encoded => FND_API.g_false,
530: p_count => x_msg_count,
531: p_data => x_msg_data
532: );

Line 539: FND_MSG_PUB.count_and_get(

535:
536: WHEN FND_API.g_exc_error THEN
537: ROLLBACK TO save_physicalmap_grp;
538: x_return_status := FND_API.g_ret_sts_error;
539: FND_MSG_PUB.count_and_get(
540: p_encoded => FND_API.g_false,
541: p_count => x_msg_count,
542: p_data => x_msg_data
543: );

Line 548: FND_MSG_PUB.count_and_get(

544:
545: WHEN FND_API.g_exc_unexpected_error THEN
546: ROLLBACK TO save_physicalmap_grp;
547: x_return_status := FND_API.g_ret_sts_unexp_error;
548: FND_MSG_PUB.count_and_get(
549: p_encoded => FND_API.g_false,
550: p_count => x_msg_count,
551: p_data => x_msg_data
552: );

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

554: WHEN OTHERS THEN
555: ROLLBACK TO save_physicalmap_grp;
556: x_return_status := FND_API.g_ret_sts_unexp_error ;
557:
558: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
559: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
560: END IF;
561:
562: FND_MSG_PUB.count_and_get(

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

555: ROLLBACK TO save_physicalmap_grp;
556: x_return_status := FND_API.g_ret_sts_unexp_error ;
557:
558: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
559: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
560: END IF;
561:
562: FND_MSG_PUB.count_and_get(
563: p_encoded => FND_API.g_false,

Line 562: FND_MSG_PUB.count_and_get(

558: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
559: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
560: END IF;
561:
562: FND_MSG_PUB.count_and_get(
563: p_encoded => FND_API.g_false,
564: p_count => x_msg_count,
565: p_data => x_msg_data
566: );

Line 619: FND_MSG_PUB.initialize;

615: END IF;
616:
617: -- Initialize message list if p_init_msg_list is set to TRUE
618: IF FND_API.to_boolean(p_init_msg_list) THEN
619: FND_MSG_PUB.initialize;
620: END IF;
621:
622: -- Initialize API rturn status to success
623: x_return_status := FND_API.g_ret_sts_success;

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

637: DELETE FROM JTF_DSP_LGL_PHYS_MAP
638: WHERE lgl_phys_map_id = p_lgl_phys_map_id_tbl(l_index);
639: IF SQL%NOTFOUND THEN
640: -- RAISE JTF_DSPMGRVALIDATION_GRP.physmap_not_exists_exception;
641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
642: FND_MESSAGE.set_name('JTF', 'JTF_DSP_PHYSMAP_NOT_EXISTS');
643: FND_MESSAGE.set_token(
644: 'ID',
645: TO_CHAR(p_lgl_phys_map_id_tbl(l_index)));

Line 646: FND_MSG_PUB.add;

642: FND_MESSAGE.set_name('JTF', 'JTF_DSP_PHYSMAP_NOT_EXISTS');
643: FND_MESSAGE.set_token(
644: 'ID',
645: TO_CHAR(p_lgl_phys_map_id_tbl(l_index)));
646: FND_MSG_PUB.add;
647: END IF;
648: RAISE FND_API.g_exc_error;
649: END IF;
650:

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

661:
662: /*
663: WHEN JTF_DSPMGRVALIDATION_GRP.physmap_not_exists_exception THEN
664: -- only warning; no error
665: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
666: FND_MESSAGE.set_name('JTF', 'JTF_DSP_PHYSMAP_NOT_EXISTS');
667: FND_MESSAGE.set_token(
668: 'ID',
669: TO_CHAR(p_lgl_phys_map_id_tbl(l_index)));

Line 670: FND_MSG_PUB.add;

666: FND_MESSAGE.set_name('JTF', 'JTF_DSP_PHYSMAP_NOT_EXISTS');
667: FND_MESSAGE.set_token(
668: 'ID',
669: TO_CHAR(p_lgl_phys_map_id_tbl(l_index)));
670: FND_MSG_PUB.add;
671: END IF;
672: */
673:
674: WHEN OTHERS THEN

Line 676: IF FND_MSG_PUB.check_msg_level(

672: */
673:
674: WHEN OTHERS THEN
675: x_return_status := FND_API.g_ret_sts_unexp_error ;
676: IF FND_MSG_PUB.check_msg_level(
677: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
678: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
679: END IF;
680:

Line 677: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

673:
674: WHEN OTHERS THEN
675: x_return_status := FND_API.g_ret_sts_unexp_error ;
676: IF FND_MSG_PUB.check_msg_level(
677: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
678: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
679: END IF;
680:
681: END;

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

674: WHEN OTHERS THEN
675: x_return_status := FND_API.g_ret_sts_unexp_error ;
676: IF FND_MSG_PUB.check_msg_level(
677: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
678: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
679: END IF;
680:
681: END;
682: END LOOP;

Line 692: FND_MSG_PUB.count_and_get(

688: COMMIT;
689: END IF;
690:
691: -- Standard call to get message count and if count is 1, get message info
692: FND_MSG_PUB.count_and_get(
693: p_encoded => FND_API.g_false,
694: p_count => x_msg_count,
695: p_data => x_msg_data
696: );

Line 703: FND_MSG_PUB.count_and_get(

699:
700: WHEN FND_API.g_exc_error THEN
701: ROLLBACK TO delete_physicalmap_grp;
702: x_return_status := FND_API.g_ret_sts_error;
703: FND_MSG_PUB.count_and_get(
704: p_encoded => FND_API.g_false,
705: p_count => x_msg_count,
706: p_data => x_msg_data
707: );

Line 712: FND_MSG_PUB.count_and_get(

708:
709: WHEN FND_API.g_exc_unexpected_error THEN
710: ROLLBACK TO delete_physicalmap_grp;
711: x_return_status := FND_API.g_ret_sts_unexp_error ;
712: FND_MSG_PUB.count_and_get(
713: p_encoded => FND_API.g_false,
714: p_count => x_msg_count,
715: p_data => x_msg_data
716: );

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

718: WHEN OTHERS THEN
719: ROLLBACK TO delete_physicalmap_grp;
720: x_return_status := FND_API.g_ret_sts_unexp_error ;
721:
722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
723: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
724: END IF;
725:
726: FND_MSG_PUB.count_and_get(

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

719: ROLLBACK TO delete_physicalmap_grp;
720: x_return_status := FND_API.g_ret_sts_unexp_error ;
721:
722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
723: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
724: END IF;
725:
726: FND_MSG_PUB.count_and_get(
727: p_encoded => FND_API.g_false,

Line 726: FND_MSG_PUB.count_and_get(

722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
723: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
724: END IF;
725:
726: FND_MSG_PUB.count_and_get(
727: p_encoded => FND_API.g_false,
728: p_count => x_msg_count,
729: p_data => x_msg_data
730: );

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

765:
766: WHEN OTHERS THEN
767: ROLLBACK TO delete_attachment_grp;
768:
769: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
770: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
771: END IF;
772:
773: END delete_attachment;

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

766: WHEN OTHERS THEN
767: ROLLBACK TO delete_attachment_grp;
768:
769: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
770: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
771: END IF;
772:
773: END delete_attachment;
774:

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

806:
807: WHEN OTHERS THEN
808: ROLLBACK TO delete_deliverable_grp;
809:
810: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
811: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
812: END IF;
813:
814: END delete_deliverable;

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

807: WHEN OTHERS THEN
808: ROLLBACK TO delete_deliverable_grp;
809:
810: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
811: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
812: END IF;
813:
814: END delete_deliverable;
815:

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

847:
848: WHEN OTHERS THEN
849: ROLLBACK TO delete_msite_grp;
850:
851: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
852: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
853: END IF;
854:
855: END delete_msite;

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

848: WHEN OTHERS THEN
849: ROLLBACK TO delete_msite_grp;
850:
851: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
852: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
853: END IF;
854:
855: END delete_msite;
856:

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

894:
895: WHEN OTHERS THEN
896: ROLLBACK TO delete_msite_language_grp;
897:
898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
899: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
900: END IF;
901:
902: END delete_msite_language;

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

895: WHEN OTHERS THEN
896: ROLLBACK TO delete_msite_language_grp;
897:
898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
899: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
900: END IF;
901:
902: END delete_msite_language;
903:

Line 949: FND_MSG_PUB.initialize;

945: END IF;
946:
947: -- Initialize message list if p_init_msg_list is set to TRUE
948: IF FND_API.to_boolean(p_init_msg_list) THEN
949: FND_MSG_PUB.initialize;
950: END IF;
951:
952: -- Initialize API rturn status to success
953: x_return_status := FND_API.g_ret_sts_success;

Line 980: IF FND_MSG_PUB.check_msg_level(

976:
977: WHEN OTHERS THEN
978: ROLLBACK TO delete_one_ath_msite_grp;
979: x_return_status := FND_API.g_ret_sts_unexp_error ;
980: IF FND_MSG_PUB.check_msg_level(
981: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
982: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
983: END IF;
984:

Line 981: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

977: WHEN OTHERS THEN
978: ROLLBACK TO delete_one_ath_msite_grp;
979: x_return_status := FND_API.g_ret_sts_unexp_error ;
980: IF FND_MSG_PUB.check_msg_level(
981: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
982: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
983: END IF;
984:
985: END;

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

978: ROLLBACK TO delete_one_ath_msite_grp;
979: x_return_status := FND_API.g_ret_sts_unexp_error ;
980: IF FND_MSG_PUB.check_msg_level(
981: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
982: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
983: END IF;
984:
985: END;
986: END LOOP;

Line 996: FND_MSG_PUB.count_and_get(

992: COMMIT;
993: END IF;
994:
995: -- Standard call to get message count and if count is 1, get message info
996: FND_MSG_PUB.count_and_get(
997: p_encoded => FND_API.g_false,
998: p_count => x_msg_count,
999: p_data => x_msg_data
1000: );

Line 1007: FND_MSG_PUB.count_and_get(

1003:
1004: WHEN FND_API.g_exc_error THEN
1005: ROLLBACK TO delete_attachment_msite_grp;
1006: x_return_status := FND_API.g_ret_sts_error;
1007: FND_MSG_PUB.count_and_get(
1008: p_encoded => FND_API.g_false,
1009: p_count => x_msg_count,
1010: p_data => x_msg_data
1011: );

Line 1016: FND_MSG_PUB.count_and_get(

1012:
1013: WHEN FND_API.g_exc_unexpected_error THEN
1014: ROLLBACK TO delete_attachment_msite_grp;
1015: x_return_status := FND_API.g_ret_sts_unexp_error ;
1016: FND_MSG_PUB.count_and_get(
1017: p_encoded => FND_API.g_false,
1018: p_count => x_msg_count,
1019: p_data => x_msg_data
1020: );

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

1022: WHEN OTHERS THEN
1023: ROLLBACK TO delete_attachment_msite_grp;
1024: x_return_status := FND_API.g_ret_sts_unexp_error ;
1025:
1026: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1027: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1028: END IF;
1029:
1030: FND_MSG_PUB.count_and_get(

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

1023: ROLLBACK TO delete_attachment_msite_grp;
1024: x_return_status := FND_API.g_ret_sts_unexp_error ;
1025:
1026: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1027: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1028: END IF;
1029:
1030: FND_MSG_PUB.count_and_get(
1031: p_encoded => FND_API.g_false,

Line 1030: FND_MSG_PUB.count_and_get(

1026: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1027: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1028: END IF;
1029:
1030: FND_MSG_PUB.count_and_get(
1031: p_encoded => FND_API.g_false,
1032: p_count => x_msg_count,
1033: p_data => x_msg_data
1034: );

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

1071:
1072: WHEN OTHERS THEN
1073: ROLLBACK TO delete_dlv_all_all_grp;
1074:
1075: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1076: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1077: END IF;
1078:
1079: END delete_dlv_all_all;

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

1072: WHEN OTHERS THEN
1073: ROLLBACK TO delete_dlv_all_all_grp;
1074:
1075: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1076: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1077: END IF;
1078:
1079: END delete_dlv_all_all;
1080: