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_TRIP_STOPS_ACTIONS dependencies on FND_API

Line 637: RAISE FND_API.G_EXC_ERROR;

633: l_stopsNotProcessedWarnings := l_stopsNotProcessedWarnings + 1;
634: RAISE wsh_util_core.g_exc_warning;
635: ELSE
636: l_num_errors := l_num_errors + 1;
637: RAISE FND_API.G_EXC_ERROR;
638: END IF;
639: --
640: --
641: IF l_debug_on THEN

Line 694: RAISE FND_API.G_EXC_ERROR;

690: x_num_warnings => l_num_warnings,
691: x_num_errors => l_num_errors
692: );
693: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
694: RAISE FND_API.G_EXC_ERROR;
695: END IF;
696:
697: --}
698: ELSIF (p_action = 'ARRIVE')

Line 737: RAISE FND_API.G_EXC_ERROR;

733: IF (SQL%NOTFOUND) THEN
734: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
735: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
736: l_num_errors := l_num_errors + 1;
737: RAISE FND_API.G_EXC_ERROR;
738: END IF;
739: --
740:
741: -- Workflow Project

Line 810: WHEN FND_API.G_EXC_ERROR

806: END IF;
807: --}
808: EXCEPTION
809: --{
810: WHEN FND_API.G_EXC_ERROR
811: THEN
812: --{
813: ROLLBACK to stop_chg_status_sp;
814: --

Line 907: WHEN FND_API.G_EXC_ERROR THEN

903: WSH_DEBUG_SV.pop(l_module_name);
904: END IF;
905: --}
906: EXCEPTION
907: WHEN FND_API.G_EXC_ERROR THEN
908: ROLLBACK TO stop_chg_status_begin_sp;
909: --
910: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
911: --

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

909: --
910: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
911: --
912: IF l_debug_on THEN
913: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
914: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
915: END IF;
916: --
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

910: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
911: --
912: IF l_debug_on THEN
913: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
914: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
915: END IF;
916: --
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
918:

Line 917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

913: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
914: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
915: END IF;
916: --
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
918:
919: ROLLBACK TO stop_chg_status_begin_sp;
920: --
921: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

921: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
922: --
923: IF l_debug_on THEN
924: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
925: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
926: END IF;
927: --
928: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
929: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1460: WHEN FND_API.G_EXC_ERROR THEN

1456: END IF;
1457: --}
1458: EXCEPTION
1459: --
1460: WHEN FND_API.G_EXC_ERROR THEN
1461:
1462: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1463: --
1464: IF l_debug_on THEN

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

1461:
1462: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1463: --
1464: IF l_debug_on THEN
1465: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1466: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1467: END IF;
1468: --
1469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1462: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1463: --
1464: IF l_debug_on THEN
1465: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1466: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1467: END IF;
1468: --
1469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1470:

Line 1469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1465: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1466: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1467: END IF;
1468: --
1469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1470:
1471: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1472: --
1473: IF l_debug_on THEN

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

1471: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1472: --
1473: IF l_debug_on THEN
1474: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1475: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1476: END IF;
1477: --
1478: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1479: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1703: RAISE FND_API.G_EXC_ERROR;

1699: THEN
1700: --{
1701: -- None of the candidate deliveries could be set to in-transit. Raise Error
1702: --
1703: RAISE FND_API.G_EXC_ERROR;
1704: --}
1705: END IF;
1706: --
1707: --

Line 1863: RAISE FND_API.G_EXC_ERROR;

1859: IF l_debug_on THEN
1860: wsh_debug_sv.log(l_module_name,'last_pickup_stop_closed return error');
1861: END IF;
1862: wsh_util_core.add_message(l_return_status);
1863: RAISE FND_API.G_EXC_ERROR;
1864: END IF;
1865: IF l_last_pickup_stop_closed = 'Y' AND l_eligible_for_asr = 'Y' THEN --{
1866: l_tms_interface_flag := WSH_TRIP_STOPS_PVT.C_TMS_ACTUAL_REQUEST;
1867: ELSE

Line 1897: RAISE FND_API.G_EXC_ERROR;

1893: THEN
1894: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_EXIST');
1895: FND_MESSAGE.SET_TOKEN('STOP_ID',p_in_rec.stop_id);
1896: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
1897: RAISE FND_API.G_EXC_ERROR;
1898: END IF;
1899: --
1900: --
1901: EXCEPTION

Line 1903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1899: --
1900: --
1901: EXCEPTION
1902: WHEN others THEN
1903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1904: END;--}
1905: --
1906:
1907: -- Workflow Project

Line 2083: p_init_msg_list => FND_API.G_FALSE,

2079: l_action_params.action := 'RATE';
2080: l_action_params.trip_id_list(1) := p_in_rec1.trip_id;
2081: WSH_FTE_INTEGRATION.Rate_Trip (
2082: p_api_version => 1.0,
2083: p_init_msg_list => FND_API.G_FALSE,
2084: p_action_params => l_action_params,
2085: p_commit => FND_API.G_FALSE,
2086: x_return_status => l_return_status,
2087: x_msg_count => l_msg_count,

Line 2085: p_commit => FND_API.G_FALSE,

2081: WSH_FTE_INTEGRATION.Rate_Trip (
2082: p_api_version => 1.0,
2083: p_init_msg_list => FND_API.G_FALSE,
2084: p_action_params => l_action_params,
2085: p_commit => FND_API.G_FALSE,
2086: x_return_status => l_return_status,
2087: x_msg_count => l_msg_count,
2088: x_msg_data => l_msg_data);
2089: --

Line 2095: RAISE FND_API.G_EXC_ERROR;

2091: THEN
2092: FND_MESSAGE.SET_NAME('WSH','WSH_PRICE_CNSLD_UNEXP_ERROR');
2093: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_rec1.trip_id));
2094: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
2095: RAISE FND_API.G_EXC_ERROR;
2096: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2097: -- Bug 3278059, treat warning from rate_trip as success
2098: THEN
2099: --{

Line 2140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2136: --
2137: --
2138: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2139: THEN
2140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2141: ELSIF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2142: THEN
2143: --{
2144: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

Line 2270: WHEN FND_API.G_EXC_ERROR THEN

2266: --}
2267: EXCEPTION
2268: --{
2269: --
2270: WHEN FND_API.G_EXC_ERROR THEN
2271: --ROLLBACK TO close_stop_begin_sp;
2272: --
2273: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2274: --

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

2272: --
2273: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2274: --
2275: IF l_debug_on THEN
2276: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2277: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2278: END IF;
2279: --
2280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2273: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2274: --
2275: IF l_debug_on THEN
2276: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2277: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2278: END IF;
2279: --
2280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2281: --ROLLBACK TO close_stop_begin_sp;

Line 2280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2276: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2277: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2278: END IF;
2279: --
2280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2281: --ROLLBACK TO close_stop_begin_sp;
2282: --
2283: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2284: --

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

2283: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2284: --
2285: IF l_debug_on THEN
2286: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2287: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2288: END IF;
2289: --
2290: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2291: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2499: RAISE FND_API.G_EXC_ERROR;

2495: THEN
2496: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_EXIST');
2497: FND_MESSAGE.SET_TOKEN('STOP_ID',p_in_rec.stop_id);
2498: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
2499: RAISE FND_API.G_EXC_ERROR;
2500: END IF;
2501: --
2502:
2503: -- Workflow Project

Line 2900: WHEN FND_API.G_EXC_ERROR THEN

2896: --}
2897: EXCEPTION
2898: --{
2899: --
2900: WHEN FND_API.G_EXC_ERROR THEN
2901:
2902: --ROLLBACK TO open_stop_begin_sp;
2903: --
2904: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

2903: --
2904: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2905: --
2906: IF l_debug_on THEN
2907: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2908: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2909: END IF;
2910: --
2911: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2904: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2905: --
2906: IF l_debug_on THEN
2907: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2908: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2909: END IF;
2910: --
2911: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2912:

Line 2911: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2907: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2908: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2909: END IF;
2910: --
2911: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2912:
2913: --ROLLBACK TO open_stop_begin_sp;
2914: --
2915: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

2915: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2916: --
2917: IF l_debug_on THEN
2918: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2919: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2920: END IF;
2921: --
2922: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2923: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 3271: RAISE FND_API.G_EXC_ERROR;

3267: WSH_DEBUG_SV.logmsg(l_module_name,
3268: 'Please specify p_trip_id and p_stop_id');
3269: wsh_debug_sv.pop(l_module_name, 'ERROR EXCEPTION');
3270: END IF;
3271: RAISE FND_API.G_EXC_ERROR;
3272: END IF;
3273:
3274: --OTM R12 Org-Specific start.
3275: OPEN pickup_stop_csr;

Line 3325: WHEN FND_API.G_EXC_ERROR THEN

3321: END IF;
3322:
3323: EXCEPTION
3324: --OTM R12 Org-Specific start.
3325: WHEN FND_API.G_EXC_ERROR THEN
3326: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3327: IF pickup_stop_csr%ISOPEN THEN
3328: CLOSE pickup_stop_csr;
3329: END IF;

Line 3338: wsh_debug_sv.pop(l_module_name, 'FND_API.G_EXC_ERROR');

3334: IF l_debug_on THEN
3335: WSH_DEBUG_SV.log(l_module_name,
3336: 'Oracle error '||SQLERRM,
3337: WSH_DEBUG_SV.C_EXCEP_LEVEL);
3338: wsh_debug_sv.pop(l_module_name, 'FND_API.G_EXC_ERROR');
3339: END IF;
3340:
3341: --OTM R12 End
3342: WHEN OTHERS THEN