[Home] [Help]
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;
70: -- Populate New Values.
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: --
134: -- Validate IGS_PS_UNIT mode closed indicator
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: --
148: -- If calendar instance is inactive, then prevent inserts, updates and
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: --
158: -- If item is examinable then validate that reference is set.
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: --
170: -- Validate the examination calendar type/sequence number if they have
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: --<
186: IF p_inserting THEN
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;
197: -- Commented out NOCOPY by DDEY as a part of Bug # 2162831
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; */
230: END IF;
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: --
314: -- if record has not been deleted
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;
335: -- Save the rowid of the current row.
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:
371: PROCEDURE check_parent_existance AS
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:
395: -- ADDED BY DDEY FOR BUG # 2162831
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;
413: CLOSE cur_rowid;
414: END get_fk_igs_as_grd_schema;
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;
432: CLOSE cur_rowid;
433: END get_fk_igs_as_us_ai_group;
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;
601: ELSIF (p_action = 'UPDATE') 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
619: check_uniqueness;
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
729: FROM DUAL;
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;
873: CLOSE c1;
874: IF ((tlinfo.uoo_id = x_uoo_id)
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;
964:
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',
1039: x_rowid => x_rowid,