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 2008/06/11 06:00:24 sanagar noship $ */
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 2008/06/11 06:00:24 sanagar noship $ */
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 307: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Select_CoveredInventory');

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

Line 361: l_inv_hdr_rec DPP_COVEREDINVENTORY_PVT.dpp_inv_hdr_rec_type := p_inv_hdr_rec;

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

Line 362: l_covered_inv_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_tbl_type := p_covered_inv_tbl;

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

Line 363: l_covered_inv_wh_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_wh_tbl_type;

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

Line 364: l_covered_inv_rct_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_rct_tbl_type;

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

Line 426: DPP_COVEREDINVENTORY_PVT.Update_CoveredInventory(

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(
427: p_api_version => l_api_version
428: ,p_init_msg_list => FND_API.G_FALSE
429: ,p_commit => FND_API.G_FALSE
430: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

502: WHEN OTHERS THEN
503: ROLLBACK TO Populate_CoveredInventory_PVT;
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
506: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Populate_CoveredInventory');
507: fnd_message.set_token('ERRNO', sqlcode);
508: fnd_message.set_token('REASON', sqlerrm);
509: FND_MSG_PUB.add;
510: -- Standard call to get message count and if count=1, get the message

Line 545: l_inv_hdr_rec DPP_COVEREDINVENTORY_PVT.dpp_inv_hdr_rec_type := p_inv_hdr_rec;

541: l_return_status VARCHAR2(30);
542: l_msg_count NUMBER;
543: l_msg_data VARCHAR2(4000);
544:
545: l_inv_hdr_rec DPP_COVEREDINVENTORY_PVT.dpp_inv_hdr_rec_type := p_inv_hdr_rec;
546: l_covered_inv_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_tbl_type := p_covered_inv_tbl;
547: l_covered_inv_wh_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_wh_tbl_type;
548: l_covered_inv_rct_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_rct_tbl_type;
549: l_inv_details_id NUMBER;

Line 546: l_covered_inv_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_tbl_type := p_covered_inv_tbl;

542: l_msg_count NUMBER;
543: l_msg_data VARCHAR2(4000);
544:
545: l_inv_hdr_rec DPP_COVEREDINVENTORY_PVT.dpp_inv_hdr_rec_type := p_inv_hdr_rec;
546: l_covered_inv_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_tbl_type := p_covered_inv_tbl;
547: l_covered_inv_wh_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_wh_tbl_type;
548: l_covered_inv_rct_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_rct_tbl_type;
549: l_inv_details_id NUMBER;
550: l_txn_lines_tbl DPP_LOG_PVT.dpp_txn_line_tbl_type;

Line 547: l_covered_inv_wh_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_wh_tbl_type;

543: l_msg_data VARCHAR2(4000);
544:
545: l_inv_hdr_rec DPP_COVEREDINVENTORY_PVT.dpp_inv_hdr_rec_type := p_inv_hdr_rec;
546: l_covered_inv_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_tbl_type := p_covered_inv_tbl;
547: l_covered_inv_wh_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_wh_tbl_type;
548: l_covered_inv_rct_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_rct_tbl_type;
549: l_inv_details_id NUMBER;
550: l_txn_lines_tbl DPP_LOG_PVT.dpp_txn_line_tbl_type;
551: l_include_flag VARCHAR2(1);

Line 548: l_covered_inv_rct_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_rct_tbl_type;

544:
545: l_inv_hdr_rec DPP_COVEREDINVENTORY_PVT.dpp_inv_hdr_rec_type := p_inv_hdr_rec;
546: l_covered_inv_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_tbl_type := p_covered_inv_tbl;
547: l_covered_inv_wh_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_wh_tbl_type;
548: l_covered_inv_rct_tbl DPP_COVEREDINVENTORY_PVT.dpp_inv_cov_rct_tbl_type;
549: l_inv_details_id NUMBER;
550: l_txn_lines_tbl DPP_LOG_PVT.dpp_txn_line_tbl_type;
551: l_include_flag VARCHAR2(1);
552: l_flag VARCHAR2(1);

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

688: NULL;
689: WHEN OTHERS THEN
690: IF g_debug THEN
691: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
692: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Update_CoveredInventory - Delete rows');
693: fnd_message.set_token('ERRNO', sqlcode);
694: fnd_message.set_token('REASON', sqlerrm);
695: FND_MSG_PUB.add;
696: END IF;

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

884: WHEN OTHERS THEN
885: ROLLBACK TO Update_CoveredInventory_PVT;
886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
887: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
888: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Update_CoveredInventory');
889: fnd_message.set_token('ERRNO', sqlcode);
890: fnd_message.set_token('REASON', sqlerrm);
891: FND_MSG_PUB.add;
892: -- Standard call to get message count and if count=1, get the message

Line 907: END DPP_COVEREDINVENTORY_PVT;

903:
904:
905: END Update_CoveredInventory;
906:
907: END DPP_COVEREDINVENTORY_PVT;