DBA Data[Home] [Help]

APPS.GHR_CREATE_PTNL_LIFE_EVENTS dependencies on HR_UTILITY

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

145:
146:
147: begin
148: ghr_history_api.get_g_session_var(l_session);
149: hr_utility.set_location('Entering ' || l_proc,10 );
150:
151: FOR bgp_id in c_bgp_id LOOP
152: l_business_group_id := bgp_id.business_group_id;
153: END LOOP;

Line 168: hr_utility.set_location(l_proc,20 );

164: exit;
165: End Loop;
166: End If;
167: --
168: hr_utility.set_location(l_proc,20 );
169: IF l_emp_exemp THEN
170: hr_utility.set_location(l_proc,30 );
171: FOR prior_pa_details IN c_prior_pa_details LOOP
172: l_prior_duty_station := prior_pa_details.duty_station_code;

Line 170: hr_utility.set_location(l_proc,30 );

166: End If;
167: --
168: hr_utility.set_location(l_proc,20 );
169: IF l_emp_exemp THEN
170: hr_utility.set_location(l_proc,30 );
171: FOR prior_pa_details IN c_prior_pa_details LOOP
172: l_prior_duty_station := prior_pa_details.duty_station_code;
173: l_prior_work_schedule := prior_pa_details.work_schedule;
174: l_last_separation_date := prior_pa_details.effective_date;

Line 178: hr_utility.set_location(l_proc,40 );

174: l_last_separation_date := prior_pa_details.effective_date;
175: EXIT;
176: END LOOP;
177: ELSE
178: hr_utility.set_location(l_proc,40 );
179: FOR get_ds_code IN c_get_ds_code LOOP
180: hr_utility.set_location( l_proc,80 );
181: l_prior_duty_station := get_ds_code.duty_Station_code;
182: END LOOP;

Line 180: hr_utility.set_location( l_proc,80 );

176: END LOOP;
177: ELSE
178: hr_utility.set_location(l_proc,40 );
179: FOR get_ds_code IN c_get_ds_code LOOP
180: hr_utility.set_location( l_proc,80 );
181: l_prior_duty_station := get_ds_code.duty_Station_code;
182: END LOOP;
183:
184: Ghr_History_Fetch.Fetch_asgei (

Line 193: hr_utility.set_location(l_proc,40 );

189: l_prior_work_schedule := l_asg_ei_data.aei_information7;
190: END IF;
191:
192:
193: hr_utility.set_location(l_proc,40 );
194: hr_utility.trace('Family Code ' ||p_pa_request_rec.noa_family_code);
195:
196: IF p_pa_request_rec.noa_family_code = 'APP' THEN
197: IF l_session.noa_id_correct is null THEN

Line 194: hr_utility.trace('Family Code ' ||p_pa_request_rec.noa_family_code);

190: END IF;
191:
192:
193: hr_utility.set_location(l_proc,40 );
194: hr_utility.trace('Family Code ' ||p_pa_request_rec.noa_family_code);
195:
196: IF p_pa_request_rec.noa_family_code = 'APP' THEN
197: IF l_session.noa_id_correct is null THEN
198:

Line 405: hr_utility.set_location(l_proc,90 );

401:
402: END IF;
403: END IF;
404:
405: hr_utility.set_location(l_proc,90 );
406: hr_utility.trace('Life Event ' ||l_life_event);
407: -- Now create the relevant potential life event for the Employee
408:
409: IF l_life_event is not null THEN

Line 406: hr_utility.trace('Life Event ' ||l_life_event);

402: END IF;
403: END IF;
404:
405: hr_utility.set_location(l_proc,90 );
406: hr_utility.trace('Life Event ' ||l_life_event);
407: -- Now create the relevant potential life event for the Employee
408:
409: IF l_life_event is not null THEN
410: hr_utility.set_location( l_proc,140 );

Line 410: hr_utility.set_location( l_proc,140 );

406: hr_utility.trace('Life Event ' ||l_life_event);
407: -- Now create the relevant potential life event for the Employee
408:
409: IF l_life_event is not null THEN
410: hr_utility.set_location( l_proc,140 );
411:
412: -- get the Business Group Id
413: FOR bgp_id in c_bgp_id LOOP
414: hr_utility.set_location( l_proc,150 );

Line 414: hr_utility.set_location( l_proc,150 );

410: hr_utility.set_location( l_proc,140 );
411:
412: -- get the Business Group Id
413: FOR bgp_id in c_bgp_id LOOP
414: hr_utility.set_location( l_proc,150 );
415: l_business_group_id := bgp_id.business_group_id;
416: END LOOP;
417:
418:

Line 421: hr_utility.set_location( l_proc,160 );

417:
418:
419: --get the ler_id
420: for ler_id in c_ler_id loop
421: hr_utility.set_location( l_proc,160 );
422: l_ler_id := ler_id.ler_id;
423: end loop;
424: l_ptnl_le_exists := 'N';
425: for ptnl_ler_id in c_chk_ptnl_ler loop

Line 430: hr_utility.set_location( l_proc,170 );

426: l_ptnl_le_exists := 'Y';
427: exit;
428: end loop;
429: if l_ler_id is not null and l_ptnl_le_exists = 'N' then
430: hr_utility.set_location( l_proc,170 );
431: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
432: (p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id
433: ,p_lf_evt_ocrd_dt => p_pa_request_rec.effective_date
434: ,p_ptnl_ler_for_per_stat_cd => 'UNPROCD'

Line 443: hr_utility.set_location( l_proc,180 );

439: ,p_object_version_number => l_ovn
440: ,p_effective_date => p_pa_request_rec.effective_date
441: );
442: ELSE
443: hr_utility.set_location( l_proc,180 );
444: -- Should this be an error condition. For now leaving it at null
445: null;
446: END IF;
447: END IF;

Line 448: hr_utility.set_location('Leaving ' || l_proc ,200 );

444: -- Should this be an error condition. For now leaving it at null
445: null;
446: END IF;
447: END IF;
448: hr_utility.set_location('Leaving ' || l_proc ,200 );
449: END create_ptnl_ler_for_per;
450:
451:
452: PROCEDURE create_ptnl_tsp_ler_for_per

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

454:
455: l_session ghr_history_api.g_session_var_type;
456: l_proc Varchar2(75) := 'create_ptnl_tsp_ler_for_per';
457: Begin
458: hr_utility.set_location('Entering ' || l_proc,5 );
459: hr_utility.set_location('Leaving ' || l_proc ,500 );
460:
461: End create_ptnl_tsp_ler_for_per;
462:

Line 459: hr_utility.set_location('Leaving ' || l_proc ,500 );

455: l_session ghr_history_api.g_session_var_type;
456: l_proc Varchar2(75) := 'create_ptnl_tsp_ler_for_per';
457: Begin
458: hr_utility.set_location('Entering ' || l_proc,5 );
459: hr_utility.set_location('Leaving ' || l_proc ,500 );
460:
461: End create_ptnl_tsp_ler_for_per;
462:
463: end ghr_create_ptnl_life_events;