BI Publisher Multiple Templates

Hi,

I have an RDF and 6 different BI Publsiher templates to be called based on a parameter passed to the report.

I tried using the FND_REQUEST.ADD_LAYOUT in BEFORE REPORT trigger . But unfortunately only one template is being called for any parameter that is being passed.

Can you help resolve the issue.

Sample:

IF :v_test = 'ABC' then

     l_option_return :=fnd_request.add_layout (template_appl_name      => 'XXRM',

                              template_code           => 'XXRM_ABC,

                              template_language       => 'En',

                              template_territory      => 'US',

                              output_format           => 'PDF');

     

elsif :p_temp_test like XYZ' then

l_option_return :=fnd_request.add_layout (template_appl_name      => 'XXRM',