DBA Data[Home] [Help]

APPS.OKS_AUTH_UTIL_PVT dependencies on DBMS_TRANSACTION

Line 9607: DBMS_TRANSACTION.SAVEPOINT('REVALUE_PRICE');

9603:
9604: END IF;
9605:
9606: -- Make a save point, in case of error rollback
9607: DBMS_TRANSACTION.SAVEPOINT('REVALUE_PRICE');
9608:
9609: x_return_status := OKC_API.G_RET_STS_SUCCESS;
9610: /*
9611: SELECT Nvl(conversion_rate, 1)

Line 9817: DBMS_TRANSACTION.rollback_savepoint('REVALUE_PRICE');

9813: 'exception raised in revalue contract ');
9814: FND_LOG.string(FND_LOG.level_procedure, l_mod_name, 'Leaving 100 ');
9815: END IF;
9816:
9817: DBMS_TRANSACTION.rollback_savepoint('REVALUE_PRICE');
9818:
9819: WHEN OTHERS THEN
9820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9821: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 9828: DBMS_TRANSACTION.rollback_savepoint('REVALUE_PRICE');

9824: 'error at revalue contract l_return_status=' ||
9825: x_return_status);
9826: FND_LOG.string(FND_LOG.level_procedure, l_mod_name, 'Leaving 200 ');
9827: END IF;
9828: DBMS_TRANSACTION.rollback_savepoint('REVALUE_PRICE');
9829:
9830: END REVALUE_CONTRACT;
9831:
9832: /*============================================================================+