This client extension enables custom logic to determine if move, scrap, reject, and completion transactions are processed or stopped. The program returns one of several values. If the value returned is:
Yes, the transaction page proceeds as normal.
No, the transaction page is aborted displaying an error message.
Warning, you are redirected to a dialog page. You can cancel the dialog page, and return to the transaction page. Or select Continue and process the transaction.
Informational, the transaction proceeds as normal. The custom message is displayed in the returning transaction page.
A PL/SQL package, WIP_WS_CUSTOM, contains the custom programming instructions invoked.
Transaction Validation Function - get_transaction_validation_value
| Parameter | IN/OUT | Type | Description |
|---|---|---|---|
| wip_entity_id | IN | Number | WIP entity identification of the job |
| mtl_header_id | IN | Number | Material header identification |
| txn_type f | IN | Varchar2 | Transaction type |
| from_op_seq | IN | Number | From operation sequence |
| from_step | IN | Varchar2 | From operation step |
| to_op_seq | IN | Number | To operation sequence |
| to_step | IN | Varchar2 | To operation step |
| txn_quantity | IN | Number | Transaction quantity |
| txn_uom | IN | Varchar2 | Transaction unit of measure |
| scrap_quantity | IN | NUMBER | Scrap quantity (for combination transaction) |
| reject_quantity | IN | NUMBER | Reject quantity (for combination transaction) |
| subinv locator_id | IN | VARCHAR2 | Subinventory locator identification |
| assembly_lot | IN | NUMBER | Assembly lot number. |
| assembly_serial | IN | VARCHAR2 | Assembly serial number |
| reason_id | IN | NUMBER | Reason identification |
| reference | IN | VARCHAR2 | Transaction reference |
| sales_order_id | IN | VARCHAR2 | Sales order identification |
| sales_order_line_id | IN | NUMBER | Sales order line identification |
| overcompletion | IN | STRING | Overcompletion |
| project_id | IN | NUMBER | Project identification |
| task_id | IN | NUMBER | Task identification |
| scrap_acct_id | IN | NUMBER | Scrap account identification |
| kanban_id | IN | NUMBER | Kanban identification |
| attribute1 | IN | VARCHAR2 | Reserved for future use |
| attribute2 | IN | VARCHAR2 | Reserved for future use |
| attribute3 | IN | VARCHAR2 | Reserved for future use |
| attribute4 | IN | VARCHAR2 | Reserved for future use |
| attribute5 | IN | VARCHAR2 | Reserved for future use |
| return_status | OUT | VARCHAR2 | Indicates return status of the program: Yes, No, Warning, Informational |
| return_message | OUT | VARCHAR2 | Custom message returned by the program |
| return_attribute1 | OUT | VARCHAR2 | Reserved for future use |
| return_attribute2 | OUT | VARCHAR2 | Reserved for future use |