APPS.IBE_PHYSICALMAP_GRP dependencies on FND_MSG_PUB

Line 82: FND_MSG_PUB.initialize;

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

Line 252: IF FND_MSG_PUB.check_msg_level(

248: ROLLBACK TO save_one_physicalmap_grp;
249: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
250: x_return_status := FND_API.g_ret_sts_error;
251: END IF;
252: IF FND_MSG_PUB.check_msg_level(
253: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
254: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
255:
256: IF l_default_msite = g_yes THEN

Line 253: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

249: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
250: x_return_status := FND_API.g_ret_sts_error;
251: END IF;
252: IF FND_MSG_PUB.check_msg_level(
253: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
254: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
255:
256: IF l_default_msite = g_yes THEN
257: FND_MESSAGE.set_name(

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

250: x_return_status := FND_API.g_ret_sts_error;
251: END IF;
252: IF FND_MSG_PUB.check_msg_level(
253: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
254: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
255:
256: IF l_default_msite = g_yes THEN
257: FND_MESSAGE.set_name(
258: 'IBE',

Line 277: FND_MSG_PUB.add;

273: END IF;
274: FND_MESSAGE.set_token(
275: 'ID',
276: TO_CHAR(l_deliverable_id));
277: FND_MSG_PUB.add;
278: END IF;
279:
280: WHEN OTHERS THEN
281: ROLLBACK TO save_one_physicalmap_grp;

Line 284: IF FND_MSG_PUB.check_msg_level(

280: WHEN OTHERS THEN
281: ROLLBACK TO save_one_physicalmap_grp;
282: x_return_status := FND_API.g_ret_sts_unexp_error ;
283:
284: IF FND_MSG_PUB.check_msg_level(
285: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
286: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
287: END IF;
288:

Line 285: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

281: ROLLBACK TO save_one_physicalmap_grp;
282: x_return_status := FND_API.g_ret_sts_unexp_error ;
283:
284: IF FND_MSG_PUB.check_msg_level(
285: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
286: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
287: END IF;
288:
289: END;

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

282: x_return_status := FND_API.g_ret_sts_unexp_error ;
283:
284: IF FND_MSG_PUB.check_msg_level(
285: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
286: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
287: END IF;
288:
289: END;
290: END LOOP;

Line 302: FND_MSG_PUB.count_and_get(

298: COMMIT;
299: END IF;
300:
301: -- Standard call to get message count and if count is 1, get message info
302: FND_MSG_PUB.count_and_get(
303: p_encoded => FND_API.g_false,
304: p_count => x_msg_count,
305: p_data => x_msg_data
306: );

Line 314: FND_MSG_PUB.count_and_get(

310:
311: WHEN FND_API.g_exc_error THEN
312: ROLLBACK TO save_physicalmap_grp;
313: x_return_status := FND_API.g_ret_sts_error;
314: FND_MSG_PUB.count_and_get(
315: p_encoded => FND_API.g_false,
316: p_count => x_msg_count,
317: p_data => x_msg_data
318: );

Line 323: FND_MSG_PUB.count_and_get(

319:
320: WHEN FND_API.g_exc_unexpected_error THEN
321: ROLLBACK TO save_physicalmap_grp;
322: x_return_status := FND_API.g_ret_sts_unexp_error;
323: FND_MSG_PUB.count_and_get(
324: p_encoded => FND_API.g_false,
325: p_count => x_msg_count,
326: p_data => x_msg_data
327: );

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

328:
329: WHEN dup_val_on_index THEN
330: ROLLBACK TO save_physicalmap_grp;
331: x_return_status := FND_API.g_ret_sts_error;
332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
333: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
334:
335: --added by YAXU on 08/02/2002
336: IF l_default_msite = g_yes and l_default_lang = g_yes THEN

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

329: WHEN dup_val_on_index THEN
330: ROLLBACK TO save_physicalmap_grp;
331: x_return_status := FND_API.g_ret_sts_error;
332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
333: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
334:
335: --added by YAXU on 08/02/2002
336: IF l_default_msite = g_yes and l_default_lang = g_yes THEN
337: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_ALL_ALL_EXISTS');

Line 353: FND_MSG_PUB.add;

349: FND_MESSAGE.set_token('LANG', p_language_code_tbl(l_index));
350: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));
351: END IF;
352: FND_MESSAGE.set_token('ID', TO_CHAR(l_deliverable_id));
353: FND_MSG_PUB.add;
354:
355: END IF;
356:
357: FND_MSG_PUB.count_and_get(

Line 357: FND_MSG_PUB.count_and_get(

353: FND_MSG_PUB.add;
354:
355: END IF;
356:
357: FND_MSG_PUB.count_and_get(
358: p_encoded => FND_API.g_false,
359: p_count => x_msg_count,
360: p_data => x_msg_data
361: );

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

363: WHEN OTHERS THEN
364: ROLLBACK TO save_physicalmap_grp;
365: x_return_status := FND_API.g_ret_sts_unexp_error ;
366:
367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
368: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
369: END IF;
370:
371: FND_MSG_PUB.count_and_get(

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

364: ROLLBACK TO save_physicalmap_grp;
365: x_return_status := FND_API.g_ret_sts_unexp_error ;
366:
367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
368: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
369: END IF;
370:
371: FND_MSG_PUB.count_and_get(
372: p_encoded => FND_API.g_false,

Line 371: FND_MSG_PUB.count_and_get(

367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
368: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
369: END IF;
370:
371: FND_MSG_PUB.count_and_get(
372: p_encoded => FND_API.g_false,
373: p_count => x_msg_count,
374: p_data => x_msg_data
375: );

Line 452: FND_MSG_PUB.initialize;

448: END IF;
449:
450: -- Initialize message list if p_init_msg_list is set to TRUE
451: IF FND_API.to_boolean(p_init_msg_list) THEN
452: FND_MSG_PUB.initialize;
453: END IF;
454:
455: -- Initialize API rturn status to success
456: x_return_status := FND_API.g_ret_sts_success;

Line 568: FND_MSG_PUB.count_and_get(

564: COMMIT;
565: END IF;
566:
567: -- Standard call to get message count and if count is 1, get message info
568: FND_MSG_PUB.count_and_get(
569: p_encoded => FND_API.g_false,
570: p_count => x_msg_count,
571: p_data => x_msg_data
572: );

Line 579: FND_MSG_PUB.count_and_get(

575:
576: WHEN FND_API.g_exc_error THEN
577: ROLLBACK TO save_physicalmap_grp;
578: x_return_status := FND_API.g_ret_sts_error;
579: FND_MSG_PUB.count_and_get(
580: p_encoded => FND_API.g_false,
581: p_count => x_msg_count,
582: p_data => x_msg_data
583: );

Line 588: FND_MSG_PUB.count_and_get(

584:
585: WHEN FND_API.g_exc_unexpected_error THEN
586: ROLLBACK TO save_physicalmap_grp;
587: x_return_status := FND_API.g_ret_sts_unexp_error;
588: FND_MSG_PUB.count_and_get(
589: p_encoded => FND_API.g_false,
590: p_count => x_msg_count,
591: p_data => x_msg_data
592: );

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

594: WHEN OTHERS THEN
595: ROLLBACK TO save_physicalmap_grp;
596: x_return_status := FND_API.g_ret_sts_unexp_error ;
597:
598: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
599: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
600: END IF;
601:
602: FND_MSG_PUB.count_and_get(

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

595: ROLLBACK TO save_physicalmap_grp;
596: x_return_status := FND_API.g_ret_sts_unexp_error ;
597:
598: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
599: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
600: END IF;
601:
602: FND_MSG_PUB.count_and_get(
603: p_encoded => FND_API.g_false,

Line 602: FND_MSG_PUB.count_and_get(

598: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
599: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
600: END IF;
601:
602: FND_MSG_PUB.count_and_get(
603: p_encoded => FND_API.g_false,
604: p_count => x_msg_count,
605: p_data => x_msg_data
606: );

Line 659: FND_MSG_PUB.initialize;

655: END IF;
656:
657: -- Initialize message list if p_init_msg_list is set to TRUE
658: IF FND_API.to_boolean(p_init_msg_list) THEN
659: FND_MSG_PUB.initialize;
660: END IF;
661:
662: -- Initialize API rturn status to success
663: x_return_status := FND_API.g_ret_sts_success;

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

677: DELETE FROM IBE_DSP_LGL_PHYS_MAP
678: WHERE lgl_phys_map_id = p_lgl_phys_map_id_tbl(l_index);
679: IF SQL%NOTFOUND THEN
680: -- RAISE IBE_DSPMGRVALIDATION_GRP.physmap_not_exists_exception;
681: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
682: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_NOT_EXISTS');
683: FND_MESSAGE.set_token(
684: 'ID',
685: TO_CHAR(p_lgl_phys_map_id_tbl(l_index)));

Line 686: FND_MSG_PUB.add;

682: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_NOT_EXISTS');
683: FND_MESSAGE.set_token(
684: 'ID',
685: TO_CHAR(p_lgl_phys_map_id_tbl(l_index)));
686: FND_MSG_PUB.add;
687: END IF;
688: RAISE FND_API.g_exc_error;
689: END IF;
690:

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

701:
702: /*
703: WHEN IBE_DSPMGRVALIDATION_GRP.physmap_not_exists_exception THEN
704: -- only warning; no error
705: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
706: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_NOT_EXISTS');
707: FND_MESSAGE.set_token(
708: 'ID',
709: TO_CHAR(p_lgl_phys_map_id_tbl(l_index)));

Line 710: FND_MSG_PUB.add;

706: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_NOT_EXISTS');
707: FND_MESSAGE.set_token(
708: 'ID',
709: TO_CHAR(p_lgl_phys_map_id_tbl(l_index)));
710: FND_MSG_PUB.add;
711: END IF;
712: */
713:
714: WHEN OTHERS THEN

Line 716: IF FND_MSG_PUB.check_msg_level(

712: */
713:
714: WHEN OTHERS THEN
715: x_return_status := FND_API.g_ret_sts_unexp_error ;
716: IF FND_MSG_PUB.check_msg_level(
717: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
718: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
719: END IF;
720:

Line 717: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

713:
714: WHEN OTHERS THEN
715: x_return_status := FND_API.g_ret_sts_unexp_error ;
716: IF FND_MSG_PUB.check_msg_level(
717: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
718: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
719: END IF;
720:
721: END;

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

714: WHEN OTHERS THEN
715: x_return_status := FND_API.g_ret_sts_unexp_error ;
716: IF FND_MSG_PUB.check_msg_level(
717: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
718: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
719: END IF;
720:
721: END;
722: END LOOP;

Line 732: FND_MSG_PUB.count_and_get(

728: COMMIT;
729: END IF;
730:
731: -- Standard call to get message count and if count is 1, get message info
732: FND_MSG_PUB.count_and_get(
733: p_encoded => FND_API.g_false,
734: p_count => x_msg_count,
735: p_data => x_msg_data
736: );

Line 743: FND_MSG_PUB.count_and_get(

739:
740: WHEN FND_API.g_exc_error THEN
741: ROLLBACK TO delete_physicalmap_grp;
742: x_return_status := FND_API.g_ret_sts_error;
743: FND_MSG_PUB.count_and_get(
744: p_encoded => FND_API.g_false,
745: p_count => x_msg_count,
746: p_data => x_msg_data
747: );

Line 752: FND_MSG_PUB.count_and_get(

748:
749: WHEN FND_API.g_exc_unexpected_error THEN
750: ROLLBACK TO delete_physicalmap_grp;
751: x_return_status := FND_API.g_ret_sts_unexp_error ;
752: FND_MSG_PUB.count_and_get(
753: p_encoded => FND_API.g_false,
754: p_count => x_msg_count,
755: p_data => x_msg_data
756: );

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

758: WHEN OTHERS THEN
759: ROLLBACK TO delete_physicalmap_grp;
760: x_return_status := FND_API.g_ret_sts_unexp_error ;
761:
762: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
763: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
764: END IF;
765:
766: FND_MSG_PUB.count_and_get(

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

759: ROLLBACK TO delete_physicalmap_grp;
760: x_return_status := FND_API.g_ret_sts_unexp_error ;
761:
762: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
763: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
764: END IF;
765:
766: FND_MSG_PUB.count_and_get(
767: p_encoded => FND_API.g_false,

Line 766: FND_MSG_PUB.count_and_get(

762: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
763: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
764: END IF;
765:
766: FND_MSG_PUB.count_and_get(
767: p_encoded => FND_API.g_false,
768: p_count => x_msg_count,
769: p_data => x_msg_data
770: );

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

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

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

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

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

888:
889: WHEN OTHERS THEN
890: ROLLBACK TO delete_deliverable_grp;
891:
892: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
893: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
894: END IF;
895:
896: END delete_deliverable;

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

889: WHEN OTHERS THEN
890: ROLLBACK TO delete_deliverable_grp;
891:
892: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
893: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
894: END IF;
895:
896: END delete_deliverable;
897:

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

929:
930: WHEN OTHERS THEN
931: ROLLBACK TO delete_msite_grp;
932:
933: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
934: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
935: END IF;
936:
937: END delete_msite;

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

930: WHEN OTHERS THEN
931: ROLLBACK TO delete_msite_grp;
932:
933: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
934: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
935: END IF;
936:
937: END delete_msite;
938:

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

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

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

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

Line 1031: FND_MSG_PUB.initialize;

1027: END IF;
1028:
1029: -- Initialize message list if p_init_msg_list is set to TRUE
1030: IF FND_API.to_boolean(p_init_msg_list) THEN
1031: FND_MSG_PUB.initialize;
1032: END IF;
1033:
1034: -- Initialize API rturn status to success
1035: x_return_status := FND_API.g_ret_sts_success;

Line 1062: IF FND_MSG_PUB.check_msg_level(

1058:
1059: WHEN OTHERS THEN
1060: ROLLBACK TO delete_one_ath_msite_grp;
1061: x_return_status := FND_API.g_ret_sts_unexp_error ;
1062: IF FND_MSG_PUB.check_msg_level(
1063: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1064: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1065: END IF;
1066:

Line 1063: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1059: WHEN OTHERS THEN
1060: ROLLBACK TO delete_one_ath_msite_grp;
1061: x_return_status := FND_API.g_ret_sts_unexp_error ;
1062: IF FND_MSG_PUB.check_msg_level(
1063: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1064: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1065: END IF;
1066:
1067: END;

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

1060: ROLLBACK TO delete_one_ath_msite_grp;
1061: x_return_status := FND_API.g_ret_sts_unexp_error ;
1062: IF FND_MSG_PUB.check_msg_level(
1063: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1064: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1065: END IF;
1066:
1067: END;
1068: END LOOP;

Line 1078: FND_MSG_PUB.count_and_get(

1074: COMMIT;
1075: END IF;
1076:
1077: -- Standard call to get message count and if count is 1, get message info
1078: FND_MSG_PUB.count_and_get(
1079: p_encoded => FND_API.g_false,
1080: p_count => x_msg_count,
1081: p_data => x_msg_data
1082: );

Line 1089: FND_MSG_PUB.count_and_get(

1085:
1086: WHEN FND_API.g_exc_error THEN
1087: ROLLBACK TO delete_attachment_msite_grp;
1088: x_return_status := FND_API.g_ret_sts_error;
1089: FND_MSG_PUB.count_and_get(
1090: p_encoded => FND_API.g_false,
1091: p_count => x_msg_count,
1092: p_data => x_msg_data
1093: );

Line 1098: FND_MSG_PUB.count_and_get(

1094:
1095: WHEN FND_API.g_exc_unexpected_error THEN
1096: ROLLBACK TO delete_attachment_msite_grp;
1097: x_return_status := FND_API.g_ret_sts_unexp_error ;
1098: FND_MSG_PUB.count_and_get(
1099: p_encoded => FND_API.g_false,
1100: p_count => x_msg_count,
1101: p_data => x_msg_data
1102: );

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

1104: WHEN OTHERS THEN
1105: ROLLBACK TO delete_attachment_msite_grp;
1106: x_return_status := FND_API.g_ret_sts_unexp_error ;
1107:
1108: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1109: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1110: END IF;
1111:
1112: FND_MSG_PUB.count_and_get(

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

1105: ROLLBACK TO delete_attachment_msite_grp;
1106: x_return_status := FND_API.g_ret_sts_unexp_error ;
1107:
1108: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1109: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1110: END IF;
1111:
1112: FND_MSG_PUB.count_and_get(
1113: p_encoded => FND_API.g_false,

Line 1112: FND_MSG_PUB.count_and_get(

1108: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1109: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1110: END IF;
1111:
1112: FND_MSG_PUB.count_and_get(
1113: p_encoded => FND_API.g_false,
1114: p_count => x_msg_count,
1115: p_data => x_msg_data
1116: );

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

1153:
1154: WHEN OTHERS THEN
1155: ROLLBACK TO delete_dlv_all_all_grp;
1156:
1157: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1158: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1159: END IF;
1160:
1161: END delete_dlv_all_all;

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

1154: WHEN OTHERS THEN
1155: ROLLBACK TO delete_dlv_all_all_grp;
1156:
1157: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1158: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1159: END IF;
1160:
1161: END delete_dlv_all_all;
1162:

Line 1219: FND_MSG_PUB.initialize;

1215: G_PKG_NAME) THEN
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1217: END IF;
1218: IF FND_API.to_Boolean(p_init_msg_list) THEN
1219: FND_MSG_PUB.initialize;
1220: END IF;
1221: -- Initialize API return status to SUCCESS
1222: x_return_status := FND_API.G_RET_STS_SUCCESS;
1223: l_ocm_integration

Line 1389: IF FND_MSG_PUB.check_msg_level

1385: ROLLBACK TO SAVE_ONE_PHYSICALMAP;
1386: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1387: x_return_status := FND_API.g_ret_sts_error;
1388: END IF;
1389: IF FND_MSG_PUB.check_msg_level
1390: (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1391: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1392: IF l_default_msite = g_yes THEN
1393: FND_MESSAGE.set_name('IBE',

Line 1390: (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1386: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1387: x_return_status := FND_API.g_ret_sts_error;
1388: END IF;
1389: IF FND_MSG_PUB.check_msg_level
1390: (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1391: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1392: IF l_default_msite = g_yes THEN
1393: FND_MESSAGE.set_name('IBE',
1394: 'IBE_DSP_PHYSMAP_ALL_LNG_EXISTS');

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

1387: x_return_status := FND_API.g_ret_sts_error;
1388: END IF;
1389: IF FND_MSG_PUB.check_msg_level
1390: (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1391: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1392: IF l_default_msite = g_yes THEN
1393: FND_MESSAGE.set_name('IBE',
1394: 'IBE_DSP_PHYSMAP_ALL_LNG_EXISTS');
1395: FND_MESSAGE.set_token('LANG',

Line 1406: FND_MSG_PUB.add;

1402: FND_MESSAGE.set_token(
1403: 'LANG', p_language_code_tbl(l_index));
1404: END IF;
1405: FND_MESSAGE.set_token('ID', TO_CHAR(l_deliverable_id));
1406: FND_MSG_PUB.add;
1407: END IF;
1408: WHEN OTHERS THEN
1409: ROLLBACK TO SAVE_ONE_PHYSICALMAP;
1410: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1411: IF FND_MSG_PUB.check_msg_level(

1407: END IF;
1408: WHEN OTHERS THEN
1409: ROLLBACK TO SAVE_ONE_PHYSICALMAP;
1410: x_return_status := FND_API.g_ret_sts_unexp_error;
1411: IF FND_MSG_PUB.check_msg_level(
1412: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1413: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1414: END IF;
1415: END;

Line 1412: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1408: WHEN OTHERS THEN
1409: ROLLBACK TO SAVE_ONE_PHYSICALMAP;
1410: x_return_status := FND_API.g_ret_sts_unexp_error;
1411: IF FND_MSG_PUB.check_msg_level(
1412: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1413: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1414: END IF;
1415: END;
1416: END LOOP;

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

1409: ROLLBACK TO SAVE_ONE_PHYSICALMAP;
1410: x_return_status := FND_API.g_ret_sts_unexp_error;
1411: IF FND_MSG_PUB.check_msg_level(
1412: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1413: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1414: END IF;
1415: END;
1416: END LOOP;
1417: END IF;

Line 1422: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1418: END IF;
1419: IF (FND_API.To_Boolean(p_commit)) THEN
1420: COMMIT WORK;
1421: END IF;
1422: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1423: p_data => x_msg_data,
1424: p_encoded => 'F');
1425: EXCEPTION
1426: WHEN FND_API.G_EXC_ERROR THEN

Line 1429: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1425: EXCEPTION
1426: WHEN FND_API.G_EXC_ERROR THEN
1427: ROLLBACK TO SAVE_PHYSICALMAP;
1428: x_return_status := FND_API.G_RET_STS_ERROR;
1429: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1430: p_data => x_msg_data,
1431: p_encoded => 'F');
1432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1433: ROLLBACK TO SAVE_PHYSICALMAP;

Line 1435: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1431: p_encoded => 'F');
1432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1433: ROLLBACK TO SAVE_PHYSICALMAP;
1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1435: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1436: p_data => x_msg_data,
1437: p_encoded => 'F');
1438:
1439: --added by YAXU on 01/02/2004

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

1439: --added by YAXU on 01/02/2004
1440: WHEN dup_val_on_index THEN
1441: ROLLBACK TO SAVE_PHYSICALMAP;
1442: x_return_status := FND_API.g_ret_sts_error;
1443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1444: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1445:
1446: IF l_default_msite = g_yes and l_default_lang = g_yes THEN
1447: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_ALL_ALL_EXISTS');

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

1440: WHEN dup_val_on_index THEN
1441: ROLLBACK TO SAVE_PHYSICALMAP;
1442: x_return_status := FND_API.g_ret_sts_error;
1443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1444: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1445:
1446: IF l_default_msite = g_yes and l_default_lang = g_yes THEN
1447: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_ALL_ALL_EXISTS');
1448: END IF;

Line 1454: FND_MSG_PUB.add;

1450: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_STE_ALL_EXISTS');
1451: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));
1452: END IF;
1453: FND_MESSAGE.set_token('ID', TO_CHAR(l_deliverable_id));
1454: FND_MSG_PUB.add;
1455:
1456: END IF;
1457:
1458: FND_MSG_PUB.count_and_get(

Line 1458: FND_MSG_PUB.count_and_get(

1454: FND_MSG_PUB.add;
1455:
1456: END IF;
1457:
1458: FND_MSG_PUB.count_and_get(
1459: p_encoded => FND_API.g_false,
1460: p_count => x_msg_count,
1461: p_data => x_msg_data
1462: );

Line 1471: FND_MSG_PUB.Add;

1467: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1468: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1469: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1470: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1471: FND_MSG_PUB.Add;
1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1473: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1474: THEN
1475: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 1473: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1469: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1470: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1471: FND_MSG_PUB.Add;
1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1473: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1474: THEN
1475: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1476: END IF;
1477: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 1475: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1471: FND_MSG_PUB.Add;
1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1473: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1474: THEN
1475: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1476: END IF;
1477: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1478: p_data => x_msg_data,
1479: p_encoded => 'F');

Line 1477: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1473: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1474: THEN
1475: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1476: END IF;
1477: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1478: p_data => x_msg_data,
1479: p_encoded => 'F');
1480: END save_physicalmap;
1481:

Line 1520: FND_MSG_PUB.initialize;

1516: G_PKG_NAME) THEN
1517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1518: END IF;
1519: IF FND_API.to_Boolean(p_init_msg_list) THEN
1520: FND_MSG_PUB.initialize;
1521: END IF;
1522: -- Initialize API return status to SUCCESS
1523: x_return_status := FND_API.G_RET_STS_SUCCESS;
1524: -- Validate the input parameters

Line 1609: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1605:
1606: IF (FND_API.To_Boolean(p_commit)) THEN
1607: COMMIT WORK;
1608: END IF;
1609: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1610: p_data => x_msg_data,
1611: p_encoded => 'F');
1612: EXCEPTION
1613: WHEN FND_API.G_EXC_ERROR THEN

Line 1616: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1612: EXCEPTION
1613: WHEN FND_API.G_EXC_ERROR THEN
1614: ROLLBACK TO SAVE_PHYSICALMAP;
1615: x_return_status := FND_API.G_RET_STS_ERROR;
1616: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1617: p_data => x_msg_data,
1618: p_encoded => 'F');
1619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1620: ROLLBACK TO SAVE_PHYSICALMAP;

Line 1622: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1618: p_encoded => 'F');
1619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1620: ROLLBACK TO SAVE_PHYSICALMAP;
1621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1622: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1623: p_data => x_msg_data,
1624: p_encoded => 'F');
1625: WHEN OTHERS THEN
1626: ROLLBACK TO SAVE_PHYSICALMAP;

Line 1631: FND_MSG_PUB.Add;

1627: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1628: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1629: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1630: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1631: FND_MSG_PUB.Add;
1632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1633: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1634: THEN
1635: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 1633: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1629: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1630: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1631: FND_MSG_PUB.Add;
1632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1633: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1634: THEN
1635: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1636: END IF;
1637: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 1635: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1631: FND_MSG_PUB.Add;
1632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1633: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1634: THEN
1635: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1636: END IF;
1637: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1638: p_data => x_msg_data,
1639: p_encoded => 'F');

Line 1637: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1633: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1634: THEN
1635: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1636: END IF;
1637: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1638: p_data => x_msg_data,
1639: p_encoded => 'F');
1640: END save_physicalmap;
1641:

Line 1674: FND_MSG_PUB.initialize;

1670: G_PKG_NAME) THEN
1671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1672: END IF;
1673: IF FND_API.to_Boolean(p_init_msg_list) THEN
1674: FND_MSG_PUB.initialize;
1675: END IF;
1676: -- Initialize API return status to SUCCESS
1677: x_return_status := FND_API.G_RET_STS_SUCCESS;
1678: l_ocm_integration

Line 1728: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1724: END IF;
1725: IF (FND_API.To_Boolean(p_commit)) THEN
1726: COMMIT WORK;
1727: END IF;
1728: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1729: p_data => x_msg_data,
1730: p_encoded => 'F');
1731: EXCEPTION
1732: WHEN FND_API.G_EXC_ERROR THEN

Line 1735: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1731: EXCEPTION
1732: WHEN FND_API.G_EXC_ERROR THEN
1733: ROLLBACK TO DELETE_PHYSICALMAP;
1734: x_return_status := FND_API.G_RET_STS_ERROR;
1735: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1736: p_data => x_msg_data,
1737: p_encoded => 'F');
1738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1739: ROLLBACK TO DELETE_PHYSICALMAP;

Line 1741: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1737: p_encoded => 'F');
1738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1739: ROLLBACK TO DELETE_PHYSICALMAP;
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1742: p_data => x_msg_data,
1743: p_encoded => 'F');
1744: WHEN OTHERS THEN
1745: ROLLBACK TO DELETE_PHYSICALMAP;

Line 1750: FND_MSG_PUB.Add;

1746: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1747: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1748: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1749: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1750: FND_MSG_PUB.Add;
1751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1752: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1753: THEN
1754: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 1752: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1748: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1749: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1750: FND_MSG_PUB.Add;
1751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1752: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1753: THEN
1754: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1755: END IF;
1756: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 1754: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1750: FND_MSG_PUB.Add;
1751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1752: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1753: THEN
1754: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1755: END IF;
1756: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1757: p_data => x_msg_data,
1758: p_encoded => 'F');

Line 1756: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1752: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1753: THEN
1754: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1755: END IF;
1756: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1757: p_data => x_msg_data,
1758: p_encoded => 'F');
1759: END delete_physicalmap;
1760:

Line 1788: FND_MSG_PUB.initialize;

1784: G_PKG_NAME) THEN
1785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1786: END IF;
1787: IF FND_API.to_Boolean(p_init_msg_list) THEN
1788: FND_MSG_PUB.initialize;
1789: END IF;
1790: -- Initialize API return status to SUCCESS
1791: x_return_status := FND_API.G_RET_STS_SUCCESS;
1792: l_ocm_integration

Line 1813: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1809: END IF;
1810: IF (FND_API.To_Boolean(p_commit)) THEN
1811: COMMIT WORK;
1812: END IF;
1813: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1814: p_data => x_msg_data,
1815: p_encoded => 'F');
1816: EXCEPTION
1817: WHEN FND_API.G_EXC_ERROR THEN

Line 1820: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1816: EXCEPTION
1817: WHEN FND_API.G_EXC_ERROR THEN
1818: ROLLBACK TO REPLACE_CONTENT;
1819: x_return_status := FND_API.G_RET_STS_ERROR;
1820: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1821: p_data => x_msg_data,
1822: p_encoded => 'F');
1823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1824: ROLLBACK TO REPLACE_CONTENT;

Line 1826: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1822: p_encoded => 'F');
1823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1824: ROLLBACK TO REPLACE_CONTENT;
1825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1826: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1827: p_data => x_msg_data,
1828: p_encoded => 'F');
1829: WHEN OTHERS THEN
1830: ROLLBACK TO REPLACE_CONTENT;

Line 1835: FND_MSG_PUB.Add;

1831: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1832: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1833: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1834: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1835: FND_MSG_PUB.Add;
1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1837: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1838: THEN
1839: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 1837: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1833: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1834: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1835: FND_MSG_PUB.Add;
1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1837: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1838: THEN
1839: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1840: END IF;
1841: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 1839: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1835: FND_MSG_PUB.Add;
1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1837: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1838: THEN
1839: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1840: END IF;
1841: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1842: p_data => x_msg_data,
1843: p_encoded => 'F');

Line 1841: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1837: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1838: THEN
1839: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1840: END IF;
1841: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1842: p_data => x_msg_data,
1843: p_encoded => 'F');
1844: END replace_content;
1845: