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_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 2008/05/28 09:48:41 sdasan noship $ */
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 2008/05/28 09:48:41 sdasan noship $ */
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 168: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');

164: DPP_UTILITY_PVT.debug_message('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 684: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT.Update_PurchasePrice-XML Generation');

680: EXCEPTION
681: WHEN OTHERS THEN
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
683: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
684: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT.Update_PurchasePrice-XML Generation');
685: fnd_message.set_token('ERRNO', sqlcode);
686: fnd_message.set_token('REASON', sqlerrm);
687: FND_MSG_PUB.add;
688: END;

Line 821: l_po_notify_hdr_rec DPP_PURCHASEPRICE_PVT.dpp_po_notify_rec_type := p_po_notify_hdr_rec;

817: l_rec_count NUMBER;
818: l_return_status VARCHAR2(1);
819: l_operating_unit_name VARCHAR2(40);
820:
821: l_po_notify_hdr_rec DPP_PURCHASEPRICE_PVT.dpp_po_notify_rec_type := p_po_notify_hdr_rec;
822: l_po_notify_item_tbl DPP_PURCHASEPRICE_PVT.dpp_po_notify_item_tbl_type := p_po_notify_item_tbl;
823: l_po_details_tbl DPP_PURCHASEPRICE_PVT.dpp_po_details_tbl_type;
824: l_vendor_rec DPP_UTILITY_PVT.vendor_rec_type;
825: l_vendor_site_rec DPP_UTILITY_PVT.vendor_site_rec_type;

Line 822: l_po_notify_item_tbl DPP_PURCHASEPRICE_PVT.dpp_po_notify_item_tbl_type := p_po_notify_item_tbl;

818: l_return_status VARCHAR2(1);
819: l_operating_unit_name VARCHAR2(40);
820:
821: l_po_notify_hdr_rec DPP_PURCHASEPRICE_PVT.dpp_po_notify_rec_type := p_po_notify_hdr_rec;
822: l_po_notify_item_tbl DPP_PURCHASEPRICE_PVT.dpp_po_notify_item_tbl_type := p_po_notify_item_tbl;
823: l_po_details_tbl DPP_PURCHASEPRICE_PVT.dpp_po_details_tbl_type;
824: l_vendor_rec DPP_UTILITY_PVT.vendor_rec_type;
825: l_vendor_site_rec DPP_UTILITY_PVT.vendor_site_rec_type;
826:

Line 823: l_po_details_tbl DPP_PURCHASEPRICE_PVT.dpp_po_details_tbl_type;

819: l_operating_unit_name VARCHAR2(40);
820:
821: l_po_notify_hdr_rec DPP_PURCHASEPRICE_PVT.dpp_po_notify_rec_type := p_po_notify_hdr_rec;
822: l_po_notify_item_tbl DPP_PURCHASEPRICE_PVT.dpp_po_notify_item_tbl_type := p_po_notify_item_tbl;
823: l_po_details_tbl DPP_PURCHASEPRICE_PVT.dpp_po_details_tbl_type;
824: l_vendor_rec DPP_UTILITY_PVT.vendor_rec_type;
825: l_vendor_site_rec DPP_UTILITY_PVT.vendor_site_rec_type;
826:
827: CURSOR get_po_details_csr(p_vendor_id IN NUMBER, p_inventory_item_id IN NUMBER, p_org_id IN NUMBER)

Line 1199: END DPP_PURCHASEPRICE_PVT;

1195: END IF;
1196:
1197: END Notify_PO;
1198:
1199: END DPP_PURCHASEPRICE_PVT;
1200: