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

Line 784: fnd_file.put_line (fnd_file.LOG,'Payroll ID has invalid characters for the assignment ' || l_assignment_number||'.');

780:
781: IF ((l_payroll_id <> ' ' and l_payroll_id IS NOT NULL)
782: and validate_input(l_payroll_id,'PAYROLLID') > 0) THEN
783: populate_run_msg(p_assactid,'Payroll ID has invalid characters for the assignment ' || l_assignment_number||'.');
784: fnd_file.put_line (fnd_file.LOG,'Payroll ID has invalid characters for the assignment ' || l_assignment_number||'.');
785: edi_validation_fail := 'Y';
786: END IF;
787:
788: IF l_eas_start_asg_date IS NOT NULL

Line 791: fnd_file.put_line (fnd_file.LOG,'The start date of employment for the assignment ' || l_assignment_number || ' is invalid.');

787:
788: IF l_eas_start_asg_date IS NOT NULL
789: and date_validate(p_assactid,'UK_EMPL_DATE',l_eas_start_asg_date) = 0 THEN
790: populate_run_msg(p_assactid,'The start date of employment for the assignment ' || l_assignment_number || ' is invalid.');
791: fnd_file.put_line (fnd_file.LOG,'The start date of employment for the assignment ' || l_assignment_number || ' is invalid.');
792: edi_validation_fail := 'Y';
793: END IF;
794:
795:

Line 799: fnd_file.put_line (fnd_file.LOG,'The end date of employment for the assignment ' || l_assignment_number || ' is invalid.');

795:
796: IF l_eas_end_asg_date IS NOT NULL
797: and date_validate(p_assactid,'UK_EMPL_DATE_LEAVING',l_eas_end_asg_date) = 0 THEN
798: populate_run_msg(p_assactid,' The end date of employment for the assignment ' || l_assignment_number || ' is invalid.');
799: fnd_file.put_line (fnd_file.LOG,'The end date of employment for the assignment ' || l_assignment_number || ' is invalid.');
800: edi_validation_fail := 'Y';
801: END IF;
802:
803: OPEN get_effective_date;

Line 818: fnd_file.put_line (fnd_file.LOG,'The Tax Code is missing for assignment ' || l_assignment_number||'.');

814: --Tax code
815:
816: IF (l_tax_code_in_use = ' ' OR l_tax_code_in_use IS NULL) then
817: populate_run_msg(p_assactid, 'The Tax Code is missing for assignment ' || l_assignment_number||'.');
818: fnd_file.put_line (fnd_file.LOG,'The Tax Code is missing for assignment ' || l_assignment_number||'.');
819: edi_validation_fail := 'Y';
820: END IF;
821:
822:

Line 826: fnd_file.put_line (fnd_file.LOG,'The Tax Code ' || l_tax_code_in_use || ' for assignment ' || l_assignment_number||' is invalid.');

822:
823: IF (l_tax_code_in_use <> ' ' and l_tax_code_in_use IS NOT NULL)
824: AND (l_msg_value <> ' ') THEN
825: populate_run_msg(p_assactid,'The Tax Code ' || l_tax_code_in_use || ' for assignment ' || l_assignment_number||' is invalid.');
826: fnd_file.put_line (fnd_file.LOG,'The Tax Code ' || l_tax_code_in_use || ' for assignment ' || l_assignment_number||' is invalid.');
827: edi_validation_fail := 'Y';
828: END IF;
829:
830: -- Tax basis validations

Line 835: fnd_file.put_line (fnd_file.LOG,'The Tax Code is not present although, Tax Basis is present for assignment ' || l_assignment_number||'.');

831:
832: --Tax basis cannot be present if tax code is absent
833: IF (l_tax_basis_in_use <>' ' and l_tax_basis_in_use IS NOT NULL) AND (l_tax_code_in_use = ' ' OR l_tax_code_in_use IS NULL)THEN
834: populate_run_msg(p_assactid, 'The Tax Code is not present although, Tax Basis is present for assignment ' || l_assignment_number||'.');
835: fnd_file.put_line (fnd_file.LOG,'The Tax Code is not present although, Tax Basis is present for assignment ' || l_assignment_number||'.');
836: edi_validation_fail := 'Y';
837: END IF;
838:
839: IF (l_tax_basis_in_use <>' ' AND l_tax_basis_in_use IS NOT NULL) AND (l_tax_basis_in_use <> 'Y' )THEN

Line 841: fnd_file.put_line (fnd_file.LOG,'Tax Basis ' ||l_tax_basis_in_use ||' for assignment ' || l_assignment_number||' is invalid.');

837: END IF;
838:
839: IF (l_tax_basis_in_use <>' ' AND l_tax_basis_in_use IS NOT NULL) AND (l_tax_basis_in_use <> 'Y' )THEN
840: populate_run_msg(p_assactid, 'Tax Basis ' ||l_tax_basis_in_use ||' for assignment ' || l_assignment_number||' is invalid.');
841: fnd_file.put_line (fnd_file.LOG,'Tax Basis ' ||l_tax_basis_in_use ||' for assignment ' || l_assignment_number||' is invalid.');
842: edi_validation_fail := 'Y';
843: END IF;
844:
845: hr_utility.set_location('Leaving: '||l_proc,111);

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

923: --Address line 1 and 2 are mandatory as Start date is not null
924:
925: IF l_address_line1 = ' ' OR l_address_line1 IS NULL THEN
926: populate_run_msg(p_assactid,'The Address Line 1 of the assignment ' || l_assignment_number || ' is missing.');
927: fnd_file.put_line (fnd_file.LOG,'The Address Line 1 of the assignment ' || l_assignment_number || ' is missing.');
928: edi_validation_fail := 'Y';
929: l_count_missing_val := l_count_missing_val + 1;
930:
931: elsIF validate_input(l_address_line1,'ADDRESS') > 0 THEN

Line 933: fnd_file.put_line (fnd_file.LOG,'The Address Line 1 ' || l_address_line1 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');

929: l_count_missing_val := l_count_missing_val + 1;
930:
931: elsIF validate_input(l_address_line1,'ADDRESS') > 0 THEN
932: populate_run_msg(p_assactid,'The Address Line 1 ' || l_address_line1 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
933: fnd_file.put_line (fnd_file.LOG,'The Address Line 1 ' || l_address_line1 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
934: edi_validation_fail := 'Y';
935: l_count_char_errors := l_count_char_errors + 1;
936: end if;
937:

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

936: end if;
937:
938: IF l_address_line2 = ' ' OR l_address_line2 IS NULL THEN
939: populate_run_msg(p_assactid,'The Address Line 2 of the assignment ' || l_assignment_number || ' is missing.');
940: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 of the assignment ' || l_assignment_number || ' is missing.');
941: edi_validation_fail := 'Y';
942: l_count_missing_val := l_count_missing_val + 1;
943:
944: elsIF validate_input(l_address_line2,'ADDRESS') > 0 THEN

Line 946: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 ' || l_address_line2 || ' of the assignment '|| l_assignment_number || ' has invalid characters.');

942: l_count_missing_val := l_count_missing_val + 1;
943:
944: elsIF validate_input(l_address_line2,'ADDRESS') > 0 THEN
945: populate_run_msg(p_assactid,'The Address Line 2 ' || l_address_line2 || ' of the assignment '|| l_assignment_number || ' has invalid characters.');
946: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 ' || l_address_line2 || ' of the assignment '|| l_assignment_number || ' has invalid characters.');
947: edi_validation_fail := 'Y';
948: l_count_char_errors := l_count_char_errors + 1;
949: end if;
950:

Line 954: fnd_file.put_line (fnd_file.LOG,'The Address Line 3 ' || l_address_line3 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');

950:
951: IF l_address_line3 <> ' ' and l_address_line3 IS NOT NULL THEN
952: IF validate_input(l_address_line3,'ADDRESS') > 0 THEN
953: populate_run_msg(p_assactid,'The Address Line 3 ' || l_address_line3 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
954: fnd_file.put_line (fnd_file.LOG,'The Address Line 3 ' || l_address_line3 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
955: edi_validation_fail := 'Y';
956: l_count_char_errors := l_count_char_errors + 1;
957: END IF;
958: END IF;

Line 963: fnd_file.put_line (fnd_file.LOG,'The Town or City ' || l_town_or_city ||' of the assignment ' || l_assignment_number || ' has invalid characters.');

959:
960: IF l_town_or_city <> ' ' and l_town_or_city IS NOT NULL THEN
961: IF validate_input(l_town_or_city,'ADDRESS') > 0 THEN
962: populate_run_msg(p_assactid,'The Town or City ' || l_town_or_city || ' of the assignment '|| l_assignment_number || ' has invalid characters.');
963: fnd_file.put_line (fnd_file.LOG,'The Town or City ' || l_town_or_city ||' of the assignment ' || l_assignment_number || ' has invalid characters.');
964: edi_validation_fail := 'Y';
965: l_count_char_errors := l_count_char_errors + 1;
966: END IF;
967: END IF;

Line 972: fnd_file.put_line (fnd_file.LOG,'The Country ' || l_country || ' of the assignment ' || l_assignment_number || ' has invalid characters.');

968:
969: IF l_country <> ' ' and l_country IS NOT NULL THEN
970: IF validate_input(l_country,'COUNTRY') > 0 THEN
971: populate_run_msg(p_assactid,'The Country ' || l_country || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
972: fnd_file.put_line (fnd_file.LOG,'The Country ' || l_country || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
973: edi_validation_fail := 'Y';
974: l_count_char_errors := l_count_char_errors + 1;
975: END IF;
976: END IF;

Line 981: fnd_file.put_line (fnd_file.LOG,'The Postal Code ' || l_postal_code || ' of the assignment ' || l_assignment_number || ' has invalid characters.');

977:
978: IF l_postal_code <> ' ' and l_postal_code IS NOT NULL THEN
979: IF validate_input(l_postal_code,'POSTALCODE') > 0 THEN
980: populate_run_msg(p_assactid,'The Postal Code ' || l_postal_code || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
981: fnd_file.put_line (fnd_file.LOG,'The Postal Code ' || l_postal_code || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
982: edi_validation_fail := 'Y';
983: l_count_char_errors := l_count_char_errors + 1;
984: END IF;
985: END IF;

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

987: --person validation
988:
989: IF l_last_name = ' ' OR l_last_name is null THEN
990: populate_run_msg(p_assactid,'The Last Name of the assignment ' || l_assignment_number || ' is missing.');
991: fnd_file.put_line (fnd_file.LOG,'The Last Name of the assignment '|| l_assignment_number || ' is missing.');
992: edi_validation_fail := 'Y';
993: l_count_missing_val := l_count_missing_val + 1;
994:
995: elsif validate_input(l_last_name,'NAME') > 0 then

Line 997: fnd_file.put_line (fnd_file.LOG,'The Last Name ' || l_last_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');

993: l_count_missing_val := l_count_missing_val + 1;
994:
995: elsif validate_input(l_last_name,'NAME') > 0 then
996: populate_run_msg(p_assactid,'The Last Name ' || l_last_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
997: fnd_file.put_line (fnd_file.LOG,'The Last Name ' || l_last_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
998: edi_validation_fail := 'Y';
999: l_count_char_errors := l_count_char_errors + 1;
1000: END IF;
1001:

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

1000: END IF;
1001:
1002: IF l_first_name = ' ' OR l_first_name is null THEN
1003: populate_run_msg(p_assactid,'The First Name of the assignment '|| l_assignment_number || ' is missing.');
1004: fnd_file.put_line (fnd_file.LOG,'The First Name of the assignment ' || l_assignment_number || ' is missing.');
1005: edi_validation_fail := 'Y';
1006: l_count_missing_val := l_count_missing_val + 1;
1007:
1008: ELSIF validate_input(l_first_name,'NAME') > 0 THEN

Line 1010: fnd_file.put_line (fnd_file.LOG,'The First Name ' || l_first_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');

1006: l_count_missing_val := l_count_missing_val + 1;
1007:
1008: ELSIF validate_input(l_first_name,'NAME') > 0 THEN
1009: populate_run_msg(p_assactid,'The First Name ' || l_first_name ||' of the assignment ' || l_assignment_number || ' has invalid characters.');
1010: fnd_file.put_line (fnd_file.LOG,'The First Name ' || l_first_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1011: edi_validation_fail := 'Y';
1012: l_count_char_errors := l_count_char_errors + 1;
1013: END IF;
1014:

Line 1018: fnd_file.put_line (fnd_file.LOG,'The Middle Name ' || l_middle_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');

1014:
1015: IF l_middle_name <> ' ' AND l_middle_name is not null THEN
1016: IF validate_input(l_middle_name,'NAME') > 0 THEN
1017: populate_run_msg(p_assactid,'The Middle Name ' || l_middle_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1018: fnd_file.put_line (fnd_file.LOG,'The Middle Name ' || l_middle_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1019: edi_validation_fail := 'Y';
1020: l_count_char_errors := l_count_char_errors + 1;
1021: END IF;
1022: END IF;

Line 1028: fnd_file.put_line (fnd_file.LOG,'The Title ' || l_title || ' of the assignment ' || l_assignment_number || ' has invalid characters.');

1024:
1025: IF l_title <> ' ' AND l_title is not null THEN
1026: IF validate_input(l_title,'TITLE') > 0 THEN
1027: populate_run_msg(p_assactid,'The Title ' || l_title || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1028: fnd_file.put_line (fnd_file.LOG,'The Title ' || l_title || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1029: edi_validation_fail := 'Y';
1030: l_count_char_errors := l_count_char_errors + 1;
1031: END IF;
1032: END IF;

Line 1037: fnd_file.put_line (fnd_file.LOG,'The National Insurance number ' || l_national_identifier || ' of the assignment ' || l_assignment_number || ' has invalid characters.');

1033:
1034: IF l_national_identifier is not null AND
1035: hr_gb_utility.ni_validate(l_national_identifier,p_effective_date) <> 0 THEN
1036: populate_run_msg(p_assactid,'The National Insurance number ' || l_national_identifier || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1037: fnd_file.put_line (fnd_file.LOG,'The National Insurance number ' || l_national_identifier || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1038: edi_validation_fail := 'Y';
1039: END IF;
1040:
1041: IF ((l_sex <> 'M' AND l_sex <> 'F') OR (l_sex = ' ' OR l_sex IS NULL)) THEN

Line 1043: fnd_file.put_line (fnd_file.LOG,'Gender is not specified for the assignment ' || l_assignment_number||'.');

1039: END IF;
1040:
1041: IF ((l_sex <> 'M' AND l_sex <> 'F') OR (l_sex = ' ' OR l_sex IS NULL)) THEN
1042: populate_run_msg(p_assactid,'Gender is not specified for the assignment ' || l_assignment_number||'.');
1043: fnd_file.put_line (fnd_file.LOG,'Gender is not specified for the assignment ' || l_assignment_number||'.');
1044: edi_validation_fail := 'Y';
1045: END IF;
1046:
1047: IF l_date_of_birth IS NULL THEN

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

1045: END IF;
1046:
1047: IF l_date_of_birth IS NULL THEN
1048: populate_run_msg(p_assactid,'The Date of Birth of the assignment ' || l_assignment_number || ' is missing.');
1049: fnd_file.put_line (fnd_file.LOG,'The Date of Birth of the assignment '|| l_assignment_number || ' is missing.');
1050: edi_validation_fail := 'Y';
1051: END IF;
1052:
1053: IF ((l_date_of_birth > p_effective_date) OR (l_year1 > 130)) THEN

Line 1055: fnd_file.put_line (fnd_file.LOG,'The Date of Birth of the assignment '|| l_assignment_number || ' is invalid.');

1051: END IF;
1052:
1053: IF ((l_date_of_birth > p_effective_date) OR (l_year1 > 130)) THEN
1054: populate_run_msg(p_assactid,'The Date of Birth of the assignment ' || l_assignment_number || ' is invalid.');
1055: fnd_file.put_line (fnd_file.LOG,'The Date of Birth of the assignment '|| l_assignment_number || ' is invalid.');
1056: edi_validation_fail := 'Y';
1057: END IF;
1058:
1059: hr_utility.set_location('Leaving'||l_proc,10);

Line 1141: fnd_file.put_line (fnd_file.LOG,'The Address Line 1 of the employee ' || l_employee_number || ' is missing.');

1137:
1138:
1139: IF l_address_line1 = ' ' OR l_address_line1 IS NULL THEN
1140: populate_run_msg(p_assactid,'The Address Line 1 of the employee ' || l_employee_number || ' is missing.');
1141: fnd_file.put_line (fnd_file.LOG,'The Address Line 1 of the employee ' || l_employee_number || ' is missing.');
1142: edi_validation_fail := 'Y';
1143: l_count_missing_val := l_count_missing_val + 1;
1144:
1145: elsIF validate_input(l_address_line1,'ADDRESS') > 0 THEN

Line 1147: fnd_file.put_line (fnd_file.LOG,'The Address Line 1 ' || l_address_line1 || ' of the employee ' || l_employee_number || ' has invalid characters.');

1143: l_count_missing_val := l_count_missing_val + 1;
1144:
1145: elsIF validate_input(l_address_line1,'ADDRESS') > 0 THEN
1146: populate_run_msg(p_assactid,'The Address Line 1 ' || l_address_line1 || ' of the employee ' || l_employee_number || ' has invalid characters.');
1147: fnd_file.put_line (fnd_file.LOG,'The Address Line 1 ' || l_address_line1 || ' of the employee ' || l_employee_number || ' has invalid characters.');
1148: edi_validation_fail := 'Y';
1149: l_count_char_errors := l_count_char_errors + 1;
1150: end if;
1151:

Line 1154: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 of the employee ' || l_employee_number || ' is missing.');

1150: end if;
1151:
1152: IF l_address_line2 = ' ' OR l_address_line2 IS NULL THEN
1153: populate_run_msg(p_assactid,'The Address Line 2 of the employee ' || l_employee_number || ' is missing.');
1154: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 of the employee ' || l_employee_number || ' is missing.');
1155: edi_validation_fail := 'Y';
1156: l_count_missing_val := l_count_missing_val + 1;
1157:
1158: elsIF validate_input(l_address_line2,'ADDRESS') > 0 THEN

Line 1160: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 ' || l_address_line2 || ' of the employee '|| l_employee_number || ' has invalid characters.');

1156: l_count_missing_val := l_count_missing_val + 1;
1157:
1158: elsIF validate_input(l_address_line2,'ADDRESS') > 0 THEN
1159: populate_run_msg(p_assactid,'The Address Line 2 ' || l_address_line2 || ' of the employee '|| l_employee_number || ' has invalid characters.');
1160: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 ' || l_address_line2 || ' of the employee '|| l_employee_number || ' has invalid characters.');
1161: edi_validation_fail := 'Y';
1162: l_count_char_errors := l_count_char_errors + 1;
1163: end if;
1164:

Line 1168: fnd_file.put_line (fnd_file.LOG,'The Address Line 3 ' || l_address_line3 || ' of the employee ' || l_employee_number || ' has invalid characters.');

1164:
1165: IF l_address_line3 <> ' ' and l_address_line3 IS NOT NULL THEN
1166: IF validate_input(l_address_line3,'ADDRESS') > 0 THEN
1167: populate_run_msg(p_assactid,'The Address Line 3 ' || l_address_line3 || ' of the employee ' || l_employee_number || ' has invalid characters.');
1168: fnd_file.put_line (fnd_file.LOG,'The Address Line 3 ' || l_address_line3 || ' of the employee ' || l_employee_number || ' has invalid characters.');
1169: edi_validation_fail := 'Y';
1170: l_count_char_errors := l_count_char_errors + 1;
1171: END IF;
1172: END IF;

Line 1177: fnd_file.put_line (fnd_file.LOG,'The Town or City ' || l_town_or_city ||' of the employee ' || l_employee_number || ' has invalid characters.');

1173:
1174: IF l_town_or_city <> ' ' and l_town_or_city IS NOT NULL THEN
1175: IF validate_input(l_town_or_city,'ADDRESS') > 0 THEN
1176: populate_run_msg(p_assactid,'The Town or City ' || l_town_or_city || ' of the employee '|| l_employee_number || ' has invalid characters.');
1177: fnd_file.put_line (fnd_file.LOG,'The Town or City ' || l_town_or_city ||' of the employee ' || l_employee_number || ' has invalid characters.');
1178: edi_validation_fail := 'Y';
1179: l_count_char_errors := l_count_char_errors + 1;
1180: END IF;
1181: END IF;

Line 1186: fnd_file.put_line (fnd_file.LOG,'The Country ' || l_country || ' of the employee ' || l_employee_number || ' has invalid characters.');

1182:
1183: IF l_country <> ' ' and l_country IS NOT NULL THEN
1184: IF validate_input(l_country,'COUNTRY') > 0 THEN
1185: populate_run_msg(p_assactid,'The Country ' || l_country || ' of the employee ' || l_employee_number || ' has invalid characters.');
1186: fnd_file.put_line (fnd_file.LOG,'The Country ' || l_country || ' of the employee ' || l_employee_number || ' has invalid characters.');
1187: edi_validation_fail := 'Y';
1188: l_count_char_errors := l_count_char_errors + 1;
1189: END IF;
1190: END IF;

Line 1195: fnd_file.put_line (fnd_file.LOG,'The Postal Code ' || l_postal_code || ' of the employee ' || l_employee_number || ' has invalid characters.');

1191:
1192: IF l_postal_code <> ' ' and l_postal_code IS NOT NULL THEN
1193: IF validate_input(l_postal_code,'POSTALCODE') > 0 THEN
1194: populate_run_msg(p_assactid,'The Postal Code ' || l_postal_code || ' of the employee ' || l_employee_number || ' has invalid characters.');
1195: fnd_file.put_line (fnd_file.LOG,'The Postal Code ' || l_postal_code || ' of the employee ' || l_employee_number || ' has invalid characters.');
1196: edi_validation_fail := 'Y';
1197: l_count_char_errors := l_count_char_errors + 1;
1198: END IF;
1199: END IF;

Line 1205: fnd_file.put_line (fnd_file.LOG,'The Last Name of the employee '|| l_employee_number || ' is missing.');

1201: --person validation
1202:
1203: IF l_last_name = ' ' OR l_last_name is null THEN
1204: populate_run_msg(p_assactid,'The Last Name of the employee ' || l_employee_number || ' is missing.');
1205: fnd_file.put_line (fnd_file.LOG,'The Last Name of the employee '|| l_employee_number || ' is missing.');
1206: edi_validation_fail := 'Y';
1207: l_count_missing_val := l_count_missing_val + 1;
1208:
1209: elsif validate_input(l_last_name,'NAME') > 0 then

Line 1211: fnd_file.put_line (fnd_file.LOG,'The Last Name ' || l_last_name || ' of the employee ' || l_employee_number || ' has invalid characters.');

1207: l_count_missing_val := l_count_missing_val + 1;
1208:
1209: elsif validate_input(l_last_name,'NAME') > 0 then
1210: populate_run_msg(p_assactid,'The Last Name ' || l_last_name || ' of the employee ' || l_employee_number || ' has invalid characters.');
1211: fnd_file.put_line (fnd_file.LOG,'The Last Name ' || l_last_name || ' of the employee ' || l_employee_number || ' has invalid characters.');
1212: edi_validation_fail := 'Y';
1213: l_count_char_errors := l_count_char_errors + 1;
1214: END IF;
1215:

Line 1218: fnd_file.put_line (fnd_file.LOG,'The First Name of the employee ' || l_employee_number || ' is missing.');

1214: END IF;
1215:
1216: IF l_first_name = ' ' OR l_first_name is null THEN
1217: populate_run_msg(p_assactid,'The First Name of the employee '|| l_employee_number || ' is missing.');
1218: fnd_file.put_line (fnd_file.LOG,'The First Name of the employee ' || l_employee_number || ' is missing.');
1219: edi_validation_fail := 'Y';
1220: l_count_missing_val := l_count_missing_val + 1;
1221:
1222: ELSIF validate_input(l_first_name,'NAME') > 0 THEN

Line 1224: fnd_file.put_line (fnd_file.LOG,'The First Name ' || l_first_name || ' of the employee ' || l_employee_number || ' has invalid characters.');

1220: l_count_missing_val := l_count_missing_val + 1;
1221:
1222: ELSIF validate_input(l_first_name,'NAME') > 0 THEN
1223: populate_run_msg(p_assactid,'The First Name ' || l_first_name ||' of the employee ' || l_employee_number || ' has invalid characters.');
1224: fnd_file.put_line (fnd_file.LOG,'The First Name ' || l_first_name || ' of the employee ' || l_employee_number || ' has invalid characters.');
1225: edi_validation_fail := 'Y';
1226: l_count_char_errors := l_count_char_errors + 1;
1227: END IF;
1228:

Line 1232: fnd_file.put_line (fnd_file.LOG,'The First Name ' || l_middle_name || ' of the employee ' || l_employee_number || ' has invalid characters.');

1228:
1229: IF l_middle_name <> ' ' AND l_middle_name is not null THEN
1230: IF validate_input(l_middle_name,'NAME') > 0 THEN
1231: populate_run_msg(p_assactid,'The First Name ' || l_middle_name || ' of the employee ' || l_employee_number || ' has invalid characters.');
1232: fnd_file.put_line (fnd_file.LOG,'The First Name ' || l_middle_name || ' of the employee ' || l_employee_number || ' has invalid characters.');
1233: edi_validation_fail := 'Y';
1234: l_count_char_errors := l_count_char_errors + 1;
1235: END IF;
1236: END IF;

Line 1242: fnd_file.put_line (fnd_file.LOG,'The Title ' || l_title || ' of the employee ' || l_employee_number || ' has invalid characters.');

1238:
1239: IF l_title <> ' ' AND l_title is not null THEN
1240: IF validate_input(l_title,'TITLE') > 0 THEN
1241: populate_run_msg(p_assactid,'The Title ' || l_title || ' of the employee ' || l_employee_number || ' has invalid characters.');
1242: fnd_file.put_line (fnd_file.LOG,'The Title ' || l_title || ' of the employee ' || l_employee_number || ' has invalid characters.');
1243: edi_validation_fail := 'Y';
1244: l_count_char_errors := l_count_char_errors + 1;
1245: END IF;
1246: END IF;

Line 1251: fnd_file.put_line (fnd_file.LOG,'The National Insurance number ' || l_national_identifier || ' of the employee ' || l_employee_number || ' has invalid characters.');

1247:
1248: IF l_national_identifier is not null AND
1249: hr_gb_utility.ni_validate(l_national_identifier,sysdate) <> 0 THEN
1250: populate_run_msg(p_assactid,'The National Insurance number ' || l_national_identifier || ' of the employee ' || l_employee_number || ' has invalid characters.');
1251: fnd_file.put_line (fnd_file.LOG,'The National Insurance number ' || l_national_identifier || ' of the employee ' || l_employee_number || ' has invalid characters.');
1252: edi_validation_fail := 'Y';
1253: END IF;
1254:
1255: IF ((l_sex <> 'M' AND l_sex <> 'F') OR (l_sex = ' ' OR l_sex IS NULL)) THEN

Line 1257: fnd_file.put_line (fnd_file.LOG,'Gender is not specified for the employee ' || l_employee_number||'.');

1253: END IF;
1254:
1255: IF ((l_sex <> 'M' AND l_sex <> 'F') OR (l_sex = ' ' OR l_sex IS NULL)) THEN
1256: populate_run_msg(p_assactid,'Gender is not specified for the employee ' || l_employee_number||'.');
1257: fnd_file.put_line (fnd_file.LOG,'Gender is not specified for the employee ' || l_employee_number||'.');
1258: edi_validation_fail := 'Y';
1259: END IF;
1260:
1261: IF l_date_of_birth IS NULL THEN

Line 1263: fnd_file.put_line (fnd_file.LOG,'The Date of Birth of the employee '|| l_employee_number || ' is missing.');

1259: END IF;
1260:
1261: IF l_date_of_birth IS NULL THEN
1262: populate_run_msg(p_assactid,'The Date of Birth of the employee ' || l_employee_number || ' is missing.');
1263: fnd_file.put_line (fnd_file.LOG,'The Date of Birth of the employee '|| l_employee_number || ' is missing.');
1264: edi_validation_fail := 'Y';
1265: END IF;
1266:
1267: IF ((l_date_of_birth > sysdate) OR (l_year1 > 130)) THEN

Line 1269: fnd_file.put_line (fnd_file.LOG,'The Date of Birth of the employee '|| l_employee_number || ' is invalid.');

1265: END IF;
1266:
1267: IF ((l_date_of_birth > sysdate) OR (l_year1 > 130)) THEN
1268: populate_run_msg(p_assactid,'The Date of Birth of the employee ' || l_employee_number || ' is invalid.');
1269: fnd_file.put_line (fnd_file.LOG,'The Date of Birth of the employee '|| l_employee_number || ' is invalid.');
1270: edi_validation_fail := 'Y';
1271: END IF;
1272:
1273: hr_utility.set_location('Leaving'||l_proc,10);

Line 1915: fnd_file.put_line (fnd_file.LOG,'Terminated Asg '||asg_rec.assignment_id||' found.P45 issued.');

1911: end if;
1912: /*
1913: -- P45 check.If issued do not pick the assignment
1914: if asg_rec.status = 'TERM_ASSIGN' and pay_p45_pkg.return_p45_issued_flag(asg_rec.assignment_id) = 'Y' then
1915: fnd_file.put_line (fnd_file.LOG,'Terminated Asg '||asg_rec.assignment_id||' found.P45 issued.');
1916: l_flag:= 'N';
1917: end if;*/
1918:
1919: -- If Terminated before start of the Tax Year. Ignore the assignment

Line 2265: fnd_file.put_line(fnd_file.output,'The HMRC Office Number is missing.');

2261:
2262:
2263: if l_payroll_rec.tax_office_no = ' ' or l_payroll_rec.tax_office_no is null then
2264: hr_utility.set_location('The HMRC Office Number is missing.',10);
2265: fnd_file.put_line(fnd_file.output,'The HMRC Office Number is missing.');
2266: l_err := true;
2267: elsif validate_input(substr(l_payroll_rec.tax_office_no,1,3),'NUMBER') > 0
2268: then
2269: hr_utility.set_location('The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.',10);

Line 2270: fnd_file.put_line(fnd_file.output,'The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.');

2266: l_err := true;
2267: elsif validate_input(substr(l_payroll_rec.tax_office_no,1,3),'NUMBER') > 0
2268: then
2269: hr_utility.set_location('The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.',10);
2270: fnd_file.put_line(fnd_file.output,'The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.');
2271: l_err := true;
2272: end if;
2273:
2274: if l_payroll_rec.tax_ref_no = ' ' or l_payroll_rec.tax_ref_no is null then

Line 2276: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference is missing.');

2272: end if;
2273:
2274: if l_payroll_rec.tax_ref_no = ' ' or l_payroll_rec.tax_ref_no is null then
2275: hr_utility.set_location('The Employer PAYE Reference is missing.',10);
2276: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference is missing.');
2277: l_err := true;
2278: elsif validate_input(l_payroll_rec.tax_ref_no,'FULL_EDI') > 0 then
2279: hr_utility.set_location('The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.',10);
2280: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.');

Line 2280: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.');

2276: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference is missing.');
2277: l_err := true;
2278: elsif validate_input(l_payroll_rec.tax_ref_no,'FULL_EDI') > 0 then
2279: hr_utility.set_location('The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.',10);
2280: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.');
2281: l_err := true;
2282: end if;
2283:
2284: if l_payroll_rec.employer_name = ' ' or l_payroll_rec.employer_name is null then

Line 2286: fnd_file.put_line(fnd_file.output,'The Employer Name is missing.');

2282: end if;
2283:
2284: if l_payroll_rec.employer_name = ' ' or l_payroll_rec.employer_name is null then
2285: hr_utility.set_location('The Employer Name is missing.',10);
2286: fnd_file.put_line(fnd_file.output,'The Employer Name is missing.');
2287: l_err := true;
2288: elsif validate_input(l_payroll_rec.employer_name,'EMP_NAME') > 0 then
2289: hr_utility.set_location('The Employer Name '||l_payroll_rec.employer_name||' has invalid characters.',10);
2290: fnd_file.put_line(fnd_file.output,'The Employer Name '||l_payroll_rec.employer_name||' has invalid characters.');

Line 2290: fnd_file.put_line(fnd_file.output,'The Employer Name '||l_payroll_rec.employer_name||' has invalid characters.');

2286: fnd_file.put_line(fnd_file.output,'The Employer Name is missing.');
2287: l_err := true;
2288: elsif validate_input(l_payroll_rec.employer_name,'EMP_NAME') > 0 then
2289: hr_utility.set_location('The Employer Name '||l_payroll_rec.employer_name||' has invalid characters.',10);
2290: fnd_file.put_line(fnd_file.output,'The Employer Name '||l_payroll_rec.employer_name||' has invalid characters.');
2291: l_err := true;
2292: end if;
2293:
2294: if l_payroll_rec.acc_ref_no = ' ' or l_payroll_rec.acc_ref_no is null then

Line 2296: fnd_file.put_line(fnd_file.output,'The Account Office Reference Number is missing.');

2292: end if;
2293:
2294: if l_payroll_rec.acc_ref_no = ' ' or l_payroll_rec.acc_ref_no is null then
2295: hr_utility.set_location('The Account Office Reference Number is missing.',10);
2296: fnd_file.put_line(fnd_file.output,'The Account Office Reference Number is missing.');
2297: l_err := true;
2298:
2299: elsif (length(l_payroll_rec.acc_ref_no) > 13
2300: OR REGEXP_INSTR(l_payroll_rec.acc_ref_no,'^([[:digit:]]{1,3})P([[:alpha:]]{1})([[:digit:]]{1,7})([[:digit:]]|X)$') = 0 ) THEN

Line 2303: fnd_file.put_line(fnd_file.output,'Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.');

2299: elsif (length(l_payroll_rec.acc_ref_no) > 13
2300: OR REGEXP_INSTR(l_payroll_rec.acc_ref_no,'^([[:digit:]]{1,3})P([[:alpha:]]{1})([[:digit:]]{1,7})([[:digit:]]|X)$') = 0 ) THEN
2301:
2302: hr_utility.set_location ('Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.',10);
2303: fnd_file.put_line(fnd_file.output,'Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.');
2304: l_err := true;
2305: END IF;
2306:
2307: END IF;

Line 2665: fnd_file.put_line(fnd_file.output,' ');

2661: l_form := 'RTI_NINO_REP';
2662: l_form_name :='NINO Verification Request Process';
2663: end if;
2664:
2665: fnd_file.put_line(fnd_file.output,' ');
2666: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
2667: fnd_file.put_line(fnd_file.output,' ');
2668: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
2669: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);

Line 2666: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');

2662: l_form_name :='NINO Verification Request Process';
2663: end if;
2664:
2665: fnd_file.put_line(fnd_file.output,' ');
2666: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
2667: fnd_file.put_line(fnd_file.output,' ');
2668: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
2669: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
2670: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));

Line 2667: fnd_file.put_line(fnd_file.output,' ');

2663: end if;
2664:
2665: fnd_file.put_line(fnd_file.output,' ');
2666: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
2667: fnd_file.put_line(fnd_file.output,' ');
2668: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
2669: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
2670: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
2671: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);

Line 2668: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);

2664:
2665: fnd_file.put_line(fnd_file.output,' ');
2666: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
2667: fnd_file.put_line(fnd_file.output,' ');
2668: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
2669: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
2670: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
2671: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
2672: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);

Line 2669: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);

2665: fnd_file.put_line(fnd_file.output,' ');
2666: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
2667: fnd_file.put_line(fnd_file.output,' ');
2668: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
2669: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
2670: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
2671: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
2672: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
2673: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));

Line 2670: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));

2666: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
2667: fnd_file.put_line(fnd_file.output,' ');
2668: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
2669: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
2670: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
2671: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
2672: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
2673: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
2674: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);

Line 2671: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);

2667: fnd_file.put_line(fnd_file.output,' ');
2668: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
2669: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
2670: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
2671: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
2672: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
2673: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
2674: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
2675: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);

Line 2672: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);

2668: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
2669: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
2670: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
2671: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
2672: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
2673: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
2674: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
2675: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
2676: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);

Line 2673: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));

2669: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
2670: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
2671: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
2672: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
2673: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
2674: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
2675: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
2676: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
2677: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);

Line 2674: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);

2670: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
2671: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
2672: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
2673: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
2674: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
2675: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
2676: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
2677: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
2678:

Line 2675: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);

2671: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
2672: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
2673: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
2674: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
2675: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
2676: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
2677: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
2678:
2679: if length(l_addr2) > 0 then

Line 2676: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);

2672: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
2673: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
2674: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
2675: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
2676: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
2677: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
2678:
2679: if length(l_addr2) > 0 then
2680: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);

Line 2677: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);

2673: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
2674: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
2675: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
2676: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
2677: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
2678:
2679: if length(l_addr2) > 0 then
2680: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
2681: end if;

Line 2680: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);

2676: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
2677: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
2678:
2679: if length(l_addr2) > 0 then
2680: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
2681: end if;
2682: if length(l_addr3) > 0 then
2683: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
2684: end if;

Line 2683: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);

2679: if length(l_addr2) > 0 then
2680: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
2681: end if;
2682: if length(l_addr3) > 0 then
2683: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
2684: end if;
2685: if length(l_addr4) > 0 then
2686: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);
2687: end if;

Line 2686: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);

2682: if length(l_addr3) > 0 then
2683: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
2684: end if;
2685: if length(l_addr4) > 0 then
2686: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);
2687: end if;
2688: if report_type = 'RTI_EAS_REP' then
2689: fnd_file.put_line(fnd_file.output,rpad('Effective Date : ',32) || l_eff_date);
2690: end if;

Line 2689: fnd_file.put_line(fnd_file.output,rpad('Effective Date : ',32) || l_eff_date);

2685: if length(l_addr4) > 0 then
2686: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);
2687: end if;
2688: if report_type = 'RTI_EAS_REP' then
2689: fnd_file.put_line(fnd_file.output,rpad('Effective Date : ',32) || l_eff_date);
2690: end if;
2691:
2692: end write_header;
2693:

Line 2696: fnd_file.put_line(fnd_file.output,null);

2692: end write_header;
2693:
2694: procedure write_sub_header(p_type varchar2,report_type varchar2) is
2695: begin
2696: fnd_file.put_line(fnd_file.output,null);
2697: if p_type = 'E' then
2698: fnd_file.put_line(fnd_file.output,'The following employments have completed with error');
2699: else
2700: fnd_file.put_line(fnd_file.output,'The following employments have completed successfully');

Line 2698: fnd_file.put_line(fnd_file.output,'The following employments have completed with error');

2694: procedure write_sub_header(p_type varchar2,report_type varchar2) is
2695: begin
2696: fnd_file.put_line(fnd_file.output,null);
2697: if p_type = 'E' then
2698: fnd_file.put_line(fnd_file.output,'The following employments have completed with error');
2699: else
2700: fnd_file.put_line(fnd_file.output,'The following employments have completed successfully');
2701: end if;
2702:

Line 2700: fnd_file.put_line(fnd_file.output,'The following employments have completed successfully');

2696: fnd_file.put_line(fnd_file.output,null);
2697: if p_type = 'E' then
2698: fnd_file.put_line(fnd_file.output,'The following employments have completed with error');
2699: else
2700: fnd_file.put_line(fnd_file.output,'The following employments have completed successfully');
2701: end if;
2702:
2703: if report_type = 'RTI_EAS_REP' then
2704:

Line 2706: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) ||

2702:
2703: if report_type = 'RTI_EAS_REP' then
2704:
2705: if p_type <> 'E' then --Completed records
2706: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) ||
2707: rpad('NI Number',11) ||
2708: rpad('Employee Name', 51) ||
2709: rpad('Start Date',16) ||
2710: rpad('End Date',16));

Line 2712: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) ||

2708: rpad('Employee Name', 51) ||
2709: rpad('Start Date',16) ||
2710: rpad('End Date',16));
2711: else -- errored records
2712: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) ||
2713: rpad('NI Number',11) ||
2714: rpad('Employee Name', 51) ||
2715: rpad('Start Date',16) ||
2716: rpad('End Date',16) ||

Line 2722: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||

2718: end if;
2719:
2720:
2721: if p_type <> 'E' then -- Completed records
2722: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||
2723: rpad('-',10,'-') || ' ' ||
2724: rpad('-',50,'-') || ' ' ||
2725: rpad('-',15,'-') || ' ' ||
2726: rpad('-',15,'-') );

Line 2729: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||

2725: rpad('-',15,'-') || ' ' ||
2726: rpad('-',15,'-') );
2727:
2728: else -- errored records
2729: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||
2730: rpad('-',10,'-') || ' ' ||
2731: rpad('-',50,'-') || ' ' ||
2732: rpad('-',15,'-') || ' ' ||
2733: rpad('-',15,'-') || ' ' ||

Line 2741: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||

2737:
2738: if report_type = 'RTI_NINO_REP' then
2739:
2740: if p_type <> 'E' then -- completed records
2741: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
2742: rpad('NI Number',11) ||
2743: rpad('Employee Name', 52));
2744: else
2745: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||

Line 2745: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||

2741: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
2742: rpad('NI Number',11) ||
2743: rpad('Employee Name', 52));
2744: else
2745: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
2746: rpad('NI Number',11) ||
2747: rpad('Employee Name', 51) ||
2748: rpad('Error Messages',30));
2749: end if;

Line 2753: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||

2749: end if;
2750:
2751:
2752: if p_type <> 'E' then
2753: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||
2754: rpad('-',10,'-') || ' ' ||
2755: rpad('-',52,'-') );
2756:
2757: else

Line 2758: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||

2754: rpad('-',10,'-') || ' ' ||
2755: rpad('-',52,'-') );
2756:
2757: else
2758: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||
2759: rpad('-',10,'-') || ' ' ||
2760: rpad('-',50,'-') || ' ' ||
2761: rpad('-',30,'-'));
2762: end if;

Line 2985: fnd_file.put_line(fnd_file.output,rpad(asg_rec1.emp_no, 18) || ' ' ||

2981: end if;
2982:
2983:
2984: if report_type = 'RTI_EAS_REP' then
2985: fnd_file.put_line(fnd_file.output,rpad(asg_rec1.emp_no, 18) || ' ' ||
2986: rpad(asg_rec1.ni_no ,10) || ' ' ||
2987: rpad(l_et_temp,50) || ' ' ||
2988: rpad(asg_rec1.start_date,15) || ' ' ||
2989: rpad(asg_rec1.end_date,15) );

Line 2992: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.employee_number, 18) || ' ' ||

2988: rpad(asg_rec1.start_date,15) || ' ' ||
2989: rpad(asg_rec1.end_date,15) );
2990:
2991: elsif report_type = 'RTI_NINO_REP' then
2992: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.employee_number, 18) || ' ' ||
2993: rpad(et_asg_rec.ni_no ,10) || ' ' ||
2994: rpad(l_et_temp,50));
2995: end if;
2996:

Line 3025: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' ||

3021: asg_rec.f_name || ' ' || asg_rec.m_name;
3022:
3023: if report_type = 'RTI_EAS_REP' then
3024: if asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') then
3025: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' ||
3026: rpad(asg_rec.ni_no ,10) || ' ' ||
3027: rpad(l_temp,50) || ' ' ||
3028: rpad(asg_rec.start_date,15) || ' ' ||
3029: rpad(' ' ,15) || ' ' ||

Line 3032: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' ||

3028: rpad(asg_rec.start_date,15) || ' ' ||
3029: rpad(' ' ,15) || ' ' ||
3030: rpad(err_msg.line_text,100) ); -- error message
3031: else
3032: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' ||
3033: rpad(asg_rec.ni_no ,10) || ' ' ||
3034: rpad(l_temp,50) || ' ' ||
3035: rpad(asg_rec.start_date,15) || ' ' ||
3036: rpad(asg_rec.end_date,15) || ' ' ||

Line 3041: fnd_file.put_line(fnd_file.output,rpad(asg_rec.employee_number, 18) || ' ' ||

3037: rpad(err_msg.line_text,100) ); -- error message
3038:
3039: end if;
3040: elsif report_type = 'RTI_NINO_REP' then
3041: fnd_file.put_line(fnd_file.output,rpad(asg_rec.employee_number, 18) || ' ' ||
3042: rpad(asg_rec.ni_no ,10) || ' ' ||
3043: rpad(l_temp,50) || ' ' ||
3044: rpad(err_msg.line_text,100) ); -- error message
3045: end if;

Line 3051: fnd_file.put_line(fnd_file.output,rpad(' ',113,' ')||rpad(err_msg.line_text,100));

3047: loop
3048: fetch csr_err_msg into err_msg;
3049: exit when csr_err_msg%notfound;
3050: if report_type = 'RTI_EAS_REP' then
3051: fnd_file.put_line(fnd_file.output,rpad(' ',113,' ')||rpad(err_msg.line_text,100));
3052: elsif report_type = 'RTI_NINO_REP' then
3053: fnd_file.put_line(fnd_file.output,rpad(' ',81,' ')||rpad(err_msg.line_text,100));
3054: end if;
3055: end loop;

Line 3053: fnd_file.put_line(fnd_file.output,rpad(' ',81,' ')||rpad(err_msg.line_text,100));

3049: exit when csr_err_msg%notfound;
3050: if report_type = 'RTI_EAS_REP' then
3051: fnd_file.put_line(fnd_file.output,rpad(' ',113,' ')||rpad(err_msg.line_text,100));
3052: elsif report_type = 'RTI_NINO_REP' then
3053: fnd_file.put_line(fnd_file.output,rpad(' ',81,' ')||rpad(err_msg.line_text,100));
3054: end if;
3055: end loop;
3056: close csr_err_msg;
3057:

Line 3062: fnd_file.put_line(fnd_file.output,null);

3058: l_count := l_count + 1;
3059: END LOOP;
3060: END IF;
3061:
3062: fnd_file.put_line(fnd_file.output,null);
3063: if p_type = 'E' then
3064: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with error : ' || l_count);
3065: else
3066: fnd_file.put_line(fnd_file.output,'Total Number of employments completed successfully :' || l_count);

Line 3064: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with error : ' || l_count);

3060: END IF;
3061:
3062: fnd_file.put_line(fnd_file.output,null);
3063: if p_type = 'E' then
3064: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with error : ' || l_count);
3065: else
3066: fnd_file.put_line(fnd_file.output,'Total Number of employments completed successfully :' || l_count);
3067: end if;
3068: l_counter := l_counter + l_count;

Line 3066: fnd_file.put_line(fnd_file.output,'Total Number of employments completed successfully :' || l_count);

3062: fnd_file.put_line(fnd_file.output,null);
3063: if p_type = 'E' then
3064: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with error : ' || l_count);
3065: else
3066: fnd_file.put_line(fnd_file.output,'Total Number of employments completed successfully :' || l_count);
3067: end if;
3068: l_counter := l_counter + l_count;
3069: end write_body;
3070:

Line 3089: fnd_file.put_line(fnd_file.output,null);

3085: open get_person_count;
3086: fetch get_person_count into l_person_count;
3087: close get_person_count;
3088:
3089: fnd_file.put_line(fnd_file.output,null);
3090: fnd_file.put_line(fnd_file.output,'Total Number Of employments : ' || l_counter);
3091: fnd_file.put_line(fnd_file.output,null);
3092: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
3093: end write_footer;

Line 3090: fnd_file.put_line(fnd_file.output,'Total Number Of employments : ' || l_counter);

3086: fetch get_person_count into l_person_count;
3087: close get_person_count;
3088:
3089: fnd_file.put_line(fnd_file.output,null);
3090: fnd_file.put_line(fnd_file.output,'Total Number Of employments : ' || l_counter);
3091: fnd_file.put_line(fnd_file.output,null);
3092: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
3093: end write_footer;
3094:

Line 3091: fnd_file.put_line(fnd_file.output,null);

3087: close get_person_count;
3088:
3089: fnd_file.put_line(fnd_file.output,null);
3090: fnd_file.put_line(fnd_file.output,'Total Number Of employments : ' || l_counter);
3091: fnd_file.put_line(fnd_file.output,null);
3092: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
3093: end write_footer;
3094:
3095: ---------------------

Line 3092: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);

3088:
3089: fnd_file.put_line(fnd_file.output,null);
3090: fnd_file.put_line(fnd_file.output,'Total Number Of employments : ' || l_counter);
3091: fnd_file.put_line(fnd_file.output,null);
3092: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
3093: end write_footer;
3094:
3095: ---------------------
3096: ---------------------