APPS.AMS_CTD_PRM_VAL_PVT dependencies on JTF_PLSQL_API

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

624:
625:
626: PROCEDURE check_ctd_prm_val_uk_items(
627: p_ctd_prm_val_rec IN ctd_prm_val_rec_type,
628: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
629: x_return_status OUT NOCOPY VARCHAR2)
630: IS
631: l_valid_flag VARCHAR2(1);
632:

Line 635: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

631: l_valid_flag VARCHAR2(1);
632:
633: BEGIN
634: x_return_status := FND_API.g_ret_sts_success;
635: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
636: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
637: 'AMS_CTD_PARAM_VALUES',
638: 'ACTION_PARAM_VALUE_ID = ''' || p_ctd_prm_val_rec.ACTION_PARAM_VALUE_ID ||''''
639: );

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

654: END check_ctd_prm_val_uk_items;
655:
656: PROCEDURE check_ctd_prm_val_req_items(
657: p_ctd_prm_val_rec IN ctd_prm_val_rec_type,
658: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
659: x_return_status OUT NOCOPY VARCHAR2
660: )
661: IS
662: BEGIN

Line 665: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

661: IS
662: BEGIN
663: x_return_status := FND_API.g_ret_sts_success;
664:
665: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
666:
667:
668: IF p_ctd_prm_val_rec.action_param_value_id = FND_API.g_miss_num OR p_ctd_prm_val_rec.action_param_value_id IS NULL THEN
669: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_prm_val_NO_action_param_value_id');

Line 977: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

973: IF FND_API.to_Boolean( p_init_msg_list )
974: THEN
975: FND_MSG_PUB.initialize;
976: END IF;
977: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
978: Check_ctd_prm_val_Items(
979: p_ctd_prm_val_rec => p_ctd_prm_val_rec,
980: p_validation_mode => JTF_PLSQL_API.g_update,
981: x_return_status => x_return_status

Line 980: p_validation_mode => JTF_PLSQL_API.g_update,

976: END IF;
977: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
978: Check_ctd_prm_val_Items(
979: p_ctd_prm_val_rec => p_ctd_prm_val_rec,
980: p_validation_mode => JTF_PLSQL_API.g_update,
981: x_return_status => x_return_status
982: );
983:
984: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 996: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

992: p_ctd_prm_val_rec => p_ctd_prm_val_rec,
993: x_complete_rec => l_ctd_prm_val_rec
994: );
995:
996: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
997: Validate_ctd_prm_val_Rec(
998: p_api_version_number => 1.0,
999: p_init_msg_list => FND_API.G_FALSE,
1000: x_return_status => x_return_status,