Performance issue in Scheduler JOb

Hi There, 

   Database Version : 11.2.0.2

   OS : windows 2008 R2

   We have one Scheduler JOb that runs nightly and executes on an average of 20 mins. This jobs runs a series of procedures and each procedure has a massive INSERT statement. This INSERT statement fetches the data from a remote database (hosted in the same server with the database where the job runs). We never had seen any issue till yesterday where is started over running. This job never completed even after 5 Hrs. When checking the event in V$SESSION, I am seeing "SQL*NET MESSGAE FROM DBLINK"

   I tried to run the SQL statement(the SELECT part of the INSERT) and the SQL never triggered fetching the rows. These procedures are working fine for us for a longer time. Below is the query and the respective EP.