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

Line 512: hr_utility.set_location('duty station code is OPM Mandated change ' ,20);

508: 'TC1000000', 'TC1030000', 'TC1040000', 'TC1050000', 'TC1200000',
509: 'TC1300000', 'TC1500000', 'WS0000000', '422760045')
510: then
511: l_ret_val := TRUE;
512: hr_utility.set_location('duty station code is OPM Mandated change ' ,20);
513: else
514: l_ret_val := FALSE;
515: hr_utility.set_location('duty station code is not OPM Mandated change ' ,20);
516: end if;

Line 515: hr_utility.set_location('duty station code is not OPM Mandated change ' ,20);

511: l_ret_val := TRUE;
512: hr_utility.set_location('duty station code is OPM Mandated change ' ,20);
513: else
514: l_ret_val := FALSE;
515: hr_utility.set_location('duty station code is not OPM Mandated change ' ,20);
516: end if;
517:
518: return l_ret_val;
519: END opm_mandated_duty_stations;

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

552: and effective_start_date = to_date('19'||'99/01/01','YYYY/MM/DD');
553:
554:
555: BEGIN
556: hr_utility.set_location('Entering ...' || l_proc,5);
557:
558: l_location_id := null;
559: l_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family(p_first_noa_id);
560:

Line 570: hr_utility.set_location('Location_id ...' || l_location_id,10);

566: IF l_noa_family_code = 'CORRECT' then
567: l_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family(p_second_noa_id);
568: END IF;
569:
570: hr_utility.set_location('Location_id ...' || l_location_id,10);
571: hr_utility.set_location('noa_family_code ...' || l_noa_family_code,10);
572: hr_utility.set_location('form ds code ...' || p_form_ds_code,10);
573: IF l_noa_family_code in
574: ('APP','CHG_DUTY_STATION','CONV_APP','POS_CHG','POS_ESTABLISH',

Line 571: hr_utility.set_location('noa_family_code ...' || l_noa_family_code,10);

567: l_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family(p_second_noa_id);
568: END IF;
569:
570: hr_utility.set_location('Location_id ...' || l_location_id,10);
571: hr_utility.set_location('noa_family_code ...' || l_noa_family_code,10);
572: hr_utility.set_location('form ds code ...' || p_form_ds_code,10);
573: IF l_noa_family_code in
574: ('APP','CHG_DUTY_STATION','CONV_APP','POS_CHG','POS_ESTABLISH',
575: 'REALIGNMENT','REASSIGNMENT','RECRUIT_FILL',

Line 572: hr_utility.set_location('form ds code ...' || p_form_ds_code,10);

568: END IF;
569:
570: hr_utility.set_location('Location_id ...' || l_location_id,10);
571: hr_utility.set_location('noa_family_code ...' || l_noa_family_code,10);
572: hr_utility.set_location('form ds code ...' || p_form_ds_code,10);
573: IF l_noa_family_code in
574: ('APP','CHG_DUTY_STATION','CONV_APP','POS_CHG','POS_ESTABLISH',
575: 'REALIGNMENT','REASSIGNMENT','RECRUIT_FILL',
576: 'RETURN_TO_DUTY','SALARY_CHG') then

Line 586: hr_utility.set_location('duty station id ...' || l_duty_station_id,15);

582: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
583: (p_location_id => l_location_id
584: ,p_duty_station_id => l_duty_station_id);
585:
586: hr_utility.set_location('duty station id ...' || l_duty_station_id,15);
587:
588: ghr_pa_requests_pkg.get_duty_station_details
589: (p_duty_station_id => l_duty_station_id
590: ,p_effective_date => p_effective_date

Line 594: hr_utility.set_location('duty station code..' || l_duty_station_code,20);

590: ,p_effective_date => p_effective_date
591: ,p_duty_station_code => l_duty_station_code
592: ,p_duty_station_desc => l_duty_station_desc);
593:
594: hr_utility.set_location('duty station code..' || l_duty_station_code,20);
595: else
596: l_duty_station_code := null;
597: hr_utility.set_location('duty station code..is null ' ,20);
598: end if;

Line 597: hr_utility.set_location('duty station code..is null ' ,20);

593:
594: hr_utility.set_location('duty station code..' || l_duty_station_code,20);
595: else
596: l_duty_station_code := null;
597: hr_utility.set_location('duty station code..is null ' ,20);
598: end if;
599:
600: if p_effective_date < to_date('19'||'99/01/01','YYYY/MM/DD') then
601: if nvl(p_form_ds_code, '123456789') <> nvl(l_duty_station_code, '123456789') then

Line 607: hr_utility.set_location('GHR_38147_NOAC_RPA_900' ,25);

603: if l_noa_family_code in
604: ('CHG_DUTY_STATION','CONV_APP','POS_CHG','POS_ESTABLISH',
605: 'REALIGNMENT','REASSIGNMENT','RECRUIT_FILL',
606: 'RETURN_TO_DUTY','SALARY_CHG') then
607: hr_utility.set_location('GHR_38147_NOAC_RPA_900' ,25);
608: hr_utility.set_message(8301,'GHR_38147_NOAC_RPA_900');
609: raise duty_sta_exp;
610: else
611: if l_noa_family_code = 'APP' then

Line 608: hr_utility.set_message(8301,'GHR_38147_NOAC_RPA_900');

604: ('CHG_DUTY_STATION','CONV_APP','POS_CHG','POS_ESTABLISH',
605: 'REALIGNMENT','REASSIGNMENT','RECRUIT_FILL',
606: 'RETURN_TO_DUTY','SALARY_CHG') then
607: hr_utility.set_location('GHR_38147_NOAC_RPA_900' ,25);
608: hr_utility.set_message(8301,'GHR_38147_NOAC_RPA_900');
609: raise duty_sta_exp;
610: else
611: if l_noa_family_code = 'APP' then
612: if opm_mandated_duty_stations(p_form_ds_code) then

Line 613: hr_utility.set_location('GHR_38148_RERUN_DUTYSTN_CONV' ,25);

609: raise duty_sta_exp;
610: else
611: if l_noa_family_code = 'APP' then
612: if opm_mandated_duty_stations(p_form_ds_code) then
613: hr_utility.set_location('GHR_38148_RERUN_DUTYSTN_CONV' ,25);
614: hr_utility.set_message(8301,'GHR_38148_RERUN_DUTYSTN_CONV');
615: raise duty_sta_exp;
616: end if;
617: end if;

Line 614: hr_utility.set_message(8301,'GHR_38148_RERUN_DUTYSTN_CONV');

610: else
611: if l_noa_family_code = 'APP' then
612: if opm_mandated_duty_stations(p_form_ds_code) then
613: hr_utility.set_location('GHR_38148_RERUN_DUTYSTN_CONV' ,25);
614: hr_utility.set_message(8301,'GHR_38148_RERUN_DUTYSTN_CONV');
615: raise duty_sta_exp;
616: end if;
617: end if;
618: end if;

Line 625: hr_utility.set_location('GHR_38148_RERUN_DUTYSTN_CONV' ,25);

621: ('CHG_DUTY_STATION','CONV_APP','POS_CHG','POS_ESTABLISH',
622: 'REALIGNMENT','REASSIGNMENT','RECRUIT_FILL',
623: 'RETURN_TO_DUTY','SALARY_CHG') then
624: if opm_mandated_duty_stations(p_form_ds_code) then
625: hr_utility.set_location('GHR_38148_RERUN_DUTYSTN_CONV' ,25);
626: hr_utility.set_message(8301,'GHR_38148_RERUN_DUTYSTN_CONV');
627: raise duty_sta_exp;
628: end if;
629: else

Line 626: hr_utility.set_message(8301,'GHR_38148_RERUN_DUTYSTN_CONV');

622: 'REALIGNMENT','REASSIGNMENT','RECRUIT_FILL',
623: 'RETURN_TO_DUTY','SALARY_CHG') then
624: if opm_mandated_duty_stations(p_form_ds_code) then
625: hr_utility.set_location('GHR_38148_RERUN_DUTYSTN_CONV' ,25);
626: hr_utility.set_message(8301,'GHR_38148_RERUN_DUTYSTN_CONV');
627: raise duty_sta_exp;
628: end if;
629: else
630: if l_noa_family_code = 'APP' then

Line 632: hr_utility.set_location('GHR_38149_RERUN_CHECK_DUTYSTN' ,25);

628: end if;
629: else
630: if l_noa_family_code = 'APP' then
631: if opm_mandated_duty_stations(p_form_ds_code) then
632: hr_utility.set_location('GHR_38149_RERUN_CHECK_DUTYSTN' ,25);
633: hr_utility.set_message(8301,'GHR_38149_RERUN_CHECK_DUTYSTN');
634: raise duty_sta_exp;
635: end if;
636: end if;

Line 633: hr_utility.set_message(8301,'GHR_38149_RERUN_CHECK_DUTYSTN');

629: else
630: if l_noa_family_code = 'APP' then
631: if opm_mandated_duty_stations(p_form_ds_code) then
632: hr_utility.set_location('GHR_38149_RERUN_CHECK_DUTYSTN' ,25);
633: hr_utility.set_message(8301,'GHR_38149_RERUN_CHECK_DUTYSTN');
634: raise duty_sta_exp;
635: end if;
636: end if;
637: end if;

Line 645: hr_utility.set_location('GHR_38147_NOAC_RPA_900' ,25);

641: ('CHG_DUTY_STATION','CONV_APP','POS_CHG','POS_ESTABLISH',
642: 'REALIGNMENT','REASSIGNMENT','RECRUIT_FILL',
643: 'RETURN_TO_DUTY','SALARY_CHG') then
644: if l_exists then
645: hr_utility.set_location('GHR_38147_NOAC_RPA_900' ,25);
646: hr_utility.set_message(8301,'GHR_38147_NOAC_RPA_900');
647: raise duty_sta_exp;
648: else
649: if opm_mandated_duty_stations(p_form_ds_code) then

Line 646: hr_utility.set_message(8301,'GHR_38147_NOAC_RPA_900');

642: 'REALIGNMENT','REASSIGNMENT','RECRUIT_FILL',
643: 'RETURN_TO_DUTY','SALARY_CHG') then
644: if l_exists then
645: hr_utility.set_location('GHR_38147_NOAC_RPA_900' ,25);
646: hr_utility.set_message(8301,'GHR_38147_NOAC_RPA_900');
647: raise duty_sta_exp;
648: else
649: if opm_mandated_duty_stations(p_form_ds_code) then
650: hr_utility.set_location('GHR_38148_RERUN_DUTYSTN_CONV' ,25);

Line 650: hr_utility.set_location('GHR_38148_RERUN_DUTYSTN_CONV' ,25);

646: hr_utility.set_message(8301,'GHR_38147_NOAC_RPA_900');
647: raise duty_sta_exp;
648: else
649: if opm_mandated_duty_stations(p_form_ds_code) then
650: hr_utility.set_location('GHR_38148_RERUN_DUTYSTN_CONV' ,25);
651: hr_utility.set_message(8301,'GHR_38148_RERUN_DUTYSTN_CONV');
652: raise duty_sta_exp;
653: end if;
654: end if;

Line 651: hr_utility.set_message(8301,'GHR_38148_RERUN_DUTYSTN_CONV');

647: raise duty_sta_exp;
648: else
649: if opm_mandated_duty_stations(p_form_ds_code) then
650: hr_utility.set_location('GHR_38148_RERUN_DUTYSTN_CONV' ,25);
651: hr_utility.set_message(8301,'GHR_38148_RERUN_DUTYSTN_CONV');
652: raise duty_sta_exp;
653: end if;
654: end if;
655: end if;

Line 660: hr_utility.set_location('Leaving ...' || l_proc,30);

656:
657: end if;
658: end if;
659: END IF;
660: hr_utility.set_location('Leaving ...' || l_proc,30);
661: p_message_set := l_message_set;
662: exception when duty_sta_exp then
663: l_message_set := TRUE;
664: p_message_set := l_message_set;

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

753: and pos1.availability_status_id = typ1.shared_type_id
754: order by 1;
755:
756: BEGIN
757: hr_utility.set_location('Entering ...' || l_proc,5);
758:
759: for cur_pos_rec in cur_pos
760: loop
761: l_effective_start_date := cur_pos_rec.effective_start_date;

Line 783: hr_utility.set_location('Leaving ...' || l_proc,30);

779: end if;
780: end loop;
781: p_message_set := l_message_set;
782:
783: hr_utility.set_location('Leaving ...' || l_proc,30);
784:
785: EXCEPTION
786: WHEN OTHERS THEN
787: p_message_set := NULL;

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

812: and pos.availability_status_id = typ.shared_type_id
813: order by 1;
814:
815: BEGIN
816: hr_utility.set_location('Entering ...' || l_proc,5);
817:
818: for cur_pos_rec in cur_pos
819: loop
820: l_effective_start_date := cur_pos_rec.effective_start_date;

Line 832: hr_utility.set_location('Leaving ...' || l_proc,30);

828:
829: end loop;
830: p_message_set := l_message_set;
831:
832: hr_utility.set_location('Leaving ...' || l_proc,30);
833: EXCEPTION
834: WHEN OTHERS THEN
835: p_message_set := NULL;
836: END chk_position_hire_status;