DBA Data[Home] [Help]

APPS.PAY_GB_P11D_EDI_2008 dependencies on PAY_GB_EOY_MAGTAPE

Line 2258: elsif pay_gb_eoy_magtape.validate_input(edi_sender_id,'FULL_EDI') > 0 then

2254: /* Perform EDI validation */
2255: if (edi_sender_id = ' ' or edi_sender_id is null) then
2256: p_error_msg1 := ':Sender ID missing.';
2257: p_missing_val := p_missing_val + 1;
2258: elsif pay_gb_eoy_magtape.validate_input(edi_sender_id,'FULL_EDI') > 0 then
2259: p_error_msg1 := ':Sender ID contains illegal character(s)';
2260: p_error_count := p_error_count + 1;
2261: end if;
2262:

Line 2373: if pay_gb_eoy_magtape.validate_input(to_number(substr(p_employer_ref,1,3)),'NUMBER') > 0 then

2369: end if;
2370:
2371: /* Perform EDI validation */
2372: /* Validations are now done at archive level
2373: if pay_gb_eoy_magtape.validate_input(to_number(substr(p_employer_ref,1,3)),'NUMBER') > 0 then
2374: p_error_msg1 := ':Tax District ' || substr(p_employer_ref,1,3) || ' is non-numeric';
2375: p_error_count := p_error_count + 1;
2376: end if;
2377: if pay_gb_eoy_magtape.validate_input(p_employer_addr,'EDI_SURNAME') > 0 then

Line 2377: if pay_gb_eoy_magtape.validate_input(p_employer_addr,'EDI_SURNAME') > 0 then

2373: if pay_gb_eoy_magtape.validate_input(to_number(substr(p_employer_ref,1,3)),'NUMBER') > 0 then
2374: p_error_msg1 := ':Tax District ' || substr(p_employer_ref,1,3) || ' is non-numeric';
2375: p_error_count := p_error_count + 1;
2376: end if;
2377: if pay_gb_eoy_magtape.validate_input(p_employer_addr,'EDI_SURNAME') > 0 then
2378: p_error_msg2 := ':Employers Address contains illegal character(s) for ' ||
2379: 'Tax Ref : ' || p_employer_ref;
2380: p_error_count := p_error_count + 1;
2381: end if;

Line 2382: if pay_gb_eoy_magtape.validate_input(p_employer_addr,'EDI_SURNAME') > 0 then

2378: p_error_msg2 := ':Employers Address contains illegal character(s) for ' ||
2379: 'Tax Ref : ' || p_employer_ref;
2380: p_error_count := p_error_count + 1;
2381: end if;
2382: if pay_gb_eoy_magtape.validate_input(p_employer_addr,'EDI_SURNAME') > 0 then
2383: p_error_msg3 := ':Employers Name contains illegal character(s) for ' ||
2384: 'Tax Ref : ' || p_employer_ref;
2385: p_error_count := p_error_count + 1;
2386: end if;

Line 2558: if pay_gb_eoy_magtape.validate_input(l_last_name,'EDI_SURNAME') > 0 then

2554: /* EOY 2008 ends */
2555:
2556: /* EDI Validations are removed, this is now done at archive level*/
2557: /*
2558: if pay_gb_eoy_magtape.validate_input(l_last_name,'EDI_SURNAME') > 0 then
2559: p_error_msg1 := ':Illegal Character for last name for employee id ' || l_employee_no;
2560: p_error_count := p_error_count + 1;
2561: end if;
2562: if pay_gb_eoy_magtape.validate_input(l_first_name,'EDI_SURNAME') > 0 then

Line 2562: if pay_gb_eoy_magtape.validate_input(l_first_name,'EDI_SURNAME') > 0 then

2558: if pay_gb_eoy_magtape.validate_input(l_last_name,'EDI_SURNAME') > 0 then
2559: p_error_msg1 := ':Illegal Character for last name for employee id ' || l_employee_no;
2560: p_error_count := p_error_count + 1;
2561: end if;
2562: if pay_gb_eoy_magtape.validate_input(l_first_name,'EDI_SURNAME') > 0 then
2563: p_error_msg2 := ':Illegal Character for first name for employee id ' || l_employee_no;
2564: p_error_count := p_error_count + 1;
2565: end if;
2566: if pay_gb_eoy_magtape.validate_input(l_middle_name,'EDI_SURNAME') > 0 then

Line 2566: if pay_gb_eoy_magtape.validate_input(l_middle_name,'EDI_SURNAME') > 0 then

2562: if pay_gb_eoy_magtape.validate_input(l_first_name,'EDI_SURNAME') > 0 then
2563: p_error_msg2 := ':Illegal Character for first name for employee id ' || l_employee_no;
2564: p_error_count := p_error_count + 1;
2565: end if;
2566: if pay_gb_eoy_magtape.validate_input(l_middle_name,'EDI_SURNAME') > 0 then
2567: p_error_msg3 := ':Illegal Character for middle name for employee id ' || l_employee_no;
2568: p_error_count := p_error_count + 1;
2569: end if;
2570: if pay_gb_eoy_magtape.validate_input(l_addr1,'EDI_SURNAME') > 0 then

Line 2570: if pay_gb_eoy_magtape.validate_input(l_addr1,'EDI_SURNAME') > 0 then

2566: if pay_gb_eoy_magtape.validate_input(l_middle_name,'EDI_SURNAME') > 0 then
2567: p_error_msg3 := ':Illegal Character for middle name for employee id ' || l_employee_no;
2568: p_error_count := p_error_count + 1;
2569: end if;
2570: if pay_gb_eoy_magtape.validate_input(l_addr1,'EDI_SURNAME') > 0 then
2571: p_error_msg4 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line1' ;
2572: p_error_count := p_error_count + 1;
2573: end if;
2574: if pay_gb_eoy_magtape.validate_input(l_addr2,'EDI_SURNAME') > 0 then

Line 2574: if pay_gb_eoy_magtape.validate_input(l_addr2,'EDI_SURNAME') > 0 then

2570: if pay_gb_eoy_magtape.validate_input(l_addr1,'EDI_SURNAME') > 0 then
2571: p_error_msg4 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line1' ;
2572: p_error_count := p_error_count + 1;
2573: end if;
2574: if pay_gb_eoy_magtape.validate_input(l_addr2,'EDI_SURNAME') > 0 then
2575: p_error_msg5 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line3' ;
2576: p_error_count := p_error_count + 1;
2577: end if;
2578: if pay_gb_eoy_magtape.validate_input(l_addr3,'EDI_SURNAME') > 0 then

Line 2578: if pay_gb_eoy_magtape.validate_input(l_addr3,'EDI_SURNAME') > 0 then

2574: if pay_gb_eoy_magtape.validate_input(l_addr2,'EDI_SURNAME') > 0 then
2575: p_error_msg5 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line3' ;
2576: p_error_count := p_error_count + 1;
2577: end if;
2578: if pay_gb_eoy_magtape.validate_input(l_addr3,'EDI_SURNAME') > 0 then
2579: p_error_msg6 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line3' ;
2580: p_error_count := p_error_count + 1;
2581: end if;
2582: if pay_gb_eoy_magtape.validate_input(l_addr4,'EDI_SURNAME') > 0 then

Line 2582: if pay_gb_eoy_magtape.validate_input(l_addr4,'EDI_SURNAME') > 0 then

2578: if pay_gb_eoy_magtape.validate_input(l_addr3,'EDI_SURNAME') > 0 then
2579: p_error_msg6 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line3' ;
2580: p_error_count := p_error_count + 1;
2581: end if;
2582: if pay_gb_eoy_magtape.validate_input(l_addr4,'EDI_SURNAME') > 0 then
2583: p_error_msg7 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line4' ;
2584: p_error_count := p_error_count + 1;
2585: end if;
2586: if pay_gb_eoy_magtape.validate_input(l_addr5,'EDI_SURNAME') > 0 then

Line 2586: if pay_gb_eoy_magtape.validate_input(l_addr5,'EDI_SURNAME') > 0 then

2582: if pay_gb_eoy_magtape.validate_input(l_addr4,'EDI_SURNAME') > 0 then
2583: p_error_msg7 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line4' ;
2584: p_error_count := p_error_count + 1;
2585: end if;
2586: if pay_gb_eoy_magtape.validate_input(l_addr5,'EDI_SURNAME') > 0 then
2587: p_error_msg8 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line5' ;
2588: p_error_count := p_error_count + 1;
2589: end if;
2590: */