91: END IF;
92: CLOSE c;
93: EXCEPTION
94: WHEN OTHERS THEN
95: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
96: THEN
97: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Insert_row');
98: END IF;
99: RAISE;
93: EXCEPTION
94: WHEN OTHERS THEN
95: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
96: THEN
97: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Insert_row');
98: END IF;
99: RAISE;
100:
101: END Insert_row;
189: RAISE NO_DATA_FOUND;
190: END IF;
191: EXCEPTION
192: WHEN OTHERS THEN
193: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
194: THEN
195: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Update_row');
196: END IF;
197: RAISE;
191: EXCEPTION
192: WHEN OTHERS THEN
193: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
194: THEN
195: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Update_row');
196: END IF;
197: RAISE;
198:
199: END Update_Row;
218: RAISE NO_DATA_FOUND;
219: END IF;
220: EXCEPTION
221: WHEN OTHERS THEN
222: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
223: THEN
224: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Delete_row');
225: END IF;
226: RAISE;
220: EXCEPTION
221: WHEN OTHERS THEN
222: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
223: THEN
224: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,'Delete_row');
225: END IF;
226: RAISE;
227:
228: END Delete_row;