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_CPDF_EHRIS dependencies on HR_UTILITY

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

9: PROCEDURE initialize_record
10: IS
11: l_proc varchar2(30) := 'initialize_record';
12: BEGIN
13: hr_utility.set_location('Entering:'||l_proc,5);
14: g_ghr_cpdf_temp.academic_discipline := NULL;
15: g_ghr_cpdf_temp.agency_code := NULL;
16: g_ghr_cpdf_temp.annuitant_indicator := NULL;
17: g_ghr_cpdf_temp.award_amount := NULL;

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

219: PROCEDURE cleanup_table
220: IS
221: l_proc varchar2(30) := 'cleanup_table';
222: BEGIN
223: hr_utility.set_location('Entering:'||l_proc,5);
224: DELETE FROM ghr_cpdf_temp
225: WHERE report_type = 'STATUS'
226: AND session_id = userenv('SESSIONID');
227: END cleanup_table;

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

282: l_result varchar2(20);
283: l_non_asg_ei_data PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
284:
285: BEGIN
286: hr_utility.set_location('Entering:'||l_proc,5);
287:
288: l_ASGNEI_DATA := l_ASGNEI_DATA_INIT;
289: -- Begin Bug# 4753092
290: g_message_name := 'Assignment EIT: Assigment RPA';

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

388: l_last_name per_all_people.last_name%type;
389:
390:
391: BEGIN
392: hr_utility.set_location('Entering:'||l_proc,5);
393: --Begin Bug# 4753092
394: g_message_name := 'Fetch Person Details';
395: --End Bug# 4753092
396:

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

554:
555: BEGIN
556:
557: -- bug 749386 use ghr_api.return_education_details and ghr_api.return_special_information
558: hr_utility.set_location('Entering:'||l_proc,5);
559: --Begin Bug# 4753092
560: g_message_name := 'Special Info: Education Dtls';
561: --End Bug# 4753092
562: ghr_api.return_education_details(p_person_id => p_sr_person_id,

Line 578: hr_utility.set_message(8301,'GHR_38275_INV_SP_INFO_TYPE');

574: l_id_flex_num := flex_num.id_flex_num;
575: End loop;
576:
577: If l_id_flex_num is null then
578: hr_utility.set_message(8301,'GHR_38275_INV_SP_INFO_TYPE');
579: hr_utility.raise_error;
580: End if;
581:
582: l_lang_cnt := 1;

Line 579: hr_utility.raise_error;

575: End loop;
576:
577: If l_id_flex_num is null then
578: hr_utility.set_message(8301,'GHR_38275_INV_SP_INFO_TYPE');
579: hr_utility.raise_error;
580: End if;
581:
582: l_lang_cnt := 1;
583: FOR special_info IN c_sit_oldest LOOP

Line 753: hr_utility.set_message(8301,'GHR_38275_INV_SP_INFO_TYPE');

749: l_id_flex_num := flex_num.id_flex_num;
750: End loop;
751:
752: If l_id_flex_num is null then
753: hr_utility.set_message(8301,'GHR_38275_INV_SP_INFO_TYPE');
754: hr_utility.raise_error;
755: End if;
756:
757: l_lang_cnt := 0;

Line 754: hr_utility.raise_error;

750: End loop;
751:
752: If l_id_flex_num is null then
753: hr_utility.set_message(8301,'GHR_38275_INV_SP_INFO_TYPE');
754: hr_utility.raise_error;
755: End if;
756:
757: l_lang_cnt := 0;
758: FOR special_info IN c_sit_latest LOOP

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

802: l_message_name varchar2(50);
803: l_log_text varchar2(2000);
804:
805: BEGIN
806: hr_utility.set_location('Entering:'||l_proc,5);
807: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
808: -- Begin Bug# 4753092
809: g_message_name := 'Person EIT: Uniformed Serivces';
810: -- End Bug# 4753092

Line 974: hr_utility.set_location(l_proc,10);

970: For extra_info in c_extra_info_id loop
971: l_cnt := l_cnt + 1;
972: l_extra_info_id := extra_info.person_extra_info_id;
973: If l_extra_info_id is not null then
974: hr_utility.set_location(l_proc,10);
975: ghr_history_api.get_g_session_var(l_session);
976: ghr_history_fetch.fetch_peopleei ( p_person_extra_info_id => l_extra_info_id,
977: p_date_effective => p_sr_report_date,
978: p_altered_pa_request_id => l_session.altered_pa_request_id,

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

1165: l_POSIEI_DATA PER_POSITION_EXTRA_INFO%ROWTYPE;
1166: l_POSIEI_DATA_INIT PER_POSITION_EXTRA_INFO%ROWTYPE;
1167: l_to_pay_table_id ghr_cpdf_temp.to_pay_table_id%type;
1168: BEGIN
1169: hr_utility.set_location('Entering:'||l_proc,5);
1170:
1171: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
1172: -- Begin Bug# 4753092
1173: g_message_name := 'Position EIT: Position Group1';

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

1282: WHERE GRADE_ID = g_grade_id);
1283:
1284: l_GRADEFREC GRADEFCUR%ROWTYPE;
1285: BEGIN
1286: hr_utility.set_location('Entering:'||l_proc,5);
1287:
1288: OPEN GRADEFCUR;
1289:
1290: FETCH GRADEFCUR INTO l_GRADEFREC;

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

1319:
1320: -- Declared record despite a "one column query" for future maintenance
1321: l_JOBDEF_REC JOBDEF_CUR%ROWTYPE;
1322: BEGIN
1323: hr_utility.set_location('Entering:'||l_proc,5);
1324:
1325: OPEN JOBDEF_CUR;
1326:
1327: FETCH JOBDEF_CUR INTO l_JOBDEF_REC;

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

1375: FROM hr_locations_all
1376: WHERE location_id = g_location_id;
1377:
1378: BEGIN
1379: hr_utility.set_location('Entering:'||l_proc,5);
1380: -- Begin Bug# 4753092
1381: g_message_name := 'Duty Station Details';
1382: -- End Bug# 4753092
1383: OPEN DUTSTACUR;

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

1436: And trunc(p_sr_report_date) between date_from and
1437: nvl(date_to, p_sr_report_date);
1438:
1439: BEGIN
1440: hr_utility.set_location('Entering:'||l_proc,5);
1441: g_message_name := 'Person Work Address Details';
1442:
1443: FOR cur_wrk_addr_rec IN workaddcur LOOP
1444: --Bug # 9817051 added substr in work address lines as it is coming as 240 from base table

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

1499: connect by altered_pa_request_id = prior pa_request_id);
1500: --Bug # 4122470
1501:
1502: BEGIN
1503: hr_utility.set_location('Entering:'||l_proc,5);
1504:
1505: l_value := null;
1506: l_effective_start_date := null;
1507: -- Begin Bug# 4753092

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

1830:
1831: l_STATE_CNTRY_CODE GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;
1832:
1833: BEGIN
1834: hr_utility.set_location('Entering:'||l_proc,5);
1835:
1836: OPEN CALCDUTSTA_CUR;
1837:
1838: FETCH CALCDUTSTA_CUR INTO l_STATE_CNTRY_CODE;

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

1866: l_log_text ghr_process_log.log_text%type;
1867: l_message_name ghr_process_log.message_name%type;
1868:
1869: BEGIN
1870: hr_utility.set_location('Entering:'||l_proc,5);
1871:
1872: -- Bug#3231946 Added reference to parameters as the function definition is changed
1873: IF NOT (ghr_cpdf_dynrpt.get_loc_pay_area_code(p_duty_station_id => g_duty_station_id,
1874: p_effective_date => g_ghr_cpdf_temp.effective_date) <> '99')

Line 1885: hr_utility.set_location('Inside insert row Locality adj' || g_ghr_cpdf_temp.to_locality_adj,111 );

1881: g_ghr_cpdf_temp.from_locality_adj := NULL;
1882: g_ghr_cpdf_temp.to_locality_adj := NULL;
1883: END IF;
1884:
1885: hr_utility.set_location('Inside insert row Locality adj' || g_ghr_cpdf_temp.to_locality_adj,111 );
1886:
1887:
1888: INSERT INTO ghr_cpdf_temp (
1889: report_type

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

2320: PROCEDURE purge_suppression
2321: IS
2322: l_proc varchar2(30) := 'purge_suppression';
2323: BEGIN
2324: hr_utility.set_location('Entering:'||l_proc,5);
2325:
2326: -- bug 743502 moved the checking of agency code matching the parameter passed in to
2327: -- to as soon as possible, not here at the end!
2328: -- Bug#5225838 Modified citizenship <> '1' to citizenship <>'Y'

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

2369: LENGTH(p_last_name)),' ') = ' '||UPPER(LOOKUP_CODE)
2370: AND ROWNUM = 1;
2371: BEGIN
2372:
2373: hr_utility.set_location('Entering:'||l_proc,5);
2374:
2375: IF GET_SUFFIX%ISOPEN THEN
2376: CLOSE GET_SUFFIX;
2377: END IF;

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

3486: END pp_gs_equivalent;
3487:
3488:
3489: BEGIN
3490: hr_utility.set_location('Entering:'||l_proc,5);
3491: ghr_mto_int.set_log_program_name('GHR_CPDF_EHRI_STATRPT');
3492: g_report_date := p_report_date;
3493: g_agency := p_agency;
3494: l_records_found:=FALSE;

Line 3690: hr_utility.set_location('Inside PRD ' || g_ghr_cpdf_temp.to_locality_adj,111 );

3686:
3687:
3688: -- Bug 4714292 EHRI Reports Changes for EOY 05
3689: IF g_ghr_cpdf_temp.to_pay_rate_determinant IN ('5','6','E','F') THEN
3690: hr_utility.set_location('Inside PRD ' || g_ghr_cpdf_temp.to_locality_adj,111 );
3691: g_ghr_cpdf_temp.to_spl_rate_supplement := g_ghr_cpdf_temp.to_locality_adj;
3692: g_ghr_cpdf_temp.to_locality_adj := NULL;
3693: ELSE
3694: g_ghr_cpdf_temp.to_spl_rate_supplement := NULL;

Line 3768: hr_utility.set_location('Inside EHRI_STATRPT_ERROR exception ',30);

3764: NULL;
3765:
3766: EXCEPTION
3767: WHEN CPDF_STATRPT_ERROR THEN
3768: hr_utility.set_location('Inside EHRI_STATRPT_ERROR exception ',30);
3769: ghr_mto_int.log_message(p_procedure => g_message_name, --Bug# 4753092
3770: p_message => l_log_text);
3771: --dbms_output.put_line('Name '||l_full_name);
3772: --dbms_output.put_line('Name '||l_log_text);