APPS.IGF_SL_PNOTE_STAT_H_PKG dependencies on APP_EXCEPTION

Line 48: app_exception.raise_exception;

44: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
45: CLOSE cur_old_ref_values;
46: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
47: igs_ge_msg_stack.add;
48: app_exception.raise_exception;
49: RETURN;
50: END IF;
51: CLOSE cur_old_ref_values;
52:

Line 94: app_exception.raise_exception;

90: new_references.loan_id
91: ) THEN
92: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
93: igs_ge_msg_stack.add;
94: app_exception.raise_exception;
95: END IF;
96:
97: END check_parent_existance;
98:

Line 164: app_exception.raise_exception;

160: IF (cur_rowid%FOUND) THEN
161: CLOSE cur_rowid;
162: fnd_message.set_name ('IGF', 'IGF_SL_DLPNH_LOR_FK');
163: igs_ge_msg_stack.add;
164: app_exception.raise_exception;
165: RETURN;
166: END IF;
167: CLOSE cur_rowid;
168:

Line 219: app_exception.raise_exception;

215: )
216: ) THEN
217: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
218: igs_ge_msg_stack.add;
219: app_exception.raise_exception;
220: END IF;
221: check_parent_existance;
222: ELSIF (p_action = 'UPDATE') THEN
223: -- Call all the procedures related to Before Update.

Line 233: app_exception.raise_exception;

229: )
230: ) THEN
231: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
232: igs_ge_msg_stack.add;
233: app_exception.raise_exception;
234: END IF;
235: END IF;
236:
237: END before_dml;

Line 300: app_exception.raise_exception;

296: END IF;
297: ELSE
298: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
299: igs_ge_msg_stack.add;
300: app_exception.raise_exception;
301: END IF;
302:
303: SELECT igf_sl_pnote_stat_h_s.NEXTVAL
304: INTO x_dlpnh_id

Line 397: app_exception.raise_exception;

393: IF (c1%notfound) THEN
394: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
395: igs_ge_msg_stack.add;
396: CLOSE c1;
397: app_exception.raise_exception;
398: RETURN;
399: END IF;
400: CLOSE c1;
401:

Line 411: app_exception.raise_exception;

407: NULL;
408: ELSE
409: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
410: igs_ge_msg_stack.add;
411: app_exception.raise_exception;
412: END IF;
413:
414: RETURN;
415:

Line 462: app_exception.raise_exception;

458: END IF;
459: ELSE
460: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
461: igs_ge_msg_stack.add;
462: app_exception.raise_exception;
463: END IF;
464:
465: before_dml(
466: p_action => 'UPDATE',