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

Line 138: fnd_file.put_line (

134: BEGIN
135: hr_utility.set_location ('Entered Procedure GETDATA', 10);
136:
137:
138: fnd_file.put_line (
139: fnd_file.LOG, 'payroll_action_id '||l_payroll_action_id
140: );
141:
142: l_payroll_action_id:=get_archive_payroll_action_id( p_payroll_action_id);

Line 139: fnd_file.LOG, 'payroll_action_id '||l_payroll_action_id

135: hr_utility.set_location ('Entered Procedure GETDATA', 10);
136:
137:
138: fnd_file.put_line (
139: fnd_file.LOG, 'payroll_action_id '||l_payroll_action_id
140: );
141:
142: l_payroll_action_id:=get_archive_payroll_action_id( p_payroll_action_id);
143:

Line 144: fnd_file.put_line (

140: );
141:
142: l_payroll_action_id:=get_archive_payroll_action_id( p_payroll_action_id);
143:
144: fnd_file.put_line (
145: fnd_file.LOG, 'payroll_action_id '||l_payroll_action_id
146: );
147:
148: FOR umfr_rep IN csr_umfr_data (l_payroll_action_id)

Line 145: fnd_file.LOG, 'payroll_action_id '||l_payroll_action_id

141:
142: l_payroll_action_id:=get_archive_payroll_action_id( p_payroll_action_id);
143:
144: fnd_file.put_line (
145: fnd_file.LOG, 'payroll_action_id '||l_payroll_action_id
146: );
147:
148: FOR umfr_rep IN csr_umfr_data (l_payroll_action_id)
149: LOOP

Line 150: fnd_file.put_line (

146: );
147:
148: FOR umfr_rep IN csr_umfr_data (l_payroll_action_id)
149: LOOP
150: fnd_file.put_line (
151: fnd_file.LOG, 'TRADE_UNION_NAME1 '||umfr_rep.trade_union_name
152: );
153:
154:

Line 151: fnd_file.LOG, 'TRADE_UNION_NAME1 '||umfr_rep.trade_union_name

147:
148: FOR umfr_rep IN csr_umfr_data (l_payroll_action_id)
149: LOOP
150: fnd_file.put_line (
151: fnd_file.LOG, 'TRADE_UNION_NAME1 '||umfr_rep.trade_union_name
152: );
153:
154:
155: if l_trade_union_name <> umfr_rep.trade_union_name THEN

Line 159: fnd_file.put_line (

155: if l_trade_union_name <> umfr_rep.trade_union_name THEN
156: l_trade_union_name:=umfr_rep.trade_union_name;
157: gplsqltable (l_counter).tagname := 'TRADE_UNION_NAME';
158: gplsqltable (l_counter).tagvalue := pay_fi_general.xml_parser(TO_CHAR (umfr_rep.trade_union_name));
159: fnd_file.put_line (
160: fnd_file.LOG, 'TRADE_UNION_NAME '||gplsqltable (l_counter).tagvalue
161: );
162:
163: l_counter := l_counter

Line 160: fnd_file.LOG, 'TRADE_UNION_NAME '||gplsqltable (l_counter).tagvalue

156: l_trade_union_name:=umfr_rep.trade_union_name;
157: gplsqltable (l_counter).tagname := 'TRADE_UNION_NAME';
158: gplsqltable (l_counter).tagvalue := pay_fi_general.xml_parser(TO_CHAR (umfr_rep.trade_union_name));
159: fnd_file.put_line (
160: fnd_file.LOG, 'TRADE_UNION_NAME '||gplsqltable (l_counter).tagvalue
161: );
162:
163: l_counter := l_counter
164: + 1;

Line 329: -- fnd_file.put_line ( fnd_file.LOG, p_xml );

325: -- TO_CHAR(NVL(L_TOTAL,0) ,'999G999G990D99' );
326: -- TO_CHAR(NVL(FND_NUMBER.canonical_to_number(L_TOTAL),0) ,'999G999G990D99' );
327:
328: writetoclob (p_xml);
329: -- fnd_file.put_line ( fnd_file.LOG, p_xml );
330:
331:
332:
333:

Line 409: fnd_file.put_line ( fnd_file.LOG, gplsqltable.COUNT );

405: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
406: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
407: */
408:
409: fnd_file.put_line ( fnd_file.LOG, gplsqltable.COUNT );
410:
411: FOR table_counter IN gplsqltable.FIRST .. gplsqltable.LAST
412:
413: LOOP

Line 414: fnd_file.put_line ( fnd_file.LOG, l_xfdf_string );

410:
411: FOR table_counter IN gplsqltable.FIRST .. gplsqltable.LAST
412:
413: LOOP
414: fnd_file.put_line ( fnd_file.LOG, l_xfdf_string );
415: l_str8 := gplsqltable (table_counter).tagname;
416: l_str9 := gplsqltable (table_counter).tagvalue;
417: IF l_str8 = 'END' THEN
418: fnd_file.put_line ( fnd_file.LOG, l_xfdf_string );

Line 418: fnd_file.put_line ( fnd_file.LOG, l_xfdf_string );

414: fnd_file.put_line ( fnd_file.LOG, l_xfdf_string );
415: l_str8 := gplsqltable (table_counter).tagname;
416: l_str9 := gplsqltable (table_counter).tagvalue;
417: IF l_str8 = 'END' THEN
418: fnd_file.put_line ( fnd_file.LOG, l_xfdf_string );
419: DBMS_LOB.writeappend (
420: l_xfdf_string,
421: LENGTH (l_str11),
422: l_str11

Line 424: fnd_file.put_line ( fnd_file.LOG, l_xfdf_string );

420: l_xfdf_string,
421: LENGTH (l_str11),
422: l_str11
423: );
424: fnd_file.put_line ( fnd_file.LOG, l_xfdf_string );
425: ELSIF l_str8 = 'LU' THEN
426: fnd_file.put_line ( fnd_file.LOG, l_xfdf_string );
427: IF l_str9 ='START' THEN
428: DBMS_LOB.writeappend (

Line 426: fnd_file.put_line ( fnd_file.LOG, l_xfdf_string );

422: l_str11
423: );
424: fnd_file.put_line ( fnd_file.LOG, l_xfdf_string );
425: ELSIF l_str8 = 'LU' THEN
426: fnd_file.put_line ( fnd_file.LOG, l_xfdf_string );
427: IF l_str9 ='START' THEN
428: DBMS_LOB.writeappend (
429: l_xfdf_string,
430: LENGTH (l_strlustart), l_strlustart );

Line 448: fnd_file.put_line ( fnd_file.LOG, l_xfdf_string );

444:
445:
446: end if;
447:
448: fnd_file.put_line ( fnd_file.LOG, l_xfdf_string );
449: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_total_start), l_total_start);
450: DBMS_LOB.writeappend (
451: l_xfdf_string,
452: LENGTH (l_str9),