You've actually got to go through your PS3's PSN screen to activate it (the instructions are better detailed on the card with the code on it).
That said, I've activated and downloaded the add-on through my PS3, but I'm still getting the same "You Need to Activate Your Code" message on my Vita whenever I try to upload my file to the cloud.
Anyone else having that problem?