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_13 dependencies on HR_UTILITY

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

28: )
29: IS
30: PRAGMA AUTONOMOUS_TRANSACTION;
31: BEGIN
32: hr_utility.set_location(' Entering: populate_run_msg',111);
33:
34: INSERT INTO pay_message_lines(line_sequence,
35: payroll_id,
36: message_level,

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

45: ,'A'
46: ,substr(p_message_text,1,240)
47: );
48:
49: hr_utility.set_location(' Leaving: populate_run_msg',999);
50: COMMIT;
51: EXCEPTION
52: WHEN OTHERS THEN
53: hr_utility.trace('Error occured in populate_run_msg');

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

49: hr_utility.set_location(' Leaving: populate_run_msg',999);
50: COMMIT;
51: EXCEPTION
52: WHEN OTHERS THEN
53: hr_utility.trace('Error occured in populate_run_msg');
54: RAISE;
55: END populate_run_msg;
56:
57:

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

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

Line 120: hr_utility.set_location('l_payroll_rec.paye_ref '|| l_payroll_rec.paye_ref, 10);

116: open csr_payroll_details_2(l_payroll_rec.paye_ref,l_payroll_rec.orgid);
117: fetch csr_payroll_details_2 into l_tax_details;
118: close csr_payroll_details_2;
119:
120: hr_utility.set_location('l_payroll_rec.paye_ref '|| l_payroll_rec.paye_ref, 10);
121: hr_utility.set_location('l_payroll_rec.orgid '|| l_payroll_rec.orgid, 10);
122: hr_utility.set_location('l_tax_details.sautr '|| l_tax_details.sautr, 10);
123: hr_utility.set_location('l_tax_details.cotaxref '|| l_tax_details.cotaxref, 10);
124:

Line 121: hr_utility.set_location('l_payroll_rec.orgid '|| l_payroll_rec.orgid, 10);

117: fetch csr_payroll_details_2 into l_tax_details;
118: close csr_payroll_details_2;
119:
120: hr_utility.set_location('l_payroll_rec.paye_ref '|| l_payroll_rec.paye_ref, 10);
121: hr_utility.set_location('l_payroll_rec.orgid '|| l_payroll_rec.orgid, 10);
122: hr_utility.set_location('l_tax_details.sautr '|| l_tax_details.sautr, 10);
123: hr_utility.set_location('l_tax_details.cotaxref '|| l_tax_details.cotaxref, 10);
124:
125: -- Sender Id

Line 122: hr_utility.set_location('l_tax_details.sautr '|| l_tax_details.sautr, 10);

118: close csr_payroll_details_2;
119:
120: hr_utility.set_location('l_payroll_rec.paye_ref '|| l_payroll_rec.paye_ref, 10);
121: hr_utility.set_location('l_payroll_rec.orgid '|| l_payroll_rec.orgid, 10);
122: hr_utility.set_location('l_tax_details.sautr '|| l_tax_details.sautr, 10);
123: hr_utility.set_location('l_tax_details.cotaxref '|| l_tax_details.cotaxref, 10);
124:
125: -- Sender Id
126: if l_payroll_rec.sender_id = ' ' or l_payroll_rec.sender_id is null then

Line 123: hr_utility.set_location('l_tax_details.cotaxref '|| l_tax_details.cotaxref, 10);

119:
120: hr_utility.set_location('l_payroll_rec.paye_ref '|| l_payroll_rec.paye_ref, 10);
121: hr_utility.set_location('l_payroll_rec.orgid '|| l_payroll_rec.orgid, 10);
122: hr_utility.set_location('l_tax_details.sautr '|| l_tax_details.sautr, 10);
123: hr_utility.set_location('l_tax_details.cotaxref '|| l_tax_details.cotaxref, 10);
124:
125: -- Sender Id
126: if l_payroll_rec.sender_id = ' ' or l_payroll_rec.sender_id is null then
127: hr_utility.set_location('The Sender ID is missing.',10);

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

123: hr_utility.set_location('l_tax_details.cotaxref '|| l_tax_details.cotaxref, 10);
124:
125: -- Sender Id
126: if l_payroll_rec.sender_id = ' ' or l_payroll_rec.sender_id is null then
127: hr_utility.set_location('The Sender ID is missing.',10);
128: fnd_file.put_line(fnd_file.output,'The Sender ID is missing.');
129: l_err := true;
130: end if;
131:

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

130: end if;
131:
132: -- HMRC Office Number
133: if l_payroll_rec.tax_office_no = ' ' or l_payroll_rec.tax_office_no is null then
134: hr_utility.set_location('The HMRC Office number is missing.',10);
135: fnd_file.put_line(fnd_file.output,'The HMRC Office number is missing.');
136: l_err := true;
137: elsif validate_input(substr(l_payroll_rec.tax_office_no,1,3),'NUMBER') > 0
138: then

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

135: fnd_file.put_line(fnd_file.output,'The HMRC Office number is missing.');
136: l_err := true;
137: elsif validate_input(substr(l_payroll_rec.tax_office_no,1,3),'NUMBER') > 0
138: then
139: hr_utility.set_location('The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.',10);
140: fnd_file.put_line(fnd_file.output,'The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.');
141: l_err := true;
142: end if;
143:

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

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

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

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

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

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

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

157: hr_utility.set_location('The Employer Name is missing.',10);
158: fnd_file.put_line(fnd_file.output,'The Employer Name is missing.');
159: l_err := true;
160: elsif validate_input(l_payroll_rec.employer_name,'EMP_NAME') > 0 then
161: hr_utility.set_location('The Employer Name '||l_payroll_rec.employer_name ||' has invalid characters.',10);
162: fnd_file.put_line(fnd_file.output,'The Employer Name '||l_payroll_rec.employer_name ||' has invalid characters.');
163: l_err := true;
164: end if;
165:

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

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

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

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

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

178:
179: -- Econ
180: if l_payroll_rec.econ is not null then
181: IF econ_validate(l_payroll_rec.econ) = 0 THEN
182: hr_utility.set_location('ECON Number '||l_payroll_rec.econ ||' is invalid',10);
183: fnd_file.put_line(fnd_file.output,'ECON Number '||l_payroll_rec.econ ||' is invalid.');
184: l_err := true;
185: END IF;
186: END IF;

Line 191: hr_utility.set_location('Self Assessment Unique Tax Ref (SAUTR) and Corporation Tax Ref (COTAXREF) are mutually exclusive, hence only one value can be present at a time.',10);

187:
188: --Self Assessment Unique Tax Ref (SAUTR) and Corporation Tax Ref (COTAXREF) are mutually exclusive, so only one value can be present at a time.
189:
190: if l_tax_details.sautr is not null and l_tax_details.cotaxref is not null then
191: hr_utility.set_location('Self Assessment Unique Tax Ref (SAUTR) and Corporation Tax Ref (COTAXREF) are mutually exclusive, hence only one value can be present at a time.',10);
192: fnd_file.put_line(fnd_file.output,'Self Assessment Unique Tax Ref (SAUTR) and Corporation Tax Ref (COTAXREF) are mutually exclusive, hence only one value can be present at a time.');
193: l_err := true;
194: end if;
195:

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

197: flag := 'N';
198: raise l_exp; -- Raising Exception when error is found
199: end if;
200:
201: hr_utility.set_location('Leaving '|| l_proc, 10);
202: EXCEPTION
203: when l_exp then
204: raise_application_error(-20001,'Errors found while archiving data.');
205:

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

273: l_year1 number;
274: l_year2 number;
275:
276: BEGIN
277: hr_utility.set_location('Entering '||l_proc,10);
278: edi_validation_fail := 'N'; -- Initialized validation fail to N
279:
280: -- Assignment Number
281: l_assignment_number := p_tab_rec_data(2).act_info13;

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

495: edi_validation_fail := 'Y';
496: END IF;
497:
498:
499: hr_utility.set_location('Leaving'||l_proc,10);
500: END person_address_validations;
501: --
502: -- Person Address validations
503: PROCEDURE person_addr_validations_aggr( p_assactid IN NUMBER,

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

545: l_year1 number;
546: l_year2 number;
547:
548: BEGIN
549: hr_utility.set_location('Entering '||l_proc,10);
550: edi_validation_fail := 'N'; -- Initialized validation fail to N
551:
552: -- Assignment Number
553: --l_assignment_number := p_tab_rec_data(2).act_info13;

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

770: edi_validation_fail := 'Y';
771: END IF;
772:
773:
774: hr_utility.set_location('Leaving'||l_proc,10);
775: END person_addr_validations_aggr;
776: --
777:
778:

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

858: l_eff_date date;
859:
860:
861: BEGIN
862: hr_utility.set_location('Entering: '||l_proc,1);
863:
864: edi_validation_fail := 'N'; -- Initialized validation fail to N
865:
866: -- Assigning values to the local variables

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

1301: edi_validation_fail := 'Y';
1302: END IF;
1303:
1304:
1305: hr_utility.set_location('Leaving '||l_proc,1);
1306:
1307: END assignment_validations;
1308: --
1309: /*--------------------------------------------------------------------------

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

1388: l_eff_date date;
1389:
1390:
1391: BEGIN
1392: hr_utility.set_location('Entering: '||l_proc,1);
1393:
1394: edi_validation_fail := 'N'; -- Initialized validation fail to N
1395:
1396: -- Assigning values to the local variables

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

1836: edi_validation_fail := 'Y';
1837: END IF;
1838:
1839:
1840: hr_utility.set_location('Leaving '||l_proc,1);
1841:
1842: END assignment_validations_aggr;
1843: --
1844: --

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

1875: l_gender varchar2(1);
1876:
1877:
1878: BEGIN
1879: hr_utility.set_location('Entering: '||l_proc,1);
1880:
1881: edi_validation_fail := 'N'; -- Initialized validation fail to N
1882:
1883: begin

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

1888: l_gender := p_tab_rec_data(0).act_info9;
1889: exception
1890: when others then
1891: -- fetch the details using asg action id
1892: hr_utility.set_location('Getting from asg_act_id' ,2);
1893: select paaf.assignment_number,papf.sex into l_assignment_number,l_gender from per_all_assignments_f paaf,
1894: pay_assignment_Actions paa ,
1895: per_all_people_f papf where
1896: paa.assignment_action_id = p_assactid

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

1897: and paa.assignment_id = paaf.assignment_id
1898: and paaf.person_id = papf.person_id
1899: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date
1900: and p_effective_date between papf.effective_start_date and papf.effective_end_date;
1901: hr_utility.set_location('l_assignment_number: ' || l_assignment_number ,2);
1902: end;
1903:
1904: -- Assigning values to the local variables
1905: l_ni_category := p_tab_rec_data(p_index).act_info1;

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

2067: l_proc CONSTANT VARCHAR2(70):= g_package||'footer_validations';
2068: l_err BOOLEAN := FALSE;
2069:
2070: BEGIN
2071: hr_utility.set_location('Entering: '||l_proc,1);
2072:
2073: -- ECON Validations
2074: /* 16505555 Bug Fix- Validation Rule -110*/
2075: IF g_econ_ni_check = 'Y' THEN

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

2073: -- ECON Validations
2074: /* 16505555 Bug Fix- Validation Rule -110*/
2075: IF g_econ_ni_check = 'Y' THEN
2076: IF econ IS NULL THEN
2077: hr_utility.set_location('ECON is missing.',10);
2078: fnd_file.put_line(fnd_file.output,'ECON is missing.');
2079: l_err := true;
2080: END IF;
2081: END IF;

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

2084: flag := 'Y';
2085: else flag := 'N';
2086: end if;
2087:
2088: hr_utility.set_location('Leaving '|| l_proc, 10);
2089: END footer_validations;
2090:
2091:
2092: -- Returns 1 on success, 0 on failure

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

2099: l_reminder number;
2100: l_check_letters varchar2(19) := 'ABCDEFHJKLMNPQRTWXY';
2101:
2102: begin
2103: hr_utility.trace('Entering ECON Validate');
2104:
2105: -- Format Check ENNNNNNNA
2106: IF regexp_instr(econ,'^E[[:digit:]]{7}[[:alpha:]]$') = 0 THEN
2107: hr_utility.set_location('ECON Validation Fails',10);

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

2103: hr_utility.trace('Entering ECON Validate');
2104:
2105: -- Format Check ENNNNNNNA
2106: IF regexp_instr(econ,'^E[[:digit:]]{7}[[:alpha:]]$') = 0 THEN
2107: hr_utility.set_location('ECON Validation Fails',10);
2108: return 0;-- Validation fails
2109: END IF;
2110:
2111: -- First Char must be E

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

2109: END IF;
2110:
2111: -- First Char must be E
2112: IF substr(econ,1,1) <> 'E' THEN
2113: hr_utility.set_location('ECON Validation Fails',10);
2114: return 0;-- Validation fails
2115:
2116: -- Next 7 should be numeric ranging 3000000 up to 3999999
2117: ELSIF substr(econ,2,7) < 3000000 OR substr(econ,2,7) > 3999999 THEN

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

2114: return 0;-- Validation fails
2115:
2116: -- Next 7 should be numeric ranging 3000000 up to 3999999
2117: ELSIF substr(econ,2,7) < 3000000 OR substr(econ,2,7) > 3999999 THEN
2118: hr_utility.set_location('ECON Validation Fails',20);
2119: return 0;-- Validation fails
2120: END IF;
2121:
2122: -- Last char must be alpha satifying modulas 19 rule

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

2128: l_sum := l_sum + l_fixed_value;
2129: l_reminder := mod(l_sum,19);
2130:
2131: IF substr(l_check_letters,l_reminder+1,1) <> substr(econ,9,1) THEN
2132: hr_utility.set_location('ECON Validation Fails',30);
2133: return 0; -- Validation Fails
2134: END IF;
2135:
2136: return 1; -- Validation passes

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

2133: return 0; -- Validation Fails
2134: END IF;
2135:
2136: return 1; -- Validation passes
2137: hr_utility.trace('Leaving ECON Validate');
2138: END econ_validate;
2139:
2140: --
2141: -- Function to validate the format of the fields

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

2159: l_translated_value varchar2(200); -- Required to output failing char.
2160: --
2161: BEGIN
2162: --
2163: hr_utility.trace('Entering validate_input');
2164: hr_utility.trace('p_validate_mode='||p_validate_mode);
2165: hr_utility.trace('p_input_value='||p_input_value);
2166: --
2167:

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

2160: --
2161: BEGIN
2162: --
2163: hr_utility.trace('Entering validate_input');
2164: hr_utility.trace('p_validate_mode='||p_validate_mode);
2165: hr_utility.trace('p_input_value='||p_input_value);
2166: --
2167:
2168: if p_validate_mode = 'EMP_NAME' then

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

2161: BEGIN
2162: --
2163: hr_utility.trace('Entering validate_input');
2164: hr_utility.trace('p_validate_mode='||p_validate_mode);
2165: hr_utility.trace('p_input_value='||p_input_value);
2166: --
2167:
2168: if p_validate_mode = 'EMP_NAME' then
2169: if ( substr(p_input_value,1,1) =' ') then

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

2166: --
2167:
2168: if p_validate_mode = 'EMP_NAME' then
2169: if ( substr(p_input_value,1,1) =' ') then
2170: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
2171: l_valid := 2;
2172: else
2173: l_translated_value :=
2174: translate(p_input_value,

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

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

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

2190: translate(p_input_value,
2191: l_invalid_char||l_number_chk,l_invalid_char);
2192:
2193: if l_translated_value is not null then
2194: hr_utility.trace('Invalid chars found: '||l_translated_value);
2195: l_valid := 1; -- Not valid
2196: else
2197: l_valid := 0; -- Valid
2198: end if;

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

2201: --
2202: -- Check for Valid First Char
2203: --
2204: if ( substr(p_input_value,1,1) =' ') then
2205: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
2206: l_valid := 2;
2207: else
2208: l_translated_value :=
2209: translate(p_input_value,

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

2209: translate(p_input_value,
2210: l_invalid_char||l_char_chk||l_number_chk||l_char_set_B||l_space,l_invalid_char);
2211:
2212: if l_translated_value is not null then
2213: hr_utility.trace('Invalid chars found: '||l_translated_value);
2214: l_valid := 1; -- Not valid
2215: else
2216: l_valid := 0; -- Valid
2217: end if;

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

2222: -- Check for Valid First Char
2223: --
2224: if not (substr(p_input_value,1,1) between 'A' and 'Z'
2225: or substr(p_input_value,1,1) between 'a' and 'z') then
2226: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
2227: l_valid := 2;
2228: else
2229: l_translated_value :=
2230: translate(p_input_value,

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

2230: translate(p_input_value,
2231: l_invalid_char||l_mix_chars||l_char_set_D||l_space,l_invalid_char);
2232:
2233: if l_translated_value is not null then
2234: hr_utility.trace('Invalid chars found: '||l_translated_value);
2235: l_valid := 1; -- Not valid
2236: else
2237: l_valid := 0; -- Valid
2238: end if;

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

2243: -- Check for Valid First Char
2244: --
2245: if not (substr(p_input_value,1,1) between 'A' and 'Z'
2246: or substr(p_input_value,1,1) between 'a' and 'z') then
2247: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
2248: l_valid := 2;
2249: else
2250: l_translated_value :=
2251: translate(p_input_value,

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

2251: translate(p_input_value,
2252: l_invalid_char||l_mix_chars||l_char_set_C||l_space,l_invalid_char);
2253:
2254: if l_translated_value is not null then
2255: hr_utility.trace('Invalid chars found: '||l_translated_value);
2256: l_valid := 1; -- Not valid
2257: else
2258: l_valid := 0; -- Valid
2259: end if;

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

2265: --
2266: if not (substr(p_input_value,1,1) between 'A' and 'Z'
2267: or substr(p_input_value,1,1) between 'a' and 'z' or substr(p_input_value,1,1) between '0' and '9') then
2268: -- First char invalid
2269: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
2270: l_valid := 2;
2271: else
2272: l_translated_value :=
2273: translate(p_input_value,

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

2273: translate(p_input_value,
2274: l_invalid_char||l_mix_chars||l_number_chk||l_space||l_char_set_B,l_invalid_char);
2275:
2276: if l_translated_value is not null then
2277: hr_utility.trace('Invalid chars found: '||l_translated_value);
2278: l_valid := 1; --Invalid
2279: else
2280: l_valid := 0; -- Valid
2281: end if;

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

2283:
2284: elsif p_validate_mode = 'COUNTRY' then
2285: if not (substr(p_input_value,1,1) between 'A' and 'Z' or
2286: substr(p_input_value,1,1) between 'a' and 'z' ) then
2287: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
2288: l_valid := 2;
2289: else
2290: l_translated_value :=
2291: translate(p_input_value,

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

2291: translate(p_input_value,
2292: l_invalid_char||l_mix_chars||l_number_chk||l_space||l_char_set_B,l_invalid_char);
2293:
2294: if l_translated_value is not null then
2295: hr_utility.trace('Invalid chars found: '||l_translated_value);
2296: l_valid := 1; -- Not valid
2297: else
2298: l_valid := 0; -- Valid
2299: end if;

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

2304:
2305: if not (substr(p_input_value,1,1) between 'A' and 'Z'
2306: or substr(p_input_value,1,1) between 'a' and 'z' or substr(p_input_value,1,1) between '0' and '9') then
2307: -- First char invalid
2308: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
2309: l_valid := 2;
2310: else
2311: l_translated_value := translate(p_input_value,
2312: l_invalid_char||l_mix_chars||l_number_chk||l_space,l_invalid_char);

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_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 2329: hr_utility.trace('Invalid chars found: '||l_translated_value);

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

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

2334:
2335:
2336: elsif p_validate_mode = 'PAYROLLID' then
2337: if ( substr(p_input_value,1,1) =' ') then
2338: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
2339: l_valid := 2;
2340: else
2341: l_translated_value :=
2342: translate(p_input_value,

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

2342: translate(p_input_value,
2343: l_invalid_char||l_mix_chars||l_number_chk||l_char_set_B||l_space,l_invalid_char);
2344:
2345: if l_translated_value is not null then
2346: hr_utility.trace('Invalid chars found: '||l_translated_value);
2347: l_valid := 1; -- Not valid
2348: else
2349: l_valid := 0; -- Valid
2350: end if;

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

2351: end if ;
2352:
2353: END IF;
2354: --
2355: hr_utility.trace('Leaving validate_input');
2356: return l_valid;
2357: end validate_input;
2358:
2359: -- Function for validating Date fields

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

2384: open csr_parameter_info;
2385: fetch csr_parameter_info into l_test_submission,l_tax_date;
2386: close csr_parameter_info;
2387:
2388: hr_utility.trace('date as parameter : '||p_validate_date);
2389:
2390: l_tax_year := to_char(l_tax_date,'RRRR');
2391: if (l_tax_date > to_date(l_tax_year||'0405','RRRRMMDD')) THEN
2392: l_tax_date := ADD_MONTHS(to_date(l_tax_year||'0405','RRRRMMDD'),12) ; /*tax year end date*/