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

567: l_slab_6_2 := 300;
568: --
569: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
570:
571: fnd_file.put_line(fnd_file.log,'Creating the XML...');
572:
573: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
574: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
575: --

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

577: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
578: l_tag := '';
579: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
580:
581: fnd_file.put_line(fnd_file.log,'Started...');
582: fnd_file.put_line(fnd_file.log,'Creating XML for PT Form III.');
583:
584: --System Date:
585: l_sys_date_time := to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');

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

578: l_tag := '';
579: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
580:
581: fnd_file.put_line(fnd_file.log,'Started...');
582: fnd_file.put_line(fnd_file.log,'Creating XML for PT Form III.');
583:
584: --System Date:
585: l_sys_date_time := to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
586: l_tag :=pay_in_xml_utils.getTag('c_sys_date_in_hh_mm_ss',l_sys_date_time);

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

628: IF g_debug THEN
629: pay_in_utils.trace('c_rec.org_id ',c_rec.org_id);
630: END IF;
631:
632: fnd_file.put_line(fnd_file.log,'c_rec.org_id '|| c_rec.org_id);
633:
634: OPEN c_max_pa_action_id(c_rec.org_id
635: ,period_start
636: ,period_end);

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

717: l_slab_month_count := 0;
718: l_count_200_temp := 0;
719: l_count_300_temp := 0;
720:
721: fnd_file.put_line(fnd_file.log,'l_date: '|| l_date);
722:
723: l_period_month := TO_NUMBER(TO_CHAR(ADD_MONTHS(l_date, -3), 'MM'));
724:
725: IF l_period_month >= 10 THEN

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

780: IF l_slab <> 6 THEN
781: -- Writing to the report if the slab is not the highest slab
782: -- Highest slab is written to the report once the loop is over since a sum is to be taken for 200 and 300
783: l_slab_month_tag := 'c_month' || l_period_month || '_emp_slab'|| l_slab;
784: fnd_file.put_line(fnd_file.log,'l_slab_month_tag: '|| l_slab_month_tag);
785: l_tag := pay_in_xml_utils.getTag(l_slab_month_tag, l_slab_month_count);
786: dbms_lob.writeAppend(g_xml_data, LENGTH(l_tag), l_tag);
787: END IF;
788:

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

891:
892: l_tag :='';
893: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
894: pay_in_utils.set_location(g_debug,l_procedure, 140);
895: fnd_file.put_line(fnd_file.log,'Org Over');
896: END LOOP;
897: l_tag :='';
898: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
899: fnd_file.put_line(fnd_file.log,'XML Created.');

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

895: fnd_file.put_line(fnd_file.log,'Org Over');
896: END LOOP;
897: l_tag :='';
898: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
899: fnd_file.put_line(fnd_file.log,'XML Created.');
900: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 150);
901:
902: END create_pt_form3_xml;
903:

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

1197:
1198:
1199: pay_in_xml_utils.gXMLTable.DELETE;
1200: --
1201: fnd_file.put_line(fnd_file.log,'Creating the XML...');
1202: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
1203: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
1204: --
1205: l_tag :='';

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

1206: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1207:
1208: l_tag := '';
1209: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1210: fnd_file.put_line(fnd_file.log,'Started...');
1211:
1212: pay_in_utils.set_location(g_debug,l_procedure, 20);
1213: --
1214: fnd_file.put_line(fnd_file.log,'Creating XML for Employer Details.');

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

1210: fnd_file.put_line(fnd_file.log,'Started...');
1211:
1212: pay_in_utils.set_location(g_debug,l_procedure, 20);
1213: --
1214: fnd_file.put_line(fnd_file.log,'Creating XML for Employer Details.');
1215: l_sys_date_time:=TO_CHAR(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
1216: l_sys_date := TO_CHAR(SYSDATE,'DD-Mon-YYYY');
1217: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
1218: --System Date

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

1296:
1297: l_tag := '';
1298: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1299:
1300: fnd_file.put_line(fnd_file.log,'XML Created.');
1301: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 60);
1302:
1303:
1304: END create_form27A_xml;

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

1719:
1720:
1721: pay_in_xml_utils.gXMLTable.DELETE;
1722: --
1723: fnd_file.put_line(fnd_file.log,'Creating the XML...');
1724: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
1725: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
1726: --
1727: l_tag :='';

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

1728: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1729:
1730: l_tag := '';
1731: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1732: fnd_file.put_line(fnd_file.log,'Started...');
1733: --
1734: fnd_file.put_line(fnd_file.log,'Creating XML for Employer Details.');
1735: l_sys_date_time:=TO_CHAR(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
1736: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');

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

1730: l_tag := '';
1731: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1732: fnd_file.put_line(fnd_file.log,'Started...');
1733: --
1734: fnd_file.put_line(fnd_file.log,'Creating XML for Employer Details.');
1735: l_sys_date_time:=TO_CHAR(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
1736: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
1737: --System Date
1738: l_tag :=pay_in_xml_utils.getTag('c_current_date_in_hh_mm_ss',l_sys_date_time);

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

2030:
2031: l_tag := '';
2032: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
2033:
2034: fnd_file.put_line(fnd_file.log,'XML Created.');
2035: -- INSERT INTO temp_clob VALUES (g_xml_data);
2036:
2037: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 160);
2038:

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

2764: l_procedure := g_package ||'create_form6a_xml';
2765: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2766:
2767: --
2768: fnd_file.put_line(fnd_file.log,'Creating the XML...');
2769: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
2770: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
2771: --
2772: l_tag :='';

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

2773:
2774: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
2775: l_tag := '';
2776: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
2777: fnd_file.put_line(fnd_file.log,'Started...');
2778: --
2779: fnd_file.put_line(fnd_file.log,'Creating XML for Employee Personal Details.');
2780: l_sys_date_time:=to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
2781: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');

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

2775: l_tag := '';
2776: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
2777: fnd_file.put_line(fnd_file.log,'Started...');
2778: --
2779: fnd_file.put_line(fnd_file.log,'Creating XML for Employee Personal Details.');
2780: l_sys_date_time:=to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
2781: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
2782: --System Date
2783: l_tag :=pay_in_xml_utils.getTag('c_current_date_in_hh_mm_ss',l_sys_date_time);

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

3109: END LOOP;
3110: pay_in_utils.set_location(g_debug,l_procedure, 240);
3111: l_tag := '';
3112: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3113: fnd_file.put_line(fnd_file.log,'XML Created.');
3114:
3115: END create_form6a_xml;
3116:
3117: --------------------------------------------------------------------------

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

3327: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3328:
3329: pay_in_xml_utils.gXMLTable.DELETE;
3330: --
3331: fnd_file.put_line(fnd_file.log,'Creating the XML...');
3332: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
3333: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
3334: --
3335: l_tag :='';

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

3336:
3337: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3338: l_tag := '';
3339: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3340: fnd_file.put_line(fnd_file.log,'Started...');
3341: --
3342: fnd_file.put_line(fnd_file.log,'Creating XML for Employee Personal Details.');
3343: l_sys_date_time:=to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
3344: --System Date

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

3338: l_tag := '';
3339: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3340: fnd_file.put_line(fnd_file.log,'Started...');
3341: --
3342: fnd_file.put_line(fnd_file.log,'Creating XML for Employee Personal Details.');
3343: l_sys_date_time:=to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
3344: --System Date
3345: l_tag :=pay_in_xml_utils.getTag('c_current_date_in_hh_mm_ss',l_sys_date_time);
3346: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

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

3588: --
3589: pay_in_utils.set_location(g_debug,l_procedure, 130);
3590: l_tag := '';
3591: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3592: fnd_file.put_line(fnd_file.log,'XML Created.');
3593: END create_form3a_xml;
3594:
3595:
3596: --------------------------------------------------------------------------

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

3817:
3818: pay_in_xml_utils.gXMLTable.DELETE;
3819:
3820: --
3821: fnd_file.put_line(fnd_file.log,'Creating the XML...');
3822: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
3823: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
3824: --
3825: l_tag :='';

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

3826: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3827:
3828: l_tag := '';
3829: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3830: fnd_file.put_line(fnd_file.log,'Started...');
3831: --
3832:
3833: fnd_file.put_line(fnd_file.log,'Creating XML for Form7.');
3834:

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

3829: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3830: fnd_file.put_line(fnd_file.log,'Started...');
3831: --
3832:
3833: fnd_file.put_line(fnd_file.log,'Creating XML for Form7.');
3834:
3835: --System Date
3836: l_sys_date_time := to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
3837: l_tag :=pay_in_xml_utils.getTag('c_current_date_in_hh_mm_ss',l_sys_date_time);

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

3850: p_cp_pf_org_id := p_pf_org_id;
3851: l_bg_id:= fnd_profile.value('PER_BUSINESS_GROUP_ID');
3852:
3853:
3854: fnd_file.put_line(fnd_file.log,'Start of Exempted Org list.');
3855: pay_in_utils.set_location(g_debug,l_procedure, 20);
3856:
3857: FOR c_pf_orglist IN csr_exempted_pf_orglist LOOP
3858: --

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

3886: l_org_count := l_org_count +1;
3887: --
3888: -- Org Level Details End
3889: --
3890: fnd_file.put_line(fnd_file.log,'Start of all Pension number list.');
3891: FOR c_master_rec IN csr_pension_number(c_pf_orglist.orgid) LOOP
3892: -- Repeat this for all distinct (pension number,assignment id combinations . Rehire cases will not be
3893: -- considered.
3894: -- fnd_file.put_line(fnd_file.log,'Get details for the assignment id.'||c_master_rec.asg_id);

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

3890: fnd_file.put_line(fnd_file.log,'Start of all Pension number list.');
3891: FOR c_master_rec IN csr_pension_number(c_pf_orglist.orgid) LOOP
3892: -- Repeat this for all distinct (pension number,assignment id combinations . Rehire cases will not be
3893: -- considered.
3894: -- fnd_file.put_line(fnd_file.log,'Get details for the assignment id.'||c_master_rec.asg_id);
3895: pay_in_utils.set_location(g_debug,l_procedure, 40);
3896: IF (employee_type(c_master_rec.pension_number
3897: ,p_employee_type
3898: ,p_effective_start_date

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

3901: ,c_pf_orglist.orgid
3902: ,p_status))
3903: THEN
3904: pay_in_utils.set_location(g_debug,l_procedure, 50);
3905: fnd_file.put_line(fnd_file.log,'Inside the Employee Type Check');
3906: OPEN csr_not_excluded_employee(c_pf_orglist.orgid
3907: ,p_contribution_period
3908: ,c_master_rec.pension_number);
3909: FETCH csr_not_excluded_employee INTO l_excluded_employee_status;

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

4036: --
4037: END IF;
4038: --
4039: END LOOP;
4040: fnd_file.put_line(fnd_file.log,'Monthwise details found for the pension number');
4041:
4042:
4043: IF l_row_count < 12 THEN
4044: FOR i IN 1..(12-l_row_count) LOOP

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

4114: END IF; -- Employee Type Check End
4115:
4116: END LOOP; -- End each pension number
4117: pay_in_utils.set_location(g_debug,l_procedure, 90);
4118: fnd_file.put_line(fnd_file.log,'XML Created for a PF Org.Moving onto next');
4119: END LOOP; -- End Each Organization
4120:
4121: l_tag := '';
4122: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

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

4119: END LOOP; -- End Each Organization
4120:
4121: l_tag := '';
4122: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4123: fnd_file.put_line(fnd_file.log,'XML Created.');
4124: END create_form7_xml;
4125: --------------------------------------------------------------------------
4126: -- --
4127: -- Name : ESI_EMPLOYEE_TYPE --

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

4838: pay_in_utils.trace('p_esi_coverage',p_esi_coverage);
4839: pay_in_utils.trace('p_sysdate',p_sysdate);
4840:
4841: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
4842: fnd_file.put_line(fnd_file.log,'Creating the XML...');
4843: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
4844: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
4845: --
4846: l_tag :='';

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

4846: l_tag :='';
4847: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4848: l_tag := '';
4849: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4850: fnd_file.put_line(fnd_file.log,'Started...');
4851: --
4852: fnd_file.put_line(fnd_file.log,'Creating XML for ESI Form 6.');
4853: l_sys_date_time:=to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
4854: --System Date:

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

4848: l_tag := '';
4849: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4850: fnd_file.put_line(fnd_file.log,'Started...');
4851: --
4852: fnd_file.put_line(fnd_file.log,'Creating XML for ESI Form 6.');
4853: l_sys_date_time:=to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
4854: --System Date:
4855: l_tag :=pay_in_xml_utils.getTag('c_sys_date_in_hh_mm_ss',l_sys_date_time);
4856: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

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

5183: END LOOP;
5184: l_tag :='';
5185: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5186:
5187: fnd_file.put_line(fnd_file.log,'XML Created.');
5188: END create_esi_xml;
5189:
5190: END pay_in_reports_pkg;