155: IBE_UTIL.debug(' ERROR G_RET_STS_UNEXP_ERROR =' || FND_API.G_RET_STS_UNEXP_ERROR);
156: WHEN OTHERS THEN
157: IBE_UTIL.debug(' ERROR G_RET_STS_UNEXP_ERROR =' || FND_API.G_RET_STS_UNEXP_ERROR);
158:
159: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
160: FND_MESSAGE.Set_Token('ROUTINE', 'Search_Price_List');
161: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
162: FND_MESSAGE.Set_Token('REASON', SQLERRM);
163: FND_MSG_PUB.Add;
156: WHEN OTHERS THEN
157: IBE_UTIL.debug(' ERROR G_RET_STS_UNEXP_ERROR =' || FND_API.G_RET_STS_UNEXP_ERROR);
158:
159: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
160: FND_MESSAGE.Set_Token('ROUTINE', 'Search_Price_List');
161: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
162: FND_MESSAGE.Set_Token('REASON', SQLERRM);
163: FND_MSG_PUB.Add;
164:
157: IBE_UTIL.debug(' ERROR G_RET_STS_UNEXP_ERROR =' || FND_API.G_RET_STS_UNEXP_ERROR);
158:
159: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
160: FND_MESSAGE.Set_Token('ROUTINE', 'Search_Price_List');
161: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
162: FND_MESSAGE.Set_Token('REASON', SQLERRM);
163: FND_MSG_PUB.Add;
164:
165: END Search_Price_List;
158:
159: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
160: FND_MESSAGE.Set_Token('ROUTINE', 'Search_Price_List');
161: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
162: FND_MESSAGE.Set_Token('REASON', SQLERRM);
163: FND_MSG_PUB.Add;
164:
165: END Search_Price_List;
166: PROCEDURE Search_Currency