APPS.IGS_PE_HZ_REL_PKG dependencies on IGS_GE_MSG_STACK

Line 54: igs_ge_msg_stack.add;

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

Line 330: igs_ge_msg_stack.add;

326: */
327: BEGIN
328: IF new_references.primary = 'Y' AND new_references.secondary = 'Y' THEN
329: fnd_message.set_name('IGS', 'IGS_AD_NOT_BOTH_PRIM_SEC');
330: igs_ge_msg_stack.add;
331: app_exception.raise_exception;
332: END IF;
333: END before_row_insert_update;
334:

Line 364: igs_ge_msg_stack.add;

360: FETCH rel_pk INTO l_var;
361: IF rel_pk%NOTFOUND THEN
362: CLOSE rel_pk;
363: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
364: igs_ge_msg_stack.add;
365: app_exception.raise_exception;
366: END IF;
367: CLOSE rel_pk;
368: END IF;

Line 470: igs_ge_msg_stack.add;

466: new_references.directional_flag
467: )
468: ) THEN
469: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
470: igs_ge_msg_stack.add;
471: app_exception.raise_exception;
472: END IF;
473: check_parent_existance;
474: before_row_insert_update;

Line 487: igs_ge_msg_stack.add;

483: new_references.directional_flag
484: )
485: ) THEN
486: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
487: igs_ge_msg_stack.add;
488: app_exception.raise_exception;
489: END IF;
490: before_row_insert_update;
491: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 584: igs_ge_msg_stack.add;

580: END IF;
581: ELSE
582: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
583: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_REL_PKG.INSERT_ROW');
584: igs_ge_msg_stack.add;
585: app_exception.raise_exception;
586: END IF;
587:
588: before_dml(

Line 702: igs_ge_msg_stack.add;

698: WHEN OTHERS THEN
699: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
700: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
701: fnd_message.set_token ('ERR_CD', SQLCODE);
702: igs_ge_msg_stack.add;
703: igs_sc_gen_001.unset_ctx('R');
704: app_exception.raise_exception;
705: ELSE
706: igs_sc_gen_001.unset_ctx('R');

Line 758: igs_ge_msg_stack.add;

754: OPEN c1;
755: FETCH c1 INTO tlinfo;
756: IF (c1%notfound) THEN
757: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
758: igs_ge_msg_stack.add;
759: CLOSE c1;
760: app_exception.raise_exception;
761: RETURN;
762: END IF;

Line 779: igs_ge_msg_stack.add;

775: ) THEN
776: NULL;
777: ELSE
778: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
779: igs_ge_msg_stack.add;
780: app_exception.raise_exception;
781: END IF;
782:
783: RETURN;

Line 834: igs_ge_msg_stack.add;

830: END IF;
831: ELSE
832: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
833: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_REL_PKG.UPDATE_ROW');
834: igs_ge_msg_stack.add;
835: app_exception.raise_exception;
836: END IF;
837:
838: before_dml(

Line 900: igs_ge_msg_stack.add;

896: END IF;
897:
898: IF (SQL%NOTFOUND) THEN
899: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
900: igs_ge_msg_stack.add;
901: igs_sc_gen_001.unset_ctx('R');
902: app_exception.raise_exception;
903: END IF;
904: IF (x_mode = 'S') THEN

Line 917: igs_ge_msg_stack.add;

913: WHEN OTHERS THEN
914: IF (SQLCODE = (-28115)) THEN
915: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
916: fnd_message.set_token ('ERR_CD', SQLCODE);
917: igs_ge_msg_stack.add;
918: igs_sc_gen_001.unset_ctx('R');
919: app_exception.raise_exception;
920: ELSE
921: igs_sc_gen_001.unset_ctx('R');

Line 1030: igs_ge_msg_stack.add;

1026: WHERE rowid = x_rowid;
1027:
1028: IF (SQL%NOTFOUND) THEN
1029: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1030: igs_ge_msg_stack.add;
1031: igs_sc_gen_001.unset_ctx('R');
1032: app_exception.raise_exception;
1033: END IF;
1034: IF (x_mode = 'S') THEN