APPS.AMS_LIST_RULE_FIELDS_PVT dependencies on JTF_PLSQL_API

Line 294: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

290:
291: x_return_status := FND_API.g_ret_sts_success;
292:
293: -- validate
294: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
295: IF (AMS_DEBUG_HIGH_ON) THEN
296:
297: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
298: END IF;

Line 302: p_validation_mode => JTF_PLSQL_API.g_update,

298: END IF;
299:
300: check_items
301: (
302: p_validation_mode => JTF_PLSQL_API.g_update,
303: x_return_status => l_return_status,
304: p_rule_fld_rec => l_rule_fld_rec
305: );
306:

Line 757: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

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

Line 764: p_validation_mode => JTF_PLSQL_API.g_create,

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

Line 925: AND p_validation_mode = JTF_PLSQL_API.g_update THEN

921: x_return_status := FND_API.g_ret_sts_success;
922:
923: -- check list_rule_field_id
924: IF p_rule_fld_rec.list_rule_field_id IS NULL
925: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
926: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
927: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_ID');
928: FND_MSG_PUB.add;
929: END IF;

Line 937: AND p_validation_mode = JTF_PLSQL_API.g_update

933: END IF;
934:
935: -- check object_version_number
936: IF p_rule_fld_rec.object_version_number IS NULL
937: AND p_validation_mode = JTF_PLSQL_API.g_update
938: THEN
939: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
940: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');
941: FND_MSG_PUB.add;

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

1050: -- 01/24/2000 julou created
1051: -------------------------------------------------------------------------------
1052: PROCEDURE check_uk_items
1053: (
1054: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1055: p_rule_fld_rec IN rule_fld_rec_type,
1056: x_return_status OUT NOCOPY VARCHAR2
1057: )
1058: IS

Line 1067: IF p_validation_mode = JTF_PLSQL_API.g_create

1063:
1064: x_return_status := FND_API.g_ret_sts_success;
1065:
1066: -- check PK, if list_rule_field_id is passed in, must check if it is duplicate
1067: IF p_validation_mode = JTF_PLSQL_API.g_create
1068: AND p_rule_fld_rec.list_rule_field_id IS NOT NULL
1069: THEN
1070: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1071: (