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 PAY_GB_EOY_MAGTAPE

Line 2842: ELSIF pay_gb_eoy_magtape.validate_input(l_addline1, 'P14_FULL_EDI') > 0 THEN

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).');
2845: edi_validation_fail := 'Y';
2846: END IF;

Line 2852: ELSIF pay_gb_eoy_magtape.validate_input(l_addline2, 'P14_FULL_EDI') > 0 THEN

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).');
2855: edi_validation_fail := 'Y';
2856: END IF;

Line 2858: IF l_addline3 IS NOT NULL AND pay_gb_eoy_magtape.validate_input(l_addline3, 'P14_FULL_EDI') > 0 THEN

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
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;

Line 2864: IF town_or_city IS NOT NULL AND pay_gb_eoy_magtape.validate_input(town_or_city, 'P14_FULL_EDI') > 0 THEN

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
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;

Line 2870: IF assignment_number IS NOT NULL AND pay_gb_eoy_magtape.validate_input(assignment_number, 'P14_FULL_EDI') > 0 THEN

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
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;

Line 2876: IF l_county IS NOT NULL AND pay_gb_eoy_magtape.validate_input(l_county, 'P14_FULL_EDI') > 0 THEN

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
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;

Line 2886: ELSIF pay_gb_eoy_magtape.validate_input(l_last_name, 'P45_46_LAST_NAME') > 0 THEN

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).');
2889: edi_validation_fail := 'Y';
2890: END IF;

Line 2896: ELSIF pay_gb_eoy_magtape.validate_input(l_first_name, 'P45_46_FIRST_NAME') > 0 THEN

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).');
2899: edi_validation_fail := 'Y';
2900: END IF;

Line 2902: IF l_middle_name IS NOT NULL and pay_gb_eoy_magtape.validate_input(l_middle_name, 'P45_46_FIRST_NAME') > 0 THEN

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
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;

Line 2908: IF l_title IS NOT NULL and pay_gb_eoy_magtape.validate_input(l_title, 'P45_46_TITLE') > 0 THEN

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
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;

Line 2914: IF l_postal_code IS NOT NULL and pay_gb_eoy_magtape.validate_input(l_postal_code, 'P45_46_POSTCODE') > 0 THEN

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
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;

Line 3423: /* IF pay_gb_eoy_magtape.validate_input(upper(l_assignment_number),

3419: hr_utility.trace('--------------------------------------');
3420: IF g_do_edi_validation or g_edi_ver = 'V6' THEN
3421: --Already handled in EDI_MOVDED6_ASG procedure. we dont want to error the process
3422: --immediately once we hit an error bug 8254291
3423: /* IF pay_gb_eoy_magtape.validate_input(upper(l_assignment_number),
3424: 'FULL_EDI') > 0 THEN
3425: hr_utility.set_message(801, 'PAY_78037_EDI_ILLEGAL_CHARS');
3426: hr_utility.set_message_token('ITEM_NAME', 'Assignment Number');
3427: hr_utility.raise_error;

Line 3430: IF pay_gb_eoy_magtape.validate_input(l_last_name,

3426: hr_utility.set_message_token('ITEM_NAME', 'Assignment Number');
3427: hr_utility.raise_error;
3428: END IF;
3429:
3430: IF pay_gb_eoy_magtape.validate_input(l_last_name,
3431: 'EDI_SURNAME') > 0 THEN
3432: hr_utility.set_message(801, 'PAY_78037_EDI_ILLEGAL_CHARS');
3433: hr_utility.set_message_token('ITEM_NAME', 'Surname');
3434: hr_utility.raise_error;

Line 3437: IF pay_gb_eoy_magtape.validate_input(l_first_name,

3433: hr_utility.set_message_token('ITEM_NAME', 'Surname');
3434: hr_utility.raise_error;
3435: END IF;
3436:
3437: IF pay_gb_eoy_magtape.validate_input(l_first_name,
3438: 'EDI_SURNAME') > 0 THEN
3439: hr_utility.set_message(801, 'PAY_78037_EDI_ILLEGAL_CHARS');
3440: hr_utility.set_message_token('ITEM_NAME', 'Forename');
3441: hr_utility.raise_error;

Line 3444: IF pay_gb_eoy_magtape.validate_input(l_ni_number,

3440: hr_utility.set_message_token('ITEM_NAME', 'Forename');
3441: hr_utility.raise_error;
3442: END IF;
3443:
3444: IF pay_gb_eoy_magtape.validate_input(l_ni_number,
3445: 'FULL_EDI') > 0 THEN
3446: hr_utility.set_message(801, 'PAY_78037_EDI_ILLEGAL_CHARS');
3447: hr_utility.set_message_token('ITEM_NAME', 'NI Number');
3448: hr_utility.raise_error;

Line 3550: IF pay_gb_eoy_magtape.validate_input(upper(l_address_line1),

3546: IF l_edi_movded6_asg_flag = 'Y' THEN
3547: l_edi_validation_fail := 'Y';
3548: END IF;
3549: /* All the validations are already done in EDI_MOVDED6_ASG so commenting out
3550: IF pay_gb_eoy_magtape.validate_input(upper(l_address_line1),
3551: 'EDI_SURNAME') > 0 THEN
3552: hr_utility.set_message(801, 'PAY_78037_EDI_ILLEGAL_CHARS');
3553: hr_utility.set_message_token('ITEM_NAME', 'Address Line 1');
3554: hr_utility.raise_error;

Line 3556: IF pay_gb_eoy_magtape.validate_input(upper(l_address_line2),

3552: hr_utility.set_message(801, 'PAY_78037_EDI_ILLEGAL_CHARS');
3553: hr_utility.set_message_token('ITEM_NAME', 'Address Line 1');
3554: hr_utility.raise_error;
3555: END IF;
3556: IF pay_gb_eoy_magtape.validate_input(upper(l_address_line2),
3557: 'EDI_SURNAME') > 0 THEN
3558: hr_utility.set_message(801, 'PAY_78037_EDI_ILLEGAL_CHARS');
3559: hr_utility.set_message_token('ITEM_NAME', 'Address Line 2');
3560: hr_utility.raise_error;

Line 3562: IF pay_gb_eoy_magtape.validate_input(upper(l_address_line3),

3558: hr_utility.set_message(801, 'PAY_78037_EDI_ILLEGAL_CHARS');
3559: hr_utility.set_message_token('ITEM_NAME', 'Address Line 2');
3560: hr_utility.raise_error;
3561: END IF;
3562: IF pay_gb_eoy_magtape.validate_input(upper(l_address_line3),
3563: 'EDI_SURNAME') > 0 THEN
3564: hr_utility.set_message(801, 'PAY_78037_EDI_ILLEGAL_CHARS');
3565: hr_utility.set_message_token('ITEM_NAME', 'Address Line 3');
3566: hr_utility.raise_error;

Line 3568: IF pay_gb_eoy_magtape.validate_input(upper(l_town_or_city),

3564: hr_utility.set_message(801, 'PAY_78037_EDI_ILLEGAL_CHARS');
3565: hr_utility.set_message_token('ITEM_NAME', 'Address Line 3');
3566: hr_utility.raise_error;
3567: END IF;
3568: IF pay_gb_eoy_magtape.validate_input(upper(l_town_or_city),
3569: 'FULL_EDI') > 0 THEN
3570: hr_utility.set_message(801, 'PAY_78037_EDI_ILLEGAL_CHARS');
3571: hr_utility.set_message_token('ITEM_NAME', 'Town or City');
3572: hr_utility.raise_error;

Line 3574: IF pay_gb_eoy_magtape.validate_input(upper(l_county),

3570: hr_utility.set_message(801, 'PAY_78037_EDI_ILLEGAL_CHARS');
3571: hr_utility.set_message_token('ITEM_NAME', 'Town or City');
3572: hr_utility.raise_error;
3573: END IF;
3574: IF pay_gb_eoy_magtape.validate_input(upper(l_county),
3575: 'FULL_EDI') > 0 THEN
3576: hr_utility.set_message(801, 'PAY_78037_EDI_ILLEGAL_CHARS');
3577: hr_utility.set_message_token('ITEM_NAME', 'County');
3578: hr_utility.raise_error;

Line 3580: IF pay_gb_eoy_magtape.validate_input(l_postal_code,

3576: hr_utility.set_message(801, 'PAY_78037_EDI_ILLEGAL_CHARS');
3577: hr_utility.set_message_token('ITEM_NAME', 'County');
3578: hr_utility.raise_error;
3579: END IF;
3580: IF pay_gb_eoy_magtape.validate_input(l_postal_code,
3581: 'FULL_EDI') > 0 THEN
3582: hr_utility.set_message(801, 'PAY_78037_EDI_ILLEGAL_CHARS');
3583: hr_utility.set_message_token('ITEM_NAME', 'Postcode');
3584: hr_utility.raise_error;

Line 3870: IF pay_gb_eoy_magtape.validate_input(l_pay_in_this_emp,'NUMBER_1') > 0 THEN

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
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;

Line 3898: IF pay_gb_eoy_magtape.validate_input(l_tax_in_this_emp,'NUMBER_1') > 0 THEN

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
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

Line 3917: IF pay_gb_eoy_magtape.validate_input(l_total_pay_to_date,'NUMBER_1') > 0 THEN

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

Line 3961: IF pay_gb_eoy_magtape.validate_input(l_total_tax_to_date,'NUMBER_1') > 0 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).');
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;

Line 3990: ELSIF pay_gb_eoy_magtape.validate_tax_code_yrfil(p_assactid,l_tax_code,p_effective_date) <> ' ' THEN

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.');
3993: l_edi_validation_fail := 'Y';
3994: END IF;