APPS.AMS_ACTCATEGORY_PVT dependencies on AMS_UTILITY_PVT

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

83: --
84: -- API body
85: --
86: ----------------------- validate -----------------------
87: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
88:
89: Validate_Act_Category
90: ( p_api_version => 1.0
91: ,p_init_msg_list => p_init_msg_list

Line 691: WHEN AMS_Utility_PVT.resource_locked THEN

687: p_data => x_msg_data,
688: p_encoded => FND_API.G_FALSE
689: );
690:
691: WHEN AMS_Utility_PVT.resource_locked THEN
692: x_return_status := FND_API.g_ret_sts_error;
693: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
694: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
695: FND_MSG_PUB.add;

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

785:
786: --
787: -- API body
788: --
789: AMS_Utility_PVT.debug_message(l_full_name||': check items');
790:
791: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item
792: THEN
793:

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

809:
810: -- Perform cross attribute validation and missing attribute checks. Record
811: -- level validation.
812:
813: AMS_Utility_PVT.debug_message(l_full_name||': check record level');
814:
815:
816: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record
817: THEN

Line 990: IF AMS_Utility_PVT.check_uniqueness(

986: -- Validate uniqueness
987: IF p_validation_mode = JTF_PLSQL_API.g_create
988: AND p_act_category_rec.activity_category_id IS NOT NULL
989: THEN
990: IF AMS_Utility_PVT.check_uniqueness(
991: 'ams_act_categories',
992: 'activity_category_id = ' || p_act_category_rec.activity_category_id
993: ) = FND_API.g_false
994: THEN

Line 1017: IF AMS_Utility_PVT.Check_FK_Exists (

1013: l_table_name := 'AMS_ACT_CATEGORIES';
1014: l_pk_name := 'ACT_CATEGORY_USED_BY_ID';
1015: l_pk_value := p_act_category_rec.ACT_CATEGORY_USED_BY_ID;
1016:
1017: IF AMS_Utility_PVT.Check_FK_Exists (
1018: p_table_name => l_table_name
1019: ,p_pk_name => l_pk_name
1020: ,p_pk_value => l_pk_value
1021: ) = FND_API.G_FALSE

Line 1042: IF AMS_Utility_PVT.Check_FK_Exists (

1038: l_table_name := 'AMS_ACT_CATEGORIES';
1039: l_pk_name := 'ACT_CATEGORY_USED_BY_ID';
1040: l_pk_value := p_act_category_rec.ACT_CATEGORY_USED_BY_ID;
1041:
1042: IF AMS_Utility_PVT.Check_FK_Exists (
1043: p_table_name => l_table_name
1044: ,p_pk_name => l_pk_name
1045: ,p_pk_value => l_pk_value
1046: ) = FND_API.G_FALSE

Line 1080: IF AMS_Utility_PVT.Check_FK_Exists (

1076: x_return_status := FND_API.G_RET_STS_ERROR;
1077: -- If any errors happen abort API/Procedure.
1078: RETURN;
1079: end if;
1080: IF AMS_Utility_PVT.Check_FK_Exists (
1081: p_table_name => l_table_name
1082: ,p_pk_name => l_pk_name
1083: ,p_pk_value => l_pk_value
1084: ) = FND_API.G_FALSE

Line 1104: IF AMS_Utility_PVT.Check_FK_Exists (

1100: l_table_name := 'AMS_CATEGORIES_B';
1101: l_pk_name := 'CATEGORY_ID';
1102: l_pk_value := p_act_category_rec.CATEGORY_ID;
1103:
1104: IF AMS_Utility_PVT.Check_FK_Exists (
1105: p_table_name => l_table_name
1106: ,p_pk_name => l_pk_name
1107: ,p_pk_value => l_pk_value
1108: ) = FND_API.G_FALSE

Line 1125: IF AMS_Utility_PVT.check_lookup_exists(

1121:
1122: -- check for lookups....
1123:
1124: IF p_act_category_rec.arc_act_category_used_by <> FND_API.g_miss_char THEN
1125: IF AMS_Utility_PVT.check_lookup_exists(
1126: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
1127: p_lookup_code => p_act_category_rec.arc_act_category_used_by
1128: ) = FND_API.g_false
1129: THEN