[Home] [Help]
114: OR p_updating THEN
115: --
116: -- Validate assessment item exists
117: -- w.r.t Bug # 1956374 procedure assp_val_ai_exists reference is changed
118: IF igs_as_val_uai.assp_val_ai_exists (new_references.ass_id, v_message_name) = FALSE THEN
119: fnd_message.set_name ('IGS', v_message_name);
120: igs_ge_msg_stack.ADD;
121: app_exception.raise_exception;
122: END IF;
169: --
170: -- Validate the examination calendar type/sequence number if they have
171: -- been specified.
172: IF new_references.exam_cal_type IS NOT NULL THEN
173: IF igs_as_val_uai.assp_val_uai_cal (
174: new_references.exam_cal_type,
175: new_references.exam_ci_sequence_number,
176: lv_cal_type,
177: lv_ci_sequence_number,
186: IF p_inserting THEN
187: --
188: -- If calendar type is closed, then prevent inserts.
189: -- As part of the bug# 1956374 changed to the below call from IGS_PS_VAL_UAI.crsp_val_uo_cal_type
190: IF igs_as_val_uai.crsp_val_uo_cal_type (lv_cal_type, v_message_name) = FALSE THEN
191: fnd_message.set_name ('IGS', v_message_name);
192: igs_ge_msg_stack.ADD;
193: app_exception.raise_exception;
194: END IF;
205: -- Only perform this validation if not in the process of performing a
206: -- cascading update from altering the IGS_AS_UNTAS_PATTERN
207: -- fields of IGS_AD_LOCATION, class and mode. (Refer to IGS_AS_GEN_005.ASSP_UPD_UAP_UOO)
208: IF igs_as_val_suaap.genp_val_sdtt_sess('UNIT_ASSESSMENT_PATTERN_UPD') THEN
209: IF IGS_AS_VAL_UAI.assp_val_uai_uapi(lv_unit_cd,
210: lv_version_number,
211: lv_cal_type,
212: lv_ci_sequence_number,
213: new_references.ass_id,
294: -- w.r.t Bug # 1956374 procedure assp_val_ai_exmnbl reference is changed
295: IF igs_as_val_aiem.assp_val_ai_exmnbl (new_references.ass_id, v_message_name) = TRUE THEN
296: --
297: -- Validate that the reference number id unique within a UOP
298: IF igs_as_val_uai.assp_val_uai_uniqref (
299: lv_unit_cd,
300: lv_version_number,
301: lv_cal_type,
302: lv_ci_sequence_number,