using custom.pll
Hi,
working in oracle applications 11i.
need to customize inventory transactions form INVTTMTX.I have a requirement to alert the user with a message whenever the issuing transaction invalidate a business rule/ data entered in DFF.
I have been advised to use CUSTOM.pll
The data I need to check is in mtl_material_transactions:
working in oracle applications 11i.
need to customize inventory transactions form INVTTMTX.I have a requirement to alert the user with a message whenever the issuing transaction invalidate a business rule/ data entered in DFF.
I have been advised to use CUSTOM.pll
The data I need to check is in mtl_material_transactions:
- transaction_type_id
- organization_id
- subinventory_code
- inventory_item_id
- transaction_quantity
- attribute3
- attribute4
I have created a boolean function that returns true if need tl alert the message.
I need guides on how to use CUSTOM.pll.
- should i place the code/call the function(parameters) in procedure event(event_name) and send the message to the user when function = true?
0