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

Line 1: Package BODY pa_billing_pub AS

1: Package BODY pa_billing_pub AS
2: /* $Header: PAXIPUBB.pls 120.6.12020000.2 2012/07/19 10:05:00 admarath ship $ */
3:
4: --------------------------------------
5: -- PROCEDURE/FUNCTION IMPLEMENTATIONS

Line 71: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_pub.get_budget_amount: ');

67: cost_budget_not_baselined EXCEPTION;
68:
69: BEGIN
70: IF g1_debug_mode = 'Y' THEN
71: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_pub.get_budget_amount: ');
72: END IF;
73: X_status := 0;
74: X_error_message := NULL;
75: BEGIN

Line 278: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_pub.get_budget_amount: ');

274:
275: -- If any exception then raise it to the calling pl/sql block
276: --
277: IF g1_debug_mode = 'Y' THEN
278: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_pub.get_budget_amount: ');
279: END IF;
280: EXCEPTION
281: WHEN invalid_cost_budget_code THEN
282: status := pa_billing_values.get_message('INVALID_COST_BUDGET_TYPE');

Line 317: (X_inserting_procedure_name =>'pa_billing_pub.get_budget_amount',

313: X_error_message := status;
314: X_status := l_status;
315:
316: insert_message
317: (X_inserting_procedure_name =>'pa_billing_pub.get_budget_amount',
318: X_attribute1 => l_cost_budget_type_code,
319: X_attribute2 => l_rev_budget_type_code,
320: X_message => status,
321: X_error_message=>err_msg,

Line 497: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_pub.get_amount: ');

493:
494: BEGIN
495:
496: IF g1_debug_mode = 'Y' THEN
497: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_pub.get_amount: ');
498: END IF;
499: total_amount := 0;
500:
501: IF (X_Request_id IS NULL) THEN -->No RqstId given

Line 533: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_pub.get_amount: ');

529: END IF;
530: X_amount := pa_currency.round_currency_amt(total_amount);
531:
532: IF g1_debug_mode = 'Y' THEN
533: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_pub.get_amount: ');
534: END IF;
535: EXCEPTION
536: WHEN NO_DATA_FOUND THEN
537: -- DBMS_OUTPUT.PUT_LINE(SQLERRM);

Line 578: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_pub.insert_message: ');

574: xo_line_num NUMBER(15);
575:
576: BEGIN
577: IF g1_debug_mode = 'Y' THEN
578: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_pub.insert_message: ');
579: END IF;
580: x_created_by := FND_GLOBAL.USER_ID;
581: x_last_updated_by := FND_GLOBAL.USER_ID;
582: x_last_update_login := FND_GLOBAL.LOGIN_ID;

Line 667: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_pub.insert_message: ');

663:
664: --commit;
665:
666: IF g1_debug_mode = 'Y' THEN
667: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_pub.insert_message: ');
668: END IF;
669: EXCEPTION
670: WHEN OTHERS THEN
671: -- DBMS_OUTPUT.PUT(SQLERRM);

Line 810: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_pub.insert_event:' );

806:
807: BEGIN
808: BEGIN
809: IF g1_debug_mode = 'Y' THEN
810: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_pub.insert_event:' );
811: END IF;
812: -- Assigning who columns for insertion into PA_EVENTS.
813:
814: created_by := FND_GLOBAL.USER_ID;

Line 875: PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event: rev amt'||to_char(XD_bill_trans_rev_amt));

871:
872: /* Rounding the transaction amount upto the precision of transaction currency for MCB2 */
873: XD_bill_trans_rev_amt := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(NVL(X_rev_amt, 0),l_txn_currency_code);
874: IF g1_debug_mode = 'Y' THEN
875: PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event: rev amt'||to_char(XD_bill_trans_rev_amt));
876: END IF;
877: XD_bill_trans_bill_amt := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(NVL(X_bill_amt,0),l_txn_currency_code);
878: IF g1_debug_mode = 'Y' THEN
879: PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event: inv amt'||to_char(XD_bill_trans_bill_amt));

Line 879: PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event: inv amt'||to_char(XD_bill_trans_bill_amt));

875: PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event: rev amt'||to_char(XD_bill_trans_rev_amt));
876: END IF;
877: XD_bill_trans_bill_amt := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(NVL(X_bill_amt,0),l_txn_currency_code);
878: IF g1_debug_mode = 'Y' THEN
879: PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event: inv amt'||to_char(XD_bill_trans_bill_amt));
880: END IF;
881: /* The following amounts have been commented for MCB2, the above amounts are satisfying the same requirement */
882: /* XD_bill_trans_rev_amt := (NVL(X_rev_amt, 0));
883: XD_bill_trans_bill_amt := (NVL(X_bill_amt,0)); */

Line 1353: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_pub.insert_events: ');

1349: END IF;
1350: -- COMMIT;
1351:
1352: IF g1_debug_mode = 'Y' THEN
1353: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_pub.insert_events: ');
1354: END IF;
1355: EXCEPTION
1356: WHEN mandatory_prm_missing THEN
1357: status := pa_billing_values.get_message('MANDATORY_PRM_MISSING');

Line 1436: insert_message(X_inserting_procedure_name => 'pa_billing_pub.insert_event',

1432: -- DBMS_OUTPUT.PUT_LINE(SQLERRM);
1433: X_error_message := status;
1434: X_status := l_status;
1435:
1436: insert_message(X_inserting_procedure_name => 'pa_billing_pub.insert_event',
1437: X_attribute1 => XD_bill_trans_rev_amt,
1438: X_attribute2 => XD_bill_trans_bill_amt,
1439: X_message => status,
1440: X_status => err_status,

Line 1649: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_pub.insert_event2:' );

1645:
1646: BEGIN
1647: BEGIN
1648: IF g1_debug_mode = 'Y' THEN
1649: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_pub.insert_event2:' );
1650: END IF;
1651: -- Assigning who columns for insertion into PA_EVENTS.
1652:
1653: created_by := FND_GLOBAL.USER_ID;

Line 1714: PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event2: rev amt'||to_char(XD_bill_trans_rev_amt));

1710:
1711: /* Rounding the transaction amount upto the precision of transaction currency for MCB2 */
1712: XD_bill_trans_rev_amt := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(NVL(X_rev_amt, 0),l_txn_currency_code);
1713: IF g1_debug_mode = 'Y' THEN
1714: PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event2: rev amt'||to_char(XD_bill_trans_rev_amt));
1715: END IF;
1716: XD_bill_trans_bill_amt := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(NVL(X_bill_amt,0),l_txn_currency_code);
1717: IF g1_debug_mode = 'Y' THEN
1718: PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event2: inv amt'||to_char(XD_bill_trans_bill_amt));

Line 1718: PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event2: inv amt'||to_char(XD_bill_trans_bill_amt));

1714: PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event2: rev amt'||to_char(XD_bill_trans_rev_amt));
1715: END IF;
1716: XD_bill_trans_bill_amt := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(NVL(X_bill_amt,0),l_txn_currency_code);
1717: IF g1_debug_mode = 'Y' THEN
1718: PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event2: inv amt'||to_char(XD_bill_trans_bill_amt));
1719: END IF;
1720: /* The following amounts have been commented for MCB2, the above amounts are satisfying the same requirement */
1721: /* XD_bill_trans_rev_amt := (NVL(X_rev_amt, 0));
1722: XD_bill_trans_bill_amt := (NVL(X_bill_amt,0)); */

Line 2202: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_pub.insert_event2: ');

2198:
2199:
2200:
2201: IF g1_debug_mode = 'Y' THEN
2202: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_pub.insert_event2: ');
2203: END IF;
2204: EXCEPTION
2205: WHEN mandatory_prm_missing THEN
2206: status := pa_billing_values.get_message('MANDATORY_PRM_MISSING');

Line 2285: insert_message(X_inserting_procedure_name => 'pa_billing_pub.insert_event2',

2281: -- DBMS_OUTPUT.PUT_LINE(SQLERRM);
2282: X_error_message := status;
2283: X_status := l_status;
2284:
2285: insert_message(X_inserting_procedure_name => 'pa_billing_pub.insert_event2',
2286: X_attribute1 => XD_bill_trans_rev_amt,
2287: X_attribute2 => XD_bill_trans_bill_amt,
2288: X_message => status,
2289: X_status => err_status,

Line 2304: END pa_billing_pub;

2300:
2301:
2302: --ER 14089913
2303:
2304: END pa_billing_pub;