DBA Data[Home] [Help]

APPS.AMS_CTD_PVT dependencies on JTF_PLSQL_API

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

1029:
1030:
1031: PROCEDURE check_ctd_uk_items(
1032: p_ctd_rec IN ctd_rec_type,
1033: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1034: x_return_status OUT NOCOPY VARCHAR2)
1035: IS
1036: l_valid_flag VARCHAR2(1);
1037:

Line 1040: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1036: l_valid_flag VARCHAR2(1);
1037:
1038: BEGIN
1039: x_return_status := FND_API.g_ret_sts_success;
1040: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1041: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1042: 'AMS_CTDS',
1043: 'CTD_ID = ''' || p_ctd_rec.CTD_ID ||''''
1044: );

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

1059: END check_ctd_uk_items;
1060:
1061: PROCEDURE check_ctd_req_items(
1062: p_ctd_rec IN ctd_rec_type,
1063: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1064: x_return_status OUT NOCOPY VARCHAR2
1065: )
1066: IS
1067: BEGIN

Line 1070: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1066: IS
1067: BEGIN
1068: x_return_status := FND_API.g_ret_sts_success;
1069:
1070: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1071:
1072:
1073: IF p_ctd_rec.ctd_id = FND_API.g_miss_num OR p_ctd_rec.ctd_id IS NULL THEN
1074: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_ctd_id');

Line 1364: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1360: IF FND_API.to_Boolean( p_init_msg_list )
1361: THEN
1362: FND_MSG_PUB.initialize;
1363: END IF;
1364: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1365: Check_ctd_Items(
1366: p_ctd_rec => p_ctd_rec,
1367: p_validation_mode => JTF_PLSQL_API.g_update,
1368: x_return_status => x_return_status

Line 1367: p_validation_mode => JTF_PLSQL_API.g_update,

1363: END IF;
1364: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1365: Check_ctd_Items(
1366: p_ctd_rec => p_ctd_rec,
1367: p_validation_mode => JTF_PLSQL_API.g_update,
1368: x_return_status => x_return_status
1369: );
1370:
1371: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1383: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1379: p_ctd_rec => p_ctd_rec,
1380: x_complete_rec => l_ctd_rec
1381: );
1382:
1383: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1384: Validate_ctd_Rec(
1385: p_api_version_number => 1.0,
1386: p_init_msg_list => FND_API.G_FALSE,
1387: x_return_status => x_return_status,