[Home] [Help]
1205:
1206: BEGIN
1207: hr_utility.set_location('Entering:'||l_proc, 10);
1208:
1209: per_cagr_utility_pkg.put_log('Identified entitlement line records, calling benmngle at: '||fnd_date.date_to_canonical(sysdate));
1210: per_cagr_utility_pkg.put_log(' p_person_id: '|| to_char(p_person_id));
1211: per_cagr_utility_pkg.put_log(' p_effective_date: '|| to_char(p_effective_date,'DD-MON-YYYY'));
1212: per_cagr_utility_pkg.put_log(' p_mode: '||l_mode);
1213: per_cagr_utility_pkg.put_log(' p_derivable_factors: '||l_derivable_factors_flag);
1220: ben_manage_life_events.internal_process
1221: (errbuf => l_errbuf,
1222: retcode => l_retcode,
1223: p_benefit_action_id => l_benefit_action_id,
1224: p_effective_date => fnd_date.date_to_canonical(p_effective_date),
1225: p_mode => l_mode,
1226: p_derivable_factors => l_derivable_factors_flag,
1227: p_validate => l_validate_flag,
1228: p_person_id => p_person_id,
1235:
1236: Commit;
1237:
1238: per_cagr_utility_pkg.put_log('Completed benmngle at: '||
1239: fnd_date.date_to_canonical(sysdate)||' return code is :'||to_char(l_retcode));
1240: per_cagr_utility_pkg.put_log('benefit_action_id: '|| to_char(l_benefit_action_id));
1241: p_benefit_action_id := l_benefit_action_id;
1242:
1243: hr_utility.set_location('Leaving:'||l_proc, 30);
1631: end loop;
1632: do_num_beneficial(l_dyn_csr_table,p_ben_rule,l_ben_row);
1633: elsif p_results_table(1).column_type = 'DATE' then
1634: for i in p_results_table.first..p_results_table.last loop
1635: l_dyn_csr_table(i).date_col := trunc(fnd_date.canonical_to_date(p_results_table(i).value));
1636: end loop;
1637: do_date_beneficial(l_dyn_csr_table,p_ben_rule,l_ben_row);
1638: end if;
1639: EXCEPTION
2367: BEGIN
2368:
2369: hr_utility.set_location('Entering:'||l_proc, 5);
2370: per_cagr_utility_pkg.put_log(g_separator,1);
2371: per_cagr_utility_pkg.put_log('Starting Evaluation Process ('||fnd_date.date_to_canonical(sysdate)||')',1);
2372: --
2373: -- choose which cursor to open,
2374: -- depending upon operation mode
2375: --
3113: ,p_denormalise_flag => p_params.denormalise_flag
3114: ,p_cagr_request_id => p_params.cagr_request_id);
3115: -- output log header
3116: per_cagr_utility_pkg.put_log(g_head_separator,1);
3117: per_cagr_utility_pkg.put_log('----------- Collective Agreement Process Log ('||fnd_date.date_to_canonical(sysdate)||') -----------',1);
3118: per_cagr_utility_pkg.put_log(g_head_separator,1);
3119: per_cagr_utility_pkg.put_log(' ',1);
3120: per_cagr_utility_pkg.put_log(' Evaluating Assignment '|| t_assignments_table(k).assignment_id ||
3121: ' during Single Collective Agreement mode.',1);
3779: null;
3780: end if;
3781:
3782: per_cagr_utility_pkg.put_log(' ',1);
3783: per_cagr_utility_pkg.put_log('Completed Evaluation Process ('||fnd_date.date_to_canonical(sysdate)||')',1);
3784: per_cagr_utility_pkg.put_log(' ',1);
3785: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
3786: hr_utility.set_location('Leaving:'||l_proc, 100);
3787:
3841: --
3842: -- Output log header
3843: --
3844: per_cagr_utility_pkg.put_log(g_head_separator,1);
3845: per_cagr_utility_pkg.put_log('----------- Collective Agreement Process Log ('||fnd_date.date_to_canonical(sysdate)||') -----------',1);
3846: --
3847: -- Ensure that all the mandatory arguments are not null
3848: --
3849: hr_api.mandatory_arg_error(p_api_name => l_proc