Exception Handling

Hello,

Can somebody help us understand on the foll.:

1. What is the recommended/common practice: is it to create 1 global EXCEPTIONS table and log all exceptions to it OR one exception table for each table?

2. When logging exceptions, is there a way to log values for the failing sql/transaction too? Otherwise how does it help? Because without values, all that is logged is the statement that failed. How does the application team then look at the exceptions and resolve those?

3. A theoretical one - is there a difference between conflict detection and exception handling?

Thanks