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_TRIPS_ACTIONS dependencies on WSH_XC_UTIL

Line 328: l_exceptions_tab wsh_xc_util.XC_TAB_TYPE;

324: l_is_action_not_performed BOOLEAN := TRUE;
325: --Bug#: 2867209 - End
326:
327: -- Exceptions Project
328: l_exceptions_tab wsh_xc_util.XC_TAB_TYPE;
329: l_exp_logged BOOLEAN := FALSE;
330: check_exceptions EXCEPTION;
331: l_msg_count NUMBER;
332: l_msg_summary VARCHAR2(4000);

Line 410: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Check_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);

406:
407: -- Check for Exceptions against Trip and its contents, only if trip is being set to In-Transit or Closed
408: IF p_intransit_flag = 'Y' OR p_close_flag = 'Y' THEN
409: IF l_debug_on THEN
410: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Check_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
411: END IF;
412: l_exceptions_tab.delete;
413: l_exp_logged := FALSE;
414: WSH_XC_UTIL.Check_Exceptions (

Line 414: WSH_XC_UTIL.Check_Exceptions (

410: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Check_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
411: END IF;
412: l_exceptions_tab.delete;
413: l_exp_logged := FALSE;
414: WSH_XC_UTIL.Check_Exceptions (
415: p_api_version => 1.0,
416: x_return_status => l_return_status,
417: x_msg_count => l_msg_count,
418: x_msg_data => l_msg_data,

Line 574: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Close_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);

570: CLOSE c_trip_status;
571:
572: IF l_trip_status = 'CL' THEN
573: IF l_debug_on THEN
574: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Close_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
575: END IF;
576: WSH_XC_UTIL.Close_Exceptions (
577: p_api_version => 1.0,
578: x_return_status => l_return_status,

Line 576: WSH_XC_UTIL.Close_Exceptions (

572: IF l_trip_status = 'CL' THEN
573: IF l_debug_on THEN
574: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Close_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
575: END IF;
576: WSH_XC_UTIL.Close_Exceptions (
577: p_api_version => 1.0,
578: x_return_status => l_return_status,
579: x_msg_count => l_msg_count,
580: x_msg_data => l_msg_data,

Line 925: l_exceptions_tab wsh_xc_util.XC_TAB_TYPE;

921: l_return_status VARCHAR2(30);
922: l_num_warn NUMBER := 0;
923:
924: -- Exceptions Project
925: l_exceptions_tab wsh_xc_util.XC_TAB_TYPE;
926: l_exp_logged BOOLEAN := FALSE;
927: check_exceptions EXCEPTION;
928: l_msg_count NUMBER;
929: l_msg_data VARCHAR2(4000);

Line 970: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Check_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);

966:
967: -- Check for Exceptions if p_status_code = 'CL' or 'IT'
968: IF p_status_code IN ('IT','CL') THEN
969: IF l_debug_on THEN
970: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Check_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
971: END IF;
972: l_exceptions_tab.delete;
973: l_exp_logged := FALSE;
974: WSH_XC_UTIL.Check_Exceptions (

Line 974: WSH_XC_UTIL.Check_Exceptions (

970: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Check_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
971: END IF;
972: l_exceptions_tab.delete;
973: l_exp_logged := FALSE;
974: WSH_XC_UTIL.Check_Exceptions (
975: p_api_version => 1.0,
976: x_return_status => l_return_status,
977: x_msg_count => l_msg_count,
978: x_msg_data => l_msg_data,

Line 1109: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Close_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);

1105:
1106: -- Close Exceptions for the Trip and its contents
1107: IF p_status_code IN ('IT','CL') THEN
1108: IF l_debug_on THEN
1109: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Close_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
1110: END IF;
1111: WSH_XC_UTIL.Close_Exceptions (
1112: p_api_version => 1.0,
1113: x_return_status => l_return_status,

Line 1111: WSH_XC_UTIL.Close_Exceptions (

1107: IF p_status_code IN ('IT','CL') THEN
1108: IF l_debug_on THEN
1109: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Close_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
1110: END IF;
1111: WSH_XC_UTIL.Close_Exceptions (
1112: p_api_version => 1.0,
1113: x_return_status => l_return_status,
1114: x_msg_count => l_msg_count,
1115: x_msg_data => l_msg_data,

Line 1418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Close_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);

1414: --
1415: -- Close Exceptions for the Trip and its contents, if new status = 'CL' or 'IT'
1416: IF p_in_rec.new_status_code IN ('IT','CL') THEN
1417: IF l_debug_on THEN
1418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Close_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
1419: END IF;
1420: WSH_XC_UTIL.Close_Exceptions (
1421: p_api_version => 1.0,
1422: x_return_status => l_return_status,

Line 1420: WSH_XC_UTIL.Close_Exceptions (

1416: IF p_in_rec.new_status_code IN ('IT','CL') THEN
1417: IF l_debug_on THEN
1418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Close_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
1419: END IF;
1420: WSH_XC_UTIL.Close_Exceptions (
1421: p_api_version => 1.0,
1422: x_return_status => l_return_status,
1423: x_msg_count => l_msg_count,
1424: x_msg_data => l_msg_data,