APPS.GHR_EHRI_DYNRPT dependencies on HR_UTILITY

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

2324: LENGTH(p_last_name)),' ') = ' '||UPPER(LOOKUP_CODE)
2325: AND ROWNUM = 1;
2326: BEGIN
2327:
2328: hr_utility.set_location('Entering:'||l_proc,5);
2329:
2330: IF GET_SUFFIX%ISOPEN THEN
2331: CLOSE GET_SUFFIX;
2332: END IF;

Line 2658: -- hr_utility.trace_on(null,'venkat');

2654:
2655: BEGIN
2656: --
2657: l_records_found:=FALSE;
2658: -- hr_utility.trace_on(null,'venkat');
2659: hr_utility.set_location('Entering:'||l_proc, 10);
2660: --
2661: ghr_mto_int.set_log_program_name('ghr_ehri_dynrpt');
2662: --

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

2655: BEGIN
2656: --
2657: l_records_found:=FALSE;
2658: -- hr_utility.trace_on(null,'venkat');
2659: hr_utility.set_location('Entering:'||l_proc, 10);
2660: --
2661: ghr_mto_int.set_log_program_name('ghr_ehri_dynrpt');
2662: --
2663: IF p_end_date > p_start_Date THEN

Line 2764: hr_utility.set_location(l_proc||' Check non_us_citizen_and_foreign_ds' ,30);

2760: (p_person_id => l_ghr_pa_requests_rec.person_id,
2761: p_effective_date => l_ghr_pa_requests_rec.effective_date);
2762: End if;
2763:
2764: hr_utility.set_location(l_proc||' Check non_us_citizen_and_foreign_ds' ,30);
2765:
2766: --
2767: -- 2.1) Do not include PAR's for a non US Citizen in a foreign country
2768: IF non_us_citizen_and_foreign_ds (p_citizenship => l_ghr_pa_requests_rec.citizenship

Line 2773: hr_utility.set_location(l_proc||' Customer exclusion hook' ,40);

2769: ,p_duty_station_code => l_ghr_pa_requests_rec.duty_station_code) THEN
2770: GOTO end_par_loop; -- loop for the next one!
2771: END IF;
2772: --
2773: hr_utility.set_location(l_proc||' Customer exclusion hook' ,40);
2774: --
2775: -- Bug 714944 -- Added exclusion of NAF:
2776: IF exclude_position (p_position_id => NVL(l_ghr_pa_requests_rec.to_position_id
2777: ,l_ghr_pa_requests_rec.from_position_id)

Line 2817: hr_utility.set_location(l_proc||' populate cpdf temp from par' ,50);

2813: -- If we are just doing a count, we do not need to do the second bit!
2814: --
2815: -- 3.1) Get all info from PAR table itself
2816: --
2817: hr_utility.set_location(l_proc||' populate cpdf temp from par' ,50);
2818: --
2819: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
2820: -- Agency Subelement Code
2821: l_ghr_cpdf_temp_rec.to_national_identifier := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);

Line 4433: hr_utility.set_location('Inside EHRI_DYNRPT_ERROR exception ',30);

4429: NULL;
4430:
4431: EXCEPTION
4432: WHEN EHRI_DYNRPT_ERROR THEN
4433: hr_utility.set_location('Inside EHRI_DYNRPT_ERROR exception ',30);
4434: ghr_mto_int.log_message(p_procedure => l_message_name,
4435: p_message => l_log_text
4436: );
4437: COMMIT;

Line 4439: hr_utility.set_location('Inside WHEN_OTHERS exception ',40);

4435: p_message => l_log_text
4436: );
4437: COMMIT;
4438: WHEN OTHERS THEN
4439: hr_utility.set_location('Inside WHEN_OTHERS exception ',40);
4440: l_message_name := 'Unhandled Error';
4441: --Bug # 9329643 Modified SSN to Emp No
4442: l_log_text := 'Unhandled Error for pa_request_id: '||
4443: l_ghr_pa_requests_rec.pa_request_id ||

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

4479: );
4480: END IF;
4481:
4482: --
4483: hr_utility.set_location('Leaving:'||l_proc, 99);
4484: -- hr_utility.trace_off;
4485: --
4486: END populate_ghr_cpdf_temp;
4487:

Line 4484: -- hr_utility.trace_off;

4480: END IF;
4481:
4482: --
4483: hr_utility.set_location('Leaving:'||l_proc, 99);
4484: -- hr_utility.trace_off;
4485: --
4486: END populate_ghr_cpdf_temp;
4487:
4488: