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_PVT

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 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 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 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: