DBA Data[Home] [Help]

APPS.IGF_SL_DL_CHG_RESP_PKG dependencies on APP_EXCEPTION

Line 53: app_exception.raise_exception;

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

Line 104: app_exception.raise_exception;

100: new_references.dbth_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: END check_parent_existance;
108:

Line 172: app_exception.raise_exception;

168: IF (cur_rowid%FOUND) THEN
169: CLOSE cur_rowid;
170: fnd_message.set_name ('IGF', 'IGF_SL_RCHG_DBTH_FK');
171: igs_ge_msg_stack.add;
172: app_exception.raise_exception;
173: RETURN;
174: END IF;
175: CLOSE cur_rowid;
176:

Line 237: app_exception.raise_exception;

233: )
234: ) THEN
235: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
236: igs_ge_msg_stack.add;
237: app_exception.raise_exception;
238: END IF;
239: check_parent_existance;
240: ELSIF (p_action = 'UPDATE') THEN
241: -- Call all the procedures related to Before Update.

Line 251: app_exception.raise_exception;

247: )
248: ) THEN
249: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
250: igs_ge_msg_stack.add;
251: app_exception.raise_exception;
252: END IF;
253: END IF;
254:
255: END before_dml;

Line 324: app_exception.raise_exception;

320: END IF;
321: ELSE
322: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
323: igs_ge_msg_stack.add;
324: app_exception.raise_exception;
325: END IF;
326:
327: SELECT igf_sl_dl_chg_resp_s.nextval INTO
328: x_resp_num FROM dual;

Line 449: app_exception.raise_exception;

445: IF (c1%notfound) THEN
446: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
447: igs_ge_msg_stack.add;
448: CLOSE c1;
449: app_exception.raise_exception;
450: RETURN;
451: END IF;
452: CLOSE c1;
453:

Line 468: app_exception.raise_exception;

464: NULL;
465: ELSE
466: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
467: igs_ge_msg_stack.add;
468: app_exception.raise_exception;
469: END IF;
470:
471: RETURN;
472:

Line 524: app_exception.raise_exception;

520: END IF;
521: ELSE
522: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
523: igs_ge_msg_stack.add;
524: app_exception.raise_exception;
525: END IF;
526:
527: before_dml(
528: p_action => 'UPDATE',