10: -- Return transaction type
11: G_OM_RETURN CONSTANT VARCHAR2(30) := 'RMA_RECEIPT';
12:
13: --Shipment Group API parameters
14: x_header_rec OE_ORDER_PUB.Header_Rec_Type;
15: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
16: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
17: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
18: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
11: G_OM_RETURN CONSTANT VARCHAR2(30) := 'RMA_RECEIPT';
12:
13: --Shipment Group API parameters
14: x_header_rec OE_ORDER_PUB.Header_Rec_Type;
15: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
16: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
17: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
18: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
19: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type ;
12:
13: --Shipment Group API parameters
14: x_header_rec OE_ORDER_PUB.Header_Rec_Type;
15: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
16: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
17: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
18: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
19: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type ;
20: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
13: --Shipment Group API parameters
14: x_header_rec OE_ORDER_PUB.Header_Rec_Type;
15: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
16: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
17: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
18: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
19: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type ;
20: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
21: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
14: x_header_rec OE_ORDER_PUB.Header_Rec_Type;
15: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
16: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
17: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
18: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
19: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type ;
20: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
21: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
22: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
15: x_header_val_rec OE_ORDER_PUB.Header_Val_Rec_Type;
16: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
17: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
18: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
19: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type ;
20: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
21: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
22: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
23: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
16: x_Header_Adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;
17: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
18: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
19: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type ;
20: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
21: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
22: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
23: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
24: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
17: x_Header_Adj_val_tbl OE_ORDER_PUB.Header_Adj_Val_Tbl_Type;
18: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
19: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type ;
20: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
21: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
22: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
23: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
24: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
25: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
18: x_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
19: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type ;
20: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
21: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
22: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
23: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
24: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
25: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
26: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
19: x_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type ;
20: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
21: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
22: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
23: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
24: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
25: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
26: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
27: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
20: x_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
21: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
22: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
23: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
24: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
25: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
26: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
27: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
28: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type ;
21: x_Header_Scredit_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;
22: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
23: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
24: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
25: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
26: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
27: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
28: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type ;
29: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
22: x_Header_Scredit_val_tbl OE_ORDER_PUB.Header_Scredit_Val_Tbl_Type;
23: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
24: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
25: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
26: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
27: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
28: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type ;
29: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
30: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
23: x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
24: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
25: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
26: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
27: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
28: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type ;
29: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
30: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
31: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
24: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
25: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
26: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
27: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
28: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type ;
29: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
30: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
31: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
32: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
25: x_Line_Adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
26: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
27: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
28: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type ;
29: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
30: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
31: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
32: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
33: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
26: x_Line_Adj_val_tbl OE_ORDER_PUB.Line_Adj_Val_Tbl_Type;
27: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
28: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type ;
29: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
30: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
31: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
32: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
33: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
34: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
27: x_Line_price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
28: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type ;
29: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
30: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
31: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
32: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
33: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
34: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
35:
28: x_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type ;
29: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
30: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
31: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
32: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
33: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
34: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
35:
36: ---------------------------------------------------------------------
29: x_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
30: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
31: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
32: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
33: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
34: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
35:
36: ---------------------------------------------------------------------
37: -- Declare local/private APIs defined in the package later --
30: x_Line_Scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;
31: x_Line_Scredit_val_tbl OE_ORDER_PUB.Line_Scredit_Val_Tbl_Type;
32: x_Lot_Serial_tbl OE_ORDER_PUB.Lot_Serial_Tbl_Type;
33: x_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type;
34: x_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
35:
36: ---------------------------------------------------------------------
37: -- Declare local/private APIs defined in the package later --
38: ---------------------------------------------------------------------
1605: l_new_item_number VARCHAR2(40);
1606: l_new_oe_line_id NUMBER;
1607: l_osp_ord_obj_ver NUMBER;
1608: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;
1609: l_oe_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1610: l_oe_lot_serial_tbl OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
1611: l_derived_instance_id NUMBER;
1612: l_del_oe_lines_tbl AHL_OSP_SHIPMENT_PUB.SHIP_ID_TBL_TYPE;
1613: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.OSP_ORDER_LINES_TBL_TYPE;
1606: l_new_oe_line_id NUMBER;
1607: l_osp_ord_obj_ver NUMBER;
1608: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;
1609: l_oe_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1610: l_oe_lot_serial_tbl OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
1611: l_derived_instance_id NUMBER;
1612: l_del_oe_lines_tbl AHL_OSP_SHIPMENT_PUB.SHIP_ID_TBL_TYPE;
1613: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.OSP_ORDER_LINES_TBL_TYPE;
1614: l_request_id NUMBER;
1616: l_return_status VARCHAR2(1);
1617: l_msg_count NUMBER;
1618: l_msg_data VARCHAR2(2000);
1619: l_msg_index_out NUMBER;
1620: l_oe_line_rec OE_ORDER_PUB.line_rec_type;
1621: l_rma_line_canceled boolean;
1622: l_ib_trans_deleted boolean;
1623: l_dummy VARCHAR2(1);
1624: l_err_intf_trans_id NUMBER;
1976: END IF;
1977: END IF;
1978:
1979: IF(l_rma_line_canceled) THEN
1980: l_oe_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
1981: l_oe_lot_serial_tbl := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL;
1982:
1983: /* Create a new RMA Line, corresponding to the receipt */
1984: l_oe_line_tbl(1) := l_oe_line_rec;
1977: END IF;
1978:
1979: IF(l_rma_line_canceled) THEN
1980: l_oe_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
1981: l_oe_lot_serial_tbl := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL;
1982:
1983: /* Create a new RMA Line, corresponding to the receipt */
1984: l_oe_line_tbl(1) := l_oe_line_rec;
1985: l_oe_line_tbl(1).inventory_item_id := p_rma_receipt_rec.EXCHANGE_ITEM_ID;
2047: OE_MSG_PUB.Get(p_msg_index => i,
2048: p_encoded => FND_API.G_FALSE,
2049: p_data => l_msg_data,
2050: p_msg_index_out => l_msg_index_out);
2051: fnd_msg_pub.add_exc_msg(p_pkg_name => 'OE_ORDER_PUB',
2052: p_procedure_name => 'processOrder',
2053: p_error_text => substr(l_msg_data,1,240));
2054: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2055: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'OE:Err Msg '||i||'.' || l_msg_data);