APPS.IGF_SL_CL_RECIPIENT_PKG dependencies on APP_EXCEPTION

Line 55: app_exception.raise_exception;

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;
59:

Line 111: app_exception.raise_exception;

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

Line 120: app_exception.raise_exception;

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;
124:

Line 177: app_exception.raise_exception;

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
181: (old_references.lend_non_ed_brc_id = new_references.lend_non_ed_brc_id)) OR

Line 191: app_exception.raise_exception;

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
195: ((new_references.guarantor_id IS NULL))) THEN

Line 202: app_exception.raise_exception;

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;
206:

Line 350: app_exception.raise_exception;

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;
354:

Line 387: app_exception.raise_exception;

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;
391:

Line 422: app_exception.raise_exception;

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;
426:

Line 491: app_exception.raise_exception;

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;
495: ELSIF (p_action = 'UPDATE') THEN

Line 507: app_exception.raise_exception;

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
511: check_uniqueness;

Line 573: app_exception.raise_exception;

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:
577: SELECT igf_sl_cl_recipient_s.nextval

Line 699: app_exception.raise_exception;

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;
702: CLOSE c1;
703:

Line 720: app_exception.raise_exception;

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;
724:

Line 774: app_exception.raise_exception;

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(
778: p_action => 'UPDATE',