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

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

587: l_slab_6_2 := 300;
588: --
589: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
590:
591: fnd_file.put_line(fnd_file.log,'Creating the XML...');
592:
593: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
594: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
595: --

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

597: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
598: l_tag := '';
599: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
600:
601: fnd_file.put_line(fnd_file.log,'Started...');
602: fnd_file.put_line(fnd_file.log,'Creating XML for PT Form III.');
603:
604: --System Date:
605: l_sys_date_time := to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');

Line 602: fnd_file.put_line(fnd_file.log,'Creating XML for PT Form III.');

598: l_tag := '';
599: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
600:
601: fnd_file.put_line(fnd_file.log,'Started...');
602: fnd_file.put_line(fnd_file.log,'Creating XML for PT Form III.');
603:
604: --System Date:
605: l_sys_date_time := to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
606: l_tag :=pay_in_xml_utils.getTag('c_sys_date_in_hh_mm_ss',l_sys_date_time);

Line 652: fnd_file.put_line(fnd_file.log,'c_rec.org_id '|| c_rec.org_id);

648: IF g_debug THEN
649: pay_in_utils.trace('c_rec.org_id ',c_rec.org_id);
650: END IF;
651:
652: fnd_file.put_line(fnd_file.log,'c_rec.org_id '|| c_rec.org_id);
653:
654: OPEN c_max_pa_action_id(c_rec.org_id
655: ,period_start
656: ,period_end);

Line 750: fnd_file.put_line(fnd_file.log,'l_date: '|| l_date);

746: l_slab_month_count := 0;
747: l_count_200_temp := 0;
748: l_count_300_temp := 0;
749:
750: fnd_file.put_line(fnd_file.log,'l_date: '|| l_date);
751:
752: l_period_month := TO_NUMBER(TO_CHAR(ADD_MONTHS(l_date, -3), 'MM'));
753:
754: IF l_period_month >= 10 THEN

Line 823: fnd_file.put_line(fnd_file.log,'l_slab_month_tag: '|| l_slab_month_tag);

819: IF l_slab <> 6 THEN
820: -- Writing to the report if the slab is not the highest slab
821: -- Highest slab is written to the report once the loop is over since a sum is to be taken for 200 and 300
822: l_slab_month_tag := 'c_month' || l_period_month || '_emp_slab'|| l_slab;
823: fnd_file.put_line(fnd_file.log,'l_slab_month_tag: '|| l_slab_month_tag);
824: l_tag := pay_in_xml_utils.getTag(l_slab_month_tag, l_slab_month_count);
825: dbms_lob.writeAppend(g_xml_data, LENGTH(l_tag), l_tag);
826: END IF;
827:

Line 975: fnd_file.put_line(fnd_file.log,'Org Over');

971:
972: l_tag :='';
973: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
974: pay_in_utils.set_location(g_debug,l_procedure, 140);
975: fnd_file.put_line(fnd_file.log,'Org Over');
976: END LOOP;
977: l_tag :='';
978: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
979: fnd_file.put_line(fnd_file.log,'XML Created.');

Line 979: fnd_file.put_line(fnd_file.log,'XML Created.');

975: fnd_file.put_line(fnd_file.log,'Org Over');
976: END LOOP;
977: l_tag :='';
978: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
979: fnd_file.put_line(fnd_file.log,'XML Created.');
980: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 150);
981:
982: END create_pt_form3_xml;
983:

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

1277:
1278:
1279: pay_in_xml_utils.gXMLTable.DELETE;
1280: --
1281: fnd_file.put_line(fnd_file.log,'Creating the XML...');
1282: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
1283: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
1284: --
1285: l_tag :='';

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

1286: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1287:
1288: l_tag := '';
1289: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1290: fnd_file.put_line(fnd_file.log,'Started...');
1291:
1292: pay_in_utils.set_location(g_debug,l_procedure, 20);
1293: --
1294: fnd_file.put_line(fnd_file.log,'Creating XML for Employer Details.');

Line 1294: fnd_file.put_line(fnd_file.log,'Creating XML for Employer Details.');

1290: fnd_file.put_line(fnd_file.log,'Started...');
1291:
1292: pay_in_utils.set_location(g_debug,l_procedure, 20);
1293: --
1294: fnd_file.put_line(fnd_file.log,'Creating XML for Employer Details.');
1295: l_sys_date_time:=TO_CHAR(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
1296: l_sys_date := TO_CHAR(SYSDATE,'DD-Mon-YYYY');
1297: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
1298: --System Date

Line 1380: fnd_file.put_line(fnd_file.log,'XML Created.');

1376:
1377: l_tag := '';
1378: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1379:
1380: fnd_file.put_line(fnd_file.log,'XML Created.');
1381: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 60);
1382:
1383:
1384: END create_form27A_xml;

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

1546: pay_in_utils.trace('Month ',p_month);
1547: END IF;
1548:
1549: --
1550: fnd_file.put_line(fnd_file.log,'Creating the ECR XML...');
1551: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
1552: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
1553:
1554: l_mon := TO_NUMBER(p_month);

Line 1871: fnd_file.put_line(fnd_file.log,'XML Created.');

1867: pay_in_utils.set_location(g_debug,l_procedure, 140);
1868: l_tag :='';
1869: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1870: pay_in_utils.set_location(g_debug,l_procedure, 150);
1871: fnd_file.put_line(fnd_file.log,'XML Created.');
1872: fnd_file.put_line(fnd_file.log,dbms_lob.substr(g_xml_data));
1873:
1874: EXCEPTION
1875:

Line 1872: fnd_file.put_line(fnd_file.log,dbms_lob.substr(g_xml_data));

1868: l_tag :='';
1869: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1870: pay_in_utils.set_location(g_debug,l_procedure, 150);
1871: fnd_file.put_line(fnd_file.log,'XML Created.');
1872: fnd_file.put_line(fnd_file.log,dbms_lob.substr(g_xml_data));
1873:
1874: EXCEPTION
1875:
1876: WHEN OTHERS THEN

Line 1877: fnd_file.put_line(fnd_file.log,'Exception');

1873:
1874: EXCEPTION
1875:
1876: WHEN OTHERS THEN
1877: fnd_file.put_line(fnd_file.log,'Exception');
1878: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 160);
1879: RAISE;
1880: END create_ecr_xml;
1881: --------------------------------------------------------------------------

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

2300:
2301:
2302: pay_in_xml_utils.gXMLTable.DELETE;
2303: --
2304: fnd_file.put_line(fnd_file.log,'Creating the XML...');
2305: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
2306: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
2307: --
2308: l_tag :='';

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

2309: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
2310:
2311: l_tag := '';
2312: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
2313: fnd_file.put_line(fnd_file.log,'Started...');
2314: --
2315: fnd_file.put_line(fnd_file.log,'Creating XML for Employer Details.');
2316: l_sys_date_time:=TO_CHAR(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
2317: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');

Line 2315: fnd_file.put_line(fnd_file.log,'Creating XML for Employer Details.');

2311: l_tag := '';
2312: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
2313: fnd_file.put_line(fnd_file.log,'Started...');
2314: --
2315: fnd_file.put_line(fnd_file.log,'Creating XML for Employer Details.');
2316: l_sys_date_time:=TO_CHAR(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
2317: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
2318: --System Date
2319: l_tag :=pay_in_xml_utils.getTag('c_current_date_in_hh_mm_ss',l_sys_date_time);

Line 2615: fnd_file.put_line(fnd_file.log,'XML Created.');

2611:
2612: l_tag := '';
2613: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
2614:
2615: fnd_file.put_line(fnd_file.log,'XML Created.');
2616: -- INSERT INTO temp_clob VALUES (g_xml_data);
2617:
2618: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 160);
2619:

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

3354: l_procedure := g_package ||'create_form6a_xml';
3355: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3356:
3357: --
3358: fnd_file.put_line(fnd_file.log,'Creating the XML...');
3359: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
3360: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
3361: --
3362: l_tag :='';

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

3363:
3364: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3365: l_tag := '';
3366: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3367: fnd_file.put_line(fnd_file.log,'Started...');
3368: --
3369: fnd_file.put_line(fnd_file.log,'Creating XML for Employee Personal Details.');
3370: l_sys_date_time:=to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
3371: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');

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

3365: l_tag := '';
3366: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3367: fnd_file.put_line(fnd_file.log,'Started...');
3368: --
3369: fnd_file.put_line(fnd_file.log,'Creating XML for Employee Personal Details.');
3370: l_sys_date_time:=to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
3371: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
3372: --System Date
3373: l_tag :=pay_in_xml_utils.getTag('c_current_date_in_hh_mm_ss',l_sys_date_time);

Line 3745: fnd_file.put_line(fnd_file.log,'XML Created.');

3741: END LOOP;
3742: pay_in_utils.set_location(g_debug,l_procedure, 240);
3743: l_tag := '';
3744: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3745: fnd_file.put_line(fnd_file.log,'XML Created.');
3746:
3747: END create_form6a_xml;
3748:
3749: --------------------------------------------------------------------------

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

3969: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3970:
3971: pay_in_xml_utils.gXMLTable.DELETE;
3972: --
3973: fnd_file.put_line(fnd_file.log,'Creating the XML...');
3974: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
3975: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
3976: --
3977: l_tag :='';

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

3978:
3979: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3980: l_tag := '';
3981: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3982: fnd_file.put_line(fnd_file.log,'Started...');
3983: --
3984: fnd_file.put_line(fnd_file.log,'Creating XML for Employee Personal Details.');
3985: l_sys_date_time:=to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
3986: --System Date

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

3980: l_tag := '';
3981: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3982: fnd_file.put_line(fnd_file.log,'Started...');
3983: --
3984: fnd_file.put_line(fnd_file.log,'Creating XML for Employee Personal Details.');
3985: l_sys_date_time:=to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
3986: --System Date
3987: l_tag :=pay_in_xml_utils.getTag('c_current_date_in_hh_mm_ss',l_sys_date_time);
3988: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 4311: fnd_file.put_line(fnd_file.log,'XML Created.');

4307: --
4308: pay_in_utils.set_location(g_debug,l_procedure, 130);
4309: l_tag := '';
4310: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4311: fnd_file.put_line(fnd_file.log,'XML Created.');
4312: END create_form3a_xml;
4313:
4314:
4315: --------------------------------------------------------------------------

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

4536:
4537: pay_in_xml_utils.gXMLTable.DELETE;
4538:
4539: --
4540: fnd_file.put_line(fnd_file.log,'Creating the XML...');
4541: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
4542: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
4543: --
4544: l_tag :='';

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

4545: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4546:
4547: l_tag := '';
4548: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4549: fnd_file.put_line(fnd_file.log,'Started...');
4550: --
4551:
4552: fnd_file.put_line(fnd_file.log,'Creating XML for Form7.');
4553:

Line 4552: fnd_file.put_line(fnd_file.log,'Creating XML for Form7.');

4548: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4549: fnd_file.put_line(fnd_file.log,'Started...');
4550: --
4551:
4552: fnd_file.put_line(fnd_file.log,'Creating XML for Form7.');
4553:
4554: --System Date
4555: l_sys_date_time := to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
4556: l_tag :=pay_in_xml_utils.getTag('c_current_date_in_hh_mm_ss',l_sys_date_time);

Line 4573: fnd_file.put_line(fnd_file.log,'Start of Exempted Org list.');

4569: p_cp_pf_org_id := p_pf_org_id;
4570: l_bg_id:= fnd_profile.value('PER_BUSINESS_GROUP_ID');
4571:
4572:
4573: fnd_file.put_line(fnd_file.log,'Start of Exempted Org list.');
4574: pay_in_utils.set_location(g_debug,l_procedure, 20);
4575:
4576: FOR c_pf_orglist IN csr_exempted_pf_orglist LOOP
4577: --

Line 4609: fnd_file.put_line(fnd_file.log,'Start of all Pension number list.');

4605: l_org_count := l_org_count +1;
4606: --
4607: -- Org Level Details End
4608: --
4609: fnd_file.put_line(fnd_file.log,'Start of all Pension number list.');
4610: FOR c_master_rec IN csr_pension_number(c_pf_orglist.orgid) LOOP
4611: -- Repeat this for all distinct (pension number,assignment id combinations . Rehire cases will not be
4612: -- considered.
4613: -- fnd_file.put_line(fnd_file.log,'Get details for the assignment id.'||c_master_rec.asg_id);

Line 4613: -- fnd_file.put_line(fnd_file.log,'Get details for the assignment id.'||c_master_rec.asg_id);

4609: fnd_file.put_line(fnd_file.log,'Start of all Pension number list.');
4610: FOR c_master_rec IN csr_pension_number(c_pf_orglist.orgid) LOOP
4611: -- Repeat this for all distinct (pension number,assignment id combinations . Rehire cases will not be
4612: -- considered.
4613: -- fnd_file.put_line(fnd_file.log,'Get details for the assignment id.'||c_master_rec.asg_id);
4614: pay_in_utils.set_location(g_debug,l_procedure, 40);
4615: IF (employee_type(c_master_rec.pension_number
4616: ,p_employee_type
4617: ,p_effective_start_date

Line 4624: fnd_file.put_line(fnd_file.log,'Inside the Employee Type Check');

4620: ,c_pf_orglist.orgid
4621: ,p_status))
4622: THEN
4623: pay_in_utils.set_location(g_debug,l_procedure, 50);
4624: fnd_file.put_line(fnd_file.log,'Inside the Employee Type Check');
4625: OPEN csr_not_excluded_employee(c_pf_orglist.orgid
4626: ,p_contribution_period
4627: ,c_master_rec.pension_number);
4628: FETCH csr_not_excluded_employee INTO l_excluded_employee_status;

Line 4759: fnd_file.put_line(fnd_file.log,'Monthwise details found for the pension number');

4755: --
4756: END IF;
4757: --
4758: END LOOP;
4759: fnd_file.put_line(fnd_file.log,'Monthwise details found for the pension number');
4760:
4761:
4762: IF l_row_count < 12 THEN
4763: FOR i IN 1..(12-l_row_count) LOOP

Line 4837: fnd_file.put_line(fnd_file.log,'XML Created for a PF Org.Moving onto next');

4833: END IF; -- Employee Type Check End
4834:
4835: END LOOP; -- End each pension number
4836: pay_in_utils.set_location(g_debug,l_procedure, 90);
4837: fnd_file.put_line(fnd_file.log,'XML Created for a PF Org.Moving onto next');
4838: END LOOP; -- End Each Organization
4839:
4840: l_tag := '';
4841: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 4842: fnd_file.put_line(fnd_file.log,'XML Created.');

4838: END LOOP; -- End Each Organization
4839:
4840: l_tag := '';
4841: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4842: fnd_file.put_line(fnd_file.log,'XML Created.');
4843: END create_form7_xml;
4844: --------------------------------------------------------------------------
4845: -- --
4846: -- Name : ESI_EMPLOYEE_TYPE --

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

5557: pay_in_utils.trace('p_esi_coverage',p_esi_coverage);
5558: pay_in_utils.trace('p_sysdate',p_sysdate);
5559:
5560: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
5561: fnd_file.put_line(fnd_file.log,'Creating the XML...');
5562: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
5563: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
5564: --
5565: l_tag :='';

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

5565: l_tag :='';
5566: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5567: l_tag := '';
5568: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5569: fnd_file.put_line(fnd_file.log,'Started...');
5570: --
5571: fnd_file.put_line(fnd_file.log,'Creating XML for ESI Form 6.');
5572: l_sys_date_time:=to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
5573: --System Date:

Line 5571: fnd_file.put_line(fnd_file.log,'Creating XML for ESI Form 6.');

5567: l_tag := '';
5568: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5569: fnd_file.put_line(fnd_file.log,'Started...');
5570: --
5571: fnd_file.put_line(fnd_file.log,'Creating XML for ESI Form 6.');
5572: l_sys_date_time:=to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
5573: --System Date:
5574: l_tag :=pay_in_xml_utils.getTag('c_sys_date_in_hh_mm_ss',l_sys_date_time);
5575: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5906: fnd_file.put_line(fnd_file.log,'XML Created.');

5902: END LOOP;
5903: l_tag :='';
5904: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5905:
5906: fnd_file.put_line(fnd_file.log,'XML Created.');
5907: END create_esi_xml;
5908:
5909: END pay_in_reports_pkg;