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 1944: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');

1940: l_rcpt_tbl(j).INVOICE_LINE_ID := c_open_invoices_contract_rec.invoice_line_id;
1941: l_rcpt_tbl(j).INVOICE_LINE_NUMBER := c_open_invoices_contract_rec.line_number;
1942: IF l_currency_code <> l_inv_curr_code THEN
1943: IF l_inv_to_rct_rate is null THEN
1944: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
1945: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
1946: IF l_exchange_rate_type IS NULL THEN
1947: OKL_API.set_message( p_app_name => G_APP_NAME
1948: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

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

2011: l_pro_rate_inv_total := l_pro_rate_inv_total + l_rcpt_tbl(j).AMOUNT_APPLIED;
2012:
2013: IF l_currency_code <> l_inv_curr_code THEN
2014: IF l_inv_to_rct_rate is null THEN
2015: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
2016: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
2017: IF l_exchange_rate_type IS NULL THEN
2018: OKL_API.set_message( p_app_name => G_APP_NAME
2019: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

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

2081: l_rcpt_tbl(j).AMOUNT_APPLIED:=GET_ROUNDED_AMOUNT(l_rcpt_tbl(j).AMOUNT_APPLIED,l_inv_curr_Code);
2082: l_inv_total_amt := l_inv_total_amt + l_rcpt_tbl(j).AMOUNT_APPLIED;
2083: IF l_currency_code <> l_inv_curr_code THEN
2084: IF l_inv_to_rct_rate is null THEN
2085: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
2086: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
2087: IF l_exchange_rate_type IS NULL THEN
2088: OKL_API.set_message( p_app_name => G_APP_NAME
2089: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

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

2123: if l_diff_amount > 0 then
2124: l_rcpt_tbl(l_rcpt_tbl.LAST).amount_Applied := l_rcpt_tbl(l_rcpt_tbl.LAST).amount_Applied + l_diff_amount;
2125: IF l_currency_code <> l_inv_curr_code THEN
2126: IF l_inv_to_rct_rate is null THEN
2127: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
2128: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
2129: IF l_exchange_rate_type IS NULL THEN
2130: OKL_API.set_message( p_app_name => G_APP_NAME
2131: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

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

2188: l_amount_app_to := l_amount_app_to - l_rcpt_tbl(j).AMOUNT_APPLIED;
2189: END IF;
2190: IF l_currency_code <> l_inv_curr_code THEN
2191: IF l_inv_to_rct_rate is null THEN
2192: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
2193: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
2194: IF l_exchange_rate_type IS NULL THEN
2195: OKL_API.set_message( p_app_name => G_APP_NAME
2196: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

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

3215: ,p_msg_name => 'OKL_BPD_PARAMS_MISMATCH'
3216: );
3217: END IF;
3218: END IF;
3219: /* l_cross_curr_enabled := nvl(FND_PROFILE.value('AR_ENABLE_CROSS_CURRENCY'),'N');
3220: log_debug('l_cross_curr_enabled = '||l_cross_curr_enabled);
3221: IF l_cross_curr_enabled <> 'Y' THEN
3222: OKL_API.set_message( p_app_name => G_APP_NAME
3223: ,p_msg_name => 'OKL_BPD_CROSS_CURR_NA'

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

3224: );
3225: RAISE G_EXCEPTION_HALT_VALIDATION;
3226: ELSE*/
3227: IF l_inv_to_rct_rate is null THEN
3228: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3229: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3230: IF l_exchange_rate_type IS NULL THEN
3231: OKL_API.set_message( p_app_name => G_APP_NAME
3232: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

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

3393: l_amount_app_to := l_amount_app_to - l_rcpt_tbl(j).AMOUNT_APPLIED;
3394: END IF;
3395: IF l_currency_code <> l_inv_curr_code THEN
3396: IF l_inv_to_rct_rate is null THEN
3397: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3398: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3399: IF l_exchange_rate_type IS NULL THEN
3400: OKL_API.set_message( p_app_name => G_APP_NAME
3401: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

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

3465: l_rcpt_tbl(j).INVOICE_LINE_NUMBER := c_open_invs_rec.ar_invoice_line_number;
3466: l_rcpt_tbl(j).INVOICE_LINE_ID := c_open_invs_rec.ar_invoice_line_id;
3467: IF l_currency_code <> l_inv_curr_code THEN
3468: IF l_inv_to_rct_rate is null THEN
3469: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3470: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3471: IF l_exchange_rate_type IS NULL THEN
3472: OKL_API.set_message( p_app_name => G_APP_NAME
3473: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

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

3537: l_rcpt_tbl(j).AMOUNT_APPLIED := l_temp_val * l_rcpt_tbl(j).AMOUNT_APPLIED;
3538: l_rcpt_tbl(j).AMOUNT_APPLIED:=GET_ROUNDED_AMOUNT(l_rcpt_tbl(j).AMOUNT_APPLIED,l_inv_curr_Code);
3539: IF l_currency_code <> l_inv_curr_code THEN
3540: IF l_inv_to_rct_rate is null THEN
3541: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3542: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3543: IF l_exchange_rate_type IS NULL THEN
3544: OKL_API.set_message( p_app_name => G_APP_NAME
3545: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

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

3579: if l_diff_amount > 0 then
3580: l_rcpt_tbl(l_rcpt_tbl.LAST).amount_Applied := l_rcpt_tbl(l_rcpt_tbl.LAST).amount_Applied + l_diff_amount;
3581: IF l_currency_code <> l_inv_curr_code THEN
3582: IF l_inv_to_rct_rate is null THEN
3583: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3584: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3585: IF l_exchange_rate_type IS NULL THEN
3586: OKL_API.set_message( p_app_name => G_APP_NAME
3587: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

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

3648: l_amount_app_to := l_amount_app_to - l_rcpt_tbl(j).AMOUNT_APPLIED;
3649: END IF;
3650: IF l_currency_code <> l_inv_curr_code THEN
3651: IF l_inv_to_rct_rate is null THEN
3652: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3653: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3654: IF l_exchange_rate_type IS NULL THEN
3655: OKL_API.set_message( p_app_name => G_APP_NAME
3656: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

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

3889:
3890: --j := j + 1;
3891: IF l_currency_code <> l_inv_curr_code THEN
3892: IF l_inv_to_rct_rate is null THEN
3893: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3894: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3895: IF l_exchange_rate_type IS NULL THEN
3896: OKL_API.set_message( p_app_name => G_APP_NAME
3897: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

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

3958: l_rcpt_tbl(j).INVOICE_LINE_ID := c_open_invs_rec.ar_invoice_line_id;
3959: l_rcpt_tbl(j).INVOICE_LINE_NUMBER := c_open_invs_rec.ar_invoice_line_number;
3960: IF l_currency_code <> l_inv_curr_code THEN
3961: IF l_inv_to_rct_rate is null THEN
3962: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3963: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3964: IF l_exchange_rate_type IS NULL THEN
3965: OKL_API.set_message( p_app_name => G_APP_NAME
3966: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

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

4026: l_rcpt_tbl(j).AMOUNT_APPLIED := l_temp_val * l_rcpt_tbl(j).AMOUNT_APPLIED;
4027: l_rcpt_tbl(j).AMOUNT_APPLIED:=GET_ROUNDED_AMOUNT(l_rcpt_tbl(j).AMOUNT_APPLIED,l_inv_curr_Code);
4028: IF l_currency_code <> l_inv_curr_code THEN
4029: IF l_inv_to_rct_rate is null THEN
4030: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
4031: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
4032: IF l_exchange_rate_type IS NULL THEN
4033: OKL_API.set_message( p_app_name => G_APP_NAME
4034: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'

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

4105:
4106: END IF;
4107: IF l_currency_code <> l_inv_curr_code THEN
4108: IF l_inv_to_rct_rate is null THEN
4109: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
4110: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
4111: IF l_exchange_rate_type IS NULL THEN
4112: OKL_API.set_message( p_app_name => G_APP_NAME
4113: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'