List of exceptions


Method Summary
 clean_old_logs
          
           It is maintance procedure to delete old data in TRACE_LOG table.
           There is expected in table CONF_PARAM configuration (NAME = 'CLEAN_OLDER_THEN_X_DAYS') with number of days.
           Records in TRACE_LOG older then CLEAN_OLDER_THEN_X_DAYS days will be automaticly delete weekly by job.
           @throws C_ERR_MISSING_MAINTANCE_PAR There is missing configuration of log level in CONF_PARAM table. The should be column NAME = 'CLEAN_OLDER_THEN_X_DAYS' with column VAL with numeric value. Then of VAL should be numeric. Higer then 0.
          
          
 log_trace( p_severity_id in number , p_procedure_name in varchar2 , p_description in varchar2 )
          
           It is initially loading value of global variable g_log_level from CONF_PARAM.
           When configuration is not set correctly the debug level, then it raise exception MISSING_DEBUG_LEVEL.
           According the debug level is apropriate call of log_trace inserted record into TRACE_LOG table.
           @throws C_ERR_MISSING_DEBUG_LEVEL There is missing configuration of log level in CONF_PRAM table. The should be column NAME = 'LOG_LEVEL' with column VAL with numeric value. Then of VAL should be one of the "List of statuses"
          
          

Method Detail

clean_old_logs

          clean_old_logs
          
           It is maintance procedure to delete old data in TRACE_LOG table.
           There is expected in table CONF_PARAM configuration (NAME = 'CLEAN_OLDER_THEN_X_DAYS') with number of days.
           Records in TRACE_LOG older then CLEAN_OLDER_THEN_X_DAYS days will be automaticly delete weekly by job.
           @throws C_ERR_MISSING_MAINTANCE_PAR There is missing configuration of log level in CONF_PARAM table. The should be column NAME = 'CLEAN_OLDER_THEN_X_DAYS' with column VAL with numeric value. Then of VAL should be numeric. Higer then 0.
          
          
Throws:
C_ERR_MISSING_MAINTANCE_PAR - There is missing configuration of log level in CONF_PARAM table. The should be column NAME = 'CLEAN_OLDER_THEN_X_DAYS' with column VAL with numeric value. Then of VAL should be numeric. Higer then 0.

log_trace

          log_trace( p_severity_id in number , p_procedure_name in varchar2 , p_description in varchar2 ) 
          
           It is initially loading value of global variable g_log_level from CONF_PARAM.
           When configuration is not set correctly the debug level, then it raise exception MISSING_DEBUG_LEVEL.
           According the debug level is apropriate call of log_trace inserted record into TRACE_LOG table.
           @throws C_ERR_MISSING_DEBUG_LEVEL There is missing configuration of log level in CONF_PRAM table. The should be column NAME = 'LOG_LEVEL' with column VAL with numeric value. Then of VAL should be one of the "List of statuses"
          
          
Throws:
C_ERR_MISSING_DEBUG_LEVEL - There is missing configuration of log level in CONF_PRAM table. The should be column NAME = 'LOG_LEVEL' with column VAL with numeric value. Then of VAL should be one of the "List of statuses"