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 112: hr_utility.trace('Get_City_Values');

108: l_city_name pay_us_city_names.city_name%TYPE;
109:
110: Begin
111:
112: hr_utility.trace('Get_City_Values');
113: hr_utility.trace('p_jurisdiction_code = '||p_jurisdiction_code);
114:
115: OPEN GET_CITY_NAME(p_jurisdiction_code);
116: hr_utility.trace('OPEN GET_CITY_NAME');

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

109:
110: Begin
111:
112: hr_utility.trace('Get_City_Values');
113: hr_utility.trace('p_jurisdiction_code = '||p_jurisdiction_code);
114:
115: OPEN GET_CITY_NAME(p_jurisdiction_code);
116: hr_utility.trace('OPEN GET_CITY_NAME');
117: FETCH GET_CITY_NAME INTO l_city_name;

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

112: hr_utility.trace('Get_City_Values');
113: hr_utility.trace('p_jurisdiction_code = '||p_jurisdiction_code);
114:
115: OPEN GET_CITY_NAME(p_jurisdiction_code);
116: hr_utility.trace('OPEN GET_CITY_NAME');
117: FETCH GET_CITY_NAME INTO l_city_name;
118: hr_utility.trace('FETCH GET_CITY_NAME '||l_city_name);
119:
120: IF GET_CITY_NAME%NOTFOUND THEN

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

114:
115: OPEN GET_CITY_NAME(p_jurisdiction_code);
116: hr_utility.trace('OPEN GET_CITY_NAME');
117: FETCH GET_CITY_NAME INTO l_city_name;
118: hr_utility.trace('FETCH GET_CITY_NAME '||l_city_name);
119:
120: IF GET_CITY_NAME%NOTFOUND THEN
121:
122: hr_utility.trace('No city found with this jurisdiction code = '||p_jurisdiction_code);

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

118: hr_utility.trace('FETCH GET_CITY_NAME '||l_city_name);
119:
120: IF GET_CITY_NAME%NOTFOUND THEN
121:
122: hr_utility.trace('No city found with this jurisdiction code = '||p_jurisdiction_code);
123: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
124: pay_core_utils.push_token('record_name','jurisdiction '||p_jurisdiction_code);
125: pay_core_utils.push_token('description','City not found in pay_us_city_names.');
126: l_city_name := ' ';

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

129:
130: CLOSE GET_CITY_NAME;
131:
132: OPEN GET_CITY_CODE(p_jurisdiction_code,p_effective_date);
133: hr_utility.trace('OPEN GET_CITY_CODE');
134: FETCH GET_CITY_CODE INTO l_city_value,l_city_id;
135: hr_utility.trace('FETCH GET_CITY_CODE '||l_city_id);
136:
137: IF GET_CITY_CODE%NOTFOUND THEN

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

131:
132: OPEN GET_CITY_CODE(p_jurisdiction_code,p_effective_date);
133: hr_utility.trace('OPEN GET_CITY_CODE');
134: FETCH GET_CITY_CODE INTO l_city_value,l_city_id;
135: hr_utility.trace('FETCH GET_CITY_CODE '||l_city_id);
136:
137: IF GET_CITY_CODE%NOTFOUND THEN
138:
139: hr_utility.trace('No city information found for jurisdiction code = '||p_jurisdiction_code);

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

135: hr_utility.trace('FETCH GET_CITY_CODE '||l_city_id);
136:
137: IF GET_CITY_CODE%NOTFOUND THEN
138:
139: hr_utility.trace('No city information found for jurisdiction code = '||p_jurisdiction_code);
140: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
141: pay_core_utils.push_token('record_name','jurisdiction '||p_jurisdiction_code
142: ||' in '||'pay_us_city_tax_info_f');
143: pay_core_utils.push_token('description','City tax infm not found.');

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

148: ELSIF GET_CITY_CODE%FOUND THEN
149:
150: sp_out_1 := l_city_value;
151: sp_out_2 := l_city_id;
152: hr_utility.trace('city information found');
153: hr_utility.trace('l_city_value = '||l_city_value);
154: hr_utility.trace('l_city_id = '||l_city_id);
155:
156: END IF;

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

149:
150: sp_out_1 := l_city_value;
151: sp_out_2 := l_city_id;
152: hr_utility.trace('city information found');
153: hr_utility.trace('l_city_value = '||l_city_value);
154: hr_utility.trace('l_city_id = '||l_city_id);
155:
156: END IF;
157:

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

150: sp_out_1 := l_city_value;
151: sp_out_2 := l_city_id;
152: hr_utility.trace('city information found');
153: hr_utility.trace('l_city_value = '||l_city_value);
154: hr_utility.trace('l_city_id = '||l_city_id);
155:
156: END IF;
157:
158: RETURN l_city_name;

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

190: lv_jd_ot_hrs number(10);
191:
192: Begin
193:
194: hr_utility.trace('Get_Hours_Worked');
195: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
196: hr_utility.trace('p_scl_asg_work_sch = '||p_scl_asg_work_sch);
197: hr_utility.trace('p_input_1 = '||p_input_1);
198:

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

191:
192: Begin
193:
194: hr_utility.trace('Get_Hours_Worked');
195: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
196: hr_utility.trace('p_scl_asg_work_sch = '||p_scl_asg_work_sch);
197: hr_utility.trace('p_input_1 = '||p_input_1);
198:
199: /* Bug:2873584 WA does not include Sick hours. */

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

192: Begin
193:
194: hr_utility.trace('Get_Hours_Worked');
195: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
196: hr_utility.trace('p_scl_asg_work_sch = '||p_scl_asg_work_sch);
197: hr_utility.trace('p_input_1 = '||p_input_1);
198:
199: /* Bug:2873584 WA does not include Sick hours. */
200: /* Bug :7458671 WA include sick hours for non-Qualified plans */

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

193:
194: hr_utility.trace('Get_Hours_Worked');
195: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
196: hr_utility.trace('p_scl_asg_work_sch = '||p_scl_asg_work_sch);
197: hr_utility.trace('p_input_1 = '||p_input_1);
198:
199: /* Bug:2873584 WA does not include Sick hours. */
200: /* Bug :7458671 WA include sick hours for non-Qualified plans */
201: /*IF p_report_qualifier = 'WA_SQWL' THEN

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

219:
220: l_hours_worked := nvl(to_number(sp_out_1),0) + nvl(to_number(sp_out_2),0)
221: + nvl(to_number(sp_out_3),0) + nvl(to_number(sp_out_4),0);
222:
223: hr_utility.trace('sp_out_1 = '||sp_out_1);
224: hr_utility.trace('sp_out_2 = '||sp_out_2);
225: hr_utility.trace('sp_out_3 = '||sp_out_3);
226: hr_utility.trace('sp_out_4 = '||sp_out_4);
227: ELSE

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

220: l_hours_worked := nvl(to_number(sp_out_1),0) + nvl(to_number(sp_out_2),0)
221: + nvl(to_number(sp_out_3),0) + nvl(to_number(sp_out_4),0);
222:
223: hr_utility.trace('sp_out_1 = '||sp_out_1);
224: hr_utility.trace('sp_out_2 = '||sp_out_2);
225: hr_utility.trace('sp_out_3 = '||sp_out_3);
226: hr_utility.trace('sp_out_4 = '||sp_out_4);
227: ELSE
228: l_hours_worked := p_regular_hours*p_sui_er_gross/p_gross_earnings;

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

221: + nvl(to_number(sp_out_3),0) + nvl(to_number(sp_out_4),0);
222:
223: hr_utility.trace('sp_out_1 = '||sp_out_1);
224: hr_utility.trace('sp_out_2 = '||sp_out_2);
225: hr_utility.trace('sp_out_3 = '||sp_out_3);
226: hr_utility.trace('sp_out_4 = '||sp_out_4);
227: ELSE
228: l_hours_worked := p_regular_hours*p_sui_er_gross/p_gross_earnings;
229: hr_utility.trace('p_regular_hours = '||to_char(p_regular_hours));

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

222:
223: hr_utility.trace('sp_out_1 = '||sp_out_1);
224: hr_utility.trace('sp_out_2 = '||sp_out_2);
225: hr_utility.trace('sp_out_3 = '||sp_out_3);
226: hr_utility.trace('sp_out_4 = '||sp_out_4);
227: ELSE
228: l_hours_worked := p_regular_hours*p_sui_er_gross/p_gross_earnings;
229: hr_utility.trace('p_regular_hours = '||to_char(p_regular_hours));
230: hr_utility.trace('p_sui_er_gross = '||to_char(p_sui_er_gross));

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

225: hr_utility.trace('sp_out_3 = '||sp_out_3);
226: hr_utility.trace('sp_out_4 = '||sp_out_4);
227: ELSE
228: l_hours_worked := p_regular_hours*p_sui_er_gross/p_gross_earnings;
229: hr_utility.trace('p_regular_hours = '||to_char(p_regular_hours));
230: hr_utility.trace('p_sui_er_gross = '||to_char(p_sui_er_gross));
231: hr_utility.trace('p_gross_earnings = '||to_char(p_gross_earnings));
232: hr_utility.trace('p_gross_earnings <>0. l_hours_worked = '||to_char(l_hours_worked));
233: END IF;

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

226: hr_utility.trace('sp_out_4 = '||sp_out_4);
227: ELSE
228: l_hours_worked := p_regular_hours*p_sui_er_gross/p_gross_earnings;
229: hr_utility.trace('p_regular_hours = '||to_char(p_regular_hours));
230: hr_utility.trace('p_sui_er_gross = '||to_char(p_sui_er_gross));
231: hr_utility.trace('p_gross_earnings = '||to_char(p_gross_earnings));
232: hr_utility.trace('p_gross_earnings <>0. l_hours_worked = '||to_char(l_hours_worked));
233: END IF;
234: END IF;

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

227: ELSE
228: l_hours_worked := p_regular_hours*p_sui_er_gross/p_gross_earnings;
229: hr_utility.trace('p_regular_hours = '||to_char(p_regular_hours));
230: hr_utility.trace('p_sui_er_gross = '||to_char(p_sui_er_gross));
231: hr_utility.trace('p_gross_earnings = '||to_char(p_gross_earnings));
232: hr_utility.trace('p_gross_earnings <>0. l_hours_worked = '||to_char(l_hours_worked));
233: END IF;
234: END IF;
235:

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

228: l_hours_worked := p_regular_hours*p_sui_er_gross/p_gross_earnings;
229: hr_utility.trace('p_regular_hours = '||to_char(p_regular_hours));
230: hr_utility.trace('p_sui_er_gross = '||to_char(p_sui_er_gross));
231: hr_utility.trace('p_gross_earnings = '||to_char(p_gross_earnings));
232: hr_utility.trace('p_gross_earnings <>0. l_hours_worked = '||to_char(l_hours_worked));
233: END IF;
234: END IF;
235:
236: IF l_hours_worked <0 THEN /* Negative Hour checking*/

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

242: (p_report_qualifier = 'NJ_SQWL') OR
243: (p_report_qualifier = 'PA_SQWL')) THEN
244:
245: sp_out_5 :='Y';
246: hr_utility.trace(' l_hours_worked is negative = '||to_char(l_hours_worked));
247:
248: END IF;
249:
250: END IF;

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

250: END IF;
251:
252: IF p_scl_asg_work_sch = '99999' THEN
253:
254: hr_utility.trace('p_scl_asg_work_sch = 99999 ');
255:
256: l_add_days := fffunc.add_days(sysdate,6);
257: l_hours_per_week := hr_us_ff_udfs.Standard_Hours_Worked(
258: p_asg_hours,

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

258: p_asg_hours,
259: sysdate,
260: l_add_days,
261: p_asg_freq);
262: hr_utility.trace('p_report_qualifier = NH.p_scl_asg_work_sch was defaulted');
263: hr_utility.trace('l_add_days = '||l_add_days);
264: hr_utility.trace('l_hours_per_week = '||to_char(l_hours_per_week));
265:
266: ELSE

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

259: sysdate,
260: l_add_days,
261: p_asg_freq);
262: hr_utility.trace('p_report_qualifier = NH.p_scl_asg_work_sch was defaulted');
263: hr_utility.trace('l_add_days = '||l_add_days);
264: hr_utility.trace('l_hours_per_week = '||to_char(l_hours_per_week));
265:
266: ELSE
267:

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

260: l_add_days,
261: p_asg_freq);
262: hr_utility.trace('p_report_qualifier = NH.p_scl_asg_work_sch was defaulted');
263: hr_utility.trace('l_add_days = '||l_add_days);
264: hr_utility.trace('l_hours_per_week = '||to_char(l_hours_per_week));
265:
266: ELSE
267:
268: l_hours_per_week := hr_us_ff_udfs.work_schedule_total_hours(to_number(p_input_1),

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

268: l_hours_per_week := hr_us_ff_udfs.work_schedule_total_hours(to_number(p_input_1),
269: p_scl_asg_work_sch,
270: null,
271: null);
272: hr_utility.trace('p_scl_asg_work_sch = '||p_scl_asg_work_sch);
273: hr_utility.trace('l_hours_per_week = '||to_char(l_hours_per_week));
274:
275:
276: END IF;

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

269: p_scl_asg_work_sch,
270: null,
271: null);
272: hr_utility.trace('p_scl_asg_work_sch = '||p_scl_asg_work_sch);
273: hr_utility.trace('l_hours_per_week = '||to_char(l_hours_per_week));
274:
275:
276: END IF;
277:

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

280: l_output_hours := '00';
281:
282: ELSE
283:
284: hr_utility.trace('l_hours_per_week <> 0 ');
285: hr_utility.trace('l_hours_worked = '||l_hours_worked);
286: l_output_hours := lpad(to_char(ceil(l_hours_worked/l_hours_per_week)),2,'0');
287: hr_utility.trace('l_output_hours = '||l_output_hours);
288:

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

281:
282: ELSE
283:
284: hr_utility.trace('l_hours_per_week <> 0 ');
285: hr_utility.trace('l_hours_worked = '||l_hours_worked);
286: l_output_hours := lpad(to_char(ceil(l_hours_worked/l_hours_per_week)),2,'0');
287: hr_utility.trace('l_output_hours = '||l_output_hours);
288:
289: IF p_report_qualifier = 'PA_SQWL' AND to_number(l_output_hours) > 14 THEN

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

283:
284: hr_utility.trace('l_hours_per_week <> 0 ');
285: hr_utility.trace('l_hours_worked = '||l_hours_worked);
286: l_output_hours := lpad(to_char(ceil(l_hours_worked/l_hours_per_week)),2,'0');
287: hr_utility.trace('l_output_hours = '||l_output_hours);
288:
289: IF p_report_qualifier = 'PA_SQWL' AND to_number(l_output_hours) > 14 THEN
290: l_output_hours := 14;
291: ELSIF to_number(l_output_hours) > 13 THEN /* BUG 12547987*/

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

296:
297:
298: IF p_report_type = 'SSA_SQWL' THEN
299:
300: hr_utility.trace('SSA_SQWL');
301:
302: IF p_report_qualifier = 'WY_SQWL' THEN
303:
304: hr_utility.trace('WY');

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

300: hr_utility.trace('SSA_SQWL');
301:
302: IF p_report_qualifier = 'WY_SQWL' THEN
303:
304: hr_utility.trace('WY');
305: l_output_hours := '00';
306: sp_out_1 := to_char(l_hours_worked);
307:
308: ELSIF p_report_qualifier = 'DE_SQWL' THEN

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

306: sp_out_1 := to_char(l_hours_worked);
307:
308: ELSIF p_report_qualifier = 'DE_SQWL' THEN
309:
310: hr_utility.trace('DE l_output_hours '||l_output_hours);
311: l_output_hours :=lpad(l_output_hours,2,'0');
312:
313: ELSIF p_report_qualifier = 'RI_SQWL' THEN /*bug 6613661*/
314:

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

311: l_output_hours :=lpad(l_output_hours,2,'0');
312:
313: ELSIF p_report_qualifier = 'RI_SQWL' THEN /*bug 6613661*/
314:
315: hr_utility.trace('RI l_output_hours '||l_output_hours);
316: l_output_hours :=lpad(l_output_hours,2,'0');
317: sp_out_1 := to_char(round(l_hours_worked));
318: ELSE
319:

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

379:
380: l_hours_worked := 999;
381:
382: END IF;
383: hr_utility.trace('l_hours_worked = '||l_hours_worked);
384:
385: END IF;
386:
387: hr_utility.trace('Report Qualifier = '||p_report_qualifier ||'and l_hours_worked = '||l_hours_worked);

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

383: hr_utility.trace('l_hours_worked = '||l_hours_worked);
384:
385: END IF;
386:
387: hr_utility.trace('Report Qualifier = '||p_report_qualifier ||'and l_hours_worked = '||l_hours_worked);
388: RETURN to_char(l_hours_worked); -- hours worked for MN and OR
389:
390: ELSE
391:

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

459:
460:
461: Begin
462:
463: hr_utility.trace('Get_Sqwl_Extra_Info');
464:
465: arch_table(1).p_user_name:='A_SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD';
466: arch_table(2).p_user_name:='A_SUI_ER_PRE_TAX_REDNS_PER_JD_GRE_QTD';
467:

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

472: FETCH GET_ENTITY_ID INTO l_entity_id;
473:
474: IF GET_ENTITY_ID%NOTFOUND THEN
475:
476: hr_utility.trace('User entity id not found for '||arch_table(i).p_user_name);
477:
478: END IF;
479:
480:

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

477:
478: END IF;
479:
480:
481: hr_utility.trace('l_entity_id = '||to_char(l_entity_id));
482:
483: OPEN GET_ARCHIVED_VALUE(p_payroll_action_id,
484: p_tax_unit_id,
485: l_entity_id);

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

486:
487: FETCH GET_ARCHIVED_VALUE INTO arch_table(i).p_archived_value, l_count;
488:
489:
490: hr_utility.trace('Value = '||arch_table(i).p_archived_value);
491: hr_utility.trace('Count = '||l_count);
492:
493: IF GET_ARCHIVED_VALUE%NOTFOUND THEN
494:

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

487: FETCH GET_ARCHIVED_VALUE INTO arch_table(i).p_archived_value, l_count;
488:
489:
490: hr_utility.trace('Value = '||arch_table(i).p_archived_value);
491: hr_utility.trace('Count = '||l_count);
492:
493: IF GET_ARCHIVED_VALUE%NOTFOUND THEN
494:
495: hr_utility.trace('Archived value not found for '||arch_table(i).p_user_name);

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

491: hr_utility.trace('Count = '||l_count);
492:
493: IF GET_ARCHIVED_VALUE%NOTFOUND THEN
494:
495: hr_utility.trace('Archived value not found for '||arch_table(i).p_user_name);
496:
497: END IF;
498:
499: CLOSE GET_ARCHIVED_VALUE;

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

503: END LOOP;
504:
505: l_output_value := to_char((to_number(arch_table(1).p_archived_value)-to_number(arch_table(2).p_archived_value))*100);
506:
507: hr_utility.trace('p_output_1 = '||p_output_1);
508: RETURN l_output_value;
509:
510: End;
511: