DBA Data[Home] [Help]

APPS.HXC_DATA_SET dependencies on FND_MESSAGE

Line 735: fnd_message.set_name('HXC', 'HXC_VALIDATION_WARNINGS');

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;

Line 736: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

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;

Line 783: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_APPROVED_TC');

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);

Line 784: 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;

Line 786: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');

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

Line 787: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

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:

Line 795: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');

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);

Line 796: 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;

Line 798: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');

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:

Line 799: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

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

Line 808: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');

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);

Line 809: 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;

Line 811: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');

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

Line 812: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

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:

Line 820: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');

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);

Line 821: 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;

Line 823: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');

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:

Line 824: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

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:

Line 860: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');

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);

Line 861: 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;

Line 863: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');

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:

Line 864: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

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);

Line 911: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');

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);

Line 912: 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;

Line 914: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');

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,

Line 915: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

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);