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 2894: DBMS_TRANSACTION.rollback_savepoint ('REPRICE_OKS');

2890: l_api_name
2891: );
2892: END IF;
2893:
2894: DBMS_TRANSACTION.rollback_savepoint ('REPRICE_OKS');
2895:
2896: IF l_line_csr%ISOPEN THEN
2897: CLOSE l_line_csr;
2898: END IF;

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

2911: );
2912: END IF;
2913:
2914: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2915: DBMS_TRANSACTION.rollback_savepoint ('REPRICE_OKS');
2916: okc_api.set_message (p_app_name => g_app_name_oks,
2917: p_msg_name => g_unexpected_error,
2918: p_token1 => g_sqlcode_token,
2919: p_token1_value => SQLCODE,

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

3064: fnd_file.put_line(FND_FILE.LOG,'p_subject_sub_line_tbl.COUNT : '||p_subject_sub_line_tbl.COUNT);
3065: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
3066: fnd_file.put_line(FND_FILE.LOG,' ');
3067:
3068: DBMS_TRANSACTION.SAVEPOINT ('REPRICE_OKS');
3069:
3070: OPEN l_k_details_csr (p_subject_chr_id);
3071: FETCH l_k_details_csr
3072: INTO l_k_details_rec;

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

3776: l_api_name
3777: );
3778: END IF;
3779:
3780: DBMS_TRANSACTION.rollback_savepoint ('REPRICE_OKS');
3781: x_return_status := l_return_status;
3782: WHEN OTHERS THEN
3783: -- end debug log
3784: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN