1739: WHEN OTHERS THEN
1740:
1741: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1742:
1743: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1744: fnd_message.set_token('Error is : ' ,SQLCODE);
1745: fnd_message.set_token('Reason is : ', SQLERRM);
1746:
1747: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1740:
1741: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1742:
1743: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1744: fnd_message.set_token('Error is : ' ,SQLCODE);
1745: fnd_message.set_token('Reason is : ', SQLERRM);
1746:
1747: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1748: MODULE => g_pkg || l_proc || 'proc_error',
1741: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1742:
1743: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1744: fnd_message.set_token('Error is : ' ,SQLCODE);
1745: fnd_message.set_token('Reason is : ', SQLERRM);
1746:
1747: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1748: MODULE => g_pkg || l_proc || 'proc_error',
1749: MESSAGE => fnd_message.get );
1745: fnd_message.set_token('Reason is : ', SQLERRM);
1746:
1747: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1748: MODULE => g_pkg || l_proc || 'proc_error',
1749: MESSAGE => fnd_message.get );
1750:
1751: END IF;
1752: RAISE;
1753: END BIL_BI_FRCST_OVERVIEW;
3205: EXCEPTION
3206: WHEN OTHERS THEN
3207:
3208: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3209: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3210: fnd_message.set_token('Error is : ' ,SQLCODE);
3211: fnd_message.set_token('Reason is : ', SQLERRM);
3212:
3213: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
3206: WHEN OTHERS THEN
3207:
3208: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3209: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3210: fnd_message.set_token('Error is : ' ,SQLCODE);
3211: fnd_message.set_token('Reason is : ', SQLERRM);
3212:
3213: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
3214: MODULE => g_pkg || l_proc || 'proc_error',
3207:
3208: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3209: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3210: fnd_message.set_token('Error is : ' ,SQLCODE);
3211: fnd_message.set_token('Reason is : ', SQLERRM);
3212:
3213: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
3214: MODULE => g_pkg || l_proc || 'proc_error',
3215: MESSAGE => fnd_message.get );
3211: fnd_message.set_token('Reason is : ', SQLERRM);
3212:
3213: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
3214: MODULE => g_pkg || l_proc || 'proc_error',
3215: MESSAGE => fnd_message.get );
3216: END IF;
3217: RAISE;
3218: END BIL_BI_FRCST_PRODCAT;
3219: