Aftorres02
6/4/2018 - 7:23 PM

enable debug apex

 
apex_debug.enable(p_level => 1);
apex_debug.message('...AAAA  PXX_VAL  ' || :PXX_VAL ,p_level =>1);

apex_debug.enable(p_level => g_debug_level);  -- (1 critical, 2 warn, 3 info, 6 trace) 

apex_debug.message('PP120_MES_FIN  ' || :P120_MES_FIN ,p_level =>1);

exception
 when others then
  
apex_debug.message('SQLERRM  ' || SQLERRM 
     || '  ** TRACE **   ' || dbms_utility.format_error_backtrace 
     || ' ** STACK ** ' ||dbms_utility.format_error_stack ,p_level =>1);


/// on plsql code
  apex_debug.message ( 
    p_message => ' l val ' || l_val ,
    p_force => false);