SQL & PL/SQL :: Maintaining Log Table

The below procedure is scheduled using DBMS_JOB.

I want to maintain log table for the actions performed by this procedure and as well as the job information.

CREATE OR REPLACE PROCEDURE load_proc (P_ID IN NUMBER)
IS
CURSOR C
IS
SELECT GROUP_ID, tablename, target_table
FROM temp_table
WHERE GROUP_ID = p_id;

[Code]..

I want to capture the below information in the log table.

SNO RECORDS_INSERTED RECORDS_DELETED JOBID JOB_START_TIME JOB_END_TIME JOB_LAST_RAN_ON JOB_STATUS
1 2000 records inserted into 2000 records deleted from 1 20/01/2013 00:00:00 20/01/2013 02:30:00 20/01/2013 02:30:00 completed successfully
table WEDB_EMPLOYEE table WEDB_EMPLOYEE
2 1 21/01/2013 00:00:00 21/01/2013 01:00:00 Failed: error message
3 1 NULL

If the job is not started on the particular day NULL value has to be inserted in the JOB_LAST_RAN_ON column.

If the job is not failed in the middle on a particular day FAILED: ERROR MESSAGE value has to be inserted in the JOB_STATUS column.

Script for log table creation.

CREATE TABLE log_load_proc
(sno NUMBER,
records_inserted VARCHAR2(4000),
records_deleted VARCHAR2(4000),
jobid NUMBER,

[Code]....