Form Personalization - To restrict sum(line_qty)

Hi All,

In the Sales Order line level we have a requirement such that, based on certain order type , user should not be able to enter more then certain predefined Qty irrespective of any item in the line .

Example: Lets say I am capturing some value in Order Type DFF(i.e., 100), when the user creates order with this order type, in the line level the sum of all the lines should not exceed this value(100), here the issue is the validation should happen prior to save i.e., before the record is commited into database, can this possible through form personalization. For Single record I am able to restrict , but the main issue I am facing is to get the sum of the line qty of all lines . Can you please share your thought process on this