DBA Data[Home] [Help]

APPS.IGF_SL_CL_PREF_LENDERS_PKG dependencies on APP_EXCEPTION

Line 54: app_exception.raise_exception;

50: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
51: CLOSE cur_old_ref_values;
52: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
53: igs_ge_msg_stack.add;
54: app_exception.raise_exception;
55: RETURN;
56: END IF;
57: CLOSE cur_old_ref_values;
58:

Line 104: app_exception.raise_exception;

100: new_references.person_id
101: ) THEN
102: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
103: igs_ge_msg_stack.add;
104: app_exception.raise_exception;
105: END IF;
106:
107: IF (((old_references.relationship_cd = new_references.relationship_cd)) OR
108: ((new_references.relationship_cd IS NULL))) THEN

Line 115: app_exception.raise_exception;

111: new_references.relationship_cd
112: ) THEN
113: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
114: igs_ge_msg_stack.add;
115: app_exception.raise_exception;
116: END IF;
117:
118: END check_parent_existance;
119:

Line 184: app_exception.raise_exception;

180: IF (cur_rowid%FOUND) THEN
181: CLOSE cur_rowid;
182: fnd_message.set_name ('IGF','IGF_SL_CLPRL_RECIP_FK');
183: igs_ge_msg_stack.add;
184: app_exception.raise_exception;
185: RETURN;
186: END IF;
187: CLOSE cur_rowid;
188:

Line 244: app_exception.raise_exception;

240: )
241: ) THEN
242: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
243: igs_ge_msg_stack.add;
244: app_exception.raise_exception;
245: END IF;
246: check_parent_existance;
247: ELSIF (p_action = 'UPDATE') THEN
248: -- Call all the procedures related to Before Update.

Line 258: app_exception.raise_exception;

254: )
255: ) THEN
256: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
257: igs_ge_msg_stack.add;
258: app_exception.raise_exception;
259: END IF;
260: END IF;
261:
262: END before_dml;

Line 357: app_exception.raise_exception;

353: ELSE
354: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
355: fnd_message.set_token ('ROUTINE', 'IGF_SL_CL_PREF_LENDERS_PKG.INSERT_ROW');
356: igs_ge_msg_stack.add;
357: app_exception.raise_exception;
358: END IF;
359:
360: x_clprl_id := NULL;
361:

Line 424: app_exception.raise_exception;

420: x_msg_data := g_msg_data;
421: x_return_status := g_return_status;
422: fnd_message.set_name ('IGF',g_msg_data);
423: igs_ge_msg_stack.add;
424: app_exception.raise_exception;
425: END IF;
426:
427: END insert_row;
428:

Line 469: app_exception.raise_exception;

465: IF (c1%notfound) THEN
466: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
467: igs_ge_msg_stack.add;
468: CLOSE c1;
469: app_exception.raise_exception;
470: RETURN;
471: END IF;
472: CLOSE c1;
473:

Line 485: app_exception.raise_exception;

481: NULL;
482: ELSE
483: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
484: igs_ge_msg_stack.add;
485: app_exception.raise_exception;
486: END IF;
487:
488: RETURN;
489:

Line 544: app_exception.raise_exception;

540: ELSE
541: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
542: fnd_message.set_token ('ROUTINE', 'igf_sl_cl_pref_lenders_PKG.UPDATE_ROW');
543: igs_ge_msg_stack.add;
544: app_exception.raise_exception;
545: END IF;
546:
547: before_dml(
548: p_action => 'UPDATE',

Line 608: app_exception.raise_exception;

604: x_msg_data := g_msg_data;
605: x_return_status := g_return_status;
606: fnd_message.set_name ('IGF',g_msg_data);
607: igs_ge_msg_stack.add;
608: app_exception.raise_exception;
609: END IF;
610:
611: END update_row;
612: