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

Line 62: fnd_file.put_line(fnd_file.log, 'Starting...');

58:
59: date_from := fnd_date.canonical_to_date(p_start_date);
60: date_to := fnd_date.canonical_to_date(p_end_date);
61:
62: fnd_file.put_line(fnd_file.log, 'Starting...');
63: select hsecs into l_start_time from v$timer;
64: fnd_file.put_line(fnd_file.log, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
65:
66: fnd_file.put_line(fnd_file.log, 'Dimension: '||p_dim_code);

Line 64: fnd_file.put_line(fnd_file.log, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));

60: date_to := fnd_date.canonical_to_date(p_end_date);
61:
62: fnd_file.put_line(fnd_file.log, 'Starting...');
63: select hsecs into l_start_time from v$timer;
64: fnd_file.put_line(fnd_file.log, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
65:
66: fnd_file.put_line(fnd_file.log, 'Dimension: '||p_dim_code);
67: fnd_file.put_line(fnd_file.log, 'Hierarchy: '||p_hier_code);
68:

Line 66: fnd_file.put_line(fnd_file.log, 'Dimension: '||p_dim_code);

62: fnd_file.put_line(fnd_file.log, 'Starting...');
63: select hsecs into l_start_time from v$timer;
64: fnd_file.put_line(fnd_file.log, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
65:
66: fnd_file.put_line(fnd_file.log, 'Dimension: '||p_dim_code);
67: fnd_file.put_line(fnd_file.log, 'Hierarchy: '||p_hier_code);
68:
69: l_dim_src_instance_id := p_instance_id;
70:

Line 67: fnd_file.put_line(fnd_file.log, 'Hierarchy: '||p_hier_code);

63: select hsecs into l_start_time from v$timer;
64: fnd_file.put_line(fnd_file.log, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
65:
66: fnd_file.put_line(fnd_file.log, 'Dimension: '||p_dim_code);
67: fnd_file.put_line(fnd_file.log, 'Hierarchy: '||p_hier_code);
68:
69: l_dim_src_instance_id := p_instance_id;
70:
71: select instance_type into l_inst_type

Line 86: fnd_file.put_line(fnd_file.log, 'One or more mandatory parameters are NULL');

82: end if;
83:
84: if not qpr_sr_util.dm_parameters_ok then
85: retcode:= 2;
86: fnd_file.put_line(fnd_file.log, 'One or more mandatory parameters are NULL');
87: return;
88: end if;
89:
90: -- Calling procedure with proper parameters based on the Dimension/Hierarchy --

Line 114: fnd_file.put_line(fnd_file.log, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));

110: -- delete_duplicate_data (p_instance_id);
111: -- commit;
112:
113: select hsecs into l_end_time from v$timer;
114: fnd_file.put_line(fnd_file.log, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time taken for loading dimension data (sec):' ||(l_end_time - l_start_time)/100);
116:
117: exception
118: WHEN NO_DATA_FOUND THEN

Line 115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time taken for loading dimension data (sec):' ||(l_end_time - l_start_time)/100);

111: -- commit;
112:
113: select hsecs into l_end_time from v$timer;
114: fnd_file.put_line(fnd_file.log, 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time taken for loading dimension data (sec):' ||(l_end_time - l_start_time)/100);
116:
117: exception
118: WHEN NO_DATA_FOUND THEN
119: retcode := 2;

Line 121: fnd_file.put_line( fnd_file.log, 'Unexpected error '||substr(sqlerrm,1200));

117: exception
118: WHEN NO_DATA_FOUND THEN
119: retcode := 2;
120: errbuf := FND_MESSAGE.GET;
121: fnd_file.put_line( fnd_file.log, 'Unexpected error '||substr(sqlerrm,1200));
122: End;
123:
124: /*
125: procedure delete_duplicate_data (p_instance_id in number)

Line 293: fnd_file.put_line(fnd_file.log, 'Dimension: '||p_dim_code);

289: end delete_arrays;
290:
291:
292: Begin
293: fnd_file.put_line(fnd_file.log, 'Dimension: '||p_dim_code);
294: fnd_file.put_line(fnd_file.log, 'Hierarchy: '||p_hier_code);
295:
296: l_source_view_name := null;
297: l_sql := 'select ';

Line 294: fnd_file.put_line(fnd_file.log, 'Hierarchy: '||p_hier_code);

290:
291:
292: Begin
293: fnd_file.put_line(fnd_file.log, 'Dimension: '||p_dim_code);
294: fnd_file.put_line(fnd_file.log, 'Hierarchy: '||p_hier_code);
295:
296: l_source_view_name := null;
297: l_sql := 'select ';
298: l_count := 1;

Line 470: fnd_file.put_line(fnd_file.log, 'Source view name not specified for Dimension: ' || p_dim_code || ' and Hierrarchy: ' || p_hier_code);

466: if (l_source_view_name is not null)
467: then
468: l_sql := l_sql || ' from ' || l_source_view_name || qpr_sr_util.get_dblink(p_instance_id);
469: else
470: fnd_file.put_line(fnd_file.log, 'Source view name not specified for Dimension: ' || p_dim_code || ' and Hierrarchy: ' || p_hier_code);
471: return;
472: end if;
473:
474: if (date_from is not null) or (date_to is not null) then

Line 496: fnd_file.put_line(fnd_file.log, 'SQL: '||l_sql);

492: else
493: l_sql := l_sql || ' order by level1_value ';
494: end if;
495:
496: fnd_file.put_line(fnd_file.log, 'SQL: '||l_sql);
497:
498: open c_dim_data for l_sql;
499: loop
500: fnd_file.put_line( fnd_file.log, 'Delete arrays ');

Line 500: fnd_file.put_line( fnd_file.log, 'Delete arrays ');

496: fnd_file.put_line(fnd_file.log, 'SQL: '||l_sql);
497:
498: open c_dim_data for l_sql;
499: loop
500: fnd_file.put_line( fnd_file.log, 'Delete arrays ');
501: delete_arrays(null);
502: l_temp_value := '';
503: fetch c_dim_data bulk collect
504: into c_dim_data_rec.level1_value,

Line 565: fnd_file.put_line( fnd_file.log, 'Populated arrays for dim: '||p_dim_code||' and hier: '||p_hier_code);

561: limit l_rows;
562:
563: exit when c_dim_data_rec.level1_value.count=0;
564:
565: fnd_file.put_line( fnd_file.log, 'Populated arrays for dim: '||p_dim_code||' and hier: '||p_hier_code);
566: fnd_file.put_line(fnd_file.log, 'Record read count:' || c_dim_data_rec.level1_value.count);
567: -- looping thro to eliminate duplicate level1_values
568: for i in 1..c_dim_data_rec.level1_value.count loop
569: if nvl(l_temp_value,'*') <> c_dim_data_rec.level1_value(i) then

Line 566: fnd_file.put_line(fnd_file.log, 'Record read count:' || c_dim_data_rec.level1_value.count);

562:
563: exit when c_dim_data_rec.level1_value.count=0;
564:
565: fnd_file.put_line( fnd_file.log, 'Populated arrays for dim: '||p_dim_code||' and hier: '||p_hier_code);
566: fnd_file.put_line(fnd_file.log, 'Record read count:' || c_dim_data_rec.level1_value.count);
567: -- looping thro to eliminate duplicate level1_values
568: for i in 1..c_dim_data_rec.level1_value.count loop
569: if nvl(l_temp_value,'*') <> c_dim_data_rec.level1_value(i) then
570: l_temp_value := c_dim_data_rec.level1_value(i);

Line 576: fnd_file.put_line(fnd_file.log,

572: --delete that index
573: delete_arrays(i);
574: end if;
575: end loop;
576: fnd_file.put_line(fnd_file.log,
577: 'Record count after removing duplicate values in read set:' || c_dim_data_rec.level1_value.count);
578:
579: insert_dimension_data(p_instance_id, p_dim_code, p_hier_code, c_dim_data_rec);
580:

Line 597: fnd_file.put_line(fnd_file.log,

593:
594: l_request_id number;
595:
596: Begin
597: fnd_file.put_line(fnd_file.log,
598: 'Deleting duplicate values in table data ');
599:
600: fnd_profile.get('CONC_REQUEST_ID', l_request_id);
601:

Line 611: fnd_file.put_line(fnd_file.log,

607: and hierarchy_code = p_hier_code
608: and instance_id = p_instance_id
609: and level1_value = c_dim_data_rec.level1_value(I);
610:
611: fnd_file.put_line(fnd_file.log,
612: 'Deleted record count:' || sql%rowcount);
613:
614: fnd_file.put_line(fnd_file.log,'Inserting dimension data for: '||p_dim_code||'_'||p_hier_code);
615:

Line 614: fnd_file.put_line(fnd_file.log,'Inserting dimension data for: '||p_dim_code||'_'||p_hier_code);

610:
611: fnd_file.put_line(fnd_file.log,
612: 'Deleted record count:' || sql%rowcount);
613:
614: fnd_file.put_line(fnd_file.log,'Inserting dimension data for: '||p_dim_code||'_'||p_hier_code);
615:
616: forall i in indices of c_dim_data_rec.level1_value
617: INSERT INTO QPR_DIMENSION_VALUES
618: (dim_value_id,

Line 759: fnd_file.put_line(fnd_file.log, 'No of rows processed: '||sql%rowcount);

755: fnd_global.prog_appl_id,
756: fnd_global.conc_program_id,
757: null,
758: l_request_id);
759: fnd_file.put_line(fnd_file.log, 'No of rows processed: '||sql%rowcount);
760:
761: commit;
762:
763: EXCEPTION

Line 765: fnd_file.put_line(fnd_file.log, 'UNEXCPECTED ERROR IN INSERT_DIMENSION_DATA:'||sqlerrm);

761: commit;
762:
763: EXCEPTION
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: fnd_file.put_line(fnd_file.log, 'UNEXCPECTED ERROR IN INSERT_DIMENSION_DATA:'||sqlerrm);
766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
767: WHEN OTHERS THEN
768: fnd_file.put_line(fnd_file.log, 'UNEXCPECTED ERROR IN INSERT_DIMENSION_DATA:'||sqlerrm);
769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 768: fnd_file.put_line(fnd_file.log, 'UNEXCPECTED ERROR IN INSERT_DIMENSION_DATA:'||sqlerrm);

764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: fnd_file.put_line(fnd_file.log, 'UNEXCPECTED ERROR IN INSERT_DIMENSION_DATA:'||sqlerrm);
766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
767: WHEN OTHERS THEN
768: fnd_file.put_line(fnd_file.log, 'UNEXCPECTED ERROR IN INSERT_DIMENSION_DATA:'||sqlerrm);
769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
770: End;
771:
772: End;