[Home] [Help]
122: END IF;
123: --<
124: --
125: -- Validate IGS_AD_LOCATION closed indicator
126: -- As part of the bug# 1956374 changed to the below call from IGS_PS_VAL_UAI.crsp_val_loc_cd
127: IF igs_ps_val_uoo.crsp_val_loc_cd (new_references.location_cd, v_message_name) = FALSE THEN
128: fnd_message.set_name ('IGS', v_message_name);
129: igs_ge_msg_stack.ADD;
130: app_exception.raise_exception;
131: END IF;
132: --<
133: --
134: -- Validate IGS_PS_UNIT mode closed indicator
135: -- As part of the bug# 1956374 changed to the below call from IGS_PS_VAL_UAI.crsp_val_um_closed
136: --<
137: --
138: -- If the IGS_PS_UNIT version status is inactive then prevent inserts, updates and
139: -- deletes. As deletes are logical, they are equiv to updates and delete
147: --
148: -- If calendar instance is inactive, then prevent inserts, updates and
149: -- deletes. As deletes are logical, they are equiv to updates and delete
150: -- trigger is not required.
151: IF igs_ps_val_uai.crsp_val_crs_ci (lv_cal_type, lv_ci_sequence_number, v_message_name) = FALSE THEN
152: fnd_message.set_name ('IGS', v_message_name);
153: igs_ge_msg_stack.ADD;
154: app_exception.raise_exception;
155: END IF;
185: --<
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;
314: -- if record has not been deleted
315: IF NVL (new_references.logical_delete_dt, igs_ge_date.igsdate ('1900/01/01')) =
316: igs_ge_date.igsdate ('1900/01/01') THEN
317: -- Validate that the reference number id unique within a UOP
318: IF igs_ps_val_uai.assp_val_uai_opt_ref (
319: lv_unit_cd,
320: lv_version_number,
321: lv_cal_type,
322: lv_ci_sequence_number,