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

Line 2000: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;

1996: WSH_DEBUG_SV.pop(l_module_name);
1997: END IF;
1998: RETURN;
1999: ELSIF (l_is_delivery_empty = 'Y') THEN
2000: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
2001: ELSIF (l_is_delivery_empty = 'N') THEN
2002: IF (l_gross_weight = 0) THEN
2003: -- do not update if assign/unassign 0/NULL weight line/LPN to
2004: -- nonempty delivery

Line 2021: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

2017: END IF;
2018: END IF;
2019:
2020: IF (l_call_update = 'Y') THEN
2021: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
2022: p_delivery_id_tab => l_delivery_id_tab,
2023: p_tms_interface_flag_tab => l_interface_flag_tab,
2024: x_return_status => l_return_status);
2025:

Line 2030: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');

2026: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
2027: --
2028: x_return_status := l_return_status;
2029: IF l_debug_on THEN
2030: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
2031: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
2032: WSH_DEBUG_SV.pop(l_module_name);
2033: END IF;
2034: RETURN;

Line 3186: wsh_new_deliveries wnd

3182: -- OTM R12 : packing ECO
3183: CURSOR c_get_delivery_info(p_delivery_detail_id IN NUMBER) IS
3184: SELECT wda.delivery_id
3185: FROM wsh_delivery_assignments wda,
3186: wsh_new_deliveries wnd
3187: WHERE wda.delivery_detail_id = p_delivery_detail_id
3188: AND wda.delivery_id = wnd.delivery_id
3189: AND wnd.tms_interface_flag IN
3190: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

Line 3190: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

3186: wsh_new_deliveries wnd
3187: WHERE wda.delivery_detail_id = p_delivery_detail_id
3188: AND wda.delivery_id = wnd.delivery_id
3189: AND wnd.tms_interface_flag IN
3190: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3191: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
3192: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3193: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)
3194: AND NVL(wnd.ignore_for_planning, 'N') = 'N';

Line 3191: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

3187: WHERE wda.delivery_detail_id = p_delivery_detail_id
3188: AND wda.delivery_id = wnd.delivery_id
3189: AND wnd.tms_interface_flag IN
3190: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3191: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
3192: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3193: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)
3194: AND NVL(wnd.ignore_for_planning, 'N') = 'N';
3195:

Line 3192: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

3188: AND wda.delivery_id = wnd.delivery_id
3189: AND wnd.tms_interface_flag IN
3190: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3191: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
3192: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3193: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)
3194: AND NVL(wnd.ignore_for_planning, 'N') = 'N';
3195:
3196: -- bug # 6749200 (replenishment project) : back order consolidation for dynamic replenishment case.

Line 3193: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)

3189: AND wnd.tms_interface_flag IN
3190: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3191: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
3192: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3193: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)
3194: AND NVL(wnd.ignore_for_planning, 'N') = 'N';
3195:
3196: -- bug # 6749200 (replenishment project) : back order consolidation for dynamic replenishment case.
3197: CURSOR get_bo_dd_info IS

Line 3217: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;

3213: l_del_id NUMBER;
3214: l_global_param_rec WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
3215: -- 6749200 (replenishment project) : end
3216:
3217: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;
3218: l_requested_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
3219: l_shipped_quantity WSH_DELIVERY_DETAILS.SHIPPED_QUANTITY%TYPE;
3220: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3221: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

Line 4097: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

4093: -- only proceed if tms_interface_flag is in the following
4094: -- which will be set to UPDATE_REQUIRED
4095: IF (l_delivery_id IS NOT NULL) THEN
4096: l_delivery_id_tab(1) := l_delivery_id;
4097: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
4098:
4099: IF l_debug_on THEN
4100: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab', l_delivery_id_tab(1));
4101: WSH_DEBUG_SV.log(l_module_name, 'l_interface_flag_tab', l_interface_flag_tab(1));

Line 4104: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

4100: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab', l_delivery_id_tab(1));
4101: WSH_DEBUG_SV.log(l_module_name, 'l_interface_flag_tab', l_interface_flag_tab(1));
4102: END IF;
4103:
4104: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
4105: p_delivery_id_tab => l_delivery_id_tab,
4106: p_tms_interface_flag_tab => l_interface_flag_tab,
4107: x_return_status => l_return_status);
4108:

Line 4112: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');

4108:
4109: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
4110: x_return_status := l_return_status;
4111: IF l_debug_on THEN
4112: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
4113: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
4114: WSH_DEBUG_SV.pop(l_module_name);
4115: END IF;
4116: RETURN;

Line 4907: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);

4903: END IF;
4904: EXCEPTION
4905: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
4906: IF p_delivery_id IS NOT NULL THEN
4907: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);
4908: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LINE_LPN_LOCK');
4909: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
4910: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
4911: IF l_debug_on THEN

Line 5266: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);

5262: END IF;
5263: EXCEPTION
5264: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
5265: IF p_delivery_id IS NOT NULL THEN
5266: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);
5267: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LINE_LPN_LOCK');
5268: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
5269: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5270: IF l_debug_on THEN