1695:
1696: l_api_name VARCHAR2(50) := 'CheckOverReturnQty';
1697: l_api_version NUMBER := 1.0;
1698: lineTblCnt NUMBER := 0;
1699: x_error_tbl OE_RMA_GRP.OVER_RETURN_ERR_TBL_TYPE;
1700: l_order_id VARCHAR2(240);
1701: l_part_number VARCHAR2(2000);
1702: l_hdr_id NUMBER;
1703: l_order_number NUMBER;
1790: CLOSE QtyChkLineCur;
1791:
1792: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1793: IBE_Util.Debug('l_order_line_tbl size: '|| l_order_line_tbl.COUNT);
1794: IBE_Util.Debug('Before Calling OE_RMA_GRP.Is_Over_Return()');
1795: END IF;
1796:
1797: OE_RMA_GRP.Is_Over_Return(p_api_version => 1.0
1798: , p_line_tbl => l_order_line_tbl
1793: IBE_Util.Debug('l_order_line_tbl size: '|| l_order_line_tbl.COUNT);
1794: IBE_Util.Debug('Before Calling OE_RMA_GRP.Is_Over_Return()');
1795: END IF;
1796:
1797: OE_RMA_GRP.Is_Over_Return(p_api_version => 1.0
1798: , p_line_tbl => l_order_line_tbl
1799: , x_error_tbl => x_error_tbl
1800: , x_return_status => x_return_status
1801: , x_msg_count => x_msg_count
3291: AND(l_order_header_rec.order_category_code = 'RETURN' AND
3292: l_flow_status_code = 'WORKING'))THEN
3293:
3294: IF (IBE_UTIL.G_DEBUGON = l_true) then
3295: IBE_UTIL.DEBUG('Before Calling OE_RMA_GRP.Submit_Order');
3296: end if;
3297:
3298: OE_RMA_GRP.Submit_Order( p_api_version => 1.0
3299: , p_header_id => l_order_header_rec.header_id
3294: IF (IBE_UTIL.G_DEBUGON = l_true) then
3295: IBE_UTIL.DEBUG('Before Calling OE_RMA_GRP.Submit_Order');
3296: end if;
3297:
3298: OE_RMA_GRP.Submit_Order( p_api_version => 1.0
3299: , p_header_id => l_order_header_rec.header_id
3300: , x_return_status => x_return_status
3301: , x_msg_count => x_msg_count
3302: , x_msg_data => x_msg_data);