DBA Data[Home] [Help]

APPS.HXC_DATA_SET dependencies on FND_MESSAGE

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

820:
821: --Start all the validations
822: --for each validation error we need to add that to the log file
823:
824: fnd_message.set_name('HXC', 'HXC_VALIDATION_WARNINGS');
825: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
826: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
827:
828: OPEN c_get_bee_retrieval;

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

821: --Start all the validations
822: --for each validation error we need to add that to the log file
823:
824: fnd_message.set_name('HXC', 'HXC_VALIDATION_WARNINGS');
825: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
826: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
827:
828: OPEN c_get_bee_retrieval;
829: FETCH c_get_bee_retrieval INTO l_bee_retrieval;

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

868: if(l_approved_count=1 and l_unretrieved_tc.approval_status='APPROVED') then
869:
870: fnd_file.put_line(fnd_file.LOG,' ');
871: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
872: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_APPROVED_TC');
873: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
874: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
875: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
876: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

Line 873: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

869:
870: fnd_file.put_line(fnd_file.LOG,' ');
871: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
872: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_APPROVED_TC');
873: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
874: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
875: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
876: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
877: end if;

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

871: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
872: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_APPROVED_TC');
873: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
874: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
875: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
876: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
877: end if;
878:
879: if(l_rejected_count=1 and l_unretrieved_tc.approval_status='REJECTED') then

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

872: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_APPROVED_TC');
873: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
874: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
875: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
876: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
877: end if;
878:
879: if(l_rejected_count=1 and l_unretrieved_tc.approval_status='REJECTED') then
880:

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

880:
881: fnd_file.put_line(fnd_file.LOG,' ');
882: fnd_file.put_line(fnd_file.LOG,' ');
883: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
884: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
885: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
886: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
887: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
888: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

Line 885: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

881: fnd_file.put_line(fnd_file.LOG,' ');
882: fnd_file.put_line(fnd_file.LOG,' ');
883: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
884: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
885: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
886: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
887: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
888: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
889: end if;

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

883: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
884: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
885: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
886: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
887: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
888: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
889: end if;
890:
891:

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

884: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
885: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
886: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
887: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
888: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
889: end if;
890:
891:
892: if(l_submitted_count=1 and l_unretrieved_tc.approval_status='SUBMITTED') then

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

893:
894: fnd_file.put_line(fnd_file.LOG,' ');
895: fnd_file.put_line(fnd_file.LOG,' ');
896: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
897: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
898: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
899: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
900: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
901: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

Line 898: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

894: fnd_file.put_line(fnd_file.LOG,' ');
895: fnd_file.put_line(fnd_file.LOG,' ');
896: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
897: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
898: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
899: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
900: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
901: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
902: end if;

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

896: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
897: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
898: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
899: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
900: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
901: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
902: end if;
903:
904: if(l_working_count=1 and l_unretrieved_tc.approval_status='WORKING') then

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

897: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
898: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
899: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
900: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
901: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
902: end if;
903:
904: if(l_working_count=1 and l_unretrieved_tc.approval_status='WORKING') then
905:

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

905:
906: fnd_file.put_line(fnd_file.LOG,' ');
907: fnd_file.put_line(fnd_file.LOG,' ');
908: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
909: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
910: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
911: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
912: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
913: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

Line 910: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

906: fnd_file.put_line(fnd_file.LOG,' ');
907: fnd_file.put_line(fnd_file.LOG,' ');
908: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
909: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
910: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
911: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
912: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
913: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
914: end if;

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

908: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
909: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
910: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
911: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
912: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
913: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
914: end if;
915:
916:

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

909: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
910: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
911: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
912: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
913: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
914: end if;
915:
916:
917:

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

945: if(l_count=1) then
946: fnd_file.put_line(fnd_file.LOG,' ');
947: fnd_file.put_line(fnd_file.LOG,' ');
948: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
949: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
950: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
951: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
952: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
953: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

Line 950: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

946: fnd_file.put_line(fnd_file.LOG,' ');
947: fnd_file.put_line(fnd_file.LOG,' ');
948: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
949: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
950: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
951: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
952: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
953: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
954: end if;

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

948: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
949: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
950: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
951: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
952: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
953: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
954: end if;
955:
956:

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

949: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
950: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
951: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
952: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
953: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
954: end if;
955:
956:
957: 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 1000: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');

996: then
997: fnd_file.put_line(fnd_file.LOG,' ');
998: fnd_file.put_line(fnd_file.LOG,' ');
999: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
1000: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');
1001: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
1002: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
1003: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
1004: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

Line 1001: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

997: fnd_file.put_line(fnd_file.LOG,' ');
998: fnd_file.put_line(fnd_file.LOG,' ');
999: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
1000: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');
1001: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
1002: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
1003: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
1004: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
1005: end if;

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

999: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
1000: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');
1001: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
1002: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
1003: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
1004: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
1005: end if;
1006:
1007: fnd_file.put_line(fnd_file.LOG,

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

1000: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');
1001: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
1002: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
1003: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
1004: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
1005: end if;
1006:
1007: fnd_file.put_line(fnd_file.LOG,
1008: 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);