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

Line 9: g_debug boolean := hr_utility.debug_enabled;

5: -- ----------------------------------------------------------------------------
6: --
7: --
8: g_package varchar2(33) := ' ben_ext_person.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10:
11: TYPE t_number IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
12: TYPE t_varchar2_30 IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
13: TYPE t_varchar2_600 IS TABLE OF VARCHAR2(600) INDEX BY BINARY_INTEGER;

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

58: --
59: Begin
60: if g_debug then
61: l_proc := g_package||'get_pay_adv_crit_dates';
62: hr_utility.set_location('Entering'||l_proc, 5);
63: end if;
64:
65: l_cad_exist := 'N' ;
66: l_ced_exist := 'N' ;

Line 71: hr_utility.set_location('oper cd '||i.oper_cd, 5);

67:
68: for i in c1
69: Loop
70:
71: hr_utility.set_location('oper cd '||i.oper_cd, 5);
72: hr_utility.set_location('crit_typ_cd cd '||i.crit_typ_cd, 5);
73:
74: l_from_date := ben_ext_util.calc_ext_date
75: (p_ext_date_cd => i.val_1,

Line 72: hr_utility.set_location('crit_typ_cd cd '||i.crit_typ_cd, 5);

68: for i in c1
69: Loop
70:
71: hr_utility.set_location('oper cd '||i.oper_cd, 5);
72: hr_utility.set_location('crit_typ_cd cd '||i.crit_typ_cd, 5);
73:
74: l_from_date := ben_ext_util.calc_ext_date
75: (p_ext_date_cd => i.val_1,
76: p_abs_date => p_effective_date,

Line 149: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);

145: p_act_from_dt := l_act_from_dt;
146: p_act_to_dt := l_act_to_dt ;
147: p_date_mode := 'C' ;
148:
149: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);
150: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);
151: hr_utility.set_location('Exiting for C eot bot '||l_proc, 15);
152:
153: Return ;

Line 150: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);

146: p_act_to_dt := l_act_to_dt ;
147: p_date_mode := 'C' ;
148:
149: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);
150: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);
151: hr_utility.set_location('Exiting for C eot bot '||l_proc, 15);
152:
153: Return ;
154: end if ;

Line 151: hr_utility.set_location('Exiting for C eot bot '||l_proc, 15);

147: p_date_mode := 'C' ;
148:
149: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);
150: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);
151: hr_utility.set_location('Exiting for C eot bot '||l_proc, 15);
152:
153: Return ;
154: end if ;
155:

Line 163: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);

159: p_act_from_dt := l_act_from_dt;
160: p_act_to_dt := l_act_to_dt ;
161: p_date_mode := 'C' ;
162:
163: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);
164: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);
165: hr_utility.set_location('Exiting for C no ced '||l_proc, 15);
166:
167: Return ;

Line 164: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);

160: p_act_to_dt := l_act_to_dt ;
161: p_date_mode := 'C' ;
162:
163: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);
164: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);
165: hr_utility.set_location('Exiting for C no ced '||l_proc, 15);
166:
167: Return ;
168:

Line 165: hr_utility.set_location('Exiting for C no ced '||l_proc, 15);

161: p_date_mode := 'C' ;
162:
163: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);
164: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);
165: hr_utility.set_location('Exiting for C no ced '||l_proc, 15);
166:
167: Return ;
168:
169: end if ;

Line 187: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);

183: p_eff_from_dt := l_eff_from_dt;
184: p_eff_to_dt := l_eff_to_dt ;
185: p_date_mode := 'E' ;
186:
187: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);
188: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);
189: hr_utility.set_location('Exiting for E eot bot '||l_proc, 15);
190:
191: Return ;

Line 188: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);

184: p_eff_to_dt := l_eff_to_dt ;
185: p_date_mode := 'E' ;
186:
187: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);
188: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);
189: hr_utility.set_location('Exiting for E eot bot '||l_proc, 15);
190:
191: Return ;
192: end if ;

Line 189: hr_utility.set_location('Exiting for E eot bot '||l_proc, 15);

185: p_date_mode := 'E' ;
186:
187: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);
188: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);
189: hr_utility.set_location('Exiting for E eot bot '||l_proc, 15);
190:
191: Return ;
192: end if ;
193:

Line 201: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);

197: p_eff_from_dt := l_eff_from_dt;
198: p_eff_to_dt := l_eff_to_dt ;
199: p_date_mode := 'E' ;
200:
201: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);
202: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);
203: hr_utility.set_location('Exiting for no cad '||l_proc, 15);
204:
205: Return ;

Line 202: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);

198: p_eff_to_dt := l_eff_to_dt ;
199: p_date_mode := 'E' ;
200:
201: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);
202: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);
203: hr_utility.set_location('Exiting for no cad '||l_proc, 15);
204:
205: Return ;
206:

Line 203: hr_utility.set_location('Exiting for no cad '||l_proc, 15);

199: p_date_mode := 'E' ;
200:
201: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);
202: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);
203: hr_utility.set_location('Exiting for no cad '||l_proc, 15);
204:
205: Return ;
206:
207: end if ;

Line 223: hr_utility.set_location('act_from_dt '|| p_act_from_dt , 15);

219:
220: End if ;
221:
222:
223: hr_utility.set_location('act_from_dt '|| p_act_from_dt , 15);
224: hr_utility.set_location('act_to_dt '|| p_act_to_dt , 15);
225: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);
226: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);
227:

Line 224: hr_utility.set_location('act_to_dt '|| p_act_to_dt , 15);

220: End if ;
221:
222:
223: hr_utility.set_location('act_from_dt '|| p_act_from_dt , 15);
224: hr_utility.set_location('act_to_dt '|| p_act_to_dt , 15);
225: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);
226: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);
227:
228: hr_utility.set_location('node '|| p_date_mode , 15);

Line 225: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);

221:
222:
223: hr_utility.set_location('act_from_dt '|| p_act_from_dt , 15);
224: hr_utility.set_location('act_to_dt '|| p_act_to_dt , 15);
225: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);
226: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);
227:
228: hr_utility.set_location('node '|| p_date_mode , 15);
229: if g_debug then

Line 226: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);

222:
223: hr_utility.set_location('act_from_dt '|| p_act_from_dt , 15);
224: hr_utility.set_location('act_to_dt '|| p_act_to_dt , 15);
225: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);
226: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);
227:
228: hr_utility.set_location('node '|| p_date_mode , 15);
229: if g_debug then
230: hr_utility.set_location('Exiting'||l_proc, 15);

Line 228: hr_utility.set_location('node '|| p_date_mode , 15);

224: hr_utility.set_location('act_to_dt '|| p_act_to_dt , 15);
225: hr_utility.set_location('eff_from_dt '|| p_eff_from_dt , 15);
226: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);
227:
228: hr_utility.set_location('node '|| p_date_mode , 15);
229: if g_debug then
230: hr_utility.set_location('Exiting'||l_proc, 15);
231: end if;
232:

Line 230: hr_utility.set_location('Exiting'||l_proc, 15);

226: hr_utility.set_location('eff_to_dt '|| p_eff_to_dt , 15);
227:
228: hr_utility.set_location('node '|| p_date_mode , 15);
229: if g_debug then
230: hr_utility.set_location('Exiting'||l_proc, 15);
231: end if;
232:
233: End get_pay_adv_crit_dates ;
234:

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

270:
271: begin
272: if g_debug then
273: l_proc := g_package||'Check_assg_info';
274: hr_utility.set_location('Entering'||l_proc, 5);
275: end if;
276:
277: open c_asg ;
278: fetch c_Asg into p_assignment_id ;

Line 299: hr_utility.set_location('assignment_id : ' || p_assignment_id , 99 );

295:
296: end if ;
297:
298: if g_debug then
299: hr_utility.set_location('assignment_id : ' || p_assignment_id , 99 );
300: hr_utility.set_location('Exiting'||l_proc, 15);
301: end if;
302: end Check_assg_info;
303:

Line 300: hr_utility.set_location('Exiting'||l_proc, 15);

296: end if ;
297:
298: if g_debug then
299: hr_utility.set_location('assignment_id : ' || p_assignment_id , 99 );
300: hr_utility.set_location('Exiting'||l_proc, 15);
301: end if;
302: end Check_assg_info;
303:
304:

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

322: --
323: Begin
324: if g_debug then
325: l_proc := g_package||'init_assignment_id';
326: hr_utility.set_location('Entering'||l_proc, 5);
327: end if;
328: -- p_asg id param added to validate a particular id
329: if p_assignment_id is not null then
330: l_assignment_id := p_assignment_id ;

Line 337: hr_utility.set_location('rqd '|| ben_ext_evaluate_inclusion.g_asg_to_use_rqd, 99 );

333: --if the assignment to use code is not defined then use
334: -- empl, benefit,applicant order
335:
336: if g_debug then
337: hr_utility.set_location('rqd '|| ben_ext_evaluate_inclusion.g_asg_to_use_rqd, 99 );
338: end if;
339: if ben_ext_evaluate_inclusion.g_asg_to_use_rqd = 'Y' then
340: l_asg_to_use_cd := ben_ext_evaluate_inclusion.g_asg_to_use_list(1) ;
341: if g_debug then

Line 342: hr_utility.set_location('order by user '|| l_asg_to_use_cd, 99 );

338: end if;
339: if ben_ext_evaluate_inclusion.g_asg_to_use_rqd = 'Y' then
340: l_asg_to_use_cd := ben_ext_evaluate_inclusion.g_asg_to_use_list(1) ;
341: if g_debug then
342: hr_utility.set_location('order by user '|| l_asg_to_use_cd, 99 );
343: end if;
344: end if ;
345:
346: if l_asg_to_use_cd is null then

Line 351: hr_utility.set_location(' ass cd ' || l_asg_to_use_cd, 99 );

347: l_asg_to_use_cd := 'EBAC' ; -- hardcoded default
348: -- Emp/BEN/Appl/Cont
349: end if ;
350: if g_debug then
351: hr_utility.set_location(' ass cd ' || l_asg_to_use_cd, 99 );
352: end if;
353:
354: ----determine the kind of assignment
355: if l_asg_to_use_cd = 'EAO' then

Line 465: hr_utility.set_location('assignment_id : ' || g_assignment_id , 99 );

461: ---intialise the global assignment_id
462: g_assignment_id := l_assignment_id ;
463:
464: if g_debug then
465: hr_utility.set_location('assignment_id : ' || g_assignment_id , 99 );
466: hr_utility.set_location('Exiting'||l_proc, 15);
467: end if;
468:
469: End init_assignment_id ;

Line 466: hr_utility.set_location('Exiting'||l_proc, 15);

462: g_assignment_id := l_assignment_id ;
463:
464: if g_debug then
465: hr_utility.set_location('assignment_id : ' || g_assignment_id , 99 );
466: hr_utility.set_location('Exiting'||l_proc, 15);
467: end if;
468:
469: End init_assignment_id ;
470: --

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

581: Begin
582: --
583: if g_debug then
584: l_proc := g_package||'get_person_info';
585: hr_utility.set_location('Entering'||l_proc, 5);
586: end if;
587: --
588: open c_person_info;
589: fetch c_person_info into

Line 691: hr_utility.set_location('Global BG ' || ben_ext_person.g_business_group_id|| ' / ' ||ben_extract.g_proc_business_group_id,99) ;

687: if g_ext_global_flag = 'Y' then
688: ben_ext_person.g_business_group_id := l_business_group_id ;
689: ben_extract.g_business_group_name := l_business_group_name ;
690: end if ;
691: hr_utility.set_location('Global BG ' || ben_ext_person.g_business_group_id|| ' / ' ||ben_extract.g_proc_business_group_id,99) ;
692:
693: ---initalize the assignment_id as soon the person information avaialble
694: init_assignment_id(p_person_id =>p_person_id ,
695: p_effective_date =>p_effective_date );

Line 698: hr_utility.set_location('Tobacco Usage '||g_uses_tobacco_flag, 5);

694: init_assignment_id(p_person_id =>p_person_id ,
695: p_effective_date =>p_effective_date );
696:
697: if g_debug then
698: hr_utility.set_location('Tobacco Usage '||g_uses_tobacco_flag, 5);
699: hr_utility.set_location('Exiting'||l_proc, 15);
700: end if;
701: --
702: --

Line 699: hr_utility.set_location('Exiting'||l_proc, 15);

695: p_effective_date =>p_effective_date );
696:
697: if g_debug then
698: hr_utility.set_location('Tobacco Usage '||g_uses_tobacco_flag, 5);
699: hr_utility.set_location('Exiting'||l_proc, 15);
700: end if;
701: --
702: --
703: end get_person_info;

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

710: l_proc varchar2(72) := g_package||'get_pos_info';
711: --
712: begin
713: if g_debug then
714: hr_utility.set_location('Entering'||l_proc, 5);
715: end if;
716:
717: select
718: pos.name,

Line 746: hr_utility.set_location('Exiting'||l_proc, 15);

742: where pos.position_id = p_position_id
743: and p_effective_date between pos.EFFECTIVE_START_DATE and pos.EFFECTIVE_END_DATE ;
744:
745: if g_debug then
746: hr_utility.set_location('Exiting'||l_proc, 15);
747: end if;
748:
749: end get_pos_info ;
750:

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

756: l_proc varchar2(72) := g_package||'get_job_info';
757: --
758: begin
759: if g_debug then
760: hr_utility.set_location('Entering'||l_proc, 5);
761: end if;
762: select
763: j.name,
764: j.attribute1,

Line 790: hr_utility.set_location('Exiting'||l_proc, 15);

786: from per_jobs_vl j
787: where j.job_id = p_job_id;
788:
789: if g_debug then
790: hr_utility.set_location('Exiting'||l_proc, 15);
791: end if;
792:
793: end get_job_info ;
794:

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

801: l_proc varchar2(72) := g_package||'get_payroll_info';
802: --
803: begin
804: if g_debug then
805: hr_utility.set_location('Entering'||l_proc, 5);
806: end if;
807:
808: select
809: pay.payroll_name,

Line 866: hr_utility.set_location('Exiting'||l_proc, 15);

862:
863:
864:
865: if g_debug then
866: hr_utility.set_location('Exiting'||l_proc, 15);
867: end if;
868:
869: end get_payroll_info ;
870:

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

877: l_proc varchar2(72) := g_package||'get_grade_info';
878: --
879: begin
880: if g_debug then
881: hr_utility.set_location('Entering'||l_proc, 5);
882: end if;
883:
884:
885: select

Line 913: hr_utility.set_location('Exiting'||l_proc, 15);

909: from per_grades_vl g
910: where g.grade_id = p_grade_id;
911:
912: if g_debug then
913: hr_utility.set_location('Exiting'||l_proc, 15);
914: end if;
915:
916: end get_grade_info ;
917:

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

945:
946: --
947: begin
948: if g_debug then
949: hr_utility.set_location('Entering'||l_proc, 5);
950: end if;
951:
952: open c_org ;
953: fetch c_org into l_location_id ;

Line 973: hr_utility.set_location('Exiting'||l_proc, 15);

969:
970: close c_loc_info ;
971: end if ;
972: if g_debug then
973: hr_utility.set_location('Exiting'||l_proc, 15);
974: end if;
975:
976: end get_org_loc_info ;
977:

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

988: l_proc varchar2(72) := g_package||'get_loc_info';
989: --
990: begin
991: if g_debug then
992: hr_utility.set_location('Entering'||l_proc, 5);
993: end if;
994:
995: select
996: l.location_code,

Line 1042: hr_utility.set_location('Exiting'||l_proc, 15);

1038: where l.location_id = p_location_id;
1039:
1040:
1041: if g_debug then
1042: hr_utility.set_location('Exiting'||l_proc, 15);
1043: end if;
1044:
1045: end get_loc_info ;
1046:

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

1132: l_assignment_id number ;
1133: Begin
1134: --
1135: if g_debug then
1136: hr_utility.set_location('Entering'||l_proc, 5);
1137: end if;
1138: --
1139: open c_asg_info (p_assignment_id);
1140: fetch c_asg_info into

Line 1197: hr_utility.set_location('Payroll id '||g_payroll_id, 5);

1193:
1194: close c_asg_info;
1195:
1196: if g_debug then
1197: hr_utility.set_location('Payroll id '||g_payroll_id, 5);
1198: end if;
1199:
1200: begin
1201: if g_employee_grade_id is not null

Line 1204: hr_utility.set_location('asg Grade'||g_employee_grade_id, 5);

1200: begin
1201: if g_employee_grade_id is not null
1202: then
1203: if g_debug then
1204: hr_utility.set_location('asg Grade'||g_employee_grade_id, 5);
1205: end if;
1206:
1207: get_grade_info (p_grade_id => g_employee_grade_id,
1208: p_effective_date => p_effective_date );

Line 1214: hr_utility.set_location('asg Location'||g_location_id , 5);

1210: end if;
1211:
1212: if g_location_id is not null then
1213: if g_debug then
1214: hr_utility.set_location('asg Location'||g_location_id , 5);
1215: end if;
1216: get_loc_info (p_location_id => g_location_id,
1217: p_effective_date => p_effective_date );
1218:

Line 1223: hr_utility.set_location('Asg Position'||g_position_id, 5);

1219: end if;
1220:
1221: if g_position_id is not null then
1222: if g_debug then
1223: hr_utility.set_location('Asg Position'||g_position_id, 5);
1224: end if;
1225: get_pos_info (p_position_id => g_position_id,
1226: p_effective_date => p_effective_date ) ;
1227: end if;

Line 1231: hr_utility.set_location('Asg Job'||g_job_id, 5);

1227: end if;
1228:
1229: if g_job_id is not null then
1230: if g_debug then
1231: hr_utility.set_location('Asg Job'||g_job_id, 5);
1232: end if;
1233: get_job_info (p_job_id => g_job_id,
1234: p_effective_date => p_effective_date );
1235: end if;

Line 1239: hr_utility.set_location('asg pay'||g_payroll_id, 5);

1235: end if;
1236:
1237: if g_payroll_id is not null then
1238: if g_debug then
1239: hr_utility.set_location('asg pay'||g_payroll_id, 5);
1240: end if;
1241:
1242: get_payroll_info (p_payroll_id => g_payroll_id,
1243: p_effective_date => p_effective_date );

Line 1248: hr_utility.set_location('Emp org '||g_employee_organization_id, 5);

1244: end if;
1245:
1246: if g_employee_organization_id is not null then
1247: if g_debug then
1248: hr_utility.set_location('Emp org '||g_employee_organization_id, 5);
1249: end if;
1250:
1251: get_org_loc_info (p_org_id => g_employee_organization_id,
1252: p_effective_date => p_effective_date );

Line 1259: hr_utility.set_location('NO_DATA_FOUND IN ASG CHILD ', 5) ;

1255:
1256: Exception
1257: When NO_DATA_FOUND then
1258: if g_debug then
1259: hr_utility.set_location('NO_DATA_FOUND IN ASG CHILD ', 5) ;
1260: end if;
1261: g_err_num := 94102 ;
1262: g_err_name := 'BEN_94102_EXT_ERROR_ON_ASG' ;
1263:

Line 1269: hr_utility.set_location('asg type '|| g_asg_type, 99 );

1265: Raise ;
1266:
1267: end;
1268: if g_debug then
1269: hr_utility.set_location('asg type '|| g_asg_type, 99 );
1270: hr_utility.set_location('Exiting'||l_proc, 15);
1271: end if;
1272: --
1273: --

Line 1270: hr_utility.set_location('Exiting'||l_proc, 15);

1266:
1267: end;
1268: if g_debug then
1269: hr_utility.set_location('asg type '|| g_asg_type, 99 );
1270: hr_utility.set_location('Exiting'||l_proc, 15);
1271: end if;
1272: --
1273: --
1274: end get_assignment_info;

Line 1303: hr_utility.set_location('Entering'||l_proc, 15);

1299:
1300: Begin
1301: if g_debug then
1302: l_proc := g_package||'get_School_info';
1303: hr_utility.set_location('Entering'||l_proc, 15);
1304: end if;
1305: open c_school ;
1306: fetch c_school into g_ESTABLISHMENT_name ;
1307: if c_school%notfound then

Line 1313: hr_utility.set_location('Exiting'||l_proc, 15);

1309: end if ;
1310: close c_school ;
1311:
1312: if g_debug then
1313: hr_utility.set_location('Exiting'||l_proc, 15);
1314: end if;
1315: end get_School_info;
1316:
1317:

Line 1353: hr_utility.set_location('Entering'||l_proc, 15);

1349:
1350: begin
1351: if g_debug then
1352: l_proc := g_package||'get_base_annual_salary_info_info';
1353: hr_utility.set_location('Entering'||l_proc, 15);
1354: end if;
1355:
1356: open c (p_person_id ) ;
1357: fetch c into lc ;

Line 1361: hr_utility.set_location(' salary ' || g_base_salary , 936);

1357: fetch c into lc ;
1358: close c ;
1359: g_base_salary := lc.pay_annualization_factor * lc.proposed_salary_n ;
1360: if g_debug then
1361: hr_utility.set_location(' salary ' || g_base_salary , 936);
1362: hr_utility.set_location('Exiting'||l_proc, 15);
1363: end if;
1364: end get_base_annual_salary_info;
1365:

Line 1362: hr_utility.set_location('Exiting'||l_proc, 15);

1358: close c ;
1359: g_base_salary := lc.pay_annualization_factor * lc.proposed_salary_n ;
1360: if g_debug then
1361: hr_utility.set_location(' salary ' || g_base_salary , 936);
1362: hr_utility.set_location('Exiting'||l_proc, 15);
1363: end if;
1364: end get_base_annual_salary_info;
1365:
1366:

Line 1409: hr_utility.set_location('Entering'||l_proc, 15);

1405:
1406: begin
1407: if g_debug then
1408: l_proc := g_package||'get_person_flex_credit';
1409: hr_utility.set_location('Entering'||l_proc, 15);
1410: end if;
1411:
1412: -- the fLex cedit calcualted in person level
1413: if g_debug then

Line 1414: hr_utility.set_location('entering to open flex credit ' ,160);

1410: end if;
1411:
1412: -- the fLex cedit calcualted in person level
1413: if g_debug then
1414: hr_utility.set_location('entering to open flex credit ' ,160);
1415: end if;
1416: open flex_cred_info_c;
1417: fetch flex_cred_info_c into ben_ext_person.g_flex_credit_provided
1418: ,ben_ext_person.g_flex_credit_forfited

Line 1426: hr_utility.set_location('provided amount '|| ben_ext_person.g_flex_credit_provided ,160);

1422: nvl(ben_ext_person.g_flex_credit_forfited,0) -
1423: nvl(ben_ext_person.g_flex_credit_used,0);
1424: close flex_cred_info_c;
1425: if g_debug then
1426: hr_utility.set_location('provided amount '|| ben_ext_person.g_flex_credit_provided ,160);
1427: hr_utility.set_location('used amount '|| ben_ext_person.g_flex_credit_used ,160);
1428: hr_utility.set_location('Exiting'||l_proc, 15);
1429: end if;
1430:

Line 1427: hr_utility.set_location('used amount '|| ben_ext_person.g_flex_credit_used ,160);

1423: nvl(ben_ext_person.g_flex_credit_used,0);
1424: close flex_cred_info_c;
1425: if g_debug then
1426: hr_utility.set_location('provided amount '|| ben_ext_person.g_flex_credit_provided ,160);
1427: hr_utility.set_location('used amount '|| ben_ext_person.g_flex_credit_used ,160);
1428: hr_utility.set_location('Exiting'||l_proc, 15);
1429: end if;
1430:
1431: end get_person_flex_credit;

Line 1428: hr_utility.set_location('Exiting'||l_proc, 15);

1424: close flex_cred_info_c;
1425: if g_debug then
1426: hr_utility.set_location('provided amount '|| ben_ext_person.g_flex_credit_provided ,160);
1427: hr_utility.set_location('used amount '|| ben_ext_person.g_flex_credit_used ,160);
1428: hr_utility.set_location('Exiting'||l_proc, 15);
1429: end if;
1430:
1431: end get_person_flex_credit;
1432:

Line 1458: hr_utility.set_location('Entering'||l_proc, 15);

1454: and effective_end_date ;
1455: begin
1456: if g_debug then
1457: l_proc := g_package||'get_supervisor_info';
1458: hr_utility.set_location('Entering'||l_proc, 15);
1459: end if;
1460:
1461: open c_sup_info ;
1462: fetch c_sup_info into

Line 1468: hr_utility.set_location('Exiting'||l_proc, 15);

1464: g_sup_employee_number ;
1465: close c_sup_info ;
1466:
1467: if g_debug then
1468: hr_utility.set_location('Exiting'||l_proc, 15);
1469: end if;
1470: end get_supervisor_info;
1471:
1472:

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

1555: Begin
1556: --
1557: if g_debug then
1558: l_proc := g_package||'get_primary_address_info';
1559: hr_utility.set_location('Entering'||l_proc, 5);
1560: end if;
1561: --
1562: open c_prmy_address;
1563: fetch c_prmy_address into

Line 1608: hr_utility.set_location('Exiting'||l_proc, 15);

1604: close c_prmy_address;
1605: --
1606: --
1607: if g_debug then
1608: hr_utility.set_location('Exiting'||l_proc, 15);
1609: end if;
1610: --
1611: end get_primary_address_info;
1612: --

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

1652: Begin
1653: --
1654: if g_debug then
1655: l_proc := g_package||'get_mailing_address_info';
1656: hr_utility.set_location('Entering'||l_proc, 5);
1657: end if;
1658: --
1659: open c_mail_address;
1660: fetch c_mail_address into

Line 1677: hr_utility.set_location('Exiting'||l_proc, 15);

1673: --
1674: close c_mail_address;
1675: --
1676: if g_debug then
1677: hr_utility.set_location('Exiting'||l_proc, 15);
1678: end if;
1679: --
1680: end get_mailing_address_info;
1681: --

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

1734: Begin
1735: --
1736: if g_debug then
1737: l_proc := g_package||'get_comm_address_info';
1738: hr_utility.set_location('Entering'||l_proc, 5);
1739: end if;
1740: --
1741: --
1742: IF p_address_id is not null then

Line 1814: hr_utility.set_location('Exiting'||l_proc, 15);

1810: close c_prim_rltd_address;
1811: --
1812: End if;
1813: if g_debug then
1814: hr_utility.set_location('Exiting'||l_proc, 15);
1815: end if;
1816: --
1817: end get_comm_address_info;
1818: --

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

1912: Begin
1913: --
1914: if g_debug then
1915: l_proc := g_package||'get_phone_info';
1916: hr_utility.set_location('Entering'||l_proc, 5);
1917: end if;
1918: --
1919: open c_phone;
1920: fetch c_phone into

Line 1927: hr_utility.set_location(' looking phone ' || g_phone_home , 99 );

1923: g_phone_fax,
1924: g_phone_mobile,
1925: g_phone_pager
1926: ;
1927: hr_utility.set_location(' looking phone ' || g_phone_home , 99 );
1928: if c_phone%notfound or
1929: (g_phone_home is null and g_phone_work is null and g_phone_fax is null and g_phone_mobile is null) then
1930: hr_utility.set_location(' looking for related phone ' || p_person_id , 99 );
1931: -- get related person information

Line 1930: hr_utility.set_location(' looking for related phone ' || p_person_id , 99 );

1926: ;
1927: hr_utility.set_location(' looking phone ' || g_phone_home , 99 );
1928: if c_phone%notfound or
1929: (g_phone_home is null and g_phone_work is null and g_phone_fax is null and g_phone_mobile is null) then
1930: hr_utility.set_location(' looking for related phone ' || p_person_id , 99 );
1931: -- get related person information
1932: open c_rltd_phone;
1933: fetch c_rltd_phone into
1934: g_phone_home,

Line 1940: hr_utility.set_location(' home related phone ' || g_phone_home , 99 );

1936: g_phone_fax,
1937: g_phone_mobile
1938: ;
1939: close c_rltd_phone;
1940: hr_utility.set_location(' home related phone ' || g_phone_home , 99 );
1941: end if ;
1942: --
1943: close c_phone;
1944: --

Line 1946: hr_utility.set_location('Exiting'||l_proc, 15);

1942: --
1943: close c_phone;
1944: --
1945: if g_debug then
1946: hr_utility.set_location('Exiting'||l_proc, 15);
1947: end if;
1948: --
1949: end get_phone_info;
1950: --

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

1988: Begin
1989: --
1990: if g_debug then
1991: l_proc := g_package||'get_period_of_svc_info';
1992: hr_utility.set_location('Entering'||l_proc, 5);
1993: end if;
1994: --
1995: open c_period_of_svc;
1996: fetch c_period_of_svc into

Line 2020: hr_utility.set_location('Exiting'||l_proc, 15);

2016: ;
2017: close c_period_of_svc;
2018: --
2019: if g_debug then
2020: hr_utility.set_location('Exiting'||l_proc, 15);
2021: end if;
2022: --
2023: end get_period_of_svc_info;
2024: --

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

2051: Begin
2052: --
2053: if g_debug then
2054: l_proc := g_package||'get_svc_area_info';
2055: hr_utility.set_location('Entering'||l_proc, 5);
2056: end if;
2057: --
2058: open c_prmy_svc_area;
2059: fetch c_prmy_svc_area into ben_ext_person.g_prim_addr_sva_id,

Line 2064: hr_utility.set_location('Exiting'||l_proc, 15);

2060: ben_ext_person.g_prim_addr_service_area;
2061: close c_prmy_svc_area;
2062: --
2063: if g_debug then
2064: hr_utility.set_location('Exiting'||l_proc, 15);
2065: end if;
2066: --
2067: end get_svc_area_info;
2068: --

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

2105: Begin
2106: --
2107: if g_debug then
2108: l_proc := g_package||'get_started_ler_info';
2109: hr_utility.set_location('Entering'||l_proc, 5);
2110: end if;
2111: --
2112: open c_started_ler;
2113: fetch c_started_ler into

Line 2132: hr_utility.set_location('Exiting'||l_proc, 15);

2128: g_ler_attr_10;
2129: close c_started_ler;
2130: --
2131: if g_debug then
2132: hr_utility.set_location('Exiting'||l_proc, 15);
2133: end if;
2134: --
2135: end get_started_ler_info;
2136: --

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

2160: Begin
2161: --
2162: if g_debug then
2163: l_proc := g_package||'get_bnfts_group_info';
2164: hr_utility.set_location('Entering'||l_proc, 5);
2165: end if;
2166: --
2167: open c_bnfts_group;
2168: fetch c_bnfts_group into

Line 2183: hr_utility.set_location('Exiting'||l_proc, 15);

2179: g_bng_flex_10;
2180: close c_bnfts_group;
2181: --
2182: if g_debug then
2183: hr_utility.set_location('Exiting'||l_proc, 15);
2184: end if;
2185: --
2186: end get_bnfts_group_info;
2187: --

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

2245: Begin
2246: --
2247: if g_debug then
2248: l_proc := g_package||'get_absence_info';
2249: hr_utility.set_location('Entering'||l_proc, 5);
2250: hr_utility.set_location('bug 4208'||p_person_id , 4208);
2251: end if;
2252: --
2253:

Line 2250: hr_utility.set_location('bug 4208'||p_person_id , 4208);

2246: --
2247: if g_debug then
2248: l_proc := g_package||'get_absence_info';
2249: hr_utility.set_location('Entering'||l_proc, 5);
2250: hr_utility.set_location('bug 4208'||p_person_id , 4208);
2251: end if;
2252: --
2253:
2254: open c_absence;

Line 2288: hr_utility.set_location('Exiting'||l_proc, 15);

2284: g_abs_reason_cd; -- Bug 2841958, extra column in cursor
2285: close abs_reason;
2286: --
2287: if g_debug then
2288: hr_utility.set_location('Exiting'||l_proc, 15);
2289: end if;
2290: --
2291: end get_absence_info;
2292: --

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

2336: Begin
2337: --
2338: if g_debug then
2339: l_proc := g_package||'get_cobra_info';
2340: hr_utility.set_location('Entering'||l_proc, 5);
2341: end if;
2342: --
2343: -- get cobra information
2344: --

Line 2368: hr_utility.set_location('Exiting'||l_proc, 15);

2364: end if;
2365: close cbra_info_c;
2366: --
2367: if g_debug then
2368: hr_utility.set_location('Exiting'||l_proc, 15);
2369: end if;
2370: --
2371: end get_cobra_info;
2372: --

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

2394: Begin
2395: --
2396: if g_debug then
2397: l_proc := g_package||'get_bnfts_bal_info';
2398: hr_utility.set_location('Entering'||l_proc, 5);
2399: end if;
2400: --
2401: -- Vacation
2402: --

Line 2448: hr_utility.set_location('Exiting'||l_proc, 15);

2444: END IF;
2445: --
2446: --
2447: if g_debug then
2448: hr_utility.set_location('Exiting'||l_proc, 15);
2449: end if;
2450: --
2451: end get_bnfts_bal_info;
2452:

Line 2466: g_debug := hr_utility.debug_enabled;

2462: l_proc varchar2(72);
2463:
2464: begin
2465:
2466: g_debug := hr_utility.debug_enabled;
2467: if g_debug then
2468: l_proc := g_package||' Extract_person_info';
2469: hr_utility.set_location('Entering'||l_proc, 5);
2470: end if;

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

2465:
2466: g_debug := hr_utility.debug_enabled;
2467: if g_debug then
2468: l_proc := g_package||' Extract_person_info';
2469: hr_utility.set_location('Entering'||l_proc, 5);
2470: end if;
2471:
2472:
2473: get_person_info (p_person_id => p_person_id,

Line 2477: hr_utility.set_location('asg level ' || ben_extract.g_asg_csr,99);

2473: get_person_info (p_person_id => p_person_id,
2474: p_effective_date => g_person_ext_dt);
2475: --
2476: if g_debug then
2477: hr_utility.set_location('asg level ' || ben_extract.g_asg_csr,99);
2478: end if;
2479: if ben_extract.g_asg_csr = 'Y' then
2480: get_assignment_info (p_person_id => p_person_id,
2481: p_assignment_id => g_assignment_id,

Line 2579: hr_utility.set_location('Exiting'||l_proc, 15);

2575:
2576:
2577: --
2578: if g_debug then
2579: hr_utility.set_location('Exiting'||l_proc, 15);
2580: end if;
2581: --
2582:
2583: End Extract_person_info ;

Line 3161: g_debug := hr_utility.debug_enabled;

3157:
3158:
3159: Begin
3160: --
3161: g_debug := hr_utility.debug_enabled;
3162: if g_debug then
3163: l_proc := g_package||'process_ext_person';
3164: hr_utility.set_location('Entering'||l_proc, 5);
3165: end if;

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

3160: --
3161: g_debug := hr_utility.debug_enabled;
3162: if g_debug then
3163: l_proc := g_package||'process_ext_person';
3164: hr_utility.set_location('Entering'||l_proc, 5);
3165: end if;
3166:
3167: --
3168: -- Get general extract info

Line 3280: hr_utility.set_location( 'chg actl date ' || l_chg_actl_strt_dt || ' / ' || l_chg_actl_end_dt, 99 );

3276: l_chg_actl_strt_dt := ben_ext_thread.g_actual_start_date ;
3277: l_chg_actl_end_dt := ben_ext_thread.g_actual_end_date ;
3278: end if ;
3279:
3280: hr_utility.set_location( 'chg actl date ' || l_chg_actl_strt_dt || ' / ' || l_chg_actl_end_dt, 99 );
3281: hr_utility.set_location( 'chg eff date ' || l_chg_eff_strt_dt || ' / ' || l_chg_eff_end_dt , 99 );
3282: --
3283: if ben_ext_thread.g_chg_ext_from_ben = 'Y' then
3284: hr_utility.set_location( ' extract chg evt log included ' , 99 );

Line 3281: hr_utility.set_location( 'chg eff date ' || l_chg_eff_strt_dt || ' / ' || l_chg_eff_end_dt , 99 );

3277: l_chg_actl_end_dt := ben_ext_thread.g_actual_end_date ;
3278: end if ;
3279:
3280: hr_utility.set_location( 'chg actl date ' || l_chg_actl_strt_dt || ' / ' || l_chg_actl_end_dt, 99 );
3281: hr_utility.set_location( 'chg eff date ' || l_chg_eff_strt_dt || ' / ' || l_chg_eff_end_dt , 99 );
3282: --
3283: if ben_ext_thread.g_chg_ext_from_ben = 'Y' then
3284: hr_utility.set_location( ' extract chg evt log included ' , 99 );
3285: open c_changes_only_extract (l_chg_actl_strt_dt,

Line 3284: hr_utility.set_location( ' extract chg evt log included ' , 99 );

3280: hr_utility.set_location( 'chg actl date ' || l_chg_actl_strt_dt || ' / ' || l_chg_actl_end_dt, 99 );
3281: hr_utility.set_location( 'chg eff date ' || l_chg_eff_strt_dt || ' / ' || l_chg_eff_end_dt , 99 );
3282: --
3283: if ben_ext_thread.g_chg_ext_from_ben = 'Y' then
3284: hr_utility.set_location( ' extract chg evt log included ' , 99 );
3285: open c_changes_only_extract (l_chg_actl_strt_dt,
3286: l_chg_actl_end_dt,
3287: l_chg_eff_strt_dt,
3288: l_chg_eff_end_dt);

Line 3388: hr_utility.set_location(' Change Event Code ' || g_chg_evt_cd , 99 );

3384: --
3385: -- Not really sure what this hard coding is all about, should be investigated. th.
3386: --
3387: if g_debug then
3388: hr_utility.set_location(' Change Event Code ' || g_chg_evt_cd , 99 );
3389: end if;
3390: --BBurns Bug 1745274. Set context for AD and DD also on line below.
3391: /*
3392: CODE PRIOR TO WWBUG: 2008949

Line 3443: hr_utility.set_location(' l name ' || g_previous_last_name , 99 );

3439: g_previous_suffix := g_chg_old_val6;
3440: end if ;
3441:
3442: if g_debug then
3443: hr_utility.set_location(' l name ' || g_previous_last_name , 99 );
3444: hr_utility.set_location(' f name ' || g_previous_first_name , 99 );
3445: hr_utility.set_location(' m name ' || g_previous_middle_name , 99 );
3446: end if;
3447:

Line 3444: hr_utility.set_location(' f name ' || g_previous_first_name , 99 );

3440: end if ;
3441:
3442: if g_debug then
3443: hr_utility.set_location(' l name ' || g_previous_last_name , 99 );
3444: hr_utility.set_location(' f name ' || g_previous_first_name , 99 );
3445: hr_utility.set_location(' m name ' || g_previous_middle_name , 99 );
3446: end if;
3447:
3448: ELSIF g_chg_evt_cd = 'CONS' THEN

Line 3445: hr_utility.set_location(' m name ' || g_previous_middle_name , 99 );

3441:
3442: if g_debug then
3443: hr_utility.set_location(' l name ' || g_previous_last_name , 99 );
3444: hr_utility.set_location(' f name ' || g_previous_first_name , 99 );
3445: hr_utility.set_location(' m name ' || g_previous_middle_name , 99 );
3446: end if;
3447:
3448: ELSIF g_chg_evt_cd = 'CONS' THEN
3449: g_previous_prefix := g_chg_old_val1 ;

Line 3504: hr_utility.set_location( ' PAY event log included ' , 99 );

3500: end if ; --- for extract chg logs
3501:
3502:
3503: if ben_ext_thread.g_chg_ext_from_pay = 'Y' then
3504: hr_utility.set_location( ' PAY event log included ' , 99 );
3505: -- Loop thorough all the assignment id for a person
3506: -- within the extract period
3507: --- get the primary assg as of effective date
3508: init_assignment_id(p_person_id => p_person_id ,

Line 3520: hr_utility.set_location('pay adv condition mode ' ||g_pay_adv_date_mode , 66 );

3516: If ben_ext_evaluate_inclusion.g_chg_actl_dt_incl_rqd = 'N' and
3517: ben_ext_evaluate_inclusion.g_chg_eff_dt_incl_rqd = 'N' and
3518: ben_ext_evaluate_inclusion.g_cmbn_incl_rqd = 'Y' then
3519:
3520: hr_utility.set_location('pay adv condition mode ' ||g_pay_adv_date_mode , 66 );
3521: if g_pay_adv_date_mode is null then
3522: hr_utility.set_location('pay adv condition exisit withoutot other criteria' , 66 );
3523: get_pay_adv_crit_dates(
3524: p_ext_crit_prfl_id => p_ext_crit_prfl_id,

Line 3522: hr_utility.set_location('pay adv condition exisit withoutot other criteria' , 66 );

3518: ben_ext_evaluate_inclusion.g_cmbn_incl_rqd = 'Y' then
3519:
3520: hr_utility.set_location('pay adv condition mode ' ||g_pay_adv_date_mode , 66 );
3521: if g_pay_adv_date_mode is null then
3522: hr_utility.set_location('pay adv condition exisit withoutot other criteria' , 66 );
3523: get_pay_adv_crit_dates(
3524: p_ext_crit_prfl_id => p_ext_crit_prfl_id,
3525: p_ext_dfn_id => p_ext_dfn_id,
3526: p_business_group_id => p_business_group_id,

Line 3543: hr_utility.set_location(' pay assg id ' ||pasg.Assignment_id , 66 ) ;

3539: for pasg in c_pay_p_asg(p_person_id , nvl(l_chg_eff_strt_dt,nvl(l_chg_actl_strt_dt,p_effective_date)),
3540: nvl(l_chg_eff_end_dt,nvl(l_chg_actl_end_dt,p_effective_date))
3541: )
3542: Loop
3543: hr_utility.set_location(' pay assg id ' ||pasg.Assignment_id , 66 ) ;
3544:
3545: open c_pay_asg_date (pasg.Assignment_id) ;
3546: fetch c_pay_asg_date into l_pay_asg_eff_date ;
3547: close c_pay_asg_date ;

Line 3548: hr_utility.set_location(' pay assg date ' ||l_pay_asg_eff_date , 66 ) ;

3544:
3545: open c_pay_asg_date (pasg.Assignment_id) ;
3546: fetch c_pay_asg_date into l_pay_asg_eff_date ;
3547: close c_pay_asg_date ;
3548: hr_utility.set_location(' pay assg date ' ||l_pay_asg_eff_date , 66 ) ;
3549: hr_utility.set_location(' pay actual start date ' ||l_chg_actl_strt_dt , 66 ) ;
3550:
3551: -- determine the assignment before call the interpreter
3552: init_assignment_id(p_person_id => p_person_id ,

Line 3549: hr_utility.set_location(' pay actual start date ' ||l_chg_actl_strt_dt , 66 ) ;

3545: open c_pay_asg_date (pasg.Assignment_id) ;
3546: fetch c_pay_asg_date into l_pay_asg_eff_date ;
3547: close c_pay_asg_date ;
3548: hr_utility.set_location(' pay assg date ' ||l_pay_asg_eff_date , 66 ) ;
3549: hr_utility.set_location(' pay actual start date ' ||l_chg_actl_strt_dt , 66 ) ;
3550:
3551: -- determine the assignment before call the interpreter
3552: init_assignment_id(p_person_id => p_person_id ,
3553: p_effective_date => l_pay_asg_eff_date ,

Line 3585: hr_utility.set_location('adv effective date mode '||g_pay_adv_eff_from_dt||'/'||

3581: Begin
3582:
3583:
3584: if g_pay_adv_date_mode = 'B' or g_pay_adv_date_mode = 'E' then
3585: hr_utility.set_location('adv effective date mode '||g_pay_adv_eff_from_dt||'/'||
3586: g_pay_adv_eff_to_dt,99) ;
3587:
3588: l_eff_event_ecount := 0 ;
3589: l_eff_event_scount := 0 ;

Line 3603: hr_utility.set_location( 'number of result ' ||l_pay_detail_tab.count, 99 ) ;

3599: ,p_process_mode => 'ENTRY_EFFECTIVE_DATE'
3600: ,p_penserv_mode => p_penserv_mode -- vkodedal - changes for penserver -30-apr-2008
3601: );
3602:
3603: hr_utility.set_location( 'number of result ' ||l_pay_detail_tab.count, 99 ) ;
3604:
3605: -- get the starting count of total colection for comparison
3606: l_eff_event_scount := l_pay_tot_Srno ;
3607:

Line 3613: hr_utility.set_location(' insertining tot '|| l_pay_tot_Srno|| ' / '

3609: -- collect all the information onto a table for process for a person
3610: FOR l_pay IN l_pay_detail_tab.FIRST..l_pay_detail_tab.LAST
3611: LOOP
3612:
3613: hr_utility.set_location(' insertining tot '|| l_pay_tot_Srno|| ' / '
3614: ||l_pay_detail_tab(l_pay).column_name,99) ;
3615:
3616: l_pay_detail_tot_tab(l_pay_tot_Srno).dated_table_id
3617: := l_pay_detail_tab(l_pay).dated_table_id ;

Line 3653: hr_utility.set_location('adv actual date mode '||g_pay_adv_act_from_dt||' / ' ||

3649: if g_pay_adv_date_mode = 'B' or g_pay_adv_date_mode = 'C' then
3650: -- get the total count of srno for efficient comaprison
3651: l_eff_event_ecount := l_pay_detail_tot_tab.count ;
3652: l_pay_detail_tab.delete ;
3653: hr_utility.set_location('adv actual date mode '||g_pay_adv_act_from_dt||' / ' ||
3654: g_pay_adv_act_to_dt,99) ;
3655: ben_ext_util.entries_affected
3656: (p_assignment_id => l_pay_Assignment_id
3657: ,p_event_group_id => i.event_group_id

Line 3670: hr_utility.set_location( 'number of result ' ||l_pay_detail_tab.count, 99 ) ;

3666: );
3667:
3668:
3669:
3670: hr_utility.set_location( 'number of result ' ||l_pay_detail_tab.count, 99 ) ;
3671:
3672: if l_pay_detail_tab.count > 0 then
3673:
3674: -- collect all the information onto a table for process for a person

Line 3720: hr_utility.set_location(' insertining tot '|| l_pay_tot_Srno|| ' / '

3716:
3717: --- if the entry is unique then create
3718: if l_g_c_found = 'N' then
3719:
3720: hr_utility.set_location(' insertining tot '|| l_pay_tot_Srno|| ' / '
3721: ||l_pay_detail_tab(l_pay).column_name,99) ;
3722:
3723: l_pay_detail_tot_tab(l_pay_tot_Srno).dated_table_id
3724: := l_pay_detail_tab(l_pay).dated_table_id ;

Line 3758: IF hr_utility.get_message = 'BEN_94629_NO_ASG_ACTION_ID' THEN

3754: end if;
3755: Exception
3756: WHEN hr_application_error THEN
3757: -- the exception handled only when thge pqp raise the error with the msg
3758: IF hr_utility.get_message = 'BEN_94629_NO_ASG_ACTION_ID' THEN
3759: hr_utility.set_location( 'Current assignment has no Assignment Action id. ' ,-9999);
3760: g_err_num := 94629 ;
3761: g_err_name := 'BEN_94629_NO_ASG_ACTION_ID' ;
3762: g_elmt_name:= null ;

Line 3759: hr_utility.set_location( 'Current assignment has no Assignment Action id. ' ,-9999);

3755: Exception
3756: WHEN hr_application_error THEN
3757: -- the exception handled only when thge pqp raise the error with the msg
3758: IF hr_utility.get_message = 'BEN_94629_NO_ASG_ACTION_ID' THEN
3759: hr_utility.set_location( 'Current assignment has no Assignment Action id. ' ,-9999);
3760: g_err_num := 94629 ;
3761: g_err_name := 'BEN_94629_NO_ASG_ACTION_ID' ;
3762: g_elmt_name:= null ;
3763: raise detail_restart_error ;

Line 3765: hr_utility.set_location( 'unknow exception raised in pqp.',-9999);

3761: g_err_name := 'BEN_94629_NO_ASG_ACTION_ID' ;
3762: g_elmt_name:= null ;
3763: raise detail_restart_error ;
3764: else
3765: hr_utility.set_location( 'unknow exception raised in pqp.',-9999);
3766: raise; -- to re-raise the exception
3767: end if ;
3768:
3769: End ;

Line 3782: hr_utility.set_location('pay actual dt mode '||trunc(l_chg_actl_strt_dt)||' / '||

3778: -- as per my understanding from PQP - ram
3779: -- since the actual date has the time stamp , the time stamp play the role in extracting info
3780: -- so the from date is truncated and to date is extended to the last second of the day
3781:
3782: hr_utility.set_location('pay actual dt mode '||trunc(l_chg_actl_strt_dt)||' / '||
3783: (trunc(l_chg_actl_end_dt)+0.99999) , 66 );
3784:
3785: ben_ext_util.entries_affected
3786: (p_assignment_id => l_pay_Assignment_id

Line 3804: hr_utility.set_location(' pay effectivedt mode ' ||(l_chg_eff_strt_dt-1) || ' / ' ||

3800: -- payroll exclude the from date data for proration purpose ,
3801: --the interpreter developerd for proration
3802: -- then used for reporting so the functionality remains the same
3803: -- we are passing -1 to make sure the from date data is included
3804: hr_utility.set_location(' pay effectivedt mode ' ||(l_chg_eff_strt_dt-1) || ' / ' ||
3805: l_chg_eff_end_dt , 66 ) ;
3806: ben_ext_util.entries_affected
3807: (p_assignment_id => l_pay_Assignment_id
3808: ,p_event_group_id => i.event_group_id

Line 3822: IF hr_utility.get_message = 'BEN_94629_NO_ASG_ACTION_ID' THEN

3818: end if ;
3819: Exception
3820: WHEN hr_application_error THEN
3821: -- the exception handled only when thge pqp raise the error with the msg
3822: IF hr_utility.get_message = 'BEN_94629_NO_ASG_ACTION_ID' THEN
3823: hr_utility.set_location( 'Current assignment has no Assignment Action id. ' ,-9999);
3824: g_err_num := 94629 ;
3825: g_err_name := 'BEN_94629_NO_ASG_ACTION_ID' ;
3826: g_elmt_name:= null ;

Line 3823: hr_utility.set_location( 'Current assignment has no Assignment Action id. ' ,-9999);

3819: Exception
3820: WHEN hr_application_error THEN
3821: -- the exception handled only when thge pqp raise the error with the msg
3822: IF hr_utility.get_message = 'BEN_94629_NO_ASG_ACTION_ID' THEN
3823: hr_utility.set_location( 'Current assignment has no Assignment Action id. ' ,-9999);
3824: g_err_num := 94629 ;
3825: g_err_name := 'BEN_94629_NO_ASG_ACTION_ID' ;
3826: g_elmt_name:= null ;
3827: raise detail_restart_error ;

Line 3829: hr_utility.set_location( 'unknow exception raised in ben_ext_util.entries_affected.',-9999);

3825: g_err_name := 'BEN_94629_NO_ASG_ACTION_ID' ;
3826: g_elmt_name:= null ;
3827: raise detail_restart_error ;
3828: else
3829: hr_utility.set_location( 'unknow exception raised in ben_ext_util.entries_affected.',-9999);
3830: raise; -- to re-raise the exception
3831: end if ;
3832: End ;
3833:

Line 3834: hr_utility.set_location( 'number of result ' ||l_pay_detail_tab.count, 99 ) ;

3830: raise; -- to re-raise the exception
3831: end if ;
3832: End ;
3833:
3834: hr_utility.set_location( 'number of result ' ||l_pay_detail_tab.count, 99 ) ;
3835: if l_pay_detail_tab.count > 0 then
3836:
3837: -- collect all the information onto a table for process for a person
3838: FOR l_pay IN l_pay_detail_tab.FIRST..l_pay_detail_tab.LAST

Line 3841: hr_utility.set_location(' insertining tot '|| l_pay_tot_Srno|| ' / ' ||

3837: -- collect all the information onto a table for process for a person
3838: FOR l_pay IN l_pay_detail_tab.FIRST..l_pay_detail_tab.LAST
3839: LOOP
3840:
3841: hr_utility.set_location(' insertining tot '|| l_pay_tot_Srno|| ' / ' ||
3842: l_pay_detail_tab(l_pay).column_name,99) ;
3843:
3844: l_pay_detail_tot_tab(l_pay_tot_Srno).dated_table_id := l_pay_detail_tab(l_pay).dated_table_id ;
3845: l_pay_detail_tot_tab(l_pay_tot_Srno).datetracked_event

Line 3873: hr_utility.set_location('insertining GL '||l_pay_evt_srno||' / '||

3869: end if ;
3870: End loop ;
3871: -- if the value not already exist
3872: if l_g_c_found = 'N' then
3873: hr_utility.set_location('insertining GL '||l_pay_evt_srno||' / '||
3874: l_pay_detail_tab(l_pay).column_name,99) ;
3875: g_pay_evt_group_tab(l_pay_evt_srno).dated_table_id:=l_pay_detail_tab(l_pay).dated_table_id ;
3876: g_pay_evt_group_tab(l_pay_evt_srno).column_name := l_pay_detail_tab(l_pay).column_name ;
3877: g_pay_evt_group_tab(l_pay_evt_srno).event_group_id := i.event_group_id ;

Line 3898: hr_utility.set_location( 'number of sorted result ' ||g_pay_proc_evt_tab.count, 99 ) ;

3894: ben_ext_payroll_balance.sort_payroll_events
3895: (p_pay_events_tab => l_pay_detail_tot_tab ) ;
3896:
3897: -- process the collected nformation for a person
3898: hr_utility.set_location( 'number of sorted result ' ||g_pay_proc_evt_tab.count, 99 ) ;
3899: if g_pay_proc_evt_tab.count > 0 then
3900: FOR l_pay IN 1 .. g_pay_proc_evt_tab.count
3901: LOOP
3902: init_detail_globals;

Line 3904: hr_utility.set_location( ' column name ' ||g_pay_proc_evt_tab(l_pay).column_name

3900: FOR l_pay IN 1 .. g_pay_proc_evt_tab.count
3901: LOOP
3902: init_detail_globals;
3903:
3904: hr_utility.set_location( ' column name ' ||g_pay_proc_evt_tab(l_pay).column_name
3905: ||' / '||g_pay_proc_evt_tab(l_pay).dated_table_id , 99 );
3906:
3907: l_dated_table_id := g_pay_proc_evt_tab(l_pay).dated_table_id ;
3908: g_chg_pay_column := g_pay_proc_evt_tab(l_pay).column_name ;

Line 3920: hr_utility.set_location(' pay chg index '||g_chg_pay_evt_index,99) ;

3916: g_chg_next_event_date := g_pay_proc_evt_tab(l_pay).next_evt_start_date ;
3917: g_chg_actl_dt := g_pay_proc_evt_tab(l_pay).actual_date ;
3918: g_chg_pay_evt_index := l_pay ;
3919:
3920: hr_utility.set_location(' pay chg index '||g_chg_pay_evt_index,99) ;
3921: hr_utility.set_location('date and end date '||g_person_id||'-'||g_chg_eff_dt||'/'||
3922: g_chg_next_event_date,99) ;
3923: g_chg_evt_source := 'PAY' ;
3924: ben_ext_util.get_ext_dates

Line 3921: hr_utility.set_location('date and end date '||g_person_id||'-'||g_chg_eff_dt||'/'||

3917: g_chg_actl_dt := g_pay_proc_evt_tab(l_pay).actual_date ;
3918: g_chg_pay_evt_index := l_pay ;
3919:
3920: hr_utility.set_location(' pay chg index '||g_chg_pay_evt_index,99) ;
3921: hr_utility.set_location('date and end date '||g_person_id||'-'||g_chg_eff_dt||'/'||
3922: g_chg_next_event_date,99) ;
3923: g_chg_evt_source := 'PAY' ;
3924: ben_ext_util.get_ext_dates
3925: (p_ext_dfn_id => p_ext_dfn_id,

Line 3956: hr_utility.set_location( ' Inclusion flag ' || l_include , 99 ) ;

3952: p_include => l_include);
3953: --
3954: end if; -- p_ext_crit_prfl_id is not null
3955: --
3956: hr_utility.set_location( ' Inclusion flag ' || l_include , 99 ) ;
3957: hr_utility.set_location( ' actual ' || g_chg_actl_dt , 99 ) ;
3958: hr_utility.set_location( ' efective ' || g_chg_eff_dt , 99 ) ;
3959:
3960: if l_include = 'Y' then

Line 3957: hr_utility.set_location( ' actual ' || g_chg_actl_dt , 99 ) ;

3953: --
3954: end if; -- p_ext_crit_prfl_id is not null
3955: --
3956: hr_utility.set_location( ' Inclusion flag ' || l_include , 99 ) ;
3957: hr_utility.set_location( ' actual ' || g_chg_actl_dt , 99 ) ;
3958: hr_utility.set_location( ' efective ' || g_chg_eff_dt , 99 ) ;
3959:
3960: if l_include = 'Y' then
3961: --

Line 3958: hr_utility.set_location( ' efective ' || g_chg_eff_dt , 99 ) ;

3954: end if; -- p_ext_crit_prfl_id is not null
3955: --
3956: hr_utility.set_location( ' Inclusion flag ' || l_include , 99 ) ;
3957: hr_utility.set_location( ' actual ' || g_chg_actl_dt , 99 ) ;
3958: hr_utility.set_location( ' efective ' || g_chg_eff_dt , 99 ) ;
3959:
3960: if l_include = 'Y' then
3961: --
3962:

Line 3995: hr_utility.set_location(' Change Event Code ' || g_chg_evt_cd , 99 );

3991: end if; -- l_include = 'Y'
3992: --
3993: if l_include = 'Y' THEN
3994: if g_debug then
3995: hr_utility.set_location(' Change Event Code ' || g_chg_evt_cd , 99 );
3996: end if;
3997: g_rcd_seq := 1;
3998: --
3999: if nvl(ben_extract.g_spcl_hndl_flag,'X') <> 'Y' then -- normal processing

Line 4278: hr_utility.set_location('cwb person ' || l_cwb.person_id , 99 ) ;

4274: for l_cwb in c_cwb_extract
4275: Loop
4276: g_CWB_EFFECTIVE_DATE := l_cwb.effective_date ;
4277: g_CWB_LE_DT := l_cwb.LF_EVT_OCRD_DT ;
4278: hr_utility.set_location('cwb person ' || l_cwb.person_id , 99 ) ;
4279: ben_ext_util.get_ext_dates
4280: (p_ext_dfn_id => p_ext_dfn_id,
4281: p_data_typ_cd => p_data_typ_cd,
4282: p_effective_date => g_effective_date,

Line 4608: hr_utility.set_location('Exiting'||l_proc, 15);

4604:
4605: END IF; -- extract type
4606:
4607: if g_debug then
4608: hr_utility.set_location('Exiting'||l_proc, 15);
4609: end if;
4610: --
4611: EXCEPTION
4612: --

Line 4618: hr_utility.set_location('err msg ' || l_err_message, 99.98 );

4614: --
4615: ROLLBACK TO cur_transaction;
4616: l_err_message := ben_ext_fmt.get_error_msg(g_err_num,g_err_name,g_elmt_name ) ;
4617: if g_debug then
4618: hr_utility.set_location('err msg ' || l_err_message, 99.98 );
4619: end if;
4620: write_error(
4621: p_err_num => g_err_num,
4622: p_err_name => l_err_message,

Line 4633: hr_utility.set_location('err msg ' || l_err_message, 99.98 );

4629:
4630: ROLLBACK TO cur_transaction;
4631: l_err_message := ben_ext_fmt.get_error_msg(g_err_num,g_err_name,g_elmt_name ) ;
4632: if g_debug then
4633: hr_utility.set_location('err msg ' || l_err_message, 99.98 );
4634: end if;
4635: write_error(
4636: p_err_num => g_err_num,
4637: p_err_name => l_err_message,

Line 4732: g_debug := hr_utility.debug_enabled;

4728:
4729: --
4730: begin
4731: --
4732: g_debug := hr_utility.debug_enabled;
4733: if g_debug then
4734: l_proc := g_package||'process_ext_levels';
4735: hr_utility.set_location('Entering'||l_proc, 5);
4736: end if;

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

4731: --
4732: g_debug := hr_utility.debug_enabled;
4733: if g_debug then
4734: l_proc := g_package||'process_ext_levels';
4735: hr_utility.set_location('Entering'||l_proc, 5);
4736: end if;
4737: --
4738: -- Initialize rollback flag.
4739: --

Line 4743: hr_utility.set_location('ben_extract.g_per_lvl ' || ben_extract.g_per_lvl ,99 );

4739: --
4740: l_rollback:=FALSE;
4741:
4742: if g_debug then
4743: hr_utility.set_location('ben_extract.g_per_lvl ' || ben_extract.g_per_lvl ,99 );
4744: end if;
4745: --
4746: IF ben_extract.g_per_lvl = 'Y' THEN
4747: --

Line 4752: hr_utility.set_location(' ben_ext_fmt.process_ext_recs',99 );

4748: -- Process Personal Level Detail Records
4749: --
4750: --
4751: if g_debug then
4752: hr_utility.set_location(' ben_ext_fmt.process_ext_recs',99 );
4753: end if;
4754: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,
4755: p_ext_file_id => p_ext_file_id,
4756: p_data_typ_cd => p_data_typ_cd,

Line 4781: hr_utility.set_location(' ben_ext_enrt.main',99 );

4777: IF (ben_extract.g_enrt_lvl = 'Y' OR ben_extract.g_dpnt_lvl = 'Y' OR ben_extract.g_bnf_lvl = 'Y' OR
4778: ben_extract.g_actn_lvl = 'Y' or ben_extract.g_prem_lvl = 'Y' ) THEN
4779: --
4780: if g_debug then
4781: hr_utility.set_location(' ben_ext_enrt.main',99 );
4782: end if;
4783: ben_ext_enrt.main(
4784: p_person_id => p_person_id,
4785: p_ext_rslt_id => p_ext_rslt_id,

Line 4909: hr_utility.set_location( ' bdgt lvl ' || ben_extract.g_cwb_bdgt_lvl , 99 );

4905:
4906: --- cwb
4907: if p_data_typ_cd = 'CW' THEN
4908:
4909: hr_utility.set_location( ' bdgt lvl ' || ben_extract.g_cwb_bdgt_lvl , 99 );
4910:
4911: if ben_extract.g_cwb_bdgt_lvl = 'Y' then
4912: ben_ext_cwb.extract_person_groups
4913: ( p_person_id => p_person_id,

Line 4974: hr_utility.set_location('Mandatory failed '||ben_extract.gtt_rcd_rqd_vals_seq(i).low_lvl_cd || ' '||

4970: -- validate the mandatory for low level in sequenc
4971: FOR i in ben_extract.gtt_rcd_rqd_vals_seq.first .. ben_extract.gtt_rcd_rqd_vals_seq.last LOOP
4972: --
4973: If NOT ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found THEN
4974: hr_utility.set_location('Mandatory failed '||ben_extract.gtt_rcd_rqd_vals_seq(i).low_lvl_cd || ' '||
4975: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);
4976: l_rollback := TRUE; -- raise required_error;
4977: end if ;
4978: if ben_extract.gtt_rcd_rqd_vals_seq(1).low_lvl_cd <> 'NOREQDRCD' then

Line 4989: hr_utility.set_location('Exiting'||l_proc, 15);

4985: RAISE required_error;
4986: END IF;
4987: --
4988: if g_debug then
4989: hr_utility.set_location('Exiting'||l_proc, 15);
4990: end if;
4991: --
4992: --
4993: End process_ext_levels;

Line 5008: g_debug := hr_utility.debug_enabled;

5004: --
5005: --
5006: begin
5007: --
5008: g_debug := hr_utility.debug_enabled;
5009: if g_debug then
5010: l_proc := g_package||'init_detail_globals';
5011: hr_utility.set_location('Entering'||l_proc, 5);
5012: end if;

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

5007: --
5008: g_debug := hr_utility.debug_enabled;
5009: if g_debug then
5010: l_proc := g_package||'init_detail_globals';
5011: hr_utility.set_location('Entering'||l_proc, 5);
5012: end if;
5013: --
5014: --
5015: -- personal (25)

Line 5532: hr_utility.set_location('Exiting'||l_proc, 15);

5528: -- subheader
5529: g_group_elmt_value1 := null ;
5530: g_group_elmt_value2 := null ;
5531: if g_debug then
5532: hr_utility.set_location('Exiting'||l_proc, 15);
5533: end if;
5534: --
5535: End init_detail_globals;
5536: --

Line 5558: g_debug := hr_utility.debug_enabled;

5554: --
5555: --
5556: begin
5557: --
5558: g_debug := hr_utility.debug_enabled;
5559: if g_debug then
5560: l_proc := g_package||'write_error';
5561: hr_utility.set_location('Entering'||l_proc, 5);
5562: hr_utility.set_location('error message ' || p_err_name,99.97);

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

5557: --
5558: g_debug := hr_utility.debug_enabled;
5559: if g_debug then
5560: l_proc := g_package||'write_error';
5561: hr_utility.set_location('Entering'||l_proc, 5);
5562: hr_utility.set_location('error message ' || p_err_name,99.97);
5563: end if;
5564: --
5565: open err_cnt_c;

Line 5562: hr_utility.set_location('error message ' || p_err_name,99.97);

5558: g_debug := hr_utility.debug_enabled;
5559: if g_debug then
5560: l_proc := g_package||'write_error';
5561: hr_utility.set_location('Entering'||l_proc, 5);
5562: hr_utility.set_location('error message ' || p_err_name,99.97);
5563: end if;
5564: --
5565: open err_cnt_c;
5566: fetch err_cnt_c into l_err_num;

Line 5595: hr_utility.set_location('Exiting'||l_proc, 15);

5591: --
5592: end if;
5593: --
5594: if g_debug then
5595: hr_utility.set_location('Exiting'||l_proc, 15);
5596: end if;
5597: --
5598: end write_error;
5599: --