DBA Data[Home] [Help]

APPS.PAY_GB_P11D_EDI_2008 dependencies on PAY_GB_EOY_MAGTAPE

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

2208: /* Perform EDI validation */
2209: if (edi_sender_id = ' ' or edi_sender_id is null) then
2210: p_error_msg1 := ':Sender ID missing.';
2211: p_missing_val := p_missing_val + 1;
2212: elsif pay_gb_eoy_magtape.validate_input(edi_sender_id,'FULL_EDI') > 0 then
2213: p_error_msg1 := ':Sender ID contains illegal character(s)';
2214: p_error_count := p_error_count + 1;
2215: end if;
2216:

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

2323: end if;
2324:
2325: /* Perform EDI validation */
2326: /* Validations are now done at archive level
2327: if pay_gb_eoy_magtape.validate_input(to_number(substr(p_employer_ref,1,3)),'NUMBER') > 0 then
2328: p_error_msg1 := ':Tax District ' || substr(p_employer_ref,1,3) || ' is non-numeric';
2329: p_error_count := p_error_count + 1;
2330: end if;
2331: if pay_gb_eoy_magtape.validate_input(p_employer_addr,'EDI_SURNAME') > 0 then

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

2327: if pay_gb_eoy_magtape.validate_input(to_number(substr(p_employer_ref,1,3)),'NUMBER') > 0 then
2328: p_error_msg1 := ':Tax District ' || substr(p_employer_ref,1,3) || ' is non-numeric';
2329: p_error_count := p_error_count + 1;
2330: end if;
2331: if pay_gb_eoy_magtape.validate_input(p_employer_addr,'EDI_SURNAME') > 0 then
2332: p_error_msg2 := ':Employers Address contains illegal character(s) for ' ||
2333: 'Tax Ref : ' || p_employer_ref;
2334: p_error_count := p_error_count + 1;
2335: end if;

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

2332: p_error_msg2 := ':Employers Address contains illegal character(s) for ' ||
2333: 'Tax Ref : ' || p_employer_ref;
2334: p_error_count := p_error_count + 1;
2335: end if;
2336: if pay_gb_eoy_magtape.validate_input(p_employer_addr,'EDI_SURNAME') > 0 then
2337: p_error_msg3 := ':Employers Name contains illegal character(s) for ' ||
2338: 'Tax Ref : ' || p_employer_ref;
2339: p_error_count := p_error_count + 1;
2340: end if;

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

2502: /* EOY 2008 ends */
2503:
2504: /* EDI Validations are removed, this is now done at archive level*/
2505: /*
2506: if pay_gb_eoy_magtape.validate_input(l_last_name,'EDI_SURNAME') > 0 then
2507: p_error_msg1 := ':Illegal Character for last name for employee id ' || l_employee_no;
2508: p_error_count := p_error_count + 1;
2509: end if;
2510: if pay_gb_eoy_magtape.validate_input(l_first_name,'EDI_SURNAME') > 0 then

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

2506: if pay_gb_eoy_magtape.validate_input(l_last_name,'EDI_SURNAME') > 0 then
2507: p_error_msg1 := ':Illegal Character for last name for employee id ' || l_employee_no;
2508: p_error_count := p_error_count + 1;
2509: end if;
2510: if pay_gb_eoy_magtape.validate_input(l_first_name,'EDI_SURNAME') > 0 then
2511: p_error_msg2 := ':Illegal Character for first name for employee id ' || l_employee_no;
2512: p_error_count := p_error_count + 1;
2513: end if;
2514: if pay_gb_eoy_magtape.validate_input(l_middle_name,'EDI_SURNAME') > 0 then

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

2510: if pay_gb_eoy_magtape.validate_input(l_first_name,'EDI_SURNAME') > 0 then
2511: p_error_msg2 := ':Illegal Character for first name for employee id ' || l_employee_no;
2512: p_error_count := p_error_count + 1;
2513: end if;
2514: if pay_gb_eoy_magtape.validate_input(l_middle_name,'EDI_SURNAME') > 0 then
2515: p_error_msg3 := ':Illegal Character for middle name for employee id ' || l_employee_no;
2516: p_error_count := p_error_count + 1;
2517: end if;
2518: if pay_gb_eoy_magtape.validate_input(l_addr1,'EDI_SURNAME') > 0 then

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

2514: if pay_gb_eoy_magtape.validate_input(l_middle_name,'EDI_SURNAME') > 0 then
2515: p_error_msg3 := ':Illegal Character for middle name for employee id ' || l_employee_no;
2516: p_error_count := p_error_count + 1;
2517: end if;
2518: if pay_gb_eoy_magtape.validate_input(l_addr1,'EDI_SURNAME') > 0 then
2519: p_error_msg4 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line1' ;
2520: p_error_count := p_error_count + 1;
2521: end if;
2522: if pay_gb_eoy_magtape.validate_input(l_addr2,'EDI_SURNAME') > 0 then

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

2518: if pay_gb_eoy_magtape.validate_input(l_addr1,'EDI_SURNAME') > 0 then
2519: p_error_msg4 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line1' ;
2520: p_error_count := p_error_count + 1;
2521: end if;
2522: if pay_gb_eoy_magtape.validate_input(l_addr2,'EDI_SURNAME') > 0 then
2523: p_error_msg5 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line3' ;
2524: p_error_count := p_error_count + 1;
2525: end if;
2526: if pay_gb_eoy_magtape.validate_input(l_addr3,'EDI_SURNAME') > 0 then

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

2522: if pay_gb_eoy_magtape.validate_input(l_addr2,'EDI_SURNAME') > 0 then
2523: p_error_msg5 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line3' ;
2524: p_error_count := p_error_count + 1;
2525: end if;
2526: if pay_gb_eoy_magtape.validate_input(l_addr3,'EDI_SURNAME') > 0 then
2527: p_error_msg6 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line3' ;
2528: p_error_count := p_error_count + 1;
2529: end if;
2530: if pay_gb_eoy_magtape.validate_input(l_addr4,'EDI_SURNAME') > 0 then

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

2526: if pay_gb_eoy_magtape.validate_input(l_addr3,'EDI_SURNAME') > 0 then
2527: p_error_msg6 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line3' ;
2528: p_error_count := p_error_count + 1;
2529: end if;
2530: if pay_gb_eoy_magtape.validate_input(l_addr4,'EDI_SURNAME') > 0 then
2531: p_error_msg7 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line4' ;
2532: p_error_count := p_error_count + 1;
2533: end if;
2534: if pay_gb_eoy_magtape.validate_input(l_addr5,'EDI_SURNAME') > 0 then

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

2530: if pay_gb_eoy_magtape.validate_input(l_addr4,'EDI_SURNAME') > 0 then
2531: p_error_msg7 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line4' ;
2532: p_error_count := p_error_count + 1;
2533: end if;
2534: if pay_gb_eoy_magtape.validate_input(l_addr5,'EDI_SURNAME') > 0 then
2535: p_error_msg8 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line5' ;
2536: p_error_count := p_error_count + 1;
2537: end if;
2538: */