46: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
47: CLOSE cur_old_ref_values;
48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
49: igs_ge_msg_stack.add;
50: app_exception.raise_exception;
51: RETURN;
52: END IF;
53: CLOSE cur_old_ref_values;
54:
97: new_references.admission_application_type
98: ) THEN
99: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
100: igs_ge_msg_stack.add;
101: app_exception.raise_exception;
102: END IF;
103:
104: END check_parent_existance;
105:
171: IF (cur_rowid%FOUND) THEN
172: CLOSE cur_rowid;
173: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
174: igs_ge_msg_stack.add;
175: app_exception.raise_exception;
176: RETURN;
177: END IF;
178: CLOSE cur_rowid;
179:
232: )
233: ) THEN
234: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
235: igs_ge_msg_stack.add;
236: app_exception.raise_exception;
237: END IF;
238: check_parent_existance;
239: ELSIF (p_action = 'UPDATE') THEN
240: -- Call all the procedures related to Before Update.
248: )
249: ) THEN
250: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
251: igs_ge_msg_stack.add;
252: app_exception.raise_exception;
253: END IF;
254: END IF;
255:
256: END before_dml;
298: ELSE
299: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
300: fnd_message.set_token ('ROUTINE', 'igs_ad_ss_appl_comps_PKG.INSERT_ROW');
301: igs_ge_msg_stack.add;
302: app_exception.raise_exception;
303: END IF;
304:
305: before_dml(
306: p_action => 'INSERT',
387: IF (c1%notfound) THEN
388: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
389: igs_ge_msg_stack.add;
390: CLOSE c1;
391: app_exception.raise_exception;
392: RETURN;
393: END IF;
394: CLOSE c1;
395:
401: NULL;
402: ELSE
403: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
404: igs_ge_msg_stack.add;
405: app_exception.raise_exception;
406: END IF;
407:
408: RETURN;
409:
451: ELSE
452: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
453: fnd_message.set_token ('ROUTINE', 'igs_ad_ss_appl_comps_PKG.UPDATE_ROW');
454: igs_ge_msg_stack.add;
455: app_exception.raise_exception;
456: END IF;
457:
458: before_dml(
459: p_action => 'UPDATE',