125: CLOSE c;
126:
127: EXCEPTION
128: WHEN OTHERS THEN
129: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
130: THEN
131: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Insert_Row');
132: END IF;
133: RAISE;
127: EXCEPTION
128: WHEN OTHERS THEN
129: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
130: THEN
131: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Insert_Row');
132: END IF;
133: RAISE;
134:
135: END INSERT_ROW;
195: WHEN record_changed THEN
196: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
197: APP_EXCEPTION.raise_exception;
198: WHEN OTHERS THEN
199: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
200: THEN
201: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Insert_Row');
202: END IF;
203: RAISE;
197: APP_EXCEPTION.raise_exception;
198: WHEN OTHERS THEN
199: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
200: THEN
201: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Insert_Row');
202: END IF;
203: RAISE;
204:
205: END LOCK_ROW;
249: END IF;
250:
251: EXCEPTION
252: WHEN OTHERS THEN
253: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
254: THEN
255: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Update_Row');
256: END IF;
257: RAISE;
251: EXCEPTION
252: WHEN OTHERS THEN
253: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
254: THEN
255: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Update_Row');
256: END IF;
257: RAISE;
258:
259: END Update_Row;
286: END IF;
287:
288: EXCEPTION
289: WHEN OTHERS THEN
290: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
291: THEN
292: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Delete_Row');
293: END IF;
294: RAISE;
288: EXCEPTION
289: WHEN OTHERS THEN
290: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
291: THEN
292: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Delete_Row');
293: END IF;
294: RAISE;
295:
296: END DELETE_ROW;
373: AND T.language = L.language_CODE);
374:
375: EXCEPTION
376: WHEN OTHERS THEN
377: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
378: THEN
379: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Add_Language');
380: END IF;
381: RAISE;
375: EXCEPTION
376: WHEN OTHERS THEN
377: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
378: THEN
379: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Add_Language');
380: END IF;
381: RAISE;
382:
383: END Add_Language;
410: AND userenv('LANG') IN (language, source_lang);
411:
412: EXCEPTION
413: WHEN OTHERS THEN
414: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
415: THEN
416: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Translate_Row');
417: END IF;
418: RAISE;
412: EXCEPTION
413: WHEN OTHERS THEN
414: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
415: THEN
416: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Translate_Row');
417: END IF;
418: RAISE;
419:
420: END Translate_Row;
475: END;
476:
477: EXCEPTION
478: WHEN OTHERS THEN
479: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
480: THEN
481: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Load_Row');
482: END IF;
483: RAISE;
477: EXCEPTION
478: WHEN OTHERS THEN
479: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
480: THEN
481: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Load_Row');
482: END IF;
483: RAISE;
484:
485: END Load_Row;