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 PAY_CORE_UTILS

Line 106: pay_core_utils.push_message(801,'PAY_INVALID_ER_FORMAT','P');

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);
108: pay_core_utils.push_token('name_or_number',p_input_4);
109: pay_core_utils.push_token('description',l_description);
110: l_err:=TRUE;

Line 107: pay_core_utils.push_token('record_name',p_record_name);

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);
108: pay_core_utils.push_token('name_or_number',p_input_4);
109: pay_core_utils.push_token('description',l_description);
110: l_err:=TRUE;
111: --}

Line 108: pay_core_utils.push_token('name_or_number',p_input_4);

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);
108: pay_core_utils.push_token('name_or_number',p_input_4);
109: pay_core_utils.push_token('description',l_description);
110: l_err:=TRUE;
111: --}
112: END IF;

Line 109: pay_core_utils.push_token('description',l_description);

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);
108: pay_core_utils.push_token('name_or_number',p_input_4);
109: pay_core_utils.push_token('description',l_description);
110: l_err:=TRUE;
111: --}
112: END IF;
113: p_err := l_err;

Line 177: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');

173: substr(l_ssn,1,1);
174: --l_err:=TRUE;
175: -- Bug # 2183859
176: -- This should be a warning instead of an error
177: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
178: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
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

Line 178: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));

174: --l_err:=TRUE;
175: -- Bug # 2183859
176: -- This should be a warning instead of an error
177: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
178: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
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 */

Line 179: pay_core_utils.push_token('name_or_number',substr(p_input_4,1,50));

175: -- Bug # 2183859
176: -- This should be a warning instead of an error
177: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
178: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
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 '||

Line 180: pay_core_utils.push_token('description',substr(l_description,1,50));

176: -- This should be a warning instead of an error
177: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
178: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
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);

Line 209: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');

205:
206: -- For SQWL an error message is logged but record is not invalidated
207: -- when these numbers used as SSN
208: IF l_err THEN
209: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
210: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
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

Line 210: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));

206: -- For SQWL an error message is logged but record is not invalidated
207: -- when these numbers used as SSN
208: IF l_err THEN
209: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
210: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
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 */

Line 211: pay_core_utils.push_token('name_or_number',substr(p_input_4,1,50));

207: -- when these numbers used as SSN
208: IF l_err THEN
209: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
210: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
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 '||

Line 212: pay_core_utils.push_token('description',substr(l_description,1,50));

208: IF l_err THEN
209: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
210: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));
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);

Line 232: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');

228: ELSE
229: l_description:= 'SSN is blank. Padded with zeros';
230: -- Bug # 2183859
231: -- This would be a informative warning
232: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
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*/

Line 233: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));

229: l_description:= 'SSN is blank. Padded with zeros';
230: -- Bug # 2183859
231: -- This would be a informative warning
232: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
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 '||

Line 234: pay_core_utils.push_token('name_or_number',substr(p_input_4,1,50));

230: -- Bug # 2183859
231: -- This would be a informative warning
232: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
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);

Line 235: pay_core_utils.push_token('description',substr(l_description,1,50));

231: -- This would be a informative warning
232: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
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;

Line 363: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');

359:
360: -- For W2 a warning message is logged but record is processed without Invalidating
361: --
362: IF l_warning THEN
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 '||

Line 364: pay_core_utils.push_token('record_name',substr(p_record_name,1,50));

360: -- For W2 a warning message is logged but record is processed without Invalidating
361: --
362: IF l_warning THEN
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);

Line 365: pay_core_utils.push_token('name_or_number',substr(p_input_4,1,50));

361: --
362: IF l_warning THEN
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

Line 366: pay_core_utils.push_token('description',substr(l_description,1,50));

362: IF l_warning THEN
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;