DBA Data[Home] [Help]

APPS.IBE_CATALOG_PRELOAD_PUB dependencies on FND_MESSAGE

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

110: --gzhang 08/08/2002, bug#2488246
111: --ibe_util.disable_debug;
112: WHEN OTHERS THEN
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
115: FND_MESSAGE.Set_Token('ROUTINE', l_api_name || '4');
116: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
117: FND_MESSAGE.Set_Token('REASON', SQLERRM);
118: FND_MSG_PUB.Add;

Line 115: FND_MESSAGE.Set_Token('ROUTINE', l_api_name || '4');

111: --ibe_util.disable_debug;
112: WHEN OTHERS THEN
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
115: FND_MESSAGE.Set_Token('ROUTINE', l_api_name || '4');
116: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
117: FND_MESSAGE.Set_Token('REASON', SQLERRM);
118: FND_MSG_PUB.Add;
119: IF FND_MSG_PUB.Check_Msg_Level

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

112: WHEN OTHERS THEN
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
115: FND_MESSAGE.Set_Token('ROUTINE', l_api_name || '4');
116: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
117: FND_MESSAGE.Set_Token('REASON', SQLERRM);
118: FND_MSG_PUB.Add;
119: IF FND_MSG_PUB.Check_Msg_Level
120: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
115: FND_MESSAGE.Set_Token('ROUTINE', l_api_name || '4');
116: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
117: FND_MESSAGE.Set_Token('REASON', SQLERRM);
118: FND_MSG_PUB.Add;
119: IF FND_MSG_PUB.Check_Msg_Level
120: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
121: THEN FND_MSG_PUB.Add_Exc_Msg

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

238: --gzhang 08/08/2002, bug#2488246
239: --ibe_util.disable_debug;
240: WHEN OTHERS THEN
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
243: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
244: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
245: FND_MESSAGE.Set_Token('REASON', SQLERRM);
246: FND_MSG_PUB.Add;

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

239: --ibe_util.disable_debug;
240: WHEN OTHERS THEN
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
243: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
244: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
245: FND_MESSAGE.Set_Token('REASON', SQLERRM);
246: FND_MSG_PUB.Add;
247: IF FND_MSG_PUB.Check_Msg_Level

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

240: WHEN OTHERS THEN
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
243: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
244: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
245: FND_MESSAGE.Set_Token('REASON', SQLERRM);
246: FND_MSG_PUB.Add;
247: IF FND_MSG_PUB.Check_Msg_Level
248: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
243: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
244: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
245: FND_MESSAGE.Set_Token('REASON', SQLERRM);
246: FND_MSG_PUB.Add;
247: IF FND_MSG_PUB.Check_Msg_Level
248: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
249: THEN FND_MSG_PUB.Add_Exc_Msg