DBA Data[Home] [Help]

APPS.IGF_SL_DL_LOR_RESP_PKG dependencies on APP_EXCEPTION

Line 57: app_exception.raise_exception;

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

Line 112: app_exception.raise_exception;

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

Line 180: app_exception.raise_exception;

176: IF (cur_rowid%FOUND) THEN
177: CLOSE cur_rowid;
178: fnd_message.set_name ('IGF', 'IGF_SL_LORR_DBTH_FK');
179: igs_ge_msg_stack.add;
180: app_exception.raise_exception;
181: RETURN;
182: END IF;
183: CLOSE cur_rowid;
184:

Line 253: app_exception.raise_exception;

249: )
250: ) THEN
251: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
252: igs_ge_msg_stack.add;
253: app_exception.raise_exception;
254: END IF;
255: check_parent_existance;
256: ELSIF (p_action = 'UPDATE') THEN
257: -- Call all the procedures related to Before Update.

Line 267: app_exception.raise_exception;

263: )
264: ) THEN
265: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
266: igs_ge_msg_stack.add;
267: app_exception.raise_exception;
268: END IF;
269: END IF;
270:
271: END before_dml;

Line 344: app_exception.raise_exception;

340: END IF;
341: ELSE
342: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
343: igs_ge_msg_stack.add;
344: app_exception.raise_exception;
345: END IF;
346:
347: SELECT igf_sl_dl_lor_resp_s.NEXTVAL
348: INTO x_lor_resp_num

Line 489: app_exception.raise_exception;

485: IF (c1%notfound) THEN
486: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
487: igs_ge_msg_stack.add;
488: CLOSE c1;
489: app_exception.raise_exception;
490: RETURN;
491: END IF;
492: CLOSE c1;
493:

Line 512: app_exception.raise_exception;

508: NULL;
509: ELSE
510: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
511: igs_ge_msg_stack.add;
512: app_exception.raise_exception;
513: END IF;
514:
515: RETURN;
516:

Line 572: app_exception.raise_exception;

568: END IF;
569: ELSE
570: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
571: igs_ge_msg_stack.add;
572: app_exception.raise_exception;
573: END IF;
574:
575: before_dml(
576: p_action => 'UPDATE',