DBA Data[Home] [Help]

APPS.PAY_GB_P11D_EDI_2006 dependencies on PAY_GB_EOY_MAGTAPE

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

2140: /* Perform EDI validation */
2141: if (edi_sender_id = ' ' or edi_sender_id is null) then
2142: p_error_msg1 := ':Sender ID missing.';
2143: p_missing_val := p_missing_val + 1;
2144: elsif pay_gb_eoy_magtape.validate_input(edi_sender_id,'FULL_EDI') > 0 then
2145: p_error_msg1 := ':Sender ID contains illegal character(s)';
2146: p_error_count := p_error_count + 1;
2147: end if;
2148:

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

2255: end if;
2256:
2257: /* Perform EDI validation */
2258: /* Validations are now done at archive level
2259: if pay_gb_eoy_magtape.validate_input(to_number(substr(p_employer_ref,1,3)),'NUMBER') > 0 then
2260: p_error_msg1 := ':Tax District ' || substr(p_employer_ref,1,3) || ' is non-numeric';
2261: p_error_count := p_error_count + 1;
2262: end if;
2263: if pay_gb_eoy_magtape.validate_input(p_employer_addr,'EDI_SURNAME') > 0 then

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

2259: if pay_gb_eoy_magtape.validate_input(to_number(substr(p_employer_ref,1,3)),'NUMBER') > 0 then
2260: p_error_msg1 := ':Tax District ' || substr(p_employer_ref,1,3) || ' is non-numeric';
2261: p_error_count := p_error_count + 1;
2262: end if;
2263: if pay_gb_eoy_magtape.validate_input(p_employer_addr,'EDI_SURNAME') > 0 then
2264: p_error_msg2 := ':Employers Address contains illegal character(s) for ' ||
2265: 'Tax Ref : ' || p_employer_ref;
2266: p_error_count := p_error_count + 1;
2267: end if;

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

2264: p_error_msg2 := ':Employers Address contains illegal character(s) for ' ||
2265: 'Tax Ref : ' || p_employer_ref;
2266: p_error_count := p_error_count + 1;
2267: end if;
2268: if pay_gb_eoy_magtape.validate_input(p_employer_addr,'EDI_SURNAME') > 0 then
2269: p_error_msg3 := ':Employers Name contains illegal character(s) for ' ||
2270: 'Tax Ref : ' || p_employer_ref;
2271: p_error_count := p_error_count + 1;
2272: end if;

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

2406: end if;
2407:
2408: /* EDI Validations are removed, this is now done at archive level*/
2409: /*
2410: if pay_gb_eoy_magtape.validate_input(l_last_name,'EDI_SURNAME') > 0 then
2411: p_error_msg1 := ':Illegal Character for last name for employee id ' || l_employee_no;
2412: p_error_count := p_error_count + 1;
2413: end if;
2414: if pay_gb_eoy_magtape.validate_input(l_first_name,'EDI_SURNAME') > 0 then

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

2410: if pay_gb_eoy_magtape.validate_input(l_last_name,'EDI_SURNAME') > 0 then
2411: p_error_msg1 := ':Illegal Character for last name for employee id ' || l_employee_no;
2412: p_error_count := p_error_count + 1;
2413: end if;
2414: if pay_gb_eoy_magtape.validate_input(l_first_name,'EDI_SURNAME') > 0 then
2415: p_error_msg2 := ':Illegal Character for first name for employee id ' || l_employee_no;
2416: p_error_count := p_error_count + 1;
2417: end if;
2418: if pay_gb_eoy_magtape.validate_input(l_middle_name,'EDI_SURNAME') > 0 then

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

2414: if pay_gb_eoy_magtape.validate_input(l_first_name,'EDI_SURNAME') > 0 then
2415: p_error_msg2 := ':Illegal Character for first name for employee id ' || l_employee_no;
2416: p_error_count := p_error_count + 1;
2417: end if;
2418: if pay_gb_eoy_magtape.validate_input(l_middle_name,'EDI_SURNAME') > 0 then
2419: p_error_msg3 := ':Illegal Character for middle name for employee id ' || l_employee_no;
2420: p_error_count := p_error_count + 1;
2421: end if;
2422: if pay_gb_eoy_magtape.validate_input(l_addr1,'EDI_SURNAME') > 0 then

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

2418: if pay_gb_eoy_magtape.validate_input(l_middle_name,'EDI_SURNAME') > 0 then
2419: p_error_msg3 := ':Illegal Character for middle name for employee id ' || l_employee_no;
2420: p_error_count := p_error_count + 1;
2421: end if;
2422: if pay_gb_eoy_magtape.validate_input(l_addr1,'EDI_SURNAME') > 0 then
2423: p_error_msg4 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line1' ;
2424: p_error_count := p_error_count + 1;
2425: end if;
2426: if pay_gb_eoy_magtape.validate_input(l_addr2,'EDI_SURNAME') > 0 then

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

2422: if pay_gb_eoy_magtape.validate_input(l_addr1,'EDI_SURNAME') > 0 then
2423: p_error_msg4 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line1' ;
2424: p_error_count := p_error_count + 1;
2425: end if;
2426: if pay_gb_eoy_magtape.validate_input(l_addr2,'EDI_SURNAME') > 0 then
2427: p_error_msg5 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line3' ;
2428: p_error_count := p_error_count + 1;
2429: end if;
2430: if pay_gb_eoy_magtape.validate_input(l_addr3,'EDI_SURNAME') > 0 then

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

2426: if pay_gb_eoy_magtape.validate_input(l_addr2,'EDI_SURNAME') > 0 then
2427: p_error_msg5 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line3' ;
2428: p_error_count := p_error_count + 1;
2429: end if;
2430: if pay_gb_eoy_magtape.validate_input(l_addr3,'EDI_SURNAME') > 0 then
2431: p_error_msg6 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line3' ;
2432: p_error_count := p_error_count + 1;
2433: end if;
2434: if pay_gb_eoy_magtape.validate_input(l_addr4,'EDI_SURNAME') > 0 then

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

2430: if pay_gb_eoy_magtape.validate_input(l_addr3,'EDI_SURNAME') > 0 then
2431: p_error_msg6 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line3' ;
2432: p_error_count := p_error_count + 1;
2433: end if;
2434: if pay_gb_eoy_magtape.validate_input(l_addr4,'EDI_SURNAME') > 0 then
2435: p_error_msg7 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line4' ;
2436: p_error_count := p_error_count + 1;
2437: end if;
2438: if pay_gb_eoy_magtape.validate_input(l_addr5,'EDI_SURNAME') > 0 then

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

2434: if pay_gb_eoy_magtape.validate_input(l_addr4,'EDI_SURNAME') > 0 then
2435: p_error_msg7 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line4' ;
2436: p_error_count := p_error_count + 1;
2437: end if;
2438: if pay_gb_eoy_magtape.validate_input(l_addr5,'EDI_SURNAME') > 0 then
2439: p_error_msg8 := ':Employee id ' || l_employee_no || ' has illegal Character(s) in Address Line5' ;
2440: p_error_count := p_error_count + 1;
2441: end if;
2442: */