APPS.PAY_IN_REPORTS_PKG dependencies on DBMS_LOB

Line 593: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);

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: --
596: l_tag :='';
597: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 594: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);

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: --
596: l_tag :='';
597: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
598: l_tag := '';

Line 597: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

593: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
594: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
595: --
596: l_tag :='';
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...');

Line 599: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

595: --
596: l_tag :='';
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:

Line 607: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

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);
607: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
608:
609: IF g_debug THEN
610: pay_in_utils.trace('Business Group id ',l_bg_id);
611: pay_in_utils.trace('System Date and Time ',l_sys_date_time);

Line 646: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

642: ,period_end)
643: LOOP
644: l_tag :='';
645: pay_in_utils.set_location(g_debug,l_procedure, 40);
646: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
647:
648: IF g_debug THEN
649: pay_in_utils.trace('c_rec.org_id ',c_rec.org_id);
650: END IF;

Line 679: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

675: CLOSE c_org_details;
676: pay_in_utils.set_location(g_debug,l_procedure, 60);
677: -- Registered No
678: l_tag :=pay_in_xml_utils.getTag('c_registered_no', l_registered_no);
679: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
680: --Organization Name and Address
681: l_tag :=pay_in_xml_utils.getTag('c_registered_name', l_registered_name);
682: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
683: l_tag :=pay_in_xml_utils.getTag('c_registered_address', l_reg_address);

Line 682: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

678: l_tag :=pay_in_xml_utils.getTag('c_registered_no', l_registered_no);
679: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
680: --Organization Name and Address
681: l_tag :=pay_in_xml_utils.getTag('c_registered_name', l_registered_name);
682: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
683: l_tag :=pay_in_xml_utils.getTag('c_registered_address', l_reg_address);
684: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
685: --Report Period
686: l_tag :=pay_in_xml_utils.getTag('c_period_from', to_char(period_start));

Line 684: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

680: --Organization Name and Address
681: l_tag :=pay_in_xml_utils.getTag('c_registered_name', l_registered_name);
682: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
683: l_tag :=pay_in_xml_utils.getTag('c_registered_address', l_reg_address);
684: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
685: --Report Period
686: l_tag :=pay_in_xml_utils.getTag('c_period_from', to_char(period_start));
687: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
688: l_tag :=pay_in_xml_utils.getTag('c_period_to', to_char(period_end));

Line 687: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

683: l_tag :=pay_in_xml_utils.getTag('c_registered_address', l_reg_address);
684: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
685: --Report Period
686: l_tag :=pay_in_xml_utils.getTag('c_period_from', to_char(period_start));
687: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
688: l_tag :=pay_in_xml_utils.getTag('c_period_to', to_char(period_end));
689: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
690: --Organization Rep Name and Designation
691: l_tag :=pay_in_xml_utils.getTag('c_rep_name', l_rep_name);

Line 689: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

685: --Report Period
686: l_tag :=pay_in_xml_utils.getTag('c_period_from', to_char(period_start));
687: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
688: l_tag :=pay_in_xml_utils.getTag('c_period_to', to_char(period_end));
689: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
690: --Organization Rep Name and Designation
691: l_tag :=pay_in_xml_utils.getTag('c_rep_name', l_rep_name);
692: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
693: l_tag :=pay_in_xml_utils.getTag('c_rep_desg', l_rep_desg);

Line 692: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

688: l_tag :=pay_in_xml_utils.getTag('c_period_to', to_char(period_end));
689: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
690: --Organization Rep Name and Designation
691: l_tag :=pay_in_xml_utils.getTag('c_rep_name', l_rep_name);
692: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
693: l_tag :=pay_in_xml_utils.getTag('c_rep_desg', l_rep_desg);
694: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
695: --BSRTC No
696: l_tag :=pay_in_xml_utils.getTag('c_bsrtc_no', l_bsrtc_no);

Line 694: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

690: --Organization Rep Name and Designation
691: l_tag :=pay_in_xml_utils.getTag('c_rep_name', l_rep_name);
692: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
693: l_tag :=pay_in_xml_utils.getTag('c_rep_desg', l_rep_desg);
694: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
695: --BSRTC No
696: l_tag :=pay_in_xml_utils.getTag('c_bsrtc_no', l_bsrtc_no);
697: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
698: --Date

Line 697: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

693: l_tag :=pay_in_xml_utils.getTag('c_rep_desg', l_rep_desg);
694: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
695: --BSRTC No
696: l_tag :=pay_in_xml_utils.getTag('c_bsrtc_no', l_bsrtc_no);
697: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
698: --Date
699: l_tag :=pay_in_xml_utils.getTag('c_date', substr(l_sys_date_time, 1, 11));
700: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
701: pay_in_utils.set_location(g_debug,l_procedure, 70);

Line 700: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

696: l_tag :=pay_in_xml_utils.getTag('c_bsrtc_no', l_bsrtc_no);
697: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
698: --Date
699: l_tag :=pay_in_xml_utils.getTag('c_date', substr(l_sys_date_time, 1, 11));
700: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
701: pay_in_utils.set_location(g_debug,l_procedure, 70);
702:
703: IF g_debug THEN
704: pay_in_utils.trace('Registered No ',l_registered_no);

Line 825: dbms_lob.writeAppend(g_xml_data, LENGTH(l_tag), l_tag);

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:
828: END LOOP;
829: END LOOP;

Line 851: dbms_lob.writeAppend(g_xml_data, LENGTH(l_tag), l_tag);

847: IF l_slab_month_count <> 0 THEN
848: -- Writing to the file for the highest slab
849: l_slab_month_tag := 'c_month' || l_period_month || '_emp_slab6';
850: l_tag := pay_in_xml_utils.getTag(l_slab_month_tag, l_slab_month_count);
851: dbms_lob.writeAppend(g_xml_data, LENGTH(l_tag), l_tag);
852: END IF;
853:
854: l_date := ADD_MONTHS(l_date, 1);
855:

Line 861: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

857: pay_in_utils.set_location(g_debug,l_procedure, 120);
858:
859: -- Writing the total employees in a slab
860: l_tag := pay_in_xml_utils.getTag('c_emp_slab_1', l_count_0);
861: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
862: -- l_tag := pay_in_xml_utils.getTag('c_emp_slab_2', l_count_30);
863: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
864: l_tag := pay_in_xml_utils.getTag('c_emp_slab_3', l_count_60);
865: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 863: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

859: -- Writing the total employees in a slab
860: l_tag := pay_in_xml_utils.getTag('c_emp_slab_1', l_count_0);
861: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
862: -- l_tag := pay_in_xml_utils.getTag('c_emp_slab_2', l_count_30);
863: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
864: l_tag := pay_in_xml_utils.getTag('c_emp_slab_3', l_count_60);
865: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
866: l_tag := pay_in_xml_utils.getTag('c_emp_slab_4', l_count_120);
867: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 865: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

861: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
862: -- l_tag := pay_in_xml_utils.getTag('c_emp_slab_2', l_count_30);
863: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
864: l_tag := pay_in_xml_utils.getTag('c_emp_slab_3', l_count_60);
865: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
866: l_tag := pay_in_xml_utils.getTag('c_emp_slab_4', l_count_120);
867: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
868: l_tag := pay_in_xml_utils.getTag('c_emp_slab_5', l_count_175);
869: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 867: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

863: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
864: l_tag := pay_in_xml_utils.getTag('c_emp_slab_3', l_count_60);
865: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
866: l_tag := pay_in_xml_utils.getTag('c_emp_slab_4', l_count_120);
867: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
868: l_tag := pay_in_xml_utils.getTag('c_emp_slab_5', l_count_175);
869: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
870: l_tag := pay_in_xml_utils.getTag('c_emp_slab_6', l_count_200 + l_count_300);
871: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 869: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

865: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
866: l_tag := pay_in_xml_utils.getTag('c_emp_slab_4', l_count_120);
867: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
868: l_tag := pay_in_xml_utils.getTag('c_emp_slab_5', l_count_175);
869: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
870: l_tag := pay_in_xml_utils.getTag('c_emp_slab_6', l_count_200 + l_count_300);
871: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
872:
873: -- Calculating the PT paid in each slab

Line 871: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

867: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
868: l_tag := pay_in_xml_utils.getTag('c_emp_slab_5', l_count_175);
869: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
870: l_tag := pay_in_xml_utils.getTag('c_emp_slab_6', l_count_200 + l_count_300);
871: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
872:
873: -- Calculating the PT paid in each slab
874: -- l_tax_slab_2 := l_slab_2 * l_count_30;
875: l_tax_slab_3 := l_slab_3 * l_cnt_60;

Line 885: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

881:
882: /*To maintain two formats of the report before to Jul09 and from Jul09*/
883: IF l_slab_3 = 0 THEN
884: l_tag := pay_in_xml_utils.getTag('c_rate_1', 'Nil');
885: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
886: ELSE
887: l_tag := pay_in_xml_utils.getTag('c_rate_1', 'Rs. 60');
888: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
889: END IF;

Line 888: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

884: l_tag := pay_in_xml_utils.getTag('c_rate_1', 'Nil');
885: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
886: ELSE
887: l_tag := pay_in_xml_utils.getTag('c_rate_1', 'Rs. 60');
888: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
889: END IF;
890:
891: IF l_slab_4 = 0 THEN
892: l_tag := pay_in_xml_utils.getTag('c_rate_2', 'Nil');

Line 893: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

889: END IF;
890:
891: IF l_slab_4 = 0 THEN
892: l_tag := pay_in_xml_utils.getTag('c_rate_2', 'Nil');
893: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
894: ELSE
895: l_tag := pay_in_xml_utils.getTag('c_rate_2', 'Rs. 120');
896: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
897: END IF;

Line 896: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

892: l_tag := pay_in_xml_utils.getTag('c_rate_2', 'Nil');
893: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
894: ELSE
895: l_tag := pay_in_xml_utils.getTag('c_rate_2', 'Rs. 120');
896: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
897: END IF;
898:
899: IF l_cnt_60 = 0 THEN
900: l_tag := pay_in_xml_utils.getTag('c_rs1', 'Nil');

Line 901: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

897: END IF;
898:
899: IF l_cnt_60 = 0 THEN
900: l_tag := pay_in_xml_utils.getTag('c_rs1', 'Nil');
901: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
902: l_tag := pay_in_xml_utils.getTag('c_tax_slab_3', '');
903: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
904: ELSE
905: l_tag := pay_in_xml_utils.getTag('c_rs1', 'Rs.');

Line 903: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

899: IF l_cnt_60 = 0 THEN
900: l_tag := pay_in_xml_utils.getTag('c_rs1', 'Nil');
901: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
902: l_tag := pay_in_xml_utils.getTag('c_tax_slab_3', '');
903: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
904: ELSE
905: l_tag := pay_in_xml_utils.getTag('c_rs1', 'Rs.');
906: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
907: l_tag := pay_in_xml_utils.getTag('c_tax_slab_3', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_3,0)));

Line 906: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

902: l_tag := pay_in_xml_utils.getTag('c_tax_slab_3', '');
903: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
904: ELSE
905: l_tag := pay_in_xml_utils.getTag('c_rs1', 'Rs.');
906: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
907: l_tag := pay_in_xml_utils.getTag('c_tax_slab_3', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_3,0)));
908: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
909: END IF;
910:

Line 908: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

904: ELSE
905: l_tag := pay_in_xml_utils.getTag('c_rs1', 'Rs.');
906: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
907: l_tag := pay_in_xml_utils.getTag('c_tax_slab_3', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_3,0)));
908: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
909: END IF;
910:
911: IF l_cnt_120 = 0 THEN
912: l_tag := pay_in_xml_utils.getTag('c_rs2', 'Nil');

Line 913: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

909: END IF;
910:
911: IF l_cnt_120 = 0 THEN
912: l_tag := pay_in_xml_utils.getTag('c_rs2', 'Nil');
913: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
914: l_tag := pay_in_xml_utils.getTag('c_tax_slab_4', '');
915: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
916: ELSE
917: l_tag := pay_in_xml_utils.getTag('c_rs2', 'Rs.');

Line 915: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

911: IF l_cnt_120 = 0 THEN
912: l_tag := pay_in_xml_utils.getTag('c_rs2', 'Nil');
913: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
914: l_tag := pay_in_xml_utils.getTag('c_tax_slab_4', '');
915: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
916: ELSE
917: l_tag := pay_in_xml_utils.getTag('c_rs2', 'Rs.');
918: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
919: l_tag := pay_in_xml_utils.getTag('c_tax_slab_4', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_4,0)));

Line 918: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

914: l_tag := pay_in_xml_utils.getTag('c_tax_slab_4', '');
915: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
916: ELSE
917: l_tag := pay_in_xml_utils.getTag('c_rs2', 'Rs.');
918: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
919: l_tag := pay_in_xml_utils.getTag('c_tax_slab_4', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_4,0)));
920: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
921: END IF;
922:

Line 920: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

916: ELSE
917: l_tag := pay_in_xml_utils.getTag('c_rs2', 'Rs.');
918: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
919: l_tag := pay_in_xml_utils.getTag('c_tax_slab_4', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_4,0)));
920: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
921: END IF;
922:
923:
924: -- Writing to file the calculated PT paid in each slab

Line 926: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

922:
923:
924: -- Writing to file the calculated PT paid in each slab
925: -- l_tag := pay_in_xml_utils.getTag('c_tax_slab_2', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_2,0)));
926: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
927: l_tag := pay_in_xml_utils.getTag('c_tax_slab_5', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_5,0)));
928: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
929: l_tag := pay_in_xml_utils.getTag('c_tax_slab_6', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_6,0)));
930: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 928: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

924: -- Writing to file the calculated PT paid in each slab
925: -- l_tag := pay_in_xml_utils.getTag('c_tax_slab_2', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_2,0)));
926: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
927: l_tag := pay_in_xml_utils.getTag('c_tax_slab_5', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_5,0)));
928: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
929: l_tag := pay_in_xml_utils.getTag('c_tax_slab_6', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_6,0)));
930: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
931:
932: pay_in_utils.set_location(g_debug,l_procedure, 130);

Line 930: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

926: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
927: l_tag := pay_in_xml_utils.getTag('c_tax_slab_5', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_5,0)));
928: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
929: l_tag := pay_in_xml_utils.getTag('c_tax_slab_6', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_6,0)));
930: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
931:
932: pay_in_utils.set_location(g_debug,l_procedure, 130);
933:
934: -- Getting the actual PT paid from the challans data

Line 951: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

947: END IF;
948:
949:
950: l_tag := pay_in_xml_utils.getTag('c_tax_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_amount,0)));
951: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
952:
953: l_tag := pay_in_xml_utils.getTag('c_interest_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_interest_amount,0)));
954: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
955:

Line 954: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

950: l_tag := pay_in_xml_utils.getTag('c_tax_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_amount,0)));
951: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
952:
953: l_tag := pay_in_xml_utils.getTag('c_interest_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_interest_amount,0)));
954: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
955:
956: l_tag := pay_in_xml_utils.getTag('c_excess_tax', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_excess_tax,0)));
957: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
958:

Line 957: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

953: l_tag := pay_in_xml_utils.getTag('c_interest_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_interest_amount,0)));
954: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
955:
956: l_tag := pay_in_xml_utils.getTag('c_excess_tax', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_excess_tax,0)));
957: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
958:
959: l_net_amount := l_tax_amount - l_excess_tax + l_interest_amount;
960:
961: l_tag := pay_in_xml_utils.getTag('c_net_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_net_amount,0)));

Line 962: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

958:
959: l_net_amount := l_tax_amount - l_excess_tax + l_interest_amount;
960:
961: l_tag := pay_in_xml_utils.getTag('c_net_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_net_amount,0)));
962: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
963:
964: l_tag := pay_in_xml_utils.getTag('c_total_amount_words', initcap(pay_in_utils.number_to_words(l_net_amount)));
965: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
966:

Line 965: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

961: l_tag := pay_in_xml_utils.getTag('c_net_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_net_amount,0)));
962: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
963:
964: l_tag := pay_in_xml_utils.getTag('c_total_amount_words', initcap(pay_in_utils.number_to_words(l_net_amount)));
965: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
966:
967: l_tag :=pay_in_xml_utils.getTag('c_year', period_start_year);
968: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
969: l_tag :=pay_in_xml_utils.getTag('c_year1', SUBSTR(p_year, 6, 4));

Line 968: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

964: l_tag := pay_in_xml_utils.getTag('c_total_amount_words', initcap(pay_in_utils.number_to_words(l_net_amount)));
965: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
966:
967: l_tag :=pay_in_xml_utils.getTag('c_year', period_start_year);
968: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
969: l_tag :=pay_in_xml_utils.getTag('c_year1', SUBSTR(p_year, 6, 4));
970: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
971:
972: l_tag :='';

Line 970: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

966:
967: l_tag :=pay_in_xml_utils.getTag('c_year', period_start_year);
968: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
969: l_tag :=pay_in_xml_utils.getTag('c_year1', SUBSTR(p_year, 6, 4));
970: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
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);

Line 973: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

969: l_tag :=pay_in_xml_utils.getTag('c_year1', SUBSTR(p_year, 6, 4));
970: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
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 :='';

Line 978: 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.');
980: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 150);
981:
982: END create_pt_form3_xml;

Line 1016: dbms_lob.writeAppend(g_xml_data,length(l_tag),l_tag);

1012: l_tag := pay_in_xml_utils.getTag( p_tag_name => p_tag_name
1013: , p_tag_value => p_tag_value
1014: );
1015:
1016: dbms_lob.writeAppend(g_xml_data,length(l_tag),l_tag);
1017: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
1018: END write_tag;
1019:
1020: --------------------------------------------------------------------------

Line 1282: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);

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 :='';
1286: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 1283: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);

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 :='';
1286: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1287:

Line 1286: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

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 :='';
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...');

Line 1289: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1285: l_tag :='';
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: --

Line 1300: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1296: l_sys_date := TO_CHAR(SYSDATE,'DD-Mon-YYYY');
1297: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
1298: --System Date
1299: l_tag :=pay_in_xml_utils.getTag('c_current_date_in_hh_mm_ss',l_sys_date_time);
1300: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1301:
1302: pay_in_utils.set_location(g_debug,l_procedure, 30);
1303:
1304: OPEN csr_org_max_action_context_id;

Line 1378: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1374: WRITE_TAG('C_REP_DESG',l_rep_desg);
1375:
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:

Line 1551: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);

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);
1555: IF (l_mon < 10) THEN

Line 1552: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);

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);
1555: IF (l_mon < 10) THEN
1556: l_mon := l_mon + 3;

Line 1595: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1591:
1592: END LOOP;
1593:
1594: l_tag :='';
1595: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1596: l_tag :='';
1597: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1598:
1599: pay_in_utils.set_location(g_debug,l_procedure, 30);

Line 1597: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1593:
1594: l_tag :='';
1595: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1596: l_tag :='';
1597: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1598:
1599: pay_in_utils.set_location(g_debug,l_procedure, 30);
1600:
1601: FOR c_rec IN c_asg_id(p_pf_org_id --PF Org ID

Line 1608: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1604: LOOP
1605: pay_in_utils.set_location(g_debug,l_procedure, 40);
1606:
1607: l_tag := '';
1608: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1609:
1610: IF length(c_rec.member_id) < 8 and to_number(c_rec.member_id) >0
1611: THEN
1612: l_tag :=pay_in_xml_utils.getTag('c_1_pf_no',c_rec.member_id);

Line 1613: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1609:
1610: IF length(c_rec.member_id) < 8 and to_number(c_rec.member_id) >0
1611: THEN
1612: l_tag :=pay_in_xml_utils.getTag('c_1_pf_no',c_rec.member_id);
1613: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1614: ELSE
1615: fnd_message.set_name('PER', 'PER_IN_INVALID_PF_NUMBER');
1616: fnd_message.set_token('PF_NUMBER',c_rec.member_id, translate => true );
1617: hr_utility.raise_error; /* raise invalid pf account number error */

Line 1678: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1674: fnd_message.set_token('EMP_NAME',l_member_name_1, translate => true );
1675: hr_utility.raise_error; /* raise invalid name error */
1676: ELSE
1677: l_tag :=pay_in_xml_utils.getTag('c_1_memeber_name',l_member_name_1);
1678: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1679:
1680: END IF;
1681:
1682: l_is_number := to_number(l_epf_wages_1);

Line 1686: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1682: l_is_number := to_number(l_epf_wages_1);
1683:
1684: IF l_is_number = trunc(l_is_number) THEN
1685: l_tag :=pay_in_xml_utils.getTag('c_1_epf_wages',l_epf_wages_1);
1686: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1687: ELSE
1688: fnd_message.set_name('PER', 'PER_IN_DECIMAL_VALUE');
1689: fnd_message.set_token('NUM_VAL',l_epf_wages_1, translate => true );
1690: hr_utility.raise_error; /* raise no decimal error */

Line 1696: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1692:
1693: l_is_number := to_number(l_eps_wages_1);
1694: IF l_is_number = trunc(l_is_number) THEN
1695: l_tag :=pay_in_xml_utils.getTag('c_1_eps_wages',l_eps_wages_1);
1696: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1697: ELSE
1698: fnd_message.set_name('PER', 'PER_IN_DECIMAL_VALUE');
1699: fnd_message.set_token('NUM_VAL',l_eps_wages_1, translate => true );
1700: hr_utility.raise_error; /* raise no decimal error */

Line 1707: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1703: l_is_number := to_number(l_epf_contribution_employee_1);
1704:
1705: IF l_is_number = trunc(l_is_number) THEN
1706: l_tag :=pay_in_xml_utils.getTag('c_1_epf_cont_due',l_epf_contribution_employee_1);
1707: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1708:
1709: l_tag :=pay_in_xml_utils.getTag('c_1_epf_cont_rem',l_epf_contribution_employee_1);
1710: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1711: ELSE

Line 1710: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1706: l_tag :=pay_in_xml_utils.getTag('c_1_epf_cont_due',l_epf_contribution_employee_1);
1707: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1708:
1709: l_tag :=pay_in_xml_utils.getTag('c_1_epf_cont_rem',l_epf_contribution_employee_1);
1710: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1711: ELSE
1712: fnd_message.set_name('PER', 'PER_IN_DECIMAL_VALUE');
1713: fnd_message.set_token('NUM_VAL',l_epf_contribution_employee_1, translate => true );
1714: hr_utility.raise_error; /* raise no decimal error */

Line 1721: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1717: l_is_number := to_number(l_employer_contr_towards_eps_1);
1718:
1719: IF l_is_number = trunc(l_is_number) THEN
1720: l_tag :=pay_in_xml_utils.getTag('c_1_eps_cont_due',l_employer_contr_towards_eps_1);
1721: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1722:
1723: l_tag :=pay_in_xml_utils.getTag('c_1_eps_cont_rem',l_employer_contr_towards_eps_1);
1724: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1725: ELSE

Line 1724: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1720: l_tag :=pay_in_xml_utils.getTag('c_1_eps_cont_due',l_employer_contr_towards_eps_1);
1721: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1722:
1723: l_tag :=pay_in_xml_utils.getTag('c_1_eps_cont_rem',l_employer_contr_towards_eps_1);
1724: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1725: ELSE
1726: fnd_message.set_name('PER', 'PER_IN_DECIMAL_VALUE');
1727: fnd_message.set_token('NUM_VAL',l_employer_contr_towards_eps_1, translate => true );
1728: hr_utility.raise_error; /* raise no decimal error */

Line 1734: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1730:
1731: l_is_number := to_number(l_employer_contr_towards_pf_1);
1732: IF l_is_number = trunc(l_is_number) THEN
1733: l_tag :=pay_in_xml_utils.getTag('c_1_eps_epf_due',l_employer_contr_towards_pf_1);
1734: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1735:
1736: l_tag :=pay_in_xml_utils.getTag('c_1_eps_epf_rem',l_employer_contr_towards_pf_1);
1737: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1738: ELSE

Line 1737: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1733: l_tag :=pay_in_xml_utils.getTag('c_1_eps_epf_due',l_employer_contr_towards_pf_1);
1734: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1735:
1736: l_tag :=pay_in_xml_utils.getTag('c_1_eps_epf_rem',l_employer_contr_towards_pf_1);
1737: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1738: ELSE
1739: fnd_message.set_name('PER', 'PER_IN_DECIMAL_VALUE');
1740: fnd_message.set_token('NUM_VAL',l_employer_contr_towards_pf_1, translate => true );
1741: hr_utility.raise_error; /* raise no decimal error */

Line 1747: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1743:
1744: l_is_number := to_number(l_absence_1);
1745: IF l_is_number = trunc(l_is_number) THEN
1746: l_tag :=pay_in_xml_utils.getTag('c_1_non_con_per',l_absence_1);
1747: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1748: ELSE
1749: fnd_message.set_name('PER', 'PER_IN_DECIMAL_VALUE');
1750: fnd_message.set_token('NUM_VAL',l_absence_1, translate => true );
1751: hr_utility.raise_error; /* raise no decimal error */

Line 1755: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1751: hr_utility.raise_error; /* raise no decimal error */
1752: END IF;
1753:
1754: l_tag :=pay_in_xml_utils.getTag('c_1_ref_adv_emp','0');
1755: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1756:
1757: l_tag :=pay_in_xml_utils.getTag('c_1_epf_arr_wages','0');
1758: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1759:

Line 1758: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1754: l_tag :=pay_in_xml_utils.getTag('c_1_ref_adv_emp','0');
1755: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1756:
1757: l_tag :=pay_in_xml_utils.getTag('c_1_epf_arr_wages','0');
1758: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1759:
1760: l_tag :=pay_in_xml_utils.getTag('c_1_epf_ee_arr','0');
1761: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1762:

Line 1761: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1757: l_tag :=pay_in_xml_utils.getTag('c_1_epf_arr_wages','0');
1758: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1759:
1760: l_tag :=pay_in_xml_utils.getTag('c_1_epf_ee_arr','0');
1761: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1762:
1763: l_tag :=pay_in_xml_utils.getTag('c_1_epf_er_arr','0');
1764: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1765:

Line 1764: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1760: l_tag :=pay_in_xml_utils.getTag('c_1_epf_ee_arr','0');
1761: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1762:
1763: l_tag :=pay_in_xml_utils.getTag('c_1_epf_er_arr','0');
1764: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1765:
1766: l_tag :=pay_in_xml_utils.getTag('c_1_eps_arr_wages','0');
1767: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1768:

Line 1767: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1763: l_tag :=pay_in_xml_utils.getTag('c_1_epf_er_arr','0');
1764: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1765:
1766: l_tag :=pay_in_xml_utils.getTag('c_1_eps_arr_wages','0');
1767: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1768:
1769: pay_in_utils.set_location(g_debug,l_procedure, 70);
1770:
1771: IF(to_date(l_hire_date_1,'DD/MM/YYYY')

Line 1783: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1779: fnd_message.set_token('EMP_NAME',l_father_husband_name_1, translate => true );
1780: hr_utility.raise_error; /* raise invalid name error */
1781: ELSE
1782: l_tag :=pay_in_xml_utils.getTag('c_1_fat_hus_name',l_father_husband_name_1);
1783: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1784: END IF;
1785:
1786: l_tag :=pay_in_xml_utils.getTag('c_1_fat_hus_rel',l_contact_type_1);
1787: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 1787: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1783: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1784: END IF;
1785:
1786: l_tag :=pay_in_xml_utils.getTag('c_1_fat_hus_rel',l_contact_type_1);
1787: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1788:
1789: l_tag :=pay_in_xml_utils.getTag('c_1_dob',l_date_of_birth_1);
1790: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1791:

Line 1790: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1786: l_tag :=pay_in_xml_utils.getTag('c_1_fat_hus_rel',l_contact_type_1);
1787: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1788:
1789: l_tag :=pay_in_xml_utils.getTag('c_1_dob',l_date_of_birth_1);
1790: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1791:
1792: l_tag :=pay_in_xml_utils.getTag('c_1_gender',l_gender_1);
1793: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1794:

Line 1793: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1789: l_tag :=pay_in_xml_utils.getTag('c_1_dob',l_date_of_birth_1);
1790: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1791:
1792: l_tag :=pay_in_xml_utils.getTag('c_1_gender',l_gender_1);
1793: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1794:
1795: l_tag :=pay_in_xml_utils.getTag('c_1_doj_epf',l_hire_date_1);
1796: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1797:

Line 1796: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1792: l_tag :=pay_in_xml_utils.getTag('c_1_gender',l_gender_1);
1793: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1794:
1795: l_tag :=pay_in_xml_utils.getTag('c_1_doj_epf',l_hire_date_1);
1796: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1797:
1798: l_tag :=pay_in_xml_utils.getTag('c_1_doj_eps',l_hire_date_1);
1799: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1800:

Line 1799: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1795: l_tag :=pay_in_xml_utils.getTag('c_1_doj_epf',l_hire_date_1);
1796: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1797:
1798: l_tag :=pay_in_xml_utils.getTag('c_1_doj_eps',l_hire_date_1);
1799: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1800:
1801: pay_in_utils.set_location(g_debug,l_procedure, 80);
1802:
1803: END IF;

Line 1810: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1806: BETWEEN TRUNC(to_date(l_payroll_date_1,'DD/MM/YYYY'),'MM')
1807: AND last_day(to_date(l_payroll_date_1,'DD/MM/YYYY'))) THEN
1808:
1809: l_tag :=pay_in_xml_utils.getTag('c_1_doe_epf', l_term_date_1);
1810: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1811:
1812: l_tag :=pay_in_xml_utils.getTag('c_1_leav_rsn',l_term_reason_1);
1813: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1814:

Line 1813: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1809: l_tag :=pay_in_xml_utils.getTag('c_1_doe_epf', l_term_date_1);
1810: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1811:
1812: l_tag :=pay_in_xml_utils.getTag('c_1_leav_rsn',l_term_reason_1);
1813: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1814:
1815: pay_in_utils.set_location(g_debug,l_procedure, 90);
1816:
1817: END IF;

Line 1830: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1826: THEN
1827: l_leave:=least(add_months(to_date(l_date_of_birth_1,'DD/MM/YYYY'),l_eps_age*12 ),to_date( l_term_date_1,'DD/MM/YYYY'));
1828: l_leave_2:=to_char(to_date(l_leave,'DD/MM/RRRR'),'DD/MM/RRRR');
1829: l_tag :=pay_in_xml_utils.getTag('c_1_doe_eps',l_leave_2);
1830: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1831:
1832: pay_in_utils.set_location(g_debug,l_procedure, 100);
1833:
1834: ELSE

Line 1838: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1834: ELSE
1835: l_leave:=add_months(to_date(l_date_of_birth_1,'DD/MM/YYYY'),l_eps_age*12 );
1836: l_leave_2:=to_char(to_date(l_leave,'DD/MM/RRRR'),'DD/MM/RRRR');
1837: l_tag :=pay_in_xml_utils.getTag('c_1_doe_eps',l_leave_2);
1838: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1839:
1840: pay_in_utils.set_location(g_debug,l_procedure, 110);
1841: END IF;
1842:

Line 1851: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1847: THEN
1848: IF (add_months(to_date(l_date_of_birth_1,'DD/MM/YYYY'),l_eps_age*12 ) < TRUNC(to_date(l_payroll_date_1,'DD/MM/YYYY'),'MM'))
1849: THEN
1850: l_tag :=pay_in_xml_utils.getTag('c_1_doe_eps',null);
1851: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1852:
1853: pay_in_utils.set_location(g_debug,l_procedure, 120);
1854: ELSE
1855: l_tag :=pay_in_xml_utils.getTag('c_1_doe_eps', l_term_date_1);

Line 1856: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1852:
1853: pay_in_utils.set_location(g_debug,l_procedure, 120);
1854: ELSE
1855: l_tag :=pay_in_xml_utils.getTag('c_1_doe_eps', l_term_date_1);
1856: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1857:
1858: pay_in_utils.set_location(g_debug,l_procedure, 130);
1859: END IF;
1860: END IF;

Line 1864: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1860: END IF;
1861: END IF;
1862:
1863: l_tag := '';
1864: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1865: END LOOP;
1866:
1867: pay_in_utils.set_location(g_debug,l_procedure, 140);
1868: l_tag :='';

Line 1869: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1865: END LOOP;
1866:
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:

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 2305: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);

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 :='';
2309: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 2306: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);

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 :='';
2309: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
2310:

Line 2309: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

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 :='';
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...');

Line 2312: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

2308: l_tag :='';
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');

Line 2320: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

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);
2320: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
2321:
2322: pay_in_utils.set_location(g_debug,l_procedure, 20);
2323:
2324: FOR c_rec IN c_pf_org_id(p_pf_org_id

Line 2331: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

2327: ,p_effective_end_date)
2328: LOOP
2329: pay_in_utils.set_location(g_debug,l_procedure, 30);
2330: l_tag := '';
2331: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
2332:
2333: IF g_debug THEN
2334: pay_in_utils.trace('PF Organization id ',p_pf_org_id);
2335: pay_in_utils.trace('Contribution Period ',p_contribution_period);

Line 2604: dbms_lob.writeAppend(g_xml_data, LENGTH(l_tag), l_tag);

2600: l_count := l_count + 1;
2601: pay_in_xml_utils.multiColumnar('pf_org_sum',pay_in_xml_utils.gXMLTable,l_count,g_xml_data);
2602: /* Ending Starts here*/
2603: l_tag := '';
2604: dbms_lob.writeAppend(g_xml_data, LENGTH(l_tag), l_tag);
2605: pay_in_xml_utils.gXMLTable.DELETE;
2606: l_row_count:=NULL;
2607: pay_in_utils.set_location(g_debug,l_procedure, 140);
2608: END LOOP;

Line 2613: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

2609:
2610: pay_in_utils.set_location(g_debug,l_procedure, 150);
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:

Line 3359: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);

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 :='';
3363:

Line 3360: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);

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 :='';
3363:
3364: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 3364: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3360: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
3361: --
3362: l_tag :='';
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: --

Line 3366: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3362: l_tag :='';
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');

Line 3374: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

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);
3374: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3375:
3376: pay_in_utils.set_location(g_debug,l_procedure, 20);
3377:
3378: FOR c_rec IN c_pf_org_id(p_pf_org_id

Line 3390: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3386: l_org_employee := 0 ;
3387: l_org_pension := 0 ;
3388:
3389: l_tag := '';
3390: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3391: l_count:=1;
3392: --PF Org Reg Name
3393: --PF Org Name made in BLOCK
3394: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pf_org_name';

Line 3738: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3734: l_count := l_count + 1;
3735: pay_in_xml_utils.multiColumnar('pf_org_sum',pay_in_xml_utils.gXMLTable,l_count,g_xml_data);
3736: /* Ending Starts here*/
3737: l_tag := '';
3738: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3739: pay_in_xml_utils.gXMLTable.delete;
3740: l_row_count:=null;
3741: END LOOP;
3742: pay_in_utils.set_location(g_debug,l_procedure, 240);

Line 3744: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3740: l_row_count:=null;
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:

Line 3974: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);

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 :='';
3978:

Line 3975: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);

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 :='';
3978:
3979: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 3979: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3975: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
3976: --
3977: l_tag :='';
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: --

Line 3981: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

3977: l_tag :='';
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');

Line 3988: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

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);
3989: l_cp_pf_org_id := p_pf_org_id;
3990:
3991: pay_in_utils.set_location(g_debug,l_procedure, 20);
3992:

Line 4147: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4143: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_address';
4144: pay_in_xml_utils.gXMLTable(l_count).Value := (c_rec.action_information5);
4145: l_count := l_count + 1;
4146: l_tag := '';
4147: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4148: pay_in_xml_utils.multiColumnar('Details',pay_in_xml_utils.gXMLTable,l_count,g_xml_data);
4149: l_count:=1;
4150: l_row_count:=0;
4151: --Individual Month Record Determination

Line 4252: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4248:
4249: pay_in_utils.set_location(g_debug,l_procedure, 100);
4250: --Voluntary Higher Contr Rate
4251: l_tag :=pay_in_xml_utils.getTag('c_voluntary_rate',to_number(l_voluntary_contribution_rate,999.99));
4252: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4253: --Employer Representative name
4254: l_tag :=pay_in_xml_utils.getTag('c_rep_name',l_pf_rep_name);
4255: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4256: FOR c_sum IN c_asg_summation_details(/*c_master.assignment_id --Assignment ID

Line 4255: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4251: l_tag :=pay_in_xml_utils.getTag('c_voluntary_rate',to_number(l_voluntary_contribution_rate,999.99));
4252: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4253: --Employer Representative name
4254: l_tag :=pay_in_xml_utils.getTag('c_rep_name',l_pf_rep_name);
4255: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4256: FOR c_sum IN c_asg_summation_details(/*c_master.assignment_id --Assignment ID
4257: ,*/c_org.pf_org_id --PF Org ID
4258: ,c_org.pf_num --PF Number
4259: ,p_effective_start_date

Line 4265: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4261: ,p_contribution_period)
4262: LOOP
4263: --PF Salary Annual Value
4264: l_tag :=pay_in_xml_utils.getTag('c_pf_salary_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.pf_ytd));
4265: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4266: -- Employee Total Contribution
4267: l_tag :=pay_in_xml_utils.getTag('c_epf_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employee));
4268: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4269: -- Employer Total Contribution

Line 4268: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4264: l_tag :=pay_in_xml_utils.getTag('c_pf_salary_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.pf_ytd));
4265: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4266: -- Employee Total Contribution
4267: l_tag :=pay_in_xml_utils.getTag('c_epf_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employee));
4268: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4269: -- Employer Total Contribution
4270: l_tag :=pay_in_xml_utils.getTag('c_epf_difference_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employer));
4271: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4272: -- Pension

Line 4271: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4267: l_tag :=pay_in_xml_utils.getTag('c_epf_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employee));
4268: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4269: -- Employer Total Contribution
4270: l_tag :=pay_in_xml_utils.getTag('c_epf_difference_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employer));
4271: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4272: -- Pension
4273: l_tag :=pay_in_xml_utils.getTag('c_pension_fund_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.pension));
4274: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4275: --Total Employee Employer Contr

Line 4274: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4270: l_tag :=pay_in_xml_utils.getTag('c_epf_difference_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employer));
4271: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4272: -- Pension
4273: l_tag :=pay_in_xml_utils.getTag('c_pension_fund_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.pension));
4274: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4275: --Total Employee Employer Contr
4276: l_tag :=pay_in_xml_utils.getTag('c_employer_employee_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.total));
4277: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4278: END LOOP;

Line 4277: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4273: l_tag :=pay_in_xml_utils.getTag('c_pension_fund_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.pension));
4274: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4275: --Total Employee Employer Contr
4276: l_tag :=pay_in_xml_utils.getTag('c_employer_employee_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.total));
4277: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4278: END LOOP;
4279: pay_in_utils.set_location(g_debug,l_procedure, 110);
4280: --Current Date
4281: l_tag :=pay_in_xml_utils.getTag('c_current_date',to_char(SYSDATE,'DD-Mon-YYYY'));

Line 4282: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4278: END LOOP;
4279: pay_in_utils.set_location(g_debug,l_procedure, 110);
4280: --Current Date
4281: l_tag :=pay_in_xml_utils.getTag('c_current_date',to_char(SYSDATE,'DD-Mon-YYYY'));
4282: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4283: --Starting Year
4284: l_tag :=pay_in_xml_utils.getTag('c_start_year',to_char(p_effective_start_date,'YYYY'));
4285: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4286: --Ending Year

Line 4285: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4281: l_tag :=pay_in_xml_utils.getTag('c_current_date',to_char(SYSDATE,'DD-Mon-YYYY'));
4282: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4283: --Starting Year
4284: l_tag :=pay_in_xml_utils.getTag('c_start_year',to_char(p_effective_start_date,'YYYY'));
4285: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4286: --Ending Year
4287: l_tag :=pay_in_xml_utils.getTag('c_end_year',to_char(p_effective_end_date,'YYYY'));
4288: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4289: --Statuory Rate of Contribution

Line 4288: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4284: l_tag :=pay_in_xml_utils.getTag('c_start_year',to_char(p_effective_start_date,'YYYY'));
4285: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4286: --Ending Year
4287: l_tag :=pay_in_xml_utils.getTag('c_end_year',to_char(p_effective_end_date,'YYYY'));
4288: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4289: --Statuory Rate of Contribution
4290: SELECT ROUND(fnd_number.canonical_to_number(GLOBAL_VALUE)*100,2) INTO l_rate
4291: FROM FF_GLOBALS_F
4292: WHERE GLOBAL_NAME ='IN_EMPLOYEE_PF_PERCENT'

Line 4297: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4293: AND LEGISLATION_CODE='IN'
4294: AND p_effective_start_date BETWEEN effective_start_date AND p_effective_end_date;
4295:
4296: l_tag :=pay_in_xml_utils.getTag('c_stat_rate',to_number(l_rate,99.99));
4297: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4298: l_tag := '';
4299: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4300: pay_in_utils.set_location(g_debug,l_procedure, 120);
4301: END LOOP;

Line 4299: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4295:
4296: l_tag :=pay_in_xml_utils.getTag('c_stat_rate',to_number(l_rate,99.99));
4297: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4298: l_tag := '';
4299: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4300: pay_in_utils.set_location(g_debug,l_procedure, 120);
4301: END LOOP;
4302: END IF;
4303: END LOOP;

Line 4310: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4306: END IF;
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:

Line 4541: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);

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 :='';
4545: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 4542: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);

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 :='';
4545: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4546:

Line 4545: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

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 :='';
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...');

Line 4548: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4544: l_tag :='';
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.');

Line 4557: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

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);
4557: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4558:
4559:
4560: OPEN csr_global_value('IN_EPS_PERCENT');
4561: FETCH csr_global_value INTO l_eps_percent ;

Line 4638: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4634: FETCH csr_employee_details INTO l_employee_name,l_fath_husb_name,l_hire_date;
4635: CLOSE csr_employee_details;
4636:
4637: l_tag := '';
4638: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4639:
4640:
4641: -- Reset these variables for each pension number
4642: l_count :=1;

Line 4821: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4817: pay_in_xml_utils.multiColumnar('Organization',g_org_XMLTable,l_org_count,g_xml_data);
4818:
4819: --Current Date
4820: l_tag :=pay_in_xml_utils.getTag('c_current_date',to_char(sysdate,'DD-Mon-YYYY'));
4821: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4822:
4823: --Starting Year
4824: l_tag :=pay_in_xml_utils.getTag('c_start_year',to_char(p_effective_start_date,'YYYY'));
4825: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 4825: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4821: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4822:
4823: --Starting Year
4824: l_tag :=pay_in_xml_utils.getTag('c_start_year',to_char(p_effective_start_date,'YYYY'));
4825: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4826: --Ending Year
4827: l_tag :=pay_in_xml_utils.getTag('c_end_year',to_char(p_effective_end_date,'YYYY'));
4828: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4829:

Line 4828: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4824: l_tag :=pay_in_xml_utils.getTag('c_start_year',to_char(p_effective_start_date,'YYYY'));
4825: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4826: --Ending Year
4827: l_tag :=pay_in_xml_utils.getTag('c_end_year',to_char(p_effective_end_date,'YYYY'));
4828: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4829:
4830: l_tag := '';
4831: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4832: END IF;-- Excluded employee status end

Line 4831: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

4827: l_tag :=pay_in_xml_utils.getTag('c_end_year',to_char(p_effective_end_date,'YYYY'));
4828: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4829:
4830: l_tag := '';
4831: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4832: END IF;-- Excluded employee status end
4833: END IF; -- Employee Type Check End
4834:
4835: END LOOP; -- End each pension number

Line 4841: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

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);
4842: fnd_file.put_line(fnd_file.log,'XML Created.');
4843: END create_form7_xml;
4844: --------------------------------------------------------------------------
4845: -- --

Line 5562: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);

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 :='';
5566: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5563: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);

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 :='';
5566: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5567: l_tag := '';

Line 5566: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

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 :='';
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: --

Line 5568: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5564: --
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');

Line 5575: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

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);
5576: pay_in_utils.set_location(g_debug,l_procedure, 20);
5577:
5578: FOR c_rec IN c_distinct_org
5579: LOOP

Line 5596: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);

5592: ,l_rep_addr
5593: ,l_org_name;
5594: CLOSE c_org_details;
5595: --Starting Writing the data for this org on to the local clob varaible
5596: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);
5597: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
5598: l_tag :='';
5599: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5600: l_tag :=pay_in_xml_utils.getTag('c_employer_code',l_employer_code);

Line 5597: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);

5593: ,l_org_name;
5594: CLOSE c_org_details;
5595: --Starting Writing the data for this org on to the local clob varaible
5596: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);
5597: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
5598: l_tag :='';
5599: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5600: l_tag :=pay_in_xml_utils.getTag('c_employer_code',l_employer_code);
5601: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5599: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5595: --Starting Writing the data for this org on to the local clob varaible
5596: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);
5597: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
5598: l_tag :='';
5599: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5600: l_tag :=pay_in_xml_utils.getTag('c_employer_code',l_employer_code);
5601: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5602: --Organization Name made in BLOCK
5603: l_tag :=pay_in_xml_utils.getTag('c_registered_name',upper(l_registered_name));

Line 5601: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5597: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
5598: l_tag :='';
5599: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5600: l_tag :=pay_in_xml_utils.getTag('c_employer_code',l_employer_code);
5601: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5602: --Organization Name made in BLOCK
5603: l_tag :=pay_in_xml_utils.getTag('c_registered_name',upper(l_registered_name));
5604: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5605: l_tag :=pay_in_xml_utils.getTag('c_address',l_reg_address);

Line 5604: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5600: l_tag :=pay_in_xml_utils.getTag('c_employer_code',l_employer_code);
5601: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5602: --Organization Name made in BLOCK
5603: l_tag :=pay_in_xml_utils.getTag('c_registered_name',upper(l_registered_name));
5604: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5605: l_tag :=pay_in_xml_utils.getTag('c_address',l_reg_address);
5606: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5607: --Organization Rep Name made in BLOCK
5608: l_tag :=pay_in_xml_utils.getTag('c_rep_name',upper(l_rep_name));

Line 5606: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5602: --Organization Name made in BLOCK
5603: l_tag :=pay_in_xml_utils.getTag('c_registered_name',upper(l_registered_name));
5604: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5605: l_tag :=pay_in_xml_utils.getTag('c_address',l_reg_address);
5606: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5607: --Organization Rep Name made in BLOCK
5608: l_tag :=pay_in_xml_utils.getTag('c_rep_name',upper(l_rep_name));
5609: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5610: l_tag :=pay_in_xml_utils.getTag('c_rep_desg',l_rep_desg);

Line 5609: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5605: l_tag :=pay_in_xml_utils.getTag('c_address',l_reg_address);
5606: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5607: --Organization Rep Name made in BLOCK
5608: l_tag :=pay_in_xml_utils.getTag('c_rep_name',upper(l_rep_name));
5609: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5610: l_tag :=pay_in_xml_utils.getTag('c_rep_desg',l_rep_desg);
5611: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5612: l_tag :=pay_in_xml_utils.getTag('c_rep_address',l_rep_addr);
5613: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5611: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5607: --Organization Rep Name made in BLOCK
5608: l_tag :=pay_in_xml_utils.getTag('c_rep_name',upper(l_rep_name));
5609: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5610: l_tag :=pay_in_xml_utils.getTag('c_rep_desg',l_rep_desg);
5611: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5612: l_tag :=pay_in_xml_utils.getTag('c_rep_address',l_rep_addr);
5613: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5614: l_tag :=pay_in_xml_utils.getTag('c_local_office',l_org_name);
5615: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5613: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5609: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5610: l_tag :=pay_in_xml_utils.getTag('c_rep_desg',l_rep_desg);
5611: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5612: l_tag :=pay_in_xml_utils.getTag('c_rep_address',l_rep_addr);
5613: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5614: l_tag :=pay_in_xml_utils.getTag('c_local_office',l_org_name);
5615: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5616:
5617: --Organization Specific Data written on the CLOB. Finding Contribution Periods

Line 5615: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5611: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5612: l_tag :=pay_in_xml_utils.getTag('c_rep_address',l_rep_addr);
5613: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5614: l_tag :=pay_in_xml_utils.getTag('c_local_office',l_org_name);
5615: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5616:
5617: --Organization Specific Data written on the CLOB. Finding Contribution Periods
5618: l_contr_start := substr(p_contribution_period,1,8);
5619: l_contr_end := substr(p_contribution_period,11);

Line 5621: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5617: --Organization Specific Data written on the CLOB. Finding Contribution Periods
5618: l_contr_start := substr(p_contribution_period,1,8);
5619: l_contr_end := substr(p_contribution_period,11);
5620: l_tag :=pay_in_xml_utils.getTag('c_contr_start',l_contr_start);
5621: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5622: l_tag :=pay_in_xml_utils.getTag('c_contr_end',l_contr_end);
5623: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5624: --Details of Contribution Period written to the CLOB.Finding Employee Details
5625: l_count := 1;

Line 5623: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5619: l_contr_end := substr(p_contribution_period,11);
5620: l_tag :=pay_in_xml_utils.getTag('c_contr_start',l_contr_start);
5621: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5622: l_tag :=pay_in_xml_utils.getTag('c_contr_end',l_contr_end);
5623: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5624: --Details of Contribution Period written to the CLOB.Finding Employee Details
5625: l_count := 1;
5626: l_employer_total := 0;
5627: l_employee_total := 0;

Line 5745: dbms_lob.Append(g_xml_data,l_xml_data);

5741: l_employer_total := l_employer_total + nvl(l_employer_contr,0);
5742: l_employee_total := l_employee_total + nvl(l_employee_contr,0);
5743:
5744: IF flag THEN
5745: dbms_lob.Append(g_xml_data,l_xml_data);
5746: flag := FALSE;
5747: END IF;
5748: l_tag :='';
5749: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5749: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5745: dbms_lob.Append(g_xml_data,l_xml_data);
5746: flag := FALSE;
5747: END IF;
5748: l_tag :='';
5749: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5750: l_tag :=pay_in_xml_utils.getTag('c_sl_no',l_count);
5751: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5752: l_tag :=pay_in_xml_utils.getTag('c_insurance_number',l_insurance_no);
5753: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5751: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5747: END IF;
5748: l_tag :='';
5749: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5750: l_tag :=pay_in_xml_utils.getTag('c_sl_no',l_count);
5751: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5752: l_tag :=pay_in_xml_utils.getTag('c_insurance_number',l_insurance_no);
5753: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5754: l_tag :=pay_in_xml_utils.getTag('c_full_name',l_full_name);
5755: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5753: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5749: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5750: l_tag :=pay_in_xml_utils.getTag('c_sl_no',l_count);
5751: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5752: l_tag :=pay_in_xml_utils.getTag('c_insurance_number',l_insurance_no);
5753: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5754: l_tag :=pay_in_xml_utils.getTag('c_full_name',l_full_name);
5755: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5756: l_tag :=pay_in_xml_utils.getTag('c_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_actual_salary));
5757: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5755: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5751: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5752: l_tag :=pay_in_xml_utils.getTag('c_insurance_number',l_insurance_no);
5753: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5754: l_tag :=pay_in_xml_utils.getTag('c_full_name',l_full_name);
5755: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5756: l_tag :=pay_in_xml_utils.getTag('c_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_actual_salary));
5757: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5758: l_tag :=pay_in_xml_utils.getTag('c_employee_contr',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_contr));
5759: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5757: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5753: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5754: l_tag :=pay_in_xml_utils.getTag('c_full_name',l_full_name);
5755: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5756: l_tag :=pay_in_xml_utils.getTag('c_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_actual_salary));
5757: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5758: l_tag :=pay_in_xml_utils.getTag('c_employee_contr',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_contr));
5759: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5760: l_tag :=pay_in_xml_utils.getTag('c_esi_coverage',l_esi_coverage);
5761: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5759: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5755: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5756: l_tag :=pay_in_xml_utils.getTag('c_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_actual_salary));
5757: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5758: l_tag :=pay_in_xml_utils.getTag('c_employee_contr',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_contr));
5759: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5760: l_tag :=pay_in_xml_utils.getTag('c_esi_coverage',l_esi_coverage);
5761: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5762: l_tag :=pay_in_xml_utils.getTag('c_remarks',l_remarks);
5763: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5761: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5757: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5758: l_tag :=pay_in_xml_utils.getTag('c_employee_contr',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_contr));
5759: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5760: l_tag :=pay_in_xml_utils.getTag('c_esi_coverage',l_esi_coverage);
5761: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5762: l_tag :=pay_in_xml_utils.getTag('c_remarks',l_remarks);
5763: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5764: l_tag :=pay_in_xml_utils.getTag('c_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days));
5765: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5763: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5759: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5760: l_tag :=pay_in_xml_utils.getTag('c_esi_coverage',l_esi_coverage);
5761: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5762: l_tag :=pay_in_xml_utils.getTag('c_remarks',l_remarks);
5763: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5764: l_tag :=pay_in_xml_utils.getTag('c_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days));
5765: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5766: l_tag :=pay_in_xml_utils.getTag('c_avg_daily_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_avg_daily_wage));
5767: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5765: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5761: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5762: l_tag :=pay_in_xml_utils.getTag('c_remarks',l_remarks);
5763: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5764: l_tag :=pay_in_xml_utils.getTag('c_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days));
5765: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5766: l_tag :=pay_in_xml_utils.getTag('c_avg_daily_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_avg_daily_wage));
5767: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5768: l_tag :='';
5769: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5767: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5763: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5764: l_tag :=pay_in_xml_utils.getTag('c_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days));
5765: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5766: l_tag :=pay_in_xml_utils.getTag('c_avg_daily_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_avg_daily_wage));
5767: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5768: l_tag :='';
5769: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5770: l_count := l_count + 1;
5771: l_con_tot := l_con_tot + nvl(l_employee_contr,0);

Line 5769: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5765: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5766: l_tag :=pay_in_xml_utils.getTag('c_avg_daily_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_avg_daily_wage));
5767: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5768: l_tag :='';
5769: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5770: l_count := l_count + 1;
5771: l_con_tot := l_con_tot + nvl(l_employee_contr,0);
5772: l_wages_tot := l_wages_tot + nvl(l_actual_salary,0);
5773: l_days_tot := l_days_tot + nvl(l_days,0);

Line 5778: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5774: END IF;
5775: END LOOP;
5776:
5777: l_tag :=pay_in_xml_utils.getTag('c_total_con',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_con_tot));
5778: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5779: l_tag :=pay_in_xml_utils.getTag('c_total_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_tot));
5780: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5781: l_tag :=pay_in_xml_utils.getTag('c_total_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days_tot));
5782: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5780: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5776:
5777: l_tag :=pay_in_xml_utils.getTag('c_total_con',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_con_tot));
5778: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5779: l_tag :=pay_in_xml_utils.getTag('c_total_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_tot));
5780: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5781: l_tag :=pay_in_xml_utils.getTag('c_total_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days_tot));
5782: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5783:
5784: dbms_lob.close(l_xml_data);

Line 5782: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5778: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5779: l_tag :=pay_in_xml_utils.getTag('c_total_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_tot));
5780: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5781: l_tag :=pay_in_xml_utils.getTag('c_total_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days_tot));
5782: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5783:
5784: dbms_lob.close(l_xml_data);
5785: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);
5786: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);

Line 5784: dbms_lob.close(l_xml_data);

5780: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5781: l_tag :=pay_in_xml_utils.getTag('c_total_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days_tot));
5782: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5783:
5784: dbms_lob.close(l_xml_data);
5785: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);
5786: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
5787: --Employer Share, Employee Share and Total Contribution
5788: l_tag :=pay_in_xml_utils.getTag('c_employer_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employer_total));

Line 5785: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);

5781: l_tag :=pay_in_xml_utils.getTag('c_total_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days_tot));
5782: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5783:
5784: dbms_lob.close(l_xml_data);
5785: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);
5786: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
5787: --Employer Share, Employee Share and Total Contribution
5788: l_tag :=pay_in_xml_utils.getTag('c_employer_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employer_total));
5789: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5786: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);

5782: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5783:
5784: dbms_lob.close(l_xml_data);
5785: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);
5786: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
5787: --Employer Share, Employee Share and Total Contribution
5788: l_tag :=pay_in_xml_utils.getTag('c_employer_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employer_total));
5789: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5790: l_tag :=pay_in_xml_utils.getTag('c_employee_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total));

Line 5789: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5785: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);
5786: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
5787: --Employer Share, Employee Share and Total Contribution
5788: l_tag :=pay_in_xml_utils.getTag('c_employer_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employer_total));
5789: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5790: l_tag :=pay_in_xml_utils.getTag('c_employee_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total));
5791: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5792: l_tag :=pay_in_xml_utils.getTag('c_total',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total + l_employer_total));
5793: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5791: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5787: --Employer Share, Employee Share and Total Contribution
5788: l_tag :=pay_in_xml_utils.getTag('c_employer_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employer_total));
5789: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5790: l_tag :=pay_in_xml_utils.getTag('c_employee_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total));
5791: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5792: l_tag :=pay_in_xml_utils.getTag('c_total',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total + l_employer_total));
5793: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5794: --Challan Details
5795: l_count := 1;

Line 5793: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5789: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5790: l_tag :=pay_in_xml_utils.getTag('c_employee_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total));
5791: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5792: l_tag :=pay_in_xml_utils.getTag('c_total',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total + l_employer_total));
5793: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5794: --Challan Details
5795: l_count := 1;
5796: l_challan_tot := 0;
5797: pay_in_utils.set_location(g_debug,l_procedure, 100);

Line 5807: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5803: CLOSE c_branch_dtls;
5804:
5805:
5806: l_tag :='';
5807: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5808: l_tag :=pay_in_xml_utils.getTag('c_sl',l_count);
5809: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5810: l_tag :=pay_in_xml_utils.getTag('c_month',c_challan_rec.month);
5811: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5809: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5805:
5806: l_tag :='';
5807: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5808: l_tag :=pay_in_xml_utils.getTag('c_sl',l_count);
5809: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5810: l_tag :=pay_in_xml_utils.getTag('c_month',c_challan_rec.month);
5811: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5812: l_tag :=pay_in_xml_utils.getTag('c_challan_date',c_challan_rec.challan_date);
5813: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5811: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5807: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5808: l_tag :=pay_in_xml_utils.getTag('c_sl',l_count);
5809: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5810: l_tag :=pay_in_xml_utils.getTag('c_month',c_challan_rec.month);
5811: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5812: l_tag :=pay_in_xml_utils.getTag('c_challan_date',c_challan_rec.challan_date);
5813: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5814: l_tag :=pay_in_xml_utils.getTag('c_challan_paid',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_challan_rec.challan_amt));
5815: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5813: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5809: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5810: l_tag :=pay_in_xml_utils.getTag('c_month',c_challan_rec.month);
5811: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5812: l_tag :=pay_in_xml_utils.getTag('c_challan_date',c_challan_rec.challan_date);
5813: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5814: l_tag :=pay_in_xml_utils.getTag('c_challan_paid',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_challan_rec.challan_amt));
5815: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5816: l_tag :=pay_in_xml_utils.getTag('c_challan_bank',c_challan_rec.challan_bank);
5817: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5815: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5811: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5812: l_tag :=pay_in_xml_utils.getTag('c_challan_date',c_challan_rec.challan_date);
5813: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5814: l_tag :=pay_in_xml_utils.getTag('c_challan_paid',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_challan_rec.challan_amt));
5815: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5816: l_tag :=pay_in_xml_utils.getTag('c_challan_bank',c_challan_rec.challan_bank);
5817: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5818: l_tag :=pay_in_xml_utils.getTag('c_challan_branch',l_bank_branch_name);
5819: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5817: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5813: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5814: l_tag :=pay_in_xml_utils.getTag('c_challan_paid',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_challan_rec.challan_amt));
5815: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5816: l_tag :=pay_in_xml_utils.getTag('c_challan_bank',c_challan_rec.challan_bank);
5817: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5818: l_tag :=pay_in_xml_utils.getTag('c_challan_branch',l_bank_branch_name);
5819: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5820: l_challan_tot := l_challan_tot + nvl(c_challan_rec.challan_amt,0);
5821: l_count := l_count + 1;

Line 5819: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5815: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5816: l_tag :=pay_in_xml_utils.getTag('c_challan_bank',c_challan_rec.challan_bank);
5817: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5818: l_tag :=pay_in_xml_utils.getTag('c_challan_branch',l_bank_branch_name);
5819: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5820: l_challan_tot := l_challan_tot + nvl(c_challan_rec.challan_amt,0);
5821: l_count := l_count + 1;
5822: l_tag :='';
5823: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5823: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5819: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5820: l_challan_tot := l_challan_tot + nvl(c_challan_rec.challan_amt,0);
5821: l_count := l_count + 1;
5822: l_tag :='';
5823: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5824: END LOOP;
5825: l_tag :=pay_in_xml_utils.getTag('c_challan_total',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_challan_tot));
5826: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5827:

Line 5826: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5822: l_tag :='';
5823: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5824: END LOOP;
5825: l_tag :=pay_in_xml_utils.getTag('c_challan_total',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_challan_tot));
5826: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5827:
5828:
5829: --Declaration Details
5830: OPEN c_declaration(c_rec.org_id);

Line 5847: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5843: ,l_wages_immd_emplr_not_covered ;
5844: CLOSE c_declaration ;
5845:
5846: l_tag := '';
5847: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5848: l_tag :=pay_in_xml_utils.getTag('c_declaration_forms',l_declaration_forms);
5849: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5850: l_tag := pay_in_xml_utils.getTag('c_tic',l_tic);
5851: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5849: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5845:
5846: l_tag := '';
5847: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5848: l_tag :=pay_in_xml_utils.getTag('c_declaration_forms',l_declaration_forms);
5849: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5850: l_tag := pay_in_xml_utils.getTag('c_tic',l_tic);
5851: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5852: l_tag := pay_in_xml_utils.getTag('c_pic_received',l_pic_received);
5853: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5851: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5847: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5848: l_tag :=pay_in_xml_utils.getTag('c_declaration_forms',l_declaration_forms);
5849: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5850: l_tag := pay_in_xml_utils.getTag('c_tic',l_tic);
5851: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5852: l_tag := pay_in_xml_utils.getTag('c_pic_received',l_pic_received);
5853: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5854: l_tag := pay_in_xml_utils.getTag('c_pic_distributed',l_pic_distributed);
5855: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5853: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5849: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5850: l_tag := pay_in_xml_utils.getTag('c_tic',l_tic);
5851: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5852: l_tag := pay_in_xml_utils.getTag('c_pic_received',l_pic_received);
5853: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5854: l_tag := pay_in_xml_utils.getTag('c_pic_distributed',l_pic_distributed);
5855: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5856: l_tag := pay_in_xml_utils.getTag('c_accidents_reported',l_accidents_reported);
5857: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5855: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5851: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5852: l_tag := pay_in_xml_utils.getTag('c_pic_received',l_pic_received);
5853: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5854: l_tag := pay_in_xml_utils.getTag('c_pic_distributed',l_pic_distributed);
5855: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5856: l_tag := pay_in_xml_utils.getTag('c_accidents_reported',l_accidents_reported);
5857: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5858: l_tag := pay_in_xml_utils.getTag('c_direct_covered_employees',l_direct_covered_employees);
5859: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5857: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5853: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5854: l_tag := pay_in_xml_utils.getTag('c_pic_distributed',l_pic_distributed);
5855: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5856: l_tag := pay_in_xml_utils.getTag('c_accidents_reported',l_accidents_reported);
5857: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5858: l_tag := pay_in_xml_utils.getTag('c_direct_covered_employees',l_direct_covered_employees);
5859: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5860: l_tag := pay_in_xml_utils.getTag('c_direct_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_covered_wages));
5861: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5859: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5855: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5856: l_tag := pay_in_xml_utils.getTag('c_accidents_reported',l_accidents_reported);
5857: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5858: l_tag := pay_in_xml_utils.getTag('c_direct_covered_employees',l_direct_covered_employees);
5859: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5860: l_tag := pay_in_xml_utils.getTag('c_direct_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_covered_wages));
5861: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5862: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_employees',l_direct_not_covered_employees);
5863: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5861: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5857: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5858: l_tag := pay_in_xml_utils.getTag('c_direct_covered_employees',l_direct_covered_employees);
5859: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5860: l_tag := pay_in_xml_utils.getTag('c_direct_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_covered_wages));
5861: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5862: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_employees',l_direct_not_covered_employees);
5863: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5864: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_not_covered_wages));
5865: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5863: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5859: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5860: l_tag := pay_in_xml_utils.getTag('c_direct_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_covered_wages));
5861: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5862: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_employees',l_direct_not_covered_employees);
5863: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5864: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_not_covered_wages));
5865: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5866: l_tag := pay_in_xml_utils.getTag('c_immediate_employer_covered',l_immediate_employer_covered);
5867: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5865: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5861: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5862: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_employees',l_direct_not_covered_employees);
5863: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5864: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_not_covered_wages));
5865: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5866: l_tag := pay_in_xml_utils.getTag('c_immediate_employer_covered',l_immediate_employer_covered);
5867: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5868: l_tag := pay_in_xml_utils.getTag('c_wages_immediate_emplr_cover',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immediate_emplr_cover));
5869: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5867: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5863: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5864: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_not_covered_wages));
5865: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5866: l_tag := pay_in_xml_utils.getTag('c_immediate_employer_covered',l_immediate_employer_covered);
5867: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5868: l_tag := pay_in_xml_utils.getTag('c_wages_immediate_emplr_cover',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immediate_emplr_cover));
5869: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5870: l_tag := pay_in_xml_utils.getTag('c_immediate_emplr_not_covered',l_immediate_emplr_not_covered);
5871: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5869: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5865: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5866: l_tag := pay_in_xml_utils.getTag('c_immediate_employer_covered',l_immediate_employer_covered);
5867: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5868: l_tag := pay_in_xml_utils.getTag('c_wages_immediate_emplr_cover',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immediate_emplr_cover));
5869: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5870: l_tag := pay_in_xml_utils.getTag('c_immediate_emplr_not_covered',l_immediate_emplr_not_covered);
5871: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5872: l_tag := pay_in_xml_utils.getTag('c_wages_immd_emplr_not_covered',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immd_emplr_not_covered));
5873: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5871: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5867: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5868: l_tag := pay_in_xml_utils.getTag('c_wages_immediate_emplr_cover',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immediate_emplr_cover));
5869: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5870: l_tag := pay_in_xml_utils.getTag('c_immediate_emplr_not_covered',l_immediate_emplr_not_covered);
5871: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5872: l_tag := pay_in_xml_utils.getTag('c_wages_immd_emplr_not_covered',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immd_emplr_not_covered));
5873: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5874: l_tag := '';
5875: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

Line 5873: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5869: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5870: l_tag := pay_in_xml_utils.getTag('c_immediate_emplr_not_covered',l_immediate_emplr_not_covered);
5871: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5872: l_tag := pay_in_xml_utils.getTag('c_wages_immd_emplr_not_covered',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immd_emplr_not_covered));
5873: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5874: l_tag := '';
5875: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5876:
5877:

Line 5875: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5871: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5872: l_tag := pay_in_xml_utils.getTag('c_wages_immd_emplr_not_covered',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immd_emplr_not_covered));
5873: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5874: l_tag := '';
5875: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5876:
5877:
5878:
5879: --Element Details computing the Base Salary for ESI Calculation.

Line 5884: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5880: l_count := 1;
5881: FOR rec_elements IN c_elements
5882: LOOP
5883: l_tag := '';
5884: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5885: l_tag :=pay_in_xml_utils.getTag('c_sl_no',l_count);
5886: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5887: l_count := l_count + 1;
5888: l_tag := pay_in_xml_utils.getTag('c_elements',rec_elements.element_name);

Line 5886: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5882: LOOP
5883: l_tag := '';
5884: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5885: l_tag :=pay_in_xml_utils.getTag('c_sl_no',l_count);
5886: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5887: l_count := l_count + 1;
5888: l_tag := pay_in_xml_utils.getTag('c_elements',rec_elements.element_name);
5889: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5890: l_tag := '';

Line 5889: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5885: l_tag :=pay_in_xml_utils.getTag('c_sl_no',l_count);
5886: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5887: l_count := l_count + 1;
5888: l_tag := pay_in_xml_utils.getTag('c_elements',rec_elements.element_name);
5889: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5890: l_tag := '';
5891: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5892: END LOOP ;
5893:

Line 5891: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5887: l_count := l_count + 1;
5888: l_tag := pay_in_xml_utils.getTag('c_elements',rec_elements.element_name);
5889: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5890: l_tag := '';
5891: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5892: END LOOP ;
5893:
5894:
5895: l_tag :='';

Line 5896: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);

5892: END LOOP ;
5893:
5894:
5895: l_tag :='';
5896: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5897: IF flag = FALSE THEN
5898: dbms_lob.Append(g_xml_data,l_xml_data);
5899: END IF;
5900: dbms_lob.close(l_xml_data);

Line 5898: dbms_lob.Append(g_xml_data,l_xml_data);

5894:
5895: l_tag :='';
5896: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5897: IF flag = FALSE THEN
5898: dbms_lob.Append(g_xml_data,l_xml_data);
5899: END IF;
5900: dbms_lob.close(l_xml_data);
5901: pay_in_utils.set_location(g_debug,l_procedure, 110);
5902: END LOOP;

Line 5900: dbms_lob.close(l_xml_data);

5896: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5897: IF flag = FALSE THEN
5898: dbms_lob.Append(g_xml_data,l_xml_data);
5899: END IF;
5900: dbms_lob.close(l_xml_data);
5901: pay_in_utils.set_location(g_debug,l_procedure, 110);
5902: END LOOP;
5903: l_tag :='';
5904: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 5904: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

5900: dbms_lob.close(l_xml_data);
5901: pay_in_utils.set_location(g_debug,l_procedure, 110);
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: