Update deal stage on subscription payment failure

Failed subscription payments in Stripe leave CRM deals out of sync and delay collections. Mark deals as Failed Payment and log the event so billing staff can act before the next billing run.