213: close c_events;
214: END IF;
215:
216: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
217: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
218: fnd_message.set_token('ORACLE_ERR',SQLERRM);
219: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
220: END IF;
221: raise;
214: END IF;
215:
216: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
217: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
218: fnd_message.set_token('ORACLE_ERR',SQLERRM);
219: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
220: END IF;
221: raise;
222:
278:
279: EXCEPTION
280: WHEN OTHERS THEN
281: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
282: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
283: fnd_message.set_token('ORACLE_ERR',SQLERRM);
284: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
285: END IF;
286: RAISE;
279: EXCEPTION
280: WHEN OTHERS THEN
281: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
282: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
283: fnd_message.set_token('ORACLE_ERR',SQLERRM);
284: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
285: END IF;
286: RAISE;
287:
340:
341: EXCEPTION
342: WHEN OTHERS THEN
343: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
344: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
345: fnd_message.set_token('ORACLE_ERR',SQLERRM);
346: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
347: END IF;
348: RAISE;
341: EXCEPTION
342: WHEN OTHERS THEN
343: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
344: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
345: fnd_message.set_token('ORACLE_ERR',SQLERRM);
346: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
347: END IF;
348: RAISE;
349:
603:
604: EXCEPTION
605: WHEN OTHERS THEN
606: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
607: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
608: fnd_message.set_token('ORACLE_ERR',SQLERRM);
609: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
610: END IF;
611: RAISE;
604: EXCEPTION
605: WHEN OTHERS THEN
606: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
607: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
608: fnd_message.set_token('ORACLE_ERR',SQLERRM);
609: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
610: END IF;
611: RAISE;
612:
811:
812: EXCEPTION
813: WHEN OTHERS THEN
814: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
815: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
816: fnd_message.set_token('ORACLE_ERR',SQLERRM);
817: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
818: END IF;
819: RAISE;
812: EXCEPTION
813: WHEN OTHERS THEN
814: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
815: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
816: fnd_message.set_token('ORACLE_ERR',SQLERRM);
817: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
818: END IF;
819: RAISE;
820: END;