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

Line 105: FND_FILE.put_line(FND_FILE.OUTPUT, 'Interface Records Processed:');

101:
102: IF l_loop_count = 0 THEN
103: RAISE G_NO_DATA_FOUND_EXC;
104: END IF;
105: FND_FILE.put_line(FND_FILE.OUTPUT, 'Interface Records Processed:');
106:
107: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');
108: FND_FILE.put_line(FND_FILE.OUTPUT, rpad('Interface Tables->', 36) ||
109: 'Headers' ||

Line 107: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');

103: RAISE G_NO_DATA_FOUND_EXC;
104: END IF;
105: FND_FILE.put_line(FND_FILE.OUTPUT, 'Interface Records Processed:');
106:
107: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');
108: FND_FILE.put_line(FND_FILE.OUTPUT, rpad('Interface Tables->', 36) ||
109: 'Headers' ||
110: lpad('Lines', 10) ||
111: lpad('Covered Levels', 20) ||

Line 108: FND_FILE.put_line(FND_FILE.OUTPUT, rpad('Interface Tables->', 36) ||

104: END IF;
105: FND_FILE.put_line(FND_FILE.OUTPUT, 'Interface Records Processed:');
106:
107: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');
108: FND_FILE.put_line(FND_FILE.OUTPUT, rpad('Interface Tables->', 36) ||
109: 'Headers' ||
110: lpad('Lines', 10) ||
111: lpad('Covered Levels', 20) ||
112: lpad('Usage Counters', 20) ||

Line 115: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');

111: lpad('Covered Levels', 20) ||
112: lpad('Usage Counters', 20) ||
113: lpad('Sales Credits', 20) ||
114: lpad('Notes', 10));
115: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');
116: FOR i IN 1..l_loop_count
117: LOOP
118: FND_FILE.put_line(FND_FILE.OUTPUT, rpad(l_statistics_tab(i).Statistic_Name, 36) ||
119: lpad(l_statistics_tab(i).Headers_Stat, 7) ||

Line 118: FND_FILE.put_line(FND_FILE.OUTPUT, rpad(l_statistics_tab(i).Statistic_Name, 36) ||

114: lpad('Notes', 10));
115: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');
116: FOR i IN 1..l_loop_count
117: LOOP
118: FND_FILE.put_line(FND_FILE.OUTPUT, rpad(l_statistics_tab(i).Statistic_Name, 36) ||
119: lpad(l_statistics_tab(i).Headers_Stat, 7) ||
120: lpad(l_statistics_tab(i).Lines_Stat, 10) ||
121: lpad(l_statistics_tab(i).Covered_Levels_Stat, 20) ||
122: lpad(l_statistics_tab(i).Usage_Counters_Stat, 20) ||

Line 127: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');

123: lpad(l_statistics_tab(i).Sales_Credits_Stat, 20) ||
124: lpad(l_statistics_tab(i).Notes_Stat, 10));
125: END LOOP;
126:
127: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');
128: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || fnd_global.local_chr(10) || fnd_global.local_chr(10));
129: IF G_PROCEDURE_LOG THEN
130: fnd_log.string(fnd_log.level_procedure,
131: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,

Line 128: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || fnd_global.local_chr(10) || fnd_global.local_chr(10));

124: lpad(l_statistics_tab(i).Notes_Stat, 10));
125: END LOOP;
126:
127: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');
128: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || fnd_global.local_chr(10) || fnd_global.local_chr(10));
129: IF G_PROCEDURE_LOG THEN
130: fnd_log.string(fnd_log.level_procedure,
131: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
132: 'Exit.');

Line 187: FND_FILE.put_line(FND_FILE.OUTPUT, 'Error Messages:');

183: 'P_mode = ' || P_mode ||','||
184: 'P_batch_id = ' || P_batch_id ||','||
185: 'P_parent_request_id = ' || P_parent_request_id);
186: END IF;
187: FND_FILE.put_line(FND_FILE.OUTPUT, 'Error Messages:');
188: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');
189: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Interface Table', 16) ||
190: lpad('Interface Id', 28) ||
191: lpad('Error Message', 25));

Line 188: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');

184: 'P_batch_id = ' || P_batch_id ||','||
185: 'P_parent_request_id = ' || P_parent_request_id);
186: END IF;
187: FND_FILE.put_line(FND_FILE.OUTPUT, 'Error Messages:');
188: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');
189: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Interface Table', 16) ||
190: lpad('Interface Id', 28) ||
191: lpad('Error Message', 25));
192: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');

Line 189: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Interface Table', 16) ||

185: 'P_parent_request_id = ' || P_parent_request_id);
186: END IF;
187: FND_FILE.put_line(FND_FILE.OUTPUT, 'Error Messages:');
188: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');
189: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Interface Table', 16) ||
190: lpad('Interface Id', 28) ||
191: lpad('Error Message', 25));
192: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');
193:

Line 192: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');

188: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');
189: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Interface Table', 16) ||
190: lpad('Interface Id', 28) ||
191: lpad('Error Message', 25));
192: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');
193:
194: l_stmt_num := 10;
195: OPEN error_messages_cur (P_parent_request_id);
196: l_stmt_num := 20;

Line 209: FND_FILE.put_line(FND_FILE.OUTPUT, rpad(l_err_msg_tab(i).INTERFACE_TABLE, 35) ||

205: END IF;
206:
207: FOR i IN 1..l_loop_count
208: LOOP
209: FND_FILE.put_line(FND_FILE.OUTPUT, rpad(l_err_msg_tab(i).INTERFACE_TABLE, 35) ||
210: rpad(l_err_msg_tab(i).INTERFACE_ID, 15) ||
211: l_err_msg_tab(i).ERROR_MESSAGE);
212: END LOOP;
213: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');

Line 213: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');

209: FND_FILE.put_line(FND_FILE.OUTPUT, rpad(l_err_msg_tab(i).INTERFACE_TABLE, 35) ||
210: rpad(l_err_msg_tab(i).INTERFACE_ID, 15) ||
211: l_err_msg_tab(i).ERROR_MESSAGE);
212: END LOOP;
213: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');
214:
215: CLOSE error_messages_cur;
216:
217: IF l_error_count = l_threshold_count THEN

Line 219: FND_FILE.put_line(FND_FILE.OUTPUT, FND_MESSAGE.GET);

215: CLOSE error_messages_cur;
216:
217: IF l_error_count = l_threshold_count THEN
218: FND_MESSAGE.Set_Name('OKS', 'OKS_IMP_RPT_TOO_MANY_ERRORS');
219: FND_FILE.put_line(FND_FILE.OUTPUT, FND_MESSAGE.GET);
220: END IF;
221:
222: IF G_PROCEDURE_LOG THEN
223: fnd_log.string(fnd_log.level_procedure,

Line 292: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || fnd_global.local_chr(10) || fnd_global.local_chr(10));

288: l_stmt_num := 20;
289:
290: select meaning into l_mode from fnd_lookups where lookup_type = 'OKS_IMPORT_MODE' and lookup_code = P_mode;
291:
292: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || fnd_global.local_chr(10) || fnd_global.local_chr(10));
293: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Execution Report', 70) || lpad('Date: ', 32) || l_report_date);
294: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));
295: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Process Request Id: ', 35) || P_parent_request_id);
296: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request Start Date: ', 35) || l_start_date);

Line 293: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Execution Report', 70) || lpad('Date: ', 32) || l_report_date);

289:
290: select meaning into l_mode from fnd_lookups where lookup_type = 'OKS_IMPORT_MODE' and lookup_code = P_mode;
291:
292: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || fnd_global.local_chr(10) || fnd_global.local_chr(10));
293: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Execution Report', 70) || lpad('Date: ', 32) || l_report_date);
294: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));
295: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Process Request Id: ', 35) || P_parent_request_id);
296: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request Start Date: ', 35) || l_start_date);
297: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request End Date: ', 35) || l_end_date);

Line 294: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));

290: select meaning into l_mode from fnd_lookups where lookup_type = 'OKS_IMPORT_MODE' and lookup_code = P_mode;
291:
292: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || fnd_global.local_chr(10) || fnd_global.local_chr(10));
293: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Execution Report', 70) || lpad('Date: ', 32) || l_report_date);
294: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));
295: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Process Request Id: ', 35) || P_parent_request_id);
296: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request Start Date: ', 35) || l_start_date);
297: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request End Date: ', 35) || l_end_date);
298: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Batch Number: ', 35) || P_batch_id);

Line 295: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Process Request Id: ', 35) || P_parent_request_id);

291:
292: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || fnd_global.local_chr(10) || fnd_global.local_chr(10));
293: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Execution Report', 70) || lpad('Date: ', 32) || l_report_date);
294: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));
295: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Process Request Id: ', 35) || P_parent_request_id);
296: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request Start Date: ', 35) || l_start_date);
297: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request End Date: ', 35) || l_end_date);
298: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Batch Number: ', 35) || P_batch_id);
299: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Mode: ', 35) || l_mode);

Line 296: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request Start Date: ', 35) || l_start_date);

292: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || fnd_global.local_chr(10) || fnd_global.local_chr(10));
293: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Execution Report', 70) || lpad('Date: ', 32) || l_report_date);
294: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));
295: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Process Request Id: ', 35) || P_parent_request_id);
296: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request Start Date: ', 35) || l_start_date);
297: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request End Date: ', 35) || l_end_date);
298: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Batch Number: ', 35) || P_batch_id);
299: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Mode: ', 35) || l_mode);
300: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Number of Workers: ', 35) || P_Num_Workers);

Line 297: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request End Date: ', 35) || l_end_date);

293: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Execution Report', 70) || lpad('Date: ', 32) || l_report_date);
294: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));
295: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Process Request Id: ', 35) || P_parent_request_id);
296: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request Start Date: ', 35) || l_start_date);
297: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request End Date: ', 35) || l_end_date);
298: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Batch Number: ', 35) || P_batch_id);
299: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Mode: ', 35) || l_mode);
300: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Number of Workers: ', 35) || P_Num_Workers);
301: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Commit Size : ', 35) || P_commit_size);

Line 298: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Batch Number: ', 35) || P_batch_id);

294: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));
295: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Process Request Id: ', 35) || P_parent_request_id);
296: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request Start Date: ', 35) || l_start_date);
297: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request End Date: ', 35) || l_end_date);
298: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Batch Number: ', 35) || P_batch_id);
299: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Mode: ', 35) || l_mode);
300: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Number of Workers: ', 35) || P_Num_Workers);
301: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Commit Size : ', 35) || P_commit_size);
302: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));

Line 299: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Mode: ', 35) || l_mode);

295: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Process Request Id: ', 35) || P_parent_request_id);
296: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request Start Date: ', 35) || l_start_date);
297: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request End Date: ', 35) || l_end_date);
298: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Batch Number: ', 35) || P_batch_id);
299: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Mode: ', 35) || l_mode);
300: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Number of Workers: ', 35) || P_Num_Workers);
301: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Commit Size : ', 35) || P_commit_size);
302: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));
303:

Line 300: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Number of Workers: ', 35) || P_Num_Workers);

296: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request Start Date: ', 35) || l_start_date);
297: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request End Date: ', 35) || l_end_date);
298: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Batch Number: ', 35) || P_batch_id);
299: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Mode: ', 35) || l_mode);
300: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Number of Workers: ', 35) || P_Num_Workers);
301: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Commit Size : ', 35) || P_commit_size);
302: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));
303:
304:

Line 301: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Commit Size : ', 35) || P_commit_size);

297: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request End Date: ', 35) || l_end_date);
298: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Batch Number: ', 35) || P_batch_id);
299: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Mode: ', 35) || l_mode);
300: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Number of Workers: ', 35) || P_Num_Workers);
301: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Commit Size : ', 35) || P_commit_size);
302: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));
303:
304:
305: l_stmt_num := 30;

Line 302: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));

298: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Batch Number: ', 35) || P_batch_id);
299: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Mode: ', 35) || l_mode);
300: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Number of Workers: ', 35) || P_Num_Workers);
301: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Commit Size : ', 35) || P_commit_size);
302: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));
303:
304:
305: l_stmt_num := 30;
306: Print_Statistics(P_batch_id,

Line 326: FND_FILE.put_line(FND_FILE.OUTPUT, l_msg_data);

322: WHEN G_NO_DATA_FOUND_EXC THEN
323: FND_MESSAGE.Set_Name('OKS', 'OKS_IMP_RPT_NO_DATA');
324: FND_MESSAGE.set_token('REQUEST', P_parent_request_id);
325: l_msg_data := FND_MESSAGE.GET;
326: FND_FILE.put_line(FND_FILE.OUTPUT, l_msg_data);
327: X_errbuf := l_msg_data;
328: WHEN no_data_found THEN
329: FND_MESSAGE.Set_Name('OKS', 'OKS_IMP_RPT_NO_REQUEST');
330: FND_MESSAGE.set_token('REQUEST', P_parent_request_id);

Line 333: FND_FILE.put_line(FND_FILE.OUTPUT, l_msg_data);

329: FND_MESSAGE.Set_Name('OKS', 'OKS_IMP_RPT_NO_REQUEST');
330: FND_MESSAGE.set_token('REQUEST', P_parent_request_id);
331: FND_MESSAGE.set_token('STMT', l_stmt_num);
332: l_msg_data := FND_MESSAGE.GET;
333: FND_FILE.put_line(FND_FILE.OUTPUT, l_msg_data);
334: X_errbuf := l_msg_data;
335: WHEN FND_API.G_EXC_ERROR THEN
336: FND_MSG_PUB.Count_And_Get
337: (p_encoded => FND_API.G_FALSE