DBA Data[Home] [Help]

APPS.EGO_ITEM_ASSOCIATIONS_UTIL dependencies on FND_MESSAGE

Line 401: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERROR');

397: -- But the complete error message should be less than 2000 characters.
398: -- Since the SQLERRM is a token with in the message, add only 1900
399: -- characters, which should be enough to identify the root cause
400: l_err_msg := 'Unexpected Error Occured: ' || SUBSTR(SQLERRM,1,1900);
401: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERROR');
402: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);
403: fnd_message.set_token ('API_NAME', l_api_name);
404: fnd_message.set_token ('SQL_ERR_MSG', l_err_msg);
405: --ROLLBACK TO search_supplier_and_site_pvt;

Line 402: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);

398: -- Since the SQLERRM is a token with in the message, add only 1900
399: -- characters, which should be enough to identify the root cause
400: l_err_msg := 'Unexpected Error Occured: ' || SUBSTR(SQLERRM,1,1900);
401: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERROR');
402: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);
403: fnd_message.set_token ('API_NAME', l_api_name);
404: fnd_message.set_token ('SQL_ERR_MSG', l_err_msg);
405: --ROLLBACK TO search_supplier_and_site_pvt;
406: app_exception.raise_exception;

Line 403: fnd_message.set_token ('API_NAME', l_api_name);

399: -- characters, which should be enough to identify the root cause
400: l_err_msg := 'Unexpected Error Occured: ' || SUBSTR(SQLERRM,1,1900);
401: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERROR');
402: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);
403: fnd_message.set_token ('API_NAME', l_api_name);
404: fnd_message.set_token ('SQL_ERR_MSG', l_err_msg);
405: --ROLLBACK TO search_supplier_and_site_pvt;
406: app_exception.raise_exception;
407: END search_supplier_and_site;

Line 404: fnd_message.set_token ('SQL_ERR_MSG', l_err_msg);

400: l_err_msg := 'Unexpected Error Occured: ' || SUBSTR(SQLERRM,1,1900);
401: fnd_message.set_name ('EGO', 'EGO_PLSQL_ERROR');
402: fnd_message.set_token ('PKG_NAME', G_PKG_NAME);
403: fnd_message.set_token ('API_NAME', l_api_name);
404: fnd_message.set_token ('SQL_ERR_MSG', l_err_msg);
405: --ROLLBACK TO search_supplier_and_site_pvt;
406: app_exception.raise_exception;
407: END search_supplier_and_site;
408: