DBA Data[Home] [Help]

APPS.BIL_BI_OPPTY_MGMT_RPTS_PKG dependencies on FND_MESSAGE

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

1324: WHEN OTHERS THEN
1325:
1326: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1327:
1328: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1329: fnd_message.set_token('ERRNO',SQLCODE);
1330: fnd_message.set_token('REASON',SQLERRM);
1331: fnd_message.set_token('ROUTINE',l_proc);
1332:

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

1325:
1326: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1327:
1328: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1329: fnd_message.set_token('ERRNO',SQLCODE);
1330: fnd_message.set_token('REASON',SQLERRM);
1331: fnd_message.set_token('ROUTINE',l_proc);
1332:
1333: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

1326: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1327:
1328: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1329: fnd_message.set_token('ERRNO',SQLCODE);
1330: fnd_message.set_token('REASON',SQLERRM);
1331: fnd_message.set_token('ROUTINE',l_proc);
1332:
1333: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1334: MODULE => g_pkg || l_proc,

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

1327:
1328: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1329: fnd_message.set_token('ERRNO',SQLCODE);
1330: fnd_message.set_token('REASON',SQLERRM);
1331: fnd_message.set_token('ROUTINE',l_proc);
1332:
1333: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1334: MODULE => g_pkg || l_proc,
1335: MESSAGE => fnd_message.get );

Line 1335: MESSAGE => fnd_message.get );

1331: fnd_message.set_token('ROUTINE',l_proc);
1332:
1333: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1334: MODULE => g_pkg || l_proc,
1335: MESSAGE => fnd_message.get );
1336:
1337: END IF;
1338:
1339: RAISE;

Line 2403: fnd_message.set_name('FND','SQL_PLSQL_ERROR');

2399: WHEN OTHERS THEN
2400:
2401: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2402:
2403: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
2404: fnd_message.set_token('ERROR' ,SQLCODE);
2405: fnd_message.set_token('REASON', SQLERRM);
2406: fnd_message.set_token('ROUTINE',l_proc);
2407:

Line 2404: fnd_message.set_token('ERROR' ,SQLCODE);

2400:
2401: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2402:
2403: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
2404: fnd_message.set_token('ERROR' ,SQLCODE);
2405: fnd_message.set_token('REASON', SQLERRM);
2406: fnd_message.set_token('ROUTINE',l_proc);
2407:
2408: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

2401: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2402:
2403: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
2404: fnd_message.set_token('ERROR' ,SQLCODE);
2405: fnd_message.set_token('REASON', SQLERRM);
2406: fnd_message.set_token('ROUTINE',l_proc);
2407:
2408: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2409: MODULE => g_pkg || l_proc || 'proc_error',

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

2402:
2403: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
2404: fnd_message.set_token('ERROR' ,SQLCODE);
2405: fnd_message.set_token('REASON', SQLERRM);
2406: fnd_message.set_token('ROUTINE',l_proc);
2407:
2408: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2409: MODULE => g_pkg || l_proc || 'proc_error',
2410: MESSAGE => fnd_message.get );

Line 2410: MESSAGE => fnd_message.get );

2406: fnd_message.set_token('ROUTINE',l_proc);
2407:
2408: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2409: MODULE => g_pkg || l_proc || 'proc_error',
2410: MESSAGE => fnd_message.get );
2411:
2412: END IF;
2413:
2414: RAISE;

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

2809: WHEN OTHERS THEN
2810:
2811: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2812:
2813: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2814: fnd_message.set_token('Error is : ' ,SQLCODE);
2815: fnd_message.set_token('Reason is : ', SQLERRM);
2816:
2817: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

Line 2814: fnd_message.set_token('Error is : ' ,SQLCODE);

2810:
2811: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2812:
2813: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2814: fnd_message.set_token('Error is : ' ,SQLCODE);
2815: fnd_message.set_token('Reason is : ', SQLERRM);
2816:
2817: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2818: MODULE => g_pkg || l_proc || 'proc_error',

Line 2815: fnd_message.set_token('Reason is : ', SQLERRM);

2811: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2812:
2813: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2814: fnd_message.set_token('Error is : ' ,SQLCODE);
2815: fnd_message.set_token('Reason is : ', SQLERRM);
2816:
2817: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2818: MODULE => g_pkg || l_proc || 'proc_error',
2819: MESSAGE => fnd_message.get );

Line 2819: MESSAGE => fnd_message.get );

2815: fnd_message.set_token('Reason is : ', SQLERRM);
2816:
2817: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2818: MODULE => g_pkg || l_proc || 'proc_error',
2819: MESSAGE => fnd_message.get );
2820:
2821: END IF;
2822:
2823: RAISE;