770: close c_rtf_data;
771:
772:
773: IF p_output_format = 'HTML' THEN
774: success := FND_REQUEST.add_layout(l_app_short_name,l_template_code,l_default_lang,l_default_territory,'HTML');
775: ELSIF p_output_format = 'PDF' or p_output_format ='TXT'THEN
776: success := FND_REQUEST.add_layout(l_app_short_name,l_template_code,l_default_lang,l_default_territory,'PDF');
777: ELSIF p_output_format = 'EXCEL' or p_output_format ='CSV' THEN
778: success := FND_REQUEST.add_layout(l_app_short_name,l_template_code,l_default_lang,l_default_territory,'EXCEL');
772:
773: IF p_output_format = 'HTML' THEN
774: success := FND_REQUEST.add_layout(l_app_short_name,l_template_code,l_default_lang,l_default_territory,'HTML');
775: ELSIF p_output_format = 'PDF' or p_output_format ='TXT'THEN
776: success := FND_REQUEST.add_layout(l_app_short_name,l_template_code,l_default_lang,l_default_territory,'PDF');
777: ELSIF p_output_format = 'EXCEL' or p_output_format ='CSV' THEN
778: success := FND_REQUEST.add_layout(l_app_short_name,l_template_code,l_default_lang,l_default_territory,'EXCEL');
779: ELSIF p_output_format = 'RTF' THEN
780: success := FND_REQUEST.add_layout(l_app_short_name,l_template_code,l_default_lang,l_default_territory,'RTF');
774: success := FND_REQUEST.add_layout(l_app_short_name,l_template_code,l_default_lang,l_default_territory,'HTML');
775: ELSIF p_output_format = 'PDF' or p_output_format ='TXT'THEN
776: success := FND_REQUEST.add_layout(l_app_short_name,l_template_code,l_default_lang,l_default_territory,'PDF');
777: ELSIF p_output_format = 'EXCEL' or p_output_format ='CSV' THEN
778: success := FND_REQUEST.add_layout(l_app_short_name,l_template_code,l_default_lang,l_default_territory,'EXCEL');
779: ELSIF p_output_format = 'RTF' THEN
780: success := FND_REQUEST.add_layout(l_app_short_name,l_template_code,l_default_lang,l_default_territory,'RTF');
781: END IF;
782:
776: success := FND_REQUEST.add_layout(l_app_short_name,l_template_code,l_default_lang,l_default_territory,'PDF');
777: ELSIF p_output_format = 'EXCEL' or p_output_format ='CSV' THEN
778: success := FND_REQUEST.add_layout(l_app_short_name,l_template_code,l_default_lang,l_default_territory,'EXCEL');
779: ELSIF p_output_format = 'RTF' THEN
780: success := FND_REQUEST.add_layout(l_app_short_name,l_template_code,l_default_lang,l_default_territory,'RTF');
781: END IF;
782:
783: if ( not success ) then
784: hr_utility.set_location('XML submit fail' ,50);
786: ELSE
787: hr_utility.set_location('XML submit success' ,50);
788: end if;
789:
790: l_request_id := FND_REQUEST.submit_request(
791: 'PQP'
792: ,'PQPRPEXR'
793: ,NULL
794: ,NULL