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

Line 61: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.employee_earnings ');

57: FUNCTION employee_earnings( p_assignment_action_id in NUMBER )
58: RETURN LONG IS
59: BEGIN
60:
61: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.employee_earnings ');
62: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
63:
64: pay_soe_util.clear;
65:

Line 62: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);

58: RETURN LONG IS
59: BEGIN
60:
61: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.employee_earnings ');
62: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
63:
64: pay_soe_util.clear;
65:
66: lv_sql := 'select earn_bal_name COL01

Line 76: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.employee_earnings ');

72: from PAY_MX_EMPLOYEE_EARNINGS_V
73: where assignment_action_id :action_clause
74: and earn_run_val <> 0';
75:
76: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.employee_earnings ');
77:
78: return lv_sql;
79:
80: END employee_earnings;

Line 86: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.employee_taxes ');

82: FUNCTION employee_taxes( p_assignment_action_id in NUMBER )
83: RETURN LONG IS
84: BEGIN
85:
86: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.employee_taxes ');
87: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
88:
89: pay_soe_util.clear;
90:

Line 87: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);

83: RETURN LONG IS
84: BEGIN
85:
86: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.employee_taxes ');
87: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
88:
89: pay_soe_util.clear;
90:
91: lv_sql := 'select balance_name COL01

Line 99: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.employee_taxes ');

95: from PAY_MX_EMPLOYEE_TAXES_V
96: where assignment_action_id :action_clause
97: and run_val <> 0';
98:
99: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.employee_taxes ');
100:
101: return lv_sql;
102:
103: END employee_taxes;

Line 109: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.tax_calc_details ');

105: FUNCTION tax_calc_details( p_assignment_action_id in NUMBER )
106: RETURN LONG IS
107: BEGIN
108:
109: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.tax_calc_details ');
110: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
111:
112: pay_soe_util.clear;
113:

Line 110: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);

106: RETURN LONG IS
107: BEGIN
108:
109: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.tax_calc_details ');
110: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
111:
112: pay_soe_util.clear;
113:
114: lv_sql := 'select balance_name COL01

Line 122: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');

118: from PAY_MX_TAX_CALC_DETAILS_V
119: where assignment_action_id :action_clause
120: and run_val <> 0';
121:
122: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
123:
124: return lv_sql;
125:
126: END tax_calc_details;

Line 155: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.mx_summary_balances ');

151:
152: summary summary_bal;
153:
154: BEGIN
155: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.mx_summary_balances ');
156: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
157: hr_utility.trace('lv_currency_code '||lv_currency_code);
158:
159: open c_tax_unit(p_assignment_action_id);

Line 156: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);

152: summary summary_bal;
153:
154: BEGIN
155: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.mx_summary_balances ');
156: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
157: hr_utility.trace('lv_currency_code '||lv_currency_code);
158:
159: open c_tax_unit(p_assignment_action_id);
160: fetch c_tax_unit into ln_tax_unit_id,ln_pyrl_act_id;

Line 157: hr_utility.trace('lv_currency_code '||lv_currency_code);

153:
154: BEGIN
155: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.mx_summary_balances ');
156: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
157: hr_utility.trace('lv_currency_code '||lv_currency_code);
158:
159: open c_tax_unit(p_assignment_action_id);
160: fetch c_tax_unit into ln_tax_unit_id,ln_pyrl_act_id;
161: close c_tax_unit;

Line 201: hr_utility.trace('i = '||i);

197: pay_soe_util.clear;
198:
199: for i in summary.first..summary.last loop
200:
201: hr_utility.trace('i = '||i);
202: hr_utility.trace('Balance = '||summary(i).bal_name);
203:
204: summary(i).curr_def_bal_id :=
205: pay_ac_utility.get_defined_balance_id

Line 202: hr_utility.trace('Balance = '||summary(i).bal_name);

198:
199: for i in summary.first..summary.last loop
200:
201: hr_utility.trace('i = '||i);
202: hr_utility.trace('Balance = '||summary(i).bal_name);
203:
204: summary(i).curr_def_bal_id :=
205: pay_ac_utility.get_defined_balance_id
206: (p_balance_name => summary(i).bal_name

Line 225: hr_utility.trace(' summary(i).curr_val '|| summary(i).curr_val);

221: -- pay_balance_pkg.get_value(summary(i).ytd_def_bal_id
222: -- ,p_assignment_action_id);
223: --
224: --
225: hr_utility.trace(' summary(i).curr_val '|| summary(i).curr_val);
226: pay_soe_util.setValue('01' ,summary(i).bal_name ,TRUE, FALSE);
227: pay_soe_util.setValue('02' ,summary(i).reporting_name ,FALSE, FALSE);
228: pay_soe_util.setValue('16' ,summary(i).curr_val, FALSE, FALSE );
229: pay_soe_util.setValue('17' ,summary(i).ytd_val, FALSE, TRUE );

Line 233: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.mx_summary_balances ');

229: pay_soe_util.setValue('17' ,summary(i).ytd_val, FALSE, TRUE );
230: --
231: end loop;
232:
233: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.mx_summary_balances ');
234:
235: return pay_soe_util.genCursor;
236:
237: END summary_balances;

Line 243: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.hourly_earnings ');

239: FUNCTION hourly_earnings( p_assignment_action_id in NUMBER )
240: RETURN LONG IS
241: BEGIN
242:
243: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.hourly_earnings ');
244: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
245:
246: pay_soe_util.clear;
247:

Line 244: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);

240: RETURN LONG IS
241: BEGIN
242:
243: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.hourly_earnings ');
244: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
245:
246: pay_soe_util.clear;
247:
248: lv_sql := 'select earn_bal_name COL01

Line 258: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.employee_earnings ');

254: from PAY_MX_HOURLY_EARNINGS_V
255: where assignment_action_id :action_clause
256: and earn_run_val <> 0';
257:
258: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.employee_earnings ');
259:
260: return lv_sql;
261:
262: END hourly_earnings;

Line 268: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.taxable_benefits ');

264: FUNCTION taxable_benefits( p_assignment_action_id in NUMBER )
265: RETURN LONG IS
266: BEGIN
267:
268: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.taxable_benefits ');
269: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
270:
271: pay_soe_util.clear;
272:

Line 269: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);

265: RETURN LONG IS
266: BEGIN
267:
268: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.taxable_benefits ');
269: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
270:
271: pay_soe_util.clear;
272:
273: lv_sql := 'select balance_name COL01

Line 281: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');

277: from PAY_MX_TAXABLE_BENEFITS_V
278: where assignment_action_id :action_clause
279: and run_val <> 0';
280:
281: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
282:
283: return lv_sql;
284:
285: END taxable_benefits;

Line 291: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.tax_balances ');

287: FUNCTION tax_balances( p_assignment_action_id in NUMBER )
288: RETURN LONG IS
289: BEGIN
290:
291: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.tax_balances ');
292: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
293:
294: pay_soe_util.clear;
295:

Line 292: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);

288: RETURN LONG IS
289: BEGIN
290:
291: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.tax_balances ');
292: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
293:
294: pay_soe_util.clear;
295:
296: lv_sql := 'select balance_name COL01

Line 304: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');

300: from PAY_MX_TAX_BALANCES_V
301: where assignment_action_id :action_clause
302: and run_val <> 0';
303:
304: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
305:
306: return lv_sql;
307:
308: END tax_balances;

Line 314: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.deductions ');

310: FUNCTION deductions( p_assignment_action_id in NUMBER )
311: RETURN LONG IS
312: BEGIN
313:
314: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.deductions ');
315: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
316:
317: pay_soe_util.clear;
318:

Line 315: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);

311: RETURN LONG IS
312: BEGIN
313:
314: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.deductions ');
315: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
316:
317: pay_soe_util.clear;
318:
319: lv_sql := 'select balance_name COL01

Line 327: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');

323: from PAY_MX_DEDUCTIONS_V
324: where assignment_action_id :action_clause
325: and run_val <> 0';
326:
327: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
328:
329: return lv_sql;
330:
331: END deductions;

Line 337: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.other_balances ');

333: FUNCTION other_balances( p_assignment_action_id in NUMBER )
334: RETURN LONG IS
335: BEGIN
336:
337: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.other_balances ');
338: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
339:
340: pay_soe_util.clear;
341:

Line 338: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);

334: RETURN LONG IS
335: BEGIN
336:
337: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.other_balances ');
338: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
339:
340: pay_soe_util.clear;
341:
342: lv_sql := 'select balance_name COL01

Line 353: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');

349: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18
350: from PAY_MX_OTHER_BALANCES_V
351: where assignment_action_id :action_clause';
352:
353: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
354:
355: return lv_sql;
356:
357: END other_balances;

Line 427: hr_utility.set_location('Entering pay_soe_glb.setParameters', 10);

423: --
424: begin
425: --
426: if g_debug then
427: hr_utility.set_location('Entering pay_soe_glb.setParameters', 10);
428: end if;
429: --
430: -- Prepay change
431: select action_type

Line 483: hr_utility.trace('p_payroll_id = ' || p.payroll_id);

479: 'PREPAY_MIN_ACTION:' ||l_min_action ||':'||
480: 'CURRENCY_NAME:' ||p.currency_name ||':'||
481: 'ASSIGNMENT_ACTION_ID:'||p_assignment_action_id||':';
482: if g_debug then
483: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
484: hr_utility.trace('jsqldate = ' || p.jsqldate);
485: hr_utility.trace('effective_date = ' || p.effective_date);
486: hr_utility.trace('assignment_id = ' || p.assignment_id);
487: hr_utility.trace('business_group_id = ' || p.business_group_id);

Line 484: hr_utility.trace('jsqldate = ' || p.jsqldate);

480: 'CURRENCY_NAME:' ||p.currency_name ||':'||
481: 'ASSIGNMENT_ACTION_ID:'||p_assignment_action_id||':';
482: if g_debug then
483: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
484: hr_utility.trace('jsqldate = ' || p.jsqldate);
485: hr_utility.trace('effective_date = ' || p.effective_date);
486: hr_utility.trace('assignment_id = ' || p.assignment_id);
487: hr_utility.trace('business_group_id = ' || p.business_group_id);
488: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);

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

481: 'ASSIGNMENT_ACTION_ID:'||p_assignment_action_id||':';
482: if g_debug then
483: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
484: hr_utility.trace('jsqldate = ' || p.jsqldate);
485: hr_utility.trace('effective_date = ' || p.effective_date);
486: hr_utility.trace('assignment_id = ' || p.assignment_id);
487: hr_utility.trace('business_group_id = ' || p.business_group_id);
488: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
489: hr_utility.trace('g_currency_code = ' || g_currency_code);

Line 486: hr_utility.trace('assignment_id = ' || p.assignment_id);

482: if g_debug then
483: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
484: hr_utility.trace('jsqldate = ' || p.jsqldate);
485: hr_utility.trace('effective_date = ' || p.effective_date);
486: hr_utility.trace('assignment_id = ' || p.assignment_id);
487: hr_utility.trace('business_group_id = ' || p.business_group_id);
488: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
489: hr_utility.trace('g_currency_code = ' || g_currency_code);
490: hr_utility.trace('action_clause = ' || l_actions);

Line 487: hr_utility.trace('business_group_id = ' || p.business_group_id);

483: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
484: hr_utility.trace('jsqldate = ' || p.jsqldate);
485: hr_utility.trace('effective_date = ' || p.effective_date);
486: hr_utility.trace('assignment_id = ' || p.assignment_id);
487: hr_utility.trace('business_group_id = ' || p.business_group_id);
488: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
489: hr_utility.trace('g_currency_code = ' || g_currency_code);
490: hr_utility.trace('action_clause = ' || l_actions);
491: end if;

Line 488: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);

484: hr_utility.trace('jsqldate = ' || p.jsqldate);
485: hr_utility.trace('effective_date = ' || p.effective_date);
486: hr_utility.trace('assignment_id = ' || p.assignment_id);
487: hr_utility.trace('business_group_id = ' || p.business_group_id);
488: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
489: hr_utility.trace('g_currency_code = ' || g_currency_code);
490: hr_utility.trace('action_clause = ' || l_actions);
491: end if;
492: g_currency_code := p.currency_code;

Line 489: hr_utility.trace('g_currency_code = ' || g_currency_code);

485: hr_utility.trace('effective_date = ' || p.effective_date);
486: hr_utility.trace('assignment_id = ' || p.assignment_id);
487: hr_utility.trace('business_group_id = ' || p.business_group_id);
488: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
489: hr_utility.trace('g_currency_code = ' || g_currency_code);
490: hr_utility.trace('action_clause = ' || l_actions);
491: end if;
492: g_currency_code := p.currency_code;
493: l_action_type := p.action_type;

Line 490: hr_utility.trace('action_clause = ' || l_actions);

486: hr_utility.trace('assignment_id = ' || p.assignment_id);
487: hr_utility.trace('business_group_id = ' || p.business_group_id);
488: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
489: hr_utility.trace('g_currency_code = ' || g_currency_code);
490: hr_utility.trace('action_clause = ' || l_actions);
491: end if;
492: g_currency_code := p.currency_code;
493: l_action_type := p.action_type;
494: end loop;

Line 505: hr_utility.trace('l_parameters = ' || l_parameters);

501: ' in ('||l_actions ||')' ||':';
502: end if;
503: --
504: if g_debug then
505: hr_utility.trace('l_parameters = ' || l_parameters);
506: hr_utility.set_location('Leaving pay_soe_glb.setParameters', 20);
507: end if;
508: --
509: return l_parameters;

Line 506: hr_utility.set_location('Leaving pay_soe_glb.setParameters', 20);

502: end if;
503: --
504: if g_debug then
505: hr_utility.trace('l_parameters = ' || l_parameters);
506: hr_utility.set_location('Leaving pay_soe_glb.setParameters', 20);
507: end if;
508: --
509: return l_parameters;
510: end;

Line 524: hr_utility.set_location('Entering pay_soe_glb.setParameters', 10);

520: RETURN VARCHAR2 is
521: begin
522: --
523: if g_debug then
524: hr_utility.set_location('Entering pay_soe_glb.setParameters', 10);
525: end if;
526: --
527: -- NOTE:
528: -- This overridden version of setParameters is not yet fully implemented

Line 536: hr_utility.set_location('Leaving pay_soe_glb.setParameters', 20);

532: -- derive the desired assignment_action_id, and then call
533: -- pay_soe_glb.setParameters with that assignment_action_id.
534: --
535: if g_debug then
536: hr_utility.set_location('Leaving pay_soe_glb.setParameters', 20);
537: end if;
538: --
539: RETURN null;
540: --

Line 544: -- hr_utility.trace_on(NULL, 'DEBUG');

540: --
541: END;
542:
543: BEGIN
544: -- hr_utility.trace_on(NULL, 'DEBUG');
545: lv_currency_code := 'MXN';
546: END pay_mx_soe_ss_pkg;