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 288: hr_utility.trace('PROCEDURE print_er_rearch_data');

284:
285:
286: BEGIN
287:
288: hr_utility.trace('PROCEDURE print_er_rearch_data');
289: hr_utility.trace('p_federal_state = '||p_federal_state);
290: hr_utility.trace('p_old_value = '||p_old_value);
291: hr_utility.trace('p_new_value = '||p_new_value);
292:

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

285:
286: BEGIN
287:
288: hr_utility.trace('PROCEDURE print_er_rearch_data');
289: hr_utility.trace('p_federal_state = '||p_federal_state);
290: hr_utility.trace('p_old_value = '||p_old_value);
291: hr_utility.trace('p_new_value = '||p_new_value);
292:
293: OPEN c_usr_entity_name;

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

286: BEGIN
287:
288: hr_utility.trace('PROCEDURE print_er_rearch_data');
289: hr_utility.trace('p_federal_state = '||p_federal_state);
290: hr_utility.trace('p_old_value = '||p_old_value);
291: hr_utility.trace('p_new_value = '||p_new_value);
292:
293: OPEN c_usr_entity_name;
294: FETCH c_usr_entity_name INTO l_item_name;

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

287:
288: hr_utility.trace('PROCEDURE print_er_rearch_data');
289: hr_utility.trace('p_federal_state = '||p_federal_state);
290: hr_utility.trace('p_old_value = '||p_old_value);
291: hr_utility.trace('p_new_value = '||p_new_value);
292:
293: OPEN c_usr_entity_name;
294: FETCH c_usr_entity_name INTO l_item_name;
295:

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

295:
296: IF c_usr_entity_name%NOTFOUND THEN
297:
298: l_item_name:= null;
299: hr_utility.trace('user_entity_name not found for user_entity_id = '
300: ||to_char(p_user_entity_id));
301:
302: END IF;
303:

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

321:
322: END IF;
323:
324:
325: hr_utility.trace('l_item_name = '||l_item_name);
326: l_old_value := p_old_value;
327: l_new_value := p_new_value;
328:
329: IF l_item_name = 'W2 REPORTING RULES ORG COMPANY NAME' THEN

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

335:
336: IF c_gre_name%NOTFOUND THEN
337:
338: l_old_value := null;
339: hr_utility.trace('Gre Name not found for tax_unit_id '||p_old_value);
340:
341: END IF;
342:
343: CLOSE c_gre_name;

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

351:
352: IF c_gre_name%NOTFOUND THEN
353:
354: l_new_value := null;
355: hr_utility.trace('Gre Name not found for tax_unit_id '||p_new_value);
356:
357: END IF;
358:
359: CLOSE c_gre_name;

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

369:
370: IF c_per_name%NOTFOUND THEN
371:
372: l_old_value := null;
373: hr_utility.trace('Person Name not found for person_id '||p_old_value);
374:
375: END IF;
376:
377: CLOSE c_per_name;

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

385:
386: IF c_per_name%NOTFOUND THEN
387:
388: l_new_value := null;
389: hr_utility.trace('Person Name not found for person_id '||p_new_value);
390:
391: END IF;
392:
393: CLOSE c_per_name;

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

400:
401: OPEN c_lookup_meaning('MMREF_PREPARER_CODE',p_old_value);
402: FETCH c_lookup_meaning INTO l_old_value;
403: CLOSE c_lookup_meaning;
404: hr_utility.trace('c_lookup_meaning = '||l_old_value);
405:
406: END IF;
407:
408: IF p_new_value IS NOT NULL THEN

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

409:
410: OPEN c_lookup_meaning('MMREF_PREPARER_CODE',p_new_value);
411: FETCH c_lookup_meaning INTO l_new_value;
412: CLOSE c_lookup_meaning;
413: hr_utility.trace('c_lookup_meaning = '||l_new_value);
414:
415: END IF;
416:
417:

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

421:
422: OPEN c_lookup_meaning('MMREF_PROBLEM_NOTIFICATON_MTHD',p_old_value);
423: FETCH c_lookup_meaning INTO l_old_value;
424: CLOSE c_lookup_meaning;
425: hr_utility.trace('c_lookup_meaning = '||l_old_value);
426:
427: END IF;
428:
429: IF p_new_value IS NOT NULL THEN

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

430:
431: OPEN c_lookup_meaning('MMREF_PROBLEM_NOTIFICATON_MTHD',p_new_value);
432: FETCH c_lookup_meaning INTO l_new_value;
433: CLOSE c_lookup_meaning;
434: hr_utility.trace('c_lookup_meaning = '||l_new_value);
435:
436: END IF;
437:
438: ELSIF l_item_name ='W2 REPORTING RULES ORG TAX JURISDICTION' THEN

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

441:
442: OPEN c_lookup_meaning('MMREF_TAX_JURISDICTION',p_old_value);
443: FETCH c_lookup_meaning INTO l_old_value;
444: CLOSE c_lookup_meaning;
445: hr_utility.trace('c_lookup_meaning = '||l_old_value);
446:
447: END IF;
448:
449: IF p_new_value IS NOT NULL THEN

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

450:
451: OPEN c_lookup_meaning('MMREF_TAX_JURISDICTION',p_new_value);
452: FETCH c_lookup_meaning INTO l_new_value;
453: CLOSE c_lookup_meaning;
454: hr_utility.trace('c_lookup_meaning = '||l_new_value);
455:
456: END IF;
457:
458: ELSIF l_item_name = 'FEDERAL TAX RULES ORG TYPE OF EMPLOYMENT' THEN

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

461:
462: OPEN c_lookup_meaning('US_EMPLOYMENT_TYPE',p_old_value);
463: FETCH c_lookup_meaning INTO l_old_value;
464: CLOSE c_lookup_meaning;
465: hr_utility.trace('c_lookup_meaning = '||l_old_value);
466:
467: END IF;
468:
469: IF p_new_value IS NOT NULL THEN

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

470:
471: OPEN c_lookup_meaning('US_EMPLOYMENT_TYPE',p_new_value);
472: FETCH c_lookup_meaning INTO l_new_value;
473: CLOSE c_lookup_meaning;
474: hr_utility.trace('c_lookup_meaning = '||l_new_value);
475:
476: END IF;
477:
478: ELSIF l_item_name = 'FIPS CODE JD' THEN

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

481: OPEN c_state_code(l_new_value);
482: FETCH c_state_code INTO l_new_value;
483: CLOSE c_state_code;
484:
485: hr_utility.trace('l_new_value ='||l_new_value);
486:
487:
488: END IF;
489: