APPS.IGS_PE_FELONY_DTLS_PKG dependencies on IGS_SC_GEN_001

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

498: x_last_update_login => x_last_update_login
499: );
500:
501: IF (x_mode = 'S') THEN
502: igs_sc_gen_001.set_ctx('R');
503: END IF;
504: INSERT INTO igs_pe_felony_dtls (
505: felony_details_id,
506: person_id,

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

526: x_last_updated_by,
527: x_last_update_login
528: );
529: IF (x_mode = 'S') THEN
530: igs_sc_gen_001.unset_ctx('R');
531: END IF;
532:
533:
534: OPEN c;

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

545: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
546: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
547: fnd_message.set_token ('ERR_CD', SQLCODE);
548: igs_ge_msg_stack.add;
549: igs_sc_gen_001.unset_ctx('R');
550: app_exception.raise_exception;
551: ELSE
552: igs_sc_gen_001.unset_ctx('R');
553: RAISE;

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

548: igs_ge_msg_stack.add;
549: igs_sc_gen_001.unset_ctx('R');
550: app_exception.raise_exception;
551: ELSE
552: igs_sc_gen_001.unset_ctx('R');
553: RAISE;
554: END IF;
555: END insert_row;
556:

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

684: x_last_update_login => x_last_update_login
685: );
686:
687: IF (x_mode = 'S') THEN
688: igs_sc_gen_001.set_ctx('R');
689: END IF;
690: UPDATE igs_pe_felony_dtls
691: SET
692: person_id = new_references.person_id,

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

701:
702: IF (SQL%NOTFOUND) THEN
703: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
704: igs_ge_msg_stack.add;
705: igs_sc_gen_001.unset_ctx('R');
706: app_exception.raise_exception;
707: END IF;
708: IF (x_mode = 'S') THEN
709: igs_sc_gen_001.unset_ctx('R');

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

705: igs_sc_gen_001.unset_ctx('R');
706: app_exception.raise_exception;
707: END IF;
708: IF (x_mode = 'S') THEN
709: igs_sc_gen_001.unset_ctx('R');
710: END IF;
711:
712:
713:

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

716: IF (SQLCODE = (-28115)) THEN
717: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
718: fnd_message.set_token ('ERR_CD', SQLCODE);
719: igs_ge_msg_stack.add;
720: igs_sc_gen_001.unset_ctx('R');
721: app_exception.raise_exception;
722: ELSE
723: igs_sc_gen_001.unset_ctx('R');
724: RAISE;

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

719: igs_ge_msg_stack.add;
720: igs_sc_gen_001.unset_ctx('R');
721: app_exception.raise_exception;
722: ELSE
723: igs_sc_gen_001.unset_ctx('R');
724: RAISE;
725: END IF;
726: END update_row;
727:

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

806: x_rowid => x_rowid
807: );
808:
809: IF (x_mode = 'S') THEN
810: igs_sc_gen_001.set_ctx('R');
811: END IF;
812: DELETE FROM igs_pe_felony_dtls
813: WHERE rowid = x_rowid;
814:

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

814:
815: IF (SQL%NOTFOUND) THEN
816: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
817: igs_ge_msg_stack.add;
818: igs_sc_gen_001.unset_ctx('R');
819: app_exception.raise_exception;
820: END IF;
821: IF (x_mode = 'S') THEN
822: igs_sc_gen_001.unset_ctx('R');

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

818: igs_sc_gen_001.unset_ctx('R');
819: app_exception.raise_exception;
820: END IF;
821: IF (x_mode = 'S') THEN
822: igs_sc_gen_001.unset_ctx('R');
823: END IF;
824:
825:
826: END delete_row;