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 3150: FROM WSH_NEW_DELIVERIES

3146: AND container_flag = 'Y';
3147:
3148: CURSOR Get_Del_Org (v_del_id NUMBER) IS
3149: SELECT organization_id, freight_terms_code
3150: FROM WSH_NEW_DELIVERIES
3151: WHERE delivery_id = v_del_id;
3152:
3153: l_del_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE;
3154:

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

3219: IF Get_Del_Org%NOTFOUND THEN
3220: CLOSE Get_Del_Org;
3221: --
3222: IF l_debug_on THEN
3223: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3224: END IF;
3225: --
3226: l_del_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id);
3227: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DEL');

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

3222: IF l_debug_on THEN
3223: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3224: END IF;
3225: --
3226: l_del_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id);
3227: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DEL');
3228: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_name);
3229: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3230: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

3277: --
3278: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3279: --
3280: IF l_debug_on THEN
3281: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3282: END IF;
3283: --
3284: l_del_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id);
3285: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ORG_DIFF');

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

3280: IF l_debug_on THEN
3281: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3282: END IF;
3283: --
3284: l_del_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id);
3285: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ORG_DIFF');
3286: FND_MESSAGE.SET_TOKEN('ENTITY1',l_cont_name);
3287: FND_MESSAGE.SET_TOKEN('ENTITY2',l_del_name);
3288: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 6315: nvl(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)

6311: WHERE delivery_detail_id = v_detail_id;
6312:
6313: CURSOR c_get_plan_and_tms_flag(v_delivery_id NUMBER) IS
6314: SELECT nvl(ignore_for_planning, 'N'),
6315: nvl(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6316: FROM wsh_new_deliveries
6317: WHERE delivery_id = v_delivery_id;
6318:
6319: TYPE Boolean_Tab_Type IS TABLE OF BOOLEAN INDEX BY BINARY_INTEGER;

Line 6316: FROM wsh_new_deliveries

6312:
6313: CURSOR c_get_plan_and_tms_flag(v_delivery_id NUMBER) IS
6314: SELECT nvl(ignore_for_planning, 'N'),
6315: nvl(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6316: FROM wsh_new_deliveries
6317: WHERE delivery_id = v_delivery_id;
6318:
6319: TYPE Boolean_Tab_Type IS TABLE OF BOOLEAN INDEX BY BINARY_INTEGER;
6320:

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

7503: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');
7504: END IF;
7505: raise FND_API.G_EXC_ERROR;
7506: ELSIF (l_is_delivery_empty = 'N') THEN
7507: IF (l_tms_interface_flag_tab(l_index) = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
7508: l_index_update := l_index_update + 1;
7509: l_delivery_id_tab(l_index_update) := l_dellist1(l_index);
7510: l_interface_flag_tab(l_index_update) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
7511:

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

7506: ELSIF (l_is_delivery_empty = 'N') THEN
7507: IF (l_tms_interface_flag_tab(l_index) = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
7508: l_index_update := l_index_update + 1;
7509: l_delivery_id_tab(l_index_update) := l_dellist1(l_index);
7510: l_interface_flag_tab(l_index_update) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
7511:
7512: IF (l_debug_on) THEN
7513: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery is not empty');
7514: WSH_DEBUG_SV.log(l_module_name,'l_dellist1', l_dellist1(l_index));

Line 7518: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

7514: WSH_DEBUG_SV.log(l_module_name,'l_dellist1', l_dellist1(l_index));
7515: WSH_DEBUG_SV.log(l_module_name,'l_interface_flag_tab', l_interface_flag_tab(l_index_update));
7516: END IF;
7517: ELSIF (l_tms_interface_flag_tab(l_index) in
7518: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7519: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
7520: l_index_update := l_index_update + 1;
7521: l_delivery_id_tab(l_index_update) := l_dellist1(l_index);
7522: l_interface_flag_tab(l_index_update) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 7519: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN

7515: WSH_DEBUG_SV.log(l_module_name,'l_interface_flag_tab', l_interface_flag_tab(l_index_update));
7516: END IF;
7517: ELSIF (l_tms_interface_flag_tab(l_index) in
7518: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7519: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
7520: l_index_update := l_index_update + 1;
7521: l_delivery_id_tab(l_index_update) := l_dellist1(l_index);
7522: l_interface_flag_tab(l_index_update) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
7523: IF (l_debug_on) THEN

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

7518: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
7519: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
7520: l_index_update := l_index_update + 1;
7521: l_delivery_id_tab(l_index_update) := l_dellist1(l_index);
7522: l_interface_flag_tab(l_index_update) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
7523: IF (l_debug_on) THEN
7524: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery is not empty');
7525: WSH_DEBUG_SV.log(l_module_name,'l_dellist1', l_dellist1(l_index));
7526: WSH_DEBUG_SV.log(l_module_name,'l_interface_flag_tab', l_interface_flag_tab(l_index_update));

Line 7567: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

7563: l_index := l_dellist1.NEXT(l_index);
7564: END LOOP;
7565:
7566: IF (l_index_update > 0) THEN
7567: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
7568: p_delivery_id_tab => l_delivery_id_tab,
7569: p_tms_interface_flag_tab => l_interface_flag_tab,
7570: x_return_status => l_return_status);
7571:

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

7570: x_return_status => l_return_status);
7571:
7572: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
7573: IF l_debug_on THEN
7574: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);
7575: END IF;
7576: raise FND_API.G_EXC_ERROR;
7577: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
7578: IF l_debug_on THEN

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

7575: END IF;
7576: raise FND_API.G_EXC_ERROR;
7577: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
7578: IF l_debug_on THEN
7579: WSH_DEBUG_SV.logmsg(l_module_name,'Warning in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);
7580: END IF;
7581: cont_warn := cont_warn + 1;
7582: END IF;
7583:

Line 7870: FROM wsh_new_deliveries wnd,

7866: x_return_status OUT NOCOPY VARCHAR2) IS
7867:
7868: CURSOR get_delivery_wms(x_delivery_id NUMBER) IS
7869: SELECT mp.wms_enabled_flag
7870: FROM wsh_new_deliveries wnd,
7871: mtl_parameters mp
7872: WHERE wnd.delivery_id = x_delivery_id
7873: AND mp.organization_id = wnd.organization_id;
7874:

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

7995:
7996: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_AUTOPACK_NULL');
7997: --
7998: IF l_debug_on THEN
7999: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
8000: END IF;
8001: --
8002: l_del_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_tab(j));
8003: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_name);

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

7998: IF l_debug_on THEN
7999: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
8000: END IF;
8001: --
8002: l_del_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_tab(j));
8003: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_name);
8004: WSH_UTIL_CORE.Add_Message(l_ret_sts,l_module_name);
8005: ELSE
8006:

Line 11554: FROM WSH_NEW_DELIVERIES

11550: shipping_control, -- J-IB-NPARIKH
11551: vendor_id, -- J-IB-NPARIKH
11552: party_id, -- J-IB-NPARIKH
11553: nvl(ignore_for_planning,'N') ignore_for_planning --J TP Release
11554: FROM WSH_NEW_DELIVERIES
11555: WHERE delivery_id = v_del_id;
11556:
11557: l_cont_name VARCHAR2(30);
11558:

Line 12360: FROM wsh_new_deliveries wnd

12356: vendor_id,
12357: party_id,
12358: name,
12359: nvl(ignore_for_planning,'N') ignore_for_planning
12360: FROM wsh_new_deliveries wnd
12361: WHERE delivery_id = p_delivery_id;
12362: --
12363: --
12364: l_dlvy_rec dlvy_csr%ROWTYPE;

Line 12391: wsh_new_deliveries wnd

12387: wnd.status_code,
12388: wda.delivery_detail_id
12389: from wsh_delivery_details wdd,
12390: wsh_delivery_assignments_v wda,
12391: wsh_new_deliveries wnd
12392: where wdd.container_name = p_lpn_name
12393: and wdd.container_flag = 'Y'
12394: and wda.delivery_detail_id = wdd.delivery_detail_id
12395: and wda.delivery_id = wnd.delivery_id(+);

Line 12801: FROM wsh_new_deliveries wnd

12797: IS
12798: SELECT nvl(shipment_direction,'O') shipment_direction,
12799: initial_pickup_location_id,
12800: name
12801: FROM wsh_new_deliveries wnd
12802: WHERE delivery_id = p_delivery_id;
12803: --
12804: l_dlvy_rec dlvy_csr%ROWTYPE;
12805: --

Line 13274: wsh_new_deliveries d1, wsh_new_deliveries d2,

13270:
13271: cursor c_get_trip_info(p_del_id in number) is
13272: select s.trip_id, d2.delivery_id
13273: from wsh_delivery_legs l1, wsh_delivery_legs l2,
13274: wsh_new_deliveries d1, wsh_new_deliveries d2,
13275: wsh_trip_stops s
13276: where l1.delivery_id = p_del_id
13277: and l1.delivery_id = d1.delivery_id -- bug 4891897
13278: and s.stop_id = l1.pick_up_stop_id

Line 13309: l_del_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

13305: WHERE s.stop_id = l.pick_up_stop_id
13306: AND l.delivery_id = p_delivery_id;
13307:
13308: l_assign_flag VARCHAR2(1);
13309: l_del_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
13310: l_parent_del_info_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
13311: l_del_asg_info_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_TYPE;
13312: l_child_details_tab wsh_util_core.id_tab_type;
13313: l_dummy_asg_tab wsh_util_core.id_tab_type;

Line 13310: l_parent_del_info_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

13306: AND l.delivery_id = p_delivery_id;
13307:
13308: l_assign_flag VARCHAR2(1);
13309: l_del_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
13310: l_parent_del_info_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
13311: l_del_asg_info_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_TYPE;
13312: l_child_details_tab wsh_util_core.id_tab_type;
13313: l_dummy_asg_tab wsh_util_core.id_tab_type;
13314: l_wv_delivery_tab wsh_util_core.id_tab_type;

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

13508: l_child_delivery_id := l_child_container_info.delivery_id;
13509: END IF;
13510:
13511: IF l_debug_on THEN
13512: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.Populate_Record',WSH_DEBUG_SV.C_PROC_LEVEL);
13513: END IF;
13514: WSH_NEW_DELIVERIES_PVT.Populate_Record(
13515: p_delivery_id => l_child_delivery_id,
13516: x_delivery_info => l_del_info_tab(i),

Line 13514: WSH_NEW_DELIVERIES_PVT.Populate_Record(

13510:
13511: IF l_debug_on THEN
13512: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.Populate_Record',WSH_DEBUG_SV.C_PROC_LEVEL);
13513: END IF;
13514: WSH_NEW_DELIVERIES_PVT.Populate_Record(
13515: p_delivery_id => l_child_delivery_id,
13516: x_delivery_info => l_del_info_tab(i),
13517: x_return_status => l_return_status);
13518:

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

13609: -- Convert the parent LPN to be a consol LPN.
13610:
13611: -- Get the attributes of the parent delivery
13612: IF l_debug_on THEN
13613: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.Populate_Record',WSH_DEBUG_SV.C_PROC_LEVEL);
13614: END IF;
13615:
13616: WSH_NEW_DELIVERIES_PVT.Populate_Record(
13617: p_delivery_id => l_new_parent_delivery_id,

Line 13616: WSH_NEW_DELIVERIES_PVT.Populate_Record(

13612: IF l_debug_on THEN
13613: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.Populate_Record',WSH_DEBUG_SV.C_PROC_LEVEL);
13614: END IF;
13615:
13616: WSH_NEW_DELIVERIES_PVT.Populate_Record(
13617: p_delivery_id => l_new_parent_delivery_id,
13618: x_delivery_info => l_parent_del_info_rec,
13619: x_return_status => l_return_status);
13620:

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

13828:
13829: FOR i in 1..l_del_tab.count LOOP
13830:
13831: IF l_debug_on THEN
13832: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.Populate_Record',WSH_DEBUG_SV.C_PROC_LEVEL);
13833: END IF;
13834: WSH_NEW_DELIVERIES_PVT.Populate_Record(
13835: p_delivery_id => l_del_tab(i),
13836: x_delivery_info => l_del_info_tab(i),

Line 13834: WSH_NEW_DELIVERIES_PVT.Populate_Record(

13830:
13831: IF l_debug_on THEN
13832: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.Populate_Record',WSH_DEBUG_SV.C_PROC_LEVEL);
13833: END IF;
13834: WSH_NEW_DELIVERIES_PVT.Populate_Record(
13835: p_delivery_id => l_del_tab(i),
13836: x_delivery_info => l_del_info_tab(i),
13837: x_return_status => l_return_status);
13838:

Line 14107: wsh_new_deliveries wnd

14103: wdd2.volume_uom_code
14104: from wsh_delivery_details wdd1,
14105: wsh_delivery_details wdd2,
14106: wsh_delivery_assignments wda,
14107: wsh_new_deliveries wnd
14108: where wdd1.delivery_detail_id = p_dd_id
14109: and wda.delivery_detail_id = wdd1.delivery_detail_id
14110: and wda.type = 'C'
14111: and wda.delivery_id = wnd.delivery_id