There is nothing built into SQL Server that I know of that will give you the type of call-stack information that you are looking for. There are hacks/workarounds, but all of those require modifying the calling stored procedure or wrapping the calling stored procedure in another stored procedure and then calling the wrapper.