DBA Data[Home] [Help]

APPS.DPP_PURCHASEPRICE_PVT dependencies on DPP_PURCHASEPRICE_PVT

Line 1: PACKAGE BODY DPP_PURCHASEPRICE_PVT AS

1: PACKAGE BODY DPP_PURCHASEPRICE_PVT AS
2: /* $Header: dppvpopb.pls 120.21.12010000.2 2010/04/21 11:35:15 anbbalas ship $ */
3:
4: -- Package name : DPP_PURCHASEPRICE_PVT
5: -- Purpose :

Line 4: -- Package name : DPP_PURCHASEPRICE_PVT

1: PACKAGE BODY DPP_PURCHASEPRICE_PVT AS
2: /* $Header: dppvpopb.pls 120.21.12010000.2 2010/04/21 11:35:15 anbbalas ship $ */
3:
4: -- Package name : DPP_PURCHASEPRICE_PVT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

Line 51: l_item_price_rec DPP_PURCHASEPRICE_PVT.dpp_txn_hdr_rec_type := p_item_price_rec;

47: l_cur_return_status VARCHAR2(1);
48: l_msg_count NUMBER;
49: l_msg_data VARCHAR2(4000);
50:
51: l_item_price_rec DPP_PURCHASEPRICE_PVT.dpp_txn_hdr_rec_type := p_item_price_rec;
52: l_item_cost_tbl DPP_PURCHASEPRICE_PVT.dpp_item_cost_tbl_type := p_item_cost_tbl;
53: l_po_details_tbl DPP_PURCHASEPRICE_PVT.dpp_po_line_tbl_type;
54: l_exe_update_rec DPP_ExecutionDetails_PVT.DPP_EXE_UPDATE_REC_TYPE;
55: l_status_Update_tbl DPP_ExecutionDetails_PVT.dpp_status_Update_tbl_type;

Line 52: l_item_cost_tbl DPP_PURCHASEPRICE_PVT.dpp_item_cost_tbl_type := p_item_cost_tbl;

48: l_msg_count NUMBER;
49: l_msg_data VARCHAR2(4000);
50:
51: l_item_price_rec DPP_PURCHASEPRICE_PVT.dpp_txn_hdr_rec_type := p_item_price_rec;
52: l_item_cost_tbl DPP_PURCHASEPRICE_PVT.dpp_item_cost_tbl_type := p_item_cost_tbl;
53: l_po_details_tbl DPP_PURCHASEPRICE_PVT.dpp_po_line_tbl_type;
54: l_exe_update_rec DPP_ExecutionDetails_PVT.DPP_EXE_UPDATE_REC_TYPE;
55: l_status_Update_tbl DPP_ExecutionDetails_PVT.dpp_status_Update_tbl_type;
56:

Line 53: l_po_details_tbl DPP_PURCHASEPRICE_PVT.dpp_po_line_tbl_type;

49: l_msg_data VARCHAR2(4000);
50:
51: l_item_price_rec DPP_PURCHASEPRICE_PVT.dpp_txn_hdr_rec_type := p_item_price_rec;
52: l_item_cost_tbl DPP_PURCHASEPRICE_PVT.dpp_item_cost_tbl_type := p_item_cost_tbl;
53: l_po_details_tbl DPP_PURCHASEPRICE_PVT.dpp_po_line_tbl_type;
54: l_exe_update_rec DPP_ExecutionDetails_PVT.DPP_EXE_UPDATE_REC_TYPE;
55: l_status_Update_tbl DPP_ExecutionDetails_PVT.dpp_status_Update_tbl_type;
56:
57: l_new_price NUMBER;

Line 68: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_PURCHASEPRICE_PVT.UPDATE_PURCHASEPRICE';

64:
65: --OutputXML
66: l_output_xml CLOB;
67: l_queryCtx dbms_xmlquery.ctxType;
68: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_PURCHASEPRICE_PVT.UPDATE_PURCHASEPRICE';
69:
70: /* pll.price_override,
71: nvl(pll.price_override,pol.unit_price) unit_price*/
72: CURSOR po_cur(p_inventory_item_id IN NUMBER, p_org_id IN NUMBER, p_vendor_id IN NUMBER) IS

Line 168: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');

164: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module,'Invalid User');
165: RAISE FND_API.G_EXC_ERROR;
166: WHEN OTHERS THEN
167: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
168: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');
169: fnd_message.set_token('ERRNO', sqlcode);
170: fnd_message.set_token('REASON', sqlerrm);
171: FND_MSG_PUB.add;
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 244: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');

240: WHEN NO_DATA_FOUND THEN
241: l_responsibility_id := -1;
242: WHEN OTHERS THEN
243: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
244: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');
245: fnd_message.set_token('ERRNO', sqlcode);
246: fnd_message.set_token('REASON', sqlerrm);
247: FND_MSG_PUB.add;
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 252: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');

248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: END;
250: WHEN OTHERS THEN
251: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
252: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');
253: fnd_message.set_token('ERRNO', sqlcode);
254: fnd_message.set_token('REASON', sqlerrm);
255: FND_MSG_PUB.add;
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 328: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');

324: WHEN NO_DATA_FOUND THEN
325: l_responsibility_id := -1;
326: WHEN OTHERS THEN
327: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
328: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');
329: fnd_message.set_token('ERRNO', sqlcode);
330: fnd_message.set_token('REASON', sqlerrm);
331: FND_MSG_PUB.add;
332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 336: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');

332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
333: END;
334: WHEN OTHERS THEN
335: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
336: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');
337: fnd_message.set_token('ERRNO', sqlcode);
338: fnd_message.set_token('REASON', sqlerrm);
339: FND_MSG_PUB.add;
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 413: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');

409: WHEN NO_DATA_FOUND THEN
410: l_responsibility_id := -1;
411: WHEN OTHERS THEN
412: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
413: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');
414: fnd_message.set_token('ERRNO', sqlcode);
415: fnd_message.set_token('REASON', sqlerrm);
416: FND_MSG_PUB.add;
417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 421: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');

417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418: END;
419: WHEN OTHERS THEN
420: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
421: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');
422: fnd_message.set_token('ERRNO', sqlcode);
423: fnd_message.set_token('REASON', sqlerrm);
424: FND_MSG_PUB.add;
425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

494: WHEN NO_DATA_FOUND THEN
495: l_responsibility_id := -1;
496: WHEN OTHERS THEN
497: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
498: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');
499: fnd_message.set_token('ERRNO', sqlcode);
500: fnd_message.set_token('REASON', sqlerrm);
501: FND_MSG_PUB.add;
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END;
504: WHEN OTHERS THEN
505: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
506: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');
507: fnd_message.set_token('ERRNO', sqlcode);
508: fnd_message.set_token('REASON', sqlerrm);
509: FND_MSG_PUB.add;
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 676: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT.Update_PurchasePrice-XML Generation');

672: EXCEPTION
673: WHEN OTHERS THEN
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
676: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT.Update_PurchasePrice-XML Generation');
677: fnd_message.set_token('ERRNO', sqlcode);
678: fnd_message.set_token('REASON', sqlerrm);
679: FND_MSG_PUB.add;
680: END;

Line 806: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_PURCHASEPRICE_PVT.NOTIFY_PO';

802: IS
803: l_api_name CONSTANT VARCHAR2(30) := 'Notify_PO';
804: l_api_version CONSTANT NUMBER := 1.0;
805: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
806: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_PURCHASEPRICE_PVT.NOTIFY_PO';
807:
808: l_rec_count NUMBER;
809: l_return_status VARCHAR2(1);
810: l_operating_unit_name VARCHAR2(40);

Line 812: l_po_notify_hdr_rec DPP_PURCHASEPRICE_PVT.dpp_po_notify_rec_type := p_po_notify_hdr_rec;

808: l_rec_count NUMBER;
809: l_return_status VARCHAR2(1);
810: l_operating_unit_name VARCHAR2(40);
811:
812: l_po_notify_hdr_rec DPP_PURCHASEPRICE_PVT.dpp_po_notify_rec_type := p_po_notify_hdr_rec;
813: l_po_notify_item_tbl DPP_PURCHASEPRICE_PVT.dpp_po_notify_item_tbl_type := p_po_notify_item_tbl;
814: l_po_details_tbl DPP_PURCHASEPRICE_PVT.dpp_po_details_tbl_type;
815: l_vendor_rec DPP_UTILITY_PVT.vendor_rec_type;
816: l_vendor_site_rec DPP_UTILITY_PVT.vendor_site_rec_type;

Line 813: l_po_notify_item_tbl DPP_PURCHASEPRICE_PVT.dpp_po_notify_item_tbl_type := p_po_notify_item_tbl;

809: l_return_status VARCHAR2(1);
810: l_operating_unit_name VARCHAR2(40);
811:
812: l_po_notify_hdr_rec DPP_PURCHASEPRICE_PVT.dpp_po_notify_rec_type := p_po_notify_hdr_rec;
813: l_po_notify_item_tbl DPP_PURCHASEPRICE_PVT.dpp_po_notify_item_tbl_type := p_po_notify_item_tbl;
814: l_po_details_tbl DPP_PURCHASEPRICE_PVT.dpp_po_details_tbl_type;
815: l_vendor_rec DPP_UTILITY_PVT.vendor_rec_type;
816: l_vendor_site_rec DPP_UTILITY_PVT.vendor_site_rec_type;
817:

Line 814: l_po_details_tbl DPP_PURCHASEPRICE_PVT.dpp_po_details_tbl_type;

810: l_operating_unit_name VARCHAR2(40);
811:
812: l_po_notify_hdr_rec DPP_PURCHASEPRICE_PVT.dpp_po_notify_rec_type := p_po_notify_hdr_rec;
813: l_po_notify_item_tbl DPP_PURCHASEPRICE_PVT.dpp_po_notify_item_tbl_type := p_po_notify_item_tbl;
814: l_po_details_tbl DPP_PURCHASEPRICE_PVT.dpp_po_details_tbl_type;
815: l_vendor_rec DPP_UTILITY_PVT.vendor_rec_type;
816: l_vendor_site_rec DPP_UTILITY_PVT.vendor_site_rec_type;
817:
818: CURSOR get_po_details_csr(p_vendor_id IN NUMBER, p_inventory_item_id IN NUMBER, p_org_id IN NUMBER)

Line 1189: END DPP_PURCHASEPRICE_PVT;

1185: END IF;
1186:
1187: END Notify_PO;
1188:
1189: END DPP_PURCHASEPRICE_PVT;
1190: