APPS.AMS_DM_SCORE_PVT dependencies on JTF_PLSQL_API

Line 563: p_validation_mode => JTF_PLSQL_API.g_create,

559: p_api_version => 1.0,
560: p_init_msg_list => FND_API.G_FALSE,
561: p_validation_level => p_validation_level,
562: P_Score_Rec => l_score_rec,
563: p_validation_mode => JTF_PLSQL_API.g_create,
564: x_return_status => x_return_status,
565: x_msg_count => x_msg_count,
566: x_msg_data => x_msg_data
567: );

Line 1216: p_validation_mode => JTF_PLSQL_API.g_update,

1212: Validate_Score (
1213: p_api_version => 1.0,
1214: p_init_msg_list => FND_API.G_FALSE,
1215: p_validation_level => p_validation_level,
1216: p_validation_mode => JTF_PLSQL_API.g_update,
1217: p_score_rec => l_tar_score_rec,
1218: x_return_status => x_return_status,
1219: x_msg_count => x_msg_count,
1220: x_msg_data => x_msg_data

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

1531:
1532:
1533: PROCEDURE check_score_uk_items(
1534: p_score_rec IN Score_Rec_Type,
1535: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1536: x_return_status OUT NOCOPY VARCHAR2)
1537: IS
1538:
1539: l_valid_flag VARCHAR2(1);

Line 1562: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1558: AMS_UTILITY_PVT.debug_message('Private API:check_Score_uk_items');
1559: END IF;
1560:
1561: x_return_status := FND_API.g_ret_sts_success;
1562: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1563: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1564: 'AMS_DM_SCORES_ALL_B',
1565: 'SCORE_ID = ''' || p_score_rec.score_id ||''''
1566: );

Line 1586: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1582: RETURN;
1583: END IF;
1584:
1585: --Validate unique score_name
1586: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1587: OPEN c_score_name ;
1588: FETCH c_score_name INTO l_dummy;
1589: CLOSE c_score_name ;
1590: ELSE

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

1606:
1607:
1608: PROCEDURE check_Score_req_items(
1609: p_score_rec IN Score_Rec_Type,
1610: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1611: x_return_status OUT NOCOPY VARCHAR2
1612: )
1613: IS
1614: BEGIN

Line 1625: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1621:
1622: AMS_UTILITY_PVT.debug_message('Private API:mode ' || p_validation_mode);
1623: END IF;
1624:
1625: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1626: IF (AMS_DEBUG_HIGH_ON) THEN
1627:
1628: AMS_UTILITY_PVT.debug_message('Private API: id ' || p_score_rec.score_id);
1629: END IF;

Line 2147: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

2143: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2144: FND_MSG_PUB.initialize;
2145: END IF;
2146:
2147: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2148: Check_Score_Items(
2149: p_score_rec => p_score_rec,
2150: p_validation_mode => p_validation_mode,
2151: x_return_status => x_return_status

Line 2160: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

2156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2157: END IF;
2158: END IF;
2159:
2160: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
2161: Validate_Score_Rec(
2162: p_api_version => 1.0,
2163: p_init_msg_list => FND_API.G_FALSE,
2164: p_validation_mode => p_validation_mode,

Line 2272: IF p_validation_mode = JTF_PLSQL_API.g_update THEN

2268:
2269: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
2270: END IF;
2271:
2272: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
2273: l_context_resource_id := AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);
2274:
2275: OPEN c_reference(p_score_rec.score_id);
2276: FETCH c_reference INTO l_reference_rec;