Steps to Turn ON Logging for XMLP Reports for Debugging

Steps to Turn ON Logging for XMLP Reports for Debugging.

Create a file named xdodebug.cfg and place it under [PS_HOME]\JRE\Lib] folder.The file should include the following line:

Under Windows
LogLevel=STATEMENT

LogDir=c:\temp

Under Unix
The file Should look like this (point to an appropriate temporary directory under the Unix box)
LogLevel=STATEMENT

LogDir=/ds3/ps/dssgrp/t849xr21/appserv/

Remove xdodebug.cfg when finished replicating the issue.

The logging is specifically useful for troubleshooting the Template(RTF/PDF) or Data File(XML file) specific issues. The generated XML file is the actual data file which is run from the MS Word Design Helper Preview mode to narrow down the issue.

Online Checks - using the GetNextNumberWithGapsCommit() function

Here is a good sample for using the GetNextNumberWithGapsCommit() function for online paycheck numbers.

First on a RowInit() lets gray the field or make it display only on the page.

If %Component = Component.PAY_OL_SHEET Then
Gray(PAY_LINE.PAYCHECK_NBR);
End-If;

Next, lets get the Max() paycheck number from pay_check currently within Production and insert that number into a custom record.

SQLExec("SELECT MAX(A.PAYCHECK_NBR) FROM PS_PAY_CHECK A WHERE (A.FORM_ID = '******' OR A.FORM_ID = ' ')", &MAX_PAYCHECK_NBR);


INSERT INTO PS_ASU_HR_TRAN_NBR
(ASU_HR_APP_CODE, TRANSACTION_NBR)
VALUES
(
'OLCK' -- A place holder value if you plan to use other types of transactions
,'123456') -- This will be the max number currently within ps_pay_check


SavePreChange code

If %Component = Component.PAY_OL_SHEET Then
If None(PAY_LINE.PAYCHECK_NBR) Or
%Mode = "A" Then
&next_pay_check_nbr = GetNextNumberWithGapsCommit(ASU_HR_TRAN_NBR.TRANSACTION_NBR, 999999999999999, 1, "WHERE ASU_HR_APP_CODE = 'OLCK'");
PAY_LINE.PAYCHECK_NBR.Value = &next_pay_check_nbr;
End-If;
End-If;