APPS.IGF_SL_DL_PNOTE_P_P_PKG dependencies on APP_EXCEPTION

Line 93: app_exception.raise_exception;

89: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
90: CLOSE cur_old_ref_values;
91: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
92: igs_ge_msg_stack.add;
93: app_exception.raise_exception;
94: RETURN;
95: END IF;
96: CLOSE cur_old_ref_values;
97:

Line 184: app_exception.raise_exception;

180: new_references.loan_id
181: ) THEN
182: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
183: igs_ge_msg_stack.add;
184: app_exception.raise_exception;
185: END IF;
186:
187: END check_parent_existance;
188:

Line 252: app_exception.raise_exception;

248: IF (cur_rowid%FOUND) THEN
249: CLOSE cur_rowid;
250: fnd_message.set_name ('IGF', 'IGF_SL_PNPP_LAR_FK');
251: igs_ge_msg_stack.add;
252: app_exception.raise_exception;
253: RETURN;
254: END IF;
255: CLOSE cur_rowid;
256:

Line 397: app_exception.raise_exception;

393: )
394: ) THEN
395: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
396: igs_ge_msg_stack.add;
397: app_exception.raise_exception;
398: END IF;
399: check_parent_existance;
400: ELSIF (p_action = 'UPDATE') THEN
401: -- Call all the procedures related to Before Update.

Line 411: app_exception.raise_exception;

407: )
408: ) THEN
409: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
410: igs_ge_msg_stack.add;
411: app_exception.raise_exception;
412: END IF;
413: END IF;
414:
415: END before_dml;

Line 523: app_exception.raise_exception;

519: END IF;
520: ELSE
521: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
522: igs_ge_msg_stack.add;
523: app_exception.raise_exception;
524: END IF;
525:
526: SELECT igf_sl_dl_pnote_p_p_all_s.NEXTVAL
527: INTO x_pnpp_id

Line 849: app_exception.raise_exception;

845: IF (c1%notfound) THEN
846: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
847: igs_ge_msg_stack.add;
848: CLOSE c1;
849: app_exception.raise_exception;
850: RETURN;
851: END IF;
852: CLOSE c1;
853:

Line 908: app_exception.raise_exception;

904: NULL;
905: ELSE
906: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
907: igs_ge_msg_stack.add;
908: app_exception.raise_exception;
909: END IF;
910:
911: RETURN;
912:

Line 1004: app_exception.raise_exception;

1000: END IF;
1001: ELSE
1002: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1003: igs_ge_msg_stack.add;
1004: app_exception.raise_exception;
1005: END IF;
1006:
1007: before_dml(
1008: p_action => 'UPDATE',