DBA Data[Home] [Help]

APPS.PA_API dependencies on DBMS_TRANSACTION

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

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

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

57: ) RETURN VARCHAR2 IS
58: BEGIN
59: -- Standard START OF API SAVEPOINT
60:
61: DBMS_TRANSACTION.SAVEPOINT(p_api_name || p_api_type);
62: PA_API.init_msg_list(p_init_msg_list);
63:
64: x_return_status := PA_API.G_RET_STS_SUCCESS;
65: RETURN(PA_API.G_RET_STS_SUCCESS);

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

76: p_api_type IN VARCHAR2
77: ) RETURN VARCHAR2 IS
78: l_return_value VARCHAR2(200) := PA_API.G_RET_STS_UNEXP_ERROR;
79: BEGIN
80: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(p_api_name || p_api_type);
81: IF p_exc_name = 'PA_API.G_RET_STS_ERROR' THEN
82: FND_MSG_PUB.Count_And_Get
83: (
84: p_count => x_msg_count,