APPS.AMS_LIST_WORD_FIELDS_PVT dependencies on JTF_PLSQL_API

Line 276: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

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

Line 284: p_validation_mode => JTF_PLSQL_API.g_update,

280: END IF;
281:
282: check_items
283: (
284: p_validation_mode => JTF_PLSQL_API.g_update,
285: x_return_status => l_return_status,
286: p_wrd_fld_rec => l_wrd_fld_rec
287: );
288:

Line 709: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

705:
706: x_return_status := FND_API.g_ret_sts_success;
707:
708: ---------------------- validate ------------------------
709: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
710: IF (AMS_DEBUG_HIGH_ON) THEN
711:
712: AMS_Utility_PVT.debug_message(l_full_name||': check items');
713: END IF;

Line 716: p_validation_mode => JTF_PLSQL_API.g_create,

712: AMS_Utility_PVT.debug_message(l_full_name||': check items');
713: END IF;
714: check_items
715: (
716: p_validation_mode => JTF_PLSQL_API.g_create,
717: x_return_status => l_return_status,
718: p_wrd_fld_rec => p_wrd_fld_rec
719: );
720:

Line 877: AND p_validation_mode = JTF_PLSQL_API.g_update THEN

873: x_return_status := FND_API.g_ret_sts_success;
874:
875: -- check list_word_field_id
876: IF p_wrd_fld_rec.list_word_field_id IS NULL
877: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
878: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
879: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FIELDS_NO_ID');
880: FND_MSG_PUB.add;
881: END IF;

Line 889: AND p_validation_mode = JTF_PLSQL_API.g_update

885: END IF;
886:
887: -- check object_version_number
888: IF p_wrd_fld_rec.object_version_number IS NULL
889: AND p_validation_mode = JTF_PLSQL_API.g_update
890: THEN
891: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
892: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');
893: FND_MSG_PUB.add;

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

1048: -- 01/24/2000 julou created
1049: -------------------------------------------------------------------------------
1050: PROCEDURE check_uk_items
1051: (
1052: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1053: p_wrd_fld_rec IN wrd_fld_rec_type,
1054: x_return_status OUT NOCOPY VARCHAR2
1055: )
1056: IS

Line 1065: IF p_validation_mode = JTF_PLSQL_API.g_create

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