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.DPP_COVEREDINVENTORY_PVT dependencies on FND_LOG

Line 148: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'start');

144: THEN
145: FND_MSG_PUB.initialize;
146: END IF;
147:
148: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'start');
149:
150: -- Initialize API return status to sucess
151: l_return_status := FND_API.G_RET_STS_SUCCESS;
152: --

Line 216: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'On Hand Quantity: '||l_covered_inv_tbl(i).onhand_quantity);

212: END LOOP;
213: END IF; --ware house level details only if the covered quantiy > 0
214: l_covered_inv_tbl(i).wh_line_tbl := l_covered_inv_wh_tbl;
215: END LOOP;
216: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'On Hand Quantity: '||l_covered_inv_tbl(i).onhand_quantity);
217: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Covered Quantity: '||l_covered_inv_tbl(i).covered_quantity);
218: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'inventory_item_id: '||l_covered_inv_tbl(i).inventory_item_id);
219:
220: IF l_covered_inv_tbl(i).onhand_quantity IS NULL THEN

Line 217: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Covered Quantity: '||l_covered_inv_tbl(i).covered_quantity);

213: END IF; --ware house level details only if the covered quantiy > 0
214: l_covered_inv_tbl(i).wh_line_tbl := l_covered_inv_wh_tbl;
215: END LOOP;
216: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'On Hand Quantity: '||l_covered_inv_tbl(i).onhand_quantity);
217: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Covered Quantity: '||l_covered_inv_tbl(i).covered_quantity);
218: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'inventory_item_id: '||l_covered_inv_tbl(i).inventory_item_id);
219:
220: IF l_covered_inv_tbl(i).onhand_quantity IS NULL THEN
221: l_covered_inv_tbl(i).covered_quantity := 0;

Line 218: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'inventory_item_id: '||l_covered_inv_tbl(i).inventory_item_id);

214: l_covered_inv_tbl(i).wh_line_tbl := l_covered_inv_wh_tbl;
215: END LOOP;
216: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'On Hand Quantity: '||l_covered_inv_tbl(i).onhand_quantity);
217: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Covered Quantity: '||l_covered_inv_tbl(i).covered_quantity);
218: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'inventory_item_id: '||l_covered_inv_tbl(i).inventory_item_id);
219:
220: IF l_covered_inv_tbl(i).onhand_quantity IS NULL THEN
221: l_covered_inv_tbl(i).covered_quantity := 0;
222: l_covered_inv_tbl(i).onhand_quantity := 0;

Line 234: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Error in fetching primary UOM: ' || SQLERRM);

230: AND mp.organization_id = mp.master_organization_id
231: AND rownum = 1;
232: EXCEPTION
233: WHEN OTHERS THEN
234: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Error in fetching primary UOM: ' || SQLERRM);
235: x_return_status := FND_API.G_RET_STS_ERROR;
236: END;
237: l_covered_inv_tbl(i).uom_code := l_primary_uom_code; -- Default to Primary UOM
238: END IF; -- onhand qty null if

Line 244: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'select_coveredinventory(): x_return_status: ' || x_return_status);

240: END LOOP;
241: END IF;
242: p_covered_inv_tbl := l_covered_inv_tbl;
243: x_return_status := l_return_status;
244: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'select_coveredinventory(): x_return_status: ' || x_return_status);
245:
246: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 258: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'end');

254: THEN
255: COMMIT WORK;
256: END IF;
257:
258: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'end');
259:
260: -- Standard call to get message count and if count is 1, get message info.
261: FND_MSG_PUB.Count_And_Get
262: (p_count => x_msg_count,

Line 389: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'start');

385: FND_MSG_PUB.initialize;
386: END IF;
387:
388:
389: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'start');
390:
391: -- Initialize API return status to sucess
392: l_return_status := FND_API.G_RET_STS_SUCCESS;
393: --

Line 410: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Invalid value for Execution Detail ID: ' || l_inv_hdr_rec.Execution_Detail_ID);

406: WHERE execution_detail_id = l_inv_hdr_rec.Execution_Detail_ID;
407:
408: IF SQL%ROWCOUNT = 0 THEN
409:
410: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Invalid value for Execution Detail ID: ' || l_inv_hdr_rec.Execution_Detail_ID);
411: RAISE FND_API.G_EXC_ERROR;
412: END IF;
413:
414: EXCEPTION

Line 416: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, substr(('Error in Updating DPP_EXECUTION_DETAILS: ' || SQLERRM || ' from Populate Covered Inventory API'),1,4000));

412: END IF;
413:
414: EXCEPTION
415: WHEN OTHERS THEN
416: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, substr(('Error in Updating DPP_EXECUTION_DETAILS: ' || SQLERRM || ' from Populate Covered Inventory API'),1,4000));
417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418: END ;
419:
420: DPP_COVEREDINVENTORY_PVT.Update_CoveredInventory(

Line 440: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'end');

436: THEN
437: COMMIT WORK;
438: END IF;
439:
440: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'end');
441: -- Standard call to get message count and if count is 1, get message info.
442: FND_MSG_PUB.Count_And_Get
443: (p_count => x_msg_count,
444: p_data => x_msg_data

Line 573: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'start');

569: THEN
570: FND_MSG_PUB.initialize;
571: END IF;
572:
573: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'start');
574:
575: -- Initialize API return status to sucess
576: l_return_status := FND_API.G_RET_STS_SUCCESS;
577: --

Line 631: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Invalid value for Transaction Line ID: ' || l_covered_inv_tbl(i).Transaction_Line_Id);

627: last_calculated_date = l_sysdate
628: WHERE transaction_line_id = l_covered_inv_tbl(i).Transaction_Line_Id;
629: IF SQL%ROWCOUNT = 0 THEN
630:
631: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Invalid value for Transaction Line ID: ' || l_covered_inv_tbl(i).Transaction_Line_Id);
632:
633: RAISE FND_API.G_EXC_ERROR;
634: END IF;
635: EXCEPTION

Line 637: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, substr(('Error in Updating DPP_TRANSACTION_LINES_ALL: ' || SQLERRM || ' from Update Covered Inventory API'),1,4000));

633: RAISE FND_API.G_EXC_ERROR;
634: END IF;
635: EXCEPTION
636: WHEN OTHERS THEN
637: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, substr(('Error in Updating DPP_TRANSACTION_LINES_ALL: ' || SQLERRM || ' from Update Covered Inventory API'),1,4000));
638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
639: END ;
640:
641: --Get the supplier trade profile value to include price increase value for claim or not

Line 717: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Org Id: ' || l_inv_hdr_rec.org_id || 'transaction_line_id ' || l_covered_inv_tbl(i).Transaction_Line_Id);

713: l_txn_lines_tbl(i).onhand_inventory := NVL(l_covered_inv_tbl(i).Onhand_Quantity,0);
714:
715: BEGIN
716:
717: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Org Id: ' || l_inv_hdr_rec.org_id || 'transaction_line_id ' || l_covered_inv_tbl(i).Transaction_Line_Id);
718:
719: -- Delete existing rows in DPP_INVENTORY_DETAILS_ADJ_ALL (if any)
720: SELECT
721: inventory_details_id

Line 791: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Inventory Details ID: '||l_inv_details_id);

787: l_inv_hdr_rec.org_id,
788: l_covered_inv_tbl(i).wh_line_tbl(j).Warehouse_id,
789: 1);
790:
791: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Inventory Details ID: '||l_inv_details_id);
792:
793: FOR k IN l_covered_inv_tbl(i).wh_line_tbl(j).rct_line_tbl.FIRST..l_covered_inv_tbl(i).wh_line_tbl(j).rct_line_tbl.LAST LOOP
794: BEGIN
795: IF ((l_covered_inv_tbl(i).wh_line_tbl(j).rct_line_tbl(k).date_received >= l_inv_hdr_rec.effective_start_date)

Line 873: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'return status for Insert_LinesLog =>'||l_return_status);

869: ,x_msg_data => l_msg_data
870: ,p_txn_lines_tbl => l_txn_lines_tbl
871: );
872:
873: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'return status for Insert_LinesLog =>'||l_return_status);
874: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
875: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, substr(('Message dat for the DPP Insert_LinesLog API =>'||l_msg_data),1,4000));
876: END IF;
877:

Line 875: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, substr(('Message dat for the DPP Insert_LinesLog API =>'||l_msg_data),1,4000));

871: );
872:
873: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'return status for Insert_LinesLog =>'||l_return_status);
874: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
875: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, substr(('Message dat for the DPP Insert_LinesLog API =>'||l_msg_data),1,4000));
876: END IF;
877:
878:
879: x_return_status := l_return_status;

Line 885: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'end');

881: IF FND_API.to_Boolean(p_commit) THEN
882: COMMIT WORK;
883: END IF;
884:
885: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'end');
886:
887: -- Standard call to get message count and if count is 1, get message info.
888: FND_MSG_PUB.Count_And_Get
889: (p_count => x_msg_count,