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.AR_REVENUE_MANAGEMENT_PVT dependencies on AR_REVENUE_MANAGEMENT_PVT

Line 1: PACKAGE BODY ar_revenue_management_pvt AS

1: PACKAGE BODY ar_revenue_management_pvt AS
2: /* $Header: ARXRVMGB.pls 120.134.12020000.10 2012/10/02 03:51:25 vpotti ship $ */
3:
4:
5: /*=======================================================================+

Line 359: AND ar_revenue_management_pvt.creditworthy

355: AND ct.org_id = ctt.org_id
356: AND ctt.type = 'INV'
357: AND ctl.line_type = 'LINE'
358: AND NVL(ctl.deferral_exclusion_flag, 'N') = 'N'
359: AND ar_revenue_management_pvt.creditworthy
360: (ct.bill_to_customer_id, ct.bill_to_site_use_id)= 0
361: AND NOT EXISTS
362: (SELECT 'errors'
363: FROM ar_trx_errors_gt teg,

Line 427: AND ar_revenue_management_pvt.creditworthy

423: AND ct.org_id = ctt.org_id
424: AND ctt.type = 'INV'
425: AND ctl.line_type = 'LINE'
426: AND NVL(ctl.deferral_exclusion_flag, 'N') = 'N'
427: AND ar_revenue_management_pvt.creditworthy
428: (ct.bill_to_customer_id, ct.bill_to_site_use_id)= 0
429: AND NOT EXISTS
430: (SELECT 'errors'
431: FROM ra_interface_errors_all ie

Line 492: AND ar_revenue_management_pvt.creditworthy

488: AND ct.org_id = ctt.org_id
489: AND ctt.type = 'INV'
490: AND ctl.line_type = 'LINE'
491: AND NVL(ctl.deferral_exclusion_flag, 'N') = 'N'
492: AND ar_revenue_management_pvt.creditworthy
493: (ct.bill_to_customer_id, ct.bill_to_site_use_id)= 0
494: AND NOT EXISTS
495: (SELECT 'prevent duplicate contingency'
496: FROM ar_line_conts_all alc

Line 1183: AND ar_revenue_management_pvt.creditworthy

1179: FROM ra_customer_trx_lines ctl,
1180: ra_customer_trx ct
1181: WHERE ctl.customer_trx_id = ct.customer_trx_id
1182: AND ctl.request_id = p_request_id
1183: AND ar_revenue_management_pvt.creditworthy
1184: (ct.bill_to_customer_id, ct.bill_to_site_use_id)= 1)
1185: AND EXISTS
1186: (SELECT 'its a CREDIT_CLASSIFICATION'
1187: FROM ar_deferral_reasons dr

Line 1282: AND ar_revenue_management_pvt.creditworthy

1278: FROM ra_customer_trx_lines ctl,
1279: ra_customer_trx ct
1280: WHERE ctl.customer_trx_id = ct.customer_trx_id
1281: AND ctl.customer_trx_line_id = p_customer_trx_line_id
1282: AND ar_revenue_management_pvt.creditworthy
1283: (ct.bill_to_customer_id, ct.bill_to_site_use_id)= 1);
1284:
1285: IF PG_DEBUG IN ('Y','C')
1286: THEN

Line 4584: debug('ar_revenue_management_pvt.revenue_management_enabled()+');

4580: -- it automatically means Revenue Management would not manage that
4581: -- transaction. So, this subroutine returns TRUE in hard coded
4582: -- fashion.
4583:
4584: debug('ar_revenue_management_pvt.revenue_management_enabled()+');
4585: l_return_value := TRUE;
4586:
4587: debug('ar_revenue_management_pvt.revenue_management_enabled()-');
4588: RETURN l_return_value;

Line 4587: debug('ar_revenue_management_pvt.revenue_management_enabled()-');

4583:
4584: debug('ar_revenue_management_pvt.revenue_management_enabled()+');
4585: l_return_value := TRUE;
4586:
4587: debug('ar_revenue_management_pvt.revenue_management_enabled()-');
4588: RETURN l_return_value;
4589:
4590: EXCEPTION
4591:

Line 4658: debug('ar_revenue_management_pvt.line_collectible()+');

4654:
4655: BEGIN
4656:
4657: IF pg_debug IN ('Y', 'C') THEN
4658: debug('ar_revenue_management_pvt.line_collectible()+');
4659: debug('** line_collectible parameters **');
4660: debug(' p_customer_trx_id : ' || p_customer_trx_id);
4661: debug(' p_customer_trx_line_id : ' ||
4662: p_customer_trx_line_id);

Line 4679: debug('ar_revenue_management_pvt.line_collectible()-');

4675:
4676: CLOSE c;
4677:
4678: IF pg_debug IN ('Y', 'C') THEN
4679: debug('ar_revenue_management_pvt.line_collectible()-');
4680: END IF;
4681:
4682: RETURN l_return_value;
4683:

Line 4762: debug('ar_revenue_management_pvt.txn_collectible()+');

4758: l_cont VARCHAR2(50);
4759: BEGIN
4760:
4761: IF pg_debug IN ('Y', 'C') THEN
4762: debug('ar_revenue_management_pvt.txn_collectible()+');
4763: debug('** txn_collectible parameters **');
4764: debug(' p_customer_trx_id : ' || p_customer_trx_id);
4765: END IF;
4766:

Line 4788: debug('ar_revenue_management_pvt.txn_collectible()-');

4784: end if;
4785: end if;
4786:
4787: IF pg_debug IN ('Y', 'C') THEN
4788: debug('ar_revenue_management_pvt.txn_collectible()-');
4789: END IF;
4790:
4791: RETURN l_return_value;
4792:

Line 4843: debug('ar_revenue_management_pvt.delete_failed_rows()+');

4839:
4840: BEGIN
4841:
4842: IF pg_debug IN ('Y', 'C') THEN
4843: debug('ar_revenue_management_pvt.delete_failed_rows()+');
4844: debug('** delete_failed_rows parameters **');
4845: debug(' p_request_id : ' || p_request_id);
4846: END IF;
4847:

Line 4855: debug('ar_revenue_management_pvt.delete_failed_rows()-');

4851: DELETE FROM ar_line_conts
4852: WHERE request_id = p_request_id;
4853:
4854: IF pg_debug IN ('Y', 'C') THEN
4855: debug('ar_revenue_management_pvt.delete_failed_rows()-');
4856: END IF;
4857:
4858: EXCEPTION
4859:

Line 4909: debug('ar_revenue_management_pvt.delete_rejected_rows()+');

4905: PROCEDURE delete_rejected_rows (p_request_id IN NUMBER) IS
4906:
4907: BEGIN
4908:
4909: debug('ar_revenue_management_pvt.delete_rejected_rows()+');
4910: debug('** delete_rejected_rows parameters **');
4911: debug(' p_request_id : ' || p_request_id);
4912:
4913: ---------------------------------------------------------------------------

Line 4956: debug('ar_revenue_management_pvt.delete_rejected_rows()-');

4952: AND il.request_id = p_request_id
4953: );
4954:
4955: debug('lines deleted : ' || SQL%ROWCOUNT);
4956: debug('ar_revenue_management_pvt.delete_rejected_rows()-');
4957:
4958: EXCEPTION
4959:
4960: WHEN NO_DATA_FOUND THEN

Line 5037: debug('ar_revenue_management_pvt.acceptance_allowed()+');

5033: | do not have an acceptance problem.
5034: +------------------------------------------------------------------------*/
5035:
5036: IF pg_debug IN ('Y', 'C') THEN
5037: debug('ar_revenue_management_pvt.acceptance_allowed()+');
5038: debug('** acceptance_allowed parameters **');
5039: debug(' p_customer_trx_id : ' || p_customer_trx_id);
5040: debug(' p_customer_trx_line_id : ' ||
5041: p_customer_trx_line_id);

Line 5071: debug('ar_revenue_management_pvt.acceptance_allowed()-');

5067: END IF;
5068:
5069: IF pg_debug IN ('Y', 'C') THEN
5070: debug('Acceptance Allowed? : ' || l_return_value);
5071: debug('ar_revenue_management_pvt.acceptance_allowed()-');
5072: END IF;
5073:
5074: RETURN l_return_value;
5075:

Line 5140: debug('ar_revenue_management_pvt.cash_based()+');

5136:
5137: BEGIN
5138:
5139: IF pg_debug IN ('Y', 'C') THEN
5140: debug('ar_revenue_management_pvt.cash_based()+');
5141: debug('** cash_based parameters **');
5142: debug(' p_customer_trx_id : ' || p_customer_trx_id);
5143: END IF;
5144:

Line 5164: debug('ar_revenue_management_pvt.cash_based()-');

5160:
5161: CLOSE contingencies;
5162:
5163: IF pg_debug IN ('Y', 'C') THEN
5164: debug('ar_revenue_management_pvt.cash_based()-');
5165: END IF;
5166:
5167: EXCEPTION
5168:

Line 5479: debug('ar_revenue_management_pvt.revenue_synchronizer +');

5475:
5476: BEGIN
5477:
5478: IF pg_debug IN ('Y', 'C') THEN
5479: debug('ar_revenue_management_pvt.revenue_synchronizer +');
5480: debug('** revenue_synchronizer parameters **');
5481: debug(' p_mode : ' || p_mode);
5482: debug(' p_customer_trx_id : ' || p_customer_trx_id);
5483: debug(' p_customer_trx_line_id : ' ||

Line 5849: debug('ar_revenue_management_pvt.revenue_synchronizer()-');

5845:
5846: END IF;
5847:
5848: IF pg_debug IN ('Y', 'C') THEN
5849: debug('ar_revenue_management_pvt.revenue_synchronizer()-');
5850: END IF;
5851:
5852: EXCEPTION
5853:

Line 5966: debug('ar_revenue_management_pvt.periodic_sweeper +');

5962: error_message VARCHAR2(50);
5963:
5964: BEGIN
5965:
5966: debug('ar_revenue_management_pvt.periodic_sweeper +');
5967:
5968: retcode := SUCCESS;
5969:
5970: l_request_id := fnd_global.conc_request_id;

Line 6247: debug('ar_revenue_management_pvt.periodic_sweeper -');

6243: debug('Unable to set WARNING return status');
6244: END IF;
6245: END IF;
6246:
6247: debug('ar_revenue_management_pvt.periodic_sweeper -');
6248:
6249: EXCEPTION
6250:
6251: WHEN NO_DATA_FOUND THEN

Line 6520: debug('ar_revenue_management_pvt.receipt_analyzer +');

6516: SKIP_RECEIPT_ANALYZER EXCEPTION;
6517: BEGIN
6518:
6519: IF pg_debug IN ('Y', 'C') THEN
6520: debug('ar_revenue_management_pvt.receipt_analyzer +');
6521: END IF;
6522:
6523: get_receipt_parameters (
6524: p_mode => p_mode,

Line 7139: debug('ar_revenue_management_pvt.receipt_analyzer()-');

7135:
7136: END LOOP; -- (rev_lines => bulk collect)
7137:
7138: IF pg_debug IN ('Y', 'C') THEN
7139: debug('ar_revenue_management_pvt.receipt_analyzer()-');
7140: END IF;
7141:
7142: EXCEPTION
7143:

Line 7146: debug('ar_revenue_management_pvt.receipt_analyzer()-');

7142: EXCEPTION
7143:
7144: WHEN SKIP_RECEIPT_ANALYZER THEN
7145: IF pg_debug IN ('Y', 'C') THEN
7146: debug('ar_revenue_management_pvt.receipt_analyzer()-');
7147: END IF;
7148:
7149: WHEN NO_DATA_FOUND THEN
7150: IF pg_debug IN ('Y', 'C') THEN

Line 7231: debug('ar_revenue_management_pvt.receipt_analyzer()+ ');

7227: l_gl_date_tbl date_table;
7228:
7229: BEGIN
7230:
7231: debug('ar_revenue_management_pvt.receipt_analyzer()+ ');
7232: debug(' p_request_id : ' || p_request_id);
7233:
7234: OPEN receipts;
7235: LOOP

Line 7303: debug('ar_revenue_management_pvt.receipt_analyzer()- ');

7299: END LOOP;
7300:
7301: CLOSE receipts;
7302:
7303: debug('ar_revenue_management_pvt.receipt_analyzer()- ');
7304:
7305: EXCEPTION
7306:
7307: WHEN NO_DATA_FOUND THEN

Line 7360: debug('ar_revenue_management_pvt.line_collectibility()+');

7356: l_line_verdict NUMBER;
7357:
7358: BEGIN
7359:
7360: debug('ar_revenue_management_pvt.line_collectibility()+');
7361: debug('** line_collectibility parameters **');
7362: debug(' p_customer_trx_id : ' || p_customer_trx_id);
7363: debug(' p_customer_trx_line_id : ' || p_customer_trx_line_id);
7364:

Line 7373: debug('ar_revenue_management_pvt.line_collectibility()-');

7369: IF (l_line_verdict = not_analyzed) THEN
7370: RETURN collect;
7371: END IF;
7372:
7373: debug('ar_revenue_management_pvt.line_collectibility()-');
7374:
7375: RETURN l_line_verdict;
7376:
7377: EXCEPTION

Line 7451: debug('ar_revenue_management_pvt.line_collectibility()+');

7447: BEGIN
7448:
7449: g_source := p_source;
7450:
7451: debug('ar_revenue_management_pvt.line_collectibility()+');
7452: debug(' p_request_id : ' || p_request_id);
7453: debug(' p_source : ' || p_source);
7454: debug(' p_customer_trx_line_id : ' || p_customer_trx_line_id);
7455:

Line 7497: debug('ar_revenue_management_pvt.line_collectibility()-');

7493: debug('Verdict: ' || revline.verdict);
7494: l_line_verdicts_tbl(revline.customer_trx_line_id) := revline.verdict;
7495: END LOOP;
7496:
7497: debug('ar_revenue_management_pvt.line_collectibility()-');
7498:
7499: RETURN l_line_verdicts_tbl;
7500:
7501: EXCEPTION

Line 7546: debug(' ar_revenue_management_pvt.initialize');

7542:
7543: EXCEPTION
7544:
7545: WHEN NO_DATA_FOUND THEN
7546: debug(' ar_revenue_management_pvt.initialize');
7547: debug(sqlerrm);
7548: RAISE;
7549:
7550: WHEN OTHERS THEN

Line 7551: debug(' ar_revenue_management_pvt.initialize');

7547: debug(sqlerrm);
7548: RAISE;
7549:
7550: WHEN OTHERS THEN
7551: debug(' ar_revenue_management_pvt.initialize');
7552: debug(sqlerrm);
7553: RAISE;
7554:
7555: END ar_revenue_management_pvt;

Line 7555: END ar_revenue_management_pvt;

7551: debug(' ar_revenue_management_pvt.initialize');
7552: debug(sqlerrm);
7553: RAISE;
7554:
7555: END ar_revenue_management_pvt;