DBA Data[Home] [Help]

APPS.XTR_REVAL_PROCESS_P dependencies on FND_FILE

Line 1283: FND_FILE.put_line(fnd_file.log, l_buf);

1279: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
1280: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
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');

Line 1298: FND_FILE.put_line(fnd_file.log, l_buf);

1294: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
1295: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
1296: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
1297: l_buf := FND_MESSAGE.GET;
1298: FND_FILE.put_line(fnd_file.log, l_buf);
1299: end if;
1300: when others then
1301: if g_call_by_form = true then
1302: APP_EXCEPTION.raise_exception;

Line 1310: FND_FILE.put_line(fnd_file.log, l_buf);

1306: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
1307: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
1308: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
1309: l_buf := FND_MESSAGE.GET;
1310: FND_FILE.put_line(fnd_file.log, l_buf);
1311: end if;
1312: end xtr_revl_main;
1313: --------------------------------------------------------
1314: /********************************************************/

Line 1466: FND_FILE.put_line(fnd_file.log, l_buf);

1462: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
1463: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
1464: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
1465: l_buf := FND_MESSAGE.GET;
1466: FND_FILE.put_line(fnd_file.log, l_buf);
1467: end if;
1468: END;
1469: --------------------------------------------------------------------------
1470: /************************************************************/

Line 1537: FND_FILE.put_line(fnd_file.log, l_buf);

1533: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
1534: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
1535: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
1536: l_buf := FND_MESSAGE.GET;
1537: FND_FILE.put_line(fnd_file.log, l_buf);
1538: elsif rec.expiry_date <= rec.revldate and rec.status_code = 'EXPIRED' then -- realized
1539: if rec.contract_code is not null then
1540: select RIC_CODE
1541: into l_ric_code

Line 1587: FND_FILE.put_line(fnd_file.log, l_buf);

1583: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
1584: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
1585: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
1586: l_buf := FND_MESSAGE.GET;
1587: FND_FILE.put_line(fnd_file.log, l_buf);
1588: elsif rec.expiry_date <= rec.revldate and rec.status_code = 'EXPIRED' then -- realized
1589: rec.reval_rate := null;
1590: fair_value := 0; -- realized
1591: elsif rec.effective_date <= rec.revldate and rec.status_code = 'EXERCISED' then -- realized

Line 1628: FND_FILE.put_line(fnd_file.log, l_buf);

1624: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
1625: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
1626: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
1627: l_buf := FND_MESSAGE.GET;
1628: FND_FILE.put_line(fnd_file.log, l_buf);
1629: elsif rec.effective_date <= rec.revldate and rec.status_code = 'SETTLED' then -- realized
1630: select settle_rate
1631: into rec.reval_rate
1632: from xtr_deals

Line 1711: FND_FILE.put_line(fnd_file.log, l_buf);

1707: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
1708: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
1709: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
1710: l_buf := FND_MESSAGE.GET;
1711: FND_FILE.put_line(fnd_file.log, l_buf);
1712: elsif rec.effective_date <= rec.revldate and rec.status_code = 'EXPIRED' then -- realized
1713: xtr_revl_mds_init(r_md_in, l_market_set, C_SOURCE, C_SPOT_RATE_IND,
1714: rec.expiry_date, NULL, rec.currencya, rec.currencyb, NULL, NULL, 'M',
1715: rec.batch_id, NULL);

Line 1775: FND_FILE.put_line(fnd_file.log, l_buf);

1771: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
1772: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
1773: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
1774: l_buf := FND_MESSAGE.GET;
1775: FND_FILE.put_line(fnd_file.log, l_buf);
1776: elsif rec.expiry_date <= rec.revldate and rec.status_code = 'EXPIRED' then -- realized
1777: rec.reval_rate := rec.transaction_rate;
1778: fair_value := 0;
1779: elsif rec.effective_date <= rec.revldate and rec.status_code = 'EXERCISED' then -- realized

Line 1876: FND_FILE.put_line(fnd_file.log, l_buf);

1872: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
1873: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
1874: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
1875: l_buf := FND_MESSAGE.GET;
1876: FND_FILE.put_line(fnd_file.log, l_buf);
1877: end if;
1878: when e_invalid_transno then
1879: if g_call_by_form = true then
1880: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_TRANS_NUM');

Line 1891: FND_FILE.put_line(fnd_file.log, l_buf);

1887: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
1888: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
1889: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
1890: l_buf := FND_MESSAGE.GET;
1891: FND_FILE.put_line(fnd_file.log, l_buf);
1892: end if;
1893: when e_invalid_price_model then
1894: if g_call_by_form = true then
1895: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_PRICE_MODEL');

Line 1907: FND_FILE.put_line(fnd_file.log, l_buf);

1903: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
1904: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
1905: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
1906: l_buf := FND_MESSAGE.GET;
1907: FND_FILE.put_line(fnd_file.log, l_buf);
1908: end if;
1909: when e_date_order_error then
1910: if g_call_by_form = true then
1911: FND_MESSAGE.set_name('XTR', 'XTR_DATE_ORDER_ERROR');

Line 1921: FND_FILE.put_line(fnd_file.log, l_buf);

1917: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
1918: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
1919: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
1920: l_buf := FND_MESSAGE.GET;
1921: FND_FILE.put_line(fnd_file.log, l_buf);
1922: end if;
1923: when e_invalid_code then
1924: if g_call_by_form = true then
1925: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CODE');

Line 1935: FND_FILE.put_line(fnd_file.log, l_buf);

1931: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
1932: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
1933: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
1934: l_buf := FND_MESSAGE.GET;
1935: FND_FILE.put_line(fnd_file.log, l_buf);
1936: end if;
1937: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
1938: if g_call_by_form = true then
1939: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');

Line 1949: FND_FILE.put_line(fnd_file.log, l_buf);

1945: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
1946: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
1947: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
1948: l_buf := FND_MESSAGE.GET;
1949: FND_FILE.put_line(fnd_file.log, l_buf);
1950: end if;
1951: when XTR_MARKET_DATA_P.e_mdcs_no_curve_found then
1952: if g_call_by_form = true then
1953: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');

Line 1964: FND_FILE.put_line(fnd_file.log, l_buf);

1960: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
1961: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
1962: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
1963: l_buf := FND_MESSAGE.GET;
1964: FND_FILE.put_line(fnd_file.log, l_buf);
1965: end if;
1966: when others then
1967: if g_call_by_form = true then
1968: APP_EXCEPTION.raise_exception;

Line 1976: FND_FILE.put_line(fnd_file.log, l_buf);

1972: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
1973: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
1974: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
1975: l_buf := FND_MESSAGE.GET;
1976: FND_FILE.put_line(fnd_file.log, l_buf);
1977: end if;
1978: end xtr_revl_get_fairvalue;
1979: -----------------------------------------
1980: /************************************************************/

Line 2200: FND_FILE.put_line(fnd_file.log, l_buf);

2196: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
2197: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
2198: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
2199: l_buf := FND_MESSAGE.GET;
2200: FND_FILE.put_line(fnd_file.log, l_buf);
2201: end if;
2202: when e_invalid_deal_subtype then
2203: if g_call_by_form = true then
2204: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_DEAL_SUBTYPE');

Line 2216: FND_FILE.put_line(fnd_file.log, l_buf);

2212: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
2213: FND_MESSAGE.SET_TOKEN('DEAL_SUBTYPE', rec.deal_subtype);
2214: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
2215: l_buf := FND_MESSAGE.GET;
2216: FND_FILE.put_line(fnd_file.log, l_buf);
2217: end if;
2218: when others then
2219: if g_call_by_form = true then
2220: APP_EXCEPTION.raise_exception;

Line 2228: FND_FILE.put_line(fnd_file.log, l_buf);

2224: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
2225: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
2226: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
2227: l_buf := FND_MESSAGE.GET;
2228: FND_FILE.put_line(fnd_file.log, l_buf);
2229: end if;
2230: end xtr_revl_get_unrel_pl;
2231: --------------------------------------------------------------
2232: /*************************************************************************************/

Line 2367: FND_FILE.put_line(fnd_file.log, l_buf);

2363: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
2364: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
2365: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
2366: l_buf := FND_MESSAGE.GET;
2367: FND_FILE.put_line(fnd_file.log, l_buf);
2368: end if;
2369: when GL_CURRENCY_API.invalid_currency then
2370: if g_call_by_form = true then
2371: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');

Line 2382: FND_FILE.put_line(fnd_file.log, l_buf);

2378: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
2379: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
2380: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
2381: l_buf := FND_MESSAGE.GET;
2382: FND_FILE.put_line(fnd_file.log, l_buf);
2383: end if;
2384: when others then
2385: if g_call_by_form = true then
2386: APP_EXCEPTION.raise_exception;

Line 2394: FND_FILE.put_line(fnd_file.log, l_buf);

2390: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
2391: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
2392: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
2393: l_buf := FND_MESSAGE.GET;
2394: FND_FILE.put_line(fnd_file.log, l_buf);
2395: end if;
2396: End xtr_revl_exchange_rate;
2397: -----------------------------------------------------------------------------------
2398: /*************************************************************************************/

Line 2501: FND_FILE.put_line(fnd_file.log, l_buf);

2497: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
2498: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
2499: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
2500: l_buf := FND_MESSAGE.GET;
2501: FND_FILE.put_line(fnd_file.log, l_buf);
2502: end if;
2503: end xtr_revl_get_curr_gl;
2504: -------------------------------------------------------------------
2505: /*******************************************************************/

Line 2802: FND_FILE.put_line(fnd_file.log, l_buf);

2798: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
2799: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
2800: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
2801: l_buf := FND_MESSAGE.GET;
2802: FND_FILE.put_line(fnd_file.log, l_buf);
2803: end if;
2804: when GL_CURRENCY_API.invalid_currency then
2805: if g_call_by_form = true then
2806: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');

Line 2817: FND_FILE.put_line(fnd_file.log, l_buf);

2813: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
2814: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
2815: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
2816: l_buf := FND_MESSAGE.GET;
2817: FND_FILE.put_line(fnd_file.log, l_buf);
2818: end if;
2819: when others then
2820: if g_call_by_form = true then
2821: APP_EXCEPTION.raise_exception;

Line 2829: FND_FILE.put_line(fnd_file.log, l_buf);

2825: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
2826: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
2827: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
2828: l_buf := FND_MESSAGE.GET;
2829: FND_FILE.put_line(fnd_file.log, l_buf);
2830: end if;
2831: End;
2832: --------------------------------------------------------
2833: /*******************************************************************/

Line 3265: FND_FILE.put_line(fnd_file.log, l_buf);

3261: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
3262: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
3263: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
3264: l_buf := FND_MESSAGE.GET;
3265: FND_FILE.put_line(fnd_file.log, l_buf);
3266: end if;
3267: when GL_CURRENCY_API.invalid_currency then
3268: if g_call_by_form = true then
3269: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');

Line 3280: FND_FILE.put_line(fnd_file.log, l_buf);

3276: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
3277: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
3278: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
3279: l_buf := FND_MESSAGE.GET;
3280: FND_FILE.put_line(fnd_file.log, l_buf);
3281: end if;
3282: when others then
3283: if g_call_by_form = true then
3284: APP_EXCEPTION.raise_exception;

Line 3292: FND_FILE.put_line(fnd_file.log, l_buf);

3288: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
3289: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
3290: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
3291: l_buf := FND_MESSAGE.GET;
3292: FND_FILE.put_line(fnd_file.log, l_buf);
3293: end if;
3294:
3295: End;
3296:

Line 3737: FND_FILE.put_line(fnd_file.log, l_buf);

3733: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
3734: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
3735: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
3736: l_buf := FND_MESSAGE.GET;
3737: FND_FILE.put_line(fnd_file.log, l_buf);
3738: end if;
3739: when GL_CURRENCY_API.invalid_currency then
3740: if g_call_by_form = true then
3741: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');

Line 3752: FND_FILE.put_line(fnd_file.log, l_buf);

3748: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
3749: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
3750: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
3751: l_buf := FND_MESSAGE.GET;
3752: FND_FILE.put_line(fnd_file.log, l_buf);
3753: end if;
3754: when others then
3755: if g_call_by_form = true then
3756: APP_EXCEPTION.raise_exception;

Line 3764: FND_FILE.put_line(fnd_file.log, l_buf);

3760: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
3761: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
3762: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
3763: l_buf := FND_MESSAGE.GET;
3764: FND_FILE.put_line(fnd_file.log, l_buf);
3765: end if;
3766: End;
3767: -----------------------------------------------------------------
3768: /*******************************************************************/

Line 3881: --FND_FILE.put_line(fnd_file.log, 'l_trans_gl_rate = '||l_trans_gl_rate);

3877: -- Get GL rate on start date
3878: GL_CURRENCY_API.get_triangulation_rate
3879: (rec.reval_ccy, rec.sob_ccy, rec.effective_date, rec.ex_rate_type,
3880: l_deno, l_numer, l_trans_gl_rate);
3881: --FND_FILE.put_line(fnd_file.log, 'l_trans_gl_rate = '||l_trans_gl_rate);
3882: l_unrel_start_rate := l_trans_gl_rate;
3883: l_unrel_start_date := rec.start_date;
3884:
3885: select count(*)

Line 4054: FND_FILE.put_line(fnd_file.log, l_buf);

4050: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
4051: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
4052: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
4053: l_buf := FND_MESSAGE.GET;
4054: FND_FILE.put_line(fnd_file.log, l_buf);
4055: end if;
4056: when GL_CURRENCY_API.invalid_currency then
4057: if g_call_by_form = true then
4058: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');

Line 4069: FND_FILE.put_line(fnd_file.log, l_buf);

4065: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
4066: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
4067: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
4068: l_buf := FND_MESSAGE.GET;
4069: FND_FILE.put_line(fnd_file.log, l_buf);
4070: end if;
4071: when others then
4072: if g_call_by_form = true then
4073: APP_EXCEPTION.raise_exception;

Line 4081: FND_FILE.put_line(fnd_file.log, l_buf);

4077: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
4078: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
4079: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
4080: l_buf := FND_MESSAGE.GET;
4081: FND_FILE.put_line(fnd_file.log, l_buf);
4082: end if;
4083: end;
4084: ---------------------------------------------------------------
4085: /***************************************************************/

Line 4179: FND_FILE.put_line(fnd_file.log, l_buf);

4175: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
4176: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
4177: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
4178: l_buf := FND_MESSAGE.GET;
4179: FND_FILE.put_line(fnd_file.log, l_buf);
4180: end if;
4181: end xtr_get_fv_from_batch;
4182:
4183: --------------------------------------------------------

Line 4353: FND_FILE.put_line(fnd_file.log, l_buf);

4349: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
4350: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
4351: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
4352: l_buf := FND_MESSAGE.GET;
4353: FND_FILE.put_line(fnd_file.log, l_buf);
4354: end if;
4355: end xtr_init_fv;
4356:
4357: -------------------------------------------------------------------

Line 4603: FND_FILE.put_line(fnd_file.log, l_buff);

4599: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
4600: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
4601: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
4602: l_buff := FND_MESSAGE.GET;
4603: FND_FILE.put_line(fnd_file.log, l_buff);
4604: end if;
4605: if rec.settle_action = 'PAY' then
4606: end_fv := end_fv * (-1);
4607: end if;

Line 4723: FND_FILE.put_line(fnd_file.log, l_buff);

4719: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
4720: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
4721: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
4722: l_buff := FND_MESSAGE.GET;
4723: FND_FILE.put_line(fnd_file.log, l_buff);
4724: end if;
4725: when GL_CURRENCY_API.invalid_currency then
4726: if g_call_by_form = true then
4727: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');

Line 4736: FND_FILE.put_line(fnd_file.log, l_buff);

4732: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
4733: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
4734: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
4735: l_buff := FND_MESSAGE.GET;
4736: FND_FILE.put_line(fnd_file.log, l_buff);
4737: end if;
4738: when others then
4739: if g_call_by_form = true then
4740: APP_EXCEPTION.raise_exception;

Line 4748: FND_FILE.put_line(fnd_file.log, l_buff);

4744: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
4745: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
4746: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
4747: l_buff := FND_MESSAGE.GET;
4748: FND_FILE.put_line(fnd_file.log, l_buff);
4749: end if;
4750: end xtr_end_fv;
4751: --------------------------------------------------------
4752: /*********************************************************/

Line 4845: FND_FILE.put_line(fnd_file.log, l_buf);

4841: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
4842: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
4843: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
4844: l_buf := FND_MESSAGE.GET;
4845: FND_FILE.put_line(fnd_file.log, l_buf);
4846: Else
4847: XTR_CALC_P.calc_days_run(rec.revldate, l_start_date,
4848: rec.year_calc_type, l_days_t1, l_year);
4849: xtr_revl_mds_init(r_md_in, l_market_set, C_SOURCE,

Line 4909: FND_FILE.put_line(fnd_file.log, l_buf);

4905: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
4906: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
4907: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
4908: l_buf := FND_MESSAGE.GET;
4909: FND_FILE.put_line(fnd_file.log, l_buf);
4910: end if;
4911: when XTR_MARKET_DATA_P.e_mdcs_no_curve_found then
4912: if g_call_by_form = true then
4913: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');

Line 4924: FND_FILE.put_line(fnd_file.log, l_buf);

4920: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
4921: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
4922: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
4923: l_buf := FND_MESSAGE.GET;
4924: FND_FILE.put_line(fnd_file.log, l_buf);
4925: end if;
4926: when others then
4927: if g_call_by_form = true then
4928: APP_EXCEPTION.raise_exception;

Line 4936: FND_FILE.put_line(fnd_file.log, l_buf);

4932: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
4933: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
4934: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
4935: l_buf := FND_MESSAGE.GET;
4936: FND_FILE.put_line(fnd_file.log, l_buf);
4937: end if;
4938: end xtr_revl_getprice_fwd;
4939: --------------------------------------------------------
4940: /*********************************************************/

Line 5091: FND_FILE.put_line(fnd_file.log, l_buf);

5087: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
5088: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
5089: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
5090: l_buf := FND_MESSAGE.GET;
5091: FND_FILE.put_line(fnd_file.log, l_buf);
5092: end if;
5093: when XTR_MARKET_DATA_P.e_mdcs_no_curve_found then
5094: if g_call_by_form = true then
5095: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');

Line 5106: FND_FILE.put_line(fnd_file.log, l_buf);

5102: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
5103: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
5104: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
5105: l_buf := FND_MESSAGE.GET;
5106: FND_FILE.put_line(fnd_file.log, l_buf);
5107: end if;
5108: when others then
5109: if g_call_by_form = true then
5110: APP_EXCEPTION.raise_exception;

Line 5118: FND_FILE.put_line(fnd_file.log, l_buf);

5114: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
5115: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
5116: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
5117: l_buf := FND_MESSAGE.GET;
5118: FND_FILE.put_line(fnd_file.log, l_buf);
5119: end if;
5120: end xtr_revl_fv_fra;
5121: -----------------------------------------
5122: /*********************************************************/

Line 5424: FND_FILE.put_line(fnd_file.log, l_buff);

5420: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
5421: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
5422: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
5423: l_buff := FND_MESSAGE.GET;
5424: FND_FILE.put_line(fnd_file.log, l_buff);
5425: end if;
5426: when GL_CURRENCY_API.invalid_currency then
5427: if g_call_by_form = true then
5428: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');

Line 5439: FND_FILE.put_line(fnd_file.log, l_buff);

5435: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
5436: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
5437: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
5438: l_buff := FND_MESSAGE.GET;
5439: FND_FILE.put_line(fnd_file.log, l_buff);
5440: end if;
5441: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
5442: if g_call_by_form = true then
5443: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');

Line 5453: FND_FILE.put_line(fnd_file.log, l_buff);

5449: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
5450: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
5451: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
5452: l_buff := FND_MESSAGE.GET;
5453: FND_FILE.put_line(fnd_file.log, l_buff);
5454: end if;
5455: when XTR_MARKET_DATA_P.e_mdcs_no_curve_found then
5456: if g_call_by_form = true then
5457: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');

Line 5468: FND_FILE.put_line(fnd_file.log, l_buff);

5464: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
5465: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
5466: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
5467: l_buff := FND_MESSAGE.GET;
5468: FND_FILE.put_line(fnd_file.log, l_buff);
5469: end if;
5470: when others then
5471: if g_call_by_form = true then
5472: APP_EXCEPTION.raise_exception;

Line 5480: FND_FILE.put_line(fnd_file.log, l_buff);

5476: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
5477: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
5478: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
5479: l_buff := FND_MESSAGE.GET;
5480: FND_FILE.put_line(fnd_file.log, l_buff);
5481: end if;
5482: end xtr_revl_fv_fx;
5483: --------------------------------------------------------
5484: /*************************************************************/

Line 5673: FND_FILE.put_line(fnd_file.log, l_buff);

5669: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
5670: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
5671: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
5672: l_buff := FND_MESSAGE.GET;
5673: FND_FILE.put_line(fnd_file.log, l_buff);
5674: end if;
5675: when GL_CURRENCY_API.invalid_currency then
5676: if g_call_by_form = true then
5677: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');

Line 5688: FND_FILE.put_line(fnd_file.log, l_buff);

5684: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
5685: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
5686: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
5687: l_buff := FND_MESSAGE.GET;
5688: FND_FILE.put_line(fnd_file.log, l_buff);
5689: end if;
5690: when others then
5691: if g_call_by_form = true then
5692: APP_EXCEPTION.raise_exception;

Line 5700: FND_FILE.put_line(fnd_file.log, l_buff);

5696: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
5697: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
5698: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
5699: l_buff := FND_MESSAGE.GET;
5700: FND_FILE.put_line(fnd_file.log, l_buff);
5701: end if;
5702: End;
5703: ----------------------------------------------------------------
5704: /*********************************************************/

Line 5946: FND_FILE.put_line(fnd_file.log, l_buff);

5942: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
5943: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
5944: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
5945: l_buff := FND_MESSAGE.GET;
5946: FND_FILE.put_line(fnd_file.log, l_buff);
5947: end if;
5948: when GL_CURRENCY_API.invalid_currency then
5949: if g_call_by_form = true then
5950: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');

Line 5961: FND_FILE.put_line(fnd_file.log, l_buff);

5957: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
5958: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
5959: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
5960: l_buff := FND_MESSAGE.GET;
5961: FND_FILE.put_line(fnd_file.log, l_buff);
5962: end if;
5963: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
5964: if g_call_by_form = true then
5965: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');

Line 5975: FND_FILE.put_line(fnd_file.log, l_buff);

5971: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
5972: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
5973: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
5974: l_buff := FND_MESSAGE.GET;
5975: FND_FILE.put_line(fnd_file.log, l_buff);
5976: end if;
5977: when XTR_MARKET_DATA_P.e_mdcs_no_curve_found then
5978: if g_call_by_form = true then
5979: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');

Line 5990: FND_FILE.put_line(fnd_file.log, l_buff);

5986: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
5987: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
5988: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
5989: l_buff := FND_MESSAGE.GET;
5990: FND_FILE.put_line(fnd_file.log, l_buff);
5991: end if;
5992: when others then
5993: if g_call_by_form = true then
5994: APP_EXCEPTION.raise_exception;

Line 6002: FND_FILE.put_line(fnd_file.log, l_buff);

5998: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
5999: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
6000: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
6001: l_buff := FND_MESSAGE.GET;
6002: FND_FILE.put_line(fnd_file.log, l_buff);
6003: end if;
6004: end xtr_revl_getrate_fx;
6005:
6006:

Line 6293: FND_FILE.put_line(fnd_file.log, l_buff);

6289: FND_MESSAGE.SET_NAME('XTR', 'XTR_REVAL_PROS_FAIL');
6290: FND_MESSAGE.SET_TOKEN('HEDGE_NO', rec.deal_no);
6291: FND_MESSAGE.SET_TOKEN('NEXT_TEST_DATE', l_next_test_date);
6292: l_buff := FND_MESSAGE.GET;
6293: FND_FILE.put_line(fnd_file.log, l_buff);
6294: end if;
6295:
6296: xtr_first_reval(rec, l_first);
6297: if l_first = TRUE then -- first time reval

Line 6454: FND_FILE.put_line(fnd_file.log, l_buff);

6450: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
6451: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
6452: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
6453: l_buff := FND_MESSAGE.GET;
6454: FND_FILE.put_line(fnd_file.log, l_buff);
6455: end if;
6456: when GL_CURRENCY_API.invalid_currency then
6457: if g_call_by_form = true then
6458: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');

Line 6467: FND_FILE.put_line(fnd_file.log, l_buff);

6463: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
6464: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
6465: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
6466: l_buff := FND_MESSAGE.GET;
6467: FND_FILE.put_line(fnd_file.log, l_buff);
6468: end if;
6469: when others then
6470: if g_call_by_form = true then
6471: APP_EXCEPTION.raise_exception;

Line 6479: FND_FILE.put_line(fnd_file.log, l_buff);

6475: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
6476: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
6477: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
6478: l_buff := FND_MESSAGE.GET;
6479: FND_FILE.put_line(fnd_file.log, l_buff);
6480: end if;
6481:
6482: END xtr_hedge_gl_rate;
6483:

Line 6766: FND_FILE.put_line(fnd_file.log, l_buff);

6762: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
6763: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
6764: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
6765: l_buff := FND_MESSAGE.GET;
6766: FND_FILE.put_line(fnd_file.log, l_buff);
6767: end if;
6768: when XTR_MARKET_DATA_P.e_mdcs_no_curve_found then
6769: if g_call_by_form = true then
6770: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');

Line 6781: FND_FILE.put_line(fnd_file.log, l_buff);

6777: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
6778: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
6779: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
6780: l_buff := FND_MESSAGE.GET;
6781: FND_FILE.put_line(fnd_file.log, l_buff);
6782: end if;
6783: when others then
6784: if g_call_by_form = true then
6785: APP_EXCEPTION.raise_exception;

Line 6793: fnd_file.put_line(fnd_file.log, l_buff);

6789: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
6790: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
6791: FND_MESSAGE.SET_TOKEN('ISSUE_CODE', rec.contract_code);
6792: l_buff := FND_MESSAGE.GET;
6793: fnd_file.put_line(fnd_file.log, l_buff);
6794: end if;
6795: END xtr_hedge_fwd_rate;
6796:
6797: ---------------------------------------------------------------

Line 6980: FND_FILE.put_line(fnd_file.log, l_buf);

6976: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
6977: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
6978: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
6979: l_buf := FND_MESSAGE.GET;
6980: FND_FILE.put_line(fnd_file.log, l_buf);
6981: Else
6982: XTR_CALC_P.calc_days_run(rec.revldate, rec.expiry_date,
6983: rec.year_calc_type, l_no_of_days, l_year);
6984:

Line 7097: FND_FILE.put_line(fnd_file.log, l_buf);

7093: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
7094: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
7095: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
7096: l_buf := FND_MESSAGE.GET;
7097: FND_FILE.put_line(fnd_file.log, l_buf);
7098: end if;
7099: when XTR_MARKET_DATA_P.e_mdcs_no_curve_found then
7100: if g_call_by_form = true then
7101: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');

Line 7112: FND_FILE.put_line(fnd_file.log, l_buf);

7108: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
7109: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
7110: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
7111: l_buf := FND_MESSAGE.GET;
7112: FND_FILE.put_line(fnd_file.log, l_buf);
7113: end if;
7114: when others then
7115: if g_call_by_form = true then
7116: APP_EXCEPTION.raise_exception;

Line 7124: FND_FILE.put_line(fnd_file.log, l_buf);

7120: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
7121: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
7122: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
7123: l_buf := FND_MESSAGE.GET;
7124: FND_FILE.put_line(fnd_file.log, l_buf);
7125: end if;
7126: end xtr_revl_getprice_fxo;
7127: --------------------------------------------------------
7128: /*********************************************************/

Line 7281: FND_FILE.put_line(fnd_file.log, l_buf);

7277: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
7278: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
7279: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
7280: l_buf := FND_MESSAGE.GET;
7281: FND_FILE.put_line(fnd_file.log, l_buf);
7282: end if;
7283: end xtr_revl_fv_ni;
7284: --------------------------------------------------------
7285: /*********************************************************/

Line 7356: FND_FILE.put_line(fnd_file.log, l_buf);

7352: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
7353: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
7354: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
7355: l_buf := FND_MESSAGE.GET;
7356: FND_FILE.put_line(fnd_file.log, l_buf);
7357: end if;
7358: when XTR_MARKET_DATA_P.e_mdcs_no_curve_found then
7359: if g_call_by_form = true then
7360: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');

Line 7371: FND_FILE.put_line(fnd_file.log, l_buf);

7367: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
7368: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
7369: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
7370: l_buf := FND_MESSAGE.GET;
7371: FND_FILE.put_line(fnd_file.log, l_buf);
7372: end if;
7373: when others then
7374: if g_call_by_form = true then
7375: APP_EXCEPTION.raise_exception;

Line 7383: FND_FILE.put_line(fnd_file.log, l_buf);

7379: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
7380: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
7381: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
7382: l_buf := FND_MESSAGE.GET;
7383: FND_FILE.put_line(fnd_file.log, l_buf);
7384: end if;
7385:
7386: end xtr_revl_getrate_ni;
7387: -------------------------------------------------------------

Line 7552: FND_FILE.put_line(fnd_file.log, l_buff);

7548: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
7549: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
7550: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
7551: l_buff := FND_MESSAGE.GET;
7552: FND_FILE.put_line(fnd_file.log, l_buff);
7553: end if;
7554: when XTR_MARKET_DATA_P.e_mdcs_no_curve_found then
7555: if g_call_by_form = true then
7556: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');

Line 7567: FND_FILE.put_line(fnd_file.log, l_buff);

7563: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
7564: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
7565: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
7566: l_buff := FND_MESSAGE.GET;
7567: FND_FILE.put_line(fnd_file.log, l_buff);
7568: end if;
7569: when others then
7570: if g_call_by_form = true then
7571: APP_EXCEPTION.raise_exception;

Line 7579: fnd_file.put_line(fnd_file.log, l_buff);

7575: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
7576: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
7577: FND_MESSAGE.SET_TOKEN('ISSUE_CODE', rec.contract_code);
7578: l_buff := FND_MESSAGE.GET;
7579: fnd_file.put_line(fnd_file.log, l_buff);
7580: end if;
7581: End xtr_revl_getprice_bond;
7582: -------------------------------------------------------------
7583: /*********************************************************/

Line 7708: FND_FILE.put_line(fnd_file.log, l_buf);

7704: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
7705: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
7706: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
7707: l_buf := FND_MESSAGE.GET;
7708: FND_FILE.put_line(fnd_file.log, l_buf);
7709: end if;
7710: End;
7711: --------------------------------------------------------
7712: /*********************************************************/

Line 7770: FND_FILE.put_line(fnd_file.log, l_buf);

7766: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
7767: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
7768: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
7769: l_buf := FND_MESSAGE.GET;
7770: FND_FILE.put_line(fnd_file.log, l_buf);
7771: end if;
7772: End xtr_revl_bond_realamc;
7773: -------------------------------------------------------------
7774: /*********************************************************/

Line 7903: FND_FILE.put_line(fnd_file.log, l_buf);

7899: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
7900: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
7901: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
7902: l_buf := FND_MESSAGE.GET;
7903: FND_FILE.put_line(fnd_file.log, l_buf);
7904: end if;
7905: End xtr_revl_bond_realmtm;
7906: ---------------------------------------------------------------
7907: /*********************************************************/

Line 8117: FND_FILE.put_line(fnd_file.log, l_buf);

8113: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
8114: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
8115: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
8116: l_buf := FND_MESSAGE.GET;
8117: FND_FILE.put_line(fnd_file.log, l_buf);
8118: end if;
8119: when GL_CURRENCY_API.invalid_currency then
8120: if g_call_by_form = true then
8121: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');

Line 8132: FND_FILE.put_line(fnd_file.log, l_buf);

8128: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
8129: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
8130: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
8131: l_buf := FND_MESSAGE.GET;
8132: FND_FILE.put_line(fnd_file.log, l_buf);
8133: end if;
8134: when others then
8135: if g_call_by_form = true then
8136: APP_EXCEPTION.raise_exception;

Line 8144: FND_FILE.put_line(fnd_file.log, l_buf);

8140: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
8141: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
8142: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
8143: l_buf := FND_MESSAGE.GET;
8144: FND_FILE.put_line(fnd_file.log, l_buf);
8145: end if;
8146: End xtr_revl_bond_unreal;
8147: ----------------------------------------------------------------
8148: /*********************************************************/

Line 8527: FND_FILE.put_line(fnd_file.log, l_buf);

8523: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
8524: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
8525: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
8526: l_buf := FND_MESSAGE.GET;
8527: FND_FILE.put_line(fnd_file.log, l_buf);
8528: end if;
8529: end xtr_revl_fv_tmm;
8530: --------------------------------------------------------
8531: PROCEDURE xtr_revl_present_value_tmm(

Line 8602: FND_FILE.put_line(fnd_file.log, l_buf);

8598: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
8599: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
8600: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
8601: l_buf := FND_MESSAGE.GET;
8602: FND_FILE.put_line(fnd_file.log, l_buf);
8603: end if;
8604: when XTR_MARKET_DATA_P.e_mdcs_no_curve_found then
8605: if g_call_by_form = true then
8606: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');

Line 8617: FND_FILE.put_line(fnd_file.log, l_buf);

8613: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
8614: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
8615: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
8616: l_buf := FND_MESSAGE.GET;
8617: FND_FILE.put_line(fnd_file.log, l_buf);
8618: end if;
8619: when others then
8620: if g_call_by_form = true then
8621: APP_EXCEPTION.raise_exception;

Line 8629: FND_FILE.put_line(fnd_file.log, l_buf);

8625: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
8626: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
8627: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
8628: l_buf := FND_MESSAGE.GET;
8629: FND_FILE.put_line(fnd_file.log, l_buf);
8630: end if;
8631:
8632: end xtr_revl_present_value_tmm;
8633: --------------------------------------------------------

Line 8748: FND_FILE.put_line(fnd_file.log, l_buf);

8744: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
8745: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
8746: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
8747: l_buf := FND_MESSAGE.GET;
8748: FND_FILE.put_line(fnd_file.log, l_buf);
8749: end if;
8750:
8751: END;
8752:

Line 8812: FND_FILE.put_line(fnd_file.log, l_buf);

8808: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
8809: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
8810: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
8811: l_buf := FND_MESSAGE.GET;
8812: FND_FILE.put_line(fnd_file.log, l_buf);
8813: end if;
8814:
8815: END;
8816:

Line 9020: FND_FILE.put_line(fnd_file.log, l_buf);

9016: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
9017: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
9018: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
9019: l_buf := FND_MESSAGE.GET;
9020: FND_FILE.put_line(fnd_file.log, l_buf);
9021: end if;
9022: when GL_CURRENCY_API.invalid_currency then
9023: if g_call_by_form = true then
9024: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');

Line 9035: FND_FILE.put_line(fnd_file.log, l_buf);

9031: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
9032: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
9033: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
9034: l_buf := FND_MESSAGE.GET;
9035: FND_FILE.put_line(fnd_file.log, l_buf);
9036: end if;
9037: when others then
9038: if g_call_by_form = true then
9039: APP_EXCEPTION.raise_exception;

Line 9103: FND_FILE.put_line(fnd_file.log, l_buff);

9099: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
9100: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
9101: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
9102: l_buff := FND_MESSAGE.GET;
9103: FND_FILE.put_line(fnd_file.log, l_buff);
9104: end if;
9105: when XTR_MARKET_DATA_P.e_mdcs_no_curve_found then
9106: if g_call_by_form = true then
9107: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');

Line 9118: FND_FILE.put_line(fnd_file.log, l_buff);

9114: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
9115: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
9116: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
9117: l_buff := FND_MESSAGE.GET;
9118: FND_FILE.put_line(fnd_file.log, l_buff);
9119: end if;
9120: when others then
9121: if g_call_by_form = true then
9122: APP_EXCEPTION.raise_exception;

Line 9130: fnd_file.put_line(fnd_file.log, l_buff);

9126: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
9127: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
9128: FND_MESSAGE.SET_TOKEN('ISSUE_CODE', rec.contract_code);
9129: l_buff := FND_MESSAGE.GET;
9130: fnd_file.put_line(fnd_file.log, l_buff);
9131: end if;
9132: End xtr_revl_getprice_stock;
9133:
9134: -----------------------------------------------------------

Line 9264: FND_FILE.put_line(fnd_file.log, l_buf);

9260: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
9261: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
9262: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
9263: l_buf := FND_MESSAGE.GET;
9264: FND_FILE.put_line(fnd_file.log, l_buf);
9265: end if;
9266: when XTR_MARKET_DATA_P.e_mdcs_no_curve_found then
9267: if g_call_by_form = true then
9268: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');

Line 9279: FND_FILE.put_line(fnd_file.log, l_buf);

9275: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
9276: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
9277: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
9278: l_buf := FND_MESSAGE.GET;
9279: FND_FILE.put_line(fnd_file.log, l_buf);
9280: end if;
9281: when others then
9282: if g_call_by_form = true then
9283: APP_EXCEPTION.raise_exception;

Line 9291: FND_FILE.put_line(fnd_file.log, l_buf);

9287: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
9288: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
9289: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
9290: l_buf := FND_MESSAGE.GET;
9291: FND_FILE.put_line(fnd_file.log, l_buf);
9292: end if;
9293: end xtr_revl_fv_iro;
9294: --------------------------------------------------------
9295: /*********************************************************/

Line 9572: FND_FILE.put_line(fnd_file.log, l_buf);

9568: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
9569: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
9570: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
9571: l_buf := FND_MESSAGE.GET;
9572: FND_FILE.put_line(fnd_file.log, l_buf);
9573: end if;
9574: end xtr_revl_fv_irs;
9575:
9576: -------------------------------------------------------------

Line 9701: FND_FILE.put_line(fnd_file.log, l_buf);

9697: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
9698: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
9699: FND_MESSAGE.SET_TOKEN('TRANS_NO', rec.trans_no);
9700: l_buf := FND_MESSAGE.GET;
9701: FND_FILE.put_line(fnd_file.log, l_buf);
9702: end if;
9703: End;
9704: --------------------------------------------------------
9705: /*******************************************************/

Line 9798: fnd_file.put_line(fnd_file.log, l_buf);

9794: t_log(l_tmp).trans_no || ' Error: ' ||
9795: t_log(l_tmp).log;
9796: end if;
9797: End If;
9798: fnd_file.put_line(fnd_file.log, l_buf);
9799: l_tmp := l_tmp + 1;
9800: end loop;
9801: fnd_file.close;
9802: end t_log_dump;

Line 9801: fnd_file.close;

9797: End If;
9798: fnd_file.put_line(fnd_file.log, l_buf);
9799: l_tmp := l_tmp + 1;
9800: end loop;
9801: fnd_file.close;
9802: end t_log_dump;
9803:
9804: --------------------------------------------------------
9805: PROCEDURE t_log_init is

Line 10388: fnd_file.put_line(1,p_text||' : '||p_value);

10384: if l_flag = 'D' then
10385: /*dbms_output.put_line(p_text||' : '||p_value);*/
10386: null;
10387: elsif l_flag = 'C' then
10388: fnd_file.put_line(1,p_text||' : '||p_value);
10389: else
10390: xtr_risk_debug_pkg.dlog(p_text, p_value);
10391: end if;
10392: