APPS.AMS_SETUP_ATTR_PVT dependencies on JTF_PLSQL_API

Line 79: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

75:
76: x_return_status := FND_API.g_ret_sts_success;
77:
78: -- validate
79: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
80: IF (AMS_DEBUG_HIGH_ON) THEN
81:
82: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
83: END IF;

Line 296: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

292: l_setup_attr_rec
293: );
294:
295: -- validate
296: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
297: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': validate'); END IF;
298:
299: check_items
300: (

Line 301: p_validation_mode => JTF_PLSQL_API.g_update,

297: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': validate'); END IF;
298:
299: check_items
300: (
301: p_validation_mode => JTF_PLSQL_API.g_update,
302: x_return_status => l_return_status,
303: p_setup_attr_rec => l_setup_attr_rec
304: );
305:

Line 454: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

450:
451: x_return_status := FND_API.g_ret_sts_success;
452:
453: ---------------------- validate ------------------------
454: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
455: IF (AMS_DEBUG_HIGH_ON) THEN
456:
457: AMS_Utility_PVT.debug_message(l_full_name||': check items');
458: END IF;

Line 461: p_validation_mode => JTF_PLSQL_API.g_create,

457: AMS_Utility_PVT.debug_message(l_full_name||': check items');
458: END IF;
459: check_items
460: (
461: p_validation_mode => JTF_PLSQL_API.g_create,
462: x_return_status => l_return_status,
463: p_setup_attr_rec => p_setup_attr_rec
464: );
465:

Line 620: AND p_validation_mode = JTF_PLSQL_API.g_update THEN

616: x_return_status := FND_API.g_ret_sts_success;
617:
618: -- check setup_attribute_id
619: IF p_setup_attr_rec.setup_attribute_id IS NULL
620: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
621: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
622: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_SETUP_ATT_ID');
623: FND_MSG_PUB.add;
624: END IF;

Line 632: AND p_validation_mode = JTF_PLSQL_API.g_update

628: END IF;
629:
630: -- check object_version_number
631: IF p_setup_attr_rec.object_version_number IS NULL
632: AND p_validation_mode = JTF_PLSQL_API.g_update
633: THEN
634: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
635: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_OBJ_VER_NUM');
636: FND_MSG_PUB.add;

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

718: -- 11/29/1999 julou created
719: -------------------------------------------------------------------------------
720: PROCEDURE check_setup_attr_uk_items
721: (
722: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
723: p_setup_attr_rec IN setup_attr_rec_type,
724: x_return_status OUT NOCOPY VARCHAR2
725: )
726: IS

Line 748: IF p_validation_mode = JTF_PLSQL_API.g_create

744: -- check PK, if custom_setup_id is passed in, must check if it is duplicate
745:
746: /***
747:
748: IF p_validation_mode = JTF_PLSQL_API.g_create
749: AND p_setup_attr_rec.setup_attribute_id IS NOT NULL
750: THEN
751: l_uk_flag := AMS_Utility_PVT.check_uniqueness
752: (

Line 770: IF p_validation_mode = Jtf_Plsql_Api.g_create

766: RETURN;
767: END IF;
768: *****/
769:
770: IF p_validation_mode = Jtf_Plsql_Api.g_create
771: THEN
772: OPEN c_ess_seq_exists (p_setup_attr_rec.essential_seq_num,
773: p_setup_attr_rec.custom_setup_id,
774: p_setup_attr_rec.setup_attribute_id);