DBA Data[Home] [Help]

APPS.OKL_API dependencies on DBMS_TRANSACTION

Line 35: DBMS_TRANSACTION.SAVEPOINT(p_api_name || p_api_type);

31: x_return_status OUT NOCOPY VARCHAR2
32: ) RETURN VARCHAR2 IS
33: BEGIN
34: -- Standard START OF API SAVEPOINT
35: DBMS_TRANSACTION.SAVEPOINT(p_api_name || p_api_type);
36: IF NOT FND_API.compatible_API_Call( l_api_version,
37: p_api_version,
38: p_api_name,
39: p_pkg_name)

Line 55: DBMS_TRANSACTION.SAVEPOINT(p_api_name || p_api_type);

51: x_return_status OUT NOCOPY VARCHAR2
52: ) RETURN VARCHAR2 IS
53: BEGIN
54: -- Standard START OF API SAVEPOINT
55: DBMS_TRANSACTION.SAVEPOINT(p_api_name || p_api_type);
56: OKL_API.init_msg_list(p_init_msg_list);
57: x_return_status := OKL_API.G_RET_STS_SUCCESS;
58: RETURN(OKL_API.G_RET_STS_SUCCESS);
59: END start_activity;

Line 73: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(p_api_name || p_api_type);

69: p_api_type IN VARCHAR2
70: ) RETURN VARCHAR2 IS
71: l_return_value VARCHAR2(200) := OKL_API.G_RET_STS_UNEXP_ERROR;
72: BEGIN
73: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(p_api_name || p_api_type);
74: IF UPPER(p_exc_name) = 'OKL_API.G_RET_STS_ERROR' THEN
75: FND_MSG_PUB.Count_And_Get
76: (
77: p_count => x_msg_count,