APPS.DPP_LISTPRICE_PVT dependencies on DPP_LISTPRICE_PVT

Line 1: PACKAGE BODY DPP_LISTPRICE_PVT AS

1: PACKAGE BODY DPP_LISTPRICE_PVT AS
2: /* $Header: dppvlprb.pls 120.19.12010000.2 2010/04/21 11:33:45 anbbalas ship $ */
3:
4: -- Package name : DPP_LISTPRICE_PVT
5: -- Purpose :

Line 4: -- Package name : DPP_LISTPRICE_PVT

1: PACKAGE BODY DPP_LISTPRICE_PVT AS
2: /* $Header: dppvlprb.pls 120.19.12010000.2 2010/04/21 11:33:45 anbbalas ship $ */
3:
4: -- Package name : DPP_LISTPRICE_PVT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_LISTPRICE_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) := 'dppvlprb.pls';
13:
14: ---------------------------------------------------------------------

Line 43: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_LISTPRICE_PVT.UPDATE_LISTPRICE';

39: IS
40: l_api_name CONSTANT VARCHAR2(30) := 'Update_ListPrice';
41: l_api_version CONSTANT NUMBER := 1.0;
42: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
43: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_LISTPRICE_PVT.UPDATE_LISTPRICE';
44:
45: l_return_status VARCHAR2(30);
46: l_msg_count NUMBER;
47: l_msg_data VARCHAR2(4000);

Line 49: l_txn_hdr_rec DPP_LISTPRICE_PVT.dpp_txn_hdr_rec_type := p_txn_hdr_rec;

45: l_return_status VARCHAR2(30);
46: l_msg_count NUMBER;
47: l_msg_data VARCHAR2(4000);
48:
49: l_txn_hdr_rec DPP_LISTPRICE_PVT.dpp_txn_hdr_rec_type := p_txn_hdr_rec;
50: l_item_cost_tbl DPP_LISTPRICE_PVT.dpp_txn_line_tbl_type := p_item_cost_tbl;
51: l_exe_update_rec DPP_ExecutionDetails_PVT.DPP_EXE_UPDATE_REC_TYPE;
52: l_status_Update_tbl DPP_ExecutionDetails_PVT.dpp_status_Update_tbl_type;
53:

Line 50: l_item_cost_tbl DPP_LISTPRICE_PVT.dpp_txn_line_tbl_type := p_item_cost_tbl;

46: l_msg_count NUMBER;
47: l_msg_data VARCHAR2(4000);
48:
49: l_txn_hdr_rec DPP_LISTPRICE_PVT.dpp_txn_hdr_rec_type := p_txn_hdr_rec;
50: l_item_cost_tbl DPP_LISTPRICE_PVT.dpp_txn_line_tbl_type := p_item_cost_tbl;
51: l_exe_update_rec DPP_ExecutionDetails_PVT.DPP_EXE_UPDATE_REC_TYPE;
52: l_status_Update_tbl DPP_ExecutionDetails_PVT.dpp_status_Update_tbl_type;
53:
54: l_to_amount NUMBER := 0;

Line 150: fnd_message.set_token('ROUTINE', 'DPP_LISTPRICE_PVT');

146: END IF;
147: RAISE FND_API.G_EXC_ERROR;
148: WHEN OTHERS THEN
149: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
150: fnd_message.set_token('ROUTINE', 'DPP_LISTPRICE_PVT');
151: fnd_message.set_token('ERRNO', sqlcode);
152: fnd_message.set_token('REASON', sqlerrm);
153: FND_MSG_PUB.add;
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 285: fnd_message.set_token('ROUTINE', 'DPP_LISTPRICE_PVT.Update_ListPrice');

281: EXCEPTION
282: WHEN OTHERS THEN
283: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
285: fnd_message.set_token('ROUTINE', 'DPP_LISTPRICE_PVT.Update_ListPrice');
286: fnd_message.set_token('ERRNO', sqlcode);
287: fnd_message.set_token('REASON', sqlerrm);
288: fnd_msg_pub.add;
289: END;

Line 421: END DPP_LISTPRICE_PVT;

417: END IF;
418:
419: END Update_ListPrice;
420:
421: END DPP_LISTPRICE_PVT;