Dynamic Course Enrollment Capacity Tracking System

Design a PostgreSQL stored procedure that dynamically manages course enrollment capacities with real-time seat allocation. The procedure must handle concurrent registration attempts, prevent over-enrollment, and implement a waitlist mechanism that automatically promotes students when seats become available. Include comprehensive error handling for race conditions, implement transaction-level locking, and create a log tracking all enrollment state changes with precise timestamps.