APPS.AHL_OSP_RCV_PVT dependencies on AHL_OSP_SHIPMENT_PUB

Line 1371: l_serialnum_change_rec AHL_OSP_SHIPMENT_PUB.Sernum_Change_Rec_Type;

1367: l_oe_order_line_rec oe_order_line_details_csr%ROWTYPE;
1368: l_oe_lot_serial_rec ahl_oe_lot_serial_id_csr%ROWTYPE;
1369: l_osp_order_line_rec get_osp_order_line_dtls%ROWTYPE;
1370: l_curr_org_id NUMBER;
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;

Line 1379: l_del_oe_lines_tbl AHL_OSP_SHIPMENT_PUB.SHIP_ID_TBL_TYPE;

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;
1382:
1383: l_return_status VARCHAR2(1);

Line 1499: IF(l_osp_line_id is not null AND AHL_OSP_SHIPMENT_PUB.Is_part_chg_valid_for_ospline(l_osp_line_id) = 'Y')

1495:
1496: --Part Number change is being performed
1497: IF (l_part_num_change_flag) THEN
1498:
1499: IF(l_osp_line_id is not null AND AHL_OSP_SHIPMENT_PUB.Is_part_chg_valid_for_ospline(l_osp_line_id) = 'Y')
1500: THEN
1501: OPEN get_item_number(p_rma_receipt_rec.new_item_id);
1502: FETCH get_item_number INTO l_new_item_number;
1503: CLOSE get_item_number;

Line 1516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Before calling AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change');

1512: l_serialnum_change_rec.NEW_SERIAL_NUMBER := p_rma_receipt_rec.NEW_SERIAL_NUMBER;
1513: l_serialnum_change_rec.NEW_SERIAL_TAG_CODE := p_rma_receipt_rec.NEW_SERIAL_TAG_CODE;
1514:
1515: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Before calling AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change');
1517: END IF;
1518:
1519: AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change
1520: (

Line 1519: AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change

1515: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Before calling AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change');
1517: END IF;
1518:
1519: AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change
1520: (
1521: p_api_version => 1.0,
1522: p_init_msg_list => FND_API.G_FALSE,
1523: p_commit => FND_API.G_FALSE,

Line 1531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'After calling AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change');

1527: x_msg_data => l_msg_data
1528: );
1529:
1530: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'After calling AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change');
1532: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'l_return_status: '||l_return_status);
1533: END IF;
1534:
1535: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1643: AHL_OSP_SHIPMENT_PUB.Delete_IB_Transaction(

1639: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1640: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'l_osp_order_line_rec.exchange_instance_id:'||l_osp_order_line_rec.exchange_instance_id);
1641: END IF;
1642: IF(nvl(l_derived_instance_id,-1) <> nvl(l_osp_order_line_rec.exchange_instance_id,-1)) THEN
1643: AHL_OSP_SHIPMENT_PUB.Delete_IB_Transaction(
1644: p_init_msg_list => FND_API.G_FALSE, --p_init_msg_list,
1645: p_commit => FND_API.G_FALSE,
1646: p_validation_level => p_validation_level,
1647: x_return_status => x_return_status,

Line 1665: AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order (

1661: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Before calling the Delete_Cancel_Order');
1662: END IF;
1663:
1664: l_del_oe_lines_tbl(1) := p_rma_receipt_rec.return_line_id;
1665: AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order (
1666: p_api_version => 1.0,
1667: p_init_msg_list => FND_API.G_FALSE, -- Don't initialize the Message List
1668: p_commit => FND_API.G_FALSE, -- Don't commit independently
1669: p_oe_header_id => null, -- Not deleting the shipment header: Only the lines

Line 1828: AHL_OSP_SHIPMENT_PUB.Create_IB_Transaction(

1824: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Before calling Create_IB_Transaction ' );
1825: END IF;
1826:
1827: /* Create the new IB transaction */
1828: AHL_OSP_SHIPMENT_PUB.Create_IB_Transaction(
1829: p_init_msg_list => FND_API.G_FALSE, --p_init_msg_list,
1830: p_commit => FND_API.G_FALSE,
1831: p_validation_level => p_validation_level,
1832: x_return_status => l_return_status,