54: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
55: CLOSE cur_old_ref_values;
56: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
57: igs_ge_msg_stack.add;
58: app_exception.raise_exception;
59: RETURN;
60: END IF;
61: CLOSE cur_old_ref_values;
62:
124: new_references.course_cd
125: ) THEN
126: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
127: igs_ge_msg_stack.add;
128: app_exception.raise_exception;
129: END IF;
130:
131: IF (((old_references.person_id = new_references.person_id) AND
132: (old_references.course_cd = new_references.course_cd) AND
144: new_references.term_ci_sequence_number
145: ) THEN
146: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
147: igs_ge_msg_stack.add;
148: app_exception.raise_exception;
149: END IF;
150:
151: END check_parent_existance;
152:
221: CLOSE cur_rowid;
222:
223: fnd_message.set_name ('IGS', 'IGS_EN_PLSHT_SCA_FK');
224: igs_ge_msg_stack.add;
225: app_exception.raise_exception;
226: RETURN;
227: END IF;
228: CLOSE cur_rowid;
229:
262: IF (cur_rowid%FOUND) THEN
263: CLOSE cur_rowid;
264: fnd_message.set_name ('IGS', 'IGS_EN_PLSHT_ESPT_FK');
265: igs_ge_msg_stack.add;
266: app_exception.raise_exception;
267: RETURN;
268: END IF;
269: CLOSE cur_rowid;
270:
430: )
431: ) THEN
432: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
433: igs_ge_msg_stack.add;
434: app_exception.raise_exception;
435: END IF;
436: before_insert_update(p_action);
437: check_parent_existance;
438:
463: )
464: ) THEN
465: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
466: igs_ge_msg_stack.add;
467: app_exception.raise_exception;
468: END IF;
469: END IF;
470:
471: -- populate the sup_uoo_id if context unit is a subordinate unit
528: ELSE
529: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
530: fnd_message.set_token ('ROUTINE', 'IGS_EN_PLAN_UNITS_PKG.INSERT_ROW');
531: igs_ge_msg_stack.add;
532: app_exception.raise_exception;
533: END IF;
534:
535: before_dml(
536: p_action => 'INSERT',
652: IF (c1%notfound) THEN
653: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
654: igs_ge_msg_stack.add;
655: CLOSE c1;
656: app_exception.raise_exception;
657: RETURN;
658: END IF;
659: CLOSE c1;
660:
673: NULL;
674: ELSE
675: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
676: igs_ge_msg_stack.add;
677: app_exception.raise_exception;
678: END IF;
679:
680: RETURN;
681:
731: ELSE
732: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
733: fnd_message.set_token ('ROUTINE', 'IGS_EN_PLAN_UNITS_PKG.UPDATE_ROW');
734: igs_ge_msg_stack.add;
735: app_exception.raise_exception;
736: END IF;
737:
738: before_dml(
739: p_action => 'UPDATE',