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_TMS_RELEASE dependencies on WSH_NEW_DELIVERIES

Line 355: wsh_new_deliveries wnd

351: (SELECT wti.group_id FROM wsh_new_del_interface wndi,
352: wsh_del_legs_interface wdli,
353: wsh_trip_stops_interface wtsi,
354: wsh_trips_interface wti,
355: wsh_new_deliveries wnd
356: where wndi.interface_action_code IN (G_TMS_RELEASE_CODE,G_TMS_DELETE_CODE)
357: AND wdli.delivery_interface_id = wndi.delivery_interface_id
358: AND wdli.pick_up_stop_interface_id = wtsi.stop_interface_id
359: AND wtsi.trip_interface_id = wti.trip_interface_id

Line 619: wsh_new_deliveries wnd

615: (SELECT wti.group_id FROM wsh_new_del_interface wndi,
616: wsh_del_legs_interface wdli,
617: wsh_trip_stops_interface wtsi,
618: wsh_trips_interface wti,
619: wsh_new_deliveries wnd
620: where wndi.interface_action_code IN (G_TMS_RELEASE_CODE,G_TMS_DELETE_CODE)
621: AND wdli.delivery_interface_id = wndi.delivery_interface_id
622: AND wdli.pick_up_stop_interface_id = wtsi.stop_interface_id
623: AND wtsi.trip_interface_id = wti.trip_interface_id

Line 722: wsh_new_deliveries wnd

718: wsh_new_del_interface wndi,
719: wsh_trip_stops_interface wtsi_pu,
720: wsh_trip_stops_interface wtsi_do,
721: wsh_trips_interface wti,
722: wsh_new_deliveries wnd
723: WHERE wti.group_id = p_group_id --p_group_id is the input parameter
724: AND wti.interface_action_code = G_TMS_RELEASE_CODE
725: AND wtsi_pu.trip_interface_id = wti.trip_interface_id
726: AND wtsi_pu.stop_interface_id = wdli.pick_up_stop_interface_id

Line 769: wsh_new_deliveries wnd

765: wsh_new_del_interface wndi,
766: wsh_trip_stops_interface wtsi_pu,
767: wsh_trip_stops_interface wtsi_do,
768: wsh_trips_interface wti,
769: wsh_new_deliveries wnd
770: WHERE wti.tp_plan_name >= nvl(p_tp_plan_low,wti.tp_plan_name)
771: AND wti.tp_plan_name <= nvl(p_tp_plan_high,wti.tp_plan_name)
772: AND wti.interface_action_code = G_TMS_RELEASE_CODE
773: AND wtsi_pu.trip_interface_id = wti.trip_interface_id

Line 817: wsh_new_deliveries wnd

813: wsh_new_del_interface wndi,
814: wsh_trip_stops_interface wtsi_pu,
815: wsh_trip_stops_interface wtsi_do,
816: wsh_trips_interface wti,
817: wsh_new_deliveries wnd
818: WHERE wti.interface_action_code = G_TMS_RELEASE_CODE
819: AND wtsi_pu.trip_interface_id = wti.trip_interface_id
820: AND wtsi_pu.stop_interface_id = wdli.pick_up_stop_interface_id
821: AND wtsi_pu.interface_action_code = G_TMS_RELEASE_CODE

Line 834: wsh_new_deliveries wnd

830: (SELECT wti.group_id FROM wsh_new_del_interface wndi,
831: wsh_del_legs_interface wdli,
832: wsh_trip_stops_interface wtsi,
833: wsh_trips_interface wti,
834: wsh_new_deliveries wnd
835: where wndi.interface_action_code IN (G_TMS_RELEASE_CODE,G_TMS_DELETE_CODE)
836: AND wdli.delivery_interface_id = wndi.delivery_interface_id
837: AND wdli.pick_up_stop_interface_id = wtsi.stop_interface_id
838: AND wtsi.trip_interface_id = wti.trip_interface_id

Line 876: wsh_new_deliveries wnd

872: wsh_new_del_interface wndi,
873: wsh_trip_stops_interface wtsi_pu,
874: wsh_trip_stops_interface wtsi_do,
875: wsh_trips_interface wti,
876: wsh_new_deliveries wnd
877: WHERE wti.interface_action_code = G_TMS_RELEASE_CODE
878: AND wtsi_pu.trip_interface_id = wti.trip_interface_id
879: AND wtsi_pu.stop_interface_id = wdli.pick_up_stop_interface_id
880: AND wtsi_pu.interface_action_code = G_TMS_RELEASE_CODE

Line 944: wsh_new_deliveries wnd

940: -- dummy stop which is linked to this physical stop
941: CURSOR c_get_deliveries(p_stop_id IN NUMBER) IS
942: SELECT wdl.delivery_id, wnd.organization_id,wnd.tms_version_number
943: FROM wsh_delivery_legs wdl,
944: wsh_new_deliveries wnd
945: WHERE wdl.pick_up_stop_id = p_stop_id
946: AND wnd.delivery_id = wdl.delivery_id
947: UNION
948: SELECT wdl.delivery_id, wnd.organization_id,wnd.tms_version_number

Line 950: wsh_new_deliveries wnd

946: AND wnd.delivery_id = wdl.delivery_id
947: UNION
948: SELECT wdl.delivery_id, wnd.organization_id,wnd.tms_version_number
949: FROM wsh_delivery_legs wdl,
950: wsh_new_deliveries wnd
951: WHERE wdl.drop_off_stop_id = p_stop_id
952: AND wnd.delivery_id = wdl.delivery_id
953: UNION
954: SELECT wdl.delivery_id, wnd.organization_id,wnd.tms_version_number

Line 956: wsh_new_deliveries wnd,

952: AND wnd.delivery_id = wdl.delivery_id
953: UNION
954: SELECT wdl.delivery_id, wnd.organization_id,wnd.tms_version_number
955: FROM wsh_delivery_legs wdl,
956: wsh_new_deliveries wnd,
957: wsh_trip_stops wts
958: WHERE wdl.drop_off_stop_id = wts.stop_id
959: AND wnd.delivery_id = wdl.delivery_id
960: AND wts.physical_stop_id = p_stop_id;

Line 1050: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

1046:
1047: -- List of Delivery ids which are unassigned during the flow
1048: l_unassigned_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
1049: l_unassigned_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;
1050: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1051: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1052: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1053: l_unassigned_del_index NUMBER;
1054:

Line 1051: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

1047: -- List of Delivery ids which are unassigned during the flow
1048: l_unassigned_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
1049: l_unassigned_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;
1050: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1051: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1052: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1053: l_unassigned_del_index NUMBER;
1054:
1055: -- Populate Errors

Line 1543: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',wsh_new_deliveries_pvt.get_name(l_dleg_local_tab(m).delivery_id));

1539:
1540: EXCEPTION
1541: WHEN OTHERS THEN
1542: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_DLEG');
1543: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',wsh_new_deliveries_pvt.get_name(l_dleg_local_tab(m).delivery_id));
1544: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1545: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1546: IF l_debug_on THEN
1547: WSH_DEBUG_SV.log(l_module_name, 'Delivery Leg not locked: l_return_status', l_return_status);

Line 1555: wsh_new_deliveries_pvt.lock_dlvy_no_compare(

1551:
1552: -- Lock corresponding deliveries in EBS
1553: -- Compare the version number in the where clause of the cursor c_tms_interface_legs
1554: BEGIN
1555: wsh_new_deliveries_pvt.lock_dlvy_no_compare(
1556: p_delivery_id => l_dleg_local_tab(m).delivery_id);
1557: EXCEPTION
1558: WHEN OTHERS THEN
1559: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_DLVY');

Line 1560: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',wsh_new_deliveries_pvt.get_name(l_dleg_local_tab(m).delivery_id));

1556: p_delivery_id => l_dleg_local_tab(m).delivery_id);
1557: EXCEPTION
1558: WHEN OTHERS THEN
1559: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_DLVY');
1560: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',wsh_new_deliveries_pvt.get_name(l_dleg_local_tab(m).delivery_id));
1561: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1562: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1563: IF l_debug_on THEN
1564: WSH_DEBUG_SV.log(l_module_name, 'Delivery not locked: l_return_status', l_return_status);

Line 1730: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;

1726: DECLARE
1727: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;
1728: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
1729:
1730: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
1731: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
1732: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
1733: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
1734:

Line 1937: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;

1933: l_stop_matches VARCHAR2(1); -- stop sent by GC3 matches stop in EBS
1934: l_stop_delete_tab WSH_UTIL_CORE.id_tab_type; -- stops to be deleted
1935: --l_dlvy_unassign_tab WSH_UTIL_CORE.id_tab_type; -- deliveries to be unassigned
1936:
1937: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
1938: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
1939: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
1940: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
1941:

Line 2584: wsh_new_deliveries wnd,

2580: CURSOR c_dock_appt_rec(c_stop_interface_id IN NUMBER, c_group_id IN NUMBER) IS
2581: SELECT wtsi.dock_name, wnd.organization_id, wtsi.start_time, wtsi.end_time
2582: FROM wsh_del_legs_interface wdli,
2583: wsh_new_del_interface wndi,
2584: wsh_new_deliveries wnd,
2585: wsh_trip_stops_interface wtsi,
2586: wsh_trips_interface wti
2587: WHERE wti.group_id = c_group_id
2588: AND wti.interface_action_code = G_TMS_RELEASE_CODE

Line 2732: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;

2728:
2729: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;
2730: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
2731:
2732: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
2733: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
2734: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
2735: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
2736:

Line 3579: FROM wsh_new_deliveries wnd,

3575: ORDER BY wts.stop_sequence_number DESC;
3576:
3577: CURSOR c_lock_deliveries_and_details (c_drop_off_stop_id IN number) IS
3578: SELECT wnd.delivery_id, wdd.delivery_detail_id
3579: FROM wsh_new_deliveries wnd,
3580: wsh_delivery_legs wdl,
3581: wsh_delivery_assignments wda, wsh_delivery_details wdd
3582: WHERE wdl.drop_off_stop_id = c_drop_off_stop_id
3583: AND wdl.delivery_id = wnd.delivery_id

Line 3614: UPDATE wsh_new_deliveries

3610: WSH_DEBUG_SV.log(l_module_name, 'Updating Deliveries and Details With Loading Sequence '||l_loading_sequence);
3611: END IF;
3612:
3613: FORALL i in l_del_tab.FIRST..l_del_tab.LAST
3614: UPDATE wsh_new_deliveries
3615: SET loading_sequence = l_loading_sequence,
3616: last_update_date = SYSDATE,
3617: last_updated_by = FND_GLOBAL.USER_ID,
3618: last_update_login = FND_GLOBAL.LOGIN_ID

Line 3778: p_entity_table_name => 'WSH_NEW_DELIVERIES_INTERFACE',

3774: -- Generic error message is to be logged against all deliveries
3775: -- Handled in stamp_interface_errors
3776: stamp_interface_error(
3777: p_group_id => l_trip_info_tab(i).group_id, --Bug7717569 replaced p_group_id with l_trip_info_tab(i).group_id
3778: p_entity_table_name => 'WSH_NEW_DELIVERIES_INTERFACE',
3779: p_entity_interface_id => l_trip_info_tab(i).trip_interface_id,
3780: p_message_name => 'WSH_OTM_GENERIC', -- NEW MESSAGE !!!
3781: p_dleg_tab => l_dleg_local_tab,
3782: x_errors_tab => l_errors_tab,

Line 3913: l_upd_dlvy_tms_tab(l_upd_dlvy_tms_tab.COUNT + 1) := WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED;

3909: END IF;
3910:
3911: -- OTM R12 populate record structure to call update_tms_interface_flag
3912: l_upd_dlvy_id_tab(l_upd_dlvy_id_tab.COUNT + 1) := l_dleg_local_tab(rec).delivery_id;
3913: l_upd_dlvy_tms_tab(l_upd_dlvy_tms_tab.COUNT + 1) := WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED;
3914: -- OTM R12
3915: ELSE
3916: l_upd_dlvy_id_tab(l_upd_dlvy_id_tab.COUNT + 1) := l_dleg_local_tab(rec).delivery_id;
3917: l_upd_dlvy_tms_tab(l_upd_dlvy_tms_tab.COUNT + 1) := l_dleg_local_tab(rec).tms_interface_flag; --update to the old status.

Line 3981: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);

3977: IF l_debug_on THEN
3978: WSH_DEBUG_SV.log(l_module_name, 'l_unassigned_delivery_id_tab('||l_unassigned_del_index||')='||
3979: l_unassigned_delivery_id_tab(l_unassigned_del_index));
3980:
3981: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);
3982: END IF;
3983:
3984: WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD(p_delivery_id => l_unassigned_delivery_id_tab(l_unassigned_del_index),
3985: x_delivery_rec => l_delivery_info,

Line 3984: WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD(p_delivery_id => l_unassigned_delivery_id_tab(l_unassigned_del_index),

3980:
3981: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);
3982: END IF;
3983:
3984: WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD(p_delivery_id => l_unassigned_delivery_id_tab(l_unassigned_del_index),
3985: x_delivery_rec => l_delivery_info,
3986: x_return_status => l_return_status);
3987:
3988: -- OTM R12

Line 3992: WSH_DEBUG_SV.log(l_module_name, 'WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD Failed');

3988: -- OTM R12
3989: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3990: --l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3991: IF l_debug_on THEN
3992: WSH_DEBUG_SV.log(l_module_name, 'WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD Failed');
3993: END IF;
3994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3995: END IF;
3996: -- OTM R12

Line 4003: l_new_interface_flag_tab(l_delivery_info_tab.count) := WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER;

3999: l_delivery_info_tab(l_delivery_info_tab.COUNT+1) := l_delivery_info;
4000:
4001: IF WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(l_unassigned_delivery_id_tab(l_unassigned_del_index)) = 'N' THEN
4002: -- set the flag to AW
4003: l_new_interface_flag_tab(l_delivery_info_tab.count) := WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER;
4004:
4005: ELSIF WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(l_unassigned_delivery_id_tab(l_unassigned_del_index)) = 'Y' THEN
4006: -- set the flag to NS
4007: l_new_interface_flag_tab(l_delivery_info_tab.count) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;

Line 4007: l_new_interface_flag_tab(l_delivery_info_tab.count) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;

4003: l_new_interface_flag_tab(l_delivery_info_tab.count) := WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER;
4004:
4005: ELSIF WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(l_unassigned_delivery_id_tab(l_unassigned_del_index)) = 'Y' THEN
4006: -- set the flag to NS
4007: l_new_interface_flag_tab(l_delivery_info_tab.count) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;
4008: END IF;
4009:
4010: -- OTM R12 populate record structure to call update_tms_interface_flag
4011: l_upd_dlvy_id_tab(l_upd_dlvy_id_tab.COUNT + 1) := l_unassigned_delivery_id_tab(l_unassigned_del_index);

Line 4027: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag

4023: END IF; --}
4024:
4025: -- OTM R12 call update_tms_interface_flag here
4026:
4027: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag
4028: ( p_delivery_id_tab => l_upd_dlvy_id_tab,
4029: p_tms_interface_flag_tab => l_upd_dlvy_tms_tab,
4030: x_return_status => l_return_status);
4031:

Line 4697: wsh_new_deliveries wnd

4693: wnd.name,
4694: wnd.status_code
4695: FROM wsh_delivery_legs wdl,
4696: wsh_trip_stops wts,
4697: wsh_new_deliveries wnd
4698: WHERE wdl.pick_up_stop_id = wts.stop_id
4699: AND wts.trip_id = p_trip_id
4700: AND wdl.delivery_id = wnd.delivery_id(+);
4701:

Line 4712: wsh_new_deliveries wnd

4708: wnd.status_code
4709: FROM wsh_delivery_legs wdl,
4710: wsh_trip_stops wts,
4711: wsh_trips wt,
4712: wsh_new_deliveries wnd
4713: WHERE wdl.pick_up_stop_id = wts.stop_id
4714: AND wts.trip_id = wt.trip_id
4715: AND wt.tp_plan_name = p_tp_plan_name
4716: AND wdl.delivery_id = wnd.delivery_id(+);

Line 4826: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;

4822: AND wdl.drop_off_stop_id = wts_do.stop_id ;
4823:
4824: l_current_trip_id NUMBER;
4825:
4826: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
4827: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
4828: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
4829: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
4830: