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

Line 2968: DBMS_TRANSACTION.SAVEPOINT('BEFORE_AR_TRANSACTION');

2964: EXIT WHEN cur_bcl_term%NOTFOUND;
2965: END IF;
2966:
2967: BEGIN
2968: DBMS_TRANSACTION.SAVEPOINT('BEFORE_AR_TRANSACTION');
2969: --Fix for bug#4390448
2970: --initializing the variable l_usage_type to NULL
2971: l_usage_type := NULL;
2972:

Line 3113: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

3109: x_msg_count := l_msg_cnt;
3110: x_msg_data := l_msg_data;
3111: END IF;
3112:
3113: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
3114: RAISE MAIN_CUR_EXCEPTION;
3115: END IF; -- (l_ret_stat = 'S')
3116:
3117:

Line 3696: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

3692: x_msg_count := l_msg_cnt;
3693: x_msg_data := l_msg_data;
3694: END IF;
3695:
3696: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
3697: RAISE MAIN_CUR_EXCEPTION;
3698:
3699: END IF;
3700:

Line 3883: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

3879: );
3880:
3881: IF (l_ret_stat <> 'S') THEN
3882: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER Auto Invoice Not Run'||Bcl_rec.cle_id);
3883: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
3884: RAISE MAIN_CUR_EXCEPTION;
3885: End if;
3886:
3887:

Line 3966: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

3962: x_msg_count := l_msg_cnt;
3963: x_msg_data := l_msg_data;
3964: END IF;
3965:
3966: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
3967: RAISE MAIN_CUR_EXCEPTION;
3968: END IF;
3969:
3970: l_amount := (bcl_rec.amount);

Line 4028: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

4024: x_msg_count := l_msg_cnt;
4025: x_msg_data := l_msg_data;
4026:
4027: END IF;
4028: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4029: RAISE MAIN_CUR_EXCEPTION;
4030: END IF;
4031:
4032: IF P_PRV = 1 THEN

Line 4053: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

4049: x_msg_count := l_msg_cnt;
4050: x_msg_data := l_msg_data;
4051:
4052: END IF;
4053: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4054: RAISE MAIN_CUR_EXCEPTION;
4055: END IF;
4056:
4057:

Line 4074: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

4070: x_msg_count := l_msg_cnt;
4071: x_msg_data := l_msg_data;
4072:
4073: END IF;
4074: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4075: RAISE MAIN_CUR_EXCEPTION;
4076: END IF;
4077:
4078: If G_LOG_YES_NO = 'YES' then

Line 4187: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

4183: );
4184:
4185: IF (l_ret_stat <> 'S') THEN
4186: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER Auto Invoice Not Run'||Bcl_rec.cle_id);
4187: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4188: RAISE MAIN_CUR_EXCEPTION;
4189: End if;
4190:
4191: If G_LOG_YES_NO = 'YES' then

Line 4267: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

4263: l_msg_data => l_msg_data);
4264:
4265: x_msg_count := l_msg_cnt;
4266: x_msg_data := l_msg_data;
4267: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4268: RAISE MAIN_CUR_EXCEPTION;
4269: END IF;
4270:
4271: l_amount := (bsl_rec.amount);

Line 4407: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

4403: l_msg_data => l_msg_data);
4404:
4405: x_msg_count := l_msg_cnt;
4406: x_msg_data := l_msg_data;
4407: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4408: RAISE MAIN_CUR_EXCEPTION;
4409: END IF;
4410:
4411: INSERT_RA_REV_DIST( l_ret_stat,

Line 4417: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

4413:
4414: IF (l_ret_stat <> 'S') THEN
4415: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_REVENUE_DISTRIBUTIO NS'||lines_rec.id);
4416:
4417: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4418: RAISE MAIN_CUR_EXCEPTION;
4419: END IF;
4420:
4421: If G_LOG_YES_NO = 'YES' then

Line 4432: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

4428: l_ret_stat);
4429:
4430: IF ( l_ret_stat <> 'S') THEN
4431: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_SALES_CREDIT FAILED'||lines_rec.id);
4432: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4433: RAISE MAIN_CUR_EXCEPTION;
4434: END IF;
4435: If G_LOG_YES_NO = 'YES' then
4436: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of sales credit processing ');

Line 4489: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

4485: l_msg_data => l_msg_data);
4486:
4487: x_msg_count := l_msg_cnt;
4488: x_msg_data := l_msg_data;
4489: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4490: RAISE MAIN_CUR_EXCEPTION;
4491: END IF;
4492:
4493: ELSE ---normal

Line 4511: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

4507:
4508: x_msg_count := l_msg_cnt;
4509: x_msg_data := l_msg_data;
4510:
4511: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4512: RAISE MAIN_CUR_EXCEPTION;
4513:
4514: END IF; --IF (l_ret_stat <> 'S')
4515:

Line 4531: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

4527:
4528: IF (l_ret_stat <> 'S') THEN
4529: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_REVENUE_DISTRIBUTIONS'||lines_rec.id);
4530:
4531: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4532: RAISE MAIN_CUR_EXCEPTION;
4533: END IF;
4534:
4535: If G_LOG_YES_NO = 'YES' then

Line 4546: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

4542: l_ret_stat);
4543:
4544: IF ( l_ret_stat <> 'S') THEN
4545: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_SALES_CREDIT FAILED'||lines_rec.id);
4546: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4547: RAISE MAIN_CUR_EXCEPTION;
4548: END IF;
4549: If G_LOG_YES_NO = 'YES' then
4550: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of sales credit processing ');

Line 4626: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

4622: END IF; -- P_PRV <> 3
4623:
4624: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER MAIN_CUR_EXCEPTION RAISED '||sqlerrm);
4625: l_reject_counter := l_reject_counter + 1;
4626: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4627: x_return_status := OKC_API.G_RET_STS_ERROR;
4628: WHEN OTHERS THEN
4629:
4630: /*FOR BILLING REPORT*/

Line 4690: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

4686:
4687: x_return_status := OKC_API.G_RET_STS_ERROR;
4688: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER OTHERS EXCEPTION RAISED'||sqlerrm);
4689: l_reject_counter := l_reject_counter + 1;
4690: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4691:
4692: END;
4693:
4694: IF (p_prv <> 3 and nvl(report_bill_action,'RI') <> 'AV') THEN

Line 4755: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

4751: EXCEPTION
4752: WHEN G_EXCEPTION_BILLING THEN
4753: --x_return_status := OKC_API.G_RET_STS_ERROR;
4754: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER G_BILLING_EXCEPTION RAISED '||sqlerrm);
4755: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4756: WHEN OTHERS THEN
4757: --x_return_status := OKC_API.G_RET_STS_ERROR;
4758: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER WHEN OTHERS EXCEPTION RAISED'||sqlerrm);
4759: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

Line 4759: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

4755: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4756: WHEN OTHERS THEN
4757: --x_return_status := OKC_API.G_RET_STS_ERROR;
4758: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER WHEN OTHERS EXCEPTION RAISED'||sqlerrm);
4759: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4760:
4761: End Get_REC_FEEDER;
4762:
4763: Procedure Populate_TR_reference_fields(p_instance_number IN NUMBER,