APPS.AHL_OSP_RCV_PVT dependencies on AHL_OSP_SHIPMENT_PUB

Line 1604: l_serialnum_change_rec AHL_OSP_SHIPMENT_PUB.Sernum_Change_Rec_Type;

1600: l_oe_order_line_rec oe_order_line_details_csr%ROWTYPE;
1601: l_oe_lot_serial_rec ahl_oe_lot_serial_id_csr%ROWTYPE;
1602: l_osp_order_line_rec get_osp_order_line_dtls%ROWTYPE;
1603: l_curr_org_id NUMBER;
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;

Line 1612: l_del_oe_lines_tbl AHL_OSP_SHIPMENT_PUB.SHIP_ID_TBL_TYPE;

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;
1615:
1616: l_return_status VARCHAR2(1);

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

1750:
1751: --Part Number change is being performed
1752: IF (l_part_num_change_flag) THEN
1753:
1754: IF(l_osp_line_id is not null AND AHL_OSP_SHIPMENT_PUB.Is_part_chg_valid_for_ospline(l_osp_line_id) = 'Y')
1755: THEN
1756: OPEN get_item_number(p_rma_receipt_rec.new_item_id);
1757: FETCH get_item_number INTO l_new_item_number;
1758: CLOSE get_item_number;

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

1767: l_serialnum_change_rec.NEW_SERIAL_NUMBER := p_rma_receipt_rec.NEW_SERIAL_NUMBER;
1768: l_serialnum_change_rec.NEW_SERIAL_TAG_CODE := p_rma_receipt_rec.NEW_SERIAL_TAG_CODE;
1769:
1770: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1771: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Before calling AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change');
1772: END IF;
1773:
1774: AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change
1775: (

Line 1774: AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change

1770: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1771: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Before calling AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change');
1772: END IF;
1773:
1774: AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change
1775: (
1776: p_api_version => 1.0,
1777: p_init_msg_list => FND_API.G_FALSE,
1778: p_commit => FND_API.G_FALSE,

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

1782: x_msg_data => l_msg_data
1783: );
1784:
1785: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1786: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'After calling AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change');
1787: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'l_return_status: '||l_return_status);
1788: END IF;
1789:
1790: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1920: AHL_OSP_SHIPMENT_PUB.Delete_IB_Transaction(

1916: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1917: 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);
1918: END IF;
1919: IF(nvl(l_derived_instance_id,-1) <> nvl(l_osp_order_line_rec.exchange_instance_id,-1)) THEN
1920: AHL_OSP_SHIPMENT_PUB.Delete_IB_Transaction(
1921: p_init_msg_list => FND_API.G_FALSE, --p_init_msg_list,
1922: p_commit => FND_API.G_FALSE,
1923: p_validation_level => p_validation_level,
1924: x_return_status => x_return_status,

Line 1942: AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order (

1938: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Before calling the Delete_Cancel_Order');
1939: END IF;
1940:
1941: l_del_oe_lines_tbl(1) := p_rma_receipt_rec.return_line_id;
1942: AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order (
1943: p_api_version => 1.0,
1944: p_init_msg_list => FND_API.G_FALSE, -- Don't initialize the Message List
1945: p_commit => FND_API.G_FALSE, -- Don't commit independently
1946: p_oe_header_id => null, -- Not deleting the shipment header: Only the lines

Line 2105: AHL_OSP_SHIPMENT_PUB.Create_IB_Transaction(

2101: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Before calling Create_IB_Transaction ' );
2102: END IF;
2103:
2104: /* Create the new IB transaction */
2105: AHL_OSP_SHIPMENT_PUB.Create_IB_Transaction(
2106: p_init_msg_list => FND_API.G_FALSE, --p_init_msg_list,
2107: p_commit => FND_API.G_FALSE,
2108: p_validation_level => p_validation_level,
2109: x_return_status => l_return_status,