eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IE_P45_ARCHIVE dependencies on FND_FILE

Line 4981: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

4977:
4978:
4979: -- P45File root ELEMENT
4980: IF (to_number(to_char(to_date(l_start_date,'yyyy/mm/dd'),'yyyy')) >= 2012) THEN -- 13359530
4981: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
4982: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_start_tag_new1);
4983: ELSE
4984: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
4985: IF (to_number(to_char(to_date(l_start_date,'yyyy/mm/dd'),'yyyy')) >= 2009) THEN -- 7291676

Line 4982: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_start_tag_new1);

4978:
4979: -- P45File root ELEMENT
4980: IF (to_number(to_char(to_date(l_start_date,'yyyy/mm/dd'),'yyyy')) >= 2012) THEN -- 13359530
4981: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
4982: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_start_tag_new1);
4983: ELSE
4984: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
4985: IF (to_number(to_char(to_date(l_start_date,'yyyy/mm/dd'),'yyyy')) >= 2009) THEN -- 7291676
4986: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_start_tag_new);

Line 4984: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

4980: IF (to_number(to_char(to_date(l_start_date,'yyyy/mm/dd'),'yyyy')) >= 2012) THEN -- 13359530
4981: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
4982: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_start_tag_new1);
4983: ELSE
4984: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
4985: IF (to_number(to_char(to_date(l_start_date,'yyyy/mm/dd'),'yyyy')) >= 2009) THEN -- 7291676
4986: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_start_tag_new);
4987: ELSE
4988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_start_tag);

Line 4986: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_start_tag_new);

4982: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_start_tag_new1);
4983: ELSE
4984: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
4985: IF (to_number(to_char(to_date(l_start_date,'yyyy/mm/dd'),'yyyy')) >= 2009) THEN -- 7291676
4986: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_start_tag_new);
4987: ELSE
4988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_start_tag);
4989: END IF;
4990: END IF;

Line 4988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_start_tag);

4984: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
4985: IF (to_number(to_char(to_date(l_start_date,'yyyy/mm/dd'),'yyyy')) >= 2009) THEN -- 7291676
4986: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_start_tag_new);
4987: ELSE
4988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_start_tag);
4989: END IF;
4990: END IF;
4991:
4992: -- Get Employer Address

Line 5002: FND_FILE.PUT(FND_FILE.OUTPUT,'

4998: ,l_employer_phone
4999: ,l_employer_name;
5000: CLOSE cur_employer_address;
5001: -- Employer ELEMENT
5002: FND_FILE.PUT(FND_FILE.OUTPUT,' 5003: FND_FILE.PUT(FND_FILE.OUTPUT,'number="' || l_employer_number ||'" ');
5004: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || l_employer_name ||'" ');
5005: IF l_employer_add1 IS NOT NULL THEN
5006: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_employer_add1 ||'" ');

Line 5003: FND_FILE.PUT(FND_FILE.OUTPUT,'number="' || l_employer_number ||'" ');

4999: ,l_employer_name;
5000: CLOSE cur_employer_address;
5001: -- Employer ELEMENT
5002: FND_FILE.PUT(FND_FILE.OUTPUT,' 5003: FND_FILE.PUT(FND_FILE.OUTPUT,'number="' || l_employer_number ||'" ');
5004: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || l_employer_name ||'" ');
5005: IF l_employer_add1 IS NOT NULL THEN
5006: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_employer_add1 ||'" ');
5007: END IF;

Line 5004: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || l_employer_name ||'" ');

5000: CLOSE cur_employer_address;
5001: -- Employer ELEMENT
5002: FND_FILE.PUT(FND_FILE.OUTPUT,' 5003: FND_FILE.PUT(FND_FILE.OUTPUT,'number="' || l_employer_number ||'" ');
5004: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || l_employer_name ||'" ');
5005: IF l_employer_add1 IS NOT NULL THEN
5006: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_employer_add1 ||'" ');
5007: END IF;
5008: IF l_employer_add2 IS NOT NULL THEN

Line 5006: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_employer_add1 ||'" ');

5002: FND_FILE.PUT(FND_FILE.OUTPUT,' 5003: FND_FILE.PUT(FND_FILE.OUTPUT,'number="' || l_employer_number ||'" ');
5004: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || l_employer_name ||'" ');
5005: IF l_employer_add1 IS NOT NULL THEN
5006: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_employer_add1 ||'" ');
5007: END IF;
5008: IF l_employer_add2 IS NOT NULL THEN
5009: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || l_employer_add2 ||'" ');
5010: END IF;

Line 5009: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || l_employer_add2 ||'" ');

5005: IF l_employer_add1 IS NOT NULL THEN
5006: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_employer_add1 ||'" ');
5007: END IF;
5008: IF l_employer_add2 IS NOT NULL THEN
5009: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || l_employer_add2 ||'" ');
5010: END IF;
5011: IF l_employer_add3 IS NOT NULL THEN
5012: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_employer_add3 ||'" ');
5013: END IF;

Line 5012: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_employer_add3 ||'" ');

5008: IF l_employer_add2 IS NOT NULL THEN
5009: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || l_employer_add2 ||'" ');
5010: END IF;
5011: IF l_employer_add3 IS NOT NULL THEN
5012: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_employer_add3 ||'" ');
5013: END IF;
5014: FND_FILE.PUT(FND_FILE.OUTPUT,'contact="' || l_employer_contact ||'" ');
5015: IF l_employer_phone IS NOT NULL THEN
5016: FND_FILE.PUT(FND_FILE.OUTPUT,'phone="' || l_employer_phone ||'" ');

Line 5014: FND_FILE.PUT(FND_FILE.OUTPUT,'contact="' || l_employer_contact ||'" ');

5010: END IF;
5011: IF l_employer_add3 IS NOT NULL THEN
5012: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_employer_add3 ||'" ');
5013: END IF;
5014: FND_FILE.PUT(FND_FILE.OUTPUT,'contact="' || l_employer_contact ||'" ');
5015: IF l_employer_phone IS NOT NULL THEN
5016: FND_FILE.PUT(FND_FILE.OUTPUT,'phone="' || l_employer_phone ||'" ');
5017: END IF;
5018: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

Line 5016: FND_FILE.PUT(FND_FILE.OUTPUT,'phone="' || l_employer_phone ||'" ');

5012: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_employer_add3 ||'" ');
5013: END IF;
5014: FND_FILE.PUT(FND_FILE.OUTPUT,'contact="' || l_employer_contact ||'" ');
5015: IF l_employer_phone IS NOT NULL THEN
5016: FND_FILE.PUT(FND_FILE.OUTPUT,'phone="' || l_employer_phone ||'" ');
5017: END IF;
5018: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5019: -- End of Employer
5020: once_per_run := 'Y';

Line 5018: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5014: FND_FILE.PUT(FND_FILE.OUTPUT,'contact="' || l_employer_contact ||'" ');
5015: IF l_employer_phone IS NOT NULL THEN
5016: FND_FILE.PUT(FND_FILE.OUTPUT,'phone="' || l_employer_phone ||'" ');
5017: END IF;
5018: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5019: -- End of Employer
5020: once_per_run := 'Y';
5021: END IF;
5022: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) >= 2009) THEN -- 7291676

Line 5024: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

5020: once_per_run := 'Y';
5021: END IF;
5022: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) >= 2009) THEN -- 7291676
5023: IF p45_rec.supp_flag = 'N' THEN
5024: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5025: ELSE
5026: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5027: END IF;
5028: -- Employee

Line 5026: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

5022: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) >= 2009) THEN -- 7291676
5023: IF p45_rec.supp_flag = 'N' THEN
5024: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5025: ELSE
5026: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5027: END IF;
5028: -- Employee
5029: FND_FILE.PUT(FND_FILE.OUTPUT,' 5030: IF cur_p45_emp_details_rec.ppsn IS NOT NULL THEN -- Optional

Line 5029: FND_FILE.PUT(FND_FILE.OUTPUT,'

5025: ELSE
5026: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5027: END IF;
5028: -- Employee
5029: FND_FILE.PUT(FND_FILE.OUTPUT,' 5030: IF cur_p45_emp_details_rec.ppsn IS NOT NULL THEN -- Optional
5031: /* 7291676 */
5032: l_ppsn_override:=null;
5033: open csr_ppsn_override(p45_rec.assignment_id);

Line 5036: FND_FILE.PUT(FND_FILE.OUTPUT,'ppsn="' ||nvl(l_ppsn_override, cur_p45_emp_details_rec.ppsn ) ||'" ');

5032: l_ppsn_override:=null;
5033: open csr_ppsn_override(p45_rec.assignment_id);
5034: fetch csr_ppsn_override into l_ppsn_override;
5035: close csr_ppsn_override;
5036: FND_FILE.PUT(FND_FILE.OUTPUT,'ppsn="' ||nvl(l_ppsn_override, cur_p45_emp_details_rec.ppsn ) ||'" ');
5037: ppsn_flag := 1;
5038: ELSE
5039: ppsn_flag := 0;
5040: END IF;

Line 5043: FND_FILE.PUT(FND_FILE.OUTPUT,'surname="' || l_sur_name ||'" ');

5039: ppsn_flag := 0;
5040: END IF;
5041:
5042: -- required
5043: FND_FILE.PUT(FND_FILE.OUTPUT,'surname="' || l_sur_name ||'" ');
5044: FND_FILE.PUT(FND_FILE.OUTPUT,'firstnames="' || l_first_name ||'" ');
5045: IF cur_p45_emp_details_rec.works IS NOT NULL THEN -- Optional
5046: FND_FILE.PUT(FND_FILE.OUTPUT,'works="' || replace(cur_p45_emp_details_rec.works,'-','') ||'" '); /* 7827732 */
5047: END IF;

Line 5044: FND_FILE.PUT(FND_FILE.OUTPUT,'firstnames="' || l_first_name ||'" ');

5040: END IF;
5041:
5042: -- required
5043: FND_FILE.PUT(FND_FILE.OUTPUT,'surname="' || l_sur_name ||'" ');
5044: FND_FILE.PUT(FND_FILE.OUTPUT,'firstnames="' || l_first_name ||'" ');
5045: IF cur_p45_emp_details_rec.works IS NOT NULL THEN -- Optional
5046: FND_FILE.PUT(FND_FILE.OUTPUT,'works="' || replace(cur_p45_emp_details_rec.works,'-','') ||'" '); /* 7827732 */
5047: END IF;
5048:

Line 5046: FND_FILE.PUT(FND_FILE.OUTPUT,'works="' || replace(cur_p45_emp_details_rec.works,'-','') ||'" '); /* 7827732 */

5042: -- required
5043: FND_FILE.PUT(FND_FILE.OUTPUT,'surname="' || l_sur_name ||'" ');
5044: FND_FILE.PUT(FND_FILE.OUTPUT,'firstnames="' || l_first_name ||'" ');
5045: IF cur_p45_emp_details_rec.works IS NOT NULL THEN -- Optional
5046: FND_FILE.PUT(FND_FILE.OUTPUT,'works="' || replace(cur_p45_emp_details_rec.works,'-','') ||'" '); /* 7827732 */
5047: END IF;
5048:
5049: IF cur_p45_emp_details_rec.dob IS NOT NULL THEN -- Optional
5050: FND_FILE.PUT(FND_FILE.OUTPUT,'dob="' || cur_p45_emp_details_rec.dob ||'" ');

Line 5050: FND_FILE.PUT(FND_FILE.OUTPUT,'dob="' || cur_p45_emp_details_rec.dob ||'" ');

5046: FND_FILE.PUT(FND_FILE.OUTPUT,'works="' || replace(cur_p45_emp_details_rec.works,'-','') ||'" '); /* 7827732 */
5047: END IF;
5048:
5049: IF cur_p45_emp_details_rec.dob IS NOT NULL THEN -- Optional
5050: FND_FILE.PUT(FND_FILE.OUTPUT,'dob="' || cur_p45_emp_details_rec.dob ||'" ');
5051:
5052: ELSIF cur_p45_emp_details_rec.dob IS NULL and ppsn_flag = 0 THEN
5053: warn_status := 1;
5054: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and date of birth missing for employee' );

Line 5054: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and date of birth missing for employee' );

5050: FND_FILE.PUT(FND_FILE.OUTPUT,'dob="' || cur_p45_emp_details_rec.dob ||'" ');
5051:
5052: ELSIF cur_p45_emp_details_rec.dob IS NULL and ppsn_flag = 0 THEN
5053: warn_status := 1;
5054: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and date of birth missing for employee' );
5055: END IF;
5056:
5057: IF l_addressline1 IS NOT NULL THEN -- Optional
5058: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_addressline1 ||'" ');

Line 5058: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_addressline1 ||'" ');

5054: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and date of birth missing for employee' );
5055: END IF;
5056:
5057: IF l_addressline1 IS NOT NULL THEN -- Optional
5058: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_addressline1 ||'" ');
5059: ELSIF l_addressline1 IS NULL and ppsn_flag = 0 THEN
5060: -- Enter the employee details in the log
5061: warn_status := 1;
5062: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 1 missing for employee' );

Line 5062: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 1 missing for employee' );

5058: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_addressline1 ||'" ');
5059: ELSIF l_addressline1 IS NULL and ppsn_flag = 0 THEN
5060: -- Enter the employee details in the log
5061: warn_status := 1;
5062: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 1 missing for employee' );
5063: END IF;
5064:
5065: IF l_addressline2 IS NOT NULL THEN -- Optional
5066: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || l_addressline2 ||'" ');

Line 5066: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || l_addressline2 ||'" ');

5062: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 1 missing for employee' );
5063: END IF;
5064:
5065: IF l_addressline2 IS NOT NULL THEN -- Optional
5066: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || l_addressline2 ||'" ');
5067: ELSIF l_addressline2 IS NULL and ppsn_flag = 0 THEN
5068: -- Enter the employee details in the log
5069: warn_status := 1;
5070: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 2 missing for employee');

Line 5070: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 2 missing for employee');

5066: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || l_addressline2 ||'" ');
5067: ELSIF l_addressline2 IS NULL and ppsn_flag = 0 THEN
5068: -- Enter the employee details in the log
5069: warn_status := 1;
5070: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 2 missing for employee');
5071: END IF;
5072:
5073: IF l_addressline3 IS NOT NULL THEN -- Optional
5074: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_addressline3 ||'" ');

Line 5074: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_addressline3 ||'" ');

5070: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 2 missing for employee');
5071: END IF;
5072:
5073: IF l_addressline3 IS NOT NULL THEN -- Optional
5074: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_addressline3 ||'" ');
5075: END IF;
5076: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5077: -- Employment
5078: IF p45_rec.supp_flag = 'N' THEN

Line 5076: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5072:
5073: IF l_addressline3 IS NOT NULL THEN -- Optional
5074: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_addressline3 ||'" ');
5075: END IF;
5076: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5077: -- Employment
5078: IF p45_rec.supp_flag = 'N' THEN
5079: FND_FILE.PUT(FND_FILE.OUTPUT,' 5080: IF cur_p45_emp_details_rec.start1 IS NOT NULL THEN -- Optional

Line 5079: FND_FILE.PUT(FND_FILE.OUTPUT,'

5075: END IF;
5076: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5077: -- Employment
5078: IF p45_rec.supp_flag = 'N' THEN
5079: FND_FILE.PUT(FND_FILE.OUTPUT,' 5080: IF cur_p45_emp_details_rec.start1 IS NOT NULL THEN -- Optional
5081: FND_FILE.PUT(FND_FILE.OUTPUT,'start="' || cur_p45_emp_details_rec.start1 ||'" ');
5082: END IF;
5083: -- required

Line 5081: FND_FILE.PUT(FND_FILE.OUTPUT,'start="' || cur_p45_emp_details_rec.start1 ||'" ');

5077: -- Employment
5078: IF p45_rec.supp_flag = 'N' THEN
5079: FND_FILE.PUT(FND_FILE.OUTPUT,' 5080: IF cur_p45_emp_details_rec.start1 IS NOT NULL THEN -- Optional
5081: FND_FILE.PUT(FND_FILE.OUTPUT,'start="' || cur_p45_emp_details_rec.start1 ||'" ');
5082: END IF;
5083: -- required
5084: /* 7291676 */
5085: /* 8198702 */

Line 5087: FND_FILE.PUT(FND_FILE.OUTPUT,'end="' || cur_p45_emp_details_rec.end1 ||'" ');

5083: -- required
5084: /* 7291676 */
5085: /* 8198702 */
5086: -- IF (to_number(to_char(to_date(nvl(cur_p45_emp_details_rec.end1,'01/01/2009'),'dd/mm/yyyy'),'yyyy')) >= 2009) THEN -- 7291676
5087: FND_FILE.PUT(FND_FILE.OUTPUT,'end="' || cur_p45_emp_details_rec.end1 ||'" ');
5088: -- END IF;
5089: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) <= 2011) THEN
5090: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');
5091: END IF ; -- 13359530

Line 5090: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');

5086: -- IF (to_number(to_char(to_date(nvl(cur_p45_emp_details_rec.end1,'01/01/2009'),'dd/mm/yyyy'),'yyyy')) >= 2009) THEN -- 7291676
5087: FND_FILE.PUT(FND_FILE.OUTPUT,'end="' || cur_p45_emp_details_rec.end1 ||'" ');
5088: -- END IF;
5089: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) <= 2011) THEN
5090: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');
5091: END IF ; -- 13359530
5092: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5093: ELSE
5094: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) >= 2012) THEN

Line 5092: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5088: -- END IF;
5089: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) <= 2011) THEN
5090: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');
5091: END IF ; -- 13359530
5092: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5093: ELSE
5094: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) >= 2012) THEN
5095: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5096: IF cur_p45_emp_details_rec.deceased = 'Y' THEN

Line 5095: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'

5091: END IF ; -- 13359530
5092: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5093: ELSE
5094: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) >= 2012) THEN
5095: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5096: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5097: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="true" ' );
5098: ELSE
5099: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="false" ' );

Line 5097: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="true" ' );

5093: ELSE
5094: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) >= 2012) THEN
5095: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5096: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5097: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="true" ' );
5098: ELSE
5099: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="false" ' );
5100: END IF;
5101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

Line 5099: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="false" ' );

5095: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5096: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5097: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="true" ' );
5098: ELSE
5099: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="false" ' );
5100: END IF;
5101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5102: END IF;
5103: FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 5101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5097: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="true" ' );
5098: ELSE
5099: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="false" ' );
5100: END IF;
5101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5102: END IF;
5103: FND_FILE.PUT(FND_FILE.OUTPUT,' 5104: /* 7291676 */
5105: /* 8198702 */

Line 5103: FND_FILE.PUT(FND_FILE.OUTPUT,'

5099: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="false" ' );
5100: END IF;
5101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5102: END IF;
5103: FND_FILE.PUT(FND_FILE.OUTPUT,' 5104: /* 7291676 */
5105: /* 8198702 */
5106: -- IF (to_number(to_char(to_date(nvl(cur_p45_emp_details_rec.end1,'01/01/2009'),'dd/mm/yyyy'),'yyyy')) >= 2009) THEN -- 7291676
5107: FND_FILE.PUT(FND_FILE.OUTPUT,'end="' || cur_p45_emp_details_rec.end1 ||'" ');

Line 5107: FND_FILE.PUT(FND_FILE.OUTPUT,'end="' || cur_p45_emp_details_rec.end1 ||'" ');

5103: FND_FILE.PUT(FND_FILE.OUTPUT,' 5104: /* 7291676 */
5105: /* 8198702 */
5106: -- IF (to_number(to_char(to_date(nvl(cur_p45_emp_details_rec.end1,'01/01/2009'),'dd/mm/yyyy'),'yyyy')) >= 2009) THEN -- 7291676
5107: FND_FILE.PUT(FND_FILE.OUTPUT,'end="' || cur_p45_emp_details_rec.end1 ||'" ');
5108: -- END IF;
5109: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) <= 2011) THEN
5110: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');
5111: END IF; -- 13359530

Line 5110: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');

5106: -- IF (to_number(to_char(to_date(nvl(cur_p45_emp_details_rec.end1,'01/01/2009'),'dd/mm/yyyy'),'yyyy')) >= 2009) THEN -- 7291676
5107: FND_FILE.PUT(FND_FILE.OUTPUT,'end="' || cur_p45_emp_details_rec.end1 ||'" ');
5108: -- END IF;
5109: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) <= 2011) THEN
5110: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');
5111: END IF; -- 13359530
5112: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5113: END IF;
5114: -- Pay

Line 5112: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5108: -- END IF;
5109: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) <= 2011) THEN
5110: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');
5111: END IF; -- 13359530
5112: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5113: END IF;
5114: -- Pay
5115: IF p45_rec.supp_flag = 'N' THEN /* 7291676 Pay tag only for main p45, for supp its paydetails */
5116:

Line 5118: FND_FILE.PUT(FND_FILE.OUTPUT,'

5114: -- Pay
5115: IF p45_rec.supp_flag = 'N' THEN /* 7291676 Pay tag only for main p45, for supp its paydetails */
5116:
5117: -- required
5118: FND_FILE.PUT(FND_FILE.OUTPUT,' 5119: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || lower(p45_rec.freq) ||'" ');
5120: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || p45_rec.period ||'" ');
5121: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');
5122: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoff="' || cur_p45_ie_emp_details_rec.cutoff ||'" ');

Line 5119: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || lower(p45_rec.freq) ||'" ');

5115: IF p45_rec.supp_flag = 'N' THEN /* 7291676 Pay tag only for main p45, for supp its paydetails */
5116:
5117: -- required
5118: FND_FILE.PUT(FND_FILE.OUTPUT,' 5119: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || lower(p45_rec.freq) ||'" ');
5120: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || p45_rec.period ||'" ');
5121: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');
5122: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoff="' || cur_p45_ie_emp_details_rec.cutoff ||'" ');
5123:

Line 5120: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || p45_rec.period ||'" ');

5116:
5117: -- required
5118: FND_FILE.PUT(FND_FILE.OUTPUT,' 5119: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || lower(p45_rec.freq) ||'" ');
5120: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || p45_rec.period ||'" ');
5121: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');
5122: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoff="' || cur_p45_ie_emp_details_rec.cutoff ||'" ');
5123:
5124: IF p45_rec.emergency_tax = 'Y' THEN

Line 5121: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');

5117: -- required
5118: FND_FILE.PUT(FND_FILE.OUTPUT,' 5119: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || lower(p45_rec.freq) ||'" ');
5120: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || p45_rec.period ||'" ');
5121: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');
5122: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoff="' || cur_p45_ie_emp_details_rec.cutoff ||'" ');
5123:
5124: IF p45_rec.emergency_tax = 'Y' THEN
5125: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'true' ||'" ');

Line 5122: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoff="' || cur_p45_ie_emp_details_rec.cutoff ||'" ');

5118: FND_FILE.PUT(FND_FILE.OUTPUT,' 5119: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || lower(p45_rec.freq) ||'" ');
5120: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || p45_rec.period ||'" ');
5121: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');
5122: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoff="' || cur_p45_ie_emp_details_rec.cutoff ||'" ');
5123:
5124: IF p45_rec.emergency_tax = 'Y' THEN
5125: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'true' ||'" ');
5126: ELSE

Line 5125: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'true' ||'" ');

5121: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');
5122: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoff="' || cur_p45_ie_emp_details_rec.cutoff ||'" ');
5123:
5124: IF p45_rec.emergency_tax = 'Y' THEN
5125: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'true' ||'" ');
5126: ELSE
5127: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'false' ||'" ');
5128: END IF;
5129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />'); -- 7291676

Line 5127: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'false' ||'" ');

5123:
5124: IF p45_rec.emergency_tax = 'Y' THEN
5125: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'true' ||'" ');
5126: ELSE
5127: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'false' ||'" ');
5128: END IF;
5129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />'); -- 7291676
5130: /* ELSE
5131: OPEN csr_supp_paydetails(p45_rec.assignment_id);

Line 5129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />'); -- 7291676

5125: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'true' ||'" ');
5126: ELSE
5127: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'false' ||'" ');
5128: END IF;
5129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />'); -- 7291676
5130: /* ELSE
5131: OPEN csr_supp_paydetails(p45_rec.assignment_id);
5132: FETCH csr_supp_paydetails INTO csr_supp_paydetails_rec;
5133:

Line 5145: FND_FILE.PUT(FND_FILE.OUTPUT,'

5141:
5142:
5143: -- IF l_eit_sum= l_supp_totalpay THEN
5144: /* l_eit_supp_flag:= false;
5145: FND_FILE.PUT(FND_FILE.OUTPUT,' 5146: IF csr_supp_paydetails_rec.year1 IS NOT NULL THEN
5147: FND_FILE.PUT(FND_FILE.OUTPUT,' year1="' || csr_supp_paydetails_rec.year1 ||'" ');
5148: FND_FILE.PUT(FND_FILE.OUTPUT,' pay1="' || csr_supp_paydetails_rec.pay1 ||'" ');
5149:

Line 5147: FND_FILE.PUT(FND_FILE.OUTPUT,' year1="' || csr_supp_paydetails_rec.year1 ||'" ');

5143: -- IF l_eit_sum= l_supp_totalpay THEN
5144: /* l_eit_supp_flag:= false;
5145: FND_FILE.PUT(FND_FILE.OUTPUT,' 5146: IF csr_supp_paydetails_rec.year1 IS NOT NULL THEN
5147: FND_FILE.PUT(FND_FILE.OUTPUT,' year1="' || csr_supp_paydetails_rec.year1 ||'" ');
5148: FND_FILE.PUT(FND_FILE.OUTPUT,' pay1="' || csr_supp_paydetails_rec.pay1 ||'" ');
5149:
5150: END IF;
5151: IF csr_supp_paydetails_rec.year2 IS NOT NULL THEN

Line 5148: FND_FILE.PUT(FND_FILE.OUTPUT,' pay1="' || csr_supp_paydetails_rec.pay1 ||'" ');

5144: /* l_eit_supp_flag:= false;
5145: FND_FILE.PUT(FND_FILE.OUTPUT,' 5146: IF csr_supp_paydetails_rec.year1 IS NOT NULL THEN
5147: FND_FILE.PUT(FND_FILE.OUTPUT,' year1="' || csr_supp_paydetails_rec.year1 ||'" ');
5148: FND_FILE.PUT(FND_FILE.OUTPUT,' pay1="' || csr_supp_paydetails_rec.pay1 ||'" ');
5149:
5150: END IF;
5151: IF csr_supp_paydetails_rec.year2 IS NOT NULL THEN
5152: IF csr_supp_paydetails_rec.year1=csr_supp_paydetails_rec.year2 THEN

Line 5156: FND_FILE.PUT(FND_FILE.OUTPUT,' year2="' || csr_supp_paydetails_rec.year2 ||'" ');

5152: IF csr_supp_paydetails_rec.year1=csr_supp_paydetails_rec.year2 THEN
5153: l_eit_supp_flag:= true;
5154: END IF;
5155: IF NOT l_eit_supp_flag THEN
5156: FND_FILE.PUT(FND_FILE.OUTPUT,' year2="' || csr_supp_paydetails_rec.year2 ||'" ');
5157: FND_FILE.PUT(FND_FILE.OUTPUT,' pay2="' || csr_supp_paydetails_rec.pay2 ||'" ');
5158: END IF;
5159: END IF;
5160: IF csr_supp_paydetails_rec.year3 IS NOT NULL THEN

Line 5157: FND_FILE.PUT(FND_FILE.OUTPUT,' pay2="' || csr_supp_paydetails_rec.pay2 ||'" ');

5153: l_eit_supp_flag:= true;
5154: END IF;
5155: IF NOT l_eit_supp_flag THEN
5156: FND_FILE.PUT(FND_FILE.OUTPUT,' year2="' || csr_supp_paydetails_rec.year2 ||'" ');
5157: FND_FILE.PUT(FND_FILE.OUTPUT,' pay2="' || csr_supp_paydetails_rec.pay2 ||'" ');
5158: END IF;
5159: END IF;
5160: IF csr_supp_paydetails_rec.year3 IS NOT NULL THEN
5161: IF( (csr_supp_paydetails_rec.year1=csr_supp_paydetails_rec.year3 )

Line 5167: FND_FILE.PUT(FND_FILE.OUTPUT,' year3="' || csr_supp_paydetails_rec.year3 ||'" ');

5163: )THEN
5164: l_eit_supp_flag:= true;
5165: END IF;
5166: IF NOT l_eit_supp_flag THEN
5167: FND_FILE.PUT(FND_FILE.OUTPUT,' year3="' || csr_supp_paydetails_rec.year3 ||'" ');
5168: FND_FILE.PUT(FND_FILE.OUTPUT,' pay3="' || csr_supp_paydetails_rec.pay3 ||'" ');
5169: END IF;
5170: END IF;
5171: IF csr_supp_paydetails_rec.year4 IS NOT NULL THEN

Line 5168: FND_FILE.PUT(FND_FILE.OUTPUT,' pay3="' || csr_supp_paydetails_rec.pay3 ||'" ');

5164: l_eit_supp_flag:= true;
5165: END IF;
5166: IF NOT l_eit_supp_flag THEN
5167: FND_FILE.PUT(FND_FILE.OUTPUT,' year3="' || csr_supp_paydetails_rec.year3 ||'" ');
5168: FND_FILE.PUT(FND_FILE.OUTPUT,' pay3="' || csr_supp_paydetails_rec.pay3 ||'" ');
5169: END IF;
5170: END IF;
5171: IF csr_supp_paydetails_rec.year4 IS NOT NULL THEN
5172: IF ((csr_supp_paydetails_rec.year1=csr_supp_paydetails_rec.year4)

Line 5179: FND_FILE.PUT(FND_FILE.OUTPUT,' year4="' || csr_supp_paydetails_rec.year4 ||'" ');

5175: )THEN
5176: l_eit_supp_flag:= true;
5177: END IF;
5178: IF NOT l_eit_supp_flag THEN
5179: FND_FILE.PUT(FND_FILE.OUTPUT,' year4="' || csr_supp_paydetails_rec.year4 ||'" ');
5180: FND_FILE.PUT(FND_FILE.OUTPUT,' pay4="' || csr_supp_paydetails_rec.pay4 ||'" ');
5181: END IF;
5182: END IF;
5183: IF csr_supp_paydetails_rec.year5 IS NOT NULL THEN

Line 5180: FND_FILE.PUT(FND_FILE.OUTPUT,' pay4="' || csr_supp_paydetails_rec.pay4 ||'" ');

5176: l_eit_supp_flag:= true;
5177: END IF;
5178: IF NOT l_eit_supp_flag THEN
5179: FND_FILE.PUT(FND_FILE.OUTPUT,' year4="' || csr_supp_paydetails_rec.year4 ||'" ');
5180: FND_FILE.PUT(FND_FILE.OUTPUT,' pay4="' || csr_supp_paydetails_rec.pay4 ||'" ');
5181: END IF;
5182: END IF;
5183: IF csr_supp_paydetails_rec.year5 IS NOT NULL THEN
5184: IF ((csr_supp_paydetails_rec.year1=csr_supp_paydetails_rec.year5 )

Line 5192: FND_FILE.PUT(FND_FILE.OUTPUT,' year5="' || csr_supp_paydetails_rec.year5 ||'" ');

5188: )THEN
5189: l_eit_supp_flag:= true;
5190: END IF;
5191: IF NOT l_eit_supp_flag THEN
5192: FND_FILE.PUT(FND_FILE.OUTPUT,' year5="' || csr_supp_paydetails_rec.year5 ||'" ');
5193: FND_FILE.PUT(FND_FILE.OUTPUT,' pay5="' || csr_supp_paydetails_rec.pay5 ||'" ');
5194: END IF;
5195: END IF;
5196: IF csr_supp_paydetails_rec.allotherpay <>0 THEN

Line 5193: FND_FILE.PUT(FND_FILE.OUTPUT,' pay5="' || csr_supp_paydetails_rec.pay5 ||'" ');

5189: l_eit_supp_flag:= true;
5190: END IF;
5191: IF NOT l_eit_supp_flag THEN
5192: FND_FILE.PUT(FND_FILE.OUTPUT,' year5="' || csr_supp_paydetails_rec.year5 ||'" ');
5193: FND_FILE.PUT(FND_FILE.OUTPUT,' pay5="' || csr_supp_paydetails_rec.pay5 ||'" ');
5194: END IF;
5195: END IF;
5196: IF csr_supp_paydetails_rec.allotherpay <>0 THEN
5197: FND_FILE.PUT(FND_FILE.OUTPUT,' allotherpay="' || csr_supp_paydetails_rec.allotherpay ||'" ');

Line 5197: FND_FILE.PUT(FND_FILE.OUTPUT,' allotherpay="' || csr_supp_paydetails_rec.allotherpay ||'" ');

5193: FND_FILE.PUT(FND_FILE.OUTPUT,' pay5="' || csr_supp_paydetails_rec.pay5 ||'" ');
5194: END IF;
5195: END IF;
5196: IF csr_supp_paydetails_rec.allotherpay <>0 THEN
5197: FND_FILE.PUT(FND_FILE.OUTPUT,' allotherpay="' || csr_supp_paydetails_rec.allotherpay ||'" ');
5198: END IF;
5199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5200: IF l_eit_supp_flag THEN
5201: l_str_Common:=' Ensure that the Year1, Year2, Year3, Year4, and Year5 values are not the same for the assignment '|| p45_rec.assignment_id;

Line 5199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5195: END IF;
5196: IF csr_supp_paydetails_rec.allotherpay <>0 THEN
5197: FND_FILE.PUT(FND_FILE.OUTPUT,' allotherpay="' || csr_supp_paydetails_rec.allotherpay ||'" ');
5198: END IF;
5199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5200: IF l_eit_supp_flag THEN
5201: l_str_Common:=' Ensure that the Year1, Year2, Year3, Year4, and Year5 values are not the same for the assignment '|| p45_rec.assignment_id;
5202: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
5203: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',

Line 5202: Fnd_file.put_line(FND_FILE.LOG,l_str_common);

5198: END IF;
5199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5200: IF l_eit_supp_flag THEN
5201: l_str_Common:=' Ensure that the Year1, Year2, Year3, Year4, and Year5 values are not the same for the assignment '|| p45_rec.assignment_id;
5202: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
5203: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',
5204: 'IE P45 XML report completed with validation warning(s).');
5205: END IF; */
5206: /* ELSE

Line 5208: Fnd_file.put_line(FND_FILE.LOG,l_str_common);

5204: 'IE P45 XML report completed with validation warning(s).');
5205: END IF; */
5206: /* ELSE
5207: l_str_Common:=' Ensure that the sum of Pay1, Pay2, Pay3, Pay4, Pay5 and All Other Pay is equal to the total pay in supplementary p45 for the asssingment'|| p45_rec.assignment_id;
5208: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
5209: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',
5210: 'IE P45 XML report completed with validation warning(s).');
5211:
5212: END IF; */

Line 5215: FND_FILE.PUT(FND_FILE.OUTPUT,'

5211:
5212: END IF; */
5213:
5214: /* ELSE
5215: FND_FILE.PUT(FND_FILE.OUTPUT,' 5216: FND_FILE.PUT(FND_FILE.OUTPUT,' year1="' || to_char(p45_rec.date_paid,'yyyy') ||'" ');
5217: FND_FILE.PUT(FND_FILE.OUTPUT,' pay1="' || l_supp_totalpay ||'" ');
5218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5219: END IF;

Line 5216: FND_FILE.PUT(FND_FILE.OUTPUT,' year1="' || to_char(p45_rec.date_paid,'yyyy') ||'" ');

5212: END IF; */
5213:
5214: /* ELSE
5215: FND_FILE.PUT(FND_FILE.OUTPUT,' 5216: FND_FILE.PUT(FND_FILE.OUTPUT,' year1="' || to_char(p45_rec.date_paid,'yyyy') ||'" ');
5217: FND_FILE.PUT(FND_FILE.OUTPUT,' pay1="' || l_supp_totalpay ||'" ');
5218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5219: END IF;
5220: CLOSE csr_supp_paydetails; */

Line 5217: FND_FILE.PUT(FND_FILE.OUTPUT,' pay1="' || l_supp_totalpay ||'" ');

5213:
5214: /* ELSE
5215: FND_FILE.PUT(FND_FILE.OUTPUT,' 5216: FND_FILE.PUT(FND_FILE.OUTPUT,' year1="' || to_char(p45_rec.date_paid,'yyyy') ||'" ');
5217: FND_FILE.PUT(FND_FILE.OUTPUT,' pay1="' || l_supp_totalpay ||'" ');
5218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5219: END IF;
5220: CLOSE csr_supp_paydetails; */
5221: END IF;

Line 5218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5214: /* ELSE
5215: FND_FILE.PUT(FND_FILE.OUTPUT,' 5216: FND_FILE.PUT(FND_FILE.OUTPUT,' year1="' || to_char(p45_rec.date_paid,'yyyy') ||'" ');
5217: FND_FILE.PUT(FND_FILE.OUTPUT,' pay1="' || l_supp_totalpay ||'" ');
5218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5219: END IF;
5220: CLOSE csr_supp_paydetails; */
5221: END IF;
5222:

Line 5228: FND_FILE.PUT(FND_FILE.OUTPUT,'

5224:
5225:
5226: IF p45_rec.supp_flag = 'N' THEN
5227: -- Tax Details for Normal P45 Run
5228: FND_FILE.PUT(FND_FILE.OUTPUT,' 5229: IF cur_p45_paye_prsi_rec.totalpay IS NOT NULL THEN -- Optional
5230: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || cur_p45_paye_prsi_rec.totalpay ||'" ');
5231: END IF;
5232: IF cur_p45_paye_prsi_rec.totaltax IS NOT NULL THEN -- Optional

Line 5230: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || cur_p45_paye_prsi_rec.totalpay ||'" ');

5226: IF p45_rec.supp_flag = 'N' THEN
5227: -- Tax Details for Normal P45 Run
5228: FND_FILE.PUT(FND_FILE.OUTPUT,' 5229: IF cur_p45_paye_prsi_rec.totalpay IS NOT NULL THEN -- Optional
5230: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || cur_p45_paye_prsi_rec.totalpay ||'" ');
5231: END IF;
5232: IF cur_p45_paye_prsi_rec.totaltax IS NOT NULL THEN -- Optional
5233: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || cur_p45_paye_prsi_rec.totaltax ||'" ');
5234: END IF;

Line 5233: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || cur_p45_paye_prsi_rec.totaltax ||'" ');

5229: IF cur_p45_paye_prsi_rec.totalpay IS NOT NULL THEN -- Optional
5230: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || cur_p45_paye_prsi_rec.totalpay ||'" ');
5231: END IF;
5232: IF cur_p45_paye_prsi_rec.totaltax IS NOT NULL THEN -- Optional
5233: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || cur_p45_paye_prsi_rec.totaltax ||'" ');
5234: END IF;
5235: IF cur_p45_paye_prsi_rec.thispay IS NOT NULL THEN -- Optional
5236: FND_FILE.PUT(FND_FILE.OUTPUT,'thispay="' || cur_p45_paye_prsi_rec.thispay ||'" ');
5237: END IF;

Line 5236: FND_FILE.PUT(FND_FILE.OUTPUT,'thispay="' || cur_p45_paye_prsi_rec.thispay ||'" ');

5232: IF cur_p45_paye_prsi_rec.totaltax IS NOT NULL THEN -- Optional
5233: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || cur_p45_paye_prsi_rec.totaltax ||'" ');
5234: END IF;
5235: IF cur_p45_paye_prsi_rec.thispay IS NOT NULL THEN -- Optional
5236: FND_FILE.PUT(FND_FILE.OUTPUT,'thispay="' || cur_p45_paye_prsi_rec.thispay ||'" ');
5237: END IF;
5238: IF cur_p45_paye_prsi_rec.thistax IS NOT NULL THEN -- Optional
5239: -- for bug 5401393, negative tax should not be displayed with - sign.
5240: FND_FILE.PUT(FND_FILE.OUTPUT,'thistax="' || abs(cur_p45_paye_prsi_rec.thistax) ||'" ');

Line 5240: FND_FILE.PUT(FND_FILE.OUTPUT,'thistax="' || abs(cur_p45_paye_prsi_rec.thistax) ||'" ');

5236: FND_FILE.PUT(FND_FILE.OUTPUT,'thispay="' || cur_p45_paye_prsi_rec.thispay ||'" ');
5237: END IF;
5238: IF cur_p45_paye_prsi_rec.thistax IS NOT NULL THEN -- Optional
5239: -- for bug 5401393, negative tax should not be displayed with - sign.
5240: FND_FILE.PUT(FND_FILE.OUTPUT,'thistax="' || abs(cur_p45_paye_prsi_rec.thistax) ||'" ');
5241: IF cur_p45_paye_prsi_rec.thistax < 0 THEN
5242: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="true" ');
5243: ELSE
5244: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="false" ');

Line 5242: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="true" ');

5238: IF cur_p45_paye_prsi_rec.thistax IS NOT NULL THEN -- Optional
5239: -- for bug 5401393, negative tax should not be displayed with - sign.
5240: FND_FILE.PUT(FND_FILE.OUTPUT,'thistax="' || abs(cur_p45_paye_prsi_rec.thistax) ||'" ');
5241: IF cur_p45_paye_prsi_rec.thistax < 0 THEN
5242: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="true" ');
5243: ELSE
5244: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="false" ');
5245: END IF;
5246: END IF;

Line 5244: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="false" ');

5240: FND_FILE.PUT(FND_FILE.OUTPUT,'thistax="' || abs(cur_p45_paye_prsi_rec.thistax) ||'" ');
5241: IF cur_p45_paye_prsi_rec.thistax < 0 THEN
5242: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="true" ');
5243: ELSE
5244: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="false" ');
5245: END IF;
5246: END IF;
5247:
5248: IF cur_p45_paye_prsi_rec.lumpsum IS NOT NULL THEN -- Optional

Line 5249: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || cur_p45_paye_prsi_rec.lumpsum ||'" ');

5245: END IF;
5246: END IF;
5247:
5248: IF cur_p45_paye_prsi_rec.lumpsum IS NOT NULL THEN -- Optional
5249: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || cur_p45_paye_prsi_rec.lumpsum ||'" ');
5250: END IF;
5251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5252: -- PRSI
5253: FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 5251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5247:
5248: IF cur_p45_paye_prsi_rec.lumpsum IS NOT NULL THEN -- Optional
5249: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || cur_p45_paye_prsi_rec.lumpsum ||'" ');
5250: END IF;
5251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5252: -- PRSI
5253: FND_FILE.PUT(FND_FILE.OUTPUT,' 5254: -- Bug 5005788
5255: l_total_prsi := NVL(cur_p45_paye_prsi_rec.employerprsi,0) + NVL(cur_p45_paye_prsi_rec.employeeprsi,0);

Line 5253: FND_FILE.PUT(FND_FILE.OUTPUT,'

5249: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || cur_p45_paye_prsi_rec.lumpsum ||'" ');
5250: END IF;
5251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5252: -- PRSI
5253: FND_FILE.PUT(FND_FILE.OUTPUT,' 5254: -- Bug 5005788
5255: l_total_prsi := NVL(cur_p45_paye_prsi_rec.employerprsi,0) + NVL(cur_p45_paye_prsi_rec.employeeprsi,0);
5256: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_total_prsi,0) ||'" ');
5257: IF cur_p45_paye_prsi_rec.employeeprsi IS NOT NULL THEN -- Optional

Line 5256: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_total_prsi,0) ||'" ');

5252: -- PRSI
5253: FND_FILE.PUT(FND_FILE.OUTPUT,' 5254: -- Bug 5005788
5255: l_total_prsi := NVL(cur_p45_paye_prsi_rec.employerprsi,0) + NVL(cur_p45_paye_prsi_rec.employeeprsi,0);
5256: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_total_prsi,0) ||'" ');
5257: IF cur_p45_paye_prsi_rec.employeeprsi IS NOT NULL THEN -- Optional
5258: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(cur_p45_paye_prsi_rec.employeeprsi,0) ||'" ');
5259: END IF;
5260: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(cur_p45_paye_prsi_rec.totalweeks,0) ||'" ');

Line 5258: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(cur_p45_paye_prsi_rec.employeeprsi,0) ||'" ');

5254: -- Bug 5005788
5255: l_total_prsi := NVL(cur_p45_paye_prsi_rec.employerprsi,0) + NVL(cur_p45_paye_prsi_rec.employeeprsi,0);
5256: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_total_prsi,0) ||'" ');
5257: IF cur_p45_paye_prsi_rec.employeeprsi IS NOT NULL THEN -- Optional
5258: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(cur_p45_paye_prsi_rec.employeeprsi,0) ||'" ');
5259: END IF;
5260: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(cur_p45_paye_prsi_rec.totalweeks,0) ||'" ');
5261:
5262: ELSE

Line 5260: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(cur_p45_paye_prsi_rec.totalweeks,0) ||'" ');

5256: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_total_prsi,0) ||'" ');
5257: IF cur_p45_paye_prsi_rec.employeeprsi IS NOT NULL THEN -- Optional
5258: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(cur_p45_paye_prsi_rec.employeeprsi,0) ||'" ');
5259: END IF;
5260: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(cur_p45_paye_prsi_rec.totalweeks,0) ||'" ');
5261:
5262: ELSE
5263: -- Tax Details for P45 Supp Run
5264: FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 5264: FND_FILE.PUT(FND_FILE.OUTPUT,'

5260: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(cur_p45_paye_prsi_rec.totalweeks,0) ||'" ');
5261:
5262: ELSE
5263: -- Tax Details for P45 Supp Run
5264: FND_FILE.PUT(FND_FILE.OUTPUT,' 5265: IF l_supp_totalpay IS NOT NULL THEN -- Optional
5266: -- FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || l_supp_totalpay ||'" '); /* 7291676 */
5267: FND_FILE.PUT(FND_FILE.OUTPUT,'paysupp="' || l_supp_totalpay ||'" '); /* 7291676 */
5268: END IF;

Line 5266: -- FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || l_supp_totalpay ||'" '); /* 7291676 */

5262: ELSE
5263: -- Tax Details for P45 Supp Run
5264: FND_FILE.PUT(FND_FILE.OUTPUT,' 5265: IF l_supp_totalpay IS NOT NULL THEN -- Optional
5266: -- FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || l_supp_totalpay ||'" '); /* 7291676 */
5267: FND_FILE.PUT(FND_FILE.OUTPUT,'paysupp="' || l_supp_totalpay ||'" '); /* 7291676 */
5268: END IF;
5269: IF l_supp_totaltax IS NOT NULL THEN -- Optional
5270: -- FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || l_supp_totaltax ||'" '); /* 7291676 */

Line 5267: FND_FILE.PUT(FND_FILE.OUTPUT,'paysupp="' || l_supp_totalpay ||'" '); /* 7291676 */

5263: -- Tax Details for P45 Supp Run
5264: FND_FILE.PUT(FND_FILE.OUTPUT,' 5265: IF l_supp_totalpay IS NOT NULL THEN -- Optional
5266: -- FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || l_supp_totalpay ||'" '); /* 7291676 */
5267: FND_FILE.PUT(FND_FILE.OUTPUT,'paysupp="' || l_supp_totalpay ||'" '); /* 7291676 */
5268: END IF;
5269: IF l_supp_totaltax IS NOT NULL THEN -- Optional
5270: -- FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || l_supp_totaltax ||'" '); /* 7291676 */
5271: FND_FILE.PUT(FND_FILE.OUTPUT,'taxdsupp="' || l_supp_totaltax ||'" '); /* 7291676 */

Line 5270: -- FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || l_supp_totaltax ||'" '); /* 7291676 */

5266: -- FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || l_supp_totalpay ||'" '); /* 7291676 */
5267: FND_FILE.PUT(FND_FILE.OUTPUT,'paysupp="' || l_supp_totalpay ||'" '); /* 7291676 */
5268: END IF;
5269: IF l_supp_totaltax IS NOT NULL THEN -- Optional
5270: -- FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || l_supp_totaltax ||'" '); /* 7291676 */
5271: FND_FILE.PUT(FND_FILE.OUTPUT,'taxdsupp="' || l_supp_totaltax ||'" '); /* 7291676 */
5272: END IF;
5273: /* 7291676 */
5274: IF p45_rec.date_paid IS NOT NULL THEN

Line 5271: FND_FILE.PUT(FND_FILE.OUTPUT,'taxdsupp="' || l_supp_totaltax ||'" '); /* 7291676 */

5267: FND_FILE.PUT(FND_FILE.OUTPUT,'paysupp="' || l_supp_totalpay ||'" '); /* 7291676 */
5268: END IF;
5269: IF l_supp_totaltax IS NOT NULL THEN -- Optional
5270: -- FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || l_supp_totaltax ||'" '); /* 7291676 */
5271: FND_FILE.PUT(FND_FILE.OUTPUT,'taxdsupp="' || l_supp_totaltax ||'" '); /* 7291676 */
5272: END IF;
5273: /* 7291676 */
5274: IF p45_rec.date_paid IS NOT NULL THEN
5275:

Line 5276: FND_FILE.PUT(FND_FILE.OUTPUT,'dateofpayment="' || to_char(p45_rec.date_paid,'dd/mm/rrrr') ||'" ');

5272: END IF;
5273: /* 7291676 */
5274: IF p45_rec.date_paid IS NOT NULL THEN
5275:
5276: FND_FILE.PUT(FND_FILE.OUTPUT,'dateofpayment="' || to_char(p45_rec.date_paid,'dd/mm/rrrr') ||'" ');
5277: END IF;
5278:
5279: IF l_supp_totalprsi IS NOT NULL THEN
5280:

Line 5281: FND_FILE.PUT(FND_FILE.OUTPUT,'totalprsi="' || l_supp_totalprsi ||'" ');

5277: END IF;
5278:
5279: IF l_supp_totalprsi IS NOT NULL THEN
5280:
5281: FND_FILE.PUT(FND_FILE.OUTPUT,'totalprsi="' || l_supp_totalprsi ||'" ');
5282: END IF;
5283: IF l_supp_employeeprsi IS NOT NULL THEN
5284:
5285: FND_FILE.PUT(FND_FILE.OUTPUT,'employeeshare="' || l_supp_employeeprsi ||'" ');

Line 5285: FND_FILE.PUT(FND_FILE.OUTPUT,'employeeshare="' || l_supp_employeeprsi ||'" ');

5281: FND_FILE.PUT(FND_FILE.OUTPUT,'totalprsi="' || l_supp_totalprsi ||'" ');
5282: END IF;
5283: IF l_supp_employeeprsi IS NOT NULL THEN
5284:
5285: FND_FILE.PUT(FND_FILE.OUTPUT,'employeeshare="' || l_supp_employeeprsi ||'" ');
5286: END IF;
5287: -- BUG 13359530
5288: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) >= 2012) THEN
5289: IF l_supp_totaluscpay IS NOT NULL THEN

Line 5291: FND_FILE.PUT(FND_FILE.OUTPUT,'uscpaysupp="' || l_supp_totaluscpay ||'" ');

5287: -- BUG 13359530
5288: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) >= 2012) THEN
5289: IF l_supp_totaluscpay IS NOT NULL THEN
5290:
5291: FND_FILE.PUT(FND_FILE.OUTPUT,'uscpaysupp="' || l_supp_totaluscpay ||'" ');
5292: END IF;
5293: IF l_supp_totalusc IS NOT NULL THEN
5294:
5295: FND_FILE.PUT(FND_FILE.OUTPUT,'usctaxdsupp="' || l_supp_totalusc ||'" ');

Line 5295: FND_FILE.PUT(FND_FILE.OUTPUT,'usctaxdsupp="' || l_supp_totalusc ||'" ');

5291: FND_FILE.PUT(FND_FILE.OUTPUT,'uscpaysupp="' || l_supp_totaluscpay ||'" ');
5292: END IF;
5293: IF l_supp_totalusc IS NOT NULL THEN
5294:
5295: FND_FILE.PUT(FND_FILE.OUTPUT,'usctaxdsupp="' || l_supp_totalusc ||'" ');
5296: END IF;
5297: END IF;
5298: -- BUG 13359530 END
5299:

Line 5303: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || l_supp_lumpsum ||'" ');

5299:
5300: /* 7291676 */
5301: /*
5302: IF l_supp_lumpsum IS NOT NULL THEN -- Optional
5303: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || l_supp_lumpsum ||'" ');
5304: END IF;
5305: */
5306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5307: -- PRSI details for P45 Supp Run

Line 5306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5302: IF l_supp_lumpsum IS NOT NULL THEN -- Optional
5303: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || l_supp_lumpsum ||'" ');
5304: END IF;
5305: */
5306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5307: -- PRSI details for P45 Supp Run
5308: /* 7291676 commenting the PRSI section for supp p45 */
5309: /*
5310: FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 5310: FND_FILE.PUT(FND_FILE.OUTPUT,'

5306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5307: -- PRSI details for P45 Supp Run
5308: /* 7291676 commenting the PRSI section for supp p45 */
5309: /*
5310: FND_FILE.PUT(FND_FILE.OUTPUT,' 5311: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_supp_totalprsi,0) ||'" ');
5312: IF l_supp_employeeprsi IS NOT NULL THEN -- Optional
5313: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(l_supp_employeeprsi,0) ||'" ');
5314: END IF;

Line 5311: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_supp_totalprsi,0) ||'" ');

5307: -- PRSI details for P45 Supp Run
5308: /* 7291676 commenting the PRSI section for supp p45 */
5309: /*
5310: FND_FILE.PUT(FND_FILE.OUTPUT,' 5311: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_supp_totalprsi,0) ||'" ');
5312: IF l_supp_employeeprsi IS NOT NULL THEN -- Optional
5313: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(l_supp_employeeprsi,0) ||'" ');
5314: END IF;
5315: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(l_supp_totalweeks,0) ||'" '); */

Line 5313: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(l_supp_employeeprsi,0) ||'" ');

5309: /*
5310: FND_FILE.PUT(FND_FILE.OUTPUT,' 5311: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_supp_totalprsi,0) ||'" ');
5312: IF l_supp_employeeprsi IS NOT NULL THEN -- Optional
5313: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(l_supp_employeeprsi,0) ||'" ');
5314: END IF;
5315: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(l_supp_totalweeks,0) ||'" '); */
5316: OPEN csr_supp_paydetails(p45_rec.assignment_id);
5317: FETCH csr_supp_paydetails INTO csr_supp_paydetails_rec;

Line 5315: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(l_supp_totalweeks,0) ||'" '); */

5311: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_supp_totalprsi,0) ||'" ');
5312: IF l_supp_employeeprsi IS NOT NULL THEN -- Optional
5313: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(l_supp_employeeprsi,0) ||'" ');
5314: END IF;
5315: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(l_supp_totalweeks,0) ||'" '); */
5316: OPEN csr_supp_paydetails(p45_rec.assignment_id);
5317: FETCH csr_supp_paydetails INTO csr_supp_paydetails_rec;
5318:
5319: IF csr_supp_paydetails%FOUND THEN

Line 5329: FND_FILE.PUT(FND_FILE.OUTPUT,'

5325: + to_number(nvl(csr_supp_paydetails_rec.allotherpay,0)); */
5326: l_eit_supp_flag:= false;
5327:
5328: -- IF l_eit_sum= l_supp_totalpay THEN
5329: FND_FILE.PUT(FND_FILE.OUTPUT,' 5330: IF csr_supp_paydetails_rec.year1 IS NOT NULL THEN
5331: FND_FILE.PUT(FND_FILE.OUTPUT,' year1="' || csr_supp_paydetails_rec.year1 ||'" ');
5332: FND_FILE.PUT(FND_FILE.OUTPUT,' pay1="' || csr_supp_paydetails_rec.pay1 ||'" ');
5333:

Line 5331: FND_FILE.PUT(FND_FILE.OUTPUT,' year1="' || csr_supp_paydetails_rec.year1 ||'" ');

5327:
5328: -- IF l_eit_sum= l_supp_totalpay THEN
5329: FND_FILE.PUT(FND_FILE.OUTPUT,' 5330: IF csr_supp_paydetails_rec.year1 IS NOT NULL THEN
5331: FND_FILE.PUT(FND_FILE.OUTPUT,' year1="' || csr_supp_paydetails_rec.year1 ||'" ');
5332: FND_FILE.PUT(FND_FILE.OUTPUT,' pay1="' || csr_supp_paydetails_rec.pay1 ||'" ');
5333:
5334: END IF;
5335: IF csr_supp_paydetails_rec.year2 IS NOT NULL THEN

Line 5332: FND_FILE.PUT(FND_FILE.OUTPUT,' pay1="' || csr_supp_paydetails_rec.pay1 ||'" ');

5328: -- IF l_eit_sum= l_supp_totalpay THEN
5329: FND_FILE.PUT(FND_FILE.OUTPUT,' 5330: IF csr_supp_paydetails_rec.year1 IS NOT NULL THEN
5331: FND_FILE.PUT(FND_FILE.OUTPUT,' year1="' || csr_supp_paydetails_rec.year1 ||'" ');
5332: FND_FILE.PUT(FND_FILE.OUTPUT,' pay1="' || csr_supp_paydetails_rec.pay1 ||'" ');
5333:
5334: END IF;
5335: IF csr_supp_paydetails_rec.year2 IS NOT NULL THEN
5336: IF csr_supp_paydetails_rec.year1=csr_supp_paydetails_rec.year2 THEN

Line 5340: FND_FILE.PUT(FND_FILE.OUTPUT,' year2="' || csr_supp_paydetails_rec.year2 ||'" ');

5336: IF csr_supp_paydetails_rec.year1=csr_supp_paydetails_rec.year2 THEN
5337: l_eit_supp_flag:= true;
5338: END IF;
5339: IF NOT l_eit_supp_flag THEN
5340: FND_FILE.PUT(FND_FILE.OUTPUT,' year2="' || csr_supp_paydetails_rec.year2 ||'" ');
5341: FND_FILE.PUT(FND_FILE.OUTPUT,' pay2="' || csr_supp_paydetails_rec.pay2 ||'" ');
5342: END IF;
5343: END IF;
5344: IF csr_supp_paydetails_rec.year3 IS NOT NULL THEN

Line 5341: FND_FILE.PUT(FND_FILE.OUTPUT,' pay2="' || csr_supp_paydetails_rec.pay2 ||'" ');

5337: l_eit_supp_flag:= true;
5338: END IF;
5339: IF NOT l_eit_supp_flag THEN
5340: FND_FILE.PUT(FND_FILE.OUTPUT,' year2="' || csr_supp_paydetails_rec.year2 ||'" ');
5341: FND_FILE.PUT(FND_FILE.OUTPUT,' pay2="' || csr_supp_paydetails_rec.pay2 ||'" ');
5342: END IF;
5343: END IF;
5344: IF csr_supp_paydetails_rec.year3 IS NOT NULL THEN
5345: IF( (csr_supp_paydetails_rec.year1=csr_supp_paydetails_rec.year3 )

Line 5351: FND_FILE.PUT(FND_FILE.OUTPUT,' year3="' || csr_supp_paydetails_rec.year3 ||'" ');

5347: )THEN
5348: l_eit_supp_flag:= true;
5349: END IF;
5350: IF NOT l_eit_supp_flag THEN
5351: FND_FILE.PUT(FND_FILE.OUTPUT,' year3="' || csr_supp_paydetails_rec.year3 ||'" ');
5352: FND_FILE.PUT(FND_FILE.OUTPUT,' pay3="' || csr_supp_paydetails_rec.pay3 ||'" ');
5353: END IF;
5354: END IF;
5355: IF csr_supp_paydetails_rec.year4 IS NOT NULL THEN

Line 5352: FND_FILE.PUT(FND_FILE.OUTPUT,' pay3="' || csr_supp_paydetails_rec.pay3 ||'" ');

5348: l_eit_supp_flag:= true;
5349: END IF;
5350: IF NOT l_eit_supp_flag THEN
5351: FND_FILE.PUT(FND_FILE.OUTPUT,' year3="' || csr_supp_paydetails_rec.year3 ||'" ');
5352: FND_FILE.PUT(FND_FILE.OUTPUT,' pay3="' || csr_supp_paydetails_rec.pay3 ||'" ');
5353: END IF;
5354: END IF;
5355: IF csr_supp_paydetails_rec.year4 IS NOT NULL THEN
5356: IF ((csr_supp_paydetails_rec.year1=csr_supp_paydetails_rec.year4)

Line 5363: FND_FILE.PUT(FND_FILE.OUTPUT,' year4="' || csr_supp_paydetails_rec.year4 ||'" ');

5359: )THEN
5360: l_eit_supp_flag:= true;
5361: END IF;
5362: IF NOT l_eit_supp_flag THEN
5363: FND_FILE.PUT(FND_FILE.OUTPUT,' year4="' || csr_supp_paydetails_rec.year4 ||'" ');
5364: FND_FILE.PUT(FND_FILE.OUTPUT,' pay4="' || csr_supp_paydetails_rec.pay4 ||'" ');
5365: END IF;
5366: END IF;
5367: IF csr_supp_paydetails_rec.year5 IS NOT NULL THEN

Line 5364: FND_FILE.PUT(FND_FILE.OUTPUT,' pay4="' || csr_supp_paydetails_rec.pay4 ||'" ');

5360: l_eit_supp_flag:= true;
5361: END IF;
5362: IF NOT l_eit_supp_flag THEN
5363: FND_FILE.PUT(FND_FILE.OUTPUT,' year4="' || csr_supp_paydetails_rec.year4 ||'" ');
5364: FND_FILE.PUT(FND_FILE.OUTPUT,' pay4="' || csr_supp_paydetails_rec.pay4 ||'" ');
5365: END IF;
5366: END IF;
5367: IF csr_supp_paydetails_rec.year5 IS NOT NULL THEN
5368: IF ((csr_supp_paydetails_rec.year1=csr_supp_paydetails_rec.year5 )

Line 5376: FND_FILE.PUT(FND_FILE.OUTPUT,' year5="' || csr_supp_paydetails_rec.year5 ||'" ');

5372: )THEN
5373: l_eit_supp_flag:= true;
5374: END IF;
5375: IF NOT l_eit_supp_flag THEN
5376: FND_FILE.PUT(FND_FILE.OUTPUT,' year5="' || csr_supp_paydetails_rec.year5 ||'" ');
5377: FND_FILE.PUT(FND_FILE.OUTPUT,' pay5="' || csr_supp_paydetails_rec.pay5 ||'" ');
5378: END IF;
5379: END IF;
5380: IF csr_supp_paydetails_rec.allotherpay <>0 THEN

Line 5377: FND_FILE.PUT(FND_FILE.OUTPUT,' pay5="' || csr_supp_paydetails_rec.pay5 ||'" ');

5373: l_eit_supp_flag:= true;
5374: END IF;
5375: IF NOT l_eit_supp_flag THEN
5376: FND_FILE.PUT(FND_FILE.OUTPUT,' year5="' || csr_supp_paydetails_rec.year5 ||'" ');
5377: FND_FILE.PUT(FND_FILE.OUTPUT,' pay5="' || csr_supp_paydetails_rec.pay5 ||'" ');
5378: END IF;
5379: END IF;
5380: IF csr_supp_paydetails_rec.allotherpay <>0 THEN
5381: FND_FILE.PUT(FND_FILE.OUTPUT,' allotherpay="' || csr_supp_paydetails_rec.allotherpay ||'" ');

Line 5381: FND_FILE.PUT(FND_FILE.OUTPUT,' allotherpay="' || csr_supp_paydetails_rec.allotherpay ||'" ');

5377: FND_FILE.PUT(FND_FILE.OUTPUT,' pay5="' || csr_supp_paydetails_rec.pay5 ||'" ');
5378: END IF;
5379: END IF;
5380: IF csr_supp_paydetails_rec.allotherpay <>0 THEN
5381: FND_FILE.PUT(FND_FILE.OUTPUT,' allotherpay="' || csr_supp_paydetails_rec.allotherpay ||'" ');
5382: END IF;
5383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5384: IF l_eit_supp_flag THEN
5385: l_str_Common:=' Ensure that the Year1, Year2, Year3, Year4, and Year5 values are not the same for the assignment '|| p45_rec.assignment_id;

Line 5383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5379: END IF;
5380: IF csr_supp_paydetails_rec.allotherpay <>0 THEN
5381: FND_FILE.PUT(FND_FILE.OUTPUT,' allotherpay="' || csr_supp_paydetails_rec.allotherpay ||'" ');
5382: END IF;
5383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5384: IF l_eit_supp_flag THEN
5385: l_str_Common:=' Ensure that the Year1, Year2, Year3, Year4, and Year5 values are not the same for the assignment '|| p45_rec.assignment_id;
5386: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
5387: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',

Line 5386: Fnd_file.put_line(FND_FILE.LOG,l_str_common);

5382: END IF;
5383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5384: IF l_eit_supp_flag THEN
5385: l_str_Common:=' Ensure that the Year1, Year2, Year3, Year4, and Year5 values are not the same for the assignment '|| p45_rec.assignment_id;
5386: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
5387: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',
5388: 'IE P45 XML report completed with validation warning(s).');
5389: END IF;
5390: /* ELSE

Line 5392: Fnd_file.put_line(FND_FILE.LOG,l_str_common);

5388: 'IE P45 XML report completed with validation warning(s).');
5389: END IF;
5390: /* ELSE
5391: l_str_Common:=' Ensure that the sum of Pay1, Pay2, Pay3, Pay4, Pay5 and All Other Pay is equal to the total pay in supplementary p45 for the asssingment'|| p45_rec.assignment_id;
5392: Fnd_file.put_line(FND_FILE.LOG,l_str_common);
5393: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',
5394: 'IE P45 XML report completed with validation warning(s).');
5395:
5396: END IF; */

Line 5399: FND_FILE.PUT(FND_FILE.OUTPUT,'

5395:
5396: END IF; */
5397:
5398: ELSE
5399: FND_FILE.PUT(FND_FILE.OUTPUT,' 5400: FND_FILE.PUT(FND_FILE.OUTPUT,' year1="' || to_char(p45_rec.date_paid,'yyyy') ||'" ');
5401: FND_FILE.PUT(FND_FILE.OUTPUT,' pay1="' || l_supp_totalpay ||'" ');
5402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5403: END IF;

Line 5400: FND_FILE.PUT(FND_FILE.OUTPUT,' year1="' || to_char(p45_rec.date_paid,'yyyy') ||'" ');

5396: END IF; */
5397:
5398: ELSE
5399: FND_FILE.PUT(FND_FILE.OUTPUT,' 5400: FND_FILE.PUT(FND_FILE.OUTPUT,' year1="' || to_char(p45_rec.date_paid,'yyyy') ||'" ');
5401: FND_FILE.PUT(FND_FILE.OUTPUT,' pay1="' || l_supp_totalpay ||'" ');
5402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5403: END IF;
5404: CLOSE csr_supp_paydetails;

Line 5401: FND_FILE.PUT(FND_FILE.OUTPUT,' pay1="' || l_supp_totalpay ||'" ');

5397:
5398: ELSE
5399: FND_FILE.PUT(FND_FILE.OUTPUT,' 5400: FND_FILE.PUT(FND_FILE.OUTPUT,' year1="' || to_char(p45_rec.date_paid,'yyyy') ||'" ');
5401: FND_FILE.PUT(FND_FILE.OUTPUT,' pay1="' || l_supp_totalpay ||'" ');
5402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5403: END IF;
5404: CLOSE csr_supp_paydetails;
5405:

Line 5402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5398: ELSE
5399: FND_FILE.PUT(FND_FILE.OUTPUT,' 5400: FND_FILE.PUT(FND_FILE.OUTPUT,' year1="' || to_char(p45_rec.date_paid,'yyyy') ||'" ');
5401: FND_FILE.PUT(FND_FILE.OUTPUT,' pay1="' || l_supp_totalpay ||'" ');
5402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5403: END IF;
5404: CLOSE csr_supp_paydetails;
5405:
5406: END IF;

Line 5413: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');

5409: ( NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0 and p45_rec.supp_flag <> 'Y' ) OR
5410: ( NVL(l_supp_classA_weeks,0) <> 0 and p45_rec.supp_flag <> 'N' ) THEN
5411: /* 7291676 */
5412: IF p45_rec.supp_flag <> 'Y' THEN
5413: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');
5414: END IF;
5415: IF (NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0) and p45_rec.supp_flag <> 'Y' THEN -- Bug 5015438
5416: FND_FILE.PUT(FND_FILE.OUTPUT,' 5417: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');

Line 5416: FND_FILE.PUT(FND_FILE.OUTPUT,'

5412: IF p45_rec.supp_flag <> 'Y' THEN
5413: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');
5414: END IF;
5415: IF (NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0) and p45_rec.supp_flag <> 'Y' THEN -- Bug 5015438
5416: FND_FILE.PUT(FND_FILE.OUTPUT,' 5417: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5418: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || cur_p45_paye_prsi_rec.totalaweeks ||'" ');
5419: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5420: END IF;

Line 5417: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');

5413: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');
5414: END IF;
5415: IF (NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0) and p45_rec.supp_flag <> 'Y' THEN -- Bug 5015438
5416: FND_FILE.PUT(FND_FILE.OUTPUT,' 5417: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5418: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || cur_p45_paye_prsi_rec.totalaweeks ||'" ');
5419: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5420: END IF;
5421: /* 7291676 */

Line 5418: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || cur_p45_paye_prsi_rec.totalaweeks ||'" ');

5414: END IF;
5415: IF (NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0) and p45_rec.supp_flag <> 'Y' THEN -- Bug 5015438
5416: FND_FILE.PUT(FND_FILE.OUTPUT,' 5417: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5418: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || cur_p45_paye_prsi_rec.totalaweeks ||'" ');
5419: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5420: END IF;
5421: /* 7291676 */
5422: /*

Line 5419: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');

5415: IF (NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0) and p45_rec.supp_flag <> 'Y' THEN -- Bug 5015438
5416: FND_FILE.PUT(FND_FILE.OUTPUT,' 5417: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5418: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || cur_p45_paye_prsi_rec.totalaweeks ||'" ');
5419: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5420: END IF;
5421: /* 7291676 */
5422: /*
5423: IF (NVL(l_supp_classA_weeks,0) <> 0 ) and p45_rec.supp_flag <> 'N' THEN

Line 5424: FND_FILE.PUT(FND_FILE.OUTPUT,'

5420: END IF;
5421: /* 7291676 */
5422: /*
5423: IF (NVL(l_supp_classA_weeks,0) <> 0 ) and p45_rec.supp_flag <> 'N' THEN
5424: FND_FILE.PUT(FND_FILE.OUTPUT,' 5425: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5426: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || l_supp_classA_weeks ||'" ');
5427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5428: END IF; */

Line 5425: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');

5421: /* 7291676 */
5422: /*
5423: IF (NVL(l_supp_classA_weeks,0) <> 0 ) and p45_rec.supp_flag <> 'N' THEN
5424: FND_FILE.PUT(FND_FILE.OUTPUT,' 5425: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5426: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || l_supp_classA_weeks ||'" ');
5427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5428: END IF; */
5429:

Line 5426: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || l_supp_classA_weeks ||'" ');

5422: /*
5423: IF (NVL(l_supp_classA_weeks,0) <> 0 ) and p45_rec.supp_flag <> 'N' THEN
5424: FND_FILE.PUT(FND_FILE.OUTPUT,' 5425: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5426: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || l_supp_classA_weeks ||'" ');
5427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5428: END IF; */
5429:
5430: --14627387

Line 5427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');

5423: IF (NVL(l_supp_classA_weeks,0) <> 0 ) and p45_rec.supp_flag <> 'N' THEN
5424: FND_FILE.PUT(FND_FILE.OUTPUT,' 5425: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5426: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || l_supp_classA_weeks ||'" ');
5427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5428: END IF; */
5429:
5430: --14627387
5431: vfound:= instr(cur_p45_ie_emp_details_rec.prsi_class,',',1,1);

Line 5435: FND_FILE.PUT(FND_FILE.OUTPUT,'

5431: vfound:= instr(cur_p45_ie_emp_details_rec.prsi_class,',',1,1);
5432: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,1);
5433:
5434: IF vfound = 0 AND v_prsi_class = 'M' THEN
5435: FND_FILE.PUT(FND_FILE.OUTPUT,' 5436: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5437: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="0" ');
5438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5439: END IF;

Line 5436: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');

5432: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,1);
5433:
5434: IF vfound = 0 AND v_prsi_class = 'M' THEN
5435: FND_FILE.PUT(FND_FILE.OUTPUT,' 5436: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5437: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="0" ');
5438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5439: END IF;
5440: --14627387

Line 5437: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="0" ');

5433:
5434: IF vfound = 0 AND v_prsi_class = 'M' THEN
5435: FND_FILE.PUT(FND_FILE.OUTPUT,' 5436: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5437: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="0" ');
5438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5439: END IF;
5440: --14627387
5441:

Line 5438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');

5434: IF vfound = 0 AND v_prsi_class = 'M' THEN
5435: FND_FILE.PUT(FND_FILE.OUTPUT,' 5436: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5437: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="0" ');
5438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5439: END IF;
5440: --14627387
5441:
5442: vfrom:=1;

Line 5449: FND_FILE.PUT(FND_FILE.OUTPUT,'

5445: vfound:= instr(cur_p45_ie_emp_details_rec.prsi_class,',',vfrom,1);
5446: IF (vfound > 0 ) THEN
5447: vto:=vfound-vfrom;
5448: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom,vto);
5449: FND_FILE.PUT(FND_FILE.OUTPUT,' 5450: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');
5451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5452: vfrom:=vfound+1;
5453: ELSE

Line 5450: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');

5446: IF (vfound > 0 ) THEN
5447: vto:=vfound-vfrom;
5448: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom,vto);
5449: FND_FILE.PUT(FND_FILE.OUTPUT,' 5450: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');
5451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5452: vfrom:=vfound+1;
5453: ELSE
5454: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom);

Line 5451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');

5447: vto:=vfound-vfrom;
5448: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom,vto);
5449: FND_FILE.PUT(FND_FILE.OUTPUT,' 5450: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');
5451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5452: vfrom:=vfound+1;
5453: ELSE
5454: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom);
5455: IF v_prsi_class IS NOT NULL THEN

Line 5456: FND_FILE.PUT(FND_FILE.OUTPUT,'

5452: vfrom:=vfound+1;
5453: ELSE
5454: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom);
5455: IF v_prsi_class IS NOT NULL THEN
5456: FND_FILE.PUT(FND_FILE.OUTPUT,' 5457: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');
5458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5459: END IF;
5460: EXIT;

Line 5457: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');

5453: ELSE
5454: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom);
5455: IF v_prsi_class IS NOT NULL THEN
5456: FND_FILE.PUT(FND_FILE.OUTPUT,' 5457: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');
5458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5459: END IF;
5460: EXIT;
5461: END IF;

Line 5458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');

5454: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom);
5455: IF v_prsi_class IS NOT NULL THEN
5456: FND_FILE.PUT(FND_FILE.OUTPUT,' 5457: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');
5458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5459: END IF;
5460: EXIT;
5461: END IF;
5462: END LOOP;

Line 5465: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

5461: END IF;
5462: END LOOP;
5463: /* 7291676 */
5464: IF p45_rec.supp_flag <> 'Y' THEN
5465: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5466: END IF;
5467: ELSE
5468: /* 7291676 */
5469: IF p45_rec.supp_flag <> 'Y' THEN

Line 5470: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');

5466: END IF;
5467: ELSE
5468: /* 7291676 */
5469: IF p45_rec.supp_flag <> 'Y' THEN
5470: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5471: END IF;
5472: END IF;
5473: IF p45_rec.supp_flag = 'N' THEN
5474: -- Disability

Line 5475: FND_FILE.PUT(FND_FILE.OUTPUT,'

5471: END IF;
5472: END IF;
5473: IF p45_rec.supp_flag = 'N' THEN
5474: -- Disability
5475: FND_FILE.PUT(FND_FILE.OUTPUT,' 5476: FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || nvl(cur_p45_emp_soc_details_rec.benefit,0) ||'" ');
5477: IF cur_p45_emp_soc_details_rec.taxcreditreduction <> 0 THEN -- Optional
5478: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || cur_p45_emp_soc_details_rec.taxcreditreduction ||'" ');
5479: END IF;

Line 5476: FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || nvl(cur_p45_emp_soc_details_rec.benefit,0) ||'" ');

5472: END IF;
5473: IF p45_rec.supp_flag = 'N' THEN
5474: -- Disability
5475: FND_FILE.PUT(FND_FILE.OUTPUT,' 5476: FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || nvl(cur_p45_emp_soc_details_rec.benefit,0) ||'" ');
5477: IF cur_p45_emp_soc_details_rec.taxcreditreduction <> 0 THEN -- Optional
5478: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || cur_p45_emp_soc_details_rec.taxcreditreduction ||'" ');
5479: END IF;
5480: IF cur_p45_emp_soc_details_rec.cutoffreduction <> 0 THEN -- Optional

Line 5478: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || cur_p45_emp_soc_details_rec.taxcreditreduction ||'" ');

5474: -- Disability
5475: FND_FILE.PUT(FND_FILE.OUTPUT,' 5476: FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || nvl(cur_p45_emp_soc_details_rec.benefit,0) ||'" ');
5477: IF cur_p45_emp_soc_details_rec.taxcreditreduction <> 0 THEN -- Optional
5478: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || cur_p45_emp_soc_details_rec.taxcreditreduction ||'" ');
5479: END IF;
5480: IF cur_p45_emp_soc_details_rec.cutoffreduction <> 0 THEN -- Optional
5481: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || cur_p45_emp_soc_details_rec.cutoffreduction ||'" ');
5482: END IF;

Line 5481: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || cur_p45_emp_soc_details_rec.cutoffreduction ||'" ');

5477: IF cur_p45_emp_soc_details_rec.taxcreditreduction <> 0 THEN -- Optional
5478: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || cur_p45_emp_soc_details_rec.taxcreditreduction ||'" ');
5479: END IF;
5480: IF cur_p45_emp_soc_details_rec.cutoffreduction <> 0 THEN -- Optional
5481: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || cur_p45_emp_soc_details_rec.cutoffreduction ||'" ');
5482: END IF;
5483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5484: -- Deceased
5485:

Line 5483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5479: END IF;
5480: IF cur_p45_emp_soc_details_rec.cutoffreduction <> 0 THEN -- Optional
5481: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || cur_p45_emp_soc_details_rec.cutoffreduction ||'" ');
5482: END IF;
5483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5484: -- Deceased
5485:
5486: FND_FILE.PUT(FND_FILE.OUTPUT,' 5487: IF cur_p45_emp_soc_details_rec.noncumulative IS NOT NULL THEN -- Optional

Line 5486: FND_FILE.PUT(FND_FILE.OUTPUT,'

5482: END IF;
5483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5484: -- Deceased
5485:
5486: FND_FILE.PUT(FND_FILE.OUTPUT,' 5487: IF cur_p45_emp_soc_details_rec.noncumulative IS NOT NULL THEN -- Optional
5488: FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || cur_p45_emp_soc_details_rec.noncumulative ||'" ');
5489: END IF;
5490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

Line 5488: FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || cur_p45_emp_soc_details_rec.noncumulative ||'" ');

5484: -- Deceased
5485:
5486: FND_FILE.PUT(FND_FILE.OUTPUT,' 5487: IF cur_p45_emp_soc_details_rec.noncumulative IS NOT NULL THEN -- Optional
5488: FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || cur_p45_emp_soc_details_rec.noncumulative ||'" ');
5489: END IF;
5490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5491:
5492: -- 13359530

Line 5490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5486: FND_FILE.PUT(FND_FILE.OUTPUT,' 5487: IF cur_p45_emp_soc_details_rec.noncumulative IS NOT NULL THEN -- Optional
5488: FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || cur_p45_emp_soc_details_rec.noncumulative ||'" ');
5489: END IF;
5490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5491:
5492: -- 13359530
5493: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) >= 2012) THEN
5494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'

Line 5494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'

5490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5491:
5492: -- 13359530
5493: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) >= 2012) THEN
5494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5495: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5496: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="true" ' );
5497: ELSE
5498: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="false" ' );

Line 5496: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="true" ' );

5492: -- 13359530
5493: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) >= 2012) THEN
5494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5495: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5496: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="true" ' );
5497: ELSE
5498: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="false" ' );
5499: END IF;
5500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

Line 5498: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="false" ' );

5494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5495: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5496: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="true" ' );
5497: ELSE
5498: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="false" ' );
5499: END IF;
5500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5501: FND_FILE.PUT(FND_FILE.OUTPUT,' 5502: IF cur_p45_paye_prsi_rec.totaluscpay IS NOT NULL THEN

Line 5500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5496: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="true" ' );
5497: ELSE
5498: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="false" ' );
5499: END IF;
5500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5501: FND_FILE.PUT(FND_FILE.OUTPUT,' 5502: IF cur_p45_paye_prsi_rec.totaluscpay IS NOT NULL THEN
5503: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpaytodate="' || cur_p45_paye_prsi_rec.totaluscpay ||'" ');
5504: END IF;

Line 5501: FND_FILE.PUT(FND_FILE.OUTPUT,'

5497: ELSE
5498: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="false" ' );
5499: END IF;
5500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5501: FND_FILE.PUT(FND_FILE.OUTPUT,' 5502: IF cur_p45_paye_prsi_rec.totaluscpay IS NOT NULL THEN
5503: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpaytodate="' || cur_p45_paye_prsi_rec.totaluscpay ||'" ');
5504: END IF;
5505: IF cur_p45_paye_prsi_rec.totalusc IS NOT NULL THEN

Line 5503: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpaytodate="' || cur_p45_paye_prsi_rec.totaluscpay ||'" ');

5499: END IF;
5500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5501: FND_FILE.PUT(FND_FILE.OUTPUT,' 5502: IF cur_p45_paye_prsi_rec.totaluscpay IS NOT NULL THEN
5503: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpaytodate="' || cur_p45_paye_prsi_rec.totaluscpay ||'" ');
5504: END IF;
5505: IF cur_p45_paye_prsi_rec.totalusc IS NOT NULL THEN
5506: FND_FILE.PUT(FND_FILE.OUTPUT,'totalusctodate="' || cur_p45_paye_prsi_rec.totalusc ||'" ');
5507: end if;

Line 5506: FND_FILE.PUT(FND_FILE.OUTPUT,'totalusctodate="' || cur_p45_paye_prsi_rec.totalusc ||'" ');

5502: IF cur_p45_paye_prsi_rec.totaluscpay IS NOT NULL THEN
5503: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpaytodate="' || cur_p45_paye_prsi_rec.totaluscpay ||'" ');
5504: END IF;
5505: IF cur_p45_paye_prsi_rec.totalusc IS NOT NULL THEN
5506: FND_FILE.PUT(FND_FILE.OUTPUT,'totalusctodate="' || cur_p45_paye_prsi_rec.totalusc ||'" ');
5507: end if;
5508: IF cur_p45_paye_prsi_rec.thisuscpay IS NOT NULL THEN
5509: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpaythisemp="' || cur_p45_paye_prsi_rec.thisuscpay ||'" ');
5510: END IF;

Line 5509: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpaythisemp="' || cur_p45_paye_prsi_rec.thisuscpay ||'" ');

5505: IF cur_p45_paye_prsi_rec.totalusc IS NOT NULL THEN
5506: FND_FILE.PUT(FND_FILE.OUTPUT,'totalusctodate="' || cur_p45_paye_prsi_rec.totalusc ||'" ');
5507: end if;
5508: IF cur_p45_paye_prsi_rec.thisuscpay IS NOT NULL THEN
5509: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpaythisemp="' || cur_p45_paye_prsi_rec.thisuscpay ||'" ');
5510: END IF;
5511: IF cur_p45_paye_prsi_rec.thisusc IS NOT NULL THEN
5512: FND_FILE.PUT(FND_FILE.OUTPUT,'totaluscthisemp="' || abs(cur_p45_paye_prsi_rec.thisusc) ||'" ');
5513: END IF;

Line 5512: FND_FILE.PUT(FND_FILE.OUTPUT,'totaluscthisemp="' || abs(cur_p45_paye_prsi_rec.thisusc) ||'" ');

5508: IF cur_p45_paye_prsi_rec.thisuscpay IS NOT NULL THEN
5509: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpaythisemp="' || cur_p45_paye_prsi_rec.thisuscpay ||'" ');
5510: END IF;
5511: IF cur_p45_paye_prsi_rec.thisusc IS NOT NULL THEN
5512: FND_FILE.PUT(FND_FILE.OUTPUT,'totaluscthisemp="' || abs(cur_p45_paye_prsi_rec.thisusc) ||'" ');
5513: END IF;
5514: IF cur_p45_paye_prsi_rec.thisusc < 0 THEN
5515: FND_FILE.PUT(FND_FILE.OUTPUT,'uscrefunded="true" ');
5516: ELSE

Line 5515: FND_FILE.PUT(FND_FILE.OUTPUT,'uscrefunded="true" ');

5511: IF cur_p45_paye_prsi_rec.thisusc IS NOT NULL THEN
5512: FND_FILE.PUT(FND_FILE.OUTPUT,'totaluscthisemp="' || abs(cur_p45_paye_prsi_rec.thisusc) ||'" ');
5513: END IF;
5514: IF cur_p45_paye_prsi_rec.thisusc < 0 THEN
5515: FND_FILE.PUT(FND_FILE.OUTPUT,'uscrefunded="true" ');
5516: ELSE
5517: FND_FILE.PUT(FND_FILE.OUTPUT,'uscrefunded="false" ');
5518: END IF;
5519: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');

Line 5517: FND_FILE.PUT(FND_FILE.OUTPUT,'uscrefunded="false" ');

5513: END IF;
5514: IF cur_p45_paye_prsi_rec.thisusc < 0 THEN
5515: FND_FILE.PUT(FND_FILE.OUTPUT,'uscrefunded="true" ');
5516: ELSE
5517: FND_FILE.PUT(FND_FILE.OUTPUT,'uscrefunded="false" ');
5518: END IF;
5519: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');
5520: FND_FILE.PUT(FND_FILE.OUTPUT,' 5521: FND_FILE.PUT(FND_FILE.OUTPUT,'band="' || 'Band1' ||'" ');

Line 5519: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');

5515: FND_FILE.PUT(FND_FILE.OUTPUT,'uscrefunded="true" ');
5516: ELSE
5517: FND_FILE.PUT(FND_FILE.OUTPUT,'uscrefunded="false" ');
5518: END IF;
5519: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');
5520: FND_FILE.PUT(FND_FILE.OUTPUT,' 5521: FND_FILE.PUT(FND_FILE.OUTPUT,'band="' || 'Band1' ||'" ');
5522: FND_FILE.PUT(FND_FILE.OUTPUT,'amount="' || cur_p45_ie_emp_details_rec.usccutoff1 ||'" ');
5523: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

Line 5520: FND_FILE.PUT(FND_FILE.OUTPUT,'

5516: ELSE
5517: FND_FILE.PUT(FND_FILE.OUTPUT,'uscrefunded="false" ');
5518: END IF;
5519: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');
5520: FND_FILE.PUT(FND_FILE.OUTPUT,' 5521: FND_FILE.PUT(FND_FILE.OUTPUT,'band="' || 'Band1' ||'" ');
5522: FND_FILE.PUT(FND_FILE.OUTPUT,'amount="' || cur_p45_ie_emp_details_rec.usccutoff1 ||'" ');
5523: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5524: FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 5521: FND_FILE.PUT(FND_FILE.OUTPUT,'band="' || 'Band1' ||'" ');

5517: FND_FILE.PUT(FND_FILE.OUTPUT,'uscrefunded="false" ');
5518: END IF;
5519: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');
5520: FND_FILE.PUT(FND_FILE.OUTPUT,' 5521: FND_FILE.PUT(FND_FILE.OUTPUT,'band="' || 'Band1' ||'" ');
5522: FND_FILE.PUT(FND_FILE.OUTPUT,'amount="' || cur_p45_ie_emp_details_rec.usccutoff1 ||'" ');
5523: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5524: FND_FILE.PUT(FND_FILE.OUTPUT,' 5525: FND_FILE.PUT(FND_FILE.OUTPUT,'band="' || 'Band2' ||'" ');

Line 5522: FND_FILE.PUT(FND_FILE.OUTPUT,'amount="' || cur_p45_ie_emp_details_rec.usccutoff1 ||'" ');

5518: END IF;
5519: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');
5520: FND_FILE.PUT(FND_FILE.OUTPUT,' 5521: FND_FILE.PUT(FND_FILE.OUTPUT,'band="' || 'Band1' ||'" ');
5522: FND_FILE.PUT(FND_FILE.OUTPUT,'amount="' || cur_p45_ie_emp_details_rec.usccutoff1 ||'" ');
5523: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5524: FND_FILE.PUT(FND_FILE.OUTPUT,' 5525: FND_FILE.PUT(FND_FILE.OUTPUT,'band="' || 'Band2' ||'" ');
5526: FND_FILE.PUT(FND_FILE.OUTPUT,'amount="' || cur_p45_ie_emp_details_rec.usccutoff2 ||'" ');

Line 5523: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5519: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');
5520: FND_FILE.PUT(FND_FILE.OUTPUT,' 5521: FND_FILE.PUT(FND_FILE.OUTPUT,'band="' || 'Band1' ||'" ');
5522: FND_FILE.PUT(FND_FILE.OUTPUT,'amount="' || cur_p45_ie_emp_details_rec.usccutoff1 ||'" ');
5523: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5524: FND_FILE.PUT(FND_FILE.OUTPUT,' 5525: FND_FILE.PUT(FND_FILE.OUTPUT,'band="' || 'Band2' ||'" ');
5526: FND_FILE.PUT(FND_FILE.OUTPUT,'amount="' || cur_p45_ie_emp_details_rec.usccutoff2 ||'" ');
5527: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

Line 5524: FND_FILE.PUT(FND_FILE.OUTPUT,'

5520: FND_FILE.PUT(FND_FILE.OUTPUT,' 5521: FND_FILE.PUT(FND_FILE.OUTPUT,'band="' || 'Band1' ||'" ');
5522: FND_FILE.PUT(FND_FILE.OUTPUT,'amount="' || cur_p45_ie_emp_details_rec.usccutoff1 ||'" ');
5523: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5524: FND_FILE.PUT(FND_FILE.OUTPUT,' 5525: FND_FILE.PUT(FND_FILE.OUTPUT,'band="' || 'Band2' ||'" ');
5526: FND_FILE.PUT(FND_FILE.OUTPUT,'amount="' || cur_p45_ie_emp_details_rec.usccutoff2 ||'" ');
5527: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5528:

Line 5525: FND_FILE.PUT(FND_FILE.OUTPUT,'band="' || 'Band2' ||'" ');

5521: FND_FILE.PUT(FND_FILE.OUTPUT,'band="' || 'Band1' ||'" ');
5522: FND_FILE.PUT(FND_FILE.OUTPUT,'amount="' || cur_p45_ie_emp_details_rec.usccutoff1 ||'" ');
5523: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5524: FND_FILE.PUT(FND_FILE.OUTPUT,' 5525: FND_FILE.PUT(FND_FILE.OUTPUT,'band="' || 'Band2' ||'" ');
5526: FND_FILE.PUT(FND_FILE.OUTPUT,'amount="' || cur_p45_ie_emp_details_rec.usccutoff2 ||'" ');
5527: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5528:
5529:

Line 5526: FND_FILE.PUT(FND_FILE.OUTPUT,'amount="' || cur_p45_ie_emp_details_rec.usccutoff2 ||'" ');

5522: FND_FILE.PUT(FND_FILE.OUTPUT,'amount="' || cur_p45_ie_emp_details_rec.usccutoff1 ||'" ');
5523: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5524: FND_FILE.PUT(FND_FILE.OUTPUT,' 5525: FND_FILE.PUT(FND_FILE.OUTPUT,'band="' || 'Band2' ||'" ');
5526: FND_FILE.PUT(FND_FILE.OUTPUT,'amount="' || cur_p45_ie_emp_details_rec.usccutoff2 ||'" ');
5527: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5528:
5529:
5530: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 5527: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5523: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5524: FND_FILE.PUT(FND_FILE.OUTPUT,' 5525: FND_FILE.PUT(FND_FILE.OUTPUT,'band="' || 'Band2' ||'" ');
5526: FND_FILE.PUT(FND_FILE.OUTPUT,'amount="' || cur_p45_ie_emp_details_rec.usccutoff2 ||'" ');
5527: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5528:
5529:
5530: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5531:

Line 5530: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

5526: FND_FILE.PUT(FND_FILE.OUTPUT,'amount="' || cur_p45_ie_emp_details_rec.usccutoff2 ||'" ');
5527: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5528:
5529:
5530: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5531:
5532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5533: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5534: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || cur_p45_emp_details_rec.kin_name ||'" ');

Line 5532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'

5528:
5529:
5530: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5531:
5532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5533: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5534: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || cur_p45_emp_details_rec.kin_name ||'" ');
5535: IF cur_p45_emp_details_rec.address_line1 IS NOT NULL THEN
5536: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || cur_p45_emp_details_rec.address_line1 ||'" ');

Line 5534: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || cur_p45_emp_details_rec.kin_name ||'" ');

5530: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5531:
5532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5533: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5534: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || cur_p45_emp_details_rec.kin_name ||'" ');
5535: IF cur_p45_emp_details_rec.address_line1 IS NOT NULL THEN
5536: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || cur_p45_emp_details_rec.address_line1 ||'" ');
5537: END IF;
5538: IF cur_p45_emp_details_rec.address_line2 IS NOT NULL THEN

Line 5536: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || cur_p45_emp_details_rec.address_line1 ||'" ');

5532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5533: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5534: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || cur_p45_emp_details_rec.kin_name ||'" ');
5535: IF cur_p45_emp_details_rec.address_line1 IS NOT NULL THEN
5536: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || cur_p45_emp_details_rec.address_line1 ||'" ');
5537: END IF;
5538: IF cur_p45_emp_details_rec.address_line2 IS NOT NULL THEN
5539: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || cur_p45_emp_details_rec.address_line2 ||'" ');
5540: END IF;

Line 5539: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || cur_p45_emp_details_rec.address_line2 ||'" ');

5535: IF cur_p45_emp_details_rec.address_line1 IS NOT NULL THEN
5536: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || cur_p45_emp_details_rec.address_line1 ||'" ');
5537: END IF;
5538: IF cur_p45_emp_details_rec.address_line2 IS NOT NULL THEN
5539: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || cur_p45_emp_details_rec.address_line2 ||'" ');
5540: END IF;
5541: IF cur_p45_emp_details_rec.address_line3 IS NOT NULL THEN
5542: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || cur_p45_emp_details_rec.address_line3 ||'" ');
5543: END IF;

Line 5542: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || cur_p45_emp_details_rec.address_line3 ||'" ');

5538: IF cur_p45_emp_details_rec.address_line2 IS NOT NULL THEN
5539: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || cur_p45_emp_details_rec.address_line2 ||'" ');
5540: END IF;
5541: IF cur_p45_emp_details_rec.address_line3 IS NOT NULL THEN
5542: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || cur_p45_emp_details_rec.address_line3 ||'" ');
5543: END IF;
5544: IF cur_p45_emp_details_rec.address_line4 IS NOT NULL THEN
5545: FND_FILE.PUT(FND_FILE.OUTPUT,'address4="' || cur_p45_emp_details_rec.address_line4 ||'" ');
5546: END IF;

Line 5545: FND_FILE.PUT(FND_FILE.OUTPUT,'address4="' || cur_p45_emp_details_rec.address_line4 ||'" ');

5541: IF cur_p45_emp_details_rec.address_line3 IS NOT NULL THEN
5542: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || cur_p45_emp_details_rec.address_line3 ||'" ');
5543: END IF;
5544: IF cur_p45_emp_details_rec.address_line4 IS NOT NULL THEN
5545: FND_FILE.PUT(FND_FILE.OUTPUT,'address4="' || cur_p45_emp_details_rec.address_line4 ||'" ');
5546: END IF;
5547: END IF;
5548: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5549: ELSE

Line 5548: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5544: IF cur_p45_emp_details_rec.address_line4 IS NOT NULL THEN
5545: FND_FILE.PUT(FND_FILE.OUTPUT,'address4="' || cur_p45_emp_details_rec.address_line4 ||'" ');
5546: END IF;
5547: END IF;
5548: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5549: ELSE
5550: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5551: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5552: END IF;

Line 5551: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

5547: END IF;
5548: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5549: ELSE
5550: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5551: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5552: END IF;
5553: END IF;
5554:
5555: --13359530

Line 5556: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

5552: END IF;
5553: END IF;
5554:
5555: --13359530
5556: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5557: ELSE
5558: -- FND_FILE.PUT(FND_FILE.OUTPUT,' 5559: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
5560: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');

Line 5558: -- FND_FILE.PUT(FND_FILE.OUTPUT,'

5554:
5555: --13359530
5556: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5557: ELSE
5558: -- FND_FILE.PUT(FND_FILE.OUTPUT,' 5559: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
5560: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
5561: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
5562: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');

Line 5559: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');

5555: --13359530
5556: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5557: ELSE
5558: -- FND_FILE.PUT(FND_FILE.OUTPUT,' 5559: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
5560: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
5561: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
5562: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');
5563: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

Line 5560: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');

5556: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5557: ELSE
5558: -- FND_FILE.PUT(FND_FILE.OUTPUT,' 5559: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
5560: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
5561: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
5562: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');
5563: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5564: -- 13359530

Line 5561: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');

5557: ELSE
5558: -- FND_FILE.PUT(FND_FILE.OUTPUT,' 5559: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
5560: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
5561: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
5562: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');
5563: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5564: -- 13359530
5565: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) >= 2012) THEN

Line 5562: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');

5558: -- FND_FILE.PUT(FND_FILE.OUTPUT,' 5559: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
5560: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
5561: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
5562: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');
5563: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5564: -- 13359530
5565: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) >= 2012) THEN
5566: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'

Line 5563: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5559: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
5560: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
5561: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
5562: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');
5563: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5564: -- 13359530
5565: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) >= 2012) THEN
5566: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5567: IF cur_p45_emp_details_rec.deceased = 'Y' THEN

Line 5566: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'

5562: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');
5563: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5564: -- 13359530
5565: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) >= 2012) THEN
5566: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5567: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5568: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="true" ' );
5569: ELSE
5570: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="false" ' );

Line 5568: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="true" ' );

5564: -- 13359530
5565: IF (to_number(to_char(nvl(p45_rec.date_paid,p45_rec.main_p45_date_paid),'yyyy')) >= 2012) THEN
5566: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5567: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5568: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="true" ' );
5569: ELSE
5570: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="false" ' );
5571: END IF;
5572: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />'); */

Line 5570: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="false" ' );

5566: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5567: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5568: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="true" ' );
5569: ELSE
5570: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="false" ' );
5571: END IF;
5572: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />'); */
5573: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5574: IF cur_p45_emp_details_rec.deceased = 'Y' THEN

Line 5572: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />'); */

5568: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="true" ' );
5569: ELSE
5570: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="false" ' );
5571: END IF;
5572: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />'); */
5573: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5574: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5575: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || cur_p45_emp_details_rec.kin_name ||'" ');
5576: IF cur_p45_emp_details_rec.address_line1 IS NOT NULL THEN

Line 5573: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'

5569: ELSE
5570: FND_FILE.PUT(FND_FILE.OUTPUT,'isdeceased="false" ' );
5571: END IF;
5572: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />'); */
5573: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5574: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5575: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || cur_p45_emp_details_rec.kin_name ||'" ');
5576: IF cur_p45_emp_details_rec.address_line1 IS NOT NULL THEN
5577: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || cur_p45_emp_details_rec.address_line1 ||'" ');

Line 5575: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || cur_p45_emp_details_rec.kin_name ||'" ');

5571: END IF;
5572: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />'); */
5573: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5574: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5575: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || cur_p45_emp_details_rec.kin_name ||'" ');
5576: IF cur_p45_emp_details_rec.address_line1 IS NOT NULL THEN
5577: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || cur_p45_emp_details_rec.address_line1 ||'" ');
5578: END IF;
5579: IF cur_p45_emp_details_rec.address_line2 IS NOT NULL THEN

Line 5577: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || cur_p45_emp_details_rec.address_line1 ||'" ');

5573: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 5574: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5575: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || cur_p45_emp_details_rec.kin_name ||'" ');
5576: IF cur_p45_emp_details_rec.address_line1 IS NOT NULL THEN
5577: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || cur_p45_emp_details_rec.address_line1 ||'" ');
5578: END IF;
5579: IF cur_p45_emp_details_rec.address_line2 IS NOT NULL THEN
5580: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || cur_p45_emp_details_rec.address_line2 ||'" ');
5581: END IF;

Line 5580: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || cur_p45_emp_details_rec.address_line2 ||'" ');

5576: IF cur_p45_emp_details_rec.address_line1 IS NOT NULL THEN
5577: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || cur_p45_emp_details_rec.address_line1 ||'" ');
5578: END IF;
5579: IF cur_p45_emp_details_rec.address_line2 IS NOT NULL THEN
5580: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || cur_p45_emp_details_rec.address_line2 ||'" ');
5581: END IF;
5582: IF cur_p45_emp_details_rec.address_line3 IS NOT NULL THEN
5583: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || cur_p45_emp_details_rec.address_line3 ||'" ');
5584: END IF;

Line 5583: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || cur_p45_emp_details_rec.address_line3 ||'" ');

5579: IF cur_p45_emp_details_rec.address_line2 IS NOT NULL THEN
5580: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || cur_p45_emp_details_rec.address_line2 ||'" ');
5581: END IF;
5582: IF cur_p45_emp_details_rec.address_line3 IS NOT NULL THEN
5583: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || cur_p45_emp_details_rec.address_line3 ||'" ');
5584: END IF;
5585: IF cur_p45_emp_details_rec.address_line4 IS NOT NULL THEN
5586: FND_FILE.PUT(FND_FILE.OUTPUT,'address4="' || cur_p45_emp_details_rec.address_line4 ||'" ');
5587: END IF;

Line 5586: FND_FILE.PUT(FND_FILE.OUTPUT,'address4="' || cur_p45_emp_details_rec.address_line4 ||'" ');

5582: IF cur_p45_emp_details_rec.address_line3 IS NOT NULL THEN
5583: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || cur_p45_emp_details_rec.address_line3 ||'" ');
5584: END IF;
5585: IF cur_p45_emp_details_rec.address_line4 IS NOT NULL THEN
5586: FND_FILE.PUT(FND_FILE.OUTPUT,'address4="' || cur_p45_emp_details_rec.address_line4 ||'" ');
5587: END IF;
5588: END IF;
5589: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5590: ELSE

Line 5589: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5585: IF cur_p45_emp_details_rec.address_line4 IS NOT NULL THEN
5586: FND_FILE.PUT(FND_FILE.OUTPUT,'address4="' || cur_p45_emp_details_rec.address_line4 ||'" ');
5587: END IF;
5588: END IF;
5589: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5590: ELSE
5591: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5592: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '); /* 7291676 */
5593: END IF;

Line 5592: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '); /* 7291676 */

5588: END IF;
5589: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5590: ELSE
5591: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5592: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '); /* 7291676 */
5593: END IF;
5594: END IF;
5595: --13359530
5596: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 5596: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

5592: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '); /* 7291676 */
5593: END IF;
5594: END IF;
5595: --13359530
5596: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5597: END IF;
5598: ELSE
5599:
5600: IF p45_rec.supp_flag = 'N' THEN

Line 5601: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

5597: END IF;
5598: ELSE
5599:
5600: IF p45_rec.supp_flag = 'N' THEN
5601: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5602: ELSE
5603: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5604: END IF;
5605: -- Employee

Line 5603: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

5599:
5600: IF p45_rec.supp_flag = 'N' THEN
5601: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5602: ELSE
5603: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5604: END IF;
5605: -- Employee
5606: FND_FILE.PUT(FND_FILE.OUTPUT,' 5607: IF cur_p45_emp_details_rec.ppsn IS NOT NULL THEN -- Optional

Line 5606: FND_FILE.PUT(FND_FILE.OUTPUT,'

5602: ELSE
5603: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5604: END IF;
5605: -- Employee
5606: FND_FILE.PUT(FND_FILE.OUTPUT,' 5607: IF cur_p45_emp_details_rec.ppsn IS NOT NULL THEN -- Optional
5608: /* 7291676QA */
5609: l_ppsn_override:=null;
5610: open csr_ppsn_override(p45_rec.assignment_id);

Line 5613: FND_FILE.PUT(FND_FILE.OUTPUT,'ppsn="' || nvl(l_ppsn_override, cur_p45_emp_details_rec.ppsn ) ||'" ');

5609: l_ppsn_override:=null;
5610: open csr_ppsn_override(p45_rec.assignment_id);
5611: fetch csr_ppsn_override into l_ppsn_override;
5612: close csr_ppsn_override;
5613: FND_FILE.PUT(FND_FILE.OUTPUT,'ppsn="' || nvl(l_ppsn_override, cur_p45_emp_details_rec.ppsn ) ||'" ');
5614: ppsn_flag := 1;
5615: ELSE
5616: ppsn_flag := 0;
5617: END IF;

Line 5620: FND_FILE.PUT(FND_FILE.OUTPUT,'surname="' || l_sur_name ||'" ');

5616: ppsn_flag := 0;
5617: END IF;
5618:
5619: -- required
5620: FND_FILE.PUT(FND_FILE.OUTPUT,'surname="' || l_sur_name ||'" ');
5621: FND_FILE.PUT(FND_FILE.OUTPUT,'firstnames="' || l_first_name ||'" ');
5622: IF cur_p45_emp_details_rec.works IS NOT NULL THEN -- Optional
5623: FND_FILE.PUT(FND_FILE.OUTPUT,'works="' || replace(cur_p45_emp_details_rec.works,'-','') ||'" '); /* 7827732 */
5624: END IF;

Line 5621: FND_FILE.PUT(FND_FILE.OUTPUT,'firstnames="' || l_first_name ||'" ');

5617: END IF;
5618:
5619: -- required
5620: FND_FILE.PUT(FND_FILE.OUTPUT,'surname="' || l_sur_name ||'" ');
5621: FND_FILE.PUT(FND_FILE.OUTPUT,'firstnames="' || l_first_name ||'" ');
5622: IF cur_p45_emp_details_rec.works IS NOT NULL THEN -- Optional
5623: FND_FILE.PUT(FND_FILE.OUTPUT,'works="' || replace(cur_p45_emp_details_rec.works,'-','') ||'" '); /* 7827732 */
5624: END IF;
5625:

Line 5623: FND_FILE.PUT(FND_FILE.OUTPUT,'works="' || replace(cur_p45_emp_details_rec.works,'-','') ||'" '); /* 7827732 */

5619: -- required
5620: FND_FILE.PUT(FND_FILE.OUTPUT,'surname="' || l_sur_name ||'" ');
5621: FND_FILE.PUT(FND_FILE.OUTPUT,'firstnames="' || l_first_name ||'" ');
5622: IF cur_p45_emp_details_rec.works IS NOT NULL THEN -- Optional
5623: FND_FILE.PUT(FND_FILE.OUTPUT,'works="' || replace(cur_p45_emp_details_rec.works,'-','') ||'" '); /* 7827732 */
5624: END IF;
5625:
5626: IF cur_p45_emp_details_rec.dob IS NOT NULL THEN -- Optional
5627: FND_FILE.PUT(FND_FILE.OUTPUT,'dob="' || cur_p45_emp_details_rec.dob ||'" ');

Line 5627: FND_FILE.PUT(FND_FILE.OUTPUT,'dob="' || cur_p45_emp_details_rec.dob ||'" ');

5623: FND_FILE.PUT(FND_FILE.OUTPUT,'works="' || replace(cur_p45_emp_details_rec.works,'-','') ||'" '); /* 7827732 */
5624: END IF;
5625:
5626: IF cur_p45_emp_details_rec.dob IS NOT NULL THEN -- Optional
5627: FND_FILE.PUT(FND_FILE.OUTPUT,'dob="' || cur_p45_emp_details_rec.dob ||'" ');
5628: END IF;
5629:
5630: IF l_addressline1 IS NOT NULL THEN -- Optional
5631: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_addressline1 ||'" ');

Line 5631: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_addressline1 ||'" ');

5627: FND_FILE.PUT(FND_FILE.OUTPUT,'dob="' || cur_p45_emp_details_rec.dob ||'" ');
5628: END IF;
5629:
5630: IF l_addressline1 IS NOT NULL THEN -- Optional
5631: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_addressline1 ||'" ');
5632: ELSIF l_addressline1 IS NULL and ppsn_flag = 0 THEN
5633: -- Enter the employee details in the log
5634: warn_status := 1;
5635: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 1 missing for employee' );

Line 5635: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 1 missing for employee' );

5631: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_addressline1 ||'" ');
5632: ELSIF l_addressline1 IS NULL and ppsn_flag = 0 THEN
5633: -- Enter the employee details in the log
5634: warn_status := 1;
5635: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 1 missing for employee' );
5636: END IF;
5637:
5638: IF l_addressline2 IS NOT NULL THEN -- Optional
5639: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || l_addressline2 ||'" ');

Line 5639: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || l_addressline2 ||'" ');

5635: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 1 missing for employee' );
5636: END IF;
5637:
5638: IF l_addressline2 IS NOT NULL THEN -- Optional
5639: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || l_addressline2 ||'" ');
5640: ELSIF l_addressline2 IS NULL and ppsn_flag = 0 THEN
5641: -- Enter the employee details in the log
5642: warn_status := 1;
5643: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 2 missing for employee');

Line 5643: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 2 missing for employee');

5639: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || l_addressline2 ||'" ');
5640: ELSIF l_addressline2 IS NULL and ppsn_flag = 0 THEN
5641: -- Enter the employee details in the log
5642: warn_status := 1;
5643: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 2 missing for employee');
5644: END IF;
5645:
5646: IF l_addressline3 IS NOT NULL THEN -- Optional
5647: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_addressline3 ||'" ');

Line 5647: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_addressline3 ||'" ');

5643: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 2 missing for employee');
5644: END IF;
5645:
5646: IF l_addressline3 IS NOT NULL THEN -- Optional
5647: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_addressline3 ||'" ');
5648: END IF;
5649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5650: -- Employment
5651: FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 5649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5645:
5646: IF l_addressline3 IS NOT NULL THEN -- Optional
5647: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_addressline3 ||'" ');
5648: END IF;
5649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5650: -- Employment
5651: FND_FILE.PUT(FND_FILE.OUTPUT,' 5652: IF cur_p45_emp_details_rec.start1 IS NOT NULL THEN -- Optional
5653: FND_FILE.PUT(FND_FILE.OUTPUT,'start="' || cur_p45_emp_details_rec.start1 ||'" ');

Line 5651: FND_FILE.PUT(FND_FILE.OUTPUT,'

5647: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_addressline3 ||'" ');
5648: END IF;
5649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5650: -- Employment
5651: FND_FILE.PUT(FND_FILE.OUTPUT,' 5652: IF cur_p45_emp_details_rec.start1 IS NOT NULL THEN -- Optional
5653: FND_FILE.PUT(FND_FILE.OUTPUT,'start="' || cur_p45_emp_details_rec.start1 ||'" ');
5654: END IF;
5655: -- required

Line 5653: FND_FILE.PUT(FND_FILE.OUTPUT,'start="' || cur_p45_emp_details_rec.start1 ||'" ');

5649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5650: -- Employment
5651: FND_FILE.PUT(FND_FILE.OUTPUT,' 5652: IF cur_p45_emp_details_rec.start1 IS NOT NULL THEN -- Optional
5653: FND_FILE.PUT(FND_FILE.OUTPUT,'start="' || cur_p45_emp_details_rec.start1 ||'" ');
5654: END IF;
5655: -- required
5656: FND_FILE.PUT(FND_FILE.OUTPUT,'end="' || cur_p45_emp_details_rec.end1 ||'" ');
5657: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');

Line 5656: FND_FILE.PUT(FND_FILE.OUTPUT,'end="' || cur_p45_emp_details_rec.end1 ||'" ');

5652: IF cur_p45_emp_details_rec.start1 IS NOT NULL THEN -- Optional
5653: FND_FILE.PUT(FND_FILE.OUTPUT,'start="' || cur_p45_emp_details_rec.start1 ||'" ');
5654: END IF;
5655: -- required
5656: FND_FILE.PUT(FND_FILE.OUTPUT,'end="' || cur_p45_emp_details_rec.end1 ||'" ');
5657: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');
5658: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5659: -- Pay
5660: FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 5657: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');

5653: FND_FILE.PUT(FND_FILE.OUTPUT,'start="' || cur_p45_emp_details_rec.start1 ||'" ');
5654: END IF;
5655: -- required
5656: FND_FILE.PUT(FND_FILE.OUTPUT,'end="' || cur_p45_emp_details_rec.end1 ||'" ');
5657: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');
5658: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5659: -- Pay
5660: FND_FILE.PUT(FND_FILE.OUTPUT,' 5661: -- required

Line 5658: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5654: END IF;
5655: -- required
5656: FND_FILE.PUT(FND_FILE.OUTPUT,'end="' || cur_p45_emp_details_rec.end1 ||'" ');
5657: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');
5658: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5659: -- Pay
5660: FND_FILE.PUT(FND_FILE.OUTPUT,' 5661: -- required
5662: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || p45_rec.freq ||'" ');

Line 5660: FND_FILE.PUT(FND_FILE.OUTPUT,'

5656: FND_FILE.PUT(FND_FILE.OUTPUT,'end="' || cur_p45_emp_details_rec.end1 ||'" ');
5657: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');
5658: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5659: -- Pay
5660: FND_FILE.PUT(FND_FILE.OUTPUT,' 5661: -- required
5662: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || p45_rec.freq ||'" ');
5663: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || p45_rec.period ||'" ');
5664: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');

Line 5662: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || p45_rec.freq ||'" ');

5658: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5659: -- Pay
5660: FND_FILE.PUT(FND_FILE.OUTPUT,' 5661: -- required
5662: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || p45_rec.freq ||'" ');
5663: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || p45_rec.period ||'" ');
5664: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');
5665: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoff="' || cur_p45_ie_emp_details_rec.cutoff ||'" ');
5666:

Line 5663: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || p45_rec.period ||'" ');

5659: -- Pay
5660: FND_FILE.PUT(FND_FILE.OUTPUT,' 5661: -- required
5662: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || p45_rec.freq ||'" ');
5663: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || p45_rec.period ||'" ');
5664: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');
5665: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoff="' || cur_p45_ie_emp_details_rec.cutoff ||'" ');
5666:
5667: IF p45_rec.emergency_tax = 'Y' THEN

Line 5664: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');

5660: FND_FILE.PUT(FND_FILE.OUTPUT,' 5661: -- required
5662: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || p45_rec.freq ||'" ');
5663: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || p45_rec.period ||'" ');
5664: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');
5665: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoff="' || cur_p45_ie_emp_details_rec.cutoff ||'" ');
5666:
5667: IF p45_rec.emergency_tax = 'Y' THEN
5668: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'true' ||'" ');

Line 5665: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoff="' || cur_p45_ie_emp_details_rec.cutoff ||'" ');

5661: -- required
5662: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || p45_rec.freq ||'" ');
5663: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || p45_rec.period ||'" ');
5664: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');
5665: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoff="' || cur_p45_ie_emp_details_rec.cutoff ||'" ');
5666:
5667: IF p45_rec.emergency_tax = 'Y' THEN
5668: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'true' ||'" ');
5669: ELSE

Line 5668: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'true' ||'" ');

5664: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');
5665: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoff="' || cur_p45_ie_emp_details_rec.cutoff ||'" ');
5666:
5667: IF p45_rec.emergency_tax = 'Y' THEN
5668: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'true' ||'" ');
5669: ELSE
5670: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'false' ||'" ');
5671: END IF;
5672: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

Line 5670: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'false' ||'" ');

5666:
5667: IF p45_rec.emergency_tax = 'Y' THEN
5668: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'true' ||'" ');
5669: ELSE
5670: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'false' ||'" ');
5671: END IF;
5672: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5673:
5674: IF p45_rec.supp_flag = 'N' THEN

Line 5672: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5668: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'true' ||'" ');
5669: ELSE
5670: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'false' ||'" ');
5671: END IF;
5672: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5673:
5674: IF p45_rec.supp_flag = 'N' THEN
5675: -- Tax Details for Normal P45 Run
5676: FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 5676: FND_FILE.PUT(FND_FILE.OUTPUT,'

5672: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5673:
5674: IF p45_rec.supp_flag = 'N' THEN
5675: -- Tax Details for Normal P45 Run
5676: FND_FILE.PUT(FND_FILE.OUTPUT,' 5677: IF cur_p45_paye_prsi_rec.totalpay IS NOT NULL THEN -- Optional
5678: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || cur_p45_paye_prsi_rec.totalpay ||'" ');
5679: END IF;
5680: IF cur_p45_paye_prsi_rec.totaltax IS NOT NULL THEN -- Optional

Line 5678: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || cur_p45_paye_prsi_rec.totalpay ||'" ');

5674: IF p45_rec.supp_flag = 'N' THEN
5675: -- Tax Details for Normal P45 Run
5676: FND_FILE.PUT(FND_FILE.OUTPUT,' 5677: IF cur_p45_paye_prsi_rec.totalpay IS NOT NULL THEN -- Optional
5678: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || cur_p45_paye_prsi_rec.totalpay ||'" ');
5679: END IF;
5680: IF cur_p45_paye_prsi_rec.totaltax IS NOT NULL THEN -- Optional
5681: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || cur_p45_paye_prsi_rec.totaltax ||'" ');
5682: END IF;

Line 5681: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || cur_p45_paye_prsi_rec.totaltax ||'" ');

5677: IF cur_p45_paye_prsi_rec.totalpay IS NOT NULL THEN -- Optional
5678: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || cur_p45_paye_prsi_rec.totalpay ||'" ');
5679: END IF;
5680: IF cur_p45_paye_prsi_rec.totaltax IS NOT NULL THEN -- Optional
5681: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || cur_p45_paye_prsi_rec.totaltax ||'" ');
5682: END IF;
5683: IF cur_p45_paye_prsi_rec.thispay IS NOT NULL THEN -- Optional
5684: FND_FILE.PUT(FND_FILE.OUTPUT,'thispay="' || cur_p45_paye_prsi_rec.thispay ||'" ');
5685: END IF;

Line 5684: FND_FILE.PUT(FND_FILE.OUTPUT,'thispay="' || cur_p45_paye_prsi_rec.thispay ||'" ');

5680: IF cur_p45_paye_prsi_rec.totaltax IS NOT NULL THEN -- Optional
5681: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || cur_p45_paye_prsi_rec.totaltax ||'" ');
5682: END IF;
5683: IF cur_p45_paye_prsi_rec.thispay IS NOT NULL THEN -- Optional
5684: FND_FILE.PUT(FND_FILE.OUTPUT,'thispay="' || cur_p45_paye_prsi_rec.thispay ||'" ');
5685: END IF;
5686: IF cur_p45_paye_prsi_rec.thistax IS NOT NULL THEN -- Optional
5687: -- for bug 5401393, negative tax should not be displayed with - sign.
5688: FND_FILE.PUT(FND_FILE.OUTPUT,'thistax="' || abs(cur_p45_paye_prsi_rec.thistax) ||'" ');

Line 5688: FND_FILE.PUT(FND_FILE.OUTPUT,'thistax="' || abs(cur_p45_paye_prsi_rec.thistax) ||'" ');

5684: FND_FILE.PUT(FND_FILE.OUTPUT,'thispay="' || cur_p45_paye_prsi_rec.thispay ||'" ');
5685: END IF;
5686: IF cur_p45_paye_prsi_rec.thistax IS NOT NULL THEN -- Optional
5687: -- for bug 5401393, negative tax should not be displayed with - sign.
5688: FND_FILE.PUT(FND_FILE.OUTPUT,'thistax="' || abs(cur_p45_paye_prsi_rec.thistax) ||'" ');
5689: IF cur_p45_paye_prsi_rec.thistax < 0 THEN
5690: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="true" ');
5691: ELSE
5692: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="false" ');

Line 5690: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="true" ');

5686: IF cur_p45_paye_prsi_rec.thistax IS NOT NULL THEN -- Optional
5687: -- for bug 5401393, negative tax should not be displayed with - sign.
5688: FND_FILE.PUT(FND_FILE.OUTPUT,'thistax="' || abs(cur_p45_paye_prsi_rec.thistax) ||'" ');
5689: IF cur_p45_paye_prsi_rec.thistax < 0 THEN
5690: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="true" ');
5691: ELSE
5692: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="false" ');
5693: END IF;
5694: END IF;

Line 5692: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="false" ');

5688: FND_FILE.PUT(FND_FILE.OUTPUT,'thistax="' || abs(cur_p45_paye_prsi_rec.thistax) ||'" ');
5689: IF cur_p45_paye_prsi_rec.thistax < 0 THEN
5690: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="true" ');
5691: ELSE
5692: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="false" ');
5693: END IF;
5694: END IF;
5695:
5696: IF cur_p45_paye_prsi_rec.lumpsum IS NOT NULL THEN -- Optional

Line 5697: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || cur_p45_paye_prsi_rec.lumpsum ||'" ');

5693: END IF;
5694: END IF;
5695:
5696: IF cur_p45_paye_prsi_rec.lumpsum IS NOT NULL THEN -- Optional
5697: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || cur_p45_paye_prsi_rec.lumpsum ||'" ');
5698: END IF;
5699: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5700: -- PRSI
5701: FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 5699: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5695:
5696: IF cur_p45_paye_prsi_rec.lumpsum IS NOT NULL THEN -- Optional
5697: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || cur_p45_paye_prsi_rec.lumpsum ||'" ');
5698: END IF;
5699: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5700: -- PRSI
5701: FND_FILE.PUT(FND_FILE.OUTPUT,' 5702: -- Bug 5005788
5703: l_total_prsi := NVL(cur_p45_paye_prsi_rec.employerprsi,0) + NVL(cur_p45_paye_prsi_rec.employeeprsi,0);

Line 5701: FND_FILE.PUT(FND_FILE.OUTPUT,'

5697: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || cur_p45_paye_prsi_rec.lumpsum ||'" ');
5698: END IF;
5699: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5700: -- PRSI
5701: FND_FILE.PUT(FND_FILE.OUTPUT,' 5702: -- Bug 5005788
5703: l_total_prsi := NVL(cur_p45_paye_prsi_rec.employerprsi,0) + NVL(cur_p45_paye_prsi_rec.employeeprsi,0);
5704: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_total_prsi,0) ||'" ');
5705: IF cur_p45_paye_prsi_rec.employeeprsi IS NOT NULL THEN -- Optional

Line 5704: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_total_prsi,0) ||'" ');

5700: -- PRSI
5701: FND_FILE.PUT(FND_FILE.OUTPUT,' 5702: -- Bug 5005788
5703: l_total_prsi := NVL(cur_p45_paye_prsi_rec.employerprsi,0) + NVL(cur_p45_paye_prsi_rec.employeeprsi,0);
5704: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_total_prsi,0) ||'" ');
5705: IF cur_p45_paye_prsi_rec.employeeprsi IS NOT NULL THEN -- Optional
5706: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(cur_p45_paye_prsi_rec.employeeprsi,0) ||'" ');
5707: END IF;
5708: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(cur_p45_paye_prsi_rec.totalweeks,0) ||'" ');

Line 5706: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(cur_p45_paye_prsi_rec.employeeprsi,0) ||'" ');

5702: -- Bug 5005788
5703: l_total_prsi := NVL(cur_p45_paye_prsi_rec.employerprsi,0) + NVL(cur_p45_paye_prsi_rec.employeeprsi,0);
5704: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_total_prsi,0) ||'" ');
5705: IF cur_p45_paye_prsi_rec.employeeprsi IS NOT NULL THEN -- Optional
5706: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(cur_p45_paye_prsi_rec.employeeprsi,0) ||'" ');
5707: END IF;
5708: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(cur_p45_paye_prsi_rec.totalweeks,0) ||'" ');
5709: ELSE
5710: -- Tax Details for P45 Supp Run

Line 5708: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(cur_p45_paye_prsi_rec.totalweeks,0) ||'" ');

5704: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_total_prsi,0) ||'" ');
5705: IF cur_p45_paye_prsi_rec.employeeprsi IS NOT NULL THEN -- Optional
5706: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(cur_p45_paye_prsi_rec.employeeprsi,0) ||'" ');
5707: END IF;
5708: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(cur_p45_paye_prsi_rec.totalweeks,0) ||'" ');
5709: ELSE
5710: -- Tax Details for P45 Supp Run
5711: FND_FILE.PUT(FND_FILE.OUTPUT,' 5712: IF l_supp_totalpay IS NOT NULL THEN -- Optional

Line 5711: FND_FILE.PUT(FND_FILE.OUTPUT,'

5707: END IF;
5708: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(cur_p45_paye_prsi_rec.totalweeks,0) ||'" ');
5709: ELSE
5710: -- Tax Details for P45 Supp Run
5711: FND_FILE.PUT(FND_FILE.OUTPUT,' 5712: IF l_supp_totalpay IS NOT NULL THEN -- Optional
5713: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || l_supp_totalpay ||'" ');
5714: END IF;
5715: IF l_supp_totaltax IS NOT NULL THEN -- Optional

Line 5713: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || l_supp_totalpay ||'" ');

5709: ELSE
5710: -- Tax Details for P45 Supp Run
5711: FND_FILE.PUT(FND_FILE.OUTPUT,' 5712: IF l_supp_totalpay IS NOT NULL THEN -- Optional
5713: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || l_supp_totalpay ||'" ');
5714: END IF;
5715: IF l_supp_totaltax IS NOT NULL THEN -- Optional
5716: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || l_supp_totaltax ||'" ');
5717: END IF;

Line 5716: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || l_supp_totaltax ||'" ');

5712: IF l_supp_totalpay IS NOT NULL THEN -- Optional
5713: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || l_supp_totalpay ||'" ');
5714: END IF;
5715: IF l_supp_totaltax IS NOT NULL THEN -- Optional
5716: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || l_supp_totaltax ||'" ');
5717: END IF;
5718: IF l_supp_lumpsum IS NOT NULL THEN -- Optional
5719: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || l_supp_lumpsum ||'" ');
5720: END IF;

Line 5719: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || l_supp_lumpsum ||'" ');

5715: IF l_supp_totaltax IS NOT NULL THEN -- Optional
5716: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || l_supp_totaltax ||'" ');
5717: END IF;
5718: IF l_supp_lumpsum IS NOT NULL THEN -- Optional
5719: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || l_supp_lumpsum ||'" ');
5720: END IF;
5721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5722: -- PRSI details for P45 Supp Run
5723: FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 5721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5717: END IF;
5718: IF l_supp_lumpsum IS NOT NULL THEN -- Optional
5719: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || l_supp_lumpsum ||'" ');
5720: END IF;
5721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5722: -- PRSI details for P45 Supp Run
5723: FND_FILE.PUT(FND_FILE.OUTPUT,' 5724: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_supp_totalprsi,0) ||'" ');
5725: IF l_supp_employeeprsi IS NOT NULL THEN -- Optional

Line 5723: FND_FILE.PUT(FND_FILE.OUTPUT,'

5719: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || l_supp_lumpsum ||'" ');
5720: END IF;
5721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5722: -- PRSI details for P45 Supp Run
5723: FND_FILE.PUT(FND_FILE.OUTPUT,' 5724: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_supp_totalprsi,0) ||'" ');
5725: IF l_supp_employeeprsi IS NOT NULL THEN -- Optional
5726: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(l_supp_employeeprsi,0) ||'" ');
5727: END IF;

Line 5724: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_supp_totalprsi,0) ||'" ');

5720: END IF;
5721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5722: -- PRSI details for P45 Supp Run
5723: FND_FILE.PUT(FND_FILE.OUTPUT,' 5724: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_supp_totalprsi,0) ||'" ');
5725: IF l_supp_employeeprsi IS NOT NULL THEN -- Optional
5726: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(l_supp_employeeprsi,0) ||'" ');
5727: END IF;
5728: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(l_supp_totalweeks,0) ||'" ');

Line 5726: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(l_supp_employeeprsi,0) ||'" ');

5722: -- PRSI details for P45 Supp Run
5723: FND_FILE.PUT(FND_FILE.OUTPUT,' 5724: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_supp_totalprsi,0) ||'" ');
5725: IF l_supp_employeeprsi IS NOT NULL THEN -- Optional
5726: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(l_supp_employeeprsi,0) ||'" ');
5727: END IF;
5728: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(l_supp_totalweeks,0) ||'" ');
5729: END IF;
5730: -- PRSIClass for main P45

Line 5728: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(l_supp_totalweeks,0) ||'" ');

5724: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_supp_totalprsi,0) ||'" ');
5725: IF l_supp_employeeprsi IS NOT NULL THEN -- Optional
5726: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(l_supp_employeeprsi,0) ||'" ');
5727: END IF;
5728: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(l_supp_totalweeks,0) ||'" ');
5729: END IF;
5730: -- PRSIClass for main P45
5731: IF cur_p45_ie_emp_details_rec.prsi_class IS NOT NULL OR
5732: ( NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0 and p45_rec.supp_flag <> 'Y' ) OR

Line 5734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');

5730: -- PRSIClass for main P45
5731: IF cur_p45_ie_emp_details_rec.prsi_class IS NOT NULL OR
5732: ( NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0 and p45_rec.supp_flag <> 'Y' ) OR
5733: ( NVL(l_supp_classA_weeks,0) <> 0 and p45_rec.supp_flag <> 'N' ) THEN
5734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');
5735: IF (NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0) and p45_rec.supp_flag <> 'Y' THEN -- Bug 5015438
5736: FND_FILE.PUT(FND_FILE.OUTPUT,' 5737: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5738: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || cur_p45_paye_prsi_rec.totalaweeks ||'" ');

Line 5736: FND_FILE.PUT(FND_FILE.OUTPUT,'

5732: ( NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0 and p45_rec.supp_flag <> 'Y' ) OR
5733: ( NVL(l_supp_classA_weeks,0) <> 0 and p45_rec.supp_flag <> 'N' ) THEN
5734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');
5735: IF (NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0) and p45_rec.supp_flag <> 'Y' THEN -- Bug 5015438
5736: FND_FILE.PUT(FND_FILE.OUTPUT,' 5737: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5738: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || cur_p45_paye_prsi_rec.totalaweeks ||'" ');
5739: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5740: END IF;

Line 5737: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');

5733: ( NVL(l_supp_classA_weeks,0) <> 0 and p45_rec.supp_flag <> 'N' ) THEN
5734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');
5735: IF (NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0) and p45_rec.supp_flag <> 'Y' THEN -- Bug 5015438
5736: FND_FILE.PUT(FND_FILE.OUTPUT,' 5737: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5738: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || cur_p45_paye_prsi_rec.totalaweeks ||'" ');
5739: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5740: END IF;
5741: IF (NVL(l_supp_classA_weeks,0) <> 0 ) and p45_rec.supp_flag <> 'N' THEN

Line 5738: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || cur_p45_paye_prsi_rec.totalaweeks ||'" ');

5734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');
5735: IF (NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0) and p45_rec.supp_flag <> 'Y' THEN -- Bug 5015438
5736: FND_FILE.PUT(FND_FILE.OUTPUT,' 5737: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5738: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || cur_p45_paye_prsi_rec.totalaweeks ||'" ');
5739: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5740: END IF;
5741: IF (NVL(l_supp_classA_weeks,0) <> 0 ) and p45_rec.supp_flag <> 'N' THEN
5742: FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 5739: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');

5735: IF (NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0) and p45_rec.supp_flag <> 'Y' THEN -- Bug 5015438
5736: FND_FILE.PUT(FND_FILE.OUTPUT,' 5737: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5738: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || cur_p45_paye_prsi_rec.totalaweeks ||'" ');
5739: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5740: END IF;
5741: IF (NVL(l_supp_classA_weeks,0) <> 0 ) and p45_rec.supp_flag <> 'N' THEN
5742: FND_FILE.PUT(FND_FILE.OUTPUT,' 5743: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');

Line 5742: FND_FILE.PUT(FND_FILE.OUTPUT,'

5738: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || cur_p45_paye_prsi_rec.totalaweeks ||'" ');
5739: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5740: END IF;
5741: IF (NVL(l_supp_classA_weeks,0) <> 0 ) and p45_rec.supp_flag <> 'N' THEN
5742: FND_FILE.PUT(FND_FILE.OUTPUT,' 5743: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5744: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || l_supp_classA_weeks ||'" ');
5745: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5746: END IF;

Line 5743: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');

5739: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5740: END IF;
5741: IF (NVL(l_supp_classA_weeks,0) <> 0 ) and p45_rec.supp_flag <> 'N' THEN
5742: FND_FILE.PUT(FND_FILE.OUTPUT,' 5743: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5744: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || l_supp_classA_weeks ||'" ');
5745: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5746: END IF;
5747:

Line 5744: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || l_supp_classA_weeks ||'" ');

5740: END IF;
5741: IF (NVL(l_supp_classA_weeks,0) <> 0 ) and p45_rec.supp_flag <> 'N' THEN
5742: FND_FILE.PUT(FND_FILE.OUTPUT,' 5743: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5744: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || l_supp_classA_weeks ||'" ');
5745: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5746: END IF;
5747:
5748: --14627387

Line 5745: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');

5741: IF (NVL(l_supp_classA_weeks,0) <> 0 ) and p45_rec.supp_flag <> 'N' THEN
5742: FND_FILE.PUT(FND_FILE.OUTPUT,' 5743: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5744: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || l_supp_classA_weeks ||'" ');
5745: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5746: END IF;
5747:
5748: --14627387
5749: vfound:= instr(cur_p45_ie_emp_details_rec.prsi_class,',',1,1);

Line 5753: FND_FILE.PUT(FND_FILE.OUTPUT,'

5749: vfound:= instr(cur_p45_ie_emp_details_rec.prsi_class,',',1,1);
5750: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,1);
5751:
5752: IF vfound = 0 AND v_prsi_class = 'M' THEN
5753: FND_FILE.PUT(FND_FILE.OUTPUT,' 5754: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5755: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="0" ');
5756: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5757: END IF;

Line 5754: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');

5750: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,1);
5751:
5752: IF vfound = 0 AND v_prsi_class = 'M' THEN
5753: FND_FILE.PUT(FND_FILE.OUTPUT,' 5754: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5755: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="0" ');
5756: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5757: END IF;
5758: --14627387

Line 5755: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="0" ');

5751:
5752: IF vfound = 0 AND v_prsi_class = 'M' THEN
5753: FND_FILE.PUT(FND_FILE.OUTPUT,' 5754: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5755: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="0" ');
5756: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5757: END IF;
5758: --14627387
5759:

Line 5756: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');

5752: IF vfound = 0 AND v_prsi_class = 'M' THEN
5753: FND_FILE.PUT(FND_FILE.OUTPUT,' 5754: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
5755: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="0" ');
5756: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5757: END IF;
5758: --14627387
5759:
5760: vfrom:=1;

Line 5767: FND_FILE.PUT(FND_FILE.OUTPUT,'

5763: vfound:= instr(cur_p45_ie_emp_details_rec.prsi_class,',',vfrom,1);
5764: IF (vfound > 0 ) THEN
5765: vto:=vfound-vfrom;
5766: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom,vto);
5767: FND_FILE.PUT(FND_FILE.OUTPUT,' 5768: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');
5769: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5770: vfrom:=vfound+1;
5771: ELSE

Line 5768: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');

5764: IF (vfound > 0 ) THEN
5765: vto:=vfound-vfrom;
5766: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom,vto);
5767: FND_FILE.PUT(FND_FILE.OUTPUT,' 5768: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');
5769: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5770: vfrom:=vfound+1;
5771: ELSE
5772: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom);

Line 5769: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');

5765: vto:=vfound-vfrom;
5766: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom,vto);
5767: FND_FILE.PUT(FND_FILE.OUTPUT,' 5768: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');
5769: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5770: vfrom:=vfound+1;
5771: ELSE
5772: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom);
5773: IF v_prsi_class IS NOT NULL THEN

Line 5774: FND_FILE.PUT(FND_FILE.OUTPUT,'

5770: vfrom:=vfound+1;
5771: ELSE
5772: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom);
5773: IF v_prsi_class IS NOT NULL THEN
5774: FND_FILE.PUT(FND_FILE.OUTPUT,' 5775: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');
5776: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5777: END IF;
5778: EXIT;

Line 5775: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');

5771: ELSE
5772: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom);
5773: IF v_prsi_class IS NOT NULL THEN
5774: FND_FILE.PUT(FND_FILE.OUTPUT,' 5775: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');
5776: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5777: END IF;
5778: EXIT;
5779: END IF;

Line 5776: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');

5772: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom);
5773: IF v_prsi_class IS NOT NULL THEN
5774: FND_FILE.PUT(FND_FILE.OUTPUT,' 5775: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');
5776: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5777: END IF;
5778: EXIT;
5779: END IF;
5780: END LOOP;

Line 5781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

5777: END IF;
5778: EXIT;
5779: END IF;
5780: END LOOP;
5781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5782: ELSE
5783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5784: END IF;
5785: IF p45_rec.supp_flag = 'N' THEN

Line 5783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');

5779: END IF;
5780: END LOOP;
5781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5782: ELSE
5783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5784: END IF;
5785: IF p45_rec.supp_flag = 'N' THEN
5786: -- Disability
5787: FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 5787: FND_FILE.PUT(FND_FILE.OUTPUT,'

5783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
5784: END IF;
5785: IF p45_rec.supp_flag = 'N' THEN
5786: -- Disability
5787: FND_FILE.PUT(FND_FILE.OUTPUT,' 5788: FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || nvl(cur_p45_emp_soc_details_rec.benefit,0) ||'" ');
5789: IF cur_p45_emp_soc_details_rec.taxcreditreduction IS NOT NULL THEN -- Optional
5790: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || cur_p45_emp_soc_details_rec.taxcreditreduction ||'" ');
5791: END IF;

Line 5788: FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || nvl(cur_p45_emp_soc_details_rec.benefit,0) ||'" ');

5784: END IF;
5785: IF p45_rec.supp_flag = 'N' THEN
5786: -- Disability
5787: FND_FILE.PUT(FND_FILE.OUTPUT,' 5788: FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || nvl(cur_p45_emp_soc_details_rec.benefit,0) ||'" ');
5789: IF cur_p45_emp_soc_details_rec.taxcreditreduction IS NOT NULL THEN -- Optional
5790: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || cur_p45_emp_soc_details_rec.taxcreditreduction ||'" ');
5791: END IF;
5792: IF cur_p45_emp_soc_details_rec.cutoffreduction IS NOT NULL THEN -- Optional

Line 5790: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || cur_p45_emp_soc_details_rec.taxcreditreduction ||'" ');

5786: -- Disability
5787: FND_FILE.PUT(FND_FILE.OUTPUT,' 5788: FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || nvl(cur_p45_emp_soc_details_rec.benefit,0) ||'" ');
5789: IF cur_p45_emp_soc_details_rec.taxcreditreduction IS NOT NULL THEN -- Optional
5790: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || cur_p45_emp_soc_details_rec.taxcreditreduction ||'" ');
5791: END IF;
5792: IF cur_p45_emp_soc_details_rec.cutoffreduction IS NOT NULL THEN -- Optional
5793: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || cur_p45_emp_soc_details_rec.cutoffreduction ||'" ');
5794: END IF;

Line 5793: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || cur_p45_emp_soc_details_rec.cutoffreduction ||'" ');

5789: IF cur_p45_emp_soc_details_rec.taxcreditreduction IS NOT NULL THEN -- Optional
5790: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || cur_p45_emp_soc_details_rec.taxcreditreduction ||'" ');
5791: END IF;
5792: IF cur_p45_emp_soc_details_rec.cutoffreduction IS NOT NULL THEN -- Optional
5793: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || cur_p45_emp_soc_details_rec.cutoffreduction ||'" ');
5794: END IF;
5795: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5796: -- Deceased
5797:

Line 5795: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5791: END IF;
5792: IF cur_p45_emp_soc_details_rec.cutoffreduction IS NOT NULL THEN -- Optional
5793: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || cur_p45_emp_soc_details_rec.cutoffreduction ||'" ');
5794: END IF;
5795: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5796: -- Deceased
5797:
5798: FND_FILE.PUT(FND_FILE.OUTPUT,' 5799: IF cur_p45_emp_soc_details_rec.noncumulative IS NOT NULL THEN -- Optional

Line 5798: FND_FILE.PUT(FND_FILE.OUTPUT,'

5794: END IF;
5795: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5796: -- Deceased
5797:
5798: FND_FILE.PUT(FND_FILE.OUTPUT,' 5799: IF cur_p45_emp_soc_details_rec.noncumulative IS NOT NULL THEN -- Optional
5800: FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || cur_p45_emp_soc_details_rec.noncumulative ||'" ');
5801: END IF;
5802: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

Line 5800: FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || cur_p45_emp_soc_details_rec.noncumulative ||'" ');

5796: -- Deceased
5797:
5798: FND_FILE.PUT(FND_FILE.OUTPUT,' 5799: IF cur_p45_emp_soc_details_rec.noncumulative IS NOT NULL THEN -- Optional
5800: FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || cur_p45_emp_soc_details_rec.noncumulative ||'" ');
5801: END IF;
5802: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5803:
5804: IF cur_p45_emp_details_rec.deceased = 'Y' THEN

Line 5802: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5798: FND_FILE.PUT(FND_FILE.OUTPUT,' 5799: IF cur_p45_emp_soc_details_rec.noncumulative IS NOT NULL THEN -- Optional
5800: FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || cur_p45_emp_soc_details_rec.noncumulative ||'" ');
5801: END IF;
5802: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5803:
5804: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5805: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5806: END IF;

Line 5805: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

5801: END IF;
5802: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5803:
5804: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5805: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5806: END IF;
5807: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5808: ELSE
5809: -- FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 5807: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

5803:
5804: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
5805: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5806: END IF;
5807: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5808: ELSE
5809: -- FND_FILE.PUT(FND_FILE.OUTPUT,' 5810: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
5811: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');

Line 5809: -- FND_FILE.PUT(FND_FILE.OUTPUT,'

5805: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5806: END IF;
5807: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5808: ELSE
5809: -- FND_FILE.PUT(FND_FILE.OUTPUT,' 5810: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
5811: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
5812: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
5813: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');

Line 5810: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');

5806: END IF;
5807: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5808: ELSE
5809: -- FND_FILE.PUT(FND_FILE.OUTPUT,' 5810: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
5811: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
5812: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
5813: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');
5814: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

Line 5811: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');

5807: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5808: ELSE
5809: -- FND_FILE.PUT(FND_FILE.OUTPUT,' 5810: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
5811: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
5812: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
5813: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');
5814: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 5812: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');

5808: ELSE
5809: -- FND_FILE.PUT(FND_FILE.OUTPUT,' 5810: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
5811: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
5812: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
5813: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');
5814: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5816: END IF;

Line 5813: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');

5809: -- FND_FILE.PUT(FND_FILE.OUTPUT,' 5810: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
5811: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
5812: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
5813: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');
5814: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5816: END IF;
5817: END IF; -- 7291676

Line 5814: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

5810: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
5811: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
5812: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
5813: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');
5814: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5816: END IF;
5817: END IF; -- 7291676
5818: END IF;

Line 5815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

5811: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
5812: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
5813: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');
5814: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
5815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
5816: END IF;
5817: END IF; -- 7291676
5818: END IF;
5819: END LOOP;

Line 5822: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_end_tag);

5818: END IF;
5819: END LOOP;
5820: IF once_per_run = 'Y' THEN
5821: -- End of ROOT P45File ELEMENT
5822: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_end_tag);
5823: END IF;
5824:
5825:
5826: IF warn_status =1 then