APPS.IGS_HE_EN_SUSA_CC_PKG dependencies on APP_EXCEPTION

Line 52: app_exception.raise_exception;

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

Line 105: app_exception.raise_exception;

101: )
102: ) THEN
103: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
104: igs_ge_msg_stack.add;
105: app_exception.raise_exception;
106: END IF;
107:
108: END check_uniqueness;
109:

Line 246: app_exception.raise_exception;

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

Line 260: app_exception.raise_exception;

256: )
257: ) THEN
258: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
259: igs_ge_msg_stack.add;
260: app_exception.raise_exception;
261: END IF;
262: check_uniqueness;
263: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
264: check_uniqueness;

Line 319: app_exception.raise_exception;

315: ELSE
316: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
317: fnd_message.set_token ('ROUTINE', 'IGS_HE_EN_SUSA_CC_PKG.INSERT_ROW');
318: igs_ge_msg_stack.add;
319: app_exception.raise_exception;
320: END IF;
321:
322: x_he_susa_cc_id := NULL;
323:

Line 389: app_exception.raise_exception;

385: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
386: fnd_message.set_token ('ERR_CD', SQLCODE);
387: igs_ge_msg_stack.add;
388: igs_sc_gen_001.unset_ctx('R');
389: app_exception.raise_exception;
390: ELSE
391: igs_sc_gen_001.unset_ctx('R');
392: RAISE;
393: END IF;

Line 440: app_exception.raise_exception;

436: IF (c1%notfound) THEN
437: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
438: igs_ge_msg_stack.add;
439: CLOSE c1;
440: app_exception.raise_exception;
441: RETURN;
442: END IF;
443: CLOSE c1;
444:

Line 458: app_exception.raise_exception;

454: NULL;
455: ELSE
456: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
457: igs_ge_msg_stack.add;
458: app_exception.raise_exception;
459: END IF;
460:
461: RETURN;
462:

Line 510: app_exception.raise_exception;

506: ELSE
507: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
508: fnd_message.set_token ('ROUTINE', 'IGS_HE_EN_SUSA_CC_PKG.UPDATE_ROW');
509: igs_ge_msg_stack.add;
510: app_exception.raise_exception;
511: END IF;
512:
513: before_dml(
514: p_action => 'UPDATE',

Line 552: app_exception.raise_exception;

548: IF (SQL%NOTFOUND) THEN
549: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
550: igs_ge_msg_stack.add;
551: igs_sc_gen_001.unset_ctx('R');
552: app_exception.raise_exception;
553: END IF;
554: IF (x_mode = 'S') THEN
555: igs_sc_gen_001.unset_ctx('R');
556: END IF;

Line 568: app_exception.raise_exception;

564: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
565: fnd_message.set_token ('ERR_CD', SQLCODE);
566: igs_ge_msg_stack.add;
567: igs_sc_gen_001.unset_ctx('R');
568: app_exception.raise_exception;
569: ELSE
570: igs_sc_gen_001.unset_ctx('R');
571: RAISE;
572: END IF;

Line 672: app_exception.raise_exception;

668: IF (SQL%NOTFOUND) THEN
669: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
670: igs_ge_msg_stack.add;
671: igs_sc_gen_001.unset_ctx('R');
672: app_exception.raise_exception;
673: END IF;
674: IF (x_mode = 'S') THEN
675: igs_sc_gen_001.unset_ctx('R');
676: END IF;