APPS.IGS_AD_APPL_ARP_PKG dependencies on IGS_SC_GEN_001

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

540: x_last_update_login => x_last_update_login
541: );
542:
543: IF (x_mode = 'S') THEN
544: igs_sc_gen_001.set_ctx('R');
545: END IF;
546: INSERT INTO igs_ad_appl_arp (
547: appl_arp_id,
548: person_id,

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

578: x_program_application_id,
579: x_program_update_date
580: ) RETURNING appl_arp_id INTO x_appl_arp_id;
581: IF (x_mode = 'S') THEN
582: igs_sc_gen_001.unset_ctx('R');
583: END IF;
584:
585:
586: OPEN c;

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

594:
595: EXCEPTION
596: WHEN OTHERS THEN
597: IF (x_mode = 'S') THEN
598: igs_sc_gen_001.unset_ctx('R');
599: END IF;
600: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
601: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
602: fnd_message.set_token ('ERR_CD', SQLCODE);

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

602: fnd_message.set_token ('ERR_CD', SQLCODE);
603: igs_ge_msg_stack.add;
604: app_exception.raise_exception;
605: ELSE
606: igs_sc_gen_001.unset_ctx('R');
607: RAISE;
608: END IF;
609: END insert_row;
610:

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

756: END IF;
757: END IF;
758:
759: IF (x_mode = 'S') THEN
760: igs_sc_gen_001.set_ctx('R');
761: END IF;
762: UPDATE igs_ad_appl_arp
763: SET
764: person_id = new_references.person_id,

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

779: IF (SQL%NOTFOUND) THEN
780: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
781: igs_ge_msg_stack.add;
782: IF (x_mode = 'S') THEN
783: igs_sc_gen_001.unset_ctx('R');
784: END IF;
785: app_exception.raise_exception;
786: END IF;
787: IF (x_mode = 'S') THEN

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

784: END IF;
785: app_exception.raise_exception;
786: END IF;
787: IF (x_mode = 'S') THEN
788: igs_sc_gen_001.unset_ctx('R');
789: END IF;
790:
791: EXCEPTION
792: WHEN OTHERS THEN

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

790:
791: EXCEPTION
792: WHEN OTHERS THEN
793: IF (x_mode = 'S') THEN
794: igs_sc_gen_001.unset_ctx('R');
795: END IF;
796: IF SQLCODE = '-28115' OR SQLCODE = '-28113' OR SQLCODE = '-28111' THEN
797: -- Code to handle Security Policy error raised
798: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.

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

892: x_rowid => x_rowid
893: );
894:
895: IF (x_mode = 'S') THEN
896: igs_sc_gen_001.set_ctx('R');
897: END IF;
898: DELETE FROM igs_ad_appl_arp
899: WHERE rowid = x_rowid;
900:

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

901: IF (SQL%NOTFOUND) THEN
902: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
903: igs_ge_msg_stack.add;
904: IF (x_mode = 'S') THEN
905: igs_sc_gen_001.unset_ctx('R');
906: END IF;
907: app_exception.raise_exception;
908: END IF;
909: IF (x_mode = 'S') THEN

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

906: END IF;
907: app_exception.raise_exception;
908: END IF;
909: IF (x_mode = 'S') THEN
910: igs_sc_gen_001.unset_ctx('R');
911: END IF;
912:
913: EXCEPTION
914: WHEN OTHERS THEN

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

912:
913: EXCEPTION
914: WHEN OTHERS THEN
915: IF (x_mode = 'S') THEN
916: igs_sc_gen_001.unset_ctx('R');
917: END IF;
918:
919: END delete_row;
920: