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

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

424: IF(p_truncate = 'Y' or p_truncate= 'y') THEN
425: IF p_start_date IS NULL THEN
426: G_Start_Date := g_cal_start_date;
427: ELSIF (TO_DATE(p_start_date, 'YYYY/MM/DD HH24:MI:SS') > l_sysdate) THEN
428: fnd_message.set_name('BIL','BIL_BI_DATE_PARAM_RESET');
429: fnd_message.set_token('RESET_DATE',
430: TO_CHAR(SYSDATE, 'YYYY/MM/DD HH24:MI:SS'));
431: bil_bi_util_collection_pkg.writeLog
432: (

Line 429: fnd_message.set_token('RESET_DATE',

425: IF p_start_date IS NULL THEN
426: G_Start_Date := g_cal_start_date;
427: ELSIF (TO_DATE(p_start_date, 'YYYY/MM/DD HH24:MI:SS') > l_sysdate) THEN
428: fnd_message.set_name('BIL','BIL_BI_DATE_PARAM_RESET');
429: fnd_message.set_token('RESET_DATE',
430: TO_CHAR(SYSDATE, 'YYYY/MM/DD HH24:MI:SS'));
431: bil_bi_util_collection_pkg.writeLog
432: (
433: p_log_level => fnd_log.LEVEL_ERROR,

Line 435: p_msg => fnd_message.get,

431: bil_bi_util_collection_pkg.writeLog
432: (
433: p_log_level => fnd_log.LEVEL_ERROR,
434: p_module => g_pkg || l_proc ,
435: p_msg => fnd_message.get,
436: p_force_log => TRUE
437: );
438: g_start_date := l_sysdate;
439: g_warn_flag := 'Y';

Line 448: fnd_message.set_name('BIL','BIL_BI_INVALID_DATE_RANGE');

444: IF p_start_date IS NULL THEN
445: G_Start_Date := g_cal_start_date;
446: ELSE
447: IF ((TO_DATE(p_start_date, 'YYYY/MM/DD HH24:MI:SS') < l_period_to) AND p_truncate NOT IN ('y','Y')) THEN
448: fnd_message.set_name('BIL','BIL_BI_INVALID_DATE_RANGE');
449: bil_bi_util_collection_pkg.writeLog
450: (
451: p_log_level => fnd_log.LEVEL_ERROR,
452: p_module => g_pkg || l_proc ,

Line 453: p_msg => fnd_message.get,

449: bil_bi_util_collection_pkg.writeLog
450: (
451: p_log_level => fnd_log.LEVEL_ERROR,
452: p_module => g_pkg || l_proc ,
453: p_msg => fnd_message.get,
454: p_force_log => TRUE
455: );
456: g_start_date := l_period_to;
457: g_warn_flag := 'Y';

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

455: );
456: g_start_date := l_period_to;
457: g_warn_flag := 'Y';
458: ELSIF ( TO_DATE(p_start_date, 'YYYY/MM/DD HH24:MI:SS') > l_period_to ) THEN
459: fnd_message.set_name('BIL','BIL_BI_DATE_PARAM_RESET');
460: fnd_message.set_token('RESET_DATE',
461: TO_CHAR(l_period_to, 'YYYY/MM/DD HH24:MI:SS'));
462: bil_bi_util_collection_pkg.writeLog
463: (

Line 460: fnd_message.set_token('RESET_DATE',

456: g_start_date := l_period_to;
457: g_warn_flag := 'Y';
458: ELSIF ( TO_DATE(p_start_date, 'YYYY/MM/DD HH24:MI:SS') > l_period_to ) THEN
459: fnd_message.set_name('BIL','BIL_BI_DATE_PARAM_RESET');
460: fnd_message.set_token('RESET_DATE',
461: TO_CHAR(l_period_to, 'YYYY/MM/DD HH24:MI:SS'));
462: bil_bi_util_collection_pkg.writeLog
463: (
464: p_log_level => fnd_log.LEVEL_ERROR,

Line 466: p_msg => FND_MESSAGE.get,

462: bil_bi_util_collection_pkg.writeLog
463: (
464: p_log_level => fnd_log.LEVEL_ERROR,
465: p_module => g_pkg || l_proc ,
466: p_msg => FND_MESSAGE.get,
467: p_force_log => TRUE
468: );
469: g_start_date := l_period_to;
470: g_warn_flag := 'Y';

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

1029: g_retcode := -1;
1030: ROLLBACK;
1031: retcode := g_retcode;
1032: Clean_up(sqlerrm);
1033: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1034: fnd_message.set_token('ERRNO' ,SQLCODE);
1035: fnd_message.set_token('REASON' ,SQLERRM);
1036: fnd_message.set_token('ROUTINE' , l_proc);
1037: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

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

1030: ROLLBACK;
1031: retcode := g_retcode;
1032: Clean_up(sqlerrm);
1033: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1034: fnd_message.set_token('ERRNO' ,SQLCODE);
1035: fnd_message.set_token('REASON' ,SQLERRM);
1036: fnd_message.set_token('ROUTINE' , l_proc);
1037: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1038: p_module => g_pkg || l_proc || 'proc_error',

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

1031: retcode := g_retcode;
1032: Clean_up(sqlerrm);
1033: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1034: fnd_message.set_token('ERRNO' ,SQLCODE);
1035: fnd_message.set_token('REASON' ,SQLERRM);
1036: fnd_message.set_token('ROUTINE' , l_proc);
1037: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1038: p_module => g_pkg || l_proc || 'proc_error',
1039: p_msg => fnd_message.get,

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

1032: Clean_up(sqlerrm);
1033: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1034: fnd_message.set_token('ERRNO' ,SQLCODE);
1035: fnd_message.set_token('REASON' ,SQLERRM);
1036: fnd_message.set_token('ROUTINE' , l_proc);
1037: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1038: p_module => g_pkg || l_proc || 'proc_error',
1039: p_msg => fnd_message.get,
1040: p_force_log => TRUE);

Line 1039: p_msg => fnd_message.get,

1035: fnd_message.set_token('REASON' ,SQLERRM);
1036: fnd_message.set_token('ROUTINE' , l_proc);
1037: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1038: p_module => g_pkg || l_proc || 'proc_error',
1039: p_msg => fnd_message.get,
1040: p_force_log => TRUE);
1041: RAISE;
1042: END Main;
1043: /************************************************************************************************/

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

1202: EXCEPTION
1203:
1204: WHEN OTHERS Then
1205: g_retcode := -1;
1206: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1207: fnd_message.set_token('ERRNO' ,SQLCODE);
1208: fnd_message.set_token('REASON', SQLERRM);
1209: fnd_message.set_token('ROUTINE' , l_proc);
1210: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

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

1203:
1204: WHEN OTHERS Then
1205: g_retcode := -1;
1206: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1207: fnd_message.set_token('ERRNO' ,SQLCODE);
1208: fnd_message.set_token('REASON', SQLERRM);
1209: fnd_message.set_token('ROUTINE' , l_proc);
1210: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1211: p_module => g_pkg || l_proc || ' proc_error ',

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

1204: WHEN OTHERS Then
1205: g_retcode := -1;
1206: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1207: fnd_message.set_token('ERRNO' ,SQLCODE);
1208: fnd_message.set_token('REASON', SQLERRM);
1209: fnd_message.set_token('ROUTINE' , l_proc);
1210: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1211: p_module => g_pkg || l_proc || ' proc_error ',
1212: p_msg => fnd_message.get,

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

1205: g_retcode := -1;
1206: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1207: fnd_message.set_token('ERRNO' ,SQLCODE);
1208: fnd_message.set_token('REASON', SQLERRM);
1209: fnd_message.set_token('ROUTINE' , l_proc);
1210: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1211: p_module => g_pkg || l_proc || ' proc_error ',
1212: p_msg => fnd_message.get,
1213: p_force_log => TRUE);

Line 1212: p_msg => fnd_message.get,

1208: fnd_message.set_token('REASON', SQLERRM);
1209: fnd_message.set_token('ROUTINE' , l_proc);
1210: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1211: p_module => g_pkg || l_proc || ' proc_error ',
1212: p_msg => fnd_message.get,
1213: p_force_log => TRUE);
1214: RAISE;
1215:
1216: END New_Forecasts;

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

1416: EXCEPTION
1417: WHEN OTHERS THEN
1418:
1419: g_retcode := -1;
1420: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1421: fnd_message.set_token('ERRNO' ,SQLCODE);
1422: fnd_message.set_token('REASON' ,SQLERRM);
1423: fnd_message.set_token('ROUTINE' , l_proc);
1424: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

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

1417: WHEN OTHERS THEN
1418:
1419: g_retcode := -1;
1420: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1421: fnd_message.set_token('ERRNO' ,SQLCODE);
1422: fnd_message.set_token('REASON' ,SQLERRM);
1423: fnd_message.set_token('ROUTINE' , l_proc);
1424: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1425: p_module => g_pkg || l_proc || 'proc_error',

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

1418:
1419: g_retcode := -1;
1420: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1421: fnd_message.set_token('ERRNO' ,SQLCODE);
1422: fnd_message.set_token('REASON' ,SQLERRM);
1423: fnd_message.set_token('ROUTINE' , l_proc);
1424: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1425: p_module => g_pkg || l_proc || 'proc_error',
1426: p_msg => fnd_message.get,

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

1419: g_retcode := -1;
1420: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1421: fnd_message.set_token('ERRNO' ,SQLCODE);
1422: fnd_message.set_token('REASON' ,SQLERRM);
1423: fnd_message.set_token('ROUTINE' , l_proc);
1424: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1425: p_module => g_pkg || l_proc || 'proc_error',
1426: p_msg => fnd_message.get,
1427: p_force_log => TRUE);

Line 1426: p_msg => fnd_message.get,

1422: fnd_message.set_token('REASON' ,SQLERRM);
1423: fnd_message.set_token('ROUTINE' , l_proc);
1424: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1425: p_module => g_pkg || l_proc || 'proc_error',
1426: p_msg => fnd_message.get,
1427: p_force_log => TRUE);
1428: RAISE;
1429: END Populate_Currency_Rate;
1430:

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

1836:
1837: EXCEPTION
1838: WHEN OTHERS Then
1839: g_retcode := -1;
1840: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1841: fnd_message.set_token('ERRNO' ,SQLCODE);
1842: fnd_message.set_token('REASON', SQLERRM);
1843: fnd_message.set_token('ROUTINE' , l_proc);
1844: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

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

1837: EXCEPTION
1838: WHEN OTHERS Then
1839: g_retcode := -1;
1840: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1841: fnd_message.set_token('ERRNO' ,SQLCODE);
1842: fnd_message.set_token('REASON', SQLERRM);
1843: fnd_message.set_token('ROUTINE' , l_proc);
1844: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1845: p_module => g_pkg || l_proc || ' proc_error ',

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

1838: WHEN OTHERS Then
1839: g_retcode := -1;
1840: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1841: fnd_message.set_token('ERRNO' ,SQLCODE);
1842: fnd_message.set_token('REASON', SQLERRM);
1843: fnd_message.set_token('ROUTINE' , l_proc);
1844: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1845: p_module => g_pkg || l_proc || ' proc_error ',
1846: p_msg => fnd_message.get,

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

1839: g_retcode := -1;
1840: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1841: fnd_message.set_token('ERRNO' ,SQLCODE);
1842: fnd_message.set_token('REASON', SQLERRM);
1843: fnd_message.set_token('ROUTINE' , l_proc);
1844: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1845: p_module => g_pkg || l_proc || ' proc_error ',
1846: p_msg => fnd_message.get,
1847: p_force_log => TRUE);

Line 1846: p_msg => fnd_message.get,

1842: fnd_message.set_token('REASON', SQLERRM);
1843: fnd_message.set_token('ROUTINE' , l_proc);
1844: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1845: p_module => g_pkg || l_proc || ' proc_error ',
1846: p_msg => fnd_message.get,
1847: p_force_log => TRUE);
1848:
1849: raise;
1850:

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

1904:
1905: ROLLBACK;
1906:
1907: g_retcode:=-1;
1908: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1909: fnd_message.set_token('ERRNO' ,SQLCODE);
1910: fnd_message.set_token('REASON', SQLERRM);
1911: fnd_message.set_token('ROUTINE' , l_proc);
1912: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

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

1905: ROLLBACK;
1906:
1907: g_retcode:=-1;
1908: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1909: fnd_message.set_token('ERRNO' ,SQLCODE);
1910: fnd_message.set_token('REASON', SQLERRM);
1911: fnd_message.set_token('ROUTINE' , l_proc);
1912: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1913: p_module => g_pkg || l_proc || ' proc_error ',

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

1906:
1907: g_retcode:=-1;
1908: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1909: fnd_message.set_token('ERRNO' ,SQLCODE);
1910: fnd_message.set_token('REASON', SQLERRM);
1911: fnd_message.set_token('ROUTINE' , l_proc);
1912: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1913: p_module => g_pkg || l_proc || ' proc_error ',
1914: p_msg => fnd_message.get,

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

1907: g_retcode:=-1;
1908: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1909: fnd_message.set_token('ERRNO' ,SQLCODE);
1910: fnd_message.set_token('REASON', SQLERRM);
1911: fnd_message.set_token('ROUTINE' , l_proc);
1912: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1913: p_module => g_pkg || l_proc || ' proc_error ',
1914: p_msg => fnd_message.get,
1915: p_force_log => TRUE);

Line 1914: p_msg => fnd_message.get,

1910: fnd_message.set_token('REASON', SQLERRM);
1911: fnd_message.set_token('ROUTINE' , l_proc);
1912: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1913: p_module => g_pkg || l_proc || ' proc_error ',
1914: p_msg => fnd_message.get,
1915: p_force_log => TRUE);
1916: RAISE;
1917:
1918: END Clean_up;

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

2272:
2273: EXCEPTION
2274: WHEN OTHERS Then
2275: g_retcode := -1;
2276: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2277: fnd_message.set_token('ERRNO' ,SQLCODE);
2278: fnd_message.set_token('REASON', SQLERRM);
2279: fnd_message.set_token('ROUTINE' , l_proc);
2280: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

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

2273: EXCEPTION
2274: WHEN OTHERS Then
2275: g_retcode := -1;
2276: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2277: fnd_message.set_token('ERRNO' ,SQLCODE);
2278: fnd_message.set_token('REASON', SQLERRM);
2279: fnd_message.set_token('ROUTINE' , l_proc);
2280: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2281: p_module => g_pkg || l_proc || ' proc_error ',

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

2274: WHEN OTHERS Then
2275: g_retcode := -1;
2276: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2277: fnd_message.set_token('ERRNO' ,SQLCODE);
2278: fnd_message.set_token('REASON', SQLERRM);
2279: fnd_message.set_token('ROUTINE' , l_proc);
2280: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2281: p_module => g_pkg || l_proc || ' proc_error ',
2282: p_msg => fnd_message.get,

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

2275: g_retcode := -1;
2276: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2277: fnd_message.set_token('ERRNO' ,SQLCODE);
2278: fnd_message.set_token('REASON', SQLERRM);
2279: fnd_message.set_token('ROUTINE' , l_proc);
2280: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2281: p_module => g_pkg || l_proc || ' proc_error ',
2282: p_msg => fnd_message.get,
2283: p_force_log => TRUE);

Line 2282: p_msg => fnd_message.get,

2278: fnd_message.set_token('REASON', SQLERRM);
2279: fnd_message.set_token('ROUTINE' , l_proc);
2280: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2281: p_module => g_pkg || l_proc || ' proc_error ',
2282: p_msg => fnd_message.get,
2283: p_force_log => TRUE);
2284: raise;
2285:
2286: END Summarize_Frcsts_Periods;

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

2558: EXCEPTION
2559:
2560: WHEN OTHERS Then
2561: g_retcode := -1;
2562: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2563: fnd_message.set_token('ERRNO' ,SQLCODE);
2564: fnd_message.set_token('REASON', SQLERRM);
2565: fnd_message.set_token('ROUTINE' , l_proc);
2566: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

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

2559:
2560: WHEN OTHERS Then
2561: g_retcode := -1;
2562: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2563: fnd_message.set_token('ERRNO' ,SQLCODE);
2564: fnd_message.set_token('REASON', SQLERRM);
2565: fnd_message.set_token('ROUTINE' , l_proc);
2566: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2567: p_module => g_pkg || l_proc || ' proc_error ',

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

2560: WHEN OTHERS Then
2561: g_retcode := -1;
2562: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2563: fnd_message.set_token('ERRNO' ,SQLCODE);
2564: fnd_message.set_token('REASON', SQLERRM);
2565: fnd_message.set_token('ROUTINE' , l_proc);
2566: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2567: p_module => g_pkg || l_proc || ' proc_error ',
2568: p_msg => fnd_message.get,

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

2561: g_retcode := -1;
2562: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2563: fnd_message.set_token('ERRNO' ,SQLCODE);
2564: fnd_message.set_token('REASON', SQLERRM);
2565: fnd_message.set_token('ROUTINE' , l_proc);
2566: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2567: p_module => g_pkg || l_proc || ' proc_error ',
2568: p_msg => fnd_message.get,
2569: p_force_log => TRUE);

Line 2568: p_msg => fnd_message.get,

2564: fnd_message.set_token('REASON', SQLERRM);
2565: fnd_message.set_token('ROUTINE' , l_proc);
2566: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
2567: p_module => g_pkg || l_proc || ' proc_error ',
2568: p_msg => fnd_message.get,
2569: p_force_log => TRUE);
2570:
2571: raise;
2572:

Line 2701: fnd_message.set_name('BIL','BIL_BI_FST_PERIOD_MAP_ERROR');

2697: l_number_of_rows :=l_number_of_rows + 1;
2698:
2699:
2700: IF(l_number_of_rows=1) THEN
2701: fnd_message.set_name('BIL','BIL_BI_FST_PERIOD_MAP_ERROR');
2702: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN
2703: bil_bi_util_collection_pkg.writeLog(
2704: p_log_level => fnd_log.LEVEL_ERROR,
2705: p_module => g_pkg || l_proc,

Line 2706: p_msg =>fnd_message.get);

2702: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_ERROR) THEN
2703: bil_bi_util_collection_pkg.writeLog(
2704: p_log_level => fnd_log.LEVEL_ERROR,
2705: p_module => g_pkg || l_proc,
2706: p_msg =>fnd_message.get);
2707: END IF;
2708:
2709: END IF;
2710:

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

3017: EXCEPTION
3018:
3019: WHEN OTHERS Then
3020: g_retcode := -1;
3021: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3022: fnd_message.set_token('ERRNO' ,SQLCODE);
3023: fnd_message.set_token('REASON', SQLERRM);
3024: fnd_message.set_token('ROUTINE' , l_proc);
3025: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

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

3018:
3019: WHEN OTHERS Then
3020: g_retcode := -1;
3021: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3022: fnd_message.set_token('ERRNO' ,SQLCODE);
3023: fnd_message.set_token('REASON', SQLERRM);
3024: fnd_message.set_token('ROUTINE' , l_proc);
3025: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3026: p_module => g_pkg || l_proc || ' proc_error ',

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

3019: WHEN OTHERS Then
3020: g_retcode := -1;
3021: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3022: fnd_message.set_token('ERRNO' ,SQLCODE);
3023: fnd_message.set_token('REASON', SQLERRM);
3024: fnd_message.set_token('ROUTINE' , l_proc);
3025: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3026: p_module => g_pkg || l_proc || ' proc_error ',
3027: p_msg => fnd_message.get,

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

3020: g_retcode := -1;
3021: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3022: fnd_message.set_token('ERRNO' ,SQLCODE);
3023: fnd_message.set_token('REASON', SQLERRM);
3024: fnd_message.set_token('ROUTINE' , l_proc);
3025: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3026: p_module => g_pkg || l_proc || ' proc_error ',
3027: p_msg => fnd_message.get,
3028: p_force_log => TRUE);

Line 3027: p_msg => fnd_message.get,

3023: fnd_message.set_token('REASON', SQLERRM);
3024: fnd_message.set_token('ROUTINE' , l_proc);
3025: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3026: p_module => g_pkg || l_proc || ' proc_error ',
3027: p_msg => fnd_message.get,
3028: p_force_log => TRUE);
3029:
3030: raise;
3031: END summary_adjust;

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

3229:
3230: EXCEPTION
3231: WHEN OTHERS THEN
3232: g_retcode:=-1;
3233: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3234: fnd_message.set_token('ERRNO' ,SQLCODE);
3235: fnd_message.set_token('REASON', SQLERRM);
3236: fnd_message.set_token('ROUTINE' , l_proc);
3237: bil_bi_util_collection_pkg.writeLog

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

3230: EXCEPTION
3231: WHEN OTHERS THEN
3232: g_retcode:=-1;
3233: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3234: fnd_message.set_token('ERRNO' ,SQLCODE);
3235: fnd_message.set_token('REASON', SQLERRM);
3236: fnd_message.set_token('ROUTINE' , l_proc);
3237: bil_bi_util_collection_pkg.writeLog
3238: (

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

3231: WHEN OTHERS THEN
3232: g_retcode:=-1;
3233: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3234: fnd_message.set_token('ERRNO' ,SQLCODE);
3235: fnd_message.set_token('REASON', SQLERRM);
3236: fnd_message.set_token('ROUTINE' , l_proc);
3237: bil_bi_util_collection_pkg.writeLog
3238: (
3239: p_log_level => fnd_log.LEVEL_UNEXPECTED,

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

3232: g_retcode:=-1;
3233: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3234: fnd_message.set_token('ERRNO' ,SQLCODE);
3235: fnd_message.set_token('REASON', SQLERRM);
3236: fnd_message.set_token('ROUTINE' , l_proc);
3237: bil_bi_util_collection_pkg.writeLog
3238: (
3239: p_log_level => fnd_log.LEVEL_UNEXPECTED,
3240: p_module => g_pkg || l_proc || ' proc_error ',

Line 3241: p_msg => fnd_message.get

3237: bil_bi_util_collection_pkg.writeLog
3238: (
3239: p_log_level => fnd_log.LEVEL_UNEXPECTED,
3240: p_module => g_pkg || l_proc || ' proc_error ',
3241: p_msg => fnd_message.get
3242: );
3243: Raise;
3244:
3245: END Summary_err_check;

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

3320: EXCEPTION
3321:
3322: WHEN OTHERS THEN
3323: g_retcode := -1;
3324: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3325: fnd_message.set_token('ERRNO' ,SQLCODE);
3326: fnd_message.set_token('REASON', SQLERRM);
3327: fnd_message.set_token('ROUTINE' , l_proc);
3328: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

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

3321:
3322: WHEN OTHERS THEN
3323: g_retcode := -1;
3324: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3325: fnd_message.set_token('ERRNO' ,SQLCODE);
3326: fnd_message.set_token('REASON', SQLERRM);
3327: fnd_message.set_token('ROUTINE' , l_proc);
3328: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3329: p_module => g_pkg || l_proc || ' proc_error ',

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

3322: WHEN OTHERS THEN
3323: g_retcode := -1;
3324: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3325: fnd_message.set_token('ERRNO' ,SQLCODE);
3326: fnd_message.set_token('REASON', SQLERRM);
3327: fnd_message.set_token('ROUTINE' , l_proc);
3328: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3329: p_module => g_pkg || l_proc || ' proc_error ',
3330: p_msg => fnd_message.get,

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

3323: g_retcode := -1;
3324: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3325: fnd_message.set_token('ERRNO' ,SQLCODE);
3326: fnd_message.set_token('REASON', SQLERRM);
3327: fnd_message.set_token('ROUTINE' , l_proc);
3328: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3329: p_module => g_pkg || l_proc || ' proc_error ',
3330: p_msg => fnd_message.get,
3331: p_force_log => TRUE);

Line 3330: p_msg => fnd_message.get,

3326: fnd_message.set_token('REASON', SQLERRM);
3327: fnd_message.set_token('ROUTINE' , l_proc);
3328: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3329: p_module => g_pkg || l_proc || ' proc_error ',
3330: p_msg => fnd_message.get,
3331: p_force_log => TRUE);
3332: RAISE;
3333:
3334: END REPORT_MISSING_RATES;

Line 3437: fnd_message.set_name('BIL','BIL_BI_FST_PROD_CAT_NUL_ERR');

3433: );
3434: END IF;
3435:
3436:
3437: fnd_message.set_name('BIL','BIL_BI_FST_PROD_CAT_NUL_ERR');
3438: bil_bi_util_collection_pkg.writeLog
3439: (
3440: p_log_level => fnd_log.LEVEL_ERROR,
3441: p_module => g_pkg || l_proc || 'proc_error',

Line 3442: p_msg => fnd_message.get

3438: bil_bi_util_collection_pkg.writeLog
3439: (
3440: p_log_level => fnd_log.LEVEL_ERROR,
3441: p_module => g_pkg || l_proc || 'proc_error',
3442: p_msg => fnd_message.get
3443: );
3444:
3445: FOR ro IN
3446: (

Line 3467: fnd_message.set_name('BIL','BIL_BI_FST_CAT_MAP_ERR_DTL');

3463: )
3464: LOOP
3465:
3466:
3467: fnd_message.set_name('BIL','BIL_BI_FST_CAT_MAP_ERR_DTL');
3468: fnd_message.set_token('FORECAST_CATEGORY_ID', ro.forecast_category_id);
3469: fnd_message.set_token('FORECAST_CATEGORY_NAME', ro.forecast_category_name);
3470: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3471: p_module => g_pkg || l_proc || 'proc_error',

Line 3468: fnd_message.set_token('FORECAST_CATEGORY_ID', ro.forecast_category_id);

3464: LOOP
3465:
3466:
3467: fnd_message.set_name('BIL','BIL_BI_FST_CAT_MAP_ERR_DTL');
3468: fnd_message.set_token('FORECAST_CATEGORY_ID', ro.forecast_category_id);
3469: fnd_message.set_token('FORECAST_CATEGORY_NAME', ro.forecast_category_name);
3470: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3471: p_module => g_pkg || l_proc || 'proc_error',
3472: p_msg => fnd_message.get,

Line 3469: fnd_message.set_token('FORECAST_CATEGORY_NAME', ro.forecast_category_name);

3465:
3466:
3467: fnd_message.set_name('BIL','BIL_BI_FST_CAT_MAP_ERR_DTL');
3468: fnd_message.set_token('FORECAST_CATEGORY_ID', ro.forecast_category_id);
3469: fnd_message.set_token('FORECAST_CATEGORY_NAME', ro.forecast_category_name);
3470: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3471: p_module => g_pkg || l_proc || 'proc_error',
3472: p_msg => fnd_message.get,
3473: p_force_log => TRUE);

Line 3472: p_msg => fnd_message.get,

3468: fnd_message.set_token('FORECAST_CATEGORY_ID', ro.forecast_category_id);
3469: fnd_message.set_token('FORECAST_CATEGORY_NAME', ro.forecast_category_name);
3470: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3471: p_module => g_pkg || l_proc || 'proc_error',
3472: p_msg => fnd_message.get,
3473: p_force_log => TRUE);
3474:
3475:
3476: END LOOP;

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

3490: l_number_of_rows :=l_number_of_rows + 1;
3491:
3492: IF(l_number_of_rows=1) THEN -- OS vs BIS Calendar Period Mismatch
3493: -- print header
3494: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
3495: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3496: p_module => g_pkg || l_proc || 'proc_error',
3497: p_msg => fnd_message.get,
3498: p_force_log => TRUE);

Line 3497: p_msg => fnd_message.get,

3493: -- print header
3494: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
3495: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3496: p_module => g_pkg || l_proc || 'proc_error',
3497: p_msg => fnd_message.get,
3498: p_force_log => TRUE);
3499: fnd_message.set_name('BIL','BIL_BI_PER_MISMATCH_HDR');
3500: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3501: p_module => g_pkg || l_proc || 'proc_error',

Line 3499: fnd_message.set_name('BIL','BIL_BI_PER_MISMATCH_HDR');

3495: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3496: p_module => g_pkg || l_proc || 'proc_error',
3497: p_msg => fnd_message.get,
3498: p_force_log => TRUE);
3499: fnd_message.set_name('BIL','BIL_BI_PER_MISMATCH_HDR');
3500: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3501: p_module => g_pkg || l_proc || 'proc_error',
3502: p_msg => fnd_message.get,
3503: p_force_log => TRUE);

Line 3502: p_msg => fnd_message.get,

3498: p_force_log => TRUE);
3499: fnd_message.set_name('BIL','BIL_BI_PER_MISMATCH_HDR');
3500: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3501: p_module => g_pkg || l_proc || 'proc_error',
3502: p_msg => fnd_message.get,
3503: p_force_log => TRUE);
3504: l_ret_status:=FALSE;
3505:
3506: END IF;

Line 3508: fnd_message.set_name('BIL','BIL_BI_PER_MISMATCH_DTL');

3504: l_ret_status:=FALSE;
3505:
3506: END IF;
3507: -- print detail
3508: fnd_message.set_name('BIL','BIL_BI_PER_MISMATCH_DTL');
3509: fnd_message.set_token('OFFENDING_PERIOD_NAME', l_per_name);
3510: bil_bi_util_collection_pkg.writeLog
3511: (
3512: p_log_level => fnd_log.LEVEL_ERROR,

Line 3509: fnd_message.set_token('OFFENDING_PERIOD_NAME', l_per_name);

3505:
3506: END IF;
3507: -- print detail
3508: fnd_message.set_name('BIL','BIL_BI_PER_MISMATCH_DTL');
3509: fnd_message.set_token('OFFENDING_PERIOD_NAME', l_per_name);
3510: bil_bi_util_collection_pkg.writeLog
3511: (
3512: p_log_level => fnd_log.LEVEL_ERROR,
3513: p_module => g_pkg || l_proc || 'proc_error',

Line 3514: p_msg => fnd_message.get,

3510: bil_bi_util_collection_pkg.writeLog
3511: (
3512: p_log_level => fnd_log.LEVEL_ERROR,
3513: p_module => g_pkg || l_proc || 'proc_error',
3514: p_msg => fnd_message.get,
3515: p_force_log => TRUE
3516: );
3517: END LOOP;
3518: CLOSE asf_bil_per_csr;

Line 3535: fnd_message.set_name('BIL','BIL_BI_FST_CAT_MAP_ERR_HDR');

3531: EXIT WHEN fst_prod_csr%NOTFOUND ;
3532: l_number_of_rows :=l_number_of_rows + 1;
3533: IF(l_number_of_rows=1) THEN -- Forecast to Product Category Mapping Not 1-to-1
3534: -- print header
3535: fnd_message.set_name('BIL','BIL_BI_FST_CAT_MAP_ERR_HDR');
3536: fnd_message.set_token('ASN_IMPLEM_DATE', g_asn_date);
3537: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3538: p_module => g_pkg || l_proc || 'proc_error',
3539: p_msg => fnd_message.get,

Line 3536: fnd_message.set_token('ASN_IMPLEM_DATE', g_asn_date);

3532: l_number_of_rows :=l_number_of_rows + 1;
3533: IF(l_number_of_rows=1) THEN -- Forecast to Product Category Mapping Not 1-to-1
3534: -- print header
3535: fnd_message.set_name('BIL','BIL_BI_FST_CAT_MAP_ERR_HDR');
3536: fnd_message.set_token('ASN_IMPLEM_DATE', g_asn_date);
3537: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3538: p_module => g_pkg || l_proc || 'proc_error',
3539: p_msg => fnd_message.get,
3540: p_force_log => TRUE);

Line 3539: p_msg => fnd_message.get,

3535: fnd_message.set_name('BIL','BIL_BI_FST_CAT_MAP_ERR_HDR');
3536: fnd_message.set_token('ASN_IMPLEM_DATE', g_asn_date);
3537: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3538: p_module => g_pkg || l_proc || 'proc_error',
3539: p_msg => fnd_message.get,
3540: p_force_log => TRUE);
3541: g_warn_flag := 'Y';
3542: END IF;
3543: -- print detail

Line 3544: fnd_message.set_name('BIL','BIL_BI_FST_CAT_MAP_ERR_DTL');

3540: p_force_log => TRUE);
3541: g_warn_flag := 'Y';
3542: END IF;
3543: -- print detail
3544: fnd_message.set_name('BIL','BIL_BI_FST_CAT_MAP_ERR_DTL');
3545: fnd_message.set_token('FORECAST_CATEGORY_ID', l_fst_id);
3546: fnd_message.set_token('FORECAST_CATEGORY_NAME', l_fst_name);
3547: bil_bi_util_collection_pkg.writeLog
3548: (

Line 3545: fnd_message.set_token('FORECAST_CATEGORY_ID', l_fst_id);

3541: g_warn_flag := 'Y';
3542: END IF;
3543: -- print detail
3544: fnd_message.set_name('BIL','BIL_BI_FST_CAT_MAP_ERR_DTL');
3545: fnd_message.set_token('FORECAST_CATEGORY_ID', l_fst_id);
3546: fnd_message.set_token('FORECAST_CATEGORY_NAME', l_fst_name);
3547: bil_bi_util_collection_pkg.writeLog
3548: (
3549: p_log_level => fnd_log.LEVEL_ERROR,

Line 3546: fnd_message.set_token('FORECAST_CATEGORY_NAME', l_fst_name);

3542: END IF;
3543: -- print detail
3544: fnd_message.set_name('BIL','BIL_BI_FST_CAT_MAP_ERR_DTL');
3545: fnd_message.set_token('FORECAST_CATEGORY_ID', l_fst_id);
3546: fnd_message.set_token('FORECAST_CATEGORY_NAME', l_fst_name);
3547: bil_bi_util_collection_pkg.writeLog
3548: (
3549: p_log_level => fnd_log.LEVEL_ERROR,
3550: p_module => g_pkg || l_proc || 'proc_error',

Line 3551: p_msg => fnd_message.get,

3547: bil_bi_util_collection_pkg.writeLog
3548: (
3549: p_log_level => fnd_log.LEVEL_ERROR,
3550: p_module => g_pkg || l_proc || 'proc_error',
3551: p_msg => fnd_message.get,
3552: p_force_log => TRUE
3553: );
3554: END LOOP;
3555: CLOSE fst_prod_csr;

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

3568: EXCEPTION
3569:
3570: WHEN OTHERS THEN
3571: g_retcode := -1;
3572: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3573: fnd_message.set_token('ERRNO' ,SQLCODE);
3574: fnd_message.set_token('REASON', SQLERRM);
3575: fnd_message.set_token('ROUTINE' , l_proc);
3576: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

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

3569:
3570: WHEN OTHERS THEN
3571: g_retcode := -1;
3572: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3573: fnd_message.set_token('ERRNO' ,SQLCODE);
3574: fnd_message.set_token('REASON', SQLERRM);
3575: fnd_message.set_token('ROUTINE' , l_proc);
3576: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3577: p_module => g_pkg || l_proc || ' proc_error ',

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

3570: WHEN OTHERS THEN
3571: g_retcode := -1;
3572: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3573: fnd_message.set_token('ERRNO' ,SQLCODE);
3574: fnd_message.set_token('REASON', SQLERRM);
3575: fnd_message.set_token('ROUTINE' , l_proc);
3576: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3577: p_module => g_pkg || l_proc || ' proc_error ',
3578: p_msg => fnd_message.get,

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

3571: g_retcode := -1;
3572: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3573: fnd_message.set_token('ERRNO' ,SQLCODE);
3574: fnd_message.set_token('REASON', SQLERRM);
3575: fnd_message.set_token('ROUTINE' , l_proc);
3576: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3577: p_module => g_pkg || l_proc || ' proc_error ',
3578: p_msg => fnd_message.get,
3579: p_force_log => TRUE);

Line 3578: p_msg => fnd_message.get,

3574: fnd_message.set_token('REASON', SQLERRM);
3575: fnd_message.set_token('ROUTINE' , l_proc);
3576: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3577: p_module => g_pkg || l_proc || ' proc_error ',
3578: p_msg => fnd_message.get,
3579: p_force_log => TRUE);
3580: RAISE;
3581:
3582:

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

3622: IF (NOT bis_common_parameters.check_global_parameters(l_list)) THEN -- Check Parameters
3623: bis_common_parameters.get_global_parameters(l_list, l_val);
3624: l_ret_status := FALSE;
3625:
3626: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
3627:
3628: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3629: p_module => g_pkg || l_proc || 'proc_error',
3630: p_msg => fnd_message.get,

Line 3630: p_msg => fnd_message.get,

3626: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
3627:
3628: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3629: p_module => g_pkg || l_proc || 'proc_error',
3630: p_msg => fnd_message.get,
3631: p_force_log => TRUE);
3632: FOR v_counter IN 1..9 LOOP
3633: IF (l_val(v_counter) IS NULL) THEN
3634: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');

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

3630: p_msg => fnd_message.get,
3631: p_force_log => TRUE);
3632: FOR v_counter IN 1..9 LOOP
3633: IF (l_val(v_counter) IS NULL) THEN
3634: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3635: fnd_message.set_token('PROFILE_USER_NAME' ,
3636: bil_bi_util_collection_pkg.get_user_profile_name(l_list(v_counter)));
3637: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(v_counter));
3638:

Line 3635: fnd_message.set_token('PROFILE_USER_NAME' ,

3631: p_force_log => TRUE);
3632: FOR v_counter IN 1..9 LOOP
3633: IF (l_val(v_counter) IS NULL) THEN
3634: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3635: fnd_message.set_token('PROFILE_USER_NAME' ,
3636: bil_bi_util_collection_pkg.get_user_profile_name(l_list(v_counter)));
3637: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(v_counter));
3638:
3639: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,

Line 3637: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(v_counter));

3633: IF (l_val(v_counter) IS NULL) THEN
3634: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3635: fnd_message.set_token('PROFILE_USER_NAME' ,
3636: bil_bi_util_collection_pkg.get_user_profile_name(l_list(v_counter)));
3637: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(v_counter));
3638:
3639: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3640: p_module => g_pkg || l_proc || 'proc_error',
3641: p_msg => fnd_message.get,

Line 3641: p_msg => fnd_message.get,

3637: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(v_counter));
3638:
3639: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3640: p_module => g_pkg || l_proc || 'proc_error',
3641: p_msg => fnd_message.get,
3642: p_force_log => TRUE);
3643: END IF;
3644: END LOOP;
3645: ELSE

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

3691: p_msg => ' Secondary curency set up but rate type not set up: ERROR '
3692: );
3693: END IF;
3694: IF(l_ret_status = FALSE) THEN-- already a profile error reported.. so dont print header etc
3695: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3696: fnd_message.set_token('PROFILE_USER_NAME' ,
3697: bil_bi_util_collection_pkg.get_user_profile_name(l_list(11)));
3698: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(11));
3699: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,

Line 3696: fnd_message.set_token('PROFILE_USER_NAME' ,

3692: );
3693: END IF;
3694: IF(l_ret_status = FALSE) THEN-- already a profile error reported.. so dont print header etc
3695: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3696: fnd_message.set_token('PROFILE_USER_NAME' ,
3697: bil_bi_util_collection_pkg.get_user_profile_name(l_list(11)));
3698: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(11));
3699: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3700: p_module => g_pkg || l_proc || 'proc_error',

Line 3698: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(11));

3694: IF(l_ret_status = FALSE) THEN-- already a profile error reported.. so dont print header etc
3695: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3696: fnd_message.set_token('PROFILE_USER_NAME' ,
3697: bil_bi_util_collection_pkg.get_user_profile_name(l_list(11)));
3698: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(11));
3699: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3700: p_module => g_pkg || l_proc || 'proc_error',
3701: p_msg => fnd_message.get,
3702: p_force_log => TRUE); -- for fnd_message.get

Line 3701: p_msg => fnd_message.get,

3697: bil_bi_util_collection_pkg.get_user_profile_name(l_list(11)));
3698: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(11));
3699: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3700: p_module => g_pkg || l_proc || 'proc_error',
3701: p_msg => fnd_message.get,
3702: p_force_log => TRUE); -- for fnd_message.get
3703: ELSE -- print error msg with header also
3704: l_ret_status := FALSE;
3705: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');

Line 3702: p_force_log => TRUE); -- for fnd_message.get

3698: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(11));
3699: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3700: p_module => g_pkg || l_proc || 'proc_error',
3701: p_msg => fnd_message.get,
3702: p_force_log => TRUE); -- for fnd_message.get
3703: ELSE -- print error msg with header also
3704: l_ret_status := FALSE;
3705: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
3706: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,

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

3701: p_msg => fnd_message.get,
3702: p_force_log => TRUE); -- for fnd_message.get
3703: ELSE -- print error msg with header also
3704: l_ret_status := FALSE;
3705: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
3706: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3707: p_module => g_pkg || l_proc || 'proc_error',
3708: p_msg => fnd_message.get,
3709: p_force_log => TRUE); -- for fnd_message.get

Line 3708: p_msg => fnd_message.get,

3704: l_ret_status := FALSE;
3705: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
3706: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3707: p_module => g_pkg || l_proc || 'proc_error',
3708: p_msg => fnd_message.get,
3709: p_force_log => TRUE); -- for fnd_message.get
3710: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3711: fnd_message.set_token('PROFILE_USER_NAME' ,
3712: bil_bi_util_collection_pkg.get_user_profile_name(l_list(11)));

Line 3709: p_force_log => TRUE); -- for fnd_message.get

3705: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
3706: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3707: p_module => g_pkg || l_proc || 'proc_error',
3708: p_msg => fnd_message.get,
3709: p_force_log => TRUE); -- for fnd_message.get
3710: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3711: fnd_message.set_token('PROFILE_USER_NAME' ,
3712: bil_bi_util_collection_pkg.get_user_profile_name(l_list(11)));
3713: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(11));

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

3706: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3707: p_module => g_pkg || l_proc || 'proc_error',
3708: p_msg => fnd_message.get,
3709: p_force_log => TRUE); -- for fnd_message.get
3710: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3711: fnd_message.set_token('PROFILE_USER_NAME' ,
3712: bil_bi_util_collection_pkg.get_user_profile_name(l_list(11)));
3713: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(11));
3714: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,

Line 3711: fnd_message.set_token('PROFILE_USER_NAME' ,

3707: p_module => g_pkg || l_proc || 'proc_error',
3708: p_msg => fnd_message.get,
3709: p_force_log => TRUE); -- for fnd_message.get
3710: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3711: fnd_message.set_token('PROFILE_USER_NAME' ,
3712: bil_bi_util_collection_pkg.get_user_profile_name(l_list(11)));
3713: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(11));
3714: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3715: p_module => g_pkg || l_proc || 'proc_error',

Line 3713: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(11));

3709: p_force_log => TRUE); -- for fnd_message.get
3710: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3711: fnd_message.set_token('PROFILE_USER_NAME' ,
3712: bil_bi_util_collection_pkg.get_user_profile_name(l_list(11)));
3713: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(11));
3714: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3715: p_module => g_pkg || l_proc || 'proc_error',
3716: p_msg => fnd_message.get,
3717: p_force_log => TRUE); -- for fnd_message.get

Line 3716: p_msg => fnd_message.get,

3712: bil_bi_util_collection_pkg.get_user_profile_name(l_list(11)));
3713: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(11));
3714: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3715: p_module => g_pkg || l_proc || 'proc_error',
3716: p_msg => fnd_message.get,
3717: p_force_log => TRUE); -- for fnd_message.get
3718: END IF;
3719: END IF;
3720:

Line 3717: p_force_log => TRUE); -- for fnd_message.get

3713: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(11));
3714: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3715: p_module => g_pkg || l_proc || 'proc_error',
3716: p_msg => fnd_message.get,
3717: p_force_log => TRUE); -- for fnd_message.get
3718: END IF;
3719: END IF;
3720:
3721: -- sec curr and rate type properly set up

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

3747: );
3748: END IF;
3749:
3750: IF(l_ret_status = FALSE) THEN-- already a profile error reported.. so dont print header etc
3751: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3752: fnd_message.set_token('PROFILE_USER_NAME' ,
3753: bil_bi_util_collection_pkg.get_user_profile_name(l_list(12)));
3754: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(12));
3755: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,

Line 3752: fnd_message.set_token('PROFILE_USER_NAME' ,

3748: END IF;
3749:
3750: IF(l_ret_status = FALSE) THEN-- already a profile error reported.. so dont print header etc
3751: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3752: fnd_message.set_token('PROFILE_USER_NAME' ,
3753: bil_bi_util_collection_pkg.get_user_profile_name(l_list(12)));
3754: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(12));
3755: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3756: p_module => g_pkg || l_proc || 'proc_error',

Line 3754: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(12));

3750: IF(l_ret_status = FALSE) THEN-- already a profile error reported.. so dont print header etc
3751: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3752: fnd_message.set_token('PROFILE_USER_NAME' ,
3753: bil_bi_util_collection_pkg.get_user_profile_name(l_list(12)));
3754: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(12));
3755: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3756: p_module => g_pkg || l_proc || 'proc_error',
3757: p_msg => fnd_message.get,
3758: p_force_log => TRUE); -- for fnd_message.get

Line 3757: p_msg => fnd_message.get,

3753: bil_bi_util_collection_pkg.get_user_profile_name(l_list(12)));
3754: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(12));
3755: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3756: p_module => g_pkg || l_proc || 'proc_error',
3757: p_msg => fnd_message.get,
3758: p_force_log => TRUE); -- for fnd_message.get
3759: ELSE -- print error msg with header also
3760: l_ret_status := FALSE;
3761: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');

Line 3758: p_force_log => TRUE); -- for fnd_message.get

3754: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(12));
3755: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3756: p_module => g_pkg || l_proc || 'proc_error',
3757: p_msg => fnd_message.get,
3758: p_force_log => TRUE); -- for fnd_message.get
3759: ELSE -- print error msg with header also
3760: l_ret_status := FALSE;
3761: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
3762: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,

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

3757: p_msg => fnd_message.get,
3758: p_force_log => TRUE); -- for fnd_message.get
3759: ELSE -- print error msg with header also
3760: l_ret_status := FALSE;
3761: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
3762: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3763: p_module => g_pkg || l_proc || 'proc_error',
3764: p_msg => fnd_message.get,
3765: p_force_log => TRUE); -- for fnd_message.get

Line 3764: p_msg => fnd_message.get,

3760: l_ret_status := FALSE;
3761: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
3762: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3763: p_module => g_pkg || l_proc || 'proc_error',
3764: p_msg => fnd_message.get,
3765: p_force_log => TRUE); -- for fnd_message.get
3766: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3767: fnd_message.set_token('PROFILE_USER_NAME' ,
3768: bil_bi_util_collection_pkg.get_user_profile_name(l_list(12)));

Line 3765: p_force_log => TRUE); -- for fnd_message.get

3761: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
3762: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3763: p_module => g_pkg || l_proc || 'proc_error',
3764: p_msg => fnd_message.get,
3765: p_force_log => TRUE); -- for fnd_message.get
3766: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3767: fnd_message.set_token('PROFILE_USER_NAME' ,
3768: bil_bi_util_collection_pkg.get_user_profile_name(l_list(12)));
3769: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(12));

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

3762: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3763: p_module => g_pkg || l_proc || 'proc_error',
3764: p_msg => fnd_message.get,
3765: p_force_log => TRUE); -- for fnd_message.get
3766: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3767: fnd_message.set_token('PROFILE_USER_NAME' ,
3768: bil_bi_util_collection_pkg.get_user_profile_name(l_list(12)));
3769: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(12));
3770: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,

Line 3767: fnd_message.set_token('PROFILE_USER_NAME' ,

3763: p_module => g_pkg || l_proc || 'proc_error',
3764: p_msg => fnd_message.get,
3765: p_force_log => TRUE); -- for fnd_message.get
3766: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3767: fnd_message.set_token('PROFILE_USER_NAME' ,
3768: bil_bi_util_collection_pkg.get_user_profile_name(l_list(12)));
3769: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(12));
3770: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3771: p_module => g_pkg || l_proc || 'proc_error',

Line 3769: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(12));

3765: p_force_log => TRUE); -- for fnd_message.get
3766: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
3767: fnd_message.set_token('PROFILE_USER_NAME' ,
3768: bil_bi_util_collection_pkg.get_user_profile_name(l_list(12)));
3769: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(12));
3770: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3771: p_module => g_pkg || l_proc || 'proc_error',
3772: p_msg => fnd_message.get,
3773: p_force_log => TRUE); -- for fnd_message.get

Line 3772: p_msg => fnd_message.get,

3768: bil_bi_util_collection_pkg.get_user_profile_name(l_list(12)));
3769: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(12));
3770: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3771: p_module => g_pkg || l_proc || 'proc_error',
3772: p_msg => fnd_message.get,
3773: p_force_log => TRUE); -- for fnd_message.get
3774: END IF;
3775:
3776: ELSE

Line 3773: p_force_log => TRUE); -- for fnd_message.get

3769: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(12));
3770: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3771: p_module => g_pkg || l_proc || 'proc_error',
3772: p_msg => fnd_message.get,
3773: p_force_log => TRUE); -- for fnd_message.get
3774: END IF;
3775:
3776: ELSE
3777:

Line 3799: fnd_message.set_name('BIL','BIL_BI_FUTURE_ASN_DATE');

3795: -- Set the status to error
3796: l_ret_status := FALSE;
3797:
3798: -- Log a message in the CP log file and the CP ouput file
3799: fnd_message.set_name('BIL','BIL_BI_FUTURE_ASN_DATE');
3800: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3801: p_module => g_pkg || l_proc || 'proc_error',
3802: p_msg => fnd_message.get,
3803: p_force_log => TRUE); -- for fnd_message.get

Line 3802: p_msg => fnd_message.get,

3798: -- Log a message in the CP log file and the CP ouput file
3799: fnd_message.set_name('BIL','BIL_BI_FUTURE_ASN_DATE');
3800: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3801: p_module => g_pkg || l_proc || 'proc_error',
3802: p_msg => fnd_message.get,
3803: p_force_log => TRUE); -- for fnd_message.get
3804: END IF;
3805:
3806: END IF;

Line 3803: p_force_log => TRUE); -- for fnd_message.get

3799: fnd_message.set_name('BIL','BIL_BI_FUTURE_ASN_DATE');
3800: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
3801: p_module => g_pkg || l_proc || 'proc_error',
3802: p_msg => fnd_message.get,
3803: p_force_log => TRUE); -- for fnd_message.get
3804: END IF;
3805:
3806: END IF;
3807:

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

3836: EXCEPTION
3837: WHEN OTHERS THEN
3838:
3839: g_retcode := -1;
3840: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3841: fnd_message.set_token('ERRNO' ,SQLCODE);
3842: fnd_message.set_token('REASON' ,SQLERRM);
3843: fnd_message.set_token('ROUTINE' , l_proc);
3844: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

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

3837: WHEN OTHERS THEN
3838:
3839: g_retcode := -1;
3840: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3841: fnd_message.set_token('ERRNO' ,SQLCODE);
3842: fnd_message.set_token('REASON' ,SQLERRM);
3843: fnd_message.set_token('ROUTINE' , l_proc);
3844: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3845: p_module => g_pkg || l_proc || 'proc_error',

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

3838:
3839: g_retcode := -1;
3840: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3841: fnd_message.set_token('ERRNO' ,SQLCODE);
3842: fnd_message.set_token('REASON' ,SQLERRM);
3843: fnd_message.set_token('ROUTINE' , l_proc);
3844: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3845: p_module => g_pkg || l_proc || 'proc_error',
3846: p_msg => fnd_message.get,

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

3839: g_retcode := -1;
3840: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3841: fnd_message.set_token('ERRNO' ,SQLCODE);
3842: fnd_message.set_token('REASON' ,SQLERRM);
3843: fnd_message.set_token('ROUTINE' , l_proc);
3844: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3845: p_module => g_pkg || l_proc || 'proc_error',
3846: p_msg => fnd_message.get,
3847: p_force_log => TRUE);

Line 3846: p_msg => fnd_message.get,

3842: fnd_message.set_token('REASON' ,SQLERRM);
3843: fnd_message.set_token('ROUTINE' , l_proc);
3844: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
3845: p_module => g_pkg || l_proc || 'proc_error',
3846: p_msg => fnd_message.get,
3847: p_force_log => TRUE);
3848:
3849: RAISE;
3850: