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 2007/12/10 11:29:07 kbabu 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 370: XTR_AUTO_RECONCILIATION.RECALC_ROLL_DETAILS(old_deal_no,

366: IF old_deal_no <> l_deal_no THEN
367: -- Reconciled Deal has changed therefore recalc rollover records
368: -- using the old deal no, update rows where the start date >=
369: -- the lowest start date for this deal
370: XTR_AUTO_RECONCILIATION.RECALC_ROLL_DETAILS(old_deal_no,
371: l_subtype,
372: l_lowest_start,
373: l_ccy,
374: old_trans_no,

Line 415: XTR_AUTO_RECONCILIATION.RECALC_ROLL_DETAILS( old_deal_no,

411: -- add
412: IF old_deal_no is not null then
413: -- Recalc Rollover Transactions for the Last deal fetched
414: -- ie the recalc did not occur within the LOOP
415: XTR_AUTO_RECONCILIATION.RECALC_ROLL_DETAILS( old_deal_no,
416: l_subtype,
417: l_lowest_start,
418: l_ccy,
419: old_trans_no,

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

425: CLOSE DDA_REC_ROW;
426: EXCEPTION
427: WHEN OTHERS THEN
428: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
429: xtr_debug_pkg.debug('EXCEPTION: XTR_AUTO_RECONCILIATION.update_roll_trans');
430: END IF;
431: RAISE;
432: END UPDATE_ROLL_TRANS;
433:

Line 508: XTR_AUTO_RECONCILIATION.RECALC_DT_DETAILS

504: l_company,l_dealer,l_deal_date,l_limit_code;
505: close DET;
506: --
507: if l_deal_no is NOT NULL then
508: XTR_AUTO_RECONCILIATION.RECALC_DT_DETAILS
509: (l_deal_no,
510: l_deal_date,
511: l_company,
512: l_subtype,

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

528: END IF;
529: EXCEPTION
530: WHEN OTHERS THEN
531: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
532: xtr_debug_pkg.debug('EXCEPTION: XTR_AUTO_RECONCILIATION.recalc_roll_details');
533: END IF;
534: RAISE;
535: END RECALC_ROLL_DETAILS;
536:

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

1151: end if;
1152: EXCEPTION
1153: WHEN OTHERS THEN
1154: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1155: xtr_debug_pkg.debug('EXCEPTION: XTR_AUTO_RECONCILIATION.recalc_dt_details');
1156: END IF;
1157: RAISE;
1158: END RECALC_DT_DETAILS;
1159: /* ---------------------------------------------------------------------

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

1420: --
1421: -- set parameteres
1422: --
1423: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1424: xtr_debug_pkg.debug('>>>XTR_AUTO_RECONCILIATION.p_reconcile ');
1425: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>> set parameteres ---------------->');
1426: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_verification_method = ' || p_verification_method);
1427: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_pass_code = ' || p_pass_code);
1428: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_import_reference = ' || to_char(p_import_reference));

Line 2530: END XTR_AUTO_RECONCILIATION;

2526: utl_file.fclose(l_file);
2527:
2528: end P_RECONCILE;
2529:
2530: END XTR_AUTO_RECONCILIATION;