<<I have tried booting up with a bootable cd disk to access the recovery console but no luck.>>
"A bootable CD disk"...does that mean that it came with the system you are trying to repair? What happens when the CD is inserted and the system boots?
Have you tried running Dell Diagnostics on the system?
Generally...STOP 24 error messages can indicate a problem with a file, the file system, or the hard drive.
From what I see...Dimension 9150s were issued with "reinstallation disks". These are not equivalent to retail copies of MS Genuine XP, as I understand it.
Do you also have a Drivers CD and a Software CD?