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_AU_PAYMENT_SUMMARY_REPORT dependencies on HR_UTILITY

Line 52: hr_utility.set_location('Start of range_code',1);

48: procedure range_code
49: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
50: p_sql out NOCOPY varchar2) is
51: begin
52: hr_utility.set_location('Start of range_code',1);
53:
54: /*Bug2920725 Corrected base tables to support security model*/
55:
56: p_sql := ' select distinct p.person_id' ||

Line 63: hr_utility.set_location('End of range_code',2);

59: ' where pa.payroll_action_id = :payroll_action_id' ||
60: ' and p.business_group_id = pa.business_group_id' ||
61: ' order by p.person_id';
62:
63: hr_utility.set_location('End of range_code',2);
64: end range_code;
65:
66:
67: /*

Line 104: g_debug := hr_utility.debug_enabled;

100: l_report_param_val varchar2(30);
101:
102: BEGIN
103:
104: g_debug := hr_utility.debug_enabled;
105:
106: BEGIN
107:
108: open csr_action_parameter;

Line 123: hr_utility.set_location('Range Person = True',1);

119: --
120: IF l_action_param_val = 'Y' AND l_report_param_val = 'Y' THEN
121: l_return := TRUE;
122: IF g_debug THEN
123: hr_utility.set_location('Range Person = True',1);
124: END IF;
125: ELSE
126: l_return := FALSE;
127: END IF;

Line 405: g_debug := hr_utility.debug_enabled;

401: /* End Bug 6470581 */
402:
403: BEGIN
404:
405: g_debug := hr_utility.debug_enabled;
406:
407: IF g_debug
408: THEN
409: hr_utility.set_location('Start of assignment_action_code',3);

Line 409: hr_utility.set_location('Start of assignment_action_code',3);

405: g_debug := hr_utility.debug_enabled;
406:
407: IF g_debug
408: THEN
409: hr_utility.set_location('Start of assignment_action_code',3);
410: hr_utility.set_location('The payroll_action_id passed '|| p_payroll_action_id,4);
411: hr_utility.set_location('The p_start_person_id '|| p_start_person_id,5);
412: hr_utility.set_location('The p_end_person_id '|| p_end_person_id,6);
413: hr_utility.set_location('The p_chunk number '|| p_chunk ,7);

Line 410: hr_utility.set_location('The payroll_action_id passed '|| p_payroll_action_id,4);

406:
407: IF g_debug
408: THEN
409: hr_utility.set_location('Start of assignment_action_code',3);
410: hr_utility.set_location('The payroll_action_id passed '|| p_payroll_action_id,4);
411: hr_utility.set_location('The p_start_person_id '|| p_start_person_id,5);
412: hr_utility.set_location('The p_end_person_id '|| p_end_person_id,6);
413: hr_utility.set_location('The p_chunk number '|| p_chunk ,7);
414: END IF;

Line 411: hr_utility.set_location('The p_start_person_id '|| p_start_person_id,5);

407: IF g_debug
408: THEN
409: hr_utility.set_location('Start of assignment_action_code',3);
410: hr_utility.set_location('The payroll_action_id passed '|| p_payroll_action_id,4);
411: hr_utility.set_location('The p_start_person_id '|| p_start_person_id,5);
412: hr_utility.set_location('The p_end_person_id '|| p_end_person_id,6);
413: hr_utility.set_location('The p_chunk number '|| p_chunk ,7);
414: END IF;
415:

Line 412: hr_utility.set_location('The p_end_person_id '|| p_end_person_id,6);

408: THEN
409: hr_utility.set_location('Start of assignment_action_code',3);
410: hr_utility.set_location('The payroll_action_id passed '|| p_payroll_action_id,4);
411: hr_utility.set_location('The p_start_person_id '|| p_start_person_id,5);
412: hr_utility.set_location('The p_end_person_id '|| p_end_person_id,6);
413: hr_utility.set_location('The p_chunk number '|| p_chunk ,7);
414: END IF;
415:
416: /* Bug 6470581 - Fetch the Payment Summary Type details.

Line 413: hr_utility.set_location('The p_chunk number '|| p_chunk ,7);

409: hr_utility.set_location('Start of assignment_action_code',3);
410: hr_utility.set_location('The payroll_action_id passed '|| p_payroll_action_id,4);
411: hr_utility.set_location('The p_start_person_id '|| p_start_person_id,5);
412: hr_utility.set_location('The p_end_person_id '|| p_end_person_id,6);
413: hr_utility.set_location('The p_chunk number '|| p_chunk ,7);
414: END IF;
415:
416: /* Bug 6470581 - Fetch the Payment Summary Type details.
417: If Type is 'O' (Original), lock only Archive action

Line 448: hr_utility.set_location('Assignment_ID '||csr_rec.assignment_id,35);

444: null);
445: hr_nonrun_asact.insint(v_next_action_id,csr_rec.assignment_action_id);
446: IF g_debug
447: THEN
448: hr_utility.set_location('Assignment_ID '||csr_rec.assignment_id,35);
449: hr_utility.set_location('New Ass Action ID '||v_next_action_id,40);
450: hr_utility.set_location('Locked Archive Action ID '||csr_rec.assignment_action_id,45);
451: END IF;
452: END LOOP;

Line 449: hr_utility.set_location('New Ass Action ID '||v_next_action_id,40);

445: hr_nonrun_asact.insint(v_next_action_id,csr_rec.assignment_action_id);
446: IF g_debug
447: THEN
448: hr_utility.set_location('Assignment_ID '||csr_rec.assignment_id,35);
449: hr_utility.set_location('New Ass Action ID '||v_next_action_id,40);
450: hr_utility.set_location('Locked Archive Action ID '||csr_rec.assignment_action_id,45);
451: END IF;
452: END LOOP;
453:

Line 450: hr_utility.set_location('Locked Archive Action ID '||csr_rec.assignment_action_id,45);

446: IF g_debug
447: THEN
448: hr_utility.set_location('Assignment_ID '||csr_rec.assignment_id,35);
449: hr_utility.set_location('New Ass Action ID '||v_next_action_id,40);
450: hr_utility.set_location('Locked Archive Action ID '||csr_rec.assignment_action_id,45);
451: END IF;
452: END LOOP;
453:
454: ELSE

Line 460: hr_utility.set_location('LOOP STARTED '|| process_rec.assignment_id ,14);

456: for process_rec in process_assignments (p_payroll_action_id,
457: p_start_person_id,
458: p_end_person_id)
459: loop
460: hr_utility.set_location('LOOP STARTED '|| process_rec.assignment_id ,14);
461: open next_action_id;
462: fetch next_action_id into v_next_action_id;
463: close next_action_id;
464: hr_utility.set_location('before calling insact '|| v_next_action_id ,14);

Line 464: hr_utility.set_location('before calling insact '|| v_next_action_id ,14);

460: hr_utility.set_location('LOOP STARTED '|| process_rec.assignment_id ,14);
461: open next_action_id;
462: fetch next_action_id into v_next_action_id;
463: close next_action_id;
464: hr_utility.set_location('before calling insact '|| v_next_action_id ,14);
465: hr_nonrun_asact.insact(v_next_action_id,
466: process_rec.assignment_id,
467: p_payroll_action_id,
468: p_chunk,

Line 470: hr_utility.set_location('inserted assigment action assignment '|| process_rec.assignment_id ,15);

466: process_rec.assignment_id,
467: p_payroll_action_id,
468: p_chunk,
469: null);
470: hr_utility.set_location('inserted assigment action assignment '|| process_rec.assignment_id ,15);
471: hr_utility.set_location('Before calling hr_nonrun_asact.insint archive ' || process_rec.archive_action_id,16);
472: hr_utility.set_location('v_next_action_id' || v_next_action_id,16);
473: hr_nonrun_asact.insint(v_next_action_id,process_rec.assignment_action_id);
474: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);

Line 471: hr_utility.set_location('Before calling hr_nonrun_asact.insint archive ' || process_rec.archive_action_id,16);

467: p_payroll_action_id,
468: p_chunk,
469: null);
470: hr_utility.set_location('inserted assigment action assignment '|| process_rec.assignment_id ,15);
471: hr_utility.set_location('Before calling hr_nonrun_asact.insint archive ' || process_rec.archive_action_id,16);
472: hr_utility.set_location('v_next_action_id' || v_next_action_id,16);
473: hr_nonrun_asact.insint(v_next_action_id,process_rec.assignment_action_id);
474: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
475: end loop;

Line 472: hr_utility.set_location('v_next_action_id' || v_next_action_id,16);

468: p_chunk,
469: null);
470: hr_utility.set_location('inserted assigment action assignment '|| process_rec.assignment_id ,15);
471: hr_utility.set_location('Before calling hr_nonrun_asact.insint archive ' || process_rec.archive_action_id,16);
472: hr_utility.set_location('v_next_action_id' || v_next_action_id,16);
473: hr_nonrun_asact.insint(v_next_action_id,process_rec.assignment_action_id);
474: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
475: end loop;
476: hr_utility.set_location('End of assignment_action_code',5);

Line 474: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);

470: hr_utility.set_location('inserted assigment action assignment '|| process_rec.assignment_id ,15);
471: hr_utility.set_location('Before calling hr_nonrun_asact.insint archive ' || process_rec.archive_action_id,16);
472: hr_utility.set_location('v_next_action_id' || v_next_action_id,16);
473: hr_nonrun_asact.insint(v_next_action_id,process_rec.assignment_action_id);
474: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
475: end loop;
476: hr_utility.set_location('End of assignment_action_code',5);
477: END IF;
478:

Line 476: hr_utility.set_location('End of assignment_action_code',5);

472: hr_utility.set_location('v_next_action_id' || v_next_action_id,16);
473: hr_nonrun_asact.insint(v_next_action_id,process_rec.assignment_action_id);
474: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
475: end loop;
476: hr_utility.set_location('End of assignment_action_code',5);
477: END IF;
478:
479: ELSIF l_get_paysum_details.payment_summary_type = 'A'
480: THEN

Line 483: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);

479: ELSIF l_get_paysum_details.payment_summary_type = 'A'
480: THEN
481: IF range_person_on THEN /* 9113084 - Use new Range Person Cursor if Range Person is enabled */
482: IF g_debug THEN
483: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
484: END IF;
485: FOR csr_rec IN rg_amend_process_assignments(p_payroll_action_id
486: ,p_chunk
487: ,l_get_paysum_details.archive_id

Line 505: hr_utility.set_location('Assignment_ID '||csr_rec.assignment_id,35);

501: hr_nonrun_asact.insint(v_next_action_id,csr_rec.datafile_action_id);
502:
503: IF g_debug
504: THEN
505: hr_utility.set_location('Assignment_ID '||csr_rec.assignment_id,35);
506: hr_utility.set_location('New Ass Action ID '||v_next_action_id,40);
507: hr_utility.set_location('Locked Archive Action ID '||csr_rec.assignment_action_id,45);
508: hr_utility.set_location('Locked Data file Action ID '||csr_rec.datafile_action_id,50);
509: END IF;

Line 506: hr_utility.set_location('New Ass Action ID '||v_next_action_id,40);

502:
503: IF g_debug
504: THEN
505: hr_utility.set_location('Assignment_ID '||csr_rec.assignment_id,35);
506: hr_utility.set_location('New Ass Action ID '||v_next_action_id,40);
507: hr_utility.set_location('Locked Archive Action ID '||csr_rec.assignment_action_id,45);
508: hr_utility.set_location('Locked Data file Action ID '||csr_rec.datafile_action_id,50);
509: END IF;
510: END LOOP;

Line 507: hr_utility.set_location('Locked Archive Action ID '||csr_rec.assignment_action_id,45);

503: IF g_debug
504: THEN
505: hr_utility.set_location('Assignment_ID '||csr_rec.assignment_id,35);
506: hr_utility.set_location('New Ass Action ID '||v_next_action_id,40);
507: hr_utility.set_location('Locked Archive Action ID '||csr_rec.assignment_action_id,45);
508: hr_utility.set_location('Locked Data file Action ID '||csr_rec.datafile_action_id,50);
509: END IF;
510: END LOOP;
511: ELSE /* 9113084 - Use Old logic if Range Person is disabled */

Line 508: hr_utility.set_location('Locked Data file Action ID '||csr_rec.datafile_action_id,50);

504: THEN
505: hr_utility.set_location('Assignment_ID '||csr_rec.assignment_id,35);
506: hr_utility.set_location('New Ass Action ID '||v_next_action_id,40);
507: hr_utility.set_location('Locked Archive Action ID '||csr_rec.assignment_action_id,45);
508: hr_utility.set_location('Locked Data file Action ID '||csr_rec.datafile_action_id,50);
509: END IF;
510: END LOOP;
511: ELSE /* 9113084 - Use Old logic if Range Person is disabled */
512:

Line 534: hr_utility.set_location('Assignment_ID '||csr_rec.assignment_id,35);

530: hr_nonrun_asact.insint(v_next_action_id,csr_rec.datafile_action_id);
531:
532: IF g_debug
533: THEN
534: hr_utility.set_location('Assignment_ID '||csr_rec.assignment_id,35);
535: hr_utility.set_location('New Ass Action ID '||v_next_action_id,40);
536: hr_utility.set_location('Locked Archive Action ID '||csr_rec.assignment_action_id,45);
537: hr_utility.set_location('Locked Data file Action ID '||csr_rec.datafile_action_id,50);
538: END IF;

Line 535: hr_utility.set_location('New Ass Action ID '||v_next_action_id,40);

531:
532: IF g_debug
533: THEN
534: hr_utility.set_location('Assignment_ID '||csr_rec.assignment_id,35);
535: hr_utility.set_location('New Ass Action ID '||v_next_action_id,40);
536: hr_utility.set_location('Locked Archive Action ID '||csr_rec.assignment_action_id,45);
537: hr_utility.set_location('Locked Data file Action ID '||csr_rec.datafile_action_id,50);
538: END IF;
539: END LOOP;

Line 536: hr_utility.set_location('Locked Archive Action ID '||csr_rec.assignment_action_id,45);

532: IF g_debug
533: THEN
534: hr_utility.set_location('Assignment_ID '||csr_rec.assignment_id,35);
535: hr_utility.set_location('New Ass Action ID '||v_next_action_id,40);
536: hr_utility.set_location('Locked Archive Action ID '||csr_rec.assignment_action_id,45);
537: hr_utility.set_location('Locked Data file Action ID '||csr_rec.datafile_action_id,50);
538: END IF;
539: END LOOP;
540: END IF;

Line 537: hr_utility.set_location('Locked Data file Action ID '||csr_rec.datafile_action_id,50);

533: THEN
534: hr_utility.set_location('Assignment_ID '||csr_rec.assignment_id,35);
535: hr_utility.set_location('New Ass Action ID '||v_next_action_id,40);
536: hr_utility.set_location('Locked Archive Action ID '||csr_rec.assignment_action_id,45);
537: hr_utility.set_location('Locked Data file Action ID '||csr_rec.datafile_action_id,50);
538: END IF;
539: END LOOP;
540: END IF;
541: END IF;

Line 545: hr_utility.set_location('error raised in assignment_action_code procedure ',5);

541: END IF;
542:
543: exception
544: when others then
545: hr_utility.set_location('error raised in assignment_action_code procedure ',5);
546: raise;
547: end assignment_action_code;
548:
549:

Line 650: hr_utility.set_location('Before payroll action' , 25);

646:
647: Begin
648: LOOP
649: l_count := l_count + 1;
650: hr_utility.set_location('Before payroll action' , 25);
651: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_names(l_count) , 105);
652: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_values(l_count) , 115);
653: l_passed_sort_order:=pay_mag_tape.internal_prm_names(l_count);
654: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID'

Line 651: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_names(l_count) , 105);

647: Begin
648: LOOP
649: l_count := l_count + 1;
650: hr_utility.set_location('Before payroll action' , 25);
651: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_names(l_count) , 105);
652: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_values(l_count) , 115);
653: l_passed_sort_order:=pay_mag_tape.internal_prm_names(l_count);
654: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID'
655: THEN

Line 652: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_values(l_count) , 115);

648: LOOP
649: l_count := l_count + 1;
650: hr_utility.set_location('Before payroll action' , 25);
651: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_names(l_count) , 105);
652: hr_utility.set_location('mag_internal ' || pay_mag_tape.internal_prm_values(l_count) , 115);
653: l_passed_sort_order:=pay_mag_tape.internal_prm_names(l_count);
654: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID'
655: THEN
656: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));

Line 657: hr_utility.set_location('payroll_action ',0);

653: l_passed_sort_order:=pay_mag_tape.internal_prm_names(l_count);
654: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID'
655: THEN
656: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));
657: hr_utility.set_location('payroll_action ',0);
658: ELSIF l_passed_sort_order= 'SORT_ORDER1'
659: THEN
660: l_sort_order1 := pay_mag_tape.internal_prm_values(l_count);
661: hr_utility.set_location('in sort order1 ',1);

Line 661: hr_utility.set_location('in sort order1 ',1);

657: hr_utility.set_location('payroll_action ',0);
658: ELSIF l_passed_sort_order= 'SORT_ORDER1'
659: THEN
660: l_sort_order1 := pay_mag_tape.internal_prm_values(l_count);
661: hr_utility.set_location('in sort order1 ',1);
662: ELSIF l_passed_sort_order= 'SORT_ORDER2'
663: THEN
664: l_sort_order2 := pay_mag_tape.internal_prm_values(l_count);
665: hr_utility.set_location('in sort_order 2 ',2);

Line 665: hr_utility.set_location('in sort_order 2 ',2);

661: hr_utility.set_location('in sort order1 ',1);
662: ELSIF l_passed_sort_order= 'SORT_ORDER2'
663: THEN
664: l_sort_order2 := pay_mag_tape.internal_prm_values(l_count);
665: hr_utility.set_location('in sort_order 2 ',2);
666: ELSIF l_passed_sort_order= 'SORT_ORDER3'
667: THEN
668: hr_utility.set_location('in sort_order3 ',3);
669: l_sort_order3 := pay_mag_tape.internal_prm_values(l_count);

Line 668: hr_utility.set_location('in sort_order3 ',3);

664: l_sort_order2 := pay_mag_tape.internal_prm_values(l_count);
665: hr_utility.set_location('in sort_order 2 ',2);
666: ELSIF l_passed_sort_order= 'SORT_ORDER3'
667: THEN
668: hr_utility.set_location('in sort_order3 ',3);
669: l_sort_order3 := pay_mag_tape.internal_prm_values(l_count);
670: ELSIF l_passed_sort_order= 'SORT_ORDER4'
671: THEN
672: l_sort_order4 := pay_mag_tape.internal_prm_values(l_count);

Line 673: hr_utility.set_location('in sort_orderr4 ',4);

669: l_sort_order3 := pay_mag_tape.internal_prm_values(l_count);
670: ELSIF l_passed_sort_order= 'SORT_ORDER4'
671: THEN
672: l_sort_order4 := pay_mag_tape.internal_prm_values(l_count);
673: hr_utility.set_location('in sort_orderr4 ',4);
674: /* Bug 3132172 Duplex Printing Support*/
675: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'DUPLEX_PRINT_FLAG'
676: THEN
677: l_duplex_print_flag := pay_mag_tape.internal_prm_values(l_count);

Line 678: hr_utility.set_location('in duplex_print_flag',5);

674: /* Bug 3132172 Duplex Printing Support*/
675: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'DUPLEX_PRINT_FLAG'
676: THEN
677: l_duplex_print_flag := pay_mag_tape.internal_prm_values(l_count);
678: hr_utility.set_location('in duplex_print_flag',5);
679: /* Bug 4859876 - Template Code for PDF Output */
680: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'TMPL'
681: THEN
682: l_template_name := pay_mag_tape.internal_prm_values(l_count);

Line 683: hr_utility.set_location('in Template Names'||l_template_name,6);

679: /* Bug 4859876 - Template Code for PDF Output */
680: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'TMPL'
681: THEN
682: l_template_name := pay_mag_tape.internal_prm_values(l_count);
683: hr_utility.set_location('in Template Names'||l_template_name,6);
684: END IF;
685:
686: END LOOP;
687: EXCEPTION

Line 698: hr_utility.set_location('getting sort_order1'||l_sort_order1, 121);

694: End;
695:
696:
697: l_sort_order1:=get_sort_order_value(l_sort_order1);
698: hr_utility.set_location('getting sort_order1'||l_sort_order1, 121);
699: l_sort_order2:=get_sort_order_value(l_sort_order2);
700: hr_utility.set_location('getting sort_order2'||l_sort_order2, 122);
701: l_sort_order3:=get_sort_order_value(l_sort_order3);
702: hr_utility.set_location('getting sort_order3'||l_sort_order3, 123);

Line 700: hr_utility.set_location('getting sort_order2'||l_sort_order2, 122);

696:
697: l_sort_order1:=get_sort_order_value(l_sort_order1);
698: hr_utility.set_location('getting sort_order1'||l_sort_order1, 121);
699: l_sort_order2:=get_sort_order_value(l_sort_order2);
700: hr_utility.set_location('getting sort_order2'||l_sort_order2, 122);
701: l_sort_order3:=get_sort_order_value(l_sort_order3);
702: hr_utility.set_location('getting sort_order3'||l_sort_order3, 123);
703: l_sort_order4:=get_sort_order_value(l_sort_order4);
704: hr_utility.set_location('getting sort_order4'||l_sort_order4, 124);

Line 702: hr_utility.set_location('getting sort_order3'||l_sort_order3, 123);

698: hr_utility.set_location('getting sort_order1'||l_sort_order1, 121);
699: l_sort_order2:=get_sort_order_value(l_sort_order2);
700: hr_utility.set_location('getting sort_order2'||l_sort_order2, 122);
701: l_sort_order3:=get_sort_order_value(l_sort_order3);
702: hr_utility.set_location('getting sort_order3'||l_sort_order3, 123);
703: l_sort_order4:=get_sort_order_value(l_sort_order4);
704: hr_utility.set_location('getting sort_order4'||l_sort_order4, 124);
705:
706:

Line 704: hr_utility.set_location('getting sort_order4'||l_sort_order4, 124);

700: hr_utility.set_location('getting sort_order2'||l_sort_order2, 122);
701: l_sort_order3:=get_sort_order_value(l_sort_order3);
702: hr_utility.set_location('getting sort_order3'||l_sort_order3, 123);
703: l_sort_order4:=get_sort_order_value(l_sort_order4);
704: hr_utility.set_location('getting sort_order4'||l_sort_order4, 124);
705:
706:
707:
708: hr_utility.set_location('getting current chunk_number ', 125);

Line 708: hr_utility.set_location('getting current chunk_number ', 125);

704: hr_utility.set_location('getting sort_order4'||l_sort_order4, 124);
705:
706:
707:
708: hr_utility.set_location('getting current chunk_number ', 125);
709:
710: OPEN csr_get_current_chunk_number(l_payroll_action_id);
711: fetch csr_get_current_chunk_number into l_current_chunk_number;
712: CLOSE csr_get_current_chunk_number;

Line 725: hr_utility.set_location('Afer payroll action ' || l_payroll_action_id , 125);

721:
722: if l_current_chunk_number <> 0 and l_assignment_exist > 0
723: then
724:
725: hr_utility.set_location('Afer payroll action ' || l_payroll_action_id , 125);
726: --hr_utility.set_location('sort ' || l_sort_order,166);
727: hr_utility.set_location('Before calling report',24);
728:
729: OPEN csr_get_print_options(l_payroll_action_id);

Line 726: --hr_utility.set_location('sort ' || l_sort_order,166);

722: if l_current_chunk_number <> 0 and l_assignment_exist > 0
723: then
724:
725: hr_utility.set_location('Afer payroll action ' || l_payroll_action_id , 125);
726: --hr_utility.set_location('sort ' || l_sort_order,166);
727: hr_utility.set_location('Before calling report',24);
728:
729: OPEN csr_get_print_options(l_payroll_action_id);
730: FETCH csr_get_print_options INTO rec_print_options;

Line 727: hr_utility.set_location('Before calling report',24);

723: then
724:
725: hr_utility.set_location('Afer payroll action ' || l_payroll_action_id , 125);
726: --hr_utility.set_location('sort ' || l_sort_order,166);
727: hr_utility.set_location('Before calling report',24);
728:
729: OPEN csr_get_print_options(l_payroll_action_id);
730: FETCH csr_get_print_options INTO rec_print_options;
731: CLOSE csr_get_print_options;

Line 743: hr_utility.set_location('payroll_action id '|| l_payroll_action_id,25);

739: copies => rec_print_options.number_of_copies, /* Bug: 3768288 */
740: save_output => hr_general.char_to_bool(rec_print_options.save_output),
741: print_together => l_print_together);
742: -- Submit report
743: hr_utility.set_location('payroll_action id '|| l_payroll_action_id,25);
744:
745: /* Bug 4891196 - Determine Report to be submitted,
746: i. If Template is Null, then Postscript output
747: ii. If Template is NOT Null, then XML/PDF output.

Line 789: hr_utility.set_location('After calling report',24);

785: NULL, NULL, NULL, NULL, NULL, NULL,
786: NULL, NULL, NULL, NULL, NULL
787: );
788:
789: hr_utility.set_location('After calling report',24);
790:
791:
792: end if;
793:

Line 794: hr_utility.set_location('Before calling formula',22);

790:
791:
792: end if;
793:
794: hr_utility.set_location('Before calling formula',22);
795:
796: OPEN csr_get_formula_id('AU_PS_REPORT');
797: FETCH csr_get_formula_id INTO l_formula_id;
798: CLOSE csr_get_formula_id;

Line 816: -- hr_utility.trace_off;

812: pay_mag_tape.internal_prm_names(7) := 'SORT_ORDER3';
813: pay_mag_tape.internal_prm_values(7) :=l_sort_order3;
814: pay_mag_tape.internal_prm_names(8) := 'SORT_ORDER4';
815: pay_mag_tape.internal_prm_values(8) :=l_sort_order4;
816: -- hr_utility.trace_off;
817: end spawn_archive_reports;
818:
819: ---
820: -- Bug 4726357 Added to check whether Self Service Option is enabled for the employee