Validation of input parameters

The values specified for the input parameters are validated. These are the validation rules for each parameter in the EXECUTE_HIERARCHY_PREPARE program:

• HIERARCHY_ID: The specified value must exist with the Active status in the SZ_HIERARCHY table. Else, an error message is displayed, and the execution is stopped.
• HIERARCHY_NAME: The specified value must exist with the Active status in the SZ_HIERARCHY table. Else, an error message is displayed, and the execution is stopped.
  Note: Only the HIERARCHY_ID or HIERARCHY_NAME parameter must be specified. If both parameters are specified, an error message is displayed, and the execution is stopped.
• TABLE_NAME:
  • The specified value must exist with table_area set to Core in the SZ_REG_TABLE table. Else, an error message is displayed, and the execution is stopped.
  • If this parameter is specified and the HIERARCHY_ID or HIERARCHY_NAME parameter is specified, these values must exist with Active status in SZ_HIERARCHY table. Else, an error message is displayed, and the execution is stopped.
• Source: If this parameter is specified, the records associated with the value of the Source parameter are processed. Else, all records are processed.