Oracle data pump export / import errors
After hours of trying numerous things I've found this as to answer my question. On a tip of an Oracle Community discussion, I was told to run this below. 

select comp_id, version, status, comp_name
from dba_registry
where comp_id='SDO';


This would tell me if I am or not running Oracle Spatial on my existing database that I ran the export from. Now, why I bring this up is I've asked numerous people in my organization if we're using spatial and numerous people have swore up and down we don't. Come to find out, the database is installed with spatial and that above sql script showed me that yes, it is running spatial. 

RDS won't accept spatial data, even if there is no spatial data in it. So I'm in the process of installing an EC2 instance with 11gR2 and actually importing the data that way. This is why the stored procedures failed as above. I just don't know why our AWS team didn't catch this when I submitted my trouble ticket. Oh well. 

Thanks for all of the help.