APPS.IGF_SL_DL_LOR_CRRESP_PKG dependencies on APP_EXCEPTION

Line 56: app_exception.raise_exception;

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

Line 109: app_exception.raise_exception;

105: new_references.dbth_id
106: ) THEN
107: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
108: igs_ge_msg_stack.add;
109: app_exception.raise_exception;
110: END IF;
111:
112: END check_parent_existance;
113:

Line 177: app_exception.raise_exception;

173: IF (cur_rowid%FOUND) THEN
174: CLOSE cur_rowid;
175: fnd_message.set_name ('IGF', 'IGF_SL_LORC_DBTH_FK');
176: igs_ge_msg_stack.add;
177: app_exception.raise_exception;
178: RETURN;
179: END IF;
180: CLOSE cur_rowid;
181:

Line 246: app_exception.raise_exception;

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

Line 260: app_exception.raise_exception;

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

Line 335: app_exception.raise_exception;

331: END IF;
332: ELSE
333: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
334: igs_ge_msg_stack.add;
335: app_exception.raise_exception;
336: END IF;
337:
338: SELECT igf_sl_dl_lor_crresp_s.NEXTVAL
339: INTO x_lor_resp_num

Line 471: app_exception.raise_exception;

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

Line 492: app_exception.raise_exception;

488: NULL;
489: ELSE
490: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
491: igs_ge_msg_stack.add;
492: app_exception.raise_exception;
493: END IF;
494:
495: RETURN;
496:

Line 550: app_exception.raise_exception;

546: END IF;
547: ELSE
548: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
549: igs_ge_msg_stack.add;
550: app_exception.raise_exception;
551: END IF;
552:
553: before_dml(
554: p_action => 'UPDATE',