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

Line 41: --hr_utility.trace_on('Y','ORACLE');

37: l_uid_tax_unit_id ff_user_entities.user_entity_id%TYPE;
38: l_uid_person_id ff_user_entities.user_entity_id%TYPE;
39: --
40: begin
41: --hr_utility.trace_on('Y','ORACLE');
42: hr_utility.trace('begining of range_cursor 1 ');
43:
44: select
45: legislative_parameters

Line 42: hr_utility.trace('begining of range_cursor 1 ');

38: l_uid_person_id ff_user_entities.user_entity_id%TYPE;
39: --
40: begin
41: --hr_utility.trace_on('Y','ORACLE');
42: hr_utility.trace('begining of range_cursor 1 ');
43:
44: select
45: legislative_parameters
46: into

Line 77: hr_utility.trace('End of range_cursor 2 ');

73: ' and fai3.value =
74: nvl(pay_ca_t4a_reg.get_parameter(''PER_ID'',ppa.legislative_parameters),fai3.value)
75: order by to_number(fai3.value)';
76:
77: hr_utility.trace('End of range_cursor 2 ');
78:
79: end range_cursor;
80: ------------------------- action_creation ----------------------------------
81:

Line 476: hr_utility.trace('begining of action creation 1 '||to_char(pactid));

472:
473:
474: begin
475:
476: hr_utility.trace('begining of action creation 1 '||to_char(pactid));
477:
478: /* get report type and effective date */
479:
480: select

Line 503: hr_utility.trace('begining of action creation 2 '||

499: pay_payroll_actions
500: where
501: payroll_action_id = pactid;
502:
503: hr_utility.trace('begining of action creation 2 '||
504: to_char(l_bus_group_id));
505:
506: hr_utility.trace('legislative parameters is '||l_legislative_parameters);
507: hr_utility.trace('Start Person ID = '||to_char(stperson));

Line 506: hr_utility.trace('legislative parameters is '||l_legislative_parameters);

502:
503: hr_utility.trace('begining of action creation 2 '||
504: to_char(l_bus_group_id));
505:
506: hr_utility.trace('legislative parameters is '||l_legislative_parameters);
507: hr_utility.trace('Start Person ID = '||to_char(stperson));
508: hr_utility.trace('End Person ID = '||to_char(endperson));
509: hr_utility.trace('Chunk # = '||to_char(chunk));
510:

Line 507: hr_utility.trace('Start Person ID = '||to_char(stperson));

503: hr_utility.trace('begining of action creation 2 '||
504: to_char(l_bus_group_id));
505:
506: hr_utility.trace('legislative parameters is '||l_legislative_parameters);
507: hr_utility.trace('Start Person ID = '||to_char(stperson));
508: hr_utility.trace('End Person ID = '||to_char(endperson));
509: hr_utility.trace('Chunk # = '||to_char(chunk));
510:
511: l_year := pay_ca_t4a_reg.get_parameter('TAX_YEAR',l_legislative_parameters);

Line 508: hr_utility.trace('End Person ID = '||to_char(endperson));

504: to_char(l_bus_group_id));
505:
506: hr_utility.trace('legislative parameters is '||l_legislative_parameters);
507: hr_utility.trace('Start Person ID = '||to_char(stperson));
508: hr_utility.trace('End Person ID = '||to_char(endperson));
509: hr_utility.trace('Chunk # = '||to_char(chunk));
510:
511: l_year := pay_ca_t4a_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
512: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');

Line 509: hr_utility.trace('Chunk # = '||to_char(chunk));

505:
506: hr_utility.trace('legislative parameters is '||l_legislative_parameters);
507: hr_utility.trace('Start Person ID = '||to_char(stperson));
508: hr_utility.trace('End Person ID = '||to_char(endperson));
509: hr_utility.trace('Chunk # = '||to_char(chunk));
510:
511: l_year := pay_ca_t4a_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
512: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
513: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;

Line 519: hr_utility.trace('begining of action creation 3 '||

515: l_legislative_parameters);
516: lv_per_id := pay_ca_t4a_reg.get_parameter('PER_ID',l_legislative_parameters);
517: l_print_term := pay_ca_t4_reg.get_parameter('PRINT_TERM',l_legislative_parameters);
518:
519: hr_utility.trace('begining of action creation 3 '||
520: l_year||to_char(l_year_start)||to_char(l_year_end));
521:
522: l_t4areg_tax_unit_id := to_number(pay_ca_t4a_reg.get_parameter('GRE_ID',
523: l_legislative_parameters));

Line 527: hr_utility.trace('begining of action creation 4 '

523: l_legislative_parameters));
524: l_uid_caeoy_tax_year := get_user_entity_id('CAEOY_TAXATION_YEAR');
525: l_uid_caeoy_tax_unit_id := get_user_entity_id('CAEOY_TAX_UNIT_ID');
526:
527: hr_utility.trace('begining of action creation 4 '
528: ||to_char(l_t4areg_tax_unit_id));
529:
530: -- Code modification for bug 10399514 starts here
531: /* Initializing variable */

Line 556: hr_utility.trace(' Tax Unit ID is passed = '|| to_char(l_t4areg_tax_unit_id));

552:
553:
554: if l_t4areg_tax_unit_id is not null then
555:
556: hr_utility.trace(' Tax Unit ID is passed = '|| to_char(l_t4areg_tax_unit_id));
557:
558: open cur_gre;
559:
560: fetch cur_gre

Line 573: hr_utility.trace('opening c_all_asg_in_asgset_range_term CURSOR');

569: if l_asg_set_id is not null then
570: if l_person_on then -- Added if for bug 10399514
571: if nvl(l_print_term,'N') = 'Y' then
572: open c_all_asg_in_asgset_range_term(l_arch_pactid);
573: hr_utility.trace('opening c_all_asg_in_asgset_range_term CURSOR');
574: else
575: open c_all_asg_in_asgset_range(l_arch_pactid);
576: hr_utility.trace('opening c_all_asg_in_asgset_range CURSOR');
577: end if;

Line 576: hr_utility.trace('opening c_all_asg_in_asgset_range CURSOR');

572: open c_all_asg_in_asgset_range_term(l_arch_pactid);
573: hr_utility.trace('opening c_all_asg_in_asgset_range_term CURSOR');
574: else
575: open c_all_asg_in_asgset_range(l_arch_pactid);
576: hr_utility.trace('opening c_all_asg_in_asgset_range CURSOR');
577: end if;
578: else
579: if nvl(l_print_term,'N') = 'Y' then
580: open c_all_asg_in_asgset_term(l_arch_pactid);

Line 581: hr_utility.trace('opening c_all_asg_in_asgset_term CURSOR');

577: end if;
578: else
579: if nvl(l_print_term,'N') = 'Y' then
580: open c_all_asg_in_asgset_term(l_arch_pactid);
581: hr_utility.trace('opening c_all_asg_in_asgset_term CURSOR');
582: else
583: open c_all_asg_in_asgset(l_arch_pactid);
584: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');
585: end if;

Line 584: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');

580: open c_all_asg_in_asgset_term(l_arch_pactid);
581: hr_utility.trace('opening c_all_asg_in_asgset_term CURSOR');
582: else
583: open c_all_asg_in_asgset(l_arch_pactid);
584: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');
585: end if;
586: end if;
587: elsif lv_per_id is not null then
588: if nvl(l_print_term,'N') = 'Y' then

Line 590: hr_utility.trace('opening c_single_asg_term CURSOR');

586: end if;
587: elsif lv_per_id is not null then
588: if nvl(l_print_term,'N') = 'Y' then
589: open c_single_asg_term(l_arch_pactid, lv_per_id);
590: hr_utility.trace('opening c_single_asg_term CURSOR');
591: else
592: open c_single_asg(l_arch_pactid, lv_per_id);
593: hr_utility.trace('opening c_single_asg CURSOR');
594: end if;

Line 593: hr_utility.trace('opening c_single_asg CURSOR');

589: open c_single_asg_term(l_arch_pactid, lv_per_id);
590: hr_utility.trace('opening c_single_asg_term CURSOR');
591: else
592: open c_single_asg(l_arch_pactid, lv_per_id);
593: hr_utility.trace('opening c_single_asg CURSOR');
594: end if;
595: else
596: if l_person_on then -- Added if for bug 10399514
597: if nvl(l_print_term,'N') = 'Y' then

Line 599: hr_utility.trace('opening c_all_asg_range_term CURSOR');

595: else
596: if l_person_on then -- Added if for bug 10399514
597: if nvl(l_print_term,'N') = 'Y' then
598: open c_all_asg_range_term(l_arch_pactid);
599: hr_utility.trace('opening c_all_asg_range_term CURSOR');
600: else
601: open c_all_asg_range(l_arch_pactid);
602: hr_utility.trace('opening c_all_asg_range CURSOR');
603: end if;

Line 602: hr_utility.trace('opening c_all_asg_range CURSOR');

598: open c_all_asg_range_term(l_arch_pactid);
599: hr_utility.trace('opening c_all_asg_range_term CURSOR');
600: else
601: open c_all_asg_range(l_arch_pactid);
602: hr_utility.trace('opening c_all_asg_range CURSOR');
603: end if;
604: else
605: if nvl(l_print_term,'N') = 'Y' then
606: open c_all_asg_term(l_arch_pactid);

Line 607: hr_utility.trace('opening c_all_asg_term CURSOR');

603: end if;
604: else
605: if nvl(l_print_term,'N') = 'Y' then
606: open c_all_asg_term(l_arch_pactid);
607: hr_utility.trace('opening c_all_asg_term CURSOR');
608: else
609: open c_all_asg(l_arch_pactid);
610: hr_utility.trace('opening c_all_asg CURSOR');
611: end if;

Line 610: hr_utility.trace('opening c_all_asg CURSOR');

606: open c_all_asg_term(l_arch_pactid);
607: hr_utility.trace('opening c_all_asg_term CURSOR');
608: else
609: open c_all_asg(l_arch_pactid);
610: hr_utility.trace('opening c_all_asg CURSOR');
611: end if;
612: end if;
613: end if;
614:

Line 617: hr_utility.trace('l_t4areg_tax_unit_id is = ' ||

613: end if;
614:
615: loop
616:
617: hr_utility.trace('l_t4areg_tax_unit_id is = ' ||
618: to_char(l_t4areg_tax_unit_id));
619:
620: l_tax_unit_id := l_t4areg_tax_unit_id;
621:

Line 623: hr_utility.trace('begining of if condition 5 '||to_char(l_tax_unit_id));

619:
620: l_tax_unit_id := l_t4areg_tax_unit_id;
621:
622:
623: hr_utility.trace('begining of if condition 5 '||to_char(l_tax_unit_id));
624:
625: /* Added this validation to fix bug#2135545 */
626: if l_asg_set_id is not null then
627: if l_person_on then -- Added if for bug 10399514

Line 633: hr_utility.trace('fetching from c_all_asg_in_asgset_range_term CURSOR');

629: fetch c_all_asg_in_asgset_range_term into l_asg_id,
630: ln_arch_asgact_id,
631: ln_arch_pact_id,
632: l_effective_end_date;
633: hr_utility.trace('fetching from c_all_asg_in_asgset_range_term CURSOR');
634: exit when c_all_asg_in_asgset_range_term%notfound;
635: else
636: fetch c_all_asg_in_asgset_range into l_asg_id,
637: ln_arch_asgact_id,

Line 640: hr_utility.trace('fetching from c_all_asg_in_asgset_range CURSOR');

636: fetch c_all_asg_in_asgset_range into l_asg_id,
637: ln_arch_asgact_id,
638: ln_arch_pact_id,
639: l_effective_end_date;
640: hr_utility.trace('fetching from c_all_asg_in_asgset_range CURSOR');
641: exit when c_all_asg_in_asgset_range%notfound;
642: end if;
643: else
644: if nvl(l_print_term,'N') = 'Y' then

Line 649: hr_utility.trace('fetching from c_all_asg_in_asgset_term CURSOR');

645: fetch c_all_asg_in_asgset_term into l_asg_id,
646: ln_arch_asgact_id,
647: ln_arch_pact_id,
648: l_effective_end_date;
649: hr_utility.trace('fetching from c_all_asg_in_asgset_term CURSOR');
650: exit when c_all_asg_in_asgset_term%notfound;
651: else
652: fetch c_all_asg_in_asgset into l_asg_id,
653: ln_arch_asgact_id,

Line 656: hr_utility.trace('fetching from c_all_asg_in_asgset CURSOR');

652: fetch c_all_asg_in_asgset into l_asg_id,
653: ln_arch_asgact_id,
654: ln_arch_pact_id,
655: l_effective_end_date;
656: hr_utility.trace('fetching from c_all_asg_in_asgset CURSOR');
657: exit when c_all_asg_in_asgset%notfound;
658: end if;
659: end if;
660: elsif lv_per_id is not null then

Line 666: hr_utility.trace('fetching from c_single_asg_term CURSOR');

662: fetch c_single_asg_term into l_asg_id,
663: ln_arch_asgact_id,
664: ln_arch_pact_id,
665: l_effective_end_date;
666: hr_utility.trace('fetching from c_single_asg_term CURSOR');
667: exit when c_single_asg_term%notfound;
668: else
669: fetch c_single_asg into l_asg_id,
670: ln_arch_asgact_id,

Line 673: hr_utility.trace('fetching from c_single_asg CURSOR');

669: fetch c_single_asg into l_asg_id,
670: ln_arch_asgact_id,
671: ln_arch_pact_id,
672: l_effective_end_date;
673: hr_utility.trace('fetching from c_single_asg CURSOR');
674: exit when c_single_asg%notfound;
675: end if;
676: else
677: if l_person_on then -- Added if for bug 10399514

Line 683: hr_utility.trace('fetching from c_all_asg_range_term CURSOR');

679: fetch c_all_asg_range_term into l_asg_id,
680: ln_arch_asgact_id,
681: ln_arch_pact_id,
682: l_effective_end_date;
683: hr_utility.trace('fetching from c_all_asg_range_term CURSOR');
684: exit when c_all_asg_range_term%notfound;
685: else
686: fetch c_all_asg_range into l_asg_id,
687: ln_arch_asgact_id,

Line 690: hr_utility.trace('fetching from c_all_asg_range CURSOR');

686: fetch c_all_asg_range into l_asg_id,
687: ln_arch_asgact_id,
688: ln_arch_pact_id,
689: l_effective_end_date;
690: hr_utility.trace('fetching from c_all_asg_range CURSOR');
691: exit when c_all_asg_range%notfound;
692: end if;
693: else
694: if nvl(l_print_term,'N') = 'Y' then

Line 699: hr_utility.trace('fetching from c_all_asg_term CURSOR');

695: fetch c_all_asg_term into l_asg_id,
696: ln_arch_asgact_id,
697: ln_arch_pact_id,
698: l_effective_end_date;
699: hr_utility.trace('fetching from c_all_asg_term CURSOR');
700: exit when c_all_asg_term%notfound;
701: else
702: fetch c_all_asg into l_asg_id,
703: ln_arch_asgact_id,

Line 706: hr_utility.trace('fetching from c_all_asg CURSOR');

702: fetch c_all_asg into l_asg_id,
703: ln_arch_asgact_id,
704: ln_arch_pact_id,
705: l_effective_end_date;
706: hr_utility.trace('fetching from c_all_asg CURSOR');
707: exit when c_all_asg%notfound;
708: end if;
709: end if;
710: end if;

Line 712: hr_utility.trace('Begining of if part loop for c_all_asg 10 '||

708: end if;
709: end if;
710: end if;
711:
712: hr_utility.trace('Begining of if part loop for c_all_asg 10 '||
713: to_char(l_asg_id));
714:
715:
716: if (l_report_type = 'PAYCAT4APDF' and nvl(pay_us_employee_payslip_web.get_doc_eit('T4APDF',

Line 731: hr_utility.trace('in if loop after calling hr_nonrun_asact.insact pkg 11 '||to_char(l_asg_id));

727: pactid,
728: chunk,
729: l_tax_unit_id);
730:
731: hr_utility.trace('in if loop after calling hr_nonrun_asact.insact pkg 11 '||to_char(l_asg_id));
732:
733: /* Added this to implement T4A Register and T4A Amendment Register
734: using the same report file */
735:

Line 745: hr_utility.trace('lv_serial_number :' ||lv_serial_number);

741: lv_serial_number := lv_serial_number ||trim(pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id ,
742: 'CAEOY_T4A_NEGATIVE_BALANCE_EXISTS'));
743: end if;
744:
745: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
746:
747: update pay_assignment_actions paa
748: set paa.serial_number = lv_serial_number
749: where paa.assignment_action_id = lockingactid;

Line 759: hr_utility.trace('closing c_all_asg_in_asgset_range_term CURSOR');

755: if l_asg_set_id is not null then
756: if l_person_on then -- Added if for bug 10399514
757: if nvl(l_print_term,'N') = 'Y' then
758: close c_all_asg_in_asgset_range_term;
759: hr_utility.trace('closing c_all_asg_in_asgset_range_term CURSOR');
760: else
761: close c_all_asg_in_asgset_range;
762: hr_utility.trace('closing c_all_asg_in_asgset_range CURSOR');
763: end if;

Line 762: hr_utility.trace('closing c_all_asg_in_asgset_range CURSOR');

758: close c_all_asg_in_asgset_range_term;
759: hr_utility.trace('closing c_all_asg_in_asgset_range_term CURSOR');
760: else
761: close c_all_asg_in_asgset_range;
762: hr_utility.trace('closing c_all_asg_in_asgset_range CURSOR');
763: end if;
764: else
765: if nvl(l_print_term,'N') = 'Y' then
766: close c_all_asg_in_asgset_term;

Line 767: hr_utility.trace('closing c_all_asg_in_asgset_term CURSOR');

763: end if;
764: else
765: if nvl(l_print_term,'N') = 'Y' then
766: close c_all_asg_in_asgset_term;
767: hr_utility.trace('closing c_all_asg_in_asgset_term CURSOR');
768: else
769: close c_all_asg_in_asgset;
770: hr_utility.trace('closing c_all_asg_in_asgset CURSOR');
771: end if;

Line 770: hr_utility.trace('closing c_all_asg_in_asgset CURSOR');

766: close c_all_asg_in_asgset_term;
767: hr_utility.trace('closing c_all_asg_in_asgset_term CURSOR');
768: else
769: close c_all_asg_in_asgset;
770: hr_utility.trace('closing c_all_asg_in_asgset CURSOR');
771: end if;
772: end if;
773: elsif lv_per_id is not null then
774: if nvl(l_print_term,'N') = 'Y' then

Line 776: hr_utility.trace('closing c_single_asg_term CURSOR');

772: end if;
773: elsif lv_per_id is not null then
774: if nvl(l_print_term,'N') = 'Y' then
775: close c_single_asg_term;
776: hr_utility.trace('closing c_single_asg_term CURSOR');
777: else
778: close c_single_asg;
779: hr_utility.trace('closing c_single_asg CURSOR');
780: end if;

Line 779: hr_utility.trace('closing c_single_asg CURSOR');

775: close c_single_asg_term;
776: hr_utility.trace('closing c_single_asg_term CURSOR');
777: else
778: close c_single_asg;
779: hr_utility.trace('closing c_single_asg CURSOR');
780: end if;
781: else
782: if l_person_on then -- Added if for bug 10399514
783: if nvl(l_print_term,'N') = 'Y' then

Line 785: hr_utility.trace('closing c_all_asg_range_term CURSOR');

781: else
782: if l_person_on then -- Added if for bug 10399514
783: if nvl(l_print_term,'N') = 'Y' then
784: close c_all_asg_range_term;
785: hr_utility.trace('closing c_all_asg_range_term CURSOR');
786: else
787: close c_all_asg_range;
788: hr_utility.trace('closing c_all_asg_range CURSOR');
789: end if;

Line 788: hr_utility.trace('closing c_all_asg_range CURSOR');

784: close c_all_asg_range_term;
785: hr_utility.trace('closing c_all_asg_range_term CURSOR');
786: else
787: close c_all_asg_range;
788: hr_utility.trace('closing c_all_asg_range CURSOR');
789: end if;
790: else
791: if nvl(l_print_term,'N') = 'Y' then
792: close c_all_asg_term;

Line 793: hr_utility.trace('closing c_all_asg_term CURSOR');

789: end if;
790: else
791: if nvl(l_print_term,'N') = 'Y' then
792: close c_all_asg_term;
793: hr_utility.trace('closing c_all_asg_term CURSOR');
794: else
795: close c_all_asg;
796: hr_utility.trace('closing c_all_asg CURSOR');
797: end if;

Line 796: hr_utility.trace('closing c_all_asg CURSOR');

792: close c_all_asg_term;
793: hr_utility.trace('closing c_all_asg_term CURSOR');
794: else
795: close c_all_asg;
796: hr_utility.trace('closing c_all_asg CURSOR');
797: end if;
798: end if;
799: end if;
800:

Line 801: hr_utility.trace('End of cursor c_all_asg 12');

797: end if;
798: end if;
799: end if;
800:
801: hr_utility.trace('End of cursor c_all_asg 12');
802:
803: else
804:
805: hr_utility.trace('All the GREs will be processed !!!');

Line 805: hr_utility.trace('All the GREs will be processed !!!');

801: hr_utility.trace('End of cursor c_all_asg 12');
802:
803: else
804:
805: hr_utility.trace('All the GREs will be processed !!!');
806:
807: open c_all_gres;
808: loop
809:

Line 818: hr_utility.trace('l_tax_unit_id = ' || to_char(l_tax_unit_id));

814: l_session_date;
815:
816: exit when c_all_gres%notfound;
817:
818: hr_utility.trace('l_tax_unit_id = ' || to_char(l_tax_unit_id));
819: hr_utility.trace('l_arch_pactid = ' || to_char(l_arch_pactid));
820:
821: if l_asg_set_id is not null then
822: if l_person_on then -- Added if for bug 10399514

Line 819: hr_utility.trace('l_arch_pactid = ' || to_char(l_arch_pactid));

815:
816: exit when c_all_gres%notfound;
817:
818: hr_utility.trace('l_tax_unit_id = ' || to_char(l_tax_unit_id));
819: hr_utility.trace('l_arch_pactid = ' || to_char(l_arch_pactid));
820:
821: if l_asg_set_id is not null then
822: if l_person_on then -- Added if for bug 10399514
823: if nvl(l_print_term,'N') = 'Y' then

Line 825: hr_utility.trace('opening c_all_asg_in_asgset_range_term CURSOR');

821: if l_asg_set_id is not null then
822: if l_person_on then -- Added if for bug 10399514
823: if nvl(l_print_term,'N') = 'Y' then
824: open c_all_asg_in_asgset_range_term(l_arch_pactid);
825: hr_utility.trace('opening c_all_asg_in_asgset_range_term CURSOR');
826: else
827: open c_all_asg_in_asgset_range(l_arch_pactid);
828: hr_utility.trace('opening c_all_asg_in_asgset_range CURSOR');
829: end if;

Line 828: hr_utility.trace('opening c_all_asg_in_asgset_range CURSOR');

824: open c_all_asg_in_asgset_range_term(l_arch_pactid);
825: hr_utility.trace('opening c_all_asg_in_asgset_range_term CURSOR');
826: else
827: open c_all_asg_in_asgset_range(l_arch_pactid);
828: hr_utility.trace('opening c_all_asg_in_asgset_range CURSOR');
829: end if;
830: else
831: if nvl(l_print_term,'N') = 'Y' then
832: open c_all_asg_in_asgset_term(l_arch_pactid);

Line 833: hr_utility.trace('opening c_all_asg_in_asgset_term CURSOR');

829: end if;
830: else
831: if nvl(l_print_term,'N') = 'Y' then
832: open c_all_asg_in_asgset_term(l_arch_pactid);
833: hr_utility.trace('opening c_all_asg_in_asgset_term CURSOR');
834: else
835: open c_all_asg_in_asgset(l_arch_pactid);
836: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');
837: end if;

Line 836: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');

832: open c_all_asg_in_asgset_term(l_arch_pactid);
833: hr_utility.trace('opening c_all_asg_in_asgset_term CURSOR');
834: else
835: open c_all_asg_in_asgset(l_arch_pactid);
836: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');
837: end if;
838: end if;
839: elsif lv_per_id is not null then
840: if nvl(l_print_term,'N') = 'Y' then

Line 842: hr_utility.trace('opening c_single_asg_term CURSOR');

838: end if;
839: elsif lv_per_id is not null then
840: if nvl(l_print_term,'N') = 'Y' then
841: open c_single_asg_term(l_arch_pactid, lv_per_id);
842: hr_utility.trace('opening c_single_asg_term CURSOR');
843: else
844: open c_single_asg(l_arch_pactid, lv_per_id);
845: hr_utility.trace('opening c_single_asg CURSOR');
846: end if;

Line 845: hr_utility.trace('opening c_single_asg CURSOR');

841: open c_single_asg_term(l_arch_pactid, lv_per_id);
842: hr_utility.trace('opening c_single_asg_term CURSOR');
843: else
844: open c_single_asg(l_arch_pactid, lv_per_id);
845: hr_utility.trace('opening c_single_asg CURSOR');
846: end if;
847: else
848: if l_person_on then -- Added if for bug 10399514
849: if nvl(l_print_term,'N') = 'Y' then

Line 851: hr_utility.trace('opening c_all_asg_range_term CURSOR');

847: else
848: if l_person_on then -- Added if for bug 10399514
849: if nvl(l_print_term,'N') = 'Y' then
850: open c_all_asg_range_term(l_arch_pactid);
851: hr_utility.trace('opening c_all_asg_range_term CURSOR');
852: else
853: open c_all_asg_range(l_arch_pactid);
854: hr_utility.trace('opening c_all_asg_range CURSOR');
855: end if;

Line 854: hr_utility.trace('opening c_all_asg_range CURSOR');

850: open c_all_asg_range_term(l_arch_pactid);
851: hr_utility.trace('opening c_all_asg_range_term CURSOR');
852: else
853: open c_all_asg_range(l_arch_pactid);
854: hr_utility.trace('opening c_all_asg_range CURSOR');
855: end if;
856: else
857: if nvl(l_print_term,'N') = 'Y' then
858: open c_all_asg_term(l_arch_pactid);

Line 859: hr_utility.trace('opening c_all_asg_term CURSOR');

855: end if;
856: else
857: if nvl(l_print_term,'N') = 'Y' then
858: open c_all_asg_term(l_arch_pactid);
859: hr_utility.trace('opening c_all_asg_term CURSOR');
860: else
861: open c_all_asg(l_arch_pactid);
862: hr_utility.trace('opening c_all_asg CURSOR');
863: end if;

Line 862: hr_utility.trace('opening c_all_asg CURSOR');

858: open c_all_asg_term(l_arch_pactid);
859: hr_utility.trace('opening c_all_asg_term CURSOR');
860: else
861: open c_all_asg(l_arch_pactid);
862: hr_utility.trace('opening c_all_asg CURSOR');
863: end if;
864: end if;
865: end if;
866:

Line 877: hr_utility.trace('fetching from c_all_asg_in_asgset_range_term CURSOR');

873: fetch c_all_asg_in_asgset_range_term into l_asg_id,
874: ln_arch_asgact_id,
875: ln_arch_pact_id,
876: l_effective_end_date;
877: hr_utility.trace('fetching from c_all_asg_in_asgset_range_term CURSOR');
878: exit when c_all_asg_in_asgset_range_term%notfound;
879: else
880: fetch c_all_asg_in_asgset_range into l_asg_id,
881: ln_arch_asgact_id,

Line 884: hr_utility.trace('fetching from c_all_asg_in_asgset_range CURSOR');

880: fetch c_all_asg_in_asgset_range into l_asg_id,
881: ln_arch_asgact_id,
882: ln_arch_pact_id,
883: l_effective_end_date;
884: hr_utility.trace('fetching from c_all_asg_in_asgset_range CURSOR');
885: exit when c_all_asg_in_asgset_range%notfound;
886: end if;
887: else
888: if nvl(l_print_term,'N') = 'Y' then

Line 893: hr_utility.trace('fetching from c_all_asg_in_asgset_term CURSOR');

889: fetch c_all_asg_in_asgset_term into l_asg_id,
890: ln_arch_asgact_id,
891: ln_arch_pact_id,
892: l_effective_end_date;
893: hr_utility.trace('fetching from c_all_asg_in_asgset_term CURSOR');
894: exit when c_all_asg_in_asgset_term%notfound;
895: else
896: fetch c_all_asg_in_asgset into l_asg_id,
897: ln_arch_asgact_id,

Line 900: hr_utility.trace('fetching from c_all_asg_in_asgset CURSOR');

896: fetch c_all_asg_in_asgset into l_asg_id,
897: ln_arch_asgact_id,
898: ln_arch_pact_id,
899: l_effective_end_date;
900: hr_utility.trace('fetching from c_all_asg_in_asgset CURSOR');
901: exit when c_all_asg_in_asgset%notfound;
902: end if;
903: end if;
904: elsif lv_per_id is not null then

Line 910: hr_utility.trace('fetching from c_single_asg_term CURSOR');

906: fetch c_single_asg_term into l_asg_id,
907: ln_arch_asgact_id,
908: ln_arch_pact_id,
909: l_effective_end_date;
910: hr_utility.trace('fetching from c_single_asg_term CURSOR');
911: exit when c_single_asg_term%notfound;
912: else
913: fetch c_single_asg into l_asg_id,
914: ln_arch_asgact_id,

Line 917: hr_utility.trace('fetching from c_single_asg CURSOR');

913: fetch c_single_asg into l_asg_id,
914: ln_arch_asgact_id,
915: ln_arch_pact_id,
916: l_effective_end_date;
917: hr_utility.trace('fetching from c_single_asg CURSOR');
918: exit when c_single_asg%notfound;
919: end if;
920: else
921: if l_person_on then -- Added if for bug 10399514

Line 927: hr_utility.trace('fetching from c_all_asg_range_term CURSOR');

923: fetch c_all_asg_range_term into l_asg_id,
924: ln_arch_asgact_id,
925: ln_arch_pact_id,
926: l_effective_end_date;
927: hr_utility.trace('fetching from c_all_asg_range_term CURSOR');
928: exit when c_all_asg_range_term%notfound;
929: else
930: fetch c_all_asg_range into l_asg_id,
931: ln_arch_asgact_id,

Line 934: hr_utility.trace('fetching from c_all_asg_range CURSOR');

930: fetch c_all_asg_range into l_asg_id,
931: ln_arch_asgact_id,
932: ln_arch_pact_id,
933: l_effective_end_date;
934: hr_utility.trace('fetching from c_all_asg_range CURSOR');
935: exit when c_all_asg_range%notfound;
936: end if;
937: else
938: if nvl(l_print_term,'N') = 'Y' then

Line 943: hr_utility.trace('fetching from c_all_asg_term CURSOR');

939: fetch c_all_asg_term into l_asg_id,
940: ln_arch_asgact_id,
941: ln_arch_pact_id,
942: l_effective_end_date;
943: hr_utility.trace('fetching from c_all_asg_term CURSOR');
944: exit when c_all_asg_term%notfound;
945: else
946: fetch c_all_asg into l_asg_id,
947: ln_arch_asgact_id,

Line 950: hr_utility.trace('fetching from c_all_asg CURSOR');

946: fetch c_all_asg into l_asg_id,
947: ln_arch_asgact_id,
948: ln_arch_pact_id,
949: l_effective_end_date;
950: hr_utility.trace('fetching from c_all_asg CURSOR');
951: exit when c_all_asg%notfound;
952: end if;
953: end if;
954: end if;

Line 956: hr_utility.trace('Begining of if part loop for c_all_asg 20 '||

952: end if;
953: end if;
954: end if;
955:
956: hr_utility.trace('Begining of if part loop for c_all_asg 20 '||
957: to_char(l_asg_id));
958:
959:
960: if (l_report_type = 'PAYCAT4APDF' and nvl(pay_us_employee_payslip_web.get_doc_eit('T4APDF',

Line 975: hr_utility.trace('in if loop after calling hr_nonrun_asact.insact pkg 9 '||

971: pactid,
972: chunk,
973: l_tax_unit_id);
974:
975: hr_utility.trace('in if loop after calling hr_nonrun_asact.insact pkg 9 '||
976: to_char(l_asg_id));
977:
978: /* Added this to implement T4A Register and T4A Amendment Register
979: using the same report file */

Line 990: hr_utility.trace('lv_serial_number :' ||lv_serial_number);

986: lv_serial_number := lv_serial_number ||trim(pay_ca_archive_utils.get_archive_value(ln_arch_asgact_id ,
987: 'CAEOY_T4A_NEGATIVE_BALANCE_EXISTS'));
988: end if;
989:
990: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
991:
992: update pay_assignment_actions paa
993: set paa.serial_number = lv_serial_number
994: where paa.assignment_action_id = lockingactid;

Line 1004: hr_utility.trace('closing c_all_asg_in_asgset_range_term CURSOR');

1000: if l_asg_set_id is not null then
1001: if l_person_on then -- Added if for bug 10399514
1002: if nvl(l_print_term,'N') = 'Y' then
1003: close c_all_asg_in_asgset_range_term;
1004: hr_utility.trace('closing c_all_asg_in_asgset_range_term CURSOR');
1005: else
1006: close c_all_asg_in_asgset_range;
1007: hr_utility.trace('closing c_all_asg_in_asgset_range CURSOR');
1008: end if;

Line 1007: hr_utility.trace('closing c_all_asg_in_asgset_range CURSOR');

1003: close c_all_asg_in_asgset_range_term;
1004: hr_utility.trace('closing c_all_asg_in_asgset_range_term CURSOR');
1005: else
1006: close c_all_asg_in_asgset_range;
1007: hr_utility.trace('closing c_all_asg_in_asgset_range CURSOR');
1008: end if;
1009: else
1010: if nvl(l_print_term,'N') = 'Y' then
1011: close c_all_asg_in_asgset_term;

Line 1012: hr_utility.trace('closing c_all_asg_in_asgset_term CURSOR');

1008: end if;
1009: else
1010: if nvl(l_print_term,'N') = 'Y' then
1011: close c_all_asg_in_asgset_term;
1012: hr_utility.trace('closing c_all_asg_in_asgset_term CURSOR');
1013: else
1014: close c_all_asg_in_asgset;
1015: hr_utility.trace('closing c_all_asg_in_asgset CURSOR');
1016: end if;

Line 1015: hr_utility.trace('closing c_all_asg_in_asgset CURSOR');

1011: close c_all_asg_in_asgset_term;
1012: hr_utility.trace('closing c_all_asg_in_asgset_term CURSOR');
1013: else
1014: close c_all_asg_in_asgset;
1015: hr_utility.trace('closing c_all_asg_in_asgset CURSOR');
1016: end if;
1017: end if;
1018: elsif lv_per_id is not null then
1019: if nvl(l_print_term,'N') = 'Y' then

Line 1021: hr_utility.trace('closing c_single_asg_term CURSOR');

1017: end if;
1018: elsif lv_per_id is not null then
1019: if nvl(l_print_term,'N') = 'Y' then
1020: close c_single_asg_term;
1021: hr_utility.trace('closing c_single_asg_term CURSOR');
1022: else
1023: close c_single_asg;
1024: hr_utility.trace('closing c_single_asg CURSOR');
1025: end if;

Line 1024: hr_utility.trace('closing c_single_asg CURSOR');

1020: close c_single_asg_term;
1021: hr_utility.trace('closing c_single_asg_term CURSOR');
1022: else
1023: close c_single_asg;
1024: hr_utility.trace('closing c_single_asg CURSOR');
1025: end if;
1026: else
1027: if l_person_on then -- Added if for bug 10399514
1028: if nvl(l_print_term,'N') = 'Y' then

Line 1030: hr_utility.trace('closing c_all_asg_range_term CURSOR');

1026: else
1027: if l_person_on then -- Added if for bug 10399514
1028: if nvl(l_print_term,'N') = 'Y' then
1029: close c_all_asg_range_term;
1030: hr_utility.trace('closing c_all_asg_range_term CURSOR');
1031: else
1032: close c_all_asg_range;
1033: hr_utility.trace('closing c_all_asg_range CURSOR');
1034: end if;

Line 1033: hr_utility.trace('closing c_all_asg_range CURSOR');

1029: close c_all_asg_range_term;
1030: hr_utility.trace('closing c_all_asg_range_term CURSOR');
1031: else
1032: close c_all_asg_range;
1033: hr_utility.trace('closing c_all_asg_range CURSOR');
1034: end if;
1035: else
1036: if nvl(l_print_term,'N') = 'Y' then
1037: close c_all_asg_term;

Line 1038: hr_utility.trace('closing c_all_asg_term CURSOR');

1034: end if;
1035: else
1036: if nvl(l_print_term,'N') = 'Y' then
1037: close c_all_asg_term;
1038: hr_utility.trace('closing c_all_asg_term CURSOR');
1039: else
1040: close c_all_asg;
1041: hr_utility.trace('closing c_all_asg CURSOR');
1042: end if;

Line 1041: hr_utility.trace('closing c_all_asg CURSOR');

1037: close c_all_asg_term;
1038: hr_utility.trace('closing c_all_asg_term CURSOR');
1039: else
1040: close c_all_asg;
1041: hr_utility.trace('closing c_all_asg CURSOR');
1042: end if;
1043: end if;
1044: end if;
1045:

Line 1052: hr_utility.trace('End of If Condition for Loop 13');

1048: close c_all_gres;
1049:
1050: end if;
1051:
1052: hr_utility.trace('End of If Condition for Loop 13');
1053: end action_creation;
1054:
1055: ---------------------------------- sort_action ---------------------------------
1056:

Line 1064: hr_utility.trace('Start of Sort_Action 1');

1060: sqlstr in out nocopy varchar2, /* string holding the sql statement */
1061: len out nocopy number /* length of the sql string */
1062: ) is
1063: begin
1064: hr_utility.trace('Start of Sort_Action 1');
1065:
1066:
1067: sqlstr := 'select paa1.rowid
1068: from hr_all_organization_units hou,

Line 1117: hr_utility.trace('End of Sort_Action 2');

1113: ppf.last_name,first_name
1114: for update of paa1.assignment_action_id';
1115:
1116: len := length(sqlstr); -- return the length of the string.
1117: hr_utility.trace('End of Sort_Action 2');
1118: end sort_action;
1119: --
1120: ------------------------------ get_parameter -------------------------------
1121: function get_parameter(name in varchar2,