APPS.IGF_SL_DL_PNOTE_RESP_PKG dependencies on APP_EXCEPTION

Line 55: app_exception.raise_exception;

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

Line 108: app_exception.raise_exception;

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

Line 195: app_exception.raise_exception;

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

Line 264: app_exception.raise_exception;

260: )
261: ) THEN
262: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
263: igs_ge_msg_stack.add;
264: app_exception.raise_exception;
265: END IF;
266: check_parent_existance;
267: ELSIF (p_action = 'UPDATE') THEN
268: -- Call all the procedures related to Before Update.

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: ELSIF (p_action = 'VALIDATE_DELETE') THEN
284: check_child_existance;
285: END IF;

Line 357: app_exception.raise_exception;

353: END IF;
354: ELSE
355: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
356: igs_ge_msg_stack.add;
357: app_exception.raise_exception;
358: END IF;
359:
360: SELECT igf_sl_dl_pnote_resp_all_s.NEXTVAL
361: INTO x_dlpnr_id

Line 493: app_exception.raise_exception;

489: IF (c1%notfound) THEN
490: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
491: igs_ge_msg_stack.add;
492: CLOSE c1;
493: app_exception.raise_exception;
494: RETURN;
495: END IF;
496: CLOSE c1;
497:

Line 514: app_exception.raise_exception;

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

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',