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_PIPELINE_F_PKG dependencies on FND_MESSAGE

Line 173: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

169: p_msg => 'End of Procedure '|| l_proc);
170: END IF;
171: EXCEPTION
172: WHEN OTHERS THEN
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,

Line 174: fnd_message.set_token('ERRNO' ,SQLCODE);

170: END IF;
171: EXCEPTION
172: WHEN OTHERS THEN
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',

Line 175: fnd_message.set_token('REASON' ,SQLERRM);

171: EXCEPTION
172: WHEN OTHERS THEN
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,

Line 176: fnd_message.set_token('ROUTINE' , l_proc);

172: WHEN OTHERS THEN
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);

Line 179: p_msg => fnd_message.get,

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:
182: RAISE;
183: END Populate_Curr_Rate_SmallGap;

Line 365: fnd_message.set_name('BIL','BIL_BI_ITEM_PROD_WARN_HDR');

361: p_msg => ' Some opportunties had null product category. They have not been collected.'
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);

Line 368: p_msg => fnd_message.get,

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;
371:
372: -- print detail

Line 374: fnd_message.set_name('BIL','BIL_BI_ITEM_PROD_ERR_DTL');

370: END IF;
371:
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,

Line 375: fnd_message.set_token('OPPNUM', l_lead_num);

371:
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);

Line 378: p_msg => fnd_message.get,

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:
381:
382: END LOOP;

Line 404: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

400: END IF;
401:
402: EXCEPTION
403: WHEN OTHERS THEN
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,

Line 405: fnd_message.set_token('ERRNO' ,SQLCODE);

401:
402: EXCEPTION
403: WHEN OTHERS THEN
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',

Line 406: fnd_message.set_token('REASON' ,SQLERRM);

402: EXCEPTION
403: WHEN OTHERS THEN
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,

Line 407: fnd_message.set_token('ROUTINE' , l_proc);

403: WHEN OTHERS THEN
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);

Line 410: p_msg => fnd_message.get,

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;
413:
414: END Summary_Err_Check_SmallGap;

Line 468: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

464:
465: Exception
466: WHEN OTHERS THEN
467: /*Generic Exception Handling block.*/
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,

Line 469: fnd_message.set_token('ERRNO' ,SQLCODE);

465: Exception
466: WHEN OTHERS THEN
467: /*Generic Exception Handling block.*/
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',

Line 470: fnd_message.set_token('REASON', SQLERRM);

466: WHEN OTHERS THEN
467: /*Generic Exception Handling block.*/
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,

Line 471: fnd_message.set_token('ROUTINE', l_proc);

467: /*Generic Exception Handling block.*/
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);

Line 474: p_msg => fnd_message.get,

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:
477: RAISE;
478:

Line 529: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

525:
526: Exception
527: WHEN OTHERS THEN
528: /*Generic Exception Handling block.*/
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,

Line 530: fnd_message.set_token('ERRNO' ,SQLCODE);

526: Exception
527: WHEN OTHERS THEN
528: /*Generic Exception Handling block.*/
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',

Line 531: fnd_message.set_token('REASON', SQLERRM);

527: WHEN OTHERS THEN
528: /*Generic Exception Handling block.*/
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,

Line 532: fnd_message.set_token('ROUTINE', l_proc);

528: /*Generic Exception Handling block.*/
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);

Line 535: p_msg => fnd_message.get,

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:
538: RAISE;
539:

Line 678: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

674:
675: Exception
676: WHEN OTHERS THEN
677: /*Generic Exception Handling block.*/
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,

Line 679: fnd_message.set_token('ERRNO' ,SQLCODE);

675: Exception
676: WHEN OTHERS THEN
677: /*Generic Exception Handling block.*/
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',

Line 680: fnd_message.set_token('REASON', SQLERRM);

676: WHEN OTHERS THEN
677: /*Generic Exception Handling block.*/
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,

Line 681: fnd_message.set_token('ROUTINE', l_proc);

677: /*Generic Exception Handling block.*/
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);

Line 684: p_msg => fnd_message.get,

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:
687: RAISE;
688:

Line 742: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

738:
739: Exception
740: WHEN OTHERS THEN
741: /*Generic Exception Handling block.*/
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,

Line 743: fnd_message.set_token('ERRNO' ,SQLCODE);

739: Exception
740: WHEN OTHERS THEN
741: /*Generic Exception Handling block.*/
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',

Line 744: fnd_message.set_token('REASON', SQLERRM);

740: WHEN OTHERS THEN
741: /*Generic Exception Handling block.*/
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,

Line 745: fnd_message.set_token('ROUTINE', l_proc);

741: /*Generic Exception Handling block.*/
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);

Line 748: p_msg => fnd_message.get,

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:
751: RAISE;
752:

Line 794: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

790:
791: Exception
792: WHEN OTHERS THEN
793: /*Generic Exception Handling block.*/
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,

Line 795: fnd_message.set_token('ERRNO' ,SQLCODE);

791: Exception
792: WHEN OTHERS THEN
793: /*Generic Exception Handling block.*/
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',

Line 796: fnd_message.set_token('REASON', SQLERRM);

792: WHEN OTHERS THEN
793: /*Generic Exception Handling block.*/
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,

Line 797: fnd_message.set_token('ROUTINE', l_proc);

793: /*Generic Exception Handling block.*/
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);

Line 800: p_msg => fnd_message.get,

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:
803: RAISE;
804:

Line 860: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

856: p_period_to:=null;
857:
858: WHEN OTHERS THEN
859: /*Generic Exception Handling block.*/
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,

Line 861: fnd_message.set_token('ERRNO' ,SQLCODE);

857:
858: WHEN OTHERS THEN
859: /*Generic Exception Handling block.*/
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',

Line 862: fnd_message.set_token('REASON', SQLERRM);

858: WHEN OTHERS THEN
859: /*Generic Exception Handling block.*/
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,

Line 863: fnd_message.set_token('ROUTINE', l_proc);

859: /*Generic Exception Handling block.*/
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);

Line 866: p_msg => fnd_message.get,

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:
869: RAISE;
870: end get_last_failure_periods;

Line 919: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

915:
916: Exception
917: WHEN OTHERS THEN
918: /*Generic Exception Handling block.*/
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,

Line 920: fnd_message.set_token('ERRNO' ,SQLCODE);

916: Exception
917: WHEN OTHERS THEN
918: /*Generic Exception Handling block.*/
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',

Line 921: fnd_message.set_token('REASON', SQLERRM);

917: WHEN OTHERS THEN
918: /*Generic Exception Handling block.*/
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,

Line 922: fnd_message.set_token('ROUTINE', l_proc);

918: /*Generic Exception Handling block.*/
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);

Line 925: p_msg => fnd_message.get,

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:
928: RAISE;
929: end get_first_success_period;

Line 967: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

963:
964: Exception
965: WHEN OTHERS THEN
966: /*Generic Exception Handling block.*/
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,

Line 968: fnd_message.set_token('ERRNO' ,SQLCODE);

964: Exception
965: WHEN OTHERS THEN
966: /*Generic Exception Handling block.*/
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',

Line 969: fnd_message.set_token('REASON', SQLERRM);

965: WHEN OTHERS THEN
966: /*Generic Exception Handling block.*/
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,

Line 970: fnd_message.set_token('ROUTINE', l_proc);

966: /*Generic Exception Handling block.*/
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);

Line 973: p_msg => fnd_message.get,

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:
976: RAISE;
977: END get_number_of_runs;

Line 1257: fnd_message.set_name('BIL','BIL_BI_DATE_PARAM_RESET');

1253:
1254: IF p_start_date IS NULL THEN
1255: l_Start_Date := G_global_start_date;
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: (

Line 1258: fnd_message.set_token('RESET_DATE',

1254: IF p_start_date IS NULL THEN
1255: l_Start_Date := G_global_start_date;
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,

Line 1264: p_msg => fnd_message.get,

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,
1265: p_force_log => TRUE
1266: );
1267: l_start_date := TRUNC(l_sysdate);
1268: l_return_warn := 'Y';

Line 1302: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');

1298: IF (l_opty_cnt < 0 ) THEN
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',

Line 1307: p_msg => fnd_message.get,

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,
1308: p_force_log => TRUE
1309: );
1310: END IF;
1311: fnd_message.set_name('BIL','BIL_BI_OPTY_LOG_MISSING');

Line 1311: fnd_message.set_name('BIL','BIL_BI_OPTY_LOG_MISSING');

1307: p_msg => fnd_message.get,
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',

Line 1316: p_msg => fnd_message.get,

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,
1317: p_force_log => TRUE
1318: );
1319: END IF;
1320:

Line 2846: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

2842: l_date,
2843: l_date
2844: );
2845:
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,

Line 2847: fnd_message.set_token('ERRNO' ,SQLCODE);

2843: l_date
2844: );
2845:
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',

Line 2848: fnd_message.set_token('REASON' ,SQLERRM);

2844: );
2845:
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,

Line 2849: fnd_message.set_token('ROUTINE' , l_proc);

2845:
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);

Line 2852: p_msg => fnd_message.get,

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;
2855: END;
2856:

Line 2993: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

2989: p_msg => 'End of Procedure '|| l_proc);
2990: END IF;
2991: EXCEPTION
2992: WHEN OTHERS THEN
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,

Line 2994: fnd_message.set_token('ERRNO' ,SQLCODE);

2990: END IF;
2991: EXCEPTION
2992: WHEN OTHERS THEN
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',

Line 2995: fnd_message.set_token('REASON' ,SQLERRM);

2991: EXCEPTION
2992: WHEN OTHERS THEN
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,

Line 2996: fnd_message.set_token('ROUTINE' , l_proc);

2992: WHEN OTHERS THEN
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);

Line 2999: p_msg => fnd_message.get,

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:
3002: RAISE;
3003: END Populate_Currency_Rate;

Line 3265: fnd_message.set_name('BIL','BIL_BI_ITEM_PROD_WARN_HDR');

3261: p_msg => ' Some opportunties had null product category. They have not been collected.'
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);

Line 3268: p_msg => fnd_message.get,

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;
3271:
3272: -- print detail

Line 3274: fnd_message.set_name('BIL','BIL_BI_ITEM_PROD_ERR_DTL');

3270: END IF;
3271:
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,

Line 3275: fnd_message.set_token('OPPNUM', l_lead_num);

3271:
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);

Line 3278: p_msg => fnd_message.get,

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:
3281:
3282: END LOOP;

Line 3304: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

3300: END IF;
3301:
3302: EXCEPTION
3303: WHEN OTHERS THEN
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,

Line 3305: fnd_message.set_token('ERRNO' ,SQLCODE);

3301:
3302: EXCEPTION
3303: WHEN OTHERS THEN
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',

Line 3306: fnd_message.set_token('REASON' ,SQLERRM);

3302: EXCEPTION
3303: WHEN OTHERS THEN
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,

Line 3307: fnd_message.set_token('ROUTINE' , l_proc);

3303: WHEN OTHERS THEN
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);

Line 3310: p_msg => fnd_message.get,

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;
3313:
3314: END Summary_Err_Check;

Line 3335: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');

3331: IF (g_setup_error_flag = FALSE) 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,

Line 3339: p_msg => fnd_message.get,

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:
3342: END IF;
3343:

Line 3346: fnd_message.set_name('BIL','BIL_BI_PROFILE_WRONG_VALUE');

3342: END IF;
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:

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 3348: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,p_profile_name);

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
3352: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,

Line 3349: fnd_message.set_token('PROFILE_VALUE' , p_exp_value);

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
3352: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3353: p_module => g_pkg || l_proc || ' proc_error',

Line 3354: p_msg => fnd_message.get,

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:
3357: END IF;
3358: END IF;

Line 3370: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

3366:
3367: EXCEPTION
3368:
3369: WHEN OTHERS THEN
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,

Line 3371: fnd_message.set_token('ERRNO' ,SQLCODE);

3367: EXCEPTION
3368:
3369: WHEN OTHERS THEN
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',

Line 3372: fnd_message.set_token('REASON' ,SQLERRM);

3368:
3369: WHEN OTHERS THEN
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,

Line 3373: fnd_message.set_token('ROUTINE' , l_proc);

3369: WHEN OTHERS THEN
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);

Line 3376: p_msg => fnd_message.get,

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:
3379: raise;
3380:

Line 3401: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');

3397:
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',

Line 3406: p_msg => fnd_message.get,

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,
3407: p_force_log => TRUE
3408: );
3409: END IF;
3410:

Line 3411: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');

3407: p_force_log => TRUE
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:

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 3413: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,p_profile_name);

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,
3417: p_module => g_pkg || l_proc || ' proc_error',

Line 3418: p_msg => fnd_message.get,

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:
3421: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
3422: bil_bi_util_collection_pkg.writeLog(

Line 3431: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

3427:
3428: EXCEPTION
3429:
3430: WHEN OTHERS THEN
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,

Line 3432: fnd_message.set_token('ERRNO' ,SQLCODE);

3428: EXCEPTION
3429:
3430: WHEN OTHERS THEN
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',

Line 3433: fnd_message.set_token('REASON' ,SQLERRM);

3429:
3430: WHEN OTHERS THEN
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,

Line 3434: fnd_message.set_token('ROUTINE' , l_proc);

3430: WHEN OTHERS THEN
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);

Line 3437: p_msg => fnd_message.get,

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:
3440: raise;
3441:

Line 3530: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

3526:
3527: EXCEPTION
3528:
3529: WHEN OTHERS THEN
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,

Line 3531: fnd_message.set_token('ERRNO' ,SQLCODE);

3527: EXCEPTION
3528:
3529: WHEN OTHERS THEN
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',

Line 3532: fnd_message.set_token('REASON' ,SQLERRM);

3528:
3529: WHEN OTHERS THEN
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,

Line 3533: fnd_message.set_token('ROUTINE' , l_proc);

3529: WHEN OTHERS THEN
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);

Line 3536: p_msg => fnd_message.get,

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:
3539: raise;
3540:

Line 4052: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

4048:
4049: EXCEPTION
4050:
4051: WHEN OTHERS THEN
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,

Line 4053: fnd_message.set_token('ERRNO' ,SQLCODE);

4049: EXCEPTION
4050:
4051: WHEN OTHERS THEN
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',

Line 4054: fnd_message.set_token('REASON' ,SQLERRM);

4050:
4051: WHEN OTHERS THEN
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,

Line 4055: fnd_message.set_token('ROUTINE' , l_proc);

4051: WHEN OTHERS THEN
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);

Line 4058: p_msg => fnd_message.get,

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:
4061: raise;
4062:

Line 4437: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

4433:
4434: EXCEPTION
4435:
4436: WHEN OTHERS THEN
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,

Line 4438: fnd_message.set_token('ERRNO' ,SQLCODE);

4434: EXCEPTION
4435:
4436: WHEN OTHERS THEN
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',

Line 4439: fnd_message.set_token('REASON' ,SQLERRM);

4435:
4436: WHEN OTHERS THEN
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,

Line 4440: fnd_message.set_token('ROUTINE' , l_proc);

4436: WHEN OTHERS THEN
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);

Line 4443: p_msg => fnd_message.get,

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:
4446: raise;
4447:

Line 4669: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

4665: WHEN NO_DATA_FOUND THEN
4666: NULL;
4667:
4668: WHEN OTHERS THEN
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,

Line 4670: fnd_message.set_token('ERRNO' ,SQLCODE);

4666: NULL;
4667:
4668: WHEN OTHERS THEN
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',

Line 4671: fnd_message.set_token('REASON' ,SQLERRM);

4667:
4668: WHEN OTHERS THEN
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,

Line 4672: fnd_message.set_token('ROUTINE' , l_proc);

4668: WHEN OTHERS THEN
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);

Line 4675: p_msg => fnd_message.get,

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:
4678: raise;
4679:

Line 4716: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

4712: where end_date = p_end_date;
4713:
4714: EXCEPTION
4715: WHEN OTHERS THEN
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,

Line 4717: fnd_message.set_token('ERRNO' ,SQLCODE);

4713:
4714: EXCEPTION
4715: WHEN OTHERS THEN
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',

Line 4718: fnd_message.set_token('REASON' ,SQLERRM);

4714: EXCEPTION
4715: WHEN OTHERS THEN
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,

Line 4719: fnd_message.set_token('ROUTINE' , l_proc);

4715: WHEN OTHERS THEN
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);

Line 4722: p_msg => fnd_message.get,

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:
4725: raise;
4726: END;

Line 4929: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

4925: ;
4926: commit;
4927:
4928: EXCEPTION WHEN OTHERS THEN
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,

Line 4930: fnd_message.set_token('ERRNO' ,SQLCODE);

4926: commit;
4927:
4928: EXCEPTION WHEN OTHERS THEN
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',

Line 4931: fnd_message.set_token('REASON' ,SQLERRM);

4927:
4928: EXCEPTION WHEN OTHERS THEN
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,

Line 4932: fnd_message.set_token('ROUTINE' , l_proc);

4928: EXCEPTION WHEN OTHERS THEN
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);

Line 4935: p_msg => fnd_message.get,

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:
4938: raise;
4939:

Line 5034: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

5030:
5031: commit;
5032:
5033: EXCEPTION WHEN OTHERS THEN
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,

Line 5035: fnd_message.set_token('ERRNO' ,SQLCODE);

5031: commit;
5032:
5033: EXCEPTION WHEN OTHERS THEN
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',

Line 5036: fnd_message.set_token('REASON' ,SQLERRM);

5032:
5033: EXCEPTION WHEN OTHERS THEN
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,

Line 5037: fnd_message.set_token('ROUTINE' , l_proc);

5033: EXCEPTION WHEN OTHERS THEN
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);

Line 5040: p_msg => fnd_message.get,

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:
5043: raise;
5044:

Line 5367: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

5363:
5364: EXCEPTION
5365:
5366: WHEN OTHERS THEN
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,

Line 5368: fnd_message.set_token('ERRNO' ,SQLCODE);

5364: EXCEPTION
5365:
5366: WHEN OTHERS THEN
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',

Line 5369: fnd_message.set_token('REASON' ,SQLERRM);

5365:
5366: WHEN OTHERS THEN
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,

Line 5370: fnd_message.set_token('ROUTINE' , l_proc);

5366: WHEN OTHERS THEN
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);

Line 5373: p_msg => fnd_message.get,

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:
5376: raise;
5377:

Line 6153: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

6149:
6150: EXCEPTION
6151:
6152: WHEN OTHERS THEN
6153: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
6154: fnd_message.set_token('ERRNO' ,SQLCODE);
6155: fnd_message.set_token('REASON' ,SQLERRM);
6156: fnd_message.set_token('ROUTINE' , l_proc);
6157:

Line 6154: fnd_message.set_token('ERRNO' ,SQLCODE);

6150: EXCEPTION
6151:
6152: WHEN OTHERS THEN
6153: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
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,

Line 6155: fnd_message.set_token('REASON' ,SQLERRM);

6151:
6152: WHEN OTHERS THEN
6153: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
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',

Line 6156: fnd_message.set_token('ROUTINE' , l_proc);

6152: WHEN OTHERS THEN
6153: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
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,

Line 6160: p_msg => fnd_message.get,

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:
6163: raise;
6164:

Line 6337: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

6333:
6334: EXCEPTION
6335:
6336: WHEN OTHERS THEN
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,

Line 6338: fnd_message.set_token('ERRNO' ,SQLCODE);

6334: EXCEPTION
6335:
6336: WHEN OTHERS THEN
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',

Line 6339: fnd_message.set_token('REASON' ,SQLERRM);

6335:
6336: WHEN OTHERS THEN
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,

Line 6340: fnd_message.set_token('ROUTINE' , l_proc);

6336: WHEN OTHERS THEN
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);

Line 6343: p_msg => fnd_message.get,

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:
6346: raise;
6347: END Insert_Into_Stg_SmallGap;

Line 6873: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

6869:
6870: EXCEPTION
6871:
6872: WHEN OTHERS THEN
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,

Line 6874: fnd_message.set_token('ERRNO' ,SQLCODE);

6870: EXCEPTION
6871:
6872: WHEN OTHERS THEN
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',

Line 6875: fnd_message.set_token('REASON' ,SQLERRM);

6871:
6872: WHEN OTHERS THEN
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,

Line 6876: fnd_message.set_token('ROUTINE' , l_proc);

6872: WHEN OTHERS THEN
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);

Line 6879: p_msg => fnd_message.get,

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:
6882: raise;
6883: