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_BILLING_PUB dependencies on DBMS_TRANSACTION

Line 814: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

810:
811: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in getting next level ');
812:
813: /*Needs to determine or revisited */
814: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
815: Raise USAGE_EXCEPTION;
816: END IF;
817:
818: IF (level_elements_tab.count < 1) THEN

Line 896: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION') ;

892: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in creating account');
893:
894:
895:
896: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION') ;
897: Raise USAGE_EXCEPTION;
898: END IF;
899:
900: *******/

Line 939: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

935: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
936: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
937: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in insert bcl');
938:
939: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
940: Raise USAGE_EXCEPTION;
941: END IF;
942:
943: IF (p_prv <> 2) THEN

Line 973: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

969: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
970: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
971: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
972: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in get next level of coverage ');
973: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
974: Raise USAGE_EXCEPTION;
975: END IF;
976:
977: /*Update date completed in coverage line */

Line 1093: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

1089: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
1090: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||' Target Quantity is zero';
1091: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error Get_Prorated_Usage_Qty returns l_qty as '||l_qty);
1092:
1093: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1094: Raise USAGE_EXCEPTION;
1095: END IF;
1096: l_qty := Round(l_qty,0);
1097: ELSE

Line 1114: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

1110: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
1111: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||' Target Quantity is zero';
1112: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error Get_target_qty returns Zero');
1113:
1114: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1115: Raise USAGE_EXCEPTION;
1116: END IF;
1117: /* Modified for Bug#15897052 */
1118: l_qty := ((l_qty * (l_calc_rec.l_calc_edate -

Line 1285: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

1281: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
1282: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message:= 'Error: '|| sqlerrm||'. Error Message:' ;
1283:
1284: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in LEVEL ') ;
1285: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1286: Raise USAGE_EXCEPTION;
1287: END IF;
1288: END IF; -- l_usage_type in 'VRT','QTY'
1289:

Line 1408: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

1404: (l_msg_cnt => l_msg_count,
1405: l_msg_data => l_msg_data);
1406:
1407: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error update bsl'||' '||l_return_status);
1408: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1409: Raise USAGE_EXCEPTION;
1410: END IF;
1411:
1412: END IF; --l_line_rec.usage_qty <>0

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

3037:
3038: for usage_line_rec IN usage_line_csr(bulk_qp_hdr_id_rec.dnz_chr_id)
3039: LOOP
3040: BEGIN
3041: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
3042:
3043: If l_write_log then
3044: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => B4 initializing Billing Report ');
3045: End If;

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

3462: p_billrep_err_tbl(p_billrep_err_tbl_idx).Sub_line_id := l_subline_id ;
3463: p_billrep_err_tbl(p_billrep_err_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
3464:
3465:
3466: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
3467:
3468: Rollback_usg_bill_dtls_prc(usage_line_rec.line_id,bulk_qp_hdr_id_rec.DNZ_chr_id,l_prv);
3469: RETCODE := 1;
3470:

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

3470:
3471: WHEN Bulk_USAGE_line_EXCEPTION THEN
3472:
3473: p_reject_counter := p_reject_counter + 1;
3474: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
3475: Rollback_usg_bill_dtls_prc(usage_line_rec.line_id,bulk_qp_hdr_id_rec.DNZ_chr_id,l_prv);
3476: RETCODE := 1;
3477:
3478: WHEN OTHERS THEN

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

3489:
3490:
3491:
3492:
3493: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
3494:
3495: Rollback_usg_bill_dtls_prc(usage_line_rec.line_id,bulk_qp_hdr_id_rec.DNZ_chr_id,l_prv);
3496: RETCODE := 1;
3497:

Line 3835: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

3831:
3832: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in getting next level ');
3833:
3834: /*Needs to determine or revisited */
3835: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
3836: Raise USAGE_EXCEPTION;
3837: END IF;
3838:
3839: IF (level_elements_tab.count < 1) THEN

Line 3917: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION') ;

3913: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in creating account');
3914:
3915:
3916:
3917: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION') ;
3918: Raise USAGE_EXCEPTION;
3919: END IF;
3920:
3921: *******/

Line 3960: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

3956: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
3957: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
3958: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in insert bcl');
3959:
3960: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
3961: Raise USAGE_EXCEPTION;
3962: END IF;
3963:
3964: IF (p_prv <> 2) THEN

Line 3994: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

3990: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
3991: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
3992: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
3993: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in get next level of coverage ');
3994: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
3995: Raise USAGE_EXCEPTION;
3996: END IF;
3997:
3998: /*Update date completed in coverage line */

Line 4114: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

4110: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
4111: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||' Target Quantity is zero';
4112: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error Get_Prorated_Usage_Qty returns l_qty as '||l_qty);
4113:
4114: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
4115: Raise USAGE_EXCEPTION;
4116: END IF;
4117: /* Commented for Bug#15897052 */
4118: --l_qty := Round(l_qty,0);

Line 4136: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

4132: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
4133: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||' Target Quantity is zero';
4134: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error Get_target_qty returns Zero');
4135:
4136: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
4137: Raise USAGE_EXCEPTION;
4138: END IF;
4139: /* Modifed for Bug#15897052 */
4140: l_qty := ((l_qty * (l_calc_rec.l_calc_edate -

Line 4307: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

4303: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
4304: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message:= 'Error: '|| sqlerrm||'. Error Message:' ;
4305:
4306: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in LEVEL ') ;
4307: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
4308: Raise USAGE_EXCEPTION;
4309: END IF;
4310: END IF; -- l_usage_type in 'VRT','QTY'
4311:

Line 4447: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

4443: (l_msg_cnt => l_msg_count,
4444: l_msg_data => l_msg_data);
4445:
4446: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error update bsl'||' '||l_return_status);
4447: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
4448: Raise USAGE_EXCEPTION;
4449: END IF;
4450:
4451: l_break_amount := 0;

Line 4746: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

4742:
4743: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed in Creation of get_next_level_element For coverage Id: '||l_covlvl_rec.id );
4744: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Rolling Back the Whole Service With Top Line ID: '||p_top_line_id );
4745:
4746: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
4747:
4748: RAISE sub_service_exception;
4749: END IF;
4750:

Line 4844: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

4840:
4841: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed in Creation of bank account For coverage Id: '||l_covlvl_rec.id );
4842: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Rolling Back the Whole Service With Top Line ID: '||p_top_line_id );
4843:
4844: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
4845:
4846: RAISE sub_service_exception;
4847: END IF;
4848: *****/

Line 4947: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

4943: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
4944:
4945: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Bill_Service_Item => Insert into sublines table failed Contract line id :'||p_top_line_id);
4946: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Rolling Back the Whole Service With Top Line ID: '||p_top_line_id );
4947: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
4948: RAISE sub_service_exception;
4949: END IF;
4950:
4951: /* Following code is to update the date_completed field of top line */

Line 5012: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

5008:
5009: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed- sub_service_exception exception raised for coverage: '||l_covlvl_rec.id||' With Error: '||sqlerrm );
5010: EXIT;
5011: WHEN OTHERS THEN
5012: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
5013: /* FOR BILLING REPORT */
5014: Open top_line_amount(p_top_line_id);
5015: Fetch top_line_amount into l_errep_amount;
5016: Close top_line_amount;

Line 5210: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

5206: l_msg_data => l_msg_data);
5207: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
5208: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
5209:
5210: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
5211: FND_FILE.PUT_LINE( FND_FILE.LOG,' Failed in Creation of bank account');
5212: FND_FILE.PUT_LINE( FND_FILE.LOG,' Rolling Back the Whole Service '||p_top_line_id );
5213:
5214: RAISE SUBSRIPTION_EXCEPTION;

Line 5302: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION ');

5298: l_msg_data => l_msg_data);
5299: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N ' ;
5300: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
5301: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Insert into sublines table failed Contract line id : '||p_top_line_id);
5302: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION ');
5303: Raise SUBSRIPTION_EXCEPTION;
5304: END IF;
5305:
5306: END IF; -- l_cov_tbl.count > 0

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

5596: LOOP
5597:
5598: BEGIN
5599:
5600: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
5601:
5602: IF l_write_log THEN
5603: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => B4 opening cursor l_bill_line_csr line id '||cle_id(i)||' header ID '||chr_id(i)||' line number '||l_line_no(i));
5604: END IF;

Line 5747: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

5743: l_return_status);
5744:
5745:
5746: IF (l_return_status <> 'S') THEN
5747: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
5748: RAISE MAIN_LINE_EXCEPTION;
5749: END IF;
5750: -----------------------------------------------------------------
5751: ELSIF (l_bill_rec.lse_id in (1,19)) Then

Line 5787: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

5783: l_return_status
5784: );
5785:
5786: IF (l_return_status <> 'S') THEN
5787: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
5788: RAISE MAIN_LINE_EXCEPTION;
5789: END IF;
5790: -----------------------------------------------------------------
5791:

Line 5883: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

5879:
5880: End if; --l_bulk_usage
5881:
5882: IF (l_return_status <> 'S') THEN
5883: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
5884: RAISE MAIN_LINE_EXCEPTION;
5885: END IF;
5886:
5887: --------------------------------------------------------

Line 5929: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

5925: P_TOP_LINE => l_bill_rec.id) ;
5926:
5927: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => Failed in AR FEEDER :'||' '||l_bill_rec.id);
5928:
5929: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
5930: Raise Main_Line_Exception;
5931: END IF;
5932:
5933:

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

5952: WHEN MAIN_LINE_EXCEPTION THEN
5953: --Added by pmallara begin exception block to fix bug#3961046
5954: BEGIN
5955: l_reject_counter := l_reject_counter + 1;
5956: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
5957: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => MAIN LINE EXCEPTION RAISE'||' '||sqlerrm);
5958: RETCODE := 1;
5959: EXCEPTION
5960: WHEN OTHERS THEN

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

5975: l_billrep_err_tbl(l_billrep_errtbl_idx).Sub_line_id := NULL;
5976: l_billrep_err_tbl(l_billrep_errtbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
5977:
5978: l_reject_counter := l_reject_counter + 1;
5979: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
5980: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Failed- when others exception raised in Mainline loop '||sqlerrm );
5981: RETCODE := 1;
5982:
5983: --Bug#5378184

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

6053: WHEN G_EXCEPTION_HALT_VALIDATION THEN
6054: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6055: RETCODE := 2;
6056: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when g_exception_rollback raised'||sqlerrm);
6057: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
6058: WHEN G_EXCEPTION_ROLLBACK THEN
6059: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when g_exception_rollback raised'||sqlerrm);
6060: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
6061:

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

6056: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when g_exception_rollback raised'||sqlerrm);
6057: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
6058: WHEN G_EXCEPTION_ROLLBACK THEN
6059: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when g_exception_rollback raised'||sqlerrm);
6060: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
6061:
6062: WHEN OTHERS THEN
6063: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
6064: RETCODE := 2;

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

6064: RETCODE := 2;
6065: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when others raised'||sqlerrm);
6066: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
6067: G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
6068: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
6069:
6070: END Calculate_bill;
6071:
6072: /*----------------------------------------------------------------------

Line 6248: DBMS_TRANSACTION.SAVEPOINT('BEFORE_MAIN_BILLING');

6244:
6245: -- We need to see if we should spawn sub-requests;
6246: -- i.e., the number of contract lines that qualify is > MAX_SINGLE_REQUEST.
6247:
6248: DBMS_TRANSACTION.SAVEPOINT('BEFORE_MAIN_BILLING');
6249:
6250:
6251: l_line_no := 0;
6252: /*Code hook to get interface start_date for bug7668259*/

Line 6931: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MAIN_BILLING');

6927: ELSE
6928: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Billing Main completed with errors');
6929: conc_ret_code := ERROR;
6930: RETCODE := 2;
6931: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MAIN_BILLING');
6932: END IF;
6933:
6934:
6935: COMMIT;

Line 7073: ----DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

7069: BEGIN
7070:
7071: l_retcode := 0;
7072:
7073: ----DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
7074:
7075: l_org_id := p_org_id;
7076:
7077: --mchoudha fixed bug#4729936

Line 7226: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

7222: OKS_BILL_REC_PUB.GET_MESSAGE(
7223: l_msg_cnt => l_msg_cnt,
7224: l_msg_data => l_msg_data);
7225: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error: Failed in AR FEEDER');
7226: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
7227: l_retcode := 1;
7228: END IF;
7229:
7230: IF (l_retcode = 0) THEN