DBA Data[Home] [Help]

APPS.PAY_GB_RTI_UPD dependencies on FND_FILE

Line 635: fnd_file.put_line (fnd_file.output

631: hr_utility.trace('l_business_group_id:'||l_business_group_id);
632: p_effect_date := get_soy_date (fnd_date.canonical_to_date(p_effective_date));
633: hr_utility.trace('Effective Date after get_soy_date call:'||p_effect_date);
634:
635: fnd_file.put_line (fnd_file.output
636: ,rpad ('-----------------------------------------------------------------'
637: ,80));
638:
639: fnd_file.put_line (fnd_file.output

Line 639: fnd_file.put_line (fnd_file.output

635: fnd_file.put_line (fnd_file.output
636: ,rpad ('-----------------------------------------------------------------'
637: ,80));
638:
639: fnd_file.put_line (fnd_file.output
640: ,rpad ('RTI Payroll Report'
641: ,80)
642: || rpad (' '
643: ,37

Line 647: fnd_file.put_line (fnd_file.output

643: ,37
644: ,' ')
645: || sysdate);
646:
647: fnd_file.put_line (fnd_file.output
648: ,' ');
649:
650: fnd_file.put_line (fnd_file.output
651: ,'Business Group : '

Line 650: fnd_file.put_line (fnd_file.output

646:
647: fnd_file.put_line (fnd_file.output
648: ,' ');
649:
650: fnd_file.put_line (fnd_file.output
651: ,'Business Group : '
652: || l_business_group_id);
653:
654: fnd_file.put_line (fnd_file.output

Line 654: fnd_file.put_line (fnd_file.output

650: fnd_file.put_line (fnd_file.output
651: ,'Business Group : '
652: || l_business_group_id);
653:
654: fnd_file.put_line (fnd_file.output
655: ,'Effective Date : '
656: || fnd_date.canonical_to_date(p_effective_date));
657: fnd_file.put_line (fnd_file.output
658: ,rpad (' '

Line 657: fnd_file.put_line (fnd_file.output

653:
654: fnd_file.put_line (fnd_file.output
655: ,'Effective Date : '
656: || fnd_date.canonical_to_date(p_effective_date));
657: fnd_file.put_line (fnd_file.output
658: ,rpad (' '
659: ,80));
660: fnd_file.put_line (fnd_file.output
661: ,rpad (' '

Line 660: fnd_file.put_line (fnd_file.output

656: || fnd_date.canonical_to_date(p_effective_date));
657: fnd_file.put_line (fnd_file.output
658: ,rpad (' '
659: ,80));
660: fnd_file.put_line (fnd_file.output
661: ,rpad (' '
662: ,80));
663:
664: fnd_file.put_line (fnd_file.output

Line 664: fnd_file.put_line (fnd_file.output

660: fnd_file.put_line (fnd_file.output
661: ,rpad (' '
662: ,80));
663:
664: fnd_file.put_line (fnd_file.output
665: ,rpad ('-----------------------------------------------------------------'
666: ,80));
667:
668:

Line 669: fnd_file.put_line (fnd_file.output

665: ,rpad ('-----------------------------------------------------------------'
666: ,80));
667:
668:
669: fnd_file.put_line (fnd_file.output
670: ,rpad ('Assignments Processed in this Run'
671: ,80));
672: fnd_file.put_line (fnd_file.output
673: ,rpad ('-----------------------------------------------------------------'

Line 672: fnd_file.put_line (fnd_file.output

668:
669: fnd_file.put_line (fnd_file.output
670: ,rpad ('Assignments Processed in this Run'
671: ,80));
672: fnd_file.put_line (fnd_file.output
673: ,rpad ('-----------------------------------------------------------------'
674: ,80));
675: fnd_file.put_line (fnd_file.output
676: ,rpad ('-----------------------------------------------------------------'

Line 675: fnd_file.put_line (fnd_file.output

671: ,80));
672: fnd_file.put_line (fnd_file.output
673: ,rpad ('-----------------------------------------------------------------'
674: ,80));
675: fnd_file.put_line (fnd_file.output
676: ,rpad ('-----------------------------------------------------------------'
677: ,80));
678:
679: hr_utility.trace('before start of the loop');

Line 757: fnd_file.put_line (fnd_file.output

753: ,p_assignment_extra_info_id => p_assignment_extra_info_id);
754:
755: hr_utility.trace('Back to main program after insert api call...');
756: l_asg_pr_count := l_asg_pr_count +1;
757: fnd_file.put_line (fnd_file.output
758: ,rpad ('Person ID: '
759: || v_person_details.person_id
760: ,80));
761:

Line 762: fnd_file.put_line (fnd_file.output

758: ,rpad ('Person ID: '
759: || v_person_details.person_id
760: ,80));
761:
762: fnd_file.put_line (fnd_file.output
763: ,rpad ('Assignment ID: '
764: || v_person_details.assignment_id
765: ,80));
766:

Line 767: fnd_file.put_line (fnd_file.output

763: ,rpad ('Assignment ID: '
764: || v_person_details.assignment_id
765: ,80));
766:
767: fnd_file.put_line (fnd_file.output
768: ,rpad ('RTI Payroll ID: '
769: || l_rti_payroll_id
770: ,80));
771:

Line 778: fnd_file.put_line (fnd_file.output

774: ELSE
775: l_ni_reporting_flag_display := 'No';
776: END IF;
777:
778: fnd_file.put_line (fnd_file.output
779: ,rpad ('NI Reporting Flag: '
780: || l_ni_reporting_flag_display
781: ,80));
782:

Line 783: fnd_file.put_line (fnd_file.output

779: ,rpad ('NI Reporting Flag: '
780: || l_ni_reporting_flag_display
781: ,80));
782:
783: fnd_file.put_line (fnd_file.output
784: ,rpad ('-----------------------------------------------------------------'
785: ,80));
786: ELSE
787: l_count_processed := 1;

Line 821: fnd_file.put_line (fnd_file.output

817: hr_utility.trace('Error count is:'||l_err_count);
818: if l_err_count>0 then
819: --loop through the employees and show the errors
820:
821: fnd_file.put_line (fnd_file.output
822: ,rpad (' '
823: ,80));
824: fnd_file.put_line (fnd_file.output
825: ,rpad (' '

Line 824: fnd_file.put_line (fnd_file.output

820:
821: fnd_file.put_line (fnd_file.output
822: ,rpad (' '
823: ,80));
824: fnd_file.put_line (fnd_file.output
825: ,rpad (' '
826: ,80));
827:
828: fnd_file.put_line (fnd_file.output

Line 828: fnd_file.put_line (fnd_file.output

824: fnd_file.put_line (fnd_file.output
825: ,rpad (' '
826: ,80));
827:
828: fnd_file.put_line (fnd_file.output
829: ,rpad ('-----------------------------------------------------------------'
830: ,80));
831: fnd_file.put_line (fnd_file.output
832: ,rpad ('Employees Not Processed in this Run'

Line 831: fnd_file.put_line (fnd_file.output

827:
828: fnd_file.put_line (fnd_file.output
829: ,rpad ('-----------------------------------------------------------------'
830: ,80));
831: fnd_file.put_line (fnd_file.output
832: ,rpad ('Employees Not Processed in this Run'
833: ,80));
834: fnd_file.put_line (fnd_file.output
835: ,rpad ('-----------------------------------------------------------------'

Line 834: fnd_file.put_line (fnd_file.output

830: ,80));
831: fnd_file.put_line (fnd_file.output
832: ,rpad ('Employees Not Processed in this Run'
833: ,80));
834: fnd_file.put_line (fnd_file.output
835: ,rpad ('-----------------------------------------------------------------'
836: ,80));
837: fnd_file.put_line (fnd_file.output
838: ,rpad ('-----------------------------------------------------------------'

Line 837: fnd_file.put_line (fnd_file.output

833: ,80));
834: fnd_file.put_line (fnd_file.output
835: ,rpad ('-----------------------------------------------------------------'
836: ,80));
837: fnd_file.put_line (fnd_file.output
838: ,rpad ('-----------------------------------------------------------------'
839: ,80));
840: fnd_file.put_line (fnd_file.output
841: ,rpad ('Employee Numbers with no Primary Assignment:'

Line 840: fnd_file.put_line (fnd_file.output

836: ,80));
837: fnd_file.put_line (fnd_file.output
838: ,rpad ('-----------------------------------------------------------------'
839: ,80));
840: fnd_file.put_line (fnd_file.output
841: ,rpad ('Employee Numbers with no Primary Assignment:'
842: ,80));
843:
844:

Line 847: fnd_file.put_line (fnd_file.output

843:
844:
845: for l_err_emp_number in l_err_employee.first..l_err_employee.last loop
846: hr_utility.trace('l_err_employee(l_err_emp_number):'||l_err_employee(l_err_emp_number));
847: fnd_file.put_line (fnd_file.output
848: ,rpad(l_err_employee(l_err_emp_number),80)
849: );
850:
851:

Line 854: fnd_file.put_line (fnd_file.output

850:
851:
852: end loop;
853: RAISE ex_complete_warning;
854: fnd_file.put_line (fnd_file.output
855: ,rpad ('-----------------------------------------------------------------'
856: ,80));
857: null;
858: end if;

Line 860: fnd_file.put_line (fnd_file.output

856: ,80));
857: null;
858: end if;
859: IF l_count_processed = 1 and l_err_count=0 THEN
860: fnd_file.put_line (fnd_file.output
861: ,rpad ('No Assignments Found'
862: ,80));
863: END IF;
864: fnd_file.put_line (fnd_file.output

Line 864: fnd_file.put_line (fnd_file.output

860: fnd_file.put_line (fnd_file.output
861: ,rpad ('No Assignments Found'
862: ,80));
863: END IF;
864: fnd_file.put_line (fnd_file.output
865: ,rpad ('-----------------------------------------------------------------'
866: ,80));
867:
868: fnd_file.put_line(fnd_file.output,rpad('Total Assignment Count Picked up by the process:'||l_total_count,80));

Line 868: fnd_file.put_line(fnd_file.output,rpad('Total Assignment Count Picked up by the process:'||l_total_count,80));

864: fnd_file.put_line (fnd_file.output
865: ,rpad ('-----------------------------------------------------------------'
866: ,80));
867:
868: fnd_file.put_line(fnd_file.output,rpad('Total Assignment Count Picked up by the process:'||l_total_count,80));
869: fnd_file.put_line(fnd_file.output,rpad('Assignment Count Processesed in this run:'||l_asg_pr_count,80));
870: fnd_file.put_line(fnd_file.output,rpad('Assignment Count Not Processesed in this run:'||l_asg_not_pr_count,80));
871: retcode:=ret_normal_status;
872: EXCEPTION

Line 869: fnd_file.put_line(fnd_file.output,rpad('Assignment Count Processesed in this run:'||l_asg_pr_count,80));

865: ,rpad ('-----------------------------------------------------------------'
866: ,80));
867:
868: fnd_file.put_line(fnd_file.output,rpad('Total Assignment Count Picked up by the process:'||l_total_count,80));
869: fnd_file.put_line(fnd_file.output,rpad('Assignment Count Processesed in this run:'||l_asg_pr_count,80));
870: fnd_file.put_line(fnd_file.output,rpad('Assignment Count Not Processesed in this run:'||l_asg_not_pr_count,80));
871: retcode:=ret_normal_status;
872: EXCEPTION
873: WHEN check_payroll_exp THEN

Line 870: fnd_file.put_line(fnd_file.output,rpad('Assignment Count Not Processesed in this run:'||l_asg_not_pr_count,80));

866: ,80));
867:
868: fnd_file.put_line(fnd_file.output,rpad('Total Assignment Count Picked up by the process:'||l_total_count,80));
869: fnd_file.put_line(fnd_file.output,rpad('Assignment Count Processesed in this run:'||l_asg_pr_count,80));
870: fnd_file.put_line(fnd_file.output,rpad('Assignment Count Not Processesed in this run:'||l_asg_not_pr_count,80));
871: retcode:=ret_normal_status;
872: EXCEPTION
873: WHEN check_payroll_exp THEN
874: raise_application_error (- 20101