[Home] [Help]
225: --
226: EXCEPTION
227: --
228: When ben_batch_utils.g_record_error then
229: hr_utility.set_location(l_package ,10);
230: if g_audit_flag = true then
231: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
232: fnd_message.set_token('ID' ,to_char(p_person_id) );
233: fnd_message.set_token('PROC',l_package ) ;
235: ' Reason : '|| fnd_message.get ||' >>' );
236: end if;
237: RETURN FALSE;
238: When value_exception then
239: hr_utility.set_location(l_package ,20);
240: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
241: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);
242: fnd_message.set_token('PROC',l_package ) ;
243: Ben_batch_utils.write(p_text => '<< Person id : '||to_char(p_person_id)||' failed.'||
243: Ben_batch_utils.write(p_text => '<< Person id : '||to_char(p_person_id)||' failed.'||
244: ' Reason : '|| fnd_message.get ||' >>' );
245: RETURN FALSE;
246: WHEN OTHERS THEN
247: hr_utility.set_location(l_package ,30);
248: Ben_batch_utils.write(p_text => '<< Person id : '||to_char(p_person_id)||' failed.'||
249: ' Reason : '|| SQLERRM ||' >>' );
250: RETURN FALSE;
251: --
348:
349: -- Check for temporal mode
350: -- When running in temporal mode we can exclude contacts without PTUs
351: -- The assumption is that only contacts exist without PTUs
352: hr_utility.set_location('Entering create_normal_person_actions ',19);
353: hr_utility.set_location(' p_effective_date '||p_effective_date, 19);
354: --
355: IF p_mode_cd = 'T'
356: and p_person_selection_rule_id is null
349: -- Check for temporal mode
350: -- When running in temporal mode we can exclude contacts without PTUs
351: -- The assumption is that only contacts exist without PTUs
352: hr_utility.set_location('Entering create_normal_person_actions ',19);
353: hr_utility.set_location(' p_effective_date '||p_effective_date, 19);
354: --
355: IF p_mode_cd = 'T'
356: and p_person_selection_rule_id is null
357: THEN
414: -- Bug 2248822 Restrict the persons to only Employees and Ex-employees
415: -- for the CWB Process.
416: IF p_mode_cd = 'W' THEN
417: --
418: hr_utility.set_location(' p_cwb_person_type '||p_cwb_person_type, 19);
419: fnd_file.put_line(fnd_file.log, p_cwb_person_type );
420: if nvl(p_cwb_person_type,'AEXE') = 'AEXE'
421: then
422: l_cwb_whclause := ' and exists ( select ''x'' from per_person_type_usages_f ptu, '||
461: || ' and :effective_date between asgn.effective_start_date '
462: || ' and asgn.effective_end_date '
463: || ' and :l_wth_start_date is null )' ;
464: else
465: hr_utility.set_location(' p_popl_enrt_typ_cycl_id '|| p_popl_enrt_typ_cycl_id, 19);
466: hr_utility.set_location(' p_lf_evt_ocrd_dt '|| p_lf_evt_ocrd_dt, 19);
467: --
468: fnd_file.put_line(fnd_file.log, p_popl_enrt_typ_cycl_id );
469: fnd_file.put_line(fnd_file.log, p_lf_evt_ocrd_dt );
462: || ' and asgn.effective_end_date '
463: || ' and :l_wth_start_date is null )' ;
464: else
465: hr_utility.set_location(' p_popl_enrt_typ_cycl_id '|| p_popl_enrt_typ_cycl_id, 19);
466: hr_utility.set_location(' p_lf_evt_ocrd_dt '|| p_lf_evt_ocrd_dt, 19);
467: --
468: fnd_file.put_line(fnd_file.log, p_popl_enrt_typ_cycl_id );
469: fnd_file.put_line(fnd_file.log, p_lf_evt_ocrd_dt );
470:
474: open c_cwb_asg_date_chk;
475: fetch c_cwb_asg_date_chk into l_wth_start_date, l_wth_end_date ;
476: close c_cwb_asg_date_chk;
477: --
478: hr_utility.set_location(' l_wth_start_date '|| l_wth_start_date, 19);
479: fnd_file.put_line(fnd_file.log, l_wth_start_date );
480: --
481: if l_wth_start_date is not null
482: then
522: -- bug 3537113
523: --
524: l_query_str := l_query_str||l_cwb_whclause ;
525: --
526: hr_utility.set_location('Building cwb where clause ',29);
527: --
528: ELSE -- if p_mode_cd <> 'W' then
529: --
530: -- Bug 2279394 : where clause is not formed correctly, as and is missing
580: ' and ler.typ_cd =''COMP'' ' ||
581: ' and pil.per_in_ler_stat_cd in(''STRTD''))';
582: end if;
583: */
584: hr_utility.set_location('CWB group pl id'|| ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id ,10);
585:
586: -- end cwbglobal
587:
588:
1363: ' and :effective_date between ptu.effective_start_date '||
1364: ' and ptu.effective_end_date ) ' ;
1365: l_query_str := l_query_str||l_gsp_whclause ;
1366: --
1367: hr_utility.set_location('Building cwb where clause ',29);
1368: --
1369: ELSE
1370: --
1371: -- Bug 2279394 : where clause is not formed correctly, as and is missing
1965:
1966: /* Uncomment the following lines when you debug the dynamic sql
1967: text
1968: for i in 1..60 loop
1969: hr_utility.set_location(substr(l_query_str, 60*i-59, 60), 1234);
1970: if (60*i-59 > length(l_query_str)) then
1971: exit;
1972: end if;
1973: end loop;
2154: l_to_chunk_loop NUMBER := 0;
2155: --
2156: BEGIN
2157: --
2158: -- hr_utility.set_location('Entering '||l_package,10);
2159: --
2160: -- Updating ranges from ben_batch_ranges table
2161: -- Rolling back ranges with erred or partially unfinished person actions
2162: --
2196: -- This is for What IF Functionality
2197: commit;
2198: end if;
2199: --
2200: -- hr_utility.set_location('Leaving '||l_package,10);
2201: --
2202: END create_restart_person_actions;
2203: --
2204: END ben_benbatch_persons;