Cancelling an Order from with in iStore

One of our customer was not convinced with the idea of Oracle’s out-of-the-box functionality that High Risk credit card orders or Authorizatoin Failed Ordres are put on Hold by Order Management. And this is done by the Credit Card Authorization API (technically iby_payment_adapter_pub a public API) which is called from with OE_ORDER_PUB API.

We came up with a solution for this customer where in we cancel the order completely from with in iStore if we do not get an Auth code for the Order. This was done by writting a PL/SQL wrapper around Oralce’s standard API, OE_Order_PUB.Process_Order.

Passing the following should do the trick

l_header_rec.cancelled_flag:=’Y';
l_header_rec.header_id:=p_header_id;
l_header_rec.flow_status_code= ‘CANCELLED’;
l_header_rec.change_reason = ‘Cancel Order APPCON’;
l_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;

l_action_request_tbl(1).request_type := OE_GLOBALS.G_CANCEL_ORDER;
l_action_request_tbl(1).entity_code := OE_GLOBALS.G_ENTITY_HEADER;

Call us to know more about this Custom API