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: ---------------------------------------------------------------------
1372: l_new_item_number VARCHAR2(40);
1373: l_new_oe_line_id NUMBER;
1374: l_osp_ord_obj_ver NUMBER;
1375: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;
1376: l_oe_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1377: l_oe_lot_serial_tbl OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
1378: l_derived_instance_id NUMBER;
1379: l_del_oe_lines_tbl AHL_OSP_SHIPMENT_PUB.SHIP_ID_TBL_TYPE;
1380: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.OSP_ORDER_LINES_TBL_TYPE;
1373: l_new_oe_line_id NUMBER;
1374: l_osp_ord_obj_ver NUMBER;
1375: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;
1376: l_oe_line_tbl OE_ORDER_PUB.LINE_TBL_TYPE;
1377: l_oe_lot_serial_tbl OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
1378: l_derived_instance_id NUMBER;
1379: l_del_oe_lines_tbl AHL_OSP_SHIPMENT_PUB.SHIP_ID_TBL_TYPE;
1380: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.OSP_ORDER_LINES_TBL_TYPE;
1381: l_request_id NUMBER;
1383: l_return_status VARCHAR2(1);
1384: l_msg_count NUMBER;
1385: l_msg_data VARCHAR2(2000);
1386: l_msg_index_out NUMBER;
1387: l_oe_line_rec OE_ORDER_PUB.line_rec_type;
1388: l_rma_line_canceled boolean;
1389: l_ib_trans_deleted boolean;
1390: l_dummy VARCHAR2(1);
1391: l_err_intf_trans_id NUMBER;
1699: END IF;
1700: END IF;
1701:
1702: IF(l_rma_line_canceled) THEN
1703: l_oe_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
1704: l_oe_lot_serial_tbl := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL;
1705:
1706: /* Create a new RMA Line, corresponding to the receipt */
1707: l_oe_line_tbl(1) := l_oe_line_rec;
1700: END IF;
1701:
1702: IF(l_rma_line_canceled) THEN
1703: l_oe_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
1704: l_oe_lot_serial_tbl := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL;
1705:
1706: /* Create a new RMA Line, corresponding to the receipt */
1707: l_oe_line_tbl(1) := l_oe_line_rec;
1708: l_oe_line_tbl(1).inventory_item_id := p_rma_receipt_rec.EXCHANGE_ITEM_ID;
1770: OE_MSG_PUB.Get(p_msg_index => i,
1771: p_encoded => FND_API.G_FALSE,
1772: p_data => l_msg_data,
1773: p_msg_index_out => l_msg_index_out);
1774: fnd_msg_pub.add_exc_msg(p_pkg_name => 'OE_ORDER_PUB',
1775: p_procedure_name => 'processOrder',
1776: p_error_text => substr(l_msg_data,1,240));
1777: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1778: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'OE:Err Msg '||i||'.' || l_msg_data);