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_DK_EINR dependencies on FND_FILE

Line 316: --fnd_file.put_line(fnd_file.log,'1');

312:
313: /* End of Cursors */
314: BEGIN
315:
316: --fnd_file.put_line(fnd_file.log,'1');
317: IF p_payroll_action_id IS NULL THEN
318:
319: BEGIN
320:

Line 335: --fnd_file.put_line(fnd_file.log,'2');

331: EXCEPTION
332: WHEN others THEN
333: NULL;
334: END ;
335: --fnd_file.put_line(fnd_file.log,'2');
336: ELSE
337:
338: l_payroll_action_id :=p_payroll_action_id;
339: --fnd_file.put_line(fnd_file.log,'3');

Line 339: --fnd_file.put_line(fnd_file.log,'3');

335: --fnd_file.put_line(fnd_file.log,'2');
336: ELSE
337:
338: l_payroll_action_id :=p_payroll_action_id;
339: --fnd_file.put_line(fnd_file.log,'3');
340: END IF;
341:
342: hr_utility.set_location('Entered Procedure GETDATA',10);
343:

Line 347: --fnd_file.put_line(fnd_file.log,'4');

343:
344: /* Pick up the data related to Record 1000*/
345: FOR rg_csr_1000 IN csr_1000 (l_payroll_action_id)
346: LOOP
347: --fnd_file.put_line(fnd_file.log,'4');
348:
349: gtagdata(l_counter).TagName := 'REC_1000';
350: gtagdata(l_counter).TagValue := 'REC_1000';
351: l_counter := l_counter + 1;

Line 448: --fnd_file.put_line(fnd_file.log,'5');

444: FETCH csr_2001 INTO rg_csr_2001;
445: CLOSE csr_2001; */
446: FOR rg_csr_2001 IN csr_2001(l_payroll_action_id)
447: LOOP
448: --fnd_file.put_line(fnd_file.log,'5');
449:
450: gtagdata(l_counter).TagName := 'REC_2001';
451: gtagdata(l_counter).TagValue := 'REC_2001';
452: l_counter := l_counter + 1;

Line 485: --fnd_file.put_line(fnd_file.log,'Company Terminating value : '||rg_csr_2001.action_information5);

481: gtagdata(l_counter).TagName := 'RT2001_06';
482: gtagdata(l_counter).TagValue := rg_csr_2001.action_information6;
483: l_counter := l_counter + 1;
484:
485: --fnd_file.put_line(fnd_file.log,'Company Terminating value : '||rg_csr_2001.action_information5);
486: if(rg_csr_2001.action_information5 IS NULL) then
487: -- Record 2101
488: /* bug 10367494 passing p_se_no to rec 2101 */
489: FOR rg_csr_2101 IN csr_2101(l_payroll_action_id,rg_csr_2001.action_information4)

Line 492: --fnd_file.put_line(fnd_file.log,'6');

488: /* bug 10367494 passing p_se_no to rec 2101 */
489: FOR rg_csr_2101 IN csr_2101(l_payroll_action_id,rg_csr_2001.action_information4)
490: LOOP
491:
492: --fnd_file.put_line(fnd_file.log,'6');
493:
494: gtagdata(l_counter).TagName := 'REC_2101';
495: gtagdata(l_counter).TagValue := 'REC_2101';
496: l_counter := l_counter + 1;

Line 600: fnd_file.put_line(fnd_file.log,'csr_5000.person:' || l_flag);

596:
597:
598: -- record 6000
599: l_flag:='N';
600: fnd_file.put_line(fnd_file.log,'csr_5000.person:' || l_flag);
601: fnd_file.put_line(fnd_file.log,'l_flag:' || l_flag);
602: fnd_file.put_line(fnd_file.log,'l_flag_end:' || l_flag_end);
603: /* bug 10367494 passing p_se_no to rec 2101 */
604: FOR rg_csr_6000 IN csr_6000(l_payroll_action_id,rg_csr_5000.action_information25,rg_csr_5000.action_information9,rg_csr_5000.action_information24,rg_csr_5000.action_information8,rg_csr_2001.action_information4) /* 9489806 */

Line 601: fnd_file.put_line(fnd_file.log,'l_flag:' || l_flag);

597:
598: -- record 6000
599: l_flag:='N';
600: fnd_file.put_line(fnd_file.log,'csr_5000.person:' || l_flag);
601: fnd_file.put_line(fnd_file.log,'l_flag:' || l_flag);
602: fnd_file.put_line(fnd_file.log,'l_flag_end:' || l_flag_end);
603: /* bug 10367494 passing p_se_no to rec 2101 */
604: FOR rg_csr_6000 IN csr_6000(l_payroll_action_id,rg_csr_5000.action_information25,rg_csr_5000.action_information9,rg_csr_5000.action_information24,rg_csr_5000.action_information8,rg_csr_2001.action_information4) /* 9489806 */
605: LOOP

Line 602: fnd_file.put_line(fnd_file.log,'l_flag_end:' || l_flag_end);

598: -- record 6000
599: l_flag:='N';
600: fnd_file.put_line(fnd_file.log,'csr_5000.person:' || l_flag);
601: fnd_file.put_line(fnd_file.log,'l_flag:' || l_flag);
602: fnd_file.put_line(fnd_file.log,'l_flag_end:' || l_flag_end);
603: /* bug 10367494 passing p_se_no to rec 2101 */
604: FOR rg_csr_6000 IN csr_6000(l_payroll_action_id,rg_csr_5000.action_information25,rg_csr_5000.action_information9,rg_csr_5000.action_information24,rg_csr_5000.action_information8,rg_csr_2001.action_information4) /* 9489806 */
605: LOOP
606: IF(l_flag='N') THEN

Line 613: --fnd_file.put_line(fnd_file.log,'7');

609: gtagdata(l_counter).TagName := 'REC_5000';
610: gtagdata(l_counter).TagValue := 'REC_5000';
611: l_counter := l_counter + 1;
612:
613: --fnd_file.put_line(fnd_file.log,'7');
614:
615: /* line num */
616: gtagdata(l_counter).TagName := 'RT5000_01';
617: gtagdata(l_counter).TagValue := rg_csr_5000.action_information30;

Line 675: --fnd_file.put_line(fnd_file.log,'8');

671:
672: l_flag:='Y';
673: END IF;
674:
675: --fnd_file.put_line(fnd_file.log,'8');
676:
677: gtagdata(l_counter).TagName := 'REC_6000';
678: gtagdata(l_counter).TagValue := 'REC_6000';
679: l_counter := l_counter + 1;

Line 799: --fnd_file.put_line(fnd_file.log,'9');

795: FOR rg_csr_6001 IN csr_6001(l_payroll_action_id, rg_csr_6000.action_information5,rg_csr_5000.action_information25
796: ,rg_csr_5000.action_information9,rg_csr_5000.action_information24,rg_csr_5000.action_information8) /* 9489806 8847591 */
797: LOOP
798:
799: --fnd_file.put_line(fnd_file.log,'9');
800:
801: gtagdata(l_counter).TagName := 'REC_6001';
802: gtagdata(l_counter).TagValue := 'REC_6001';
803: l_counter := l_counter + 1;

Line 840: --fnd_file.put_line(fnd_file.log,'10');

836: -- Record 6002
837: FOR rg_csr_6002 IN csr_6002(l_payroll_action_id, rg_csr_6000.action_information5,rg_csr_5000.action_information25
838: ,rg_csr_5000.action_information9,rg_csr_5000.action_information24,rg_csr_5000.action_information8) /* 9489806 8847591 */
839: LOOP
840: --fnd_file.put_line(fnd_file.log,'10');
841:
842: gtagdata(l_counter).TagName := 'REC_6002';
843: gtagdata(l_counter).TagValue := 'REC_6002';
844: l_counter := l_counter + 1;

Line 876: --fnd_file.put_line(fnd_file.log,'10');

872:
873: FOR rg_csr_6003 IN csr_6003(l_payroll_action_id, rg_csr_6000.action_information5,rg_csr_5000.action_information25
874: ,rg_csr_5000.action_information9,rg_csr_5000.action_information24,rg_csr_5000.action_information8) /* 9489806 8847591 */
875: LOOP
876: --fnd_file.put_line(fnd_file.log,'10');
877:
878: gtagdata(l_counter).TagName := 'REC_6003';
879: gtagdata(l_counter).TagValue := 'REC_6003';
880: l_counter := l_counter + 1;

Line 913: --fnd_file.put_line(fnd_file.log,'11');

909: -- Record 6004
910: FOR rg_csr_6004 IN csr_6004(l_payroll_action_id, rg_csr_6000.action_information5,rg_csr_5000.action_information25
911: ,rg_csr_5000.action_information9,rg_csr_5000.action_information24,rg_csr_5000.action_information8) /* 9489806 8847591 */
912: LOOP
913: --fnd_file.put_line(fnd_file.log,'11');
914:
915: gtagdata(l_counter).TagName := 'REC_6004';
916: gtagdata(l_counter).TagValue := 'REC_6004';
917: l_counter := l_counter + 1;

Line 1075: --fnd_file.put_line(fnd_file.log,'7');

1071: gtagdata(l_counter).TagName := 'REC_5000';
1072: gtagdata(l_counter).TagValue := 'REC_5000';
1073: l_counter := l_counter + 1;
1074:
1075: --fnd_file.put_line(fnd_file.log,'7');
1076:
1077: /* line num */
1078: l_line_num := l_line_num + 1;
1079: gtagdata(l_counter).TagName := 'RT5000_01';

Line 1142: --fnd_file.put_line(fnd_file.log,'8');

1138: FOR rg_csr_6000 IN csr_6000_corr(l_payroll_action_id, rg_csr_6001_corr.action_information5,rg_csr_5000.action_information25
1139: ,rg_csr_5000.action_information9,rg_csr_5000.action_information24,rg_csr_5000.action_information8,rg_csr_2001.action_information4) /* 8847591 */
1140: LOOP
1141:
1142: --fnd_file.put_line(fnd_file.log,'8');
1143:
1144: gtagdata(l_counter).TagName := 'REC_6000';
1145: gtagdata(l_counter).TagValue := 'REC_6000';
1146: l_counter := l_counter + 1;

Line 1400: --fnd_file.put_line(fnd_file.log,'wc1');

1396: l_str5 := '>';
1397: l_str6 := '';
1398: l_str7 := ' ';
1399:
1400: --fnd_file.put_line(fnd_file.log,'wc1');
1401:
1402: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1403: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1404:

Line 1407: --fnd_file.put_line(fnd_file.log,'wc2');

1403: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1404:
1405: current_index := 0;
1406:
1407: --fnd_file.put_line(fnd_file.log,'wc2');
1408:
1409: IF gtagdata.count > 0 THEN
1410:
1411: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

Line 1413: --fnd_file.put_line(fnd_file.log,'wc3');

1409: IF gtagdata.count > 0 THEN
1410:
1411: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
1412:
1413: --fnd_file.put_line(fnd_file.log,'wc3');
1414: FOR table_counter IN gtagdata.FIRST .. gtagdata.LAST LOOP
1415:
1416: l_str8 := gtagdata(table_counter).TagName;
1417: l_str9 := gtagdata(table_counter).TagValue ;

Line 1423: --fnd_file.put_line(fnd_file.log,'Processing '||l_str9);

1419: IF l_str9 IN ('REC_1000','REC_1000_END','REC_2001','REC_2001_END','REC_2101','REC_2101_END',
1420: 'REC_5000','REC_5000_END','REC_6000','REC_6000_END','REC_8001','REC_8001_END','REC_6001','REC_6001_END',
1421: 'REC_6002','REC_6002_END','REC_6003','REC_6003_END','REC_6004','REC_6004_END','REC_6005','REC_6005_END','REC_6102','REC_6102_END','REC_9999','REC_9999_END') THEN --13463885
1422:
1423: --fnd_file.put_line(fnd_file.log,'Processing '||l_str9);
1424: IF l_str9 IN ('REC_1000','REC_2001','REC_2101','REC_5000','REC_6000','REC_8001','REC_6001','REC_6002','REC_6003','REC_6004','REC_6005','REC_6102','REC_9999') THEN --13463885
1425: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
1426: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
1427: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);

Line 1469: --fnd_file.put_line(fnd_file.log,'wc5');

1465: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
1466: END IF;
1467:
1468:
1469: --fnd_file.put_line(fnd_file.log,'wc5');
1470: p_xfdf_clob := l_xfdf_string;
1471:
1472: hr_utility.set_location('Leaving WritetoCLOB ',40);
1473: