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

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

13: -- 03-Dec-2002 ptendulk Added fix for bug 2615287, increased length of vendor
14: -- 13-FEB-2003 vmodur Fix for Bug 2791639
15:
16:
17: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
18: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
19: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
20:
21: PROCEDURE Check_Chan_Record(

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

14: -- 13-FEB-2003 vmodur Fix for Bug 2791639
15:
16:
17: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
18: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
19: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
20:
21: PROCEDURE Check_Chan_Record(
22: p_chan_rec IN chan_rec_type,

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

15:
16:
17: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
18: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
19: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
20:
21: PROCEDURE Check_Chan_Record(
22: p_chan_rec IN chan_rec_type,
23: p_complete_rec IN chan_rec_type,

Line 87: FND_MSG_PUB.initialize;

83:
84: END IF;
85:
86: IF FND_API.to_boolean(p_init_msg_list) THEN
87: FND_MSG_PUB.initialize;
88: END IF;
89:
90: IF NOT FND_API.compatible_api_call(
91: l_api_version,

Line 278: FND_MSG_PUB.count_and_get(

274: IF FND_API.to_boolean(p_commit) THEN
275: COMMIT;
276: END IF;
277:
278: FND_MSG_PUB.count_and_get(
279: p_encoded => FND_API.g_false,
280: p_count => x_msg_count,
281: p_data => x_msg_data
282: );

Line 297: FND_MSG_PUB.count_and_get(

293:
294: WHEN FND_API.g_exc_error THEN
295: ROLLBACK TO create_channel;
296: x_return_status := FND_API.g_ret_sts_error;
297: FND_MSG_PUB.count_and_get(
298: p_encoded => FND_API.g_false,
299: p_count => x_msg_count,
300: p_data => x_msg_data
301: );

Line 306: FND_MSG_PUB.count_and_get(

302:
303: WHEN FND_API.g_exc_unexpected_error THEN
304: ROLLBACK TO create_channel;
305: x_return_status := FND_API.g_ret_sts_unexp_error ;
306: FND_MSG_PUB.count_and_get(
307: p_encoded => FND_API.g_false,
308: p_count => x_msg_count,
309: p_data => x_msg_data
310: );

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

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

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

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

Line 322: FND_MSG_PUB.count_and_get(

318: THEN
319: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
320: END IF;
321:
322: FND_MSG_PUB.count_and_get(
323: p_encoded => FND_API.g_false,
324: p_count => x_msg_count,
325: p_data => x_msg_data
326: );

Line 386: FND_MSG_PUB.initialize;

382:
383: END IF;
384:
385: IF FND_API.to_boolean(p_init_msg_list) THEN
386: FND_MSG_PUB.initialize;
387: END IF;
388:
389: IF NOT FND_API.compatible_api_call(
390: l_api_version,

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

407: FETCH c_media_id INTO l_media_id;
408: CLOSE c_media_id;
409:
410: IF l_media_id IS NOT NULL THEN
411: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
412: THEN
413: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_CANNOT_DELETE');
414: FND_MSG_PUB.add;
415: END IF;

Line 414: FND_MSG_PUB.add;

410: IF l_media_id IS NOT NULL THEN
411: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
412: THEN
413: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_CANNOT_DELETE');
414: FND_MSG_PUB.add;
415: END IF;
416: RAISE FND_API.g_exc_error;
417: END IF;
418:

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

421: FETCH c_check_schedule_association INTO l_mktg_medium_id;
422: CLOSE c_check_schedule_association;
423:
424: IF l_mktg_medium_id IS NOT NULL THEN
425: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
426: THEN
427: FND_MESSAGE.set_name('AMS', 'AMS_MKTG_MEDIA_IS_USED_BY_CSCH');
428: FND_MSG_PUB.add;
429: END IF;

Line 428: FND_MSG_PUB.add;

424: IF l_mktg_medium_id IS NOT NULL THEN
425: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
426: THEN
427: FND_MESSAGE.set_name('AMS', 'AMS_MKTG_MEDIA_IS_USED_BY_CSCH');
428: FND_MSG_PUB.add;
429: END IF;
430: RAISE FND_API.g_exc_error;
431: END IF;
432: -- Bug fix:2089112. 10/31/01

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

440: WHERE channel_id = p_chan_id
441: AND object_version_number = p_object_version;
442:
443: IF (SQL%NOTFOUND) THEN
444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
445: THEN
446: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
447: FND_MSG_PUB.add;
448: END IF;

Line 447: FND_MSG_PUB.add;

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

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

452: DELETE FROM ams_channels_tl
453: WHERE channel_id = p_chan_id;
454:
455: IF (SQL%NOTFOUND) THEN
456: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
457: THEN
458: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
459: FND_MSG_PUB.add;
460: END IF;

Line 459: FND_MSG_PUB.add;

455: IF (SQL%NOTFOUND) THEN
456: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
457: THEN
458: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
459: FND_MSG_PUB.add;
460: END IF;
461: RAISE FND_API.g_exc_error;
462: END IF;
463:

Line 469: FND_MSG_PUB.count_and_get(

465: IF FND_API.to_boolean(p_commit) THEN
466: COMMIT;
467: END IF;
468:
469: FND_MSG_PUB.count_and_get(
470: p_encoded => FND_API.g_false,
471: p_count => x_msg_count,
472: p_data => x_msg_data
473: );

Line 488: FND_MSG_PUB.count_and_get(

484:
485: WHEN FND_API.g_exc_error THEN
486: ROLLBACK TO delete_channel;
487: x_return_status := FND_API.g_ret_sts_error;
488: FND_MSG_PUB.count_and_get(
489: p_encoded => FND_API.g_false,
490: p_count => x_msg_count,
491: p_data => x_msg_data
492: );

Line 497: FND_MSG_PUB.count_and_get(

493:
494: WHEN FND_API.g_exc_unexpected_error THEN
495: ROLLBACK TO delete_channel;
496: x_return_status := FND_API.g_ret_sts_unexp_error ;
497: FND_MSG_PUB.count_and_get(
498: p_encoded => FND_API.g_false,
499: p_count => x_msg_count,
500: p_data => x_msg_data
501: );

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

503: WHEN OTHERS THEN
504: ROLLBACK TO delete_channel;
505: x_return_status := FND_API.g_ret_sts_unexp_error ;
506:
507: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
508: THEN
509: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
510: END IF;
511:

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

505: x_return_status := FND_API.g_ret_sts_unexp_error ;
506:
507: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
508: THEN
509: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
510: END IF;
511:
512: FND_MSG_PUB.count_and_get(
513: p_encoded => FND_API.g_false,

Line 512: FND_MSG_PUB.count_and_get(

508: THEN
509: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
510: END IF;
511:
512: FND_MSG_PUB.count_and_get(
513: p_encoded => FND_API.g_false,
514: p_count => x_msg_count,
515: p_data => x_msg_data
516: );

Line 570: FND_MSG_PUB.initialize;

566: AMS_Utility_PVT.debug_message(l_full_name||': start');
567: END IF;
568:
569: IF FND_API.to_boolean(p_init_msg_list) THEN
570: FND_MSG_PUB.initialize;
571: END IF;
572:
573: IF NOT FND_API.compatible_api_call(
574: l_api_version,

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

590: OPEN c_chan_b;
591: FETCH c_chan_b INTO l_chan_id;
592: IF (c_chan_b%NOTFOUND) THEN
593: CLOSE c_chan_b;
594: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
595: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
596: FND_MSG_PUB.add;
597: END IF;
598: RAISE FND_API.g_exc_error;

Line 596: FND_MSG_PUB.add;

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

Line 606: FND_MSG_PUB.count_and_get(

602: OPEN c_chan_tl;
603: CLOSE c_chan_tl;
604:
605: -------------------- finish --------------------------
606: FND_MSG_PUB.count_and_get(
607: p_encoded => FND_API.g_false,
608: p_count => x_msg_count,
609: p_data => x_msg_data
610: );

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

620: EXCEPTION
621:
622: WHEN AMS_Utility_PVT.resource_locked THEN
623: x_return_status := FND_API.g_ret_sts_error;
624: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
625: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
626: FND_MSG_PUB.add;
627: END IF;
628:

Line 626: FND_MSG_PUB.add;

622: WHEN AMS_Utility_PVT.resource_locked THEN
623: x_return_status := FND_API.g_ret_sts_error;
624: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
625: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
626: FND_MSG_PUB.add;
627: END IF;
628:
629: FND_MSG_PUB.count_and_get(
630: p_encoded => FND_API.g_false,

Line 629: FND_MSG_PUB.count_and_get(

625: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
626: FND_MSG_PUB.add;
627: END IF;
628:
629: FND_MSG_PUB.count_and_get(
630: p_encoded => FND_API.g_false,
631: p_count => x_msg_count,
632: p_data => x_msg_data
633: );

Line 637: FND_MSG_PUB.count_and_get(

633: );
634:
635: WHEN FND_API.g_exc_error THEN
636: x_return_status := FND_API.g_ret_sts_error;
637: FND_MSG_PUB.count_and_get(
638: p_encoded => FND_API.g_false,
639: p_count => x_msg_count,
640: p_data => x_msg_data
641: );

Line 645: FND_MSG_PUB.count_and_get(

641: );
642:
643: WHEN FND_API.g_exc_unexpected_error THEN
644: x_return_status := FND_API.g_ret_sts_unexp_error ;
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 653: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

649: );
650:
651: WHEN OTHERS THEN
652: x_return_status := FND_API.g_ret_sts_unexp_error ;
653: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
654: THEN
655: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
656: END IF;
657:

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

651: WHEN OTHERS THEN
652: x_return_status := FND_API.g_ret_sts_unexp_error ;
653: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
654: THEN
655: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
656: END IF;
657:
658: FND_MSG_PUB.count_and_get(
659: p_encoded => FND_API.g_false,

Line 658: FND_MSG_PUB.count_and_get(

654: THEN
655: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
656: END IF;
657:
658: FND_MSG_PUB.count_and_get(
659: p_encoded => FND_API.g_false,
660: p_count => x_msg_count,
661: p_data => x_msg_data
662: );

Line 710: FND_MSG_PUB.initialize;

706:
707: END IF;
708:
709: IF FND_API.to_boolean(p_init_msg_list) THEN
710: FND_MSG_PUB.initialize;
711: END IF;
712:
713: IF NOT FND_API.compatible_api_call(
714: l_api_version,

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

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

Line 826: FND_MSG_PUB.add;

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

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

838: WHERE channel_id = l_chan_rec.channel_id
839: AND USERENV('LANG') IN (language, source_lang);
840:
841: IF (SQL%NOTFOUND) THEN
842: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
843: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
844: FND_MSG_PUB.add;
845: END IF;
846: RAISE FND_API.g_exc_error;

Line 844: FND_MSG_PUB.add;

840:
841: IF (SQL%NOTFOUND) THEN
842: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
843: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
844: FND_MSG_PUB.add;
845: END IF;
846: RAISE FND_API.g_exc_error;
847: END IF;
848:

Line 854: FND_MSG_PUB.count_and_get(

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

Line 873: FND_MSG_PUB.count_and_get(

869:
870: WHEN FND_API.g_exc_error THEN
871: ROLLBACK TO update_channel;
872: x_return_status := FND_API.g_ret_sts_error;
873: FND_MSG_PUB.count_and_get(
874: p_encoded => FND_API.g_false,
875: p_count => x_msg_count,
876: p_data => x_msg_data
877: );

Line 882: FND_MSG_PUB.count_and_get(

878:
879: WHEN FND_API.g_exc_unexpected_error THEN
880: ROLLBACK TO update_channel;
881: x_return_status := FND_API.g_ret_sts_unexp_error;
882: FND_MSG_PUB.count_and_get(
883: p_encoded => FND_API.g_false,
884: p_count => x_msg_count,
885: p_data => x_msg_data
886: );

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

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

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

890: x_return_status := FND_API.g_ret_sts_unexp_error;
891:
892: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
893: THEN
894: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
895: END IF;
896:
897: FND_MSG_PUB.count_and_get(
898: p_encoded => FND_API.g_false,

Line 897: FND_MSG_PUB.count_and_get(

893: THEN
894: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
895: END IF;
896:
897: FND_MSG_PUB.count_and_get(
898: p_encoded => FND_API.g_false,
899: p_count => x_msg_count,
900: p_data => x_msg_data
901: );

Line 943: FND_MSG_PUB.initialize;

939: AMS_Utility_PVT.debug_message(l_full_name||': start');
940: END IF;
941:
942: IF FND_API.to_boolean(p_init_msg_list) THEN
943: FND_MSG_PUB.initialize;
944: END IF;
945:
946: IF NOT FND_API.compatible_api_call(
947: l_api_version,

Line 998: FND_MSG_PUB.count_and_get(

994: END IF;
995: END IF;
996:
997: -------------------- finish --------------------------
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 1016: FND_MSG_PUB.count_and_get(

1012: EXCEPTION
1013:
1014: WHEN FND_API.g_exc_error THEN
1015: x_return_status := FND_API.g_ret_sts_error;
1016: FND_MSG_PUB.count_and_get(
1017: p_encoded => FND_API.g_false,
1018: p_count => x_msg_count,
1019: p_data => x_msg_data
1020: );

Line 1024: FND_MSG_PUB.count_and_get(

1020: );
1021:
1022: WHEN FND_API.g_exc_unexpected_error THEN
1023: x_return_status := FND_API.g_ret_sts_unexp_error ;
1024: FND_MSG_PUB.count_and_get(
1025: p_encoded => FND_API.g_false,
1026: p_count => x_msg_count,
1027: p_data => x_msg_data
1028: );

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

1028: );
1029:
1030: WHEN OTHERS THEN
1031: x_return_status := FND_API.g_ret_sts_unexp_error;
1032: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1033: THEN
1034: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1035: END IF;
1036:

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

1030: WHEN OTHERS THEN
1031: x_return_status := FND_API.g_ret_sts_unexp_error;
1032: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1033: THEN
1034: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1035: END IF;
1036:
1037: FND_MSG_PUB.count_and_get(
1038: p_encoded => FND_API.g_false,

Line 1037: FND_MSG_PUB.count_and_get(

1033: THEN
1034: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1035: END IF;
1036:
1037: FND_MSG_PUB.count_and_get(
1038: p_encoded => FND_API.g_false,
1039: p_count => x_msg_count,
1040: p_data => x_msg_data
1041: );

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

1062:
1063: x_return_status := FND_API.g_ret_sts_success;
1064: ------------------------ channel_type --------------------------
1065: IF p_chan_rec.channel_type_code IS NULL THEN
1066: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1067: THEN
1068: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_INVALID_TYPE_CODE');
1069: FND_MSG_PUB.add;
1070: END IF;

Line 1069: FND_MSG_PUB.add;

1065: IF p_chan_rec.channel_type_code IS NULL THEN
1066: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1067: THEN
1068: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_INVALID_TYPE_CODE');
1069: FND_MSG_PUB.add;
1070: END IF;
1071: x_return_status := FND_API.g_ret_sts_error;
1072: RETURN;
1073: END IF;

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

1073: END IF;
1074:
1075: ------------------------ channel_name --------------------------
1076: IF p_chan_rec.channel_name IS NULL THEN
1077: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1078: THEN
1079: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_NO_NAME');
1080: FND_MSG_PUB.add;
1081: END IF;

Line 1080: FND_MSG_PUB.add;

1076: IF p_chan_rec.channel_name IS NULL THEN
1077: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1078: THEN
1079: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_NO_NAME');
1080: FND_MSG_PUB.add;
1081: END IF;
1082: x_return_status := FND_API.g_ret_sts_error;
1083: RETURN;
1084: END IF;

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

1085:
1086: -- Added by rrajesh on 12/07/00
1087: ------------------------ country_id --------------------------
1088: IF p_chan_rec.country_id IS NULL THEN
1089: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1090: THEN
1091: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_INVALID_COUNTRY_ID');
1092: FND_MSG_PUB.add;
1093: END IF;

Line 1092: FND_MSG_PUB.add;

1088: IF p_chan_rec.country_id IS NULL THEN
1089: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1090: THEN
1091: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_INVALID_COUNTRY_ID');
1092: FND_MSG_PUB.add;
1093: END IF;
1094: x_return_status := FND_API.g_ret_sts_error;
1095: RETURN;
1096: END IF;

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

1098:
1099: -- Added by vmodur on 02/13/2003
1100: ------------------------ Active From Date ---------------------
1101: IF p_chan_rec.active_from_date IS NULL THEN
1102: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1103: THEN
1104: FND_MESSAGE.set_name('AMS', 'AMS_MED_CFD_IS_NULL');
1105: FND_MSG_PUB.add;
1106: END IF;

Line 1105: FND_MSG_PUB.add;

1101: IF p_chan_rec.active_from_date IS NULL THEN
1102: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1103: THEN
1104: FND_MESSAGE.set_name('AMS', 'AMS_MED_CFD_IS_NULL');
1105: FND_MSG_PUB.add;
1106: END IF;
1107: x_return_status := FND_API.g_ret_sts_error;
1108: RETURN;
1109: END IF;

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

1167: 'ams_channels_vl',
1168: 'channel_id = ' || p_chan_rec.channel_id
1169: ) = FND_API.g_false
1170: THEN
1171: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1172: THEN
1173: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_DUPLICATE_ID');
1174: FND_MSG_PUB.add;
1175: END IF;

Line 1174: FND_MSG_PUB.add;

1170: THEN
1171: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1172: THEN
1173: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_DUPLICATE_ID');
1174: FND_MSG_PUB.add;
1175: END IF;
1176: x_return_status := FND_API.g_ret_sts_error;
1177: RETURN;
1178: END IF;

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

1216: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message('Check the uniqueness Count '|| l_count ); END IF;
1217: IF l_count > 0 THEN
1218: --IF l_valid_flag = FND_API.g_false THEN
1219: -- rrajesh end 11/08
1220: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1221: THEN
1222: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_DUPLICATE_NAME');
1223: FND_MSG_PUB.add;
1224: END IF;

Line 1223: FND_MSG_PUB.add;

1219: -- rrajesh end 11/08
1220: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1221: THEN
1222: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_DUPLICATE_NAME');
1223: FND_MSG_PUB.add;
1224: END IF;
1225: x_return_status := FND_API.g_ret_sts_error;
1226: RETURN;
1227: END IF;

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

1254: 'resource_id',
1255: p_chan_rec.managed_by_person_id
1256: ) = FND_API.g_false
1257: THEN
1258: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1259: THEN
1260: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_BAD_MANAGED_BY_ID');
1261: FND_MSG_PUB.add;
1262: END IF;

Line 1261: FND_MSG_PUB.add;

1257: THEN
1258: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1259: THEN
1260: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_BAD_MANAGED_BY_ID');
1261: FND_MSG_PUB.add;
1262: END IF;
1263: x_return_status := FND_API.g_ret_sts_error;
1264: RETURN;
1265: END IF;

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

1272: 'vendor_id',
1273: p_chan_rec.preferred_vendor_id
1274: ) = FND_API.g_false
1275: THEN
1276: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1277: THEN
1278: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_VENDOR_ID');
1279: FND_MSG_PUB.add;
1280: END IF;

Line 1279: FND_MSG_PUB.add;

1275: THEN
1276: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1277: THEN
1278: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_VENDOR_ID');
1279: FND_MSG_PUB.add;
1280: END IF;
1281: x_return_status := FND_API.g_ret_sts_error;
1282: RETURN;
1283: END IF;

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

1289: 'party_id',
1290: p_chan_rec.party_id
1291: ) = FND_API.g_false
1292: THEN
1293: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1294: THEN
1295: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_PARTY_ID');
1296: FND_MSG_PUB.add;
1297: END IF;

Line 1296: FND_MSG_PUB.add;

1292: THEN
1293: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1294: THEN
1295: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_PARTY_ID');
1296: FND_MSG_PUB.add;
1297: END IF;
1298: x_return_status := FND_API.g_ret_sts_error;
1299: RETURN;
1300: END IF;

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

1313: -- modified by soagrawa on 28-sep-2001, bug# 2021940
1314: p_additional_where_clause => ' location_type_code = ''COUNTRY'' ' --' location_type_name = ''Country'' '
1315: ) = FND_API.g_false
1316: THEN
1317: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1318: THEN
1319: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_COUNTRY_ID');
1320: FND_MSG_PUB.add;
1321: END IF;

Line 1320: FND_MSG_PUB.add;

1316: THEN
1317: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1318: THEN
1319: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_COUNTRY_ID');
1320: FND_MSG_PUB.add;
1321: END IF;
1322: x_return_status := FND_API.g_ret_sts_error;
1323: RETURN;
1324: END IF;

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

1351: p_lookup_type => 'AMS_CHANNEL_TYPE',
1352: p_lookup_code => p_chan_rec.channel_type_code
1353: ) = FND_API.g_false
1354: THEN
1355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1356: THEN
1357: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_WRONG_CHANNEL_TYPE');
1358: FND_MSG_PUB.add;
1359: END IF;

Line 1358: FND_MSG_PUB.add;

1354: THEN
1355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1356: THEN
1357: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_WRONG_CHANNEL_TYPE');
1358: FND_MSG_PUB.add;
1359: END IF;
1360: x_return_status := FND_API.g_ret_sts_error;
1361: RETURN;
1362: END IF;

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

1370: p_lookup_type => 'AMS_CHANNEL_RATING',
1371: p_lookup_code => p_chan_rec.rating
1372: ) = FND_API.g_false
1373: THEN
1374: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1375: THEN
1376: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_RATING_VALUE');
1377: FND_MSG_PUB.add;
1378: END IF;

Line 1377: FND_MSG_PUB.add;

1373: THEN
1374: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1375: THEN
1376: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_RATING_VALUE');
1377: FND_MSG_PUB.add;
1378: END IF;
1379: x_return_status := FND_API.g_ret_sts_error;
1380: RETURN;
1381: END IF;

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

1408: AND p_chan_rec.outbound_flag IS NOT NULL
1409: THEN
1410: IF AMS_Utility_PVT.is_Y_or_N(p_chan_rec.outbound_flag) = FND_API.g_false
1411: THEN
1412: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1413: THEN
1414: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_OUTBOUND_FLAG');
1415: FND_MSG_PUB.add;
1416: END IF;

Line 1415: FND_MSG_PUB.add;

1411: THEN
1412: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1413: THEN
1414: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_OUTBOUND_FLAG');
1415: FND_MSG_PUB.add;
1416: END IF;
1417: x_return_status := FND_API.g_ret_sts_error;
1418: RETURN;
1419: END IF;

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

1424: AND p_chan_rec.inbound_flag IS NOT NULL
1425: THEN
1426: IF AMS_Utility_PVT.is_Y_or_N(p_chan_rec.inbound_flag) = FND_API.g_false
1427: THEN
1428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1429: THEN
1430: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_INBOUND_FLAG');
1431: FND_MSG_PUB.add;
1432: END IF;

Line 1431: FND_MSG_PUB.add;

1427: THEN
1428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1429: THEN
1430: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_INBOUND_FLAG');
1431: FND_MSG_PUB.add;
1432: END IF;
1433: x_return_status := FND_API.g_ret_sts_error;
1434: RETURN;
1435: END IF;

Line 1564: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1560: IF l_end_date IS NOT NULL
1561: AND l_start_date IS NOT NULL THEN
1562: IF l_start_date > l_end_date THEN
1563: -- invalid item
1564: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1565: THEN -- MMSG
1566: -- DBMS_OUTPUT.Put_Line('Start Date time or End Date Time is invalid');
1567: FND_MESSAGE.Set_Name('AMS', 'AMS_MED_FROMDT_GTR_TODT');
1568: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_DT_RANGE');

Line 1569: FND_MSG_PUB.Add;

1565: THEN -- MMSG
1566: -- DBMS_OUTPUT.Put_Line('Start Date time or End Date Time is invalid');
1567: FND_MESSAGE.Set_Name('AMS', 'AMS_MED_FROMDT_GTR_TODT');
1568: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_DT_RANGE');
1569: FND_MSG_PUB.Add;
1570: END IF;
1571: x_return_status := FND_API.G_RET_STS_ERROR;
1572: -- If any errors happen abort API/Procedure.
1573: RETURN;

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

1668: OPEN c_chan;
1669: FETCH c_chan INTO l_chan_rec;
1670: IF c_chan%NOTFOUND THEN
1671: CLOSE c_chan;
1672: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1673: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1674: FND_MSG_PUB.add;
1675: END IF;
1676: RAISE FND_API.g_exc_error;

Line 1674: FND_MSG_PUB.add;

1670: IF c_chan%NOTFOUND THEN
1671: CLOSE c_chan;
1672: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1673: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1674: FND_MSG_PUB.add;
1675: END IF;
1676: RAISE FND_API.g_exc_error;
1677: END IF;
1678: CLOSE c_chan;