Validate the Derived Encoding Date Through TMS

API to validate the TMS Encoding Date.

Use this API to validate the TMS Encoding Date. This public API returns the reencoding date for an Oracle DMW term classified through TMS successfully for scenarios where TMS term is reclassified on the TMS-side directly. The subsequent data load in Oracle DMW reclassifies the term during TMS post-processing.

Name

DME_PUB_XFORM_MAP.getTMSReEncodingDate

Signature

function dme_pub_xform_map.getTMSReEncodingDate (
  p_api_version IN VARCHAR2,
  p_init_msg_list IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE,
  p_commit IN VARCHAR2 default CDR_PUB_DEF_CONSTANTS.G_FALSE,
  p_validation_level IN NUMBER default CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL,
  x_return_status OUT NOCOPY VARCHAR2,
  x_msg_count OUT NOCOPY NUMBER,
  x_msg_data OUT NOCOPY VARCHAR2,
  p_sourceTermId  IN NUMBER
)

return date: It returns the reencoding date for the p_sourceTermId that is passed. The API looks up the reencoding date in an internal TMS table for the given p_sourceTermId. If p_sourceTermId is passed as null, the API returns the reencoding date as null.

Parameters

This API has standard parameters (see Standard Parameters) and the following parameters:

• p_api_version (Mandatory): Enter the current version of the API you are calling. The API compares the version numbers of incoming calls to its current version number and returns an error if they are incompatible.
• p_init_msg_list (Optional): Accept the default value (FND_API.G_FALSE) to ensure that this individual API does not initialize the message list upon completion. Pass FND_API.G_TRUE to override the default behavior.
• p_commit (Optional): Accept the default value (FND_API.G_FALSE) to ensure that this individual API does not commit upon completion. Pass FND_API.G_TRUE to override the default behavior.
• p_validation_level (Optional): Accept the default value to perform full validation. No other values are currently supported.
• x_return_status: This output parameter returns the end status of the API: (S) Success, (E) Error, or (U) Unexpected Error
• x_msg_count: This output parameter returns the count of error messages if the return status is other than Success.
• x_msg_data: This output parameter returns the text of the error message, if the message count is 1. If there are more than one messages, use cdr_pub_msg_pub.get to retrieve the messages.
• p_sourceTermId (Mandatory): Enter the TERM_ID of the source term stored in DMW.