Validations of input parameters

The values specified for the input parameters are validated. These are the validation rules for each parameter in the TFORM_SPLIT_PLANNED_ORDER program:
  • SOURCE: If the value is specified, the records are filtered based on the specified source. Else, all records are processed.
  • TABLE_NAME: If the value is specified:
    • The specified table_name must be an existing entry in the SZ_REG_TABLE table with plan_table_flag set to Y, and table_area set to Core.
    • An error message is logged, and the process is not executed if there is no entry in the SZ_REG_TABLE table with the specified table_name value.
  • ITEM_COLUMN_NAME: If the value is specified:
    • The specified item_column_name must be an existing entry in the SZ_ENTITY_PROPERTY table for the specified TABLE_NAME (the entity_id for the table is obtained from the SZ_ENTITY for the specified TABLE_NAME).
    • An error message is logged, and the process is not executed if there is no entry in the SZ_ENTITY_PROPERTY table with the specified item column name.
  • LOCATION_COLUMN_NAME: If the value is specified:
    • The specified location_column_name must be an existing entry in the SZ_ENTITY_PROPERTY table for the specified TABLE_NAME (the entity_id for the table is obtained from the SZ_ENTITY for the specified TABLE_NAME).
    • An error message is logged, and the process is not executed if there is no entry in the SZ_ENTITY_PROPERTY table with the specified item column name.
  • SOURCE_LOCATION_COLUMN_NAME: If the value is specified:
    • The specified source_location_column_name must be an existing entry in the SZ_ENTITY_PROPERTY table for the specified TABLE_NAME (the entity_id for the table is obtained from the SZ_ENTITY for the specified TABLE_NAME).
    • An error message is logged, and the process is not executed if there is no entry in the SZ_ENTITY_PROPERTY table with the specified item column name.
    • Only one of SOURCE_LOCATION_COLUMN_NAME and SOURCE_SUPPLIER_COLUMN_NAME can be populated. If SOURCE_LOCATION_COLUMN_NAME and SOURCE_SUPPLIER_COLUMN_NAME are populated, an error message is logged, and the process is not executed.
  • SOURCE_SUPPLIER_COLUMN_NAME: If the value is specified:
    • The specified source_supplier_column_name must be an existing entry in the SZ_ENTITY_PROPERTY table for the specified TABLE_NAME (the entity_id for the table is obtained from the SZ_ENTITY for the specified TABLE_NAME).
    • An error message is logged, and the process is not executed if there is no entry in the SZ_ENTITY_PROPERTY table with the specified item column name.
    • Only one of SOURCE_LOCATION_COLUMN_NAME and SOURCE_SUPPLIER_COLUMN_NAME can be populated. If SOURCE_LOCATION_COLUMN_NAME and SOURCE_SUPPLIER_COLUMN_NAME are populated, an error message is logged, and the process is not executed.
Note: The above-mentioned parameters are mandatory, except SOURCE, SOURCE_LOCATION_COLUMN_NAME, and SOURCE_SUPPLIER_COLUMN_NAME.