4 Replies Latest reply: Jun 24, 2013 4:29 PM by ThAn RSS

    issue in getting output through concurrent program

    1010764

      Hi,

       

      I have developed a procedure and registered in APPS and passing 2 parameters.

       

      while running the concurrent program i have entered values for 2 parameters and submitted.. but it is going as null (log file) and i am not getting output.

      This procedure is working fine in Back End.

       

      Please help me to fix it.

      What could be the issue...

       

      Thanks

      Winsky.

        • 1. Re: issue in getting output through concurrent program
          shreevat

          Please post your code snippet. I am assuming you are passing default parameters errbuf and errcode to the procedure. Also using ffnd_file.put_line (fnd_file.log,"<message>"); for printing the log messages.

           

          Thanks

          Shree

          • 2. Re: issue in getting output through concurrent program
            1010764

            I have checked it is null while printing.

             

             

            my procedure is

             

            proc(a number, b varchar2, errbuf varchar2, errcode number is )

            (

             

            -----

            }

             

             

            while running the procedure in Apps :

             

            It is popping up for values a, b. I have given..

            Log : a null

            b=null;

             

            why it is so..?

             

             

            Thanks,

            Winsky..

            • 3. Re: issue in getting output through concurrent program
              Srini Chavali-Oracle

              Code developed for EBS requires the errbuf and retcode OUT parameters - pl search Google for examples. Make these changes and your code should work as expected

               

              HTH
              Srini

              • 4. Re: issue in getting output through concurrent program
                ThAn

                Hi,

                 

                stored procedures MUST be coded with errbuf and retcode OUT parameters

                which MUST be defined as first parameters of your procedure if you want to
                use the procedure as concurrent request.

                errbuf parameter comes first, retcode comes second, then the rest of your
                parameters.

                 

                Populate retcode with 0 if logic within your procedure completes successful,

                use 2 if the program ran into an exception (either a logic exception or when
                an unexpected error should occurr) and use 1 for retcode, if your logic
                should indicate a warning such as "no data found for processing" or something

                like this.

                 

                 

                When defining concurrent program in sysadmin responsibility do NOT define
                parameters for errbuf and retcode, only for the rest of your parameters.

                That's all - in short.

                 

                Regards