[Home] [Help]
2687: hr_utility.set_location ('process rollup ' || p_run_rollup_only, 10);
2688: --
2689: if p_online_call_flag = 'N' then
2690: --
2691: fnd_file.put_line(which => fnd_file.log,
2692: buff => 'GLOBAL COMPENSATION PROCESS - SUMMARY lOG');
2693: fnd_file.put_line(which => fnd_file.log,
2694: buff => '------------------------------------------');
2695: --
2689: if p_online_call_flag = 'N' then
2690: --
2691: fnd_file.put_line(which => fnd_file.log,
2692: buff => 'GLOBAL COMPENSATION PROCESS - SUMMARY lOG');
2693: fnd_file.put_line(which => fnd_file.log,
2694: buff => '------------------------------------------');
2695: --
2696: end if;
2697: --
2782: ben_manage_cwb_life_events.g_num_cwb_processes + 1;
2783: ben_manage_cwb_life_events.g_cwb_processes_rec(g_num_cwb_processes) := l_request_id;
2784: --
2785: --
2786: fnd_file.put_line(which => fnd_file.log,
2787: buff => 'Submitted the concurrent request id '||l_request_id||
2788: ' for the plan :'||substr(l_count.name,1,100) );
2789: --
2790: else
2966: if g_cache_group_plan_rec.group_ler_id is not null then
2967: --
2968: --Populate Missing Group Plan Information
2969: --
2970: fnd_file.put_line(which => fnd_file.log,
2971: buff => 'Started : Populating group plan data, ' || to_char(sysdate,'dd-mm-yyyy hh24:mi:ss'));
2972: hr_utility.set_location('global_process - before call to cwb_group_pil', 1234);
2973: if l_use_eff_dt_flag = 'N' then
2974: --
3018: ,p_effective_date => l_effective_date
3019: );
3020: end if;
3021: --
3022: fnd_file.put_line(which => fnd_file.log,
3023: buff => 'Completed : Populating group plan data, ' || to_char(sysdate,'dd-mm-yyyy hh24:mi:ss'));
3024: --
3025: --Populate Group Hierarchy table data
3026: --
3032: ,p_group_lf_evt_ocrd_dt => g_cache_group_plan_rec.group_lf_evt_ocrd_dt
3033: ,p_group_business_group_id => g_cache_group_plan_rec.group_business_group_id
3034: ,p_group_ler_id => g_cache_group_plan_rec.group_ler_id ) ;
3035: --
3036: fnd_file.put_line(which => fnd_file.log,
3037: -- buff => 'Completed : Populating heirarchy data, ' || to_char(sysdate,'dd-mm-yyyy hh24:mi:ss'));
3038: buff => 'Completed : Populating hierarchy data, ' || to_char(sysdate,'dd-mm-yyyy hh24:mi:ss'));
3039: -- changed for bug: 5134561
3040: --
3107: BEN_CWB_SUMMARY_PKG.refresh_summary_persons(
3108: p_group_pl_id => g_cache_group_plan_rec.group_pl_id
3109: ,p_lf_evt_ocrd_dt => g_cache_group_plan_rec.group_lf_evt_ocrd_dt);
3110: --
3111: fnd_file.put_line(which => fnd_file.log,
3112: -- buff => 'Completed : Populating heirarchy data, ' || to_char(sysdate,'dd-mm-yyyy hh24:mi:ss'));
3113: buff => 'Completed : Populating hierarchy data, ' || to_char(sysdate,'dd-mm-yyyy hh24:mi:ss'));
3114: -- changed for bug: 5134561
3115: --
3126: begin
3127: l_hrchy_counter := nvl(g_hrchy_tbl.LAST, 0);
3128: if l_hrchy_counter > 0 then
3129: --
3130: fnd_file.put_line(which => fnd_file.log,
3131: buff => 'A recursive relationship was detected in the manager hierarchy. '||
3132: 'You can correct the hierarchy data by updating the worksheet manager '||
3133: 'on the employee administration page for each person ID listed. '||
3134: 'You should also fix the problem at its HR source and refresh the '||
3142: */
3143: l_loop_counter := least(l_hrchy_counter, 100);
3144: if l_hrchy_counter > 100 then
3145: --
3146: fnd_file.put_line(which => fnd_file.log,
3147: buff => 'Also query the ben_trasactions table to see complete list.');
3148: --
3149: for i in 1..l_hrchy_counter loop
3150:
3161: end loop;
3162: end if;
3163: --
3164: for i in 1..l_loop_counter loop
3165: fnd_file.put_line(which => fnd_file.log,
3166: buff => ' ' ||g_hrchy_tbl(i).hrchy_cat_string);
3167: end loop;
3168: --
3169: end if;
3167: end loop;
3168: --
3169: end if;
3170: exception when others then
3171: fnd_file.put_line(which => fnd_file.log,
3172: buff =>'A recursive relationship was detected in the manager hierarchy. '||
3173: 'You can correct the hierarchy data by updating the worksheet manager '||
3174: 'on the employee administration page for each person ID listed. '||
3175: 'You should also fix the problem at its HR source and refresh the '||
3192: --
3193: if nvl(ben_manage_cwb_life_events.g_num_cwb_processes, 0) <> 0
3194: then
3195: --
3196: fnd_file.put_line(which => fnd_file.log,
3197: buff => 'An error occurred in the rollup routine. After fixing the ' ||
3198: 'errors, please submit the process again with Run Rollup processes ' ||
3199: 'only set to Yes.'
3200: );
3261: -- Write into log only if not a online process.
3262: -- Bug 4636102. The fnd_message.get was killing
3263: -- the error even for online mode.
3264: --
3265: fnd_file.put_line(which => fnd_file.log,
3266: buff => 'Error occured after calling: ' ||
3267: g_error_log_rec.calling_proc);
3268: fnd_file.put_line(which => fnd_file.log,
3269: buff => ' Step Number: ' ||
3264: --
3265: fnd_file.put_line(which => fnd_file.log,
3266: buff => 'Error occured after calling: ' ||
3267: g_error_log_rec.calling_proc);
3268: fnd_file.put_line(which => fnd_file.log,
3269: buff => ' Step Number: ' ||
3270: to_number(g_error_log_rec.step_number));
3271: fnd_file.put_line(which => fnd_file.log,
3272: buff => ' Error : ' ||
3267: g_error_log_rec.calling_proc);
3268: fnd_file.put_line(which => fnd_file.log,
3269: buff => ' Step Number: ' ||
3270: to_number(g_error_log_rec.step_number));
3271: fnd_file.put_line(which => fnd_file.log,
3272: buff => ' Error : ' ||
3273: nvl(fnd_message.get,sqlerrm));
3274: end if;
3275: --