50: FETCH cur_old_ref_values INTO old_references;
51: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
52: CLOSE cur_old_ref_values;
53: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
54: igs_ge_msg_stack.add;
55: app_exception.raise_exception;
56: RETURN;
57: END IF;
58: CLOSE cur_old_ref_values;
106: new_references.relationship_cd
107: )
108: ) THEN
109: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: END IF;
113:
114: IF ( get_uk1_for_validation (
115: new_references.relationship_cd
116: )
117: ) THEN
118: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
119: igs_ge_msg_stack.add;
120: app_exception.raise_exception;
121: END IF;
122:
123: END check_uniqueness;
172: ELSIF NOT igf_sl_lender_pkg.get_pk_for_validation (
173: new_references.lender_id
174: ) THEN
175: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
176: igs_ge_msg_stack.add;
177: app_exception.raise_exception;
178: END IF;
179:
180: IF (((old_references.lender_id = new_references.lender_id) AND
186: new_references.lender_id,
187: new_references.lend_non_ed_brc_id
188: ) THEN
189: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
190: igs_ge_msg_stack.add;
191: app_exception.raise_exception;
192: END IF;
193:
194: IF (((old_references.guarantor_id = new_references.guarantor_id)) OR
197: ELSIF NOT igf_sl_guarantor_pkg.get_pk_for_validation (
198: new_references.guarantor_id
199: ) THEN
200: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
201: igs_ge_msg_stack.add;
202: app_exception.raise_exception;
203: END IF;
204:
205: END check_parent_existance;
345: FETCH cur_rowid INTO lv_rowid;
346: IF (cur_rowid%FOUND) THEN
347: CLOSE cur_rowid;
348: fnd_message.set_name ('IGF', 'IGF_SL_RCPT_LND_FK');
349: igs_ge_msg_stack.add;
350: app_exception.raise_exception;
351: RETURN;
352: END IF;
353: CLOSE cur_rowid;
382: FETCH cur_rowid INTO lv_rowid;
383: IF (cur_rowid%FOUND) THEN
384: CLOSE cur_rowid;
385: fnd_message.set_name ('IGF', 'IGF_SL_RCPT_LNDB_FK');
386: igs_ge_msg_stack.add;
387: app_exception.raise_exception;
388: RETURN;
389: END IF;
390: CLOSE cur_rowid;
417: FETCH cur_rowid INTO lv_rowid;
418: IF (cur_rowid%FOUND) THEN
419: CLOSE cur_rowid;
420: fnd_message.set_name ('IGF', 'IGF_SL_RCPT_GUARN_FK');
421: igs_ge_msg_stack.add;
422: app_exception.raise_exception;
423: RETURN;
424: END IF;
425: CLOSE cur_rowid;
486: new_references.rcpt_id
487: )
488: ) THEN
489: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
490: igs_ge_msg_stack.add;
491: app_exception.raise_exception;
492: END IF;
493: check_uniqueness;
494: check_parent_existance;
502: new_references.rcpt_id
503: )
504: ) THEN
505: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
506: igs_ge_msg_stack.add;
507: app_exception.raise_exception;
508: END IF;
509: check_uniqueness;
510: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
568: x_last_update_login := -1;
569: END IF;
570: ELSE
571: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
572: igs_ge_msg_stack.add;
573: app_exception.raise_exception;
574: END IF;
575:
576:
693: OPEN c1;
694: FETCH c1 INTO tlinfo;
695: IF (c1%notfound) THEN
696: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
697: igs_ge_msg_stack.add;
698: CLOSE c1;
699: app_exception.raise_exception;
700: RETURN;
701: END IF;
715: ) THEN
716: NULL;
717: ELSE
718: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
719: igs_ge_msg_stack.add;
720: app_exception.raise_exception;
721: END IF;
722:
723: RETURN;
769: x_last_update_login := -1;
770: END IF;
771: ELSE
772: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
773: igs_ge_msg_stack.add;
774: app_exception.raise_exception;
775: END IF;
776:
777: before_dml(