BTN use on Oracle forms
BTN Select Use on Oracle Forms BTN Use In Oracle Form:- FND_MESSAGE.SET_NAME('XXCOM','XXCOM_TEST_M1'); BTN_SELECT:=FND_MESSAGE.QUESTION('YES','NO','CANCEL','',3,'CAUTION'); IF BTN_SELECT = 1 THEN Condition; ELSIF BTN_SELECT = 2 THEN Condition ; ELSE Condition ; END IF; Example:- ------------------------------------------------------------------------ DECLARE V_TOKEN_VALUE VARCHAR2(1000); BTN_SELECT NUMBER; V_FORM VARCHAR2(100); SELECT_OPTION NUMBER; V_PARAMETER_1 VARCHAR2(100); BEGIN V_PARAMETER_1:= :XXCOM_RCPT_ENTRY_TL.PROJECT_ID ||'#1#' || :XXCOM_RCPT_ENTRY_TL.RECEIPT_DATE ||'#2#' || :XXCOM_RCPT_ENTRY_TL.CUSTOMER_NUMBER; /* FND_MESSAGE.SET_STRING('1:-'||V_PARAMETER_1); FND_MESSAGE.SHOW(); */ FND_MESSAGE.SET_