APPS.OKS_BILL_REC_PUB dependencies on DBMS_TRANSACTION

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

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

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

3704: FOR bcl_rec in billed_cur(p_line_id,l_termination_date,l_next_ship_date )
3705: LOOP
3706: BEGIN
3707: EXIT A WHEN (l_termination_amount <= 0 OR l_con_termination_amount <= 0 and p_full_credit <> 'Y' );
3708: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
3709: l_bclv_tbl_in.delete;
3710: l_bclv_tbl_out.delete;
3711: l_bslv_tbl_in.delete;
3712: l_bslv_tbl_out.delete;

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

3888: l_bslv_tbl_in(1).AMOUNT := -1* l_amount ;
3889: END IF;
3890:
3891: IF ( l_AMOUNT <= 0) THEN
3892: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
3893: RAISE NEGATIVE_TERM_AMOUNT;
3894: END IF;
3895: END IF;
3896: ***********************************************************************************************************************/

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

4375: /* Start Addition for bug fix 6012384 (FP for 5990067) */
4376: SKIP_THIS_LINE EXCEPTION;
4377: /* End Addition for bug fix 6012384 (FP for 5990067) */
4378: BEGIN
4379: DBMS_TRANSACTION.SAVEPOINT('BEFORE_PRE_TERMINATE');
4380: x_return_status := OKC_API.G_RET_STS_SUCCESS ;
4381: l_billed := FALSE;
4382: l_terminate := FALSE;
4383: l_termination_amount := p_termination_amount;

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

5373: x_return_status := nvl(l_okc_status, 'S');
5374:
5375: EXCEPTION
5376: WHEN G_EXCEPTION_HALT_VALIDATION THEN
5377: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_PRE_TERMINATE');
5378: WHEN OTHERS THEN
5379: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5380: OKC_API.set_message(G_APP_NAME,G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN, SQLCODE,G_SQLERRM_TOKEN, SQLERRM);
5381: END;

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

7908: x_return_status := 'S';
7909:
7910: FOR l_bill_rec in l_bill_line_csr
7911: LOOP
7912: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
7913:
7914: If l_error = 'T' Then
7915: Fetch l_bill_line_csr Into l_bill_rec;
7916: Exit WHEN l_bill_line_csr%notFOUND;

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

8070: If (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
8071: x_return_status := l_return_status;
8072: FND_FILE.PUT_LINE( FND_FILE.LOG, 'insert into table failed Contract line id :'||' '||l_bill_rec.id);
8073: l_error := 'T';
8074: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
8075: raise G_EXCEPTION_HALT_VALIDATION;
8076: ELSE
8077: x_return_status := l_return_status;
8078: FOR I IN 1..FND_MSG_PUB.Count_Msg

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

8081: END LOOP;
8082:
8083: FND_FILE.PUT_LINE( FND_FILE.LOG, 'insert into table failed Contract line id :'||' '||l_bill_rec.id);
8084: l_error := 'T';
8085: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
8086: END If;
8087: End If;
8088:
8089: <>

Line 8293: DBMS_TRANSACTION.SAVEPOINT('BEFORE_PRE_TERMINATE_CP');

8289:
8290: BEGIN
8291:
8292: /*Added for bug 11702843*/
8293: DBMS_TRANSACTION.SAVEPOINT('BEFORE_PRE_TERMINATE_CP');
8294: /*Added for bug 11702843*/
8295:
8296: X_return_status := 'S';
8297: l_ctr := TRUE;

Line 8570: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_PRE_TERMINATE_CP');

8566: EXCEPTION
8567: WHEN G_EXCEPTION_HALT_VALIDATION THEN
8568: /*Added for bug 11702843*/
8569: x_return_status := OKC_API.G_RET_STS_ERROR ;
8570: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_PRE_TERMINATE_CP');
8571: /*Added for bug 11702843*/
8572:
8573: END pre_terminate_cp;
8574: