Oracle Event Alert-Firing but No action or Exception

 Hi Experts,

   Oracle Event Alert-Firing but No action or Exception

Our Requirement is

1.When Engineering Change(ENG_ENGINEERING_CHANGES) order get implemented,FYI needs go send to some department

2.Now alert is getting trigger and completing normal without any Action or Exception,Pls help me

select 

       eec.CHANGE_NOTICE,        

       eec.ORGANIZATION_ID, 

       org.ORGANIZATION_NAME,

       :MAILID,

       eec.ROWID 

into 

     &CHANGE_NOTICE,          

     &ORGANIZATION_CODE,

     &ORGANIZATION_NAME,

     &MAILID

     &ROW_ID

from 

eng_engineering_changes eec,

org_organization_definitions org

where eec.STATUS_TYPE ='6'

and eec.organization_id = org.organization_id

and trunc(eec.last_update_date) = trunc(sysdate) 

and eec.ROWID=:ROWID;