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

Line 13: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

9: -- History
10: -- 01/04/2000 julou created
11: -- 11/29/2000 musman bug 1519059 fix.Changed the cursor in check_uk_items procedure.
12: -------------------------------------------------------------------------------
13: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
14: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
15: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
16:
17: PROCEDURE create_msg

Line 14: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

10: -- 01/04/2000 julou created
11: -- 11/29/2000 musman bug 1519059 fix.Changed the cursor in check_uk_items procedure.
12: -------------------------------------------------------------------------------
13: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
14: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
15: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
16:
17: PROCEDURE create_msg
18: (

Line 15: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

11: -- 11/29/2000 musman bug 1519059 fix.Changed the cursor in check_uk_items procedure.
12: -------------------------------------------------------------------------------
13: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
14: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
15: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
16:
17: PROCEDURE create_msg
18: (
19: p_api_version IN NUMBER,

Line 54: FND_MSG_PUB.initialize;

50: -- initialize
51: SAVEPOINT create_msg;
52:
53: IF FND_API.to_boolean(p_init_msg_list) THEN
54: FND_MSG_PUB.initialize;
55: END IF;
56:
57:
58: IF (AMS_DEBUG_HIGH_ON) THEN

Line 247: FND_MSG_PUB.count_and_get

243: IF FND_API.to_boolean(p_commit) THEN
244: COMMIT;
245: END IF;
246:
247: FND_MSG_PUB.count_and_get
248: (
249: p_encoded => FND_API.g_false,
250: p_count => x_msg_count,
251: p_data => x_msg_data

Line 267: FND_MSG_PUB.count_and_get

263:
264: WHEN FND_API.g_exc_error THEN
265: ROLLBACK TO create_msg;
266: x_return_status := FND_API.g_ret_sts_error;
267: FND_MSG_PUB.count_and_get
268: (
269: p_encoded => FND_API.g_false,
270: p_count => x_msg_count,
271: p_data => x_msg_data

Line 277: FND_MSG_PUB.count_and_get

273:
274: WHEN FND_API.g_exc_unexpected_error THEN
275: ROLLBACK TO create_msg;
276: x_return_status := FND_API.g_ret_sts_unexp_error;
277: FND_MSG_PUB.count_and_get
278: (
279: p_encoded => FND_API.g_false,
280: p_count => x_msg_count,
281: p_data => x_msg_data

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

283:
284: WHEN OTHERS THEN
285: ROLLBACK TO create_msg;
286: x_return_status :=FND_API.g_ret_sts_unexp_error;
287: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
288: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
289: END IF;
290: FND_MSG_PUB.count_and_get
291: (

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

284: WHEN OTHERS THEN
285: ROLLBACK TO create_msg;
286: x_return_status :=FND_API.g_ret_sts_unexp_error;
287: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
288: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
289: END IF;
290: FND_MSG_PUB.count_and_get
291: (
292: p_encoded => FND_API.g_false,

Line 290: FND_MSG_PUB.count_and_get

286: x_return_status :=FND_API.g_ret_sts_unexp_error;
287: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
288: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
289: END IF;
290: FND_MSG_PUB.count_and_get
291: (
292: p_encoded => FND_API.g_false,
293: p_count => x_msg_count,
294: p_data => x_msg_data

Line 333: FND_MSG_PUB.initialize;

329: -- initialize
330: SAVEPOINT update_msg;
331:
332: IF FND_API.to_boolean(p_init_msg_list) THEN
333: FND_MSG_PUB.initialize;
334: END IF;
335:
336: IF (AMS_DEBUG_HIGH_ON) THEN
337:

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

444: WHERE message_id = l_msg_rec.message_id
445: AND object_version_number = l_msg_rec.object_version_number;
446:
447: IF (SQL%NOTFOUND) THEN
448: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
449: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
450: FND_MSG_PUB.add;
451: END IF;
452: RAISE FND_API.g_exc_error;

Line 450: FND_MSG_PUB.add;

446:
447: IF (SQL%NOTFOUND) THEN
448: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
449: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
450: FND_MSG_PUB.add;
451: END IF;
452: RAISE FND_API.g_exc_error;
453: END IF;
454:

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

462: WHERE message_id = l_msg_rec.message_id
463: AND USERENV('LANG') IN (language, source_lang);
464:
465: IF (SQL%NOTFOUND) THEN
466: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
467: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
468: FND_MSG_PUB.add;
469: END IF;
470: RAISE FND_API.g_exc_error;

Line 468: FND_MSG_PUB.add;

464:
465: IF (SQL%NOTFOUND) THEN
466: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
467: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
468: FND_MSG_PUB.add;
469: END IF;
470: RAISE FND_API.g_exc_error;
471: END IF;
472:

Line 478: FND_MSG_PUB.count_and_get

474: IF FND_API.to_boolean(p_commit) THEN
475: COMMIT;
476: END IF;
477:
478: FND_MSG_PUB.count_and_get
479: (
480: P_ENCODED => FND_API.g_false,
481: p_count => x_msg_count,
482: p_data => x_msg_data

Line 498: FND_MSG_PUB.count_and_get

494:
495: WHEN FND_API.g_exc_error THEN
496: ROLLBACK TO update_msg;
497: x_return_status := FND_API.g_ret_sts_error;
498: FND_MSG_PUB.count_and_get
499: (
500: p_encoded => FND_API.g_false,
501: p_count => x_msg_count,
502: p_data => x_msg_data

Line 508: FND_MSG_PUB.count_and_get

504:
505: WHEN FND_API.g_exc_unexpected_error THEN
506: ROLLBACK TO update_msg;
507: x_return_status := FND_API.g_ret_sts_unexp_error;
508: FND_MSG_PUB.count_and_get
509: (
510: p_encoded => FND_API.g_false,
511: p_count => x_msg_count,
512: p_data => x_msg_data

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

514:
515: WHEN OTHERS THEN
516: ROLLBACK TO update_msg;
517: x_return_status :=FND_API.g_ret_sts_unexp_error;
518: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
519: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
520: END IF;
521: FND_MSG_PUB.count_and_get
522: (

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

515: WHEN OTHERS THEN
516: ROLLBACK TO update_msg;
517: x_return_status :=FND_API.g_ret_sts_unexp_error;
518: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
519: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
520: END IF;
521: FND_MSG_PUB.count_and_get
522: (
523: p_encoded => FND_API.g_false,

Line 521: FND_MSG_PUB.count_and_get

517: x_return_status :=FND_API.g_ret_sts_unexp_error;
518: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
519: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
520: END IF;
521: FND_MSG_PUB.count_and_get
522: (
523: p_encoded => FND_API.g_false,
524: p_count => x_msg_count,
525: p_data => x_msg_data

Line 569: FND_MSG_PUB.initialize;

565:
566: END IF;
567:
568: IF FND_API.to_boolean(p_init_msg_list) THEN
569: FND_MSG_PUB.initialize;
570: END IF;
571:
572: IF NOT FND_API.compatible_api_call
573: (

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

591: DELETE FROM AMS_MESSAGES_TL
592: WHERE message_id = p_msg_id;
593:
594: IF (SQL%NOTFOUND) THEN
595: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
596: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
597: FND_MSG_PUB.add;
598: END IF;
599: RAISE FND_API.g_exc_error;

Line 597: FND_MSG_PUB.add;

593:
594: IF (SQL%NOTFOUND) THEN
595: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
596: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
597: FND_MSG_PUB.add;
598: END IF;
599: RAISE FND_API.g_exc_error;
600: END IF;
601:

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

603: WHERE message_id = p_msg_id
604: AND object_version_number = p_object_version;
605:
606: IF (SQL%NOTFOUND) THEN
607: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
608: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
609: FND_MSG_PUB.add;
610: END IF;
611: RAISE FND_API.g_exc_error;

Line 609: FND_MSG_PUB.add;

605:
606: IF (SQL%NOTFOUND) THEN
607: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
608: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
609: FND_MSG_PUB.add;
610: END IF;
611: RAISE FND_API.g_exc_error;
612: END IF;
613:

Line 619: FND_MSG_PUB.count_and_get

615: IF FND_API.to_boolean(p_commit) THEN
616: COMMIT;
617: END IF;
618:
619: FND_MSG_PUB.count_and_get
620: (
621: P_ENCODED => FND_API.g_false,
622: p_count => x_msg_count,
623: p_data => x_msg_data

Line 639: FND_MSG_PUB.count_and_get

635:
636: WHEN FND_API.g_exc_error THEN
637: ROLLBACK TO delete_msg;
638: x_return_status := FND_API.g_ret_sts_error;
639: FND_MSG_PUB.count_and_get
640: (
641: p_encoded => FND_API.g_false,
642: p_count => x_msg_count,
643: p_data => x_msg_data

Line 649: FND_MSG_PUB.count_and_get

645:
646: WHEN FND_API.g_exc_unexpected_error THEN
647: ROLLBACK TO delete_msg;
648: x_return_status := FND_API.g_ret_sts_unexp_error;
649: FND_MSG_PUB.count_and_get
650: (
651: p_encoded => FND_API.g_false,
652: p_count => x_msg_count,
653: p_data => x_msg_data

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

655:
656: WHEN OTHERS THEN
657: ROLLBACK TO delete_msg;
658: x_return_status :=FND_API.g_ret_sts_unexp_error;
659: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
660: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
661: END IF;
662: FND_MSG_PUB.count_and_get
663: (

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

656: WHEN OTHERS THEN
657: ROLLBACK TO delete_msg;
658: x_return_status :=FND_API.g_ret_sts_unexp_error;
659: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
660: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
661: END IF;
662: FND_MSG_PUB.count_and_get
663: (
664: p_encoded => FND_API.g_false,

Line 662: FND_MSG_PUB.count_and_get

658: x_return_status :=FND_API.g_ret_sts_unexp_error;
659: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
660: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
661: END IF;
662: FND_MSG_PUB.count_and_get
663: (
664: p_encoded => FND_API.g_false,
665: p_count => x_msg_count,
666: p_data => x_msg_data

Line 719: FND_MSG_PUB.initialize;

715: AMS_Utility_PVT.debug_message(l_full_name || ': start');
716: END IF;
717:
718: IF FND_API.to_boolean(p_init_msg_list) THEN
719: FND_MSG_PUB.initialize;
720: END IF;
721:
722: IF NOT FND_API.compatible_api_call
723: (

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

741: OPEN c_msg_b;
742: FETCH c_msg_b INTO l_msg_id;
743: IF (c_msg_b%NOTFOUND) THEN
744: CLOSE c_msg_b;
745: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
746: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
747: FND_MSG_PUB.add;
748: END IF;
749: RAISE FND_API.g_exc_error;

Line 747: FND_MSG_PUB.add;

743: IF (c_msg_b%NOTFOUND) THEN
744: CLOSE c_msg_b;
745: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
746: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
747: FND_MSG_PUB.add;
748: END IF;
749: RAISE FND_API.g_exc_error;
750: END IF;
751: CLOSE c_msg_b;

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

753: OPEN c_msg_tl;
754: FETCH c_msg_tl INTO l_msg_id;
755: IF (c_msg_tl%NOTFOUND) THEN
756: CLOSE c_msg_tl;
757: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
758: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
759: FND_MSG_PUB.add;
760: END IF;
761: RAISE FND_API.g_exc_error;

Line 759: FND_MSG_PUB.add;

755: IF (c_msg_tl%NOTFOUND) THEN
756: CLOSE c_msg_tl;
757: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
758: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
759: FND_MSG_PUB.add;
760: END IF;
761: RAISE FND_API.g_exc_error;
762: END IF;
763: CLOSE c_msg_tl;

Line 766: FND_MSG_PUB.count_and_get

762: END IF;
763: CLOSE c_msg_tl;
764:
765: -- finish
766: FND_MSG_PUB.count_and_get
767: (
768: p_encoded => FND_API.g_false,
769: p_count => x_msg_count,
770: p_data => x_msg_data

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

781: EXCEPTION
782:
783: WHEN AMS_Utility_PVT.resource_locked THEN
784: x_return_status := FND_API.g_ret_sts_error;
785: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
786: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
787: FND_MSG_PUB.add;
788: END IF;
789: FND_MSG_PUB.count_and_get

Line 787: FND_MSG_PUB.add;

783: WHEN AMS_Utility_PVT.resource_locked THEN
784: x_return_status := FND_API.g_ret_sts_error;
785: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
786: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
787: FND_MSG_PUB.add;
788: END IF;
789: FND_MSG_PUB.count_and_get
790: (
791: p_encoded => FND_API.g_false,

Line 789: FND_MSG_PUB.count_and_get

785: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
786: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
787: FND_MSG_PUB.add;
788: END IF;
789: FND_MSG_PUB.count_and_get
790: (
791: p_encoded => FND_API.g_false,
792: p_count => x_msg_count,
793: p_data => x_msg_data

Line 798: FND_MSG_PUB.count_and_get

794: );
795:
796: WHEN FND_API.g_exc_error THEN
797: x_return_status := FND_API.g_ret_sts_error;
798: FND_MSG_PUB.count_and_get
799: (
800: p_encoded => FND_API.g_false,
801: p_count => x_msg_count,
802: p_data => x_msg_data

Line 807: FND_MSG_PUB.count_and_get

803: );
804:
805: WHEN FND_API.g_exc_unexpected_error THEN
806: x_return_status := FND_API.g_ret_sts_unexp_error;
807: FND_MSG_PUB.count_and_get
808: (
809: p_encoded => FND_API.g_false,
810: p_count => x_msg_count,
811: p_data => x_msg_data

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

812: );
813:
814: WHEN OTHERS THEN
815: x_return_status :=FND_API.g_ret_sts_unexp_error;
816: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
817: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
818: END IF;
819: FND_MSG_PUB.count_and_get
820: (

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

813:
814: WHEN OTHERS THEN
815: x_return_status :=FND_API.g_ret_sts_unexp_error;
816: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
817: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
818: END IF;
819: FND_MSG_PUB.count_and_get
820: (
821: p_encoded => FND_API.g_false,

Line 819: FND_MSG_PUB.count_and_get

815: x_return_status :=FND_API.g_ret_sts_unexp_error;
816: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
817: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
818: END IF;
819: FND_MSG_PUB.count_and_get
820: (
821: p_encoded => FND_API.g_false,
822: p_count => x_msg_count,
823: p_data => x_msg_data

Line 917: FND_MSG_PUB.count_and_get

913: RAISE FND_API.g_exc_error;
914: END IF;
915: END IF;
916: -------------------- finish --------------------------
917: FND_MSG_PUB.count_and_get
918: (
919: p_encoded => FND_API.g_false,
920: p_count => x_msg_count,
921: p_data => x_msg_data

Line 935: FND_MSG_PUB.count_and_get

931:
932: EXCEPTION
933: WHEN FND_API.g_exc_error THEN
934: x_return_status := FND_API.g_ret_sts_error;
935: FND_MSG_PUB.count_and_get
936: (
937: p_encoded => FND_API.g_false,
938: p_count => x_msg_count,
939: p_data => x_msg_data

Line 944: FND_MSG_PUB.count_and_get

940: );
941:
942: WHEN FND_API.g_exc_unexpected_error THEN
943: x_return_status := FND_API.g_ret_sts_unexp_error ;
944: FND_MSG_PUB.count_and_get
945: (
946: p_encoded => FND_API.g_false,
947: p_count => x_msg_count,
948: p_data => x_msg_data

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

949: );
950:
951: WHEN OTHERS THEN
952: x_return_status := FND_API.g_ret_sts_unexp_error;
953: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
954: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
955: END IF;
956:
957: FND_MSG_PUB.count_and_get

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

950:
951: WHEN OTHERS THEN
952: x_return_status := FND_API.g_ret_sts_unexp_error;
953: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
954: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
955: END IF;
956:
957: FND_MSG_PUB.count_and_get
958: (

Line 957: FND_MSG_PUB.count_and_get

953: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
954: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
955: END IF;
956:
957: FND_MSG_PUB.count_and_get
958: (
959: p_encoded => FND_API.g_false,
960: p_count => x_msg_count,
961: p_data => x_msg_data

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

1045:
1046: -- check message_id
1047: IF p_msg_rec.message_id IS NULL
1048: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
1049: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1050: FND_MESSAGE.set_name('AMS', 'AMS_MSG_NO_MSG_ID');
1051: FND_MSG_PUB.add;
1052: END IF;
1053:

Line 1051: FND_MSG_PUB.add;

1047: IF p_msg_rec.message_id IS NULL
1048: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
1049: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1050: FND_MESSAGE.set_name('AMS', 'AMS_MSG_NO_MSG_ID');
1051: FND_MSG_PUB.add;
1052: END IF;
1053:
1054: x_return_status := FND_API.g_ret_sts_error;
1055: RETURN;

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

1058: -- check object_version_number
1059: IF p_msg_rec.object_version_number IS NULL
1060: AND p_validation_mode = JTF_PLSQL_API.g_update
1061: THEN
1062: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1063: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');
1064: FND_MSG_PUB.add;
1065: END IF;
1066:

Line 1064: FND_MSG_PUB.add;

1060: AND p_validation_mode = JTF_PLSQL_API.g_update
1061: THEN
1062: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1063: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');
1064: FND_MSG_PUB.add;
1065: END IF;
1066:
1067: x_return_status := FND_API.g_ret_sts_error;
1068: RETURN;

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

1069: END IF;
1070:
1071: -- check active_flag
1072: IF p_msg_rec.active_flag IS NULL THEN
1073: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1074: FND_MESSAGE.set_name('AMS', 'AMS_MSG_BAD_ACTIVE_FLAG');
1075: FND_MSG_PUB.add;
1076: END IF;
1077:

Line 1075: FND_MSG_PUB.add;

1071: -- check active_flag
1072: IF p_msg_rec.active_flag IS NULL THEN
1073: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1074: FND_MESSAGE.set_name('AMS', 'AMS_MSG_BAD_ACTIVE_FLAG');
1075: FND_MSG_PUB.add;
1076: END IF;
1077:
1078: x_return_status := FND_API.g_ret_sts_error;
1079: RETURN;

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

1082: IF p_msg_rec.active_flag <> 'Y'
1083: AND p_msg_rec.active_flag <> 'N'
1084: AND p_msg_rec.active_flag <> FND_API.g_miss_char
1085: THEN
1086: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1087: FND_MESSAGE.set_name('AMS', 'AMS_MSG_BAD_ACTIVE_FLAG');
1088: FND_MSG_PUB.add;
1089: END IF;
1090:

Line 1088: FND_MSG_PUB.add;

1084: AND p_msg_rec.active_flag <> FND_API.g_miss_char
1085: THEN
1086: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1087: FND_MESSAGE.set_name('AMS', 'AMS_MSG_BAD_ACTIVE_FLAG');
1088: FND_MSG_PUB.add;
1089: END IF;
1090:
1091: x_return_status := FND_API.g_ret_sts_error;
1092: RETURN;

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

1093: END IF;
1094:
1095: -- check message_name
1096: IF p_msg_rec.message_name IS NULL THEN
1097: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1098: FND_MESSAGE.set_name('AMS', 'AMS_MSG_NO_MSG_NAME');
1099: FND_MSG_PUB.add;
1100: END IF;
1101:

Line 1099: FND_MSG_PUB.add;

1095: -- check message_name
1096: IF p_msg_rec.message_name IS NULL THEN
1097: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1098: FND_MESSAGE.set_name('AMS', 'AMS_MSG_NO_MSG_NAME');
1099: FND_MSG_PUB.add;
1100: END IF;
1101:
1102: x_return_status := FND_API.g_ret_sts_error;
1103: RETURN;

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

1153: );
1154: END IF;
1155:
1156: IF l_uk_flag = FND_API.g_false THEN
1157: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1158: FND_MESSAGE.set_name('AMS', 'AMS_MSG_DUPLICATE_MSG_ID');
1159: FND_MSG_PUB.add;
1160: END IF;
1161:

Line 1159: FND_MSG_PUB.add;

1155:
1156: IF l_uk_flag = FND_API.g_false THEN
1157: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1158: FND_MESSAGE.set_name('AMS', 'AMS_MSG_DUPLICATE_MSG_ID');
1159: FND_MSG_PUB.add;
1160: END IF;
1161:
1162: x_return_status := FND_API.g_ret_sts_error;
1163: RETURN;

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

1183: );
1184: END IF;
1185:
1186: IF l_uk_flag = FND_API.g_false THEN
1187: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1188: FND_MESSAGE.set_name('AMS', 'AMS_MSG_DUP_NAME_LANG');
1189: FND_MSG_PUB.add;
1190: END IF;
1191:

Line 1189: FND_MSG_PUB.add;

1185:
1186: IF l_uk_flag = FND_API.g_false THEN
1187: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1188: FND_MESSAGE.set_name('AMS', 'AMS_MSG_DUP_NAME_LANG');
1189: FND_MSG_PUB.add;
1190: END IF;
1191:
1192: ***************/
1193: l_flag := 'N';

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

1209:
1210: END IF;
1211:
1212: IF ( l_flag = 'Y') THEN
1213: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1214: FND_MESSAGE.set_name('AMS', 'AMS_MSG_DUP_NAME_LANG');
1215: FND_MSG_PUB.add;
1216: END IF;
1217: x_return_status := FND_API.g_ret_sts_error;

Line 1215: FND_MSG_PUB.add;

1211:
1212: IF ( l_flag = 'Y') THEN
1213: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1214: FND_MESSAGE.set_name('AMS', 'AMS_MSG_DUP_NAME_LANG');
1215: FND_MSG_PUB.add;
1216: END IF;
1217: x_return_status := FND_API.g_ret_sts_error;
1218: RETURN;
1219: END IF;

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

1251: THEN
1252: l_date_from := p_complete_rec.date_effective_from;
1253: l_date_to := p_complete_rec.date_effective_to;
1254: IF l_date_from > l_date_to THEN
1255: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1256: FND_MESSAGE.set_name('AMS', 'AMS_MESG_INVALID_DATES');
1257: FND_MSG_PUB.add;
1258: END IF;
1259:

Line 1257: FND_MSG_PUB.add;

1253: l_date_to := p_complete_rec.date_effective_to;
1254: IF l_date_from > l_date_to THEN
1255: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1256: FND_MESSAGE.set_name('AMS', 'AMS_MESG_INVALID_DATES');
1257: FND_MSG_PUB.add;
1258: END IF;
1259:
1260: x_return_status := FND_API.g_ret_sts_error;
1261: RETURN;

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

1291: OPEN c_msg;
1292: FETCH c_msg INTO l_msg_rec;
1293: IF (c_msg%NOTFOUND) THEN
1294: CLOSE c_msg;
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_msg%NOTFOUND) THEN
1294: CLOSE c_msg;
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_msg;