[Home] [Help]
67: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
68: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
69: --serla end
70: --
71: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
72: --
73: begin
74:
75: --
76: -- RUN mode - normal process execution
77: --
78: if (funcmode = 'RUN') then
79: IF l_debug_level > 0 THEN
80: oe_debug_pub.add( 'ENTERING OE_RMA_WF.CREATE_OUTBOUND_SHIPMENT' , 1 ) ;
81: END IF;
82:
83: -- your run code goes here
84:
156:
157: l_x_line_rec := l_line_tbl(1);
158:
159: IF l_debug_level > 0 THEN
160: oe_debug_pub.add( 'CALLING CALCULATE TAX' , 2 ) ;
161: END IF;
162: -- Calculate Tax
163:
164: -- Commented out the call as the line tax is now calculated as a delayed
168: OE_Delayed_Requests_UTIL.Tax_Line (x_return_status
169: , l_x_line_rec
170: , l_x_line_rec
171: );
172: oe_debug_pub.add('Calling Update Row', 2);
173: OE_Line_Util.Update_Row (l_x_line_rec);
174: OE_GLOBALS.G_TAX_FLAG := 'N';
175: END IF;
176: */
230: is
231: l_category_code VARCHAR2(30);
232:
233: --
234: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
235: --
236: BEGIN
237: IF itemtype = OE_GLOBALS.G_WFI_LIN THEN
238: l_category_code := wf_engine.GetItemAttrText(OE_GLOBALS.G_WFI_LIN,
263: is
264: l_shippable_flag VARCHAR2(1);
265: l_transactable_flag VARCHAR2(1);
266: --
267: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
268: --
269: BEGIN
270:
271:
341: is
342: l_category_code VARCHAR2(30);
343: l_return_status VARCHAR2(30);
344: --
345: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
346: --
347: BEGIN
348:
349: IF l_debug_level > 0 THEN
346: --
347: BEGIN
348:
349: IF l_debug_level > 0 THEN
350: oe_debug_pub.add( 'ENTERING OE_RMA_WF.WAIT_FOR_RECEIVING '||ITEMTYPE||'/' ||ITEMKEY , 1 ) ;
351: END IF;
352:
353:
354: IF (funcmode = 'RUN') then
366:
367: OE_STANDARD_WF.Set_Msg_Context(actid);
368:
369: IF l_debug_level > 0 THEN
370: oe_debug_pub.add( 'CALLING FLOW STATUS API ' , 1 ) ;
371: END IF;
372:
373: IF OE_STANDARD_WF.G_UPGRADE_MODE <> TRUE THEN
374:
377: p_flow_status_code => 'AWAITING_RETURN',
378: x_return_status => l_return_status
379: );
380: IF l_debug_level > 0 THEN
381: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API '|| L_RETURN_STATUS , 1 ) ;
382: END IF;
383: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
384: -- start data fix project
385: -- OE_STANDARD_WF.Save_Messages;
431: -- resultout := '';
432: -- return;
433:
434: IF l_debug_level > 0 THEN
435: oe_debug_pub.add( 'EXITING OE_RMA_WF.WAIT_FOR_RECEIVING ' , 1 ) ;
436: END IF;
437:
438: Exception
439: when others then
464: ,funcmode IN VARCHAR2
465: ,resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
466: ) AS
467: l_return_status VARCHAR2(1);
468: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
469:
470: CURSOR return_lines IS
471: SELECT line_id,wias.item_type,wias.item_key
472: FROM oe_order_lines l
481: AND WIAS.activity_status = 'NOTIFIED'
482: AND WPA.activity_name = 'APPROVE_WAIT_FOR_H';
483: BEGIN
484: IF l_debug_level > 0 THEN
485: oe_debug_pub.add('OEXWRMAB: ENTERING UPD_FLOW_STATUS_CODE_REJ, '
486: ||'ITEM TYPE/KEY: '||itemtype||'/'||itemkey);
487: END IF;
488: oe_order_wf_util.update_flow_status_code (
489: P_HEADER_ID => To_Number(itemkey)
491: ,X_RETURN_STATUS => l_return_status);
492:
493: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
494: IF l_debug_level > 0 THEN
495: oe_debug_pub.add('Update flow status code: '||L_RETURN_STATUS
496: ||' - '||itemtype||'/'||itemkey,1);
497: END IF;
498: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
499: RAISE FND_API.G_EXC_ERROR;
509: ,x_return_status => l_return_status
510: );
511: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
512: IF l_debug_level > 0 THEN
513: oe_debug_pub.add('Update flow status code: '||L_RETURN_STATUS
514: ||' - '||lines.item_type||'/'||lines.item_key,1);
515: END IF;
516: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
517: RAISE FND_API.G_EXC_ERROR;
521: END IF;
522: END LOOP;
523: RESULTOUT := 'COMPLETE';
524: IF l_debug_level > 0 THEN
525: oe_debug_pub.add('OEXWRMAB: EXITING UPD_FLOW_STATUS_CODE_REJ');
526: END IF;
527: EXCEPTION
528: WHEN OTHERS THEN
529: -- The line below records this function call in the error system
555: ,funcmode IN VARCHAR2
556: ,resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
557: ) AS
558: l_return_status VARCHAR2(1);
559: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
560:
561: CURSOR return_lines IS
562: SELECT line_id,wias.item_type,wias.item_key
563: FROM oe_order_lines l
572: AND WIAS.activity_status = 'NOTIFIED'
573: AND WPA.activity_name = 'APPROVE_WAIT_FOR_H';
574: BEGIN
575: IF l_debug_level > 0 THEN
576: oe_debug_pub.add('OEXWRMAB: ENTERING UPD_FLOW_STATUS_CODE_MIX_REJ, '
577: ||'ITEM TYPE/KEY: '||itemtype||'/'||itemkey);
578: END IF;
579: oe_order_wf_util.update_flow_status_code (
580: P_HEADER_ID => To_Number(itemkey)
582: ,X_RETURN_STATUS => l_return_status);
583:
584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
585: IF l_debug_level > 0 THEN
586: oe_debug_pub.add('Update flow status code: '||L_RETURN_STATUS
587: ||' - '||itemtype||'/'||itemkey,1);
588: END IF;
589: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
590: RAISE FND_API.G_EXC_ERROR;
600: ,x_return_status => l_return_status
601: );
602: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
603: IF l_debug_level > 0 THEN
604: oe_debug_pub.add('Update flow status code: '||L_RETURN_STATUS
605: ||' - '||lines.item_type||'/'||lines.item_key,1);
606: END IF;
607: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
608: RAISE FND_API.G_EXC_ERROR;
612: END IF;
613: END LOOP;
614: RESULTOUT := 'COMPLETE';
615: IF l_debug_level > 0 THEN
616: oe_debug_pub.add('OEXWRMAB: EXITING UPD_FLOW_STATUS_CODE_MIX_REJ');
617: END IF;
618: EXCEPTION
619: WHEN OTHERS THEN
620: -- The line below records this function call in the error system