No, there is no limit to the size of individual transactions except that they must be confirmable. For a package to be considered it must be independently confirmable as well (see comments in bitcoin-dev post). There is an inherent rough patch there at the limit, due the the variable nature of coinbases, which could be exploited if misconfigured, but that's really only an issue for miners, who have the coinbase under their control.