APPS.IGS_EN_INST_WL_STPS_PKG dependencies on APP_EXCEPTION

Line 51: app_exception.raise_exception;

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

Line 163: app_exception.raise_exception;

159:
160: IF v_no_recs >1 THEN
161: fnd_message.set_name ('FND', 'IGS_EN_WLST_ONLY_ONE_REC');
162: igs_ge_msg_stack.add;
163: app_exception.raise_exception;
164: END IF;
165: IF get_pk_for_validation(new_references.inst_wlst_setup_id ) THEN
166: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
167: igs_ge_msg_stack.add;

Line 168: app_exception.raise_exception;

164: END IF;
165: IF get_pk_for_validation(new_references.inst_wlst_setup_id ) THEN
166: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
167: igs_ge_msg_stack.add;
168: app_exception.raise_exception;
169: END IF;
170: ELSIF (p_action = 'VALIDATE_INSERT') THEN
171: -- Call all the procedures related to Before Insert.
172: IF get_pk_for_validation (new_references.inst_wlst_setup_id )

Line 176: app_exception.raise_exception;

172: IF get_pk_for_validation (new_references.inst_wlst_setup_id )
173: THEN
174: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
175: igs_ge_msg_stack.add;
176: app_exception.raise_exception;
177: END IF;
178: END IF;
179:
180: IF p_action IN ('VALIDATE_INSERT', 'VALIDATE_UPDATE', 'VALIDATE_DELETE') THEN

Line 261: app_exception.raise_exception;

257: ELSE
258: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
259: fnd_message.set_token ('ROUTINE', 'IGS_EN_INST_WL_STPS_PKG.INSERT_ROW');
260: igs_ge_msg_stack.add;
261: app_exception.raise_exception;
262: END IF;
263:
264: before_dml(
265: p_action => 'INSERT',

Line 360: app_exception.raise_exception;

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

Line 378: app_exception.raise_exception;

374: NULL;
375: ELSE
376: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
377: igs_ge_msg_stack.add;
378: app_exception.raise_exception;
379: END IF;
380:
381: RETURN;
382:

Line 429: app_exception.raise_exception;

425: ELSE
426: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
427: fnd_message.set_token ('ROUTINE', 'IGS_EN_INST_WL_STPS_PKG.UPDATE_ROW');
428: igs_ge_msg_stack.add;
429: app_exception.raise_exception;
430: END IF;
431:
432: before_dml(
433: p_action => 'UPDATE',