DBA Data[Home] [Help]

APPS.DPP_COVEREDINVENTORY_PVT dependencies on DPP_TRANSACTION_LINES_ALL

Line 624: UPDATE DPP_TRANSACTION_LINES_ALL

620: FND_MSG_PUB.add;
621: RAISE FND_API.G_EXC_ERROR;
622: ELSE
623: BEGIN
624: UPDATE DPP_TRANSACTION_LINES_ALL
625: SET covered_inventory = NVL(l_covered_inv_tbl(i).Covered_quantity,0),
626: onhand_inventory = NVL(l_covered_inv_tbl(i).Onhand_Quantity,0),
627: UOM = l_covered_inv_tbl(i).UOM_Code,
628: last_update_date = l_sysdate,

Line 642: DPP_UTILITY_PVT.debug_message(substr(('Error in Updating DPP_TRANSACTION_LINES_ALL: ' || SQLERRM || ' from Update Covered Inventory API'),1,4000));

638: RAISE FND_API.G_EXC_ERROR;
639: END IF;
640: EXCEPTION
641: WHEN OTHERS THEN
642: DPP_UTILITY_PVT.debug_message(substr(('Error in Updating DPP_TRANSACTION_LINES_ALL: ' || SQLERRM || ' from Update Covered Inventory API'),1,4000));
643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
644: END ;
645: END IF;
646: -- Assign values to l_txn_lines_tbl for History