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_MANAGE_CWB_LIFE_EVENTS dependencies on HR_UTILITY

Line 215: g_debug boolean := hr_utility.debug_enabled;

211: --------------------------------------------------------------------------------
212: --
213: g_package varchar2(80) := 'ben_manage_cwb_life_events';
214: --
215: g_debug boolean := hr_utility.debug_enabled;
216: g_rebuild_pl_id number := null;
217: g_rebuild_lf_evt_ocrd_dt date := null;
218: g_rebuild_business_group_id number := null;
219: g_opt_exists boolean;

Line 289: hr_utility.set_location ('Entering '||l_package,10);

285: --
286: begin
287: --
288: if g_debug then
289: hr_utility.set_location ('Entering '||l_package,10);
290: end if;
291: --
292: if p_num_cwb_processes <> 0 -- and p_master = 'Y'
293: then

Line 339: hr_utility.set_location ('Leaving '||l_package,10);

335: --
336: end if;
337: --
338: if g_debug then
339: hr_utility.set_location ('Leaving '||l_package,10);
340: end if;
341: --
342: commit;
343: --

Line 371: hr_utility.set_location ('Entering '||l_package,10);

367: --
368: begin
369: --
370: if g_debug then
371: hr_utility.set_location ('Entering '||l_package,10);
372: end if;
373: --
374: /*
375: -- Work out if process is master

Line 395: hr_utility.set_location (l_package||' OUT NOCOPY slave loop ',20);

391: ,p_slave_errored => l_slave_errored
392: );
393: --
394: if g_debug then
395: hr_utility.set_location (l_package||' OUT NOCOPY slave loop ',20);
396: end if;
397: --
398: /*
399: -- Log process information

Line 410: hr_utility.set_location (l_package||' Write to file ',35);

406: ,p_benefit_action_id => p_benefit_action_id
407: );
408: --
409: end if;
410: hr_utility.set_location (l_package||' Write to file ',35);
411: --
412: benutils.write_table_and_file(p_table => true,
413: p_file => false);
414: */

Line 420: hr_utility.set_location ('Leaving '||l_package,50);

416: commit;
417: --
418: p_slave_errored := l_slave_errored;
419: --
420: hr_utility.set_location ('Leaving '||l_package,50);
421: --
422: end check_all_slaves_finished;
423: --
424: -- Evaluates element determination rule

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

449:
450: begin
451: --
452: if g_debug then
453: hr_utility.set_location('Entering: '||l_proc,10);
454: end if;
455: --
456: if p_element_det_rl is null then
457: --

Line 460: hr_utility.set_location('Incorrect args '||l_proc,15);

456: if p_element_det_rl is null then
457: --
458: if p_acty_base_rt_id is null then
459: --
460: hr_utility.set_location('Incorrect args '||l_proc,15);
461: --
462: hr_api.mandatory_arg_error
463: (p_api_name => l_proc,
464: p_argument => 'p_element_det_rl,p_acty_base_rt_id',

Line 475: hr_utility.set_location('No RL found '||l_proc,15);

471: if c_abr%NotFound then /* Bug 5141153 : Added if condition */
472: close c_abr;
473: --
474: if g_debug then
475: hr_utility.set_location('No RL found '||l_proc,15);
476: hr_utility.set_location('Leaving: '||l_proc,15);
477: end if;
478: --
479: return;

Line 476: hr_utility.set_location('Leaving: '||l_proc,15);

472: close c_abr;
473: --
474: if g_debug then
475: hr_utility.set_location('No RL found '||l_proc,15);
476: hr_utility.set_location('Leaving: '||l_proc,15);
477: end if;
478: --
479: return;
480: --

Line 490: hr_utility.set_location('element_det_rl: '||l_element_det_rl,25);

486: l_element_det_rl := p_element_det_rl;
487: end if;
488:
489: if g_debug then
490: hr_utility.set_location('element_det_rl: '||l_element_det_rl,25);
491: end if;
492:
493: l_outputs := benutils.formula
494: (p_formula_id => l_element_det_rl,

Line 520: hr_utility.set_location('Leaving: '||l_proc,10);

516: --
517: end loop;
518: --
519: if g_debug then
520: hr_utility.set_location('Leaving: '||l_proc,10);
521: end if;
522: --
523: exception
524: when others then

Line 526: hr_utility.set_location('In exception block '||l_proc,10);

522: --
523: exception
524: when others then
525: if g_debug then
526: hr_utility.set_location('In exception block '||l_proc,10);
527: end if;
528: --
529: p_element_type_id := null;
530: p_input_value_id := null;

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

555:
556: begin
557: --
558: if g_debug then
559: hr_utility.set_location('Entering: '||l_proc,10);
560: end if;
561: --
562: ben_element_entry.get_abr_assignment
563: (p_person_id => p_person_id

Line 595: hr_utility.set_location('elt: '||p_element_type_id_out,10);

591: --
592: end if;
593: --
594: if g_debug then
595: hr_utility.set_location('elt: '||p_element_type_id_out,10);
596: hr_utility.set_location('inp: '||p_input_value_id_out,10);
597: hr_utility.set_location('Leaving: '||l_proc,10);
598: end if;
599: --

Line 596: hr_utility.set_location('inp: '||p_input_value_id_out,10);

592: end if;
593: --
594: if g_debug then
595: hr_utility.set_location('elt: '||p_element_type_id_out,10);
596: hr_utility.set_location('inp: '||p_input_value_id_out,10);
597: hr_utility.set_location('Leaving: '||l_proc,10);
598: end if;
599: --
600: exception

Line 597: hr_utility.set_location('Leaving: '||l_proc,10);

593: --
594: if g_debug then
595: hr_utility.set_location('elt: '||p_element_type_id_out,10);
596: hr_utility.set_location('inp: '||p_input_value_id_out,10);
597: hr_utility.set_location('Leaving: '||l_proc,10);
598: end if;
599: --
600: exception
601: when others then

Line 603: hr_utility.set_location('In exception block '||l_proc,10);

599: --
600: exception
601: when others then
602: if g_debug then
603: hr_utility.set_location('In exception block '||l_proc,10);
604: end if;
605: --
606: p_element_type_id_out := null;
607: p_input_value_id_out := null;

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

668: pln.effective_start_date and pln.effective_end_date;
669: begin
670: --
671: if g_debug then
672: hr_utility.set_location('Entering: '||l_proc,10);
673: hr_utility.set_location('p_currency_det_cd: '||p_currency_det_cd,10);
674: end if;
675: --
676: if nvl(p_currency_det_cd, 'AUTO') in ('STDRTEL', 'AUTO') then

Line 673: hr_utility.set_location('p_currency_det_cd: '||p_currency_det_cd,10);

669: begin
670: --
671: if g_debug then
672: hr_utility.set_location('Entering: '||l_proc,10);
673: hr_utility.set_location('p_currency_det_cd: '||p_currency_det_cd,10);
674: end if;
675: --
676: if nvl(p_currency_det_cd, 'AUTO') in ('STDRTEL', 'AUTO') then
677: --

Line 756: hr_utility.set_location('Leaving: '||l_proc,10);

752: p_input_value_id := l_input_value_id;
753: p_element_type_id := l_element_type_id;
754: --
755: if g_debug then
756: hr_utility.set_location('Leaving: '||l_proc,10);
757: end if;
758: --
759: end determine_curr_code;
760:

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

768: begin
769: --
770: if g_debug then
771: l_proc := g_package|| '.p_add_to_recur_hrchy';
772: hr_utility.set_location('Entering: '||l_proc,10);
773: end if;
774: --
775: l_counter := nvl(g_hrchy_tbl.LAST, 0);
776: if l_counter > 0 and p_hrchy_search is not null then

Line 795: hr_utility.set_location('Leaving: '||l_proc,10);

791: --
792: end if;
793: --
794: if g_debug then
795: hr_utility.set_location('Leaving: '||l_proc,10);
796: end if;
797: --
798: end p_add_to_recur_hrchy;
799: --

Line 904: g_debug := hr_utility.debug_enabled;

900: l_ws_mgr_id number := null ;
901: l_per_in_ler_id number := null ;
902: begin
903: --
904: g_debug := hr_utility.debug_enabled;
905: if g_debug then
906: hr_utility.set_location('MGR p_person_id '||p_person_id,22);
907: hr_utility.set_location('MGR p_business_group_id '||p_business_group_id,23);
908: end if;

Line 906: hr_utility.set_location('MGR p_person_id '||p_person_id,22);

902: begin
903: --
904: g_debug := hr_utility.debug_enabled;
905: if g_debug then
906: hr_utility.set_location('MGR p_person_id '||p_person_id,22);
907: hr_utility.set_location('MGR p_business_group_id '||p_business_group_id,23);
908: end if;
909: --
910: open c_mgr (p_person_id,p_pl_id,p_lf_evt_ocrd_dt,p_ler_id,p_business_group_id);

Line 907: hr_utility.set_location('MGR p_business_group_id '||p_business_group_id,23);

903: --
904: g_debug := hr_utility.debug_enabled;
905: if g_debug then
906: hr_utility.set_location('MGR p_person_id '||p_person_id,22);
907: hr_utility.set_location('MGR p_business_group_id '||p_business_group_id,23);
908: end if;
909: --
910: open c_mgr (p_person_id,p_pl_id,p_lf_evt_ocrd_dt,p_ler_id,p_business_group_id);
911: fetch c_mgr into l_ws_mgr_id,l_per_in_ler_id ;

Line 915: hr_utility.set_location('MGR OUT l_per_in_ler_id '||l_per_in_ler_id,30);

911: fetch c_mgr into l_ws_mgr_id,l_per_in_ler_id ;
912: close c_mgr ;
913: --
914: if g_debug then
915: hr_utility.set_location('MGR OUT l_per_in_ler_id '||l_per_in_ler_id,30);
916: hr_utility.set_location('MGR OUT l_ws_mgr_id '||l_ws_mgr_id,40);
917: end if;
918: --
919: p_per_in_ler_id := l_per_in_ler_id ;

Line 916: hr_utility.set_location('MGR OUT l_ws_mgr_id '||l_ws_mgr_id,40);

912: close c_mgr ;
913: --
914: if g_debug then
915: hr_utility.set_location('MGR OUT l_per_in_ler_id '||l_per_in_ler_id,30);
916: hr_utility.set_location('MGR OUT l_ws_mgr_id '||l_ws_mgr_id,40);
917: end if;
918: --
919: p_per_in_ler_id := l_per_in_ler_id ;
920: p_ws_mgr_id := l_ws_mgr_id ;

Line 931: hr_utility.set_location('insert_mgr_hrchy p_emp_per_in_ler_id '

927: p_lvl_num number ) is
928: begin
929: --
930: if g_debug then
931: hr_utility.set_location('insert_mgr_hrchy p_emp_per_in_ler_id '
932: ||p_emp_per_in_ler_id,10);
933: hr_utility.set_location('insert_mgr_hrchy p_mgr_per_in_ler_id '
934: ||p_mgr_per_in_ler_id || ' lvl = '
935: || p_lvl_num, 20);

Line 933: hr_utility.set_location('insert_mgr_hrchy p_mgr_per_in_ler_id '

929: --
930: if g_debug then
931: hr_utility.set_location('insert_mgr_hrchy p_emp_per_in_ler_id '
932: ||p_emp_per_in_ler_id,10);
933: hr_utility.set_location('insert_mgr_hrchy p_mgr_per_in_ler_id '
934: ||p_mgr_per_in_ler_id || ' lvl = '
935: || p_lvl_num, 20);
936: end if;
937: insert into ben_cwb_group_hrchy (

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

1050: begin
1051: --
1052: if g_debug then
1053: l_proc := g_package|| '.popu_group_pil_heir';
1054: hr_utility.set_location('Entering: '||l_proc,10);
1055: end if;
1056: --
1057: lv_pl_id := p_group_pl_id;
1058: lv_business_group_id := p_group_business_group_id;

Line 1063: hr_utility.set_location(l_proc || ' lv_pl_id = ' || lv_pl_id, 9876);

1059: lv_lf_evt_ocrd_dt := p_group_lf_evt_ocrd_dt;
1060: lv_ler_id := p_group_ler_id;
1061: --
1062: if g_debug then
1063: hr_utility.set_location(l_proc || ' lv_pl_id = ' || lv_pl_id, 9876);
1064: hr_utility.set_location(l_proc || ' lv_lf_evt_ocrd_dt = '
1065: || lv_lf_evt_ocrd_dt, 9876);
1066: hr_utility.set_location(l_proc || ' lv_business_group_id = '
1067: || lv_business_group_id, 9876);

Line 1064: hr_utility.set_location(l_proc || ' lv_lf_evt_ocrd_dt = '

1060: lv_ler_id := p_group_ler_id;
1061: --
1062: if g_debug then
1063: hr_utility.set_location(l_proc || ' lv_pl_id = ' || lv_pl_id, 9876);
1064: hr_utility.set_location(l_proc || ' lv_lf_evt_ocrd_dt = '
1065: || lv_lf_evt_ocrd_dt, 9876);
1066: hr_utility.set_location(l_proc || ' lv_business_group_id = '
1067: || lv_business_group_id, 9876);
1068: hr_utility.set_location(l_proc || ' lv_ler_id = ' || lv_ler_id, 9876);

Line 1066: hr_utility.set_location(l_proc || ' lv_business_group_id = '

1062: if g_debug then
1063: hr_utility.set_location(l_proc || ' lv_pl_id = ' || lv_pl_id, 9876);
1064: hr_utility.set_location(l_proc || ' lv_lf_evt_ocrd_dt = '
1065: || lv_lf_evt_ocrd_dt, 9876);
1066: hr_utility.set_location(l_proc || ' lv_business_group_id = '
1067: || lv_business_group_id, 9876);
1068: hr_utility.set_location(l_proc || ' lv_ler_id = ' || lv_ler_id, 9876);
1069: end if;
1070: open c_pil(lv_pl_id, lv_lf_evt_ocrd_dt);

Line 1068: hr_utility.set_location(l_proc || ' lv_ler_id = ' || lv_ler_id, 9876);

1064: hr_utility.set_location(l_proc || ' lv_lf_evt_ocrd_dt = '
1065: || lv_lf_evt_ocrd_dt, 9876);
1066: hr_utility.set_location(l_proc || ' lv_business_group_id = '
1067: || lv_business_group_id, 9876);
1068: hr_utility.set_location(l_proc || ' lv_ler_id = ' || lv_ler_id, 9876);
1069: end if;
1070: open c_pil(lv_pl_id, lv_lf_evt_ocrd_dt);
1071: fetch c_pil into l_emp_pil,l_mgr_person_id,l_person_id ;
1072: --

Line 1083: hr_utility.set_location(' l_emp_pil '||l_emp_pil,99);

1079: -- RECUR END
1080: --
1081: --
1082: if g_debug then
1083: hr_utility.set_location(' l_emp_pil '||l_emp_pil,99);
1084: hr_utility.set_location(' l_mgr_person_id '||l_mgr_person_id,99);
1085: end if;
1086: --
1087: <>

Line 1084: hr_utility.set_location(' l_mgr_person_id '||l_mgr_person_id,99);

1080: --
1081: --
1082: if g_debug then
1083: hr_utility.set_location(' l_emp_pil '||l_emp_pil,99);
1084: hr_utility.set_location(' l_mgr_person_id '||l_mgr_person_id,99);
1085: end if;
1086: --
1087: <>
1088: loop

Line 1097: hr_utility.set_location('Before mgr l_mgr_person_id '

1093: <>
1094: loop
1095: --
1096: if g_debug then
1097: hr_utility.set_location('Before mgr l_mgr_person_id '
1098: ||l_mgr_person_id,10);
1099: end if;
1100: --
1101: mgr(l_mgr_person_id,

Line 1110: hr_utility.set_location('After Mgr l_mgr_person_id '

1106: l_mgr_person_id_out,
1107: l_mgr_pil);
1108: --
1109: if g_debug then
1110: hr_utility.set_location('After Mgr l_mgr_person_id '
1111: ||l_mgr_person_id,20);
1112: hr_utility.set_location('After Mgr l_mgr_person_id_out '
1113: ||l_mgr_person_id_out,20);
1114: hr_utility.set_location('After Mgr l_mgr_pil '|| l_mgr_pil,30);

Line 1112: hr_utility.set_location('After Mgr l_mgr_person_id_out '

1108: --
1109: if g_debug then
1110: hr_utility.set_location('After Mgr l_mgr_person_id '
1111: ||l_mgr_person_id,20);
1112: hr_utility.set_location('After Mgr l_mgr_person_id_out '
1113: ||l_mgr_person_id_out,20);
1114: hr_utility.set_location('After Mgr l_mgr_pil '|| l_mgr_pil,30);
1115: end if;
1116: --

Line 1114: hr_utility.set_location('After Mgr l_mgr_pil '|| l_mgr_pil,30);

1110: hr_utility.set_location('After Mgr l_mgr_person_id '
1111: ||l_mgr_person_id,20);
1112: hr_utility.set_location('After Mgr l_mgr_person_id_out '
1113: ||l_mgr_person_id_out,20);
1114: hr_utility.set_location('After Mgr l_mgr_pil '|| l_mgr_pil,30);
1115: end if;
1116: --
1117: --
1118: -- RECUR

Line 1125: -- hr_utility.set_location('level = ' || l_level, 99);

1121: l_mgr_per_id_pos := instr (l_heirarchy_string, '~'|| to_char(l_mgr_person_id_out) || '~');
1122: if l_mgr_per_id_pos > 0 then
1123: --
1124: l_recursive_found := true;
1125: -- hr_utility.set_location('level = ' || l_level, 99);
1126: -- hr_utility.set_location('l_heirarchy_string = ' || l_heirarchy_string, 99);
1127: -- Now go ahead and store in a pl/sql table so that we print each occurance only once
1128: p_add_to_recur_hrchy(l_heirarchy_string|| to_char(l_mgr_person_id_out) || '~',
1129: '~'||to_char(l_mgr_person_id) || '~' || to_char(l_mgr_person_id_out) || '~');

Line 1126: -- hr_utility.set_location('l_heirarchy_string = ' || l_heirarchy_string, 99);

1122: if l_mgr_per_id_pos > 0 then
1123: --
1124: l_recursive_found := true;
1125: -- hr_utility.set_location('level = ' || l_level, 99);
1126: -- hr_utility.set_location('l_heirarchy_string = ' || l_heirarchy_string, 99);
1127: -- Now go ahead and store in a pl/sql table so that we print each occurance only once
1128: p_add_to_recur_hrchy(l_heirarchy_string|| to_char(l_mgr_person_id_out) || '~',
1129: '~'||to_char(l_mgr_person_id) || '~' || to_char(l_mgr_person_id_out) || '~');
1130: --

Line 1145: hr_utility.set_location('BEN_94020_RECURSIVE_EMP_HEIRAR', 999);

1141: -- Bug 3748539
1142: -- This situation indicates it is a recursive supervisory heirarchy.
1143: -- Raise error and rollback the heirarchy rebuild.
1144: --
1145: hr_utility.set_location('BEN_94020_RECURSIVE_EMP_HEIRAR', 999);
1146: /* RECUR
1147: fnd_message.set_name('BEN', 'BEN_94020_RECURSIVE_EMP_HEIRAR');
1148: fnd_message.set_token('PERSONID',to_char(l_person_id));
1149: fnd_message.set_token('MGRPERSONID',to_char(l_mgr_person_id));

Line 1172: hr_utility.set_location('Emp EPE '||l_emp_pil , 20);

1168: OR l_mgr_person_id_out is null or l_recursive_found or
1169: l_level > 75) ;
1170: --call to insert routne
1171: if g_debug then
1172: hr_utility.set_location('Emp EPE '||l_emp_pil , 20);
1173: hr_utility.set_location('Mgr EPE '||l_mgr_pil , 30);
1174: hr_utility.set_location('Level '||l_level , 40);
1175: end if;
1176: --

Line 1173: hr_utility.set_location('Mgr EPE '||l_mgr_pil , 30);

1169: l_level > 75) ;
1170: --call to insert routne
1171: if g_debug then
1172: hr_utility.set_location('Emp EPE '||l_emp_pil , 20);
1173: hr_utility.set_location('Mgr EPE '||l_mgr_pil , 30);
1174: hr_utility.set_location('Level '||l_level , 40);
1175: end if;
1176: --
1177: --

Line 1174: hr_utility.set_location('Level '||l_level , 40);

1170: --call to insert routne
1171: if g_debug then
1172: hr_utility.set_location('Emp EPE '||l_emp_pil , 20);
1173: hr_utility.set_location('Mgr EPE '||l_mgr_pil , 30);
1174: hr_utility.set_location('Level '||l_level , 40);
1175: end if;
1176: --
1177: --
1178: --after call to insert routine

Line 1191: hr_utility.set_location(' End of mgr_loop ',99);

1187: l_recursive_found := false;
1188: l_heirarchy_string := '~'||to_char(l_person_id)||'~'||to_char(l_mgr_person_id)||'~';
1189: --
1190: if g_debug then
1191: hr_utility.set_location(' End of mgr_loop ',99);
1192: end if;
1193: end loop pil ;
1194: --
1195: close c_pil ;

Line 1199: hr_utility.set_location('Before call to delete_init_pil',10);

1195: close c_pil ;
1196: --
1197: --call to delete the intial pil records
1198: if g_debug then
1199: hr_utility.set_location('Before call to delete_init_pil',10);
1200: end if;
1201: update_init_pil(lv_pl_id, lv_lf_evt_ocrd_dt) ;
1202: if g_debug then
1203: hr_utility.set_location('After call to delete_init_pil',10);

Line 1203: hr_utility.set_location('After call to delete_init_pil',10);

1199: hr_utility.set_location('Before call to delete_init_pil',10);
1200: end if;
1201: update_init_pil(lv_pl_id, lv_lf_evt_ocrd_dt) ;
1202: if g_debug then
1203: hr_utility.set_location('After call to delete_init_pil',10);
1204: end if;
1205:
1206: -- Bug 4587770
1207: -- Backout already deletes the data, so no need to call again here,

Line 1257: hr_utility.set_location('Leaving: '||l_proc,10);

1253: end;
1254: --
1255: end loop;
1256: if g_debug then
1257: hr_utility.set_location('Leaving: '||l_proc,10);
1258: end if;
1259: --
1260: end popu_group_pil_heir;
1261: --

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

1364: begin
1365: --
1366: if g_debug then
1367: l_proc := g_package|| '.get_group_plan_info';
1368: hr_utility.set_location('Entering: '||l_proc,10);
1369: end if;
1370: --
1371: if g_cache_group_plan_rec.group_pl_id is null then
1372: --

Line 1425: hr_utility.set_location('Leaving: '||l_proc,100);

1421: --
1422: end if;
1423: --
1424: if g_debug then
1425: hr_utility.set_location('Leaving: '||l_proc,100);
1426: end if;
1427: --
1428: end get_group_plan_info;
1429: --

Line 1461: hr_utility.set_location('Entering: '||l_proc,100);

1457: --
1458: --
1459: if g_debug then
1460: l_proc := g_package|| '.popu_cwb_tables';
1461: hr_utility.set_location('Entering: '||l_proc,100);
1462: end if;
1463: --
1464: g_cache_group_plan_rec.group_per_in_ler_id := p_group_per_in_ler_id;
1465: --

Line 1471: hr_utility.set_location('p_group_per_in_ler_id: '||p_group_per_in_ler_id,111);

1467: --
1468: open c_cwb_hrchy(p_group_per_in_ler_id);
1469: fetch c_cwb_hrchy into l_emp_pil_id;
1470: --
1471: hr_utility.set_location('p_group_per_in_ler_id: '||p_group_per_in_ler_id,111);
1472: if c_cwb_hrchy%notfound then
1473: --
1474: insert into ben_cwb_group_hrchy (
1475: emp_per_in_ler_id,

Line 1523: hr_utility.set_location('Leaving: '||l_proc,100);

1519: p_effective_date => l_effective_date,
1520: p_called_from_benmngle => true);
1521: --
1522: if g_debug then
1523: hr_utility.set_location('Leaving: '||l_proc,100);
1524: end if;
1525: --
1526: end popu_cwb_tables;
1527: --

Line 1622: hr_utility.set_location('Entering: '||l_proc,100);

1618: BEGIN
1619: --
1620: if g_debug then
1621: l_proc := g_package|| '.get_cwb_manager_and_assignment';
1622: hr_utility.set_location('Entering: '||l_proc,100);
1623: end if;
1624: --
1625: hr_utility.set_location('p_hrchy_to_use_cd '|| p_hrchy_to_use_cd,100);
1626: --

Line 1625: hr_utility.set_location('p_hrchy_to_use_cd '|| p_hrchy_to_use_cd,100);

1621: l_proc := g_package|| '.get_cwb_manager_and_assignment';
1622: hr_utility.set_location('Entering: '||l_proc,100);
1623: end if;
1624: --
1625: hr_utility.set_location('p_hrchy_to_use_cd '|| p_hrchy_to_use_cd,100);
1626: --
1627: OPEN c_get_assignment;
1628: FETCH c_get_assignment INTO l_get_assignment;
1629: CLOSE c_get_assignment;

Line 1675: hr_utility.set_location(' g_cache_group_plan_rec.hrchy_ame_trn_cd '

1671: ELSIF p_hrchy_to_use_cd = 'AME' THEN
1672: -- Use AME Hierarchy to fetch manager hierarchy.
1673: l_application_id := 805; -- Default it to 805
1674: -- Fetch the next approver
1675: hr_utility.set_location(' g_cache_group_plan_rec.hrchy_ame_trn_cd '
1676: || g_cache_group_plan_rec.hrchy_ame_trn_cd, 20);
1677: hr_utility.set_location(' p_person_id '|| p_person_id, 20);
1678: --
1679: BEGIN

Line 1677: hr_utility.set_location(' p_person_id '|| p_person_id, 20);

1673: l_application_id := 805; -- Default it to 805
1674: -- Fetch the next approver
1675: hr_utility.set_location(' g_cache_group_plan_rec.hrchy_ame_trn_cd '
1676: || g_cache_group_plan_rec.hrchy_ame_trn_cd, 20);
1677: hr_utility.set_location(' p_person_id '|| p_person_id, 20);
1678: --
1679: BEGIN
1680: ame_api.getnextapprover (applicationidin => l_application_id,
1681: transactionidin => p_person_id,

Line 1691: hr_utility.set_location(' l_ame_approver.person_id '|| l_ame_approver.person_id, 20);

1687: fnd_message.set_name('BEN','BEN_94119_AME_APPL_ERR');
1688: fnd_message.set_token('AME_ERROR', SQLERRM);
1689: fnd_message.raise_error;
1690: END;
1691: hr_utility.set_location(' l_ame_approver.person_id '|| l_ame_approver.person_id, 20);
1692: --
1693: l_manager_id := l_ame_approver.person_id;
1694: --
1695: ELSIF p_hrchy_to_use_cd = 'RL' THEN

Line 1697: hr_utility.set_location(' process RULE hrchy_rl '||g_cache_group_plan_rec.hrchy_rl, 20);

1693: l_manager_id := l_ame_approver.person_id;
1694: --
1695: ELSIF p_hrchy_to_use_cd = 'RL' THEN
1696: -- Use Rule to fetch Manager Id.
1697: hr_utility.set_location(' process RULE hrchy_rl '||g_cache_group_plan_rec.hrchy_rl, 20);
1698: --
1699: l_outputs :=
1700: benutils.formula (p_formula_id => g_cache_group_plan_rec.hrchy_rl
1701: ,p_effective_date => NVL(g_cache_group_plan_rec.group_lf_evt_ocrd_dt,

Line 1727: hr_utility.set_location(' Rule ret MGR_ID '|| l_manager_id, 20);

1723: );
1724: --
1725: l_manager_id := TO_NUMBER(l_outputs(l_outputs.FIRST).VALUE);
1726: --
1727: hr_utility.set_location(' Rule ret MGR_ID '|| l_manager_id, 20);
1728: --
1729: -- Bug: 3979082: Changes end here
1730: END IF;
1731: --

Line 1737: hr_utility.set_location('Leaving: '||l_proc,100);

1733: p_assignment_id := l_assignment_id;
1734: --
1735: if g_debug then
1736: l_proc := g_package|| '.get_cwb_manager_and_assignment';
1737: hr_utility.set_location('Leaving: '||l_proc,100);
1738: end if;
1739: --
1740: EXCEPTION -- nocopy changes
1741: --

Line 1840: hr_utility.set_location ('Entering '||l_package,10);

1836: * ben_cwb_person_tasks.
1837: */
1838: if g_debug then
1839: l_package := g_package||'.del_all_cwb_pils';
1840: hr_utility.set_location ('Entering '||l_package,10);
1841: end if;
1842: --
1843: -- This cursor can be avoided if it is fetched in main process.
1844: --

Line 1899: hr_utility.set_location ('Leaving '||l_package,10);

1895: --
1896: end if;
1897: --
1898: if g_debug then
1899: hr_utility.set_location ('Leaving '||l_package,10);
1900: end if;
1901: --
1902: end del_all_cwb_pils;
1903: --

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

2006: --
2007: -- Clone the data for current plan only.
2008: -- Group plan cloning should happen at the end of the loop.
2009: --
2010: hr_utility.set_location ('Entering '||l_proc,10);
2011: open c_popl_enrt_typ_cycl(p_lf_evt_ocrd_dt,
2012: p_business_group_id,
2013: p_effective_date,
2014: p_pl_id);

Line 2024: hr_utility.set_location('p_lf_evt_ocrd_dt = ' || p_lf_evt_ocrd_dt, 1234);

2020: fnd_message.set_name('BEN','BEN_91668_NO_FIND_POPL_ENRT');
2021: fnd_message.raise_error;
2022: end if;
2023: close c_popl_enrt_typ_cycl;
2024: hr_utility.set_location('p_lf_evt_ocrd_dt = ' || p_lf_evt_ocrd_dt, 1234);
2025: hr_utility.set_location('l_ler_id = ' || l_ler_id, 1234);
2026: hr_utility.set_location('p_pl_id = ' || p_pl_id, 1234);
2027: hr_utility.set_location('p_business_group_id = ' || p_business_group_id, 1234);
2028: --

Line 2025: hr_utility.set_location('l_ler_id = ' || l_ler_id, 1234);

2021: fnd_message.raise_error;
2022: end if;
2023: close c_popl_enrt_typ_cycl;
2024: hr_utility.set_location('p_lf_evt_ocrd_dt = ' || p_lf_evt_ocrd_dt, 1234);
2025: hr_utility.set_location('l_ler_id = ' || l_ler_id, 1234);
2026: hr_utility.set_location('p_pl_id = ' || p_pl_id, 1234);
2027: hr_utility.set_location('p_business_group_id = ' || p_business_group_id, 1234);
2028: --
2029: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf

Line 2026: hr_utility.set_location('p_pl_id = ' || p_pl_id, 1234);

2022: end if;
2023: close c_popl_enrt_typ_cycl;
2024: hr_utility.set_location('p_lf_evt_ocrd_dt = ' || p_lf_evt_ocrd_dt, 1234);
2025: hr_utility.set_location('l_ler_id = ' || l_ler_id, 1234);
2026: hr_utility.set_location('p_pl_id = ' || p_pl_id, 1234);
2027: hr_utility.set_location('p_business_group_id = ' || p_business_group_id, 1234);
2028: --
2029: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf
2030: (p_validate => false,

Line 2027: hr_utility.set_location('p_business_group_id = ' || p_business_group_id, 1234);

2023: close c_popl_enrt_typ_cycl;
2024: hr_utility.set_location('p_lf_evt_ocrd_dt = ' || p_lf_evt_ocrd_dt, 1234);
2025: hr_utility.set_location('l_ler_id = ' || l_ler_id, 1234);
2026: hr_utility.set_location('p_pl_id = ' || p_pl_id, 1234);
2027: hr_utility.set_location('p_business_group_id = ' || p_business_group_id, 1234);
2028: --
2029: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf
2030: (p_validate => false,
2031: p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id,

Line 2052: hr_utility.set_location('group_pl_id ' ||

2048: p_pl_id => p_pl_id,
2049: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
2050: p_business_group_id => p_business_group_id);
2051: --
2052: hr_utility.set_location('group_pl_id ' ||
2053: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id ,20);
2054: if p_pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id
2055: then
2056: --

Line 2106: hr_utility.set_location('group_pl_id = ' ||

2102: --
2103: */
2104: end if;
2105: --
2106: hr_utility.set_location('group_pl_id = ' ||
2107: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id, 30);
2108: --
2109: hr_utility.set_location('l_ws_mgr_id = ' || l_ws_mgr_id, 1234);
2110: hr_utility.set_location('l_assignment_id = ' || l_assignment_id, 1234);

Line 2109: hr_utility.set_location('l_ws_mgr_id = ' || l_ws_mgr_id, 1234);

2105: --
2106: hr_utility.set_location('group_pl_id = ' ||
2107: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id, 30);
2108: --
2109: hr_utility.set_location('l_ws_mgr_id = ' || l_ws_mgr_id, 1234);
2110: hr_utility.set_location('l_assignment_id = ' || l_assignment_id, 1234);
2111: ben_Person_Life_Event_api.create_Person_Life_Event_perf
2112: (p_validate => false
2113: ,p_per_in_ler_id => l_curr_per_in_ler_id

Line 2110: hr_utility.set_location('l_assignment_id = ' || l_assignment_id, 1234);

2106: hr_utility.set_location('group_pl_id = ' ||
2107: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id, 30);
2108: --
2109: hr_utility.set_location('l_ws_mgr_id = ' || l_ws_mgr_id, 1234);
2110: hr_utility.set_location('l_assignment_id = ' || l_assignment_id, 1234);
2111: ben_Person_Life_Event_api.create_Person_Life_Event_perf
2112: (p_validate => false
2113: ,p_per_in_ler_id => l_curr_per_in_ler_id
2114: ,p_ler_id => l_ler_id

Line 2143: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 40);

2139: -- plan design tables.
2140: --
2141: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_per_in_ler_id := l_curr_per_in_ler_id;
2142: --
2143: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 40);
2144: ben_manage_cwb_life_events.popu_cwb_tables(
2145: p_group_per_in_ler_id => l_curr_per_in_ler_id,
2146: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
2147: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,

Line 2162: hr_utility.set_location('Creating missing ben_cwb_person_groups', 50);

2158: loop
2159: --
2160: -- create row in ben_cwb_person_groups
2161: --
2162: hr_utility.set_location('Creating missing ben_cwb_person_groups', 50);
2163: insert into ben_cwb_person_groups
2164: (group_per_in_ler_id,
2165: group_pl_id ,
2166: group_oipl_id ,

Line 2266: hr_utility.set_location ('p_pl_id ' || p_pl_id,60);

2262: -- Populate
2263: -- BEN_CWB_PERSON_RATES
2264: -- Primary Key: PERSON_RATE_ID
2265: --
2266: hr_utility.set_location ('p_pl_id ' || p_pl_id,60);
2267: hr_utility.set_location ('g_cache_group_plan_rec.group_pl_id '||
2268: g_cache_group_plan_rec.group_pl_id ,60);
2269: hr_utility.set_location ('g_cache_group_plan_rec.plans_wthn_group_pl '
2270: || g_cache_group_plan_rec.plans_wthn_group_pl ,60);

Line 2267: hr_utility.set_location ('g_cache_group_plan_rec.group_pl_id '||

2263: -- BEN_CWB_PERSON_RATES
2264: -- Primary Key: PERSON_RATE_ID
2265: --
2266: hr_utility.set_location ('p_pl_id ' || p_pl_id,60);
2267: hr_utility.set_location ('g_cache_group_plan_rec.group_pl_id '||
2268: g_cache_group_plan_rec.group_pl_id ,60);
2269: hr_utility.set_location ('g_cache_group_plan_rec.plans_wthn_group_pl '
2270: || g_cache_group_plan_rec.plans_wthn_group_pl ,60);
2271: if ((p_pl_id = g_cache_group_plan_rec.group_pl_id and

Line 2269: hr_utility.set_location ('g_cache_group_plan_rec.plans_wthn_group_pl '

2265: --
2266: hr_utility.set_location ('p_pl_id ' || p_pl_id,60);
2267: hr_utility.set_location ('g_cache_group_plan_rec.group_pl_id '||
2268: g_cache_group_plan_rec.group_pl_id ,60);
2269: hr_utility.set_location ('g_cache_group_plan_rec.plans_wthn_group_pl '
2270: || g_cache_group_plan_rec.plans_wthn_group_pl ,60);
2271: if ((p_pl_id = g_cache_group_plan_rec.group_pl_id and
2272: g_cache_group_plan_rec.plans_wthn_group_pl = 1
2273: ) OR

Line 2279: hr_utility.set_location ('Person rate ' ,70);

2275: )
2276: then
2277: --
2278: if g_debug then
2279: hr_utility.set_location ('Person rate ' ,70);
2280: end if;
2281: --
2282: for l_cpr_rec in c_person_rates(
2283: c_group_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt

Line 2672: g_debug := hr_utility.debug_enabled;

2668: l_elpro_attcd_act_pln boolean := false; -- 5232223
2669: --
2670: begin
2671: --
2672: g_debug := hr_utility.debug_enabled;
2673: -- decide the sudit log and supress report flag
2674: l_audit_log_flag := substr(P_audit_log_flag,1,1) ;
2675: l_supress_report := nvl(substr(P_audit_log_flag,2,1),'Y') ;
2676: l_run_rollup_only := nvl(p_run_rollup_only, 'N');

Line 2684: hr_utility.set_location ('Entering '||l_package,10);

2680: --- Y Y Y
2681: --- NN N N
2682: --- YN Y N
2683: --
2684: hr_utility.set_location ('Entering '||l_package,10);
2685: hr_utility.set_location ('audit log '||l_audit_log_flag ,10);
2686: hr_utility.set_location ('supress log '|| l_supress_report ,10);
2687: hr_utility.set_location ('process rollup ' || p_run_rollup_only, 10);
2688: --

Line 2685: hr_utility.set_location ('audit log '||l_audit_log_flag ,10);

2681: --- NN N N
2682: --- YN Y N
2683: --
2684: hr_utility.set_location ('Entering '||l_package,10);
2685: hr_utility.set_location ('audit log '||l_audit_log_flag ,10);
2686: hr_utility.set_location ('supress log '|| l_supress_report ,10);
2687: hr_utility.set_location ('process rollup ' || p_run_rollup_only, 10);
2688: --
2689: if p_online_call_flag = 'N' then

Line 2686: hr_utility.set_location ('supress log '|| l_supress_report ,10);

2682: --- YN Y N
2683: --
2684: hr_utility.set_location ('Entering '||l_package,10);
2685: hr_utility.set_location ('audit log '||l_audit_log_flag ,10);
2686: hr_utility.set_location ('supress log '|| l_supress_report ,10);
2687: hr_utility.set_location ('process rollup ' || p_run_rollup_only, 10);
2688: --
2689: if p_online_call_flag = 'N' then
2690: --

Line 2687: hr_utility.set_location ('process rollup ' || p_run_rollup_only, 10);

2683: --
2684: hr_utility.set_location ('Entering '||l_package,10);
2685: hr_utility.set_location ('audit log '||l_audit_log_flag ,10);
2686: hr_utility.set_location ('supress log '|| l_supress_report ,10);
2687: hr_utility.set_location ('process rollup ' || p_run_rollup_only, 10);
2688: --
2689: if p_online_call_flag = 'N' then
2690: --
2691: fnd_file.put_line(which => fnd_file.log,

Line 2715: hr_utility.set_location('Entire process', 8888);

2711: --
2712: if l_run_rollup_only = 'N'
2713: then
2714: --
2715: hr_utility.set_location('Entire process', 8888);
2716: --
2717: for l_count in c_pln(p_pl_id) loop
2718: --
2719: if p_benfts_grp_id is not null then

Line 2724: hr_utility.set_location('l_benfts_grp_id = ' || l_benfts_grp_id, 1234);

2720: --
2721: open c_benfts_grp(p_benfts_grp_id, l_count.business_group_id);
2722: fetch c_benfts_grp into l_benfts_grp_id;
2723: close c_benfts_grp;
2724: hr_utility.set_location('l_benfts_grp_id = ' || l_benfts_grp_id, 1234);
2725: --
2726: end if;
2727: --
2728: if p_person_selection_rule_id is not null then

Line 2733: hr_utility.set_location('l_person_selection_rule_id = '||l_person_selection_rule_id,4321);

2729: --
2730: open c_person_selection_rl(p_person_selection_rule_id,l_count.business_group_id,l_lf_evt_ocrd_dt);
2731: fetch c_person_selection_rl into l_person_selection_rule_id ;
2732: close c_person_selection_rl ;
2733: hr_utility.set_location('l_person_selection_rule_id = '||l_person_selection_rule_id,4321);
2734: --
2735: end if;
2736: --
2737: if p_trace_plans_flag = 'N' then

Line 2855: hr_utility.set_location('hire dt = ' || l_per_rec.hire_date, 999);

2851: if l_per_rec.hire_date is null then
2852: --
2853: open get_per_info (p_person_id , l_effective_date);
2854: fetch get_per_info into l_per_rec;
2855: hr_utility.set_location('hire dt = ' || l_per_rec.hire_date, 999);
2856: hr_utility.set_location('leod dt = ' || l_lf_evt_ocrd_dt, 999);
2857: close get_per_info;
2858: --
2859: end if;

Line 2856: hr_utility.set_location('leod dt = ' || l_lf_evt_ocrd_dt, 999);

2852: --
2853: open get_per_info (p_person_id , l_effective_date);
2854: fetch get_per_info into l_per_rec;
2855: hr_utility.set_location('hire dt = ' || l_per_rec.hire_date, 999);
2856: hr_utility.set_location('leod dt = ' || l_lf_evt_ocrd_dt, 999);
2857: close get_per_info;
2858: --
2859: end if;
2860: --

Line 2866: hr_utility.set_location('Before call to p_single_per_clone_all_data', 999);

2862: -- l_per_rec.actual_termination_date < l_lf_evt_ocrd_dt or -- Changed for bug#7393142
2863: p_clone_all_data_flag = 'Y'
2864: then
2865: --
2866: hr_utility.set_location('Before call to p_single_per_clone_all_data', 999);
2867: -- Clone the data for current plan only.
2868: -- Group plan cloning should happen at the end of the loop.
2869: --
2870: l_USE_EFF_DT_FLAG := 'Y';

Line 2972: hr_utility.set_location('global_process - before call to cwb_group_pil', 1234);

2968: --Populate Missing Group Plan Information
2969: --
2970: fnd_file.put_line(which => fnd_file.log,
2971: buff => 'Started : Populating group plan data, ' || to_char(sysdate,'dd-mm-yyyy hh24:mi:ss'));
2972: hr_utility.set_location('global_process - before call to cwb_group_pil', 1234);
2973: if l_use_eff_dt_flag = 'N' then
2974: --
2975: g_error_log_rec.calling_proc := 'popu_cwb_group_pil_data';
2976: g_error_log_rec.step_number := 2;

Line 3066: hr_utility.set_location('trk_inelg ->'|| g_cache_group_plan_rec.trk_inelig_per_flag,99);

3062: l_elpro_attcd_act_pln := FALSE;
3063: end if;
3064: close c_elpros_attchd_loc;
3065: --
3066: hr_utility.set_location('trk_inelg ->'|| g_cache_group_plan_rec.trk_inelig_per_flag,99);
3067: --
3068: if NOT l_elpro_attcd_grp_pln
3069: and l_elpro_attcd_act_pln
3070: and g_cache_group_plan_rec.trk_inelig_per_flag = 'N' then

Line 3349: hr_utility.set_location ('Entering :' || l_package,10);

3345: --
3346: begin
3347: --
3348: if g_debug then
3349: hr_utility.set_location ('Entering :' || l_package,10);
3350: end if;
3351: --
3352: if p_pl_id = g_cache_group_plan_rec.group_pl_id then
3353: --

Line 3358: hr_utility.set_location ('Group rate ' ,15);

3354: -- Populate BEN_CWB_PERSON_GROUPS
3355: -- Primary Key: GROUP_PER_IN_LER_ID, GROUP_PL_ID, GROUP_OIPL_ID
3356: --
3357: if g_debug then
3358: hr_utility.set_location ('Group rate ' ,15);
3359: end if;
3360: --
3361: /* Bug 3510081
3362: if g_cwb_person_groups_rec.ws_bdgt_val is not null

Line 3500: hr_utility.set_location ('Person rate ' ,15);

3496: ) -- and (nvl(p_no_person_rates, 'N') = 'N')
3497: then
3498: --
3499: if g_debug then
3500: hr_utility.set_location ('Person rate ' ,15);
3501: end if;
3502: --
3503: -- Find the group_oipl_id
3504: --

Line 3535: hr_utility.set_location ('Person rate GROUP_PER_IN_LER_ID ' || g_cache_group_plan_rec.group_per_in_ler_id,15);

3531: p_input_value_id => l_input_value_id,
3532: p_currency_cd => l_currency_cd);
3533: --
3534: if g_debug then
3535: hr_utility.set_location ('Person rate GROUP_PER_IN_LER_ID ' || g_cache_group_plan_rec.group_per_in_ler_id,15);
3536: hr_utility.set_location ('Person rate PERSON_ID ' || p_person_id ,15);
3537: hr_utility.set_location ('Person rate PL_ID ' || p_pl_id,15);
3538: hr_utility.set_location ('Person rate GROUP_PL_ID ' || g_cache_group_plan_rec.group_pl_id,15);
3539: hr_utility.set_location ('Person rate LF_EVT_OCRD_DT ' || g_cache_group_plan_rec.group_lf_evt_ocrd_dt,15);

Line 3536: hr_utility.set_location ('Person rate PERSON_ID ' || p_person_id ,15);

3532: p_currency_cd => l_currency_cd);
3533: --
3534: if g_debug then
3535: hr_utility.set_location ('Person rate GROUP_PER_IN_LER_ID ' || g_cache_group_plan_rec.group_per_in_ler_id,15);
3536: hr_utility.set_location ('Person rate PERSON_ID ' || p_person_id ,15);
3537: hr_utility.set_location ('Person rate PL_ID ' || p_pl_id,15);
3538: hr_utility.set_location ('Person rate GROUP_PL_ID ' || g_cache_group_plan_rec.group_pl_id,15);
3539: hr_utility.set_location ('Person rate LF_EVT_OCRD_DT ' || g_cache_group_plan_rec.group_lf_evt_ocrd_dt,15);
3540: end if;

Line 3537: hr_utility.set_location ('Person rate PL_ID ' || p_pl_id,15);

3533: --
3534: if g_debug then
3535: hr_utility.set_location ('Person rate GROUP_PER_IN_LER_ID ' || g_cache_group_plan_rec.group_per_in_ler_id,15);
3536: hr_utility.set_location ('Person rate PERSON_ID ' || p_person_id ,15);
3537: hr_utility.set_location ('Person rate PL_ID ' || p_pl_id,15);
3538: hr_utility.set_location ('Person rate GROUP_PL_ID ' || g_cache_group_plan_rec.group_pl_id,15);
3539: hr_utility.set_location ('Person rate LF_EVT_OCRD_DT ' || g_cache_group_plan_rec.group_lf_evt_ocrd_dt,15);
3540: end if;
3541:

Line 3538: hr_utility.set_location ('Person rate GROUP_PL_ID ' || g_cache_group_plan_rec.group_pl_id,15);

3534: if g_debug then
3535: hr_utility.set_location ('Person rate GROUP_PER_IN_LER_ID ' || g_cache_group_plan_rec.group_per_in_ler_id,15);
3536: hr_utility.set_location ('Person rate PERSON_ID ' || p_person_id ,15);
3537: hr_utility.set_location ('Person rate PL_ID ' || p_pl_id,15);
3538: hr_utility.set_location ('Person rate GROUP_PL_ID ' || g_cache_group_plan_rec.group_pl_id,15);
3539: hr_utility.set_location ('Person rate LF_EVT_OCRD_DT ' || g_cache_group_plan_rec.group_lf_evt_ocrd_dt,15);
3540: end if;
3541:
3542: insert into ben_cwb_person_rates

Line 3539: hr_utility.set_location ('Person rate LF_EVT_OCRD_DT ' || g_cache_group_plan_rec.group_lf_evt_ocrd_dt,15);

3535: hr_utility.set_location ('Person rate GROUP_PER_IN_LER_ID ' || g_cache_group_plan_rec.group_per_in_ler_id,15);
3536: hr_utility.set_location ('Person rate PERSON_ID ' || p_person_id ,15);
3537: hr_utility.set_location ('Person rate PL_ID ' || p_pl_id,15);
3538: hr_utility.set_location ('Person rate GROUP_PL_ID ' || g_cache_group_plan_rec.group_pl_id,15);
3539: hr_utility.set_location ('Person rate LF_EVT_OCRD_DT ' || g_cache_group_plan_rec.group_lf_evt_ocrd_dt,15);
3540: end if;
3541:
3542: insert into ben_cwb_person_rates
3543: (person_rate_id ,

Line 3662: hr_utility.set_location ('Leaving :' || l_package,10);

3658: --
3659: end if;
3660: --
3661: if g_debug then
3662: hr_utility.set_location ('Leaving :' || l_package,10);
3663: end if;
3664: --
3665: end populate_cwb_rates;
3666: --

Line 3683: g_debug := hr_utility.debug_enabled;

3679: --
3680: l_ler_id number ;
3681: begin
3682: --
3683: g_debug := hr_utility.debug_enabled;
3684: if g_debug then
3685: hr_utility.set_location ('Entering :' || l_package,10);
3686: end if;
3687: --

Line 3685: hr_utility.set_location ('Entering :' || l_package,10);

3681: begin
3682: --
3683: g_debug := hr_utility.debug_enabled;
3684: if g_debug then
3685: hr_utility.set_location ('Entering :' || l_package,10);
3686: end if;
3687: --
3688: -- Steps
3689: --

Line 3711: hr_utility.set_location ('Before Step 1',20);

3707: l_ler_id ;
3708: close c_pil;
3709:
3710: if g_debug then
3711: hr_utility.set_location ('Before Step 1',20);
3712: end if;
3713: --
3714: -- Step 1
3715: begin

Line 3737: hr_utility.set_location ('After Step 1',20);

3733: --
3734: end;
3735: --
3736: if g_debug then
3737: hr_utility.set_location ('After Step 1',20);
3738: --
3739: hr_utility.set_location ('Before Step 2 ',20);
3740: end if;
3741: --

Line 3739: hr_utility.set_location ('Before Step 2 ',20);

3735: --
3736: if g_debug then
3737: hr_utility.set_location ('After Step 1',20);
3738: --
3739: hr_utility.set_location ('Before Step 2 ',20);
3740: end if;
3741: --
3742: --Step 2
3743: -- Don't insert for the pil,0,0 record since it is

Line 3781: hr_utility.set_location ('After Step 2 ',20);

3777: --
3778: end;
3779: --
3780: if g_debug then
3781: hr_utility.set_location ('After Step 2 ',20);
3782: --
3783: hr_utility.set_location ('Before Step 3 ',20);
3784: end if;
3785: --

Line 3783: hr_utility.set_location ('Before Step 3 ',20);

3779: --
3780: if g_debug then
3781: hr_utility.set_location ('After Step 2 ',20);
3782: --
3783: hr_utility.set_location ('Before Step 3 ',20);
3784: end if;
3785: --
3786: begin
3787: --

Line 3810: hr_utility.set_location ('After Step 3 ',20);

3806: --
3807: end;
3808: --
3809: if g_debug then
3810: hr_utility.set_location ('After Step 3 ',20);
3811: --
3812: hr_utility.set_location ('Before Calling popu_pel_heir',20);
3813: end if;
3814: --

Line 3812: hr_utility.set_location ('Before Calling popu_pel_heir',20);

3808: --
3809: if g_debug then
3810: hr_utility.set_location ('After Step 3 ',20);
3811: --
3812: hr_utility.set_location ('Before Calling popu_pel_heir',20);
3813: end if;
3814: --
3815: begin
3816: --

Line 3830: hr_utility.set_location ('Before Step 5',20);

3826: --
3827: end;
3828: --
3829: if g_debug then
3830: hr_utility.set_location ('Before Step 5',20);
3831: end if;
3832: --
3833: begin
3834: --

Line 3894: hr_utility.set_location ('Afert Step 5',20);

3890: --
3891: end if;
3892: --
3893: if g_debug then
3894: hr_utility.set_location ('Afert Step 5',20);
3895: hr_utility.set_location ('After Calling popu_pil_heir',20);
3896: hr_utility.set_location ('Leaving : rebuild_heirarchy',30);
3897: end if;
3898: --

Line 3895: hr_utility.set_location ('After Calling popu_pil_heir',20);

3891: end if;
3892: --
3893: if g_debug then
3894: hr_utility.set_location ('Afert Step 5',20);
3895: hr_utility.set_location ('After Calling popu_pil_heir',20);
3896: hr_utility.set_location ('Leaving : rebuild_heirarchy',30);
3897: end if;
3898: --
3899: --

Line 3896: hr_utility.set_location ('Leaving : rebuild_heirarchy',30);

3892: --
3893: if g_debug then
3894: hr_utility.set_location ('Afert Step 5',20);
3895: hr_utility.set_location ('After Calling popu_pil_heir',20);
3896: hr_utility.set_location ('Leaving : rebuild_heirarchy',30);
3897: end if;
3898: --
3899: --
3900: end rebuild_heirarchy ;

Line 3990: hr_utility.set_location ('Entering : ' || l_proc,30);

3986: --
3987: begin
3988: --
3989: if g_debug then
3990: hr_utility.set_location ('Entering : ' || l_proc,30);
3991: end if;
3992: --
3993: -- Create the potential and per in ler in group plan.
3994: --

Line 4029: hr_utility.set_location('l_ws_mgr_id = ' || l_ws_mgr_id, 1234);

4025: p_effective_date => l_effective_date, -- ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
4026: p_manager_id => l_ws_mgr_id,
4027: p_assignment_id => l_assignment_id ) ;
4028: --
4029: hr_utility.set_location('l_ws_mgr_id = ' || l_ws_mgr_id, 1234);
4030: hr_utility.set_location('l_assignment_id = ' || l_assignment_id, 1234);
4031: --
4032: -- Create the group person life event
4033: --

Line 4030: hr_utility.set_location('l_assignment_id = ' || l_assignment_id, 1234);

4026: p_manager_id => l_ws_mgr_id,
4027: p_assignment_id => l_assignment_id ) ;
4028: --
4029: hr_utility.set_location('l_ws_mgr_id = ' || l_ws_mgr_id, 1234);
4030: hr_utility.set_location('l_assignment_id = ' || l_assignment_id, 1234);
4031: --
4032: -- Create the group person life event
4033: --
4034: hr_utility.set_location('group_pl_id = ' || ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id, 1234);

Line 4034: hr_utility.set_location('group_pl_id = ' || ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id, 1234);

4030: hr_utility.set_location('l_assignment_id = ' || l_assignment_id, 1234);
4031: --
4032: -- Create the group person life event
4033: --
4034: hr_utility.set_location('group_pl_id = ' || ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id, 1234);
4035: ben_Person_Life_Event_api.create_Person_Life_Event_perf
4036: (p_validate => false
4037: ,p_per_in_ler_id => l_curr_per_in_ler_id
4038: ,p_ler_id => p_group_ler_id

Line 4061: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 1234);

4057: --
4058: -- Per in ler created is a group per in ler so populate other
4059: -- plan design tables.
4060: --
4061: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 1234);
4062: if p_use_eff_dt_flag = 'Y' then
4063: --
4064: ben_manage_cwb_life_events.popu_cwb_tables(
4065: p_group_per_in_ler_id => l_curr_per_in_ler_id,

Line 4090: hr_utility.set_location('popu_cwb_tables before for loop', 1234);

4086: if nvl(g_cache_cpg_rec.count, 0) = 0 then
4087: --
4088: -- Cache the cwb_person_groups data.
4089: --
4090: hr_utility.set_location('popu_cwb_tables before for loop', 1234);
4091: i := 1;
4092: for l_cpg_rec in c_cpg(p_group_pl_id, p_group_lf_evt_ocrd_dt) loop
4093: --
4094: hr_utility.set_location('popu_cwb_tables for loop i = ' || to_char(i), 1234);

Line 4094: hr_utility.set_location('popu_cwb_tables for loop i = ' || to_char(i), 1234);

4090: hr_utility.set_location('popu_cwb_tables before for loop', 1234);
4091: i := 1;
4092: for l_cpg_rec in c_cpg(p_group_pl_id, p_group_lf_evt_ocrd_dt) loop
4093: --
4094: hr_utility.set_location('popu_cwb_tables for loop i = ' || to_char(i), 1234);
4095: g_cache_cpg_rec(i) := l_cpg_rec;
4096: i := i+1;
4097: --
4098: end loop;

Line 4111: hr_utility.set_location (' populate g_cache_cpg_rec', 1234);

4107: */
4108:
4109: IF NVL (g_cache_cpg_rec.COUNT, 0) = 0
4110: THEN
4111: hr_utility.set_location (' populate g_cache_cpg_rec', 1234);
4112: i := 1;
4113:
4114: FOR l_pl_dsgn IN c_pl_dsgn (g_cache_group_plan_rec.group_pl_id,
4115: g_cache_group_plan_rec.group_lf_evt_ocrd_dt

Line 4282: hr_utility.set_location('Creating missing ben_cwb_person_groups', 1234);

4278: end if;
4279: --
4280: -- create row in ben_cwb_person_groups
4281: --
4282: hr_utility.set_location('Creating missing ben_cwb_person_groups', 1234);
4283: insert into ben_cwb_person_groups
4284: (group_per_in_ler_id,
4285: group_pl_id ,
4286: group_oipl_id ,

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

4397: end loop;
4398: end if;
4399: --
4400: if g_debug then
4401: hr_utility.set_location ('Leaving : ' || l_proc,30);
4402: end if;
4403: end popu_missing_person_pil;
4404: --
4405: procedure popu_cwb_group_pil_data (

Line 4461: hr_utility.set_location('Entering popu_cwb_group_pil_data', 10);

4457: --
4458: begin
4459: --
4460: if g_debug then
4461: hr_utility.set_location('Entering popu_cwb_group_pil_data', 10);
4462: hr_utility.set_location('= ' ||p_group_per_in_ler_id , 1234);
4463: hr_utility.set_location('= ' ||p_group_pl_id , 1234);
4464: hr_utility.set_location('= ' ||p_group_lf_evt_ocrd_dt , 1234);
4465: hr_utility.set_location('= ' ||p_group_business_group_id , 1234);

Line 4462: hr_utility.set_location('= ' ||p_group_per_in_ler_id , 1234);

4458: begin
4459: --
4460: if g_debug then
4461: hr_utility.set_location('Entering popu_cwb_group_pil_data', 10);
4462: hr_utility.set_location('= ' ||p_group_per_in_ler_id , 1234);
4463: hr_utility.set_location('= ' ||p_group_pl_id , 1234);
4464: hr_utility.set_location('= ' ||p_group_lf_evt_ocrd_dt , 1234);
4465: hr_utility.set_location('= ' ||p_group_business_group_id , 1234);
4466: hr_utility.set_location('= ' ||p_group_ler_id , 1234);

Line 4463: hr_utility.set_location('= ' ||p_group_pl_id , 1234);

4459: --
4460: if g_debug then
4461: hr_utility.set_location('Entering popu_cwb_group_pil_data', 10);
4462: hr_utility.set_location('= ' ||p_group_per_in_ler_id , 1234);
4463: hr_utility.set_location('= ' ||p_group_pl_id , 1234);
4464: hr_utility.set_location('= ' ||p_group_lf_evt_ocrd_dt , 1234);
4465: hr_utility.set_location('= ' ||p_group_business_group_id , 1234);
4466: hr_utility.set_location('= ' ||p_group_ler_id , 1234);
4467: end if;

Line 4464: hr_utility.set_location('= ' ||p_group_lf_evt_ocrd_dt , 1234);

4460: if g_debug then
4461: hr_utility.set_location('Entering popu_cwb_group_pil_data', 10);
4462: hr_utility.set_location('= ' ||p_group_per_in_ler_id , 1234);
4463: hr_utility.set_location('= ' ||p_group_pl_id , 1234);
4464: hr_utility.set_location('= ' ||p_group_lf_evt_ocrd_dt , 1234);
4465: hr_utility.set_location('= ' ||p_group_business_group_id , 1234);
4466: hr_utility.set_location('= ' ||p_group_ler_id , 1234);
4467: end if;
4468: /*

Line 4465: hr_utility.set_location('= ' ||p_group_business_group_id , 1234);

4461: hr_utility.set_location('Entering popu_cwb_group_pil_data', 10);
4462: hr_utility.set_location('= ' ||p_group_per_in_ler_id , 1234);
4463: hr_utility.set_location('= ' ||p_group_pl_id , 1234);
4464: hr_utility.set_location('= ' ||p_group_lf_evt_ocrd_dt , 1234);
4465: hr_utility.set_location('= ' ||p_group_business_group_id , 1234);
4466: hr_utility.set_location('= ' ||p_group_ler_id , 1234);
4467: end if;
4468: /*
4469: popu_missing_pil(p_mode, p_group_pl_business_group_id, p_group_pl_id,

Line 4466: hr_utility.set_location('= ' ||p_group_ler_id , 1234);

4462: hr_utility.set_location('= ' ||p_group_per_in_ler_id , 1234);
4463: hr_utility.set_location('= ' ||p_group_pl_id , 1234);
4464: hr_utility.set_location('= ' ||p_group_lf_evt_ocrd_dt , 1234);
4465: hr_utility.set_location('= ' ||p_group_business_group_id , 1234);
4466: hr_utility.set_location('= ' ||p_group_ler_id , 1234);
4467: end if;
4468: /*
4469: popu_missing_pil(p_mode, p_group_pl_business_group_id, p_group_pl_id,
4470: p_group_ler_id, p_effective_date, p_lf_evt_ocrd_dt)

Line 4530: hr_utility.set_location(' popu_cwb_group_pil_data : per id = ' || l_rec.person_id, 10);

4526: for l_rec in c_missing_group_pils loop
4527: --
4528: -- Populate group pil and associated data for this person.
4529: --
4530: hr_utility.set_location(' popu_cwb_group_pil_data : per id = ' || l_rec.person_id, 10);
4531: if p_use_eff_dt_flag = 'N' then
4532: --
4533: popu_missing_person_pil(
4534: p_mode => 'ABCD',

Line 4592: hr_utility.set_location('Leaving popu_cwb_group_pil_data', 10);

4588: --
4589: end loop;
4590: --
4591: if g_debug then
4592: hr_utility.set_location('Leaving popu_cwb_group_pil_data', 10);
4593: end if;
4594: end popu_cwb_group_pil_data;
4595: --
4596: procedure global_online_process_w

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

4619: l_cache_group_plan_rec_temp g_cache_group_plan_type;
4620: --
4621: begin
4622: --
4623: hr_utility.set_location ('Entering '||l_proc,10);
4624: l_effective_date := to_char(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
4625: l_lf_evt_ocrd_dt := to_char(nvl(p_lf_evt_ocrd_dt,p_effective_date),'YYYY/MM/DD HH24:MI:SS');
4626: --
4627: fnd_msg_pub.initialize;

Line 4633: hr_utility.set_location ('Before : p_backout_global_cwb_event ',10);

4629: -- If backout is requested then first back out and call online.
4630: --
4631: if p_backout_and_process_flag = 'Y' then
4632: --
4633: hr_utility.set_location ('Before : p_backout_global_cwb_event ',10);
4634: ben_cwb_back_out_conc.p_backout_global_cwb_event(
4635: p_effective_date => p_lf_evt_ocrd_dt
4636: ,p_validate => p_validate
4637: ,p_business_group_id => p_business_group_id

Line 4762: hr_utility.set_location ('Entering :sum_oipl_rates_and_upd_pl_rate ' ,10);

4758: --
4759: begin
4760: --
4761: if g_debug then
4762: hr_utility.set_location ('Entering :sum_oipl_rates_and_upd_pl_rate ' ,10);
4763: end if;
4764: --
4765: -- Fetch all ben_cwb_person_rates for the person
4766: -- for the plan, for lf_evt_ocrd_dt if there exists oipl for this plan

Line 4810: hr_utility.set_location ('Leaving :sum_oipl_rates_and_upd_pl_rate ' ,10);

4806: end loop;
4807: --
4808: end if;
4809: if g_debug then
4810: hr_utility.set_location ('Leaving :sum_oipl_rates_and_upd_pl_rate ' ,10);
4811: end if;
4812: --
4813: end sum_oipl_rates_and_upd_pl_rate;
4814: --

Line 4875: hr_utility.set_location ('Entering :auto_allocate_budgets ' ,10);

4871: l_pop_cd varchar2(30);
4872: --
4873: begin
4874: if g_debug then
4875: hr_utility.set_location ('Entering :auto_allocate_budgets ' ,10);
4876: end if;
4877: --
4878: for l_high_mgr_cpg_rec in c_high_mgr_cpg(p_group_pl_id , p_lf_evt_ocrd_dt )
4879: loop

Line 4960: hr_utility.set_location ('Leaving :auto_allocate_budgets ' ,10);

4956: --
4957: end loop;
4958: --
4959: if g_debug then
4960: hr_utility.set_location ('Leaving :auto_allocate_budgets ' ,10);
4961: end if;
4962: --
4963: end auto_allocate_budgets;
4964: --