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_UIWRAPPER_PVT dependencies on FND_MSG_PUB

Line 26: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

22:
23: WHEN OTHERS THEN
24: x_return_status := fnd_api.g_ret_sts_unexp_error;
25:
26: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
27: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
28: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.check_txnclose');
29: fnd_message.set_token('ERRNO', sqlcode);
30: fnd_message.set_token('REASON', sqlerrm);

Line 31: FND_MSG_PUB.ADD;

27: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
28: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.check_txnclose');
29: fnd_message.set_token('ERRNO', sqlcode);
30: fnd_message.set_token('REASON', sqlerrm);
31: FND_MSG_PUB.ADD;
32: END IF;
33: END check_transaction;
34:
35: PROCEDURE search_vendors(

Line 72: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

68: EXCEPTION
69: WHEN OTHERS THEN
70: x_return_status := fnd_api.g_ret_sts_unexp_error;
71:
72: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
73: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
74: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendors');
75: fnd_message.set_token('ERRNO', sqlcode);
76: fnd_message.set_token('REASON', sqlerrm);

Line 77: FND_MSG_PUB.add;

73: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
74: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendors');
75: fnd_message.set_token('ERRNO', sqlcode);
76: fnd_message.set_token('REASON', sqlerrm);
77: FND_MSG_PUB.add;
78: END IF;
79: END search_vendors;
80:
81: PROCEDURE search_vendor_sites(

Line 125: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

121: EXCEPTION
122: WHEN OTHERS THEN
123: x_return_status := fnd_api.g_ret_sts_unexp_error;
124:
125: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
126: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
127: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendor_sites');
128: fnd_message.set_token('ERRNO', sqlcode);
129: fnd_message.set_token('REASON', sqlerrm);

Line 130: FND_MSG_PUB.add;

126: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
127: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendor_sites');
128: fnd_message.set_token('ERRNO', sqlcode);
129: fnd_message.set_token('REASON', sqlerrm);
130: FND_MSG_PUB.add;
131: END IF;
132: END search_vendor_sites;
133:
134: PROCEDURE search_vendor_contacts(

Line 174: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

170: EXCEPTION
171: WHEN OTHERS THEN
172: x_return_status := fnd_api.g_ret_sts_unexp_error;
173:
174: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
175: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
176: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendor_contacts');
177: fnd_message.set_token('ERRNO', sqlcode);
178: fnd_message.set_token('REASON', sqlerrm);

Line 179: FND_MSG_PUB.add;

175: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
176: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendor_contacts');
177: fnd_message.set_token('ERRNO', sqlcode);
178: fnd_message.set_token('REASON', sqlerrm);
179: FND_MSG_PUB.add;
180: END IF;
181: END search_vendor_contacts;
182:
183: PROCEDURE search_items(

Line 221: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

217: EXCEPTION
218: WHEN OTHERS THEN
219: x_return_status := fnd_api.g_ret_sts_unexp_error;
220:
221: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
222: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
223: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_items');
224: fnd_message.set_token('ERRNO', sqlcode);
225: fnd_message.set_token('REASON', sqlerrm);

Line 226: FND_MSG_PUB.add;

222: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
223: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_items');
224: fnd_message.set_token('ERRNO', sqlcode);
225: fnd_message.set_token('REASON', sqlerrm);
226: FND_MSG_PUB.add;
227: END IF;
228: END search_items;
229:
230: PROCEDURE search_customer_items(

Line 267: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

263: EXCEPTION
264: WHEN OTHERS THEN
265: x_return_status := fnd_api.g_ret_sts_unexp_error;
266:
267: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
268: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
269: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customer_items');
270: fnd_message.set_token('ERRNO', sqlcode);
271: fnd_message.set_token('REASON', sqlerrm);

Line 272: FND_MSG_PUB.add;

268: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
269: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customer_items');
270: fnd_message.set_token('ERRNO', sqlcode);
271: fnd_message.set_token('REASON', sqlerrm);
272: FND_MSG_PUB.add;
273: END IF;
274: END search_customer_items;
275:
276:

Line 314: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

310: EXCEPTION
311: WHEN OTHERS THEN
312: x_return_status := fnd_api.g_ret_sts_unexp_error;
313:
314: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
315: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
316: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customer_items_all');
317: fnd_message.set_token('ERRNO', sqlcode);
318: fnd_message.set_token('REASON', sqlerrm);

Line 319: FND_MSG_PUB.add;

315: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
316: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customer_items_all');
317: fnd_message.set_token('ERRNO', sqlcode);
318: fnd_message.set_token('REASON', sqlerrm);
319: FND_MSG_PUB.add;
320: END IF;
321: END search_customer_items_all;
322:
323:

Line 361: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

357: EXCEPTION
358: WHEN OTHERS THEN
359: x_return_status := fnd_api.g_ret_sts_unexp_error;
360:
361: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
362: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
363: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_warehouses');
364: fnd_message.set_token('ERRNO', sqlcode);
365: fnd_message.set_token('REASON', sqlerrm);

Line 366: FND_MSG_PUB.add;

362: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
363: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_warehouses');
364: fnd_message.set_token('ERRNO', sqlcode);
365: fnd_message.set_token('REASON', sqlerrm);
366: FND_MSG_PUB.add;
367: END IF;
368: END search_warehouses;
369:
370: PROCEDURE Get_InventoryDetails(

Line 412: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

408: EXCEPTION
409: WHEN OTHERS THEN
410: x_return_status := fnd_api.g_ret_sts_unexp_error;
411:
412: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
413: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
414: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_InventoryDetails');
415: fnd_message.set_token('ERRNO', sqlcode);
416: fnd_message.set_token('REASON', sqlerrm);

Line 417: FND_MSG_PUB.add;

413: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
414: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_InventoryDetails');
415: fnd_message.set_token('ERRNO', sqlcode);
416: fnd_message.set_token('REASON', sqlerrm);
417: FND_MSG_PUB.add;
418: END IF;
419: END Get_InventoryDetails;
420:
421: PROCEDURE Get_CustomerInventory(

Line 461: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

457: EXCEPTION
458: WHEN OTHERS THEN
459: x_return_status := fnd_api.g_ret_sts_unexp_error;
460:
461: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
462: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
463: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_CustomerInventory');
464: fnd_message.set_token('ERRNO', sqlcode);
465: fnd_message.set_token('REASON', sqlerrm);

Line 466: FND_MSG_PUB.add;

462: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
463: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_CustomerInventory');
464: fnd_message.set_token('ERRNO', sqlcode);
465: fnd_message.set_token('REASON', sqlerrm);
466: FND_MSG_PUB.add;
467: END IF;
468: END Get_CustomerInventory;
469:
470: PROCEDURE search_customers(

Line 506: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

502: EXCEPTION
503: WHEN OTHERS THEN
504: x_return_status := fnd_api.g_ret_sts_unexp_error;
505:
506: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
507: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
508: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customers');
509: fnd_message.set_token('ERRNO', sqlcode);
510: fnd_message.set_token('REASON', sqlerrm);

Line 511: FND_MSG_PUB.add;

507: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
508: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customers');
509: fnd_message.set_token('ERRNO', sqlcode);
510: fnd_message.set_token('REASON', sqlerrm);
511: FND_MSG_PUB.add;
512: END IF;
513: END search_customers;
514:
515:

Line 552: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

548: EXCEPTION
549: WHEN OTHERS THEN
550: x_return_status := fnd_api.g_ret_sts_unexp_error;
551:
552: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
553: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
554: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customers_all');
555: fnd_message.set_token('ERRNO', sqlcode);
556: fnd_message.set_token('REASON', sqlerrm);

Line 557: FND_MSG_PUB.add;

553: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
554: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customers_all');
555: fnd_message.set_token('ERRNO', sqlcode);
556: fnd_message.set_token('REASON', sqlerrm);
557: FND_MSG_PUB.add;
558: END IF;
559: END search_customers_all;
560:
561: PROCEDURE Get_LastPrice(

Line 605: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

601: EXCEPTION
602: WHEN OTHERS THEN
603: x_return_status := fnd_api.g_ret_sts_unexp_error;
604:
605: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
606: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
607: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_LastPrice');
608: fnd_message.set_token('ERRNO', sqlcode);
609: fnd_message.set_token('REASON', sqlerrm);

Line 610: FND_MSG_PUB.add;

606: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
607: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_LastPrice');
608: fnd_message.set_token('ERRNO', sqlcode);
609: fnd_message.set_token('REASON', sqlerrm);
610: FND_MSG_PUB.add;
611: END IF;
612: END Get_LastPrice;
613:
614: PROCEDURE Get_ListPrice(

Line 650: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

646: EXCEPTION
647: WHEN OTHERS THEN
648: x_return_status := fnd_api.g_ret_sts_unexp_error;
649:
650: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
651: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
652: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_ListPrice');
653: fnd_message.set_token('ERRNO', sqlcode);
654: fnd_message.set_token('REASON', sqlerrm);

Line 655: FND_MSG_PUB.add;

651: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
652: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_ListPrice');
653: fnd_message.set_token('ERRNO', sqlcode);
654: fnd_message.set_token('REASON', sqlerrm);
655: FND_MSG_PUB.add;
656: END IF;
657: END Get_ListPrice;
658:
659: PROCEDURE Get_Vendor(

Line 682: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

678: EXCEPTION
679: WHEN OTHERS THEN
680: x_return_status := fnd_api.g_ret_sts_unexp_error;
681:
682: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
683: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
684: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor');
685: fnd_message.set_token('ERRNO', sqlcode);
686: fnd_message.set_token('REASON', sqlerrm);

Line 687: FND_MSG_PUB.add;

683: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
684: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor');
685: fnd_message.set_token('ERRNO', sqlcode);
686: fnd_message.set_token('REASON', sqlerrm);
687: FND_MSG_PUB.add;
688: END IF;
689: END Get_Vendor;
690:
691: PROCEDURE Get_Vendor_Site(

Line 722: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

718: EXCEPTION
719: WHEN OTHERS THEN
720: x_return_status := fnd_api.g_ret_sts_unexp_error;
721:
722: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
723: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
724: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Site');
725: fnd_message.set_token('ERRNO', sqlcode);
726: fnd_message.set_token('REASON', sqlerrm);

Line 727: FND_MSG_PUB.add;

723: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
724: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Site');
725: fnd_message.set_token('ERRNO', sqlcode);
726: fnd_message.set_token('REASON', sqlerrm);
727: FND_MSG_PUB.add;
728: END IF;
729: END Get_Vendor_Site;
730:
731: PROCEDURE Get_Vendor_Contact(

Line 760: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

756: EXCEPTION
757: WHEN OTHERS THEN
758: x_return_status := fnd_api.g_ret_sts_unexp_error;
759:
760: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
761: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
762: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Contact');
763: fnd_message.set_token('ERRNO', sqlcode);
764: fnd_message.set_token('REASON', sqlerrm);

Line 765: FND_MSG_PUB.add;

761: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
762: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Contact');
763: fnd_message.set_token('ERRNO', sqlcode);
764: fnd_message.set_token('REASON', sqlerrm);
765: FND_MSG_PUB.add;
766: END IF;
767: END Get_Vendor_Contact;
768:
769: PROCEDURE Get_Warehouse(

Line 799: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

795: EXCEPTION
796: WHEN OTHERS THEN
797: x_return_status := fnd_api.g_ret_sts_unexp_error;
798:
799: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
800: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
801: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Warehouse');
802: fnd_message.set_token('ERRNO', sqlcode);
803: fnd_message.set_token('REASON', sqlerrm);

Line 804: FND_MSG_PUB.add;

800: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
801: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Warehouse');
802: fnd_message.set_token('ERRNO', sqlcode);
803: fnd_message.set_token('REASON', sqlerrm);
804: FND_MSG_PUB.add;
805: END IF;
806: END Get_Warehouse;
807:
808: PROCEDURE Get_Customer(

Line 838: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

834: EXCEPTION
835: WHEN OTHERS THEN
836: x_return_status := fnd_api.g_ret_sts_unexp_error;
837:
838: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
839: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
840: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Customer');
841: fnd_message.set_token('ERRNO', sqlcode);
842: fnd_message.set_token('REASON', sqlerrm);

Line 843: FND_MSG_PUB.add;

839: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
840: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Customer');
841: fnd_message.set_token('ERRNO', sqlcode);
842: fnd_message.set_token('REASON', sqlerrm);
843: FND_MSG_PUB.add;
844: END IF;
845: END Get_Customer;
846:
847: PROCEDURE Get_Product(

Line 879: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

875: EXCEPTION
876: WHEN OTHERS THEN
877: x_return_status := fnd_api.g_ret_sts_unexp_error;
878:
879: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
880: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
881: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Product');
882: fnd_message.set_token('ERRNO', sqlcode);
883: fnd_message.set_token('REASON', sqlerrm);

Line 884: FND_MSG_PUB.add;

880: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
881: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Product');
882: fnd_message.set_token('ERRNO', sqlcode);
883: fnd_message.set_token('REASON', sqlerrm);
884: FND_MSG_PUB.add;
885: END IF;
886: END Get_Product;
887: --- for AME
888:

Line 942: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

938: EXCEPTION
939: WHEN OTHERS THEN
940: x_return_status := fnd_api.g_ret_sts_unexp_error;
941:
942: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
943: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
944: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_AllApprovers');
945: fnd_message.set_token('ERRNO', sqlcode);
946: fnd_message.set_token('REASON', sqlerrm);

Line 947: FND_MSG_PUB.add;

943: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
944: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_AllApprovers');
945: fnd_message.set_token('ERRNO', sqlcode);
946: fnd_message.set_token('REASON', sqlerrm);
947: FND_MSG_PUB.add;
948: END IF;
949: END Get_AllApprovers;
950:
951: PROCEDURE Process_User_Action (

Line 993: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

989: EXCEPTION
990: WHEN OTHERS THEN
991: x_return_status := fnd_api.g_ret_sts_unexp_error;
992:
993: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
994: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
995: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Process_User_Action');
996: fnd_message.set_token('ERRNO', sqlcode);
997: fnd_message.set_token('REASON', sqlerrm);

Line 998: FND_MSG_PUB.add;

994: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
995: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Process_User_Action');
996: fnd_message.set_token('ERRNO', sqlcode);
997: fnd_message.set_token('REASON', sqlerrm);
998: FND_MSG_PUB.add;
999: END IF;
1000: END Process_User_Action;
1001:
1002: PROCEDURE Raise_Business_Event(

Line 1046: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1042: EXCEPTION
1043: WHEN OTHERS THEN
1044: x_return_status := fnd_api.g_ret_sts_unexp_error;
1045:
1046: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1047: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1048: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Raise_Business_Event');
1049: fnd_message.set_token('ERRNO', sqlcode);
1050: fnd_message.set_token('REASON', sqlerrm);

Line 1051: FND_MSG_PUB.add;

1047: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1048: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Raise_Business_Event');
1049: fnd_message.set_token('ERRNO', sqlcode);
1050: fnd_message.set_token('REASON', sqlerrm);
1051: FND_MSG_PUB.add;
1052: END IF;
1053: END Raise_Business_Event;
1054:
1055: PROCEDURE convert_currency(

Line 1070: FND_MSG_PUB.initialize;

1066: IS
1067: BEGIN
1068: --Clearing the msg stack and Initialize the message stack.
1069: fnd_message.clear();
1070: FND_MSG_PUB.initialize;
1071: --Call Dpp_utility_pvt.convert_currency
1072: DPP_UTILITY_PVT.convert_currency(p_from_currency => p_from_currency
1073: ,p_to_currency => p_to_currency
1074: ,p_conv_type => FND_API.G_MISS_CHAR

Line 1088: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1084:
1085: WHEN OTHERS THEN
1086: x_return_status := fnd_api.g_ret_sts_unexp_error;
1087:
1088: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1089: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1090: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.convert_currency');
1091: fnd_message.set_token('ERRNO', sqlcode);
1092: fnd_message.set_token('REASON', sqlerrm);

Line 1093: FND_MSG_PUB.ADD;

1089: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1090: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.convert_currency');
1091: fnd_message.set_token('ERRNO', sqlcode);
1092: fnd_message.set_token('REASON', sqlerrm);
1093: FND_MSG_PUB.ADD;
1094: END IF;
1095:
1096: END convert_currency;
1097: