APPS.AMS_ACTDELVMETHOD_PVT dependencies on AMS_UTILITY_PVT

Line 72: AMS_Utility_PVT.debug_message(l_full_name ||': validate');

68: --
69: -- API body
70: --
71: ----------------------- validate -----------------------
72: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
73: Validate_Act_DelvMethod
74: ( p_api_version => 1.0
75: ,p_init_msg_list => p_init_msg_list
76: ,p_validation_level => p_validation_level

Line 262: AMS_Utility_PVT.debug_message(l_api_name||': Calling check items');

258: -- Perform the database operation
259:
260:
261:
262: AMS_Utility_PVT.debug_message(l_api_name||': Calling check items');
263: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item
264: THEN
265: Validate_Act_DelvMethod_Items
266: ( p_act_DelvMethod_rec => l_act_DelvMethod_rec,

Line 564: WHEN AMS_Utility_PVT.resource_locked THEN

560: ( p_count => x_msg_count,
561: p_data => x_msg_data,
562: p_encoded => FND_API.G_FALSE
563: );
564: WHEN AMS_Utility_PVT.resource_locked THEN
565: x_return_status := FND_API.g_ret_sts_error;
566: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
567: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
568: FND_MSG_PUB.add;

Line 634: AMS_Utility_PVT.debug_message(l_full_name||': check items');

630: x_return_status := FND_API.G_RET_STS_SUCCESS;
631: --
632: -- API body
633: --
634: AMS_Utility_PVT.debug_message(l_full_name||': check items');
635: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item
636: THEN
637: Validate_Act_DelvMethod_Items
638: ( p_act_DelvMethod_rec => l_act_DelvMethod_rec,

Line 653: AMS_Utility_PVT.debug_message(l_full_name||': check record level');

649: END IF;
650: END IF;
651: -- Perform cross attribute validation and missing attribute checks. Record
652: -- level validation.
653: AMS_Utility_PVT.debug_message(l_full_name||': check record level');
654: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record
655: THEN
656: Validate_Act_DelvMethod_Record(
657: p_act_DelvMethod_rec => l_act_DelvMethod_rec,

Line 768: IF AMS_Utility_PVT.check_uniqueness(

764: -- Validate uniqueness
765: IF p_validation_mode = JTF_PLSQL_API.g_create
766: AND p_act_DelvMethod_rec.activity_delivery_method_id IS NOT NULL
767: THEN
768: IF AMS_Utility_PVT.check_uniqueness(
769: 'ams_act_delivery_methods',
770: 'activity_delivery_method_id = ' || p_act_DelvMethod_rec.activity_delivery_method_id
771: ) = FND_API.g_false
772: THEN

Line 792: AMS_Utility_PVT.debug_message(l_pk_value ||': insert B');

788: IF p_act_DelvMethod_rec.ARC_ACT_DELIVERY_USED_BY = 'EVEH' THEN
789: l_table_name := 'AMS_EVENT_HEADERS_VL';
790: l_pk_name := 'EVENT_HEADER_ID';
791: l_pk_value := p_act_DelvMethod_rec.ACT_DELIVERY_METHOD_USED_BY_ID;
792: AMS_Utility_PVT.debug_message(l_pk_value ||': insert B');
793: IF AMS_Utility_PVT.Check_FK_Exists (
794: p_table_name => l_table_name
795: ,p_pk_name => l_pk_name
796: ,p_pk_value => l_pk_value

Line 793: IF AMS_Utility_PVT.Check_FK_Exists (

789: l_table_name := 'AMS_EVENT_HEADERS_VL';
790: l_pk_name := 'EVENT_HEADER_ID';
791: l_pk_value := p_act_DelvMethod_rec.ACT_DELIVERY_METHOD_USED_BY_ID;
792: AMS_Utility_PVT.debug_message(l_pk_value ||': insert B');
793: IF AMS_Utility_PVT.Check_FK_Exists (
794: p_table_name => l_table_name
795: ,p_pk_name => l_pk_name
796: ,p_pk_value => l_pk_value
797: ) = FND_API.G_FALSE

Line 813: IF AMS_Utility_PVT.check_lookup_exists(

809: END IF;
810:
811: -- check for lookups....
812: IF p_act_DelvMethod_rec.arc_act_delivery_used_by <> FND_API.g_miss_char THEN
813: IF AMS_Utility_PVT.check_lookup_exists(
814: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
815: p_lookup_code => p_act_DelvMethod_rec.arc_act_delivery_used_by
816: ) = FND_API.g_false
817: THEN

Line 828: IF AMS_Utility_PVT.check_lookup_exists(

824: RETURN;
825: END IF;
826: END IF;
827: IF p_act_DelvMethod_rec.delivery_media_type_code <> FND_API.g_miss_char THEN
828: IF AMS_Utility_PVT.check_lookup_exists(
829: p_lookup_type => 'AMS_DELIVERY_MEDIA_TYPE',
830: p_lookup_code => p_act_DelvMethod_rec.DELIVERY_MEDIA_TYPE_CODE
831: ) = FND_API.g_false
832: THEN