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