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

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

3008: EXIT WHEN cur_bcl_term%NOTFOUND;
3009: END IF;
3010:
3011: BEGIN
3012: DBMS_TRANSACTION.SAVEPOINT('BEFORE_AR_TRANSACTION');
3013: --Fix for bug#4390448
3014: --initializing the variable l_usage_type to NULL
3015: l_usage_type := NULL;
3016:

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

3158: x_msg_count := l_msg_cnt;
3159: x_msg_data := l_msg_data;
3160: END IF;
3161:
3162: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
3163: RAISE MAIN_CUR_EXCEPTION;
3164: END IF; -- (l_ret_stat = 'S')
3165:
3166:

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

3743: x_msg_count := l_msg_cnt;
3744: x_msg_data := l_msg_data;
3745: END IF;
3746:
3747: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
3748: RAISE MAIN_CUR_EXCEPTION;
3749:
3750: END IF;
3751:

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

3940: );
3941:
3942: IF (l_ret_stat <> 'S') THEN
3943: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER Auto Invoice Not Run'||Bcl_rec.cle_id);
3944: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
3945: l_msg_data:='OKS_ARFEEDER_PUB.Get_REC_FEEDER Auto Invoice Not Run '||Bcl_rec.cle_id ||
3946: ' for the date billed from '||bcl_rec.date_billed_from|| ' and the date billed to '||bcl_rec.date_billed_to; --skuchima 10416595
3947: RAISE MAIN_CUR_EXCEPTION;
3948: End if;

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

4025: x_msg_count := l_msg_cnt;
4026: x_msg_data := l_msg_data;
4027: END IF;
4028:
4029: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4030: RAISE MAIN_CUR_EXCEPTION;
4031: END IF;
4032:
4033: l_amount := (bcl_rec.amount);

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

4095: x_msg_count := l_msg_cnt;
4096: x_msg_data := l_msg_data;
4097:
4098: END IF;
4099: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4100: RAISE MAIN_CUR_EXCEPTION;
4101: END IF;
4102:
4103: IF P_PRV = 1 THEN

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

4156: x_msg_count := l_msg_cnt;
4157: x_msg_data := l_msg_data;
4158:
4159: END IF;
4160: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4161: RAISE MAIN_CUR_EXCEPTION;
4162: END IF;
4163:
4164: If G_LOG_YES_NO = 'YES' then

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

4270:
4271: IF (l_ret_stat <> 'S') THEN
4272: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER Auto Invoice Not Run'||Bcl_rec.cle_id);
4273:
4274: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4275:
4276: l_msg_data:='OKS_ARFEEDER_PUB.Get_REC_FEEDER Auto Invoice Not Run '||Bcl_rec.cle_id ||
4277: ' for the date billed from '||bcl_rec.date_billed_from|| ' and the date billed to '||bcl_rec.date_billed_to; --skuchima 10416595
4278:

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

4364: l_msg_data => l_msg_data);
4365:
4366: x_msg_count := l_msg_cnt;
4367: x_msg_data := l_msg_data;
4368: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4369: RAISE MAIN_CUR_EXCEPTION;
4370: END IF;
4371:
4372: l_amount := (bsl_rec.amount);

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

4525: l_msg_data => l_msg_data);
4526:
4527: x_msg_count := l_msg_cnt;
4528: x_msg_data := l_msg_data;
4529: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4530: RAISE MAIN_CUR_EXCEPTION;
4531: END IF;
4532:
4533: INSERT_RA_REV_DIST( l_ret_stat,

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

4535:
4536: IF (l_ret_stat <> 'S') THEN
4537: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_REVENUE_DISTRIBUTIO NS'||lines_rec.id);
4538:
4539: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4540: RAISE MAIN_CUR_EXCEPTION;
4541: END IF;
4542:
4543: If G_LOG_YES_NO = 'YES' then

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

4550: l_ret_stat);
4551:
4552: IF ( l_ret_stat <> 'S') THEN
4553: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_SALES_CREDIT FAILED'||lines_rec.id);
4554: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4555:
4556: l_msg_data:= 'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_SALES_CREDIT FAILED '||lines_rec.id; --skuchima 10416595
4557:
4558: RAISE MAIN_CUR_EXCEPTION;

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

4610: l_msg_data => l_msg_data);
4611:
4612: x_msg_count := l_msg_cnt;
4613: x_msg_data := l_msg_data;
4614: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4615: RAISE MAIN_CUR_EXCEPTION;
4616: END IF;
4617:
4618: ELSE ---normal

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

4632:
4633: x_msg_count := l_msg_cnt;
4634: x_msg_data := l_msg_data;
4635:
4636: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4637: RAISE MAIN_CUR_EXCEPTION;
4638:
4639: END IF; --IF (l_ret_stat <> 'S')
4640:

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

4674: l_ret_stat);
4675:
4676: IF ( l_ret_stat <> 'S') THEN
4677: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_SALES_CREDIT FAILED'||lines_rec.id);
4678: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4679: l_msg_data:= 'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_SALES_CREDIT FAILED '||lines_rec.id; ---skuchima
4680: RAISE MAIN_CUR_EXCEPTION;
4681: END IF;
4682: If G_LOG_YES_NO = 'YES' then

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

4774: END IF; -- P_PRV <> 3
4775:
4776: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER MAIN_CUR_EXCEPTION RAISED '||sqlerrm);
4777: l_reject_counter := l_reject_counter + 1;
4778: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4779: x_return_status := OKC_API.G_RET_STS_ERROR;
4780: WHEN OTHERS THEN
4781:
4782: /*FOR BILLING REPORT*/

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

4838:
4839: x_return_status := OKC_API.G_RET_STS_ERROR;
4840: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER OTHERS EXCEPTION RAISED'||sqlerrm);
4841: l_reject_counter := l_reject_counter + 1;
4842: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4843:
4844: END;
4845:
4846: IF (p_prv <> 3 and nvl(report_bill_action,'RI') <> 'AV') THEN

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

4903: EXCEPTION
4904: WHEN G_EXCEPTION_BILLING THEN
4905: --x_return_status := OKC_API.G_RET_STS_ERROR;
4906: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER G_BILLING_EXCEPTION RAISED '||sqlerrm);
4907: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4908: WHEN OTHERS THEN
4909: --x_return_status := OKC_API.G_RET_STS_ERROR;
4910: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER WHEN OTHERS EXCEPTION RAISED'||sqlerrm);
4911: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');

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

4907: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4908: WHEN OTHERS THEN
4909: --x_return_status := OKC_API.G_RET_STS_ERROR;
4910: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER WHEN OTHERS EXCEPTION RAISED'||sqlerrm);
4911: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4912:
4913: End Get_REC_FEEDER;
4914:
4915: Procedure Populate_TR_reference_fields(p_instance_number IN NUMBER,