DBA Data[Home] [Help]

APPS.PAY_GB_P11D_EDI_2005 dependencies on PAY_GB_EOY_MAGTAPE

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

2104: /* Perform EDI validation */
2105: if (edi_sender_id = ' ' or edi_sender_id is null) then
2106: p_error_msg := ':Sender ID missing.';
2107: p_missing_val := p_missing_val + 1;
2108: elsif pay_gb_eoy_magtape.validate_input(edi_sender_id,'FULL_EDI') > 0 then
2109: p_error_msg := ':Sender ID contains illegal character(s)';
2110: p_error_count := p_error_count + 1;
2111: end if;
2112:

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

2211: edi_addr3 := substr(edi_addr3, 1, l_wrap_point);
2212: end if;
2213:
2214: /* Perform EDI validation */
2215: if pay_gb_eoy_magtape.validate_input(to_number(substr(p_employer_ref,1,3)),'NUMBER') > 0 then
2216: p_error_msg1 := ':Tax District ' || substr(p_employer_ref,1,3) || ' is non-numeric';
2217: p_error_count := p_error_count + 1;
2218: end if;
2219: if pay_gb_eoy_magtape.validate_input(p_employer_addr,'EDI_SURNAME') > 0 then

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

2215: if pay_gb_eoy_magtape.validate_input(to_number(substr(p_employer_ref,1,3)),'NUMBER') > 0 then
2216: p_error_msg1 := ':Tax District ' || substr(p_employer_ref,1,3) || ' is non-numeric';
2217: p_error_count := p_error_count + 1;
2218: end if;
2219: if pay_gb_eoy_magtape.validate_input(p_employer_addr,'EDI_SURNAME') > 0 then
2220: p_error_msg2 := ':Employers Address contains illegal character(s) for ' ||
2221: 'Tax Ref : ' || p_employer_ref;
2222: p_error_count := p_error_count + 1;
2223: end if;

Line 2224: if pay_gb_eoy_magtape.validate_input(p_employer_name,'EDI_SURNAME') > 0 then

2220: p_error_msg2 := ':Employers Address contains illegal character(s) for ' ||
2221: 'Tax Ref : ' || p_employer_ref;
2222: p_error_count := p_error_count + 1;
2223: end if;
2224: if pay_gb_eoy_magtape.validate_input(p_employer_name,'EDI_SURNAME') > 0 then
2225: p_error_msg3 := ':Employers Name contains illegal character(s) for ' ||
2226: 'Tax Ref : ' || p_employer_ref;
2227: p_error_count := p_error_count + 1;
2228: end if;

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

2355:
2356: /* Perform EDI Validation */
2357: /* Removed validation. Validations are now done at archive level */
2358: /*
2359: if pay_gb_eoy_magtape.validate_input(l_last_name,'EDI_SURNAME') > 0 then
2360: p_error_msg1 := ':Illegal Character for last name for employee id ' || l_employee_no;
2361: p_error_count := p_error_count + 1;
2362: end if;
2363: if pay_gb_eoy_magtape.validate_input(l_first_name,'EDI_SURNAME') > 0 then

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

2359: if pay_gb_eoy_magtape.validate_input(l_last_name,'EDI_SURNAME') > 0 then
2360: p_error_msg1 := ':Illegal Character for last name for employee id ' || l_employee_no;
2361: p_error_count := p_error_count + 1;
2362: end if;
2363: if pay_gb_eoy_magtape.validate_input(l_first_name,'EDI_SURNAME') > 0 then
2364: p_error_msg2 := ':Illegal Character for first name for employee id ' || l_employee_no;
2365: p_error_count := p_error_count + 1;
2366: end if;
2367: if pay_gb_eoy_magtape.validate_input(l_middle_name,'EDI_SURNAME') > 0 then

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

2363: if pay_gb_eoy_magtape.validate_input(l_first_name,'EDI_SURNAME') > 0 then
2364: p_error_msg2 := ':Illegal Character for first name for employee id ' || l_employee_no;
2365: p_error_count := p_error_count + 1;
2366: end if;
2367: if pay_gb_eoy_magtape.validate_input(l_middle_name,'EDI_SURNAME') > 0 then
2368: p_error_msg3 := ':Illegal Character for middle name for employee id ' || l_employee_no;
2369: p_error_count := p_error_count + 1;
2370: end if;
2371: if pay_gb_eoy_magtape.validate_input(l_addr1,'EDI_SURNAME') > 0 then

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

2367: if pay_gb_eoy_magtape.validate_input(l_middle_name,'EDI_SURNAME') > 0 then
2368: p_error_msg3 := ':Illegal Character for middle name for employee id ' || l_employee_no;
2369: p_error_count := p_error_count + 1;
2370: end if;
2371: if pay_gb_eoy_magtape.validate_input(l_addr1,'EDI_SURNAME') > 0 then
2372: p_error_msg4 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line1' ;
2373: p_error_count := p_error_count + 1;
2374: end if;
2375: if pay_gb_eoy_magtape.validate_input(l_addr2,'EDI_SURNAME') > 0 then

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

2371: if pay_gb_eoy_magtape.validate_input(l_addr1,'EDI_SURNAME') > 0 then
2372: p_error_msg4 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line1' ;
2373: p_error_count := p_error_count + 1;
2374: end if;
2375: if pay_gb_eoy_magtape.validate_input(l_addr2,'EDI_SURNAME') > 0 then
2376: p_error_msg5 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line2' ;
2377: p_error_count := p_error_count + 1;
2378: end if;
2379: if pay_gb_eoy_magtape.validate_input(l_addr3,'EDI_SURNAME') > 0 then

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

2375: if pay_gb_eoy_magtape.validate_input(l_addr2,'EDI_SURNAME') > 0 then
2376: p_error_msg5 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line2' ;
2377: p_error_count := p_error_count + 1;
2378: end if;
2379: if pay_gb_eoy_magtape.validate_input(l_addr3,'EDI_SURNAME') > 0 then
2380: p_error_msg6 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line3' ;
2381: p_error_count := p_error_count + 1;
2382: end if;
2383: if pay_gb_eoy_magtape.validate_input(l_addr4,'EDI_SURNAME') > 0 then

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

2379: if pay_gb_eoy_magtape.validate_input(l_addr3,'EDI_SURNAME') > 0 then
2380: p_error_msg6 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line3' ;
2381: p_error_count := p_error_count + 1;
2382: end if;
2383: if pay_gb_eoy_magtape.validate_input(l_addr4,'EDI_SURNAME') > 0 then
2384: p_error_msg7 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line4' ;
2385: p_error_count := p_error_count + 1;
2386: end if;
2387: if pay_gb_eoy_magtape.validate_input(l_addr5,'EDI_SURNAME') > 0 then

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

2383: if pay_gb_eoy_magtape.validate_input(l_addr4,'EDI_SURNAME') > 0 then
2384: p_error_msg7 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line4' ;
2385: p_error_count := p_error_count + 1;
2386: end if;
2387: if pay_gb_eoy_magtape.validate_input(l_addr5,'EDI_SURNAME') > 0 then
2388: p_error_msg8 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line5' ;
2389: p_error_count := p_error_count + 1;
2390: end if;
2391: */