DBA Data[Home] [Help]

APPS.IGS_AD_HZ_EMP_DTL_PKG dependencies on IGS_GE_MSG_STACK

Line 51: igs_ge_msg_stack.add;

47: FETCH cur_old_ref_values INTO old_references;
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;

Line 106: IGS_GE_MSG_STACK.ADD;

102: Open cur_rowid;
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;

Line 174: igs_ge_msg_stack.add;

170: FETCH cur_rowid INTO lv_rowid;
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;

Line 236: igs_ge_msg_stack.add;

232: new_references.hz_emp_dtl_id
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

Line 255: igs_ge_msg_stack.add;

251: new_references.hz_emp_dtl_id
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:

Line 310: igs_ge_msg_stack.add;

306: x_last_update_login := -1;
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;

Line 384: igs_ge_msg_stack.add;

380: WHEN OTHERS THEN
381: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
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');

Line 436: igs_ge_msg_stack.add;

432: OPEN c1;
433: FETCH c1 INTO tlinfo;
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;

Line 451: igs_ge_msg_stack.add;

447: ) THEN
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;

Line 502: igs_ge_msg_stack.add;

498: x_last_update_login := -1;
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(

Line 544: igs_ge_msg_stack.add;

540: WHERE rowid = x_rowid;
541:
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

Line 559: igs_ge_msg_stack.add;

555: WHEN OTHERS THEN
556: IF (SQLCODE = (-28115)) THEN
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');

Line 664: igs_ge_msg_stack.add;

660: WHERE rowid = x_rowid;
661:
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