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 276: --hr_utility.trace_on(NULL,'ATS_TAB');

272: /*Make calls to suppoting procedures to form the XML file*/
273:
274: begin
275:
276: --hr_utility.trace_on(NULL,'ATS_TAB');
277: --hr_utility.set_location('inside ATS',10);
278: l_archive_action:=0;
279: l_taxable_income:=0;
280: l_deducted_wage_tax:=0;

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

273:
274: begin
275:
276: --hr_utility.trace_on(NULL,'ATS_TAB');
277: --hr_utility.set_location('inside ATS',10);
278: l_archive_action:=0;
279: l_taxable_income:=0;
280: l_deducted_wage_tax:=0;
281: l_labour_tax_reduction:=0;

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

297: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
298: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
299:
300: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
301: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
302:
303: if p_agg_flag = 'Y' THEN
304: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');
305: else

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

642: --PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW_Basis; --11886537
643: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := floor(l_ZVW_Basis); --11886537
644: vCtr := vCtr + 1;
645:
646: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);
647: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/
648:
649: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ZVW_Cont';
650: --PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW; --11886537

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

643: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := floor(l_ZVW_Basis); --11886537
644: vCtr := vCtr + 1;
645:
646: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);
647: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/
648:
649: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ZVW_Cont';
650: --PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW; --11886537
651: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := ceil(l_ZVW); --11886537

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

650: --PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW; --11886537
651: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := ceil(l_ZVW); --11886537
652: vCtr := vCtr + 1;
653:
654: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);
655: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/
656:
657:
658: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Private_Use_Car';

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

651: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := ceil(l_ZVW); --11886537
652: vCtr := vCtr + 1;
653:
654: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);
655: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/
656:
657:
658: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Private_Use_Car';
659: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_Private_Use_Car;

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

1490: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Applied_LCLD';
1491: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Applied_LCLD;
1492: vCtr := vCtr + 1;
1493:
1494: hr_utility.set_location('Calling bal table',10);
1495:
1496: populate_UserBalVal(info_rec.User_Bal_String,'N');
1497:
1498: --hr_utility.set_location('FIRST-'||vUserBalVal.FIRST||' LAST-'||vUserBalVal.LAST||' COUNT-'||vUserBalVal.COUNT,20);

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

1494: hr_utility.set_location('Calling bal table',10);
1495:
1496: populate_UserBalVal(info_rec.User_Bal_String,'N');
1497:
1498: --hr_utility.set_location('FIRST-'||vUserBalVal.FIRST||' LAST-'||vUserBalVal.LAST||' COUNT-'||vUserBalVal.COUNT,20);
1499:
1500: IF vUserBalVal.COUNT > 0 THEN
1501:
1502: FOR lCtr IN vUserBalVal.FIRST .. vUserBalVal.LAST LOOP

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

1600: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := vUserBalVal(lCtr).TagName;
1601: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := vUserBalVal(lCtr).BalValue;
1602: vCtr := vCtr + 1;
1603:
1604: --hr_utility.set_location('tag name-'||vUserBalVal(lCtr).TagName||' tag value-'||vUserBalVal(lCtr).BalValue,90);
1605:
1606: END LOOP;
1607:
1608: END IF;

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

1900: /*Make calls to suppoting procedures to form the XML file*/
1901:
1902: begin
1903:
1904: --hr_utility.trace_on(NULL,'ATS_TAB');
1905: --hr_utility.set_location('inside ATS',10);
1906: l_archive_action:=0;
1907: l_taxable_income:=0;
1908: l_deducted_wage_tax:=0;

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

1901:
1902: begin
1903:
1904: --hr_utility.trace_on(NULL,'ATS_TAB');
1905: --hr_utility.set_location('inside ATS',10);
1906: l_archive_action:=0;
1907: l_taxable_income:=0;
1908: l_deducted_wage_tax:=0;
1909: l_labour_tax_reduction:=0;

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

1925: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
1926: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
1927:
1928: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
1929: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
1930:
1931: if p_agg_flag = 'Y' THEN
1932: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');
1933: else

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

2270: --PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW_Basis; --11886537
2271: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := floor(l_ZVW_Basis); --11886537
2272: vCtr := vCtr + 1;
2273:
2274: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);
2275: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/
2276:
2277: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ZVW_Cont';
2278: --PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW; --11886537

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

2271: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := floor(l_ZVW_Basis); --11886537
2272: vCtr := vCtr + 1;
2273:
2274: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);
2275: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/
2276:
2277: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ZVW_Cont';
2278: --PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW; --11886537
2279: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := ceil(l_ZVW); --11886537

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

2278: --PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_ZVW; --11886537
2279: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := ceil(l_ZVW); --11886537
2280: vCtr := vCtr + 1;
2281:
2282: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);
2283: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/
2284:
2285:
2286: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Private_Use_Car';

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

2279: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := ceil(l_ZVW); --11886537
2280: vCtr := vCtr + 1;
2281:
2282: /*hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagName,100);
2283: hr_utility.set_location('Tag name: '||PAY_NL_XDO_REPORT.vXMLTable(vCtr-1).TagValue,110);*/
2284:
2285:
2286: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Private_Use_Car';
2287: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_Private_Use_Car;

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

3118: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Applied_LCLD';
3119: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Applied_LCLD;
3120: vCtr := vCtr + 1;
3121:
3122: hr_utility.set_location('Calling bal table',10);
3123:
3124: populate_UserBalVal(info_rec.User_Bal_String,'N');
3125:
3126: --hr_utility.set_location('FIRST-'||vUserBalVal.FIRST||' LAST-'||vUserBalVal.LAST||' COUNT-'||vUserBalVal.COUNT,20);

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

3122: hr_utility.set_location('Calling bal table',10);
3123:
3124: populate_UserBalVal(info_rec.User_Bal_String,'N');
3125:
3126: --hr_utility.set_location('FIRST-'||vUserBalVal.FIRST||' LAST-'||vUserBalVal.LAST||' COUNT-'||vUserBalVal.COUNT,20);
3127:
3128: IF vUserBalVal.COUNT > 0 THEN
3129:
3130: FOR lCtr IN vUserBalVal.FIRST .. vUserBalVal.LAST LOOP

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

3228: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := vUserBalVal(lCtr).TagName;
3229: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := vUserBalVal(lCtr).BalValue;
3230: vCtr := vCtr + 1;
3231:
3232: --hr_utility.set_location('tag name-'||vUserBalVal(lCtr).TagName||' tag value-'||vUserBalVal(lCtr).BalValue,90);
3233:
3234: END LOOP;
3235:
3236: END IF;

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

3314:
3315: l_start := 1;
3316: lCtr := 0;
3317:
3318: hr_utility.set_location('Entered populate_UserBalVal',10);
3319:
3320: 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
3321:
3322: IF p_agg_flag='N' THEN

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

3320: 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
3321:
3322: IF p_agg_flag='N' THEN
3323:
3324: --hr_utility.set_location('Agg flag N in function',20);
3325: --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);
3326:
3327: FOR lCtr IN PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST .. PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST LOOP
3328:

Line 3325: --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);

3321:
3322: IF p_agg_flag='N' THEN
3323:
3324: --hr_utility.set_location('Agg flag N in function',20);
3325: --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);
3326:
3327: FOR lCtr IN PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST .. PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST LOOP
3328:
3329: l_end := instr(p_User_Bal_String,'|',l_start,1);

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

3330:
3331: vUserBalVal(lCtr).BalValue := fnd_number.canonical_to_number(substr(p_User_Bal_String,l_start,l_end-l_start));
3332: vUserBalVal(lCtr).TagName := PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable(lCtr).TagName;
3333:
3334: hr_utility.set_location('tag-'||vUserBalVal(lCtr).TagName,13);
3335: hr_utility.set_location('bal-'||vUserBalVal(lCtr).BalValue,23);
3336:
3337: l_start := l_end + 1;
3338:

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

3331: vUserBalVal(lCtr).BalValue := fnd_number.canonical_to_number(substr(p_User_Bal_String,l_start,l_end-l_start));
3332: vUserBalVal(lCtr).TagName := PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable(lCtr).TagName;
3333:
3334: hr_utility.set_location('tag-'||vUserBalVal(lCtr).TagName,13);
3335: hr_utility.set_location('bal-'||vUserBalVal(lCtr).BalValue,23);
3336:
3337: l_start := l_end + 1;
3338:
3339: END LOOP;