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 285: hr_utility.set_location('PERSON ID : '||to_char(p_person_id),500);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

551: --hr_utility.set_location('Completed Processing for Person '||to_char(l_current_person_id),70);
552: EXCEPTION
553: WHEN OTHERS THEN
554: l_per_err_cnt := l_per_err_cnt + 1 ;
555: --hr_utility.set_location('Error Occured while processing Person ID',75);
556: get_person_name_ssn(l_current_person_id,l_new_effective_date,l_full_name,l_ssn);
557: l_log_text := 'System unable to create Benefits EIT for the Person: '||l_full_name||
558: '; SSN: '||l_ssn||'; Error: '||sqlerrm;
559: ghr_wgi_pkg.create_ghr_errorlog (p_program_name => l_program_name

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

567:
568: -- Set Concurrent program completion messages
569: IF l_per_err_cnt > 0 THEN
570: p_retcode := 1;
571: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
572: p_errbuf := 'Unable to create benefits EIT for some person records. Please see the federal process log for details.';
573: ELSE
574: p_retcode := l_retcode;
575: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);

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

571: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
572: p_errbuf := 'Unable to create benefits EIT for some person records. Please see the federal process log for details.';
573: ELSE
574: p_retcode := l_retcode;
575: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
576: p_errbuf := 'Process Completed Successfully';
577: END IF;
578:
579: -- Update the completion status.

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

585: COMMIT;
586: END IF; -- End of c_eit_exists%FOUND.
587: EXCEPTION
588: WHEN OTHERS THEN
589: hr_utility.set_location('ERROR Occured '||sqlerrm,100);
590: p_errbuf := 'Process Errored Out with error message: '||sqlerrm;
591: p_retcode := 2;
592: END execute_conversion;
593: