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

Line 1122: fnd_file.put_line(fnd_file.log,'Creating the XML...');

1118: --
1119: gXMLTable.DELETE;
1120: l_count := 1;
1121: --
1122: fnd_file.put_line(fnd_file.log,'Creating the XML...');
1123: dbms_lob.createtemporary(p_xml_data,FALSE,DBMS_LOB.CALL);
1124: dbms_lob.open(p_xml_data,dbms_lob.lob_readwrite);
1125: --
1126: l_tag := '';

Line 1130: fnd_file.put_line(fnd_file.log,'Started...');

1126: l_tag := '';
1127: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1128: l_tag := '';
1129: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1130: fnd_file.put_line(fnd_file.log,'Started...');
1131: --
1132: --
1133: fnd_file.put_line(fnd_file.log,'Creating XML for Employee Personal Details.');
1134:

Line 1133: fnd_file.put_line(fnd_file.log,'Creating XML for Employee Personal Details.');

1129: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1130: fnd_file.put_line(fnd_file.log,'Started...');
1131: --
1132: --
1133: fnd_file.put_line(fnd_file.log,'Creating XML for Employee Personal Details.');
1134:
1135: --Bug 6772976 starts
1136: OPEN c_final_report_info(p_bus_grp_id);
1137: FETCH c_final_report_info into l_final_report_info;

Line 1240: fnd_file.put_line(fnd_file.log,'Created Employee Personal Details.');

1236: -- For getting the Designation
1237: l_tag := getTag('c_designation', c_rec_designation.designation);
1238: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1239: END LOOP;
1240: fnd_file.put_line(fnd_file.log,'Created Employee Personal Details.');
1241: --
1242: l_total_earnings := 0;
1243: l_total_deductions := 0;
1244: l_total_employer_charges := 0;

Line 1250: fnd_file.put_line(fnd_file.log,'Creating XML for Regular Pay and Other Deductions.');

1246: l_total_other_deductions := 0;
1247: l_total_advance := 0; -- Added for the bug fix 6660147
1248: l_total_fringe_benefit := 0; -- Added for the bug fix 6660147
1249: --
1250: fnd_file.put_line(fnd_file.log,'Creating XML for Regular Pay and Other Deductions.');
1251: --
1252: -- Following steps are carried out
1253: -- 1. The Classification of the element is checked
1254: -- 2. As per the classification, relevant colums are populated

Line 1432: fnd_file.put_line(fnd_file.log,'Created Regular Pay and Other Deductions.');

1428: END IF;
1429: --Bugfix 66660147 end
1430: --
1431: --
1432: fnd_file.put_line(fnd_file.log,'Created Regular Pay and Other Deductions.');
1433: --
1434: --
1435: fnd_file.put_line(fnd_file.log,'Creating XML for Loan Recovery.');
1436: --

Line 1435: fnd_file.put_line(fnd_file.log,'Creating XML for Loan Recovery.');

1431: --
1432: fnd_file.put_line(fnd_file.log,'Created Regular Pay and Other Deductions.');
1433: --
1434: --
1435: fnd_file.put_line(fnd_file.log,'Creating XML for Loan Recovery.');
1436: --
1437: l_total_loan_recovery := 0;
1438: l_count := 1;
1439: --

Line 1489: fnd_file.put_line(fnd_file.log,'Created Loan Recovery.');

1485: ,gXMLTable
1486: ,1);
1487: END IF;
1488: --
1489: fnd_file.put_line(fnd_file.log,'Created Loan Recovery.');
1490: --
1491: fnd_file.put_line(fnd_file.log,'Creating XML for Leave Encashment.');
1492: --
1493: l_count := 1;

Line 1491: fnd_file.put_line(fnd_file.log,'Creating XML for Leave Encashment.');

1487: END IF;
1488: --
1489: fnd_file.put_line(fnd_file.log,'Created Loan Recovery.');
1490: --
1491: fnd_file.put_line(fnd_file.log,'Creating XML for Leave Encashment.');
1492: --
1493: l_count := 1;
1494: l_leave_encashed_flag := 0; /* variable to check if No data Found is to be printed */
1495: --

Line 1546: fnd_file.put_line(fnd_file.log,'Created Leave Encashment.');

1542: ,gXMLTable
1543: ,1);
1544: END IF;
1545: --
1546: fnd_file.put_line(fnd_file.log,'Created Leave Encashment.');
1547: --
1548: fnd_file.put_line(fnd_file.log,'Creating XML for Gratuity Payment.');
1549: --
1550: l_count := 1;

Line 1548: fnd_file.put_line(fnd_file.log,'Creating XML for Gratuity Payment.');

1544: END IF;
1545: --
1546: fnd_file.put_line(fnd_file.log,'Created Leave Encashment.');
1547: --
1548: fnd_file.put_line(fnd_file.log,'Creating XML for Gratuity Payment.');
1549: --
1550: l_count := 1;
1551: l_gratuity_paid_flag := 0; /* variable to check if No data Found is to be printed */
1552: l_grat_elig_sal := 0;

Line 1623: fnd_file.put_line(fnd_file.log,'Created Gratuity Payment.');

1619: ,gXMLTable
1620: ,l_count);
1621: END IF;
1622: --
1623: fnd_file.put_line(fnd_file.log,'Created Gratuity Payment.');
1624: --
1625: fnd_file.put_line(fnd_file.log,'Creating XML for Dues to Employee.');
1626: --
1627: l_total_paid := 0;

Line 1625: fnd_file.put_line(fnd_file.log,'Creating XML for Dues to Employee.');

1621: END IF;
1622: --
1623: fnd_file.put_line(fnd_file.log,'Created Gratuity Payment.');
1624: --
1625: fnd_file.put_line(fnd_file.log,'Creating XML for Dues to Employee.');
1626: --
1627: l_total_paid := 0;
1628: l_total_taxable := 0;
1629: l_total_exempted := 0 ;

Line 1821: fnd_file.put_line(fnd_file.log,'Created Dues to Employee.');

1817: ,l_total_exempted));
1818: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1819: END IF;
1820: --
1821: fnd_file.put_line(fnd_file.log,'Created Dues to Employee.');
1822: --
1823: fnd_file.put_line(fnd_file.log,'Creating XML for Net Amount Payables.');
1824: l_gross_earnings := 0;
1825: --

Line 1823: fnd_file.put_line(fnd_file.log,'Creating XML for Net Amount Payables.');

1819: END IF;
1820: --
1821: fnd_file.put_line(fnd_file.log,'Created Dues to Employee.');
1822: --
1823: fnd_file.put_line(fnd_file.log,'Creating XML for Net Amount Payables.');
1824: l_gross_earnings := 0;
1825: --
1826: -- Following steps are carried out
1827: -- 1. Net Amount is found through the Balance _ASG_RUN values

Line 1877: fnd_file.put_line(fnd_file.log,'Created Net Amount Payables.');

1873: l_tag := getTag('c_gross_earnings', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1874: ,l_gross_earnings));
1875: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1876: --
1877: fnd_file.put_line(fnd_file.log,'Created Net Amount Payables.');
1878: --
1879: fnd_file.put_line(fnd_file.log,'Creating XML for Payment Details.');
1880: --
1881: l_count := 1;

Line 1879: fnd_file.put_line(fnd_file.log,'Creating XML for Payment Details.');

1875: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1876: --
1877: fnd_file.put_line(fnd_file.log,'Created Net Amount Payables.');
1878: --
1879: fnd_file.put_line(fnd_file.log,'Creating XML for Payment Details.');
1880: --
1881: l_count := 1;
1882: l_payment_flag := 0;
1883: --

Line 1937: fnd_file.put_line(fnd_file.log,'Created Payment Details.');

1933: ,gXMLTable
1934: ,1);
1935: END IF;
1936: --
1937: fnd_file.put_line(fnd_file.log,'Created Payment Details.');
1938: --
1939: l_tag := '';
1940: --
1941: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);