731:
732: --Start all the validations
733: --for each validation error we need to add that to the log file
734:
735: fnd_message.set_name('HXC', 'HXC_VALIDATION_WARNINGS');
736: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
737: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
738:
739: OPEN c_get_bee_retrieval;
732: --Start all the validations
733: --for each validation error we need to add that to the log file
734:
735: fnd_message.set_name('HXC', 'HXC_VALIDATION_WARNINGS');
736: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
737: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
738:
739: OPEN c_get_bee_retrieval;
740: FETCH c_get_bee_retrieval INTO l_bee_retrieval;
779: if(l_approved_count=1 and l_unretrieved_tc.approval_status='APPROVED') then
780:
781: fnd_file.put_line(fnd_file.LOG,' ');
782: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
783: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_APPROVED_TC');
784: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
785: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
786: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
787: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
780:
781: fnd_file.put_line(fnd_file.LOG,' ');
782: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
783: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_APPROVED_TC');
784: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
785: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
786: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
787: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
788: end if;
782: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
783: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_APPROVED_TC');
784: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
785: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
786: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
787: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
788: end if;
789:
790: if(l_rejected_count=1 and l_unretrieved_tc.approval_status='REJECTED') then
783: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_APPROVED_TC');
784: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
785: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
786: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
787: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
788: end if;
789:
790: if(l_rejected_count=1 and l_unretrieved_tc.approval_status='REJECTED') then
791:
791:
792: fnd_file.put_line(fnd_file.LOG,' ');
793: fnd_file.put_line(fnd_file.LOG,' ');
794: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
795: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
796: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
797: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
798: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
799: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
792: fnd_file.put_line(fnd_file.LOG,' ');
793: fnd_file.put_line(fnd_file.LOG,' ');
794: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
795: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
796: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
797: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
798: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
799: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
800: end if;
794: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
795: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
796: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
797: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
798: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
799: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
800: end if;
801:
802:
795: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
796: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
797: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
798: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
799: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
800: end if;
801:
802:
803: if(l_submitted_count=1 and l_unretrieved_tc.approval_status='SUBMITTED') then
804:
805: fnd_file.put_line(fnd_file.LOG,' ');
806: fnd_file.put_line(fnd_file.LOG,' ');
807: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
808: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
809: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
810: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
811: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
812: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
805: fnd_file.put_line(fnd_file.LOG,' ');
806: fnd_file.put_line(fnd_file.LOG,' ');
807: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
808: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
809: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
810: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
811: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
812: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
813: end if;
807: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
808: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
809: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
810: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
811: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
812: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
813: end if;
814:
815: if(l_working_count=1 and l_unretrieved_tc.approval_status='WORKING') then
808: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
809: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
810: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
811: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
812: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
813: end if;
814:
815: if(l_working_count=1 and l_unretrieved_tc.approval_status='WORKING') then
816:
816:
817: fnd_file.put_line(fnd_file.LOG,' ');
818: fnd_file.put_line(fnd_file.LOG,' ');
819: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
820: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
821: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
822: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
823: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
824: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
817: fnd_file.put_line(fnd_file.LOG,' ');
818: fnd_file.put_line(fnd_file.LOG,' ');
819: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
820: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
821: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
822: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
823: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
824: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
825: end if;
819: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
820: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
821: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
822: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
823: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
824: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
825: end if;
826:
827:
820: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
821: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
822: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
823: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
824: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
825: end if;
826:
827:
828:
856: if(l_count=1) then
857: fnd_file.put_line(fnd_file.LOG,' ');
858: fnd_file.put_line(fnd_file.LOG,' ');
859: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
860: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
861: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
862: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
863: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
864: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
857: fnd_file.put_line(fnd_file.LOG,' ');
858: fnd_file.put_line(fnd_file.LOG,' ');
859: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
860: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
861: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
862: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
863: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
864: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
865: end if;
859: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
860: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
861: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
862: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
863: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
864: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
865: end if;
866:
867:
860: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
861: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
862: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
863: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
864: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
865: end if;
866:
867:
868: fnd_file.put_line(fnd_file.LOG,l_err_tc.start_time||'-'||l_err_tc.stop_time||' '||l_err_tc.resource_id||' - '||l_err_tc.employee_number||' - '||l_err_tc.full_name);
907: then
908: fnd_file.put_line(fnd_file.LOG,' ');
909: fnd_file.put_line(fnd_file.LOG,' ');
910: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
911: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');
912: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
913: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
914: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
915: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
908: fnd_file.put_line(fnd_file.LOG,' ');
909: fnd_file.put_line(fnd_file.LOG,' ');
910: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
911: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');
912: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
913: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
914: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
915: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
916: end if;
910: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
911: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');
912: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
913: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
914: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
915: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
916: end if;
917:
918: fnd_file.put_line(fnd_file.LOG,
911: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');
912: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
913: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
914: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
915: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
916: end if;
917:
918: fnd_file.put_line(fnd_file.LOG,
919: l_timecard_notifications.start_time||'-'||l_timecard_notifications.stop_time||' '||l_timecard_notifications.resource_id||' - '||l_timecard_notifications.employee_number||' - '||l_timecard_notifications.full_name);