In season mode, the CPU will accept all your trades (at least in rookie mode). You can trade players that you do not use a lot for other players on other teams that are very good. For example it is possible to trade Marcus Thames to the Diamondbacks for Randy Johnson.