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

Line 121: fnd_file.put_line(fnd_file.output,'The Sender ID is missing.');

117:
118: -- Sender Id
119: if l_payroll_rec.sender_id = ' ' or l_payroll_rec.sender_id is null then
120: hr_utility.set_location('The Sender ID is missing.',10);
121: fnd_file.put_line(fnd_file.output,'The Sender ID is missing.');
122: l_err := true;
123: end if;
124:
125: -- HMRC Office Number

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

124:
125: -- HMRC Office Number
126: if l_payroll_rec.tax_office_no = ' ' or l_payroll_rec.tax_office_no is null then
127: hr_utility.set_location('The HMRC Office number is missing.',10);
128: fnd_file.put_line(fnd_file.output,'The HMRC Office number is missing.');
129: l_err := true;
130: elsif validate_input(substr(l_payroll_rec.tax_office_no,1,3),'NUMBER') > 0
131: then
132: hr_utility.set_location('The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.',10);

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

129: l_err := true;
130: elsif validate_input(substr(l_payroll_rec.tax_office_no,1,3),'NUMBER') > 0
131: then
132: hr_utility.set_location('The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.',10);
133: fnd_file.put_line(fnd_file.output,'The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.');
134: l_err := true;
135: end if;
136:
137: -- Employer PAYE Ref

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

136:
137: -- Employer PAYE Ref
138: if l_payroll_rec.tax_ref_no = ' ' or l_payroll_rec.tax_ref_no is null then
139: hr_utility.set_location('The Employer PAYE Reference is missing.',10);
140: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference is missing.');
141: l_err := true;
142: elsif validate_input(l_payroll_rec.tax_ref_no,'FULL_EDI') > 0 then
143: hr_utility.set_location('The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.',10);
144: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.');

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

140: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference is missing.');
141: l_err := true;
142: elsif validate_input(l_payroll_rec.tax_ref_no,'FULL_EDI') > 0 then
143: hr_utility.set_location('The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.',10);
144: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.');
145: l_err := true;
146: end if;
147:
148: -- Employer Name

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

147:
148: -- Employer Name
149: if l_payroll_rec.employer_name = ' ' or l_payroll_rec.employer_name is null then
150: hr_utility.set_location('The Employer Name is missing.',10);
151: fnd_file.put_line(fnd_file.output,'The Employer Name is missing.');
152: l_err := true;
153: elsif validate_input(l_payroll_rec.employer_name,'EMP_NAME') > 0 then
154: hr_utility.set_location('The Employer Name '||l_payroll_rec.employer_name ||' has invalid characters.',10);
155: fnd_file.put_line(fnd_file.output,'The Employer Name '||l_payroll_rec.employer_name ||' has invalid characters.');

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

151: fnd_file.put_line(fnd_file.output,'The Employer Name is missing.');
152: l_err := true;
153: elsif validate_input(l_payroll_rec.employer_name,'EMP_NAME') > 0 then
154: hr_utility.set_location('The Employer Name '||l_payroll_rec.employer_name ||' has invalid characters.',10);
155: fnd_file.put_line(fnd_file.output,'The Employer Name '||l_payroll_rec.employer_name ||' has invalid characters.');
156: l_err := true;
157: end if;
158:
159: -- Accounts Office Number

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

158:
159: -- Accounts Office Number
160: if l_payroll_rec.acc_ref_no = ' ' or l_payroll_rec.acc_ref_no is null then
161: hr_utility.set_location('The Account Office Reference Number is missing.',10);
162: fnd_file.put_line(fnd_file.output,'The Account Office Reference Number is missing.');
163: l_err := true;
164: elsif (length(l_payroll_rec.acc_ref_no) > 13
165: OR REGEXP_INSTR(l_payroll_rec.acc_ref_no,'^([[:digit:]]{1,3})P([[:alpha:]]{1})([[:digit:]]{1,7})([[:digit:]]|X)$') = 0 ) THEN
166:

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

164: elsif (length(l_payroll_rec.acc_ref_no) > 13
165: OR REGEXP_INSTR(l_payroll_rec.acc_ref_no,'^([[:digit:]]{1,3})P([[:alpha:]]{1})([[:digit:]]{1,7})([[:digit:]]|X)$') = 0 ) THEN
166:
167: hr_utility.set_location ('Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.',10);
168: fnd_file.put_line(fnd_file.output,'Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.');
169: l_err := true;
170: END IF;
171:
172: -- Econ

Line 176: fnd_file.put_line(fnd_file.output,'ECON Number '||l_payroll_rec.econ ||' is invalid.');

172: -- Econ
173: if l_payroll_rec.econ is not null then
174: IF econ_validate(l_payroll_rec.econ) = 0 THEN
175: hr_utility.set_location('ECON Number '||l_payroll_rec.econ ||' is invalid',10);
176: fnd_file.put_line(fnd_file.output,'ECON Number '||l_payroll_rec.econ ||' is invalid.');
177: l_err := true;
178: END IF;
179: END IF;
180:

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

304: --Address line 1 is mandatory if Start date is not null or nino is null
305: IF l_start_date is not null or l_national_identifier is null then
306: IF l_address_line1 = ' ' OR l_address_line1 IS NULL THEN
307: populate_run_msg(p_assactid,'The Address Line 1 of the assignment ' || l_assignment_number || ' is missing.');
308: fnd_file.put_line (fnd_file.LOG,'The Address Line 1 of the assignment ' || l_assignment_number || ' is missing.');
309: edi_validation_fail := 'Y';
310: ELSIF validate_input(l_address_line1,'ADDRESS') > 0 THEN
311: populate_run_msg(p_assactid,'The Address Line 1 ' || l_address_line1 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
312: fnd_file.put_line (fnd_file.LOG,'The Address Line 1 ' || l_address_line1 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');

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

308: fnd_file.put_line (fnd_file.LOG,'The Address Line 1 of the assignment ' || l_assignment_number || ' is missing.');
309: edi_validation_fail := 'Y';
310: ELSIF validate_input(l_address_line1,'ADDRESS') > 0 THEN
311: populate_run_msg(p_assactid,'The Address Line 1 ' || l_address_line1 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
312: fnd_file.put_line (fnd_file.LOG,'The Address Line 1 ' || l_address_line1 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
313: edi_validation_fail := 'Y';
314: END IF;
315: END IF;
316:

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

317: --Address line 2 is mandatory if Start date is not null
318: IF l_start_date is not null then
319: IF l_address_line2 = ' ' OR l_address_line2 IS NULL THEN
320: populate_run_msg(p_assactid,'The Address Line 2 of the assignment ' || l_assignment_number || ' is missing.');
321: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 of the assignment ' || l_assignment_number || ' is missing.');
322: edi_validation_fail := 'Y';
323: ELSIF validate_input(l_address_line2,'ADDRESS') > 0 THEN
324: populate_run_msg(p_assactid,'The Address Line 2 ' || l_address_line2 || ' of the assignment '|| l_assignment_number || ' has invalid characters.');
325: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 ' || l_address_line2 || ' of the assignment '|| l_assignment_number || ' has invalid characters.');

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

321: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 of the assignment ' || l_assignment_number || ' is missing.');
322: edi_validation_fail := 'Y';
323: ELSIF validate_input(l_address_line2,'ADDRESS') > 0 THEN
324: populate_run_msg(p_assactid,'The Address Line 2 ' || l_address_line2 || ' of the assignment '|| l_assignment_number || ' has invalid characters.');
325: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 ' || l_address_line2 || ' of the assignment '|| l_assignment_number || ' has invalid characters.');
326: edi_validation_fail := 'Y';
327: END IF;
328: END IF;
329:

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

329:
330: IF l_address_line3 <> ' ' and l_address_line3 IS NOT NULL THEN
331: IF validate_input(l_address_line3,'ADDRESS') > 0 THEN
332: populate_run_msg(p_assactid,'The Address Line 3 ' || l_address_line3 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
333: fnd_file.put_line (fnd_file.LOG,'The Address Line 3 ' || l_address_line3 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
334: edi_validation_fail := 'Y';
335: END IF;
336: END IF;
337:

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

337:
338: IF l_town_or_city <> ' ' and l_town_or_city IS NOT NULL THEN
339: IF validate_input(l_town_or_city,'ADDRESS') > 0 THEN
340: populate_run_msg(p_assactid,'The Town Or City ' || l_town_or_city || ' of the assignment '|| l_assignment_number || ' has invalid characters.');
341: fnd_file.put_line (fnd_file.LOG,'The Town Or City ' || l_town_or_city ||' of the assignment ' || l_assignment_number || ' has invalid characters.');
342: edi_validation_fail := 'Y';
343: END IF;
344: END IF;
345:

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

345:
346: IF l_country <> ' ' and l_country IS NOT NULL THEN
347: IF validate_input(l_country,'COUNTRY') > 0 THEN
348: populate_run_msg(p_assactid,'The Country ' || l_country || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
349: fnd_file.put_line (fnd_file.LOG,'The Country ' || l_country || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
350: edi_validation_fail := 'Y';
351: END IF;
352: END IF;
353:

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

353:
354: IF l_postal_code <> ' ' and l_postal_code IS NOT NULL THEN
355: IF validate_input(l_postal_code,'POSTALCODE') > 0 THEN
356: populate_run_msg(p_assactid,'The Postal Code ' || l_postal_code || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
357: fnd_file.put_line (fnd_file.LOG,'The Postal Code ' || l_postal_code || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
358: edi_validation_fail := 'Y';
359: END IF;
360: END IF;
361:

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

364:
365: -- Last name is mandatory field
366: IF l_last_name = ' ' OR l_last_name IS NULL THEN
367: populate_run_msg(p_assactid,'The Last Name of the assignment ' || l_assignment_number || ' is missing.');
368: fnd_file.put_line (fnd_file.LOG,'The Last Name of the assignment '|| l_assignment_number || ' is missing.');
369: edi_validation_fail := 'Y';
370: ELSIF validate_input(l_last_name,'NAME') > 0 THEN
371: populate_run_msg(p_assactid,'The Last Name ' || l_last_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
372: fnd_file.put_line (fnd_file.LOG,'The Last Name ' || l_last_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');

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

368: fnd_file.put_line (fnd_file.LOG,'The Last Name of the assignment '|| l_assignment_number || ' is missing.');
369: edi_validation_fail := 'Y';
370: ELSIF validate_input(l_last_name,'NAME') > 0 THEN
371: populate_run_msg(p_assactid,'The Last Name ' || l_last_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
372: fnd_file.put_line (fnd_file.LOG,'The Last Name ' || l_last_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
373: edi_validation_fail := 'Y';
374: END IF;
375:
376: -- First name is mandatory field

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

375:
376: -- First name is mandatory field
377: IF l_first_name = ' ' OR l_first_name IS NULL THEN
378: populate_run_msg(p_assactid,'The First Name of the assignment '|| l_assignment_number || ' is missing.');
379: fnd_file.put_line (fnd_file.LOG,'The First Name of the assignment ' || l_assignment_number || ' is missing.');
380: edi_validation_fail := 'Y';
381: ELSIF validate_input(l_first_name,'NAME') > 0 THEN
382: populate_run_msg(p_assactid,'The First Name ' || l_first_name ||' of the assignment ' || l_assignment_number || ' has invalid characters.');
383: fnd_file.put_line (fnd_file.LOG,'The First Name ' || l_first_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');

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

379: fnd_file.put_line (fnd_file.LOG,'The First Name of the assignment ' || l_assignment_number || ' is missing.');
380: edi_validation_fail := 'Y';
381: ELSIF validate_input(l_first_name,'NAME') > 0 THEN
382: populate_run_msg(p_assactid,'The First Name ' || l_first_name ||' of the assignment ' || l_assignment_number || ' has invalid characters.');
383: fnd_file.put_line (fnd_file.LOG,'The First Name ' || l_first_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
384: edi_validation_fail := 'Y';
385: END IF;
386:
387: -- Middle name = Second First name

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

387: -- Middle name = Second First name
388: IF l_middle_name <> ' ' AND l_middle_name IS NOT NULL THEN
389: IF validate_input(l_middle_name,'NAME') > 0 THEN
390: populate_run_msg(p_assactid,'The Middle Name ' || l_middle_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
391: fnd_file.put_line (fnd_file.LOG,'The Middle Name ' || l_middle_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
392: edi_validation_fail := 'Y';
393: END IF;
394: END IF;
395:

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

396:
397: IF l_title <> ' ' AND l_title is not null THEN
398: IF validate_input(l_title,'TITLE') > 0 THEN
399: populate_run_msg(p_assactid,'The Title ' || l_title || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
400: fnd_file.put_line (fnd_file.LOG,'The Title ' || l_title || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
401: edi_validation_fail := 'Y';
402: END IF;
403: END IF;
404:

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

404:
405: IF l_national_identifier IS NOT NULL AND
406: hr_gb_utility.ni_validate(l_national_identifier,sysdate) <> 0 THEN
407: populate_run_msg(p_assactid,'The National Insurance number ' || l_national_identifier || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
408: fnd_file.put_line (fnd_file.LOG,'The National Insurance number ' || l_national_identifier || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
409: edi_validation_fail := 'Y';
410: END IF;
411:
412: -- Gender is mandatory field

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

411:
412: -- Gender is mandatory field
413: IF ((l_sex <> 'M' AND l_sex <> 'F') OR (l_sex = ' ' OR l_sex IS NULL)) THEN
414: populate_run_msg(p_assactid,'Gender is not specified for the assignment ' || l_assignment_number || '.');
415: fnd_file.put_line (fnd_file.LOG,'Gender is not specified for the assignment ' || l_assignment_number || '.');
416: edi_validation_fail := 'Y';
417: END IF;
418:
419: IF l_passport_no <> ' ' OR l_passport_no IS NOT NULL THEN

Line 422: fnd_file.put_line (fnd_file.LOG,'The Passport Number ' || l_passport_no || ' of the assignment ' || l_assignment_number || ' has invalid characters.');

418:
419: IF l_passport_no <> ' ' OR l_passport_no IS NOT NULL THEN
420: IF validate_input(l_passport_no,'PASSPORT') > 0 THEN
421: populate_run_msg(p_assactid,'The Passport Number ' || l_passport_no || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
422: fnd_file.put_line (fnd_file.LOG,'The Passport Number ' || l_passport_no || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
423: edi_validation_fail := 'Y';
424: END IF;
425: END IF;
426:

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

426:
427: -- Date of Birth is mandatory field
428: IF l_date_of_birth IS NULL THEN
429: populate_run_msg(p_assactid,'The Date of Birth of the assignment ' || l_assignment_number || ' is missing.');
430: fnd_file.put_line (fnd_file.LOG,'The Date of Birth of the assignment '|| l_assignment_number || ' is missing.');
431: edi_validation_fail := 'Y';
432: END IF;
433:
434: IF ((l_date_of_birth > sysdate) OR (l_year1 > 130)) THEN

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

432: END IF;
433:
434: IF ((l_date_of_birth > sysdate) OR (l_year1 > 130)) THEN
435: populate_run_msg(p_assactid,'The Date of Birth of the assignment ' || l_assignment_number || ' is invalid');
436: fnd_file.put_line (fnd_file.LOG,'The Date of Birth of the assignment '|| l_assignment_number || ' is invalid');
437: edi_validation_fail := 'Y';
438: END IF;
439:
440: -- Partner validations

Line 447: fnd_file.put_line (fnd_file.LOG,'Additional Statutory Paternity Pay for assignment ' || l_assignment_number||' is missing, although Partner details are present.');

443: IF l_partner_last_name <> ' ' OR l_partner_last_name IS NOT NULL THEN
444:
445: IF l_aspp IS NULL THEN
446: populate_run_msg(p_assactid, 'Additional Statutory Paternity Pay for assignment ' || l_assignment_number||' is missing, although Partner details are present.');
447: fnd_file.put_line (fnd_file.LOG,'Additional Statutory Paternity Pay for assignment ' || l_assignment_number||' is missing, although Partner details are present.');
448: edi_validation_fail := 'Y';
449: END IF;
450:
451: IF validate_input(l_partner_last_name,'NAME') > 0 THEN

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

449: END IF;
450:
451: IF validate_input(l_partner_last_name,'NAME') > 0 THEN
452: populate_run_msg(p_assactid,'The Partner Last Name ' || l_partner_last_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
453: fnd_file.put_line (fnd_file.LOG,'The Partner Last Name ' || l_partner_last_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
454: edi_validation_fail := 'Y';
455: END IF;
456: END IF;
457:

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

457:
458: -- Partner First name is mandatory field if last name is present
459: IF l_partner_last_name IS NOT NULL AND (l_partner_first_name = ' ' OR l_partner_first_name IS NULL) THEN
460: populate_run_msg(p_assactid,'The Partner First Name of the assignment '|| l_assignment_number || ' is missing.');
461: fnd_file.put_line (fnd_file.LOG,'The Partner First Name of the assignment ' || l_assignment_number || ' is missing.');
462: edi_validation_fail := 'Y';
463: ELSIF validate_input(l_partner_first_name,'NAME') > 0 THEN
464: populate_run_msg(p_assactid,'The Partner First Name ' || l_partner_first_name ||' of the assignment ' || l_assignment_number || ' has invalid characters.');
465: fnd_file.put_line (fnd_file.LOG,'The Partner First Name ' || l_partner_first_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');

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

461: fnd_file.put_line (fnd_file.LOG,'The Partner First Name of the assignment ' || l_assignment_number || ' is missing.');
462: edi_validation_fail := 'Y';
463: ELSIF validate_input(l_partner_first_name,'NAME') > 0 THEN
464: populate_run_msg(p_assactid,'The Partner First Name ' || l_partner_first_name ||' of the assignment ' || l_assignment_number || ' has invalid characters.');
465: fnd_file.put_line (fnd_file.LOG,'The Partner First Name ' || l_partner_first_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
466: edi_validation_fail := 'Y';
467: END IF;
468:
469: -- Middle name = Second First name

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

469: -- Middle name = Second First name
470: IF l_partner_middle_name <> ' ' AND l_partner_middle_name IS NOT NULL THEN
471: IF validate_input(l_partner_middle_name,'NAME') > 0 THEN
472: populate_run_msg(p_assactid,'The Partner First Name ' || l_partner_middle_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
473: fnd_file.put_line (fnd_file.LOG,'The Partner First Name ' || l_partner_middle_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
474: edi_validation_fail := 'Y';
475: END IF;
476: END IF;
477:

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

477:
478: IF l_partner_national_id IS NOT NULL AND
479: hr_gb_utility.ni_validate(l_partner_national_id,sysdate) <> 0 THEN
480: populate_run_msg(p_assactid,'The Partner National Insurance number ' || l_partner_national_id || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
481: fnd_file.put_line (fnd_file.LOG,'The Partner National Insurance number ' || l_partner_national_id || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
482: edi_validation_fail := 'Y';
483: END IF;
484:
485:

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

578: --Address line 1 is mandatory if Start date is not null or nino is null
579: IF l_start_date is not null or l_national_identifier is null then
580: IF l_address_line1 = ' ' OR l_address_line1 IS NULL THEN
581: populate_run_msg(p_assactid,'The Address Line 1 of the assignment ' || l_assignment_number || ' is missing.');
582: fnd_file.put_line (fnd_file.LOG,'The Address Line 1 of the assignment ' || l_assignment_number || ' is missing.');
583: edi_validation_fail := 'Y';
584: ELSIF validate_input(l_address_line1,'ADDRESS') > 0 THEN
585: populate_run_msg(p_assactid,'The Address Line 1 ' || l_address_line1 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
586: fnd_file.put_line (fnd_file.LOG,'The Address Line 1 ' || l_address_line1 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');

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

582: fnd_file.put_line (fnd_file.LOG,'The Address Line 1 of the assignment ' || l_assignment_number || ' is missing.');
583: edi_validation_fail := 'Y';
584: ELSIF validate_input(l_address_line1,'ADDRESS') > 0 THEN
585: populate_run_msg(p_assactid,'The Address Line 1 ' || l_address_line1 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
586: fnd_file.put_line (fnd_file.LOG,'The Address Line 1 ' || l_address_line1 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
587: edi_validation_fail := 'Y';
588: END IF;
589: END IF;
590:

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

591: --Address line 2 is mandatory if Start date is not null
592: IF l_start_date is not null then
593: IF l_address_line2 = ' ' OR l_address_line2 IS NULL THEN
594: populate_run_msg(p_assactid,'The Address Line 2 of the assignment ' || l_assignment_number || ' is missing.');
595: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 of the assignment ' || l_assignment_number || ' is missing.');
596: edi_validation_fail := 'Y';
597: ELSIF validate_input(l_address_line2,'ADDRESS') > 0 THEN
598: populate_run_msg(p_assactid,'The Address Line 2 ' || l_address_line2 || ' of the assignment '|| l_assignment_number || ' has invalid characters.');
599: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 ' || l_address_line2 || ' of the assignment '|| l_assignment_number || ' has invalid characters.');

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

595: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 of the assignment ' || l_assignment_number || ' is missing.');
596: edi_validation_fail := 'Y';
597: ELSIF validate_input(l_address_line2,'ADDRESS') > 0 THEN
598: populate_run_msg(p_assactid,'The Address Line 2 ' || l_address_line2 || ' of the assignment '|| l_assignment_number || ' has invalid characters.');
599: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 ' || l_address_line2 || ' of the assignment '|| l_assignment_number || ' has invalid characters.');
600: edi_validation_fail := 'Y';
601: END IF;
602: END IF;
603:

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

604:
605: IF l_address_line3 <> ' ' and l_address_line3 IS NOT NULL THEN
606: IF validate_input(l_address_line3,'ADDRESS') > 0 THEN
607: populate_run_msg(p_assactid,'The Address Line 3 ' || l_address_line3 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
608: fnd_file.put_line (fnd_file.LOG,'The Address Line 3 ' || l_address_line3 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
609: edi_validation_fail := 'Y';
610: END IF;
611: END IF;
612:

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

612:
613: IF l_town_or_city <> ' ' and l_town_or_city IS NOT NULL THEN
614: IF validate_input(l_town_or_city,'ADDRESS') > 0 THEN
615: populate_run_msg(p_assactid,'The Town Or City ' || l_town_or_city || ' of the assignment '|| l_assignment_number || ' has invalid characters.');
616: fnd_file.put_line (fnd_file.LOG,'The Town Or City ' || l_town_or_city ||' of the assignment ' || l_assignment_number || ' has invalid characters.');
617: edi_validation_fail := 'Y';
618: END IF;
619: END IF;
620:

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

620:
621: IF l_country <> ' ' and l_country IS NOT NULL THEN
622: IF validate_input(l_country,'COUNTRY') > 0 THEN
623: populate_run_msg(p_assactid,'The Country ' || l_country || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
624: fnd_file.put_line (fnd_file.LOG,'The Country ' || l_country || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
625: edi_validation_fail := 'Y';
626: END IF;
627: END IF;
628:

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

628:
629: IF l_postal_code <> ' ' and l_postal_code IS NOT NULL THEN
630: IF validate_input(l_postal_code,'POSTALCODE') > 0 THEN
631: populate_run_msg(p_assactid,'The Postal Code ' || l_postal_code || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
632: fnd_file.put_line (fnd_file.LOG,'The Postal Code ' || l_postal_code || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
633: edi_validation_fail := 'Y';
634: END IF;
635: END IF;
636:

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

639:
640: -- Last name is mandatory field
641: IF l_last_name = ' ' OR l_last_name IS NULL THEN
642: populate_run_msg(p_assactid,'The Last Name of the assignment ' || l_assignment_number || ' is missing.');
643: fnd_file.put_line (fnd_file.LOG,'The Last Name of the assignment '|| l_assignment_number || ' is missing.');
644: edi_validation_fail := 'Y';
645: ELSIF validate_input(l_last_name,'NAME') > 0 THEN
646: populate_run_msg(p_assactid,'The Last Name ' || l_last_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
647: fnd_file.put_line (fnd_file.LOG,'The Last Name ' || l_last_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');

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

643: fnd_file.put_line (fnd_file.LOG,'The Last Name of the assignment '|| l_assignment_number || ' is missing.');
644: edi_validation_fail := 'Y';
645: ELSIF validate_input(l_last_name,'NAME') > 0 THEN
646: populate_run_msg(p_assactid,'The Last Name ' || l_last_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
647: fnd_file.put_line (fnd_file.LOG,'The Last Name ' || l_last_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
648: edi_validation_fail := 'Y';
649: END IF;
650:
651: -- First name is mandatory field

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

650:
651: -- First name is mandatory field
652: IF l_first_name = ' ' OR l_first_name IS NULL THEN
653: populate_run_msg(p_assactid,'The First Name of the assignment '|| l_assignment_number || ' is missing.');
654: fnd_file.put_line (fnd_file.LOG,'The First Name of the assignment ' || l_assignment_number || ' is missing.');
655: edi_validation_fail := 'Y';
656: ELSIF validate_input(l_first_name,'NAME') > 0 THEN
657: populate_run_msg(p_assactid,'The First Name ' || l_first_name ||' of the assignment ' || l_assignment_number || ' has invalid characters.');
658: fnd_file.put_line (fnd_file.LOG,'The First Name ' || l_first_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');

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

654: fnd_file.put_line (fnd_file.LOG,'The First Name of the assignment ' || l_assignment_number || ' is missing.');
655: edi_validation_fail := 'Y';
656: ELSIF validate_input(l_first_name,'NAME') > 0 THEN
657: populate_run_msg(p_assactid,'The First Name ' || l_first_name ||' of the assignment ' || l_assignment_number || ' has invalid characters.');
658: fnd_file.put_line (fnd_file.LOG,'The First Name ' || l_first_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
659: edi_validation_fail := 'Y';
660: END IF;
661:
662: -- Middle name = Second First name

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

662: -- Middle name = Second First name
663: IF l_middle_name <> ' ' AND l_middle_name IS NOT NULL THEN
664: IF validate_input(l_middle_name,'NAME') > 0 THEN
665: populate_run_msg(p_assactid,'The First Name ' || l_middle_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
666: fnd_file.put_line (fnd_file.LOG,'The First Name ' || l_middle_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
667: edi_validation_fail := 'Y';
668: END IF;
669: END IF;
670:

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

671:
672: IF l_title <> ' ' AND l_title is not null THEN
673: IF validate_input(l_title,'TITLE') > 0 THEN
674: populate_run_msg(p_assactid,'The Title ' || l_title || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
675: fnd_file.put_line (fnd_file.LOG,'The Title ' || l_title || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
676: edi_validation_fail := 'Y';
677: END IF;
678: END IF;
679:

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

679:
680: IF l_national_identifier IS NOT NULL AND
681: hr_gb_utility.ni_validate(l_national_identifier,sysdate) <> 0 THEN
682: populate_run_msg(p_assactid,'The National Insurance number ' || l_national_identifier || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
683: fnd_file.put_line (fnd_file.LOG,'The National Insurance number ' || l_national_identifier || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
684: edi_validation_fail := 'Y';
685: END IF;
686:
687: -- Gender is mandatory field

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

686:
687: -- Gender is mandatory field
688: IF ((l_sex <> 'M' AND l_sex <> 'F') OR (l_sex = ' ' OR l_sex IS NULL)) THEN
689: populate_run_msg(p_assactid,'Gender is not specified for the assignment ' || l_assignment_number || '.');
690: fnd_file.put_line (fnd_file.LOG,'Gender is not specified for the assignment ' || l_assignment_number || '.');
691: edi_validation_fail := 'Y';
692: END IF;
693:
694: IF l_passport_no <> ' ' OR l_passport_no IS NOT NULL THEN

Line 697: fnd_file.put_line (fnd_file.LOG,'The Passport Number ' || l_passport_no || ' of the assignment ' || l_assignment_number || ' has invalid characters.');

693:
694: IF l_passport_no <> ' ' OR l_passport_no IS NOT NULL THEN
695: IF validate_input(l_passport_no,'PASSPORT') > 0 THEN
696: populate_run_msg(p_assactid,'The Passport Number ' || l_passport_no || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
697: fnd_file.put_line (fnd_file.LOG,'The Passport Number ' || l_passport_no || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
698: edi_validation_fail := 'Y';
699: END IF;
700: END IF;
701:

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

701:
702: -- Date of Birth is mandatory field
703: IF l_date_of_birth IS NULL THEN
704: populate_run_msg(p_assactid,'The Date of Birth of the assignment ' || l_assignment_number || ' is missing.');
705: fnd_file.put_line (fnd_file.LOG,'The Date of Birth of the assignment '|| l_assignment_number || ' is missing.');
706: edi_validation_fail := 'Y';
707: END IF;
708:
709: IF ((l_date_of_birth > sysdate) OR (l_year1 > 130)) THEN

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

707: END IF;
708:
709: IF ((l_date_of_birth > sysdate) OR (l_year1 > 130)) THEN
710: populate_run_msg(p_assactid,'The Date of Birth of the assignment ' || l_assignment_number || ' is invalid');
711: fnd_file.put_line (fnd_file.LOG,'The Date of Birth of the assignment '|| l_assignment_number || ' is invalid');
712: edi_validation_fail := 'Y';
713: END IF;
714:
715: -- Partner validations

Line 722: fnd_file.put_line (fnd_file.LOG,'Additional Statutory Paternity Pay for assignment ' || l_assignment_number||' is missing, although Partner details are present.');

718: IF l_partner_last_name <> ' ' OR l_partner_last_name IS NOT NULL THEN
719:
720: IF l_aspp IS NULL THEN
721: populate_run_msg(p_assactid, 'Additional Statutory Paternity Pay for assignment ' || l_assignment_number||' is missing, although Partner details are present.');
722: fnd_file.put_line (fnd_file.LOG,'Additional Statutory Paternity Pay for assignment ' || l_assignment_number||' is missing, although Partner details are present.');
723: edi_validation_fail := 'Y';
724: END IF;
725:
726: IF validate_input(l_partner_last_name,'NAME') > 0 THEN

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

724: END IF;
725:
726: IF validate_input(l_partner_last_name,'NAME') > 0 THEN
727: populate_run_msg(p_assactid,'The Partner Last Name ' || l_partner_last_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
728: fnd_file.put_line (fnd_file.LOG,'The Partner Last Name ' || l_partner_last_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
729: edi_validation_fail := 'Y';
730: END IF;
731: END IF;
732:

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

732:
733: -- Partner First name is mandatory field if last name is present
734: IF l_partner_last_name IS NOT NULL AND (l_partner_first_name = ' ' OR l_partner_first_name IS NULL) THEN
735: populate_run_msg(p_assactid,'The Partner First Name of the assignment '|| l_assignment_number || ' is missing.');
736: fnd_file.put_line (fnd_file.LOG,'The Partner First Name of the assignment ' || l_assignment_number || ' is missing.');
737: edi_validation_fail := 'Y';
738: ELSIF validate_input(l_partner_first_name,'NAME') > 0 THEN
739: populate_run_msg(p_assactid,'The Partner First Name ' || l_partner_first_name ||' of the assignment ' || l_assignment_number || ' has invalid characters.');
740: fnd_file.put_line (fnd_file.LOG,'The Partner First Name ' || l_partner_first_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');

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

736: fnd_file.put_line (fnd_file.LOG,'The Partner First Name of the assignment ' || l_assignment_number || ' is missing.');
737: edi_validation_fail := 'Y';
738: ELSIF validate_input(l_partner_first_name,'NAME') > 0 THEN
739: populate_run_msg(p_assactid,'The Partner First Name ' || l_partner_first_name ||' of the assignment ' || l_assignment_number || ' has invalid characters.');
740: fnd_file.put_line (fnd_file.LOG,'The Partner First Name ' || l_partner_first_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
741: edi_validation_fail := 'Y';
742: END IF;
743:
744: -- Middle name = Second First name

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

744: -- Middle name = Second First name
745: IF l_partner_middle_name <> ' ' AND l_partner_middle_name IS NOT NULL THEN
746: IF validate_input(l_partner_middle_name,'NAME') > 0 THEN
747: populate_run_msg(p_assactid,'The Partner First Name ' || l_partner_middle_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
748: fnd_file.put_line (fnd_file.LOG,'The Partner First Name ' || l_partner_middle_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
749: edi_validation_fail := 'Y';
750: END IF;
751: END IF;
752:

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

752:
753: IF l_partner_national_id IS NOT NULL AND
754: hr_gb_utility.ni_validate(l_partner_national_id,sysdate) <> 0 THEN
755: populate_run_msg(p_assactid,'The Partner National Insurance number ' || l_partner_national_id || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
756: fnd_file.put_line (fnd_file.LOG,'The Partner National Insurance number ' || l_partner_national_id || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
757: edi_validation_fail := 'Y';
758: END IF;
759:
760:

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

906:
907: IF l_start_date IS NOT NULL
908: and date_validate(p_assactid,'UK_EMPL_DATE',l_start_date) = 0 THEN
909: populate_run_msg(p_assactid,' The start date of employment for the assignment ' || l_assignment_number || ' is invalid.');
910: fnd_file.put_line (fnd_file.LOG,'The start date of employment for the assignment ' || l_assignment_number || ' is invalid.');
911: edi_validation_fail := 'Y';
912: END IF;
913:
914: IF l_end_date IS NOT NULL

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

913:
914: IF l_end_date IS NOT NULL
915: and date_validate(p_assactid,'UK_EMPL_DATE_LEAVING',l_end_date) = 0 THEN
916: populate_run_msg(p_assactid,' The end date of employment for the assignment ' || l_assignment_number || ' is invalid.');
917: fnd_file.put_line (fnd_file.LOG,'The end date of employment for the assignment ' || l_assignment_number || ' is invalid.');
918: edi_validation_fail := 'Y';
919: END IF;
920:
921: -- Payment Date is mandatory field

Line 924: fnd_file.put_line (fnd_file.LOG,'The Payment Date is missing for assignment ' || l_assignment_number || '.');

920:
921: -- Payment Date is mandatory field
922: IF l_payment_date IS NULL then
923: populate_run_msg(p_assactid, 'The Payment Date is missing for assignment ' || l_assignment_number || '.');
924: fnd_file.put_line (fnd_file.LOG,'The Payment Date is missing for assignment ' || l_assignment_number || '.');
925: edi_validation_fail := 'Y';
926: END IF;
927:
928:

Line 932: fnd_file.put_line (fnd_file.LOG,'The Payment Date ' ||l_payment_date|| ' for assignment ' || l_assignment_number||' is invalid.');

928:
929: IF l_payment_date IS NOT NULL THEN
930: IF l_payment_date < fnd_date.canonical_to_date('2012/04/06 00:00:00') THEN
931: populate_run_msg(p_assactid, 'The Payment Date ' ||l_payment_date|| ' for assignment ' || l_assignment_number||' is invalid.');
932: fnd_file.put_line (fnd_file.LOG,'The Payment Date ' ||l_payment_date|| ' for assignment ' || l_assignment_number||' is invalid.');
933: edi_validation_fail := 'Y';
934: END IF;
935: END IF;
936:

Line 940: fnd_file.put_line (fnd_file.LOG,'The Starter Declaration is missing for assignment ' || l_assignment_number || '.');

936:
937: -- Starter Declaration is mandatory field
938: IF l_start_date IS NOT NULL and (l_starter_declaration = ' ' OR l_starter_declaration IS NULL )then
939: populate_run_msg(p_assactid, 'The Starter Declaration is missing for assignment ' || l_assignment_number || '.');
940: fnd_file.put_line (fnd_file.LOG,'The Starter Declaration is missing for assignment ' || l_assignment_number || '.');
941: edi_validation_fail := 'Y';
942: END IF;
943:
944: IF l_starter_declaration IS NOT NULL THEN

Line 947: fnd_file.put_line (fnd_file.LOG,'The Starter Declaration ' ||l_starter_declaration|| ' for assignment ' || l_assignment_number||' is invalid.');

943:
944: IF l_starter_declaration IS NOT NULL THEN
945: IF l_starter_declaration NOT IN ('A' , 'B' , 'C') THEN
946: populate_run_msg(p_assactid, 'The Starter Declaration ' ||l_starter_declaration|| ' for assignment ' || l_assignment_number||' is invalid.');
947: fnd_file.put_line (fnd_file.LOG,'The Starter Declaration ' ||l_starter_declaration|| ' for assignment ' || l_assignment_number||' is invalid.');
948: edi_validation_fail := 'Y';
949: END IF;
950: END IF;
951:

Line 957: fnd_file.put_line (fnd_file.LOG,'Stay in UK over six months for assignment ' || l_assignment_number||' is invalid.');

953: -- l_stay_over_six_months , l_stay_less_six_months , l_living_abroad
954:
955: IF l_stay_over_six_months = 'Y' AND (l_stay_less_six_months = 'Y' OR l_living_abroad = 'Y') THEN
956: populate_run_msg(p_assactid, 'Stay in UK over six months for assignment ' || l_assignment_number||' is invalid.');
957: fnd_file.put_line (fnd_file.LOG,'Stay in UK over six months for assignment ' || l_assignment_number||' is invalid.');
958: edi_validation_fail := 'Y';
959: END IF;
960:
961: IF l_stay_less_six_months = 'Y' AND (l_stay_over_six_months = 'Y' OR l_living_abroad = 'Y') THEN

Line 963: fnd_file.put_line (fnd_file.LOG,'Stay in UK less than six months for assignment ' || l_assignment_number||' is invalid.');

959: END IF;
960:
961: IF l_stay_less_six_months = 'Y' AND (l_stay_over_six_months = 'Y' OR l_living_abroad = 'Y') THEN
962: populate_run_msg(p_assactid, 'Stay in UK less than six months for assignment ' || l_assignment_number||' is invalid.');
963: fnd_file.put_line (fnd_file.LOG,'Stay in UK less than six months for assignment ' || l_assignment_number||' is invalid.');
964: edi_validation_fail := 'Y';
965: END IF;
966:
967: IF l_living_abroad = 'Y' AND (l_stay_less_six_months = 'Y' OR l_stay_over_six_months = 'Y') THEN

Line 969: fnd_file.put_line (fnd_file.LOG,'Working in/out of UK but living abroad for assignment ' || l_assignment_number||' is invalid.');

965: END IF;
966:
967: IF l_living_abroad = 'Y' AND (l_stay_less_six_months = 'Y' OR l_stay_over_six_months = 'Y') THEN
968: populate_run_msg(p_assactid, 'Working in/out of UK but living abroad for assignment ' || l_assignment_number||' is invalid.');
969: fnd_file.put_line (fnd_file.LOG,'Working in/out of UK but living abroad for assignment ' || l_assignment_number||' is invalid.');
970: edi_validation_fail := 'Y';
971: END IF;
972:
973:

Line 976: fnd_file.put_line (fnd_file.LOG,'The Annual amount of Occupational Pension for assignment ' || l_assignment_number||' is missing, although Occupational Pension Indicator is present.');

972:
973:
974: IF l_occ_pension_indicator = 'Y' AND l_annual_occupational_pension IS NULL THEN
975: populate_run_msg(p_assactid, 'The Annual amount of Occupational Pension for assignment ' || l_assignment_number||' is missing, although Occupational Pension Indicator is present.');
976: fnd_file.put_line (fnd_file.LOG,'The Annual amount of Occupational Pension for assignment ' || l_assignment_number||' is missing, although Occupational Pension Indicator is present.');
977: edi_validation_fail := 'Y';
978: END IF;
979:
980:

Line 984: fnd_file.put_line (fnd_file.LOG,'The Annual amount of Occupational Pension ' ||l_annual_occupational_pension|| ' for assignment ' || l_assignment_number||' must be greater than zero.');

980:
981: IF l_annual_occupational_pension IS NOT NULL THEN
982: IF l_annual_occupational_pension < 0 THEN
983: populate_run_msg(p_assactid, 'The Annual amount of Occupational Pension ' ||l_annual_occupational_pension|| ' for assignment ' || l_assignment_number||' must be greater than zero.');
984: fnd_file.put_line (fnd_file.LOG,'The Annual amount of Occupational Pension ' ||l_annual_occupational_pension|| ' for assignment ' || l_assignment_number||' must be greater than zero.');
985: edi_validation_fail := 'Y';
986: ELSIF l_annual_occupational_pension > 999999999.99 THEN
987: populate_run_msg(p_assactid, 'The Annual amount of Occupational Pension ' ||l_annual_occupational_pension|| ' exceeds 999999999.99 for assignment ' || l_assignment_number||' must be greater than zero.');
988: fnd_file.put_line (fnd_file.LOG,'The Annual amount of Occupational Pension ' ||l_annual_occupational_pension|| ' exceeds 999999999.99 for assignment ' || l_assignment_number||' must be greater than zero.');

Line 988: fnd_file.put_line (fnd_file.LOG,'The Annual amount of Occupational Pension ' ||l_annual_occupational_pension|| ' exceeds 999999999.99 for assignment ' || l_assignment_number||' must be greater than zero.');

984: fnd_file.put_line (fnd_file.LOG,'The Annual amount of Occupational Pension ' ||l_annual_occupational_pension|| ' for assignment ' || l_assignment_number||' must be greater than zero.');
985: edi_validation_fail := 'Y';
986: ELSIF l_annual_occupational_pension > 999999999.99 THEN
987: populate_run_msg(p_assactid, 'The Annual amount of Occupational Pension ' ||l_annual_occupational_pension|| ' exceeds 999999999.99 for assignment ' || l_assignment_number||' must be greater than zero.');
988: fnd_file.put_line (fnd_file.LOG,'The Annual amount of Occupational Pension ' ||l_annual_occupational_pension|| ' exceeds 999999999.99 for assignment ' || l_assignment_number||' must be greater than zero.');
989: edi_validation_fail := 'Y';
990: END IF;
991: END IF;
992:

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

992:
993: IF ((l_payroll_id <> ' ' and l_payroll_id IS NOT NULL)
994: and validate_input(l_payroll_id,'PAYROLLID') > 0) THEN
995: populate_run_msg(p_assactid,' Payroll ID has invalid characters for the assignment ' || l_assignment_number || '.');
996: fnd_file.put_line (fnd_file.LOG,'Payroll ID has invalid characters for the assignment ' || l_assignment_number || '.');
997: edi_validation_fail := 'Y';
998: END IF;
999:
1000: IF ((l_old_payroll_id <> ' ' and l_old_payroll_id IS NOT NULL)

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

999:
1000: IF ((l_old_payroll_id <> ' ' and l_old_payroll_id IS NOT NULL)
1001: and validate_input(l_old_payroll_id,'PAYROLLID') > 0) THEN
1002: populate_run_msg(p_assactid,' Old Payroll id has invalid characters for the assignment ' || l_assignment_number || '.');
1003: fnd_file.put_line (fnd_file.LOG,'Old Payroll id has invalid characters for the assignment ' || l_assignment_number || '.');
1004: edi_validation_fail := 'Y';
1005: END IF;
1006:
1007:

Line 1011: fnd_file.put_line (fnd_file.LOG,'The Pay frequency is missing for assignment ' || l_assignment_number || '.');

1007:
1008: -- Pay Frequency is mandatory field
1009: IF l_pay_frequency IS NULL OR l_pay_frequency = ' ' then
1010: populate_run_msg(p_assactid, 'The Pay frequency is missing for assignment ' || l_assignment_number || '.');
1011: fnd_file.put_line (fnd_file.LOG,'The Pay frequency is missing for assignment ' || l_assignment_number || '.');
1012: edi_validation_fail := 'Y';
1013: END IF;
1014:
1015:

Line 1019: fnd_file.put_line (fnd_file.LOG,'The Pay frequency for assignment ' || l_assignment_number|| ' is invalid.');

1015:
1016: IF (l_pay_frequency IS NOT NULL OR l_pay_frequency <> ' ') AND
1017: l_pay_frequency NOT IN ('W1','W2','W4','M1','M3','M6','MA','IO','IR') THEN
1018: populate_run_msg(p_assactid, 'The Pay frequency for assignment ' || l_assignment_number|| ' is invalid.' );
1019: fnd_file.put_line (fnd_file.LOG,'The Pay frequency for assignment ' || l_assignment_number|| ' is invalid.');
1020: edi_validation_fail := 'Y';
1021: END IF;
1022:
1023: -- Atleast one should be present

Line 1026: fnd_file.put_line (fnd_file.LOG,'Either Payment Week Number or Payment Month Number must be present for assignment ' || l_assignment_number || '.');

1022:
1023: -- Atleast one should be present
1024: IF l_payment_week_number IS NULL AND l_payment_month_number IS NULL THEN
1025: populate_run_msg(p_assactid, 'Either Payment Week Number or Payment Month Number must be present for assignment ' || l_assignment_number || '.');
1026: fnd_file.put_line (fnd_file.LOG,'Either Payment Week Number or Payment Month Number must be present for assignment ' || l_assignment_number || '.');
1027: edi_validation_fail := 'Y';
1028: END IF;
1029:
1030: IF l_payment_week_number IS NOT NULL AND

Line 1033: fnd_file.put_line (fnd_file.LOG,'The Payment Week Number for assignment ' || l_assignment_number|| ' is invalid.');

1029:
1030: IF l_payment_week_number IS NOT NULL AND
1031: ((l_payment_week_number < 1 OR l_payment_week_number > 54) AND l_payment_week_number <> 56) THEN
1032: populate_run_msg(p_assactid, 'The Payment Week Number for assignment ' || l_assignment_number|| ' is invalid.' );
1033: fnd_file.put_line (fnd_file.LOG,'The Payment Week Number for assignment ' || l_assignment_number|| ' is invalid.');
1034: edi_validation_fail := 'Y';
1035: END IF;
1036:
1037: IF l_payment_month_number IS NOT NULL AND

Line 1040: fnd_file.put_line (fnd_file.LOG,'The Payment Month Number for assignment ' || l_assignment_number|| ' is invalid.');

1036:
1037: IF l_payment_month_number IS NOT NULL AND
1038: (l_payment_month_number < 1 OR l_payment_month_number > 12) THEN
1039: populate_run_msg(p_assactid, 'The Payment Month Number for assignment ' || l_assignment_number|| ' is invalid.' );
1040: fnd_file.put_line (fnd_file.LOG,'The Payment Month Number for assignment ' || l_assignment_number|| ' is invalid.');
1041: edi_validation_fail := 'Y';
1042: END IF;
1043:
1044: -- Number of Earnings periods covered by payment is mandatory field

Line 1047: fnd_file.put_line (fnd_file.LOG,'The Number of Earnings Periods covered by Payment is missing for assignment ' || l_assignment_number || '.');

1043:
1044: -- Number of Earnings periods covered by payment is mandatory field
1045: IF l_no_of_earnings IS NULL THEN
1046: populate_run_msg(p_assactid, 'The Number of Earnings Periods covered by Payment is missing for assignment ' || l_assignment_number || '.');
1047: fnd_file.put_line (fnd_file.LOG,'The Number of Earnings Periods covered by Payment is missing for assignment ' || l_assignment_number || '.');
1048: edi_validation_fail := 'Y';
1049: END IF;
1050:
1051: IF l_payment_after_leaving = 'Y' AND

Line 1054: fnd_file.put_line (fnd_file.LOG,'The Date of Leaving is missing for assignment ' || l_assignment_number|| ',although Payment after leaving indicator is present.');

1050:
1051: IF l_payment_after_leaving = 'Y' AND
1052: l_end_date = fnd_date.canonical_to_date('4712/12/31') THEN
1053: populate_run_msg(p_assactid, 'The Date of Leaving is missing for assignment ' || l_assignment_number|| ',although Payment after leaving indicator is present.');
1054: fnd_file.put_line (fnd_file.LOG,'The Date of Leaving is missing for assignment ' || l_assignment_number|| ',although Payment after leaving indicator is present.');
1055: edi_validation_fail := 'Y';
1056: END IF;
1057:
1058: -- No of normal hours worked is mandatory field

Line 1062: fnd_file.put_line (fnd_file.LOG,'The Number of normal hours worked is missing for assignment ' || l_assignment_number || '.');

1058: -- No of normal hours worked is mandatory field
1059:
1060: IF l_no_of_hours_worked IS NULL THEN
1061: populate_run_msg(p_assactid, 'The Number of normal hours worked is missing for assignment ' || l_assignment_number || '.');
1062: fnd_file.put_line (fnd_file.LOG,'The Number of normal hours worked is missing for assignment ' || l_assignment_number || '.');
1063: edi_validation_fail := 'Y';
1064: END IF;
1065:
1066:

Line 1070: fnd_file.put_line (fnd_file.LOG,'The Week Number of Director appointment for assignment ' || l_assignment_number|| ' is invalid.');

1066:
1067: IF l_week_director_app IS NOT NULL AND
1068: ((l_week_director_app < 1 OR l_week_director_app > 54) AND l_week_director_app <> 56) THEN
1069: populate_run_msg(p_assactid, 'The Week Number of Director appointment for assignment ' || l_assignment_number|| ' is invalid.' );
1070: fnd_file.put_line (fnd_file.LOG,'The Week Number of Director appointment for assignment ' || l_assignment_number|| ' is invalid.');
1071: edi_validation_fail := 'Y';
1072: END IF;
1073:
1074: IF l_director_nic_method IS NOT NULL AND

Line 1077: fnd_file.put_line (fnd_file.LOG,'The Director NIC calculation method for assignment ' || l_assignment_number|| ' is invalid.');

1073:
1074: IF l_director_nic_method IS NOT NULL AND
1075: l_director_nic_method NOT IN ('AN' , 'AL') THEN
1076: populate_run_msg(p_assactid, 'The Director NIC calculation method for assignment ' || l_assignment_number|| ' is invalid.' );
1077: fnd_file.put_line (fnd_file.LOG,'The Director NIC calculation method for assignment ' || l_assignment_number|| ' is invalid.');
1078: edi_validation_fail := 'Y';
1079: END IF;
1080:
1081: IF l_week_director_app IS NOT NULL AND

Line 1084: fnd_file.put_line (fnd_file.LOG,'The Director NIC calculation method is mission for assignment ' || l_assignment_number||' although Tax week number is present.');

1080:
1081: IF l_week_director_app IS NOT NULL AND
1082: l_director_nic_method IS NULL THEN
1083: populate_run_msg(p_assactid, 'The Director NIC calculation method is missing for assignment ' || l_assignment_number||' although Tax week number is present.');
1084: fnd_file.put_line (fnd_file.LOG,'The Director NIC calculation method is mission for assignment ' || l_assignment_number||' although Tax week number is present.');
1085: edi_validation_fail := 'Y';
1086: END IF;
1087:
1088: -- Taxable Pay to Date is mandatory field

Line 1091: fnd_file.put_line (fnd_file.LOG,'The Taxable Pay to Date is missing for assignment ' || l_assignment_number || '.');

1087:
1088: -- Taxable Pay to Date is mandatory field
1089: IF l_taxable_pay_to_date IS NULL THEN
1090: populate_run_msg(p_assactid, 'The Taxable Pay to Date is missing for assignment ' || l_assignment_number || '.');
1091: fnd_file.put_line (fnd_file.LOG,'The Taxable Pay to Date is missing for assignment ' || l_assignment_number || '.');
1092: edi_validation_fail := 'Y';
1093: END IF;
1094:
1095: IF l_taxable_pay_to_date IS NOT NULL AND l_taxable_pay_to_date < 0 THEN

Line 1097: fnd_file.put_line (fnd_file.LOG,'The Taxable Pay to Date for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');

1093: END IF;
1094:
1095: IF l_taxable_pay_to_date IS NOT NULL AND l_taxable_pay_to_date < 0 THEN
1096: populate_run_msg(p_assactid, 'The Taxable Pay to Date for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.' );
1097: fnd_file.put_line (fnd_file.LOG,'The Taxable Pay to Date for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1098: edi_validation_fail := 'Y';
1099: END IF;
1100:
1101: -- Total Tax to Date is mandatory field

Line 1104: fnd_file.put_line (fnd_file.LOG,'The Total Tax to Date is missing for assignment ' || l_assignment_number || '.');

1100:
1101: -- Total Tax to Date is mandatory field
1102: IF l_total_tax IS NULL THEN
1103: populate_run_msg(p_assactid, 'The Total Tax to Date is missing for assignment ' || l_assignment_number || '.');
1104: fnd_file.put_line (fnd_file.LOG,'The Total Tax to Date is missing for assignment ' || l_assignment_number || '.');
1105: edi_validation_fail := 'Y';
1106: END IF;
1107:
1108: IF l_total_tax IS NOT NULL AND abs(l_total_tax) > 99999999999 THEN

Line 1110: fnd_file.put_line (fnd_file.LOG,'The Total Tax to Date exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1106: END IF;
1107:
1108: IF l_total_tax IS NOT NULL AND abs(l_total_tax) > 99999999999 THEN
1109: populate_run_msg(p_assactid, 'The Total Tax to Date exceeds 999999999.99 for assignment ' || l_assignment_number|| '.' );
1110: fnd_file.put_line (fnd_file.LOG,'The Total Tax to Date exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1111: edi_validation_fail := 'Y';
1112: END IF;
1113:
1114: IF l_student_loan_repayment IS NOT NULL AND l_student_loan_repayment < 0 THEN

Line 1116: fnd_file.put_line (fnd_file.LOG,'The Total Student loan repayment recovered to date for assignment ' || l_assignment_number|| ' must be greater than or equal to zero..');

1112: END IF;
1113:
1114: IF l_student_loan_repayment IS NOT NULL AND l_student_loan_repayment < 0 THEN
1115: populate_run_msg(p_assactid, 'The Total Student loan repayment recovered to date for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.' );
1116: fnd_file.put_line (fnd_file.LOG,'The Total Student loan repayment recovered to date for assignment ' || l_assignment_number|| ' must be greater than or equal to zero..');
1117: edi_validation_fail := 'Y';
1118: ELSIF l_student_loan_repayment IS NOT NULL AND l_student_loan_repayment > 9999900 THEN
1119: populate_run_msg(p_assactid, 'The Total Student loan repayment recovered to date exceeds 99999.00 for assignment ' || l_assignment_number|| '.' );
1120: fnd_file.put_line (fnd_file.LOG,'The Total Student loan repayment recovered to date exceeds 99999.00 for assignment ' || l_assignment_number|| '.');

Line 1120: fnd_file.put_line (fnd_file.LOG,'The Total Student loan repayment recovered to date exceeds 99999.00 for assignment ' || l_assignment_number|| '.');

1116: fnd_file.put_line (fnd_file.LOG,'The Total Student loan repayment recovered to date for assignment ' || l_assignment_number|| ' must be greater than or equal to zero..');
1117: edi_validation_fail := 'Y';
1118: ELSIF l_student_loan_repayment IS NOT NULL AND l_student_loan_repayment > 9999900 THEN
1119: populate_run_msg(p_assactid, 'The Total Student loan repayment recovered to date exceeds 99999.00 for assignment ' || l_assignment_number|| '.' );
1120: fnd_file.put_line (fnd_file.LOG,'The Total Student loan repayment recovered to date exceeds 99999.00 for assignment ' || l_assignment_number|| '.');
1121: edi_validation_fail := 'Y';
1122: END IF;
1123:
1124: ---- > 0

Line 1127: fnd_file.put_line (fnd_file.LOG,'Taxable pay '||l_taxable_pay||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1123:
1124: ---- > 0
1125: IF l_taxable_pay IS NOT NULL AND abs(l_taxable_pay) > 99999999999 THEN
1126: populate_run_msg(p_assactid, 'Taxable pay '||l_taxable_pay||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1127: fnd_file.put_line (fnd_file.LOG,'Taxable pay '||l_taxable_pay||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1128: edi_validation_fail := 'Y';
1129: END IF;
1130:
1131: IF l_non_tax_nic_payment IS NOT NULL AND abs(l_non_tax_nic_payment) > 99999999999 THEN

Line 1133: fnd_file.put_line (fnd_file.LOG,'Non Tax or NIC Payment '||l_non_tax_nic_payment||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1129: END IF;
1130:
1131: IF l_non_tax_nic_payment IS NOT NULL AND abs(l_non_tax_nic_payment) > 99999999999 THEN
1132: populate_run_msg(p_assactid, 'Non Tax or NIC Payment '||l_non_tax_nic_payment||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1133: fnd_file.put_line (fnd_file.LOG,'Non Tax or NIC Payment '||l_non_tax_nic_payment||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1134: edi_validation_fail := 'Y';
1135: END IF;
1136:
1137: IF l_net_pay_deductions IS NOT NULL AND abs(l_net_pay_deductions) > 99999999999 THEN

Line 1139: fnd_file.put_line (fnd_file.LOG,'Deductions from Net pay '||l_net_pay_deductions||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1135: END IF;
1136:
1137: IF l_net_pay_deductions IS NOT NULL AND abs(l_net_pay_deductions) > 99999999999 THEN
1138: populate_run_msg(p_assactid, 'Deductions from Net pay '||l_net_pay_deductions||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1139: fnd_file.put_line (fnd_file.LOG,'Deductions from Net pay '||l_net_pay_deductions||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1140: edi_validation_fail := 'Y';
1141: END IF;
1142:
1143: IF l_pay_after_statutory IS NOT NULL AND abs(l_pay_after_statutory) > 99999999999 THEN

Line 1145: fnd_file.put_line (fnd_file.LOG,'Pay after Statutory deductions '||l_pay_after_statutory||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1141: END IF;
1142:
1143: IF l_pay_after_statutory IS NOT NULL AND abs(l_pay_after_statutory) > 99999999999 THEN
1144: populate_run_msg(p_assactid, 'Pay after Statutory deductions '||l_pay_after_statutory||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1145: fnd_file.put_line (fnd_file.LOG,'Pay after Statutory deductions '||l_pay_after_statutory||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1146: edi_validation_fail := 'Y';
1147: END IF;
1148:
1149: IF l_benefits_taxed_payroll IS NOT NULL AND abs(l_benefits_taxed_payroll) > 99999999999 THEN

Line 1151: fnd_file.put_line (fnd_file.LOG,'Benefits Taxed via Payroll '||l_benefits_taxed_payroll||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1147: END IF;
1148:
1149: IF l_benefits_taxed_payroll IS NOT NULL AND abs(l_benefits_taxed_payroll) > 99999999999 THEN
1150: populate_run_msg(p_assactid, 'Benefits Taxed via Payroll '||l_benefits_taxed_payroll||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1151: fnd_file.put_line (fnd_file.LOG,'Benefits Taxed via Payroll '||l_benefits_taxed_payroll||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1152: edi_validation_fail := 'Y';
1153: END IF;
1154:
1155: IF l_benefits_class1_nic IS NOT NULL AND abs(l_benefits_class1_nic) > 99999999999 THEN

Line 1157: fnd_file.put_line (fnd_file.LOG,'Benefits Subject to Class1 NIC '||l_benefits_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1153: END IF;
1154:
1155: IF l_benefits_class1_nic IS NOT NULL AND abs(l_benefits_class1_nic) > 99999999999 THEN
1156: populate_run_msg(p_assactid, 'Benefits Subject to Class1 NIC '||l_benefits_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1157: fnd_file.put_line (fnd_file.LOG,'Benefits Subject to Class1 NIC '||l_benefits_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1158: edi_validation_fail := 'Y';
1159: END IF;
1160:
1161: IF l_benefits_n_class1_nic IS NOT NULL AND abs(l_benefits_n_class1_nic) > 99999999999 THEN

Line 1163: fnd_file.put_line (fnd_file.LOG,'Benefits not subject to Class1 NIC '||l_benefits_n_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1159: END IF;
1160:
1161: IF l_benefits_n_class1_nic IS NOT NULL AND abs(l_benefits_n_class1_nic) > 99999999999 THEN
1162: populate_run_msg(p_assactid, 'Benefits not subject to Class1 NIC '||l_benefits_n_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1163: fnd_file.put_line (fnd_file.LOG,'Benefits not subject to Class1 NIC '||l_benefits_n_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1164: edi_validation_fail := 'Y';
1165: END IF;
1166:
1167: IF l_employee_pension_contri IS NOT NULL AND abs(l_employee_pension_contri) > 99999999999 THEN

Line 1169: fnd_file.put_line (fnd_file.LOG,'Employee Pension contributions '||l_benefits_n_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1165: END IF;
1166:
1167: IF l_employee_pension_contri IS NOT NULL AND abs(l_employee_pension_contri) > 99999999999 THEN
1168: populate_run_msg(p_assactid, 'Employee Pension contributions '||l_benefits_n_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1169: fnd_file.put_line (fnd_file.LOG,'Employee Pension contributions '||l_benefits_n_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1170: edi_validation_fail := 'Y';
1171: END IF;
1172:
1173: IF l_items_class1_nic IS NOT NULL AND abs(l_items_class1_nic) > 99999999999 THEN

Line 1175: fnd_file.put_line (fnd_file.LOG,'Items subject to Class1 NIC '||l_items_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1171: END IF;
1172:
1173: IF l_items_class1_nic IS NOT NULL AND abs(l_items_class1_nic) > 99999999999 THEN
1174: populate_run_msg(p_assactid, 'Items subject to Class1 NIC '||l_items_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1175: fnd_file.put_line (fnd_file.LOG,'Items subject to Class1 NIC '||l_items_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1176: edi_validation_fail := 'Y';
1177: END IF;
1178:
1179: IF l_emp_contri_not_paid IS NOT NULL AND abs(l_emp_contri_not_paid) > 99999999999 THEN

Line 1181: fnd_file.put_line (fnd_file.LOG,'Employee contributions not paid '||l_emp_contri_not_paid||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1177: END IF;
1178:
1179: IF l_emp_contri_not_paid IS NOT NULL AND abs(l_emp_contri_not_paid) > 99999999999 THEN
1180: populate_run_msg(p_assactid, 'Employee contributions not paid '||l_emp_contri_not_paid||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1181: fnd_file.put_line (fnd_file.LOG,'Employee contributions not paid '||l_emp_contri_not_paid||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1182: edi_validation_fail := 'Y';
1183: END IF;
1184:
1185: IF l_student_loan_repay IS NOT NULL AND abs(l_student_loan_repay) > 9999900 THEN

Line 1187: fnd_file.put_line (fnd_file.LOG,'Student Loan Repayment recovered '||l_student_loan_repay||' exceeds 99999.00 for assignment ' || l_assignment_number|| '.');

1183: END IF;
1184:
1185: IF l_student_loan_repay IS NOT NULL AND abs(l_student_loan_repay) > 9999900 THEN
1186: populate_run_msg(p_assactid, 'Student Loan Repayment recovered '||l_student_loan_repay||' exceeds 99999.00 for assignment ' || l_assignment_number|| '.');
1187: fnd_file.put_line (fnd_file.LOG,'Student Loan Repayment recovered '||l_student_loan_repay||' exceeds 99999.00 for assignment ' || l_assignment_number|| '.');
1188: edi_validation_fail := 'Y';
1189: END IF;
1190:
1191: -- Tax Deducted or Refunded is mandatory field

Line 1194: fnd_file.put_line (fnd_file.LOG,'Tax deducted or refunded is missing for assignment ' || l_assignment_number || '.');

1190:
1191: -- Tax Deducted or Refunded is mandatory field
1192: IF l_tax_deducted_refunded IS NULL THEN
1193: populate_run_msg(p_assactid, 'Tax deducted or refunded is missing for assignment ' || l_assignment_number || '.');
1194: fnd_file.put_line (fnd_file.LOG,'Tax deducted or refunded is missing for assignment ' || l_assignment_number || '.');
1195: edi_validation_fail := 'Y';
1196: END IF;
1197:
1198: IF l_tax_deducted_refunded IS NOT NULL AND abs(l_tax_deducted_refunded) > 999999999999 THEN

Line 1200: fnd_file.put_line (fnd_file.LOG,'Tax Deducted or Refunded '||l_student_loan_repay||' exceeds 9999999999.99 for assignment ' || l_assignment_number|| '.');

1196: END IF;
1197:
1198: IF l_tax_deducted_refunded IS NOT NULL AND abs(l_tax_deducted_refunded) > 999999999999 THEN
1199: populate_run_msg(p_assactid, 'Tax Deducted or Refunded '||l_student_loan_repay||' exceeds 9999999999.99 for assignment ' || l_assignment_number|| '.');
1200: fnd_file.put_line (fnd_file.LOG,'Tax Deducted or Refunded '||l_student_loan_repay||' exceeds 9999999999.99 for assignment ' || l_assignment_number|| '.');
1201: edi_validation_fail := 'Y';
1202: END IF;
1203:
1204: IF l_ssp IS NOT NULL AND l_ssp < 0 THEN

Line 1206: fnd_file.put_line (fnd_file.LOG,'Statutory Sick Pay '||l_ssp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');

1202: END IF;
1203:
1204: IF l_ssp IS NOT NULL AND l_ssp < 0 THEN
1205: populate_run_msg(p_assactid, 'Statutory Sick Pay '||l_ssp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1206: fnd_file.put_line (fnd_file.LOG,'Statutory Sick Pay '||l_ssp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1207: edi_validation_fail := 'Y';
1208: ELSIF l_ssp IS NOT NULL AND l_ssp > 999999 THEN
1209: populate_run_msg(p_assactid, 'Statutory Sick Pay '||l_ssp||' exceeds 9999.99 for assignment ' || l_assignment_number|| '.');
1210: fnd_file.put_line (fnd_file.LOG,'Statutory Sick Pay '||l_ssp||' exceeds 9999.99 for assignment ' || l_assignment_number|| '.');

Line 1210: fnd_file.put_line (fnd_file.LOG,'Statutory Sick Pay '||l_ssp||' exceeds 9999.99 for assignment ' || l_assignment_number|| '.');

1206: fnd_file.put_line (fnd_file.LOG,'Statutory Sick Pay '||l_ssp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1207: edi_validation_fail := 'Y';
1208: ELSIF l_ssp IS NOT NULL AND l_ssp > 999999 THEN
1209: populate_run_msg(p_assactid, 'Statutory Sick Pay '||l_ssp||' exceeds 9999.99 for assignment ' || l_assignment_number|| '.');
1210: fnd_file.put_line (fnd_file.LOG,'Statutory Sick Pay '||l_ssp||' exceeds 9999.99 for assignment ' || l_assignment_number|| '.');
1211: edi_validation_fail := 'Y';
1212: END IF;
1213:
1214: IF l_smp IS NOT NULL AND l_smp < 0 THEN

Line 1216: fnd_file.put_line (fnd_file.LOG,'Statutory Maternity Pay '||l_smp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');

1212: END IF;
1213:
1214: IF l_smp IS NOT NULL AND l_smp < 0 THEN
1215: populate_run_msg(p_assactid, 'Statutory Maternity Pay '||l_smp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1216: fnd_file.put_line (fnd_file.LOG,'Statutory Maternity Pay '||l_smp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1217: edi_validation_fail := 'Y';
1218: ELSIF l_smp IS NOT NULL AND l_smp > 99999999 THEN
1219: populate_run_msg(p_assactid, 'Statutory Maternity Pay '||l_smp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1220: fnd_file.put_line (fnd_file.LOG,'Statutory Maternity Pay '||l_smp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');

Line 1220: fnd_file.put_line (fnd_file.LOG,'Statutory Maternity Pay '||l_smp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');

1216: fnd_file.put_line (fnd_file.LOG,'Statutory Maternity Pay '||l_smp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1217: edi_validation_fail := 'Y';
1218: ELSIF l_smp IS NOT NULL AND l_smp > 99999999 THEN
1219: populate_run_msg(p_assactid, 'Statutory Maternity Pay '||l_smp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1220: fnd_file.put_line (fnd_file.LOG,'Statutory Maternity Pay '||l_smp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1221: edi_validation_fail := 'Y';
1222: END IF;
1223:
1224: IF l_smp > 0 AND l_gender <> 'F' THEN

Line 1226: fnd_file.put_line (fnd_file.LOG,'Gender must be female for assignment ' || l_assignment_number|| ' to claim Statutory Maternity Pay.');

1222: END IF;
1223:
1224: IF l_smp > 0 AND l_gender <> 'F' THEN
1225: populate_run_msg(p_assactid, 'Gender must be female for assignment ' || l_assignment_number|| ' to claim Statutory Maternity Pay.');
1226: fnd_file.put_line (fnd_file.LOG,'Gender must be female for assignment ' || l_assignment_number|| ' to claim Statutory Maternity Pay.');
1227: edi_validation_fail := 'Y';
1228: END IF;
1229:
1230: IF l_ospp IS NOT NULL AND l_ospp < 0 THEN

Line 1232: fnd_file.put_line (fnd_file.LOG,'Ordinary Statutory Paternity Pay '||l_ospp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');

1228: END IF;
1229:
1230: IF l_ospp IS NOT NULL AND l_ospp < 0 THEN
1231: populate_run_msg(p_assactid, 'Ordinary Statutory Paternity Pay '||l_ospp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1232: fnd_file.put_line (fnd_file.LOG,'Ordinary Statutory Paternity Pay '||l_ospp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1233: edi_validation_fail := 'Y';
1234: ELSIF l_ospp IS NOT NULL AND l_ospp > 99999999 THEN
1235: populate_run_msg(p_assactid, 'Ordinary Statutory Paternity Pay '||l_ospp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1236: fnd_file.put_line (fnd_file.LOG,'Ordinary Statutory Paternity Pay '||l_ospp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');

Line 1236: fnd_file.put_line (fnd_file.LOG,'Ordinary Statutory Paternity Pay '||l_ospp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');

1232: fnd_file.put_line (fnd_file.LOG,'Ordinary Statutory Paternity Pay '||l_ospp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1233: edi_validation_fail := 'Y';
1234: ELSIF l_ospp IS NOT NULL AND l_ospp > 99999999 THEN
1235: populate_run_msg(p_assactid, 'Ordinary Statutory Paternity Pay '||l_ospp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1236: fnd_file.put_line (fnd_file.LOG,'Ordinary Statutory Paternity Pay '||l_ospp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1237: edi_validation_fail := 'Y';
1238: END IF;
1239:
1240: IF l_sap IS NOT NULL AND l_sap < 0 THEN

Line 1242: fnd_file.put_line (fnd_file.LOG,'Statutory Adoption Pay '||l_sap||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');

1238: END IF;
1239:
1240: IF l_sap IS NOT NULL AND l_sap < 0 THEN
1241: populate_run_msg(p_assactid, 'Statutory Adoption Pay '||l_sap||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1242: fnd_file.put_line (fnd_file.LOG,'Statutory Adoption Pay '||l_sap||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1243: edi_validation_fail := 'Y';
1244: ELSIF l_sap IS NOT NULL AND l_sap > 99999999 THEN
1245: populate_run_msg(p_assactid, 'Statutory Adoption Pay '||l_sap||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1246: fnd_file.put_line (fnd_file.LOG,'Statutory Adoption Pay '||l_sap||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');

Line 1246: fnd_file.put_line (fnd_file.LOG,'Statutory Adoption Pay '||l_sap||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');

1242: fnd_file.put_line (fnd_file.LOG,'Statutory Adoption Pay '||l_sap||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1243: edi_validation_fail := 'Y';
1244: ELSIF l_sap IS NOT NULL AND l_sap > 99999999 THEN
1245: populate_run_msg(p_assactid, 'Statutory Adoption Pay '||l_sap||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1246: fnd_file.put_line (fnd_file.LOG,'Statutory Adoption Pay '||l_sap||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1247: edi_validation_fail := 'Y';
1248: END IF;
1249:
1250: IF l_aspp IS NOT NULL AND l_aspp < 0 THEN

Line 1252: fnd_file.put_line (fnd_file.LOG,'Additional Statutory Paternity Pay '||l_aspp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');

1248: END IF;
1249:
1250: IF l_aspp IS NOT NULL AND l_aspp < 0 THEN
1251: populate_run_msg(p_assactid, 'Additional Statutory Paternity Pay '||l_aspp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1252: fnd_file.put_line (fnd_file.LOG,'Additional Statutory Paternity Pay '||l_aspp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1253: edi_validation_fail := 'Y';
1254: ELSIF l_aspp IS NOT NULL AND l_aspp > 99999999 THEN
1255: populate_run_msg(p_assactid, 'Additional Statutory Paternity Pay '||l_aspp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1256: fnd_file.put_line (fnd_file.LOG,'Additional Statutory Paternity Pay '||l_aspp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');

Line 1256: fnd_file.put_line (fnd_file.LOG,'Additional Statutory Paternity Pay '||l_aspp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');

1252: fnd_file.put_line (fnd_file.LOG,'Additional Statutory Paternity Pay '||l_aspp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1253: edi_validation_fail := 'Y';
1254: ELSIF l_aspp IS NOT NULL AND l_aspp > 99999999 THEN
1255: populate_run_msg(p_assactid, 'Additional Statutory Paternity Pay '||l_aspp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1256: fnd_file.put_line (fnd_file.LOG,'Additional Statutory Paternity Pay '||l_aspp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1257: edi_validation_fail := 'Y';
1258: END IF;
1259:
1260:

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

1260:
1261: -- Tax Code
1262: IF (l_tax_code = ' ' OR l_tax_code IS NULL) then
1263: populate_run_msg(p_assactid, 'The Tax Code is missing for assignment ' || l_assignment_number || '.');
1264: fnd_file.put_line (fnd_file.LOG,'The Tax Code is missing for assignment ' || l_assignment_number || '.');
1265: edi_validation_fail := 'Y';
1266: END IF;
1267:
1268:

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

1274:
1275: IF (l_tax_code <> ' ' and l_tax_code IS NOT NULL)
1276: AND (l_msg_value <> ' ') THEN
1277: populate_run_msg(p_assactid,'The Tax Code ' || l_tax_code || ' for assignment ' || l_assignment_number||' is invalid.');
1278: fnd_file.put_line (fnd_file.LOG,'The Tax Code ' || l_tax_code || ' for assignment ' || l_assignment_number||' is invalid.');
1279: edi_validation_fail := 'Y';
1280: END IF;
1281:
1282: -- Tax code ends

Line 1287: fnd_file.put_line (fnd_file.LOG,'Bacs Hash Code for assignment ' || l_assignment_number|| ' is invalid.');

1283:
1284: IF l_bacs_hash_code IS NOT NULL AND
1285: regexp_instr(l_bacs_hash_code,'^([[:alnum:]]){64}$') = 0 THEN
1286: populate_run_msg(p_assactid, 'Bacs Hash Code for assignment ' || l_assignment_number|| ' is invalid.' );
1287: fnd_file.put_line (fnd_file.LOG,'Bacs Hash Code for assignment ' || l_assignment_number|| ' is invalid.');
1288: edi_validation_fail := 'Y';
1289: END IF;
1290:
1291:

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

1438:
1439: IF l_start_date IS NOT NULL
1440: and date_validate(p_assactid,'UK_EMPL_DATE',l_start_date) = 0 THEN
1441: populate_run_msg(p_assactid,' The start date of employment for the assignment ' || l_assignment_number || ' is invalid.');
1442: fnd_file.put_line (fnd_file.LOG,'The start date of employment for the assignment ' || l_assignment_number || ' is invalid.');
1443: edi_validation_fail := 'Y';
1444: END IF;
1445:
1446: IF l_end_date IS NOT NULL

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

1445:
1446: IF l_end_date IS NOT NULL
1447: and date_validate(p_assactid,'UK_EMPL_DATE_LEAVING',l_end_date) = 0 THEN
1448: populate_run_msg(p_assactid,' The end date of employment for the assignment ' || l_assignment_number || ' is invalid.');
1449: fnd_file.put_line (fnd_file.LOG,'The end date of employment for the assignment ' || l_assignment_number || ' is invalid.');
1450: edi_validation_fail := 'Y';
1451: END IF;
1452:
1453: -- Payment Date is mandatory field

Line 1456: fnd_file.put_line (fnd_file.LOG,'The Payment Date is missing for assignment ' || l_assignment_number || '.');

1452:
1453: -- Payment Date is mandatory field
1454: IF l_payment_date IS NULL then
1455: populate_run_msg(p_assactid, 'The Payment Date is missing for assignment ' || l_assignment_number || '.');
1456: fnd_file.put_line (fnd_file.LOG,'The Payment Date is missing for assignment ' || l_assignment_number || '.');
1457: edi_validation_fail := 'Y';
1458: END IF;
1459:
1460:

Line 1464: fnd_file.put_line (fnd_file.LOG,'The Payment Date ' ||l_payment_date|| ' for assignment ' || l_assignment_number||' is invalid.');

1460:
1461: IF l_payment_date IS NOT NULL THEN
1462: IF l_payment_date < fnd_date.canonical_to_date('2012/04/06 00:00:00') THEN
1463: populate_run_msg(p_assactid, 'The Payment Date ' ||l_payment_date|| ' for assignment ' || l_assignment_number||' is invalid.');
1464: fnd_file.put_line (fnd_file.LOG,'The Payment Date ' ||l_payment_date|| ' for assignment ' || l_assignment_number||' is invalid.');
1465: edi_validation_fail := 'Y';
1466: END IF;
1467: END IF;
1468:

Line 1472: fnd_file.put_line (fnd_file.LOG,'The Starter Declaration is missing for assignment ' || l_assignment_number || '.');

1468:
1469: -- Starter Declaration is mandatory field
1470: IF l_start_date IS NOT NULL and (l_starter_declaration = ' ' OR l_starter_declaration IS NULL )then
1471: populate_run_msg(p_assactid, 'The Starter Declaration is missing for assignment ' || l_assignment_number || '.');
1472: fnd_file.put_line (fnd_file.LOG,'The Starter Declaration is missing for assignment ' || l_assignment_number || '.');
1473: edi_validation_fail := 'Y';
1474: END IF;
1475:
1476: IF l_starter_declaration IS NOT NULL THEN

Line 1479: fnd_file.put_line (fnd_file.LOG,'The Starter Declaration ' ||l_starter_declaration|| ' for assignment ' || l_assignment_number||' is invalid.');

1475:
1476: IF l_starter_declaration IS NOT NULL THEN
1477: IF l_starter_declaration NOT IN ('A' , 'B' , 'C') THEN
1478: populate_run_msg(p_assactid, 'The Starter Declaration ' ||l_starter_declaration|| ' for assignment ' || l_assignment_number||' is invalid.');
1479: fnd_file.put_line (fnd_file.LOG,'The Starter Declaration ' ||l_starter_declaration|| ' for assignment ' || l_assignment_number||' is invalid.');
1480: edi_validation_fail := 'Y';
1481: END IF;
1482: END IF;
1483:

Line 1489: fnd_file.put_line (fnd_file.LOG,'Stay in UK over six months for assignment ' || l_assignment_number||' is invalid.');

1485: -- l_stay_over_six_months , l_stay_less_six_months , l_living_abroad
1486:
1487: IF l_stay_over_six_months = 'Y' AND (l_stay_less_six_months = 'Y' OR l_living_abroad = 'Y') THEN
1488: populate_run_msg(p_assactid, 'Stay in UK over six months for assignment ' || l_assignment_number||' is invalid.');
1489: fnd_file.put_line (fnd_file.LOG,'Stay in UK over six months for assignment ' || l_assignment_number||' is invalid.');
1490: edi_validation_fail := 'Y';
1491: END IF;
1492:
1493: IF l_stay_less_six_months = 'Y' AND (l_stay_over_six_months = 'Y' OR l_living_abroad = 'Y') THEN

Line 1495: fnd_file.put_line (fnd_file.LOG,'Stay in UK less than six months for assignment ' || l_assignment_number||' is invalid.');

1491: END IF;
1492:
1493: IF l_stay_less_six_months = 'Y' AND (l_stay_over_six_months = 'Y' OR l_living_abroad = 'Y') THEN
1494: populate_run_msg(p_assactid, 'Stay in UK less than six months for assignment ' || l_assignment_number||' is invalid.');
1495: fnd_file.put_line (fnd_file.LOG,'Stay in UK less than six months for assignment ' || l_assignment_number||' is invalid.');
1496: edi_validation_fail := 'Y';
1497: END IF;
1498:
1499: IF l_living_abroad = 'Y' AND (l_stay_less_six_months = 'Y' OR l_stay_over_six_months = 'Y') THEN

Line 1501: fnd_file.put_line (fnd_file.LOG,'Working in/out of UK but living abroad for assignment ' || l_assignment_number||' is invalid.');

1497: END IF;
1498:
1499: IF l_living_abroad = 'Y' AND (l_stay_less_six_months = 'Y' OR l_stay_over_six_months = 'Y') THEN
1500: populate_run_msg(p_assactid, 'Working in/out of UK but living abroad for assignment ' || l_assignment_number||' is invalid.');
1501: fnd_file.put_line (fnd_file.LOG,'Working in/out of UK but living abroad for assignment ' || l_assignment_number||' is invalid.');
1502: edi_validation_fail := 'Y';
1503: END IF;
1504:
1505:

Line 1508: fnd_file.put_line (fnd_file.LOG,'The Annual amount of Occupational Pension for assignment ' || l_assignment_number||' is missing, although Occupational Pension Indicator is present.');

1504:
1505:
1506: IF l_occ_pension_indicator = 'Y' AND l_annual_occupational_pension IS NULL THEN
1507: populate_run_msg(p_assactid, 'The Annual amount of Occupational Pension for assignment ' || l_assignment_number||' is missing, although Occupational Pension Indicator is present.');
1508: fnd_file.put_line (fnd_file.LOG,'The Annual amount of Occupational Pension for assignment ' || l_assignment_number||' is missing, although Occupational Pension Indicator is present.');
1509: edi_validation_fail := 'Y';
1510: END IF;
1511:
1512:

Line 1516: fnd_file.put_line (fnd_file.LOG,'The Annual amount of Occupational Pension ' ||l_annual_occupational_pension|| ' for assignment ' || l_assignment_number||' must be greater than zero.');

1512:
1513: IF l_annual_occupational_pension IS NOT NULL THEN
1514: IF l_annual_occupational_pension < 0 THEN
1515: populate_run_msg(p_assactid, 'The Annual amount of Occupational Pension ' ||l_annual_occupational_pension|| ' for assignment ' || l_assignment_number||' must be greater than zero.');
1516: fnd_file.put_line (fnd_file.LOG,'The Annual amount of Occupational Pension ' ||l_annual_occupational_pension|| ' for assignment ' || l_assignment_number||' must be greater than zero.');
1517: edi_validation_fail := 'Y';
1518: ELSIF l_annual_occupational_pension > 999999999.99 THEN
1519: populate_run_msg(p_assactid, 'The Annual amount of Occupational Pension ' ||l_annual_occupational_pension|| ' exceeds 999999999.99 for assignment ' || l_assignment_number||' must be greater than zero.');
1520: fnd_file.put_line (fnd_file.LOG,'The Annual amount of Occupational Pension ' ||l_annual_occupational_pension|| ' exceeds 999999999.99 for assignment ' || l_assignment_number||' must be greater than zero.');

Line 1520: fnd_file.put_line (fnd_file.LOG,'The Annual amount of Occupational Pension ' ||l_annual_occupational_pension|| ' exceeds 999999999.99 for assignment ' || l_assignment_number||' must be greater than zero.');

1516: fnd_file.put_line (fnd_file.LOG,'The Annual amount of Occupational Pension ' ||l_annual_occupational_pension|| ' for assignment ' || l_assignment_number||' must be greater than zero.');
1517: edi_validation_fail := 'Y';
1518: ELSIF l_annual_occupational_pension > 999999999.99 THEN
1519: populate_run_msg(p_assactid, 'The Annual amount of Occupational Pension ' ||l_annual_occupational_pension|| ' exceeds 999999999.99 for assignment ' || l_assignment_number||' must be greater than zero.');
1520: fnd_file.put_line (fnd_file.LOG,'The Annual amount of Occupational Pension ' ||l_annual_occupational_pension|| ' exceeds 999999999.99 for assignment ' || l_assignment_number||' must be greater than zero.');
1521: edi_validation_fail := 'Y';
1522: END IF;
1523: END IF;
1524:

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

1524:
1525: IF ((l_payroll_id <> ' ' and l_payroll_id IS NOT NULL)
1526: and validate_input(l_payroll_id,'PAYROLLID') > 0) THEN
1527: populate_run_msg(p_assactid,' Payroll ID has invalid characters for the assignment ' || l_assignment_number || '.');
1528: fnd_file.put_line (fnd_file.LOG,'Payroll ID has invalid characters for the assignment ' || l_assignment_number || '.');
1529: edi_validation_fail := 'Y';
1530: END IF;
1531:
1532: IF ((l_old_payroll_id <> ' ' and l_old_payroll_id IS NOT NULL)

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

1531:
1532: IF ((l_old_payroll_id <> ' ' and l_old_payroll_id IS NOT NULL)
1533: and validate_input(l_old_payroll_id,'PAYROLLID') > 0) THEN
1534: populate_run_msg(p_assactid,' Old Payroll id has invalid characters for the assignment ' || l_assignment_number || '.');
1535: fnd_file.put_line (fnd_file.LOG,'Old Payroll id has invalid characters for the assignment ' || l_assignment_number || '.');
1536: edi_validation_fail := 'Y';
1537: END IF;
1538:
1539:

Line 1543: fnd_file.put_line (fnd_file.LOG,'The Pay frequency is missing for assignment ' || l_assignment_number || '.');

1539:
1540: -- Pay Frequency is mandatory field
1541: IF l_pay_frequency IS NULL OR l_pay_frequency = ' ' then
1542: populate_run_msg(p_assactid, 'The Pay frequency is missing for assignment ' || l_assignment_number || '.');
1543: fnd_file.put_line (fnd_file.LOG,'The Pay frequency is missing for assignment ' || l_assignment_number || '.');
1544: edi_validation_fail := 'Y';
1545: END IF;
1546:
1547:

Line 1551: fnd_file.put_line (fnd_file.LOG,'The Pay frequency for assignment ' || l_assignment_number|| ' is invalid.');

1547:
1548: IF (l_pay_frequency IS NOT NULL OR l_pay_frequency <> ' ') AND
1549: l_pay_frequency NOT IN ('W1','W2','W4','M1','M3','M6','MA','IO','IR') THEN
1550: populate_run_msg(p_assactid, 'The Pay frequency for assignment ' || l_assignment_number|| ' is invalid.' );
1551: fnd_file.put_line (fnd_file.LOG,'The Pay frequency for assignment ' || l_assignment_number|| ' is invalid.');
1552: edi_validation_fail := 'Y';
1553: END IF;
1554:
1555: -- Atleast one should be present

Line 1558: fnd_file.put_line (fnd_file.LOG,'Either Payment Week Number or Payment Month Number must be present for assignment ' || l_assignment_number || '.');

1554:
1555: -- Atleast one should be present
1556: IF l_payment_week_number IS NULL AND l_payment_month_number IS NULL THEN
1557: populate_run_msg(p_assactid, 'Either Payment Week Number or Payment Month Number must be present for assignment ' || l_assignment_number || '.');
1558: fnd_file.put_line (fnd_file.LOG,'Either Payment Week Number or Payment Month Number must be present for assignment ' || l_assignment_number || '.');
1559: edi_validation_fail := 'Y';
1560: END IF;
1561:
1562: IF l_payment_week_number IS NOT NULL AND

Line 1565: fnd_file.put_line (fnd_file.LOG,'The Payment Week Number for assignment ' || l_assignment_number|| ' is invalid.');

1561:
1562: IF l_payment_week_number IS NOT NULL AND
1563: ((l_payment_week_number < 1 OR l_payment_week_number > 54) AND l_payment_week_number <> 56) THEN
1564: populate_run_msg(p_assactid, 'The Payment Week Number for assignment ' || l_assignment_number|| ' is invalid.' );
1565: fnd_file.put_line (fnd_file.LOG,'The Payment Week Number for assignment ' || l_assignment_number|| ' is invalid.');
1566: edi_validation_fail := 'Y';
1567: END IF;
1568:
1569: IF l_payment_month_number IS NOT NULL AND

Line 1572: fnd_file.put_line (fnd_file.LOG,'The Payment Month Number for assignment ' || l_assignment_number|| ' is invalid.');

1568:
1569: IF l_payment_month_number IS NOT NULL AND
1570: (l_payment_month_number < 1 OR l_payment_month_number > 12) THEN
1571: populate_run_msg(p_assactid, 'The Payment Month Number for assignment ' || l_assignment_number|| ' is invalid.' );
1572: fnd_file.put_line (fnd_file.LOG,'The Payment Month Number for assignment ' || l_assignment_number|| ' is invalid.');
1573: edi_validation_fail := 'Y';
1574: END IF;
1575:
1576: -- Number of Earnings periods covered by payment is mandatory field

Line 1579: fnd_file.put_line (fnd_file.LOG,'The Number of Earnings Periods covered by Payment is missing for assignment ' || l_assignment_number || '.');

1575:
1576: -- Number of Earnings periods covered by payment is mandatory field
1577: IF l_no_of_earnings IS NULL THEN
1578: populate_run_msg(p_assactid, 'The Number of Earnings Periods covered by Payment is missing for assignment ' || l_assignment_number || '.');
1579: fnd_file.put_line (fnd_file.LOG,'The Number of Earnings Periods covered by Payment is missing for assignment ' || l_assignment_number || '.');
1580: edi_validation_fail := 'Y';
1581: END IF;
1582:
1583: IF l_payment_after_leaving = 'Y' AND

Line 1586: fnd_file.put_line (fnd_file.LOG,'The Date of Leaving is missing for assignment ' || l_assignment_number|| ',although Payment after leaving indicator is present.');

1582:
1583: IF l_payment_after_leaving = 'Y' AND
1584: l_end_date = fnd_date.canonical_to_date('4712/12/31') THEN
1585: populate_run_msg(p_assactid, 'The Date of Leaving is missing for assignment ' || l_assignment_number|| ',although Payment after leaving indicator is present.');
1586: fnd_file.put_line (fnd_file.LOG,'The Date of Leaving is missing for assignment ' || l_assignment_number|| ',although Payment after leaving indicator is present.');
1587: edi_validation_fail := 'Y';
1588: END IF;
1589:
1590: -- No of normal hours worked is mandatory field

Line 1594: fnd_file.put_line (fnd_file.LOG,'The Number of normal hours worked is missing for assignment ' || l_assignment_number || '.');

1590: -- No of normal hours worked is mandatory field
1591:
1592: IF l_no_of_hours_worked IS NULL THEN
1593: populate_run_msg(p_assactid, 'The Number of normal hours worked is missing for assignment ' || l_assignment_number || '.');
1594: fnd_file.put_line (fnd_file.LOG,'The Number of normal hours worked is missing for assignment ' || l_assignment_number || '.');
1595: edi_validation_fail := 'Y';
1596: END IF;
1597:
1598:

Line 1602: fnd_file.put_line (fnd_file.LOG,'The Week Number of Director appointment for assignment ' || l_assignment_number|| ' is invalid.');

1598:
1599: IF l_week_director_app IS NOT NULL AND
1600: ((l_week_director_app < 1 OR l_week_director_app > 54) AND l_week_director_app <> 56) THEN
1601: populate_run_msg(p_assactid, 'The Week Number of Director appointment for assignment ' || l_assignment_number|| ' is invalid.' );
1602: fnd_file.put_line (fnd_file.LOG,'The Week Number of Director appointment for assignment ' || l_assignment_number|| ' is invalid.');
1603: edi_validation_fail := 'Y';
1604: END IF;
1605:
1606: IF l_director_nic_method IS NOT NULL AND

Line 1609: fnd_file.put_line (fnd_file.LOG,'The Director NIC calculation method for assignment ' || l_assignment_number|| ' is invalid.');

1605:
1606: IF l_director_nic_method IS NOT NULL AND
1607: l_director_nic_method NOT IN ('AN' , 'AL') THEN
1608: populate_run_msg(p_assactid, 'The Director NIC calculation method for assignment ' || l_assignment_number|| ' is invalid.' );
1609: fnd_file.put_line (fnd_file.LOG,'The Director NIC calculation method for assignment ' || l_assignment_number|| ' is invalid.');
1610: edi_validation_fail := 'Y';
1611: END IF;
1612:
1613: IF l_week_director_app IS NOT NULL AND

Line 1616: fnd_file.put_line (fnd_file.LOG,'The Director NIC calculation method is mission for assignment ' || l_assignment_number||' although Tax week number is present.');

1612:
1613: IF l_week_director_app IS NOT NULL AND
1614: l_director_nic_method IS NULL THEN
1615: populate_run_msg(p_assactid, 'The Director NIC calculation method is missing for assignment ' || l_assignment_number||' although Tax week number is present.');
1616: fnd_file.put_line (fnd_file.LOG,'The Director NIC calculation method is mission for assignment ' || l_assignment_number||' although Tax week number is present.');
1617: edi_validation_fail := 'Y';
1618: END IF;
1619:
1620: -- Taxable Pay to Date is mandatory field

Line 1623: fnd_file.put_line (fnd_file.LOG,'The Taxable Pay to Date is missing for assignment ' || l_assignment_number || '.');

1619:
1620: -- Taxable Pay to Date is mandatory field
1621: IF l_taxable_pay_to_date IS NULL THEN
1622: populate_run_msg(p_assactid, 'The Taxable Pay to Date is missing for assignment ' || l_assignment_number || '.');
1623: fnd_file.put_line (fnd_file.LOG,'The Taxable Pay to Date is missing for assignment ' || l_assignment_number || '.');
1624: edi_validation_fail := 'Y';
1625: END IF;
1626:
1627: IF l_taxable_pay_to_date IS NOT NULL AND l_taxable_pay_to_date < 0 THEN

Line 1629: fnd_file.put_line (fnd_file.LOG,'The Taxable Pay to Date for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');

1625: END IF;
1626:
1627: IF l_taxable_pay_to_date IS NOT NULL AND l_taxable_pay_to_date < 0 THEN
1628: populate_run_msg(p_assactid, 'The Taxable Pay to Date for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.' );
1629: fnd_file.put_line (fnd_file.LOG,'The Taxable Pay to Date for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1630: edi_validation_fail := 'Y';
1631: END IF;
1632:
1633: -- Total Tax to Date is mandatory field

Line 1636: fnd_file.put_line (fnd_file.LOG,'The Total Tax to Date is missing for assignment ' || l_assignment_number || '.');

1632:
1633: -- Total Tax to Date is mandatory field
1634: IF l_total_tax IS NULL THEN
1635: populate_run_msg(p_assactid, 'The Total Tax to Date is missing for assignment ' || l_assignment_number || '.');
1636: fnd_file.put_line (fnd_file.LOG,'The Total Tax to Date is missing for assignment ' || l_assignment_number || '.');
1637: edi_validation_fail := 'Y';
1638: END IF;
1639:
1640: IF l_total_tax IS NOT NULL AND abs(l_total_tax) > 99999999999 THEN

Line 1642: fnd_file.put_line (fnd_file.LOG,'The Total Tax to Date exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1638: END IF;
1639:
1640: IF l_total_tax IS NOT NULL AND abs(l_total_tax) > 99999999999 THEN
1641: populate_run_msg(p_assactid, 'The Total Tax to Date exceeds 999999999.99 for assignment ' || l_assignment_number|| '.' );
1642: fnd_file.put_line (fnd_file.LOG,'The Total Tax to Date exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1643: edi_validation_fail := 'Y';
1644: END IF;
1645:
1646: IF l_student_loan_repayment IS NOT NULL AND l_student_loan_repayment < 0 THEN

Line 1648: fnd_file.put_line (fnd_file.LOG,'The Total Student loan repayment recovered to date for assignment ' || l_assignment_number|| ' must be greater than or equal to zero..');

1644: END IF;
1645:
1646: IF l_student_loan_repayment IS NOT NULL AND l_student_loan_repayment < 0 THEN
1647: populate_run_msg(p_assactid, 'The Total Student loan repayment recovered to date for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.' );
1648: fnd_file.put_line (fnd_file.LOG,'The Total Student loan repayment recovered to date for assignment ' || l_assignment_number|| ' must be greater than or equal to zero..');
1649: edi_validation_fail := 'Y';
1650: ELSIF l_student_loan_repayment IS NOT NULL AND l_student_loan_repayment > 9999900 THEN
1651: populate_run_msg(p_assactid, 'The Total Student loan repayment recovered to date exceeds 99999.00 for assignment ' || l_assignment_number|| '.' );
1652: fnd_file.put_line (fnd_file.LOG,'The Total Student loan repayment recovered to date exceeds 99999.00 for assignment ' || l_assignment_number|| '.');

Line 1652: fnd_file.put_line (fnd_file.LOG,'The Total Student loan repayment recovered to date exceeds 99999.00 for assignment ' || l_assignment_number|| '.');

1648: fnd_file.put_line (fnd_file.LOG,'The Total Student loan repayment recovered to date for assignment ' || l_assignment_number|| ' must be greater than or equal to zero..');
1649: edi_validation_fail := 'Y';
1650: ELSIF l_student_loan_repayment IS NOT NULL AND l_student_loan_repayment > 9999900 THEN
1651: populate_run_msg(p_assactid, 'The Total Student loan repayment recovered to date exceeds 99999.00 for assignment ' || l_assignment_number|| '.' );
1652: fnd_file.put_line (fnd_file.LOG,'The Total Student loan repayment recovered to date exceeds 99999.00 for assignment ' || l_assignment_number|| '.');
1653: edi_validation_fail := 'Y';
1654: END IF;
1655:
1656: ---- > 0

Line 1659: fnd_file.put_line (fnd_file.LOG,'Taxable pay '||l_taxable_pay||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1655:
1656: ---- > 0
1657: IF l_taxable_pay IS NOT NULL AND abs(l_taxable_pay) > 99999999999 THEN
1658: populate_run_msg(p_assactid, 'Taxable pay '||l_taxable_pay||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1659: fnd_file.put_line (fnd_file.LOG,'Taxable pay '||l_taxable_pay||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1660: edi_validation_fail := 'Y';
1661: END IF;
1662:
1663: IF l_non_tax_nic_payment IS NOT NULL AND abs(l_non_tax_nic_payment) > 99999999999 THEN

Line 1665: fnd_file.put_line (fnd_file.LOG,'Non Tax or NIC Payment '||l_non_tax_nic_payment||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1661: END IF;
1662:
1663: IF l_non_tax_nic_payment IS NOT NULL AND abs(l_non_tax_nic_payment) > 99999999999 THEN
1664: populate_run_msg(p_assactid, 'Non Tax or NIC Payment '||l_non_tax_nic_payment||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1665: fnd_file.put_line (fnd_file.LOG,'Non Tax or NIC Payment '||l_non_tax_nic_payment||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1666: edi_validation_fail := 'Y';
1667: END IF;
1668:
1669: IF l_net_pay_deductions IS NOT NULL AND abs(l_net_pay_deductions) > 99999999999 THEN

Line 1671: fnd_file.put_line (fnd_file.LOG,'Deductions from Net pay '||l_net_pay_deductions||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1667: END IF;
1668:
1669: IF l_net_pay_deductions IS NOT NULL AND abs(l_net_pay_deductions) > 99999999999 THEN
1670: populate_run_msg(p_assactid, 'Deductions from Net pay '||l_net_pay_deductions||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1671: fnd_file.put_line (fnd_file.LOG,'Deductions from Net pay '||l_net_pay_deductions||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1672: edi_validation_fail := 'Y';
1673: END IF;
1674:
1675: IF l_pay_after_statutory IS NOT NULL AND abs(l_pay_after_statutory) > 99999999999 THEN

Line 1677: fnd_file.put_line (fnd_file.LOG,'Pay after Statutory deductions '||l_pay_after_statutory||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1673: END IF;
1674:
1675: IF l_pay_after_statutory IS NOT NULL AND abs(l_pay_after_statutory) > 99999999999 THEN
1676: populate_run_msg(p_assactid, 'Pay after Statutory deductions '||l_pay_after_statutory||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1677: fnd_file.put_line (fnd_file.LOG,'Pay after Statutory deductions '||l_pay_after_statutory||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1678: edi_validation_fail := 'Y';
1679: END IF;
1680:
1681: IF l_benefits_taxed_payroll IS NOT NULL AND abs(l_benefits_taxed_payroll) > 99999999999 THEN

Line 1683: fnd_file.put_line (fnd_file.LOG,'Benefits Taxed via Payroll '||l_benefits_taxed_payroll||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1679: END IF;
1680:
1681: IF l_benefits_taxed_payroll IS NOT NULL AND abs(l_benefits_taxed_payroll) > 99999999999 THEN
1682: populate_run_msg(p_assactid, 'Benefits Taxed via Payroll '||l_benefits_taxed_payroll||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1683: fnd_file.put_line (fnd_file.LOG,'Benefits Taxed via Payroll '||l_benefits_taxed_payroll||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1684: edi_validation_fail := 'Y';
1685: END IF;
1686:
1687: IF l_benefits_class1_nic IS NOT NULL AND abs(l_benefits_class1_nic) > 99999999999 THEN

Line 1689: fnd_file.put_line (fnd_file.LOG,'Benefits Subject to Class1 NIC '||l_benefits_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1685: END IF;
1686:
1687: IF l_benefits_class1_nic IS NOT NULL AND abs(l_benefits_class1_nic) > 99999999999 THEN
1688: populate_run_msg(p_assactid, 'Benefits Subject to Class1 NIC '||l_benefits_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1689: fnd_file.put_line (fnd_file.LOG,'Benefits Subject to Class1 NIC '||l_benefits_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1690: edi_validation_fail := 'Y';
1691: END IF;
1692:
1693: IF l_benefits_n_class1_nic IS NOT NULL AND abs(l_benefits_n_class1_nic) > 99999999999 THEN

Line 1695: fnd_file.put_line (fnd_file.LOG,'Benefits not subject to Class1 NIC '||l_benefits_n_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1691: END IF;
1692:
1693: IF l_benefits_n_class1_nic IS NOT NULL AND abs(l_benefits_n_class1_nic) > 99999999999 THEN
1694: populate_run_msg(p_assactid, 'Benefits not subject to Class1 NIC '||l_benefits_n_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1695: fnd_file.put_line (fnd_file.LOG,'Benefits not subject to Class1 NIC '||l_benefits_n_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1696: edi_validation_fail := 'Y';
1697: END IF;
1698:
1699: IF l_employee_pension_contri IS NOT NULL AND abs(l_employee_pension_contri) > 99999999999 THEN

Line 1701: fnd_file.put_line (fnd_file.LOG,'Employee Pension contributions '||l_benefits_n_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1697: END IF;
1698:
1699: IF l_employee_pension_contri IS NOT NULL AND abs(l_employee_pension_contri) > 99999999999 THEN
1700: populate_run_msg(p_assactid, 'Employee Pension contributions '||l_benefits_n_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1701: fnd_file.put_line (fnd_file.LOG,'Employee Pension contributions '||l_benefits_n_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1702: edi_validation_fail := 'Y';
1703: END IF;
1704:
1705: IF l_items_class1_nic IS NOT NULL AND abs(l_items_class1_nic) > 99999999999 THEN

Line 1707: fnd_file.put_line (fnd_file.LOG,'Items subject to Class1 NIC '||l_items_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1703: END IF;
1704:
1705: IF l_items_class1_nic IS NOT NULL AND abs(l_items_class1_nic) > 99999999999 THEN
1706: populate_run_msg(p_assactid, 'Items subject to Class1 NIC '||l_items_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1707: fnd_file.put_line (fnd_file.LOG,'Items subject to Class1 NIC '||l_items_class1_nic||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1708: edi_validation_fail := 'Y';
1709: END IF;
1710:
1711: IF l_emp_contri_not_paid IS NOT NULL AND abs(l_emp_contri_not_paid) > 99999999999 THEN

Line 1713: fnd_file.put_line (fnd_file.LOG,'Employee contributions not paid '||l_emp_contri_not_paid||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');

1709: END IF;
1710:
1711: IF l_emp_contri_not_paid IS NOT NULL AND abs(l_emp_contri_not_paid) > 99999999999 THEN
1712: populate_run_msg(p_assactid, 'Employee contributions not paid '||l_emp_contri_not_paid||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1713: fnd_file.put_line (fnd_file.LOG,'Employee contributions not paid '||l_emp_contri_not_paid||' exceeds 999999999.99 for assignment ' || l_assignment_number|| '.');
1714: edi_validation_fail := 'Y';
1715: END IF;
1716:
1717: IF l_student_loan_repay IS NOT NULL AND abs(l_student_loan_repay) > 9999900 THEN

Line 1719: fnd_file.put_line (fnd_file.LOG,'Student Loan Repayment recovered '||l_student_loan_repay||' exceeds 99999.00 for assignment ' || l_assignment_number|| '.');

1715: END IF;
1716:
1717: IF l_student_loan_repay IS NOT NULL AND abs(l_student_loan_repay) > 9999900 THEN
1718: populate_run_msg(p_assactid, 'Student Loan Repayment recovered '||l_student_loan_repay||' exceeds 99999.00 for assignment ' || l_assignment_number|| '.');
1719: fnd_file.put_line (fnd_file.LOG,'Student Loan Repayment recovered '||l_student_loan_repay||' exceeds 99999.00 for assignment ' || l_assignment_number|| '.');
1720: edi_validation_fail := 'Y';
1721: END IF;
1722:
1723: -- Tax Deducted or Refunded is mandatory field

Line 1728: fnd_file.put_line (fnd_file.LOG,'Tax deducted or refunded is missing for assignment ' || l_assignment_number || '.');

1724: --Commented the below for testing
1725:
1726: IF l_tax_deducted_refunded IS NULL THEN
1727: populate_run_msg(p_assactid, 'Tax deducted or refunded is missing for assignment ' || l_assignment_number || '.');
1728: fnd_file.put_line (fnd_file.LOG,'Tax deducted or refunded is missing for assignment ' || l_assignment_number || '.');
1729: edi_validation_fail := 'Y';
1730: END IF;
1731:
1732:

Line 1735: fnd_file.put_line (fnd_file.LOG,'Tax Deducted or Refunded '||l_student_loan_repay||' exceeds 9999999999.99 for assignment ' || l_assignment_number|| '.');

1731:
1732:
1733: IF l_tax_deducted_refunded IS NOT NULL AND abs(l_tax_deducted_refunded) > 999999999999 THEN
1734: populate_run_msg(p_assactid, 'Tax Deducted or Refunded '||l_student_loan_repay||' exceeds 9999999999.99 for assignment ' || l_assignment_number|| '.');
1735: fnd_file.put_line (fnd_file.LOG,'Tax Deducted or Refunded '||l_student_loan_repay||' exceeds 9999999999.99 for assignment ' || l_assignment_number|| '.');
1736: edi_validation_fail := 'Y';
1737: END IF;
1738:
1739: IF l_ssp IS NOT NULL AND l_ssp < 0 THEN

Line 1741: fnd_file.put_line (fnd_file.LOG,'Statutory Sick Pay '||l_ssp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');

1737: END IF;
1738:
1739: IF l_ssp IS NOT NULL AND l_ssp < 0 THEN
1740: populate_run_msg(p_assactid, 'Statutory Sick Pay '||l_ssp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1741: fnd_file.put_line (fnd_file.LOG,'Statutory Sick Pay '||l_ssp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1742: edi_validation_fail := 'Y';
1743: ELSIF l_ssp IS NOT NULL AND l_ssp > 999999 THEN
1744: populate_run_msg(p_assactid, 'Statutory Sick Pay '||l_ssp||' exceeds 9999.99 for assignment ' || l_assignment_number|| '.');
1745: fnd_file.put_line (fnd_file.LOG,'Statutory Sick Pay '||l_ssp||' exceeds 9999.99 for assignment ' || l_assignment_number|| '.');

Line 1745: fnd_file.put_line (fnd_file.LOG,'Statutory Sick Pay '||l_ssp||' exceeds 9999.99 for assignment ' || l_assignment_number|| '.');

1741: fnd_file.put_line (fnd_file.LOG,'Statutory Sick Pay '||l_ssp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1742: edi_validation_fail := 'Y';
1743: ELSIF l_ssp IS NOT NULL AND l_ssp > 999999 THEN
1744: populate_run_msg(p_assactid, 'Statutory Sick Pay '||l_ssp||' exceeds 9999.99 for assignment ' || l_assignment_number|| '.');
1745: fnd_file.put_line (fnd_file.LOG,'Statutory Sick Pay '||l_ssp||' exceeds 9999.99 for assignment ' || l_assignment_number|| '.');
1746: edi_validation_fail := 'Y';
1747: END IF;
1748:
1749: IF l_smp IS NOT NULL AND l_smp < 0 THEN

Line 1751: fnd_file.put_line (fnd_file.LOG,'Statutory Maternity Pay '||l_smp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');

1747: END IF;
1748:
1749: IF l_smp IS NOT NULL AND l_smp < 0 THEN
1750: populate_run_msg(p_assactid, 'Statutory Maternity Pay '||l_smp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1751: fnd_file.put_line (fnd_file.LOG,'Statutory Maternity Pay '||l_smp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1752: edi_validation_fail := 'Y';
1753: ELSIF l_smp IS NOT NULL AND l_smp > 99999999 THEN
1754: populate_run_msg(p_assactid, 'Statutory Maternity Pay '||l_smp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1755: fnd_file.put_line (fnd_file.LOG,'Statutory Maternity Pay '||l_smp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');

Line 1755: fnd_file.put_line (fnd_file.LOG,'Statutory Maternity Pay '||l_smp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');

1751: fnd_file.put_line (fnd_file.LOG,'Statutory Maternity Pay '||l_smp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1752: edi_validation_fail := 'Y';
1753: ELSIF l_smp IS NOT NULL AND l_smp > 99999999 THEN
1754: populate_run_msg(p_assactid, 'Statutory Maternity Pay '||l_smp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1755: fnd_file.put_line (fnd_file.LOG,'Statutory Maternity Pay '||l_smp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1756: edi_validation_fail := 'Y';
1757: END IF;
1758:
1759: IF l_smp > 0 AND l_gender <> 'F' THEN

Line 1761: fnd_file.put_line (fnd_file.LOG,'Gender must be female for assignment ' || l_assignment_number|| ' to claim Statutory Maternity Pay.');

1757: END IF;
1758:
1759: IF l_smp > 0 AND l_gender <> 'F' THEN
1760: populate_run_msg(p_assactid, 'Gender must be female for assignment ' || l_assignment_number|| ' to claim Statutory Maternity Pay.');
1761: fnd_file.put_line (fnd_file.LOG,'Gender must be female for assignment ' || l_assignment_number|| ' to claim Statutory Maternity Pay.');
1762: edi_validation_fail := 'Y';
1763: END IF;
1764:
1765: IF l_ospp IS NOT NULL AND l_ospp < 0 THEN

Line 1767: fnd_file.put_line (fnd_file.LOG,'Ordinary Statutory Paternity Pay '||l_ospp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');

1763: END IF;
1764:
1765: IF l_ospp IS NOT NULL AND l_ospp < 0 THEN
1766: populate_run_msg(p_assactid, 'Ordinary Statutory Paternity Pay '||l_ospp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1767: fnd_file.put_line (fnd_file.LOG,'Ordinary Statutory Paternity Pay '||l_ospp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1768: edi_validation_fail := 'Y';
1769: ELSIF l_ospp IS NOT NULL AND l_ospp > 99999999 THEN
1770: populate_run_msg(p_assactid, 'Ordinary Statutory Paternity Pay '||l_ospp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1771: fnd_file.put_line (fnd_file.LOG,'Ordinary Statutory Paternity Pay '||l_ospp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');

Line 1771: fnd_file.put_line (fnd_file.LOG,'Ordinary Statutory Paternity Pay '||l_ospp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');

1767: fnd_file.put_line (fnd_file.LOG,'Ordinary Statutory Paternity Pay '||l_ospp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1768: edi_validation_fail := 'Y';
1769: ELSIF l_ospp IS NOT NULL AND l_ospp > 99999999 THEN
1770: populate_run_msg(p_assactid, 'Ordinary Statutory Paternity Pay '||l_ospp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1771: fnd_file.put_line (fnd_file.LOG,'Ordinary Statutory Paternity Pay '||l_ospp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1772: edi_validation_fail := 'Y';
1773: END IF;
1774:
1775: IF l_sap IS NOT NULL AND l_sap < 0 THEN

Line 1777: fnd_file.put_line (fnd_file.LOG,'Statutory Adoption Pay '||l_sap||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');

1773: END IF;
1774:
1775: IF l_sap IS NOT NULL AND l_sap < 0 THEN
1776: populate_run_msg(p_assactid, 'Statutory Adoption Pay '||l_sap||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1777: fnd_file.put_line (fnd_file.LOG,'Statutory Adoption Pay '||l_sap||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1778: edi_validation_fail := 'Y';
1779: ELSIF l_sap IS NOT NULL AND l_sap > 99999999 THEN
1780: populate_run_msg(p_assactid, 'Statutory Adoption Pay '||l_sap||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1781: fnd_file.put_line (fnd_file.LOG,'Statutory Adoption Pay '||l_sap||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');

Line 1781: fnd_file.put_line (fnd_file.LOG,'Statutory Adoption Pay '||l_sap||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');

1777: fnd_file.put_line (fnd_file.LOG,'Statutory Adoption Pay '||l_sap||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1778: edi_validation_fail := 'Y';
1779: ELSIF l_sap IS NOT NULL AND l_sap > 99999999 THEN
1780: populate_run_msg(p_assactid, 'Statutory Adoption Pay '||l_sap||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1781: fnd_file.put_line (fnd_file.LOG,'Statutory Adoption Pay '||l_sap||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1782: edi_validation_fail := 'Y';
1783: END IF;
1784:
1785: IF l_aspp IS NOT NULL AND l_aspp < 0 THEN

Line 1787: fnd_file.put_line (fnd_file.LOG,'Additional Statutory Paternity Pay '||l_aspp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');

1783: END IF;
1784:
1785: IF l_aspp IS NOT NULL AND l_aspp < 0 THEN
1786: populate_run_msg(p_assactid, 'Additional Statutory Paternity Pay '||l_aspp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1787: fnd_file.put_line (fnd_file.LOG,'Additional Statutory Paternity Pay '||l_aspp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1788: edi_validation_fail := 'Y';
1789: ELSIF l_aspp IS NOT NULL AND l_aspp > 99999999 THEN
1790: populate_run_msg(p_assactid, 'Additional Statutory Paternity Pay '||l_aspp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1791: fnd_file.put_line (fnd_file.LOG,'Additional Statutory Paternity Pay '||l_aspp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');

Line 1791: fnd_file.put_line (fnd_file.LOG,'Additional Statutory Paternity Pay '||l_aspp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');

1787: fnd_file.put_line (fnd_file.LOG,'Additional Statutory Paternity Pay '||l_aspp||' for assignment ' || l_assignment_number|| ' must be greater than or equal to zero.');
1788: edi_validation_fail := 'Y';
1789: ELSIF l_aspp IS NOT NULL AND l_aspp > 99999999 THEN
1790: populate_run_msg(p_assactid, 'Additional Statutory Paternity Pay '||l_aspp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1791: fnd_file.put_line (fnd_file.LOG,'Additional Statutory Paternity Pay '||l_aspp||' exceeds 999999.99 for assignment ' || l_assignment_number|| '.');
1792: edi_validation_fail := 'Y';
1793: END IF;
1794:
1795:

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

1795:
1796: -- Tax Code
1797: IF (l_tax_code = ' ' OR l_tax_code IS NULL) then
1798: populate_run_msg(p_assactid, 'The Tax Code is missing for assignment ' || l_assignment_number || '.');
1799: fnd_file.put_line (fnd_file.LOG,'The Tax Code is missing for assignment ' || l_assignment_number || '.');
1800: edi_validation_fail := 'Y';
1801: END IF;
1802:
1803:

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

1809:
1810: IF (l_tax_code <> ' ' and l_tax_code IS NOT NULL)
1811: AND (l_msg_value <> ' ') THEN
1812: populate_run_msg(p_assactid,'The Tax Code ' || l_tax_code || ' for assignment ' || l_assignment_number||' is invalid.');
1813: fnd_file.put_line (fnd_file.LOG,'The Tax Code ' || l_tax_code || ' for assignment ' || l_assignment_number||' is invalid.');
1814: edi_validation_fail := 'Y';
1815: END IF;
1816:
1817: -- Tax code ends

Line 1822: fnd_file.put_line (fnd_file.LOG,'Bacs Hash Code for assignment ' || l_assignment_number|| ' is invalid.');

1818:
1819: IF l_bacs_hash_code IS NOT NULL AND
1820: regexp_instr(l_bacs_hash_code,'^([[:alnum:]]){64}$') = 0 THEN
1821: populate_run_msg(p_assactid, 'Bacs Hash Code for assignment ' || l_assignment_number|| ' is invalid.' );
1822: fnd_file.put_line (fnd_file.LOG,'Bacs Hash Code for assignment ' || l_assignment_number|| ' is invalid.');
1823: edi_validation_fail := 'Y';
1824: END IF;
1825:
1826:

Line 1910: fnd_file.put_line (fnd_file.LOG,'NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');

1906: IF (l_gender = 'M' AND l_ni_category NOT IN ('A','C','D','J','L','N','Q','R','W','X')) OR
1907: (l_gender = 'F' AND l_ni_category NOT IN ('A','B','C','D','E','J','L','N','O','Q','R','T','W','X')) THEN
1908:
1909: populate_run_msg(p_assactid,'NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');
1910: fnd_file.put_line (fnd_file.LOG,'NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');
1911: edi_validation_fail := 'Y';
1912:
1913: END IF;
1914: END IF;

Line 1919: fnd_file.put_line (fnd_file.LOG,'Pay subject to NICs in this period for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');

1915:
1916: IF l_ni_category IS NOT NULL THEN
1917: IF l_pay_to_nic IS NULL THEN
1918: populate_run_msg(p_assactid,'Pay subject to NICs in this period for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');
1919: fnd_file.put_line (fnd_file.LOG,'Pay subject to NICs in this period for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');
1920: edi_validation_fail := 'Y';
1921: ELSIF l_ni_category = 'X' AND l_pay_to_nic <> 0 THEN
1922: populate_run_msg(p_assactid,'Pay subject to NICs in this period for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
1923: fnd_file.put_line (fnd_file.LOG,'Pay subject to NICs in this period for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');

Line 1923: fnd_file.put_line (fnd_file.LOG,'Pay subject to NICs in this period for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');

1919: fnd_file.put_line (fnd_file.LOG,'Pay subject to NICs in this period for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');
1920: edi_validation_fail := 'Y';
1921: ELSIF l_ni_category = 'X' AND l_pay_to_nic <> 0 THEN
1922: populate_run_msg(p_assactid,'Pay subject to NICs in this period for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
1923: fnd_file.put_line (fnd_file.LOG,'Pay subject to NICs in this period for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
1924: edi_validation_fail := 'Y';
1925: END IF;
1926: END IF;
1927:

Line 1932: fnd_file.put_line (fnd_file.LOG,'Earnings at Lower Earnings Limit Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');

1928:
1929: IF l_ni_category IS NOT NULL THEN
1930: IF l_earnings_lel IS NULL THEN
1931: populate_run_msg(p_assactid,'Earnings at Lower Earnings Limit Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');
1932: fnd_file.put_line (fnd_file.LOG,'Earnings at Lower Earnings Limit Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');
1933: edi_validation_fail := 'Y';
1934: ELSIF l_earnings_lel < 0 THEN
1935: populate_run_msg(p_assactid,'Earnings at Lower Earnings Limit Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');
1936: fnd_file.put_line (fnd_file.LOG,'Earnings at Lower Earnings Limit Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');

Line 1936: fnd_file.put_line (fnd_file.LOG,'Earnings at Lower Earnings Limit Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');

1932: fnd_file.put_line (fnd_file.LOG,'Earnings at Lower Earnings Limit Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');
1933: edi_validation_fail := 'Y';
1934: ELSIF l_earnings_lel < 0 THEN
1935: populate_run_msg(p_assactid,'Earnings at Lower Earnings Limit Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');
1936: fnd_file.put_line (fnd_file.LOG,'Earnings at Lower Earnings Limit Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');
1937: edi_validation_fail := 'Y';
1938: ELSIF l_ni_category = 'X' AND l_earnings_lel <> 0 THEN
1939: populate_run_msg(p_assactid,'Earnings at Lower Earnings Limit Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
1940: fnd_file.put_line (fnd_file.LOG,'Earnings at Lower Earnings Limit Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');

Line 1940: fnd_file.put_line (fnd_file.LOG,'Earnings at Lower Earnings Limit Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');

1936: fnd_file.put_line (fnd_file.LOG,'Earnings at Lower Earnings Limit Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');
1937: edi_validation_fail := 'Y';
1938: ELSIF l_ni_category = 'X' AND l_earnings_lel <> 0 THEN
1939: populate_run_msg(p_assactid,'Earnings at Lower Earnings Limit Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
1940: fnd_file.put_line (fnd_file.LOG,'Earnings at Lower Earnings Limit Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
1941: edi_validation_fail := 'Y';
1942: END IF;
1943: END IF;
1944:

Line 1948: fnd_file.put_line (fnd_file.LOG,'Earnings above LEL upto PT Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');

1944:
1945: IF l_ni_category IS NOT NULL THEN
1946: IF l_earnings_above_lel IS NULL THEN
1947: populate_run_msg(p_assactid,'Earnings above LEL upto PT Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');
1948: fnd_file.put_line (fnd_file.LOG,'Earnings above LEL upto PT Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');
1949: edi_validation_fail := 'Y';
1950: ELSIF l_earnings_above_lel < 0 THEN
1951: populate_run_msg(p_assactid,'Earnings above LEL upto PT Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');
1952: fnd_file.put_line (fnd_file.LOG,'Earnings above LEL upto PT Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');

Line 1952: fnd_file.put_line (fnd_file.LOG,'Earnings above LEL upto PT Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');

1948: fnd_file.put_line (fnd_file.LOG,'Earnings above LEL upto PT Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');
1949: edi_validation_fail := 'Y';
1950: ELSIF l_earnings_above_lel < 0 THEN
1951: populate_run_msg(p_assactid,'Earnings above LEL upto PT Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');
1952: fnd_file.put_line (fnd_file.LOG,'Earnings above LEL upto PT Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');
1953: edi_validation_fail := 'Y';
1954: ELSIF l_ni_category = 'X' AND l_earnings_above_lel <> 0 THEN
1955: populate_run_msg(p_assactid,'Earnings above LEL upto PT Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
1956: fnd_file.put_line (fnd_file.LOG,'Earnings above LEL upto PT Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');

Line 1956: fnd_file.put_line (fnd_file.LOG,'Earnings above LEL upto PT Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');

1952: fnd_file.put_line (fnd_file.LOG,'Earnings above LEL upto PT Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');
1953: edi_validation_fail := 'Y';
1954: ELSIF l_ni_category = 'X' AND l_earnings_above_lel <> 0 THEN
1955: populate_run_msg(p_assactid,'Earnings above LEL upto PT Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
1956: fnd_file.put_line (fnd_file.LOG,'Earnings above LEL upto PT Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
1957: edi_validation_fail := 'Y';
1958: END IF;
1959: END IF;
1960:

Line 1964: fnd_file.put_line (fnd_file.LOG,'Earnings above PT upto UAP Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');

1960:
1961: IF l_ni_category IS NOT NULL THEN
1962: IF l_earnings_above_pt IS NULL THEN
1963: populate_run_msg(p_assactid,'Earnings above PT upto UAP Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');
1964: fnd_file.put_line (fnd_file.LOG,'Earnings above PT upto UAP Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');
1965: edi_validation_fail := 'Y';
1966: ELSIF l_earnings_above_pt < 0 THEN
1967: populate_run_msg(p_assactid,'Earnings above PT upto UAP Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');
1968: fnd_file.put_line (fnd_file.LOG,'Earnings above PT upto UAP Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');

Line 1968: fnd_file.put_line (fnd_file.LOG,'Earnings above PT upto UAP Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');

1964: fnd_file.put_line (fnd_file.LOG,'Earnings above PT upto UAP Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');
1965: edi_validation_fail := 'Y';
1966: ELSIF l_earnings_above_pt < 0 THEN
1967: populate_run_msg(p_assactid,'Earnings above PT upto UAP Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');
1968: fnd_file.put_line (fnd_file.LOG,'Earnings above PT upto UAP Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');
1969: edi_validation_fail := 'Y';
1970: ELSIF l_ni_category = 'X' AND l_earnings_above_pt <> 0 THEN
1971: populate_run_msg(p_assactid,'Earnings above PT upto UAP Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
1972: fnd_file.put_line (fnd_file.LOG,'Earnings above PT upto UAP Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');

Line 1972: fnd_file.put_line (fnd_file.LOG,'Earnings above PT upto UAP Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');

1968: fnd_file.put_line (fnd_file.LOG,'Earnings above PT upto UAP Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');
1969: edi_validation_fail := 'Y';
1970: ELSIF l_ni_category = 'X' AND l_earnings_above_pt <> 0 THEN
1971: populate_run_msg(p_assactid,'Earnings above PT upto UAP Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
1972: fnd_file.put_line (fnd_file.LOG,'Earnings above PT upto UAP Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
1973: edi_validation_fail := 'Y';
1974: END IF;
1975: END IF;
1976:

Line 1980: fnd_file.put_line (fnd_file.LOG,'Earnings above UAP upto UEL Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');

1976:
1977: IF l_ni_category IS NOT NULL THEN
1978: IF l_earnings_above_uap IS NULL THEN
1979: populate_run_msg(p_assactid,'Earnings above UAP upto UEL Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');
1980: fnd_file.put_line (fnd_file.LOG,'Earnings above UAP upto UEL Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');
1981: edi_validation_fail := 'Y';
1982: ELSIF l_earnings_above_uap < 0 THEN
1983: populate_run_msg(p_assactid,'Earnings above UAP upto UEL Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');
1984: fnd_file.put_line (fnd_file.LOG,'Earnings above UAP upto UEL Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');

Line 1984: fnd_file.put_line (fnd_file.LOG,'Earnings above UAP upto UEL Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');

1980: fnd_file.put_line (fnd_file.LOG,'Earnings above UAP upto UEL Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is missing.');
1981: edi_validation_fail := 'Y';
1982: ELSIF l_earnings_above_uap < 0 THEN
1983: populate_run_msg(p_assactid,'Earnings above UAP upto UEL Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');
1984: fnd_file.put_line (fnd_file.LOG,'Earnings above UAP upto UEL Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');
1985: edi_validation_fail := 'Y';
1986: ELSIF l_ni_category = 'X' AND l_earnings_above_uap <> 0 THEN
1987: populate_run_msg(p_assactid,'Earnings above UAP upto UEL Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
1988: fnd_file.put_line (fnd_file.LOG,'Earnings above UAP upto UEL Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');

Line 1988: fnd_file.put_line (fnd_file.LOG,'Earnings above UAP upto UEL Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');

1984: fnd_file.put_line (fnd_file.LOG,'Earnings above UAP upto UEL Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' is invalid.');
1985: edi_validation_fail := 'Y';
1986: ELSIF l_ni_category = 'X' AND l_earnings_above_uap <> 0 THEN
1987: populate_run_msg(p_assactid,'Earnings above UAP upto UEL Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
1988: fnd_file.put_line (fnd_file.LOG,'Earnings above UAP upto UEL Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
1989: edi_validation_fail := 'Y';
1990: END IF;
1991: END IF;
1992:

Line 1996: fnd_file.put_line (fnd_file.LOG,'The Total of Employer contributions in this period is missing for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number);

1992:
1993: --Employer Contribution
1994: IF l_employer_contribution IS NULL THEN
1995: populate_run_msg(p_assactid, 'The Total of Employer contributions in this period is missing for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number);
1996: fnd_file.put_line (fnd_file.LOG,'The Total of Employer contributions in this period is missing for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number);
1997: edi_validation_fail := 'Y';
1998: ELSIF l_ni_category = 'X' AND l_employer_contribution <> 0 THEN
1999: populate_run_msg(p_assactid, 'The Total of Employer contributions in this period for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
2000: fnd_file.put_line (fnd_file.LOG,'The Total of Employer contributions in this period for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');

Line 2000: fnd_file.put_line (fnd_file.LOG,'The Total of Employer contributions in this period for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');

1996: fnd_file.put_line (fnd_file.LOG,'The Total of Employer contributions in this period is missing for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number);
1997: edi_validation_fail := 'Y';
1998: ELSIF l_ni_category = 'X' AND l_employer_contribution <> 0 THEN
1999: populate_run_msg(p_assactid, 'The Total of Employer contributions in this period for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
2000: fnd_file.put_line (fnd_file.LOG,'The Total of Employer contributions in this period for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
2001: edi_validation_fail := 'Y';
2002: END IF;
2003:
2004: IF l_employer_contrib_y2d IS NULL THEN

Line 2006: fnd_file.put_line (fnd_file.LOG,'The Total of Employer contributions Year to Date is missing for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number);

2002: END IF;
2003:
2004: IF l_employer_contrib_y2d IS NULL THEN
2005: populate_run_msg(p_assactid, 'The Total of Employer contributions Year to Date is missing for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number);
2006: fnd_file.put_line (fnd_file.LOG,'The Total of Employer contributions Year to Date is missing for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number);
2007: edi_validation_fail := 'Y';
2008: ELSIF l_ni_category = 'X' AND l_employer_contrib_y2d <> 0 THEN
2009: populate_run_msg(p_assactid, 'The Total of Employer contributions Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
2010: fnd_file.put_line (fnd_file.LOG,'The Total of Employer contributions Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');

Line 2010: fnd_file.put_line (fnd_file.LOG,'The Total of Employer contributions Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');

2006: fnd_file.put_line (fnd_file.LOG,'The Total of Employer contributions Year to Date is missing for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number);
2007: edi_validation_fail := 'Y';
2008: ELSIF l_ni_category = 'X' AND l_employer_contrib_y2d <> 0 THEN
2009: populate_run_msg(p_assactid, 'The Total of Employer contributions Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
2010: fnd_file.put_line (fnd_file.LOG,'The Total of Employer contributions Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
2011: edi_validation_fail := 'Y';
2012: END IF;
2013:
2014: --Employee Contribution

Line 2017: fnd_file.put_line (fnd_file.LOG,'The Employee contributions Payable this period is missing for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number || '.');

2013:
2014: --Employee Contribution
2015: IF l_employee_contribution IS NULL THEN
2016: populate_run_msg(p_assactid, 'The Employee contributions Payable this period is missing for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number || '.');
2017: fnd_file.put_line (fnd_file.LOG,'The Employee contributions Payable this period is missing for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number || '.');
2018: edi_validation_fail := 'Y';
2019: ELSIF l_ni_category IN ('X','C','W') AND l_employee_contribution <> 0 THEN
2020: populate_run_msg(p_assactid, 'The Employee contributions Payable this period for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
2021: fnd_file.put_line (fnd_file.LOG,'The Employee contributions Payable this period for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');

Line 2021: fnd_file.put_line (fnd_file.LOG,'The Employee contributions Payable this period for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');

2017: fnd_file.put_line (fnd_file.LOG,'The Employee contributions Payable this period is missing for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number || '.');
2018: edi_validation_fail := 'Y';
2019: ELSIF l_ni_category IN ('X','C','W') AND l_employee_contribution <> 0 THEN
2020: populate_run_msg(p_assactid, 'The Employee contributions Payable this period for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
2021: fnd_file.put_line (fnd_file.LOG,'The Employee contributions Payable this period for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
2022: edi_validation_fail := 'Y';
2023: END IF;
2024:
2025: IF l_employee_contrib_y2d IS NULL THEN

Line 2027: fnd_file.put_line (fnd_file.LOG,'The Employee contributions Payable Year to Date is missing for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number);

2023: END IF;
2024:
2025: IF l_employee_contrib_y2d IS NULL THEN
2026: populate_run_msg(p_assactid, 'The Employee contributions Payable Year to Date is missing for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number);
2027: fnd_file.put_line (fnd_file.LOG,'The Employee contributions Payable Year to Date is missing for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number);
2028: edi_validation_fail := 'Y';
2029: ELSIF l_ni_category IN ('X','C','W') AND l_employee_contrib_y2d <> 0 THEN
2030: populate_run_msg(p_assactid, 'The Employee contributions Payable Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
2031: fnd_file.put_line (fnd_file.LOG,'The Employee contributions Payable Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');

Line 2031: fnd_file.put_line (fnd_file.LOG,'The Employee contributions Payable Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');

2027: fnd_file.put_line (fnd_file.LOG,'The Employee contributions Payable Year to Date is missing for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number);
2028: edi_validation_fail := 'Y';
2029: ELSIF l_ni_category IN ('X','C','W') AND l_employee_contrib_y2d <> 0 THEN
2030: populate_run_msg(p_assactid, 'The Employee contributions Payable Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
2031: fnd_file.put_line (fnd_file.LOG,'The Employee contributions Payable Year to Date for NI Category '||l_ni_category|| ' of the assignment ' || l_assignment_number||' must be zero.');
2032: edi_validation_fail := 'Y';
2033: END IF;
2034:
2035:

Line 2064: fnd_file.put_line(fnd_file.output,'ECON is missing.');

2060: -- ECON Validations
2061: IF (final_submission = 'Yes - Final for the Year' OR final_submission = 'Yes - Final for Ceased PAYE Ref') AND g_econ_ni_check = 'Y' THEN
2062: IF econ IS NULL THEN
2063: hr_utility.set_location('ECON is missing.',10);
2064: fnd_file.put_line(fnd_file.output,'ECON is missing.');
2065: l_err := true;
2066: END IF;
2067: END IF;
2068: