APPS.IGS_PE_CREDENTIALS_PKG dependencies on IGS_SC_GEN_001

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

451: x_rating_code => x_rating_code
452: );
453:
454: IF (x_mode = 'S') THEN
455: igs_sc_gen_001.set_ctx('R');
456: END IF;
457: INSERT INTO igs_pe_credentials (
458: credential_id,
459: person_id,

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

487: x_last_update_login,
488: new_references.rating_code
489: );
490: IF (x_mode = 'S') THEN
491: igs_sc_gen_001.unset_ctx('R');
492: END IF;
493:
494:
495: OPEN c;

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

506: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
507: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
508: fnd_message.set_token ('ERR_CD', SQLCODE);
509: igs_ge_msg_stack.add;
510: igs_sc_gen_001.unset_ctx('R');
511: app_exception.raise_exception;
512: ELSE
513: igs_sc_gen_001.unset_ctx('R');
514: RAISE;

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

509: igs_ge_msg_stack.add;
510: igs_sc_gen_001.unset_ctx('R');
511: app_exception.raise_exception;
512: ELSE
513: igs_sc_gen_001.unset_ctx('R');
514: RAISE;
515: END IF;
516: END insert_row;
517:

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

659: x_rating_code => x_rating_code
660: );
661:
662: IF (x_mode = 'S') THEN
663: igs_sc_gen_001.set_ctx('R');
664: END IF;
665: UPDATE igs_pe_credentials
666: SET
667: person_id = new_references.person_id,

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

680:
681: IF (SQL%NOTFOUND) THEN
682: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
683: igs_ge_msg_stack.add;
684: igs_sc_gen_001.unset_ctx('R');
685: app_exception.raise_exception;
686: END IF;
687: IF (x_mode = 'S') THEN
688: igs_sc_gen_001.unset_ctx('R');

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

684: igs_sc_gen_001.unset_ctx('R');
685: app_exception.raise_exception;
686: END IF;
687: IF (x_mode = 'S') THEN
688: igs_sc_gen_001.unset_ctx('R');
689: END IF;
690:
691:
692:

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

695: IF (SQLCODE = (-28115)) THEN
696: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
697: fnd_message.set_token ('ERR_CD', SQLCODE);
698: igs_ge_msg_stack.add;
699: igs_sc_gen_001.unset_ctx('R');
700: app_exception.raise_exception;
701: ELSE
702: igs_sc_gen_001.unset_ctx('R');
703: RAISE;

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

698: igs_ge_msg_stack.add;
699: igs_sc_gen_001.unset_ctx('R');
700: app_exception.raise_exception;
701: ELSE
702: igs_sc_gen_001.unset_ctx('R');
703: RAISE;
704: END IF;
705: END update_row;
706:

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

796: x_rowid => x_rowid
797: );
798:
799: IF (x_mode = 'S') THEN
800: igs_sc_gen_001.set_ctx('R');
801: END IF;
802: DELETE FROM igs_pe_credentials
803: WHERE rowid = x_rowid;
804:

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

804:
805: IF (SQL%NOTFOUND) THEN
806: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
807: igs_ge_msg_stack.add;
808: igs_sc_gen_001.unset_ctx('R');
809: app_exception.raise_exception;
810: END IF;
811: IF (x_mode = 'S') THEN
812: igs_sc_gen_001.unset_ctx('R');

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

808: igs_sc_gen_001.unset_ctx('R');
809: app_exception.raise_exception;
810: END IF;
811: IF (x_mode = 'S') THEN
812: igs_sc_gen_001.unset_ctx('R');
813: END IF;
814:
815:
816: END delete_row;