DBA Data[Home] [Help]

APPS.OKS_IBINT_PUB dependencies on DBMS_TRANSACTION

Line 3717: DBMS_TRANSACTION.SAVEPOINT(l_api_name || l_api_type);

3713: RETURN (l_formatted_invoice_text);
3714: END getformattedinvoicetext;
3715:
3716: BEGIN
3717: DBMS_TRANSACTION.SAVEPOINT(l_api_name || l_api_type);
3718: /*Ensure that the contract is in entered statuses ste_code.*/
3719: OPEN chk_sts(p_chr_id);
3720: FETCH chk_sts INTO l_k_sts;
3721: CLOSE chk_sts;

Line 4029: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || l_api_type);

4025: EXCEPTION
4026: WHEN g_exception_halt_validation
4027: THEN
4028: x_return_status := l_return_status;
4029: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || l_api_type);
4030: NULL;
4031: WHEN OTHERS
4032: THEN
4033: x_msg_data := 'Unexpected error during OKS cov level creation';

Line 4035: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || l_api_type);

4031: WHEN OTHERS
4032: THEN
4033: x_msg_data := 'Unexpected error during OKS cov level creation';
4034: x_return_status := okc_api.g_ret_sts_unexp_error;
4035: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || l_api_type);
4036: okc_api.set_message (g_app_name,
4037: g_unexpected_error,
4038: g_sqlcode_token,
4039: SQLCODE,