2023: --
2024: -- start of fix for Bug #2586522
2025: --
2026: if p_rec.org_information_context = 'FR_ESTAB_INFO' then
2027: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information2);
2028: elsif p_rec.org_information_context = 'FR_ESTAB_PREV_INFO' then
2029: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information1);
2030: end if;
2031:
2025: --
2026: if p_rec.org_information_context = 'FR_ESTAB_INFO' then
2027: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information2);
2028: elsif p_rec.org_information_context = 'FR_ESTAB_PREV_INFO' then
2029: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information1);
2030: end if;
2031:
2032: if p_rec.org_information_context = 'FR_COMP_INFO' then
2033: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2029: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information1);
2030: end if;
2031:
2032: if p_rec.org_information_context = 'FR_COMP_INFO' then
2033: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2034: elsif p_rec.org_information_context = 'FR_COMP_PREV_INFO' then
2035: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2036: end if;
2037:
2031:
2032: if p_rec.org_information_context = 'FR_COMP_INFO' then
2033: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2034: elsif p_rec.org_information_context = 'FR_COMP_PREV_INFO' then
2035: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2036: end if;
2037:
2038: HR_ORG_INFORMATION_PKG.validate_business_group_name
2039: (p_organization_id => p_rec.Organization_Id
2034: elsif p_rec.org_information_context = 'FR_COMP_PREV_INFO' then
2035: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2036: end if;
2037:
2038: HR_ORG_INFORMATION_PKG.validate_business_group_name
2039: (p_organization_id => p_rec.Organization_Id
2040: ,p_org_information_context => p_rec.Org_Information_Context
2041: ,p_org_information1 => p_rec.Org_Information1
2042: ,p_org_information2 => p_rec.Org_Information2
2170: X_Org_information8 => p_rec.org_information8);
2171: END IF;
2172:
2173: if p_rec.org_information_context = 'FR_ESTAB_INFO' then
2174: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information2);
2175: elsif p_rec.org_information_context = 'FR_ESTAB_PREV_INFO' then
2176: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information1);
2177: end if;
2178:
2172:
2173: if p_rec.org_information_context = 'FR_ESTAB_INFO' then
2174: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information2);
2175: elsif p_rec.org_information_context = 'FR_ESTAB_PREV_INFO' then
2176: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information1);
2177: end if;
2178:
2179: if p_rec.org_information_context = 'FR_COMP_INFO' then
2180: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2176: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information1);
2177: end if;
2178:
2179: if p_rec.org_information_context = 'FR_COMP_INFO' then
2180: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2181: elsif p_rec.org_information_context = 'FR_COMP_PREV_INFO' then
2182: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2183: end if;
2184:
2178:
2179: if p_rec.org_information_context = 'FR_COMP_INFO' then
2180: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2181: elsif p_rec.org_information_context = 'FR_COMP_PREV_INFO' then
2182: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2183: end if;
2184:
2185: HR_ORG_INFORMATION_PKG.validate_business_group_name
2186: (p_organization_id => p_rec.Organization_Id
2181: elsif p_rec.org_information_context = 'FR_COMP_PREV_INFO' then
2182: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2183: end if;
2184:
2185: HR_ORG_INFORMATION_PKG.validate_business_group_name
2186: (p_organization_id => p_rec.Organization_Id
2187: ,p_org_information_context => p_rec.Org_Information_Context
2188: ,p_org_information1 => p_rec.Org_Information1
2189: ,p_org_information2 => p_rec.Org_Information2