59: return;
60: End If;
61:
62: select XDP_ORDER_HEADERS_S.NextVal into x_SDP_ORDER_ID
63: from dual;
64:
65: insert into xdp_order_headers
66: (
67: order_id,
186: error_description =>x_error_description);
187:
188: Begin
189: select 'N' into lv_done
190: from dual
191: where exists( select 'x' from
192: XDP_FULFILL_WORKLIST
193: where line_item_id = lv_line_id and
194: status_code = 'ERROR');