APPS.IGS_PE_NONIMG_STAT_PKG dependencies on IGS_SC_GEN_001

Line 516: igs_sc_gen_001.set_ctx('R');

512: x_cancel_flag => x_cancel_flag
513: );
514:
515: IF (x_mode = 'S') THEN
516: igs_sc_gen_001.set_ctx('R');
517: END IF;
518: INSERT INTO igs_pe_nonimg_stat (
519: nonimg_stat_id,
520: nonimg_form_id,

Line 552: igs_sc_gen_001.unset_ctx('R');

548: new_references.print_flag,
549: new_references.cancel_flag
550: ) RETURNING ROWID, nonimg_stat_id INTO x_rowid, x_nonimg_stat_id;
551: IF (x_mode = 'S') THEN
552: igs_sc_gen_001.unset_ctx('R');
553: END IF;
554:
555:
556: IF new_references.action_type IN ('C','T','CP') THEN

Line 567: igs_sc_gen_001.unset_ctx('R');

563: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
564: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
565: fnd_message.set_token ('ERR_CD', SQLCODE);
566: igs_ge_msg_stack.add;
567: igs_sc_gen_001.unset_ctx('R');
568: app_exception.raise_exception;
569: ELSE
570: igs_sc_gen_001.unset_ctx('R');
571: RAISE;

Line 570: igs_sc_gen_001.unset_ctx('R');

566: igs_ge_msg_stack.add;
567: igs_sc_gen_001.unset_ctx('R');
568: app_exception.raise_exception;
569: ELSE
570: igs_sc_gen_001.unset_ctx('R');
571: RAISE;
572: END IF;
573: END insert_row;
574:

Line 719: igs_sc_gen_001.set_ctx('R');

715: x_cancel_flag => x_cancel_flag
716: );
717:
718: IF (x_mode = 'S') THEN
719: igs_sc_gen_001.set_ctx('R');
720: END IF;
721: UPDATE igs_pe_nonimg_stat
722: SET
723: nonimg_form_id = new_references.nonimg_form_id,

Line 740: igs_sc_gen_001.unset_ctx('R');

736:
737: IF (SQL%NOTFOUND) THEN
738: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
739: igs_ge_msg_stack.add;
740: igs_sc_gen_001.unset_ctx('R');
741: app_exception.raise_exception;
742: END IF;
743: IF (x_mode = 'S') THEN
744: igs_sc_gen_001.unset_ctx('R');

Line 744: igs_sc_gen_001.unset_ctx('R');

740: igs_sc_gen_001.unset_ctx('R');
741: app_exception.raise_exception;
742: END IF;
743: IF (x_mode = 'S') THEN
744: igs_sc_gen_001.unset_ctx('R');
745: END IF;
746:
747:
748:

Line 755: igs_sc_gen_001.unset_ctx('R');

751: IF (SQLCODE = (-28115)) THEN
752: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
753: fnd_message.set_token ('ERR_CD', SQLCODE);
754: igs_ge_msg_stack.add;
755: igs_sc_gen_001.unset_ctx('R');
756: app_exception.raise_exception;
757: ELSE
758: igs_sc_gen_001.unset_ctx('R');
759: RAISE;

Line 758: igs_sc_gen_001.unset_ctx('R');

754: igs_ge_msg_stack.add;
755: igs_sc_gen_001.unset_ctx('R');
756: app_exception.raise_exception;
757: ELSE
758: igs_sc_gen_001.unset_ctx('R');
759: RAISE;
760: END IF;
761: END update_row;
762:

Line 854: igs_sc_gen_001.set_ctx('R');

850: x_rowid => x_rowid
851: );
852:
853: IF (x_mode = 'S') THEN
854: igs_sc_gen_001.set_ctx('R');
855: END IF;
856: DELETE FROM igs_pe_nonimg_stat
857: WHERE rowid = x_rowid;
858:

Line 862: igs_sc_gen_001.unset_ctx('R');

858:
859: IF (SQL%NOTFOUND) THEN
860: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
861: igs_ge_msg_stack.add;
862: igs_sc_gen_001.unset_ctx('R');
863: app_exception.raise_exception;
864: END IF;
865: IF (x_mode = 'S') THEN
866: igs_sc_gen_001.unset_ctx('R');

Line 866: igs_sc_gen_001.unset_ctx('R');

862: igs_sc_gen_001.unset_ctx('R');
863: app_exception.raise_exception;
864: END IF;
865: IF (x_mode = 'S') THEN
866: igs_sc_gen_001.unset_ctx('R');
867: END IF;
868:
869:
870: END delete_row;