eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_OSP_RCV_PVT dependencies on AHL_OSP_ORDERS_PVT

Line 1608: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;

1604: l_serialnum_change_rec AHL_OSP_SHIPMENT_PUB.Sernum_Change_Rec_Type;
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;

Line 1613: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.OSP_ORDER_LINES_TBL_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;
1615:
1616: l_return_status VARCHAR2(1);
1617: l_msg_count NUMBER;

Line 1817: IF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE) THEN

1813: ELSIF (l_exchange_flag) THEN
1814: --Exchange is being performed for the return line
1815: l_rma_line_canceled := false;
1816: l_ib_trans_deleted := false;
1817: IF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE) THEN
1818: l_osp_order_rec.OSP_ORDER_ID := l_osp_order_id;
1819: l_osp_order_rec.ORDER_TYPE_CODE := AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE;
1820: l_osp_order_rec.OBJECT_VERSION_NUMBER := l_osp_ord_obj_ver;
1821: l_osp_order_rec.OPERATION_FLAG := 'U';

Line 1819: l_osp_order_rec.ORDER_TYPE_CODE := AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE;

1815: l_rma_line_canceled := false;
1816: l_ib_trans_deleted := false;
1817: IF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE) THEN
1818: l_osp_order_rec.OSP_ORDER_ID := l_osp_order_id;
1819: l_osp_order_rec.ORDER_TYPE_CODE := AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE;
1820: l_osp_order_rec.OBJECT_VERSION_NUMBER := l_osp_ord_obj_ver;
1821: l_osp_order_rec.OPERATION_FLAG := 'U';
1822:
1823: --Save the OE Return Line information, before deletion

Line 1832: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Before calling AHL_OSP_ORDERS_PVT.process_osp_order for order conversion');

1828:
1829: /* Convert the Service Order into Exchange Order. All the existing RMA lines will be cancelled if there was no
1830: receipt performed on any of the lines. */
1831: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1832: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Before calling AHL_OSP_ORDERS_PVT.process_osp_order for order conversion');
1833: END IF;
1834: AHL_OSP_ORDERS_PVT.process_osp_order(
1835: p_api_version => 1.0,
1836: p_init_msg_list => FND_API.G_FALSE,

Line 1834: AHL_OSP_ORDERS_PVT.process_osp_order(

1830: receipt performed on any of the lines. */
1831: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1832: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Before calling AHL_OSP_ORDERS_PVT.process_osp_order for order conversion');
1833: END IF;
1834: AHL_OSP_ORDERS_PVT.process_osp_order(
1835: p_api_version => 1.0,
1836: p_init_msg_list => FND_API.G_FALSE,
1837: p_commit => FND_API.G_FALSE,
1838: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1847: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'After calling AHL_OSP_ORDERS_PVT.process_osp_order for order conversion');

1843: x_msg_count => l_msg_count,
1844: x_msg_data => l_msg_data);
1845:
1846: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1847: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'After calling AHL_OSP_ORDERS_PVT.process_osp_order for order conversion');
1848: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'l_return_status: '||l_return_status);
1849: END IF;
1850:
1851: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1859: l_osp_order_type := AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE;

1855: END IF;
1856: l_rma_line_canceled := true;
1857: --Need to change the order type, if the conversion is indeed successful. Depending on the order type, the serial number/lot
1858: --number are dervived for receipt.
1859: l_osp_order_type := AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE;
1860:
1861: --change by jrotich 08/22/2012 for handling service to exchange order conversion bug 14526569
1862: --we set both the l_is_ib_trackable and l_derived_instance_id for IB Txns to be created begin
1863: OPEN inv_item_ctrls_csr(p_rma_receipt_rec.EXCHANGE_ITEM_ID, p_rma_receipt_rec.receiving_org_id);

Line 1963: END IF;--IF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE) THEN

1959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1960: END IF;
1961: l_rma_line_canceled := true;
1962: END IF;--IF(l_oe_order_line_rec.inventory_item_id = p_rma_receipt_rec.EXCHANGE_ITEM_ID) THEN
1963: END IF;--IF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE) THEN
1964:
1965: --The following holds good for both service orders and exchange orders
1966: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1967: IF(l_rma_line_canceled) THEN

Line 2112: p_osp_order_type => AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE,

2108: p_validation_level => p_validation_level,
2109: x_return_status => l_return_status,
2110: x_msg_count => l_msg_count,
2111: x_msg_data => l_msg_data,
2112: p_osp_order_type => AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE,
2113: p_oe_line_type => 'RETURN',
2114: p_oe_line_id => nvl(x_return_line_id,p_rma_receipt_rec.return_line_id),
2115: p_csi_instance_id => l_derived_instance_id);
2116:

Line 2348: IF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE) THEN

2344: CLOSE get_IB_subtrns_inst_dtls_csr;
2345: END IF;
2346:
2347: IF (l_serial_control_code IN (2,5,6)) THEN
2348: IF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE) THEN
2349: --Item is serial controlled
2350: IF(l_is_ib_trackable = 'Y') THEN
2351: --Derive the serial number from the instance, which may have undergone serial number changes.
2352: l_trans_serial_number := l_IB_subtrns_inst_rec.serial_number;

Line 2362: ELSIF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE) THEN

2358: --For non-IB tracked serialized items use the serial_number from the osp order line
2359: l_trans_serial_number := l_osp_order_line_rec.serial_number;
2360: END IF;
2361: END IF;--IF(l_is_ib_trackable = 'Y')
2362: ELSIF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE) THEN
2363: IF(l_osp_line_id is NULL) THEN
2364: l_trans_serial_number := l_oe_lot_serial_rec.serial_number;
2365: ELSE
2366: l_trans_serial_number := p_rma_receipt_rec.exchange_serial_number;

Line 2372: IF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE) THEN

2368: END IF;--IF(l_osp_order_type = 'SERVICE')
2369: END IF;--IF (l_serial_control_code IN (2,5,6))
2370:
2371: IF (l_lot_control_code = 2) THEN
2372: IF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE) THEN
2373: --Item is serial controlled
2374: IF(l_is_ib_trackable = 'Y') THEN
2375: --Derive the serial number from the instance, which may have undergone serial number changes.
2376: l_trans_lot_number := l_IB_subtrns_inst_rec.lot_number;

Line 2386: ELSIF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE) THEN

2382: --For non-IB tracked lot controlled items use the serial_number from the osp order line
2383: l_trans_lot_number := l_osp_order_line_rec.lot_number;
2384: END IF;
2385: END IF;--IF(l_is_ib_trackable = 'Y')
2386: ELSIF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE) THEN
2387: IF(l_osp_line_id is NULL) THEN
2388: l_trans_lot_number := l_oe_lot_serial_rec.lot_number;
2389: ELSE
2390: l_trans_lot_number := p_rma_receipt_rec.exchange_lot_number;