APPS.IGS_AD_APLINS_ADMREQ_PKG dependencies on IGS_SC_GEN_001

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

596: x_last_update_login => x_last_update_login
597: );
598:
599: IF (x_mode = 'S') THEN
600: igs_sc_gen_001.set_ctx('R');
601: END IF;
602: INSERT INTO igs_ad_aplins_admreq (
603: aplins_admreq_id,
604: person_id,

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

632: x_program_application_id,
633: x_program_update_date
634: )RETURNING aplins_admreq_id INTO x_aplins_admreq_id;
635: IF (x_mode = 'S') THEN
636: igs_sc_gen_001.unset_ctx('R');
637: END IF;
638:
639:
640: OPEN c;

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

647:
648: EXCEPTION
649: WHEN OTHERS THEN
650: IF (x_mode = 'S') THEN
651: igs_sc_gen_001.unset_ctx('R');
652: END IF;
653: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
654: -- Code to handle Security Policy error raised
655: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

808: END IF;
809: END IF;
810:
811: IF (x_mode = 'S') THEN
812: igs_sc_gen_001.set_ctx('R');
813: END IF;
814: UPDATE igs_ad_aplins_admreq
815: SET
816: person_id = new_references.person_id,

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

830: IF (SQL%NOTFOUND) THEN
831: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
832: igs_ge_msg_stack.add;
833: IF (x_mode = 'S') THEN
834: igs_sc_gen_001.set_ctx('R');
835: END IF;
836: app_exception.raise_exception;
837: END IF;
838: IF (x_mode = 'S') THEN

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

835: END IF;
836: app_exception.raise_exception;
837: END IF;
838: IF (x_mode = 'S') THEN
839: igs_sc_gen_001.unset_ctx('R');
840: END IF;
841:
842:
843: EXCEPTION

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

842:
843: EXCEPTION
844: WHEN OTHERS THEN
845: IF (x_mode = 'S') THEN
846: igs_sc_gen_001.set_ctx('R');
847: END IF;
848: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
849: -- Code to handle Security Policy error raised
850: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

941: x_rowid => x_rowid
942: );
943:
944: IF (x_mode = 'S') THEN
945: igs_sc_gen_001.set_ctx('R');
946: END IF;
947: DELETE FROM igs_ad_aplins_admreq
948: WHERE rowid = x_rowid;
949:

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

950: IF (SQL%NOTFOUND) THEN
951: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
952: igs_ge_msg_stack.add;
953: IF (x_mode = 'S') THEN
954: igs_sc_gen_001.set_ctx('R');
955: END IF;
956: app_exception.raise_exception;
957: END IF;
958: IF (x_mode = 'S') THEN

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

955: END IF;
956: app_exception.raise_exception;
957: END IF;
958: IF (x_mode = 'S') THEN
959: igs_sc_gen_001.unset_ctx('R');
960: END IF;
961:
962:
963: EXCEPTION

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

962:
963: EXCEPTION
964: WHEN OTHERS THEN
965: IF (x_mode = 'S') THEN
966: igs_sc_gen_001.unset_ctx('R');
967: END IF;
968: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
969: -- Code to handle Security Policy error raised
970: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.