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.WSH_INBOUND_UTIL_PKG dependencies on FND_API

Line 498: WHEN FND_API.G_EXC_ERROR THEN

494: END IF;
495: --
496: EXCEPTION
497: --{
498: WHEN FND_API.G_EXC_ERROR THEN
499: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
500: --
501: -- Debug Statements
502: --

Line 504: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

500: --
501: -- Debug Statements
502: --
503: IF l_debug_on THEN
504: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
505: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
506: END IF;
507: --
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 505: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

501: -- Debug Statements
502: --
503: IF l_debug_on THEN
504: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
505: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
506: END IF;
507: --
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

504: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
505: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
506: END IF;
507: --
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
510: --
511: -- Debug Statements
512: --

Line 514: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

510: --
511: -- Debug Statements
512: --
513: IF l_debug_on THEN
514: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
515: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
516: END IF;
517: --
518: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 515: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

511: -- Debug Statements
512: --
513: IF l_debug_on THEN
514: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
515: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
516: END IF;
517: --
518: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
519: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 692: WHEN FND_API.G_EXC_ERROR THEN

688: END IF;
689: --
690: EXCEPTION
691: --{
692: WHEN FND_API.G_EXC_ERROR THEN
693: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
694: --
695: -- Debug Statements
696: --

Line 698: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

694: --
695: -- Debug Statements
696: --
697: IF l_debug_on THEN
698: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
699: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
700: END IF;
701: --
702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 699: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

695: -- Debug Statements
696: --
697: IF l_debug_on THEN
698: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
699: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
700: END IF;
701: --
702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
703: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

698: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
699: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
700: END IF;
701: --
702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
703: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
704: --
705: -- Debug Statements
706: --

Line 708: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

704: --
705: -- Debug Statements
706: --
707: IF l_debug_on THEN
708: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
709: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
710: END IF;
711: --
712: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 709: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

705: -- Debug Statements
706: --
707: IF l_debug_on THEN
708: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
709: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
710: END IF;
711: --
712: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
713: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 854: RAISE FND_API.G_EXC_ERROR;

850: --{
851: IF l_debug_on THEN
852: WSH_DEBUG_SV.logmsg(l_module_name,'PO Release less than 11.5.10');
853: END IF;
854: RAISE FND_API.G_EXC_ERROR;
855: --}
856: END IF;
857: --}
858: END IF;

Line 922: WHEN FND_API.G_EXC_ERROR THEN

918: END IF;
919: --
920: EXCEPTION
921: --{
922: WHEN FND_API.G_EXC_ERROR THEN
923: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
924: --
925: -- Debug Statements
926: --

Line 928: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

924: --
925: -- Debug Statements
926: --
927: IF l_debug_on THEN
928: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
929: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
930: END IF;
931: --
932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 929: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

925: -- Debug Statements
926: --
927: IF l_debug_on THEN
928: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
929: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
930: END IF;
931: --
932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
933: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

928: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
929: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
930: END IF;
931: --
932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
933: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
934: --
935: -- Debug Statements
936: --

Line 938: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

934: --
935: -- Debug Statements
936: --
937: IF l_debug_on THEN
938: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
939: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
940: END IF;
941: --
942: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 939: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

935: -- Debug Statements
936: --
937: IF l_debug_on THEN
938: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
939: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
940: END IF;
941: --
942: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
943: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1189: WHEN FND_API.G_EXC_ERROR THEN

1185: WSH_DEBUG_SV.pop(l_module_name);
1186: END IF;
1187: --
1188: EXCEPTION
1189: WHEN FND_API.G_EXC_ERROR THEN
1190: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1191: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1192:
1193: --

Line 1197: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1193: --
1194: -- Debug Statements
1195: --
1196: IF l_debug_on THEN
1197: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1198: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1199: END IF;
1200: --
1201: WHEN INVALID_DROP_SHIP_INFO THEN

Line 1198: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1194: -- Debug Statements
1195: --
1196: IF l_debug_on THEN
1197: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1198: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1199: END IF;
1200: --
1201: WHEN INVALID_DROP_SHIP_INFO THEN
1202: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1361: RAISE FND_API.G_EXC_ERROR;

1357: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
1358: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'p_delivery_id');
1359: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
1360: --
1361: RAISE FND_API.G_EXC_ERROR;
1362: --}
1363: END IF;
1364: --
1365: IF p_delivery_detail_id_tbl.count = 0

Line 1375: RAISE FND_API.G_EXC_ERROR;

1371: FND_MESSAGE.SET_NAME('WSH', 'WSH_EMPTY_TABLE_ERROR');
1372: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'p_delivery_detail_id_tbl');
1373: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
1374: --
1375: RAISE FND_API.G_EXC_ERROR;
1376: --}
1377: END IF;
1378: --
1379:

Line 1392: RAISE FND_API.G_EXC_ERROR;

1388: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_NOT_EXIST');
1389: FND_MESSAGE.SET_TOKEN('DELIVERY_ID', p_delivery_id);
1390: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
1391: --
1392: RAISE FND_API.G_EXC_ERROR;
1393: --}
1394: END IF;
1395: --
1396: --

Line 1407: RAISE FND_API.G_EXC_ERROR;

1403: FND_MESSAGE.SET_NAME('WSH','WSH_NOT_IB_DLVY_ERROR');
1404: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', l_dlvy_rec.name);
1405: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
1406: --
1407: RAISE FND_API.G_EXC_ERROR;
1408: --}
1409: END IF;
1410: --
1411: --

Line 1415: l_delivery_rec.routing_response_id := FND_API.G_MISS_NUM ;

1411: --
1412: --
1413: IF x_delivery_id IS NULL THEN
1414: l_delivery_rec.wv_frozen_flag := 'N';
1415: l_delivery_rec.routing_response_id := FND_API.G_MISS_NUM ;
1416:
1417: IF l_debug_on THEN
1418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.clone',WSH_DEBUG_SV.C_PROC_LEVEL);
1419: END IF;

Line 1636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1632: x_return_status => l_return_status
1633: );
1634: --
1635: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1637: END IF;
1638: --
1639: wsh_util_core.api_post_call(
1640: p_return_status => l_return_status,

Line 1756: WHEN FND_API.G_EXC_ERROR THEN

1752: --}
1753: EXCEPTION
1754: --{
1755: --
1756: WHEN FND_API.G_EXC_ERROR THEN
1757:
1758: ROLLBACK TO split_inbound_delivery_sp;
1759: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1760: --

Line 1762: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1758: ROLLBACK TO split_inbound_delivery_sp;
1759: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1760: --
1761: IF l_debug_on THEN
1762: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1763: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1764: END IF;
1765: --
1766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1763: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1759: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1760: --
1761: IF l_debug_on THEN
1762: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1763: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1764: END IF;
1765: --
1766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1767:

Line 1766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1762: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1763: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1764: END IF;
1765: --
1766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1767:
1768: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1769: ROLLBACK TO split_inbound_delivery_sp;
1770: --

Line 1773: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1769: ROLLBACK TO split_inbound_delivery_sp;
1770: --
1771: IF l_debug_on THEN
1772: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1773: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1774: END IF;
1775: --
1776: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1777: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1916: --
1917: --
1918: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1919: THEN
1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1921: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1922: THEN
1923: RAISE FND_API.G_EXC_ERROR;
1924: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

Line 1923: RAISE FND_API.G_EXC_ERROR;

1919: THEN
1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1921: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1922: THEN
1923: RAISE FND_API.G_EXC_ERROR;
1924: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
1925: THEN
1926: --{
1927: IF l_debug_on THEN

Line 2047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2043: );
2044: --
2045: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2046: THEN
2047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2048: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2049: THEN
2050: RAISE FND_API.G_EXC_ERROR;
2051: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

Line 2050: RAISE FND_API.G_EXC_ERROR;

2046: THEN
2047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2048: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2049: THEN
2050: RAISE FND_API.G_EXC_ERROR;
2051: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
2052: THEN
2053: --{
2054: l_action_params.trip_id_list(l_action_params.trip_id_list.count + 1) := trips_rec.trip_id;

Line 2109: p_init_msg_list => FND_API.G_FALSE,

2105: --
2106: --
2107: FTE_TRIP_RATING_GRP.Rate_Trip (
2108: p_api_version => 1.0,
2109: p_init_msg_list => FND_API.G_FALSE,
2110: p_action_params => l_action_params,
2111: p_commit => FND_API.G_FALSE,
2112: p_init_prc_log => 'Y',
2113: x_return_status => l_return_status,

Line 2111: p_commit => FND_API.G_FALSE,

2107: FTE_TRIP_RATING_GRP.Rate_Trip (
2108: p_api_version => 1.0,
2109: p_init_msg_list => FND_API.G_FALSE,
2110: p_action_params => l_action_params,
2111: p_commit => FND_API.G_FALSE,
2112: p_init_prc_log => 'Y',
2113: x_return_status => l_return_status,
2114: x_msg_count => l_msg_count,
2115: x_msg_data => l_msg_data);

Line 2166: WHEN FND_API.G_EXC_ERROR THEN

2162: --}
2163: EXCEPTION
2164: --{
2165: --
2166: WHEN FND_API.G_EXC_ERROR THEN
2167:
2168: --ROLLBACK TO open_stop_begin_sp;
2169: --
2170: WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE := null; -- IB-Phase-2

Line 2174: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2170: WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE := null; -- IB-Phase-2
2171: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2172: --
2173: IF l_debug_on THEN
2174: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2175: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2176: END IF;
2177: --
2178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2175: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

2171: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2172: --
2173: IF l_debug_on THEN
2174: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2175: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2176: END IF;
2177: --
2178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2179:

Line 2178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2174: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2175: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2176: END IF;
2177: --
2178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2179:
2180: --ROLLBACK TO open_stop_begin_sp;
2181: --
2182: WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE := null; -- IB-Phase-2

Line 2187: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2183: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2184: --
2185: IF l_debug_on THEN
2186: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2187: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2188: END IF;
2189: --
2190: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2191: WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE := null; -- IB-Phase-2

Line 2411: WHEN FND_API.G_EXC_ERROR THEN

2407: --}
2408: EXCEPTION
2409: --{
2410: --
2411: WHEN FND_API.G_EXC_ERROR THEN
2412:
2413: --ROLLBACK TO open_stop_begin_sp;
2414: --
2415: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2418: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2414: --
2415: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2416: --
2417: IF l_debug_on THEN
2418: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2419: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2420: END IF;
2421: --
2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2419: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

2415: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2416: --
2417: IF l_debug_on THEN
2418: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2419: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2420: END IF;
2421: --
2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2423:

Line 2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2418: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2419: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2420: END IF;
2421: --
2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2423:
2424: --ROLLBACK TO open_stop_begin_sp;
2425: --
2426: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 2430: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2426: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2427: --
2428: IF l_debug_on THEN
2429: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2430: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2431: END IF;
2432: --
2433: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2434: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2672: RAISE FND_API.G_EXC_ERROR;

2668: --{
2669: FND_MESSAGE.SET_NAME('WSH', l_message_name);
2670: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',first_leg_rec.delivery_name);
2671: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
2672: RAISE FND_API.G_EXC_ERROR;
2673: --}
2674: END IF;
2675: --}
2676: ELSIF p_transaction_code = 'RECEIPT'

Line 2707: RAISE FND_API.G_EXC_ERROR;

2703: --{
2704: FND_MESSAGE.SET_NAME('WSH', l_message_name);
2705: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',first_leg_rec.delivery_name);
2706: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
2707: RAISE FND_API.G_EXC_ERROR;
2708: --}
2709: END IF;
2710: --}
2711: END IF;

Line 3091: WHEN FND_API.G_EXC_ERROR THEN

3087: --}
3088: EXCEPTION
3089: --{
3090: --
3091: WHEN FND_API.G_EXC_ERROR THEN
3092:
3093: --ROLLBACK TO open_stop_begin_sp;
3094: --
3095: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3098: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3094: --
3095: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3096: --
3097: IF l_debug_on THEN
3098: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3099: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3100: END IF;
3101: --
3102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3099: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

3095: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3096: --
3097: IF l_debug_on THEN
3098: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3099: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3100: END IF;
3101: --
3102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3103:

Line 3102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3098: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3099: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3100: END IF;
3101: --
3102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3103:
3104: --ROLLBACK TO open_stop_begin_sp;
3105: --
3106: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 3110: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3106: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3107: --
3108: IF l_debug_on THEN
3109: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3110: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3111: END IF;
3112: --
3113: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3114: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 3185: l_is_org_type_opm VARCHAR2(1) := FND_API.G_FALSE;

3181: WHERE inventory_item_id = v_inventory_item_id
3182: AND organization_id = v_organization_id;
3183:
3184: l_return_status VARCHAR2(1);
3185: l_is_org_type_opm VARCHAR2(1) := FND_API.G_FALSE;
3186: l_debug_on BOOLEAN;
3187: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CONVERT_QUANTITY';
3188:
3189: BEGIN