From ferromagnetic to non-magnetic singlet ground state in CePd1-xNix