DBA Data[Home] [Help]

APPS.FPA_VALIDATION_PVT dependencies on DBMS_TRANSACTION

Line 617: DBMS_TRANSACTION.SAVEPOINT(L_API_NAME || G_API_TYPE);

613: l_header_id NUMBER;
614:
615: BEGIN
616:
617: DBMS_TRANSACTION.SAVEPOINT(L_API_NAME || G_API_TYPE);
618:
619: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
620:
621: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

Line 692: DBMS_TRANSACTION.SAVEPOINT(L_API_NAME || G_API_TYPE);

688:
689: -- following commit and new savepoint not required
690: -- if header record can be created before transaction starts
691: commit;
692: DBMS_TRANSACTION.SAVEPOINT(L_API_NAME || G_API_TYPE);
693:
694: Check_Lock_Resource(
695: p_api_version => p_api_version,
696: p_init_msg_list => p_init_msg_list,

Line 774: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(L_API_NAME || G_API_TYPE);

770:
771: EXCEPTION
772: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
773: UnInitialize;
774: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(L_API_NAME || G_API_TYPE);
775:
776: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
777: p_api_name => l_api_name,
778: p_pkg_name => G_PKG_NAME,

Line 787: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(L_API_NAME || G_API_TYPE);

783: p_api_type => G_API_TYPE);
784:
785: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
786: UnInitialize;
787: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(L_API_NAME || G_API_TYPE);
788:
789: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
790: p_api_name => l_api_name,
791: p_pkg_name => G_PKG_NAME,

Line 800: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(L_API_NAME || G_API_TYPE);

796: p_api_type => G_API_TYPE);
797:
798: when OTHERS then
799: UnInitialize;
800: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(L_API_NAME || G_API_TYPE);
801:
802: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
803: p_api_name => l_api_name,
804: p_pkg_name => G_PKG_NAME,