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_COVEREDINVENTORY_PVT

Line 1: PACKAGE BODY DPP_COVEREDINVENTORY_PVT AS

1: PACKAGE BODY DPP_COVEREDINVENTORY_PVT AS
2: /* $Header: dppvcovb.pls 120.16.12010000.5 2010/04/26 07:08:11 pvaramba ship $ */
3:
4: -- Package name : DPP_COVEREDINVENTORY_PVT
5: -- Purpose :

Line 4: -- Package name : DPP_COVEREDINVENTORY_PVT

1: PACKAGE BODY DPP_COVEREDINVENTORY_PVT AS
2: /* $Header: dppvcovb.pls 120.16.12010000.5 2010/04/26 07:08:11 pvaramba ship $ */
3:
4: -- Package name : DPP_COVEREDINVENTORY_PVT
5: -- Purpose :
6: -- History :
7: -- NOTE :Contains Procedures - Select Covered Inventory from INV, Populate Covered Inventory in DPP
8: -- End of Comments

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_COVEREDINVENTORY_PVT';

6: -- History :
7: -- NOTE :Contains Procedures - Select Covered Inventory from INV, Populate Covered Inventory in DPP
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_COVEREDINVENTORY_PVT';
11: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
12: G_FILE_NAME CONSTANT VARCHAR2(14) := 'dppvcovb.pls';
13:
14: ---------------------------------------------------------------------

Line 304: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Select_CoveredInventory');

300: WHEN OTHERS THEN
301: ROLLBACK TO Select_CoveredInventory_PVT;
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
304: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Select_CoveredInventory');
305: fnd_message.set_token('ERRNO', sqlcode);
306: fnd_message.set_token('REASON', sqlerrm);
307: FND_MSG_PUB.add;
308: -- Standard call to get message count and if count=1, get the message

Line 358: l_inv_hdr_rec DPP_COVEREDINVENTORY_PVT.dpp_inv_hdr_rec_type := p_inv_hdr_rec;

354: l_return_status VARCHAR2(30);
355: l_msg_count NUMBER;
356: l_msg_data VARCHAR2(4000);
357:
358: l_inv_hdr_rec DPP_COVEREDINVENTORY_PVT.dpp_inv_hdr_rec_type := p_inv_hdr_rec;
359: l_covered_inv_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_tbl_type := p_covered_inv_tbl;
360: l_covered_inv_wh_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_wh_tbl_type;
361: l_covered_inv_rct_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_rct_tbl_type;
362:

Line 359: l_covered_inv_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_tbl_type := p_covered_inv_tbl;

355: l_msg_count NUMBER;
356: l_msg_data VARCHAR2(4000);
357:
358: l_inv_hdr_rec DPP_COVEREDINVENTORY_PVT.dpp_inv_hdr_rec_type := p_inv_hdr_rec;
359: l_covered_inv_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_tbl_type := p_covered_inv_tbl;
360: l_covered_inv_wh_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_wh_tbl_type;
361: l_covered_inv_rct_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_rct_tbl_type;
362:
363: l_inv_details_id NUMBER;

Line 360: l_covered_inv_wh_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_wh_tbl_type;

356: l_msg_data VARCHAR2(4000);
357:
358: l_inv_hdr_rec DPP_COVEREDINVENTORY_PVT.dpp_inv_hdr_rec_type := p_inv_hdr_rec;
359: l_covered_inv_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_tbl_type := p_covered_inv_tbl;
360: l_covered_inv_wh_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_wh_tbl_type;
361: l_covered_inv_rct_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_rct_tbl_type;
362:
363: l_inv_details_id NUMBER;
364: l_include_flag VARCHAR2(1);

Line 361: l_covered_inv_rct_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_rct_tbl_type;

357:
358: l_inv_hdr_rec DPP_COVEREDINVENTORY_PVT.dpp_inv_hdr_rec_type := p_inv_hdr_rec;
359: l_covered_inv_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_tbl_type := p_covered_inv_tbl;
360: l_covered_inv_wh_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_wh_tbl_type;
361: l_covered_inv_rct_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_rct_tbl_type;
362:
363: l_inv_details_id NUMBER;
364: l_include_flag VARCHAR2(1);
365: l_days_out NUMBER;

Line 420: DPP_COVEREDINVENTORY_PVT.Update_CoveredInventory(

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(
421: p_api_version => l_api_version
422: ,p_init_msg_list => FND_API.G_FALSE
423: ,p_commit => FND_API.G_FALSE
424: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 498: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Populate_CoveredInventory');

494: WHEN OTHERS THEN
495: ROLLBACK TO Populate_CoveredInventory_PVT;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
498: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Populate_CoveredInventory');
499: fnd_message.set_token('ERRNO', sqlcode);
500: fnd_message.set_token('REASON', sqlerrm);
501: FND_MSG_PUB.add;
502: -- Standard call to get message count and if count=1, get the message

Line 537: l_inv_hdr_rec DPP_COVEREDINVENTORY_PVT.dpp_inv_hdr_rec_type := p_inv_hdr_rec;

533: l_return_status VARCHAR2(30);
534: l_msg_count NUMBER;
535: l_msg_data VARCHAR2(4000);
536:
537: l_inv_hdr_rec DPP_COVEREDINVENTORY_PVT.dpp_inv_hdr_rec_type := p_inv_hdr_rec;
538: l_covered_inv_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_tbl_type := p_covered_inv_tbl;
539: l_covered_inv_wh_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_wh_tbl_type;
540: l_covered_inv_rct_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_rct_tbl_type;
541: l_inv_details_id NUMBER;

Line 538: l_covered_inv_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_tbl_type := p_covered_inv_tbl;

534: l_msg_count NUMBER;
535: l_msg_data VARCHAR2(4000);
536:
537: l_inv_hdr_rec DPP_COVEREDINVENTORY_PVT.dpp_inv_hdr_rec_type := p_inv_hdr_rec;
538: l_covered_inv_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_tbl_type := p_covered_inv_tbl;
539: l_covered_inv_wh_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_wh_tbl_type;
540: l_covered_inv_rct_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_rct_tbl_type;
541: l_inv_details_id NUMBER;
542: l_txn_lines_tbl DPP_LOG_PVT.dpp_txn_line_tbl_type;

Line 539: l_covered_inv_wh_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_wh_tbl_type;

535: l_msg_data VARCHAR2(4000);
536:
537: l_inv_hdr_rec DPP_COVEREDINVENTORY_PVT.dpp_inv_hdr_rec_type := p_inv_hdr_rec;
538: l_covered_inv_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_tbl_type := p_covered_inv_tbl;
539: l_covered_inv_wh_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_wh_tbl_type;
540: l_covered_inv_rct_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_rct_tbl_type;
541: l_inv_details_id NUMBER;
542: l_txn_lines_tbl DPP_LOG_PVT.dpp_txn_line_tbl_type;
543: l_include_flag VARCHAR2(1);

Line 540: l_covered_inv_rct_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_rct_tbl_type;

536:
537: l_inv_hdr_rec DPP_COVEREDINVENTORY_PVT.dpp_inv_hdr_rec_type := p_inv_hdr_rec;
538: l_covered_inv_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_tbl_type := p_covered_inv_tbl;
539: l_covered_inv_wh_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_wh_tbl_type;
540: l_covered_inv_rct_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_rct_tbl_type;
541: l_inv_details_id NUMBER;
542: l_txn_lines_tbl DPP_LOG_PVT.dpp_txn_line_tbl_type;
543: l_include_flag VARCHAR2(1);
544: l_flag VARCHAR2(1);

Line 747: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Update_CoveredInventory - Delete rows');

743: NULL;
744: WHEN OTHERS THEN
745: IF g_debug THEN
746: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
747: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Update_CoveredInventory - Delete rows');
748: fnd_message.set_token('ERRNO', sqlcode);
749: fnd_message.set_token('REASON', sqlerrm);
750: FND_MSG_PUB.add;
751: END IF;

Line 944: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Update_CoveredInventory');

940: WHEN OTHERS THEN
941: ROLLBACK TO Update_CoveredInventory_PVT;
942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
943: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
944: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Update_CoveredInventory');
945: fnd_message.set_token('ERRNO', sqlcode);
946: fnd_message.set_token('REASON', sqlerrm);
947: FND_MSG_PUB.add;
948: -- Standard call to get message count and if count=1, get the message

Line 963: END DPP_COVEREDINVENTORY_PVT;

959:
960:
961: END Update_CoveredInventory;
962:
963: END DPP_COVEREDINVENTORY_PVT;