7 Replies Latest reply on Dec 1, 2007 5:20 AM by 611077

    how to call FND_REQUEST.SUBMIT_REQUEST in forms

    611077
      hi,
      i tried to submit concurrent request from forms by using FND_REQUEST.SUBMIT_REQUEST() stored procedure. i passed all the required parameters.
      This is the code
      l_request_id := FND_REQUEST.SUBMIT_REQUEST(
      'AR',
      'XXSSIIBCLCON',
      null
      );
      When compile this in WHEN BUTTON PRESSED trigger it throws the following error
      Error 707: unsupported construct or internal error(2601)

      Please help me to fix this error

      Thanks,
      Khan

      Message was edited by:
      amjadkhan
        • 1. Re: how to call FND_REQUEST.SUBMIT_REQUEST in forms
          577207
          Hello,

          Please see the following;

          https://metalink.oracle.com/metalink/plsql/f?p=200:27:3210552301722554040::::p27_id,p27_show_header,p27_show_help:294005.996,1,1

          Oracle Metalink: Error 707 unsupported construct or internal error 2601: Doc ID: 294005.996.

          Adith
          • 2. Re: how to call FND_REQUEST.SUBMIT_REQUEST in forms
            611077
            req_id := fnd_request.submit_request(
            'AR',
            'XXARALDL',
            NULL, null,
            FALSE, NULL, NULL, NULL,………….Null );

            We could able to call the concurrent program by giving other parameter as NULL, But it is not generating the reports(output file).

            Thanks,
            Amjad khan
            • 3. Re: how to call FND_REQUEST.SUBMIT_REQUEST in forms
              591713
              Before calling fnd_request.submit_Request
              call fnd_request.set_print_options (set the value for the parameter save_output as TRUE). By calling this funciton, you will be able to get the output as well.
              • 4. Re: how to call FND_REQUEST.SUBMIT_REQUEST in forms
                611077
                I tried with the API fnd_request.set_print_options(), still it does not generating the view log out output.

                Actually we are calling our custom report concurrent program in fnd_request.submit_request() API to submit concurrent process.

                fnd_request.submit_request() API returning the concurrent request id, but when query up the id in
                fnd_concurrent_requests table, its not there. Please help me to fix the issue.

                Thanks,
                amjadkhan
                • 5. Re: how to call FND_REQUEST.SUBMIT_REQUEST in forms
                  591713
                  You have to commit to see the request_id in the fnd_concurrent_requests table.
                  • 6. Re: how to call FND_REQUEST.SUBMIT_REQUEST in forms
                    552232
                    you need to pass values for all 100 params

                    like this

                         l_request_id := fnd_request.submit_request('XXX',
                    'XXXSPVF',
                    NULL,
                    NULL,
                    FALSE,
                    :p_move_order_high,
                    :p_org_id,
                    '', --l_printer,
                    '','','','','','','','','','','',
                    '','','','','','','','','','','',
                    '','','','','','','','','','','',
                    '','','','','','','','','','','',
                    '','','','','','','','','','','',
                    '','','','','','','','','','','',
                    '','','','','','','','','','','',
                    '','','','','','','','','','','',
                    '','','','','','','','','');
                         COMMIT;

                    Thanks
                    Tom...

                    Message was edited by:
                    Tom Trever
                    • 7. Re: how to call FND_REQUEST.SUBMIT_REQUEST in forms
                      611077
                      This issue has been fixed by including the library GLCORE.pll and adding the below code while submitting the concurrent request

                      gl_working.work_begin;
                      req_id := fnd_request.submit_request(
                      'AR',
                      'XXARALDL', '', '', FALSE,
                      '','','','','','','','','','','',
                      '','','','','','','','','','','',
                      '','','','','','','','','','','',
                      '','','','','','','','','','','',
                      '','','','','','','','','','','',
                      '','','','','','','','','','','',
                      '','','','','','','','','','','',
                      '','','','','','','','','','','',
                      '','','','','','','','','');

                      -- Failure in submission the concurrent request.
                      IF (req_id = 0) then
                      gl_working.work_end;
                      fnd_message.retrieve;
                      fnd_message.error;
                      Raise Form_Trigger_Failure;
                      END IF;
                      gl_working.work_end;


                      -- Show the concurrent request id.
                      gl_message.show( 'GL_REQUEST_SUBMITTED',
                      'REQUEST_ID',
                      to_char( req_id ) );


                      gl_working.work_begin;
                      -- Commit the concurrent request submission and the form.
                      app_form.set_message_level(25);
                      app_standard.event( 'KEY-COMMIT' );
                      app_form.reset_message_level;
                      gl_working.work_end;

                      Thanks,
                      amjadkhan