43: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
44: CLOSE cur_old_ref_values;
45: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
46: igs_ge_msg_stack.add;
47: app_exception.raise_exception;
48: RETURN;
49: END IF;
50: CLOSE cur_old_ref_values;
51:
88: new_references.dlpnr_id
89: ) THEN
90: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
91: igs_ge_msg_stack.add;
92: app_exception.raise_exception;
93: END IF;
94:
95: END check_parent_existance;
96:
158: IF (cur_rowid%FOUND) THEN
159: CLOSE cur_rowid;
160: fnd_message.set_name ('IGF', 'IGF_SL_DLPDR_DLPNR_FK');
161: igs_ge_msg_stack.add;
162: app_exception.raise_exception;
163: RETURN;
164: END IF;
165: CLOSE cur_rowid;
166:
212: )
213: ) THEN
214: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
215: igs_ge_msg_stack.add;
216: app_exception.raise_exception;
217: END IF;
218: check_parent_existance;
219: ELSIF (p_action = 'UPDATE') THEN
220: -- Call all the procedures related to Before Update.
227: )
228: ) THEN
229: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
230: igs_ge_msg_stack.add;
231: app_exception.raise_exception;
232: END IF;
233: END IF;
234:
235: END before_dml;
294: END IF;
295: ELSE
296: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299: END IF;
300:
301: before_dml(
302: p_action => 'INSERT',
381: IF (c1%notfound) THEN
382: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
383: igs_ge_msg_stack.add;
384: CLOSE c1;
385: app_exception.raise_exception;
386: RETURN;
387: END IF;
388: CLOSE c1;
389:
393: NULL;
394: ELSE
395: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
396: igs_ge_msg_stack.add;
397: app_exception.raise_exception;
398: END IF;
399:
400: RETURN;
401:
443: END IF;
444: ELSE
445: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
446: igs_ge_msg_stack.add;
447: app_exception.raise_exception;
448: END IF;
449:
450: before_dml(
451: p_action => 'UPDATE',