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 APP_EXCEPTION

Line 410: APP_EXCEPTION.raise_exception;

406: EXCEPTION
407: When e_no_pre_batch then
408: FND_MESSAGE.Set_Name('XTR', 'XTR_NO_PRE_REVAL');
409: FND_MESSAGE.Set_Token('BATCH', p_batch_id);
410: APP_EXCEPTION.raise_exception;
411: When e_batch_been_run then
412: FND_MESSAGE.Set_Name('XTR', 'XTR_BATCH_IN_REVAL');
413: FND_MESSAGE.Set_Token('BATCH', p_batch_id);
414: APP_EXCEPTION.raise_exception;

Line 414: APP_EXCEPTION.raise_exception;

410: APP_EXCEPTION.raise_exception;
411: When e_batch_been_run then
412: FND_MESSAGE.Set_Name('XTR', 'XTR_BATCH_IN_REVAL');
413: FND_MESSAGE.Set_Token('BATCH', p_batch_id);
414: APP_EXCEPTION.raise_exception;
415:
416: end CALC_REVALS;
417: --------------------------------------------------------
418: /********************************************************/

Line 1275: APP_EXCEPTION.raise_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;
1276: else
1277: set_err_log(retcode);
1278: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
1279: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 1290: APP_EXCEPTION.raise_exception;

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);
1290: APP_EXCEPTION.raise_exception;
1291: else
1292: set_err_log(retcode);
1293: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
1294: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 1302: APP_EXCEPTION.raise_exception;

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;
1303: else
1304: set_err_log(retcode);
1305: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
1306: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 1475: APP_EXCEPTION.raise_exception;

1471:
1472: EXCEPTION
1473: when others then
1474: if g_call_by_form = true then
1475: APP_EXCEPTION.raise_exception;
1476: else
1477: set_err_log(retcode);
1478: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
1479: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 1885: APP_EXCEPTION.raise_exception;

1881: if g_call_by_form = true then
1882: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_DEAL_TYPE');
1883: FND_MESSAGE.Set_Token('DEAL_TYPE', rec.deal_type);
1884: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
1885: APP_EXCEPTION.raise_exception;
1886: else
1887: set_err_log(retcode);
1888: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_DEALTYPE');
1889: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 1900: APP_EXCEPTION.raise_exception;

1896: if g_call_by_form = true then
1897: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_TRANS_NUM');
1898: FND_MESSAGE.Set_Token('DEAL_NO', rec.deal_no);
1899: FND_MESSAGE.Set_Token('TRANS_NO', rec.trans_no);
1900: APP_EXCEPTION.raise_exception;
1901: else
1902: set_err_log(retcode);
1903: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_TRANSNUM');
1904: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 1916: APP_EXCEPTION.raise_exception;

1912: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_PRICE_MODEL');
1913: FND_MESSAGE.Set_Token('PRICE_MODEL', rec.pricing_model);
1914: FND_MESSAGE.Set_Token('DEAL_TYPE', rec.deal_type);
1915: FND_MESSAGE.Set_Token('DEAL_NO', rec.deal_no);
1916: APP_EXCEPTION.raise_exception;
1917: else
1918: set_err_log(retcode);
1919: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_PRICEMODEL');
1920: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 1930: APP_EXCEPTION.raise_exception;

1926: when e_date_order_error then
1927: if g_call_by_form = true then
1928: FND_MESSAGE.set_name('XTR', 'XTR_DATE_ORDER_ERROR');
1929: FND_MESSAGE.Set_Token('DEAL_NO', rec.deal_no);
1930: APP_EXCEPTION.raise_exception;
1931: else
1932: set_err_log(retcode);
1933: FND_MESSAGE.SET_NAME('XTR', 'XTR_SPOTDATE_REVALDATE');
1934: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 1944: APP_EXCEPTION.raise_exception;

1940: when e_invalid_code then
1941: if g_call_by_form = true then
1942: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CODE');
1943: FND_MESSAGE.Set_Token('DEAL_NO', rec.deal_no);
1944: APP_EXCEPTION.raise_exception;
1945: else
1946: set_err_log(retcode);
1947: FND_MESSAGE.SET_NAME('XTR', 'XTR_INTERNAL_ERR');
1948: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 1958: APP_EXCEPTION.raise_exception;

1954: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
1955: if g_call_by_form = true then
1956: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
1957: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
1958: APP_EXCEPTION.raise_exception;
1959: else
1960: set_err_log(retcode);
1961: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
1962: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 1973: APP_EXCEPTION.raise_exception;

1969: if g_call_by_form = true then
1970: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
1971: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
1972: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
1973: APP_EXCEPTION.raise_exception;
1974: else
1975: set_err_log(retcode);
1976: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
1977: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 1985: APP_EXCEPTION.raise_exception;

1981: FND_FILE.put_line(fnd_file.log, l_buf);
1982: end if;
1983: when others then
1984: if g_call_by_form = true then
1985: APP_EXCEPTION.raise_exception;
1986: else
1987: set_err_log(retcode);
1988: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
1989: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2209: APP_EXCEPTION.raise_exception;

2205: if g_call_by_form = true then
2206: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_DEAL_TYPE');
2207: FND_MESSAGE.set_token('DEAL_TYPE', rec.deal_type);
2208: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
2209: APP_EXCEPTION.raise_exception;
2210: else
2211: set_err_log(retcode);
2212: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_DEALTYPE');
2213: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2224: APP_EXCEPTION.raise_exception;

2220: if g_call_by_form = true then
2221: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_DEAL_SUBTYPE');
2222: FND_MESSAGE.set_token('DEAL_TYPE', rec.deal_type);
2223: FND_MESSAGE.set_token('DEAL_SUBTYPE', rec.deal_subtype);
2224: APP_EXCEPTION.raise_exception;
2225: else
2226: set_err_log(retcode);
2227: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_DEALSUBTYPE');
2228: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2237: APP_EXCEPTION.raise_exception;

2233: FND_FILE.put_line(fnd_file.log, l_buf);
2234: end if;
2235: when others then
2236: if g_call_by_form = true then
2237: APP_EXCEPTION.raise_exception;
2238: else
2239: set_err_log(retcode);
2240: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
2241: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2376: APP_EXCEPTION.raise_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;
2377: else
2378: set_err_log(retcode);
2379: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
2380: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2391: APP_EXCEPTION.raise_exception;

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);
2391: APP_EXCEPTION.raise_exception;
2392: else
2393: set_err_log(retcode);
2394: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
2395: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2403: APP_EXCEPTION.raise_exception;

2399: FND_FILE.put_line(fnd_file.log, l_buf);
2400: end if;
2401: when others then
2402: if g_call_by_form = true then
2403: APP_EXCEPTION.raise_exception;
2404: else
2405: set_err_log(retcode);
2406: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
2407: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2510: APP_EXCEPTION.raise_exception;

2506:
2507: EXCEPTION
2508: when others then
2509: if g_call_by_form = true then
2510: APP_EXCEPTION.raise_exception;
2511: else
2512: set_err_log(retcode);
2513: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
2514: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2811: APP_EXCEPTION.raise_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;
2812: else
2813: set_err_log(retcode);
2814: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
2815: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2826: APP_EXCEPTION.raise_exception;

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);
2826: APP_EXCEPTION.raise_exception;
2827: else
2828: set_err_log(retcode);
2829: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
2830: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2838: APP_EXCEPTION.raise_exception;

2834: FND_FILE.put_line(fnd_file.log, l_buf);
2835: end if;
2836: when others then
2837: if g_call_by_form = true then
2838: APP_EXCEPTION.raise_exception;
2839: else
2840: set_err_log(retcode);
2841: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
2842: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 3274: APP_EXCEPTION.raise_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;
3275: else
3276: set_err_log(retcode);
3277: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
3278: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 3289: APP_EXCEPTION.raise_exception;

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);
3289: APP_EXCEPTION.raise_exception;
3290: else
3291: set_err_log(retcode);
3292: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
3293: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 3301: APP_EXCEPTION.raise_exception;

3297: FND_FILE.put_line(fnd_file.log, l_buf);
3298: end if;
3299: when others then
3300: if g_call_by_form = true then
3301: APP_EXCEPTION.raise_exception;
3302: else
3303: set_err_log(retcode);
3304: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
3305: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 3746: APP_EXCEPTION.raise_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;
3747: else
3748: set_err_log(retcode);
3749: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
3750: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 3761: APP_EXCEPTION.raise_exception;

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);
3761: APP_EXCEPTION.raise_exception;
3762: else
3763: set_err_log(retcode);
3764: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
3765: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 3773: APP_EXCEPTION.raise_exception;

3769: FND_FILE.put_line(fnd_file.log, l_buf);
3770: end if;
3771: when others then
3772: if g_call_by_form = true then
3773: APP_EXCEPTION.raise_exception;
3774: else
3775: set_err_log(retcode);
3776: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
3777: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4063: APP_EXCEPTION.raise_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;
4064: else
4065: set_err_log(retcode);
4066: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
4067: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4078: APP_EXCEPTION.raise_exception;

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);
4078: APP_EXCEPTION.raise_exception;
4079: else
4080: set_err_log(retcode);
4081: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
4082: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4090: APP_EXCEPTION.raise_exception;

4086: FND_FILE.put_line(fnd_file.log, l_buf);
4087: end if;
4088: when others then
4089: if g_call_by_form = true then
4090: APP_EXCEPTION.raise_exception;
4091: else
4092: set_err_log(retcode);
4093: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
4094: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4188: APP_EXCEPTION.raise_exception;

4184:
4185: EXCEPTION
4186: when others then
4187: if g_call_by_form = true then
4188: APP_EXCEPTION.raise_exception;
4189: else
4190: set_err_log(retcode);
4191: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
4192: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4362: APP_EXCEPTION.raise_exception;

4358:
4359: EXCEPTION
4360: when others then
4361: if g_call_by_form = true then
4362: APP_EXCEPTION.raise_exception;
4363: else
4364: set_err_log(retcode);
4365: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
4366: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4552: APP_EXCEPTION.raise_exception;

4548: Null; -- Not Applicable for these Deal Types;
4549: End If;
4550: EXCEPTION
4551: WHEN others THEN
4552: APP_EXCEPTION.raise_exception;
4553: END xtr_ins_init_fv;
4554:
4555: --------------------------------------------------------
4556: /********************************************************/

Line 4732: APP_EXCEPTION.raise_exception;

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
4734: set_err_log(retcode);
4735: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
4736: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4745: APP_EXCEPTION.raise_exception;

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
4747: set_err_log(retcode);
4748: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
4749: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4757: APP_EXCEPTION.raise_exception;

4753: FND_FILE.put_line(fnd_file.log, l_buff);
4754: end if;
4755: when others then
4756: if g_call_by_form = true then
4757: APP_EXCEPTION.raise_exception;
4758: else
4759: set_err_log(retcode);
4760: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
4761: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4918: APP_EXCEPTION.raise_exception;

4914: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
4915: if g_call_by_form = true then
4916: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
4917: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
4918: APP_EXCEPTION.raise_exception;
4919: else
4920: set_err_log(retcode);
4921: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
4922: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4933: APP_EXCEPTION.raise_exception;

4929: if g_call_by_form = true then
4930: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
4931: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
4932: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
4933: APP_EXCEPTION.raise_exception;
4934: else
4935: set_err_log(retcode);
4936: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
4937: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4945: APP_EXCEPTION.raise_exception;

4941: FND_FILE.put_line(fnd_file.log, l_buf);
4942: end if;
4943: when others then
4944: if g_call_by_form = true then
4945: APP_EXCEPTION.raise_exception;
4946: else
4947: set_err_log(retcode);
4948: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
4949: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5100: APP_EXCEPTION.raise_exception;

5096: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
5097: if g_call_by_form = true then
5098: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
5099: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5100: APP_EXCEPTION.raise_exception;
5101: else
5102: set_err_log(retcode);
5103: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
5104: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5115: APP_EXCEPTION.raise_exception;

5111: if g_call_by_form = true then
5112: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
5113: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
5114: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5115: APP_EXCEPTION.raise_exception;
5116: else
5117: set_err_log(retcode);
5118: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
5119: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5127: APP_EXCEPTION.raise_exception;

5123: FND_FILE.put_line(fnd_file.log, l_buf);
5124: end if;
5125: when others then
5126: if g_call_by_form = true then
5127: APP_EXCEPTION.raise_exception;
5128: else
5129: set_err_log(retcode);
5130: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
5131: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5433: APP_EXCEPTION.raise_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;
5434: else
5435: set_err_log(retcode);
5436: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
5437: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5448: APP_EXCEPTION.raise_exception;

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);
5448: APP_EXCEPTION.raise_exception;
5449: else
5450: set_err_log(retcode);
5451: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
5452: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5462: APP_EXCEPTION.raise_exception;

5458: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
5459: if g_call_by_form = true then
5460: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
5461: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5462: APP_EXCEPTION.raise_exception;
5463: else
5464: set_err_log(retcode);
5465: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
5466: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5477: APP_EXCEPTION.raise_exception;

5473: if g_call_by_form = true then
5474: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
5475: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
5476: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5477: APP_EXCEPTION.raise_exception;
5478: else
5479: set_err_log(retcode);
5480: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
5481: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5489: APP_EXCEPTION.raise_exception;

5485: FND_FILE.put_line(fnd_file.log, l_buff);
5486: end if;
5487: when others then
5488: if g_call_by_form = true then
5489: APP_EXCEPTION.raise_exception;
5490: else
5491: set_err_log(retcode);
5492: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
5493: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5682: APP_EXCEPTION.raise_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;
5683: else
5684: set_err_log(retcode);
5685: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
5686: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5697: APP_EXCEPTION.raise_exception;

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);
5697: APP_EXCEPTION.raise_exception;
5698: else
5699: set_err_log(retcode);
5700: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
5701: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5709: APP_EXCEPTION.raise_exception;

5705: FND_FILE.put_line(fnd_file.log, l_buff);
5706: end if;
5707: when others then
5708: if g_call_by_form = true then
5709: APP_EXCEPTION.raise_exception;
5710: else
5711: set_err_log(retcode);
5712: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
5713: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5955: APP_EXCEPTION.raise_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;
5956: else
5957: set_err_log(retcode);
5958: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
5959: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5970: APP_EXCEPTION.raise_exception;

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);
5970: APP_EXCEPTION.raise_exception;
5971: else
5972: set_err_log(retcode);
5973: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
5974: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5984: APP_EXCEPTION.raise_exception;

5980: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
5981: if g_call_by_form = true then
5982: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
5983: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5984: APP_EXCEPTION.raise_exception;
5985: else
5986: set_err_log(retcode);
5987: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
5988: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5999: APP_EXCEPTION.raise_exception;

5995: if g_call_by_form = true then
5996: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
5997: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
5998: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5999: APP_EXCEPTION.raise_exception;
6000: else
6001: set_err_log(retcode);
6002: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
6003: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 6011: APP_EXCEPTION.raise_exception;

6007: FND_FILE.put_line(fnd_file.log, l_buff);
6008: end if;
6009: when others then
6010: if g_call_by_form = true then
6011: APP_EXCEPTION.raise_exception;
6012: else
6013: set_err_log(retcode);
6014: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
6015: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 6465: APP_EXCEPTION.raise_exception;

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
6467: set_err_log(retcode);
6468: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
6469: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 6478: APP_EXCEPTION.raise_exception;

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
6480: set_err_log(retcode);
6481: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
6482: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 6490: APP_EXCEPTION.raise_exception;

6486: FND_FILE.put_line(fnd_file.log, l_buff);
6487: end if;
6488: when others then
6489: if g_call_by_form = true then
6490: APP_EXCEPTION.raise_exception;
6491: else
6492: set_err_log(retcode);
6493: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
6494: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 6777: APP_EXCEPTION.raise_exception;

6773: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
6774: if g_call_by_form = true then
6775: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
6776: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
6777: APP_EXCEPTION.raise_exception;
6778: else
6779: set_err_log(retcode);
6780: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
6781: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 6792: APP_EXCEPTION.raise_exception;

6788: if g_call_by_form = true then
6789: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
6790: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
6791: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
6792: APP_EXCEPTION.raise_exception;
6793: else
6794: set_err_log(retcode);
6795: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
6796: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 6804: APP_EXCEPTION.raise_exception;

6800: FND_FILE.put_line(fnd_file.log, l_buff);
6801: end if;
6802: when others then
6803: if g_call_by_form = true then
6804: APP_EXCEPTION.raise_exception;
6805: else
6806: set_err_log(retcode);
6807: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_REF');
6808: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7108: APP_EXCEPTION.raise_exception;

7104: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
7105: if g_call_by_form = true then
7106: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
7107: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
7108: APP_EXCEPTION.raise_exception;
7109: else
7110: set_err_log(retcode);
7111: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
7112: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7123: APP_EXCEPTION.raise_exception;

7119: if g_call_by_form = true then
7120: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
7121: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
7122: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
7123: APP_EXCEPTION.raise_exception;
7124: else
7125: set_err_log(retcode);
7126: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
7127: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7135: APP_EXCEPTION.raise_exception;

7131: FND_FILE.put_line(fnd_file.log, l_buf);
7132: end if;
7133: when others then
7134: if g_call_by_form = true then
7135: APP_EXCEPTION.raise_exception;
7136: else
7137: set_err_log(retcode);
7138: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
7139: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7292: APP_EXCEPTION.raise_exception;

7288:
7289: EXCEPTION
7290: when others then
7291: if g_call_by_form = true then
7292: APP_EXCEPTION.raise_exception;
7293: else
7294: set_err_log(retcode);
7295: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
7296: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7367: APP_EXCEPTION.raise_exception;

7363: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
7364: if g_call_by_form = true then
7365: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
7366: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
7367: APP_EXCEPTION.raise_exception;
7368: else
7369: set_err_log(retcode);
7370: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
7371: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7382: APP_EXCEPTION.raise_exception;

7378: if g_call_by_form = true then
7379: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
7380: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
7381: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
7382: APP_EXCEPTION.raise_exception;
7383: else
7384: set_err_log(retcode);
7385: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
7386: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7394: APP_EXCEPTION.raise_exception;

7390: FND_FILE.put_line(fnd_file.log, l_buf);
7391: end if;
7392: when others then
7393: if g_call_by_form = true then
7394: APP_EXCEPTION.raise_exception;
7395: else
7396: set_err_log(retcode);
7397: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
7398: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7563: APP_EXCEPTION.raise_exception;

7559: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
7560: if g_call_by_form = true then
7561: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
7562: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
7563: APP_EXCEPTION.raise_exception;
7564: else
7565: set_err_log(retcode);
7566: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
7567: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7578: APP_EXCEPTION.raise_exception;

7574: if g_call_by_form = true then
7575: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
7576: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
7577: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
7578: APP_EXCEPTION.raise_exception;
7579: else
7580: set_err_log(retcode);
7581: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
7582: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7590: APP_EXCEPTION.raise_exception;

7586: FND_FILE.put_line(fnd_file.log, l_buff);
7587: end if;
7588: when others then
7589: if g_call_by_form = true then
7590: APP_EXCEPTION.raise_exception;
7591: else
7592: set_err_log(retcode);
7593: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_REF');
7594: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7719: APP_EXCEPTION.raise_exception;

7715:
7716: EXCEPTION
7717: when others then
7718: if g_call_by_form = true then
7719: APP_EXCEPTION.raise_exception;
7720: else
7721: set_err_log(retcode);
7722: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
7723: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7781: APP_EXCEPTION.raise_exception;

7777:
7778: EXCEPTION
7779: when others then
7780: if g_call_by_form = true then
7781: APP_EXCEPTION.raise_exception;
7782: else
7783: set_err_log(retcode);
7784: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
7785: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7914: APP_EXCEPTION.raise_exception;

7910:
7911: EXCEPTION
7912: when others then
7913: if g_call_by_form = true then
7914: APP_EXCEPTION.raise_exception;
7915: else
7916: set_err_log(retcode);
7917: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
7918: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 8128: APP_EXCEPTION.raise_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;
8129: else
8130: set_err_log(retcode);
8131: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
8132: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 8143: APP_EXCEPTION.raise_exception;

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);
8143: APP_EXCEPTION.raise_exception;
8144: else
8145: set_err_log(retcode);
8146: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
8147: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 8155: APP_EXCEPTION.raise_exception;

8151: FND_FILE.put_line(fnd_file.log, l_buf);
8152: end if;
8153: when others then
8154: if g_call_by_form = true then
8155: APP_EXCEPTION.raise_exception;
8156: else
8157: set_err_log(retcode);
8158: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
8159: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 8538: APP_EXCEPTION.raise_exception;

8534:
8535: EXCEPTION
8536: when others then
8537: if g_call_by_form = true then
8538: APP_EXCEPTION.raise_exception;
8539: else
8540: set_err_log(retcode);
8541: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
8542: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 8613: APP_EXCEPTION.raise_exception;

8609: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
8610: if g_call_by_form = true then
8611: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
8612: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
8613: APP_EXCEPTION.raise_exception;
8614: else
8615: set_err_log(retcode);
8616: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
8617: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 8628: APP_EXCEPTION.raise_exception;

8624: if g_call_by_form = true then
8625: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
8626: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
8627: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
8628: APP_EXCEPTION.raise_exception;
8629: else
8630: set_err_log(retcode);
8631: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
8632: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 8640: APP_EXCEPTION.raise_exception;

8636: FND_FILE.put_line(fnd_file.log, l_buf);
8637: end if;
8638: when others then
8639: if g_call_by_form = true then
8640: APP_EXCEPTION.raise_exception;
8641: else
8642: set_err_log(retcode);
8643: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
8644: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 8759: APP_EXCEPTION.raise_exception;

8755:
8756: EXCEPTION
8757: when others then
8758: if g_call_by_form = true then
8759: APP_EXCEPTION.raise_exception;
8760: else
8761: set_err_log(retcode);
8762: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
8763: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 8823: APP_EXCEPTION.raise_exception;

8819:
8820: EXCEPTION
8821: when others then
8822: if g_call_by_form = true then
8823: APP_EXCEPTION.raise_exception;
8824: else
8825: set_err_log(retcode);
8826: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
8827: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9031: APP_EXCEPTION.raise_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;
9032: else
9033: set_err_log(retcode);
9034: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
9035: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9046: APP_EXCEPTION.raise_exception;

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);
9046: APP_EXCEPTION.raise_exception;
9047: else
9048: set_err_log(retcode);
9049: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
9050: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9058: APP_EXCEPTION.raise_exception;

9054: FND_FILE.put_line(fnd_file.log, l_buf);
9055: end if;
9056: when others then
9057: if g_call_by_form = true then
9058: APP_EXCEPTION.raise_exception;
9059: else
9060: set_err_log(retcode);
9061: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_REF');
9062: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9064: APP_EXCEPTION.raise_exception;

9060: set_err_log(retcode);
9061: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_REF');
9062: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
9063: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
9064: APP_EXCEPTION.raise_exception;
9065: end if;
9066: END xtr_revl_stock_unreal;
9067:
9068: ------------------------------------------------------------------

Line 9114: APP_EXCEPTION.raise_exception;

9110: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
9111: if g_call_by_form = true then
9112: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
9113: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
9114: APP_EXCEPTION.raise_exception;
9115: else
9116: set_err_log(retcode);
9117: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
9118: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9129: APP_EXCEPTION.raise_exception;

9125: if g_call_by_form = true then
9126: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
9127: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
9128: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
9129: APP_EXCEPTION.raise_exception;
9130: else
9131: set_err_log(retcode);
9132: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
9133: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9141: APP_EXCEPTION.raise_exception;

9137: FND_FILE.put_line(fnd_file.log, l_buff);
9138: end if;
9139: when others then
9140: if g_call_by_form = true then
9141: APP_EXCEPTION.raise_exception;
9142: else
9143: set_err_log(retcode);
9144: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_REF');
9145: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9275: APP_EXCEPTION.raise_exception;

9271: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
9272: if g_call_by_form = true then
9273: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
9274: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
9275: APP_EXCEPTION.raise_exception;
9276: else
9277: set_err_log(retcode);
9278: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
9279: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9290: APP_EXCEPTION.raise_exception;

9286: if g_call_by_form = true then
9287: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
9288: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
9289: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
9290: APP_EXCEPTION.raise_exception;
9291: else
9292: set_err_log(retcode);
9293: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
9294: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9302: APP_EXCEPTION.raise_exception;

9298: FND_FILE.put_line(fnd_file.log, l_buf);
9299: end if;
9300: when others then
9301: if g_call_by_form = true then
9302: APP_EXCEPTION.raise_exception;
9303: else
9304: set_err_log(retcode);
9305: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
9306: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9583: APP_EXCEPTION.raise_exception;

9579: rec.trans_no := 1;
9580: EXCEPTION
9581: when others then
9582: if g_call_by_form = true then
9583: APP_EXCEPTION.raise_exception;
9584: else
9585: set_err_log(retcode);
9586: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
9587: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9712: APP_EXCEPTION.raise_exception;

9708:
9709: EXCEPTION
9710: when others then
9711: if g_call_by_form = true then
9712: APP_EXCEPTION.raise_exception;
9713: else
9714: set_err_log(retcode);
9715: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
9716: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 10015: When app_exceptions.RECORD_LOCK_EXCEPTION then

10011: end if;
10012: end if;
10013:
10014: Exception
10015: When app_exceptions.RECORD_LOCK_EXCEPTION then
10016: if CHK_LOCK_DEAL%ISOPEN then
10017: close CHK_LOCK_DEAL;
10018: end if;
10019:

Line 10034: Raise app_exceptions.RECORD_LOCK_EXCEPTION;

10030: end if;
10031: FND_MESSAGE.Set_name('XTR', 'XTR_DEAL_LOCK');
10032: FND_MESSAGE.Set_token('DEAL_NO', rec.deal_no);
10033: FND_MESSAGE.Set_token('DEAL_TYPE', rec.deal_type);
10034: Raise app_exceptions.RECORD_LOCK_EXCEPTION;
10035:
10036: end xtr_revl_unreal_log;
10037:
10038: --------------------------------------------------------------------

Line 10169: When app_exceptions.RECORD_LOCK_EXCEPTION then

10165: Close CHK_LOCK_ROLL;
10166: end if;
10167:
10168: Exception
10169: When app_exceptions.RECORD_LOCK_EXCEPTION then
10170: if CHK_LOCK_DEAL%ISOPEN then
10171: close CHK_LOCK_DEAL;
10172: end if;
10173:

Line 10181: Raise app_exceptions.RECORD_LOCK_EXCEPTION;

10177:
10178: FND_MESSAGE.Set_name('XTR', 'XTR_DEAL_LOCK');
10179: FND_MESSAGE.Set_token('DEAL_NO', rec.deal_no);
10180: FND_MESSAGE.Set_token('DEAL_TYPE', rec.deal_type);
10181: Raise app_exceptions.RECORD_LOCK_EXCEPTION;
10182:
10183: end xtr_revl_real_log;
10184:
10185: ------------------------------------------------------------------------------

Line 10224: APP_EXCEPTION.raise_exception;

10220: EXCEPTION
10221: When e_batch_been_run then
10222: FND_MESSAGE.Set_Name('XTR', 'XTR_BATCH_IN_REVAL');
10223: FND_MESSAGE.Set_Token('BATCH', p_batch_id);
10224: APP_EXCEPTION.raise_exception;
10225:
10226: End;
10227: --------------------------------------------------------
10228: PROCEDURE dump_xtr_mds_rec(