2033: --
2034: -- start of fix for Bug #2586522
2035: --
2036: if p_rec.org_information_context = 'FR_ESTAB_INFO' then
2037: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information2);
2038: elsif p_rec.org_information_context = 'FR_ESTAB_PREV_INFO' then
2039: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information1);
2040: end if;
2041:
2035: --
2036: if p_rec.org_information_context = 'FR_ESTAB_INFO' then
2037: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information2);
2038: elsif p_rec.org_information_context = 'FR_ESTAB_PREV_INFO' then
2039: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information1);
2040: end if;
2041:
2042: if p_rec.org_information_context = 'FR_COMP_INFO' then
2043: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2039: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information1);
2040: end if;
2041:
2042: if p_rec.org_information_context = 'FR_COMP_INFO' then
2043: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2044: elsif p_rec.org_information_context = 'FR_COMP_PREV_INFO' then
2045: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2046: end if;
2047:
2041:
2042: if p_rec.org_information_context = 'FR_COMP_INFO' then
2043: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2044: elsif p_rec.org_information_context = 'FR_COMP_PREV_INFO' then
2045: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2046: end if;
2047:
2048: HR_ORG_INFORMATION_PKG.validate_business_group_name
2049: (p_organization_id => p_rec.Organization_Id
2044: elsif p_rec.org_information_context = 'FR_COMP_PREV_INFO' then
2045: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2046: end if;
2047:
2048: HR_ORG_INFORMATION_PKG.validate_business_group_name
2049: (p_organization_id => p_rec.Organization_Id
2050: ,p_org_information_context => p_rec.Org_Information_Context
2051: ,p_org_information1 => p_rec.Org_Information1
2052: ,p_org_information2 => p_rec.Org_Information2
2180: X_Org_information8 => p_rec.org_information8);
2181: END IF;
2182:
2183: if p_rec.org_information_context = 'FR_ESTAB_INFO' then
2184: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information2);
2185: elsif p_rec.org_information_context = 'FR_ESTAB_PREV_INFO' then
2186: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information1);
2187: end if;
2188:
2182:
2183: if p_rec.org_information_context = 'FR_ESTAB_INFO' then
2184: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information2);
2185: elsif p_rec.org_information_context = 'FR_ESTAB_PREV_INFO' then
2186: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information1);
2187: end if;
2188:
2189: if p_rec.org_information_context = 'FR_COMP_INFO' then
2190: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2186: HR_ORG_INFORMATION_PKG.Validate_SIRET(X_SIRET => p_rec.org_information1);
2187: end if;
2188:
2189: if p_rec.org_information_context = 'FR_COMP_INFO' then
2190: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2191: elsif p_rec.org_information_context = 'FR_COMP_PREV_INFO' then
2192: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2193: end if;
2194:
2188:
2189: if p_rec.org_information_context = 'FR_COMP_INFO' then
2190: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2191: elsif p_rec.org_information_context = 'FR_COMP_PREV_INFO' then
2192: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2193: end if;
2194:
2195: HR_ORG_INFORMATION_PKG.validate_business_group_name
2196: (p_organization_id => p_rec.Organization_Id
2191: elsif p_rec.org_information_context = 'FR_COMP_PREV_INFO' then
2192: HR_ORG_INFORMATION_PKG.Validate_SIREN(X_SIREN => p_rec.org_information1);
2193: end if;
2194:
2195: HR_ORG_INFORMATION_PKG.validate_business_group_name
2196: (p_organization_id => p_rec.Organization_Id
2197: ,p_org_information_context => p_rec.Org_Information_Context
2198: ,p_org_information1 => p_rec.Org_Information1
2199: ,p_org_information2 => p_rec.Org_Information2