How to submit RTF Layout from Backend
DECLARE
l_bool BOOLEAN;
l_request_id NUMBER;
BEGIN
fnd_global.apps_initialize (user_id => 9999,--fnd_global.user_id,
resp_id => 20560,--fnd_global.resp_id,
resp_appl_id => 706--fnd_global.resp_appl_id
);
l_bool :=
fnd_request.add_layout (template_appl_name => '''TECHHARDS''',
template_code => '''TECHHARDS_OSP_COMP_SHRTG''',
template_language => '''EN''',
template_territory => '''IN''',
output_format => '''PDF'''
);
l_request_id :=
fnd_request.submit_request (application => '''TECHHARDS''',
program => '''TECHHARDS_OSP_COMP_SHRTG''',
description => '',
start_time => SYSDATE,
sub_request => NULL
-- argument1 => fnd_global.org_id,
-- argument2 => p_inv_id
);
IF l_request_id = 0
THEN
DBMS_OUTPUT.put_line (l_request_id);
-- raise_application_error (-20001, '''Dear Unable to Submit Report''');
END IF;
DBMS_OUTPUT.put_line (l_request_id);
COMMIT;
END;
