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

385: SET status = 'OFF_LINE', validation_status = ' '
386: WHERE data_set_id = p_data_set_id;
387:
388: ELSE
389: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');
390: fnd_file.put_line(fnd_file.LOG,' Either one of the threads failed or there is a data issue ');
391: fnd_file.put_line(fnd_file.LOG,' Please run the process again to reprocess the failed timecards ');
392: fnd_file.put_line(fnd_file.LOG,' ');
393:

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

386: WHERE data_set_id = p_data_set_id;
387:
388: ELSE
389: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');
390: fnd_file.put_line(fnd_file.LOG,' Either one of the threads failed or there is a data issue ');
391: fnd_file.put_line(fnd_file.LOG,' Please run the process again to reprocess the failed timecards ');
392: fnd_file.put_line(fnd_file.LOG,' ');
393:
394: END IF;

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

387:
388: ELSE
389: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');
390: fnd_file.put_line(fnd_file.LOG,' Either one of the threads failed or there is a data issue ');
391: fnd_file.put_line(fnd_file.LOG,' Please run the process again to reprocess the failed timecards ');
392: fnd_file.put_line(fnd_file.LOG,' ');
393:
394: END IF;
395:

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

388: ELSE
389: fnd_file.put_line(fnd_file.LOG,' There were some issues with the process');
390: fnd_file.put_line(fnd_file.LOG,' Either one of the threads failed or there is a data issue ');
391: fnd_file.put_line(fnd_file.LOG,' Please run the process again to reprocess the failed timecards ');
392: fnd_file.put_line(fnd_file.LOG,' ');
393:
394: END IF;
395:
396:

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

400: -- Check if the profile is set for detailed logging.
401: IF fnd_profile.value('HXC_AR_ENABLE_LOG') = 'Y'
402: THEN
403: -- Print out the log.
404: fnd_file.put_line(fnd_file.LOG,' ');
405: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
406: fnd_file.put_line(fnd_file.LOG,'======================================');
407: fnd_file.put_line(fnd_file.LOG,' ');
408: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');

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

401: IF fnd_profile.value('HXC_AR_ENABLE_LOG') = 'Y'
402: THEN
403: -- Print out the log.
404: fnd_file.put_line(fnd_file.LOG,' ');
405: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
406: fnd_file.put_line(fnd_file.LOG,'======================================');
407: fnd_file.put_line(fnd_file.LOG,' ');
408: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
409: fnd_file.put_line(fnd_file.LOG,' ');

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

402: THEN
403: -- Print out the log.
404: fnd_file.put_line(fnd_file.LOG,' ');
405: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
406: fnd_file.put_line(fnd_file.LOG,'======================================');
407: fnd_file.put_line(fnd_file.LOG,' ');
408: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
409: fnd_file.put_line(fnd_file.LOG,' ');
410: FOR log_rec IN get_log_details

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

403: -- Print out the log.
404: fnd_file.put_line(fnd_file.LOG,' ');
405: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
406: fnd_file.put_line(fnd_file.LOG,'======================================');
407: fnd_file.put_line(fnd_file.LOG,' ');
408: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
409: fnd_file.put_line(fnd_file.LOG,' ');
410: FOR log_rec IN get_log_details
411: LOOP

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

404: fnd_file.put_line(fnd_file.LOG,' ');
405: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
406: fnd_file.put_line(fnd_file.LOG,'======================================');
407: fnd_file.put_line(fnd_file.LOG,' ');
408: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
409: fnd_file.put_line(fnd_file.LOG,' ');
410: FOR log_rec IN get_log_details
411: LOOP
412: IF l_debug_info <> log_rec.detail

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

405: fnd_file.put_line(fnd_file.LOG,'Following are the timecards processed ');
406: fnd_file.put_line(fnd_file.LOG,'======================================');
407: fnd_file.put_line(fnd_file.LOG,' ');
408: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
409: fnd_file.put_line(fnd_file.LOG,' ');
410: FOR log_rec IN get_log_details
411: LOOP
412: IF l_debug_info <> log_rec.detail
413: THEN

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

410: FOR log_rec IN get_log_details
411: LOOP
412: IF l_debug_info <> log_rec.detail
413: THEN
414: fnd_file.put_line(fnd_file.log,' ---- ');
415: l_debug_info := log_rec.detail;
416: END IF;
417: hr_utility.trace(log_rec.resource_id||' - '||log_rec.start_time||
418: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');

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

415: l_debug_info := log_rec.detail;
416: END IF;
417: hr_utility.trace(log_rec.resource_id||' - '||log_rec.start_time||
418: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
419: fnd_file.put_line(fnd_file.log,log_rec.resource_id||' - '||log_rec.start_time||
420: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
421: END LOOP;
422:
423: l_debug_info := ' ';

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

420: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
421: END LOOP;
422:
423: l_debug_info := ' ';
424: fnd_file.put_line(fnd_file.LOG,' ');
425: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
426: fnd_file.put_line(fnd_file.LOG,'==========================================');
427: fnd_file.put_line(fnd_file.LOG,' ');
428: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');

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

421: END LOOP;
422:
423: l_debug_info := ' ';
424: fnd_file.put_line(fnd_file.LOG,' ');
425: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
426: fnd_file.put_line(fnd_file.LOG,'==========================================');
427: fnd_file.put_line(fnd_file.LOG,' ');
428: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
429: fnd_file.put_line(fnd_file.LOG,' ');

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

422:
423: l_debug_info := ' ';
424: fnd_file.put_line(fnd_file.LOG,' ');
425: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
426: fnd_file.put_line(fnd_file.LOG,'==========================================');
427: fnd_file.put_line(fnd_file.LOG,' ');
428: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
429: fnd_file.put_line(fnd_file.LOG,' ');
430: FOR log_rec IN get_log_details_failed

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

423: l_debug_info := ' ';
424: fnd_file.put_line(fnd_file.LOG,' ');
425: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
426: fnd_file.put_line(fnd_file.LOG,'==========================================');
427: fnd_file.put_line(fnd_file.LOG,' ');
428: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
429: fnd_file.put_line(fnd_file.LOG,' ');
430: FOR log_rec IN get_log_details_failed
431: LOOP

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

424: fnd_file.put_line(fnd_file.LOG,' ');
425: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
426: fnd_file.put_line(fnd_file.LOG,'==========================================');
427: fnd_file.put_line(fnd_file.LOG,' ');
428: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
429: fnd_file.put_line(fnd_file.LOG,' ');
430: FOR log_rec IN get_log_details_failed
431: LOOP
432: IF l_debug_info <> log_rec.detail

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

425: fnd_file.put_line(fnd_file.LOG,'Following are the timecards not processed ');
426: fnd_file.put_line(fnd_file.LOG,'==========================================');
427: fnd_file.put_line(fnd_file.LOG,' ');
428: fnd_file.put_line(fnd_file.LOG,'Person id - Timecard start time [TC ID - Debug information]');
429: fnd_file.put_line(fnd_file.LOG,' ');
430: FOR log_rec IN get_log_details_failed
431: LOOP
432: IF l_debug_info <> log_rec.detail
433: THEN

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

430: FOR log_rec IN get_log_details_failed
431: LOOP
432: IF l_debug_info <> log_rec.detail
433: THEN
434: fnd_file.put_line(fnd_file.log,' ---- ');
435: l_debug_info := log_rec.detail;
436: END IF;
437: hr_utility.trace(log_rec.resource_id||' - '||log_rec.start_time||
438: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');

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

435: l_debug_info := log_rec.detail;
436: END IF;
437: hr_utility.trace(log_rec.resource_id||' - '||log_rec.start_time||
438: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
439: fnd_file.put_line(fnd_file.log,log_rec.resource_id||' - '||log_rec.start_time||
440: ' ['||log_rec.tc_id||'-'||log_rec.detail||']');
441: END LOOP;
442: END IF;
443:

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

777: hr_general.g_data_migrator_mode := 'Y';
778:
779: l_chunk_size := nvl(fnd_profile.value('HXC_ARCHIVE_RESTORE_CHUNK_SIZE'),50);
780:
781: fnd_file.put_line(fnd_file.LOG,'--- > Chunk Size is: '||l_chunk_size);
782:
783: -- firs let's get the min start time of
784: -- the timecard for this data set
785:

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

807: data_mismatch := FALSE;
808: iloop := 1;
809: l_chunk_no := l_chunk_no + 1;
810:
811: fnd_file.put_line(fnd_file.log,' ');
812: fnd_file.put_line(fnd_file.log,'*****************************************************************');
813: fnd_file.put_line(fnd_file.log,'=================================================================');
814: fnd_file.put_line(fnd_file.log,'Entering in a new chunk ');
815: fnd_file.put_line(fnd_file.log,'==================================================================');

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

808: iloop := 1;
809: l_chunk_no := l_chunk_no + 1;
810:
811: fnd_file.put_line(fnd_file.log,' ');
812: fnd_file.put_line(fnd_file.log,'*****************************************************************');
813: fnd_file.put_line(fnd_file.log,'=================================================================');
814: fnd_file.put_line(fnd_file.log,'Entering in a new chunk ');
815: fnd_file.put_line(fnd_file.log,'==================================================================');
816:

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

809: l_chunk_no := l_chunk_no + 1;
810:
811: fnd_file.put_line(fnd_file.log,' ');
812: fnd_file.put_line(fnd_file.log,'*****************************************************************');
813: fnd_file.put_line(fnd_file.log,'=================================================================');
814: fnd_file.put_line(fnd_file.log,'Entering in a new chunk ');
815: fnd_file.put_line(fnd_file.log,'==================================================================');
816:
817: <>

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

810:
811: fnd_file.put_line(fnd_file.log,' ');
812: fnd_file.put_line(fnd_file.log,'*****************************************************************');
813: fnd_file.put_line(fnd_file.log,'=================================================================');
814: fnd_file.put_line(fnd_file.log,'Entering in a new chunk ');
815: fnd_file.put_line(fnd_file.log,'==================================================================');
816:
817: <>
818: WHILE iloop = 1

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

811: fnd_file.put_line(fnd_file.log,' ');
812: fnd_file.put_line(fnd_file.log,'*****************************************************************');
813: fnd_file.put_line(fnd_file.log,'=================================================================');
814: fnd_file.put_line(fnd_file.log,'Entering in a new chunk ');
815: fnd_file.put_line(fnd_file.log,'==================================================================');
816:
817: <>
818: WHILE iloop = 1
819: LOOP

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

1801: END LOOP;
1802: CLOSE get_latest_details;
1803:
1804:
1805: fnd_file.put_line(fnd_file.log,' ');
1806: fnd_file.put_line(fnd_file.log,' ');
1807: fnd_file.put_line(fnd_file.log,'========================================================== ');
1808: fnd_file.put_line(fnd_file.log,' ');
1809: fnd_file.put_line(fnd_file.log,' ');

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

1802: CLOSE get_latest_details;
1803:
1804:
1805: fnd_file.put_line(fnd_file.log,' ');
1806: fnd_file.put_line(fnd_file.log,' ');
1807: fnd_file.put_line(fnd_file.log,'========================================================== ');
1808: fnd_file.put_line(fnd_file.log,' ');
1809: fnd_file.put_line(fnd_file.log,' ');
1810: COMMIT;

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

1803:
1804:
1805: fnd_file.put_line(fnd_file.log,' ');
1806: fnd_file.put_line(fnd_file.log,' ');
1807: fnd_file.put_line(fnd_file.log,'========================================================== ');
1808: fnd_file.put_line(fnd_file.log,' ');
1809: fnd_file.put_line(fnd_file.log,' ');
1810: COMMIT;
1811: tc_id_tab.DELETE;

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

1804:
1805: fnd_file.put_line(fnd_file.log,' ');
1806: fnd_file.put_line(fnd_file.log,' ');
1807: fnd_file.put_line(fnd_file.log,'========================================================== ');
1808: fnd_file.put_line(fnd_file.log,' ');
1809: fnd_file.put_line(fnd_file.log,' ');
1810: COMMIT;
1811: tc_id_tab.DELETE;
1812: tc_ovn_tab.DELETE;

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

1805: fnd_file.put_line(fnd_file.log,' ');
1806: fnd_file.put_line(fnd_file.log,' ');
1807: fnd_file.put_line(fnd_file.log,'========================================================== ');
1808: fnd_file.put_line(fnd_file.log,' ');
1809: fnd_file.put_line(fnd_file.log,' ');
1810: COMMIT;
1811: tc_id_tab.DELETE;
1812: tc_ovn_tab.DELETE;
1813: iloop:= 0;

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

1814: EXCEPTION
1815: WHEN DUP_VAL_ON_INDEX THEN
1816: ROLLBACK;
1817: iloop := 1;
1818: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention, will sleep for a minute ');
1819: fnd_file.put_line(fnd_file.log,'=================================================================');
1820: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1821: fnd_file.put_line(fnd_file.log,'==================================================================');
1822: l_td_count := 0;

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

1815: WHEN DUP_VAL_ON_INDEX THEN
1816: ROLLBACK;
1817: iloop := 1;
1818: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention, will sleep for a minute ');
1819: fnd_file.put_line(fnd_file.log,'=================================================================');
1820: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1821: fnd_file.put_line(fnd_file.log,'==================================================================');
1822: l_td_count := 0;
1823: l_trans_count := 0;

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

1816: ROLLBACK;
1817: iloop := 1;
1818: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention, will sleep for a minute ');
1819: fnd_file.put_line(fnd_file.log,'=================================================================');
1820: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1821: fnd_file.put_line(fnd_file.log,'==================================================================');
1822: l_td_count := 0;
1823: l_trans_count := 0;
1824: l_tau_count := 0;

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

1817: iloop := 1;
1818: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention, will sleep for a minute ');
1819: fnd_file.put_line(fnd_file.log,'=================================================================');
1820: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1821: fnd_file.put_line(fnd_file.log,'==================================================================');
1822: l_td_count := 0;
1823: l_trans_count := 0;
1824: l_tau_count := 0;
1825: l_ta_count := 0;

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

1827: dbms_lock.sleep(60);
1828: WHEN DEADLOCK_DETECTED THEN
1829: ROLLBACK;
1830: iloop := 1;
1831: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');
1832: fnd_file.put_line(fnd_file.log,'=================================================================');
1833: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1834: fnd_file.put_line(fnd_file.log,'==================================================================');
1835: l_td_count := 0;

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

1828: WHEN DEADLOCK_DETECTED THEN
1829: ROLLBACK;
1830: iloop := 1;
1831: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');
1832: fnd_file.put_line(fnd_file.log,'=================================================================');
1833: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1834: fnd_file.put_line(fnd_file.log,'==================================================================');
1835: l_td_count := 0;
1836: l_trans_count := 0;

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

1829: ROLLBACK;
1830: iloop := 1;
1831: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');
1832: fnd_file.put_line(fnd_file.log,'=================================================================');
1833: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1834: fnd_file.put_line(fnd_file.log,'==================================================================');
1835: l_td_count := 0;
1836: l_trans_count := 0;
1837: l_tau_count := 0;

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

1830: iloop := 1;
1831: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');
1832: fnd_file.put_line(fnd_file.log,'=================================================================');
1833: fnd_file.put_line(fnd_file.log,'Reprocessing this chunk ');
1834: fnd_file.put_line(fnd_file.log,'==================================================================');
1835: l_td_count := 0;
1836: l_trans_count := 0;
1837: l_tau_count := 0;
1838: l_ta_count := 0;

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

1855:
1856: BEGIN
1857: IF p_insert = p_delete
1858: THEN
1859: fnd_file.put_line(fnd_file.log,' ');
1860: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1861: ELSE
1862: fnd_file.put_line(fnd_file.log,' ');
1863: fnd_file.put_line(fnd_file.log,'==========================================================================');

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

1856: BEGIN
1857: IF p_insert = p_delete
1858: THEN
1859: fnd_file.put_line(fnd_file.log,' ');
1860: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1861: ELSE
1862: fnd_file.put_line(fnd_file.log,' ');
1863: fnd_file.put_line(fnd_file.log,'==========================================================================');
1864: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');

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

1858: THEN
1859: fnd_file.put_line(fnd_file.log,' ');
1860: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1861: ELSE
1862: fnd_file.put_line(fnd_file.log,' ');
1863: fnd_file.put_line(fnd_file.log,'==========================================================================');
1864: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1865: fnd_file.put_line(fnd_file.log,'==========================================================================');
1866: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into offline table ');

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

1859: fnd_file.put_line(fnd_file.log,' ');
1860: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1861: ELSE
1862: fnd_file.put_line(fnd_file.log,' ');
1863: fnd_file.put_line(fnd_file.log,'==========================================================================');
1864: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1865: fnd_file.put_line(fnd_file.log,'==========================================================================');
1866: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into offline table ');
1867: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from online table ');

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

1860: fnd_file.put_line(fnd_file.log,' '||p_scope||' records moved : '||p_insert);
1861: ELSE
1862: fnd_file.put_line(fnd_file.log,' ');
1863: fnd_file.put_line(fnd_file.log,'==========================================================================');
1864: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1865: fnd_file.put_line(fnd_file.log,'==========================================================================');
1866: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into offline table ');
1867: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from online table ');
1868: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');

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

1861: ELSE
1862: fnd_file.put_line(fnd_file.log,' ');
1863: fnd_file.put_line(fnd_file.log,'==========================================================================');
1864: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1865: fnd_file.put_line(fnd_file.log,'==========================================================================');
1866: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into offline table ');
1867: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from online table ');
1868: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');
1869: p_mismatch := TRUE;

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

1862: fnd_file.put_line(fnd_file.log,' ');
1863: fnd_file.put_line(fnd_file.log,'==========================================================================');
1864: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1865: fnd_file.put_line(fnd_file.log,'==========================================================================');
1866: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into offline table ');
1867: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from online table ');
1868: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');
1869: p_mismatch := TRUE;
1870: ROLLBACK;

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

1863: fnd_file.put_line(fnd_file.log,'==========================================================================');
1864: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1865: fnd_file.put_line(fnd_file.log,'==========================================================================');
1866: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into offline table ');
1867: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from online table ');
1868: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');
1869: p_mismatch := TRUE;
1870: ROLLBACK;
1871: END IF;

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

1864: fnd_file.put_line(fnd_file.log,' An error occured while processing '||p_scope||' records');
1865: fnd_file.put_line(fnd_file.log,'==========================================================================');
1866: fnd_file.put_line(fnd_file.log, p_insert||' records were inserted into offline table ');
1867: fnd_file.put_line(fnd_file.log, p_delete||' records were deleted from online table ');
1868: fnd_file.put_line(fnd_file.log,'This chunk is rolled back, pls check up data. ');
1869: p_mismatch := TRUE;
1870: ROLLBACK;
1871: END IF;
1872: