There was (is) an issue with the SATA controller in the G5 machines that prevent the Raptor 150 from working properly, but since the Mac Pro uses an Intel controller (rather than the custom IC the G5 uses), it should work.
xlr8yourmac.com has a couple of items about this drive in G5s.