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

Line 123: fnd_file.put_line(fnd_file.log,'--- > Chunk Size is: '||l_chunk_size);

119: hr_general.g_data_migrator_mode := 'Y';
120:
121: l_chunk_size := nvl(fnd_profile.value('HXC_ARCHIVE_RESTORE_CHUNK_SIZE'),50);
122:
123: fnd_file.put_line(fnd_file.log,'--- > Chunk Size is: '||l_chunk_size);
124:
125: -- Update hxc_data_sets as RESTORE_IN_PROGRESS because the process is going to take some time.
126:
127: UPDATE hxc_data_sets

Line 198: fnd_file.put_line(fnd_file.log,'Following are the bb id ranges for the threads ');

194:
195: l_start := 1;
196: l_stop := l_tc_chunk ;
197: id_stop := bb_id_tab(l_start);
198: fnd_file.put_line(fnd_file.log,'Following are the bb id ranges for the threads ');
199: fnd_file.put_line(fnd_file.log,'==============================================');
200: FOR i IN 1..4
201: LOOP
202: -- Calculate the start and stop ids and launch the threads.

Line 199: fnd_file.put_line(fnd_file.log,'==============================================');

195: l_start := 1;
196: l_stop := l_tc_chunk ;
197: id_stop := bb_id_tab(l_start);
198: fnd_file.put_line(fnd_file.log,'Following are the bb id ranges for the threads ');
199: fnd_file.put_line(fnd_file.log,'==============================================');
200: FOR i IN 1..4
201: LOOP
202: -- Calculate the start and stop ids and launch the threads.
203: -- ( 1- 4 threads get launched in this loop

Line 216: fnd_file.put_line(fnd_file.log,id_start||' -> '||id_stop);

212: argument1 => id_start,
213: argument2 => id_stop,
214: argument3 => p_data_set_id,
215: argument4 => i );
216: fnd_file.put_line(fnd_file.log,id_start||' -> '||id_stop);
217: COMMIT;
218: l_stop := l_stop + l_tc_chunk ;
219: IF l_stop > l_tc_count
220: THEN

Line 228: fnd_file.put_line(fnd_file.log,id_start||' -> '||id_stop);

224:
225: id_start := id_stop;
226: id_stop := bb_id_tab(bb_id_tab.LAST)+1;
227:
228: fnd_file.put_line(fnd_file.log,id_start||' -> '||id_stop);
229:
230: l_req_id_tab(5) := FND_REQUEST.SUBMIT_REQUEST( application => 'HXC',
231: program => 'HXCRESCHILD',
232: description => NULL,

Line 270: fnd_file.put_line(fnd_file.log,i||'th request failed');

266: l_message);
267:
268: IF l_call_status = FALSE
269: THEN
270: fnd_file.put_line(fnd_file.log,i||'th request failed');
271: l_thread_success := FALSE;
272: END IF;
273: IF l_dev_phase <> 'COMPLETE'
274: THEN

Line 345: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');

341: SET status = 'ON_LINE', validation_status = 'E'
342: WHERE data_set_id = p_data_set_id;
343:
344: ELSE
345: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');
346: fnd_file.put_line(fnd_file.LOG,' Either one of the threads failed or there is a data issue ');
347: fnd_file.put_line(fnd_file.LOG,' Please run the process once again to reprocess the failed ');
348: fnd_file.put_line(fnd_file.LOG,' timecards. ');
349: fnd_file.put_line(fnd_file.LOG,' ');

Line 346: fnd_file.put_line(fnd_file.LOG,' Either one of the threads failed or there is a data issue ');

342: WHERE data_set_id = p_data_set_id;
343:
344: ELSE
345: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');
346: fnd_file.put_line(fnd_file.LOG,' Either one of the threads failed or there is a data issue ');
347: fnd_file.put_line(fnd_file.LOG,' Please run the process once again to reprocess the failed ');
348: fnd_file.put_line(fnd_file.LOG,' timecards. ');
349: fnd_file.put_line(fnd_file.LOG,' ');
350:

Line 347: fnd_file.put_line(fnd_file.LOG,' Please run the process once again to reprocess the failed ');

343:
344: ELSE
345: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');
346: fnd_file.put_line(fnd_file.LOG,' Either one of the threads failed or there is a data issue ');
347: fnd_file.put_line(fnd_file.LOG,' Please run the process once again to reprocess the failed ');
348: fnd_file.put_line(fnd_file.LOG,' timecards. ');
349: fnd_file.put_line(fnd_file.LOG,' ');
350:
351: END IF;

Line 348: fnd_file.put_line(fnd_file.LOG,' timecards. ');

344: ELSE
345: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');
346: fnd_file.put_line(fnd_file.LOG,' Either one of the threads failed or there is a data issue ');
347: fnd_file.put_line(fnd_file.LOG,' Please run the process once again to reprocess the failed ');
348: fnd_file.put_line(fnd_file.LOG,' timecards. ');
349: fnd_file.put_line(fnd_file.LOG,' ');
350:
351: END IF;
352:

Line 349: fnd_file.put_line(fnd_file.LOG,' ');

345: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');
346: fnd_file.put_line(fnd_file.LOG,' Either one of the threads failed or there is a data issue ');
347: fnd_file.put_line(fnd_file.LOG,' Please run the process once again to reprocess the failed ');
348: fnd_file.put_line(fnd_file.LOG,' timecards. ');
349: fnd_file.put_line(fnd_file.LOG,' ');
350:
351: END IF;
352:
353:

Line 361: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');

357:
358: l_debug_info := ' ';
359: IF fnd_profile.value('HXC_AR_ENABLE_LOG') = 'Y'
360: THEN
361: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
362: fnd_file.put_line(fnd_file.LOG,'======================================');
363: fnd_file.put_line(fnd_file.LOG,' ');
364: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
365: fnd_file.put_line(fnd_file.LOG,' ');

Line 362: fnd_file.put_line(fnd_file.LOG,'======================================');

358: l_debug_info := ' ';
359: IF fnd_profile.value('HXC_AR_ENABLE_LOG') = 'Y'
360: THEN
361: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
362: fnd_file.put_line(fnd_file.LOG,'======================================');
363: fnd_file.put_line(fnd_file.LOG,' ');
364: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
365: fnd_file.put_line(fnd_file.LOG,' ');
366: FOR log_rec IN get_log_details

Line 363: fnd_file.put_line(fnd_file.LOG,' ');

359: IF fnd_profile.value('HXC_AR_ENABLE_LOG') = 'Y'
360: THEN
361: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
362: fnd_file.put_line(fnd_file.LOG,'======================================');
363: fnd_file.put_line(fnd_file.LOG,' ');
364: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
365: fnd_file.put_line(fnd_file.LOG,' ');
366: FOR log_rec IN get_log_details
367: LOOP

Line 364: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');

360: THEN
361: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
362: fnd_file.put_line(fnd_file.LOG,'======================================');
363: fnd_file.put_line(fnd_file.LOG,' ');
364: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
365: fnd_file.put_line(fnd_file.LOG,' ');
366: FOR log_rec IN get_log_details
367: LOOP
368: IF l_debug_info <> log_rec.detail

Line 365: fnd_file.put_line(fnd_file.LOG,' ');

361: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
362: fnd_file.put_line(fnd_file.LOG,'======================================');
363: fnd_file.put_line(fnd_file.LOG,' ');
364: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
365: fnd_file.put_line(fnd_file.LOG,' ');
366: FOR log_rec IN get_log_details
367: LOOP
368: IF l_debug_info <> log_rec.detail
369: THEN

Line 370: fnd_file.put_line(fnd_file.log,' ---- ');

366: FOR log_rec IN get_log_details
367: LOOP
368: IF l_debug_info <> log_rec.detail
369: THEN
370: fnd_file.put_line(fnd_file.log,' ---- ');
371: l_debug_info := log_rec.detail;
372: END IF;
373: hr_utility.trace(log_rec.resource_id||' - '||log_rec.start_time||
374: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');

Line 375: fnd_file.put_line(fnd_file.log,log_rec.resource_id||' - '||log_rec.start_time||

371: l_debug_info := log_rec.detail;
372: END IF;
373: hr_utility.trace(log_rec.resource_id||' - '||log_rec.start_time||
374: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
375: fnd_file.put_line(fnd_file.log,log_rec.resource_id||' - '||log_rec.start_time||
376: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
377: END LOOP;
378:
379: l_debug_info := ' ';

Line 380: fnd_file.put_line(fnd_file.LOG,' ');

376: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
377: END LOOP;
378:
379: l_debug_info := ' ';
380: fnd_file.put_line(fnd_file.LOG,' ');
381: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
382: fnd_file.put_line(fnd_file.LOG,'======================================');
383: fnd_file.put_line(fnd_file.LOG,' ');
384: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');

Line 381: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');

377: END LOOP;
378:
379: l_debug_info := ' ';
380: fnd_file.put_line(fnd_file.LOG,' ');
381: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
382: fnd_file.put_line(fnd_file.LOG,'======================================');
383: fnd_file.put_line(fnd_file.LOG,' ');
384: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
385: fnd_file.put_line(fnd_file.LOG,' ');

Line 382: fnd_file.put_line(fnd_file.LOG,'======================================');

378:
379: l_debug_info := ' ';
380: fnd_file.put_line(fnd_file.LOG,' ');
381: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
382: fnd_file.put_line(fnd_file.LOG,'======================================');
383: fnd_file.put_line(fnd_file.LOG,' ');
384: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
385: fnd_file.put_line(fnd_file.LOG,' ');
386: FOR log_rec IN get_log_details_failed

Line 383: fnd_file.put_line(fnd_file.LOG,' ');

379: l_debug_info := ' ';
380: fnd_file.put_line(fnd_file.LOG,' ');
381: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
382: fnd_file.put_line(fnd_file.LOG,'======================================');
383: fnd_file.put_line(fnd_file.LOG,' ');
384: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
385: fnd_file.put_line(fnd_file.LOG,' ');
386: FOR log_rec IN get_log_details_failed
387: LOOP

Line 384: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');

380: fnd_file.put_line(fnd_file.LOG,' ');
381: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
382: fnd_file.put_line(fnd_file.LOG,'======================================');
383: fnd_file.put_line(fnd_file.LOG,' ');
384: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
385: fnd_file.put_line(fnd_file.LOG,' ');
386: FOR log_rec IN get_log_details_failed
387: LOOP
388: IF l_debug_info <> log_rec.detail

Line 385: fnd_file.put_line(fnd_file.LOG,' ');

381: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
382: fnd_file.put_line(fnd_file.LOG,'======================================');
383: fnd_file.put_line(fnd_file.LOG,' ');
384: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
385: fnd_file.put_line(fnd_file.LOG,' ');
386: FOR log_rec IN get_log_details_failed
387: LOOP
388: IF l_debug_info <> log_rec.detail
389: THEN

Line 390: fnd_file.put_line(fnd_file.log,' ---- ');

386: FOR log_rec IN get_log_details_failed
387: LOOP
388: IF l_debug_info <> log_rec.detail
389: THEN
390: fnd_file.put_line(fnd_file.log,' ---- ');
391: l_debug_info := log_rec.detail;
392: END IF;
393: hr_utility.trace(log_rec.resource_id||' - '||log_rec.start_time||
394: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');

Line 395: fnd_file.put_line(fnd_file.log,log_rec.resource_id||' - '||log_rec.start_time||

391: l_debug_info := log_rec.detail;
392: END IF;
393: hr_utility.trace(log_rec.resource_id||' - '||log_rec.start_time||
394: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
395: fnd_file.put_line(fnd_file.log,log_rec.resource_id||' - '||log_rec.start_time||
396: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
397: END LOOP;
398:
399:

Line 684: fnd_file.put_line(fnd_file.log,'--- > Chunk Size is: '||l_chunk_size);

680: hr_general.g_data_migrator_mode := 'Y';
681:
682: l_chunk_size := nvl(fnd_profile.value('HXC_ARCHIVE_RESTORE_CHUNK_SIZE'),50);
683:
684: fnd_file.put_line(fnd_file.log,'--- > Chunk Size is: '||l_chunk_size);
685:
686:
687: SELECT start_date,
688: end_date

Line 712: fnd_file.put_line(fnd_file.log,' ');

708: data_mismatch := FALSE;
709: iloop := 1;
710: l_chunk_no := l_chunk_no + 1;
711:
712: fnd_file.put_line(fnd_file.log,' ');
713: fnd_file.put_line(fnd_file.log,'*****************************************************************');
714: fnd_file.put_line(fnd_file.log,'=================================================================');
715: fnd_file.put_line(fnd_file.log,'Entering in a new chunk l_tbb_id_tab.count ');
716: fnd_file.put_line(fnd_file.log,'==================================================================');

Line 713: fnd_file.put_line(fnd_file.log,'*****************************************************************');

709: iloop := 1;
710: l_chunk_no := l_chunk_no + 1;
711:
712: fnd_file.put_line(fnd_file.log,' ');
713: fnd_file.put_line(fnd_file.log,'*****************************************************************');
714: fnd_file.put_line(fnd_file.log,'=================================================================');
715: fnd_file.put_line(fnd_file.log,'Entering in a new chunk l_tbb_id_tab.count ');
716: fnd_file.put_line(fnd_file.log,'==================================================================');
717:

Line 714: fnd_file.put_line(fnd_file.log,'=================================================================');

710: l_chunk_no := l_chunk_no + 1;
711:
712: fnd_file.put_line(fnd_file.log,' ');
713: fnd_file.put_line(fnd_file.log,'*****************************************************************');
714: fnd_file.put_line(fnd_file.log,'=================================================================');
715: fnd_file.put_line(fnd_file.log,'Entering in a new chunk l_tbb_id_tab.count ');
716: fnd_file.put_line(fnd_file.log,'==================================================================');
717:
718:

Line 715: fnd_file.put_line(fnd_file.log,'Entering in a new chunk l_tbb_id_tab.count ');

711:
712: fnd_file.put_line(fnd_file.log,' ');
713: fnd_file.put_line(fnd_file.log,'*****************************************************************');
714: fnd_file.put_line(fnd_file.log,'=================================================================');
715: fnd_file.put_line(fnd_file.log,'Entering in a new chunk l_tbb_id_tab.count ');
716: fnd_file.put_line(fnd_file.log,'==================================================================');
717:
718:
719: << TO_CONTINUE_TO_NEXT_CHUNK >>

Line 716: fnd_file.put_line(fnd_file.log,'==================================================================');

712: fnd_file.put_line(fnd_file.log,' ');
713: fnd_file.put_line(fnd_file.log,'*****************************************************************');
714: fnd_file.put_line(fnd_file.log,'=================================================================');
715: fnd_file.put_line(fnd_file.log,'Entering in a new chunk l_tbb_id_tab.count ');
716: fnd_file.put_line(fnd_file.log,'==================================================================');
717:
718:
719: << TO_CONTINUE_TO_NEXT_CHUNK >>
720: WHILE iloop = 1

Line 1925: fnd_file.put_line(fnd_file.log,' ');

1921: orgtab.DELETE;
1922: bgtab.DELETE;
1923:
1924:
1925: fnd_file.put_line(fnd_file.log,' ');
1926: fnd_file.put_line(fnd_file.log,' ');
1927: fnd_file.put_line(fnd_file.log,' ');
1928: fnd_file.put_line(fnd_file.log,' ');
1929: fnd_file.put_line(fnd_file.log,' ');

Line 1926: fnd_file.put_line(fnd_file.log,' ');

1922: bgtab.DELETE;
1923:
1924:
1925: fnd_file.put_line(fnd_file.log,' ');
1926: fnd_file.put_line(fnd_file.log,' ');
1927: fnd_file.put_line(fnd_file.log,' ');
1928: fnd_file.put_line(fnd_file.log,' ');
1929: fnd_file.put_line(fnd_file.log,' ');
1930:

Line 1927: fnd_file.put_line(fnd_file.log,' ');

1923:
1924:
1925: fnd_file.put_line(fnd_file.log,' ');
1926: fnd_file.put_line(fnd_file.log,' ');
1927: fnd_file.put_line(fnd_file.log,' ');
1928: fnd_file.put_line(fnd_file.log,' ');
1929: fnd_file.put_line(fnd_file.log,' ');
1930:
1931: fnd_file.put_line(fnd_file.log,'*****************************************');

Line 1928: fnd_file.put_line(fnd_file.log,' ');

1924:
1925: fnd_file.put_line(fnd_file.log,' ');
1926: fnd_file.put_line(fnd_file.log,' ');
1927: fnd_file.put_line(fnd_file.log,' ');
1928: fnd_file.put_line(fnd_file.log,' ');
1929: fnd_file.put_line(fnd_file.log,' ');
1930:
1931: fnd_file.put_line(fnd_file.log,'*****************************************');
1932: fnd_file.put_line(fnd_file.log,' ');

Line 1929: fnd_file.put_line(fnd_file.log,' ');

1925: fnd_file.put_line(fnd_file.log,' ');
1926: fnd_file.put_line(fnd_file.log,' ');
1927: fnd_file.put_line(fnd_file.log,' ');
1928: fnd_file.put_line(fnd_file.log,' ');
1929: fnd_file.put_line(fnd_file.log,' ');
1930:
1931: fnd_file.put_line(fnd_file.log,'*****************************************');
1932: fnd_file.put_line(fnd_file.log,' ');
1933: COMMIT;

Line 1931: fnd_file.put_line(fnd_file.log,'*****************************************');

1927: fnd_file.put_line(fnd_file.log,' ');
1928: fnd_file.put_line(fnd_file.log,' ');
1929: fnd_file.put_line(fnd_file.log,' ');
1930:
1931: fnd_file.put_line(fnd_file.log,'*****************************************');
1932: fnd_file.put_line(fnd_file.log,' ');
1933: COMMIT;
1934: tc_id_tab.DELETE;
1935: tc_ovn_tab.DELETE;

Line 1932: fnd_file.put_line(fnd_file.log,' ');

1928: fnd_file.put_line(fnd_file.log,' ');
1929: fnd_file.put_line(fnd_file.log,' ');
1930:
1931: fnd_file.put_line(fnd_file.log,'*****************************************');
1932: fnd_file.put_line(fnd_file.log,' ');
1933: COMMIT;
1934: tc_id_tab.DELETE;
1935: tc_ovn_tab.DELETE;
1936: iloop:= 0;

Line 1941: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention, will sleep for a minute ');

1937: EXCEPTION
1938: WHEN DUP_VAL_ON_INDEX THEN
1939: ROLLBACK;
1940: iloop := 1;
1941: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention, will sleep for a minute ');
1942: fnd_file.put_line(fnd_file.log,'=================================================================');
1943: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1944: fnd_file.put_line(fnd_file.log,'==================================================================');
1945: l_td_count := 0;

Line 1942: fnd_file.put_line(fnd_file.log,'=================================================================');

1938: WHEN DUP_VAL_ON_INDEX THEN
1939: ROLLBACK;
1940: iloop := 1;
1941: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention, will sleep for a minute ');
1942: fnd_file.put_line(fnd_file.log,'=================================================================');
1943: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1944: fnd_file.put_line(fnd_file.log,'==================================================================');
1945: l_td_count := 0;
1946: l_trans_count := 0;

Line 1943: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');

1939: ROLLBACK;
1940: iloop := 1;
1941: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention, will sleep for a minute ');
1942: fnd_file.put_line(fnd_file.log,'=================================================================');
1943: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1944: fnd_file.put_line(fnd_file.log,'==================================================================');
1945: l_td_count := 0;
1946: l_trans_count := 0;
1947: l_tau_count := 0;

Line 1944: fnd_file.put_line(fnd_file.log,'==================================================================');

1940: iloop := 1;
1941: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention, will sleep for a minute ');
1942: fnd_file.put_line(fnd_file.log,'=================================================================');
1943: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1944: fnd_file.put_line(fnd_file.log,'==================================================================');
1945: l_td_count := 0;
1946: l_trans_count := 0;
1947: l_tau_count := 0;
1948: l_ta_count := 0;

Line 1954: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');

1950: dbms_lock.sleep(60);
1951: WHEN DEADLOCK_DETECTED THEN
1952: ROLLBACK;
1953: iloop := 1;
1954: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');
1955: fnd_file.put_line(fnd_file.log,'=================================================================');
1956: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1957: fnd_file.put_line(fnd_file.log,'==================================================================');
1958: l_td_count := 0;

Line 1955: fnd_file.put_line(fnd_file.log,'=================================================================');

1951: WHEN DEADLOCK_DETECTED THEN
1952: ROLLBACK;
1953: iloop := 1;
1954: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');
1955: fnd_file.put_line(fnd_file.log,'=================================================================');
1956: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1957: fnd_file.put_line(fnd_file.log,'==================================================================');
1958: l_td_count := 0;
1959: l_trans_count := 0;

Line 1956: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');

1952: ROLLBACK;
1953: iloop := 1;
1954: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');
1955: fnd_file.put_line(fnd_file.log,'=================================================================');
1956: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1957: fnd_file.put_line(fnd_file.log,'==================================================================');
1958: l_td_count := 0;
1959: l_trans_count := 0;
1960: l_tau_count := 0;

Line 1957: fnd_file.put_line(fnd_file.log,'==================================================================');

1953: iloop := 1;
1954: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');
1955: fnd_file.put_line(fnd_file.log,'=================================================================');
1956: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1957: fnd_file.put_line(fnd_file.log,'==================================================================');
1958: l_td_count := 0;
1959: l_trans_count := 0;
1960: l_tau_count := 0;
1961: l_ta_count := 0;

Line 1982: fnd_file.put_line(fnd_file.log,' ');

1978:
1979: BEGIN
1980: IF p_insert = p_delete
1981: THEN
1982: fnd_file.put_line(fnd_file.log,' ');
1983: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1984: ELSE
1985: fnd_file.put_line(fnd_file.log,' ');
1986: fnd_file.put_line(fnd_file.log,'==========================================================================');

Line 1983: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);

1979: BEGIN
1980: IF p_insert = p_delete
1981: THEN
1982: fnd_file.put_line(fnd_file.log,' ');
1983: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1984: ELSE
1985: fnd_file.put_line(fnd_file.log,' ');
1986: fnd_file.put_line(fnd_file.log,'==========================================================================');
1987: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');

Line 1985: fnd_file.put_line(fnd_file.log,' ');

1981: THEN
1982: fnd_file.put_line(fnd_file.log,' ');
1983: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1984: ELSE
1985: fnd_file.put_line(fnd_file.log,' ');
1986: fnd_file.put_line(fnd_file.log,'==========================================================================');
1987: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1988: fnd_file.put_line(fnd_file.log,'==========================================================================');
1989: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into online table ');

Line 1986: fnd_file.put_line(fnd_file.log,'==========================================================================');

1982: fnd_file.put_line(fnd_file.log,' ');
1983: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1984: ELSE
1985: fnd_file.put_line(fnd_file.log,' ');
1986: fnd_file.put_line(fnd_file.log,'==========================================================================');
1987: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1988: fnd_file.put_line(fnd_file.log,'==========================================================================');
1989: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into online table ');
1990: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from offline table ');

Line 1987: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');

1983: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1984: ELSE
1985: fnd_file.put_line(fnd_file.log,' ');
1986: fnd_file.put_line(fnd_file.log,'==========================================================================');
1987: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1988: fnd_file.put_line(fnd_file.log,'==========================================================================');
1989: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into online table ');
1990: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from offline table ');
1991: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');

Line 1988: fnd_file.put_line(fnd_file.log,'==========================================================================');

1984: ELSE
1985: fnd_file.put_line(fnd_file.log,' ');
1986: fnd_file.put_line(fnd_file.log,'==========================================================================');
1987: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1988: fnd_file.put_line(fnd_file.log,'==========================================================================');
1989: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into online table ');
1990: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from offline table ');
1991: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');
1992: p_mismatch := TRUE;

Line 1989: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into online table ');

1985: fnd_file.put_line(fnd_file.log,' ');
1986: fnd_file.put_line(fnd_file.log,'==========================================================================');
1987: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1988: fnd_file.put_line(fnd_file.log,'==========================================================================');
1989: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into online table ');
1990: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from offline table ');
1991: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');
1992: p_mismatch := TRUE;
1993: ROLLBACK;

Line 1990: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from offline table ');

1986: fnd_file.put_line(fnd_file.log,'==========================================================================');
1987: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1988: fnd_file.put_line(fnd_file.log,'==========================================================================');
1989: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into online table ');
1990: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from offline table ');
1991: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');
1992: p_mismatch := TRUE;
1993: ROLLBACK;
1994: END IF;

Line 1991: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');

1987: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1988: fnd_file.put_line(fnd_file.log,'==========================================================================');
1989: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into online table ');
1990: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from offline table ');
1991: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');
1992: p_mismatch := TRUE;
1993: ROLLBACK;
1994: END IF;
1995: