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

Line 104: hr_utility.trace('Get_City_Values');

100: l_city_name pay_us_city_names.city_name%TYPE;
101:
102: Begin
103:
104: hr_utility.trace('Get_City_Values');
105: hr_utility.trace('p_jurisdiction_code = '||p_jurisdiction_code);
106:
107: OPEN GET_CITY_NAME(p_jurisdiction_code);
108: hr_utility.trace('OPEN GET_CITY_NAME');

Line 105: hr_utility.trace('p_jurisdiction_code = '||p_jurisdiction_code);

101:
102: Begin
103:
104: hr_utility.trace('Get_City_Values');
105: hr_utility.trace('p_jurisdiction_code = '||p_jurisdiction_code);
106:
107: OPEN GET_CITY_NAME(p_jurisdiction_code);
108: hr_utility.trace('OPEN GET_CITY_NAME');
109: FETCH GET_CITY_NAME INTO l_city_name;

Line 108: hr_utility.trace('OPEN GET_CITY_NAME');

104: hr_utility.trace('Get_City_Values');
105: hr_utility.trace('p_jurisdiction_code = '||p_jurisdiction_code);
106:
107: OPEN GET_CITY_NAME(p_jurisdiction_code);
108: hr_utility.trace('OPEN GET_CITY_NAME');
109: FETCH GET_CITY_NAME INTO l_city_name;
110: hr_utility.trace('FETCH GET_CITY_NAME '||l_city_name);
111:
112: IF GET_CITY_NAME%NOTFOUND THEN

Line 110: hr_utility.trace('FETCH GET_CITY_NAME '||l_city_name);

106:
107: OPEN GET_CITY_NAME(p_jurisdiction_code);
108: hr_utility.trace('OPEN GET_CITY_NAME');
109: FETCH GET_CITY_NAME INTO l_city_name;
110: hr_utility.trace('FETCH GET_CITY_NAME '||l_city_name);
111:
112: IF GET_CITY_NAME%NOTFOUND THEN
113:
114: hr_utility.trace('No city found with this jurisdiction code = '||p_jurisdiction_code);

Line 114: hr_utility.trace('No city found with this jurisdiction code = '||p_jurisdiction_code);

110: hr_utility.trace('FETCH GET_CITY_NAME '||l_city_name);
111:
112: IF GET_CITY_NAME%NOTFOUND THEN
113:
114: hr_utility.trace('No city found with this jurisdiction code = '||p_jurisdiction_code);
115: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
116: pay_core_utils.push_token('record_name','jurisdiction '||p_jurisdiction_code);
117: pay_core_utils.push_token('description','City not found in pay_us_city_names.');
118: l_city_name := ' ';

Line 125: hr_utility.trace('OPEN GET_CITY_CODE');

121:
122: CLOSE GET_CITY_NAME;
123:
124: OPEN GET_CITY_CODE(p_jurisdiction_code,p_effective_date);
125: hr_utility.trace('OPEN GET_CITY_CODE');
126: FETCH GET_CITY_CODE INTO l_city_value,l_city_id;
127: hr_utility.trace('FETCH GET_CITY_CODE '||l_city_id);
128:
129: IF GET_CITY_CODE%NOTFOUND THEN

Line 127: hr_utility.trace('FETCH GET_CITY_CODE '||l_city_id);

123:
124: OPEN GET_CITY_CODE(p_jurisdiction_code,p_effective_date);
125: hr_utility.trace('OPEN GET_CITY_CODE');
126: FETCH GET_CITY_CODE INTO l_city_value,l_city_id;
127: hr_utility.trace('FETCH GET_CITY_CODE '||l_city_id);
128:
129: IF GET_CITY_CODE%NOTFOUND THEN
130:
131: hr_utility.trace('No city information found for jurisdiction code = '||p_jurisdiction_code);

Line 131: hr_utility.trace('No city information found for jurisdiction code = '||p_jurisdiction_code);

127: hr_utility.trace('FETCH GET_CITY_CODE '||l_city_id);
128:
129: IF GET_CITY_CODE%NOTFOUND THEN
130:
131: hr_utility.trace('No city information found for jurisdiction code = '||p_jurisdiction_code);
132: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
133: pay_core_utils.push_token('record_name','jurisdiction '||p_jurisdiction_code
134: ||' in '||'pay_us_city_tax_info_f');
135: pay_core_utils.push_token('description','City tax infm not found.');

Line 144: hr_utility.trace('city information found');

140: ELSIF GET_CITY_CODE%FOUND THEN
141:
142: sp_out_1 := l_city_value;
143: sp_out_2 := l_city_id;
144: hr_utility.trace('city information found');
145: hr_utility.trace('l_city_value = '||l_city_value);
146: hr_utility.trace('l_city_id = '||l_city_id);
147:
148: END IF;

Line 145: hr_utility.trace('l_city_value = '||l_city_value);

141:
142: sp_out_1 := l_city_value;
143: sp_out_2 := l_city_id;
144: hr_utility.trace('city information found');
145: hr_utility.trace('l_city_value = '||l_city_value);
146: hr_utility.trace('l_city_id = '||l_city_id);
147:
148: END IF;
149:

Line 146: hr_utility.trace('l_city_id = '||l_city_id);

142: sp_out_1 := l_city_value;
143: sp_out_2 := l_city_id;
144: hr_utility.trace('city information found');
145: hr_utility.trace('l_city_value = '||l_city_value);
146: hr_utility.trace('l_city_id = '||l_city_id);
147:
148: END IF;
149:
150: RETURN l_city_name;

Line 186: hr_utility.trace('Get_Hours_Worked');

182: lv_jd_ot_hrs number(10);
183:
184: Begin
185:
186: hr_utility.trace('Get_Hours_Worked');
187: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
188: hr_utility.trace('p_scl_asg_work_sch = '||p_scl_asg_work_sch);
189: hr_utility.trace('p_input_1 = '||p_input_1);
190:

Line 187: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);

183:
184: Begin
185:
186: hr_utility.trace('Get_Hours_Worked');
187: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
188: hr_utility.trace('p_scl_asg_work_sch = '||p_scl_asg_work_sch);
189: hr_utility.trace('p_input_1 = '||p_input_1);
190:
191: /* Bug:2873584 WA does not include Sick hours. */

Line 188: hr_utility.trace('p_scl_asg_work_sch = '||p_scl_asg_work_sch);

184: Begin
185:
186: hr_utility.trace('Get_Hours_Worked');
187: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
188: hr_utility.trace('p_scl_asg_work_sch = '||p_scl_asg_work_sch);
189: hr_utility.trace('p_input_1 = '||p_input_1);
190:
191: /* Bug:2873584 WA does not include Sick hours. */
192:

Line 189: hr_utility.trace('p_input_1 = '||p_input_1);

185:
186: hr_utility.trace('Get_Hours_Worked');
187: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
188: hr_utility.trace('p_scl_asg_work_sch = '||p_scl_asg_work_sch);
189: hr_utility.trace('p_input_1 = '||p_input_1);
190:
191: /* Bug:2873584 WA does not include Sick hours. */
192:
193: IF p_report_qualifier = 'WA_SQWL' THEN

Line 215: hr_utility.trace('sp_out_1 = '||sp_out_1);

211:
212: l_hours_worked := nvl(to_number(sp_out_1),0) + nvl(to_number(sp_out_2),0)
213: + nvl(to_number(sp_out_3),0) + nvl(to_number(sp_out_4),0);
214:
215: hr_utility.trace('sp_out_1 = '||sp_out_1);
216: hr_utility.trace('sp_out_2 = '||sp_out_2);
217: hr_utility.trace('sp_out_3 = '||sp_out_3);
218: hr_utility.trace('sp_out_4 = '||sp_out_4);
219: ELSE

Line 216: hr_utility.trace('sp_out_2 = '||sp_out_2);

212: l_hours_worked := nvl(to_number(sp_out_1),0) + nvl(to_number(sp_out_2),0)
213: + nvl(to_number(sp_out_3),0) + nvl(to_number(sp_out_4),0);
214:
215: hr_utility.trace('sp_out_1 = '||sp_out_1);
216: hr_utility.trace('sp_out_2 = '||sp_out_2);
217: hr_utility.trace('sp_out_3 = '||sp_out_3);
218: hr_utility.trace('sp_out_4 = '||sp_out_4);
219: ELSE
220: l_hours_worked := p_regular_hours*p_sui_er_gross/p_gross_earnings;

Line 217: hr_utility.trace('sp_out_3 = '||sp_out_3);

213: + nvl(to_number(sp_out_3),0) + nvl(to_number(sp_out_4),0);
214:
215: hr_utility.trace('sp_out_1 = '||sp_out_1);
216: hr_utility.trace('sp_out_2 = '||sp_out_2);
217: hr_utility.trace('sp_out_3 = '||sp_out_3);
218: hr_utility.trace('sp_out_4 = '||sp_out_4);
219: ELSE
220: l_hours_worked := p_regular_hours*p_sui_er_gross/p_gross_earnings;
221: hr_utility.trace('p_regular_hours = '||to_char(p_regular_hours));

Line 218: hr_utility.trace('sp_out_4 = '||sp_out_4);

214:
215: hr_utility.trace('sp_out_1 = '||sp_out_1);
216: hr_utility.trace('sp_out_2 = '||sp_out_2);
217: hr_utility.trace('sp_out_3 = '||sp_out_3);
218: hr_utility.trace('sp_out_4 = '||sp_out_4);
219: ELSE
220: l_hours_worked := p_regular_hours*p_sui_er_gross/p_gross_earnings;
221: hr_utility.trace('p_regular_hours = '||to_char(p_regular_hours));
222: hr_utility.trace('p_sui_er_gross = '||to_char(p_sui_er_gross));

Line 221: hr_utility.trace('p_regular_hours = '||to_char(p_regular_hours));

217: hr_utility.trace('sp_out_3 = '||sp_out_3);
218: hr_utility.trace('sp_out_4 = '||sp_out_4);
219: ELSE
220: l_hours_worked := p_regular_hours*p_sui_er_gross/p_gross_earnings;
221: hr_utility.trace('p_regular_hours = '||to_char(p_regular_hours));
222: hr_utility.trace('p_sui_er_gross = '||to_char(p_sui_er_gross));
223: hr_utility.trace('p_gross_earnings = '||to_char(p_gross_earnings));
224: hr_utility.trace('p_gross_earnings <>0. l_hours_worked = '||to_char(l_hours_worked));
225: END IF;

Line 222: hr_utility.trace('p_sui_er_gross = '||to_char(p_sui_er_gross));

218: hr_utility.trace('sp_out_4 = '||sp_out_4);
219: ELSE
220: l_hours_worked := p_regular_hours*p_sui_er_gross/p_gross_earnings;
221: hr_utility.trace('p_regular_hours = '||to_char(p_regular_hours));
222: hr_utility.trace('p_sui_er_gross = '||to_char(p_sui_er_gross));
223: hr_utility.trace('p_gross_earnings = '||to_char(p_gross_earnings));
224: hr_utility.trace('p_gross_earnings <>0. l_hours_worked = '||to_char(l_hours_worked));
225: END IF;
226: END IF;

Line 223: hr_utility.trace('p_gross_earnings = '||to_char(p_gross_earnings));

219: ELSE
220: l_hours_worked := p_regular_hours*p_sui_er_gross/p_gross_earnings;
221: hr_utility.trace('p_regular_hours = '||to_char(p_regular_hours));
222: hr_utility.trace('p_sui_er_gross = '||to_char(p_sui_er_gross));
223: hr_utility.trace('p_gross_earnings = '||to_char(p_gross_earnings));
224: hr_utility.trace('p_gross_earnings <>0. l_hours_worked = '||to_char(l_hours_worked));
225: END IF;
226: END IF;
227:

Line 224: hr_utility.trace('p_gross_earnings <>0. l_hours_worked = '||to_char(l_hours_worked));

220: l_hours_worked := p_regular_hours*p_sui_er_gross/p_gross_earnings;
221: hr_utility.trace('p_regular_hours = '||to_char(p_regular_hours));
222: hr_utility.trace('p_sui_er_gross = '||to_char(p_sui_er_gross));
223: hr_utility.trace('p_gross_earnings = '||to_char(p_gross_earnings));
224: hr_utility.trace('p_gross_earnings <>0. l_hours_worked = '||to_char(l_hours_worked));
225: END IF;
226: END IF;
227:
228: IF l_hours_worked <0 THEN /* Negative Hour checking*/

Line 238: hr_utility.trace(' l_hours_worked is negative = '||to_char(l_hours_worked));

234: (p_report_qualifier = 'NJ_SQWL') OR
235: (p_report_qualifier = 'PA_SQWL')) THEN
236:
237: sp_out_5 :='Y';
238: hr_utility.trace(' l_hours_worked is negative = '||to_char(l_hours_worked));
239:
240: END IF;
241:
242: END IF;

Line 246: hr_utility.trace('p_scl_asg_work_sch = 99999 ');

242: END IF;
243:
244: IF p_scl_asg_work_sch = '99999' THEN
245:
246: hr_utility.trace('p_scl_asg_work_sch = 99999 ');
247:
248: l_add_days := fffunc.add_days(sysdate,6);
249: l_hours_per_week := hr_us_ff_udfs.Standard_Hours_Worked(
250: p_asg_hours,

Line 254: hr_utility.trace('p_report_qualifier = NH.p_scl_asg_work_sch was defaulted');

250: p_asg_hours,
251: sysdate,
252: l_add_days,
253: p_asg_freq);
254: hr_utility.trace('p_report_qualifier = NH.p_scl_asg_work_sch was defaulted');
255: hr_utility.trace('l_add_days = '||l_add_days);
256: hr_utility.trace('l_hours_per_week = '||to_char(l_hours_per_week));
257:
258: ELSE

Line 255: hr_utility.trace('l_add_days = '||l_add_days);

251: sysdate,
252: l_add_days,
253: p_asg_freq);
254: hr_utility.trace('p_report_qualifier = NH.p_scl_asg_work_sch was defaulted');
255: hr_utility.trace('l_add_days = '||l_add_days);
256: hr_utility.trace('l_hours_per_week = '||to_char(l_hours_per_week));
257:
258: ELSE
259:

Line 256: hr_utility.trace('l_hours_per_week = '||to_char(l_hours_per_week));

252: l_add_days,
253: p_asg_freq);
254: hr_utility.trace('p_report_qualifier = NH.p_scl_asg_work_sch was defaulted');
255: hr_utility.trace('l_add_days = '||l_add_days);
256: hr_utility.trace('l_hours_per_week = '||to_char(l_hours_per_week));
257:
258: ELSE
259:
260: l_hours_per_week := hr_us_ff_udfs.work_schedule_total_hours(to_number(p_input_1),

Line 264: hr_utility.trace('p_scl_asg_work_sch = '||p_scl_asg_work_sch);

260: l_hours_per_week := hr_us_ff_udfs.work_schedule_total_hours(to_number(p_input_1),
261: p_scl_asg_work_sch,
262: null,
263: null);
264: hr_utility.trace('p_scl_asg_work_sch = '||p_scl_asg_work_sch);
265: hr_utility.trace('l_hours_per_week = '||to_char(l_hours_per_week));
266:
267:
268: END IF;

Line 265: hr_utility.trace('l_hours_per_week = '||to_char(l_hours_per_week));

261: p_scl_asg_work_sch,
262: null,
263: null);
264: hr_utility.trace('p_scl_asg_work_sch = '||p_scl_asg_work_sch);
265: hr_utility.trace('l_hours_per_week = '||to_char(l_hours_per_week));
266:
267:
268: END IF;
269:

Line 276: hr_utility.trace('l_hours_per_week <> 0 ');

272: l_output_hours := '00';
273:
274: ELSE
275:
276: hr_utility.trace('l_hours_per_week <> 0 ');
277: hr_utility.trace('l_hours_worked = '||l_hours_worked);
278: l_output_hours := lpad(to_char(ceil(l_hours_worked/l_hours_per_week)),2,'0');
279: hr_utility.trace('l_output_hours = '||l_output_hours);
280:

Line 277: hr_utility.trace('l_hours_worked = '||l_hours_worked);

273:
274: ELSE
275:
276: hr_utility.trace('l_hours_per_week <> 0 ');
277: hr_utility.trace('l_hours_worked = '||l_hours_worked);
278: l_output_hours := lpad(to_char(ceil(l_hours_worked/l_hours_per_week)),2,'0');
279: hr_utility.trace('l_output_hours = '||l_output_hours);
280:
281: IF to_number(l_output_hours) > 14 THEN

Line 279: hr_utility.trace('l_output_hours = '||l_output_hours);

275:
276: hr_utility.trace('l_hours_per_week <> 0 ');
277: hr_utility.trace('l_hours_worked = '||l_hours_worked);
278: l_output_hours := lpad(to_char(ceil(l_hours_worked/l_hours_per_week)),2,'0');
279: hr_utility.trace('l_output_hours = '||l_output_hours);
280:
281: IF to_number(l_output_hours) > 14 THEN
282:
283: l_output_hours := 14;

Line 292: hr_utility.trace('SSA_SQWL');

288:
289:
290: IF p_report_type = 'SSA_SQWL' THEN
291:
292: hr_utility.trace('SSA_SQWL');
293:
294: IF p_report_qualifier = 'WY_SQWL' THEN
295:
296: hr_utility.trace('WY');

Line 296: hr_utility.trace('WY');

292: hr_utility.trace('SSA_SQWL');
293:
294: IF p_report_qualifier = 'WY_SQWL' THEN
295:
296: hr_utility.trace('WY');
297: l_output_hours := '00';
298: sp_out_1 := to_char(l_hours_worked);
299:
300: ELSIF p_report_qualifier = 'DE_SQWL' THEN

Line 302: hr_utility.trace('DE l_output_hours '||l_output_hours);

298: sp_out_1 := to_char(l_hours_worked);
299:
300: ELSIF p_report_qualifier = 'DE_SQWL' THEN
301:
302: hr_utility.trace('DE l_output_hours '||l_output_hours);
303: l_output_hours :=lpad(l_output_hours,2,'0');
304:
305: ELSIF p_report_qualifier = 'RI_SQWL' THEN /*bug 6613661*/
306:

Line 307: hr_utility.trace('RI l_output_hours '||l_output_hours);

303: l_output_hours :=lpad(l_output_hours,2,'0');
304:
305: ELSIF p_report_qualifier = 'RI_SQWL' THEN /*bug 6613661*/
306:
307: hr_utility.trace('RI l_output_hours '||l_output_hours);
308: l_output_hours :=lpad(l_output_hours,2,'0');
309: sp_out_1 := to_char(round(l_hours_worked));
310: ELSE
311:

Line 371: hr_utility.trace('l_hours_worked = '||l_hours_worked);

367:
368: l_hours_worked := 999;
369:
370: END IF;
371: hr_utility.trace('l_hours_worked = '||l_hours_worked);
372:
373: END IF;
374:
375: hr_utility.trace('Report Qualifier = '||p_report_qualifier ||'and l_hours_worked = '||l_hours_worked);

Line 375: hr_utility.trace('Report Qualifier = '||p_report_qualifier ||'and l_hours_worked = '||l_hours_worked);

371: hr_utility.trace('l_hours_worked = '||l_hours_worked);
372:
373: END IF;
374:
375: hr_utility.trace('Report Qualifier = '||p_report_qualifier ||'and l_hours_worked = '||l_hours_worked);
376: RETURN to_char(l_hours_worked); -- hours worked for MN and OR
377:
378: ELSE
379:

Line 451: hr_utility.trace('Get_Sqwl_Extra_Info');

447:
448:
449: Begin
450:
451: hr_utility.trace('Get_Sqwl_Extra_Info');
452:
453: arch_table(1).p_user_name:='A_SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD';
454: arch_table(2).p_user_name:='A_SUI_ER_PRE_TAX_REDNS_PER_JD_GRE_QTD';
455:

Line 464: hr_utility.trace('User entity id not found for '||arch_table(i).p_user_name);

460: FETCH GET_ENTITY_ID INTO l_entity_id;
461:
462: IF GET_ENTITY_ID%NOTFOUND THEN
463:
464: hr_utility.trace('User entity id not found for '||arch_table(i).p_user_name);
465:
466: END IF;
467:
468:

Line 469: hr_utility.trace('l_entity_id = '||to_char(l_entity_id));

465:
466: END IF;
467:
468:
469: hr_utility.trace('l_entity_id = '||to_char(l_entity_id));
470:
471: OPEN GET_ARCHIVED_VALUE(p_payroll_action_id,
472: p_tax_unit_id,
473: l_entity_id);

Line 478: hr_utility.trace('Value = '||arch_table(i).p_archived_value);

474:
475: FETCH GET_ARCHIVED_VALUE INTO arch_table(i).p_archived_value, l_count;
476:
477:
478: hr_utility.trace('Value = '||arch_table(i).p_archived_value);
479: hr_utility.trace('Count = '||l_count);
480:
481: IF GET_ARCHIVED_VALUE%NOTFOUND THEN
482:

Line 479: hr_utility.trace('Count = '||l_count);

475: FETCH GET_ARCHIVED_VALUE INTO arch_table(i).p_archived_value, l_count;
476:
477:
478: hr_utility.trace('Value = '||arch_table(i).p_archived_value);
479: hr_utility.trace('Count = '||l_count);
480:
481: IF GET_ARCHIVED_VALUE%NOTFOUND THEN
482:
483: hr_utility.trace('Archived value not found for '||arch_table(i).p_user_name);

Line 483: hr_utility.trace('Archived value not found for '||arch_table(i).p_user_name);

479: hr_utility.trace('Count = '||l_count);
480:
481: IF GET_ARCHIVED_VALUE%NOTFOUND THEN
482:
483: hr_utility.trace('Archived value not found for '||arch_table(i).p_user_name);
484:
485: END IF;
486:
487: CLOSE GET_ARCHIVED_VALUE;

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

491: END LOOP;
492:
493: l_output_value := to_char((to_number(arch_table(1).p_archived_value)-to_number(arch_table(2).p_archived_value))*100);
494:
495: hr_utility.trace('p_output_1 = '||p_output_1);
496: RETURN l_output_value;
497:
498: End;
499: