What you want is 3D displacement. Take a look at FreeForm which has been bundled with AE since, ... ... CS4? There is a newer rendition, FreeFormPro that renders much faster and has lots of new options in place.
Intensive AE & Mocha Training in Singapore and Malaysia
Adobe ACE/ACI (version 7) & Imagineer Systems Inc Approved Mocha Trainer
roland, I have trying the freeform, which is basically a mesh like in Photoshop. I was wondering , do you think it could be a good idea having some pattern in the wall? Over a simple wall, the result it is not amazing. Maybe simulating drops shadows as well...
Free Form is good and will get you somewhere, but as Roland suggested FreeForm Pro would be a better option. It's not only fast but has a much more accurate displacement mapping the will enable you to give a 3d texture to the wall. There is a nice interaction with AE 3d lights which can give you shadows and you can even use a Reflection Map.
You can cut the part of the wall you want affected, bring it in PSD, paint a rectangle (undistorted wall) and bring that back in AE. Use the controls in FreeForm Pro to position the rectangle (wall piece)in 3d to match the perspective in the shot and distort at will. If you seek this forum you will find some project files posted by Chris Bobotis (Mettle - creators of FreeForm Pro) that have some handy expressions for 3d displacement written by Dan Ebberts. Those can come in handy.
The Puppet Tool is a 2d tool. You can animate/distort a 2d image and then precomp and make the layer 3d to position it in perspective, but you will never be able to give the depth and dimensionality of a true 3d distortion tool. You can simulate shadows, but nothing looks like a shadow cast by a 3d light. You can simulate a 3d texture, but nothing will match the real 3d displacement.
There are other ways of approaching the effect you are after, the issue here is what looks the best and what makes the client/audience believe.
At the end of the clip posted below (starting at 21 sec) I used Polar Coordinates to achieve the impression of the space around the subject pulsating with energy: