DBA Data[Home] [Help]

APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on PAY_GB_EOY_MAGTAPE

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

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

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

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

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

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

Line 1388: 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

1384: -- fnd_file.put_line(fnd_file.output,'Employers Reference Number contains illegal character(s) :' || l_employers_ref_no);
1385: RAISE employers_ref_no_error;
1386: END IF;
1387:
1388: 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
1389: THEN
1390: RAISE employers_ref_no_error;
1391: END IF;
1392:

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

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

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

2719: l_addr3,
2720: l_addr4,
2721: l_addr5;
2722: close get_address;
2723: if pay_gb_eoy_magtape.validate_input(l_addr1,'P11D_EDI') > 0 then
2724: l_error_assignment := TRUE;
2725: l_error := '1';
2726: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2727: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 1 value ' || l_addr1);

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

2725: l_error := '1';
2726: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2727: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 1 value ' || l_addr1);
2728: end if;
2729: if pay_gb_eoy_magtape.validate_input(l_addr2,'P11D_EDI') > 0 then
2730: l_error_assignment := TRUE;
2731: l_error := '1';
2732: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2733: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 2 value ' || l_addr2);

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

2731: l_error := '1';
2732: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2733: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 2 value ' || l_addr2);
2734: end if;
2735: if pay_gb_eoy_magtape.validate_input(l_addr3,'P11D_EDI') > 0 then
2736: l_error_assignment := TRUE;
2737: l_error := '1';
2738: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2739: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 3 value ' || l_addr3);

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

2737: l_error := '1';
2738: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2739: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 3 value ' || l_addr3);
2740: end if;
2741: if pay_gb_eoy_magtape.validate_input(l_addr4,'P11D_EDI') > 0 then
2742: l_error_assignment := TRUE;
2743: l_error := '1';
2744: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2745: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 4 value ' || l_addr4);

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

2743: l_error := '1';
2744: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2745: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 4 value ' || l_addr4);
2746: end if;
2747: if pay_gb_eoy_magtape.validate_input(l_addr5,'P11D_EDI') > 0 then
2748: l_error_assignment := TRUE;
2749: l_error := '1';
2750: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
2751: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Address Line 5 value ' || l_addr5);

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

3072: END IF;
3073:
3074: hr_utility.set_location('Archiving GB EMPLOYEE DETAILS', 50);
3075:
3076: IF pay_gb_eoy_magtape.validate_input(UPPER(l_first_name), 'P11D_EDI') > 0
3077: THEN
3078: l_error_assignment := TRUE;
3079: l_error := '1';
3080: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

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

3080: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3081: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for First Name value ' || l_first_name);
3082: END IF;
3083:
3084: IF pay_gb_eoy_magtape.validate_input(UPPER(l_middle_name), 'P11D_EDI') > 0
3085: THEN
3086: l_error_assignment := TRUE;
3087: l_error := '1';
3088: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

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

3088: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3089: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for Middle Name value ' || l_middle_name);
3090: END IF;
3091:
3092: IF pay_gb_eoy_magtape.validate_input(UPPER(l_last_name), 'P11D_EDI') > 0
3093: THEN
3094: l_error_assignment := TRUE;
3095: l_error := '1';
3096: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');

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

3399: -- hr_utility.tracE_off;
3400: -- check_magtape_validation;
3401: FOR l_inner IN l_user_inputs.FIRST .. l_user_inputs.LAST
3402: LOOP
3403: IF pay_gb_eoy_magtape.validate_input(UPPER(l_user_inputs(l_inner).VALUE) ) > 0
3404: THEN
3405: IF INSTR(UPPER(l_user_inputs(l_inner).NAME), 'DATE') > 0
3406: THEN
3407: NULL; -- ignore the failure as the dates validatred by the above process is incrrect