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

Line 526: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);

522: EXCEPTION
523: WHEN OTHERS THEN
524: hr_utility.trace('Exception in get_expat_indicator end of function block.');
525: hr_utility.trace(SQLCODE || ' - ' || sqlerrm );
526: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
527: return null;
528: END get_expat_indicator;
529:
530:

Line 669: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);

665: EXCEPTION
666: WHEN OTHERS THEN
667: hr_utility.trace('Exception in get_occ_pension_indicator end of function block.');
668: hr_utility.trace(SQLCODE || ' - ' || sqlerrm );
669: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
670: return null;
671: END get_occ_pension_indicator;
672:
673: /* EAS 2013 Changes */

Line 812: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);

808: EXCEPTION
809: WHEN OTHERS THEN
810: hr_utility.trace('Exception in get_pay_non_indiv_ind end of function block.');
811: hr_utility.trace(SQLCODE || ' - ' || sqlerrm );
812: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
813: return null;
814: END get_pay_non_indiv_ind;
815:
816: -- Function to fetch Assignment details (CONTEXT - GB_RTI_ASG_DETAILS)

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

1203:
1204: IF ((l_payroll_id <> ' ' and l_payroll_id IS NOT NULL)
1205: and validate_input(l_payroll_id,'PAYROLLID') > 0) THEN
1206: populate_run_msg(p_assactid,'Payroll ID has invalid characters for the assignment ' || l_assignment_number||'.');
1207: fnd_file.put_line (fnd_file.LOG,'Payroll ID has invalid characters for the assignment ' || l_assignment_number||'.');
1208: edi_validation_fail := 'Y';
1209: END IF;
1210:
1211: IF l_eas_start_asg_date IS NOT NULL

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

1210:
1211: IF l_eas_start_asg_date IS NOT NULL
1212: and date_validate(p_assactid,'UK_EMPL_DATE',l_eas_start_asg_date) = 0 THEN
1213: populate_run_msg(p_assactid,'The start date of employment for the assignment ' || l_assignment_number || ' is invalid.');
1214: fnd_file.put_line (fnd_file.LOG,'The start date of employment for the assignment ' || l_assignment_number || ' is invalid.');
1215: edi_validation_fail := 'Y';
1216: END IF;
1217:
1218:

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

1218:
1219: IF l_eas_end_asg_date IS NOT NULL
1220: and date_validate(p_assactid,'UK_EMPL_DATE_LEAVING',l_eas_end_asg_date) = 0 THEN
1221: populate_run_msg(p_assactid,' The end date of employment for the assignment ' || l_assignment_number || ' is invalid.');
1222: fnd_file.put_line (fnd_file.LOG,'The end date of employment for the assignment ' || l_assignment_number || ' is invalid.');
1223: edi_validation_fail := 'Y';
1224: END IF;
1225:
1226: OPEN get_effective_date;

Line 1242: fnd_file.put_line (fnd_file.LOG,'The Expat indicator for the assignment ' || l_assignment_number || ' is invalid. Verify and submit a valid Expat indicator.');

1238: /*
1239: IF ((l_expat_indicator <> ' ' and l_expat_indicator IS NOT NULL)
1240: and l_expat_indicator <> 'Y') then
1241: populate_run_msg(p_assactid,'The Expat indicator for the assignment ' || l_assignment_number || ' is invalid. Verify and submit a valid Expat indicator.');
1242: fnd_file.put_line (fnd_file.LOG,'The Expat indicator for the assignment ' || l_assignment_number || ' is invalid. Verify and submit a valid Expat indicator.');
1243: edi_validation_fail := 'Y';
1244: END IF;
1245:
1246: IF ((l_occ_pension_indicator <> ' ' and l_occ_pension_indicator IS NOT NULL)

Line 1249: fnd_file.put_line (fnd_file.LOG,'The Occupational Pension indicator for the assignment ' || l_assignment_number || ' is invalid. Verify and submit a valid Occupational Pension indicator.');

1245:
1246: IF ((l_occ_pension_indicator <> ' ' and l_occ_pension_indicator IS NOT NULL)
1247: and l_occ_pension_indicator <> 'Y') then
1248: populate_run_msg(p_assactid,'The Occupational Pension indicator for the assignment ' || l_assignment_number || ' is invalid. Verify and submit a valid Occupational Pension indicator.');
1249: fnd_file.put_line (fnd_file.LOG,'The Occupational Pension indicator for the assignment ' || l_assignment_number || ' is invalid. Verify and submit a valid Occupational Pension indicator.');
1250: edi_validation_fail := 'Y';
1251: END IF;
1252:
1253: IF ((l_pay_non_indiv_ind <> ' ' and l_pay_non_indiv_ind IS NOT NULL)

Line 1256: fnd_file.put_line (fnd_file.LOG,'The Payment to a Non-Individual indicator for the assignment ' || l_assignment_number || ' is invalid. Verify and submit a valid Payment to a Non-Individual indicator.');

1252:
1253: IF ((l_pay_non_indiv_ind <> ' ' and l_pay_non_indiv_ind IS NOT NULL)
1254: and l_pay_non_indiv_ind <> 'Y') then
1255: populate_run_msg(p_assactid,'The Payment to a Non-Individual indicator for the assignment ' || l_assignment_number || ' is invalid. Verify and submit a valid Payment to a Non-Individual indicator.');
1256: fnd_file.put_line (fnd_file.LOG,'The Payment to a Non-Individual indicator for the assignment ' || l_assignment_number || ' is invalid. Verify and submit a valid Payment to a Non-Individual indicator.');
1257: edi_validation_fail := 'Y';
1258: END IF; */
1259:
1260: --Tax code

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

1260: --Tax code
1261:
1262: IF (l_tax_code_in_use = ' ' OR l_tax_code_in_use 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 1272: fnd_file.put_line (fnd_file.LOG,'The Tax Code ' || l_tax_code_in_use || ' for assignment ' || l_assignment_number||' is invalid.');

1268:
1269: IF (l_tax_code_in_use <> ' ' and l_tax_code_in_use IS NOT NULL)
1270: AND (l_msg_value <> ' ') THEN
1271: populate_run_msg(p_assactid,'The Tax Code ' || l_tax_code_in_use || ' for assignment ' || l_assignment_number||' is invalid.');
1272: fnd_file.put_line (fnd_file.LOG,'The Tax Code ' || l_tax_code_in_use || ' for assignment ' || l_assignment_number||' is invalid.');
1273: edi_validation_fail := 'Y';
1274: END IF;
1275:
1276: -- Tax basis validations

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

1277:
1278: --Tax basis cannot be present if tax code is absent
1279: IF (l_tax_basis_in_use <>' ' and l_tax_basis_in_use IS NOT NULL) AND (l_tax_code_in_use = ' ' OR l_tax_code_in_use IS NULL)THEN
1280: populate_run_msg(p_assactid, 'The Tax Code is not present although, Tax Basis is present for assignment ' || l_assignment_number||'.');
1281: fnd_file.put_line (fnd_file.LOG,'The Tax Code is not present although, Tax Basis is present for assignment ' || l_assignment_number||'.');
1282: edi_validation_fail := 'Y';
1283: END IF;
1284:
1285: IF (l_tax_basis_in_use <>' ' AND l_tax_basis_in_use IS NOT NULL) AND (l_tax_basis_in_use <> 'Y' )THEN

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

1283: END IF;
1284:
1285: IF (l_tax_basis_in_use <>' ' AND l_tax_basis_in_use IS NOT NULL) AND (l_tax_basis_in_use <> 'Y' )THEN
1286: populate_run_msg(p_assactid, 'Tax Basis ' ||l_tax_basis_in_use ||' for assignment ' || l_assignment_number||' is invalid.');
1287: fnd_file.put_line (fnd_file.LOG,'Tax Basis ' ||l_tax_basis_in_use ||' for assignment ' || l_assignment_number||' is invalid.');
1288: edi_validation_fail := 'Y';
1289: END IF;
1290:
1291: hr_utility.set_location('Leaving: '||l_proc,111);

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

1378: --Address line 1 and 2 are mandatory as Start date is not null
1379: /* EAS 2013 changes */
1380: IF ((l_address_line1 = ' ' OR l_address_line1 IS NULL) and (l_national_identifier = ' ' OR l_national_identifier IS NULL)) THEN
1381: populate_run_msg(p_assactid,'The Address Line 1 of the assignment ' || l_assignment_number || ' is missing.');
1382: fnd_file.put_line (fnd_file.LOG,'The Address Line 1 of the assignment ' || l_assignment_number || ' is missing.');
1383: edi_validation_fail := 'Y';
1384: l_count_missing_val := l_count_missing_val + 1;
1385: END IF;
1386:

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

1386:
1387: IF l_address_line1 <> ' ' and l_address_line1 IS NOT NULL THEN
1388: IF validate_input(l_address_line1,'ADDRESS') > 0 THEN
1389: populate_run_msg(p_assactid,'The Address Line 1 ' || l_address_line1 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1390: fnd_file.put_line (fnd_file.LOG,'The Address Line 1 ' || l_address_line1 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1391: edi_validation_fail := 'Y';
1392: l_count_char_errors := l_count_char_errors + 1;
1393: end if;
1394: END IF;

Line 1398: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 of the assignment ' || l_assignment_number || ' is missing. Enter either Address Line 2 or Address Line 3 or Town for the assignment.');

1394: END IF;
1395:
1396: IF ((l_address_line2 = ' ' OR l_address_line2 IS NULL) and (l_national_identifier = ' ' OR l_national_identifier IS NULL)) THEN
1397: populate_run_msg(p_assactid,'The Address Line 2 of the assignment ' || l_assignment_number || ' is missing. Enter either Address Line 2 or Address Line 3 or Town for the assignment.');
1398: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 of the assignment ' || l_assignment_number || ' is missing. Enter either Address Line 2 or Address Line 3 or Town for the assignment.');
1399: edi_validation_fail := 'Y';
1400: l_count_missing_val := l_count_missing_val + 1;
1401: end if;
1402:

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

1402:
1403: IF l_address_line2 <> ' ' and l_address_line2 IS NOT NULL THEN
1404: IF validate_input(l_address_line2,'ADDRESS') > 0 THEN
1405: populate_run_msg(p_assactid,'The Address Line 2 ' || l_address_line2 || ' of the assignment '|| l_assignment_number || ' has invalid characters.');
1406: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 ' || l_address_line2 || ' of the assignment '|| l_assignment_number || ' has invalid characters.');
1407: edi_validation_fail := 'Y';
1408: l_count_char_errors := l_count_char_errors + 1;
1409: end if;
1410: end if;

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

1411:
1412: IF l_address_line3 <> ' ' and l_address_line3 IS NOT NULL THEN
1413: IF validate_input(l_address_line3,'ADDRESS') > 0 THEN
1414: populate_run_msg(p_assactid,'The Address Line 3 ' || l_address_line3 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1415: fnd_file.put_line (fnd_file.LOG,'The Address Line 3 ' || l_address_line3 || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1416: edi_validation_fail := 'Y';
1417: l_count_char_errors := l_count_char_errors + 1;
1418: END IF;
1419: END IF;

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

1420:
1421: IF l_town_or_city <> ' ' and l_town_or_city IS NOT NULL THEN
1422: IF validate_input(l_town_or_city,'ADDRESS') > 0 THEN
1423: populate_run_msg(p_assactid,'The Town or City ' || l_town_or_city || ' of the assignment '|| l_assignment_number || ' has invalid characters.');
1424: fnd_file.put_line (fnd_file.LOG,'The Town or City ' || l_town_or_city ||' of the assignment ' || l_assignment_number || ' has invalid characters.');
1425: edi_validation_fail := 'Y';
1426: l_count_char_errors := l_count_char_errors + 1;
1427: END IF;
1428: END IF;

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

1429:
1430: IF l_country <> ' ' and l_country IS NOT NULL THEN
1431: IF validate_input(l_country,'COUNTRY') > 0 THEN
1432: populate_run_msg(p_assactid,'The Country ' || l_country || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1433: fnd_file.put_line (fnd_file.LOG,'The Country ' || l_country || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1434: edi_validation_fail := 'Y';
1435: l_count_char_errors := l_count_char_errors + 1;
1436: END IF;
1437: END IF;

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

1438:
1439: IF l_postal_code <> ' ' and l_postal_code IS NOT NULL THEN
1440: IF validate_input(l_postal_code,'POSTALCODE') > 0 THEN
1441: populate_run_msg(p_assactid,'The Postal Code ' || l_postal_code || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1442: fnd_file.put_line (fnd_file.LOG,'The Postal Code ' || l_postal_code || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1443: edi_validation_fail := 'Y';
1444: l_count_char_errors := l_count_char_errors + 1;
1445: END IF;
1446: END IF;

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

1448: --person validation
1449:
1450: IF l_last_name = ' ' OR l_last_name is null THEN
1451: populate_run_msg(p_assactid,'The Last Name of the assignment ' || l_assignment_number || ' is missing.');
1452: fnd_file.put_line (fnd_file.LOG,'The Last Name of the assignment '|| l_assignment_number || ' is missing.');
1453: edi_validation_fail := 'Y';
1454: l_count_missing_val := l_count_missing_val + 1;
1455:
1456: elsif validate_input(l_last_name,'NAME') > 0 then

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

1454: l_count_missing_val := l_count_missing_val + 1;
1455:
1456: elsif validate_input(l_last_name,'NAME') > 0 then
1457: populate_run_msg(p_assactid,'The Last Name ' || l_last_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1458: fnd_file.put_line (fnd_file.LOG,'The Last Name ' || l_last_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1459: edi_validation_fail := 'Y';
1460: l_count_char_errors := l_count_char_errors + 1;
1461: END IF;
1462:

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

1461: END IF;
1462:
1463: IF l_first_name = ' ' OR l_first_name is null THEN
1464: populate_run_msg(p_assactid,'The First Name of the assignment '|| l_assignment_number || ' is missing.');
1465: fnd_file.put_line (fnd_file.LOG,'The First Name of the assignment ' || l_assignment_number || ' is missing.');
1466: edi_validation_fail := 'Y';
1467: l_count_missing_val := l_count_missing_val + 1;
1468:
1469: ELSIF validate_input(l_first_name,'NAME') > 0 THEN

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

1467: l_count_missing_val := l_count_missing_val + 1;
1468:
1469: ELSIF validate_input(l_first_name,'NAME') > 0 THEN
1470: populate_run_msg(p_assactid,'The First Name ' || l_first_name ||' of the assignment ' || l_assignment_number || ' has invalid characters.');
1471: fnd_file.put_line (fnd_file.LOG,'The First Name ' || l_first_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1472: edi_validation_fail := 'Y';
1473: l_count_char_errors := l_count_char_errors + 1;
1474: END IF;
1475:

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

1475:
1476: IF l_middle_name <> ' ' AND l_middle_name is not null THEN
1477: IF validate_input(l_middle_name,'NAME') > 0 THEN
1478: populate_run_msg(p_assactid,'The Middle Name ' || l_middle_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1479: fnd_file.put_line (fnd_file.LOG,'The Middle Name ' || l_middle_name || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1480: edi_validation_fail := 'Y';
1481: l_count_char_errors := l_count_char_errors + 1;
1482: END IF;
1483: END IF;

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

1485:
1486: IF l_title <> ' ' AND l_title is not null THEN
1487: IF validate_input(l_title,'TITLE') > 0 THEN
1488: populate_run_msg(p_assactid,'The Title ' || l_title || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1489: fnd_file.put_line (fnd_file.LOG,'The Title ' || l_title || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1490: edi_validation_fail := 'Y';
1491: l_count_char_errors := l_count_char_errors + 1;
1492: END IF;
1493: END IF;

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

1494:
1495: IF l_national_identifier is not null AND
1496: hr_gb_utility.ni_validate(l_national_identifier,p_effective_date) <> 0 THEN
1497: populate_run_msg(p_assactid,'The National Insurance number ' || l_national_identifier || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1498: fnd_file.put_line (fnd_file.LOG,'The National Insurance number ' || l_national_identifier || ' of the assignment ' || l_assignment_number || ' has invalid characters.');
1499: edi_validation_fail := 'Y';
1500: END IF;
1501:
1502: IF ((l_sex <> 'M' AND l_sex <> 'F') OR (l_sex = ' ' OR l_sex IS NULL)) THEN

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

1500: END IF;
1501:
1502: IF ((l_sex <> 'M' AND l_sex <> 'F') OR (l_sex = ' ' OR l_sex IS NULL)) THEN
1503: populate_run_msg(p_assactid,'Gender is not specified for the assignment ' || l_assignment_number||'.');
1504: fnd_file.put_line (fnd_file.LOG,'Gender is not specified for the assignment ' || l_assignment_number||'.');
1505: edi_validation_fail := 'Y';
1506: END IF;
1507:
1508: /* EAS 2013 changes */

Line 1511: fnd_file.put_line (fnd_file.LOG,'The Date of Birth of the assignment ' || l_assignment_number || ' is missing. Enter a date of birth for the assignment.');

1507:
1508: /* EAS 2013 changes */
1509: IF ((l_date_of_birth IS NULL) and (l_pay_non_indiv_ind = ' ' or l_pay_non_indiv_ind IS NULL)) THEN
1510: populate_run_msg(p_assactid,'The Date of Birth of the assignment ' || l_assignment_number || ' is missing. Enter a date of birth for the assignment.');
1511: fnd_file.put_line (fnd_file.LOG,'The Date of Birth of the assignment ' || l_assignment_number || ' is missing. Enter a date of birth for the assignment.');
1512: edi_validation_fail := 'Y';
1513: END IF;
1514:
1515: /*

Line 1518: fnd_file.put_line (fnd_file.LOG,'Date of Birth present for a non_individual. Please remove and resubmit');

1514:
1515: /*
1516: IF ((l_date_of_birth IS not NULL) and (l_pay_non_indiv_ind <> ' ' or l_pay_non_indiv_ind IS not NULL)) THEN
1517: populate_run_msg(p_assactid,'Date of Birth present for a non_individual. Please remove and resubmit');
1518: fnd_file.put_line (fnd_file.LOG,'Date of Birth present for a non_individual. Please remove and resubmit');
1519: edi_validation_fail := 'Y';
1520: END IF;*/
1521:
1522: IF ((l_date_of_birth > p_effective_date) OR (l_year1 > 130)) THEN

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

1520: END IF;*/
1521:
1522: IF ((l_date_of_birth > p_effective_date) OR (l_year1 > 130)) THEN
1523: populate_run_msg(p_assactid,'The Date of Birth of the assignment ' || l_assignment_number || ' is invalid.');
1524: fnd_file.put_line (fnd_file.LOG,'The Date of Birth of the assignment '|| l_assignment_number || ' is invalid.');
1525: edi_validation_fail := 'Y';
1526: END IF;
1527:
1528: hr_utility.set_location('Leaving'||l_proc,10);

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

1605:
1606:
1607: IF l_address_line1 = ' ' OR l_address_line1 IS NULL THEN
1608: populate_run_msg(p_assactid,'The Address Line 1 of the employee ' || l_employee_number || ' is missing.');
1609: fnd_file.put_line (fnd_file.LOG,'The Address Line 1 of the employee ' || l_employee_number || ' is missing.');
1610: edi_validation_fail := 'Y';
1611: l_count_missing_val := l_count_missing_val + 1;
1612:
1613: elsIF validate_input(l_address_line1,'ADDRESS') > 0 THEN

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

1611: l_count_missing_val := l_count_missing_val + 1;
1612:
1613: elsIF validate_input(l_address_line1,'ADDRESS') > 0 THEN
1614: populate_run_msg(p_assactid,'The Address Line 1 ' || l_address_line1 || ' of the employee ' || l_employee_number || ' has invalid characters.');
1615: fnd_file.put_line (fnd_file.LOG,'The Address Line 1 ' || l_address_line1 || ' of the employee ' || l_employee_number || ' has invalid characters.');
1616: edi_validation_fail := 'Y';
1617: l_count_char_errors := l_count_char_errors + 1;
1618: end if;
1619:

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

1618: end if;
1619:
1620: IF l_address_line2 = ' ' OR l_address_line2 IS NULL THEN
1621: populate_run_msg(p_assactid,'The Address Line 2 of the employee ' || l_employee_number || ' is missing.');
1622: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 of the employee ' || l_employee_number || ' is missing.');
1623: edi_validation_fail := 'Y';
1624: l_count_missing_val := l_count_missing_val + 1;
1625:
1626: elsIF validate_input(l_address_line2,'ADDRESS') > 0 THEN

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

1624: l_count_missing_val := l_count_missing_val + 1;
1625:
1626: elsIF validate_input(l_address_line2,'ADDRESS') > 0 THEN
1627: populate_run_msg(p_assactid,'The Address Line 2 ' || l_address_line2 || ' of the employee '|| l_employee_number || ' has invalid characters.');
1628: fnd_file.put_line (fnd_file.LOG,'The Address Line 2 ' || l_address_line2 || ' of the employee '|| l_employee_number || ' has invalid characters.');
1629: edi_validation_fail := 'Y';
1630: l_count_char_errors := l_count_char_errors + 1;
1631: end if;
1632:

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

1632:
1633: IF l_address_line3 <> ' ' and l_address_line3 IS NOT NULL THEN
1634: IF validate_input(l_address_line3,'ADDRESS') > 0 THEN
1635: populate_run_msg(p_assactid,'The Address Line 3 ' || l_address_line3 || ' of the employee ' || l_employee_number || ' has invalid characters.');
1636: fnd_file.put_line (fnd_file.LOG,'The Address Line 3 ' || l_address_line3 || ' of the employee ' || l_employee_number || ' has invalid characters.');
1637: edi_validation_fail := 'Y';
1638: l_count_char_errors := l_count_char_errors + 1;
1639: END IF;
1640: END IF;

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

1641:
1642: IF l_town_or_city <> ' ' and l_town_or_city IS NOT NULL THEN
1643: IF validate_input(l_town_or_city,'ADDRESS') > 0 THEN
1644: populate_run_msg(p_assactid,'The Town or City ' || l_town_or_city || ' of the employee '|| l_employee_number || ' has invalid characters.');
1645: fnd_file.put_line (fnd_file.LOG,'The Town or City ' || l_town_or_city ||' of the employee ' || l_employee_number || ' has invalid characters.');
1646: edi_validation_fail := 'Y';
1647: l_count_char_errors := l_count_char_errors + 1;
1648: END IF;
1649: END IF;

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

1650:
1651: IF l_country <> ' ' and l_country IS NOT NULL THEN
1652: IF validate_input(l_country,'COUNTRY') > 0 THEN
1653: populate_run_msg(p_assactid,'The Country ' || l_country || ' of the employee ' || l_employee_number || ' has invalid characters.');
1654: fnd_file.put_line (fnd_file.LOG,'The Country ' || l_country || ' of the employee ' || l_employee_number || ' has invalid characters.');
1655: edi_validation_fail := 'Y';
1656: l_count_char_errors := l_count_char_errors + 1;
1657: END IF;
1658: END IF;

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

1659:
1660: IF l_postal_code <> ' ' and l_postal_code IS NOT NULL THEN
1661: IF validate_input(l_postal_code,'POSTALCODE') > 0 THEN
1662: populate_run_msg(p_assactid,'The Postal Code ' || l_postal_code || ' of the employee ' || l_employee_number || ' has invalid characters.');
1663: fnd_file.put_line (fnd_file.LOG,'The Postal Code ' || l_postal_code || ' of the employee ' || l_employee_number || ' has invalid characters.');
1664: edi_validation_fail := 'Y';
1665: l_count_char_errors := l_count_char_errors + 1;
1666: END IF;
1667: END IF;

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

1669: --person validation
1670:
1671: IF l_last_name = ' ' OR l_last_name is null THEN
1672: populate_run_msg(p_assactid,'The Last Name of the employee ' || l_employee_number || ' is missing.');
1673: fnd_file.put_line (fnd_file.LOG,'The Last Name of the employee '|| l_employee_number || ' is missing.');
1674: edi_validation_fail := 'Y';
1675: l_count_missing_val := l_count_missing_val + 1;
1676:
1677: elsif validate_input(l_last_name,'NAME') > 0 then

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

1675: l_count_missing_val := l_count_missing_val + 1;
1676:
1677: elsif validate_input(l_last_name,'NAME') > 0 then
1678: populate_run_msg(p_assactid,'The Last Name ' || l_last_name || ' of the employee ' || l_employee_number || ' has invalid characters.');
1679: fnd_file.put_line (fnd_file.LOG,'The Last Name ' || l_last_name || ' of the employee ' || l_employee_number || ' has invalid characters.');
1680: edi_validation_fail := 'Y';
1681: l_count_char_errors := l_count_char_errors + 1;
1682: END IF;
1683:

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

1682: END IF;
1683:
1684: IF l_first_name = ' ' OR l_first_name is null THEN
1685: populate_run_msg(p_assactid,'The First Name of the employee '|| l_employee_number || ' is missing.');
1686: fnd_file.put_line (fnd_file.LOG,'The First Name of the employee ' || l_employee_number || ' is missing.');
1687: edi_validation_fail := 'Y';
1688: l_count_missing_val := l_count_missing_val + 1;
1689:
1690: ELSIF validate_input(l_first_name,'NAME') > 0 THEN

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

1688: l_count_missing_val := l_count_missing_val + 1;
1689:
1690: ELSIF validate_input(l_first_name,'NAME') > 0 THEN
1691: populate_run_msg(p_assactid,'The First Name ' || l_first_name ||' of the employee ' || l_employee_number || ' has invalid characters.');
1692: fnd_file.put_line (fnd_file.LOG,'The First Name ' || l_first_name || ' of the employee ' || l_employee_number || ' has invalid characters.');
1693: edi_validation_fail := 'Y';
1694: l_count_char_errors := l_count_char_errors + 1;
1695: END IF;
1696:

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

1696:
1697: IF l_middle_name <> ' ' AND l_middle_name is not null THEN
1698: IF validate_input(l_middle_name,'NAME') > 0 THEN
1699: populate_run_msg(p_assactid,'The First Name ' || l_middle_name || ' of the employee ' || l_employee_number || ' has invalid characters.');
1700: fnd_file.put_line (fnd_file.LOG,'The First Name ' || l_middle_name || ' of the employee ' || l_employee_number || ' has invalid characters.');
1701: edi_validation_fail := 'Y';
1702: l_count_char_errors := l_count_char_errors + 1;
1703: END IF;
1704: END IF;

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

1706:
1707: IF l_title <> ' ' AND l_title is not null THEN
1708: IF validate_input(l_title,'TITLE') > 0 THEN
1709: populate_run_msg(p_assactid,'The Title ' || l_title || ' of the employee ' || l_employee_number || ' has invalid characters.');
1710: fnd_file.put_line (fnd_file.LOG,'The Title ' || l_title || ' of the employee ' || l_employee_number || ' has invalid characters.');
1711: edi_validation_fail := 'Y';
1712: l_count_char_errors := l_count_char_errors + 1;
1713: END IF;
1714: END IF;

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

1715:
1716: IF l_national_identifier is not null AND
1717: hr_gb_utility.ni_validate(l_national_identifier,sysdate) <> 0 THEN
1718: populate_run_msg(p_assactid,'The National Insurance number ' || l_national_identifier || ' of the employee ' || l_employee_number || ' has invalid characters.');
1719: fnd_file.put_line (fnd_file.LOG,'The National Insurance number ' || l_national_identifier || ' of the employee ' || l_employee_number || ' has invalid characters.');
1720: edi_validation_fail := 'Y';
1721: END IF;
1722:
1723: IF ((l_sex <> 'M' AND l_sex <> 'F') OR (l_sex = ' ' OR l_sex IS NULL)) THEN

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

1721: END IF;
1722:
1723: IF ((l_sex <> 'M' AND l_sex <> 'F') OR (l_sex = ' ' OR l_sex IS NULL)) THEN
1724: populate_run_msg(p_assactid,'Gender is not specified for the employee ' || l_employee_number||'.');
1725: fnd_file.put_line (fnd_file.LOG,'Gender is not specified for the employee ' || l_employee_number||'.');
1726: edi_validation_fail := 'Y';
1727: END IF;
1728:
1729: IF l_date_of_birth IS NULL THEN

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

1727: END IF;
1728:
1729: IF l_date_of_birth IS NULL THEN
1730: populate_run_msg(p_assactid,'The Date of Birth of the employee ' || l_employee_number || ' is missing.');
1731: fnd_file.put_line (fnd_file.LOG,'The Date of Birth of the employee '|| l_employee_number || ' is missing.');
1732: edi_validation_fail := 'Y';
1733: END IF;
1734:
1735: IF ((l_date_of_birth > sysdate) OR (l_year1 > 130)) THEN

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

1733: END IF;
1734:
1735: IF ((l_date_of_birth > sysdate) OR (l_year1 > 130)) THEN
1736: populate_run_msg(p_assactid,'The Date of Birth of the employee ' || l_employee_number || ' is invalid.');
1737: fnd_file.put_line (fnd_file.LOG,'The Date of Birth of the employee '|| l_employee_number || ' is invalid.');
1738: edi_validation_fail := 'Y';
1739: END IF;
1740:
1741: hr_utility.set_location('Leaving'||l_proc,10);

Line 2192: fnd_file.put_line(fnd_file.output,'Effective Date must be later than 06-April-2013.');

2188: /* EAS 2013 Changes*/
2189:
2190: if l_payroll_rec.effective_date < fnd_date.canonical_to_date('2013/04/06 00:00:00') then
2191: hr_utility.set_location('Effective Date must be later than 06-April-2013',10);
2192: fnd_file.put_line(fnd_file.output,'Effective Date must be later than 06-April-2013.');
2193: l_err := true;
2194: end if;
2195: if l_payroll_rec.no_of_parts = ' ' or l_payroll_rec.no_of_parts is null then
2196: hr_utility.set_location('Enter the Number of Parts for Submission. This is a mandatory field.',10);

Line 2197: fnd_file.put_line(fnd_file.output,'Enter the Number of Parts for Submission. This is a mandatory field.');

2193: l_err := true;
2194: end if;
2195: if l_payroll_rec.no_of_parts = ' ' or l_payroll_rec.no_of_parts is null then
2196: hr_utility.set_location('Enter the Number of Parts for Submission. This is a mandatory field.',10);
2197: fnd_file.put_line(fnd_file.output,'Enter the Number of Parts for Submission. This is a mandatory field.');
2198: l_err := true;
2199: elsif substr(l_payroll_rec.no_of_parts,1,2) = '00' or substr(l_payroll_rec.no_of_parts,1,2) ='0'
2200: then
2201: hr_utility.set_location('Number of Parts '||l_payroll_rec.no_of_parts||' must be numeric and in the range of 01 to 99 only.',10);

Line 2202: fnd_file.put_line(fnd_file.output,'Number of Parts '||l_payroll_rec.no_of_parts||' must be numeric and in the range of 01 to 99 only.');

2198: l_err := true;
2199: elsif substr(l_payroll_rec.no_of_parts,1,2) = '00' or substr(l_payroll_rec.no_of_parts,1,2) ='0'
2200: then
2201: hr_utility.set_location('Number of Parts '||l_payroll_rec.no_of_parts||' must be numeric and in the range of 01 to 99 only.',10);
2202: fnd_file.put_line(fnd_file.output,'Number of Parts '||l_payroll_rec.no_of_parts||' must be numeric and in the range of 01 to 99 only.');
2203: l_err := true;
2204: elsif validate_input(substr(l_payroll_rec.no_of_parts,1,2),'NUMBER') > 0
2205: then
2206: hr_utility.set_location('Number of Parts '||l_payroll_rec.no_of_parts||' must be numeric and in the range of 01 to 99 only.',10);

Line 2207: fnd_file.put_line(fnd_file.output,'Number of Parts '||l_payroll_rec.no_of_parts||' must be numeric and in the range of 01 to 99 only.');

2203: l_err := true;
2204: elsif validate_input(substr(l_payroll_rec.no_of_parts,1,2),'NUMBER') > 0
2205: then
2206: hr_utility.set_location('Number of Parts '||l_payroll_rec.no_of_parts||' must be numeric and in the range of 01 to 99 only.',10);
2207: fnd_file.put_line(fnd_file.output,'Number of Parts '||l_payroll_rec.no_of_parts||' must be numeric and in the range of 01 to 99 only.');
2208: l_err := true;
2209: end if;
2210:
2211: if ((l_payroll_rec.unique_part_id = ' ' or l_payroll_rec.unique_part_id is null) and (l_payroll_rec.no_of_parts > 1)) then

Line 2213: fnd_file.put_line(fnd_file.output,'The value in the Number of Parts field is greater than 01. The Unique Part Identifier field is now mandatory. Enter a value for the Unique Part Identifier.');

2209: end if;
2210:
2211: if ((l_payroll_rec.unique_part_id = ' ' or l_payroll_rec.unique_part_id is null) and (l_payroll_rec.no_of_parts > 1)) then
2212: hr_utility.set_location('The value in the Number of Parts field is greater than 01. The Unique Part Identifier field is now mandatory. Enter a value for the Unique Part Identifier.',10);
2213: fnd_file.put_line(fnd_file.output,'The value in the Number of Parts field is greater than 01. The Unique Part Identifier field is now mandatory. Enter a value for the Unique Part Identifier.');
2214: l_err := true;
2215: elsif (check_resubmission(pactid,l_paye_ref,l_payroll_rec.unique_part_id,l_payroll_rec.business_group_id) = 'Y')
2216: then
2217: hr_utility.set_location('The Unique Part Identifier '||l_payroll_rec.unique_part_id|| ' has been previously used. Change the Unique Part Identifier and resubmit.',10);

Line 2218: fnd_file.put_line(fnd_file.output,'The Unique Part Identifier '||l_payroll_rec.unique_part_id|| ' has been previously used. Change the Unique Part Identifier and resubmit.');

2214: l_err := true;
2215: elsif (check_resubmission(pactid,l_paye_ref,l_payroll_rec.unique_part_id,l_payroll_rec.business_group_id) = 'Y')
2216: then
2217: hr_utility.set_location('The Unique Part Identifier '||l_payroll_rec.unique_part_id|| ' has been previously used. Change the Unique Part Identifier and resubmit.',10);
2218: fnd_file.put_line(fnd_file.output,'The Unique Part Identifier '||l_payroll_rec.unique_part_id|| ' has been previously used. Change the Unique Part Identifier and resubmit.');
2219: l_err := true;
2220:
2221:
2222: elsif validate_input(substr(l_payroll_rec.unique_part_id,1,12),'UNIQUE_PART_ID') > 0

Line 2225: fnd_file.put_line(fnd_file.output,'The Unique Part Identifier '||l_payroll_rec.unique_part_id||' has invalid characters. Verify and submit a valid Unique Part Identifier.');

2221:
2222: elsif validate_input(substr(l_payroll_rec.unique_part_id,1,12),'UNIQUE_PART_ID') > 0
2223: then
2224: hr_utility.set_location('The Unique Part Identifier '||l_payroll_rec.unique_part_id||' has invalid characters. Verify and submit a valid Unique Part Identifier.',10);
2225: fnd_file.put_line(fnd_file.output,'The Unique Part Identifier '||l_payroll_rec.unique_part_id||' has invalid characters. Verify and submit a valid Unique Part Identifier.');
2226: l_err := true;
2227: end if;
2228: END IF;
2229:

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

2559: */
2560: -- P45 check.If issued do not pick the assignment
2561: /*
2562: if asg_rec.status = 'TERM_ASSIGN' and pay_p45_pkg.return_p45_issued_flag(asg_rec.assignment_id) = 'Y' then
2563: fnd_file.put_line (fnd_file.LOG,'Terminated Asg '||asg_rec.assignment_id||' found.P45 issued.');
2564: l_flag:= 'N';
2565: end if;*/
2566:
2567: -- If Terminated before start of the Tax Year. Ignore the assignment

Line 2916: fnd_file.put_line(fnd_file.output,'The Sender Id is missing.');

2912: hr_utility.set_location('Calling header validations', 10);
2913:
2914: if l_payroll_rec.sender_id = ' ' or l_payroll_rec.sender_id is null then
2915: hr_utility.set_location('The Sender Id is missing.',10);
2916: fnd_file.put_line(fnd_file.output,'The Sender Id is missing.');
2917: l_err := true;
2918: end if;
2919:
2920: if l_payroll_rec.tax_office_no = ' ' or l_payroll_rec.tax_office_no is null then

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

2918: end if;
2919:
2920: if l_payroll_rec.tax_office_no = ' ' or l_payroll_rec.tax_office_no is null then
2921: hr_utility.set_location('The HMRC Office Number is missing.',10);
2922: fnd_file.put_line(fnd_file.output,'The HMRC Office Number is missing.');
2923: l_err := true;
2924: elsif validate_input(substr(l_payroll_rec.tax_office_no,1,3),'NUMBER') > 0
2925: then
2926: hr_utility.set_location('The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.',10);

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

2923: l_err := true;
2924: elsif validate_input(substr(l_payroll_rec.tax_office_no,1,3),'NUMBER') > 0
2925: then
2926: hr_utility.set_location('The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.',10);
2927: fnd_file.put_line(fnd_file.output,'The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.');
2928: l_err := true;
2929: end if;
2930:
2931: if l_payroll_rec.tax_ref_no = ' ' or l_payroll_rec.tax_ref_no is null then

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

2929: end if;
2930:
2931: if l_payroll_rec.tax_ref_no = ' ' or l_payroll_rec.tax_ref_no is null then
2932: hr_utility.set_location('The Employer PAYE Reference is missing.',10);
2933: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference is missing.');
2934: l_err := true;
2935: elsif validate_input(l_payroll_rec.tax_ref_no,'FULL_EDI') > 0 then
2936: hr_utility.set_location('The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.',10);
2937: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.');

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

2933: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference is missing.');
2934: l_err := true;
2935: elsif validate_input(l_payroll_rec.tax_ref_no,'FULL_EDI') > 0 then
2936: hr_utility.set_location('The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.',10);
2937: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.');
2938: l_err := true;
2939: end if;
2940:
2941: if l_payroll_rec.employer_name = ' ' or l_payroll_rec.employer_name is null then

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

2939: end if;
2940:
2941: if l_payroll_rec.employer_name = ' ' or l_payroll_rec.employer_name is null then
2942: hr_utility.set_location('The Employer Name is missing.',10);
2943: fnd_file.put_line(fnd_file.output,'The Employer Name is missing.');
2944: l_err := true;
2945: elsif validate_input(l_payroll_rec.employer_name,'EMP_NAME') > 0 then
2946: hr_utility.set_location('The Employer Name '||l_payroll_rec.employer_name||' has invalid characters.',10);
2947: fnd_file.put_line(fnd_file.output,'The Employer Name '||l_payroll_rec.employer_name||' has invalid characters.');

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

2943: fnd_file.put_line(fnd_file.output,'The Employer Name is missing.');
2944: l_err := true;
2945: elsif validate_input(l_payroll_rec.employer_name,'EMP_NAME') > 0 then
2946: hr_utility.set_location('The Employer Name '||l_payroll_rec.employer_name||' has invalid characters.',10);
2947: fnd_file.put_line(fnd_file.output,'The Employer Name '||l_payroll_rec.employer_name||' has invalid characters.');
2948: l_err := true;
2949: end if;
2950:
2951: if l_payroll_rec.acc_ref_no = ' ' or l_payroll_rec.acc_ref_no is null then

Line 2953: fnd_file.put_line(fnd_file.output,'The Employer Accounts Office Ref is missing.');

2949: end if;
2950:
2951: if l_payroll_rec.acc_ref_no = ' ' or l_payroll_rec.acc_ref_no is null then
2952: hr_utility.set_location('The Employer Accounts Office Ref is missing.',10);
2953: fnd_file.put_line(fnd_file.output,'The Employer Accounts Office Ref is missing.');
2954: l_err := true;
2955:
2956: elsif (length(l_payroll_rec.acc_ref_no) > 13
2957: OR REGEXP_INSTR(l_payroll_rec.acc_ref_no,'^([[:digit:]]{1,3})P([[:alpha:]]{1})([[:digit:]]{1,7})([[:digit:]]|X)$') = 0 ) THEN

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

2956: elsif (length(l_payroll_rec.acc_ref_no) > 13
2957: OR REGEXP_INSTR(l_payroll_rec.acc_ref_no,'^([[:digit:]]{1,3})P([[:alpha:]]{1})([[:digit:]]{1,7})([[:digit:]]|X)$') = 0 ) THEN
2958:
2959: hr_utility.set_location ('Incorrect format entered for Employer Accounts Office Ref field. Valid format is NNNPANNNNNNNX.',10);
2960: fnd_file.put_line(fnd_file.output,'Incorrect format entered for Employer Accounts Office Ref field. Valid format is NNNPANNNNNNNX.');
2961: l_err := true;
2962: END IF;
2963:
2964: END IF;

Line 3172: fnd_file.put_line (fnd_file.LOG,'There are aggregated assignments for an ExPat but indicators are not set across all assignments');

3168: if(((l_prev_expat <> '' or l_prev_expat is not null)and (l_expat = '' or l_expat is null))
3169: or ((l_prev_expat = '' or l_prev_expat is null) and (l_expat <> '' or l_expat is not null))
3170: or ((l_prev_expat <> '' or l_prev_expat is not null)and (l_expat <> '' or l_expat is not null)and (l_prev_expat <> l_expat))) then
3171: populate_run_msg(p_assactid,'There are aggregated assignments for an ExPat but indicators are not set across all assignments');
3172: fnd_file.put_line (fnd_file.LOG,'There are aggregated assignments for an ExPat but indicators are not set across all assignments');
3173: l_error :='Y';
3174: end if;
3175: if(((l_prev_occ_pension <> '' or l_prev_occ_pension is not null) and (l_occ_pension = '' or l_occ_pension is null))
3176: or ((l_prev_occ_pension = '' or l_prev_occ_pension is null) and (l_occ_pension <> '' or l_occ_pension is not null))

Line 3179: fnd_file.put_line (fnd_file.LOG,'There are aggregated assignments for the pensioner but indicators are not set across all assignments.');

3175: if(((l_prev_occ_pension <> '' or l_prev_occ_pension is not null) and (l_occ_pension = '' or l_occ_pension is null))
3176: or ((l_prev_occ_pension = '' or l_prev_occ_pension is null) and (l_occ_pension <> '' or l_occ_pension is not null))
3177: or ((l_prev_occ_pension <> '' or l_prev_occ_pension is not null)and (l_occ_pension <> '' or l_occ_pension is not null)and (l_prev_occ_pension <> l_occ_pension)))then
3178: populate_run_msg(p_assactid,'There are aggregated assignments for the pensioner but indicators are not set across all assignments.');
3179: fnd_file.put_line (fnd_file.LOG,'There are aggregated assignments for the pensioner but indicators are not set across all assignments.');
3180: l_error :='Y';
3181: end if;
3182: if(((l_prev_pay_non_indiv <> '' or l_prev_pay_non_indiv is not null)and (l_pay_non_indiv = '' or l_pay_non_indiv is null))
3183: or ((l_prev_pay_non_indiv = '' or l_prev_pay_non_indiv is null) and (l_pay_non_indiv <> '' or l_pay_non_indiv is not null))

Line 3186: fnd_file.put_line (fnd_file.LOG,'There are aggregated assignments for payment to a non-individual but indicators are not set across all assignments.');

3182: if(((l_prev_pay_non_indiv <> '' or l_prev_pay_non_indiv is not null)and (l_pay_non_indiv = '' or l_pay_non_indiv is null))
3183: or ((l_prev_pay_non_indiv = '' or l_prev_pay_non_indiv is null) and (l_pay_non_indiv <> '' or l_pay_non_indiv is not null))
3184: or ((l_prev_pay_non_indiv <> '' or l_prev_pay_non_indiv is not null)and (l_pay_non_indiv <> '' or l_pay_non_indiv is not null)and (l_prev_pay_non_indiv <> l_pay_non_indiv))) then
3185: populate_run_msg(p_assactid,'There are aggregated assignments for payment to a non-individual but indicators are not set across all assignments');
3186: fnd_file.put_line (fnd_file.LOG,'There are aggregated assignments for payment to a non-individual but indicators are not set across all assignments.');
3187: l_error :='Y';
3188: end if;
3189: if l_error = 'Y' then
3190: close fetch_all_paye_agg_asg;

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

3490: l_form_name :='NINO Verification Request Process';
3491: end if;
3492:
3493: /* EAS 2013 Changes */
3494: fnd_file.put_line(fnd_file.output,' ');
3495: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
3496: fnd_file.put_line(fnd_file.output,' ');
3497: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
3498: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);

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

3491: end if;
3492:
3493: /* EAS 2013 Changes */
3494: fnd_file.put_line(fnd_file.output,' ');
3495: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
3496: fnd_file.put_line(fnd_file.output,' ');
3497: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
3498: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
3499: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));

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

3492:
3493: /* EAS 2013 Changes */
3494: fnd_file.put_line(fnd_file.output,' ');
3495: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
3496: fnd_file.put_line(fnd_file.output,' ');
3497: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
3498: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
3499: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
3500: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);

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

3493: /* EAS 2013 Changes */
3494: fnd_file.put_line(fnd_file.output,' ');
3495: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
3496: fnd_file.put_line(fnd_file.output,' ');
3497: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
3498: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
3499: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
3500: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
3501: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);

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

3494: fnd_file.put_line(fnd_file.output,' ');
3495: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
3496: fnd_file.put_line(fnd_file.output,' ');
3497: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
3498: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
3499: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
3500: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
3501: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
3502: fnd_file.put_line(fnd_file.output,rpad('Number of Parts : ',32) || l_no_of_parts);

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

3495: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
3496: fnd_file.put_line(fnd_file.output,' ');
3497: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
3498: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
3499: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
3500: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
3501: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
3502: fnd_file.put_line(fnd_file.output,rpad('Number of Parts : ',32) || l_no_of_parts);
3503: --fnd_file.put_line(fnd_file.output,rpad('Part : ',32) || g_part_no);

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

3496: fnd_file.put_line(fnd_file.output,' ');
3497: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
3498: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
3499: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
3500: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
3501: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
3502: fnd_file.put_line(fnd_file.output,rpad('Number of Parts : ',32) || l_no_of_parts);
3503: --fnd_file.put_line(fnd_file.output,rpad('Part : ',32) || g_part_no);
3504: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));

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

3497: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
3498: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
3499: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
3500: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
3501: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
3502: fnd_file.put_line(fnd_file.output,rpad('Number of Parts : ',32) || l_no_of_parts);
3503: --fnd_file.put_line(fnd_file.output,rpad('Part : ',32) || g_part_no);
3504: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
3505: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);

Line 3502: fnd_file.put_line(fnd_file.output,rpad('Number of Parts : ',32) || l_no_of_parts);

3498: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
3499: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
3500: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
3501: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
3502: fnd_file.put_line(fnd_file.output,rpad('Number of Parts : ',32) || l_no_of_parts);
3503: --fnd_file.put_line(fnd_file.output,rpad('Part : ',32) || g_part_no);
3504: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
3505: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
3506: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);

Line 3503: --fnd_file.put_line(fnd_file.output,rpad('Part : ',32) || g_part_no);

3499: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
3500: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
3501: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
3502: fnd_file.put_line(fnd_file.output,rpad('Number of Parts : ',32) || l_no_of_parts);
3503: --fnd_file.put_line(fnd_file.output,rpad('Part : ',32) || g_part_no);
3504: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
3505: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
3506: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
3507: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);

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

3500: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
3501: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
3502: fnd_file.put_line(fnd_file.output,rpad('Number of Parts : ',32) || l_no_of_parts);
3503: --fnd_file.put_line(fnd_file.output,rpad('Part : ',32) || g_part_no);
3504: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
3505: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
3506: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
3507: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
3508: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);

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

3501: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
3502: fnd_file.put_line(fnd_file.output,rpad('Number of Parts : ',32) || l_no_of_parts);
3503: --fnd_file.put_line(fnd_file.output,rpad('Part : ',32) || g_part_no);
3504: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
3505: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
3506: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
3507: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
3508: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
3509: fnd_file.put_line(fnd_file.output,rpad('Unique Part Identifier : ',32) || l_unique_part_id);

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

3502: fnd_file.put_line(fnd_file.output,rpad('Number of Parts : ',32) || l_no_of_parts);
3503: --fnd_file.put_line(fnd_file.output,rpad('Part : ',32) || g_part_no);
3504: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
3505: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
3506: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
3507: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
3508: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
3509: fnd_file.put_line(fnd_file.output,rpad('Unique Part Identifier : ',32) || l_unique_part_id);
3510:

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

3503: --fnd_file.put_line(fnd_file.output,rpad('Part : ',32) || g_part_no);
3504: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
3505: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
3506: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
3507: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
3508: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
3509: fnd_file.put_line(fnd_file.output,rpad('Unique Part Identifier : ',32) || l_unique_part_id);
3510:
3511: if length(l_addr2) > 0 then

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

3504: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
3505: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
3506: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
3507: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
3508: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
3509: fnd_file.put_line(fnd_file.output,rpad('Unique Part Identifier : ',32) || l_unique_part_id);
3510:
3511: if length(l_addr2) > 0 then
3512: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);

Line 3509: fnd_file.put_line(fnd_file.output,rpad('Unique Part Identifier : ',32) || l_unique_part_id);

3505: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
3506: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
3507: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
3508: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
3509: fnd_file.put_line(fnd_file.output,rpad('Unique Part Identifier : ',32) || l_unique_part_id);
3510:
3511: if length(l_addr2) > 0 then
3512: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
3513: end if;

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

3508: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
3509: fnd_file.put_line(fnd_file.output,rpad('Unique Part Identifier : ',32) || l_unique_part_id);
3510:
3511: if length(l_addr2) > 0 then
3512: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
3513: end if;
3514: if length(l_addr3) > 0 then
3515: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
3516: end if;

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

3511: if length(l_addr2) > 0 then
3512: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
3513: end if;
3514: if length(l_addr3) > 0 then
3515: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
3516: end if;
3517: if length(l_addr4) > 0 then
3518: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);
3519: end if;

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

3514: if length(l_addr3) > 0 then
3515: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
3516: end if;
3517: if length(l_addr4) > 0 then
3518: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);
3519: end if;
3520: if report_type = 'RTI_EAS_REP_13' then
3521: fnd_file.put_line(fnd_file.output,rpad('Effective Date : ',32) || l_eff_date);
3522: end if;

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

3517: if length(l_addr4) > 0 then
3518: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);
3519: end if;
3520: if report_type = 'RTI_EAS_REP_13' then
3521: fnd_file.put_line(fnd_file.output,rpad('Effective Date : ',32) || l_eff_date);
3522: end if;
3523:
3524: end write_header;
3525:

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

3524: end write_header;
3525:
3526: procedure write_sub_header(p_type varchar2,report_type varchar2) is
3527: begin
3528: fnd_file.put_line(fnd_file.output,null);
3529: if p_type = 'E' then
3530: fnd_file.put_line(fnd_file.output,'The following employments have completed with error');
3531: /* EAS 2013 Changes */
3532: elsif p_type = 'W' then

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

3526: procedure write_sub_header(p_type varchar2,report_type varchar2) is
3527: begin
3528: fnd_file.put_line(fnd_file.output,null);
3529: if p_type = 'E' then
3530: fnd_file.put_line(fnd_file.output,'The following employments have completed with error');
3531: /* EAS 2013 Changes */
3532: elsif p_type = 'W' then
3533: fnd_file.put_line(fnd_file.output,'The following employments have completed with warnings');
3534: else

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

3529: if p_type = 'E' then
3530: fnd_file.put_line(fnd_file.output,'The following employments have completed with error');
3531: /* EAS 2013 Changes */
3532: elsif p_type = 'W' then
3533: fnd_file.put_line(fnd_file.output,'The following employments have completed with warnings');
3534: else
3535: fnd_file.put_line(fnd_file.output,'The following employments have completed successfully');
3536: end if;
3537:

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

3531: /* EAS 2013 Changes */
3532: elsif p_type = 'W' then
3533: fnd_file.put_line(fnd_file.output,'The following employments have completed with warnings');
3534: else
3535: fnd_file.put_line(fnd_file.output,'The following employments have completed successfully');
3536: end if;
3537:
3538: if report_type = 'RTI_EAS_REP_13' then
3539:

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

3537:
3538: if report_type = 'RTI_EAS_REP_13' then
3539:
3540: if p_type = 'C' then --Completed records
3541: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) ||
3542: rpad('NI Number',11) ||
3543: rpad('Employee Name', 51) ||
3544: rpad('Start Date',16) ||
3545: rpad('End Date',16));

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

3543: rpad('Employee Name', 51) ||
3544: rpad('Start Date',16) ||
3545: rpad('End Date',16));
3546: else-- errored records
3547: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) ||
3548: rpad('NI Number',11) ||
3549: rpad('Employee Name', 51) ||
3550: rpad('Start Date',16) ||
3551: rpad('End Date',16) ||

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

3553: end if;
3554:
3555:
3556: if p_type = 'C' then -- Completed records
3557: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||
3558: rpad('-',10,'-') || ' ' ||
3559: rpad('-',50,'-') || ' ' ||
3560: rpad('-',15,'-') || ' ' ||
3561: rpad('-',15,'-') );

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

3560: rpad('-',15,'-') || ' ' ||
3561: rpad('-',15,'-') );
3562:
3563: else -- errored records
3564: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||
3565: rpad('-',10,'-') || ' ' ||
3566: rpad('-',50,'-') || ' ' ||
3567: rpad('-',15,'-') || ' ' ||
3568: rpad('-',15,'-') || ' ' ||

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

3572:
3573: if report_type = 'RTI_NINO_REP' then
3574:
3575: if p_type <> 'E' then -- completed records
3576: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
3577: rpad('NI Number',11) ||
3578: rpad('Employee Name', 52));
3579: else
3580: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||

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

3576: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
3577: rpad('NI Number',11) ||
3578: rpad('Employee Name', 52));
3579: else
3580: fnd_file.put_line(fnd_file.output,rpad('Employee Number',19) ||
3581: rpad('NI Number',11) ||
3582: rpad('Employee Name', 51) ||
3583: rpad('Error Messages',30));
3584: end if;

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

3584: end if;
3585:
3586:
3587: if p_type <> 'E' then
3588: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||
3589: rpad('-',10,'-') || ' ' ||
3590: rpad('-',52,'-') );
3591:
3592: else

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

3589: rpad('-',10,'-') || ' ' ||
3590: rpad('-',52,'-') );
3591:
3592: else
3593: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||
3594: rpad('-',10,'-') || ' ' ||
3595: rpad('-',50,'-') || ' ' ||
3596: rpad('-',30,'-'));
3597: end if;

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

3812:
3813: if (report_type = 'RTI_EAS_REP_13' and l_flag = 'Y') then
3814:
3815:
3816: fnd_file.put_line(fnd_file.output,rpad(asg_rec1.emp_no, 18) || ' ' ||
3817: rpad(asg_rec1.ni_no ,10) || ' ' ||
3818: rpad(l_et_temp,50) || ' ' ||
3819: rpad(asg_rec1.start_date,15) || ' ' ||
3820: rpad(asg_rec1.end_date,15) );

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

3819: rpad(asg_rec1.start_date,15) || ' ' ||
3820: rpad(asg_rec1.end_date,15) );
3821:
3822: elsif report_type = 'RTI_NINO_REP' then
3823: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.employee_number, 18) || ' ' ||
3824: rpad(et_asg_rec.ni_no ,10) || ' ' ||
3825: rpad(l_et_temp,50));
3826: end if;
3827:

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

3858:
3859: if report_type = 'RTI_EAS_REP_13' then
3860: if asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') then
3861: -- if asg_rec.end_date = '31-DEC-4712' then
3862: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' ||
3863: rpad(asg_rec.ni_no ,10) || ' ' ||
3864: rpad(l_temp,50) || ' ' ||
3865: rpad(asg_rec.start_date,15) || ' ' ||
3866: rpad(' ' ,15) || ' ' ||

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

3865: rpad(asg_rec.start_date,15) || ' ' ||
3866: rpad(' ' ,15) || ' ' ||
3867: rpad(err_msg.line_text,160) ); -- error message
3868: else
3869: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' ||
3870: rpad(asg_rec.ni_no ,10) || ' ' ||
3871: rpad(l_temp,50) || ' ' ||
3872: rpad(asg_rec.start_date,15) || ' ' ||
3873: rpad(asg_rec.end_date,15) || ' ' ||

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

3874: rpad(err_msg.line_text,160) ); -- error message
3875:
3876: end if;
3877: elsif report_type = 'RTI_NINO_REP' then
3878: fnd_file.put_line(fnd_file.output,rpad(asg_rec.employee_number, 18) || ' ' ||
3879: rpad(asg_rec.ni_no ,10) || ' ' ||
3880: rpad(l_temp,50) || ' ' ||
3881: rpad(err_msg.line_text,100) ); -- error message
3882: end if;

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

3884: loop
3885: fetch csr_err_msg into err_msg;
3886: exit when csr_err_msg%notfound;
3887: if report_type = 'RTI_EAS_REP_13' then
3888: fnd_file.put_line(fnd_file.output,rpad(' ',113,' ')||rpad(err_msg.line_text,160));
3889: elsif report_type = 'RTI_NINO_REP' then
3890: fnd_file.put_line(fnd_file.output,rpad(' ',81,' ')||rpad(err_msg.line_text,100));
3891: end if;
3892: end loop;

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

3886: exit when csr_err_msg%notfound;
3887: if report_type = 'RTI_EAS_REP_13' then
3888: fnd_file.put_line(fnd_file.output,rpad(' ',113,' ')||rpad(err_msg.line_text,160));
3889: elsif report_type = 'RTI_NINO_REP' then
3890: fnd_file.put_line(fnd_file.output,rpad(' ',81,' ')||rpad(err_msg.line_text,100));
3891: end if;
3892: end loop;
3893: close csr_err_msg;
3894:

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

3895: l_count := l_count + 1;
3896: END LOOP;
3897: END IF;
3898:
3899: fnd_file.put_line(fnd_file.output,null);
3900: /* EAS 2013 Changes */
3901: -- Warning Records
3902: IF p_type = 'W' THEN
3903:

Line 3912: -- fnd_file.put_line(fnd_file.LOG,'action_id.asg_action_id: '||action_id.asg_action_id);

3908: open get_person_details(action_id.assignment_id,l_eff_date);
3909: fetch get_person_details into asg_rec;
3910: close get_person_details;
3911:
3912: -- fnd_file.put_line(fnd_file.LOG,'action_id.asg_action_id: '||action_id.asg_action_id);
3913:
3914: OPEN csr_war_msg(action_id.asg_action_id);
3915: FETCH csr_war_msg INTO war_msg;
3916:

Line 3917: -- fnd_file.put_line(fnd_file.LOG,'action_id.asg_action_id: '||action_id.asg_action_id);

3913:
3914: OPEN csr_war_msg(action_id.asg_action_id);
3915: FETCH csr_war_msg INTO war_msg;
3916:
3917: -- fnd_file.put_line(fnd_file.LOG,'action_id.asg_action_id: '||action_id.asg_action_id);
3918:
3919: IF csr_war_msg%NOTFOUND THEN
3920: NULL;
3921: ELSE

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

3921: ELSE
3922: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' || asg_rec.f_name || ' ' || asg_rec.m_name;
3923: if asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') then
3924:
3925: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' ||
3926: rpad(asg_rec.ni_no ,10) || ' ' ||
3927: rpad(l_temp,50) || ' ' ||
3928: rpad(asg_rec.start_date,15) || ' ' ||
3929: rpad(' ' ,15) || ' ' ||

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

3928: rpad(asg_rec.start_date,15) || ' ' ||
3929: rpad(' ' ,15) || ' ' ||
3930: rpad(war_msg.line_text,150) ); -- error message
3931: else
3932: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' ||
3933: rpad(asg_rec.ni_no ,10) || ' ' ||
3934: rpad(l_temp,50) || ' ' ||
3935: rpad(asg_rec.start_date,15) || ' ' ||
3936: rpad(asg_rec.end_date,15) || ' ' ||

Line 3946: fnd_file.put_line(fnd_file.output,NULL);

3942:
3943: END LOOP;
3944:
3945: END IF;
3946: fnd_file.put_line(fnd_file.output,NULL);
3947:
3948: IF p_type = 'E' THEN
3949: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with error : ' || l_count);
3950: ELSIF p_type = 'W' THEN

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

3945: END IF;
3946: fnd_file.put_line(fnd_file.output,NULL);
3947:
3948: IF p_type = 'E' THEN
3949: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with error : ' || l_count);
3950: ELSIF p_type = 'W' THEN
3951: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with warning : ' || l_count_warns);
3952: ELSE
3953: fnd_file.put_line(fnd_file.output,'Total Number of employments completed successfully :' || l_count);

Line 3951: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with warning : ' || l_count_warns);

3947:
3948: IF p_type = 'E' THEN
3949: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with error : ' || l_count);
3950: ELSIF p_type = 'W' THEN
3951: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with warning : ' || l_count_warns);
3952: ELSE
3953: fnd_file.put_line(fnd_file.output,'Total Number of employments completed successfully :' || l_count);
3954: END IF;
3955: l_counter := l_counter + l_count;

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

3949: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with error : ' || l_count);
3950: ELSIF p_type = 'W' THEN
3951: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with warning : ' || l_count_warns);
3952: ELSE
3953: fnd_file.put_line(fnd_file.output,'Total Number of employments completed successfully :' || l_count);
3954: END IF;
3955: l_counter := l_counter + l_count;
3956: END write_body;
3957:

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

3972: open get_person_count;
3973: fetch get_person_count into l_person_count;
3974: close get_person_count;
3975:
3976: fnd_file.put_line(fnd_file.output,null);
3977: fnd_file.put_line(fnd_file.output,'Total Number Of employments : ' || l_counter);
3978: fnd_file.put_line(fnd_file.output,null);
3979: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
3980: end write_footer;

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

3973: fetch get_person_count into l_person_count;
3974: close get_person_count;
3975:
3976: fnd_file.put_line(fnd_file.output,null);
3977: fnd_file.put_line(fnd_file.output,'Total Number Of employments : ' || l_counter);
3978: fnd_file.put_line(fnd_file.output,null);
3979: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
3980: end write_footer;
3981:

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

3974: close get_person_count;
3975:
3976: fnd_file.put_line(fnd_file.output,null);
3977: fnd_file.put_line(fnd_file.output,'Total Number Of employments : ' || l_counter);
3978: fnd_file.put_line(fnd_file.output,null);
3979: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
3980: end write_footer;
3981:
3982: ---------------------

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

3975:
3976: fnd_file.put_line(fnd_file.output,null);
3977: fnd_file.put_line(fnd_file.output,'Total Number Of employments : ' || l_counter);
3978: fnd_file.put_line(fnd_file.output,null);
3979: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
3980: end write_footer;
3981:
3982: ---------------------
3983: ---------------------