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;
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;
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;
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: