DBA Data[Home] [Help]

APPS.AP_RECONCILIATION_PKG dependencies on AP_UTILITIES_PKG

Line 371: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

367: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
368: END IF;
369: ---------------------------------------------------------------
370: /* Start bug 12555714 - trx_base_amount should be NULL if exchange rate is null
371: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
372: -- X_Transaction_Amount*nvl(X_Exchange_Rate, 1),
373: -- Bug 3168106
374: X_Transaction_Amount* NVL(X_Exchange_Rate, l_exchange_rate), --bug 9069767
375: l_functional_currency_code );

Line 377: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

373: -- Bug 3168106
374: X_Transaction_Amount* NVL(X_Exchange_Rate, l_exchange_rate), --bug 9069767
375: l_functional_currency_code );
376: */
377: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
378: X_Transaction_Amount*X_Exchange_Rate, l_functional_currency_code);
379: /* End bug 12555714 */
380: ------------------------------------------------------------
381: l_debug_info := 'Insert Payment History';

Line 760: l_remainder_errors_pmt_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

756: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
757: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
758: END IF;
759: ---------------------------------------------------------------
760: l_remainder_errors_pmt_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
761: l_errors_bank_amount / nvl(l_pmt_to_base_xrate,1), --bug8628166
762: l_pmt_currency_code );
763: l_remainder_charges_pmt_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
764: l_charges_bank_amount / nvl(l_pmt_to_base_xrate,1), --bug8628166

Line 763: l_remainder_charges_pmt_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

759: ---------------------------------------------------------------
760: l_remainder_errors_pmt_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
761: l_errors_bank_amount / nvl(l_pmt_to_base_xrate,1), --bug8628166
762: l_pmt_currency_code );
763: l_remainder_charges_pmt_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
764: l_charges_bank_amount / nvl(l_pmt_to_base_xrate,1), --bug8628166
765: l_pmt_currency_code );
766:
767: -- Since the bank and base currencies are the same ...

Line 829: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

825: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
826: END IF;
827: ---------------------------------------------------------------
828:
829: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
830: l_errors_pmt_amount/l_payment_count,
831: l_pmt_currency_code );
832: l_ind_charges_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
833: l_charges_pmt_amount/l_payment_count,

Line 832: l_ind_charges_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

828:
829: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
830: l_errors_pmt_amount/l_payment_count,
831: l_pmt_currency_code );
832: l_ind_charges_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
833: l_charges_pmt_amount/l_payment_count,
834: l_pmt_currency_code );
835:
836: ELSIF (l_running_total_payments = l_pay_sum_amt) THEN

Line 853: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

849: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
850: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
851: END IF;
852: ---------------------------------------------------------------
853: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
854: l_errors_pmt_amount*l_check_amount
855: /l_pay_sum_amt,
856: l_pmt_currency_code );
857: l_ind_charges_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

Line 857: l_ind_charges_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

853: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
854: l_errors_pmt_amount*l_check_amount
855: /l_pay_sum_amt,
856: l_pmt_currency_code );
857: l_ind_charges_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
858: l_charges_pmt_amount*l_check_amount
859: /l_pay_sum_amt,
860: l_pmt_currency_code );
861:

Line 932: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

928: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
929: END IF;
930: ---------------------------------------------------------------
931:
932: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
933: (l_check_amount + l_ind_errors_pmt_amount
934: + l_ind_charges_pmt_amount) * nvl(l_pmt_to_base_xrate,1),
935: l_functional_currency_code); --bug8628166
936: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

Line 936: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

932: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
933: (l_check_amount + l_ind_errors_pmt_amount
934: + l_ind_charges_pmt_amount) * nvl(l_pmt_to_base_xrate,1),
935: l_functional_currency_code); --bug8628166
936: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
937: l_ind_errors_pmt_amount
938: * nvl(l_pmt_to_base_xrate,1),
939: l_functional_currency_code); -- bug8628166
940: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

Line 940: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

936: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
937: l_ind_errors_pmt_amount
938: * nvl(l_pmt_to_base_xrate,1),
939: l_functional_currency_code); -- bug8628166
940: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
941: l_ind_charges_pmt_amount
942: * nvl(l_pmt_to_base_xrate,1), l_functional_currency_code); --bug8628166
943: END IF;
944:

Line 1008: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1004: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1005: END IF;
1006: ---------------------------------------------------------------
1007:
1008: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1009: (l_check_amount + l_ind_errors_pmt_amount
1010: + l_ind_charges_pmt_amount) * nvl(l_pmt_to_base_xrate,1),
1011: l_functional_currency_code); --bug8628166
1012: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

Line 1012: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1008: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1009: (l_check_amount + l_ind_errors_pmt_amount
1010: + l_ind_charges_pmt_amount) * nvl(l_pmt_to_base_xrate,1),
1011: l_functional_currency_code); --bug8628166
1012: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1013: l_ind_errors_pmt_amount
1014: * nvl(l_pmt_to_base_xrate,1),
1015: l_functional_currency_code); --bug8628166
1016: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

Line 1016: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1012: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1013: l_ind_errors_pmt_amount
1014: * nvl(l_pmt_to_base_xrate,1),
1015: l_functional_currency_code); --bug8628166
1016: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1017: l_ind_charges_pmt_amount
1018: * nvl(l_pmt_to_base_xrate,1),
1019: l_functional_currency_code); --bug8628166
1020: -- Bug 2276503

Line 1157: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1153: l_charges_base_amount := X_CHARGES_BANK_AMOUNT
1154: - l_runtotal_charges_bank_amount;
1155: ELSE
1156:
1157: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1158: (l_check_amount + l_ind_errors_pmt_amount
1159: + l_ind_charges_pmt_amount)
1160: * nvl(l_pmt_to_base_xrate,1),
1161: l_functional_currency_code); --bug8628166

Line 1162: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1158: (l_check_amount + l_ind_errors_pmt_amount
1159: + l_ind_charges_pmt_amount)
1160: * nvl(l_pmt_to_base_xrate,1),
1161: l_functional_currency_code); --bug8628166
1162: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1163: l_ind_errors_pmt_amount
1164: * nvl(l_pmt_to_base_xrate,1),
1165: l_functional_currency_code); --bug8628166
1166: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

Line 1166: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1162: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1163: l_ind_errors_pmt_amount
1164: * nvl(l_pmt_to_base_xrate,1),
1165: l_functional_currency_code); --bug8628166
1166: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1167: l_ind_charges_pmt_amount
1168: * nvl(l_pmt_to_base_xrate,1),
1169: l_functional_currency_code); --bug8628166
1170: END IF;

Line 1174: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1170: END IF;
1171:
1172: ELSIF (l_currency_case = 'FOREIGN') THEN
1173:
1174: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1175: (l_check_amount + l_ind_errors_pmt_amount
1176: + l_ind_charges_pmt_amount)
1177: * nvl(l_pmt_to_base_xrate,1),
1178: l_functional_currency_code); -- bug8628166

Line 1179: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1175: (l_check_amount + l_ind_errors_pmt_amount
1176: + l_ind_charges_pmt_amount)
1177: * nvl(l_pmt_to_base_xrate,1),
1178: l_functional_currency_code); -- bug8628166
1179: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1180: l_ind_errors_pmt_amount
1181: * nvl(l_pmt_to_base_xrate,1),
1182: l_functional_currency_code); --bug8628166
1183: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

Line 1183: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1179: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1180: l_ind_errors_pmt_amount
1181: * nvl(l_pmt_to_base_xrate,1),
1182: l_functional_currency_code); --bug8628166
1183: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1184: l_ind_charges_pmt_amount
1185: * nvl(l_pmt_to_base_xrate,1),
1186: l_functional_currency_code); --bug8628166
1187:

Line 1345: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

1341: -- the errors and charges before proration.
1342: IF (l_currency_case = 'INTERNATIONAL') THEN
1343: l_debug_info := 'checkrun is null, inside International';
1344:
1345: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
1346: l_errors_bank_amount / nvl(l_pmt_to_base_xrate,1),
1347: l_pmt_currency_code ); --bug8628166
1348: l_ind_charges_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
1349: l_charges_bank_amount / nvl(l_pmt_to_base_xrate,1),

Line 1348: l_ind_charges_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

1344:
1345: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
1346: l_errors_bank_amount / nvl(l_pmt_to_base_xrate,1),
1347: l_pmt_currency_code ); --bug8628166
1348: l_ind_charges_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
1349: l_charges_bank_amount / nvl(l_pmt_to_base_xrate,1),
1350: l_pmt_currency_code ); --bug8628166
1351:
1352: -- Since the bank and base currencies are the same ...

Line 1485: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1481:
1482:
1483: ELSIF (l_currency_case = 'FOREIGN') THEN
1484:
1485: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1486: (l_check_amount + l_ind_errors_pmt_amount
1487: + l_ind_charges_pmt_amount) * nvl(l_pmt_to_base_xrate,1),
1488: l_functional_currency_code); --bug8628166
1489: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

Line 1489: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1485: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1486: (l_check_amount + l_ind_errors_pmt_amount
1487: + l_ind_charges_pmt_amount) * nvl(l_pmt_to_base_xrate,1),
1488: l_functional_currency_code); --bug8628166
1489: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1490: l_ind_errors_pmt_amount * nvl(l_pmt_to_base_xrate,1),
1491: l_functional_currency_code); --bug8628166
1492: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1493: l_ind_charges_pmt_amount * nvl(l_pmt_to_base_xrate,1),

Line 1492: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1488: l_functional_currency_code); --bug8628166
1489: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1490: l_ind_errors_pmt_amount * nvl(l_pmt_to_base_xrate,1),
1491: l_functional_currency_code); --bug8628166
1492: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1493: l_ind_charges_pmt_amount * nvl(l_pmt_to_base_xrate,1),
1494: l_functional_currency_code); --bug8628166
1495:
1496: -- Bug 2276503

Line 1621: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1617: l_charges_base_amount := X_CHARGES_BANK_AMOUNT;
1618:
1619: ELSIF (l_currency_case = 'FOREIGN') THEN
1620:
1621: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1622: (l_check_amount + l_ind_errors_pmt_amount
1623: + l_ind_charges_pmt_amount )
1624: * nvl(l_pmt_to_base_xrate,1),
1625: l_functional_currency_code); --bug8628166

Line 1627: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1623: + l_ind_charges_pmt_amount )
1624: * nvl(l_pmt_to_base_xrate,1),
1625: l_functional_currency_code); --bug8628166
1626:
1627: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1628: l_ind_errors_pmt_amount * nvl(l_pmt_to_base_xrate,1),
1629: l_functional_currency_code); --bug8628166
1630:
1631: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

Line 1631: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1627: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1628: l_ind_errors_pmt_amount * nvl(l_pmt_to_base_xrate,1),
1629: l_functional_currency_code); --bug8628166
1630:
1631: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1632: l_ind_charges_pmt_amount * nvl(l_pmt_to_base_xrate,1),
1633: l_functional_currency_code); --bug8628166
1634:
1635: ELSIF (l_currency_case = 'DOMESTIC') THEN