DBA Data[Home] [Help]

APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on PAY_GB_EOY_MAGTAPE

Line 1369: IF pay_gb_eoy_magtape.validate_input(UPPER(l_pay_info_tab(p_payroll_id).l_tax_office_name) ) > 0

1365: CLOSE csr_payroll_info;
1366: hr_utility.set_location('Archiving Payroll info', 35);
1367: hr_utility.TRACE(' Found InsidePopulate_Payroll_info');
1368:
1369: IF pay_gb_eoy_magtape.validate_input(UPPER(l_pay_info_tab(p_payroll_id).l_tax_office_name) ) > 0
1370: THEN
1371: -- fnd_file.put_line(fnd_file.output,'Tax Office Name contains illegal character(s) :' || l_tax_office_name );
1372: RAISE tax_office_name_error;
1373: END IF;

Line 1375: IF pay_gb_eoy_magtape.validate_input(UPPER(l_pay_info_tab(p_payroll_id).l_employer_address),'P11D_EDI' ) > 0

1371: -- fnd_file.put_line(fnd_file.output,'Tax Office Name contains illegal character(s) :' || l_tax_office_name );
1372: RAISE tax_office_name_error;
1373: END IF;
1374:
1375: IF pay_gb_eoy_magtape.validate_input(UPPER(l_pay_info_tab(p_payroll_id).l_employer_address),'P11D_EDI' ) > 0
1376: THEN
1377: -- fnd_file.put_line(fnd_file.output,'Employers Address contains illegal character(s) :' || l_employer_address );
1378: RAISE employer_address_error;
1379: END IF;

Line 1381: IF pay_gb_eoy_magtape.validate_input(UPPER(l_pay_info_tab(p_payroll_id).l_employers_ref_no) ) > 0

1377: -- fnd_file.put_line(fnd_file.output,'Employers Address contains illegal character(s) :' || l_employer_address );
1378: RAISE employer_address_error;
1379: END IF;
1380:
1381: IF pay_gb_eoy_magtape.validate_input(UPPER(l_pay_info_tab(p_payroll_id).l_employers_ref_no) ) > 0
1382: THEN
1383: -- fnd_file.put_line(fnd_file.output,'Employers Reference Number contains illegal character(s) :' || l_employers_ref_no);
1384: RAISE employers_ref_no_error;
1385: END IF;

Line 1387: IF pay_gb_eoy_magtape.validate_input(to_number(substr(l_pay_info_tab(p_payroll_id).l_employers_ref_no,1,3)),'NUMBER') > 0

1383: -- fnd_file.put_line(fnd_file.output,'Employers Reference Number contains illegal character(s) :' || l_employers_ref_no);
1384: RAISE employers_ref_no_error;
1385: END IF;
1386:
1387: IF pay_gb_eoy_magtape.validate_input(to_number(substr(l_pay_info_tab(p_payroll_id).l_employers_ref_no,1,3)),'NUMBER') > 0
1388: THEN
1389: RAISE employers_ref_no_error;
1390: END IF;
1391:

Line 1392: IF pay_gb_eoy_magtape.validate_input(UPPER(l_pay_info_tab(p_payroll_id).l_employer_name),'P11D_EDI' ) > 0

1388: THEN
1389: RAISE employers_ref_no_error;
1390: END IF;
1391:
1392: IF pay_gb_eoy_magtape.validate_input(UPPER(l_pay_info_tab(p_payroll_id).l_employer_name),'P11D_EDI' ) > 0
1393: THEN
1394: -- fnd_file.put_line(fnd_file.output,'Employers Name contains illegal character(s) :' || l_employer_name );
1395: RAISE employer_name_error;
1396: END IF;

Line 2657: if pay_gb_eoy_magtape.validate_input(l_addr1,'P11D_EDI') > 0 then

2653: l_addr3,
2654: l_addr4,
2655: l_addr5;
2656: close get_address;
2657: if pay_gb_eoy_magtape.validate_input(l_addr1,'P11D_EDI') > 0 then
2658: l_error_assignment := TRUE;
2659: l_error := '1';
2660: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2661: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 1 value ' || l_addr1);

Line 2663: if pay_gb_eoy_magtape.validate_input(l_addr2,'P11D_EDI') > 0 then

2659: l_error := '1';
2660: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2661: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 1 value ' || l_addr1);
2662: end if;
2663: if pay_gb_eoy_magtape.validate_input(l_addr2,'P11D_EDI') > 0 then
2664: l_error_assignment := TRUE;
2665: l_error := '1';
2666: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2667: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 2 value ' || l_addr2);

Line 2669: if pay_gb_eoy_magtape.validate_input(l_addr3,'P11D_EDI') > 0 then

2665: l_error := '1';
2666: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2667: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 2 value ' || l_addr2);
2668: end if;
2669: if pay_gb_eoy_magtape.validate_input(l_addr3,'P11D_EDI') > 0 then
2670: l_error_assignment := TRUE;
2671: l_error := '1';
2672: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2673: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 3 value ' || l_addr3);

Line 2675: if pay_gb_eoy_magtape.validate_input(l_addr4,'P11D_EDI') > 0 then

2671: l_error := '1';
2672: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2673: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 3 value ' || l_addr3);
2674: end if;
2675: if pay_gb_eoy_magtape.validate_input(l_addr4,'P11D_EDI') > 0 then
2676: l_error_assignment := TRUE;
2677: l_error := '1';
2678: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2679: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 4 value ' || l_addr4);

Line 2681: if pay_gb_eoy_magtape.validate_input(l_addr5,'P11D_EDI') > 0 then

2677: l_error := '1';
2678: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2679: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 4 value ' || l_addr4);
2680: end if;
2681: if pay_gb_eoy_magtape.validate_input(l_addr5,'P11D_EDI') > 0 then
2682: l_error_assignment := TRUE;
2683: l_error := '1';
2684: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2685: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 5 value ' || l_addr5);

Line 3010: IF pay_gb_eoy_magtape.validate_input(UPPER(l_first_name), 'P11D_EDI') > 0

3006: END IF;
3007:
3008: hr_utility.set_location('Archiving GB EMPLOYEE DETAILS', 50);
3009:
3010: IF pay_gb_eoy_magtape.validate_input(UPPER(l_first_name), 'P11D_EDI') > 0
3011: THEN
3012: l_error_assignment := TRUE;
3013: l_error := '1';
3014: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

Line 3018: IF pay_gb_eoy_magtape.validate_input(UPPER(l_middle_name), 'P11D_EDI') > 0

3014: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3015: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for First Name value ' || l_first_name);
3016: END IF;
3017:
3018: IF pay_gb_eoy_magtape.validate_input(UPPER(l_middle_name), 'P11D_EDI') > 0
3019: THEN
3020: l_error_assignment := TRUE;
3021: l_error := '1';
3022: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

Line 3026: IF pay_gb_eoy_magtape.validate_input(UPPER(l_last_name), 'P11D_EDI') > 0

3022: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3023: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Middle Name value ' || l_middle_name);
3024: END IF;
3025:
3026: IF pay_gb_eoy_magtape.validate_input(UPPER(l_last_name), 'P11D_EDI') > 0
3027: THEN
3028: l_error_assignment := TRUE;
3029: l_error := '1';
3030: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

Line 3337: IF pay_gb_eoy_magtape.validate_input(UPPER(l_user_inputs(l_inner).VALUE) ) > 0

3333: -- hr_utility.tracE_off;
3334: -- check_magtape_validation;
3335: FOR l_inner IN l_user_inputs.FIRST .. l_user_inputs.LAST
3336: LOOP
3337: IF pay_gb_eoy_magtape.validate_input(UPPER(l_user_inputs(l_inner).VALUE) ) > 0
3338: THEN
3339: IF INSTR(UPPER(l_user_inputs(l_inner).NAME), 'DATE') > 0
3340: THEN
3341: NULL; -- ignore the failure as the dates validatred by the above process is incrrect