APPS.GHR_CPDF_DYNRPT dependencies on HR_UTILITY

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

1086: LENGTH(p_last_name)),' ') = ' '||UPPER(LOOKUP_CODE)
1087: AND ROWNUM = 1;
1088: BEGIN
1089:
1090: hr_utility.set_location('Entering:'||l_proc,5);
1091:
1092: IF GET_SUFFIX%ISOPEN THEN
1093: CLOSE GET_SUFFIX;
1094: END IF;

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

1223:
1224: BEGIN
1225: --
1226: l_records_found:=FALSE;
1227: -- hr_utility.trace_on(null,'venkat');
1228: hr_utility.set_location('Entering:'||l_proc, 10);
1229: --
1230: ghr_mto_int.set_log_program_name('GHR_CPDF_DYNRPT');
1231: --

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

1224: BEGIN
1225: --
1226: l_records_found:=FALSE;
1227: -- hr_utility.trace_on(null,'venkat');
1228: hr_utility.set_location('Entering:'||l_proc, 10);
1229: --
1230: ghr_mto_int.set_log_program_name('GHR_CPDF_DYNRPT');
1231: --
1232: IF p_end_date > p_start_Date THEN

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

1232: IF p_end_date > p_start_Date THEN
1233:
1234: FOR cur_get_pars_rec IN cur_get_pars
1235: LOOP
1236: hr_utility.set_location(l_proc||' Get PA Request data', 20);
1237: -- 1) Get PA Request data
1238: l_ghr_pa_requests_rec := cur_get_pars_rec;
1239:
1240: l_sf52_rec1 := l_ghr_pa_requests_rec;

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

1331: --End Bug# 4648811
1332:
1333: l_ghr_pa_requests_rec.employee_last_name := l_last_name;
1334:
1335: hr_utility.set_location(l_proc||' Check non_us_citizen_and_foreign_ds' ,30);
1336: --
1337: -- 2.1) Do not include PAR's for a non US Citizen in a foreign country
1338: IF non_us_citizen_and_foreign_ds (p_citizenship => l_ghr_pa_requests_rec.citizenship
1339: ,p_duty_station_code => l_ghr_pa_requests_rec.duty_station_code) THEN

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

1339: ,p_duty_station_code => l_ghr_pa_requests_rec.duty_station_code) THEN
1340: GOTO end_par_loop; -- loop for the next one!
1341: END IF;
1342: --
1343: hr_utility.set_location(l_proc||' Customer exclusion hook' ,40);
1344: --
1345: -- Bug 714944 -- Added exclusion of NAF:
1346: IF exclude_position (p_position_id => NVL(l_ghr_pa_requests_rec.to_position_id
1347: ,l_ghr_pa_requests_rec.from_position_id)

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

1384: -- If we are just doing a count, we do not need to do the second bit!
1385: --
1386: -- 3.1) Get all info from PAR table itself
1387: --
1388: hr_utility.set_location(l_proc||' populate cpdf temp from par' ,50);
1389: --
1390: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
1391: l_ghr_cpdf_temp_rec.to_national_identifier := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
1392:

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

2279: <>
2280: NULL;
2281: EXCEPTION
2282: WHEN CPDF_DYNRPT_ERROR THEN
2283: hr_utility.set_location('Inside CPDF_DYNRPT_ERROR exception ',30);
2284: ghr_mto_int.log_message(p_procedure => l_message_name,
2285: p_message => l_log_text
2286: );
2287: COMMIT;

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

2285: p_message => l_log_text
2286: );
2287: COMMIT;
2288: WHEN OTHERS THEN
2289: hr_utility.set_location('Inside WHEN_OTHERS exception ',40);
2290: l_message_name := 'Unhandled Error';
2291: l_log_text := 'Unhandled Error for pa_request_id: '||
2292: l_ghr_pa_requests_rec.pa_request_id ||
2293: ' ; SSN/employee last name' ||

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

2328: );
2329: END IF;
2330:
2331: --
2332: hr_utility.set_location('Leaving:'||l_proc, 99);
2333: -- hr_utility.trace_off;
2334: --
2335: END populate_ghr_cpdf_temp;
2336: --

Line 2333: -- hr_utility.trace_off;

2329: END IF;
2330:
2331: --
2332: hr_utility.set_location('Leaving:'||l_proc, 99);
2333: -- hr_utility.trace_off;
2334: --
2335: END populate_ghr_cpdf_temp;
2336: --
2337: END ghr_cpdf_dynrpt;