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

Line 4827: FND_FILE.PUT_LINE(FND_FILE.LOG,'Business Group Name : '|| l_business_group_name);

4823: where business_group_id = p_business_group_id;
4824:
4825: select decode(p_mode, 'L', 'Listing Mode', 'A','All','U','Upgrading Mode','Future Upgrade') into l_run_mode from dual;
4826:
4827: FND_FILE.PUT_LINE(FND_FILE.LOG,'Business Group Name : '|| l_business_group_name);
4828: FND_FILE.PUT_LINE(FND_FILE.LOG,'Running Mode : '|| l_run_mode);
4829: FND_FILE.NEW_LINE(FND_FILE.LOG);
4830: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');
4831: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 4828: FND_FILE.PUT_LINE(FND_FILE.LOG,'Running Mode : '|| l_run_mode);

4824:
4825: select decode(p_mode, 'L', 'Listing Mode', 'A','All','U','Upgrading Mode','Future Upgrade') into l_run_mode from dual;
4826:
4827: FND_FILE.PUT_LINE(FND_FILE.LOG,'Business Group Name : '|| l_business_group_name);
4828: FND_FILE.PUT_LINE(FND_FILE.LOG,'Running Mode : '|| l_run_mode);
4829: FND_FILE.NEW_LINE(FND_FILE.LOG);
4830: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');
4831: FND_FILE.NEW_LINE(FND_FILE.LOG);
4832:

Line 4829: FND_FILE.NEW_LINE(FND_FILE.LOG);

4825: select decode(p_mode, 'L', 'Listing Mode', 'A','All','U','Upgrading Mode','Future Upgrade') into l_run_mode from dual;
4826:
4827: FND_FILE.PUT_LINE(FND_FILE.LOG,'Business Group Name : '|| l_business_group_name);
4828: FND_FILE.PUT_LINE(FND_FILE.LOG,'Running Mode : '|| l_run_mode);
4829: FND_FILE.NEW_LINE(FND_FILE.LOG);
4830: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');
4831: FND_FILE.NEW_LINE(FND_FILE.LOG);
4832:
4833: OPEN csr_paye_tax_element;

Line 4830: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');

4826:
4827: FND_FILE.PUT_LINE(FND_FILE.LOG,'Business Group Name : '|| l_business_group_name);
4828: FND_FILE.PUT_LINE(FND_FILE.LOG,'Running Mode : '|| l_run_mode);
4829: FND_FILE.NEW_LINE(FND_FILE.LOG);
4830: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');
4831: FND_FILE.NEW_LINE(FND_FILE.LOG);
4832:
4833: OPEN csr_paye_tax_element;
4834: FETCH csr_paye_tax_element into l_element_type_id;

Line 4831: FND_FILE.NEW_LINE(FND_FILE.LOG);

4827: FND_FILE.PUT_LINE(FND_FILE.LOG,'Business Group Name : '|| l_business_group_name);
4828: FND_FILE.PUT_LINE(FND_FILE.LOG,'Running Mode : '|| l_run_mode);
4829: FND_FILE.NEW_LINE(FND_FILE.LOG);
4830: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');
4831: FND_FILE.NEW_LINE(FND_FILE.LOG);
4832:
4833: OPEN csr_paye_tax_element;
4834: FETCH csr_paye_tax_element into l_element_type_id;
4835: CLOSE csr_paye_tax_element;

Line 4889: fnd_file.put_line(FND_FILE.LOG,'Listing of Employees with current tax scale = 7 and eligible for upgrade to tax scale = 2' );

4885:
4886:
4887: IF l_run_mode = 'Listing Mode' THEN
4888:
4889: fnd_file.put_line(FND_FILE.LOG,'Listing of Employees with current tax scale = 7 and eligible for upgrade to tax scale = 2' );
4890: fnd_file.put_line(FND_FILE.LOG,'since they have open ended element entry for Tax Information element as of 01-JUL-2012' );
4891: fnd_file.put_line(FND_FILE.LOG,'and open ended assignment entry record as of 01-JUL-2012' );
4892: FND_FILE.NEW_LINE(FND_FILE.LOG);
4893:

Line 4890: fnd_file.put_line(FND_FILE.LOG,'since they have open ended element entry for Tax Information element as of 01-JUL-2012' );

4886:
4887: IF l_run_mode = 'Listing Mode' THEN
4888:
4889: fnd_file.put_line(FND_FILE.LOG,'Listing of Employees with current tax scale = 7 and eligible for upgrade to tax scale = 2' );
4890: fnd_file.put_line(FND_FILE.LOG,'since they have open ended element entry for Tax Information element as of 01-JUL-2012' );
4891: fnd_file.put_line(FND_FILE.LOG,'and open ended assignment entry record as of 01-JUL-2012' );
4892: FND_FILE.NEW_LINE(FND_FILE.LOG);
4893:
4894: FOR asgrec IN csr_ele_entries(l_element_type_id,l_inp_value_id_table(13))

Line 4891: fnd_file.put_line(FND_FILE.LOG,'and open ended assignment entry record as of 01-JUL-2012' );

4887: IF l_run_mode = 'Listing Mode' THEN
4888:
4889: fnd_file.put_line(FND_FILE.LOG,'Listing of Employees with current tax scale = 7 and eligible for upgrade to tax scale = 2' );
4890: fnd_file.put_line(FND_FILE.LOG,'since they have open ended element entry for Tax Information element as of 01-JUL-2012' );
4891: fnd_file.put_line(FND_FILE.LOG,'and open ended assignment entry record as of 01-JUL-2012' );
4892: FND_FILE.NEW_LINE(FND_FILE.LOG);
4893:
4894: FOR asgrec IN csr_ele_entries(l_element_type_id,l_inp_value_id_table(13))
4895: LOOP

Line 4892: FND_FILE.NEW_LINE(FND_FILE.LOG);

4888:
4889: fnd_file.put_line(FND_FILE.LOG,'Listing of Employees with current tax scale = 7 and eligible for upgrade to tax scale = 2' );
4890: fnd_file.put_line(FND_FILE.LOG,'since they have open ended element entry for Tax Information element as of 01-JUL-2012' );
4891: fnd_file.put_line(FND_FILE.LOG,'and open ended assignment entry record as of 01-JUL-2012' );
4892: FND_FILE.NEW_LINE(FND_FILE.LOG);
4893:
4894: FOR asgrec IN csr_ele_entries(l_element_type_id,l_inp_value_id_table(13))
4895: LOOP
4896:

Line 4916: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ')' );

4912: FETCH get_emp_details INTO l_full_name , l_emp_num;
4913: CLOSE get_emp_details;
4914:
4915: IF l_full_name is not null and l_emp_num is not null and l_business_group_id = p_business_group_id THEN
4916: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ')' );
4917: l_count := l_count + 1;
4918: END IF;
4919:
4920: END IF;

Line 4921: -- FND_FILE.NEW_LINE(FND_FILE.LOG);

4917: l_count := l_count + 1;
4918: END IF;
4919:
4920: END IF;
4921: -- FND_FILE.NEW_LINE(FND_FILE.LOG);
4922:
4923: END LOOP;
4924:
4925: IF l_count = 0 THEN

Line 4926: FND_FILE.NEW_LINE(FND_FILE.LOG);

4922:
4923: END LOOP;
4924:
4925: IF l_count = 0 THEN
4926: FND_FILE.NEW_LINE(FND_FILE.LOG);
4927: fnd_file.put_line(FND_FILE.LOG,'No Employees exist under this category' );
4928: END IF;
4929:
4930: IF l_count > 0 THEN

Line 4927: fnd_file.put_line(FND_FILE.LOG,'No Employees exist under this category' );

4923: END LOOP;
4924:
4925: IF l_count = 0 THEN
4926: FND_FILE.NEW_LINE(FND_FILE.LOG);
4927: fnd_file.put_line(FND_FILE.LOG,'No Employees exist under this category' );
4928: END IF;
4929:
4930: IF l_count > 0 THEN
4931: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 4931: FND_FILE.NEW_LINE(FND_FILE.LOG);

4927: fnd_file.put_line(FND_FILE.LOG,'No Employees exist under this category' );
4928: END IF;
4929:
4930: IF l_count > 0 THEN
4931: FND_FILE.NEW_LINE(FND_FILE.LOG);
4932: fnd_file.put_line(FND_FILE.LOG,'Total Number of Employees eligible for upgrade = '||l_count);
4933: END IF;
4934:
4935: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 4932: fnd_file.put_line(FND_FILE.LOG,'Total Number of Employees eligible for upgrade = '||l_count);

4928: END IF;
4929:
4930: IF l_count > 0 THEN
4931: FND_FILE.NEW_LINE(FND_FILE.LOG);
4932: fnd_file.put_line(FND_FILE.LOG,'Total Number of Employees eligible for upgrade = '||l_count);
4933: END IF;
4934:
4935: FND_FILE.NEW_LINE(FND_FILE.LOG);
4936: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');

Line 4935: FND_FILE.NEW_LINE(FND_FILE.LOG);

4931: FND_FILE.NEW_LINE(FND_FILE.LOG);
4932: fnd_file.put_line(FND_FILE.LOG,'Total Number of Employees eligible for upgrade = '||l_count);
4933: END IF;
4934:
4935: FND_FILE.NEW_LINE(FND_FILE.LOG);
4936: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');
4937: FND_FILE.NEW_LINE(FND_FILE.LOG);
4938:
4939: fnd_file.put_line(FND_FILE.LOG,'Listing of Employees with current tax scale = 7 and eligible for upgrade to tax scale = 2');

Line 4936: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');

4932: fnd_file.put_line(FND_FILE.LOG,'Total Number of Employees eligible for upgrade = '||l_count);
4933: END IF;
4934:
4935: FND_FILE.NEW_LINE(FND_FILE.LOG);
4936: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');
4937: FND_FILE.NEW_LINE(FND_FILE.LOG);
4938:
4939: fnd_file.put_line(FND_FILE.LOG,'Listing of Employees with current tax scale = 7 and eligible for upgrade to tax scale = 2');
4940: fnd_file.put_line(FND_FILE.LOG,'but having future-dated/end-dated element entries for Tax Information element and (or) having future-dated/end-dated assignment changes post 01-JUL-2012' );

Line 4937: FND_FILE.NEW_LINE(FND_FILE.LOG);

4933: END IF;
4934:
4935: FND_FILE.NEW_LINE(FND_FILE.LOG);
4936: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');
4937: FND_FILE.NEW_LINE(FND_FILE.LOG);
4938:
4939: fnd_file.put_line(FND_FILE.LOG,'Listing of Employees with current tax scale = 7 and eligible for upgrade to tax scale = 2');
4940: fnd_file.put_line(FND_FILE.LOG,'but having future-dated/end-dated element entries for Tax Information element and (or) having future-dated/end-dated assignment changes post 01-JUL-2012' );
4941: fnd_file.put_line(FND_FILE.LOG,'Please delete the future-dated/end-dated element entries and (or) future-dated/end-dated assignment changes before running program in UPGRADE mode');

Line 4939: fnd_file.put_line(FND_FILE.LOG,'Listing of Employees with current tax scale = 7 and eligible for upgrade to tax scale = 2');

4935: FND_FILE.NEW_LINE(FND_FILE.LOG);
4936: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');
4937: FND_FILE.NEW_LINE(FND_FILE.LOG);
4938:
4939: fnd_file.put_line(FND_FILE.LOG,'Listing of Employees with current tax scale = 7 and eligible for upgrade to tax scale = 2');
4940: fnd_file.put_line(FND_FILE.LOG,'but having future-dated/end-dated element entries for Tax Information element and (or) having future-dated/end-dated assignment changes post 01-JUL-2012' );
4941: fnd_file.put_line(FND_FILE.LOG,'Please delete the future-dated/end-dated element entries and (or) future-dated/end-dated assignment changes before running program in UPGRADE mode');
4942: fnd_file.put_line(FND_FILE.LOG,'OR');
4943: fnd_file.put_line(FND_FILE.LOG,'Modify the tax scale of these employees manually from 7 to 2 effective 01-JUL-2012');

Line 4940: fnd_file.put_line(FND_FILE.LOG,'but having future-dated/end-dated element entries for Tax Information element and (or) having future-dated/end-dated assignment changes post 01-JUL-2012' );

4936: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');
4937: FND_FILE.NEW_LINE(FND_FILE.LOG);
4938:
4939: fnd_file.put_line(FND_FILE.LOG,'Listing of Employees with current tax scale = 7 and eligible for upgrade to tax scale = 2');
4940: fnd_file.put_line(FND_FILE.LOG,'but having future-dated/end-dated element entries for Tax Information element and (or) having future-dated/end-dated assignment changes post 01-JUL-2012' );
4941: fnd_file.put_line(FND_FILE.LOG,'Please delete the future-dated/end-dated element entries and (or) future-dated/end-dated assignment changes before running program in UPGRADE mode');
4942: fnd_file.put_line(FND_FILE.LOG,'OR');
4943: fnd_file.put_line(FND_FILE.LOG,'Modify the tax scale of these employees manually from 7 to 2 effective 01-JUL-2012');
4944: fnd_file.put_line(FND_FILE.LOG,'Manually Changing the Assignments Leave Loading Flag from "No" to "Yes" effective 01-JUL-2012 ');

Line 4941: fnd_file.put_line(FND_FILE.LOG,'Please delete the future-dated/end-dated element entries and (or) future-dated/end-dated assignment changes before running program in UPGRADE mode');

4937: FND_FILE.NEW_LINE(FND_FILE.LOG);
4938:
4939: fnd_file.put_line(FND_FILE.LOG,'Listing of Employees with current tax scale = 7 and eligible for upgrade to tax scale = 2');
4940: fnd_file.put_line(FND_FILE.LOG,'but having future-dated/end-dated element entries for Tax Information element and (or) having future-dated/end-dated assignment changes post 01-JUL-2012' );
4941: fnd_file.put_line(FND_FILE.LOG,'Please delete the future-dated/end-dated element entries and (or) future-dated/end-dated assignment changes before running program in UPGRADE mode');
4942: fnd_file.put_line(FND_FILE.LOG,'OR');
4943: fnd_file.put_line(FND_FILE.LOG,'Modify the tax scale of these employees manually from 7 to 2 effective 01-JUL-2012');
4944: fnd_file.put_line(FND_FILE.LOG,'Manually Changing the Assignments Leave Loading Flag from "No" to "Yes" effective 01-JUL-2012 ');
4945: fnd_file.put_line(FND_FILE.LOG,'changes the existing Tax Scale of these employees from 7 to 2');

Line 4942: fnd_file.put_line(FND_FILE.LOG,'OR');

4938:
4939: fnd_file.put_line(FND_FILE.LOG,'Listing of Employees with current tax scale = 7 and eligible for upgrade to tax scale = 2');
4940: fnd_file.put_line(FND_FILE.LOG,'but having future-dated/end-dated element entries for Tax Information element and (or) having future-dated/end-dated assignment changes post 01-JUL-2012' );
4941: fnd_file.put_line(FND_FILE.LOG,'Please delete the future-dated/end-dated element entries and (or) future-dated/end-dated assignment changes before running program in UPGRADE mode');
4942: fnd_file.put_line(FND_FILE.LOG,'OR');
4943: fnd_file.put_line(FND_FILE.LOG,'Modify the tax scale of these employees manually from 7 to 2 effective 01-JUL-2012');
4944: fnd_file.put_line(FND_FILE.LOG,'Manually Changing the Assignments Leave Loading Flag from "No" to "Yes" effective 01-JUL-2012 ');
4945: fnd_file.put_line(FND_FILE.LOG,'changes the existing Tax Scale of these employees from 7 to 2');
4946: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 4943: fnd_file.put_line(FND_FILE.LOG,'Modify the tax scale of these employees manually from 7 to 2 effective 01-JUL-2012');

4939: fnd_file.put_line(FND_FILE.LOG,'Listing of Employees with current tax scale = 7 and eligible for upgrade to tax scale = 2');
4940: fnd_file.put_line(FND_FILE.LOG,'but having future-dated/end-dated element entries for Tax Information element and (or) having future-dated/end-dated assignment changes post 01-JUL-2012' );
4941: fnd_file.put_line(FND_FILE.LOG,'Please delete the future-dated/end-dated element entries and (or) future-dated/end-dated assignment changes before running program in UPGRADE mode');
4942: fnd_file.put_line(FND_FILE.LOG,'OR');
4943: fnd_file.put_line(FND_FILE.LOG,'Modify the tax scale of these employees manually from 7 to 2 effective 01-JUL-2012');
4944: fnd_file.put_line(FND_FILE.LOG,'Manually Changing the Assignments Leave Loading Flag from "No" to "Yes" effective 01-JUL-2012 ');
4945: fnd_file.put_line(FND_FILE.LOG,'changes the existing Tax Scale of these employees from 7 to 2');
4946: FND_FILE.NEW_LINE(FND_FILE.LOG);
4947:

Line 4944: fnd_file.put_line(FND_FILE.LOG,'Manually Changing the Assignments Leave Loading Flag from "No" to "Yes" effective 01-JUL-2012 ');

4940: fnd_file.put_line(FND_FILE.LOG,'but having future-dated/end-dated element entries for Tax Information element and (or) having future-dated/end-dated assignment changes post 01-JUL-2012' );
4941: fnd_file.put_line(FND_FILE.LOG,'Please delete the future-dated/end-dated element entries and (or) future-dated/end-dated assignment changes before running program in UPGRADE mode');
4942: fnd_file.put_line(FND_FILE.LOG,'OR');
4943: fnd_file.put_line(FND_FILE.LOG,'Modify the tax scale of these employees manually from 7 to 2 effective 01-JUL-2012');
4944: fnd_file.put_line(FND_FILE.LOG,'Manually Changing the Assignments Leave Loading Flag from "No" to "Yes" effective 01-JUL-2012 ');
4945: fnd_file.put_line(FND_FILE.LOG,'changes the existing Tax Scale of these employees from 7 to 2');
4946: FND_FILE.NEW_LINE(FND_FILE.LOG);
4947:
4948: l_count := 0;

Line 4945: fnd_file.put_line(FND_FILE.LOG,'changes the existing Tax Scale of these employees from 7 to 2');

4941: fnd_file.put_line(FND_FILE.LOG,'Please delete the future-dated/end-dated element entries and (or) future-dated/end-dated assignment changes before running program in UPGRADE mode');
4942: fnd_file.put_line(FND_FILE.LOG,'OR');
4943: fnd_file.put_line(FND_FILE.LOG,'Modify the tax scale of these employees manually from 7 to 2 effective 01-JUL-2012');
4944: fnd_file.put_line(FND_FILE.LOG,'Manually Changing the Assignments Leave Loading Flag from "No" to "Yes" effective 01-JUL-2012 ');
4945: fnd_file.put_line(FND_FILE.LOG,'changes the existing Tax Scale of these employees from 7 to 2');
4946: FND_FILE.NEW_LINE(FND_FILE.LOG);
4947:
4948: l_count := 0;
4949:

Line 4946: FND_FILE.NEW_LINE(FND_FILE.LOG);

4942: fnd_file.put_line(FND_FILE.LOG,'OR');
4943: fnd_file.put_line(FND_FILE.LOG,'Modify the tax scale of these employees manually from 7 to 2 effective 01-JUL-2012');
4944: fnd_file.put_line(FND_FILE.LOG,'Manually Changing the Assignments Leave Loading Flag from "No" to "Yes" effective 01-JUL-2012 ');
4945: fnd_file.put_line(FND_FILE.LOG,'changes the existing Tax Scale of these employees from 7 to 2');
4946: FND_FILE.NEW_LINE(FND_FILE.LOG);
4947:
4948: l_count := 0;
4949:
4950: FOR asgrec IN csr_fut_ele_entries(l_element_type_id,l_inp_value_id_table(13))

Line 4965: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ') has future-dated/end-dated element entries' );

4961: OPEN get_emp_details(asgrec.assignment_id) ;
4962: FETCH get_emp_details INTO l_full_name,l_emp_num;
4963: CLOSE get_emp_details;
4964:
4965: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ') has future-dated/end-dated element entries' );
4966: FND_FILE.NEW_LINE(FND_FILE.LOG);
4967:
4968: OPEN csr_fut_asg_rec(asgrec.assignment_id);
4969: FETCH csr_fut_asg_rec INTO l_asg_exist;

Line 4966: FND_FILE.NEW_LINE(FND_FILE.LOG);

4962: FETCH get_emp_details INTO l_full_name,l_emp_num;
4963: CLOSE get_emp_details;
4964:
4965: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ') has future-dated/end-dated element entries' );
4966: FND_FILE.NEW_LINE(FND_FILE.LOG);
4967:
4968: OPEN csr_fut_asg_rec(asgrec.assignment_id);
4969: FETCH csr_fut_asg_rec INTO l_asg_exist;
4970: CLOSE csr_fut_asg_rec;

Line 4973: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ') has future-dated/end-dated assignment records' );

4969: FETCH csr_fut_asg_rec INTO l_asg_exist;
4970: CLOSE csr_fut_asg_rec;
4971:
4972: IF l_asg_exist > 0 THEN
4973: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ') has future-dated/end-dated assignment records' );
4974: FND_FILE.NEW_LINE(FND_FILE.LOG);
4975: END IF;
4976:
4977: -- FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 4974: FND_FILE.NEW_LINE(FND_FILE.LOG);

4970: CLOSE csr_fut_asg_rec;
4971:
4972: IF l_asg_exist > 0 THEN
4973: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ') has future-dated/end-dated assignment records' );
4974: FND_FILE.NEW_LINE(FND_FILE.LOG);
4975: END IF;
4976:
4977: -- FND_FILE.NEW_LINE(FND_FILE.LOG);
4978: l_count := l_count + 1;

Line 4977: -- FND_FILE.NEW_LINE(FND_FILE.LOG);

4973: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ') has future-dated/end-dated assignment records' );
4974: FND_FILE.NEW_LINE(FND_FILE.LOG);
4975: END IF;
4976:
4977: -- FND_FILE.NEW_LINE(FND_FILE.LOG);
4978: l_count := l_count + 1;
4979: END IF;
4980: END LOOP;
4981:

Line 4982: FND_FILE.NEW_LINE(FND_FILE.LOG);

4978: l_count := l_count + 1;
4979: END IF;
4980: END LOOP;
4981:
4982: FND_FILE.NEW_LINE(FND_FILE.LOG);
4983:
4984: FOR asgrec IN csr_ele_entries(l_element_type_id,l_inp_value_id_table(13))
4985: LOOP
4986:

Line 5007: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ') has future-dated/end-dated assignment records' );

5003:
5004: IF l_business_group_id = p_business_group_id THEN
5005: IF l_asg_exist > 0 THEN
5006:
5007: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ') has future-dated/end-dated assignment records' );
5008: FND_FILE.NEW_LINE(FND_FILE.LOG);
5009: l_count := l_count + 1;
5010:
5011: ELSIF l_full_name is null and l_emp_num is null THEN

Line 5008: FND_FILE.NEW_LINE(FND_FILE.LOG);

5004: IF l_business_group_id = p_business_group_id THEN
5005: IF l_asg_exist > 0 THEN
5006:
5007: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ') has future-dated/end-dated assignment records' );
5008: FND_FILE.NEW_LINE(FND_FILE.LOG);
5009: l_count := l_count + 1;
5010:
5011: ELSIF l_full_name is null and l_emp_num is null THEN
5012: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ') does not have any assignment record, but has some element entries attached to assignment');

Line 5012: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ') does not have any assignment record, but has some element entries attached to assignment');

5008: FND_FILE.NEW_LINE(FND_FILE.LOG);
5009: l_count := l_count + 1;
5010:
5011: ELSIF l_full_name is null and l_emp_num is null THEN
5012: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ') does not have any assignment record, but has some element entries attached to assignment');
5013: fnd_file.put_line(FND_FILE.LOG,'Please check the data setup for the assignment on Assignment Form and insert the assignment details appropriately' );
5014: fnd_file.put_line(FND_FILE.LOG,'This could probably be a case of data corruption' );
5015: FND_FILE.NEW_LINE(FND_FILE.LOG);
5016: l_count := l_count + 1;

Line 5013: fnd_file.put_line(FND_FILE.LOG,'Please check the data setup for the assignment on Assignment Form and insert the assignment details appropriately' );

5009: l_count := l_count + 1;
5010:
5011: ELSIF l_full_name is null and l_emp_num is null THEN
5012: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ') does not have any assignment record, but has some element entries attached to assignment');
5013: fnd_file.put_line(FND_FILE.LOG,'Please check the data setup for the assignment on Assignment Form and insert the assignment details appropriately' );
5014: fnd_file.put_line(FND_FILE.LOG,'This could probably be a case of data corruption' );
5015: FND_FILE.NEW_LINE(FND_FILE.LOG);
5016: l_count := l_count + 1;
5017:

Line 5014: fnd_file.put_line(FND_FILE.LOG,'This could probably be a case of data corruption' );

5010:
5011: ELSIF l_full_name is null and l_emp_num is null THEN
5012: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ') does not have any assignment record, but has some element entries attached to assignment');
5013: fnd_file.put_line(FND_FILE.LOG,'Please check the data setup for the assignment on Assignment Form and insert the assignment details appropriately' );
5014: fnd_file.put_line(FND_FILE.LOG,'This could probably be a case of data corruption' );
5015: FND_FILE.NEW_LINE(FND_FILE.LOG);
5016: l_count := l_count + 1;
5017:
5018: END IF;

Line 5015: FND_FILE.NEW_LINE(FND_FILE.LOG);

5011: ELSIF l_full_name is null and l_emp_num is null THEN
5012: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ') does not have any assignment record, but has some element entries attached to assignment');
5013: fnd_file.put_line(FND_FILE.LOG,'Please check the data setup for the assignment on Assignment Form and insert the assignment details appropriately' );
5014: fnd_file.put_line(FND_FILE.LOG,'This could probably be a case of data corruption' );
5015: FND_FILE.NEW_LINE(FND_FILE.LOG);
5016: l_count := l_count + 1;
5017:
5018: END IF;
5019: END IF;

Line 5026: FND_FILE.NEW_LINE(FND_FILE.LOG);

5022:
5023: END LOOP;
5024:
5025: IF l_count = 0 THEN
5026: FND_FILE.NEW_LINE(FND_FILE.LOG);
5027: fnd_file.put_line(FND_FILE.LOG,'No Employees exist under this category' );
5028: END IF;
5029:
5030: IF l_count > 0 THEN

Line 5027: fnd_file.put_line(FND_FILE.LOG,'No Employees exist under this category' );

5023: END LOOP;
5024:
5025: IF l_count = 0 THEN
5026: FND_FILE.NEW_LINE(FND_FILE.LOG);
5027: fnd_file.put_line(FND_FILE.LOG,'No Employees exist under this category' );
5028: END IF;
5029:
5030: IF l_count > 0 THEN
5031: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 5031: FND_FILE.NEW_LINE(FND_FILE.LOG);

5027: fnd_file.put_line(FND_FILE.LOG,'No Employees exist under this category' );
5028: END IF;
5029:
5030: IF l_count > 0 THEN
5031: FND_FILE.NEW_LINE(FND_FILE.LOG);
5032: fnd_file.put_line(FND_FILE.LOG,'Total Number of Employees ineligible for upgrade = '||l_count);
5033: END IF;
5034:
5035: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 5032: fnd_file.put_line(FND_FILE.LOG,'Total Number of Employees ineligible for upgrade = '||l_count);

5028: END IF;
5029:
5030: IF l_count > 0 THEN
5031: FND_FILE.NEW_LINE(FND_FILE.LOG);
5032: fnd_file.put_line(FND_FILE.LOG,'Total Number of Employees ineligible for upgrade = '||l_count);
5033: END IF;
5034:
5035: FND_FILE.NEW_LINE(FND_FILE.LOG);
5036: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');

Line 5035: FND_FILE.NEW_LINE(FND_FILE.LOG);

5031: FND_FILE.NEW_LINE(FND_FILE.LOG);
5032: fnd_file.put_line(FND_FILE.LOG,'Total Number of Employees ineligible for upgrade = '||l_count);
5033: END IF;
5034:
5035: FND_FILE.NEW_LINE(FND_FILE.LOG);
5036: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');
5037: FND_FILE.NEW_LINE(FND_FILE.LOG);
5038:
5039: ELSIF l_run_mode = 'All' THEN

Line 5036: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');

5032: fnd_file.put_line(FND_FILE.LOG,'Total Number of Employees ineligible for upgrade = '||l_count);
5033: END IF;
5034:
5035: FND_FILE.NEW_LINE(FND_FILE.LOG);
5036: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');
5037: FND_FILE.NEW_LINE(FND_FILE.LOG);
5038:
5039: ELSIF l_run_mode = 'All' THEN
5040:

Line 5037: FND_FILE.NEW_LINE(FND_FILE.LOG);

5033: END IF;
5034:
5035: FND_FILE.NEW_LINE(FND_FILE.LOG);
5036: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');
5037: FND_FILE.NEW_LINE(FND_FILE.LOG);
5038:
5039: ELSIF l_run_mode = 'All' THEN
5040:
5041: fnd_file.put_line(FND_FILE.LOG,'Listing of all upgraded employees with tax scale = 2 as of 01-JUL-2012' );

Line 5041: fnd_file.put_line(FND_FILE.LOG,'Listing of all upgraded employees with tax scale = 2 as of 01-JUL-2012' );

5037: FND_FILE.NEW_LINE(FND_FILE.LOG);
5038:
5039: ELSIF l_run_mode = 'All' THEN
5040:
5041: fnd_file.put_line(FND_FILE.LOG,'Listing of all upgraded employees with tax scale = 2 as of 01-JUL-2012' );
5042: FND_FILE.NEW_LINE(FND_FILE.LOG);
5043:
5044: l_count := 0;
5045: FOR csritr IN csr_asg_curr_scale(l_element_type_id,l_inp_value_id_table(13))

Line 5042: FND_FILE.NEW_LINE(FND_FILE.LOG);

5038:
5039: ELSIF l_run_mode = 'All' THEN
5040:
5041: fnd_file.put_line(FND_FILE.LOG,'Listing of all upgraded employees with tax scale = 2 as of 01-JUL-2012' );
5042: FND_FILE.NEW_LINE(FND_FILE.LOG);
5043:
5044: l_count := 0;
5045: FOR csritr IN csr_asg_curr_scale(l_element_type_id,l_inp_value_id_table(13))
5046: LOOP

Line 5059: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||csritr.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ')' );

5055: FETCH get_bg_id INTO l_business_group_id;
5056: CLOSE get_bg_id;
5057:
5058: IF l_business_group_id = p_business_group_id THEN
5059: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||csritr.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num || ')' );
5060: l_count := l_count + 1;
5061: END IF;
5062:
5063: END LOOP;

Line 5066: FND_FILE.NEW_LINE(FND_FILE.LOG);

5062:
5063: END LOOP;
5064:
5065: IF l_count > 0 THEN
5066: FND_FILE.NEW_LINE(FND_FILE.LOG);
5067: fnd_file.put_line(FND_FILE.LOG,'Total Number of upgraded Employees with tax scale = 2 are '||l_count);
5068: END IF;
5069:
5070: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 5067: fnd_file.put_line(FND_FILE.LOG,'Total Number of upgraded Employees with tax scale = 2 are '||l_count);

5063: END LOOP;
5064:
5065: IF l_count > 0 THEN
5066: FND_FILE.NEW_LINE(FND_FILE.LOG);
5067: fnd_file.put_line(FND_FILE.LOG,'Total Number of upgraded Employees with tax scale = 2 are '||l_count);
5068: END IF;
5069:
5070: FND_FILE.NEW_LINE(FND_FILE.LOG);
5071: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');

Line 5070: FND_FILE.NEW_LINE(FND_FILE.LOG);

5066: FND_FILE.NEW_LINE(FND_FILE.LOG);
5067: fnd_file.put_line(FND_FILE.LOG,'Total Number of upgraded Employees with tax scale = 2 are '||l_count);
5068: END IF;
5069:
5070: FND_FILE.NEW_LINE(FND_FILE.LOG);
5071: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');
5072: FND_FILE.NEW_LINE(FND_FILE.LOG);
5073: ELSIF l_run_mode = 'Upgrading Mode' THEN
5074: fnd_file.put_line(FND_FILE.LOG,'Upgrading Tax Scales for Employee from 7 to 2 ' );

Line 5071: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');

5067: fnd_file.put_line(FND_FILE.LOG,'Total Number of upgraded Employees with tax scale = 2 are '||l_count);
5068: END IF;
5069:
5070: FND_FILE.NEW_LINE(FND_FILE.LOG);
5071: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');
5072: FND_FILE.NEW_LINE(FND_FILE.LOG);
5073: ELSIF l_run_mode = 'Upgrading Mode' THEN
5074: fnd_file.put_line(FND_FILE.LOG,'Upgrading Tax Scales for Employee from 7 to 2 ' );
5075: fnd_file.put_line(FND_FILE.LOG,'This mode will update the Assignment Leave Loading Flag from No to Yes effective 01-JUL-2012' );

Line 5072: FND_FILE.NEW_LINE(FND_FILE.LOG);

5068: END IF;
5069:
5070: FND_FILE.NEW_LINE(FND_FILE.LOG);
5071: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');
5072: FND_FILE.NEW_LINE(FND_FILE.LOG);
5073: ELSIF l_run_mode = 'Upgrading Mode' THEN
5074: fnd_file.put_line(FND_FILE.LOG,'Upgrading Tax Scales for Employee from 7 to 2 ' );
5075: fnd_file.put_line(FND_FILE.LOG,'This mode will update the Assignment Leave Loading Flag from No to Yes effective 01-JUL-2012' );
5076: fnd_file.put_line(FND_FILE.LOG,'This mode will also update the Assignment Tax Scale in element entries from 7 to 2 effective 01-JUL-2012' );

Line 5074: fnd_file.put_line(FND_FILE.LOG,'Upgrading Tax Scales for Employee from 7 to 2 ' );

5070: FND_FILE.NEW_LINE(FND_FILE.LOG);
5071: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');
5072: FND_FILE.NEW_LINE(FND_FILE.LOG);
5073: ELSIF l_run_mode = 'Upgrading Mode' THEN
5074: fnd_file.put_line(FND_FILE.LOG,'Upgrading Tax Scales for Employee from 7 to 2 ' );
5075: fnd_file.put_line(FND_FILE.LOG,'This mode will update the Assignment Leave Loading Flag from No to Yes effective 01-JUL-2012' );
5076: fnd_file.put_line(FND_FILE.LOG,'This mode will also update the Assignment Tax Scale in element entries from 7 to 2 effective 01-JUL-2012' );
5077: fnd_file.put_line(FND_FILE.LOG,'UPGRADE is only done for those employees having open ended element entry for Tax Information element as of 01-JUL-2012' );
5078: fnd_file.put_line(FND_FILE.LOG,'and having open ended assignment entry record as of 01-JUL-2012');

Line 5075: fnd_file.put_line(FND_FILE.LOG,'This mode will update the Assignment Leave Loading Flag from No to Yes effective 01-JUL-2012' );

5071: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------------------------------------');
5072: FND_FILE.NEW_LINE(FND_FILE.LOG);
5073: ELSIF l_run_mode = 'Upgrading Mode' THEN
5074: fnd_file.put_line(FND_FILE.LOG,'Upgrading Tax Scales for Employee from 7 to 2 ' );
5075: fnd_file.put_line(FND_FILE.LOG,'This mode will update the Assignment Leave Loading Flag from No to Yes effective 01-JUL-2012' );
5076: fnd_file.put_line(FND_FILE.LOG,'This mode will also update the Assignment Tax Scale in element entries from 7 to 2 effective 01-JUL-2012' );
5077: fnd_file.put_line(FND_FILE.LOG,'UPGRADE is only done for those employees having open ended element entry for Tax Information element as of 01-JUL-2012' );
5078: fnd_file.put_line(FND_FILE.LOG,'and having open ended assignment entry record as of 01-JUL-2012');
5079: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 5076: fnd_file.put_line(FND_FILE.LOG,'This mode will also update the Assignment Tax Scale in element entries from 7 to 2 effective 01-JUL-2012' );

5072: FND_FILE.NEW_LINE(FND_FILE.LOG);
5073: ELSIF l_run_mode = 'Upgrading Mode' THEN
5074: fnd_file.put_line(FND_FILE.LOG,'Upgrading Tax Scales for Employee from 7 to 2 ' );
5075: fnd_file.put_line(FND_FILE.LOG,'This mode will update the Assignment Leave Loading Flag from No to Yes effective 01-JUL-2012' );
5076: fnd_file.put_line(FND_FILE.LOG,'This mode will also update the Assignment Tax Scale in element entries from 7 to 2 effective 01-JUL-2012' );
5077: fnd_file.put_line(FND_FILE.LOG,'UPGRADE is only done for those employees having open ended element entry for Tax Information element as of 01-JUL-2012' );
5078: fnd_file.put_line(FND_FILE.LOG,'and having open ended assignment entry record as of 01-JUL-2012');
5079: FND_FILE.NEW_LINE(FND_FILE.LOG);
5080:

Line 5077: fnd_file.put_line(FND_FILE.LOG,'UPGRADE is only done for those employees having open ended element entry for Tax Information element as of 01-JUL-2012' );

5073: ELSIF l_run_mode = 'Upgrading Mode' THEN
5074: fnd_file.put_line(FND_FILE.LOG,'Upgrading Tax Scales for Employee from 7 to 2 ' );
5075: fnd_file.put_line(FND_FILE.LOG,'This mode will update the Assignment Leave Loading Flag from No to Yes effective 01-JUL-2012' );
5076: fnd_file.put_line(FND_FILE.LOG,'This mode will also update the Assignment Tax Scale in element entries from 7 to 2 effective 01-JUL-2012' );
5077: fnd_file.put_line(FND_FILE.LOG,'UPGRADE is only done for those employees having open ended element entry for Tax Information element as of 01-JUL-2012' );
5078: fnd_file.put_line(FND_FILE.LOG,'and having open ended assignment entry record as of 01-JUL-2012');
5079: FND_FILE.NEW_LINE(FND_FILE.LOG);
5080:
5081: l_count := 0;

Line 5078: fnd_file.put_line(FND_FILE.LOG,'and having open ended assignment entry record as of 01-JUL-2012');

5074: fnd_file.put_line(FND_FILE.LOG,'Upgrading Tax Scales for Employee from 7 to 2 ' );
5075: fnd_file.put_line(FND_FILE.LOG,'This mode will update the Assignment Leave Loading Flag from No to Yes effective 01-JUL-2012' );
5076: fnd_file.put_line(FND_FILE.LOG,'This mode will also update the Assignment Tax Scale in element entries from 7 to 2 effective 01-JUL-2012' );
5077: fnd_file.put_line(FND_FILE.LOG,'UPGRADE is only done for those employees having open ended element entry for Tax Information element as of 01-JUL-2012' );
5078: fnd_file.put_line(FND_FILE.LOG,'and having open ended assignment entry record as of 01-JUL-2012');
5079: FND_FILE.NEW_LINE(FND_FILE.LOG);
5080:
5081: l_count := 0;
5082:

Line 5079: FND_FILE.NEW_LINE(FND_FILE.LOG);

5075: fnd_file.put_line(FND_FILE.LOG,'This mode will update the Assignment Leave Loading Flag from No to Yes effective 01-JUL-2012' );
5076: fnd_file.put_line(FND_FILE.LOG,'This mode will also update the Assignment Tax Scale in element entries from 7 to 2 effective 01-JUL-2012' );
5077: fnd_file.put_line(FND_FILE.LOG,'UPGRADE is only done for those employees having open ended element entry for Tax Information element as of 01-JUL-2012' );
5078: fnd_file.put_line(FND_FILE.LOG,'and having open ended assignment entry record as of 01-JUL-2012');
5079: FND_FILE.NEW_LINE(FND_FILE.LOG);
5080:
5081: l_count := 0;
5082:
5083: FOR asgrec IN csr_ele_entries(l_element_type_id,l_inp_value_id_table(13))

Line 5232: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||') succesfully upgraded from Tax Scale 7 to 2' );

5228: );
5229:
5230: COMMIT;
5231:
5232: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||') succesfully upgraded from Tax Scale 7 to 2' );
5233: FND_FILE.NEW_LINE(FND_FILE.LOG);
5234:
5235: l_count := l_count + 1;
5236:

Line 5233: FND_FILE.NEW_LINE(FND_FILE.LOG);

5229:
5230: COMMIT;
5231:
5232: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||') succesfully upgraded from Tax Scale 7 to 2' );
5233: FND_FILE.NEW_LINE(FND_FILE.LOG);
5234:
5235: l_count := l_count + 1;
5236:
5237: ELSE

Line 5238: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||') not upgraded from Tax Scale 7 to 2' );

5234:
5235: l_count := l_count + 1;
5236:
5237: ELSE
5238: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||') not upgraded from Tax Scale 7 to 2' );
5239: fnd_file.put_line(FND_FILE.LOG,'due to non-availability of valid legal employer as of 01-JUL-2012' );
5240: FND_FILE.NEW_LINE(FND_FILE.LOG);
5241: END IF;
5242: ELSE

Line 5239: fnd_file.put_line(FND_FILE.LOG,'due to non-availability of valid legal employer as of 01-JUL-2012' );

5235: l_count := l_count + 1;
5236:
5237: ELSE
5238: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||') not upgraded from Tax Scale 7 to 2' );
5239: fnd_file.put_line(FND_FILE.LOG,'due to non-availability of valid legal employer as of 01-JUL-2012' );
5240: FND_FILE.NEW_LINE(FND_FILE.LOG);
5241: END IF;
5242: ELSE
5243: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||') not upgraded from Tax Scale 7 to 2' );

Line 5240: FND_FILE.NEW_LINE(FND_FILE.LOG);

5236:
5237: ELSE
5238: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||') not upgraded from Tax Scale 7 to 2' );
5239: fnd_file.put_line(FND_FILE.LOG,'due to non-availability of valid legal employer as of 01-JUL-2012' );
5240: FND_FILE.NEW_LINE(FND_FILE.LOG);
5241: END IF;
5242: ELSE
5243: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||') not upgraded from Tax Scale 7 to 2' );
5244: fnd_file.put_line(FND_FILE.LOG,'due to non-availability of valid SCL Information for Assignment as of 01-JUL-2012' );

Line 5243: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||') not upgraded from Tax Scale 7 to 2' );

5239: fnd_file.put_line(FND_FILE.LOG,'due to non-availability of valid legal employer as of 01-JUL-2012' );
5240: FND_FILE.NEW_LINE(FND_FILE.LOG);
5241: END IF;
5242: ELSE
5243: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||') not upgraded from Tax Scale 7 to 2' );
5244: fnd_file.put_line(FND_FILE.LOG,'due to non-availability of valid SCL Information for Assignment as of 01-JUL-2012' );
5245: fnd_file.put_line(FND_FILE.LOG,'Please correct assignment SCL Information and then rerun the upgrade process for this assignment' );
5246: FND_FILE.NEW_LINE(FND_FILE.LOG);
5247: END IF;

Line 5244: fnd_file.put_line(FND_FILE.LOG,'due to non-availability of valid SCL Information for Assignment as of 01-JUL-2012' );

5240: FND_FILE.NEW_LINE(FND_FILE.LOG);
5241: END IF;
5242: ELSE
5243: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||') not upgraded from Tax Scale 7 to 2' );
5244: fnd_file.put_line(FND_FILE.LOG,'due to non-availability of valid SCL Information for Assignment as of 01-JUL-2012' );
5245: fnd_file.put_line(FND_FILE.LOG,'Please correct assignment SCL Information and then rerun the upgrade process for this assignment' );
5246: FND_FILE.NEW_LINE(FND_FILE.LOG);
5247: END IF;
5248: END IF;

Line 5245: fnd_file.put_line(FND_FILE.LOG,'Please correct assignment SCL Information and then rerun the upgrade process for this assignment' );

5241: END IF;
5242: ELSE
5243: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||') not upgraded from Tax Scale 7 to 2' );
5244: fnd_file.put_line(FND_FILE.LOG,'due to non-availability of valid SCL Information for Assignment as of 01-JUL-2012' );
5245: fnd_file.put_line(FND_FILE.LOG,'Please correct assignment SCL Information and then rerun the upgrade process for this assignment' );
5246: FND_FILE.NEW_LINE(FND_FILE.LOG);
5247: END IF;
5248: END IF;
5249: END LOOP;

Line 5246: FND_FILE.NEW_LINE(FND_FILE.LOG);

5242: ELSE
5243: fnd_file.put_line(FND_FILE.LOG,'Assignment ID '||asgrec.assignment_id || ' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||') not upgraded from Tax Scale 7 to 2' );
5244: fnd_file.put_line(FND_FILE.LOG,'due to non-availability of valid SCL Information for Assignment as of 01-JUL-2012' );
5245: fnd_file.put_line(FND_FILE.LOG,'Please correct assignment SCL Information and then rerun the upgrade process for this assignment' );
5246: FND_FILE.NEW_LINE(FND_FILE.LOG);
5247: END IF;
5248: END IF;
5249: END LOOP;
5250:

Line 5252: FND_FILE.NEW_LINE(FND_FILE.LOG);

5248: END IF;
5249: END LOOP;
5250:
5251: IF l_upgraded = 0 THEN
5252: FND_FILE.NEW_LINE(FND_FILE.LOG);
5253: fnd_file.put_line(FND_FILE.LOG,'No assignments upgraded from tax scale = 7 to tax scale = 2' );
5254: END IF;
5255:
5256: IF l_count > 0 THEN

Line 5253: fnd_file.put_line(FND_FILE.LOG,'No assignments upgraded from tax scale = 7 to tax scale = 2' );

5249: END LOOP;
5250:
5251: IF l_upgraded = 0 THEN
5252: FND_FILE.NEW_LINE(FND_FILE.LOG);
5253: fnd_file.put_line(FND_FILE.LOG,'No assignments upgraded from tax scale = 7 to tax scale = 2' );
5254: END IF;
5255:
5256: IF l_count > 0 THEN
5257: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 5257: FND_FILE.NEW_LINE(FND_FILE.LOG);

5253: fnd_file.put_line(FND_FILE.LOG,'No assignments upgraded from tax scale = 7 to tax scale = 2' );
5254: END IF;
5255:
5256: IF l_count > 0 THEN
5257: FND_FILE.NEW_LINE(FND_FILE.LOG);
5258: fnd_file.put_line(FND_FILE.LOG,'Total Number of succesfully upgraded Employees = '||l_count);
5259: END IF;
5260:
5261: ELSE /* upgrading future or end dated assignments */

Line 5258: fnd_file.put_line(FND_FILE.LOG,'Total Number of succesfully upgraded Employees = '||l_count);

5254: END IF;
5255:
5256: IF l_count > 0 THEN
5257: FND_FILE.NEW_LINE(FND_FILE.LOG);
5258: fnd_file.put_line(FND_FILE.LOG,'Total Number of succesfully upgraded Employees = '||l_count);
5259: END IF;
5260:
5261: ELSE /* upgrading future or end dated assignments */
5262:

Line 5263: fnd_file.put_line(FND_FILE.LOG,'Upgrading Tax Scales for Future or End Dated Employee from 7 to 2 ' );

5259: END IF;
5260:
5261: ELSE /* upgrading future or end dated assignments */
5262:
5263: fnd_file.put_line(FND_FILE.LOG,'Upgrading Tax Scales for Future or End Dated Employee from 7 to 2 ' );
5264: fnd_file.put_line(FND_FILE.LOG,'This mode will update the Assignment Leave Loading Flag from No to Yes effective 01-JUL-2012' );
5265: fnd_file.put_line(FND_FILE.LOG,'This mode will also update the Assignment Tax Scale in element entries from 7 to 2 effective 01-JUL-2012' );
5266:
5267: -- below code is for scenarios where single/multiple future dated element entries for tax information, single/multiple future dated records for assignment

Line 5264: fnd_file.put_line(FND_FILE.LOG,'This mode will update the Assignment Leave Loading Flag from No to Yes effective 01-JUL-2012' );

5260:
5261: ELSE /* upgrading future or end dated assignments */
5262:
5263: fnd_file.put_line(FND_FILE.LOG,'Upgrading Tax Scales for Future or End Dated Employee from 7 to 2 ' );
5264: fnd_file.put_line(FND_FILE.LOG,'This mode will update the Assignment Leave Loading Flag from No to Yes effective 01-JUL-2012' );
5265: fnd_file.put_line(FND_FILE.LOG,'This mode will also update the Assignment Tax Scale in element entries from 7 to 2 effective 01-JUL-2012' );
5266:
5267: -- below code is for scenarios where single/multiple future dated element entries for tax information, single/multiple future dated records for assignment
5268: FOR asgrec IN csr_fut_ele_entries(l_element_type_id,l_inp_value_id_table(13)) LOOP

Line 5265: fnd_file.put_line(FND_FILE.LOG,'This mode will also update the Assignment Tax Scale in element entries from 7 to 2 effective 01-JUL-2012' );

5261: ELSE /* upgrading future or end dated assignments */
5262:
5263: fnd_file.put_line(FND_FILE.LOG,'Upgrading Tax Scales for Future or End Dated Employee from 7 to 2 ' );
5264: fnd_file.put_line(FND_FILE.LOG,'This mode will update the Assignment Leave Loading Flag from No to Yes effective 01-JUL-2012' );
5265: fnd_file.put_line(FND_FILE.LOG,'This mode will also update the Assignment Tax Scale in element entries from 7 to 2 effective 01-JUL-2012' );
5266:
5267: -- below code is for scenarios where single/multiple future dated element entries for tax information, single/multiple future dated records for assignment
5268: FOR asgrec IN csr_fut_ele_entries(l_element_type_id,l_inp_value_id_table(13)) LOOP
5269: l_le_id := -1;

Line 5348: fnd_file.new_line(FND_FILE.LOG);

5344: ,p_no_managers_warning => l_no_managers_warning -- out parameter
5345: ,p_other_manager_warning => l_other_manager_warning -- out parameter
5346: );
5347: COMMIT;
5348: fnd_file.new_line(FND_FILE.LOG);
5349: fnd_file.put_line(FND_FILE.LOG,'succesfully changed leave loading flag for assignment record as of 01-JUL-2012 for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');
5350: END IF;
5351: END IF;
5352: END LOOP;

Line 5349: fnd_file.put_line(FND_FILE.LOG,'succesfully changed leave loading flag for assignment record as of 01-JUL-2012 for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');

5345: ,p_other_manager_warning => l_other_manager_warning -- out parameter
5346: );
5347: COMMIT;
5348: fnd_file.new_line(FND_FILE.LOG);
5349: fnd_file.put_line(FND_FILE.LOG,'succesfully changed leave loading flag for assignment record as of 01-JUL-2012 for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');
5350: END IF;
5351: END IF;
5352: END LOOP;
5353:

Line 5401: fnd_file.new_line(FND_FILE.LOG);

5397: ,p_no_managers_warning => l_no_managers_warning -- out parameter
5398: ,p_other_manager_warning => l_other_manager_warning -- out parameter
5399: );
5400: COMMIT;
5401: fnd_file.new_line(FND_FILE.LOG);
5402: fnd_file.put_line(FND_FILE.LOG,'succesfully changed leave loading flag for future assignment records for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');
5403: END IF;
5404: END IF;
5405: END LOOP;

Line 5402: fnd_file.put_line(FND_FILE.LOG,'succesfully changed leave loading flag for future assignment records for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');

5398: ,p_other_manager_warning => l_other_manager_warning -- out parameter
5399: );
5400: COMMIT;
5401: fnd_file.new_line(FND_FILE.LOG);
5402: fnd_file.put_line(FND_FILE.LOG,'succesfully changed leave loading flag for future assignment records for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');
5403: END IF;
5404: END IF;
5405: END LOOP;
5406:

Line 5507: fnd_file.new_line(FND_FILE.LOG);

5503: ,p_override_user_ent_chk => 'Y'
5504: );
5505:
5506: COMMIT;
5507: fnd_file.new_line(FND_FILE.LOG);
5508: fnd_file.put_line(FND_FILE.LOG,'succesfully changed tax scale for element record as of 01-JUL-2012 for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');
5509: END IF;
5510:
5511: END LOOP;

Line 5508: fnd_file.put_line(FND_FILE.LOG,'succesfully changed tax scale for element record as of 01-JUL-2012 for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');

5504: );
5505:
5506: COMMIT;
5507: fnd_file.new_line(FND_FILE.LOG);
5508: fnd_file.put_line(FND_FILE.LOG,'succesfully changed tax scale for element record as of 01-JUL-2012 for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');
5509: END IF;
5510:
5511: END LOOP;
5512:

Line 5571: fnd_file.new_line(FND_FILE.LOG);

5567: ,p_override_user_ent_chk => 'Y'
5568: );
5569:
5570: COMMIT;
5571: fnd_file.new_line(FND_FILE.LOG);
5572: fnd_file.put_line(FND_FILE.LOG,'succesfully changed tax scale for future element records for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');
5573: END IF;
5574: END IF;
5575: END LOOP;

Line 5572: fnd_file.put_line(FND_FILE.LOG,'succesfully changed tax scale for future element records for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');

5568: );
5569:
5570: COMMIT;
5571: fnd_file.new_line(FND_FILE.LOG);
5572: fnd_file.put_line(FND_FILE.LOG,'succesfully changed tax scale for future element records for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');
5573: END IF;
5574: END IF;
5575: END LOOP;
5576:

Line 5675: fnd_file.new_line(FND_FILE.LOG);

5671: ,p_no_managers_warning => l_no_managers_warning -- out parameter
5672: ,p_other_manager_warning => l_other_manager_warning -- out parameter
5673: );
5674: COMMIT;
5675: fnd_file.new_line(FND_FILE.LOG);
5676: fnd_file.put_line(FND_FILE.LOG,'succesfully changed leave loading flag for assignment record as of 01-JUL-2012 for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');
5677: END IF;
5678: END IF;
5679: END LOOP;

Line 5676: fnd_file.put_line(FND_FILE.LOG,'succesfully changed leave loading flag for assignment record as of 01-JUL-2012 for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');

5672: ,p_other_manager_warning => l_other_manager_warning -- out parameter
5673: );
5674: COMMIT;
5675: fnd_file.new_line(FND_FILE.LOG);
5676: fnd_file.put_line(FND_FILE.LOG,'succesfully changed leave loading flag for assignment record as of 01-JUL-2012 for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');
5677: END IF;
5678: END IF;
5679: END LOOP;
5680:

Line 5728: fnd_file.new_line(FND_FILE.LOG);

5724: ,p_other_manager_warning => l_other_manager_warning -- out parameter
5725: );
5726: COMMIT;
5727:
5728: fnd_file.new_line(FND_FILE.LOG);
5729: fnd_file.put_line(FND_FILE.LOG,'succesfully changed leave loading flag for future assignment records for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');
5730: END IF;
5731: END IF;
5732: END LOOP;

Line 5729: fnd_file.put_line(FND_FILE.LOG,'succesfully changed leave loading flag for future assignment records for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');

5725: );
5726: COMMIT;
5727:
5728: fnd_file.new_line(FND_FILE.LOG);
5729: fnd_file.put_line(FND_FILE.LOG,'succesfully changed leave loading flag for future assignment records for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');
5730: END IF;
5731: END IF;
5732: END LOOP;
5733:

Line 5814: fnd_file.new_line(FND_FILE.LOG);

5810: );
5811:
5812: COMMIT;
5813:
5814: fnd_file.new_line(FND_FILE.LOG);
5815: fnd_file.put_line(FND_FILE.LOG,'succesfully changed tax scale for element record as of 01-JUL-2012 for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');
5816:
5817: ELSIF l_full_name is null and l_emp_num is null THEN
5818: fnd_file.new_line(FND_FILE.LOG);

Line 5815: fnd_file.put_line(FND_FILE.LOG,'succesfully changed tax scale for element record as of 01-JUL-2012 for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');

5811:
5812: COMMIT;
5813:
5814: fnd_file.new_line(FND_FILE.LOG);
5815: fnd_file.put_line(FND_FILE.LOG,'succesfully changed tax scale for element record as of 01-JUL-2012 for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');
5816:
5817: ELSIF l_full_name is null and l_emp_num is null THEN
5818: fnd_file.new_line(FND_FILE.LOG);
5819: fnd_file.put_line(FND_FILE.LOG,'assignment record does not exist for assignment id '||asgrec.assignment_id|| '. probably a case of data corruption. please insert record and then upgrade');

Line 5818: fnd_file.new_line(FND_FILE.LOG);

5814: fnd_file.new_line(FND_FILE.LOG);
5815: fnd_file.put_line(FND_FILE.LOG,'succesfully changed tax scale for element record as of 01-JUL-2012 for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');
5816:
5817: ELSIF l_full_name is null and l_emp_num is null THEN
5818: fnd_file.new_line(FND_FILE.LOG);
5819: fnd_file.put_line(FND_FILE.LOG,'assignment record does not exist for assignment id '||asgrec.assignment_id|| '. probably a case of data corruption. please insert record and then upgrade');
5820: fnd_file.new_line(FND_FILE.LOG);
5821: END IF;
5822:

Line 5819: fnd_file.put_line(FND_FILE.LOG,'assignment record does not exist for assignment id '||asgrec.assignment_id|| '. probably a case of data corruption. please insert record and then upgrade');

5815: fnd_file.put_line(FND_FILE.LOG,'succesfully changed tax scale for element record as of 01-JUL-2012 for assignment id '||asgrec.assignment_id||' (Employee name / Employee number - ' || l_full_name ||' / ' || l_emp_num ||')');
5816:
5817: ELSIF l_full_name is null and l_emp_num is null THEN
5818: fnd_file.new_line(FND_FILE.LOG);
5819: fnd_file.put_line(FND_FILE.LOG,'assignment record does not exist for assignment id '||asgrec.assignment_id|| '. probably a case of data corruption. please insert record and then upgrade');
5820: fnd_file.new_line(FND_FILE.LOG);
5821: END IF;
5822:
5823: END IF;

Line 5820: fnd_file.new_line(FND_FILE.LOG);

5816:
5817: ELSIF l_full_name is null and l_emp_num is null THEN
5818: fnd_file.new_line(FND_FILE.LOG);
5819: fnd_file.put_line(FND_FILE.LOG,'assignment record does not exist for assignment id '||asgrec.assignment_id|| '. probably a case of data corruption. please insert record and then upgrade');
5820: fnd_file.new_line(FND_FILE.LOG);
5821: END IF;
5822:
5823: END IF;
5824: END LOOP;

Line 5834: FND_FILE.PUT_LINE(FND_FILE.LOG,' * ERRORS * ');

5830:
5831: error_code :=SQLCODE;
5832: error_message := SQLERRM ;
5833:
5834: FND_FILE.PUT_LINE(FND_FILE.LOG,' ***** ERRORS ***** ');
5835: FND_FILE.PUT_LINE(FND_FILE.LOG,' Report to Oracle Support.');
5836: FND_FILE.PUT_LINE(FND_FILE.LOG,error_code ||' : '||error_message);
5837:
5838: raise;

Line 5835: FND_FILE.PUT_LINE(FND_FILE.LOG,' Report to Oracle Support.');

5831: error_code :=SQLCODE;
5832: error_message := SQLERRM ;
5833:
5834: FND_FILE.PUT_LINE(FND_FILE.LOG,' ***** ERRORS ***** ');
5835: FND_FILE.PUT_LINE(FND_FILE.LOG,' Report to Oracle Support.');
5836: FND_FILE.PUT_LINE(FND_FILE.LOG,error_code ||' : '||error_message);
5837:
5838: raise;
5839:

Line 5836: FND_FILE.PUT_LINE(FND_FILE.LOG,error_code ||' : '||error_message);

5832: error_message := SQLERRM ;
5833:
5834: FND_FILE.PUT_LINE(FND_FILE.LOG,' ***** ERRORS ***** ');
5835: FND_FILE.PUT_LINE(FND_FILE.LOG,' Report to Oracle Support.');
5836: FND_FILE.PUT_LINE(FND_FILE.LOG,error_code ||' : '||error_message);
5837:
5838: raise;
5839:
5840: END upgrade_tax_scale;