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_NO_K27_REIM_UPLD dependencies on FND_FILE

Line 580: fnd_file.PUT_LINE(FND_FILE.LOG, 'File Name:'|| p_filename);

576: end count_tokens;
577:
578: BEGIN
579:
580: fnd_file.PUT_LINE(FND_FILE.LOG, 'File Name:'|| p_filename);
581: fnd_file.PUT_LINE(FND_FILE.LOG, 'p_test_submission:'||p_test_submission);
582: fnd_file.PUT_LINE(FND_FILE.LOG, 'g_period_date:'||g_period_date);
583:
584:

Line 581: fnd_file.PUT_LINE(FND_FILE.LOG, 'p_test_submission:'||p_test_submission);

577:
578: BEGIN
579:
580: fnd_file.PUT_LINE(FND_FILE.LOG, 'File Name:'|| p_filename);
581: fnd_file.PUT_LINE(FND_FILE.LOG, 'p_test_submission:'||p_test_submission);
582: fnd_file.PUT_LINE(FND_FILE.LOG, 'g_period_date:'||g_period_date);
583:
584:
585: fnd_profile.get('PER_DATA_EXCHANGE_DIR', l_location);

Line 582: fnd_file.PUT_LINE(FND_FILE.LOG, 'g_period_date:'||g_period_date);

578: BEGIN
579:
580: fnd_file.PUT_LINE(FND_FILE.LOG, 'File Name:'|| p_filename);
581: fnd_file.PUT_LINE(FND_FILE.LOG, 'p_test_submission:'||p_test_submission);
582: fnd_file.PUT_LINE(FND_FILE.LOG, 'g_period_date:'||g_period_date);
583:
584:
585: fnd_profile.get('PER_DATA_EXCHANGE_DIR', l_location);
586:

Line 587: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_location:'||l_location);

583:
584:
585: fnd_profile.get('PER_DATA_EXCHANGE_DIR', l_location);
586:
587: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_location:'||l_location);
588:
589: l_file_handle := utl_file.fopen(l_location,p_filename,'r');
590:
591: --13359423

Line 595: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'Delimiter count is not as expected. Record Format altered.');

591: --13359423
592: /* if (count_tokens(l_present_line) <> 5) then
593: retcode := 2;
594: errbuf := 'Header Record Format altered.';
595: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'Delimiter count is not as expected. Record Format altered.');
596: raise invalid_file_format;
597: end if; */
598: --13359423
599:

Line 601: --fnd_file.PUT_LINE(FND_FILE.LOG, '+++++++++BODY+++++++++');

597: end if; */
598: --13359423
599:
600:
601: --fnd_file.PUT_LINE(FND_FILE.LOG, '+++++++++BODY+++++++++');
602:
603: LOOP
604: BEGIN
605: l_skip_flag := 'N';

Line 615: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_present_line:'||l_present_line);

611: l_rec_uploaded := 'N';
612: l_is_payroll_run := 'N';
613:
614: utl_file.get_line(l_file_handle,l_present_line); --Reading Body values
615: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_present_line:'||l_present_line);
616:
617: l_line_number := l_line_number + 1;
618: fnd_file.PUT_LINE(FND_FILE.LOG, 'Line Number:'||l_line_number);
619:

Line 618: fnd_file.PUT_LINE(FND_FILE.LOG, 'Line Number:'||l_line_number);

614: utl_file.get_line(l_file_handle,l_present_line); --Reading Body values
615: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_present_line:'||l_present_line);
616:
617: l_line_number := l_line_number + 1;
618: fnd_file.PUT_LINE(FND_FILE.LOG, 'Line Number:'||l_line_number);
619:
620: fnd_file.PUT_LINE(FND_FILE.OUTPUT, '+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
621: fnd_file.PUT_LINE(FND_FILE.OUTPUT, 'Line Number '||l_line_number||':'||l_present_line);
622:

Line 620: fnd_file.PUT_LINE(FND_FILE.OUTPUT, '+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

616:
617: l_line_number := l_line_number + 1;
618: fnd_file.PUT_LINE(FND_FILE.LOG, 'Line Number:'||l_line_number);
619:
620: fnd_file.PUT_LINE(FND_FILE.OUTPUT, '+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
621: fnd_file.PUT_LINE(FND_FILE.OUTPUT, 'Line Number '||l_line_number||':'||l_present_line);
622:
623: IF (count_tokens(l_present_line) <> 11) then
624: retcode := 1;

Line 621: fnd_file.PUT_LINE(FND_FILE.OUTPUT, 'Line Number '||l_line_number||':'||l_present_line);

617: l_line_number := l_line_number + 1;
618: fnd_file.PUT_LINE(FND_FILE.LOG, 'Line Number:'||l_line_number);
619:
620: fnd_file.PUT_LINE(FND_FILE.OUTPUT, '+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
621: fnd_file.PUT_LINE(FND_FILE.OUTPUT, 'Line Number '||l_line_number||':'||l_present_line);
622:
623: IF (count_tokens(l_present_line) <> 11) then
624: retcode := 1;
625: errbuf := 'Record Format altered.';

Line 626: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'Delimiter count is not as expected. Record Format altered. Skipping Line Number'||l_line_number);

622:
623: IF (count_tokens(l_present_line) <> 11) then
624: retcode := 1;
625: errbuf := 'Record Format altered.';
626: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'Delimiter count is not as expected. Record Format altered. Skipping Line Number'||l_line_number);
627: l_format_altered := 'Y';
628: END IF;
629:
630: IF l_format_altered = 'N' THEN

Line 633: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_mun_sso_num:'||l_mun_sso_num);

629:
630: IF l_format_altered = 'N' THEN
631:
632: l_mun_sso_num := get_token(l_present_line,1);
633: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_mun_sso_num:'||l_mun_sso_num);
634:
635: l_le_org_num := get_token(l_present_line,2);
636: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_le_org_num:'||l_le_org_num);
637:

Line 636: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_le_org_num:'||l_le_org_num);

632: l_mun_sso_num := get_token(l_present_line,1);
633: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_mun_sso_num:'||l_mun_sso_num);
634:
635: l_le_org_num := get_token(l_present_line,2);
636: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_le_org_num:'||l_le_org_num);
637:
638: l_lu_org_num := get_token(l_present_line,3);
639: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_lu_org_num:'||l_lu_org_num);
640:

Line 639: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_lu_org_num:'||l_lu_org_num);

635: l_le_org_num := get_token(l_present_line,2);
636: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_le_org_num:'||l_le_org_num);
637:
638: l_lu_org_num := get_token(l_present_line,3);
639: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_lu_org_num:'||l_lu_org_num);
640:
641: l_ref_code := get_token(l_present_line,4);
642: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_ref_code:'||l_ref_code);
643:

Line 642: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_ref_code:'||l_ref_code);

638: l_lu_org_num := get_token(l_present_line,3);
639: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_lu_org_num:'||l_lu_org_num);
640:
641: l_ref_code := get_token(l_present_line,4);
642: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_ref_code:'||l_ref_code);
643:
644: l_emp_ni_num := get_token(l_present_line,5);
645: l_emp_ni_num := lpad(l_emp_ni_num,11,'0');
646: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_emp_ni_num:'||l_emp_ni_num);

Line 646: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_emp_ni_num:'||l_emp_ni_num);

642: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_ref_code:'||l_ref_code);
643:
644: l_emp_ni_num := get_token(l_present_line,5);
645: l_emp_ni_num := lpad(l_emp_ni_num,11,'0');
646: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_emp_ni_num:'||l_emp_ni_num);
647:
648: l_reimb_start_dt := get_token(l_present_line,6);
649: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_reimb_start_dt:'||l_reimb_start_dt);
650:

Line 649: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_reimb_start_dt:'||l_reimb_start_dt);

645: l_emp_ni_num := lpad(l_emp_ni_num,11,'0');
646: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_emp_ni_num:'||l_emp_ni_num);
647:
648: l_reimb_start_dt := get_token(l_present_line,6);
649: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_reimb_start_dt:'||l_reimb_start_dt);
650:
651: l_le_bank_ac_num := get_token(l_present_line,7);
652: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_le_bank_ac_num:'||l_le_bank_ac_num);
653:

Line 652: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_le_bank_ac_num:'||l_le_bank_ac_num);

648: l_reimb_start_dt := get_token(l_present_line,6);
649: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_reimb_start_dt:'||l_reimb_start_dt);
650:
651: l_le_bank_ac_num := get_token(l_present_line,7);
652: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_le_bank_ac_num:'||l_le_bank_ac_num);
653:
654: l_emp_name := get_token(l_present_line,8);
655: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_emp_name:'||l_emp_name);
656:

Line 655: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_emp_name:'||l_emp_name);

651: l_le_bank_ac_num := get_token(l_present_line,7);
652: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_le_bank_ac_num:'||l_le_bank_ac_num);
653:
654: l_emp_name := get_token(l_present_line,8);
655: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_emp_name:'||l_emp_name);
656:
657: l_reimb_end_dt := get_token(l_present_line,9);
658: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_reimb_end_dt:'||l_reimb_end_dt);
659:

Line 658: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_reimb_end_dt:'||l_reimb_end_dt);

654: l_emp_name := get_token(l_present_line,8);
655: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_emp_name:'||l_emp_name);
656:
657: l_reimb_end_dt := get_token(l_present_line,9);
658: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_reimb_end_dt:'||l_reimb_end_dt);
659:
660: l_reimb_amount := get_token(l_present_line,10);
661: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_reimb_amount:'||l_reimb_amount);
662:

Line 661: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_reimb_amount:'||l_reimb_amount);

657: l_reimb_end_dt := get_token(l_present_line,9);
658: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_reimb_end_dt:'||l_reimb_end_dt);
659:
660: l_reimb_amount := get_token(l_present_line,10);
661: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_reimb_amount:'||l_reimb_amount);
662:
663: IF substr(l_reimb_amount,11,1) = '-' THEN
664: l_reimb_amount := '-'||substr(l_reimb_amount,1,10);
665: fnd_file.PUT_LINE(FND_FILE.LOG, '1:l_reimb_amount:'||l_reimb_amount);

Line 665: fnd_file.PUT_LINE(FND_FILE.LOG, '1:l_reimb_amount:'||l_reimb_amount);

661: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_reimb_amount:'||l_reimb_amount);
662:
663: IF substr(l_reimb_amount,11,1) = '-' THEN
664: l_reimb_amount := '-'||substr(l_reimb_amount,1,10);
665: fnd_file.PUT_LINE(FND_FILE.LOG, '1:l_reimb_amount:'||l_reimb_amount);
666: END IF;
667:
668: l_filler := get_token(l_present_line,11);
669: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_filler:'||l_filler);

Line 669: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_filler:'||l_filler);

665: fnd_file.PUT_LINE(FND_FILE.LOG, '1:l_reimb_amount:'||l_reimb_amount);
666: END IF;
667:
668: l_filler := get_token(l_present_line,11);
669: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_filler:'||l_filler);
670:
671: l_max_reimb_dt := get_token(l_present_line,12);
672: IF substr(l_max_reimb_dt,1,8) = '00000000' THEN -- Bug 16318591 --added if condition for 16318591
673: l_max_reimb_dt := null;

Line 675: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_max_reimb_dt:'||l_max_reimb_dt);

671: l_max_reimb_dt := get_token(l_present_line,12);
672: IF substr(l_max_reimb_dt,1,8) = '00000000' THEN -- Bug 16318591 --added if condition for 16318591
673: l_max_reimb_dt := null;
674: END IF;
675: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_max_reimb_dt:'||l_max_reimb_dt);
676:
677:
678: fnd_file.PUT_LINE(FND_FILE.LOG, 'p_employer_number:'||p_employer_number);
679:

Line 678: fnd_file.PUT_LINE(FND_FILE.LOG, 'p_employer_number:'||p_employer_number);

674: END IF;
675: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_max_reimb_dt:'||l_max_reimb_dt);
676:
677:
678: fnd_file.PUT_LINE(FND_FILE.LOG, 'p_employer_number:'||p_employer_number);
679:
680: IF p_employer_number <> l_le_org_num THEN
681: fnd_file.PUT_LINE(FND_FILE.output, 'Employer Organization Number does not match. Skipping line number '||l_line_number);
682: l_skip_flag := 'Y';

Line 681: fnd_file.PUT_LINE(FND_FILE.output, 'Employer Organization Number does not match. Skipping line number '||l_line_number);

677:
678: fnd_file.PUT_LINE(FND_FILE.LOG, 'p_employer_number:'||p_employer_number);
679:
680: IF p_employer_number <> l_le_org_num THEN
681: fnd_file.PUT_LINE(FND_FILE.output, 'Employer Organization Number does not match. Skipping line number '||l_line_number);
682: l_skip_flag := 'Y';
683: retcode := 1;
684: errbuf := 'Employer Organization Number mismatch.';
685: END IF;

Line 694: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_assignment_id:'||l_assignment_id||'-Payroll_id-'||l_payroll_id);

690: ,p_date => g_period_date) ;
691:
692: FETCH csr_get_prim_assg INTO l_assignment_id, l_payroll_id;
693:
694: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_assignment_id:'||l_assignment_id||'-Payroll_id-'||l_payroll_id);
695:
696: IF csr_get_prim_assg%NOTFOUND THEN
697: fnd_file.PUT_LINE(FND_FILE.output, 'No valid primary assignment exists for NI Number '||l_emp_ni_num||'. Skipping line number '||l_line_number); --14363238
698: l_skip_flag := 'Y';

Line 697: fnd_file.PUT_LINE(FND_FILE.output, 'No valid primary assignment exists for NI Number '||l_emp_ni_num||'. Skipping line number '||l_line_number); --14363238

693:
694: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_assignment_id:'||l_assignment_id||'-Payroll_id-'||l_payroll_id);
695:
696: IF csr_get_prim_assg%NOTFOUND THEN
697: fnd_file.PUT_LINE(FND_FILE.output, 'No valid primary assignment exists for NI Number '||l_emp_ni_num||'. Skipping line number '||l_line_number); --14363238
698: l_skip_flag := 'Y';
699: retcode := 1;
700: errbuf := 'No primary assignment exists.';
701: ELSE

Line 710: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_asg_lu_id:'||l_asg_lu_id);

706: );
707: FETCH csr_asg_lu_id INTO l_asg_lu_id;
708: CLOSE csr_asg_lu_id;
709:
710: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_asg_lu_id:'||l_asg_lu_id);
711:
712: OPEN csr_lu_org_number
713: (g_business_group_id,
714: l_asg_lu_id);

Line 718: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_asg_lu_org_num:'||l_asg_lu_org_num);

714: l_asg_lu_id);
715: FETCH csr_lu_org_number INTO l_asg_lu_org_num;
716: CLOSE csr_lu_org_number;
717:
718: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_asg_lu_org_num:'||l_asg_lu_org_num);
719:
720: IF l_asg_lu_org_num <> l_lu_org_num THEN
721: fnd_file.PUT_LINE(FND_FILE.output, 'Local Unit Organization Number does not match for NI Number '||l_emp_ni_num||'. Skipping line number '||l_line_number);
722: l_skip_flag := 'Y';

Line 721: fnd_file.PUT_LINE(FND_FILE.output, 'Local Unit Organization Number does not match for NI Number '||l_emp_ni_num||'. Skipping line number '||l_line_number);

717:
718: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_asg_lu_org_num:'||l_asg_lu_org_num);
719:
720: IF l_asg_lu_org_num <> l_lu_org_num THEN
721: fnd_file.PUT_LINE(FND_FILE.output, 'Local Unit Organization Number does not match for NI Number '||l_emp_ni_num||'. Skipping line number '||l_line_number);
722: l_skip_flag := 'Y';
723: retcode := 1;
724: errbuf := 'Local Unit Organization Number mismatch.';
725: END IF;

Line 731: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_element_link_id:'||l_element_link_id);

727: CLOSE csr_get_prim_assg;
728:
729: l_element_link_id := get_element_link_id(l_assignment_id, g_business_group_id, g_period_date, 'K27 Reimbursement File Details');
730:
731: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_element_link_id:'||l_element_link_id);
732:
733: IF l_element_link_id = -1 THEN
734: fnd_file.PUT_LINE(FND_FILE.output, 'No K27 Reimbursement File Details element link exists for NI Number '||l_emp_ni_num||'. Skipping line number '||l_line_number);
735: l_skip_flag := 'Y';

Line 734: fnd_file.PUT_LINE(FND_FILE.output, 'No K27 Reimbursement File Details element link exists for NI Number '||l_emp_ni_num||'. Skipping line number '||l_line_number);

730:
731: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_element_link_id:'||l_element_link_id);
732:
733: IF l_element_link_id = -1 THEN
734: fnd_file.PUT_LINE(FND_FILE.output, 'No K27 Reimbursement File Details element link exists for NI Number '||l_emp_ni_num||'. Skipping line number '||l_line_number);
735: l_skip_flag := 'Y';
736: retcode := 1;
737: errbuf := 'No element link exists.';
738: END IF;

Line 758: fnd_file.PUT_LINE(FND_FILE.output, 'Record already uploaded for NI Number '||l_emp_ni_num||'. Skipping line number '||l_line_number);

754:
755: IF l_rec_uploaded = 'Y'
756: THEN
757: l_skip_flag := 'Y';
758: fnd_file.PUT_LINE(FND_FILE.output, 'Record already uploaded for NI Number '||l_emp_ni_num||'. Skipping line number '||l_line_number);
759: retcode := 1;
760: errbuf := 'Record already uploaded.';
761: END IF;
762:

Line 763: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_rec_uploaded:'||l_rec_uploaded);

759: retcode := 1;
760: errbuf := 'Record already uploaded.';
761: END IF;
762:
763: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_rec_uploaded:'||l_rec_uploaded);
764: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_skip_flag:'||l_skip_flag);
765: fnd_file.PUT_LINE(FND_FILE.LOG, 'p_test_submission:'||p_test_submission);
766:
767: OPEN cur_is_payroll_run(l_assignment_id, g_business_group_id, l_payroll_id, g_period_date);

Line 764: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_skip_flag:'||l_skip_flag);

760: errbuf := 'Record already uploaded.';
761: END IF;
762:
763: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_rec_uploaded:'||l_rec_uploaded);
764: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_skip_flag:'||l_skip_flag);
765: fnd_file.PUT_LINE(FND_FILE.LOG, 'p_test_submission:'||p_test_submission);
766:
767: OPEN cur_is_payroll_run(l_assignment_id, g_business_group_id, l_payroll_id, g_period_date);
768: FETCH cur_is_payroll_run INTO l_is_payroll_run;

Line 765: fnd_file.PUT_LINE(FND_FILE.LOG, 'p_test_submission:'||p_test_submission);

761: END IF;
762:
763: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_rec_uploaded:'||l_rec_uploaded);
764: fnd_file.PUT_LINE(FND_FILE.LOG, 'l_skip_flag:'||l_skip_flag);
765: fnd_file.PUT_LINE(FND_FILE.LOG, 'p_test_submission:'||p_test_submission);
766:
767: OPEN cur_is_payroll_run(l_assignment_id, g_business_group_id, l_payroll_id, g_period_date);
768: FETCH cur_is_payroll_run INTO l_is_payroll_run;
769: CLOSE cur_is_payroll_run;

Line 774: fnd_file.PUT_LINE(FND_FILE.output, 'Payroll already run for NI Number '||l_emp_ni_num||'. Skipping line number '||l_line_number);

770:
771: IF l_is_payroll_run = 'Y'
772: THEN
773: l_skip_flag := 'Y';
774: fnd_file.PUT_LINE(FND_FILE.output, 'Payroll already run for NI Number '||l_emp_ni_num||'. Skipping line number '||l_line_number);
775: retcode := 1;
776: errbuf := 'Payroll already run.';
777: END IF;
778:

Line 835: fnd_file.PUT_LINE(FND_FILE.output, 'Line Number '||l_line_number||' passed.');

831: ,p_action_information30 => p_filename);
832: END IF;
833:
834: IF l_skip_flag = 'N' THEN
835: fnd_file.PUT_LINE(FND_FILE.output, 'Line Number '||l_line_number||' passed.');
836: END IF;
837:
838: END IF; --l_format_altered
839:

Line 842: fnd_file.PUT_LINE(FND_FILE.LOG, 'End of file reached.');

838: END IF; --l_format_altered
839:
840: EXCEPTION
841: WHEN NO_DATA_FOUND THEN
842: fnd_file.PUT_LINE(FND_FILE.LOG, 'End of file reached.');
843: EXIT;
844: WHEN OTHERS THEN
845: fnd_file.PUT_LINE(FND_FILE.LOG, 'Other error occured');
846: fnd_file.PUT_LINE(FND_FILE.LOG, sqlerrm);

Line 845: fnd_file.PUT_LINE(FND_FILE.LOG, 'Other error occured');

841: WHEN NO_DATA_FOUND THEN
842: fnd_file.PUT_LINE(FND_FILE.LOG, 'End of file reached.');
843: EXIT;
844: WHEN OTHERS THEN
845: fnd_file.PUT_LINE(FND_FILE.LOG, 'Other error occured');
846: fnd_file.PUT_LINE(FND_FILE.LOG, sqlerrm);
847: retcode := 2;
848: errbuf := 'Other error occured';
849: EXIT;

Line 846: fnd_file.PUT_LINE(FND_FILE.LOG, sqlerrm);

842: fnd_file.PUT_LINE(FND_FILE.LOG, 'End of file reached.');
843: EXIT;
844: WHEN OTHERS THEN
845: fnd_file.PUT_LINE(FND_FILE.LOG, 'Other error occured');
846: fnd_file.PUT_LINE(FND_FILE.LOG, sqlerrm);
847: retcode := 2;
848: errbuf := 'Other error occured';
849: EXIT;
850: END;

Line 1153: Fnd_file.put_line(FND_FILE.LOG,l_errbuf);

1149: , l_employer_number
1150: , l_test_submission);
1151:
1152: IF l_retcode = 2 THEN
1153: Fnd_file.put_line(FND_FILE.LOG,l_errbuf);
1154: Fnd_file.put_line(FND_FILE.OUTPUT,'Report completed with Error(s)');
1155: Fnd_file.put_line(FND_FILE.OUTPUT,l_errbuf);
1156: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',
1157: 'Report completed with Error(s).Please check the log/output file.');

Line 1154: Fnd_file.put_line(FND_FILE.OUTPUT,'Report completed with Error(s)');

1150: , l_test_submission);
1151:
1152: IF l_retcode = 2 THEN
1153: Fnd_file.put_line(FND_FILE.LOG,l_errbuf);
1154: Fnd_file.put_line(FND_FILE.OUTPUT,'Report completed with Error(s)');
1155: Fnd_file.put_line(FND_FILE.OUTPUT,l_errbuf);
1156: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',
1157: 'Report completed with Error(s).Please check the log/output file.');
1158: ELSIF l_retcode = 1 THEN

Line 1155: Fnd_file.put_line(FND_FILE.OUTPUT,l_errbuf);

1151:
1152: IF l_retcode = 2 THEN
1153: Fnd_file.put_line(FND_FILE.LOG,l_errbuf);
1154: Fnd_file.put_line(FND_FILE.OUTPUT,'Report completed with Error(s)');
1155: Fnd_file.put_line(FND_FILE.OUTPUT,l_errbuf);
1156: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',
1157: 'Report completed with Error(s).Please check the log/output file.');
1158: ELSIF l_retcode = 1 THEN
1159: Fnd_file.put_line(FND_FILE.LOG,l_errbuf);

Line 1159: Fnd_file.put_line(FND_FILE.LOG,l_errbuf);

1155: Fnd_file.put_line(FND_FILE.OUTPUT,l_errbuf);
1156: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',
1157: 'Report completed with Error(s).Please check the log/output file.');
1158: ELSIF l_retcode = 1 THEN
1159: Fnd_file.put_line(FND_FILE.LOG,l_errbuf);
1160: Fnd_file.put_line(FND_FILE.OUTPUT,'Report completed with warning(s)');
1161: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',
1162: 'Report completed with validation warning(s).Please check the log/output file.');
1163: END IF;

Line 1160: Fnd_file.put_line(FND_FILE.OUTPUT,'Report completed with warning(s)');

1156: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',
1157: 'Report completed with Error(s).Please check the log/output file.');
1158: ELSIF l_retcode = 1 THEN
1159: Fnd_file.put_line(FND_FILE.LOG,l_errbuf);
1160: Fnd_file.put_line(FND_FILE.OUTPUT,'Report completed with warning(s)');
1161: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',
1162: 'Report completed with validation warning(s).Please check the log/output file.');
1163: END IF;
1164:

Line 1187: fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE START 1');

1183: ,p_chunk IN NUMBER )
1184: IS
1185:
1186: BEGIN
1187: fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE START 1');
1188: fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE END 2');
1189: EXCEPTION
1190: WHEN others THEN
1191: IF g_debug THEN

Line 1188: fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE END 2');

1184: IS
1185:
1186: BEGIN
1187: fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE START 1');
1188: fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE END 2');
1189: EXCEPTION
1190: WHEN others THEN
1191: IF g_debug THEN
1192: hr_utility.set_location('error raised assignment_action_code ',5);

Line 1223: fnd_file.put_line(fnd_file.log,'ARCHIVE_CODE START 1');

1219: PROCEDURE ARCHIVE_CODE(p_assignment_action_id IN NUMBER
1220: ,p_effective_date IN DATE)
1221: IS
1222: BEGIN
1223: fnd_file.put_line(fnd_file.log,'ARCHIVE_CODE START 1');
1224: fnd_file.put_line(fnd_file.log,'ARCHIVE_CODE END 2');
1225: EXCEPTION
1226: WHEN others THEN
1227: IF g_debug THEN

Line 1224: fnd_file.put_line(fnd_file.log,'ARCHIVE_CODE END 2');

1220: ,p_effective_date IN DATE)
1221: IS
1222: BEGIN
1223: fnd_file.put_line(fnd_file.log,'ARCHIVE_CODE START 1');
1224: fnd_file.put_line(fnd_file.log,'ARCHIVE_CODE END 2');
1225: EXCEPTION
1226: WHEN others THEN
1227: IF g_debug THEN
1228: hr_utility.set_location('error raised in archive code ',5);

Line 1236: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE START 1');

1232:
1233: PROCEDURE DEINITIALIZATION_CODE
1234: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
1235: BEGIN
1236: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE START 1');
1237: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE END 2');
1238: EXCEPTION
1239: WHEN others THEN
1240: IF g_debug THEN

Line 1237: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE END 2');

1233: PROCEDURE DEINITIALIZATION_CODE
1234: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
1235: BEGIN
1236: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE START 1');
1237: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE END 2');
1238: EXCEPTION
1239: WHEN others THEN
1240: IF g_debug THEN
1241: hr_utility.set_location('error raised in DEINITIALIZATION_CODE ',999);

Line 1291: fnd_file.PUT_LINE(FND_FILE.LOG,'p_legal_employer:'||p_legal_employer);

1287:
1288: BEGIN
1289: hr_utility.set_location('Entering K27_NOTIFICATION_REP ',800);
1290:
1291: fnd_file.PUT_LINE(FND_FILE.LOG,'p_legal_employer:'||p_legal_employer);
1292: fnd_file.PUT_LINE(FND_FILE.LOG,'p_Date_from:'||p_Date_from);
1293: fnd_file.PUT_LINE(FND_FILE.LOG,'p_Date_to:'||p_Date_to);
1294:
1295: l_date_from := fnd_date.canonical_to_date(p_Date_from);

Line 1292: fnd_file.PUT_LINE(FND_FILE.LOG,'p_Date_from:'||p_Date_from);

1288: BEGIN
1289: hr_utility.set_location('Entering K27_NOTIFICATION_REP ',800);
1290:
1291: fnd_file.PUT_LINE(FND_FILE.LOG,'p_legal_employer:'||p_legal_employer);
1292: fnd_file.PUT_LINE(FND_FILE.LOG,'p_Date_from:'||p_Date_from);
1293: fnd_file.PUT_LINE(FND_FILE.LOG,'p_Date_to:'||p_Date_to);
1294:
1295: l_date_from := fnd_date.canonical_to_date(p_Date_from);
1296: l_date_to := fnd_date.canonical_to_date(p_Date_to);

Line 1293: fnd_file.PUT_LINE(FND_FILE.LOG,'p_Date_to:'||p_Date_to);

1289: hr_utility.set_location('Entering K27_NOTIFICATION_REP ',800);
1290:
1291: fnd_file.PUT_LINE(FND_FILE.LOG,'p_legal_employer:'||p_legal_employer);
1292: fnd_file.PUT_LINE(FND_FILE.LOG,'p_Date_from:'||p_Date_from);
1293: fnd_file.PUT_LINE(FND_FILE.LOG,'p_Date_to:'||p_Date_to);
1294:
1295: l_date_from := fnd_date.canonical_to_date(p_Date_from);
1296: l_date_to := fnd_date.canonical_to_date(p_Date_to);
1297:

Line 1298: fnd_file.PUT_LINE(FND_FILE.LOG,'l_Date_from:'||l_Date_from);

1294:
1295: l_date_from := fnd_date.canonical_to_date(p_Date_from);
1296: l_date_to := fnd_date.canonical_to_date(p_Date_to);
1297:
1298: fnd_file.PUT_LINE(FND_FILE.LOG,'l_Date_from:'||l_Date_from);
1299: fnd_file.PUT_LINE(FND_FILE.LOG,'l_Date_to:'||l_Date_to);
1300:
1301: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'------------------- --------------------- ------------------------ -------------------------');
1302: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'Employee Number NI Number Reimbursement Max Date Reimbursement Amount');

Line 1299: fnd_file.PUT_LINE(FND_FILE.LOG,'l_Date_to:'||l_Date_to);

1295: l_date_from := fnd_date.canonical_to_date(p_Date_from);
1296: l_date_to := fnd_date.canonical_to_date(p_Date_to);
1297:
1298: fnd_file.PUT_LINE(FND_FILE.LOG,'l_Date_from:'||l_Date_from);
1299: fnd_file.PUT_LINE(FND_FILE.LOG,'l_Date_to:'||l_Date_to);
1300:
1301: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'------------------- --------------------- ------------------------ -------------------------');
1302: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'Employee Number NI Number Reimbursement Max Date Reimbursement Amount');
1303: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'------------------- --------------------- ------------------------ -------------------------');

Line 1301: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'------------------- --------------------- ------------------------ -------------------------');

1297:
1298: fnd_file.PUT_LINE(FND_FILE.LOG,'l_Date_from:'||l_Date_from);
1299: fnd_file.PUT_LINE(FND_FILE.LOG,'l_Date_to:'||l_Date_to);
1300:
1301: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'------------------- --------------------- ------------------------ -------------------------');
1302: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'Employee Number NI Number Reimbursement Max Date Reimbursement Amount');
1303: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'------------------- --------------------- ------------------------ -------------------------');
1304:
1305: FOR I IN cur_k27_employee_list(p_legal_employer, l_date_from, l_date_to)

Line 1302: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'Employee Number NI Number Reimbursement Max Date Reimbursement Amount');

1298: fnd_file.PUT_LINE(FND_FILE.LOG,'l_Date_from:'||l_Date_from);
1299: fnd_file.PUT_LINE(FND_FILE.LOG,'l_Date_to:'||l_Date_to);
1300:
1301: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'------------------- --------------------- ------------------------ -------------------------');
1302: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'Employee Number NI Number Reimbursement Max Date Reimbursement Amount');
1303: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'------------------- --------------------- ------------------------ -------------------------');
1304:
1305: FOR I IN cur_k27_employee_list(p_legal_employer, l_date_from, l_date_to)
1306: LOOP

Line 1303: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'------------------- --------------------- ------------------------ -------------------------');

1299: fnd_file.PUT_LINE(FND_FILE.LOG,'l_Date_to:'||l_Date_to);
1300:
1301: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'------------------- --------------------- ------------------------ -------------------------');
1302: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'Employee Number NI Number Reimbursement Max Date Reimbursement Amount');
1303: fnd_file.PUT_LINE(FND_FILE.OUTPUT,'------------------- --------------------- ------------------------ -------------------------');
1304:
1305: FOR I IN cur_k27_employee_list(p_legal_employer, l_date_from, l_date_to)
1306: LOOP
1307:

Line 1308: fnd_file.PUT_LINE(FND_FILE.OUTPUT,RPAD(I.emp_number,21,' ')||RPAD(I.NI_number,25,' ')||RPAD(I. Reimb_date,26,' ')||I.reimburse_amount);

1304:
1305: FOR I IN cur_k27_employee_list(p_legal_employer, l_date_from, l_date_to)
1306: LOOP
1307:
1308: fnd_file.PUT_LINE(FND_FILE.OUTPUT,RPAD(I.emp_number,21,' ')||RPAD(I.NI_number,25,' ')||RPAD(I. Reimb_date,26,' ')||I.reimburse_amount);
1309:
1310: END LOOP;
1311:
1312: hr_utility.set_location('Leaving K27_NOTIFICATION_REP ',888);