APPS.AMS_ADHOC_PARAM_PVT dependencies on JTF_PLSQL_API

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

624:
625:
626: PROCEDURE check_adhoc_param_uk_items(
627: p_adhoc_param_rec IN adhoc_param_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_ADHOC_PARAM_VALUES',
638: 'ADHOC_PARAM_ID = ''' || p_adhoc_param_rec.ADHOC_PARAM_ID ||''''
639: );

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

654: END check_adhoc_param_uk_items;
655:
656: PROCEDURE check_adhoc_param_req_items(
657: p_adhoc_param_rec IN adhoc_param_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_adhoc_param_rec.adhoc_param_id = FND_API.g_miss_num OR p_adhoc_param_rec.adhoc_param_id IS NULL THEN
669: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_adhoc_param_id');

Line 962: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

958: IF FND_API.to_Boolean( p_init_msg_list )
959: THEN
960: FND_MSG_PUB.initialize;
961: END IF;
962: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
963: Check_adhoc_param_Items(
964: p_adhoc_param_rec => p_adhoc_param_rec,
965: p_validation_mode => JTF_PLSQL_API.g_update,
966: x_return_status => x_return_status

Line 965: p_validation_mode => JTF_PLSQL_API.g_update,

961: END IF;
962: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
963: Check_adhoc_param_Items(
964: p_adhoc_param_rec => p_adhoc_param_rec,
965: p_validation_mode => JTF_PLSQL_API.g_update,
966: x_return_status => x_return_status
967: );
968:
969: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 981: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

977: p_adhoc_param_rec => p_adhoc_param_rec,
978: x_complete_rec => l_adhoc_param_rec
979: );
980:
981: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
982: Validate_adhoc_param_Rec(
983: p_api_version_number => 1.0,
984: p_init_msg_list => FND_API.G_FALSE,
985: x_return_status => x_return_status,