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 WSH_TRIPS

Line 969: from wsh_trip_stops st, wsh_trips tr

965:
966: CURSOR get_status(l_stop_id NUMBER) IS
967: select st.status_code, tr.status_code ,
968: NVL(st.shipments_type_flag,'O') -- J-IB-NPARIKH
969: from wsh_trip_stops st, wsh_trips tr
970: where st.stop_id = l_stop_id
971: and st.trip_id = tr.trip_id;
972:
973: others EXCEPTION;

Line 1219: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.TRIP_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);

1215: --
1216: -- Debug Statements
1217: --
1218: IF l_debug_on THEN
1219: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.TRIP_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
1220: END IF;
1221: --
1222: wsh_trips_actions.trip_weight_volume(
1223: p_trip_rows => dummy_trip_ids,

Line 1222: wsh_trips_actions.trip_weight_volume(

1218: IF l_debug_on THEN
1219: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.TRIP_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
1220: END IF;
1221: --
1222: wsh_trips_actions.trip_weight_volume(
1223: p_trip_rows => dummy_trip_ids,
1224: p_override_flag => l_override_flag,
1225: p_calc_wv_if_frozen => p_calc_wv_if_frozen,
1226: p_start_departure_date => NULL,

Line 2058: wsh_debug_sv.log(l_module_name, 'WSH_TRIPS_ACTIONS.g_rate_trip_id',WSH_TRIPS_ACTIONS.g_rate_trip_id);

2054: -- Bug fix 2489164
2055: -- Call Shipment_Price_Consolidate API only for NON carrier manifest enabled cases
2056: IF l_debug_on THEN
2057: wsh_debug_sv.log(l_module_name, 'l_cms_flag', l_cms_flag);
2058: wsh_debug_sv.log(l_module_name, 'WSH_TRIPS_ACTIONS.g_rate_trip_id',WSH_TRIPS_ACTIONS.g_rate_trip_id);
2059: wsh_debug_sv.log(l_module_name, 'p_in_rec1.trip_id',p_in_rec1.trip_id);
2060: END IF;
2061: --
2062:

Line 2063: IF (nvl(WSH_TRIPS_ACTIONS.g_rate_trip_id,-99) <> p_in_rec1.trip_id) THEN --{

2059: wsh_debug_sv.log(l_module_name, 'p_in_rec1.trip_id',p_in_rec1.trip_id);
2060: END IF;
2061: --
2062:
2063: IF (nvl(WSH_TRIPS_ACTIONS.g_rate_trip_id,-99) <> p_in_rec1.trip_id) THEN --{
2064: IF ( nvl(l_cms_flag, 'N') = 'N')
2065: AND p_in_rec1.service_level is not null
2066: AND p_in_rec1.carrier_id is not null
2067: AND p_in_rec1.mode_of_transport is not null

Line 2075: WSH_TRIPS_ACTIONS.g_rate_trip_id := p_in_rec1.trip_id;

2071: IF l_debug_on THEN
2072: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_INTEGRATION.Rate_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
2073: END IF;
2074: --
2075: WSH_TRIPS_ACTIONS.g_rate_trip_id := p_in_rec1.trip_id;
2076:
2077: l_action_params.caller := 'WSH';
2078: l_action_params.event := 'SHIP-CONFIRM';
2079: l_action_params.action := 'RATE';

Line 2093: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_rec1.trip_id));

2089: --
2090: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_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

Line 2103: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_rec1.trip_id));

2099: --{
2100: l_num_warnings := l_num_warnings + 1;
2101: --
2102: FND_MESSAGE.SET_NAME('WSH','WSH_PRICE_CNSLD_ERROR');
2103: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_in_rec1.trip_id));
2104: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
2105: --}
2106: END IF;
2107: --}

Line 2226: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.CHANGESTATUS',WSH_DEBUG_SV.C_PROC_LEVEL);

2222: l_trip_in_rec.stop_id := p_in_Rec.stop_id;
2223: --
2224: --
2225: IF l_debug_on THEN
2226: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.CHANGESTATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
2227: END IF;
2228: --
2229: wsh_trips_actions.changeStatus
2230: (

Line 2229: wsh_trips_actions.changeStatus

2225: IF l_debug_on THEN
2226: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.CHANGESTATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
2227: END IF;
2228: --
2229: wsh_trips_actions.changeStatus
2230: (
2231: p_in_rec => l_trip_in_rec,
2232: x_return_status => l_return_status
2233: );

Line 2741: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.CHANGESTATUS',WSH_DEBUG_SV.C_PROC_LEVEL);

2737: l_trip_in_rec.stop_id := p_in_Rec.stop_id;
2738: --
2739: --
2740: IF l_debug_on THEN
2741: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.CHANGESTATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
2742: END IF;
2743: --
2744: wsh_trips_actions.changeStatus
2745: (

Line 2744: wsh_trips_actions.changeStatus

2740: IF l_debug_on THEN
2741: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.CHANGESTATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
2742: END IF;
2743: --
2744: wsh_trips_actions.changeStatus
2745: (
2746: p_in_rec => l_trip_in_rec,
2747: x_return_status => l_return_status
2748: );

Line 3016: WSH_TRIPS_PVT.lock_trip_no_compare(p_stop_details_rec.trip_id);

3012: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3013: l_locking_stops := 'N';
3014:
3015: -- lock trip p_trip_id;
3016: WSH_TRIPS_PVT.lock_trip_no_compare(p_stop_details_rec.trip_id);
3017:
3018: l_locking_stops := 'Y';
3019:
3020: open get_max_closed_seq( p_stop_details_rec.trip_id);

Line 3094: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.trip_weight_volume',WSH_DEBUG_SV.C_PROC_LEVEL);

3090: END IF;
3091:
3092: -- Need to compute all stops weight/volumes since the sequence would have changed
3093: IF l_debug_on THEN
3094: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.trip_weight_volume',WSH_DEBUG_SV.C_PROC_LEVEL);
3095: END IF;
3096:
3097: l_trip_id_tab(1) := p_stop_details_rec.trip_id;
3098: WSH_TRIPS_ACTIONS.trip_weight_volume(

Line 3098: WSH_TRIPS_ACTIONS.trip_weight_volume(

3094: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.trip_weight_volume',WSH_DEBUG_SV.C_PROC_LEVEL);
3095: END IF;
3096:
3097: l_trip_id_tab(1) := p_stop_details_rec.trip_id;
3098: WSH_TRIPS_ACTIONS.trip_weight_volume(
3099: p_trip_rows => l_trip_id_tab,
3100: p_override_flag => 'Y',
3101: p_calc_wv_if_frozen => 'N',
3102: p_start_departure_date => to_date(NULL),