The condition is hidden in the statement that a curve that parallel transports its own tangent vector must satisfy
$$\frac{D}{d\lambda} \frac{dx^\mu}{d\lambda} = 0. \tag{1}$$
See, the issue is that this equation (which is just the usual geodesic equation) is not reparametrization invariant. If you use a new parameter $\mu = g(\lambda)$, you will in general find that
$$\frac{D}{d\mu} \frac{dx^\mu}{d\mu} \neq 0$$
unless $g$ is an affine function (hence the name affine parameter).
There are two possible paths we can take here, and both are used in the literature. One is to declare that $(1)$ is the only geodesic equation; that is, a curve $x^\mu(\lambda)$ is a geodesic if and only if it satisfies $(1)$. This means that your definition of geodesic depends on the parameter: the same geometric curve (as in, 1-dimensional subspace) could simultaneously be a geodesic and fail to be one, depending on how you choose to parametrize it. In many situations, it's useful to make sure your geodesics are affinely parametrized.
The other option is to require the condition of geodesic to be reparametrization invariant. We do that by recognizing that in the definition of parallel transport we don't strictly need the acceleration (the left hand side of $(1)$) to be zero; we just need it to point in the same direction as the velocity. This leads us to a "generalized" geodesic equation
$$\frac{D}{d\lambda} \frac{dx^\mu}{d\lambda} = f(\lambda) \frac{dx^\mu}{d\lambda}, \tag{2}$$
where $f$ is an arbitrary function. This equation is reparametrization invariant; changing the parameter just changes $f$. If you try to solve it for a given metric you will get an undetermined function in the solution; this function represents your freedom to choose the parameter however you want. It can be shown that the parameters that make $f=0$ are affine rescalings of proper time (or arclength in general); but note that proper time has no meaning for null curves, so having $f=0$ (that is, satisfying equation $(1)$) is the only definition of affine parameter for them.
This second equation is what you get if you work with the definition that a geodesic is an extremum of length and allow any parameter; as such, it's a bit more intuitive geometrically, if you will, but actually working with it can get a bit gnarly, which is why we almost always use affine parameters and equation $(1)$ as our geodesic equation. This is also why Carroll explicitly chooses proper time as a parameter when deriving the "shortest length" geodesic equation, which also explains why $f$ is nowhere to be found in his book.