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 1375: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;

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

Line 1380: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.OSP_ORDER_LINES_TBL_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;
1382:
1383: l_return_status VARCHAR2(1);
1384: l_msg_count NUMBER;

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

1558: ELSIF (l_exchange_flag) THEN
1559: --Exchange is being performed for the return line
1560: l_rma_line_canceled := false;
1561: l_ib_trans_deleted := false;
1562: IF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE) THEN
1563: l_osp_order_rec.OSP_ORDER_ID := l_osp_order_id;
1564: l_osp_order_rec.ORDER_TYPE_CODE := AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE;
1565: l_osp_order_rec.OBJECT_VERSION_NUMBER := l_osp_ord_obj_ver;
1566: l_osp_order_rec.OPERATION_FLAG := 'U';

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

1560: l_rma_line_canceled := false;
1561: l_ib_trans_deleted := false;
1562: IF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE) THEN
1563: l_osp_order_rec.OSP_ORDER_ID := l_osp_order_id;
1564: l_osp_order_rec.ORDER_TYPE_CODE := AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE;
1565: l_osp_order_rec.OBJECT_VERSION_NUMBER := l_osp_ord_obj_ver;
1566: l_osp_order_rec.OPERATION_FLAG := 'U';
1567:
1568: --Save the OE Return Line information, before deletion

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

1573:
1574: /* Convert the Service Order into Exchange Order. All the existing RMA lines will be cancelled if there was no
1575: receipt performed on any of the lines. */
1576: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Before calling AHL_OSP_ORDERS_PVT.process_osp_order for order conversion');
1578: END IF;
1579: AHL_OSP_ORDERS_PVT.process_osp_order(
1580: p_api_version => 1.0,
1581: p_init_msg_list => FND_API.G_FALSE,

Line 1579: AHL_OSP_ORDERS_PVT.process_osp_order(

1575: receipt performed on any of the lines. */
1576: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Before calling AHL_OSP_ORDERS_PVT.process_osp_order for order conversion');
1578: END IF;
1579: AHL_OSP_ORDERS_PVT.process_osp_order(
1580: p_api_version => 1.0,
1581: p_init_msg_list => FND_API.G_FALSE,
1582: p_commit => FND_API.G_FALSE,
1583: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

1588: x_msg_count => l_msg_count,
1589: x_msg_data => l_msg_data);
1590:
1591: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1592: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'After calling AHL_OSP_ORDERS_PVT.process_osp_order for order conversion');
1593: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'l_return_status: '||l_return_status);
1594: END IF;
1595:
1596: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1604: l_osp_order_type := AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE;

1600: END IF;
1601: l_rma_line_canceled := true;
1602: --Need to change the order type, if the conversion is indeed successful. Depending on the order type, the serial number/lot
1603: --number are dervived for receipt.
1604: l_osp_order_type := AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE;
1605:
1606: ELSE--Existing Order is already an Exchange Order
1607: --Derive the exchange item properties
1608: OPEN inv_item_ctrls_csr(p_rma_receipt_rec.EXCHANGE_ITEM_ID, p_rma_receipt_rec.receiving_org_id);

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

1682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1683: END IF;
1684: l_rma_line_canceled := true;
1685: END IF;--IF(l_oe_order_line_rec.inventory_item_id = p_rma_receipt_rec.EXCHANGE_ITEM_ID) THEN
1686: END IF;--IF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE) THEN
1687:
1688: --The following holds good for both service orders and exchange orders
1689: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1690: IF(l_rma_line_canceled) THEN

Line 1835: p_osp_order_type => AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE,

1831: p_validation_level => p_validation_level,
1832: x_return_status => l_return_status,
1833: x_msg_count => l_msg_count,
1834: x_msg_data => l_msg_data,
1835: p_osp_order_type => AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE,
1836: p_oe_line_type => 'RETURN',
1837: p_oe_line_id => nvl(x_return_line_id,p_rma_receipt_rec.return_line_id),
1838: p_csi_instance_id => l_derived_instance_id);
1839:

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

2065: CLOSE get_IB_subtrns_inst_dtls_csr;
2066: END IF;
2067:
2068: IF (l_serial_control_code IN (2,5,6)) THEN
2069: IF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE) THEN
2070: --Item is serial controlled
2071: IF(l_is_ib_trackable = 'Y') THEN
2072: --Derive the serial number from the instance, which may have undergone serial number changes.
2073: l_trans_serial_number := l_IB_subtrns_inst_rec.serial_number;

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

2079: --For non-IB tracked serialized items use the serial_number from the osp order line
2080: l_trans_serial_number := l_osp_order_line_rec.serial_number;
2081: END IF;
2082: END IF;--IF(l_is_ib_trackable = 'Y')
2083: ELSIF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE) THEN
2084: IF(l_osp_line_id is NULL) THEN
2085: l_trans_serial_number := l_oe_lot_serial_rec.serial_number;
2086: ELSE
2087: l_trans_serial_number := p_rma_receipt_rec.exchange_serial_number;

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

2089: END IF;--IF(l_osp_order_type = 'SERVICE')
2090: END IF;--IF (l_serial_control_code IN (2,5,6))
2091:
2092: IF (l_lot_control_code = 2) THEN
2093: IF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE) THEN
2094: --Item is serial controlled
2095: IF(l_is_ib_trackable = 'Y') THEN
2096: --Derive the serial number from the instance, which may have undergone serial number changes.
2097: l_trans_lot_number := l_IB_subtrns_inst_rec.lot_number;

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

2103: --For non-IB tracked lot controlled items use the serial_number from the osp order line
2104: l_trans_lot_number := l_osp_order_line_rec.lot_number;
2105: END IF;
2106: END IF;--IF(l_is_ib_trackable = 'Y')
2107: ELSIF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE) THEN
2108: IF(l_osp_line_id is NULL) THEN
2109: l_trans_lot_number := l_oe_lot_serial_rec.lot_number;
2110: ELSE
2111: l_trans_lot_number := p_rma_receipt_rec.exchange_lot_number;