DBA Data[Home] [Help]

APPS.PAY_US_EMP_PAYSLIP_ACCRUAL_WEB dependencies on HR_UTILITY

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

180: l_start_date DATE; --16064956
181:
182: BEGIN
183:
184: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 10);
185: hr_utility.trace('p_assignment_action_id = ' || p_assignment_action_id);
186: hr_utility.trace('p_assignment_id = ' || p_assignment_id );
187: hr_utility.trace('p_cur_earned_date = ' || p_cur_earned_date );
188:

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

181:
182: BEGIN
183:
184: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 10);
185: hr_utility.trace('p_assignment_action_id = ' || p_assignment_action_id);
186: hr_utility.trace('p_assignment_id = ' || p_assignment_id );
187: hr_utility.trace('p_cur_earned_date = ' || p_cur_earned_date );
188:
189: open c_payroll_id(p_assignment_action_id);

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

182: BEGIN
183:
184: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 10);
185: hr_utility.trace('p_assignment_action_id = ' || p_assignment_action_id);
186: hr_utility.trace('p_assignment_id = ' || p_assignment_id );
187: hr_utility.trace('p_cur_earned_date = ' || p_cur_earned_date );
188:
189: open c_payroll_id(p_assignment_action_id);
190: fetch c_payroll_id into ln_payroll_id, ln_business_group_id;

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

183:
184: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 10);
185: hr_utility.trace('p_assignment_action_id = ' || p_assignment_action_id);
186: hr_utility.trace('p_assignment_id = ' || p_assignment_id );
187: hr_utility.trace('p_cur_earned_date = ' || p_cur_earned_date );
188:
189: open c_payroll_id(p_assignment_action_id);
190: fetch c_payroll_id into ln_payroll_id, ln_business_group_id;
191: if c_payroll_id%found then

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

195: close c_time_periods;
196: end if;
197: close c_payroll_id;
198:
199: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 30);
200: hr_utility.trace('Payroll Start Date = ' || ld_period_start_date);
201: hr_utility.trace('Payroll End Date = ' || ld_period_end_date);
202:
203: lv_correspndence_lang := pay_emp_action_arch.gv_correspondence_language;

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

196: end if;
197: close c_payroll_id;
198:
199: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 30);
200: hr_utility.trace('Payroll Start Date = ' || ld_period_start_date);
201: hr_utility.trace('Payroll End Date = ' || ld_period_end_date);
202:
203: lv_correspndence_lang := pay_emp_action_arch.gv_correspondence_language;
204:

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

197: close c_payroll_id;
198:
199: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 30);
200: hr_utility.trace('Payroll Start Date = ' || ld_period_start_date);
201: hr_utility.trace('Payroll End Date = ' || ld_period_end_date);
202:
203: lv_correspndence_lang := pay_emp_action_arch.gv_correspondence_language;
204:
205: hr_utility.trace('lv_correspndence_lang = ' || lv_correspndence_lang);

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

201: hr_utility.trace('Payroll End Date = ' || ld_period_end_date);
202:
203: lv_correspndence_lang := pay_emp_action_arch.gv_correspondence_language;
204:
205: hr_utility.trace('lv_correspndence_lang = ' || lv_correspndence_lang);
206:
207: open c_accrual_category(lv_correspndence_lang);
208: loop
209: fetch c_accrual_category into lv_accrual_code, lv_accrual_category;

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

210: if c_accrual_category%notfound then
211: exit;
212: end if;
213:
214: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 50);
215: hr_utility.trace('Accrual Category = ' || lv_accrual_code);
216:
217: open c_accrual_plan( p_assignment_id
218: ,p_cur_earned_date

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

211: exit;
212: end if;
213:
214: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 50);
215: hr_utility.trace('Accrual Category = ' || lv_accrual_code);
216:
217: open c_accrual_plan( p_assignment_id
218: ,p_cur_earned_date
219: ,lv_accrual_code

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

221: loop
222: fetch c_accrual_plan into ln_accrual_plan_id
223: ,ln_accrual_ele_type_id;
224: if c_accrual_plan%notfound then
225: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 60);
226: exit;
227: end if;
228:
229: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 70);

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

225: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 60);
226: exit;
227: end if;
228:
229: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 70);
230: hr_utility.trace('Accrual Plan ID = ' || ln_accrual_plan_id);
231: hr_utility.trace('Accrual Elem ID = ' || ln_accrual_ele_type_id);
232:
233:

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

226: exit;
227: end if;
228:
229: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 70);
230: hr_utility.trace('Accrual Plan ID = ' || ln_accrual_plan_id);
231: hr_utility.trace('Accrual Elem ID = ' || ln_accrual_ele_type_id);
232:
233:
234: /*************************************************************

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

227: end if;
228:
229: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 70);
230: hr_utility.trace('Accrual Plan ID = ' || ln_accrual_plan_id);
231: hr_utility.trace('Accrual Elem ID = ' || ln_accrual_ele_type_id);
232:
233:
234: /*************************************************************
235: ** Set Var. if Plan Exists.

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

251: ,p_assignment_action_id => -1
252: );*/
253:
254:
255: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 80);
256:
257: per_accrual_calc_functions.get_net_accrual(
258: p_assignment_id => p_assignment_id,
259: p_plan_id => ln_accrual_plan_id,

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

316: if lc_plan_exists = 'Y' then
317:
318: i_count := i_count + 1;
319:
320: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 100);
321: lc_plan_exists := 'N';
322:
323: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i_count).accrual_code
324: := lv_accrual_code;

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

342: p_total_acc_category := i_count;
343:
344:
345: for i in 1 .. i_count loop
346: hr_utility.trace('Accrual Code = '
347: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_code);
348: hr_utility.trace('Accrual Type = '
349: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category);
350: hr_utility.trace('Accrual Current = '

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

344:
345: for i in 1 .. i_count loop
346: hr_utility.trace('Accrual Code = '
347: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_code);
348: hr_utility.trace('Accrual Type = '
349: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category);
350: hr_utility.trace('Accrual Current = '
351: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);
352: hr_utility.trace('Accrual Bal = '

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

346: hr_utility.trace('Accrual Code = '
347: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_code);
348: hr_utility.trace('Accrual Type = '
349: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category);
350: hr_utility.trace('Accrual Current = '
351: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);
352: hr_utility.trace('Accrual Bal = '
353: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);
354: end loop;

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

348: hr_utility.trace('Accrual Type = '
349: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_category);
350: hr_utility.trace('Accrual Current = '
351: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_cur_value);
352: hr_utility.trace('Accrual Bal = '
353: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);
354: end loop;
355:
356: hr_utility.trace('Total Accrual Account = ' || i_count);

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

352: hr_utility.trace('Accrual Bal = '
353: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);
354: end loop;
355:
356: hr_utility.trace('Total Accrual Account = ' || i_count);
357: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 110);
358:
359: END get_emp_net_accrual;
360:

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

353: || pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_net_value);
354: end loop;
355:
356: hr_utility.trace('Total Accrual Account = ' || i_count);
357: hr_utility.set_location(gv_package_name || '.get_emp_net_accrual', 110);
358:
359: END get_emp_net_accrual;
360:
361:

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

380: END delete_ltr_assignment_accrual;
381:
382:
383: --BEGIN
384: -- hr_utility.trace_on(null, 'ORACLE');
385:
386: END pay_us_emp_payslip_accrual_web;