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;
69: CLOSE cur_old_ref_values;
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: --<
133: --
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: --<
147: --
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: --<
157: --
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: --<
169: --
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;
185: --<
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: --<
196: END IF;
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;
229: END IF; */
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
313: --
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;
334: END IF;
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;
370:
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;
394:
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;
412: END IF;
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;
431: END IF;
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;
600: check_parent_existance;
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;
618: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
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
728: INTO x_unit_section_ass_item_id
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;
872: END IF;
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;
963: END lock_row;
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 (
1038: p_action => 'UPDATE',