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

Line 130: fnd_file calls to place non-p45s in log.

126: of last assignment before termination.
127: 09-FEB-2004 A.Mills 115.36 3433915. Also added suspended assignments to
128: future_active_exists to remedy issue.
129: 17-FEB-2004 A.Mills 115.37 Change to payment_made function. Plus use
130: fnd_file calls to place non-p45s in log.
131: 3452081.
132: 03-MAR-2004 A.Mills 115.38 3473274. For 1st period of new starter, the
133: c_act query raises exception, handle this in
134: code.

Line 1588: fnd_file.put_line (fnd_file.LOG,'Error : Enter the Test ID as the EDI Test Indicator is Yes.');

1584: -- and Raise an unhandled exception to fail the process.
1585: --
1586: IF l_report_type = 'P45PT1' and l_report_category = 'EDI' THEN
1587: IF (l_test_indicator = 'Y' AND l_test_id IS NULL) THEN
1588: fnd_file.put_line (fnd_file.LOG,'Error : Enter the Test ID as the EDI Test Indicator is Yes.');
1589: RAISE test_indicator_error;
1590: END IF;
1591: END IF;
1592: --

Line 1632: fnd_file.put_line (fnd_file.LOG, 'The Start Date and the End Date must be within the tax year.');

1628: AND to_date('05/04/'||to_char(l_chk_start_date,'YYYY'),'dd/mm/yyyy')))
1629: THEN
1630: hr_utility.set_location('Start Date and End Date are in the same tax year ',6);
1631: ELSE
1632: fnd_file.put_line (fnd_file.LOG, 'The Start Date and the End Date must be within the tax year.');
1633: hr_utility.set_location('The Start Date and the End Date must be within the tax year.',8);
1634: RAISE p45_one_taxyear_error;
1635: END IF;
1636: END;

Line 2661: fnd_file.put_line(fnd_file.log,

2657: if l_archive = FALSE then
2658: hr_utility.trace('No P45 for '||to_char(rec_asg.assignment_id)||
2659: '. Reason:');
2660: hr_utility.trace(l_non_p45_message);
2661: fnd_file.put_line(fnd_file.log,
2662: rec_asg.assignment_number||': '|| l_non_p45_message);
2663: l_non_p45_message := null;
2664: else
2665: hr_utility.set_location(l_proc,107);

Line 2720: fnd_file.put_line(fnd_file.log,

2716: else
2717: hr_utility.set_location(l_proc,130);
2718: hr_utility.trace('No P45 for '||to_char(rec_asg.assignment_id)||
2719: '. Tax Code = NI');
2720: fnd_file.put_line(fnd_file.log,
2721: rec_asg.assignment_number||': Tax Code = NI');
2722: end if; -- NI Tax Code
2723: end if; -- archive FALSE
2724: END LOOP; -- csr_all_assignments

Line 2834: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The National Insurance Number of the assignment has invalid character(s)');

2830: end if;
2831:
2832: IF l_ni_number IS NOT NULL and hr_gb_utility.ni_validate(l_ni_number,l_effective_date) <> 0 THEN
2833: populate_run_msg(p_assactid,'The National Insurance Number of the assignment has invalid character(s)');
2834: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The National Insurance Number of the assignment has invalid character(s)');
2835: edi_validation_fail := 'Y';
2836: END IF;
2837:
2838: IF l_addline1 IS NULL THEN

Line 2840: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Address Line 1 of the assignment is missing.');

2836: END IF;
2837:
2838: IF l_addline1 IS NULL THEN
2839: populate_run_msg(p_assactid,' The Address Line 1 of the assignment is missing.');
2840: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Address Line 1 of the assignment is missing.');
2841: edi_validation_fail := 'Y';
2842: ELSIF pay_gb_eoy_magtape.validate_input(l_addline1, 'P14_FULL_EDI') > 0 THEN
2843: populate_run_msg(p_assactid,'The Address Line 1 of the assignment has invalid character(s).');
2844: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Address Line 1 of the assignment has invalid character(s).');

Line 2844: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Address Line 1 of the assignment has invalid character(s).');

2840: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Address Line 1 of the assignment is missing.');
2841: edi_validation_fail := 'Y';
2842: ELSIF pay_gb_eoy_magtape.validate_input(l_addline1, 'P14_FULL_EDI') > 0 THEN
2843: populate_run_msg(p_assactid,'The Address Line 1 of the assignment has invalid character(s).');
2844: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Address Line 1 of the assignment has invalid character(s).');
2845: edi_validation_fail := 'Y';
2846: END IF;
2847:
2848: IF l_addline2 IS NULL THEN

Line 2850: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Address Line 2 of the assignment is missing.');

2846: END IF;
2847:
2848: IF l_addline2 IS NULL THEN
2849: populate_run_msg(p_assactid,'The Address Line 2 of the assignment is missing.');
2850: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Address Line 2 of the assignment is missing.');
2851: edi_validation_fail := 'Y';
2852: ELSIF pay_gb_eoy_magtape.validate_input(l_addline2, 'P14_FULL_EDI') > 0 THEN
2853: populate_run_msg(p_assactid,'The Address Line 2 of the assignment has invalid character(s).');
2854: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Address Line 2 of the assignment has invalid character(s).');

Line 2854: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Address Line 2 of the assignment has invalid character(s).');

2850: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Address Line 2 of the assignment is missing.');
2851: edi_validation_fail := 'Y';
2852: ELSIF pay_gb_eoy_magtape.validate_input(l_addline2, 'P14_FULL_EDI') > 0 THEN
2853: populate_run_msg(p_assactid,'The Address Line 2 of the assignment has invalid character(s).');
2854: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Address Line 2 of the assignment has invalid character(s).');
2855: edi_validation_fail := 'Y';
2856: END IF;
2857:
2858: IF l_addline3 IS NOT NULL AND pay_gb_eoy_magtape.validate_input(l_addline3, 'P14_FULL_EDI') > 0 THEN

Line 2860: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Address Line 3 of the assignment has invalid character(s).');

2856: END IF;
2857:
2858: IF l_addline3 IS NOT NULL AND pay_gb_eoy_magtape.validate_input(l_addline3, 'P14_FULL_EDI') > 0 THEN
2859: populate_run_msg(p_assactid,'The Address Line 3 of the assignment has invalid character(s).');
2860: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Address Line 3 of the assignment has invalid character(s).');
2861: edi_validation_fail := 'Y';
2862: END IF;
2863:
2864: IF town_or_city IS NOT NULL AND pay_gb_eoy_magtape.validate_input(town_or_city, 'P14_FULL_EDI') > 0 THEN

Line 2866: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Town or City of the assignment has invalid character(s).');

2862: END IF;
2863:
2864: IF town_or_city IS NOT NULL AND pay_gb_eoy_magtape.validate_input(town_or_city, 'P14_FULL_EDI') > 0 THEN
2865: populate_run_msg(p_assactid,'The Town or City of the assignment has invalid character(s).');
2866: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Town or City of the assignment has invalid character(s).');
2867: edi_validation_fail := 'Y';
2868: END IF;
2869:
2870: IF assignment_number IS NOT NULL AND pay_gb_eoy_magtape.validate_input(assignment_number, 'P14_FULL_EDI') > 0 THEN

Line 2872: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : Assignment number has invalid character(s).');

2868: END IF;
2869:
2870: IF assignment_number IS NOT NULL AND pay_gb_eoy_magtape.validate_input(assignment_number, 'P14_FULL_EDI') > 0 THEN
2871: populate_run_msg(p_assactid,'Assignment number has invalid character(s).');
2872: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : Assignment number has invalid character(s).');
2873: edi_validation_fail := 'Y';
2874: END IF;
2875:
2876: IF l_county IS NOT NULL AND pay_gb_eoy_magtape.validate_input(l_county, 'P14_FULL_EDI') > 0 THEN

Line 2878: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The County of the assignment has invalid character(s).');

2874: END IF;
2875:
2876: IF l_county IS NOT NULL AND pay_gb_eoy_magtape.validate_input(l_county, 'P14_FULL_EDI') > 0 THEN
2877: populate_run_msg(p_assactid,'The County of the assignment has invalid character(s).');
2878: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The County of the assignment has invalid character(s).');
2879: edi_validation_fail := 'Y';
2880: END IF;
2881:
2882: IF l_last_name IS NULL THEN

Line 2884: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Last Name of the assignment is missing');

2880: END IF;
2881:
2882: IF l_last_name IS NULL THEN
2883: populate_run_msg(p_assactid,'The Last Name of the assignment is missing.');
2884: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Last Name of the assignment is missing');
2885: edi_validation_fail := 'Y';
2886: ELSIF pay_gb_eoy_magtape.validate_input(l_last_name, 'P45_46_LAST_NAME') > 0 THEN
2887: populate_run_msg(p_assactid,'The Last Name of the assignment has invalid character(s).');
2888: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Last Name of the assignment has invalid character(s).');

Line 2888: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Last Name of the assignment has invalid character(s).');

2884: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Last Name of the assignment is missing');
2885: edi_validation_fail := 'Y';
2886: ELSIF pay_gb_eoy_magtape.validate_input(l_last_name, 'P45_46_LAST_NAME') > 0 THEN
2887: populate_run_msg(p_assactid,'The Last Name of the assignment has invalid character(s).');
2888: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Last Name of the assignment has invalid character(s).');
2889: edi_validation_fail := 'Y';
2890: END IF;
2891:
2892: IF l_first_name IS NULL THEN

Line 2894: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The First Name of the assignment is missing');

2890: END IF;
2891:
2892: IF l_first_name IS NULL THEN
2893: populate_run_msg(p_assactid,' The First Name of the assignment is missing');
2894: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The First Name of the assignment is missing');
2895: edi_validation_fail := 'Y';
2896: ELSIF pay_gb_eoy_magtape.validate_input(l_first_name, 'P45_46_FIRST_NAME') > 0 THEN
2897: populate_run_msg(p_assactid,'The First Name of the assignment has invalid character(s).');
2898: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The First Name of the assignment has invalid character(s).');

Line 2898: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The First Name of the assignment has invalid character(s).');

2894: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The First Name of the assignment is missing');
2895: edi_validation_fail := 'Y';
2896: ELSIF pay_gb_eoy_magtape.validate_input(l_first_name, 'P45_46_FIRST_NAME') > 0 THEN
2897: populate_run_msg(p_assactid,'The First Name of the assignment has invalid character(s).');
2898: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The First Name of the assignment has invalid character(s).');
2899: edi_validation_fail := 'Y';
2900: END IF;
2901:
2902: IF l_middle_name IS NOT NULL and pay_gb_eoy_magtape.validate_input(l_middle_name, 'P45_46_FIRST_NAME') > 0 THEN

Line 2904: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Middle Name of the assignment has invalid character(s).');

2900: END IF;
2901:
2902: IF l_middle_name IS NOT NULL and pay_gb_eoy_magtape.validate_input(l_middle_name, 'P45_46_FIRST_NAME') > 0 THEN
2903: populate_run_msg(p_assactid,'The Middle Name of the assignment has invalid character(s).');
2904: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Middle Name of the assignment has invalid character(s).');
2905: edi_validation_fail := 'Y';
2906: END IF;
2907:
2908: IF l_title IS NOT NULL and pay_gb_eoy_magtape.validate_input(l_title, 'P45_46_TITLE') > 0 THEN

Line 2910: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Title of the assignment has invalid character(s).');

2906: END IF;
2907:
2908: IF l_title IS NOT NULL and pay_gb_eoy_magtape.validate_input(l_title, 'P45_46_TITLE') > 0 THEN
2909: populate_run_msg(p_assactid,'The Title of the assignment has invalid character(s).');
2910: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Title of the assignment has invalid character(s).');
2911: edi_validation_fail := 'Y';
2912: END IF;
2913:
2914: IF l_postal_code IS NOT NULL and pay_gb_eoy_magtape.validate_input(l_postal_code, 'P45_46_POSTCODE') > 0 THEN

Line 2916: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Postal Code of the assignment has invalid character(s).');

2912: END IF;
2913:
2914: IF l_postal_code IS NOT NULL and pay_gb_eoy_magtape.validate_input(l_postal_code, 'P45_46_POSTCODE') > 0 THEN
2915: populate_run_msg(p_assactid,'The Postal Code of the assignment has invalid character(s).');
2916: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Postal Code of the assignment has invalid character(s).');
2917: edi_validation_fail := 'Y';
2918: END IF;
2919:
2920:

Line 3453: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : Date Of Birth for this assignment is missing');

3449: END IF;*/
3450:
3451: IF g_edi_ver = 'V6' and l_date_of_birth IS NULL THEN -- V6 Validation
3452: populate_run_msg(p_assactid,'Date Of Birth for this assignment is missing.');
3453: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : Date Of Birth for this assignment is missing');
3454: l_edi_validation_fail := 'Y';
3455: ELSIF l_date_of_birth IS NOT NULL and PAY_GB_MOVDED_EDI.date_validate(p_assactid,'DOB',l_date_of_birth) = 0 THEN
3456: populate_run_msg(p_assactid,'The Date of Birth for this assignment must be the current date or an earlier date.');
3457: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Date of Birth for this assignment must be the current date or an earlier date.');

Line 3457: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Date of Birth for this assignment must be the current date or an earlier date.');

3453: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : Date Of Birth for this assignment is missing');
3454: l_edi_validation_fail := 'Y';
3455: ELSIF l_date_of_birth IS NOT NULL and PAY_GB_MOVDED_EDI.date_validate(p_assactid,'DOB',l_date_of_birth) = 0 THEN
3456: populate_run_msg(p_assactid,'The Date of Birth for this assignment must be the current date or an earlier date.');
3457: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Date of Birth for this assignment must be the current date or an earlier date.');
3458: l_edi_validation_fail := 'Y';
3459: END IF;
3460:
3461: IF g_edi_ver = 'V6' and l_sex IS NULL THEN -- V6 Validation

Line 3463: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Gender for this assignment is missing');

3459: END IF;
3460:
3461: IF g_edi_ver = 'V6' and l_sex IS NULL THEN -- V6 Validation
3462: populate_run_msg(p_assactid,'The Gender for this assignment is missing.');
3463: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Gender for this assignment is missing');
3464: l_edi_validation_fail := 'Y';
3465: END IF;
3466:
3467: IF l_sex not in ('M','F') THEN

Line 3469: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Gender of this assignment has invalid character(s)');

3465: END IF;
3466:
3467: IF l_sex not in ('M','F') THEN
3468: populate_run_msg(p_assactid,'The Gender of this assignment has invalid character(s)');
3469: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Gender of this assignment has invalid character(s)');
3470: l_edi_validation_fail := 'Y';
3471: END IF;
3472:
3473: IF l_termination_date IS NULL THEN

Line 3475: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Date of Leaving of the assignment is missing');

3471: END IF;
3472:
3473: IF l_termination_date IS NULL THEN
3474: populate_run_msg(p_assactid,'The Date of Leaving of the assignment is missing.');
3475: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Date of Leaving of the assignment is missing');
3476: l_edi_validation_fail := 'Y';
3477: ELSIF PAY_GB_MOVDED_EDI.date_validate(p_assactid,'LEFT_DATE_V6',l_termination_date) = 0 THEN
3478: populate_run_msg(p_assactid,'The Date of Leaving is invalid.');
3479: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Date of Leaving is invalid.');

Line 3479: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Date of Leaving is invalid.');

3475: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Date of Leaving of the assignment is missing');
3476: l_edi_validation_fail := 'Y';
3477: ELSIF PAY_GB_MOVDED_EDI.date_validate(p_assactid,'LEFT_DATE_V6',l_termination_date) = 0 THEN
3478: populate_run_msg(p_assactid,'The Date of Leaving is invalid.');
3479: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Date of Leaving is invalid.');
3480: l_edi_validation_fail := 'Y';
3481: END IF;
3482:
3483:

Line 3795: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Tax Code at Leaving of the assignment must be defined if the Week1/Month1 indicator is defined.');

3791: END IF;
3792:
3793: IF l_tax_basis = 'N' AND l_tax_code IS NULL THEN
3794: populate_run_msg(p_assactid,'The Tax Code at Leaving of the assignment must be defined if the Week1/Month1 indicator is defined.');
3795: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Tax Code at Leaving of the assignment must be defined if the Week1/Month1 indicator is defined.');
3796: l_edi_validation_fail := 'Y';
3797: END IF;
3798:
3799: IF l_tax_basis = 'N' AND l_week_or_month IS NOT NULL AND l_tax_code IS NOT NULL THEN

Line 3801: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Week/Month type of the assignment must not be defined if both the Tax Code at Leaving Date and the Week1/Month1 indicator are defined.');

3797: END IF;
3798:
3799: IF l_tax_basis = 'N' AND l_week_or_month IS NOT NULL AND l_tax_code IS NOT NULL THEN
3800: populate_run_msg(p_assactid,'The Week/Month type of the assignment must not be defined if both the Tax Code at Leaving Date and the Week1/Month1 indicator are defined.');
3801: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Week/Month type of the assignment must not be defined if both the Tax Code at Leaving Date and the Week1/Month1 indicator are defined.');
3802: l_edi_validation_fail := 'Y';
3803: END IF;
3804:
3805: IF l_tax_basis <> 'N' AND l_week_or_month IS NULL AND l_tax_code IS NOT NULL THEN

Line 3807: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Week/Month type of the assignment must be defined if both the Tax Code at Leaving Date and the Week1/Month1 indicator are defined.');

3803: END IF;
3804:
3805: IF l_tax_basis <> 'N' AND l_week_or_month IS NULL AND l_tax_code IS NOT NULL THEN
3806: populate_run_msg(p_assactid,'The Week/Month type of the assignment must be defined if both the Tax Code at Leaving Date and the Week1/Month1 indicator are defined.');
3807: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Week/Month type of the assignment must be defined if both the Tax Code at Leaving Date and the Week1/Month1 indicator are defined.');
3808: l_edi_validation_fail := 'Y';
3809: END IF;
3810:
3811: IF l_tax_basis <> 'N' AND l_period_no IS NOT NULL AND l_week_or_month IS NULL THEN

Line 3813: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Week/Month type of the assignment must be defined if the Week/Month Number is defined.');

3809: END IF;
3810:
3811: IF l_tax_basis <> 'N' AND l_period_no IS NOT NULL AND l_week_or_month IS NULL THEN
3812: populate_run_msg(p_assactid,'The Week/Month type of the assignment must be defined if the Week/Month Number is defined.');
3813: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Week/Month type of the assignment must be defined if the Week/Month Number is defined.');
3814: l_edi_validation_fail := 'Y';
3815: END IF;
3816:
3817: IF nvl(l_taxable,0) <> 0 AND nvl(l_paye,0) <> 0 THEN

Line 3853: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Pay in this Employment of the assignment must be defined if the Week1/Month1 indicator is defined.');

3849:
3850:
3851: /*IF l_tax_basis ='N' AND l_pay_in_this_emp IS NULL THEN
3852: populate_run_msg(p_assactid,'The Total Pay in this Employment of the assignment must be defined if the Week1/Month1 indicator is defined.');
3853: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Pay in this Employment of the assignment must be defined if the Week1/Month1 indicator is defined.');
3854: l_edi_validation_fail := 'Y';
3855: END IF;
3856:
3857: IF l_tax_basis ='N' AND l_tax_in_this_emp IS NULL THEN

Line 3859: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Tax Deducted in this Employment of the assignment must be defined if the Week1/Month1 indicator is defined.');

3855: END IF;
3856:
3857: IF l_tax_basis ='N' AND l_tax_in_this_emp IS NULL THEN
3858: populate_run_msg(p_assactid,'The Tax Deducted in this Employment of the assignment must be defined if the Week1/Month1 indicator is defined.');
3859: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Tax Deducted in this Employment of the assignment must be defined if the Week1/Month1 indicator is defined.');
3860: l_edi_validation_fail := 'Y';
3861: END IF;*/
3862: --
3863: IF l_pay_in_this_emp IS NOT NULL THEN

Line 3866: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' :The Total Pay in this Employment of the assignment must be defined if the Tax Deducted in this employment is defined.');

3862: --
3863: IF l_pay_in_this_emp IS NOT NULL THEN
3864: /*IF l_tax_in_this_emp IS NULL THEN
3865: populate_run_msg(p_assactid,'The Total Pay in this Employment of the assignment must be defined if the Tax Deducted in this employment is defined.');
3866: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' :The Total Pay in this Employment of the assignment must be defined if the Tax Deducted in this employment is defined.');
3867: l_edi_validation_fail := 'Y';
3868: END IF;*/ -- Tax can be Zero even if pay is not Zero
3869:
3870: IF pay_gb_eoy_magtape.validate_input(l_pay_in_this_emp,'NUMBER_1') > 0 THEN

Line 3872: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Pay in this Employment of the assignment has invalid character(s).');

3868: END IF;*/ -- Tax can be Zero even if pay is not Zero
3869:
3870: IF pay_gb_eoy_magtape.validate_input(l_pay_in_this_emp,'NUMBER_1') > 0 THEN
3871: populate_run_msg(p_assactid,'The Total Pay in this Employment of the assignment has invalid character(s).');
3872: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Pay in this Employment of the assignment has invalid character(s).');
3873: l_edi_validation_fail := 'Y';
3874: END IF;
3875:
3876: IF to_number(l_pay_in_this_emp) < 0 THEN

Line 3878: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Pay in this Employment of the assignment is Less Than 0');

3874: END IF;
3875:
3876: IF to_number(l_pay_in_this_emp) < 0 THEN
3877: populate_run_msg(p_assactid,'The Total Pay in this Employment of the assignment is Less Than 0');
3878: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Pay in this Employment of the assignment is Less Than 0');
3879: l_edi_validation_fail := 'Y';
3880: END IF;
3881:
3882: IF l_tax_in_this_emp IS NOT NULL THEN

Line 3885: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Tax Deducted in this employment of the assignment must be Less Than or equal to the Total Pay in this employment.');

3881:
3882: IF l_tax_in_this_emp IS NOT NULL THEN
3883: IF to_number(l_pay_in_this_emp) < to_number(l_tax_in_this_emp) THEN
3884: populate_run_msg(p_assactid,'The Tax Deducted in this employment of the assignment must be Less Than or equal to the Total Pay in this employment.');
3885: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Tax Deducted in this employment of the assignment must be Less Than or equal to the Total Pay in this employment.');
3886: l_edi_validation_fail := 'Y';
3887: END IF;
3888: END IF;
3889: END IF;

Line 3894: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Tax Deducted in this Employment of the assignment must be defined if the Total Pay in this employment is defined.');

3890: --
3891: IF l_tax_in_this_emp IS NOT NULL THEN
3892: IF l_pay_in_this_emp IS NULL THEN
3893: populate_run_msg(p_assactid,'The Tax Deducted in this Employment of the assignment must be defined if the Total Pay in this employment is defined.');
3894: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Tax Deducted in this Employment of the assignment must be defined if the Total Pay in this employment is defined.');
3895: l_edi_validation_fail := 'Y';
3896: END IF;
3897:
3898: IF pay_gb_eoy_magtape.validate_input(l_tax_in_this_emp,'NUMBER_1') > 0 THEN

Line 3900: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Tax Deducted in this Employment of the assignment has invalid character(s).');

3896: END IF;
3897:
3898: IF pay_gb_eoy_magtape.validate_input(l_tax_in_this_emp,'NUMBER_1') > 0 THEN
3899: populate_run_msg(p_assactid,'The Tax Deducted in this Employment of the assignment has invalid character(s).');
3900: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Tax Deducted in this Employment of the assignment has invalid character(s).');
3901: l_edi_validation_fail := 'Y';
3902: ELSIF less_than_zero_flag = 'Y' THEN
3903: populate_run_msg(p_assactid,'The Tax Deducted in this Employment of the assignment is Less Than 0; printing the amount as Zero.');
3904: fnd_file.put_line (fnd_file.LOG,'The Tax Deducted in this Employment of the assignment is Less Than 0; printing the amount as Zero.');

Line 3904: fnd_file.put_line (fnd_file.LOG,'The Tax Deducted in this Employment of the assignment is Less Than 0; printing the amount as Zero.');

3900: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Tax Deducted in this Employment of the assignment has invalid character(s).');
3901: l_edi_validation_fail := 'Y';
3902: ELSIF less_than_zero_flag = 'Y' THEN
3903: populate_run_msg(p_assactid,'The Tax Deducted in this Employment of the assignment is Less Than 0; printing the amount as Zero.');
3904: fnd_file.put_line (fnd_file.LOG,'The Tax Deducted in this Employment of the assignment is Less Than 0; printing the amount as Zero.');
3905: -- Not raising an error as this is a warning
3906: END IF;
3907: END IF;
3908:

Line 3912: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Pay to Date of the assignment must not be defined if the Week1/Month1 indicator is defined.');

3908:
3909: IF l_total_pay_to_date IS NOT NULL THEN
3910: /*IF l_tax_basis = 'N' THEN
3911: populate_run_msg(p_assactid,'The Total Pay to Date of the assignment must not be defined if the Week1/Month1 indicator is defined.');
3912: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Pay to Date of the assignment must not be defined if the Week1/Month1 indicator is defined.');
3913: l_edi_validation_fail := 'Y';
3914: END IF;*/-- Commenting the code as Total Pay to Date can be Zero and it is legitame to have no pay
3915: -- This case will be handled at the EDi level
3916:

Line 3919: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Pay to Date of the assignment has invalid character(s).');

3915: -- This case will be handled at the EDi level
3916:
3917: IF pay_gb_eoy_magtape.validate_input(l_total_pay_to_date,'NUMBER_1') > 0 THEN
3918: populate_run_msg(p_assactid,'The Total Pay to Date of the assignment has invalid character(s).');
3919: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Pay to Date of the assignment has invalid character(s).');
3920: l_edi_validation_fail := 'Y';
3921: END IF;
3922:
3923: --Bug 10077936:Removed the Else if and made it If statement

Line 3927: fnd_file.put_line (fnd_file.LOG,'The Total Pay to Date of the assignment is Less Than 0.');

3923: --Bug 10077936:Removed the Else if and made it If statement
3924:
3925: IF to_number(l_total_pay_to_date) < 0 THEN
3926: populate_run_msg(p_assactid,'The Total Pay to Date of the assignment is Less Than 0.');
3927: fnd_file.put_line (fnd_file.LOG,'The Total Pay to Date of the assignment is Less Than 0.');
3928: l_edi_validation_fail := 'Y';
3929: END IF;
3930:
3931: IF l_total_tax_to_date IS NOT NULL THEN

Line 3934: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Tax to Date of the assignment must be Less Than or equal to the Total Pay to Date.');

3930:
3931: IF l_total_tax_to_date IS NOT NULL THEN
3932: IF (to_number(l_total_pay_to_date) < to_number(l_total_tax_to_date)) THEN
3933: populate_run_msg(p_assactid,'The Total Tax to Date of the assignment must be Less Than or equal to the Total Pay to Date.');
3934: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Tax to Date of the assignment must be Less Than or equal to the Total Pay to Date.');
3935: l_edi_validation_fail := 'Y';
3936: END IF;
3937: END IF;
3938: END IF;

Line 3943: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Pay to Date of the assignment must be defined if the Total Tax to Date is defined.');

3939:
3940: IF l_total_pay_to_date IS NULL THEN
3941: IF l_total_tax_to_date IS NOT NULL THEN
3942: populate_run_msg(p_assactid,'The Total Pay to Date of the assignment must be defined if the Total Tax to Date is defined.');
3943: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Pay to Date of the assignment must be defined if the Total Tax to Date is defined.');
3944: l_edi_validation_fail := 'Y';
3945: END IF;
3946:
3947: /* IF l_tax_basis <> 'N' THEN

Line 3949: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Pay to Date of the assignment must be defined if the Week1/Month1 indicator is not defined.');

3945: END IF;
3946:
3947: /* IF l_tax_basis <> 'N' THEN
3948: populate_run_msg(p_assactid,'The Total Pay to Date of the assignment must be defined if the Week1/Month1 indicator is not defined.');
3949: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Pay to Date of the assignment must be defined if the Week1/Month1 indicator is not defined.');
3950: l_edi_validation_fail := 'Y';
3951: END IF;*/-- Commenting the code as Total Pay to Date can be Zero and it is legitame to have no pay
3952: -- This case will be handled at the EDi level
3953: END IF;

Line 3958: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Tax to Date of the assignment must not be defined if the Week1/Month1 indicator is defined.');

3954:
3955: IF l_total_tax_to_date IS NOT NULL THEN
3956: /*IF l_tax_basis = 'N' THEN
3957: populate_run_msg(p_assactid,'The Total Tax to Date of the assignment must not be defined if the Week1/Month1 indicator is defined.');
3958: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Tax to Date of the assignment must not be defined if the Week1/Month1 indicator is defined.');
3959: l_edi_validation_fail := 'Y';
3960: ELSIF */
3961: IF pay_gb_eoy_magtape.validate_input(l_total_tax_to_date,'NUMBER_1') > 0 THEN
3962: populate_run_msg(p_assactid,'The Total Tax to Date of the assignment has invalid character(s).');

Line 3963: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Tax to Date of the assignment has invalid character(s).');

3959: l_edi_validation_fail := 'Y';
3960: ELSIF */
3961: IF pay_gb_eoy_magtape.validate_input(l_total_tax_to_date,'NUMBER_1') > 0 THEN
3962: populate_run_msg(p_assactid,'The Total Tax to Date of the assignment has invalid character(s).');
3963: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Tax to Date of the assignment has invalid character(s).');
3964: l_edi_validation_fail := 'Y';
3965: END IF;
3966:
3967: IF to_number(l_total_tax_to_date) < 0 THEN

Line 3969: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Tax to Date of the assignment is Less Than 0.');

3965: END IF;
3966:
3967: IF to_number(l_total_tax_to_date) < 0 THEN
3968: populate_run_msg(p_assactid,'The Total Tax to Date of the assignment is Less Than 0.');
3969: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Tax to Date of the assignment is Less Than 0.');
3970: l_edi_validation_fail := 'Y';
3971: END IF;
3972: END IF;
3973:

Line 3977: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' :The Total Tax to Date of the assignment must be defined if the Total Pay to Date is defined.');

3973:
3974: /*IF l_total_tax_to_date IS NULL THEN
3975: IF l_total_pay_to_date IS NOT NULL THEN
3976: populate_run_msg(p_assactid,'The Total Tax to Date of the assignment must be defined if the Total Pay to Date is defined.');
3977: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' :The Total Tax to Date of the assignment must be defined if the Total Pay to Date is defined.');
3978: l_edi_validation_fail := 'Y'; -- Total Tax can be Zero even though the employee has total pay
3979: ELSIF l_tax_basis <> 'N' THEN
3980: populate_run_msg(p_assactid,'The Total Tax to Date of the assignment must be defined if the Week1/Month1 indicator is not defined.');
3981: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Tax to Date of the assignment must be defined if the Week1/Month1 indicator is not defined.');

Line 3981: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Tax to Date of the assignment must be defined if the Week1/Month1 indicator is not defined.');

3977: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' :The Total Tax to Date of the assignment must be defined if the Total Pay to Date is defined.');
3978: l_edi_validation_fail := 'Y'; -- Total Tax can be Zero even though the employee has total pay
3979: ELSIF l_tax_basis <> 'N' THEN
3980: populate_run_msg(p_assactid,'The Total Tax to Date of the assignment must be defined if the Week1/Month1 indicator is not defined.');
3981: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Total Tax to Date of the assignment must be defined if the Week1/Month1 indicator is not defined.');
3982: l_edi_validation_fail := 'Y';
3983: END IF;
3984: END IF; */ -- Total Tax zan be Zero if tax basis is not N
3985:

Line 3988: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Tax Code at Leaving Date is missing.');

3984: END IF; */ -- Total Tax zan be Zero if tax basis is not N
3985:
3986: IF l_tax_code IS NULL THEN
3987: populate_run_msg(p_assactid,'The Tax Code at Leaving Date is missing.');
3988: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Tax Code at Leaving Date is missing.');
3989: l_edi_validation_fail := 'Y';
3990: ELSIF pay_gb_eoy_magtape.validate_tax_code_yrfil(p_assactid,l_tax_code,p_effective_date) <> ' ' THEN
3991: populate_run_msg(p_assactid,'The Tax Code at Leaving Date is invalid.');
3992: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Tax Code at Leaving Date is invalid.');

Line 3992: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Tax Code at Leaving Date is invalid.');

3988: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Tax Code at Leaving Date is missing.');
3989: l_edi_validation_fail := 'Y';
3990: ELSIF pay_gb_eoy_magtape.validate_tax_code_yrfil(p_assactid,l_tax_code,p_effective_date) <> ' ' THEN
3991: populate_run_msg(p_assactid,'The Tax Code at Leaving Date is invalid.');
3992: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Tax Code at Leaving Date is invalid.');
3993: l_edi_validation_fail := 'Y';
3994: END IF;
3995:
3996: IF l_week_or_month IS NOT NULL THEN

Line 4000: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Week/Month Number of the assignment must be between 1 to 54 or 56 as the Week/Month Type is Weekly.');

3996: IF l_week_or_month IS NOT NULL THEN
3997: IF l_week_or_month = 'W' THEN
3998: IF l_period_no < 1 OR l_period_no = 55 OR l_period_no > 56 THEN
3999: populate_run_msg(p_assactid,'The Week/Month Number of the assignment must be between 1 to 54 or 56 as the Week/Month Type is Weekly.');
4000: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Week/Month Number of the assignment must be between 1 to 54 or 56 as the Week/Month Type is Weekly.');
4001: l_edi_validation_fail := 'Y';
4002: END IF;
4003: ELSIF l_week_or_month = 'M' THEN
4004: IF l_period_no < 1 OR l_period_no > 12 THEN

Line 4006: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Week/Month Number of the assignment must be between 1 to 12 as the Week/Month Type is Monthly.');

4002: END IF;
4003: ELSIF l_week_or_month = 'M' THEN
4004: IF l_period_no < 1 OR l_period_no > 12 THEN
4005: populate_run_msg(p_assactid,'The Week/Month Number of the assignment must be between 1 to 12 as the Week/Month Type is Monthly.');
4006: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Week/Month Number of the assignment must be between 1 to 12 as the Week/Month Type is Monthly.');
4007: l_edi_validation_fail := 'Y';
4008: END IF;
4009: END IF;
4010: END IF;