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

Line 103: hr_utility.trace('ERROR: EIN is NULL');

99: */
100: IF p_input_2 IS NULL
101: THEN
102: --{
103: hr_utility.trace('ERROR: EIN is NULL');
104: l_description:='EIN '||substr(p_input_2,1,9)||
105: ' is Invalid. EIN cannot be NULL';
106: pay_core_utils.push_message(801,'PAY_INVALID_ER_FORMAT','P');
107: pay_core_utils.push_token('record_name',p_record_name);

Line 153: hr_utility.trace('Input SSN before Validation '||p_input_2);

149: ssn_check ssn_special_number_rec;
150: BEGIN
151: /* SSN valid check */
152:
153: hr_utility.trace('Input SSN before Validation '||p_input_2);
154: IF ((p_report_qualifier = 'MN_SQWL') OR
155: (p_report_qualifier = 'GA_SQWL')) THEN
156: -- Character hypen, period and quotes are eliminated
157: l_ssn := replace(replace(replace(

Line 167: hr_utility.trace('SSN after eliminating special chars = '||l_ssn);

163: replace(pay_us_reporting_utils_pkg.character_check(p_input_2),
164: ' '),'I'),'-'),'.'),'''');
165: END IF;
166:
167: hr_utility.trace('SSN after eliminating special chars = '||l_ssn);
168: -- Validation for SSN starting with 8 or 9
169: -- When SSN starting with 8 or 9 a warning is logged
170: --
171: IF ((substr(l_ssn,1,1) = '8') OR (substr(l_ssn,1,1) = '9')) THEN

Line 183: hr_utility.trace('Warning in '||p_record_name||'for employee '||

179: pay_core_utils.push_token('name_or_number',substr(p_input_4,1,50));
180: pay_core_utils.push_token('description',substr(l_description,1,50));
181: /* WARNING in RW record for employee 1234.SSN 912345697 is invalid.SSN
182: cannot begin with 9 */
183: hr_utility.trace('Warning in '||p_record_name||'for employee '||
184: p_input_4||l_description);
185: ELSE
186: -- Validation for Special numbers wrongly used as SSN
187: -- An error is logged for these numbers

Line 201: hr_utility.trace(l_description);

197: FOR i in 1 .. 8 LOOP
198: IF l_ssn = ssn_check(i).p_number_set THEN
199: l_err:=TRUE;
200: l_description := 'Social Security '||l_ssn||' is Invalid.';
201: hr_utility.trace(l_description);
202: END IF;
203: END LOOP;
204: END IF; -- End of check for SSN starting with 8 or 9
205:

Line 215: hr_utility.trace('Error in '||p_record_name||'for employee '||

211: pay_core_utils.push_token('name_or_number',substr(p_input_4,1,50));
212: pay_core_utils.push_token('description',substr(l_description,1,50));
213: /* Error in RW record for employee 1234.SSN 912345697 is
214: invalid.SSN cannot begin with 9 */
215: hr_utility.trace('Error in '||p_record_name||'for employee '||
216: p_input_4||l_description);
217: return_value:= rpad(substr(l_ssn,1,9),9);
218: IF p_report_type = 'SQWL' THEN /*Bug:2309772. */
219: l_err := FALSE;

Line 222: hr_utility.trace('Valid SSN');

218: IF p_report_type = 'SQWL' THEN /*Bug:2309772. */
219: l_err := FALSE;
220: END IF;
221: ELSE
222: hr_utility.trace('Valid SSN');
223: IF l_ssn IS NULL THEN --SSN null check
224: return_value:= '000000000';
225: IF p_report_qualifier = 'AZ_SQWL' THEN
226: hr_utility.trace('SSN is BLANK.Padding spaces to 1 ');

Line 226: hr_utility.trace('SSN is BLANK.Padding spaces to 1 ');

222: hr_utility.trace('Valid SSN');
223: IF l_ssn IS NULL THEN --SSN null check
224: return_value:= '000000000';
225: IF p_report_qualifier = 'AZ_SQWL' THEN
226: hr_utility.trace('SSN is BLANK.Padding spaces to 1 ');
227: return_value := rpad('1',9);
228: ELSE
229: l_description:= 'SSN is blank. Padded with zeros';
230: -- Bug # 2183859

Line 237: hr_utility.trace('Warning in '||p_record_name||'for employee '||

233: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
234: pay_core_utils.push_token('name_or_number',substr(p_input_4,1,50));
235: pay_core_utils.push_token('description',substr(l_description,1,50));
236: /* WARNING in RW record for employee 1234.SSN is blank padded with zeros*/
237: hr_utility.trace('Warning in '||p_record_name||'for employee '||
238: p_input_4||l_description);
239: END IF;
240: -- If SSN is I after stripping hypen, period and quotes a warning message
241: -- is logged and I padded with blanks is reported as SSN

Line 247: hr_utility.trace('Valid SSN after all checks = '||return_value);

243: ELSIF l_ssn = 'I' THEN
244: return_value := rpad(l_ssn,9);
245: ELSE
246: -- If SSN is valid and Not Null
247: hr_utility.trace('Valid SSN after all checks = '||return_value);
248: return_value:= rpad(substr(l_ssn,1,9),9);
249: END IF; --SSN null check
250: END IF; -- SSN valid check
251: p_err := l_err;

Line 291: hr_utility.trace('Input SSN before Validation '||p_input_2);

287: INDEX BY binary_integer;
288: ssn_check ssn_special_number_rec;
289: BEGIN
290: /* SSN validation for W2 reporting */
291: hr_utility.trace('Input SSN before Validation '||p_input_2);
292:
293: -- Character I is eliminated in addition to hypen, period and quotes
294: l_ssn := replace(replace(replace(replace(
295: replace(pay_us_reporting_utils_pkg.character_check(p_input_2),

Line 297: hr_utility.trace('SSN after eliminating special chars = '||l_ssn);

293: -- Character I is eliminated in addition to hypen, period and quotes
294: l_ssn := replace(replace(replace(replace(
295: replace(pay_us_reporting_utils_pkg.character_check(p_input_2),
296: ' '),'I'),'-'),'.'),'''');
297: hr_utility.trace('SSN after eliminating special chars = '||l_ssn);
298: l_1st_three_chars := substr(l_ssn,1,3);
299: l_last_four_chars := substr(l_ssn,(length(l_ssn)-3));
300:
301: -- Validation for SSN starting with 8 or 9

Line 330: hr_utility.trace(l_description);

326: FOR i in 1 .. 8 LOOP
327: IF l_ssn = ssn_check(i).p_number_set THEN
328: l_warning :=TRUE;
329: l_description := 'SSN '||l_ssn||' has Invalid combinations.';
330: hr_utility.trace(l_description);
331: END IF;
332: END LOOP;
333: -- First 3 digits of SSN should not be 000 or 666
334: if (l_1st_three_chars = '000' or

Line 339: hr_utility.trace(l_description);

335: l_1st_three_chars = '666' ) then
336: --{
337: l_warning:=TRUE;
338: l_description := 'SSN '||l_ssn||' is Invalid as 1st 3 digits 000/666';
339: hr_utility.trace(l_description);
340: --}
341: -- Last 4 digits of SSN should not be 0000
342: elsif (l_last_four_chars = '0000') then
343: l_warning:=TRUE;

Line 345: hr_utility.trace(l_description);

341: -- Last 4 digits of SSN should not be 0000
342: elsif (l_last_four_chars = '0000') then
343: l_warning:=TRUE;
344: l_description := 'SSN '||l_ssn||' is Invalid as last 4 digits 0000';
345: hr_utility.trace(l_description);
346: end if;
347:
348: END IF; -- End of check for SSN starting with 8 or 9
349:

Line 367: hr_utility.trace('WARNING: in '||p_record_name||'for employee '||

363: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
364: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
365: pay_core_utils.push_token('name_or_number',substr(p_input_4,1,50));
366: pay_core_utils.push_token('description',substr(l_description,1,50));
367: hr_utility.trace('WARNING: in '||p_record_name||'for employee '||
368: p_input_4||l_description);
369: END IF; -- SSN valid check
370: p_err := FALSE;
371: return return_value;