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_PICK_LIST dependencies on WSH_USA_INV_PVT

Line 3660: l_backorder_rec_tbl WSH_USA_INV_PVT.Back_Det_Rec_Tbl;

3656: AND wdd.released_status = 'B'
3657: AND wdd.replenishment_status IS NULL -- replenishment2, select only back order delivery lines.
3658: AND wda.delivery_id = wnd.delivery_id(+);
3659:
3660: l_backorder_rec_tbl WSH_USA_INV_PVT.Back_Det_Rec_Tbl;
3661:
3662: CURSOR c_batch_orgs(l_batch_id NUMBER) IS
3663: SELECT organization_id
3664: FROM wsh_pr_workers

Line 4895: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT.Unassign_Backordered_Details',WSH_DEBUG_SV.C_PROC_LEVEL);

4891: l_detail_cfetch := c_get_backordered_details%ROWCOUNT - l_detail_pfetch;
4892: EXIT WHEN (l_detail_cfetch = 0);
4893: IF l_debug_on THEN
4894: WSH_DEBUG_SV.log(l_module_name,'Number of backordered lines ',l_backorder_rec_tbl.COUNT);
4895: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT.Unassign_Backordered_Details',WSH_DEBUG_SV.C_PROC_LEVEL);
4896: END IF;
4897: WSH_USA_INV_PVT.Unassign_Backordered_Details(
4898: p_backorder_rec_tbl => l_backorder_rec_tbl,
4899: p_org_info_tbl => l_org_info_tbl,

Line 4897: WSH_USA_INV_PVT.Unassign_Backordered_Details(

4893: IF l_debug_on THEN
4894: WSH_DEBUG_SV.log(l_module_name,'Number of backordered lines ',l_backorder_rec_tbl.COUNT);
4895: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT.Unassign_Backordered_Details',WSH_DEBUG_SV.C_PROC_LEVEL);
4896: END IF;
4897: WSH_USA_INV_PVT.Unassign_Backordered_Details(
4898: p_backorder_rec_tbl => l_backorder_rec_tbl,
4899: p_org_info_tbl => l_org_info_tbl,
4900: x_return_status => l_return_status);
4901: IF l_debug_on THEN

Line 4902: WSH_DEBUG_SV.log(l_module_name,'WSH_USA_INV_PVT.Unassign_Backordered_Details l_return_status' ,l_return_status);

4898: p_backorder_rec_tbl => l_backorder_rec_tbl,
4899: p_org_info_tbl => l_org_info_tbl,
4900: x_return_status => l_return_status);
4901: IF l_debug_on THEN
4902: WSH_DEBUG_SV.log(l_module_name,'WSH_USA_INV_PVT.Unassign_Backordered_Details l_return_status' ,l_return_status);
4903: END IF;
4904: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
4905: WSH_UTIL_CORE.PrintMsg('Unexpected Error occurred in WSH_USA_INV_PVT.Unassign_Backordered_Details');
4906: RAISE e_return;

Line 4905: WSH_UTIL_CORE.PrintMsg('Unexpected Error occurred in WSH_USA_INV_PVT.Unassign_Backordered_Details');

4901: IF l_debug_on THEN
4902: WSH_DEBUG_SV.log(l_module_name,'WSH_USA_INV_PVT.Unassign_Backordered_Details l_return_status' ,l_return_status);
4903: END IF;
4904: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
4905: WSH_UTIL_CORE.PrintMsg('Unexpected Error occurred in WSH_USA_INV_PVT.Unassign_Backordered_Details');
4906: RAISE e_return;
4907: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
4908: l_errors := l_errors + 1;
4909: END IF;

Line 4922: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_USA_INV_PVT.Unassign_Backordered_Details');

4918: CLOSE c_get_backordered_details;
4919:
4920: -- If there are any Errors encountered, stop processing immediately
4921: IF l_errors > 0 THEN
4922: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_USA_INV_PVT.Unassign_Backordered_Details');
4923: RAISE e_return;
4924: END IF;
4925: END IF; --}
4926: