690:
691: IF (c_Met_Tpl_Assoc%NOTFOUND) THEN
692: CLOSE c_Met_Tpl_Assoc;
693: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
694: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
695: FND_MSG_PUB.ADD;
696: END IF;
697: RAISE FND_API.g_exc_error;
698: END IF;
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');
820: -- FND_MESSAGE.set_token('MISS_FIELD','METRIC_TPL_ASSOC_ID');
821: -- x_return_status := FND_API.g_ret_sts_error;
822: -- RETURN;
823: -- END IF;
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');
820: -- FND_MESSAGE.set_token('MISS_FIELD','METRIC_TPL_ASSOC_ID');
821: -- x_return_status := FND_API.g_ret_sts_error;
822: -- RETURN;
823: -- END IF;
824: --
822: -- RETURN;
823: -- END IF;
824: --
825: -- IF p_met_tpl_assoc_rec.last_update_date = FND_API.g_miss_date OR p_met_tpl_assoc_rec.last_update_date IS NULL THEN
826: -- FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
827: -- FND_MESSAGE.set_token('MISS_FIELD','LAST_UPDATE_DATE');
828: -- x_return_status := FND_API.g_ret_sts_error;
829: -- RETURN;
830: -- END IF;
823: -- END IF;
824: --
825: -- IF p_met_tpl_assoc_rec.last_update_date = FND_API.g_miss_date OR p_met_tpl_assoc_rec.last_update_date IS NULL THEN
826: -- FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
827: -- FND_MESSAGE.set_token('MISS_FIELD','LAST_UPDATE_DATE');
828: -- x_return_status := FND_API.g_ret_sts_error;
829: -- RETURN;
830: -- END IF;
831: --
829: -- RETURN;
830: -- END IF;
831: --
832: -- IF p_met_tpl_assoc_rec.last_updated_by = FND_API.g_miss_num OR p_met_tpl_assoc_rec.last_updated_by IS NULL THEN
833: -- FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
834: -- FND_MESSAGE.set_token('MISS_FIELD','LAST_UPDATED_BY');
835: -- x_return_status := FND_API.g_ret_sts_error;
836: -- RETURN;
837: -- END IF;
830: -- END IF;
831: --
832: -- IF p_met_tpl_assoc_rec.last_updated_by = FND_API.g_miss_num OR p_met_tpl_assoc_rec.last_updated_by IS NULL THEN
833: -- FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
834: -- FND_MESSAGE.set_token('MISS_FIELD','LAST_UPDATED_BY');
835: -- x_return_status := FND_API.g_ret_sts_error;
836: -- RETURN;
837: -- END IF;
838: --
836: -- RETURN;
837: -- END IF;
838: --
839: -- IF p_met_tpl_assoc_rec.creation_date = FND_API.g_miss_date OR p_met_tpl_assoc_rec.creation_date IS NULL THEN
840: -- FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
841: -- FND_MESSAGE.set_token('MISS_FIELD','CREATION_DATE');
842: -- x_return_status := FND_API.g_ret_sts_error;
843: -- RETURN;
844: -- END IF;
837: -- END IF;
838: --
839: -- IF p_met_tpl_assoc_rec.creation_date = FND_API.g_miss_date OR p_met_tpl_assoc_rec.creation_date IS NULL THEN
840: -- FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
841: -- FND_MESSAGE.set_token('MISS_FIELD','CREATION_DATE');
842: -- x_return_status := FND_API.g_ret_sts_error;
843: -- RETURN;
844: -- END IF;
845: --
843: -- RETURN;
844: -- END IF;
845: --
846: -- IF p_met_tpl_assoc_rec.created_by = FND_API.g_miss_num OR p_met_tpl_assoc_rec.created_by IS NULL THEN
847: -- FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
848: -- FND_MESSAGE.set_token('MISS_FIELD','CREATED_BY');
849: -- x_return_status := FND_API.g_ret_sts_error;
850: -- RETURN;
851: -- END IF;
844: -- END IF;
845: --
846: -- IF p_met_tpl_assoc_rec.created_by = FND_API.g_miss_num OR p_met_tpl_assoc_rec.created_by IS NULL THEN
847: -- FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
848: -- FND_MESSAGE.set_token('MISS_FIELD','CREATED_BY');
849: -- x_return_status := FND_API.g_ret_sts_error;
850: -- RETURN;
851: -- END IF;
852: --
850: -- RETURN;
851: -- END IF;
852: --
853: IF p_met_tpl_assoc_rec.metric_tpl_header_id = FND_API.g_miss_num OR p_met_tpl_assoc_rec.metric_tpl_header_id IS NULL THEN
854: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
855: FND_MESSAGE.set_token('MISS_FIELD','METRIC_TPL_HEADER_ID');
856: x_return_status := FND_API.g_ret_sts_error;
857: RETURN;
858: END IF;
851: -- END IF;
852: --
853: IF p_met_tpl_assoc_rec.metric_tpl_header_id = FND_API.g_miss_num OR p_met_tpl_assoc_rec.metric_tpl_header_id IS NULL THEN
854: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
855: FND_MESSAGE.set_token('MISS_FIELD','METRIC_TPL_HEADER_ID');
856: x_return_status := FND_API.g_ret_sts_error;
857: RETURN;
858: END IF;
859:
857: RETURN;
858: END IF;
859:
860: IF p_met_tpl_assoc_rec.association_type = FND_API.g_miss_char OR p_met_tpl_assoc_rec.association_type IS NULL THEN
861: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
862: FND_MESSAGE.set_token('MISS_FIELD','ASSOCIATION_TYPE');
863: x_return_status := FND_API.g_ret_sts_error;
864: RETURN;
865: END IF;
858: END IF;
859:
860: IF p_met_tpl_assoc_rec.association_type = FND_API.g_miss_char OR p_met_tpl_assoc_rec.association_type IS NULL THEN
861: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
862: FND_MESSAGE.set_token('MISS_FIELD','ASSOCIATION_TYPE');
863: x_return_status := FND_API.g_ret_sts_error;
864: RETURN;
865: END IF;
866:
864: RETURN;
865: END IF;
866:
867: IF p_met_tpl_assoc_rec.enabled_flag = FND_API.g_miss_char OR p_met_tpl_assoc_rec.enabled_flag IS NULL THEN
868: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
869: FND_MESSAGE.set_token('MISS_FIELD','ENABLED_FLAG');
870: x_return_status := FND_API.g_ret_sts_error;
871: RETURN;
872: END IF;
865: END IF;
866:
867: IF p_met_tpl_assoc_rec.enabled_flag = FND_API.g_miss_char OR p_met_tpl_assoc_rec.enabled_flag IS NULL THEN
868: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
869: FND_MESSAGE.set_token('MISS_FIELD','ENABLED_FLAG');
870: x_return_status := FND_API.g_ret_sts_error;
871: RETURN;
872: END IF;
873: ELSE