45: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
46: CLOSE cur_old_ref_values;
47: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
48: igs_ge_msg_stack.add;
49: app_exception.raise_exception;
50: RETURN;
51: END IF;
52: CLOSE cur_old_ref_values;
53:
93: 'N'
94: ) THEN
95: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
96: igs_ge_msg_stack.add;
97: app_exception.raise_exception;
98: END IF;
99:
100: END check_parent_existance;
101:
186: new_references.admission_appl_number )
187: ) THEN
188: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
189: igs_ge_msg_stack.add;
190: app_exception.raise_exception;
191: END IF;
192: check_parent_existance;
193: END IF;
194: END before_dml;
254: END IF;
255: ELSE
256: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
257: igs_ge_msg_stack.add;
258: app_exception.raise_exception;
259: END IF;
260:
261: before_dml(
262: p_action => 'INSERT',