[Home] [Help]
54: FETCH cur_old_ref_values INTO old_references;
55: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
56: CLOSE cur_old_ref_values;
57: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
58: igs_ge_msg_stack.add;
59: app_exception.raise_exception;
60: RETURN;
61: END IF;
62: CLOSE cur_old_ref_values;
111: ELSIF NOT igs_pe_person_id_typ_pkg.get_pk_for_validation (
112: new_references.default_student_id_type
113: ) THEN
114: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
115: igs_ge_msg_stack.add;
116: app_exception.raise_exception;
117: END IF;
118:
119: IF (((old_references.wif_major_unit_set_cat = new_references.wif_major_unit_set_cat)) OR
122: ELSIF NOT igs_en_unit_set_cat_pkg.get_pk_for_validation (
123: new_references.wif_major_unit_set_cat
124: ) THEN
125: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
126: igs_ge_msg_stack.add;
127: app_exception.raise_exception;
128: END IF;
129:
130: IF (((old_references.wif_minor_unit_set_cat = new_references.wif_minor_unit_set_cat)) OR
133: ELSIF NOT igs_en_unit_set_cat_pkg.get_pk_for_validation (
134: new_references.wif_minor_unit_set_cat
135: ) THEN
136: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
137: igs_ge_msg_stack.add;
138: app_exception.raise_exception;
139: END IF;
140:
141: IF (((old_references.wif_track_unit_set_cat = new_references.wif_track_unit_set_cat)) OR
144: ELSIF NOT igs_en_unit_set_cat_pkg.get_pk_for_validation (
145: new_references.wif_track_unit_set_cat
146: ) THEN
147: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
148: igs_ge_msg_stack.add;
149: app_exception.raise_exception;
150: END IF;
151:
152: IF (((old_references.default_inst_id_type = new_references.default_inst_id_type)) OR
155: ELSIF NOT igs_or_org_alt_idtyp_pkg.get_pk_for_validation (
156: new_references.default_inst_id_type
157: ) THEN
158: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
159: igs_ge_msg_stack.add;
160: app_exception.raise_exception;
161: END IF;
162:
163: END check_parent_existance;
224: FETCH cur_rowid INTO lv_rowid;
225: IF (cur_rowid%FOUND) THEN
226: CLOSE cur_rowid;
227: fnd_message.set_name ('IGS', 'IGS_DA_SET_EUS_FK');
228: igs_ge_msg_stack.add;
229: app_exception.raise_exception;
230: RETURN;
231: END IF;
232: CLOSE cur_rowid;
259: FETCH cur_rowid INTO lv_rowid;
260: IF (cur_rowid%FOUND) THEN
261: CLOSE cur_rowid;
262: fnd_message.set_name ('IGS', 'IGS_DA_SET_OAIT_FK');
263: igs_ge_msg_stack.add;
264: app_exception.raise_exception;
265: RETURN;
266: END IF;
267: CLOSE cur_rowid;
336: new_references.s_control_num
337: )
338: ) THEN
339: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
340: igs_ge_msg_stack.add;
341: app_exception.raise_exception;
342: END IF;
343: check_parent_existance;
344: ELSIF (p_action = 'UPDATE') THEN
350: new_references.s_control_num
351: )
352: ) THEN
353: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
354: igs_ge_msg_stack.add;
355: app_exception.raise_exception;
356: END IF;
357: END IF;
358:
409: END IF;
410: ELSE
411: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
412: fnd_message.set_token ('ROUTINE', 'IGS_DA_SETUP_PKG.INSERT_ROW');
413: igs_ge_msg_stack.add;
414: app_exception.raise_exception;
415: END IF;
416:
417: before_dml(
540: OPEN c1;
541: FETCH c1 INTO tlinfo;
542: IF (c1%notfound) THEN
543: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
544: igs_ge_msg_stack.add;
545: CLOSE c1;
546: app_exception.raise_exception;
547: RETURN;
548: END IF;
566: ) THEN
567: NULL;
568: ELSE
569: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
570: igs_ge_msg_stack.add;
571: app_exception.raise_exception;
572: END IF;
573:
574: RETURN;
625: END IF;
626: ELSE
627: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
628: fnd_message.set_token ('ROUTINE', 'IGS_DA_SETUP_PKG.UPDATE_ROW');
629: igs_ge_msg_stack.add;
630: app_exception.raise_exception;
631: END IF;
632:
633: before_dml(