29 May 2008

Oracle Apps: Raising error message from Custom Objects

Don't use raise_application_error(-20000,ln_ERR_MESG) to raise any exception in custom objects instead use following

FND_MESSAGE.SET_NAME('Application Short Name',Message Name);
FND_MSG_PUB.ADD;
RAISE fnd_api.g_exc_error;

No comments: