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.HXC_TCSUMMARY_MIGRATE dependencies on FND_FILE

Line 746: fnd_file.put_line(fnd_file.LOG,'Exception in populate_details is :' || SQLERRM);

742: CLOSE csr_get_resource_details;
743:
744: Exception
745: When others then
746: fnd_file.put_line(fnd_file.LOG,'Exception in populate_details is :' || SQLERRM);
747: return;
748: END populate_details;
749:
750:

Line 826: fnd_file.put_line(fnd_file.LOG, 'Starting Template Migration');

822: l_elp_upg_count number;
823:
824: begin
825:
826: fnd_file.put_line(fnd_file.LOG, 'Starting Template Migration');
827: fnd_file.put_line(fnd_file.LOG,'Starting Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
828:
829: l_timecard_count := 0;
830: l_detail_count := 0;

Line 827: fnd_file.put_line(fnd_file.LOG,'Starting Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

823:
824: begin
825:
826: fnd_file.put_line(fnd_file.LOG, 'Starting Template Migration');
827: fnd_file.put_line(fnd_file.LOG,'Starting Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
828:
829: l_timecard_count := 0;
830: l_detail_count := 0;
831: l_elp_upg_count := 0;

Line 840: fnd_file.put_line(fnd_file.LOG,'-------------------------------------');

836: l_end_date := trunc(fnd_date.canonical_to_date(p_end_date)) + 1 - (1 / (24 * 60 * 60));
837: l_batch_size := nvl(p_batch_size,500);
838:
839:
840: fnd_file.put_line(fnd_file.LOG,'-------------------------------------');
841: fnd_file.put_line(fnd_file.LOG, 'Parameters');
842: fnd_file.put_line(fnd_file.LOG, '----------');
843: fnd_file.put_line(fnd_file.LOG,'Business Group Id :' || p_business_group_id);
844: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);

Line 841: fnd_file.put_line(fnd_file.LOG, 'Parameters');

837: l_batch_size := nvl(p_batch_size,500);
838:
839:
840: fnd_file.put_line(fnd_file.LOG,'-------------------------------------');
841: fnd_file.put_line(fnd_file.LOG, 'Parameters');
842: fnd_file.put_line(fnd_file.LOG, '----------');
843: fnd_file.put_line(fnd_file.LOG,'Business Group Id :' || p_business_group_id);
844: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);
845: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);

Line 842: fnd_file.put_line(fnd_file.LOG, '----------');

838:
839:
840: fnd_file.put_line(fnd_file.LOG,'-------------------------------------');
841: fnd_file.put_line(fnd_file.LOG, 'Parameters');
842: fnd_file.put_line(fnd_file.LOG, '----------');
843: fnd_file.put_line(fnd_file.LOG,'Business Group Id :' || p_business_group_id);
844: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);
845: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);
846: fnd_file.put_line(fnd_file.LOG, 'Stop Processing At :' || p_stop_time);

Line 843: fnd_file.put_line(fnd_file.LOG,'Business Group Id :' || p_business_group_id);

839:
840: fnd_file.put_line(fnd_file.LOG,'-------------------------------------');
841: fnd_file.put_line(fnd_file.LOG, 'Parameters');
842: fnd_file.put_line(fnd_file.LOG, '----------');
843: fnd_file.put_line(fnd_file.LOG,'Business Group Id :' || p_business_group_id);
844: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);
845: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);
846: fnd_file.put_line(fnd_file.LOG, 'Stop Processing At :' || p_stop_time);
847: fnd_file.put_line(fnd_file.LOG, 'Batch Size :' || l_batch_size);

Line 844: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);

840: fnd_file.put_line(fnd_file.LOG,'-------------------------------------');
841: fnd_file.put_line(fnd_file.LOG, 'Parameters');
842: fnd_file.put_line(fnd_file.LOG, '----------');
843: fnd_file.put_line(fnd_file.LOG,'Business Group Id :' || p_business_group_id);
844: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);
845: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);
846: fnd_file.put_line(fnd_file.LOG, 'Stop Processing At :' || p_stop_time);
847: fnd_file.put_line(fnd_file.LOG, 'Batch Size :' || l_batch_size);
848: fnd_file.put_line(fnd_file.LOG,'Number of Workers : ' || p_num_workers);

Line 845: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);

841: fnd_file.put_line(fnd_file.LOG, 'Parameters');
842: fnd_file.put_line(fnd_file.LOG, '----------');
843: fnd_file.put_line(fnd_file.LOG,'Business Group Id :' || p_business_group_id);
844: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);
845: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);
846: fnd_file.put_line(fnd_file.LOG, 'Stop Processing At :' || p_stop_time);
847: fnd_file.put_line(fnd_file.LOG, 'Batch Size :' || l_batch_size);
848: fnd_file.put_line(fnd_file.LOG,'Number of Workers : ' || p_num_workers);
849: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');

Line 846: fnd_file.put_line(fnd_file.LOG, 'Stop Processing At :' || p_stop_time);

842: fnd_file.put_line(fnd_file.LOG, '----------');
843: fnd_file.put_line(fnd_file.LOG,'Business Group Id :' || p_business_group_id);
844: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);
845: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);
846: fnd_file.put_line(fnd_file.LOG, 'Stop Processing At :' || p_stop_time);
847: fnd_file.put_line(fnd_file.LOG, 'Batch Size :' || l_batch_size);
848: fnd_file.put_line(fnd_file.LOG,'Number of Workers : ' || p_num_workers);
849: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
850:

Line 847: fnd_file.put_line(fnd_file.LOG, 'Batch Size :' || l_batch_size);

843: fnd_file.put_line(fnd_file.LOG,'Business Group Id :' || p_business_group_id);
844: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);
845: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);
846: fnd_file.put_line(fnd_file.LOG, 'Stop Processing At :' || p_stop_time);
847: fnd_file.put_line(fnd_file.LOG, 'Batch Size :' || l_batch_size);
848: fnd_file.put_line(fnd_file.LOG,'Number of Workers : ' || p_num_workers);
849: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
850:
851: IF ( p_business_group_id is null) THEN

Line 848: fnd_file.put_line(fnd_file.LOG,'Number of Workers : ' || p_num_workers);

844: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);
845: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);
846: fnd_file.put_line(fnd_file.LOG, 'Stop Processing At :' || p_stop_time);
847: fnd_file.put_line(fnd_file.LOG, 'Batch Size :' || l_batch_size);
848: fnd_file.put_line(fnd_file.LOG,'Number of Workers : ' || p_num_workers);
849: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
850:
851: IF ( p_business_group_id is null) THEN
852: open c_templates(l_start_date, l_end_date);

Line 849: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');

845: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);
846: fnd_file.put_line(fnd_file.LOG, 'Stop Processing At :' || p_stop_time);
847: fnd_file.put_line(fnd_file.LOG, 'Batch Size :' || l_batch_size);
848: fnd_file.put_line(fnd_file.LOG,'Number of Workers : ' || p_num_workers);
849: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
850:
851: IF ( p_business_group_id is null) THEN
852: open c_templates(l_start_date, l_end_date);
853: ELSE

Line 862: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

858: i := 1;
859: loop
860:
861: if (is_process_time_over(l_process_end_time)) then
862: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
863: fnd_file.put_line(fnd_file.LOG,'Total Number of templates processed : ' ||l_timecard_count);
864: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
865: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
866: fnd_file.put_line(fnd_file.LOG, 'Leaving Template Migration');

Line 863: fnd_file.put_line(fnd_file.LOG,'Total Number of templates processed : ' ||l_timecard_count);

859: loop
860:
861: if (is_process_time_over(l_process_end_time)) then
862: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
863: fnd_file.put_line(fnd_file.LOG,'Total Number of templates processed : ' ||l_timecard_count);
864: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
865: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
866: fnd_file.put_line(fnd_file.LOG, 'Leaving Template Migration');
867: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

Line 864: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);

860:
861: if (is_process_time_over(l_process_end_time)) then
862: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
863: fnd_file.put_line(fnd_file.LOG,'Total Number of templates processed : ' ||l_timecard_count);
864: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
865: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
866: fnd_file.put_line(fnd_file.LOG, 'Leaving Template Migration');
867: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
868: commit;

Line 865: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

861: if (is_process_time_over(l_process_end_time)) then
862: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
863: fnd_file.put_line(fnd_file.LOG,'Total Number of templates processed : ' ||l_timecard_count);
864: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
865: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
866: fnd_file.put_line(fnd_file.LOG, 'Leaving Template Migration');
867: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
868: commit;
869: return;

Line 866: fnd_file.put_line(fnd_file.LOG, 'Leaving Template Migration');

862: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
863: fnd_file.put_line(fnd_file.LOG,'Total Number of templates processed : ' ||l_timecard_count);
864: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
865: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
866: fnd_file.put_line(fnd_file.LOG, 'Leaving Template Migration');
867: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
868: commit;
869: return;
870: end if;

Line 867: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

863: fnd_file.put_line(fnd_file.LOG,'Total Number of templates processed : ' ||l_timecard_count);
864: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
865: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
866: fnd_file.put_line(fnd_file.LOG, 'Leaving Template Migration');
867: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
868: commit;
869: return;
870: end if;
871:

Line 882: fnd_file.put_line(fnd_file.LOG,'There was a problem while submitting the concurrent request for Worker ' || i);

878: ,argument2 => p_stop_time
879: ,argument3 => 'TEMPLATE');
880: if l_req_id(i) = 0 then
881: --some problem with the concurrent request. write to log file.
882: fnd_file.put_line(fnd_file.LOG,'There was a problem while submitting the concurrent request for Worker ' || i);
883:
884: end if;
885: commit;
886:

Line 944: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

940: ELSE
941: close c_templates_bg;
942: END IF;
943:
944: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
945: fnd_file.put_line(fnd_file.LOG,'Total Number of templates processed : ' ||l_timecard_count);
946:
947:
948:

Line 945: fnd_file.put_line(fnd_file.LOG,'Total Number of templates processed : ' ||l_timecard_count);

941: close c_templates_bg;
942: END IF;
943:
944: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
945: fnd_file.put_line(fnd_file.LOG,'Total Number of templates processed : ' ||l_timecard_count);
946:
947:
948:
949: insert into hxc_temp_timecards

Line 963: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);

959: ,l_request_id
960: ,'Y');
961: commit;
962:
963: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
964: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
965: fnd_file.put_line(fnd_file.LOG, 'Leaving Template Migration');
966: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
967:

Line 964: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

960: ,'Y');
961: commit;
962:
963: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
964: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
965: fnd_file.put_line(fnd_file.LOG, 'Leaving Template Migration');
966: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
967:
968: -- delete_templates;

Line 965: fnd_file.put_line(fnd_file.LOG, 'Leaving Template Migration');

961: commit;
962:
963: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
964: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
965: fnd_file.put_line(fnd_file.LOG, 'Leaving Template Migration');
966: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
967:
968: -- delete_templates;
969: commit;

Line 966: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

962:
963: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
964: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
965: fnd_file.put_line(fnd_file.LOG, 'Leaving Template Migration');
966: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
967:
968: -- delete_templates;
969: commit;
970: end migrate_templates;

Line 1096: fnd_file.put_line(fnd_file.LOG, 'Starting Timecard Migration');

1092: l_elp_upg_count number;
1093:
1094: begin
1095:
1096: fnd_file.put_line(fnd_file.LOG, 'Starting Timecard Migration');
1097: fnd_file.put_line(fnd_file.LOG,'Starting Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1098:
1099: l_timecard_count := 0;
1100: l_app_period_count := 0;

Line 1097: fnd_file.put_line(fnd_file.LOG,'Starting Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

1093:
1094: begin
1095:
1096: fnd_file.put_line(fnd_file.LOG, 'Starting Timecard Migration');
1097: fnd_file.put_line(fnd_file.LOG,'Starting Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1098:
1099: l_timecard_count := 0;
1100: l_app_period_count := 0;
1101: l_detail_count := 0;

Line 1111: fnd_file.put_line(fnd_file.LOG,'-------------------------------------');

1107: l_end_date := trunc(fnd_date.canonical_to_date(p_end_date)) + 1 - (1 / (24 * 60 * 60));
1108: l_batch_size := nvl(p_batch_size,500);
1109:
1110:
1111: fnd_file.put_line(fnd_file.LOG,'-------------------------------------');
1112: fnd_file.put_line(fnd_file.LOG, 'Parameters');
1113: fnd_file.put_line(fnd_file.LOG, '----------');
1114: fnd_file.put_line(fnd_file.LOG,'Business Group Id :' || p_business_group_id);
1115: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);

Line 1112: fnd_file.put_line(fnd_file.LOG, 'Parameters');

1108: l_batch_size := nvl(p_batch_size,500);
1109:
1110:
1111: fnd_file.put_line(fnd_file.LOG,'-------------------------------------');
1112: fnd_file.put_line(fnd_file.LOG, 'Parameters');
1113: fnd_file.put_line(fnd_file.LOG, '----------');
1114: fnd_file.put_line(fnd_file.LOG,'Business Group Id :' || p_business_group_id);
1115: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);
1116: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);

Line 1113: fnd_file.put_line(fnd_file.LOG, '----------');

1109:
1110:
1111: fnd_file.put_line(fnd_file.LOG,'-------------------------------------');
1112: fnd_file.put_line(fnd_file.LOG, 'Parameters');
1113: fnd_file.put_line(fnd_file.LOG, '----------');
1114: fnd_file.put_line(fnd_file.LOG,'Business Group Id :' || p_business_group_id);
1115: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);
1116: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);
1117: fnd_file.put_line(fnd_file.LOG, 'Stop Processing At :' || p_stop_time);

Line 1114: fnd_file.put_line(fnd_file.LOG,'Business Group Id :' || p_business_group_id);

1110:
1111: fnd_file.put_line(fnd_file.LOG,'-------------------------------------');
1112: fnd_file.put_line(fnd_file.LOG, 'Parameters');
1113: fnd_file.put_line(fnd_file.LOG, '----------');
1114: fnd_file.put_line(fnd_file.LOG,'Business Group Id :' || p_business_group_id);
1115: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);
1116: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);
1117: fnd_file.put_line(fnd_file.LOG, 'Stop Processing At :' || p_stop_time);
1118: fnd_file.put_line(fnd_file.LOG, 'Batch Size :' || l_batch_size);

Line 1115: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);

1111: fnd_file.put_line(fnd_file.LOG,'-------------------------------------');
1112: fnd_file.put_line(fnd_file.LOG, 'Parameters');
1113: fnd_file.put_line(fnd_file.LOG, '----------');
1114: fnd_file.put_line(fnd_file.LOG,'Business Group Id :' || p_business_group_id);
1115: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);
1116: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);
1117: fnd_file.put_line(fnd_file.LOG, 'Stop Processing At :' || p_stop_time);
1118: fnd_file.put_line(fnd_file.LOG, 'Batch Size :' || l_batch_size);
1119: fnd_file.put_line(fnd_file.LOG,'Number of Workers : ' || p_num_workers);

Line 1116: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);

1112: fnd_file.put_line(fnd_file.LOG, 'Parameters');
1113: fnd_file.put_line(fnd_file.LOG, '----------');
1114: fnd_file.put_line(fnd_file.LOG,'Business Group Id :' || p_business_group_id);
1115: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);
1116: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);
1117: fnd_file.put_line(fnd_file.LOG, 'Stop Processing At :' || p_stop_time);
1118: fnd_file.put_line(fnd_file.LOG, 'Batch Size :' || l_batch_size);
1119: fnd_file.put_line(fnd_file.LOG,'Number of Workers : ' || p_num_workers);
1120: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');

Line 1117: fnd_file.put_line(fnd_file.LOG, 'Stop Processing At :' || p_stop_time);

1113: fnd_file.put_line(fnd_file.LOG, '----------');
1114: fnd_file.put_line(fnd_file.LOG,'Business Group Id :' || p_business_group_id);
1115: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);
1116: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);
1117: fnd_file.put_line(fnd_file.LOG, 'Stop Processing At :' || p_stop_time);
1118: fnd_file.put_line(fnd_file.LOG, 'Batch Size :' || l_batch_size);
1119: fnd_file.put_line(fnd_file.LOG,'Number of Workers : ' || p_num_workers);
1120: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
1121:

Line 1118: fnd_file.put_line(fnd_file.LOG, 'Batch Size :' || l_batch_size);

1114: fnd_file.put_line(fnd_file.LOG,'Business Group Id :' || p_business_group_id);
1115: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);
1116: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);
1117: fnd_file.put_line(fnd_file.LOG, 'Stop Processing At :' || p_stop_time);
1118: fnd_file.put_line(fnd_file.LOG, 'Batch Size :' || l_batch_size);
1119: fnd_file.put_line(fnd_file.LOG,'Number of Workers : ' || p_num_workers);
1120: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
1121:
1122: IF(p_business_group_id is null) THEN

Line 1119: fnd_file.put_line(fnd_file.LOG,'Number of Workers : ' || p_num_workers);

1115: fnd_file.put_line(fnd_file.LOG, 'Start Date :' || l_start_date);
1116: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);
1117: fnd_file.put_line(fnd_file.LOG, 'Stop Processing At :' || p_stop_time);
1118: fnd_file.put_line(fnd_file.LOG, 'Batch Size :' || l_batch_size);
1119: fnd_file.put_line(fnd_file.LOG,'Number of Workers : ' || p_num_workers);
1120: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
1121:
1122: IF(p_business_group_id is null) THEN
1123: open c_timecards(l_start_date, l_end_date);

Line 1120: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');

1116: fnd_file.put_line(fnd_file.LOG, 'End Date :' || l_end_date);
1117: fnd_file.put_line(fnd_file.LOG, 'Stop Processing At :' || p_stop_time);
1118: fnd_file.put_line(fnd_file.LOG, 'Batch Size :' || l_batch_size);
1119: fnd_file.put_line(fnd_file.LOG,'Number of Workers : ' || p_num_workers);
1120: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
1121:
1122: IF(p_business_group_id is null) THEN
1123: open c_timecards(l_start_date, l_end_date);
1124: ELSE

Line 1132: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

1128: i := 1;
1129: loop
1130:
1131: if (is_process_time_over(l_process_end_time)) then
1132: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1133: fnd_file.put_line(fnd_file.LOG,'Total Number of timecards processed : ' ||l_timecard_count);
1134: fnd_file.put_line(fnd_file.LOG,'Total Number of application period blocks processed : ' ||l_app_period_count);
1135: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
1136: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

Line 1133: fnd_file.put_line(fnd_file.LOG,'Total Number of timecards processed : ' ||l_timecard_count);

1129: loop
1130:
1131: if (is_process_time_over(l_process_end_time)) then
1132: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1133: fnd_file.put_line(fnd_file.LOG,'Total Number of timecards processed : ' ||l_timecard_count);
1134: fnd_file.put_line(fnd_file.LOG,'Total Number of application period blocks processed : ' ||l_app_period_count);
1135: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
1136: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1137: fnd_file.put_line(fnd_file.LOG, 'Leaving Timecard Migration');

Line 1134: fnd_file.put_line(fnd_file.LOG,'Total Number of application period blocks processed : ' ||l_app_period_count);

1130:
1131: if (is_process_time_over(l_process_end_time)) then
1132: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1133: fnd_file.put_line(fnd_file.LOG,'Total Number of timecards processed : ' ||l_timecard_count);
1134: fnd_file.put_line(fnd_file.LOG,'Total Number of application period blocks processed : ' ||l_app_period_count);
1135: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
1136: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1137: fnd_file.put_line(fnd_file.LOG, 'Leaving Timecard Migration');
1138: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

Line 1135: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);

1131: if (is_process_time_over(l_process_end_time)) then
1132: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1133: fnd_file.put_line(fnd_file.LOG,'Total Number of timecards processed : ' ||l_timecard_count);
1134: fnd_file.put_line(fnd_file.LOG,'Total Number of application period blocks processed : ' ||l_app_period_count);
1135: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
1136: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1137: fnd_file.put_line(fnd_file.LOG, 'Leaving Timecard Migration');
1138: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1139: commit;

Line 1136: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

1132: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1133: fnd_file.put_line(fnd_file.LOG,'Total Number of timecards processed : ' ||l_timecard_count);
1134: fnd_file.put_line(fnd_file.LOG,'Total Number of application period blocks processed : ' ||l_app_period_count);
1135: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
1136: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1137: fnd_file.put_line(fnd_file.LOG, 'Leaving Timecard Migration');
1138: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1139: commit;
1140: return;

Line 1137: fnd_file.put_line(fnd_file.LOG, 'Leaving Timecard Migration');

1133: fnd_file.put_line(fnd_file.LOG,'Total Number of timecards processed : ' ||l_timecard_count);
1134: fnd_file.put_line(fnd_file.LOG,'Total Number of application period blocks processed : ' ||l_app_period_count);
1135: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
1136: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1137: fnd_file.put_line(fnd_file.LOG, 'Leaving Timecard Migration');
1138: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1139: commit;
1140: return;
1141: end if;

Line 1138: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

1134: fnd_file.put_line(fnd_file.LOG,'Total Number of application period blocks processed : ' ||l_app_period_count);
1135: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
1136: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1137: fnd_file.put_line(fnd_file.LOG, 'Leaving Timecard Migration');
1138: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1139: commit;
1140: return;
1141: end if;
1142:

Line 1153: fnd_file.put_line(fnd_file.LOG,'There was a problem while submitting the concurrent request for Worker ' || i);

1149: ,argument2 => p_stop_time
1150: ,argument3 => 'TIMECARD');
1151: if l_req_id(i) = 0 then
1152: --some problem with the concurrent request. write to log file.
1153: fnd_file.put_line(fnd_file.LOG,'There was a problem while submitting the concurrent request for Worker ' || i);
1154:
1155: end if;
1156: commit;
1157:

Line 1214: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

1210: ELSE
1211: close c_timecards_bg;
1212: END IF;
1213:
1214: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1215: fnd_file.put_line(fnd_file.LOG,'Total Number of timecards processed : ' ||l_timecard_count);
1216:
1217: if(p_business_group_id is null) then
1218: open c_app_periods(l_start_date, l_end_date);

Line 1215: fnd_file.put_line(fnd_file.LOG,'Total Number of timecards processed : ' ||l_timecard_count);

1211: close c_timecards_bg;
1212: END IF;
1213:
1214: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1215: fnd_file.put_line(fnd_file.LOG,'Total Number of timecards processed : ' ||l_timecard_count);
1216:
1217: if(p_business_group_id is null) then
1218: open c_app_periods(l_start_date, l_end_date);
1219: else

Line 1226: fnd_file.put_line(fnd_file.LOG,'Total Number of application period blocks processed : ' ||l_app_period_count);

1222:
1223: i := 1;
1224: loop
1225: if (is_process_time_over(l_process_end_time)) then
1226: fnd_file.put_line(fnd_file.LOG,'Total Number of application period blocks processed : ' ||l_app_period_count);
1227: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
1228: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1229: fnd_file.put_line(fnd_file.LOG, 'Leaving Timecard Migration');
1230: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

Line 1227: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);

1223: i := 1;
1224: loop
1225: if (is_process_time_over(l_process_end_time)) then
1226: fnd_file.put_line(fnd_file.LOG,'Total Number of application period blocks processed : ' ||l_app_period_count);
1227: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
1228: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1229: fnd_file.put_line(fnd_file.LOG, 'Leaving Timecard Migration');
1230: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1231: commit;

Line 1228: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

1224: loop
1225: if (is_process_time_over(l_process_end_time)) then
1226: fnd_file.put_line(fnd_file.LOG,'Total Number of application period blocks processed : ' ||l_app_period_count);
1227: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
1228: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1229: fnd_file.put_line(fnd_file.LOG, 'Leaving Timecard Migration');
1230: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1231: commit;
1232: return;

Line 1229: fnd_file.put_line(fnd_file.LOG, 'Leaving Timecard Migration');

1225: if (is_process_time_over(l_process_end_time)) then
1226: fnd_file.put_line(fnd_file.LOG,'Total Number of application period blocks processed : ' ||l_app_period_count);
1227: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
1228: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1229: fnd_file.put_line(fnd_file.LOG, 'Leaving Timecard Migration');
1230: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1231: commit;
1232: return;
1233: end if;

Line 1230: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

1226: fnd_file.put_line(fnd_file.LOG,'Total Number of application period blocks processed : ' ||l_app_period_count);
1227: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
1228: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1229: fnd_file.put_line(fnd_file.LOG, 'Leaving Timecard Migration');
1230: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1231: commit;
1232: return;
1233: end if;
1234:

Line 1246: fnd_file.put_line(fnd_file.LOG,'There was a problem while submitting the concurrent request for Worker ' || i);

1242: ,argument2 => p_stop_time
1243: ,argument3 => 'TIMECARD');
1244: if l_req_id(i) = 0 then
1245: --some problem with the concurrent request. write to log file.
1246: fnd_file.put_line(fnd_file.LOG,'There was a problem while submitting the concurrent request for Worker ' || i);
1247: end if;
1248:
1249: commit;
1250:

Line 1303: fnd_file.put_line(fnd_file.LOG,'Total Number of application period blocks processed : ' ||l_app_period_count);

1299: ELSE
1300: close c_app_periods_bg;
1301: END IF;
1302:
1303: fnd_file.put_line(fnd_file.LOG,'Total Number of application period blocks processed : ' ||l_app_period_count);
1304:
1305: insert into hxc_temp_timecards
1306: (TIME_BUILDING_BLOCK_ID
1307: ,scope

Line 1329: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);

1325: ,l_detail_count);
1326:
1327: populate_appl_set_id(p_business_group_id, l_process_end_time, l_start_date, l_end_date,l_elp_upg_count);
1328:
1329: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
1330: fnd_file.put_line(fnd_file.LOG,'Total Number of blocks processsed for ELP upgrade : ' ||l_elp_upg_count);
1331: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1332: fnd_file.put_line(fnd_file.LOG, 'Leaving Timecard Migration');
1333: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

Line 1330: fnd_file.put_line(fnd_file.LOG,'Total Number of blocks processsed for ELP upgrade : ' ||l_elp_upg_count);

1326:
1327: populate_appl_set_id(p_business_group_id, l_process_end_time, l_start_date, l_end_date,l_elp_upg_count);
1328:
1329: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
1330: fnd_file.put_line(fnd_file.LOG,'Total Number of blocks processsed for ELP upgrade : ' ||l_elp_upg_count);
1331: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1332: fnd_file.put_line(fnd_file.LOG, 'Leaving Timecard Migration');
1333: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1334:

Line 1331: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

1327: populate_appl_set_id(p_business_group_id, l_process_end_time, l_start_date, l_end_date,l_elp_upg_count);
1328:
1329: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
1330: fnd_file.put_line(fnd_file.LOG,'Total Number of blocks processsed for ELP upgrade : ' ||l_elp_upg_count);
1331: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1332: fnd_file.put_line(fnd_file.LOG, 'Leaving Timecard Migration');
1333: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1334:
1335: delete_timecards;

Line 1332: fnd_file.put_line(fnd_file.LOG, 'Leaving Timecard Migration');

1328:
1329: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
1330: fnd_file.put_line(fnd_file.LOG,'Total Number of blocks processsed for ELP upgrade : ' ||l_elp_upg_count);
1331: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1332: fnd_file.put_line(fnd_file.LOG, 'Leaving Timecard Migration');
1333: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1334:
1335: delete_timecards;
1336: commit;

Line 1333: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

1329: fnd_file.put_line(fnd_file.LOG,'Total Number of detail blocks processed : ' ||l_detail_count);
1330: fnd_file.put_line(fnd_file.LOG,'Total Number of blocks processsed for ELP upgrade : ' ||l_elp_upg_count);
1331: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1332: fnd_file.put_line(fnd_file.LOG, 'Leaving Timecard Migration');
1333: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1334:
1335: delete_timecards;
1336: commit;
1337:

Line 1411: fnd_file.put_line(fnd_file.LOG,'There was a problem while submitting the concurrent request for migrating tiemcards');

1407:
1408:
1409: if l_timecard_req_id = 0 then
1410: --some problem with the concurrent request. write to log file.
1411: fnd_file.put_line(fnd_file.LOG,'There was a problem while submitting the concurrent request for migrating tiemcards');
1412:
1413: end if;
1414:
1415: /*l_template_req_id := FND_REQUEST.SUBMIT_REQUEST(application => 'HXC'

Line 1448: fnd_file.put_line(fnd_file.LOG,'There was a problem while submitting the concurrent request for migrating templates' );

1444:
1445:
1446: if l_template_req_id = 0 then
1447: --some problem with the concurrent request. write to log file.
1448: fnd_file.put_line(fnd_file.LOG,'There was a problem while submitting the concurrent request for migrating templates' );
1449:
1450: end if;
1451:
1452: if ( l_timecard_req_id <> 0 AND l_template_req_id <> 0

Line 1504: fnd_file.put_line(fnd_file.LOG,'Starting Worker Migration');

1500: l_app_per_summary_count number;
1501:
1502: Begin
1503:
1504: fnd_file.put_line(fnd_file.LOG,'Starting Worker Migration');
1505: fnd_file.put_line(fnd_file.LOG,'Starting Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1506: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1507:
1508: l_process_end_time := fnd_date.canonical_to_date(p_stop_time);

Line 1505: fnd_file.put_line(fnd_file.LOG,'Starting Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

1501:
1502: Begin
1503:
1504: fnd_file.put_line(fnd_file.LOG,'Starting Worker Migration');
1505: fnd_file.put_line(fnd_file.LOG,'Starting Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1506: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1507:
1508: l_process_end_time := fnd_date.canonical_to_date(p_stop_time);
1509: l_worker_id := FND_GLOBAL.CONC_REQUEST_ID;

Line 1506: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

1502: Begin
1503:
1504: fnd_file.put_line(fnd_file.LOG,'Starting Worker Migration');
1505: fnd_file.put_line(fnd_file.LOG,'Starting Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1506: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1507:
1508: l_process_end_time := fnd_date.canonical_to_date(p_stop_time);
1509: l_worker_id := FND_GLOBAL.CONC_REQUEST_ID;
1510: l_parent_req_id := p_parent_req_id;

Line 1518: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

1514:
1515: if (p_migration_type ='TIMECARD') THEN
1516: loop
1517: if (is_process_time_over(l_process_end_time)) then
1518: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1519: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||
1520: l_time_summary_count);
1521: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);
1522: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

Line 1519: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||

1515: if (p_migration_type ='TIMECARD') THEN
1516: loop
1517: if (is_process_time_over(l_process_end_time)) then
1518: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1519: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||
1520: l_time_summary_count);
1521: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);
1522: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1523: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');

Line 1521: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);

1517: if (is_process_time_over(l_process_end_time)) then
1518: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1519: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||
1520: l_time_summary_count);
1521: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);
1522: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1523: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1524: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1525: delete from hxc_temp_timecards where worker_id = l_worker_id;

Line 1522: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

1518: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1519: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||
1520: l_time_summary_count);
1521: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);
1522: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1523: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1524: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1525: delete from hxc_temp_timecards where worker_id = l_worker_id;
1526: commit;

Line 1523: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');

1519: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||
1520: l_time_summary_count);
1521: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);
1522: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1523: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1524: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1525: delete from hxc_temp_timecards where worker_id = l_worker_id;
1526: commit;
1527: return;

Line 1524: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

1520: l_time_summary_count);
1521: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);
1522: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1523: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1524: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1525: delete from hxc_temp_timecards where worker_id = l_worker_id;
1526: commit;
1527: return;
1528: end if;

Line 1571: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

1567: open c_check_completion(l_parent_req_id);
1568: fetch c_check_completion
1569: into l_dummy;
1570: if c_check_completion%found then
1571: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1572: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1573: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);
1574: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1575: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');

Line 1572: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);

1568: fetch c_check_completion
1569: into l_dummy;
1570: if c_check_completion%found then
1571: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1572: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1573: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);
1574: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1575: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1576: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

Line 1573: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);

1569: into l_dummy;
1570: if c_check_completion%found then
1571: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1572: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1573: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);
1574: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1575: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1576: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1577: commit;

Line 1574: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

1570: if c_check_completion%found then
1571: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1572: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1573: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);
1574: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1575: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1576: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1577: commit;
1578: close c_check_completion;

Line 1575: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');

1571: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1572: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1573: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);
1574: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1575: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1576: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1577: commit;
1578: close c_check_completion;
1579: return;

Line 1576: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

1572: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1573: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);
1574: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1575: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1576: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1577: commit;
1578: close c_check_completion;
1579: return;
1580: end if;

Line 1591: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

1587: ,dev_status => l_dev_status
1588: ,message => l_message);
1589:
1590: if (l_dev_Phase = 'COMPLETE') then
1591: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1592: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1593: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);
1594: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1595: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');

Line 1592: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);

1588: ,message => l_message);
1589:
1590: if (l_dev_Phase = 'COMPLETE') then
1591: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1592: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1593: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);
1594: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1595: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1596: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

Line 1593: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);

1589:
1590: if (l_dev_Phase = 'COMPLETE') then
1591: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1592: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1593: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);
1594: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1595: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1596: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1597: commit;

Line 1594: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

1590: if (l_dev_Phase = 'COMPLETE') then
1591: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1592: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1593: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);
1594: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1595: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1596: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1597: commit;
1598: return;

Line 1595: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');

1591: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1592: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1593: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);
1594: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1595: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1596: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1597: commit;
1598: return;
1599: end if;

Line 1596: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

1592: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1593: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);
1594: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1595: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1596: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1597: commit;
1598: return;
1599: end if;
1600:

Line 1606: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

1602: end loop;
1603: elsif (p_migration_type ='TEMPLATE') THEN
1604: loop
1605: if (is_process_time_over(l_process_end_time)) then
1606: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1607: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||
1608: l_time_summary_count);
1609: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1610: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');

Line 1607: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||

1603: elsif (p_migration_type ='TEMPLATE') THEN
1604: loop
1605: if (is_process_time_over(l_process_end_time)) then
1606: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1607: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||
1608: l_time_summary_count);
1609: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1610: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1611: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

Line 1609: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

1605: if (is_process_time_over(l_process_end_time)) then
1606: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1607: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||
1608: l_time_summary_count);
1609: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1610: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1611: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1612: delete from hxc_temp_timecards where worker_id = l_worker_id;
1613: commit;

Line 1610: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');

1606: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1607: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||
1608: l_time_summary_count);
1609: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1610: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1611: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1612: delete from hxc_temp_timecards where worker_id = l_worker_id;
1613: commit;
1614: return;

Line 1611: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

1607: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||
1608: l_time_summary_count);
1609: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1610: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1611: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1612: delete from hxc_temp_timecards where worker_id = l_worker_id;
1613: commit;
1614: return;
1615: end if;

Line 1646: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

1642: open c_check_completion(l_parent_req_id);
1643: fetch c_check_completion
1644: into l_dummy;
1645: if c_check_completion%found then
1646: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1647: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1648: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1649: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1650: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

Line 1647: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);

1643: fetch c_check_completion
1644: into l_dummy;
1645: if c_check_completion%found then
1646: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1647: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1648: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1649: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1650: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1651: commit;

Line 1648: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

1644: into l_dummy;
1645: if c_check_completion%found then
1646: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1647: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1648: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1649: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1650: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1651: commit;
1652: close c_check_completion;

Line 1649: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');

1645: if c_check_completion%found then
1646: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1647: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1648: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1649: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1650: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1651: commit;
1652: close c_check_completion;
1653: return;

Line 1650: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

1646: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1647: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1648: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1649: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1650: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1651: commit;
1652: close c_check_completion;
1653: return;
1654: end if;

Line 1665: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

1661: ,dev_status => l_dev_status
1662: ,message => l_message);
1663:
1664: if (l_dev_Phase = 'COMPLETE') then
1665: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1666: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1667: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1668: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1669: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

Line 1666: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);

1662: ,message => l_message);
1663:
1664: if (l_dev_Phase = 'COMPLETE') then
1665: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1666: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1667: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1668: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1669: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1670: commit;

Line 1667: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');

1663:
1664: if (l_dev_Phase = 'COMPLETE') then
1665: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1666: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1667: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1668: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1669: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1670: commit;
1671: return;

Line 1668: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');

1664: if (l_dev_Phase = 'COMPLETE') then
1665: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1666: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1667: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1668: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1669: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1670: commit;
1671: return;
1672: end if;

Line 1669: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));

1665: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1666: fnd_file.put_line(fnd_file.LOG,'Number of Summary Records Processed :' ||l_time_summary_count);
1667: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1668: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1669: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1670: commit;
1671: return;
1672: end if;
1673: