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

Line 2089: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

2085: END IF;
2086:
2087: WHEN WSH_DP_NO_ENTITY THEN
2088: FND_MESSAGE.SET_NAME('WSH', 'WSH_DP_NO_ENTITY');
2089: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2090: x_return_status := FND_API.G_RET_STS_ERROR;
2091: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2092: if x_msg_count > 1 then
2093: x_msg_data := l_msg_summary || l_msg_details;

Line 2090: x_return_status := FND_API.G_RET_STS_ERROR;

2086:
2087: WHEN WSH_DP_NO_ENTITY THEN
2088: FND_MESSAGE.SET_NAME('WSH', 'WSH_DP_NO_ENTITY');
2089: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2090: x_return_status := FND_API.G_RET_STS_ERROR;
2091: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2092: if x_msg_count > 1 then
2093: x_msg_data := l_msg_summary || l_msg_details;
2094: else

Line 2109: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

2105: END IF;
2106: --
2107: WHEN WSH_INV_LIST_TYPE THEN
2108: FND_MESSAGE.SET_NAME('WSH', 'WSH_INV_LIST_TYPE');
2109: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2110: x_return_status := FND_API.G_RET_STS_ERROR;
2111: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2112: if x_msg_count > 1 then
2113: x_msg_data := l_msg_summary || l_msg_details;

Line 2110: x_return_status := FND_API.G_RET_STS_ERROR;

2106: --
2107: WHEN WSH_INV_LIST_TYPE THEN
2108: FND_MESSAGE.SET_NAME('WSH', 'WSH_INV_LIST_TYPE');
2109: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2110: x_return_status := FND_API.G_RET_STS_ERROR;
2111: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
2112: if x_msg_count > 1 then
2113: x_msg_data := l_msg_summary || l_msg_details;
2114: else

Line 2290: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2286: WSH_DEBUG_SV.log(l_module_name,'Unable to obtain lock on the Stop Id',p_rec_attr_tab(l_index).stop_id);
2287: END IF;
2288: --
2289: WHEN others THEN
2290: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2291: end;
2292: --
2293: l_index := p_valid_index_tab.NEXT(l_index);
2294: --

Line 2306: RAISE FND_API.G_EXC_ERROR;

2302: wsh_util_core.add_message(x_return_status,l_module_name);
2303: IF l_debug_on THEN
2304: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PERFORMED');
2305: END IF;
2306: RAISE FND_API.G_EXC_ERROR;
2307: ELSIF l_num_errors > 0 THEN
2308: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PROCESSED');
2309: x_return_status := wsh_util_core.g_ret_sts_warning;
2310: wsh_util_core.add_message(x_return_status,l_module_name);

Line 2326: WHEN FND_API.G_EXC_ERROR THEN

2322: --
2323: EXCEPTION
2324: --
2325: --
2326: WHEN FND_API.G_EXC_ERROR THEN
2327: --
2328: x_return_status := wsh_util_core.g_ret_sts_error;
2329: --
2330: IF l_debug_on THEN

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

2327: --
2328: x_return_status := wsh_util_core.g_ret_sts_error;
2329: --
2330: IF l_debug_on THEN
2331: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2333: END IF;
2334: --
2335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2328: x_return_status := wsh_util_core.g_ret_sts_error;
2329: --
2330: IF l_debug_on THEN
2331: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2333: END IF;
2334: --
2335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2336: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

Line 2335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2331: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2333: END IF;
2334: --
2335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2336: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2337: --
2338: IF l_debug_on THEN
2339: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

2336: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2337: --
2338: IF l_debug_on THEN
2339: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2340: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2341: END IF;
2342: --
2343: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2344: x_return_status := wsh_util_core.g_ret_sts_warning;

Line 2425: RAISE FND_API.G_EXC_ERROR;

2421: IF l_debug_on THEN
2422: WSH_DEBUG_SV.logmsg(l_module_name,
2423: 'Stop ID and TMS_interface_flag_tab count does not match');
2424: END IF;
2425: RAISE FND_API.G_EXC_ERROR;
2426: END IF;
2427:
2428: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2429:

Line 2472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2468: IF l_debug_on THEN
2469: WSH_DEBUG_SV.log(l_module_name,
2470: 'DBI API Returned Unexpected error '||x_return_status);
2471: END IF;
2472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2473: END IF;
2474:
2475: EXIT WHEN l_loop_counter >= p_stop_id_tab.LAST;
2476: l_loop_counter := p_stop_id_tab.NEXT(l_loop_counter);

Line 2492: WHEN FND_API.G_EXC_ERROR THEN

2488: END IF;
2489: --
2490: EXCEPTION
2491: --
2492: WHEN FND_API.G_EXC_ERROR THEN
2493: ROLLBACK TO update_tms_interface;
2494: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2495: --
2496: IF l_debug_on THEN

Line 2498: 'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2494: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2495: --
2496: IF l_debug_on THEN
2497: WSH_DEBUG_SV.logmsg(l_module_name,
2498: 'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2499: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2500: END IF;
2501: --
2502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2495: --
2496: IF l_debug_on THEN
2497: WSH_DEBUG_SV.logmsg(l_module_name,
2498: 'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2499: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2500: END IF;
2501: --
2502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2503: --

Line 2502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2498: 'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2499: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2500: END IF;
2501: --
2502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2503: --
2504: ROLLBACK TO update_tms_interface;
2505: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2506: --

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

2505: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2506: --
2507: IF l_debug_on THEN
2508: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2510: END IF;
2511: --
2512: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2513: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;