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.BIL_BI_PURGE_OBJ_PKG dependencies on FND_LOG

Line 53: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

49: BEGIN
50: g_pkg := 'bil.patch.115.sql.BIL_BI_PURGE_OBJ_PKG.';
51: l_proc := 'TRUNC_OBJ.';
52:
53: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
54: bil_bi_util_collection_pkg.writeLog
55: (
56: p_log_level => fnd_log.LEVEL_PROCEDURE,
57: p_module => g_pkg || l_proc || 'begin',

Line 56: p_log_level => fnd_log.LEVEL_PROCEDURE,

52:
53: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
54: bil_bi_util_collection_pkg.writeLog
55: (
56: p_log_level => fnd_log.LEVEL_PROCEDURE,
57: p_module => g_pkg || l_proc || 'begin',
58: p_msg => 'Start of Procedure '|| l_proc
59: );
60: END IF;

Line 64: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

60: END IF;
61: errbuf := NULL;
62: retcode := 0;
63:
64: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
65: bil_bi_util_collection_pkg.writeLog
66: (p_log_level => fnd_log.LEVEL_STATEMENT,
67: p_module => g_pkg || l_proc || 'End',
68: p_msg => 'p_obj_name =>'||p_obj_name);

Line 66: (p_log_level => fnd_log.LEVEL_STATEMENT,

62: retcode := 0;
63:
64: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
65: bil_bi_util_collection_pkg.writeLog
66: (p_log_level => fnd_log.LEVEL_STATEMENT,
67: p_module => g_pkg || l_proc || 'End',
68: p_msg => 'p_obj_name =>'||p_obj_name);
69: END IF;
70:

Line 153: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

149: retcode := 0;
150: errbuf := 'Truncated ' || p_obj_name ||
151: ' Object(s) successfully' ;
152:
153: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
154: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
155: p_module => g_pkg || l_proc || 'End',
156: p_msg => 'End of Procedure '||l_proc
157: );

Line 154: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

150: errbuf := 'Truncated ' || p_obj_name ||
151: ' Object(s) successfully' ;
152:
153: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
154: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
155: p_module => g_pkg || l_proc || 'End',
156: p_msg => 'End of Procedure '||l_proc
157: );
158: END IF;

Line 165: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

161: g_retcode := -2;
162: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
163: fnd_message.set_token('Error is : ' ,SQLCODE);
164: fnd_message.set_token('Reason is : ', SQLERRM);
165: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
166: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
167: p_module => g_pkg || l_proc || 'proc_error',
168: p_msg => fnd_message.get,
169: p_force_log => TRUE

Line 166: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

162: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
163: fnd_message.set_token('Error is : ' ,SQLCODE);
164: fnd_message.set_token('Reason is : ', SQLERRM);
165: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
166: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
167: p_module => g_pkg || l_proc || 'proc_error',
168: p_msg => fnd_message.get,
169: p_force_log => TRUE
170: );

Line 201: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

197:
198: BEGIN
199: g_pkg := 'bil.patch.115.sql.BIL_BI_PURGE_OBJ_PKG.';
200: l_proc := 'PURGE_OBJ.';
201: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
202: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
203: p_module => g_pkg || l_proc || 'begin',
204: p_msg => 'Start of Procedure '|| l_proc
205: );

Line 202: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

198: BEGIN
199: g_pkg := 'bil.patch.115.sql.BIL_BI_PURGE_OBJ_PKG.';
200: l_proc := 'PURGE_OBJ.';
201: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
202: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
203: p_module => g_pkg || l_proc || 'begin',
204: p_msg => 'Start of Procedure '|| l_proc
205: );
206: END IF;

Line 211: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

207:
208: errbuf := NULL;
209: retcode := 0;
210:
211: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
212: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
213: p_module => g_pkg || l_proc ,
214: p_msg => 'p_obj_name =>'||p_obj_name||' p_end_date => '||p_end_date);
215: END IF;

Line 212: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

208: errbuf := NULL;
209: retcode := 0;
210:
211: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
212: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
213: p_module => g_pkg || l_proc ,
214: p_msg => 'p_obj_name =>'||p_obj_name||' p_end_date => '||p_end_date);
215: END IF;
216:

Line 219: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

215: END IF;
216:
217: g_end_date := TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS');
218:
219: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
220: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
221: p_module => g_pkg || l_proc ,
222: p_msg => ' g_end_date => '||g_end_date);
223: END IF;

Line 220: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

216:
217: g_end_date := TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS');
218:
219: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
220: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
221: p_module => g_pkg || l_proc ,
222: p_msg => ' g_end_date => '||g_end_date);
223: END IF;
224:

Line 227: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

223: END IF;
224:
225: g_end_date_timeid := TO_NUMBER(TO_CHAR(TRUNC(TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS')),'J'));
226:
227: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
228: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
229: p_module => g_pkg || l_proc ,
230: p_msg => ' g_end_date_timid => '||g_end_date_timeid);
231: END IF;

Line 228: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

224:
225: g_end_date_timeid := TO_NUMBER(TO_CHAR(TRUNC(TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS')),'J'));
226:
227: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
228: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
229: p_module => g_pkg || l_proc ,
230: p_msg => ' g_end_date_timid => '||g_end_date_timeid);
231: END IF;
232:

Line 262: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

258: g_status := TRUE;
259: errbuf := 'Purged ' || p_obj_name ||
260: ' Object(s) successfully upto date ' || g_end_date;
261:
262: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
263: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
264: p_module => g_pkg || l_proc || 'End',
265: p_msg => 'End of Procedure '||l_proc
266: );

Line 263: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

259: errbuf := 'Purged ' || p_obj_name ||
260: ' Object(s) successfully upto date ' || g_end_date;
261:
262: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
263: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
264: p_module => g_pkg || l_proc || 'End',
265: p_msg => 'End of Procedure '||l_proc
266: );
267: END IF;

Line 280: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

276: errbuf := g_errbuf;
277: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
278: fnd_message.set_token('Error is : ' ,SQLCODE);
279: fnd_message.set_token('Reason is : ', SQLERRM);
280: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
281: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
282: p_module => g_pkg || l_proc || 'proc_error',
283: p_msg => fnd_message.get,
284: p_force_log => TRUE

Line 281: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

277: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
278: fnd_message.set_token('Error is : ' ,SQLCODE);
279: fnd_message.set_token('Reason is : ', SQLERRM);
280: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
281: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
282: p_module => g_pkg || l_proc || 'proc_error',
283: p_msg => fnd_message.get,
284: p_force_log => TRUE
285: );

Line 306: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

302:
303: BEGIN
304: l_proc := 'OPDTL_F_PURGE.';
305: l_cnt := 0;
306: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
307: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
308: p_module => g_pkg || l_proc || 'begin',
309: p_msg => 'Start of Procedure '|| l_proc
310: );

Line 307: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

303: BEGIN
304: l_proc := 'OPDTL_F_PURGE.';
305: l_cnt := 0;
306: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
307: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
308: p_module => g_pkg || l_proc || 'begin',
309: p_msg => 'Start of Procedure '|| l_proc
310: );
311: END IF;

Line 330: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

326: OR opty_ld_conversion_date IS NULL)
327: AND close_date <= g_end_date; -- added asolaiy after forecast date changes.
328: END IF;
329:
330: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
331: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
332: p_module => g_pkg || l_proc ,
333: p_msg => ' Opdtl Stg Tbl records Deleted :'||SQL%ROWCOUNT);
334: END IF;

Line 331: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

327: AND close_date <= g_end_date; -- added asolaiy after forecast date changes.
328: END IF;
329:
330: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
331: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
332: p_module => g_pkg || l_proc ,
333: p_msg => ' Opdtl Stg Tbl records Deleted :'||SQL%ROWCOUNT);
334: END IF;
335:

Line 346: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

342: AND (opty_ld_conversion_time_id <= g_end_date_timeid
343: OR opty_ld_conversion_time_id IS NULL)
344: AND opty_effective_time_id <= g_end_date_timeid; -- added asolaiy for forecast date changes.
345:
346: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
347: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
348: p_module => g_pkg || l_proc ,
349: p_msg => ' Opdtl_f Summary Tbl records Deleted :'||SQL%ROWCOUNT);
350: END IF;

Line 347: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

343: OR opty_ld_conversion_time_id IS NULL)
344: AND opty_effective_time_id <= g_end_date_timeid; -- added asolaiy for forecast date changes.
345:
346: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
347: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
348: p_module => g_pkg || l_proc ,
349: p_msg => ' Opdtl_f Summary Tbl records Deleted :'||SQL%ROWCOUNT);
350: END IF;
351:

Line 366: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

362: g_retcode := 0;
363: -- Call BIS wrap up and clean up
364: clean_up;
365:
366: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
367: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
368: p_module => g_pkg || l_proc || 'End',
369: p_msg => 'End of Procedure '||l_proc
370: );

Line 367: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

363: -- Call BIS wrap up and clean up
364: clean_up;
365:
366: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
367: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
368: p_module => g_pkg || l_proc || 'End',
369: p_msg => 'End of Procedure '||l_proc
370: );
371: END IF;

Line 381: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

377: g_errbuf := sqlerrm ;
378: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
379: fnd_message.set_token('Error is : ' ,SQLCODE);
380: fnd_message.set_token('Reason is : ', SQLERRM);
381: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
382: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
383: p_module => g_pkg || l_proc || 'proc_error',
384: p_msg => fnd_message.get,
385: p_force_log => TRUE

Line 382: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

378: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
379: fnd_message.set_token('Error is : ' ,SQLCODE);
380: fnd_message.set_token('Reason is : ', SQLERRM);
381: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
382: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
383: p_module => g_pkg || l_proc || 'proc_error',
384: p_msg => fnd_message.get,
385: p_force_log => TRUE
386: );

Line 409: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

405: BEGIN
406: l_proc := 'PIPELINE_F_PURGE.';
407: l_cnt := 0;
408:
409: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
410: bil_bi_util_collection_pkg.writeLog
411: (
412: p_log_level => fnd_log.LEVEL_PROCEDURE,
413: p_module => g_pkg || l_proc || 'begin',

Line 412: p_log_level => fnd_log.LEVEL_PROCEDURE,

408:
409: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
410: bil_bi_util_collection_pkg.writeLog
411: (
412: p_log_level => fnd_log.LEVEL_PROCEDURE,
413: p_module => g_pkg || l_proc || 'begin',
414: p_msg => 'Start of Procedure '|| l_proc
415: );
416: END IF;

Line 435: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

431: DELETE FROM bil_bi_pipeline_stg
432: WHERE snap_date <= g_end_date;
433: END IF;
434:
435: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
436: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
437: p_module => g_pkg || l_proc ,
438: p_msg => ' Pipeline Stg Tbl records Deleted :'||SQL%ROWCOUNT);
439: END IF;

Line 436: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

432: WHERE snap_date <= g_end_date;
433: END IF;
434:
435: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
436: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
437: p_module => g_pkg || l_proc ,
438: p_msg => ' Pipeline Stg Tbl records Deleted :'||SQL%ROWCOUNT);
439: END IF;
440:

Line 447: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

443: DELETE FROM bil_bi_pipeline_f
444: WHERE snap_date <= g_end_date;
445:
446:
447: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
448: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
449: p_module => g_pkg || l_proc ,
450: p_msg => ' Pipeline_f Summary Tbl records Deleted :'||SQL%ROWCOUNT);
451: END IF;

Line 448: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

444: WHERE snap_date <= g_end_date;
445:
446:
447: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
448: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
449: p_module => g_pkg || l_proc ,
450: p_msg => ' Pipeline_f Summary Tbl records Deleted :'||SQL%ROWCOUNT);
451: END IF;
452:

Line 460: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

456: DELETE FROM bil_bi_pipec_f
457: WHERE snap_date <= g_end_date;
458:
459:
460: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
461: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
462: p_module => g_pkg || l_proc ,
463: p_msg => ' Pipec_f Summary Tbl records Deleted :'||SQL%ROWCOUNT);
464: END IF;

Line 461: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

457: WHERE snap_date <= g_end_date;
458:
459:
460: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
461: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
462: p_module => g_pkg || l_proc ,
463: p_msg => ' Pipec_f Summary Tbl records Deleted :'||SQL%ROWCOUNT);
464: END IF;
465:

Line 495: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

491:
492: -- Call BIS wrap up and clean up
493: clean_up;
494:
495: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
496: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
497: p_module => g_pkg || l_proc || 'End',
498: p_msg => 'End of Procedure '||l_proc
499: );

Line 496: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

492: -- Call BIS wrap up and clean up
493: clean_up;
494:
495: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
496: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
497: p_module => g_pkg || l_proc || 'End',
498: p_msg => 'End of Procedure '||l_proc
499: );
500: END IF;

Line 511: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

507: g_errbuf := sqlerrm ;
508: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
509: fnd_message.set_token('Error is : ' ,SQLCODE);
510: fnd_message.set_token('Reason is : ', SQLERRM);
511: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
512: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
513: p_module => g_pkg || l_proc || 'proc_error',
514: p_msg => fnd_message.get,
515: p_force_log => TRUE);

Line 512: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

508: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
509: fnd_message.set_token('Error is : ' ,SQLCODE);
510: fnd_message.set_token('Reason is : ', SQLERRM);
511: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
512: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
513: p_module => g_pkg || l_proc || 'proc_error',
514: p_msg => fnd_message.get,
515: p_force_log => TRUE);
516: END IF;

Line 543: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

539: l_proc VARCHAR2(100);
540:
541: BEGIN
542: l_proc := 'FST_DTL_F_PURGE.';
543: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
544: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
545: p_module => g_pkg || l_proc || 'begin',
546: p_msg => 'Start of Procedure '|| l_proc
547: );

Line 544: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

540:
541: BEGIN
542: l_proc := 'FST_DTL_F_PURGE.';
543: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
544: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
545: p_module => g_pkg || l_proc || 'begin',
546: p_msg => 'Start of Procedure '|| l_proc
547: );
548: END IF;

Line 551: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

547: );
548: END IF;
549:
550: -- Initialize the WHO Variables
551: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
552: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
553: p_module => g_pkg || l_proc ,
554: p_msg => ' Initialize the WHO Variables ');
555: END IF;

Line 552: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

548: END IF;
549:
550: -- Initialize the WHO Variables
551: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
552: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
553: p_module => g_pkg || l_proc ,
554: p_msg => ' Initialize the WHO Variables ');
555: END IF;
556:

Line 570: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,

566:
567: IF (NOT bis_common_parameters.check_global_parameters(l_list)) THEN -- Check Parameters
568: bis_common_parameters.get_global_parameters(l_list, l_val);
569: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
570: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
571: p_module => g_pkg || l_proc || 'proc_error',
572: p_msg => fnd_message.get,
573: p_force_log => TRUE);
574: FOR v_counter IN 1..3 LOOP

Line 580: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,

576: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
577: fnd_message.set_token('PROFILE_USER_NAME' ,
578: bil_bi_util_collection_pkg.get_user_profile_name(l_list(v_counter)));
579: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(v_counter));
580: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
581: p_module => g_pkg || l_proc || 'proc_error',
582: p_msg => fnd_message.get,
583: p_force_log => TRUE);
584: END IF;

Line 591: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

587: ELSE
588: bis_common_parameters.get_global_parameters(l_list, l_val);
589: END IF; -- Check Parameters Ends Here
590:
591: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
592: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
593: p_module => g_pkg || l_proc ,
594: p_msg => 'l_val(1) = ' || l_val(1) || ' l_val(2)= ' || l_val(2) ||
595: ' l_val(3)= ' || l_val(3));

Line 592: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

588: bis_common_parameters.get_global_parameters(l_list, l_val);
589: END IF; -- Check Parameters Ends Here
590:
591: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
592: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
593: p_module => g_pkg || l_proc ,
594: p_msg => 'l_val(1) = ' || l_val(1) || ' l_val(2)= ' || l_val(2) ||
595: ' l_val(3)= ' || l_val(3));
596: END IF;

Line 682: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

678: ' l_end_dt_ent_qtr_id =>'||l_end_dt_ent_qtr_id||' '||
679: ' l_end_dt_ent_period_id =>'||l_end_dt_ent_per_id||' '||
680: ' l_end_dt_ent_week_id =>'||l_end_dt_week_id ;
681:
682: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
683: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
684: p_module => g_pkg || l_proc ,
685: p_msg => 'Parameters '||l_stmt);
686: END IF;

Line 683: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

679: ' l_end_dt_ent_period_id =>'||l_end_dt_ent_per_id||' '||
680: ' l_end_dt_ent_week_id =>'||l_end_dt_week_id ;
681:
682: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
683: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
684: p_module => g_pkg || l_proc ,
685: p_msg => 'Parameters '||l_stmt);
686: END IF;
687:

Line 701: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

697: OR (forecast_time_id <= l_end_dt_ent_year_id
698: AND forecast_period_type_id = 128));
699:
700: l_stmt := ' Summary Tbl records Eff Dt < End Dt Deleted';
701: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
702: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
703: p_module => g_pkg || l_proc ,
704: p_msg => l_stmt|| ' '||SQL%ROWCOUNT);
705: END IF;

Line 702: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

698: AND forecast_period_type_id = 128));
699:
700: l_stmt := ' Summary Tbl records Eff Dt < End Dt Deleted';
701: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
702: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
703: p_module => g_pkg || l_proc ,
704: p_msg => l_stmt|| ' '||SQL%ROWCOUNT);
705: END IF;
706:

Line 715: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

711: WHEN OTHERS THEN
712: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
713: fnd_message.set_token('Error is : ' ,SQLCODE);
714: fnd_message.set_token('Reason is : ', SQLERRM);
715: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
716: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
717: p_module => g_pkg || l_proc || 'proc_error',
718: p_msg => fnd_message.get,
719: p_force_log => TRUE);

Line 716: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

712: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
713: fnd_message.set_token('Error is : ' ,SQLCODE);
714: fnd_message.set_token('Reason is : ', SQLERRM);
715: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
716: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
717: p_module => g_pkg || l_proc || 'proc_error',
718: p_msg => fnd_message.get,
719: p_force_log => TRUE);
720: END IF;

Line 734: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

730: AND gl.period_set_name = l_val(3)
731: AND gl.end_date <= g_end_date
732: );
733: l_stmt := ' Rows deleted from processed_fst_id table ';
734: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
735: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
736: p_module => g_pkg || l_proc ,
737: p_msg => l_stmt|| ''||SQL%ROWCOUNT);
738: END IF;

Line 735: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

731: AND gl.end_date <= g_end_date
732: );
733: l_stmt := ' Rows deleted from processed_fst_id table ';
734: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
735: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
736: p_module => g_pkg || l_proc ,
737: p_msg => l_stmt|| ''||SQL%ROWCOUNT);
738: END IF;
739: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');

Line 754: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

750: g_status := TRUE;
751: g_retcode := 0;
752: -- Call BIS wrap up and clean up
753: clean_up;
754: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
755: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
756: p_module => g_pkg || l_proc || 'End',
757: p_msg => 'End of Procedure '||l_proc
758: );

Line 755: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

751: g_retcode := 0;
752: -- Call BIS wrap up and clean up
753: clean_up;
754: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
755: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
756: p_module => g_pkg || l_proc || 'End',
757: p_msg => 'End of Procedure '||l_proc
758: );
759: END IF;

Line 774: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

770: g_errbuf := sqlerrm ;
771: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
772: fnd_message.set_token('Error is : ' ,SQLCODE);
773: fnd_message.set_token('Reason is : ', SQLERRM);
774: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
775: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
776: p_module => g_pkg || l_proc || 'proc_error',
777: p_msg => fnd_message.get,
778: p_force_log => TRUE

Line 775: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

771: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
772: fnd_message.set_token('Error is : ' ,SQLCODE);
773: fnd_message.set_token('Reason is : ', SQLERRM);
774: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
775: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
776: p_module => g_pkg || l_proc || 'proc_error',
777: p_msg => fnd_message.get,
778: p_force_log => TRUE
779: );

Line 799: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

795: l_proc VARCHAR2(100);
796: BEGIN
797: l_valid_setup := FALSE;
798: l_proc := 'INIT.';
799: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
800: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
801: p_module => g_pkg || l_proc || 'begin',
802: p_msg => 'Start of Procedure '||l_proc
803: );

Line 800: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

796: BEGIN
797: l_valid_setup := FALSE;
798: l_proc := 'INIT.';
799: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
800: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
801: p_module => g_pkg || l_proc || 'begin',
802: p_msg => 'Start of Procedure '||l_proc
803: );
804: END IF;

Line 820: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

816: -- Call generic Setup procedure
817: l_valid_setup := BIS_COLLECTION_UTILITIES.SETUP(p_object_name => 'BIL_BI_'|| p_obj_name ||'_PURGE');
818:
819: IF l_valid_setup THEN
820: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
821: bil_bi_util_collection_pkg.writeLog
822: (
823: p_log_level => fnd_log.LEVEL_STATEMENT,
824: p_module => g_pkg || l_proc ||' BIS Setup ',

Line 823: p_log_level => fnd_log.LEVEL_STATEMENT,

819: IF l_valid_setup THEN
820: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
821: bil_bi_util_collection_pkg.writeLog
822: (
823: p_log_level => fnd_log.LEVEL_STATEMENT,
824: p_module => g_pkg || l_proc ||' BIS Setup ',
825: p_msg => 'BIS Setup successful'
826: );
827: END IF;

Line 829: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

825: p_msg => 'BIS Setup successful'
826: );
827: END IF;
828: ELSE
829: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
830: bil_bi_util_collection_pkg.writeLog
831: (
832: p_log_level => fnd_log.LEVEL_STATEMENT,
833: p_module => g_pkg || l_proc ||' BIS Setup ',

Line 832: p_log_level => fnd_log.LEVEL_STATEMENT,

828: ELSE
829: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
830: bil_bi_util_collection_pkg.writeLog
831: (
832: p_log_level => fnd_log.LEVEL_STATEMENT,
833: p_module => g_pkg || l_proc ||' BIS Setup ',
834: p_msg => 'BIS Setup Failed'
835: );
836: END IF;

Line 841: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

837: g_retcode := 2;
838: RETURN;
839: END IF;
840:
841: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
842: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
843: p_module => g_pkg || l_proc || 'End',
844: p_msg => 'End of Procedure '||l_proc);
845: END IF;

Line 842: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

838: RETURN;
839: END IF;
840:
841: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
842: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
843: p_module => g_pkg || l_proc || 'End',
844: p_msg => 'End of Procedure '||l_proc);
845: END IF;
846:

Line 854: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

850: g_errbuf := sqlerrm ;
851: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
852: fnd_message.set_token('Error is : ' ,SQLCODE);
853: fnd_message.set_token('Reason is : ', SQLERRM);
854: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
855: bil_bi_util_collection_pkg.writeLog
856: (
857: p_log_level => fnd_log.LEVEL_UNEXPECTED,
858: p_module => g_pkg || l_proc || 'proc_error',

Line 857: p_log_level => fnd_log.LEVEL_UNEXPECTED,

853: fnd_message.set_token('Reason is : ', SQLERRM);
854: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
855: bil_bi_util_collection_pkg.writeLog
856: (
857: p_log_level => fnd_log.LEVEL_UNEXPECTED,
858: p_module => g_pkg || l_proc || 'proc_error',
859: p_msg => fnd_message.get,
860: p_force_log => TRUE
861: );

Line 879: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

875: PROCEDURE clean_up IS
876: l_proc VARCHAR2(100);
877: BEGIN
878: l_proc := 'CLEAN_UP.';
879: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
880: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
881: p_module => g_pkg || l_proc || 'begin',
882: p_msg => 'Start of Procedure '||l_proc
883: );

Line 880: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

876: l_proc VARCHAR2(100);
877: BEGIN
878: l_proc := 'CLEAN_UP.';
879: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
880: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
881: p_module => g_pkg || l_proc || 'begin',
882: p_msg => 'Start of Procedure '||l_proc
883: );
884: END IF;

Line 899: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

895: p_message => NULL,
896: p_period_from => NULL,
897: p_period_to => g_end_date);
898: END IF;
899: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
900: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
901: p_module => g_pkg || l_proc || 'End',
902: p_msg => 'End of Procedure '||l_proc);
903: END IF;

Line 900: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

896: p_period_from => NULL,
897: p_period_to => g_end_date);
898: END IF;
899: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
900: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
901: p_module => g_pkg || l_proc || 'End',
902: p_msg => 'End of Procedure '||l_proc);
903: END IF;
904: EXCEPTION

Line 911: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

907: g_errbuf := sqlerrm;
908: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
909: fnd_message.set_token('Error is : ' ,SQLCODE);
910: fnd_message.set_token('Reason is : ', SQLERRM);
911: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
912: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
913: p_module => g_pkg || l_proc || 'proc_error',
914: p_msg => fnd_message.get,
915: p_force_log => TRUE

Line 912: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

908: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
909: fnd_message.set_token('Error is : ' ,SQLCODE);
910: fnd_message.set_token('Reason is : ', SQLERRM);
911: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
912: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
913: p_module => g_pkg || l_proc || 'proc_error',
914: p_msg => fnd_message.get,
915: p_force_log => TRUE
916: );