While After Effects itself does not contain any stock music or sound effects, the Creative Suite or Creative Cloud has a big library of stock music and sound effects included.

In CS4, CS5 and CS5.5 the audio files are conventiently accessible from Adobe Soundbooth as shown in Andrew Davis' tutorial Free Music & Sound FX in Soundbooth.

In CS6 and newer versions...