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 DPP_UTILITY_PVT

Line 149: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

145: FND_MSG_PUB.initialize;
146: END IF;
147: -- Debug Message
148: IF g_debug THEN
149: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
150: END IF;
151: -- Initialize API return status to sucess
152: l_return_status := FND_API.G_RET_STS_SUCCESS;
153: --

Line 217: DPP_UTILITY_PVT.debug_message('On Hand Quantity: '||l_covered_inv_tbl(i).onhand_quantity);

213: END LOOP;
214: END IF; --ware house level details only if the covered quantiy > 0
215: l_covered_inv_tbl(i).wh_line_tbl := l_covered_inv_wh_tbl;
216: END LOOP;
217: DPP_UTILITY_PVT.debug_message('On Hand Quantity: '||l_covered_inv_tbl(i).onhand_quantity);
218: DPP_UTILITY_PVT.debug_message('Covered Quantity: '||l_covered_inv_tbl(i).covered_quantity);
219: DPP_UTILITY_PVT.debug_message('inventory_item_id: '||l_covered_inv_tbl(i).inventory_item_id);
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('Covered Quantity: '||l_covered_inv_tbl(i).covered_quantity);

214: END IF; --ware house level details only if the covered quantiy > 0
215: l_covered_inv_tbl(i).wh_line_tbl := l_covered_inv_wh_tbl;
216: END LOOP;
217: DPP_UTILITY_PVT.debug_message('On Hand Quantity: '||l_covered_inv_tbl(i).onhand_quantity);
218: DPP_UTILITY_PVT.debug_message('Covered Quantity: '||l_covered_inv_tbl(i).covered_quantity);
219: DPP_UTILITY_PVT.debug_message('inventory_item_id: '||l_covered_inv_tbl(i).inventory_item_id);
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 219: DPP_UTILITY_PVT.debug_message('inventory_item_id: '||l_covered_inv_tbl(i).inventory_item_id);

215: l_covered_inv_tbl(i).wh_line_tbl := l_covered_inv_wh_tbl;
216: END LOOP;
217: DPP_UTILITY_PVT.debug_message('On Hand Quantity: '||l_covered_inv_tbl(i).onhand_quantity);
218: DPP_UTILITY_PVT.debug_message('Covered Quantity: '||l_covered_inv_tbl(i).covered_quantity);
219: DPP_UTILITY_PVT.debug_message('inventory_item_id: '||l_covered_inv_tbl(i).inventory_item_id);
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;
223: BEGIN

Line 234: DPP_UTILITY_PVT.debug_message ('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 ('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 245: DPP_UTILITY_pvt.debug_message ('select_coveredinventory(): x_return_status: ' || x_return_status);

241: END IF;
242: p_covered_inv_tbl := l_covered_inv_tbl;
243: x_return_status := l_return_status;
244: IF DPP_DEBUG_HIGH_ON THEN
245: DPP_UTILITY_pvt.debug_message ('select_coveredinventory(): x_return_status: ' || x_return_status);
246: END IF;
247:
248: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 261: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

257: COMMIT WORK;
258: END IF;
259: -- Debug Message
260: IF g_debug THEN
261: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
262: END IF;
263: -- Standard call to get message count and if count is 1, get message info.
264: FND_MSG_PUB.Count_And_Get
265: (p_count => x_msg_count,

Line 393: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

389: END IF;
390:
391: -- Debug Message
392: IF g_debug THEN
393: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
394: END IF;
395: -- Initialize API return status to sucess
396: l_return_status := FND_API.G_RET_STS_SUCCESS;
397: --

Line 415: DPP_UTILITY_PVT.debug_message('Invalid value for Execution Detail ID: ' || l_inv_hdr_rec.Execution_Detail_ID);

411:
412: IF SQL%ROWCOUNT = 0 THEN
413: -- Debug Message
414: IF g_debug THEN
415: DPP_UTILITY_PVT.debug_message('Invalid value for Execution Detail ID: ' || l_inv_hdr_rec.Execution_Detail_ID);
416: RAISE FND_API.G_EXC_ERROR;
417: END IF;
418: END IF;
419:

Line 422: DPP_UTILITY_PVT.debug_message(substr(('Error in Updating DPP_EXECUTION_DETAILS: ' || SQLERRM || ' from Populate Covered Inventory API'),1,4000));

418: END IF;
419:
420: EXCEPTION
421: WHEN OTHERS THEN
422: DPP_UTILITY_PVT.debug_message(substr(('Error in Updating DPP_EXECUTION_DETAILS: ' || SQLERRM || ' from Populate Covered Inventory API'),1,4000));
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424: END ;
425:
426: DPP_COVEREDINVENTORY_PVT.Update_CoveredInventory(

Line 447: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

443: COMMIT WORK;
444: END IF;
445: -- Debug Message
446: IF g_debug THEN
447: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
448: END IF;
449: -- Standard call to get message count and if count is 1, get message info.
450: FND_MSG_PUB.Count_And_Get
451: (p_count => x_msg_count,

Line 457: WHEN DPP_UTILITY_PVT.resource_locked THEN

453: );
454:
455: --Exception Handling
456: EXCEPTION
457: WHEN DPP_UTILITY_PVT.resource_locked THEN
458: ROLLBACK TO Populate_CoveredInventory_PVT;
459: x_return_status := FND_API.g_ret_sts_error;
460: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');
461: FND_MSG_PUB.Count_And_Get (

Line 460: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');

456: EXCEPTION
457: WHEN DPP_UTILITY_PVT.resource_locked THEN
458: ROLLBACK TO Populate_CoveredInventory_PVT;
459: x_return_status := FND_API.g_ret_sts_error;
460: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');
461: FND_MSG_PUB.Count_And_Get (
462: p_encoded => FND_API.G_FALSE,
463: p_count => x_msg_count,
464: p_data => x_msg_data

Line 579: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

575: FND_MSG_PUB.initialize;
576: END IF;
577: -- Debug Message
578: IF g_debug THEN
579: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
580: END IF;
581: -- Initialize API return status to sucess
582: l_return_status := FND_API.G_RET_STS_SUCCESS;
583: --

Line 636: DPP_UTILITY_PVT.debug_message('Invalid value for Transaction Line ID: ' || l_covered_inv_tbl(i).Transaction_Line_Id);

632: last_calculated_date = l_sysdate
633: WHERE transaction_line_id = l_covered_inv_tbl(i).Transaction_Line_Id;
634: IF SQL%ROWCOUNT = 0 THEN
635: -- Debug Message
636: DPP_UTILITY_PVT.debug_message('Invalid value for Transaction Line ID: ' || l_covered_inv_tbl(i).Transaction_Line_Id);
637:
638: RAISE FND_API.G_EXC_ERROR;
639: END IF;
640: EXCEPTION

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

Line 663: DPP_UTILITY_PVT.debug_message('Org Id: ' || l_inv_hdr_rec.org_id || 'transaction_line_id ' || l_covered_inv_tbl(i).Transaction_Line_Id);

659: l_txn_lines_tbl(i).last_calculated_date := l_sysdate;
660: l_txn_lines_tbl(i).onhand_inventory := NVL(l_covered_inv_tbl(i).Onhand_Quantity,0);
661:
662: BEGIN
663: DPP_UTILITY_PVT.debug_message('Org Id: ' || l_inv_hdr_rec.org_id || 'transaction_line_id ' || l_covered_inv_tbl(i).Transaction_Line_Id);
664: -- Delete existing rows in DPP_INVENTORY_DETAILS_ADJ_ALL (if any)
665: SELECT
666: inventory_details_id
667: BULK COLLECT INTO

Line 735: DPP_UTILITY_PVT.debug_message('Inventory Details ID: '||l_inv_details_id);

731: l_covered_inv_tbl(i).inventory_item_id,
732: l_inv_hdr_rec.org_id,
733: l_covered_inv_tbl(i).wh_line_tbl(j).Warehouse_id,
734: 1);
735: DPP_UTILITY_PVT.debug_message('Inventory Details ID: '||l_inv_details_id);
736: 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
737: BEGIN
738: IF ((l_covered_inv_tbl(i).wh_line_tbl(j).rct_line_tbl(k).date_received >= l_inv_hdr_rec.effective_start_date)
739: AND (l_covered_inv_tbl(i).wh_line_tbl(j).rct_line_tbl(k).date_received < l_inv_hdr_rec.effective_end_date)) THEN

Line 816: dpp_utility_pvt.debug_message('return status for Insert_LinesLog =>'||l_return_status);

812: ,x_msg_data => l_msg_data
813: ,p_txn_lines_tbl => l_txn_lines_tbl
814: );
815: IF g_debug THEN
816: dpp_utility_pvt.debug_message('return status for Insert_LinesLog =>'||l_return_status);
817: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
818: dpp_utility_pvt.debug_message(substr(('Message dat for the DPP Insert_LinesLog API =>'||l_msg_data),1,4000));
819: END IF;
820: END IF;

Line 818: dpp_utility_pvt.debug_message(substr(('Message dat for the DPP Insert_LinesLog API =>'||l_msg_data),1,4000));

814: );
815: IF g_debug THEN
816: dpp_utility_pvt.debug_message('return status for Insert_LinesLog =>'||l_return_status);
817: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
818: dpp_utility_pvt.debug_message(substr(('Message dat for the DPP Insert_LinesLog API =>'||l_msg_data),1,4000));
819: END IF;
820: END IF;
821:
822: x_return_status := l_return_status;

Line 829: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

825: COMMIT WORK;
826: END IF;
827: -- Debug Message
828: IF g_debug THEN
829: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
830: END IF;
831: -- Standard call to get message count and if count is 1, get message info.
832: FND_MSG_PUB.Count_And_Get
833: (p_count => x_msg_count,

Line 839: WHEN DPP_UTILITY_PVT.resource_locked THEN

835: );
836:
837: --Exception Handling
838: EXCEPTION
839: WHEN DPP_UTILITY_PVT.resource_locked THEN
840: ROLLBACK TO Update_CoveredInventory_PVT;
841: x_return_status := FND_API.g_ret_sts_error;
842: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');
843: FND_MSG_PUB.Count_And_Get (

Line 842: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');

838: EXCEPTION
839: WHEN DPP_UTILITY_PVT.resource_locked THEN
840: ROLLBACK TO Update_CoveredInventory_PVT;
841: x_return_status := FND_API.g_ret_sts_error;
842: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');
843: FND_MSG_PUB.Count_And_Get (
844: p_encoded => FND_API.G_FALSE,
845: p_count => x_msg_count,
846: p_data => x_msg_data