DBA Data[Home] [Help]

APPS.PAY_US_EMP_PAYSLIP_ACCRUAL_WEB dependencies on HR_UTILITY

Line 176: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 10);

172: lc_plan_exists VARCHAR2(1) := 'N';
173:
174: BEGIN
175:
176: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 10);
177: hr_utility.trace('p_assignment_action_id = ' || p_assignment_action_id);
178: hr_utility.trace('p_assignment_id = ' || p_assignment_id );
179: hr_utility.trace('p_cur_earned_date = ' || p_cur_earned_date );
180:

Line 177: hr_utility.trace('p_assignment_action_id = ' || p_assignment_action_id);

173:
174: BEGIN
175:
176: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 10);
177: hr_utility.trace('p_assignment_action_id = ' || p_assignment_action_id);
178: hr_utility.trace('p_assignment_id = ' || p_assignment_id );
179: hr_utility.trace('p_cur_earned_date = ' || p_cur_earned_date );
180:
181: open c_payroll_id(p_assignment_action_id);

Line 178: hr_utility.trace('p_assignment_id = ' || p_assignment_id );

174: BEGIN
175:
176: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 10);
177: hr_utility.trace('p_assignment_action_id = ' || p_assignment_action_id);
178: hr_utility.trace('p_assignment_id = ' || p_assignment_id );
179: hr_utility.trace('p_cur_earned_date = ' || p_cur_earned_date );
180:
181: open c_payroll_id(p_assignment_action_id);
182: fetch c_payroll_id into ln_payroll_id, ln_business_group_id;

Line 179: hr_utility.trace('p_cur_earned_date = ' || p_cur_earned_date );

175:
176: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 10);
177: hr_utility.trace('p_assignment_action_id = ' || p_assignment_action_id);
178: hr_utility.trace('p_assignment_id = ' || p_assignment_id );
179: hr_utility.trace('p_cur_earned_date = ' || p_cur_earned_date );
180:
181: open c_payroll_id(p_assignment_action_id);
182: fetch c_payroll_id into ln_payroll_id, ln_business_group_id;
183: if c_payroll_id%found then

Line 191: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 30);

187: close c_time_periods;
188: end if;
189: close c_payroll_id;
190:
191: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 30);
192: hr_utility.trace('Payroll Start Date = ' || ld_period_start_date);
193: hr_utility.trace('Payroll End Date = ' || ld_period_end_date);
194:
195: lv_correspndence_lang := pay_emp_action_arch.gv_correspondence_language;

Line 192: hr_utility.trace('Payroll Start Date = ' || ld_period_start_date);

188: end if;
189: close c_payroll_id;
190:
191: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 30);
192: hr_utility.trace('Payroll Start Date = ' || ld_period_start_date);
193: hr_utility.trace('Payroll End Date = ' || ld_period_end_date);
194:
195: lv_correspndence_lang := pay_emp_action_arch.gv_correspondence_language;
196:

Line 193: hr_utility.trace('Payroll End Date = ' || ld_period_end_date);

189: close c_payroll_id;
190:
191: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 30);
192: hr_utility.trace('Payroll Start Date = ' || ld_period_start_date);
193: hr_utility.trace('Payroll End Date = ' || ld_period_end_date);
194:
195: lv_correspndence_lang := pay_emp_action_arch.gv_correspondence_language;
196:
197: hr_utility.trace('lv_correspndence_lang = ' || lv_correspndence_lang);

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

193: hr_utility.trace('Payroll End Date = ' || ld_period_end_date);
194:
195: lv_correspndence_lang := pay_emp_action_arch.gv_correspondence_language;
196:
197: hr_utility.trace('lv_correspndence_lang = ' || lv_correspndence_lang);
198:
199: open c_accrual_category(lv_correspndence_lang);
200: loop
201: fetch c_accrual_category into lv_accrual_code, lv_accrual_category;

Line 206: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 50);

202: if c_accrual_category%notfound then
203: exit;
204: end if;
205:
206: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 50);
207: hr_utility.trace('Accrual Category = ' || lv_accrual_code);
208:
209: open c_accrual_plan( p_assignment_id
210: ,p_cur_earned_date

Line 207: hr_utility.trace('Accrual Category = ' || lv_accrual_code);

203: exit;
204: end if;
205:
206: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 50);
207: hr_utility.trace('Accrual Category = ' || lv_accrual_code);
208:
209: open c_accrual_plan( p_assignment_id
210: ,p_cur_earned_date
211: ,lv_accrual_code

Line 217: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 60);

213: loop
214: fetch c_accrual_plan into ln_accrual_plan_id
215: ,ln_accrual_ele_type_id;
216: if c_accrual_plan%notfound then
217: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 60);
218: exit;
219: end if;
220:
221: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 70);

Line 221: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 70);

217: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 60);
218: exit;
219: end if;
220:
221: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 70);
222: hr_utility.trace('Accrual Plan ID = ' || ln_accrual_plan_id);
223: hr_utility.trace('Accrual Elem ID = ' || ln_accrual_ele_type_id);
224:
225:

Line 222: hr_utility.trace('Accrual Plan ID = ' || ln_accrual_plan_id);

218: exit;
219: end if;
220:
221: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 70);
222: hr_utility.trace('Accrual Plan ID = ' || ln_accrual_plan_id);
223: hr_utility.trace('Accrual Elem ID = ' || ln_accrual_ele_type_id);
224:
225:
226: /*************************************************************

Line 223: hr_utility.trace('Accrual Elem ID = ' || ln_accrual_ele_type_id);

219: end if;
220:
221: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 70);
222: hr_utility.trace('Accrual Plan ID = ' || ln_accrual_plan_id);
223: hr_utility.trace('Accrual Elem ID = ' || ln_accrual_ele_type_id);
224:
225:
226: /*************************************************************
227: ** Set Var. if Plan Exists.

Line 246: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 80);

242: ,p_assignment_action_id => -1
243: );
244:
245:
246: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 80);
247:
248: per_accrual_calc_functions.get_net_accrual(
249: p_assignment_id => p_assignment_id,
250: p_plan_id => ln_accrual_plan_id,

Line 303: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 100);

299: if lc_plan_exists = 'Y' then
300:
301: i_count := i_count + 1;
302:
303: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 100);
304: lc_plan_exists := 'N';
305:
306: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_code
307: := lv_accrual_code;

Line 329: hr_utility.trace('Accrual Code = '

325: p_total_acc_category := i_count;
326:
327:
328: for i in 1 .. i_count loop
329: hr_utility.trace('Accrual Code = '
330: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_code);
331: hr_utility.trace('Accrual Type = '
332: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category);
333: hr_utility.trace('Accrual Current = '

Line 331: hr_utility.trace('Accrual Type = '

327:
328: for i in 1 .. i_count loop
329: hr_utility.trace('Accrual Code = '
330: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_code);
331: hr_utility.trace('Accrual Type = '
332: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category);
333: hr_utility.trace('Accrual Current = '
334: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);
335: hr_utility.trace('Accrual Bal = '

Line 333: hr_utility.trace('Accrual Current = '

329: hr_utility.trace('Accrual Code = '
330: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_code);
331: hr_utility.trace('Accrual Type = '
332: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category);
333: hr_utility.trace('Accrual Current = '
334: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);
335: hr_utility.trace('Accrual Bal = '
336: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);
337: end loop;

Line 335: hr_utility.trace('Accrual Bal = '

331: hr_utility.trace('Accrual Type = '
332: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category);
333: hr_utility.trace('Accrual Current = '
334: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);
335: hr_utility.trace('Accrual Bal = '
336: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);
337: end loop;
338:
339: hr_utility.trace('Total Accrual Account = ' || i_count);

Line 339: hr_utility.trace('Total Accrual Account = ' || i_count);

335: hr_utility.trace('Accrual Bal = '
336: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);
337: end loop;
338:
339: hr_utility.trace('Total Accrual Account = ' || i_count);
340: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 110);
341:
342: END get_emp_net_accrual;
343:

Line 340: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 110);

336: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);
337: end loop;
338:
339: hr_utility.trace('Total Accrual Account = ' || i_count);
340: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 110);
341:
342: END get_emp_net_accrual;
343:
344:

Line 367: -- hr_utility.trace_on(null, 'ORACLE');

363: END delete_ltr_assignment_accrual;
364:
365:
366: --BEGIN
367: -- hr_utility.trace_on(null, 'ORACLE');
368:
369: END pay_us_emp_payslip_accrual_web;