APPS.IGS_PE_NONIMG_EMPL_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 109: app_exception.raise_exception;

105: NULL;
106: ELSIF NOT igs_pe_nonimg_form_pkg.get_pk_for_validation ( new_references.nonimg_form_id ) 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 175: app_exception.raise_exception;

171: IF (cur_rowid%FOUND) THEN
172: CLOSE cur_rowid;
173: fnd_message.set_name ('IGS', 'IGS_PE_PENEM_PENIF_FK');
174: igs_ge_msg_stack.add;
175: app_exception.raise_exception;
176: RETURN;
177: END IF;
178: CLOSE cur_rowid;
179:

Line 245: app_exception.raise_exception;

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

Line 256: app_exception.raise_exception;

252: -- Call all the procedures related to Before Insert.
253: IF ( get_pk_for_validation ( new_references.nonimg_empl_id ) ) THEN
254: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
255: igs_ge_msg_stack.add;
256: app_exception.raise_exception;
257: END IF;
258: END IF;
259:
260: END before_dml;

Line 312: app_exception.raise_exception;

308: END IF;
309: ELSE
310: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
311: igs_ge_msg_stack.add;
312: app_exception.raise_exception;
313: END IF;
314:
315: before_dml(
316: p_action => 'INSERT',

Line 393: app_exception.raise_exception;

389: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
390: fnd_message.set_token ('ERR_CD', SQLCODE);
391: igs_ge_msg_stack.add;
392: igs_sc_gen_001.unset_ctx('R');
393: app_exception.raise_exception;
394: ELSE
395: igs_sc_gen_001.unset_ctx('R');
396: RAISE;
397: END IF;

Line 454: app_exception.raise_exception;

450: IF (c1%notfound) THEN
451: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
452: igs_ge_msg_stack.add;
453: CLOSE c1;
454: app_exception.raise_exception;
455: RETURN;
456: END IF;
457: CLOSE c1;
458:

Line 477: app_exception.raise_exception;

473: NULL;
474: ELSE
475: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
476: igs_ge_msg_stack.add;
477: app_exception.raise_exception;
478: END IF;
479:
480: RETURN;
481:

Line 533: app_exception.raise_exception;

529: END IF;
530: ELSE
531: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
532: igs_ge_msg_stack.add;
533: app_exception.raise_exception;
534: END IF;
535:
536: before_dml(
537: p_action => 'UPDATE',

Line 585: app_exception.raise_exception;

581: IF (SQL%NOTFOUND) THEN
582: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
583: igs_ge_msg_stack.add;
584: igs_sc_gen_001.unset_ctx('R');
585: app_exception.raise_exception;
586: END IF;
587: IF (x_mode = 'S') THEN
588: igs_sc_gen_001.unset_ctx('R');
589: END IF;

Line 600: app_exception.raise_exception;

596: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
597: fnd_message.set_token ('ERR_CD', SQLCODE);
598: igs_ge_msg_stack.add;
599: igs_sc_gen_001.unset_ctx('R');
600: app_exception.raise_exception;
601: ELSE
602: igs_sc_gen_001.unset_ctx('R');
603: RAISE;
604: END IF;

Line 718: app_exception.raise_exception;

714: IF (SQL%NOTFOUND) THEN
715: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
716: igs_ge_msg_stack.add;
717: igs_sc_gen_001.unset_ctx('R');
718: app_exception.raise_exception;
719: END IF;
720: IF (x_mode = 'S') THEN
721: igs_sc_gen_001.unset_ctx('R');
722: END IF;