CREATE OR REPLACE PROCEDURE T(in_emp_id number
)  IS 
o_return_cdenbr;
BEGIN
INS_EMP_DATA(in_emp_id,o_return_cde);
EXCEPTION
WHEN OTHERS THEN
UPDATE ERROR_T SET CNTR=-1 WHERE ID=IN_ID;
END;

SQL> 
SQL> create table test
  2  (
  3  ctr number
  4  );

Table created.
SQL> insert into test values (1);

1 row created.

SQL> commit;

Commit complete.
ed
Wrote file afiedt.buf

  1  CREATE OR REPLACE PROCEDURE test_p_del(in_emp_id number
  2  )  IS
  3  BEGIN
  4  RAISE NO_DATA_FOUND;
  5  EXCEPTION
  6  WHEN OTHERS THEN
  7  UPDATE TEST SET CTR=-1;
  8* END;
SQL> /

Procedure created.

SQL> begin
  2  test_p_del(1);
  3  end;
  4  /

PL/SQL procedure successfully completed.

SQL> select * from test;

       CTR
----------
        -1