109:
110: EXCEPTION
111: WHEN OTHERS THEN
112: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
113: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
114: fnd_message.set_token('ORACLE_ERR',SQLERRM);
115: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
116: END IF;
117: raise;
110: EXCEPTION
111: WHEN OTHERS THEN
112: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
113: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
114: fnd_message.set_token('ORACLE_ERR',SQLERRM);
115: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
116: END IF;
117: raise;
118:
202:
203: EXCEPTION
204: WHEN OTHERS THEN
205: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
206: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
207: fnd_message.set_token('ORACLE_ERR',SQLERRM);
208: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
209: END IF;
210: raise;
203: EXCEPTION
204: WHEN OTHERS THEN
205: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
206: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
207: fnd_message.set_token('ORACLE_ERR',SQLERRM);
208: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
209: END IF;
210: raise;
211:
259:
260: EXCEPTION
261: WHEN OTHERS THEN
262: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
263: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
264: fnd_message.set_token('ORACLE_ERR',SQLERRM);
265: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
266: END IF;
267: RETURN FALSE;
260: EXCEPTION
261: WHEN OTHERS THEN
262: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
263: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
264: fnd_message.set_token('ORACLE_ERR',SQLERRM);
265: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
266: END IF;
267: RETURN FALSE;
268:
335: 'ERROR: Package Locked');
336: END IF;
337:
338: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
339: fnd_message.set_name('XLA','XLA_CMP_PACKAGE_LOCKED');
340: fnd_message.set_token('PACKAGE_NAME',p_package_name);
341: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
342: END IF;
343:
336: END IF;
337:
338: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
339: fnd_message.set_name('XLA','XLA_CMP_PACKAGE_LOCKED');
340: fnd_message.set_token('PACKAGE_NAME',p_package_name);
341: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
342: END IF;
343:
344: RETURN FALSE;
352: END IF;
353:
354:
355: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
356: fnd_message.set_name('XLA','XLA_CMP_COMPILATION_FAILED');
357: fnd_message.set_token('PACKAGE_NAME',p_package_name);
358: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
359: END IF;
360:
353:
354:
355: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
356: fnd_message.set_name('XLA','XLA_CMP_COMPILATION_FAILED');
357: fnd_message.set_token('PACKAGE_NAME',p_package_name);
358: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
359: END IF;
360:
361: RETURN FALSE;
361: RETURN FALSE;
362:
363: WHEN OTHERS THEN
364: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
365: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
366: fnd_message.set_token('ORACLE_ERR',SQLERRM);
367: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
368: END IF;
369:
362:
363: WHEN OTHERS THEN
364: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
365: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
366: fnd_message.set_token('ORACLE_ERR',SQLERRM);
367: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
368: END IF;
369:
370: RETURN FALSE;
436: 'ERROR: XLA_CMP_PACKAGE_LOCKED');
437: END IF;
438:
439: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
440: fnd_message.set_name('XLA','XLA_CMP_PACKAGE_LOCKED');
441: fnd_message.set_token('PACKAGE_NAME',p_package_name);
442: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
443: END IF;
444:
437: END IF;
438:
439: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
440: fnd_message.set_name('XLA','XLA_CMP_PACKAGE_LOCKED');
441: fnd_message.set_token('PACKAGE_NAME',p_package_name);
442: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
443: END IF;
444:
445: RETURN FALSE;
458: 'ERROR: XLA_CMP_COMPILATION_FAILED');
459: END IF;
460:
461: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
462: fnd_message.set_name('XLA','XLA_CMP_COMPILATION_FAILED');
463: fnd_message.set_token('PACKAGE_NAME',p_package_name);
464: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
465: END IF;
466:
459: END IF;
460:
461: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL ) THEN
462: fnd_message.set_name('XLA','XLA_CMP_COMPILATION_FAILED');
463: fnd_message.set_token('PACKAGE_NAME',p_package_name);
464: FND_LOG.MESSAGE (G_LEVEL_ERROR,G_MODULE_NAME||l_procedure_name,TRUE);
465: END IF;
466:
467: RETURN FALSE;
468:
469:
470: WHEN OTHERS THEN
471: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
472: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
473: fnd_message.set_token('ORACLE_ERR',SQLERRM);
474: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
475: END IF;
476:
469:
470: WHEN OTHERS THEN
471: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
472: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
473: fnd_message.set_token('ORACLE_ERR',SQLERRM);
474: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
475: END IF;
476:
477: return false;
537:
538: EXCEPTION
539: WHEN OTHERS THEN
540: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
541: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
542: fnd_message.set_token('ORACLE_ERR',SQLERRM);
543: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
544: END IF;
545:
538: EXCEPTION
539: WHEN OTHERS THEN
540: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
541: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
542: fnd_message.set_token('ORACLE_ERR',SQLERRM);
543: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
544: END IF;
545:
546: return false;
625:
626: EXCEPTION
627: WHEN OTHERS THEN
628: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
629: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
630: fnd_message.set_token('ORACLE_ERR',SQLERRM);
631: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
632: END IF;
633:
626: EXCEPTION
627: WHEN OTHERS THEN
628: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
629: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
630: fnd_message.set_token('ORACLE_ERR',SQLERRM);
631: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
632: END IF;
633:
634: return false;
685:
686: EXCEPTION
687: WHEN OTHERS THEN
688: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
689: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
690: fnd_message.set_token('ORACLE_ERR',SQLERRM);
691: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
692: END IF;
693:
686: EXCEPTION
687: WHEN OTHERS THEN
688: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
689: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
690: fnd_message.set_token('ORACLE_ERR',SQLERRM);
691: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
692: END IF;
693:
694: return false;
744:
745: WHEN compilation_fails THEN
746:
747: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
748: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
749: fnd_message.set_token('ORACLE_ERR',SQLERRM);
750: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
751: END IF;
752:
745: WHEN compilation_fails THEN
746:
747: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
748: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
749: fnd_message.set_token('ORACLE_ERR',SQLERRM);
750: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
751: END IF;
752:
753: RETURN FALSE;
754:
755: WHEN package_locked THEN
756:
757: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
758: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
759: fnd_message.set_token('ORACLE_ERR',SQLERRM);
760: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
761: END IF;
762:
755: WHEN package_locked THEN
756:
757: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
758: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
759: fnd_message.set_token('ORACLE_ERR',SQLERRM);
760: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
761: END IF;
762:
763: RETURN FALSE;
764:
765: WHEN OTHERS THEN
766:
767: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
768: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
769: fnd_message.set_token('ORACLE_ERR',SQLERRM);
770: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
771: END IF;
772:
765: WHEN OTHERS THEN
766:
767: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
768: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
769: fnd_message.set_token('ORACLE_ERR',SQLERRM);
770: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
771: END IF;
772:
773: RETURN FALSE;
830:
831: EXCEPTION
832: WHEN OTHERS THEN
833: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
834: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
835: fnd_message.set_token('ORACLE_ERR',SQLERRM);
836: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
837: END IF;
838:
831: EXCEPTION
832: WHEN OTHERS THEN
833: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
834: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
835: fnd_message.set_token('ORACLE_ERR',SQLERRM);
836: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
837: END IF;
838:
839: return false;
968:
969: EXCEPTION
970: WHEN le_compilation_fails THEN
971: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
972: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
973: fnd_message.set_token('ORACLE_ERR',SQLERRM);
974: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
975: END IF;
976:
969: EXCEPTION
970: WHEN le_compilation_fails THEN
971: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
972: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
973: fnd_message.set_token('ORACLE_ERR',SQLERRM);
974: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
975: END IF;
976:
977: -- BMR: need utility like xla_cmp_common_pkg.dump_text here
979: RETURN FALSE;
980:
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:
980:
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:
988: RETURN FALSE;