170: CLOSE usages_csr;
171:
172: EXCEPTION
173: WHEN OTHERS THEN
174: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
175: THEN
176: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Insert_row');
177: END IF;
178: RAISE;
172: EXCEPTION
173: WHEN OTHERS THEN
174: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
175: THEN
176: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Insert_row');
177: END IF;
178: RAISE;
179:
180: END Insert_row;
199: RAISE NO_DATA_FOUND;
200: END IF;
201: EXCEPTION
202: WHEN OTHERS THEN
203: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
204: THEN
205: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Delete_row');
206: END IF;
207: RAISE;
201: EXCEPTION
202: WHEN OTHERS THEN
203: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
204: THEN
205: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Delete_row');
206: END IF;
207: RAISE;
208:
209: END Delete_row;
619: -- x_usage_curr_tbl.count );
620:
621: EXCEPTION
622: WHEN OTHERS THEN
623: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
624: THEN
625: FND_MSG_PUB.Add_Exc_Msg
626: ( G_PKG_NAME
627: , 'Get_Limit_Currency_usages'
621: EXCEPTION
622: WHEN OTHERS THEN
623: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
624: THEN
625: FND_MSG_PUB.Add_Exc_Msg
626: ( G_PKG_NAME
627: , 'Get_Limit_Currency_usages'
628: );
629: END IF;
847:
848:
849: EXCEPTION
850: WHEN OTHERS THEN
851: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
852: THEN
853: FND_MSG_PUB.Add_Exc_Msg
854: ( G_PKG_NAME
855: , 'get_usage_rules'
849: EXCEPTION
850: WHEN OTHERS THEN
851: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
852: THEN
853: FND_MSG_PUB.Add_Exc_Msg
854: ( G_PKG_NAME
855: , 'get_usage_rules'
856: );
857: END IF;