eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIL_BI_OPDTL_F_PKG dependencies on BIL_BI_UTIL_COLLECTION_PKG

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

121: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
122: fnd_message.set_token('ERRNO' ,SQLCODE);
123: fnd_message.set_token('REASON', SQLERRM);
124: fnd_message.set_token('ROUTINE', l_proc);
125: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
126: p_module => g_pkg || l_proc || ' proc_error',
127: p_msg => fnd_message.get,
128: p_force_log => TRUE);
129: RAISE;

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

158: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
159: fnd_message.set_token('ERRNO' ,SQLCODE);
160: fnd_message.set_token('REASON', SQLERRM);
161: fnd_message.set_token('ROUTINE', l_proc);
162: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
163: p_module => g_pkg || l_proc || ' proc_error',
164: p_msg => fnd_message.get,
165: p_force_log => TRUE);
166:

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

192: l_proc := 'Init_load';
193:
194: l_valid_setup := BIS_COLLECTION_UTILITIES.SETUP('BIL_BI_OPDTL_F');
195: IF (not l_valid_setup) THEN
196: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
197: bil_bi_util_collection_pkg.writeLog(
198: p_log_level => fnd_log.LEVEL_EVENT,
199: p_module => g_pkg || l_proc ,
200: p_msg => 'BIS_COLLECTION_UTILITIES.SETUP failed' );

Line 197: bil_bi_util_collection_pkg.writeLog(

193:
194: l_valid_setup := BIS_COLLECTION_UTILITIES.SETUP('BIL_BI_OPDTL_F');
195: IF (not l_valid_setup) THEN
196: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
197: bil_bi_util_collection_pkg.writeLog(
198: p_log_level => fnd_log.LEVEL_EVENT,
199: p_module => g_pkg || l_proc ,
200: p_msg => 'BIS_COLLECTION_UTILITIES.SETUP failed' );
201: END IF;

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

201: END IF;
202: retcode := g_retcode;
203: return;
204: END IF;
205: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
206: bil_bi_util_collection_pkg.writeLog(
207: p_log_level => fnd_log.LEVEL_PROCEDURE,
208: p_module => g_pkg || l_proc || ' begin',
209: p_msg => 'Start of Procedure '|| l_proc);

Line 206: bil_bi_util_collection_pkg.writeLog(

202: retcode := g_retcode;
203: return;
204: END IF;
205: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
206: bil_bi_util_collection_pkg.writeLog(
207: p_log_level => fnd_log.LEVEL_PROCEDURE,
208: p_module => g_pkg || l_proc || ' begin',
209: p_msg => 'Start of Procedure '|| l_proc);
210: END IF;

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

223: /*
224: A generic line in the log file that requests the user to see the o/p file for
225: further info.
226: */
227: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
228: bil_bi_util_collection_pkg.writeLog
229: (
230: p_log_level => fnd_log.LEVEL_EVENT,
231: p_module => g_pkg || l_proc,

Line 228: bil_bi_util_collection_pkg.writeLog

224: A generic line in the log file that requests the user to see the o/p file for
225: further info.
226: */
227: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
228: bil_bi_util_collection_pkg.writeLog
229: (
230: p_log_level => fnd_log.LEVEL_EVENT,
231: p_module => g_pkg || l_proc,
232: p_msg =>

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

233: ' If there have been errors, Please refer to the Concurrent program output file for more information '
234: );
235: END IF;
236:
237: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
238: bil_bi_util_collection_pkg.writeLog(
239: p_log_level => fnd_log.LEVEL_PROCEDURE,
240: p_module => g_pkg || l_proc || ' end',
241: p_msg => 'End of Procedure '|| l_proc);

Line 238: bil_bi_util_collection_pkg.writeLog(

234: );
235: END IF;
236:
237: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
238: bil_bi_util_collection_pkg.writeLog(
239: p_log_level => fnd_log.LEVEL_PROCEDURE,
240: p_module => g_pkg || l_proc || ' end',
241: p_msg => 'End of Procedure '|| l_proc);
242: END IF;

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

263:
264: l_valid_setup := BIS_COLLECTION_UTILITIES.SETUP('BIL_BI_OPDTL_F');
265:
266: IF (not l_valid_setup) THEN
267: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
268: bil_bi_util_collection_pkg.writeLog(
269: p_log_level => fnd_log.LEVEL_EVENT,
270: p_module => g_pkg || l_proc ,
271: p_msg => 'BIS_COLLECTION_UTILITIES.SETUP failed' );

Line 268: bil_bi_util_collection_pkg.writeLog(

264: l_valid_setup := BIS_COLLECTION_UTILITIES.SETUP('BIL_BI_OPDTL_F');
265:
266: IF (not l_valid_setup) THEN
267: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
268: bil_bi_util_collection_pkg.writeLog(
269: p_log_level => fnd_log.LEVEL_EVENT,
270: p_module => g_pkg || l_proc ,
271: p_msg => 'BIS_COLLECTION_UTILITIES.SETUP failed' );
272: END IF;

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

272: END IF;
273: retcode := g_retcode;
274: return;
275: END IF;
276: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
277: bil_bi_util_collection_pkg.writeLog(
278: p_log_level => fnd_log.LEVEL_PROCEDURE,
279: p_module => g_pkg || l_proc || ' begin',
280: p_msg => 'Start of Procedure '|| l_proc);

Line 277: bil_bi_util_collection_pkg.writeLog(

273: retcode := g_retcode;
274: return;
275: END IF;
276: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
277: bil_bi_util_collection_pkg.writeLog(
278: p_log_level => fnd_log.LEVEL_PROCEDURE,
279: p_module => g_pkg || l_proc || ' begin',
280: p_msg => 'Start of Procedure '|| l_proc);
281: END IF;

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

298: /*
299: A generic line in the log file that requests the user to see the o/p file for
300: further info.
301: */
302: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
303: bil_bi_util_collection_pkg.writeLog
304: (
305: p_log_level => fnd_log.LEVEL_EVENT,
306: p_module => g_pkg || l_proc,

Line 303: bil_bi_util_collection_pkg.writeLog

299: A generic line in the log file that requests the user to see the o/p file for
300: further info.
301: */
302: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
303: bil_bi_util_collection_pkg.writeLog
304: (
305: p_log_level => fnd_log.LEVEL_EVENT,
306: p_module => g_pkg || l_proc,
307: p_msg =>

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

307: p_msg =>
308: ' If there have been errors, Please refer to the Concurrent program output file for more information '
309: );
310: END IF;
311: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
312: bil_bi_util_collection_pkg.writeLog(
313: p_log_level => fnd_log.LEVEL_PROCEDURE,
314: p_module => g_pkg || l_proc || ' end',
315: p_msg => 'End of Procedure '|| l_proc);

Line 312: bil_bi_util_collection_pkg.writeLog(

308: ' If there have been errors, Please refer to the Concurrent program output file for more information '
309: );
310: END IF;
311: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
312: bil_bi_util_collection_pkg.writeLog(
313: p_log_level => fnd_log.LEVEL_PROCEDURE,
314: p_module => g_pkg || l_proc || ' end',
315: p_msg => 'End of Procedure '|| l_proc);
316: END IF;

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

404: l_resume_flag:= 'N';
405:
406: G_Start_date := TO_DATE(p_start_date, l_date_format);
407:
408: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
409: bil_bi_util_collection_pkg.writeLog(
410: p_log_level => fnd_log.LEVEL_PROCEDURE,
411: p_module => g_pkg || l_proc || ' begin',
412: p_msg => 'Start of Procedure '|| l_proc);

Line 409: bil_bi_util_collection_pkg.writeLog(

405:
406: G_Start_date := TO_DATE(p_start_date, l_date_format);
407:
408: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
409: bil_bi_util_collection_pkg.writeLog(
410: p_log_level => fnd_log.LEVEL_PROCEDURE,
411: p_module => g_pkg || l_proc || ' begin',
412: p_msg => 'Start of Procedure '|| l_proc);
413: END IF;

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

434: INTO l_count
435: FROM BIL_BI_OPDTL_STG
436: WHERE rownum < 2;
437:
438: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
439: bil_bi_util_collection_pkg.writeLog(
440: p_log_level => fnd_log.LEVEL_EVENT,
441: p_module => g_pkg || l_proc ,
442: p_msg => 'No. of Rows in Staging are :'||l_count);

Line 439: bil_bi_util_collection_pkg.writeLog(

435: FROM BIL_BI_OPDTL_STG
436: WHERE rownum < 2;
437:
438: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
439: bil_bi_util_collection_pkg.writeLog(
440: p_log_level => fnd_log.LEVEL_EVENT,
441: p_module => g_pkg || l_proc ,
442: p_msg => 'No. of Rows in Staging are :'||l_count);
443: END IF;

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

451: x_valid_prod => l_valid_prod,
452: x_return_warn => l_return_warn_resume
453: );
454: IF ((l_valid_curr = 'Y') AND (l_valid_date = 'Y') AND (l_valid_prod='Y') ) THEN
455: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
456: bil_bi_util_collection_pkg.writeLog
457: (
458: p_log_level => fnd_log.LEVEL_EVENT,
459: p_module => g_pkg || l_proc ,

Line 456: bil_bi_util_collection_pkg.writeLog

452: x_return_warn => l_return_warn_resume
453: );
454: IF ((l_valid_curr = 'Y') AND (l_valid_date = 'Y') AND (l_valid_prod='Y') ) THEN
455: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
456: bil_bi_util_collection_pkg.writeLog
457: (
458: p_log_level => fnd_log.LEVEL_EVENT,
459: p_module => g_pkg || l_proc ,
460: p_msg =>'Summary Error Check Successful!'

Line 496: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_STG');

492:
493: ELSE
494: g_end_date := l_failure_date;
495: IF (l_valid_prod='N') THEN
496: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_STG');
497: END IF;
498: RAISE INVALID_SETUP;
499: END IF;
500: commit;

Line 504: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_STG');

500: commit;
501: END IF;
502: END IF;
503: END;
504: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_STG');
505: -----------------------------------------------------------------
506: -- If Truncate flag is 'Y' (Complete), then this program starts from the
507: -- beginning:
508: -- 1. Identify the lead_ids for which the process need to run.

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

513: -- 3. Merging summarized records into base summary table
514: ------------------------------------------------------------------
515: /*This is for complete refresh and if truncate_flag is yes*/
516:
517: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
518: bil_bi_util_collection_pkg.writeLog(
519: p_log_level => fnd_log.LEVEL_EVENT,
520: p_module => g_pkg || l_proc ,
521: p_msg => 'Default Parameter : Global Start Date ='||G_global_Start_date);

Line 518: bil_bi_util_collection_pkg.writeLog(

514: ------------------------------------------------------------------
515: /*This is for complete refresh and if truncate_flag is yes*/
516:
517: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
518: bil_bi_util_collection_pkg.writeLog(
519: p_log_level => fnd_log.LEVEL_EVENT,
520: p_module => g_pkg || l_proc ,
521: p_msg => 'Default Parameter : Global Start Date ='||G_global_Start_date);
522: END IF;

Line 525: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_F');

521: p_msg => 'Default Parameter : Global Start Date ='||G_global_Start_date);
522: END IF;
523: IF(g_refresh_flag = 'Y') THEN
524: BIS_COLLECTION_UTILITIES.deleteLogForObject ('BIL_BI_OPDTL_F');
525: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_F');
526:
527: IF p_start_date IS NOT NULL THEN
528: G_Start_date := TO_DATE(p_start_date, l_date_format);
529: IF(G_START_DATE <= sysdate) THEN

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

526:
527: IF p_start_date IS NOT NULL THEN
528: G_Start_date := TO_DATE(p_start_date, l_date_format);
529: IF(G_START_DATE <= sysdate) THEN
530: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
531: bil_bi_util_collection_pkg.writeLog(
532: p_log_level => fnd_log.LEVEL_EVENT,
533: p_module => g_pkg || l_proc ,
534: p_msg => 'User Parameter : Start Date = ' || g_start_date);

Line 531: bil_bi_util_collection_pkg.writeLog(

527: IF p_start_date IS NOT NULL THEN
528: G_Start_date := TO_DATE(p_start_date, l_date_format);
529: IF(G_START_DATE <= sysdate) THEN
530: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
531: bil_bi_util_collection_pkg.writeLog(
532: p_log_level => fnd_log.LEVEL_EVENT,
533: p_module => g_pkg || l_proc ,
534: p_msg => 'User Parameter : Start Date = ' || g_start_date);
535: END IF;

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

538: l_warn_parameter := 'Y';
539: G_Start_date := sysdate;
540: fnd_message.set_name('BIL','BIL_BI_DATE_PARAM_RESET');
541: fnd_message.set_token('RESET_DATE', to_char(sysdate, l_date_format));
542: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN
543: bil_bi_util_collection_pkg.writeLog(
544: p_log_level => fnd_log.LEVEL_ERROR,
545: p_module => g_pkg || l_proc ,
546: p_msg => fnd_message.get );

Line 543: bil_bi_util_collection_pkg.writeLog(

539: G_Start_date := sysdate;
540: fnd_message.set_name('BIL','BIL_BI_DATE_PARAM_RESET');
541: fnd_message.set_token('RESET_DATE', to_char(sysdate, l_date_format));
542: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN
543: bil_bi_util_collection_pkg.writeLog(
544: p_log_level => fnd_log.LEVEL_ERROR,
545: p_module => g_pkg || l_proc ,
546: p_msg => fnd_message.get );
547: END IF;

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

548: END IF;
549: ELSE
550: G_Start_date :=
551: fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F'));
552: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
553: bil_bi_util_collection_pkg.writeLog(
554: p_log_level => fnd_log.LEVEL_EVENT,
555: p_module => g_pkg || l_proc ,
556: p_msg => 'Default Parameter : Start Date ='||G_Start_date);

Line 553: bil_bi_util_collection_pkg.writeLog(

549: ELSE
550: G_Start_date :=
551: fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F'));
552: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
553: bil_bi_util_collection_pkg.writeLog(
554: p_log_level => fnd_log.LEVEL_EVENT,
555: p_module => g_pkg || l_proc ,
556: p_msg => 'Default Parameter : Start Date ='||G_Start_date);
557: END IF;

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

556: p_msg => 'Default Parameter : Start Date ='||G_Start_date);
557: END IF;
558: END IF;
559: G_END_DATE := TO_DATE(p_end_date, l_date_format);
560: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
561: bil_bi_util_collection_pkg.writeLog(
562: p_log_level => fnd_log.LEVEL_EVENT,
563: p_module => g_pkg || l_proc ,
564: p_msg => 'User Parameter : Purge = ' || g_refresh_flag);

Line 561: bil_bi_util_collection_pkg.writeLog(

557: END IF;
558: END IF;
559: G_END_DATE := TO_DATE(p_end_date, l_date_format);
560: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
561: bil_bi_util_collection_pkg.writeLog(
562: p_log_level => fnd_log.LEVEL_EVENT,
563: p_module => g_pkg || l_proc ,
564: p_msg => 'User Parameter : Purge = ' || g_refresh_flag);
565: END IF;

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

571: ELSE
572: G_Start_Date := TO_DATE(p_start_date, l_date_format);
573: END IF;
574: G_End_Date := TO_DATE(p_end_date, l_date_format);
575: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
576: bil_bi_util_collection_pkg.writeLog(
577: p_log_level => fnd_log.LEVEL_EVENT,
578: p_module => g_pkg || l_proc ,
579: p_msg => 'Assigning the start and end Dates:'||to_char(G_Start_Date,l_date_format)||

Line 576: bil_bi_util_collection_pkg.writeLog(

572: G_Start_Date := TO_DATE(p_start_date, l_date_format);
573: END IF;
574: G_End_Date := TO_DATE(p_end_date, l_date_format);
575: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
576: bil_bi_util_collection_pkg.writeLog(
577: p_log_level => fnd_log.LEVEL_EVENT,
578: p_module => g_pkg || l_proc ,
579: p_msg => 'Assigning the start and end Dates:'||to_char(G_Start_Date,l_date_format)||
580: ' -- '||to_char(G_End_Date, l_date_format));

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

586:
587: /* resume should called wrap up which should have set last_refresh_period */
588:
589: l_max_date := fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F'));
590: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
591: bil_bi_util_collection_pkg.writeLog(
592: p_log_level => fnd_log.LEVEL_EVENT,
593: p_module => g_pkg || l_proc ,
594: p_msg => 'L_max_date from bis_refresh_log:'||l_max_date);

Line 591: bil_bi_util_collection_pkg.writeLog(

587: /* resume should called wrap up which should have set last_refresh_period */
588:
589: l_max_date := fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F'));
590: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
591: bil_bi_util_collection_pkg.writeLog(
592: p_log_level => fnd_log.LEVEL_EVENT,
593: p_module => g_pkg || l_proc ,
594: p_msg => 'L_max_date from bis_refresh_log:'||l_max_date);
595: END IF;

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

596:
597: IF (p_start_date IS NOT NULL) THEN
598: G_Start_date := l_max_date;
599: IF (TO_DATE(p_start_date, l_date_format)= l_max_date) THEN
600: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
601: bil_bi_util_collection_pkg.writeLog(
602: p_log_level => fnd_log.LEVEL_EVENT,
603: p_module => g_pkg || l_proc ,
604: p_msg => 'User Parameter : Start Date = ' || g_start_date );

Line 601: bil_bi_util_collection_pkg.writeLog(

597: IF (p_start_date IS NOT NULL) THEN
598: G_Start_date := l_max_date;
599: IF (TO_DATE(p_start_date, l_date_format)= l_max_date) THEN
600: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
601: bil_bi_util_collection_pkg.writeLog(
602: p_log_level => fnd_log.LEVEL_EVENT,
603: p_module => g_pkg || l_proc ,
604: p_msg => 'User Parameter : Start Date = ' || g_start_date );
605: END IF;

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

606: ELSE
607: l_warn_parameter := 'Y';
608: fnd_message.set_name('BIL','BIL_BI_DATE_PARAM_RESET');
609: fnd_message.set_token('RESET_DATE', to_char(l_max_date, l_date_format));
610: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN
611: bil_bi_util_collection_pkg.writeLog(
612: p_log_level => fnd_log.LEVEL_ERROR,
613: p_module => g_pkg || l_proc ,
614: p_msg => fnd_message.get );

Line 611: bil_bi_util_collection_pkg.writeLog(

607: l_warn_parameter := 'Y';
608: fnd_message.set_name('BIL','BIL_BI_DATE_PARAM_RESET');
609: fnd_message.set_token('RESET_DATE', to_char(l_max_date, l_date_format));
610: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN
611: bil_bi_util_collection_pkg.writeLog(
612: p_log_level => fnd_log.LEVEL_ERROR,
613: p_module => g_pkg || l_proc ,
614: p_msg => fnd_message.get );
615: END IF;

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

615: END IF;
616: END IF;
617: ELSE
618: G_Start_date := l_max_date;
619: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
620: bil_bi_util_collection_pkg.writeLog(
621: p_log_level => fnd_log.LEVEL_EVENT,
622: p_module => g_pkg || l_proc ,
623: p_msg => 'Default Parameter : Start Date ='||G_Start_date);

Line 620: bil_bi_util_collection_pkg.writeLog(

616: END IF;
617: ELSE
618: G_Start_date := l_max_date;
619: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
620: bil_bi_util_collection_pkg.writeLog(
621: p_log_level => fnd_log.LEVEL_EVENT,
622: p_module => g_pkg || l_proc ,
623: p_msg => 'Default Parameter : Start Date ='||G_Start_date);
624: END IF;

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

623: p_msg => 'Default Parameter : Start Date ='||G_Start_date);
624: END IF;
625: END IF;
626: G_END_DATE := TO_DATE(p_end_date, l_date_format);
627: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
628: bil_bi_util_collection_pkg.writeLog(
629: p_log_level => fnd_log.LEVEL_EVENT,
630: p_module => g_pkg || l_proc ,
631: p_msg => 'User Parameter : Purge = ' || g_refresh_flag );

Line 628: bil_bi_util_collection_pkg.writeLog(

624: END IF;
625: END IF;
626: G_END_DATE := TO_DATE(p_end_date, l_date_format);
627: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
628: bil_bi_util_collection_pkg.writeLog(
629: p_log_level => fnd_log.LEVEL_EVENT,
630: p_module => g_pkg || l_proc ,
631: p_msg => 'User Parameter : Purge = ' || g_refresh_flag );
632: END IF;

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

662: -- Summary_err_check routine to check for any Invalid currencies
663: -- and invalid date ranges in staging table (BIL_BI_OPDTL_STG).
664: -----------------------------------------------------------------
665: g_phase:= 'Summarization Error Check';
666: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
667: bil_bi_util_collection_pkg.writeLog(
668: p_log_level => fnd_log.LEVEL_EVENT,
669: p_module => g_pkg || l_proc ,
670: p_msg => g_phase);

Line 667: bil_bi_util_collection_pkg.writeLog(

663: -- and invalid date ranges in staging table (BIL_BI_OPDTL_STG).
664: -----------------------------------------------------------------
665: g_phase:= 'Summarization Error Check';
666: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
667: bil_bi_util_collection_pkg.writeLog(
668: p_log_level => fnd_log.LEVEL_EVENT,
669: p_module => g_pkg || l_proc ,
670: p_msg => g_phase);
671: END IF;

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

675: x_return_warn => l_return_warn);
676:
677: IF ((l_valid_curr = 'Y') AND (l_valid_date = 'Y') AND (l_valid_prod='Y') ) THEN
678: g_phase := 'Merging records into base summary table...';
679: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
680: bil_bi_util_collection_pkg.writeLog(
681: p_log_level => fnd_log.LEVEL_EVENT,
682: p_module => g_pkg || l_proc ,
683: p_msg => g_phase);

Line 680: bil_bi_util_collection_pkg.writeLog(

676:
677: IF ((l_valid_curr = 'Y') AND (l_valid_date = 'Y') AND (l_valid_prod='Y') ) THEN
678: g_phase := 'Merging records into base summary table...';
679: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
680: bil_bi_util_collection_pkg.writeLog(
681: p_log_level => fnd_log.LEVEL_EVENT,
682: p_module => g_pkg || l_proc ,
683: p_msg => g_phase);
684: END IF;

Line 685: bil_bi_util_collection_pkg.analyze_table('BIL_BI_OPDTL_STG',TRUE, 10, 'GLOBAL');

681: p_log_level => fnd_log.LEVEL_EVENT,
682: p_module => g_pkg || l_proc ,
683: p_msg => g_phase);
684: END IF;
685: bil_bi_util_collection_pkg.analyze_table('BIL_BI_OPDTL_STG',TRUE, 10, 'GLOBAL');
686:
687: IF ((g_load_flag = 'I') OR (g_refresh_flag = 'N')) THEN
688: Insert_Into_Sumry_Incr;
689: ELSE

Line 700: bil_bi_util_collection_pkg.analyze_table('BIL_BI_OPDTL_F',TRUE, 10, 'GLOBAL');

696: G_status := TRUE;
697: Clean_up;
698: IF (G_refresh_flag = 'Y') THEN
699: --- why 99 percent
700: bil_bi_util_collection_pkg.analyze_table('BIL_BI_OPDTL_F',TRUE, 10, 'GLOBAL');
701: END IF;
702:
703:
704:

Line 710: bil_bi_util_collection_pkg.writeLog(

706: retcode := 1;
707: ELSE
708: retcode := 0;
709: END IF;
710: bil_bi_util_collection_pkg.writeLog(
711: p_log_level => fnd_log.LEVEL_EVENT,
712: p_module => g_pkg || l_proc || ' proc_event',
713: p_msg => 'Procedure Completed Successfully',
714: p_force_log => TRUE

Line 719: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_STG');

715: );
716: return;
717: ELSE
718: IF (l_valid_prod='N') THEN
719: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_STG');
720: END IF;
721: RAISE INVALID_SETUP;
722: END IF;
723: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

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

719: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_STG');
720: END IF;
721: RAISE INVALID_SETUP;
722: END IF;
723: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
724: bil_bi_util_collection_pkg.writeLog(
725: p_log_level => fnd_log.LEVEL_PROCEDURE,
726: p_module => g_pkg || l_proc || ' end',
727: p_msg => 'End of Procedure '|| l_proc);

Line 724: bil_bi_util_collection_pkg.writeLog(

720: END IF;
721: RAISE INVALID_SETUP;
722: END IF;
723: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
724: bil_bi_util_collection_pkg.writeLog(
725: p_log_level => fnd_log.LEVEL_PROCEDURE,
726: p_module => g_pkg || l_proc || ' end',
727: p_msg => 'End of Procedure '|| l_proc);
728: END IF;

Line 749: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_EVENT,

745: ROLLBACK;
746: clean_up;
747: ---????? detail message output by the validation routines, this is for log
748:
749: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_EVENT,
750: p_module => g_pkg || l_proc || ' proc_error',
751: p_msg => 'The Time, Currency or Product Dimensions are not properly setup',
752: p_force_log => TRUE);
753:

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

762: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
763: fnd_message.set_token('ERRNO' ,SQLCODE);
764: fnd_message.set_token('REASON' ,SQLERRM);
765: fnd_message.set_token('ROUTINE' , l_proc);
766: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
767: p_module => g_pkg || l_proc || ' proc_error',
768: p_msg => fnd_message.get,
769: p_force_log => TRUE);
770: retcode := g_retcode;

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

788:
789: l_proc VARCHAR2(100);
790: BEGIN
791: l_proc := 'Report_Missing_Rates';
792: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
793: bil_bi_util_collection_pkg.writeLog(
794: p_log_level => fnd_log.LEVEL_PROCEDURE,
795: p_module => g_pkg || l_proc || ' begin',
796: p_msg => 'Start of Procedure '|| l_proc);

Line 793: bil_bi_util_collection_pkg.writeLog(

789: l_proc VARCHAR2(100);
790: BEGIN
791: l_proc := 'Report_Missing_Rates';
792: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
793: bil_bi_util_collection_pkg.writeLog(
794: p_log_level => fnd_log.LEVEL_PROCEDURE,
795: p_module => g_pkg || l_proc || ' begin',
796: p_msg => 'Start of Procedure '|| l_proc);
797: END IF;

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

815: rate_record.txn_date);
816: END IF;
817: END LOOP;
818:
819: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
820: bil_bi_util_collection_pkg.writeLog(
821: p_log_level => fnd_log.LEVEL_PROCEDURE,
822: p_module => g_pkg || l_proc || ' end',
823: p_msg => 'End of Procedure '|| l_proc);

Line 820: bil_bi_util_collection_pkg.writeLog(

816: END IF;
817: END LOOP;
818:
819: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
820: bil_bi_util_collection_pkg.writeLog(
821: p_log_level => fnd_log.LEVEL_PROCEDURE,
822: p_module => g_pkg || l_proc || ' end',
823: p_msg => 'End of Procedure '|| l_proc);
824: END IF;

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

828: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
829: fnd_message.set_token('ERRNO' ,SQLCODE);
830: fnd_message.set_token('REASON' ,SQLERRM);
831: fnd_message.set_token('ROUTINE' , l_proc);
832: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
833: p_module => g_pkg || l_proc || ' proc_error',
834: p_msg => fnd_message.get,
835: p_force_log => TRUE);
836: raise;

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

845: l_sysdate DATE;
846: l_proc VARCHAR2(100);
847: BEGIN
848: l_proc := 'Clean_Up';
849: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
850: bil_bi_util_collection_pkg.writeLog(
851: p_log_level => fnd_log.LEVEL_PROCEDURE,
852: p_module => g_pkg || l_proc || ' begin',
853: p_msg => 'Start of Procedure '|| l_proc);

Line 850: bil_bi_util_collection_pkg.writeLog(

846: l_proc VARCHAR2(100);
847: BEGIN
848: l_proc := 'Clean_Up';
849: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
850: bil_bi_util_collection_pkg.writeLog(
851: p_log_level => fnd_log.LEVEL_PROCEDURE,
852: p_module => g_pkg || l_proc || ' begin',
853: p_msg => 'Start of Procedure '|| l_proc);
854: END IF;

Line 856: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_EVENT,

852: p_module => g_pkg || l_proc || ' begin',
853: p_msg => 'Start of Procedure '|| l_proc);
854: END IF;
855: IF (G_status) THEN
856: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_EVENT,
857: p_module => g_pkg || l_proc || ' proc_event',
858: p_msg => 'Program finished normally, truncating staging tables.',
859: p_force_log => TRUE);
860:

Line 861: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_STG');

857: p_module => g_pkg || l_proc || ' proc_event',
858: p_msg => 'Program finished normally, truncating staging tables.',
859: p_force_log => TRUE);
860:
861: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_STG');
862: null;
863: ELSIF (g_phase = 'Other') THEN
864: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_EVENT,
865: p_module => g_pkg || l_proc || ' proc_event',

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

860:
861: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_STG');
862: null;
863: ELSIF (g_phase = 'Other') THEN
864: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_EVENT,
865: p_module => g_pkg || l_proc || ' proc_event',
866: p_msg => 'Program finished with unhandled error, truncating staging tables.',
867: p_force_log => TRUE);
868: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_STG');

Line 868: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_STG');

864: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_EVENT,
865: p_module => g_pkg || l_proc || ' proc_event',
866: p_msg => 'Program finished with unhandled error, truncating staging tables.',
867: p_force_log => TRUE);
868: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_STG');
869: END IF;
870: l_sysdate := SYSDATE;
871: /*
872: Added commit before wrapup and setup procedures are called

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

879: null,
880: G_Start_Date,
881: G_end_date);
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 || ' end',
887: p_msg => 'End of Procedure '|| l_proc);

Line 884: bil_bi_util_collection_pkg.writeLog(

880: G_Start_Date,
881: G_end_date);
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 || ' end',
887: p_msg => 'End of Procedure '|| l_proc);
888: END IF;

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

894: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
895: fnd_message.set_token('ERRNO' ,SQLCODE);
896: fnd_message.set_token('REASON' ,SQLERRM);
897: fnd_message.set_token('ROUTINE' , l_proc);
898: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
899: p_module => g_pkg || l_proc || ' proc_error',
900: p_msg => fnd_message.get,
901: p_force_log => TRUE);
902: RAISE;

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

928: Added commit before wrapup and setup procedures are called
929: Commented commit in write_log procedure. This is done to avoid
930: hanging of incremental program when ran with multiple workers.
931: */
932: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
933: bil_bi_util_collection_pkg.writeLog(
934: p_log_level => fnd_log.LEVEL_PROCEDURE,
935: p_module => g_pkg || l_proc || ' begin',
936: p_msg => 'Start of Procedure '|| l_proc);

Line 933: bil_bi_util_collection_pkg.writeLog(

929: Commented commit in write_log procedure. This is done to avoid
930: hanging of incremental program when ran with multiple workers.
931: */
932: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
933: bil_bi_util_collection_pkg.writeLog(
934: p_log_level => fnd_log.LEVEL_PROCEDURE,
935: p_module => g_pkg || l_proc || ' begin',
936: p_msg => 'Start of Procedure '|| l_proc);
937: END IF;

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

942: Setup_Validation(l_setup_status);
943: IF (NOT l_setup_status) THEN
944: --- ???
945: g_retcode := 2;
946: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
947: bil_bi_util_collection_pkg.writeLog(
948: p_log_level => fnd_log.LEVEL_EVENT,
949: p_module => g_pkg || l_proc ,
950: p_msg => 'Setup Validition failed' );

Line 947: bil_bi_util_collection_pkg.writeLog(

943: IF (NOT l_setup_status) THEN
944: --- ???
945: g_retcode := 2;
946: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
947: bil_bi_util_collection_pkg.writeLog(
948: p_log_level => fnd_log.LEVEL_EVENT,
949: p_module => g_pkg || l_proc ,
950: p_msg => 'Setup Validition failed' );
951: END IF;

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

950: p_msg => 'Setup Validition failed' );
951: END IF;
952: RAISE G_SETUP_VAL_ERROR;
953: ELSE
954: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
955: bil_bi_util_collection_pkg.writeLog(
956: p_log_level => fnd_log.LEVEL_EVENT,
957: p_module => g_pkg || l_proc ,
958: p_msg => 'Setup Validition success' );

Line 955: bil_bi_util_collection_pkg.writeLog(

951: END IF;
952: RAISE G_SETUP_VAL_ERROR;
953: ELSE
954: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
955: bil_bi_util_collection_pkg.writeLog(
956: p_log_level => fnd_log.LEVEL_EVENT,
957: p_module => g_pkg || l_proc ,
958: p_msg => 'Setup Validition success' );
959: END IF;

Line 963: g_bil_schema := bil_bi_util_collection_pkg.get_schema_name('BIL');

959: END IF;
960:
961: END IF;
962: g_phase := 'Find BIL schema';
963: g_bil_schema := bil_bi_util_collection_pkg.get_schema_name('BIL');
964:
965: -- no user id check for now
966: G_request_id := FND_GLOBAL.CONC_REQUEST_ID();
967: G_appl_id := FND_GLOBAL.PROG_APPL_ID();

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

978: -- Get secondary currency code and rate type
979: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
980: g_sec_rate_type := bis_common_parameters.get_secondary_rate_type;
981:
982: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
983: bil_bi_util_collection_pkg.writeLog(
984: p_log_level => fnd_log.LEVEL_EVENT,
985: p_module => g_pkg || l_proc || 'Primary Currency',
986: p_msg => g_prim_currency);

Line 983: bil_bi_util_collection_pkg.writeLog(

979: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
980: g_sec_rate_type := bis_common_parameters.get_secondary_rate_type;
981:
982: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
983: bil_bi_util_collection_pkg.writeLog(
984: p_log_level => fnd_log.LEVEL_EVENT,
985: p_module => g_pkg || l_proc || 'Primary Currency',
986: p_msg => g_prim_currency);
987: END IF;

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

984: p_log_level => fnd_log.LEVEL_EVENT,
985: p_module => g_pkg || l_proc || 'Primary Currency',
986: p_msg => g_prim_currency);
987: END IF;
988: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
989: bil_bi_util_collection_pkg.writeLog(
990: p_log_level => fnd_log.LEVEL_EVENT,
991: p_module => g_pkg || l_proc || 'Primary Rate Type',
992: p_msg => g_prim_rate_type);

Line 989: bil_bi_util_collection_pkg.writeLog(

985: p_module => g_pkg || l_proc || 'Primary Currency',
986: p_msg => g_prim_currency);
987: END IF;
988: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
989: bil_bi_util_collection_pkg.writeLog(
990: p_log_level => fnd_log.LEVEL_EVENT,
991: p_module => g_pkg || l_proc || 'Primary Rate Type',
992: p_msg => g_prim_rate_type);
993: END IF;

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

990: p_log_level => fnd_log.LEVEL_EVENT,
991: p_module => g_pkg || l_proc || 'Primary Rate Type',
992: p_msg => g_prim_rate_type);
993: END IF;
994: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
995: bil_bi_util_collection_pkg.writeLog(
996: p_log_level => fnd_log.LEVEL_EVENT,
997: p_module => g_pkg || l_proc || 'Secondary Currency',
998: p_msg => g_sec_currency);

Line 995: bil_bi_util_collection_pkg.writeLog(

991: p_module => g_pkg || l_proc || 'Primary Rate Type',
992: p_msg => g_prim_rate_type);
993: END IF;
994: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
995: bil_bi_util_collection_pkg.writeLog(
996: p_log_level => fnd_log.LEVEL_EVENT,
997: p_module => g_pkg || l_proc || 'Secondary Currency',
998: p_msg => g_sec_currency);
999: END IF;

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

996: p_log_level => fnd_log.LEVEL_EVENT,
997: p_module => g_pkg || l_proc || 'Secondary Currency',
998: p_msg => g_sec_currency);
999: END IF;
1000: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1001: bil_bi_util_collection_pkg.writeLog(
1002: p_log_level => fnd_log.LEVEL_EVENT,
1003: p_module => g_pkg || l_proc || 'Secondary Rate Type',
1004: p_msg => g_sec_rate_type);

Line 1001: bil_bi_util_collection_pkg.writeLog(

997: p_module => g_pkg || l_proc || 'Secondary Currency',
998: p_msg => g_sec_currency);
999: END IF;
1000: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1001: bil_bi_util_collection_pkg.writeLog(
1002: p_log_level => fnd_log.LEVEL_EVENT,
1003: p_module => g_pkg || l_proc || 'Secondary Rate Type',
1004: p_msg => g_sec_rate_type);
1005: END IF;

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

1002: p_log_level => fnd_log.LEVEL_EVENT,
1003: p_module => g_pkg || l_proc || 'Secondary Rate Type',
1004: p_msg => g_sec_rate_type);
1005: END IF;
1006: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1007: bil_bi_util_collection_pkg.writeLog(
1008: p_log_level => fnd_log.LEVEL_PROCEDURE,
1009: p_module => g_pkg || l_proc || ' end',
1010: p_msg => 'End of Procedure '|| l_proc);

Line 1007: bil_bi_util_collection_pkg.writeLog(

1003: p_module => g_pkg || l_proc || 'Secondary Rate Type',
1004: p_msg => g_sec_rate_type);
1005: END IF;
1006: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1007: bil_bi_util_collection_pkg.writeLog(
1008: p_log_level => fnd_log.LEVEL_PROCEDURE,
1009: p_module => g_pkg || l_proc || ' end',
1010: p_msg => 'End of Procedure '|| l_proc);
1011: END IF;

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

1061: l_limit_date := add_months(trunc(g_program_start),24);
1062: l_proc := 'Summary_Err_Check';
1063:
1064:
1065: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1066: bil_bi_util_collection_pkg.writeLog(
1067: p_log_level => fnd_log.LEVEL_PROCEDURE,
1068: p_module => g_pkg || l_proc || ' begin',
1069: p_msg => 'Start of Procedure '|| l_proc);

Line 1066: bil_bi_util_collection_pkg.writeLog(

1062: l_proc := 'Summary_Err_Check';
1063:
1064:
1065: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1066: bil_bi_util_collection_pkg.writeLog(
1067: p_log_level => fnd_log.LEVEL_PROCEDURE,
1068: p_module => g_pkg || l_proc || ' begin',
1069: p_msg => 'Start of Procedure '|| l_proc);
1070: END IF;

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

1068: p_module => g_pkg || l_proc || ' begin',
1069: p_msg => 'Start of Procedure '|| l_proc);
1070: END IF;
1071: g_phase := 'update rates';
1072: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1073: bil_bi_util_collection_pkg.writeLog(
1074: p_log_level => fnd_log.LEVEL_EVENT,
1075: p_module => g_pkg || l_proc ,
1076: p_msg => g_phase);

Line 1073: bil_bi_util_collection_pkg.writeLog(

1069: p_msg => 'Start of Procedure '|| l_proc);
1070: END IF;
1071: g_phase := 'update rates';
1072: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1073: bil_bi_util_collection_pkg.writeLog(
1074: p_log_level => fnd_log.LEVEL_EVENT,
1075: p_module => g_pkg || l_proc ,
1076: p_msg => g_phase);
1077: END IF;

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

1113: END IF;
1114: -- need this commit for the rollup not to roll back all the currencys, doesn't really matter anyway
1115: commit;
1116:
1117: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1118: bil_bi_util_collection_pkg.writeLog(
1119: p_log_level => fnd_log.LEVEL_EVENT,
1120: p_module => g_pkg || l_proc ,
1121: p_msg => 'Updated rates for '|| sql%rowcount || ' rows');

Line 1118: bil_bi_util_collection_pkg.writeLog(

1114: -- need this commit for the rollup not to roll back all the currencys, doesn't really matter anyway
1115: commit;
1116:
1117: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1118: bil_bi_util_collection_pkg.writeLog(
1119: p_log_level => fnd_log.LEVEL_EVENT,
1120: p_module => g_pkg || l_proc ,
1121: p_msg => 'Updated rates for '|| sql%rowcount || ' rows');
1122: END IF;

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

1139:
1140: --l_conv_rate_cnt := 0; -- only for GSIDBI testing
1141:
1142: IF (l_conv_rate_cnt >0) THEN
1143: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1144: bil_bi_util_collection_pkg.writeLog(
1145: p_log_level => fnd_log.LEVEL_EVENT,
1146: p_module => g_pkg || l_proc,
1147: p_msg => 'Missing currency conversion rates found, program will exit with warning status. '

Line 1144: bil_bi_util_collection_pkg.writeLog(

1140: --l_conv_rate_cnt := 0; -- only for GSIDBI testing
1141:
1142: IF (l_conv_rate_cnt >0) THEN
1143: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1144: bil_bi_util_collection_pkg.writeLog(
1145: p_log_level => fnd_log.LEVEL_EVENT,
1146: p_module => g_pkg || l_proc,
1147: p_msg => 'Missing currency conversion rates found, program will exit with warning status. '
1148: ||'Please fix the missing conversion rates');

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

1157: x_valid_curr := 'Y';
1158: END IF;
1159:
1160: g_phase := 'Checking for Time dimension';
1161: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1162: bil_bi_util_collection_pkg.writeLog(
1163: p_log_level => fnd_log.LEVEL_EVENT,
1164: p_module => g_pkg || l_proc ,
1165: p_msg => g_phase);

Line 1162: bil_bi_util_collection_pkg.writeLog(

1158: END IF;
1159:
1160: g_phase := 'Checking for Time dimension';
1161: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1162: bil_bi_util_collection_pkg.writeLog(
1163: p_log_level => fnd_log.LEVEL_EVENT,
1164: p_module => g_pkg || l_proc ,
1165: p_msg => g_phase);
1166: END IF;

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

1203:
1204: FII_TIME_API.check_missing_date (l_stg_min_dt,l_stg_max_dt,l_has_missing_date);
1205:
1206: IF (l_has_missing_date) THEN
1207: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1208: bil_bi_util_collection_pkg.writeLog(
1209: p_log_level => fnd_log.LEVEL_EVENT,
1210: p_module => g_pkg || l_proc ,
1211: p_msg => 'Time Dimension is not fully populated. '||

Line 1208: bil_bi_util_collection_pkg.writeLog(

1204: FII_TIME_API.check_missing_date (l_stg_min_dt,l_stg_max_dt,l_has_missing_date);
1205:
1206: IF (l_has_missing_date) THEN
1207: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1208: bil_bi_util_collection_pkg.writeLog(
1209: p_log_level => fnd_log.LEVEL_EVENT,
1210: p_module => g_pkg || l_proc ,
1211: p_msg => 'Time Dimension is not fully populated. '||
1212: 'Please populate Time dimension to cover the date range you are collecting');

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

1227: l_number_of_rows :=l_number_of_rows + 1;
1228: IF(l_number_of_rows=1) THEN
1229: -- print header
1230: fnd_message.set_name('BIL','BIL_BI_OPTY_PER_ERR_HDR');
1231: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
1232: p_module => g_pkg || l_proc || ' proc_error',
1233: p_msg => fnd_message.get,
1234: p_force_log => TRUE);
1235: END IF;

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

1236: -- print detail
1237: fnd_message.set_name('BIL','BIL_BI_OPTY_PER_ERR_DTL');
1238: fnd_message.set_token('OPPNUM', l_lead_num);
1239: fnd_message.set_token('CLOSEDATE', to_char(l_eff_date));
1240: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
1241: p_module => g_pkg || l_proc || ' proc_error',
1242: p_msg => fnd_message.get,
1243: p_force_log => TRUE);
1244:

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

1261:
1262: IF(l_number_of_rows=1) THEN
1263: -- print header
1264: fnd_message.set_name('BIL','BIL_BI_ITEM_PROD_ERR_HDR');
1265: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
1266: p_module => g_pkg || l_proc || ' proc_error',
1267: --p_msg => 'The following opportunities have null product and product category, they are not collected',
1268: p_msg => fnd_message.get,
1269: p_force_log => TRUE);

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

1272: -- print detail
1273:
1274: fnd_message.set_name('BIL','BIL_BI_ITEM_PROD_ERR_DTL');
1275: fnd_message.set_token('OPPNUM', l_lead_num);
1276: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
1277: p_module => g_pkg || l_proc || ' proc_error',
1278: p_msg => fnd_message.get,
1279: p_force_log => TRUE);
1280:

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

1288:
1289: --(item_id = -1 and nvl(product_category_id,-1)=-1) or valid_flag = 'F';
1290:
1291: /*
1292: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1293: bil_bi_util_collection_pkg.writeLog(
1294: p_log_level => fnd_log.LEVEL_EVENT,
1295: p_module => g_pkg || l_proc ,
1296: p_msg => 'Deleted'|| sql%rowcount || ' rows due to bad item/prod or close date');

Line 1293: bil_bi_util_collection_pkg.writeLog(

1289: --(item_id = -1 and nvl(product_category_id,-1)=-1) or valid_flag = 'F';
1290:
1291: /*
1292: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1293: bil_bi_util_collection_pkg.writeLog(
1294: p_log_level => fnd_log.LEVEL_EVENT,
1295: p_module => g_pkg || l_proc ,
1296: p_msg => 'Deleted'|| sql%rowcount || ' rows due to bad item/prod or close date');
1297: END IF;

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

1303: END IF;
1304:
1305: x_return_warn := l_warn;
1306:
1307: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1308: bil_bi_util_collection_pkg.writeLog(
1309: p_log_level => fnd_log.LEVEL_PROCEDURE,
1310: p_module => g_pkg || l_proc || ' end',
1311: p_msg => 'End of Procedure '|| l_proc);

Line 1308: bil_bi_util_collection_pkg.writeLog(

1304:
1305: x_return_warn := l_warn;
1306:
1307: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1308: bil_bi_util_collection_pkg.writeLog(
1309: p_log_level => fnd_log.LEVEL_PROCEDURE,
1310: p_module => g_pkg || l_proc || ' end',
1311: p_msg => 'End of Procedure '|| l_proc);
1312: END IF;

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

1316: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1317: fnd_message.set_token('ERRNO' ,SQLCODE);
1318: fnd_message.set_token('REASON' ,SQLERRM);
1319: fnd_message.set_token('ROUTINE' , l_proc);
1320: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1321: p_module => g_pkg || l_proc || ' proc_error',
1322: p_msg => fnd_message.get,
1323: p_force_log => TRUE);
1324: Raise;

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

1348: l_int_date_format :='DD/MM/YYYY HH24:MI:SS';
1349: l_proc := 'Ins_New_Chngd_Oppty_Inc';
1350: l_limit_date := add_months(trunc(g_program_start),24);
1351:
1352: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1353: bil_bi_util_collection_pkg.writeLog(
1354: p_log_level => fnd_log.LEVEL_PROCEDURE,
1355: p_module => g_pkg || l_proc || ' begin',
1356: p_msg => 'Start of Procedure '|| l_proc);

Line 1353: bil_bi_util_collection_pkg.writeLog(

1349: l_proc := 'Ins_New_Chngd_Oppty_Inc';
1350: l_limit_date := add_months(trunc(g_program_start),24);
1351:
1352: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1353: bil_bi_util_collection_pkg.writeLog(
1354: p_log_level => fnd_log.LEVEL_PROCEDURE,
1355: p_module => g_pkg || l_proc || ' begin',
1356: p_msg => 'Start of Procedure '|| l_proc);
1357: END IF;

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

1357: END IF;
1358:
1359: l_start_date := fnd_date.displaydt_to_date(get_first_success_period('BIL_BI_OPDTL_F'));
1360:
1361: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1362: bil_bi_util_collection_pkg.writeLog(
1363: p_log_level => fnd_log.LEVEL_EVENT,
1364: p_module => g_pkg || l_proc ,
1365: p_msg => 'Close date collected is greater or equal to :'

Line 1362: bil_bi_util_collection_pkg.writeLog(

1358:
1359: l_start_date := fnd_date.displaydt_to_date(get_first_success_period('BIL_BI_OPDTL_F'));
1360:
1361: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1362: bil_bi_util_collection_pkg.writeLog(
1363: p_log_level => fnd_log.LEVEL_EVENT,
1364: p_module => g_pkg || l_proc ,
1365: p_msg => 'Close date collected is greater or equal to :'
1366: || TO_CHAR(l_start_date,'DD-MON-YYYY HH24:MI:SS') );

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

1512: ,TRUNC(denorm.forecast_date);
1513:
1514: l_cnt:=sql%rowcount;
1515:
1516: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1517: bil_bi_util_collection_pkg.writeLog(
1518: p_log_level => fnd_log.LEVEL_EVENT,
1519: p_module => g_pkg || l_proc ,
1520: p_msg => 'Start and End Dates for which Ids are collected:'||

Line 1517: bil_bi_util_collection_pkg.writeLog(

1513:
1514: l_cnt:=sql%rowcount;
1515:
1516: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1517: bil_bi_util_collection_pkg.writeLog(
1518: p_log_level => fnd_log.LEVEL_EVENT,
1519: p_module => g_pkg || l_proc ,
1520: p_msg => 'Start and End Dates for which Ids are collected:'||
1521: TO_CHAR(G_Start_Date,'DD-MON-YYYY HH24:MI:SS') ||

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

1520: p_msg => 'Start and End Dates for which Ids are collected:'||
1521: TO_CHAR(G_Start_Date,'DD-MON-YYYY HH24:MI:SS') ||
1522: ' and G_end_date:'|| TO_CHAR(G_end_date,'DD-MON-YYYY HH24:MI:SS'));
1523: END IF;
1524: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1525: bil_bi_util_collection_pkg.writeLog(
1526: p_log_level => fnd_log.LEVEL_EVENT,
1527: p_module => g_pkg || l_proc ,
1528: p_msg => 'Rows Inserted into staging table are: '||l_cnt);

Line 1525: bil_bi_util_collection_pkg.writeLog(

1521: TO_CHAR(G_Start_Date,'DD-MON-YYYY HH24:MI:SS') ||
1522: ' and G_end_date:'|| TO_CHAR(G_end_date,'DD-MON-YYYY HH24:MI:SS'));
1523: END IF;
1524: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1525: bil_bi_util_collection_pkg.writeLog(
1526: p_log_level => fnd_log.LEVEL_EVENT,
1527: p_module => g_pkg || l_proc ,
1528: p_msg => 'Rows Inserted into staging table are: '||l_cnt);
1529: END IF;

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

1537:
1538: dbms_output.put_line('deleted these many rows in ins_new_chgd_opty_incr procedure from fact :'||l_cnt);*/
1539:
1540: COMMIT;
1541: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1542: bil_bi_util_collection_pkg.writeLog(
1543: p_log_level => fnd_log.LEVEL_PROCEDURE,
1544: p_module => g_pkg || l_proc || ' end',
1545: p_msg => 'End of Procedure '|| l_proc);

Line 1542: bil_bi_util_collection_pkg.writeLog(

1538: dbms_output.put_line('deleted these many rows in ins_new_chgd_opty_incr procedure from fact :'||l_cnt);*/
1539:
1540: COMMIT;
1541: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1542: bil_bi_util_collection_pkg.writeLog(
1543: p_log_level => fnd_log.LEVEL_PROCEDURE,
1544: p_module => g_pkg || l_proc || ' end',
1545: p_msg => 'End of Procedure '|| l_proc);
1546: END IF;

Line 1555: bil_bi_util_collection_pkg.writeLog(

1551: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1552: fnd_message.set_token('ERRNO' ,SQLCODE);
1553: fnd_message.set_token('REASON' ,SQLERRM);
1554: fnd_message.set_token('ROUTINE' , l_proc);
1555: bil_bi_util_collection_pkg.writeLog(
1556: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1557: p_module => g_pkg || l_proc || ' proc_error',
1558: p_msg => fnd_message.get,
1559: p_force_log => TRUE);

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

1570: l_proc := 'Ins_New_Chngd_Oppty_Init';
1571: l_count := 0;
1572: l_limit_date := add_months(trunc(g_program_start),24);
1573:
1574: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1575: bil_bi_util_collection_pkg.writeLog(
1576: p_log_level => fnd_log.LEVEL_PROCEDURE,
1577: p_module => g_pkg || l_proc || ' begin',
1578: p_msg => 'Start of Procedure '|| l_proc);

Line 1575: bil_bi_util_collection_pkg.writeLog(

1571: l_count := 0;
1572: l_limit_date := add_months(trunc(g_program_start),24);
1573:
1574: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1575: bil_bi_util_collection_pkg.writeLog(
1576: p_log_level => fnd_log.LEVEL_PROCEDURE,
1577: p_module => g_pkg || l_proc || ' begin',
1578: p_msg => 'Start of Procedure '|| l_proc);
1579: END IF;

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

1578: p_msg => 'Start of Procedure '|| l_proc);
1579: END IF;
1580:
1581:
1582: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1583: bil_bi_util_collection_pkg.writeLog(
1584: p_log_level => fnd_log.LEVEL_EVENT,
1585: p_module => g_pkg || l_proc ,
1586: p_msg => 'Start and End Dates for which Ids are collected:'||

Line 1583: bil_bi_util_collection_pkg.writeLog(

1579: END IF;
1580:
1581:
1582: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1583: bil_bi_util_collection_pkg.writeLog(
1584: p_log_level => fnd_log.LEVEL_EVENT,
1585: p_module => g_pkg || l_proc ,
1586: p_msg => 'Start and End Dates for which Ids are collected:'||
1587: TO_CHAR(G_Start_Date,'DD-MON-YYYY HH24:MI:SS') ||

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

1717: ,denorm.sales_stage_id
1718: ,denorm.status_code
1719: ,TRUNC(denorm.forecast_date);
1720:
1721: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1722: bil_bi_util_collection_pkg.writeLog(
1723: p_log_level => fnd_log.LEVEL_EVENT,
1724: p_module => g_pkg || l_proc ,
1725: p_msg => 'Rows Inserted into staging table are: '||sql%rowcount);

Line 1722: bil_bi_util_collection_pkg.writeLog(

1718: ,denorm.status_code
1719: ,TRUNC(denorm.forecast_date);
1720:
1721: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1722: bil_bi_util_collection_pkg.writeLog(
1723: p_log_level => fnd_log.LEVEL_EVENT,
1724: p_module => g_pkg || l_proc ,
1725: p_msg => 'Rows Inserted into staging table are: '||sql%rowcount);
1726: END IF;

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

1726: END IF;
1727:
1728: COMMIT;
1729:
1730: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1731: bil_bi_util_collection_pkg.writeLog(
1732: p_log_level => fnd_log.LEVEL_PROCEDURE,
1733: p_module => g_pkg || l_proc || ' end',
1734: p_msg => 'End of Procedure '|| l_proc);

Line 1731: bil_bi_util_collection_pkg.writeLog(

1727:
1728: COMMIT;
1729:
1730: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1731: bil_bi_util_collection_pkg.writeLog(
1732: p_log_level => fnd_log.LEVEL_PROCEDURE,
1733: p_module => g_pkg || l_proc || ' end',
1734: p_msg => 'End of Procedure '|| l_proc);
1735: END IF;

Line 1745: bil_bi_util_collection_pkg.writeLog(

1741: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1742: fnd_message.set_token('ERRNO' ,SQLCODE);
1743: fnd_message.set_token('REASON' ,SQLERRM);
1744: fnd_message.set_token('ROUTINE' , l_proc);
1745: bil_bi_util_collection_pkg.writeLog(
1746: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1747: p_module => g_pkg || l_proc || ' proc_error',
1748: p_msg => fnd_message.get,
1749: p_force_log => TRUE);

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

1769: l_sysdate := sysdate;
1770: l_count := 0;
1771: l_proc := 'Insert_Into_Sumry_Incr';
1772:
1773: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1774: bil_bi_util_collection_pkg.writeLog(
1775: p_log_level => fnd_log.LEVEL_PROCEDURE,
1776: p_module => g_pkg || l_proc || ' begin',
1777: p_msg => 'Start of Procedure '|| l_proc);

Line 1774: bil_bi_util_collection_pkg.writeLog(

1770: l_count := 0;
1771: l_proc := 'Insert_Into_Sumry_Incr';
1772:
1773: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1774: bil_bi_util_collection_pkg.writeLog(
1775: p_log_level => fnd_log.LEVEL_PROCEDURE,
1776: p_module => g_pkg || l_proc || ' begin',
1777: p_msg => 'Start of Procedure '|| l_proc);
1778: END IF;

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

1791:
1792:
1793: l_count:=sql%rowcount;
1794:
1795: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1796: bil_bi_util_collection_pkg.writeLog(
1797: p_log_level => fnd_log.LEVEL_EVENT,
1798: p_module => g_pkg || l_proc ,
1799: p_msg => 'Deleted '|| l_count ||' from BIL_BI_OPDTL_F');

Line 1796: bil_bi_util_collection_pkg.writeLog(

1792:
1793: l_count:=sql%rowcount;
1794:
1795: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1796: bil_bi_util_collection_pkg.writeLog(
1797: p_log_level => fnd_log.LEVEL_EVENT,
1798: p_module => g_pkg || l_proc ,
1799: p_msg => 'Deleted '|| l_count ||' from BIL_BI_OPDTL_F');
1800: END IF;

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

2072: ;
2073: */
2074: g_row_num := sql%rowcount;
2075:
2076: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
2077: bil_bi_util_collection_pkg.writeLog(
2078: p_log_level => fnd_log.LEVEL_EVENT,
2079: p_module => g_pkg || l_proc ,
2080: p_msg => 'Inserted '|| g_row_num ||' into BIL_BI_OPDTL_F table from BIL_BI_OPDTL_STG');

Line 2077: bil_bi_util_collection_pkg.writeLog(

2073: */
2074: g_row_num := sql%rowcount;
2075:
2076: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
2077: bil_bi_util_collection_pkg.writeLog(
2078: p_log_level => fnd_log.LEVEL_EVENT,
2079: p_module => g_pkg || l_proc ,
2080: p_msg => 'Inserted '|| g_row_num ||' into BIL_BI_OPDTL_F table from BIL_BI_OPDTL_STG');
2081: END IF;

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

2079: p_module => g_pkg || l_proc ,
2080: p_msg => 'Inserted '|| g_row_num ||' into BIL_BI_OPDTL_F table from BIL_BI_OPDTL_STG');
2081: END IF;
2082:
2083: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2084: bil_bi_util_collection_pkg.writeLog(
2085: p_log_level => fnd_log.LEVEL_PROCEDURE,
2086: p_module => g_pkg || l_proc || ' end',
2087: p_msg => 'End of Procedure '|| l_proc);

Line 2084: bil_bi_util_collection_pkg.writeLog(

2080: p_msg => 'Inserted '|| g_row_num ||' into BIL_BI_OPDTL_F table from BIL_BI_OPDTL_STG');
2081: END IF;
2082:
2083: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2084: bil_bi_util_collection_pkg.writeLog(
2085: p_log_level => fnd_log.LEVEL_PROCEDURE,
2086: p_module => g_pkg || l_proc || ' end',
2087: p_msg => 'End of Procedure '|| l_proc);
2088: END IF;

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

2091: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2092: fnd_message.set_token('ERRNO' ,SQLCODE);
2093: fnd_message.set_token('REASON' ,SQLERRM);
2094: fnd_message.set_token('ROUTINE' , l_proc);
2095: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2096: p_module => g_pkg || l_proc || ' proc_error',
2097: p_msg => fnd_message.get,
2098: p_force_log => TRUE);
2099: RAISE;

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

2108: l_sysdate :=sysdate;
2109: l_count :=0;
2110: l_proc := 'Insert_Into_Sumry_Init';
2111:
2112: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2113: bil_bi_util_collection_pkg.writeLog(
2114: p_log_level => fnd_log.LEVEL_PROCEDURE,
2115: p_module => g_pkg || l_proc || ' begin',
2116: p_msg => 'Start of Procedure '|| l_proc);

Line 2113: bil_bi_util_collection_pkg.writeLog(

2109: l_count :=0;
2110: l_proc := 'Insert_Into_Sumry_Init';
2111:
2112: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2113: bil_bi_util_collection_pkg.writeLog(
2114: p_log_level => fnd_log.LEVEL_PROCEDURE,
2115: p_module => g_pkg || l_proc || ' begin',
2116: p_msg => 'Start of Procedure '|| l_proc);
2117: END IF;

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

2232:
2233: g_row_num := sql%rowcount;
2234:
2235: COMMIT;
2236: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
2237: bil_bi_util_collection_pkg.writeLog(
2238: p_log_level => fnd_log.LEVEL_EVENT,
2239: p_module => g_pkg || l_proc ,
2240: p_msg => 'Inserted '||g_row_num||' into BIL_BI_OPDTL_F table from BIL_BI_OPDTL_STG');

Line 2237: bil_bi_util_collection_pkg.writeLog(

2233: g_row_num := sql%rowcount;
2234:
2235: COMMIT;
2236: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
2237: bil_bi_util_collection_pkg.writeLog(
2238: p_log_level => fnd_log.LEVEL_EVENT,
2239: p_module => g_pkg || l_proc ,
2240: p_msg => 'Inserted '||g_row_num||' into BIL_BI_OPDTL_F table from BIL_BI_OPDTL_STG');
2241: END IF;

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

2238: p_log_level => fnd_log.LEVEL_EVENT,
2239: p_module => g_pkg || l_proc ,
2240: p_msg => 'Inserted '||g_row_num||' into BIL_BI_OPDTL_F table from BIL_BI_OPDTL_STG');
2241: END IF;
2242: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2243: bil_bi_util_collection_pkg.writeLog(
2244: p_log_level => fnd_log.LEVEL_PROCEDURE,
2245: p_module => g_pkg || l_proc || ' end ',
2246: p_msg => 'End of Procedure '|| l_proc);

Line 2243: bil_bi_util_collection_pkg.writeLog(

2239: p_module => g_pkg || l_proc ,
2240: p_msg => 'Inserted '||g_row_num||' into BIL_BI_OPDTL_F table from BIL_BI_OPDTL_STG');
2241: END IF;
2242: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2243: bil_bi_util_collection_pkg.writeLog(
2244: p_log_level => fnd_log.LEVEL_PROCEDURE,
2245: p_module => g_pkg || l_proc || ' end ',
2246: p_msg => 'End of Procedure '|| l_proc);
2247: END IF;

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

2250: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2251: fnd_message.set_token('ERRNO' ,SQLCODE);
2252: fnd_message.set_token('REASON' ,SQLERRM);
2253: fnd_message.set_token('ROUTINE' , l_proc);
2254: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2255: p_module => g_pkg || l_proc || ' proc_error',
2256: p_msg => fnd_message.get,
2257: p_force_log => TRUE);
2258:

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

2270:
2271: l_int_date_format1 :='MM/DD/YYYY HH24:MI:SS';
2272: l_proc := 'Check_Profiles';
2273:
2274: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2275: bil_bi_util_collection_pkg.writeLog(
2276: p_log_level => fnd_log.LEVEL_PROCEDURE,
2277: p_module => g_pkg || l_proc || ' begin',
2278: p_msg => 'Start of Procedure '|| l_proc);

Line 2275: bil_bi_util_collection_pkg.writeLog(

2271: l_int_date_format1 :='MM/DD/YYYY HH24:MI:SS';
2272: l_proc := 'Check_Profiles';
2273:
2274: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2275: bil_bi_util_collection_pkg.writeLog(
2276: p_log_level => fnd_log.LEVEL_PROCEDURE,
2277: p_module => g_pkg || l_proc || ' begin',
2278: p_msg => 'Start of Procedure '|| l_proc);
2279: END IF;

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

2298: g_setup_error_flag := TRUE;
2299:
2300: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
2301:
2302: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
2303: p_module => g_pkg || l_proc || ' proc_error',
2304: p_msg => fnd_message.get,
2305: p_force_log => TRUE);
2306:

Line 2314: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name('ASN_FRCST_CREDIT_TYPE_ID'));

2310:
2311:
2312:
2313: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
2314: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name('ASN_FRCST_CREDIT_TYPE_ID'));
2315: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,'ASN_FRCST_CREDIT_TYPE_ID');
2316:
2317:
2318: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,

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

2314: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name('ASN_FRCST_CREDIT_TYPE_ID'));
2315: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,'ASN_FRCST_CREDIT_TYPE_ID');
2316:
2317:
2318: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
2319: p_module => g_pkg || l_proc || ' proc_error',
2320: p_msg => fnd_message.get,
2321: p_force_log => TRUE);
2322:

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

2333: g_setup_error_flag := TRUE;
2334:
2335: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
2336:
2337: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
2338: p_module => g_pkg || l_proc || ' proc_error',
2339: p_msg => fnd_message.get,
2340: p_force_log => TRUE);
2341:

Line 2349: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name(l_list(v_counter)));

2345: FOR v_counter IN 1..2 LOOP
2346: IF (l_val(v_counter) IS NULL) THEN
2347:
2348: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
2349: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name(l_list(v_counter)));
2350: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(v_counter));
2351:
2352:
2353: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,

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

2349: fnd_message.set_token('PROFILE_USER_NAME' ,bil_bi_util_collection_pkg.get_user_profile_name(l_list(v_counter)));
2350: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(v_counter));
2351:
2352:
2353: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
2354: p_module => g_pkg || l_proc || ' proc_error',
2355: p_msg => fnd_message.get,
2356: p_force_log => TRUE);
2357:

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

2361:
2362: ret_status := FALSE;
2363: END IF;
2364:
2365: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2366: bil_bi_util_collection_pkg.writeLog(
2367: p_log_level => fnd_log.LEVEL_PROCEDURE,
2368: p_module => g_pkg || l_proc || ' end',
2369: p_msg => 'End of Procedure '|| l_proc);

Line 2366: bil_bi_util_collection_pkg.writeLog(

2362: ret_status := FALSE;
2363: END IF;
2364:
2365: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2366: bil_bi_util_collection_pkg.writeLog(
2367: p_log_level => fnd_log.LEVEL_PROCEDURE,
2368: p_module => g_pkg || l_proc || ' end',
2369: p_msg => 'End of Procedure '|| l_proc);
2370: END IF;

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

2373: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2374: fnd_message.set_token('ERRNO' ,SQLCODE);
2375: fnd_message.set_token('REASON' ,SQLERRM);
2376: fnd_message.set_token('ROUTINE' , l_proc);
2377: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2378: p_module => g_pkg || l_proc || ' proc_error',
2379: p_msg => fnd_message.get,
2380: p_force_log => TRUE);
2381:

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

2391: BEGIN
2392: l_status := FALSE;
2393: l_number_of_rows :=0;
2394: l_proc := 'Setup_Validation';
2395: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2396: bil_bi_util_collection_pkg.writeLog(
2397: p_log_level => fnd_log.LEVEL_PROCEDURE,
2398: p_module => g_pkg || l_proc || ' begin',
2399: p_msg => 'Start of Procedure '|| l_proc);

Line 2396: bil_bi_util_collection_pkg.writeLog(

2392: l_status := FALSE;
2393: l_number_of_rows :=0;
2394: l_proc := 'Setup_Validation';
2395: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2396: bil_bi_util_collection_pkg.writeLog(
2397: p_log_level => fnd_log.LEVEL_PROCEDURE,
2398: p_module => g_pkg || l_proc || ' begin',
2399: p_msg => 'Start of Procedure '|| l_proc);
2400: END IF;

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

2400: END IF;
2401: -- check profiles
2402: Check_Profiles(l_status);
2403: ret_status := l_status;
2404: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2405: bil_bi_util_collection_pkg.writeLog(
2406: p_log_level => fnd_log.LEVEL_PROCEDURE,
2407: p_module => g_pkg || l_proc || ' end',
2408: p_msg => 'End of Procedure '|| l_proc);

Line 2405: bil_bi_util_collection_pkg.writeLog(

2401: -- check profiles
2402: Check_Profiles(l_status);
2403: ret_status := l_status;
2404: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2405: bil_bi_util_collection_pkg.writeLog(
2406: p_log_level => fnd_log.LEVEL_PROCEDURE,
2407: p_module => g_pkg || l_proc || ' end',
2408: p_msg => 'End of Procedure '|| l_proc);
2409: END IF;

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

2412: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2413: fnd_message.set_token('ERRNO' ,SQLCODE);
2414: fnd_message.set_token('REASON' ,SQLERRM);
2415: fnd_message.set_token('ROUTINE' , l_proc);
2416: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2417: p_module => g_pkg || l_proc || ' proc_error',
2418: p_msg => fnd_message.get,
2419: p_force_log => TRUE);
2420: ret_status := false;

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

2433: PROCEDURE Populate_Currency_Rate IS
2434: l_proc VARCHAR2(100);
2435: BEGIN
2436: l_proc := 'Populate_Currency_Rate_Stg';
2437: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2438: bil_bi_util_collection_pkg.writeLog(
2439: p_log_level => fnd_log.LEVEL_PROCEDURE,
2440: p_module => g_pkg || l_proc || ' begin',
2441: p_msg => 'Start of Procedure '|| l_proc);

Line 2438: bil_bi_util_collection_pkg.writeLog(

2434: l_proc VARCHAR2(100);
2435: BEGIN
2436: l_proc := 'Populate_Currency_Rate_Stg';
2437: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2438: bil_bi_util_collection_pkg.writeLog(
2439: p_log_level => fnd_log.LEVEL_PROCEDURE,
2440: p_module => g_pkg || l_proc || ' begin',
2441: p_msg => 'Start of Procedure '|| l_proc);
2442: END IF;

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

2563: rates.rate);
2564:
2565: END IF;
2566: END IF;
2567: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
2568: bil_bi_util_collection_pkg.writeLog(
2569: p_log_level => fnd_log.LEVEL_EVENT,
2570: p_module => g_pkg || l_proc ,
2571: p_msg => 'Inserted '||sql%rowcount||' into BIL_BI_CURRENCY_RATE table');

Line 2568: bil_bi_util_collection_pkg.writeLog(

2564:
2565: END IF;
2566: END IF;
2567: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
2568: bil_bi_util_collection_pkg.writeLog(
2569: p_log_level => fnd_log.LEVEL_EVENT,
2570: p_module => g_pkg || l_proc ,
2571: p_msg => 'Inserted '||sql%rowcount||' into BIL_BI_CURRENCY_RATE table');
2572: END IF;

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

2570: p_module => g_pkg || l_proc ,
2571: p_msg => 'Inserted '||sql%rowcount||' into BIL_BI_CURRENCY_RATE table');
2572: END IF;
2573: commit;
2574: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2575: bil_bi_util_collection_pkg.writeLog(
2576: p_log_level => fnd_log.LEVEL_PROCEDURE,
2577: p_module => g_pkg || l_proc || ' end',
2578: p_msg => 'End of Procedure '|| l_proc);

Line 2575: bil_bi_util_collection_pkg.writeLog(

2571: p_msg => 'Inserted '||sql%rowcount||' into BIL_BI_CURRENCY_RATE table');
2572: END IF;
2573: commit;
2574: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
2575: bil_bi_util_collection_pkg.writeLog(
2576: p_log_level => fnd_log.LEVEL_PROCEDURE,
2577: p_module => g_pkg || l_proc || ' end',
2578: p_msg => 'End of Procedure '|| l_proc);
2579: END IF;

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

2582: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2583: fnd_message.set_token('ERRNO' ,SQLCODE);
2584: fnd_message.set_token('REASON' ,SQLERRM);
2585: fnd_message.set_token('ROUTINE' , l_proc);
2586: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2587: p_module => g_pkg || l_proc || ' proc_error',
2588: p_msg => fnd_message.get,
2589: p_force_log => TRUE);
2590: