APPS.AMS_LIST_SRC_FIELD_PVT dependencies on JTF_PLSQL_API

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

806:
807:
808: PROCEDURE check_list_src_field_uk_items(
809: p_list_src_field_rec IN list_src_field_rec_type,
810: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
811: x_return_status OUT NOCOPY VARCHAR2)
812: IS
813: l_valid_flag VARCHAR2(1);
814:

Line 817: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

813: l_valid_flag VARCHAR2(1);
814:
815: BEGIN
816: x_return_status := FND_API.g_ret_sts_success;
817: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
818: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
819: 'AMS_LIST_SRC_FIELDS',
820: 'LIST_SOURCE_FIELD_ID = ''' || p_list_src_field_rec.LIST_SOURCE_FIELD_ID ||''''
821: );

Line 836: IF p_validation_mode = JTF_PLSQL_API.g_create

832: x_return_status := FND_API.g_ret_sts_error;
833: RETURN;
834: END IF;
835:
836: IF p_validation_mode = JTF_PLSQL_API.g_create
837: AND p_list_src_field_rec.source_column_name IS NOT NULL
838: AND p_list_src_field_rec.field_column_name IS NOT NULL
839: AND p_list_src_field_rec.field_table_name IS NOT NULL
840: AND p_list_src_field_rec.list_source_type_id IS NOT NULL

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

862: END check_list_src_field_uk_items;
863:
864: PROCEDURE check_list_src_field_req_items(
865: p_list_src_field_rec IN list_src_field_rec_type,
866: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
867: x_return_status OUT NOCOPY VARCHAR2
868: )
869: IS
870: BEGIN

Line 873: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

869: IS
870: BEGIN
871: x_return_status := FND_API.g_ret_sts_success;
872:
873: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
874:
875:
876: IF p_list_src_field_rec.list_source_field_id = FND_API.g_miss_num OR p_list_src_field_rec.list_source_field_id IS NULL THEN
877: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','LIST_SOURCE_FIELD_ID');

Line 1307: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1303: END IF;
1304:
1305:
1306:
1307: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1308: Check_list_src_field_Items(
1309: p_list_src_field_rec => p_list_src_field_rec,
1310: p_validation_mode => JTF_PLSQL_API.g_update,
1311: x_return_status => x_return_status

Line 1310: p_validation_mode => JTF_PLSQL_API.g_update,

1306:
1307: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1308: Check_list_src_field_Items(
1309: p_list_src_field_rec => p_list_src_field_rec,
1310: p_validation_mode => JTF_PLSQL_API.g_update,
1311: x_return_status => x_return_status
1312: );
1313:
1314: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1326: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1322: p_list_src_field_rec => p_list_src_field_rec,
1323: x_complete_rec => l_list_src_field_rec
1324: );
1325:
1326: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1327: Validate_list_src_field_Rec(
1328: p_api_version_number => 1.0,
1329: p_init_msg_list => FND_API.G_FALSE,
1330: x_return_status => x_return_status,