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.GHR_ELT_TO_BEN_PKG dependencies on HR_UTILITY

Line 158: hr_utility.set_location('batch ' || l_thread_count,1000);

154: IF g_person_ids.COUNT > 0 THEN
155: -- Wait for the child concurrent programs to get finished
156: FOR l_thread_count IN 1..l_batch_no LOOP
157: l_status := TRUE;
158: hr_utility.set_location('batch ' || l_thread_count,1000);
159: hr_utility.set_location('request id ' || g_person_ids(l_thread_count),1000);
160: WHILE l_status = TRUE LOOP
161: call_status := FND_CONCURRENT.GET_REQUEST_STATUS(g_person_ids(l_thread_count),'','',rphase,rstatus,dphase,dstatus, message);
162: hr_utility.set_location('dphase ' || dphase,1000);

Line 159: hr_utility.set_location('request id ' || g_person_ids(l_thread_count),1000);

155: -- Wait for the child concurrent programs to get finished
156: FOR l_thread_count IN 1..l_batch_no LOOP
157: l_status := TRUE;
158: hr_utility.set_location('batch ' || l_thread_count,1000);
159: hr_utility.set_location('request id ' || g_person_ids(l_thread_count),1000);
160: WHILE l_status = TRUE LOOP
161: call_status := FND_CONCURRENT.GET_REQUEST_STATUS(g_person_ids(l_thread_count),'','',rphase,rstatus,dphase,dstatus, message);
162: hr_utility.set_location('dphase ' || dphase,1000);
163: IF dphase = 'COMPLETE' THEN

Line 162: hr_utility.set_location('dphase ' || dphase,1000);

158: hr_utility.set_location('batch ' || l_thread_count,1000);
159: hr_utility.set_location('request id ' || g_person_ids(l_thread_count),1000);
160: WHILE l_status = TRUE LOOP
161: call_status := FND_CONCURRENT.GET_REQUEST_STATUS(g_person_ids(l_thread_count),'','',rphase,rstatus,dphase,dstatus, message);
162: hr_utility.set_location('dphase ' || dphase,1000);
163: IF dphase = 'COMPLETE' THEN
164: l_status := FALSE;
165: ELSE
166: dbms_lock.sleep(5);

Line 176: --hr_utility.trace_off;

172: FOR l_cur_compl_status IN c_completion_status(l_session_id) LOOP
173: l_completion_status := l_cur_compl_status.max_status;
174: END LOOP;
175:
176: --hr_utility.trace_off;
177: -- Assigning Return codes
178: IF l_completion_status = 2 THEN
179: p_retcode := 2;
180: p_errbuf := 'There were errors in some person records. Please verify Federal Process Log for details';

Line 288: hr_utility.set_location('PERSON ID : '||to_char(p_person_id),500);

284:
285: PROCEDURE print_ben_record(p_benefits_eit_rec IN ghr_api.per_benefit_info_type,p_person_id IN NUMBER,
286: p_effective_date IN DATE) IS
287: BEGIN
288: hr_utility.set_location('PERSON ID : '||to_char(p_person_id),500);
289: hr_utility.set_location('Eff Date : '||to_char(p_effective_date),505);
290: hr_utility.set_location('FEGLI Date Elg Exp : '|| p_benefits_eit_rec.FEGLI_Date_Eligibility_Expires,510);
291: hr_utility.set_location('FEHB Date Elg Exp : '|| p_benefits_eit_rec.FEHB_Date_Eligibility_expires,520);
292: hr_utility.set_location('FEHB Date Temp Elg : '|| p_benefits_eit_rec.FEHB_Date_temp_eligibility,530);

Line 289: hr_utility.set_location('Eff Date : '||to_char(p_effective_date),505);

285: PROCEDURE print_ben_record(p_benefits_eit_rec IN ghr_api.per_benefit_info_type,p_person_id IN NUMBER,
286: p_effective_date IN DATE) IS
287: BEGIN
288: hr_utility.set_location('PERSON ID : '||to_char(p_person_id),500);
289: hr_utility.set_location('Eff Date : '||to_char(p_effective_date),505);
290: hr_utility.set_location('FEGLI Date Elg Exp : '|| p_benefits_eit_rec.FEGLI_Date_Eligibility_Expires,510);
291: hr_utility.set_location('FEHB Date Elg Exp : '|| p_benefits_eit_rec.FEHB_Date_Eligibility_expires,520);
292: hr_utility.set_location('FEHB Date Temp Elg : '|| p_benefits_eit_rec.FEHB_Date_temp_eligibility,530);
293: hr_utility.set_location('FEHB Dte Dep Cer Exp : '|| p_benefits_eit_rec.FEHB_Date_dependent_cert_expir,540);

Line 290: hr_utility.set_location('FEGLI Date Elg Exp : '|| p_benefits_eit_rec.FEGLI_Date_Eligibility_Expires,510);

286: p_effective_date IN DATE) IS
287: BEGIN
288: hr_utility.set_location('PERSON ID : '||to_char(p_person_id),500);
289: hr_utility.set_location('Eff Date : '||to_char(p_effective_date),505);
290: hr_utility.set_location('FEGLI Date Elg Exp : '|| p_benefits_eit_rec.FEGLI_Date_Eligibility_Expires,510);
291: hr_utility.set_location('FEHB Date Elg Exp : '|| p_benefits_eit_rec.FEHB_Date_Eligibility_expires,520);
292: hr_utility.set_location('FEHB Date Temp Elg : '|| p_benefits_eit_rec.FEHB_Date_temp_eligibility,530);
293: hr_utility.set_location('FEHB Dte Dep Cer Exp : '|| p_benefits_eit_rec.FEHB_Date_dependent_cert_expir,540);
294: hr_utility.set_location('FEHB LWOP Cont St Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_st_date,550);

Line 291: hr_utility.set_location('FEHB Date Elg Exp : '|| p_benefits_eit_rec.FEHB_Date_Eligibility_expires,520);

287: BEGIN
288: hr_utility.set_location('PERSON ID : '||to_char(p_person_id),500);
289: hr_utility.set_location('Eff Date : '||to_char(p_effective_date),505);
290: hr_utility.set_location('FEGLI Date Elg Exp : '|| p_benefits_eit_rec.FEGLI_Date_Eligibility_Expires,510);
291: hr_utility.set_location('FEHB Date Elg Exp : '|| p_benefits_eit_rec.FEHB_Date_Eligibility_expires,520);
292: hr_utility.set_location('FEHB Date Temp Elg : '|| p_benefits_eit_rec.FEHB_Date_temp_eligibility,530);
293: hr_utility.set_location('FEHB Dte Dep Cer Exp : '|| p_benefits_eit_rec.FEHB_Date_dependent_cert_expir,540);
294: hr_utility.set_location('FEHB LWOP Cont St Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_st_date,550);
295: hr_utility.set_location('FEHB LWOP Cont Ed Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_end_date,560);

Line 292: hr_utility.set_location('FEHB Date Temp Elg : '|| p_benefits_eit_rec.FEHB_Date_temp_eligibility,530);

288: hr_utility.set_location('PERSON ID : '||to_char(p_person_id),500);
289: hr_utility.set_location('Eff Date : '||to_char(p_effective_date),505);
290: hr_utility.set_location('FEGLI Date Elg Exp : '|| p_benefits_eit_rec.FEGLI_Date_Eligibility_Expires,510);
291: hr_utility.set_location('FEHB Date Elg Exp : '|| p_benefits_eit_rec.FEHB_Date_Eligibility_expires,520);
292: hr_utility.set_location('FEHB Date Temp Elg : '|| p_benefits_eit_rec.FEHB_Date_temp_eligibility,530);
293: hr_utility.set_location('FEHB Dte Dep Cer Exp : '|| p_benefits_eit_rec.FEHB_Date_dependent_cert_expir,540);
294: hr_utility.set_location('FEHB LWOP Cont St Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_st_date,550);
295: hr_utility.set_location('FEHB LWOP Cont Ed Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_end_date,560);
296: hr_utility.set_location('FEHB Chld Eq Crt Dt : '|| p_benefits_eit_rec.FEHB_Child_equiry_court_date,570);

Line 293: hr_utility.set_location('FEHB Dte Dep Cer Exp : '|| p_benefits_eit_rec.FEHB_Date_dependent_cert_expir,540);

289: hr_utility.set_location('Eff Date : '||to_char(p_effective_date),505);
290: hr_utility.set_location('FEGLI Date Elg Exp : '|| p_benefits_eit_rec.FEGLI_Date_Eligibility_Expires,510);
291: hr_utility.set_location('FEHB Date Elg Exp : '|| p_benefits_eit_rec.FEHB_Date_Eligibility_expires,520);
292: hr_utility.set_location('FEHB Date Temp Elg : '|| p_benefits_eit_rec.FEHB_Date_temp_eligibility,530);
293: hr_utility.set_location('FEHB Dte Dep Cer Exp : '|| p_benefits_eit_rec.FEHB_Date_dependent_cert_expir,540);
294: hr_utility.set_location('FEHB LWOP Cont St Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_st_date,550);
295: hr_utility.set_location('FEHB LWOP Cont Ed Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_end_date,560);
296: hr_utility.set_location('FEHB Chld Eq Crt Dt : '|| p_benefits_eit_rec.FEHB_Child_equiry_court_date,570);
297: hr_utility.set_location('FERS Date Elg Exp : '|| p_benefits_eit_rec.FERS_Date_eligibility_expires,580);

Line 294: hr_utility.set_location('FEHB LWOP Cont St Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_st_date,550);

290: hr_utility.set_location('FEGLI Date Elg Exp : '|| p_benefits_eit_rec.FEGLI_Date_Eligibility_Expires,510);
291: hr_utility.set_location('FEHB Date Elg Exp : '|| p_benefits_eit_rec.FEHB_Date_Eligibility_expires,520);
292: hr_utility.set_location('FEHB Date Temp Elg : '|| p_benefits_eit_rec.FEHB_Date_temp_eligibility,530);
293: hr_utility.set_location('FEHB Dte Dep Cer Exp : '|| p_benefits_eit_rec.FEHB_Date_dependent_cert_expir,540);
294: hr_utility.set_location('FEHB LWOP Cont St Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_st_date,550);
295: hr_utility.set_location('FEHB LWOP Cont Ed Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_end_date,560);
296: hr_utility.set_location('FEHB Chld Eq Crt Dt : '|| p_benefits_eit_rec.FEHB_Child_equiry_court_date,570);
297: hr_utility.set_location('FERS Date Elg Exp : '|| p_benefits_eit_rec.FERS_Date_eligibility_expires,580);
298: hr_utility.set_location('FERS Election Dt : '|| p_benefits_eit_rec.FERS_Election_Date,590);

Line 295: hr_utility.set_location('FEHB LWOP Cont Ed Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_end_date,560);

291: hr_utility.set_location('FEHB Date Elg Exp : '|| p_benefits_eit_rec.FEHB_Date_Eligibility_expires,520);
292: hr_utility.set_location('FEHB Date Temp Elg : '|| p_benefits_eit_rec.FEHB_Date_temp_eligibility,530);
293: hr_utility.set_location('FEHB Dte Dep Cer Exp : '|| p_benefits_eit_rec.FEHB_Date_dependent_cert_expir,540);
294: hr_utility.set_location('FEHB LWOP Cont St Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_st_date,550);
295: hr_utility.set_location('FEHB LWOP Cont Ed Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_end_date,560);
296: hr_utility.set_location('FEHB Chld Eq Crt Dt : '|| p_benefits_eit_rec.FEHB_Child_equiry_court_date,570);
297: hr_utility.set_location('FERS Date Elg Exp : '|| p_benefits_eit_rec.FERS_Date_eligibility_expires,580);
298: hr_utility.set_location('FERS Election Dt : '|| p_benefits_eit_rec.FERS_Election_Date,590);
299: hr_utility.set_location('FERS Election Ind : '|| p_benefits_eit_rec.FERS_Election_Indicator,600);

Line 296: hr_utility.set_location('FEHB Chld Eq Crt Dt : '|| p_benefits_eit_rec.FEHB_Child_equiry_court_date,570);

292: hr_utility.set_location('FEHB Date Temp Elg : '|| p_benefits_eit_rec.FEHB_Date_temp_eligibility,530);
293: hr_utility.set_location('FEHB Dte Dep Cer Exp : '|| p_benefits_eit_rec.FEHB_Date_dependent_cert_expir,540);
294: hr_utility.set_location('FEHB LWOP Cont St Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_st_date,550);
295: hr_utility.set_location('FEHB LWOP Cont Ed Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_end_date,560);
296: hr_utility.set_location('FEHB Chld Eq Crt Dt : '|| p_benefits_eit_rec.FEHB_Child_equiry_court_date,570);
297: hr_utility.set_location('FERS Date Elg Exp : '|| p_benefits_eit_rec.FERS_Date_eligibility_expires,580);
298: hr_utility.set_location('FERS Election Dt : '|| p_benefits_eit_rec.FERS_Election_Date,590);
299: hr_utility.set_location('FERS Election Ind : '|| p_benefits_eit_rec.FERS_Election_Indicator,600);
300: hr_utility.set_location('TSP Agn Cont Elg Dt : '|| p_benefits_eit_rec.TSP_Agncy_Contrib_Elig_date,610);

Line 297: hr_utility.set_location('FERS Date Elg Exp : '|| p_benefits_eit_rec.FERS_Date_eligibility_expires,580);

293: hr_utility.set_location('FEHB Dte Dep Cer Exp : '|| p_benefits_eit_rec.FEHB_Date_dependent_cert_expir,540);
294: hr_utility.set_location('FEHB LWOP Cont St Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_st_date,550);
295: hr_utility.set_location('FEHB LWOP Cont Ed Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_end_date,560);
296: hr_utility.set_location('FEHB Chld Eq Crt Dt : '|| p_benefits_eit_rec.FEHB_Child_equiry_court_date,570);
297: hr_utility.set_location('FERS Date Elg Exp : '|| p_benefits_eit_rec.FERS_Date_eligibility_expires,580);
298: hr_utility.set_location('FERS Election Dt : '|| p_benefits_eit_rec.FERS_Election_Date,590);
299: hr_utility.set_location('FERS Election Ind : '|| p_benefits_eit_rec.FERS_Election_Indicator,600);
300: hr_utility.set_location('TSP Agn Cont Elg Dt : '|| p_benefits_eit_rec.TSP_Agncy_Contrib_Elig_date,610);
301: hr_utility.set_location('TSP Emp Cont Elg Dt : '|| p_benefits_eit_rec.TSP_Emp_Contrib_Elig_date,620);

Line 298: hr_utility.set_location('FERS Election Dt : '|| p_benefits_eit_rec.FERS_Election_Date,590);

294: hr_utility.set_location('FEHB LWOP Cont St Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_st_date,550);
295: hr_utility.set_location('FEHB LWOP Cont Ed Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_end_date,560);
296: hr_utility.set_location('FEHB Chld Eq Crt Dt : '|| p_benefits_eit_rec.FEHB_Child_equiry_court_date,570);
297: hr_utility.set_location('FERS Date Elg Exp : '|| p_benefits_eit_rec.FERS_Date_eligibility_expires,580);
298: hr_utility.set_location('FERS Election Dt : '|| p_benefits_eit_rec.FERS_Election_Date,590);
299: hr_utility.set_location('FERS Election Ind : '|| p_benefits_eit_rec.FERS_Election_Indicator,600);
300: hr_utility.set_location('TSP Agn Cont Elg Dt : '|| p_benefits_eit_rec.TSP_Agncy_Contrib_Elig_date,610);
301: hr_utility.set_location('TSP Emp Cont Elg Dt : '|| p_benefits_eit_rec.TSP_Emp_Contrib_Elig_date,620);
302: END print_ben_record;

Line 299: hr_utility.set_location('FERS Election Ind : '|| p_benefits_eit_rec.FERS_Election_Indicator,600);

295: hr_utility.set_location('FEHB LWOP Cont Ed Dt : '|| p_benefits_eit_rec.FEHB_LWOP_contingency_end_date,560);
296: hr_utility.set_location('FEHB Chld Eq Crt Dt : '|| p_benefits_eit_rec.FEHB_Child_equiry_court_date,570);
297: hr_utility.set_location('FERS Date Elg Exp : '|| p_benefits_eit_rec.FERS_Date_eligibility_expires,580);
298: hr_utility.set_location('FERS Election Dt : '|| p_benefits_eit_rec.FERS_Election_Date,590);
299: hr_utility.set_location('FERS Election Ind : '|| p_benefits_eit_rec.FERS_Election_Indicator,600);
300: hr_utility.set_location('TSP Agn Cont Elg Dt : '|| p_benefits_eit_rec.TSP_Agncy_Contrib_Elig_date,610);
301: hr_utility.set_location('TSP Emp Cont Elg Dt : '|| p_benefits_eit_rec.TSP_Emp_Contrib_Elig_date,620);
302: END print_ben_record;
303:

Line 300: hr_utility.set_location('TSP Agn Cont Elg Dt : '|| p_benefits_eit_rec.TSP_Agncy_Contrib_Elig_date,610);

296: hr_utility.set_location('FEHB Chld Eq Crt Dt : '|| p_benefits_eit_rec.FEHB_Child_equiry_court_date,570);
297: hr_utility.set_location('FERS Date Elg Exp : '|| p_benefits_eit_rec.FERS_Date_eligibility_expires,580);
298: hr_utility.set_location('FERS Election Dt : '|| p_benefits_eit_rec.FERS_Election_Date,590);
299: hr_utility.set_location('FERS Election Ind : '|| p_benefits_eit_rec.FERS_Election_Indicator,600);
300: hr_utility.set_location('TSP Agn Cont Elg Dt : '|| p_benefits_eit_rec.TSP_Agncy_Contrib_Elig_date,610);
301: hr_utility.set_location('TSP Emp Cont Elg Dt : '|| p_benefits_eit_rec.TSP_Emp_Contrib_Elig_date,620);
302: END print_ben_record;
303:
304: -- Procedure to get person Full Name, SSN

Line 301: hr_utility.set_location('TSP Emp Cont Elg Dt : '|| p_benefits_eit_rec.TSP_Emp_Contrib_Elig_date,620);

297: hr_utility.set_location('FERS Date Elg Exp : '|| p_benefits_eit_rec.FERS_Date_eligibility_expires,580);
298: hr_utility.set_location('FERS Election Dt : '|| p_benefits_eit_rec.FERS_Election_Date,590);
299: hr_utility.set_location('FERS Election Ind : '|| p_benefits_eit_rec.FERS_Election_Indicator,600);
300: hr_utility.set_location('TSP Agn Cont Elg Dt : '|| p_benefits_eit_rec.TSP_Agncy_Contrib_Elig_date,610);
301: hr_utility.set_location('TSP Emp Cont Elg Dt : '|| p_benefits_eit_rec.TSP_Emp_Contrib_Elig_date,620);
302: END print_ben_record;
303:
304: -- Procedure to get person Full Name, SSN
305: PROCEDURE get_person_name_ssn(p_person_id IN per_people_f.person_id%TYPE

Line 347: hr_utility.set_location('Entering build_benefits_rec',0);

343: AND b.input_value_id = p_input_value_id;
344:
345:
346: BEGIN
347: hr_utility.set_location('Entering build_benefits_rec',0);
348: l_benefits_eit_rec := p_benefits_eit_rec;
349: IF p_pa_history_rec.table_name = 'PER_PEOPLE_EXTRA_INFO' AND p_pa_history_rec.information5 = 'GHR_US_PER_GROUP1' THEN
350: hr_utility.set_location('Assigning values for FEHB Person EIT',5);
351: p_benefits_eit_rec.FEHB_Date_Eligibility_expires := p_pa_history_rec.information19;

Line 350: hr_utility.set_location('Assigning values for FEHB Person EIT',5);

346: BEGIN
347: hr_utility.set_location('Entering build_benefits_rec',0);
348: l_benefits_eit_rec := p_benefits_eit_rec;
349: IF p_pa_history_rec.table_name = 'PER_PEOPLE_EXTRA_INFO' AND p_pa_history_rec.information5 = 'GHR_US_PER_GROUP1' THEN
350: hr_utility.set_location('Assigning values for FEHB Person EIT',5);
351: p_benefits_eit_rec.FEHB_Date_Eligibility_expires := p_pa_history_rec.information19;
352: p_benefits_eit_rec.FEHB_Date_temp_eligibility := p_pa_history_rec.information20;
353: p_benefits_eit_rec.FEHB_Date_dependent_cert_expir := p_pa_history_rec.information21;
354: ELSIF p_pa_history_rec.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN

Line 389: hr_utility.set_location('Leaving build_benefits_rec',10);

385: ELSE
386: -- SKIP the Record;
387: NULL;
388: END IF;
389: hr_utility.set_location('Leaving build_benefits_rec',10);
390: EXCEPTION
391: WHEN OTHERS THEN
392: p_benefits_eit_rec := l_benefits_eit_rec;
393: RAISE;

Line 413: hr_utility.set_location('Entering Insert benefits EIT REC',0);

409: AND information_type = 'GHR_US_PER_BENEFIT_INFO';
410:
411:
412: BEGIN
413: hr_utility.set_location('Entering Insert benefits EIT REC',0);
414: l_information_type := 'GHR_US_PER_BENEFIT_INFO';
415: hr_utility.set_location('Calling Create Person Extra Info',10);
416: FOR per_extra_info_rec IN c_person_extra_info(p_person_id)
417: LOOP

Line 415: hr_utility.set_location('Calling Create Person Extra Info',10);

411:
412: BEGIN
413: hr_utility.set_location('Entering Insert benefits EIT REC',0);
414: l_information_type := 'GHR_US_PER_BENEFIT_INFO';
415: hr_utility.set_location('Calling Create Person Extra Info',10);
416: FOR per_extra_info_rec IN c_person_extra_info(p_person_id)
417: LOOP
418: l_person_extra_info_id := per_extra_info_rec.person_extra_info_id;
419: l_object_version_number := per_extra_info_rec.object_version_number;

Line 446: hr_utility.set_location('Person Extra Info ID: '||to_char(l_person_extra_info_id),20);

442: ,p_pei_information15 => p_benefits_eit_rec.TSP_Emp_Contrib_Elig_date
443: ,p_person_extra_info_id => l_person_extra_info_id
444: ,p_object_version_number => l_object_version_number
445: );
446: hr_utility.set_location('Person Extra Info ID: '||to_char(l_person_extra_info_id),20);
447: hr_utility.set_location('Object Version Number: '||to_char(l_object_version_number),30);
448: ELSE
449: ghr_person_extra_info_api.update_person_extra_info
450: (p_person_extra_info_id => l_person_extra_info_id

Line 447: hr_utility.set_location('Object Version Number: '||to_char(l_object_version_number),30);

443: ,p_person_extra_info_id => l_person_extra_info_id
444: ,p_object_version_number => l_object_version_number
445: );
446: hr_utility.set_location('Person Extra Info ID: '||to_char(l_person_extra_info_id),20);
447: hr_utility.set_location('Object Version Number: '||to_char(l_object_version_number),30);
448: ELSE
449: ghr_person_extra_info_api.update_person_extra_info
450: (p_person_extra_info_id => l_person_extra_info_id
451: ,p_object_version_number => l_object_version_number

Line 467: hr_utility.set_location('Leaving Insert Benefits EIT REC',40);

463: ,p_pei_information14 => p_benefits_eit_rec.TSP_Agncy_Contrib_Elig_date
464: ,p_pei_information15 => p_benefits_eit_rec.TSP_Emp_Contrib_Elig_date
465: );
466: END IF;
467: hr_utility.set_location('Leaving Insert Benefits EIT REC',40);
468: END insert_benefits_eit_rec;
469:
470: -- ***************** MAIN PROGRAM ***************
471: BEGIN

Line 487: --hr_utility.set_location('Entering the Conversion Process...',0);

483: VALUES (l_sid,sysdate);
484: END IF;
485: END;
486:
487: --hr_utility.set_location('Entering the Conversion Process...',0);
488: l_errbuf := NULL;
489: l_retcode := 0;
490: l_per_err_cnt := 0;
491:

Line 512: -- hr_utility.set_location('Processing Person '||to_char(l_current_person_id)||'....',20);

508: FOR federal_persons_rec IN c_batch_persons(p_session_id,p_batch_no)
509: LOOP
510: BEGIN
511: l_current_person_id := federal_persons_rec.person_id;
512: -- hr_utility.set_location('Processing Person '||to_char(l_current_person_id)||'....',20);
513: -- initialise Benefits EIT Record
514: l_benefits_eit_rec := NULL;
515: l_new_effective_date := to_date('1900/01/01','YYYY/MM/DD');
516: l_old_effective_date := to_date('1900/01/01','YYYY/MM/DD');

Line 524: --hr_utility.set_location('Processing history record '||to_char(l_pa_history_rec.pa_history_id)||'....',30);

520: BEGIN
521: FETCH c_person_history INTO l_pa_history_rec;
522: l_cnt := l_cnt + 1;
523: IF c_person_history%FOUND THEN
524: --hr_utility.set_location('Processing history record '||to_char(l_pa_history_rec.pa_history_id)||'....',30);
525: --hr_utility.set_location('History record found',40);
526: l_new_effective_date := l_pa_history_rec.effective_date;
527: IF (l_new_effective_date = l_old_effective_date OR l_cnt = 1) THEN
528: build_benefits_rec(l_pa_history_rec,l_benefits_eit_rec);

Line 525: --hr_utility.set_location('History record found',40);

521: FETCH c_person_history INTO l_pa_history_rec;
522: l_cnt := l_cnt + 1;
523: IF c_person_history%FOUND THEN
524: --hr_utility.set_location('Processing history record '||to_char(l_pa_history_rec.pa_history_id)||'....',30);
525: --hr_utility.set_location('History record found',40);
526: l_new_effective_date := l_pa_history_rec.effective_date;
527: IF (l_new_effective_date = l_old_effective_date OR l_cnt = 1) THEN
528: build_benefits_rec(l_pa_history_rec,l_benefits_eit_rec);
529: ELSE

Line 535: hr_utility.set_location('History record NOT found ...',50);

531: build_benefits_rec(l_pa_history_rec,l_benefits_eit_rec);
532: END IF;
533: l_old_effective_date := l_new_effective_date;
534: ELSE
535: hr_utility.set_location('History record NOT found ...',50);
536: -- Added l_Cnt >1 condition. This is to check whether there are history records exists or not.
537: -- If no history record exists for a person, creation of benefits records can be skipped.
538: IF l_cnt > 1 THEN
539: insert_benefits_eit_rec(l_current_person_id,l_benefits_eit_rec,l_old_effective_date);

Line 544: --hr_utility.set_location('Completed Processing History Records. ',60);

540: END IF;
541: -- print_ben_record(l_benefits_eit_rec,l_current_person_id,l_old_effective_date);
542: EXIT;
543: END IF;
544: --hr_utility.set_location('Completed Processing History Records. ',60);
545: EXCEPTION
546: WHEN OTHERS THEN
547: --hr_utility.set_location('Error Occured while processing history records',65);
548: Close c_person_history;

Line 547: --hr_utility.set_location('Error Occured while processing history records',65);

543: END IF;
544: --hr_utility.set_location('Completed Processing History Records. ',60);
545: EXCEPTION
546: WHEN OTHERS THEN
547: --hr_utility.set_location('Error Occured while processing history records',65);
548: Close c_person_history;
549: RAISE;
550: END;
551: END LOOP; -- For Person_history_rec Cursor

Line 554: --hr_utility.set_location('Completed Processing for Person '||to_char(l_current_person_id),70);

550: END;
551: END LOOP; -- For Person_history_rec Cursor
552: Close c_person_history;
553: COMMIT;
554: --hr_utility.set_location('Completed Processing for Person '||to_char(l_current_person_id),70);
555: EXCEPTION
556: WHEN OTHERS THEN
557: l_per_err_cnt := l_per_err_cnt + 1 ;
558: --hr_utility.set_location('Error Occured while processing Person ID',75);

Line 558: --hr_utility.set_location('Error Occured while processing Person ID',75);

554: --hr_utility.set_location('Completed Processing for Person '||to_char(l_current_person_id),70);
555: EXCEPTION
556: WHEN OTHERS THEN
557: l_per_err_cnt := l_per_err_cnt + 1 ;
558: --hr_utility.set_location('Error Occured while processing Person ID',75);
559: get_person_name_ssn(l_current_person_id,l_new_effective_date,l_full_name,l_ssn);
560: --Bug # 9329643
561: l_emp_num := ghr_pa_requests_pkg2.get_employee_number
562: (p_person_id => l_current_person_id,

Line 578: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);

574:
575: -- Set Concurrent program completion messages
576: IF l_per_err_cnt > 0 THEN
577: p_retcode := 1;
578: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
579: p_errbuf := 'Unable to create benefits EIT for some person records. Please see the federal process log for details.';
580: ELSE
581: p_retcode := l_retcode;
582: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);

Line 582: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);

578: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
579: p_errbuf := 'Unable to create benefits EIT for some person records. Please see the federal process log for details.';
580: ELSE
581: p_retcode := l_retcode;
582: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
583: p_errbuf := 'Process Completed Successfully';
584: END IF;
585:
586: -- Update the completion status.

Line 596: hr_utility.set_location('ERROR Occured '||sqlerrm,100);

592: COMMIT;
593: END IF; -- End of c_eit_exists%FOUND.
594: EXCEPTION
595: WHEN OTHERS THEN
596: hr_utility.set_location('ERROR Occured '||sqlerrm,100);
597: p_errbuf := 'Process Errored Out with error message: '||sqlerrm;
598: p_retcode := 2;
599: END execute_conversion;
600: