[Home] [Help]
49: OPEN cur_old_ref_values;
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;
105: new_references.recip_non_ed_brc_id,
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:
171: NULL;
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:
185: ELSIF NOT igf_sl_lender_brc_pkg.get_pk_for_validation (
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:
196: NULL;
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:
344: OPEN cur_rowid;
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;
381: OPEN 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;
416: OPEN 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;
485: IF ( get_pk_for_validation(
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;
501: IF ( get_pk_for_validation (
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;
567: IF (x_last_update_login IS NULL) 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:
692:
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;
714: AND ((tlinfo.preferred_flag = x_preferred_flag) OR ((tlinfo.preferred_flag IS NULL) AND (X_preferred_flag IS NULL)))
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:
768: IF (x_last_update_login IS NULL) THEN
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: