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.
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
why it is so..?
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
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
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
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.