We are facing an issue with Customize order management in EBS R12 as follows:
The order has been created already.
When press BOOK button in order management,we want to do sth to the order(some logic check for Headers and Lines).
If the reasult is illegal, instead of book the order ,popup message to user and hold the order at the same time(the line which is illegal and its header)(call API to hold the order).
We have tryed some ways,but it seems can not work.
Solution 1. use form personalize.but there is no way to catch the press book button trigger for we can do this things.
(only when-new-form-instance,when-new-item-instance...trigger can be personalized,and the book button seems no when-new-item-instance trigger)
Solution 2.rewrite custom.pll.as the same with Soluton1,there is no method to write the when-button-pressed trigger.
We do not want to rewrite the ebs standard form or standard pll,so is that any way to achieve this?
Looking forward to helping answers and thanks already.
We really appreciate your suggestion.
we handled similar situation through personalization as follows:
1a. Write the validation condition in personalization on WHEN-NEW-RECORD-INSTANCE of ORDER Block.
Through actions, display error message and disable Book button.
1b. Write the negative of validation condition in personalization on WHEN-NEW-RECORD-INSTANCE of ORDER Block.
Through actions, enable Book button.
2. Disable Book order button in LINES Block
3. Train the users to enter the order header first, order line next and then come back to header and click book (if allowed).
We do want to let the Book button can always be enabled.
And we want to accomplish the work flow as follows:
input data(user)-save order(user) - try to book order(user) - check(system) - popup message & hold order(system) - confirm(user,offline) - release hold(user) - repair illegal data(user) - try to book order again(user) - check again(system) -...
the text which be bolded is the things that we need to handle.
You restrict order booking based on conditions by using
Trigger Event: OM_PRE_BOOK_EVENT
Condition: As required
Processing Mode: Both
Message: Error: Order Can't be booked
Builtin : RAISE FORM_TRIGGER_FAILURE