291: and ppf.effective_end_date;
292:
293: Begin
294: --
295: hr_utility.set_location ('Entering '||l_proc,10);
296: --
297: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
298: fnd_message.set_token('PROC','dt_fndate.change_ses_date');
299: dt_fndate.change_ses_date
360: -- 3) Put each row into the person cache.
361: -- 4) Process the person cache
362: -- 5) Go to number 1 again.
363: --
364: hr_utility.set_location('getting range',10);
365: --
366: Loop
367: --
368: open c_range_thread;
369: --
370: fetch c_range_thread into l_range_id
371: ,l_start_person_action_id
372: ,l_end_person_action_id;
373: hr_utility.set_location('doing range fetch',10);
374: --
375: if c_range_thread%notfound then
376: --
377: hr_utility.set_location('range not Found',10);
373: hr_utility.set_location('doing range fetch',10);
374: --
375: if c_range_thread%notfound then
376: --
377: hr_utility.set_location('range not Found',10);
378: --
379: exit;
380: --
381: end if;
379: exit;
380: --
381: end if;
382: --
383: hr_utility.set_location('range Found',10);
384: --
385: close c_range_thread;
386: --
387: update ben_batch_ranges ran
397: loop
398: --
399: fetch c_person_thread into l_person_id,
400: l_person_action_id;
401: hr_utility.set_location('person id'||l_person_id,10);
402: --
403: exit when c_person_thread%notfound;
404: --
405: savepoint last_place;
432:
433: --
434: begin
435: --
436: hr_utility.set_location('Before open',10);
437: open c_ler_thread;
438: --
439: Loop
440: --
547: exception
548: --
549: when others then
550: --
551: hr_utility.set_location('Super Error exception level',10);
552: hr_utility.set_location(sqlerrm,10);
553:
554: if c_latest_ler%isopen then
555:
548: --
549: when others then
550: --
551: hr_utility.set_location('Super Error exception level',10);
552: hr_utility.set_location(sqlerrm,10);
553:
554: if c_latest_ler%isopen then
555:
556: close c_latest_ler;
588: g_rec.text := fnd_message.get;
589:
590: -- Bug 2376330 end
591: --
592: hr_utility.set_location('Error Message '||g_rec.text,10);
593: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
594: benutils.write(g_rec.text);
595: benutils.write(p_rec => g_rec);
596: --
593: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
594: benutils.write(g_rec.text);
595: benutils.write(p_rec => g_rec);
596: --
597: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
598: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
599: if g_persons_errored > g_max_errors_allowed then
600: --
601: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');
594: benutils.write(g_rec.text);
595: benutils.write(p_rec => g_rec);
596: --
597: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
598: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
599: if g_persons_errored > g_max_errors_allowed then
600: --
601: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');
602: benutils.write(p_text => fnd_message.get);
606: end if;
607: --
608: end;
609: --
610: hr_utility.set_location('Closing c_person_thread',10);
611: --
612: end loop;
613: --
614: close c_person_thread;
616: -- Commit chunk
617: --
618: if p_validate = 'Y' then
619: --
620: hr_utility.set_location('Rolling back transaction ',10);
621: --
622: rollback;
623: --
624: end if;
636: ,p_num_pers_errored => g_persons_errored);
637: --
638: commit;
639: --
640: hr_utility.set_location ('Leaving '||l_proc,70);
641: --
642: Exception
643: --
644: When others then
642: Exception
643: --
644: When others then
645: --
646: hr_utility.set_location('Super Error',10);
647: hr_utility.set_location(sqlerrm,10);
648: hr_utility.set_location('Super Error',10);
649: rollback;
650: benutils.rollback_cache;
643: --
644: When others then
645: --
646: hr_utility.set_location('Super Error',10);
647: hr_utility.set_location(sqlerrm,10);
648: hr_utility.set_location('Super Error',10);
649: rollback;
650: benutils.rollback_cache;
651: --
644: When others then
645: --
646: hr_utility.set_location('Super Error',10);
647: hr_utility.set_location(sqlerrm,10);
648: hr_utility.set_location('Super Error',10);
649: rollback;
650: benutils.rollback_cache;
651: --
652: g_rec.ler_id := nvl(p_life_event_id,l_ler_thread.ler_id);
706: l_retcode number;
707: --
708: Begin
709: --
710: hr_utility.set_location ('Entering '||l_proc,10);
711: --
712: -- get the parameters for a previous run and do a restart
713: --
714: open c_parameters;
743: ,p_legal_entity_id => l_parameters.legal_entity_id
744: ,p_person_selection_rule_id => l_parameters.person_selection_rl
745: ,p_debug_messages => l_parameters.debug_messages_flag);
746: --
747: hr_utility.set_location ('Leaving '||l_proc,70);
748: --
749: end restart;
750: --
751: -- *************************************************************************
917: l_person_ok varchar2(1) := 'Y';
918: l_err_message varchar2(2000);
919: Begin
920: --
921: hr_utility.set_location ('Entering '||l_proc,10);
922: --
923: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
924: l_from_ocrd_date:=trunc(fnd_date.canonical_to_date(p_from_ocrd_date));
925: l_to_ocrd_date:=trunc(fnd_date.canonical_to_date(p_to_ocrd_date));
1081: End loop;
1082: --
1083: close c_person;
1084: --
1085: hr_utility.set_location('l_num_row='||to_char(l_num_row),18);
1086: --
1087: If l_num_row <> 0 then
1088: --
1089: Ben_batch_ranges_api.create_batch_ranges
1218: description => null,
1219: sub_request => false,
1220: argument1 => fnd_global.conc_request_id);
1221: --
1222: hr_utility.set_location ('Leaving '||l_proc,70);
1223: --
1224: hr_utility.trace_off;
1225: Exception
1226: --Bug 2253040
1220: argument1 => fnd_global.conc_request_id);
1221: --
1222: hr_utility.set_location ('Leaving '||l_proc,70);
1223: --
1224: hr_utility.trace_off;
1225: Exception
1226: --Bug 2253040
1227: when l_no_one_to_process then
1228: benutils.write(p_text => fnd_message.get);
1230: --Bug 2253040
1231:
1232: when others then
1233: --
1234: hr_utility.set_location('Super Error',10);
1235: rollback;
1236: benutils.write(p_text => fnd_message.get);
1237: benutils.write(p_text => sqlerrm);
1238: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);