I handle those at both DB and application layer. Integrity is ensured by the database, proper error messages and logging is handled at the application layer.