APPS.IGF_SL_DL_PNOTE_S_P_PKG dependencies on APP_EXCEPTION

Line 64: app_exception.raise_exception;

60: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
61: CLOSE cur_old_ref_values;
62: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
63: igs_ge_msg_stack.add;
64: app_exception.raise_exception;
65: RETURN;
66: END IF;
67: CLOSE cur_old_ref_values;
68:

Line 126: app_exception.raise_exception;

122: new_references.loan_id
123: ) THEN
124: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
125: igs_ge_msg_stack.add;
126: app_exception.raise_exception;
127: END IF;
128:
129: END check_parent_existance;
130:

Line 194: app_exception.raise_exception;

190: IF (cur_rowid%FOUND) THEN
191: CLOSE cur_rowid;
192: fnd_message.set_name ('IGF', 'IGF_SL_PNSP_LAR_FK');
193: igs_ge_msg_stack.add;
194: app_exception.raise_exception;
195: RETURN;
196: END IF;
197: CLOSE cur_rowid;
198:

Line 281: app_exception.raise_exception;

277: )
278: ) THEN
279: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
280: igs_ge_msg_stack.add;
281: app_exception.raise_exception;
282: END IF;
283: check_parent_existance;
284: ELSIF (p_action = 'UPDATE') THEN
285: -- Call all the procedures related to Before Update.

Line 295: app_exception.raise_exception;

291: )
292: ) THEN
293: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
294: igs_ge_msg_stack.add;
295: app_exception.raise_exception;
296: END IF;
297: END IF;
298:
299: END before_dml;

Line 378: app_exception.raise_exception;

374: END IF;
375: ELSE
376: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
377: igs_ge_msg_stack.add;
378: app_exception.raise_exception;
379: END IF;
380:
381: SELECT igf_sl_dl_pnote_s_p_all_s.NEXTVAL
382: INTO x_pnsp_id

Line 559: app_exception.raise_exception;

555: IF (c1%notfound) THEN
556: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
557: igs_ge_msg_stack.add;
558: CLOSE c1;
559: app_exception.raise_exception;
560: RETURN;
561: END IF;
562: CLOSE c1;
563:

Line 589: app_exception.raise_exception;

585: NULL;
586: ELSE
587: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
588: igs_ge_msg_stack.add;
589: app_exception.raise_exception;
590: END IF;
591:
592: RETURN;
593:

Line 656: app_exception.raise_exception;

652: END IF;
653: ELSE
654: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
655: igs_ge_msg_stack.add;
656: app_exception.raise_exception;
657: END IF;
658:
659: before_dml(
660: p_action => 'UPDATE',