144:
145: EXCEPTION
146: WHEN others THEN
147: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
148: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
149: fnd_message.set_token('ORACLE_ERR',SQLERRM);
150: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
151: END IF;
152: raise;
145: EXCEPTION
146: WHEN others THEN
147: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
148: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
149: fnd_message.set_token('ORACLE_ERR',SQLERRM);
150: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
151: END IF;
152: raise;
153:
230:
231: EXCEPTION
232: WHEN others THEN
233: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
234: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
235: fnd_message.set_token('ORACLE_ERR',SQLERRM);
236: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
237: END IF;
238: raise;
231: EXCEPTION
232: WHEN others THEN
233: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
234: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
235: fnd_message.set_token('ORACLE_ERR',SQLERRM);
236: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
237: END IF;
238: raise;
239:
375:
376: EXCEPTION
377: WHEN others THEN
378: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
379: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
380: fnd_message.set_token('ORACLE_ERR',SQLERRM);
381: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
382: END IF;
383: raise;
376: EXCEPTION
377: WHEN others THEN
378: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
379: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
380: fnd_message.set_token('ORACLE_ERR',SQLERRM);
381: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
382: END IF;
383: raise;
384:
607:
608: EXCEPTION
609: WHEN others THEN
610: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
611: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
612: fnd_message.set_token('ORACLE_ERR',SQLERRM);
613: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
614: END IF;
615: raise;
608: EXCEPTION
609: WHEN others THEN
610: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
611: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
612: fnd_message.set_token('ORACLE_ERR',SQLERRM);
613: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
614: END IF;
615: raise;
616:
979:
980: EXCEPTION
981: WHEN others THEN
982: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
983: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
984: fnd_message.set_token('ORACLE_ERR',SQLERRM);
985: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
986: END IF;
987: raise;
980: EXCEPTION
981: WHEN others THEN
982: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
983: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
984: fnd_message.set_token('ORACLE_ERR',SQLERRM);
985: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
986: END IF;
987: raise;
988:
1315:
1316: EXCEPTION
1317: WHEN others THEN
1318: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1319: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1320: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1321: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1322: END IF;
1323: raise;
1316: EXCEPTION
1317: WHEN others THEN
1318: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1319: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1320: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1321: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1322: END IF;
1323: raise;
1324:
1630:
1631: EXCEPTION
1632: WHEN others THEN
1633: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1634: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1635: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1636: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1637: END IF;
1638: raise;
1631: EXCEPTION
1632: WHEN others THEN
1633: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1634: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1635: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1636: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1637: END IF;
1638: raise;
1639:
2168:
2169: EXCEPTION
2170: WHEN others THEN
2171: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
2172: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
2173: fnd_message.set_token('ORACLE_ERR',SQLERRM);
2174: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
2175: END IF;
2176: raise;
2169: EXCEPTION
2170: WHEN others THEN
2171: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
2172: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
2173: fnd_message.set_token('ORACLE_ERR',SQLERRM);
2174: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
2175: END IF;
2176: raise;
2177:
2475:
2476: EXCEPTION
2477: WHEN others THEN
2478: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
2479: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
2480: fnd_message.set_token('ORACLE_ERR',SQLERRM);
2481: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
2482: END IF;
2483: raise;
2476: EXCEPTION
2477: WHEN others THEN
2478: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
2479: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
2480: fnd_message.set_token('ORACLE_ERR',SQLERRM);
2481: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
2482: END IF;
2483: raise;
2484:
2782:
2783: EXCEPTION
2784: WHEN others THEN
2785: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
2786: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
2787: fnd_message.set_token('ORACLE_ERR',SQLERRM);
2788: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
2789: END IF;
2790: raise;
2783: EXCEPTION
2784: WHEN others THEN
2785: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
2786: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
2787: fnd_message.set_token('ORACLE_ERR',SQLERRM);
2788: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
2789: END IF;
2790: raise;
2791:
2830:
2831: EXCEPTION
2832: WHEN others THEN
2833: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
2834: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
2835: fnd_message.set_token('ORACLE_ERR',SQLERRM);
2836: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
2837: END IF;
2838: raise;
2831: EXCEPTION
2832: WHEN others THEN
2833: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
2834: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
2835: fnd_message.set_token('ORACLE_ERR',SQLERRM);
2836: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
2837: END IF;
2838: raise;
2839:
3124:
3125: EXCEPTION
3126: WHEN others THEN
3127: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
3128: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
3129: fnd_message.set_token('ORACLE_ERR',SQLERRM);
3130: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
3131: END IF;
3132: raise;
3125: EXCEPTION
3126: WHEN others THEN
3127: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
3128: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
3129: fnd_message.set_token('ORACLE_ERR',SQLERRM);
3130: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
3131: END IF;
3132: raise;
3133:
3170:
3171: EXCEPTION
3172: WHEN others THEN
3173: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
3174: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
3175: fnd_message.set_token('ORACLE_ERR',SQLERRM);
3176: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
3177: END IF;
3178: raise;
3171: EXCEPTION
3172: WHEN others THEN
3173: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
3174: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
3175: fnd_message.set_token('ORACLE_ERR',SQLERRM);
3176: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
3177: END IF;
3178: raise;
3179:
3279: raise;
3280:
3281: WHEN others THEN
3282: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
3283: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
3284: fnd_message.set_token('ORACLE_ERR',SQLERRM);
3285: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
3286: END IF;
3287: raise;
3280:
3281: WHEN others THEN
3282: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
3283: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
3284: fnd_message.set_token('ORACLE_ERR',SQLERRM);
3285: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
3286: END IF;
3287: raise;
3288: