APPS.GHR_CPDF_DYNRPT dependencies on HR_UTILITY

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

1133: LENGTH(p_last_name)),' ') = ' '||UPPER(LOOKUP_CODE)
1134: AND ROWNUM = 1;
1135: BEGIN
1136:
1137: hr_utility.set_location('Entering:'||l_proc,5);
1138:
1139: IF GET_SUFFIX%ISOPEN THEN
1140: CLOSE GET_SUFFIX;
1141: END IF;

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

1308:
1309: BEGIN
1310: --
1311: l_records_found:=FALSE;
1312: -- hr_utility.trace_on(null,'venkat');
1313: hr_utility.set_location('Entering:'||l_proc, 10);
1314: --
1315: ghr_mto_int.set_log_program_name('GHR_CPDF_DYNRPT');
1316: --

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

1309: BEGIN
1310: --
1311: l_records_found:=FALSE;
1312: -- hr_utility.trace_on(null,'venkat');
1313: hr_utility.set_location('Entering:'||l_proc, 10);
1314: --
1315: ghr_mto_int.set_log_program_name('GHR_CPDF_DYNRPT');
1316: --
1317: IF p_end_date > p_start_Date THEN

Line 1321: hr_utility.set_location(l_proc||' Get PA Request data', 20);

1317: IF p_end_date > p_start_Date THEN
1318:
1319: FOR cur_get_pars_rec IN cur_get_pars
1320: LOOP
1321: hr_utility.set_location(l_proc||' Get PA Request data', 20);
1322: -- 1) Get PA Request data
1323: l_ghr_pa_requests_rec := cur_get_pars_rec;
1324:
1325: l_sf52_rec1 := l_ghr_pa_requests_rec;

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

1446: End if;
1447:
1448: l_ghr_pa_requests_rec.employee_last_name := l_last_name;
1449:
1450: hr_utility.set_location(l_proc||' Check non_us_citizen_and_foreign_ds' ,30);
1451: --
1452: -- 2.1) Do not include PAR's for a non US Citizen in a foreign country
1453: IF non_us_citizen_and_foreign_ds (p_citizenship => l_ghr_pa_requests_rec.citizenship
1454: ,p_duty_station_code => l_ghr_pa_requests_rec.duty_station_code) THEN

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

1454: ,p_duty_station_code => l_ghr_pa_requests_rec.duty_station_code) THEN
1455: GOTO end_par_loop; -- loop for the next one!
1456: END IF;
1457: --
1458: hr_utility.set_location(l_proc||' Customer exclusion hook' ,40);
1459: --
1460: -- Bug 714944 -- Added exclusion of NAF:
1461: IF exclude_position (p_position_id => NVL(l_ghr_pa_requests_rec.to_position_id
1462: ,l_ghr_pa_requests_rec.from_position_id)

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

1499: -- If we are just doing a count, we do not need to do the second bit!
1500: --
1501: -- 3.1) Get all info from PAR table itself
1502: --
1503: hr_utility.set_location(l_proc||' populate cpdf temp from par' ,50);
1504: --
1505: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
1506: l_ghr_cpdf_temp_rec.to_national_identifier := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
1507:

Line 2435: hr_utility.set_location('Inside CPDF_DYNRPT_ERROR exception ',30);

2431: <>
2432: NULL;
2433: EXCEPTION
2434: WHEN CPDF_DYNRPT_ERROR THEN
2435: hr_utility.set_location('Inside CPDF_DYNRPT_ERROR exception ',30);
2436: ghr_mto_int.log_message(p_procedure => l_message_name,
2437: p_message => l_log_text
2438: );
2439: COMMIT;

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

2437: p_message => l_log_text
2438: );
2439: COMMIT;
2440: WHEN OTHERS THEN
2441: hr_utility.set_location('Inside WHEN_OTHERS exception ',40);
2442: --Bug # 9329643 Modified SSN to Emp No
2443: l_message_name := 'Unhandled Error';
2444: l_log_text := 'Unhandled Error for pa_request_id: '||
2445: l_ghr_pa_requests_rec.pa_request_id ||

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

2481: );
2482: END IF;
2483:
2484: --
2485: hr_utility.set_location('Leaving:'||l_proc, 99);
2486: -- hr_utility.trace_off;
2487: --
2488: END populate_ghr_cpdf_temp;
2489: --

Line 2486: -- hr_utility.trace_off;

2482: END IF;
2483:
2484: --
2485: hr_utility.set_location('Leaving:'||l_proc, 99);
2486: -- hr_utility.trace_off;
2487: --
2488: END populate_ghr_cpdf_temp;
2489: --
2490: END ghr_cpdf_dynrpt;