DBA Data[Home] [Help]

APPS.IGF_SL_CL_RECIPIENT_PKG dependencies on IGS_GE_MSG_STACK

Line 54: igs_ge_msg_stack.add;

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;

Line 110: igs_ge_msg_stack.add;

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 (

Line 119: igs_ge_msg_stack.add;

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;

Line 176: igs_ge_msg_stack.add;

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

Line 190: igs_ge_msg_stack.add;

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

Line 201: igs_ge_msg_stack.add;

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;

Line 349: igs_ge_msg_stack.add;

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;

Line 386: igs_ge_msg_stack.add;

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;

Line 421: igs_ge_msg_stack.add;

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;

Line 490: igs_ge_msg_stack.add;

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;

Line 506: igs_ge_msg_stack.add;

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

Line 572: igs_ge_msg_stack.add;

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:

Line 697: igs_ge_msg_stack.add;

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;

Line 719: igs_ge_msg_stack.add;

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;

Line 773: igs_ge_msg_stack.add;

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(