[Home] [Help]
430: --- the warning will be later converted to erro because
431: --- if error the range the subseqent range may not be executed , every time spawn the thread
432: --- the process validated for the errored thread so we set the range status to 'W'
433:
434: update ben_batch_ranges set range_status_cd = 'W'
435: where range_id = p_range_id and range_status_cd = 'P';
436:
437: l_err_message := ben_ext_fmt.get_error_msg(ben_Ext_person.g_err_num,
438: ben_Ext_person.g_err_name,ben_Ext_person.g_elmt_name ) ;
454: --- the warning will be later converted to erro because
455: --- if error the range the subseqent range may not be executed , every time spawn the thread
456: --- the process validated for the errored thread so we set the range status to 'W'
457:
458: update ben_batch_ranges set range_status_cd = 'W'
459: where range_id = p_range_id and range_status_cd = 'P';
460: if nvl(ben_ext_person.g_err_num,-1) <> 94102 then
461: l_err_message := substr(sqlerrm,1,2000) ;
462: if g_debug then
518: EXCEPTION
519: --
520: WHEN g_max_err_num_exception THEN
521: --
522: update ben_batch_ranges set range_status_cd = 'E'
523: where range_id = p_range_id;
524: --
525: commit;
526: --