APPS.AMS_METRIC_FORMULA_PVT dependencies on JTF_PLSQL_API

Line 206: p_validation_mode => JTF_PLSQL_API.g_create,

202: Validate_metric_formula(
203: p_api_version_number => 1.0,
204: p_init_msg_list => FND_API.G_FALSE,
205: p_validation_level => p_validation_level,
206: p_validation_mode => JTF_PLSQL_API.g_create,
207: p_metric_formula_rec => l_metric_formula_rec,
208: x_return_status => x_return_status,
209: x_msg_count => x_msg_count,
210: x_msg_data => x_msg_data);

Line 472: p_validation_mode => JTF_PLSQL_API.g_update,

468: Validate_metric_formula(
469: p_api_version_number => 1.0,
470: p_init_msg_list => FND_API.G_FALSE,
471: p_validation_level => p_validation_level,
472: p_validation_mode => JTF_PLSQL_API.g_update,
473: p_metric_formula_rec => l_tar_metric_formula_rec,
474: x_return_status => x_return_status,
475: x_msg_count => x_msg_count,
476: x_msg_data => x_msg_data);

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

831:
832:
833: PROCEDURE check_metric_formula_uk_items(
834: p_metric_formula_rec IN met_formula_rec_type,
835: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
836: x_return_status OUT NOCOPY VARCHAR2)
837: IS
838: l_valid_flag VARCHAR2(1);
839: /*

Line 861: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

857: IF (AMS_DEBUG_HIGH_ON) THEN
858: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_uk_items : START');
859: END IF;
860: x_return_status := FND_API.g_ret_sts_success;
861: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
862: l_valid_flag := Ams_Utility_Pvt.check_uniqueness(
863: 'AMS_METRIC_FORMULAS',
864: 'METRIC_FORMULA_ID = ' || p_metric_formula_rec.METRIC_FORMULA_ID
865: );

Line 875: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN

871: RETURN;
872: END IF;
873: /*
874: l_dummy := 0;
875: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
876: open c_check_sequence_new(p_metric_formula_rec.metric_id,
877: p_metric_formula_rec.sequence);
878: fetch c_check_sequence_new INTO l_dummy;
879: close c_check_sequence_new;

Line 880: elsif p_validation_mode = JTF_PLSQL_API.G_UPDATE THEN

876: open c_check_sequence_new(p_metric_formula_rec.metric_id,
877: p_metric_formula_rec.sequence);
878: fetch c_check_sequence_new INTO l_dummy;
879: close c_check_sequence_new;
880: elsif p_validation_mode = JTF_PLSQL_API.G_UPDATE THEN
881: open c_check_sequence_update(p_metric_formula_rec.metric_formula_id,
882: p_metric_formula_rec.metric_id, p_metric_formula_rec.sequence);
883: fetch c_check_sequence_update INTO l_dummy;
884: close c_check_sequence_update;

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

897: END check_metric_formula_uk_items;
898:
899: PROCEDURE check_metric_formula_req_items(
900: p_metric_formula_rec IN met_formula_rec_type,
901: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
902: x_return_status OUT NOCOPY VARCHAR2
903: )
904: IS
905: BEGIN

Line 912: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

908: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_req_items : START');
909: END IF;
910: x_return_status := FND_API.g_ret_sts_success;
911:
912: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
913:
914: -- Debug Message
915: IF (AMS_DEBUG_HIGH_ON) THEN
916: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_req_items : metric_id='||p_metric_formula_rec.metric_id);

Line 1296: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1292: -- Initialize API return status to SUCCESS
1293: x_return_status := FND_API.G_RET_STS_SUCCESS;
1294:
1295:
1296: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1297: Check_metric_formula_Items(
1298: p_metric_formula_rec => p_metric_formula_rec,
1299: p_validation_mode => p_validation_mode,
1300: x_return_status => x_return_status

Line 1315: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1311: -- p_metric_formula_rec => p_metric_formula_rec,
1312: -- x_complete_rec => l_metric_formula_rec
1313: -- );
1314:
1315: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1316: Validate_metric_formula_Rec(
1317: p_api_version_number => 1.0,
1318: p_init_msg_list => FND_API.G_FALSE,
1319: x_return_status => x_return_status,