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 131: FND_MSG_PUB.initialize;

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

Line 290: FND_MSG_PUB.count_and_get(

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

Line 302: FND_MSG_PUB.count_and_get (

298: EXCEPTION
299: WHEN FND_API.g_exc_error THEN
300: ROLLBACK TO Create_ListSourceType;
301: x_return_status := FND_API.g_ret_sts_error;
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 310: FND_MSG_PUB.count_and_get (

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

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

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

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

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

Line 323: FND_MSG_PUB.count_and_get(

319: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
320: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
321: END IF;
322:
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 407: FND_MSG_PUB.initialize;

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

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

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

Line 432: FND_MSG_PUB.add;

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

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

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

Line 441: FND_MSG_PUB.add;

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

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

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

Line 478: FND_MSG_PUB.add;

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

Line 522: FND_MSG_PUB.count_and_get (

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

Line 534: FND_MSG_PUB.count_and_get (

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

Line 542: FND_MSG_PUB.count_and_get (

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

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

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

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

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

Line 555: FND_MSG_PUB.count_and_get (

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

Line 617: FND_MSG_PUB.initialize;

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

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

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

Line 638: FND_MSG_PUB.add;

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

Line 645: FND_MSG_PUB.count_and_get (

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

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

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

Line 658: FND_MSG_PUB.add;

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

Line 661: FND_MSG_PUB.count_and_get(

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

Line 668: FND_MSG_PUB.count_and_get (

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

Line 675: FND_MSG_PUB.count_and_get (

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

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

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

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

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

Line 687: FND_MSG_PUB.count_and_get (

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

Line 736: FND_MSG_PUB.initialize;

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

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

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

Line 758: FND_MSG_PUB.add;

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

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

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

Line 823: FND_MSG_PUB.add;

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

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

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

Line 846: FND_MSG_PUB.Add;

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

Line 856: FND_MSG_PUB.count_and_get (

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

Line 868: FND_MSG_PUB.count_and_get (

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

Line 876: FND_MSG_PUB.count_and_get (

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

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

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

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

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

Line 890: FND_MSG_PUB.count_and_get (

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

Line 937: FND_MSG_PUB.initialize;

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

Line 985: FND_MSG_PUB.count_and_get (

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

Line 996: FND_MSG_PUB.count_and_get (

992:
993: EXCEPTION
994: WHEN FND_API.g_exc_error THEN
995: x_return_status := FND_API.g_ret_sts_error;
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 1003: FND_MSG_PUB.count_and_get (

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

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

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

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

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

Line 1015: FND_MSG_PUB.count_and_get (

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

Line 1052: FND_MSG_PUB.Add;

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

Line 1065: FND_MSG_PUB.Add;

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

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

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

Line 1297: FND_MSG_PUB.add;

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

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

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

Line 1380: FND_MSG_PUB.add;

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

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

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

Line 1391: FND_MSG_PUB.add;

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

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

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

Line 1403: FND_MSG_PUB.add;

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

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

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

Line 1414: FND_MSG_PUB.add;

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

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

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

Line 1468: FND_MSG_PUB.add;

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

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

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

Line 1482: FND_MSG_PUB.add;

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

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

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

Line 1495: FND_MSG_PUB.add;

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

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

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

Line 1509: FND_MSG_PUB.add;

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

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

1600:
1601: -- master_source_type_flag
1602: 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
1603: IF AMS_Utility_PVT.is_Y_or_N (p_listsrctype_rec.master_source_type_flag) = FND_API.g_false THEN
1604: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1605: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_MASTERSRC_FLAG');
1606: FND_MSG_PUB.add;
1607: END IF;
1608:

Line 1606: FND_MSG_PUB.add;

1602: 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
1603: IF AMS_Utility_PVT.is_Y_or_N (p_listsrctype_rec.master_source_type_flag) = FND_API.g_false THEN
1604: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1605: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_MASTERSRC_FLAG');
1606: FND_MSG_PUB.add;
1607: END IF;
1608:
1609: x_return_status := FND_API.g_ret_sts_error;
1610: RETURN;

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

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

Line 1619: FND_MSG_PUB.add;

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

Line 1730: FND_MSG_PUB.Count_And_Get (

1726: WHEN FND_API.G_EXC_ERROR THEN
1727: ROLLBACK TO generate_source_fields;
1728: x_return_status := FND_API.G_RET_STS_ERROR;
1729: -- Standard call to get message count and if count=1, get the message
1730: FND_MSG_PUB.Count_And_Get (
1731: p_encoded => FND_API.G_FALSE,
1732: p_count => x_msg_count,
1733: p_data => x_msg_data
1734: );