149:
150: EXCEPTION
151: WHEN others THEN
152: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
153: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
154: fnd_message.set_token('ORACLE_ERR',SQLERRM);
155: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
156: END IF;
157: raise;
150: EXCEPTION
151: WHEN others THEN
152: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
153: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
154: fnd_message.set_token('ORACLE_ERR',SQLERRM);
155: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
156: END IF;
157: raise;
158:
206:
207: EXCEPTION
208: WHEN OTHERS THEN
209: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
210: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
211: fnd_message.set_token('ORACLE_ERR',SQLERRM);
212: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
213: END IF;
214: RAISE;
207: EXCEPTION
208: WHEN OTHERS THEN
209: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
210: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
211: fnd_message.set_token('ORACLE_ERR',SQLERRM);
212: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
213: END IF;
214: RAISE;
215:
260:
261: EXCEPTION
262: WHEN OTHERS THEN
263: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
264: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
265: fnd_message.set_token('ORACLE_ERR',SQLERRM);
266: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
267: END IF;
268: RAISE;
261: EXCEPTION
262: WHEN OTHERS THEN
263: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
264: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
265: fnd_message.set_token('ORACLE_ERR',SQLERRM);
266: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
267: END IF;
268: RAISE;
269:
508:
509: EXCEPTION
510: WHEN OTHERS THEN
511: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
512: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
513: fnd_message.set_token('ORACLE_ERR',SQLERRM);
514: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
515: END IF;
516: RAISE;
509: EXCEPTION
510: WHEN OTHERS THEN
511: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
512: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
513: fnd_message.set_token('ORACLE_ERR',SQLERRM);
514: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
515: END IF;
516: RAISE;
517:
706:
707: EXCEPTION
708: WHEN OTHERS THEN
709: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
710: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
711: fnd_message.set_token('ORACLE_ERR',SQLERRM);
712: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
713: END IF;
714: RAISE;
707: EXCEPTION
708: WHEN OTHERS THEN
709: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
710: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
711: fnd_message.set_token('ORACLE_ERR',SQLERRM);
712: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
713: END IF;
714: RAISE;
715: END;