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.