DBA Data[Home] [Help]

APPS.OKS_REPRICE_PVT dependencies on DBMS_TRANSACTION

Line 2104: DBMS_TRANSACTION.SAVEPOINT ('REPRICE_OKS');

2100: oks_renew_pvt.debug_log (p_program_name => 'Reprice',
2101: p_perf_msg => 'Markup Percent: ' ||
2102: p_reprice_rec.markup_percent);
2103: -- Make a save point, in case of error rollback
2104: DBMS_TRANSACTION.SAVEPOINT ('REPRICE_OKS');
2105: --Added by jvorugan begin new logic for Partial Periods
2106:
2107: -- Bug 5139658
2108:

Line 2880: DBMS_TRANSACTION.rollback_savepoint ('REPRICE_OKS');

2876: l_api_name
2877: );
2878: END IF;
2879:
2880: DBMS_TRANSACTION.rollback_savepoint ('REPRICE_OKS');
2881:
2882: IF l_line_csr%ISOPEN THEN
2883: CLOSE l_line_csr;
2884: END IF;

Line 2901: DBMS_TRANSACTION.rollback_savepoint ('REPRICE_OKS');

2897: );
2898: END IF;
2899:
2900: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2901: DBMS_TRANSACTION.rollback_savepoint ('REPRICE_OKS');
2902: okc_api.set_message (p_app_name => g_app_name_oks,
2903: p_msg_name => g_unexpected_error,
2904: p_token1 => g_sqlcode_token,
2905: p_token1_value => SQLCODE,

Line 3052: DBMS_TRANSACTION.SAVEPOINT ('REPRICE_OKS');

3048: fnd_file.put_line(FND_FILE.LOG,'p_subject_sub_line_tbl.COUNT : '||p_subject_sub_line_tbl.COUNT);
3049: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
3050: fnd_file.put_line(FND_FILE.LOG,' ');
3051:
3052: DBMS_TRANSACTION.SAVEPOINT ('REPRICE_OKS');
3053:
3054: OPEN l_k_details_csr (p_subject_chr_id);
3055: FETCH l_k_details_csr
3056: INTO l_k_details_rec;

Line 3758: DBMS_TRANSACTION.rollback_savepoint ('REPRICE_OKS');

3754: l_api_name
3755: );
3756: END IF;
3757:
3758: DBMS_TRANSACTION.rollback_savepoint ('REPRICE_OKS');
3759: x_return_status := l_return_status;
3760: WHEN OTHERS THEN
3761: -- end debug log
3762: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN