609:
610: IF (c_template_res%NOTFOUND) THEN
611: CLOSE c_template_res;
612: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
613: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
614: FND_MSG_PUB.add;
615: END IF;
616: RAISE FND_API.g_exc_error;
617: END IF;
710:
711: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
712:
713: IF p_template_res_rec.template_id = FND_API.g_miss_num OR p_template_res_rec.template_id IS NULL THEN
714: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
715: FND_MESSAGE.set_token('MISS_FIELD','TEMPLATE_ID');
716: x_return_status := FND_API.g_ret_sts_error;
717: RETURN;
718: END IF;
711: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
712:
713: IF p_template_res_rec.template_id = FND_API.g_miss_num OR p_template_res_rec.template_id IS NULL THEN
714: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
715: FND_MESSAGE.set_token('MISS_FIELD','TEMPLATE_ID');
716: x_return_status := FND_API.g_ret_sts_error;
717: RETURN;
718: END IF;
719:
718: END IF;
719:
720:
721: IF p_template_res_rec.responsibility_id = FND_API.g_miss_num OR p_template_res_rec.responsibility_id IS NULL THEN
722: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
723: FND_MESSAGE.set_token('MISS_FIELD','RESPONSIBILITY_ID');
724: x_return_status := FND_API.g_ret_sts_error;
725: RETURN;
726: END IF;
719:
720:
721: IF p_template_res_rec.responsibility_id = FND_API.g_miss_num OR p_template_res_rec.responsibility_id IS NULL THEN
722: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
723: FND_MESSAGE.set_token('MISS_FIELD','RESPONSIBILITY_ID');
724: x_return_status := FND_API.g_ret_sts_error;
725: RETURN;
726: END IF;
727: