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.OKL_AUTO_CASH_APPL_RULES_PVT dependencies on FND_PROFILE

Line 390: /* l_cross_curr_enabled := nvl(FND_PROFILE.value('AR_ENABLE_CROSS_CURRENCY'),'N');

386: ,p_msg_name => 'OKL_BPD_PARAMS_MISMATCH'
387: );
388: END IF;
389: END IF;
390: /* l_cross_curr_enabled := nvl(FND_PROFILE.value('AR_ENABLE_CROSS_CURRENCY'),'N');
391: log_debug('l_cross_curr_enabled = '||l_cross_curr_enabled);
392: IF l_cross_curr_enabled <> 'Y' THEN
393: OKL_API.set_message( p_app_name => G_APP_NAME
394: ,p_msg_name => 'OKL_BPD_CROSS_CURR_NA'

Line 399: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

395: );
396: RAISE G_EXCEPTION_HALT_VALIDATION;
397: ELSE*/
398: IF l_inv_to_rct_rate is null THEN
399: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
400: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
401: IF l_exchange_rate_type IS NULL THEN
402: OKL_API.set_message( p_app_name => G_APP_NAME
403: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 571: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

567: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' l_rcpt_tbl(j).AMOUNT_APPLIED : '||l_rcpt_tbl(j).AMOUNT_APPLIED);
568: END IF;
569: IF l_currency_code <> l_inv_curr_code THEN
570: IF l_inv_to_rct_rate is null THEN
571: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
572: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
573: IF l_exchange_rate_type IS NULL THEN
574: OKL_API.set_message( p_app_name => G_APP_NAME
575: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 637: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

633: l_rcpt_tbl(j).AMOUNT_APPLIED := c_all_open_invs_rec.amount_due_remaining;
634: l_pro_rate_inv_total :=l_pro_rate_inv_total + l_rcpt_tbl(j).AMOUNT_APPLIED;
635: IF l_currency_code <> l_inv_curr_code THEN
636: IF l_inv_to_rct_rate is null THEN
637: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
638: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
639: IF l_exchange_rate_type IS NULL THEN
640: OKL_API.set_message( p_app_name => G_APP_NAME
641: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 703: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

699: l_rcpt_tbl(j).AMOUNT_APPLIED := l_temp_val * l_rcpt_tbl(j).AMOUNT_APPLIED;
700: l_rcpt_tbl(j).AMOUNT_APPLIED:=GET_ROUNDED_AMOUNT(l_rcpt_tbl(j).AMOUNT_APPLIED,l_inv_curr_code);
701: IF l_currency_code <> l_inv_curr_code THEN
702: IF l_inv_to_rct_rate is null THEN
703: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
704: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
705: IF l_exchange_rate_type IS NULL THEN
706: OKL_API.set_message( p_app_name => G_APP_NAME
707: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 745: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

741: if l_diff_amount > 0 then
742: l_rcpt_tbl(l_rcpt_tbl.LAST).amount_Applied := l_rcpt_tbl(l_rcpt_tbl.LAST).amount_Applied + l_diff_amount;
743: IF l_currency_code <> l_inv_curr_code THEN
744: IF l_inv_to_rct_rate is null THEN
745: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
746: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
747: IF l_exchange_rate_type IS NULL THEN
748: OKL_API.set_message( p_app_name => G_APP_NAME
749: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 817: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

813: l_amount_app_to := l_amount_app_to - l_rcpt_tbl(j).AMOUNT_APPLIED;
814: END IF;
815: IF l_currency_code <> l_inv_curr_code THEN
816: IF l_inv_to_rct_rate is null THEN
817: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
818: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
819: IF l_exchange_rate_type IS NULL THEN
820: OKL_API.set_message( p_app_name => G_APP_NAME
821: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 998: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

994: --Amount Applied will be total amount applied including line and tax
995: l_rcpt_tbl(j).AMOUNT_APPLIED := l_amount_app_to;
996: IF l_currency_code <> l_inv_curr_code THEN
997: IF l_inv_to_rct_rate is null THEN
998: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
999: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
1000: IF l_exchange_rate_type IS NULL THEN
1001: OKL_API.set_message( p_app_name => G_APP_NAME
1002: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 1098: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

1094: l_amount_app_to := l_amount_app_to - l_rcpt_tbl(j).AMOUNT_APPLIED;
1095: END IF;
1096: IF l_currency_code <> l_inv_curr_code THEN
1097: IF l_inv_to_rct_rate is null THEN
1098: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
1099: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
1100: IF l_exchange_rate_type IS NULL THEN
1101: OKL_API.set_message( p_app_name => G_APP_NAME
1102: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 1172: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

1168: l_rcpt_tbl(j).INVOICE_LINE_NUMBER := c_all_open_invs_rec.line_identifier;
1169: l_rcpt_tbl(j).AMOUNT_APPLIED := c_all_open_invs_rec.amount_due_remaining;
1170: IF l_currency_code <> l_inv_curr_code THEN
1171: IF l_inv_to_rct_rate is null THEN
1172: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
1173: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
1174: IF l_exchange_rate_type IS NULL THEN
1175: OKL_API.set_message( p_app_name => G_APP_NAME
1176: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 1237: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

1233: l_rcpt_tbl(j).AMOUNT_APPLIED := l_temp_val * l_rcpt_tbl(j).AMOUNT_APPLIED;
1234: l_rcpt_tbl(j).AMOUNT_APPLIED:=GET_ROUNDED_AMOUNT(l_rcpt_tbl(j).AMOUNT_APPLIED,l_inv_curr_code);
1235: IF l_currency_code <> l_inv_curr_code THEN
1236: IF l_inv_to_rct_rate is null THEN
1237: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
1238: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
1239: IF l_exchange_rate_type IS NULL THEN
1240: OKL_API.set_message( p_app_name => G_APP_NAME
1241: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 1279: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

1275: if l_diff_amount > 0 then
1276: l_rcpt_tbl(l_rcpt_tbl.LAST).amount_Applied := l_rcpt_tbl(l_rcpt_tbl.LAST).amount_Applied + l_diff_amount;
1277: IF l_currency_code <> l_inv_curr_code THEN
1278: IF l_inv_to_rct_rate is null THEN
1279: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
1280: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
1281: IF l_exchange_rate_type IS NULL THEN
1282: OKL_API.set_message( p_app_name => G_APP_NAME
1283: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 1350: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

1346: l_amount_app_to := l_amount_app_to - l_rcpt_tbl(j).AMOUNT_APPLIED;
1347: END IF;
1348: IF l_currency_code <> l_inv_curr_code THEN
1349: IF l_inv_to_rct_rate is null THEN
1350: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
1351: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
1352: IF l_exchange_rate_type IS NULL THEN
1353: OKL_API.set_message( p_app_name => G_APP_NAME
1354: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 1734: l_cross_curr_enabled := nvl(FND_PROFILE.value('AR_ENABLE_CROSS_CURRENCY'),'N');

1730: ,p_msg_name => 'OKL_BPD_PARAMS_MISMATCH'
1731: );
1732: END IF;
1733: END IF;
1734: l_cross_curr_enabled := nvl(FND_PROFILE.value('AR_ENABLE_CROSS_CURRENCY'),'N');
1735: log_debug('l_cross_curr_enabled = '||l_cross_curr_enabled);
1736: /* IF l_cross_curr_enabled <> 'Y' THEN
1737: OKL_API.set_message( p_app_name => G_APP_NAME
1738: ,p_msg_name => 'OKL_BPD_CROSS_CURR_NA'

Line 1743: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

1739: );
1740: RAISE G_EXCEPTION_HALT_VALIDATION;
1741: ELSE*/
1742: IF l_inv_to_rct_rate is null THEN
1743: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
1744: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
1745: IF l_exchange_rate_type IS NULL THEN
1746: OKL_API.set_message( p_app_name => G_APP_NAME
1747: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 1950: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

1946: l_rcpt_tbl(j).INVOICE_LINE_ID := c_open_invoices_contract_rec.invoice_line_id;
1947: l_rcpt_tbl(j).INVOICE_LINE_NUMBER := c_open_invoices_contract_rec.line_number;
1948: IF l_currency_code <> l_inv_curr_code THEN
1949: IF l_inv_to_rct_rate is null THEN
1950: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
1951: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
1952: IF l_exchange_rate_type IS NULL THEN
1953: OKL_API.set_message( p_app_name => G_APP_NAME
1954: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 2021: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

2017: l_pro_rate_inv_total := l_pro_rate_inv_total + l_rcpt_tbl(j).AMOUNT_APPLIED;
2018:
2019: IF l_currency_code <> l_inv_curr_code THEN
2020: IF l_inv_to_rct_rate is null THEN
2021: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
2022: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
2023: IF l_exchange_rate_type IS NULL THEN
2024: OKL_API.set_message( p_app_name => G_APP_NAME
2025: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 2091: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

2087: l_rcpt_tbl(j).AMOUNT_APPLIED:=GET_ROUNDED_AMOUNT(l_rcpt_tbl(j).AMOUNT_APPLIED,l_inv_curr_Code);
2088: l_inv_total_amt := l_inv_total_amt + l_rcpt_tbl(j).AMOUNT_APPLIED;
2089: IF l_currency_code <> l_inv_curr_code THEN
2090: IF l_inv_to_rct_rate is null THEN
2091: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
2092: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
2093: IF l_exchange_rate_type IS NULL THEN
2094: OKL_API.set_message( p_app_name => G_APP_NAME
2095: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 2133: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

2129: if l_diff_amount > 0 then
2130: l_rcpt_tbl(l_rcpt_tbl.LAST).amount_Applied := l_rcpt_tbl(l_rcpt_tbl.LAST).amount_Applied + l_diff_amount;
2131: IF l_currency_code <> l_inv_curr_code THEN
2132: IF l_inv_to_rct_rate is null THEN
2133: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
2134: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
2135: IF l_exchange_rate_type IS NULL THEN
2136: OKL_API.set_message( p_app_name => G_APP_NAME
2137: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 2198: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

2194: l_amount_app_to := l_amount_app_to - l_rcpt_tbl(j).AMOUNT_APPLIED;
2195: END IF;
2196: IF l_currency_code <> l_inv_curr_code THEN
2197: IF l_inv_to_rct_rate is null THEN
2198: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
2199: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
2200: IF l_exchange_rate_type IS NULL THEN
2201: OKL_API.set_message( p_app_name => G_APP_NAME
2202: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 3229: /* l_cross_curr_enabled := nvl(FND_PROFILE.value('AR_ENABLE_CROSS_CURRENCY'),'N');

3225: ,p_msg_name => 'OKL_BPD_PARAMS_MISMATCH'
3226: );
3227: END IF;
3228: END IF;
3229: /* l_cross_curr_enabled := nvl(FND_PROFILE.value('AR_ENABLE_CROSS_CURRENCY'),'N');
3230: log_debug('l_cross_curr_enabled = '||l_cross_curr_enabled);
3231: IF l_cross_curr_enabled <> 'Y' THEN
3232: OKL_API.set_message( p_app_name => G_APP_NAME
3233: ,p_msg_name => 'OKL_BPD_CROSS_CURR_NA'

Line 3238: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

3234: );
3235: RAISE G_EXCEPTION_HALT_VALIDATION;
3236: ELSE*/
3237: IF l_inv_to_rct_rate is null THEN
3238: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3239: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3240: IF l_exchange_rate_type IS NULL THEN
3241: OKL_API.set_message( p_app_name => G_APP_NAME
3242: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 3407: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

3403: l_amount_app_to := l_amount_app_to - l_rcpt_tbl(j).AMOUNT_APPLIED;
3404: END IF;
3405: IF l_currency_code <> l_inv_curr_code THEN
3406: IF l_inv_to_rct_rate is null THEN
3407: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3408: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3409: IF l_exchange_rate_type IS NULL THEN
3410: OKL_API.set_message( p_app_name => G_APP_NAME
3411: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 3479: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

3475: l_rcpt_tbl(j).INVOICE_LINE_NUMBER := c_open_invs_rec.ar_invoice_line_number;
3476: l_rcpt_tbl(j).INVOICE_LINE_ID := c_open_invs_rec.ar_invoice_line_id;
3477: IF l_currency_code <> l_inv_curr_code THEN
3478: IF l_inv_to_rct_rate is null THEN
3479: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3480: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3481: IF l_exchange_rate_type IS NULL THEN
3482: OKL_API.set_message( p_app_name => G_APP_NAME
3483: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 3551: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

3547: l_rcpt_tbl(j).AMOUNT_APPLIED := l_temp_val * l_rcpt_tbl(j).AMOUNT_APPLIED;
3548: l_rcpt_tbl(j).AMOUNT_APPLIED:=GET_ROUNDED_AMOUNT(l_rcpt_tbl(j).AMOUNT_APPLIED,l_inv_curr_Code);
3549: IF l_currency_code <> l_inv_curr_code THEN
3550: IF l_inv_to_rct_rate is null THEN
3551: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3552: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3553: IF l_exchange_rate_type IS NULL THEN
3554: OKL_API.set_message( p_app_name => G_APP_NAME
3555: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 3593: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

3589: if l_diff_amount > 0 then
3590: l_rcpt_tbl(l_rcpt_tbl.LAST).amount_Applied := l_rcpt_tbl(l_rcpt_tbl.LAST).amount_Applied + l_diff_amount;
3591: IF l_currency_code <> l_inv_curr_code THEN
3592: IF l_inv_to_rct_rate is null THEN
3593: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3594: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3595: IF l_exchange_rate_type IS NULL THEN
3596: OKL_API.set_message( p_app_name => G_APP_NAME
3597: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 3662: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

3658: l_amount_app_to := l_amount_app_to - l_rcpt_tbl(j).AMOUNT_APPLIED;
3659: END IF;
3660: IF l_currency_code <> l_inv_curr_code THEN
3661: IF l_inv_to_rct_rate is null THEN
3662: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3663: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3664: IF l_exchange_rate_type IS NULL THEN
3665: OKL_API.set_message( p_app_name => G_APP_NAME
3666: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 3903: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

3899:
3900: --j := j + 1;
3901: IF l_currency_code <> l_inv_curr_code THEN
3902: IF l_inv_to_rct_rate is null THEN
3903: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3904: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3905: IF l_exchange_rate_type IS NULL THEN
3906: OKL_API.set_message( p_app_name => G_APP_NAME
3907: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 3972: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

3968: l_rcpt_tbl(j).INVOICE_LINE_ID := c_open_invs_rec.ar_invoice_line_id;
3969: l_rcpt_tbl(j).INVOICE_LINE_NUMBER := c_open_invs_rec.ar_invoice_line_number;
3970: IF l_currency_code <> l_inv_curr_code THEN
3971: IF l_inv_to_rct_rate is null THEN
3972: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3973: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3974: IF l_exchange_rate_type IS NULL THEN
3975: OKL_API.set_message( p_app_name => G_APP_NAME
3976: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 4040: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

4036: l_rcpt_tbl(j).AMOUNT_APPLIED := l_temp_val * l_rcpt_tbl(j).AMOUNT_APPLIED;
4037: l_rcpt_tbl(j).AMOUNT_APPLIED:=GET_ROUNDED_AMOUNT(l_rcpt_tbl(j).AMOUNT_APPLIED,l_inv_curr_Code);
4038: IF l_currency_code <> l_inv_curr_code THEN
4039: IF l_inv_to_rct_rate is null THEN
4040: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
4041: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
4042: IF l_exchange_rate_type IS NULL THEN
4043: OKL_API.set_message( p_app_name => G_APP_NAME
4044: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

Line 4119: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

4115:
4116: END IF;
4117: IF l_currency_code <> l_inv_curr_code THEN
4118: IF l_inv_to_rct_rate is null THEN
4119: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
4120: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
4121: IF l_exchange_rate_type IS NULL THEN
4122: OKL_API.set_message( p_app_name => G_APP_NAME
4123: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'