APPS.AMS_LIST_SRC_FIELD_PVT dependencies on JTF_PLSQL_API

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

837:
838:
839: PROCEDURE check_list_src_field_uk_items(
840: p_list_src_field_rec IN list_src_field_rec_type,
841: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
842: x_return_status OUT NOCOPY VARCHAR2)
843: IS
844: l_valid_flag VARCHAR2(1);
845:

Line 848: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

844: l_valid_flag VARCHAR2(1);
845:
846: BEGIN
847: x_return_status := FND_API.g_ret_sts_success;
848: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
849: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
850: 'AMS_LIST_SRC_FIELDS',
851: 'LIST_SOURCE_FIELD_ID = ''' || p_list_src_field_rec.LIST_SOURCE_FIELD_ID ||''''
852: );

Line 867: IF p_validation_mode = JTF_PLSQL_API.g_create

863: x_return_status := FND_API.g_ret_sts_error;
864: RETURN;
865: END IF;
866:
867: IF p_validation_mode = JTF_PLSQL_API.g_create
868: AND p_list_src_field_rec.source_column_name IS NOT NULL
869: AND p_list_src_field_rec.field_column_name IS NOT NULL
870: AND p_list_src_field_rec.field_table_name IS NOT NULL
871: AND p_list_src_field_rec.list_source_type_id IS NOT NULL

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

893: END check_list_src_field_uk_items;
894:
895: PROCEDURE check_list_src_field_req_items(
896: p_list_src_field_rec IN list_src_field_rec_type,
897: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
898: x_return_status OUT NOCOPY VARCHAR2
899: )
900: IS
901: BEGIN

Line 904: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

900: IS
901: BEGIN
902: x_return_status := FND_API.g_ret_sts_success;
903:
904: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
905:
906:
907: 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
908: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','LIST_SOURCE_FIELD_ID');

Line 1338: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1334: END IF;
1335:
1336:
1337:
1338: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1339: Check_list_src_field_Items(
1340: p_list_src_field_rec => p_list_src_field_rec,
1341: p_validation_mode => JTF_PLSQL_API.g_update,
1342: x_return_status => x_return_status

Line 1341: p_validation_mode => JTF_PLSQL_API.g_update,

1337:
1338: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1339: Check_list_src_field_Items(
1340: p_list_src_field_rec => p_list_src_field_rec,
1341: p_validation_mode => JTF_PLSQL_API.g_update,
1342: x_return_status => x_return_status
1343: );
1344:
1345: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1357: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1353: p_list_src_field_rec => p_list_src_field_rec,
1354: x_complete_rec => l_list_src_field_rec
1355: );
1356:
1357: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1358: Validate_list_src_field_Rec(
1359: p_api_version_number => 1.0,
1360: p_init_msg_list => FND_API.G_FALSE,
1361: x_return_status => x_return_status,