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 566: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);

562: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);
563: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
564: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
565: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
566: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
567: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);
568: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);
569: IF (nvl(l_lwop_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) or
570: (nvl(l_susp_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) or

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

563: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
564: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
565: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
566: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
567: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);
568: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);
569: IF (nvl(l_lwop_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) or
570: (nvl(l_susp_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) or
571: (nvl(l_furlough_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) then

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

564: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
565: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
566: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
567: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);
568: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);
569: IF (nvl(l_lwop_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) or
570: (nvl(l_susp_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) or
571: (nvl(l_furlough_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) then
572: l_susp_flag := 'Y';

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

589:
590: GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP2',p_rpt_date,
591: l_pos_hist_data );
592: l_position_code := l_pos_hist_data.poei_information3;
593: hr_utility.set_location('l_susp_flag is ' || l_susp_flag ,2);
594: hr_utility.set_location('l_assignment_id is ' || l_assignment_id ,3);
595: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
596: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
597: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);

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

590: GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP2',p_rpt_date,
591: l_pos_hist_data );
592: l_position_code := l_pos_hist_data.poei_information3;
593: hr_utility.set_location('l_susp_flag is ' || l_susp_flag ,2);
594: hr_utility.set_location('l_assignment_id is ' || l_assignment_id ,3);
595: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
596: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
597: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
598: hr_utility.set_location('l_work_schedule is ' || l_work_schedule ,3);

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

591: l_pos_hist_data );
592: l_position_code := l_pos_hist_data.poei_information3;
593: hr_utility.set_location('l_susp_flag is ' || l_susp_flag ,2);
594: hr_utility.set_location('l_assignment_id is ' || l_assignment_id ,3);
595: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
596: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
597: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
598: hr_utility.set_location('l_work_schedule is ' || l_work_schedule ,3);
599: hr_utility.set_location('l_emp_type is ' || l_emp_type ,3);

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

592: l_position_code := l_pos_hist_data.poei_information3;
593: hr_utility.set_location('l_susp_flag is ' || l_susp_flag ,2);
594: hr_utility.set_location('l_assignment_id is ' || l_assignment_id ,3);
595: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
596: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
597: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
598: hr_utility.set_location('l_work_schedule is ' || l_work_schedule ,3);
599: hr_utility.set_location('l_emp_type is ' || l_emp_type ,3);
600: hr_utility.set_location('l_tenure is ' || l_tenure ,3);

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

593: hr_utility.set_location('l_susp_flag is ' || l_susp_flag ,2);
594: hr_utility.set_location('l_assignment_id is ' || l_assignment_id ,3);
595: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
596: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
597: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
598: hr_utility.set_location('l_work_schedule is ' || l_work_schedule ,3);
599: hr_utility.set_location('l_emp_type is ' || l_emp_type ,3);
600: hr_utility.set_location('l_tenure is ' || l_tenure ,3);
601: hr_utility.set_location('l_position_code is ' || l_position_code ,3);

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

594: hr_utility.set_location('l_assignment_id is ' || l_assignment_id ,3);
595: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
596: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
597: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
598: hr_utility.set_location('l_work_schedule is ' || l_work_schedule ,3);
599: hr_utility.set_location('l_emp_type is ' || l_emp_type ,3);
600: hr_utility.set_location('l_tenure is ' || l_tenure ,3);
601: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
602: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);

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

595: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
596: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
597: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
598: hr_utility.set_location('l_work_schedule is ' || l_work_schedule ,3);
599: hr_utility.set_location('l_emp_type is ' || l_emp_type ,3);
600: hr_utility.set_location('l_tenure is ' || l_tenure ,3);
601: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
602: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
603: hr_utility.set_location('l_cur_appt1 is ' || l_cur_appt1 ,3);

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

596: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
597: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
598: hr_utility.set_location('l_work_schedule is ' || l_work_schedule ,3);
599: hr_utility.set_location('l_emp_type is ' || l_emp_type ,3);
600: hr_utility.set_location('l_tenure is ' || l_tenure ,3);
601: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
602: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
603: hr_utility.set_location('l_cur_appt1 is ' || l_cur_appt1 ,3);
604: hr_utility.set_location('l_cur_appt2 is ' || l_cur_appt2 ,3);

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

597: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
598: hr_utility.set_location('l_work_schedule is ' || l_work_schedule ,3);
599: hr_utility.set_location('l_emp_type is ' || l_emp_type ,3);
600: hr_utility.set_location('l_tenure is ' || l_tenure ,3);
601: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
602: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
603: hr_utility.set_location('l_cur_appt1 is ' || l_cur_appt1 ,3);
604: hr_utility.set_location('l_cur_appt2 is ' || l_cur_appt2 ,3);
605:

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

598: hr_utility.set_location('l_work_schedule is ' || l_work_schedule ,3);
599: hr_utility.set_location('l_emp_type is ' || l_emp_type ,3);
600: hr_utility.set_location('l_tenure is ' || l_tenure ,3);
601: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
602: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
603: hr_utility.set_location('l_cur_appt1 is ' || l_cur_appt1 ,3);
604: hr_utility.set_location('l_cur_appt2 is ' || l_cur_appt2 ,3);
605:
606: -- For line 3, Need to take Work schedule irrespective of Employment type(except Intermittent)

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

599: hr_utility.set_location('l_emp_type is ' || l_emp_type ,3);
600: hr_utility.set_location('l_tenure is ' || l_tenure ,3);
601: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
602: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
603: hr_utility.set_location('l_cur_appt1 is ' || l_cur_appt1 ,3);
604: hr_utility.set_location('l_cur_appt2 is ' || l_cur_appt2 ,3);
605:
606: -- For line 3, Need to take Work schedule irrespective of Employment type(except Intermittent)
607: -- IF l_emp_type in ('1','H') and l_work_schedule ='F' THEN

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

600: hr_utility.set_location('l_tenure is ' || l_tenure ,3);
601: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
602: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
603: hr_utility.set_location('l_cur_appt1 is ' || l_cur_appt1 ,3);
604: hr_utility.set_location('l_cur_appt2 is ' || l_cur_appt2 ,3);
605:
606: -- For line 3, Need to take Work schedule irrespective of Employment type(except Intermittent)
607: -- IF l_emp_type in ('1','H') and l_work_schedule ='F' THEN
608: -- Sundar 3166530 Commented the above stmt. Replaced it with the one below.

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

971: END IF;
972: END IF;
973: END LOOP;
974: CLOSE sf113_section1;
975: hr_utility.set_location('Leaving ' || l_susp_flag ,1);
976:
977: EXCEPTION -- NOCOPY changes
978: WHEN OTHERS THEN
979: p_l1a := l_l1a ;

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

1640: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
1641: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
1642: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
1643:
1644: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
1645: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);
1646: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);
1647: -- NOAs 430,452, 473 doesnt have NTE dates. hence they're considered as separations
1648: -- when counting for line 25 without any 30 days check.

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

1641: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
1642: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
1643:
1644: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
1645: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);
1646: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);
1647: -- NOAs 430,452, 473 doesnt have NTE dates. hence they're considered as separations
1648: -- when counting for line 25 without any 30 days check.
1649: IF l_code IN ('430','452','473') THEN

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

1642: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
1643:
1644: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
1645: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);
1646: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);
1647: -- NOAs 430,452, 473 doesnt have NTE dates. hence they're considered as separations
1648: -- when counting for line 25 without any 30 days check.
1649: IF l_code IN ('430','452','473') THEN
1650: l_susp_flag := 'Y';

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

1685: p_rpt_date,l_people_hist_data);
1686:
1687: l_citizenship := l_people_hist_data.pei_information3;
1688:
1689: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1690: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1691: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1692: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1693: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);

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

1686:
1687: l_citizenship := l_people_hist_data.pei_information3;
1688:
1689: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1690: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1691: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1692: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1693: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
1694:

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

1687: l_citizenship := l_people_hist_data.pei_information3;
1688:
1689: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1690: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1691: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1692: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1693: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
1694:
1695: IF l_effective_date <> p_empl_as_of_date THEN

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

1688:
1689: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1690: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1691: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1692: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1693: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
1694:
1695: IF l_effective_date <> p_empl_as_of_date THEN
1696: -- Line 25 - 27

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

1689: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1690: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1691: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1692: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1693: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
1694:
1695: IF l_effective_date <> p_empl_as_of_date THEN
1696: -- Line 25 - 27
1697:

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

1798: GHR_HISTORY_FETCH.fetch_positionei(l_position_id,'GHR_US_POS_GRP2',p_rpt_date,
1799: l_pos_hist_data );
1800: l_position_code := l_pos_hist_data.poei_information3;
1801:
1802: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1803: hr_utility.set_location('l_code is ' || l_code ,3);
1804: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
1805: hr_utility.set_location('l_position_id is ' || l_position_id ,3);
1806: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);

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

1799: l_pos_hist_data );
1800: l_position_code := l_pos_hist_data.poei_information3;
1801:
1802: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1803: hr_utility.set_location('l_code is ' || l_code ,3);
1804: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
1805: hr_utility.set_location('l_position_id is ' || l_position_id ,3);
1806: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1807: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);

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

1800: l_position_code := l_pos_hist_data.poei_information3;
1801:
1802: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1803: hr_utility.set_location('l_code is ' || l_code ,3);
1804: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
1805: hr_utility.set_location('l_position_id is ' || l_position_id ,3);
1806: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1807: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1808: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);

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

1801:
1802: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1803: hr_utility.set_location('l_code is ' || l_code ,3);
1804: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
1805: hr_utility.set_location('l_position_id is ' || l_position_id ,3);
1806: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1807: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1808: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1809: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);

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

1802: hr_utility.set_location('l_person_id is ' || l_person_id ,3);
1803: hr_utility.set_location('l_code is ' || l_code ,3);
1804: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
1805: hr_utility.set_location('l_position_id is ' || l_position_id ,3);
1806: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1807: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1808: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1809: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
1810:

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

1803: hr_utility.set_location('l_code is ' || l_code ,3);
1804: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
1805: hr_utility.set_location('l_position_id is ' || l_position_id ,3);
1806: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1807: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1808: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1809: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
1810:
1811: IF l_code in ('100', '101', '107', '108', '112', '115',

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

1804: hr_utility.set_location('l_position_code is ' || l_position_code ,3);
1805: hr_utility.set_location('l_position_id is ' || l_position_id ,3);
1806: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1807: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1808: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1809: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
1810:
1811: IF l_code in ('100', '101', '107', '108', '112', '115',
1812: '117', '120', '122', '124', '130', '132',

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

1805: hr_utility.set_location('l_position_id is ' || l_position_id ,3);
1806: hr_utility.set_location('l_citizenship is ' || l_citizenship ,3);
1807: hr_utility.set_location('l_duty_station is ' || l_duty_station ,3);
1808: hr_utility.set_location('l_duty_station_code is ' || l_duty_station_code ,3);
1809: hr_utility.set_location('l_msa_code is ' || l_msa_code ,3);
1810:
1811: IF l_code in ('100', '101', '107', '108', '112', '115',
1812: '117', '120', '122', '124', '130', '132',
1813: '140', '141', '142', '143', '145', '146',

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

2083: l_proc varchar2(72) := g_package||'ghr_sf113a_main';
2084: --
2085: BEGIN
2086: --
2087: hr_utility.set_location('Entering: '||l_proc,10);
2088: l_rpt_date := fnd_date.canonical_to_date(p_rpt_date);
2089: l_pay_to := fnd_date.canonical_to_date(p_pay_to);
2090: l_pay_from := fnd_date.canonical_to_date(p_pay_from);
2091: l_emp_as_of_date := fnd_date.canonical_to_date(p_employment_as_of_date);

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

2096: ghr_sf113_payroll(p_pay_from => l_pay_from,
2097: p_pay_to => l_pay_to);
2098: --
2099: --Get Agency, SubElement Name
2100: hr_utility.set_location('Set Agency and SubElement Name. '||l_proc,20);
2101: l_segment := get_org_info(p_business_id);
2102: l_agency_name := hr_general.decode_lookup('GHR_US_AGENCY_CODE_2',p_agency_code);
2103: l_subelem := hr_general.decode_lookup('GHR_US_AGENCY_CODE'
2104: ,p_agency_code||p_agency_subelement);

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

2103: l_subelem := hr_general.decode_lookup('GHR_US_AGENCY_CODE'
2104: ,p_agency_code||p_agency_subelement);
2105: --
2106: --Populate Section I
2107: hr_utility.set_location('Calling Procedure to Populate SectionI. '||l_proc,30);
2108: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate SectionI');
2109: sf113a_sec1 (l_rpt_date, l_emp_as_of_date, l_agency_code, l_segment,
2110: l_l1a, l_l1b, l_l1c, l_l1d, l_l1e,
2111: l_l2a, l_l2b, l_l2c, l_l2d, l_l2e,

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

2126: l_l29a, l_l29b, l_l29c, l_l29d, l_l29e,
2127: l_l30a, l_l30b, l_l30c, l_l30d, l_l30e);
2128: --
2129: --Populate Section II
2130: hr_utility.set_location('Calling Procedure to Populate SectionII. '||l_proc,40);
2131: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate SectionII');
2132: sf113a_sec2 (l_agency_code, l_rpt_date, l_emp_as_of_date,
2133: l_pay_from, l_pay_to, l_segment,
2134: l_l17a ,l_l17b ,l_l17c ,l_l17d, l_l17e,

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

2135: l_l18a ,l_l18b ,l_l18c ,l_l18d, l_l18e,
2136: l_l31a ,l_l31b ,l_l31c ,l_l31d, l_l31e);
2137: --
2138: --Populate Section III
2139: hr_utility.set_location('Calling Procedure to Populate SectionIII. '||l_proc,50);
2140: fnd_file.put_line(fnd_file.log,'Calling Procedure to Populate SectionIII');
2141: sf113a_sec3 (l_agency_code, l_rpt_date, l_emp_as_of_date, l_last_rpt_date,
2142: l_pay_from, l_pay_to, l_segment,
2143: l_l19a, l_l19b ,l_l19c ,l_l19d, l_l19e,

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

2151: l_l27a ,l_l27b ,l_l27c ,l_l27d, l_l27e,
2152: l_l28a ,l_l28b ,l_l28c ,l_l28d, l_l28e);
2153: --
2154: --Replace Zeroes with Null
2155: hr_utility.set_location('Calling Procedure to replace zeroes with null. '||l_proc,60);
2156: fnd_file.put_line(fnd_file.log,'Calling Procedure to replace zeroes with null');
2157: repl_zero(l_l1a, l_l1b, l_l1c, l_l1d, l_l1e,
2158: l_l2a, l_l2b, l_l2c, l_l2d, l_l2e,
2159: l_l3a, l_l3b, l_l3c, l_l3d, l_l3e,

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

2185: l_l29a, l_l29b, l_l29c, l_l29d, l_l29e,
2186: l_l30a, l_l30b, l_l30c, l_l30d, l_l30e,
2187: l_l31a, l_l31b, l_l31c, l_l31d, l_l31e);
2188: --
2189: hr_utility.set_location('Started generating XML in Concurrent Request Output. '||l_proc,70);
2190: fnd_file.put_line(fnd_file.log,'Started generating XML in Concurrent Request Output');
2191: --
2192: --Start adding XML in CP Output
2193: fnd_file.put_line(fnd_file.output,'');

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

2465: fnd_file.put_line(fnd_file.output,' ');
2466: fnd_file.put_line(fnd_file.output,'');
2467: --End adding XML in CP Output
2468: --
2469: hr_utility.set_location('Finished generating XML in Concurrent Request Output. '||l_proc,80);
2470: fnd_file.put_line(fnd_file.log,'Finished generating XML in Concurrent Request Output');
2471: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
2472: --
2473: hr_utility.set_location('Leaving: '||l_proc,10);

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

2469: hr_utility.set_location('Finished generating XML in Concurrent Request Output. '||l_proc,80);
2470: fnd_file.put_line(fnd_file.log,'Finished generating XML in Concurrent Request Output');
2471: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
2472: --
2473: hr_utility.set_location('Leaving: '||l_proc,10);
2474: --
2475: EXCEPTION
2476: WHEN others THEN
2477: retcode := 2;

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

2474: --
2475: EXCEPTION
2476: WHEN others THEN
2477: retcode := 2;
2478: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2479: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2480: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2481: hr_utility.set_location('Error Leaving: '||l_proc,90);
2482: raise;

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

2475: EXCEPTION
2476: WHEN others THEN
2477: retcode := 2;
2478: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2479: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2480: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2481: hr_utility.set_location('Error Leaving: '||l_proc,90);
2482: raise;
2483: END ghr_sf113a_out;

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

2476: WHEN others THEN
2477: retcode := 2;
2478: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2479: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2480: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2481: hr_utility.set_location('Error Leaving: '||l_proc,90);
2482: raise;
2483: END ghr_sf113a_out;
2484: --

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

2477: retcode := 2;
2478: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2479: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2480: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2481: hr_utility.set_location('Error Leaving: '||l_proc,90);
2482: raise;
2483: END ghr_sf113a_out;
2484: --
2485: --This procedure replaces all Zeroes to NULL.