APPS.AMS_MEDIA_PVT dependencies on FND_MSG_PUB

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

48: -- Global CONSTANTS
49: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_Media_PVT';
50:
51: -- Check_Media_Req_Items
52: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
53: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
54: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
55:
56: PROCEDURE Check_Media_Req_Items (

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

49: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_Media_PVT';
50:
51: -- Check_Media_Req_Items
52: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
53: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
54: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
55:
56: PROCEDURE Check_Media_Req_Items (
57: p_media_rec IN Media_Rec_Type,

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

50:
51: -- Check_Media_Req_Items
52: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
53: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
54: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
55:
56: PROCEDURE Check_Media_Req_Items (
57: p_media_rec IN Media_Rec_Type,
58: x_return_status OUT NOCOPY VARCHAR2

Line 211: FND_MSG_PUB.initialize;

207:
208: END IF;
209:
210: IF FND_API.to_boolean (p_init_msg_list) THEN
211: FND_MSG_PUB.initialize;
212: END IF;
213:
214: IF NOT FND_API.compatible_api_call (
215: L_API_VERSION,

Line 238: -- IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

234: -- can be created with media_type_code = 'DIRECT_MARKETING'
235: -- End of Comments by ptendulk
236:
237: -- IF p_media_rec.media_type_code = 'DIRECT_MARKETING' THEN
238: -- IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
239: -- FND_MESSAGE.set_name ('AMS', 'AMS_MED_CANT_CREATE_DM_MEDIA');
240: -- FND_MSG_PUB.add;
241: -- END IF;
242: -- RAISE FND_API.g_exc_error;

Line 240: -- FND_MSG_PUB.add;

236:
237: -- IF p_media_rec.media_type_code = 'DIRECT_MARKETING' THEN
238: -- IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
239: -- FND_MESSAGE.set_name ('AMS', 'AMS_MED_CANT_CREATE_DM_MEDIA');
240: -- FND_MSG_PUB.add;
241: -- END IF;
242: -- RAISE FND_API.g_exc_error;
243: -- END IF;
244:

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

243: -- END IF;
244:
245:
246: IF p_media_rec.media_type_code = 'EVENTS' THEN
247: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
248: FND_MESSAGE.set_name ('AMS', 'AMS_MED_CANT_CREATE_EVE_MEDIA');
249: FND_MSG_PUB.add;
250: END IF;
251: RAISE FND_API.g_exc_error;

Line 249: FND_MSG_PUB.add;

245:
246: IF p_media_rec.media_type_code = 'EVENTS' THEN
247: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
248: FND_MESSAGE.set_name ('AMS', 'AMS_MED_CANT_CREATE_EVE_MEDIA');
249: FND_MSG_PUB.add;
250: END IF;
251: RAISE FND_API.g_exc_error;
252: END IF;
253:

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

251: RAISE FND_API.g_exc_error;
252: END IF;
253:
254: IF p_media_rec.media_type_code = 'INTERNET' THEN
255: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
256: FND_MESSAGE.set_name ('AMS', 'AMS_MED_CANT_CR_INTERNET_MEDIA');
257: FND_MSG_PUB.add;
258: END IF;
259: RAISE FND_API.g_exc_error;

Line 257: FND_MSG_PUB.add;

253:
254: IF p_media_rec.media_type_code = 'INTERNET' THEN
255: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
256: FND_MESSAGE.set_name ('AMS', 'AMS_MED_CANT_CR_INTERNET_MEDIA');
257: FND_MSG_PUB.add;
258: END IF;
259: RAISE FND_API.g_exc_error;
260: END IF;
261:

Line 421: FND_MSG_PUB.count_and_get(

417: IF FND_API.To_Boolean ( p_commit ) THEN
418: COMMIT WORK;
419: END IF;
420:
421: FND_MSG_PUB.count_and_get(
422: p_encoded => FND_API.g_false,
423: p_count => x_msg_count,
424: p_data => x_msg_data
425: );

Line 439: FND_MSG_PUB.count_and_get(

435: EXCEPTION
436: WHEN FND_API.g_exc_error THEN
437: ROLLBACK TO Create_Media;
438: x_return_status := FND_API.g_ret_sts_error;
439: FND_MSG_PUB.count_and_get(
440: p_encoded => FND_API.g_false,
441: p_count => x_msg_count,
442: p_data => x_msg_data
443: );

Line 447: FND_MSG_PUB.count_and_get (

443: );
444: WHEN FND_API.g_exc_unexpected_error THEN
445: ROLLBACK TO Create_Media;
446: x_return_status := FND_API.g_ret_sts_unexp_error ;
447: FND_MSG_PUB.count_and_get (
448: p_encoded => FND_API.g_false,
449: p_count => x_msg_count,
450: p_data => x_msg_data
451: );

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

452: WHEN OTHERS THEN
453: ROLLBACK TO Create_Media;
454: x_return_status := FND_API.g_ret_sts_unexp_error ;
455:
456: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
457: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
458: END IF;
459:
460: FND_MSG_PUB.count_and_get (

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

453: ROLLBACK TO Create_Media;
454: x_return_status := FND_API.g_ret_sts_unexp_error ;
455:
456: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
457: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
458: END IF;
459:
460: FND_MSG_PUB.count_and_get (
461: p_encoded => FND_API.g_false,

Line 460: FND_MSG_PUB.count_and_get (

456: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
457: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
458: END IF;
459:
460: FND_MSG_PUB.count_and_get (
461: p_encoded => FND_API.g_false,
462: p_count => x_msg_count,
463: p_data => x_msg_data
464: );

Line 507: FND_MSG_PUB.initialize;

503:
504: END IF;
505:
506: IF FND_API.to_boolean (p_init_msg_list) THEN
507: FND_MSG_PUB.initialize;
508: END IF;
509:
510: IF NOT FND_API.compatible_api_call(
511: l_api_version,

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

529: --
530: -- Seed Data can be disabled
531: /***
532: IF IsSeeded (p_media_rec.media_id) THEN
533: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
534: THEN
535: FND_MESSAGE.set_name('AMS', 'AMS_API_SEED_DATA');
536: FND_MSG_PUB.add;
537: END IF;

Line 536: FND_MSG_PUB.add;

532: IF IsSeeded (p_media_rec.media_id) THEN
533: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
534: THEN
535: FND_MESSAGE.set_name('AMS', 'AMS_API_SEED_DATA');
536: FND_MSG_PUB.add;
537: END IF;
538:
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;

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

609: WHERE media_id = l_media_rec.media_id
610: AND object_version_number = l_media_rec.object_version_number ;
611:
612: IF (SQL%NOTFOUND) THEN
613: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
614: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
615: FND_MSG_PUB.add;
616: END IF;
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 615: FND_MSG_PUB.add;

611:
612: IF (SQL%NOTFOUND) THEN
613: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
614: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
615: FND_MSG_PUB.add;
616: END IF;
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
619:

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

629: WHERE media_id = l_media_rec.media_id
630: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
631:
632: IF (SQL%NOTFOUND) THEN
633: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
634: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
635: FND_MSG_PUB.add;
636: END IF;
637: RAISE FND_API.g_exc_error;

Line 635: FND_MSG_PUB.add;

631:
632: IF (SQL%NOTFOUND) THEN
633: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
634: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
635: FND_MSG_PUB.add;
636: END IF;
637: RAISE FND_API.g_exc_error;
638: END IF;
639:

Line 645: FND_MSG_PUB.count_and_get (

641: IF FND_API.to_boolean (p_commit) THEN
642: COMMIT;
643: END IF;
644:
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 663: FND_MSG_PUB.count_and_get (

659: EXCEPTION
660: WHEN FND_API.g_exc_error THEN
661: ROLLBACK TO Update_Media;
662: x_return_status := FND_API.g_ret_sts_error;
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 671: FND_MSG_PUB.count_and_get (

667: );
668: WHEN FND_API.g_exc_unexpected_error THEN
669: ROLLBACK TO Update_Media;
670: x_return_status := FND_API.g_ret_sts_unexp_error ;
671: FND_MSG_PUB.count_and_get (
672: p_encoded => FND_API.g_false,
673: p_count => x_msg_count,
674: p_data => x_msg_data
675: );

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

676: WHEN OTHERS THEN
677: ROLLBACK TO Update_Media;
678: x_return_status := FND_API.g_ret_sts_unexp_error ;
679:
680: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
681: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
682: END IF;
683:
684: FND_MSG_PUB.count_and_get (

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

677: ROLLBACK TO Update_Media;
678: x_return_status := FND_API.g_ret_sts_unexp_error ;
679:
680: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
681: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
682: END IF;
683:
684: FND_MSG_PUB.count_and_get (
685: p_encoded => FND_API.g_false,

Line 684: FND_MSG_PUB.count_and_get (

680: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
681: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
682: END IF;
683:
684: FND_MSG_PUB.count_and_get (
685: p_encoded => FND_API.g_false,
686: p_count => x_msg_count,
687: p_data => x_msg_data
688: );

Line 753: FND_MSG_PUB.initialize;

749:
750: END IF;
751:
752: IF FND_API.to_boolean (p_init_msg_list) THEN
753: FND_MSG_PUB.initialize;
754: END IF;
755:
756: IF NOT FND_API.compatible_api_call (
757: l_api_version,

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

772:
773: --
774: -- Check if record is seeded.
775: IF IsSeeded (p_media_id) THEN
776: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
777: THEN
778: FND_MESSAGE.set_name('AMS', 'AMS_API_SEED_DATA');
779: FND_MSG_PUB.add;
780: END IF;

Line 779: FND_MSG_PUB.add;

775: IF IsSeeded (p_media_id) THEN
776: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
777: THEN
778: FND_MESSAGE.set_name('AMS', 'AMS_API_SEED_DATA');
779: FND_MSG_PUB.add;
780: END IF;
781:
782: RAISE FND_API.G_EXC_ERROR;
783: END IF;

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

793: CLOSE c_check_campaign;
794: CLOSE c_check_customsetup;
795:
796: IF ( l_is_campaign = 'Y' ) OR ( l_is_setup = 'Y') THEN
797: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
798: THEN
799: FND_MESSAGE.set_name('AMS', 'AMS_MEDIA_IS_USED');
800: FND_MSG_PUB.add;
801: END IF;

Line 800: FND_MSG_PUB.add;

796: IF ( l_is_campaign = 'Y' ) OR ( l_is_setup = 'Y') THEN
797: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
798: THEN
799: FND_MESSAGE.set_name('AMS', 'AMS_MEDIA_IS_USED');
800: FND_MSG_PUB.add;
801: END IF;
802:
803: RAISE FND_API.G_EXC_ERROR;
804:

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

811: WHERE media_id = p_media_id ;
812:
813:
814: IF (SQL%NOTFOUND) THEN
815: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
816: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
817: FND_MSG_PUB.add;
818: END IF;
819: RAISE FND_API.g_exc_error;

Line 817: FND_MSG_PUB.add;

813:
814: IF (SQL%NOTFOUND) THEN
815: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
816: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
817: FND_MSG_PUB.add;
818: END IF;
819: RAISE FND_API.g_exc_error;
820: END IF;
821:

Line 831: FND_MSG_PUB.count_and_get (

827: IF FND_API.to_boolean (p_commit) THEN
828: COMMIT;
829: END IF;
830:
831: FND_MSG_PUB.count_and_get (
832: p_encoded => FND_API.g_false,
833: p_count => x_msg_count,
834: p_data => x_msg_data
835: );

Line 849: FND_MSG_PUB.count_and_get (

845: EXCEPTION
846: WHEN FND_API.g_exc_error THEN
847: ROLLBACK TO Delete_Media;
848: x_return_status := FND_API.g_ret_sts_error;
849: FND_MSG_PUB.count_and_get (
850: p_encoded => FND_API.g_false,
851: p_count => x_msg_count,
852: p_data => x_msg_data
853: );

Line 857: FND_MSG_PUB.count_and_get (

853: );
854: WHEN FND_API.g_exc_unexpected_error THEN
855: ROLLBACK TO Delete_Media;
856: x_return_status := FND_API.g_ret_sts_unexp_error ;
857: FND_MSG_PUB.count_and_get (
858: p_encoded => FND_API.g_false,
859: p_count => x_msg_count,
860: p_data => x_msg_data
861: );

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

862: WHEN OTHERS THEN
863: ROLLBACK TO Delete_Media;
864: x_return_status := FND_API.g_ret_sts_unexp_error ;
865:
866: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
867: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
868: END IF;
869:
870: FND_MSG_PUB.count_and_get (

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

863: ROLLBACK TO Delete_Media;
864: x_return_status := FND_API.g_ret_sts_unexp_error ;
865:
866: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
867: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
868: END IF;
869:
870: FND_MSG_PUB.count_and_get (
871: p_encoded => FND_API.g_false,

Line 870: FND_MSG_PUB.count_and_get (

866: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
867: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
868: END IF;
869:
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 924: FND_MSG_PUB.initialize;

920: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
921: END IF;
922:
923: IF FND_API.to_boolean (p_init_msg_list) THEN
924: FND_MSG_PUB.initialize;
925: END IF;
926:
927: IF NOT FND_API.compatible_api_call (
928: l_api_version,

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

944: OPEN c_lock;
945: FETCH c_lock INTO l_dummy;
946: IF (c_lock%NOTFOUND) THEN
947: CLOSE c_lock;
948: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
949: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
950: FND_MSG_PUB.add;
951: END IF;
952: RAISE FND_API.g_exc_error;

Line 950: FND_MSG_PUB.add;

946: IF (c_lock%NOTFOUND) THEN
947: CLOSE c_lock;
948: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
949: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
950: FND_MSG_PUB.add;
951: END IF;
952: RAISE FND_API.g_exc_error;
953: END IF;
954: CLOSE c_lock;

Line 957: FND_MSG_PUB.count_and_get (

953: END IF;
954: CLOSE c_lock;
955:
956: -------------------- finish --------------------------
957: FND_MSG_PUB.count_and_get (
958: p_encoded => FND_API.g_false,
959: p_count => x_msg_count,
960: p_data => x_msg_data
961: );

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

970:
971: EXCEPTION
972: WHEN AMS_Utility_PVT.resource_locked THEN
973: x_return_status := FND_API.g_ret_sts_error;
974: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
975: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
976: FND_MSG_PUB.add;
977: END IF;
978:

Line 976: FND_MSG_PUB.add;

972: WHEN AMS_Utility_PVT.resource_locked THEN
973: x_return_status := FND_API.g_ret_sts_error;
974: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
975: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
976: FND_MSG_PUB.add;
977: END IF;
978:
979: FND_MSG_PUB.count_and_get (
980: p_encoded => FND_API.g_false,

Line 979: FND_MSG_PUB.count_and_get (

975: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
976: FND_MSG_PUB.add;
977: END IF;
978:
979: FND_MSG_PUB.count_and_get (
980: p_encoded => FND_API.g_false,
981: p_count => x_msg_count,
982: p_data => x_msg_data
983: );

Line 986: FND_MSG_PUB.count_and_get (

982: p_data => x_msg_data
983: );
984: WHEN FND_API.g_exc_error THEN
985: x_return_status := FND_API.g_ret_sts_error;
986: FND_MSG_PUB.count_and_get (
987: p_encoded => FND_API.g_false,
988: p_count => x_msg_count,
989: p_data => x_msg_data
990: );

Line 993: FND_MSG_PUB.count_and_get (

989: p_data => x_msg_data
990: );
991: WHEN FND_API.g_exc_unexpected_error THEN
992: x_return_status := FND_API.g_ret_sts_unexp_error ;
993: FND_MSG_PUB.count_and_get (
994: p_encoded => FND_API.g_false,
995: p_count => x_msg_count,
996: p_data => x_msg_data
997: );

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

996: p_data => x_msg_data
997: );
998: WHEN OTHERS THEN
999: x_return_status := FND_API.g_ret_sts_unexp_error ;
1000: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1001: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1002: END IF;
1003:
1004: FND_MSG_PUB.count_and_get (

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

997: );
998: WHEN OTHERS THEN
999: x_return_status := FND_API.g_ret_sts_unexp_error ;
1000: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1001: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1002: END IF;
1003:
1004: FND_MSG_PUB.count_and_get (
1005: p_encoded => FND_API.g_false,

Line 1004: FND_MSG_PUB.count_and_get (

1000: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1001: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1002: END IF;
1003:
1004: FND_MSG_PUB.count_and_get (
1005: p_encoded => FND_API.g_false,
1006: p_count => x_msg_count,
1007: p_data => x_msg_data
1008: );

Line 1043: FND_MSG_PUB.initialize;

1039: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
1040: END IF;
1041:
1042: IF FND_API.to_boolean (p_init_msg_list) THEN
1043: FND_MSG_PUB.initialize;
1044: END IF;
1045:
1046: IF NOT FND_API.compatible_api_call (
1047: l_api_version,

Line 1100: FND_MSG_PUB.count_and_get (

1096: END IF;
1097: END IF;
1098:
1099: -------------------- finish --------------------------
1100: FND_MSG_PUB.count_and_get (
1101: p_encoded => FND_API.g_false,
1102: p_count => x_msg_count,
1103: p_data => x_msg_data
1104: );

Line 1117: FND_MSG_PUB.count_and_get (

1113:
1114: EXCEPTION
1115: WHEN FND_API.g_exc_error THEN
1116: x_return_status := FND_API.g_ret_sts_error;
1117: FND_MSG_PUB.count_and_get (
1118: p_encoded => FND_API.g_false,
1119: p_count => x_msg_count,
1120: p_data => x_msg_data
1121: );

Line 1124: FND_MSG_PUB.count_and_get (

1120: p_data => x_msg_data
1121: );
1122: WHEN FND_API.g_exc_unexpected_error THEN
1123: x_return_status := FND_API.g_ret_sts_unexp_error ;
1124: FND_MSG_PUB.count_and_get (
1125: p_encoded => FND_API.g_false,
1126: p_count => x_msg_count,
1127: p_data => x_msg_data
1128: );

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

1127: p_data => x_msg_data
1128: );
1129: WHEN OTHERS THEN
1130: x_return_status := FND_API.g_ret_sts_unexp_error;
1131: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1132: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1133: END IF;
1134:
1135: FND_MSG_PUB.count_and_get (

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

1128: );
1129: WHEN OTHERS THEN
1130: x_return_status := FND_API.g_ret_sts_unexp_error;
1131: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1132: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1133: END IF;
1134:
1135: FND_MSG_PUB.count_and_get (
1136: p_encoded => FND_API.g_false,

Line 1135: FND_MSG_PUB.count_and_get (

1131: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1132: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1133: END IF;
1134:
1135: FND_MSG_PUB.count_and_get (
1136: p_encoded => FND_API.g_false,
1137: p_count => x_msg_count,
1138: p_data => x_msg_data
1139: );

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

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

Line 1302: FND_MSG_PUB.add;

1298: IF c_media%NOTFOUND THEN
1299: CLOSE c_media;
1300: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1301: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1302: FND_MSG_PUB.add;
1303: END IF;
1304: RAISE FND_API.g_exc_error;
1305: END IF;
1306: CLOSE c_media;

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

1441: IS
1442: BEGIN
1443: -- MEDIA_TYPE_CODE
1444: IF p_media_rec.media_type_code IS NULL THEN
1445: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1446: FND_MESSAGE.set_name ('AMS', 'AMS_MED_NO_MEDIA_TYPE_CODE');
1447: FND_MSG_PUB.add;
1448: END IF;
1449:

Line 1447: FND_MSG_PUB.add;

1443: -- MEDIA_TYPE_CODE
1444: IF p_media_rec.media_type_code IS NULL THEN
1445: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1446: FND_MESSAGE.set_name ('AMS', 'AMS_MED_NO_MEDIA_TYPE_CODE');
1447: FND_MSG_PUB.add;
1448: END IF;
1449:
1450: x_return_status := FND_API.g_ret_sts_error;
1451: RETURN;

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

1452: END IF;
1453:
1454: -- MEDIA_NAME
1455: IF p_media_rec.media_name IS NULL THEN
1456: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1457: FND_MESSAGE.set_name ('AMS', 'AMS_MED_NO_MEDIA_NAME');
1458: FND_MSG_PUB.add;
1459: END IF;
1460:

Line 1458: FND_MSG_PUB.add;

1454: -- MEDIA_NAME
1455: IF p_media_rec.media_name IS NULL THEN
1456: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1457: FND_MESSAGE.set_name ('AMS', 'AMS_MED_NO_MEDIA_NAME');
1458: FND_MSG_PUB.add;
1459: END IF;
1460:
1461: x_return_status := FND_API.g_ret_sts_error;
1462: RETURN;

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

1501: 'ams_media_b',
1502: 'media_id = ' || p_media_rec.media_id
1503: ) = FND_API.g_false
1504: THEN
1505: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1506: FND_MESSAGE.set_name ('AMS', 'AMS_MED_DUP_MEDIA_ID');
1507: FND_MSG_PUB.add;
1508: END IF;
1509: x_return_status := FND_API.g_ret_sts_error;

Line 1507: FND_MSG_PUB.add;

1503: ) = FND_API.g_false
1504: THEN
1505: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1506: FND_MESSAGE.set_name ('AMS', 'AMS_MED_DUP_MEDIA_ID');
1507: FND_MSG_PUB.add;
1508: END IF;
1509: x_return_status := FND_API.g_ret_sts_error;
1510: RETURN;
1511: END IF;

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

1540: -- rrajesh start 11/07. Checking the uniqueness against the new cursor,
1541: -- c_name_unique_up
1542: IF l_count > 0 THEN
1543: -- rrajesh end 11/07
1544: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1545: FND_MESSAGE.set_name ('AMS', 'AMS_MED_DUP_NAME');
1546: FND_MSG_PUB.add;
1547: END IF;
1548: x_return_status := FND_API.g_ret_sts_error;

Line 1546: FND_MSG_PUB.add;

1542: IF l_count > 0 THEN
1543: -- rrajesh end 11/07
1544: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1545: FND_MESSAGE.set_name ('AMS', 'AMS_MED_DUP_NAME');
1546: FND_MSG_PUB.add;
1547: END IF;
1548: x_return_status := FND_API.g_ret_sts_error;
1549: RETURN;
1550: END IF;

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

1582: p_lookup_type => L_MEDIA_TYPE_CODE,
1583: p_lookup_code => p_media_rec.media_type_code
1584: ) = FND_API.g_false
1585: THEN
1586: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1587: FND_MESSAGE.set_name ('AMS', 'AMS_MED_BAD_MEDIA_TYPE_CODE');
1588: FND_MSG_PUB.add;
1589: END IF;
1590:

Line 1588: FND_MSG_PUB.add;

1584: ) = FND_API.g_false
1585: THEN
1586: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1587: FND_MESSAGE.set_name ('AMS', 'AMS_MED_BAD_MEDIA_TYPE_CODE');
1588: FND_MSG_PUB.add;
1589: END IF;
1590:
1591: x_return_status := FND_API.g_ret_sts_error;
1592: RETURN;

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

1609:
1610: -- INBOUND_FLAG
1611: IF p_media_rec.inbound_flag <> FND_API.g_miss_char AND p_media_rec.inbound_flag IS NOT NULL THEN
1612: IF AMS_Utility_PVT.is_Y_or_N (p_media_rec.inbound_flag) = FND_API.g_false THEN
1613: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1614: FND_MESSAGE.set_name ('AMS', 'AMS_MED_BAD_INBOUND_FLAG');
1615: FND_MSG_PUB.add;
1616: END IF;
1617:

Line 1615: FND_MSG_PUB.add;

1611: IF p_media_rec.inbound_flag <> FND_API.g_miss_char AND p_media_rec.inbound_flag IS NOT NULL THEN
1612: IF AMS_Utility_PVT.is_Y_or_N (p_media_rec.inbound_flag) = FND_API.g_false THEN
1613: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1614: FND_MESSAGE.set_name ('AMS', 'AMS_MED_BAD_INBOUND_FLAG');
1615: FND_MSG_PUB.add;
1616: END IF;
1617:
1618: x_return_status := FND_API.g_ret_sts_error;
1619: RETURN;

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

1622:
1623: -- ENABLED_FLAG
1624: IF p_media_rec.enabled_flag <> FND_API.g_miss_char AND p_media_rec.enabled_flag IS NOT NULL THEN
1625: IF AMS_Utility_PVT.is_Y_or_N (p_media_rec.enabled_flag) = FND_API.g_false THEN
1626: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1627: FND_MESSAGE.set_name ('AMS', 'AMS_MED_BAD_ENABLED_FLAG');
1628: FND_MSG_PUB.add;
1629: END IF;
1630:

Line 1628: FND_MSG_PUB.add;

1624: IF p_media_rec.enabled_flag <> FND_API.g_miss_char AND p_media_rec.enabled_flag IS NOT NULL THEN
1625: IF AMS_Utility_PVT.is_Y_or_N (p_media_rec.enabled_flag) = FND_API.g_false THEN
1626: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1627: FND_MESSAGE.set_name ('AMS', 'AMS_MED_BAD_ENABLED_FLAG');
1628: FND_MSG_PUB.add;
1629: END IF;
1630:
1631: x_return_status := FND_API.g_ret_sts_error;
1632: RETURN;

Line 1696: FND_MSG_PUB.initialize;

1692:
1693: END IF;
1694:
1695: IF FND_API.to_boolean (p_init_msg_list) THEN
1696: FND_MSG_PUB.initialize;
1697: END IF;
1698:
1699: IF NOT FND_API.compatible_api_call (
1700: L_API_VERSION,

Line 1824: FND_MSG_PUB.count_and_get (

1820: IF FND_API.To_Boolean ( p_commit ) THEN
1821: COMMIT WORK;
1822: END IF;
1823:
1824: FND_MSG_PUB.count_and_get (
1825: p_encoded => FND_API.g_false,
1826: p_count => x_msg_count,
1827: p_data => x_msg_data
1828: );

Line 1842: FND_MSG_PUB.count_and_get (

1838: EXCEPTION
1839: WHEN FND_API.g_exc_error THEN
1840: ROLLBACK TO Create_MediaChannel;
1841: x_return_status := FND_API.g_ret_sts_error;
1842: FND_MSG_PUB.count_and_get (
1843: p_encoded => FND_API.g_false,
1844: p_count => x_msg_count,
1845: p_data => x_msg_data
1846: );

Line 1850: FND_MSG_PUB.count_and_get (

1846: );
1847: WHEN FND_API.g_exc_unexpected_error THEN
1848: ROLLBACK TO Create_MediaChannel;
1849: x_return_status := FND_API.g_ret_sts_unexp_error ;
1850: FND_MSG_PUB.count_and_get (
1851: p_encoded => FND_API.g_false,
1852: p_count => x_msg_count,
1853: p_data => x_msg_data
1854: );

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

1855: WHEN OTHERS THEN
1856: ROLLBACK TO Create_MediaChannel;
1857: x_return_status := FND_API.g_ret_sts_unexp_error ;
1858:
1859: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1860: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1861: END IF;
1862:
1863: FND_MSG_PUB.count_and_get (

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

1856: ROLLBACK TO Create_MediaChannel;
1857: x_return_status := FND_API.g_ret_sts_unexp_error ;
1858:
1859: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1860: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1861: END IF;
1862:
1863: FND_MSG_PUB.count_and_get (
1864: p_encoded => FND_API.g_false,

Line 1863: FND_MSG_PUB.count_and_get (

1859: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1860: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1861: END IF;
1862:
1863: FND_MSG_PUB.count_and_get (
1864: p_encoded => FND_API.g_false,
1865: p_count => x_msg_count,
1866: p_data => x_msg_data
1867: );

Line 1909: FND_MSG_PUB.initialize;

1905:
1906: END IF;
1907:
1908: IF FND_API.to_boolean (p_init_msg_list) THEN
1909: FND_MSG_PUB.initialize;
1910: END IF;
1911:
1912: IF NOT FND_API.compatible_api_call(
1913: l_api_version,

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

1994: WHERE media_channel_id = l_mediachl_rec.media_channel_id
1995: AND object_version_number = l_mediachl_rec.object_version_number ;
1996:
1997: IF (SQL%NOTFOUND) THEN
1998: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1999: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2000: FND_MSG_PUB.add;
2001: END IF;
2002: RAISE FND_API.g_exc_error;

Line 2000: FND_MSG_PUB.add;

1996:
1997: IF (SQL%NOTFOUND) THEN
1998: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1999: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2000: FND_MSG_PUB.add;
2001: END IF;
2002: RAISE FND_API.g_exc_error;
2003: END IF;
2004:

Line 2010: FND_MSG_PUB.count_and_get (

2006: IF FND_API.to_boolean (p_commit) THEN
2007: COMMIT;
2008: END IF;
2009:
2010: FND_MSG_PUB.count_and_get (
2011: p_encoded => FND_API.g_false,
2012: p_count => x_msg_count,
2013: p_data => x_msg_data
2014: );

Line 2028: FND_MSG_PUB.count_and_get (

2024: EXCEPTION
2025: WHEN FND_API.g_exc_error THEN
2026: ROLLBACK TO Update_MediaChannel;
2027: x_return_status := FND_API.g_ret_sts_error;
2028: FND_MSG_PUB.count_and_get (
2029: p_encoded => FND_API.g_false,
2030: p_count => x_msg_count,
2031: p_data => x_msg_data
2032: );

Line 2036: FND_MSG_PUB.count_and_get (

2032: );
2033: WHEN FND_API.g_exc_unexpected_error THEN
2034: ROLLBACK TO Update_MediaChannel;
2035: x_return_status := FND_API.g_ret_sts_unexp_error ;
2036: FND_MSG_PUB.count_and_get (
2037: p_encoded => FND_API.g_false,
2038: p_count => x_msg_count,
2039: p_data => x_msg_data
2040: );

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

2041: WHEN OTHERS THEN
2042: ROLLBACK TO Update_MediaChannel;
2043: x_return_status := FND_API.g_ret_sts_unexp_error ;
2044:
2045: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2046: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2047: END IF;
2048:
2049: FND_MSG_PUB.count_and_get (

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

2042: ROLLBACK TO Update_MediaChannel;
2043: x_return_status := FND_API.g_ret_sts_unexp_error ;
2044:
2045: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2046: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2047: END IF;
2048:
2049: FND_MSG_PUB.count_and_get (
2050: p_encoded => FND_API.g_false,

Line 2049: FND_MSG_PUB.count_and_get (

2045: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2046: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2047: END IF;
2048:
2049: FND_MSG_PUB.count_and_get (
2050: p_encoded => FND_API.g_false,
2051: p_count => x_msg_count,
2052: p_data => x_msg_data
2053: );

Line 2119: FND_MSG_PUB.initialize;

2115:
2116: END IF;
2117:
2118: IF FND_API.to_boolean (p_init_msg_list) THEN
2119: FND_MSG_PUB.initialize;
2120: END IF;
2121:
2122: IF NOT FND_API.compatible_api_call (
2123: l_api_version,

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

2140: FETCH c_in_use INTO l_in_use;
2141: CLOSE c_in_use;
2142:
2143: IF l_in_use IS NOT NULL THEN
2144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2145: THEN
2146: FND_MESSAGE.set_name('AMS', 'AMS_MED_CANNOT_DELETE_CHAN');
2147: FND_MSG_PUB.add;
2148: END IF;

Line 2147: FND_MSG_PUB.add;

2143: IF l_in_use IS NOT NULL THEN
2144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2145: THEN
2146: FND_MESSAGE.set_name('AMS', 'AMS_MED_CANNOT_DELETE_CHAN');
2147: FND_MSG_PUB.add;
2148: END IF;
2149: RAISE FND_API.g_exc_error;
2150: END IF;
2151:

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

2154: FETCH c_check_schedule_association INTO l_mktg_medium_id;
2155: CLOSE c_check_schedule_association;
2156:
2157: IF l_mktg_medium_id IS NOT NULL THEN
2158: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2159: THEN
2160: FND_MESSAGE.set_name('AMS', 'AMS_MKTG_MEDIA_ACT_IN_USE');
2161: FND_MSG_PUB.add;
2162: END IF;

Line 2161: FND_MSG_PUB.add;

2157: IF l_mktg_medium_id IS NOT NULL THEN
2158: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2159: THEN
2160: FND_MESSAGE.set_name('AMS', 'AMS_MKTG_MEDIA_ACT_IN_USE');
2161: FND_MSG_PUB.add;
2162: END IF;
2163: RAISE FND_API.g_exc_error;
2164: END IF;
2165: -- Bug fix:2089112. 10/31/01

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

2173: DELETE FROM ams_media_channels
2174: WHERE media_channel_id = p_mediachl_id;
2175:
2176: IF (SQL%NOTFOUND) THEN
2177: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2178: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
2179: FND_MSG_PUB.add;
2180: END IF;
2181: RAISE FND_API.g_exc_error;

Line 2179: FND_MSG_PUB.add;

2175:
2176: IF (SQL%NOTFOUND) THEN
2177: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2178: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
2179: FND_MSG_PUB.add;
2180: END IF;
2181: RAISE FND_API.g_exc_error;
2182: END IF;
2183:

Line 2189: FND_MSG_PUB.count_and_get (

2185: IF FND_API.to_boolean (p_commit) THEN
2186: COMMIT;
2187: END IF;
2188:
2189: FND_MSG_PUB.count_and_get (
2190: p_encoded => FND_API.g_false,
2191: p_count => x_msg_count,
2192: p_data => x_msg_data
2193: );

Line 2207: FND_MSG_PUB.count_and_get (

2203: EXCEPTION
2204: WHEN FND_API.g_exc_error THEN
2205: ROLLBACK TO Delete_MediaChannel;
2206: x_return_status := FND_API.g_ret_sts_error;
2207: FND_MSG_PUB.count_and_get (
2208: p_encoded => FND_API.g_false,
2209: p_count => x_msg_count,
2210: p_data => x_msg_data
2211: );

Line 2215: FND_MSG_PUB.count_and_get (

2211: );
2212: WHEN FND_API.g_exc_unexpected_error THEN
2213: ROLLBACK TO Delete_MediaChannel;
2214: x_return_status := FND_API.g_ret_sts_unexp_error ;
2215: FND_MSG_PUB.count_and_get (
2216: p_encoded => FND_API.g_false,
2217: p_count => x_msg_count,
2218: p_data => x_msg_data
2219: );

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

2220: WHEN OTHERS THEN
2221: ROLLBACK TO Delete_MediaChannel;
2222: x_return_status := FND_API.g_ret_sts_unexp_error ;
2223:
2224: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2225: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2226: END IF;
2227:
2228: FND_MSG_PUB.count_and_get (

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

2221: ROLLBACK TO Delete_MediaChannel;
2222: x_return_status := FND_API.g_ret_sts_unexp_error ;
2223:
2224: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2225: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2226: END IF;
2227:
2228: FND_MSG_PUB.count_and_get (
2229: p_encoded => FND_API.g_false,

Line 2228: FND_MSG_PUB.count_and_get (

2224: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2225: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2226: END IF;
2227:
2228: FND_MSG_PUB.count_and_get (
2229: p_encoded => FND_API.g_false,
2230: p_count => x_msg_count,
2231: p_data => x_msg_data
2232: );

Line 2281: FND_MSG_PUB.initialize;

2277: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
2278: END IF;
2279:
2280: IF FND_API.to_boolean (p_init_msg_list) THEN
2281: FND_MSG_PUB.initialize;
2282: END IF;
2283:
2284: IF NOT FND_API.compatible_api_call (
2285: l_api_version,

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

2301: OPEN c_lock;
2302: FETCH c_lock INTO l_dummy;
2303: IF (c_lock%NOTFOUND) THEN
2304: CLOSE c_lock;
2305: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2306: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2307: FND_MSG_PUB.add;
2308: END IF;
2309: RAISE FND_API.g_exc_error;

Line 2307: FND_MSG_PUB.add;

2303: IF (c_lock%NOTFOUND) THEN
2304: CLOSE c_lock;
2305: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2306: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2307: FND_MSG_PUB.add;
2308: END IF;
2309: RAISE FND_API.g_exc_error;
2310: END IF;
2311: CLOSE c_lock;

Line 2314: FND_MSG_PUB.count_and_get (

2310: END IF;
2311: CLOSE c_lock;
2312:
2313: -------------------- finish --------------------------
2314: FND_MSG_PUB.count_and_get (
2315: p_encoded => FND_API.g_false,
2316: p_count => x_msg_count,
2317: p_data => x_msg_data
2318: );

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

2327:
2328: EXCEPTION
2329: WHEN AMS_Utility_PVT.resource_locked THEN
2330: x_return_status := FND_API.g_ret_sts_error;
2331: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2332: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
2333: FND_MSG_PUB.add;
2334: END IF;
2335:

Line 2333: FND_MSG_PUB.add;

2329: WHEN AMS_Utility_PVT.resource_locked THEN
2330: x_return_status := FND_API.g_ret_sts_error;
2331: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2332: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
2333: FND_MSG_PUB.add;
2334: END IF;
2335:
2336: FND_MSG_PUB.count_and_get (
2337: p_encoded => FND_API.g_false,

Line 2336: FND_MSG_PUB.count_and_get (

2332: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
2333: FND_MSG_PUB.add;
2334: END IF;
2335:
2336: FND_MSG_PUB.count_and_get (
2337: p_encoded => FND_API.g_false,
2338: p_count => x_msg_count,
2339: p_data => x_msg_data
2340: );

Line 2343: FND_MSG_PUB.count_and_get (

2339: p_data => x_msg_data
2340: );
2341: WHEN FND_API.g_exc_error THEN
2342: x_return_status := FND_API.g_ret_sts_error;
2343: FND_MSG_PUB.count_and_get (
2344: p_encoded => FND_API.g_false,
2345: p_count => x_msg_count,
2346: p_data => x_msg_data
2347: );

Line 2350: FND_MSG_PUB.count_and_get (

2346: p_data => x_msg_data
2347: );
2348: WHEN FND_API.g_exc_unexpected_error THEN
2349: x_return_status := FND_API.g_ret_sts_unexp_error ;
2350: FND_MSG_PUB.count_and_get (
2351: p_encoded => FND_API.g_false,
2352: p_count => x_msg_count,
2353: p_data => x_msg_data
2354: );

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

2353: p_data => x_msg_data
2354: );
2355: WHEN OTHERS THEN
2356: x_return_status := FND_API.g_ret_sts_unexp_error ;
2357: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2358: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2359: END IF;
2360:
2361: FND_MSG_PUB.count_and_get (

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

2354: );
2355: WHEN OTHERS THEN
2356: x_return_status := FND_API.g_ret_sts_unexp_error ;
2357: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2358: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2359: END IF;
2360:
2361: FND_MSG_PUB.count_and_get (
2362: p_encoded => FND_API.g_false,

Line 2361: FND_MSG_PUB.count_and_get (

2357: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2358: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2359: END IF;
2360:
2361: FND_MSG_PUB.count_and_get (
2362: p_encoded => FND_API.g_false,
2363: p_count => x_msg_count,
2364: p_data => x_msg_data
2365: );

Line 2399: FND_MSG_PUB.initialize;

2395: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
2396: END IF;
2397:
2398: IF FND_API.to_boolean (p_init_msg_list) THEN
2399: FND_MSG_PUB.initialize;
2400: END IF;
2401:
2402: IF NOT FND_API.compatible_api_call (
2403: l_api_version,

Line 2456: FND_MSG_PUB.count_and_get (

2452: END IF;
2453: END IF;
2454:
2455: -------------------- finish --------------------------
2456: FND_MSG_PUB.count_and_get (
2457: p_encoded => FND_API.g_false,
2458: p_count => x_msg_count,
2459: p_data => x_msg_data
2460: );

Line 2473: FND_MSG_PUB.count_and_get (

2469:
2470: EXCEPTION
2471: WHEN FND_API.g_exc_error THEN
2472: x_return_status := FND_API.g_ret_sts_error;
2473: FND_MSG_PUB.count_and_get (
2474: p_encoded => FND_API.g_false,
2475: p_count => x_msg_count,
2476: p_data => x_msg_data
2477: );

Line 2480: FND_MSG_PUB.count_and_get (

2476: p_data => x_msg_data
2477: );
2478: WHEN FND_API.g_exc_unexpected_error THEN
2479: x_return_status := FND_API.g_ret_sts_unexp_error ;
2480: FND_MSG_PUB.count_and_get (
2481: p_encoded => FND_API.g_false,
2482: p_count => x_msg_count,
2483: p_data => x_msg_data
2484: );

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

2483: p_data => x_msg_data
2484: );
2485: WHEN OTHERS THEN
2486: x_return_status := FND_API.g_ret_sts_unexp_error;
2487: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2488: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2489: END IF;
2490:
2491: FND_MSG_PUB.count_and_get (

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

2484: );
2485: WHEN OTHERS THEN
2486: x_return_status := FND_API.g_ret_sts_unexp_error;
2487: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2488: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2489: END IF;
2490:
2491: FND_MSG_PUB.count_and_get (
2492: p_encoded => FND_API.g_false,

Line 2491: FND_MSG_PUB.count_and_get (

2487: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2488: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2489: END IF;
2490:
2491: FND_MSG_PUB.count_and_get (
2492: p_encoded => FND_API.g_false,
2493: p_count => x_msg_count,
2494: p_data => x_msg_data
2495: );

Line 2607: FND_MSG_PUB.add;

2603: END IF;
2604:
2605: IF l_active_from_date > l_active_to_date THEN
2606: FND_MESSAGE.set_name ('AMS', 'AMS_MED_FROMDT_GTR_TODT');
2607: FND_MSG_PUB.add;
2608: x_return_status := FND_API.g_ret_sts_error;
2609: RETURN;
2610: END IF;
2611: END IF;

Line 2643: FND_MSG_PUB.add;

2639: )
2640: THEN
2641:
2642: FND_MESSAGE.set_name ('AMS', 'AMS_MEDCHAN_FROMDT_GTR');
2643: FND_MSG_PUB.add;
2644: x_return_status := FND_API.g_ret_sts_error;
2645: RETURN;
2646:
2647: END IF;

Line 2657: FND_MSG_PUB.add;

2653: )
2654: THEN
2655:
2656: FND_MESSAGE.set_name ('AMS', 'AMS_MEDCHAN_TODT_GTR');
2657: FND_MSG_PUB.add;
2658: x_return_status := FND_API.g_ret_sts_error;
2659: RETURN;
2660:
2661: END IF;

Line 2671: FND_MSG_PUB.add;

2667:
2668: IF l_active_from_date < l_chan_from_date THEN
2669:
2670: FND_MESSAGE.set_name ('AMS', 'AMS_MEDCHAN_FROMDT_GTR');
2671: FND_MSG_PUB.add;
2672: x_return_status := FND_API.g_ret_sts_error;
2673: RETURN;
2674:
2675: END IF;

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

2723: OPEN c_mediachl;
2724: FETCH c_mediachl INTO l_mediachl_rec;
2725: IF c_mediachl%NOTFOUND THEN
2726: CLOSE c_mediachl;
2727: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2728: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2729: FND_MSG_PUB.add;
2730: END IF;
2731: RAISE FND_API.g_exc_error;

Line 2729: FND_MSG_PUB.add;

2725: IF c_mediachl%NOTFOUND THEN
2726: CLOSE c_mediachl;
2727: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2728: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2729: FND_MSG_PUB.add;
2730: END IF;
2731: RAISE FND_API.g_exc_error;
2732: END IF;
2733: CLOSE c_mediachl;

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

2768:
2769: --
2770: -- MEDIA_ID
2771: IF p_mediachl_rec.media_id IS NULL THEN
2772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2773: FND_MESSAGE.set_name('AMS', 'AMS_MED_NO_MEDIA_ID');
2774: FND_MSG_PUB.add;
2775: END IF;
2776:

Line 2774: FND_MSG_PUB.add;

2770: -- MEDIA_ID
2771: IF p_mediachl_rec.media_id IS NULL THEN
2772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2773: FND_MESSAGE.set_name('AMS', 'AMS_MED_NO_MEDIA_ID');
2774: FND_MSG_PUB.add;
2775: END IF;
2776:
2777: x_return_status := FND_API.g_ret_sts_error;
2778: RETURN;

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

2780:
2781: --
2782: -- CHANNEL_ID
2783: IF p_mediachl_rec.channel_id IS NULL THEN
2784: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2785: THEN
2786: FND_MESSAGE.set_name('AMS', 'AMS_MED_NO_CHANNEL_ID');
2787: FND_MSG_PUB.add;
2788: END IF;

Line 2787: FND_MSG_PUB.add;

2783: IF p_mediachl_rec.channel_id IS NULL THEN
2784: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2785: THEN
2786: FND_MESSAGE.set_name('AMS', 'AMS_MED_NO_CHANNEL_ID');
2787: FND_MSG_PUB.add;
2788: END IF;
2789:
2790: x_return_status := FND_API.g_ret_sts_error;
2791: RETURN;

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

2793:
2794: --
2795: -- ACTIVE_FROM_DATE
2796: IF p_mediachl_rec.active_from_date IS NULL THEN
2797: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2798: FND_MESSAGE.set_name('AMS', 'AMS_MED_NO_ACTIVE_FROM_DATE');
2799: FND_MSG_PUB.add;
2800: END IF;
2801:

Line 2799: FND_MSG_PUB.add;

2795: -- ACTIVE_FROM_DATE
2796: IF p_mediachl_rec.active_from_date IS NULL THEN
2797: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2798: FND_MESSAGE.set_name('AMS', 'AMS_MED_NO_ACTIVE_FROM_DATE');
2799: FND_MSG_PUB.add;
2800: END IF;
2801:
2802: x_return_status := FND_API.g_ret_sts_error;
2803: RETURN;

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

2937: END IF;
2938:
2939: END IF;
2940: IF l_valid_flag = FND_API.g_false THEN
2941: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2942: FND_MESSAGE.set_name('AMS', 'AMS_MED_DUP_MEDIA_CHANNEL');
2943: FND_MSG_PUB.add;
2944: END IF;
2945: x_return_status := FND_API.g_ret_sts_error;

Line 2943: FND_MSG_PUB.add;

2939: END IF;
2940: IF l_valid_flag = FND_API.g_false THEN
2941: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2942: FND_MESSAGE.set_name('AMS', 'AMS_MED_DUP_MEDIA_CHANNEL');
2943: FND_MSG_PUB.add;
2944: END IF;
2945: x_return_status := FND_API.g_ret_sts_error;
2946: RETURN;
2947: END IF;

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

2969: 'media_id',
2970: p_mediachl_rec.media_id
2971: ) = FND_API.g_false
2972: THEN
2973: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2974: FND_MESSAGE.set_name ('AMS', 'AMS_MED_BAD_MEDIA_ID');
2975: FND_MSG_PUB.add;
2976: END IF;
2977:

Line 2975: FND_MSG_PUB.add;

2971: ) = FND_API.g_false
2972: THEN
2973: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2974: FND_MESSAGE.set_name ('AMS', 'AMS_MED_BAD_MEDIA_ID');
2975: FND_MSG_PUB.add;
2976: END IF;
2977:
2978: x_return_status := FND_API.g_ret_sts_error;
2979: RETURN;

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

2988: 'channel_id',
2989: p_mediachl_rec.channel_id
2990: ) = FND_API.g_false
2991: THEN
2992: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2993: FND_MESSAGE.set_name ('AMS', 'AMS_MED_BAD_CHANNEL_ID');
2994: FND_MSG_PUB.add;
2995: END IF;
2996:

Line 2994: FND_MSG_PUB.add;

2990: ) = FND_API.g_false
2991: THEN
2992: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2993: FND_MESSAGE.set_name ('AMS', 'AMS_MED_BAD_CHANNEL_ID');
2994: FND_MSG_PUB.add;
2995: END IF;
2996:
2997: x_return_status := FND_API.g_ret_sts_error;
2998: RETURN;

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

3096: ISSUE: Do we need to check this even though
3097: from date is NOT NULL on channels table?
3098: ***/
3099: IF l_channel_rec.active_from_date IS NULL AND l_active_from_date IS NOT NULL THEN
3100: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3101: FND_MESSAGE.set_name ('AMS', 'AMS_MED_CFD_IS_NULL'); -- Channel From Date is NULL.
3102: FND_MSG_PUB.Add;
3103: END IF;
3104:

Line 3102: FND_MSG_PUB.Add;

3098: ***/
3099: IF l_channel_rec.active_from_date IS NULL AND l_active_from_date IS NOT NULL THEN
3100: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3101: FND_MESSAGE.set_name ('AMS', 'AMS_MED_CFD_IS_NULL'); -- Channel From Date is NULL.
3102: FND_MSG_PUB.Add;
3103: END IF;
3104:
3105: x_return_status := FND_API.g_ret_sts_error;
3106: END IF;

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

3105: x_return_status := FND_API.g_ret_sts_error;
3106: END IF;
3107:
3108: IF l_channel_rec.active_to_date IS NULL AND l_active_from_date IS NOT NULL THEN
3109: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3110: FND_MESSAGE.set_name ('AMS', 'AMS_MED_CTD_IS_NULL'); -- Channel To Date is NULL.
3111: FND_MSG_PUB.Add;
3112: END IF;
3113:

Line 3111: FND_MSG_PUB.Add;

3107:
3108: IF l_channel_rec.active_to_date IS NULL AND l_active_from_date IS NOT NULL THEN
3109: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3110: FND_MESSAGE.set_name ('AMS', 'AMS_MED_CTD_IS_NULL'); -- Channel To Date is NULL.
3111: FND_MSG_PUB.Add;
3112: END IF;
3113:
3114: x_return_status := FND_API.g_ret_sts_error;
3115: END IF;

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

3117: --
3118: -- media channel's active from date should not
3119: -- be before channel's active from date.
3120: IF l_active_from_date < l_channel_rec.active_from_date THEN
3121: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3122: FND_MESSAGE.set_name ('AMS', 'AMS_MED_MFD_LT_CFD');
3123: FND_MSG_PUB.Add;
3124: END IF;
3125:

Line 3123: FND_MSG_PUB.Add;

3119: -- be before channel's active from date.
3120: IF l_active_from_date < l_channel_rec.active_from_date THEN
3121: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3122: FND_MESSAGE.set_name ('AMS', 'AMS_MED_MFD_LT_CFD');
3123: FND_MSG_PUB.Add;
3124: END IF;
3125:
3126: x_return_status := FND_API.g_ret_sts_error;
3127: END IF;

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

3129: --
3130: -- media channel's active from date should not
3131: -- be after channel's active to date.
3132: IF l_active_from_date > l_channel_rec.active_to_date THEN
3133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3134: FND_MESSAGE.set_name ('AMS', 'AMS_MED_CFD_GT_MTD');
3135: FND_MSG_PUB.Add;
3136: END IF;
3137:

Line 3135: FND_MSG_PUB.Add;

3131: -- be after channel's active to date.
3132: IF l_active_from_date > l_channel_rec.active_to_date THEN
3133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3134: FND_MESSAGE.set_name ('AMS', 'AMS_MED_CFD_GT_MTD');
3135: FND_MSG_PUB.Add;
3136: END IF;
3137:
3138: x_return_status := FND_API.g_ret_sts_error;
3139: END IF;

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

3141: --
3142: -- media channel's active to date should not
3143: -- be after channel's active to date.
3144: IF l_active_to_date > l_channel_rec.active_to_date THEN
3145: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3146: FND_MESSAGE.set_name ('AMS', 'AMS_MED_CTD_GT_MTD');
3147: FND_MSG_PUB.Add;
3148: END IF;
3149:

Line 3147: FND_MSG_PUB.Add;

3143: -- be after channel's active to date.
3144: IF l_active_to_date > l_channel_rec.active_to_date THEN
3145: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3146: FND_MESSAGE.set_name ('AMS', 'AMS_MED_CTD_GT_MTD');
3147: FND_MSG_PUB.Add;
3148: END IF;
3149:
3150: x_return_status := FND_API.g_ret_sts_error;
3151: END IF;