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.

[Home] [Help]

APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_NEW_DELIVERIES_PVT

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