[Home] [Help]
1240:
1241: BEGIN
1242: hr_utility.set_location('Entering:'||l_proc, 10);
1243:
1244: per_cagr_utility_pkg.put_log('Identified entitlement line records, calling benmngle at: '||fnd_date.date_to_canonical(sysdate));
1245: per_cagr_utility_pkg.put_log(' p_person_id: '|| to_char(p_person_id));
1246: per_cagr_utility_pkg.put_log(' p_effective_date: '|| to_char(p_effective_date,'DD-MON-YYYY'));
1247: per_cagr_utility_pkg.put_log(' p_mode: '||l_mode);
1248: per_cagr_utility_pkg.put_log(' p_derivable_factors: '||l_derivable_factors_flag);
1255: ben_manage_life_events.internal_process
1256: (errbuf => l_errbuf,
1257: retcode => l_retcode,
1258: p_benefit_action_id => l_benefit_action_id,
1259: p_effective_date => fnd_date.date_to_canonical(p_effective_date),
1260: p_mode => l_mode,
1261: p_derivable_factors => l_derivable_factors_flag,
1262: p_validate => l_validate_flag,
1263: p_person_id => p_person_id,
1270:
1271: Commit;
1272:
1273: per_cagr_utility_pkg.put_log('Completed benmngle at: '||
1274: fnd_date.date_to_canonical(sysdate)||' return code is :'||to_char(l_retcode));
1275: per_cagr_utility_pkg.put_log('benefit_action_id: '|| to_char(l_benefit_action_id));
1276: p_benefit_action_id := l_benefit_action_id;
1277:
1278: hr_utility.set_location('Leaving:'||l_proc, 30);
1703: end loop;
1704: do_num_beneficial(l_dyn_csr_table,p_ben_rule,l_ben_row);
1705: elsif p_results_table(1).column_type = 'DATE' then
1706: for i in p_results_table.first..p_results_table.last loop
1707: l_dyn_csr_table(i).date_col := trunc(fnd_date.canonical_to_date(p_results_table(i).value));
1708: end loop;
1709: do_date_beneficial(l_dyn_csr_table,p_ben_rule,l_ben_row);
1710: end if;
1711: EXCEPTION
2439: BEGIN
2440:
2441: hr_utility.set_location('Entering:'||l_proc, 5);
2442: per_cagr_utility_pkg.put_log(g_separator,1);
2443: per_cagr_utility_pkg.put_log('Starting Evaluation Process ('||fnd_date.date_to_canonical(sysdate)||')',1);
2444: --
2445: -- choose which cursor to open,
2446: -- depending upon operation mode
2447: --
3186: ,p_denormalise_flag => p_params.denormalise_flag
3187: ,p_cagr_request_id => p_params.cagr_request_id);
3188: -- output log header
3189: per_cagr_utility_pkg.put_log(g_head_separator,1);
3190: per_cagr_utility_pkg.put_log('----------- Collective Agreement Process Log ('||fnd_date.date_to_canonical(sysdate)||') -----------',1);
3191: per_cagr_utility_pkg.put_log(g_head_separator,1);
3192: per_cagr_utility_pkg.put_log(' ',1);
3193: per_cagr_utility_pkg.put_log(' Evaluating Assignment '|| t_assignments_table(k).assignment_id ||
3194: ' during Single Collective Agreement mode.',1);
3852: null;
3853: end if;
3854:
3855: per_cagr_utility_pkg.put_log(' ',1);
3856: per_cagr_utility_pkg.put_log('Completed Evaluation Process ('||fnd_date.date_to_canonical(sysdate)||')',1);
3857: per_cagr_utility_pkg.put_log(' ',1);
3858: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
3859: hr_utility.set_location('Leaving:'||l_proc, 100);
3860:
3914: --
3915: -- Output log header
3916: --
3917: per_cagr_utility_pkg.put_log(g_head_separator,1);
3918: per_cagr_utility_pkg.put_log('----------- Collective Agreement Process Log ('||fnd_date.date_to_canonical(sysdate)||') -----------',1);
3919: --
3920: -- Ensure that all the mandatory arguments are not null
3921: --
3922: hr_api.mandatory_arg_error(p_api_name => l_proc