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

Line 5: -- g_debug boolean := hr_utility.debug_enabled; --Bug3132178

1: package body pay_au_payment_summary_magtape as
2: /* $Header: pyaupsm.pkb 120.4.12010000.4 2009/12/16 14:17:37 dduvvuri ship $*/
3: -------------------------------------------------------------------------+
4:
5: -- g_debug boolean := hr_utility.debug_enabled; --Bug3132178
6: g_debug boolean := TRUE; --Bug3132178
7:
8:
9: procedure range_code

Line 13: -- hr_utility.trace_on(null, 'magtape');

9: procedure range_code
10: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
11: p_sql out NOCOPY varchar2) is
12: begin
13: -- hr_utility.trace_on(null, 'magtape');
14: hr_utility.set_location('Start of range_code',1);
15: /*Bug2920725 Corrected base tables to support security model*/
16:
17: p_sql := ' select distinct p.person_id' ||

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

10: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
11: p_sql out NOCOPY varchar2) is
12: begin
13: -- hr_utility.trace_on(null, 'magtape');
14: hr_utility.set_location('Start of range_code',1);
15: /*Bug2920725 Corrected base tables to support security model*/
16:
17: p_sql := ' select distinct p.person_id' ||
18: ' from per_people_f p,' ||

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

21: ' and p.business_group_id = pa.business_group_id' ||
22: ' order by p.person_id';
23:
24: IF g_debug THEN
25: hr_utility.set_location('End of range_code',2);
26: END IF;
27: end range_code;
28:
29: /*

Line 66: g_debug := hr_utility.debug_enabled;

62: l_report_param_val varchar2(30);
63:
64: BEGIN
65:
66: g_debug := hr_utility.debug_enabled;
67:
68: BEGIN
69:
70: open csr_action_parameter;

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

81: --
82: IF l_action_param_val = 'Y' AND l_report_param_val = 'Y' THEN
83: l_return := TRUE;
84: IF g_debug THEN
85: hr_utility.set_location('Range Person = True',1);
86: END IF;
87: ELSE
88: l_return := FALSE;
89: END IF;

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

462:
463: BEGIN
464:
465: IF g_debug THEN
466: hr_utility.set_location('Start of assignment_action_code',3);
467: END IF;
468: --------start of Bug3132178-----------------------------------------------------
469: OPEN get_parameters;
470: FETCH get_parameters INTO l_testing_flag,l_archive_payroll_action,l_payment_summary_type;

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

474: IF l_testing_flag = 'Y' THEN -- In this case fetch the assignments processed by archival process
475: IF l_payment_summary_type = 'O' THEN
476: IF range_person_on THEN /* 9113084 - Use new Range Person Cursor if Range Person is enabled */
477: IF g_debug THEN
478: hr_utility.set_location('Using Range Person Cursor for fetching assignments', 5);
479: END IF;
480: FOR process_rec IN rg_process_assignments_val (l_archive_payroll_action,
481: p_chunk)
482: LOOP

Line 493: hr_utility.set_location('After calling hr_nonrun_asact.insint',5);

489: p_payroll_action_id,
490: p_chunk,
491: NULL);
492: IF g_debug THEN
493: hr_utility.set_location('After calling hr_nonrun_asact.insint',5);
494: END IF;
495: END LOOP;
496: ELSE /* 9113084 - Use Old logic if Range Person is disabled */
497:

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

508: p_payroll_action_id,
509: p_chunk,
510: NULL);
511: IF g_debug THEN
512: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
513: END IF;
514: END LOOP;
515: END IF;
516: ELSE /* bug 6630375 */

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

515: END IF;
516: ELSE /* bug 6630375 */
517: IF range_person_on THEN
518: IF g_debug THEN
519: hr_utility.set_location('Using Range Person Cursor for fetching assignments', 5);
520: END IF;
521: FOR process_rec IN range_assignments_val_amend(l_archive_payroll_action,
522: p_chunk)
523: LOOP

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

530: p_payroll_action_id,
531: p_chunk,
532: NULL);
533: IF g_debug THEN
534: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
535: END IF;
536: END LOOP;
537: ELSE /* 9113084 - Use Old Logic when Range Person is disabled */
538:

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

549: p_payroll_action_id,
550: p_chunk,
551: NULL);
552: IF g_debug THEN
553: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
554: END IF;
555: END LOOP;
556: END IF;
557: END IF;

Line 583: hr_utility.set_location('Before calling hr_nonrun_asact.insint',14);

579: p_payroll_action_id,
580: p_chunk,
581: NULL);
582: IF g_debug THEN
583: hr_utility.set_location('Before calling hr_nonrun_asact.insint',14);
584: hr_utility.set_location('locking action' || v_next_action_id, 15);
585: hr_utility.set_location('locked action' || process_rec.ps_report_id, 16);
586: END IF;
587: hr_nonrun_asact.insint(v_next_action_id, -- locking action id

Line 584: hr_utility.set_location('locking action' || v_next_action_id, 15);

580: p_chunk,
581: NULL);
582: IF g_debug THEN
583: hr_utility.set_location('Before calling hr_nonrun_asact.insint',14);
584: hr_utility.set_location('locking action' || v_next_action_id, 15);
585: hr_utility.set_location('locked action' || process_rec.ps_report_id, 16);
586: END IF;
587: hr_nonrun_asact.insint(v_next_action_id, -- locking action id
588: process_rec.ps_report_id); -- locked action id

Line 585: hr_utility.set_location('locked action' || process_rec.ps_report_id, 16);

581: NULL);
582: IF g_debug THEN
583: hr_utility.set_location('Before calling hr_nonrun_asact.insint',14);
584: hr_utility.set_location('locking action' || v_next_action_id, 15);
585: hr_utility.set_location('locked action' || process_rec.ps_report_id, 16);
586: END IF;
587: hr_nonrun_asact.insint(v_next_action_id, -- locking action id
588: process_rec.ps_report_id); -- locked action id
589:

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

587: hr_nonrun_asact.insint(v_next_action_id, -- locking action id
588: process_rec.ps_report_id); -- locked action id
589:
590: IF g_debug THEN
591: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
592: END IF;
593: END LOOP;
594:
595: ELSE

Line 611: hr_utility.set_location('Before calling hr_nonrun_asact.insint',14);

607: p_payroll_action_id,
608: p_chunk,
609: NULL);
610: IF g_debug THEN
611: hr_utility.set_location('Before calling hr_nonrun_asact.insint',14);
612: hr_utility.set_location('locking action' || v_next_action_id, 15);
613: hr_utility.set_location('locked action' || process_rec.ps_report_id, 16);
614: END IF;
615: hr_nonrun_asact.insint(v_next_action_id, -- locking action id

Line 612: hr_utility.set_location('locking action' || v_next_action_id, 15);

608: p_chunk,
609: NULL);
610: IF g_debug THEN
611: hr_utility.set_location('Before calling hr_nonrun_asact.insint',14);
612: hr_utility.set_location('locking action' || v_next_action_id, 15);
613: hr_utility.set_location('locked action' || process_rec.ps_report_id, 16);
614: END IF;
615: hr_nonrun_asact.insint(v_next_action_id, -- locking action id
616: process_rec.ps_report_id); -- locked action id

Line 613: hr_utility.set_location('locked action' || process_rec.ps_report_id, 16);

609: NULL);
610: IF g_debug THEN
611: hr_utility.set_location('Before calling hr_nonrun_asact.insint',14);
612: hr_utility.set_location('locking action' || v_next_action_id, 15);
613: hr_utility.set_location('locked action' || process_rec.ps_report_id, 16);
614: END IF;
615: hr_nonrun_asact.insint(v_next_action_id, -- locking action id
616: process_rec.ps_report_id); -- locked action id
617:

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

615: hr_nonrun_asact.insint(v_next_action_id, -- locking action id
616: process_rec.ps_report_id); -- locked action id
617:
618: IF g_debug THEN
619: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
620: END IF;
621: END LOOP;
622: END IF;
623: ELSE /* bug 6630375 */

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

622: END IF;
623: ELSE /* bug 6630375 */
624: IF range_person_on THEN /* 9113084 - Use new Range Person Cursor if Range Person is enabled */
625: IF g_debug THEN
626: hr_utility.set_location('Using Range Person Cursor for fetching assignments', 5);
627: END IF;
628: FOR process_rec IN rg_process_assignments_amend (p_payroll_action_id,
629: p_chunk)
630: LOOP

Line 641: hr_utility.set_location('Before calling hr_nonrun_asact.insint',14);

637: p_payroll_action_id,
638: p_chunk,
639: NULL);
640: IF g_debug THEN
641: hr_utility.set_location('Before calling hr_nonrun_asact.insint',14);
642: hr_utility.set_location('locking action' || v_next_action_id, 15);
643: hr_utility.set_location('locked action' || process_rec.ps_report_id, 16);
644: END IF;
645: hr_nonrun_asact.insint(v_next_action_id, -- locking action id

Line 642: hr_utility.set_location('locking action' || v_next_action_id, 15);

638: p_chunk,
639: NULL);
640: IF g_debug THEN
641: hr_utility.set_location('Before calling hr_nonrun_asact.insint',14);
642: hr_utility.set_location('locking action' || v_next_action_id, 15);
643: hr_utility.set_location('locked action' || process_rec.ps_report_id, 16);
644: END IF;
645: hr_nonrun_asact.insint(v_next_action_id, -- locking action id
646: process_rec.ps_report_id); -- locked action id

Line 643: hr_utility.set_location('locked action' || process_rec.ps_report_id, 16);

639: NULL);
640: IF g_debug THEN
641: hr_utility.set_location('Before calling hr_nonrun_asact.insint',14);
642: hr_utility.set_location('locking action' || v_next_action_id, 15);
643: hr_utility.set_location('locked action' || process_rec.ps_report_id, 16);
644: END IF;
645: hr_nonrun_asact.insint(v_next_action_id, -- locking action id
646: process_rec.ps_report_id); -- locked action id
647:

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

645: hr_nonrun_asact.insint(v_next_action_id, -- locking action id
646: process_rec.ps_report_id); -- locked action id
647:
648: IF g_debug THEN
649: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
650: END IF;
651: END LOOP;
652: ELSE /* 9113084 - Use Old Logic if Range Person is disabled */
653:

Line 668: hr_utility.set_location('Before calling hr_nonrun_asact.insint',14);

664: p_payroll_action_id,
665: p_chunk,
666: NULL);
667: IF g_debug THEN
668: hr_utility.set_location('Before calling hr_nonrun_asact.insint',14);
669: hr_utility.set_location('locking action' || v_next_action_id, 15);
670: hr_utility.set_location('locked action' || process_rec.ps_report_id, 16);
671: END IF;
672: hr_nonrun_asact.insint(v_next_action_id, -- locking action id

Line 669: hr_utility.set_location('locking action' || v_next_action_id, 15);

665: p_chunk,
666: NULL);
667: IF g_debug THEN
668: hr_utility.set_location('Before calling hr_nonrun_asact.insint',14);
669: hr_utility.set_location('locking action' || v_next_action_id, 15);
670: hr_utility.set_location('locked action' || process_rec.ps_report_id, 16);
671: END IF;
672: hr_nonrun_asact.insint(v_next_action_id, -- locking action id
673: process_rec.ps_report_id); -- locked action id

Line 670: hr_utility.set_location('locked action' || process_rec.ps_report_id, 16);

666: NULL);
667: IF g_debug THEN
668: hr_utility.set_location('Before calling hr_nonrun_asact.insint',14);
669: hr_utility.set_location('locking action' || v_next_action_id, 15);
670: hr_utility.set_location('locked action' || process_rec.ps_report_id, 16);
671: END IF;
672: hr_nonrun_asact.insint(v_next_action_id, -- locking action id
673: process_rec.ps_report_id); -- locked action id
674:

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

672: hr_nonrun_asact.insint(v_next_action_id, -- locking action id
673: process_rec.ps_report_id); -- locked action id
674:
675: IF g_debug THEN
676: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
677: END IF;
678: END LOOP;
679: END IF;
680: END IF;

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

679: END IF;
680: END IF;
681: END IF;
682: IF g_debug THEN
683: hr_utility.set_location('End of assignment_action_code',5);
684: END IF;
685: END assignment_action_code;
686:
687: -----------------------------------------------------------------------+

Line 699: hr_utility.set_location('Start of initialization_code',6);

695: procedure initialization_code
696: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
697: begin
698: IF g_debug THEN
699: hr_utility.set_location('Start of initialization_code',6);
700: END IF;
701: null;
702: IF g_debug THEN
703: hr_utility.set_location('End of initialization_code',7);

Line 703: hr_utility.set_location('End of initialization_code',7);

699: hr_utility.set_location('Start of initialization_code',6);
700: END IF;
701: null;
702: IF g_debug THEN
703: hr_utility.set_location('End of initialization_code',7);
704: END IF;
705: end initialization_code;
706:
707:

Line 719: hr_utility.set_location('Start of archive_code',8);

715: is
716:
717: begin
718: IF g_debug THEN
719: hr_utility.set_location('Start of archive_code',8);
720: END IF;
721: null;
722: IF g_debug THEN
723: hr_utility.set_location('End of archive_code',9);

Line 723: hr_utility.set_location('End of archive_code',9);

719: hr_utility.set_location('Start of archive_code',8);
720: END IF;
721: null;
722: IF g_debug THEN
723: hr_utility.set_location('End of archive_code',9);
724: END IF;
725: end archive_code;
726: ---------------------------------------------------------------------------+
727: