Procedure to show the error "ORA-01403: no data found"

Hello Experts,

Recently, I created the new procedure in ORACLE DB. Then, I plan to execute the procedure in ORACLE EBS R12. The procedure objective as schedule run the program "Journal import". But the error message as follows:

--------------------------------------------------------------------------------------------------

ORA-01403: no data found

ORA-06512: at "PP_AUTO_JOURNAL_IMPORT", line 48

ORA-06512: at line 2

---------------------------------------------------------------------------------------------------

create or replace procedure PP_auto_journal_import as

--declare

p_req_id     number; 

c_req_id     number; 

l_phase     varchar(50);

l_status    varchar(50);

l_dev_phase   varchar(50);

l_dev_status  varchar(50);

l_message    varchar(50);

l_return    boolean;

a_resp_id  number;

a_resp_name varchar(100);