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_API

Line 20: WHEN FND_API.G_EXC_ERROR THEN

16: ,x_msg_data => x_msg_data
17: ,x_return_status => x_return_status);
18:
19: EXCEPTION
20: WHEN FND_API.G_EXC_ERROR THEN
21: x_return_status := FND_API.G_RET_STS_ERROR;
22:
23: WHEN OTHERS THEN
24: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 21: x_return_status := FND_API.G_RET_STS_ERROR;

17: ,x_return_status => x_return_status);
18:
19: EXCEPTION
20: WHEN FND_API.G_EXC_ERROR THEN
21: x_return_status := FND_API.G_RET_STS_ERROR;
22:
23: WHEN OTHERS THEN
24: x_return_status := fnd_api.g_ret_sts_unexp_error;
25:

Line 24: x_return_status := fnd_api.g_ret_sts_unexp_error;

20: WHEN FND_API.G_EXC_ERROR THEN
21: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 70: x_return_status := fnd_api.g_ret_sts_unexp_error;

66: END IF;
67:
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');

Line 123: x_return_status := fnd_api.g_ret_sts_unexp_error;

119: END IF;
120:
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');

Line 172: x_return_status := fnd_api.g_ret_sts_unexp_error;

168: END IF;
169:
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');

Line 219: x_return_status := fnd_api.g_ret_sts_unexp_error;

215: END IF;
216:
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');

Line 265: x_return_status := fnd_api.g_ret_sts_unexp_error;

261: END IF;
262:
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');

Line 311: x_return_status := fnd_api.g_ret_sts_unexp_error;

307: END IF;
308:
309: EXCEPTION
310: WHEN OTHERS THEN
311: x_return_status := fnd_api.g_ret_sts_unexp_error;
312:
313: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
314: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
315: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_warehouses');

Line 362: x_return_status := fnd_api.g_ret_sts_unexp_error;

358: END LOOP;
359:
360: EXCEPTION
361: WHEN OTHERS THEN
362: x_return_status := fnd_api.g_ret_sts_unexp_error;
363:
364: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
365: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
366: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_InventoryDetails');

Line 411: x_return_status := fnd_api.g_ret_sts_unexp_error;

407: END LOOP;
408:
409: EXCEPTION
410: WHEN OTHERS THEN
411: x_return_status := fnd_api.g_ret_sts_unexp_error;
412:
413: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
414: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
415: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_CustomerInventory');

Line 456: x_return_status := fnd_api.g_ret_sts_unexp_error;

452: END LOOP;
453: END IF;
454: EXCEPTION
455: WHEN OTHERS THEN
456: x_return_status := fnd_api.g_ret_sts_unexp_error;
457:
458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
459: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
460: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customers');

Line 509: x_return_status := fnd_api.g_ret_sts_unexp_error;

505: END LOOP;
506:
507: EXCEPTION
508: WHEN OTHERS THEN
509: x_return_status := fnd_api.g_ret_sts_unexp_error;
510:
511: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
512: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
513: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_LastPrice');

Line 554: x_return_status := fnd_api.g_ret_sts_unexp_error;

550: END LOOP;
551:
552: EXCEPTION
553: WHEN OTHERS THEN
554: x_return_status := fnd_api.g_ret_sts_unexp_error;
555:
556: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
557: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
558: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_ListPrice');

Line 586: x_return_status := fnd_api.g_ret_sts_unexp_error;

582: p_vendor_rec.vendor_name := l_vendor_rec.vendor_name;
583:
584: EXCEPTION
585: WHEN OTHERS THEN
586: x_return_status := fnd_api.g_ret_sts_unexp_error;
587:
588: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
589: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
590: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor');

Line 626: x_return_status := fnd_api.g_ret_sts_unexp_error;

622: p_vendor_site_rec.country := l_vendor_site_rec.country;
623:
624: EXCEPTION
625: WHEN OTHERS THEN
626: x_return_status := fnd_api.g_ret_sts_unexp_error;
627:
628: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
629: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
630: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Site');

Line 664: x_return_status := fnd_api.g_ret_sts_unexp_error;

660: p_vendor_contact_rec.contact_fax := l_vendor_contact_rec.contact_fax;
661:
662: EXCEPTION
663: WHEN OTHERS THEN
664: x_return_status := fnd_api.g_ret_sts_unexp_error;
665:
666: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
667: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
668: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Contact');

Line 703: x_return_status := fnd_api.g_ret_sts_unexp_error;

699: END LOOP;
700:
701: EXCEPTION
702: WHEN OTHERS THEN
703: x_return_status := fnd_api.g_ret_sts_unexp_error;
704:
705: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
706: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
707: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Warehouse');

Line 742: x_return_status := fnd_api.g_ret_sts_unexp_error;

738: END LOOP;
739:
740: EXCEPTION
741: WHEN OTHERS THEN
742: x_return_status := fnd_api.g_ret_sts_unexp_error;
743:
744: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
745: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
746: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Customer');

Line 783: x_return_status := fnd_api.g_ret_sts_unexp_error;

779: END LOOP;
780:
781: EXCEPTION
782: WHEN OTHERS THEN
783: x_return_status := fnd_api.g_ret_sts_unexp_error;
784:
785: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
786: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
787: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Product');

Line 797: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

793: --- for AME
794:
795: PROCEDURE Get_AllApprovers(
796: p_api_version IN NUMBER
797: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
798: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
799:
800: ,x_return_status OUT NOCOPY VARCHAR2
801: ,x_msg_data OUT NOCOPY VARCHAR2

Line 798: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

794:
795: PROCEDURE Get_AllApprovers(
796: p_api_version IN NUMBER
797: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
798: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
799:
800: ,x_return_status OUT NOCOPY VARCHAR2
801: ,x_msg_data OUT NOCOPY VARCHAR2
802: ,x_msg_count OUT NOCOPY NUMBER

Line 846: x_return_status := fnd_api.g_ret_sts_unexp_error;

842: END IF;
843:
844: EXCEPTION
845: WHEN OTHERS THEN
846: x_return_status := fnd_api.g_ret_sts_unexp_error;
847:
848: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
849: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
850: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_AllApprovers');

Line 859: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

855: END Get_AllApprovers;
856:
857: PROCEDURE Process_User_Action (
858: p_api_version IN NUMBER
859: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
860: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
861: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
862:
863: ,x_return_status OUT NOCOPY VARCHAR2

Line 860: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

856:
857: PROCEDURE Process_User_Action (
858: p_api_version IN NUMBER
859: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
860: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
861: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
862:
863: ,x_return_status OUT NOCOPY VARCHAR2
864: ,x_msg_data OUT NOCOPY VARCHAR2

Line 861: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

857: PROCEDURE Process_User_Action (
858: p_api_version IN NUMBER
859: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
860: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
861: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
862:
863: ,x_return_status OUT NOCOPY VARCHAR2
864: ,x_msg_data OUT NOCOPY VARCHAR2
865: ,x_msg_count OUT NOCOPY NUMBER

Line 897: x_return_status := fnd_api.g_ret_sts_unexp_error;

893: );
894:
895: EXCEPTION
896: WHEN OTHERS THEN
897: x_return_status := fnd_api.g_ret_sts_unexp_error;
898:
899: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
900: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
901: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Process_User_Action');

Line 910: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

906: END Process_User_Action;
907:
908: PROCEDURE Raise_Business_Event(
909: p_api_version IN NUMBER
910: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
911: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
912: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
913:
914: ,x_return_status OUT NOCOPY VARCHAR2

Line 911: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

907:
908: PROCEDURE Raise_Business_Event(
909: p_api_version IN NUMBER
910: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
911: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
912: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
913:
914: ,x_return_status OUT NOCOPY VARCHAR2
915: ,x_msg_count OUT NOCOPY NUMBER

Line 912: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

908: PROCEDURE Raise_Business_Event(
909: p_api_version IN NUMBER
910: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
911: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
912: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
913:
914: ,x_return_status OUT NOCOPY VARCHAR2
915: ,x_msg_count OUT NOCOPY NUMBER
916: ,x_msg_data OUT NOCOPY VARCHAR2

Line 950: x_return_status := fnd_api.g_ret_sts_unexp_error;

946: ,p_txn_line_id => l_txn_line_id
947: );
948: EXCEPTION
949: WHEN OTHERS THEN
950: x_return_status := fnd_api.g_ret_sts_unexp_error;
951:
952: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
953: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
954: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Raise_Business_Event');

Line 964: ,p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

960:
961: PROCEDURE convert_currency(
962: p_from_currency IN VARCHAR2
963: ,p_to_currency IN VARCHAR2
964: ,p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
965: ,p_conv_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM
966: ,p_conv_date IN DATE DEFAULT SYSDATE
967: ,p_from_amount IN NUMBER
968: ,x_return_status OUT NOCOPY VARCHAR2

Line 965: ,p_conv_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM

961: PROCEDURE convert_currency(
962: p_from_currency IN VARCHAR2
963: ,p_to_currency IN VARCHAR2
964: ,p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
965: ,p_conv_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM
966: ,p_conv_date IN DATE DEFAULT SYSDATE
967: ,p_from_amount IN NUMBER
968: ,x_return_status OUT NOCOPY VARCHAR2
969: ,x_to_amount OUT NOCOPY NUMBER

Line 980: ,p_conv_type => FND_API.G_MISS_CHAR

976: FND_MSG_PUB.initialize;
977: --Call Dpp_utility_pvt.convert_currency
978: DPP_UTILITY_PVT.convert_currency(p_from_currency => p_from_currency
979: ,p_to_currency => p_to_currency
980: ,p_conv_type => FND_API.G_MISS_CHAR
981: ,p_conv_rate => FND_API.G_MISS_NUM
982: ,p_conv_date => sysdate
983: ,p_from_amount => p_from_amount
984: ,x_return_status => x_return_status

Line 981: ,p_conv_rate => FND_API.G_MISS_NUM

977: --Call Dpp_utility_pvt.convert_currency
978: DPP_UTILITY_PVT.convert_currency(p_from_currency => p_from_currency
979: ,p_to_currency => p_to_currency
980: ,p_conv_type => FND_API.G_MISS_CHAR
981: ,p_conv_rate => FND_API.G_MISS_NUM
982: ,p_conv_date => sysdate
983: ,p_from_amount => p_from_amount
984: ,x_return_status => x_return_status
985: ,x_to_amount => x_to_amount

Line 988: WHEN FND_API.G_EXC_ERROR THEN

984: ,x_return_status => x_return_status
985: ,x_to_amount => x_to_amount
986: ,x_rate => x_rate);
987: EXCEPTION
988: WHEN FND_API.G_EXC_ERROR THEN
989: x_return_status := FND_API.G_RET_STS_ERROR;
990:
991: WHEN OTHERS THEN
992: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 989: x_return_status := FND_API.G_RET_STS_ERROR;

985: ,x_to_amount => x_to_amount
986: ,x_rate => x_rate);
987: EXCEPTION
988: WHEN FND_API.G_EXC_ERROR THEN
989: x_return_status := FND_API.G_RET_STS_ERROR;
990:
991: WHEN OTHERS THEN
992: x_return_status := fnd_api.g_ret_sts_unexp_error;
993:

Line 992: x_return_status := fnd_api.g_ret_sts_unexp_error;

988: WHEN FND_API.G_EXC_ERROR THEN
989: x_return_status := FND_API.G_RET_STS_ERROR;
990:
991: WHEN OTHERS THEN
992: x_return_status := fnd_api.g_ret_sts_unexp_error;
993:
994: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
995: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
996: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.convert_currency');