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 312: x_return_status := fnd_api.g_ret_sts_unexp_error;

308: END IF;
309:
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');

Line 359: x_return_status := fnd_api.g_ret_sts_unexp_error;

355: END IF;
356:
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');

Line 410: x_return_status := fnd_api.g_ret_sts_unexp_error;

406: END LOOP;
407:
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');

Line 459: x_return_status := fnd_api.g_ret_sts_unexp_error;

455: END LOOP;
456:
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');

Line 504: x_return_status := fnd_api.g_ret_sts_unexp_error;

500: END LOOP;
501: END IF;
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');

Line 550: x_return_status := fnd_api.g_ret_sts_unexp_error;

546: END LOOP;
547: END IF;
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');

Line 603: x_return_status := fnd_api.g_ret_sts_unexp_error;

599: END LOOP;
600:
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');

Line 648: x_return_status := fnd_api.g_ret_sts_unexp_error;

644: END LOOP;
645:
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');

Line 680: x_return_status := fnd_api.g_ret_sts_unexp_error;

676: p_vendor_rec.vendor_name := l_vendor_rec.vendor_name;
677:
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');

Line 720: x_return_status := fnd_api.g_ret_sts_unexp_error;

716: p_vendor_site_rec.country := l_vendor_site_rec.country;
717:
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');

Line 758: x_return_status := fnd_api.g_ret_sts_unexp_error;

754: p_vendor_contact_rec.contact_fax := l_vendor_contact_rec.contact_fax;
755:
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');

Line 797: x_return_status := fnd_api.g_ret_sts_unexp_error;

793: END LOOP;
794:
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');

Line 836: x_return_status := fnd_api.g_ret_sts_unexp_error;

832: END LOOP;
833:
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');

Line 877: x_return_status := fnd_api.g_ret_sts_unexp_error;

873: END LOOP;
874:
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');

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

887: --- for AME
888:
889: PROCEDURE Get_AllApprovers(
890: p_api_version IN NUMBER
891: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
892: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
893:
894: ,x_return_status OUT NOCOPY VARCHAR2
895: ,x_msg_data OUT NOCOPY VARCHAR2

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

888:
889: PROCEDURE Get_AllApprovers(
890: p_api_version IN NUMBER
891: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
892: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
893:
894: ,x_return_status OUT NOCOPY VARCHAR2
895: ,x_msg_data OUT NOCOPY VARCHAR2
896: ,x_msg_count OUT NOCOPY NUMBER

Line 940: x_return_status := fnd_api.g_ret_sts_unexp_error;

936: END IF;
937:
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');

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

949: END Get_AllApprovers;
950:
951: PROCEDURE Process_User_Action (
952: p_api_version IN NUMBER
953: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
954: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
955: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
956:
957: ,x_return_status OUT NOCOPY VARCHAR2

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

950:
951: PROCEDURE Process_User_Action (
952: p_api_version IN NUMBER
953: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
954: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
955: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
956:
957: ,x_return_status OUT NOCOPY VARCHAR2
958: ,x_msg_data OUT NOCOPY VARCHAR2

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

951: PROCEDURE Process_User_Action (
952: p_api_version IN NUMBER
953: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
954: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
955: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
956:
957: ,x_return_status OUT NOCOPY VARCHAR2
958: ,x_msg_data OUT NOCOPY VARCHAR2
959: ,x_msg_count OUT NOCOPY NUMBER

Line 991: x_return_status := fnd_api.g_ret_sts_unexp_error;

987: );
988:
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');

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

1000: END Process_User_Action;
1001:
1002: PROCEDURE Raise_Business_Event(
1003: p_api_version IN NUMBER
1004: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1005: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1006: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1007:
1008: ,x_return_status OUT NOCOPY VARCHAR2

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

1001:
1002: PROCEDURE Raise_Business_Event(
1003: p_api_version IN NUMBER
1004: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1005: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1006: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1007:
1008: ,x_return_status OUT NOCOPY VARCHAR2
1009: ,x_msg_count OUT NOCOPY NUMBER

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

1002: PROCEDURE Raise_Business_Event(
1003: p_api_version IN NUMBER
1004: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1005: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1006: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1007:
1008: ,x_return_status OUT NOCOPY VARCHAR2
1009: ,x_msg_count OUT NOCOPY NUMBER
1010: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1044: x_return_status := fnd_api.g_ret_sts_unexp_error;

1040: ,p_txn_line_id => l_txn_line_id
1041: );
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');

Line 1058: ,p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

1054:
1055: PROCEDURE convert_currency(
1056: p_from_currency IN VARCHAR2
1057: ,p_to_currency IN VARCHAR2
1058: ,p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1059: ,p_conv_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM
1060: ,p_conv_date IN DATE DEFAULT SYSDATE
1061: ,p_from_amount IN NUMBER
1062: ,x_return_status OUT NOCOPY VARCHAR2

Line 1059: ,p_conv_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM

1055: PROCEDURE convert_currency(
1056: p_from_currency IN VARCHAR2
1057: ,p_to_currency IN VARCHAR2
1058: ,p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1059: ,p_conv_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM
1060: ,p_conv_date IN DATE DEFAULT SYSDATE
1061: ,p_from_amount IN NUMBER
1062: ,x_return_status OUT NOCOPY VARCHAR2
1063: ,x_to_amount OUT NOCOPY NUMBER

Line 1074: ,p_conv_type => FND_API.G_MISS_CHAR

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
1075: ,p_conv_rate => FND_API.G_MISS_NUM
1076: ,p_conv_date => sysdate
1077: ,p_from_amount => p_from_amount
1078: ,x_return_status => x_return_status

Line 1075: ,p_conv_rate => FND_API.G_MISS_NUM

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
1075: ,p_conv_rate => FND_API.G_MISS_NUM
1076: ,p_conv_date => sysdate
1077: ,p_from_amount => p_from_amount
1078: ,x_return_status => x_return_status
1079: ,x_to_amount => x_to_amount

Line 1082: WHEN FND_API.G_EXC_ERROR THEN

1078: ,x_return_status => x_return_status
1079: ,x_to_amount => x_to_amount
1080: ,x_rate => x_rate);
1081: EXCEPTION
1082: WHEN FND_API.G_EXC_ERROR THEN
1083: x_return_status := FND_API.G_RET_STS_ERROR;
1084:
1085: WHEN OTHERS THEN
1086: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1083: x_return_status := FND_API.G_RET_STS_ERROR;

1079: ,x_to_amount => x_to_amount
1080: ,x_rate => x_rate);
1081: EXCEPTION
1082: WHEN FND_API.G_EXC_ERROR THEN
1083: x_return_status := FND_API.G_RET_STS_ERROR;
1084:
1085: WHEN OTHERS THEN
1086: x_return_status := fnd_api.g_ret_sts_unexp_error;
1087:

Line 1086: x_return_status := fnd_api.g_ret_sts_unexp_error;

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