DBA Data[Home] [Help]

APPS.BEN_DET_WAIT_PERD_CMPLTN dependencies on HR_UTILITY

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

85: l_per_rec per_all_people_f%rowtype;
86: --
87: begin
88: --
89: hr_utility.set_location('Entering : ' || l_proc, 10);
90: --
91: ben_person_object.get_object(p_person_id => p_person_id,
92: p_rec => l_per_rec);
93: --

Line 118: hr_utility.set_location('Using OSD', 10);

114: -- Overriden Service Date.
115: --
116: if l_ovrid_svc_dt is not null then
117: --
118: hr_utility.set_location('Using OSD', 10);
119: --
120: l_return_date := l_ovrid_svc_dt;
121: --
122: -- Set flag so that the search stops.

Line 137: hr_utility.set_location('Using ASD', 10);

133: -- Adjusted service date.
134: --
135: if l_adj_svc_dt is not null then
136: --
137: hr_utility.set_location('Using ASD', 10);
138: --
139: l_return_date := l_adj_svc_dt;
140: --
141: -- Set flag so that the search stops.

Line 156: hr_utility.set_location('Using DOH', 10);

152: -- Date of Hire.
153: --
154: if l_hire_date is not null then
155: --
156: hr_utility.set_location('Using DOH', 10);
157: --
158: l_return_date := l_hire_date;
159: --
160: end if;

Line 168: hr_utility.set_location('Using OHD', 10);

164: else
165: --
166: -- Date code is Original Hire Date.
167: --
168: hr_utility.set_location('Using OHD', 10);
169: --
170: l_return_date := l_orig_hire_date;
171: --
172: end if;

Line 177: hr_utility.set_location('ERROR. Unable to calculate service date : ' ||

173: --
174: /*
175: if l_return_date is null then
176: --
177: hr_utility.set_location('ERROR. Unable to calculate service date : ' ||
178: p_date_code, 10);
179: --
180: fnd_message.set_name('BEN', 'BEN_92197_CANT_CALC_SVC_DATE');
181: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

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

185: --
186: end if;
187: */
188: --
189: hr_utility.set_location('Leaving : ' || l_proc, 10);
190: --
191: return l_return_date;
192: --
193: end get_per_svc_dt;

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

211: L_aei_rec per_assignment_extra_info%rowtype;
212: l_proc varchar2(80) := g_package||'.get_ben_asg_dt';
213:
214: begin
215: hr_utility.set_location('Entering : ' || l_proc, 10);
216: --
217: -- Get the ovrid_svc_dt from the cache.
218: --
219: l_ovrid_svc_dt := ben_derive_part_and_rate_facts.

Line 286: hr_utility.set_location('ERROR in ' || l_proc, 10);

282: --
283: /*
284: if l_return_date is null then
285: --
286: hr_utility.set_location('ERROR in ' || l_proc, 10);
287: --
288: fnd_message.set_name('BEN', 'BEN_92197_CANT_CALC_SVC_DATE');
289: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
290: fnd_message.set_token('DATE_CODE',p_date_code);

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

293: --
294: end if;
295: */
296: --
297: hr_utility.set_location('Leaving : ' || l_proc, 10);
298: --
299: return l_return_date;
300: --
301: end get_ben_asg_dt;

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

337: l_jurisdiction_code varchar2(30);
338: --
339: begin
340: --
341: hr_utility.set_location('Entering : ' || l_proc, 10);
342: --
343: -- First determine if the person is an employee or not.
344: --
345: ben_person_object.get_object(p_person_id => p_person_id,

Line 350: hr_utility.set_location('l_employee_flag ', 11);

346: p_rec => l_typ_rec);
347: --
348: if l_typ_rec(1).system_person_type = 'EMP' then
349: l_employee_flag := TRUE;
350: hr_utility.set_location('l_employee_flag ', 11);
351: else
352: l_employee_flag := FALSE;
353: hr_utility.set_location('NOT l_employee_flag', 11);
354: --for a in l_typ_rec.first..l_typ_rec.last loop

Line 353: hr_utility.set_location('NOT l_employee_flag', 11);

349: l_employee_flag := TRUE;
350: hr_utility.set_location('l_employee_flag ', 11);
351: else
352: l_employee_flag := FALSE;
353: hr_utility.set_location('NOT l_employee_flag', 11);
354: --for a in l_typ_rec.first..l_typ_rec.last loop
355: --hr_utility.set_location(to_char(a)||' '||l_typ_rec(a).system_person_type, 11);
356: --end loop;
357: end if;

Line 355: --hr_utility.set_location(to_char(a)||' '||l_typ_rec(a).system_person_type, 11);

351: else
352: l_employee_flag := FALSE;
353: hr_utility.set_location('NOT l_employee_flag', 11);
354: --for a in l_typ_rec.first..l_typ_rec.last loop
355: --hr_utility.set_location(to_char(a)||' '||l_typ_rec(a).system_person_type, 11);
356: --end loop;
357: end if;
358: --
359: -- Determine the date from which the waiting period should calculated from.

Line 712: hr_utility.set_location('ERROR in ' || l_proc, 10);

708: end if;
709: --
710: if p_wait_perd_dt_to_use_cd IS NOT NULL and l_wait_st_date IS NULL then
711: --
712: hr_utility.set_location('ERROR in ' || l_proc, 10);
713: --
714: fnd_message.set_name('BEN', 'BEN_92197_CANT_CALC_SVC_DATE');
715: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
716: fnd_message.set_token('DATE_CODE',p_wait_perd_dt_to_use_cd);

Line 722: hr_utility.set_location('Wait start date ' || l_wait_st_date, 10);

718: raise ben_manage_life_events.g_record_error;
719: --
720: end if;
721: --
722: hr_utility.set_location('Wait start date ' || l_wait_st_date, 10);
723: --
724: -- Now calculate the waiting period end date.
725: --
726: if p_wait_perd_rl is not null and

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

812: elsif l_wait_perd_uom = 'YR' then
813: l_wait_end_date := add_months(l_wait_st_date,(12 * l_wait_perd_val));
814: end if;
815: p_wait_perd_strt_dt := l_wait_st_date ;
816: hr_utility.set_location('Leaving : ' || l_proc, 10);
817:
818: return l_wait_end_date;
819:
820: end get_wait_end_date;

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

866: l_envplip_id number;
867: l_envpl_id number;
868: --
869: begin
870: hr_utility.set_location('Entering : ' || l_proc, 10);
871: hr_utility.set_location('p_pgm_id -> ' ||p_pgm_id ,10);
872: hr_utility.set_location('p_ptip_id -> ' ||p_ptip_id,10);
873: hr_utility.set_location('p_plip_id -> ' ||p_plip_id,10);
874: hr_utility.set_location('p_pl_id -> ' ||p_pl_id ,10);

Line 871: hr_utility.set_location('p_pgm_id -> ' ||p_pgm_id ,10);

867: l_envpl_id number;
868: --
869: begin
870: hr_utility.set_location('Entering : ' || l_proc, 10);
871: hr_utility.set_location('p_pgm_id -> ' ||p_pgm_id ,10);
872: hr_utility.set_location('p_ptip_id -> ' ||p_ptip_id,10);
873: hr_utility.set_location('p_plip_id -> ' ||p_plip_id,10);
874: hr_utility.set_location('p_pl_id -> ' ||p_pl_id ,10);
875: hr_utility.set_location('p_oipl_id -> ' ||p_oipl_id,10);

Line 872: hr_utility.set_location('p_ptip_id -> ' ||p_ptip_id,10);

868: --
869: begin
870: hr_utility.set_location('Entering : ' || l_proc, 10);
871: hr_utility.set_location('p_pgm_id -> ' ||p_pgm_id ,10);
872: hr_utility.set_location('p_ptip_id -> ' ||p_ptip_id,10);
873: hr_utility.set_location('p_plip_id -> ' ||p_plip_id,10);
874: hr_utility.set_location('p_pl_id -> ' ||p_pl_id ,10);
875: hr_utility.set_location('p_oipl_id -> ' ||p_oipl_id,10);
876:

Line 873: hr_utility.set_location('p_plip_id -> ' ||p_plip_id,10);

869: begin
870: hr_utility.set_location('Entering : ' || l_proc, 10);
871: hr_utility.set_location('p_pgm_id -> ' ||p_pgm_id ,10);
872: hr_utility.set_location('p_ptip_id -> ' ||p_ptip_id,10);
873: hr_utility.set_location('p_plip_id -> ' ||p_plip_id,10);
874: hr_utility.set_location('p_pl_id -> ' ||p_pl_id ,10);
875: hr_utility.set_location('p_oipl_id -> ' ||p_oipl_id,10);
876:
877: ben_env_object.get(p_rec => l_env_rec);

Line 874: hr_utility.set_location('p_pl_id -> ' ||p_pl_id ,10);

870: hr_utility.set_location('Entering : ' || l_proc, 10);
871: hr_utility.set_location('p_pgm_id -> ' ||p_pgm_id ,10);
872: hr_utility.set_location('p_ptip_id -> ' ||p_ptip_id,10);
873: hr_utility.set_location('p_plip_id -> ' ||p_plip_id,10);
874: hr_utility.set_location('p_pl_id -> ' ||p_pl_id ,10);
875: hr_utility.set_location('p_oipl_id -> ' ||p_oipl_id,10);
876:
877: ben_env_object.get(p_rec => l_env_rec);
878: --

Line 875: hr_utility.set_location('p_oipl_id -> ' ||p_oipl_id,10);

871: hr_utility.set_location('p_pgm_id -> ' ||p_pgm_id ,10);
872: hr_utility.set_location('p_ptip_id -> ' ||p_ptip_id,10);
873: hr_utility.set_location('p_plip_id -> ' ||p_plip_id,10);
874: hr_utility.set_location('p_pl_id -> ' ||p_pl_id ,10);
875: hr_utility.set_location('p_oipl_id -> ' ||p_oipl_id,10);
876:
877: ben_env_object.get(p_rec => l_env_rec);
878: --
879: -- Assign comp object locals

Line 1035: hr_utility.set_location('Waiting period data found. Continuing', 60);

1031: if l_wait_data_found = TRUE then
1032: --
1033: -- Waiting period data was found. Continue with processing.
1034: --
1035: hr_utility.set_location('Waiting period data found. Continuing', 60);
1036: -- Calculate the date when the waiting period will end.
1037: l_wait_end_date := get_wait_end_date
1038: (p_wait_perd_dt_to_use_cd => l_wait_perd_dt_to_use_cd,
1039: p_wait_perd_dt_to_use_rl => l_wait_perd_dt_to_use_rl,

Line 1053: hr_utility.set_location('Wait end date : ' ||

1049: p_ler_id => p_ler_id,
1050: p_effective_date => p_effective_date,
1051: p_business_group_id => p_business_group_id,
1052: p_wait_perd_strt_dt => p_wait_perd_strt_dt );
1053: hr_utility.set_location('Wait end date : ' ||
1054: nvl(to_char(l_wait_end_date, 'DD-MON-YYYY')
1055: ,'NULL'), 62);
1056: --
1057: -- Get the plan's max waiting perd attibutes form the cache.

Line 1090: hr_utility.set_location('Max wait end date : ' ||

1086: p_ler_id => p_ler_id,
1087: p_effective_date => p_effective_date,
1088: p_business_group_id => p_business_group_id,
1089: p_wait_perd_strt_dt => p_wait_perd_strt_dt );
1090: hr_utility.set_location('Max wait end date : ' ||
1091: to_char(l_max_wait_end_date, 'DD-MON-YYYY'), 70);
1092: end if;
1093: end if;
1094:

Line 1112: hr_utility.set_location('Waiting period data not found.', 90);

1108: p_return_date := l_wait_end_date;
1109: end if;
1110: else
1111: -- l_wait_data_found is FALSE. Exit the procedure
1112: hr_utility.set_location('Waiting period data not found.', 90);
1113: p_return_date := NULL;
1114: end if;
1115:
1116: hr_utility.set_location('Leaving : ' || l_proc, 99);

Line 1116: hr_utility.set_location('Leaving : ' || l_proc, 99);

1112: hr_utility.set_location('Waiting period data not found.', 90);
1113: p_return_date := NULL;
1114: end if;
1115:
1116: hr_utility.set_location('Leaving : ' || l_proc, 99);
1117: end main;
1118: --
1119: end ben_det_wait_perd_cmpltn;