APPS.GHR_EHRI_DYNRPT dependencies on HR_UTILITY

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

2257: LENGTH(p_last_name)),' ') = ' '||UPPER(LOOKUP_CODE)
2258: AND ROWNUM = 1;
2259: BEGIN
2260:
2261: hr_utility.set_location('Entering:'||l_proc,5);
2262:
2263: IF GET_SUFFIX%ISOPEN THEN
2264: CLOSE GET_SUFFIX;
2265: END IF;

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

2469:
2470: BEGIN
2471: --
2472: l_records_found:=FALSE;
2473: -- hr_utility.trace_on(null,'venkat');
2474: hr_utility.set_location('Entering:'||l_proc, 10);
2475: --
2476: ghr_mto_int.set_log_program_name('ghr_ehri_dynrpt');
2477: --

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

2470: BEGIN
2471: --
2472: l_records_found:=FALSE;
2473: -- hr_utility.trace_on(null,'venkat');
2474: hr_utility.set_location('Entering:'||l_proc, 10);
2475: --
2476: ghr_mto_int.set_log_program_name('ghr_ehri_dynrpt');
2477: --
2478: IF p_end_date > p_start_Date THEN

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

2541:
2542: l_ghr_pa_requests_rec.employee_last_name := l_last_name;
2543: --End Bug# 4648811
2544:
2545: hr_utility.set_location(l_proc||' Check non_us_citizen_and_foreign_ds' ,30);
2546: --
2547: -- 2.1) Do not include PAR's for a non US Citizen in a foreign country
2548: IF non_us_citizen_and_foreign_ds (p_citizenship => l_ghr_pa_requests_rec.citizenship
2549: ,p_duty_station_code => l_ghr_pa_requests_rec.duty_station_code) THEN

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

2549: ,p_duty_station_code => l_ghr_pa_requests_rec.duty_station_code) THEN
2550: GOTO end_par_loop; -- loop for the next one!
2551: END IF;
2552: --
2553: hr_utility.set_location(l_proc||' Customer exclusion hook' ,40);
2554: --
2555: -- Bug 714944 -- Added exclusion of NAF:
2556: IF exclude_position (p_position_id => NVL(l_ghr_pa_requests_rec.to_position_id
2557: ,l_ghr_pa_requests_rec.from_position_id)

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

2593: -- If we are just doing a count, we do not need to do the second bit!
2594: --
2595: -- 3.1) Get all info from PAR table itself
2596: --
2597: hr_utility.set_location(l_proc||' populate cpdf temp from par' ,50);
2598: --
2599: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
2600: -- Agency Subelement Code
2601: l_ghr_cpdf_temp_rec.to_national_identifier := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);

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

4131: NULL;
4132:
4133: EXCEPTION
4134: WHEN EHRI_DYNRPT_ERROR THEN
4135: hr_utility.set_location('Inside EHRI_DYNRPT_ERROR exception ',30);
4136: ghr_mto_int.log_message(p_procedure => l_message_name,
4137: p_message => l_log_text
4138: );
4139: COMMIT;

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

4137: p_message => l_log_text
4138: );
4139: COMMIT;
4140: WHEN OTHERS THEN
4141: hr_utility.set_location('Inside WHEN_OTHERS exception ',40);
4142: l_message_name := 'Unhandled Error';
4143: l_log_text := 'Unhandled Error for pa_request_id: '||
4144: l_ghr_pa_requests_rec.pa_request_id ||
4145: ' ; SSN/employee last name' ||

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

4180: );
4181: END IF;
4182:
4183: --
4184: hr_utility.set_location('Leaving:'||l_proc, 99);
4185: -- hr_utility.trace_off;
4186: --
4187: END populate_ghr_cpdf_temp;
4188:

Line 4185: -- hr_utility.trace_off;

4181: END IF;
4182:
4183: --
4184: hr_utility.set_location('Leaving:'||l_proc, 99);
4185: -- hr_utility.trace_off;
4186: --
4187: END populate_ghr_cpdf_temp;
4188:
4189: