APPS.IGS_RE_THS_PNL_MBR_PKG dependencies on IGS_SC_GEN_001

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

720: x_last_update_login => X_LAST_UPDATE_LOGIN
721: );
722:
723: IF (x_mode = 'S') THEN
724: igs_sc_gen_001.set_ctx('R');
725: END IF;
726: insert into IGS_RE_THS_PNL_MBR (
727: CA_PERSON_ID,
728: CA_SEQUENCE_NUMBER,

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

762: X_LAST_UPDATED_BY,
763: X_LAST_UPDATE_LOGIN
764: );
765: IF (x_mode = 'S') THEN
766: igs_sc_gen_001.unset_ctx('R');
767: END IF;
768:
769:
770: open c;

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

786: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
787: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
788: fnd_message.set_token ('ERR_CD', SQLCODE);
789: igs_ge_msg_stack.add;
790: igs_sc_gen_001.unset_ctx('R');
791: app_exception.raise_exception;
792: ELSE
793: igs_sc_gen_001.unset_ctx('R');
794: RAISE;

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

789: igs_ge_msg_stack.add;
790: igs_sc_gen_001.unset_ctx('R');
791: app_exception.raise_exception;
792: ELSE
793: igs_sc_gen_001.unset_ctx('R');
794: RAISE;
795: END IF;
796:
797: end INSERT_ROW;

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

929: x_last_update_login => X_LAST_UPDATE_LOGIN
930: );
931:
932: IF (x_mode = 'S') THEN
933: igs_sc_gen_001.set_ctx('R');
934: END IF;
935: update IGS_RE_THS_PNL_MBR set
936: PANEL_MEMBER_TYPE = NEW_REFERENCES.PANEL_MEMBER_TYPE,
937: CONFIRMED_DT = NEW_REFERENCES.CONFIRMED_DT,

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

948: ;
949: if (sql%notfound) then
950: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
951: igs_ge_msg_stack.add;
952: igs_sc_gen_001.unset_ctx('R');
953: app_exception.raise_exception;
954: end if;
955: IF (x_mode = 'S') THEN
956: igs_sc_gen_001.unset_ctx('R');

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

952: igs_sc_gen_001.unset_ctx('R');
953: app_exception.raise_exception;
954: end if;
955: IF (x_mode = 'S') THEN
956: igs_sc_gen_001.unset_ctx('R');
957: END IF;
958:
959:
960: After_DML (

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

967: IF (SQLCODE = (-28115)) THEN
968: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
969: fnd_message.set_token ('ERR_CD', SQLCODE);
970: igs_ge_msg_stack.add;
971: igs_sc_gen_001.unset_ctx('R');
972: app_exception.raise_exception;
973: ELSE
974: igs_sc_gen_001.unset_ctx('R');
975: RAISE;

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

970: igs_ge_msg_stack.add;
971: igs_sc_gen_001.unset_ctx('R');
972: app_exception.raise_exception;
973: ELSE
974: igs_sc_gen_001.unset_ctx('R');
975: RAISE;
976: END IF;
977:
978: end UPDATE_ROW;

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

1054: x_rowid => X_ROWID
1055: );
1056:
1057: IF (x_mode = 'S') THEN
1058: igs_sc_gen_001.set_ctx('R');
1059: END IF;
1060: delete from IGS_RE_THS_PNL_MBR
1061: where ROWID = X_ROWID;
1062: if (sql%notfound) then

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

1061: where ROWID = X_ROWID;
1062: if (sql%notfound) then
1063: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1064: igs_ge_msg_stack.add;
1065: igs_sc_gen_001.unset_ctx('R');
1066: app_exception.raise_exception;
1067: end if;
1068: IF (x_mode = 'S') THEN
1069: igs_sc_gen_001.unset_ctx('R');

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

1065: igs_sc_gen_001.unset_ctx('R');
1066: app_exception.raise_exception;
1067: end if;
1068: IF (x_mode = 'S') THEN
1069: igs_sc_gen_001.unset_ctx('R');
1070: END IF;
1071:
1072:
1073: After_DML (