APPS.AMS_MET_TPL_ASSOC_PVT dependencies on JTF_PLSQL_API

Line 146: p_validation_mode => JTF_PLSQL_API.g_create,

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

Line 394: p_validation_mode => JTF_PLSQL_API.g_update,

390: Validate_met_tpl_assoc(
391: p_api_version_number => 1.0,
392: p_init_msg_list => FND_API.G_FALSE,
393: p_validation_level => p_validation_level,
394: p_validation_mode => JTF_PLSQL_API.g_update,
395: p_met_tpl_assoc_rec => p_met_tpl_assoc_rec,
396: x_return_status => x_return_status,
397: x_msg_count => x_msg_count,
398: x_msg_data => x_msg_data);

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

751:
752:
753: PROCEDURE check_met_tpl_assoc_uk_items(
754: p_met_tpl_assoc_rec IN met_tpl_assoc_rec_type,
755: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
756: x_return_status OUT NOCOPY VARCHAR2)
757: IS
758: l_valid_flag VARCHAR2(1);
759: CURSOR c_dup_assoc (p_met_tpl_hdr_id NUMBER, p_assoc_type VARCHAR2,

Line 770: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

766: AND NVL(p_used_by_code, '0') = NVL(used_by_code, '0');
767:
768: BEGIN
769: x_return_status := FND_API.g_ret_sts_success;
770: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
771: l_valid_flag := Ams_Utility_Pvt.check_uniqueness(
772: 'AMS_MET_TPL_ASSOCS',
773: 'METRIC_TPL_ASSOC_ID = ' || p_met_tpl_assoc_rec.METRIC_TPL_ASSOC_ID
774: );

Line 789: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

785: x_return_status := FND_API.g_ret_sts_error;
786: RETURN;
787: END IF;
788:
789: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
790: OPEN c_dup_assoc(p_met_tpl_assoc_rec.METRIC_TPL_HEADER_ID,
791: p_met_tpl_assoc_rec.ASSOCIATION_TYPE,
792: p_met_tpl_assoc_rec.used_by_id,
793: p_met_tpl_assoc_rec.used_by_code);

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

804: END check_met_tpl_assoc_uk_items;
805:
806: PROCEDURE check_met_tpl_assoc_req_items(
807: p_met_tpl_assoc_rec IN met_tpl_assoc_rec_type,
808: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
809: x_return_status OUT NOCOPY VARCHAR2
810: )
811: IS
812: BEGIN

Line 815: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

811: IS
812: BEGIN
813: x_return_status := FND_API.g_ret_sts_success;
814:
815: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
816:
817: -- IF p_met_tpl_assoc_rec.metric_tpl_assoc_id = FND_API.g_miss_num OR
818: -- p_met_tpl_assoc_rec.metric_tpl_assoc_id IS NULL THEN
819: -- FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');

Line 1177: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1173: IF FND_API.to_Boolean( p_init_msg_list )
1174: THEN
1175: FND_MSG_PUB.initialize;
1176: END IF;
1177: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1178: Check_met_tpl_assoc_Items(
1179: p_met_tpl_assoc_rec => p_met_tpl_assoc_rec,
1180: p_validation_mode => p_validation_mode,
1181: x_return_status => x_return_status

Line 1196: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1192: -- p_met_tpl_assoc_rec => p_met_tpl_assoc_rec,
1193: -- x_complete_rec => l_met_tpl_assoc_rec
1194: -- );
1195:
1196: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1197: Validate_met_tpl_assoc_Rec(
1198: p_api_version_number => 1.0,
1199: p_init_msg_list => FND_API.G_FALSE,
1200: x_return_status => x_return_status,