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 170: fnd_file.put_line(fnd_file.log, 'Dimension: '||p_dim_code);

166: l_hierarchy_level_id number;
167: l_date_column varchar2(30);
168:
169: Begin
170: fnd_file.put_line(fnd_file.log, 'Dimension: '||p_dim_code);
171: fnd_file.put_line(fnd_file.log, 'Hierarchy: '||p_hier_code);
172:
173: l_source_view_name := null;
174: l_sql := 'select ';

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

167: l_date_column varchar2(30);
168:
169: Begin
170: fnd_file.put_line(fnd_file.log, 'Dimension: '||p_dim_code);
171: fnd_file.put_line(fnd_file.log, 'Hierarchy: '||p_hier_code);
172:
173: l_source_view_name := null;
174: l_sql := 'select ';
175: l_count := 1;

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

343: if (l_source_view_name is not null)
344: then
345: l_sql := l_sql || ' from ' || l_source_view_name || qpr_sr_util.get_dblink(p_instance_id);
346: else
347: fnd_file.put_line(fnd_file.log, 'Source view name not specified for Dimension: ' || p_dim_code || ' and Hierrarchy: ' || p_hier_code);
348: return;
349: end if;
350:
351: if (date_from is not null) or (date_to is not null) then

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

365: l_sql := l_sql || ''', ' || l_date_column || ') and nvl('''|| date_to;
366: l_sql := l_sql || ''', ' || l_date_column || ')) ';
367: end if;
368:
369: fnd_file.put_line(fnd_file.log, 'SQL: '||l_sql);
370:
371: open c_dim_data for l_sql;
372: loop
373: fnd_file.put_line( fnd_file.log, 'Delete arrays ');

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

369: fnd_file.put_line(fnd_file.log, 'SQL: '||l_sql);
370:
371: open c_dim_data for l_sql;
372: loop
373: fnd_file.put_line( fnd_file.log, 'Delete arrays ');
374: c_dim_data_rec.level1_value.delete;
375: c_dim_data_rec.level1_desc.delete;
376: c_dim_data_rec.level1_attribute1.delete;
377: c_dim_data_rec.level1_attribute2.delete;

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

488: c_dim_data_rec.level8_attribute5,
489: c_dim_data_rec.check_date
490: limit l_rows;
491:
492: fnd_file.put_line( fnd_file.log, 'Populated arrays for dim: '||p_dim_code||' and hier: '||p_hier_code);
493: insert_dimension_data(p_instance_id, p_dim_code, p_hier_code, c_dim_data_rec);
494:
495: exit when c_dim_data%NOTFOUND;
496:

Line 513: fnd_file.put_line(fnd_file.log,'Entering insert dimension data ');

509:
510: l_request_id number;
511:
512: Begin
513: fnd_file.put_line(fnd_file.log,'Entering insert dimension data ');
514: fnd_file.put_line(fnd_file.log,'Inserting dimension data for: '||p_dim_code||'_'||p_hier_code);
515:
516: -- fnd_file.put_line(fnd_file.log,'Count '||c_dim_data_rec.day_sr_level_value_pk.count);
517: fnd_profile.get('CONC_REQUEST_ID', l_request_id);

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

510: l_request_id number;
511:
512: Begin
513: fnd_file.put_line(fnd_file.log,'Entering insert dimension data ');
514: fnd_file.put_line(fnd_file.log,'Inserting dimension data for: '||p_dim_code||'_'||p_hier_code);
515:
516: -- fnd_file.put_line(fnd_file.log,'Count '||c_dim_data_rec.day_sr_level_value_pk.count);
517: fnd_profile.get('CONC_REQUEST_ID', l_request_id);
518:

Line 516: -- fnd_file.put_line(fnd_file.log,'Count '||c_dim_data_rec.day_sr_level_value_pk.count);

512: Begin
513: fnd_file.put_line(fnd_file.log,'Entering insert dimension data ');
514: fnd_file.put_line(fnd_file.log,'Inserting dimension data for: '||p_dim_code||'_'||p_hier_code);
515:
516: -- fnd_file.put_line(fnd_file.log,'Count '||c_dim_data_rec.day_sr_level_value_pk.count);
517: fnd_profile.get('CONC_REQUEST_ID', l_request_id);
518:
519: forall I in
520: 1..c_dim_data_rec.level1_value.count

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

667: fnd_global.prog_appl_id,
668: fnd_global.conc_program_id,
669: null,
670: l_request_id);
671: fnd_file.put_line(fnd_file.log, 'No of rows processed: '||sql%rowcount);
672:
673: commit;
674:
675: EXCEPTION

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

673: commit;
674:
675: EXCEPTION
676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
677: fnd_file.put_line(fnd_file.log, 'UNEXCPECTED ERROR IN INSERT_DIMENSION_DATA:'||sqlerrm);
678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
679: WHEN OTHERS THEN
680: fnd_file.put_line(fnd_file.log, 'UNEXCPECTED ERROR IN INSERT_DIMENSION_DATA:'||sqlerrm);
681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
677: fnd_file.put_line(fnd_file.log, 'UNEXCPECTED ERROR IN INSERT_DIMENSION_DATA:'||sqlerrm);
678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
679: WHEN OTHERS THEN
680: fnd_file.put_line(fnd_file.log, 'UNEXCPECTED ERROR IN INSERT_DIMENSION_DATA:'||sqlerrm);
681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
682: End;
683:
684: End;