DIRECTORATE-GENERAL FOR HEALTH AND FOOD SAFETY
General Affairs
Information systems
EU-CEG system:Errormessages
Document Control Information
Settings / ValueDocument Title: / XML errormessages for the EU-CEG system.
Project Title: / EU-CEG /
Document Author: / EC
Doc. Version: / 0.1 /
Sensitivity: / Public
Date: / 15/09/2015
Document history:
The Document Author is authorized to make the following types of changes to the document without requiring that the document be re-approved:
- Editorial, formatting, and spelling
- Clarification
To request a change to this document, contact the Document Author or Owner.
Changes to this document are summarized in the following table in reverse chronological order (latest version first).
Revision / Date / Created by / Short Description of Changes0.1 / 14/04/2016 / EC / Creation of the document
Table of Contents
1.Subject
2.Errors in the eu-ceg database
2.1.Data stored in the "APP_RESPONSE" table
2.2.List of codes
2.3.XML submitter
2.3.1.Structure error
2.3.2.Business rules errors
2.4.XML attachment
2.4.1.Structure error
2.4.2.Business rules errors
2.5.XML product
2.5.1.Structure error
2.5.2.Business rules errors
1.Subject
This document explains and gives an overview of the different error messages that are generated during the validation of the XML submitted by the industry.
2.Errors in the eu-ceg database
2.1.Data stored in the "APP_RESPONSE" table
The following data are stored in the "APP_RESPONSE" table:
- ID
- UUID
- CONTENT (the xml message)
- STATUS ("error")
- CREATED_DATE (the creation date of the xml message)
- RECEIVER (party ID)
2.2.List of codes
ERR-STRUCTURE-0001: XML submitter
ERR-STRUCTURE-0002: XML attachment
ERR-STRUCTURE-0003: XML product
ERR-RULES-0001: "SubmitterDetails" element
ERR-RULES-0001-0001: "SubmitterID" attribute
ERR-RULES-0001-0002: "VatNumber" element
ERR-RULES-0002: "Attachment" element
ERR-RULES-0002-0001: "Action" attribute
ERR-RULES-0002-0002: "Action" attribute
ERR-RULES-0003: "Submission" element
ERR-RULES-0003-0001: "SubmissionType" element
ERR-RULES-0003-0002: "SubmissionType" element
ERR-RULES-0004: "Submitter" element
ERR-RULES-0004-0001: "Parent" element
ERR-RULES-0004-0002: "Affiliate" element
ERR-RULES-0004-0003: "Enterer" element
ERR-RULES-0005: "Parent" element
ERR-RULES-0005-0001: "Name" element
ERR-RULES-0005-0002: "Address" element
ERR-RULES-0005-0003: "Country" element
ERR-RULES-0005-0004: "Phone" element
ERR-RULES-0005-0005: "Email" element
ERR-RULES-0006: "Affiliate"element
ERR-RULES-0006-0001: "Name" element
ERR-RULES-0006-0002: "Address" element
ERR-RULES-0006-0003: "Country" element
ERR-RULES-0006-0004: "Phone" element
ERR-RULES-0006-0005: "Email" element
ERR-RULES-0007: "Enterer"element
ERR-RULES-0007-0001: "Name" element
ERR-RULES-0007-0002: "Address" element
ERR-RULES-0007-0003: "Country" element
ERR-RULES-0007-0004: "Phone" element
ERR-RULES-0007-0005: "Email" element
ERR-RULES-0008: "Product"element
ERR-RULES-0008-0001: "PreviousProductID" element
ERR-RULES-0008-0002: "OtherProducts" element
ERR-RULES-0008-0003: "SameCompositionProducts" element
ERR-RULES-0008-0004: "Length" element
ERR-RULES-0008-0005: "Diameter" element
ERR-RULES-0008-0006: "Weight" element
ERR-RULES-0008-0007: "Volume" element
ERR-RULES-0008-0008: "ClpClassification" element
ERR-RULES-0008-0009: "TobaccoWeight" element
ERR-RULES-0008-0010: "Filter" element
ERR-RULES-0008-0011: "FilterLength" element
ERR-RULES-0008-0012: "TechnicalFiles" element
ERR-RULES-0008-0013: "Manufacturers" element
ERR-RULES-0009: "Manufacturer"element
ERR-RULES-0009-0001: "Name" element
ERR-RULES-0009-0002: "Address" element
ERR-RULES-0009-0003: "Country" element
ERR-RULES-0009-0004: "Phone" element
ERR-RULES-0009-0005: "Email" element
ERR-RULES-0010: "ProductionSiteAddress"element
ERR-RULES-0011: "Presentation"element
ERR-RULES-0011-0001: "WithdrawalDate" element
ERR-RULES-0011-0002: "PackageUnits" element
ERR-RULES-0011-0003: "PackageNetWeight" element
ERR-RULES-0011-0004: "OtherMarketData" element
ERR-RULES-0012: "AnnualSalesData"element
ERR-RULES-0013: "Ingredient"element
ERR-RULES-0013-0001: "Name" element
ERR-RULES-0013-0002: "CasNumberExists" element
ERR-RULES-0013-0003: "CasNumber" element
ERR-RULES-0013-0004: "FemaNumber" element
ERR-RULES-0013-0005: "AdditiveNumber" element
ERR-RULES-0013-0006: "FlNumber" element
ERR-RULES-0013-0007: "EcNumber" element
ERR-RULES-0013-0008: "Function" element
ERR-RULES-0013-0009: "FunctionOther" element
ERR-RULES-0013-0010: "RecipeQuantity" element
ERR-RULES-0013-0011: "ToxicityStatus" element
ERR-RULES-0013-0012: "ReachRegistrationNumber" element
ERR-RULES-0013-0013: "ClpWetherClassification" element
ERR-RULES-0013-0014: "ClpAcuteToxOral" element
ERR-RULES-0013-0015: "ClpAcuteToxDermal" element
ERR-RULES-0013-0016: "ClpAcuteToxInhalation" element
ERR-RULES-0013-0017: "ClpSkinCorrositiveIrritant" element
ERR-RULES-0013-0018: "ClpEyeDamageIrritation" element
ERR-RULES-0013-0019: "ClpRespiratorySensitisation" element
ERR-RULES-0013-0020: "ClpSkinSensitisation" element
ERR-RULES-0013-0021: "ClpMutagenGenotox" element
ERR-RULES-0013-0022: "ClpCarcinogenicity" element
ERR-RULES-0013-0023: "ClpReproductiveTox" element
ERR-RULES-0013-0024: "ClpStot" element
ERR-RULES-0013-0025: "ClpStotDescription" element
ERR-RULES-0013-0026: "ClpAspirationTox" element
ERR-RULES-0013-0027: "ToxicologicalDetails" element
ERR-RULES-0014: "TobaccoIngredient"element
ERR-RULES-0014-0001: "PartTypeOther" element
ERR-RULES-0014-0002: "LeafTypeOther" element
ERR-RULES-0014-0003: "LeafCureMethodOther" element
ERR-RULES-0014-0004: "PartDescriptionFiles" element
ERR-RULES-0015: "OtherIngredient"element
ERR-RULES-0015-0001: "CategoryOther" element
ERR-RULES-0015-0002: "CasNumber" element
ERR-RULES-0015-0003: "AdditionalCasNumbers" element
ERR-RULES-0015-0004: "FemaNumber" element
ERR-RULES-0015-0005: "AdditiveNumber" element
ERR-RULES-0015-0006: "FlNumber" element
ERR-RULES-0015-0007: "EcNumber" element
ERR-RULES-0015-0008: "RecipeRangeMinLevel" element
ERR-RULES-0015-0009: "RecipeRangeMaxLevel" element
ERR-RULES-0015-0010: "MeasuredMeanQuantity" element
ERR-RULES-0015-0011: "MeasuredSd" element
ERR-RULES-0015-0012: "MeasuredMinLevel" element
ERR-RULES-0015-0013: "MeasuredMaxLevel" element
ERR-RULES-0015-0014: "MeasuredNumber" element
ERR-RULES-0015-0015: "FunctionOther" element
ERR-RULES-0015-0016: "ReachRegistrationNumber" element
ERR-RULES-0015-0017: "PriorityAdditiveFiles" element
ERR-RULES-0016: "ToxicologicalDetails"element
ERR-RULES-0016-0001: "ToxEmissionFiles" element
ERR-RULES-0016-0002: "ToxCmrFiles" element
ERR-RULES-0016-0003: "ToxCardioPulmonaryFiles" element
ERR-RULES-0016-0004: "ToxAddictiveFiles" element
ERR-RULES-0016-0005: "ToxOtherFiles" element
ERR-RULES-0016-0006: "ToxicologicalDataAvailable" element
ERR-RULES-0016-0007: "ToxEmission" element
ERR-RULES-0016-0008: "ToxCmr" element
ERR-RULES-0016-0009: "ToxCardioPulmonary" element
ERR-RULES-0016-0010: "ToxAddictive" element
ERR-RULES-0016-0011: "ToxOther" element
ERR-RULES-0017: "Emission"element
ERR-RULES-0017-0001: "NameOther" element
ERR-RULES-0017-0002: "CasNumber" element
ERR-RULES-0017-0003: "IupacName" element
ERR-RULES-0018: "TncoEmission"element
ERR-RULES-0018-0001: "Tar" element
ERR-RULES-0018-0002: "Nicotine" element
ERR-RULES-0018-0003: "Co" element
ERR-RULES-0018-0004: "Laboratory" element
ERR-RULES-0019: "OtherEmission"element
ERR-RULES-0020: "Design"element
ERR-RULES-0020-0001: "LiquidVolumeCapacity" element
ERR-RULES-0020-0002: "NicotineConcentration" element
ERR-RULES-0020-0003: "Voltage" element
ERR-RULES-0020-0004: "VoltageLowerRange" element
ERR-RULES-0020-0005: "VoltageUpperRange" element
ERR-RULES-0020-0006: "Wattage" element
ERR-RULES-0020-0007: "WattageLowerRange" element
ERR-RULES-0020-0008: "WattageUpperRange" element
ERR-RULES-0020-0009: "AirflowAdjustable" element
ERR-RULES-0020-0010: "AirflowAdjustable" element
ERR-RULES-0020-0011: "WickChangeable" element
ERR-RULES-0020-0012: "WickChangeable" element
ERR-RULES-0020-0013: "Microprocessor" element
ERR-RULES-0020-0014: "Micorprocessor" element
ERR-RULES-0020-0015: "CoilComposition" element
ERR-RULES-0020-0016: "CoilComposition" element
ERR-RULES-0020-0017: "OpeningRefillFile" element
ERR-RULES-0021: "CigaretteSpecific"element
ERR-RULES-0022: "SmokelessSpecific"element
ERR-RULES-0023: "RyoPipeSpecific"element
ERR-RULES-0024: "NovelSpecific"element
2.3.XML submitter
2.3.1.Structure error
CODE: ERR-STRUCTURE-0001
MESSAGE: List of reasons
2.3.2.Business rules errors
2.3.2.1."SubmitterDetails" element
CODE: ERR-RULES-0001-0001
MESSAGE: The value "xxxxx" of the "submitterID" attribute is not correct because it doesn't correspond to the party "value" that sends the XML submitter.
CODE: ERR-RULES-0001-0002
MESSAGE: The value of the "VatNumber" element cannot be empty because the value of the "HasVatNumber" element is "true".
2.4.XML attachment
2.4.1.Structure error
CODE: ERR-STRUCTURE-0002
MESSAGE: List of reasons
2.4.2.Business rules errors
2.4.2.1."Attachment" element
CODE: ERR-RULES-0002-0001
MESSAGE: The value "UPDATE" of the "action" attribute is not correct because no attachment exists yet for this uuid"xxxxx".
CODE: ERR-RULES-0002-0002
MESSAGE: The value "CREATE" of the "action" attribute is not correct because the attachment already exists for this uuid"xxxxx".
2.5.XML product
2.5.1.Structure error
CODE: ERR-STRUCTURE-0003
MESSAGE: List of reasons
2.5.2.Business rules errors
2.5.2.1."Submission" element
CODE: ERR-RULES-0003-0001
MESSAGE: The value "x" of the "SubmissionType" element is not correct because only the value "1", "2" or "7" is possible.
CODE: ERR-RULES-0003-0002
MESSAGE: The value of the "SubmissionType" element cannot be "2" or "7" because there is not submission yet for this product.
2.5.2.2."Submitter" element
CODE: ERR-RULES-0004-0001
MESSAGE: The XML must contain the "Parent" element because the value of the "HasParent" element is "true".
CODE: ERR-RULES-0004-0002
MESSAGE: The XML must contain the "Affiliate" element because the value of the "HasAffiliate" element is "true".
CODE: ERR-RULES-0004-0003
MESSAGE: The XML must contain the "Enterer" element because the value of the "HasEnterer" element is "true".
2.5.2.3."Parent" element
CODE: ERR-RULES-0005-0001
MESSAGE: The value of the "Name" element must be empty element because the value of the "SubmitterId" element is completed.
CODE: ERR-RULES-0005-0002
MESSAGE: The value of the "Address" element must be empty element because the value of the "SubmitterId" element is completed.
CODE: ERR-RULES-0005-0003
MESSAGE: The value of the "Country" element must be empty element because the value of the "SubmitterId" element is completed.
CODE: ERR-RULES-0005-0004
MESSAGE: The value of the "Phone" element must be empty element because the value of the "SubmitterId" element is completed.
CODE: ERR-RULES-0005-0005
MESSAGE: The value of the "Email" element must be empty element because the value of the "SubmitterId" element is completed.
2.5.2.4."Affiliate" element
CODE: ERR-RULES-0006-0001
MESSAGE: The value of the "Name" element must be empty element because the value of the "SubmitterId" element is completed.
CODE: ERR-RULES-0006-0002
MESSAGE: The value of the "Address" element must be empty element because the value of the "SubmitterId" element is completed.
CODE: ERR-RULES-0006-0003
MESSAGE: The value of the "Country" element must be empty element because the value of the "SubmitterId" element is completed.
CODE: ERR-RULES-0006-0004
MESSAGE: The value of the "Phone" element must be empty element because the value of the "SubmitterId" element is completed.
CODE: ERR-RULES-0006-0005
MESSAGE: The value of the "Email" element must be empty element because the value of the "SubmitterId" element is completed.
2.5.2.5."Enterer" element
CODE: ERR-RULES-0007-0001
MESSAGE: The value of the "Name" element must be empty element because the value of the "SubmitterId" element is completed.
CODE: ERR-RULES-0007-0002
MESSAGE: The value of the "Address" element must be empty element because the value of the "SubmitterId" element is completed.
CODE: ERR-RULES-0007-0003
MESSAGE: The value of the "Country" element must be empty element because the value of the "SubmitterId" element is completed.
CODE: ERR-RULES-0007-0004
MESSAGE: The value of the "Phone" element must be empty element because the value of the "SubmitterId" element is completed.
CODE: ERR-RULES-0007-0005
MESSAGE: The value of the "Email" element must be empty element because the value of the "SubmitterId" element is completed.
2.5.2.6."Product" element
CODE: ERR-RULES-0008-0001
MESSAGE: The value of the "PreviousProductID" element cannot be empty because the value of the "SubmissionType" element is "2".
CODE: ERR-RULES-0008-0002
MESSAGE: The "OtherProducts" element must be present because the value of the "OtherProductsExist" element is "true".
CODE: ERR-RULES-0008-0003
MESSAGE: The "SameCompositionProducts" element must be present because the value of the "SameCompositionProductsExist" element is "true".
CODE: ERR-RULES-0008-0004
MESSAGE: The value of the "Length" element cannot be empty because the value of the "ProductType" is "1", "2" or "3".
CODE: ERR-RULES-0008-0005
MESSAGE: The value of the "Diameter" element cannot be empty because the value of the "ProductType" is "1", "2" or "3".
CODE: ERR-RULES-0008-0006
MESSAGE: The value of the "Weight" element cannot be empty because the value of the "ProductType" is "1", "2", "4" or "7".
CODE: ERR-RULES-0008-0007
MESSAGE: The value of the "Volume" element cannot be empty because the value of the "ProductType" is "1", "2", "4" or "7".
CODE: ERR-RULES-0008-0008
MESSAGE: The value of the "ClpClassification" element cannot be empty because the value of the "ProductType" is "1", "2", "4" or "7".
CODE: ERR-RULES-0008-0009
MESSAGE: The value of the "TobaccoWeight" element cannot be empty because the value of the "ProductType" is "1", "2", "3", "4", "5", "6", "7", "8", "9" or "16".
CODE: ERR-RULES-0008-0010
MESSAGE: The value of the "Filter" element cannot be empty because the value of the "ProductType" is "1", "2" or "3".
CODE: ERR-RULES-0008-0011
MESSAGE: The value of the "FilterLength" element cannot be empty because the value of the "ProductType" is "1", "2" or "3" and the value of the "Filter" element is "true".
CODE: ERR-RULES-0008-0012
MESSAGE: The "TechnicalFiles" element must be present because the value of the "ProductType" element is "1" or "4".
CODE: ERR-RULES-0008-0013
MESSAGE: The "Manufacturers" element must be present because the value of the "SubmitterType" element is "1".
2.5.2.7."Manufacturer" element
CODE: ERR-RULES-0009-0001
MESSAGE: The value of the "Name" element must be empty element because the value of the "SubmitterId" element is completed.
CODE: ERR-RULES-0009-0002
MESSAGE: The value of the "Address" element must be empty element because the value of the "SubmitterId" element is completed.
CODE: ERR-RULES-0009-0003
MESSAGE: The value of the "Country" element must be empty element because the value of the "SubmitterId" element is completed.
CODE: ERR-RULES-0009-0004
MESSAGE: The value of the "Phone" element must be empty element because the value of the "SubmitterId" element is completed.
CODE: ERR-RULES-0009-0005
MESSAGE: The value of the "Email" element must be empty element because the value of the "SubmitterId" element is completed.
2.5.2.8."ProductionSiteAddress" element
2.5.2.9."Presentation" element
CODE: ERR-RULES-0011-0001
MESSAGE: The value of the "WithdrawalDate" element cannot be empty because the value of the "WithdrawalIndication" element is "true" of the "Presentation" element where the value of the "NationalMarket" element is "XXX", the value of the "BrandName" element is "XXX" and the value of the "ProductNumber" element is "XXX".
CODE: ERR-RULES-0011-0002
MESSAGE: The "PackageUnits" element of the "Presentation" element where the value of the "NationalMarket" element is "XXX", the value of the "BrandName" element is "XXX" and the value of the "ProductNumber" element is "XXX" cannot be empty because the value of the "ProductType" is "1", "2" or "3".
CODE: ERR-RULES-0011-0003
MESSAGE: The "PackageNetWeight" element of the "Presentation" element where the value of the "NationalMarket" element is "XXX", the value of the "BrandName" element is "XXX" and the value of the "ProductNumber" element is "XXX" cannot be empty because the value of the "ProductType" is "4", "6", "7", "8", "9", "15" or "16".
CODE: ERR-RULES-0011-0004
MESSAGE: The value of the "OtherMarketData" element of the "Presentation" element where the value of the "NationalMarket" element is "XXX", the value of the "BrandName" element is "XXX" and the value of the "ProductNumber" element is "XXX" cannot be empty because the value of the "HasOtherMarketData" element is "true".
2.5.2.10."AnnualSatesData" element
2.5.2.11."Ingredient" element
CODE: ERR-RULES-0013-0001
MESSAGE: The "Name" element cannot be empty because the value of the "ProductType" element is "1", "2", "4" or "7".
CODE: ERR-RULES-0013-0002
MESSAGE: The "CasNumberExists" element cannot be empty because the value of the "ProductType" element is "1", "2", "4" or "7".
CODE: ERR-RULES-0013-0003
MESSAGE: The "CasNumber" element cannot be empty because the value of the "ProductType" element is "1", "2", "4" or "7" and the value of the "CasNUmberExists" element is "true".
CODE: ERR-RULES-0013-0004
MESSAGE: The value of the "FemaNumber" element cannot be empty because the value of the "ProductType" element is "1", "2", "4" or "7" and the value of the "CasNumber", "AdditiveNumber", "FlNumber" and "EcNumber" elements is empty.
CODE: ERR-RULES-0013-0005
MESSAGE: The value of the "AdditiveNumber" element cannot be empty because the value of the "ProductType" element is "1", "2", "4" or "7" and the value of the "CasNumber", "FemaNumber", "FlNumber" and "EcNumber" elements is empty.
CODE: ERR-RULES-0013-0006
MESSAGE: The value of the "FlNumber" element cannot be empty because the value of the "ProductType" element is "1", "2", "4" or "7" and the value of the "CasNumber", "AdditiveNumber", "FemaNumber" and "EcNumber" elements is empty.
CODE: ERR-RULES-0013-0007
MESSAGE: The value of the "EcNumber" element cannot be empty because the value of the "ProductType" element is "1", "2", "4" or "7" and the value of the "CasNumber", "AdditiveNumber", "FemaNumber" and "FlNumber" elements is empty.
CODE: ERR-RULES-0013-0008
MESSAGE: The value of the "Function" element must be present because the value of the "ProductType" element is "1", "2", "4" or "7".
CODE: ERR-RULES-0013-0009
MESSAGE: The value of the "FunctionOther" element cannot be empty because the value of the "ProductType" element is "1", "2", "4" or "7" and the value of the "Function" element is "other".
CODE: ERR-RULES-0013-0010
MESSAGE: The value of the "RecipeQuantity" element cannot be empty because the value of the "ProductType" element is "1", "2", "4" or "7".
CODE: ERR-RULES-0013-0011
MESSAGE: The value of the "ToxicityStatus" element cannot be empty because the value of the "ProductType" element is "1", "2", "4" or "7" and the value of the "ProductType" element is "1", "2", "4" or "7".
CODE: ERR-RULES-0013-0012
MESSAGE: The value of the "ReachRegistrationNumber" element cannot be empty because the value of the "ReachRegistration" element is empty.
CODE: ERR-RULES-0013-0013
MESSAGE: The value of the "ClpWetherClassification" element cannot be empty because the value of the "ProductType" element is "1", "2", "4" or "7".
CODE: ERR-RULES-0013-0014
MESSAGE: The value of the "ClpAcuteToxOral" element cannot be empty because the value of the "ClpWetherClassification" element is "true".
CODE: ERR-RULES-0013-0015
MESSAGE: The value of the "ClpAcuteToxDermal" element cannot be empty because the value of the "ClpWetherClassification" element is "true".
CODE: ERR-RULES-0013-0016
MESSAGE: The value of the "ClpAcuteToxInhalation" element cannot be empty because the value of the "ClpWetherClassification" element is "true".
CODE: ERR-RULES-0013-0017
MESSAGE: The value of the "ClpSkinCorrositiveIrritant" element cannot be empty because the value of the "ClpWetherClassification" element is "true".
CODE: ERR-RULES-0013-0018
MESSAGE: The value of the "ClpEyeDamageIrritation" element cannot be empty because the value of the "ClpWetherClassification" element is "true".
CODE: ERR-RULES-0013-0019
MESSAGE: The value of the "ClpRespiratorySensitisation" element cannot be empty because the value of the "ClpWetherClassification" element is "true".