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 157: --fnd_file.put_line(fnd_file.log,'1');

153:
154: /* End of Cursors */
155: BEGIN
156:
157: --fnd_file.put_line(fnd_file.log,'1');
158: IF p_payroll_action_id IS NULL THEN
159:
160: BEGIN
161:

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

172: EXCEPTION
173: WHEN others THEN
174: NULL;
175: END ;
176: --fnd_file.put_line(fnd_file.log,'2');
177: ELSE
178:
179: l_payroll_action_id :=p_payroll_action_id;
180: --fnd_file.put_line(fnd_file.log,'3');

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

176: --fnd_file.put_line(fnd_file.log,'2');
177: ELSE
178:
179: l_payroll_action_id :=p_payroll_action_id;
180: --fnd_file.put_line(fnd_file.log,'3');
181: END IF;
182:
183: hr_utility.set_location('Entered Procedure GETDATA',10);
184:

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

184:
185: /* Pick up the data related to Record 1000*/
186: FOR rg_csr_1000 IN csr_1000 (l_payroll_action_id)
187: LOOP
188: --fnd_file.put_line(fnd_file.log,'4');
189:
190: gtagdata(l_counter).TagName := 'REC_1000';
191: gtagdata(l_counter).TagValue := 'REC_1000';
192: l_counter := l_counter + 1;

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

281: OPEN csr_2001(l_payroll_action_id);
282: FETCH csr_2001 INTO rg_csr_2001;
283: CLOSE csr_2001;
284:
285: --fnd_file.put_line(fnd_file.log,'5');
286:
287: gtagdata(l_counter).TagName := 'REC_2001';
288: gtagdata(l_counter).TagValue := 'REC_2001';
289: l_counter := l_counter + 1;

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

317: gtagdata(l_counter).TagName := 'RT2001_06';
318: gtagdata(l_counter).TagValue := rg_csr_2001.action_information6;
319: l_counter := l_counter + 1;
320:
321: fnd_file.put_line(fnd_file.log,'Company Terminating value : '||rg_csr_2001.action_information5);
322: if(rg_csr_2001.action_information5 IS NULL) then
323: -- Record 2101
324: FOR rg_csr_2101 IN csr_2101(l_payroll_action_id)
325: LOOP

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

323: -- Record 2101
324: FOR rg_csr_2101 IN csr_2101(l_payroll_action_id)
325: LOOP
326:
327: --fnd_file.put_line(fnd_file.log,'6');
328:
329: gtagdata(l_counter).TagName := 'REC_2101';
330: gtagdata(l_counter).TagValue := 'REC_2101';
331: l_counter := l_counter + 1;

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

423: gtagdata(l_counter).TagName := 'REC_5000';
424: gtagdata(l_counter).TagValue := 'REC_5000';
425: l_counter := l_counter + 1;
426:
427: --fnd_file.put_line(fnd_file.log,'7');
428:
429: /* line num */
430: gtagdata(l_counter).TagName := 'RT5000_01';
431: gtagdata(l_counter).TagValue := rg_csr_5000.action_information30;

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

490: -- record 6000
491: FOR rg_csr_6000 IN csr_6000(l_payroll_action_id)
492: LOOP
493:
494: --fnd_file.put_line(fnd_file.log,'8');
495:
496: gtagdata(l_counter).TagName := 'REC_6000';
497: gtagdata(l_counter).TagValue := 'REC_6000';
498: l_counter := l_counter + 1;

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

552: -- record 6001
553: FOR rg_csr_6001 IN csr_6001(l_payroll_action_id, rg_csr_6000.action_information5)
554: LOOP
555:
556: --fnd_file.put_line(fnd_file.log,'9');
557:
558: gtagdata(l_counter).TagName := 'REC_6001';
559: gtagdata(l_counter).TagValue := 'REC_6001';
560: l_counter := l_counter + 1;

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

593: OPEN csr_6002(l_payroll_action_id, rg_csr_6000.action_information5);
594: FETCH csr_6002 INTO rg_csr_6002;
595: CLOSE csr_6002;
596:
597: --fnd_file.put_line(fnd_file.log,'10');
598:
599: gtagdata(l_counter).TagName := 'REC_6002';
600: gtagdata(l_counter).TagValue := 'REC_6002';
601: l_counter := l_counter + 1;

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

629: OPEN csr_6004(l_payroll_action_id, rg_csr_6000.action_information5);
630: FETCH csr_6004 INTO rg_csr_6004;
631: CLOSE csr_6004;
632:
633: --fnd_file.put_line(fnd_file.log,'11');
634:
635: gtagdata(l_counter).TagName := 'REC_6004';
636: gtagdata(l_counter).TagValue := 'REC_6004';
637: l_counter := l_counter + 1;

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

786: l_str5 := '>';
787: l_str6 := '';
788: l_str7 := ' ';
789:
790: --fnd_file.put_line(fnd_file.log,'wc1');
791:
792: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
793: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
794:

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

793: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
794:
795: current_index := 0;
796:
797: --fnd_file.put_line(fnd_file.log,'wc2');
798:
799: IF gtagdata.count > 0 THEN
800:
801: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

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

799: IF gtagdata.count > 0 THEN
800:
801: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
802:
803: --fnd_file.put_line(fnd_file.log,'wc3');
804: FOR table_counter IN gtagdata.FIRST .. gtagdata.LAST LOOP
805:
806: l_str8 := gtagdata(table_counter).TagName;
807: l_str9 := gtagdata(table_counter).TagValue ;

Line 813: --fnd_file.put_line(fnd_file.log,'wc4');

809: IF l_str9 IN ('REC_1000','REC_1000_END','REC_2001','REC_2001_END','REC_2101','REC_2101_END',
810: 'REC_5000','REC_5000_END','REC_6000','REC_6000_END','REC_6001','REC_6001_END','REC_6002','REC_6002_END',
811: 'REC_6004','REC_6004_END','REC_6005','REC_6005_END','REC_9999','REC_9999_END') THEN
812:
813: --fnd_file.put_line(fnd_file.log,'wc4');
814: IF l_str9 IN ('REC_1000','REC_2001','REC_2101','REC_5000','REC_6000','REC_6001','REC_6002','REC_6004','REC_6005','REC_9999') THEN
815: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
816: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
817: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);

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

855: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
856: END IF;
857:
858:
859: --fnd_file.put_line(fnd_file.log,'wc5');
860: p_xfdf_clob := l_xfdf_string;
861:
862: hr_utility.set_location('Leaving WritetoCLOB ',40);
863: