104: CLOSE c;
105:
106: EXCEPTION
107: WHEN OTHERS THEN
108: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
109: THEN
110: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Insert_Row');
111: END IF;
112: RAISE;
106: EXCEPTION
107: WHEN OTHERS THEN
108: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
109: THEN
110: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Insert_Row');
111: END IF;
112: RAISE;
113:
114: END Insert_Row;
175: WHEN record_changed THEN
176: FND_MESSAGE.set_name('FND', 'FORM_RECORD_CHANGED');
177: APP_EXCEPTION.raise_exception;
178: WHEN OTHERS THEN
179: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
180: THEN
181: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Lock_Row');
182: END IF;
183: RAISE;
177: APP_EXCEPTION.raise_exception;
178: WHEN OTHERS THEN
179: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
180: THEN
181: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Lock_Row');
182: END IF;
183: RAISE;
184:
185: END Lock_Row;
222: END IF;
223:
224: EXCEPTION
225: WHEN OTHERS THEN
226: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
227: THEN
228: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Update_Row');
229: END IF;
230: RAISE;
224: EXCEPTION
225: WHEN OTHERS THEN
226: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
227: THEN
228: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Update_Row');
229: END IF;
230: RAISE;
231:
232: END Update_row;
253: EXCEPTION
254: WHEN NO_DATA_FOUND THEN
255: NULL;
256: WHEN OTHERS THEN
257: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
258: THEN
259: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Delete_Row'||substr(sqlerrm,1,100));
260: END IF;
261: RAISE;
255: NULL;
256: WHEN OTHERS THEN
257: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
258: THEN
259: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Delete_Row'||substr(sqlerrm,1,100));
260: END IF;
261: RAISE;
262:
263: END Delete_row;