On the rare occasions I use it, I've found Mathematica already gives a lot of information regarding errors in code. Are you sure you've got the relevant preferences selected correctly?
The debugger also seems to be reasonably helpful if you're looking into code more deeply. (Although it's not, obviously, comparable to something like gdb.)