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 271: hr_utility.trace('opened c_get_defined_balance');

267: ln_defined_balance_id NUMBER;
268: lv_error_message VARCHAR2(200);
269:
270: BEGIN
271: hr_utility.trace('opened c_get_defined_balance');
272: open c_get_defined_balance_id(p_balance_id,
273: p_balance_dimension,
274: p_legislation_code);
275:

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

278: /*********************************************************
279: ** If defined_balance_id not found then return null.
280: ** This will happen for the Hours YTD balance
281: *********************************************************/
282: hr_utility.trace('Defined balance id not found for... ' );
283: hr_utility.trace(' p_balance_id = ' || p_balance_id);
284: hr_utility.trace(' p_balance_dimension = ' || p_balance_dimension);
285: hr_utility.trace(' p_legislation_code = ' || p_legislation_code);
286: end if;

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

279: ** If defined_balance_id not found then return null.
280: ** This will happen for the Hours YTD balance
281: *********************************************************/
282: hr_utility.trace('Defined balance id not found for... ' );
283: hr_utility.trace(' p_balance_id = ' || p_balance_id);
284: hr_utility.trace(' p_balance_dimension = ' || p_balance_dimension);
285: hr_utility.trace(' p_legislation_code = ' || p_legislation_code);
286: end if;
287: close c_get_defined_balance_id;

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

280: ** This will happen for the Hours YTD balance
281: *********************************************************/
282: hr_utility.trace('Defined balance id not found for... ' );
283: hr_utility.trace(' p_balance_id = ' || p_balance_id);
284: hr_utility.trace(' p_balance_dimension = ' || p_balance_dimension);
285: hr_utility.trace(' p_legislation_code = ' || p_legislation_code);
286: end if;
287: close c_get_defined_balance_id;
288: hr_utility.trace('ln_defined_balance_id = ' || ln_defined_balance_id);

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

281: *********************************************************/
282: hr_utility.trace('Defined balance id not found for... ' );
283: hr_utility.trace(' p_balance_id = ' || p_balance_id);
284: hr_utility.trace(' p_balance_dimension = ' || p_balance_dimension);
285: hr_utility.trace(' p_legislation_code = ' || p_legislation_code);
286: end if;
287: close c_get_defined_balance_id;
288: hr_utility.trace('ln_defined_balance_id = ' || ln_defined_balance_id);
289: return ln_defined_balance_id ;

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

284: hr_utility.trace(' p_balance_dimension = ' || p_balance_dimension);
285: hr_utility.trace(' p_legislation_code = ' || p_legislation_code);
286: end if;
287: close c_get_defined_balance_id;
288: hr_utility.trace('ln_defined_balance_id = ' || ln_defined_balance_id);
289: return ln_defined_balance_id ;
290:
291: END get_defined_balance_id;
292:

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

314: lv_procedure_name VARCHAR2(50);
315: BEGIN
316: lv_multi_leg_rule := 'N';
317: lv_procedure_name := '.get_multi_legislative_rule' ;
318: hr_utility.set_location(gv_package || lv_procedure_name, 10);
319: open c_leg_rule(p_legislation_code);
320: fetch c_leg_rule into lv_multi_leg_rule;
321: if c_leg_rule%found then
322: lv_multi_leg_rule := 'Y';

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

324: lv_multi_leg_rule := 'N';
325: end if;
326: close c_leg_rule;
327:
328: hr_utility.trace('lv_multi_leg_rule = ' || lv_multi_leg_rule);
329: hr_utility.set_location(gv_package || lv_procedure_name, 100);
330: return(lv_multi_leg_rule);
331:
332: END get_multi_legislative_rule;

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

325: end if;
326: close c_leg_rule;
327:
328: hr_utility.trace('lv_multi_leg_rule = ' || lv_multi_leg_rule);
329: hr_utility.set_location(gv_package || lv_procedure_name, 100);
330: return(lv_multi_leg_rule);
331:
332: END get_multi_legislative_rule;
333:

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

358:
359: BEGIN
360: lv_multi_asg_flag := 'N';
361: lv_procedure_name := '.get_multi_assignment_flag' ;
362: hr_utility.set_location(gv_package || lv_procedure_name, 10);
363: open c_get_payroll_info(p_payroll_id, p_effective_date);
364: fetch c_get_payroll_info into lv_multi_asg_flag;
365: if c_get_payroll_info%found then
366: lv_multi_asg_flag := 'Y';

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

367: else
368: lv_multi_asg_flag := 'N';
369: end if;
370: close c_get_payroll_info;
371: hr_utility.set_location(gv_package || lv_procedure_name, 30);
372: hr_utility.trace('lv_multi_asg_flag = ' || lv_multi_asg_flag);
373: return lv_multi_asg_flag;
374:
375: END get_multi_assignment_flag;

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

368: lv_multi_asg_flag := 'N';
369: end if;
370: close c_get_payroll_info;
371: hr_utility.set_location(gv_package || lv_procedure_name, 30);
372: hr_utility.trace('lv_multi_asg_flag = ' || lv_multi_asg_flag);
373: return lv_multi_asg_flag;
374:
375: END get_multi_assignment_flag;
376:

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

389: lv_procedure_name VARCHAR2(100);
390:
391: BEGIN
392: lv_procedure_name := '.initialization_process';
393: hr_utility.set_location(gv_package || lv_procedure_name, 10);
394:
395: if pay_emp_action_arch.lrr_act_tab.count > 0 then
396: hr_utility.set_location(gv_package || lv_procedure_name, 20);
397: for i in pay_emp_action_arch.lrr_act_tab.first ..

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

392: lv_procedure_name := '.initialization_process';
393: hr_utility.set_location(gv_package || lv_procedure_name, 10);
394:
395: if pay_emp_action_arch.lrr_act_tab.count > 0 then
396: hr_utility.set_location(gv_package || lv_procedure_name, 20);
397: for i in pay_emp_action_arch.lrr_act_tab.first ..
398: pay_emp_action_arch.lrr_act_tab.last loop
399: pay_emp_action_arch.lrr_act_tab(i).action_context_id := null;
400: pay_emp_action_arch.lrr_act_tab(i).action_context_type := null;

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

433: end loop;
434: end if;
435: pay_emp_action_arch.lrr_act_tab.delete;
436: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.delete;
437: hr_utility.set_location(gv_package || lv_procedure_name, 30);
438:
439: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
440: hr_utility.set_location(gv_package || lv_procedure_name, 40);
441: for i in pay_emp_action_arch.ltr_ppa_arch.first ..

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

436: pay_us_emp_payslip_accrual_web.ltr_assignment_accruals.delete;
437: hr_utility.set_location(gv_package || lv_procedure_name, 30);
438:
439: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
440: hr_utility.set_location(gv_package || lv_procedure_name, 40);
441: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
442: pay_emp_action_arch.ltr_ppa_arch.last loop
443: pay_emp_action_arch.ltr_ppa_arch(i).action_context_id := null;
444: pay_emp_action_arch.ltr_ppa_arch(i).action_context_type := null;

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

477: end loop;
478: end if;
479: pay_emp_action_arch.ltr_ppa_arch.delete;
480:
481: hr_utility.set_location(gv_package || lv_procedure_name, 50);
482: END initialization_process;
483:
484:
485:

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

504: lv_procedure_name VARCHAR2(100);
505:
506: BEGIN
507: lv_procedure_name := '.insert_rows_thro_api_process';
508: hr_utility.set_location(gv_package || lv_procedure_name, 10);
509:
510: if p_tab_rec_data.count > 0 then
511: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
512: hr_utility.trace('Defining category '||

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

508: hr_utility.set_location(gv_package || lv_procedure_name, 10);
509:
510: if p_tab_rec_data.count > 0 then
511: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
512: hr_utility.trace('Defining category '||
513: p_tab_rec_data(i).action_info_category);
514: hr_utility.trace('action_context_id = '|| p_action_context_id);
515: hr_utility.trace('jurisdiction_code '||
516: p_tab_rec_data(i).jurisdiction_code);

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

510: if p_tab_rec_data.count > 0 then
511: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
512: hr_utility.trace('Defining category '||
513: p_tab_rec_data(i).action_info_category);
514: hr_utility.trace('action_context_id = '|| p_action_context_id);
515: hr_utility.trace('jurisdiction_code '||
516: p_tab_rec_data(i).jurisdiction_code);
517: hr_utility.trace('act_info1 is'|| p_tab_rec_data(i).act_info1);
518: hr_utility.trace('act_info2 is'|| p_tab_rec_data(i).act_info2);

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

511: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
512: hr_utility.trace('Defining category '||
513: p_tab_rec_data(i).action_info_category);
514: hr_utility.trace('action_context_id = '|| p_action_context_id);
515: hr_utility.trace('jurisdiction_code '||
516: p_tab_rec_data(i).jurisdiction_code);
517: hr_utility.trace('act_info1 is'|| p_tab_rec_data(i).act_info1);
518: hr_utility.trace('act_info2 is'|| p_tab_rec_data(i).act_info2);
519: hr_utility.trace('act_info3 is'|| p_tab_rec_data(i).act_info3);

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

513: p_tab_rec_data(i).action_info_category);
514: hr_utility.trace('action_context_id = '|| p_action_context_id);
515: hr_utility.trace('jurisdiction_code '||
516: p_tab_rec_data(i).jurisdiction_code);
517: hr_utility.trace('act_info1 is'|| p_tab_rec_data(i).act_info1);
518: hr_utility.trace('act_info2 is'|| p_tab_rec_data(i).act_info2);
519: hr_utility.trace('act_info3 is'|| p_tab_rec_data(i).act_info3);
520: hr_utility.trace('act_info4 is'|| p_tab_rec_data(i).act_info4);
521: hr_utility.trace('act_info5 is'|| p_tab_rec_data(i).act_info5);

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

514: hr_utility.trace('action_context_id = '|| p_action_context_id);
515: hr_utility.trace('jurisdiction_code '||
516: p_tab_rec_data(i).jurisdiction_code);
517: hr_utility.trace('act_info1 is'|| p_tab_rec_data(i).act_info1);
518: hr_utility.trace('act_info2 is'|| p_tab_rec_data(i).act_info2);
519: hr_utility.trace('act_info3 is'|| p_tab_rec_data(i).act_info3);
520: hr_utility.trace('act_info4 is'|| p_tab_rec_data(i).act_info4);
521: hr_utility.trace('act_info5 is'|| p_tab_rec_data(i).act_info5);
522: hr_utility.trace('act_info6 is'|| p_tab_rec_data(i).act_info6);

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

515: hr_utility.trace('jurisdiction_code '||
516: p_tab_rec_data(i).jurisdiction_code);
517: hr_utility.trace('act_info1 is'|| p_tab_rec_data(i).act_info1);
518: hr_utility.trace('act_info2 is'|| p_tab_rec_data(i).act_info2);
519: hr_utility.trace('act_info3 is'|| p_tab_rec_data(i).act_info3);
520: hr_utility.trace('act_info4 is'|| p_tab_rec_data(i).act_info4);
521: hr_utility.trace('act_info5 is'|| p_tab_rec_data(i).act_info5);
522: hr_utility.trace('act_info6 is'|| p_tab_rec_data(i).act_info6);
523: hr_utility.trace('act_info30 is'|| p_tab_rec_data(i).act_info30);

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

516: p_tab_rec_data(i).jurisdiction_code);
517: hr_utility.trace('act_info1 is'|| p_tab_rec_data(i).act_info1);
518: hr_utility.trace('act_info2 is'|| p_tab_rec_data(i).act_info2);
519: hr_utility.trace('act_info3 is'|| p_tab_rec_data(i).act_info3);
520: hr_utility.trace('act_info4 is'|| p_tab_rec_data(i).act_info4);
521: hr_utility.trace('act_info5 is'|| p_tab_rec_data(i).act_info5);
522: hr_utility.trace('act_info6 is'|| p_tab_rec_data(i).act_info6);
523: hr_utility.trace('act_info30 is'|| p_tab_rec_data(i).act_info30);
524:

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

517: hr_utility.trace('act_info1 is'|| p_tab_rec_data(i).act_info1);
518: hr_utility.trace('act_info2 is'|| p_tab_rec_data(i).act_info2);
519: hr_utility.trace('act_info3 is'|| p_tab_rec_data(i).act_info3);
520: hr_utility.trace('act_info4 is'|| p_tab_rec_data(i).act_info4);
521: hr_utility.trace('act_info5 is'|| p_tab_rec_data(i).act_info5);
522: hr_utility.trace('act_info6 is'|| p_tab_rec_data(i).act_info6);
523: hr_utility.trace('act_info30 is'|| p_tab_rec_data(i).act_info30);
524:
525: hr_utility.set_location(gv_package || '.' || lv_procedure_name, 30);

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

518: hr_utility.trace('act_info2 is'|| p_tab_rec_data(i).act_info2);
519: hr_utility.trace('act_info3 is'|| p_tab_rec_data(i).act_info3);
520: hr_utility.trace('act_info4 is'|| p_tab_rec_data(i).act_info4);
521: hr_utility.trace('act_info5 is'|| p_tab_rec_data(i).act_info5);
522: hr_utility.trace('act_info6 is'|| p_tab_rec_data(i).act_info6);
523: hr_utility.trace('act_info30 is'|| p_tab_rec_data(i).act_info30);
524:
525: hr_utility.set_location(gv_package || '.' || lv_procedure_name, 30);
526: pay_action_information_api.create_action_information(

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

519: hr_utility.trace('act_info3 is'|| p_tab_rec_data(i).act_info3);
520: hr_utility.trace('act_info4 is'|| p_tab_rec_data(i).act_info4);
521: hr_utility.trace('act_info5 is'|| p_tab_rec_data(i).act_info5);
522: hr_utility.trace('act_info6 is'|| p_tab_rec_data(i).act_info6);
523: hr_utility.trace('act_info30 is'|| p_tab_rec_data(i).act_info30);
524:
525: hr_utility.set_location(gv_package || '.' || lv_procedure_name, 30);
526: pay_action_information_api.create_action_information(
527: p_action_information_id => l_action_information_id_1,

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

521: hr_utility.trace('act_info5 is'|| p_tab_rec_data(i).act_info5);
522: hr_utility.trace('act_info6 is'|| p_tab_rec_data(i).act_info6);
523: hr_utility.trace('act_info30 is'|| p_tab_rec_data(i).act_info30);
524:
525: hr_utility.set_location(gv_package || '.' || lv_procedure_name, 30);
526: pay_action_information_api.create_action_information(
527: p_action_information_id => l_action_information_id_1,
528: p_object_version_number => l_object_version_number_1,
529: p_action_information_category

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

568: );
569:
570: end loop;
571: end if;
572: hr_utility.set_location(gv_package || lv_procedure_name, 50);
573: END insert_rows_thro_api_process;
574:
575:
576:

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

877: lv_value_type := null;
878: lv_value := null;
879: lv_organization_fetch := 'N';
880: lv_exists := 'N';
881: hr_utility.set_location(gv_package || lv_procedure_name, 10);
882: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
883: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
884: hr_utility.trace('p_organization_id = ' || p_organization_id);
885: hr_utility.trace('p_business_group_id = ' || p_business_group_id);

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

878: lv_value := null;
879: lv_organization_fetch := 'N';
880: lv_exists := 'N';
881: hr_utility.set_location(gv_package || lv_procedure_name, 10);
882: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
883: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
884: hr_utility.trace('p_organization_id = ' || p_organization_id);
885: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
886: hr_utility.trace('p_curr_pymt_eff_date = '|| p_curr_pymt_eff_date);

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

879: lv_organization_fetch := 'N';
880: lv_exists := 'N';
881: hr_utility.set_location(gv_package || lv_procedure_name, 10);
882: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
883: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
884: hr_utility.trace('p_organization_id = ' || p_organization_id);
885: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
886: hr_utility.trace('p_curr_pymt_eff_date = '|| p_curr_pymt_eff_date);
887: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);

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

880: lv_exists := 'N';
881: hr_utility.set_location(gv_package || lv_procedure_name, 10);
882: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
883: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
884: hr_utility.trace('p_organization_id = ' || p_organization_id);
885: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
886: hr_utility.trace('p_curr_pymt_eff_date = '|| p_curr_pymt_eff_date);
887: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
888:

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

881: hr_utility.set_location(gv_package || lv_procedure_name, 10);
882: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
883: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
884: hr_utility.trace('p_organization_id = ' || p_organization_id);
885: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
886: hr_utility.trace('p_curr_pymt_eff_date = '|| p_curr_pymt_eff_date);
887: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
888:
889: open c_organization_info(p_organization_id,

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

882: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
883: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
884: hr_utility.trace('p_organization_id = ' || p_organization_id);
885: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
886: hr_utility.trace('p_curr_pymt_eff_date = '|| p_curr_pymt_eff_date);
887: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
888:
889: open c_organization_info(p_organization_id,
890: 'Organization:Payslip Info');

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

883: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
884: hr_utility.trace('p_organization_id = ' || p_organization_id);
885: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
886: hr_utility.trace('p_curr_pymt_eff_date = '|| p_curr_pymt_eff_date);
887: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
888:
889: open c_organization_info(p_organization_id,
890: 'Organization:Payslip Info');
891: hr_utility.set_location(gv_package || lv_procedure_name, 20);

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

887: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
888:
889: open c_organization_info(p_organization_id,
890: 'Organization:Payslip Info');
891: hr_utility.set_location(gv_package || lv_procedure_name, 20);
892: loop
893: fetch c_organization_info into lv_info_type
894: ,ln_element_type_id
895: ,ln_input_value_id

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

901: if c_organization_info%notfound then
902: exit;
903: end if;
904:
905: hr_utility.set_location(gv_package || lv_procedure_name, 30);
906: hr_utility.trace('lv_info_type ' || lv_info_type);
907: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
908: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
909: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);

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

902: exit;
903: end if;
904:
905: hr_utility.set_location(gv_package || lv_procedure_name, 30);
906: hr_utility.trace('lv_info_type ' || lv_info_type);
907: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
908: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
909: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
910: hr_utility.trace('ln_balance_dimension_id ' || ln_balance_dimension_id);

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

903: end if;
904:
905: hr_utility.set_location(gv_package || lv_procedure_name, 30);
906: hr_utility.trace('lv_info_type ' || lv_info_type);
907: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
908: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
909: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
910: hr_utility.trace('ln_balance_dimension_id ' || ln_balance_dimension_id);
911: hr_utility.trace('lv_message ' || lv_message);

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

904:
905: hr_utility.set_location(gv_package || lv_procedure_name, 30);
906: hr_utility.trace('lv_info_type ' || lv_info_type);
907: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
908: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
909: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
910: hr_utility.trace('ln_balance_dimension_id ' || ln_balance_dimension_id);
911: hr_utility.trace('lv_message ' || lv_message);
912: hr_utility.trace('lv_display_name ' ||lv_display_name);

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

905: hr_utility.set_location(gv_package || lv_procedure_name, 30);
906: hr_utility.trace('lv_info_type ' || lv_info_type);
907: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
908: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
909: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
910: hr_utility.trace('ln_balance_dimension_id ' || ln_balance_dimension_id);
911: hr_utility.trace('lv_message ' || lv_message);
912: hr_utility.trace('lv_display_name ' ||lv_display_name);
913:

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

906: hr_utility.trace('lv_info_type ' || lv_info_type);
907: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
908: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
909: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
910: hr_utility.trace('ln_balance_dimension_id ' || ln_balance_dimension_id);
911: hr_utility.trace('lv_message ' || lv_message);
912: hr_utility.trace('lv_display_name ' ||lv_display_name);
913:
914: lv_organization_fetch := 'Y' ;

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

907: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
908: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
909: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
910: hr_utility.trace('ln_balance_dimension_id ' || ln_balance_dimension_id);
911: hr_utility.trace('lv_message ' || lv_message);
912: hr_utility.trace('lv_display_name ' ||lv_display_name);
913:
914: lv_organization_fetch := 'Y' ;
915:

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

908: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
909: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
910: hr_utility.trace('ln_balance_dimension_id ' || ln_balance_dimension_id);
911: hr_utility.trace('lv_message ' || lv_message);
912: hr_utility.trace('lv_display_name ' ||lv_display_name);
913:
914: lv_organization_fetch := 'Y' ;
915:
916: if lv_info_type ='ELEMENT' then

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

913:
914: lv_organization_fetch := 'Y' ;
915:
916: if lv_info_type ='ELEMENT' then
917: hr_utility.set_location(gv_package || lv_procedure_name, 40);
918: open c_element_details(ln_element_type_id
919: ,ln_input_value_id
920: ,p_assignment_id
921: ,gv_correspondence_language

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

925: lv_value_type,
926: lv_uom,
927: lv_reporting_name;
928: if c_element_details%found then
929: hr_utility.set_location(gv_package || lv_procedure_name, 50);
930: hr_utility.trace('lv_uom ' || lv_uom);
931:
932: if lv_uom in ('M', 'N', 'I') then
933: lv_value := fnd_number.number_to_canonical(lv_value);

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

926: lv_uom,
927: lv_reporting_name;
928: if c_element_details%found then
929: hr_utility.set_location(gv_package || lv_procedure_name, 50);
930: hr_utility.trace('lv_uom ' || lv_uom);
931:
932: if lv_uom in ('M', 'N', 'I') then
933: lv_value := fnd_number.number_to_canonical(lv_value);
934: end if;

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

931:
932: if lv_uom in ('M', 'N', 'I') then
933: lv_value := fnd_number.number_to_canonical(lv_value);
934: end if;
935: hr_utility.trace('lv_value ' || lv_value);
936: hr_utility.trace('lv_name ' || lv_info_type);
937: hr_utility.trace('lv_value_type ' || lv_value_type);
938:
939: ln_index := pay_emp_action_arch.lrr_act_tab.count;

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

932: if lv_uom in ('M', 'N', 'I') then
933: lv_value := fnd_number.number_to_canonical(lv_value);
934: end if;
935: hr_utility.trace('lv_value ' || lv_value);
936: hr_utility.trace('lv_name ' || lv_info_type);
937: hr_utility.trace('lv_value_type ' || lv_value_type);
938:
939: ln_index := pay_emp_action_arch.lrr_act_tab.count;
940:

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

933: lv_value := fnd_number.number_to_canonical(lv_value);
934: end if;
935: hr_utility.trace('lv_value ' || lv_value);
936: hr_utility.trace('lv_name ' || lv_info_type);
937: hr_utility.trace('lv_value_type ' || lv_value_type);
938:
939: ln_index := pay_emp_action_arch.lrr_act_tab.count;
940:
941: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category

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

965: end if;
966: close c_element_details;
967:
968: elsif lv_info_type = 'BALANCE' then
969: hr_utility.set_location(gv_package || lv_procedure_name, 60);
970: open c_defined_balance_id(ln_balance_type_id
971: ,ln_balance_dimension_id
972: ,gv_correspondence_language);
973: fetch c_defined_balance_id into ln_defined_balance_id,

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

975: lv_value_type,
976: lv_uom,
977: lv_reporting_name;
978:
979: hr_utility.trace('lv_name ' || lv_info_type);
980: hr_utility.trace('lv_value_type ' || lv_value_type);
981: hr_utility.trace('ln_defined_balance_id ' || ln_defined_balance_id);
982:
983: if c_defined_balance_id%found then

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

976: lv_uom,
977: lv_reporting_name;
978:
979: hr_utility.trace('lv_name ' || lv_info_type);
980: hr_utility.trace('lv_value_type ' || lv_value_type);
981: hr_utility.trace('ln_defined_balance_id ' || ln_defined_balance_id);
982:
983: if c_defined_balance_id%found then
984:

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

977: lv_reporting_name;
978:
979: hr_utility.trace('lv_name ' || lv_info_type);
980: hr_utility.trace('lv_value_type ' || lv_value_type);
981: hr_utility.trace('ln_defined_balance_id ' || ln_defined_balance_id);
982:
983: if c_defined_balance_id%found then
984:
985: if p_ppp_source_action_id is not null then

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

991: ln_run_action_id := nvl(p_ytd_balcall_aaid,p_run_action_id);
992: end if;
993: end if;
994:
995: hr_utility.trace('p_ppp_source_action_id '||
996: p_ppp_source_action_id);
997: hr_utility.trace('ln_run_action_id '|| ln_run_action_id);
998:
999: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

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

993: end if;
994:
995: hr_utility.trace('p_ppp_source_action_id '||
996: p_ppp_source_action_id);
997: hr_utility.trace('ln_run_action_id '|| ln_run_action_id);
998:
999: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1000: lv_value := nvl(pay_balance_pkg.get_value(ln_defined_balance_id,
1001: ln_run_action_id),0);

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

999: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1000: lv_value := nvl(pay_balance_pkg.get_value(ln_defined_balance_id,
1001: ln_run_action_id),0);
1002: if lv_value <> 0 then
1003: hr_utility.set_location(gv_package || lv_procedure_name, 110);
1004: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1005:
1006: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1007: := 'EMPLOYEE OTHER INFORMATION';

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

1032: close c_defined_balance_id;
1033:
1034: end if;
1035:
1036: hr_utility.trace('ln_index in get_employee_other_info proc is '
1037: || pay_emp_action_arch.lrr_act_tab.count);
1038: hr_utility.trace('lv_info_type is'||lv_info_type);
1039:
1040: end loop;

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

1034: end if;
1035:
1036: hr_utility.trace('ln_index in get_employee_other_info proc is '
1037: || pay_emp_action_arch.lrr_act_tab.count);
1038: hr_utility.trace('lv_info_type is'||lv_info_type);
1039:
1040: end loop;
1041: close c_organization_info;
1042:

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

1042:
1043: if lv_organization_fetch = 'N' then
1044: open c_organization_info(p_business_group_id,
1045: 'Business Group:Payslip Info');
1046: hr_utility.trace('Opened for Business Group:Payslip Info');
1047: loop
1048: fetch c_organization_info into lv_info_type
1049: ,ln_element_type_id
1050: ,ln_input_value_id

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

1055:
1056: if c_organization_info%notfound then
1057: exit;
1058: end if;
1059: hr_utility.set_location(gv_package || lv_procedure_name, 140);
1060: hr_utility.trace('lv_info_type ' || lv_info_type);
1061: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
1062: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
1063: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);

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

1056: if c_organization_info%notfound then
1057: exit;
1058: end if;
1059: hr_utility.set_location(gv_package || lv_procedure_name, 140);
1060: hr_utility.trace('lv_info_type ' || lv_info_type);
1061: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
1062: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
1063: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
1064: hr_utility.trace('ln_balance_dimension_id' || ln_balance_dimension_id);

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

1057: exit;
1058: end if;
1059: hr_utility.set_location(gv_package || lv_procedure_name, 140);
1060: hr_utility.trace('lv_info_type ' || lv_info_type);
1061: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
1062: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
1063: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
1064: hr_utility.trace('ln_balance_dimension_id' || ln_balance_dimension_id);
1065: hr_utility.trace('lv_message ' || lv_message);

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

1058: end if;
1059: hr_utility.set_location(gv_package || lv_procedure_name, 140);
1060: hr_utility.trace('lv_info_type ' || lv_info_type);
1061: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
1062: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
1063: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
1064: hr_utility.trace('ln_balance_dimension_id' || ln_balance_dimension_id);
1065: hr_utility.trace('lv_message ' || lv_message);
1066: hr_utility.trace('lv_display_name ' || lv_display_name);

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

1059: hr_utility.set_location(gv_package || lv_procedure_name, 140);
1060: hr_utility.trace('lv_info_type ' || lv_info_type);
1061: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
1062: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
1063: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
1064: hr_utility.trace('ln_balance_dimension_id' || ln_balance_dimension_id);
1065: hr_utility.trace('lv_message ' || lv_message);
1066: hr_utility.trace('lv_display_name ' || lv_display_name);
1067:

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

1060: hr_utility.trace('lv_info_type ' || lv_info_type);
1061: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
1062: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
1063: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
1064: hr_utility.trace('ln_balance_dimension_id' || ln_balance_dimension_id);
1065: hr_utility.trace('lv_message ' || lv_message);
1066: hr_utility.trace('lv_display_name ' || lv_display_name);
1067:
1068: if lv_info_type ='ELEMENT' then

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

1061: hr_utility.trace('ln_element_type_id ' || ln_element_type_id);
1062: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
1063: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
1064: hr_utility.trace('ln_balance_dimension_id' || ln_balance_dimension_id);
1065: hr_utility.trace('lv_message ' || lv_message);
1066: hr_utility.trace('lv_display_name ' || lv_display_name);
1067:
1068: if lv_info_type ='ELEMENT' then
1069: open c_element_details(ln_element_type_id

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

1062: hr_utility.trace('ln_input_value_id ' || ln_input_value_id);
1063: hr_utility.trace('ln_balance_type_id ' || ln_balance_type_id);
1064: hr_utility.trace('ln_balance_dimension_id' || ln_balance_dimension_id);
1065: hr_utility.trace('lv_message ' || lv_message);
1066: hr_utility.trace('lv_display_name ' || lv_display_name);
1067:
1068: if lv_info_type ='ELEMENT' then
1069: open c_element_details(ln_element_type_id
1070: ,ln_input_value_id

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

1077: lv_reporting_name;
1078: --if c_element_details%notfound then
1079: if c_element_details%found then
1080:
1081: hr_utility.trace('lv_uom ' || lv_uom);
1082: if lv_uom in ('M', 'N', 'I') then
1083: lv_value := fnd_number.number_to_canonical(lv_value);
1084: end if;
1085:

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

1083: lv_value := fnd_number.number_to_canonical(lv_value);
1084: end if;
1085:
1086: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1087: hr_utility.trace('lv_name ' || lv_info_type);
1088: hr_utility.trace('lv_value ' || lv_value);
1089: hr_utility.trace('lv_value_type ' || lv_value_type);
1090:
1091: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category

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

1084: end if;
1085:
1086: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1087: hr_utility.trace('lv_name ' || lv_info_type);
1088: hr_utility.trace('lv_value ' || lv_value);
1089: hr_utility.trace('lv_value_type ' || lv_value_type);
1090:
1091: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1092: := 'EMPLOYEE OTHER INFORMATION';

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

1085:
1086: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1087: hr_utility.trace('lv_name ' || lv_info_type);
1088: hr_utility.trace('lv_value ' || lv_value);
1089: hr_utility.trace('lv_value_type ' || lv_value_type);
1090:
1091: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1092: := 'EMPLOYEE OTHER INFORMATION';
1093: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code

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

1114: := nvl(lv_display_name,lv_reporting_name);
1115: end if;
1116: close c_element_details;
1117: elsif lv_info_type = 'BALANCE' then
1118: hr_utility.set_location(gv_package || lv_procedure_name, 210);
1119:
1120: open c_defined_balance_id(ln_balance_type_id
1121: ,ln_balance_dimension_id
1122: ,gv_correspondence_language);

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

1120: open c_defined_balance_id(ln_balance_type_id
1121: ,ln_balance_dimension_id
1122: ,gv_correspondence_language);
1123:
1124: hr_utility.set_location(gv_package || lv_procedure_name, 220);
1125: fetch c_defined_balance_id into ln_defined_balance_id,
1126: lv_name,
1127: lv_value_type,
1128: lv_uom,

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

1127: lv_value_type,
1128: lv_uom,
1129: lv_reporting_name;
1130:
1131: hr_utility.trace('ln_balance_type_id' || ln_balance_type_id);
1132: hr_utility.trace('lv_name ' || lv_info_type);
1133: hr_utility.trace('lv_value_type ' || lv_value_type);
1134: hr_utility.trace('ln_defined_balance_id ' || ln_defined_balance_id);
1135: if c_defined_balance_id%found then

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

1128: lv_uom,
1129: lv_reporting_name;
1130:
1131: hr_utility.trace('ln_balance_type_id' || ln_balance_type_id);
1132: hr_utility.trace('lv_name ' || lv_info_type);
1133: hr_utility.trace('lv_value_type ' || lv_value_type);
1134: hr_utility.trace('ln_defined_balance_id ' || ln_defined_balance_id);
1135: if c_defined_balance_id%found then
1136:

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

1129: lv_reporting_name;
1130:
1131: hr_utility.trace('ln_balance_type_id' || ln_balance_type_id);
1132: hr_utility.trace('lv_name ' || lv_info_type);
1133: hr_utility.trace('lv_value_type ' || lv_value_type);
1134: hr_utility.trace('ln_defined_balance_id ' || ln_defined_balance_id);
1135: if c_defined_balance_id%found then
1136:
1137: if p_ppp_source_action_id is not null then

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

1130:
1131: hr_utility.trace('ln_balance_type_id' || ln_balance_type_id);
1132: hr_utility.trace('lv_name ' || lv_info_type);
1133: hr_utility.trace('lv_value_type ' || lv_value_type);
1134: hr_utility.trace('ln_defined_balance_id ' || ln_defined_balance_id);
1135: if c_defined_balance_id%found then
1136:
1137: if p_ppp_source_action_id is not null then
1138: ln_run_action_id := p_ppp_source_action_id;

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

1144: p_run_action_id);
1145: end if;
1146: end if;
1147:
1148: hr_utility.trace('p_ppp_source_action_id '||
1149: p_ppp_source_action_id);
1150: hr_utility.trace('ln_run_action_id '|| ln_run_action_id);
1151:
1152: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

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

1146: end if;
1147:
1148: hr_utility.trace('p_ppp_source_action_id '||
1149: p_ppp_source_action_id);
1150: hr_utility.trace('ln_run_action_id '|| ln_run_action_id);
1151:
1152: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1153:
1154: lv_value := nvl(pay_balance_pkg.get_value(ln_defined_balance_id,

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

1209: lv_procedure_name VARCHAR2(100);
1210:
1211: BEGIN
1212: lv_procedure_name := 'get_employee_accruals';
1213: hr_utility.trace('Entered get_employee_accruals');
1214:
1215: pay_us_emp_payslip_accrual_web.get_emp_net_accrual (
1216: p_assignment_action_id => p_run_action_id
1217: ,p_assignment_id => p_assignment_id

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

1242: := pay_us_emp_payslip_accrual_web.ltr_assignment_accruals(i).accrual_code;
1243: end loop;
1244: end if;
1245:
1246: hr_utility.trace('Leaving get_employee_accruals');
1247:
1248: END get_employee_accruals;
1249:
1250:

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

1269:
1270: BEGIN
1271: lv_procedure_name := 'get_organization_name';
1272: lv_exists := 'N';
1273: hr_utility.trace('Entered get_organization_name');
1274: if pay_emp_action_arch.ltr_organizations.count > 0 then
1275: for i in pay_emp_action_arch.ltr_organizations.first ..
1276: pay_emp_action_arch.ltr_organizations.last loop
1277: if pay_emp_action_arch.ltr_organizations(i).id = p_organization_id then

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

1290: pay_emp_action_arch.ltr_organizations(ln_index).id := p_organization_id;
1291: pay_emp_action_arch.ltr_organizations(ln_index).name := lv_organization_name;
1292: end if;
1293:
1294: hr_utility.trace('Leaving get_organization_name');
1295: return(lv_organization_name);
1296: EXCEPTION
1297: when others then
1298: hr_utility.trace('Error in ' || lv_procedure_name ||

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

1294: hr_utility.trace('Leaving get_organization_name');
1295: return(lv_organization_name);
1296: EXCEPTION
1297: when others then
1298: hr_utility.trace('Error in ' || lv_procedure_name ||
1299: to_char(sqlcode) || '-' || sqlerrm);
1300: raise hr_utility.hr_error;
1301:
1302: END get_organization_name ;

Line 1300: raise hr_utility.hr_error;

1296: EXCEPTION
1297: when others then
1298: hr_utility.trace('Error in ' || lv_procedure_name ||
1299: to_char(sqlcode) || '-' || sqlerrm);
1300: raise hr_utility.hr_error;
1301:
1302: END get_organization_name ;
1303:
1304:

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

1324:
1325: BEGIN
1326: lv_procedure_name := 'get_location';
1327: lv_exists := 'N';
1328: hr_utility.trace('Entered get_location');
1329:
1330: if pay_emp_action_arch.ltr_location.count > 0 then
1331: for i in pay_emp_action_arch.ltr_location.first ..
1332: pay_emp_action_arch.ltr_location.last loop

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

1346: pay_emp_action_arch.ltr_location(ln_index).id := p_location_id;
1347: pay_emp_action_arch.ltr_location(ln_index).name := lv_location_name;
1348: end if;
1349:
1350: hr_utility.trace('Leaving get_location');
1351:
1352: return(lv_location_name);
1353: EXCEPTION
1354: when others then

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

1384:
1385: BEGIN
1386: lv_procedure_name := 'get_job_name';
1387: lv_exists := 'N';
1388: hr_utility.trace('Entered get_job_name');
1389: if pay_emp_action_arch.ltr_jobs.count > 0 then
1390: for i in pay_emp_action_arch.ltr_jobs.first ..
1391: pay_emp_action_arch.ltr_jobs.last loop
1392: if pay_emp_action_arch.ltr_jobs(i).id = p_job_id then

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

1405: pay_emp_action_arch.ltr_jobs(ln_index).id := p_job_id;
1406: pay_emp_action_arch.ltr_jobs(ln_index).name := lv_job_name;
1407: end if;
1408:
1409: hr_utility.trace('Leaving get_job_name');
1410: return(lv_job_name);
1411:
1412: END get_job_name ;
1413:

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

1437:
1438: BEGIN
1439: lv_procedure_name := 'get_position';
1440: lv_exists := 'N';
1441: hr_utility.trace('Entered get_position');
1442: if pay_emp_action_arch.ltr_positions.count > 0 then
1443: for i in pay_emp_action_arch.ltr_positions.first ..
1444: pay_emp_action_arch.ltr_positions.last loop
1445: if pay_emp_action_arch.ltr_positions(i).id = p_position_id then

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

1458: pay_emp_action_arch.ltr_positions(ln_index).id := p_position_id;
1459: pay_emp_action_arch.ltr_positions(ln_index).name := lv_position_name;
1460: end if;
1461:
1462: hr_utility.trace('Leaving get_position');
1463:
1464: return(lv_position_name);
1465:
1466: END get_position ;

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

1493:
1494: BEGIN
1495: lv_procedure_name := 'get_pay_basis';
1496: lv_exists := 'N';
1497: hr_utility.trace('Entered get_pay_basis');
1498: if pay_emp_action_arch.ltr_pay_basis.count > 0 then
1499: for i in pay_emp_action_arch.ltr_pay_basis.first ..
1500: pay_emp_action_arch.ltr_pay_basis.last loop
1501: if pay_emp_action_arch.ltr_pay_basis(i).id = p_pay_basis_id then

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

1514: pay_emp_action_arch.ltr_pay_basis(ln_index).id := p_pay_basis_id;
1515: pay_emp_action_arch.ltr_pay_basis(ln_index).name := lv_pay_basis;
1516: end if;
1517:
1518: hr_utility.trace('Leaving get_pay_basis');
1519:
1520: return(lv_pay_basis);
1521:
1522: END get_pay_basis ;

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

1546: lv_procedure_name VARCHAR2(100);
1547:
1548: BEGIN
1549: lv_procedure_name := 'get_frequency';
1550: hr_utility.trace('Entered get_frequency');
1551: open c_get_asg_frequency(p_frequency, p_effective_date);
1552: fetch c_get_asg_frequency into lv_frequency_desc;
1553: close c_get_asg_frequency;
1554:

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

1551: open c_get_asg_frequency(p_frequency, p_effective_date);
1552: fetch c_get_asg_frequency into lv_frequency_desc;
1553: close c_get_asg_frequency;
1554:
1555: hr_utility.trace('Leaving get_frequency');
1556: return(lv_frequency_desc);
1557:
1558: END get_frequency ;
1559:

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

1584:
1585: BEGIN
1586: lv_procedure_name := 'get_grade';
1587: lv_exists := 'N';
1588: hr_utility.trace('Entered get_grades');
1589: if pay_emp_action_arch.ltr_grades.count > 0 then
1590: for i in pay_emp_action_arch.ltr_grades.first ..
1591: pay_emp_action_arch.ltr_grades.last loop
1592: if pay_emp_action_arch.ltr_grades(i).id = p_grade_id then

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

1635: lv_procedure_name VARCHAR2(100);
1636:
1637: BEGIN
1638: lv_procedure_name := 'get_bargaining_unit';
1639: hr_utility.trace('Entered get_bargaining_unit');
1640: open c_get_bargaining_unit(p_bargaining_unit, p_effective_date);
1641: fetch c_get_bargaining_unit into lv_bargaining_unit;
1642: close c_get_bargaining_unit;
1643:

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

1640: open c_get_bargaining_unit(p_bargaining_unit, p_effective_date);
1641: fetch c_get_bargaining_unit into lv_bargaining_unit;
1642: close c_get_bargaining_unit;
1643:
1644: hr_utility.trace('Leaving get_bargaining_unit');
1645: return(lv_bargaining_unit);
1646:
1647: END get_bargaining_unit ;
1648:

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

1671: lv_procedure_name VARCHAR2(100);
1672:
1673: BEGIN
1674: lv_procedure_name := 'get_collective_agreement';
1675: hr_utility.trace('Entered get_collective_agreement');
1676: open c_get_collective_agreement(p_collective_agreement_id
1677: ,p_effective_date);
1678: fetch c_get_collective_agreement into lv_collective_agreement;
1679: close c_get_collective_agreement;

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

1676: open c_get_collective_agreement(p_collective_agreement_id
1677: ,p_effective_date);
1678: fetch c_get_collective_agreement into lv_collective_agreement;
1679: close c_get_collective_agreement;
1680: hr_utility.trace('Leaving get_collective_agreement');
1681: return(lv_collective_agreement);
1682:
1683: END get_collective_agreement ;
1684:

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

1705: lv_procedure_name VARCHAR2(100);
1706:
1707: BEGIN
1708: lv_procedure_name := 'get_contract';
1709: hr_utility.trace('Entered get_contract');
1710: open c_get_contract(p_contract_id, p_effective_date);
1711: fetch c_get_contract into lv_contract;
1712: close c_get_contract;
1713:

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

1710: open c_get_contract(p_contract_id, p_effective_date);
1711: fetch c_get_contract into lv_contract;
1712: close c_get_contract;
1713:
1714: hr_utility.trace('Leaving get_contract');
1715: return(lv_contract);
1716: END get_contract ;
1717:
1718:

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

1742: lv_procedure_name VARCHAR2(100);
1743:
1744: BEGIN
1745: lv_procedure_name := 'get_hourly_salaried_code';
1746: hr_utility.trace('Entered get_hourly_salaried_code');
1747: open c_get_hourly_salaried_code(p_hourly_salaried_code
1748: ,p_effective_date);
1749: fetch c_get_hourly_salaried_code into lv_hourly_salaried_desc;
1750: close c_get_hourly_salaried_code;

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

1748: ,p_effective_date);
1749: fetch c_get_hourly_salaried_code into lv_hourly_salaried_desc;
1750: close c_get_hourly_salaried_code;
1751:
1752: hr_utility.trace('Leaving get_hourly_salaried_code');
1753: return(lv_hourly_salaried_desc);
1754:
1755: END get_hourly_salaried_code ;
1756:

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

1798: lv_legislation_code VARCHAR2(2);
1799:
1800: BEGIN
1801: lv_procedure_name := 'get_shift';
1802: hr_utility.trace('Entered get_shift');
1803:
1804: open c_legislation (p_business_group_id);
1805: fetch c_legislation into lv_legislation_code ;
1806: close c_legislation;

Line 1807: hr_utility.trace('lv_legislation_code '||lv_legislation_code);

1803:
1804: open c_legislation (p_business_group_id);
1805: fetch c_legislation into lv_legislation_code ;
1806: close c_legislation;
1807: hr_utility.trace('lv_legislation_code '||lv_legislation_code);
1808:
1809: /* bug:9549403 : Corrected and changed the logic
1810: to archive shift info for US localization. */
1811:

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

1812: IF lv_legislation_code = 'US' THEN
1813: open c_get_shift(p_soft_coding_keyflex_id, p_effective_date);
1814: fetch c_get_shift into lv_shift_code;
1815: IF c_get_shift%FOUND THEN
1816: hr_utility.trace('shift_code = ' || lv_shift_code);
1817:
1818: open c_get_shift_desc(lv_shift_code, p_effective_date);
1819: fetch c_get_shift_desc into lv_shift_desc;
1820: close c_get_shift_desc;

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

1821: END IF;
1822: close c_get_shift;
1823: END IF;
1824:
1825: hr_utility.trace('Leaving get_shift');
1826: return(lv_shift_desc);
1827:
1828: END get_shift ;
1829:

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

1884: close c_addr_line;
1885:
1886: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1887:
1888: hr_utility.trace('ln_index in get_employee_addr proc is '
1889: || pay_emp_action_arch.lrr_act_tab.count);
1890: hr_utility.trace('person_id is'||p_person_id);
1891:
1892: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category

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

1886: ln_index := pay_emp_action_arch.lrr_act_tab.count;
1887:
1888: hr_utility.trace('ln_index in get_employee_addr proc is '
1889: || pay_emp_action_arch.lrr_act_tab.count);
1890: hr_utility.trace('person_id is'||p_person_id);
1891:
1892: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
1893: := 'ADDRESS DETAILS';
1894: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code

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

1914: pay_emp_action_arch.lrr_act_tab(ln_index).act_info13
1915: := lv_ee_country;
1916: pay_emp_action_arch.lrr_act_tab(ln_index).act_info14
1917: := lv_ee_or_er;
1918: hr_utility.trace('Leaving get_employee_addr');
1919: END get_employee_addr;
1920:
1921:
1922: /******************************************************************

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

2027: open c_net_pay(p_pre_pay_action_id
2028: ,p_assignment_id
2029: ,p_curr_pymt_eff_date
2030: ,p_ppp_source_action_id);
2031: hr_utility.trace('Opened cursor get_net_pay_distribution ');
2032:
2033: loop
2034: fetch c_net_pay into lv_segment1
2035: ,lv_segment2

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

2045: ,ln_pre_payment_id
2046: ,ln_org_payment_method_id
2047: ,lv_org_payment_method_name
2048: ,ln_emp_payment_method_id;
2049: hr_utility.trace('Fetched get_net_pay_distribution ');
2050: if c_net_pay%notfound then
2051: exit;
2052: end if;
2053:

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

2052: end if;
2053:
2054: ln_index := pay_emp_action_arch.lrr_act_tab.count;
2055:
2056: hr_utility.trace('ln_index in get_net_pay_dist proc is '
2057: || pay_emp_action_arch.lrr_act_tab.count);
2058:
2059: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2060: := 'EMPLOYEE NET PAY DISTRIBUTION';

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

2095: pay_emp_action_arch.lrr_act_tab(ln_index).act_info18
2096: := lv_org_payment_method_name;
2097: end loop;
2098: close c_net_pay;
2099: hr_utility.set_location(gv_package || lv_procedure_name,100);
2100: END get_net_pay_distribution;
2101:
2102: /******************************************************************
2103: Name : get_tp_pay_distribution

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

2215: lv_procedure_name VARCHAR2(100);
2216:
2217: BEGIN
2218: lv_procedure_name := 'get_3rdparty_pay_distribution';
2219: hr_utility.set_location(gv_package || lv_procedure_name,10);
2220: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
2221: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2222: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
2223: k := 0;

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

2216:
2217: BEGIN
2218: lv_procedure_name := 'get_3rdparty_pay_distribution';
2219: hr_utility.set_location(gv_package || lv_procedure_name,10);
2220: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
2221: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2222: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
2223: k := 0;
2224:

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

2217: BEGIN
2218: lv_procedure_name := 'get_3rdparty_pay_distribution';
2219: hr_utility.set_location(gv_package || lv_procedure_name,10);
2220: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
2221: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2222: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
2223: k := 0;
2224:
2225: -- Check if Multi assignment payment is enabled

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

2218: lv_procedure_name := 'get_3rdparty_pay_distribution';
2219: hr_utility.set_location(gv_package || lv_procedure_name,10);
2220: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
2221: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2222: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
2223: k := 0;
2224:
2225: -- Check if Multi assignment payment is enabled
2226: if pay_emp_action_arch.gv_multi_payroll_pymt is null then

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

2228: := pay_emp_action_arch.get_multi_assignment_flag(
2229: p_payroll_id => p_payroll_id
2230: ,p_effective_date => p_curr_pymt_eff_date);
2231: end if;
2232: hr_utility.set_location(gv_package || lv_procedure_name,20);
2233:
2234: if nvl(pay_emp_action_arch.gv_multi_payroll_pymt, 'N') = 'Y' then
2235: -- If Multi Assignment Payment is enabled, get the child prepayment
2236: -- actions as payment information is stored against child.

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

2238: for cval in c_child_action(p_pre_pay_action_id, p_assignment_id) loop
2239: ltt_actions(k) := cval.assignment_action_id;
2240: k := k + 1;
2241: end loop;
2242: hr_utility.set_location(gv_package || lv_procedure_name,30);
2243: else
2244: ltt_actions(k) := p_pre_pay_action_id;
2245: k := k + 1;
2246: hr_utility.set_location(gv_package || lv_procedure_name,40);

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

2242: hr_utility.set_location(gv_package || lv_procedure_name,30);
2243: else
2244: ltt_actions(k) := p_pre_pay_action_id;
2245: k := k + 1;
2246: hr_utility.set_location(gv_package || lv_procedure_name,40);
2247: end if;
2248:
2249: -- Value of k will be zero only if the payroll is enabled for multi
2250: -- assignment payments and we are processing seperate check action.

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

2253: ltt_actions(k) := p_pre_pay_action_id;
2254: end if;
2255:
2256: for j in ltt_actions.first .. ltt_actions.last loop
2257: hr_utility.trace('assignment action = ' || ltt_actions(j));
2258: end loop;
2259:
2260: for j in ltt_actions.first .. ltt_actions.last loop
2261: open c_third_party_pay(ltt_actions(j)

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

2278: ,ln_pre_payment_id
2279: ,ln_org_payment_method_id
2280: ,lv_org_payment_method_name
2281: ,ln_emp_payment_method_id;
2282: hr_utility.trace('Fetched get_3rdparty_pay_distribution ');
2283: if c_third_party_pay%notfound then
2284: exit;
2285: end if;
2286:

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

2285: end if;
2286:
2287: ln_index := pay_emp_action_arch.lrr_act_tab.count;
2288:
2289: hr_utility.trace('ln_index in get_3rdparty_pay_distribution proc is '
2290: || pay_emp_action_arch.lrr_act_tab.count);
2291:
2292: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
2293: := 'EMPLOYEE THIRD PARTY PAYMENTS';

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

2294: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2295: := '00-000-0000';
2296: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
2297: := ln_org_payment_method_id;
2298: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);
2299: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
2300: := ln_emp_payment_method_id;
2301: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
2302: := null;

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

2330: := lv_org_payment_method_name;
2331: end loop;
2332: close c_third_party_pay;
2333: end loop;
2334: hr_utility.set_location(gv_package || lv_procedure_name,100);
2335:
2336: END get_3rdparty_pay_distribution;
2337:
2338:

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

2372: if p_organization_id is not null then
2373: open c_get_other_info(p_organization_id
2374: ,'Organization:Payslip Info') ;
2375: loop
2376: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2377: fetch c_get_other_info into lv_org_information1
2378: ,lv_org_information2
2379: ,lv_org_information3
2380: ,lv_org_information4

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

2382: ,lv_org_information6
2383: ,lv_org_information7
2384: ,lv_org_information_cntxt;
2385: if c_get_other_info%notfound then
2386: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2387: exit;
2388: end if;
2389:
2390:

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

2387: exit;
2388: end if;
2389:
2390:
2391: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2392: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2393: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2394: pay_emp_action_arch.ltr_ppa_arch.last loop
2395: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1

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

2427: end loop ;
2428: close c_get_other_info;
2429: end if;
2430:
2431: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2432: if p_business_group_id is not null then
2433: open c_get_other_info(p_business_group_id
2434: ,'Business Group:Payslip Info') ;
2435: loop

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

2432: if p_business_group_id is not null then
2433: open c_get_other_info(p_business_group_id
2434: ,'Business Group:Payslip Info') ;
2435: loop
2436: hr_utility.set_location(gv_package || lv_procedure_name, 110);
2437: fetch c_get_other_info into lv_org_information1
2438: ,lv_org_information2
2439: ,lv_org_information3
2440: ,lv_org_information4

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

2442: ,lv_org_information6
2443: ,lv_org_information7
2444: ,lv_org_information_cntxt; ----Bug 7115367
2445: if c_get_other_info%notfound then
2446: hr_utility.set_location(gv_package || lv_procedure_name, 120);
2447: exit;
2448: end if;
2449:
2450: hr_utility.set_location(gv_package || lv_procedure_name, 130);

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

2446: hr_utility.set_location(gv_package || lv_procedure_name, 120);
2447: exit;
2448: end if;
2449:
2450: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2451: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2452: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2453: pay_emp_action_arch.ltr_ppa_arch.last loop
2454: if pay_emp_action_arch.ltr_ppa_arch(i).act_info1

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

2485: end if;
2486: end loop ;
2487: close c_get_other_info;
2488: end if;
2489: hr_utility.set_location(gv_package || lv_procedure_name, 140);
2490:
2491: END get_org_other_info;
2492:
2493:

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

2524: lv_procedure_name := '.get_org_address';
2525: lv_ee_or_er := 'Employer Address';
2526: lv_exists := 'N';
2527: -- Get Employer address
2528: hr_utility.set_location(gv_package || lv_procedure_name, 210);
2529: if p_organization_id is null then
2530: return;
2531: end if;
2532: open c_addr_line(p_organization_id);

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

2540: ,lv_er_postal_code
2541: ,lv_er_country
2542: ,lv_er_telephone;
2543: close c_addr_line;
2544: hr_utility.set_location(gv_package || lv_procedure_name, 250);
2545:
2546: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2547: for i in pay_emp_action_arch.ltr_ppa_arch.first ..
2548: pay_emp_action_arch.ltr_ppa_arch.last loop

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

2556: end loop;
2557: end if;
2558:
2559: if lv_exists = 'N' then
2560: hr_utility.set_location(gv_package || lv_procedure_name, 260);
2561: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
2562:
2563: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
2564: := 'ADDRESS DETAILS';

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

2630: and paf.effective_end_date;
2631:
2632: BEGIN
2633: lv_procedure_name := '.arch_pay_action_level_data';
2634: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2635: open c_get_organization(p_payroll_id, p_effective_date);
2636: loop
2637: fetch c_get_organization into ln_organization_id,
2638: ln_business_group_id;

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

2645:
2646: end loop;
2647: close c_get_organization;
2648:
2649: hr_utility.set_location(gv_package || lv_procedure_name, 140);
2650:
2651: -- insert rows in pay_action_information table
2652: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2653: insert_rows_thro_api_process(

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

2660: );
2661: end if;
2662: EXCEPTION
2663: when others then
2664: hr_utility.trace('Error in ' || gv_package || '.' || lv_procedure_name || '-'
2665: || to_char(sqlcode) || '-' || sqlerrm);
2666: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2667: raise hr_utility.hr_error;
2668:

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

2662: EXCEPTION
2663: when others then
2664: hr_utility.trace('Error in ' || gv_package || '.' || lv_procedure_name || '-'
2665: || to_char(sqlcode) || '-' || sqlerrm);
2666: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2667: raise hr_utility.hr_error;
2668:
2669: END arch_pay_action_level_data;
2670:

Line 2667: raise hr_utility.hr_error;

2663: when others then
2664: hr_utility.trace('Error in ' || gv_package || '.' || lv_procedure_name || '-'
2665: || to_char(sqlcode) || '-' || sqlerrm);
2666: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2667: raise hr_utility.hr_error;
2668:
2669: END arch_pay_action_level_data;
2670:
2671:

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

2722: lv_procedure_name VARCHAR2(100);
2723:
2724: BEGIN
2725: lv_procedure_name := '.arch_pay_action_level_data_deinit';
2726: hr_utility.set_location(gv_package || lv_procedure_name, 1);
2727:
2728: delete from pay_action_information pai
2729: where pai.action_context_id = p_payroll_action_id
2730: and pai.action_context_type = 'PA'

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

2741: /* Archive Business Group Address and Address */
2742: get_org_other_info(null, ln_business_group_id);
2743: get_org_address(ln_business_group_id);
2744:
2745: hr_utility.set_location(gv_package || lv_procedure_name, 5);
2746: /* Get all the Organization ID and Tax Unit ID for assignment
2747: archived by the archiver. For the ORganizations get any
2748: message which needs to be archived and also archive the
2749: address information */

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

2753: if c_employer_info%notfound then
2754: exit;
2755: end if;
2756:
2757: hr_utility.trace('Organization ID = ' || ln_organization_id);
2758: hr_utility.trace('Tax Unit ID = ' || ln_tax_unit_id);
2759: /* Archive Organization Message */
2760: get_org_other_info(ln_organization_id, null);
2761: get_org_address(ln_organization_id);

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

2754: exit;
2755: end if;
2756:
2757: hr_utility.trace('Organization ID = ' || ln_organization_id);
2758: hr_utility.trace('Tax Unit ID = ' || ln_tax_unit_id);
2759: /* Archive Organization Message */
2760: get_org_other_info(ln_organization_id, null);
2761: get_org_address(ln_organization_id);
2762: if ln_organization_id <> ln_tax_unit_id and ln_tax_unit_id <> -1 then

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

2765:
2766: end loop;
2767: close c_employer_info;
2768:
2769: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2770:
2771: -- insert rows in pay_action_information table
2772: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2773: insert_rows_thro_api_process(

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

2778: ,p_curr_pymt_eff_date => p_effective_date
2779: ,p_tab_rec_data => pay_emp_action_arch.ltr_ppa_arch
2780: );
2781: end if;
2782: hr_utility.set_location(gv_package || lv_procedure_name, 150);
2783:
2784: EXCEPTION
2785: when others then
2786: hr_utility.trace('Error in ' || gv_package || '.' || lv_procedure_name || '-'

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

2782: hr_utility.set_location(gv_package || lv_procedure_name, 150);
2783:
2784: EXCEPTION
2785: when others then
2786: hr_utility.trace('Error in ' || gv_package || '.' || lv_procedure_name || '-'
2787: || to_char(sqlcode) || '-' || sqlerrm);
2788: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2789: raise hr_utility.hr_error;
2790:

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

2784: EXCEPTION
2785: when others then
2786: hr_utility.trace('Error in ' || gv_package || '.' || lv_procedure_name || '-'
2787: || to_char(sqlcode) || '-' || sqlerrm);
2788: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2789: raise hr_utility.hr_error;
2790:
2791: END arch_pay_action_level_data;
2792:

Line 2789: raise hr_utility.hr_error;

2785: when others then
2786: hr_utility.trace('Error in ' || gv_package || '.' || lv_procedure_name || '-'
2787: || to_char(sqlcode) || '-' || sqlerrm);
2788: hr_utility.set_location(gv_package || lv_procedure_name, 130);
2789: raise hr_utility.hr_error;
2790:
2791: END arch_pay_action_level_data;
2792:
2793:

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

2954:
2955: BEGIN
2956: lv_procedure_name := 'get_personal_information';
2957: lv_exists := 'N';
2958: hr_utility.trace('Entered get_personal_information');
2959: initialization_process;
2960:
2961: hr_utility.trace('p_assactid = ' || p_assactid);
2962: hr_utility.trace('p_assignment_id = ' || p_assignment_id);

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

2957: lv_exists := 'N';
2958: hr_utility.trace('Entered get_personal_information');
2959: initialization_process;
2960:
2961: hr_utility.trace('p_assactid = ' || p_assactid);
2962: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
2963: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
2964: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);
2965: hr_utility.trace('p_date_earned = ' || p_date_earned);

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

2958: hr_utility.trace('Entered get_personal_information');
2959: initialization_process;
2960:
2961: hr_utility.trace('p_assactid = ' || p_assactid);
2962: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
2963: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
2964: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);
2965: hr_utility.trace('p_date_earned = ' || p_date_earned);
2966: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);

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

2959: initialization_process;
2960:
2961: hr_utility.trace('p_assactid = ' || p_assactid);
2962: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
2963: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
2964: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);
2965: hr_utility.trace('p_date_earned = ' || p_date_earned);
2966: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2967: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);

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

2960:
2961: hr_utility.trace('p_assactid = ' || p_assactid);
2962: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
2963: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
2964: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);
2965: hr_utility.trace('p_date_earned = ' || p_date_earned);
2966: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2967: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
2968: hr_utility.trace('p_time_period_id = ' || p_time_period_id);

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

2961: hr_utility.trace('p_assactid = ' || p_assactid);
2962: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
2963: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
2964: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);
2965: hr_utility.trace('p_date_earned = ' || p_date_earned);
2966: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2967: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
2968: hr_utility.trace('p_time_period_id = ' || p_time_period_id);
2969: hr_utility.trace('p_run_action_id = ' || p_run_action_id);

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

2962: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
2963: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
2964: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);
2965: hr_utility.trace('p_date_earned = ' || p_date_earned);
2966: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2967: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
2968: hr_utility.trace('p_time_period_id = ' || p_time_period_id);
2969: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
2970: --Bug 5585331 starts here

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

2963: hr_utility.trace('p_curr_pymt_ass_act_id = ' || p_curr_pymt_ass_act_id);
2964: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);
2965: hr_utility.trace('p_date_earned = ' || p_date_earned);
2966: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2967: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
2968: hr_utility.trace('p_time_period_id = ' || p_time_period_id);
2969: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
2970: --Bug 5585331 starts here
2971: -- open c_employee_details(p_assignment_id,p_curr_eff_date);

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

2964: hr_utility.trace('p_curr_eff_date = ' || p_curr_eff_date);
2965: hr_utility.trace('p_date_earned = ' || p_date_earned);
2966: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2967: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
2968: hr_utility.trace('p_time_period_id = ' || p_time_period_id);
2969: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
2970: --Bug 5585331 starts here
2971: -- open c_employee_details(p_assignment_id,p_curr_eff_date);
2972: -- Bug 8305579 modified cursor and passed extra parameter of p_curr_eff_date

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

2965: hr_utility.trace('p_date_earned = ' || p_date_earned);
2966: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
2967: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
2968: hr_utility.trace('p_time_period_id = ' || p_time_period_id);
2969: hr_utility.trace('p_run_action_id = ' || p_run_action_id);
2970: --Bug 5585331 starts here
2971: -- open c_employee_details(p_assignment_id,p_curr_eff_date);
2972: -- Bug 8305579 modified cursor and passed extra parameter of p_curr_eff_date
2973: open c_employee_details(p_assignment_id,p_curr_eff_date,p_date_earned);

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

2971: -- open c_employee_details(p_assignment_id,p_curr_eff_date);
2972: -- Bug 8305579 modified cursor and passed extra parameter of p_curr_eff_date
2973: open c_employee_details(p_assignment_id,p_curr_eff_date,p_date_earned);
2974: --Bug 5585331 ends here
2975: hr_utility.trace('Opened c_employee_details of get_personal_information ');
2976: fetch c_employee_details into lv_full_name,
2977: lv_national_identifier,
2978: ln_person_id,
2979: ld_date_start,

Line 3003: hr_utility.raise_error;

2999: ln_business_group_id,
3000: ln_soft_coding_keyflex_id,
3001: lv_hourly_salaried_code;
3002: if c_employee_details%notfound then
3003: hr_utility.raise_error;
3004: end if;
3005:
3006: hr_utility.trace('Opening c_period_details');
3007: open c_period_details(p_time_period_id);

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

3002: if c_employee_details%notfound then
3003: hr_utility.raise_error;
3004: end if;
3005:
3006: hr_utility.trace('Opening c_period_details');
3007: open c_period_details(p_time_period_id);
3008: fetch c_period_details into ln_payroll_id,
3009: lv_period_type,
3010: ld_period_start_date,

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

3009: lv_period_type,
3010: ld_period_start_date,
3011: ld_period_end_date;
3012: if c_period_details%notfound then
3013: hr_utility.trace('Time Period details not found for time_period_id '
3014: ||to_char(p_time_period_id));
3015: --hr_utility.raise_error;
3016: end if;
3017: close c_period_details;

Line 3015: --hr_utility.raise_error;

3011: ld_period_end_date;
3012: if c_period_details%notfound then
3013: hr_utility.trace('Time Period details not found for time_period_id '
3014: ||to_char(p_time_period_id));
3015: --hr_utility.raise_error;
3016: end if;
3017: close c_period_details;
3018:
3019:

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

3102: end if;
3103:
3104: ln_index := pay_emp_action_arch.lrr_act_tab.count;
3105:
3106: hr_utility.trace('ln_index in get_personal_information proc is '
3107: || pay_emp_action_arch.lrr_act_tab.count);
3108:
3109: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category
3110: := 'EMPLOYEE DETAILS';

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

3111: pay_emp_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3112: := '00-000-0000';
3113: pay_emp_action_arch.lrr_act_tab(ln_index).act_info1
3114: := lv_full_name;
3115: hr_utility.trace('lv_full_name is'||lv_full_name);
3116:
3117: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
3118: := ln_organization_id;
3119: hr_utility.trace('ln_organization_id is'||ln_organization_id);

Line 3119: hr_utility.trace('ln_organization_id is'||ln_organization_id);

3115: hr_utility.trace('lv_full_name is'||lv_full_name);
3116:
3117: pay_emp_action_arch.lrr_act_tab(ln_index).act_info2
3118: := ln_organization_id;
3119: hr_utility.trace('ln_organization_id is'||ln_organization_id);
3120:
3121: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
3122: := lv_national_identifier ;
3123:

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

3120:
3121: pay_emp_action_arch.lrr_act_tab(ln_index).act_info4
3122: := lv_national_identifier ;
3123:
3124: hr_utility.trace('lv_national_identifier is'||lv_national_identifier);
3125:
3126: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5 := lv_pay_basis;
3127:
3128: hr_utility.trace('lv_pay_basis is'||lv_pay_basis);

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

3124: hr_utility.trace('lv_national_identifier is'||lv_national_identifier);
3125:
3126: pay_emp_action_arch.lrr_act_tab(ln_index).act_info5 := lv_pay_basis;
3127:
3128: hr_utility.trace('lv_pay_basis is'||lv_pay_basis);
3129:
3130: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
3131: := lv_frequency_desc;
3132:

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

3129:
3130: pay_emp_action_arch.lrr_act_tab(ln_index).act_info6
3131: := lv_frequency_desc;
3132:
3133: hr_utility.trace('lv_frequency_desc is'||lv_frequency_desc);
3134:
3135: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
3136: := lv_grade;
3137:

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

3134:
3135: pay_emp_action_arch.lrr_act_tab(ln_index).act_info7
3136: := lv_grade;
3137:
3138: hr_utility.trace('lv_grade is'||lv_grade);
3139:
3140: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
3141: := lv_bargaining_unit;
3142:

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

3139:
3140: pay_emp_action_arch.lrr_act_tab(ln_index).act_info8
3141: := lv_bargaining_unit;
3142:
3143: hr_utility.trace('lv_bargaining_unit is'||lv_bargaining_unit);
3144: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
3145: := lv_collective_agreement;
3146:
3147: hr_utility.trace('lv_collective_agreement is'||lv_collective_agreement);

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

3143: hr_utility.trace('lv_bargaining_unit is'||lv_bargaining_unit);
3144: pay_emp_action_arch.lrr_act_tab(ln_index).act_info9
3145: := lv_collective_agreement;
3146:
3147: hr_utility.trace('lv_collective_agreement is'||lv_collective_agreement);
3148: pay_emp_action_arch.lrr_act_tab(ln_index).act_info10
3149: := lv_employee_number ;
3150:
3151: pay_emp_action_arch.lrr_act_tab(ln_index).act_info11

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

3245: gv_package := 'pay_emp_action_arch';
3246:
3247: EXCEPTION
3248: when others then
3249: hr_utility.trace('Error in ' || gv_package ||
3250: to_char(sqlcode) || '-' || sqlerrm);
3251: raise hr_utility.hr_error;
3252:
3253: END pay_emp_action_arch;

Line 3251: raise hr_utility.hr_error;

3247: EXCEPTION
3248: when others then
3249: hr_utility.trace('Error in ' || gv_package ||
3250: to_char(sqlcode) || '-' || sqlerrm);
3251: raise hr_utility.hr_error;
3252:
3253: END pay_emp_action_arch;