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 353: wsh_new_deliveries wnd

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

Line 615: wsh_new_deliveries wnd

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

Line 717: wsh_new_deliveries wnd

713: wsh_new_del_interface wndi,
714: wsh_trip_stops_interface wtsi_pu,
715: wsh_trip_stops_interface wtsi_do,
716: wsh_trips_interface wti,
717: wsh_new_deliveries wnd
718: WHERE wti.group_id = p_group_id --p_group_id is the input parameter
719: AND wti.interface_action_code = G_TMS_RELEASE_CODE
720: AND wtsi_pu.trip_interface_id = wti.trip_interface_id
721: AND wtsi_pu.stop_interface_id = wdli.pick_up_stop_interface_id

Line 764: wsh_new_deliveries wnd

760: wsh_new_del_interface wndi,
761: wsh_trip_stops_interface wtsi_pu,
762: wsh_trip_stops_interface wtsi_do,
763: wsh_trips_interface wti,
764: wsh_new_deliveries wnd
765: WHERE wti.tp_plan_name >= nvl(p_tp_plan_low,wti.tp_plan_name)
766: AND wti.tp_plan_name <= nvl(p_tp_plan_high,wti.tp_plan_name)
767: AND wti.interface_action_code = G_TMS_RELEASE_CODE
768: AND wtsi_pu.trip_interface_id = wti.trip_interface_id

Line 812: wsh_new_deliveries wnd

808: wsh_new_del_interface wndi,
809: wsh_trip_stops_interface wtsi_pu,
810: wsh_trip_stops_interface wtsi_do,
811: wsh_trips_interface wti,
812: wsh_new_deliveries wnd
813: WHERE wti.interface_action_code = G_TMS_RELEASE_CODE
814: AND wtsi_pu.trip_interface_id = wti.trip_interface_id
815: AND wtsi_pu.stop_interface_id = wdli.pick_up_stop_interface_id
816: AND wtsi_pu.interface_action_code = G_TMS_RELEASE_CODE

Line 829: wsh_new_deliveries wnd

825: (SELECT wti.group_id FROM wsh_new_del_interface wndi,
826: wsh_del_legs_interface wdli,
827: wsh_trip_stops_interface wtsi,
828: wsh_trips_interface wti,
829: wsh_new_deliveries wnd
830: where wndi.interface_action_code IN (G_TMS_RELEASE_CODE,G_TMS_DELETE_CODE)
831: AND wdli.delivery_interface_id = wndi.delivery_interface_id
832: AND wdli.pick_up_stop_interface_id = wtsi.stop_interface_id
833: AND wtsi.trip_interface_id = wti.trip_interface_id

Line 869: wsh_new_deliveries wnd

865: wsh_new_del_interface wndi,
866: wsh_trip_stops_interface wtsi_pu,
867: wsh_trip_stops_interface wtsi_do,
868: wsh_trips_interface wti,
869: wsh_new_deliveries wnd
870: WHERE wti.interface_action_code = G_TMS_RELEASE_CODE
871: AND wtsi_pu.trip_interface_id = wti.trip_interface_id
872: AND wtsi_pu.stop_interface_id = wdli.pick_up_stop_interface_id
873: AND wtsi_pu.interface_action_code = G_TMS_RELEASE_CODE

Line 937: wsh_new_deliveries wnd

933: -- dummy stop which is linked to this physical stop
934: CURSOR c_get_deliveries(p_stop_id IN NUMBER) IS
935: SELECT wdl.delivery_id, wnd.organization_id,wnd.tms_version_number
936: FROM wsh_delivery_legs wdl,
937: wsh_new_deliveries wnd
938: WHERE wdl.pick_up_stop_id = p_stop_id
939: AND wnd.delivery_id = wdl.delivery_id
940: UNION
941: SELECT wdl.delivery_id, wnd.organization_id,wnd.tms_version_number

Line 943: wsh_new_deliveries wnd

939: AND wnd.delivery_id = wdl.delivery_id
940: UNION
941: SELECT wdl.delivery_id, wnd.organization_id,wnd.tms_version_number
942: FROM wsh_delivery_legs wdl,
943: wsh_new_deliveries wnd
944: WHERE wdl.drop_off_stop_id = p_stop_id
945: AND wnd.delivery_id = wdl.delivery_id
946: UNION
947: SELECT wdl.delivery_id, wnd.organization_id,wnd.tms_version_number

Line 949: wsh_new_deliveries wnd,

945: AND wnd.delivery_id = wdl.delivery_id
946: UNION
947: SELECT wdl.delivery_id, wnd.organization_id,wnd.tms_version_number
948: FROM wsh_delivery_legs wdl,
949: wsh_new_deliveries wnd,
950: wsh_trip_stops wts
951: WHERE wdl.drop_off_stop_id = wts.stop_id
952: AND wnd.delivery_id = wdl.delivery_id
953: AND wts.physical_stop_id = p_stop_id;

Line 1043: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

1039:
1040: -- List of Delivery ids which are unassigned during the flow
1041: l_unassigned_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
1042: l_unassigned_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;
1043: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1044: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1045: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1046: l_unassigned_del_index NUMBER;
1047:

Line 1044: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

1040: -- List of Delivery ids which are unassigned during the flow
1041: l_unassigned_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
1042: l_unassigned_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;
1043: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1044: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1045: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1046: l_unassigned_del_index NUMBER;
1047:
1048: -- Populate Errors

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

1531:
1532: EXCEPTION
1533: WHEN OTHERS THEN
1534: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_DLEG');
1535: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',wsh_new_deliveries_pvt.get_name(l_dleg_local_tab(m).delivery_id));
1536: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1537: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1538: IF l_debug_on THEN
1539: WSH_DEBUG_SV.log(l_module_name, 'Delivery Leg not locked: l_return_status', l_return_status);

Line 1547: wsh_new_deliveries_pvt.lock_dlvy_no_compare(

1543:
1544: -- Lock corresponding deliveries in EBS
1545: -- Compare the version number in the where clause of the cursor c_tms_interface_legs
1546: BEGIN
1547: wsh_new_deliveries_pvt.lock_dlvy_no_compare(
1548: p_delivery_id => l_dleg_local_tab(m).delivery_id);
1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_DLVY');

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

1548: p_delivery_id => l_dleg_local_tab(m).delivery_id);
1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_DLVY');
1552: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',wsh_new_deliveries_pvt.get_name(l_dleg_local_tab(m).delivery_id));
1553: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1554: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1555: IF l_debug_on THEN
1556: WSH_DEBUG_SV.log(l_module_name, 'Delivery not locked: l_return_status', l_return_status);

Line 1722: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;

1718: DECLARE
1719: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;
1720: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
1721:
1722: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
1723: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
1724: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
1725: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
1726:

Line 1929: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;

1925: l_stop_matches VARCHAR2(1); -- stop sent by GC3 matches stop in EBS
1926: l_stop_delete_tab WSH_UTIL_CORE.id_tab_type; -- stops to be deleted
1927: --l_dlvy_unassign_tab WSH_UTIL_CORE.id_tab_type; -- deliveries to be unassigned
1928:
1929: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
1930: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
1931: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
1932: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
1933:

Line 2576: wsh_new_deliveries wnd,

2572: CURSOR c_dock_appt_rec(c_stop_interface_id IN NUMBER, c_group_id IN NUMBER) IS
2573: SELECT wtsi.dock_name, wnd.organization_id, wtsi.start_time, wtsi.end_time
2574: FROM wsh_del_legs_interface wdli,
2575: wsh_new_del_interface wndi,
2576: wsh_new_deliveries wnd,
2577: wsh_trip_stops_interface wtsi,
2578: wsh_trips_interface wti
2579: WHERE wti.group_id = c_group_id
2580: AND wti.interface_action_code = G_TMS_RELEASE_CODE

Line 2724: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;

2720:
2721: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;
2722: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
2723:
2724: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
2725: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
2726: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
2727: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
2728:

Line 3571: FROM wsh_new_deliveries wnd,

3567: ORDER BY wts.stop_sequence_number DESC;
3568:
3569: CURSOR c_lock_deliveries_and_details (c_drop_off_stop_id IN number) IS
3570: SELECT wnd.delivery_id, wdd.delivery_detail_id
3571: FROM wsh_new_deliveries wnd,
3572: wsh_delivery_legs wdl,
3573: wsh_delivery_assignments wda, wsh_delivery_details wdd
3574: WHERE wdl.drop_off_stop_id = c_drop_off_stop_id
3575: AND wdl.delivery_id = wnd.delivery_id

Line 3606: UPDATE wsh_new_deliveries

3602: WSH_DEBUG_SV.log(l_module_name, 'Updating Deliveries and Details With Loading Sequence '||l_loading_sequence);
3603: END IF;
3604:
3605: FORALL i in l_del_tab.FIRST..l_del_tab.LAST
3606: UPDATE wsh_new_deliveries
3607: SET loading_sequence = l_loading_sequence,
3608: last_update_date = SYSDATE,
3609: last_updated_by = FND_GLOBAL.USER_ID,
3610: last_update_login = FND_GLOBAL.LOGIN_ID

Line 3770: p_entity_table_name => 'WSH_NEW_DELIVERIES_INTERFACE',

3766: -- Generic error message is to be logged against all deliveries
3767: -- Handled in stamp_interface_errors
3768: stamp_interface_error(
3769: p_group_id => l_trip_info_tab(i).group_id, --Bug7717569 replaced p_group_id with l_trip_info_tab(i).group_id
3770: p_entity_table_name => 'WSH_NEW_DELIVERIES_INTERFACE',
3771: p_entity_interface_id => l_trip_info_tab(i).trip_interface_id,
3772: p_message_name => 'WSH_OTM_GENERIC', -- NEW MESSAGE !!!
3773: p_dleg_tab => l_dleg_local_tab,
3774: x_errors_tab => l_errors_tab,

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

3901: END IF;
3902:
3903: -- OTM R12 populate record structure to call update_tms_interface_flag
3904: l_upd_dlvy_id_tab(l_upd_dlvy_id_tab.COUNT + 1) := l_dleg_local_tab(rec).delivery_id;
3905: l_upd_dlvy_tms_tab(l_upd_dlvy_tms_tab.COUNT + 1) := WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED;
3906: -- OTM R12
3907: ELSE
3908: l_upd_dlvy_id_tab(l_upd_dlvy_id_tab.COUNT + 1) := l_dleg_local_tab(rec).delivery_id;
3909: 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 3973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);

3969: IF l_debug_on THEN
3970: WSH_DEBUG_SV.log(l_module_name, 'l_unassigned_delivery_id_tab('||l_unassigned_del_index||')='||
3971: l_unassigned_delivery_id_tab(l_unassigned_del_index));
3972:
3973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);
3974: END IF;
3975:
3976: WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD(p_delivery_id => l_unassigned_delivery_id_tab(l_unassigned_del_index),
3977: x_delivery_rec => l_delivery_info,

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

3972:
3973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD',WSH_DEBUG_SV.C_PROC_LEVEL);
3974: END IF;
3975:
3976: WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD(p_delivery_id => l_unassigned_delivery_id_tab(l_unassigned_del_index),
3977: x_delivery_rec => l_delivery_info,
3978: x_return_status => l_return_status);
3979:
3980: -- OTM R12

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

3980: -- OTM R12
3981: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3982: --l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3983: IF l_debug_on THEN
3984: WSH_DEBUG_SV.log(l_module_name, 'WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD Failed');
3985: END IF;
3986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3987: END IF;
3988: -- OTM R12

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

3991: l_delivery_info_tab(l_delivery_info_tab.COUNT+1) := l_delivery_info;
3992:
3993: IF WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(l_unassigned_delivery_id_tab(l_unassigned_del_index)) = 'N' THEN
3994: -- set the flag to AW
3995: l_new_interface_flag_tab(l_delivery_info_tab.count) := WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER;
3996:
3997: ELSIF WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(l_unassigned_delivery_id_tab(l_unassigned_del_index)) = 'Y' THEN
3998: -- set the flag to NS
3999: l_new_interface_flag_tab(l_delivery_info_tab.count) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;

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

3995: l_new_interface_flag_tab(l_delivery_info_tab.count) := WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER;
3996:
3997: ELSIF WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(l_unassigned_delivery_id_tab(l_unassigned_del_index)) = 'Y' THEN
3998: -- set the flag to NS
3999: l_new_interface_flag_tab(l_delivery_info_tab.count) := WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT;
4000: END IF;
4001:
4002: -- OTM R12 populate record structure to call update_tms_interface_flag
4003: l_upd_dlvy_id_tab(l_upd_dlvy_id_tab.COUNT + 1) := l_unassigned_delivery_id_tab(l_unassigned_del_index);

Line 4019: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag

4015: END IF; --}
4016:
4017: -- OTM R12 call update_tms_interface_flag here
4018:
4019: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag
4020: ( p_delivery_id_tab => l_upd_dlvy_id_tab,
4021: p_tms_interface_flag_tab => l_upd_dlvy_tms_tab,
4022: x_return_status => l_return_status);
4023:

Line 4689: wsh_new_deliveries wnd

4685: wnd.name,
4686: wnd.status_code
4687: FROM wsh_delivery_legs wdl,
4688: wsh_trip_stops wts,
4689: wsh_new_deliveries wnd
4690: WHERE wdl.pick_up_stop_id = wts.stop_id
4691: AND wts.trip_id = p_trip_id
4692: AND wdl.delivery_id = wnd.delivery_id(+);
4693:

Line 4704: wsh_new_deliveries wnd

4700: wnd.status_code
4701: FROM wsh_delivery_legs wdl,
4702: wsh_trip_stops wts,
4703: wsh_trips wt,
4704: wsh_new_deliveries wnd
4705: WHERE wdl.pick_up_stop_id = wts.stop_id
4706: AND wts.trip_id = wt.trip_id
4707: AND wt.tp_plan_name = p_tp_plan_name
4708: AND wdl.delivery_id = wnd.delivery_id(+);

Line 4818: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;

4814: AND wdl.drop_off_stop_id = wts_do.stop_id ;
4815:
4816: l_current_trip_id NUMBER;
4817:
4818: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
4819: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
4820: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
4821: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
4822: