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:
92: new_references.lender_id
93: ) THEN
94: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
95: igs_ge_msg_stack.add;
96: app_exception.raise_exception;
97: END IF;
98:
99: END check_parent_existance;
100:
139: )
140: ) THEN
141: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
142: igs_ge_msg_stack.add;
143: app_exception.raise_exception;
144: END IF;
145:
146: END check_uniqueness;
147:
208: IF (cur_rowid%FOUND) THEN
209: CLOSE cur_rowid;
210: fnd_message.set_name ('IGF', 'IGF_SL_LNDB_LND_FK');
211: igs_ge_msg_stack.add;
212: app_exception.raise_exception;
213: RETURN;
214: END IF;
215: CLOSE cur_rowid;
216:
299: )
300: ) THEN
301: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
302: igs_ge_msg_stack.add;
303: app_exception.raise_exception;
304: END IF;
305: check_parent_existance;
306: check_uniqueness;
307: ELSIF (p_action = 'UPDATE') THEN
319: )
320: ) THEN
321: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: END IF;
325: check_uniqueness;
326: ELSIF (p_action = 'VALIDATE_DELETE') THEN
327: check_child_existance;
375: END IF;
376: ELSE
377: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
378: igs_ge_msg_stack.add;
379: app_exception.raise_exception;
380: END IF;
381:
382: before_dml(
383: p_action => 'INSERT',
464: IF (c1%notfound) THEN
465: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
466: igs_ge_msg_stack.add;
467: CLOSE c1;
468: app_exception.raise_exception;
469: RETURN;
470: END IF;
471: CLOSE c1;
472:
478: NULL;
479: ELSE
480: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
481: igs_ge_msg_stack.add;
482: app_exception.raise_exception;
483: END IF;
484:
485: RETURN;
486:
526: END IF;
527: ELSE
528: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
529: igs_ge_msg_stack.add;
530: app_exception.raise_exception;
531: END IF;
532:
533: before_dml(
534: p_action => 'UPDATE',