eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_ATS_REPORT dependencies on HR_UTILITY

Line 260: --hr_utility.trace_on(NULL,'ATS_TAB');

256: /*Make calls to suppoting procedures to form the XML file*/
257:
258: begin
259:
260: --hr_utility.trace_on(NULL,'ATS_TAB');
261: --hr_utility.set_location('inside ATS',10);
262: l_archive_action:=0;
263: l_taxable_income:=0;
264: l_deducted_wage_tax:=0;

Line 261: --hr_utility.set_location('inside ATS',10);

257:
258: begin
259:
260: --hr_utility.trace_on(NULL,'ATS_TAB');
261: --hr_utility.set_location('inside ATS',10);
262: l_archive_action:=0;
263: l_taxable_income:=0;
264: l_deducted_wage_tax:=0;
265: l_labour_tax_reduction:=0;

Line 285: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);

281: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
282: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
283:
284: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
285: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
286:
287: if p_agg_flag = 'Y' THEN
288: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');
289: else

Line 626: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);

622: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Wage_for_ZVW';
623: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW_Basis;
624: vCtr := vCtr + 1;
625:
626: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);
627: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/
628:
629: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ZVW_Cont';
630: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW;

Line 627: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/

623: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW_Basis;
624: vCtr := vCtr + 1;
625:
626: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);
627: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/
628:
629: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ZVW_Cont';
630: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW;
631: vCtr := vCtr + 1;

Line 633: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);

629: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ZVW_Cont';
630: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW;
631: vCtr := vCtr + 1;
632:
633: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);
634: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/
635:
636:
637: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Private_Use_Car';

Line 634: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/

630: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW;
631: vCtr := vCtr + 1;
632:
633: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);
634: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/
635:
636:
637: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Private_Use_Car';
638: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_Private_Use_Car;

Line 1468: hr_utility.set_location('Calling bal table',10);

1464: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Applied_LCLD';
1465: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Applied_LCLD;
1466: vCtr := vCtr + 1;
1467:
1468: hr_utility.set_location('Calling bal table',10);
1469:
1470: populate_UserBalVal(info_rec.User_Bal_String,'N');
1471:
1472: --hr_utility.set_location('FIRST-'||vUserBalVal.FIRST||' LAST-'||vUserBalVal.LAST||' COUNT-'||vUserBalVal.COUNT,20);

Line 1472: --hr_utility.set_location('FIRST-'||vUserBalVal.FIRST||' LAST-'||vUserBalVal.LAST||' COUNT-'||vUserBalVal.COUNT,20);

1468: hr_utility.set_location('Calling bal table',10);
1469:
1470: populate_UserBalVal(info_rec.User_Bal_String,'N');
1471:
1472: --hr_utility.set_location('FIRST-'||vUserBalVal.FIRST||' LAST-'||vUserBalVal.LAST||' COUNT-'||vUserBalVal.COUNT,20);
1473:
1474: IF vUserBalVal.COUNT > 0 THEN
1475:
1476: FOR lCtr IN vUserBalVal.FIRST .. vUserBalVal.LAST LOOP

Line 1573: --hr_utility.set_location('tag name-'||vUserBalVal(lCtr).TagName||' tag value-'||vUserBalVal(lCtr).BalValue,90);

1569: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := vUserBalVal(lCtr).TagName;
1570: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := vUserBalVal(lCtr).BalValue;
1571: vCtr := vCtr + 1;
1572:
1573: --hr_utility.set_location('tag name-'||vUserBalVal(lCtr).TagName||' tag value-'||vUserBalVal(lCtr).BalValue,90);
1574:
1575: END LOOP;
1576:
1577: END IF;

Line 1857: --hr_utility.trace_on(NULL,'ATS_TAB');

1853: /*Make calls to suppoting procedures to form the XML file*/
1854:
1855: begin
1856:
1857: --hr_utility.trace_on(NULL,'ATS_TAB');
1858: --hr_utility.set_location('inside ATS',10);
1859: l_archive_action:=0;
1860: l_taxable_income:=0;
1861: l_deducted_wage_tax:=0;

Line 1858: --hr_utility.set_location('inside ATS',10);

1854:
1855: begin
1856:
1857: --hr_utility.trace_on(NULL,'ATS_TAB');
1858: --hr_utility.set_location('inside ATS',10);
1859: l_archive_action:=0;
1860: l_taxable_income:=0;
1861: l_deducted_wage_tax:=0;
1862: l_labour_tax_reduction:=0;

Line 1882: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);

1878: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
1879: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
1880:
1881: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
1882: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
1883:
1884: if p_agg_flag = 'Y' THEN
1885: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');
1886: else

Line 2223: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);

2219: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Wage_for_ZVW';
2220: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW_Basis;
2221: vCtr := vCtr + 1;
2222:
2223: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);
2224: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/
2225:
2226: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ZVW_Cont';
2227: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW;

Line 2224: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/

2220: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW_Basis;
2221: vCtr := vCtr + 1;
2222:
2223: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);
2224: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/
2225:
2226: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ZVW_Cont';
2227: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW;
2228: vCtr := vCtr + 1;

Line 2230: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);

2226: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ZVW_Cont';
2227: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW;
2228: vCtr := vCtr + 1;
2229:
2230: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);
2231: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/
2232:
2233:
2234: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Private_Use_Car';

Line 2231: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/

2227: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW;
2228: vCtr := vCtr + 1;
2229:
2230: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);
2231: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/
2232:
2233:
2234: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Private_Use_Car';
2235: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_Private_Use_Car;

Line 3065: hr_utility.set_location('Calling bal table',10);

3061: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Applied_LCLD';
3062: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Applied_LCLD;
3063: vCtr := vCtr + 1;
3064:
3065: hr_utility.set_location('Calling bal table',10);
3066:
3067: populate_UserBalVal(info_rec.User_Bal_String,'N');
3068:
3069: --hr_utility.set_location('FIRST-'||vUserBalVal.FIRST||' LAST-'||vUserBalVal.LAST||' COUNT-'||vUserBalVal.COUNT,20);

Line 3069: --hr_utility.set_location('FIRST-'||vUserBalVal.FIRST||' LAST-'||vUserBalVal.LAST||' COUNT-'||vUserBalVal.COUNT,20);

3065: hr_utility.set_location('Calling bal table',10);
3066:
3067: populate_UserBalVal(info_rec.User_Bal_String,'N');
3068:
3069: --hr_utility.set_location('FIRST-'||vUserBalVal.FIRST||' LAST-'||vUserBalVal.LAST||' COUNT-'||vUserBalVal.COUNT,20);
3070:
3071: IF vUserBalVal.COUNT > 0 THEN
3072:
3073: FOR lCtr IN vUserBalVal.FIRST .. vUserBalVal.LAST LOOP

Line 3170: --hr_utility.set_location('tag name-'||vUserBalVal(lCtr).TagName||' tag value-'||vUserBalVal(lCtr).BalValue,90);

3166: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := vUserBalVal(lCtr).TagName;
3167: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := vUserBalVal(lCtr).BalValue;
3168: vCtr := vCtr + 1;
3169:
3170: --hr_utility.set_location('tag name-'||vUserBalVal(lCtr).TagName||' tag value-'||vUserBalVal(lCtr).BalValue,90);
3171:
3172: END LOOP;
3173:
3174: END IF;

Line 3256: hr_utility.set_location('Entered populate_UserBalVal',10);

3252:
3253: l_start := 1;
3254: lCtr := 0;
3255:
3256: hr_utility.set_location('Entered populate_UserBalVal',10);
3257:
3258: IF PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.count > 0 AND instr(p_User_Bal_String,'|',1,PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.count)=length(p_User_Bal_String) THEN
3259:
3260: IF p_agg_flag='N' THEN

Line 3262: --hr_utility.set_location('Agg flag N in function',20);

3258: IF PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.count > 0 AND instr(p_User_Bal_String,'|',1,PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.count)=length(p_User_Bal_String) THEN
3259:
3260: IF p_agg_flag='N' THEN
3261:
3262: --hr_utility.set_location('Agg flag N in function',20);
3263: --hr_utility.set_location('User table first-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST||' last-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST||' count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,20);
3264:
3265: FOR lCtr IN PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST .. PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST LOOP
3266:

Line 3263: --hr_utility.set_location('User table first-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST||' last-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST||' count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,20);

3259:
3260: IF p_agg_flag='N' THEN
3261:
3262: --hr_utility.set_location('Agg flag N in function',20);
3263: --hr_utility.set_location('User table first-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST||' last-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST||' count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,20);
3264:
3265: FOR lCtr IN PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST .. PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST LOOP
3266:
3267: l_end := instr(p_User_Bal_String,'|',l_start,1);

Line 3272: hr_utility.set_location('tag-'||vUserBalVal(lCtr).TagName,13);

3268:
3269: vUserBalVal(lCtr).BalValue := fnd_number.canonical_to_number(substr(p_User_Bal_String,l_start,l_end-l_start));
3270: vUserBalVal(lCtr).TagName := PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable(lCtr).TagName;
3271:
3272: hr_utility.set_location('tag-'||vUserBalVal(lCtr).TagName,13);
3273: hr_utility.set_location('bal-'||vUserBalVal(lCtr).BalValue,23);
3274:
3275: l_start := l_end + 1;
3276:

Line 3273: hr_utility.set_location('bal-'||vUserBalVal(lCtr).BalValue,23);

3269: vUserBalVal(lCtr).BalValue := fnd_number.canonical_to_number(substr(p_User_Bal_String,l_start,l_end-l_start));
3270: vUserBalVal(lCtr).TagName := PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable(lCtr).TagName;
3271:
3272: hr_utility.set_location('tag-'||vUserBalVal(lCtr).TagName,13);
3273: hr_utility.set_location('bal-'||vUserBalVal(lCtr).BalValue,23);
3274:
3275: l_start := l_end + 1;
3276:
3277: END LOOP;