Using FND Messages in Form Personalization

Step-1 ) Create database function:

CREATE OR REPLACE FUNCTION GET_NEW_MESSAGE_TEST(parameter1 IN VARCHAR2, parameter2 IN VARCHAR2)

RETURN VARCHAR2

is

L_CHR_MSG VARCHAR2(1000);

BEGIN

FND_MESSAGE.SET_NAME(<Application name>,<message name>);

FND_MESSAGE.SET_TOKEN(<token 1>,parameter1);

FND_MESSAGE.SET_TOKEN((<token 2>,parameter2);

L_CHR_MSG := FND_MESSAGE.GET;

RETURN L_CHR_MSG;

END;

Step 2)

Got to forms personalization -- Actions

Type - Message

Type = error

Message text :

=(Select Get_new_msg_test (:<block.fieldname1>,:<block.fld2>) from dual)

Apply. close the form and re visit again..it should be done...