The Madison lock code combination to the padlocked door in the ritual room where you get camera is a particular bugbear, as the code actually isn't given to you until much, much later. The solution is ...

Once you've entered the code, just hit X/A to confirm your entry, and the cupboard should pop open, revealing a crystal ball inside that serves as part of another puzzle. You may like Where to find ...