Friday, October 31, 2014

Retry Work flow from backend for sales order lines


set serveroutput on
Declare
l_line_id NUMBER := &line_id;
l_org_id NUMBER;
l_count NUMBER;
l_result VARCHAR2(30);
Begin
oe_debug_pub.setdebuglevel(5);
OE_Standard_WF.OEOL_SELECTOR
(p_itemtype => 'OEOL'
,p_itemkey => to_char(l_line_id)
,p_actid => 12345
,p_funcmode => 'SET_CTX'
,p_result => l_result
);
wf_engine.handleError('OEOL', l_line_id, 'SHIP_LINE', 'RETRY',null);
dbms_output.put_line('File name '||OE_DEBUG_PUB.G_DIR||'/'||OE_DEBUG_PUB.G_FILE);
End;
/
commit;

No comments:

Post a Comment