APPS.IGS_PS_EMP_CATS_WL_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: new_references.cal_cat_code
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 162: app_exception.raise_exception;

158: IF (cur_rowid%FOUND) THEN
159: CLOSE cur_rowid;
160: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
161: igs_ge_msg_stack.add;
162: app_exception.raise_exception;
163: RETURN;
164: END IF;
165: CLOSE cur_rowid;
166:

Line 207: app_exception.raise_exception;

203:
204: IF l_error THEN
205: fnd_message.set_name('IGS','IGS_PS_DECREASE_NOT_EXP_WL');
206: igs_ge_msg_stack.add;
207: app_exception.raise_exception;
208: END IF;
209:
210: END IF;
211: END check_expected_wl_num;

Line 259: app_exception.raise_exception;

255: )
256: ) THEN
257: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
258: igs_ge_msg_stack.add;
259: app_exception.raise_exception;
260: END IF;
261: check_parent_existance;
262: ELSIF (p_action = 'UPDATE') THEN
263: -- Call all the procedures related to Before Update.

Line 274: app_exception.raise_exception;

270: )
271: ) THEN
272: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
273: igs_ge_msg_stack.add;
274: app_exception.raise_exception;
275: END IF;
276: END IF;
277:
278: END before_dml;

Line 321: app_exception.raise_exception;

317: ELSE
318: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
319: fnd_message.set_token ('ROUTINE', 'igs_ps_emp_cats_wl_PKG.INSERT_ROW');
320: igs_ge_msg_stack.add;
321: app_exception.raise_exception;
322: END IF;
323:
324: before_dml(
325: p_action => 'INSERT',

Line 392: app_exception.raise_exception;

388: IF (c1%notfound) THEN
389: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
390: igs_ge_msg_stack.add;
391: CLOSE c1;
392: app_exception.raise_exception;
393: RETURN;
394: END IF;
395: CLOSE c1;
396:

Line 404: app_exception.raise_exception;

400: NULL;
401: ELSE
402: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
403: igs_ge_msg_stack.add;
404: app_exception.raise_exception;
405: END IF;
406:
407: RETURN;
408:

Line 451: app_exception.raise_exception;

447: ELSE
448: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
449: fnd_message.set_token ('ROUTINE', 'igs_ps_emp_cats_wl_PKG.UPDATE_ROW');
450: igs_ge_msg_stack.add;
451: app_exception.raise_exception;
452: END IF;
453:
454: before_dml(
455: p_action => 'UPDATE',