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

Line 133: FND_MSG_PUB.initialize;

129:
130: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
131:
132: IF FND_API.to_boolean (p_init_msg_list) THEN
133: FND_MSG_PUB.initialize;
134: END IF;
135:
136: IF NOT FND_API.compatible_api_call(
137: l_api_version,

Line 292: FND_MSG_PUB.count_and_get(

288: IF FND_API.to_boolean(p_commit) THEN
289: COMMIT;
290: END IF;
291:
292: FND_MSG_PUB.count_and_get(
293: p_encoded => FND_API.g_false,
294: p_count => x_msg_count,
295: p_data => x_msg_data
296: );

Line 304: FND_MSG_PUB.count_and_get (

300: EXCEPTION
301: WHEN FND_API.g_exc_error THEN
302: ROLLBACK TO Create_ListSourceType;
303: x_return_status := FND_API.g_ret_sts_error;
304: FND_MSG_PUB.count_and_get (
305: p_encoded => FND_API.g_false,
306: p_count => x_msg_count,
307: p_data => x_msg_data
308: );

Line 312: FND_MSG_PUB.count_and_get (

308: );
309: WHEN FND_API.g_exc_unexpected_error THEN
310: ROLLBACK TO Create_ListSourceType;
311: x_return_status := FND_API.g_ret_sts_unexp_error ;
312: FND_MSG_PUB.count_and_get (
313: p_encoded => FND_API.g_false,
314: p_count => x_msg_count,
315: p_data => x_msg_data
316: );

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

317: WHEN OTHERS THEN
318: ROLLBACK TO Create_ListSourceType;
319: x_return_status := FND_API.g_ret_sts_unexp_error ;
320:
321: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
322: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
323: END IF;
324:
325: FND_MSG_PUB.count_and_get(

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

318: ROLLBACK TO Create_ListSourceType;
319: x_return_status := FND_API.g_ret_sts_unexp_error ;
320:
321: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
322: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
323: END IF;
324:
325: FND_MSG_PUB.count_and_get(
326: p_encoded => FND_API.g_false,

Line 325: FND_MSG_PUB.count_and_get(

321: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
322: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
323: END IF;
324:
325: FND_MSG_PUB.count_and_get(
326: p_encoded => FND_API.g_false,
327: p_count => x_msg_count,
328: p_data => x_msg_data
329: );

Line 409: FND_MSG_PUB.initialize;

405:
406: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
407:
408: IF FND_API.to_boolean (p_init_msg_list) THEN
409: FND_MSG_PUB.initialize;
410: END IF;
411:
412: IF NOT FND_API.compatible_api_call (
413: l_api_version,

Line 431: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

427: open c_delete_sources ;
428: loop
429: fetch c_delete_sources into l_x;
430: exit when c_delete_sources%notfound;
431: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
432: THEN
433: FND_MESSAGE.set_name ('AMS', 'AMS_API_CANNOT_DELETE');
434: FND_MSG_PUB.add;
435: END IF;

Line 434: FND_MSG_PUB.add;

430: exit when c_delete_sources%notfound;
431: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
432: THEN
433: FND_MESSAGE.set_name ('AMS', 'AMS_API_CANNOT_DELETE');
434: FND_MSG_PUB.add;
435: END IF;
436: RAISE FND_API.g_exc_error;
437: end loop ;
438: close c_delete_sources ;

Line 440: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

436: RAISE FND_API.g_exc_error;
437: end loop ;
438: close c_delete_sources ;
439: IF (p_list_source_type_id <= 10000) THEN
440: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
441: THEN
442: FND_MESSAGE.set_name ('AMS', 'AMS_API_CANNOT_DELETE');
443: FND_MSG_PUB.add;
444: END IF;

Line 443: FND_MSG_PUB.add;

439: IF (p_list_source_type_id <= 10000) THEN
440: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
441: THEN
442: FND_MESSAGE.set_name ('AMS', 'AMS_API_CANNOT_DELETE');
443: FND_MSG_PUB.add;
444: END IF;
445: RAISE FND_API.g_exc_error;
446: END IF;
447:

Line 477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

473: ;
474:
475:
476: IF (SQL%NOTFOUND) THEN
477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
478: THEN
479: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
480: FND_MSG_PUB.add;
481: END IF;

Line 480: FND_MSG_PUB.add;

476: IF (SQL%NOTFOUND) THEN
477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
478: THEN
479: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
480: FND_MSG_PUB.add;
481: END IF;
482: RAISE FND_API.g_exc_error;
483: END IF;
484:

Line 524: FND_MSG_PUB.count_and_get (

520: IF FND_API.to_boolean (p_commit) THEN
521: COMMIT;
522: END IF;
523:
524: FND_MSG_PUB.count_and_get (
525: p_encoded => FND_API.g_false,
526: p_count => x_msg_count,
527: p_data => x_msg_data
528: );

Line 536: FND_MSG_PUB.count_and_get (

532: EXCEPTION
533: WHEN FND_API.g_exc_error THEN
534: ROLLBACK TO Delete_ListSourceType;
535: x_return_status := FND_API.g_ret_sts_error;
536: FND_MSG_PUB.count_and_get (
537: p_encoded => FND_API.g_false,
538: p_count => x_msg_count,
539: p_data => x_msg_data
540: );

Line 544: FND_MSG_PUB.count_and_get (

540: );
541: WHEN FND_API.g_exc_unexpected_error THEN
542: ROLLBACK TO Delete_ListSourceType;
543: x_return_status := FND_API.g_ret_sts_unexp_error ;
544: FND_MSG_PUB.count_and_get (
545: p_encoded => FND_API.g_false,
546: p_count => x_msg_count,
547: p_data => x_msg_data
548: );

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

549: WHEN OTHERS THEN
550: ROLLBACK TO Delete_ListSourceType;
551: x_return_status := FND_API.g_ret_sts_unexp_error ;
552:
553: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
554: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
555: END IF;
556:
557: FND_MSG_PUB.count_and_get (

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

550: ROLLBACK TO Delete_ListSourceType;
551: x_return_status := FND_API.g_ret_sts_unexp_error ;
552:
553: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
554: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
555: END IF;
556:
557: FND_MSG_PUB.count_and_get (
558: p_encoded => FND_API.g_false,

Line 557: FND_MSG_PUB.count_and_get (

553: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
554: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
555: END IF;
556:
557: FND_MSG_PUB.count_and_get (
558: p_encoded => FND_API.g_false,
559: p_count => x_msg_count,
560: p_data => x_msg_data
561: );

Line 619: FND_MSG_PUB.initialize;

615: --------------------- initialize -----------------------
616: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
617:
618: IF FND_API.to_boolean (p_init_msg_list) THEN
619: FND_MSG_PUB.initialize;
620: END IF;
621:
622: IF NOT FND_API.compatible_api_call (
623: l_api_version,

Line 638: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

634: OPEN c_lock_req;
635: FETCH c_lock_req INTO l_dummy;
636: IF c_lock_req%NOTFOUND THEN
637: CLOSE c_lock_req;
638: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
639: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
640: FND_MSG_PUB.add;
641: END IF;
642: RAISE FND_API.g_exc_error;

Line 640: FND_MSG_PUB.add;

636: IF c_lock_req%NOTFOUND THEN
637: CLOSE c_lock_req;
638: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
639: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
640: FND_MSG_PUB.add;
641: END IF;
642: RAISE FND_API.g_exc_error;
643: END IF;
644: CLOSE c_lock_req;

Line 647: FND_MSG_PUB.count_and_get (

643: END IF;
644: CLOSE c_lock_req;
645:
646: -------------------- finish --------------------------
647: FND_MSG_PUB.count_and_get (
648: p_encoded => FND_API.g_false,
649: p_count => x_msg_count,
650: p_data => x_msg_data
651: );

Line 658: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

654:
655: EXCEPTION
656: WHEN AMS_Utility_PVT.resource_locked THEN
657: x_return_status := FND_API.g_ret_sts_error;
658: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
659: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
660: FND_MSG_PUB.add;
661: END IF;
662:

Line 660: FND_MSG_PUB.add;

656: WHEN AMS_Utility_PVT.resource_locked THEN
657: x_return_status := FND_API.g_ret_sts_error;
658: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
659: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
660: FND_MSG_PUB.add;
661: END IF;
662:
663: FND_MSG_PUB.count_and_get(
664: p_encoded => FND_API.g_false,

Line 663: FND_MSG_PUB.count_and_get(

659: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
660: FND_MSG_PUB.add;
661: END IF;
662:
663: FND_MSG_PUB.count_and_get(
664: p_encoded => FND_API.g_false,
665: p_count => x_msg_count,
666: p_data => x_msg_data
667: );

Line 670: FND_MSG_PUB.count_and_get (

666: p_data => x_msg_data
667: );
668: WHEN FND_API.g_exc_error THEN
669: x_return_status := FND_API.g_ret_sts_error;
670: FND_MSG_PUB.count_and_get (
671: p_encoded => FND_API.g_false,
672: p_count => x_msg_count,
673: p_data => x_msg_data
674: );

Line 677: FND_MSG_PUB.count_and_get (

673: p_data => x_msg_data
674: );
675: WHEN FND_API.g_exc_unexpected_error THEN
676: x_return_status := FND_API.g_ret_sts_unexp_error ;
677: FND_MSG_PUB.count_and_get (
678: p_encoded => FND_API.g_false,
679: p_count => x_msg_count,
680: p_data => x_msg_data
681: );

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

680: p_data => x_msg_data
681: );
682: WHEN OTHERS THEN
683: x_return_status := FND_API.g_ret_sts_unexp_error ;
684: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
685: THEN
686: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
687: END IF;
688:

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

682: WHEN OTHERS THEN
683: x_return_status := FND_API.g_ret_sts_unexp_error ;
684: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
685: THEN
686: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
687: END IF;
688:
689: FND_MSG_PUB.count_and_get (
690: p_encoded => FND_API.g_false,

Line 689: FND_MSG_PUB.count_and_get (

685: THEN
686: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
687: END IF;
688:
689: FND_MSG_PUB.count_and_get (
690: p_encoded => FND_API.g_false,
691: p_count => x_msg_count,
692: p_data => x_msg_data
693: );

Line 738: FND_MSG_PUB.initialize;

734:
735: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
736:
737: IF FND_API.to_boolean (p_init_msg_list) THEN
738: FND_MSG_PUB.initialize;
739: END IF;
740:
741: IF NOT FND_API.compatible_api_call(
742: l_api_version,

Line 757: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

753: --do not allow update of seeded data source
754:
755: /*
756: IF (l_listsrctype_rec.list_source_type_id <= 10000) THEN
757: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
758: THEN
759: FND_MESSAGE.set_name ('AMS', 'AMS_API_CANNOT_UPDATE');
760: FND_MSG_PUB.add;
761: END IF;

Line 760: FND_MSG_PUB.add;

756: IF (l_listsrctype_rec.list_source_type_id <= 10000) THEN
757: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
758: THEN
759: FND_MESSAGE.set_name ('AMS', 'AMS_API_CANNOT_UPDATE');
760: FND_MSG_PUB.add;
761: END IF;
762: RAISE FND_API.g_exc_error;
763: END IF;
764: */

Line 823: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

819: AND object_version_number = l_listsrctype_rec.object_version_number
820: ;
821:
822: IF (SQL%NOTFOUND) THEN
823: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
824: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
825: FND_MSG_PUB.add;
826: END IF;
827: RAISE FND_API.g_exc_error;

Line 825: FND_MSG_PUB.add;

821:
822: IF (SQL%NOTFOUND) THEN
823: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
824: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
825: FND_MSG_PUB.add;
826: END IF;
827: RAISE FND_API.g_exc_error;
828: END IF;
829:

Line 845: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

841: ------------------------------------------------------------------
842: -- Error, check the msg level and added an error message to the --
843: -- API message list. --
844: ------------------------------------------------------------------
845: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
846: FND_MESSAGE.set_name('AMS', 'API_UNEXP_ERROR_IN_PROCESSING');
847: FND_MESSAGE.Set_Token('ROW', 'AMS_ListSourceType_PVT.Upd_AMS_LIST_SRC_TYPES_TL', TRUE);
848: FND_MSG_PUB.Add;
849: END IF;

Line 848: FND_MSG_PUB.Add;

844: ------------------------------------------------------------------
845: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
846: FND_MESSAGE.set_name('AMS', 'API_UNEXP_ERROR_IN_PROCESSING');
847: FND_MESSAGE.Set_Token('ROW', 'AMS_ListSourceType_PVT.Upd_AMS_LIST_SRC_TYPES_TL', TRUE);
848: FND_MSG_PUB.Add;
849: END IF;
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: END IF;
852:

Line 858: FND_MSG_PUB.count_and_get (

854: IF FND_API.to_boolean (p_commit) THEN
855: COMMIT;
856: END IF;
857:
858: FND_MSG_PUB.count_and_get (
859: p_encoded => FND_API.g_false,
860: p_count => x_msg_count,
861: p_data => x_msg_data
862: );

Line 870: FND_MSG_PUB.count_and_get (

866: EXCEPTION
867: WHEN FND_API.g_exc_error THEN
868: ROLLBACK TO Update_ListSourceType;
869: x_return_status := FND_API.g_ret_sts_error;
870: FND_MSG_PUB.count_and_get (
871: p_encoded => FND_API.g_false,
872: p_count => x_msg_count,
873: p_data => x_msg_data
874: );

Line 878: FND_MSG_PUB.count_and_get (

874: );
875: WHEN FND_API.g_exc_unexpected_error THEN
876: ROLLBACK TO Update_ListSourceType;
877: x_return_status := FND_API.g_ret_sts_unexp_error ;
878: FND_MSG_PUB.count_and_get (
879: p_encoded => FND_API.g_false,
880: p_count => x_msg_count,
881: p_data => x_msg_data
882: );

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

883: WHEN OTHERS THEN
884: ROLLBACK TO Update_ListSourceType;
885: x_return_status := FND_API.g_ret_sts_unexp_error ;
886:
887: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
888: THEN
889: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
890: END IF;
891:

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

885: x_return_status := FND_API.g_ret_sts_unexp_error ;
886:
887: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
888: THEN
889: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
890: END IF;
891:
892: FND_MSG_PUB.count_and_get (
893: p_encoded => FND_API.g_false,

Line 892: FND_MSG_PUB.count_and_get (

888: THEN
889: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
890: END IF;
891:
892: FND_MSG_PUB.count_and_get (
893: p_encoded => FND_API.g_false,
894: p_count => x_msg_count,
895: p_data => x_msg_data
896: );

Line 939: FND_MSG_PUB.initialize;

935: --------------------- initialize -----------------------
936: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
937:
938: IF FND_API.to_boolean (p_init_msg_list) THEN
939: FND_MSG_PUB.initialize;
940: END IF;
941:
942: IF NOT FND_API.compatible_api_call (
943: l_api_version,

Line 987: FND_MSG_PUB.count_and_get (

983: END IF;
984: END IF;
985:
986: -------------------- finish --------------------------
987: FND_MSG_PUB.count_and_get (
988: p_encoded => FND_API.g_false,
989: p_count => x_msg_count,
990: p_data => x_msg_data
991: );

Line 998: FND_MSG_PUB.count_and_get (

994:
995: EXCEPTION
996: WHEN FND_API.g_exc_error THEN
997: x_return_status := FND_API.g_ret_sts_error;
998: FND_MSG_PUB.count_and_get (
999: p_encoded => FND_API.g_false,
1000: p_count => x_msg_count,
1001: p_data => x_msg_data
1002: );

Line 1005: FND_MSG_PUB.count_and_get (

1001: p_data => x_msg_data
1002: );
1003: WHEN FND_API.g_exc_unexpected_error THEN
1004: x_return_status := FND_API.g_ret_sts_unexp_error ;
1005: FND_MSG_PUB.count_and_get (
1006: p_encoded => FND_API.g_false,
1007: p_count => x_msg_count,
1008: p_data => x_msg_data
1009: );

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

1008: p_data => x_msg_data
1009: );
1010: WHEN OTHERS THEN
1011: x_return_status := FND_API.g_ret_sts_unexp_error;
1012: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
1013: THEN
1014: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1015: END IF;
1016:

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

1010: WHEN OTHERS THEN
1011: x_return_status := FND_API.g_ret_sts_unexp_error;
1012: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
1013: THEN
1014: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1015: END IF;
1016:
1017: FND_MSG_PUB.count_and_get (
1018: p_encoded => FND_API.g_false,

Line 1017: FND_MSG_PUB.count_and_get (

1013: THEN
1014: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1015: END IF;
1016:
1017: FND_MSG_PUB.count_and_get (
1018: p_encoded => FND_API.g_false,
1019: p_count => x_msg_count,
1020: p_data => x_msg_data
1021: );

Line 1054: FND_MSG_PUB.Add;

1050: FETCH c_import_type into l_import_type;
1051: IF (c_import_type%NOTFOUND) THEN
1052: CLOSE c_import_type;
1053: FND_MESSAGE.SET_NAME('AMS', 'AMS_INVALID_IMPORT_TYPE');
1054: FND_MSG_PUB.Add;
1055: x_return_status := FND_API.g_ret_sts_error;
1056: RETURN;
1057: END IF;
1058: CLOSE c_import_type;

Line 1067: FND_MSG_PUB.Add;

1063: OPEN c_viewname(p_listsrctype_rec.source_type_code);
1064: FETCH c_viewname into l_cnt;
1065: IF l_cnt > 1 THEN
1066: FND_MESSAGE.SET_NAME('AMS', 'AMS_INVALID_SOURCE_TYPE_CODE');
1067: FND_MSG_PUB.Add;
1068: x_return_status := FND_API.g_ret_sts_error;
1069: RETURN;
1070: END IF;
1071: CLOSE c_viewname;

Line 1297: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1293: OPEN c_fields;
1294: FETCH c_fields INTO l_listsrctype_rec;
1295: IF c_fields%NOTFOUND THEN
1296: CLOSE c_fields;
1297: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1298: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1299: FND_MSG_PUB.add;
1300: END IF;
1301: RAISE FND_API.g_exc_error;

Line 1299: FND_MSG_PUB.add;

1295: IF c_fields%NOTFOUND THEN
1296: CLOSE c_fields;
1297: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1298: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1299: FND_MSG_PUB.add;
1300: END IF;
1301: RAISE FND_API.g_exc_error;
1302: END IF;
1303: CLOSE c_fields;

Line 1380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1376:
1377:
1378: -- list_source_type
1379: IF p_listsrctype_rec.list_source_type IS NULL THEN
1380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1381: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_LISTSRC_TYPE');
1382: FND_MSG_PUB.add;
1383: END IF;
1384:

Line 1382: FND_MSG_PUB.add;

1378: -- list_source_type
1379: IF p_listsrctype_rec.list_source_type IS NULL THEN
1380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1381: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_LISTSRC_TYPE');
1382: FND_MSG_PUB.add;
1383: END IF;
1384:
1385: x_return_status := FND_API.g_ret_sts_error;
1386: RETURN;

Line 1391: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1387: END IF;
1388:
1389: -- list_source_name
1390: IF p_listsrctype_rec.list_source_name IS NULL THEN
1391: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1392: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_LISTSRC_NAME');
1393: FND_MSG_PUB.add;
1394: END IF;
1395:

Line 1393: FND_MSG_PUB.add;

1389: -- list_source_name
1390: IF p_listsrctype_rec.list_source_name IS NULL THEN
1391: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1392: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_LISTSRC_NAME');
1393: FND_MSG_PUB.add;
1394: END IF;
1395:
1396: x_return_status := FND_API.g_ret_sts_error;
1397: RETURN;

Line 1403: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1399:
1400:
1401: -- source_type_code
1402: IF p_listsrctype_rec.source_type_code IS NULL THEN
1403: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1404: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_SRCTYPE_CODE');
1405: FND_MSG_PUB.add;
1406: END IF;
1407:

Line 1405: FND_MSG_PUB.add;

1401: -- source_type_code
1402: IF p_listsrctype_rec.source_type_code IS NULL THEN
1403: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1404: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_SRCTYPE_CODE');
1405: FND_MSG_PUB.add;
1406: END IF;
1407:
1408: x_return_status := FND_API.g_ret_sts_error;
1409: RETURN;

Line 1414: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1410: END IF;
1411:
1412: -- source_object_name
1413: IF p_listsrctype_rec.source_object_name IS NULL THEN
1414: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1415: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_SRCOBJ_NAME');
1416: FND_MSG_PUB.add;
1417: END IF;
1418:

Line 1416: FND_MSG_PUB.add;

1412: -- source_object_name
1413: IF p_listsrctype_rec.source_object_name IS NULL THEN
1414: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1415: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_SRCOBJ_NAME');
1416: FND_MSG_PUB.add;
1417: END IF;
1418:
1419: x_return_status := FND_API.g_ret_sts_error;
1420: RETURN;

Line 1468: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1464: OPEN c_name_create (p_listsrctype_rec.list_source_name);
1465: FETCH c_name_create INTO l_valid_flag;
1466: CLOSE c_name_create;
1467: IF l_valid_flag IS NOT NULL THEN
1468: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1469: FND_MESSAGE.set_name('AMS', 'AMS_LIST_DUPE_LISTSRC_NAME');
1470: FND_MSG_PUB.add;
1471: END IF;
1472: x_return_status := FND_API.g_ret_sts_error;

Line 1470: FND_MSG_PUB.add;

1466: CLOSE c_name_create;
1467: IF l_valid_flag IS NOT NULL THEN
1468: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1469: FND_MESSAGE.set_name('AMS', 'AMS_LIST_DUPE_LISTSRC_NAME');
1470: FND_MSG_PUB.add;
1471: END IF;
1472: x_return_status := FND_API.g_ret_sts_error;
1473: l_valid_flag := NULL;
1474: END IF;

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

1478: p_table_name => l_list_src_types_table,
1479: p_where_clause => l_where_clause
1480: );
1481: IF l_valid_flag = FND_API.g_false THEN
1482: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1483: FND_MESSAGE.set_name('AMS', 'AMS_LIST_DUPE_LISTSRC_TYPE');
1484: FND_MSG_PUB.add;
1485: END IF;
1486: x_return_status := FND_API.g_ret_sts_error;

Line 1484: FND_MSG_PUB.add;

1480: );
1481: IF l_valid_flag = FND_API.g_false THEN
1482: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1483: FND_MESSAGE.set_name('AMS', 'AMS_LIST_DUPE_LISTSRC_TYPE');
1484: FND_MSG_PUB.add;
1485: END IF;
1486: x_return_status := FND_API.g_ret_sts_error;
1487: l_valid_flag := NULL;
1488: END IF;

Line 1495: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1491: OPEN c_name_update (p_listsrctype_rec.list_source_name, p_listsrctype_rec.list_source_type_id);
1492: FETCH c_name_update INTO l_valid_flag;
1493: CLOSE c_name_update;
1494: IF l_valid_flag IS NOT NULL THEN
1495: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1496: FND_MESSAGE.set_name('AMS', 'AMS_LIST_DUPE_LISTSRC_NAME');
1497: FND_MSG_PUB.add;
1498: END IF;
1499: x_return_status := FND_API.g_ret_sts_error;

Line 1497: FND_MSG_PUB.add;

1493: CLOSE c_name_update;
1494: IF l_valid_flag IS NOT NULL THEN
1495: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1496: FND_MESSAGE.set_name('AMS', 'AMS_LIST_DUPE_LISTSRC_NAME');
1497: FND_MSG_PUB.add;
1498: END IF;
1499: x_return_status := FND_API.g_ret_sts_error;
1500: l_valid_flag := NULL;
1501: END IF;

Line 1509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1505: p_table_name => l_list_src_types_table,
1506: p_where_clause => l_where_clause || ' AND list_source_type_id <> ' || p_listsrctype_rec.list_source_type_id
1507: );
1508: IF l_valid_flag = FND_API.g_false THEN
1509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1510: FND_MESSAGE.set_name('AMS', 'AMS_LIST_DUPE_LISTSRC_TYPE');
1511: FND_MSG_PUB.add;
1512: END IF;
1513: x_return_status := FND_API.g_ret_sts_error;

Line 1511: FND_MSG_PUB.add;

1507: );
1508: IF l_valid_flag = FND_API.g_false THEN
1509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1510: FND_MESSAGE.set_name('AMS', 'AMS_LIST_DUPE_LISTSRC_TYPE');
1511: FND_MSG_PUB.add;
1512: END IF;
1513: x_return_status := FND_API.g_ret_sts_error;
1514: l_valid_flag := NULL;
1515: END IF;

Line 1606: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

1602:
1603: -- master_source_type_flag
1604: IF p_listsrctype_rec.master_source_type_flag <> FND_API.g_miss_char AND p_listsrctype_rec.master_source_type_flag IS NOT NULL THEN
1605: IF AMS_Utility_PVT.is_Y_or_N (p_listsrctype_rec.master_source_type_flag) = FND_API.g_false THEN
1606: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1607: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_MASTERSRC_FLAG');
1608: FND_MSG_PUB.add;
1609: END IF;
1610:

Line 1608: FND_MSG_PUB.add;

1604: IF p_listsrctype_rec.master_source_type_flag <> FND_API.g_miss_char AND p_listsrctype_rec.master_source_type_flag IS NOT NULL THEN
1605: IF AMS_Utility_PVT.is_Y_or_N (p_listsrctype_rec.master_source_type_flag) = FND_API.g_false THEN
1606: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1607: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_MASTERSRC_FLAG');
1608: FND_MSG_PUB.add;
1609: END IF;
1610:
1611: x_return_status := FND_API.g_ret_sts_error;
1612: RETURN;

Line 1619: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

1615:
1616: -- enabled_flag
1617: IF p_listsrctype_rec.enabled_flag <> FND_API.g_miss_char AND p_listsrctype_rec.enabled_flag IS NOT NULL THEN
1618: IF AMS_Utility_PVT.is_Y_or_N (p_listsrctype_rec.enabled_flag) = FND_API.g_false THEN
1619: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1620: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_ENABLED_FLAG');
1621: FND_MSG_PUB.add;
1622: END IF;
1623:

Line 1621: FND_MSG_PUB.add;

1617: IF p_listsrctype_rec.enabled_flag <> FND_API.g_miss_char AND p_listsrctype_rec.enabled_flag IS NOT NULL THEN
1618: IF AMS_Utility_PVT.is_Y_or_N (p_listsrctype_rec.enabled_flag) = FND_API.g_false THEN
1619: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1620: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_ENABLED_FLAG');
1621: FND_MSG_PUB.add;
1622: END IF;
1623:
1624: x_return_status := FND_API.g_ret_sts_error;
1625: RETURN;

Line 1739: FND_MSG_PUB.Count_And_Get (

1735: WHEN FND_API.G_EXC_ERROR THEN
1736: ROLLBACK TO generate_source_fields;
1737: x_return_status := FND_API.G_RET_STS_ERROR;
1738: -- Standard call to get message count and if count=1, get the message
1739: FND_MSG_PUB.Count_And_Get (
1740: p_encoded => FND_API.G_FALSE,
1741: p_count => x_msg_count,
1742: p_data => x_msg_data
1743: );