[Home] [Help]
228: --
229: EXCEPTION
230: --
231: When ben_batch_utils.g_record_error then
232: hr_utility.set_location(l_package ,10);
233: if g_audit_flag = true then
234: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
235: fnd_message.set_token('ID' ,to_char(p_person_id) );
236: fnd_message.set_token('PROC',l_package ) ;
238: ' Reason : '|| fnd_message.get ||' >>' );
239: end if;
240: RETURN FALSE;
241: When value_exception then
242: hr_utility.set_location(l_package ,20);
243: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
244: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);
245: fnd_message.set_token('PROC',l_package ) ;
246: Ben_batch_utils.write(p_text => '<< Person id : '||to_char(p_person_id)||' failed.'||
246: Ben_batch_utils.write(p_text => '<< Person id : '||to_char(p_person_id)||' failed.'||
247: ' Reason : '|| fnd_message.get ||' >>' );
248: RETURN FALSE;
249: WHEN OTHERS THEN
250: hr_utility.set_location(l_package ,30);
251: Ben_batch_utils.write(p_text => '<< Person id : '||to_char(p_person_id)||' failed.'||
252: ' Reason : '|| SQLERRM ||' >>' );
253: RETURN FALSE;
254: --
351:
352: -- Check for temporal mode
353: -- When running in temporal mode we can exclude contacts without PTUs
354: -- The assumption is that only contacts exist without PTUs
355: hr_utility.set_location('Entering create_normal_person_actions ',19);
356: hr_utility.set_location(' p_effective_date '||p_effective_date, 19);
357: --
358: IF p_mode_cd = 'T'
359: and p_person_selection_rule_id is null
352: -- Check for temporal mode
353: -- When running in temporal mode we can exclude contacts without PTUs
354: -- The assumption is that only contacts exist without PTUs
355: hr_utility.set_location('Entering create_normal_person_actions ',19);
356: hr_utility.set_location(' p_effective_date '||p_effective_date, 19);
357: --
358: IF p_mode_cd = 'T'
359: and p_person_selection_rule_id is null
360: THEN
417: -- Bug 2248822 Restrict the persons to only Employees and Ex-employees
418: -- for the CWB Process.
419: IF p_mode_cd = 'W' THEN
420: --
421: hr_utility.set_location(' p_cwb_person_type '||p_cwb_person_type, 19);
422: fnd_file.put_line(fnd_file.log, p_cwb_person_type );
423: if nvl(p_cwb_person_type,'AEXE') = 'AEXE'
424: then
425: l_cwb_whclause := ' and exists ( select ''x'' from per_person_type_usages_f ptu, '||
464: || ' and :effective_date between asgn.effective_start_date '
465: || ' and asgn.effective_end_date '
466: || ' and :l_wth_start_date is null )' ;
467: else
468: hr_utility.set_location(' p_popl_enrt_typ_cycl_id '|| p_popl_enrt_typ_cycl_id, 19);
469: hr_utility.set_location(' p_lf_evt_ocrd_dt '|| p_lf_evt_ocrd_dt, 19);
470: --
471: fnd_file.put_line(fnd_file.log, p_popl_enrt_typ_cycl_id );
472: fnd_file.put_line(fnd_file.log, p_lf_evt_ocrd_dt );
465: || ' and asgn.effective_end_date '
466: || ' and :l_wth_start_date is null )' ;
467: else
468: hr_utility.set_location(' p_popl_enrt_typ_cycl_id '|| p_popl_enrt_typ_cycl_id, 19);
469: hr_utility.set_location(' p_lf_evt_ocrd_dt '|| p_lf_evt_ocrd_dt, 19);
470: --
471: fnd_file.put_line(fnd_file.log, p_popl_enrt_typ_cycl_id );
472: fnd_file.put_line(fnd_file.log, p_lf_evt_ocrd_dt );
473:
477: open c_cwb_asg_date_chk;
478: fetch c_cwb_asg_date_chk into l_wth_start_date, l_wth_end_date ;
479: close c_cwb_asg_date_chk;
480: --
481: hr_utility.set_location(' l_wth_start_date '|| l_wth_start_date, 19);
482: fnd_file.put_line(fnd_file.log, l_wth_start_date );
483: --
484: if l_wth_start_date is not null
485: then
525: -- bug 3537113
526: --
527: l_query_str := l_query_str||l_cwb_whclause ;
528: --
529: hr_utility.set_location('Building cwb where clause ',29);
530: --
531: ELSE -- if p_mode_cd <> 'W' then
532: --
533: -- Bug 2279394 : where clause is not formed correctly, as and is missing
583: ' and ler.typ_cd =''COMP'' ' ||
584: ' and pil.per_in_ler_stat_cd in(''STRTD''))';
585: end if;
586: */
587: hr_utility.set_location('CWB group pl id'|| ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id ,10);
588:
589: -- end cwbglobal
590:
591:
1366: ' and :effective_date between ptu.effective_start_date '||
1367: ' and ptu.effective_end_date ) ' ;
1368: l_query_str := l_query_str||l_gsp_whclause ;
1369: --
1370: hr_utility.set_location('Building cwb where clause ',29);
1371: --
1372: ELSE
1373: --
1374: -- Bug 2279394 : where clause is not formed correctly, as and is missing
1970:
1971: /* Uncomment the following lines when you debug the dynamic sql
1972: text
1973: for i in 1..60 loop
1974: hr_utility.set_location(substr(l_query_str, 60*i-59, 60), 1234);
1975: if (60*i-59 > length(l_query_str)) then
1976: exit;
1977: end if;
1978: end loop;
2159: l_to_chunk_loop NUMBER := 0;
2160: --
2161: BEGIN
2162: --
2163: -- hr_utility.set_location('Entering '||l_package,10);
2164: --
2165: -- Updating ranges from ben_batch_ranges table
2166: -- Rolling back ranges with erred or partially unfinished person actions
2167: --
2201: -- This is for What IF Functionality
2202: commit;
2203: end if;
2204: --
2205: -- hr_utility.set_location('Leaving '||l_package,10);
2206: --
2207: END create_restart_person_actions;
2208: --
2209: END ben_benbatch_persons;