APPS.AMS_LIST_ASSOC_PVT dependencies on JTF_PLSQL_API

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

691:
692:
693: PROCEDURE check_list_assoc_uk_items(
694: p_list_assoc_rec IN list_assoc_rec_type,
695: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
696: x_return_status OUT NOCOPY VARCHAR2)
697: IS
698: l_valid_flag VARCHAR2(1);
699:

Line 702: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

698: l_valid_flag VARCHAR2(1);
699:
700: BEGIN
701: x_return_status := FND_API.g_ret_sts_success;
702: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
703: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
704: 'AMS_LIST_CONT_RESTRICTIONS',
705: 'LIST_CONTACT_RESTRICTIONs_ID = ''' || p_list_assoc_rec.LIST_CONT_RESTRICTIONs_ID ||''''
706: );

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

721: END check_list_assoc_uk_items;
722:
723: PROCEDURE check_list_assoc_req_items(
724: p_list_assoc_rec IN list_assoc_rec_type,
725: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
726: x_return_status OUT NOCOPY VARCHAR2
727: )
728: IS
729: l_media_id NUMBER;

Line 749: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

745:
746:
747: x_return_status := FND_API.g_ret_sts_success;
748:
749: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
750:
751:
752: IF p_list_assoc_rec.list_cont_restrictions_id = FND_API.g_miss_num OR p_list_assoc_rec.list_cont_restrictions_id IS NULL THEN
753: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_list_contact_restrictions_id');

Line 1085: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1081: IF FND_API.to_Boolean( p_init_msg_list )
1082: THEN
1083: FND_MSG_PUB.initialize;
1084: END IF;
1085: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1086: Check_list_assoc_Items(
1087: p_list_assoc_rec => p_list_assoc_rec,
1088: p_validation_mode => JTF_PLSQL_API.g_update,
1089: x_return_status => x_return_status

Line 1088: p_validation_mode => JTF_PLSQL_API.g_update,

1084: END IF;
1085: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1086: Check_list_assoc_Items(
1087: p_list_assoc_rec => p_list_assoc_rec,
1088: p_validation_mode => JTF_PLSQL_API.g_update,
1089: x_return_status => x_return_status
1090: );
1091:
1092: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1105: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1101: p_list_assoc_rec => p_list_assoc_rec,
1102: x_complete_rec => l_list_assoc_rec
1103: );
1104:
1105: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1106: Validate_list_assoc_Rec(
1107: p_api_version_number => 1.0,
1108: p_init_msg_list => FND_API.G_FALSE,
1109: x_return_status => x_return_status,