APPS.BIL_BI_PIPELINE_F_PKG dependencies on BIL_BI_UTIL_COLLECTION_PKG

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

103: PROCEDURE Populate_Curr_Rate_SmallGap IS
104: l_proc VARCHAR2(100);
105: BEGIN
106: l_proc := 'Populate_Currency_Rate_SmallGap';
107: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
108: bil_bi_util_collection_pkg.writeLog(
109: p_log_level => fnd_log.LEVEL_PROCEDURE,
110: p_module => g_pkg || l_proc || ' begin',
111: p_msg => 'Start of Procedure '|| l_proc);

Line 108: bil_bi_util_collection_pkg.writeLog(

104: l_proc VARCHAR2(100);
105: BEGIN
106: l_proc := 'Populate_Currency_Rate_SmallGap';
107: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
108: bil_bi_util_collection_pkg.writeLog(
109: p_log_level => fnd_log.LEVEL_PROCEDURE,
110: p_module => g_pkg || l_proc || ' begin',
111: p_msg => 'Start of Procedure '|| l_proc);
112: END IF;

Line 158: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

154: rates.srate
155: );
156: commit;
157:
158: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
159: bil_bi_util_collection_pkg.writeLog(
160: p_log_level => fnd_log.LEVEL_EVENT,
161: p_module => g_pkg || l_proc ,
162: p_msg => 'Inserted '||sql%rowcount||' into bil_bi_currency_rate table');

Line 159: bil_bi_util_collection_pkg.writeLog(

155: );
156: commit;
157:
158: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
159: bil_bi_util_collection_pkg.writeLog(
160: p_log_level => fnd_log.LEVEL_EVENT,
161: p_module => g_pkg || l_proc ,
162: p_msg => 'Inserted '||sql%rowcount||' into bil_bi_currency_rate table');
163: END IF;

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

161: p_module => g_pkg || l_proc ,
162: p_msg => 'Inserted '||sql%rowcount||' into bil_bi_currency_rate table');
163: END IF;
164:
165: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
166: bil_bi_util_collection_pkg.writeLog(
167: p_log_level => fnd_log.LEVEL_PROCEDURE,
168: p_module => g_pkg || l_proc || ' end',
169: p_msg => 'End of Procedure '|| l_proc);

Line 166: bil_bi_util_collection_pkg.writeLog(

162: p_msg => 'Inserted '||sql%rowcount||' into bil_bi_currency_rate table');
163: END IF;
164:
165: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
166: bil_bi_util_collection_pkg.writeLog(
167: p_log_level => fnd_log.LEVEL_PROCEDURE,
168: p_module => g_pkg || l_proc || ' end',
169: p_msg => 'End of Procedure '|| l_proc);
170: END IF;

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

173: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
174: fnd_message.set_token('ERRNO' ,SQLCODE);
175: fnd_message.set_token('REASON' ,SQLERRM);
176: fnd_message.set_token('ROUTINE' , l_proc);
177: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
178: p_module => g_pkg || l_proc || ' proc_error',
179: p_msg => fnd_message.get,
180: p_force_log => TRUE);
181:

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

226: l_count :=0;
227: l_number_of_rows :=0;
228: l_proc := 'Summary_Err_Check_SmallGap';
229:
230: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
231: bil_bi_util_collection_pkg.writeLog(
232: p_log_level => fnd_log.LEVEL_PROCEDURE,
233: p_module => g_pkg || l_proc || ' begin',
234: p_msg => 'Start of Procedure '|| l_proc);

Line 231: bil_bi_util_collection_pkg.writeLog(

227: l_number_of_rows :=0;
228: l_proc := 'Summary_Err_Check_SmallGap';
229:
230: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
231: bil_bi_util_collection_pkg.writeLog(
232: p_log_level => fnd_log.LEVEL_PROCEDURE,
233: p_module => g_pkg || l_proc || ' begin',
234: p_msg => 'Start of Procedure '|| l_proc);
235: END IF;

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

258:
259: -- need this commit for the rollup not to roll back all the currencys, doesn't really matter anyway
260: commit;
261:
262: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
263: bil_bi_util_collection_pkg.writeLog(
264: p_log_level => fnd_log.LEVEL_EVENT,
265: p_module => g_pkg || l_proc ,
266: p_msg => 'Updated rates for '|| sql%rowcount || ' rows');

Line 263: bil_bi_util_collection_pkg.writeLog(

259: -- need this commit for the rollup not to roll back all the currencys, doesn't really matter anyway
260: commit;
261:
262: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
263: bil_bi_util_collection_pkg.writeLog(
264: p_log_level => fnd_log.LEVEL_EVENT,
265: p_module => g_pkg || l_proc ,
266: p_msg => 'Updated rates for '|| sql%rowcount || ' rows');
267: END IF;

Line 278: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

274: WHERE (prim_conversion_rate < 0 OR prim_conversion_rate IS NULL)
275: OR (g_sec_currency IS NOT NULL and (conversion_rate_s < 0 OR conversion_rate_s IS NULL)) ;
276:
277: IF (l_conv_rate_cnt >0) THEN
278: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
279: bil_bi_util_collection_pkg.writeLog
280: (
281: p_log_level =>fnd_log.LEVEL_ERROR,
282: p_module => g_pkg || l_proc ,

Line 279: bil_bi_util_collection_pkg.writeLog

275: OR (g_sec_currency IS NOT NULL and (conversion_rate_s < 0 OR conversion_rate_s IS NULL)) ;
276:
277: IF (l_conv_rate_cnt >0) THEN
278: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
279: bil_bi_util_collection_pkg.writeLog
280: (
281: p_log_level =>fnd_log.LEVEL_ERROR,
282: p_module => g_pkg || l_proc ,
283: p_msg => 'Missing currency conversion rates found, program will exit with error status.'||

Line 322: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

318: END IF;
319: l_has_missing_date := FALSE;
320:
321: IF (l_has_missing_date) THEN
322: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
323: bil_bi_util_collection_pkg.writeLog
324: (
325: p_log_level => fnd_log.LEVEL_EVENT,
326: p_module => g_pkg || l_proc ,

Line 323: bil_bi_util_collection_pkg.writeLog

319: l_has_missing_date := FALSE;
320:
321: IF (l_has_missing_date) THEN
322: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
323: bil_bi_util_collection_pkg.writeLog
324: (
325: p_log_level => fnd_log.LEVEL_EVENT,
326: p_module => g_pkg || l_proc ,
327: p_msg => 'Time Dimension is not fully populated. '||

Line 356: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

352:
353: IF(l_number_of_rows=1) THEN
354: -- print header
355:
356: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
357: bil_bi_util_collection_pkg.writeLog
358: (
359: p_log_level => fnd_log.LEVEL_EVENT,
360: p_module => g_pkg || l_proc ,

Line 357: bil_bi_util_collection_pkg.writeLog

353: IF(l_number_of_rows=1) THEN
354: -- print header
355:
356: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
357: bil_bi_util_collection_pkg.writeLog
358: (
359: p_log_level => fnd_log.LEVEL_EVENT,
360: p_module => g_pkg || l_proc ,
361: p_msg => ' Some opportunties had null product category. They have not been collected.'

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

362: );
363: END IF;
364:
365: fnd_message.set_name('BIL','BIL_BI_ITEM_PROD_WARN_HDR');
366: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
367: p_module => g_pkg || l_proc || ' proc_error',
368: p_msg => fnd_message.get,
369: p_force_log => TRUE);
370: END IF;

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

372: -- print detail
373:
374: fnd_message.set_name('BIL','BIL_BI_ITEM_PROD_ERR_DTL');
375: fnd_message.set_token('OPPNUM', l_lead_num);
376: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
377: p_module => g_pkg || l_proc || ' proc_error',
378: p_msg => fnd_message.get,
379: p_force_log => TRUE);
380:

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

391: x_return_warn := 'N';
392: END IF;
393:
394:
395: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
396: bil_bi_util_collection_pkg.writeLog(
397: p_log_level => fnd_log.LEVEL_PROCEDURE,
398: p_module => g_pkg || l_proc || ' end',
399: p_msg => 'End of Procedure '|| l_proc);

Line 396: bil_bi_util_collection_pkg.writeLog(

392: END IF;
393:
394:
395: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
396: bil_bi_util_collection_pkg.writeLog(
397: p_log_level => fnd_log.LEVEL_PROCEDURE,
398: p_module => g_pkg || l_proc || ' end',
399: p_msg => 'End of Procedure '|| l_proc);
400: END IF;

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

404: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
405: fnd_message.set_token('ERRNO' ,SQLCODE);
406: fnd_message.set_token('REASON' ,SQLERRM);
407: fnd_message.set_token('ROUTINE' , l_proc);
408: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
409: p_module => g_pkg || l_proc || ' proc_error',
410: p_msg => fnd_message.get,
411: p_force_log => TRUE);
412: Raise;

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

429:
430: BEGIN
431:
432: l_proc := 'get_period_ids';
433: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
434: bil_bi_util_collection_pkg.writeLog(
435: p_log_level => fnd_log.LEVEL_PROCEDURE,
436: p_module => g_pkg || l_proc || ' begin',
437: p_msg => 'Start of Procedure '|| l_proc);

Line 434: bil_bi_util_collection_pkg.writeLog(

430: BEGIN
431:
432: l_proc := 'get_period_ids';
433: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
434: bil_bi_util_collection_pkg.writeLog(
435: p_log_level => fnd_log.LEVEL_PROCEDURE,
436: p_module => g_pkg || l_proc || ' begin',
437: p_msg => 'Start of Procedure '|| l_proc);
438: END IF;

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

452: AND time1.report_date = time.ent_year_start_date
453: AND time2.report_date = time.ent_year_end_date ;
454:
455:
456: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
457: bil_bi_util_collection_pkg.writeLog(
458: p_log_level => fnd_log.LEVEL_PROCEDURE,
459: p_module => g_pkg || l_proc || ' end',
460: p_msg => 'End of Procedure '|| l_proc);

Line 457: bil_bi_util_collection_pkg.writeLog(

453: AND time2.report_date = time.ent_year_end_date ;
454:
455:
456: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
457: bil_bi_util_collection_pkg.writeLog(
458: p_log_level => fnd_log.LEVEL_PROCEDURE,
459: p_module => g_pkg || l_proc || ' end',
460: p_msg => 'End of Procedure '|| l_proc);
461: END IF;

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

468: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
469: fnd_message.set_token('ERRNO' ,SQLCODE);
470: fnd_message.set_token('REASON', SQLERRM);
471: fnd_message.set_token('ROUTINE', l_proc);
472: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
473: p_module => g_pkg || l_proc || ' proc_error',
474: p_msg => fnd_message.get,
475: p_force_log => TRUE);
476:

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

492:
493: begin
494: l_proc := 'is_date_end_of_prd';
495:
496: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
497: bil_bi_util_collection_pkg.writeLog(
498: p_log_level => fnd_log.LEVEL_PROCEDURE,
499: p_module => g_pkg || l_proc || ' begin',
500: p_msg => 'Start of Procedure '|| l_proc);

Line 497: bil_bi_util_collection_pkg.writeLog(

493: begin
494: l_proc := 'is_date_end_of_prd';
495:
496: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
497: bil_bi_util_collection_pkg.writeLog(
498: p_log_level => fnd_log.LEVEL_PROCEDURE,
499: p_module => g_pkg || l_proc || ' begin',
500: p_msg => 'Start of Procedure '|| l_proc);
501: END IF;

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

513: l_is_eop := FALSE;
514: END IF;
515:
516:
517: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
518: bil_bi_util_collection_pkg.writeLog(
519: p_log_level => fnd_log.LEVEL_PROCEDURE,
520: p_module => g_pkg || l_proc || ' end',
521: p_msg => 'End of Procedure '|| l_proc);

Line 518: bil_bi_util_collection_pkg.writeLog(

514: END IF;
515:
516:
517: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
518: bil_bi_util_collection_pkg.writeLog(
519: p_log_level => fnd_log.LEVEL_PROCEDURE,
520: p_module => g_pkg || l_proc || ' end',
521: p_msg => 'End of Procedure '|| l_proc);
522: END IF;

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

529: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
530: fnd_message.set_token('ERRNO' ,SQLCODE);
531: fnd_message.set_token('REASON', SQLERRM);
532: fnd_message.set_token('ROUTINE', l_proc);
533: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
534: p_module => g_pkg || l_proc || ' proc_error',
535: p_msg => fnd_message.get,
536: p_force_log => TRUE);
537:

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

548:
549: begin
550: l_proc := 'delete_from_curr';
551:
552: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
553: bil_bi_util_collection_pkg.writeLog(
554: p_log_level => fnd_log.LEVEL_PROCEDURE,
555: p_module => g_pkg || l_proc || ' begin',
556: p_msg => 'Start of Procedure '|| l_proc);

Line 553: bil_bi_util_collection_pkg.writeLog(

549: begin
550: l_proc := 'delete_from_curr';
551:
552: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
553: bil_bi_util_collection_pkg.writeLog(
554: p_log_level => fnd_log.LEVEL_PROCEDURE,
555: p_module => g_pkg || l_proc || ' begin',
556: p_msg => 'Start of Procedure '|| l_proc);
557: END IF;

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

663: DELETE FROM BIL_BI_PIPEC_F
664: where snap_date < p_curr_coll_start;
665: commit;
666:
667: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
668: bil_bi_util_collection_pkg.writeLog(
669: p_log_level => fnd_log.LEVEL_PROCEDURE,
670: p_module => g_pkg || l_proc || ' end',
671: p_msg => 'End of Procedure '|| l_proc);

Line 668: bil_bi_util_collection_pkg.writeLog(

664: where snap_date < p_curr_coll_start;
665: commit;
666:
667: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
668: bil_bi_util_collection_pkg.writeLog(
669: p_log_level => fnd_log.LEVEL_PROCEDURE,
670: p_module => g_pkg || l_proc || ' end',
671: p_msg => 'End of Procedure '|| l_proc);
672: END IF;

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

678: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
679: fnd_message.set_token('ERRNO' ,SQLCODE);
680: fnd_message.set_token('REASON', SQLERRM);
681: fnd_message.set_token('ROUTINE', l_proc);
682: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
683: p_module => g_pkg || l_proc || ' proc_error',
684: p_msg => fnd_message.get,
685: p_force_log => TRUE);
686:

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

697:
698: begin
699: l_proc := 'populate_hist_dates';
700:
701: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
702: bil_bi_util_collection_pkg.writeLog(
703: p_log_level => fnd_log.LEVEL_PROCEDURE,
704: p_module => g_pkg || l_proc || ' begin',
705: p_msg => 'Start of Procedure '|| l_proc);

Line 702: bil_bi_util_collection_pkg.writeLog(

698: begin
699: l_proc := 'populate_hist_dates';
700:
701: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
702: bil_bi_util_collection_pkg.writeLog(
703: p_log_level => fnd_log.LEVEL_PROCEDURE,
704: p_module => g_pkg || l_proc || ' begin',
705: p_msg => 'Start of Procedure '|| l_proc);
706: END IF;

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

727: time1.week_start_date < time1.ent_period_start_date))
728: );
729: commit;
730:
731: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
732: bil_bi_util_collection_pkg.writeLog(
733: p_log_level => fnd_log.LEVEL_PROCEDURE,
734: p_module => g_pkg || l_proc || ' end',
735: p_msg => 'End of Procedure '|| l_proc);

Line 732: bil_bi_util_collection_pkg.writeLog(

728: );
729: commit;
730:
731: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
732: bil_bi_util_collection_pkg.writeLog(
733: p_log_level => fnd_log.LEVEL_PROCEDURE,
734: p_module => g_pkg || l_proc || ' end',
735: p_msg => 'End of Procedure '|| l_proc);
736: END IF;

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

742: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
743: fnd_message.set_token('ERRNO' ,SQLCODE);
744: fnd_message.set_token('REASON', SQLERRM);
745: fnd_message.set_token('ROUTINE', l_proc);
746: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
747: p_module => g_pkg || l_proc || ' proc_error',
748: p_msg => fnd_message.get,
749: p_force_log => TRUE);
750:

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

762:
763: begin
764: l_proc := 'get_start_curr_coll';
765:
766: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
767: bil_bi_util_collection_pkg.writeLog(
768: p_log_level => fnd_log.LEVEL_PROCEDURE,
769: p_module => g_pkg || l_proc || ' begin',
770: p_msg => 'Start of Procedure '|| l_proc);

Line 767: bil_bi_util_collection_pkg.writeLog(

763: begin
764: l_proc := 'get_start_curr_coll';
765:
766: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
767: bil_bi_util_collection_pkg.writeLog(
768: p_log_level => fnd_log.LEVEL_PROCEDURE,
769: p_module => g_pkg || l_proc || ' begin',
770: p_msg => 'Start of Procedure '|| l_proc);
771: END IF;

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

778: INTO l_curr_collect_start
779: FROM fii_time_week
780: WHERE l_last_fact_run-21 BETWEEN start_date AND end_date;
781:
782: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
783: bil_bi_util_collection_pkg.writeLog(
784: p_log_level => fnd_log.LEVEL_PROCEDURE,
785: p_module => g_pkg || l_proc || ' end',
786: p_msg => 'End of Procedure '|| l_proc);

Line 783: bil_bi_util_collection_pkg.writeLog(

779: FROM fii_time_week
780: WHERE l_last_fact_run-21 BETWEEN start_date AND end_date;
781:
782: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
783: bil_bi_util_collection_pkg.writeLog(
784: p_log_level => fnd_log.LEVEL_PROCEDURE,
785: p_module => g_pkg || l_proc || ' end',
786: p_msg => 'End of Procedure '|| l_proc);
787: END IF;

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

794: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
795: fnd_message.set_token('ERRNO' ,SQLCODE);
796: fnd_message.set_token('REASON', SQLERRM);
797: fnd_message.set_token('ROUTINE', l_proc);
798: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
799: p_module => g_pkg || l_proc || ' proc_error',
800: p_msg => fnd_message.get,
801: p_force_log => TRUE);
802:

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

826:
827: begin
828: l_proc := 'get_last_failure_period';
829: l_status := 'FAILURE';
830: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
831: bil_bi_util_collection_pkg.writeLog(
832: p_log_level => fnd_log.LEVEL_PROCEDURE,
833: p_module => g_pkg || l_proc || ' begin',
834: p_msg => 'Start of Procedure '|| l_proc);

Line 831: bil_bi_util_collection_pkg.writeLog(

827: begin
828: l_proc := 'get_last_failure_period';
829: l_status := 'FAILURE';
830: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
831: bil_bi_util_collection_pkg.writeLog(
832: p_log_level => fnd_log.LEVEL_PROCEDURE,
833: p_module => g_pkg || l_proc || ' begin',
834: p_msg => 'Start of Procedure '|| l_proc);
835: END IF;

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

841: p_period_to:=null;
842: end if;
843: close last_refresh_date_cursor;
844:
845: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
846: bil_bi_util_collection_pkg.writeLog(
847: p_log_level => fnd_log.LEVEL_PROCEDURE,
848: p_module => g_pkg || l_proc || ' end',
849: p_msg => 'End of Procedure '|| l_proc);

Line 846: bil_bi_util_collection_pkg.writeLog(

842: end if;
843: close last_refresh_date_cursor;
844:
845: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
846: bil_bi_util_collection_pkg.writeLog(
847: p_log_level => fnd_log.LEVEL_PROCEDURE,
848: p_module => g_pkg || l_proc || ' end',
849: p_msg => 'End of Procedure '|| l_proc);
850: END IF;

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

860: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
861: fnd_message.set_token('ERRNO' ,SQLCODE);
862: fnd_message.set_token('REASON', SQLERRM);
863: fnd_message.set_token('ROUTINE', l_proc);
864: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
865: p_module => g_pkg || l_proc || ' proc_error',
866: p_msg => fnd_message.get,
867: p_force_log => TRUE);
868:

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

879: begin
880: l_proc := 'get_first_success_period';
881: l_status := 'SUCCESS';
882:
883: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
884: bil_bi_util_collection_pkg.writeLog(
885: p_log_level => fnd_log.LEVEL_PROCEDURE,
886: p_module => g_pkg || l_proc || ' begin',
887: p_msg => 'Start of Procedure '|| l_proc);

Line 884: bil_bi_util_collection_pkg.writeLog(

880: l_proc := 'get_first_success_period';
881: l_status := 'SUCCESS';
882:
883: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
884: bil_bi_util_collection_pkg.writeLog(
885: p_log_level => fnd_log.LEVEL_PROCEDURE,
886: p_module => g_pkg || l_proc || ' begin',
887: p_msg => 'Start of Procedure '|| l_proc);
888: END IF;

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

903: END IF;
904:
905: l_date_disp := fnd_date.date_to_displaydt (l_date);
906:
907: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
908: bil_bi_util_collection_pkg.writeLog(
909: p_log_level => fnd_log.LEVEL_PROCEDURE,
910: p_module => g_pkg || l_proc || ' end',
911: p_msg => 'End of Procedure '|| l_proc);

Line 908: bil_bi_util_collection_pkg.writeLog(

904:
905: l_date_disp := fnd_date.date_to_displaydt (l_date);
906:
907: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
908: bil_bi_util_collection_pkg.writeLog(
909: p_log_level => fnd_log.LEVEL_PROCEDURE,
910: p_module => g_pkg || l_proc || ' end',
911: p_msg => 'End of Procedure '|| l_proc);
912: END IF;

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

919: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
920: fnd_message.set_token('ERRNO' ,SQLCODE);
921: fnd_message.set_token('REASON', SQLERRM);
922: fnd_message.set_token('ROUTINE', l_proc);
923: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
924: p_module => g_pkg || l_proc || ' proc_error',
925: p_msg => fnd_message.get,
926: p_force_log => TRUE);
927:

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

937: begin
938: l_proc := 'get_number_of_runs';
939: l_status := 'SUCCESS';
940:
941: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
942: bil_bi_util_collection_pkg.writeLog(
943: p_log_level => fnd_log.LEVEL_PROCEDURE,
944: p_module => g_pkg || l_proc || ' begin',
945: p_msg => 'Start of Procedure '|| l_proc);

Line 942: bil_bi_util_collection_pkg.writeLog(

938: l_proc := 'get_number_of_runs';
939: l_status := 'SUCCESS';
940:
941: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
942: bil_bi_util_collection_pkg.writeLog(
943: p_log_level => fnd_log.LEVEL_PROCEDURE,
944: p_module => g_pkg || l_proc || ' begin',
945: p_msg => 'Start of Procedure '|| l_proc);
946: END IF;

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

951: WHERE object_name = p_object_name
952: and status=l_status ;
953:
954:
955: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
956: bil_bi_util_collection_pkg.writeLog(
957: p_log_level => fnd_log.LEVEL_PROCEDURE,
958: p_module => g_pkg || l_proc || ' end',
959: p_msg => 'End of Procedure '|| l_proc);

Line 956: bil_bi_util_collection_pkg.writeLog(

952: and status=l_status ;
953:
954:
955: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
956: bil_bi_util_collection_pkg.writeLog(
957: p_log_level => fnd_log.LEVEL_PROCEDURE,
958: p_module => g_pkg || l_proc || ' end',
959: p_msg => 'End of Procedure '|| l_proc);
960: END IF;

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

967: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
968: fnd_message.set_token('ERRNO' ,SQLCODE);
969: fnd_message.set_token('REASON', SQLERRM);
970: fnd_message.set_token('ROUTINE', l_proc);
971: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
972: p_module => g_pkg || l_proc || ' proc_error',
973: p_msg => fnd_message.get,
974: p_force_log => TRUE);
975:

Line 1117: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

1113:
1114:
1115:
1116: IF (not l_valid_setup) THEN
1117: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1118: bil_bi_util_collection_pkg.writeLog
1119: (
1120: p_log_level => fnd_log.LEVEL_EVENT,
1121: p_module => g_pkg || l_proc ,

Line 1118: bil_bi_util_collection_pkg.writeLog

1114:
1115:
1116: IF (not l_valid_setup) THEN
1117: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1118: bil_bi_util_collection_pkg.writeLog
1119: (
1120: p_log_level => fnd_log.LEVEL_EVENT,
1121: p_module => g_pkg || l_proc ,
1122: p_msg => 'BIS_COLLECTION_UTILITIES.SETUP failed'

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

1125: RAISE G_BIS_SETUP_ERROR;
1126: END IF;
1127:
1128:
1129: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1130: bil_bi_util_collection_pkg.writeLog(
1131: p_log_level => fnd_log.LEVEL_PROCEDURE,
1132: p_module => g_pkg || l_proc || ' begin',
1133: p_msg => 'Start of Procedure '|| l_proc);

Line 1130: bil_bi_util_collection_pkg.writeLog(

1126: END IF;
1127:
1128:
1129: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1130: bil_bi_util_collection_pkg.writeLog(
1131: p_log_level => fnd_log.LEVEL_PROCEDURE,
1132: p_module => g_pkg || l_proc || ' begin',
1133: p_msg => 'Start of Procedure '|| l_proc);
1134: END IF;

Line 1174: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

1170: Report_Missing_Profile('ASN_FRCST_CREDIT_TYPE_ID');
1171: END IF;
1172:
1173: ELSE
1174: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1175: bil_bi_util_collection_pkg.writeLog
1176: (
1177: p_log_level => fnd_log.LEVEL_EVENT,
1178: p_module => g_pkg || l_proc ,

Line 1175: bil_bi_util_collection_pkg.writeLog

1171: END IF;
1172:
1173: ELSE
1174: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1175: bil_bi_util_collection_pkg.writeLog
1176: (
1177: p_log_level => fnd_log.LEVEL_EVENT,
1178: p_module => g_pkg || l_proc ,
1179: p_msg => 'Missing profiles' );

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

1190: --g_prim_rate_type := bis_common_parameters.get_rate_type;
1191: g_prim_currency := l_val(6);
1192: g_prim_rate_type := l_val(7);
1193:
1194: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1195: bil_bi_util_collection_pkg.writeLog
1196: (
1197: p_log_level => fnd_log.LEVEL_STATEMENT,
1198: p_module => g_pkg || l_proc ,

Line 1195: bil_bi_util_collection_pkg.writeLog

1191: g_prim_currency := l_val(6);
1192: g_prim_rate_type := l_val(7);
1193:
1194: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1195: bil_bi_util_collection_pkg.writeLog
1196: (
1197: p_log_level => fnd_log.LEVEL_STATEMENT,
1198: p_module => g_pkg || l_proc ,
1199: p_msg => 'prim curr : rate type = '||g_prim_currency||' : '||g_prim_rate_type

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

1211:
1212:
1213: -- sec curr not set up at all
1214: IF (l_val(8) IS NULL) THEN
1215: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1216: bil_bi_util_collection_pkg.writeLog
1217: (p_log_level => fnd_log.LEVEL_STATEMENT,p_module => g_pkg || l_proc ,
1218: p_msg => ' Secondary curency not set up '
1219: );

Line 1216: bil_bi_util_collection_pkg.writeLog

1212:
1213: -- sec curr not set up at all
1214: IF (l_val(8) IS NULL) THEN
1215: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1216: bil_bi_util_collection_pkg.writeLog
1217: (p_log_level => fnd_log.LEVEL_STATEMENT,p_module => g_pkg || l_proc ,
1218: p_msg => ' Secondary curency not set up '
1219: );
1220: END IF;

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

1222:
1223: -- sec curr set up but rate type not set up : ERROR
1224: IF (l_val(8) IS NOT NULL AND l_val(9) IS NULL ) THEN
1225: Report_Missing_Profile(l_list(9));
1226: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1227: bil_bi_util_collection_pkg.writeLog
1228: (p_log_level => fnd_log.LEVEL_STATEMENT,p_module => g_pkg || l_proc ,
1229: p_msg => ' Secondary curency set up but rate type not set up: ERROR '
1230: );

Line 1227: bil_bi_util_collection_pkg.writeLog

1223: -- sec curr set up but rate type not set up : ERROR
1224: IF (l_val(8) IS NOT NULL AND l_val(9) IS NULL ) THEN
1225: Report_Missing_Profile(l_list(9));
1226: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1227: bil_bi_util_collection_pkg.writeLog
1228: (p_log_level => fnd_log.LEVEL_STATEMENT,p_module => g_pkg || l_proc ,
1229: p_msg => ' Secondary curency set up but rate type not set up: ERROR '
1230: );
1231: END IF;

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

1236:
1237: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
1238: g_sec_rate_type := bis_common_parameters.get_secondary_rate_type;
1239:
1240: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1241: bil_bi_util_collection_pkg.writeLog
1242: (
1243: p_log_level => fnd_log.LEVEL_STATEMENT,
1244: p_module => g_pkg || l_proc ,

Line 1241: bil_bi_util_collection_pkg.writeLog

1237: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
1238: g_sec_rate_type := bis_common_parameters.get_secondary_rate_type;
1239:
1240: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1241: bil_bi_util_collection_pkg.writeLog
1242: (
1243: p_log_level => fnd_log.LEVEL_STATEMENT,
1244: p_module => g_pkg || l_proc ,
1245: p_msg => 'sec curr : rate type = '||g_sec_currency||' : '||g_sec_rate_type

Line 1260: bil_bi_util_collection_pkg.writeLog

1256: ELSIF (TO_DATE(p_start_date, 'YYYY/MM/DD HH24:MI:SS') > l_sysdate) THEN
1257: fnd_message.set_name('BIL','BIL_BI_DATE_PARAM_RESET');
1258: fnd_message.set_token('RESET_DATE',
1259: TO_CHAR(SYSDATE, 'YYYY/MM/DD HH24:MI:SS'));
1260: bil_bi_util_collection_pkg.writeLog
1261: (
1262: p_log_level => fnd_log.LEVEL_ERROR,
1263: p_module => g_pkg || l_proc ,
1264: p_msg => fnd_message.get,

Line 1303: bil_bi_util_collection_pkg.writeLog

1299: -- log table has not been populated.
1300: IF (g_setup_error_flag = FALSE) THEN
1301: g_setup_error_flag := TRUE;
1302: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
1303: bil_bi_util_collection_pkg.writeLog
1304: (
1305: p_log_level => fnd_log.LEVEL_ERROR,
1306: p_module => g_pkg || l_proc || ' proc_error',
1307: p_msg => fnd_message.get,

Line 1312: bil_bi_util_collection_pkg.writeLog

1308: p_force_log => TRUE
1309: );
1310: END IF;
1311: fnd_message.set_name('BIL','BIL_BI_OPTY_LOG_MISSING');
1312: bil_bi_util_collection_pkg.writeLog
1313: (
1314: p_log_level => fnd_log.LEVEL_ERROR,
1315: p_module => g_pkg || l_proc || ' proc_error',
1316: p_msg => fnd_message.get,

Line 1322: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

1318: );
1319: END IF;
1320:
1321: IF (g_setup_error_flag) THEN
1322: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1323: bil_bi_util_collection_pkg.writeLog
1324: (
1325: p_log_level => fnd_log.LEVEL_EVENT,
1326: p_module => g_pkg || l_proc ,

Line 1323: bil_bi_util_collection_pkg.writeLog

1319: END IF;
1320:
1321: IF (g_setup_error_flag) THEN
1322: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1323: bil_bi_util_collection_pkg.writeLog
1324: (
1325: p_log_level => fnd_log.LEVEL_EVENT,
1326: p_module => g_pkg || l_proc ,
1327: p_msg => 'Setup Validition failed'

Line 1340: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

1336:
1337: l_first_fact_run := fnd_date.displaydt_to_date(get_first_success_period('BIL_BI_OPDTL_F'));
1338:
1339:
1340: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1341: bil_bi_util_collection_pkg.writeLog
1342: (
1343: p_log_level => fnd_log.LEVEL_EVENT,
1344: p_module => g_pkg || l_proc ,

Line 1341: bil_bi_util_collection_pkg.writeLog

1337: l_first_fact_run := fnd_date.displaydt_to_date(get_first_success_period('BIL_BI_OPDTL_F'));
1338:
1339:
1340: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1341: bil_bi_util_collection_pkg.writeLog
1342: (
1343: p_log_level => fnd_log.LEVEL_EVENT,
1344: p_module => g_pkg || l_proc ,
1345: p_msg => 'p_truncate is ' || p_truncate

Line 1352: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

1348:
1349:
1350:
1351: IF (p_truncate = 'Y') THEN
1352: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1353: bil_bi_util_collection_pkg.writeLog
1354: (
1355: p_log_level => fnd_log.LEVEL_EVENT,
1356: p_module => g_pkg || l_proc ,

Line 1353: bil_bi_util_collection_pkg.writeLog

1349:
1350:
1351: IF (p_truncate = 'Y') THEN
1352: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1353: bil_bi_util_collection_pkg.writeLog
1354: (
1355: p_log_level => fnd_log.LEVEL_EVENT,
1356: p_module => g_pkg || l_proc ,
1357: p_msg => 'Truncating'

Line 1362: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');

1358: );
1359: END IF;
1360: BIS_COLLECTION_UTILITIES.deleteLogForObject ('BIL_BI_PIPELINE_F');
1361: BIS_COLLECTION_UTILITIES.deleteLogForObject ('BIL_BI_PIPEC_F');
1362: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');
1363: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_F');
1364: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPEC_F');
1365: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');
1366: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_TIME');

Line 1363: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_F');

1359: END IF;
1360: BIS_COLLECTION_UTILITIES.deleteLogForObject ('BIL_BI_PIPELINE_F');
1361: BIS_COLLECTION_UTILITIES.deleteLogForObject ('BIL_BI_PIPEC_F');
1362: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');
1363: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_F');
1364: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPEC_F');
1365: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');
1366: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_TIME');
1367: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_DENLOG_TMP');

Line 1364: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPEC_F');

1360: BIS_COLLECTION_UTILITIES.deleteLogForObject ('BIL_BI_PIPELINE_F');
1361: BIS_COLLECTION_UTILITIES.deleteLogForObject ('BIL_BI_PIPEC_F');
1362: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');
1363: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_F');
1364: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPEC_F');
1365: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');
1366: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_TIME');
1367: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_DENLOG_TMP');
1368: ELSE

Line 1365: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');

1361: BIS_COLLECTION_UTILITIES.deleteLogForObject ('BIL_BI_PIPEC_F');
1362: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');
1363: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_F');
1364: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPEC_F');
1365: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');
1366: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_TIME');
1367: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_DENLOG_TMP');
1368: ELSE
1369: ----------------------------------------------------

Line 1366: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_TIME');

1362: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');
1363: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_F');
1364: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPEC_F');
1365: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');
1366: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_TIME');
1367: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_DENLOG_TMP');
1368: ELSE
1369: ----------------------------------------------------
1370: -- CHECK FOR RESUME

Line 1367: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_DENLOG_TMP');

1363: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_F');
1364: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPEC_F');
1365: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');
1366: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_TIME');
1367: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_DENLOG_TMP');
1368: ELSE
1369: ----------------------------------------------------
1370: -- CHECK FOR RESUME
1371: ----------------------------------------------------

Line 1375: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

1371: ----------------------------------------------------
1372: SELECT sum(cnt) INTO l_count FROM (select count(1) cnt from bil_bi_pipeline_stg
1373: union all select count(1) cnt from BIL_BI_DENLOG_STG)
1374: ;
1375: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1376: bil_bi_util_collection_pkg.writeLog
1377: (
1378: p_log_level => fnd_log.LEVEL_EVENT,
1379: p_module => g_pkg || l_proc ,

Line 1376: bil_bi_util_collection_pkg.writeLog

1372: SELECT sum(cnt) INTO l_count FROM (select count(1) cnt from bil_bi_pipeline_stg
1373: union all select count(1) cnt from BIL_BI_DENLOG_STG)
1374: ;
1375: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1376: bil_bi_util_collection_pkg.writeLog
1377: (
1378: p_log_level => fnd_log.LEVEL_EVENT,
1379: p_module => g_pkg || l_proc ,
1380: p_msg => 'No. of Rows in Staging are :'||l_count

Line 1396: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_TIME');

1392: END IF;
1393:
1394: Populate_Currency_Rate(l_mode);
1395:
1396: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_TIME');
1397:
1398: populate_hist_dates(l_failure_from+1, l_failure_to);
1399:
1400: get_period_ids(l_failure_from, x_day=>l_day,

Line 1408: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');

1404:
1405:
1406: -- rebuild baseline since stage table can be in any state
1407:
1408: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');
1409:
1410: --if gap is lessthan 3 days, we don't need to rebuild baseline
1411: -- since we will use 7.0.1 approach to insert into staging
1412:

Line 1420: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

1416:
1417: Build_Baseline(l_failure_from);
1418:
1419:
1420: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1421: bil_bi_util_collection_pkg.writeLog
1422: (
1423: p_log_level => fnd_log.LEVEL_EVENT,
1424: p_module => g_pkg || l_proc ,

Line 1421: bil_bi_util_collection_pkg.writeLog

1417: Build_Baseline(l_failure_from);
1418:
1419:
1420: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1421: bil_bi_util_collection_pkg.writeLog
1422: (
1423: p_log_level => fnd_log.LEVEL_EVENT,
1424: p_module => g_pkg || l_proc ,
1425: p_msg =>'Gap Is' || l_failure_to - l_failure_from

Line 1439: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

1435: x_valid_date => l_valid_date,
1436: x_valid_prod => l_valid_prod,
1437: x_return_warn => l_return_warn_resume);
1438: IF ((l_valid_curr = 'Y') AND (l_valid_date = 'Y')) THEN
1439: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1440: bil_bi_util_collection_pkg.writeLog
1441: (
1442: p_log_level => fnd_log.LEVEL_EVENT,
1443: p_module => g_pkg || l_proc ,

Line 1440: bil_bi_util_collection_pkg.writeLog

1436: x_valid_prod => l_valid_prod,
1437: x_return_warn => l_return_warn_resume);
1438: IF ((l_valid_curr = 'Y') AND (l_valid_date = 'Y')) THEN
1439: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1440: bil_bi_util_collection_pkg.writeLog
1441: (
1442: p_log_level => fnd_log.LEVEL_EVENT,
1443: p_module => g_pkg || l_proc ,
1444: p_msg =>'Summary Error Check Successful!'

Line 1448: bil_bi_util_collection_pkg.analyze_table('BIL_BI_PIPELINE_STG',TRUE, 10, 'GLOBAL');

1444: p_msg =>'Summary Error Check Successful!'
1445: );
1446: END IF;
1447:
1448: bil_bi_util_collection_pkg.analyze_table('BIL_BI_PIPELINE_STG',TRUE, 10, 'GLOBAL');
1449: bil_bi_util_collection_pkg.analyze_table('BIL_BI_DENLOG_STG',TRUE, 10, 'GLOBAL');
1450: bil_bi_util_collection_pkg.analyze_table('BIL_BI_OPDTL_DENLOG_TMP',TRUE, 10, 'GLOBAL');
1451:
1452:

Line 1449: bil_bi_util_collection_pkg.analyze_table('BIL_BI_DENLOG_STG',TRUE, 10, 'GLOBAL');

1445: );
1446: END IF;
1447:
1448: bil_bi_util_collection_pkg.analyze_table('BIL_BI_PIPELINE_STG',TRUE, 10, 'GLOBAL');
1449: bil_bi_util_collection_pkg.analyze_table('BIL_BI_DENLOG_STG',TRUE, 10, 'GLOBAL');
1450: bil_bi_util_collection_pkg.analyze_table('BIL_BI_OPDTL_DENLOG_TMP',TRUE, 10, 'GLOBAL');
1451:
1452:
1453:

Line 1450: bil_bi_util_collection_pkg.analyze_table('BIL_BI_OPDTL_DENLOG_TMP',TRUE, 10, 'GLOBAL');

1446: END IF;
1447:
1448: bil_bi_util_collection_pkg.analyze_table('BIL_BI_PIPELINE_STG',TRUE, 10, 'GLOBAL');
1449: bil_bi_util_collection_pkg.analyze_table('BIL_BI_DENLOG_STG',TRUE, 10, 'GLOBAL');
1450: bil_bi_util_collection_pkg.analyze_table('BIL_BI_OPDTL_DENLOG_TMP',TRUE, 10, 'GLOBAL');
1451:
1452:
1453:
1454: -- this will insert the first day record

Line 1499: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

1495:
1496:
1497:
1498: IF ((l_valid_curr = 'Y') AND (l_valid_date = 'Y')) THEN
1499: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1500: bil_bi_util_collection_pkg.writeLog
1501: (
1502: p_log_level => fnd_log.LEVEL_EVENT,
1503: p_module => g_pkg || l_proc ,

Line 1500: bil_bi_util_collection_pkg.writeLog

1496:
1497:
1498: IF ((l_valid_curr = 'Y') AND (l_valid_date = 'Y')) THEN
1499: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1500: bil_bi_util_collection_pkg.writeLog
1501: (
1502: p_log_level => fnd_log.LEVEL_EVENT,
1503: p_module => g_pkg || l_proc ,
1504: p_msg =>'Summary Error Check Successful!'

Line 1508: bil_bi_util_collection_pkg.analyze_table('BIL_BI_PIPELINE_STG',TRUE, 10, 'GLOBAL');

1504: p_msg =>'Summary Error Check Successful!'
1505: );
1506: END IF;
1507:
1508: bil_bi_util_collection_pkg.analyze_table('BIL_BI_PIPELINE_STG',TRUE, 10, 'GLOBAL');
1509:
1510:
1511: --Insert the first day of the gap, since gap_fill will only insert from 2nd day on
1512: Ins_Into_CurrSum_SmGap(l_failure_from, l_week, l_period, l_qtr,

Line 1529: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');

1525: Gap_Fill(l_failure_from+1, l_failure_to, l_curr_coll_start, l_mode, l_small_gap);
1526:
1527:
1528: l_resume_flag := 'Y';
1529: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');
1530: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');
1531: --execute immediate 'Truncate table BIL_BI_DENLOG_STG';
1532: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_DENLOG_TMP');
1533:

Line 1530: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');

1526:
1527:
1528: l_resume_flag := 'Y';
1529: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');
1530: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');
1531: --execute immediate 'Truncate table BIL_BI_DENLOG_STG';
1532: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_DENLOG_TMP');
1533:
1534: -- Added by TR (to populate the correct period_to and period_from dates in Attribute

Line 1532: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_DENLOG_TMP');

1528: l_resume_flag := 'Y';
1529: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');
1530: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');
1531: --execute immediate 'Truncate table BIL_BI_DENLOG_STG';
1532: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_DENLOG_TMP');
1533:
1534: -- Added by TR (to populate the correct period_to and period_from dates in Attribute
1535: -- columns of bis_refresh_log)
1536: SELECT TO_CHAR(MIN(snap_date),'DD-MM-YYYY')

Line 1694: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN

1690: --------------------------------------------------------------
1691:
1692: IF (l_last_fact_run = G_global_start_date) THEN
1693:
1694: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN
1695: -- This error message is an unusual case of standalone run of CP in incremental mode
1696: -- hence it doesn't use a translated msg string
1697: bil_bi_util_collection_pkg.writeLog
1698: (

Line 1697: bil_bi_util_collection_pkg.writeLog

1693:
1694: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN
1695: -- This error message is an unusual case of standalone run of CP in incremental mode
1696: -- hence it doesn't use a translated msg string
1697: bil_bi_util_collection_pkg.writeLog
1698: (
1699: p_log_level =>fnd_log.LEVEL_ERROR,
1700: p_module => g_pkg || l_proc ,
1701: p_msg => 'Load Sales Opportunity Base Summary program must be run before this program.'

Line 1720: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

1716: --------------------------------------------------------------
1717: -- DETECT GAPS AND FILL THEM. (Treat initial as a big gap)
1718: --------------------------------------------------------------
1719:
1720: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1721: bil_bi_util_collection_pkg.writeLog
1722: (
1723: p_log_level =>fnd_log.LEVEL_ERROR,
1724: p_module => g_pkg || l_proc ,

Line 1721: bil_bi_util_collection_pkg.writeLog

1717: -- DETECT GAPS AND FILL THEM. (Treat initial as a big gap)
1718: --------------------------------------------------------------
1719:
1720: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1721: bil_bi_util_collection_pkg.writeLog
1722: (
1723: p_log_level =>fnd_log.LEVEL_ERROR,
1724: p_module => g_pkg || l_proc ,
1725: p_msg => 'l_date is ' || l_date || ' l_last_run is ' || l_last_run || ' g_global is' || g_global_start_date

Line 1756: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

1752: END;
1753:
1754: l_start_date := NVL(TRUNC(l_min_lead_date), l_start_date);
1755:
1756: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1757: bil_bi_util_collection_pkg.writeLog
1758: (
1759: p_log_level =>fnd_log.LEVEL_ERROR,
1760: p_module => g_pkg || l_proc ,

Line 1757: bil_bi_util_collection_pkg.writeLog

1753:
1754: l_start_date := NVL(TRUNC(l_min_lead_date), l_start_date);
1755:
1756: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1757: bil_bi_util_collection_pkg.writeLog
1758: (
1759: p_log_level =>fnd_log.LEVEL_ERROR,
1760: p_module => g_pkg || l_proc ,
1761: p_msg => 'l_min_lead_date is ' || l_min_lead_date || ' l_start_date is ' || l_start_date || ' g_global is' || g_global_start_date

Line 1773: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_F');

1769:
1770: -- truncate table here since there is a possibibility the build base line was
1771: -- successful on the 1st run and the rest failed.
1772:
1773: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_F');
1774: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPEC_F');
1775:
1776:
1777: -- setup baseline on the global start date

Line 1774: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPEC_F');

1770: -- truncate table here since there is a possibibility the build base line was
1771: -- successful on the 1st run and the rest failed.
1772:
1773: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_F');
1774: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPEC_F');
1775:
1776:
1777: -- setup baseline on the global start date
1778: Build_Baseline(l_start_date);

Line 1780: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_TIME');

1776:
1777: -- setup baseline on the global start date
1778: Build_Baseline(l_start_date);
1779:
1780: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_TIME');
1781:
1782: l_small_gap := FALSE;
1783:
1784: populate_hist_dates(l_start_date+1, l_date);

Line 1791: bil_bi_util_collection_pkg.analyze_table('BIL_BI_PIPELINE_STG',TRUE, 10, 'GLOBAL');

1787: -- build up the denlog_tmp table for the gap range
1788: -- l_date instead of l_date -1 is because denlog will check for time < l_date
1789: Build_Denlog(l_start_date+1, l_date, l_curr_coll_start, 'INIT');
1790:
1791: bil_bi_util_collection_pkg.analyze_table('BIL_BI_PIPELINE_STG',TRUE, 10, 'GLOBAL');
1792: bil_bi_util_collection_pkg.analyze_table('BIL_BI_DENLOG_STG',TRUE, 10, 'GLOBAL');
1793: bil_bi_util_collection_pkg.analyze_table('BIL_BI_OPDTL_DENLOG_TMP',TRUE, 10, 'GLOBAL');
1794:
1795: Populate_Currency_Rate('INIT');

Line 1792: bil_bi_util_collection_pkg.analyze_table('BIL_BI_DENLOG_STG',TRUE, 10, 'GLOBAL');

1788: -- l_date instead of l_date -1 is because denlog will check for time < l_date
1789: Build_Denlog(l_start_date+1, l_date, l_curr_coll_start, 'INIT');
1790:
1791: bil_bi_util_collection_pkg.analyze_table('BIL_BI_PIPELINE_STG',TRUE, 10, 'GLOBAL');
1792: bil_bi_util_collection_pkg.analyze_table('BIL_BI_DENLOG_STG',TRUE, 10, 'GLOBAL');
1793: bil_bi_util_collection_pkg.analyze_table('BIL_BI_OPDTL_DENLOG_TMP',TRUE, 10, 'GLOBAL');
1794:
1795: Populate_Currency_Rate('INIT');
1796:

Line 1793: bil_bi_util_collection_pkg.analyze_table('BIL_BI_OPDTL_DENLOG_TMP',TRUE, 10, 'GLOBAL');

1789: Build_Denlog(l_start_date+1, l_date, l_curr_coll_start, 'INIT');
1790:
1791: bil_bi_util_collection_pkg.analyze_table('BIL_BI_PIPELINE_STG',TRUE, 10, 'GLOBAL');
1792: bil_bi_util_collection_pkg.analyze_table('BIL_BI_DENLOG_STG',TRUE, 10, 'GLOBAL');
1793: bil_bi_util_collection_pkg.analyze_table('BIL_BI_OPDTL_DENLOG_TMP',TRUE, 10, 'GLOBAL');
1794:
1795: Populate_Currency_Rate('INIT');
1796:
1797: l_failure_from := g_global_start_date;

Line 1812: bil_bi_util_collection_pkg.analyze_table('BIL_BI_PIPELINE_F',TRUE, 10, 'GLOBAL');

1808: Insert_Into_Summary('INIT');
1809:
1810: -- incrementally build up the rest of the days
1811: Gap_Fill(l_start_date+1, l_date-1, l_curr_coll_start, 'INIT', l_small_gap) ;
1812: bil_bi_util_collection_pkg.analyze_table('BIL_BI_PIPELINE_F',TRUE, 10, 'GLOBAL');
1813: Else
1814: RAISE G_INVALID_DIM;
1815: END IF; -- errcheck ok
1816:

Line 1820: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_TIME');

1816:
1817:
1818: ELSE
1819:
1820: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_TIME');
1821:
1822: populate_hist_dates(l_last_run+2, l_date);
1823:
1824:

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

1834: IF l_min_curr_date < l_curr_coll_start THEN
1835: DELETE_FROM_CURR(l_curr_coll_start);
1836: END IF;
1837:
1838: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1839: bil_bi_util_collection_pkg.writeLog
1840: (
1841: p_log_level => fnd_log.LEVEL_EVENT,
1842: p_module => g_pkg || l_proc ,

Line 1839: bil_bi_util_collection_pkg.writeLog

1835: DELETE_FROM_CURR(l_curr_coll_start);
1836: END IF;
1837:
1838: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1839: bil_bi_util_collection_pkg.writeLog
1840: (
1841: p_log_level => fnd_log.LEVEL_EVENT,
1842: p_module => g_pkg || l_proc ,
1843: p_msg => 'Incr gap fill: l_min_curr_date is :' ||l_min_curr_date || ' l_curr_coll_start is : ' ||l_curr_coll_start);

Line 1848: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

1844:
1845: END IF;
1846:
1847:
1848: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1849: bil_bi_util_collection_pkg.writeLog
1850: (
1851: p_log_level => fnd_log.LEVEL_EVENT,
1852: p_module => g_pkg || l_proc ,

Line 1849: bil_bi_util_collection_pkg.writeLog

1845: END IF;
1846:
1847:
1848: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1849: bil_bi_util_collection_pkg.writeLog
1850: (
1851: p_log_level => fnd_log.LEVEL_EVENT,
1852: p_module => g_pkg || l_proc ,
1853: p_msg => 'snapshot gap found: gcredit_typeid is ' || g_credit_type_id ||

Line 1863: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

1859:
1860: DELETE FROM bil_bi_pipeline_f WHERE snap_date between l_last_run+1 and l_date-1;
1861: commit;
1862:
1863: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1864: bil_bi_util_collection_pkg.writeLog
1865: (
1866: p_log_level => fnd_log.LEVEL_EVENT,
1867: p_module => g_pkg || l_proc ,

Line 1864: bil_bi_util_collection_pkg.writeLog

1860: DELETE FROM bil_bi_pipeline_f WHERE snap_date between l_last_run+1 and l_date-1;
1861: commit;
1862:
1863: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1864: bil_bi_util_collection_pkg.writeLog
1865: (
1866: p_log_level => fnd_log.LEVEL_EVENT,
1867: p_module => g_pkg || l_proc ,
1868: p_msg => 'Deleted '|| sql%rowcount ||' from BIL_BI_PIPELINE_F table for gap between' || (l_last_run+1) ||

Line 1875: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

1871:
1872: DELETE FROM bil_bi_pipec_f WHERE snap_date between l_last_run+1 and l_date-1;
1873: commit;
1874:
1875: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1876: bil_bi_util_collection_pkg.writeLog
1877: (
1878: p_log_level => fnd_log.LEVEL_EVENT,
1879: p_module => g_pkg || l_proc ,

Line 1876: bil_bi_util_collection_pkg.writeLog

1872: DELETE FROM bil_bi_pipec_f WHERE snap_date between l_last_run+1 and l_date-1;
1873: commit;
1874:
1875: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1876: bil_bi_util_collection_pkg.writeLog
1877: (
1878: p_log_level => fnd_log.LEVEL_EVENT,
1879: p_module => g_pkg || l_proc ,
1880: p_msg => 'Deleted '|| sql%rowcount ||' from BIL_BI_PIPEC_F table for gap between' || (l_last_run+1) ||

Line 1922: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

1918: END;
1919:
1920:
1921:
1922: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1923: bil_bi_util_collection_pkg.writeLog
1924: (
1925: p_log_level =>fnd_log.LEVEL_ERROR,
1926: p_module => g_pkg || l_proc ,

Line 1923: bil_bi_util_collection_pkg.writeLog

1919:
1920:
1921:
1922: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1923: bil_bi_util_collection_pkg.writeLog
1924: (
1925: p_log_level =>fnd_log.LEVEL_ERROR,
1926: p_module => g_pkg || l_proc ,
1927: p_msg => 'l_min_lead_date is ' || l_min_lead_date || ' l_last_run+1 is ' || l_start_date || ' g_global is' || g_global_start_date

Line 1931: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

1927: p_msg => 'l_min_lead_date is ' || l_min_lead_date || ' l_last_run+1 is ' || l_start_date || ' g_global is' || g_global_start_date
1928: );
1929: END IF;
1930:
1931: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1932: bil_bi_util_collection_pkg.writeLog
1933: (
1934: p_log_level => fnd_log.LEVEL_EVENT,
1935: p_module => g_pkg || l_proc ,

Line 1932: bil_bi_util_collection_pkg.writeLog

1928: );
1929: END IF;
1930:
1931: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1932: bil_bi_util_collection_pkg.writeLog
1933: (
1934: p_log_level => fnd_log.LEVEL_EVENT,
1935: p_module => g_pkg || l_proc ,
1936: p_msg => 'Inside gap more than 3 days');

Line 1945: bil_bi_util_collection_pkg.analyze_table('BIL_BI_PIPELINE_STG',TRUE, 10, 'GLOBAL');

1941:
1942:
1943: Build_Denlog(l_last_run+2, l_date, l_curr_coll_start, 'INCR');
1944:
1945: bil_bi_util_collection_pkg.analyze_table('BIL_BI_PIPELINE_STG',TRUE, 10, 'GLOBAL');
1946: bil_bi_util_collection_pkg.analyze_table('BIL_BI_DENLOG_STG',TRUE, 10, 'GLOBAL');
1947: bil_bi_util_collection_pkg.analyze_table('BIL_BI_OPDTL_DENLOG_TMP',TRUE, 10, 'GLOBAL');
1948:
1949:

Line 1946: bil_bi_util_collection_pkg.analyze_table('BIL_BI_DENLOG_STG',TRUE, 10, 'GLOBAL');

1942:
1943: Build_Denlog(l_last_run+2, l_date, l_curr_coll_start, 'INCR');
1944:
1945: bil_bi_util_collection_pkg.analyze_table('BIL_BI_PIPELINE_STG',TRUE, 10, 'GLOBAL');
1946: bil_bi_util_collection_pkg.analyze_table('BIL_BI_DENLOG_STG',TRUE, 10, 'GLOBAL');
1947: bil_bi_util_collection_pkg.analyze_table('BIL_BI_OPDTL_DENLOG_TMP',TRUE, 10, 'GLOBAL');
1948:
1949:
1950:

Line 1947: bil_bi_util_collection_pkg.analyze_table('BIL_BI_OPDTL_DENLOG_TMP',TRUE, 10, 'GLOBAL');

1943: Build_Denlog(l_last_run+2, l_date, l_curr_coll_start, 'INCR');
1944:
1945: bil_bi_util_collection_pkg.analyze_table('BIL_BI_PIPELINE_STG',TRUE, 10, 'GLOBAL');
1946: bil_bi_util_collection_pkg.analyze_table('BIL_BI_DENLOG_STG',TRUE, 10, 'GLOBAL');
1947: bil_bi_util_collection_pkg.analyze_table('BIL_BI_OPDTL_DENLOG_TMP',TRUE, 10, 'GLOBAL');
1948:
1949:
1950:
1951: Populate_Currency_Rate('INCR');

Line 1991: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

1987:
1988:
1989: l_small_gap := TRUE;
1990:
1991: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1992: bil_bi_util_collection_pkg.writeLog
1993: (
1994: p_log_level => fnd_log.LEVEL_EVENT,
1995: p_module => g_pkg || l_proc ,

Line 1992: bil_bi_util_collection_pkg.writeLog

1988:
1989: l_small_gap := TRUE;
1990:
1991: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1992: bil_bi_util_collection_pkg.writeLog
1993: (
1994: p_log_level => fnd_log.LEVEL_EVENT,
1995: p_module => g_pkg || l_proc ,
1996: p_msg => 'Inside gap less than 3 days');

Line 1999: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

1995: p_module => g_pkg || l_proc ,
1996: p_msg => 'Inside gap less than 3 days');
1997: END IF;
1998:
1999: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
2000: bil_bi_util_collection_pkg.writeLog
2001: (
2002: p_log_level => fnd_log.LEVEL_EVENT,
2003: p_module => g_pkg || l_proc ,

Line 2000: bil_bi_util_collection_pkg.writeLog

1996: p_msg => 'Inside gap less than 3 days');
1997: END IF;
1998:
1999: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
2000: bil_bi_util_collection_pkg.writeLog
2001: (
2002: p_log_level => fnd_log.LEVEL_EVENT,
2003: p_module => g_pkg || l_proc ,
2004: p_msg => 'Dates: l_last_run+1' || (l_last_run+1) ||

Line 2195: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');

2191:
2192:
2193: -- clean up
2194:
2195: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');
2196: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');
2197: --execute immediate 'Truncate table BIL_BI_DENLOG_STG';
2198: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_DENLOG_TMP');
2199: -- regular snapshot

Line 2196: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');

2192:
2193: -- clean up
2194:
2195: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');
2196: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');
2197: --execute immediate 'Truncate table BIL_BI_DENLOG_STG';
2198: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_DENLOG_TMP');
2199: -- regular snapshot
2200:

Line 2198: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_DENLOG_TMP');

2194:
2195: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');
2196: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');
2197: --execute immediate 'Truncate table BIL_BI_DENLOG_STG';
2198: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_DENLOG_TMP');
2199: -- regular snapshot
2200:
2201: -- delete the existing snapshot, since could be multiple runs anyway in the same day
2202:

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

2213: IF l_min_curr_date < l_curr_coll_start THEN
2214: DELETE_FROM_CURR(l_curr_coll_start);
2215: END IF;
2216:
2217: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
2218: bil_bi_util_collection_pkg.writeLog
2219: (
2220: p_log_level => fnd_log.LEVEL_EVENT,
2221: p_module => g_pkg || l_proc ,

Line 2218: bil_bi_util_collection_pkg.writeLog

2214: DELETE_FROM_CURR(l_curr_coll_start);
2215: END IF;
2216:
2217: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
2218: bil_bi_util_collection_pkg.writeLog
2219: (
2220: p_log_level => fnd_log.LEVEL_EVENT,
2221: p_module => g_pkg || l_proc ,
2222: p_msg => 'l_min_curr_date is :' ||l_min_curr_date || ' l_curr_coll_start is : ' ||l_curr_coll_start);

Line 2228: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

2224: END IF;
2225:
2226:
2227:
2228: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
2229: bil_bi_util_collection_pkg.writeLog
2230: (
2231: p_log_level => fnd_log.LEVEL_EVENT,
2232: p_module => g_pkg || l_proc ,

Line 2229: bil_bi_util_collection_pkg.writeLog

2225:
2226:
2227:
2228: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
2229: bil_bi_util_collection_pkg.writeLog
2230: (
2231: p_log_level => fnd_log.LEVEL_EVENT,
2232: p_module => g_pkg || l_proc ,
2233: p_msg => 'Deleted '|| sql%rowcount ||' rows from BIL_BI_PIPEC_F for '||l_date

Line 2704: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

2700:
2701:
2702:
2703: g_row_num:= sql%rowcount;
2704: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
2705: bil_bi_util_collection_pkg.writeLog
2706: (
2707: p_log_level => fnd_log.LEVEL_EVENT,
2708: p_module => g_pkg || l_proc ,

Line 2705: bil_bi_util_collection_pkg.writeLog

2701:
2702:
2703: g_row_num:= sql%rowcount;
2704: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
2705: bil_bi_util_collection_pkg.writeLog
2706: (
2707: p_log_level => fnd_log.LEVEL_EVENT,
2708: p_module => g_pkg || l_proc ,
2709: p_msg => 'Inserted '|| g_row_num ||' into BIL_BI_PIPEC_F table from BIL_BI_OPDTL_F for date'

Line 2785: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

2781: /*
2782: A generic line in the log file that requests the user to see the o/p file for
2783: further info.
2784: */
2785: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
2786: bil_bi_util_collection_pkg.writeLog
2787: (
2788: p_log_level => fnd_log.LEVEL_EVENT,
2789: p_module => g_pkg || l_proc,

Line 2786: bil_bi_util_collection_pkg.writeLog

2782: A generic line in the log file that requests the user to see the o/p file for
2783: further info.
2784: */
2785: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
2786: bil_bi_util_collection_pkg.writeLog
2787: (
2788: p_log_level => fnd_log.LEVEL_EVENT,
2789: p_module => g_pkg || l_proc,
2790: p_msg =>

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

2791: ' If there have been errors, Please refer to the Concurrent program output file for more information '
2792: );
2793: END IF;
2794:
2795: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2796: bil_bi_util_collection_pkg.writeLog(
2797: p_log_level => fnd_log.LEVEL_PROCEDURE,
2798: p_module => g_pkg || l_proc || ' end',
2799: p_msg => 'End of Procedure '|| l_proc);

Line 2796: bil_bi_util_collection_pkg.writeLog(

2792: );
2793: END IF;
2794:
2795: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2796: bil_bi_util_collection_pkg.writeLog(
2797: p_log_level => fnd_log.LEVEL_PROCEDURE,
2798: p_module => g_pkg || l_proc || ' end',
2799: p_msg => 'End of Procedure '|| l_proc);
2800: END IF;

Line 2833: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');

2829: retcode := -1;
2830: WHEN OTHERS Then
2831:
2832:
2833: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');
2834: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');
2835: --execute immediate 'Truncate table BIL_BI_DENLOG_STG';
2836: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_DENLOG_TMP');
2837:

Line 2834: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');

2830: WHEN OTHERS Then
2831:
2832:
2833: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');
2834: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');
2835: --execute immediate 'Truncate table BIL_BI_DENLOG_STG';
2836: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_DENLOG_TMP');
2837:
2838: commit;

Line 2836: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_DENLOG_TMP');

2832:
2833: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_PIPELINE_STG');
2834: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_DENLOG_STG');
2835: --execute immediate 'Truncate table BIL_BI_DENLOG_STG';
2836: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_DENLOG_TMP');
2837:
2838: commit;
2839: BIS_COLLECTION_UTILITIES.wrapup(FALSE,
2840: g_row_num,

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

2846: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2847: fnd_message.set_token('ERRNO' ,SQLCODE);
2848: fnd_message.set_token('REASON' ,SQLERRM);
2849: fnd_message.set_token('ROUTINE' , l_proc);
2850: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2851: p_module => g_pkg || l_proc || ' proc_error',
2852: p_msg => fnd_message.get,
2853: p_force_log => TRUE);
2854: retcode := -1;

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

2859: l_proc VARCHAR2(100);
2860: BEGIN
2861: l_proc := 'Populate_Currency_Rate';
2862:
2863: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2864: bil_bi_util_collection_pkg.writeLog(
2865: p_log_level => fnd_log.LEVEL_PROCEDURE,
2866: p_module => g_pkg || l_proc || ' begin',
2867: p_msg => 'Start of Procedure '|| l_proc);

Line 2864: bil_bi_util_collection_pkg.writeLog(

2860: BEGIN
2861: l_proc := 'Populate_Currency_Rate';
2862:
2863: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2864: bil_bi_util_collection_pkg.writeLog(
2865: p_log_level => fnd_log.LEVEL_PROCEDURE,
2866: p_module => g_pkg || l_proc || ' begin',
2867: p_msg => 'Start of Procedure '|| l_proc);
2868: END IF;

Line 2923: bil_bi_util_collection_pkg.analyze_table('BIL_BI_CURRENCY_RATE',TRUE, 10, 'GLOBAL');

2919: rates.srate
2920: );
2921:
2922: --gather stats on bil_bi_currency_rate during initial load
2923: bil_bi_util_collection_pkg.analyze_table('BIL_BI_CURRENCY_RATE',TRUE, 10, 'GLOBAL');
2924:
2925: ELSE
2926: MERGE INTO BIL_BI_CURRENCY_RATE sumry
2927: USING

Line 2978: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

2974: rates.srate
2975: );
2976: END IF;
2977:
2978: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
2979: bil_bi_util_collection_pkg.writeLog(
2980: p_log_level => fnd_log.LEVEL_EVENT,
2981: p_module => g_pkg || l_proc ,
2982: p_msg => 'Inserted '||sql%rowcount||' into bil_bi_currency_rate table');

Line 2979: bil_bi_util_collection_pkg.writeLog(

2975: );
2976: END IF;
2977:
2978: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
2979: bil_bi_util_collection_pkg.writeLog(
2980: p_log_level => fnd_log.LEVEL_EVENT,
2981: p_module => g_pkg || l_proc ,
2982: p_msg => 'Inserted '||sql%rowcount||' into bil_bi_currency_rate table');
2983: END IF;

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

2981: p_module => g_pkg || l_proc ,
2982: p_msg => 'Inserted '||sql%rowcount||' into bil_bi_currency_rate table');
2983: END IF;
2984: commit;
2985: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2986: bil_bi_util_collection_pkg.writeLog(
2987: p_log_level => fnd_log.LEVEL_PROCEDURE,
2988: p_module => g_pkg || l_proc || ' end',
2989: p_msg => 'End of Procedure '|| l_proc);

Line 2986: bil_bi_util_collection_pkg.writeLog(

2982: p_msg => 'Inserted '||sql%rowcount||' into bil_bi_currency_rate table');
2983: END IF;
2984: commit;
2985: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2986: bil_bi_util_collection_pkg.writeLog(
2987: p_log_level => fnd_log.LEVEL_PROCEDURE,
2988: p_module => g_pkg || l_proc || ' end',
2989: p_msg => 'End of Procedure '|| l_proc);
2990: END IF;

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

2993: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2994: fnd_message.set_token('ERRNO' ,SQLCODE);
2995: fnd_message.set_token('REASON' ,SQLERRM);
2996: fnd_message.set_token('ROUTINE' , l_proc);
2997: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2998: p_module => g_pkg || l_proc || ' proc_error',
2999: p_msg => fnd_message.get,
3000: p_force_log => TRUE);
3001:

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

3054: l_count :=0;
3055: l_number_of_rows :=0;
3056: l_proc := 'Summary_Err_Check';
3057:
3058: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
3059: bil_bi_util_collection_pkg.writeLog(
3060: p_log_level => fnd_log.LEVEL_PROCEDURE,
3061: p_module => g_pkg || l_proc || ' begin',
3062: p_msg => 'Start of Procedure '|| l_proc);

Line 3059: bil_bi_util_collection_pkg.writeLog(

3055: l_number_of_rows :=0;
3056: l_proc := 'Summary_Err_Check';
3057:
3058: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
3059: bil_bi_util_collection_pkg.writeLog(
3060: p_log_level => fnd_log.LEVEL_PROCEDURE,
3061: p_module => g_pkg || l_proc || ' begin',
3062: p_msg => 'Start of Procedure '|| l_proc);
3063: END IF;

Line 3120: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

3116:
3117: END IF;
3118:
3119:
3120: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
3121: bil_bi_util_collection_pkg.writeLog(
3122: p_log_level => fnd_log.LEVEL_EVENT,
3123: p_module => g_pkg || l_proc ,
3124: p_msg => 'Updated rates for '|| sql%rowcount || ' rows');

Line 3121: bil_bi_util_collection_pkg.writeLog(

3117: END IF;
3118:
3119:
3120: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
3121: bil_bi_util_collection_pkg.writeLog(
3122: p_log_level => fnd_log.LEVEL_EVENT,
3123: p_module => g_pkg || l_proc ,
3124: p_msg => 'Updated rates for '|| sql%rowcount || ' rows');
3125: END IF;

Line 3164: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

3160:
3161: END IF;
3162:
3163: IF (l_conv_rate_cnt >0) THEN
3164: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
3165: bil_bi_util_collection_pkg.writeLog
3166: (
3167: p_log_level =>fnd_log.LEVEL_ERROR,
3168: p_module => g_pkg || l_proc ,

Line 3165: bil_bi_util_collection_pkg.writeLog

3161: END IF;
3162:
3163: IF (l_conv_rate_cnt >0) THEN
3164: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
3165: bil_bi_util_collection_pkg.writeLog
3166: (
3167: p_log_level =>fnd_log.LEVEL_ERROR,
3168: p_module => g_pkg || l_proc ,
3169: p_msg => 'Missing currency conversion rates found, program will exit with error status.'||

Line 3222: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

3218: FII_TIME_API.check_missing_date (l_stg_min_dt,l_stg_max_dt,l_has_missing_date);
3219:
3220: END IF;
3221: IF (l_has_missing_date) THEN
3222: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
3223: bil_bi_util_collection_pkg.writeLog
3224: (
3225: p_log_level => fnd_log.LEVEL_EVENT,
3226: p_module => g_pkg || l_proc ,

Line 3223: bil_bi_util_collection_pkg.writeLog

3219:
3220: END IF;
3221: IF (l_has_missing_date) THEN
3222: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
3223: bil_bi_util_collection_pkg.writeLog
3224: (
3225: p_log_level => fnd_log.LEVEL_EVENT,
3226: p_module => g_pkg || l_proc ,
3227: p_msg => 'Time Dimension is not fully populated. '||

Line 3256: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

3252:
3253: IF(l_number_of_rows=1) THEN
3254: -- print header
3255:
3256: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
3257: bil_bi_util_collection_pkg.writeLog
3258: (
3259: p_log_level => fnd_log.LEVEL_EVENT,
3260: p_module => g_pkg || l_proc ,

Line 3257: bil_bi_util_collection_pkg.writeLog

3253: IF(l_number_of_rows=1) THEN
3254: -- print header
3255:
3256: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
3257: bil_bi_util_collection_pkg.writeLog
3258: (
3259: p_log_level => fnd_log.LEVEL_EVENT,
3260: p_module => g_pkg || l_proc ,
3261: p_msg => ' Some opportunties had null product category. They have not been collected.'

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

3262: );
3263: END IF;
3264:
3265: fnd_message.set_name('BIL','BIL_BI_ITEM_PROD_WARN_HDR');
3266: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3267: p_module => g_pkg || l_proc || ' proc_error',
3268: p_msg => fnd_message.get,
3269: p_force_log => TRUE);
3270: END IF;

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

3272: -- print detail
3273:
3274: fnd_message.set_name('BIL','BIL_BI_ITEM_PROD_ERR_DTL');
3275: fnd_message.set_token('OPPNUM', l_lead_num);
3276: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3277: p_module => g_pkg || l_proc || ' proc_error',
3278: p_msg => fnd_message.get,
3279: p_force_log => TRUE);
3280:

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

3291: x_return_warn := 'N';
3292: END IF;
3293:
3294:
3295: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
3296: bil_bi_util_collection_pkg.writeLog(
3297: p_log_level => fnd_log.LEVEL_PROCEDURE,
3298: p_module => g_pkg || l_proc || ' end',
3299: p_msg => 'End of Procedure '|| l_proc);

Line 3296: bil_bi_util_collection_pkg.writeLog(

3292: END IF;
3293:
3294:
3295: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
3296: bil_bi_util_collection_pkg.writeLog(
3297: p_log_level => fnd_log.LEVEL_PROCEDURE,
3298: p_module => g_pkg || l_proc || ' end',
3299: p_msg => 'End of Procedure '|| l_proc);
3300: END IF;

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

3304: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3305: fnd_message.set_token('ERRNO' ,SQLCODE);
3306: fnd_message.set_token('REASON' ,SQLERRM);
3307: fnd_message.set_token('ROUTINE' , l_proc);
3308: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3309: p_module => g_pkg || l_proc || ' proc_error',
3310: p_msg => fnd_message.get,
3311: p_force_log => TRUE);
3312: Raise;

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

3320: l_proc VARCHAR2(100);
3321: BEGIN
3322:
3323: l_proc := 'Report_Profile_Error';
3324: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
3325: bil_bi_util_collection_pkg.writeLog(
3326: p_log_level => fnd_log.LEVEL_PROCEDURE,
3327: p_module => g_pkg || l_proc || ' begin',
3328: p_msg => 'Start of Procedure '|| l_proc);

Line 3325: bil_bi_util_collection_pkg.writeLog(

3321: BEGIN
3322:
3323: l_proc := 'Report_Profile_Error';
3324: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
3325: bil_bi_util_collection_pkg.writeLog(
3326: p_log_level => fnd_log.LEVEL_PROCEDURE,
3327: p_module => g_pkg || l_proc || ' begin',
3328: p_msg => 'Start of Procedure '|| l_proc);
3329: END IF;

Line 3336: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN

3332:
3333: g_setup_error_flag := TRUE;
3334:
3335: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
3336: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN
3337: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3338: p_module => g_pkg || l_proc || ' proc_error',
3339: p_msg => fnd_message.get,
3340: p_force_log => TRUE);

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

3333: g_setup_error_flag := TRUE;
3334:
3335: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
3336: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN
3337: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3338: p_module => g_pkg || l_proc || ' proc_error',
3339: p_msg => fnd_message.get,
3340: p_force_log => TRUE);
3341:

Line 3347: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name(p_profile_name));

3343:
3344: END IF;
3345: IF (p_value <> p_exp_value) THEN
3346: fnd_message.set_name('BIL','BIL_BI_PROFILE_WRONG_VALUE');
3347: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name(p_profile_name));
3348: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,p_profile_name);
3349: fnd_message.set_token('PROFILE_VALUE' , p_exp_value);
3350:
3351: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN

Line 3351: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN

3347: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name(p_profile_name));
3348: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,p_profile_name);
3349: fnd_message.set_token('PROFILE_VALUE' , p_exp_value);
3350:
3351: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN
3352: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3353: p_module => g_pkg || l_proc || ' proc_error',
3354: p_msg => fnd_message.get,
3355: p_force_log => TRUE);

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

3348: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,p_profile_name);
3349: fnd_message.set_token('PROFILE_VALUE' , p_exp_value);
3350:
3351: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN
3352: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3353: p_module => g_pkg || l_proc || ' proc_error',
3354: p_msg => fnd_message.get,
3355: p_force_log => TRUE);
3356:

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

3356:
3357: END IF;
3358: END IF;
3359:
3360: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
3361: bil_bi_util_collection_pkg.writeLog(
3362: p_log_level => fnd_log.LEVEL_PROCEDURE,
3363: p_module => g_pkg || l_proc || ' end',
3364: p_msg => 'End of Procedure '|| l_proc);

Line 3361: bil_bi_util_collection_pkg.writeLog(

3357: END IF;
3358: END IF;
3359:
3360: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
3361: bil_bi_util_collection_pkg.writeLog(
3362: p_log_level => fnd_log.LEVEL_PROCEDURE,
3363: p_module => g_pkg || l_proc || ' end',
3364: p_msg => 'End of Procedure '|| l_proc);
3365: END IF;

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

3370: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3371: fnd_message.set_token('ERRNO' ,SQLCODE);
3372: fnd_message.set_token('REASON' ,SQLERRM);
3373: fnd_message.set_token('ROUTINE' , l_proc);
3374: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3375: p_module => g_pkg || l_proc || ' proc_error',
3376: p_msg => fnd_message.get,
3377: p_force_log => TRUE);
3378:

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

3385: BEGIN
3386: l_proc := 'Report_Missing_Profile';
3387:
3388:
3389: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
3390: bil_bi_util_collection_pkg.writeLog
3391: (
3392: p_log_level => fnd_log.LEVEL_PROCEDURE,
3393: p_module => g_pkg || l_proc || ' begin',

Line 3390: bil_bi_util_collection_pkg.writeLog

3386: l_proc := 'Report_Missing_Profile';
3387:
3388:
3389: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
3390: bil_bi_util_collection_pkg.writeLog
3391: (
3392: p_log_level => fnd_log.LEVEL_PROCEDURE,
3393: p_module => g_pkg || l_proc || ' begin',
3394: p_msg => 'Start of Procedure '|| l_proc

Line 3402: bil_bi_util_collection_pkg.writeLog

3398: -- print the header
3399: IF (g_setup_error_flag = FALSE) THEN
3400: g_setup_error_flag := TRUE;
3401: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
3402: bil_bi_util_collection_pkg.writeLog
3403: (
3404: p_log_level => fnd_log.LEVEL_ERROR,
3405: p_module => g_pkg || l_proc || ' proc_error',
3406: p_msg => fnd_message.get,

Line 3412: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name(p_profile_name));

3408: );
3409: END IF;
3410:
3411: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3412: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name(p_profile_name));
3413: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,p_profile_name);
3414:
3415:
3416: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,

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

3412: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name(p_profile_name));
3413: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,p_profile_name);
3414:
3415:
3416: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3417: p_module => g_pkg || l_proc || ' proc_error',
3418: p_msg => fnd_message.get,
3419: p_force_log => TRUE);
3420:

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

3417: p_module => g_pkg || l_proc || ' proc_error',
3418: p_msg => fnd_message.get,
3419: p_force_log => TRUE);
3420:
3421: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
3422: bil_bi_util_collection_pkg.writeLog(
3423: p_log_level => fnd_log.LEVEL_PROCEDURE,
3424: p_module => g_pkg || l_proc || ' end',
3425: p_msg => 'End of Procedure '|| l_proc);

Line 3422: bil_bi_util_collection_pkg.writeLog(

3418: p_msg => fnd_message.get,
3419: p_force_log => TRUE);
3420:
3421: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
3422: bil_bi_util_collection_pkg.writeLog(
3423: p_log_level => fnd_log.LEVEL_PROCEDURE,
3424: p_module => g_pkg || l_proc || ' end',
3425: p_msg => 'End of Procedure '|| l_proc);
3426: END IF;

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

3431: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3432: fnd_message.set_token('ERRNO' ,SQLCODE);
3433: fnd_message.set_token('REASON' ,SQLERRM);
3434: fnd_message.set_token('ROUTINE' , l_proc);
3435: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3436: p_module => g_pkg || l_proc || ' proc_error',
3437: p_msg => fnd_message.get,
3438: p_force_log => TRUE);
3439:

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

3475: BEGIN
3476:
3477: l_proc := 'Report_Missing_Rates';
3478:
3479: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
3480: bil_bi_util_collection_pkg.writeLog(
3481: p_log_level => fnd_log.LEVEL_PROCEDURE,
3482: p_module => g_pkg || l_proc || ' begin',
3483: p_msg => 'Start of Procedure '|| l_proc);

Line 3480: bil_bi_util_collection_pkg.writeLog(

3476:
3477: l_proc := 'Report_Missing_Rates';
3478:
3479: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
3480: bil_bi_util_collection_pkg.writeLog(
3481: p_log_level => fnd_log.LEVEL_PROCEDURE,
3482: p_module => g_pkg || l_proc || ' begin',
3483: p_msg => 'Start of Procedure '|| l_proc);
3484: END IF;

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

3484: END IF;
3485:
3486: BIS_COLLECTION_UTILITIES.WriteMissingRateHeader;
3487:
3488: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
3489: bil_bi_util_collection_pkg.writeLog(
3490: p_log_level => fnd_log.LEVEL_STATEMENT,
3491: p_module => g_pkg || l_proc,
3492: p_msg => 'Missing conversions');

Line 3489: bil_bi_util_collection_pkg.writeLog(

3485:
3486: BIS_COLLECTION_UTILITIES.WriteMissingRateHeader;
3487:
3488: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
3489: bil_bi_util_collection_pkg.writeLog(
3490: p_log_level => fnd_log.LEVEL_STATEMENT,
3491: p_module => g_pkg || l_proc,
3492: p_msg => 'Missing conversions');
3493: END IF;

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

3516:
3517: END LOOP;
3518:
3519:
3520: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
3521: bil_bi_util_collection_pkg.writeLog(
3522: p_log_level => fnd_log.LEVEL_PROCEDURE,
3523: p_module => g_pkg || l_proc || ' end',
3524: p_msg => 'End of Procedure '|| l_proc);

Line 3521: bil_bi_util_collection_pkg.writeLog(

3517: END LOOP;
3518:
3519:
3520: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
3521: bil_bi_util_collection_pkg.writeLog(
3522: p_log_level => fnd_log.LEVEL_PROCEDURE,
3523: p_module => g_pkg || l_proc || ' end',
3524: p_msg => 'End of Procedure '|| l_proc);
3525: END IF;

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

3530: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3531: fnd_message.set_token('ERRNO' ,SQLCODE);
3532: fnd_message.set_token('REASON' ,SQLERRM);
3533: fnd_message.set_token('ROUTINE' , l_proc);
3534: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3535: p_module => g_pkg || l_proc || ' proc_error',
3536: p_msg => fnd_message.get,
3537: p_force_log => TRUE);
3538:

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

3558: BEGIN
3559:
3560: l_proc := 'Insert_Into_Curr_sumry';
3561:
3562: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
3563: bil_bi_util_collection_pkg.writeLog(
3564: p_log_level => fnd_log.LEVEL_PROCEDURE,
3565: p_module => g_pkg || l_proc || ' begin',
3566: p_msg => 'Start of Procedure '|| l_proc);

Line 3563: bil_bi_util_collection_pkg.writeLog(

3559:
3560: l_proc := 'Insert_Into_Curr_sumry';
3561:
3562: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
3563: bil_bi_util_collection_pkg.writeLog(
3564: p_log_level => fnd_log.LEVEL_PROCEDURE,
3565: p_module => g_pkg || l_proc || ' begin',
3566: p_msg => 'Start of Procedure '|| l_proc);
3567: END IF;

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

4038: product_category_id
4039: ;
4040: commit;
4041:
4042: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
4043: bil_bi_util_collection_pkg.writeLog(
4044: p_log_level => fnd_log.LEVEL_PROCEDURE,
4045: p_module => g_pkg || l_proc || ' end',
4046: p_msg => 'End of Procedure '|| l_proc);

Line 4043: bil_bi_util_collection_pkg.writeLog(

4039: ;
4040: commit;
4041:
4042: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
4043: bil_bi_util_collection_pkg.writeLog(
4044: p_log_level => fnd_log.LEVEL_PROCEDURE,
4045: p_module => g_pkg || l_proc || ' end',
4046: p_msg => 'End of Procedure '|| l_proc);
4047: END IF;

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

4052: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
4053: fnd_message.set_token('ERRNO' ,SQLCODE);
4054: fnd_message.set_token('REASON' ,SQLERRM);
4055: fnd_message.set_token('ROUTINE' , l_proc);
4056: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
4057: p_module => g_pkg || l_proc || ' proc_error',
4058: p_msg => fnd_message.get,
4059: p_force_log => TRUE);
4060:

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

4070:
4071: l_proc:= 'Insert_Into_Summary';
4072:
4073:
4074: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
4075: bil_bi_util_collection_pkg.writeLog(
4076: p_log_level => fnd_log.LEVEL_PROCEDURE,
4077: p_module => g_pkg || l_proc || ' begin',
4078: p_msg => 'Start of Procedure '|| l_proc);

Line 4075: bil_bi_util_collection_pkg.writeLog(

4071: l_proc:= 'Insert_Into_Summary';
4072:
4073:
4074: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
4075: bil_bi_util_collection_pkg.writeLog(
4076: p_log_level => fnd_log.LEVEL_PROCEDURE,
4077: p_module => g_pkg || l_proc || ' begin',
4078: p_msg => 'Start of Procedure '|| l_proc);
4079: END IF;

Line 4418: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

4414:
4415: g_row_num:= sql%rowcount;
4416: commit;
4417:
4418: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
4419: bil_bi_util_collection_pkg.writeLog(
4420: p_log_level => fnd_log.LEVEL_EVENT,
4421: p_module => g_pkg || l_proc ,
4422: p_msg => 'Inserted '|| g_row_num||' into BIL_BI_PIPELINE_F table from BIL_BI_PIPELINE_STG ');

Line 4419: bil_bi_util_collection_pkg.writeLog(

4415: g_row_num:= sql%rowcount;
4416: commit;
4417:
4418: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
4419: bil_bi_util_collection_pkg.writeLog(
4420: p_log_level => fnd_log.LEVEL_EVENT,
4421: p_module => g_pkg || l_proc ,
4422: p_msg => 'Inserted '|| g_row_num||' into BIL_BI_PIPELINE_F table from BIL_BI_PIPELINE_STG ');
4423: END IF;

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

4423: END IF;
4424:
4425:
4426:
4427: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
4428: bil_bi_util_collection_pkg.writeLog(
4429: p_log_level => fnd_log.LEVEL_PROCEDURE,
4430: p_module => g_pkg || l_proc || ' end',
4431: p_msg => 'End of Procedure '|| l_proc);

Line 4428: bil_bi_util_collection_pkg.writeLog(

4424:
4425:
4426:
4427: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
4428: bil_bi_util_collection_pkg.writeLog(
4429: p_log_level => fnd_log.LEVEL_PROCEDURE,
4430: p_module => g_pkg || l_proc || ' end',
4431: p_msg => 'End of Procedure '|| l_proc);
4432: END IF;

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

4437: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
4438: fnd_message.set_token('ERRNO' ,SQLCODE);
4439: fnd_message.set_token('REASON' ,SQLERRM);
4440: fnd_message.set_token('ROUTINE' , l_proc);
4441: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
4442: p_module => g_pkg || l_proc || ' proc_error',
4443: p_msg => fnd_message.get,
4444: p_force_log => TRUE);
4445:

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

4464: l_proc := 'Build_BaseLine';
4465: l_limit_date := add_months(trunc(g_program_start),24); --added by annsrini --fix for bug 5953589
4466:
4467:
4468: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
4469: bil_bi_util_collection_pkg.writeLog(
4470: p_log_level => fnd_log.LEVEL_PROCEDURE,
4471: p_module => g_pkg || l_proc || ' begin',
4472: p_msg => 'Start of Procedure '|| l_proc);

Line 4469: bil_bi_util_collection_pkg.writeLog(

4465: l_limit_date := add_months(trunc(g_program_start),24); --added by annsrini --fix for bug 5953589
4466:
4467:
4468: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
4469: bil_bi_util_collection_pkg.writeLog(
4470: p_log_level => fnd_log.LEVEL_PROCEDURE,
4471: p_module => g_pkg || l_proc || ' begin',
4472: p_msg => 'Start of Procedure '|| l_proc);
4473: END IF;

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

4473: END IF;
4474:
4475:
4476:
4477: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
4478: bil_bi_util_collection_pkg.writeLog(
4479: p_log_level => fnd_log.LEVEL_STATEMENT,
4480: p_module => g_pkg || l_proc ,
4481: p_msg => 'p_start_date is '|| p_start_date);

Line 4478: bil_bi_util_collection_pkg.writeLog(

4474:
4475:
4476:
4477: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
4478: bil_bi_util_collection_pkg.writeLog(
4479: p_log_level => fnd_log.LEVEL_STATEMENT,
4480: p_module => g_pkg || l_proc ,
4481: p_msg => 'p_start_date is '|| p_start_date);
4482:

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

4651:
4652:
4653:
4654:
4655: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
4656: bil_bi_util_collection_pkg.writeLog(
4657: p_log_level => fnd_log.LEVEL_PROCEDURE,
4658: p_module => g_pkg || l_proc || ' end',
4659: p_msg => 'End of Procedure '|| l_proc);

Line 4656: bil_bi_util_collection_pkg.writeLog(

4652:
4653:
4654:
4655: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
4656: bil_bi_util_collection_pkg.writeLog(
4657: p_log_level => fnd_log.LEVEL_PROCEDURE,
4658: p_module => g_pkg || l_proc || ' end',
4659: p_msg => 'End of Procedure '|| l_proc);
4660: END IF;

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

4669: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
4670: fnd_message.set_token('ERRNO' ,SQLCODE);
4671: fnd_message.set_token('REASON' ,SQLERRM);
4672: fnd_message.set_token('ROUTINE' , l_proc);
4673: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
4674: p_module => g_pkg || l_proc || ' proc_error',
4675: p_msg => fnd_message.get,
4676: p_force_log => TRUE);
4677:

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

4692: l_rank := 1;
4693: l_limit_date := add_months(trunc(g_program_start),24); --added by annsrini --fix for bug 5953589
4694:
4695:
4696: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
4697: bil_bi_util_collection_pkg.writeLog(
4698: p_log_level => fnd_log.LEVEL_PROCEDURE,
4699: p_module => g_pkg || l_proc || ' begin',
4700: p_msg => 'Start of Procedure '|| l_proc);

Line 4697: bil_bi_util_collection_pkg.writeLog(

4693: l_limit_date := add_months(trunc(g_program_start),24); --added by annsrini --fix for bug 5953589
4694:
4695:
4696: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
4697: bil_bi_util_collection_pkg.writeLog(
4698: p_log_level => fnd_log.LEVEL_PROCEDURE,
4699: p_module => g_pkg || l_proc || ' begin',
4700: p_msg => 'Start of Procedure '|| l_proc);
4701: END IF;

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

4716: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
4717: fnd_message.set_token('ERRNO' ,SQLCODE);
4718: fnd_message.set_token('REASON' ,SQLERRM);
4719: fnd_message.set_token('ROUTINE' , l_proc);
4720: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
4721: p_module => g_pkg || l_proc || ' ERROR while getting the dates',
4722: p_msg => fnd_message.get,
4723: p_force_log => TRUE);
4724:

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

4929: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
4930: fnd_message.set_token('ERRNO' ,SQLCODE);
4931: fnd_message.set_token('REASON' ,SQLERRM);
4932: fnd_message.set_token('ROUTINE' , l_proc);
4933: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
4934: p_module => g_pkg || l_proc || ' ERROR while inserting into denlog_tmp',
4935: p_msg => fnd_message.get,
4936: p_force_log => TRUE);
4937:

Line 4942: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

4938: raise;
4939:
4940: END;
4941:
4942: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
4943: bil_bi_util_collection_pkg.writeLog
4944: (
4945: p_log_level => fnd_log.LEVEL_EVENT,
4946: p_module => g_pkg || l_proc ,

Line 4943: bil_bi_util_collection_pkg.writeLog

4939:
4940: END;
4941:
4942: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
4943: bil_bi_util_collection_pkg.writeLog
4944: (
4945: p_log_level => fnd_log.LEVEL_EVENT,
4946: p_module => g_pkg || l_proc ,
4947: p_msg => 'inserted ' || sql%rowcount || 'into denlog_tmp from leadlog');

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

5034: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
5035: fnd_message.set_token('ERRNO' ,SQLCODE);
5036: fnd_message.set_token('REASON' ,SQLERRM);
5037: fnd_message.set_token('ROUTINE' , l_proc);
5038: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
5039: p_module => g_pkg || l_proc || ' ERROR while inserting into denlog_stg',
5040: p_msg => fnd_message.get,
5041: p_force_log => TRUE);
5042:

Line 5046: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

5042:
5043: raise;
5044:
5045: END;
5046: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5047: bil_bi_util_collection_pkg.writeLog
5048: (
5049: p_log_level => fnd_log.LEVEL_EVENT,
5050: p_module => g_pkg || l_proc ,

Line 5047: bil_bi_util_collection_pkg.writeLog

5043: raise;
5044:
5045: END;
5046: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5047: bil_bi_util_collection_pkg.writeLog
5048: (
5049: p_log_level => fnd_log.LEVEL_EVENT,
5050: p_module => g_pkg || l_proc ,
5051: p_msg => 'inserted ' || sql%rowcount || 'into denlog_tmp_stg');

Line 5257: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

5253: );
5254: commit;
5255:
5256:
5257: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5258: bil_bi_util_collection_pkg.writeLog
5259: (
5260: p_log_level => fnd_log.LEVEL_EVENT,
5261: p_module => g_pkg || l_proc ,

Line 5258: bil_bi_util_collection_pkg.writeLog

5254: commit;
5255:
5256:
5257: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5258: bil_bi_util_collection_pkg.writeLog
5259: (
5260: p_log_level => fnd_log.LEVEL_EVENT,
5261: p_module => g_pkg || l_proc ,
5262: p_msg => 'inserted ' || sql%rowcount || 'into denlog_tmp');

Line 5275: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

5271: and tmp2.rev_flag = 'D')
5272: and rev_flag <> 'D'; */
5273:
5274:
5275: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5276: bil_bi_util_collection_pkg.writeLog
5277: (
5278: p_log_level => fnd_log.LEVEL_EVENT,
5279: p_module => g_pkg || l_proc ,

Line 5276: bil_bi_util_collection_pkg.writeLog

5272: and rev_flag <> 'D'; */
5273:
5274:
5275: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5276: bil_bi_util_collection_pkg.writeLog
5277: (
5278: p_log_level => fnd_log.LEVEL_EVENT,
5279: p_module => g_pkg || l_proc ,
5280: p_msg => 'deleted ' || sql%rowcount || 'from denlog_tmp for same day update ');

Line 5345: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

5341: AND NVL(linelog.forecast_date, leadlog.decision_date) <=l_limit_date
5342: AND lead.decision_date >= G_Global_Start_Date
5343: AND lead.decision_date <= l_limit_date;
5344:
5345: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5346: bil_bi_util_collection_pkg.writeLog
5347: (
5348: p_log_level => fnd_log.LEVEL_EVENT,
5349: p_module => g_pkg || l_proc ,

Line 5346: bil_bi_util_collection_pkg.writeLog

5342: AND lead.decision_date >= G_Global_Start_Date
5343: AND lead.decision_date <= l_limit_date;
5344:
5345: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5346: bil_bi_util_collection_pkg.writeLog
5347: (
5348: p_log_level => fnd_log.LEVEL_EVENT,
5349: p_module => g_pkg || l_proc ,
5350: p_msg => 'inserted ' || sql%rowcount || 'into denlog_stg');

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

5353: commit;
5354: END IF;
5355:
5356:
5357: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
5358: bil_bi_util_collection_pkg.writeLog(
5359: p_log_level => fnd_log.LEVEL_PROCEDURE,
5360: p_module => g_pkg || l_proc || ' end',
5361: p_msg => 'End of Procedure '|| l_proc);

Line 5358: bil_bi_util_collection_pkg.writeLog(

5354: END IF;
5355:
5356:
5357: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
5358: bil_bi_util_collection_pkg.writeLog(
5359: p_log_level => fnd_log.LEVEL_PROCEDURE,
5360: p_module => g_pkg || l_proc || ' end',
5361: p_msg => 'End of Procedure '|| l_proc);
5362: END IF;

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

5367: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
5368: fnd_message.set_token('ERRNO' ,SQLCODE);
5369: fnd_message.set_token('REASON' ,SQLERRM);
5370: fnd_message.set_token('ROUTINE' , l_proc);
5371: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
5372: p_module => g_pkg || l_proc || ' proc_error',
5373: p_msg => fnd_message.get,
5374: p_force_log => TRUE);
5375:

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

5441: BEGIN
5442:
5443: l_proc := 'Gap_Fill';
5444:
5445: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
5446: bil_bi_util_collection_pkg.writeLog(
5447:
5448: p_log_level => fnd_log.LEVEL_PROCEDURE,
5449: p_module => g_pkg || l_proc || ' begin',

Line 5446: bil_bi_util_collection_pkg.writeLog(

5442:
5443: l_proc := 'Gap_Fill';
5444:
5445: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
5446: bil_bi_util_collection_pkg.writeLog(
5447:
5448: p_log_level => fnd_log.LEVEL_PROCEDURE,
5449: p_module => g_pkg || l_proc || ' begin',
5450: p_msg => 'Start of Procedure '|| l_proc);

Line 5464: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

5460: EXIT WHEN c1%NOTFOUND ;
5461:
5462:
5463:
5464: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5465: bil_bi_util_collection_pkg.writeLog
5466: (
5467: p_log_level => fnd_log.LEVEL_EVENT,
5468: p_module => g_pkg || l_proc ,

Line 5465: bil_bi_util_collection_pkg.writeLog

5461:
5462:
5463:
5464: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5465: bil_bi_util_collection_pkg.writeLog
5466: (
5467: p_log_level => fnd_log.LEVEL_EVENT,
5468: p_module => g_pkg || l_proc ,
5469: p_msg => 'working on ' || l_cur_date || 'l_type: ' || l_pipe_tbl_type);

Line 5504: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

5500: AND tmp.lead_line_id = stg1.line_id
5501: AND tmp.sales_credit_id = stg1.credit_id
5502: AND last_update_date = l_cur_date);
5503:
5504: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5505: bil_bi_util_collection_pkg.writeLog
5506:
5507: (
5508: p_log_level => fnd_log.LEVEL_EVENT,

Line 5505: bil_bi_util_collection_pkg.writeLog

5501: AND tmp.sales_credit_id = stg1.credit_id
5502: AND last_update_date = l_cur_date);
5503:
5504: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5505: bil_bi_util_collection_pkg.writeLog
5506:
5507: (
5508: p_log_level => fnd_log.LEVEL_EVENT,
5509: p_module => g_pkg || l_proc ,

Line 5528: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

5524: -- DELETE /*+parallel(stg) */FROM bil_bi_pipeline_stg stg
5525: /* WHERE to_number(to_char(EFFECTIVE_DATE, 'J')) < l_min_date_id;
5526:
5527:
5528: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5529: bil_bi_util_collection_pkg.writeLog
5530:
5531: (
5532: p_log_level => fnd_log.LEVEL_EVENT,

Line 5529: bil_bi_util_collection_pkg.writeLog

5525: /* WHERE to_number(to_char(EFFECTIVE_DATE, 'J')) < l_min_date_id;
5526:
5527:
5528: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5529: bil_bi_util_collection_pkg.writeLog
5530:
5531: (
5532: p_log_level => fnd_log.LEVEL_EVENT,
5533: p_module => g_pkg || l_proc ,

Line 5598: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

5594: AND product_category_id is not null;
5595:
5596:
5597:
5598: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5599: bil_bi_util_collection_pkg.writeLog
5600: (
5601: p_log_level => fnd_log.LEVEL_EVENT,
5602:

Line 5599: bil_bi_util_collection_pkg.writeLog

5595:
5596:
5597:
5598: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5599: bil_bi_util_collection_pkg.writeLog
5600: (
5601: p_log_level => fnd_log.LEVEL_EVENT,
5602:
5603: p_module => g_pkg || l_proc ,

Line 5815: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

5811:
5812: AND tmp.sales_credit_id = stg1.credit_id
5813: AND last_update_date = l_cur_date);
5814:
5815: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5816: bil_bi_util_collection_pkg.writeLog
5817: (
5818: p_log_level => fnd_log.LEVEL_EVENT,
5819: p_module => g_pkg || l_proc ,

Line 5816: bil_bi_util_collection_pkg.writeLog

5812: AND tmp.sales_credit_id = stg1.credit_id
5813: AND last_update_date = l_cur_date);
5814:
5815: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5816: bil_bi_util_collection_pkg.writeLog
5817: (
5818: p_log_level => fnd_log.LEVEL_EVENT,
5819: p_module => g_pkg || l_proc ,
5820: p_msg => 'deleted ' || sql%rowcount || 'from stg');

Line 5837: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

5833: WHERE to_number(to_char(EFFECTIVE_DATE, 'J')) < l_min_date_id;
5834:
5835:
5836:
5837: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5838: bil_bi_util_collection_pkg.writeLog
5839: (
5840: p_log_level => fnd_log.LEVEL_EVENT,
5841: p_module => g_pkg || l_proc ,

Line 5838: bil_bi_util_collection_pkg.writeLog

5834:
5835:
5836:
5837: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5838: bil_bi_util_collection_pkg.writeLog
5839: (
5840: p_log_level => fnd_log.LEVEL_EVENT,
5841: p_module => g_pkg || l_proc ,
5842: p_msg => 'deleted ' || sql%rowcount || 'from stg for last year ');

Line 5905: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

5901: AND product_category_id is not null;
5902:
5903:
5904:
5905: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5906: bil_bi_util_collection_pkg.writeLog
5907:
5908: (
5909: p_log_level => fnd_log.LEVEL_EVENT,

Line 5906: bil_bi_util_collection_pkg.writeLog

5902:
5903:
5904:
5905: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
5906: bil_bi_util_collection_pkg.writeLog
5907:
5908: (
5909: p_log_level => fnd_log.LEVEL_EVENT,
5910: p_module => g_pkg || l_proc ,

Line 6126: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

6122: END IF ; --if pipe_tbl_type='HIST'
6123:
6124: END IF;
6125:
6126: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
6127: bil_bi_util_collection_pkg.writeLog
6128: (
6129: p_log_level => fnd_log.LEVEL_EVENT,
6130: p_module => g_pkg || l_proc ,

Line 6127: bil_bi_util_collection_pkg.writeLog

6123:
6124: END IF;
6125:
6126: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
6127: bil_bi_util_collection_pkg.writeLog
6128: (
6129: p_log_level => fnd_log.LEVEL_EVENT,
6130: p_module => g_pkg || l_proc ,
6131: p_msg => 'inserted ' || sql%rowcount || 'into fact');

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

6138:
6139: CLOSE c1;
6140:
6141:
6142: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
6143: bil_bi_util_collection_pkg.writeLog(
6144: p_log_level => fnd_log.LEVEL_PROCEDURE,
6145:
6146: p_module => g_pkg || l_proc || ' end',

Line 6143: bil_bi_util_collection_pkg.writeLog(

6139: CLOSE c1;
6140:
6141:
6142: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
6143: bil_bi_util_collection_pkg.writeLog(
6144: p_log_level => fnd_log.LEVEL_PROCEDURE,
6145:
6146: p_module => g_pkg || l_proc || ' end',
6147: p_msg => 'End of Procedure '|| l_proc);

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

6154: fnd_message.set_token('ERRNO' ,SQLCODE);
6155: fnd_message.set_token('REASON' ,SQLERRM);
6156: fnd_message.set_token('ROUTINE' , l_proc);
6157:
6158: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
6159: p_module => g_pkg || l_proc || ' proc_error',
6160: p_msg => fnd_message.get,
6161: p_force_log => TRUE);
6162:

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

6174:
6175: l_proc := 'Insert_Into_Stg_SmallGap';
6176: l_limit_date := add_months(trunc(g_program_start),24); --added by annsrini --fix for bug 5953589
6177:
6178: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
6179: bil_bi_util_collection_pkg.writeLog(
6180: p_log_level => fnd_log.LEVEL_PROCEDURE,
6181: p_module => g_pkg || l_proc || ' begin',
6182: p_msg => 'Start of Procedure '|| l_proc);

Line 6179: bil_bi_util_collection_pkg.writeLog(

6175: l_proc := 'Insert_Into_Stg_SmallGap';
6176: l_limit_date := add_months(trunc(g_program_start),24); --added by annsrini --fix for bug 5953589
6177:
6178: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
6179: bil_bi_util_collection_pkg.writeLog(
6180: p_log_level => fnd_log.LEVEL_PROCEDURE,
6181: p_module => g_pkg || l_proc || ' begin',
6182: p_msg => 'Start of Procedure '|| l_proc);
6183: END IF;

Line 6320: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

6316:
6317: SELECT COUNT(1) INTO l_count FROM BIL_BI_PIPELINE_STG;
6318:
6319:
6320: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
6321: bil_bi_util_collection_pkg.writeLog(
6322: p_log_level => fnd_log.LEVEL_EVENT,
6323: p_module => g_pkg || l_proc || ' end',
6324: p_msg => 'Inserted into staging from as log tables '|| l_count);

Line 6321: bil_bi_util_collection_pkg.writeLog(

6317: SELECT COUNT(1) INTO l_count FROM BIL_BI_PIPELINE_STG;
6318:
6319:
6320: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
6321: bil_bi_util_collection_pkg.writeLog(
6322: p_log_level => fnd_log.LEVEL_EVENT,
6323: p_module => g_pkg || l_proc || ' end',
6324: p_msg => 'Inserted into staging from as log tables '|| l_count);
6325: END IF;

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

6323: p_module => g_pkg || l_proc || ' end',
6324: p_msg => 'Inserted into staging from as log tables '|| l_count);
6325: END IF;
6326:
6327: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
6328: bil_bi_util_collection_pkg.writeLog(
6329: p_log_level => fnd_log.LEVEL_PROCEDURE,
6330: p_module => g_pkg || l_proc || ' end',
6331: p_msg => 'End of Procedure '|| l_proc);

Line 6328: bil_bi_util_collection_pkg.writeLog(

6324: p_msg => 'Inserted into staging from as log tables '|| l_count);
6325: END IF;
6326:
6327: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
6328: bil_bi_util_collection_pkg.writeLog(
6329: p_log_level => fnd_log.LEVEL_PROCEDURE,
6330: p_module => g_pkg || l_proc || ' end',
6331: p_msg => 'End of Procedure '|| l_proc);
6332: END IF;

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

6337: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
6338: fnd_message.set_token('ERRNO' ,SQLCODE);
6339: fnd_message.set_token('REASON' ,SQLERRM);
6340: fnd_message.set_token('ROUTINE' , l_proc);
6341: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
6342: p_module => g_pkg || l_proc || ' proc_error',
6343: p_msg => fnd_message.get,
6344: p_force_log => TRUE);
6345:

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

6364: BEGIN
6365:
6366: l_proc := 'Ins_Into_CurrSum_SmGap';
6367:
6368: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
6369: bil_bi_util_collection_pkg.writeLog(
6370: p_log_level => fnd_log.LEVEL_PROCEDURE,
6371: p_module => g_pkg || l_proc || ' begin',
6372: p_msg => 'Start of Procedure '|| l_proc);

Line 6369: bil_bi_util_collection_pkg.writeLog(

6365:
6366: l_proc := 'Ins_Into_CurrSum_SmGap';
6367:
6368: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
6369: bil_bi_util_collection_pkg.writeLog(
6370: p_log_level => fnd_log.LEVEL_PROCEDURE,
6371: p_module => g_pkg || l_proc || ' begin',
6372: p_msg => 'Start of Procedure '|| l_proc);
6373: END IF;

Line 6410: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

6406: where report_date=l_sd_lyr;
6407:
6408: EXCEPTION WHEN NO_DATA_FOUND THEN
6409: NULL;
6410: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
6411: bil_bi_util_collection_pkg.writeLog
6412: (
6413: p_log_level => fnd_log.LEVEL_EVENT,
6414: p_module => g_pkg || l_proc ,

Line 6411: bil_bi_util_collection_pkg.writeLog

6407:
6408: EXCEPTION WHEN NO_DATA_FOUND THEN
6409: NULL;
6410: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
6411: bil_bi_util_collection_pkg.writeLog
6412: (
6413: p_log_level => fnd_log.LEVEL_EVENT,
6414: p_module => g_pkg || l_proc ,
6415: p_msg => 'inside no_data_found in insert into curr sumry ');

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

6859: ;
6860:
6861: commit;
6862:
6863: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
6864: bil_bi_util_collection_pkg.writeLog(
6865: p_log_level => fnd_log.LEVEL_PROCEDURE,
6866: p_module => g_pkg || l_proc || ' end',
6867: p_msg => 'End of Procedure '|| l_proc);

Line 6864: bil_bi_util_collection_pkg.writeLog(

6860:
6861: commit;
6862:
6863: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
6864: bil_bi_util_collection_pkg.writeLog(
6865: p_log_level => fnd_log.LEVEL_PROCEDURE,
6866: p_module => g_pkg || l_proc || ' end',
6867: p_msg => 'End of Procedure '|| l_proc);
6868: END IF;

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

6873: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
6874: fnd_message.set_token('ERRNO' ,SQLCODE);
6875: fnd_message.set_token('REASON' ,SQLERRM);
6876: fnd_message.set_token('ROUTINE' , l_proc);
6877: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
6878: p_module => g_pkg || l_proc || ' proc_error',
6879: p_msg => fnd_message.get,
6880: p_force_log => TRUE);
6881: