APPS.AMS_LIST_WORD_REPLACES_PVT dependencies on JTF_PLSQL_API

Line 271: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

267:
268: x_return_status := FND_API.g_ret_sts_success;
269:
270: -- validate
271: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
272: IF (AMS_DEBUG_HIGH_ON) THEN
273:
274: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
275: END IF;

Line 279: p_validation_mode => JTF_PLSQL_API.g_update,

275: END IF;
276:
277: check_items
278: (
279: p_validation_mode => JTF_PLSQL_API.g_update,
280: x_return_status => l_return_status,
281: p_wrd_rpl_rec => l_wrd_rpl_rec
282: );
283:

Line 734: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

730:
731: x_return_status := FND_API.g_ret_sts_success;
732:
733: ---------------------- validate ------------------------
734: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
735: IF (AMS_DEBUG_HIGH_ON) THEN
736:
737: AMS_Utility_PVT.debug_message(l_full_name||': check items');
738: END IF;

Line 741: p_validation_mode => JTF_PLSQL_API.g_create,

737: AMS_Utility_PVT.debug_message(l_full_name||': check items');
738: END IF;
739: check_items
740: (
741: p_validation_mode => JTF_PLSQL_API.g_create,
742: x_return_status => l_return_status,
743: p_wrd_rpl_rec => p_wrd_rpl_rec
744: );
745:

Line 887: AND p_validation_mode = JTF_PLSQL_API.g_update THEN

883: x_return_status := FND_API.g_ret_sts_success;
884:
885: -- check list_word_replaces_id
886: IF p_wrd_rpl_rec.list_word_replaces_id IS NULL
887: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
888: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
889: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_REPLACES_NO_ID');
890: FND_MSG_PUB.add;
891: END IF;

Line 899: AND p_validation_mode = JTF_PLSQL_API.g_update

895: END IF;
896:
897: -- check object_version_number
898: IF p_wrd_rpl_rec.object_version_number IS NULL
899: AND p_validation_mode = JTF_PLSQL_API.g_update
900: THEN
901: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
902: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');
903: FND_MSG_PUB.add;

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

962: -- 01/24/2000 julou created
963: -------------------------------------------------------------------------------
964: PROCEDURE check_uk_items
965: (
966: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
967: p_wrd_rpl_rec IN wrd_rpl_rec_type,
968: x_return_status OUT NOCOPY VARCHAR2
969: )
970: IS

Line 979: IF p_validation_mode = JTF_PLSQL_API.g_create

975:
976: x_return_status := FND_API.g_ret_sts_success;
977:
978: -- check PK, if list_word_replaces_id is passed in, must check if it is duplicate
979: IF p_validation_mode = JTF_PLSQL_API.g_create
980: AND p_wrd_rpl_rec.list_word_replaces_id IS NOT NULL
981: THEN
982: l_uk_flag := AMS_Utility_PVT.check_uniqueness
983: (