APPS.IGS_AD_HZ_EMP_DTL_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 107: App_Exception.Raise_Exception;

103: Fetch cur_rowid INTO lv_rowid;
104: IF (cur_rowid%NOTFOUND) THEN
105: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
106: IGS_GE_MSG_STACK.ADD;
107: App_Exception.Raise_Exception;
108: END IF;
109: Close cur_rowid;
110: END IF;
111:

Line 175: app_exception.raise_exception;

171: IF (cur_rowid%FOUND) THEN
172: CLOSE cur_rowid;
173: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
174: igs_ge_msg_stack.add;
175: app_exception.raise_exception;
176: RETURN;
177: END IF;
178: CLOSE cur_rowid;
179:

Line 237: app_exception.raise_exception;

233: )
234: ) THEN
235: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
236: igs_ge_msg_stack.add;
237: app_exception.raise_exception;
238: END IF;
239: check_parent_existance;
240: ELSIF (p_action = 'UPDATE') THEN
241: -- Call all the procedures related to Before Update.

Line 256: app_exception.raise_exception;

252: )
253: ) THEN
254: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
255: igs_ge_msg_stack.add;
256: app_exception.raise_exception;
257: END IF;
258: END IF;
259:
260: END before_dml;

Line 311: app_exception.raise_exception;

307: END IF;
308: ELSE
309: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
310: igs_ge_msg_stack.add;
311: app_exception.raise_exception;
312: END IF;
313:
314: X_HZ_EMP_DTL_ID := -1;
315: before_dml(

Line 386: app_exception.raise_exception;

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

Line 438: app_exception.raise_exception;

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

Line 452: app_exception.raise_exception;

448: NULL;
449: ELSE
450: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
451: igs_ge_msg_stack.add;
452: app_exception.raise_exception;
453: END IF;
454:
455: RETURN;
456:

Line 503: app_exception.raise_exception;

499: END IF;
500: ELSE
501: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
502: igs_ge_msg_stack.add;
503: app_exception.raise_exception;
504: END IF;
505:
506: before_dml(
507: p_action => 'UPDATE',

Line 546: app_exception.raise_exception;

542: IF (SQL%NOTFOUND) THEN
543: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
544: igs_ge_msg_stack.add;
545: igs_sc_gen_001.unset_ctx('R');
546: app_exception.raise_exception;
547: END IF;
548: IF (x_mode = 'S') THEN
549: igs_sc_gen_001.unset_ctx('R');
550: END IF;

Line 561: app_exception.raise_exception;

557: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
558: fnd_message.set_token ('ERR_CD', SQLCODE);
559: igs_ge_msg_stack.add;
560: igs_sc_gen_001.unset_ctx('R');
561: app_exception.raise_exception;
562: ELSE
563: igs_sc_gen_001.unset_ctx('R');
564: RAISE;
565: END IF;

Line 666: app_exception.raise_exception;

662: IF (SQL%NOTFOUND) THEN
663: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
664: igs_ge_msg_stack.add;
665: igs_sc_gen_001.unset_ctx('R');
666: app_exception.raise_exception;
667: END IF;
668: IF (x_mode = 'S') THEN
669: igs_sc_gen_001.unset_ctx('R');
670: END IF;