Hi, i have 2 parameters.
1)1st parameter has independent value set and it will have only 2 possible values 'week' or 'month' and value_set name is "xx_period_type"
2)2nd parameter has table value set which should display the 'weekno-year'of last 5 years if parameter1 value passed is 'week'.
3)2nd parameter value set should display the 'month-year' of last 5 years if parameter1 value passed is 'month'.

Code for table value_set is , for table name i wrote the below query:

(select decode(:$flex$.xx_period_type,'week',(to_char(sysdate+1-((rownum)*7) ,'ww-yyyy')),to_char(add_months(sysdate,-rownum+1),'month-yyyy')) week_month from all_objects

and in the where/order by clause:

where rownum< decode(:$flex$.xx_period_type,'week',261,61))

but it is giving error app-fnd-00005:incorrect arguments were passed to user exit #message_token.