60: EXCEPTION
61: WHEN update_history THEN
62:
63:
64: update mtl_txns_history
65: set transaction_status = 'ER'
66: where event_name = Item_type
67: and event_key = Item_key
68: and transaction_status = 'IP';
74: raise;
75: WHEN OTHERS THEN
76:
77:
78: update mtl_txns_history
79: set transaction_status = 'ER'
80: where event_name = Item_type
81: and event_key = Item_key
82: and transaction_status = 'IP';
168: EXCEPTION
169: WHEN update_history THEN
170:
171:
172: update mtl_txns_history
173: set transaction_status = 'ER'
174: where event_name = p_item_type
175: and event_key = p_item_key
176: and transaction_status = 'IP';
182: ROLLBACK;
183: WHEN OTHERS THEN
184:
185:
186: update mtl_txns_history
187: set transaction_status = 'ER'
188: where event_name = p_item_type
189: and event_key = p_item_key
190: and transaction_status = 'IP';