DBA Data[Home] [Help]

APPS.IGS_PE_NONIMG_EMPL_PKG dependencies on IGS_GE_MSG_STACK

Line 56: igs_ge_msg_stack.add;

52: FETCH cur_old_ref_values INTO old_references;
53: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
54: CLOSE cur_old_ref_values;
55: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
56: igs_ge_msg_stack.add;
57: app_exception.raise_exception;
58: RETURN;
59: END IF;
60: CLOSE cur_old_ref_values;

Line 108: igs_ge_msg_stack.add;

104: ((new_references.nonimg_form_id IS NULL))) THEN
105: NULL;
106: ELSIF NOT igs_pe_nonimg_form_pkg.get_pk_for_validation ( new_references.nonimg_form_id ) THEN
107: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
108: igs_ge_msg_stack.add;
109: app_exception.raise_exception;
110: END IF;
111:
112: END check_parent_existance;

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_PE_PENEM_PENIF_FK');
174: igs_ge_msg_stack.add;
175: app_exception.raise_exception;
176: RETURN;
177: END IF;
178: CLOSE cur_rowid;

Line 244: igs_ge_msg_stack.add;

240: IF (p_action = 'INSERT') THEN
241: -- Call all the procedures related to Before Insert.
242: IF ( get_pk_for_validation( new_references.nonimg_empl_id ) ) THEN
243: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
244: igs_ge_msg_stack.add;
245: app_exception.raise_exception;
246: END IF;
247: check_parent_existance;
248: ELSIF (p_action = 'UPDATE') THEN

Line 255: igs_ge_msg_stack.add;

251: ELSIF (p_action = 'VALIDATE_INSERT') THEN
252: -- Call all the procedures related to Before Insert.
253: IF ( get_pk_for_validation ( new_references.nonimg_empl_id ) ) 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 311: igs_ge_msg_stack.add;

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

Line 391: igs_ge_msg_stack.add;

387: WHEN OTHERS THEN
388: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
389: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
390: fnd_message.set_token ('ERR_CD', SQLCODE);
391: igs_ge_msg_stack.add;
392: igs_sc_gen_001.unset_ctx('R');
393: app_exception.raise_exception;
394: ELSE
395: igs_sc_gen_001.unset_ctx('R');

Line 452: igs_ge_msg_stack.add;

448: OPEN c1;
449: FETCH c1 INTO tlinfo;
450: IF (c1%notfound) THEN
451: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
452: igs_ge_msg_stack.add;
453: CLOSE c1;
454: app_exception.raise_exception;
455: RETURN;
456: END IF;

Line 476: igs_ge_msg_stack.add;

472: ) THEN
473: NULL;
474: ELSE
475: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
476: igs_ge_msg_stack.add;
477: app_exception.raise_exception;
478: END IF;
479:
480: RETURN;

Line 532: igs_ge_msg_stack.add;

528: x_last_update_login := -1;
529: END IF;
530: ELSE
531: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
532: igs_ge_msg_stack.add;
533: app_exception.raise_exception;
534: END IF;
535:
536: before_dml(

Line 583: igs_ge_msg_stack.add;

579: WHERE rowid = x_rowid;
580:
581: IF (SQL%NOTFOUND) THEN
582: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
583: igs_ge_msg_stack.add;
584: igs_sc_gen_001.unset_ctx('R');
585: app_exception.raise_exception;
586: END IF;
587: IF (x_mode = 'S') THEN

Line 598: igs_ge_msg_stack.add;

594: WHEN OTHERS THEN
595: IF (SQLCODE = (-28115)) THEN
596: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
597: fnd_message.set_token ('ERR_CD', SQLCODE);
598: igs_ge_msg_stack.add;
599: igs_sc_gen_001.unset_ctx('R');
600: app_exception.raise_exception;
601: ELSE
602: igs_sc_gen_001.unset_ctx('R');

Line 716: igs_ge_msg_stack.add;

712: WHERE rowid = x_rowid;
713:
714: IF (SQL%NOTFOUND) THEN
715: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
716: igs_ge_msg_stack.add;
717: igs_sc_gen_001.unset_ctx('R');
718: app_exception.raise_exception;
719: END IF;
720: IF (x_mode = 'S') THEN