eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_RTI_FPS_VALIDATE dependencies on HR_UTILITY

Line 48: hr_utility.set_location(' Entering: populate_run_msg',111);

44: )
45: IS
46: PRAGMA AUTONOMOUS_TRANSACTION;
47: BEGIN
48: hr_utility.set_location(' Entering: populate_run_msg',111);
49:
50: INSERT INTO pay_message_lines(line_sequence,
51: payroll_id,
52: message_level,

Line 65: hr_utility.set_location(' Leaving: populate_run_msg',999);

61: ,'A'
62: ,substr(p_message_text,1,240)
63: );
64:
65: hr_utility.set_location(' Leaving: populate_run_msg',999);
66: COMMIT;
67: EXCEPTION
68: WHEN OTHERS THEN
69: hr_utility.trace('Error occured in populate_run_msg');

Line 69: hr_utility.trace('Error occured in populate_run_msg');

65: hr_utility.set_location(' Leaving: populate_run_msg',999);
66: COMMIT;
67: EXCEPTION
68: WHEN OTHERS THEN
69: hr_utility.trace('Error occured in populate_run_msg');
70: RAISE;
71: END populate_run_msg;
72:
73:

Line 110: hr_utility.set_location('Entering '|| l_proc, 10);

106: l_payroll_rec csr_payroll_details%rowtype;
107:
108: BEGIN
109:
110: hr_utility.set_location('Entering '|| l_proc, 10);
111: l_err := FALSE;
112: flag := 'Y';
113:
114: open csr_payroll_details(p_payroll_action_id);

Line 120: hr_utility.set_location('The Sender ID is missing.',10);

116: close csr_payroll_details;
117:
118: -- Sender Id
119: if l_payroll_rec.sender_id = ' ' or l_payroll_rec.sender_id is null then
120: hr_utility.set_location('The Sender ID is missing.',10);
121: fnd_file.put_line(fnd_file.output,'The Sender ID is missing.');
122: l_err := true;
123: end if;
124:

Line 127: hr_utility.set_location('The HMRC Office number is missing.',10);

123: end if;
124:
125: -- HMRC Office Number
126: if l_payroll_rec.tax_office_no = ' ' or l_payroll_rec.tax_office_no is null then
127: hr_utility.set_location('The HMRC Office number is missing.',10);
128: fnd_file.put_line(fnd_file.output,'The HMRC Office number is missing.');
129: l_err := true;
130: elsif validate_input(substr(l_payroll_rec.tax_office_no,1,3),'NUMBER') > 0
131: then

Line 132: hr_utility.set_location('The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.',10);

128: fnd_file.put_line(fnd_file.output,'The HMRC Office number is missing.');
129: l_err := true;
130: elsif validate_input(substr(l_payroll_rec.tax_office_no,1,3),'NUMBER') > 0
131: then
132: hr_utility.set_location('The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.',10);
133: fnd_file.put_line(fnd_file.output,'The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.');
134: l_err := true;
135: end if;
136:

Line 139: hr_utility.set_location('The Employer PAYE Reference is missing.',10);

135: end if;
136:
137: -- Employer PAYE Ref
138: if l_payroll_rec.tax_ref_no = ' ' or l_payroll_rec.tax_ref_no is null then
139: hr_utility.set_location('The Employer PAYE Reference is missing.',10);
140: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference is missing.');
141: l_err := true;
142: elsif validate_input(l_payroll_rec.tax_ref_no,'FULL_EDI') > 0 then
143: hr_utility.set_location('The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.',10);

Line 143: hr_utility.set_location('The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.',10);

139: hr_utility.set_location('The Employer PAYE Reference is missing.',10);
140: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference is missing.');
141: l_err := true;
142: elsif validate_input(l_payroll_rec.tax_ref_no,'FULL_EDI') > 0 then
143: hr_utility.set_location('The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.',10);
144: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.');
145: l_err := true;
146: end if;
147:

Line 150: hr_utility.set_location('The Employer Name is missing.',10);

146: end if;
147:
148: -- Employer Name
149: if l_payroll_rec.employer_name = ' ' or l_payroll_rec.employer_name is null then
150: hr_utility.set_location('The Employer Name is missing.',10);
151: fnd_file.put_line(fnd_file.output,'The Employer Name is missing.');
152: l_err := true;
153: elsif validate_input(l_payroll_rec.employer_name,'EMP_NAME') > 0 then
154: hr_utility.set_location('The Employer Name '||l_payroll_rec.employer_name ||' has invalid characters.',10);

Line 154: hr_utility.set_location('The Employer Name '||l_payroll_rec.employer_name ||' has invalid characters.',10);

150: hr_utility.set_location('The Employer Name is missing.',10);
151: fnd_file.put_line(fnd_file.output,'The Employer Name is missing.');
152: l_err := true;
153: elsif validate_input(l_payroll_rec.employer_name,'EMP_NAME') > 0 then
154: hr_utility.set_location('The Employer Name '||l_payroll_rec.employer_name ||' has invalid characters.',10);
155: fnd_file.put_line(fnd_file.output,'The Employer Name '||l_payroll_rec.employer_name ||' has invalid characters.');
156: l_err := true;
157: end if;
158:

Line 161: hr_utility.set_location('The Account Office Reference Number is missing.',10);

157: end if;
158:
159: -- Accounts Office Number
160: if l_payroll_rec.acc_ref_no = ' ' or l_payroll_rec.acc_ref_no is null then
161: hr_utility.set_location('The Account Office Reference Number is missing.',10);
162: fnd_file.put_line(fnd_file.output,'The Account Office Reference Number is missing.');
163: l_err := true;
164: elsif (length(l_payroll_rec.acc_ref_no) > 13
165: OR REGEXP_INSTR(l_payroll_rec.acc_ref_no,'^([[:digit:]]{1,3})P([[:alpha:]]{1})([[:digit:]]{1,7})([[:digit:]]|X)$') = 0 ) THEN

Line 167: hr_utility.set_location ('Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.',10);

163: l_err := true;
164: elsif (length(l_payroll_rec.acc_ref_no) > 13
165: OR REGEXP_INSTR(l_payroll_rec.acc_ref_no,'^([[:digit:]]{1,3})P([[:alpha:]]{1})([[:digit:]]{1,7})([[:digit:]]|X)$') = 0 ) THEN
166:
167: hr_utility.set_location ('Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.',10);
168: fnd_file.put_line(fnd_file.output,'Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.');
169: l_err := true;
170: END IF;
171:

Line 175: hr_utility.set_location('ECON Number '||l_payroll_rec.econ ||' is invalid',10);

171:
172: -- Econ
173: if l_payroll_rec.econ is not null then
174: IF econ_validate(l_payroll_rec.econ) = 0 THEN
175: hr_utility.set_location('ECON Number '||l_payroll_rec.econ ||' is invalid',10);
176: fnd_file.put_line(fnd_file.output,'ECON Number '||l_payroll_rec.econ ||' is invalid.');
177: l_err := true;
178: END IF;
179: END IF;

Line 188: hr_utility.set_location('Leaving '|| l_proc, 10);

184: flag := 'N';
185: raise l_exp; -- Raising Exception when error is found
186: end if;
187:
188: hr_utility.set_location('Leaving '|| l_proc, 10);
189: EXCEPTION
190: when l_exp then
191: raise_application_error(-20001,'Errors found while archiving data.');
192:

Line 264: hr_utility.set_location('Entering '||l_proc,10);

260: l_year1 number;
261: l_year2 number;
262:
263: BEGIN
264: hr_utility.set_location('Entering '||l_proc,10);
265: edi_validation_fail := 'N'; -- Initialized validation fail to N
266:
267: -- Assignment Number
268: l_assignment_number := p_tab_rec_data(2).act_info13;

Line 486: hr_utility.set_location('Leaving'||l_proc,10);

482: edi_validation_fail := 'Y';
483: END IF;
484:
485:
486: hr_utility.set_location('Leaving'||l_proc,10);
487: END person_address_validations;
488: --
489: -- Person Address validations
490: PROCEDURE person_addr_validations_aggr( p_assactid IN NUMBER,

Line 536: hr_utility.set_location('Entering '||l_proc,10);

532: l_year1 number;
533: l_year2 number;
534:
535: BEGIN
536: hr_utility.set_location('Entering '||l_proc,10);
537: edi_validation_fail := 'N'; -- Initialized validation fail to N
538:
539: -- Assignment Number
540: --l_assignment_number := p_tab_rec_data(2).act_info13;

Line 761: hr_utility.set_location('Leaving'||l_proc,10);

757: edi_validation_fail := 'Y';
758: END IF;
759:
760:
761: hr_utility.set_location('Leaving'||l_proc,10);
762: END person_addr_validations_aggr;
763: --
764:
765:

Line 849: hr_utility.set_location('Entering: '||l_proc,1);

845: l_eff_date date;
846:
847:
848: BEGIN
849: hr_utility.set_location('Entering: '||l_proc,1);
850:
851: edi_validation_fail := 'N'; -- Initialized validation fail to N
852:
853: -- Assigning values to the local variables

Line 1292: hr_utility.set_location('Leaving '||l_proc,1);

1288: edi_validation_fail := 'Y';
1289: END IF;
1290:
1291:
1292: hr_utility.set_location('Leaving '||l_proc,1);
1293:
1294: END assignment_validations;
1295: --
1296: /*--------------------------------------------------------------------------

Line 1379: hr_utility.set_location('Entering: '||l_proc,1);

1375: l_eff_date date;
1376:
1377:
1378: BEGIN
1379: hr_utility.set_location('Entering: '||l_proc,1);
1380:
1381: edi_validation_fail := 'N'; -- Initialized validation fail to N
1382:
1383: -- Assigning values to the local variables

Line 1827: hr_utility.set_location('Leaving '||l_proc,1);

1823: edi_validation_fail := 'Y';
1824: END IF;
1825:
1826:
1827: hr_utility.set_location('Leaving '||l_proc,1);
1828:
1829: END assignment_validations_aggr;
1830: --
1831: --

Line 1866: hr_utility.set_location('Entering: '||l_proc,1);

1862: l_gender varchar2(1);
1863:
1864:
1865: BEGIN
1866: hr_utility.set_location('Entering: '||l_proc,1);
1867:
1868: edi_validation_fail := 'N'; -- Initialized validation fail to N
1869:
1870: begin

Line 1879: hr_utility.set_location('Getting from asg_act_id' ,2);

1875: l_gender := p_tab_rec_data(0).act_info9;
1876: exception
1877: when others then
1878: -- fetch the details using asg action id
1879: hr_utility.set_location('Getting from asg_act_id' ,2);
1880: select paaf.assignment_number,papf.sex into l_assignment_number,l_gender from per_all_assignments_f paaf,
1881: pay_assignment_Actions paa ,
1882: per_all_people_f papf where
1883: paa.assignment_action_id = p_assactid

Line 1888: hr_utility.set_location('l_assignment_number: ' || l_assignment_number ,2);

1884: and paa.assignment_id = paaf.assignment_id
1885: and paaf.person_id = papf.person_id
1886: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date
1887: and p_effective_date between papf.effective_start_date and papf.effective_end_date;
1888: hr_utility.set_location('l_assignment_number: ' || l_assignment_number ,2);
1889: end;
1890:
1891: -- Assigning values to the local variables
1892: l_ni_category := p_tab_rec_data(p_index).act_info1;

Line 2058: hr_utility.set_location('Entering: '||l_proc,1);

2054: l_proc CONSTANT VARCHAR2(70):= g_package||'footer_validations';
2055: l_err BOOLEAN := FALSE;
2056:
2057: BEGIN
2058: hr_utility.set_location('Entering: '||l_proc,1);
2059:
2060: -- ECON Validations
2061: IF (final_submission = 'Yes - Final for the Year' OR final_submission = 'Yes - Final for Ceased PAYE Ref') AND g_econ_ni_check = 'Y' THEN
2062: IF econ IS NULL THEN

Line 2063: hr_utility.set_location('ECON is missing.',10);

2059:
2060: -- ECON Validations
2061: IF (final_submission = 'Yes - Final for the Year' OR final_submission = 'Yes - Final for Ceased PAYE Ref') AND g_econ_ni_check = 'Y' THEN
2062: IF econ IS NULL THEN
2063: hr_utility.set_location('ECON is missing.',10);
2064: fnd_file.put_line(fnd_file.output,'ECON is missing.');
2065: l_err := true;
2066: END IF;
2067: END IF;

Line 2074: hr_utility.set_location('Leaving '|| l_proc, 10);

2070: flag := 'Y';
2071: else flag := 'N';
2072: end if;
2073:
2074: hr_utility.set_location('Leaving '|| l_proc, 10);
2075: END footer_validations;
2076:
2077:
2078: -- Returns 1 on success, 0 on failure

Line 2089: hr_utility.trace('Entering ECON Validate');

2085: l_reminder number;
2086: l_check_letters varchar2(19) := 'ABCDEFHJKLMNPQRTWXY';
2087:
2088: begin
2089: hr_utility.trace('Entering ECON Validate');
2090:
2091: -- Format Check ENNNNNNNA
2092: IF regexp_instr(econ,'^E[[:digit:]]{7}[[:alpha:]]$') = 0 THEN
2093: hr_utility.set_location('ECON Validation Fails',10);

Line 2093: hr_utility.set_location('ECON Validation Fails',10);

2089: hr_utility.trace('Entering ECON Validate');
2090:
2091: -- Format Check ENNNNNNNA
2092: IF regexp_instr(econ,'^E[[:digit:]]{7}[[:alpha:]]$') = 0 THEN
2093: hr_utility.set_location('ECON Validation Fails',10);
2094: return 0;-- Validation fails
2095: END IF;
2096:
2097: -- First Char must be E

Line 2099: hr_utility.set_location('ECON Validation Fails',10);

2095: END IF;
2096:
2097: -- First Char must be E
2098: IF substr(econ,1,1) <> 'E' THEN
2099: hr_utility.set_location('ECON Validation Fails',10);
2100: return 0;-- Validation fails
2101:
2102: -- Next 7 should be numeric ranging 3000000 up to 3999999
2103: ELSIF substr(econ,2,7) < 3000000 OR substr(econ,2,7) > 3999999 THEN

Line 2104: hr_utility.set_location('ECON Validation Fails',20);

2100: return 0;-- Validation fails
2101:
2102: -- Next 7 should be numeric ranging 3000000 up to 3999999
2103: ELSIF substr(econ,2,7) < 3000000 OR substr(econ,2,7) > 3999999 THEN
2104: hr_utility.set_location('ECON Validation Fails',20);
2105: return 0;-- Validation fails
2106: END IF;
2107:
2108: -- Last char must be alpha satifying modulas 19 rule

Line 2118: hr_utility.set_location('ECON Validation Fails',30);

2114: l_sum := l_sum + l_fixed_value;
2115: l_reminder := mod(l_sum,19);
2116:
2117: IF substr(l_check_letters,l_reminder+1,1) <> substr(econ,9,1) THEN
2118: hr_utility.set_location('ECON Validation Fails',30);
2119: return 0; -- Validation Fails
2120: END IF;
2121:
2122: return 1; -- Validation passes

Line 2123: hr_utility.trace('Leaving ECON Validate');

2119: return 0; -- Validation Fails
2120: END IF;
2121:
2122: return 1; -- Validation passes
2123: hr_utility.trace('Leaving ECON Validate');
2124: END econ_validate;
2125:
2126: --
2127: -- Function to validate the format of the fields

Line 2149: hr_utility.trace('Entering validate_input');

2145: l_translated_value varchar2(200); -- Required to output failing char.
2146: --
2147: BEGIN
2148: --
2149: hr_utility.trace('Entering validate_input');
2150: hr_utility.trace('p_validate_mode='||p_validate_mode);
2151: hr_utility.trace('p_input_value='||p_input_value);
2152: --
2153:

Line 2150: hr_utility.trace('p_validate_mode='||p_validate_mode);

2146: --
2147: BEGIN
2148: --
2149: hr_utility.trace('Entering validate_input');
2150: hr_utility.trace('p_validate_mode='||p_validate_mode);
2151: hr_utility.trace('p_input_value='||p_input_value);
2152: --
2153:
2154: if p_validate_mode = 'EMP_NAME' then

Line 2151: hr_utility.trace('p_input_value='||p_input_value);

2147: BEGIN
2148: --
2149: hr_utility.trace('Entering validate_input');
2150: hr_utility.trace('p_validate_mode='||p_validate_mode);
2151: hr_utility.trace('p_input_value='||p_input_value);
2152: --
2153:
2154: if p_validate_mode = 'EMP_NAME' then
2155: if ( substr(p_input_value,1,1) =' ') then

Line 2156: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

2152: --
2153:
2154: if p_validate_mode = 'EMP_NAME' then
2155: if ( substr(p_input_value,1,1) =' ') then
2156: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
2157: l_valid := 2;
2158: else
2159: l_translated_value :=
2160: translate(p_input_value,

Line 2164: hr_utility.trace('Invalid chars found: '||l_translated_value);

2160: translate(p_input_value,
2161: l_invalid_char||l_mix_chars||l_number_chk||l_char_set_A||l_space,l_invalid_char);
2162:
2163: if l_translated_value is not null then
2164: hr_utility.trace('Invalid chars found: '||l_translated_value);
2165: l_valid := 1; -- Not valid
2166: else
2167: l_valid := 0; -- Valid
2168: end if;

Line 2180: hr_utility.trace('Invalid chars found: '||l_translated_value);

2176: translate(p_input_value,
2177: l_invalid_char||l_number_chk,l_invalid_char);
2178:
2179: if l_translated_value is not null then
2180: hr_utility.trace('Invalid chars found: '||l_translated_value);
2181: l_valid := 1; -- Not valid
2182: else
2183: l_valid := 0; -- Valid
2184: end if;

Line 2191: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

2187: --
2188: -- Check for Valid First Char
2189: --
2190: if ( substr(p_input_value,1,1) =' ') then
2191: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
2192: l_valid := 2;
2193: else
2194: l_translated_value :=
2195: translate(p_input_value,

Line 2199: hr_utility.trace('Invalid chars found: '||l_translated_value);

2195: translate(p_input_value,
2196: l_invalid_char||l_char_chk||l_number_chk||l_char_set_B||l_space,l_invalid_char);
2197:
2198: if l_translated_value is not null then
2199: hr_utility.trace('Invalid chars found: '||l_translated_value);
2200: l_valid := 1; -- Not valid
2201: else
2202: l_valid := 0; -- Valid
2203: end if;

Line 2212: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

2208: -- Check for Valid First Char
2209: --
2210: if not (substr(p_input_value,1,1) between 'A' and 'Z'
2211: or substr(p_input_value,1,1) between 'a' and 'z') then
2212: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
2213: l_valid := 2;
2214: else
2215: l_translated_value :=
2216: translate(p_input_value,

Line 2220: hr_utility.trace('Invalid chars found: '||l_translated_value);

2216: translate(p_input_value,
2217: l_invalid_char||l_mix_chars||l_char_set_D||l_space,l_invalid_char);
2218:
2219: if l_translated_value is not null then
2220: hr_utility.trace('Invalid chars found: '||l_translated_value);
2221: l_valid := 1; -- Not valid
2222: else
2223: l_valid := 0; -- Valid
2224: end if;

Line 2233: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

2229: -- Check for Valid First Char
2230: --
2231: if not (substr(p_input_value,1,1) between 'A' and 'Z'
2232: or substr(p_input_value,1,1) between 'a' and 'z') then
2233: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
2234: l_valid := 2;
2235: else
2236: l_translated_value :=
2237: translate(p_input_value,

Line 2241: hr_utility.trace('Invalid chars found: '||l_translated_value);

2237: translate(p_input_value,
2238: l_invalid_char||l_mix_chars||l_char_set_C||l_space,l_invalid_char);
2239:
2240: if l_translated_value is not null then
2241: hr_utility.trace('Invalid chars found: '||l_translated_value);
2242: l_valid := 1; -- Not valid
2243: else
2244: l_valid := 0; -- Valid
2245: end if;

Line 2255: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

2251: --
2252: if not (substr(p_input_value,1,1) between 'A' and 'Z'
2253: or substr(p_input_value,1,1) between 'a' and 'z' or substr(p_input_value,1,1) between '0' and '9') then
2254: -- First char invalid
2255: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
2256: l_valid := 2;
2257: else
2258: l_translated_value :=
2259: translate(p_input_value,

Line 2263: hr_utility.trace('Invalid chars found: '||l_translated_value);

2259: translate(p_input_value,
2260: l_invalid_char||l_mix_chars||l_number_chk||l_space||l_char_set_B,l_invalid_char);
2261:
2262: if l_translated_value is not null then
2263: hr_utility.trace('Invalid chars found: '||l_translated_value);
2264: l_valid := 1; --Invalid
2265: else
2266: l_valid := 0; -- Valid
2267: end if;

Line 2273: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

2269:
2270: elsif p_validate_mode = 'COUNTRY' then
2271: if not (substr(p_input_value,1,1) between 'A' and 'Z' or
2272: substr(p_input_value,1,1) between 'a' and 'z' ) then
2273: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
2274: l_valid := 2;
2275: else
2276: l_translated_value :=
2277: translate(p_input_value,

Line 2281: hr_utility.trace('Invalid chars found: '||l_translated_value);

2277: translate(p_input_value,
2278: l_invalid_char||l_mix_chars||l_number_chk||l_space||l_char_set_B,l_invalid_char);
2279:
2280: if l_translated_value is not null then
2281: hr_utility.trace('Invalid chars found: '||l_translated_value);
2282: l_valid := 1; -- Not valid
2283: else
2284: l_valid := 0; -- Valid
2285: end if;

Line 2294: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

2290:
2291: if not (substr(p_input_value,1,1) between 'A' and 'Z'
2292: or substr(p_input_value,1,1) between 'a' and 'z' or substr(p_input_value,1,1) between '0' and '9') then
2293: -- First char invalid
2294: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
2295: l_valid := 2;
2296: else
2297: l_translated_value := translate(p_input_value,
2298: l_invalid_char||l_mix_chars||l_number_chk||l_space,l_invalid_char);

Line 2301: hr_utility.trace('Invalid chars found: '||l_translated_value);

2297: l_translated_value := translate(p_input_value,
2298: l_invalid_char||l_mix_chars||l_number_chk||l_space,l_invalid_char);
2299: --
2300: if l_translated_value is not null then
2301: hr_utility.trace('Invalid chars found: '||l_translated_value);
2302: l_valid := 1; -- Not valid
2303: else
2304: l_valid := 0; -- Valid
2305: end if;

Line 2315: hr_utility.trace('Invalid chars found: '||l_translated_value);

2311: l_translated_value := translate(p_input_value,
2312: l_invalid_char||l_mix_chars||l_number_chk||l_space||l_char_set_B,l_invalid_char);
2313: --
2314: if l_translated_value is not null then
2315: hr_utility.trace('Invalid chars found: '||l_translated_value);
2316: l_valid := 1; -- Not valid
2317: else
2318: l_valid := 0; -- Valid
2319: end if;

Line 2324: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

2320:
2321:
2322: elsif p_validate_mode = 'PAYROLLID' then
2323: if ( substr(p_input_value,1,1) =' ') then
2324: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
2325: l_valid := 2;
2326: else
2327: l_translated_value :=
2328: translate(p_input_value,

Line 2332: hr_utility.trace('Invalid chars found: '||l_translated_value);

2328: translate(p_input_value,
2329: l_invalid_char||l_mix_chars||l_number_chk||l_char_set_B||l_space,l_invalid_char);
2330:
2331: if l_translated_value is not null then
2332: hr_utility.trace('Invalid chars found: '||l_translated_value);
2333: l_valid := 1; -- Not valid
2334: else
2335: l_valid := 0; -- Valid
2336: end if;

Line 2341: hr_utility.trace('Leaving validate_input');

2337: end if ;
2338:
2339: END IF;
2340: --
2341: hr_utility.trace('Leaving validate_input');
2342: return l_valid;
2343: end validate_input;
2344:
2345: -- Function for validating Date fields

Line 2374: hr_utility.trace('date as parameter : '||p_validate_date);

2370: open csr_parameter_info;
2371: fetch csr_parameter_info into l_test_submission,l_tax_date;
2372: close csr_parameter_info;
2373:
2374: hr_utility.trace('date as parameter : '||p_validate_date);
2375:
2376: l_tax_year := to_char(l_tax_date,'RRRR');
2377: if (l_tax_date > to_date(l_tax_year||'0405','RRRRMMDD')) THEN
2378: l_tax_date := ADD_MONTHS(to_date(l_tax_year||'0405','RRRRMMDD'),12) ; /*tax year end date*/