APPS.OKS_BILL_MIGRATION dependencies on DBMS_TRANSACTION

Line 530: DBMS_TRANSACTION.SAVEPOINT('MAIN');

526: l_conversion_rate Number ;
527: x_return_status Varchar2(10);
528: BEGIN
529: x_return_status := G_RET_STS_SUCCESS;
530: DBMS_TRANSACTION.SAVEPOINT('MAIN');
531: -- Setting OKC Context
532: okc_context.set_okc_org_context;
533:
534: -- Open the contract cursor

Line 540: DBMS_TRANSACTION.SAVEPOINT('CONTRACT_LINE');

536: Loop
537: Fetch l_contract_csr into l_cont_rec ;
538: Exit when l_contract_csr%NotFound;
539:
540: DBMS_TRANSACTION.SAVEPOINT('CONTRACT_LINE');
541:
542: -- Update currency code for all bill cont lines for this contract -BTN ID not null
543: Begin
544: --dbms_output.put_line('Before Updating the bill cont lines for Contract'||l_cont_rec.ID) ;

Line 556: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('CONTRACT_LINE');

552:
553:
554:
555: Exception When Others then
556: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('CONTRACT_LINE');
557: End ;
558:
559: -- Call OKC API to find the contract requires migration or not
560: l_migration_req := OKC_CURRENCY_API.IS_EURO_CONVERSION_NEEDED(l_cont_rec.CURRENCY_CODE) ;

Line 604: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('CONTRACT_LINE');

600: Where ID = l_bill_line_rec.BclID ;
601: --dbms_output.put_line('After Updating Converted amount '||l_bill_line_rec.BclID) ;
602:
603: Exception When Others then
604: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('CONTRACT_LINE');
605: End ;
606:
607: End If; -- Conversion type and conversion rate
608:

Line 629: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('CONTRACT_LINE');

625: And BTN_ID is Null;
626:
627: -- dbms_output.put_line('After Updating the bill cont lines for Contract- BTN ID null'||l_cont_rec.ID) ;
628: Exception When Others then
629: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('CONTRACT_LINE');
630: End ;
631:
632: End If; -- migration req
633:

Line 641: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('MAIN');

637:
638: --dbms_output.put_line('Currency migration program has completed with NO errors ') ;
639: EXCEPTION
640: WHEN Others THEN
641: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('MAIN');
642: x_return_status := OKC_API.G_RET_STS_ERROR;
643: OKC_API.SET_MESSAGE
644: ( p_app_name => G_APP_NAME,
645: p_msg_name => G_UNEXPECTED_ERROR,

Line 1309: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

1305:
1306: Begin
1307:
1308: l_return_status := 'S';
1309: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
1310:
1311: OPEN top_line_grp_csr ;
1312: LOOP
1313: FETCH top_line_grp_csr bulk collect into l_id ,

Line 1386: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

1382:
1383:
1384:
1385: EXCEPTION WHEN OTHERS THEN
1386: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1387: l_return_status := OKC_API.G_RET_STS_ERROR;
1388: OKC_API.SET_MESSAGE
1389: (
1390: p_app_name => G_APP_NAME,

Line 1546: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

1542:
1543:
1544: BEGIN
1545: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1546: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
1547:
1548:
1549: OPEN top_line_grp_csr ;
1550: LOOP

Line 1917: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

1913:
1914: ELSE ---create_bill_sch _rules fail
1915:
1916: -- x_return_status := l_return_status;
1917: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1918:
1919: END IF; -- IF l_return_status = 'S' --status of create_bill_sch_rules
1920: END IF;--l_SLL_tbl_type.COUNT > 0
1921:

Line 2023: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

2019:
2020:
2021:
2022: EXCEPTION WHEN OTHERS THEN
2023: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2024: l_return_status := OKC_API.G_RET_STS_ERROR;
2025: OKC_API.SET_MESSAGE
2026: (
2027: p_app_name => G_APP_NAME,