[Home] [Help]
865: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then
866: G_VALIDATION_FAILURE := true;
867: end if;
868: hr_utility.set_message(800,'HR_GB_78129_TERM_ASG_FOUND_SOY');
869: hr_utility.set_message_token('AGG_START_DATE', fnd_date.date_to_displaydate(l_effective_date));
870: hr_utility.raise_error;
871:
872: end if;
873: close cur_term_asg_dtls;
889: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then
890: G_VALIDATION_FAILURE := true;
891: end if;
892: hr_utility.set_message(800,'HR_GB_78129_TERM_ASG_FOUND_SOY');
893: hr_utility.set_message_token('AGG_START_DATE', fnd_date.date_to_displaydate(l_cur_effective_start_date));
894: hr_utility.raise_error;
895: --hr_utility.raise_error;
896: end if;
897: close cur_term_asg_dtls;
1521: END IF;
1522:
1523: hr_utility.trace ('date after soy check:'
1524: || l_date_soy);
1525: RETURN fnd_date.date_to_displaydate (l_date_soy);
1526: END get_soy_date;
1527:
1528: PROCEDURE get_extra_info_exists
1529: (p_assignment_id IN per_all_assignments_f.assignment_id%type
1893:
1894: hr_utility.trace ('assignment_id:'
1895: || c_person_info.assignment_id);
1896:
1897: p_effect_date := get_soy_date (fnd_date.date_to_displaydate (p_effective_date));
1898:
1899: hr_utility.trace ('p_effect_date:'
1900: || p_effect_date);
1901:
1912: ,p_business_group_id => c_person_info.business_group_id
1913: ,p_information_type => 'GB_RTI_AGGREGATION'
1914: ,p_aei_information_category => 'GB_RTI_AGGREGATION'
1915: ,p_aei_information1 => l_ni_reporting_flag
1916: ,p_aei_information2 => fnd_date.date_to_canonical (p_effect_date)
1917: ,p_aei_information3 => REGEXP_REPLACE(l_rti_payroll_id,'[]\#^}{_.@\[\$]','') --added for bug 16315781
1918: ,p_aei_information4 => l_payroll_id
1919: ,p_object_version_number => p_object_version_number
1920: ,p_assignment_extra_info_id => p_assignment_extra_info_id);
1924: ,p_business_group_id => c_person_info.business_group_id
1925: ,p_object_version_number => p_object_version_number
1926: ,p_aei_information_category => 'GB_RTI_AGGREGATION'
1927: ,p_aei_information1 => l_ni_reporting_flag
1928: ,p_aei_information2 => fnd_date.date_to_canonical (p_effect_date)
1929: ,p_aei_information3 => REGEXP_REPLACE(l_rti_payroll_id,'[]\#^}{_.@\[\$]','') --added for bug 16315781
1930: ,p_aei_information4 => l_payroll_id);
1931: END IF;
1932: END LOOP;
1943: ,p_assignment_extra_info_id
1944: ,p_object_version_number);
1945: hr_utility.trace ('p_assignment_extra_info_id:'
1946: || p_assignment_extra_info_id);
1947: p_effect_date := get_soy_date (fnd_date.date_to_displaydate (p_effective_date));
1948: hr_utility.trace ('p_effect_date:'
1949: || p_effect_date);
1950:
1951: IF p_assignment_extra_info_id = - 1 THEN
1954: ,p_business_group_id => l_bus_group
1955: ,p_information_type => 'GB_RTI_AGGREGATION'
1956: ,p_aei_information_category => 'GB_RTI_AGGREGATION'
1957: ,p_aei_information1 => l_ni_flag
1958: ,p_aei_information2 => fnd_date.date_to_canonical (p_effect_date)
1959: ,p_aei_information3 => REGEXP_REPLACE(l_rti_payroll_id,'[]\#^}{_.@\[\$]','')
1960: ,p_aei_information4 => l_payroll_id
1961: ,p_object_version_number => p_object_version_number
1962: ,p_assignment_extra_info_id => p_assignment_extra_info_id);
1966: ,p_business_group_id => l_bus_group
1967: ,p_object_version_number => p_object_version_number
1968: ,p_aei_information_category => 'GB_RTI_AGGREGATION'
1969: ,p_aei_information1 => l_ni_flag
1970: ,p_aei_information2 => fnd_date.date_to_canonical (p_effect_date)
1971: ,p_aei_information3 => REGEXP_REPLACE(l_rti_payroll_id,'[]\#^}{_.@\[\$]','')
1972: ,p_aei_information4 => l_payroll_id);
1973: END IF;
1974: