Overselling Warning and ATP depletion

Hello, business have a request as:

A cetain material (say MMM) can be produced only 10000 (say) qty in a year. When creating a sales order for 250 (say) qty. It should automatically consume / deplete from the predefined 10000 leaving now 9750 qty. Orders should keep on coming till this quantity gets completely depleted. When ever the order qty is more than available qty (not yet produced but will be produced) the order creation should flag an error as "quantity not available". What config needs to be done ? Any help / ideas would be appreciated. Looked at ATP but no success till now.

Note this is at order craetion process on quantity not yet existing/ produced.

Thank You

Deb