eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_OTHER_INST_PKG dependencies on IGS_SC_GEN_001

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

542: x_last_update_login=>X_LAST_UPDATE_LOGIN,
543: x_new_institution=>x_new_institution);
544:
545: IF (x_mode = 'S') THEN
546: igs_sc_gen_001.set_ctx('R');
547: END IF;
548: insert into IGS_AD_OTHER_INST (
549: OTHER_INST_ID
550: ,PERSON_ID

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

576: ,X_PROGRAM_UPDATE_DATE
577: ,X_NEW_INSTITUTION
578: )RETURNING OTHER_INST_ID INTO X_OTHER_INST_ID;
579: IF (x_mode = 'S') THEN
580: igs_sc_gen_001.unset_ctx('R');
581: END IF;
582:
583: open c;
584: fetch c into X_ROWID;

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

592: x_rowid => X_ROWID );
593: EXCEPTION
594: WHEN OTHERS THEN
595: IF (x_mode = 'S') THEN
596: igs_sc_gen_001.unset_ctx('R');
597: END IF;
598: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
599: -- Code to handle Security Policy error raised
600: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

740: end if;
741: end if;
742:
743: IF (x_mode = 'S') THEN
744: igs_sc_gen_001.set_ctx('R');
745: END IF;
746: update IGS_AD_OTHER_INST set
747: PERSON_ID = NEW_REFERENCES.PERSON_ID,
748: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,

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

758: where ROWID = X_ROWID;
759: IF (sql%notfound) THEN
760: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
761: igs_ge_msg_stack.add;
762: igs_sc_gen_001.unset_ctx('R');
763: app_exception.raise_exception;
764: END IF;
765: IF (x_mode = 'S') THEN
766: igs_sc_gen_001.unset_ctx('R');

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

762: igs_sc_gen_001.unset_ctx('R');
763: app_exception.raise_exception;
764: END IF;
765: IF (x_mode = 'S') THEN
766: igs_sc_gen_001.unset_ctx('R');
767: END IF;
768:
769:
770: After_DML (

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

773: );
774: EXCEPTION
775: WHEN OTHERS THEN
776: IF (x_mode = 'S') THEN
777: igs_sc_gen_001.unset_ctx('R');
778: END IF;
779: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
780: -- Code to handle Security Policy error raised
781: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

860: p_action => 'DELETE',
861: x_rowid => X_ROWID
862: );
863: IF (x_mode = 'S') THEN
864: igs_sc_gen_001.set_ctx('R');
865: END IF;
866: delete from IGS_AD_OTHER_INST
867: where ROWID = X_ROWID;
868: if (sql%notfound) then

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

867: where ROWID = X_ROWID;
868: if (sql%notfound) then
869: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
870: igs_ge_msg_stack.add;
871: igs_sc_gen_001.unset_ctx('R');
872: app_exception.raise_exception;
873: end if;
874: IF (x_mode = 'S') THEN
875: igs_sc_gen_001.unset_ctx('R');

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

871: igs_sc_gen_001.unset_ctx('R');
872: app_exception.raise_exception;
873: end if;
874: IF (x_mode = 'S') THEN
875: igs_sc_gen_001.unset_ctx('R');
876: END IF;
877:
878: After_DML (
879: p_action => 'DELETE',

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

881: );
882: EXCEPTION
883: WHEN OTHERS THEN
884: IF (x_mode = 'S') THEN
885: igs_sc_gen_001.unset_ctx('R');
886: END IF;
887: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
888: -- Code to handle Security Policy error raised
889: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.