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

Line 34: fnd_file.put_line(fnd_file.output,'Exception in get_lookup_value SQL-ERRM :'||SQLERRM);

30: RETURN NULL;
31: WHEN NO_DATA_FOUND THEN
32: RETURN NULL;
33: WHEN OTHERS THEN
34: fnd_file.put_line(fnd_file.output,'Exception in get_lookup_value SQL-ERRM :'||SQLERRM);
35:
36: END get_lookup_value;
37:
38: -- ==============================================================================

Line 54: fnd_file.put_line(fnd_file.output,'Exception in clean_XML SQL-ERRM :'||SQLERRM);

50: l_string := REPLACE(l_string, '"', '&'||'quot;');
51: RETURN l_string;
52: EXCEPTION
53: WHEN others THEN
54: fnd_file.put_line(fnd_file.output,'Exception in clean_XML SQL-ERRM :'||SQLERRM);
55: RETURN l_string;
56: END clean_XML;
57:
58: -- ==============================================================================

Line 70: fnd_file.put_line(fnd_file.log,'+====write_to_clob==========================================+');

66: l_string VARCHAR2(32767) := NULL;
67: l_string1 VARCHAR2(80) := NULL;
68: BEGIN
69:
70: fnd_file.put_line(fnd_file.log,'+====write_to_clob==========================================+');
71:
72: l_str := ''||EOL;
73: dbms_lob.createtemporary(p_clob, FALSE, DBMS_LOB.CALL);
74: dbms_lob.open(p_clob, DBMS_LOB.LOB_READWRITE);

Line 95: fnd_file.put_line(fnd_file.log,'X====WRITE_to_clob==========================================X');

91: ELSE
92: dbms_lob.writeAppend(p_clob, length(l_str), l_str );
93: END IF;
94:
95: fnd_file.put_line(fnd_file.log,'X====WRITE_to_clob==========================================X');
96:
97: EXCEPTION
98: WHEN others THEN
99: fnd_file.put_line(fnd_file.output,'Exception in write_to_clob SQL-ERRM : '||SQLERRM);

Line 99: fnd_file.put_line(fnd_file.output,'Exception in write_to_clob SQL-ERRM : '||SQLERRM);

95: fnd_file.put_line(fnd_file.log,'X====WRITE_to_clob==========================================X');
96:
97: EXCEPTION
98: WHEN others THEN
99: fnd_file.put_line(fnd_file.output,'Exception in write_to_clob SQL-ERRM : '||SQLERRM);
100: hr_utility.raise_error;
101: END write_to_clob;
102:
103:

Line 198: fnd_file.put_line(fnd_file.output,'Exception in get_balance_value SQL-ERRM : '||SQLERRM);

194: RETURN l_balance_amount;
195:
196: EXCEPTION
197: WHEN OTHERS THEN
198: fnd_file.put_line(fnd_file.output,'Exception in get_balance_value SQL-ERRM : '||SQLERRM);
199: RAISE;
200: RETURN NULL;
201:
202: END get_balance_value;

Line 429: fnd_file.put_line(fnd_file.output,'Exception in get_payroll_run_details SQL-ERRM : '||SQLERRM);

425: END IF;
426: RETURN 1;
427: EXCEPTION
428: WHEN OTHERS THEN
429: fnd_file.put_line(fnd_file.output,'Exception in get_payroll_run_details SQL-ERRM : '||SQLERRM);
430: RAISE;
431: RETURN 0;
432: END get_payroll_run_details;
433:

Line 709: fnd_file.put_line(fnd_file.output,'Exception in get_retro_details SQL-ERRM : '||SQLERRM);

705:
706: RETURN 1;
707: EXCEPTION
708: WHEN OTHERS THEN
709: fnd_file.put_line(fnd_file.output,'Exception in get_retro_details SQL-ERRM : '||SQLERRM);
710: RAISE;
711: RETURN 0;
712: END get_retro_details;
713:

Line 1794: fnd_file.put_line(fnd_file.output,'Exception in generate SQL-ERRM : '||SQLERRM);

1790:
1791:
1792: EXCEPTION
1793: WHEN OTHERS THEN
1794: fnd_file.put_line(fnd_file.output,'Exception in generate SQL-ERRM : '||SQLERRM);
1795: raise;
1796: END generate;
1797:
1798: -- =============================================================================

Line 2024: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_UNIT_OF_CONTRIBUTION'

2020: CLOSE csr_other_emp_details;
2021: END LOOP Employee;
2022:
2023: /*Display Top headings for employees having single person id */
2024: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_UNIT_OF_CONTRIBUTION'
2025: ,'YEAR'
2026: ,userenv('lang'))||' : '
2027: ||l_seperator||TO_CHAR(l_reporting_end_date,'YYYY'));
2028:

Line 2029: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'

2025: ,'YEAR'
2026: ,userenv('lang'))||' : '
2027: ||l_seperator||TO_CHAR(l_reporting_end_date,'YYYY'));
2028:
2029: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'
2030: ,'WR_EMPLOYER_NAME'
2031: ,userenv('lang'))||' : '
2032: ||l_seperator||REPLACE(p_employer_name,l_seperator,' '));
2033: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'

Line 2033: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'

2029: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'
2030: ,'WR_EMPLOYER_NAME'
2031: ,userenv('lang'))||' : '
2032: ||l_seperator||REPLACE(p_employer_name,l_seperator,' '));
2033: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'
2034: ,'THRESHOLD'
2035: ,userenv('lang'))||' : '
2036: ||l_seperator||REPLACE(p_threshold_limit,l_seperator,' '));
2037: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'

Line 2037: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'

2033: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'
2034: ,'THRESHOLD'
2035: ,userenv('lang'))||' : '
2036: ||l_seperator||REPLACE(p_threshold_limit,l_seperator,' '));
2037: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'
2038: ,'PERCENTAGE'
2039: ,userenv('lang'))||' : '
2040: ||l_seperator||REPLACE(p_percentage,l_seperator,' '));
2041:

Line 2045: fnd_file.put_line(fnd_file.output,' ');

2041:
2042: /*Display only if rows exists */
2043: IF t_single_personid_details.COUNT >0 THEN
2044: /*Display Heading */
2045: fnd_file.put_line(fnd_file.output,' ');
2046:
2047: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'
2048: ,'EMPLOYEE_NUMBER'
2049: ,userenv('lang'))

Line 2047: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'

2043: IF t_single_personid_details.COUNT >0 THEN
2044: /*Display Heading */
2045: fnd_file.put_line(fnd_file.output,' ');
2046:
2047: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'
2048: ,'EMPLOYEE_NUMBER'
2049: ,userenv('lang'))
2050: ||l_seperator||get_lookup_value('NL_FORM_LABELS'
2051: ,'BSN'

Line 2074: fnd_file.put_line(fnd_file.output,t_single_personid_details(i).employee_number||l_seperator

2070: l_tax_total :=0;
2071: /*Display Employee Details */
2072: FOR i IN t_single_personid_details.FIRST..t_single_personid_details.LAST
2073: LOOP
2074: fnd_file.put_line(fnd_file.output,t_single_personid_details(i).employee_number||l_seperator
2075: ||t_single_personid_details(i).sofi_number||l_seperator
2076: ||t_single_personid_details(i).employee_name||l_seperator
2077: ||t_single_personid_details(i).hire_date||l_seperator
2078: ||t_single_personid_details(i).end_date||l_seperator

Line 2085: fnd_file.put_line(fnd_file.output,' ');

2081: l_tax_total := l_tax_total+t_single_personid_details(i).tax;
2082: END LOOP;
2083: /*End of Displaying Details */
2084:
2085: fnd_file.put_line(fnd_file.output,' ');
2086:
2087: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'
2088: ,'TOTAL'
2089: ,userenv('lang'))

Line 2087: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'

2083: /*End of Displaying Details */
2084:
2085: fnd_file.put_line(fnd_file.output,' ');
2086:
2087: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'
2088: ,'TOTAL'
2089: ,userenv('lang'))
2090: ||l_seperator
2091: ||l_seperator

Line 2100: fnd_file.put_line(fnd_file.output,' ');

2096: ||to_char(l_tax_total,l_format));
2097: END IF;
2098:
2099: IF t_multiple_personid_details.COUNT>0 THEN
2100: fnd_file.put_line(fnd_file.output,' ');
2101: /*Display Top headings for employees having multiple person id */
2102: fnd_file.put_line(fnd_file.output,' ');
2103: fnd_message.set_name('PER','HR_51410_WEB_DUP_PERSON_NAME');
2104: fnd_file.put_line(fnd_file.output,fnd_message.get);

Line 2102: fnd_file.put_line(fnd_file.output,' ');

2098:
2099: IF t_multiple_personid_details.COUNT>0 THEN
2100: fnd_file.put_line(fnd_file.output,' ');
2101: /*Display Top headings for employees having multiple person id */
2102: fnd_file.put_line(fnd_file.output,' ');
2103: fnd_message.set_name('PER','HR_51410_WEB_DUP_PERSON_NAME');
2104: fnd_file.put_line(fnd_file.output,fnd_message.get);
2105: fnd_file.put_line(fnd_file.output,' ');
2106: /*Display Heading */

Line 2104: fnd_file.put_line(fnd_file.output,fnd_message.get);

2100: fnd_file.put_line(fnd_file.output,' ');
2101: /*Display Top headings for employees having multiple person id */
2102: fnd_file.put_line(fnd_file.output,' ');
2103: fnd_message.set_name('PER','HR_51410_WEB_DUP_PERSON_NAME');
2104: fnd_file.put_line(fnd_file.output,fnd_message.get);
2105: fnd_file.put_line(fnd_file.output,' ');
2106: /*Display Heading */
2107: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'
2108: ,'BSN'

Line 2105: fnd_file.put_line(fnd_file.output,' ');

2101: /*Display Top headings for employees having multiple person id */
2102: fnd_file.put_line(fnd_file.output,' ');
2103: fnd_message.set_name('PER','HR_51410_WEB_DUP_PERSON_NAME');
2104: fnd_file.put_line(fnd_file.output,fnd_message.get);
2105: fnd_file.put_line(fnd_file.output,' ');
2106: /*Display Heading */
2107: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'
2108: ,'BSN'
2109: ,userenv('lang'))

Line 2107: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'

2103: fnd_message.set_name('PER','HR_51410_WEB_DUP_PERSON_NAME');
2104: fnd_file.put_line(fnd_file.output,fnd_message.get);
2105: fnd_file.put_line(fnd_file.output,' ');
2106: /*Display Heading */
2107: fnd_file.put_line(fnd_file.output,get_lookup_value('NL_FORM_LABELS'
2108: ,'BSN'
2109: ,userenv('lang'))
2110: ||l_seperator||get_lookup_value('NL_FORM_LABELS'
2111: ,'WR_EMPLOYER_NAME'

Line 2132: fnd_file.put_line(fnd_file.output,t_multiple_personid_details(i).sofi_number||l_seperator

2128:
2129: /*Display Employee Details */
2130: FOR i IN t_multiple_personid_details.FIRST..t_multiple_personid_details.LAST
2131: LOOP
2132: fnd_file.put_line(fnd_file.output,t_multiple_personid_details(i).sofi_number||l_seperator
2133: ||t_multiple_personid_details(i).employer_name||l_seperator
2134: ||t_multiple_personid_details(i).employee_number||l_seperator
2135: ||t_multiple_personid_details(i).employee_name||l_seperator
2136: ||t_multiple_personid_details(i).hire_date||l_seperator

Line 2146: fnd_file.put_line(fnd_file.output,SQLERRM);

2142: /*End of Displaying Details */
2143:
2144: EXCEPTION
2145: WHEN OTHERS THEN
2146: fnd_file.put_line(fnd_file.output,SQLERRM);
2147: END get_employee_high_wages;
2148:
2149:
2150: END;