APPS.AMS_MET_TPL_DTL_PVT dependencies on JTF_PLSQL_API

Line 147: p_validation_mode => JTF_PLSQL_API.g_create,

143: Validate_met_tpl_dtl(
144: p_api_version_number => 1.0,
145: p_init_msg_list => FND_API.G_FALSE,
146: p_validation_level => p_validation_level,
147: p_validation_mode => JTF_PLSQL_API.g_create,
148: p_met_tpl_dtl_rec => l_met_tpl_dtl_rec,
149: x_return_status => x_return_status,
150: x_msg_count => x_msg_count,
151: x_msg_data => x_msg_data);

Line 390: p_validation_mode => JTF_PLSQL_API.g_update,

386: Validate_met_tpl_dtl(
387: p_api_version_number => 1.0,
388: p_init_msg_list => FND_API.G_FALSE,
389: p_validation_level => p_validation_level,
390: p_validation_mode => JTF_PLSQL_API.g_update,
391: p_met_tpl_dtl_rec => l_tar_met_tpl_dtl_rec,
392: x_return_status => x_return_status,
393: x_msg_count => x_msg_count,
394: x_msg_data => x_msg_data);

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

750:
751:
752: PROCEDURE check_met_tpl_dtl_uk_items(
753: p_met_tpl_dtl_rec IN met_tpl_dtl_rec_type,
754: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
755: x_return_status OUT NOCOPY VARCHAR2)
756: IS
757: l_valid_flag VARCHAR2(1);
758: l_dummy NUMBER;

Line 767: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

763: AND METRIC_ID = p_METRIC_ID;
764:
765: BEGIN
766: x_return_status := FND_API.g_ret_sts_success;
767: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
768: l_valid_flag := Ams_Utility_Pvt.check_uniqueness(
769: 'AMS_MET_TPL_DETAILS',
770: 'METRIC_TEMPLATE_DETAIL_ID = ' || p_met_tpl_dtl_rec.METRIC_TEMPLATE_DETAIL_ID
771: );

Line 780: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

776: x_return_status := FND_API.g_ret_sts_error;
777: RETURN;
778: END IF;
779:
780: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
781: OPEN c_check_duplicate(p_met_tpl_dtl_rec.metric_id, p_met_tpl_dtl_rec.metric_tpl_header_id);
782: FETCH c_check_duplicate INTO l_dummy;
783: IF c_check_duplicate%FOUND THEN
784: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTD_DUP_METRIC_ID');

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

790: END check_met_tpl_dtl_uk_items;
791:
792: PROCEDURE check_met_tpl_dtl_req_items(
793: p_met_tpl_dtl_rec IN met_tpl_dtl_rec_type,
794: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
795: x_return_status OUT NOCOPY VARCHAR2
796: )
797: IS
798: BEGIN

Line 801: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

797: IS
798: BEGIN
799: x_return_status := FND_API.g_ret_sts_success;
800:
801: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
802:
803: IF p_met_tpl_dtl_rec.metric_template_detail_id = FND_API.g_miss_num OR p_met_tpl_dtl_rec.metric_template_detail_id IS NULL THEN
804: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
805: FND_MESSAGE.set_token('MISS_FIELD','METRIC_TEMPLATE_DETAIL_ID');

Line 1075: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1071: IF FND_API.to_Boolean( p_init_msg_list )
1072: THEN
1073: FND_MSG_PUB.initialize;
1074: END IF;
1075: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1076: Check_met_tpl_dtl_Items(
1077: p_met_tpl_dtl_rec => p_met_tpl_dtl_rec,
1078: p_validation_mode => p_validation_mode,
1079: x_return_status => x_return_status

Line 1094: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1090: -- p_met_tpl_dtl_rec => p_met_tpl_dtl_rec,
1091: -- x_complete_rec => l_met_tpl_dtl_rec
1092: -- );
1093:
1094: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1095: Validate_met_tpl_dtl_Rec(
1096: p_api_version_number => 1.0,
1097: p_init_msg_list => FND_API.G_FALSE,
1098: x_return_status => x_return_status,