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 337: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');

333: SET status = 'ON_LINE', validation_status = 'E'
334: WHERE data_set_id = p_data_set_id;
335:
336: ELSE
337: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');
338: fnd_file.put_line(fnd_file.LOG,' Either one of the threads failed or there is a data issue ');
339: fnd_file.put_line(fnd_file.LOG,' Please run the process once again to reprocess the failed ');
340: fnd_file.put_line(fnd_file.LOG,' timecards. ');
341: fnd_file.put_line(fnd_file.LOG,' ');

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

334: WHERE data_set_id = p_data_set_id;
335:
336: ELSE
337: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');
338: fnd_file.put_line(fnd_file.LOG,' Either one of the threads failed or there is a data issue ');
339: fnd_file.put_line(fnd_file.LOG,' Please run the process once again to reprocess the failed ');
340: fnd_file.put_line(fnd_file.LOG,' timecards. ');
341: fnd_file.put_line(fnd_file.LOG,' ');
342:

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

335:
336: ELSE
337: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');
338: fnd_file.put_line(fnd_file.LOG,' Either one of the threads failed or there is a data issue ');
339: fnd_file.put_line(fnd_file.LOG,' Please run the process once again to reprocess the failed ');
340: fnd_file.put_line(fnd_file.LOG,' timecards. ');
341: fnd_file.put_line(fnd_file.LOG,' ');
342:
343: END IF;

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

336: ELSE
337: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');
338: fnd_file.put_line(fnd_file.LOG,' Either one of the threads failed or there is a data issue ');
339: fnd_file.put_line(fnd_file.LOG,' Please run the process once again to reprocess the failed ');
340: fnd_file.put_line(fnd_file.LOG,' timecards. ');
341: fnd_file.put_line(fnd_file.LOG,' ');
342:
343: END IF;
344:

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

337: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');
338: fnd_file.put_line(fnd_file.LOG,' Either one of the threads failed or there is a data issue ');
339: fnd_file.put_line(fnd_file.LOG,' Please run the process once again to reprocess the failed ');
340: fnd_file.put_line(fnd_file.LOG,' timecards. ');
341: fnd_file.put_line(fnd_file.LOG,' ');
342:
343: END IF;
344:
345:

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

349:
350: l_debug_info := ' ';
351: IF fnd_profile.value('HXC_AR_ENABLE_LOG') = 'Y'
352: THEN
353: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
354: fnd_file.put_line(fnd_file.LOG,'======================================');
355: fnd_file.put_line(fnd_file.LOG,' ');
356: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
357: fnd_file.put_line(fnd_file.LOG,' ');

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

350: l_debug_info := ' ';
351: IF fnd_profile.value('HXC_AR_ENABLE_LOG') = 'Y'
352: THEN
353: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
354: fnd_file.put_line(fnd_file.LOG,'======================================');
355: fnd_file.put_line(fnd_file.LOG,' ');
356: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
357: fnd_file.put_line(fnd_file.LOG,' ');
358: FOR log_rec IN get_log_details

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

351: IF fnd_profile.value('HXC_AR_ENABLE_LOG') = 'Y'
352: THEN
353: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
354: fnd_file.put_line(fnd_file.LOG,'======================================');
355: fnd_file.put_line(fnd_file.LOG,' ');
356: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
357: fnd_file.put_line(fnd_file.LOG,' ');
358: FOR log_rec IN get_log_details
359: LOOP

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

352: THEN
353: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
354: fnd_file.put_line(fnd_file.LOG,'======================================');
355: fnd_file.put_line(fnd_file.LOG,' ');
356: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
357: fnd_file.put_line(fnd_file.LOG,' ');
358: FOR log_rec IN get_log_details
359: LOOP
360: IF l_debug_info <> log_rec.detail

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

353: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
354: fnd_file.put_line(fnd_file.LOG,'======================================');
355: fnd_file.put_line(fnd_file.LOG,' ');
356: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
357: fnd_file.put_line(fnd_file.LOG,' ');
358: FOR log_rec IN get_log_details
359: LOOP
360: IF l_debug_info <> log_rec.detail
361: THEN

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

358: FOR log_rec IN get_log_details
359: LOOP
360: IF l_debug_info <> log_rec.detail
361: THEN
362: fnd_file.put_line(fnd_file.log,' ---- ');
363: l_debug_info := log_rec.detail;
364: END IF;
365: hr_utility.trace(log_rec.resource_id||' - '||log_rec.start_time||
366: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');

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

363: l_debug_info := log_rec.detail;
364: END IF;
365: hr_utility.trace(log_rec.resource_id||' - '||log_rec.start_time||
366: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
367: fnd_file.put_line(fnd_file.log,log_rec.resource_id||' - '||log_rec.start_time||
368: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
369: END LOOP;
370:
371: l_debug_info := ' ';

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

368: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
369: END LOOP;
370:
371: l_debug_info := ' ';
372: fnd_file.put_line(fnd_file.LOG,' ');
373: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
374: fnd_file.put_line(fnd_file.LOG,'======================================');
375: fnd_file.put_line(fnd_file.LOG,' ');
376: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');

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

369: END LOOP;
370:
371: l_debug_info := ' ';
372: fnd_file.put_line(fnd_file.LOG,' ');
373: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
374: fnd_file.put_line(fnd_file.LOG,'======================================');
375: fnd_file.put_line(fnd_file.LOG,' ');
376: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
377: fnd_file.put_line(fnd_file.LOG,' ');

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

370:
371: l_debug_info := ' ';
372: fnd_file.put_line(fnd_file.LOG,' ');
373: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
374: fnd_file.put_line(fnd_file.LOG,'======================================');
375: fnd_file.put_line(fnd_file.LOG,' ');
376: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
377: fnd_file.put_line(fnd_file.LOG,' ');
378: FOR log_rec IN get_log_details_failed

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

371: l_debug_info := ' ';
372: fnd_file.put_line(fnd_file.LOG,' ');
373: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
374: fnd_file.put_line(fnd_file.LOG,'======================================');
375: fnd_file.put_line(fnd_file.LOG,' ');
376: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
377: fnd_file.put_line(fnd_file.LOG,' ');
378: FOR log_rec IN get_log_details_failed
379: LOOP

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

372: fnd_file.put_line(fnd_file.LOG,' ');
373: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
374: fnd_file.put_line(fnd_file.LOG,'======================================');
375: fnd_file.put_line(fnd_file.LOG,' ');
376: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
377: fnd_file.put_line(fnd_file.LOG,' ');
378: FOR log_rec IN get_log_details_failed
379: LOOP
380: IF l_debug_info <> log_rec.detail

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

373: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
374: fnd_file.put_line(fnd_file.LOG,'======================================');
375: fnd_file.put_line(fnd_file.LOG,' ');
376: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
377: fnd_file.put_line(fnd_file.LOG,' ');
378: FOR log_rec IN get_log_details_failed
379: LOOP
380: IF l_debug_info <> log_rec.detail
381: THEN

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

378: FOR log_rec IN get_log_details_failed
379: LOOP
380: IF l_debug_info <> log_rec.detail
381: THEN
382: fnd_file.put_line(fnd_file.log,' ---- ');
383: l_debug_info := log_rec.detail;
384: END IF;
385: hr_utility.trace(log_rec.resource_id||' - '||log_rec.start_time||
386: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');

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

383: l_debug_info := log_rec.detail;
384: END IF;
385: hr_utility.trace(log_rec.resource_id||' - '||log_rec.start_time||
386: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
387: fnd_file.put_line(fnd_file.log,log_rec.resource_id||' - '||log_rec.start_time||
388: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
389: END LOOP;
390:
391:

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

585: hr_general.g_data_migrator_mode := 'Y';
586:
587: l_chunk_size := nvl(fnd_profile.value('HXC_ARCHIVE_RESTORE_CHUNK_SIZE'),50);
588:
589: fnd_file.put_line(fnd_file.log,'--- > Chunk Size is: '||l_chunk_size);
590:
591:
592: SELECT start_date,
593: end_date

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

613: data_mismatch := FALSE;
614: iloop := 1;
615: l_chunk_no := l_chunk_no + 1;
616:
617: fnd_file.put_line(fnd_file.log,' ');
618: fnd_file.put_line(fnd_file.log,'*****************************************************************');
619: fnd_file.put_line(fnd_file.log,'=================================================================');
620: fnd_file.put_line(fnd_file.log,'Entering in a new chunk l_tbb_id_tab.count ');
621: fnd_file.put_line(fnd_file.log,'==================================================================');

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

614: iloop := 1;
615: l_chunk_no := l_chunk_no + 1;
616:
617: fnd_file.put_line(fnd_file.log,' ');
618: fnd_file.put_line(fnd_file.log,'*****************************************************************');
619: fnd_file.put_line(fnd_file.log,'=================================================================');
620: fnd_file.put_line(fnd_file.log,'Entering in a new chunk l_tbb_id_tab.count ');
621: fnd_file.put_line(fnd_file.log,'==================================================================');
622:

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

615: l_chunk_no := l_chunk_no + 1;
616:
617: fnd_file.put_line(fnd_file.log,' ');
618: fnd_file.put_line(fnd_file.log,'*****************************************************************');
619: fnd_file.put_line(fnd_file.log,'=================================================================');
620: fnd_file.put_line(fnd_file.log,'Entering in a new chunk l_tbb_id_tab.count ');
621: fnd_file.put_line(fnd_file.log,'==================================================================');
622:
623:

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

616:
617: fnd_file.put_line(fnd_file.log,' ');
618: fnd_file.put_line(fnd_file.log,'*****************************************************************');
619: fnd_file.put_line(fnd_file.log,'=================================================================');
620: fnd_file.put_line(fnd_file.log,'Entering in a new chunk l_tbb_id_tab.count ');
621: fnd_file.put_line(fnd_file.log,'==================================================================');
622:
623:
624: << TO_CONTINUE_TO_NEXT_CHUNK >>

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

617: fnd_file.put_line(fnd_file.log,' ');
618: fnd_file.put_line(fnd_file.log,'*****************************************************************');
619: fnd_file.put_line(fnd_file.log,'=================================================================');
620: fnd_file.put_line(fnd_file.log,'Entering in a new chunk l_tbb_id_tab.count ');
621: fnd_file.put_line(fnd_file.log,'==================================================================');
622:
623:
624: << TO_CONTINUE_TO_NEXT_CHUNK >>
625: WHILE iloop = 1

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

1400:
1401:
1402:
1403:
1404: fnd_file.put_line(fnd_file.log,' ');
1405: fnd_file.put_line(fnd_file.log,' ');
1406: fnd_file.put_line(fnd_file.log,' ');
1407: fnd_file.put_line(fnd_file.log,' ');
1408: fnd_file.put_line(fnd_file.log,' ');

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

1401:
1402:
1403:
1404: fnd_file.put_line(fnd_file.log,' ');
1405: fnd_file.put_line(fnd_file.log,' ');
1406: fnd_file.put_line(fnd_file.log,' ');
1407: fnd_file.put_line(fnd_file.log,' ');
1408: fnd_file.put_line(fnd_file.log,' ');
1409:

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

1402:
1403:
1404: fnd_file.put_line(fnd_file.log,' ');
1405: fnd_file.put_line(fnd_file.log,' ');
1406: fnd_file.put_line(fnd_file.log,' ');
1407: fnd_file.put_line(fnd_file.log,' ');
1408: fnd_file.put_line(fnd_file.log,' ');
1409:
1410: fnd_file.put_line(fnd_file.log,'*****************************************');

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

1403:
1404: fnd_file.put_line(fnd_file.log,' ');
1405: fnd_file.put_line(fnd_file.log,' ');
1406: fnd_file.put_line(fnd_file.log,' ');
1407: fnd_file.put_line(fnd_file.log,' ');
1408: fnd_file.put_line(fnd_file.log,' ');
1409:
1410: fnd_file.put_line(fnd_file.log,'*****************************************');
1411: fnd_file.put_line(fnd_file.log,' ');

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

1404: fnd_file.put_line(fnd_file.log,' ');
1405: fnd_file.put_line(fnd_file.log,' ');
1406: fnd_file.put_line(fnd_file.log,' ');
1407: fnd_file.put_line(fnd_file.log,' ');
1408: fnd_file.put_line(fnd_file.log,' ');
1409:
1410: fnd_file.put_line(fnd_file.log,'*****************************************');
1411: fnd_file.put_line(fnd_file.log,' ');
1412: COMMIT;

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

1406: fnd_file.put_line(fnd_file.log,' ');
1407: fnd_file.put_line(fnd_file.log,' ');
1408: fnd_file.put_line(fnd_file.log,' ');
1409:
1410: fnd_file.put_line(fnd_file.log,'*****************************************');
1411: fnd_file.put_line(fnd_file.log,' ');
1412: COMMIT;
1413: tc_id_tab.DELETE;
1414: tc_ovn_tab.DELETE;

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

1407: fnd_file.put_line(fnd_file.log,' ');
1408: fnd_file.put_line(fnd_file.log,' ');
1409:
1410: fnd_file.put_line(fnd_file.log,'*****************************************');
1411: fnd_file.put_line(fnd_file.log,' ');
1412: COMMIT;
1413: tc_id_tab.DELETE;
1414: tc_ovn_tab.DELETE;
1415: iloop:= 0;

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

1416: EXCEPTION
1417: WHEN DUP_VAL_ON_INDEX THEN
1418: ROLLBACK;
1419: iloop := 1;
1420: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention, will sleep for a minute ');
1421: fnd_file.put_line(fnd_file.log,'=================================================================');
1422: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1423: fnd_file.put_line(fnd_file.log,'==================================================================');
1424: l_td_count := 0;

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

1417: WHEN DUP_VAL_ON_INDEX THEN
1418: ROLLBACK;
1419: iloop := 1;
1420: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention, will sleep for a minute ');
1421: fnd_file.put_line(fnd_file.log,'=================================================================');
1422: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1423: fnd_file.put_line(fnd_file.log,'==================================================================');
1424: l_td_count := 0;
1425: l_trans_count := 0;

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

1418: ROLLBACK;
1419: iloop := 1;
1420: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention, will sleep for a minute ');
1421: fnd_file.put_line(fnd_file.log,'=================================================================');
1422: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1423: fnd_file.put_line(fnd_file.log,'==================================================================');
1424: l_td_count := 0;
1425: l_trans_count := 0;
1426: l_tau_count := 0;

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

1419: iloop := 1;
1420: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention, will sleep for a minute ');
1421: fnd_file.put_line(fnd_file.log,'=================================================================');
1422: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1423: fnd_file.put_line(fnd_file.log,'==================================================================');
1424: l_td_count := 0;
1425: l_trans_count := 0;
1426: l_tau_count := 0;
1427: l_ta_count := 0;

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

1429: dbms_lock.sleep(60);
1430: WHEN DEADLOCK_DETECTED THEN
1431: ROLLBACK;
1432: iloop := 1;
1433: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');
1434: fnd_file.put_line(fnd_file.log,'=================================================================');
1435: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1436: fnd_file.put_line(fnd_file.log,'==================================================================');
1437: l_td_count := 0;

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

1430: WHEN DEADLOCK_DETECTED THEN
1431: ROLLBACK;
1432: iloop := 1;
1433: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');
1434: fnd_file.put_line(fnd_file.log,'=================================================================');
1435: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1436: fnd_file.put_line(fnd_file.log,'==================================================================');
1437: l_td_count := 0;
1438: l_trans_count := 0;

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

1431: ROLLBACK;
1432: iloop := 1;
1433: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');
1434: fnd_file.put_line(fnd_file.log,'=================================================================');
1435: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1436: fnd_file.put_line(fnd_file.log,'==================================================================');
1437: l_td_count := 0;
1438: l_trans_count := 0;
1439: l_tau_count := 0;

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

1432: iloop := 1;
1433: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');
1434: fnd_file.put_line(fnd_file.log,'=================================================================');
1435: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1436: fnd_file.put_line(fnd_file.log,'==================================================================');
1437: l_td_count := 0;
1438: l_trans_count := 0;
1439: l_tau_count := 0;
1440: l_ta_count := 0;

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

1457:
1458: BEGIN
1459: IF p_insert = p_delete
1460: THEN
1461: fnd_file.put_line(fnd_file.log,' ');
1462: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1463: ELSE
1464: fnd_file.put_line(fnd_file.log,' ');
1465: fnd_file.put_line(fnd_file.log,'==========================================================================');

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

1458: BEGIN
1459: IF p_insert = p_delete
1460: THEN
1461: fnd_file.put_line(fnd_file.log,' ');
1462: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1463: ELSE
1464: fnd_file.put_line(fnd_file.log,' ');
1465: fnd_file.put_line(fnd_file.log,'==========================================================================');
1466: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');

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

1460: THEN
1461: fnd_file.put_line(fnd_file.log,' ');
1462: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1463: ELSE
1464: fnd_file.put_line(fnd_file.log,' ');
1465: fnd_file.put_line(fnd_file.log,'==========================================================================');
1466: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1467: fnd_file.put_line(fnd_file.log,'==========================================================================');
1468: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into online table ');

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

1461: fnd_file.put_line(fnd_file.log,' ');
1462: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1463: ELSE
1464: fnd_file.put_line(fnd_file.log,' ');
1465: fnd_file.put_line(fnd_file.log,'==========================================================================');
1466: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1467: fnd_file.put_line(fnd_file.log,'==========================================================================');
1468: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into online table ');
1469: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from offline table ');

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

1462: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1463: ELSE
1464: fnd_file.put_line(fnd_file.log,' ');
1465: fnd_file.put_line(fnd_file.log,'==========================================================================');
1466: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1467: fnd_file.put_line(fnd_file.log,'==========================================================================');
1468: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into online table ');
1469: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from offline table ');
1470: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');

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

1463: ELSE
1464: fnd_file.put_line(fnd_file.log,' ');
1465: fnd_file.put_line(fnd_file.log,'==========================================================================');
1466: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1467: fnd_file.put_line(fnd_file.log,'==========================================================================');
1468: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into online table ');
1469: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from offline table ');
1470: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');
1471: p_mismatch := TRUE;

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

1464: fnd_file.put_line(fnd_file.log,' ');
1465: fnd_file.put_line(fnd_file.log,'==========================================================================');
1466: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1467: fnd_file.put_line(fnd_file.log,'==========================================================================');
1468: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into online table ');
1469: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from offline table ');
1470: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');
1471: p_mismatch := TRUE;
1472: ROLLBACK;

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

1465: fnd_file.put_line(fnd_file.log,'==========================================================================');
1466: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1467: fnd_file.put_line(fnd_file.log,'==========================================================================');
1468: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into online table ');
1469: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from offline table ');
1470: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');
1471: p_mismatch := TRUE;
1472: ROLLBACK;
1473: END IF;

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

1466: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1467: fnd_file.put_line(fnd_file.log,'==========================================================================');
1468: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into online table ');
1469: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from offline table ');
1470: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');
1471: p_mismatch := TRUE;
1472: ROLLBACK;
1473: END IF;
1474: