APPS.IBC_CTYPE_PVT dependencies on DBMS_TRANSACTION

Line 136: DBMS_TRANSACTION.SAVEPOINT(l_api_name);

132: l_Does_Description_exist BOOLEAN := FALSE;
133:
134: BEGIN
135: -- Standard Start of API savepoint
136: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
137: --SAVEPOINT l_api_name;
138: -- Initialize API return status to SUCCESS
139: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
140:

Line 394: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

390: );
391:
392: EXCEPTION
393: WHEN Fnd_Api.G_EXC_ERROR THEN
394: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
395: --ROLLBACK TO SAVEPOINT l_api_name;
396: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
397: P_API_name => L_API_name
398: ,P_PKG_name => G_PKG_name

Line 408: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

404: ,X_MSG_DATA => X_MSG_DATA
405: ,X_RETURN_STATUS => X_RETURN_STATUS);
406:
407: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
408: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
409: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
410: P_API_name => L_API_name
411: ,P_PKG_name => G_PKG_name
412: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR

Line 421: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

417: ,X_MSG_DATA => X_MSG_DATA
418: ,X_RETURN_STATUS => X_RETURN_STATUS);
419:
420: WHEN OTHERS THEN
421: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
422: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
423: P_API_name => L_API_name
424: ,P_PKG_name => G_PKG_name
425: ,P_EXCEPTION_LEVEL => Ibc_Utilities_Pvt.G_EXC_OTHERS