APPS.IGF_SL_DL_CHG_SEND_PKG dependencies on APP_EXCEPTION

Line 50: app_exception.raise_exception;

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

Line 98: app_exception.raise_exception;

94: new_references.dbth_id
95: ) THEN
96: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
97: igs_ge_msg_stack.add;
98: app_exception.raise_exception;
99: END IF;
100:
101: END check_parent_existance;
102:

Line 166: app_exception.raise_exception;

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

Line 225: app_exception.raise_exception;

221: )
222: ) THEN
223: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
224: igs_ge_msg_stack.add;
225: app_exception.raise_exception;
226: END IF;
227: check_parent_existance;
228: ELSIF (p_action = 'UPDATE') THEN
229: -- Call all the procedures related to Before Update.

Line 239: app_exception.raise_exception;

235: )
236: ) THEN
237: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
238: igs_ge_msg_stack.add;
239: app_exception.raise_exception;
240: END IF;
241: END IF;
242:
243: END before_dml;

Line 309: app_exception.raise_exception;

305: END IF;
306: ELSE
307: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
308: igs_ge_msg_stack.add;
309: app_exception.raise_exception;
310: END IF;
311:
312: SELECT igf_sl_dl_chg_send_s.nextval INTO
313: x_chg_num FROM dual;

Line 419: app_exception.raise_exception;

415: IF (c1%notfound) THEN
416: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
417: igs_ge_msg_stack.add;
418: CLOSE c1;
419: app_exception.raise_exception;
420: RETURN;
421: END IF;
422: CLOSE c1;
423:

Line 435: app_exception.raise_exception;

431: NULL;
432: ELSE
433: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
434: igs_ge_msg_stack.add;
435: app_exception.raise_exception;
436: END IF;
437:
438: RETURN;
439:

Line 488: app_exception.raise_exception;

484: END IF;
485: ELSE
486: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
487: igs_ge_msg_stack.add;
488: app_exception.raise_exception;
489: END IF;
490:
491: before_dml(
492: p_action => 'UPDATE',