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 3748: l_backorder_rec_tbl WSH_USA_INV_PVT.Back_Det_Rec_Tbl;

3744: AND wdd.released_status = 'B'
3745: AND wdd.replenishment_status IS NULL -- replenishment2, select only back order delivery lines.
3746: AND wda.delivery_id = wnd.delivery_id(+);
3747:
3748: l_backorder_rec_tbl WSH_USA_INV_PVT.Back_Det_Rec_Tbl;
3749:
3750: CURSOR c_batch_orgs(l_batch_id NUMBER) IS
3751: SELECT organization_id
3752: FROM wsh_pr_workers

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

4986: l_detail_cfetch := c_get_backordered_details%ROWCOUNT - l_detail_pfetch;
4987: EXIT WHEN (l_detail_cfetch = 0);
4988: IF l_debug_on THEN
4989: WSH_DEBUG_SV.log(l_module_name,'Number of backordered lines ',l_backorder_rec_tbl.COUNT);
4990: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT.Unassign_Backordered_Details',WSH_DEBUG_SV.C_PROC_LEVEL);
4991: END IF;
4992: WSH_USA_INV_PVT.Unassign_Backordered_Details(
4993: p_backorder_rec_tbl => l_backorder_rec_tbl,
4994: p_org_info_tbl => l_org_info_tbl,

Line 4992: WSH_USA_INV_PVT.Unassign_Backordered_Details(

4988: IF l_debug_on THEN
4989: WSH_DEBUG_SV.log(l_module_name,'Number of backordered lines ',l_backorder_rec_tbl.COUNT);
4990: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT.Unassign_Backordered_Details',WSH_DEBUG_SV.C_PROC_LEVEL);
4991: END IF;
4992: WSH_USA_INV_PVT.Unassign_Backordered_Details(
4993: p_backorder_rec_tbl => l_backorder_rec_tbl,
4994: p_org_info_tbl => l_org_info_tbl,
4995: x_return_status => l_return_status);
4996: IF l_debug_on THEN

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

4993: p_backorder_rec_tbl => l_backorder_rec_tbl,
4994: p_org_info_tbl => l_org_info_tbl,
4995: x_return_status => l_return_status);
4996: IF l_debug_on THEN
4997: WSH_DEBUG_SV.log(l_module_name,'WSH_USA_INV_PVT.Unassign_Backordered_Details l_return_status' ,l_return_status);
4998: END IF;
4999: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
5000: WSH_UTIL_CORE.PrintMsg('Unexpected Error occurred in WSH_USA_INV_PVT.Unassign_Backordered_Details');
5001: RAISE e_return;

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

4996: IF l_debug_on THEN
4997: WSH_DEBUG_SV.log(l_module_name,'WSH_USA_INV_PVT.Unassign_Backordered_Details l_return_status' ,l_return_status);
4998: END IF;
4999: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
5000: WSH_UTIL_CORE.PrintMsg('Unexpected Error occurred in WSH_USA_INV_PVT.Unassign_Backordered_Details');
5001: RAISE e_return;
5002: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
5003: l_errors := l_errors + 1;
5004: END IF;

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

5013: CLOSE c_get_backordered_details;
5014:
5015: -- If there are any Errors encountered, stop processing immediately
5016: IF l_errors > 0 THEN
5017: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_USA_INV_PVT.Unassign_Backordered_Details');
5018: RAISE e_return;
5019: END IF;
5020: END IF; --}
5021: