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.BIX_KPI_CLS_RPT_PKG dependencies on UTL_FILE

Line 219: logfile UTL_FILE.file_type;

215: p_denom_rate IN NUMBER,
216: p_num_rate In NUMBER )
217: IS
218: l_format_mask VARCHAR2(50);
219: logfile UTL_FILE.file_type;
220: BEGIN
221: /* Get the format mask for the user currency */
222: l_format_mask := fnd_currency.get_format_mask(p_user_currency, 30);
223:

Line 229: UTL_FILE_DIR parameter from v$parameter is set to the /sqlcom/log

225: /* all the rows coreesponding to the classifications user has chosen */
226: form_sqlstmt(p_total_row_ind, p_classification_id, p_site_id);
227:
228: /* The following code is useful while debugging. Make sure that the
229: UTL_FILE_DIR parameter from v$parameter is set to the /sqlcom/log
230: directory. If not change the path in the fopen command below to
231: point to the right directory
232:
233: logfile := UTL_FILE.fopen('/sqlcom/log', 'BIXKCLS.sql', 'w', 2000 );

Line 233: logfile := UTL_FILE.fopen('/sqlcom/log', 'BIXKCLS.sql', 'w', 2000 );

229: UTL_FILE_DIR parameter from v$parameter is set to the /sqlcom/log
230: directory. If not change the path in the fopen command below to
231: point to the right directory
232:
233: logfile := UTL_FILE.fopen('/sqlcom/log', 'BIXKCLS.sql', 'w', 2000 );
234: UTL_FILE.put_line( logfile, 'After fopen ' );
235: UTL_FILE.put_line( logfile, 'Classification Id : ' ||
236: to_char(p_classification_id ) );
237: UTL_FILE.put_line( logfile, 'Site ID : ' || to_char(p_site_id ) );

Line 234: UTL_FILE.put_line( logfile, 'After fopen ' );

230: directory. If not change the path in the fopen command below to
231: point to the right directory
232:
233: logfile := UTL_FILE.fopen('/sqlcom/log', 'BIXKCLS.sql', 'w', 2000 );
234: UTL_FILE.put_line( logfile, 'After fopen ' );
235: UTL_FILE.put_line( logfile, 'Classification Id : ' ||
236: to_char(p_classification_id ) );
237: UTL_FILE.put_line( logfile, 'Site ID : ' || to_char(p_site_id ) );
238: UTL_FILE.put_line( logfile, 'Start date ' ||

Line 235: UTL_FILE.put_line( logfile, 'Classification Id : ' ||

231: point to the right directory
232:
233: logfile := UTL_FILE.fopen('/sqlcom/log', 'BIXKCLS.sql', 'w', 2000 );
234: UTL_FILE.put_line( logfile, 'After fopen ' );
235: UTL_FILE.put_line( logfile, 'Classification Id : ' ||
236: to_char(p_classification_id ) );
237: UTL_FILE.put_line( logfile, 'Site ID : ' || to_char(p_site_id ) );
238: UTL_FILE.put_line( logfile, 'Start date ' ||
239: to_char(p_start_date, 'DD/MM/YYYY HH24:MI:SS' ) );

Line 237: UTL_FILE.put_line( logfile, 'Site ID : ' || to_char(p_site_id ) );

233: logfile := UTL_FILE.fopen('/sqlcom/log', 'BIXKCLS.sql', 'w', 2000 );
234: UTL_FILE.put_line( logfile, 'After fopen ' );
235: UTL_FILE.put_line( logfile, 'Classification Id : ' ||
236: to_char(p_classification_id ) );
237: UTL_FILE.put_line( logfile, 'Site ID : ' || to_char(p_site_id ) );
238: UTL_FILE.put_line( logfile, 'Start date ' ||
239: to_char(p_start_date, 'DD/MM/YYYY HH24:MI:SS' ) );
240: UTL_FILE.put_line(logfile, 'End date ' ||
241: to_char(p_end_date, 'DD/MM/YYYY HH24:MI:SS' ) );

Line 238: UTL_FILE.put_line( logfile, 'Start date ' ||

234: UTL_FILE.put_line( logfile, 'After fopen ' );
235: UTL_FILE.put_line( logfile, 'Classification Id : ' ||
236: to_char(p_classification_id ) );
237: UTL_FILE.put_line( logfile, 'Site ID : ' || to_char(p_site_id ) );
238: UTL_FILE.put_line( logfile, 'Start date ' ||
239: to_char(p_start_date, 'DD/MM/YYYY HH24:MI:SS' ) );
240: UTL_FILE.put_line(logfile, 'End date ' ||
241: to_char(p_end_date, 'DD/MM/YYYY HH24:MI:SS' ) );
242:

Line 240: UTL_FILE.put_line(logfile, 'End date ' ||

236: to_char(p_classification_id ) );
237: UTL_FILE.put_line( logfile, 'Site ID : ' || to_char(p_site_id ) );
238: UTL_FILE.put_line( logfile, 'Start date ' ||
239: to_char(p_start_date, 'DD/MM/YYYY HH24:MI:SS' ) );
240: UTL_FILE.put_line(logfile, 'End date ' ||
241: to_char(p_end_date, 'DD/MM/YYYY HH24:MI:SS' ) );
242:
243: UTL_FILE.put_line(logfile, 'Length of sql statement is ' ||
244: length(g_sqlstmt) );

Line 243: UTL_FILE.put_line(logfile, 'Length of sql statement is ' ||

239: to_char(p_start_date, 'DD/MM/YYYY HH24:MI:SS' ) );
240: UTL_FILE.put_line(logfile, 'End date ' ||
241: to_char(p_end_date, 'DD/MM/YYYY HH24:MI:SS' ) );
242:
243: UTL_FILE.put_line(logfile, 'Length of sql statement is ' ||
244: length(g_sqlstmt) );
245: UTL_FILE.put_line( logfile, g_sqlstmt );
246: UTL_FILE.fclose(logfile);
247: */

Line 245: UTL_FILE.put_line( logfile, g_sqlstmt );

241: to_char(p_end_date, 'DD/MM/YYYY HH24:MI:SS' ) );
242:
243: UTL_FILE.put_line(logfile, 'Length of sql statement is ' ||
244: length(g_sqlstmt) );
245: UTL_FILE.put_line( logfile, g_sqlstmt );
246: UTL_FILE.fclose(logfile);
247: */
248: EXECUTE IMMEDIATE g_sqlstmt USING p_session_id, p_user_currency,
249: p_denom_rate, p_num_rate, l_format_mask, p_user_currency,

Line 246: UTL_FILE.fclose(logfile);

242:
243: UTL_FILE.put_line(logfile, 'Length of sql statement is ' ||
244: length(g_sqlstmt) );
245: UTL_FILE.put_line( logfile, g_sqlstmt );
246: UTL_FILE.fclose(logfile);
247: */
248: EXECUTE IMMEDIATE g_sqlstmt USING p_session_id, p_user_currency,
249: p_denom_rate, p_num_rate, l_format_mask, p_user_currency,
250: p_denom_rate, p_num_rate, l_format_mask, p_classification_id,