DBA Data[Home] [Help]

APPS.AMS_DM_MODEL_PVT dependencies on JTF_PLSQL_API

Line 652: p_validation_mode => JTF_PLSQL_API.g_create,

648: Validate_dm_model(
649: p_api_version_number => 1.0,
650: p_init_msg_list => FND_API.G_FALSE,
651: p_validation_level => p_validation_level,
652: p_validation_mode => JTF_PLSQL_API.g_create,
653: p_dm_model_rec => l_dm_model_rec,
654: x_return_status => x_return_status,
655: x_msg_count => x_msg_count,
656: x_msg_data => x_msg_data);

Line 1277: p_validation_mode => jtf_plsql_api.g_update,

1273: Validate_dm_model(
1274: p_api_version_number => 1.0,
1275: p_init_msg_list => FND_API.G_FALSE,
1276: p_validation_level => p_validation_level,
1277: p_validation_mode => jtf_plsql_api.g_update,
1278: p_dm_model_rec => l_tar_model_rec,
1279: x_return_status => x_return_status,
1280: x_msg_count => x_msg_count,
1281: x_msg_data => x_msg_data);

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

1708: -- Purpose : Validate Uniqueness for table ams_dm_models_all_b
1709: -----------------------------------------------------------------------
1710: PROCEDURE check_dm_model_uk_items(
1711: p_DM_MODEL_rec IN DM_MODEL_Rec_Type,
1712: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1713: x_return_status OUT NOCOPY VARCHAR2)
1714: IS
1715: l_valid_flag VARCHAR2(1);
1716:

Line 1737: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1733: END IF;
1734: x_return_status := FND_API.g_ret_sts_success;
1735:
1736: --Validate unique model_id
1737: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1738: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1739: 'ams_dm_models_all_b',
1740: 'MODEL_ID = ''' || p_dm_model_rec.model_id ||'''');
1741: ELSE

Line 1758: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1754: x_return_status := FND_API.g_ret_sts_error;
1755: END IF;
1756:
1757: --Validate unique model_name
1758: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1759: OPEN c_model_name ;
1760: FETCH c_model_name INTO l_dummy;
1761: CLOSE c_model_name ;
1762: ELSE

Line 1798: IF (p_validation_mode = jtf_plsql_api.g_update) THEN

1794:
1795: --for update API, check if NULL value, if the parameter is missing,
1796: --it is handled by table handler
1797:
1798: IF (p_validation_mode = jtf_plsql_api.g_update) THEN
1799:
1800: IF (AMS_DEBUG_HIGH_ON) THEN
1801: ams_utility_pvt.debug_message('Private API:check_dm_model_req_items for update');
1802: END IF;

Line 2104: IF p_validation_mode = JTF_PLSQL_API.G_UPDATE THEN

2100: -- If data not valid
2101: -- THEN
2102: -- x_return_status := FND_API.G_RET_STS_ERROR;
2103:
2104: IF p_validation_mode = JTF_PLSQL_API.G_UPDATE THEN
2105: l_context_resource_id := AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);
2106:
2107: OPEN c_reference(p_dm_model_rec.model_id);
2108: FETCH c_reference INTO l_reference_rec;

Line 2570: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

2566: IF FND_API.to_Boolean( p_init_msg_list )
2567: THEN
2568: FND_MSG_PUB.initialize;
2569: END IF;
2570: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2571: IF (AMS_DEBUG_HIGH_ON) THEN
2572:
2573: AMS_UTILITY_PVT.debug_message('Private API:call Check_DM_MODEL_Items');
2574: END IF;

Line 2586: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

2582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2583: END IF;
2584: END IF;
2585:
2586: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2587: Validate_dm_model_rec (
2588: p_api_version_number => 1.0,
2589: p_init_msg_list => fnd_api.g_false,
2590: p_validation_mode => p_validation_mode,