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