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_FX_TRANSFERS_PKG dependencies on XTR_IMPORT_DEAL_DATA

Line 55: XTR_IMPORT_DEAL_DATA.CHECK_USER_AUTH(ARec_Interface.external_deal_id,

51:
52: ----------------------------------------------------------------------------------------------------
53: --* The following code checks if user has permissions to transfer the deal (company authorization)
54: ----------------------------------------------------------------------------------------------------
55: XTR_IMPORT_DEAL_DATA.CHECK_USER_AUTH(ARec_Interface.external_deal_id,
56: ARec_Interface.deal_type,
57: ARec_Interface.company_code,
58: user_error);
59:

Line 106: xtr_import_deal_data.log_interface_errors(ARec_Interface.external_deal_id,ARec_Interface.deal_type,

102: g_currency_first,
103: g_currency_second );
104:
105: If Nvl(ARec_Interface.override_limit,'N') = 'N' and v_limit_log_return <> 0 then
106: xtr_import_deal_data.log_interface_errors(ARec_Interface.external_deal_id,ARec_Interface.deal_type,
107: 'OverrideLimit','XTR_LIMIT_EXCEEDED');
108: limit_error := TRUE;
109: else
110: limit_error := FALSE;

Line 187: xtr_import_deal_data.log_interface_errors( p_external_deal_id ,p_deal_type,'CompanyCode','XTR_INV_COMP_CODE');

183:
184: EXCEPTION
185: WHEN NO_DATA_FOUND THEN
186: error := TRUE;
187: xtr_import_deal_data.log_interface_errors( p_external_deal_id ,p_deal_type,'CompanyCode','XTR_INV_COMP_CODE');
188: END;
189:
190: END CHECK_USER_AUTH;
191: */

Line 205: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,

201:
202: error := FALSE; /* Defaulting it to No errors */
203:
204: if ARec_Interface.dealer_code is null then
205: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,
206: 'DealerCode','XTR_MANDATORY');
207: error := TRUE;
208: end if;
209:

Line 211: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,

207: error := TRUE;
208: end if;
209:
210: if ARec_Interface.date_a is null then
211: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,
212: 'DateA','XTR_MANDATORY');
213: error := TRUE;
214: end if;
215:

Line 217: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,

213: error := TRUE;
214: end if;
215:
216: if ARec_Interface.cparty_code is null then
217: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,
218: 'CpartyCode','XTR_MANDATORY');
219: error := TRUE;
220: end if;
221:

Line 223: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,

219: error := TRUE;
220: end if;
221:
222: if ARec_Interface.deal_subtype is null then
223: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,
224: 'DealSubtype','XTR_MANDATORY');
225: error := TRUE;
226: end if;
227:

Line 229: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,

225: error := TRUE;
226: end if;
227:
228: if ARec_Interface.product_type is null then
229: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,
230: 'ProductType','XTR_MANDATORY');
231: error := TRUE;
232: end if;
233:

Line 235: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,

231: error := TRUE;
232: end if;
233:
234: if ARec_Interface.date_b is null then
235: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,
236: 'DateB','XTR_MANDATORY');
237: error := TRUE;
238: end if;
239:

Line 241: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,

237: error := TRUE;
238: end if;
239:
240: if ARec_Interface.currency_a is null then
241: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,
242: 'CurrencyA','XTR_MANDATORY');
243: error := TRUE;
244: end if;
245:

Line 247: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,

243: error := TRUE;
244: end if;
245:
246: if ARec_Interface.currency_b is null then
247: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,
248: 'CurrencyB','XTR_MANDATORY');
249: error := TRUE;
250: end if;
251:

Line 253: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,

249: error := TRUE;
250: end if;
251:
252: if ARec_Interface.amount_a is null then
253: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,
254: 'AmountA','XTR_MANDATORY');
255: error := TRUE;
256: end if;
257:

Line 259: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,

255: error := TRUE;
256: end if;
257:
258: if ARec_Interface.amount_b is null then
259: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,
260: 'AmountB','XTR_MANDATORY');
261: error := TRUE;
262: end if;
263:

Line 265: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,

261: error := TRUE;
262: end if;
263:
264: if ARec_Interface.rate_a is null then
265: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,
266: 'RateA','XTR_MANDATORY');
267: error := TRUE;
268: end if;
269:

Line 271: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,

267: error := TRUE;
268: end if;
269:
270: if ARec_Interface.rate_b is null then
271: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,
272: 'RateB','XTR_MANDATORY');
273: error := TRUE;
274: end if;
275:

Line 277: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,

273: error := TRUE;
274: end if;
275:
276: if ARec_Interface.account_no_a is null then
277: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,
278: 'AccountNoA','XTR_MANDATORY');
279: error := TRUE;
280: end if;
281:

Line 283: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,

279: error := TRUE;
280: end if;
281:
282: if ARec_Interface.account_no_b is null then
283: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,
284: 'AccountNoB','XTR_MANDATORY');
285: error := TRUE;
286: end if;
287:

Line 289: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,

285: error := TRUE;
286: end if;
287:
288: if ARec_Interface.pricing_model is null then
289: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,
290: 'PricingModel','XTR_MANDATORY');
291: error := TRUE;
292: end if;
293:

Line 296: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,

292: end if;
293:
294: if ARec_Interface.brokerage_code is null and
295: (ARec_Interface.rate_c is not null or ARec_Interface.amount_c is not null) then
296: xtr_import_deal_data.log_interface_errors(ARec_Interface.External_Deal_Id,ARec_Interface.Deal_Type,
297: 'BrokerageCode','XTR_MANDATORY_BROKERAGE');
298: error := TRUE;
299: end if;
300:

Line 356: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

352:
353: /* This procedure will include all the column validations */
354:
355: if not ( val_cparty_code(ARec_Interface.company_code, ARec_Interface.cparty_code)) then
356: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
357: ARec_Interface.Deal_Type,
358: 'CpartyCode',
359: 'XTR_INV_CPARTY_CODE');
360: l_error := l_error +1;

Line 369: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

365:
366: if not ( val_portfolio_code(ARec_Interface.company_code,
367: ARec_Interface.cparty_code,
368: ARec_Interface.portfolio_code)) then
369: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
370: ARec_Interface.Deal_Type,
371: 'PortfolioCode',
372: 'XTR_INV_PORT_CODE');
373: l_error := l_error +1;

Line 379: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

375:
376: if not ( val_limit_code(ARec_Interface.company_code,
377: ARec_Interface.cparty_code,
378: ARec_Interface.limit_code)) then
379: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
380: ARec_Interface.Deal_Type,
381: 'LimitCode',
382: 'XTR_INV_LIMIT_CODE');
383: l_error := l_error +1;

Line 388: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

384: end if;
385: end if;
386:
387: if not (val_currencies(ARec_Interface.currency_a)) then
388: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
389: ARec_Interface.Deal_Type,
390: 'CurrencyA',
391: 'XTR_INV_BUY_CURR');
392: l_error := l_error +1;

Line 397: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

393: l_err_currency_a := TRUE;
394: end if;
395:
396: if not (val_currencies(ARec_Interface.currency_b)) then
397: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
398: ARec_Interface.Deal_Type,
399: 'CurrencyB',
400: 'XTR_INV_SELL_CURR');
401: l_error := l_error +1;

Line 406: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

402: l_err_currency_b := TRUE;
403: end if;
404:
405: if not ( val_deal_subtype(ARec_Interface.deal_subtype,G_Fx_Deal_Type)) then
406: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
407: ARec_Interface.Deal_Type,
408: 'DealSubtype',
409: 'XTR_INV_DEAL_SUBTYPE');
410: l_error := l_error +1;

Line 416: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

412: end if;
413:
414: if l_err_deal_subtype <> TRUE then
415: if not ( val_product_type(ARec_Interface.product_type,ARec_Interface.deal_subtype,G_Fx_Deal_type)) then
416: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
417: ARec_Interface.Deal_Type,
418: 'ProductType',
419: 'XTR_INV_PRODUCT_TYPE');
420: l_error := l_error +1;

Line 426: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

422: end if;
423:
424: if l_err_currency_a <> TRUE and l_err_currency_b <> TRUE then
425: if not (val_buy_sell_curr_comb(ARec_Interface.currency_a, ARec_Interface.currency_b)) then
426: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
427: ARec_Interface.Deal_Type,
428: 'CurrencyA',
429: 'XTR_INV_BUY_SELL_CURR_COMB');
430:

Line 431: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

427: ARec_Interface.Deal_Type,
428: 'CurrencyA',
429: 'XTR_INV_BUY_SELL_CURR_COMB');
430:
431: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
432: ARec_Interface.Deal_Type,
433: 'CurrencyB',
434: 'XTR_INV_BUY_SELL_CURR_COMB');
435: l_error := l_error +1;

Line 440: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

436: end if;
437: end if;
438:
439: if not ( val_brokerage_code(ARec_Interface.brokerage_code)) then
440: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
441: ARec_Interface.Deal_Type,
442: 'BrokerageCode',
443: 'XTR_INV_BROKERAGE_CODE');
444: l_error := l_error +1;

Line 452: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

448: if l_err_currency_a <> TRUE then
449: if not ( val_comp_acct_no(ARec_Interface.company_code,
450: ARec_Interface.currency_a,
451: ARec_Interface.account_no_a)) then
452: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
453: ARec_Interface.Deal_Type,
454: 'AccountNoA',
455: 'XTR_INV_BUY_ACCT_NO');
456: l_error := l_error +1;

Line 464: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

460: if l_err_currency_b <> TRUE then
461: if not ( val_comp_acct_no(ARec_Interface.company_code,
462: ARec_Interface.currency_b,
463: ARec_Interface.account_no_b)) then
464: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
465: ARec_Interface.Deal_Type,
466: 'AccountNoB',
467: 'XTR_INV_SELL_ACCT_NO');
468: l_error := l_error +1;

Line 477: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

473: if not ( val_cparty_ref(ARec_Interface.cparty_account_no,
474: ARec_Interface.cparty_ref,
475: ARec_Interface.cparty_code,
476: ARec_Interface.currency_b)) then
477: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
478: ARec_Interface.Deal_Type,
479: 'CpartyAccountNo', -- CE BANK MIGRATION
480: 'XTR_INV_CPARTY_REF');
481: l_error := l_error +1;

Line 486: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

482: end if;
483: end if;
484:
485: if not ( val_dealer_code(ARec_Interface.dealer_code)) then
486: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
487: ARec_Interface.Deal_Type,
488: 'DealerCode',
489: 'XTR_INV_DEALER_CODE');
490: l_error := l_error +1;

Line 495: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

491: end if;
492:
493: if ARec_Interface.dual_authorization_by is not null and
494: not ( val_dealer_code(ARec_Interface.dual_authorization_by)) then
495: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
496: ARec_Interface.Deal_Type,
497: 'DualAuthorizationBy',
498: 'XTR_INV_DUAL_AUTH_BY');
499: l_error := l_error +1;

Line 503: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

499: l_error := l_error +1;
500: end if;
501:
502: if not ( val_deal_date(ARec_Interface.date_a)) then
503: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
504: ARec_Interface.Deal_Type,
505: 'DateA',
506: 'XTR_INV_DEAL_DATE');
507: l_error := l_error +1;

Line 512: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

508: l_err_deal_date := TRUE;
509: end if;
510:
511: if not ( val_client_code(ARec_Interface.client_code)) then
512: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
513: ARec_Interface.Deal_Type,
514: 'ClientCode',
515: 'XTR_INV_CLIENT_CODE');
516: l_error := l_error +1;

Line 522: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

518:
519: if l_err_deal_date <> TRUE then
520: if not ( val_value_date(ARec_Interface.date_a,
521: ARec_Interface.date_b)) then
522: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
523: ARec_Interface.Deal_Type,
524: 'DateB',
525: 'XTR_INV_VALUE_DATE');
526: l_error := l_error +1;

Line 531: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

527: end if;
528: end if;
529:
530: if not ( val_deal_linking_code(ARec_Interface.deal_linking_code)) then
531: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
532: ARec_Interface.Deal_Type,
533: 'DealLinkingCode',
534: 'XTR_INV_LINKING_CODE');
535: l_error := l_error +1;

Line 540: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

536: end if;
537:
538:
539: if not ( val_pricing_model(ARec_Interface.pricing_model)) then
540: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
541: ARec_Interface.Deal_Type,
542: 'PricingModel',
543: 'XTR_INV_PRICING_MODEL');
544: l_error := l_error +1;

Line 548: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

544: l_error := l_error +1;
545: end if;
546:
547: if not ( val_market_data_set(ARec_Interface.market_data_set)) then
548: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
549: ARec_Interface.Deal_Type,
550: 'MarketDataSet',
551: 'XTR_INV_MKT_DATA_SET');
552: l_error := l_error +1;

Line 562: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

558: G_Fx_Deal_Type,
559: ARec_Interface.currency_a,
560: ARec_Interface.currency_b,
561: ARec_Interface.brokerage_code)) then
562: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
563: ARec_Interface.Deal_Type,
564: 'BrokerageCurrency',
565: 'XTR_INV_BROK_CURRENCY');
566: l_error := l_error +1;

Line 575: if not ( xtr_import_deal_data.val_desc_flex(ARec_Interface,'XTR_DEALS_DESC_FLEX',l_err_segment)) then

571: /*-------------------------------------------------------------------------------*/
572: /* Flexfields Validation */
573: /*-------------------------------------------------------------------------------*/
574:
575: if not ( xtr_import_deal_data.val_desc_flex(ARec_Interface,'XTR_DEALS_DESC_FLEX',l_err_segment)) then
576: l_error := l_error +1;
577: if l_err_segment is not null and l_err_segment = 'Attribute16' then
578: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
579: ARec_Interface.Deal_Type,

Line 578: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

574:
575: if not ( xtr_import_deal_data.val_desc_flex(ARec_Interface,'XTR_DEALS_DESC_FLEX',l_err_segment)) then
576: l_error := l_error +1;
577: if l_err_segment is not null and l_err_segment = 'Attribute16' then
578: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
579: ARec_Interface.Deal_Type,
580: l_err_segment,
581: 'XTR_INV_DESC_FLEX_API');
582: elsif l_err_segment is not null and l_err_segment = 'AttributeCategory' then

Line 583: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

579: ARec_Interface.Deal_Type,
580: l_err_segment,
581: 'XTR_INV_DESC_FLEX_API');
582: elsif l_err_segment is not null and l_err_segment = 'AttributeCategory' then
583: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
584: ARec_Interface.Deal_Type,
585: l_err_segment,
586: 'XTR_INV_DESC_FLEX_CONTEXT');
587: else

Line 588: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

584: ARec_Interface.Deal_Type,
585: l_err_segment,
586: 'XTR_INV_DESC_FLEX_CONTEXT');
587: else
588: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
589: ARec_Interface.Deal_Type,
590: l_err_segment,
591: 'XTR_INV_DESC_FLEX');
592: end if;

Line 599: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

595: --rvallams begin
596:
597:
598: if (ARec_Interface.rate_a <= 0) then
599: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
600: ARec_Interface.Deal_Type,
601: 'RateA',
602: 'XTR_2180');
603: l_error := l_error +1;

Line 607: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,

603: l_error := l_error +1;
604: end if;
605:
606: if (ARec_Interface.rate_b <= 0) then
607: xtr_import_deal_data.log_interface_errors( ARec_Interface.External_Deal_Id,
608: ARec_Interface.Deal_Type,
609: 'RateB',
610: 'XTR_2180');
611: l_error := l_error +1;

Line 1392: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id,p_user_deal_type,

1388: fetch rnd_fac into home_currency, roundfac;
1389: if rnd_fac%notfound then
1390: close rnd_fac;
1391: /* cannot find home currency rate */
1392: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id,p_user_deal_type,
1393: 'CompanyCode','XTR_880');
1394: p_error := TRUE;
1395: return;
1396: end if;

Line 1433: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id,p_user_deal_type,

1429: fetch hc_rate into G_Fx_Main_Rec.buy_hce_amount;
1430: if hc_rate%notfound then
1431: close hc_rate;
1432: /* Cannot find home currency rate */
1433: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id,p_user_deal_type,
1434: 'CurrencyA','XTR_880');
1435: p_error := TRUE;
1436: return;
1437: end if;

Line 1472: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id,p_user_deal_type,

1468: open calc_hce;
1469: fetch calc_hce into forward_hce_first, forward_hce_second;
1470: if calc_hce%notfound then
1471: close calc_hce;
1472: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id,p_user_deal_type,
1473: 'CurrencyB','XTR_886'); -- Unable to find spot rate sell data
1474: p_error := TRUE;
1475: return;
1476: end if;

Line 1627: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id,p_user_deal_type,

1623:
1624: if v_new_sell_amount < round(NVL(G_Fx_Main_Rec.sell_amount,0) - l_tol/power(10,nvl(roundfac,0)),nvl(roundfac,2))
1625: OR v_new_sell_amount > round(NVL(G_Fx_Main_Rec.sell_amount,0) + l_tol/power(10,nvl(roundfac,0)),nvl(roundfac,2)) then
1626:
1627: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id,p_user_deal_type,
1628: 'AmountA','XTR_INV_BUY_AMT');
1629: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id,p_user_deal_type,
1630: 'AmountB','XTR_INV_SELL_AMT');
1631: p_error := TRUE;

Line 1629: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id,p_user_deal_type,

1625: OR v_new_sell_amount > round(NVL(G_Fx_Main_Rec.sell_amount,0) + l_tol/power(10,nvl(roundfac,0)),nvl(roundfac,2)) then
1626:
1627: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id,p_user_deal_type,
1628: 'AmountA','XTR_INV_BUY_AMT');
1629: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id,p_user_deal_type,
1630: 'AmountB','XTR_INV_SELL_AMT');
1631: p_error := TRUE;
1632: end if;
1633: else

Line 1647: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id,p_user_deal_type,

1643:
1644: if v_new_buy_amount < round(NVL(G_Fx_Main_Rec.buy_amount,0) - l_tol/power(10,nvl(roundfac,0)),nvl(roundfac,2))
1645: OR v_new_buy_amount > round(NVL(G_Fx_Main_Rec.buy_amount,0) + l_tol/power(10,nvl(roundfac,0)),nvl(roundfac,2)) then
1646:
1647: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id,p_user_deal_type,
1648: 'AmountA','XTR_INV_BUY_AMT');
1649: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id,p_user_deal_type,
1650: 'AmountB','XTR_INV_SELL_AMT');
1651: p_error := TRUE;

Line 1649: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id,p_user_deal_type,

1645: OR v_new_buy_amount > round(NVL(G_Fx_Main_Rec.buy_amount,0) + l_tol/power(10,nvl(roundfac,0)),nvl(roundfac,2)) then
1646:
1647: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id,p_user_deal_type,
1648: 'AmountA','XTR_INV_BUY_AMT');
1649: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id,p_user_deal_type,
1650: 'AmountB','XTR_INV_SELL_AMT');
1651: p_error := TRUE;
1652: end if;
1653: end if;

Line 1860: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id, p_user_deal_type,

1856: new_error_code varchar2(30);
1857: Begin
1858: new_error_code := 'XTR_'|| to_char(l_err_code); -- XTR_886 Unable to find Spot Rate.
1859: if nvl(l_level,'X') = 'E' then
1860: xtr_import_deal_data.log_interface_errors(G_Fx_Main_Rec.External_Deal_Id, p_user_deal_type,
1861: 'AmountC',new_error_code);
1862: end if;
1863: End;
1864: END CHECK_FOR_ERROR;