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_GRP dependencies on WSH_TRIPS

Line 532: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;

528: l_valid_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
529: l_num_warning NUMBER := 0;
530: l_num_errors NUMBER := 0;
531: l_return_status VARCHAR2(500);
532: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
533: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
534: l_api_version_number CONSTANT NUMBER := 1.0;
535: l_api_name CONSTANT VARCHAR2(30):= 'Stop_Action';
536: l_counter NUMBER;

Line 562: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

558: l_cc_stop_id_tab wsh_util_core.id_tab_type;
559: l_cc_count_success NUMBER;
560: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
561: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
562: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
563: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
564: l_cc_in_ids wsh_util_core.id_tab_type;
565: l_cc_fail_ids wsh_util_core.id_tab_type;
566: l_msg_count NUMBER;

Line 577: FROM WSH_TRIPS

573: l_delete_t WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab;
574:
575: CURSOR c_check_trip_close (p_trip_id IN NUMBER) IS
576: SELECT trip_id
577: FROM WSH_TRIPS
578: WHERE trip_id=p_trip_id
579: AND status_code='IT'
580: AND NOT EXISTS (select 'x'
581: from wsh_trip_stops

Line 1319: WSH_TRIPS_ACTIONS.Handle_Internal_Stops(

1315: x_num_warnings =>l_num_warning,
1316: x_num_errors =>l_num_errors);
1317:
1318:
1319: WSH_TRIPS_ACTIONS.Handle_Internal_Stops(
1320: p_trip_ids => l_trip_affected_tab,
1321: p_caller => p_action_prms.caller,
1322: x_success_trip_ids => l_success_trip_tab,
1323: x_return_status => l_return_status);

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

1337: OPEN c_check_trip_close(l_trip_affected_tab(i));
1338: FETCH c_check_trip_close INTO l_trip_in_rec.trip_id;
1339: IF c_check_trip_close%FOUND THEN
1340: IF l_debug_on THEN
1341: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.CHANGESTATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
1342: WSH_DEBUG_SV.log(l_module_name,'Trip',l_trip_in_rec.trip_id);
1343: END IF;
1344:
1345: wsh_trips_actions.changeStatus

Line 1345: wsh_trips_actions.changeStatus

1341: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.CHANGESTATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
1342: WSH_DEBUG_SV.log(l_module_name,'Trip',l_trip_in_rec.trip_id);
1343: END IF;
1344:
1345: wsh_trips_actions.changeStatus
1346: (
1347: p_in_rec => l_trip_in_rec,
1348: x_return_status => l_return_status
1349: );

Line 1923: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;

1919: l_action VARCHAR2(100);
1920: l_return_status VARCHAR2(1);
1921: x_msg_count NUMBER;
1922: x_msg_data varchar2(3000);
1923: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
1924: l_isWshLocation BOOLEAN DEFAULT FALSE;
1925:
1926: WSH_STOP_VALIDATION EXCEPTION;
1927: e_mixed_stop_error EXCEPTION;

Line 2122: IF (WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN) AND

2118: END IF;
2119:
2120: -- SSN change
2121: -- Add conditional validation for stop sequence number
2122: IF (WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN) AND
2123: (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_SEQ_NUM_LVL) = 1 ) THEN
2124:
2125: IF (l_status_code = 'OP') THEN
2126: WSH_TRIP_STOPS_validations.validate_sequence_number (

Line 2334: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2330:
2331: --dummy tables for calling validate_constraint_mainper
2332: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2333: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
2334: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2335: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2336: l_cc_in_ids wsh_util_core.id_tab_type;
2337: l_cc_fail_ids wsh_util_core.id_tab_type;
2338:

Line 2369: FROM wsh_trips

2365: CURSOR c_trip_info (p_trip_id in number) is
2366: SELECT mode_of_transport,
2367: NVL(ignore_for_planning,'N'), -- OTM R12,glog project
2368: tp_plan_name
2369: FROM wsh_trips
2370: WHERE trip_id = p_trip_id;
2371:
2372: --OTM R12, glog proj
2373: l_ignore WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE;

Line 2373: l_ignore WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE;

2369: FROM wsh_trips
2370: WHERE trip_id = p_trip_id;
2371:
2372: --OTM R12, glog proj
2373: l_ignore WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE;
2374: l_tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE;
2375: l_gc3_is_installed VARCHAR2(1);
2376: e_gc3_trip_exception EXCEPTION;
2377: --OTM R12, end of glog proj

Line 2374: l_tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE;

2370: WHERE trip_id = p_trip_id;
2371:
2372: --OTM R12, glog proj
2373: l_ignore WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE;
2374: l_tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE;
2375: l_gc3_is_installed VARCHAR2(1);
2376: e_gc3_trip_exception EXCEPTION;
2377: --OTM R12, end of glog proj
2378:

Line 2391: l_mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE;

2387:
2388: get_physical_loc_err EXCEPTION;
2389:
2390: -- bug 3848771
2391: l_mode_of_transport WSH_TRIPS.MODE_OF_TRANSPORT%TYPE;
2392: --Bugfix 4070732
2393: l_api_session_name CONSTANT VARCHAR2(150) := G_PKG_NAME ||'.' || l_module_name;
2394: l_reset_flags BOOLEAN;
2395:

Line 2416: l_stop_seq_mode := WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE; -- SSN change

2412: THEN
2413: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2414: END IF;
2415: --
2416: l_stop_seq_mode := WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE; -- SSN change
2417:
2418: SAVEPOINT create_update_stop_grp;
2419:
2420: l_trips.delete;

Line 2739: WSH_TRIPS_ACTIONS.Handle_Internal_Stops(

2735:
2736:
2737: IF l_rec_attr_tab(x_index_id_tab(l_index)).trip_id is not NULL THEN
2738: l_trips(1) := l_rec_attr_tab(x_index_id_tab(l_index)).trip_id;
2739: WSH_TRIPS_ACTIONS.Handle_Internal_Stops(
2740: p_trip_ids => l_trips,
2741: p_caller => 'WSH_CREATE_TRIP_STOP',
2742: x_success_trip_ids => l_success_trip_ids,
2743: x_return_status => l_return_status);

Line 2864: WSH_TRIPS_ACTIONS.Handle_Internal_Stops(

2860: wsh_debug_sv.logmsg(l_module_name,'handle internal stop TRUE');
2861: END IF;
2862: l_trips(1) := l_rec_attr_tab(x_index_id_tab(l_index)).trip_id;
2863:
2864: WSH_TRIPS_ACTIONS.Handle_Internal_Stops(
2865: p_trip_ids => l_trips,
2866: p_caller => p_in_rec.caller,
2867: x_success_trip_ids => l_success_trip_ids,
2868: x_return_status => l_return_status);

Line 3903: FROM wsh_trip_stops wts, wsh_trips wt

3899: AND wnd.ultimate_dropoff_location_id = p_stop_loc_id;
3900: --
3901: CURSOR c_stop_trip_info(p_stop_id NUMBER) IS
3902: SELECT wts.trip_id, wts.stop_location_id, wt.status_code
3903: FROM wsh_trip_stops wts, wsh_trips wt
3904: WHERE wts.stop_id = p_stop_id
3905: AND wts.trip_id = wt.trip_id;
3906: --
3907: CURSOR c_unclosed_other_stops(p_trip_id NUMBER, p_stop_id NUMBER) IS

Line 3971: WSH_TRIPS_PVT.lock_trip_no_compare(

3967:
3968: IF l_trip_status = 'OP'
3969: THEN
3970: -- {
3971: WSH_TRIPS_PVT.lock_trip_no_compare(
3972: p_trip_id => l_trip_id
3973: );
3974:
3975: ELSIF l_trip_status = 'IT'

Line 3983: WSH_TRIPS_PVT.lock_trip_no_compare(

3979: IF c_unclosed_other_stops%NOTFOUND
3980: THEN
3981: CLOSE c_unclosed_other_stops;
3982:
3983: WSH_TRIPS_PVT.lock_trip_no_compare(
3984: p_trip_id => l_trip_id
3985: );
3986: ELSE
3987: IF l_debug_on THEN