APPS.PAY_EMP_ACTION_ARCH dependencies on HR_UTILITY

Line 46: 29-AUG-2001 asasthan 115.3 Addedc some hr_utility messages.

42: we can save DB calls.
43: Added debug stmt and formated
44: 28-AUG-2001 asasthan 115.2 Changed net pay distribution
45: and employee details.
46: 29-AUG-2001 asasthan 115.3 Addedc some hr_utility messages.
47: 17-SEP-2001 asasthan 115.4 Added pre_payment_id in
48: action_information16 for
49: EMPLOYEE NET PAY DISTRIBUTION.
50: 18-SEP-2001 asasthan 115.5 Added pre_payment_assignment_action

Line 235: hr_utility.trace('opened c_get_defined_balance');

231: ln_defined_balance_id NUMBER;
232: lv_error_message VARCHAR2(200);
233:
234: BEGIN
235: hr_utility.trace('opened c_get_defined_balance');
236: open c_get_defined_balance_id(p_balance_id,
237: p_balance_dimension,
238: p_legislation_code);
239:

Line 246: hr_utility.trace('Defined balance id not found for... ' );

242: /*********************************************************
243: ** If defined_balance_id not found then return null.
244: ** This will happen for the Hours YTD balance
245: *********************************************************/
246: hr_utility.trace('Defined balance id not found for... ' );
247: hr_utility.trace(' p_balance_id = ' || p_balance_id);
248: hr_utility.trace(' p_balance_dimension = ' || p_balance_dimension);
249: hr_utility.trace(' p_legislation_code = ' || p_legislation_code);
250: end if;

Line 247: hr_utility.trace(' p_balance_id = ' || p_balance_id);

243: ** If defined_balance_id not found then return null.
244: ** This will happen for the Hours YTD balance
245: *********************************************************/
246: hr_utility.trace('Defined balance id not found for... ' );
247: hr_utility.trace(' p_balance_id = ' || p_balance_id);
248: hr_utility.trace(' p_balance_dimension = ' || p_balance_dimension);
249: hr_utility.trace(' p_legislation_code = ' || p_legislation_code);
250: end if;
251: close c_get_defined_balance_id;

Line 248: hr_utility.trace(' p_balance_dimension = ' || p_balance_dimension);

244: ** This will happen for the Hours YTD balance
245: *********************************************************/
246: hr_utility.trace('Defined balance id not found for... ' );
247: hr_utility.trace(' p_balance_id = ' || p_balance_id);
248: hr_utility.trace(' p_balance_dimension = ' || p_balance_dimension);
249: hr_utility.trace(' p_legislation_code = ' || p_legislation_code);
250: end if;
251: close c_get_defined_balance_id;
252: hr_utility.trace('ln_defined_balance_id = ' || ln_defined_balance_id);

Line 249: hr_utility.trace(' p_legislation_code = ' || p_legislation_code);

245: *********************************************************/
246: hr_utility.trace('Defined balance id not found for... ' );
247: hr_utility.trace(' p_balance_id = ' || p_balance_id);
248: hr_utility.trace(' p_balance_dimension = ' || p_balance_dimension);
249: hr_utility.trace(' p_legislation_code = ' || p_legislation_code);
250: end if;
251: close c_get_defined_balance_id;
252: hr_utility.trace('ln_defined_balance_id = ' || ln_defined_balance_id);
253: return ln_defined_balance_id ;

Line 252: hr_utility.trace('ln_defined_balance_id = ' || ln_defined_balance_id);

248: hr_utility.trace(' p_balance_dimension = ' || p_balance_dimension);
249: hr_utility.trace(' p_legislation_code = ' || p_legislation_code);
250: end if;
251: close c_get_defined_balance_id;
252: hr_utility.trace('ln_defined_balance_id = ' || ln_defined_balance_id);
253: return ln_defined_balance_id ;
254:
255: END get_defined_balance_id;
256:

Line 282: hr_utility.set_location(gv_package || lv_procedure_name, 10);

278: lv_procedure_name VARCHAR2(50);
279: BEGIN
280: lv_multi_leg_rule := 'N';
281: lv_procedure_name := '.get_multi_legislative_rule' ;
282: hr_utility.set_location(gv_package || lv_procedure_name, 10);
283: open c_leg_rule(p_legislation_code);
284: fetch c_leg_rule into lv_multi_leg_rule;
285: if c_leg_rule%found then
286: lv_multi_leg_rule := 'Y';

Line 292: hr_utility.trace('lv_multi_leg_rule = ' || lv_multi_leg_rule);

288: lv_multi_leg_rule := 'N';
289: end if;
290: close c_leg_rule;
291:
292: hr_utility.trace('lv_multi_leg_rule = ' || lv_multi_leg_rule);
293: hr_utility.set_location(gv_package || lv_procedure_name, 100);
294: return(lv_multi_leg_rule);
295:
296: END get_multi_legislative_rule;

Line 293: hr_utility.set_location(gv_package || lv_procedure_name, 100);

289: end if;
290: close c_leg_rule;
291:
292: hr_utility.trace('lv_multi_leg_rule = ' || lv_multi_leg_rule);
293: hr_utility.set_location(gv_package || lv_procedure_name, 100);
294: return(lv_multi_leg_rule);
295:
296: END get_multi_legislative_rule;
297:

Line 326: hr_utility.set_location(gv_package || lv_procedure_name, 10);

322:
323: BEGIN
324: lv_multi_asg_flag := 'N';
325: lv_procedure_name := '.get_multi_assignment_flag' ;
326: hr_utility.set_location(gv_package || lv_procedure_name, 10);
327: open c_get_payroll_info(p_payroll_id, p_effective_date);
328: fetch c_get_payroll_info into lv_multi_asg_flag;
329: if c_get_payroll_info%found then
330: lv_multi_asg_flag := 'Y';

Line 335: hr_utility.set_location(gv_package || lv_procedure_name, 30);

331: else
332: lv_multi_asg_flag := 'N';
333: end if;
334: close c_get_payroll_info;
335: hr_utility.set_location(gv_package || lv_procedure_name, 30);
336: hr_utility.trace('lv_multi_asg_flag = ' || lv_multi_asg_flag);
337: return lv_multi_asg_flag;
338:
339: END get_multi_assignment_flag;

Line 336: hr_utility.trace('lv_multi_asg_flag = ' || lv_multi_asg_flag);

332: lv_multi_asg_flag := 'N';
333: end if;
334: close c_get_payroll_info;
335: hr_utility.set_location(gv_package || lv_procedure_name, 30);
336: hr_utility.trace('lv_multi_asg_flag = ' || lv_multi_asg_flag);
337: return lv_multi_asg_flag;
338:
339: END get_multi_assignment_flag;
340:

Line 357: hr_utility.set_location(gv_package || lv_procedure_name, 10);

353: lv_procedure_name VARCHAR2(100);
354:
355: BEGIN
356: lv_procedure_name := '.initialization_process';
357: hr_utility.set_location(gv_package || lv_procedure_name, 10);
358:
359: if pay_emp_action_arch.lrr_act_tab.count > 0 then
360: hr_utility.set_location(gv_package || lv_procedure_name, 20);
361: for i in pay_emp_action_arch.lrr_act_tab.first ..

Line 360: hr_utility.set_location(gv_package || lv_procedure_name, 20);

356: lv_procedure_name := '.initialization_process';
357: hr_utility.set_location(gv_package || lv_procedure_name, 10);
358:
359: if pay_emp_action_arch.lrr_act_tab.count > 0 then
360: hr_utility.set_location(gv_package || lv_procedure_name, 20);
361: for i in pay_emp_action_arch.lrr_act_tab.first ..
362: pay_emp_action_arch.lrr_act_tab.last loop
363: pay_emp_action_arch.lrr_act_tab(i).action_context_id := null;
364: pay_emp_action_arch.lrr_act_tab(i).action_context_type := null;

Line 401: hr_utility.set_location(gv_package || lv_procedure_name, 30);

397: end loop;
398: end if;
399: pay_emp_action_arch.lrr_act_tab.delete;
400: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.delete;
401: hr_utility.set_location(gv_package || lv_procedure_name, 30);
402:
403: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
404: hr_utility.set_location(gv_package || lv_procedure_name, 40);
405: for i in pay_emp_action_arch.ltr_ppa_arch.first ..

Line 404: hr_utility.set_location(gv_package || lv_procedure_name, 40);

400: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.delete;
401: hr_utility.set_location(gv_package || lv_procedure_name, 30);
402:
403: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
404: hr_utility.set_location(gv_package || lv_procedure_name, 40);
405: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
406: pay_emp_action_arch.ltr_ppa_arch.last loop
407: pay_emp_action_arch.ltr_ppa_arch(i).action_context_id := null;
408: pay_emp_action_arch.ltr_ppa_arch(i).action_context_type := null;

Line 445: hr_utility.set_location(gv_package || lv_procedure_name, 50);

441: end loop;
442: end if;
443: pay_emp_action_arch.ltr_ppa_arch.delete;
444:
445: hr_utility.set_location(gv_package || lv_procedure_name, 50);
446: END initialization_process;
447:
448:
449:

Line 472: hr_utility.set_location(gv_package || lv_procedure_name, 10);

468: lv_procedure_name VARCHAR2(100);
469:
470: BEGIN
471: lv_procedure_name := '.insert_rows_thro_api_process';
472: hr_utility.set_location(gv_package || lv_procedure_name, 10);
473:
474: if p_tab_rec_data.count > 0 then
475: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
476: hr_utility.trace('Defining category '||

Line 476: hr_utility.trace('Defining category '||

472: hr_utility.set_location(gv_package || lv_procedure_name, 10);
473:
474: if p_tab_rec_data.count > 0 then
475: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
476: hr_utility.trace('Defining category '||
477: p_tab_rec_data(i).action_info_category);
478: hr_utility.trace('action_context_id = '|| p_action_context_id);
479: hr_utility.trace('jurisdiction_code '||
480: p_tab_rec_data(i).jurisdiction_code);

Line 478: hr_utility.trace('action_context_id = '|| p_action_context_id);

474: if p_tab_rec_data.count > 0 then
475: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
476: hr_utility.trace('Defining category '||
477: p_tab_rec_data(i).action_info_category);
478: hr_utility.trace('action_context_id = '|| p_action_context_id);
479: hr_utility.trace('jurisdiction_code '||
480: p_tab_rec_data(i).jurisdiction_code);
481: hr_utility.trace('act_info1 is'|| p_tab_rec_data(i).act_info1);
482: hr_utility.trace('act_info2 is'|| p_tab_rec_data(i).act_info2);

Line 479: hr_utility.trace('jurisdiction_code '||

475: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
476: hr_utility.trace('Defining category '||
477: p_tab_rec_data(i).action_info_category);
478: hr_utility.trace('action_context_id = '|| p_action_context_id);
479: hr_utility.trace('jurisdiction_code '||
480: p_tab_rec_data(i).jurisdiction_code);
481: hr_utility.trace('act_info1 is'|| p_tab_rec_data(i).act_info1);
482: hr_utility.trace('act_info2 is'|| p_tab_rec_data(i).act_info2);
483: hr_utility.trace('act_info3 is'|| p_tab_rec_data(i).act_info3);

Line 481: hr_utility.trace('act_info1 is'|| p_tab_rec_data(i).act_info1);

477: p_tab_rec_data(i).action_info_category);
478: hr_utility.trace('action_context_id = '|| p_action_context_id);
479: hr_utility.trace('jurisdiction_code '||
480: p_tab_rec_data(i).jurisdiction_code);
481: hr_utility.trace('act_info1 is'|| p_tab_rec_data(i).act_info1);
482: hr_utility.trace('act_info2 is'|| p_tab_rec_data(i).act_info2);
483: hr_utility.trace('act_info3 is'|| p_tab_rec_data(i).act_info3);
484: hr_utility.trace('act_info4 is'|| p_tab_rec_data(i).act_info4);
485: hr_utility.trace('act_info5 is'|| p_tab_rec_data(i).act_info5);

Line 482: hr_utility.trace('act_info2 is'|| p_tab_rec_data(i).act_info2);

478: hr_utility.trace('action_context_id = '|| p_action_context_id);
479: hr_utility.trace('jurisdiction_code '||
480: p_tab_rec_data(i).jurisdiction_code);
481: hr_utility.trace('act_info1 is'|| p_tab_rec_data(i).act_info1);
482: hr_utility.trace('act_info2 is'|| p_tab_rec_data(i).act_info2);
483: hr_utility.trace('act_info3 is'|| p_tab_rec_data(i).act_info3);
484: hr_utility.trace('act_info4 is'|| p_tab_rec_data(i).act_info4);
485: hr_utility.trace('act_info5 is'|| p_tab_rec_data(i).act_info5);
486: hr_utility.trace('act_info6 is'|| p_tab_rec_data(i).act_info6);

Line 483: hr_utility.trace('act_info3 is'|| p_tab_rec_data(i).act_info3);

479: hr_utility.trace('jurisdiction_code '||
480: p_tab_rec_data(i).jurisdiction_code);
481: hr_utility.trace('act_info1 is'|| p_tab_rec_data(i).act_info1);
482: hr_utility.trace('act_info2 is'|| p_tab_rec_data(i).act_info2);
483: hr_utility.trace('act_info3 is'|| p_tab_rec_data(i).act_info3);
484: hr_utility.trace('act_info4 is'|| p_tab_rec_data(i).act_info4);
485: hr_utility.trace('act_info5 is'|| p_tab_rec_data(i).act_info5);
486: hr_utility.trace('act_info6 is'|| p_tab_rec_data(i).act_info6);
487: hr_utility.trace('act_info30 is'|| p_tab_rec_data(i).act_info30);

Line 484: hr_utility.trace('act_info4 is'|| p_tab_rec_data(i).act_info4);

480: p_tab_rec_data(i).jurisdiction_code);
481: hr_utility.trace('act_info1 is'|| p_tab_rec_data(i).act_info1);
482: hr_utility.trace('act_info2 is'|| p_tab_rec_data(i).act_info2);
483: hr_utility.trace('act_info3 is'|| p_tab_rec_data(i).act_info3);
484: hr_utility.trace('act_info4 is'|| p_tab_rec_data(i).act_info4);
485: hr_utility.trace('act_info5 is'|| p_tab_rec_data(i).act_info5);
486: hr_utility.trace('act_info6 is'|| p_tab_rec_data(i).act_info6);
487: hr_utility.trace('act_info30 is'|| p_tab_rec_data(i).act_info30);
488:

Line 485: hr_utility.trace('act_info5 is'|| p_tab_rec_data(i).act_info5);

481: hr_utility.trace('act_info1 is'|| p_tab_rec_data(i).act_info1);
482: hr_utility.trace('act_info2 is'|| p_tab_rec_data(i).act_info2);
483: hr_utility.trace('act_info3 is'|| p_tab_rec_data(i).act_info3);
484: hr_utility.trace('act_info4 is'|| p_tab_rec_data(i).act_info4);
485: hr_utility.trace('act_info5 is'|| p_tab_rec_data(i).act_info5);
486: hr_utility.trace('act_info6 is'|| p_tab_rec_data(i).act_info6);
487: hr_utility.trace('act_info30 is'|| p_tab_rec_data(i).act_info30);
488:
489: hr_utility.set_location(gv_package || '.' || lv_procedure_name, 30);

Line 486: hr_utility.trace('act_info6 is'|| p_tab_rec_data(i).act_info6);

482: hr_utility.trace('act_info2 is'|| p_tab_rec_data(i).act_info2);
483: hr_utility.trace('act_info3 is'|| p_tab_rec_data(i).act_info3);
484: hr_utility.trace('act_info4 is'|| p_tab_rec_data(i).act_info4);
485: hr_utility.trace('act_info5 is'|| p_tab_rec_data(i).act_info5);
486: hr_utility.trace('act_info6 is'|| p_tab_rec_data(i).act_info6);
487: hr_utility.trace('act_info30 is'|| p_tab_rec_data(i).act_info30);
488:
489: hr_utility.set_location(gv_package || '.' || lv_procedure_name, 30);
490: pay_action_information_api.create_action_information(

Line 487: hr_utility.trace('act_info30 is'|| p_tab_rec_data(i).act_info30);

483: hr_utility.trace('act_info3 is'|| p_tab_rec_data(i).act_info3);
484: hr_utility.trace('act_info4 is'|| p_tab_rec_data(i).act_info4);
485: hr_utility.trace('act_info5 is'|| p_tab_rec_data(i).act_info5);
486: hr_utility.trace('act_info6 is'|| p_tab_rec_data(i).act_info6);
487: hr_utility.trace('act_info30 is'|| p_tab_rec_data(i).act_info30);
488:
489: hr_utility.set_location(gv_package || '.' || lv_procedure_name, 30);
490: pay_action_information_api.create_action_information(
491: p_action_information_id => l_action_information_id_1,

Line 489: hr_utility.set_location(gv_package || '.' || lv_procedure_name, 30);

485: hr_utility.trace('act_info5 is'|| p_tab_rec_data(i).act_info5);
486: hr_utility.trace('act_info6 is'|| p_tab_rec_data(i).act_info6);
487: hr_utility.trace('act_info30 is'|| p_tab_rec_data(i).act_info30);
488:
489: hr_utility.set_location(gv_package || '.' || lv_procedure_name, 30);
490: pay_action_information_api.create_action_information(
491: p_action_information_id => l_action_information_id_1,
492: p_object_version_number => l_object_version_number_1,
493: p_action_information_category

Line 536: hr_utility.set_location(gv_package || lv_procedure_name, 50);

532: );
533:
534: end loop;
535: end if;
536: hr_utility.set_location(gv_package || lv_procedure_name, 50);
537: END insert_rows_thro_api_process;
538:
539:
540:

Line 832: hr_utility.set_location(gv_package || lv_procedure_name, 10);

828: lv_value_type := null;
829: lv_value := null;
830: lv_organization_fetch := 'N';
831: lv_exists := 'N';
832: hr_utility.set_location(gv_package || lv_procedure_name, 10);
833: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
834: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
835: hr_utility.trace('p_organization_id = ' || p_organization_id);
836: hr_utility.trace('p_business_group_id = ' || p_business_group_id);

Line 833: hr_utility.trace('p_run_action_id = ' || p_run_action_id);

829: lv_value := null;
830: lv_organization_fetch := 'N';
831: lv_exists := 'N';
832: hr_utility.set_location(gv_package || lv_procedure_name, 10);
833: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
834: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
835: hr_utility.trace('p_organization_id = ' || p_organization_id);
836: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
837: hr_utility.trace('p_curr_pymt_eff_date = '|| p_curr_pymt_eff_date);

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

830: lv_organization_fetch := 'N';
831: lv_exists := 'N';
832: hr_utility.set_location(gv_package || lv_procedure_name, 10);
833: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
834: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
835: hr_utility.trace('p_organization_id = ' || p_organization_id);
836: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
837: hr_utility.trace('p_curr_pymt_eff_date = '|| p_curr_pymt_eff_date);
838: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);

Line 835: hr_utility.trace('p_organization_id = ' || p_organization_id);

831: lv_exists := 'N';
832: hr_utility.set_location(gv_package || lv_procedure_name, 10);
833: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
834: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
835: hr_utility.trace('p_organization_id = ' || p_organization_id);
836: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
837: hr_utility.trace('p_curr_pymt_eff_date = '|| p_curr_pymt_eff_date);
838: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
839:

Line 836: hr_utility.trace('p_business_group_id = ' || p_business_group_id);

832: hr_utility.set_location(gv_package || lv_procedure_name, 10);
833: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
834: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
835: hr_utility.trace('p_organization_id = ' || p_organization_id);
836: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
837: hr_utility.trace('p_curr_pymt_eff_date = '|| p_curr_pymt_eff_date);
838: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
839:
840: open c_organization_info(p_organization_id,

Line 837: hr_utility.trace('p_curr_pymt_eff_date = '|| p_curr_pymt_eff_date);

833: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
834: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
835: hr_utility.trace('p_organization_id = ' || p_organization_id);
836: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
837: hr_utility.trace('p_curr_pymt_eff_date = '|| p_curr_pymt_eff_date);
838: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
839:
840: open c_organization_info(p_organization_id,
841: 'Organization:Payslip Info');

Line 838: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);

834: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
835: hr_utility.trace('p_organization_id = ' || p_organization_id);
836: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
837: hr_utility.trace('p_curr_pymt_eff_date = '|| p_curr_pymt_eff_date);
838: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
839:
840: open c_organization_info(p_organization_id,
841: 'Organization:Payslip Info');
842: hr_utility.set_location(gv_package || lv_procedure_name, 20);

Line 842: hr_utility.set_location(gv_package || lv_procedure_name, 20);

838: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
839:
840: open c_organization_info(p_organization_id,
841: 'Organization:Payslip Info');
842: hr_utility.set_location(gv_package || lv_procedure_name, 20);
843: loop
844: fetch c_organization_info into lv_info_type
845: ,ln_element_type_id
846: ,ln_input_value_id

Line 856: hr_utility.set_location(gv_package || lv_procedure_name, 30);

852: if c_organization_info%notfound then
853: exit;
854: end if;
855:
856: hr_utility.set_location(gv_package || lv_procedure_name, 30);
857: hr_utility.trace('lv_info_type ' || lv_info_type);
858: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
859: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
860: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);

Line 857: hr_utility.trace('lv_info_type ' || lv_info_type);

853: exit;
854: end if;
855:
856: hr_utility.set_location(gv_package || lv_procedure_name, 30);
857: hr_utility.trace('lv_info_type ' || lv_info_type);
858: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
859: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
860: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
861: hr_utility.trace('ln_balance_dimension_id ' || ln_balance_dimension_id);

Line 858: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);

854: end if;
855:
856: hr_utility.set_location(gv_package || lv_procedure_name, 30);
857: hr_utility.trace('lv_info_type ' || lv_info_type);
858: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
859: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
860: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
861: hr_utility.trace('ln_balance_dimension_id ' || ln_balance_dimension_id);
862: hr_utility.trace('lv_message ' || lv_message);

Line 859: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);

855:
856: hr_utility.set_location(gv_package || lv_procedure_name, 30);
857: hr_utility.trace('lv_info_type ' || lv_info_type);
858: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
859: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
860: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
861: hr_utility.trace('ln_balance_dimension_id ' || ln_balance_dimension_id);
862: hr_utility.trace('lv_message ' || lv_message);
863: hr_utility.trace('lv_display_name ' ||lv_display_name);

Line 860: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);

856: hr_utility.set_location(gv_package || lv_procedure_name, 30);
857: hr_utility.trace('lv_info_type ' || lv_info_type);
858: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
859: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
860: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
861: hr_utility.trace('ln_balance_dimension_id ' || ln_balance_dimension_id);
862: hr_utility.trace('lv_message ' || lv_message);
863: hr_utility.trace('lv_display_name ' ||lv_display_name);
864:

Line 861: hr_utility.trace('ln_balance_dimension_id ' || ln_balance_dimension_id);

857: hr_utility.trace('lv_info_type ' || lv_info_type);
858: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
859: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
860: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
861: hr_utility.trace('ln_balance_dimension_id ' || ln_balance_dimension_id);
862: hr_utility.trace('lv_message ' || lv_message);
863: hr_utility.trace('lv_display_name ' ||lv_display_name);
864:
865: lv_organization_fetch := 'Y' ;

Line 862: hr_utility.trace('lv_message ' || lv_message);

858: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
859: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
860: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
861: hr_utility.trace('ln_balance_dimension_id ' || ln_balance_dimension_id);
862: hr_utility.trace('lv_message ' || lv_message);
863: hr_utility.trace('lv_display_name ' ||lv_display_name);
864:
865: lv_organization_fetch := 'Y' ;
866:

Line 863: hr_utility.trace('lv_display_name ' ||lv_display_name);

859: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
860: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
861: hr_utility.trace('ln_balance_dimension_id ' || ln_balance_dimension_id);
862: hr_utility.trace('lv_message ' || lv_message);
863: hr_utility.trace('lv_display_name ' ||lv_display_name);
864:
865: lv_organization_fetch := 'Y' ;
866:
867: if lv_info_type ='ELEMENT' then

Line 868: hr_utility.set_location(gv_package || lv_procedure_name, 40);

864:
865: lv_organization_fetch := 'Y' ;
866:
867: if lv_info_type ='ELEMENT' then
868: hr_utility.set_location(gv_package || lv_procedure_name, 40);
869: open c_element_details(ln_element_type_id
870: ,ln_input_value_id
871: ,p_assignment_id
872: );

Line 878: hr_utility.set_location(gv_package || lv_procedure_name, 50);

874: lv_value,
875: lv_value_type,
876: lv_uom;
877: if c_element_details%found then
878: hr_utility.set_location(gv_package || lv_procedure_name, 50);
879: hr_utility.trace('lv_uom ' || lv_uom);
880:
881: if lv_uom in ('M', 'N', 'I') then
882: lv_value := fnd_number.number_to_canonical(lv_value);

Line 879: hr_utility.trace('lv_uom ' || lv_uom);

875: lv_value_type,
876: lv_uom;
877: if c_element_details%found then
878: hr_utility.set_location(gv_package || lv_procedure_name, 50);
879: hr_utility.trace('lv_uom ' || lv_uom);
880:
881: if lv_uom in ('M', 'N', 'I') then
882: lv_value := fnd_number.number_to_canonical(lv_value);
883: end if;

Line 884: hr_utility.trace('lv_value ' || lv_value);

880:
881: if lv_uom in ('M', 'N', 'I') then
882: lv_value := fnd_number.number_to_canonical(lv_value);
883: end if;
884: hr_utility.trace('lv_value ' || lv_value);
885: hr_utility.trace('lv_name ' || lv_info_type);
886: hr_utility.trace('lv_value_type ' || lv_value_type);
887:
888: ln_index := pay_emp_action_arch.lrr_act_tab.count;

Line 885: hr_utility.trace('lv_name ' || lv_info_type);

881: if lv_uom in ('M', 'N', 'I') then
882: lv_value := fnd_number.number_to_canonical(lv_value);
883: end if;
884: hr_utility.trace('lv_value ' || lv_value);
885: hr_utility.trace('lv_name ' || lv_info_type);
886: hr_utility.trace('lv_value_type ' || lv_value_type);
887:
888: ln_index := pay_emp_action_arch.lrr_act_tab.count;
889:

Line 886: hr_utility.trace('lv_value_type ' || lv_value_type);

882: lv_value := fnd_number.number_to_canonical(lv_value);
883: end if;
884: hr_utility.trace('lv_value ' || lv_value);
885: hr_utility.trace('lv_name ' || lv_info_type);
886: hr_utility.trace('lv_value_type ' || lv_value_type);
887:
888: ln_index := pay_emp_action_arch.lrr_act_tab.count;
889:
890: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category

Line 915: hr_utility.set_location(gv_package || lv_procedure_name, 60);

911: end if;
912: close c_element_details;
913:
914: elsif lv_info_type = 'BALANCE' then
915: hr_utility.set_location(gv_package || lv_procedure_name, 60);
916: open c_defined_balance_id(ln_balance_type_id
917: ,ln_balance_dimension_id);
918: fetch c_defined_balance_id into ln_defined_balance_id,
919: lv_name,

Line 922: hr_utility.trace('lv_name ' || lv_info_type);

918: fetch c_defined_balance_id into ln_defined_balance_id,
919: lv_name,
920: lv_value_type,
921: lv_uom;
922: hr_utility.trace('lv_name ' || lv_info_type);
923: hr_utility.trace('lv_value_type ' || lv_value_type);
924: hr_utility.trace('ln_defined_balance_id ' || ln_defined_balance_id);
925:
926: if c_defined_balance_id%found then

Line 923: hr_utility.trace('lv_value_type ' || lv_value_type);

919: lv_name,
920: lv_value_type,
921: lv_uom;
922: hr_utility.trace('lv_name ' || lv_info_type);
923: hr_utility.trace('lv_value_type ' || lv_value_type);
924: hr_utility.trace('ln_defined_balance_id ' || ln_defined_balance_id);
925:
926: if c_defined_balance_id%found then
927:

Line 924: hr_utility.trace('ln_defined_balance_id ' || ln_defined_balance_id);

920: lv_value_type,
921: lv_uom;
922: hr_utility.trace('lv_name ' || lv_info_type);
923: hr_utility.trace('lv_value_type ' || lv_value_type);
924: hr_utility.trace('ln_defined_balance_id ' || ln_defined_balance_id);
925:
926: if c_defined_balance_id%found then
927:
928: if p_ppp_source_action_id is not null then

Line 938: hr_utility.trace('p_ppp_source_action_id '||

934: ln_run_action_id := nvl(p_ytd_balcall_aaid,p_run_action_id);
935: end if;
936: end if;
937:
938: hr_utility.trace('p_ppp_source_action_id '||
939: p_ppp_source_action_id);
940: hr_utility.trace('ln_run_action_id '|| ln_run_action_id);
941:
942: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

Line 940: hr_utility.trace('ln_run_action_id '|| ln_run_action_id);

936: end if;
937:
938: hr_utility.trace('p_ppp_source_action_id '||
939: p_ppp_source_action_id);
940: hr_utility.trace('ln_run_action_id '|| ln_run_action_id);
941:
942: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
943: lv_value := nvl(pay_balance_pkg.get_value(ln_defined_balance_id,
944: ln_run_action_id),0);

Line 946: hr_utility.set_location(gv_package || lv_procedure_name, 110);

942: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
943: lv_value := nvl(pay_balance_pkg.get_value(ln_defined_balance_id,
944: ln_run_action_id),0);
945: if lv_value <> 0 then
946: hr_utility.set_location(gv_package || lv_procedure_name, 110);
947: ln_index := pay_emp_action_arch.lrr_act_tab.count;
948:
949: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
950: := 'EMPLOYEE OTHER INFORMATION';

Line 976: hr_utility.trace('ln_index in get_employee_other_info proc is '

972: close c_defined_balance_id;
973:
974: end if;
975:
976: hr_utility.trace('ln_index in get_employee_other_info proc is '
977: || pay_emp_action_arch.lrr_act_tab.count);
978: hr_utility.trace('lv_info_type is'||lv_info_type);
979:
980: end loop;

Line 978: hr_utility.trace('lv_info_type is'||lv_info_type);

974: end if;
975:
976: hr_utility.trace('ln_index in get_employee_other_info proc is '
977: || pay_emp_action_arch.lrr_act_tab.count);
978: hr_utility.trace('lv_info_type is'||lv_info_type);
979:
980: end loop;
981: close c_organization_info;
982:

Line 986: hr_utility.trace('Opened for Business Group:Payslip Info');

982:
983: if lv_organization_fetch = 'N' then
984: open c_organization_info(p_business_group_id,
985: 'Business Group:Payslip Info');
986: hr_utility.trace('Opened for Business Group:Payslip Info');
987: loop
988: fetch c_organization_info into lv_info_type
989: ,ln_element_type_id
990: ,ln_input_value_id

Line 999: hr_utility.set_location(gv_package || lv_procedure_name, 140);

995:
996: if c_organization_info%notfound then
997: exit;
998: end if;
999: hr_utility.set_location(gv_package || lv_procedure_name, 140);
1000: hr_utility.trace('lv_info_type ' || lv_info_type);
1001: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
1002: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
1003: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);

Line 1000: hr_utility.trace('lv_info_type ' || lv_info_type);

996: if c_organization_info%notfound then
997: exit;
998: end if;
999: hr_utility.set_location(gv_package || lv_procedure_name, 140);
1000: hr_utility.trace('lv_info_type ' || lv_info_type);
1001: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
1002: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
1003: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
1004: hr_utility.trace('ln_balance_dimension_id' || ln_balance_dimension_id);

Line 1001: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);

997: exit;
998: end if;
999: hr_utility.set_location(gv_package || lv_procedure_name, 140);
1000: hr_utility.trace('lv_info_type ' || lv_info_type);
1001: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
1002: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
1003: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
1004: hr_utility.trace('ln_balance_dimension_id' || ln_balance_dimension_id);
1005: hr_utility.trace('lv_message ' || lv_message);

Line 1002: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);

998: end if;
999: hr_utility.set_location(gv_package || lv_procedure_name, 140);
1000: hr_utility.trace('lv_info_type ' || lv_info_type);
1001: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
1002: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
1003: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
1004: hr_utility.trace('ln_balance_dimension_id' || ln_balance_dimension_id);
1005: hr_utility.trace('lv_message ' || lv_message);
1006: hr_utility.trace('lv_display_name ' || lv_display_name);

Line 1003: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);

999: hr_utility.set_location(gv_package || lv_procedure_name, 140);
1000: hr_utility.trace('lv_info_type ' || lv_info_type);
1001: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
1002: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
1003: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
1004: hr_utility.trace('ln_balance_dimension_id' || ln_balance_dimension_id);
1005: hr_utility.trace('lv_message ' || lv_message);
1006: hr_utility.trace('lv_display_name ' || lv_display_name);
1007:

Line 1004: hr_utility.trace('ln_balance_dimension_id' || ln_balance_dimension_id);

1000: hr_utility.trace('lv_info_type ' || lv_info_type);
1001: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
1002: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
1003: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
1004: hr_utility.trace('ln_balance_dimension_id' || ln_balance_dimension_id);
1005: hr_utility.trace('lv_message ' || lv_message);
1006: hr_utility.trace('lv_display_name ' || lv_display_name);
1007:
1008: if lv_info_type ='ELEMENT' then

Line 1005: hr_utility.trace('lv_message ' || lv_message);

1001: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
1002: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
1003: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
1004: hr_utility.trace('ln_balance_dimension_id' || ln_balance_dimension_id);
1005: hr_utility.trace('lv_message ' || lv_message);
1006: hr_utility.trace('lv_display_name ' || lv_display_name);
1007:
1008: if lv_info_type ='ELEMENT' then
1009: open c_element_details(ln_element_type_id

Line 1006: hr_utility.trace('lv_display_name ' || lv_display_name);

1002: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
1003: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
1004: hr_utility.trace('ln_balance_dimension_id' || ln_balance_dimension_id);
1005: hr_utility.trace('lv_message ' || lv_message);
1006: hr_utility.trace('lv_display_name ' || lv_display_name);
1007:
1008: if lv_info_type ='ELEMENT' then
1009: open c_element_details(ln_element_type_id
1010: ,ln_input_value_id

Line 1020: hr_utility.trace('lv_uom ' || lv_uom);

1016: lv_uom;
1017: --if c_element_details%notfound then
1018: if c_element_details%found then
1019:
1020: hr_utility.trace('lv_uom ' || lv_uom);
1021: if lv_uom in ('M', 'N', 'I') then
1022: lv_value := fnd_number.number_to_canonical(lv_value);
1023: end if;
1024:

Line 1026: hr_utility.trace('lv_name ' || lv_info_type);

1022: lv_value := fnd_number.number_to_canonical(lv_value);
1023: end if;
1024:
1025: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1026: hr_utility.trace('lv_name ' || lv_info_type);
1027: hr_utility.trace('lv_value ' || lv_value);
1028: hr_utility.trace('lv_value_type ' || lv_value_type);
1029:
1030: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category

Line 1027: hr_utility.trace('lv_value ' || lv_value);

1023: end if;
1024:
1025: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1026: hr_utility.trace('lv_name ' || lv_info_type);
1027: hr_utility.trace('lv_value ' || lv_value);
1028: hr_utility.trace('lv_value_type ' || lv_value_type);
1029:
1030: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1031: := 'EMPLOYEE OTHER INFORMATION';

Line 1028: hr_utility.trace('lv_value_type ' || lv_value_type);

1024:
1025: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1026: hr_utility.trace('lv_name ' || lv_info_type);
1027: hr_utility.trace('lv_value ' || lv_value);
1028: hr_utility.trace('lv_value_type ' || lv_value_type);
1029:
1030: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1031: := 'EMPLOYEE OTHER INFORMATION';
1032: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code

Line 1054: hr_utility.set_location(gv_package || lv_procedure_name, 210);

1050: := lv_uom;
1051: end if;
1052: close c_element_details;
1053: elsif lv_info_type = 'BALANCE' then
1054: hr_utility.set_location(gv_package || lv_procedure_name, 210);
1055:
1056: open c_defined_balance_id(ln_balance_type_id
1057: ,ln_balance_dimension_id);
1058:

Line 1059: hr_utility.set_location(gv_package || lv_procedure_name, 220);

1055:
1056: open c_defined_balance_id(ln_balance_type_id
1057: ,ln_balance_dimension_id);
1058:
1059: hr_utility.set_location(gv_package || lv_procedure_name, 220);
1060: fetch c_defined_balance_id into ln_defined_balance_id,
1061: lv_name,
1062: lv_value_type,
1063: lv_uom;

Line 1064: hr_utility.trace('ln_balance_type_id' || ln_balance_type_id);

1060: fetch c_defined_balance_id into ln_defined_balance_id,
1061: lv_name,
1062: lv_value_type,
1063: lv_uom;
1064: hr_utility.trace('ln_balance_type_id' || ln_balance_type_id);
1065: hr_utility.trace('lv_name ' || lv_info_type);
1066: hr_utility.trace('lv_value_type ' || lv_value_type);
1067: hr_utility.trace('ln_defined_balance_id ' || ln_defined_balance_id);
1068: if c_defined_balance_id%found then

Line 1065: hr_utility.trace('lv_name ' || lv_info_type);

1061: lv_name,
1062: lv_value_type,
1063: lv_uom;
1064: hr_utility.trace('ln_balance_type_id' || ln_balance_type_id);
1065: hr_utility.trace('lv_name ' || lv_info_type);
1066: hr_utility.trace('lv_value_type ' || lv_value_type);
1067: hr_utility.trace('ln_defined_balance_id ' || ln_defined_balance_id);
1068: if c_defined_balance_id%found then
1069:

Line 1066: hr_utility.trace('lv_value_type ' || lv_value_type);

1062: lv_value_type,
1063: lv_uom;
1064: hr_utility.trace('ln_balance_type_id' || ln_balance_type_id);
1065: hr_utility.trace('lv_name ' || lv_info_type);
1066: hr_utility.trace('lv_value_type ' || lv_value_type);
1067: hr_utility.trace('ln_defined_balance_id ' || ln_defined_balance_id);
1068: if c_defined_balance_id%found then
1069:
1070: if p_ppp_source_action_id is not null then

Line 1067: hr_utility.trace('ln_defined_balance_id ' || ln_defined_balance_id);

1063: lv_uom;
1064: hr_utility.trace('ln_balance_type_id' || ln_balance_type_id);
1065: hr_utility.trace('lv_name ' || lv_info_type);
1066: hr_utility.trace('lv_value_type ' || lv_value_type);
1067: hr_utility.trace('ln_defined_balance_id ' || ln_defined_balance_id);
1068: if c_defined_balance_id%found then
1069:
1070: if p_ppp_source_action_id is not null then
1071: ln_run_action_id := p_ppp_source_action_id;

Line 1081: hr_utility.trace('p_ppp_source_action_id '||

1077: p_run_action_id);
1078: end if;
1079: end if;
1080:
1081: hr_utility.trace('p_ppp_source_action_id '||
1082: p_ppp_source_action_id);
1083: hr_utility.trace('ln_run_action_id '|| ln_run_action_id);
1084:
1085: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

Line 1083: hr_utility.trace('ln_run_action_id '|| ln_run_action_id);

1079: end if;
1080:
1081: hr_utility.trace('p_ppp_source_action_id '||
1082: p_ppp_source_action_id);
1083: hr_utility.trace('ln_run_action_id '|| ln_run_action_id);
1084:
1085: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1086:
1087: lv_value := nvl(pay_balance_pkg.get_value(ln_defined_balance_id,

Line 1143: hr_utility.trace('Entered get_employee_accruals');

1139: lv_procedure_name VARCHAR2(100);
1140:
1141: BEGIN
1142: lv_procedure_name := 'get_employee_accruals';
1143: hr_utility.trace('Entered get_employee_accruals');
1144:
1145: pay_us_emp_payslip_accrual_web.get_emp_net_accrual (
1146: p_assignment_action_id => p_run_action_id
1147: ,p_assignment_id => p_assignment_id

Line 1176: hr_utility.trace('Leaving get_employee_accruals');

1172: := pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_code;
1173: end loop;
1174: end if;
1175:
1176: hr_utility.trace('Leaving get_employee_accruals');
1177:
1178: END get_employee_accruals;
1179:
1180:

Line 1203: hr_utility.trace('Entered get_organization_name');

1199:
1200: BEGIN
1201: lv_procedure_name := 'get_organization_name';
1202: lv_exists := 'N';
1203: hr_utility.trace('Entered get_organization_name');
1204: if pay_emp_action_arch.ltr_organizations.count > 0 then
1205: for i in pay_emp_action_arch.ltr_organizations.first ..
1206: pay_emp_action_arch.ltr_organizations.last loop
1207: if pay_emp_action_arch.ltr_organizations(i).id = p_organization_id then

Line 1224: hr_utility.trace('Leaving get_organization_name');

1220: pay_emp_action_arch.ltr_organizations(ln_index).id := p_organization_id;
1221: pay_emp_action_arch.ltr_organizations(ln_index).name := lv_organization_name;
1222: end if;
1223:
1224: hr_utility.trace('Leaving get_organization_name');
1225: return(lv_organization_name);
1226: EXCEPTION
1227: when others then
1228: hr_utility.trace('Error in ' || lv_procedure_name ||

Line 1228: hr_utility.trace('Error in ' || lv_procedure_name ||

1224: hr_utility.trace('Leaving get_organization_name');
1225: return(lv_organization_name);
1226: EXCEPTION
1227: when others then
1228: hr_utility.trace('Error in ' || lv_procedure_name ||
1229: to_char(sqlcode) || '-' || sqlerrm);
1230: raise hr_utility.hr_error;
1231:
1232: END get_organization_name ;

Line 1230: raise hr_utility.hr_error;

1226: EXCEPTION
1227: when others then
1228: hr_utility.trace('Error in ' || lv_procedure_name ||
1229: to_char(sqlcode) || '-' || sqlerrm);
1230: raise hr_utility.hr_error;
1231:
1232: END get_organization_name ;
1233:
1234:

Line 1258: hr_utility.trace('Entered get_location');

1254:
1255: BEGIN
1256: lv_procedure_name := 'get_location';
1257: lv_exists := 'N';
1258: hr_utility.trace('Entered get_location');
1259:
1260: if pay_emp_action_arch.ltr_location.count > 0 then
1261: for i in pay_emp_action_arch.ltr_location.first ..
1262: pay_emp_action_arch.ltr_location.last loop

Line 1280: hr_utility.trace('Leaving get_location');

1276: pay_emp_action_arch.ltr_location(ln_index).id := p_location_id;
1277: pay_emp_action_arch.ltr_location(ln_index).name := lv_location_name;
1278: end if;
1279:
1280: hr_utility.trace('Leaving get_location');
1281:
1282: return(lv_location_name);
1283: EXCEPTION
1284: when others then

Line 1318: hr_utility.trace('Entered get_job_name');

1314:
1315: BEGIN
1316: lv_procedure_name := 'get_job_name';
1317: lv_exists := 'N';
1318: hr_utility.trace('Entered get_job_name');
1319: if pay_emp_action_arch.ltr_jobs.count > 0 then
1320: for i in pay_emp_action_arch.ltr_jobs.first ..
1321: pay_emp_action_arch.ltr_jobs.last loop
1322: if pay_emp_action_arch.ltr_jobs(i).id = p_job_id then

Line 1339: hr_utility.trace('Leaving get_job_name');

1335: pay_emp_action_arch.ltr_jobs(ln_index).id := p_job_id;
1336: pay_emp_action_arch.ltr_jobs(ln_index).name := lv_job_name;
1337: end if;
1338:
1339: hr_utility.trace('Leaving get_job_name');
1340: return(lv_job_name);
1341:
1342: END get_job_name ;
1343:

Line 1371: hr_utility.trace('Entered get_position');

1367:
1368: BEGIN
1369: lv_procedure_name := 'get_position';
1370: lv_exists := 'N';
1371: hr_utility.trace('Entered get_position');
1372: if pay_emp_action_arch.ltr_positions.count > 0 then
1373: for i in pay_emp_action_arch.ltr_positions.first ..
1374: pay_emp_action_arch.ltr_positions.last loop
1375: if pay_emp_action_arch.ltr_positions(i).id = p_position_id then

Line 1392: hr_utility.trace('Leaving get_position');

1388: pay_emp_action_arch.ltr_positions(ln_index).id := p_position_id;
1389: pay_emp_action_arch.ltr_positions(ln_index).name := lv_position_name;
1390: end if;
1391:
1392: hr_utility.trace('Leaving get_position');
1393:
1394: return(lv_position_name);
1395:
1396: END get_position ;

Line 1427: hr_utility.trace('Entered get_pay_basis');

1423:
1424: BEGIN
1425: lv_procedure_name := 'get_pay_basis';
1426: lv_exists := 'N';
1427: hr_utility.trace('Entered get_pay_basis');
1428: if pay_emp_action_arch.ltr_pay_basis.count > 0 then
1429: for i in pay_emp_action_arch.ltr_pay_basis.first ..
1430: pay_emp_action_arch.ltr_pay_basis.last loop
1431: if pay_emp_action_arch.ltr_pay_basis(i).id = p_pay_basis_id then

Line 1448: hr_utility.trace('Leaving get_pay_basis');

1444: pay_emp_action_arch.ltr_pay_basis(ln_index).id := p_pay_basis_id;
1445: pay_emp_action_arch.ltr_pay_basis(ln_index).name := lv_pay_basis;
1446: end if;
1447:
1448: hr_utility.trace('Leaving get_pay_basis');
1449:
1450: return(lv_pay_basis);
1451:
1452: END get_pay_basis ;

Line 1480: hr_utility.trace('Entered get_frequency');

1476: lv_procedure_name VARCHAR2(100);
1477:
1478: BEGIN
1479: lv_procedure_name := 'get_frequency';
1480: hr_utility.trace('Entered get_frequency');
1481: open c_get_asg_frequency(p_frequency, p_effective_date);
1482: fetch c_get_asg_frequency into lv_frequency_desc;
1483: close c_get_asg_frequency;
1484:

Line 1485: hr_utility.trace('Leaving get_frequency');

1481: open c_get_asg_frequency(p_frequency, p_effective_date);
1482: fetch c_get_asg_frequency into lv_frequency_desc;
1483: close c_get_asg_frequency;
1484:
1485: hr_utility.trace('Leaving get_frequency');
1486: return(lv_frequency_desc);
1487:
1488: END get_frequency ;
1489:

Line 1518: hr_utility.trace('Entered get_grades');

1514:
1515: BEGIN
1516: lv_procedure_name := 'get_grade';
1517: lv_exists := 'N';
1518: hr_utility.trace('Entered get_grades');
1519: if pay_emp_action_arch.ltr_grades.count > 0 then
1520: for i in pay_emp_action_arch.ltr_grades.first ..
1521: pay_emp_action_arch.ltr_grades.last loop
1522: if pay_emp_action_arch.ltr_grades(i).id = p_grade_id then

Line 1569: hr_utility.trace('Entered get_bargaining_unit');

1565: lv_procedure_name VARCHAR2(100);
1566:
1567: BEGIN
1568: lv_procedure_name := 'get_bargaining_unit';
1569: hr_utility.trace('Entered get_bargaining_unit');
1570: open c_get_bargaining_unit(p_bargaining_unit, p_effective_date);
1571: fetch c_get_bargaining_unit into lv_bargaining_unit;
1572: close c_get_bargaining_unit;
1573:

Line 1574: hr_utility.trace('Leaving get_bargaining_unit');

1570: open c_get_bargaining_unit(p_bargaining_unit, p_effective_date);
1571: fetch c_get_bargaining_unit into lv_bargaining_unit;
1572: close c_get_bargaining_unit;
1573:
1574: hr_utility.trace('Leaving get_bargaining_unit');
1575: return(lv_bargaining_unit);
1576:
1577: END get_bargaining_unit ;
1578:

Line 1605: hr_utility.trace('Entered get_collective_agreement');

1601: lv_procedure_name VARCHAR2(100);
1602:
1603: BEGIN
1604: lv_procedure_name := 'get_collective_agreement';
1605: hr_utility.trace('Entered get_collective_agreement');
1606: open c_get_collective_agreement(p_collective_agreement_id
1607: ,p_effective_date);
1608: fetch c_get_collective_agreement into lv_collective_agreement;
1609: close c_get_collective_agreement;

Line 1610: hr_utility.trace('Leaving get_collective_agreement');

1606: open c_get_collective_agreement(p_collective_agreement_id
1607: ,p_effective_date);
1608: fetch c_get_collective_agreement into lv_collective_agreement;
1609: close c_get_collective_agreement;
1610: hr_utility.trace('Leaving get_collective_agreement');
1611: return(lv_collective_agreement);
1612:
1613: END get_collective_agreement ;
1614:

Line 1639: hr_utility.trace('Entered get_contract');

1635: lv_procedure_name VARCHAR2(100);
1636:
1637: BEGIN
1638: lv_procedure_name := 'get_contract';
1639: hr_utility.trace('Entered get_contract');
1640: open c_get_contract(p_contract_id, p_effective_date);
1641: fetch c_get_contract into lv_contract;
1642: close c_get_contract;
1643:

Line 1644: hr_utility.trace('Leaving get_contract');

1640: open c_get_contract(p_contract_id, p_effective_date);
1641: fetch c_get_contract into lv_contract;
1642: close c_get_contract;
1643:
1644: hr_utility.trace('Leaving get_contract');
1645: return(lv_contract);
1646: END get_contract ;
1647:
1648:

Line 1676: hr_utility.trace('Entered get_hourly_salaried_code');

1672: lv_procedure_name VARCHAR2(100);
1673:
1674: BEGIN
1675: lv_procedure_name := 'get_hourly_salaried_code';
1676: hr_utility.trace('Entered get_hourly_salaried_code');
1677: open c_get_hourly_salaried_code(p_hourly_salaried_code
1678: ,p_effective_date);
1679: fetch c_get_hourly_salaried_code into lv_hourly_salaried_desc;
1680: close c_get_hourly_salaried_code;

Line 1682: hr_utility.trace('Leaving get_hourly_salaried_code');

1678: ,p_effective_date);
1679: fetch c_get_hourly_salaried_code into lv_hourly_salaried_desc;
1680: close c_get_hourly_salaried_code;
1681:
1682: hr_utility.trace('Leaving get_hourly_salaried_code');
1683: return(lv_hourly_salaried_desc);
1684:
1685: END get_hourly_salaried_code ;
1686:

Line 1711: hr_utility.trace('Entered get_shift');

1707: lv_procedure_name VARCHAR2(100);
1708:
1709: BEGIN
1710: lv_procedure_name := 'get_shift';
1711: hr_utility.trace('Entered get_shift');
1712: open c_get_shift(p_soft_coding_keyflex_id, p_effective_date);
1713: fetch c_get_shift into lv_shift_code;
1714: close c_get_shift;
1715:

Line 1716: hr_utility.trace('shift_code = ' || lv_shift_code);

1712: open c_get_shift(p_soft_coding_keyflex_id, p_effective_date);
1713: fetch c_get_shift into lv_shift_code;
1714: close c_get_shift;
1715:
1716: hr_utility.trace('shift_code = ' || lv_shift_code);
1717: /* check this one out as it is legislation specific
1718: select hl.meaning
1719: into lv_shift_desc
1720: from hr_lookups hl

Line 1730: hr_utility.trace('Leaving get_shift');

1726: nvl(hl.start_date_active,p_curr_eff_date)
1727: and nvl(hl.end_date_active,p_curr_eff_date)
1728: order by meaning;
1729: */
1730: hr_utility.trace('Leaving get_shift');
1731: return(lv_shift_desc);
1732:
1733: END get_shift ;
1734:

Line 1793: hr_utility.trace('ln_index in get_employee_addr proc is '

1789: close c_addr_line;
1790:
1791: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1792:
1793: hr_utility.trace('ln_index in get_employee_addr proc is '
1794: || pay_emp_action_arch.lrr_act_tab.count);
1795: hr_utility.trace('person_id is'||p_person_id);
1796:
1797: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category

Line 1795: hr_utility.trace('person_id is'||p_person_id);

1791: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1792:
1793: hr_utility.trace('ln_index in get_employee_addr proc is '
1794: || pay_emp_action_arch.lrr_act_tab.count);
1795: hr_utility.trace('person_id is'||p_person_id);
1796:
1797: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1798: := 'ADDRESS DETAILS';
1799: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code

Line 1823: hr_utility.trace('Leaving get_employee_addr');

1819: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1820: := lv_ee_country;
1821: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1822: := lv_ee_or_er;
1823: hr_utility.trace('Leaving get_employee_addr');
1824: END get_employee_addr;
1825:
1826:
1827: /******************************************************************

Line 1936: hr_utility.trace('Opened cursor get_net_pay_distribution ');

1932: open c_net_pay(p_pre_pay_action_id
1933: ,p_assignment_id
1934: ,p_curr_pymt_eff_date
1935: ,p_ppp_source_action_id);
1936: hr_utility.trace('Opened cursor get_net_pay_distribution ');
1937:
1938: loop
1939: fetch c_net_pay into lv_segment1
1940: ,lv_segment2

Line 1954: hr_utility.trace('Fetched get_net_pay_distribution ');

1950: ,ln_pre_payment_id
1951: ,ln_org_payment_method_id
1952: ,lv_org_payment_method_name
1953: ,ln_emp_payment_method_id;
1954: hr_utility.trace('Fetched get_net_pay_distribution ');
1955: if c_net_pay%notfound then
1956: exit;
1957: end if;
1958:

Line 1961: hr_utility.trace('ln_index in get_net_pay_dist proc is '

1957: end if;
1958:
1959: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1960:
1961: hr_utility.trace('ln_index in get_net_pay_dist proc is '
1962: || pay_emp_action_arch.lrr_act_tab.count);
1963:
1964: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1965: := 'EMPLOYEE NET PAY DISTRIBUTION';

Line 2004: hr_utility.set_location(gv_package || lv_procedure_name,100);

2000: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
2001: := lv_org_payment_method_name;
2002: end loop;
2003: close c_net_pay;
2004: hr_utility.set_location(gv_package || lv_procedure_name,100);
2005: END get_net_pay_distribution;
2006:
2007: /******************************************************************
2008: Name : get_tp_pay_distribution

Line 2124: hr_utility.set_location(gv_package || lv_procedure_name,10);

2120: lv_procedure_name VARCHAR2(100);
2121:
2122: BEGIN
2123: lv_procedure_name := 'get_3rdparty_pay_distribution';
2124: hr_utility.set_location(gv_package || lv_procedure_name,10);
2125: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
2126: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2127: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
2128: k := 0;

Line 2125: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);

2121:
2122: BEGIN
2123: lv_procedure_name := 'get_3rdparty_pay_distribution';
2124: hr_utility.set_location(gv_package || lv_procedure_name,10);
2125: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
2126: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2127: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
2128: k := 0;
2129:

Line 2126: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);

2122: BEGIN
2123: lv_procedure_name := 'get_3rdparty_pay_distribution';
2124: hr_utility.set_location(gv_package || lv_procedure_name,10);
2125: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
2126: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2127: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
2128: k := 0;
2129:
2130: -- Check if Multi assignment payment is enabled

Line 2127: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);

2123: lv_procedure_name := 'get_3rdparty_pay_distribution';
2124: hr_utility.set_location(gv_package || lv_procedure_name,10);
2125: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
2126: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2127: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
2128: k := 0;
2129:
2130: -- Check if Multi assignment payment is enabled
2131: if pay_emp_action_arch.gv_multi_payroll_pymt is null then

Line 2137: hr_utility.set_location(gv_package || lv_procedure_name,20);

2133: := pay_emp_action_arch.get_multi_assignment_flag(
2134: p_payroll_id => p_payroll_id
2135: ,p_effective_date => p_curr_pymt_eff_date);
2136: end if;
2137: hr_utility.set_location(gv_package || lv_procedure_name,20);
2138:
2139: if nvl(pay_emp_action_arch.gv_multi_payroll_pymt, 'N') = 'Y' then
2140: -- If Multi Assignment Payment is enabled, get the child prepayment
2141: -- actions as payment information is stored against child.

Line 2147: hr_utility.set_location(gv_package || lv_procedure_name,30);

2143: for cval in c_child_action(p_pre_pay_action_id, p_assignment_id) loop
2144: ltt_actions(k) := cval.assignment_action_id;
2145: k := k + 1;
2146: end loop;
2147: hr_utility.set_location(gv_package || lv_procedure_name,30);
2148: else
2149: ltt_actions(k) := p_pre_pay_action_id;
2150: k := k + 1;
2151: hr_utility.set_location(gv_package || lv_procedure_name,40);

Line 2151: hr_utility.set_location(gv_package || lv_procedure_name,40);

2147: hr_utility.set_location(gv_package || lv_procedure_name,30);
2148: else
2149: ltt_actions(k) := p_pre_pay_action_id;
2150: k := k + 1;
2151: hr_utility.set_location(gv_package || lv_procedure_name,40);
2152: end if;
2153:
2154: -- Value of k will be zero only if the payroll is enabled for multi
2155: -- assignment payments and we are processing seperate check action.

Line 2162: hr_utility.trace('assignment action = ' || ltt_actions(j));

2158: ltt_actions(k) := p_pre_pay_action_id;
2159: end if;
2160:
2161: for j in ltt_actions.first .. ltt_actions.last loop
2162: hr_utility.trace('assignment action = ' || ltt_actions(j));
2163: end loop;
2164:
2165: for j in ltt_actions.first .. ltt_actions.last loop
2166: open c_third_party_pay(ltt_actions(j)

Line 2187: hr_utility.trace('Fetched get_3rdparty_pay_distribution ');

2183: ,ln_pre_payment_id
2184: ,ln_org_payment_method_id
2185: ,lv_org_payment_method_name
2186: ,ln_emp_payment_method_id;
2187: hr_utility.trace('Fetched get_3rdparty_pay_distribution ');
2188: if c_third_party_pay%notfound then
2189: exit;
2190: end if;
2191:

Line 2194: hr_utility.trace('ln_index in get_3rdparty_pay_distribution proc is '

2190: end if;
2191:
2192: ln_index := pay_emp_action_arch.lrr_act_tab.count;
2193:
2194: hr_utility.trace('ln_index in get_3rdparty_pay_distribution proc is '
2195: || pay_emp_action_arch.lrr_act_tab.count);
2196:
2197: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2198: := 'EMPLOYEE THIRD PARTY PAYMENTS';

Line 2203: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);

2199: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2200: := '00-000-0000';
2201: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2202: := ln_org_payment_method_id;
2203: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);
2204: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
2205: := ln_emp_payment_method_id;
2206: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
2207: := null;

Line 2239: hr_utility.set_location(gv_package || lv_procedure_name,100);

2235: := lv_org_payment_method_name;
2236: end loop;
2237: close c_third_party_pay;
2238: end loop;
2239: hr_utility.set_location(gv_package || lv_procedure_name,100);
2240:
2241: END get_3rdparty_pay_distribution;
2242:
2243:

Line 2281: hr_utility.set_location(gv_package || lv_procedure_name, 20);

2277: if p_organization_id is not null then
2278: open c_get_other_info(p_organization_id
2279: ,'Organization:Payslip Info') ;
2280: loop
2281: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2282: fetch c_get_other_info into lv_org_information1
2283: ,lv_org_information2
2284: ,lv_org_information3
2285: ,lv_org_information4

Line 2291: hr_utility.set_location(gv_package || lv_procedure_name, 30);

2287: ,lv_org_information6
2288: ,lv_org_information7
2289: ,lv_org_information_cntxt;
2290: if c_get_other_info%notfound then
2291: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2292: exit;
2293: end if;
2294:
2295:

Line 2296: hr_utility.set_location(gv_package || lv_procedure_name, 40);

2292: exit;
2293: end if;
2294:
2295:
2296: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2297: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2298: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2299: pay_emp_action_arch.ltr_ppa_arch.last loop
2300: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1

Line 2335: hr_utility.set_location(gv_package || lv_procedure_name, 100);

2331: end loop ;
2332: close c_get_other_info;
2333: end if;
2334:
2335: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2336: if p_business_group_id is not null then
2337: open c_get_other_info(p_business_group_id
2338: ,'Business Group:Payslip Info') ;
2339: loop

Line 2340: hr_utility.set_location(gv_package || lv_procedure_name, 110);

2336: if p_business_group_id is not null then
2337: open c_get_other_info(p_business_group_id
2338: ,'Business Group:Payslip Info') ;
2339: loop
2340: hr_utility.set_location(gv_package || lv_procedure_name, 110);
2341: fetch c_get_other_info into lv_org_information1
2342: ,lv_org_information2
2343: ,lv_org_information3
2344: ,lv_org_information4

Line 2350: hr_utility.set_location(gv_package || lv_procedure_name, 120);

2346: ,lv_org_information6
2347: ,lv_org_information7
2348: ,lv_org_information_cntxt; ----Bug 7115367
2349: if c_get_other_info%notfound then
2350: hr_utility.set_location(gv_package || lv_procedure_name, 120);
2351: exit;
2352: end if;
2353:
2354: hr_utility.set_location(gv_package || lv_procedure_name, 130);

Line 2354: hr_utility.set_location(gv_package || lv_procedure_name, 130);

2350: hr_utility.set_location(gv_package || lv_procedure_name, 120);
2351: exit;
2352: end if;
2353:
2354: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2355: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2356: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2357: pay_emp_action_arch.ltr_ppa_arch.last loop
2358: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1

Line 2392: hr_utility.set_location(gv_package || lv_procedure_name, 140);

2388: end if;
2389: end loop ;
2390: close c_get_other_info;
2391: end if;
2392: hr_utility.set_location(gv_package || lv_procedure_name, 140);
2393:
2394: END get_org_other_info;
2395:
2396:

Line 2431: hr_utility.set_location(gv_package || lv_procedure_name, 210);

2427: lv_procedure_name := '.get_org_address';
2428: lv_ee_or_er := 'Employer Address';
2429: lv_exists := 'N';
2430: -- Get Employer address
2431: hr_utility.set_location(gv_package || lv_procedure_name, 210);
2432: if p_organization_id is null then
2433: return;
2434: end if;
2435: open c_addr_line(p_organization_id);

Line 2447: hr_utility.set_location(gv_package || lv_procedure_name, 250);

2443: ,lv_er_postal_code
2444: ,lv_er_country
2445: ,lv_er_telephone;
2446: close c_addr_line;
2447: hr_utility.set_location(gv_package || lv_procedure_name, 250);
2448:
2449: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2450: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2451: pay_emp_action_arch.ltr_ppa_arch.last loop

Line 2463: hr_utility.set_location(gv_package || lv_procedure_name, 260);

2459: end loop;
2460: end if;
2461:
2462: if lv_exists = 'N' then
2463: hr_utility.set_location(gv_package || lv_procedure_name, 260);
2464: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2465:
2466: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2467: := 'ADDRESS DETAILS';

Line 2531: hr_utility.set_location(gv_package || lv_procedure_name, 10);

2527: and paf.effective_end_date;
2528:
2529: BEGIN
2530: lv_procedure_name := '.arch_pay_action_level_data';
2531: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2532: open c_get_organization(p_payroll_id, p_effective_date);
2533: loop
2534: fetch c_get_organization into ln_organization_id,
2535: ln_business_group_id;

Line 2546: hr_utility.set_location(gv_package || lv_procedure_name, 140);

2542:
2543: end loop;
2544: close c_get_organization;
2545:
2546: hr_utility.set_location(gv_package || lv_procedure_name, 140);
2547:
2548: -- insert rows in pay_action_information table
2549: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2550: insert_rows_thro_api_process(

Line 2561: hr_utility.trace('Error in ' || gv_package || '.' || lv_procedure_name || '-'

2557: );
2558: end if;
2559: EXCEPTION
2560: when others then
2561: hr_utility.trace('Error in ' || gv_package || '.' || lv_procedure_name || '-'
2562: || to_char(sqlcode) || '-' || sqlerrm);
2563: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2564: raise hr_utility.hr_error;
2565:

Line 2563: hr_utility.set_location(gv_package || lv_procedure_name, 130);

2559: EXCEPTION
2560: when others then
2561: hr_utility.trace('Error in ' || gv_package || '.' || lv_procedure_name || '-'
2562: || to_char(sqlcode) || '-' || sqlerrm);
2563: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2564: raise hr_utility.hr_error;
2565:
2566: END arch_pay_action_level_data;
2567:

Line 2564: raise hr_utility.hr_error;

2560: when others then
2561: hr_utility.trace('Error in ' || gv_package || '.' || lv_procedure_name || '-'
2562: || to_char(sqlcode) || '-' || sqlerrm);
2563: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2564: raise hr_utility.hr_error;
2565:
2566: END arch_pay_action_level_data;
2567:
2568:

Line 2623: hr_utility.set_location(gv_package || lv_procedure_name, 1);

2619: lv_procedure_name VARCHAR2(100);
2620:
2621: BEGIN
2622: lv_procedure_name := '.arch_pay_action_level_data_deinit';
2623: hr_utility.set_location(gv_package || lv_procedure_name, 1);
2624:
2625: delete from pay_action_information pai
2626: where pai.action_context_id = p_payroll_action_id
2627: and pai.action_context_type = 'PA'

Line 2642: hr_utility.set_location(gv_package || lv_procedure_name, 5);

2638: /* Archive Business Group Address and Address */
2639: get_org_other_info(null, ln_business_group_id);
2640: get_org_address(ln_business_group_id);
2641:
2642: hr_utility.set_location(gv_package || lv_procedure_name, 5);
2643: /* Get all the Organization ID and Tax Unit ID for assignment
2644: archived by the archiver. For the ORganizations get any
2645: message which needs to be archived and also archive the
2646: address information */

Line 2654: hr_utility.trace('Organization ID = ' || ln_organization_id);

2650: if c_employer_info%notfound then
2651: exit;
2652: end if;
2653:
2654: hr_utility.trace('Organization ID = ' || ln_organization_id);
2655: hr_utility.trace('Tax Unit ID = ' || ln_tax_unit_id);
2656: /* Archive Organization Message */
2657: get_org_other_info(ln_organization_id, null);
2658: get_org_address(ln_organization_id);

Line 2655: hr_utility.trace('Tax Unit ID = ' || ln_tax_unit_id);

2651: exit;
2652: end if;
2653:
2654: hr_utility.trace('Organization ID = ' || ln_organization_id);
2655: hr_utility.trace('Tax Unit ID = ' || ln_tax_unit_id);
2656: /* Archive Organization Message */
2657: get_org_other_info(ln_organization_id, null);
2658: get_org_address(ln_organization_id);
2659: if ln_organization_id <> ln_tax_unit_id and ln_tax_unit_id <> -1 then

Line 2666: hr_utility.set_location(gv_package || lv_procedure_name, 100);

2662:
2663: end loop;
2664: close c_employer_info;
2665:
2666: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2667:
2668: -- insert rows in pay_action_information table
2669: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2670: insert_rows_thro_api_process(

Line 2679: hr_utility.set_location(gv_package || lv_procedure_name, 150);

2675: ,p_curr_pymt_eff_date => p_effective_date
2676: ,p_tab_rec_data => pay_emp_action_arch.ltr_ppa_arch
2677: );
2678: end if;
2679: hr_utility.set_location(gv_package || lv_procedure_name, 150);
2680:
2681: EXCEPTION
2682: when others then
2683: hr_utility.trace('Error in ' || gv_package || '.' || lv_procedure_name || '-'

Line 2683: hr_utility.trace('Error in ' || gv_package || '.' || lv_procedure_name || '-'

2679: hr_utility.set_location(gv_package || lv_procedure_name, 150);
2680:
2681: EXCEPTION
2682: when others then
2683: hr_utility.trace('Error in ' || gv_package || '.' || lv_procedure_name || '-'
2684: || to_char(sqlcode) || '-' || sqlerrm);
2685: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2686: raise hr_utility.hr_error;
2687:

Line 2685: hr_utility.set_location(gv_package || lv_procedure_name, 130);

2681: EXCEPTION
2682: when others then
2683: hr_utility.trace('Error in ' || gv_package || '.' || lv_procedure_name || '-'
2684: || to_char(sqlcode) || '-' || sqlerrm);
2685: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2686: raise hr_utility.hr_error;
2687:
2688: END arch_pay_action_level_data;
2689:

Line 2686: raise hr_utility.hr_error;

2682: when others then
2683: hr_utility.trace('Error in ' || gv_package || '.' || lv_procedure_name || '-'
2684: || to_char(sqlcode) || '-' || sqlerrm);
2685: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2686: raise hr_utility.hr_error;
2687:
2688: END arch_pay_action_level_data;
2689:
2690:

Line 2845: hr_utility.trace('Entered get_personal_information');

2841:
2842: BEGIN
2843: lv_procedure_name := 'get_personal_information';
2844: lv_exists := 'N';
2845: hr_utility.trace('Entered get_personal_information');
2846: initialization_process;
2847:
2848: hr_utility.trace('p_assactid = ' || p_assactid);
2849: hr_utility.trace('p_assignment_id = ' || p_assignment_id);

Line 2848: hr_utility.trace('p_assactid = ' || p_assactid);

2844: lv_exists := 'N';
2845: hr_utility.trace('Entered get_personal_information');
2846: initialization_process;
2847:
2848: hr_utility.trace('p_assactid = ' || p_assactid);
2849: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
2850: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
2851: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);
2852: hr_utility.trace('p_date_earned = ' || p_date_earned);

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

2845: hr_utility.trace('Entered get_personal_information');
2846: initialization_process;
2847:
2848: hr_utility.trace('p_assactid = ' || p_assactid);
2849: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
2850: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
2851: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);
2852: hr_utility.trace('p_date_earned = ' || p_date_earned);
2853: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);

Line 2850: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);

2846: initialization_process;
2847:
2848: hr_utility.trace('p_assactid = ' || p_assactid);
2849: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
2850: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
2851: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);
2852: hr_utility.trace('p_date_earned = ' || p_date_earned);
2853: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2854: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);

Line 2851: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);

2847:
2848: hr_utility.trace('p_assactid = ' || p_assactid);
2849: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
2850: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
2851: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);
2852: hr_utility.trace('p_date_earned = ' || p_date_earned);
2853: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2854: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
2855: hr_utility.trace('p_time_period_id = ' || p_time_period_id);

Line 2852: hr_utility.trace('p_date_earned = ' || p_date_earned);

2848: hr_utility.trace('p_assactid = ' || p_assactid);
2849: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
2850: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
2851: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);
2852: hr_utility.trace('p_date_earned = ' || p_date_earned);
2853: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2854: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
2855: hr_utility.trace('p_time_period_id = ' || p_time_period_id);
2856: hr_utility.trace('p_run_action_id = ' || p_run_action_id);

Line 2853: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);

2849: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
2850: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
2851: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);
2852: hr_utility.trace('p_date_earned = ' || p_date_earned);
2853: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2854: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
2855: hr_utility.trace('p_time_period_id = ' || p_time_period_id);
2856: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
2857: --Bug 5585331 starts here

Line 2854: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);

2850: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
2851: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);
2852: hr_utility.trace('p_date_earned = ' || p_date_earned);
2853: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2854: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
2855: hr_utility.trace('p_time_period_id = ' || p_time_period_id);
2856: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
2857: --Bug 5585331 starts here
2858: -- open c_employee_details(p_assignment_id,p_curr_eff_date);

Line 2855: hr_utility.trace('p_time_period_id = ' || p_time_period_id);

2851: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);
2852: hr_utility.trace('p_date_earned = ' || p_date_earned);
2853: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2854: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
2855: hr_utility.trace('p_time_period_id = ' || p_time_period_id);
2856: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
2857: --Bug 5585331 starts here
2858: -- open c_employee_details(p_assignment_id,p_curr_eff_date);
2859: open c_employee_details(p_assignment_id,p_date_earned);

Line 2856: hr_utility.trace('p_run_action_id = ' || p_run_action_id);

2852: hr_utility.trace('p_date_earned = ' || p_date_earned);
2853: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2854: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
2855: hr_utility.trace('p_time_period_id = ' || p_time_period_id);
2856: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
2857: --Bug 5585331 starts here
2858: -- open c_employee_details(p_assignment_id,p_curr_eff_date);
2859: open c_employee_details(p_assignment_id,p_date_earned);
2860: --Bug 5585331 ends here

Line 2861: hr_utility.trace('Opened c_employee_details of get_personal_information ');

2857: --Bug 5585331 starts here
2858: -- open c_employee_details(p_assignment_id,p_curr_eff_date);
2859: open c_employee_details(p_assignment_id,p_date_earned);
2860: --Bug 5585331 ends here
2861: hr_utility.trace('Opened c_employee_details of get_personal_information ');
2862: fetch c_employee_details into lv_full_name,
2863: lv_national_identifier,
2864: ln_person_id,
2865: ld_date_start,

Line 2889: hr_utility.raise_error;

2885: ln_business_group_id,
2886: ln_soft_coding_keyflex_id,
2887: lv_hourly_salaried_code;
2888: if c_employee_details%notfound then
2889: hr_utility.raise_error;
2890: end if;
2891:
2892: hr_utility.trace('Opening c_period_details');
2893: open c_period_details(p_time_period_id);

Line 2892: hr_utility.trace('Opening c_period_details');

2888: if c_employee_details%notfound then
2889: hr_utility.raise_error;
2890: end if;
2891:
2892: hr_utility.trace('Opening c_period_details');
2893: open c_period_details(p_time_period_id);
2894: fetch c_period_details into ln_payroll_id,
2895: lv_period_type,
2896: ld_period_start_date,

Line 2899: hr_utility.trace('Time Period details not found for time_period_id '

2895: lv_period_type,
2896: ld_period_start_date,
2897: ld_period_end_date;
2898: if c_period_details%notfound then
2899: hr_utility.trace('Time Period details not found for time_period_id '
2900: ||to_char(p_time_period_id));
2901: --hr_utility.raise_error;
2902: end if;
2903: close c_period_details;

Line 2901: --hr_utility.raise_error;

2897: ld_period_end_date;
2898: if c_period_details%notfound then
2899: hr_utility.trace('Time Period details not found for time_period_id '
2900: ||to_char(p_time_period_id));
2901: --hr_utility.raise_error;
2902: end if;
2903: close c_period_details;
2904:
2905:

Line 2990: hr_utility.trace('ln_index in get_personal_information proc is '

2986: end if;
2987:
2988: ln_index := pay_emp_action_arch.lrr_act_tab.count;
2989:
2990: hr_utility.trace('ln_index in get_personal_information proc is '
2991: || pay_emp_action_arch.lrr_act_tab.count);
2992:
2993: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2994: := 'EMPLOYEE DETAILS';

Line 2999: hr_utility.trace('lv_full_name is'||lv_full_name);

2995: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2996: := '00-000-0000';
2997: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2998: := lv_full_name;
2999: hr_utility.trace('lv_full_name is'||lv_full_name);
3000: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
3001: := ln_organization_id;
3002:
3003: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4

Line 3006: hr_utility.trace('lv_national_identifier is'||lv_national_identifier);

3002:
3003: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
3004: := lv_national_identifier ;
3005:
3006: hr_utility.trace('lv_national_identifier is'||lv_national_identifier);
3007:
3008: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5 := lv_pay_basis;
3009:
3010: hr_utility.trace('lv_pay_basis is'||lv_pay_basis);

Line 3010: hr_utility.trace('lv_pay_basis is'||lv_pay_basis);

3006: hr_utility.trace('lv_national_identifier is'||lv_national_identifier);
3007:
3008: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5 := lv_pay_basis;
3009:
3010: hr_utility.trace('lv_pay_basis is'||lv_pay_basis);
3011:
3012: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
3013: := lv_frequency_desc;
3014:

Line 3015: hr_utility.trace('lv_frequency_desc is'||lv_frequency_desc);

3011:
3012: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
3013: := lv_frequency_desc;
3014:
3015: hr_utility.trace('lv_frequency_desc is'||lv_frequency_desc);
3016:
3017: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
3018: := lv_grade;
3019:

Line 3020: hr_utility.trace('lv_grade is'||lv_grade);

3016:
3017: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
3018: := lv_grade;
3019:
3020: hr_utility.trace('lv_grade is'||lv_grade);
3021:
3022: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
3023: := lv_bargaining_unit;
3024:

Line 3025: hr_utility.trace('lv_bargaining_unit is'||lv_bargaining_unit);

3021:
3022: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
3023: := lv_bargaining_unit;
3024:
3025: hr_utility.trace('lv_bargaining_unit is'||lv_bargaining_unit);
3026: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
3027: := lv_collective_agreement;
3028:
3029: hr_utility.trace('lv_collective_agreement is'||lv_collective_agreement);

Line 3029: hr_utility.trace('lv_collective_agreement is'||lv_collective_agreement);

3025: hr_utility.trace('lv_bargaining_unit is'||lv_bargaining_unit);
3026: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
3027: := lv_collective_agreement;
3028:
3029: hr_utility.trace('lv_collective_agreement is'||lv_collective_agreement);
3030: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
3031: := lv_employee_number ;
3032:
3033: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11

Line 3131: hr_utility.trace('Error in ' || gv_package ||

3127: gv_package := 'pay_emp_action_arch';
3128:
3129: EXCEPTION
3130: when others then
3131: hr_utility.trace('Error in ' || gv_package ||
3132: to_char(sqlcode) || '-' || sqlerrm);
3133: raise hr_utility.hr_error;
3134:
3135: END pay_emp_action_arch;

Line 3133: raise hr_utility.hr_error;

3129: EXCEPTION
3130: when others then
3131: hr_utility.trace('Error in ' || gv_package ||
3132: to_char(sqlcode) || '-' || sqlerrm);
3133: raise hr_utility.hr_error;
3134:
3135: END pay_emp_action_arch;