APPS.OKS_MASS_UPD_PVT dependencies on DBMS_TRANSACTION

Line 626: DBMS_TRANSACTION.SAVEPOINT('MASS_UPDATE_PRICE');

622: FOR i in l_mu_price_tbl.FIRST .. l_mu_price_tbl.LAST loop
623:
624: begin
625: -- Make a save point, in case of error rollback
626: DBMS_TRANSACTION.SAVEPOINT('MASS_UPDATE_PRICE');
627:
628: l_line_eligible :='N';
629: l_input_details.line_id := l_mu_price_tbl(i).line_id;
630: l_input_details.subline_id := l_mu_price_tbl(i).sub_line_id;

Line 884: DBMS_TRANSACTION.rollback_savepoint('MASS_UPDATE_PRICE');

880: END IF;
881:
882: EXCEPTION
883: wHEN l_EXC_ERROR THEN
884: DBMS_TRANSACTION.rollback_savepoint('MASS_UPDATE_PRICE');
885: x_overall_status := 'W';
886: END;
887: end loop;
888:

Line 1351: DBMS_TRANSACTION.SAVEPOINT('MASS_UPDATE_STATUS');

1347:
1348: FOR i in p_lines_tbl.FIRST .. p_lines_tbl.LAST LOOP
1349: BEGIN
1350: -- Make a save point, in case of error rollback
1351: DBMS_TRANSACTION.SAVEPOINT('MASS_UPDATE_STATUS');
1352:
1353: OPEN ste_code_csr(p_lines_tbl(i).old_sts_code);
1354: FETCH ste_code_csr
1355: INTO l_old_ste_code;

Line 1465: DBMS_TRANSACTION.rollback_savepoint('MASS_UPDATE_STATUS');

1461: EXCEPTION
1462: WHEN l_EXC_ERROR THEN
1463: fnd_file.put_line (fnd_file.log,'Exception raised for Line Number: '||err_mu_status_tbl(l_error_count).line_number ||
1464: 'Error Msg : '||err_mu_status_tbl(l_error_count).err_msg );
1465: DBMS_TRANSACTION.rollback_savepoint('MASS_UPDATE_STATUS');
1466: x_overall_status := 'W';
1467: END;
1468:
1469: END LOOP;

Line 2209: DBMS_TRANSACTION.SAVEPOINT('MASS_UPDATE_EFFECTIVITY');

2205: l_api_name || ' Processing Line Id:' || l_clev_tbl_kl_in(j).id);
2206:
2207: IF l_clev_tbl_kl_in(j).exception_yn <> 'Y' THEN
2208: BEGIN
2209: DBMS_TRANSACTION.SAVEPOINT('MASS_UPDATE_EFFECTIVITY');
2210: fnd_file.put_line (fnd_file.log,l_api_name || ' Before Calling : okc_contract_pub.update_contract_line');
2211:
2212: okc_contract_pub.update_contract_line(p_api_version => l_api_version,
2213: p_init_msg_list => l_init_msg_list,

Line 2260: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('MASS_UPDATE_EFFECTIVITY');

2256: end if; */
2257:
2258: EXCEPTION
2259: when OTHERS THEN
2260: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('MASS_UPDATE_EFFECTIVITY');
2261: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2262: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2263: l_api_name,
2264: ' Error from okc_contract_pub.update_contract_line procedure' ||

Line 2317: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('MASS_UPDATE_EFFECTIVITY');

2313: End If; */
2314:
2315: EXCEPTION
2316: when OTHERS THEN
2317: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('MASS_UPDATE_EFFECTIVITY');
2318: IF fnd_log.level_statement >=
2319: fnd_log.g_current_runtime_level THEN
2320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2321: l_api_name,