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 66: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.employee_earnings ');

62: FUNCTION employee_earnings( p_assignment_action_id in NUMBER )
63: RETURN CLOB IS
64: BEGIN
65:
66: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.employee_earnings ');
67: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
68:
69: pay_soe_util.clear;
70:

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

63: RETURN CLOB IS
64: BEGIN
65:
66: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.employee_earnings ');
67: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
68:
69: pay_soe_util.clear;
70:
71: lv_sql := 'select earn_bal_name COL01

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

77: from PAY_MX_EMPLOYEE_EARNINGS_V
78: where assignment_action_id :action_clause
79: and earn_run_val <> 0';
80:
81: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.employee_earnings ');
82:
83: return lv_sql;
84:
85: END employee_earnings;

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

87: FUNCTION employee_taxes( p_assignment_action_id in NUMBER )
88: RETURN CLOB IS
89: BEGIN
90:
91: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.employee_taxes ');
92: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
93:
94: pay_soe_util.clear;
95:

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

88: RETURN CLOB IS
89: BEGIN
90:
91: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.employee_taxes ');
92: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
93:
94: pay_soe_util.clear;
95:
96: lv_sql := 'select balance_name COL01

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

100: from PAY_MX_EMPLOYEE_TAXES_V
101: where assignment_action_id :action_clause
102: and run_val <> 0';
103:
104: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.employee_taxes ');
105:
106: return lv_sql;
107:
108: END employee_taxes;

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

110: FUNCTION tax_calc_details( p_assignment_action_id in NUMBER )
111: RETURN CLOB IS
112: BEGIN
113:
114: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.tax_calc_details ');
115: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
116:
117: pay_soe_util.clear;
118:

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

111: RETURN CLOB IS
112: BEGIN
113:
114: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.tax_calc_details ');
115: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
116:
117: pay_soe_util.clear;
118:
119: lv_sql := 'select balance_name COL01

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

123: from PAY_MX_TAX_CALC_DETAILS_V
124: where assignment_action_id :action_clause
125: and run_val <> 0';
126:
127: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
128:
129: return lv_sql;
130:
131: END tax_calc_details;

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

156:
157: summary summary_bal;
158:
159: BEGIN
160: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.mx_summary_balances ');
161: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
162: hr_utility.trace('lv_currency_code '||lv_currency_code);
163:
164: open c_tax_unit(p_assignment_action_id);

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

157: summary summary_bal;
158:
159: BEGIN
160: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.mx_summary_balances ');
161: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
162: hr_utility.trace('lv_currency_code '||lv_currency_code);
163:
164: open c_tax_unit(p_assignment_action_id);
165: fetch c_tax_unit into ln_tax_unit_id,ln_pyrl_act_id;

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

158:
159: BEGIN
160: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.mx_summary_balances ');
161: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
162: hr_utility.trace('lv_currency_code '||lv_currency_code);
163:
164: open c_tax_unit(p_assignment_action_id);
165: fetch c_tax_unit into ln_tax_unit_id,ln_pyrl_act_id;
166: close c_tax_unit;

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

202: pay_soe_util.clear;
203:
204: for i in summary.first..summary.last loop
205:
206: hr_utility.trace('i = '||i);
207: hr_utility.trace('Balance = '||summary(i).bal_name);
208:
209: summary(i).curr_def_bal_id :=
210: pay_ac_utility.get_defined_balance_id

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

203:
204: for i in summary.first..summary.last loop
205:
206: hr_utility.trace('i = '||i);
207: hr_utility.trace('Balance = '||summary(i).bal_name);
208:
209: summary(i).curr_def_bal_id :=
210: pay_ac_utility.get_defined_balance_id
211: (p_balance_name => summary(i).bal_name

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

226: -- pay_balance_pkg.get_value(summary(i).ytd_def_bal_id
227: -- ,p_assignment_action_id);
228: --
229: --
230: hr_utility.trace(' summary(i).curr_val '|| summary(i).curr_val);
231: pay_soe_util.setValue('01' ,summary(i).bal_name ,TRUE, FALSE);
232: pay_soe_util.setValue('02' ,summary(i).reporting_name ,FALSE, FALSE);
233: pay_soe_util.setValue('16' ,summary(i).curr_val, FALSE, FALSE );
234: pay_soe_util.setValue('17' ,summary(i).ytd_val, FALSE, TRUE );

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

234: pay_soe_util.setValue('17' ,summary(i).ytd_val, FALSE, TRUE );
235: --
236: end loop;
237:
238: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.mx_summary_balances ');
239:
240: return pay_soe_util.genCursor;
241:
242: END summary_balances;

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

244: FUNCTION hourly_earnings( p_assignment_action_id in NUMBER )
245: RETURN CLOB IS
246: BEGIN
247:
248: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.hourly_earnings ');
249: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
250:
251: pay_soe_util.clear;
252:

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

245: RETURN CLOB IS
246: BEGIN
247:
248: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.hourly_earnings ');
249: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
250:
251: pay_soe_util.clear;
252:
253: lv_sql := 'select earn_bal_name COL01

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

259: from PAY_MX_HOURLY_EARNINGS_V
260: where assignment_action_id :action_clause
261: and earn_run_val <> 0';
262:
263: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.employee_earnings ');
264:
265: return lv_sql;
266:
267: END hourly_earnings;

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

269: FUNCTION taxable_benefits( p_assignment_action_id in NUMBER )
270: RETURN CLOB IS
271: BEGIN
272:
273: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.taxable_benefits ');
274: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
275:
276: pay_soe_util.clear;
277:

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

270: RETURN CLOB IS
271: BEGIN
272:
273: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.taxable_benefits ');
274: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
275:
276: pay_soe_util.clear;
277:
278: lv_sql := 'select balance_name COL01

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

282: from PAY_MX_TAXABLE_BENEFITS_V
283: where assignment_action_id :action_clause
284: and run_val <> 0';
285:
286: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
287:
288: return lv_sql;
289:
290: END taxable_benefits;

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

292: FUNCTION tax_balances( p_assignment_action_id in NUMBER )
293: RETURN CLOB IS
294: BEGIN
295:
296: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.tax_balances ');
297: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
298:
299: pay_soe_util.clear;
300:

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

293: RETURN CLOB IS
294: BEGIN
295:
296: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.tax_balances ');
297: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
298:
299: pay_soe_util.clear;
300:
301: lv_sql := 'select balance_name COL01

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

305: from PAY_MX_TAX_BALANCES_V
306: where assignment_action_id :action_clause
307: and run_val <> 0';
308:
309: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
310:
311: return lv_sql;
312:
313: END tax_balances;

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

315: FUNCTION deductions( p_assignment_action_id in NUMBER )
316: RETURN CLOB IS
317: BEGIN
318:
319: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.deductions ');
320: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
321:
322: pay_soe_util.clear;
323:

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

316: RETURN CLOB IS
317: BEGIN
318:
319: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.deductions ');
320: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
321:
322: pay_soe_util.clear;
323:
324: lv_sql := 'select balance_name COL01

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

328: from PAY_MX_DEDUCTIONS_V
329: where assignment_action_id :action_clause
330: and run_val <> 0';
331:
332: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
333:
334: return lv_sql;
335:
336: END deductions;

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

338: FUNCTION other_balances( p_assignment_action_id in NUMBER )
339: RETURN CLOB IS
340: BEGIN
341:
342: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.other_balances ');
343: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
344:
345: pay_soe_util.clear;
346:

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

339: RETURN CLOB IS
340: BEGIN
341:
342: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.other_balances ');
343: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
344:
345: pay_soe_util.clear;
346:
347: lv_sql := 'select balance_name COL01

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

354: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18
355: from PAY_MX_OTHER_BALANCES_V
356: where assignment_action_id :action_clause';
357:
358: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
359:
360: return lv_sql;
361:
362: END other_balances;

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

428: --
429: begin
430: --
431: if g_debug then
432: hr_utility.set_location('Entering pay_soe_glb.setParameters', 10);
433: end if;
434: --
435: -- Prepay change
436: select action_type

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

484: 'PREPAY_MIN_ACTION:' ||l_min_action ||':'||
485: 'CURRENCY_NAME:' ||p.currency_name ||':'||
486: 'ASSIGNMENT_ACTION_ID:'||p_assignment_action_id||':';
487: if g_debug then
488: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
489: hr_utility.trace('jsqldate = ' || p.jsqldate);
490: hr_utility.trace('effective_date = ' || p.effective_date);
491: hr_utility.trace('assignment_id = ' || p.assignment_id);
492: hr_utility.trace('business_group_id = ' || p.business_group_id);

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

485: 'CURRENCY_NAME:' ||p.currency_name ||':'||
486: 'ASSIGNMENT_ACTION_ID:'||p_assignment_action_id||':';
487: if g_debug then
488: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
489: hr_utility.trace('jsqldate = ' || p.jsqldate);
490: hr_utility.trace('effective_date = ' || p.effective_date);
491: hr_utility.trace('assignment_id = ' || p.assignment_id);
492: hr_utility.trace('business_group_id = ' || p.business_group_id);
493: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);

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

486: 'ASSIGNMENT_ACTION_ID:'||p_assignment_action_id||':';
487: if g_debug then
488: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
489: hr_utility.trace('jsqldate = ' || p.jsqldate);
490: hr_utility.trace('effective_date = ' || p.effective_date);
491: hr_utility.trace('assignment_id = ' || p.assignment_id);
492: hr_utility.trace('business_group_id = ' || p.business_group_id);
493: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
494: hr_utility.trace('g_currency_code = ' || g_currency_code);

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

487: if g_debug then
488: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
489: hr_utility.trace('jsqldate = ' || p.jsqldate);
490: hr_utility.trace('effective_date = ' || p.effective_date);
491: hr_utility.trace('assignment_id = ' || p.assignment_id);
492: hr_utility.trace('business_group_id = ' || p.business_group_id);
493: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
494: hr_utility.trace('g_currency_code = ' || g_currency_code);
495: hr_utility.trace('action_clause = ' || l_actions);

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

488: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
489: hr_utility.trace('jsqldate = ' || p.jsqldate);
490: hr_utility.trace('effective_date = ' || p.effective_date);
491: hr_utility.trace('assignment_id = ' || p.assignment_id);
492: hr_utility.trace('business_group_id = ' || p.business_group_id);
493: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
494: hr_utility.trace('g_currency_code = ' || g_currency_code);
495: hr_utility.trace('action_clause = ' || l_actions);
496: end if;

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

489: hr_utility.trace('jsqldate = ' || p.jsqldate);
490: hr_utility.trace('effective_date = ' || p.effective_date);
491: hr_utility.trace('assignment_id = ' || p.assignment_id);
492: hr_utility.trace('business_group_id = ' || p.business_group_id);
493: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
494: hr_utility.trace('g_currency_code = ' || g_currency_code);
495: hr_utility.trace('action_clause = ' || l_actions);
496: end if;
497: g_currency_code := p.currency_code;

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

490: hr_utility.trace('effective_date = ' || p.effective_date);
491: hr_utility.trace('assignment_id = ' || p.assignment_id);
492: hr_utility.trace('business_group_id = ' || p.business_group_id);
493: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
494: hr_utility.trace('g_currency_code = ' || g_currency_code);
495: hr_utility.trace('action_clause = ' || l_actions);
496: end if;
497: g_currency_code := p.currency_code;
498: l_action_type := p.action_type;

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

491: hr_utility.trace('assignment_id = ' || p.assignment_id);
492: hr_utility.trace('business_group_id = ' || p.business_group_id);
493: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
494: hr_utility.trace('g_currency_code = ' || g_currency_code);
495: hr_utility.trace('action_clause = ' || l_actions);
496: end if;
497: g_currency_code := p.currency_code;
498: l_action_type := p.action_type;
499: end loop;

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

506: ' in ('||l_actions ||')' ||':';
507: end if;
508: --
509: if g_debug then
510: hr_utility.trace('l_parameters = ' || l_parameters);
511: hr_utility.set_location('Leaving pay_soe_glb.setParameters', 20);
512: end if;
513: --
514: return l_parameters;

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

507: end if;
508: --
509: if g_debug then
510: hr_utility.trace('l_parameters = ' || l_parameters);
511: hr_utility.set_location('Leaving pay_soe_glb.setParameters', 20);
512: end if;
513: --
514: return l_parameters;
515: end;

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

525: RETURN VARCHAR2 is
526: begin
527: --
528: if g_debug then
529: hr_utility.set_location('Entering pay_soe_glb.setParameters', 10);
530: end if;
531: --
532: -- NOTE:
533: -- This overridden version of setParameters is not yet fully implemented

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

540:
541: return (pay_soe_glb.setParameters(p_person_id, p_assignment_id, p_effective_date));
542:
543: if g_debug then
544: hr_utility.set_location('Leaving pay_soe_glb.setParameters', 20);
545: end if;
546: --
547: RETURN null;
548: --

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

548: --
549: END;
550:
551: BEGIN
552: -- hr_utility.trace_on(NULL, 'DEBUG');
553: lv_currency_code := 'MXN';
554: END pay_mx_soe_ss_pkg;