APPS.AMS_METRIC_TEMPLATE_PVT dependencies on JTF_PLSQL_API

Line 138: p_validation_mode => JTF_PLSQL_API.g_create,

134: Validate_metric_template(
135: p_api_version_number => 1.0,
136: p_init_msg_list => FND_API.G_FALSE,
137: p_validation_level => p_validation_level,
138: p_validation_mode => JTF_PLSQL_API.g_create,
139: p_metric_tpl_header_rec => l_metric_tpl_header_rec,
140: x_return_status => x_return_status,
141: x_msg_count => x_msg_count,
142: x_msg_data => x_msg_data);

Line 402: p_validation_mode => JTF_PLSQL_API.g_update,

398: Validate_metric_template(
399: p_api_version_number => 1.0,
400: p_init_msg_list => FND_API.G_FALSE,
401: p_validation_level => p_validation_level,
402: p_validation_mode => JTF_PLSQL_API.g_update,
403: p_metric_tpl_header_rec => l_tar_metric_tpl_header_rec,
404: x_return_status => x_return_status,
405: x_msg_count => x_msg_count,
406: x_msg_data => x_msg_data);

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

785:
786:
787: PROCEDURE CHECK_met_tpl_hdr_UK_ITEMS(
788: p_metric_tpl_header_rec IN metric_tpl_header_rec_type,
789: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
790: x_return_status OUT NOCOPY VARCHAR2)
791: IS
792: l_valid_flag VARCHAR2(1) := FND_API.g_false;
793:

Line 831: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

827: || '/' || p_metric_tpl_header_rec.metric_tpl_header_id);
828: END IF;
829:
830: -- Validate the PK ID is unique.
831: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
832: l_valid_flag := Ams_Utility_Pvt.check_uniqueness(
833: 'AMS_MET_TPL_HEADERS_VL',
834: 'METRIC_TPL_HEADER_ID = ' || p_metric_tpl_header_rec.METRIC_TPL_HEADER_ID
835: );

Line 856: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

852: /* CREATING template WITH THE WORD "AND" RATHER THAN "&" CREATES ERROR */
853:
854: l_valid_flag := FND_API.G_TRUE;
855:
856: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
857:
858: OPEN c_check_header_name(p_metric_tpl_header_rec.Metric_Tpl_header_name);
859: FETCH c_check_header_name INTO l_count;
860: CLOSE c_check_header_name;

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

885: END check_met_tpl_hdr_uk_items;
886:
887: PROCEDURE CHECK_met_tpl_hdr_REQ_ITEMS(
888: p_metric_tpl_header_rec IN metric_tpl_header_rec_type,
889: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
890: x_return_status OUT NOCOPY VARCHAR2
891: )
892: IS
893: BEGIN

Line 896: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

892: IS
893: BEGIN
894: x_return_status := FND_API.g_ret_sts_success;
895:
896: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
897:
898: IF p_metric_tpl_header_rec.metric_tpl_header_id IS NULL OR
899: p_metric_tpl_header_rec.metric_tpl_header_id = FND_API.g_miss_num THEN
900: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');

Line 1324: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1320: THEN
1321: FND_MSG_PUB.initialize;
1322: END IF;
1323:
1324: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1325: -- Debug Message
1326: IF AMS_DEBUG_HIGH_ON THEN
1327: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': Checking header items');
1328: END IF;

Line 1343: IF p_validation_mode = JTF_PLSQL_API.g_update THEN

1339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1340: END IF;
1341: END IF;
1342:
1343: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
1344:
1345: -- Debug Message
1346: IF AMS_DEBUG_HIGH_ON THEN
1347: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': UPDATE MODE');

Line 1350: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1346: IF AMS_DEBUG_HIGH_ON THEN
1347: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': UPDATE MODE');
1348: END IF;
1349:
1350: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1351: Validate_met_tpl_hdr_Rec(
1352: p_api_version_number => 1.0,
1353: p_init_msg_list => FND_API.G_FALSE,
1354: x_return_status => x_return_status,