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_CUSTOMERCLAIMS_PVT dependencies on DPP_CUSTOMERCLAIMS_PVT

Line 1: PACKAGE BODY DPP_CUSTOMERCLAIMS_PVT AS

1: PACKAGE BODY DPP_CUSTOMERCLAIMS_PVT AS
2: /* $Header: dppvcusb.pls 120.22 2011/06/12 13:37:57 rvkondur ship $ */
3:
4: -- Package name : DPP_CUSTOMERCLAIMS_PVT
5: -- Purpose :

Line 4: -- Package name : DPP_CUSTOMERCLAIMS_PVT

1: PACKAGE BODY DPP_CUSTOMERCLAIMS_PVT AS
2: /* $Header: dppvcusb.pls 120.22 2011/06/12 13:37:57 rvkondur ship $ */
3:
4: -- Package name : DPP_CUSTOMERCLAIMS_PVT
5: -- Purpose :
6: -- History :
7: -- NOTE : Contains Procedures - Select Data for Customer Claims Tab Prepopulation, Populate data in DPP
8: -- End of Comments

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

6: -- History :
7: -- NOTE : Contains Procedures - Select Data for Customer Claims Tab Prepopulation, Populate data in DPP
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_CUSTOMERCLAIMS_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) := 'dppvcusb.pls';
13:
14: ---------------------------------------------------------------------

Line 52: l_cust_hdr_rec DPP_CUSTOMERCLAIMS_PVT.dpp_cust_hdr_rec_type := p_cust_hdr_rec;

48: l_return_status varchar2(30);
49: l_msg_count number;
50: l_msg_data varchar2(4000);
51:
52: l_cust_hdr_rec DPP_CUSTOMERCLAIMS_PVT.dpp_cust_hdr_rec_type := p_cust_hdr_rec;
53: l_customer_tbl DPP_CUSTOMERCLAIMS_PVT.dpp_customer_tbl_type := p_customer_tbl;
54: l_customer_price_tbl DPP_CUSTOMERCLAIMS_PVT.dpp_customer_price_tbl_type;
55: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_CUSTOMERCLAIMS_PVT.SELECT_CUSTOMERPRICE';
56:

Line 53: l_customer_tbl DPP_CUSTOMERCLAIMS_PVT.dpp_customer_tbl_type := p_customer_tbl;

49: l_msg_count number;
50: l_msg_data varchar2(4000);
51:
52: l_cust_hdr_rec DPP_CUSTOMERCLAIMS_PVT.dpp_cust_hdr_rec_type := p_cust_hdr_rec;
53: l_customer_tbl DPP_CUSTOMERCLAIMS_PVT.dpp_customer_tbl_type := p_customer_tbl;
54: l_customer_price_tbl DPP_CUSTOMERCLAIMS_PVT.dpp_customer_price_tbl_type;
55: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_CUSTOMERCLAIMS_PVT.SELECT_CUSTOMERPRICE';
56:
57: CURSOR get_customer_csr (p_org_id IN NUMBER,

Line 54: l_customer_price_tbl DPP_CUSTOMERCLAIMS_PVT.dpp_customer_price_tbl_type;

50: l_msg_data varchar2(4000);
51:
52: l_cust_hdr_rec DPP_CUSTOMERCLAIMS_PVT.dpp_cust_hdr_rec_type := p_cust_hdr_rec;
53: l_customer_tbl DPP_CUSTOMERCLAIMS_PVT.dpp_customer_tbl_type := p_customer_tbl;
54: l_customer_price_tbl DPP_CUSTOMERCLAIMS_PVT.dpp_customer_price_tbl_type;
55: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_CUSTOMERCLAIMS_PVT.SELECT_CUSTOMERPRICE';
56:
57: CURSOR get_customer_csr (p_org_id IN NUMBER,
58: p_inventory_item_id IN NUMBER,

Line 55: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_CUSTOMERCLAIMS_PVT.SELECT_CUSTOMERPRICE';

51:
52: l_cust_hdr_rec DPP_CUSTOMERCLAIMS_PVT.dpp_cust_hdr_rec_type := p_cust_hdr_rec;
53: l_customer_tbl DPP_CUSTOMERCLAIMS_PVT.dpp_customer_tbl_type := p_customer_tbl;
54: l_customer_price_tbl DPP_CUSTOMERCLAIMS_PVT.dpp_customer_price_tbl_type;
55: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_CUSTOMERCLAIMS_PVT.SELECT_CUSTOMERPRICE';
56:
57: CURSOR get_customer_csr (p_org_id IN NUMBER,
58: p_inventory_item_id IN NUMBER,
59: p_start_date IN DATE,

Line 279: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Select_CustomerPrice');

275: WHEN OTHERS THEN
276: ROLLBACK TO Select_CustomerPrice_PVT;
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
279: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Select_CustomerPrice');
280: fnd_message.set_token('ERRNO', sqlcode);
281: fnd_message.set_token('REASON', sqlerrm);
282: FND_MSG_PUB.add;
283: -- Standard call to get message count and if count=1, get the message

Line 359: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_CUSTOMERCLAIMS_PVT.POPULATE_CUSTOMERPRICE';

355: l_supp_claim_amt NUMBER;
356: l_cust_claim_amt NUMBER;
357: l_last_price NUMBER;
358: l_rounding NUMBER := fnd_profile.VALUE('DPP_NEW_PRICE_DECIMAL_PRECISION');
359: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_CUSTOMERCLAIMS_PVT.POPULATE_CUSTOMERPRICE';
360: l_profile_option_value VARCHAR2(20);
361:
362: BEGIN
363: -- Standard begin of API savepoint

Line 573: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Populate_CustomerPrice');

569: 'N');
570: EXCEPTION
571: WHEN OTHERS THEN
572: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
573: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Populate_CustomerPrice');
574: fnd_message.set_token('ERRNO', sqlcode);
575: fnd_message.set_token('REASON', sqlerrm);
576: fnd_msg_pub.add;
577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 723: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Populate_CustomerPrice');

719: WHEN OTHERS THEN
720: ROLLBACK TO Populate_CustomerPrice_PVT;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
723: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Populate_CustomerPrice');
724: fnd_message.set_token('ERRNO', sqlcode);
725: fnd_message.set_token('REASON', sqlerrm);
726: FND_MSG_PUB.ADD;
727: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Error in inserting into DPP_CUSTOMER_CLAIMS_ALL: '||SQLERRM);

Line 744: END DPP_CUSTOMERCLAIMS_PVT;

740:
741:
742: END Populate_CustomerPrice;
743:
744: END DPP_CUSTOMERCLAIMS_PVT;