156:
157: EXCEPTION
158: WHEN others THEN
159: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
160: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
161: fnd_message.set_token('ORACLE_ERR',SQLERRM);
162: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
163: END IF;
164: raise;
157: EXCEPTION
158: WHEN others THEN
159: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
160: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
161: fnd_message.set_token('ORACLE_ERR',SQLERRM);
162: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
163: END IF;
164: raise;
165:
254:
255: EXCEPTION
256: WHEN others THEN
257: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
258: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
259: fnd_message.set_token('ORACLE_ERR',SQLERRM);
260: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
261: END IF;
262: raise;
255: EXCEPTION
256: WHEN others THEN
257: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
258: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
259: fnd_message.set_token('ORACLE_ERR',SQLERRM);
260: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
261: END IF;
262: raise;
263:
542:
543: EXCEPTION
544: WHEN others THEN
545: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
546: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
547: fnd_message.set_token('ORACLE_ERR',SQLERRM);
548: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
549: END IF;
550: raise;
543: EXCEPTION
544: WHEN others THEN
545: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
546: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
547: fnd_message.set_token('ORACLE_ERR',SQLERRM);
548: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
549: END IF;
550: raise;
551:
590:
591: EXCEPTION
592: WHEN others THEN
593: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
594: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
595: fnd_message.set_token('ORACLE_ERR',SQLERRM);
596: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
597: END IF;
598: raise;
591: EXCEPTION
592: WHEN others THEN
593: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
594: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
595: fnd_message.set_token('ORACLE_ERR',SQLERRM);
596: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
597: END IF;
598: raise;
599:
960:
961: EXCEPTION
962: WHEN others THEN
963: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
964: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
965: fnd_message.set_token('ORACLE_ERR',SQLERRM);
966: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
967: END IF;
968: raise;
961: EXCEPTION
962: WHEN others THEN
963: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
964: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
965: fnd_message.set_token('ORACLE_ERR',SQLERRM);
966: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
967: END IF;
968: raise;
969:
1006:
1007: EXCEPTION
1008: WHEN others THEN
1009: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1010: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1011: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1012: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1013: END IF;
1014: raise;
1007: EXCEPTION
1008: WHEN others THEN
1009: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1010: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1011: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1012: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1013: END IF;
1014: raise;
1015:
1092: raise;
1093:
1094: WHEN others THEN
1095: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1096: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1097: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1098: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1099: END IF;
1100: raise;
1093:
1094: WHEN others THEN
1095: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1096: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1097: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1098: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1099: END IF;
1100: raise;
1101: