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 1458: APP_EXCEPTION.raise_exception;

1454:
1455: EXCEPTION
1456: when others then
1457: if g_call_by_form = true then
1458: APP_EXCEPTION.raise_exception;
1459: else
1460: set_err_log(retcode);
1461: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
1462: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 1868: APP_EXCEPTION.raise_exception;

1864: if g_call_by_form = true then
1865: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_DEAL_TYPE');
1866: FND_MESSAGE.Set_Token('DEAL_TYPE', rec.deal_type);
1867: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
1868: APP_EXCEPTION.raise_exception;
1869: else
1870: set_err_log(retcode);
1871: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_DEALTYPE');
1872: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 1883: APP_EXCEPTION.raise_exception;

1879: if g_call_by_form = true then
1880: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_TRANS_NUM');
1881: FND_MESSAGE.Set_Token('DEAL_NO', rec.deal_no);
1882: FND_MESSAGE.Set_Token('TRANS_NO', rec.trans_no);
1883: APP_EXCEPTION.raise_exception;
1884: else
1885: set_err_log(retcode);
1886: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_TRANSNUM');
1887: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 1899: APP_EXCEPTION.raise_exception;

1895: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_PRICE_MODEL');
1896: FND_MESSAGE.Set_Token('PRICE_MODEL', rec.pricing_model);
1897: FND_MESSAGE.Set_Token('DEAL_TYPE', rec.deal_type);
1898: FND_MESSAGE.Set_Token('DEAL_NO', rec.deal_no);
1899: APP_EXCEPTION.raise_exception;
1900: else
1901: set_err_log(retcode);
1902: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_PRICEMODEL');
1903: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 1913: APP_EXCEPTION.raise_exception;

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');
1912: FND_MESSAGE.Set_Token('DEAL_NO', rec.deal_no);
1913: APP_EXCEPTION.raise_exception;
1914: else
1915: set_err_log(retcode);
1916: FND_MESSAGE.SET_NAME('XTR', 'XTR_SPOTDATE_REVALDATE');
1917: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 1927: APP_EXCEPTION.raise_exception;

1923: when e_invalid_code then
1924: if g_call_by_form = true then
1925: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CODE');
1926: FND_MESSAGE.Set_Token('DEAL_NO', rec.deal_no);
1927: APP_EXCEPTION.raise_exception;
1928: else
1929: set_err_log(retcode);
1930: FND_MESSAGE.SET_NAME('XTR', 'XTR_INTERNAL_ERR');
1931: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 1941: APP_EXCEPTION.raise_exception;

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');
1940: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
1941: APP_EXCEPTION.raise_exception;
1942: else
1943: set_err_log(retcode);
1944: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
1945: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 1956: APP_EXCEPTION.raise_exception;

1952: if g_call_by_form = true then
1953: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
1954: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
1955: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
1956: APP_EXCEPTION.raise_exception;
1957: else
1958: set_err_log(retcode);
1959: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
1960: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 1968: APP_EXCEPTION.raise_exception;

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;
1969: else
1970: set_err_log(retcode);
1971: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
1972: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2192: APP_EXCEPTION.raise_exception;

2188: if g_call_by_form = true then
2189: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_DEAL_TYPE');
2190: FND_MESSAGE.set_token('DEAL_TYPE', rec.deal_type);
2191: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
2192: APP_EXCEPTION.raise_exception;
2193: else
2194: set_err_log(retcode);
2195: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_DEALTYPE');
2196: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2207: APP_EXCEPTION.raise_exception;

2203: if g_call_by_form = true then
2204: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_DEAL_SUBTYPE');
2205: FND_MESSAGE.set_token('DEAL_TYPE', rec.deal_type);
2206: FND_MESSAGE.set_token('DEAL_SUBTYPE', rec.deal_subtype);
2207: APP_EXCEPTION.raise_exception;
2208: else
2209: set_err_log(retcode);
2210: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_DEALSUBTYPE');
2211: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2220: APP_EXCEPTION.raise_exception;

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;
2221: else
2222: set_err_log(retcode);
2223: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
2224: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2359: APP_EXCEPTION.raise_exception;

2355: when GL_CURRENCY_API.no_rate then
2356: if g_call_by_form = true then
2357: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
2358: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
2359: APP_EXCEPTION.raise_exception;
2360: else
2361: set_err_log(retcode);
2362: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
2363: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2374: APP_EXCEPTION.raise_exception;

2370: if g_call_by_form = true then
2371: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
2372: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
2373: FND_MESSAGE.set_token('CURRENCY', rec.currencya);
2374: APP_EXCEPTION.raise_exception;
2375: else
2376: set_err_log(retcode);
2377: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
2378: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2386: APP_EXCEPTION.raise_exception;

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;
2387: else
2388: set_err_log(retcode);
2389: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
2390: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2493: APP_EXCEPTION.raise_exception;

2489:
2490: EXCEPTION
2491: when others then
2492: if g_call_by_form = true then
2493: APP_EXCEPTION.raise_exception;
2494: else
2495: set_err_log(retcode);
2496: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
2497: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2794: APP_EXCEPTION.raise_exception;

2790: when GL_CURRENCY_API.no_rate then
2791: if g_call_by_form = true then
2792: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
2793: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
2794: APP_EXCEPTION.raise_exception;
2795: else
2796: set_err_log(retcode);
2797: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
2798: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2809: APP_EXCEPTION.raise_exception;

2805: if g_call_by_form = true then
2806: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
2807: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
2808: FND_MESSAGE.set_token('CURRENCY', rec.currencya);
2809: APP_EXCEPTION.raise_exception;
2810: else
2811: set_err_log(retcode);
2812: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
2813: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 2821: APP_EXCEPTION.raise_exception;

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;
2822: else
2823: set_err_log(retcode);
2824: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
2825: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 3257: APP_EXCEPTION.raise_exception;

3253: when GL_CURRENCY_API.no_rate then
3254: if g_call_by_form = true then
3255: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
3256: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
3257: APP_EXCEPTION.raise_exception;
3258: else
3259: set_err_log(retcode);
3260: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
3261: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 3272: APP_EXCEPTION.raise_exception;

3268: if g_call_by_form = true then
3269: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
3270: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
3271: FND_MESSAGE.set_token('CURRENCY', rec.currencya);
3272: APP_EXCEPTION.raise_exception;
3273: else
3274: set_err_log(retcode);
3275: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
3276: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 3284: APP_EXCEPTION.raise_exception;

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;
3285: else
3286: set_err_log(retcode);
3287: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
3288: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 3729: APP_EXCEPTION.raise_exception;

3725: when GL_CURRENCY_API.no_rate then
3726: if g_call_by_form = true then
3727: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
3728: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
3729: APP_EXCEPTION.raise_exception;
3730: else
3731: set_err_log(retcode);
3732: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
3733: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 3744: APP_EXCEPTION.raise_exception;

3740: if g_call_by_form = true then
3741: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
3742: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
3743: FND_MESSAGE.set_token('CURRENCY', rec.currencya);
3744: APP_EXCEPTION.raise_exception;
3745: else
3746: set_err_log(retcode);
3747: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
3748: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 3756: APP_EXCEPTION.raise_exception;

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;
3757: else
3758: set_err_log(retcode);
3759: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
3760: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4046: APP_EXCEPTION.raise_exception;

4042: when GL_CURRENCY_API.no_rate then
4043: if g_call_by_form = true then
4044: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
4045: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
4046: APP_EXCEPTION.raise_exception;
4047: else
4048: set_err_log(retcode);
4049: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
4050: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4061: APP_EXCEPTION.raise_exception;

4057: if g_call_by_form = true then
4058: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
4059: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
4060: FND_MESSAGE.set_token('CURRENCY', rec.currencya);
4061: APP_EXCEPTION.raise_exception;
4062: else
4063: set_err_log(retcode);
4064: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
4065: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4073: APP_EXCEPTION.raise_exception;

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;
4074: else
4075: set_err_log(retcode);
4076: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
4077: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4171: APP_EXCEPTION.raise_exception;

4167:
4168: EXCEPTION
4169: when others then
4170: if g_call_by_form = true then
4171: APP_EXCEPTION.raise_exception;
4172: else
4173: set_err_log(retcode);
4174: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
4175: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4345: APP_EXCEPTION.raise_exception;

4341:
4342: EXCEPTION
4343: when others then
4344: if g_call_by_form = true then
4345: APP_EXCEPTION.raise_exception;
4346: else
4347: set_err_log(retcode);
4348: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
4349: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4535: APP_EXCEPTION.raise_exception;

4531: Null; -- Not Applicable for these Deal Types;
4532: End If;
4533: EXCEPTION
4534: WHEN others THEN
4535: APP_EXCEPTION.raise_exception;
4536: END xtr_ins_init_fv;
4537:
4538: --------------------------------------------------------
4539: /********************************************************/

Line 4715: APP_EXCEPTION.raise_exception;

4711: EXCEPTION
4712: when GL_CURRENCY_API.no_rate then
4713: if g_call_by_form = true then
4714: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
4715: APP_EXCEPTION.raise_exception;
4716: else
4717: set_err_log(retcode);
4718: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
4719: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4728: APP_EXCEPTION.raise_exception;

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');
4728: APP_EXCEPTION.raise_exception;
4729: else
4730: set_err_log(retcode);
4731: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
4732: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4740: APP_EXCEPTION.raise_exception;

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;
4741: else
4742: set_err_log(retcode);
4743: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
4744: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4901: APP_EXCEPTION.raise_exception;

4897: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
4898: if g_call_by_form = true then
4899: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
4900: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
4901: APP_EXCEPTION.raise_exception;
4902: else
4903: set_err_log(retcode);
4904: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
4905: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4916: APP_EXCEPTION.raise_exception;

4912: if g_call_by_form = true then
4913: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
4914: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
4915: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
4916: APP_EXCEPTION.raise_exception;
4917: else
4918: set_err_log(retcode);
4919: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
4920: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 4928: APP_EXCEPTION.raise_exception;

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;
4929: else
4930: set_err_log(retcode);
4931: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
4932: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5083: APP_EXCEPTION.raise_exception;

5079: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
5080: if g_call_by_form = true then
5081: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
5082: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5083: APP_EXCEPTION.raise_exception;
5084: else
5085: set_err_log(retcode);
5086: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
5087: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5098: APP_EXCEPTION.raise_exception;

5094: if g_call_by_form = true then
5095: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
5096: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
5097: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5098: APP_EXCEPTION.raise_exception;
5099: else
5100: set_err_log(retcode);
5101: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
5102: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5110: APP_EXCEPTION.raise_exception;

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;
5111: else
5112: set_err_log(retcode);
5113: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
5114: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5416: APP_EXCEPTION.raise_exception;

5412: when GL_CURRENCY_API.no_rate then
5413: if g_call_by_form = true then
5414: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
5415: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5416: APP_EXCEPTION.raise_exception;
5417: else
5418: set_err_log(retcode);
5419: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
5420: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5431: APP_EXCEPTION.raise_exception;

5427: if g_call_by_form = true then
5428: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
5429: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5430: FND_MESSAGE.set_token('CURRENCY', rec.currencya);
5431: APP_EXCEPTION.raise_exception;
5432: else
5433: set_err_log(retcode);
5434: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
5435: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5445: APP_EXCEPTION.raise_exception;

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');
5444: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5445: APP_EXCEPTION.raise_exception;
5446: else
5447: set_err_log(retcode);
5448: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
5449: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5460: APP_EXCEPTION.raise_exception;

5456: if g_call_by_form = true then
5457: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
5458: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
5459: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5460: APP_EXCEPTION.raise_exception;
5461: else
5462: set_err_log(retcode);
5463: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
5464: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5472: APP_EXCEPTION.raise_exception;

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;
5473: else
5474: set_err_log(retcode);
5475: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
5476: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5665: APP_EXCEPTION.raise_exception;

5661: when GL_CURRENCY_API.no_rate then
5662: if g_call_by_form = true then
5663: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
5664: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5665: APP_EXCEPTION.raise_exception;
5666: else
5667: set_err_log(retcode);
5668: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
5669: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5680: APP_EXCEPTION.raise_exception;

5676: if g_call_by_form = true then
5677: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
5678: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5679: FND_MESSAGE.set_token('CURRENCY', rec.currencya);
5680: APP_EXCEPTION.raise_exception;
5681: else
5682: set_err_log(retcode);
5683: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
5684: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5692: APP_EXCEPTION.raise_exception;

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;
5693: else
5694: set_err_log(retcode);
5695: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
5696: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5938: APP_EXCEPTION.raise_exception;

5934: when GL_CURRENCY_API.no_rate then
5935: if g_call_by_form = true then
5936: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
5937: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5938: APP_EXCEPTION.raise_exception;
5939: else
5940: set_err_log(retcode);
5941: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
5942: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5953: APP_EXCEPTION.raise_exception;

5949: if g_call_by_form = true then
5950: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
5951: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5952: FND_MESSAGE.set_token('CURRENCY', rec.currencya);
5953: APP_EXCEPTION.raise_exception;
5954: else
5955: set_err_log(retcode);
5956: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
5957: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5967: APP_EXCEPTION.raise_exception;

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');
5966: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5967: APP_EXCEPTION.raise_exception;
5968: else
5969: set_err_log(retcode);
5970: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
5971: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5982: APP_EXCEPTION.raise_exception;

5978: if g_call_by_form = true then
5979: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
5980: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
5981: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
5982: APP_EXCEPTION.raise_exception;
5983: else
5984: set_err_log(retcode);
5985: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
5986: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 5994: APP_EXCEPTION.raise_exception;

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;
5995: else
5996: set_err_log(retcode);
5997: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
5998: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 6446: APP_EXCEPTION.raise_exception;

6442: EXCEPTION
6443: when GL_CURRENCY_API.no_rate then
6444: if g_call_by_form = true then
6445: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
6446: APP_EXCEPTION.raise_exception;
6447: else
6448: set_err_log(retcode);
6449: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
6450: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 6459: APP_EXCEPTION.raise_exception;

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');
6459: APP_EXCEPTION.raise_exception;
6460: else
6461: set_err_log(retcode);
6462: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
6463: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 6471: APP_EXCEPTION.raise_exception;

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;
6472: else
6473: set_err_log(retcode);
6474: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
6475: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 6758: APP_EXCEPTION.raise_exception;

6754: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
6755: if g_call_by_form = true then
6756: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
6757: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
6758: APP_EXCEPTION.raise_exception;
6759: else
6760: set_err_log(retcode);
6761: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
6762: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 6773: APP_EXCEPTION.raise_exception;

6769: if g_call_by_form = true then
6770: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
6771: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
6772: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
6773: APP_EXCEPTION.raise_exception;
6774: else
6775: set_err_log(retcode);
6776: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
6777: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 6785: APP_EXCEPTION.raise_exception;

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;
6786: else
6787: set_err_log(retcode);
6788: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_REF');
6789: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7089: APP_EXCEPTION.raise_exception;

7085: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
7086: if g_call_by_form = true then
7087: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
7088: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
7089: APP_EXCEPTION.raise_exception;
7090: else
7091: set_err_log(retcode);
7092: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
7093: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7104: APP_EXCEPTION.raise_exception;

7100: if g_call_by_form = true then
7101: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
7102: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
7103: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
7104: APP_EXCEPTION.raise_exception;
7105: else
7106: set_err_log(retcode);
7107: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
7108: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7116: APP_EXCEPTION.raise_exception;

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;
7117: else
7118: set_err_log(retcode);
7119: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
7120: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7273: APP_EXCEPTION.raise_exception;

7269:
7270: EXCEPTION
7271: when others then
7272: if g_call_by_form = true then
7273: APP_EXCEPTION.raise_exception;
7274: else
7275: set_err_log(retcode);
7276: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
7277: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7348: APP_EXCEPTION.raise_exception;

7344: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
7345: if g_call_by_form = true then
7346: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
7347: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
7348: APP_EXCEPTION.raise_exception;
7349: else
7350: set_err_log(retcode);
7351: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
7352: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7363: APP_EXCEPTION.raise_exception;

7359: if g_call_by_form = true then
7360: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
7361: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
7362: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
7363: APP_EXCEPTION.raise_exception;
7364: else
7365: set_err_log(retcode);
7366: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
7367: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7375: APP_EXCEPTION.raise_exception;

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;
7376: else
7377: set_err_log(retcode);
7378: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
7379: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7544: APP_EXCEPTION.raise_exception;

7540: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
7541: if g_call_by_form = true then
7542: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
7543: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
7544: APP_EXCEPTION.raise_exception;
7545: else
7546: set_err_log(retcode);
7547: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
7548: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7559: APP_EXCEPTION.raise_exception;

7555: if g_call_by_form = true then
7556: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
7557: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
7558: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
7559: APP_EXCEPTION.raise_exception;
7560: else
7561: set_err_log(retcode);
7562: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
7563: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7571: APP_EXCEPTION.raise_exception;

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;
7572: else
7573: set_err_log(retcode);
7574: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_REF');
7575: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7700: APP_EXCEPTION.raise_exception;

7696:
7697: EXCEPTION
7698: when others then
7699: if g_call_by_form = true then
7700: APP_EXCEPTION.raise_exception;
7701: else
7702: set_err_log(retcode);
7703: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
7704: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7762: APP_EXCEPTION.raise_exception;

7758:
7759: EXCEPTION
7760: when others then
7761: if g_call_by_form = true then
7762: APP_EXCEPTION.raise_exception;
7763: else
7764: set_err_log(retcode);
7765: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
7766: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 7895: APP_EXCEPTION.raise_exception;

7891:
7892: EXCEPTION
7893: when others then
7894: if g_call_by_form = true then
7895: APP_EXCEPTION.raise_exception;
7896: else
7897: set_err_log(retcode);
7898: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
7899: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 8109: APP_EXCEPTION.raise_exception;

8105: when GL_CURRENCY_API.no_rate then
8106: if g_call_by_form = true then
8107: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
8108: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
8109: APP_EXCEPTION.raise_exception;
8110: else
8111: set_err_log(retcode);
8112: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
8113: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 8124: APP_EXCEPTION.raise_exception;

8120: if g_call_by_form = true then
8121: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
8122: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
8123: FND_MESSAGE.set_token('CURRENCY', rec.currencya);
8124: APP_EXCEPTION.raise_exception;
8125: else
8126: set_err_log(retcode);
8127: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
8128: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 8136: APP_EXCEPTION.raise_exception;

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;
8137: else
8138: set_err_log(retcode);
8139: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
8140: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 8519: APP_EXCEPTION.raise_exception;

8515:
8516: EXCEPTION
8517: when others then
8518: if g_call_by_form = true then
8519: APP_EXCEPTION.raise_exception;
8520: else
8521: set_err_log(retcode);
8522: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
8523: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 8594: APP_EXCEPTION.raise_exception;

8590: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
8591: if g_call_by_form = true then
8592: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
8593: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
8594: APP_EXCEPTION.raise_exception;
8595: else
8596: set_err_log(retcode);
8597: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
8598: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 8609: APP_EXCEPTION.raise_exception;

8605: if g_call_by_form = true then
8606: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
8607: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
8608: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
8609: APP_EXCEPTION.raise_exception;
8610: else
8611: set_err_log(retcode);
8612: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
8613: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 8621: APP_EXCEPTION.raise_exception;

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;
8622: else
8623: set_err_log(retcode);
8624: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
8625: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 8740: APP_EXCEPTION.raise_exception;

8736:
8737: EXCEPTION
8738: when others then
8739: if g_call_by_form = true then
8740: APP_EXCEPTION.raise_exception;
8741: else
8742: set_err_log(retcode);
8743: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
8744: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 8804: APP_EXCEPTION.raise_exception;

8800:
8801: EXCEPTION
8802: when others then
8803: if g_call_by_form = true then
8804: APP_EXCEPTION.raise_exception;
8805: else
8806: set_err_log(retcode);
8807: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
8808: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9012: APP_EXCEPTION.raise_exception;

9008: when GL_CURRENCY_API.no_rate then
9009: if g_call_by_form = true then
9010: FND_MESSAGE.set_name('XTR', 'XTR_NO_GL_RATE');
9011: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
9012: APP_EXCEPTION.raise_exception;
9013: else
9014: set_err_log(retcode);
9015: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_CURRENCY_GL');
9016: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9027: APP_EXCEPTION.raise_exception;

9023: if g_call_by_form = true then
9024: FND_MESSAGE.set_name('XTR', 'XTR_INVALID_CURRENCY');
9025: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
9026: FND_MESSAGE.set_token('CURRENCY', rec.currencya);
9027: APP_EXCEPTION.raise_exception;
9028: else
9029: set_err_log(retcode);
9030: FND_MESSAGE.SET_NAME('XTR', 'XTR_INVALID_CURRENCY_TYPE');
9031: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9039: APP_EXCEPTION.raise_exception;

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;
9040: else
9041: set_err_log(retcode);
9042: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_REF');
9043: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9045: APP_EXCEPTION.raise_exception;

9041: set_err_log(retcode);
9042: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_REF');
9043: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);
9044: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', rec.deal_type);
9045: APP_EXCEPTION.raise_exception;
9046: end if;
9047: END xtr_revl_stock_unreal;
9048:
9049: ------------------------------------------------------------------

Line 9095: APP_EXCEPTION.raise_exception;

9091: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
9092: if g_call_by_form = true then
9093: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
9094: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
9095: APP_EXCEPTION.raise_exception;
9096: else
9097: set_err_log(retcode);
9098: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
9099: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9110: APP_EXCEPTION.raise_exception;

9106: if g_call_by_form = true then
9107: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
9108: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
9109: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
9110: APP_EXCEPTION.raise_exception;
9111: else
9112: set_err_log(retcode);
9113: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
9114: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9122: APP_EXCEPTION.raise_exception;

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;
9123: else
9124: set_err_log(retcode);
9125: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_RATE_REF');
9126: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9256: APP_EXCEPTION.raise_exception;

9252: when XTR_MARKET_DATA_P.e_mdcs_no_data_found then
9253: if g_call_by_form = true then
9254: FND_MESSAGE.set_name('XTR', 'XTR_NO_MARKET');
9255: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
9256: APP_EXCEPTION.raise_exception;
9257: else
9258: set_err_log(retcode);
9259: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_MARKETDATASET');
9260: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9271: APP_EXCEPTION.raise_exception;

9267: if g_call_by_form = true then
9268: FND_MESSAGE.set_name('XTR', 'XTR_NO_CURVE');
9269: FND_MESSAGE.set_token('MARKET', rec.market_data_set);
9270: FND_MESSAGE.set_token('DEAL_NO', rec.deal_no);
9271: APP_EXCEPTION.raise_exception;
9272: else
9273: set_err_log(retcode);
9274: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_CURVEMARKET');
9275: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9283: APP_EXCEPTION.raise_exception;

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;
9284: else
9285: set_err_log(retcode);
9286: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
9287: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9564: APP_EXCEPTION.raise_exception;

9560: rec.trans_no := 1;
9561: EXCEPTION
9562: when others then
9563: if g_call_by_form = true then
9564: APP_EXCEPTION.raise_exception;
9565: else
9566: set_err_log(retcode);
9567: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
9568: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9693: APP_EXCEPTION.raise_exception;

9689:
9690: EXCEPTION
9691: when others then
9692: if g_call_by_form = true then
9693: APP_EXCEPTION.raise_exception;
9694: else
9695: set_err_log(retcode);
9696: FND_MESSAGE.SET_NAME('XTR', 'XTR_SQL_FAILURE');
9697: FND_MESSAGE.SET_TOKEN('DEAL_NO', rec.deal_no);

Line 9996: When app_exceptions.RECORD_LOCK_EXCEPTION then

9992: end if;
9993: end if;
9994:
9995: Exception
9996: When app_exceptions.RECORD_LOCK_EXCEPTION then
9997: if CHK_LOCK_DEAL%ISOPEN then
9998: close CHK_LOCK_DEAL;
9999: end if;
10000:

Line 10015: Raise app_exceptions.RECORD_LOCK_EXCEPTION;

10011: end if;
10012: FND_MESSAGE.Set_name('XTR', 'XTR_DEAL_LOCK');
10013: FND_MESSAGE.Set_token('DEAL_NO', rec.deal_no);
10014: FND_MESSAGE.Set_token('DEAL_TYPE', rec.deal_type);
10015: Raise app_exceptions.RECORD_LOCK_EXCEPTION;
10016:
10017: end xtr_revl_unreal_log;
10018:
10019: --------------------------------------------------------------------

Line 10150: When app_exceptions.RECORD_LOCK_EXCEPTION then

10146: Close CHK_LOCK_ROLL;
10147: end if;
10148:
10149: Exception
10150: When app_exceptions.RECORD_LOCK_EXCEPTION then
10151: if CHK_LOCK_DEAL%ISOPEN then
10152: close CHK_LOCK_DEAL;
10153: end if;
10154:

Line 10162: Raise app_exceptions.RECORD_LOCK_EXCEPTION;

10158:
10159: FND_MESSAGE.Set_name('XTR', 'XTR_DEAL_LOCK');
10160: FND_MESSAGE.Set_token('DEAL_NO', rec.deal_no);
10161: FND_MESSAGE.Set_token('DEAL_TYPE', rec.deal_type);
10162: Raise app_exceptions.RECORD_LOCK_EXCEPTION;
10163:
10164: end xtr_revl_real_log;
10165:
10166: ------------------------------------------------------------------------------

Line 10205: APP_EXCEPTION.raise_exception;

10201: EXCEPTION
10202: When e_batch_been_run then
10203: FND_MESSAGE.Set_Name('XTR', 'XTR_BATCH_IN_REVAL');
10204: FND_MESSAGE.Set_Token('BATCH', p_batch_id);
10205: APP_EXCEPTION.raise_exception;
10206:
10207: End;
10208: --------------------------------------------------------
10209: PROCEDURE dump_xtr_mds_rec(