DBA Data[Home] [Help]

APPS.ASN_MIG_SALES_CREDITS_PVT dependencies on FND_MESSAGE

Line 235: errbuf := fnd_message.get;

231: -- If request submission failed, exit with error.
232: --
233: IF (l_req_id = 0) THEN
234:
235: errbuf := fnd_message.get;
236: retcode := 2;
237: RETURN;
238:
239: END IF;

Line 298: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

294: ROLLBACK;
295:
296: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
297:
298: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
299: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
300: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
301: FND_MESSAGE.Set_Token('REASON', SQLERRM);
302: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);

Line 299: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

295:
296: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
297:
298: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
299: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
300: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
301: FND_MESSAGE.Set_Token('REASON', SQLERRM);
302: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
303: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

Line 300: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

296: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
297:
298: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
299: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
300: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
301: FND_MESSAGE.Set_Token('REASON', SQLERRM);
302: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
303: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
304: l_api_name||':'||sqlcode||':'||sqlerrm);

Line 301: FND_MESSAGE.Set_Token('REASON', SQLERRM);

297:
298: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
299: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
300: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
301: FND_MESSAGE.Set_Token('REASON', SQLERRM);
302: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
303: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
304: l_api_name||':'||sqlcode||':'||sqlerrm);
305: END IF;

Line 692: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

688: ROLLBACK;
689:
690: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
691:
692: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
693: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
694: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
695: FND_MESSAGE.Set_Token('REASON', SQLERRM);
696: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);

Line 693: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

689:
690: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
691:
692: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
693: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
694: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
695: FND_MESSAGE.Set_Token('REASON', SQLERRM);
696: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
697: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

Line 694: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

690: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
691:
692: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
693: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
694: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
695: FND_MESSAGE.Set_Token('REASON', SQLERRM);
696: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
697: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
698: l_api_name||':'||sqlcode||':'||sqlerrm);

Line 695: FND_MESSAGE.Set_Token('REASON', SQLERRM);

691:
692: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
693: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
694: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
695: FND_MESSAGE.Set_Token('REASON', SQLERRM);
696: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
697: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
698: l_api_name||':'||sqlcode||':'||sqlerrm);
699:

Line 2019: errbuf := fnd_message.get;

2015: -- If request submission failed, exit with error.
2016: --
2017: IF (l_req_id = 0) THEN
2018:
2019: errbuf := fnd_message.get;
2020: retcode := 2;
2021: RETURN;
2022:
2023: END IF;

Line 2082: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

2078: ROLLBACK;
2079:
2080: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2081:
2082: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2083: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2084: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2085: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2086: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);

Line 2083: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

2079:
2080: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2081:
2082: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2083: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2084: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2085: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2086: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
2087: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

Line 2084: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

2080: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2081:
2082: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2083: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2084: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2085: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2086: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
2087: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2088: l_api_name||':'||sqlcode||':'||sqlerrm);

Line 2085: FND_MESSAGE.Set_Token('REASON', SQLERRM);

2081:
2082: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2083: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2084: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2085: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2086: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
2087: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2088: l_api_name||':'||sqlcode||':'||sqlerrm);
2089: END IF;