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.

[Home] [Help]

APPS.OKS_BILLING_PUB dependencies on DBMS_TRANSACTION

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

726:
727: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in getting next level ');
728:
729: /*Needs to determine or revisited */
730: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
731: Raise USAGE_EXCEPTION;
732: END IF;
733:
734: IF (level_elements_tab.count < 1) THEN

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

808: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in creating account');
809:
810:
811:
812: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION') ;
813: Raise USAGE_EXCEPTION;
814: END IF;
815:
816: *******/

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

851: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
852: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
853: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in insert bcl');
854:
855: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
856: Raise USAGE_EXCEPTION;
857: END IF;
858:
859: IF (p_prv <> 2) THEN

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

885: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
886: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
887: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
888: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in get next level of coverage ');
889: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
890: Raise USAGE_EXCEPTION;
891: END IF;
892:
893: /*Update date completed in coverage line */

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

1005: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
1006: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||' Target Quantity is zero';
1007: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error Get_Prorated_Usage_Qty returns l_qty as '||l_qty);
1008:
1009: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1010: Raise USAGE_EXCEPTION;
1011: END IF;
1012: l_qty := Round(l_qty,0);
1013: ELSE

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

1026: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
1027: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||' Target Quantity is zero';
1028: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error Get_target_qty returns Zero');
1029:
1030: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1031: Raise USAGE_EXCEPTION;
1032: END IF;
1033:
1034: l_qty := Round((l_qty * (l_calc_rec.l_calc_edate -

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

1197: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
1198: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message:= 'Error: '|| sqlerrm||'. Error Message:' ;
1199:
1200: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in LEVEL ') ;
1201: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1202: Raise USAGE_EXCEPTION;
1203: END IF;
1204: END IF; -- l_usage_type in 'VRT','QTY'
1205:

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

1287: l_msg_data => l_msg_data);
1288:
1289: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Calculate Price Error'||' '||l_return_status);
1290:
1291: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1292: Raise USAGE_EXCEPTION;
1293: END IF;
1294:
1295: l_price_rec.PROD_EXT_AMOUNT:=l_price_rec.PROD_EXT_AMOUNT*l_sign;

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

1310: (l_msg_cnt => l_msg_count,
1311: l_msg_data => l_msg_data);
1312:
1313: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error update bsl'||' '||l_return_status);
1314: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1315: Raise USAGE_EXCEPTION;
1316: END IF;
1317:
1318: l_break_amount := 0;

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

1609:
1610: 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 );
1611: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Rolling Back the Whole Service With Top Line ID: '||p_top_line_id );
1612:
1613: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1614:
1615: RAISE sub_service_exception;
1616: END IF;
1617:

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

1707:
1708: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed in Creation of bank account For coverage Id: '||l_covlvl_rec.id );
1709: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Rolling Back the Whole Service With Top Line ID: '||p_top_line_id );
1710:
1711: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1712:
1713: RAISE sub_service_exception;
1714: END IF;
1715: *****/

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

1810: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
1811:
1812: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Bill_Service_Item => Insert into sublines table failed Contract line id :'||p_top_line_id);
1813: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Rolling Back the Whole Service With Top Line ID: '||p_top_line_id );
1814: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1815: RAISE sub_service_exception;
1816: END IF;
1817:
1818: /* Following code is to update the date_completed field of top line */

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

1875:
1876: 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 );
1877: EXIT;
1878: WHEN OTHERS THEN
1879: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1880: /* FOR BILLING REPORT */
1881: Open top_line_amount(p_top_line_id);
1882: Fetch top_line_amount into l_errep_amount;
1883: Close top_line_amount;

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

2073: l_msg_data => l_msg_data);
2074: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
2075: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
2076:
2077: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2078: FND_FILE.PUT_LINE( FND_FILE.LOG,' Failed in Creation of bank account');
2079: FND_FILE.PUT_LINE( FND_FILE.LOG,' Rolling Back the Whole Service '||p_top_line_id );
2080:
2081: RAISE SUBSRIPTION_EXCEPTION;

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

2165: l_msg_data => l_msg_data);
2166: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N ' ;
2167: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
2168: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Insert into sublines table failed Contract line id : '||p_top_line_id);
2169: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION ');
2170: Raise SUBSRIPTION_EXCEPTION;
2171: END IF;
2172:
2173: END IF; -- l_cov_tbl.count > 0

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

2528: LOOP
2529:
2530: BEGIN
2531:
2532: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
2533:
2534: IF l_write_log THEN
2535: 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));
2536: END IF;

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

2675: l_return_status);
2676:
2677:
2678: IF (l_return_status <> 'S') THEN
2679: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2680: RAISE MAIN_LINE_EXCEPTION;
2681: END IF;
2682: -----------------------------------------------------------------
2683: ELSIF (l_bill_rec.lse_id in (1,19)) Then

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

2715: l_return_status
2716: );
2717:
2718: IF (l_return_status <> 'S') THEN
2719: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2720: RAISE MAIN_LINE_EXCEPTION;
2721: END IF;
2722: -----------------------------------------------------------------
2723:

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

2761: l_bill_rec.period_start,
2762: l_return_status
2763: );
2764: IF (l_return_status <> 'S') THEN
2765: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2766: RAISE MAIN_LINE_EXCEPTION;
2767: END IF;
2768:
2769: --------------------------------------------------------

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

2807: P_TOP_LINE => l_bill_rec.id) ;
2808:
2809: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => Failed in AR FEEDER :'||' '||l_bill_rec.id);
2810:
2811: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2812: Raise Main_Line_Exception;
2813: END IF;
2814:
2815:

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

2831: WHEN MAIN_LINE_EXCEPTION THEN
2832: --Added by pmallara begin exception block to fix bug#3961046
2833: BEGIN
2834: l_reject_counter := l_reject_counter + 1;
2835: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2836: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => MAIN LINE EXCEPTION RAISE'||' '||sqlerrm);
2837: RETCODE := 1;
2838: EXCEPTION
2839: WHEN OTHERS THEN

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

2854: l_billrep_err_tbl(l_billrep_errtbl_idx).Sub_line_id := NULL;
2855: l_billrep_err_tbl(l_billrep_errtbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
2856:
2857: l_reject_counter := l_reject_counter + 1;
2858: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2859: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Failed- when others exception raised in Mainline loop '||sqlerrm );
2860: RETCODE := 1;
2861:
2862: --Bug#5378184

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

2912: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2913: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2914: RETCODE := 2;
2915: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when g_exception_rollback raised'||sqlerrm);
2916: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2917: WHEN G_EXCEPTION_ROLLBACK THEN
2918: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when g_exception_rollback raised'||sqlerrm);
2919: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2920:

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

2915: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when g_exception_rollback raised'||sqlerrm);
2916: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2917: WHEN G_EXCEPTION_ROLLBACK THEN
2918: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when g_exception_rollback raised'||sqlerrm);
2919: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2920:
2921: WHEN OTHERS THEN
2922: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2923: RETCODE := 2;

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

2923: RETCODE := 2;
2924: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when others raised'||sqlerrm);
2925: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
2926: G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
2927: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2928:
2929: END Calculate_bill;
2930:
2931: /*----------------------------------------------------------------------

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

3085:
3086: -- We need to see if we should spawn sub-requests;
3087: -- i.e., the number of contract lines that qualify is > MAX_SINGLE_REQUEST.
3088:
3089: DBMS_TRANSACTION.SAVEPOINT('BEFORE_MAIN_BILLING');
3090:
3091:
3092: l_line_no := 0;
3093:

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

3425: ELSE
3426: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Billing Main completed with errors');
3427: conc_ret_code := ERROR;
3428: RETCODE := 2;
3429: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MAIN_BILLING');
3430: END IF;
3431:
3432:
3433: COMMIT;

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

3567: BEGIN
3568:
3569: l_retcode := 0;
3570:
3571: ----DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
3572:
3573: l_org_id := p_org_id;
3574:
3575: --mchoudha fixed bug#4729936

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

3720: OKS_BILL_REC_PUB.GET_MESSAGE(
3721: l_msg_cnt => l_msg_cnt,
3722: l_msg_data => l_msg_data);
3723: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error: Failed in AR FEEDER');
3724: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
3725: l_retcode := 1;
3726: END IF;
3727:
3728: IF (l_retcode = 0) THEN