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 1025: fnd_file.put_line(fnd_file.log,'Creating the XML...');

1021: --
1022: gXMLTable.DELETE;
1023: l_count := 1;
1024: --
1025: fnd_file.put_line(fnd_file.log,'Creating the XML...');
1026: dbms_lob.createtemporary(p_xml_data,FALSE,DBMS_LOB.CALL);
1027: dbms_lob.open(p_xml_data,dbms_lob.lob_readwrite);
1028: --
1029: l_tag := '';

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

1029: l_tag := '';
1030: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1031: l_tag := '';
1032: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1033: fnd_file.put_line(fnd_file.log,'Started...');
1034: --
1035: --
1036: fnd_file.put_line(fnd_file.log,'Creating XML for Employee Personal Details.');
1037:

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

1032: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1033: fnd_file.put_line(fnd_file.log,'Started...');
1034: --
1035: --
1036: fnd_file.put_line(fnd_file.log,'Creating XML for Employee Personal Details.');
1037:
1038: --Bug 6772976 starts
1039: OPEN c_final_report_info(p_bus_grp_id);
1040: FETCH c_final_report_info into l_final_report_info;

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

1130: -- For getting the Designation
1131: l_tag := getTag('c_designation', c_rec_designation.designation);
1132: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1133: END LOOP;
1134: fnd_file.put_line(fnd_file.log,'Created Employee Personal Details.');
1135: --
1136: l_total_earnings := 0;
1137: l_total_deductions := 0;
1138: l_total_employer_charges := 0;

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

1140: l_total_other_deductions := 0;
1141: l_total_advance := 0; -- Added for the bug fix 6660147
1142: l_total_fringe_benefit := 0; -- Added for the bug fix 6660147
1143: --
1144: fnd_file.put_line(fnd_file.log,'Creating XML for Regular Pay and Other Deductions.');
1145: --
1146: -- Following steps are carried out
1147: -- 1. The Classification of the element is checked
1148: -- 2. As per the classification, relevant colums are populated

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

1304: END IF;
1305: --Bugfix 66660147 end
1306: --
1307: --
1308: fnd_file.put_line(fnd_file.log,'Created Regular Pay and Other Deductions.');
1309: --
1310: --
1311: fnd_file.put_line(fnd_file.log,'Creating XML for Loan Recovery.');
1312: --

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

1307: --
1308: fnd_file.put_line(fnd_file.log,'Created Regular Pay and Other Deductions.');
1309: --
1310: --
1311: fnd_file.put_line(fnd_file.log,'Creating XML for Loan Recovery.');
1312: --
1313: l_total_loan_recovery := 0;
1314: l_count := 1;
1315: --

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

1361: ,gXMLTable
1362: ,1);
1363: END IF;
1364: --
1365: fnd_file.put_line(fnd_file.log,'Created Loan Recovery.');
1366: --
1367: fnd_file.put_line(fnd_file.log,'Creating XML for Leave Encashment.');
1368: --
1369: l_count := 1;

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

1363: END IF;
1364: --
1365: fnd_file.put_line(fnd_file.log,'Created Loan Recovery.');
1366: --
1367: fnd_file.put_line(fnd_file.log,'Creating XML for Leave Encashment.');
1368: --
1369: l_count := 1;
1370: l_leave_encashed_flag := 0; /* variable to check if No data Found is to be printed */
1371: --

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

1418: ,gXMLTable
1419: ,1);
1420: END IF;
1421: --
1422: fnd_file.put_line(fnd_file.log,'Created Leave Encashment.');
1423: --
1424: fnd_file.put_line(fnd_file.log,'Creating XML for Gratuity Payment.');
1425: --
1426: l_count := 1;

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

1420: END IF;
1421: --
1422: fnd_file.put_line(fnd_file.log,'Created Leave Encashment.');
1423: --
1424: fnd_file.put_line(fnd_file.log,'Creating XML for Gratuity Payment.');
1425: --
1426: l_count := 1;
1427: l_gratuity_paid_flag := 0; /* variable to check if No data Found is to be printed */
1428: l_grat_elig_sal := 0;

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

1495: ,gXMLTable
1496: ,l_count);
1497: END IF;
1498: --
1499: fnd_file.put_line(fnd_file.log,'Created Gratuity Payment.');
1500: --
1501: fnd_file.put_line(fnd_file.log,'Creating XML for Dues to Employee.');
1502: --
1503: l_total_paid := 0;

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

1497: END IF;
1498: --
1499: fnd_file.put_line(fnd_file.log,'Created Gratuity Payment.');
1500: --
1501: fnd_file.put_line(fnd_file.log,'Creating XML for Dues to Employee.');
1502: --
1503: l_total_paid := 0;
1504: l_total_taxable := 0;
1505: l_total_exempted := 0 ;

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

1688: ,l_total_exempted));
1689: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1690: END IF;
1691: --
1692: fnd_file.put_line(fnd_file.log,'Created Dues to Employee.');
1693: --
1694: fnd_file.put_line(fnd_file.log,'Creating XML for Net Amount Payables.');
1695: l_gross_earnings := 0;
1696: --

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

1690: END IF;
1691: --
1692: fnd_file.put_line(fnd_file.log,'Created Dues to Employee.');
1693: --
1694: fnd_file.put_line(fnd_file.log,'Creating XML for Net Amount Payables.');
1695: l_gross_earnings := 0;
1696: --
1697: -- Following steps are carried out
1698: -- 1. Net Amount is found through the Balance _ASG_RUN values

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

1744: l_tag := getTag('c_gross_earnings', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1745: ,l_gross_earnings));
1746: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1747: --
1748: fnd_file.put_line(fnd_file.log,'Created Net Amount Payables.');
1749: --
1750: fnd_file.put_line(fnd_file.log,'Creating XML for Payment Details.');
1751: --
1752: l_count := 1;

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

1746: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1747: --
1748: fnd_file.put_line(fnd_file.log,'Created Net Amount Payables.');
1749: --
1750: fnd_file.put_line(fnd_file.log,'Creating XML for Payment Details.');
1751: --
1752: l_count := 1;
1753: l_payment_flag := 0;
1754: --

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

1804: ,gXMLTable
1805: ,1);
1806: END IF;
1807: --
1808: fnd_file.put_line(fnd_file.log,'Created Payment Details.');
1809: --
1810: l_tag := '';
1811: --
1812: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);