APPS.AMS_LIST_RULES_ALL_PVT dependencies on JTF_PLSQL_API

Line 279: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

275:
276: x_return_status := FND_API.g_ret_sts_success;
277:
278: -- validate
279: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
280: IF (AMS_DEBUG_HIGH_ON) THEN
281:
282: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
283: END IF;

Line 287: p_validation_mode => JTF_PLSQL_API.g_update,

283: END IF;
284:
285: check_items
286: (
287: p_validation_mode => JTF_PLSQL_API.g_update,
288: x_return_status => l_return_status,
289: p_list_rule_rec => l_list_rule_rec
290: );
291:

Line 307: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

303: l_list_rule_rec
304: );
305:
306: -- record level
307: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
308: IF (AMS_DEBUG_HIGH_ON) THEN
309:
310: AMS_Utility_PVT.debug_message(l_full_name||': check record');
311: END IF;

Line 755: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

751:
752: x_return_status := FND_API.g_ret_sts_success;
753:
754: ---------------------- validate ------------------------
755: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
756: IF (AMS_DEBUG_HIGH_ON) THEN
757:
758: AMS_Utility_PVT.debug_message(l_full_name||': check items');
759: END IF;

Line 762: p_validation_mode => JTF_PLSQL_API.g_create,

758: AMS_Utility_PVT.debug_message(l_full_name||': check items');
759: END IF;
760: check_items
761: (
762: p_validation_mode => JTF_PLSQL_API.g_create,
763: x_return_status => l_return_status,
764: p_list_rule_rec => p_list_rule_rec
765: );
766:

Line 775: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

771: END IF;
772: END IF;
773:
774: -- record level
775: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
776: IF (AMS_DEBUG_HIGH_ON) THEN
777:
778: AMS_Utility_PVT.debug_message(l_full_name||': check record');
779: END IF;

Line 941: AND p_validation_mode = JTF_PLSQL_API.g_update THEN

937: x_return_status := FND_API.g_ret_sts_success;
938:
939: -- check list_rule_id
940: IF p_list_rule_rec.list_rule_id IS NULL
941: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
942: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
943: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_ID');
944: FND_MSG_PUB.add;
945: END IF;

Line 953: AND p_validation_mode = JTF_PLSQL_API.g_update

949: END IF;
950:
951: -- check object_version_number
952: IF p_list_rule_rec.object_version_number IS NULL
953: AND p_validation_mode = JTF_PLSQL_API.g_update
954: THEN
955: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
956: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');
957: FND_MSG_PUB.add;

Line 1009: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

1005: -- 01/24/2000 julou created
1006: -------------------------------------------------------------------------------
1007: PROCEDURE check_uk_items
1008: (
1009: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1010: p_list_rule_rec IN list_rule_rec_type,
1011: x_return_status OUT NOCOPY VARCHAR2
1012: )
1013: IS

Line 1022: IF p_validation_mode = JTF_PLSQL_API.g_create

1018:
1019: x_return_status := FND_API.g_ret_sts_success;
1020:
1021: -- check PK, if list_rule_id is passed in, must check if it is duplicate
1022: IF p_validation_mode = JTF_PLSQL_API.g_create
1023: AND p_list_rule_rec.list_rule_id IS NOT NULL
1024: THEN
1025: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1026: (