RAISE

Syntax

procedure RAISE
  (name in varchar2);

Description

Raises an exception to the caller by supplying a correct error number and token substituted message for the name of the error message provided.

Calls to TOKEN() and RAISE() raise predefined errors for Oracle Workflow that are stored in the WF_RESOURCES table. The error messages contain tokens that need to be replaced with relevant values when the error message is raised. This is an alternative to raising PL/SQL standard exceptions or custom-defined exceptions.

Error messages for Oracle Workflow are initially defined in message files (.msg). The message files are located in the $FND_TOP/import/<language> directory. During the installation of Oracle Workflow, a program called Workflow Resource Generator takes the designated message files and imports the messages into the WF_RESOURCES table.

Note: If you want to use custom error messages, you can define your messages in .msg files, load them to the WF_RESOURCES table, and then raise them using RAISE(). A custom error message must have an error number of 90000 or higher.

Arguments (input)

name Internal name of the error message as stored in the table WF_RESOURCES.

To run the Workflow Resource Generator:

  1. The Workflow Resource Generator program is registered as a concurrent program. You can run the Workflow Resource Generator (FNDWFRESGEN) concurrent program from the Submit Requests form or from the command line.

  2. To run the concurrent program from the Submit Requests form, navigate to the Submit Requests form.

    Note: Your system administrator needs to add this concurrent program to a request security group for the responsibility that you want to run this program from. See: Overview of Concurrent Programs and Requests.

  3. Submit the Workflow Resource Generator concurrent program as a request. See: Running Reports and Programs.

  4. In the Parameters window, enter values for the following parameters:

    Destination Type Specify "Database", to upload seed data to the database table WF_RESOURCES from a source file (.msg), or "File", to generate a resource file from a source file.
    Destination If you specify "File" for Destination Type, then enter the full path and name of the resource file you wish to generate. If you specify "Database" for Destination Type, then the program automatically uses the current database account as its destination.
    Source Specify the full path and name of your source file.

  5. Choose OK to close the Parameters window.

  6. When you finish modifying the print and run options for this request, choose Submit to submit the request.

  7. Rather than use the Submit Requests form, you can also run the Workflow Resource Generator concurrent program from the command line using one of two commands. To generate a resource file from a source file, type:

    WFRESGEN apps 0 Y FILE res_file source_file
ORACLE Password:

    To upload seed data to the database table WF_RESOURCES from a source file, type:

    WFRESGEN apps 0 Y DATABASE source_file
ORACLE Password:

    Replace apps with the username for the APPS schema, replace res_file with the file specification of a resource file, and replace source_file with the file specification of a source file (.msg). A file specification is specified as:

    @<application_short_name>:[<dir>/.../]file.ext

    or

    <native path>

    When prompted, enter the password for the APPS schema.

Related Topics