APPS.OKS_BILL_REC_PUB dependencies on DBMS_TRANSACTION

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

441:
442: l_return_status := OKC_API.G_RET_STS_SUCCESS;
443:
444:
445: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
446:
447: IF (p_bill_action in ('RI','SRI')) THEN
448:
449:

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

3678: FOR bcl_rec in billed_cur(p_line_id,l_termination_date,l_next_ship_date )
3679: LOOP
3680: BEGIN
3681: EXIT A WHEN (l_termination_amount <= 0 OR l_con_termination_amount <= 0 and p_full_credit <> 'Y' );
3682: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
3683: l_bclv_tbl_in.delete;
3684: l_bclv_tbl_out.delete;
3685: l_bslv_tbl_in.delete;
3686: l_bslv_tbl_out.delete;

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

3862: l_bslv_tbl_in(1).AMOUNT := -1* l_amount ;
3863: END IF;
3864:
3865: IF ( l_AMOUNT <= 0) THEN
3866: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
3867: RAISE NEGATIVE_TERM_AMOUNT;
3868: END IF;
3869: END IF;
3870: ***********************************************************************************************************************/

Line 4353: DBMS_TRANSACTION.SAVEPOINT('BEFORE_PRE_TERMINATE');

4349: /* Start Addition for bug fix 6012384 (FP for 5990067) */
4350: SKIP_THIS_LINE EXCEPTION;
4351: /* End Addition for bug fix 6012384 (FP for 5990067) */
4352: BEGIN
4353: DBMS_TRANSACTION.SAVEPOINT('BEFORE_PRE_TERMINATE');
4354: x_return_status := OKC_API.G_RET_STS_SUCCESS ;
4355: l_billed := FALSE;
4356: l_terminate := FALSE;
4357: l_termination_amount := p_termination_amount;

Line 5351: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_PRE_TERMINATE');

5347: x_return_status := nvl(l_okc_status, 'S');
5348:
5349: EXCEPTION
5350: WHEN G_EXCEPTION_HALT_VALIDATION THEN
5351: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_PRE_TERMINATE');
5352: WHEN OTHERS THEN
5353: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5354: OKC_API.set_message(G_APP_NAME,G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN, SQLCODE,G_SQLERRM_TOKEN, SQLERRM);
5355: END;

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

7876: x_return_status := 'S';
7877:
7878: FOR l_bill_rec in l_bill_line_csr
7879: LOOP
7880: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
7881:
7882: If l_error = 'T' Then
7883: Fetch l_bill_line_csr Into l_bill_rec;
7884: Exit WHEN l_bill_line_csr%notFOUND;

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

8038: If (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
8039: x_return_status := l_return_status;
8040: FND_FILE.PUT_LINE( FND_FILE.LOG, 'insert into table failed Contract line id :'||' '||l_bill_rec.id);
8041: l_error := 'T';
8042: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
8043: raise G_EXCEPTION_HALT_VALIDATION;
8044: ELSE
8045: x_return_status := l_return_status;
8046: FOR I IN 1..FND_MSG_PUB.Count_Msg

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

8049: END LOOP;
8050:
8051: FND_FILE.PUT_LINE( FND_FILE.LOG, 'insert into table failed Contract line id :'||' '||l_bill_rec.id);
8052: l_error := 'T';
8053: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
8054: END If;
8055: End If;
8056:
8057: <>