Validations of input parameters

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

• MODE: The specified value must be DEV. Else, an error message is displayed, and the execution is stopped.
  Note: If the value is specified, the standard BOIs are processed.
• BOI_NAME:
  • If a value for this parameter is specified and the value for MODE is set to DEV, the BOI_Name must exist with the Active status in the SZ_BOI table. Else, an error message is displayed, and the execution is stopped.
  • If a value for this parameter is specified and the value for MODE is not specified, the BOI_NAME must exist with Active status and sc_indicator = C in the SZ_BOI table. Else, an error message is displayed, and the execution is stopped.
• BOI_DIRECTION:
  • The specified value must be IMPORT or EXPORT. Else, an error message is logged, and the execution is stopped.
  • If the value of this parameter is set to IMPORT, and the value of the MODE parameter is set to DEV, the BOIs in the SZ_BOI table with the Active status and Import direction are considered.
  • If the value of this parameter is set to IMPORT, and the value of the MODE parameter is not specified, the BOIs in the SZ_BOI table with the Active status, Import direction, and sc_indicator = C are considered.
  • If the values of the BOI_NAME and BOI_DIRECTION parameters are not specified, the

    At least one of the parameters must be not null

    error message is logged, and the execution is stopped.
  • If the values of the BOI_NAME and BOI_DIRECTION parameters are specified, the

    Only one of the parameters can be specified at a time

    error message is logged, and the execution is stopped.