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 2139: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;

2135: WSH_DEBUG_SV.pop(l_module_name);
2136: END IF;
2137: RETURN;
2138: ELSIF (l_is_delivery_empty = 'Y') THEN
2139: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
2140: ELSIF (l_is_delivery_empty = 'N') THEN
2141: l_interface_flag_tab(1) := NULL;
2142: --Bug7608629
2143: --removed code which checked for gross weight

Line 2156: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

2152: END IF;
2153: END IF;
2154:
2155: IF (l_call_update = 'Y') THEN
2156: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
2157: p_delivery_id_tab => l_delivery_id_tab,
2158: p_tms_interface_flag_tab => l_interface_flag_tab,
2159: x_return_status => l_return_status);
2160:

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

2161: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
2162: --
2163: x_return_status := l_return_status;
2164: IF l_debug_on THEN
2165: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
2166: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
2167: WSH_DEBUG_SV.pop(l_module_name);
2168: END IF;
2169: RETURN;

Line 3321: wsh_new_deliveries wnd

3317: -- OTM R12 : packing ECO
3318: CURSOR c_get_delivery_info(p_delivery_detail_id IN NUMBER) IS
3319: SELECT wda.delivery_id
3320: FROM wsh_delivery_assignments wda,
3321: wsh_new_deliveries wnd
3322: WHERE wda.delivery_detail_id = p_delivery_detail_id
3323: AND wda.delivery_id = wnd.delivery_id
3324: AND wnd.tms_interface_flag IN
3325: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

Line 3325: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

3321: wsh_new_deliveries wnd
3322: WHERE wda.delivery_detail_id = p_delivery_detail_id
3323: AND wda.delivery_id = wnd.delivery_id
3324: AND wnd.tms_interface_flag IN
3325: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3326: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
3327: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3328: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)
3329: AND NVL(wnd.ignore_for_planning, 'N') = 'N';

Line 3326: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

3322: WHERE wda.delivery_detail_id = p_delivery_detail_id
3323: AND wda.delivery_id = wnd.delivery_id
3324: AND wnd.tms_interface_flag IN
3325: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3326: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
3327: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3328: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)
3329: AND NVL(wnd.ignore_for_planning, 'N') = 'N';
3330:

Line 3327: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

3323: AND wda.delivery_id = wnd.delivery_id
3324: AND wnd.tms_interface_flag IN
3325: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3326: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
3327: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3328: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)
3329: AND NVL(wnd.ignore_for_planning, 'N') = 'N';
3330:
3331: -- bug # 6749200 (replenishment project) : back order consolidation for dynamic replenishment case.

Line 3328: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)

3324: AND wnd.tms_interface_flag IN
3325: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3326: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
3327: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3328: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)
3329: AND NVL(wnd.ignore_for_planning, 'N') = 'N';
3330:
3331: -- bug # 6749200 (replenishment project) : back order consolidation for dynamic replenishment case.
3332: CURSOR get_bo_dd_info IS

Line 3352: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;

3348: l_del_id NUMBER;
3349: l_global_param_rec WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
3350: -- 6749200 (replenishment project) : end
3351:
3352: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;
3353: l_requested_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
3354: l_shipped_quantity WSH_DELIVERY_DETAILS.SHIPPED_QUANTITY%TYPE;
3355: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3356: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

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

4228: -- only proceed if tms_interface_flag is in the following
4229: -- which will be set to UPDATE_REQUIRED
4230: IF (l_delivery_id IS NOT NULL) THEN
4231: l_delivery_id_tab(1) := l_delivery_id;
4232: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
4233:
4234: IF l_debug_on THEN
4235: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab', l_delivery_id_tab(1));
4236: WSH_DEBUG_SV.log(l_module_name, 'l_interface_flag_tab', l_interface_flag_tab(1));

Line 4239: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

4235: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab', l_delivery_id_tab(1));
4236: WSH_DEBUG_SV.log(l_module_name, 'l_interface_flag_tab', l_interface_flag_tab(1));
4237: END IF;
4238:
4239: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
4240: p_delivery_id_tab => l_delivery_id_tab,
4241: p_tms_interface_flag_tab => l_interface_flag_tab,
4242: x_return_status => l_return_status);
4243:

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

4243:
4244: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
4245: x_return_status := l_return_status;
4246: IF l_debug_on THEN
4247: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
4248: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
4249: WSH_DEBUG_SV.pop(l_module_name);
4250: END IF;
4251: RETURN;

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

5038: END IF;
5039: EXCEPTION
5040: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
5041: IF p_delivery_id IS NOT NULL THEN
5042: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);
5043: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LINE_LPN_LOCK');
5044: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
5045: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5046: IF l_debug_on THEN

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

5414: END IF;
5415: EXCEPTION
5416: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
5417: IF p_delivery_id IS NOT NULL THEN
5418: l_del_name := wsh_new_deliveries_pvt.get_name(p_delivery_id);
5419: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVY_LINE_LPN_LOCK');
5420: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_del_name);
5421: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5422: IF l_debug_on THEN