[Home] [Help]
60: FETCH cur_old_ref_values INTO old_references;
61: IF (cur_old_ref_values%NOTFOUND)
62: AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
63: CLOSE cur_old_ref_values;
64: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
65: igs_ge_msg_stack.ADD;
66: app_exception.raise_exception;
67: RETURN;
68: END IF;
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;
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: --<
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
140: -- trigger is not required.
141: IF igs_ps_val_unit.crsp_val_iud_uv_dtl (lv_unit_cd, lv_version_number, v_message_name) = FALSE THEN
142: fnd_message.set_name ('IGS', v_message_name);
143: igs_ge_msg_stack.ADD;
144: app_exception.raise_exception;
145: END IF;
146: --<
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;
156: --<
160: IF NVL (new_references.REFERENCE, 'NULL666') = 'NULL666'
161: AND (igs_as_val_aiem.assp_val_ai_exmnbl (new_references.ass_id, v_message_name)
162: OR igs_as_gen_002.assp_get_ai_s_type (new_references.ass_id) = 'ASSIGNMENT'
163: ) THEN
164: fnd_message.set_name ('IGS', 'IGS_AS_REF_ASSITEM_EXAM');
165: igs_ge_msg_stack.ADD;
166: app_exception.raise_exception;
167: END IF;
168: --<
176: lv_cal_type,
177: lv_ci_sequence_number,
178: v_message_name
179: ) = FALSE THEN
180: fnd_message.set_name ('IGS', v_message_name);
181: igs_ge_msg_stack.ADD;
182: app_exception.raise_exception;
183: END IF;
184: END IF;
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;
195: --<
220: new_references.unit_class,
221: new_references.unit_mode,
222: new_references.logical_delete_dt,
223: v_message_name) = FALSE THEN
224: Fnd_Message.Set_Name('IGS', v_message_name);
225: IGS_GE_MSG_STACK.ADD;
226: App_Exception.Raise_Exception;
227: END IF;
228: END IF;
304: new_references.REFERENCE,
305: new_references.ass_id,
306: v_message_name
307: ) = FALSE THEN
308: fnd_message.set_name ('IGS', v_message_name);
309: igs_ge_msg_stack.ADD;
310: app_exception.raise_exception;
311: END IF;
312: ELSE
325: new_references.ass_id,
326: igs_as_gen_001.assp_get_ai_a_type (new_references.ass_id),
327: v_message_name
328: ) = FALSE THEN
329: fnd_message.set_name ('IGS', v_message_name);
330: igs_ge_msg_stack.ADD;
331: app_exception.raise_exception;
332: END IF;
333: END IF;
361: (reverse chronological order - newest change first)
362: ***************************************************************/
363: BEGIN
364: IF get_uk_for_validation (new_references.ass_id, new_references.sequence_number, new_references.uoo_id) THEN
365: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
366: igs_ge_msg_stack.ADD;
367: app_exception.raise_exception;
368: END IF;
369: END check_uniqueness;
385: NULL;
386: ELSIF NOT igs_as_us_ai_group_pkg.get_pk_for_validation (
387: new_references.us_ass_item_group_id
388: ) THEN
389: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
390: igs_ge_msg_stack.ADD;
391: app_exception.raise_exception;
392: END IF;
393: END check_parent_existance;
403: BEGIN
404: OPEN cur_rowid;
405: FETCH cur_rowid INTO lv_rowid;
406: IF (cur_rowid%FOUND) THEN
407: fnd_message.set_name ('IGS', 'IGS_AS_UNAS_GS_FK');
408: igs_ge_msg_stack.ADD;
409: CLOSE cur_rowid;
410: app_exception.raise_exception;
411: RETURN;
422: BEGIN
423: OPEN cur_rowid;
424: FETCH cur_rowid INTO lv_rowid;
425: IF (cur_rowid%FOUND) THEN
426: fnd_message.set_name ('IGS', 'IGS_AS_UNAS_USAI_FK');
427: igs_ge_msg_stack.ADD;
428: CLOSE cur_rowid;
429: app_exception.raise_exception;
430: RETURN;
591: -- Call all the procedures related to Before Insert.
592: -- BeforeRowInsertUpdate1 ( p_inserting => TRUE );
593: beforerowinsertupdate2 (p_inserting => TRUE);
594: IF get_pk_for_validation (new_references.unit_section_ass_item_id) THEN
595: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
596: igs_ge_msg_stack.ADD;
597: app_exception.raise_exception;
598: END IF;
599: check_uniqueness;
609: NULL;
610: ELSIF (p_action = 'VALIDATE_INSERT') THEN
611: -- Call all the procedures related to Before Insert.
612: IF get_pk_for_validation (new_references.unit_section_ass_item_id) THEN
613: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
614: igs_ge_msg_stack.ADD;
615: app_exception.raise_exception;
616: END IF;
617: check_uniqueness;
719: ELSE
720: x_program_update_date := SYSDATE;
721: END IF;
722: ELSE
723: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
724: igs_ge_msg_stack.ADD;
725: app_exception.raise_exception;
726: END IF;
727: SELECT igs_ps_unitass_item_s.NEXTVAL
863: BEGIN
864: OPEN c1;
865: FETCH c1 INTO tlinfo;
866: IF (c1%NOTFOUND) THEN
867: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
868: igs_ge_msg_stack.ADD;
869: CLOSE c1;
870: app_exception.raise_exception;
871: RETURN;
954: )
955: ) THEN
956: NULL;
957: ELSE
958: fnd_message.set_name ('FND', 'FORM_RECORD_CHANGED');
959: igs_ge_msg_stack.ADD;
960: app_exception.raise_exception;
961: END IF;
962: RETURN;
1029: ELSE
1030: x_program_update_date := SYSDATE;
1031: END IF;
1032: ELSE
1033: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
1034: igs_ge_msg_stack.ADD;
1035: app_exception.raise_exception;
1036: END IF;
1037: before_dml (