eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IP_PAYROLL_ARCH dependencies on HR_UTILITY

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

65:
66: BEGIN
67: lv_procedure_name := '.get_payroll_action_info';
68:
69: hr_utility.set_location(gv_package || lv_procedure_name, 10);
70: ln_step := 1;
71: OPEN c_payroll_action_info(p_payroll_action_id);
72: FETCH c_payroll_action_info INTO ld_end_date,
73: ld_start_date,

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

75: ln_cons_set_id,
76: ln_payroll_id;
77: CLOSE c_payroll_action_info;
78:
79: hr_utility.set_location(gv_package || lv_procedure_name, 30);
80: p_end_date := ld_end_date;
81: p_start_date := ld_start_date;
82: p_business_group_id := ln_business_group_id;
83: p_cons_set_id := ln_cons_set_id;

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

81: p_start_date := ld_start_date;
82: p_business_group_id := ln_business_group_id;
83: p_cons_set_id := ln_cons_set_id;
84: p_payroll_id := ln_payroll_id;
85: hr_utility.set_location(gv_package || lv_procedure_name, 50);
86: ln_step := 2;
87:
88: EXCEPTION
89: WHEN OTHERS THEN

Line 91: hr_utility.trace(lv_error_message || '-' || SQLERRM);

87:
88: EXCEPTION
89: WHEN OTHERS THEN
90: lv_error_message := 'Error at step ' || ln_step ||' IN '||gv_package || lv_procedure_name;
91: hr_utility.trace(lv_error_message || '-' || SQLERRM);
92:
93: lv_error_message :=
94: pay_emp_action_arch.set_error_message(lv_error_message);
95:

Line 96: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

92:
93: lv_error_message :=
94: pay_emp_action_arch.set_error_message(lv_error_message);
95:
96: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
97: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
98: hr_utility.raise_error;
99:
100: END get_payroll_action_info;

Line 97: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

93: lv_error_message :=
94: pay_emp_action_arch.set_error_message(lv_error_message);
95:
96: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
97: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
98: hr_utility.raise_error;
99:
100: END get_payroll_action_info;
101:

Line 98: hr_utility.raise_error;

94: pay_emp_action_arch.set_error_message(lv_error_message);
95:
96: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
97: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
98: hr_utility.raise_error;
99:
100: END get_payroll_action_info;
101:
102: /******************************************************************************

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

152:
153:
154: BEGIN
155: lv_procedure_name := '.get_element_payment_hours';
156: hr_utility.set_location(gv_package || lv_procedure_name, 10);
157: ln_step := 1;
158:
159: /*Get the Hours value*/
160: FOR csr_rec IN get_hours_input_value(p_element_type_id,p_effective_date)

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

168: EXIT;
169: ELSE
170: l_result := NVL(l_result,0) + NVL(l_temp,0);
171: END IF;
172: hr_utility.set_location(gv_package || lv_procedure_name, 20);
173: END LOOP;
174: ln_step := 2;
175:
176: /* Avoid Divide by Zero Error when used for computing Rate, Report Hours and Rate as Null */

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

178: THEN
179: l_result := NULL;
180: END IF;
181:
182: hr_utility.set_location(gv_package || lv_procedure_name, 30);
183: RETURN l_result;
184:
185: EXCEPTION
186: WHEN OTHERS THEN

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

183: RETURN l_result;
184:
185: EXCEPTION
186: WHEN OTHERS THEN
187: hr_utility.set_location(gv_package || lv_procedure_name, 100);
188: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
189:
190: hr_utility.trace(lv_error_message || '-' || SQLERRM);
191:

Line 190: hr_utility.trace(lv_error_message || '-' || SQLERRM);

186: WHEN OTHERS THEN
187: hr_utility.set_location(gv_package || lv_procedure_name, 100);
188: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
189:
190: hr_utility.trace(lv_error_message || '-' || SQLERRM);
191:
192: lv_error_message :=
193: pay_emp_action_arch.set_error_message(lv_error_message);
194: hr_utility.raise_error;

Line 194: hr_utility.raise_error;

190: hr_utility.trace(lv_error_message || '-' || SQLERRM);
191:
192: lv_error_message :=
193: pay_emp_action_arch.set_error_message(lv_error_message);
194: hr_utility.raise_error;
195: END get_element_payment_hours;
196:
197:
198: /******************************************************************************

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

255:
256: lv_procedure_name := '.get_employee_information';
257:
258: ln_step := 1;
259: hr_utility.set_location(gv_package || lv_procedure_name, 10);
260:
261: lv_action_category := 'IP EMPLOYEE ADDITIONAL DETAILS';
262: /*Fetching Employee additional information*/
263: OPEN c_get_emp_info(p_assignment_id);

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

274: lv_work_at_home;
275: CLOSE c_get_emp_info;
276: ln_step := 2;
277:
278: hr_utility.set_location(gv_package || lv_procedure_name, 20);
279:
280: pay_emp_action_arch.initialization_process;
281: hr_utility.trace('Initialized PL/SQL table');
282:

Line 281: hr_utility.trace('Initialized PL/SQL table');

277:
278: hr_utility.set_location(gv_package || lv_procedure_name, 20);
279:
280: pay_emp_action_arch.initialization_process;
281: hr_utility.trace('Initialized PL/SQL table');
282:
283: ln_index := pay_emp_action_arch.lrr_act_tab.count;
284:
285: pay_emp_action_arch.lrr_act_tab(ln_index).action_info_category

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

311:
312: /* api call to insert the data into pay_action_information table with
313: information category as 'IP EMPLOYEE ADDITIONAL DETAILS' */
314:
315: hr_utility.set_location(gv_package || lv_procedure_name, 30);
316: IF pay_emp_action_arch.lrr_act_tab.count > 0 THEN
317: pay_emp_action_arch.insert_rows_thro_api_process(
318: p_action_context_id => p_assactid
319: ,p_action_context_type=> 'AAP'

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

323: ,p_tab_rec_data => pay_emp_action_arch.lrr_act_tab
324: );
325: END IF;
326: ln_step := 4;
327: hr_utility.set_location(gv_package || lv_procedure_name, 40);
328:
329: EXCEPTION
330: WHEN OTHERS THEN
331: hr_utility.set_location(gv_package || lv_procedure_name, 100);

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

327: hr_utility.set_location(gv_package || lv_procedure_name, 40);
328:
329: EXCEPTION
330: WHEN OTHERS THEN
331: hr_utility.set_location(gv_package || lv_procedure_name, 100);
332: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
333: hr_utility.trace(lv_error_message || '-' || SQLERRM);
334:
335: lv_error_message :=

Line 333: hr_utility.trace(lv_error_message || '-' || SQLERRM);

329: EXCEPTION
330: WHEN OTHERS THEN
331: hr_utility.set_location(gv_package || lv_procedure_name, 100);
332: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
333: hr_utility.trace(lv_error_message || '-' || SQLERRM);
334:
335: lv_error_message :=
336: pay_emp_action_arch.set_error_message(lv_error_message);
337: hr_utility.raise_error;

Line 337: hr_utility.raise_error;

333: hr_utility.trace(lv_error_message || '-' || SQLERRM);
334:
335: lv_error_message :=
336: pay_emp_action_arch.set_error_message(lv_error_message);
337: hr_utility.raise_error;
338: END get_employee_information;
339:
340: /******************************************************************
341: Name : populate_elements

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

416: lv_is_element_archived := 'N';
417: lv_action_category := 'IP DEDUCTIONS';
418:
419: ln_step := 1;
420: hr_utility.set_location(gv_package || lv_procedure_name, 10);
421: hr_utility.trace('p_xfr_action_id '
422: ||to_char(p_xfr_action_id));
423: hr_utility.trace('p_pymt_assignment_action_id '
424: ||to_char(p_pymt_assignment_action_id));

Line 421: hr_utility.trace('p_xfr_action_id '

417: lv_action_category := 'IP DEDUCTIONS';
418:
419: ln_step := 1;
420: hr_utility.set_location(gv_package || lv_procedure_name, 10);
421: hr_utility.trace('p_xfr_action_id '
422: ||to_char(p_xfr_action_id));
423: hr_utility.trace('p_pymt_assignment_action_id '
424: ||to_char(p_pymt_assignment_action_id));
425: hr_utility.trace('p_pymt_eff_date '

Line 423: hr_utility.trace('p_pymt_assignment_action_id '

419: ln_step := 1;
420: hr_utility.set_location(gv_package || lv_procedure_name, 10);
421: hr_utility.trace('p_xfr_action_id '
422: ||to_char(p_xfr_action_id));
423: hr_utility.trace('p_pymt_assignment_action_id '
424: ||to_char(p_pymt_assignment_action_id));
425: hr_utility.trace('p_pymt_eff_date '
426: ||to_char(p_pymt_eff_date));
427: hr_utility.trace('p_primary_balance_id '

Line 425: hr_utility.trace('p_pymt_eff_date '

421: hr_utility.trace('p_xfr_action_id '
422: ||to_char(p_xfr_action_id));
423: hr_utility.trace('p_pymt_assignment_action_id '
424: ||to_char(p_pymt_assignment_action_id));
425: hr_utility.trace('p_pymt_eff_date '
426: ||to_char(p_pymt_eff_date));
427: hr_utility.trace('p_primary_balance_id '
428: ||to_char(p_primary_balance_id));
429: hr_utility.trace('p_reporting_name '

Line 427: hr_utility.trace('p_primary_balance_id '

423: hr_utility.trace('p_pymt_assignment_action_id '
424: ||to_char(p_pymt_assignment_action_id));
425: hr_utility.trace('p_pymt_eff_date '
426: ||to_char(p_pymt_eff_date));
427: hr_utility.trace('p_primary_balance_id '
428: ||to_char(p_primary_balance_id));
429: hr_utility.trace('p_reporting_name '
430: ||p_reporting_name);
431: hr_utility.trace('p_ytd_balcall_aaid '

Line 429: hr_utility.trace('p_reporting_name '

425: hr_utility.trace('p_pymt_eff_date '
426: ||to_char(p_pymt_eff_date));
427: hr_utility.trace('p_primary_balance_id '
428: ||to_char(p_primary_balance_id));
429: hr_utility.trace('p_reporting_name '
430: ||p_reporting_name);
431: hr_utility.trace('p_ytd_balcall_aaid '
432: ||to_char(p_ytd_balcall_aaid));
433: hr_utility.trace('p_pymt_balcall_aaid '

Line 431: hr_utility.trace('p_ytd_balcall_aaid '

427: hr_utility.trace('p_primary_balance_id '
428: ||to_char(p_primary_balance_id));
429: hr_utility.trace('p_reporting_name '
430: ||p_reporting_name);
431: hr_utility.trace('p_ytd_balcall_aaid '
432: ||to_char(p_ytd_balcall_aaid));
433: hr_utility.trace('p_pymt_balcall_aaid '
434: ||to_char(p_pymt_balcall_aaid));
435: hr_utility.trace('p_legislation_code '

Line 433: hr_utility.trace('p_pymt_balcall_aaid '

429: hr_utility.trace('p_reporting_name '
430: ||p_reporting_name);
431: hr_utility.trace('p_ytd_balcall_aaid '
432: ||to_char(p_ytd_balcall_aaid));
433: hr_utility.trace('p_pymt_balcall_aaid '
434: ||to_char(p_pymt_balcall_aaid));
435: hr_utility.trace('p_legislation_code '
436: ||p_legislation_code);
437: hr_utility.trace('p_hours_balance_id '

Line 435: hr_utility.trace('p_legislation_code '

431: hr_utility.trace('p_ytd_balcall_aaid '
432: ||to_char(p_ytd_balcall_aaid));
433: hr_utility.trace('p_pymt_balcall_aaid '
434: ||to_char(p_pymt_balcall_aaid));
435: hr_utility.trace('p_legislation_code '
436: ||p_legislation_code);
437: hr_utility.trace('p_hours_balance_id '
438: ||to_char(p_hours_balance_id));
439: hr_utility.trace('p_days_balance_id '

Line 437: hr_utility.trace('p_hours_balance_id '

433: hr_utility.trace('p_pymt_balcall_aaid '
434: ||to_char(p_pymt_balcall_aaid));
435: hr_utility.trace('p_legislation_code '
436: ||p_legislation_code);
437: hr_utility.trace('p_hours_balance_id '
438: ||to_char(p_hours_balance_id));
439: hr_utility.trace('p_days_balance_id '
440: ||to_char(p_days_balance_id));
441: hr_utility.trace('p_tax_unit_id '

Line 439: hr_utility.trace('p_days_balance_id '

435: hr_utility.trace('p_legislation_code '
436: ||p_legislation_code);
437: hr_utility.trace('p_hours_balance_id '
438: ||to_char(p_hours_balance_id));
439: hr_utility.trace('p_days_balance_id '
440: ||to_char(p_days_balance_id));
441: hr_utility.trace('p_tax_unit_id '
442: ||to_char(p_tax_unit_id));
443: hr_utility.trace('p_sepchk_flag '

Line 441: hr_utility.trace('p_tax_unit_id '

437: hr_utility.trace('p_hours_balance_id '
438: ||to_char(p_hours_balance_id));
439: hr_utility.trace('p_days_balance_id '
440: ||to_char(p_days_balance_id));
441: hr_utility.trace('p_tax_unit_id '
442: ||to_char(p_tax_unit_id));
443: hr_utility.trace('p_sepchk_flag '
444: ||to_char(p_sepchk_flag));
445: hr_utility.trace('p_action_type '

Line 443: hr_utility.trace('p_sepchk_flag '

439: hr_utility.trace('p_days_balance_id '
440: ||to_char(p_days_balance_id));
441: hr_utility.trace('p_tax_unit_id '
442: ||to_char(p_tax_unit_id));
443: hr_utility.trace('p_sepchk_flag '
444: ||to_char(p_sepchk_flag));
445: hr_utility.trace('p_action_type '
446: ||to_char(p_action_type));
447:

Line 445: hr_utility.trace('p_action_type '

441: hr_utility.trace('p_tax_unit_id '
442: ||to_char(p_tax_unit_id));
443: hr_utility.trace('p_sepchk_flag '
444: ||to_char(p_sepchk_flag));
445: hr_utility.trace('p_action_type '
446: ||to_char(p_action_type));
447:
448: IF pay_emp_action_arch.gv_multi_leg_rule IS NULL THEN
449: pay_emp_action_arch.gv_multi_leg_rule

Line 465: hr_utility.trace('ln_ytd_defined_balance_id = '||ln_ytd_defined_balance_id);

461: p_primary_balance_id,
462: gv_ytd_balance_dimension,
463: p_legislation_code);
464:
465: hr_utility.trace('ln_ytd_defined_balance_id = '||ln_ytd_defined_balance_id);
466:
467: ln_step := 3;
468: IF p_hours_balance_id IS NOT NULL THEN
469: hr_utility.set_location(gv_package || lv_procedure_name, 20);

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

465: hr_utility.trace('ln_ytd_defined_balance_id = '||ln_ytd_defined_balance_id);
466:
467: ln_step := 3;
468: IF p_hours_balance_id IS NOT NULL THEN
469: hr_utility.set_location(gv_package || lv_procedure_name, 20);
470: ln_ytd_hours_def_balance_id
471: := pay_emp_action_arch.get_defined_balance_id(
472: p_hours_balance_id,
473: gv_ytd_balance_dimension,

Line 476: hr_utility.trace('ln_ytd_hours_def_balance_id = '||ln_ytd_hours_def_balance_id);

472: p_hours_balance_id,
473: gv_ytd_balance_dimension,
474: p_legislation_code);
475:
476: hr_utility.trace('ln_ytd_hours_def_balance_id = '||ln_ytd_hours_def_balance_id);
477: END IF;
478:
479: ln_step := 4;
480: hr_utility.set_location(gv_package || lv_procedure_name, 30);

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

476: hr_utility.trace('ln_ytd_hours_def_balance_id = '||ln_ytd_hours_def_balance_id);
477: END IF;
478:
479: ln_step := 4;
480: hr_utility.set_location(gv_package || lv_procedure_name, 30);
481: lv_is_element_archived := 'N';
482:
483: /*Checking whether the element is archived already*/
484: IF pay_ac_action_arch.lrr_act_tab.count <> 0 THEN

Line 500: hr_utility.trace('lv_is_element_archived = ' || lv_is_element_archived);

496: END LOOP;
497: END IF;
498: ln_step := 5;
499:
500: hr_utility.trace('lv_is_element_archived = ' || lv_is_element_archived);
501:
502: IF lv_is_element_archived = 'N' THEN -- if 1
503: ln_step := 6;
504: hr_utility.set_location(gv_package || lv_procedure_name, 40);

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

500: hr_utility.trace('lv_is_element_archived = ' || lv_is_element_archived);
501:
502: IF lv_is_element_archived = 'N' THEN -- if 1
503: ln_step := 6;
504: hr_utility.set_location(gv_package || lv_procedure_name, 40);
505: IF ln_ytd_defined_balance_id IS NOT NULL THEN -- if 2
506: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
507: ln_ytd_defined_balance_id,
508: p_ytd_balcall_aaid),0);

Line 515: hr_utility.trace('YTD Dimension is not set for Primary balance');

511: lv_error_message := 'Defined Balance for the combination "'
512: || lv_balance_name ||'" and "'
513: ||gv_ytd_balance_dimension||'" not exist';
514: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
515: hr_utility.trace('YTD Dimension is not set for Primary balance');
516: hr_utility.trace('Primary balance ID '||p_primary_balance_id);
517: hr_utility.trace('YTD Balance Dimensions '||gv_ytd_balance_dimension);
518: hr_utility.raise_error;
519: END IF; -- if 2

Line 516: hr_utility.trace('Primary balance ID '||p_primary_balance_id);

512: || lv_balance_name ||'" and "'
513: ||gv_ytd_balance_dimension||'" not exist';
514: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
515: hr_utility.trace('YTD Dimension is not set for Primary balance');
516: hr_utility.trace('Primary balance ID '||p_primary_balance_id);
517: hr_utility.trace('YTD Balance Dimensions '||gv_ytd_balance_dimension);
518: hr_utility.raise_error;
519: END IF; -- if 2
520:

Line 517: hr_utility.trace('YTD Balance Dimensions '||gv_ytd_balance_dimension);

513: ||gv_ytd_balance_dimension||'" not exist';
514: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
515: hr_utility.trace('YTD Dimension is not set for Primary balance');
516: hr_utility.trace('Primary balance ID '||p_primary_balance_id);
517: hr_utility.trace('YTD Balance Dimensions '||gv_ytd_balance_dimension);
518: hr_utility.raise_error;
519: END IF; -- if 2
520:
521: IF p_hours_balance_id IS NOT NULL THEN -- if 3

Line 518: hr_utility.raise_error;

514: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
515: hr_utility.trace('YTD Dimension is not set for Primary balance');
516: hr_utility.trace('Primary balance ID '||p_primary_balance_id);
517: hr_utility.trace('YTD Balance Dimensions '||gv_ytd_balance_dimension);
518: hr_utility.raise_error;
519: END IF; -- if 2
520:
521: IF p_hours_balance_id IS NOT NULL THEN -- if 3
522: hr_utility.set_location(gv_package || lv_procedure_name, 50);

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

518: hr_utility.raise_error;
519: END IF; -- if 2
520:
521: IF p_hours_balance_id IS NOT NULL THEN -- if 3
522: hr_utility.set_location(gv_package || lv_procedure_name, 50);
523: IF ln_ytd_hours_def_balance_id IS NOT NULL THEN -- if 4
524: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
525: ln_ytd_hours_def_balance_id,
526: p_ytd_balcall_aaid),0);

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

523: IF ln_ytd_hours_def_balance_id IS NOT NULL THEN -- if 4
524: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
525: ln_ytd_hours_def_balance_id,
526: p_ytd_balcall_aaid),0);
527: hr_utility.set_location(gv_package || lv_procedure_name, 60);
528: ELSE
529: lv_balance_name := pay_ip_utility.get_balance_name(p_hours_balance_id);
530: lv_error_message := 'Defined Balance for the combination "'
531: || lv_balance_name ||'" and "'

Line 534: hr_utility.trace('YTD Dimension is not set for Primary Hours balance '||p_reporting_name);

530: lv_error_message := 'Defined Balance for the combination "'
531: || lv_balance_name ||'" and "'
532: ||gv_ytd_balance_dimension||'" not exist';
533: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
534: hr_utility.trace('YTD Dimension is not set for Primary Hours balance '||p_reporting_name);
535: hr_utility.raise_error;
536: END IF; -- if 4
537: END IF; --Hours -- if 3
538:

Line 535: hr_utility.raise_error;

531: || lv_balance_name ||'" and "'
532: ||gv_ytd_balance_dimension||'" not exist';
533: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
534: hr_utility.trace('YTD Dimension is not set for Primary Hours balance '||p_reporting_name);
535: hr_utility.raise_error;
536: END IF; -- if 4
537: END IF; --Hours -- if 3
538:
539: ln_step := 7;

Line 566: hr_utility.set_location(gv_package || lv_procedure_name, 70);

562: p_legislation_code);
563: END IF; --if 7
564: END IF; /*p_action_type */ --if 6
565:
566: hr_utility.set_location(gv_package || lv_procedure_name, 70);
567: hr_utility.trace('ln_pymt_defined_balance_id '||ln_pymt_defined_balance_id);
568: ln_step := 9;
569:
570: IF ln_pymt_defined_balance_id IS NOT NULL THEN --if 8

Line 567: hr_utility.trace('ln_pymt_defined_balance_id '||ln_pymt_defined_balance_id);

563: END IF; --if 7
564: END IF; /*p_action_type */ --if 6
565:
566: hr_utility.set_location(gv_package || lv_procedure_name, 70);
567: hr_utility.trace('ln_pymt_defined_balance_id '||ln_pymt_defined_balance_id);
568: ln_step := 9;
569:
570: IF ln_pymt_defined_balance_id IS NOT NULL THEN --if 8
571: /*****************************************************************

Line 579: hr_utility.trace('ln_payments_amount = ' ||ln_payments_amount);

575: ******************************************************************/
576: ln_payments_amount := NVL(pay_balance_pkg.get_value(
577: ln_pymt_defined_balance_id, --p_pymt_balcall_aaid
578: p_pymt_assignment_action_id),0); /*p_pymt_assignment_action_id prepayment assignment action */
579: hr_utility.trace('ln_payments_amount = ' ||ln_payments_amount);
580: hr_utility.set_location(gv_package || lv_procedure_name, 80);
581: ELSE
582:
583: lv_balance_name := pay_ip_utility.get_balance_name(p_primary_balance_id);

Line 580: hr_utility.set_location(gv_package || lv_procedure_name, 80);

576: ln_payments_amount := NVL(pay_balance_pkg.get_value(
577: ln_pymt_defined_balance_id, --p_pymt_balcall_aaid
578: p_pymt_assignment_action_id),0); /*p_pymt_assignment_action_id prepayment assignment action */
579: hr_utility.trace('ln_payments_amount = ' ||ln_payments_amount);
580: hr_utility.set_location(gv_package || lv_procedure_name, 80);
581: ELSE
582:
583: lv_balance_name := pay_ip_utility.get_balance_name(p_primary_balance_id);
584: lv_error_message := 'Defined Balance for the combination "'

Line 588: hr_utility.set_location(gv_package || lv_procedure_name, 90);

584: lv_error_message := 'Defined Balance for the combination "'
585: || lv_balance_name ||'" and "_PAYMENTS" not exist';
586: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
587:
588: hr_utility.set_location(gv_package || lv_procedure_name, 90);
589: hr_utility.trace('Dimension is not set for Primary balance '||p_primary_balance_id);
590: hr_utility.raise_error;
591: END IF; --if 8
592:

Line 589: hr_utility.trace('Dimension is not set for Primary balance '||p_primary_balance_id);

585: || lv_balance_name ||'" and "_PAYMENTS" not exist';
586: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
587:
588: hr_utility.set_location(gv_package || lv_procedure_name, 90);
589: hr_utility.trace('Dimension is not set for Primary balance '||p_primary_balance_id);
590: hr_utility.raise_error;
591: END IF; --if 8
592:
593: ln_step := 10;

Line 590: hr_utility.raise_error;

586: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
587:
588: hr_utility.set_location(gv_package || lv_procedure_name, 90);
589: hr_utility.trace('Dimension is not set for Primary balance '||p_primary_balance_id);
590: hr_utility.raise_error;
591: END IF; --if 8
592:
593: ln_step := 10;
594: IF p_hours_balance_id IS NOT NULL THEN --if 9

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

612: ,'_PAYMENTS'
613: ,p_legislation_code);
614: END IF; --if 11
615: END IF; -- p_action_type IN ('B') -- if10
616: hr_utility.set_location(gv_package || lv_procedure_name, 100);
617:
618: hr_utility.trace('ln_pymt_hours_balance_id '||ln_pymt_hours_balance_id);
619:
620: IF ln_pymt_hours_balance_id IS NOT NULL THEN --if 12

Line 618: hr_utility.trace('ln_pymt_hours_balance_id '||ln_pymt_hours_balance_id);

614: END IF; --if 11
615: END IF; -- p_action_type IN ('B') -- if10
616: hr_utility.set_location(gv_package || lv_procedure_name, 100);
617:
618: hr_utility.trace('ln_pymt_hours_balance_id '||ln_pymt_hours_balance_id);
619:
620: IF ln_pymt_hours_balance_id IS NOT NULL THEN --if 12
621: ln_current_hours := NVL(pay_balance_pkg.get_value(
622: ln_pymt_hours_balance_id,

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

626: lv_balance_name := pay_ip_utility.get_balance_name(p_hours_balance_id);
627: lv_error_message := 'Defined Balance for the combination "'
628: || lv_balance_name ||'" and "_PAYMENTS" not exist';
629: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
630: hr_utility.set_location(gv_package || lv_procedure_name, 110);
631: hr_utility.trace('Dimension is not set for Primary Hours balance '||p_hours_balance_id);
632: hr_utility.raise_error;
633: END IF; --if 12
634: hr_utility.set_location(gv_package || lv_procedure_name, 120);

Line 631: hr_utility.trace('Dimension is not set for Primary Hours balance '||p_hours_balance_id);

627: lv_error_message := 'Defined Balance for the combination "'
628: || lv_balance_name ||'" and "_PAYMENTS" not exist';
629: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
630: hr_utility.set_location(gv_package || lv_procedure_name, 110);
631: hr_utility.trace('Dimension is not set for Primary Hours balance '||p_hours_balance_id);
632: hr_utility.raise_error;
633: END IF; --if 12
634: hr_utility.set_location(gv_package || lv_procedure_name, 120);
635: END IF; --Hours -- if 9

Line 632: hr_utility.raise_error;

628: || lv_balance_name ||'" and "_PAYMENTS" not exist';
629: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
630: hr_utility.set_location(gv_package || lv_procedure_name, 110);
631: hr_utility.trace('Dimension is not set for Primary Hours balance '||p_hours_balance_id);
632: hr_utility.raise_error;
633: END IF; --if 12
634: hr_utility.set_location(gv_package || lv_procedure_name, 120);
635: END IF; --Hours -- if 9
636:

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

630: hr_utility.set_location(gv_package || lv_procedure_name, 110);
631: hr_utility.trace('Dimension is not set for Primary Hours balance '||p_hours_balance_id);
632: hr_utility.raise_error;
633: END IF; --if 12
634: hr_utility.set_location(gv_package || lv_procedure_name, 120);
635: END IF; --Hours -- if 9
636:
637: END IF; -- p_pymt_balcall_aaid is not NULL --if 5
638:

Line 648: hr_utility.set_location(gv_package || lv_procedure_name, 125);

644: 'Supplemental Earnings',
645: 'Taxable Benefits',
646: 'Employer Charges',
647: 'Direct Payment') THEN --if 14
648: hr_utility.set_location(gv_package || lv_procedure_name, 125);
649: lv_action_category := 'IP EARNINGS';
650: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
651: := fnd_number.number_to_canonical(ln_current_hours);
652: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12

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

652: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
653: := fnd_number.number_to_canonical(ln_ytd_hours);
654: END IF; --if 14
655:
656: hr_utility.set_location(gv_package || lv_procedure_name, 130);
657: /* Insert this into the plsql table if Current or YTD
658: amount is not Zero */
659: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
660: := lv_action_category;

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

679:
680: END IF; --if 13
681: END IF; -- lv_is_element_archived = 'N' --if 1
682:
683: hr_utility.set_location(gv_package || lv_procedure_name, 150);
684: ln_step := 12;
685:
686: EXCEPTION
687: WHEN OTHERS THEN

Line 688: hr_utility.set_location(gv_package || lv_procedure_name, 200);

684: ln_step := 12;
685:
686: EXCEPTION
687: WHEN OTHERS THEN
688: hr_utility.set_location(gv_package || lv_procedure_name, 200);
689: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
690: hr_utility.trace(lv_error_message || '-' || SQLERRM);
691:
692: lv_error_message :=

Line 690: hr_utility.trace(lv_error_message || '-' || SQLERRM);

686: EXCEPTION
687: WHEN OTHERS THEN
688: hr_utility.set_location(gv_package || lv_procedure_name, 200);
689: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
690: hr_utility.trace(lv_error_message || '-' || SQLERRM);
691:
692: lv_error_message :=
693: pay_emp_action_arch.set_error_message(lv_error_message);
694:

Line 695: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

691:
692: lv_error_message :=
693: pay_emp_action_arch.set_error_message(lv_error_message);
694:
695: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
696: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
697: hr_utility.raise_error;
698:
699: END populate_elements;

Line 696: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

692: lv_error_message :=
693: pay_emp_action_arch.set_error_message(lv_error_message);
694:
695: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
696: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
697: hr_utility.raise_error;
698:
699: END populate_elements;
700:

Line 697: hr_utility.raise_error;

693: pay_emp_action_arch.set_error_message(lv_error_message);
694:
695: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
696: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
697: hr_utility.raise_error;
698:
699: END populate_elements;
700:
701: /******************************************************************

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

800: lv_is_element_archived := 'N';
801: lv_procedure_name := '.get_missing_xfr_info';
802:
803: ln_step := 1;
804: hr_utility.set_location(gv_package || lv_procedure_name, 10);
805: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
806: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
807: hr_utility.trace('p_last_pymt_action_id ='|| p_last_pymt_action_id );
808: hr_utility.trace('p_last_pymt_eff_date=' || p_last_pymt_eff_date);

Line 805: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);

801: lv_procedure_name := '.get_missing_xfr_info';
802:
803: ln_step := 1;
804: hr_utility.set_location(gv_package || lv_procedure_name, 10);
805: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
806: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
807: hr_utility.trace('p_last_pymt_action_id ='|| p_last_pymt_action_id );
808: hr_utility.trace('p_last_pymt_eff_date=' || p_last_pymt_eff_date);
809:

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

802:
803: ln_step := 1;
804: hr_utility.set_location(gv_package || lv_procedure_name, 10);
805: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
806: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
807: hr_utility.trace('p_last_pymt_action_id ='|| p_last_pymt_action_id );
808: hr_utility.trace('p_last_pymt_eff_date=' || p_last_pymt_eff_date);
809:
810: ln_step := 2;

Line 807: hr_utility.trace('p_last_pymt_action_id ='|| p_last_pymt_action_id );

803: ln_step := 1;
804: hr_utility.set_location(gv_package || lv_procedure_name, 10);
805: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
806: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
807: hr_utility.trace('p_last_pymt_action_id ='|| p_last_pymt_action_id );
808: hr_utility.trace('p_last_pymt_eff_date=' || p_last_pymt_eff_date);
809:
810: ln_step := 2;
811: OPEN c_business_grp_id;

Line 808: hr_utility.trace('p_last_pymt_eff_date=' || p_last_pymt_eff_date);

804: hr_utility.set_location(gv_package || lv_procedure_name, 10);
805: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
806: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
807: hr_utility.trace('p_last_pymt_action_id ='|| p_last_pymt_action_id );
808: hr_utility.trace('p_last_pymt_eff_date=' || p_last_pymt_eff_date);
809:
810: ln_step := 2;
811: OPEN c_business_grp_id;
812: FETCH c_business_grp_id INTO lv_business_grp_id;

Line 833: hr_utility.set_location(gv_package || lv_procedure_name, 15);

829: ln_element_type_id,
830: ln_processing_priority,
831: lv_element_classification_name;
832: IF c_prev_elements_RR%NOTFOUND THEN
833: hr_utility.set_location(gv_package || lv_procedure_name, 15);
834: EXIT;
835: END IF;
836: hr_utility.set_location(gv_package || lv_procedure_name, 20);
837: ln_step := 3;

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

832: IF c_prev_elements_RR%NOTFOUND THEN
833: hr_utility.set_location(gv_package || lv_procedure_name, 15);
834: EXIT;
835: END IF;
836: hr_utility.set_location(gv_package || lv_procedure_name, 20);
837: ln_step := 3;
838: IF ln_primary_balance_id IS NULL THEN
839: lv_error_message := 'Primary Balance not exist for the Element "'
840: || lv_reporting_name ||'"';

Line 843: hr_utility.raise_error;

839: lv_error_message := 'Primary Balance not exist for the Element "'
840: || lv_reporting_name ||'"';
841:
842: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
843: hr_utility.raise_error;
844: END IF;
845:
846: IF lv_element_classification_name IN ('Voluntary Deductions'
847: , 'Tax Deductions'

Line 850: hr_utility.trace('lv_element_classification_name TAXES YES '||lv_element_classification_name);

846: IF lv_element_classification_name IN ('Voluntary Deductions'
847: , 'Tax Deductions'
848: , 'Pre-Tax Deductions'
849: , 'Involuntary Deductions') THEN
850: hr_utility.trace('lv_element_classification_name TAXES YES '||lv_element_classification_name);
851: ln_hours_balance_id := NULL;
852: END IF;
853:
854: ln_payments_amount := 0;

Line 857: hr_utility.trace('Missing ln_primary_balance_id '||ln_primary_balance_id);

853:
854: ln_payments_amount := 0;
855:
856: ln_step := 4;
857: hr_utility.trace('Missing ln_primary_balance_id '||ln_primary_balance_id);
858: /*Checking whether element is present in current run*/
859: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
860: FOR i IN pay_ac_action_arch.emp_elements_tab.first..
861: pay_ac_action_arch.emp_elements_tab.last LOOP

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

861: pay_ac_action_arch.emp_elements_tab.last LOOP
862: IF pay_ac_action_arch.emp_elements_tab(i).element_type_id
863: = ln_element_type_id THEN
864: lv_is_element_archived := 'Y';
865: hr_utility.set_location(gv_package || lv_procedure_name, 30);
866: hr_utility.trace('lv_is_element_archived YES '||lv_is_element_archived);
867: EXIT;
868: END IF;
869: END LOOP;

Line 866: hr_utility.trace('lv_is_element_archived YES '||lv_is_element_archived);

862: IF pay_ac_action_arch.emp_elements_tab(i).element_type_id
863: = ln_element_type_id THEN
864: lv_is_element_archived := 'Y';
865: hr_utility.set_location(gv_package || lv_procedure_name, 30);
866: hr_utility.trace('lv_is_element_archived YES '||lv_is_element_archived);
867: EXIT;
868: END IF;
869: END LOOP;
870: END IF;

Line 874: hr_utility.trace('lv_is_element_archived NO '||lv_is_element_archived);

870: END IF;
871: ln_step := 5;
872:
873: IF lv_is_element_archived = 'N' THEN
874: hr_utility.trace('lv_is_element_archived NO '||lv_is_element_archived);
875: /* populate the extra element table */
876: ln_step := 6;
877: ln_index := pay_ac_action_arch.emp_elements_tab.count;
878: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id

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

891: pay_emp_action_arch.get_defined_balance_id
892: (ln_primary_balance_id,
893: gv_ytd_balance_dimension,
894: p_legislation_code);
895: hr_utility.set_location(gv_package || lv_procedure_name, 60);
896: IF ln_ytd_defined_balance_id IS NOT NULL THEN
897: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
898: ln_ytd_defined_balance_id,
899: p_ytd_balcall_aaid),0);

Line 900: hr_utility.set_location(gv_package || lv_procedure_name, 70);

896: IF ln_ytd_defined_balance_id IS NOT NULL THEN
897: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
898: ln_ytd_defined_balance_id,
899: p_ytd_balcall_aaid),0);
900: hr_utility.set_location(gv_package || lv_procedure_name, 70);
901: ELSE
902: hr_utility.trace('YTD Dimension is not set for Primary balance');
903: hr_utility.trace('Primary balance ID '||ln_primary_balance_id);
904: hr_utility.trace('YTD Balance Dimensions '||gv_ytd_balance_dimension);

Line 902: hr_utility.trace('YTD Dimension is not set for Primary balance');

898: ln_ytd_defined_balance_id,
899: p_ytd_balcall_aaid),0);
900: hr_utility.set_location(gv_package || lv_procedure_name, 70);
901: ELSE
902: hr_utility.trace('YTD Dimension is not set for Primary balance');
903: hr_utility.trace('Primary balance ID '||ln_primary_balance_id);
904: hr_utility.trace('YTD Balance Dimensions '||gv_ytd_balance_dimension);
905:
906:

Line 903: hr_utility.trace('Primary balance ID '||ln_primary_balance_id);

899: p_ytd_balcall_aaid),0);
900: hr_utility.set_location(gv_package || lv_procedure_name, 70);
901: ELSE
902: hr_utility.trace('YTD Dimension is not set for Primary balance');
903: hr_utility.trace('Primary balance ID '||ln_primary_balance_id);
904: hr_utility.trace('YTD Balance Dimensions '||gv_ytd_balance_dimension);
905:
906:
907: lv_balance_name := pay_ip_utility.get_balance_name(ln_primary_balance_id);

Line 904: hr_utility.trace('YTD Balance Dimensions '||gv_ytd_balance_dimension);

900: hr_utility.set_location(gv_package || lv_procedure_name, 70);
901: ELSE
902: hr_utility.trace('YTD Dimension is not set for Primary balance');
903: hr_utility.trace('Primary balance ID '||ln_primary_balance_id);
904: hr_utility.trace('YTD Balance Dimensions '||gv_ytd_balance_dimension);
905:
906:
907: lv_balance_name := pay_ip_utility.get_balance_name(ln_primary_balance_id);
908: lv_error_message := 'Defined Balance for the combination "'

Line 912: hr_utility.raise_error;

908: lv_error_message := 'Defined Balance for the combination "'
909: || lv_balance_name ||'" and "'
910: ||gv_ytd_balance_dimension||'" not exist';
911: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
912: hr_utility.raise_error;
913: END IF;
914:
915: ln_step := 8;
916: IF ln_hours_balance_id IS NOT NULL THEN

Line 922: hr_utility.set_location(gv_package || lv_procedure_name, 80);

918: pay_emp_action_arch.get_defined_balance_id
919: (ln_hours_balance_id,
920: gv_ytd_balance_dimension,
921: p_legislation_code);
922: hr_utility.set_location(gv_package || lv_procedure_name, 80);
923: IF ln_ytd_hours_balance_id IS NOT NULL THEN
924: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
925: ln_ytd_hours_balance_id,
926: p_ytd_balcall_aaid),0);

Line 927: hr_utility.set_location(gv_package || lv_procedure_name, 90);

923: IF ln_ytd_hours_balance_id IS NOT NULL THEN
924: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
925: ln_ytd_hours_balance_id,
926: p_ytd_balcall_aaid),0);
927: hr_utility.set_location(gv_package || lv_procedure_name, 90);
928: ELSE
929:
930: lv_balance_name := pay_ip_utility.get_balance_name(ln_hours_balance_id);
931: lv_error_message := 'Defined Balance for the combination "'

Line 935: hr_utility.trace('YTD Dimension is not set for Primary Hours balance');

931: lv_error_message := 'Defined Balance for the combination "'
932: || lv_balance_name ||'" and "'
933: ||gv_ytd_balance_dimension||'" not exist';
934: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
935: hr_utility.trace('YTD Dimension is not set for Primary Hours balance');
936: hr_utility.raise_error;
937: END IF;
938: END IF; -- Hours
939:

Line 936: hr_utility.raise_error;

932: || lv_balance_name ||'" and "'
933: ||gv_ytd_balance_dimension||'" not exist';
934: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
935: hr_utility.trace('YTD Dimension is not set for Primary Hours balance');
936: hr_utility.raise_error;
937: END IF;
938: END IF; -- Hours
939:
940: hr_utility.set_location(gv_package || lv_procedure_name, 100);

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

936: hr_utility.raise_error;
937: END IF;
938: END IF; -- Hours
939:
940: hr_utility.set_location(gv_package || lv_procedure_name, 100);
941: ln_step := 9;
942: IF NVL(ln_ytd_amount, 0) <> 0 OR NVL(ln_payments_amount, 0) <> 0 THEN
943:
944: ln_index := pay_ac_action_arch.lrr_act_tab.count;

Line 945: hr_utility.trace('ln_index = ' || ln_index);

941: ln_step := 9;
942: IF NVL(ln_ytd_amount, 0) <> 0 OR NVL(ln_payments_amount, 0) <> 0 THEN
943:
944: ln_index := pay_ac_action_arch.lrr_act_tab.count;
945: hr_utility.trace('ln_index = ' || ln_index);
946:
947: IF lv_element_classification_name IN ('Earnings','Supplemental Earnings','Direct Payment',
948: 'Taxable Benefits','Employer Charges') THEN
949:

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

990: END LOOP;
991:
992: CLOSE c_prev_elements_RR;
993:
994: hr_utility.set_location(gv_package || lv_procedure_name, 150);
995:
996: ln_step := 11;
997:
998:

Line 1003: hr_utility.trace(lv_error_message || '-' || SQLERRM);

999: EXCEPTION
1000: WHEN OTHERS THEN
1001:
1002: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
1003: hr_utility.trace(lv_error_message || '-' || SQLERRM);
1004:
1005: lv_error_message :=
1006: pay_emp_action_arch.set_error_message(lv_error_message);
1007:

Line 1008: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

1004:
1005: lv_error_message :=
1006: pay_emp_action_arch.set_error_message(lv_error_message);
1007:
1008: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1009: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1010: hr_utility.raise_error;
1011:
1012: END get_missing_xfr_info;

Line 1009: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

1005: lv_error_message :=
1006: pay_emp_action_arch.set_error_message(lv_error_message);
1007:
1008: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1009: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1010: hr_utility.raise_error;
1011:
1012: END get_missing_xfr_info;
1013:

Line 1010: hr_utility.raise_error;

1006: pay_emp_action_arch.set_error_message(lv_error_message);
1007:
1008: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1009: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1010: hr_utility.raise_error;
1011:
1012: END get_missing_xfr_info;
1013:
1014:

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

1143: lv_action_info_category := 'IP DEDUCTIONS';
1144: lv_procedure_name := '.get_xfr_elements';
1145:
1146: ln_step:= 1;
1147: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1148: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
1149: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
1150: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
1151: hr_utility.trace('gv_multi_payroll_pymt = '||

Line 1148: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);

1144: lv_procedure_name := '.get_xfr_elements';
1145:
1146: ln_step:= 1;
1147: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1148: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
1149: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
1150: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
1151: hr_utility.trace('gv_multi_payroll_pymt = '||
1152: pay_emp_action_arch.gv_multi_payroll_pymt);

Line 1149: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );

1145:
1146: ln_step:= 1;
1147: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1148: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
1149: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
1150: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
1151: hr_utility.trace('gv_multi_payroll_pymt = '||
1152: pay_emp_action_arch.gv_multi_payroll_pymt);
1153: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);

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

1146: ln_step:= 1;
1147: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1148: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
1149: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
1150: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
1151: hr_utility.trace('gv_multi_payroll_pymt = '||
1152: pay_emp_action_arch.gv_multi_payroll_pymt);
1153: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);
1154:

Line 1151: hr_utility.trace('gv_multi_payroll_pymt = '||

1147: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1148: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
1149: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
1150: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
1151: hr_utility.trace('gv_multi_payroll_pymt = '||
1152: pay_emp_action_arch.gv_multi_payroll_pymt);
1153: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);
1154:
1155: cn_last_xfr_action_id := p_last_xfr_action_id;

Line 1153: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);

1149: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
1150: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
1151: hr_utility.trace('gv_multi_payroll_pymt = '||
1152: pay_emp_action_arch.gv_multi_payroll_pymt);
1153: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);
1154:
1155: cn_last_xfr_action_id := p_last_xfr_action_id;
1156: ln_payments_amount := 0;
1157:

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

1167: lv_reporting_name,
1168: ld_effective_date,
1169: ln_ytd_hours;
1170:
1171: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1172: IF c_last_xfr_elements%NOTFOUND THEN
1173: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1174: EXIT;
1175: END IF;

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

1169: ln_ytd_hours;
1170:
1171: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1172: IF c_last_xfr_elements%NOTFOUND THEN
1173: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1174: EXIT;
1175: END IF;
1176: lv_t_reporting_name := lv_reporting_name;
1177:

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

1176: lv_t_reporting_name := lv_reporting_name;
1177:
1178: ln_step := 3;
1179: IF ln_primary_balance_id IS NULL THEN
1180: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1181: OPEN c_get_balance(lv_t_reporting_name, p_business_grp_id, p_legislation_code);
1182: FETCH c_get_balance INTO ln_t_primary_balance_id;
1183: CLOSE c_get_balance;
1184: ln_primary_balance_id := ln_t_primary_balance_id;

Line 1187: hr_utility.trace('Primary balance is not present for element '||lv_reporting_name);

1183: CLOSE c_get_balance;
1184: ln_primary_balance_id := ln_t_primary_balance_id;
1185:
1186: IF ln_t_primary_balance_id IS NULL THEN
1187: hr_utility.trace('Primary balance is not present for element '||lv_reporting_name);
1188: lv_error_message := 'Primary Balance does not exist for the Element "'
1189: || lv_reporting_name ||'"';
1190: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
1191: hr_utility.raise_error;

Line 1191: hr_utility.raise_error;

1187: hr_utility.trace('Primary balance is not present for element '||lv_reporting_name);
1188: lv_error_message := 'Primary Balance does not exist for the Element "'
1189: || lv_reporting_name ||'"';
1190: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
1191: hr_utility.raise_error;
1192: END IF;
1193: END IF;
1194:
1195: hr_utility.trace('Reporting Name =' || lv_reporting_name);

Line 1195: hr_utility.trace('Reporting Name =' || lv_reporting_name);

1191: hr_utility.raise_error;
1192: END IF;
1193: END IF;
1194:
1195: hr_utility.trace('Reporting Name =' || lv_reporting_name);
1196: hr_utility.trace('JD Code =' || lv_jurisdiction_code);
1197:
1198: ln_step := 4;
1199:

Line 1196: hr_utility.trace('JD Code =' || lv_jurisdiction_code);

1192: END IF;
1193: END IF;
1194:
1195: hr_utility.trace('Reporting Name =' || lv_reporting_name);
1196: hr_utility.trace('JD Code =' || lv_jurisdiction_code);
1197:
1198: ln_step := 4;
1199:
1200: hr_utility.trace('p_assignment_id (current) = '||p_assignment_id);

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

1196: hr_utility.trace('JD Code =' || lv_jurisdiction_code);
1197:
1198: ln_step := 4;
1199:
1200: hr_utility.trace('p_assignment_id (current) = '||p_assignment_id);
1201: hr_utility.trace('ln_assignment_id (prev) = '||ln_assignment_id);
1202:
1203: IF ln_assignment_id = p_assignment_id THEN
1204: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN

Line 1201: hr_utility.trace('ln_assignment_id (prev) = '||ln_assignment_id);

1197:
1198: ln_step := 4;
1199:
1200: hr_utility.trace('p_assignment_id (current) = '||p_assignment_id);
1201: hr_utility.trace('ln_assignment_id (prev) = '||ln_assignment_id);
1202:
1203: IF ln_assignment_id = p_assignment_id THEN
1204: IF pay_ac_action_arch.emp_elements_tab.count > 0 THEN
1205: FOR i IN pay_ac_action_arch.emp_elements_tab.first..

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

1213: END IF;
1214:
1215: ln_step := 5;
1216: IF lv_is_element_archived = 'N' THEN
1217: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1218: /**************************************************************
1219: ** Check to see if the element is still effective
1220: ** the primary balance IS there before archiving
1221: ** the value when picking elements which have

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

1267: := pay_emp_action_arch.get_defined_balance_id
1268: (ln_primary_balance_id,
1269: gv_ytd_balance_dimension,
1270: p_legislation_code);
1271: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1272: IF ln_ytd_defined_balance_id IS NOT NULL THEN
1273: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
1274: ln_ytd_defined_balance_id,
1275: p_ytd_balcall_aaid),0);

Line 1277: hr_utility.trace('YTD Dimension is not set for Primary balance '||ln_ytd_defined_balance_id);

1273: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
1274: ln_ytd_defined_balance_id,
1275: p_ytd_balcall_aaid),0);
1276: ELSE
1277: hr_utility.trace('YTD Dimension is not set for Primary balance '||ln_ytd_defined_balance_id);
1278: hr_utility.trace('Primary balance ID '||ln_primary_balance_id);
1279: hr_utility.trace('YTD Balance Dimensions '||gv_ytd_balance_dimension);
1280:
1281: lv_balance_name := pay_ip_utility.get_balance_name(ln_primary_balance_id);

Line 1278: hr_utility.trace('Primary balance ID '||ln_primary_balance_id);

1274: ln_ytd_defined_balance_id,
1275: p_ytd_balcall_aaid),0);
1276: ELSE
1277: hr_utility.trace('YTD Dimension is not set for Primary balance '||ln_ytd_defined_balance_id);
1278: hr_utility.trace('Primary balance ID '||ln_primary_balance_id);
1279: hr_utility.trace('YTD Balance Dimensions '||gv_ytd_balance_dimension);
1280:
1281: lv_balance_name := pay_ip_utility.get_balance_name(ln_primary_balance_id);
1282: lv_error_message := 'Defined Balance for the combination "'

Line 1279: hr_utility.trace('YTD Balance Dimensions '||gv_ytd_balance_dimension);

1275: p_ytd_balcall_aaid),0);
1276: ELSE
1277: hr_utility.trace('YTD Dimension is not set for Primary balance '||ln_ytd_defined_balance_id);
1278: hr_utility.trace('Primary balance ID '||ln_primary_balance_id);
1279: hr_utility.trace('YTD Balance Dimensions '||gv_ytd_balance_dimension);
1280:
1281: lv_balance_name := pay_ip_utility.get_balance_name(ln_primary_balance_id);
1282: lv_error_message := 'Defined Balance for the combination "'
1283: || lv_balance_name ||'" and "'

Line 1286: hr_utility.raise_error;

1282: lv_error_message := 'Defined Balance for the combination "'
1283: || lv_balance_name ||'" and "'
1284: ||gv_ytd_balance_dimension||'" not exist';
1285: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
1286: hr_utility.raise_error;
1287: END IF;
1288: ln_step := 9;
1289: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1290: IF ln_hours_balance_id IS NOT NULL THEN

Line 1289: hr_utility.set_location(gv_package || lv_procedure_name, 70);

1285: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
1286: hr_utility.raise_error;
1287: END IF;
1288: ln_step := 9;
1289: hr_utility.set_location(gv_package || lv_procedure_name, 70);
1290: IF ln_hours_balance_id IS NOT NULL THEN
1291: ln_ytd_hours_balance_id
1292: := pay_emp_action_arch.get_defined_balance_id
1293: (ln_hours_balance_id,

Line 1296: hr_utility.set_location(gv_package || lv_procedure_name, 80);

1292: := pay_emp_action_arch.get_defined_balance_id
1293: (ln_hours_balance_id,
1294: gv_ytd_balance_dimension,
1295: p_legislation_code);
1296: hr_utility.set_location(gv_package || lv_procedure_name, 80);
1297: IF ln_ytd_hours_balance_id IS NOT NULL THEN
1298: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
1299: ln_ytd_hours_balance_id,
1300: p_ytd_balcall_aaid),0);

Line 1301: hr_utility.set_location(gv_package || lv_procedure_name, 90);

1297: IF ln_ytd_hours_balance_id IS NOT NULL THEN
1298: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
1299: ln_ytd_hours_balance_id,
1300: p_ytd_balcall_aaid),0);
1301: hr_utility.set_location(gv_package || lv_procedure_name, 90);
1302: ELSE
1303: hr_utility.trace('YTD Dimension is not set for Primary Hours balance');
1304: lv_balance_name := pay_ip_utility.get_balance_name(ln_hours_balance_id);
1305: lv_error_message := 'Defined Balance for the combination "'

Line 1303: hr_utility.trace('YTD Dimension is not set for Primary Hours balance');

1299: ln_ytd_hours_balance_id,
1300: p_ytd_balcall_aaid),0);
1301: hr_utility.set_location(gv_package || lv_procedure_name, 90);
1302: ELSE
1303: hr_utility.trace('YTD Dimension is not set for Primary Hours balance');
1304: lv_balance_name := pay_ip_utility.get_balance_name(ln_hours_balance_id);
1305: lv_error_message := 'Defined Balance for the combination "'
1306: || lv_balance_name ||'" and "'
1307: ||gv_ytd_balance_dimension||'" not exist';

Line 1309: hr_utility.raise_error;

1305: lv_error_message := 'Defined Balance for the combination "'
1306: || lv_balance_name ||'" and "'
1307: ||gv_ytd_balance_dimension||'" not exist';
1308: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
1309: hr_utility.raise_error;
1310: END IF;
1311: END IF;
1312:
1313: ln_step := 10;

Line 1314: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);

1310: END IF;
1311: END IF;
1312:
1313: ln_step := 10;
1314: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
1315: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
1316:
1317: IF NVL(ln_ytd_amount, 0) >0 OR NVL(ln_payments_amount, 0) >0 THEN
1318:

Line 1315: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);

1311: END IF;
1312:
1313: ln_step := 10;
1314: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
1315: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
1316:
1317: IF NVL(ln_ytd_amount, 0) >0 OR NVL(ln_payments_amount, 0) >0 THEN
1318:
1319: hr_utility.set_location(gv_package || lv_procedure_name, 100);

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

1315: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
1316:
1317: IF NVL(ln_ytd_amount, 0) >0 OR NVL(ln_payments_amount, 0) >0 THEN
1318:
1319: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1320: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1321: hr_utility.trace('ln_index = ' || ln_index);
1322: ln_step := 11;
1323: IF lv_element_classification_name IN ('Earnings',

Line 1321: hr_utility.trace('ln_index = ' || ln_index);

1317: IF NVL(ln_ytd_amount, 0) >0 OR NVL(ln_payments_amount, 0) >0 THEN
1318:
1319: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1320: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1321: hr_utility.trace('ln_index = ' || ln_index);
1322: ln_step := 11;
1323: IF lv_element_classification_name IN ('Earnings',
1324: 'Supplemental Earnings','Direct Payment',
1325: 'Taxable Benefits','Employer Charges') THEN

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

1371: END LOOP;
1372:
1373: CLOSE c_last_xfr_elements;
1374:
1375: hr_utility.set_location(gv_package || lv_procedure_name, 110);
1376: ln_step := 13;
1377:
1378:
1379:

Line 1383: hr_utility.trace(lv_error_message || '-' || SQLERRM);

1379:
1380: EXCEPTION
1381: WHEN OTHERS THEN
1382: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
1383: hr_utility.trace(lv_error_message || '-' || SQLERRM);
1384:
1385: lv_error_message :=
1386: pay_emp_action_arch.set_error_message(lv_error_message);
1387:

Line 1388: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

1384:
1385: lv_error_message :=
1386: pay_emp_action_arch.set_error_message(lv_error_message);
1387:
1388: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1389: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1390: hr_utility.raise_error;
1391: END get_xfr_elements;
1392:

Line 1389: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

1385: lv_error_message :=
1386: pay_emp_action_arch.set_error_message(lv_error_message);
1387:
1388: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1389: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1390: hr_utility.raise_error;
1391: END get_xfr_elements;
1392:
1393:

Line 1390: hr_utility.raise_error;

1386: pay_emp_action_arch.set_error_message(lv_error_message);
1387:
1388: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1389: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1390: hr_utility.raise_error;
1391: END get_xfr_elements;
1392:
1393:
1394: /******************************************************************

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

1521: BEGIN
1522: lv_procedure_name := '.get_current_elements';
1523:
1524: ln_step := 1;
1525: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1526: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
1527: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1528: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1529: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);

Line 1526: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);

1522: lv_procedure_name := '.get_current_elements';
1523:
1524: ln_step := 1;
1525: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1526: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
1527: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1528: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1529: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1530: hr_utility.trace('p_legislation_code '|| p_legislation_code);

Line 1527: hr_utility.trace('p_assignment_id ' || p_assignment_id);

1523:
1524: ln_step := 1;
1525: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1526: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
1527: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1528: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1529: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1530: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1531: hr_utility.trace('p_curr_pymt_action_id '

Line 1528: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);

1524: ln_step := 1;
1525: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1526: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
1527: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1528: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1529: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1530: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1531: hr_utility.trace('p_curr_pymt_action_id '
1532: ||to_char(p_curr_pymt_action_id ));

Line 1529: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);

1525: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1526: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
1527: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1528: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1529: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1530: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1531: hr_utility.trace('p_curr_pymt_action_id '
1532: ||to_char(p_curr_pymt_action_id ));
1533: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);

Line 1530: hr_utility.trace('p_legislation_code '|| p_legislation_code);

1526: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
1527: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1528: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1529: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1530: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1531: hr_utility.trace('p_curr_pymt_action_id '
1532: ||to_char(p_curr_pymt_action_id ));
1533: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1534: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);

Line 1531: hr_utility.trace('p_curr_pymt_action_id '

1527: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1528: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1529: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1530: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1531: hr_utility.trace('p_curr_pymt_action_id '
1532: ||to_char(p_curr_pymt_action_id ));
1533: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1534: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
1535: hr_utility.trace('p_curr_pymt_eff_date' ||p_curr_pymt_eff_date);

Line 1533: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);

1529: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1530: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1531: hr_utility.trace('p_curr_pymt_action_id '
1532: ||to_char(p_curr_pymt_action_id ));
1533: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1534: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
1535: hr_utility.trace('p_curr_pymt_eff_date' ||p_curr_pymt_eff_date);
1536: hr_utility.trace('p_action_type ' ||p_action_type);
1537: hr_utility.set_location(gv_package || lv_procedure_name, 20);

Line 1534: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);

1530: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1531: hr_utility.trace('p_curr_pymt_action_id '
1532: ||to_char(p_curr_pymt_action_id ));
1533: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1534: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
1535: hr_utility.trace('p_curr_pymt_eff_date' ||p_curr_pymt_eff_date);
1536: hr_utility.trace('p_action_type ' ||p_action_type);
1537: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1538:

Line 1535: hr_utility.trace('p_curr_pymt_eff_date' ||p_curr_pymt_eff_date);

1531: hr_utility.trace('p_curr_pymt_action_id '
1532: ||to_char(p_curr_pymt_action_id ));
1533: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1534: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
1535: hr_utility.trace('p_curr_pymt_eff_date' ||p_curr_pymt_eff_date);
1536: hr_utility.trace('p_action_type ' ||p_action_type);
1537: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1538:
1539: lv_run_bal_status := NULL;

Line 1536: hr_utility.trace('p_action_type ' ||p_action_type);

1532: ||to_char(p_curr_pymt_action_id ));
1533: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1534: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
1535: hr_utility.trace('p_curr_pymt_eff_date' ||p_curr_pymt_eff_date);
1536: hr_utility.trace('p_action_type ' ||p_action_type);
1537: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1538:
1539: lv_run_bal_status := NULL;
1540:

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

1533: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1534: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
1535: hr_utility.trace('p_curr_pymt_eff_date' ||p_curr_pymt_eff_date);
1536: hr_utility.trace('p_action_type ' ||p_action_type);
1537: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1538:
1539: lv_run_bal_status := NULL;
1540:
1541: ln_step := 2;

Line 1550: hr_utility.trace('101: lv_run_bal_status '||lv_run_bal_status);

1546: OPEN c_business_grp_id;
1547: FETCH c_business_grp_id INTO lv_business_grp_id;
1548: CLOSE c_business_grp_id;
1549:
1550: hr_utility.trace('101: lv_run_bal_status '||lv_run_bal_status);
1551: hr_utility.trace('p_sepchk_flag '||p_sepchk_flag);
1552: ln_step := 3;
1553: IF p_sepchk_flag = 'Y' THEN
1554: hr_utility.trace('102: lv_run_bal_status '||lv_run_bal_status);

Line 1551: hr_utility.trace('p_sepchk_flag '||p_sepchk_flag);

1547: FETCH c_business_grp_id INTO lv_business_grp_id;
1548: CLOSE c_business_grp_id;
1549:
1550: hr_utility.trace('101: lv_run_bal_status '||lv_run_bal_status);
1551: hr_utility.trace('p_sepchk_flag '||p_sepchk_flag);
1552: ln_step := 3;
1553: IF p_sepchk_flag = 'Y' THEN
1554: hr_utility.trace('102: lv_run_bal_status '||lv_run_bal_status);
1555:

Line 1554: hr_utility.trace('102: lv_run_bal_status '||lv_run_bal_status);

1550: hr_utility.trace('101: lv_run_bal_status '||lv_run_bal_status);
1551: hr_utility.trace('p_sepchk_flag '||p_sepchk_flag);
1552: ln_step := 3;
1553: IF p_sepchk_flag = 'Y' THEN
1554: hr_utility.trace('102: lv_run_bal_status '||lv_run_bal_status);
1555:
1556: OPEN c_cur_sp_action_elements_RR(p_curr_pymt_action_id,
1557: p_assignment_id,
1558: lv_business_grp_id);

Line 1561: hr_utility.trace('103: lv_run_bal_status '||lv_run_bal_status);

1557: p_assignment_id,
1558: lv_business_grp_id);
1559:
1560: ELSIF p_sepchk_flag = 'N' THEN
1561: hr_utility.trace('103: lv_run_bal_status '||lv_run_bal_status);
1562: hr_utility.trace('104: ln_ytd_action_sequence '||ln_ytd_action_sequence);
1563:
1564: OPEN c_cur_action_elements_RR(p_curr_pymt_action_id,
1565: p_assignment_id,

Line 1562: hr_utility.trace('104: ln_ytd_action_sequence '||ln_ytd_action_sequence);

1558: lv_business_grp_id);
1559:
1560: ELSIF p_sepchk_flag = 'N' THEN
1561: hr_utility.trace('103: lv_run_bal_status '||lv_run_bal_status);
1562: hr_utility.trace('104: ln_ytd_action_sequence '||ln_ytd_action_sequence);
1563:
1564: OPEN c_cur_action_elements_RR(p_curr_pymt_action_id,
1565: p_assignment_id,
1566: ln_ytd_action_sequence,

Line 1574: hr_utility.trace('105: lv_run_bal_status '||lv_run_bal_status);

1570: ln_step := 4;
1571: LOOP
1572: IF p_sepchk_flag = 'Y' THEN
1573:
1574: hr_utility.trace('105: lv_run_bal_status '||lv_run_bal_status);
1575: FETCH c_cur_sp_action_elements_RR INTO
1576: lv_reporting_name,
1577: ln_primary_balance_id,
1578: ln_hours_balance_id,

Line 1584: hr_utility.set_location(gv_package || lv_procedure_name, 25);

1580: ln_processing_priority,
1581: lv_element_classification_name;
1582:
1583: IF c_cur_sp_action_elements_RR%NOTFOUND THEN
1584: hr_utility.set_location(gv_package || lv_procedure_name, 25);
1585: EXIT;
1586: END IF;
1587: ELSIF p_sepchk_flag = 'N' THEN
1588:

Line 1589: hr_utility.trace('106: lv_run_bal_status '||lv_run_bal_status);

1585: EXIT;
1586: END IF;
1587: ELSIF p_sepchk_flag = 'N' THEN
1588:
1589: hr_utility.trace('106: lv_run_bal_status '||lv_run_bal_status);
1590: FETCH c_cur_action_elements_RR INTO
1591: lv_reporting_name,
1592: ln_primary_balance_id,
1593: ln_hours_balance_id,

Line 1599: hr_utility.set_location(gv_package || lv_procedure_name, 33);

1595: ln_processing_priority,
1596: lv_element_classification_name;
1597:
1598: IF c_cur_action_elements_RR%NOTFOUND THEN
1599: hr_utility.set_location(gv_package || lv_procedure_name, 33);
1600: EXIT;
1601: END IF;
1602:
1603: END IF;

Line 1607: hr_utility.trace('Primary balance is not present for element '||lv_reporting_name);

1603: END IF;
1604:
1605: ln_step := 5;
1606: IF ln_primary_balance_id IS NULL THEN
1607: hr_utility.trace('Primary balance is not present for element '||lv_reporting_name);
1608: lv_error_message := 'Primary Balance not exist for the Element "'
1609: || lv_reporting_name ||'"';
1610:
1611: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);

Line 1612: hr_utility.raise_error;

1608: lv_error_message := 'Primary Balance not exist for the Element "'
1609: || lv_reporting_name ||'"';
1610:
1611: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
1612: hr_utility.raise_error;
1613: END IF;
1614:
1615: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1616: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);

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

1611: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
1612: hr_utility.raise_error;
1613: END IF;
1614:
1615: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1616: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
1617:
1618: ln_step := 6;
1619: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;

Line 1616: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);

1612: hr_utility.raise_error;
1613: END IF;
1614:
1615: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1616: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
1617:
1618: ln_step := 6;
1619: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
1620: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id

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

1625: := ln_hours_balance_id;
1626: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
1627: := ln_element_type_id;
1628:
1629: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1630: ln_step := 7;
1631:
1632: populate_elements(p_xfr_action_id => p_xfr_action_id
1633: ,p_pymt_assignment_action_id => p_curr_pymt_action_id

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

1655: IF c_cur_action_elements_RR%ISOPEN THEN
1656: CLOSE c_cur_action_elements_RR;
1657: END IF;
1658:
1659: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1660: ln_step := 9;
1661:
1662: EXCEPTION
1663: WHEN OTHERS THEN

Line 1665: hr_utility.trace(lv_error_message || '-' || SQLERRM);

1661:
1662: EXCEPTION
1663: WHEN OTHERS THEN
1664: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
1665: hr_utility.trace(lv_error_message || '-' || SQLERRM);
1666:
1667: lv_error_message :=
1668: pay_emp_action_arch.set_error_message(lv_error_message);
1669:

Line 1670: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

1666:
1667: lv_error_message :=
1668: pay_emp_action_arch.set_error_message(lv_error_message);
1669:
1670: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1671: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1672: hr_utility.raise_error;
1673:
1674: END get_current_elements;

Line 1671: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

1667: lv_error_message :=
1668: pay_emp_action_arch.set_error_message(lv_error_message);
1669:
1670: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1671: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1672: hr_utility.raise_error;
1673:
1674: END get_current_elements;
1675:

Line 1672: hr_utility.raise_error;

1668: pay_emp_action_arch.set_error_message(lv_error_message);
1669:
1670: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1671: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1672: hr_utility.raise_error;
1673:
1674: END get_current_elements;
1675:
1676: /******************************************************************

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

1887:
1888: BEGIN
1889:
1890: lv_procedure_name := '.archive_elements';
1891: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1892: ln_step := 1;
1893: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
1894: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1895: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);

Line 1893: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);

1889:
1890: lv_procedure_name := '.archive_elements';
1891: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1892: ln_step := 1;
1893: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
1894: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1895: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1896: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1897: hr_utility.trace('p_legislation_code '|| p_legislation_code);

Line 1894: hr_utility.trace('p_assignment_id ' || p_assignment_id);

1890: lv_procedure_name := '.archive_elements';
1891: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1892: ln_step := 1;
1893: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
1894: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1895: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1896: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1897: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1898: hr_utility.trace('p_curr_pymt_action_id '

Line 1895: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);

1891: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1892: ln_step := 1;
1893: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
1894: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1895: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1896: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1897: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1898: hr_utility.trace('p_curr_pymt_action_id '
1899: ||to_char(p_curr_pymt_action_id ));

Line 1896: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);

1892: ln_step := 1;
1893: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
1894: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1895: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1896: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1897: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1898: hr_utility.trace('p_curr_pymt_action_id '
1899: ||to_char(p_curr_pymt_action_id ));
1900: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);

Line 1897: hr_utility.trace('p_legislation_code '|| p_legislation_code);

1893: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
1894: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1895: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1896: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1897: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1898: hr_utility.trace('p_curr_pymt_action_id '
1899: ||to_char(p_curr_pymt_action_id ));
1900: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1901: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);

Line 1898: hr_utility.trace('p_curr_pymt_action_id '

1894: hr_utility.trace('p_assignment_id ' || p_assignment_id);
1895: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
1896: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1897: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1898: hr_utility.trace('p_curr_pymt_action_id '
1899: ||to_char(p_curr_pymt_action_id ));
1900: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1901: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
1902: hr_utility.trace('p_curr_pymt_action_id ' ||p_curr_pymt_action_id);

Line 1900: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);

1896: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
1897: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1898: hr_utility.trace('p_curr_pymt_action_id '
1899: ||to_char(p_curr_pymt_action_id ));
1900: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1901: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
1902: hr_utility.trace('p_curr_pymt_action_id ' ||p_curr_pymt_action_id);
1903: hr_utility.trace('p_legislation_code ' ||p_legislation_code);
1904: hr_utility.trace('p_sepchk_flag ' ||p_sepchk_flag);

Line 1901: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);

1897: hr_utility.trace('p_legislation_code '|| p_legislation_code);
1898: hr_utility.trace('p_curr_pymt_action_id '
1899: ||to_char(p_curr_pymt_action_id ));
1900: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1901: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
1902: hr_utility.trace('p_curr_pymt_action_id ' ||p_curr_pymt_action_id);
1903: hr_utility.trace('p_legislation_code ' ||p_legislation_code);
1904: hr_utility.trace('p_sepchk_flag ' ||p_sepchk_flag);
1905:

Line 1902: hr_utility.trace('p_curr_pymt_action_id ' ||p_curr_pymt_action_id);

1898: hr_utility.trace('p_curr_pymt_action_id '
1899: ||to_char(p_curr_pymt_action_id ));
1900: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1901: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
1902: hr_utility.trace('p_curr_pymt_action_id ' ||p_curr_pymt_action_id);
1903: hr_utility.trace('p_legislation_code ' ||p_legislation_code);
1904: hr_utility.trace('p_sepchk_flag ' ||p_sepchk_flag);
1905:
1906: hr_utility.set_location(gv_package || lv_procedure_name, 20);

Line 1903: hr_utility.trace('p_legislation_code ' ||p_legislation_code);

1899: ||to_char(p_curr_pymt_action_id ));
1900: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1901: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
1902: hr_utility.trace('p_curr_pymt_action_id ' ||p_curr_pymt_action_id);
1903: hr_utility.trace('p_legislation_code ' ||p_legislation_code);
1904: hr_utility.trace('p_sepchk_flag ' ||p_sepchk_flag);
1905:
1906: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1907:

Line 1904: hr_utility.trace('p_sepchk_flag ' ||p_sepchk_flag);

1900: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
1901: hr_utility.trace('p_pymt_balcall_aaid ' ||p_pymt_balcall_aaid);
1902: hr_utility.trace('p_curr_pymt_action_id ' ||p_curr_pymt_action_id);
1903: hr_utility.trace('p_legislation_code ' ||p_legislation_code);
1904: hr_utility.trace('p_sepchk_flag ' ||p_sepchk_flag);
1905:
1906: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1907:
1908: ln_step := 2;

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

1902: hr_utility.trace('p_curr_pymt_action_id ' ||p_curr_pymt_action_id);
1903: hr_utility.trace('p_legislation_code ' ||p_legislation_code);
1904: hr_utility.trace('p_sepchk_flag ' ||p_sepchk_flag);
1905:
1906: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1907:
1908: ln_step := 2;
1909: IF p_sepchk_flag = 'Y' THEN
1910: OPEN csr_std_elements_sp(p_curr_pymt_action_id,

Line 1922: hr_utility.trace('201 p_sepchk_flag '||p_sepchk_flag);

1918:
1919: ln_step := 3;
1920: LOOP
1921: IF p_sepchk_flag = 'Y' THEN
1922: hr_utility.trace('201 p_sepchk_flag '||p_sepchk_flag);
1923: FETCH csr_std_elements_sp INTO
1924: ln_asg_action_id,
1925: lv_classification_name,
1926: lv_element_category,

Line 1932: hr_utility.trace('201 ln_asg_action_id SP '||ln_asg_action_id);

1928: ln_amount,
1929: ln_hours,
1930: ln_element_type_id;
1931:
1932: hr_utility.trace('201 ln_asg_action_id SP '||ln_asg_action_id);
1933:
1934: IF csr_std_elements_sp%NOTFOUND THEN
1935: hr_utility.set_location(gv_package || lv_procedure_name, 25);
1936: EXIT;

Line 1935: hr_utility.set_location(gv_package || lv_procedure_name, 25);

1931:
1932: hr_utility.trace('201 ln_asg_action_id SP '||ln_asg_action_id);
1933:
1934: IF csr_std_elements_sp%NOTFOUND THEN
1935: hr_utility.set_location(gv_package || lv_procedure_name, 25);
1936: EXIT;
1937: END IF;
1938: ELSE
1939: FETCH csr_std_elements INTO

Line 1948: hr_utility.trace('202 ln_asg_action_id NORMAL '||ln_asg_action_id);

1944: ln_amount,
1945: ln_hours,
1946: ln_element_type_id;
1947:
1948: hr_utility.trace('202 ln_asg_action_id NORMAL '||ln_asg_action_id);
1949: IF csr_std_elements%NOTFOUND THEN
1950: hr_utility.set_location(gv_package || lv_procedure_name, 35);
1951: EXIT;
1952: END IF;

Line 1950: hr_utility.set_location(gv_package || lv_procedure_name, 35);

1946: ln_element_type_id;
1947:
1948: hr_utility.trace('202 ln_asg_action_id NORMAL '||ln_asg_action_id);
1949: IF csr_std_elements%NOTFOUND THEN
1950: hr_utility.set_location(gv_package || lv_procedure_name, 35);
1951: EXIT;
1952: END IF;
1953: END IF;
1954: ln_step := 4;

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

1951: EXIT;
1952: END IF;
1953: END IF;
1954: ln_step := 4;
1955: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1956:
1957: pay_action_information_api.create_action_information
1958: (
1959: p_action_information_id => l_action_info_id

Line 1979: hr_utility.trace('Element Name '||lv_reporting_name);

1975: ,p_action_information11 => fnd_number.number_to_canonical(ln_hours) --Current Hours
1976: ,p_action_information12 => NULL --ytd hours
1977: );
1978:
1979: hr_utility.trace('Element Name '||lv_reporting_name);
1980: hr_utility.trace('Amount '||fnd_number.number_to_canonical(ln_amount));
1981: ln_step := 5;
1982: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1983: END LOOP;

Line 1980: hr_utility.trace('Amount '||fnd_number.number_to_canonical(ln_amount));

1976: ,p_action_information12 => NULL --ytd hours
1977: );
1978:
1979: hr_utility.trace('Element Name '||lv_reporting_name);
1980: hr_utility.trace('Amount '||fnd_number.number_to_canonical(ln_amount));
1981: ln_step := 5;
1982: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1983: END LOOP;
1984:

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

1978:
1979: hr_utility.trace('Element Name '||lv_reporting_name);
1980: hr_utility.trace('Amount '||fnd_number.number_to_canonical(ln_amount));
1981: ln_step := 5;
1982: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1983: END LOOP;
1984:
1985: IF p_sepchk_flag = 'Y' THEN
1986: CLOSE csr_std_elements_sp;

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

1987: ELSE
1988: CLOSE csr_std_elements;
1989: END IF;
1990: ln_step := 6;
1991: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1992: EXCEPTION
1993: WHEN OTHERS THEN
1994: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
1995: hr_utility.trace(lv_error_message || '-' || SQLERRM);

Line 1995: hr_utility.trace(lv_error_message || '-' || SQLERRM);

1991: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1992: EXCEPTION
1993: WHEN OTHERS THEN
1994: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
1995: hr_utility.trace(lv_error_message || '-' || SQLERRM);
1996:
1997: lv_error_message :=
1998: pay_emp_action_arch.set_error_message(lv_error_message);
1999: hr_utility.raise_error;

Line 1999: hr_utility.raise_error;

1995: hr_utility.trace(lv_error_message || '-' || SQLERRM);
1996:
1997: lv_error_message :=
1998: pay_emp_action_arch.set_error_message(lv_error_message);
1999: hr_utility.raise_error;
2000:
2001: END; -- archive_elements
2002:
2003: /******************************************************************

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

2092: lv_run_bal_status := NULL;
2093: lv_is_element_archived := 'N';
2094: lv_procedure_name := '.first_time_process';
2095:
2096: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2097: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
2098: hr_utility.trace('p_assignment_id '|| p_assignment_id);
2099: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
2100: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);

Line 2097: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);

2093: lv_is_element_archived := 'N';
2094: lv_procedure_name := '.first_time_process';
2095:
2096: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2097: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
2098: hr_utility.trace('p_assignment_id '|| p_assignment_id);
2099: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
2100: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2101: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);

Line 2098: hr_utility.trace('p_assignment_id '|| p_assignment_id);

2094: lv_procedure_name := '.first_time_process';
2095:
2096: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2097: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
2098: hr_utility.trace('p_assignment_id '|| p_assignment_id);
2099: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
2100: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2101: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2102: hr_utility.trace('p_legislation_code ' || p_legislation_code);

Line 2099: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);

2095:
2096: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2097: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
2098: hr_utility.trace('p_assignment_id '|| p_assignment_id);
2099: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
2100: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2101: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2102: hr_utility.trace('p_legislation_code ' || p_legislation_code);
2103: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);

Line 2100: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);

2096: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2097: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
2098: hr_utility.trace('p_assignment_id '|| p_assignment_id);
2099: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
2100: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2101: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2102: hr_utility.trace('p_legislation_code ' || p_legislation_code);
2103: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2104: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);

Line 2101: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);

2097: hr_utility.trace('p_xfr_action_id' || p_xfr_action_id);
2098: hr_utility.trace('p_assignment_id '|| p_assignment_id);
2099: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
2100: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2101: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2102: hr_utility.trace('p_legislation_code ' || p_legislation_code);
2103: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2104: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
2105: hr_utility.trace('p_curr_pymt_action_id '

Line 2102: hr_utility.trace('p_legislation_code ' || p_legislation_code);

2098: hr_utility.trace('p_assignment_id '|| p_assignment_id);
2099: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
2100: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2101: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2102: hr_utility.trace('p_legislation_code ' || p_legislation_code);
2103: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2104: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
2105: hr_utility.trace('p_curr_pymt_action_id '
2106: ||to_char(p_curr_pymt_action_id ));

Line 2103: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);

2099: hr_utility.trace('p_curr_eff_date '|| p_curr_eff_date);
2100: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2101: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2102: hr_utility.trace('p_legislation_code ' || p_legislation_code);
2103: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2104: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
2105: hr_utility.trace('p_curr_pymt_action_id '
2106: ||to_char(p_curr_pymt_action_id ));
2107:

Line 2104: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);

2100: hr_utility.trace('p_tax_unit_id ' || p_tax_unit_id);
2101: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2102: hr_utility.trace('p_legislation_code ' || p_legislation_code);
2103: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2104: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
2105: hr_utility.trace('p_curr_pymt_action_id '
2106: ||to_char(p_curr_pymt_action_id ));
2107:
2108: hr_utility.set_location(gv_package || lv_procedure_name, 20);

Line 2105: hr_utility.trace('p_curr_pymt_action_id '

2101: hr_utility.trace('p_sepchk_flag ' || p_sepchk_flag);
2102: hr_utility.trace('p_legislation_code ' || p_legislation_code);
2103: hr_utility.trace('p_ytd_balcall_aaid ' || p_ytd_balcall_aaid);
2104: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
2105: hr_utility.trace('p_curr_pymt_action_id '
2106: ||to_char(p_curr_pymt_action_id ));
2107:
2108: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2109: get_current_elements(p_xfr_action_id => p_xfr_action_id

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

2104: hr_utility.trace('p_pymt_balcall_aaid ' || p_pymt_balcall_aaid);
2105: hr_utility.trace('p_curr_pymt_action_id '
2106: ||to_char(p_curr_pymt_action_id ));
2107:
2108: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2109: get_current_elements(p_xfr_action_id => p_xfr_action_id
2110: ,p_curr_pymt_action_id => p_curr_pymt_action_id
2111: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
2112: ,p_assignment_id => p_assignment_id

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

2114: ,p_sepchk_flag => p_sepchk_flag
2115: ,p_pymt_balcall_aaid => p_pymt_balcall_aaid
2116: ,p_ytd_balcall_aaid => p_ytd_balcall_aaid
2117: ,p_legislation_code => p_legislation_code);
2118: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2119:
2120: OPEN c_business_grp_id;
2121: FETCH c_business_grp_id INTO lv_business_grp_id;
2122: CLOSE c_business_grp_id;

Line 2145: hr_utility.set_location(gv_package || lv_procedure_name, 45);

2141: ln_processing_priority,
2142: lv_element_classification_name;
2143:
2144: IF c_get_elements_processed%NOTFOUND THEN
2145: hr_utility.set_location(gv_package || lv_procedure_name, 45);
2146: EXIT;
2147: END IF;
2148:
2149: IF ln_primary_balance_id IS NULL THEN

Line 2150: hr_utility.trace('Primary balance is not present for element '||lv_reporting_name);

2146: EXIT;
2147: END IF;
2148:
2149: IF ln_primary_balance_id IS NULL THEN
2150: hr_utility.trace('Primary balance is not present for element '||lv_reporting_name);
2151: lv_error_message := 'Primary Balance not exist for the Element "'
2152: || lv_reporting_name ||'"';
2153: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
2154: hr_utility.raise_error;

Line 2154: hr_utility.raise_error;

2150: hr_utility.trace('Primary balance is not present for element '||lv_reporting_name);
2151: lv_error_message := 'Primary Balance not exist for the Element "'
2152: || lv_reporting_name ||'"';
2153: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
2154: hr_utility.raise_error;
2155: END IF;
2156:
2157: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2158: hr_utility.trace('Reporting Name = '|| lv_reporting_name);

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

2153: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
2154: hr_utility.raise_error;
2155: END IF;
2156:
2157: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2158: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
2159: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
2160: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
2161: hr_utility.trace('Element classification = '|| lv_element_classification_name);

Line 2158: hr_utility.trace('Reporting Name = '|| lv_reporting_name);

2154: hr_utility.raise_error;
2155: END IF;
2156:
2157: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2158: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
2159: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
2160: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
2161: hr_utility.trace('Element classification = '|| lv_element_classification_name);
2162:

Line 2159: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);

2155: END IF;
2156:
2157: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2158: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
2159: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
2160: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
2161: hr_utility.trace('Element classification = '|| lv_element_classification_name);
2162:
2163: IF lv_element_classification_name IN ('Voluntary Deductions', 'Tax Deductions',

Line 2160: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);

2156:
2157: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2158: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
2159: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
2160: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
2161: hr_utility.trace('Element classification = '|| lv_element_classification_name);
2162:
2163: IF lv_element_classification_name IN ('Voluntary Deductions', 'Tax Deductions',
2164: 'Involuntary Deductions', 'Pre-Tax Deductions') THEN

Line 2161: hr_utility.trace('Element classification = '|| lv_element_classification_name);

2157: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2158: hr_utility.trace('Reporting Name = '|| lv_reporting_name);
2159: hr_utility.trace('Primary Bal id = '|| ln_primary_balance_id);
2160: hr_utility.trace('JD Code = ' || lv_jurisdiction_code);
2161: hr_utility.trace('Element classification = '|| lv_element_classification_name);
2162:
2163: IF lv_element_classification_name IN ('Voluntary Deductions', 'Tax Deductions',
2164: 'Involuntary Deductions', 'Pre-Tax Deductions') THEN
2165: ln_step := 3;

Line 2183: hr_utility.set_location(gv_package || lv_procedure_name, 65);

2179:
2180: IF pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
2181: = ln_primary_balance_id THEN
2182:
2183: hr_utility.set_location(gv_package || lv_procedure_name, 65);
2184: lv_is_element_archived := 'Y';
2185: EXIT;
2186: END IF;
2187: END LOOP;

Line 2192: hr_utility.set_location(gv_package || lv_procedure_name, 70);

2188: END IF;
2189:
2190: IF lv_is_element_archived = 'N' THEN
2191: ln_step := 5;
2192: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2193: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2194: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2195: := lv_reporting_name;
2196: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id

Line 2209: hr_utility.set_location(gv_package || lv_procedure_name, 80);

2205: /*****************************************************************
2206: ** The Payment Assignemnt Action is not passed to this procedure
2207: ** as we do not want to call the Payment Balance.
2208: *****************************************************************/
2209: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2210:
2211: ln_step := 6;
2212: populate_elements(p_xfr_action_id => p_xfr_action_id
2213: ,p_pymt_assignment_action_id => p_curr_pymt_action_id

Line 2240: hr_utility.set_location(gv_package || lv_procedure_name, 90);

2236: END LOOP;
2237:
2238: CLOSE c_get_elements_processed;
2239:
2240: hr_utility.set_location(gv_package || lv_procedure_name, 90);
2241:
2242:
2243: ln_step := 7;
2244:

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

2241:
2242:
2243: ln_step := 7;
2244:
2245: hr_utility.set_location(gv_package || lv_procedure_name, 110);
2246:
2247:
2248: EXCEPTION
2249: WHEN OTHERS THEN

Line 2252: hr_utility.trace(lv_error_message || '-' || SQLERRM);

2248: EXCEPTION
2249: WHEN OTHERS THEN
2250:
2251: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
2252: hr_utility.trace(lv_error_message || '-' || SQLERRM);
2253:
2254: lv_error_message :=
2255: pay_emp_action_arch.set_error_message(lv_error_message);
2256:

Line 2257: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

2253:
2254: lv_error_message :=
2255: pay_emp_action_arch.set_error_message(lv_error_message);
2256:
2257: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2258: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2259: hr_utility.raise_error;
2260:
2261: END first_time_process;

Line 2258: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

2254: lv_error_message :=
2255: pay_emp_action_arch.set_error_message(lv_error_message);
2256:
2257: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2258: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2259: hr_utility.raise_error;
2260:
2261: END first_time_process;
2262:

Line 2259: hr_utility.raise_error;

2255: pay_emp_action_arch.set_error_message(lv_error_message);
2256:
2257: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2258: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2259: hr_utility.raise_error;
2260:
2261: END first_time_process;
2262:
2263:

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

2287:
2288: BEGIN
2289: lv_procedure_name := '.range_code';
2290:
2291: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2292: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
2293: ,p_start_date => ld_start_date
2294: ,p_end_date => ld_end_date
2295: ,p_business_group_id => ln_business_group_id

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

2294: ,p_end_date => ld_end_date
2295: ,p_business_group_id => ln_business_group_id
2296: ,p_cons_set_id => ln_cons_set_id
2297: ,p_payroll_id => ln_payroll_id);
2298: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2299:
2300: lv_sql_string :=
2301: 'SELECT DISTINCT paf.person_id
2302: FROM pay_assignment_actions paa,

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

2331: AND ppa1.report_type = ''IP_PAYROLL_ARCHIVE'')
2332: AND :payroll_action_id > 0 -- Bug 4202702
2333: ORDER BY paf.person_id';
2334:
2335: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2336: p_sqlstr := lv_sql_string;
2337: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2338:
2339: END range_code;

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

2333: ORDER BY paf.person_id';
2334:
2335: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2336: p_sqlstr := lv_sql_string;
2337: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2338:
2339: END range_code;
2340:
2341:

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

2500: lv_procedure_name := '.assignment_action_code';
2501:
2502: ln_step := 1;
2503: pay_emp_action_arch.gv_error_message := NULL;
2504: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2505:
2506: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
2507: ,p_start_date => ld_start_date
2508: ,p_end_date => ld_end_date

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

2508: ,p_end_date => ld_end_date
2509: ,p_business_group_id => ln_business_group_id
2510: ,p_cons_set_id => ln_cons_set_id
2511: ,p_payroll_id => ln_payroll_id);
2512: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2513:
2514:
2515: lb_range_person := pay_ac_utility.range_person_on(
2516: p_report_type => 'IP_PAYROLL_ARCHIVE'

Line 2524: hr_utility.trace('p_payroll_action_id '||p_payroll_action_id);

2520:
2521:
2522: ln_step := 2;
2523: IF lb_range_person THEN
2524: hr_utility.trace('p_payroll_action_id '||p_payroll_action_id);
2525: hr_utility.trace('p_chunk '||p_chunk);
2526: hr_utility.trace('ln_cons_set_id '||ln_cons_set_id);
2527: hr_utility.trace('ln_payroll_id '||ln_payroll_id);
2528: hr_utility.trace('ln_business_group_id '||ln_business_group_id);

Line 2525: hr_utility.trace('p_chunk '||p_chunk);

2521:
2522: ln_step := 2;
2523: IF lb_range_person THEN
2524: hr_utility.trace('p_payroll_action_id '||p_payroll_action_id);
2525: hr_utility.trace('p_chunk '||p_chunk);
2526: hr_utility.trace('ln_cons_set_id '||ln_cons_set_id);
2527: hr_utility.trace('ln_payroll_id '||ln_payroll_id);
2528: hr_utility.trace('ln_business_group_id '||ln_business_group_id);
2529: hr_utility.trace('ln_business_group_id '||ln_business_group_id);

Line 2526: hr_utility.trace('ln_cons_set_id '||ln_cons_set_id);

2522: ln_step := 2;
2523: IF lb_range_person THEN
2524: hr_utility.trace('p_payroll_action_id '||p_payroll_action_id);
2525: hr_utility.trace('p_chunk '||p_chunk);
2526: hr_utility.trace('ln_cons_set_id '||ln_cons_set_id);
2527: hr_utility.trace('ln_payroll_id '||ln_payroll_id);
2528: hr_utility.trace('ln_business_group_id '||ln_business_group_id);
2529: hr_utility.trace('ln_business_group_id '||ln_business_group_id);
2530: OPEN c_get_arch_range_emp(p_payroll_action_id

Line 2527: hr_utility.trace('ln_payroll_id '||ln_payroll_id);

2523: IF lb_range_person THEN
2524: hr_utility.trace('p_payroll_action_id '||p_payroll_action_id);
2525: hr_utility.trace('p_chunk '||p_chunk);
2526: hr_utility.trace('ln_cons_set_id '||ln_cons_set_id);
2527: hr_utility.trace('ln_payroll_id '||ln_payroll_id);
2528: hr_utility.trace('ln_business_group_id '||ln_business_group_id);
2529: hr_utility.trace('ln_business_group_id '||ln_business_group_id);
2530: OPEN c_get_arch_range_emp(p_payroll_action_id
2531: ,p_chunk

Line 2528: hr_utility.trace('ln_business_group_id '||ln_business_group_id);

2524: hr_utility.trace('p_payroll_action_id '||p_payroll_action_id);
2525: hr_utility.trace('p_chunk '||p_chunk);
2526: hr_utility.trace('ln_cons_set_id '||ln_cons_set_id);
2527: hr_utility.trace('ln_payroll_id '||ln_payroll_id);
2528: hr_utility.trace('ln_business_group_id '||ln_business_group_id);
2529: hr_utility.trace('ln_business_group_id '||ln_business_group_id);
2530: OPEN c_get_arch_range_emp(p_payroll_action_id
2531: ,p_chunk
2532: ,ln_cons_set_id

Line 2529: hr_utility.trace('ln_business_group_id '||ln_business_group_id);

2525: hr_utility.trace('p_chunk '||p_chunk);
2526: hr_utility.trace('ln_cons_set_id '||ln_cons_set_id);
2527: hr_utility.trace('ln_payroll_id '||ln_payroll_id);
2528: hr_utility.trace('ln_business_group_id '||ln_business_group_id);
2529: hr_utility.trace('ln_business_group_id '||ln_business_group_id);
2530: OPEN c_get_arch_range_emp(p_payroll_action_id
2531: ,p_chunk
2532: ,ln_cons_set_id
2533: ,ln_payroll_id

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

2544: ,ld_end_date);
2545: END IF;
2546: ln_step := 3;
2547: -- Loop for all rows returned for SQL statement.
2548: -- hr_utility.set_location(gv_package || lv_procedure_name, 30);
2549: LOOP
2550: hr_utility.trace('p_payroll_action_id LOOP'||p_payroll_action_id);
2551: IF lb_range_person THEN
2552: hr_utility.set_location(gv_package || lv_procedure_name, 300);

Line 2550: hr_utility.trace('p_payroll_action_id LOOP'||p_payroll_action_id);

2546: ln_step := 3;
2547: -- Loop for all rows returned for SQL statement.
2548: -- hr_utility.set_location(gv_package || lv_procedure_name, 30);
2549: LOOP
2550: hr_utility.trace('p_payroll_action_id LOOP'||p_payroll_action_id);
2551: IF lb_range_person THEN
2552: hr_utility.set_location(gv_package || lv_procedure_name, 300);
2553: FETCH c_get_arch_range_emp INTO ln_assignment_id,
2554: ln_tax_unit_id,

Line 2552: hr_utility.set_location(gv_package || lv_procedure_name, 300);

2548: -- hr_utility.set_location(gv_package || lv_procedure_name, 30);
2549: LOOP
2550: hr_utility.trace('p_payroll_action_id LOOP'||p_payroll_action_id);
2551: IF lb_range_person THEN
2552: hr_utility.set_location(gv_package || lv_procedure_name, 300);
2553: FETCH c_get_arch_range_emp INTO ln_assignment_id,
2554: ln_tax_unit_id,
2555: ld_effective_date,
2556: ld_date_earned,

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

2556: ld_date_earned,
2557: lv_action_type,
2558: ln_asg_action_id,
2559: ln_payroll_action_id;
2560: hr_utility.set_location(gv_package || lv_procedure_name, 301);
2561: EXIT WHEN c_get_arch_range_emp%NOTFOUND;
2562: hr_utility.set_location(gv_package || lv_procedure_name, 302);
2563: ELSE
2564: hr_utility.set_location(gv_package || lv_procedure_name, 303);

Line 2562: hr_utility.set_location(gv_package || lv_procedure_name, 302);

2558: ln_asg_action_id,
2559: ln_payroll_action_id;
2560: hr_utility.set_location(gv_package || lv_procedure_name, 301);
2561: EXIT WHEN c_get_arch_range_emp%NOTFOUND;
2562: hr_utility.set_location(gv_package || lv_procedure_name, 302);
2563: ELSE
2564: hr_utility.set_location(gv_package || lv_procedure_name, 303);
2565: FETCH c_get_arch_emp INTO ln_assignment_id,
2566: ln_tax_unit_id,

Line 2564: hr_utility.set_location(gv_package || lv_procedure_name, 303);

2560: hr_utility.set_location(gv_package || lv_procedure_name, 301);
2561: EXIT WHEN c_get_arch_range_emp%NOTFOUND;
2562: hr_utility.set_location(gv_package || lv_procedure_name, 302);
2563: ELSE
2564: hr_utility.set_location(gv_package || lv_procedure_name, 303);
2565: FETCH c_get_arch_emp INTO ln_assignment_id,
2566: ln_tax_unit_id,
2567: ld_effective_date,
2568: ld_date_earned,

Line 2572: hr_utility.set_location(gv_package || lv_procedure_name, 304);

2568: ld_date_earned,
2569: lv_action_type,
2570: ln_asg_action_id,
2571: ln_payroll_action_id;
2572: hr_utility.set_location(gv_package || lv_procedure_name, 304);
2573: EXIT WHEN c_get_arch_emp%NOTFOUND;
2574: END IF;
2575: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2576: hr_utility.trace('ln_assignment_id = ' ||

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

2571: ln_payroll_action_id;
2572: hr_utility.set_location(gv_package || lv_procedure_name, 304);
2573: EXIT WHEN c_get_arch_emp%NOTFOUND;
2574: END IF;
2575: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2576: hr_utility.trace('ln_assignment_id = ' ||
2577: TO_CHAR(ln_assignment_id));
2578: ln_step := 4;
2579: /********************************************************

Line 2576: hr_utility.trace('ln_assignment_id = ' ||

2572: hr_utility.set_location(gv_package || lv_procedure_name, 304);
2573: EXIT WHEN c_get_arch_emp%NOTFOUND;
2574: END IF;
2575: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2576: hr_utility.trace('ln_assignment_id = ' ||
2577: TO_CHAR(ln_assignment_id));
2578: ln_step := 4;
2579: /********************************************************
2580: ** If Balance Adjustment, only create one assignment

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

2591: ld_effective_date = ld_prev_effective_date AND
2592: lv_action_type = 'B' AND
2593: ln_asg_action_id <> ln_prev_asg_action_id THEN
2594:
2595: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2596: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
2597: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
2598: hr_nonrun_asact.insint(ln_xfr_action_id
2599: ,ln_asg_action_id);

Line 2596: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);

2592: lv_action_type = 'B' AND
2593: ln_asg_action_id <> ln_prev_asg_action_id THEN
2594:
2595: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2596: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
2597: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
2598: hr_nonrun_asact.insint(ln_xfr_action_id
2599: ,ln_asg_action_id);
2600: ELSE

Line 2597: hr_utility.trace('Locked Action = ' || ln_asg_action_id);

2593: ln_asg_action_id <> ln_prev_asg_action_id THEN
2594:
2595: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2596: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
2597: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
2598: hr_nonrun_asact.insint(ln_xfr_action_id
2599: ,ln_asg_action_id);
2600: ELSE
2601: hr_utility.set_location(gv_package || lv_procedure_name, 60);

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

2597: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
2598: hr_nonrun_asact.insint(ln_xfr_action_id
2599: ,ln_asg_action_id);
2600: ELSE
2601: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2602: hr_utility.trace('Action_type = '||lv_action_type );
2603:
2604: SELECT pay_assignment_actions_s.NEXTVAL
2605: INTO ln_xfr_action_id

Line 2602: hr_utility.trace('Action_type = '||lv_action_type );

2598: hr_nonrun_asact.insint(ln_xfr_action_id
2599: ,ln_asg_action_id);
2600: ELSE
2601: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2602: hr_utility.trace('Action_type = '||lv_action_type );
2603:
2604: SELECT pay_assignment_actions_s.NEXTVAL
2605: INTO ln_xfr_action_id
2606: FROM dual;

Line 2617: hr_utility.set_location(gv_package || lv_procedure_name, 70);

2613: ln_tax_unit_id,
2614: NULL,
2615: 'U',
2616: NULL);
2617: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2618: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
2619: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
2620: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
2621: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);

Line 2618: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);

2614: NULL,
2615: 'U',
2616: NULL);
2617: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2618: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
2619: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
2620: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
2621: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
2622: hr_utility.set_location(gv_package || lv_procedure_name, 80);

Line 2619: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);

2615: 'U',
2616: NULL);
2617: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2618: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
2619: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
2620: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
2621: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
2622: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2623:

Line 2620: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);

2616: NULL);
2617: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2618: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
2619: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
2620: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
2621: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
2622: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2623:
2624: -- insert an interlock to this action

Line 2621: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);

2617: hr_utility.set_location(gv_package || lv_procedure_name, 70);
2618: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
2619: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
2620: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
2621: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
2622: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2623:
2624: -- insert an interlock to this action
2625: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);

Line 2622: hr_utility.set_location(gv_package || lv_procedure_name, 80);

2618: hr_utility.trace('ln_asg_action_id = ' || ln_asg_action_id);
2619: hr_utility.trace('ln_xfr_action_id = ' || ln_xfr_action_id);
2620: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
2621: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
2622: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2623:
2624: -- insert an interlock to this action
2625: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
2626: hr_utility.trace('Locked Action = ' || ln_asg_action_id);

Line 2625: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);

2621: hr_utility.trace('ln_tax_unit_id = ' || ln_tax_unit_id);
2622: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2623:
2624: -- insert an interlock to this action
2625: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
2626: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
2627: hr_nonrun_asact.insint(ln_xfr_action_id,
2628: ln_asg_action_id);
2629:

Line 2626: hr_utility.trace('Locked Action = ' || ln_asg_action_id);

2622: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2623:
2624: -- insert an interlock to this action
2625: hr_utility.trace('Locking Action = ' || ln_xfr_action_id);
2626: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
2627: hr_nonrun_asact.insint(ln_xfr_action_id,
2628: ln_asg_action_id);
2629:
2630: hr_utility.set_location(gv_package || lv_procedure_name, 90);

Line 2630: hr_utility.set_location(gv_package || lv_procedure_name, 90);

2626: hr_utility.trace('Locked Action = ' || ln_asg_action_id);
2627: hr_nonrun_asact.insint(ln_xfr_action_id,
2628: ln_asg_action_id);
2629:
2630: hr_utility.set_location(gv_package || lv_procedure_name, 90);
2631:
2632: /********************************************************
2633: ** For Balance Adj we put only the first assignment action
2634: ********************************************************/

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

2637: UPDATE pay_assignment_actions
2638: SET serial_number = lv_serial_number
2639: WHERE assignment_action_id = ln_xfr_action_id;
2640:
2641: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2642:
2643: END IF ; --ln_assignment_id ...
2644:
2645: ln_prev_tax_unit_id := ln_tax_unit_id;

Line 2671: hr_utility.trace(lv_error_message || '-' || SQLERRM);

2667:
2668: EXCEPTION
2669: WHEN OTHERS THEN
2670: lv_error_message := 'Error at step '|| ln_step ||' IN '|| gv_package || lv_procedure_name;
2671: hr_utility.trace(lv_error_message || '-' || SQLERRM);
2672:
2673: lv_error_message :=
2674: pay_emp_action_arch.set_error_message(lv_error_message);
2675:

Line 2676: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

2672:
2673: lv_error_message :=
2674: pay_emp_action_arch.set_error_message(lv_error_message);
2675:
2676: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2677: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2678: hr_utility.raise_error;
2679:
2680: END assignment_action_code;

Line 2677: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

2673: lv_error_message :=
2674: pay_emp_action_arch.set_error_message(lv_error_message);
2675:
2676: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2677: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2678: hr_utility.raise_error;
2679:
2680: END assignment_action_code;
2681:

Line 2678: hr_utility.raise_error;

2674: pay_emp_action_arch.set_error_message(lv_error_message);
2675:
2676: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2677: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2678: hr_utility.raise_error;
2679:
2680: END assignment_action_code;
2681:
2682:

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

2760: j NUMBER;
2761:
2762: BEGIN
2763: lv_procedure_name := '.initialization_code';
2764: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2765: pay_emp_action_arch.gv_error_message := NULL;
2766: lv_reporting_level := Null;
2767: i := 0;
2768: j := 0;

Line 2777: hr_utility.trace('--Legislation code--'||lv_legislation_code);

2773:
2774: /*Setting legislation code global variable*/
2775: OPEN c_get_legislation_code (ln_business_group_id);
2776: FETCH c_get_legislation_code INTO lv_legislation_code;
2777: hr_utility.trace('--Legislation code--'||lv_legislation_code);
2778: IF c_get_legislation_code%NOTFOUND THEN
2779: hr_utility.trace('Business Group FOR Archiver Process Not Found');
2780: hr_utility.raise_error;
2781: END IF;

Line 2779: hr_utility.trace('Business Group FOR Archiver Process Not Found');

2775: OPEN c_get_legislation_code (ln_business_group_id);
2776: FETCH c_get_legislation_code INTO lv_legislation_code;
2777: hr_utility.trace('--Legislation code--'||lv_legislation_code);
2778: IF c_get_legislation_code%NOTFOUND THEN
2779: hr_utility.trace('Business Group FOR Archiver Process Not Found');
2780: hr_utility.raise_error;
2781: END IF;
2782: CLOSE c_get_legislation_code;
2783: gv_legislation_code := lv_legislation_code;

Line 2780: hr_utility.raise_error;

2776: FETCH c_get_legislation_code INTO lv_legislation_code;
2777: hr_utility.trace('--Legislation code--'||lv_legislation_code);
2778: IF c_get_legislation_code%NOTFOUND THEN
2779: hr_utility.trace('Business Group FOR Archiver Process Not Found');
2780: hr_utility.raise_error;
2781: END IF;
2782: CLOSE c_get_legislation_code;
2783: gv_legislation_code := lv_legislation_code;
2784: ln_step := 2;

Line 2789: hr_utility.trace('--Tax Unit--'||lv_rule_mode);

2785:
2786: /*Finding whether TAX_UNIT is enabled*/
2787: OPEN c_legislation_rule (gv_legislation_code,'TAX_UNIT');
2788: FETCH c_legislation_rule INTO lv_rule_mode;
2789: hr_utility.trace('--Tax Unit--'||lv_rule_mode);
2790: IF c_legislation_rule%NOTFOUND OR lv_rule_mode = 'N' THEN
2791: hr_utility.trace('--In IF case--');
2792: gv_is_tax_unit_enabled := 'N';
2793: gv_ytd_balance_dimension := '_ASG_TYTD';

Line 2791: hr_utility.trace('--In IF case--');

2787: OPEN c_legislation_rule (gv_legislation_code,'TAX_UNIT');
2788: FETCH c_legislation_rule INTO lv_rule_mode;
2789: hr_utility.trace('--Tax Unit--'||lv_rule_mode);
2790: IF c_legislation_rule%NOTFOUND OR lv_rule_mode = 'N' THEN
2791: hr_utility.trace('--In IF case--');
2792: gv_is_tax_unit_enabled := 'N';
2793: gv_ytd_balance_dimension := '_ASG_TYTD';
2794: ELSIF lv_rule_mode = 'Y' THEN
2795: hr_utility.trace('--In ELSIF case--');

Line 2795: hr_utility.trace('--In ELSIF case--');

2791: hr_utility.trace('--In IF case--');
2792: gv_is_tax_unit_enabled := 'N';
2793: gv_ytd_balance_dimension := '_ASG_TYTD';
2794: ELSIF lv_rule_mode = 'Y' THEN
2795: hr_utility.trace('--In ELSIF case--');
2796: gv_is_tax_unit_enabled := 'Y';
2797: gv_ytd_balance_dimension := '_ASG_TU_TYTD';
2798: END IF;
2799:

Line 2800: hr_utility.set_location(gv_package || lv_procedure_name, 15);

2796: gv_is_tax_unit_enabled := 'Y';
2797: gv_ytd_balance_dimension := '_ASG_TU_TYTD';
2798: END IF;
2799:
2800: hr_utility.set_location(gv_package || lv_procedure_name, 15);
2801: ln_step := 3;
2802: hr_utility.trace('Legislation code:'||gv_legislation_code);
2803: OPEN c_balance_type_id;
2804: FETCH c_balance_type_id INTO ln_run_bal_type_id;

Line 2802: hr_utility.trace('Legislation code:'||gv_legislation_code);

2798: END IF;
2799:
2800: hr_utility.set_location(gv_package || lv_procedure_name, 15);
2801: ln_step := 3;
2802: hr_utility.trace('Legislation code:'||gv_legislation_code);
2803: OPEN c_balance_type_id;
2804: FETCH c_balance_type_id INTO ln_run_bal_type_id;
2805: hr_utility.trace('--Inside loop cur_bal_type--');
2806: gn_payments_def_bal_id :=

Line 2805: hr_utility.trace('--Inside loop cur_bal_type--');

2801: ln_step := 3;
2802: hr_utility.trace('Legislation code:'||gv_legislation_code);
2803: OPEN c_balance_type_id;
2804: FETCH c_balance_type_id INTO ln_run_bal_type_id;
2805: hr_utility.trace('--Inside loop cur_bal_type--');
2806: gn_payments_def_bal_id :=
2807: NVL(pay_emp_action_arch.get_defined_balance_id(
2808: ln_run_bal_type_id,
2809: '_PAYMENTS',

Line 2814: hr_utility.trace('cur_sepchk_run_type - Legislation code:'||gv_legislation_code);

2810: gv_legislation_code),-1); --Changed _ASG_RUN to _PAYMENTS
2811: CLOSE c_balance_type_id;
2812:
2813: ln_step := 4;
2814: hr_utility.trace('cur_sepchk_run_type - Legislation code:'||gv_legislation_code);
2815: gn_np_sepchk_run_type_id := -999;
2816: gn_sepchk_run_type_id :=-999;
2817: OPEN cur_sepchk_run_type;
2818: LOOP

Line 2821: hr_utility.trace('--Inside loop cur_sepchk_run_type--');

2817: OPEN cur_sepchk_run_type;
2818: LOOP
2819: FETCH cur_sepchk_run_type INTO ln_sep_chk_run_type_id, lv_shortname;
2820: EXIT WHEN cur_sepchk_run_type%NOTFOUND;
2821: hr_utility.trace('--Inside loop cur_sepchk_run_type--');
2822: /*Fetching run type of Seperate payment, for Intl Payroll the seeded
2823: Run type for Separate run is "PAY_SEPERATELY */
2824:
2825: IF lv_shortname = 'PAY_SEPARATELY' THEN

Line 2840: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);

2836: pay_emp_action_arch.gv_multi_leg_rule
2837: := pay_emp_action_arch.get_multi_legislative_rule(gv_legislation_code);
2838: END IF;
2839:
2840: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);
2841: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2842:
2843: ln_step := 6;
2844: dbt.delete;

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

2837: := pay_emp_action_arch.get_multi_legislative_rule(gv_legislation_code);
2838: END IF;
2839:
2840: hr_utility.trace('gv_multi_leg_rule : ' || pay_emp_action_arch.gv_multi_leg_rule);
2841: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2842:
2843: ln_step := 6;
2844: dbt.delete;
2845: i := 0;

Line 2848: hr_utility.trace(' Legislation code:'||gv_legislation_code);

2844: dbt.delete;
2845: i := 0;
2846:
2847: ln_step := 7;
2848: hr_utility.trace(' Legislation code:'||gv_legislation_code);
2849: /*Fetching statutory balances for archival*/
2850:
2851: open c_get_bal_details;
2852: fetch c_get_bal_details bulk collect into dbt;

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

2851: open c_get_bal_details;
2852: fetch c_get_bal_details bulk collect into dbt;
2853: close c_get_bal_details;
2854:
2855: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2856: i := 0;
2857:
2858: ln_step := 9;
2859:

Line 2863: hr_utility.trace(dbt(i).act_info_category);

2859:
2860: IF dbt.count > 0 THEN
2861: FOR i IN dbt.first..dbt.last
2862: LOOP
2863: hr_utility.trace(dbt(i).act_info_category);
2864: hr_utility.trace(dbt(i).bal_name);
2865: hr_utility.trace(dbt(i).bal_type_id);
2866: hr_utility.trace(dbt(i).def_bal_id);
2867: hr_utility.trace(dbt(i).dimension);

Line 2864: hr_utility.trace(dbt(i).bal_name);

2860: IF dbt.count > 0 THEN
2861: FOR i IN dbt.first..dbt.last
2862: LOOP
2863: hr_utility.trace(dbt(i).act_info_category);
2864: hr_utility.trace(dbt(i).bal_name);
2865: hr_utility.trace(dbt(i).bal_type_id);
2866: hr_utility.trace(dbt(i).def_bal_id);
2867: hr_utility.trace(dbt(i).dimension);
2868: hr_utility.trace(dbt(i).attribute_name);

Line 2865: hr_utility.trace(dbt(i).bal_type_id);

2861: FOR i IN dbt.first..dbt.last
2862: LOOP
2863: hr_utility.trace(dbt(i).act_info_category);
2864: hr_utility.trace(dbt(i).bal_name);
2865: hr_utility.trace(dbt(i).bal_type_id);
2866: hr_utility.trace(dbt(i).def_bal_id);
2867: hr_utility.trace(dbt(i).dimension);
2868: hr_utility.trace(dbt(i).attribute_name);
2869: END LOOP;

Line 2866: hr_utility.trace(dbt(i).def_bal_id);

2862: LOOP
2863: hr_utility.trace(dbt(i).act_info_category);
2864: hr_utility.trace(dbt(i).bal_name);
2865: hr_utility.trace(dbt(i).bal_type_id);
2866: hr_utility.trace(dbt(i).def_bal_id);
2867: hr_utility.trace(dbt(i).dimension);
2868: hr_utility.trace(dbt(i).attribute_name);
2869: END LOOP;
2870: END IF;

Line 2867: hr_utility.trace(dbt(i).dimension);

2863: hr_utility.trace(dbt(i).act_info_category);
2864: hr_utility.trace(dbt(i).bal_name);
2865: hr_utility.trace(dbt(i).bal_type_id);
2866: hr_utility.trace(dbt(i).def_bal_id);
2867: hr_utility.trace(dbt(i).dimension);
2868: hr_utility.trace(dbt(i).attribute_name);
2869: END LOOP;
2870: END IF;
2871: ln_step := 10;

Line 2868: hr_utility.trace(dbt(i).attribute_name);

2864: hr_utility.trace(dbt(i).bal_name);
2865: hr_utility.trace(dbt(i).bal_type_id);
2866: hr_utility.trace(dbt(i).def_bal_id);
2867: hr_utility.trace(dbt(i).dimension);
2868: hr_utility.trace(dbt(i).attribute_name);
2869: END LOOP;
2870: END IF;
2871: ln_step := 10;
2872: hr_utility.set_location(gv_package || lv_procedure_name, 40);

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

2868: hr_utility.trace(dbt(i).attribute_name);
2869: END LOOP;
2870: END IF;
2871: ln_step := 10;
2872: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2873:
2874: EXCEPTION
2875: WHEN OTHERS THEN
2876: hr_utility.set_location(gv_package || lv_procedure_name, 500);

Line 2876: hr_utility.set_location(gv_package || lv_procedure_name, 500);

2872: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2873:
2874: EXCEPTION
2875: WHEN OTHERS THEN
2876: hr_utility.set_location(gv_package || lv_procedure_name, 500);
2877: lv_error_message := 'Error at step ' || ln_step ||' IN '|| gv_package || lv_procedure_name;
2878: hr_utility.trace(lv_error_message || '-' || SQLERRM);
2879:
2880: lv_error_message :=

Line 2878: hr_utility.trace(lv_error_message || '-' || SQLERRM);

2874: EXCEPTION
2875: WHEN OTHERS THEN
2876: hr_utility.set_location(gv_package || lv_procedure_name, 500);
2877: lv_error_message := 'Error at step ' || ln_step ||' IN '|| gv_package || lv_procedure_name;
2878: hr_utility.trace(lv_error_message || '-' || SQLERRM);
2879:
2880: lv_error_message :=
2881: pay_emp_action_arch.set_error_message(lv_error_message);
2882:

Line 2883: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

2879:
2880: lv_error_message :=
2881: pay_emp_action_arch.set_error_message(lv_error_message);
2882:
2883: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2884: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2885: hr_utility.raise_error;
2886:
2887: END initialization_code;

Line 2884: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

2880: lv_error_message :=
2881: pay_emp_action_arch.set_error_message(lv_error_message);
2882:
2883: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2884: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2885: hr_utility.raise_error;
2886:
2887: END initialization_code;
2888:

Line 2885: hr_utility.raise_error;

2881: pay_emp_action_arch.set_error_message(lv_error_message);
2882:
2883: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2884: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2885: hr_utility.raise_error;
2886:
2887: END initialization_code;
2888:
2889: /******************************************************************

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

2937:
2938: BEGIN
2939: ln_step := 1;
2940: lv_procedure_name := '.populate_balances';
2941: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2942:
2943: hr_utility.trace('***Parameters passed to populate_balances***');
2944: hr_utility.trace('p_xfr_action_id :'||p_xfr_action_id);
2945: hr_utility.trace('p_assignment_id :'||p_assignment_id);

Line 2943: hr_utility.trace('Parameters passed to populate_balances');

2939: ln_step := 1;
2940: lv_procedure_name := '.populate_balances';
2941: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2942:
2943: hr_utility.trace('***Parameters passed to populate_balances***');
2944: hr_utility.trace('p_xfr_action_id :'||p_xfr_action_id);
2945: hr_utility.trace('p_assignment_id :'||p_assignment_id);
2946: hr_utility.trace('p_pymt_balcall_aaid :'||p_pymt_balcall_aaid);
2947: hr_utility.trace('p_tax_unit_id :'||p_tax_unit_id);

Line 2944: hr_utility.trace('p_xfr_action_id :'||p_xfr_action_id);

2940: lv_procedure_name := '.populate_balances';
2941: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2942:
2943: hr_utility.trace('***Parameters passed to populate_balances***');
2944: hr_utility.trace('p_xfr_action_id :'||p_xfr_action_id);
2945: hr_utility.trace('p_assignment_id :'||p_assignment_id);
2946: hr_utility.trace('p_pymt_balcall_aaid :'||p_pymt_balcall_aaid);
2947: hr_utility.trace('p_tax_unit_id :'||p_tax_unit_id);
2948: hr_utility.trace('p_action_type :'||p_action_type);

Line 2945: hr_utility.trace('p_assignment_id :'||p_assignment_id);

2941: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2942:
2943: hr_utility.trace('***Parameters passed to populate_balances***');
2944: hr_utility.trace('p_xfr_action_id :'||p_xfr_action_id);
2945: hr_utility.trace('p_assignment_id :'||p_assignment_id);
2946: hr_utility.trace('p_pymt_balcall_aaid :'||p_pymt_balcall_aaid);
2947: hr_utility.trace('p_tax_unit_id :'||p_tax_unit_id);
2948: hr_utility.trace('p_action_type :'||p_action_type);
2949: hr_utility.trace('p_pymt_eff_date :'||p_pymt_eff_date);

Line 2946: hr_utility.trace('p_pymt_balcall_aaid :'||p_pymt_balcall_aaid);

2942:
2943: hr_utility.trace('***Parameters passed to populate_balances***');
2944: hr_utility.trace('p_xfr_action_id :'||p_xfr_action_id);
2945: hr_utility.trace('p_assignment_id :'||p_assignment_id);
2946: hr_utility.trace('p_pymt_balcall_aaid :'||p_pymt_balcall_aaid);
2947: hr_utility.trace('p_tax_unit_id :'||p_tax_unit_id);
2948: hr_utility.trace('p_action_type :'||p_action_type);
2949: hr_utility.trace('p_pymt_eff_date :'||p_pymt_eff_date);
2950: hr_utility.trace('p_start_date :'||p_start_date);

Line 2947: hr_utility.trace('p_tax_unit_id :'||p_tax_unit_id);

2943: hr_utility.trace('***Parameters passed to populate_balances***');
2944: hr_utility.trace('p_xfr_action_id :'||p_xfr_action_id);
2945: hr_utility.trace('p_assignment_id :'||p_assignment_id);
2946: hr_utility.trace('p_pymt_balcall_aaid :'||p_pymt_balcall_aaid);
2947: hr_utility.trace('p_tax_unit_id :'||p_tax_unit_id);
2948: hr_utility.trace('p_action_type :'||p_action_type);
2949: hr_utility.trace('p_pymt_eff_date :'||p_pymt_eff_date);
2950: hr_utility.trace('p_start_date :'||p_start_date);
2951: hr_utility.trace('p_end_date :'||p_end_date);

Line 2948: hr_utility.trace('p_action_type :'||p_action_type);

2944: hr_utility.trace('p_xfr_action_id :'||p_xfr_action_id);
2945: hr_utility.trace('p_assignment_id :'||p_assignment_id);
2946: hr_utility.trace('p_pymt_balcall_aaid :'||p_pymt_balcall_aaid);
2947: hr_utility.trace('p_tax_unit_id :'||p_tax_unit_id);
2948: hr_utility.trace('p_action_type :'||p_action_type);
2949: hr_utility.trace('p_pymt_eff_date :'||p_pymt_eff_date);
2950: hr_utility.trace('p_start_date :'||p_start_date);
2951: hr_utility.trace('p_end_date :'||p_end_date);
2952: hr_utility.trace('p_ytd_balcall_aaid :'||p_ytd_balcall_aaid);

Line 2949: hr_utility.trace('p_pymt_eff_date :'||p_pymt_eff_date);

2945: hr_utility.trace('p_assignment_id :'||p_assignment_id);
2946: hr_utility.trace('p_pymt_balcall_aaid :'||p_pymt_balcall_aaid);
2947: hr_utility.trace('p_tax_unit_id :'||p_tax_unit_id);
2948: hr_utility.trace('p_action_type :'||p_action_type);
2949: hr_utility.trace('p_pymt_eff_date :'||p_pymt_eff_date);
2950: hr_utility.trace('p_start_date :'||p_start_date);
2951: hr_utility.trace('p_end_date :'||p_end_date);
2952: hr_utility.trace('p_ytd_balcall_aaid :'||p_ytd_balcall_aaid);
2953: hr_utility.trace('p_pre_pay_action_id :'||p_pre_pay_action_id);

Line 2950: hr_utility.trace('p_start_date :'||p_start_date);

2946: hr_utility.trace('p_pymt_balcall_aaid :'||p_pymt_balcall_aaid);
2947: hr_utility.trace('p_tax_unit_id :'||p_tax_unit_id);
2948: hr_utility.trace('p_action_type :'||p_action_type);
2949: hr_utility.trace('p_pymt_eff_date :'||p_pymt_eff_date);
2950: hr_utility.trace('p_start_date :'||p_start_date);
2951: hr_utility.trace('p_end_date :'||p_end_date);
2952: hr_utility.trace('p_ytd_balcall_aaid :'||p_ytd_balcall_aaid);
2953: hr_utility.trace('p_pre_pay_action_id :'||p_pre_pay_action_id);
2954: i := 0;

Line 2951: hr_utility.trace('p_end_date :'||p_end_date);

2947: hr_utility.trace('p_tax_unit_id :'||p_tax_unit_id);
2948: hr_utility.trace('p_action_type :'||p_action_type);
2949: hr_utility.trace('p_pymt_eff_date :'||p_pymt_eff_date);
2950: hr_utility.trace('p_start_date :'||p_start_date);
2951: hr_utility.trace('p_end_date :'||p_end_date);
2952: hr_utility.trace('p_ytd_balcall_aaid :'||p_ytd_balcall_aaid);
2953: hr_utility.trace('p_pre_pay_action_id :'||p_pre_pay_action_id);
2954: i := 0;
2955: j := 0;

Line 2952: hr_utility.trace('p_ytd_balcall_aaid :'||p_ytd_balcall_aaid);

2948: hr_utility.trace('p_action_type :'||p_action_type);
2949: hr_utility.trace('p_pymt_eff_date :'||p_pymt_eff_date);
2950: hr_utility.trace('p_start_date :'||p_start_date);
2951: hr_utility.trace('p_end_date :'||p_end_date);
2952: hr_utility.trace('p_ytd_balcall_aaid :'||p_ytd_balcall_aaid);
2953: hr_utility.trace('p_pre_pay_action_id :'||p_pre_pay_action_id);
2954: i := 0;
2955: j := 0;
2956:

Line 2953: hr_utility.trace('p_pre_pay_action_id :'||p_pre_pay_action_id);

2949: hr_utility.trace('p_pymt_eff_date :'||p_pymt_eff_date);
2950: hr_utility.trace('p_start_date :'||p_start_date);
2951: hr_utility.trace('p_end_date :'||p_end_date);
2952: hr_utility.trace('p_ytd_balcall_aaid :'||p_ytd_balcall_aaid);
2953: hr_utility.trace('p_pre_pay_action_id :'||p_pre_pay_action_id);
2954: i := 0;
2955: j := 0;
2956:
2957: IF gv_is_tax_unit_enabled = 'Y' THEN

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

2957: IF gv_is_tax_unit_enabled = 'Y' THEN
2958: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
2959: END IF;
2960:
2961: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2962: ln_step := 2;
2963:
2964: IF dbt.count > 0 THEN
2965: FOR i IN dbt.first..dbt.last LOOP

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

2970: ln_amount := NVL(pay_balance_pkg.get_value(
2971: dbt(i).def_bal_id,
2972: p_pre_pay_action_id),0); /*pre payment action id*/
2973:
2974: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2975: ln_step := 3;
2976:
2977: /*Archive the balance if it has Non zero value*/
2978: IF ( ln_amount <> 0 ) THEN

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

2976:
2977: /*Archive the balance if it has Non zero value*/
2978: IF ( ln_amount <> 0 ) THEN
2979:
2980: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2981:
2982: ln_step := 4;
2983: lv_reporting_name := dbt(i).bal_name;
2984:

Line 2986: --hr_utility.trace('Tax Balance Name : '|| dbt(i).bal_name );

2982: ln_step := 4;
2983: lv_reporting_name := dbt(i).bal_name;
2984:
2985: /*Insert this into the plsql table */
2986: --hr_utility.trace('Tax Balance Name : '|| dbt(i).bal_name );
2987: hr_utility.trace('lv_reporting_name : '||lv_reporting_name);
2988: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2989:
2990: ln_step := 5;

Line 2987: hr_utility.trace('lv_reporting_name : '||lv_reporting_name);

2983: lv_reporting_name := dbt(i).bal_name;
2984:
2985: /*Insert this into the plsql table */
2986: --hr_utility.trace('Tax Balance Name : '|| dbt(i).bal_name );
2987: hr_utility.trace('lv_reporting_name : '||lv_reporting_name);
2988: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2989:
2990: ln_step := 5;
2991: ln_index := pay_ac_action_arch.lrr_act_tab.count;

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

2984:
2985: /*Insert this into the plsql table */
2986: --hr_utility.trace('Tax Balance Name : '|| dbt(i).bal_name );
2987: hr_utility.trace('lv_reporting_name : '||lv_reporting_name);
2988: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2989:
2990: ln_step := 5;
2991: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2992:

Line 2993: hr_utility.trace('ln_index IS '

2989:
2990: ln_step := 5;
2991: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2992:
2993: hr_utility.trace('ln_index IS '
2994: || pay_ac_action_arch.lrr_act_tab.count);
2995:
2996: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2997: := dbt(i).act_info_category;

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

3011: := lv_reporting_name;
3012: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
3013: := dbt(i).attribute_name;
3014:
3015: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3016:
3017: ln_step := 6;
3018: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
3019: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code

Line 3026: hr_utility.set_location(gv_package || lv_procedure_name, 70);

3022: := dbt(i).bal_name;
3023: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
3024: := dbt(i).bal_type_id;
3025:
3026: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3027:
3028: END IF;
3029:
3030: END LOOP;

Line 3033: hr_utility.set_location(gv_package || lv_procedure_name, 80);

3029:
3030: END LOOP;
3031: END IF;
3032:
3033: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3034:
3035: EXCEPTION
3036: WHEN OTHERS THEN
3037: hr_utility.set_location(gv_package || lv_procedure_name, 500);

Line 3037: hr_utility.set_location(gv_package || lv_procedure_name, 500);

3033: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3034:
3035: EXCEPTION
3036: WHEN OTHERS THEN
3037: hr_utility.set_location(gv_package || lv_procedure_name, 500);
3038: lv_error_message := 'Error at step ' || ln_step ||' IN '|| gv_package || lv_procedure_name;
3039: hr_utility.trace(lv_error_message || '-' || SQLERRM);
3040:
3041: lv_error_message :=

Line 3039: hr_utility.trace(lv_error_message || '-' || SQLERRM);

3035: EXCEPTION
3036: WHEN OTHERS THEN
3037: hr_utility.set_location(gv_package || lv_procedure_name, 500);
3038: lv_error_message := 'Error at step ' || ln_step ||' IN '|| gv_package || lv_procedure_name;
3039: hr_utility.trace(lv_error_message || '-' || SQLERRM);
3040:
3041: lv_error_message :=
3042: pay_emp_action_arch.set_error_message(lv_error_message);
3043:

Line 3044: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

3040:
3041: lv_error_message :=
3042: pay_emp_action_arch.set_error_message(lv_error_message);
3043:
3044: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3045: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3046: hr_utility.raise_error;
3047:
3048: END populate_balances;

Line 3045: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

3041: lv_error_message :=
3042: pay_emp_action_arch.set_error_message(lv_error_message);
3043:
3044: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3045: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3046: hr_utility.raise_error;
3047:
3048: END populate_balances;
3049:

Line 3046: hr_utility.raise_error;

3042: pay_emp_action_arch.set_error_message(lv_error_message);
3043:
3044: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3045: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3046: hr_utility.raise_error;
3047:
3048: END populate_balances;
3049:
3050:

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

3118: lv_is_er_exists := 'N';
3119: lv_procedure_name := '.arch_pay_action_level_data:get_legal_ER_address';
3120:
3121: -- Get Employer address
3122: hr_utility.set_location(gv_package || lv_procedure_name, 210);
3123: OPEN c_addr_line(p_organization_id);
3124: FETCH c_addr_line INTO lv_er_name
3125: ,lv_er_address_line_1
3126: ,lv_er_address_line_2

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

3132: ,lv_er_postal_code
3133: ,lv_er_country
3134: ,lv_er_telephone;
3135: CLOSE c_addr_line;
3136: hr_utility.set_location(gv_package || lv_procedure_name, 220);
3137:
3138: IF pay_emp_action_arch.ltr_ppa_arch_data.count > 0 THEN
3139: FOR i IN pay_emp_action_arch.ltr_ppa_arch_data.FIRST ..
3140: pay_emp_action_arch.ltr_ppa_arch_data.LAST LOOP

Line 3150: hr_utility.set_location(gv_package || lv_procedure_name, 230);

3146: END LOOP;
3147: END IF;
3148:
3149: IF lv_is_er_exists = 'N' THEN
3150: hr_utility.set_location(gv_package || lv_procedure_name, 230);
3151: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3152:
3153: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3154: := 'IP EMPLOYER DETAILS';

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

3212:
3213: OPEN c_get_other_info(p_organization_id
3214: ,'Organization:Payslip Info') ;
3215: LOOP
3216: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3217: FETCH c_get_other_info INTO lv_org_information1
3218: ,lv_org_information2
3219: ,lv_org_information3
3220: ,lv_org_information4

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

3221: ,lv_org_information5
3222: ,lv_org_information6
3223: ,lv_org_information7;
3224: IF c_get_other_info%NOTFOUND THEN
3225: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3226: EXIT;
3227: END IF;
3228:
3229:

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

3226: EXIT;
3227: END IF;
3228:
3229:
3230: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3231:
3232: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3233: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3234: := 'EMPLOYEE OTHER INFORMATION';

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

3246: := lv_org_information6;
3247: END LOOP ;
3248: CLOSE c_get_other_info;
3249:
3250: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3251: OPEN c_get_other_info(p_business_group_id
3252: ,'Business Group:Payslip Info') ;
3253: LOOP
3254: hr_utility.set_location(gv_package || lv_procedure_name, 110);

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

3250: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3251: OPEN c_get_other_info(p_business_group_id
3252: ,'Business Group:Payslip Info') ;
3253: LOOP
3254: hr_utility.set_location(gv_package || lv_procedure_name, 110);
3255: FETCH c_get_other_info INTO lv_org_information1
3256: ,lv_org_information2
3257: ,lv_org_information3
3258: ,lv_org_information4

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

3259: ,lv_org_information5
3260: ,lv_org_information6
3261: ,lv_org_information7;
3262: IF c_get_other_info%NOTFOUND THEN
3263: hr_utility.set_location(gv_package || lv_procedure_name, 120);
3264: EXIT;
3265: END IF;
3266:
3267: hr_utility.set_location(gv_package || lv_procedure_name, 130);

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

3263: hr_utility.set_location(gv_package || lv_procedure_name, 120);
3264: EXIT;
3265: END IF;
3266:
3267: hr_utility.set_location(gv_package || lv_procedure_name, 130);
3268: ln_index := pay_emp_action_arch.ltr_ppa_arch.count;
3269: pay_emp_action_arch.ltr_ppa_arch(ln_index).action_info_category
3270: := 'EMPLOYEE OTHER INFORMATION';
3271: pay_emp_action_arch.ltr_ppa_arch(ln_index).jurisdiction_code

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

3281: pay_emp_action_arch.ltr_ppa_arch(ln_index).act_info6
3282: := lv_org_information6;
3283: END LOOP ;
3284: CLOSE c_get_other_info;
3285: hr_utility.set_location(gv_package || lv_procedure_name, 140);
3286:
3287: END get_org_other_info;
3288:
3289: BEGIN

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

3287: END get_org_other_info;
3288:
3289: BEGIN
3290: lv_procedure_name := '.arch_pay_action_level_data';
3291: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3292:
3293: pay_emp_action_arch.initialization_process;
3294:
3295: OPEN c_get_organization(p_payroll_id, p_effective_date);

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

3312: IF gv_is_tax_unit_enabled = 'Y' THEN
3313: OPEN c_get_gre;
3314: LOOP
3315: FETCH c_get_gre INTO ln_organization_id;
3316: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3317:
3318: IF c_get_gre%NOTFOUND THEN
3319: EXIT;
3320: END IF;

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

3323: END LOOP;
3324: CLOSE c_get_gre;
3325: END IF;
3326:
3327: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3328:
3329: -- insert rows in pay_action_information table
3330: IF pay_emp_action_arch.ltr_ppa_arch.count > 0 THEN
3331: pay_emp_action_arch.insert_rows_thro_api_process(

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

3338: );
3339: END IF;
3340: EXCEPTION
3341: WHEN OTHERS THEN
3342: hr_utility.trace('Error in ' || gv_package || '.'
3343: || lv_procedure_name || '-'
3344: || TO_CHAR(SQLCODE) || '-' || SQLERRM);
3345: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3346: RAISE hr_utility.hr_error;

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

3341: WHEN OTHERS THEN
3342: hr_utility.trace('Error in ' || gv_package || '.'
3343: || lv_procedure_name || '-'
3344: || TO_CHAR(SQLCODE) || '-' || SQLERRM);
3345: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3346: RAISE hr_utility.hr_error;
3347:
3348: END arch_pay_action_level_data;
3349:

Line 3346: RAISE hr_utility.hr_error;

3342: hr_utility.trace('Error in ' || gv_package || '.'
3343: || lv_procedure_name || '-'
3344: || TO_CHAR(SQLCODE) || '-' || SQLERRM);
3345: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3346: RAISE hr_utility.hr_error;
3347:
3348: END arch_pay_action_level_data;
3349:
3350:

Line 3412: hr_utility.set_location(l_procedure_name, 10);

3408: --
3409: BEGIN
3410: --
3411: l_procedure_name := gv_package || '.archive_absences';
3412: hr_utility.set_location(l_procedure_name, 10);
3413:
3414: FOR csr_rec in csr_asg_absences
3415: LOOP
3416: hr_utility.trace('Entered for loop');

Line 3416: hr_utility.trace('Entered for loop');

3412: hr_utility.set_location(l_procedure_name, 10);
3413:
3414: FOR csr_rec in csr_asg_absences
3415: LOOP
3416: hr_utility.trace('Entered for loop');
3417:
3418: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date);
3419: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
3420:

Line 3443: hr_utility.set_location(l_procedure_name, 20);

3439: ,p_action_information7 => NULL
3440: );
3441: --
3442: END LOOP;
3443: hr_utility.set_location(l_procedure_name, 20);
3444: --
3445: EXCEPTION
3446: --
3447: WHEN others THEN

Line 3551: hr_utility.set_location(l_procedure_name, 10);

3547: --
3548: BEGIN
3549: --
3550: l_procedure_name := gv_package || '.archive_summary';
3551: hr_utility.set_location(l_procedure_name, 10);
3552: OPEN csr_asg_summary;
3553: LOOP
3554: FETCH csr_asg_summary INTO lv_action_info_category
3555: ,lv_element_type

Line 3559: hr_utility.set_location(l_procedure_name, 20);

3555: ,lv_element_type
3556: ,lv_run_amount
3557: ,lv_ytd_amount;
3558: EXIT WHEN csr_asg_summary%NOTFOUND;
3559: hr_utility.set_location(l_procedure_name, 20);
3560: IF lv_element_type = 'Gross Earnings' THEN
3561: lv_gross_earnings_run := lv_run_amount;
3562: lv_gross_earnings_ytd := lv_ytd_amount;
3563: ELSIF lv_element_type = 'Deductions' THEN

Line 3575: hr_utility.set_location(l_procedure_name, 30);

3571: lv_tax_deductions_ytd := lv_ytd_amount;
3572: END IF;
3573:
3574: END LOOP;
3575: hr_utility.set_location(l_procedure_name, 30);
3576:
3577: lv_net_pay_run := fnd_number.number_to_canonical(
3578: nvl(fnd_number.canonical_to_number(lv_gross_earnings_run),0) -
3579: (nvl(fnd_number.canonical_to_number(lv_deductions_run),0) +

Line 3583: hr_utility.set_location(l_procedure_name, 35);

3579: (nvl(fnd_number.canonical_to_number(lv_deductions_run),0) +
3580: nvl(fnd_number.canonical_to_number(lv_pre_tax_deductions_run),0) +
3581: nvl(fnd_number.canonical_to_number(lv_tax_deductions_run),0)
3582: ));
3583: hr_utility.set_location(l_procedure_name, 35);
3584: IF gv_is_tax_unit_enabled = 'Y' THEN
3585: hr_utility.set_location(l_procedure_name, 40);
3586: lv_net_pay_ytd := fnd_number.number_to_canonical(
3587: nvl(fnd_number.canonical_to_number(lv_gross_earnings_ytd),0) -

Line 3585: hr_utility.set_location(l_procedure_name, 40);

3581: nvl(fnd_number.canonical_to_number(lv_tax_deductions_run),0)
3582: ));
3583: hr_utility.set_location(l_procedure_name, 35);
3584: IF gv_is_tax_unit_enabled = 'Y' THEN
3585: hr_utility.set_location(l_procedure_name, 40);
3586: lv_net_pay_ytd := fnd_number.number_to_canonical(
3587: nvl(fnd_number.canonical_to_number(lv_gross_earnings_ytd),0) -
3588: (nvl(fnd_number.canonical_to_number(lv_deductions_ytd),0) +
3589: nvl(fnd_number.canonical_to_number(lv_pre_tax_deductions_ytd),0) +

Line 3595: hr_utility.set_location(l_procedure_name, 50);

3591: ));
3592: END IF;
3593:
3594: l_ovn := 1;
3595: hr_utility.set_location(l_procedure_name, 50);
3596: pay_action_information_api.create_action_information
3597: (
3598: p_action_information_id => l_action_info_id
3599: ,p_action_context_id => p_arch_act_id

Line 3612: hr_utility.set_location(l_procedure_name, 60);

3608: ,p_action_information6 => lv_tax_deductions_run
3609: ,p_action_information7 => lv_deductions_run
3610: ,p_action_information8 => lv_net_pay_run
3611: );
3612: hr_utility.set_location(l_procedure_name, 60);
3613: IF gv_is_tax_unit_enabled = 'Y' THEN
3614: hr_utility.set_location(l_procedure_name, 70);
3615: pay_action_information_api.create_action_information
3616: (

Line 3614: hr_utility.set_location(l_procedure_name, 70);

3610: ,p_action_information8 => lv_net_pay_run
3611: );
3612: hr_utility.set_location(l_procedure_name, 60);
3613: IF gv_is_tax_unit_enabled = 'Y' THEN
3614: hr_utility.set_location(l_procedure_name, 70);
3615: pay_action_information_api.create_action_information
3616: (
3617: p_action_information_id => l_action_info_id
3618: ,p_action_context_id => p_arch_act_id

Line 3633: hr_utility.set_location(l_procedure_name, 80);

3629: ,p_action_information8 => lv_net_pay_ytd
3630: );
3631: END IF;
3632: --
3633: hr_utility.set_location(l_procedure_name, 80);
3634: --
3635: EXCEPTION
3636: --
3637: WHEN others THEN

Line 3642: hr_utility.set_location(l_procedure_name, 90);

3638: IF csr_asg_summary%ISOPEN THEN
3639: CLOSE csr_asg_summary;
3640: END IF;
3641: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure_name, 'SQLERRMC:'||sqlerrm);
3642: hr_utility.set_location(l_procedure_name, 90);
3643: RAISE;
3644: --
3645: END archive_summary;
3646:

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

3768:
3769: BEGIN
3770: lv_procedure_name := '.process_actions';
3771:
3772: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3773: ln_step := 1;
3774: /****************************************************************
3775: ** For Seperate Check we do the YTD balance calls with the Run
3776: ** Action ID. So, we do not need to get the MAX. action which IS

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

3781: ****************************************************************/
3782: ln_ytd_balcall_aaid := p_payment_action_id;
3783: IF p_seperate_check_flag = 'N' AND
3784: p_action_type IN ('U', 'P') THEN
3785: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3786: ln_step := 2;
3787: OPEN c_ytd_aaid(p_rqp_action_id, /*pre payment assignment action*/
3788: p_assignment_id);
3789: FETCH c_ytd_aaid INTO ln_ytd_balcall_aaid; /*qp/payroll assignment action where source action is not null.*/

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

3787: OPEN c_ytd_aaid(p_rqp_action_id, /*pre payment assignment action*/
3788: p_assignment_id);
3789: FETCH c_ytd_aaid INTO ln_ytd_balcall_aaid; /*qp/payroll assignment action where source action is not null.*/
3790: IF c_ytd_aaid%NOTFOUND THEN
3791: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3792: hr_utility.raise_error;
3793: END IF;
3794: CLOSE c_ytd_aaid;
3795: END IF;

Line 3792: hr_utility.raise_error;

3788: p_assignment_id);
3789: FETCH c_ytd_aaid INTO ln_ytd_balcall_aaid; /*qp/payroll assignment action where source action is not null.*/
3790: IF c_ytd_aaid%NOTFOUND THEN
3791: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3792: hr_utility.raise_error;
3793: END IF;
3794: CLOSE c_ytd_aaid;
3795: END IF;
3796:

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

3793: END IF;
3794: CLOSE c_ytd_aaid;
3795: END IF;
3796:
3797: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3798: ln_step := 3;
3799:
3800: OPEN c_time_period(p_payment_action_id);
3801: FETCH c_time_period INTO ln_time_period_id,

Line 3806: hr_utility.set_location(gv_package || lv_procedure_name, 70);

3802: ld_run_date_earned, --Date Earned
3803: ld_run_effective_date; --PrePay Effective Date
3804: CLOSE c_time_period;
3805:
3806: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3807: ln_step := 4;
3808: /* Get last archiver assignment ation and last archiver effective date
3809: If Archiver is running for the first time then ld_last_xfr_eff_date and ln_last_xfr_action_id are null */
3810:

Line 3846: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);

3842: ld_last_xfr_eff_date := NULL;
3843: END IF;
3844: END IF;
3845:
3846: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
3847: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
3848: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
3849: hr_utility.trace('p_action_type = ' || p_action_type);
3850: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);

Line 3847: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);

3843: END IF;
3844: END IF;
3845:
3846: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
3847: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
3848: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
3849: hr_utility.trace('p_action_type = ' || p_action_type);
3850: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
3851: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);

Line 3848: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);

3844: END IF;
3845:
3846: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
3847: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
3848: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
3849: hr_utility.trace('p_action_type = ' || p_action_type);
3850: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
3851: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
3852: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);

Line 3849: hr_utility.trace('p_action_type = ' || p_action_type);

3845:
3846: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
3847: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
3848: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
3849: hr_utility.trace('p_action_type = ' || p_action_type);
3850: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
3851: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
3852: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
3853: hr_utility.trace('p_action_type = ' || p_action_type);

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

3846: hr_utility.trace('p_xfr_payroll_action_id= '|| p_xfr_payroll_action_id);
3847: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
3848: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
3849: hr_utility.trace('p_action_type = ' || p_action_type);
3850: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
3851: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
3852: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
3853: hr_utility.trace('p_action_type = ' || p_action_type);
3854: hr_utility.trace('p_assignment_id = ' || p_assignment_id);

Line 3851: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);

3847: hr_utility.trace('p_xfr_action_id = ' || p_xfr_action_id);
3848: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
3849: hr_utility.trace('p_action_type = ' || p_action_type);
3850: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
3851: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
3852: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
3853: hr_utility.trace('p_action_type = ' || p_action_type);
3854: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
3855: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );

Line 3852: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);

3848: hr_utility.trace('p_seperate_check_flag = ' || p_seperate_check_flag);
3849: hr_utility.trace('p_action_type = ' || p_action_type);
3850: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
3851: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
3852: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
3853: hr_utility.trace('p_action_type = ' || p_action_type);
3854: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
3855: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
3856: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );

Line 3853: hr_utility.trace('p_action_type = ' || p_action_type);

3849: hr_utility.trace('p_action_type = ' || p_action_type);
3850: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
3851: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
3852: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
3853: hr_utility.trace('p_action_type = ' || p_action_type);
3854: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
3855: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
3856: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
3857: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);

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

3850: hr_utility.trace('p_pre_pay_action_id = ' || p_pre_pay_action_id);
3851: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
3852: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
3853: hr_utility.trace('p_action_type = ' || p_action_type);
3854: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
3855: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
3856: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
3857: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
3858: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);

Line 3855: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );

3851: hr_utility.trace('p_payment_action_id = ' || p_payment_action_id);
3852: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
3853: hr_utility.trace('p_action_type = ' || p_action_type);
3854: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
3855: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
3856: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
3857: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
3858: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
3859: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);

Line 3856: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );

3852: hr_utility.trace('p_rqp_action_id = ' || p_rqp_action_id);
3853: hr_utility.trace('p_action_type = ' || p_action_type);
3854: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
3855: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
3856: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
3857: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
3858: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
3859: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
3860: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);

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

3853: hr_utility.trace('p_action_type = ' || p_action_type);
3854: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
3855: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
3856: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
3857: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
3858: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
3859: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
3860: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
3861: hr_utility.trace('p_archive_balance_info = '|| p_archive_balance_info);

Line 3858: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);

3854: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
3855: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
3856: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
3857: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
3858: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
3859: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
3860: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
3861: hr_utility.trace('p_archive_balance_info = '|| p_archive_balance_info);
3862: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);

Line 3859: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);

3855: hr_utility.trace('p_xfr_start_date = ' || p_xfr_start_date );
3856: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
3857: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
3858: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
3859: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
3860: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
3861: hr_utility.trace('p_archive_balance_info = '|| p_archive_balance_info);
3862: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
3863: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);

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

3856: hr_utility.trace('p_xfr_end_date = ' || p_xfr_end_date );
3857: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
3858: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
3859: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
3860: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
3861: hr_utility.trace('p_archive_balance_info = '|| p_archive_balance_info);
3862: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
3863: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
3864: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);

Line 3861: hr_utility.trace('p_archive_balance_info = '|| p_archive_balance_info);

3857: hr_utility.trace('p_curr_pymt_eff_date = ' || p_curr_pymt_eff_date);
3858: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
3859: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
3860: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
3861: hr_utility.trace('p_archive_balance_info = '|| p_archive_balance_info);
3862: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
3863: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
3864: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
3865: hr_utility.trace('p_business_grp_id = ' || p_business_grp_id);

Line 3862: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);

3858: hr_utility.trace('ld_run_effective_date = ' || ld_run_effective_date);
3859: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
3860: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
3861: hr_utility.trace('p_archive_balance_info = '|| p_archive_balance_info);
3862: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
3863: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
3864: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
3865: hr_utility.trace('p_business_grp_id = ' || p_business_grp_id);
3866:

Line 3863: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);

3859: hr_utility.trace('ln_ytd_balcall_aaid = ' || ln_ytd_balcall_aaid);
3860: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
3861: hr_utility.trace('p_archive_balance_info = '|| p_archive_balance_info);
3862: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
3863: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
3864: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
3865: hr_utility.trace('p_business_grp_id = ' || p_business_grp_id);
3866:
3867: ln_step := 6;

Line 3864: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);

3860: hr_utility.trace('p_ppp_source_action_id = '|| p_ppp_source_action_id);
3861: hr_utility.trace('p_archive_balance_info = '|| p_archive_balance_info);
3862: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
3863: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
3864: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
3865: hr_utility.trace('p_business_grp_id = ' || p_business_grp_id);
3866:
3867: ln_step := 6;
3868: pay_ac_action_arch.initialization_process;

Line 3865: hr_utility.trace('p_business_grp_id = ' || p_business_grp_id);

3861: hr_utility.trace('p_archive_balance_info = '|| p_archive_balance_info);
3862: hr_utility.trace('ld_run_date_earned = ' || ld_run_date_earned);
3863: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
3864: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
3865: hr_utility.trace('p_business_grp_id = ' || p_business_grp_id);
3866:
3867: ln_step := 6;
3868: pay_ac_action_arch.initialization_process;
3869:

Line 3889: hr_utility.set_location(gv_package || lv_procedure_name, 90);

3885: ,p_ytd_balcall_aaid => ln_ytd_balcall_aaid
3886: );
3887:
3888:
3889: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3890: ln_step := 8;
3891: /******************************************************************
3892: ** For seperate check cases, the ld_last_xfr_eff_date is never NULL
3893: ** as the master is always processed before the child actions. The

Line 3916: hr_utility.trace('lv_chk_for_arch_ytd_flag ='||lv_chk_for_arch_ytd_flag);

3912: lv_chk_for_arch_ytd_flag := 'N';
3913: END IF;
3914: CLOSE c_get_archive_ytd_flag;
3915:
3916: hr_utility.trace('lv_chk_for_arch_ytd_flag ='||lv_chk_for_arch_ytd_flag);
3917: /*If YTD values are not to be archived, enter this section*/
3918: IF lv_chk_for_arch_ytd_flag = 'N' THEN
3919:
3920: /*****************************************************************************

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

3939: IF ld_last_xfr_eff_date IS NULL THEN
3940: /*
3941: Called for First archiver process in a financial year
3942: */
3943: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3944: first_time_process(
3945: p_xfr_action_id => p_xfr_action_id
3946: ,p_assignment_id => p_assignment_id
3947: ,p_curr_pymt_action_id => p_rqp_action_id

Line 3959: hr_utility.trace('Step 9:p_curr_pymt_eff_date ='||p_curr_pymt_eff_date);

3955: );
3956:
3957: ELSE
3958: ln_step := 9;
3959: hr_utility.trace('Step 9:p_curr_pymt_eff_date ='||p_curr_pymt_eff_date);
3960: pay_ac_action_arch.get_last_pymt_info(
3961: p_assignment_id => p_assignment_id
3962: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
3963: ,p_last_pymt_eff_date => ld_last_pymt_eff_date

Line 3965: hr_utility.trace('Step 9:ld_last_pymt_eff_date ='||ld_last_pymt_eff_date);

3961: p_assignment_id => p_assignment_id
3962: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
3963: ,p_last_pymt_eff_date => ld_last_pymt_eff_date
3964: ,p_last_pymt_action_id => ln_last_pymt_action_id);
3965: hr_utility.trace('Step 9:ld_last_pymt_eff_date ='||ld_last_pymt_eff_date);
3966: hr_utility.trace('Step 9:ln_last_pymt_action_id ='||ln_last_pymt_action_id);
3967:
3968: ln_step := 10; --Elements processed in current run are picked
3969: get_current_elements(

Line 3966: hr_utility.trace('Step 9:ln_last_pymt_action_id ='||ln_last_pymt_action_id);

3962: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
3963: ,p_last_pymt_eff_date => ld_last_pymt_eff_date
3964: ,p_last_pymt_action_id => ln_last_pymt_action_id);
3965: hr_utility.trace('Step 9:ld_last_pymt_eff_date ='||ld_last_pymt_eff_date);
3966: hr_utility.trace('Step 9:ln_last_pymt_action_id ='||ln_last_pymt_action_id);
3967:
3968: ln_step := 10; --Elements processed in current run are picked
3969: get_current_elements(
3970: p_xfr_action_id => p_xfr_action_id

Line 3991: hr_utility.trace('Step 11:ld_last_pymt_eff_date ='||ld_last_pymt_eff_date);

3987: ,p_sepchk_flag => p_seperate_check_flag
3988: ,p_assignment_id => p_assignment_id
3989: ,p_business_grp_id => p_business_grp_id);
3990:
3991: hr_utility.trace('Step 11:ld_last_pymt_eff_date ='||ld_last_pymt_eff_date);
3992: hr_utility.trace('Step 11:p_curr_pymt_eff_date ='||p_curr_pymt_eff_date);
3993: IF ld_last_pymt_eff_date <> p_curr_pymt_eff_date THEN
3994: ln_step := 12; --Elements which got missed between current and previous archiver
3995: get_missing_xfr_info(

Line 3992: hr_utility.trace('Step 11:p_curr_pymt_eff_date ='||p_curr_pymt_eff_date);

3988: ,p_assignment_id => p_assignment_id
3989: ,p_business_grp_id => p_business_grp_id);
3990:
3991: hr_utility.trace('Step 11:ld_last_pymt_eff_date ='||ld_last_pymt_eff_date);
3992: hr_utility.trace('Step 11:p_curr_pymt_eff_date ='||p_curr_pymt_eff_date);
3993: IF ld_last_pymt_eff_date <> p_curr_pymt_eff_date THEN
3994: ln_step := 12; --Elements which got missed between current and previous archiver
3995: get_missing_xfr_info(
3996: p_xfr_action_id => p_xfr_action_id

Line 4010: -- hr_utility.set_location(gv_package || lv_procedure_name, 145);

4006:
4007: END IF;
4008:
4009: END IF;
4010: -- hr_utility.set_location(gv_package || lv_procedure_name, 145);
4011: -- ln_step := 13;
4012:
4013: END IF; /* p_archive_balance_info = 'Y' */
4014:

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

4011: -- ln_step := 13;
4012:
4013: END IF; /* p_archive_balance_info = 'Y' */
4014:
4015: hr_utility.set_location(gv_package || lv_procedure_name, 150);
4016: ln_step := 14;
4017: /*Archiving Employee's personal information*/
4018: hr_utility.set_location(gv_package || lv_procedure_name, 152);
4019: pay_emp_action_arch.get_personal_information(

Line 4018: hr_utility.set_location(gv_package || lv_procedure_name, 152);

4014:
4015: hr_utility.set_location(gv_package || lv_procedure_name, 150);
4016: ln_step := 14;
4017: /*Archiving Employee's personal information*/
4018: hr_utility.set_location(gv_package || lv_procedure_name, 152);
4019: pay_emp_action_arch.get_personal_information(
4020: p_payroll_action_id => p_xfr_payroll_action_id
4021: ,p_assactid => p_xfr_action_id
4022: ,p_assignment_id => p_assignment_id

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

4061: ,p_pre_effective_date =>p_curr_pymt_eff_date -- prepayment effective date
4062: );
4063:
4064:
4065: hr_utility.set_location(gv_package || lv_procedure_name, 210);
4066: ln_step := 16;
4067: pay_emp_action_arch.insert_rows_thro_api_process(
4068: p_action_context_id => p_xfr_action_id
4069: ,p_action_context_type=> 'AAP'

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

4072: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
4073: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
4074: );
4075:
4076: hr_utility.set_location(gv_package || lv_procedure_name, 220);
4077: ln_step := 17;
4078: /*Archiving Employee Additional Information*/
4079: get_employee_information(p_assignment_id => p_assignment_id
4080: ,p_assactid => p_xfr_action_id

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

4081: ,p_tax_unit_id => p_tax_unit_id
4082: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
4083: ,p_xfr_effective_date => p_xfr_end_date);
4084:
4085: hr_utility.set_location(gv_package || lv_procedure_name, 250);
4086:
4087:
4088: archive_summary(p_arch_act_id =>p_xfr_action_id /* archive assignment action id */
4089: ,p_pre_effective_date =>p_curr_pymt_eff_date); /* prepayment effective date */

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

4086:
4087:
4088: archive_summary(p_arch_act_id =>p_xfr_action_id /* archive assignment action id */
4089: ,p_pre_effective_date =>p_curr_pymt_eff_date); /* prepayment effective date */
4090: hr_utility.set_location(gv_package || lv_procedure_name, 260);
4091:
4092: EXCEPTION
4093: WHEN OTHERS THEN
4094: lv_error_message := 'Error IN step ' ||ln_step|| ' of '||

Line 4097: hr_utility.trace(lv_error_message || '-' || SQLERRM);

4093: WHEN OTHERS THEN
4094: lv_error_message := 'Error IN step ' ||ln_step|| ' of '||
4095: gv_package || lv_procedure_name;
4096:
4097: hr_utility.trace(lv_error_message || '-' || SQLERRM);
4098:
4099: lv_error_message :=
4100: pay_emp_action_arch.set_error_message(lv_error_message);
4101:

Line 4102: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

4098:
4099: lv_error_message :=
4100: pay_emp_action_arch.set_error_message(lv_error_message);
4101:
4102: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4103: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4104: hr_utility.raise_error;
4105:
4106: END process_actions;

Line 4103: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

4099: lv_error_message :=
4100: pay_emp_action_arch.set_error_message(lv_error_message);
4101:
4102: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4103: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4104: hr_utility.raise_error;
4105:
4106: END process_actions;
4107:

Line 4104: hr_utility.raise_error;

4100: pay_emp_action_arch.set_error_message(lv_error_message);
4101:
4102: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4103: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4104: hr_utility.raise_error;
4105:
4106: END process_actions;
4107:
4108:

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

4319: lv_archive_balance_info := 'Y';
4320:
4321:
4322: pay_emp_action_arch.gv_error_message := NULL;
4323: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4324: ln_step := 1;
4325: /*Get the information belongs to archiver assignment action id */
4326:
4327: OPEN c_xfr_info (p_xfr_action_id);

Line 4345: hr_utility.trace('Tax Unit is enabled but is not specified');

4341: */
4342:
4343: /*Added check to identify whether Tax Unit is specified when it is enabled for a Localization*/
4344: IF (gv_is_tax_unit_enabled = 'Y' AND ln_tax_unit_id IS NULL) THEN
4345: hr_utility.trace('Tax Unit is enabled but is not specified');
4346: lv_error_message := 'Tax Unit is enabled for localization but is not specified';
4347: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
4348: hr_utility.raise_error;
4349: END IF;

Line 4348: hr_utility.raise_error;

4344: IF (gv_is_tax_unit_enabled = 'Y' AND ln_tax_unit_id IS NULL) THEN
4345: hr_utility.trace('Tax Unit is enabled but is not specified');
4346: lv_error_message := 'Tax Unit is enabled for localization but is not specified';
4347: lv_error_message := pay_emp_action_arch.set_error_message(lv_error_message);
4348: hr_utility.raise_error;
4349: END IF;
4350:
4351: ln_step := 2;
4352: /*Get the payroll action information belongs to archiver payroll action */

Line 4360: hr_utility.set_location(gv_package || lv_procedure_name, 15);

4356: ,p_business_group_id => ln_business_group_id
4357: ,p_cons_set_id => ln_cons_set_id
4358: ,p_payroll_id => ln_payroll_id);
4359:
4360: hr_utility.set_location(gv_package || lv_procedure_name, 15);
4361:
4362: ln_step := 3;
4363: pay_emp_action_arch.gv_multi_payroll_pymt
4364: := pay_emp_action_arch.get_multi_assignment_flag(

Line 4371: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||

4367:
4368: /*International Payroll product is not supporting Mulit assignment feature
4369: pay_emp_action_arch.gv_multi_payroll_pymt always returns 'N' */
4370:
4371: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
4372: pay_emp_action_arch.gv_multi_payroll_pymt);
4373:
4374: ln_step := 4;
4375: hr_utility.set_location(gv_package || lv_procedure_name, 20);

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

4371: hr_utility.trace('pay_emp_action_arch.gv_multi_payroll_pymt = ' ||
4372: pay_emp_action_arch.gv_multi_payroll_pymt);
4373:
4374: ln_step := 4;
4375: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4376:
4377: -- process the master_action
4378: lv_master_action_type := SUBSTR(lv_xfr_master_serial_number,1,1);
4379: -- Always N FOR Master Assignment Action

Line 4388: hr_utility.trace('Payroll Action FOR Archiver Process Not Found');

4384: ln_step := 5;
4385: OPEN c_pymt_eff_date(ln_asg_action_id); --Passing Prepayment action ID
4386: FETCH c_pymt_eff_date INTO ld_curr_pymt_eff_date;
4387: IF c_pymt_eff_date%NOTFOUND THEN
4388: hr_utility.trace('Payroll Action FOR Archiver Process Not Found');
4389: hr_utility.raise_error;
4390: END IF;
4391: CLOSE c_pymt_eff_date;
4392: --Fetched Effective date of Prepayments

Line 4389: hr_utility.raise_error;

4385: OPEN c_pymt_eff_date(ln_asg_action_id); --Passing Prepayment action ID
4386: FETCH c_pymt_eff_date INTO ld_curr_pymt_eff_date;
4387: IF c_pymt_eff_date%NOTFOUND THEN
4388: hr_utility.trace('Payroll Action FOR Archiver Process Not Found');
4389: hr_utility.raise_error;
4390: END IF;
4391: CLOSE c_pymt_eff_date;
4392: --Fetched Effective date of Prepayments
4393:

Line 4394: hr_utility.trace('Archiver Information****');

4390: END IF;
4391: CLOSE c_pymt_eff_date;
4392: --Fetched Effective date of Prepayments
4393:
4394: hr_utility.trace('******Archiver Information**********');
4395: hr_utility.trace('End Date=' || TO_CHAR(ld_end_date, 'dd-mon-yyyy'));
4396: hr_utility.trace('Start Date=' || TO_CHAR(ld_start_date, 'dd-mon-yyyy'));
4397: hr_utility.trace('Business Group Id=' || TO_CHAR(ln_business_group_id));
4398: hr_utility.trace('Serial Number=' || lv_xfr_master_serial_number);

Line 4395: hr_utility.trace('End Date=' || TO_CHAR(ld_end_date, 'dd-mon-yyyy'));

4391: CLOSE c_pymt_eff_date;
4392: --Fetched Effective date of Prepayments
4393:
4394: hr_utility.trace('******Archiver Information**********');
4395: hr_utility.trace('End Date=' || TO_CHAR(ld_end_date, 'dd-mon-yyyy'));
4396: hr_utility.trace('Start Date=' || TO_CHAR(ld_start_date, 'dd-mon-yyyy'));
4397: hr_utility.trace('Business Group Id=' || TO_CHAR(ln_business_group_id));
4398: hr_utility.trace('Serial Number=' || lv_xfr_master_serial_number);
4399: hr_utility.trace('ln_xfr_payroll_action_id =' ||

Line 4396: hr_utility.trace('Start Date=' || TO_CHAR(ld_start_date, 'dd-mon-yyyy'));

4392: --Fetched Effective date of Prepayments
4393:
4394: hr_utility.trace('******Archiver Information**********');
4395: hr_utility.trace('End Date=' || TO_CHAR(ld_end_date, 'dd-mon-yyyy'));
4396: hr_utility.trace('Start Date=' || TO_CHAR(ld_start_date, 'dd-mon-yyyy'));
4397: hr_utility.trace('Business Group Id=' || TO_CHAR(ln_business_group_id));
4398: hr_utility.trace('Serial Number=' || lv_xfr_master_serial_number);
4399: hr_utility.trace('ln_xfr_payroll_action_id =' ||
4400: TO_CHAR(ln_xfr_payroll_action_id));

Line 4397: hr_utility.trace('Business Group Id=' || TO_CHAR(ln_business_group_id));

4393:
4394: hr_utility.trace('******Archiver Information**********');
4395: hr_utility.trace('End Date=' || TO_CHAR(ld_end_date, 'dd-mon-yyyy'));
4396: hr_utility.trace('Start Date=' || TO_CHAR(ld_start_date, 'dd-mon-yyyy'));
4397: hr_utility.trace('Business Group Id=' || TO_CHAR(ln_business_group_id));
4398: hr_utility.trace('Serial Number=' || lv_xfr_master_serial_number);
4399: hr_utility.trace('ln_xfr_payroll_action_id =' ||
4400: TO_CHAR(ln_xfr_payroll_action_id));
4401:

Line 4398: hr_utility.trace('Serial Number=' || lv_xfr_master_serial_number);

4394: hr_utility.trace('******Archiver Information**********');
4395: hr_utility.trace('End Date=' || TO_CHAR(ld_end_date, 'dd-mon-yyyy'));
4396: hr_utility.trace('Start Date=' || TO_CHAR(ld_start_date, 'dd-mon-yyyy'));
4397: hr_utility.trace('Business Group Id=' || TO_CHAR(ln_business_group_id));
4398: hr_utility.trace('Serial Number=' || lv_xfr_master_serial_number);
4399: hr_utility.trace('ln_xfr_payroll_action_id =' ||
4400: TO_CHAR(ln_xfr_payroll_action_id));
4401:
4402: ln_step := 6;

Line 4399: hr_utility.trace('ln_xfr_payroll_action_id =' ||

4395: hr_utility.trace('End Date=' || TO_CHAR(ld_end_date, 'dd-mon-yyyy'));
4396: hr_utility.trace('Start Date=' || TO_CHAR(ld_start_date, 'dd-mon-yyyy'));
4397: hr_utility.trace('Business Group Id=' || TO_CHAR(ln_business_group_id));
4398: hr_utility.trace('Serial Number=' || lv_xfr_master_serial_number);
4399: hr_utility.trace('ln_xfr_payroll_action_id =' ||
4400: TO_CHAR(ln_xfr_payroll_action_id));
4401:
4402: ln_step := 6;
4403: IF lv_master_action_type IN ( 'P','U') THEN

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

4409: ln_step := 7;
4410: --Fetching assignment_id, tax_unit_id, source_action_id
4411: OPEN c_payment_info(ln_asg_action_id);
4412: LOOP
4413: hr_utility.set_location(gv_package || lv_procedure_name, 30);
4414: FETCH c_payment_info INTO ln_assignment_id
4415: ,ln_tax_unit_id
4416: ,ln_source_action_id
4417: ,ln_asg_action_id;

Line 4427: hr_utility.trace('Archive_code:payment_info: ln_asg_action_id' ||

4423: 3. ln_asg_action_id is a prepayment assignment action id
4424: 4. above c_payment_info gets all assignment ids which are locked pre payment actions
4425: */
4426:
4427: hr_utility.trace('Archive_code:payment_info: ln_asg_action_id' ||
4428: ln_asg_action_id );
4429: hr_utility.trace('Archive_code:payment_info: ln_assignment_id' ||
4430: ln_assignment_id );
4431: hr_utility.trace('Archive_code:payment_info: ln_tax_unit_id' ||

Line 4429: hr_utility.trace('Archive_code:payment_info: ln_assignment_id' ||

4425: */
4426:
4427: hr_utility.trace('Archive_code:payment_info: ln_asg_action_id' ||
4428: ln_asg_action_id );
4429: hr_utility.trace('Archive_code:payment_info: ln_assignment_id' ||
4430: ln_assignment_id );
4431: hr_utility.trace('Archive_code:payment_info: ln_tax_unit_id' ||
4432: ln_tax_unit_id );
4433: hr_utility.trace('Archive_code:payment_info: ln_source_action_id' ||

Line 4431: hr_utility.trace('Archive_code:payment_info: ln_tax_unit_id' ||

4427: hr_utility.trace('Archive_code:payment_info: ln_asg_action_id' ||
4428: ln_asg_action_id );
4429: hr_utility.trace('Archive_code:payment_info: ln_assignment_id' ||
4430: ln_assignment_id );
4431: hr_utility.trace('Archive_code:payment_info: ln_tax_unit_id' ||
4432: ln_tax_unit_id );
4433: hr_utility.trace('Archive_code:payment_info: ln_source_action_id' ||
4434: ln_source_action_id );
4435:

Line 4433: hr_utility.trace('Archive_code:payment_info: ln_source_action_id' ||

4429: hr_utility.trace('Archive_code:payment_info: ln_assignment_id' ||
4430: ln_assignment_id );
4431: hr_utility.trace('Archive_code:payment_info: ln_tax_unit_id' ||
4432: ln_tax_unit_id );
4433: hr_utility.trace('Archive_code:payment_info: ln_source_action_id' ||
4434: ln_source_action_id );
4435:
4436: ln_step := 8;
4437:

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

4435:
4436: ln_step := 8;
4437:
4438: IF ln_source_action_id = -999 THEN /* True for Normal runs*/
4439: hr_utility.set_location(gv_package || lv_procedure_name, 40);
4440: ln_step := 9;
4441: lv_master_sepcheck_flag := 'N';
4442: ln_master_run_aa_id := NULL;
4443: ln_is_run_qp_found := 0;

Line 4462: hr_utility.trace('GRE ln_run_aa_id = '||ln_run_aa_id);

4458: END IF;
4459: CLOSE c_run_aa_id;
4460:
4461: ln_step := 10;
4462: hr_utility.trace('GRE ln_run_aa_id = '||ln_run_aa_id);
4463: hr_utility.trace('GRE ln_run_source_action_id = '||ln_run_source_action_id);
4464:
4465: IF ln_run_source_action_id IS NOT NULL THEN
4466: ln_master_run_aa_id := ln_run_source_action_id; -- Normal Chk

Line 4463: hr_utility.trace('GRE ln_run_source_action_id = '||ln_run_source_action_id);

4459: CLOSE c_run_aa_id;
4460:
4461: ln_step := 10;
4462: hr_utility.trace('GRE ln_run_aa_id = '||ln_run_aa_id);
4463: hr_utility.trace('GRE ln_run_source_action_id = '||ln_run_source_action_id);
4464:
4465: IF ln_run_source_action_id IS NOT NULL THEN
4466: ln_master_run_aa_id := ln_run_source_action_id; -- Normal Chk
4467: ELSE

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

4466: ln_master_run_aa_id := ln_run_source_action_id; -- Normal Chk
4467: ELSE
4468: IF ln_is_run_qp_found = 0 THEN
4469: /* Balance Adjustment or Reversal */
4470: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4471: OPEN c_run_aa_id_bal_adj(ln_asg_action_id
4472: ,ln_assignment_id
4473: ,ln_tax_unit_id);
4474: FETCH c_run_aa_id_bal_adj INTO ln_run_aa_id,

Line 4478: hr_utility.trace(' Balance Adjustment or Reversal ');

4474: FETCH c_run_aa_id_bal_adj INTO ln_run_aa_id,
4475: ln_run_source_action_id;
4476: CLOSE c_run_aa_id_bal_adj;
4477: ln_master_run_aa_id := ln_asg_action_id; /*ln_asg_action_id : prepayment assignment action*/
4478: hr_utility.trace('**** Balance Adjustment or Reversal ****');
4479: hr_utility.trace('GRE ln_run_aa_id = '||ln_run_aa_id);
4480: hr_utility.trace('GRE ln_run_source_action_id = '||ln_run_source_action_id);
4481: ELSE
4482: -- This will never be entered since the source_action_id is NULL

Line 4479: hr_utility.trace('GRE ln_run_aa_id = '||ln_run_aa_id);

4475: ln_run_source_action_id;
4476: CLOSE c_run_aa_id_bal_adj;
4477: ln_master_run_aa_id := ln_asg_action_id; /*ln_asg_action_id : prepayment assignment action*/
4478: hr_utility.trace('**** Balance Adjustment or Reversal ****');
4479: hr_utility.trace('GRE ln_run_aa_id = '||ln_run_aa_id);
4480: hr_utility.trace('GRE ln_run_source_action_id = '||ln_run_source_action_id);
4481: ELSE
4482: -- This will never be entered since the source_action_id is NULL
4483: -- IS already ruled out in the cursor c_run_aa_id

Line 4480: hr_utility.trace('GRE ln_run_source_action_id = '||ln_run_source_action_id);

4476: CLOSE c_run_aa_id_bal_adj;
4477: ln_master_run_aa_id := ln_asg_action_id; /*ln_asg_action_id : prepayment assignment action*/
4478: hr_utility.trace('**** Balance Adjustment or Reversal ****');
4479: hr_utility.trace('GRE ln_run_aa_id = '||ln_run_aa_id);
4480: hr_utility.trace('GRE ln_run_source_action_id = '||ln_run_source_action_id);
4481: ELSE
4482: -- This will never be entered since the source_action_id is NULL
4483: -- IS already ruled out in the cursor c_run_aa_id
4484: --

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

4491: ln_step := 11;
4492:
4493: ELSE
4494: /*Separate process and payment*/
4495: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4496: ln_step := 12;
4497: lv_master_sepcheck_flag := 'Y';
4498: ln_master_run_aa_id := ln_source_action_id; -- Sep Chk
4499: ln_rqp_action_id := ln_source_action_id; -- Sep Chk

Line 4517: hr_utility.set_location(gv_package || lv_procedure_name, 70);

4513: SELECT pay_assignment_actions_s.nextval
4514: INTO ln_child_xfr_action_id
4515: FROM dual;
4516:
4517: hr_utility.set_location(gv_package || lv_procedure_name, 70);
4518:
4519: -- insert into pay_assignment_actions.
4520:
4521: ln_step := 14;

Line 4533: hr_utility.set_location(gv_package || lv_procedure_name, 80);

4529: NULL,
4530: 'C',
4531: p_xfr_action_id);
4532:
4533: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4534:
4535: hr_utility.trace('GRE Locking Action = ' ||ln_child_xfr_action_id);
4536: hr_utility.trace('GRE Locked Action = ' ||ln_asg_action_id);
4537:

Line 4535: hr_utility.trace('GRE Locking Action = ' ||ln_child_xfr_action_id);

4531: p_xfr_action_id);
4532:
4533: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4534:
4535: hr_utility.trace('GRE Locking Action = ' ||ln_child_xfr_action_id);
4536: hr_utility.trace('GRE Locked Action = ' ||ln_asg_action_id);
4537:
4538: -- insert an interlock to this action
4539:

Line 4536: hr_utility.trace('GRE Locked Action = ' ||ln_asg_action_id);

4532:
4533: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4534:
4535: hr_utility.trace('GRE Locking Action = ' ||ln_child_xfr_action_id);
4536: hr_utility.trace('GRE Locked Action = ' ||ln_asg_action_id);
4537:
4538: -- insert an interlock to this action
4539:
4540: ln_step := 15;

Line 4556: hr_utility.trace('Processing Child action ' ||

4552: update pay_assignment_actions
4553: set serial_number = lv_serial_number
4554: WHERE assignment_action_id = ln_child_xfr_action_id;
4555:
4556: hr_utility.trace('Processing Child action ' ||
4557: p_xfr_action_id);
4558:
4559: ELSE --not seperate payment
4560: ln_step := 18;

Line 4574: hr_utility.set_location(gv_package || lv_procedure_name, 90);

4570:
4571: IF ln_source_action_id = -999 THEN --normal run
4572:
4573: ln_step := 20;
4574: hr_utility.set_location(gv_package || lv_procedure_name, 90);
4575:
4576: IF gv_is_tax_unit_enabled = 'Y' THEN
4577: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);
4578: END IF;

Line 4579: hr_utility.trace('ln_asg_action_id = '||ln_asg_action_id);

4575:
4576: IF gv_is_tax_unit_enabled = 'Y' THEN
4577: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);
4578: END IF;
4579: hr_utility.trace('ln_asg_action_id = '||ln_asg_action_id);
4580: ln_earnings := NVL(pay_balance_pkg.get_value(
4581: gn_payments_def_bal_id, /*Total Payment Balance with dimension _PAYMENTS*/
4582: ln_asg_action_id),0);
4583: hr_utility.trace('ln_earnings = ' ||ln_earnings);

Line 4583: hr_utility.trace('ln_earnings = ' ||ln_earnings);

4579: hr_utility.trace('ln_asg_action_id = '||ln_asg_action_id);
4580: ln_earnings := NVL(pay_balance_pkg.get_value(
4581: gn_payments_def_bal_id, /*Total Payment Balance with dimension _PAYMENTS*/
4582: ln_asg_action_id),0);
4583: hr_utility.trace('ln_earnings = ' ||ln_earnings);
4584:
4585: /*Checking for non-zero payment*/
4586:
4587: ELSE

Line 4593: hr_utility.trace('ln_earnings = ' ||ln_earnings);

4589: END IF; -- IF ln_source_action_id = -999
4590:
4591: END IF; --gn_payments_def_bal_id <> 0
4592:
4593: hr_utility.trace('ln_earnings = ' ||ln_earnings);
4594: ln_step := 21;
4595: IF ln_earnings = 0 AND
4596: ln_xfr_assignment_id = ln_assignment_id AND
4597: pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' THEN

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

4603:
4604: /* Multi Payroll payment functionality is not supported for Intl Payroll
4605: gv_multi_payroll_pymt is 'N' always */
4606: ln_step := 22;
4607: hr_utility.set_location(gv_package || lv_procedure_name, 100);
4608:
4609: hr_utility.trace('ln_earnings = '||ln_earnings);
4610: IF ln_earnings > 0 THEN
4611: process_actions(p_xfr_payroll_action_id => ln_xfr_payroll_action_id

Line 4609: hr_utility.trace('ln_earnings = '||ln_earnings);

4605: gv_multi_payroll_pymt is 'N' always */
4606: ln_step := 22;
4607: hr_utility.set_location(gv_package || lv_procedure_name, 100);
4608:
4609: hr_utility.trace('ln_earnings = '||ln_earnings);
4610: IF ln_earnings > 0 THEN
4611: process_actions(p_xfr_payroll_action_id => ln_xfr_payroll_action_id
4612: ,p_xfr_action_id => ln_child_xfr_action_id
4613: ,p_pre_pay_action_id => ln_asg_action_id

Line 4636: hr_utility.trace('pay_ac_action_arch.g_xfr_run_exists = '||

4632: END LOOP; -- c_payment_info
4633:
4634: CLOSE c_payment_info;
4635:
4636: hr_utility.trace('pay_ac_action_arch.g_xfr_run_exists = '||
4637: pay_ac_action_arch.g_xfr_run_exists );
4638: hr_utility.set_location(gv_package || lv_procedure_name, 110);
4639:
4640: END IF; /* P,U */

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

4634: CLOSE c_payment_info;
4635:
4636: hr_utility.trace('pay_ac_action_arch.g_xfr_run_exists = '||
4637: pay_ac_action_arch.g_xfr_run_exists );
4638: hr_utility.set_location(gv_package || lv_procedure_name, 110);
4639:
4640: END IF; /* P,U */
4641:
4642: ln_step := 24;

Line 4645: hr_utility.trace('Populating Current Elements FOR Balance Adjustments');

4641:
4642: ln_step := 24;
4643:
4644: IF lv_master_action_type = 'B' THEN
4645: hr_utility.trace('Populating Current Elements FOR Balance Adjustments');
4646: /* ln_asg_action_id is nothing but Balance Adjustment run action id */
4647: hr_utility.set_location(gv_package || lv_procedure_name, 120);
4648: ln_asg_action_id := -1;
4649: pay_ac_action_arch.initialization_process;

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

4643:
4644: IF lv_master_action_type = 'B' THEN
4645: hr_utility.trace('Populating Current Elements FOR Balance Adjustments');
4646: /* ln_asg_action_id is nothing but Balance Adjustment run action id */
4647: hr_utility.set_location(gv_package || lv_procedure_name, 120);
4648: ln_asg_action_id := -1;
4649: pay_ac_action_arch.initialization_process;
4650:
4651: OPEN c_get_emp_adjbal(p_xfr_action_id);

Line 4657: hr_utility.trace('Bal Adjustment ln_pymt_balcall_aaid'

4653: FETCH c_get_emp_adjbal INTO ln_asg_action_id;
4654: EXIT WHEN c_get_emp_adjbal%NOTFOUND;
4655:
4656: ln_pymt_balcall_aaid := ln_asg_action_id ;
4657: hr_utility.trace('Bal Adjustment ln_pymt_balcall_aaid'
4658: ||to_char(ln_pymt_balcall_aaid));
4659:
4660: ln_step := 25;
4661:

Line 4662: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));

4658: ||to_char(ln_pymt_balcall_aaid));
4659:
4660: ln_step := 25;
4661:
4662: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
4663: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
4664: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
4665: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
4666:

Line 4663: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));

4659:
4660: ln_step := 25;
4661:
4662: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
4663: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
4664: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
4665: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
4666:
4667: /* Need to pass Payslip Archiver Assignment_Action_id to

Line 4664: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));

4660: ln_step := 25;
4661:
4662: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
4663: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
4664: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
4665: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
4666:
4667: /* Need to pass Payslip Archiver Assignment_Action_id to
4668: p_curr_pymt_action_id because we have to archive Bal Adjustments

Line 4665: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));

4661:
4662: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
4663: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));
4664: hr_utility.trace('ld_curr_pymt_eff_date :'||to_char(ld_curr_pymt_eff_date,'DD-MON-YYYY'));
4665: hr_utility.trace('ln_assignment_id :'||to_char(ln_assignment_id));
4666:
4667: /* Need to pass Payslip Archiver Assignment_Action_id to
4668: p_curr_pymt_action_id because we have to archive Bal Adjustments
4669: that are not marked for 'Pre-Payment', Otherwise nothing

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

4667: /* Need to pass Payslip Archiver Assignment_Action_id to
4668: p_curr_pymt_action_id because we have to archive Bal Adjustments
4669: that are not marked for 'Pre-Payment', Otherwise nothing
4670: will be archived. */
4671: hr_utility.set_location(gv_package || lv_procedure_name, 130);
4672:
4673: IF ln_asg_action_id <> -1 AND ln_asg_action_id IS NOT NULL THEN
4674: ln_step := 26;
4675: get_current_elements(

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

4704: ** Archive all the payroll action level data once only when
4705: ** chunk number is 1. Also check if this has not been archived
4706: ** earlier
4707: *****************************************************************/
4708: hr_utility.set_location(gv_package || lv_procedure_name,140);
4709: ln_step := 28;
4710: OPEN c_check_pay_action(ln_xfr_payroll_action_id);
4711: FETCH c_check_pay_action INTO ln_pay_action_count;
4712: CLOSE c_check_pay_action;

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

4710: OPEN c_check_pay_action(ln_xfr_payroll_action_id);
4711: FETCH c_check_pay_action INTO ln_pay_action_count;
4712: CLOSE c_check_pay_action;
4713: IF ln_pay_action_count = 0 THEN
4714: hr_utility.set_location(gv_package || lv_procedure_name,150);
4715: IF ln_chunk_number = 1 THEN
4716: ln_step := 29;
4717:
4718: arch_pay_action_level_data(

Line 4732: hr_utility.trace(lv_error_message || '-' || SQLERRM);

4728: EXCEPTION
4729: WHEN OTHERS THEN
4730: lv_error_message := 'Error at step ' || ln_step || ' IN ' || gv_package || lv_procedure_name;
4731:
4732: hr_utility.trace(lv_error_message || '-' || SQLERRM);
4733:
4734: lv_error_message :=
4735: pay_emp_action_arch.set_error_message(lv_error_message);
4736:

Line 4737: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

4733:
4734: lv_error_message :=
4735: pay_emp_action_arch.set_error_message(lv_error_message);
4736:
4737: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4738: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4739: hr_utility.raise_error;
4740:
4741: END archive_code;

Line 4738: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

4734: lv_error_message :=
4735: pay_emp_action_arch.set_error_message(lv_error_message);
4736:
4737: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4738: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4739: hr_utility.raise_error;
4740:
4741: END archive_code;
4742:

Line 4739: hr_utility.raise_error;

4735: pay_emp_action_arch.set_error_message(lv_error_message);
4736:
4737: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4738: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4739: hr_utility.raise_error;
4740:
4741: END archive_code;
4742:
4743: BEGIN

Line 4744: --hr_utility.trace_on (NULL, 'IP_PAYROLL_ARCHIVE');

4740:
4741: END archive_code;
4742:
4743: BEGIN
4744: --hr_utility.trace_on (NULL, 'IP_PAYROLL_ARCHIVE');
4745: gv_package := 'pay_ip_payroll_arch';
4746:
4747: END pay_ip_payroll_arch;