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_PRICING_PVT dependencies on DPP_PRICING_PVT

Line 1: PACKAGE BODY DPP_PRICING_PVT AS

1: PACKAGE BODY DPP_PRICING_PVT AS
2: /* $Header: dppvqpnb.pls 120.7.12010000.3 2010/04/26 07:09:09 pvaramba ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- DPP_PRICING_PVT

2: /* $Header: dppvqpnb.pls 120.7.12010000.3 2010/04/26 07:09:09 pvaramba ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- DPP_PRICING_PVT
7: -- Purpose
8: -- Contains all APIs for Pricing Notifications
9: -- History
10: --

Line 16: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_PRICING_PVT';

12: --
13: -- End of Comments
14: -- ===============================================================
15:
16: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_PRICING_PVT';
17:
18: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
19: G_FILE_NAME CONSTANT VARCHAR2(14) := 'dppvqpnb.pls';
20: g_trunc_sysdate DATE := trunc(sysdate);

Line 66: l_pl_notify_line_tbl DPP_PRICING_PVT.dpp_pl_notify_line_tbl_type := p_pl_notify_line_tbl;

62:
63: l_result NUMBER;
64: l_return_status VARCHAR2(30);
65: l_pl_notify_hdr_rec dpp_pl_notify_rec_type := p_pl_notify_hdr_rec;
66: l_pl_notify_line_tbl DPP_PRICING_PVT.dpp_pl_notify_line_tbl_type := p_pl_notify_line_tbl;
67: l_pricelist_tbl DPP_PRICING_PVT.dpp_object_name_tbl_type;
68:
69: CURSOR get_pricelist_csr(p_inventory_item_id IN NUMBER, p_org_id IN NUMBER)
70: IS

Line 67: l_pricelist_tbl DPP_PRICING_PVT.dpp_object_name_tbl_type;

63: l_result NUMBER;
64: l_return_status VARCHAR2(30);
65: l_pl_notify_hdr_rec dpp_pl_notify_rec_type := p_pl_notify_hdr_rec;
66: l_pl_notify_line_tbl DPP_PRICING_PVT.dpp_pl_notify_line_tbl_type := p_pl_notify_line_tbl;
67: l_pricelist_tbl DPP_PRICING_PVT.dpp_object_name_tbl_type;
68:
69: CURSOR get_pricelist_csr(p_inventory_item_id IN NUMBER, p_org_id IN NUMBER)
70: IS
71:

Line 282: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_OutboundPricelists');

278:
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
281: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
282: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_OutboundPricelists');
283: fnd_message.set_token('ERRNO', sqlcode);
284: fnd_message.set_token('REASON', sqlerrm);
285: END IF;
286: -- Standard call to get message count and if count=1, get the message

Line 344: l_pl_notify_hdr_rec DPP_PRICING_PVT.dpp_pl_notify_rec_type := p_pl_notify_hdr_rec;

340: l_api_version CONSTANT NUMBER := 1.0;
341: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
342:
343: l_result NUMBER;
344: l_pl_notify_hdr_rec DPP_PRICING_PVT.dpp_pl_notify_rec_type := p_pl_notify_hdr_rec;
345: l_pl_notify_line_tbl DPP_PRICING_PVT.dpp_pl_notify_line_tbl_type := p_pl_notify_line_tbl;
346: l_pricelist_tbl DPP_PRICING_PVT.dpp_object_name_tbl_type;
347:
348: CURSOR get_pricelist_csr(p_inventory_item_id IN NUMBER, p_vendor_id IN NUMBER,p_vendor_site_id IN NUMBER, p_org_id IN NUMBER)

Line 345: l_pl_notify_line_tbl DPP_PRICING_PVT.dpp_pl_notify_line_tbl_type := p_pl_notify_line_tbl;

341: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
342:
343: l_result NUMBER;
344: l_pl_notify_hdr_rec DPP_PRICING_PVT.dpp_pl_notify_rec_type := p_pl_notify_hdr_rec;
345: l_pl_notify_line_tbl DPP_PRICING_PVT.dpp_pl_notify_line_tbl_type := p_pl_notify_line_tbl;
346: l_pricelist_tbl DPP_PRICING_PVT.dpp_object_name_tbl_type;
347:
348: CURSOR get_pricelist_csr(p_inventory_item_id IN NUMBER, p_vendor_id IN NUMBER,p_vendor_site_id IN NUMBER, p_org_id IN NUMBER)
349: IS

Line 346: l_pricelist_tbl DPP_PRICING_PVT.dpp_object_name_tbl_type;

342:
343: l_result NUMBER;
344: l_pl_notify_hdr_rec DPP_PRICING_PVT.dpp_pl_notify_rec_type := p_pl_notify_hdr_rec;
345: l_pl_notify_line_tbl DPP_PRICING_PVT.dpp_pl_notify_line_tbl_type := p_pl_notify_line_tbl;
346: l_pricelist_tbl DPP_PRICING_PVT.dpp_object_name_tbl_type;
347:
348: CURSOR get_pricelist_csr(p_inventory_item_id IN NUMBER, p_vendor_id IN NUMBER,p_vendor_site_id IN NUMBER, p_org_id IN NUMBER)
349: IS
350: SELECT qlh.name Pricelist_Name

Line 576: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_InboundPricelists');

572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
573: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
574: THEN
575: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
576: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_InboundPricelists');
577: fnd_message.set_token('ERRNO', sqlcode);
578: fnd_message.set_token('REASON', sqlerrm);
579: FND_MSG_PUB.ADD;
580: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Error in notify inbound pricelists: '||SQLERRM);

Line 640: l_pl_notify_hdr_rec DPP_PRICING_PVT.dpp_pl_notify_rec_type := p_pl_notify_hdr_rec;

636:
637: l_result NUMBER;
638: l_count NUMBER;
639:
640: l_pl_notify_hdr_rec DPP_PRICING_PVT.dpp_pl_notify_rec_type := p_pl_notify_hdr_rec;
641: l_pl_notify_line_tbl DPP_PRICING_PVT.dpp_pl_notify_line_tbl_type := p_pl_notify_line_tbl;
642: l_offer_tbl DPP_PRICING_PVT.dpp_object_name_tbl_type;
643:
644: CURSOR get_offers_csr(p_inventory_item_id IN NUMBER) IS

Line 641: l_pl_notify_line_tbl DPP_PRICING_PVT.dpp_pl_notify_line_tbl_type := p_pl_notify_line_tbl;

637: l_result NUMBER;
638: l_count NUMBER;
639:
640: l_pl_notify_hdr_rec DPP_PRICING_PVT.dpp_pl_notify_rec_type := p_pl_notify_hdr_rec;
641: l_pl_notify_line_tbl DPP_PRICING_PVT.dpp_pl_notify_line_tbl_type := p_pl_notify_line_tbl;
642: l_offer_tbl DPP_PRICING_PVT.dpp_object_name_tbl_type;
643:
644: CURSOR get_offers_csr(p_inventory_item_id IN NUMBER) IS
645: SELECT oov.name offer_name

Line 642: l_offer_tbl DPP_PRICING_PVT.dpp_object_name_tbl_type;

638: l_count NUMBER;
639:
640: l_pl_notify_hdr_rec DPP_PRICING_PVT.dpp_pl_notify_rec_type := p_pl_notify_hdr_rec;
641: l_pl_notify_line_tbl DPP_PRICING_PVT.dpp_pl_notify_line_tbl_type := p_pl_notify_line_tbl;
642: l_offer_tbl DPP_PRICING_PVT.dpp_object_name_tbl_type;
643:
644: CURSOR get_offers_csr(p_inventory_item_id IN NUMBER) IS
645: SELECT oov.name offer_name
646: FROM ozf_offers_v oov,

Line 872: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_Promotions');

868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
869: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
870: THEN
871: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
872: fnd_message.set_token('ROUTINE', 'DPP_PRICING_PVT.Notify_Promotions');
873: fnd_message.set_token('ERRNO', sqlcode);
874: fnd_message.set_token('REASON', sqlerrm);
875: FND_MSG_PUB.ADD;
876: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Error in notify promotions: '||SQLERRM);

Line 892: END DPP_PRICING_PVT;

888: END IF;
889:
890: END Notify_Promotions;
891:
892: END DPP_PRICING_PVT;