Validation of input parameters

The values specified for the input parameters must be validated. These are the validation rules for each parameter:

• HIERARCHY_ID: If this value is specified, an existing entry must be available in the SZ_HIERARCHY table with the Active status and the hierarchy_source field must be set to Generated. If there are no Active and Generated entries in the SZ_HIERARCHY table with the provided HIERARCHY_ID value, an error message is logged, and the execution is stopped.
  Note: The program can only use either the HIERARCHY_ID or HIERARCHY_NAME. If both parameters are populated an error message is logged, and the execution is stopped.
• HIERARCHY_NAME: If this value is specified, an existing entry must be available in the SZ_HIERARCHY table with the Active status and the hierarchy_source field must be set to Generated. If there are no Active and Generated entries in the SZ_HIERARCHY table with the provided HIERARCHY_NAME value, an error message is logged, and the execution is stopped.
• SOURCE: If this value is specified, records are processed based on the specified value. Else, all records are processed.