APPS.IGS_HE_EN_SUSA_PKG dependencies on APP_EXCEPTION

Line 98: app_exception.raise_exception;

94: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
95: CLOSE cur_old_ref_values;
96: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
97: igs_ge_msg_stack.add;
98: app_exception.raise_exception;
99: RETURN;
100: END IF;
101: CLOSE cur_old_ref_values;
102:

Line 194: app_exception.raise_exception;

190: )
191: ) THEN
192: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
193: igs_ge_msg_stack.add;
194: app_exception.raise_exception;
195: END IF;
196:
197: END check_uniqueness;
198:

Line 229: app_exception.raise_exception;

225: new_references.sequence_number
226: ) THEN
227: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
228: igs_ge_msg_stack.add;
229: app_exception.raise_exception;
230: END IF;
231:
232: END check_parent_existance;
233:

Line 344: app_exception.raise_exception;

340: IF (cur_rowid%FOUND) THEN
341: CLOSE cur_rowid;
342: fnd_message.set_name ('IGS', 'HES_ASS_FKIGS_AS_SU_SETATMPT');
343: igs_ge_msg_stack.add;
344: app_exception.raise_exception;
345: RETURN;
346: END IF;
347: CLOSE cur_rowid;
348:

Line 497: app_exception.raise_exception;

493: )
494: ) THEN
495: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
496: igs_ge_msg_stack.add;
497: app_exception.raise_exception;
498: END IF;
499: check_uniqueness;
500: check_parent_existance;
501: ELSIF (p_action = 'UPDATE') THEN

Line 513: app_exception.raise_exception;

509: )
510: ) THEN
511: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
512: igs_ge_msg_stack.add;
513: app_exception.raise_exception;
514: END IF;
515: check_uniqueness;
516: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
517: check_uniqueness;

Line 617: app_exception.raise_exception;

613: END IF;
614: ELSE
615: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
616: igs_ge_msg_stack.add;
617: app_exception.raise_exception;
618: END IF;
619:
620: SELECT igs_he_en_susa_s.NEXTVAL
621: INTO x_hesa_en_susa_id

Line 827: app_exception.raise_exception;

823: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
824: fnd_message.set_token ('ERR_CD', SQLCODE);
825: igs_ge_msg_stack.add;
826: igs_sc_gen_001.unset_ctx('R');
827: app_exception.raise_exception;
828: ELSE
829: igs_sc_gen_001.unset_ctx('R');
830: RAISE;
831: END IF;

Line 969: app_exception.raise_exception;

965: IF (c1%notfound) THEN
966: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
967: igs_ge_msg_stack.add;
968: CLOSE c1;
969: app_exception.raise_exception;
970: RETURN;
971: END IF;
972: CLOSE c1;
973:

Line 1031: app_exception.raise_exception;

1027: NULL;
1028: ELSE
1029: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1030: igs_ge_msg_stack.add;
1031: app_exception.raise_exception;
1032: END IF;
1033:
1034: RETURN;
1035:

Line 1128: app_exception.raise_exception;

1124: END IF;
1125: ELSE
1126: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1127: igs_ge_msg_stack.add;
1128: app_exception.raise_exception;
1129: END IF;
1130:
1131: before_dml(
1132: p_action => 'UPDATE',

Line 1258: app_exception.raise_exception;

1254: IF (SQL%NOTFOUND) THEN
1255: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1256: igs_ge_msg_stack.add;
1257: igs_sc_gen_001.unset_ctx('R');
1258: app_exception.raise_exception;
1259: END IF;
1260: IF (x_mode = 'S') THEN
1261: igs_sc_gen_001.unset_ctx('R');
1262: END IF;

Line 1271: app_exception.raise_exception;

1267: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1268: fnd_message.set_token ('ERR_CD', SQLCODE);
1269: igs_ge_msg_stack.add;
1270: igs_sc_gen_001.unset_ctx('R');
1271: app_exception.raise_exception;
1272: ELSE
1273: igs_sc_gen_001.unset_ctx('R');
1274: RAISE;
1275: END IF;

Line 1509: app_exception.raise_exception;

1505: IF (SQL%NOTFOUND) THEN
1506: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1507: igs_ge_msg_stack.add;
1508: igs_sc_gen_001.unset_ctx('R');
1509: app_exception.raise_exception;
1510: END IF;
1511: IF (x_mode = 'S') THEN
1512: igs_sc_gen_001.unset_ctx('R');
1513: END IF;