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.

[Home] [Help]

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 222: hr_utility.set_location('Entering:'||l_proc,5);

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

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

278: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
279: l_result varchar2(20);
280:
281: BEGIN
282: hr_utility.set_location('Entering:'||l_proc,5);
283:
284: l_ASGNEI_DATA := l_ASGNEI_DATA_INIT;
285: -- Begin Bug# 4753092
286: g_message_name := 'Assignment EIT: Assigment RPA';

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

376: l_last_name per_all_people.last_name%type;
377:
378:
379: BEGIN
380: hr_utility.set_location('Entering:'||l_proc,5);
381: --Begin Bug# 4753092
382: g_message_name := 'Fetch Person Details';
383: --End Bug# 4753092
384:

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

541:
542: BEGIN
543:
544: -- bug 749386 use ghr_api.return_education_details and ghr_api.return_special_information
545: hr_utility.set_location('Entering:'||l_proc,5);
546: --Begin Bug# 4753092
547: g_message_name := 'Special Info: Education Dtls';
548: --End Bug# 4753092
549: ghr_api.return_education_details(p_person_id => p_sr_person_id,

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

561: l_id_flex_num := flex_num.id_flex_num;
562: End loop;
563:
564: If l_id_flex_num is null then
565: hr_utility.set_message(8301,'GHR_38275_INV_SP_INFO_TYPE');
566: hr_utility.raise_error;
567: End if;
568:
569: l_lang_cnt := 1;

Line 566: hr_utility.raise_error;

562: End loop;
563:
564: If l_id_flex_num is null then
565: hr_utility.set_message(8301,'GHR_38275_INV_SP_INFO_TYPE');
566: hr_utility.raise_error;
567: End if;
568:
569: l_lang_cnt := 1;
570: FOR special_info IN c_sit_oldest LOOP

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

736: l_id_flex_num := flex_num.id_flex_num;
737: End loop;
738:
739: If l_id_flex_num is null then
740: hr_utility.set_message(8301,'GHR_38275_INV_SP_INFO_TYPE');
741: hr_utility.raise_error;
742: End if;
743:
744: l_lang_cnt := 0;

Line 741: hr_utility.raise_error;

737: End loop;
738:
739: If l_id_flex_num is null then
740: hr_utility.set_message(8301,'GHR_38275_INV_SP_INFO_TYPE');
741: hr_utility.raise_error;
742: End if;
743:
744: l_lang_cnt := 0;
745: FOR special_info IN c_sit_latest LOOP

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

789: l_message_name varchar2(50);
790: l_log_text varchar2(2000);
791:
792: BEGIN
793: hr_utility.set_location('Entering:'||l_proc,5);
794: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
795: -- Begin Bug# 4753092
796: g_message_name := 'Person EIT: Uniformed Serivces';
797: -- End Bug# 4753092

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

948: For extra_info in c_extra_info_id loop
949: l_cnt := l_cnt + 1;
950: l_extra_info_id := extra_info.person_extra_info_id;
951: If l_extra_info_id is not null then
952: hr_utility.set_location(l_proc,10);
953: ghr_history_api.get_g_session_var(l_session);
954: ghr_history_fetch.fetch_peopleei ( p_person_extra_info_id => l_extra_info_id,
955: p_date_effective => p_sr_report_date,
956: p_altered_pa_request_id => l_session.altered_pa_request_id,

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

1130: l_POSIEI_DATA PER_POSITION_EXTRA_INFO%ROWTYPE;
1131: l_POSIEI_DATA_INIT PER_POSITION_EXTRA_INFO%ROWTYPE;
1132: l_to_pay_table_id ghr_cpdf_temp.to_pay_table_id%type;
1133: BEGIN
1134: hr_utility.set_location('Entering:'||l_proc,5);
1135:
1136: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
1137: -- Begin Bug# 4753092
1138: g_message_name := 'Position EIT: Position Group1';

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

1236: WHERE GRADE_ID = g_grade_id);
1237:
1238: l_GRADEFREC GRADEFCUR%ROWTYPE;
1239: BEGIN
1240: hr_utility.set_location('Entering:'||l_proc,5);
1241:
1242: OPEN GRADEFCUR;
1243:
1244: FETCH GRADEFCUR INTO l_GRADEFREC;

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

1273:
1274: -- Declared record despite a "one column query" for future maintenance
1275: l_JOBDEF_REC JOBDEF_CUR%ROWTYPE;
1276: BEGIN
1277: hr_utility.set_location('Entering:'||l_proc,5);
1278:
1279: OPEN JOBDEF_CUR;
1280:
1281: FETCH JOBDEF_CUR INTO l_JOBDEF_REC;

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

1329: FROM hr_locations_all
1330: WHERE location_id = g_location_id;
1331:
1332: BEGIN
1333: hr_utility.set_location('Entering:'||l_proc,5);
1334: -- Begin Bug# 4753092
1335: g_message_name := 'Duty Station Details';
1336: -- End Bug# 4753092
1337: OPEN DUTSTACUR;

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

1390: And trunc(p_sr_report_date) between date_from and
1391: nvl(date_to, p_sr_report_date);
1392:
1393: BEGIN
1394: hr_utility.set_location('Entering:'||l_proc,5);
1395: g_message_name := 'Person Work Address Details';
1396:
1397: FOR cur_wrk_addr_rec IN workaddcur LOOP
1398: p_sr_ghr_cpdf_temp.work_address_line1 := cur_wrk_addr_rec.address_line1;

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

1430: l_value VARCHAR2(250);
1431: l_effective_start_date DATE:= NULL;
1432:
1433: BEGIN
1434: hr_utility.set_location('Entering:'||l_proc,5);
1435:
1436: l_value := null;
1437: l_effective_start_date := null;
1438: -- Begin Bug# 4753092

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

1753:
1754: l_STATE_CNTRY_CODE GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;
1755:
1756: BEGIN
1757: hr_utility.set_location('Entering:'||l_proc,5);
1758:
1759: OPEN CALCDUTSTA_CUR;
1760:
1761: FETCH CALCDUTSTA_CUR INTO l_STATE_CNTRY_CODE;

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

1789: l_log_text ghr_process_log.log_text%type;
1790: l_message_name ghr_process_log.message_name%type;
1791:
1792: BEGIN
1793: hr_utility.set_location('Entering:'||l_proc,5);
1794:
1795: -- Bug#3231946 Added reference to parameters as the function definition is changed
1796: IF NOT (ghr_cpdf_dynrpt.get_loc_pay_area_code(p_duty_station_id => g_duty_station_id,
1797: p_effective_date => g_ghr_cpdf_temp.effective_date) <> '99')

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

1804: g_ghr_cpdf_temp.from_locality_adj := NULL;
1805: g_ghr_cpdf_temp.to_locality_adj := NULL;
1806: END IF;
1807:
1808: hr_utility.set_location('Inside insert row Locality adj' || g_ghr_cpdf_temp.to_locality_adj,111 );
1809:
1810:
1811: INSERT INTO ghr_cpdf_temp (
1812: report_type

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

2241: PROCEDURE purge_suppression
2242: IS
2243: l_proc varchar2(30) := 'purge_suppression';
2244: BEGIN
2245: hr_utility.set_location('Entering:'||l_proc,5);
2246:
2247: -- bug 743502 moved the checking of agency code matching the parameter passed in to
2248: -- to as soon as possible, not here at the end!
2249: -- Bug#5225838 Modified citizenship <> '1' to citizenship <>'Y'

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

2290: LENGTH(p_last_name)),' ') = ' '||UPPER(LOOKUP_CODE)
2291: AND ROWNUM = 1;
2292: BEGIN
2293:
2294: hr_utility.set_location('Entering:'||l_proc,5);
2295:
2296: IF GET_SUFFIX%ISOPEN THEN
2297: CLOSE GET_SUFFIX;
2298: END IF;

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

3338: END pp_gs_equivalent;
3339:
3340:
3341: BEGIN
3342: hr_utility.set_location('Entering:'||l_proc,5);
3343: ghr_mto_int.set_log_program_name('GHR_CPDF_EHRI_STATRPT');
3344: g_report_date := p_report_date;
3345: g_agency := p_agency;
3346: l_records_found:=FALSE;

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

3533:
3534:
3535: -- Bug 4714292 EHRI Reports Changes for EOY 05
3536: IF g_ghr_cpdf_temp.to_pay_rate_determinant IN ('5','6','E','F') THEN
3537: hr_utility.set_location('Inside PRD ' || g_ghr_cpdf_temp.to_locality_adj,111 );
3538: g_ghr_cpdf_temp.to_spl_rate_supplement := g_ghr_cpdf_temp.to_locality_adj;
3539: g_ghr_cpdf_temp.to_locality_adj := NULL;
3540: ELSE
3541: g_ghr_cpdf_temp.to_spl_rate_supplement := NULL;

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

3608: NULL;
3609:
3610: EXCEPTION
3611: WHEN CPDF_STATRPT_ERROR THEN
3612: hr_utility.set_location('Inside EHRI_STATRPT_ERROR exception ',30);
3613: ghr_mto_int.log_message(p_procedure => g_message_name, --Bug# 4753092
3614: p_message => l_log_text);
3615: --dbms_output.put_line('Name '||l_full_name);
3616: --dbms_output.put_line('Name '||l_log_text);