Naturally vanishing cosmological constant in N=1 supergravity