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