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

Line 22: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);

18:
19: lv_format varchar2(32000);
20:
21: BEGIN
22: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
23:
24: if p_output_file_type = 'CSV' then
25:
26:

Line 27: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);

23:
24: if p_output_file_type = 'CSV' then
25:
26:
27: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
28:
29: lv_format := gc_csv_data_delimiter || p_input_string ||
30: gc_csv_data_delimiter || gc_csv_delimiter;
31:

Line 34: hr_utility.set_location(gv_package_name || '.formated_data_string', 60);

30: gc_csv_data_delimiter || gc_csv_delimiter;
31:
32: end if;
33:
34: hr_utility.set_location(gv_package_name || '.formated_data_string', 60);
35:
36: return lv_format;
37:
38: END formated_data_string;

Line 55: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);

51: lv_format2 varchar2(32000);
52:
53: BEGIN
54:
55: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
56: lv_format1 :=
57: formated_data_string (p_input_string => 'Year'
58: ,p_bold => 'Y'
59: ,p_output_file_type => p_output_file_type) ||

Line 96: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);

92: lv_format1 VARCHAR2(32000);
93:
94: BEGIN
95:
96: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
97: lv_format1 :=
98: formated_data_string (p_input_string => p_year
99: ,p_bold => 'N'
100: ,p_output_file_type => p_output_file_type)||

Line 118: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);

114: ,p_bold => 'N'
115: ,p_output_file_type => p_output_file_type);
116:
117:
118: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
119:
120:
121: hr_utility.trace('Static Data1 = ' || lv_format1);
122: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);

Line 121: hr_utility.trace('Static Data1 = ' || lv_format1);

117:
118: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
119:
120:
121: hr_utility.trace('Static Data1 = ' || lv_format1);
122: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
123:
124: return (lv_format1);
125: END;

Line 122: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);

118: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
119:
120:
121: hr_utility.trace('Static Data1 = ' || lv_format1);
122: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
123:
124: return (lv_format1);
125: END;
126:

Line 155: --hr_utility.trace_on(null,'erre');

151: l_eff_date Date;
152:
153: BEGIN
154:
155: --hr_utility.trace_on(null,'erre');
156: hr_utility.trace('PROCEDURE insert_er_rearch_data');
157: hr_utility.trace('p_tax_unit_id '||to_char(p_tax_unit_id));
158: hr_utility.trace('p_fed_state ' ||p_fed_state);
159: hr_utility.trace('p_state_code '||p_state_code);

Line 156: hr_utility.trace('PROCEDURE insert_er_rearch_data');

152:
153: BEGIN
154:
155: --hr_utility.trace_on(null,'erre');
156: hr_utility.trace('PROCEDURE insert_er_rearch_data');
157: hr_utility.trace('p_tax_unit_id '||to_char(p_tax_unit_id));
158: hr_utility.trace('p_fed_state ' ||p_fed_state);
159: hr_utility.trace('p_state_code '||p_state_code);
160: hr_utility.trace('p_year '||substr(p_year,1,4));

Line 157: hr_utility.trace('p_tax_unit_id '||to_char(p_tax_unit_id));

153: BEGIN
154:
155: --hr_utility.trace_on(null,'erre');
156: hr_utility.trace('PROCEDURE insert_er_rearch_data');
157: hr_utility.trace('p_tax_unit_id '||to_char(p_tax_unit_id));
158: hr_utility.trace('p_fed_state ' ||p_fed_state);
159: hr_utility.trace('p_state_code '||p_state_code);
160: hr_utility.trace('p_year '||substr(p_year,1,4));
161:

Line 158: hr_utility.trace('p_fed_state ' ||p_fed_state);

154:
155: --hr_utility.trace_on(null,'erre');
156: hr_utility.trace('PROCEDURE insert_er_rearch_data');
157: hr_utility.trace('p_tax_unit_id '||to_char(p_tax_unit_id));
158: hr_utility.trace('p_fed_state ' ||p_fed_state);
159: hr_utility.trace('p_state_code '||p_state_code);
160: hr_utility.trace('p_year '||substr(p_year,1,4));
161:
162:

Line 159: hr_utility.trace('p_state_code '||p_state_code);

155: --hr_utility.trace_on(null,'erre');
156: hr_utility.trace('PROCEDURE insert_er_rearch_data');
157: hr_utility.trace('p_tax_unit_id '||to_char(p_tax_unit_id));
158: hr_utility.trace('p_fed_state ' ||p_fed_state);
159: hr_utility.trace('p_state_code '||p_state_code);
160: hr_utility.trace('p_year '||substr(p_year,1,4));
161:
162:
163: OPEN c_yrend_pactid;

Line 160: hr_utility.trace('p_year '||substr(p_year,1,4));

156: hr_utility.trace('PROCEDURE insert_er_rearch_data');
157: hr_utility.trace('p_tax_unit_id '||to_char(p_tax_unit_id));
158: hr_utility.trace('p_fed_state ' ||p_fed_state);
159: hr_utility.trace('p_state_code '||p_state_code);
160: hr_utility.trace('p_year '||substr(p_year,1,4));
161:
162:
163: OPEN c_yrend_pactid;
164: FETCH c_yrend_pactid INTO l_pactid;

Line 168: hr_utility.trace('Pactid not found for GRE id '||to_char(p_tax_unit_id)||' for year' ||p_year);

164: FETCH c_yrend_pactid INTO l_pactid;
165:
166: IF c_yrend_pactid%NOTFOUND THEN
167:
168: hr_utility.trace('Pactid not found for GRE id '||to_char(p_tax_unit_id)||' for year' ||p_year);
169:
170: ELSE
171:
172: hr_utility.trace('Pactid found '||to_char(l_pactid));

Line 172: hr_utility.trace('Pactid found '||to_char(l_pactid));

168: hr_utility.trace('Pactid not found for GRE id '||to_char(p_tax_unit_id)||' for year' ||p_year);
169:
170: ELSE
171:
172: hr_utility.trace('Pactid found '||to_char(l_pactid));
173:
174: OPEN c_gre_name;
175: FETCH c_gre_name INTO l_gre_name;
176: CLOSE c_gre_name;

Line 178: hr_utility.trace(' l_gre_name = '||l_gre_name);

174: OPEN c_gre_name;
175: FETCH c_gre_name INTO l_gre_name;
176: CLOSE c_gre_name;
177:
178: hr_utility.trace(' l_gre_name = '||l_gre_name);
179:
180: l_year := substr(p_year,1,4);
181:
182: fnd_file.put_line(fnd_file.output,employer_rearch_header('CSV'));

Line 186: hr_utility.trace('Federal. p_fed_state = '||p_fed_state);

182: fnd_file.put_line(fnd_file.output,employer_rearch_header('CSV'));
183:
184: IF p_fed_state = 'Federal' THEN
185:
186: hr_utility.trace('Federal. p_fed_state = '||p_fed_state);
187:
188: hr_utility.trace('Going to call eoy_archive_gre_data for Fed');
189: pay_us_archive.eoy_archive_gre_data
190: (l_pactid,

Line 188: hr_utility.trace('Going to call eoy_archive_gre_data for Fed');

184: IF p_fed_state = 'Federal' THEN
185:
186: hr_utility.trace('Federal. p_fed_state = '||p_fed_state);
187:
188: hr_utility.trace('Going to call eoy_archive_gre_data for Fed');
189: pay_us_archive.eoy_archive_gre_data
190: (l_pactid,
191: p_tax_unit_id,
192: 'FED W2 REPORTING RULES REARCH',

Line 215: hr_utility.trace('Going to call eoy_archive_gre_data for State');

211: 'ALL');
212:
213: ELSIF p_fed_state = 'State' THEN
214:
215: hr_utility.trace('Going to call eoy_archive_gre_data for State');
216: pay_us_archive.eoy_archive_gre_data
217: (l_pactid,
218: p_tax_unit_id,
219: 'STATE TAX RULES REARCH',

Line 224: hr_utility.trace('Going to call eoy_archive_gre_data for View Online W2 Profile');

220: p_state_code);
221:
222: ELSIF p_fed_state = 'View Online W2 Profile' THEN
223:
224: hr_utility.trace('Going to call eoy_archive_gre_data for View Online W2 Profile');
225: pay_us_archive.eoy_archive_gre_data
226: (l_pactid,
227: p_tax_unit_id,
228: 'View Online W2 Profile',

Line 234: hr_utility.trace('Going to call eoy_archive_gre_data for Original 1099- on or before Profile');

230:
231: /* Changes for #8239671 Start*/
232: ELSIF p_fed_state = 'Original 1099-R on or before' THEN
233:
234: hr_utility.trace('Going to call eoy_archive_gre_data for Original 1099- on or before Profile');
235: pay_us_archive.eoy_archive_gre_data
236: (l_pactid,
237: p_tax_unit_id,
238: 'Original 1099-R on or before',

Line 298: hr_utility.trace('PROCEDURE print_er_rearch_data');

294:
295:
296: BEGIN
297:
298: hr_utility.trace('PROCEDURE print_er_rearch_data');
299: hr_utility.trace('p_federal_state = '||p_federal_state);
300: hr_utility.trace('p_old_value = '||p_old_value);
301: hr_utility.trace('p_new_value = '||p_new_value);
302:

Line 299: hr_utility.trace('p_federal_state = '||p_federal_state);

295:
296: BEGIN
297:
298: hr_utility.trace('PROCEDURE print_er_rearch_data');
299: hr_utility.trace('p_federal_state = '||p_federal_state);
300: hr_utility.trace('p_old_value = '||p_old_value);
301: hr_utility.trace('p_new_value = '||p_new_value);
302:
303: OPEN c_usr_entity_name;

Line 300: hr_utility.trace('p_old_value = '||p_old_value);

296: BEGIN
297:
298: hr_utility.trace('PROCEDURE print_er_rearch_data');
299: hr_utility.trace('p_federal_state = '||p_federal_state);
300: hr_utility.trace('p_old_value = '||p_old_value);
301: hr_utility.trace('p_new_value = '||p_new_value);
302:
303: OPEN c_usr_entity_name;
304: FETCH c_usr_entity_name INTO l_item_name;

Line 301: hr_utility.trace('p_new_value = '||p_new_value);

297:
298: hr_utility.trace('PROCEDURE print_er_rearch_data');
299: hr_utility.trace('p_federal_state = '||p_federal_state);
300: hr_utility.trace('p_old_value = '||p_old_value);
301: hr_utility.trace('p_new_value = '||p_new_value);
302:
303: OPEN c_usr_entity_name;
304: FETCH c_usr_entity_name INTO l_item_name;
305:

Line 309: hr_utility.trace('user_entity_name not found for user_entity_id = '

305:
306: IF c_usr_entity_name%NOTFOUND THEN
307:
308: l_item_name:= null;
309: hr_utility.trace('user_entity_name not found for user_entity_id = '
310: ||to_char(p_user_entity_id));
311:
312: END IF;
313:

Line 335: hr_utility.trace('l_item_name = '||l_item_name);

331:
332: END IF;
333:
334:
335: hr_utility.trace('l_item_name = '||l_item_name);
336: l_old_value := p_old_value;
337: l_new_value := p_new_value;
338:
339: IF l_item_name = 'W2 REPORTING RULES ORG COMPANY NAME' THEN

Line 349: hr_utility.trace('Gre Name not found for tax_unit_id '||p_old_value);

345:
346: IF c_gre_name%NOTFOUND THEN
347:
348: l_old_value := null;
349: hr_utility.trace('Gre Name not found for tax_unit_id '||p_old_value);
350:
351: END IF;
352:
353: CLOSE c_gre_name;

Line 365: hr_utility.trace('Gre Name not found for tax_unit_id '||p_new_value);

361:
362: IF c_gre_name%NOTFOUND THEN
363:
364: l_new_value := null;
365: hr_utility.trace('Gre Name not found for tax_unit_id '||p_new_value);
366:
367: END IF;
368:
369: CLOSE c_gre_name;

Line 383: hr_utility.trace('Person Name not found for person_id '||p_old_value);

379:
380: IF c_per_name%NOTFOUND THEN
381:
382: l_old_value := null;
383: hr_utility.trace('Person Name not found for person_id '||p_old_value);
384:
385: END IF;
386:
387: CLOSE c_per_name;

Line 399: hr_utility.trace('Person Name not found for person_id '||p_new_value);

395:
396: IF c_per_name%NOTFOUND THEN
397:
398: l_new_value := null;
399: hr_utility.trace('Person Name not found for person_id '||p_new_value);
400:
401: END IF;
402:
403: CLOSE c_per_name;

Line 414: hr_utility.trace('c_lookup_meaning = '||l_old_value);

410:
411: OPEN c_lookup_meaning('MMREF_PREPARER_CODE',p_old_value);
412: FETCH c_lookup_meaning INTO l_old_value;
413: CLOSE c_lookup_meaning;
414: hr_utility.trace('c_lookup_meaning = '||l_old_value);
415:
416: END IF;
417:
418: IF p_new_value IS NOT NULL THEN

Line 423: hr_utility.trace('c_lookup_meaning = '||l_new_value);

419:
420: OPEN c_lookup_meaning('MMREF_PREPARER_CODE',p_new_value);
421: FETCH c_lookup_meaning INTO l_new_value;
422: CLOSE c_lookup_meaning;
423: hr_utility.trace('c_lookup_meaning = '||l_new_value);
424:
425: END IF;
426:
427:

Line 435: hr_utility.trace('c_lookup_meaning = '||l_old_value);

431:
432: OPEN c_lookup_meaning('MMREF_PROBLEM_NOTIFICATON_MTHD',p_old_value);
433: FETCH c_lookup_meaning INTO l_old_value;
434: CLOSE c_lookup_meaning;
435: hr_utility.trace('c_lookup_meaning = '||l_old_value);
436:
437: END IF;
438:
439: IF p_new_value IS NOT NULL THEN

Line 444: hr_utility.trace('c_lookup_meaning = '||l_new_value);

440:
441: OPEN c_lookup_meaning('MMREF_PROBLEM_NOTIFICATON_MTHD',p_new_value);
442: FETCH c_lookup_meaning INTO l_new_value;
443: CLOSE c_lookup_meaning;
444: hr_utility.trace('c_lookup_meaning = '||l_new_value);
445:
446: END IF;
447:
448: ELSIF l_item_name ='W2 REPORTING RULES ORG TAX JURISDICTION' THEN

Line 455: hr_utility.trace('c_lookup_meaning = '||l_old_value);

451:
452: OPEN c_lookup_meaning('MMREF_TAX_JURISDICTION',p_old_value);
453: FETCH c_lookup_meaning INTO l_old_value;
454: CLOSE c_lookup_meaning;
455: hr_utility.trace('c_lookup_meaning = '||l_old_value);
456:
457: END IF;
458:
459: IF p_new_value IS NOT NULL THEN

Line 464: hr_utility.trace('c_lookup_meaning = '||l_new_value);

460:
461: OPEN c_lookup_meaning('MMREF_TAX_JURISDICTION',p_new_value);
462: FETCH c_lookup_meaning INTO l_new_value;
463: CLOSE c_lookup_meaning;
464: hr_utility.trace('c_lookup_meaning = '||l_new_value);
465:
466: END IF;
467:
468: ELSIF l_item_name = 'FEDERAL TAX RULES ORG TYPE OF EMPLOYMENT' THEN

Line 475: hr_utility.trace('c_lookup_meaning = '||l_old_value);

471:
472: OPEN c_lookup_meaning('US_EMPLOYMENT_TYPE',p_old_value);
473: FETCH c_lookup_meaning INTO l_old_value;
474: CLOSE c_lookup_meaning;
475: hr_utility.trace('c_lookup_meaning = '||l_old_value);
476:
477: END IF;
478:
479: IF p_new_value IS NOT NULL THEN

Line 484: hr_utility.trace('c_lookup_meaning = '||l_new_value);

480:
481: OPEN c_lookup_meaning('US_EMPLOYMENT_TYPE',p_new_value);
482: FETCH c_lookup_meaning INTO l_new_value;
483: CLOSE c_lookup_meaning;
484: hr_utility.trace('c_lookup_meaning = '||l_new_value);
485:
486: END IF;
487:
488: ELSIF l_item_name = 'FIPS CODE JD' THEN

Line 495: hr_utility.trace('l_new_value ='||l_new_value);

491: OPEN c_state_code(l_new_value);
492: FETCH c_state_code INTO l_new_value;
493: CLOSE c_state_code;
494:
495: hr_utility.trace('l_new_value ='||l_new_value);
496:
497:
498: END IF;
499: