Conformal deformation of warped products and scalar curvature functions on open manifolds