214:
215: EXCEPTION
216: WHEN others THEN
217: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
218: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
219: fnd_message.set_token('ORACLE_ERR',SQLERRM);
220: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
221: END IF;
222: raise;
215: EXCEPTION
216: WHEN others THEN
217: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
218: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
219: fnd_message.set_token('ORACLE_ERR',SQLERRM);
220: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
221: END IF;
222: raise;
223:
358:
359: EXCEPTION
360: WHEN others THEN
361: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
362: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
363: fnd_message.set_token('ORACLE_ERR',SQLERRM);
364: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
365: END IF;
366: raise;
359: EXCEPTION
360: WHEN others THEN
361: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
362: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
363: fnd_message.set_token('ORACLE_ERR',SQLERRM);
364: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
365: END IF;
366: raise;
367:
613:
614: EXCEPTION
615: WHEN others THEN
616: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
617: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
618: fnd_message.set_token('ORACLE_ERR',SQLERRM);
619: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
620: END IF;
621: raise;
614: EXCEPTION
615: WHEN others THEN
616: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
617: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
618: fnd_message.set_token('ORACLE_ERR',SQLERRM);
619: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
620: END IF;
621: raise;
622:
1086:
1087: EXCEPTION
1088: WHEN others THEN
1089: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1090: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1091: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1092: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1093: END IF;
1094: raise;
1087: EXCEPTION
1088: WHEN others THEN
1089: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1090: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1091: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1092: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1093: END IF;
1094: raise;
1095:
1581:
1582: EXCEPTION
1583: WHEN others THEN
1584: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1585: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1586: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1587: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1588: END IF;
1589: raise;
1582: EXCEPTION
1583: WHEN others THEN
1584: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1585: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1586: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1587: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1588: END IF;
1589: raise;
1590:
2004:
2005: EXCEPTION
2006: WHEN others THEN
2007: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
2008: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
2009: fnd_message.set_token('ORACLE_ERR',SQLERRM);
2010: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
2011: END IF;
2012: raise;
2005: EXCEPTION
2006: WHEN others THEN
2007: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
2008: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
2009: fnd_message.set_token('ORACLE_ERR',SQLERRM);
2010: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
2011: END IF;
2012: raise;
2013:
2406:
2407: EXCEPTION
2408: WHEN others THEN
2409: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
2410: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
2411: fnd_message.set_token('ORACLE_ERR',SQLERRM);
2412: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
2413: END IF;
2414: raise;
2407: EXCEPTION
2408: WHEN others THEN
2409: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
2410: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
2411: fnd_message.set_token('ORACLE_ERR',SQLERRM);
2412: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
2413: END IF;
2414: raise;
2415:
3065:
3066: EXCEPTION
3067: WHEN others THEN
3068: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
3069: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
3070: fnd_message.set_token('ORACLE_ERR',SQLERRM);
3071: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
3072: END IF;
3073: raise;
3066: EXCEPTION
3067: WHEN others THEN
3068: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
3069: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
3070: fnd_message.set_token('ORACLE_ERR',SQLERRM);
3071: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
3072: END IF;
3073: raise;
3074:
3436:
3437: EXCEPTION
3438: WHEN others THEN
3439: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
3440: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
3441: fnd_message.set_token('ORACLE_ERR',SQLERRM);
3442: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
3443: END IF;
3444: raise;
3437: EXCEPTION
3438: WHEN others THEN
3439: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
3440: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
3441: fnd_message.set_token('ORACLE_ERR',SQLERRM);
3442: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
3443: END IF;
3444: raise;
3445:
3807:
3808: EXCEPTION
3809: WHEN others THEN
3810: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
3811: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
3812: fnd_message.set_token('ORACLE_ERR',SQLERRM);
3813: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
3814: END IF;
3815: raise;
3808: EXCEPTION
3809: WHEN others THEN
3810: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
3811: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
3812: fnd_message.set_token('ORACLE_ERR',SQLERRM);
3813: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
3814: END IF;
3815: raise;
3816:
3855:
3856: EXCEPTION
3857: WHEN others THEN
3858: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
3859: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
3860: fnd_message.set_token('ORACLE_ERR',SQLERRM);
3861: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
3862: END IF;
3863: raise;
3856: EXCEPTION
3857: WHEN others THEN
3858: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
3859: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
3860: fnd_message.set_token('ORACLE_ERR',SQLERRM);
3861: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
3862: END IF;
3863: raise;
3864:
4275:
4276: EXCEPTION
4277: WHEN others THEN
4278: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
4279: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
4280: fnd_message.set_token('ORACLE_ERR',SQLERRM);
4281: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
4282: END IF;
4283: raise;
4276: EXCEPTION
4277: WHEN others THEN
4278: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
4279: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
4280: fnd_message.set_token('ORACLE_ERR',SQLERRM);
4281: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
4282: END IF;
4283: raise;
4284:
4321:
4322: EXCEPTION
4323: WHEN others THEN
4324: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
4325: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
4326: fnd_message.set_token('ORACLE_ERR',SQLERRM);
4327: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
4328: END IF;
4329: raise;
4322: EXCEPTION
4323: WHEN others THEN
4324: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
4325: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
4326: fnd_message.set_token('ORACLE_ERR',SQLERRM);
4327: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
4328: END IF;
4329: raise;
4330:
4430: raise;
4431:
4432: WHEN others THEN
4433: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
4434: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
4435: fnd_message.set_token('ORACLE_ERR',SQLERRM);
4436: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
4437: END IF;
4438: raise;
4431:
4432: WHEN others THEN
4433: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
4434: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
4435: fnd_message.set_token('ORACLE_ERR',SQLERRM);
4436: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
4437: END IF;
4438: raise;
4439: