eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CWB_BACK_OUT_CONC dependencies on HR_UTILITY

Line 118: g_debug boolean := hr_utility.debug_enabled;

114: g_persons_passed number(9) := 0;
115: g_persons_errored number(9) := 0;
116: g_max_errors_allowed number(9) := 200;
117: g_rec ben_type.g_report_rec;
118: g_debug boolean := hr_utility.debug_enabled;
119: --
120: /*
121: procedure backout_heirarchy_data
122: (p_per_in_ler_id in number

Line 132: hr_utility.set_location( 'Entering '|| l_proc, 5);

128: --
129: l_proc varchar2(50) := g_package||'.cwb_delete_routine';
130: begin
131: --
132: hr_utility.set_location( 'Entering '|| l_proc, 5);
133: --
134: -- Delete heirarchy data : bug 4021004
135: --
136: delete from ben_cwb_group_hrchy hrc

Line 153: hr_utility.set_location( 'Leaving '||l_proc, 50);

149: null;
150: end;
151: end loop;
152: --
153: hr_utility.set_location( 'Leaving '||l_proc, 50);
154: --
155: end backout_heirarchy_data;
156: */
157: --

Line 170: hr_utility.set_location( 'Entering '|| l_proc, 5);

166: --
167: l_proc varchar2(50) := g_package||'.cwb_delete_routine';
168: begin
169: --
170: hr_utility.set_location( 'Entering '|| l_proc, 5);
171: --
172: -- Delete heirarchy data : bug 4021004
173: --
174: delete from ben_cwb_group_hrchy hrc

Line 196: hr_utility.set_location( 'Leaving '||l_proc, 50);

192: null;
193: end;
194: end loop;
195: --
196: hr_utility.set_location( 'Leaving '||l_proc, 50);
197: --
198: end backout_heirarchy_data;
199: --
200: -- ----------------------------------------------------------------------------

Line 243: hr_utility.set_location('l_zap_start_date = ' || l_zap_start_date, 12);

239: p_del_future_end_date => l_del_future_end_date,
240: p_del_next_start_date => l_del_next_start_date,
241: p_del_next_end_date => l_del_next_end_date);*/
242: --
243: hr_utility.set_location('l_zap_start_date = ' || l_zap_start_date, 12);
244: hr_utility.set_location('l_zap_end_date = ' || l_zap_end_date, 12);
245: hr_utility.set_location('l_delete_start_date = ' || l_delete_start_date, 12);
246: hr_utility.set_location('l_delete_end_date = ' || l_delete_end_date, 12);
247: hr_utility.set_location('l_del_future_start_date = ' || l_del_future_start_date, 12);

Line 244: hr_utility.set_location('l_zap_end_date = ' || l_zap_end_date, 12);

240: p_del_next_start_date => l_del_next_start_date,
241: p_del_next_end_date => l_del_next_end_date);*/
242: --
243: hr_utility.set_location('l_zap_start_date = ' || l_zap_start_date, 12);
244: hr_utility.set_location('l_zap_end_date = ' || l_zap_end_date, 12);
245: hr_utility.set_location('l_delete_start_date = ' || l_delete_start_date, 12);
246: hr_utility.set_location('l_delete_end_date = ' || l_delete_end_date, 12);
247: hr_utility.set_location('l_del_future_start_date = ' || l_del_future_start_date, 12);
248: hr_utility.set_location('l_del_future_end_date = ' || l_del_future_end_date, 12);

Line 245: hr_utility.set_location('l_delete_start_date = ' || l_delete_start_date, 12);

241: p_del_next_end_date => l_del_next_end_date);*/
242: --
243: hr_utility.set_location('l_zap_start_date = ' || l_zap_start_date, 12);
244: hr_utility.set_location('l_zap_end_date = ' || l_zap_end_date, 12);
245: hr_utility.set_location('l_delete_start_date = ' || l_delete_start_date, 12);
246: hr_utility.set_location('l_delete_end_date = ' || l_delete_end_date, 12);
247: hr_utility.set_location('l_del_future_start_date = ' || l_del_future_start_date, 12);
248: hr_utility.set_location('l_del_future_end_date = ' || l_del_future_end_date, 12);
249: hr_utility.set_location('l_del_next_start_date = ' || l_del_next_start_date, 12);

Line 246: hr_utility.set_location('l_delete_end_date = ' || l_delete_end_date, 12);

242: --
243: hr_utility.set_location('l_zap_start_date = ' || l_zap_start_date, 12);
244: hr_utility.set_location('l_zap_end_date = ' || l_zap_end_date, 12);
245: hr_utility.set_location('l_delete_start_date = ' || l_delete_start_date, 12);
246: hr_utility.set_location('l_delete_end_date = ' || l_delete_end_date, 12);
247: hr_utility.set_location('l_del_future_start_date = ' || l_del_future_start_date, 12);
248: hr_utility.set_location('l_del_future_end_date = ' || l_del_future_end_date, 12);
249: hr_utility.set_location('l_del_next_start_date = ' || l_del_next_start_date, 12);
250: hr_utility.set_location('l_del_next_end_date = ' || l_del_next_end_date, 12);

Line 247: hr_utility.set_location('l_del_future_start_date = ' || l_del_future_start_date, 12);

243: hr_utility.set_location('l_zap_start_date = ' || l_zap_start_date, 12);
244: hr_utility.set_location('l_zap_end_date = ' || l_zap_end_date, 12);
245: hr_utility.set_location('l_delete_start_date = ' || l_delete_start_date, 12);
246: hr_utility.set_location('l_delete_end_date = ' || l_delete_end_date, 12);
247: hr_utility.set_location('l_del_future_start_date = ' || l_del_future_start_date, 12);
248: hr_utility.set_location('l_del_future_end_date = ' || l_del_future_end_date, 12);
249: hr_utility.set_location('l_del_next_start_date = ' || l_del_next_start_date, 12);
250: hr_utility.set_location('l_del_next_end_date = ' || l_del_next_end_date, 12);
251:

Line 248: hr_utility.set_location('l_del_future_end_date = ' || l_del_future_end_date, 12);

244: hr_utility.set_location('l_zap_end_date = ' || l_zap_end_date, 12);
245: hr_utility.set_location('l_delete_start_date = ' || l_delete_start_date, 12);
246: hr_utility.set_location('l_delete_end_date = ' || l_delete_end_date, 12);
247: hr_utility.set_location('l_del_future_start_date = ' || l_del_future_start_date, 12);
248: hr_utility.set_location('l_del_future_end_date = ' || l_del_future_end_date, 12);
249: hr_utility.set_location('l_del_next_start_date = ' || l_del_next_start_date, 12);
250: hr_utility.set_location('l_del_next_end_date = ' || l_del_next_end_date, 12);
251:
252: if l_zap_mode then

Line 249: hr_utility.set_location('l_del_next_start_date = ' || l_del_next_start_date, 12);

245: hr_utility.set_location('l_delete_start_date = ' || l_delete_start_date, 12);
246: hr_utility.set_location('l_delete_end_date = ' || l_delete_end_date, 12);
247: hr_utility.set_location('l_del_future_start_date = ' || l_del_future_start_date, 12);
248: hr_utility.set_location('l_del_future_end_date = ' || l_del_future_end_date, 12);
249: hr_utility.set_location('l_del_next_start_date = ' || l_del_next_start_date, 12);
250: hr_utility.set_location('l_del_next_end_date = ' || l_del_next_end_date, 12);
251:
252: if l_zap_mode then
253: hr_utility.set_location('l_zap true', 13);

Line 250: hr_utility.set_location('l_del_next_end_date = ' || l_del_next_end_date, 12);

246: hr_utility.set_location('l_delete_end_date = ' || l_delete_end_date, 12);
247: hr_utility.set_location('l_del_future_start_date = ' || l_del_future_start_date, 12);
248: hr_utility.set_location('l_del_future_end_date = ' || l_del_future_end_date, 12);
249: hr_utility.set_location('l_del_next_start_date = ' || l_del_next_start_date, 12);
250: hr_utility.set_location('l_del_next_end_date = ' || l_del_next_end_date, 12);
251:
252: if l_zap_mode then
253: hr_utility.set_location('l_zap true', 13);
254: end if;

Line 253: hr_utility.set_location('l_zap true', 13);

249: hr_utility.set_location('l_del_next_start_date = ' || l_del_next_start_date, 12);
250: hr_utility.set_location('l_del_next_end_date = ' || l_del_next_end_date, 12);
251:
252: if l_zap_mode then
253: hr_utility.set_location('l_zap true', 13);
254: end if;
255: if l_delete_mode then
256: hr_utility.set_location('l_delete_mode true', 13);
257: end if;

Line 256: hr_utility.set_location('l_delete_mode true', 13);

252: if l_zap_mode then
253: hr_utility.set_location('l_zap true', 13);
254: end if;
255: if l_delete_mode then
256: hr_utility.set_location('l_delete_mode true', 13);
257: end if;
258: if l_future_change_mode then
259: hr_utility.set_location('l_future_change_mode true', 13);
260: end if;

Line 259: hr_utility.set_location('l_future_change_mode true', 13);

255: if l_delete_mode then
256: hr_utility.set_location('l_delete_mode true', 13);
257: end if;
258: if l_future_change_mode then
259: hr_utility.set_location('l_future_change_mode true', 13);
260: end if;
261: if l_delete_next_change_mode then
262: hr_utility.set_location('l_delete_next_change_mode true', 13);
263: end if;

Line 262: hr_utility.set_location('l_delete_next_change_mode true', 13);

258: if l_future_change_mode then
259: hr_utility.set_location('l_future_change_mode true', 13);
260: end if;
261: if l_delete_next_change_mode then
262: hr_utility.set_location('l_delete_next_change_mode true', 13);
263: end if;
264: if l_delete_next_change_mode = true or l_future_change_mode = true then
265: l_del_mode := hr_api.g_future_change;
266: else

Line 392: g_debug := hr_utility.debug_enabled;

388: and p_effective_date = pee.effective_end_date;
389: --
390: begin
391: --
392: g_debug := hr_utility.debug_enabled;
393: if g_debug then
394: hr_utility.set_location('Entering :'||l_proc,5);
395: hr_utility.set_location('Element_link_id='||to_char(p_element_link_id),6);
396: hr_utility.set_location('p_element_entry_value_id='||to_char(p_element_entry_value_id),6);

Line 394: hr_utility.set_location('Entering :'||l_proc,5);

390: begin
391: --
392: g_debug := hr_utility.debug_enabled;
393: if g_debug then
394: hr_utility.set_location('Entering :'||l_proc,5);
395: hr_utility.set_location('Element_link_id='||to_char(p_element_link_id),6);
396: hr_utility.set_location('p_element_entry_value_id='||to_char(p_element_entry_value_id),6);
397: hr_utility.set_location('Effective_date='||to_char(p_effective_date),6);
398: hr_utility.set_location('p_rt_end_date='||to_char(p_rt_end_date),6);

Line 395: hr_utility.set_location('Element_link_id='||to_char(p_element_link_id),6);

391: --
392: g_debug := hr_utility.debug_enabled;
393: if g_debug then
394: hr_utility.set_location('Entering :'||l_proc,5);
395: hr_utility.set_location('Element_link_id='||to_char(p_element_link_id),6);
396: hr_utility.set_location('p_element_entry_value_id='||to_char(p_element_entry_value_id),6);
397: hr_utility.set_location('Effective_date='||to_char(p_effective_date),6);
398: hr_utility.set_location('p_rt_end_date='||to_char(p_rt_end_date),6);
399: end if;

Line 396: hr_utility.set_location('p_element_entry_value_id='||to_char(p_element_entry_value_id),6);

392: g_debug := hr_utility.debug_enabled;
393: if g_debug then
394: hr_utility.set_location('Entering :'||l_proc,5);
395: hr_utility.set_location('Element_link_id='||to_char(p_element_link_id),6);
396: hr_utility.set_location('p_element_entry_value_id='||to_char(p_element_entry_value_id),6);
397: hr_utility.set_location('Effective_date='||to_char(p_effective_date),6);
398: hr_utility.set_location('p_rt_end_date='||to_char(p_rt_end_date),6);
399: end if;
400: --

Line 397: hr_utility.set_location('Effective_date='||to_char(p_effective_date),6);

393: if g_debug then
394: hr_utility.set_location('Entering :'||l_proc,5);
395: hr_utility.set_location('Element_link_id='||to_char(p_element_link_id),6);
396: hr_utility.set_location('p_element_entry_value_id='||to_char(p_element_entry_value_id),6);
397: hr_utility.set_location('Effective_date='||to_char(p_effective_date),6);
398: hr_utility.set_location('p_rt_end_date='||to_char(p_rt_end_date),6);
399: end if;
400: --
401: -- After discussing with CWB team decide to go with simple approach.

Line 398: hr_utility.set_location('p_rt_end_date='||to_char(p_rt_end_date),6);

394: hr_utility.set_location('Entering :'||l_proc,5);
395: hr_utility.set_location('Element_link_id='||to_char(p_element_link_id),6);
396: hr_utility.set_location('p_element_entry_value_id='||to_char(p_element_entry_value_id),6);
397: hr_utility.set_location('Effective_date='||to_char(p_effective_date),6);
398: hr_utility.set_location('p_rt_end_date='||to_char(p_rt_end_date),6);
399: end if;
400: --
401: -- After discussing with CWB team decide to go with simple approach.
402: -- Issues to consider

Line 417: hr_utility.set_location('no element entry '||l_proc,7);

413: --
414: -- if no element entry was created to start with, return
415: --
416: if p_element_entry_value_id is null then
417: hr_utility.set_location('no element entry '||l_proc,7);
418: hr_utility.set_location('Leaving: '||l_proc,7);
419: return;
420: end if;
421: --

Line 418: hr_utility.set_location('Leaving: '||l_proc,7);

414: -- if no element entry was created to start with, return
415: --
416: if p_element_entry_value_id is null then
417: hr_utility.set_location('no element entry '||l_proc,7);
418: hr_utility.set_location('Leaving: '||l_proc,7);
419: return;
420: end if;
421: --
422: -- find the element type and input value based on element_entry_value_id

Line 440: hr_utility.set_location('Leaving: '||l_proc,7);

436: --
437: -- entry_value_id attached to prtt rt does not exist. This is possible
438: -- prior to FP C when ct. could delete the entries
439: --
440: hr_utility.set_location('Leaving: '||l_proc,7);
441: end if;
442: return;
443: end if;
444: close c_ele_info;

Line 449: hr_utility.set_location('ele type='||l_element_type_id,7);

445: --
446: l_effective_date := p_effective_date;
447: --
448: if g_debug then
449: hr_utility.set_location('ele type='||l_element_type_id,7);
450: hr_utility.set_location('inp val='||l_input_value_id,7);
451: hr_utility.set_location('l_effective_date='||l_effective_date,7);
452: end if;
453: --

Line 450: hr_utility.set_location('inp val='||l_input_value_id,7);

446: l_effective_date := p_effective_date;
447: --
448: if g_debug then
449: hr_utility.set_location('ele type='||l_element_type_id,7);
450: hr_utility.set_location('inp val='||l_input_value_id,7);
451: hr_utility.set_location('l_effective_date='||l_effective_date,7);
452: end if;
453: --
454: -- find the element entry that needs to be deleted.

Line 451: hr_utility.set_location('l_effective_date='||l_effective_date,7);

447: --
448: if g_debug then
449: hr_utility.set_location('ele type='||l_element_type_id,7);
450: hr_utility.set_location('inp val='||l_input_value_id,7);
451: hr_utility.set_location('l_effective_date='||l_effective_date,7);
452: end if;
453: --
454: -- find the element entry that needs to be deleted.
455: --

Line 477: hr_utility.set_location('element entry already ended',8);

473: if get_element_entry_id%notfound then
474: close get_element_entry_id;
475: if g_debug then
476: -- element entry already ended.
477: hr_utility.set_location('element entry already ended',8);
478: hr_utility.set_location('Leaving: '||l_proc,7);
479: end if;
480:
481: -- 9999 is it needed.

Line 478: hr_utility.set_location('Leaving: '||l_proc,7);

474: close get_element_entry_id;
475: if g_debug then
476: -- element entry already ended.
477: hr_utility.set_location('element entry already ended',8);
478: hr_utility.set_location('Leaving: '||l_proc,7);
479: end if;
480:
481: -- 9999 is it needed.
482: ben_warnings.load_warning

Line 503: hr_utility.set_location('Leaving: '||l_proc,8);

499: if g_debug then
500: --
501: -- Could delete the entries
502: --
503: hr_utility.set_location('Leaving: '||l_proc,8);
504: --
505: end if;
506: --
507: return;

Line 542: hr_utility.set_location('l_dt_delete_mode = ' || l_dt_delete_mode, 9);

538: end if;
539: end if;
540: --
541:
542: hr_utility.set_location('l_dt_delete_mode = ' || l_dt_delete_mode, 9);
543: hr_utility.set_location('l_element_entry_id = ' || l_element_entry_id, 9);
544: hr_utility.set_location('l_processing_type = ' || l_processing_type, 9);
545: --
546: -- If procesing type id Non Recussring then zap the element entry.

Line 543: hr_utility.set_location('l_element_entry_id = ' || l_element_entry_id, 9);

539: end if;
540: --
541:
542: hr_utility.set_location('l_dt_delete_mode = ' || l_dt_delete_mode, 9);
543: hr_utility.set_location('l_element_entry_id = ' || l_element_entry_id, 9);
544: hr_utility.set_location('l_processing_type = ' || l_processing_type, 9);
545: --
546: -- If procesing type id Non Recussring then zap the element entry.
547: -- If it is recurring then check whether the min effective_start date

Line 544: hr_utility.set_location('l_processing_type = ' || l_processing_type, 9);

540: --
541:
542: hr_utility.set_location('l_dt_delete_mode = ' || l_dt_delete_mode, 9);
543: hr_utility.set_location('l_element_entry_id = ' || l_element_entry_id, 9);
544: hr_utility.set_location('l_processing_type = ' || l_processing_type, 9);
545: --
546: -- If procesing type id Non Recussring then zap the element entry.
547: -- If it is recurring then check whether the min effective_start date
548: -- less than the p_effective date, if so then do a future change, otherwise

Line 562: hr_utility.set_location('Leaving :'||l_proc,5);

558: ,p_effective_end_date => l_effective_end_date
559: ,p_delete_warning => l_delete_warning);
560: --
561: if g_debug then
562: hr_utility.set_location('Leaving :'||l_proc,5);
563: end if;
564: --
565: end backout_cwb_element;
566:

Line 588: hr_utility.set_location('Entering:'|| l_proc, 10);

584:
585: begin
586:
587: if g_debug then
588: hr_utility.set_location('Entering:'|| l_proc, 10);
589: end if;
590: for l_data_exists in c_data_exists loop
591: l_return := bne_integrator_utils.delete_integrator(800,l_data_exists.custom_integrator);
592: if g_debug then

Line 593: hr_utility.set_location('Deleted custom integrator :'|| l_data_exists.custom_integrator, 20);

589: end if;
590: for l_data_exists in c_data_exists loop
591: l_return := bne_integrator_utils.delete_integrator(800,l_data_exists.custom_integrator);
592: if g_debug then
593: hr_utility.set_location('Deleted custom integrator :'|| l_data_exists.custom_integrator, 20);
594: hr_utility.set_location('l_return :'|| l_return, 21);
595: end if;
596: end loop;
597: if g_debug then

Line 594: hr_utility.set_location('l_return :'|| l_return, 21);

590: for l_data_exists in c_data_exists loop
591: l_return := bne_integrator_utils.delete_integrator(800,l_data_exists.custom_integrator);
592: if g_debug then
593: hr_utility.set_location('Deleted custom integrator :'|| l_data_exists.custom_integrator, 20);
594: hr_utility.set_location('l_return :'|| l_return, 21);
595: end if;
596: end loop;
597: if g_debug then
598: hr_utility.set_location('Leaving:'|| l_proc, 30);

Line 598: hr_utility.set_location('Leaving:'|| l_proc, 30);

594: hr_utility.set_location('l_return :'|| l_return, 21);
595: end if;
596: end loop;
597: if g_debug then
598: hr_utility.set_location('Leaving:'|| l_proc, 30);
599: end if;
600:
601: end delete_custom_integrator;
602:

Line 637: hr_utility.set_location ('Entering '||l_proc,10);

633: l_retcode number;
634: --
635: Begin
636: --
637: hr_utility.set_location ('Entering '||l_proc,10);
638: --
639: -- get the parameters for a previous run and do a restart
640: --
641: open c_parameters;

Line 670: hr_utility.set_location ('Leaving '||l_proc,70);

666: ,p_group_pl_id => l_parameters.pl_id
667: ,p_person_selection_rule_id => l_parameters.person_selection_rl
668: ,p_debug_messages => l_parameters.debug_messages_flag);
669: --
670: hr_utility.set_location ('Leaving '||l_proc,70);
671: --
672: end restart;
673: --
674:

Line 802: hr_utility.set_location ('Entering '||l_proc,10);

798: order by effective_start_date desc;
799: --
800: Begin
801: --
802: hr_utility.set_location ('Entering '||l_proc,10);
803: --
804: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
805: fnd_message.set_token('PROC','dt_fndate.change_ses_date');
806: dt_fndate.change_ses_date

Line 821: hr_utility.set_location ('l_threads '||l_threads,10);

817: ,p_threads => l_threads
818: ,p_chunk_size => l_chunk_size
819: ,p_max_errors => g_max_errors_allowed);
820: --
821: hr_utility.set_location ('l_threads '||l_threads,10);
822: hr_utility.set_location ('l_chunk_size '||l_chunk_size,10);
823: --
824: --
825: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

Line 822: hr_utility.set_location ('l_chunk_size '||l_chunk_size,10);

818: ,p_chunk_size => l_chunk_size
819: ,p_max_errors => g_max_errors_allowed);
820: --
821: hr_utility.set_location ('l_threads '||l_threads,10);
822: hr_utility.set_location ('l_chunk_size '||l_chunk_size,10);
823: --
824: --
825: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
826: fnd_message.set_token('PROC','ben_env_object.init');

Line 874: hr_utility.set_location('getting range',10);

870: -- 3) Put each row into the person cache.
871: -- 4) Process the person cache
872: -- 5) Go to number 1 again.
873: --
874: hr_utility.set_location('getting range',10);
875: --
876: Loop
877: --
878: open c_range_thread;

Line 883: hr_utility.set_location('doing range fetch',10);

879: --
880: fetch c_range_thread into l_range_id
881: ,l_start_person_action_id
882: ,l_end_person_action_id;
883: hr_utility.set_location('doing range fetch',10);
884: --
885: if c_range_thread%notfound then
886: --
887: hr_utility.set_location('range not Found',10);

Line 887: hr_utility.set_location('range not Found',10);

883: hr_utility.set_location('doing range fetch',10);
884: --
885: if c_range_thread%notfound then
886: --
887: hr_utility.set_location('range not Found',10);
888: --
889: close c_range_thread;
890: exit;
891: --

Line 894: hr_utility.set_location('range Found',10);

890: exit;
891: --
892: end if;
893: --
894: hr_utility.set_location('range Found',10);
895: --
896: close c_range_thread;
897: --
898: update ben_batch_ranges ran

Line 912: hr_utility.set_location('person id'||l_person_id,10);

908: loop
909: --
910: fetch c_person_thread into l_person_id,
911: l_person_action_id;
912: hr_utility.set_location('person id'||l_person_id,10);
913: --
914: exit when c_person_thread%notfound;
915: --
916: savepoint last_place;

Line 940: hr_utility.set_location('Before open',10);

936: close c_person;
937: --
938: begin
939: --
940: hr_utility.set_location('Before open',10);
941: open c_ler_thread;
942: --
943: Loop
944: --

Line 948: hr_utility.set_location ('per_in_ler_id '||l_ler_thread.per_in_ler_id,10);

944: --
945: fetch c_ler_thread into l_ler_thread;
946: exit when c_ler_thread%notfound;
947: --
948: hr_utility.set_location ('per_in_ler_id '||l_ler_thread.per_in_ler_id,10);
949: hr_utility.set_location ('typ_cd '||l_ler_thread.typ_cd,10);
950: hr_utility.set_location ('bg id '||l_ler_thread.business_group_id,10);
951: --
952: --

Line 949: hr_utility.set_location ('typ_cd '||l_ler_thread.typ_cd,10);

945: fetch c_ler_thread into l_ler_thread;
946: exit when c_ler_thread%notfound;
947: --
948: hr_utility.set_location ('per_in_ler_id '||l_ler_thread.per_in_ler_id,10);
949: hr_utility.set_location ('typ_cd '||l_ler_thread.typ_cd,10);
950: hr_utility.set_location ('bg id '||l_ler_thread.business_group_id,10);
951: --
952: --
953: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

Line 950: hr_utility.set_location ('bg id '||l_ler_thread.business_group_id,10);

946: exit when c_ler_thread%notfound;
947: --
948: hr_utility.set_location ('per_in_ler_id '||l_ler_thread.per_in_ler_id,10);
949: hr_utility.set_location ('typ_cd '||l_ler_thread.typ_cd,10);
950: hr_utility.set_location ('bg id '||l_ler_thread.business_group_id,10);
951: --
952: --
953: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
954: fnd_message.set_token('PROC','ben_back_out_life_event');

Line 955: hr_utility.set_location ('calling bolfe ',10);

951: --
952: --
953: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
954: fnd_message.set_token('PROC','ben_back_out_life_event');
955: hr_utility.set_location ('calling bolfe ',10);
956: ben_back_out_life_event.g_enrt_made_flag := Null;
957: ben_back_out_life_event.back_out_life_events
958: (p_per_in_ler_id => l_ler_thread.per_in_ler_id
959: ,p_business_group_id => l_ler_thread.business_group_id

Line 970: hr_utility.set_location ('this ler is '||l_ler_thread.per_in_ler_id||

966: --
967: -- Check if the current pil is the group pil. If so, call
968: -- delete_cwb_data.
969: --
970: hr_utility.set_location ('this ler is '||l_ler_thread.per_in_ler_id||
971: 'group pil is '||p_life_event_id,777);
972: --
973: -- Bug 3517726 : CWB data is not getting deleted.
974: hr_utility.set_location ('calling delete_cwb_data',10);

Line 974: hr_utility.set_location ('calling delete_cwb_data',10);

970: hr_utility.set_location ('this ler is '||l_ler_thread.per_in_ler_id||
971: 'group pil is '||p_life_event_id,777);
972: --
973: -- Bug 3517726 : CWB data is not getting deleted.
974: hr_utility.set_location ('calling delete_cwb_data',10);
975: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
976: fnd_message.set_token('PROC','delete_cwb_data');
977: delete_cwb_data
978: (p_per_in_ler_id => l_ler_thread.per_in_ler_id

Line 1027: hr_utility.set_location('Super Error exception level',10);

1023: exception
1024: --
1025: when others then
1026: --
1027: hr_utility.set_location('Super Error exception level',10);
1028: hr_utility.set_location(sqlerrm,10);
1029:
1030: if c_latest_ler_cwb%isopen then
1031:

Line 1028: hr_utility.set_location(sqlerrm,10);

1024: --
1025: when others then
1026: --
1027: hr_utility.set_location('Super Error exception level',10);
1028: hr_utility.set_location(sqlerrm,10);
1029:
1030: if c_latest_ler_cwb%isopen then
1031:
1032: close c_latest_ler_cwb;

Line 1063: hr_utility.set_location('Error Message '||g_rec.text,10);

1059: g_rec.national_identifier := l_per_rec.national_identifier;
1060: g_rec.error_message_code := benutils.get_message_name;
1061: g_rec.text := fnd_message.get;
1062:
1063: hr_utility.set_location('Error Message '||g_rec.text,10);
1064: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
1065: benutils.write(g_rec.text);
1066: benutils.write(p_rec => g_rec);
1067: --

Line 1068: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);

1064: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
1065: benutils.write(g_rec.text);
1066: benutils.write(p_rec => g_rec);
1067: --
1068: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
1069: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
1070: if g_persons_errored > g_max_errors_allowed then
1071: --
1072: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');

Line 1069: hr_utility.set_location('Num Errors = '||g_persons_errored,10);

1065: benutils.write(g_rec.text);
1066: benutils.write(p_rec => g_rec);
1067: --
1068: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
1069: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
1070: if g_persons_errored > g_max_errors_allowed then
1071: --
1072: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');
1073: benutils.write(p_text => fnd_message.get);

Line 1081: hr_utility.set_location('Closing c_person_thread',10);

1077: end if;
1078: --
1079: end;
1080: --
1081: hr_utility.set_location('Closing c_person_thread',10);
1082: --
1083: end loop;
1084: --
1085: close c_person_thread;

Line 1091: hr_utility.set_location('Rolling back transaction ',10);

1087: -- Commit chunk
1088: --
1089: if p_validate = 'Y' then
1090: --
1091: hr_utility.set_location('Rolling back transaction ',10);
1092: --
1093: rollback;
1094: --
1095: end if;

Line 1111: hr_utility.set_location ('Leaving '||l_proc,70);

1107: ,p_num_pers_errored => g_persons_errored);
1108: --
1109: commit;
1110: --
1111: hr_utility.set_location ('Leaving '||l_proc,70);
1112: --
1113: Exception
1114: --
1115: When others then

Line 1117: hr_utility.set_location('Super Error',10);

1113: Exception
1114: --
1115: When others then
1116: --
1117: hr_utility.set_location('Super Error',10);
1118: hr_utility.set_location(sqlerrm,10);
1119: hr_utility.set_location('Super Error',10);
1120: rollback;
1121: benutils.rollback_cache;

Line 1118: hr_utility.set_location(sqlerrm,10);

1114: --
1115: When others then
1116: --
1117: hr_utility.set_location('Super Error',10);
1118: hr_utility.set_location(sqlerrm,10);
1119: hr_utility.set_location('Super Error',10);
1120: rollback;
1121: benutils.rollback_cache;
1122: --

Line 1119: hr_utility.set_location('Super Error',10);

1115: When others then
1116: --
1117: hr_utility.set_location('Super Error',10);
1118: hr_utility.set_location(sqlerrm,10);
1119: hr_utility.set_location('Super Error',10);
1120: rollback;
1121: benutils.rollback_cache;
1122: --
1123: g_rec.ler_id := nvl(p_life_event_id,l_ler_thread.ler_id);

Line 1290: hr_utility.set_location ('Entering '||l_proc,10);

1286: l_head number := 0 ;
1287:
1288: begin
1289: --
1290: hr_utility.set_location ('Entering '||l_proc,10);
1291: --
1292:
1293: hr_utility.set_location ('p_business_group_id '||p_business_group_id,10);
1294: hr_utility.set_location ('p_life_event_id '||p_life_event_id,10);

Line 1293: hr_utility.set_location ('p_business_group_id '||p_business_group_id,10);

1289: --
1290: hr_utility.set_location ('Entering '||l_proc,10);
1291: --
1292:
1293: hr_utility.set_location ('p_business_group_id '||p_business_group_id,10);
1294: hr_utility.set_location ('p_life_event_id '||p_life_event_id,10);
1295: hr_utility.set_location ('p_ocrd_date '||p_ocrd_date,10);
1296: hr_utility.set_location ('p_group_pl_id '||p_group_pl_id,10);
1297: hr_utility.set_location ('p_person_selection_rule_id '||p_person_selection_rule_id,10);

Line 1294: hr_utility.set_location ('p_life_event_id '||p_life_event_id,10);

1290: hr_utility.set_location ('Entering '||l_proc,10);
1291: --
1292:
1293: hr_utility.set_location ('p_business_group_id '||p_business_group_id,10);
1294: hr_utility.set_location ('p_life_event_id '||p_life_event_id,10);
1295: hr_utility.set_location ('p_ocrd_date '||p_ocrd_date,10);
1296: hr_utility.set_location ('p_group_pl_id '||p_group_pl_id,10);
1297: hr_utility.set_location ('p_person_selection_rule_id '||p_person_selection_rule_id,10);
1298: hr_utility.set_location ('p_person_id '||p_person_id,10);

Line 1295: hr_utility.set_location ('p_ocrd_date '||p_ocrd_date,10);

1291: --
1292:
1293: hr_utility.set_location ('p_business_group_id '||p_business_group_id,10);
1294: hr_utility.set_location ('p_life_event_id '||p_life_event_id,10);
1295: hr_utility.set_location ('p_ocrd_date '||p_ocrd_date,10);
1296: hr_utility.set_location ('p_group_pl_id '||p_group_pl_id,10);
1297: hr_utility.set_location ('p_person_selection_rule_id '||p_person_selection_rule_id,10);
1298: hr_utility.set_location ('p_person_id '||p_person_id,10);
1299: --

Line 1296: hr_utility.set_location ('p_group_pl_id '||p_group_pl_id,10);

1292:
1293: hr_utility.set_location ('p_business_group_id '||p_business_group_id,10);
1294: hr_utility.set_location ('p_life_event_id '||p_life_event_id,10);
1295: hr_utility.set_location ('p_ocrd_date '||p_ocrd_date,10);
1296: hr_utility.set_location ('p_group_pl_id '||p_group_pl_id,10);
1297: hr_utility.set_location ('p_person_selection_rule_id '||p_person_selection_rule_id,10);
1298: hr_utility.set_location ('p_person_id '||p_person_id,10);
1299: --
1300:

Line 1297: hr_utility.set_location ('p_person_selection_rule_id '||p_person_selection_rule_id,10);

1293: hr_utility.set_location ('p_business_group_id '||p_business_group_id,10);
1294: hr_utility.set_location ('p_life_event_id '||p_life_event_id,10);
1295: hr_utility.set_location ('p_ocrd_date '||p_ocrd_date,10);
1296: hr_utility.set_location ('p_group_pl_id '||p_group_pl_id,10);
1297: hr_utility.set_location ('p_person_selection_rule_id '||p_person_selection_rule_id,10);
1298: hr_utility.set_location ('p_person_id '||p_person_id,10);
1299: --
1300:
1301: --

Line 1298: hr_utility.set_location ('p_person_id '||p_person_id,10);

1294: hr_utility.set_location ('p_life_event_id '||p_life_event_id,10);
1295: hr_utility.set_location ('p_ocrd_date '||p_ocrd_date,10);
1296: hr_utility.set_location ('p_group_pl_id '||p_group_pl_id,10);
1297: hr_utility.set_location ('p_person_selection_rule_id '||p_person_selection_rule_id,10);
1298: hr_utility.set_location ('p_person_id '||p_person_id,10);
1299: --
1300:
1301: --
1302: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));

Line 1368: hr_utility.set_location ('l_benefit_action_id created is '||l_benefit_action_id,30);

1364: ,p_uneai_effective_date => null);
1365: --
1366: benutils.g_benefit_action_id := l_benefit_action_id;
1367: --
1368: hr_utility.set_location ('l_benefit_action_id created is '||l_benefit_action_id,30);
1369: -- Delete/clear ranges from ben_batch_ranges table
1370: --
1371: Delete from ben_batch_ranges
1372: Where benefit_action_id = l_benefit_action_id;

Line 1386: hr_utility.set_location ('next person selected is '||l_person_id,30);

1382: loop
1383: --
1384: l_person_selection := null;
1385: fetch c_person into l_person_id, l_business_group_id;
1386: hr_utility.set_location ('next person selected is '||l_person_id,30);
1387: exit when c_person%notfound;
1388: --
1389: l_cnt := l_cnt + 1;
1390: --

Line 1436: hr_utility.set_location ('person passed selection rule '||l_person_id,35);

1432: -- Store person_id into person actions table.
1433: --
1434: If l_person_ok = 'Y' then
1435: --
1436: hr_utility.set_location ('person passed selection rule '||l_person_id,35);
1437: Ben_person_actions_api.create_person_actions
1438: (p_validate => false
1439: ,p_person_action_id => l_person_action_id
1440: ,p_person_id => l_person_id

Line 1448: hr_utility.set_location ('person action created is '||l_person_action_id,40);

1444: ,p_chunk_number => l_chunk_num
1445: ,p_object_version_number => l_object_version_number
1446: ,p_effective_date => l_effective_date);
1447: --
1448: hr_utility.set_location ('person action created is '||l_person_action_id,40);
1449: --
1450: l_num_row := l_num_row + 1;
1451: l_person_cnt := l_person_cnt + 1;
1452: l_end_person_action_id := l_person_action_id;

Line 1474: hr_utility.set_location ('person action range created is '||l_range_id,45);

1470: ,p_ending_person_action_id => l_end_person_action_id
1471: ,p_object_version_number => l_object_version_number
1472: ,p_effective_date => l_effective_date);
1473: --
1474: hr_utility.set_location ('person action range created is '||l_range_id,45);
1475: --
1476: l_start_person_action_id := 0;
1477: l_end_person_action_id := 0;
1478: l_num_row := 0;

Line 1490: hr_utility.set_location('l_num_row='||to_char(l_num_row),48);

1486: --
1487: close c_person;
1488: --
1489: --
1490: hr_utility.set_location('l_num_row='||to_char(l_num_row),48);
1491: --
1492: If l_num_row <> 0 then
1493: --
1494: Ben_batch_ranges_api.create_batch_ranges

Line 1506: hr_utility.set_location('l_num_row='||to_char(l_num_row),50);

1502: ,p_effective_date => l_effective_date);
1503: --
1504: l_num_range := l_num_range + 1;
1505: --
1506: hr_utility.set_location('l_num_row='||to_char(l_num_row),50);
1507: hr_utility.set_location ('person action range created is '||l_range_id,55);
1508: --
1509: End if;
1510: --

Line 1507: hr_utility.set_location ('person action range created is '||l_range_id,55);

1503: --
1504: l_num_range := l_num_range + 1;
1505: --
1506: hr_utility.set_location('l_num_row='||to_char(l_num_row),50);
1507: hr_utility.set_location ('person action range created is '||l_range_id,55);
1508: --
1509: End if;
1510: --
1511: Else

Line 1529: hr_utility.set_location('spawning thread #'||l_count,60);

1525: If l_num_range > 1 then
1526: --
1527: For l_count in 1..least(l_threads,l_num_range)-1 loop
1528: --
1529: hr_utility.set_location('spawning thread #'||l_count,60);
1530: --
1531: l_request_id := fnd_request.submit_request
1532: (application => 'BEN'
1533: ,program => 'BENCWBBT'

Line 1592: hr_utility.set_location('waiting for slaves',65);

1588: ,p_life_event_id => p_life_event_id
1589: ,p_bckt_stat_cd => p_bckt_stat_cd
1590: );
1591: --
1592: hr_utility.set_location('waiting for slaves',65);
1593: --
1594: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1595: hr_utility.set_location('hurray my slaves are done',70);
1596: --

Line 1595: hr_utility.set_location('hurray my slaves are done',70);

1591: --
1592: hr_utility.set_location('waiting for slaves',65);
1593: --
1594: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1595: hr_utility.set_location('hurray my slaves are done',70);
1596: --
1597: -- Once all slaves are done go and delete heirarchy data.
1598: --
1599: if p_validate = 'N' then

Line 1610: hr_utility.set_location('Deleting custom integrator ',5);

1606: backout_heirarchy_data
1607: (p_per_in_ler_id => l_group_pil_rec.per_in_ler_id);
1608: end loop;
1609: --
1610: hr_utility.set_location('Deleting custom integrator ',5);
1611: delete_custom_integrator
1612: (p_group_pl_id => p_group_pl_id
1613: ,p_lf_evt_ocrd_dt => l_ocrd_date);
1614:

Line 1617: hr_utility.set_location('Refreshing BEN_CWB_COMP_DETAILS Table ',8);

1613: ,p_lf_evt_ocrd_dt => l_ocrd_date);
1614:
1615:
1616: --
1617: hr_utility.set_location('Refreshing BEN_CWB_COMP_DETAILS Table ',8);
1618: -- fix for 14096794
1619: BEN_CWB_CD_SUMMARY_PKG.BEN_CWB_CD_SUMMARY_PROC
1620: (l_errbuff,l_retcode,P_GROUP_PL_ID => p_group_pl_id
1621: ,P_LF_EVT_OCRD_DT => fnd_date.date_to_canonical(l_ocrd_date)

Line 1625: hr_utility.set_location('Deleting data from ben_cwb_pl_dsgn ',10);

1621: ,P_LF_EVT_OCRD_DT => fnd_date.date_to_canonical(l_ocrd_date)
1622: ,P_PURGE => 'Y');
1623:
1624: --
1625: hr_utility.set_location('Deleting data from ben_cwb_pl_dsgn ',10);
1626: BEN_CWB_PL_DSGN_PKG.delete_pl_dsgn
1627: (p_group_pl_id => p_group_pl_id
1628: ,p_lf_evt_ocrd_dt => l_ocrd_date);
1629: --

Line 1630: hr_utility.set_location('Refreshing Summary ',20);

1626: BEN_CWB_PL_DSGN_PKG.delete_pl_dsgn
1627: (p_group_pl_id => p_group_pl_id
1628: ,p_lf_evt_ocrd_dt => l_ocrd_date);
1629: --
1630: hr_utility.set_location('Refreshing Summary ',20);
1631: ben_cwb_summary_pkg.refresh_summary_group_pl
1632: (p_group_pl_id => p_group_pl_id
1633: ,p_lf_evt_ocrd_dt => l_ocrd_date);
1634: --

Line 1635: hr_utility.set_location('Refreshing Summary Complete',30);

1631: ben_cwb_summary_pkg.refresh_summary_group_pl
1632: (p_group_pl_id => p_group_pl_id
1633: ,p_lf_evt_ocrd_dt => l_ocrd_date);
1634: --
1635: hr_utility.set_location('Refreshing Summary Complete',30);
1636: commit;
1637: end if;
1638: --
1639: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

Line 1664: hr_utility.set_location('Submitting reports',72);

1660: fnd_file.put_line(which => fnd_file.log,
1661: buff => i.full_name ||' ('||'person_id = ' || i.person_id||')' );
1662: end loop;
1663: --
1664: hr_utility.set_location('Submitting reports',72);
1665: --
1666: -- submit summary report here
1667: --
1668: l_request_id := fnd_request.submit_request

Line 1691: hr_utility.set_location ('Leaving '||l_proc,75);

1687: description => null,
1688: sub_request => false,
1689: argument1 => fnd_global.conc_request_id);
1690: --
1691: hr_utility.set_location ('Leaving '||l_proc,75);
1692: --
1693: -- hr_utility.trace_off;
1694: Exception
1695:

Line 1693: -- hr_utility.trace_off;

1689: argument1 => fnd_global.conc_request_id);
1690: --
1691: hr_utility.set_location ('Leaving '||l_proc,75);
1692: --
1693: -- hr_utility.trace_off;
1694: Exception
1695:
1696: when l_no_one_to_process then
1697: if c_person%isopen then

Line 1708: hr_utility.set_location('Super Error',10);

1704: --
1705: if c_person%isopen then
1706: close c_person;
1707: end if;
1708: hr_utility.set_location('Super Error',10);
1709: rollback;
1710: benutils.write(p_text => fnd_message.get);
1711: benutils.write(p_text => sqlerrm);
1712: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);

Line 1799: hr_utility.set_location( 'Entering '|| l_proc, 5);

1795: l_person_id number;
1796: --
1797: begin
1798:
1799: hr_utility.set_location( 'Entering '|| l_proc, 5);
1800: --
1801: -- CWBGLOBAL
1802: --
1803: if p_routine = 'BEN_CWB_PERSON_TASKS' then

Line 1874: hr_utility.set_location('l_ELEMENT_ENTRY_VALUE_ID = '

1870: end if;
1871: --
1872: -- Delete element entry if attached to rate row.
1873: --
1874: hr_utility.set_location('l_ELEMENT_ENTRY_VALUE_ID = '
1875: || l_ELEMENT_ENTRY_VALUE_ID, 88);
1876: hr_utility.set_location('l_business_group_id_prop = '
1877: || l_business_group_id_prop, 88);
1878: hr_utility.set_location('l_person_id = ' || l_person_id, 88);

Line 1876: hr_utility.set_location('l_business_group_id_prop = '

1872: -- Delete element entry if attached to rate row.
1873: --
1874: hr_utility.set_location('l_ELEMENT_ENTRY_VALUE_ID = '
1875: || l_ELEMENT_ENTRY_VALUE_ID, 88);
1876: hr_utility.set_location('l_business_group_id_prop = '
1877: || l_business_group_id_prop, 88);
1878: hr_utility.set_location('l_person_id = ' || l_person_id, 88);
1879: hr_utility.set_location('l_COMP_POSTING_DATE = '
1880: || l_COMP_POSTING_DATE, 88);

Line 1878: hr_utility.set_location('l_person_id = ' || l_person_id, 88);

1874: hr_utility.set_location('l_ELEMENT_ENTRY_VALUE_ID = '
1875: || l_ELEMENT_ENTRY_VALUE_ID, 88);
1876: hr_utility.set_location('l_business_group_id_prop = '
1877: || l_business_group_id_prop, 88);
1878: hr_utility.set_location('l_person_id = ' || l_person_id, 88);
1879: hr_utility.set_location('l_COMP_POSTING_DATE = '
1880: || l_COMP_POSTING_DATE, 88);
1881: if l_ELEMENT_ENTRY_VALUE_ID is not null and
1882: l_COMP_POSTING_DATE is not null then

Line 1879: hr_utility.set_location('l_COMP_POSTING_DATE = '

1875: || l_ELEMENT_ENTRY_VALUE_ID, 88);
1876: hr_utility.set_location('l_business_group_id_prop = '
1877: || l_business_group_id_prop, 88);
1878: hr_utility.set_location('l_person_id = ' || l_person_id, 88);
1879: hr_utility.set_location('l_COMP_POSTING_DATE = '
1880: || l_COMP_POSTING_DATE, 88);
1881: if l_ELEMENT_ENTRY_VALUE_ID is not null and
1882: l_COMP_POSTING_DATE is not null then
1883:

Line 1929: hr_utility.set_location( 'in audit changes BEN_CWB_PERSON_INFO'

1925: close c_cwb_person_rates;
1926:
1927: elsif p_routine = 'BEN_CWB_PERSON_INFO' then
1928:
1929: hr_utility.set_location( 'in audit changes BEN_CWB_PERSON_INFO'
1930: || l_proc, 500);
1931:
1932: open c_cwb_person_info;
1933: loop

Line 1945: hr_utility.set_location( 'LEAVING audit changes BEN_CWB_PERSON_INFO'

1941: );
1942:
1943: end loop;
1944: close c_cwb_person_info;
1945: hr_utility.set_location( 'LEAVING audit changes BEN_CWB_PERSON_INFO'
1946: || l_proc, 600);
1947:
1948: end if;
1949: hr_utility.set_location( 'Leaving '||l_proc, 50);

Line 1949: hr_utility.set_location( 'Leaving '||l_proc, 50);

1945: hr_utility.set_location( 'LEAVING audit changes BEN_CWB_PERSON_INFO'
1946: || l_proc, 600);
1947:
1948: end if;
1949: hr_utility.set_location( 'Leaving '||l_proc, 50);
1950:
1951: exception
1952: --
1953: when others then

Line 1955: hr_utility.set_location('Super Error exception level',10);

1951: exception
1952: --
1953: when others then
1954: --
1955: hr_utility.set_location('Super Error exception level',10);
1956: hr_utility.set_location(sqlerrm,10);
1957: --
1958: if c_cwb_person_info%isopen then
1959: close c_cwb_person_info;

Line 1956: hr_utility.set_location(sqlerrm,10);

1952: --
1953: when others then
1954: --
1955: hr_utility.set_location('Super Error exception level',10);
1956: hr_utility.set_location(sqlerrm,10);
1957: --
1958: if c_cwb_person_info%isopen then
1959: close c_cwb_person_info;
1960: end if;

Line 1993: hr_utility.set_location( 'Entering '||l_proc, 5);

1989: l_proc varchar2(50) := g_package||'.delete_cwb_data';
1990: p_object_version_number ben_cwb_person_info.object_version_number%type;
1991: begin
1992:
1993: hr_utility.set_location( 'Entering '||l_proc, 5);
1994:
1995: --1. BEN_CWB_PERSON_TASKS
1996: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_TASKS', 10);
1997: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

Line 1996: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_TASKS', 10);

1992:
1993: hr_utility.set_location( 'Entering '||l_proc, 5);
1994:
1995: --1. BEN_CWB_PERSON_TASKS
1996: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_TASKS', 10);
1997: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1998: fnd_message.set_token('PROC','delete_person_tasks');
1999: cwb_delete_routine
2000: (p_routine => 'BEN_CWB_PERSON_TASKS'

Line 2006: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_RATES', 15);

2002: ,p_update_summary => p_update_summary
2003: );
2004:
2005: --2. BEN_CWB_PERSON_RATES
2006: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_RATES', 15);
2007: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2008: fnd_message.set_token('PROC','delete_person_rates');
2009: cwb_delete_routine
2010: (p_routine => 'BEN_CWB_PERSON_RATES'

Line 2016: hr_utility.set_location( 'BEN_CWB_PERSON_GROUPS', 20);

2012: ,p_update_summary => p_update_summary
2013: );
2014:
2015: --3. BEN_CWB_PERSON_GROUPS
2016: hr_utility.set_location( 'BEN_CWB_PERSON_GROUPS', 20);
2017: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2018: fnd_message.set_token('PROC','delete_person_groups');
2019: cwb_delete_routine
2020: (p_routine => 'BEN_CWB_PERSON_GROUPS'

Line 2026: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_INFO', 25);

2022: ,p_update_summary => p_update_summary
2023: );
2024:
2025: --4. BEN_CWB_PERSON_INFO
2026: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_INFO', 25);
2027: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2028: fnd_message.set_token('PROC','delete_person_info');
2029: cwb_delete_routine
2030: (p_routine => 'BEN_CWB_PERSON_INFO'

Line 2036: hr_utility.set_location( 'Leaving '||l_proc, 50);

2032: ,p_update_summary => p_update_summary
2033: );
2034: --************************************************************ --
2035:
2036: hr_utility.set_location( 'Leaving '||l_proc, 50);
2037: --
2038: end delete_cwb_data;
2039: --
2040: procedure delete_summary(p_group_per_in_ler_id in number) is

Line 2125: hr_utility.set_location( 'Entering '||l_proc, 10);

2121: l_proc varchar2(50) := g_package||'.p_backout_global_cwb_event';
2122: --
2123: begin
2124: --
2125: hr_utility.set_location( 'Entering '||l_proc, 10);
2126: open c_pil(p_person_id,
2127: p_lf_evt_ocrd_dt,
2128: p_group_pl_id,
2129: p_lf_evt_ocrd_dt);

Line 2136: hr_utility.set_location ('per_in_ler_id '||l_pil_rec.per_in_ler_id,10);

2132: --
2133: fetch c_pil into l_pil_rec;
2134: exit when c_pil%notfound;
2135: --
2136: hr_utility.set_location ('per_in_ler_id '||l_pil_rec.per_in_ler_id,10);
2137: hr_utility.set_location ('typ_cd '||l_pil_rec.typ_cd,10);
2138: hr_utility.set_location ('bg id '||l_pil_rec.business_group_id,10);
2139: --
2140: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

Line 2137: hr_utility.set_location ('typ_cd '||l_pil_rec.typ_cd,10);

2133: fetch c_pil into l_pil_rec;
2134: exit when c_pil%notfound;
2135: --
2136: hr_utility.set_location ('per_in_ler_id '||l_pil_rec.per_in_ler_id,10);
2137: hr_utility.set_location ('typ_cd '||l_pil_rec.typ_cd,10);
2138: hr_utility.set_location ('bg id '||l_pil_rec.business_group_id,10);
2139: --
2140: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2141: fnd_message.set_token('PROC','ben_back_out_life_event');

Line 2138: hr_utility.set_location ('bg id '||l_pil_rec.business_group_id,10);

2134: exit when c_pil%notfound;
2135: --
2136: hr_utility.set_location ('per_in_ler_id '||l_pil_rec.per_in_ler_id,10);
2137: hr_utility.set_location ('typ_cd '||l_pil_rec.typ_cd,10);
2138: hr_utility.set_location ('bg id '||l_pil_rec.business_group_id,10);
2139: --
2140: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2141: fnd_message.set_token('PROC','ben_back_out_life_event');
2142: hr_utility.set_location ('calling bolfe ',10);

Line 2142: hr_utility.set_location ('calling bolfe ',10);

2138: hr_utility.set_location ('bg id '||l_pil_rec.business_group_id,10);
2139: --
2140: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2141: fnd_message.set_token('PROC','ben_back_out_life_event');
2142: hr_utility.set_location ('calling bolfe ',10);
2143: --
2144: ben_back_out_life_event.g_enrt_made_flag := Null;
2145: --
2146: ben_back_out_life_event.back_out_life_events

Line 2172: hr_utility.set_location('Leaving '||l_proc, 50);

2168: End loop;
2169: --
2170: close c_pil;
2171: --
2172: hr_utility.set_location('Leaving '||l_proc, 50);
2173: exception
2174: --
2175: when others then
2176: --

Line 2177: hr_utility.set_location('Super Error exception level',10);

2173: exception
2174: --
2175: when others then
2176: --
2177: hr_utility.set_location('Super Error exception level',10);
2178: hr_utility.set_location(sqlerrm,10);
2179: --
2180: if c_pil%isopen then
2181: --

Line 2178: hr_utility.set_location(sqlerrm,10);

2174: --
2175: when others then
2176: --
2177: hr_utility.set_location('Super Error exception level',10);
2178: hr_utility.set_location(sqlerrm,10);
2179: --
2180: if c_pil%isopen then
2181: --
2182: close c_pil;