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.

[Home] [Help]

APPS.PAY_IN_EXC dependencies on PAY_IN_UTILS

Line 408: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

404: BEGIN
405:
406: g_debug := hr_utility.debug_enabled;
407: l_procedure := g_package ||'date_ec1';
408: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
409:
410: IF g_debug THEN
411: pay_in_utils.trace('**************************************************','********************');
412: pay_in_utils.trace('Owner Payroll Action id ',p_owner_payroll_action_id);

Line 411: pay_in_utils.trace('******************************','');

407: l_procedure := g_package ||'date_ec1';
408: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
409:
410: IF g_debug THEN
411: pay_in_utils.trace('**************************************************','********************');
412: pay_in_utils.trace('Owner Payroll Action id ',p_owner_payroll_action_id);
413: pay_in_utils.trace('User Payroll Action id ',p_user_payroll_action_id);
414: pay_in_utils.trace('Owner Assignment Action id ',p_owner_assignment_action_id);
415: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);

Line 412: pay_in_utils.trace('Owner Payroll Action id ',p_owner_payroll_action_id);

408: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
409:
410: IF g_debug THEN
411: pay_in_utils.trace('**************************************************','********************');
412: pay_in_utils.trace('Owner Payroll Action id ',p_owner_payroll_action_id);
413: pay_in_utils.trace('User Payroll Action id ',p_user_payroll_action_id);
414: pay_in_utils.trace('Owner Assignment Action id ',p_owner_assignment_action_id);
415: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);
416: pay_in_utils.trace('Owner Effective Date ',p_owner_effective_date);

Line 413: pay_in_utils.trace('User Payroll Action id ',p_user_payroll_action_id);

409:
410: IF g_debug THEN
411: pay_in_utils.trace('**************************************************','********************');
412: pay_in_utils.trace('Owner Payroll Action id ',p_owner_payroll_action_id);
413: pay_in_utils.trace('User Payroll Action id ',p_user_payroll_action_id);
414: pay_in_utils.trace('Owner Assignment Action id ',p_owner_assignment_action_id);
415: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);
416: pay_in_utils.trace('Owner Effective Date ',p_owner_effective_date);
417: pay_in_utils.trace('User Effective Date ',p_user_effective_date);

Line 414: pay_in_utils.trace('Owner Assignment Action id ',p_owner_assignment_action_id);

410: IF g_debug THEN
411: pay_in_utils.trace('**************************************************','********************');
412: pay_in_utils.trace('Owner Payroll Action id ',p_owner_payroll_action_id);
413: pay_in_utils.trace('User Payroll Action id ',p_user_payroll_action_id);
414: pay_in_utils.trace('Owner Assignment Action id ',p_owner_assignment_action_id);
415: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);
416: pay_in_utils.trace('Owner Effective Date ',p_owner_effective_date);
417: pay_in_utils.trace('User Effective Date ',p_user_effective_date);
418: pay_in_utils.trace('Dimension Name ',p_dimension_name);

Line 415: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);

411: pay_in_utils.trace('**************************************************','********************');
412: pay_in_utils.trace('Owner Payroll Action id ',p_owner_payroll_action_id);
413: pay_in_utils.trace('User Payroll Action id ',p_user_payroll_action_id);
414: pay_in_utils.trace('Owner Assignment Action id ',p_owner_assignment_action_id);
415: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);
416: pay_in_utils.trace('Owner Effective Date ',p_owner_effective_date);
417: pay_in_utils.trace('User Effective Date ',p_user_effective_date);
418: pay_in_utils.trace('Dimension Name ',p_dimension_name);
419: pay_in_utils.trace('**************************************************','********************');

Line 416: pay_in_utils.trace('Owner Effective Date ',p_owner_effective_date);

412: pay_in_utils.trace('Owner Payroll Action id ',p_owner_payroll_action_id);
413: pay_in_utils.trace('User Payroll Action id ',p_user_payroll_action_id);
414: pay_in_utils.trace('Owner Assignment Action id ',p_owner_assignment_action_id);
415: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);
416: pay_in_utils.trace('Owner Effective Date ',p_owner_effective_date);
417: pay_in_utils.trace('User Effective Date ',p_user_effective_date);
418: pay_in_utils.trace('Dimension Name ',p_dimension_name);
419: pay_in_utils.trace('**************************************************','********************');
420: END IF;

Line 417: pay_in_utils.trace('User Effective Date ',p_user_effective_date);

413: pay_in_utils.trace('User Payroll Action id ',p_user_payroll_action_id);
414: pay_in_utils.trace('Owner Assignment Action id ',p_owner_assignment_action_id);
415: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);
416: pay_in_utils.trace('Owner Effective Date ',p_owner_effective_date);
417: pay_in_utils.trace('User Effective Date ',p_user_effective_date);
418: pay_in_utils.trace('Dimension Name ',p_dimension_name);
419: pay_in_utils.trace('**************************************************','********************');
420: END IF;
421:

Line 418: pay_in_utils.trace('Dimension Name ',p_dimension_name);

414: pay_in_utils.trace('Owner Assignment Action id ',p_owner_assignment_action_id);
415: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);
416: pay_in_utils.trace('Owner Effective Date ',p_owner_effective_date);
417: pay_in_utils.trace('User Effective Date ',p_user_effective_date);
418: pay_in_utils.trace('Dimension Name ',p_dimension_name);
419: pay_in_utils.trace('**************************************************','********************');
420: END IF;
421:
422: IF p_dimension_name LIKE '%RUN' THEN

Line 419: pay_in_utils.trace('******************************','');

415: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);
416: pay_in_utils.trace('Owner Effective Date ',p_owner_effective_date);
417: pay_in_utils.trace('User Effective Date ',p_user_effective_date);
418: pay_in_utils.trace('Dimension Name ',p_dimension_name);
419: pay_in_utils.trace('**************************************************','********************');
420: END IF;
421:
422: IF p_dimension_name LIKE '%RUN' THEN
423: -- must check for special case: if payroll action id's are the same,

Line 497: pay_in_utils.trace('******************************','');

493: p_expiry_information := 0;
494: END IF;
495:
496: IF g_debug THEN
497: pay_in_utils.trace('**************************************************','********************');
498: pay_in_utils.trace('Expiry Date ',l_expiry_date);
499: pay_in_utils.trace('Expiry Information ',p_expiry_information);
500: pay_in_utils.trace('**************************************************','********************');
501: END IF;

Line 498: pay_in_utils.trace('Expiry Date ',l_expiry_date);

494: END IF;
495:
496: IF g_debug THEN
497: pay_in_utils.trace('**************************************************','********************');
498: pay_in_utils.trace('Expiry Date ',l_expiry_date);
499: pay_in_utils.trace('Expiry Information ',p_expiry_information);
500: pay_in_utils.trace('**************************************************','********************');
501: END IF;
502: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

Line 499: pay_in_utils.trace('Expiry Information ',p_expiry_information);

495:
496: IF g_debug THEN
497: pay_in_utils.trace('**************************************************','********************');
498: pay_in_utils.trace('Expiry Date ',l_expiry_date);
499: pay_in_utils.trace('Expiry Information ',p_expiry_information);
500: pay_in_utils.trace('**************************************************','********************');
501: END IF;
502: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
503:

Line 500: pay_in_utils.trace('******************************','');

496: IF g_debug THEN
497: pay_in_utils.trace('**************************************************','********************');
498: pay_in_utils.trace('Expiry Date ',l_expiry_date);
499: pay_in_utils.trace('Expiry Information ',p_expiry_information);
500: pay_in_utils.trace('**************************************************','********************');
501: END IF;
502: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
503:
504: END date_ec;

Line 502: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

498: pay_in_utils.trace('Expiry Date ',l_expiry_date);
499: pay_in_utils.trace('Expiry Information ',p_expiry_information);
500: pay_in_utils.trace('**************************************************','********************');
501: END IF;
502: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
503:
504: END date_ec;
505:
506: --------------------------------------------------------------------------

Line 555: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

551: BEGIN
552:
553: g_debug := hr_utility.debug_enabled;
554: l_procedure := g_package ||'date_ec2';
555: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
556:
557: IF g_debug THEN
558: pay_in_utils.trace('**************************************************','********************');
559: pay_in_utils.trace('Owner Payroll Action id ',p_owner_payroll_action_id);

Line 558: pay_in_utils.trace('******************************','');

554: l_procedure := g_package ||'date_ec2';
555: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
556:
557: IF g_debug THEN
558: pay_in_utils.trace('**************************************************','********************');
559: pay_in_utils.trace('Owner Payroll Action id ',p_owner_payroll_action_id);
560: pay_in_utils.trace('User Payroll Action id ',p_user_payroll_action_id);
561: pay_in_utils.trace('Owner Assignment Action id ',p_owner_assignment_action_id);
562: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);

Line 559: pay_in_utils.trace('Owner Payroll Action id ',p_owner_payroll_action_id);

555: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
556:
557: IF g_debug THEN
558: pay_in_utils.trace('**************************************************','********************');
559: pay_in_utils.trace('Owner Payroll Action id ',p_owner_payroll_action_id);
560: pay_in_utils.trace('User Payroll Action id ',p_user_payroll_action_id);
561: pay_in_utils.trace('Owner Assignment Action id ',p_owner_assignment_action_id);
562: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);
563: pay_in_utils.trace('Owner Effective Date ',p_owner_effective_date);

Line 560: pay_in_utils.trace('User Payroll Action id ',p_user_payroll_action_id);

556:
557: IF g_debug THEN
558: pay_in_utils.trace('**************************************************','********************');
559: pay_in_utils.trace('Owner Payroll Action id ',p_owner_payroll_action_id);
560: pay_in_utils.trace('User Payroll Action id ',p_user_payroll_action_id);
561: pay_in_utils.trace('Owner Assignment Action id ',p_owner_assignment_action_id);
562: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);
563: pay_in_utils.trace('Owner Effective Date ',p_owner_effective_date);
564: pay_in_utils.trace('User Effective Date ',p_user_effective_date);

Line 561: pay_in_utils.trace('Owner Assignment Action id ',p_owner_assignment_action_id);

557: IF g_debug THEN
558: pay_in_utils.trace('**************************************************','********************');
559: pay_in_utils.trace('Owner Payroll Action id ',p_owner_payroll_action_id);
560: pay_in_utils.trace('User Payroll Action id ',p_user_payroll_action_id);
561: pay_in_utils.trace('Owner Assignment Action id ',p_owner_assignment_action_id);
562: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);
563: pay_in_utils.trace('Owner Effective Date ',p_owner_effective_date);
564: pay_in_utils.trace('User Effective Date ',p_user_effective_date);
565: pay_in_utils.trace('Dimension Name ',p_dimension_name);

Line 562: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);

558: pay_in_utils.trace('**************************************************','********************');
559: pay_in_utils.trace('Owner Payroll Action id ',p_owner_payroll_action_id);
560: pay_in_utils.trace('User Payroll Action id ',p_user_payroll_action_id);
561: pay_in_utils.trace('Owner Assignment Action id ',p_owner_assignment_action_id);
562: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);
563: pay_in_utils.trace('Owner Effective Date ',p_owner_effective_date);
564: pay_in_utils.trace('User Effective Date ',p_user_effective_date);
565: pay_in_utils.trace('Dimension Name ',p_dimension_name);
566: pay_in_utils.trace('**************************************************','********************');

Line 563: pay_in_utils.trace('Owner Effective Date ',p_owner_effective_date);

559: pay_in_utils.trace('Owner Payroll Action id ',p_owner_payroll_action_id);
560: pay_in_utils.trace('User Payroll Action id ',p_user_payroll_action_id);
561: pay_in_utils.trace('Owner Assignment Action id ',p_owner_assignment_action_id);
562: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);
563: pay_in_utils.trace('Owner Effective Date ',p_owner_effective_date);
564: pay_in_utils.trace('User Effective Date ',p_user_effective_date);
565: pay_in_utils.trace('Dimension Name ',p_dimension_name);
566: pay_in_utils.trace('**************************************************','********************');
567: END IF;

Line 564: pay_in_utils.trace('User Effective Date ',p_user_effective_date);

560: pay_in_utils.trace('User Payroll Action id ',p_user_payroll_action_id);
561: pay_in_utils.trace('Owner Assignment Action id ',p_owner_assignment_action_id);
562: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);
563: pay_in_utils.trace('Owner Effective Date ',p_owner_effective_date);
564: pay_in_utils.trace('User Effective Date ',p_user_effective_date);
565: pay_in_utils.trace('Dimension Name ',p_dimension_name);
566: pay_in_utils.trace('**************************************************','********************');
567: END IF;
568:

Line 565: pay_in_utils.trace('Dimension Name ',p_dimension_name);

561: pay_in_utils.trace('Owner Assignment Action id ',p_owner_assignment_action_id);
562: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);
563: pay_in_utils.trace('Owner Effective Date ',p_owner_effective_date);
564: pay_in_utils.trace('User Effective Date ',p_user_effective_date);
565: pay_in_utils.trace('Dimension Name ',p_dimension_name);
566: pay_in_utils.trace('**************************************************','********************');
567: END IF;
568:
569:

Line 566: pay_in_utils.trace('******************************','');

562: pay_in_utils.trace('User Assignment Action id ',p_user_assignment_action_id);
563: pay_in_utils.trace('Owner Effective Date ',p_owner_effective_date);
564: pay_in_utils.trace('User Effective Date ',p_user_effective_date);
565: pay_in_utils.trace('Dimension Name ',p_dimension_name);
566: pay_in_utils.trace('**************************************************','********************');
567: END IF;
568:
569:
570: IF p_dimension_name LIKE '%RUN' THEN

Line 625: pay_in_utils.trace('******************************','');

621:
622: END IF;
623:
624: IF g_debug THEN
625: pay_in_utils.trace('**************************************************','********************');
626: pay_in_utils.trace('Expiry Information ',p_expiry_information);
627: pay_in_utils.trace('**************************************************','********************');
628: END IF;
629:

Line 626: pay_in_utils.trace('Expiry Information ',p_expiry_information);

622: END IF;
623:
624: IF g_debug THEN
625: pay_in_utils.trace('**************************************************','********************');
626: pay_in_utils.trace('Expiry Information ',p_expiry_information);
627: pay_in_utils.trace('**************************************************','********************');
628: END IF;
629:
630: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

Line 627: pay_in_utils.trace('******************************','');

623:
624: IF g_debug THEN
625: pay_in_utils.trace('**************************************************','********************');
626: pay_in_utils.trace('Expiry Information ',p_expiry_information);
627: pay_in_utils.trace('**************************************************','********************');
628: END IF;
629:
630: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
631:

Line 630: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

626: pay_in_utils.trace('Expiry Information ',p_expiry_information);
627: pay_in_utils.trace('**************************************************','********************');
628: END IF;
629:
630: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
631:
632: END date_ec;
633:
634: PROCEDURE cal_hy_start(p_effective_date IN DATE ,

Line 653: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

649:
650: BEGIN
651: g_debug := hr_utility.debug_enabled;
652: l_procedure := g_package ||'cal_hy_start';
653: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
654:
655: p_start_date :=NULL;
656: l_year := TO_NUMBER (TO_CHAR(p_effective_date,'yyyy'));
657: l_month := TO_NUMBER (TO_CHAR(p_effective_date,'mm'));

Line 666: pay_in_utils.trace('******************************','');

662: p_start_date:=TO_DATE(l_half_start2||TO_CHAR(l_year),'DD-MM-YYYY');
663: END IF;
664:
665: IF g_debug THEN
666: pay_in_utils.trace('**************************************************','********************');
667: pay_in_utils.trace('Effective Date ',p_effective_date);
668: pay_in_utils.trace('Start Date ',p_start_date);
669: pay_in_utils.trace('**************************************************','********************');
670: END IF;

Line 667: pay_in_utils.trace('Effective Date ',p_effective_date);

663: END IF;
664:
665: IF g_debug THEN
666: pay_in_utils.trace('**************************************************','********************');
667: pay_in_utils.trace('Effective Date ',p_effective_date);
668: pay_in_utils.trace('Start Date ',p_start_date);
669: pay_in_utils.trace('**************************************************','********************');
670: END IF;
671:

Line 668: pay_in_utils.trace('Start Date ',p_start_date);

664:
665: IF g_debug THEN
666: pay_in_utils.trace('**************************************************','********************');
667: pay_in_utils.trace('Effective Date ',p_effective_date);
668: pay_in_utils.trace('Start Date ',p_start_date);
669: pay_in_utils.trace('**************************************************','********************');
670: END IF;
671:
672: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

Line 669: pay_in_utils.trace('******************************','');

665: IF g_debug THEN
666: pay_in_utils.trace('**************************************************','********************');
667: pay_in_utils.trace('Effective Date ',p_effective_date);
668: pay_in_utils.trace('Start Date ',p_start_date);
669: pay_in_utils.trace('**************************************************','********************');
670: END IF;
671:
672: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
673:

Line 672: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

668: pay_in_utils.trace('Start Date ',p_start_date);
669: pay_in_utils.trace('**************************************************','********************');
670: END IF;
671:
672: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
673:
674: END;
675:
676:

Line 695: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

691:
692: BEGIN
693: g_debug := hr_utility.debug_enabled;
694: l_procedure := g_package ||'prov_ytd_start';
695: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
696:
697: p_start_date :=NULL;
698: l_year := TO_NUMBER (TO_CHAR(p_effective_date,'yyyy'));
699:

Line 707: pay_in_utils.trace('******************************','');

703: p_start_date := TO_DATE('01-03-'||TO_CHAR(l_year-1),'DD-MM-YYYY');
704: END IF;
705:
706: IF g_debug THEN
707: pay_in_utils.trace('**************************************************','********************');
708: pay_in_utils.trace('Effective Date ',p_effective_date);
709: pay_in_utils.trace('Start Date ',p_start_date);
710: END IF;
711:

Line 708: pay_in_utils.trace('Effective Date ',p_effective_date);

704: END IF;
705:
706: IF g_debug THEN
707: pay_in_utils.trace('**************************************************','********************');
708: pay_in_utils.trace('Effective Date ',p_effective_date);
709: pay_in_utils.trace('Start Date ',p_start_date);
710: END IF;
711:
712: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

Line 709: pay_in_utils.trace('Start Date ',p_start_date);

705:
706: IF g_debug THEN
707: pay_in_utils.trace('**************************************************','********************');
708: pay_in_utils.trace('Effective Date ',p_effective_date);
709: pay_in_utils.trace('Start Date ',p_start_date);
710: END IF;
711:
712: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
713:

Line 712: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

708: pay_in_utils.trace('Effective Date ',p_effective_date);
709: pay_in_utils.trace('Start Date ',p_start_date);
710: END IF;
711:
712: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
713:
714: END;
715:
716: PROCEDURE hytd_start(p_effective_date IN DATE ,

Line 735: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

731:
732: BEGIN
733: g_debug := hr_utility.debug_enabled;
734: l_procedure := g_package ||'hytd_start';
735: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
736:
737: p_start_date :=NULL;
738: l_year := TO_NUMBER (TO_CHAR(p_effective_date,'yyyy'));
739: l_month := TO_NUMBER (TO_CHAR(p_effective_date,'mm'));

Line 750: pay_in_utils.trace('******************************','');

746: p_start_date:=TO_DATE(l_half_start2||TO_CHAR(l_year-1),'DD-MM-YYYY');
747: END IF;
748:
749: IF g_debug THEN
750: pay_in_utils.trace('**************************************************','********************');
751: pay_in_utils.trace('Effective Date ',p_effective_date);
752: pay_in_utils.trace('Start Date ',p_start_date);
753: pay_in_utils.trace('**************************************************','********************');
754: END IF;

Line 751: pay_in_utils.trace('Effective Date ',p_effective_date);

747: END IF;
748:
749: IF g_debug THEN
750: pay_in_utils.trace('**************************************************','********************');
751: pay_in_utils.trace('Effective Date ',p_effective_date);
752: pay_in_utils.trace('Start Date ',p_start_date);
753: pay_in_utils.trace('**************************************************','********************');
754: END IF;
755:

Line 752: pay_in_utils.trace('Start Date ',p_start_date);

748:
749: IF g_debug THEN
750: pay_in_utils.trace('**************************************************','********************');
751: pay_in_utils.trace('Effective Date ',p_effective_date);
752: pay_in_utils.trace('Start Date ',p_start_date);
753: pay_in_utils.trace('**************************************************','********************');
754: END IF;
755:
756: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

Line 753: pay_in_utils.trace('******************************','');

749: IF g_debug THEN
750: pay_in_utils.trace('**************************************************','********************');
751: pay_in_utils.trace('Effective Date ',p_effective_date);
752: pay_in_utils.trace('Start Date ',p_start_date);
753: pay_in_utils.trace('**************************************************','********************');
754: END IF;
755:
756: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
757:

Line 756: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

752: pay_in_utils.trace('Start Date ',p_start_date);
753: pay_in_utils.trace('**************************************************','********************');
754: END IF;
755:
756: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
757:
758: END;
759:
760: PROCEDURE get_td_start(p_effective_date in date,

Line 797: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

793:
794: BEGIN
795: g_debug := hr_utility.debug_enabled;
796: l_procedure := g_package ||'get_td_start';
797: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
798:
799: p_start_date :=NULL;
800: l_year := TO_NUMBER (TO_CHAR(p_effective_date,'yyyy'));
801: l_month := TO_NUMBER (TO_CHAR(p_effective_date,'mm'));

Line 831: pay_in_utils.trace('******************************','');

827: END IF;
828:
829: END IF;
830: IF g_debug THEN
831: pay_in_utils.trace('**************************************************','********************');
832: pay_in_utils.trace('Frequency ',l_frequency );
833: pay_in_utils.trace('Effective Date ',p_effective_date);
834: pay_in_utils.trace('Start Date ',p_start_date);
835: pay_in_utils.trace('**************************************************','********************');

Line 832: pay_in_utils.trace('Frequency ',l_frequency );

828:
829: END IF;
830: IF g_debug THEN
831: pay_in_utils.trace('**************************************************','********************');
832: pay_in_utils.trace('Frequency ',l_frequency );
833: pay_in_utils.trace('Effective Date ',p_effective_date);
834: pay_in_utils.trace('Start Date ',p_start_date);
835: pay_in_utils.trace('**************************************************','********************');
836: END IF;

Line 833: pay_in_utils.trace('Effective Date ',p_effective_date);

829: END IF;
830: IF g_debug THEN
831: pay_in_utils.trace('**************************************************','********************');
832: pay_in_utils.trace('Frequency ',l_frequency );
833: pay_in_utils.trace('Effective Date ',p_effective_date);
834: pay_in_utils.trace('Start Date ',p_start_date);
835: pay_in_utils.trace('**************************************************','********************');
836: END IF;
837:

Line 834: pay_in_utils.trace('Start Date ',p_start_date);

830: IF g_debug THEN
831: pay_in_utils.trace('**************************************************','********************');
832: pay_in_utils.trace('Frequency ',l_frequency );
833: pay_in_utils.trace('Effective Date ',p_effective_date);
834: pay_in_utils.trace('Start Date ',p_start_date);
835: pay_in_utils.trace('**************************************************','********************');
836: END IF;
837:
838: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

Line 835: pay_in_utils.trace('******************************','');

831: pay_in_utils.trace('**************************************************','********************');
832: pay_in_utils.trace('Frequency ',l_frequency );
833: pay_in_utils.trace('Effective Date ',p_effective_date);
834: pay_in_utils.trace('Start Date ',p_start_date);
835: pay_in_utils.trace('**************************************************','********************');
836: END IF;
837:
838: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
839:

Line 838: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

834: pay_in_utils.trace('Start Date ',p_start_date);
835: pay_in_utils.trace('**************************************************','********************');
836: END IF;
837:
838: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
839:
840: END;
841:
842: --------------------------------------------------------------------------

Line 876: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

872: l_message VARCHAR2(255);
873: BEGIN
874: g_debug := hr_utility.debug_enabled;
875: l_procedure := g_package ||'start_code_pmth';
876: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
877:
878: p_start_date := last_day(add_months(p_effective_date, -2))+1;
879:
880: IF g_debug THEN

Line 881: pay_in_utils.trace('******************************','');

877:
878: p_start_date := last_day(add_months(p_effective_date, -2))+1;
879:
880: IF g_debug THEN
881: pay_in_utils.trace('**************************************************','********************');
882: pay_in_utils.trace('Effective Date ',p_effective_date);
883: pay_in_utils.trace('Start Date ',p_start_date);
884: pay_in_utils.trace('**************************************************','********************');
885: END IF;

Line 882: pay_in_utils.trace('Effective Date ',p_effective_date);

878: p_start_date := last_day(add_months(p_effective_date, -2))+1;
879:
880: IF g_debug THEN
881: pay_in_utils.trace('**************************************************','********************');
882: pay_in_utils.trace('Effective Date ',p_effective_date);
883: pay_in_utils.trace('Start Date ',p_start_date);
884: pay_in_utils.trace('**************************************************','********************');
885: END IF;
886:

Line 883: pay_in_utils.trace('Start Date ',p_start_date);

879:
880: IF g_debug THEN
881: pay_in_utils.trace('**************************************************','********************');
882: pay_in_utils.trace('Effective Date ',p_effective_date);
883: pay_in_utils.trace('Start Date ',p_start_date);
884: pay_in_utils.trace('**************************************************','********************');
885: END IF;
886:
887: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

Line 884: pay_in_utils.trace('******************************','');

880: IF g_debug THEN
881: pay_in_utils.trace('**************************************************','********************');
882: pay_in_utils.trace('Effective Date ',p_effective_date);
883: pay_in_utils.trace('Start Date ',p_start_date);
884: pay_in_utils.trace('**************************************************','********************');
885: END IF;
886:
887: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
888:

Line 887: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

883: pay_in_utils.trace('Start Date ',p_start_date);
884: pay_in_utils.trace('**************************************************','********************');
885: END IF;
886:
887: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
888:
889:
890: END start_code_pmth;
891:

Line 926: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

922: l_message VARCHAR2(255);
923: BEGIN
924: g_debug := hr_utility.debug_enabled;
925: l_procedure := g_package ||'start_code_p10mth';
926: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
927:
928: p_start_date := last_day(add_months(p_effective_date, -11))+1;
929:
930: IF g_debug THEN

Line 931: pay_in_utils.trace('******************************','');

927:
928: p_start_date := last_day(add_months(p_effective_date, -11))+1;
929:
930: IF g_debug THEN
931: pay_in_utils.trace('**************************************************','********************');
932: pay_in_utils.trace('Effective Date ',p_effective_date);
933: pay_in_utils.trace('Start Date ',p_start_date);
934: pay_in_utils.trace('**************************************************','********************');
935: END IF;

Line 932: pay_in_utils.trace('Effective Date ',p_effective_date);

928: p_start_date := last_day(add_months(p_effective_date, -11))+1;
929:
930: IF g_debug THEN
931: pay_in_utils.trace('**************************************************','********************');
932: pay_in_utils.trace('Effective Date ',p_effective_date);
933: pay_in_utils.trace('Start Date ',p_start_date);
934: pay_in_utils.trace('**************************************************','********************');
935: END IF;
936: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

Line 933: pay_in_utils.trace('Start Date ',p_start_date);

929:
930: IF g_debug THEN
931: pay_in_utils.trace('**************************************************','********************');
932: pay_in_utils.trace('Effective Date ',p_effective_date);
933: pay_in_utils.trace('Start Date ',p_start_date);
934: pay_in_utils.trace('**************************************************','********************');
935: END IF;
936: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
937:

Line 934: pay_in_utils.trace('******************************','');

930: IF g_debug THEN
931: pay_in_utils.trace('**************************************************','********************');
932: pay_in_utils.trace('Effective Date ',p_effective_date);
933: pay_in_utils.trace('Start Date ',p_start_date);
934: pay_in_utils.trace('**************************************************','********************');
935: END IF;
936: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
937:
938: END start_code_p10mth;

Line 936: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

932: pay_in_utils.trace('Effective Date ',p_effective_date);
933: pay_in_utils.trace('Start Date ',p_start_date);
934: pay_in_utils.trace('**************************************************','********************');
935: END IF;
936: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
937:
938: END start_code_p10mth;
939:
940: