784: when others then
785: declare
786: module varchar2(50) := 'ap.oie_cc_validations_pkg.execute_update';
787: begin
788: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
789: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, module, sqlerrm);
790: end if;
791: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
792: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, module, 'stmt = '||p_stmt_str);
785: declare
786: module varchar2(50) := 'ap.oie_cc_validations_pkg.execute_update';
787: begin
788: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
789: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, module, sqlerrm);
790: end if;
791: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
792: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, module, 'stmt = '||p_stmt_str);
793: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, module, 'where = '||g_where_clause);
787: begin
788: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
789: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, module, sqlerrm);
790: end if;
791: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
792: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, module, 'stmt = '||p_stmt_str);
793: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, module, 'where = '||g_where_clause);
794: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, module, 'valid = '||l_validate_where);
795: end if;
788: if ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
789: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, module, sqlerrm);
790: end if;
791: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
792: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, module, 'stmt = '||p_stmt_str);
793: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, module, 'where = '||g_where_clause);
794: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, module, 'valid = '||l_validate_where);
795: end if;
796: end;
789: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, module, sqlerrm);
790: end if;
791: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
792: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, module, 'stmt = '||p_stmt_str);
793: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, module, 'where = '||g_where_clause);
794: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, module, 'valid = '||l_validate_where);
795: end if;
796: end;
797: raise;
790: end if;
791: if ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
792: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, module, 'stmt = '||p_stmt_str);
793: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, module, 'where = '||g_where_clause);
794: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, module, 'valid = '||l_validate_where);
795: end if;
796: end;
797: raise;
798: end execute_update;