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

Line 575: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);

571: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);
572: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
573: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
574: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
575: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
576: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);
577: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);
578: IF (nvl(l_lwop_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) or
579: (nvl(l_susp_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) or

Line 576: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);

572: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
573: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
574: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
575: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
576: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);
577: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);
578: IF (nvl(l_lwop_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) or
579: (nvl(l_susp_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) or
580: (nvl(l_furlough_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) then

Line 577: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);

573: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
574: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
575: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
576: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);
577: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);
578: IF (nvl(l_lwop_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) or
579: (nvl(l_susp_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) or
580: (nvl(l_furlough_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) then
581: l_susp_flag := 'Y';

Line 602: hr_utility.set_location('l_susp_flag is ' || l_susp_flag ,2);

598:
599: GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP2',p_rpt_date,
600: l_pos_hist_data );
601: l_position_code := l_pos_hist_data.poei_information3;
602: hr_utility.set_location('l_susp_flag is ' || l_susp_flag ,2);
603: hr_utility.set_location('l_assignment_id is ' || l_assignment_id ,3);
604: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
605: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
606: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);

Line 603: hr_utility.set_location('l_assignment_id is ' || l_assignment_id ,3);

599: GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP2',p_rpt_date,
600: l_pos_hist_data );
601: l_position_code := l_pos_hist_data.poei_information3;
602: hr_utility.set_location('l_susp_flag is ' || l_susp_flag ,2);
603: hr_utility.set_location('l_assignment_id is ' || l_assignment_id ,3);
604: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
605: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
606: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
607: hr_utility.set_location('l_work_schedule is ' || l_work_schedule ,3);

Line 604: hr_utility.set_location('l_person_id is ' || l_person_id ,3);

600: l_pos_hist_data );
601: l_position_code := l_pos_hist_data.poei_information3;
602: hr_utility.set_location('l_susp_flag is ' || l_susp_flag ,2);
603: hr_utility.set_location('l_assignment_id is ' || l_assignment_id ,3);
604: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
605: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
606: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
607: hr_utility.set_location('l_work_schedule is ' || l_work_schedule ,3);
608: hr_utility.set_location('l_emp_type is ' || l_emp_type ,3);

Line 605: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);

601: l_position_code := l_pos_hist_data.poei_information3;
602: hr_utility.set_location('l_susp_flag is ' || l_susp_flag ,2);
603: hr_utility.set_location('l_assignment_id is ' || l_assignment_id ,3);
604: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
605: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
606: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
607: hr_utility.set_location('l_work_schedule is ' || l_work_schedule ,3);
608: hr_utility.set_location('l_emp_type is ' || l_emp_type ,3);
609: hr_utility.set_location('l_tenure is ' || l_tenure ,3);

Line 606: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);

602: hr_utility.set_location('l_susp_flag is ' || l_susp_flag ,2);
603: hr_utility.set_location('l_assignment_id is ' || l_assignment_id ,3);
604: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
605: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
606: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
607: hr_utility.set_location('l_work_schedule is ' || l_work_schedule ,3);
608: hr_utility.set_location('l_emp_type is ' || l_emp_type ,3);
609: hr_utility.set_location('l_tenure is ' || l_tenure ,3);
610: hr_utility.set_location('l_position_code is ' || l_position_code ,3);

Line 607: hr_utility.set_location('l_work_schedule is ' || l_work_schedule ,3);

603: hr_utility.set_location('l_assignment_id is ' || l_assignment_id ,3);
604: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
605: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
606: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
607: hr_utility.set_location('l_work_schedule is ' || l_work_schedule ,3);
608: hr_utility.set_location('l_emp_type is ' || l_emp_type ,3);
609: hr_utility.set_location('l_tenure is ' || l_tenure ,3);
610: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
611: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);

Line 608: hr_utility.set_location('l_emp_type is ' || l_emp_type ,3);

604: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
605: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
606: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
607: hr_utility.set_location('l_work_schedule is ' || l_work_schedule ,3);
608: hr_utility.set_location('l_emp_type is ' || l_emp_type ,3);
609: hr_utility.set_location('l_tenure is ' || l_tenure ,3);
610: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
611: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
612: hr_utility.set_location('l_cur_appt1 is ' || l_cur_appt1 ,3);

Line 609: hr_utility.set_location('l_tenure is ' || l_tenure ,3);

605: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
606: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
607: hr_utility.set_location('l_work_schedule is ' || l_work_schedule ,3);
608: hr_utility.set_location('l_emp_type is ' || l_emp_type ,3);
609: hr_utility.set_location('l_tenure is ' || l_tenure ,3);
610: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
611: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
612: hr_utility.set_location('l_cur_appt1 is ' || l_cur_appt1 ,3);
613: hr_utility.set_location('l_cur_appt2 is ' || l_cur_appt2 ,3);

Line 610: hr_utility.set_location('l_position_code is ' || l_position_code ,3);

606: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
607: hr_utility.set_location('l_work_schedule is ' || l_work_schedule ,3);
608: hr_utility.set_location('l_emp_type is ' || l_emp_type ,3);
609: hr_utility.set_location('l_tenure is ' || l_tenure ,3);
610: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
611: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
612: hr_utility.set_location('l_cur_appt1 is ' || l_cur_appt1 ,3);
613: hr_utility.set_location('l_cur_appt2 is ' || l_cur_appt2 ,3);
614:

Line 611: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);

607: hr_utility.set_location('l_work_schedule is ' || l_work_schedule ,3);
608: hr_utility.set_location('l_emp_type is ' || l_emp_type ,3);
609: hr_utility.set_location('l_tenure is ' || l_tenure ,3);
610: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
611: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
612: hr_utility.set_location('l_cur_appt1 is ' || l_cur_appt1 ,3);
613: hr_utility.set_location('l_cur_appt2 is ' || l_cur_appt2 ,3);
614:
615: -- For line 3, Need to take Work schedule irrespective of Employment type(except Intermittent)

Line 612: hr_utility.set_location('l_cur_appt1 is ' || l_cur_appt1 ,3);

608: hr_utility.set_location('l_emp_type is ' || l_emp_type ,3);
609: hr_utility.set_location('l_tenure is ' || l_tenure ,3);
610: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
611: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
612: hr_utility.set_location('l_cur_appt1 is ' || l_cur_appt1 ,3);
613: hr_utility.set_location('l_cur_appt2 is ' || l_cur_appt2 ,3);
614:
615: -- For line 3, Need to take Work schedule irrespective of Employment type(except Intermittent)
616: -- IF l_emp_type in ('1','H') and l_work_schedule ='F' THEN

Line 613: hr_utility.set_location('l_cur_appt2 is ' || l_cur_appt2 ,3);

609: hr_utility.set_location('l_tenure is ' || l_tenure ,3);
610: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
611: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
612: hr_utility.set_location('l_cur_appt1 is ' || l_cur_appt1 ,3);
613: hr_utility.set_location('l_cur_appt2 is ' || l_cur_appt2 ,3);
614:
615: -- For line 3, Need to take Work schedule irrespective of Employment type(except Intermittent)
616: -- IF l_emp_type in ('1','H') and l_work_schedule ='F' THEN
617: -- Sundar 3166530 Commented the above stmt. Replaced it with the one below.

Line 985: hr_utility.set_location('Leaving ' || l_susp_flag ,1);

981: END IF;
982: END IF; --IF l_pay_basis NOT IN ('PD','WC') Bug# 8928564
983: END LOOP;
984: CLOSE sf113_section1;
985: hr_utility.set_location('Leaving ' || l_susp_flag ,1);
986:
987: EXCEPTION -- NOCOPY changes
988: WHEN OTHERS THEN
989: p_l1a := l_l1a ;

Line 1664: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);

1660: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
1661: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
1662: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
1663:
1664: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
1665: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);
1666: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);
1667: -- NOAs 430,452, 473 doesnt have NTE dates. hence they're considered as separations
1668: -- when counting for line 25 without any 30 days check.

Line 1665: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);

1661: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
1662: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
1663:
1664: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
1665: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);
1666: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);
1667: -- NOAs 430,452, 473 doesnt have NTE dates. hence they're considered as separations
1668: -- when counting for line 25 without any 30 days check.
1669: IF l_code IN ('430','452','473') THEN

Line 1666: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);

1662: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
1663:
1664: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
1665: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);
1666: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);
1667: -- NOAs 430,452, 473 doesnt have NTE dates. hence they're considered as separations
1668: -- when counting for line 25 without any 30 days check.
1669: IF l_code IN ('430','452','473') THEN
1670: l_susp_flag := 'Y';

Line 1709: hr_utility.set_location('l_person_id is ' || l_person_id ,3);

1705: p_rpt_date,l_people_hist_data);
1706:
1707: l_citizenship := l_people_hist_data.pei_information3;
1708:
1709: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1710: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1711: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1712: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1713: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);

Line 1710: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);

1706:
1707: l_citizenship := l_people_hist_data.pei_information3;
1708:
1709: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1710: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1711: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1712: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1713: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
1714:

Line 1711: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);

1707: l_citizenship := l_people_hist_data.pei_information3;
1708:
1709: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1710: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1711: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1712: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1713: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
1714:
1715: IF l_effective_date <> p_empl_as_of_date THEN

Line 1712: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);

1708:
1709: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1710: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1711: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1712: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1713: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
1714:
1715: IF l_effective_date <> p_empl_as_of_date THEN
1716: -- Line 25 - 27

Line 1713: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);

1709: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1710: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1711: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1712: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1713: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
1714:
1715: IF l_effective_date <> p_empl_as_of_date THEN
1716: -- Line 25 - 27
1717:

Line 1833: hr_utility.set_location('l_person_id is ' || l_person_id ,3);

1829: GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP2',p_rpt_date,
1830: l_pos_hist_data );
1831: l_position_code := l_pos_hist_data.poei_information3;
1832:
1833: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1834: hr_utility.set_location('l_code is ' || l_code ,3);
1835: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
1836: hr_utility.set_location('l_position_id is ' || l_position_id ,3);
1837: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);

Line 1834: hr_utility.set_location('l_code is ' || l_code ,3);

1830: l_pos_hist_data );
1831: l_position_code := l_pos_hist_data.poei_information3;
1832:
1833: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1834: hr_utility.set_location('l_code is ' || l_code ,3);
1835: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
1836: hr_utility.set_location('l_position_id is ' || l_position_id ,3);
1837: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1838: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);

Line 1835: hr_utility.set_location('l_position_code is ' || l_position_code ,3);

1831: l_position_code := l_pos_hist_data.poei_information3;
1832:
1833: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1834: hr_utility.set_location('l_code is ' || l_code ,3);
1835: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
1836: hr_utility.set_location('l_position_id is ' || l_position_id ,3);
1837: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1838: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1839: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);

Line 1836: hr_utility.set_location('l_position_id is ' || l_position_id ,3);

1832:
1833: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1834: hr_utility.set_location('l_code is ' || l_code ,3);
1835: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
1836: hr_utility.set_location('l_position_id is ' || l_position_id ,3);
1837: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1838: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1839: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1840: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);

Line 1837: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);

1833: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1834: hr_utility.set_location('l_code is ' || l_code ,3);
1835: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
1836: hr_utility.set_location('l_position_id is ' || l_position_id ,3);
1837: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1838: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1839: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1840: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
1841:

Line 1838: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);

1834: hr_utility.set_location('l_code is ' || l_code ,3);
1835: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
1836: hr_utility.set_location('l_position_id is ' || l_position_id ,3);
1837: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1838: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1839: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1840: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
1841:
1842: IF l_code in ('100', '101', '107', '108', '112', '115',

Line 1839: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);

1835: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
1836: hr_utility.set_location('l_position_id is ' || l_position_id ,3);
1837: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1838: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1839: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1840: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
1841:
1842: IF l_code in ('100', '101', '107', '108', '112', '115',
1843: '117', '120', '122', '124', '130', '132',

Line 1840: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);

1836: hr_utility.set_location('l_position_id is ' || l_position_id ,3);
1837: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1838: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1839: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1840: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
1841:
1842: IF l_code in ('100', '101', '107', '108', '112', '115',
1843: '117', '120', '122', '124', '130', '132',
1844: '140', '141', '142', '143', '145', '146',

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

2115: l_proc varchar2(72) := g_package||'ghr_sf113a_main';
2116: --
2117: BEGIN
2118: --
2119: hr_utility.set_location('Entering: '||l_proc,10);
2120: l_rpt_date := fnd_date.canonical_to_date(p_rpt_date);
2121: l_pay_to := fnd_date.canonical_to_date(p_pay_to);
2122: l_pay_from := fnd_date.canonical_to_date(p_pay_from);
2123: l_emp_as_of_date := fnd_date.canonical_to_date(p_employment_as_of_date);

Line 2132: hr_utility.set_location('Set Agency and SubElement Name. '||l_proc,20);

2128: ghr_sf113_payroll(p_pay_from => l_pay_from,
2129: p_pay_to => l_pay_to);
2130: --
2131: --Get Agency, SubElement Name
2132: hr_utility.set_location('Set Agency and SubElement Name. '||l_proc,20);
2133: l_segment := get_org_info(p_business_id);
2134: l_agency_name := hr_general.decode_lookup('GHR_US_AGENCY_CODE_2',p_agency_code);
2135: l_subelem := hr_general.decode_lookup('GHR_US_AGENCY_CODE'
2136: ,p_agency_code||p_agency_subelement);

Line 2139: hr_utility.set_location('Calling Procedure to Populate SectionI. '||l_proc,30);

2135: l_subelem := hr_general.decode_lookup('GHR_US_AGENCY_CODE'
2136: ,p_agency_code||p_agency_subelement);
2137: --
2138: --Populate Section I
2139: hr_utility.set_location('Calling Procedure to Populate SectionI. '||l_proc,30);
2140: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate SectionI');
2141: sf113a_sec1 (l_rpt_date, l_emp_as_of_date, l_agency_code, l_segment,
2142: l_l1a, l_l1b, l_l1c, l_l1d, l_l1e,
2143: l_l2a, l_l2b, l_l2c, l_l2d, l_l2e,

Line 2162: hr_utility.set_location('Calling Procedure to Populate SectionII. '||l_proc,40);

2158: l_l29a, l_l29b, l_l29c, l_l29d, l_l29e,
2159: l_l30a, l_l30b, l_l30c, l_l30d, l_l30e);
2160: --
2161: --Populate Section II
2162: hr_utility.set_location('Calling Procedure to Populate SectionII. '||l_proc,40);
2163: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate SectionII');
2164: sf113a_sec2 (l_agency_code, l_rpt_date, l_emp_as_of_date,
2165: l_pay_from, l_pay_to, l_segment,
2166: l_l17a ,l_l17b ,l_l17c ,l_l17d, l_l17e,

Line 2171: hr_utility.set_location('Calling Procedure to Populate SectionIII. '||l_proc,50);

2167: l_l18a ,l_l18b ,l_l18c ,l_l18d, l_l18e,
2168: l_l31a ,l_l31b ,l_l31c ,l_l31d, l_l31e);
2169: --
2170: --Populate Section III
2171: hr_utility.set_location('Calling Procedure to Populate SectionIII. '||l_proc,50);
2172: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate SectionIII');
2173: sf113a_sec3 (l_agency_code, l_rpt_date, l_emp_as_of_date, l_last_rpt_date,
2174: l_pay_from, l_pay_to, l_segment,
2175: l_l19a, l_l19b ,l_l19c ,l_l19d, l_l19e,

Line 2187: hr_utility.set_location('Calling Procedure to replace zeroes with null. '||l_proc,60);

2183: l_l27a ,l_l27b ,l_l27c ,l_l27d, l_l27e,
2184: l_l28a ,l_l28b ,l_l28c ,l_l28d, l_l28e);
2185: --
2186: --Replace Zeroes with Null
2187: hr_utility.set_location('Calling Procedure to replace zeroes with null. '||l_proc,60);
2188: fnd_file.put_line(fnd_file.log,'Calling Procedure to replace zeroes with null');
2189: repl_zero(l_l1a, l_l1b, l_l1c, l_l1d, l_l1e,
2190: l_l2a, l_l2b, l_l2c, l_l2d, l_l2e,
2191: l_l3a, l_l3b, l_l3c, l_l3d, l_l3e,

Line 2221: hr_utility.set_location('Started generating XML in Concurrent Request Output. '||l_proc,70);

2217: l_l29a, l_l29b, l_l29c, l_l29d, l_l29e,
2218: l_l30a, l_l30b, l_l30c, l_l30d, l_l30e,
2219: l_l31a, l_l31b, l_l31c, l_l31d, l_l31e);
2220: --
2221: hr_utility.set_location('Started generating XML in Concurrent Request Output. '||l_proc,70);
2222: fnd_file.put_line(fnd_file.log,'Started generating XML in Concurrent Request Output');
2223: --
2224: --Start adding XML in CP Output
2225: fnd_file.put_line(fnd_file.output,'');

Line 2501: hr_utility.set_location('Finished generating XML in Concurrent Request Output. '||l_proc,80);

2497: fnd_file.put_line(fnd_file.output,' ');
2498: fnd_file.put_line(fnd_file.output,'');
2499: --End adding XML in CP Output
2500: --
2501: hr_utility.set_location('Finished generating XML in Concurrent Request Output. '||l_proc,80);
2502: fnd_file.put_line(fnd_file.log,'Finished generating XML in Concurrent Request Output');
2503: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
2504: --
2505: hr_utility.set_location('Leaving: '||l_proc,10);

Line 2505: hr_utility.set_location('Leaving: '||l_proc,10);

2501: hr_utility.set_location('Finished generating XML in Concurrent Request Output. '||l_proc,80);
2502: fnd_file.put_line(fnd_file.log,'Finished generating XML in Concurrent Request Output');
2503: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
2504: --
2505: hr_utility.set_location('Leaving: '||l_proc,10);
2506: --
2507: EXCEPTION
2508: WHEN others THEN
2509: retcode := 2;

Line 2510: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

2506: --
2507: EXCEPTION
2508: WHEN others THEN
2509: retcode := 2;
2510: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2511: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2512: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2513: hr_utility.set_location('Error Leaving: '||l_proc,90);
2514: raise;

Line 2511: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

2507: EXCEPTION
2508: WHEN others THEN
2509: retcode := 2;
2510: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2511: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2512: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2513: hr_utility.set_location('Error Leaving: '||l_proc,90);
2514: raise;
2515: END ghr_sf113a_out;

Line 2512: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2508: WHEN others THEN
2509: retcode := 2;
2510: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2511: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2512: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2513: hr_utility.set_location('Error Leaving: '||l_proc,90);
2514: raise;
2515: END ghr_sf113a_out;
2516: --

Line 2513: hr_utility.set_location('Error Leaving: '||l_proc,90);

2509: retcode := 2;
2510: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2511: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2512: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2513: hr_utility.set_location('Error Leaving: '||l_proc,90);
2514: raise;
2515: END ghr_sf113a_out;
2516: --
2517: --This procedure replaces all Zeroes to NULL.