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

Line 3204: FROM WSH_NEW_DELIVERIES

3200: AND container_flag = 'Y';
3201:
3202: CURSOR Get_Del_Org (v_del_id NUMBER) IS
3203: SELECT organization_id, freight_terms_code
3204: FROM WSH_NEW_DELIVERIES
3205: WHERE delivery_id = v_del_id;
3206:
3207: l_del_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE;
3208:

Line 3277: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

3273: IF Get_Del_Org%NOTFOUND THEN
3274: CLOSE Get_Del_Org;
3275: --
3276: IF l_debug_on THEN
3277: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3278: END IF;
3279: --
3280: l_del_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id);
3281: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DEL');

Line 3280: l_del_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id);

3276: IF l_debug_on THEN
3277: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3278: END IF;
3279: --
3280: l_del_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id);
3281: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DEL');
3282: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_name);
3283: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3284: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

Line 3335: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

3331: --
3332: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3333: --
3334: IF l_debug_on THEN
3335: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3336: END IF;
3337: --
3338: l_del_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id);
3339: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ORG_DIFF');

Line 3338: l_del_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id);

3334: IF l_debug_on THEN
3335: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3336: END IF;
3337: --
3338: l_del_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id);
3339: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ORG_DIFF');
3340: FND_MESSAGE.SET_TOKEN('ENTITY1',l_cont_name);
3341: FND_MESSAGE.SET_TOKEN('ENTITY2',l_del_name);
3342: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 6388: nvl(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)

6384: WHERE delivery_detail_id = v_detail_id;
6385:
6386: CURSOR c_get_plan_and_tms_flag(v_delivery_id NUMBER) IS
6387: SELECT nvl(ignore_for_planning, 'N'),
6388: nvl(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6389: FROM wsh_new_deliveries
6390: WHERE delivery_id = v_delivery_id;
6391:
6392: TYPE Boolean_Tab_Type IS TABLE OF BOOLEAN INDEX BY BINARY_INTEGER;

Line 6389: FROM wsh_new_deliveries

6385:
6386: CURSOR c_get_plan_and_tms_flag(v_delivery_id NUMBER) IS
6387: SELECT nvl(ignore_for_planning, 'N'),
6388: nvl(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6389: FROM wsh_new_deliveries
6390: WHERE delivery_id = v_delivery_id;
6391:
6392: TYPE Boolean_Tab_Type IS TABLE OF BOOLEAN INDEX BY BINARY_INTEGER;
6393:

Line 7639: IF (l_tms_interface_flag_tab(l_index) = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN

7635: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');
7636: END IF;
7637: raise FND_API.G_EXC_ERROR;
7638: ELSIF (l_is_delivery_empty = 'N') THEN
7639: IF (l_tms_interface_flag_tab(l_index) = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
7640: l_index_update := l_index_update + 1;
7641: l_delivery_id_tab(l_index_update) := l_dellist1(l_index);
7642: l_interface_flag_tab(l_index_update) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
7643:

Line 7642: l_interface_flag_tab(l_index_update) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;

7638: ELSIF (l_is_delivery_empty = 'N') THEN
7639: IF (l_tms_interface_flag_tab(l_index) = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
7640: l_index_update := l_index_update + 1;
7641: l_delivery_id_tab(l_index_update) := l_dellist1(l_index);
7642: l_interface_flag_tab(l_index_update) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
7643:
7644: IF (l_debug_on) THEN
7645: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery is not empty');
7646: WSH_DEBUG_SV.log(l_module_name,'l_dellist1', l_dellist1(l_index));

Line 7650: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

7646: WSH_DEBUG_SV.log(l_module_name,'l_dellist1', l_dellist1(l_index));
7647: WSH_DEBUG_SV.log(l_module_name,'l_interface_flag_tab', l_interface_flag_tab(l_index_update));
7648: END IF;
7649: ELSIF (l_tms_interface_flag_tab(l_index) in
7650: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7651: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
7652: l_index_update := l_index_update + 1;
7653: l_delivery_id_tab(l_index_update) := l_dellist1(l_index);
7654: l_interface_flag_tab(l_index_update) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 7651: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN

7647: WSH_DEBUG_SV.log(l_module_name,'l_interface_flag_tab', l_interface_flag_tab(l_index_update));
7648: END IF;
7649: ELSIF (l_tms_interface_flag_tab(l_index) in
7650: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7651: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
7652: l_index_update := l_index_update + 1;
7653: l_delivery_id_tab(l_index_update) := l_dellist1(l_index);
7654: l_interface_flag_tab(l_index_update) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
7655: IF (l_debug_on) THEN

Line 7654: l_interface_flag_tab(l_index_update) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

7650: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7651: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
7652: l_index_update := l_index_update + 1;
7653: l_delivery_id_tab(l_index_update) := l_dellist1(l_index);
7654: l_interface_flag_tab(l_index_update) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
7655: IF (l_debug_on) THEN
7656: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery is not empty');
7657: WSH_DEBUG_SV.log(l_module_name,'l_dellist1', l_dellist1(l_index));
7658: WSH_DEBUG_SV.log(l_module_name,'l_interface_flag_tab', l_interface_flag_tab(l_index_update));

Line 7695: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

7691: l_index := l_dellist1.NEXT(l_index);
7692: END LOOP;
7693:
7694: IF (l_index_update > 0) THEN
7695: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
7696: p_delivery_id_tab => l_delivery_id_tab,
7697: p_tms_interface_flag_tab => l_interface_flag_tab,
7698: x_return_status => l_return_status);
7699:

Line 7702: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);

7698: x_return_status => l_return_status);
7699:
7700: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
7701: IF l_debug_on THEN
7702: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);
7703: END IF;
7704: raise FND_API.G_EXC_ERROR;
7705: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
7706: IF l_debug_on THEN

Line 7707: WSH_DEBUG_SV.logmsg(l_module_name,'Warning in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);

7703: END IF;
7704: raise FND_API.G_EXC_ERROR;
7705: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
7706: IF l_debug_on THEN
7707: WSH_DEBUG_SV.logmsg(l_module_name,'Warning in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);
7708: END IF;
7709: cont_warn := cont_warn + 1;
7710: END IF;
7711:

Line 7999: FROM wsh_new_deliveries wnd,

7995: x_return_status OUT NOCOPY VARCHAR2) IS
7996:
7997: CURSOR get_delivery_wms(x_delivery_id NUMBER) IS
7998: SELECT mp.wms_enabled_flag
7999: FROM wsh_new_deliveries wnd,
8000: mtl_parameters mp
8001: WHERE wnd.delivery_id = x_delivery_id
8002: AND mp.organization_id = wnd.organization_id;
8003:

Line 8128: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

8124:
8125: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_AUTOPACK_NULL');
8126: --
8127: IF l_debug_on THEN
8128: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
8129: END IF;
8130: --
8131: l_del_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_tab(j));
8132: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_name);

Line 8131: l_del_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_tab(j));

8127: IF l_debug_on THEN
8128: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
8129: END IF;
8130: --
8131: l_del_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_tab(j));
8132: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_name);
8133: WSH_UTIL_CORE.Add_Message(l_ret_sts,l_module_name);
8134: ELSE
8135:

Line 11685: FROM WSH_NEW_DELIVERIES

11681: vendor_id, -- J-IB-NPARIKH
11682: party_id, -- J-IB-NPARIKH
11683: nvl(ignore_for_planning,'N') ignore_for_planning, --J TP Release
11684: client_id -- LSP PROJECT : ClientID needs to be updated on LPN
11685: FROM WSH_NEW_DELIVERIES
11686: WHERE delivery_id = v_del_id;
11687:
11688: l_cont_name VARCHAR2(30);
11689:

Line 12510: FROM wsh_new_deliveries wnd

12506: vendor_id,
12507: party_id,
12508: name,
12509: nvl(ignore_for_planning,'N') ignore_for_planning
12510: FROM wsh_new_deliveries wnd
12511: WHERE delivery_id = p_delivery_id;
12512: --
12513: --
12514: l_dlvy_rec dlvy_csr%ROWTYPE;

Line 12541: wsh_new_deliveries wnd

12537: wnd.status_code,
12538: wda.delivery_detail_id
12539: from wsh_delivery_details wdd,
12540: wsh_delivery_assignments_v wda,
12541: wsh_new_deliveries wnd
12542: where wdd.container_name = p_lpn_name
12543: and wdd.container_flag = 'Y'
12544: and wda.delivery_detail_id = wdd.delivery_detail_id
12545: and wda.delivery_id = wnd.delivery_id(+);

Line 12951: FROM wsh_new_deliveries wnd

12947: IS
12948: SELECT nvl(shipment_direction,'O') shipment_direction,
12949: initial_pickup_location_id,
12950: name
12951: FROM wsh_new_deliveries wnd
12952: WHERE delivery_id = p_delivery_id;
12953: --
12954: l_dlvy_rec dlvy_csr%ROWTYPE;
12955: --

Line 13424: wsh_new_deliveries d1, wsh_new_deliveries d2,

13420:
13421: cursor c_get_trip_info(p_del_id in number) is
13422: select s.trip_id, d2.delivery_id
13423: from wsh_delivery_legs l1, wsh_delivery_legs l2,
13424: wsh_new_deliveries d1, wsh_new_deliveries d2,
13425: wsh_trip_stops s
13426: where l1.delivery_id = p_del_id
13427: and l1.delivery_id = d1.delivery_id -- bug 4891897
13428: and s.stop_id = l1.pick_up_stop_id

Line 13459: l_del_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

13455: WHERE s.stop_id = l.pick_up_stop_id
13456: AND l.delivery_id = p_delivery_id;
13457:
13458: l_assign_flag VARCHAR2(1);
13459: l_del_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
13460: l_parent_del_info_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
13461: l_del_asg_info_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_TYPE;
13462: l_child_details_tab wsh_util_core.id_tab_type;
13463: l_dummy_asg_tab wsh_util_core.id_tab_type;

Line 13460: l_parent_del_info_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

13456: AND l.delivery_id = p_delivery_id;
13457:
13458: l_assign_flag VARCHAR2(1);
13459: l_del_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
13460: l_parent_del_info_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
13461: l_del_asg_info_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_TYPE;
13462: l_child_details_tab wsh_util_core.id_tab_type;
13463: l_dummy_asg_tab wsh_util_core.id_tab_type;
13464: l_wv_delivery_tab wsh_util_core.id_tab_type;

Line 13662: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.Populate_Record',WSH_DEBUG_SV.C_PROC_LEVEL);

13658: l_child_delivery_id := l_child_container_info.delivery_id;
13659: END IF;
13660:
13661: IF l_debug_on THEN
13662: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.Populate_Record',WSH_DEBUG_SV.C_PROC_LEVEL);
13663: END IF;
13664: WSH_NEW_DELIVERIES_PVT.Populate_Record(
13665: p_delivery_id => l_child_delivery_id,
13666: x_delivery_info => l_del_info_tab(i),

Line 13664: WSH_NEW_DELIVERIES_PVT.Populate_Record(

13660:
13661: IF l_debug_on THEN
13662: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.Populate_Record',WSH_DEBUG_SV.C_PROC_LEVEL);
13663: END IF;
13664: WSH_NEW_DELIVERIES_PVT.Populate_Record(
13665: p_delivery_id => l_child_delivery_id,
13666: x_delivery_info => l_del_info_tab(i),
13667: x_return_status => l_return_status);
13668:

Line 13763: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.Populate_Record',WSH_DEBUG_SV.C_PROC_LEVEL);

13759: -- Convert the parent LPN to be a consol LPN.
13760:
13761: -- Get the attributes of the parent delivery
13762: IF l_debug_on THEN
13763: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.Populate_Record',WSH_DEBUG_SV.C_PROC_LEVEL);
13764: END IF;
13765:
13766: WSH_NEW_DELIVERIES_PVT.Populate_Record(
13767: p_delivery_id => l_new_parent_delivery_id,

Line 13766: WSH_NEW_DELIVERIES_PVT.Populate_Record(

13762: IF l_debug_on THEN
13763: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.Populate_Record',WSH_DEBUG_SV.C_PROC_LEVEL);
13764: END IF;
13765:
13766: WSH_NEW_DELIVERIES_PVT.Populate_Record(
13767: p_delivery_id => l_new_parent_delivery_id,
13768: x_delivery_info => l_parent_del_info_rec,
13769: x_return_status => l_return_status);
13770:

Line 13982: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.Populate_Record',WSH_DEBUG_SV.C_PROC_LEVEL);

13978:
13979: FOR i in 1..l_del_tab.count LOOP
13980:
13981: IF l_debug_on THEN
13982: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.Populate_Record',WSH_DEBUG_SV.C_PROC_LEVEL);
13983: END IF;
13984: WSH_NEW_DELIVERIES_PVT.Populate_Record(
13985: p_delivery_id => l_del_tab(i),
13986: x_delivery_info => l_del_info_tab(i),

Line 13984: WSH_NEW_DELIVERIES_PVT.Populate_Record(

13980:
13981: IF l_debug_on THEN
13982: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.Populate_Record',WSH_DEBUG_SV.C_PROC_LEVEL);
13983: END IF;
13984: WSH_NEW_DELIVERIES_PVT.Populate_Record(
13985: p_delivery_id => l_del_tab(i),
13986: x_delivery_info => l_del_info_tab(i),
13987: x_return_status => l_return_status);
13988:

Line 14257: wsh_new_deliveries wnd

14253: wdd2.volume_uom_code
14254: from wsh_delivery_details wdd1,
14255: wsh_delivery_details wdd2,
14256: wsh_delivery_assignments wda,
14257: wsh_new_deliveries wnd
14258: where wdd1.delivery_detail_id = p_dd_id
14259: and wda.delivery_detail_id = wdd1.delivery_detail_id
14260: and wda.type = 'C'
14261: and wda.delivery_id = wnd.delivery_id