DBA Data[Home] [Help]

APPS.EGO_ITEM_ASSOCIATIONS_UTIL dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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