[Home] [Help]
2732: hr_utility.set_location ('process rollup ' || p_run_rollup_only, 10);
2733: --
2734: if p_online_call_flag = 'N' then
2735: --
2736: fnd_file.put_line(which => fnd_file.log,
2737: buff => 'GLOBAL COMPENSATION PROCESS - SUMMARY lOG');
2738: fnd_file.put_line(which => fnd_file.log,
2739: buff => '------------------------------------------');
2740: --
2734: if p_online_call_flag = 'N' then
2735: --
2736: fnd_file.put_line(which => fnd_file.log,
2737: buff => 'GLOBAL COMPENSATION PROCESS - SUMMARY lOG');
2738: fnd_file.put_line(which => fnd_file.log,
2739: buff => '------------------------------------------');
2740: --
2741: end if;
2742: --
2827: ben_manage_cwb_life_events.g_num_cwb_processes + 1;
2828: ben_manage_cwb_life_events.g_cwb_processes_rec(g_num_cwb_processes) := l_request_id;
2829: --
2830: --
2831: fnd_file.put_line(which => fnd_file.log,
2832: buff => 'Submitted the concurrent request id '||l_request_id||
2833: ' for the plan :'||substr(l_count.name,1,100) );
2834: --
2835: else
3011: if g_cache_group_plan_rec.group_ler_id is not null then
3012: --
3013: --Populate Missing Group Plan Information
3014: --
3015: fnd_file.put_line(which => fnd_file.log,
3016: buff => 'Started : Populating group plan data, ' || to_char(sysdate,'dd-mm-yyyy hh24:mi:ss'));
3017: hr_utility.set_location('global_process - before call to cwb_group_pil', 1234);
3018: if l_use_eff_dt_flag = 'N' then
3019: --
3063: ,p_effective_date => l_effective_date
3064: );
3065: end if;
3066: --
3067: fnd_file.put_line(which => fnd_file.log,
3068: buff => 'Completed : Populating group plan data, ' || to_char(sysdate,'dd-mm-yyyy hh24:mi:ss'));
3069: --
3070: --Populate Group Hierarchy table data
3071: --
3084: FND_STATS.GATHER_TABLE_STATS('BEN','BEN_CWB_GROUP_HRCHY');
3085: FND_STATS.GATHER_TABLE_STATS('BEN','BEN_CWB_PERSON_RATES');
3086: FND_STATS.GATHER_TABLE_STATS('BEN','BEN_CWB_PERSON_GROUPS');
3087: -- END changes BUG#13436491
3088: fnd_file.put_line(which => fnd_file.log,
3089: -- buff => 'Completed : Populating heirarchy data, ' || to_char(sysdate,'dd-mm-yyyy hh24:mi:ss'));
3090: buff => 'Completed : Populating hierarchy data, ' || to_char(sysdate,'dd-mm-yyyy hh24:mi:ss'));
3091: -- changed for bug: 5134561
3092: --
3159: BEN_CWB_SUMMARY_PKG.refresh_summary_persons(
3160: p_group_pl_id => g_cache_group_plan_rec.group_pl_id
3161: ,p_lf_evt_ocrd_dt => g_cache_group_plan_rec.group_lf_evt_ocrd_dt);
3162: --
3163: fnd_file.put_line(which => fnd_file.log,
3164: -- buff => 'Completed : Populating heirarchy data, ' || to_char(sysdate,'dd-mm-yyyy hh24:mi:ss'));
3165: buff => 'Completed : Populating hierarchy data, ' || to_char(sysdate,'dd-mm-yyyy hh24:mi:ss'));
3166: -- changed for bug: 5134561
3167: --
3178: begin
3179: l_hrchy_counter := nvl(g_hrchy_tbl.LAST, 0);
3180: if l_hrchy_counter > 0 then
3181: --
3182: fnd_file.put_line(which => fnd_file.log,
3183: buff => 'A recursive relationship was detected in the manager hierarchy. '||
3184: 'You can correct the hierarchy data by updating the worksheet manager '||
3185: 'on the employee administration page for each person ID listed. '||
3186: 'You should also fix the problem at its HR source and refresh the '||
3194: */
3195: l_loop_counter := least(l_hrchy_counter, 100);
3196: if l_hrchy_counter > 100 then
3197: --
3198: fnd_file.put_line(which => fnd_file.log,
3199: buff => 'Also query the ben_trasactions table to see complete list.');
3200: --
3201: for i in 1..l_hrchy_counter loop
3202:
3213: end loop;
3214: end if;
3215: --
3216: for i in 1..l_loop_counter loop
3217: fnd_file.put_line(which => fnd_file.log,
3218: buff => ' ' ||g_hrchy_tbl(i).hrchy_cat_string);
3219: end loop;
3220: --
3221: end if;
3219: end loop;
3220: --
3221: end if;
3222: exception when others then
3223: fnd_file.put_line(which => fnd_file.log,
3224: buff =>'A recursive relationship was detected in the manager hierarchy. '||
3225: 'You can correct the hierarchy data by updating the worksheet manager '||
3226: 'on the employee administration page for each person ID listed. '||
3227: 'You should also fix the problem at its HR source and refresh the '||
3244: --
3245: if nvl(ben_manage_cwb_life_events.g_num_cwb_processes, 0) <> 0
3246: then
3247: --
3248: fnd_file.put_line(which => fnd_file.log,
3249: buff => 'An error occurred in the rollup routine. After fixing the ' ||
3250: 'errors, please submit the process again with Run Rollup processes ' ||
3251: 'only set to Yes.'
3252: );
3313: -- Write into log only if not a online process.
3314: -- Bug 4636102. The fnd_message.get was killing
3315: -- the error even for online mode.
3316: --
3317: fnd_file.put_line(which => fnd_file.log,
3318: buff => 'Error occured after calling: ' ||
3319: g_error_log_rec.calling_proc);
3320: fnd_file.put_line(which => fnd_file.log,
3321: buff => ' Step Number: ' ||
3316: --
3317: fnd_file.put_line(which => fnd_file.log,
3318: buff => 'Error occured after calling: ' ||
3319: g_error_log_rec.calling_proc);
3320: fnd_file.put_line(which => fnd_file.log,
3321: buff => ' Step Number: ' ||
3322: to_number(g_error_log_rec.step_number));
3323: fnd_file.put_line(which => fnd_file.log,
3324: buff => ' Error : ' ||
3319: g_error_log_rec.calling_proc);
3320: fnd_file.put_line(which => fnd_file.log,
3321: buff => ' Step Number: ' ||
3322: to_number(g_error_log_rec.step_number));
3323: fnd_file.put_line(which => fnd_file.log,
3324: buff => ' Error : ' ||
3325: nvl(fnd_message.get,sqlerrm));
3326: end if;
3327: --