Characterization of modules of finite projective dimension via Frobenius functors