Consumers can query/insert/update/delete data through the methods available in these public services from the Smart Reference Data database. Unhandled situations when the consumer enters invalid data to perform any of the above operations can result in an exception. The CMS Services handle the exceptions and provide a relevant message to the consumer instead of displaying an exception.
The following are some examples where exceptions are handled and validations are provided.
Insert/Update Exceptions
-
When the consumer enters data with an invalid length
-
When the consumer enters an invalid date format for ‘Approved date’. The following message appears.
-
Foreign key validation for ‘Approver name’. The following message appears.
-
Foreign key validation for ‘Commodity Group’
-
Foreign key validation for ‘Commodity Part’
-
Proper validation for data entered in ‘Valid From’ and ‘Valid To’ fields
-
Validation for Link ITR CC
-
Foreign key validation ITR Link CC, Group, Part - Foreign key validation
-
Validation to check if ITR Link CC and Commodity Code are different or not
The following validations are performed for Commodity Details:
-
Validations for date entered in ‘Digit from’ and ‘Digit To’ fields. A message appears when the proper data is not entered.
-
Foreign key validation for Attribute
-
Validating the ‘Attribute Values’ with the look up values available for the ‘Attribute’
The following validations are performed for Multiple Link CC:
-
Validation to check if ITR Link CC and Commodity Code are different or not
-
Validation to check if ITR Link CC and Link CC are different or not
-
Foreign key validation for Link CC, Group, Part
Delete Exceptions
-
Validation performed to check if all the inputs given for commodity group, part, and code are correct when deleting a commodity code.
