[Home] [Help]
180: v_unit_restr_ind := 'Y';
181: END IF;
182: END LOOP;
183: -- Validate inserts,updates,deletes
184: IF IGS_AD_VAL_ACAIU.admp_val_acaiu_iud(
185: v_person_id,
186: v_admission_appl_number,
187: v_nominated_course_cd,
188: v_acai_sequence_number,
220: END IF;
221: END IF;
222: IF p_inserting THEN
223: -- Validate the unit code.
224: IF IGS_AD_VAL_ACAIU.admp_val_acaiu_unit (
225: new_references.unit_cd,
226: new_references.uv_version_number,
227: v_adm_cal_type,
228: v_adm_ci_sequence_number,
235: IGS_GE_MSG_STACK.ADD;
236: App_Exception.Raise_Exception;
237: END IF;
238: -- Validate a research unit.
239: IF IGS_AD_VAL_ACAIU.admp_val_res_unit (
240: new_references.person_id,
241: new_references.admission_appl_number,
242: new_references.nominated_course_cd,
243: new_references.acai_sequence_number,
255: END IF;
256: END IF;
257: -- Validate unit encumbrances.
258: IF v_unit_encmb_chk_ind = 'Y' THEN
259: IF IGS_AD_VAL_ACAIU.admp_val_acaiu_encmb (
260: new_references.person_id,
261: v_acai_rec.course_cd,
262: new_references.unit_cd,
263: v_adm_cal_type,
277: IF p_inserting OR p_updating THEN
278: -- Validate admission unit outcome status
279: IF NVL(old_references.adm_unit_outcome_status, '-1') <>
280: new_references.adm_unit_outcome_status THEN
281: IF IGS_AD_VAL_ACAIU.admp_val_acaiu_auos (
282: new_references.person_id,
283: new_references.admission_appl_number,
284: new_references.nominated_course_cd,
285: new_references.acai_sequence_number,
290: App_Exception.Raise_Exception;
291: END IF;
292: IF v_offer_ind = 'Y' THEN
293: -- Validate that unit version is active
294: IF IGS_AD_VAL_ACAIU.admp_val_acaiu_uv(
295: new_references.unit_cd,
296: new_references.uv_version_number,
297: v_s_admission_process_type,
298: v_offer_ind,
301: IGS_GE_MSG_STACK.ADD;
302: App_Exception.Raise_Exception;
303: END IF;
304: -- Validate a research unit.
305: IF IGS_AD_VAL_ACAIU.admp_val_res_unit (
306: new_references.person_id,
307: new_references.admission_appl_number,
308: new_references.nominated_course_cd,
309: new_references.acai_sequence_number,
323: END IF;
324: END IF;
325: -- Validate unit mode.
326: IF (NVL(old_references.unit_mode, '-1') <> NVL(new_references.unit_mode, '-1')) THEN
327: -- As part of the bug# 1956374 changed to the below call from IGS_AD_VAL_ACAIU.crsp_val_um_closed
328: IF IGS_AS_VAL_UAI.crsp_val_um_closed (
329: new_references.unit_mode,
330: v_message_name) = FALSE THEN
331: Fnd_Message.Set_Name('IGS',v_message_name);
334: END IF;
335: END IF;
336: IF (NVL(old_references.unit_mode, '-1') <> NVL(new_references.unit_mode, '-1')) OR
337: (NVL(old_references.unit_class, '-1') <> NVL(new_references.unit_class, '-1')) THEN
338: IF IGS_AD_VAL_ACAIU.admp_val_acaiu_um (
339: new_references.unit_class,
340: new_references.unit_mode,
341: v_message_name) = FALSE THEN
342: Fnd_Message.Set_Name('IGS',v_message_name);
353: (NVL(old_references.unit_mode, '-1') <> NVL(new_references.unit_mode, '-1')) OR
354: ((NVL(old_references.adm_unit_outcome_status, '-1') <>
355: new_references.adm_unit_outcome_status) AND
356: v_offer_ind = 'Y') THEN
357: IF IGS_AD_VAL_ACAIU.admp_val_acaiu_opt (
358: new_references.unit_cd,
359: new_references.uv_version_number,
360: new_references.cal_type,
361: new_references.ci_sequence_number,
376: -- Validate the unit version against the teaching period.
377: IF (NVL(old_references.uv_version_number, -1) <> new_references.uv_version_number) OR
378: (NVL(old_references.cal_type, '-1') <> NVL(new_references.cal_type, '-1')) OR
379: (NVL(old_references.ci_sequence_number, -1) <> NVL(new_references.ci_sequence_number, -1)) THEN
380: IF IGS_AD_VAL_ACAIU.admp_val_acaiu_uv_ci (
381: new_references.unit_cd,
382: new_references.uv_version_number,
383: new_references.cal_type,
384: new_references.ci_sequence_number,
455: END LOOP;
456: END IF;
457: IF p_inserting THEN
458: -- Validate restriction number of admission course application instance unit.
459: IF IGS_AD_VAL_ACAIU.admp_val_acaiu_restr (
460: new_references.person_id,
461: new_references.admission_appl_number,
462: new_references.nominated_course_cd,
463: new_references.acai_sequence_number,