What's the difference between REQUIRED and REQUIRES_NEW propagation?

REQUIRED (the default) joins an already-active transaction if one exists, or starts a new one if not — a failure anywhere ties back to the same outer transaction. REQUIRES_NEW always suspends any existing transaction and starts a completely independent one with its own commit/rollback, unaffected by the outer transaction's eventual outcome.