215: RETURN l_user_name;
216:
217: WHEN OTHERS THEN
218: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
219: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
220: fnd_message.set_token('ORACLE_ERR',SQLERRM);
221: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
222: END IF;
223: raise;
216:
217: WHEN OTHERS THEN
218: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
219: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
220: fnd_message.set_token('ORACLE_ERR',SQLERRM);
221: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
222: END IF;
223: raise;
224:
311:
312: EXCEPTION
313: WHEN OTHERS THEN
314: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
315: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
316: fnd_message.set_token('ORACLE_ERR',SQLERRM);
317: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
318: END IF;
319: raise;
312: EXCEPTION
313: WHEN OTHERS THEN
314: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
315: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
316: fnd_message.set_token('ORACLE_ERR',SQLERRM);
317: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
318: END IF;
319: raise;
320:
386: EXCEPTION
387:
388: WHEN OTHERS THEN
389: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
390: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
391: fnd_message.set_token('ORACLE_ERR',SQLERRM);
392: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
393: END IF;
394: raise;
387:
388: WHEN OTHERS THEN
389: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
390: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
391: fnd_message.set_token('ORACLE_ERR',SQLERRM);
392: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
393: END IF;
394: raise;
395:
445: EXCEPTION
446:
447: WHEN OTHERS THEN
448: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
449: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
450: fnd_message.set_token('ORACLE_ERR',SQLERRM);
451: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
452: END IF;
453: return false;
446:
447: WHEN OTHERS THEN
448: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
449: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
450: fnd_message.set_token('ORACLE_ERR',SQLERRM);
451: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
452: END IF;
453: return false;
454:
517:
518: EXCEPTION
519: WHEN OTHERS THEN
520: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
521: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
522: fnd_message.set_token('ORACLE_ERR',SQLERRM);
523: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
524: END IF;
525: return FALSE;
518: EXCEPTION
519: WHEN OTHERS THEN
520: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
521: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
522: fnd_message.set_token('ORACLE_ERR',SQLERRM);
523: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
524: END IF;
525: return FALSE;
526:
735:
736: EXCEPTION
737: WHEN OTHERS THEN
738: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
739: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
740: fnd_message.set_token('ORACLE_ERR',SQLERRM);
741: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
742: END IF;
743: return false;
736: EXCEPTION
737: WHEN OTHERS THEN
738: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
739: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
740: fnd_message.set_token('ORACLE_ERR',SQLERRM);
741: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
742: END IF;
743: return false;
744:
803:
804: EXCEPTION
805: WHEN OTHERS THEN
806: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
807: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
808: fnd_message.set_token('ORACLE_ERR',SQLERRM);
809: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
810: END IF;
811: return false;
804: EXCEPTION
805: WHEN OTHERS THEN
806: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
807: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
808: fnd_message.set_token('ORACLE_ERR',SQLERRM);
809: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
810: END IF;
811: return false;
812:
916:
917: EXCEPTION
918: WHEN OTHERS THEN
919: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
920: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
921: fnd_message.set_token('ORACLE_ERR',SQLERRM);
922: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
923: END IF;
924: RETURN FALSE;
917: EXCEPTION
918: WHEN OTHERS THEN
919: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
920: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
921: fnd_message.set_token('ORACLE_ERR',SQLERRM);
922: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
923: END IF;
924: RETURN FALSE;
925:
984:
985: EXCEPTION
986: WHEN OTHERS THEN
987: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
988: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
989: fnd_message.set_token('ORACLE_ERR',SQLERRM);
990: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
991: END IF;
992:
985: EXCEPTION
986: WHEN OTHERS THEN
987: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
988: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
989: fnd_message.set_token('ORACLE_ERR',SQLERRM);
990: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
991: END IF;
992:
993: return false;
1111:
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1115: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1116: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1117: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1118: END IF;
1119: RETURN FALSE;
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1115: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1116: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1117: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1118: END IF;
1119: RETURN FALSE;
1120: