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_AUTO_RECONCILIATION dependencies on XTR_AUTO_RECONCILIATION

Line 1: PACKAGE BODY XTR_AUTO_RECONCILIATION AS

1: PACKAGE BODY XTR_AUTO_RECONCILIATION AS
2: /* $Header: xtrarecb.pls 120.11.12010000.5 2009/11/04 21:40:20 srsampat ship $ */
3:
4: --
5: CURSOR IMREF IS

Line 95: xtr_debug_pkg.debug('>XTR_AUTO_RECONCILIATION.auto_reconciliation');

91: --
92: BEGIN
93: -- cep_standard.enable_debug;
94: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
95: xtr_debug_pkg.debug('>XTR_AUTO_RECONCILIATION.auto_reconciliation');
96: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>set parameters...');
97: END IF;
98: --
99: -- set parameters

Line 147: xtr_debug_pkg.debug('>>call XTR_AUTO_RECONCILIATION.P_RECONCILE...');

143: G_account_number;
144: EXIT WHEN IMREF%NOTFOUND;
145:
146: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
147: xtr_debug_pkg.debug('>>call XTR_AUTO_RECONCILIATION.P_RECONCILE...');
148: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>>pass in -----------> ');
149: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_verfication_method ' || G_verification_method);
150: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_import_reference ' || to_char(G_import_reference));
151: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_currency ' || G_currency);

Line 157: XTR_AUTO_RECONCILIATION.P_RECONCILE ( G_verification_method,

153: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_incl_rtm ' || G_incl_rtm);
154: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '----------------> end pass in parameters');
155: END IF;
156:
157: XTR_AUTO_RECONCILIATION.P_RECONCILE ( G_verification_method,
158: x_pass_code,
159: G_import_reference,
160: G_currency,
161: sysdate,

Line 220: xtr_debug_pkg.debug('>>call XTR_AUTO_RECONCILIATION.P_RECONCILE...');

216: G_account_number;
217: EXIT WHEN ACCT_INFO%NOTFOUND;
218:
219: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
220: xtr_debug_pkg.debug('>>call XTR_AUTO_RECONCILIATION.P_RECONCILE...');
221: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>>pass in -----------> ');
222: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_verfication_method ' || G_verification_method);
223: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_import_reference ' || to_char(G_import_reference));
224: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_currency ' || G_currency);

Line 230: XTR_AUTO_RECONCILIATION.P_RECONCILE ( G_verification_method,

226: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_incl_rtm ' || G_incl_rtm);
227: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '----------------> end pass in parameters');
228: END IF;
229:
230: XTR_AUTO_RECONCILIATION.P_RECONCILE ( G_verification_method,
231: x_pass_code,
232: G_import_reference,
233: G_currency,
234: sysdate,

Line 276: xtr_debug_pkg.debug('EXCEPTION: XTR_AUTO_RECONCILIATION.auto_reconciliation');

272:
273: EXCEPTION
274: WHEN OTHERS THEN
275: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
276: xtr_debug_pkg.debug('EXCEPTION: XTR_AUTO_RECONCILIATION.auto_reconciliation');
277: END IF;
278: RAISE;
279: END AUTO_RECONCILIATION;
280:

Line 341: XTR_AUTO_RECONCILIATION.recalc_roll_details(old_deal_no,

337: -- Reconciled Deal has changed therefore recalc rollover records
338: -- using the old deal no, update rows where the start date >=
339: -- the lowest start date for this deal
340: --RECALC_ROLL_DETAILS(old_deal_no,l_subtype,l_lowest_start,l_ccy,old_trans_no,old_rec_ref,old_rec_pass);
341: XTR_AUTO_RECONCILIATION.recalc_roll_details(old_deal_no,
342: l_subtype,
343: l_lowest_start,
344: l_ccy,
345: old_trans_no,

Line 391: XTR_AUTO_RECONCILIATION.RECALC_ROLL_DETAILS(old_deal_no,

387: -- add
388: if old_deal_no is not null then
389: -- Recalc Rollover Transactions for the Last deal fetched
390: -- ie the recalc did not occur within the LOOP
391: XTR_AUTO_RECONCILIATION.RECALC_ROLL_DETAILS(old_deal_no,
392: l_subtype,
393: l_lowest_start,
394: l_ccy,
395: old_trans_no,

Line 489: XTR_AUTO_RECONCILIATION.RECALC_ROLL_DETAILS(old_deal_no,

485: -- using the old deal no, update rows where the start date >=
486: -- the lowest start date for this deal
487:
488:
489: XTR_AUTO_RECONCILIATION.RECALC_ROLL_DETAILS(old_deal_no,
490: l_subtype,
491: l_lowest_start,
492: l_ccy,
493: old_trans_no,

Line 537: XTR_AUTO_RECONCILIATION.RECALC_ROLL_DETAILS( old_deal_no,

533: -- Recalc Rollover Transactions for the Last deal fetched
534: -- ie the recalc did not occur within the LOOP
535:
536:
537: XTR_AUTO_RECONCILIATION.RECALC_ROLL_DETAILS( old_deal_no,
538: l_subtype,
539: l_lowest_start,
540: l_ccy,
541: old_trans_no,

Line 551: xtr_debug_pkg.debug('EXCEPTION: XTR_AUTO_RECONCILIATION.update_roll_trans');

547: CLOSE DDA_REC_ROW;
548: EXCEPTION
549: WHEN OTHERS THEN
550: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
551: xtr_debug_pkg.debug('EXCEPTION: XTR_AUTO_RECONCILIATION.update_roll_trans');
552: END IF;
553: RAISE;
554: END UPDATE_ROLL_TRANS_RTMM;
555:

Line 647: XTR_AUTO_RECONCILIATION.RECALC_ROLL_DETAILS(old_deal_no,

643: IF old_deal_no <> l_deal_no THEN
644: -- Reconciled Deal has changed therefore recalc rollover records
645: -- using the old deal no, update rows where the start date >=
646: -- the lowest start date for this deal
647: XTR_AUTO_RECONCILIATION.RECALC_ROLL_DETAILS(old_deal_no,
648: l_subtype,
649: l_lowest_start,
650: l_ccy,
651: old_trans_no,

Line 692: XTR_AUTO_RECONCILIATION.RECALC_ROLL_DETAILS( old_deal_no,

688: -- add
689: IF old_deal_no is not null then
690: -- Recalc Rollover Transactions for the Last deal fetched
691: -- ie the recalc did not occur within the LOOP
692: XTR_AUTO_RECONCILIATION.RECALC_ROLL_DETAILS( old_deal_no,
693: l_subtype,
694: l_lowest_start,
695: l_ccy,
696: old_trans_no,

Line 706: xtr_debug_pkg.debug('EXCEPTION: XTR_AUTO_RECONCILIATION.update_roll_trans');

702: CLOSE DDA_REC_ROW;
703: EXCEPTION
704: WHEN OTHERS THEN
705: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
706: xtr_debug_pkg.debug('EXCEPTION: XTR_AUTO_RECONCILIATION.update_roll_trans');
707: END IF;
708: RAISE;
709: END UPDATE_ROLL_TRANS;
710:

Line 785: XTR_AUTO_RECONCILIATION.RECALC_DT_DETAILS

781: l_company,l_dealer,l_deal_date,l_limit_code;
782: close DET;
783: --
784: if l_deal_no is NOT NULL then
785: XTR_AUTO_RECONCILIATION.RECALC_DT_DETAILS
786: (l_deal_no,
787: l_deal_date,
788: l_company,
789: l_subtype,

Line 809: xtr_debug_pkg.debug('EXCEPTION: XTR_AUTO_RECONCILIATION.recalc_roll_details');

805: END IF;
806: EXCEPTION
807: WHEN OTHERS THEN
808: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
809: xtr_debug_pkg.debug('EXCEPTION: XTR_AUTO_RECONCILIATION.recalc_roll_details');
810: END IF;
811: RAISE;
812: END RECALC_ROLL_DETAILS;
813:

Line 1432: xtr_debug_pkg.debug('EXCEPTION: XTR_AUTO_RECONCILIATION.recalc_dt_details');

1428: end if;
1429: EXCEPTION
1430: WHEN OTHERS THEN
1431: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1432: xtr_debug_pkg.debug('EXCEPTION: XTR_AUTO_RECONCILIATION.recalc_dt_details');
1433: END IF;
1434: RAISE;
1435: END RECALC_DT_DETAILS;
1436: /* ---------------------------------------------------------------------

Line 1701: xtr_debug_pkg.debug('>>>XTR_AUTO_RECONCILIATION.p_reconcile ');

1697: --
1698: -- set parameteres
1699: --
1700: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1701: xtr_debug_pkg.debug('>>>XTR_AUTO_RECONCILIATION.p_reconcile ');
1702: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>> set parameteres ---------------->');
1703: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_verification_method = ' || p_verification_method);
1704: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_pass_code = ' || p_pass_code);
1705: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_import_reference = ' || to_char(p_import_reference));

Line 2807: END XTR_AUTO_RECONCILIATION;

2803: utl_file.fclose(l_file);
2804:
2805: end P_RECONCILE;
2806:
2807: END XTR_AUTO_RECONCILIATION;