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

Line 374: hr_utility.trace('Entering check_emp_personal_payment');

370: ln_time_period_id NUMBER;
371:
372: BEGIN
373:
374: hr_utility.trace('Entering check_emp_personal_payment');
375: hr_utility.trace('p_effective_date='||p_effective_date);
376: hr_utility.trace('p_time_period_id='||p_time_period_id);
377:
378: IF p_payment_category IS NOT NULL THEN

Line 375: hr_utility.trace('p_effective_date='||p_effective_date);

371:
372: BEGIN
373:
374: hr_utility.trace('Entering check_emp_personal_payment');
375: hr_utility.trace('p_effective_date='||p_effective_date);
376: hr_utility.trace('p_time_period_id='||p_time_period_id);
377:
378: IF p_payment_category IS NOT NULL THEN
379:

Line 376: hr_utility.trace('p_time_period_id='||p_time_period_id);

372: BEGIN
373:
374: hr_utility.trace('Entering check_emp_personal_payment');
375: hr_utility.trace('p_effective_date='||p_effective_date);
376: hr_utility.trace('p_time_period_id='||p_time_period_id);
377:
378: IF p_payment_category IS NOT NULL THEN
379:
380: lv_return_flag := 'Y';

Line 405: hr_utility.trace('ln_time_period_id='||ln_time_period_id);

401: end if;
402: close c_get_date_earned;
403: end if;
404:
405: hr_utility.trace('ln_time_period_id='||ln_time_period_id);
406: open c_view_offset(ln_time_period_id);
407: fetch c_view_offset into ld_view_payslip_offset_date;
408: close c_view_offset;
409: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));

Line 409: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));

405: hr_utility.trace('ln_time_period_id='||ln_time_period_id);
406: open c_view_offset(ln_time_period_id);
407: fetch c_view_offset into ld_view_payslip_offset_date;
408: close c_view_offset;
409: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
410: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
411: hr_utility.trace('sysdate='||trunc(sysdate));
412:
413: /* check if the Payslip view date is populated. If it is, check the value

Line 410: hr_utility.trace('p_effective_date='||trunc(p_effective_date));

406: open c_view_offset(ln_time_period_id);
407: fetch c_view_offset into ld_view_payslip_offset_date;
408: close c_view_offset;
409: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
410: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
411: hr_utility.trace('sysdate='||trunc(sysdate));
412:
413: /* check if the Payslip view date is populated. If it is, check the value
414: and make sure it is > sysdate otherwise don't show payslip */

Line 411: hr_utility.trace('sysdate='||trunc(sysdate));

407: fetch c_view_offset into ld_view_payslip_offset_date;
408: close c_view_offset;
409: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
410: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
411: hr_utility.trace('sysdate='||trunc(sysdate));
412:
413: /* check if the Payslip view date is populated. If it is, check the value
414: and make sure it is > sysdate otherwise don't show payslip */
415: if ld_view_payslip_offset_date is not null and

Line 417: hr_utility.trace('View offset return N');

413: /* check if the Payslip view date is populated. If it is, check the value
414: and make sure it is > sysdate otherwise don't show payslip */
415: if ld_view_payslip_offset_date is not null and
416: trunc(ld_view_payslip_offset_date) > trunc(sysdate) then
417: hr_utility.trace('View offset return N');
418: return('N');
419: end if;
420:
421: open c_check_for_reversal(ln_prepay_action_id);

Line 468: hr_utility.trace('lv_return_flag='||lv_return_flag);

464: END IF;
465: CLOSE c_no_prepayments;
466: END IF;
467:
468: hr_utility.trace('lv_return_flag='||lv_return_flag);
469: hr_utility.trace('Leaving check_emp_personal_payment');
470:
471: return lv_return_flag;
472: ELSE

Line 469: hr_utility.trace('Leaving check_emp_personal_payment');

465: CLOSE c_no_prepayments;
466: END IF;
467:
468: hr_utility.trace('lv_return_flag='||lv_return_flag);
469: hr_utility.trace('Leaving check_emp_personal_payment');
470:
471: return lv_return_flag;
472: ELSE
473: return(check_emp_personal_payment(

Line 534: hr_utility.trace('Entering check_gb_emp_personal_payment');

530: ln_time_period_id NUMBER;
531: ln_count NUMBER;
532:
533: BEGIN
534: hr_utility.trace('Entering check_gb_emp_personal_payment');
535: hr_utility.trace('p_assignment_id='||p_assignment_id);
536: hr_utility.trace('p_payroll_id='||p_payroll_id);
537: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);
538: hr_utility.trace('p_effective_date='||p_effective_date);

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

531: ln_count NUMBER;
532:
533: BEGIN
534: hr_utility.trace('Entering check_gb_emp_personal_payment');
535: hr_utility.trace('p_assignment_id='||p_assignment_id);
536: hr_utility.trace('p_payroll_id='||p_payroll_id);
537: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);
538: hr_utility.trace('p_effective_date='||p_effective_date);
539: hr_utility.trace('p_time_period_id='||p_time_period_id);

Line 536: hr_utility.trace('p_payroll_id='||p_payroll_id);

532:
533: BEGIN
534: hr_utility.trace('Entering check_gb_emp_personal_payment');
535: hr_utility.trace('p_assignment_id='||p_assignment_id);
536: hr_utility.trace('p_payroll_id='||p_payroll_id);
537: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);
538: hr_utility.trace('p_effective_date='||p_effective_date);
539: hr_utility.trace('p_time_period_id='||p_time_period_id);
540:

Line 537: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);

533: BEGIN
534: hr_utility.trace('Entering check_gb_emp_personal_payment');
535: hr_utility.trace('p_assignment_id='||p_assignment_id);
536: hr_utility.trace('p_payroll_id='||p_payroll_id);
537: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);
538: hr_utility.trace('p_effective_date='||p_effective_date);
539: hr_utility.trace('p_time_period_id='||p_time_period_id);
540:
541: lv_return_flag := 'Y';

Line 538: hr_utility.trace('p_effective_date='||p_effective_date);

534: hr_utility.trace('Entering check_gb_emp_personal_payment');
535: hr_utility.trace('p_assignment_id='||p_assignment_id);
536: hr_utility.trace('p_payroll_id='||p_payroll_id);
537: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);
538: hr_utility.trace('p_effective_date='||p_effective_date);
539: hr_utility.trace('p_time_period_id='||p_time_period_id);
540:
541: lv_return_flag := 'Y';
542:

Line 539: hr_utility.trace('p_time_period_id='||p_time_period_id);

535: hr_utility.trace('p_assignment_id='||p_assignment_id);
536: hr_utility.trace('p_payroll_id='||p_payroll_id);
537: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);
538: hr_utility.trace('p_effective_date='||p_effective_date);
539: hr_utility.trace('p_time_period_id='||p_time_period_id);
540:
541: lv_return_flag := 'Y';
542:
543: ln_time_period_id := p_time_period_id;

Line 555: hr_utility.trace('ln_time_period_id='||ln_time_period_id);

551: end if;
552: close c_get_date_earned;
553: end if;
554:
555: hr_utility.trace('ln_time_period_id='||ln_time_period_id);
556: open c_view_offset(ln_time_period_id);
557: fetch c_view_offset into ld_view_payslip_offset_date;
558: close c_view_offset;
559: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));

Line 559: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));

555: hr_utility.trace('ln_time_period_id='||ln_time_period_id);
556: open c_view_offset(ln_time_period_id);
557: fetch c_view_offset into ld_view_payslip_offset_date;
558: close c_view_offset;
559: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
560: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
561: hr_utility.trace('sysdate='||trunc(sysdate));
562:
563: /* check if the Payslip view date is populated. If it is, check the value

Line 560: hr_utility.trace('p_effective_date='||trunc(p_effective_date));

556: open c_view_offset(ln_time_period_id);
557: fetch c_view_offset into ld_view_payslip_offset_date;
558: close c_view_offset;
559: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
560: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
561: hr_utility.trace('sysdate='||trunc(sysdate));
562:
563: /* check if the Payslip view date is populated. If it is, check the value
564: and make sure it is > sysdate otherwise don't show payslip */

Line 561: hr_utility.trace('sysdate='||trunc(sysdate));

557: fetch c_view_offset into ld_view_payslip_offset_date;
558: close c_view_offset;
559: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
560: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
561: hr_utility.trace('sysdate='||trunc(sysdate));
562:
563: /* check if the Payslip view date is populated. If it is, check the value
564: and make sure it is > sysdate otherwise don't show payslip */
565: if ld_view_payslip_offset_date is not null and

Line 567: hr_utility.trace('View offset return N');

563: /* check if the Payslip view date is populated. If it is, check the value
564: and make sure it is > sysdate otherwise don't show payslip */
565: if ld_view_payslip_offset_date is not null and
566: trunc(ld_view_payslip_offset_date) > trunc(sysdate) then
567: hr_utility.trace('View offset return N');
568: return('N');
569: end if;
570:
571: ln_count := 0;

Line 580: hr_utility.trace('lv_return_flag='||lv_return_flag);

576: then return('N');
577: end if;
578: close c_get_archived;
579:
580: hr_utility.trace('lv_return_flag='||lv_return_flag);
581: hr_utility.trace('Leaving check_gb_emp_personal_payment');
582:
583: return lv_return_flag;
584:

Line 581: hr_utility.trace('Leaving check_gb_emp_personal_payment');

577: end if;
578: close c_get_archived;
579:
580: hr_utility.trace('lv_return_flag='||lv_return_flag);
581: hr_utility.trace('Leaving check_gb_emp_personal_payment');
582:
583: return lv_return_flag;
584:
585: END check_gb_emp_personal_payment;

Line 640: hr_utility.trace('Entering check_sa_emp_personal_payment');

636: ln_time_period_id NUMBER;
637: ln_count NUMBER;
638:
639: BEGIN
640: hr_utility.trace('Entering check_sa_emp_personal_payment');
641: hr_utility.trace('p_assignment_id='||p_assignment_id);
642: hr_utility.trace('p_payroll_id='||p_payroll_id);
643: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);
644: hr_utility.trace('p_effective_date='||p_effective_date);

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

637: ln_count NUMBER;
638:
639: BEGIN
640: hr_utility.trace('Entering check_sa_emp_personal_payment');
641: hr_utility.trace('p_assignment_id='||p_assignment_id);
642: hr_utility.trace('p_payroll_id='||p_payroll_id);
643: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);
644: hr_utility.trace('p_effective_date='||p_effective_date);
645: hr_utility.trace('p_time_period_id='||p_time_period_id);

Line 642: hr_utility.trace('p_payroll_id='||p_payroll_id);

638:
639: BEGIN
640: hr_utility.trace('Entering check_sa_emp_personal_payment');
641: hr_utility.trace('p_assignment_id='||p_assignment_id);
642: hr_utility.trace('p_payroll_id='||p_payroll_id);
643: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);
644: hr_utility.trace('p_effective_date='||p_effective_date);
645: hr_utility.trace('p_time_period_id='||p_time_period_id);
646:

Line 643: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);

639: BEGIN
640: hr_utility.trace('Entering check_sa_emp_personal_payment');
641: hr_utility.trace('p_assignment_id='||p_assignment_id);
642: hr_utility.trace('p_payroll_id='||p_payroll_id);
643: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);
644: hr_utility.trace('p_effective_date='||p_effective_date);
645: hr_utility.trace('p_time_period_id='||p_time_period_id);
646:
647: lv_return_flag := 'Y';

Line 644: hr_utility.trace('p_effective_date='||p_effective_date);

640: hr_utility.trace('Entering check_sa_emp_personal_payment');
641: hr_utility.trace('p_assignment_id='||p_assignment_id);
642: hr_utility.trace('p_payroll_id='||p_payroll_id);
643: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);
644: hr_utility.trace('p_effective_date='||p_effective_date);
645: hr_utility.trace('p_time_period_id='||p_time_period_id);
646:
647: lv_return_flag := 'Y';
648:

Line 645: hr_utility.trace('p_time_period_id='||p_time_period_id);

641: hr_utility.trace('p_assignment_id='||p_assignment_id);
642: hr_utility.trace('p_payroll_id='||p_payroll_id);
643: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);
644: hr_utility.trace('p_effective_date='||p_effective_date);
645: hr_utility.trace('p_time_period_id='||p_time_period_id);
646:
647: lv_return_flag := 'Y';
648:
649: ln_time_period_id := p_time_period_id;

Line 661: hr_utility.trace('ln_time_period_id='||ln_time_period_id);

657: end if;
658: close c_get_date_earned;
659: end if;
660:
661: hr_utility.trace('ln_time_period_id='||ln_time_period_id);
662: open c_view_offset(ln_time_period_id);
663: fetch c_view_offset into ld_view_payslip_offset_date;
664: close c_view_offset;
665: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));

Line 665: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));

661: hr_utility.trace('ln_time_period_id='||ln_time_period_id);
662: open c_view_offset(ln_time_period_id);
663: fetch c_view_offset into ld_view_payslip_offset_date;
664: close c_view_offset;
665: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
666: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
667: hr_utility.trace('sysdate='||trunc(sysdate));
668:
669: /* check if the Payslip view date is populated. If it is, check the value

Line 666: hr_utility.trace('p_effective_date='||trunc(p_effective_date));

662: open c_view_offset(ln_time_period_id);
663: fetch c_view_offset into ld_view_payslip_offset_date;
664: close c_view_offset;
665: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
666: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
667: hr_utility.trace('sysdate='||trunc(sysdate));
668:
669: /* check if the Payslip view date is populated. If it is, check the value
670: and make sure it is > sysdate otherwise don't show payslip */

Line 667: hr_utility.trace('sysdate='||trunc(sysdate));

663: fetch c_view_offset into ld_view_payslip_offset_date;
664: close c_view_offset;
665: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
666: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
667: hr_utility.trace('sysdate='||trunc(sysdate));
668:
669: /* check if the Payslip view date is populated. If it is, check the value
670: and make sure it is > sysdate otherwise don't show payslip */
671: if ld_view_payslip_offset_date is not null and

Line 673: hr_utility.trace('View offset return N');

669: /* check if the Payslip view date is populated. If it is, check the value
670: and make sure it is > sysdate otherwise don't show payslip */
671: if ld_view_payslip_offset_date is not null and
672: trunc(ld_view_payslip_offset_date) > trunc(sysdate) then
673: hr_utility.trace('View offset return N');
674: return('N');
675: end if;
676:
677: ln_count := 0;

Line 686: hr_utility.trace('lv_return_flag='||lv_return_flag);

682: then return('N');
683: end if;
684: close c_get_archived;
685:
686: hr_utility.trace('lv_return_flag='||lv_return_flag);
687: hr_utility.trace('Leaving check_sa_emp_personal_payment');
688:
689: return lv_return_flag;
690:

Line 687: hr_utility.trace('Leaving check_sa_emp_personal_payment');

683: end if;
684: close c_get_archived;
685:
686: hr_utility.trace('lv_return_flag='||lv_return_flag);
687: hr_utility.trace('Leaving check_sa_emp_personal_payment');
688:
689: return lv_return_flag;
690:
691: END check_sa_emp_personal_payment;

Line 746: hr_utility.trace('Entering check_ie_emp_personal_payment');

742: ln_time_period_id NUMBER;
743: ln_count NUMBER;
744:
745: BEGIN
746: hr_utility.trace('Entering check_ie_emp_personal_payment');
747: hr_utility.trace('p_assignment_id='||p_assignment_id);
748: hr_utility.trace('p_payroll_id='||p_payroll_id);
749: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);
750: hr_utility.trace('p_effective_date='||p_effective_date);

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

743: ln_count NUMBER;
744:
745: BEGIN
746: hr_utility.trace('Entering check_ie_emp_personal_payment');
747: hr_utility.trace('p_assignment_id='||p_assignment_id);
748: hr_utility.trace('p_payroll_id='||p_payroll_id);
749: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);
750: hr_utility.trace('p_effective_date='||p_effective_date);
751: hr_utility.trace('p_time_period_id='||p_time_period_id);

Line 748: hr_utility.trace('p_payroll_id='||p_payroll_id);

744:
745: BEGIN
746: hr_utility.trace('Entering check_ie_emp_personal_payment');
747: hr_utility.trace('p_assignment_id='||p_assignment_id);
748: hr_utility.trace('p_payroll_id='||p_payroll_id);
749: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);
750: hr_utility.trace('p_effective_date='||p_effective_date);
751: hr_utility.trace('p_time_period_id='||p_time_period_id);
752:

Line 749: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);

745: BEGIN
746: hr_utility.trace('Entering check_ie_emp_personal_payment');
747: hr_utility.trace('p_assignment_id='||p_assignment_id);
748: hr_utility.trace('p_payroll_id='||p_payroll_id);
749: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);
750: hr_utility.trace('p_effective_date='||p_effective_date);
751: hr_utility.trace('p_time_period_id='||p_time_period_id);
752:
753: lv_return_flag := 'Y';

Line 750: hr_utility.trace('p_effective_date='||p_effective_date);

746: hr_utility.trace('Entering check_ie_emp_personal_payment');
747: hr_utility.trace('p_assignment_id='||p_assignment_id);
748: hr_utility.trace('p_payroll_id='||p_payroll_id);
749: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);
750: hr_utility.trace('p_effective_date='||p_effective_date);
751: hr_utility.trace('p_time_period_id='||p_time_period_id);
752:
753: lv_return_flag := 'Y';
754:

Line 751: hr_utility.trace('p_time_period_id='||p_time_period_id);

747: hr_utility.trace('p_assignment_id='||p_assignment_id);
748: hr_utility.trace('p_payroll_id='||p_payroll_id);
749: hr_utility.trace('p_assignment_action_id='||p_assignment_action_id);
750: hr_utility.trace('p_effective_date='||p_effective_date);
751: hr_utility.trace('p_time_period_id='||p_time_period_id);
752:
753: lv_return_flag := 'Y';
754:
755: ln_time_period_id := p_time_period_id;

Line 767: hr_utility.trace('ln_time_period_id='||ln_time_period_id);

763: end if;
764: close c_get_date_earned;
765: end if;
766:
767: hr_utility.trace('ln_time_period_id='||ln_time_period_id);
768: open c_view_offset(ln_time_period_id);
769: fetch c_view_offset into ld_view_payslip_offset_date;
770: close c_view_offset;
771: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));

Line 771: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));

767: hr_utility.trace('ln_time_period_id='||ln_time_period_id);
768: open c_view_offset(ln_time_period_id);
769: fetch c_view_offset into ld_view_payslip_offset_date;
770: close c_view_offset;
771: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
772: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
773: hr_utility.trace('sysdate='||trunc(sysdate));
774:
775: /* check if the Payslip view date is populated. If it is, check the value

Line 772: hr_utility.trace('p_effective_date='||trunc(p_effective_date));

768: open c_view_offset(ln_time_period_id);
769: fetch c_view_offset into ld_view_payslip_offset_date;
770: close c_view_offset;
771: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
772: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
773: hr_utility.trace('sysdate='||trunc(sysdate));
774:
775: /* check if the Payslip view date is populated. If it is, check the value
776: and make sure it is > sysdate otherwise don't show payslip */

Line 773: hr_utility.trace('sysdate='||trunc(sysdate));

769: fetch c_view_offset into ld_view_payslip_offset_date;
770: close c_view_offset;
771: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
772: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
773: hr_utility.trace('sysdate='||trunc(sysdate));
774:
775: /* check if the Payslip view date is populated. If it is, check the value
776: and make sure it is > sysdate otherwise don't show payslip */
777: if ld_view_payslip_offset_date is not null and

Line 779: hr_utility.trace('View offset return N');

775: /* check if the Payslip view date is populated. If it is, check the value
776: and make sure it is > sysdate otherwise don't show payslip */
777: if ld_view_payslip_offset_date is not null and
778: trunc(ld_view_payslip_offset_date) > trunc(sysdate) then
779: hr_utility.trace('View offset return N');
780: return('N');
781: end if;
782:
783: ln_count := 0;

Line 792: hr_utility.trace('lv_return_flag='||lv_return_flag);

788: then return('N');
789: end if;
790: close c_get_archived;
791:
792: hr_utility.trace('lv_return_flag='||lv_return_flag);
793: hr_utility.trace('Leaving check_ie_emp_personal_payment');
794:
795: return lv_return_flag;
796:

Line 793: hr_utility.trace('Leaving check_ie_emp_personal_payment');

789: end if;
790: close c_get_archived;
791:
792: hr_utility.trace('lv_return_flag='||lv_return_flag);
793: hr_utility.trace('Leaving check_ie_emp_personal_payment');
794:
795: return lv_return_flag;
796:
797: END check_ie_emp_personal_payment;

Line 1021: hr_utility.trace('Entering check_emp_personal_payment');

1017: AND ORG_INFORMATION1 = 'PAYSLIP';
1018:
1019: BEGIN
1020:
1021: hr_utility.trace('Entering check_emp_personal_payment');
1022: hr_utility.trace('p_effective_date='||p_effective_date);
1023: hr_utility.trace('p_time_period_id='||p_time_period_id);
1024:
1025: -- BEGIN For bug 8643214

Line 1022: hr_utility.trace('p_effective_date='||p_effective_date);

1018:
1019: BEGIN
1020:
1021: hr_utility.trace('Entering check_emp_personal_payment');
1022: hr_utility.trace('p_effective_date='||p_effective_date);
1023: hr_utility.trace('p_time_period_id='||p_time_period_id);
1024:
1025: -- BEGIN For bug 8643214
1026: open c_get_business_group_id(p_payroll_id);

Line 1023: hr_utility.trace('p_time_period_id='||p_time_period_id);

1019: BEGIN
1020:
1021: hr_utility.trace('Entering check_emp_personal_payment');
1022: hr_utility.trace('p_effective_date='||p_effective_date);
1023: hr_utility.trace('p_time_period_id='||p_time_period_id);
1024:
1025: -- BEGIN For bug 8643214
1026: open c_get_business_group_id(p_payroll_id);
1027: fetch c_get_business_group_id into ln_business_group_id;

Line 1030: hr_utility.trace('ln_business_group_id='||ln_business_group_id);

1026: open c_get_business_group_id(p_payroll_id);
1027: fetch c_get_business_group_id into ln_business_group_id;
1028: close c_get_business_group_id;
1029:
1030: hr_utility.trace('ln_business_group_id='||ln_business_group_id);
1031:
1032: ln_localization_code := get_legislation_code(ln_business_group_id);
1033:
1034: hr_utility.trace('ln_localization_code='||ln_localization_code);

Line 1034: hr_utility.trace('ln_localization_code='||ln_localization_code);

1030: hr_utility.trace('ln_business_group_id='||ln_business_group_id);
1031:
1032: ln_localization_code := get_legislation_code(ln_business_group_id);
1033:
1034: hr_utility.trace('ln_localization_code='||ln_localization_code);
1035:
1036: -- END For bug 8643214
1037:
1038: lv_return_flag := 'Y';

Line 1055: hr_utility.trace('c_purge_run%found');

1051: -- Commented for bug 8643214
1052: /*open c_get_localization(p_assignment_id);
1053: fetch c_get_localization into ln_localization_code; */
1054:
1055: hr_utility.trace('c_purge_run%found');
1056:
1057: if (ln_localization_code = 'GB') then
1058: lv_gb_return_flag :=
1059: check_gb_emp_personal_payment(

Line 1067: hr_utility.trace('lv_gb_return_flag='||lv_gb_return_flag);

1063: ,p_assignment_action_id
1064: ,p_effective_date
1065: );
1066: if (lv_gb_return_flag = 'Y') then
1067: hr_utility.trace('lv_gb_return_flag='||lv_gb_return_flag);
1068: return('Y');
1069: else
1070: hr_utility.trace('lv_gb_return_flag='||lv_gb_return_flag);
1071: return('N');

Line 1070: hr_utility.trace('lv_gb_return_flag='||lv_gb_return_flag);

1066: if (lv_gb_return_flag = 'Y') then
1067: hr_utility.trace('lv_gb_return_flag='||lv_gb_return_flag);
1068: return('Y');
1069: else
1070: hr_utility.trace('lv_gb_return_flag='||lv_gb_return_flag);
1071: return('N');
1072: end if;
1073: end if;
1074:

Line 1086: hr_utility.trace('lv_sa_return_flag='||lv_sa_return_flag);

1082: ,p_assignment_action_id
1083: ,p_effective_date
1084: );
1085: if (lv_sa_return_flag = 'Y') then
1086: hr_utility.trace('lv_sa_return_flag='||lv_sa_return_flag);
1087: return('Y');
1088: else
1089: hr_utility.trace('lv_sa_return_flag='||lv_sa_return_flag);
1090: return('N');

Line 1089: hr_utility.trace('lv_sa_return_flag='||lv_sa_return_flag);

1085: if (lv_sa_return_flag = 'Y') then
1086: hr_utility.trace('lv_sa_return_flag='||lv_sa_return_flag);
1087: return('Y');
1088: else
1089: hr_utility.trace('lv_sa_return_flag='||lv_sa_return_flag);
1090: return('N');
1091: end if;
1092: end if;
1093: --End modifications for the bug# 7648285

Line 1106: hr_utility.trace('lv_ie_return_flag='||lv_ie_return_flag);

1102: ,p_assignment_action_id
1103: ,p_effective_date
1104: );
1105: if (lv_ie_return_flag = 'Y') then
1106: hr_utility.trace('lv_ie_return_flag='||lv_ie_return_flag);
1107: return('Y');
1108: else
1109: hr_utility.trace('lv_ie_return_flag='||lv_ie_return_flag);
1110: return('N');

Line 1109: hr_utility.trace('lv_ie_return_flag='||lv_ie_return_flag);

1105: if (lv_ie_return_flag = 'Y') then
1106: hr_utility.trace('lv_ie_return_flag='||lv_ie_return_flag);
1107: return('Y');
1108: else
1109: hr_utility.trace('lv_ie_return_flag='||lv_ie_return_flag);
1110: return('N');
1111: end if;
1112: end if;
1113: --End modifications for the bug# 8522324

Line 1137: hr_utility.trace('ln_time_period_id='||ln_time_period_id);

1133: end if;
1134: close c_get_date_earned;
1135: end if;
1136:
1137: hr_utility.trace('ln_time_period_id='||ln_time_period_id);
1138: open c_view_offset(ln_time_period_id);
1139: FETCH c_view_offset INTO ld_view_payslip_offset_date, ld_reg_payment_date;
1140: close c_view_offset;
1141: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));

Line 1141: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));

1137: hr_utility.trace('ln_time_period_id='||ln_time_period_id);
1138: open c_view_offset(ln_time_period_id);
1139: FETCH c_view_offset INTO ld_view_payslip_offset_date, ld_reg_payment_date;
1140: close c_view_offset;
1141: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
1142: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
1143: hr_utility.trace('sysdate='||trunc(sysdate));
1144:
1145:

Line 1142: hr_utility.trace('p_effective_date='||trunc(p_effective_date));

1138: open c_view_offset(ln_time_period_id);
1139: FETCH c_view_offset INTO ld_view_payslip_offset_date, ld_reg_payment_date;
1140: close c_view_offset;
1141: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
1142: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
1143: hr_utility.trace('sysdate='||trunc(sysdate));
1144:
1145:
1146: --Commented out for bug 8550075. This has been handled below

Line 1143: hr_utility.trace('sysdate='||trunc(sysdate));

1139: FETCH c_view_offset INTO ld_view_payslip_offset_date, ld_reg_payment_date;
1140: close c_view_offset;
1141: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
1142: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
1143: hr_utility.trace('sysdate='||trunc(sysdate));
1144:
1145:
1146: --Commented out for bug 8550075. This has been handled below
1147: /* check if the Payslip view date is populated. If it is, check the value

Line 1151: hr_utility.trace('View offset return N');

1147: /* check if the Payslip view date is populated. If it is, check the value
1148: and make sure it is > sysdate otherwise don't show payslip */
1149: /*if ld_view_payslip_offset_date is not null and
1150: trunc(ld_view_payslip_offset_date) > trunc(sysdate) then
1151: hr_utility.trace('View offset return N');
1152: return('N');
1153: end if;*/
1154:
1155: --Starting Fix for bug 8550075

Line 1178: hr_utility.TRACE('g_legislation_code=' || g_legislation_code);

1174: if g_legislation_code is null then
1175: g_legislation_code := get_legislation_code(ln_bg_id);
1176: end if;
1177:
1178: hr_utility.TRACE('g_legislation_code=' || g_legislation_code);
1179: hr_utility.TRACE('is_dynamic_view_date=' || is_dynamic_view_date);
1180:
1181: --If Date_paid preference is set and legislation_code is 'US'
1182: IF is_dynamic_view_date = 'Y' AND ld_date_paid IS NOT NULL and g_legislation_code = 'US' THEN

Line 1179: hr_utility.TRACE('is_dynamic_view_date=' || is_dynamic_view_date);

1175: g_legislation_code := get_legislation_code(ln_bg_id);
1176: end if;
1177:
1178: hr_utility.TRACE('g_legislation_code=' || g_legislation_code);
1179: hr_utility.TRACE('is_dynamic_view_date=' || is_dynamic_view_date);
1180:
1181: --If Date_paid preference is set and legislation_code is 'US'
1182: IF is_dynamic_view_date = 'Y' AND ld_date_paid IS NOT NULL and g_legislation_code = 'US' THEN
1183:

Line 1186: hr_utility.TRACE('ln_offset_value=' || ln_offset_value);

1182: IF is_dynamic_view_date = 'Y' AND ld_date_paid IS NOT NULL and g_legislation_code = 'US' THEN
1183:
1184: ln_offset_value := trunc(ld_view_payslip_offset_date - ld_reg_payment_date);
1185:
1186: hr_utility.TRACE('ln_offset_value=' || ln_offset_value);
1187: hr_utility.TRACE('ld_view_payslip_offset_date=' || ld_view_payslip_offset_date);
1188:
1189: ld_payslip_view_date := trunc(ld_date_paid) + ln_offset_value;
1190: hr_utility.TRACE('ld_payslip_view_date=' || ld_payslip_view_date);

Line 1187: hr_utility.TRACE('ld_view_payslip_offset_date=' || ld_view_payslip_offset_date);

1183:
1184: ln_offset_value := trunc(ld_view_payslip_offset_date - ld_reg_payment_date);
1185:
1186: hr_utility.TRACE('ln_offset_value=' || ln_offset_value);
1187: hr_utility.TRACE('ld_view_payslip_offset_date=' || ld_view_payslip_offset_date);
1188:
1189: ld_payslip_view_date := trunc(ld_date_paid) + ln_offset_value;
1190: hr_utility.TRACE('ld_payslip_view_date=' || ld_payslip_view_date);
1191:

Line 1190: hr_utility.TRACE('ld_payslip_view_date=' || ld_payslip_view_date);

1186: hr_utility.TRACE('ln_offset_value=' || ln_offset_value);
1187: hr_utility.TRACE('ld_view_payslip_offset_date=' || ld_view_payslip_offset_date);
1188:
1189: ld_payslip_view_date := trunc(ld_date_paid) + ln_offset_value;
1190: hr_utility.TRACE('ld_payslip_view_date=' || ld_payslip_view_date);
1191:
1192: IF trunc(ld_payslip_view_date) > trunc(SYSDATE) THEN
1193: hr_utility.TRACE('View offset return N');
1194: RETURN('N');

Line 1193: hr_utility.TRACE('View offset return N');

1189: ld_payslip_view_date := trunc(ld_date_paid) + ln_offset_value;
1190: hr_utility.TRACE('ld_payslip_view_date=' || ld_payslip_view_date);
1191:
1192: IF trunc(ld_payslip_view_date) > trunc(SYSDATE) THEN
1193: hr_utility.TRACE('View offset return N');
1194: RETURN('N');
1195: END IF;
1196: --Default Behaviour
1197: ELSE

Line 1198: hr_utility.TRACE('Offset Criteria is not Date_paid ');

1194: RETURN('N');
1195: END IF;
1196: --Default Behaviour
1197: ELSE
1198: hr_utility.TRACE('Offset Criteria is not Date_paid ');
1199: IF trunc(ld_view_payslip_offset_date) > trunc(SYSDATE) THEN
1200: hr_utility.TRACE('View offset return N');
1201: RETURN('N');
1202: END IF;

Line 1200: hr_utility.TRACE('View offset return N');

1196: --Default Behaviour
1197: ELSE
1198: hr_utility.TRACE('Offset Criteria is not Date_paid ');
1199: IF trunc(ld_view_payslip_offset_date) > trunc(SYSDATE) THEN
1200: hr_utility.TRACE('View offset return N');
1201: RETURN('N');
1202: END IF;
1203: END IF;
1204:

Line 1244: hr_utility.trace('Inside new get_localization ');

1240:
1241: /* Modifications for the bug 8303577 starts */
1242: -- Commented for bug 8643214
1243: /* open c_get_localization(p_assignment_id);
1244: hr_utility.trace('Inside new get_localization ');
1245: fetch c_get_localization into ln_localization_code; */
1246: if (ln_localization_code = 'GB') then
1247: open c_get_completion_status(p_assignment_action_id);
1248: lv_completion_status := 0;

Line 1250: hr_utility.trace('Inside c_get_completion_status ');

1246: if (ln_localization_code = 'GB') then
1247: open c_get_completion_status(p_assignment_action_id);
1248: lv_completion_status := 0;
1249: fetch c_get_completion_status into lv_completion_status;
1250: hr_utility.trace('Inside c_get_completion_status ');
1251: hr_utility.trace('lv_completion_status '||lv_completion_status);
1252: if (lv_completion_status = 0) then
1253: hr_utility.trace('Inside c_get_completion_status if condition');
1254: return('N');

Line 1251: hr_utility.trace('lv_completion_status '||lv_completion_status);

1247: open c_get_completion_status(p_assignment_action_id);
1248: lv_completion_status := 0;
1249: fetch c_get_completion_status into lv_completion_status;
1250: hr_utility.trace('Inside c_get_completion_status ');
1251: hr_utility.trace('lv_completion_status '||lv_completion_status);
1252: if (lv_completion_status = 0) then
1253: hr_utility.trace('Inside c_get_completion_status if condition');
1254: return('N');
1255: end if;

Line 1253: hr_utility.trace('Inside c_get_completion_status if condition');

1249: fetch c_get_completion_status into lv_completion_status;
1250: hr_utility.trace('Inside c_get_completion_status ');
1251: hr_utility.trace('lv_completion_status '||lv_completion_status);
1252: if (lv_completion_status = 0) then
1253: hr_utility.trace('Inside c_get_completion_status if condition');
1254: return('N');
1255: end if;
1256: close c_get_completion_status;
1257: end if;

Line 1262: hr_utility.trace('lv_return_flag='||lv_return_flag);

1258: -- Commented for bug 8643214
1259: -- close c_get_localization;
1260: /* Modifications for the bug 8303577 ends */
1261:
1262: hr_utility.trace('lv_return_flag='||lv_return_flag);
1263: hr_utility.trace('Leaving check_emp_personal_payment');
1264:
1265: return lv_return_flag;
1266:

Line 1263: hr_utility.trace('Leaving check_emp_personal_payment');

1259: -- close c_get_localization;
1260: /* Modifications for the bug 8303577 ends */
1261:
1262: hr_utility.trace('lv_return_flag='||lv_return_flag);
1263: hr_utility.trace('Leaving check_emp_personal_payment');
1264:
1265: return lv_return_flag;
1266:
1267: END check_emp_personal_payment;

Line 1320: hr_utility.trace('Entering check_emp_personal_payment without time period');

1316: ln_time_period_id NUMBER;
1317:
1318: BEGIN
1319:
1320: hr_utility.trace('Entering check_emp_personal_payment without time period');
1321: open c_get_date_earned(p_assignment_action_id);
1322: fetch c_get_date_earned into ld_earned_date;
1323: if c_get_date_earned%found then
1324: open c_time_period(p_payroll_id, ld_earned_date);

Line 1330: hr_utility.trace('ln_time_period_id='||ln_time_period_id);

1326: close c_time_period;
1327: end if;
1328: close c_get_date_earned;
1329:
1330: hr_utility.trace('ln_time_period_id='||ln_time_period_id);
1331: return(check_emp_personal_payment(
1332: p_assignment_id => p_assignment_id
1333: ,p_payroll_id => p_payroll_id
1334: ,p_time_period_id => ln_time_period_id

Line 1918: hr_utility.set_location(l_mesg,5);

1914: l_time_period_id number; --Bug# 14682114
1915:
1916: BEGIN
1917: l_mesg := 'pay_us_employee_payslip_web.get_doc_eit';
1918: hr_utility.set_location(l_mesg,5);
1919: l_location_cache := 'NOT FOUND';
1920: l_org_cache := 'NOT FOUND';
1921: l_bg_cache := 'NOT FOUND';
1922: l_rowCount := pay_us_employee_payslip_web.eit_tab.count;

Line 1925: hr_utility.set_location(l_mesg, 10);

1921: l_bg_cache := 'NOT FOUND';
1922: l_rowCount := pay_us_employee_payslip_web.eit_tab.count;
1923:
1924: IF upper(p_level) = 'ASSIGNMENT' THEN
1925: hr_utility.set_location(l_mesg, 10);
1926:
1927: /* --RLN Check actual_termination_date 11730301 --- */
1928: /*--13084713 Added Max for the termination date and Removed eff. date from where clause */
1929: Select nvl(max(pps.actual_termination_date), to_date('12/31/4712','mm/dd/yyyy'))

Line 2028: hr_utility.set_location(l_mesg,20);

2024:
2025: END IF; /* p_level = assignment */
2026:
2027: IF upper(p_level) = 'PERSON' THEN
2028: hr_utility.set_location(l_mesg,20);
2029: OPEN get_person_eit(p_id);
2030: FETCH get_person_eit INTO l_online, l_print;
2031:
2032: IF get_person_eit%FOUND THEN

Line 2047: hr_utility.set_location(l_mesg,30);

2043: RETURN l_value;
2044: END IF;
2045:
2046: IF upper(p_level) = 'LOCATION' THEN
2047: hr_utility.set_location(l_mesg,30);
2048: hr_utility.trace('Before LOOP l_location_cache = '||l_location_cache);
2049: IF (l_rowCount > 0) THEN
2050: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
2051: pay_us_employee_payslip_web.eit_tab.last

Line 2048: hr_utility.trace('Before LOOP l_location_cache = '||l_location_cache);

2044: END IF;
2045:
2046: IF upper(p_level) = 'LOCATION' THEN
2047: hr_utility.set_location(l_mesg,30);
2048: hr_utility.trace('Before LOOP l_location_cache = '||l_location_cache);
2049: IF (l_rowCount > 0) THEN
2050: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
2051: pay_us_employee_payslip_web.eit_tab.last
2052: LOOP

Line 2066: hr_utility.trace('AFter LOOP l_location_cache = '||l_location_cache);

2062: END IF;
2063: END IF;
2064: END LOOP;
2065: END IF; -- l_rowCount > 0
2066: hr_utility.trace('AFter LOOP l_location_cache = '||l_location_cache);
2067:
2068: IF l_location_cache = 'NOT FOUND' THEN
2069: hr_utility.set_location(l_mesg,40);
2070: ---- Location Level is not cached so find it ----

Line 2069: hr_utility.set_location(l_mesg,40);

2065: END IF; -- l_rowCount > 0
2066: hr_utility.trace('AFter LOOP l_location_cache = '||l_location_cache);
2067:
2068: IF l_location_cache = 'NOT FOUND' THEN
2069: hr_utility.set_location(l_mesg,40);
2070: ---- Location Level is not cached so find it ----
2071:
2072: OPEN get_loc_eit(p_id);
2073: FETCH get_loc_eit INTO l_online, l_print;

Line 2074: hr_utility.trace('l_online = '||l_online);

2070: ---- Location Level is not cached so find it ----
2071:
2072: OPEN get_loc_eit(p_id);
2073: FETCH get_loc_eit INTO l_online, l_print;
2074: hr_utility.trace('l_online = '||l_online);
2075: hr_utility.trace('l_print = '||l_print);
2076: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;
2077: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
2078: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Location';

Line 2075: hr_utility.trace('l_print = '||l_print);

2071:
2072: OPEN get_loc_eit(p_id);
2073: FETCH get_loc_eit INTO l_online, l_print;
2074: hr_utility.trace('l_online = '||l_online);
2075: hr_utility.trace('l_print = '||l_print);
2076: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;
2077: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
2078: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Location';
2079:

Line 2088: hr_utility.trace('eit_tab(l_count).t_online = '||

2084: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
2085: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
2086: END IF;
2087:
2088: hr_utility.trace('eit_tab(l_count).t_online = '||
2089: pay_us_employee_payslip_web.eit_tab(l_count).t_online);
2090: hr_utility.trace('eit_tab(l_count).t_print = '||
2091: pay_us_employee_payslip_web.eit_tab(l_count).t_print);
2092: IF p_mode = 'ONLINE' THEN

Line 2090: hr_utility.trace('eit_tab(l_count).t_print = '||

2086: END IF;
2087:
2088: hr_utility.trace('eit_tab(l_count).t_online = '||
2089: pay_us_employee_payslip_web.eit_tab(l_count).t_online);
2090: hr_utility.trace('eit_tab(l_count).t_print = '||
2091: pay_us_employee_payslip_web.eit_tab(l_count).t_print);
2092: IF p_mode = 'ONLINE' THEN
2093: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;
2094: ELSIF p_mode = 'PRINT' THEN

Line 2103: hr_utility.set_location(l_mesg,50);

2099: return l_value;
2100: END IF; -- if p_level = Location
2101:
2102: IF upper(p_level) = 'ORGANIZATION' THEN
2103: hr_utility.set_location(l_mesg,50);
2104: IF (l_rowCount > 0) THEN
2105: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
2106: pay_us_employee_payslip_web.eit_tab.last
2107: LOOP

Line 2124: hr_utility.trace('Org cache NOT FOUND');

2120:
2121: ---- Organization Level is not cached so find it ----
2122:
2123: IF l_org_cache = 'NOT FOUND' THEN
2124: hr_utility.trace('Org cache NOT FOUND');
2125: hr_utility.set_location(l_mesg,60);
2126: OPEN get_org_eit(p_id);
2127: FETCH get_org_eit INTO l_online, l_print;
2128: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;

Line 2125: hr_utility.set_location(l_mesg,60);

2121: ---- Organization Level is not cached so find it ----
2122:
2123: IF l_org_cache = 'NOT FOUND' THEN
2124: hr_utility.trace('Org cache NOT FOUND');
2125: hr_utility.set_location(l_mesg,60);
2126: OPEN get_org_eit(p_id);
2127: FETCH get_org_eit INTO l_online, l_print;
2128: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;
2129: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;

Line 2153: hr_utility.set_location(l_mesg,70);

2149:
2150: --- So look for Cached Business Group EIT ---
2151:
2152: IF upper(p_level) = 'BUSINESS GROUP' THEN
2153: hr_utility.set_location(l_mesg,70);
2154: IF (l_rowCount > 0) THEN
2155: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
2156: pay_us_employee_payslip_web.eit_tab.last LOOP
2157: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND

Line 2173: hr_utility.set_location(l_mesg,80);

2169:
2170: --- business Group Level EIT not cached ----
2171:
2172: IF l_bg_cache = 'NOT FOUND' THEN
2173: hr_utility.set_location(l_mesg,80);
2174:
2175: OPEN get_bg_eit(p_id);
2176: FETCH get_bg_eit INTO l_online, l_print;
2177: l_count := pay_us_employee_payslip_web.eit_tab.count + 1;

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

2255: lv_state_code := substr(p_jurisdiction_code,1,2);
2256: lv_county_code := substr(p_jurisdiction_code,4,3);
2257: lv_city_code := substr(p_jurisdiction_code,8,4);
2258: lv_jurisdiction_name := null;
2259: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2260:
2261: if p_jurisdiction_code like '__-000-0000' then
2262: open c_get_state(lv_state_code);
2263: fetch c_get_state into lv_jurisdiction_name;

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

2278: lv_jurisdiction_name
2279: := pay_us_employee_payslip_web.get_school_dsts_name(p_jurisdiction_code);
2280: end if;
2281:
2282: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2283: return (lv_jurisdiction_name);
2284: END get_jurisdiction_name;
2285:
2286:

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

2470: lv_county_code := substr(p_jurisdiction_code,4,3);
2471: lv_city_code := substr(p_jurisdiction_code,8,4);
2472: lv_jurisdiction_name := null;
2473:
2474: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2475: if p_jurisdiction_code like '__-000-0000' then
2476: lv_jurisdiction_name := pay_us_employee_payslip_web.get_jurisdiction_name
2477: (lv_state_code || '-000-0000');
2478:

Line 2496: hr_utility.set_location('p_jurisdiction_code -> '||p_jurisdiction_code, 30);

2492: (lv_state_code || '-' || lv_county_code || '-0000');
2493: lv_city_name := pay_us_employee_payslip_web.get_jurisdiction_name
2494: (p_jurisdiction_code);
2495:
2496: hr_utility.set_location('p_jurisdiction_code -> '||p_jurisdiction_code, 30);
2497: hr_utility.set_location('lv_state_abbrev -> '|| lv_state_abbrev, 30);
2498: hr_utility.set_location('lv_county_name -> '|| lv_county_name, 30);
2499: hr_utility.set_location('lv_city_name -> '|| lv_city_name, 30);
2500:

Line 2497: hr_utility.set_location('lv_state_abbrev -> '|| lv_state_abbrev, 30);

2493: lv_city_name := pay_us_employee_payslip_web.get_jurisdiction_name
2494: (p_jurisdiction_code);
2495:
2496: hr_utility.set_location('p_jurisdiction_code -> '||p_jurisdiction_code, 30);
2497: hr_utility.set_location('lv_state_abbrev -> '|| lv_state_abbrev, 30);
2498: hr_utility.set_location('lv_county_name -> '|| lv_county_name, 30);
2499: hr_utility.set_location('lv_city_name -> '|| lv_city_name, 30);
2500:
2501: lv_jurisdiction_name := lv_state_abbrev ||', '||

Line 2498: hr_utility.set_location('lv_county_name -> '|| lv_county_name, 30);

2494: (p_jurisdiction_code);
2495:
2496: hr_utility.set_location('p_jurisdiction_code -> '||p_jurisdiction_code, 30);
2497: hr_utility.set_location('lv_state_abbrev -> '|| lv_state_abbrev, 30);
2498: hr_utility.set_location('lv_county_name -> '|| lv_county_name, 30);
2499: hr_utility.set_location('lv_city_name -> '|| lv_city_name, 30);
2500:
2501: lv_jurisdiction_name := lv_state_abbrev ||', '||
2502: lv_county_name ||', '||

Line 2499: hr_utility.set_location('lv_city_name -> '|| lv_city_name, 30);

2495:
2496: hr_utility.set_location('p_jurisdiction_code -> '||p_jurisdiction_code, 30);
2497: hr_utility.set_location('lv_state_abbrev -> '|| lv_state_abbrev, 30);
2498: hr_utility.set_location('lv_county_name -> '|| lv_county_name, 30);
2499: hr_utility.set_location('lv_city_name -> '|| lv_city_name, 30);
2500:
2501: lv_jurisdiction_name := lv_state_abbrev ||', '||
2502: lv_county_name ||', '||
2503: lv_city_name;

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

2509: lv_jurisdiction_name := lv_state_abbrev || ', ' ||
2510: lv_school_dst;
2511:
2512: end if;
2513: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2514: return (lv_jurisdiction_name);
2515: END get_full_jurisdiction_name;
2516:
2517: -- This Function will be called from View Definition of

Line 2547: hr_utility.trace('Entering into pay_us_employee_payslip_web.get_netpaydistr_segment');

2543: lv_legislation_code VARCHAR2(100);
2544: lv_exists VARCHAR2(10);
2545:
2546: BEGIN
2547: hr_utility.trace('Entering into pay_us_employee_payslip_web.get_netpaydistr_segment');
2548: hr_utility.trace('p_business_grp_id := ' || p_business_grp_id);
2549: hr_utility.trace('p_org_pay_meth_id := ' || p_org_pay_meth_id);
2550:
2551: open cur_legislation(p_business_grp_id);

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

2544: lv_exists VARCHAR2(10);
2545:
2546: BEGIN
2547: hr_utility.trace('Entering into pay_us_employee_payslip_web.get_netpaydistr_segment');
2548: hr_utility.trace('p_business_grp_id := ' || p_business_grp_id);
2549: hr_utility.trace('p_org_pay_meth_id := ' || p_org_pay_meth_id);
2550:
2551: open cur_legislation(p_business_grp_id);
2552: fetch cur_legislation into lv_legislation_code;

Line 2549: hr_utility.trace('p_org_pay_meth_id := ' || p_org_pay_meth_id);

2545:
2546: BEGIN
2547: hr_utility.trace('Entering into pay_us_employee_payslip_web.get_netpaydistr_segment');
2548: hr_utility.trace('p_business_grp_id := ' || p_business_grp_id);
2549: hr_utility.trace('p_org_pay_meth_id := ' || p_org_pay_meth_id);
2550:
2551: open cur_legislation(p_business_grp_id);
2552: fetch cur_legislation into lv_legislation_code;
2553: close cur_legislation;

Line 2555: hr_utility.trace('lv_legislation_code := ' || lv_legislation_code);

2551: open cur_legislation(p_business_grp_id);
2552: fetch cur_legislation into lv_legislation_code;
2553: close cur_legislation;
2554:
2555: hr_utility.trace('lv_legislation_code := ' || lv_legislation_code);
2556:
2557: -- Legislation Check Should not be needed here and Added for Safer Side
2558: -- Can be removed if it can be confirmed that for All Localizations
2559: -- Payment category is 'CH' for Check / Cheque

Line 2573: hr_utility.trace('lv_exists := ' || lv_exists);

2569: ,p_org_pay_meth_id);
2570: FETCH cur_payment_typ INTO lv_exists;
2571: CLOSE cur_payment_typ;
2572:
2573: hr_utility.trace('lv_exists := ' || lv_exists);
2574:
2575: IF lv_exists = '1' THEN
2576: RETURN 'TRUE';
2577: ELSE

Line 2622: hr_utility.TRACE('Entering check_jp_emp_personal_payment procedure');

2618: AND ppa.action_type IN ( 'P' , 'U' );
2619: --
2620: BEGIN
2621: --
2622: hr_utility.TRACE('Entering check_jp_emp_personal_payment procedure');
2623:
2624: p_pay_ret_table := pay_payslip_list_table();
2625:
2626: IF p_first_call = 'Y' THEN

Line 2628: hr_utility.TRACE('check_jp_emp_personal_payment - First Call');

2624: p_pay_ret_table := pay_payslip_list_table();
2625:
2626: IF p_first_call = 'Y' THEN
2627:
2628: hr_utility.TRACE('check_jp_emp_personal_payment - First Call');
2629:
2630: numlistrows := numlistrows + 1;
2631:
2632: -- check if the cursor was closed. If there was an exception of sort,

Line 2643: hr_utility.TRACE('p_person_id ' || p_person_id);

2639: OPEN get_jp_choose_payslip(p_person_id, p_effective_date);
2640:
2641: END IF;
2642:
2643: hr_utility.TRACE('p_person_id ' || p_person_id);
2644: hr_utility.TRACE('p_effective_date ' || p_effective_date);
2645:
2646: LOOP
2647:

Line 2644: hr_utility.TRACE('p_effective_date ' || p_effective_date);

2640:
2641: END IF;
2642:
2643: hr_utility.TRACE('p_person_id ' || p_person_id);
2644: hr_utility.TRACE('p_effective_date ' || p_effective_date);
2645:
2646: LOOP
2647:
2648: FETCH get_jp_choose_payslip into action_context_id,

Line 2662: hr_utility.TRACE('v_effective_date ' || v_effective_date);

2658: END IF;
2659:
2660: p_last_fetch := 'N';
2661:
2662: hr_utility.TRACE('v_effective_date ' || v_effective_date);
2663: hr_utility.TRACE('payroll_id ' || payroll_id);
2664: hr_utility.TRACE('action_context_id ' || action_context_id);
2665: hr_utility.TRACE('assignment_id ' || assignment_id);
2666: hr_utility.TRACE('action_information2 ' || action_information2);

Line 2663: hr_utility.TRACE('payroll_id ' || payroll_id);

2659:
2660: p_last_fetch := 'N';
2661:
2662: hr_utility.TRACE('v_effective_date ' || v_effective_date);
2663: hr_utility.TRACE('payroll_id ' || payroll_id);
2664: hr_utility.TRACE('action_context_id ' || action_context_id);
2665: hr_utility.TRACE('assignment_id ' || assignment_id);
2666: hr_utility.TRACE('action_information2 ' || action_information2);
2667:

Line 2664: hr_utility.TRACE('action_context_id ' || action_context_id);

2660: p_last_fetch := 'N';
2661:
2662: hr_utility.TRACE('v_effective_date ' || v_effective_date);
2663: hr_utility.TRACE('payroll_id ' || payroll_id);
2664: hr_utility.TRACE('action_context_id ' || action_context_id);
2665: hr_utility.TRACE('assignment_id ' || assignment_id);
2666: hr_utility.TRACE('action_information2 ' || action_information2);
2667:
2668: FOR i IN get_locked_act_id(action_context_id) LOOP

Line 2665: hr_utility.TRACE('assignment_id ' || assignment_id);

2661:
2662: hr_utility.TRACE('v_effective_date ' || v_effective_date);
2663: hr_utility.TRACE('payroll_id ' || payroll_id);
2664: hr_utility.TRACE('action_context_id ' || action_context_id);
2665: hr_utility.TRACE('assignment_id ' || assignment_id);
2666: hr_utility.TRACE('action_information2 ' || action_information2);
2667:
2668: FOR i IN get_locked_act_id(action_context_id) LOOP
2669:

Line 2666: hr_utility.TRACE('action_information2 ' || action_information2);

2662: hr_utility.TRACE('v_effective_date ' || v_effective_date);
2663: hr_utility.TRACE('payroll_id ' || payroll_id);
2664: hr_utility.TRACE('action_context_id ' || action_context_id);
2665: hr_utility.TRACE('assignment_id ' || assignment_id);
2666: hr_utility.TRACE('action_information2 ' || action_information2);
2667:
2668: FOR i IN get_locked_act_id(action_context_id) LOOP
2669:
2670: hr_utility.TRACE('locked_action_id ' || i.locked_action_id);

Line 2670: hr_utility.TRACE('locked_action_id ' || i.locked_action_id);

2666: hr_utility.TRACE('action_information2 ' || action_information2);
2667:
2668: FOR i IN get_locked_act_id(action_context_id) LOOP
2669:
2670: hr_utility.TRACE('locked_action_id ' || i.locked_action_id);
2671:
2672: is_valid_payslip := check_emp_personal_payment(
2673: p_assignment_id => to_number(assignment_id)
2674: ,p_payroll_id => to_number(payroll_id)

Line 2680: hr_utility.TRACE('check_emp_personal_payment - Valid Payslip found for t_assignment_action_id ' || action_context_id);

2676: ,p_effective_date => v_effective_date
2677: );
2678: IF is_valid_payslip = 'Y' THEN
2679:
2680: hr_utility.TRACE('check_emp_personal_payment - Valid Payslip found for t_assignment_action_id ' || action_context_id);
2681: --if row_count > 1 then
2682: p_pay_ret_table.EXTEND(1);
2683:
2684: --insert the payslip in to the table to be returned.

Line 2732: hr_utility.TRACE('Entering check_emp_personal_payment Wrapper');

2728: v_effective_date date;
2729:
2730: BEGIN
2731:
2732: hr_utility.TRACE('Entering check_emp_personal_payment Wrapper');
2733:
2734: pay_ret_table := pay_payslip_list_table();
2735:
2736: IF g_legislation_code IS NULL THEN

Line 2753: hr_utility.TRACE('check_emp_personal_payment - First Call');

2749: -- the procedure check_jp_emp_personal_payment()
2750:
2751: ELSE
2752: IF p_first_call = 'Y' THEN
2753: hr_utility.TRACE('check_emp_personal_payment - First Call');
2754: numlistrows := numlistrows + 1;
2755: g_job_label := pay_us_employee_payslip_web.get_meaning_payslip_label(g_legislation_code || '', 'JOB');
2756: g_check_label := pay_us_employee_payslip_web.get_meaning_payslip_label(g_legislation_code || '', 'CHECK');
2757:

Line 2768: hr_utility.TRACE('p_person_id ' || p_person_id);

2764:
2765:
2766: END IF;
2767:
2768: hr_utility.TRACE('p_person_id ' || p_person_id);
2769: hr_utility.TRACE('p_effective_date ' || p_effective_date);
2770: hr_utility.TRACE('g_legislation_code ' || g_legislation_code);
2771:
2772: loop

Line 2769: hr_utility.TRACE('p_effective_date ' || p_effective_date);

2765:
2766: END IF;
2767:
2768: hr_utility.TRACE('p_person_id ' || p_person_id);
2769: hr_utility.TRACE('p_effective_date ' || p_effective_date);
2770: hr_utility.TRACE('g_legislation_code ' || g_legislation_code);
2771:
2772: loop
2773:

Line 2770: hr_utility.TRACE('g_legislation_code ' || g_legislation_code);

2766: END IF;
2767:
2768: hr_utility.TRACE('p_person_id ' || p_person_id);
2769: hr_utility.TRACE('p_effective_date ' || p_effective_date);
2770: hr_utility.TRACE('g_legislation_code ' || g_legislation_code);
2771:
2772: loop
2773:
2774: fetch get_choose_payslip into action_context_id,

Line 2791: hr_utility.TRACE('check_emp_personal_payment - Legislation Code is US');

2787: p_last_fetch := 'N';
2788:
2789: IF g_legislation_code = 'US' THEN
2790:
2791: hr_utility.TRACE('check_emp_personal_payment - Legislation Code is US');
2792: hr_utility.TRACE('v_effective_date ' || v_effective_date);
2793: hr_utility.TRACE('payroll_id ' || payroll_id);
2794: hr_utility.TRACE('time_period_id ' || time_period_id);
2795: hr_utility.TRACE('action_context_id ' || action_context_id);

Line 2792: hr_utility.TRACE('v_effective_date ' || v_effective_date);

2788:
2789: IF g_legislation_code = 'US' THEN
2790:
2791: hr_utility.TRACE('check_emp_personal_payment - Legislation Code is US');
2792: hr_utility.TRACE('v_effective_date ' || v_effective_date);
2793: hr_utility.TRACE('payroll_id ' || payroll_id);
2794: hr_utility.TRACE('time_period_id ' || time_period_id);
2795: hr_utility.TRACE('action_context_id ' || action_context_id);
2796: hr_utility.TRACE('assignment_id ' || assignment_id);

Line 2793: hr_utility.TRACE('payroll_id ' || payroll_id);

2789: IF g_legislation_code = 'US' THEN
2790:
2791: hr_utility.TRACE('check_emp_personal_payment - Legislation Code is US');
2792: hr_utility.TRACE('v_effective_date ' || v_effective_date);
2793: hr_utility.TRACE('payroll_id ' || payroll_id);
2794: hr_utility.TRACE('time_period_id ' || time_period_id);
2795: hr_utility.TRACE('action_context_id ' || action_context_id);
2796: hr_utility.TRACE('assignment_id ' || assignment_id);
2797: hr_utility.TRACE('action_information14 ' || action_information14);

Line 2794: hr_utility.TRACE('time_period_id ' || time_period_id);

2790:
2791: hr_utility.TRACE('check_emp_personal_payment - Legislation Code is US');
2792: hr_utility.TRACE('v_effective_date ' || v_effective_date);
2793: hr_utility.TRACE('payroll_id ' || payroll_id);
2794: hr_utility.TRACE('time_period_id ' || time_period_id);
2795: hr_utility.TRACE('action_context_id ' || action_context_id);
2796: hr_utility.TRACE('assignment_id ' || assignment_id);
2797: hr_utility.TRACE('action_information14 ' || action_information14);
2798: hr_utility.TRACE('check_count ' || check_count);

Line 2795: hr_utility.TRACE('action_context_id ' || action_context_id);

2791: hr_utility.TRACE('check_emp_personal_payment - Legislation Code is US');
2792: hr_utility.TRACE('v_effective_date ' || v_effective_date);
2793: hr_utility.TRACE('payroll_id ' || payroll_id);
2794: hr_utility.TRACE('time_period_id ' || time_period_id);
2795: hr_utility.TRACE('action_context_id ' || action_context_id);
2796: hr_utility.TRACE('assignment_id ' || assignment_id);
2797: hr_utility.TRACE('action_information14 ' || action_information14);
2798: hr_utility.TRACE('check_count ' || check_count);
2799:

Line 2796: hr_utility.TRACE('assignment_id ' || assignment_id);

2792: hr_utility.TRACE('v_effective_date ' || v_effective_date);
2793: hr_utility.TRACE('payroll_id ' || payroll_id);
2794: hr_utility.TRACE('time_period_id ' || time_period_id);
2795: hr_utility.TRACE('action_context_id ' || action_context_id);
2796: hr_utility.TRACE('assignment_id ' || assignment_id);
2797: hr_utility.TRACE('action_information14 ' || action_information14);
2798: hr_utility.TRACE('check_count ' || check_count);
2799:
2800: --Calling the US sepecific Validations

Line 2797: hr_utility.TRACE('action_information14 ' || action_information14);

2793: hr_utility.TRACE('payroll_id ' || payroll_id);
2794: hr_utility.TRACE('time_period_id ' || time_period_id);
2795: hr_utility.TRACE('action_context_id ' || action_context_id);
2796: hr_utility.TRACE('assignment_id ' || assignment_id);
2797: hr_utility.TRACE('action_information14 ' || action_information14);
2798: hr_utility.TRACE('check_count ' || check_count);
2799:
2800: --Calling the US sepecific Validations
2801: is_valid_payslip := check_us_emp_personal_payment(

Line 2798: hr_utility.TRACE('check_count ' || check_count);

2794: hr_utility.TRACE('time_period_id ' || time_period_id);
2795: hr_utility.TRACE('action_context_id ' || action_context_id);
2796: hr_utility.TRACE('assignment_id ' || assignment_id);
2797: hr_utility.TRACE('action_information14 ' || action_information14);
2798: hr_utility.TRACE('check_count ' || check_count);
2799:
2800: --Calling the US sepecific Validations
2801: is_valid_payslip := check_us_emp_personal_payment(
2802: p_assignment_id =>to_number(assignment_id)

Line 2809: hr_utility.TRACE('check_emp_personal_payment - Calling Generic');

2805: , p_assignment_action_id => to_number(action_context_id)
2806: , p_effective_date => v_effective_date
2807: );
2808: ELSE
2809: hr_utility.TRACE('check_emp_personal_payment - Calling Generic');
2810: hr_utility.TRACE('v_effective_date ' || v_effective_date);
2811: hr_utility.TRACE('payroll_id ' || payroll_id);
2812: hr_utility.TRACE('time_period_id ' || time_period_id);
2813: hr_utility.TRACE('action_context_id ' || action_context_id);

Line 2810: hr_utility.TRACE('v_effective_date ' || v_effective_date);

2806: , p_effective_date => v_effective_date
2807: );
2808: ELSE
2809: hr_utility.TRACE('check_emp_personal_payment - Calling Generic');
2810: hr_utility.TRACE('v_effective_date ' || v_effective_date);
2811: hr_utility.TRACE('payroll_id ' || payroll_id);
2812: hr_utility.TRACE('time_period_id ' || time_period_id);
2813: hr_utility.TRACE('action_context_id ' || action_context_id);
2814: hr_utility.TRACE('assignment_id ' || assignment_id);

Line 2811: hr_utility.TRACE('payroll_id ' || payroll_id);

2807: );
2808: ELSE
2809: hr_utility.TRACE('check_emp_personal_payment - Calling Generic');
2810: hr_utility.TRACE('v_effective_date ' || v_effective_date);
2811: hr_utility.TRACE('payroll_id ' || payroll_id);
2812: hr_utility.TRACE('time_period_id ' || time_period_id);
2813: hr_utility.TRACE('action_context_id ' || action_context_id);
2814: hr_utility.TRACE('assignment_id ' || assignment_id);
2815: hr_utility.TRACE('action_information14 ' || action_information14);

Line 2812: hr_utility.TRACE('time_period_id ' || time_period_id);

2808: ELSE
2809: hr_utility.TRACE('check_emp_personal_payment - Calling Generic');
2810: hr_utility.TRACE('v_effective_date ' || v_effective_date);
2811: hr_utility.TRACE('payroll_id ' || payroll_id);
2812: hr_utility.TRACE('time_period_id ' || time_period_id);
2813: hr_utility.TRACE('action_context_id ' || action_context_id);
2814: hr_utility.TRACE('assignment_id ' || assignment_id);
2815: hr_utility.TRACE('action_information14 ' || action_information14);
2816: hr_utility.TRACE('check_count ' || check_count);

Line 2813: hr_utility.TRACE('action_context_id ' || action_context_id);

2809: hr_utility.TRACE('check_emp_personal_payment - Calling Generic');
2810: hr_utility.TRACE('v_effective_date ' || v_effective_date);
2811: hr_utility.TRACE('payroll_id ' || payroll_id);
2812: hr_utility.TRACE('time_period_id ' || time_period_id);
2813: hr_utility.TRACE('action_context_id ' || action_context_id);
2814: hr_utility.TRACE('assignment_id ' || assignment_id);
2815: hr_utility.TRACE('action_information14 ' || action_information14);
2816: hr_utility.TRACE('check_count ' || check_count);
2817:

Line 2814: hr_utility.TRACE('assignment_id ' || assignment_id);

2810: hr_utility.TRACE('v_effective_date ' || v_effective_date);
2811: hr_utility.TRACE('payroll_id ' || payroll_id);
2812: hr_utility.TRACE('time_period_id ' || time_period_id);
2813: hr_utility.TRACE('action_context_id ' || action_context_id);
2814: hr_utility.TRACE('assignment_id ' || assignment_id);
2815: hr_utility.TRACE('action_information14 ' || action_information14);
2816: hr_utility.TRACE('check_count ' || check_count);
2817:
2818: is_valid_payslip := check_emp_personal_payment(

Line 2815: hr_utility.TRACE('action_information14 ' || action_information14);

2811: hr_utility.TRACE('payroll_id ' || payroll_id);
2812: hr_utility.TRACE('time_period_id ' || time_period_id);
2813: hr_utility.TRACE('action_context_id ' || action_context_id);
2814: hr_utility.TRACE('assignment_id ' || assignment_id);
2815: hr_utility.TRACE('action_information14 ' || action_information14);
2816: hr_utility.TRACE('check_count ' || check_count);
2817:
2818: is_valid_payslip := check_emp_personal_payment(
2819: p_assignment_id =>to_number(assignment_id)

Line 2816: hr_utility.TRACE('check_count ' || check_count);

2812: hr_utility.TRACE('time_period_id ' || time_period_id);
2813: hr_utility.TRACE('action_context_id ' || action_context_id);
2814: hr_utility.TRACE('assignment_id ' || assignment_id);
2815: hr_utility.TRACE('action_information14 ' || action_information14);
2816: hr_utility.TRACE('check_count ' || check_count);
2817:
2818: is_valid_payslip := check_emp_personal_payment(
2819: p_assignment_id =>to_number(assignment_id)
2820: ,p_payroll_id => to_number(payroll_id)

Line 2829: hr_utility.TRACE('Before Term Check');

2825: END IF;
2826:
2827: IF is_valid_payslip = 'Y' THEN
2828:
2829: hr_utility.TRACE('Before Term Check');
2830: hr_utility.TRACE('check_emp_personal_payment - Valid Payslip found for t_assignment_action_id ' ||action_context_id);
2831:
2832: --Now check for Termination
2833: IF p_enable_term = 'N' THEN

Line 2830: hr_utility.TRACE('check_emp_personal_payment - Valid Payslip found for t_assignment_action_id ' ||action_context_id);

2826:
2827: IF is_valid_payslip = 'Y' THEN
2828:
2829: hr_utility.TRACE('Before Term Check');
2830: hr_utility.TRACE('check_emp_personal_payment - Valid Payslip found for t_assignment_action_id ' ||action_context_id);
2831:
2832: --Now check for Termination
2833: IF p_enable_term = 'N' THEN
2834: l_term_flag := pay_us_employee_payslip_web.get_term_info(p_business_group_id, p_person_id, action_context_id);

Line 2839: hr_utility.TRACE('After Term Check');

2835: END IF;
2836:
2837: IF (p_enable_term = 'N' AND l_term_flag = 'Y') OR (p_enable_term <> 'N') THEN
2838:
2839: hr_utility.TRACE('After Term Check');
2840: hr_utility.TRACE('check_emp_personal_payment - Valid Payslip found for t_assignment_action_id ' || action_context_id);
2841: --if row_count > 1 then
2842: pay_ret_table.EXTEND(1);
2843:

Line 2840: hr_utility.TRACE('check_emp_personal_payment - Valid Payslip found for t_assignment_action_id ' || action_context_id);

2836:
2837: IF (p_enable_term = 'N' AND l_term_flag = 'Y') OR (p_enable_term <> 'N') THEN
2838:
2839: hr_utility.TRACE('After Term Check');
2840: hr_utility.TRACE('check_emp_personal_payment - Valid Payslip found for t_assignment_action_id ' || action_context_id);
2841: --if row_count > 1 then
2842: pay_ret_table.EXTEND(1);
2843:
2844: --insert the payslip in to the table to be returned.

Line 2861: hr_utility.TRACE('Terminated Employee Payslip');

2857: RETURN;
2858: END IF;
2859: row_count := row_count + 1;
2860: ELSE
2861: hr_utility.TRACE('Terminated Employee Payslip');
2862: END IF;
2863:
2864: END IF;
2865:

Line 3013: hr_utility.TRACE('Entering check_emp_personal_payment');

3009:
3010:
3011: BEGIN
3012:
3013: hr_utility.TRACE('Entering check_emp_personal_payment');
3014: hr_utility.TRACE('p_effective_date=' || p_effective_date);
3015: hr_utility.TRACE('p_time_period_id=' || p_time_period_id);
3016:
3017:

Line 3014: hr_utility.TRACE('p_effective_date=' || p_effective_date);

3010:
3011: BEGIN
3012:
3013: hr_utility.TRACE('Entering check_emp_personal_payment');
3014: hr_utility.TRACE('p_effective_date=' || p_effective_date);
3015: hr_utility.TRACE('p_time_period_id=' || p_time_period_id);
3016:
3017:
3018: -- END For bug 8643214

Line 3015: hr_utility.TRACE('p_time_period_id=' || p_time_period_id);

3011: BEGIN
3012:
3013: hr_utility.TRACE('Entering check_emp_personal_payment');
3014: hr_utility.TRACE('p_effective_date=' || p_effective_date);
3015: hr_utility.TRACE('p_time_period_id=' || p_time_period_id);
3016:
3017:
3018: -- END For bug 8643214
3019:

Line 3046: hr_utility.TRACE('ln_time_period_id=' || ln_time_period_id);

3042: END IF;
3043: CLOSE c_get_date_earned;
3044: END IF;
3045:
3046: hr_utility.TRACE('ln_time_period_id=' || ln_time_period_id);
3047: OPEN c_view_offset(ln_time_period_id);
3048: FETCH c_view_offset INTO ld_view_payslip_offset_date, ld_reg_payment_date;
3049: CLOSE c_view_offset;
3050:

Line 3051: hr_utility.TRACE('ld_view_payslip_offset_date=' || trunc(ld_view_payslip_offset_date));

3047: OPEN c_view_offset(ln_time_period_id);
3048: FETCH c_view_offset INTO ld_view_payslip_offset_date, ld_reg_payment_date;
3049: CLOSE c_view_offset;
3050:
3051: hr_utility.TRACE('ld_view_payslip_offset_date=' || trunc(ld_view_payslip_offset_date));
3052: hr_utility.TRACE('p_effective_date=' || trunc(p_effective_date));
3053: hr_utility.TRACE('sysdate=' || trunc(SYSDATE));
3054:
3055: IF ld_date_paid IS NULL THEN

Line 3052: hr_utility.TRACE('p_effective_date=' || trunc(p_effective_date));

3048: FETCH c_view_offset INTO ld_view_payslip_offset_date, ld_reg_payment_date;
3049: CLOSE c_view_offset;
3050:
3051: hr_utility.TRACE('ld_view_payslip_offset_date=' || trunc(ld_view_payslip_offset_date));
3052: hr_utility.TRACE('p_effective_date=' || trunc(p_effective_date));
3053: hr_utility.TRACE('sysdate=' || trunc(SYSDATE));
3054:
3055: IF ld_date_paid IS NULL THEN
3056: OPEN c_get_date_earned(ln_prepay_action_id);

Line 3053: hr_utility.TRACE('sysdate=' || trunc(SYSDATE));

3049: CLOSE c_view_offset;
3050:
3051: hr_utility.TRACE('ld_view_payslip_offset_date=' || trunc(ld_view_payslip_offset_date));
3052: hr_utility.TRACE('p_effective_date=' || trunc(p_effective_date));
3053: hr_utility.TRACE('sysdate=' || trunc(SYSDATE));
3054:
3055: IF ld_date_paid IS NULL THEN
3056: OPEN c_get_date_earned(ln_prepay_action_id);
3057: FETCH c_get_date_earned INTO ld_earned_date, ld_date_paid, ln_bg_id;

Line 3073: hr_utility.TRACE('g_legislation_code=' || g_legislation_code);

3069: if g_legislation_code is null then
3070: g_legislation_code := get_legislation_code(ln_bg_id);
3071: end if;
3072:
3073: hr_utility.TRACE('g_legislation_code=' || g_legislation_code);
3074: hr_utility.TRACE('is_dynamic_view_date=' || is_dynamic_view_date);
3075:
3076: --If Date_paid preference is set and legislation_code is 'US'
3077: IF is_dynamic_view_date = 'Y' AND ld_date_paid IS NOT NULL AND g_legislation_code = 'US' THEN

Line 3074: hr_utility.TRACE('is_dynamic_view_date=' || is_dynamic_view_date);

3070: g_legislation_code := get_legislation_code(ln_bg_id);
3071: end if;
3072:
3073: hr_utility.TRACE('g_legislation_code=' || g_legislation_code);
3074: hr_utility.TRACE('is_dynamic_view_date=' || is_dynamic_view_date);
3075:
3076: --If Date_paid preference is set and legislation_code is 'US'
3077: IF is_dynamic_view_date = 'Y' AND ld_date_paid IS NOT NULL AND g_legislation_code = 'US' THEN
3078:

Line 3081: hr_utility.TRACE('ln_offset_value=' || ln_offset_value);

3077: IF is_dynamic_view_date = 'Y' AND ld_date_paid IS NOT NULL AND g_legislation_code = 'US' THEN
3078:
3079: ln_offset_value := trunc(ld_view_payslip_offset_date - ld_reg_payment_date);
3080:
3081: hr_utility.TRACE('ln_offset_value=' || ln_offset_value);
3082: hr_utility.TRACE('ld_view_payslip_offset_date=' || ld_view_payslip_offset_date);
3083:
3084: ld_payslip_view_date := trunc(ld_date_paid) + ln_offset_value;
3085: hr_utility.TRACE('ld_payslip_view_date=' || ld_payslip_view_date);

Line 3082: hr_utility.TRACE('ld_view_payslip_offset_date=' || ld_view_payslip_offset_date);

3078:
3079: ln_offset_value := trunc(ld_view_payslip_offset_date - ld_reg_payment_date);
3080:
3081: hr_utility.TRACE('ln_offset_value=' || ln_offset_value);
3082: hr_utility.TRACE('ld_view_payslip_offset_date=' || ld_view_payslip_offset_date);
3083:
3084: ld_payslip_view_date := trunc(ld_date_paid) + ln_offset_value;
3085: hr_utility.TRACE('ld_payslip_view_date=' || ld_payslip_view_date);
3086:

Line 3085: hr_utility.TRACE('ld_payslip_view_date=' || ld_payslip_view_date);

3081: hr_utility.TRACE('ln_offset_value=' || ln_offset_value);
3082: hr_utility.TRACE('ld_view_payslip_offset_date=' || ld_view_payslip_offset_date);
3083:
3084: ld_payslip_view_date := trunc(ld_date_paid) + ln_offset_value;
3085: hr_utility.TRACE('ld_payslip_view_date=' || ld_payslip_view_date);
3086:
3087: IF trunc(ld_payslip_view_date) > trunc(SYSDATE) THEN
3088: hr_utility.TRACE('View offset return N');
3089: RETURN('N');

Line 3088: hr_utility.TRACE('View offset return N');

3084: ld_payslip_view_date := trunc(ld_date_paid) + ln_offset_value;
3085: hr_utility.TRACE('ld_payslip_view_date=' || ld_payslip_view_date);
3086:
3087: IF trunc(ld_payslip_view_date) > trunc(SYSDATE) THEN
3088: hr_utility.TRACE('View offset return N');
3089: RETURN('N');
3090: END IF;
3091: --Default Behaviour
3092: ELSE

Line 3093: hr_utility.TRACE('Offset Criteria is not Date_paid ');

3089: RETURN('N');
3090: END IF;
3091: --Default Behaviour
3092: ELSE
3093: hr_utility.TRACE('Offset Criteria is not Date_paid ');
3094: IF trunc(ld_view_payslip_offset_date) > trunc(SYSDATE) THEN
3095: hr_utility.TRACE('View offset return N');
3096: RETURN('N');
3097: END IF;

Line 3095: hr_utility.TRACE('View offset return N');

3091: --Default Behaviour
3092: ELSE
3093: hr_utility.TRACE('Offset Criteria is not Date_paid ');
3094: IF trunc(ld_view_payslip_offset_date) > trunc(SYSDATE) THEN
3095: hr_utility.TRACE('View offset return N');
3096: RETURN('N');
3097: END IF;
3098: END IF;
3099:

Line 3136: hr_utility.TRACE('lv_return_flag=' || lv_return_flag);

3132:
3133: END IF;
3134: CLOSE c_check_for_reversal;
3135:
3136: hr_utility.TRACE('lv_return_flag=' || lv_return_flag);
3137: hr_utility.TRACE('Leaving check_emp_personal_payment');
3138:
3139: RETURN lv_return_flag;
3140:

Line 3137: hr_utility.TRACE('Leaving check_emp_personal_payment');

3133: END IF;
3134: CLOSE c_check_for_reversal;
3135:
3136: hr_utility.TRACE('lv_return_flag=' || lv_return_flag);
3137: hr_utility.TRACE('Leaving check_emp_personal_payment');
3138:
3139: RETURN lv_return_flag;
3140:
3141: END check_us_emp_personal_payment;

Line 3192: hr_utility.TRACE('Release greater than or equal to 12.1.1 ' );

3188: end if;
3189: /*
3190: if fnd_release.release_name >= '12.1.1' then
3191:
3192: hr_utility.TRACE('Release greater than or equal to 12.1.1 ' );
3193: --Calendar_aware parameter intentionally hard coded as 1, as date fields in OA framework does not depend
3194: --on the fnd profile "FND: Date API Calendar Awareness Default"
3195: v_list := fnd_date.date_to_displaydate(p_date,1)
3196: ||' - '

Line 3207: hr_utility.TRACE('Release less than 12.1.1 ' );

3203: || p_check_count;
3204:
3205:
3206: else
3207: hr_utility.TRACE('Release less than 12.1.1 ' );
3208: v_list := p_date
3209: ||' - '
3210: || g_job_label
3211: ||' '

Line 3234: hr_utility.TRACE('v_list ' || v_list);

3230: ||g_check_label
3231: ||' '
3232: || p_check_count;
3233:
3234: hr_utility.TRACE('v_list ' || v_list);
3235: return v_list;
3236:
3237: end get_display_list;
3238:

Line 3241: -- hr_utility.trace_on(null, 'PAYSLIP');

3237: end get_display_list;
3238:
3239: BEGIN
3240: gv_package := 'pay_us_employee_payslip_web';
3241: -- hr_utility.trace_on(null, 'PAYSLIP');
3242: END pay_us_employee_payslip_web;