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.XTR_REVAL_PROCESS_P dependencies on GL_CURRENCY_API

Line 1271: when GL_CURRENCY_API.no_rate then

1267: t_log_dump;
1268:
1269:
1270: EXCEPTION
1271: when GL_CURRENCY_API.no_rate then
1272: if g_call_by_form = true then
1273: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
1274: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
1275: APP_EXCEPTION.raise_exception;

Line 1285: when GL_CURRENCY_API.invalid_currency then

1281: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
1282: l_buf := FND_MESSAGE.GET;
1283: FND_FILE.put_line(fnd_file.log, l_buf);
1284: end if;
1285: when GL_CURRENCY_API.invalid_currency then
1286: if g_call_by_form = true then
1287: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
1288: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
1289: FND_MESSAGE.set_token('CURRENCY', rec.currencya);

Line 1690: GL_CURRENCY_API.get_triangulation_rate(l_base_ccy, l_contra_ccy,

1686: l_base_ccy := rec.currencya;
1687: l_contra_ccy := rec.currencyb;
1688: xtr_get_base_contra(l_base_ccy, l_contra_ccy, l_reverse);
1689:
1690: GL_CURRENCY_API.get_triangulation_rate(l_base_ccy, l_contra_ccy,
1691: rec.revldate, rec.ex_rate_type,l_deno, l_numer, gl_end_rate);
1692: rec.reval_rate := gl_end_rate;
1693: r_fx_rate.fx_forward_rate := gl_end_rate;
1694: xtr_revl_fv_fx(rec, r_fx_rate, l_hedge_flag, fair_value, l_sob_curr_rate);

Line 2292: GL_CURRENCY_API.get_triangulation_rate

2288: rec.reval_ex_rate_two :=NULL;
2289:
2290: -- Get XTR_DEALS table exchange_rate_one and exchange_rate_two
2291: If rec.deal_type = 'FX' then
2292: GL_CURRENCY_API.get_triangulation_rate
2293: (l_base_ccy, rec.sob_ccy, rec.eligible_date, rec.ex_rate_type,
2294: l_deno, l_numer, rec.deal_ex_rate_one);
2295: GL_CURRENCY_API.get_triangulation_rate
2296: (l_contra_ccy, rec.sob_ccy, rec.eligible_date, rec.ex_rate_type,

Line 2295: GL_CURRENCY_API.get_triangulation_rate

2291: If rec.deal_type = 'FX' then
2292: GL_CURRENCY_API.get_triangulation_rate
2293: (l_base_ccy, rec.sob_ccy, rec.eligible_date, rec.ex_rate_type,
2294: l_deno, l_numer, rec.deal_ex_rate_one);
2295: GL_CURRENCY_API.get_triangulation_rate
2296: (l_contra_ccy, rec.sob_ccy, rec.eligible_date, rec.ex_rate_type,
2297: l_deno, l_numer, rec.deal_ex_rate_two);
2298:
2299: Else -- for other deal types, only exchange_rate_one is used

Line 2300: GL_CURRENCY_API.get_triangulation_rate

2296: (l_contra_ccy, rec.sob_ccy, rec.eligible_date, rec.ex_rate_type,
2297: l_deno, l_numer, rec.deal_ex_rate_two);
2298:
2299: Else -- for other deal types, only exchange_rate_one is used
2300: GL_CURRENCY_API.get_triangulation_rate
2301: (rec.reval_ccy, rec.sob_ccy, rec.eligible_date, rec.ex_rate_type,
2302: l_deno, l_numer, rec.deal_ex_rate_one);
2303: rec.deal_ex_rate_two := null;
2304: End If;

Line 2320: GL_CURRENCY_API.get_triangulation_rate

2316:
2317: -- Get XTR_REVALUATION_DETAILS table exchange_rate_one, exchange_rate_two, and Fx forwad rate
2318: If rec.effective_date <= rec.revldate then -- deal is realized. Used maturity date rate
2319: If rec.deal_type = 'FX' then
2320: GL_CURRENCY_API.get_triangulation_rate
2321: (l_base_ccy, rec.sob_ccy, rec.effective_date, rec.ex_rate_type,
2322: l_deno, l_numer, rec.reval_ex_rate_one);
2323: GL_CURRENCY_API.get_triangulation_rate
2324: (l_contra_ccy, rec.sob_ccy, rec.effective_date, rec.ex_rate_type,

Line 2323: GL_CURRENCY_API.get_triangulation_rate

2319: If rec.deal_type = 'FX' then
2320: GL_CURRENCY_API.get_triangulation_rate
2321: (l_base_ccy, rec.sob_ccy, rec.effective_date, rec.ex_rate_type,
2322: l_deno, l_numer, rec.reval_ex_rate_one);
2323: GL_CURRENCY_API.get_triangulation_rate
2324: (l_contra_ccy, rec.sob_ccy, rec.effective_date, rec.ex_rate_type,
2325: l_deno, l_numer, rec.reval_ex_rate_two);
2326: Else
2327: GL_CURRENCY_API.get_triangulation_rate

Line 2327: GL_CURRENCY_API.get_triangulation_rate

2323: GL_CURRENCY_API.get_triangulation_rate
2324: (l_contra_ccy, rec.sob_ccy, rec.effective_date, rec.ex_rate_type,
2325: l_deno, l_numer, rec.reval_ex_rate_two);
2326: Else
2327: GL_CURRENCY_API.get_triangulation_rate
2328: (rec.reval_ccy, rec.sob_ccy, rec.effective_date, rec.ex_rate_type,
2329: l_deno, l_numer, rec.reval_ex_rate_one);
2330: rec.reval_ex_rate_two := null;
2331: IF xtr_risk_debug_pkg.g_Debug THEN

Line 2346: GL_CURRENCY_API.get_triangulation_rate

2342:
2343: End If;
2344: Else -- deal is unrealized. Use reval date's G/L rate
2345: If rec.deal_type = 'FX' then
2346: GL_CURRENCY_API.get_triangulation_rate
2347: (l_base_ccy, rec.sob_ccy, rec.revldate, rec.ex_rate_type,
2348: l_deno, l_numer, rec.reval_ex_rate_one);
2349: GL_CURRENCY_API.get_triangulation_rate
2350: (l_contra_ccy, rec.sob_ccy, rec.revldate, rec.ex_rate_type,

Line 2349: GL_CURRENCY_API.get_triangulation_rate

2345: If rec.deal_type = 'FX' then
2346: GL_CURRENCY_API.get_triangulation_rate
2347: (l_base_ccy, rec.sob_ccy, rec.revldate, rec.ex_rate_type,
2348: l_deno, l_numer, rec.reval_ex_rate_one);
2349: GL_CURRENCY_API.get_triangulation_rate
2350: (l_contra_ccy, rec.sob_ccy, rec.revldate, rec.ex_rate_type,
2351: l_deno, l_numer, rec.reval_ex_rate_two);
2352: Else
2353: GL_CURRENCY_API.get_triangulation_rate

Line 2353: GL_CURRENCY_API.get_triangulation_rate

2349: GL_CURRENCY_API.get_triangulation_rate
2350: (l_contra_ccy, rec.sob_ccy, rec.revldate, rec.ex_rate_type,
2351: l_deno, l_numer, rec.reval_ex_rate_two);
2352: Else
2353: GL_CURRENCY_API.get_triangulation_rate
2354: (rec.reval_ccy, rec.sob_ccy, rec.revldate, rec.ex_rate_type,
2355: l_deno, l_numer, rec.reval_ex_rate_one);
2356: rec.reval_ex_rate_two := null;
2357: End If;

Line 2372: when GL_CURRENCY_API.no_rate then

2368: xtr_risk_debug_pkg.dpop('xtr_revl_exchange_rate: ' || 'reval_date exchange rate');
2369: END IF;
2370:
2371: EXCEPTION
2372: when GL_CURRENCY_API.no_rate then
2373: if g_call_by_form = true then
2374: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
2375: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
2376: APP_EXCEPTION.raise_exception;

Line 2386: when GL_CURRENCY_API.invalid_currency then

2382: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
2383: l_buf := FND_MESSAGE.GET;
2384: FND_FILE.put_line(fnd_file.log, l_buf);
2385: end if;
2386: when GL_CURRENCY_API.invalid_currency then
2387: if g_call_by_form = true then
2388: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
2389: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
2390: FND_MESSAGE.set_token('CURRENCY', rec.currencya);

Line 2611: GL_CURRENCY_API.get_triangulation_rate (rec.reval_ccy, rec.sob_ccy,

2607: return;
2608: end if;
2609:
2610: -- Obtain GL exchange rate on the batch end date
2611: GL_CURRENCY_API.get_triangulation_rate (rec.reval_ccy, rec.sob_ccy,
2612: rec.revldate, rec.ex_rate_type, l_deno, l_numer, l_batch_end_rate);
2613:
2614: -- Calculate pair
2615: open C_PAIR_PRINCIPAL;

Line 2623: GL_CURRENCY_API.get_triangulation_rate (rec.reval_ccy, rec.sob_ccy,

2619:
2620: while C_PAIR_PRINCIPAL%FOUND loop
2621: -- Determine the 'Previous exchange rate'
2622: if l_first_batch0 is null then -- transaction been first revaled
2623: GL_CURRENCY_API.get_triangulation_rate (rec.reval_ccy, rec.sob_ccy,
2624: l_start_date0, rec.ex_rate_type, l_deno, l_numer, l_trans_ex_rate0);
2625:
2626: l_unrel_start_rate := l_trans_ex_rate0;
2627: l_first_batch_id := rec.batch_id;

Line 2639: GL_CURRENCY_API.get_triangulation_rate(rec.reval_ccy, rec.sob_ccy,

2635: and nvl(realized_flag, 'N') = 'N';
2636: end if;
2637:
2638: -- Determine the 'Ending exchange rate'
2639: GL_CURRENCY_API.get_triangulation_rate(rec.reval_ccy, rec.sob_ccy,
2640: l_start_date1, rec.ex_rate_type, l_deno, l_numer, l_trans_ex_rate1);
2641: l_unrel_end_rate := l_trans_ex_rate1;
2642:
2643: -- Calculate UCGL = balance_out * (ending ex rate - start ex rate)

Line 2724: GL_CURRENCY_API.get_triangulation_rate (rec.reval_ccy, rec.sob_ccy,

2720: l_principal0, l_prin_action0, l_balance_out0, l_first_batch0;
2721: if C_LAST_PRIN_ADJ%FOUND then
2722: -- Determine the 'Previous exchange rate'
2723: if l_first_batch0 is null then -- transaction been first revaled
2724: GL_CURRENCY_API.get_triangulation_rate (rec.reval_ccy, rec.sob_ccy,
2725: l_start_date0, rec.ex_rate_type, l_deno, l_numer, l_trans_ex_rate0);
2726:
2727: l_unrel_start_rate := l_trans_ex_rate0;
2728: l_first_batch_id := rec.batch_id;

Line 2807: when GL_CURRENCY_API.no_rate then

2803: end if;
2804: close C_LAST_PRIN_ADJ;
2805:
2806: EXCEPTION
2807: when GL_CURRENCY_API.no_rate then
2808: if g_call_by_form = true then
2809: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
2810: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
2811: APP_EXCEPTION.raise_exception;

Line 2821: when GL_CURRENCY_API.invalid_currency then

2817: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
2818: l_buf := FND_MESSAGE.GET;
2819: FND_FILE.put_line(fnd_file.log, l_buf);
2820: end if;
2821: when GL_CURRENCY_API.invalid_currency then
2822: if g_call_by_form = true then
2823: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
2824: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
2825: FND_MESSAGE.set_token('CURRENCY', rec.currencya);

Line 2957: GL_CURRENCY_API.get_triangulation_rate (rec.currencya, rec.sob_ccy,

2953:
2954: ----------------------------------------------------------------------
2955: -- Obtain GL exchange rate on the batch end date
2956: ----------------------------------------------------------------------
2957: GL_CURRENCY_API.get_triangulation_rate (rec.currencya, rec.sob_ccy,
2958: rec.revldate, rec.ex_rate_type, l_deno, l_numer, l_bed_rate);
2959:
2960: ----------------------------------------------------------------------
2961: -- Calculate pair records (un)realized currency G/L

Line 2972: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy,

2968: -- Get date and rate information for 1st record of the pair
2969: ----------------------------------------------------------------------
2970: if l_first_batch_id is null then
2971:
2972: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy,
2973: l_bal_date0, rec.ex_rate_type, l_deno, l_numer, l_ex_rate0);
2974: xtr_risk_debug_pkg.dpush('FIRST_BATCH_CA');
2975: xtr_risk_debug_pkg.dlog('l_ex_rate0', l_ex_rate0);
2976: xtr_risk_debug_pkg.dpop('FIRST_BATCH_CA');

Line 3010: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy,

3006: xtr_risk_debug_pkg.dlog('l_pre_batch_id', l_pre_batch_id);
3007: xtr_risk_debug_pkg.dpop('SEC_BATCH_CA');
3008:
3009: else
3010: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy,
3011: l_bal_date0, rec.ex_rate_type, l_deno, l_numer, l_ex_rate0);
3012: l_last_unrel_date := l_bal_date0;
3013: l_avg_rate0 := nvl(l_avg_rate0, l_ex_rate0);
3014: l_unrel_start_rate:= l_ex_rate0;

Line 3028: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy,

3024:
3025: ----------------------------------------------------------------------
3026: -- Get date and rate information for 2nd record of the pair
3027: ----------------------------------------------------------------------
3028: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy,
3029: l_bal_date1, rec.ex_rate_type, l_deno, l_numer, l_ex_rate1);
3030: l_unrel_end_rate := l_ex_rate1;
3031:
3032: ----------------------------------------------------------------------

Line 3196: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy,

3192: Fetch C_LAST_BALANCE into l_bal_date0, l_bal_amt0, l_first_batch_id, l_trans_rate0;
3193:
3194: if C_LAST_BALANCE%FOUND then
3195: if l_first_batch_id is null then
3196: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy,
3197: l_bal_date0, rec.ex_rate_type, l_deno, l_numer, l_ex_rate0);
3198: l_last_unrel_date := l_bal_date0;
3199: l_avg_rate0 := l_ex_rate0;
3200: l_unrel_start_rate:= l_ex_rate0;

Line 3216: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy,

3212: -------- AW 25/10/01 ------------
3213: l_ex_rate0 := l_unrel_start_rate;
3214: ---------------------------------
3215: else
3216: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy,
3217: l_bal_date0, rec.ex_rate_type, l_deno, l_numer, l_ex_rate0);
3218: l_last_unrel_date := l_bal_date0;
3219: l_avg_rate0 := l_ex_rate0;
3220: l_unrel_start_rate:= l_ex_rate0;

Line 3270: when GL_CURRENCY_API.no_rate then

3266: Close C_LAST_BALANCE;
3267: retcode := 0;
3268:
3269: EXCEPTION
3270: when GL_CURRENCY_API.no_rate then
3271: if g_call_by_form = true then
3272: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
3273: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
3274: APP_EXCEPTION.raise_exception;

Line 3284: when GL_CURRENCY_API.invalid_currency then

3280: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
3281: l_buf := FND_MESSAGE.GET;
3282: FND_FILE.put_line(fnd_file.log, l_buf);
3283: end if;
3284: when GL_CURRENCY_API.invalid_currency then
3285: if g_call_by_form = true then
3286: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
3287: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
3288: FND_MESSAGE.set_token('CURRENCY', rec.currencya);

Line 3457: GL_CURRENCY_API.get_triangulation_rate (rec.currencya, rec.sob_ccy,

3453:
3454: -------------------------------------------------
3455: -- Obtain GL exchange rate on the batch end date
3456: -------------------------------------------------
3457: GL_CURRENCY_API.get_triangulation_rate (rec.currencya, rec.sob_ccy,
3458: rec.revldate, rec.ex_rate_type, l_deno, l_numer, l_bed_rate);
3459:
3460: ----------------------------------------------------
3461: -- Calculate pair records (un)realized currency G/L

Line 3475: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy, l_bal_date0,

3471: FETCH C_PREV_BALANCE into l_bal_date0, l_bal_amt0, l_trans_no0,
3472: l_first_batch_id, l_product0, l_port0;
3473: if C_PREV_BALANCE%FOUND then
3474: if l_first_batch_id is null then
3475: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy, l_bal_date0,
3476: rec.ex_rate_type, l_deno, l_numer, l_ex_rate0);
3477: l_last_unrel_date := l_bal_date0;
3478: l_avg_rate0 := nvl(l_avg_rate0, l_ex_rate0);
3479: l_unrel_start_rate:= l_ex_rate0;

Line 3502: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy,

3498: l_avg_rate0 := nvl(l_avg_rate0, l_ex_rate0);
3499: -------------------------------------------
3500:
3501: else
3502: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy,
3503: l_bal_date0, rec.ex_rate_type, l_deno, l_numer, l_ex_rate0);
3504: l_last_unrel_date := l_bal_date0;
3505: l_avg_rate0 := nvl(l_avg_rate0, l_ex_rate0);
3506: l_unrel_start_rate:= l_ex_rate0;

Line 3515: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy, l_bal_date1,

3511:
3512: ------------------------------------------------------------
3513: -- Get date and rate information for 2nd record of the pair
3514: ------------------------------------------------------------
3515: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy, l_bal_date1,
3516: rec.ex_rate_type, l_deno, l_numer, l_ex_rate1);
3517: l_unrel_end_rate := l_ex_rate1;
3518:
3519: ------------------------------------------------------------

Line 3671: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy,

3667: l_product0, l_port0;
3668:
3669: if C_LAST_BALANCE%FOUND then
3670: if l_first_batch_id is null then
3671: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy,
3672: l_bal_date0, rec.ex_rate_type, l_deno, l_numer, l_ex_rate0);
3673: l_last_unrel_date := l_bal_date0;
3674: l_avg_rate0 := l_ex_rate0;
3675: l_unrel_start_rate:= l_ex_rate0;

Line 3693: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy,

3689: l_ex_rate0 := l_unrel_start_rate;
3690: ---------------------------------
3691:
3692: else
3693: GL_CURRENCY_API.get_triangulation_rate(rec.currencya, rec.sob_ccy,
3694: l_bal_date0, rec.ex_rate_type, l_deno, l_numer, l_ex_rate0);
3695: l_last_unrel_date := l_bal_date0;
3696: l_avg_rate0 := l_ex_rate0;
3697: l_unrel_start_rate:= l_ex_rate0;

Line 3742: when GL_CURRENCY_API.no_rate then

3738: Close C_LAST_BALANCE;
3739:
3740: retcode := 0;
3741: EXCEPTION
3742: when GL_CURRENCY_API.no_rate then
3743: if g_call_by_form = true then
3744: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
3745: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
3746: APP_EXCEPTION.raise_exception;

Line 3756: when GL_CURRENCY_API.invalid_currency then

3752: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
3753: l_buf := FND_MESSAGE.GET;
3754: FND_FILE.put_line(fnd_file.log, l_buf);
3755: end if;
3756: when GL_CURRENCY_API.invalid_currency then
3757: if g_call_by_form = true then
3758: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
3759: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
3760: FND_MESSAGE.set_token('CURRENCY', rec.currencya);

Line 3866: GL_CURRENCY_API.get_triangulation_rate

3862: into l_round
3863: from xtr_master_currencies_v
3864: where currency = rec.sob_ccy;
3865:
3866: GL_CURRENCY_API.get_triangulation_rate
3867: (rec.reval_ccy, rec.sob_ccy, rec.revldate, rec.ex_rate_type,
3868: l_deno, l_numer, l_batch_end_rate);
3869:
3870: for l_tmp in c_eligi_roll loop

Line 3895: GL_CURRENCY_API.get_triangulation_rate

3891: l_accum_int := l_tmp.accum_interest_bf;
3892:
3893: If l_first_batch_id is null then -- First time reval Section A
3894: -- Get GL rate on start date
3895: GL_CURRENCY_API.get_triangulation_rate
3896: (rec.reval_ccy, rec.sob_ccy, rec.effective_date, rec.ex_rate_type,
3897: l_deno, l_numer, l_trans_gl_rate);
3898: --FND_FILE.put_line(fnd_file.log, 'l_trans_gl_rate = '||l_trans_gl_rate);
3899: l_unrel_start_rate := l_trans_gl_rate;

Line 3990: GL_CURRENCY_API.get_triangulation_rate

3986: l_unrel_end_rate := l_batch_end_rate;
3987: l_unrel_end_date := rec.revldate;
3988: end if;
3989: else
3990: GL_CURRENCY_API.get_triangulation_rate
3991: (rec.reval_ccy, rec.sob_ccy, rec.maturity_date,
3992: rec.ex_rate_type, l_deno, l_numer, l_unrel_end_rate);
3993: l_unrel_end_date := rec.maturity_date;
3994: l_trans_last_batch := rec.batch_id;

Line 4059: when GL_CURRENCY_API.no_rate then

4055: end loop;
4056:
4057: retcode := 0;
4058: EXCEPTION
4059: when GL_CURRENCY_API.no_rate then
4060: if g_call_by_form = true then
4061: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
4062: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
4063: APP_EXCEPTION.raise_exception;

Line 4073: when GL_CURRENCY_API.invalid_currency then

4069: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
4070: l_buf := FND_MESSAGE.GET;
4071: FND_FILE.put_line(fnd_file.log, l_buf);
4072: end if;
4073: when GL_CURRENCY_API.invalid_currency then
4074: if g_call_by_form = true then
4075: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
4076: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
4077: FND_MESSAGE.set_token('CURRENCY', rec.currencya);

Line 4729: when GL_CURRENCY_API.no_rate then

4725: end if;
4726: end_fv := round(end_fv, l_round);
4727:
4728: EXCEPTION
4729: when GL_CURRENCY_API.no_rate then
4730: if g_call_by_form = true then
4731: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
4732: APP_EXCEPTION.raise_exception;
4733: else

Line 4742: when GL_CURRENCY_API.invalid_currency then

4738: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
4739: l_buff := FND_MESSAGE.GET;
4740: FND_FILE.put_line(fnd_file.log, l_buff);
4741: end if;
4742: when GL_CURRENCY_API.invalid_currency then
4743: if g_call_by_form = true then
4744: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
4745: APP_EXCEPTION.raise_exception;
4746: else

Line 5378: GL_CURRENCY_API.get_triangulation_rate(l_base1, l_contra1,

5374: -- use GL daily rate between SOB and Contra ccy instead of forward rate
5375: l_base1 := l_contra_ccy;
5376: l_contra1 := rec.sob_ccy;
5377: xtr_get_base_contra(l_base1, l_contra1, l_reverse);
5378: GL_CURRENCY_API.get_triangulation_rate(l_base1, l_contra1,
5379: l_spot_date, rec.ex_rate_type,l_deno, l_numer, p_sob_curr_rate);
5380: elsif l_contra_ccy = rec.sob_ccy and rec.pricing_model = 'FX_GL' then
5381: p_sob_curr_rate := 1;
5382: end if;

Line 5429: when GL_CURRENCY_API.no_rate then

5425: END IF; */
5426: end if;
5427:
5428: EXCEPTION
5429: when GL_CURRENCY_API.no_rate then
5430: if g_call_by_form = true then
5431: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
5432: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5433: APP_EXCEPTION.raise_exception;

Line 5443: when GL_CURRENCY_API.invalid_currency then

5439: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
5440: l_buff := FND_MESSAGE.GET;
5441: FND_FILE.put_line(fnd_file.log, l_buff);
5442: end if;
5443: when GL_CURRENCY_API.invalid_currency then
5444: if g_call_by_form = true then
5445: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
5446: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5447: FND_MESSAGE.set_token('CURRENCY', rec.currencya);

Line 5599: GL_CURRENCY_API.get_triangulation_rate(l_base_ccy, l_contra_ccy,

5595: ------------------------------------------------------------
5596: -- Get exchange rate between base and contra, contra ccy and sob ccy in
5597: -- min(batch end date, deal value date) as end rate
5598: ------------------------------------------------------------
5599: GL_CURRENCY_API.get_triangulation_rate(l_base_ccy, l_contra_ccy,
5600: l_end_date, rec.ex_rate_type,l_deno, l_numer, l_end_base_contra_rate);
5601:
5602: GL_CURRENCY_API.get_triangulation_rate(l_contra_ccy, rec.sob_ccy,
5603: l_end_date, rec.ex_rate_type,l_deno, l_numer, l_end_contra_sob_rate);

Line 5602: GL_CURRENCY_API.get_triangulation_rate(l_contra_ccy, rec.sob_ccy,

5598: ------------------------------------------------------------
5599: GL_CURRENCY_API.get_triangulation_rate(l_base_ccy, l_contra_ccy,
5600: l_end_date, rec.ex_rate_type,l_deno, l_numer, l_end_base_contra_rate);
5601:
5602: GL_CURRENCY_API.get_triangulation_rate(l_contra_ccy, rec.sob_ccy,
5603: l_end_date, rec.ex_rate_type,l_deno, l_numer, l_end_contra_sob_rate);
5604:
5605: rec.reval_ex_rate_one := l_end_base_contra_rate;
5606: rec.reval_ex_rate_two := l_end_contra_sob_rate;

Line 5614: GL_CURRENCY_API.get_triangulation_rate(l_base_ccy, rec.sob_ccy,

5610: ------------------------------------------------------------
5611: -- Store base-> SOB currency as exchange_rate_one and
5612: -- store contra -> SOB currency as exchange_rate_two in reval table
5613: ------------------------------------------------------------
5614: GL_CURRENCY_API.get_triangulation_rate(l_base_ccy, rec.sob_ccy,
5615: l_end_date, rec.ex_rate_type,l_deno, l_numer, rec.reval_ex_rate_one);
5616:
5617: GL_CURRENCY_API.get_triangulation_rate(l_contra_ccy, rec.sob_ccy,
5618: l_end_date, rec.ex_rate_type,l_deno, l_numer, rec.reval_ex_rate_two);

Line 5617: GL_CURRENCY_API.get_triangulation_rate(l_contra_ccy, rec.sob_ccy,

5613: ------------------------------------------------------------
5614: GL_CURRENCY_API.get_triangulation_rate(l_base_ccy, rec.sob_ccy,
5615: l_end_date, rec.ex_rate_type,l_deno, l_numer, rec.reval_ex_rate_one);
5616:
5617: GL_CURRENCY_API.get_triangulation_rate(l_contra_ccy, rec.sob_ccy,
5618: l_end_date, rec.ex_rate_type,l_deno, l_numer, rec.reval_ex_rate_two);
5619: ---------------------------------------------------------------------------------
5620: */
5621:

Line 5629: GL_CURRENCY_API.get_triangulation_rate(l_base_ccy, l_contra_ccy,

5625: ------------------------------------------------------------
5626: -- Get exchange rate between base and contra, contra and sob ccy in
5627: -- nvl(last batch end date, deal.deal_date) as begin rate
5628: ------------------------------------------------------------
5629: GL_CURRENCY_API.get_triangulation_rate(l_base_ccy, l_contra_ccy,
5630: l_begin_date, rec.ex_rate_type,l_deno, l_numer, l_begin_base_contra_rate);
5631:
5632: GL_CURRENCY_API.get_triangulation_rate(l_contra_ccy, rec.sob_ccy,
5633: l_begin_date, rec.ex_rate_type,l_deno, l_numer, l_begin_contra_sob_rate);

Line 5632: GL_CURRENCY_API.get_triangulation_rate(l_contra_ccy, rec.sob_ccy,

5628: ------------------------------------------------------------
5629: GL_CURRENCY_API.get_triangulation_rate(l_base_ccy, l_contra_ccy,
5630: l_begin_date, rec.ex_rate_type,l_deno, l_numer, l_begin_base_contra_rate);
5631:
5632: GL_CURRENCY_API.get_triangulation_rate(l_contra_ccy, rec.sob_ccy,
5633: l_begin_date, rec.ex_rate_type,l_deno, l_numer, l_begin_contra_sob_rate);
5634:
5635: rec.deal_ex_rate_one := l_begin_base_contra_rate;
5636: rec.deal_ex_rate_two := l_begin_contra_sob_rate;

Line 5644: GL_CURRENCY_API.get_triangulation_rate(l_base_ccy, rec.sob_ccy,

5640: ------------------------------------------------------------
5641: -- Store base-> SOB currency as exchange_rate_one and
5642: -- store contra -> SOB currency as exchange_rate_two in xtr_deals table
5643: ------------------------------------------------------------
5644: GL_CURRENCY_API.get_triangulation_rate(l_base_ccy, rec.sob_ccy,
5645: l_begin_date, rec.ex_rate_type,l_deno, l_numer, rec.deal_ex_rate_one);
5646:
5647: GL_CURRENCY_API.get_triangulation_rate(l_contra_ccy, rec.sob_ccy,
5648: l_begin_date, rec.ex_rate_type,l_deno, l_numer, rec.deal_ex_rate_two);

Line 5647: GL_CURRENCY_API.get_triangulation_rate(l_contra_ccy, rec.sob_ccy,

5643: ------------------------------------------------------------
5644: GL_CURRENCY_API.get_triangulation_rate(l_base_ccy, rec.sob_ccy,
5645: l_begin_date, rec.ex_rate_type,l_deno, l_numer, rec.deal_ex_rate_one);
5646:
5647: GL_CURRENCY_API.get_triangulation_rate(l_contra_ccy, rec.sob_ccy,
5648: l_begin_date, rec.ex_rate_type,l_deno, l_numer, rec.deal_ex_rate_two);
5649: ------------------------------------------------------------------------
5650: */
5651:

Line 5678: when GL_CURRENCY_API.no_rate then

5674: xtr_risk_debug_pkg.dpop('xtr_revl_fv_fx: ' || 'xtr_fx_currency_gl');
5675: END IF;
5676:
5677: EXCEPTION
5678: when GL_CURRENCY_API.no_rate then
5679: if g_call_by_form = true then
5680: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
5681: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5682: APP_EXCEPTION.raise_exception;

Line 5692: when GL_CURRENCY_API.invalid_currency then

5688: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
5689: l_buff := FND_MESSAGE.GET;
5690: FND_FILE.put_line(fnd_file.log, l_buff);
5691: end if;
5692: when GL_CURRENCY_API.invalid_currency then
5693: if g_call_by_form = true then
5694: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
5695: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5696: FND_MESSAGE.set_token('CURRENCY', rec.currencya);

Line 5808: GL_CURRENCY_API.get_triangulation_rate(l_base_ccy, l_contra_ccy,

5804: /* Introduce new FX pricing model, if GL-deal, then use either */
5805: /* batch end date or maturity date G/L rate as fx rate to reval */
5806: /*******************************************************************/
5807: if rec.pricing_model = 'FX_GL' then
5808: GL_CURRENCY_API.get_triangulation_rate(l_base_ccy, l_contra_ccy,
5809: l_spot_date, rec.ex_rate_type,l_deno, l_numer, l_gl_rate);
5810: r_fx_rate.fx_forward_rate := l_gl_rate;
5811:
5812: else

Line 5951: when GL_CURRENCY_API.no_rate then

5947:
5948: end if;
5949:
5950: EXCEPTION
5951: when GL_CURRENCY_API.no_rate then
5952: if g_call_by_form = true then
5953: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
5954: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5955: APP_EXCEPTION.raise_exception;

Line 5965: when GL_CURRENCY_API.invalid_currency then

5961: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
5962: l_buff := FND_MESSAGE.GET;
5963: FND_FILE.put_line(fnd_file.log, l_buff);
5964: end if;
5965: when GL_CURRENCY_API.invalid_currency then
5966: if g_call_by_form = true then
5967: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
5968: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5969: FND_MESSAGE.set_token('CURRENCY', rec.currencya);

Line 6426: -- GL_CURRENCY_API.get_triangulation_rate (rec.reval_ccy, rec.sob_ccy, rec.period_start, rec.ex_rate_type,l_deno, l_numer, l_begin_rate);

6422: -- Find beginning GL rate
6423: xtr_first_reval(rec, l_first);
6424: if l_first = TRUE then -- first time reval
6425: -- Bug 9280321 starts
6426: -- GL_CURRENCY_API.get_triangulation_rate (rec.reval_ccy, rec.sob_ccy, rec.period_start, rec.ex_rate_type,l_deno, l_numer, l_begin_rate);
6427: GL_CURRENCY_API.get_triangulation_rate (rec.currencya, rec.sob_ccy, rec.period_start, rec.ex_rate_type,l_deno, l_numer, l_begin_rate);
6428: -- Bug 9280321 stops
6429: rec.deal_ex_rate_one := l_begin_rate;
6430: else

Line 6427: GL_CURRENCY_API.get_triangulation_rate (rec.currencya, rec.sob_ccy, rec.period_start, rec.ex_rate_type,l_deno, l_numer, l_begin_rate);

6423: xtr_first_reval(rec, l_first);
6424: if l_first = TRUE then -- first time reval
6425: -- Bug 9280321 starts
6426: -- GL_CURRENCY_API.get_triangulation_rate (rec.reval_ccy, rec.sob_ccy, rec.period_start, rec.ex_rate_type,l_deno, l_numer, l_begin_rate);
6427: GL_CURRENCY_API.get_triangulation_rate (rec.currencya, rec.sob_ccy, rec.period_start, rec.ex_rate_type,l_deno, l_numer, l_begin_rate);
6428: -- Bug 9280321 stops
6429: rec.deal_ex_rate_one := l_begin_rate;
6430: else
6431: XTR_GET_PREV_FV_RATE(rec, r_prev_hedge);

Line 6435: -- GL_CURRENCY_API.get_triangulation_rate (rec.reval_ccy, rec.sob_ccy, rec.period_start, rec.ex_rate_type,l_deno, l_numer, l_begin_rate);

6431: XTR_GET_PREV_FV_RATE(rec, r_prev_hedge);
6432: l_begin_rate := r_prev_hedge.rate;
6433: if l_begin_rate is NULL then
6434: -- Bug 9280321 starts
6435: -- GL_CURRENCY_API.get_triangulation_rate (rec.reval_ccy, rec.sob_ccy, rec.period_start, rec.ex_rate_type,l_deno, l_numer, l_begin_rate);
6436: GL_CURRENCY_API.get_triangulation_rate (rec.currencya, rec.sob_ccy, rec.period_start, rec.ex_rate_type,l_deno, l_numer, l_begin_rate);
6437: -- Bug 9280321 ends
6438: end if;
6439: end if;

Line 6436: GL_CURRENCY_API.get_triangulation_rate (rec.currencya, rec.sob_ccy, rec.period_start, rec.ex_rate_type,l_deno, l_numer, l_begin_rate);

6432: l_begin_rate := r_prev_hedge.rate;
6433: if l_begin_rate is NULL then
6434: -- Bug 9280321 starts
6435: -- GL_CURRENCY_API.get_triangulation_rate (rec.reval_ccy, rec.sob_ccy, rec.period_start, rec.ex_rate_type,l_deno, l_numer, l_begin_rate);
6436: GL_CURRENCY_API.get_triangulation_rate (rec.currencya, rec.sob_ccy, rec.period_start, rec.ex_rate_type,l_deno, l_numer, l_begin_rate);
6437: -- Bug 9280321 ends
6438: end if;
6439: end if;
6440:

Line 6443: --GL_CURRENCY_API.get_triangulation_rate (rec.reval_ccy, rec.sob_ccy, rec.period_end, rec.ex_rate_type,l_deno, l_numer, l_end_rate);

6439: end if;
6440:
6441: -- Find ending GL rate
6442: -- Bug 9280321 starts
6443: --GL_CURRENCY_API.get_triangulation_rate (rec.reval_ccy, rec.sob_ccy, rec.period_end, rec.ex_rate_type,l_deno, l_numer, l_end_rate);
6444: GL_CURRENCY_API.get_triangulation_rate (rec.currencya, rec.sob_ccy, rec.period_end, rec.ex_rate_type,l_deno, l_numer, l_end_rate);
6445: -- Bug 9280321 ends
6446:
6447: l_begin_fv := round(rec.fair_value * l_begin_rate, l_round);

Line 6444: GL_CURRENCY_API.get_triangulation_rate (rec.currencya, rec.sob_ccy, rec.period_end, rec.ex_rate_type,l_deno, l_numer, l_end_rate);

6440:
6441: -- Find ending GL rate
6442: -- Bug 9280321 starts
6443: --GL_CURRENCY_API.get_triangulation_rate (rec.reval_ccy, rec.sob_ccy, rec.period_end, rec.ex_rate_type,l_deno, l_numer, l_end_rate);
6444: GL_CURRENCY_API.get_triangulation_rate (rec.currencya, rec.sob_ccy, rec.period_end, rec.ex_rate_type,l_deno, l_numer, l_end_rate);
6445: -- Bug 9280321 ends
6446:
6447: l_begin_fv := round(rec.fair_value * l_begin_rate, l_round);
6448: l_end_fv := round(rec.fair_value * l_end_rate, l_round);

Line 6462: when GL_CURRENCY_API.no_rate then

6458: currency_gl, r_rd, retcode, l_hedge_flag );
6459:
6460:
6461: EXCEPTION
6462: when GL_CURRENCY_API.no_rate then
6463: if g_call_by_form = true then
6464: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
6465: APP_EXCEPTION.raise_exception;
6466: else

Line 6475: when GL_CURRENCY_API.invalid_currency then

6471: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
6472: l_buff := FND_MESSAGE.GET;
6473: FND_FILE.put_line(fnd_file.log, l_buff);
6474: end if;
6475: when GL_CURRENCY_API.invalid_currency then
6476: if g_call_by_form = true then
6477: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
6478: APP_EXCEPTION.raise_exception;
6479: else

Line 8024: GL_CURRENCY_API.get_triangulation_rate

8020:
8021: -- End bug 2990046 - Issue #1 fix.
8022:
8023:
8024: GL_CURRENCY_API.get_triangulation_rate
8025: (rec.reval_ccy, rec.sob_ccy, rec.effective_date, rec.ex_rate_type,
8026: l_deno, l_numer, rec.reval_ex_rate_one);
8027:
8028: Else -- UNREAL record is not result of resale

Line 8124: when GL_CURRENCY_API.no_rate then

8120: unrel_sob_gl, currency_gl, r_rd, retcode);
8121: end if;
8122:
8123: EXCEPTION
8124: when GL_CURRENCY_API.no_rate then
8125: if g_call_by_form = true then
8126: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
8127: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
8128: APP_EXCEPTION.raise_exception;

Line 8138: when GL_CURRENCY_API.invalid_currency then

8134: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
8135: l_buf := FND_MESSAGE.GET;
8136: FND_FILE.put_line(fnd_file.log, l_buf);
8137: end if;
8138: when GL_CURRENCY_API.invalid_currency then
8139: if g_call_by_form = true then
8140: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
8141: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
8142: FND_MESSAGE.set_token('CURRENCY', rec.currencya);

Line 8919: GL_CURRENCY_API.get_triangulation_rate

8915: and nvl(realized_flag, 'N') = 'N'
8916: and batch_id = l_pre_batch;
8917:
8918: else
8919: GL_CURRENCY_API.get_triangulation_rate
8920: (rec.reval_ccy, rec.sob_ccy, rec.eligible_date, rec.ex_rate_type,
8921: l_deno, l_numer, rec.deal_ex_rate_one);
8922: end if;
8923:

Line 8924: GL_CURRENCY_API.get_triangulation_rate

8920: (rec.reval_ccy, rec.sob_ccy, rec.eligible_date, rec.ex_rate_type,
8921: l_deno, l_numer, rec.deal_ex_rate_one);
8922: end if;
8923:
8924: GL_CURRENCY_API.get_triangulation_rate
8925: (rec.reval_ccy, rec.sob_ccy, rec.effective_date, rec.ex_rate_type,
8926: l_deno, l_numer, rec.reval_ex_rate_one);
8927:
8928: fv_sob_amt := round((rec.fair_value * rec.reval_ex_rate_one), l_round);

Line 9027: when GL_CURRENCY_API.no_rate then

9023: unrel_sob_gl, currency_gl, r_rd, retcode);
9024: end if;
9025:
9026: EXCEPTION
9027: when GL_CURRENCY_API.no_rate then
9028: if g_call_by_form = true then
9029: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
9030: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
9031: APP_EXCEPTION.raise_exception;

Line 9041: when GL_CURRENCY_API.invalid_currency then

9037: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
9038: l_buf := FND_MESSAGE.GET;
9039: FND_FILE.put_line(fnd_file.log, l_buf);
9040: end if;
9041: when GL_CURRENCY_API.invalid_currency then
9042: if g_call_by_form = true then
9043: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
9044: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
9045: FND_MESSAGE.set_token('CURRENCY', rec.currencya);