APPS.IGS_HE_ST_SPA_CC_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 99: app_exception.raise_exception;

95: )
96: ) THEN
97: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
98: igs_ge_msg_stack.add;
99: app_exception.raise_exception;
100: END IF;
101:
102: END check_uniqueness;
103:

Line 232: app_exception.raise_exception;

228: )
229: ) THEN
230: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
231: igs_ge_msg_stack.add;
232: app_exception.raise_exception;
233: END IF;
234: check_uniqueness;
235: ELSIF (p_action = 'UPDATE') THEN
236: -- Call all the procedures related to Before Update.

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 = 'VALIDATE_UPDATE') THEN
250: check_uniqueness;

Line 303: app_exception.raise_exception;

299: ELSE
300: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
301: fnd_message.set_token ('ROUTINE', 'IGS_HE_ST_SPA_CC_PKG.INSERT_ROW');
302: igs_ge_msg_stack.add;
303: app_exception.raise_exception;
304: END IF;
305:
306: x_he_spa_cc_id := NULL;
307:

Line 367: app_exception.raise_exception;

363: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
364: fnd_message.set_token ('ERR_CD', SQLCODE);
365: igs_ge_msg_stack.add;
366: igs_sc_gen_001.unset_ctx('R');
367: app_exception.raise_exception;
368: ELSE
369: igs_sc_gen_001.unset_ctx('R');
370: RAISE;
371: END IF;

Line 414: app_exception.raise_exception;

410: IF (c1%notfound) THEN
411: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
412: igs_ge_msg_stack.add;
413: CLOSE c1;
414: app_exception.raise_exception;
415: RETURN;
416: END IF;
417: CLOSE c1;
418:

Line 430: app_exception.raise_exception;

426: NULL;
427: ELSE
428: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
429: igs_ge_msg_stack.add;
430: app_exception.raise_exception;
431: END IF;
432:
433: RETURN;
434:

Line 480: app_exception.raise_exception;

476: ELSE
477: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
478: fnd_message.set_token ('ROUTINE', 'IGS_HE_ST_SPA_CC_PKG.UPDATE_ROW');
479: igs_ge_msg_stack.add;
480: app_exception.raise_exception;
481: END IF;
482:
483: before_dml(
484: p_action => 'UPDATE',

Line 518: app_exception.raise_exception;

514: IF (SQL%NOTFOUND) THEN
515: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
516: igs_ge_msg_stack.add;
517: igs_sc_gen_001.unset_ctx('R');
518: app_exception.raise_exception;
519: END IF;
520: IF (x_mode = 'S') THEN
521: igs_sc_gen_001.unset_ctx('R');
522: END IF;

Line 534: app_exception.raise_exception;

530: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
531: fnd_message.set_token ('ERR_CD', SQLCODE);
532: igs_ge_msg_stack.add;
533: igs_sc_gen_001.unset_ctx('R');
534: app_exception.raise_exception;
535: ELSE
536: igs_sc_gen_001.unset_ctx('R');
537: RAISE;
538: END IF;

Line 632: app_exception.raise_exception;

628: IF (SQL%NOTFOUND) THEN
629: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
630: igs_ge_msg_stack.add;
631: igs_sc_gen_001.unset_ctx('R');
632: app_exception.raise_exception;
633: END IF;
634: IF (x_mode = 'S') THEN
635: igs_sc_gen_001.unset_ctx('R');
636: END IF;