DBA Data[Home] [Help]

APPS.XTR_JOURNAL_PROCESS_P dependencies on GL_CURRENCY_API

Line 1488: l_accounted_dr := GL_CURRENCY_API.Convert_Amount (

1484:
1485: -- Calculate accounted_dr and accounted_cr amounts.
1486:
1487: BEGIN
1488: l_accounted_dr := GL_CURRENCY_API.Convert_Amount (
1489: Q2_REC.currency,
1490: l_sob_currency,
1491: Q2_REC.amount_date,
1492: l_pty_convert_type,

Line 1495: l_accounted_cr := GL_CURRENCY_API.Convert_Amount (

1491: Q2_REC.amount_date,
1492: l_pty_convert_type,
1493: Q2_REC.dr_amount);
1494:
1495: l_accounted_cr := GL_CURRENCY_API.Convert_Amount (
1496: Q2_REC.currency,
1497: l_sob_currency,
1498: Q2_REC.amount_date,
1499: l_pty_convert_type,

Line 1503: when GL_CURRENCY_API.INVALID_CURRENCY then

1499: l_pty_convert_type,
1500: Q2_REC.cr_amount);
1501:
1502: EXCEPTION
1503: when GL_CURRENCY_API.INVALID_CURRENCY then
1504: FND_MESSAGE.Set_Name ('XTR','XTR_2206');
1505: FND_MESSAGE.Set_Token ('CURR1',Q2_REC.currency);
1506: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
1507: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

Line 1518: when GL_CURRENCY_API.NO_RATE then

1514: -- end 1336492 modification.
1515:
1516: Goto NEXT_Q2;
1517:
1518: when GL_CURRENCY_API.NO_RATE then
1519: FND_MESSAGE.Set_Name ('XTR','XTR_2207');
1520: FND_MESSAGE.Set_Token ('CURR1',Q2_REC.currency);
1521: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
1522: FND_MESSAGE.Set_Token ('XCHG_DATE',to_char(Q2_REC.amount_date));

Line 1812: l_accounted_dr := GL_CURRENCY_API.Convert_Amount (

1808:
1809: -- Calculate accounted_dr and accounted_cr amounts.
1810:
1811: BEGIN
1812: l_accounted_dr := GL_CURRENCY_API.Convert_Amount (
1813: Q3_REC.currency,
1814: l_sob_currency,
1815: Q3_REC.amount_date,
1816: l_pty_convert_type,

Line 1819: l_accounted_cr := GL_CURRENCY_API.Convert_Amount (

1815: Q3_REC.amount_date,
1816: l_pty_convert_type,
1817: Q3_REC.debit_amount);
1818:
1819: l_accounted_cr := GL_CURRENCY_API.Convert_Amount (
1820: Q3_REC.currency,
1821: l_sob_currency,
1822: Q3_REC.amount_date,
1823: l_pty_convert_type,

Line 1826: when GL_CURRENCY_API.INVALID_CURRENCY then

1822: Q3_REC.amount_date,
1823: l_pty_convert_type,
1824: Q3_REC.credit_amount);
1825: EXCEPTION
1826: when GL_CURRENCY_API.INVALID_CURRENCY then
1827: FND_MESSAGE.Set_Name ('XTR','XTR_2206');
1828: FND_MESSAGE.Set_Token ('CURR1',Q3_REC.currency);
1829: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
1830: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

Line 1839: when GL_CURRENCY_API.NO_RATE then

1835: l_updt_flag := 'N';
1836:
1837: Goto NEXT_Q3;
1838:
1839: when GL_CURRENCY_API.NO_RATE then
1840: FND_MESSAGE.Set_Name ('XTR','XTR_2207');
1841: FND_MESSAGE.Set_Token ('CURR1',Q3_REC.currency);
1842: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
1843: FND_MESSAGE.Set_Token ('XCHG_DATE',to_char(Q3_REC.amount_date));

Line 2103: l_accounted_dr := GL_CURRENCY_API.Convert_Amount (

2099: l_accounted_dr := 0;
2100: l_accounted_cr := 0;
2101:
2102: If (Q4_REC.credit_or_debit = 'DR') then
2103: l_accounted_dr := GL_CURRENCY_API.Convert_Amount (
2104: Q4_REC.currency,
2105: l_sob_currency,
2106: Q4_REC.amount_date,
2107: l_pty_convert_type,

Line 2110: l_accounted_cr := GL_CURRENCY_API.Convert_Amount (

2106: Q4_REC.amount_date,
2107: l_pty_convert_type,
2108: Q4_REC.accrls_amount);
2109: Else
2110: l_accounted_cr := GL_CURRENCY_API.Convert_Amount (
2111: Q4_REC.currency,
2112: l_sob_currency,
2113: Q4_REC.amount_date,
2114: l_pty_convert_type,

Line 2119: when GL_CURRENCY_API.INVALID_CURRENCY then

2115: Q4_REC.accrls_amount);
2116: End If;
2117:
2118: EXCEPTION
2119: when GL_CURRENCY_API.INVALID_CURRENCY then
2120: FND_MESSAGE.Set_Name ('XTR','XTR_2206');
2121: FND_MESSAGE.Set_Token ('CURR1',Q4_REC.currency);
2122: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
2123: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

Line 2128: when GL_CURRENCY_API.NO_RATE then

2124: --1336492 l_error_flag := 'Y';
2125: l_ret_value := greatest(l_ret_value,2);
2126: Goto NEXT_Q4;
2127:
2128: when GL_CURRENCY_API.NO_RATE then
2129: FND_MESSAGE.Set_Name ('XTR','XTR_2207');
2130: FND_MESSAGE.Set_Token ('CURR1',Q4_REC.currency);
2131: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
2132: FND_MESSAGE.Set_Token ('XCHG_DATE',to_char(Q4_REC.amount_date));

Line 2298: l_accounted_dr := GL_CURRENCY_API.Convert_Amount (

2294: l_accounted_cr := 0;
2295: --l_tmp_amt := abs(l_realized_amt + l_unrealized_amt);
2296:
2297: If (Q5_REC.credit_or_debit = 'DR') then
2298: l_accounted_dr := GL_CURRENCY_API.Convert_Amount (
2299: Q5_REC.reval_currency,
2300: l_sob_currency,
2301: Q5_REC.journal_date,
2302: l_pty_convert_type,

Line 2305: l_accounted_cr := GL_CURRENCY_API.Convert_Amount (

2301: Q5_REC.journal_date,
2302: l_pty_convert_type,
2303: Q5_REC.amount);
2304: Else
2305: l_accounted_cr := GL_CURRENCY_API.Convert_Amount (
2306: Q5_REC.reval_currency,
2307: l_sob_currency,
2308: Q5_REC.journal_date,
2309: l_pty_convert_type,

Line 2314: when GL_CURRENCY_API.INVALID_CURRENCY then

2310: Q5_REC.amount);
2311: End If;
2312:
2313: EXCEPTION
2314: when GL_CURRENCY_API.INVALID_CURRENCY then
2315: FND_MESSAGE.Set_Name ('XTR','XTR_2206');
2316: FND_MESSAGE.Set_Token ('CURR1',Q5_REC.reval_currency);
2317: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
2318: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

Line 2323: when GL_CURRENCY_API.NO_RATE then

2319: --1336492 l_error_flag := 'Y';
2320: l_ret_value := greatest(l_ret_value,2);
2321: Goto NEXT_Q5;
2322:
2323: when GL_CURRENCY_API.NO_RATE then
2324: FND_MESSAGE.Set_Name ('XTR','XTR_2207');
2325: FND_MESSAGE.Set_Token ('CURR1',Q5_REC.reval_currency);
2326: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
2327: FND_MESSAGE.Set_Token ('XCHG_DATE',to_char(Q5_REC.journal_date));

Line 2604: l_accounted_dr := GL_CURRENCY_API.Convert_Amount (

2600: l_accounted_dr := 0;
2601: l_accounted_cr := 0;
2602:
2603: If (Q6_REC.credit_or_debit = 'DR') then
2604: l_accounted_dr := GL_CURRENCY_API.Convert_Amount (
2605: Q6_REC.reval_currency,
2606: l_sob_currency,
2607: Q6_REC.journal_date,
2608: l_pty_convert_type,

Line 2611: l_accounted_cr := GL_CURRENCY_API.Convert_Amount (

2607: Q6_REC.journal_date,
2608: l_pty_convert_type,
2609: Q6_REC.amount);
2610: Else
2611: l_accounted_cr := GL_CURRENCY_API.Convert_Amount (
2612: Q6_REC.reval_currency,
2613: l_sob_currency,
2614: Q6_REC.journal_date,
2615: l_pty_convert_type,

Line 2619: when GL_CURRENCY_API.INVALID_CURRENCY then

2615: l_pty_convert_type,
2616: Q6_REC.amount);
2617: End If;
2618: EXCEPTION
2619: when GL_CURRENCY_API.INVALID_CURRENCY then
2620: FND_MESSAGE.Set_Name ('XTR','XTR_2206');
2621: FND_MESSAGE.Set_Token ('CURR1',Q6_REC.reval_currency);
2622: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
2623: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

Line 2627: when GL_CURRENCY_API.NO_RATE then

2623: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
2624: l_ret_value := greatest(l_ret_value,2);
2625: Goto NEXT_Q6;
2626:
2627: when GL_CURRENCY_API.NO_RATE then
2628: FND_MESSAGE.Set_Name ('XTR','XTR_2207');
2629: FND_MESSAGE.Set_Token ('CURR1',Q6_REC.reval_currency);
2630: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
2631: FND_MESSAGE.Set_Token ('XCHG_DATE',to_char(Q6_REC.journal_date));

Line 2855: l_accounted_dr := GL_CURRENCY_API.Convert_Amount (

2851: l_accounted_dr := 0;
2852: l_accounted_cr := 0;
2853:
2854: If (Q7_REC.credit_or_debit = 'DR') then
2855: l_accounted_dr := GL_CURRENCY_API.Convert_Amount (
2856: Q7_REC.reval_currency,
2857: l_sob_currency,
2858: Q7_REC.journal_date,
2859: l_pty_convert_type,

Line 2862: l_accounted_cr := GL_CURRENCY_API.Convert_Amount (

2858: Q7_REC.journal_date,
2859: l_pty_convert_type,
2860: Q7_REC.amount);
2861: Else
2862: l_accounted_cr := GL_CURRENCY_API.Convert_Amount (
2863: Q7_REC.reval_currency,
2864: l_sob_currency,
2865: Q7_REC.journal_date,
2866: l_pty_convert_type,

Line 2871: when GL_CURRENCY_API.INVALID_CURRENCY then

2867: Q7_REC.amount);
2868: End If;
2869:
2870: EXCEPTION
2871: when GL_CURRENCY_API.INVALID_CURRENCY then
2872: FND_MESSAGE.Set_Name ('XTR','XTR_2206');
2873: FND_MESSAGE.Set_Token ('CURR1',Q7_REC.reval_currency);
2874: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
2875: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

Line 2879: when GL_CURRENCY_API.NO_RATE then

2875: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
2876: l_ret_value := greatest(l_ret_value,2);
2877: Goto NEXT_Q7;
2878:
2879: when GL_CURRENCY_API.NO_RATE then
2880: FND_MESSAGE.Set_Name ('XTR','XTR_2207');
2881: FND_MESSAGE.Set_Token ('CURR1',Q7_REC.reval_currency);
2882: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
2883: FND_MESSAGE.Set_Token ('XCHG_DATE',to_char(Q7_REC.journal_date));