108:
109: EXCEPTION
110: WHEN OTHERS THEN
111: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
112: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
113: fnd_message.set_token('ORACLE_ERR',SQLERRM);
114: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
115: END IF;
116: raise;
109: EXCEPTION
110: WHEN OTHERS THEN
111: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
112: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
113: fnd_message.set_token('ORACLE_ERR',SQLERRM);
114: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
115: END IF;
116: raise;
117:
201:
202: EXCEPTION
203: WHEN OTHERS THEN
204: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
205: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
206: fnd_message.set_token('ORACLE_ERR',SQLERRM);
207: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
208: END IF;
209: raise;
202: EXCEPTION
203: WHEN OTHERS THEN
204: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
205: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
206: fnd_message.set_token('ORACLE_ERR',SQLERRM);
207: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
208: END IF;
209: raise;
210:
258:
259: EXCEPTION
260: WHEN OTHERS THEN
261: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
262: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
263: fnd_message.set_token('ORACLE_ERR',SQLERRM);
264: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
265: END IF;
266: RETURN FALSE;
259: EXCEPTION
260: WHEN OTHERS THEN
261: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
262: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
263: fnd_message.set_token('ORACLE_ERR',SQLERRM);
264: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
265: END IF;
266: RETURN FALSE;
267:
333: 'ERROR: Package Locked');
334: END IF;
335:
336: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
337: fnd_message.set_name('XLA','XLA_CMP_PACKAGE_LOCKED');
338: fnd_message.set_token('PACKAGE_NAME',p_package_name);
339: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
340: END IF;
341:
334: END IF;
335:
336: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
337: fnd_message.set_name('XLA','XLA_CMP_PACKAGE_LOCKED');
338: fnd_message.set_token('PACKAGE_NAME',p_package_name);
339: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
340: END IF;
341:
342: RETURN FALSE;
349: 'ERROR: Package Compilation Failed');
350: END IF;
351:
352: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
353: fnd_message.set_name('XLA','XLA_CMP_COMPILATION_FAILED');
354: fnd_message.set_token('PACKAGE_NAME',p_package_name);
355: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
356: END IF;
357:
350: END IF;
351:
352: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
353: fnd_message.set_name('XLA','XLA_CMP_COMPILATION_FAILED');
354: fnd_message.set_token('PACKAGE_NAME',p_package_name);
355: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
356: END IF;
357:
358: RETURN FALSE;
358: RETURN FALSE;
359:
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:
359:
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:
367: RETURN FALSE;
426: 'ERROR: XLA_CMP_PACKAGE_LOCKED');
427: END IF;
428:
429: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
430: fnd_message.set_name('XLA','XLA_CMP_PACKAGE_LOCKED');
431: fnd_message.set_token('PACKAGE_NAME',p_package_name);
432: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
433: END IF;
434:
427: END IF;
428:
429: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
430: fnd_message.set_name('XLA','XLA_CMP_PACKAGE_LOCKED');
431: fnd_message.set_token('PACKAGE_NAME',p_package_name);
432: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
433: END IF;
434:
435: RETURN FALSE;
448: 'ERROR: XLA_CMP_COMPILATION_FAILED');
449: END IF;
450:
451: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
452: fnd_message.set_name('XLA','XLA_CMP_COMPILATION_FAILED');
453: fnd_message.set_token('PACKAGE_NAME',p_package_name);
454: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
455: END IF;
456:
449: END IF;
450:
451: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
452: fnd_message.set_name('XLA','XLA_CMP_COMPILATION_FAILED');
453: fnd_message.set_token('PACKAGE_NAME',p_package_name);
454: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
455: END IF;
456:
457: RETURN FALSE;
457: RETURN FALSE;
458:
459: WHEN OTHERS THEN
460: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
461: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
462: fnd_message.set_token('ORACLE_ERR',SQLERRM);
463: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
464: END IF;
465:
458:
459: WHEN OTHERS THEN
460: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
461: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
462: fnd_message.set_token('ORACLE_ERR',SQLERRM);
463: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
464: END IF;
465:
466: return false;
526:
527: EXCEPTION
528: WHEN OTHERS THEN
529: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
530: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
531: fnd_message.set_token('ORACLE_ERR',SQLERRM);
532: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
533: END IF;
534:
527: EXCEPTION
528: WHEN OTHERS THEN
529: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
530: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
531: fnd_message.set_token('ORACLE_ERR',SQLERRM);
532: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
533: END IF;
534:
535: return false;
614:
615: EXCEPTION
616: WHEN OTHERS THEN
617: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
618: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
619: fnd_message.set_token('ORACLE_ERR',SQLERRM);
620: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
621: END IF;
622:
615: EXCEPTION
616: WHEN OTHERS THEN
617: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
618: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
619: fnd_message.set_token('ORACLE_ERR',SQLERRM);
620: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
621: END IF;
622:
623: return false;
674:
675: EXCEPTION
676: WHEN OTHERS THEN
677: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
678: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
679: fnd_message.set_token('ORACLE_ERR',SQLERRM);
680: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
681: END IF;
682:
675: EXCEPTION
676: WHEN OTHERS THEN
677: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
678: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
679: fnd_message.set_token('ORACLE_ERR',SQLERRM);
680: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
681: END IF;
682:
683: return false;
732:
733: WHEN compilation_fails THEN
734:
735: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
736: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
737: fnd_message.set_token('ORACLE_ERR',SQLERRM);
738: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
739: END IF;
740:
733: WHEN compilation_fails THEN
734:
735: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
736: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
737: fnd_message.set_token('ORACLE_ERR',SQLERRM);
738: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
739: END IF;
740:
741: RETURN FALSE;
742:
743: WHEN package_locked THEN
744:
745: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
746: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
747: fnd_message.set_token('ORACLE_ERR',SQLERRM);
748: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
749: END IF;
750:
743: WHEN package_locked THEN
744:
745: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
746: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
747: fnd_message.set_token('ORACLE_ERR',SQLERRM);
748: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
749: END IF;
750:
751: RETURN FALSE;
752:
753: WHEN OTHERS THEN
754:
755: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
756: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
757: fnd_message.set_token('ORACLE_ERR',SQLERRM);
758: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
759: END IF;
760:
753: WHEN OTHERS THEN
754:
755: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
756: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
757: fnd_message.set_token('ORACLE_ERR',SQLERRM);
758: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
759: END IF;
760:
761: RETURN FALSE;
818:
819: EXCEPTION
820: WHEN OTHERS THEN
821: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
822: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
823: fnd_message.set_token('ORACLE_ERR',SQLERRM);
824: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
825: END IF;
826:
819: EXCEPTION
820: WHEN OTHERS THEN
821: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
822: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
823: fnd_message.set_token('ORACLE_ERR',SQLERRM);
824: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
825: END IF;
826:
827: return false;
956:
957: EXCEPTION
958: WHEN le_compilation_fails THEN
959: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
960: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
961: fnd_message.set_token('ORACLE_ERR',SQLERRM);
962: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
963: END IF;
964:
957: EXCEPTION
958: WHEN le_compilation_fails THEN
959: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
960: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
961: fnd_message.set_token('ORACLE_ERR',SQLERRM);
962: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
963: END IF;
964:
965: -- BMR: need utility like xla_cmp_common_pkg.dump_text here
967: RETURN FALSE;
968:
969: WHEN OTHERS THEN
970: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
971: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
972: fnd_message.set_token('ORACLE_ERR',SQLERRM);
973: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
974: END IF;
975:
968:
969: WHEN OTHERS THEN
970: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
971: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
972: fnd_message.set_token('ORACLE_ERR',SQLERRM);
973: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
974: END IF;
975:
976: RETURN FALSE;