eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_CONTRACTS_PUB dependencies on DBMS_TRANSACTION

Line 5396: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTIONS');

5392:
5393:
5394: BEGIN
5395:
5396: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTIONS');
5397:
5398: OKS_RENEW_PVT.DEBUG_LOG( '(OKS_CONTRACTS_PUB).Create_Subscription :: SRV Id for Subscription line :'|| p_k_line_rec.srv_id );
5399: OKS_RENEW_PVT.DEBUG_LOG( '(OKS_CONTRACTS_PUB).Create_Subscription :: SRV Id for Support Line :'|| p_K_support_rec.srv_id );
5400: OKS_RENEW_PVT.DEBUG_LOG( '(OKS_CONTRACTS_PUB).Create_Subscription :: Negotiated amount for SB line :'|| p_k_line_rec.negotiated_amount );

Line 5474: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTIONS');

5470: --dbms_output.put_line('create item status:- ' || l_return_status);
5471: --dbms_output.put_line('create item status :: item id:- ' || p_instance_rec.instance_id);
5472:
5473: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
5474: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTIONS');
5475: RAISE G_EXCEPTION_HALT_VALIDATION;
5476: END IF;
5477: */
5478:

Line 5503: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTIONS');

5499: OKS_RENEW_PVT.DEBUG_LOG( '(OKS_CONTRACTS_PUB).Create_Subscription :: Service line Id for SB Line :'|| l_sb_service_line_id );
5500: --dbms_output.put_line('K SUBSCRIPTION LINE CREATION STATUS:- ' || l_return_status);
5501:
5502: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
5503: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTIONS');
5504: RAISE G_EXCEPTION_HALT_VALIDATION;
5505: END IF;
5506:
5507: -- Create default schedule

Line 5523: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTIONS');

5519: OKS_RENEW_PVT.DEBUG_LOG( '(OKS_CONTRACTS_PUB).Create_Subscription :: Create default sch status :'|| l_return_status );
5520: --dbms_output.put_line('K SUBSCRIPTION LINE CREATION STATUS:- ' || l_return_status);
5521:
5522: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
5523: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTIONS');
5524: RAISE G_EXCEPTION_HALT_VALIDATION;
5525: END IF;
5526:
5527: OPEN l_subscr_scr(l_sb_service_line_id,l_contract_header_id);

Line 5554: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTIONS');

5550: OKS_RENEW_PVT.DEBUG_LOG( '(OKS_CONTRACTS_PUB).Create_Subscription :: Service line Id for Su Line :'|| l_su_service_line_id);
5551: --dbms_output.put_line('K CONTRACT SUPPORT SERVICE LINE CREATION STATUS:- ' || l_return_status);
5552:
5553: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
5554: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTIONS');
5555: RAISE G_EXCEPTION_HALT_VALIDATION;
5556: END IF;
5557:
5558: -- Get the name description details of the product

Line 5606: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTIONS');

5602: OKS_RENEW_PVT.DEBUG_LOG( '(OKS_CONTRACTS_PUB).Create_Subscription :: Covered line id for support line :'|| l_cp_line_id );
5603: --dbms_output.put_line('K COVERED PRODUCT CREATION FOR SUPPORT SERVICE LINE STATUS:- ' || l_return_status);
5604:
5605: IF Not l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
5606: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTIONS');
5607: RAISE G_EXCEPTION_HALT_VALIDATION;
5608: END IF;
5609:
5610: /* -- if CP has a counter then create a covered usage line - for counter

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

5778: IF x_return_status = 'S' THEN
5779: l_slh_rec.Object2_Id1 := l_time_val;
5780: ELSE
5781: x_return_status := OKC_API.G_RET_STS_ERROR;
5782: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
5783: Raise G_EXCEPTION_HALT_VALIDATION;
5784: END IF;
5785: END IF;
5786:

Line 5836: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTIONS');

5832: OKS_RENEW_PVT.DEBUG_LOG( '(OKS_CONTRACTS_PUB).Create_Subscription :: Create_Billing_Schd for SB Line status :'|| l_return_status );
5833: --dbms_output.put_line('SUBSCRIPTION LINE BILL SCHEDULE STATUS:- ' || l_return_status);
5834:
5835: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5836: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTIONS');
5837: RAISE G_EXCEPTION_HALT_VALIDATION;
5838: END IF;
5839:
5840: END If; -- end of billing for subscription line

Line 5886: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTIONS');

5882: IF l_return_status = 'S' THEN
5883: l_slh_rec.Object2_Id1 := l_time_val;
5884: ELSE
5885: l_return_status := OKC_API.G_RET_STS_ERROR;
5886: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTIONS');
5887: Raise G_EXCEPTION_HALT_VALIDATION;
5888: END IF;
5889: END IF;
5890:

Line 5911: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTIONS');

5907:
5908: END IF; -- end of billing for line type = 'SU'
5909:
5910: IF l_return_status <> 'S' THEN
5911: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTIONS');
5912: END IF;
5913:
5914: x_return_status := l_return_status;
5915:

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

5972: l_time_val NUMBER;
5973: l_return_status Varchar2(1);
5974: BEGIN
5975:
5976: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
5977:
5978: OKS_RENEW_PVT.DEBUG_LOG( '(OKS_CONTRACTS_PUB).Create_Contract :: Line Style :'|| p_K_line_rec.line_type );
5979: OKS_RENEW_PVT.DEBUG_LOG( '(OKS_CONTRACTS_PUB).Create_Contract :: Support line style :'|| p_K_Support_rec.line_type );
5980: OKS_RENEW_PVT.DEBUG_LOG( '(OKS_CONTRACTS_PUB).Create_Contract :: Usage type :'|| p_K_line_rec.usage_type );

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

6003: OKS_RENEW_PVT.DEBUG_LOG( '(OKS_CONTRACTS_PUB).Create_Contract :: Contract Header Id :'|| to_char(l_contract_header_id) );
6004: --dbms_output.put_line('K CONTRACT HEADER CREATION STATUS:- ' || l_return_status);
6005:
6006: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6007: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
6008: RAISE G_EXCEPTION_HALT_VALIDATION;
6009: END IF;
6010:
6011:

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

6037: OKS_RENEW_PVT.DEBUG_LOG( '(OKS_CONTRACTS_PUB).Create_Contract :: Create_Subscription status :'|| l_return_status);
6038: --dbms_output.put_line('CREATE SUBSCRIPTION STATUS:- ' || l_return_status);
6039:
6040: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6041: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
6042: RAISE G_EXCEPTION_HALT_VALIDATION;
6043: END IF;
6044: ELSE
6045:

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

6065: );
6066: OKS_RENEW_PVT.DEBUG_LOG( '(OKS_CONTRACTS_PUB).Create_Contract :: Create_Service_Line status :'|| l_return_status );
6067: --dbms_output.put_line('K CONTRACT SERVICE LINE CREATION STATUS:- ' || l_return_status);
6068: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6069: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
6070: RAISE G_EXCEPTION_HALT_VALIDATION;
6071: END IF;
6072:
6073:

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

6088: OKS_RENEW_PVT.DEBUG_LOG( '(OKS_CONTRACTS_PUB).Create_Contract :: Create_Covered_Line status :'|| l_return_status );
6089: --dbms_output.put_line('K COVERED PRODUCT LINE CREATION STATUS:- ' || l_return_status);
6090:
6091: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6092: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
6093: RAISE G_EXCEPTION_HALT_VALIDATION;
6094: END IF;
6095:
6096: IF p_K_header_rec.scs_code = 'WARRANTY' AND p_K_line_rec.line_type = 'W' THEN ----warranty

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

6117: l_slh_rec.Object2_Id1 := l_time_val;
6118: ELSE
6119: x_return_status := OKC_API.G_RET_STS_ERROR;
6120: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'TIME VALUE REQUIRED FOR SLH');
6121: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
6122: Raise G_EXCEPTION_HALT_VALIDATION;
6123: END IF;
6124: END IF;*/
6125:

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

6136: --dbms_output.put_line('K BILL SCHEDULE STATUS:- ' || l_return_status);
6137:
6138: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6139:
6140: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
6141: RAISE G_EXCEPTION_HALT_VALIDATION;
6142: END IF;
6143:
6144: