APPS.IGS_HE_UT_PRS_CALCS_PKG dependencies on APP_EXCEPTION

Line 47: app_exception.raise_exception;

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

Line 92: app_exception.raise_exception;

88: 'N'
89: ) THEN
90: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
91: igs_ge_msg_stack.add;
92: app_exception.raise_exception;
93: END IF;
94:
95: END check_parent_existance;
96:

Line 199: app_exception.raise_exception;

195: )
196: ) THEN
197: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
198: igs_ge_msg_stack.add;
199: app_exception.raise_exception;
200: END IF;
201: check_parent_existance;
202: ELSIF (p_action = 'VALIDATE_INSERT') THEN
203: -- Call all the procedures related to Before Insert.

Line 211: app_exception.raise_exception;

207: )
208: ) THEN
209: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
210: igs_ge_msg_stack.add;
211: app_exception.raise_exception;
212: END IF;
213:
214: ELSIF (p_action = 'DELETE') THEN
215: -- Call all the procedures related to Before Delete.

Line 268: app_exception.raise_exception;

264: ELSE
265: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
266: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRS_CALCS_PKG.INSERT_ROW');
267: igs_ge_msg_stack.add;
268: app_exception.raise_exception;
269: END IF;
270:
271: before_dml(
272: p_action => 'INSERT',

Line 321: app_exception.raise_exception;

317: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
318: fnd_message.set_token ('ERR_CD', SQLCODE);
319: igs_ge_msg_stack.add;
320: igs_sc_gen_001.unset_ctx('R');
321: app_exception.raise_exception;
322: ELSE
323: igs_sc_gen_001.unset_ctx('R');
324: RAISE;
325: END IF;

Line 361: app_exception.raise_exception;

357: IF (c1%notfound) THEN
358: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
359: igs_ge_msg_stack.add;
360: CLOSE c1;
361: app_exception.raise_exception;
362: RETURN;
363: END IF;
364: CLOSE c1;
365:

Line 373: app_exception.raise_exception;

369: NULL;
370: ELSE
371: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
372: igs_ge_msg_stack.add;
373: app_exception.raise_exception;
374: END IF;
375:
376: RETURN;
377:

Line 420: app_exception.raise_exception;

416: ELSE
417: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
418: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRS_CALCS_PKG.UPDATE_ROW');
419: igs_ge_msg_stack.add;
420: app_exception.raise_exception;
421: END IF;
422:
423: before_dml(
424: p_action => 'UPDATE',

Line 451: app_exception.raise_exception;

447: IF (SQL%NOTFOUND) THEN
448: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
449: igs_ge_msg_stack.add;
450: igs_sc_gen_001.unset_ctx('R');
451: app_exception.raise_exception;
452: END IF;
453: IF (x_mode = 'S') THEN
454: igs_sc_gen_001.unset_ctx('R');
455: END IF;

Line 467: app_exception.raise_exception;

463: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
464: fnd_message.set_token ('ERR_CD', SQLCODE);
465: igs_ge_msg_stack.add;
466: igs_sc_gen_001.unset_ctx('R');
467: app_exception.raise_exception;
468: ELSE
469: igs_sc_gen_001.unset_ctx('R');
470: RAISE;
471: END IF;

Line 557: app_exception.raise_exception;

553: IF (SQL%NOTFOUND) THEN
554: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
555: igs_ge_msg_stack.add;
556: igs_sc_gen_001.unset_ctx('R');
557: app_exception.raise_exception;
558: END IF;
559: IF (x_mode = 'S') THEN
560: igs_sc_gen_001.unset_ctx('R');
561: END IF;