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

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

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

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

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

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

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

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

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

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

228:
229: id_start := id_stop;
230: id_stop := bb_id_tab(bb_id_tab.LAST)+1;
231:
232: fnd_file.put_line(fnd_file.log,id_start||' -> '||id_stop);
233:
234: l_req_id_tab(5) := FND_REQUEST.SUBMIT_REQUEST( application => 'HXC',
235: program => 'HXCARCCHILD',
236: description => NULL,

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

249: -- records.
250: id_start := bb_id_tab(bb_id_tab.FIRST);
251: id_stop := bb_id_tab(bb_id_tab.LAST)+1;
252:
253: fnd_file.put_line(fnd_file.log,id_start||' -> '||id_stop);
254:
255: l_req_id_tab(5) := FND_REQUEST.SUBMIT_REQUEST( application => 'HXC',
256: program => 'HXCARCCHILD',
257: description => NULL,

Line 285: fnd_file.put_line(fnd_file.LOG,i||'th request failed');

281: l_message);
282:
283: IF l_call_status = FALSE
284: THEN
285: fnd_file.put_line(fnd_file.LOG,i||'th request failed');
286: l_thread_success := FALSE;
287: END IF;
288: IF l_dev_phase <> 'COMPLETE'
289: THEN

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

378: SET status = 'OFF_LINE', validation_status = ' '
379: WHERE data_set_id = p_data_set_id;
380:
381: ELSE
382: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');
383: fnd_file.put_line(fnd_file.LOG,' Either one of the threads failed or there is a data issue ');
384: fnd_file.put_line(fnd_file.LOG,' Please run the process again to reprocess the failed timecards ');
385: fnd_file.put_line(fnd_file.LOG,' ');
386:

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

379: WHERE data_set_id = p_data_set_id;
380:
381: ELSE
382: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');
383: fnd_file.put_line(fnd_file.LOG,' Either one of the threads failed or there is a data issue ');
384: fnd_file.put_line(fnd_file.LOG,' Please run the process again to reprocess the failed timecards ');
385: fnd_file.put_line(fnd_file.LOG,' ');
386:
387: END IF;

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

380:
381: ELSE
382: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');
383: fnd_file.put_line(fnd_file.LOG,' Either one of the threads failed or there is a data issue ');
384: fnd_file.put_line(fnd_file.LOG,' Please run the process again to reprocess the failed timecards ');
385: fnd_file.put_line(fnd_file.LOG,' ');
386:
387: END IF;
388:

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

381: ELSE
382: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');
383: fnd_file.put_line(fnd_file.LOG,' Either one of the threads failed or there is a data issue ');
384: fnd_file.put_line(fnd_file.LOG,' Please run the process again to reprocess the failed timecards ');
385: fnd_file.put_line(fnd_file.LOG,' ');
386:
387: END IF;
388:
389:

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

393: -- Check if the profile is set for detailed logging.
394: IF fnd_profile.value('HXC_AR_ENABLE_LOG') = 'Y'
395: THEN
396: -- Print out the log.
397: fnd_file.put_line(fnd_file.LOG,' ');
398: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
399: fnd_file.put_line(fnd_file.LOG,'======================================');
400: fnd_file.put_line(fnd_file.LOG,' ');
401: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');

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

394: IF fnd_profile.value('HXC_AR_ENABLE_LOG') = 'Y'
395: THEN
396: -- Print out the log.
397: fnd_file.put_line(fnd_file.LOG,' ');
398: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
399: fnd_file.put_line(fnd_file.LOG,'======================================');
400: fnd_file.put_line(fnd_file.LOG,' ');
401: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
402: fnd_file.put_line(fnd_file.LOG,' ');

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

395: THEN
396: -- Print out the log.
397: fnd_file.put_line(fnd_file.LOG,' ');
398: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
399: fnd_file.put_line(fnd_file.LOG,'======================================');
400: fnd_file.put_line(fnd_file.LOG,' ');
401: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
402: fnd_file.put_line(fnd_file.LOG,' ');
403: FOR log_rec IN get_log_details

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

396: -- Print out the log.
397: fnd_file.put_line(fnd_file.LOG,' ');
398: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
399: fnd_file.put_line(fnd_file.LOG,'======================================');
400: fnd_file.put_line(fnd_file.LOG,' ');
401: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
402: fnd_file.put_line(fnd_file.LOG,' ');
403: FOR log_rec IN get_log_details
404: LOOP

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

397: fnd_file.put_line(fnd_file.LOG,' ');
398: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
399: fnd_file.put_line(fnd_file.LOG,'======================================');
400: fnd_file.put_line(fnd_file.LOG,' ');
401: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
402: fnd_file.put_line(fnd_file.LOG,' ');
403: FOR log_rec IN get_log_details
404: LOOP
405: IF l_debug_info <> log_rec.detail

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

398: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
399: fnd_file.put_line(fnd_file.LOG,'======================================');
400: fnd_file.put_line(fnd_file.LOG,' ');
401: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
402: fnd_file.put_line(fnd_file.LOG,' ');
403: FOR log_rec IN get_log_details
404: LOOP
405: IF l_debug_info <> log_rec.detail
406: THEN

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

403: FOR log_rec IN get_log_details
404: LOOP
405: IF l_debug_info <> log_rec.detail
406: THEN
407: fnd_file.put_line(fnd_file.log,' ---- ');
408: l_debug_info := log_rec.detail;
409: END IF;
410: hr_utility.trace(log_rec.resource_id||' - '||log_rec.start_time||
411: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');

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

408: l_debug_info := log_rec.detail;
409: END IF;
410: hr_utility.trace(log_rec.resource_id||' - '||log_rec.start_time||
411: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
412: fnd_file.put_line(fnd_file.log,log_rec.resource_id||' - '||log_rec.start_time||
413: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
414: END LOOP;
415:
416: l_debug_info := ' ';

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

413: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
414: END LOOP;
415:
416: l_debug_info := ' ';
417: fnd_file.put_line(fnd_file.LOG,' ');
418: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
419: fnd_file.put_line(fnd_file.LOG,'==========================================');
420: fnd_file.put_line(fnd_file.LOG,' ');
421: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');

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

414: END LOOP;
415:
416: l_debug_info := ' ';
417: fnd_file.put_line(fnd_file.LOG,' ');
418: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
419: fnd_file.put_line(fnd_file.LOG,'==========================================');
420: fnd_file.put_line(fnd_file.LOG,' ');
421: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
422: fnd_file.put_line(fnd_file.LOG,' ');

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

415:
416: l_debug_info := ' ';
417: fnd_file.put_line(fnd_file.LOG,' ');
418: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
419: fnd_file.put_line(fnd_file.LOG,'==========================================');
420: fnd_file.put_line(fnd_file.LOG,' ');
421: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
422: fnd_file.put_line(fnd_file.LOG,' ');
423: FOR log_rec IN get_log_details_failed

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

416: l_debug_info := ' ';
417: fnd_file.put_line(fnd_file.LOG,' ');
418: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
419: fnd_file.put_line(fnd_file.LOG,'==========================================');
420: fnd_file.put_line(fnd_file.LOG,' ');
421: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
422: fnd_file.put_line(fnd_file.LOG,' ');
423: FOR log_rec IN get_log_details_failed
424: LOOP

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

417: fnd_file.put_line(fnd_file.LOG,' ');
418: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
419: fnd_file.put_line(fnd_file.LOG,'==========================================');
420: fnd_file.put_line(fnd_file.LOG,' ');
421: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
422: fnd_file.put_line(fnd_file.LOG,' ');
423: FOR log_rec IN get_log_details_failed
424: LOOP
425: IF l_debug_info <> log_rec.detail

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

418: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
419: fnd_file.put_line(fnd_file.LOG,'==========================================');
420: fnd_file.put_line(fnd_file.LOG,' ');
421: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
422: fnd_file.put_line(fnd_file.LOG,' ');
423: FOR log_rec IN get_log_details_failed
424: LOOP
425: IF l_debug_info <> log_rec.detail
426: THEN

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

423: FOR log_rec IN get_log_details_failed
424: LOOP
425: IF l_debug_info <> log_rec.detail
426: THEN
427: fnd_file.put_line(fnd_file.log,' ---- ');
428: l_debug_info := log_rec.detail;
429: END IF;
430: hr_utility.trace(log_rec.resource_id||' - '||log_rec.start_time||
431: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');

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

428: l_debug_info := log_rec.detail;
429: END IF;
430: hr_utility.trace(log_rec.resource_id||' - '||log_rec.start_time||
431: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
432: fnd_file.put_line(fnd_file.log,log_rec.resource_id||' - '||log_rec.start_time||
433: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
434: END LOOP;
435: END IF;
436:

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

734: hr_general.g_data_migrator_mode := 'Y';
735:
736: l_chunk_size := nvl(fnd_profile.value('HXC_ARCHIVE_RESTORE_CHUNK_SIZE'),50);
737:
738: fnd_file.put_line(fnd_file.LOG,'--- > Chunk Size is: '||l_chunk_size);
739:
740: -- firs let's get the min start time of
741: -- the timecard for this data set
742:

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

764: data_mismatch := FALSE;
765: iloop := 1;
766: l_chunk_no := l_chunk_no + 1;
767:
768: fnd_file.put_line(fnd_file.log,' ');
769: fnd_file.put_line(fnd_file.log,'*****************************************************************');
770: fnd_file.put_line(fnd_file.log,'=================================================================');
771: fnd_file.put_line(fnd_file.log,'Entering in a new chunk ');
772: fnd_file.put_line(fnd_file.log,'==================================================================');

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

765: iloop := 1;
766: l_chunk_no := l_chunk_no + 1;
767:
768: fnd_file.put_line(fnd_file.log,' ');
769: fnd_file.put_line(fnd_file.log,'*****************************************************************');
770: fnd_file.put_line(fnd_file.log,'=================================================================');
771: fnd_file.put_line(fnd_file.log,'Entering in a new chunk ');
772: fnd_file.put_line(fnd_file.log,'==================================================================');
773:

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

766: l_chunk_no := l_chunk_no + 1;
767:
768: fnd_file.put_line(fnd_file.log,' ');
769: fnd_file.put_line(fnd_file.log,'*****************************************************************');
770: fnd_file.put_line(fnd_file.log,'=================================================================');
771: fnd_file.put_line(fnd_file.log,'Entering in a new chunk ');
772: fnd_file.put_line(fnd_file.log,'==================================================================');
773:
774: <>

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

767:
768: fnd_file.put_line(fnd_file.log,' ');
769: fnd_file.put_line(fnd_file.log,'*****************************************************************');
770: fnd_file.put_line(fnd_file.log,'=================================================================');
771: fnd_file.put_line(fnd_file.log,'Entering in a new chunk ');
772: fnd_file.put_line(fnd_file.log,'==================================================================');
773:
774: <>
775: WHILE iloop = 1

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

768: fnd_file.put_line(fnd_file.log,' ');
769: fnd_file.put_line(fnd_file.log,'*****************************************************************');
770: fnd_file.put_line(fnd_file.log,'=================================================================');
771: fnd_file.put_line(fnd_file.log,'Entering in a new chunk ');
772: fnd_file.put_line(fnd_file.log,'==================================================================');
773:
774: <>
775: WHILE iloop = 1
776: LOOP

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

1452: END LOOP;
1453: CLOSE get_latest_details;
1454:
1455:
1456: fnd_file.put_line(fnd_file.log,' ');
1457: fnd_file.put_line(fnd_file.log,' ');
1458: fnd_file.put_line(fnd_file.log,'========================================================== ');
1459: fnd_file.put_line(fnd_file.log,' ');
1460: fnd_file.put_line(fnd_file.log,' ');

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

1453: CLOSE get_latest_details;
1454:
1455:
1456: fnd_file.put_line(fnd_file.log,' ');
1457: fnd_file.put_line(fnd_file.log,' ');
1458: fnd_file.put_line(fnd_file.log,'========================================================== ');
1459: fnd_file.put_line(fnd_file.log,' ');
1460: fnd_file.put_line(fnd_file.log,' ');
1461: COMMIT;

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

1454:
1455:
1456: fnd_file.put_line(fnd_file.log,' ');
1457: fnd_file.put_line(fnd_file.log,' ');
1458: fnd_file.put_line(fnd_file.log,'========================================================== ');
1459: fnd_file.put_line(fnd_file.log,' ');
1460: fnd_file.put_line(fnd_file.log,' ');
1461: COMMIT;
1462: tc_id_tab.DELETE;

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

1455:
1456: fnd_file.put_line(fnd_file.log,' ');
1457: fnd_file.put_line(fnd_file.log,' ');
1458: fnd_file.put_line(fnd_file.log,'========================================================== ');
1459: fnd_file.put_line(fnd_file.log,' ');
1460: fnd_file.put_line(fnd_file.log,' ');
1461: COMMIT;
1462: tc_id_tab.DELETE;
1463: tc_ovn_tab.DELETE;

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

1456: fnd_file.put_line(fnd_file.log,' ');
1457: fnd_file.put_line(fnd_file.log,' ');
1458: fnd_file.put_line(fnd_file.log,'========================================================== ');
1459: fnd_file.put_line(fnd_file.log,' ');
1460: fnd_file.put_line(fnd_file.log,' ');
1461: COMMIT;
1462: tc_id_tab.DELETE;
1463: tc_ovn_tab.DELETE;
1464: iloop:= 0;

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

1465: EXCEPTION
1466: WHEN DUP_VAL_ON_INDEX THEN
1467: ROLLBACK;
1468: iloop := 1;
1469: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention, will sleep for a minute ');
1470: fnd_file.put_line(fnd_file.log,'=================================================================');
1471: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1472: fnd_file.put_line(fnd_file.log,'==================================================================');
1473: l_td_count := 0;

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

1466: WHEN DUP_VAL_ON_INDEX THEN
1467: ROLLBACK;
1468: iloop := 1;
1469: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention, will sleep for a minute ');
1470: fnd_file.put_line(fnd_file.log,'=================================================================');
1471: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1472: fnd_file.put_line(fnd_file.log,'==================================================================');
1473: l_td_count := 0;
1474: l_trans_count := 0;

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

1467: ROLLBACK;
1468: iloop := 1;
1469: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention, will sleep for a minute ');
1470: fnd_file.put_line(fnd_file.log,'=================================================================');
1471: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1472: fnd_file.put_line(fnd_file.log,'==================================================================');
1473: l_td_count := 0;
1474: l_trans_count := 0;
1475: l_tau_count := 0;

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

1468: iloop := 1;
1469: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention, will sleep for a minute ');
1470: fnd_file.put_line(fnd_file.log,'=================================================================');
1471: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1472: fnd_file.put_line(fnd_file.log,'==================================================================');
1473: l_td_count := 0;
1474: l_trans_count := 0;
1475: l_tau_count := 0;
1476: l_ta_count := 0;

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

1478: dbms_lock.sleep(60);
1479: WHEN DEADLOCK_DETECTED THEN
1480: ROLLBACK;
1481: iloop := 1;
1482: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');
1483: fnd_file.put_line(fnd_file.log,'=================================================================');
1484: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1485: fnd_file.put_line(fnd_file.log,'==================================================================');
1486: l_td_count := 0;

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

1479: WHEN DEADLOCK_DETECTED THEN
1480: ROLLBACK;
1481: iloop := 1;
1482: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');
1483: fnd_file.put_line(fnd_file.log,'=================================================================');
1484: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1485: fnd_file.put_line(fnd_file.log,'==================================================================');
1486: l_td_count := 0;
1487: l_trans_count := 0;

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

1480: ROLLBACK;
1481: iloop := 1;
1482: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');
1483: fnd_file.put_line(fnd_file.log,'=================================================================');
1484: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1485: fnd_file.put_line(fnd_file.log,'==================================================================');
1486: l_td_count := 0;
1487: l_trans_count := 0;
1488: l_tau_count := 0;

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

1481: iloop := 1;
1482: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');
1483: fnd_file.put_line(fnd_file.log,'=================================================================');
1484: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1485: fnd_file.put_line(fnd_file.log,'==================================================================');
1486: l_td_count := 0;
1487: l_trans_count := 0;
1488: l_tau_count := 0;
1489: l_ta_count := 0;

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

1506:
1507: BEGIN
1508: IF p_insert = p_delete
1509: THEN
1510: fnd_file.put_line(fnd_file.log,' ');
1511: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1512: ELSE
1513: fnd_file.put_line(fnd_file.log,' ');
1514: fnd_file.put_line(fnd_file.log,'==========================================================================');

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

1507: BEGIN
1508: IF p_insert = p_delete
1509: THEN
1510: fnd_file.put_line(fnd_file.log,' ');
1511: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1512: ELSE
1513: fnd_file.put_line(fnd_file.log,' ');
1514: fnd_file.put_line(fnd_file.log,'==========================================================================');
1515: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');

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

1509: THEN
1510: fnd_file.put_line(fnd_file.log,' ');
1511: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1512: ELSE
1513: fnd_file.put_line(fnd_file.log,' ');
1514: fnd_file.put_line(fnd_file.log,'==========================================================================');
1515: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1516: fnd_file.put_line(fnd_file.log,'==========================================================================');
1517: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into offline table ');

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

1510: fnd_file.put_line(fnd_file.log,' ');
1511: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1512: ELSE
1513: fnd_file.put_line(fnd_file.log,' ');
1514: fnd_file.put_line(fnd_file.log,'==========================================================================');
1515: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1516: fnd_file.put_line(fnd_file.log,'==========================================================================');
1517: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into offline table ');
1518: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from online table ');

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

1511: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1512: ELSE
1513: fnd_file.put_line(fnd_file.log,' ');
1514: fnd_file.put_line(fnd_file.log,'==========================================================================');
1515: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1516: fnd_file.put_line(fnd_file.log,'==========================================================================');
1517: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into offline table ');
1518: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from online table ');
1519: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');

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

1512: ELSE
1513: fnd_file.put_line(fnd_file.log,' ');
1514: fnd_file.put_line(fnd_file.log,'==========================================================================');
1515: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1516: fnd_file.put_line(fnd_file.log,'==========================================================================');
1517: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into offline table ');
1518: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from online table ');
1519: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');
1520: p_mismatch := TRUE;

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

1513: fnd_file.put_line(fnd_file.log,' ');
1514: fnd_file.put_line(fnd_file.log,'==========================================================================');
1515: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1516: fnd_file.put_line(fnd_file.log,'==========================================================================');
1517: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into offline table ');
1518: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from online table ');
1519: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');
1520: p_mismatch := TRUE;
1521: ROLLBACK;

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

1514: fnd_file.put_line(fnd_file.log,'==========================================================================');
1515: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1516: fnd_file.put_line(fnd_file.log,'==========================================================================');
1517: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into offline table ');
1518: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from online table ');
1519: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');
1520: p_mismatch := TRUE;
1521: ROLLBACK;
1522: END IF;

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

1515: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1516: fnd_file.put_line(fnd_file.log,'==========================================================================');
1517: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into offline table ');
1518: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from online table ');
1519: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');
1520: p_mismatch := TRUE;
1521: ROLLBACK;
1522: END IF;
1523: