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.

[Home] [Help]

APPS.XTR_AUTO_RECONCILIATION dependencies on XTR_DEBUG_PKG

Line 94: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

90:
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: --

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 96: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>set parameters...');

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
100: --

Line 111: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

107: date_from := to_date(G_value_date_from, 'DD/MM/RRRR');
108: date_to := to_date(G_value_date_to, 'DD/MM/RRRR');
109: G_incl_rtm := p_incl_rtm;
110:
111: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
112: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_import_reference_from = ' || to_char(G_import_reference_from));
113: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_import_reference_to = ' || to_char(G_import_reference_to));
114: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_source = ' || G_source);
115: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_acct_num = ' || G_acct_num);

Line 112: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_import_reference_from = ' || to_char(G_import_reference_from));

108: date_to := to_date(G_value_date_to, 'DD/MM/RRRR');
109: G_incl_rtm := p_incl_rtm;
110:
111: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
112: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_import_reference_from = ' || to_char(G_import_reference_from));
113: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_import_reference_to = ' || to_char(G_import_reference_to));
114: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_source = ' || G_source);
115: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_acct_num = ' || G_acct_num);
116: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_value_date_from = ' || G_value_date_from);

Line 113: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_import_reference_to = ' || to_char(G_import_reference_to));

109: G_incl_rtm := p_incl_rtm;
110:
111: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
112: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_import_reference_from = ' || to_char(G_import_reference_from));
113: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_import_reference_to = ' || to_char(G_import_reference_to));
114: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_source = ' || G_source);
115: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_acct_num = ' || G_acct_num);
116: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_value_date_from = ' || G_value_date_from);
117: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_value_date_to = ' || G_value_date_to);

Line 114: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_source = ' || G_source);

110:
111: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
112: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_import_reference_from = ' || to_char(G_import_reference_from));
113: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_import_reference_to = ' || to_char(G_import_reference_to));
114: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_source = ' || G_source);
115: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_acct_num = ' || G_acct_num);
116: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_value_date_from = ' || G_value_date_from);
117: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_value_date_to = ' || G_value_date_to);
118: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_incl_rtm = ' || G_incl_rtm);

Line 115: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_acct_num = ' || G_acct_num);

111: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
112: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_import_reference_from = ' || to_char(G_import_reference_from));
113: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_import_reference_to = ' || to_char(G_import_reference_to));
114: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_source = ' || G_source);
115: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_acct_num = ' || G_acct_num);
116: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_value_date_from = ' || G_value_date_from);
117: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_value_date_to = ' || G_value_date_to);
118: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_incl_rtm = ' || G_incl_rtm);
119: END IF;

Line 116: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_value_date_from = ' || G_value_date_from);

112: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_import_reference_from = ' || to_char(G_import_reference_from));
113: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_import_reference_to = ' || to_char(G_import_reference_to));
114: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_source = ' || G_source);
115: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_acct_num = ' || G_acct_num);
116: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_value_date_from = ' || G_value_date_from);
117: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_value_date_to = ' || G_value_date_to);
118: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_incl_rtm = ' || G_incl_rtm);
119: END IF;
120:

Line 117: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_value_date_to = ' || G_value_date_to);

113: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_import_reference_to = ' || to_char(G_import_reference_to));
114: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_source = ' || G_source);
115: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_acct_num = ' || G_acct_num);
116: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_value_date_from = ' || G_value_date_from);
117: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_value_date_to = ' || G_value_date_to);
118: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_incl_rtm = ' || G_incl_rtm);
119: END IF;
120:
121: IF (G_import_reference_to IS NOT NULL

Line 118: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_incl_rtm = ' || G_incl_rtm);

114: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_source = ' || G_source);
115: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_acct_num = ' || G_acct_num);
116: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_value_date_from = ' || G_value_date_from);
117: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_value_date_to = ' || G_value_date_to);
118: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_incl_rtm = ' || G_incl_rtm);
119: END IF;
120:
121: IF (G_import_reference_to IS NOT NULL
122: OR G_import_reference_from IS NOT NULL) THEN

Line 127: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

123: --
124: -- if user specify import reference number
125: -- as auto reconciliation drive and not account information
126: --
127: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
128: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>OPEN CURSOR IMREF');
129: END IF;
130:
131: OPEN IMREF;

Line 128: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>OPEN CURSOR IMREF');

124: -- if user specify import reference number
125: -- as auto reconciliation drive and not account information
126: --
127: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
128: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>OPEN CURSOR IMREF');
129: END IF;
130:
131: OPEN IMREF;
132:

Line 133: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

129: END IF;
130:
131: OPEN IMREF;
132:
133: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
134: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> LOOP ');
135: END IF;
136: LOOP
137: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 134: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> LOOP ');

130:
131: OPEN IMREF;
132:
133: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
134: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> LOOP ');
135: END IF;
136: LOOP
137: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
138: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>>FETCH CURSOR IMREF');

Line 137: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

133: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
134: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> LOOP ');
135: END IF;
136: LOOP
137: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
138: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>>FETCH CURSOR IMREF');
139: END IF;
140: Fetch IMREF into G_verification_method,
141: G_import_reference,

Line 138: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>>FETCH CURSOR IMREF');

134: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> LOOP ');
135: END IF;
136: LOOP
137: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
138: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>>FETCH CURSOR IMREF');
139: END IF;
140: Fetch IMREF into G_verification_method,
141: G_import_reference,
142: G_currency,

Line 146: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

142: G_currency,
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));

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 148: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>>pass in -----------> ');

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);
152: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_account_number ' || G_account_number);

Line 149: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_verfication_method ' || G_verification_method);

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);
152: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_account_number ' || G_account_number);
153: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_incl_rtm ' || G_incl_rtm);

Line 150: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_import_reference ' || to_char(G_import_reference));

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);
152: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_account_number ' || G_account_number);
153: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_incl_rtm ' || G_incl_rtm);
154: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '----------------> end pass in parameters');

Line 151: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_currency ' || G_currency);

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);
152: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_account_number ' || G_account_number);
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;

Line 152: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_account_number ' || G_account_number);

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);
152: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_account_number ' || G_account_number);
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:

Line 153: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_incl_rtm ' || G_incl_rtm);

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);
152: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_account_number ' || G_account_number);
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,

Line 154: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '----------------> end pass in parameters');

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);
152: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_account_number ' || G_account_number);
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,

Line 177: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

173: G_incl_rtm);
174:
175: IF (x_rec_num IS NOT NULL AND NVL(G_incl_rtm, 'Y') = 'Y') THEN
176:
177: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
178: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> call UPDATE_ROLL_TRANS -------->');
179: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_min_rec_nos = ' || to_char(x_min_rec_nos));
180: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_max_rec_nos = ' || to_char(x_max_rec_nos));
181: END IF;

Line 178: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> call UPDATE_ROLL_TRANS -------->');

174:
175: IF (x_rec_num IS NOT NULL AND NVL(G_incl_rtm, 'Y') = 'Y') THEN
176:
177: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
178: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> call UPDATE_ROLL_TRANS -------->');
179: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_min_rec_nos = ' || to_char(x_min_rec_nos));
180: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_max_rec_nos = ' || to_char(x_max_rec_nos));
181: END IF;
182:

Line 179: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_min_rec_nos = ' || to_char(x_min_rec_nos));

175: IF (x_rec_num IS NOT NULL AND NVL(G_incl_rtm, 'Y') = 'Y') THEN
176:
177: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
178: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> call UPDATE_ROLL_TRANS -------->');
179: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_min_rec_nos = ' || to_char(x_min_rec_nos));
180: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_max_rec_nos = ' || to_char(x_max_rec_nos));
181: END IF;
182:
183: UPDATE_ROLL_TRANS( G_verification_method,

Line 180: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_max_rec_nos = ' || to_char(x_max_rec_nos));

176:
177: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
178: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> call UPDATE_ROLL_TRANS -------->');
179: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_min_rec_nos = ' || to_char(x_min_rec_nos));
180: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_max_rec_nos = ' || to_char(x_max_rec_nos));
181: END IF;
182:
183: UPDATE_ROLL_TRANS( G_verification_method,
184: x_min_rec_nos,

Line 189: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

185: x_max_rec_nos,
186: 'AUTO');
187: END IF;
188:
189: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
190: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> END LOOP ');
191: END IF;
192: END LOOP;
193: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 190: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> END LOOP ');

186: 'AUTO');
187: END IF;
188:
189: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
190: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> END LOOP ');
191: END IF;
192: END LOOP;
193: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
194: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> CLOSE CURSOR IMREF ');

Line 193: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

189: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
190: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> END LOOP ');
191: END IF;
192: END LOOP;
193: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
194: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> CLOSE CURSOR IMREF ');
195: END IF;
196: CLOSE IMREF;
197: ELSE --

Line 194: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> CLOSE CURSOR IMREF ');

190: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> END LOOP ');
191: END IF;
192: END LOOP;
193: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
194: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> CLOSE CURSOR IMREF ');
195: END IF;
196: CLOSE IMREF;
197: ELSE --
198: -- if user specify account information

Line 201: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

197: ELSE --
198: -- if user specify account information
199: -- and not by import reference #
200: --
201: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
202: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> OPEN CURSOR ACCT_INFO ');
203: END IF;
204: OPEN ACCT_INFO;
205:

Line 202: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> OPEN CURSOR ACCT_INFO ');

198: -- if user specify account information
199: -- and not by import reference #
200: --
201: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
202: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> OPEN CURSOR ACCT_INFO ');
203: END IF;
204: OPEN ACCT_INFO;
205:
206: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 206: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

202: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> OPEN CURSOR ACCT_INFO ');
203: END IF;
204: OPEN ACCT_INFO;
205:
206: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
207: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> LOOP ');
208: END IF;
209: LOOP
210: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 207: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> LOOP ');

203: END IF;
204: OPEN ACCT_INFO;
205:
206: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
207: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> LOOP ');
208: END IF;
209: LOOP
210: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
211: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> FETCH CURSOR ACCT_INFO ');

Line 210: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

206: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
207: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> LOOP ');
208: END IF;
209: LOOP
210: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
211: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> FETCH CURSOR ACCT_INFO ');
212: END IF;
213: Fetch ACCT_INFO into G_verification_method,
214: G_import_reference,

Line 211: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> FETCH CURSOR ACCT_INFO ');

207: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> LOOP ');
208: END IF;
209: LOOP
210: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
211: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> FETCH CURSOR ACCT_INFO ');
212: END IF;
213: Fetch ACCT_INFO into G_verification_method,
214: G_import_reference,
215: G_currency,

Line 219: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

215: G_currency,
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));

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 221: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>>pass in -----------> ');

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);
225: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_account_number ' || G_account_number);

Line 222: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_verfication_method ' || G_verification_method);

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);
225: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_account_number ' || G_account_number);
226: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_incl_rtm ' || G_incl_rtm);

Line 223: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_import_reference ' || to_char(G_import_reference));

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);
225: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_account_number ' || G_account_number);
226: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_incl_rtm ' || G_incl_rtm);
227: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '----------------> end pass in parameters');

Line 224: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_currency ' || G_currency);

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);
225: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_account_number ' || G_account_number);
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;

Line 225: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_account_number ' || G_account_number);

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);
225: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_account_number ' || G_account_number);
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:

Line 226: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_incl_rtm ' || G_incl_rtm);

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);
225: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_account_number ' || G_account_number);
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,

Line 227: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '----------------> end pass in parameters');

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);
225: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'G_account_number ' || G_account_number);
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,

Line 250: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

246: G_incl_rtm);
247:
248: IF (x_rec_num IS NOT NULL AND NVL(G_incl_rtm, 'Y') = 'Y') THEN
249:
250: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
251: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> call UPDATE_ROLL_TRANS -------->');
252: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_min_rec_nos = ' || to_char(x_min_rec_nos));
253: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_max_rec_nos = ' || to_char(x_max_rec_nos));
254: END IF;

Line 251: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> call UPDATE_ROLL_TRANS -------->');

247:
248: IF (x_rec_num IS NOT NULL AND NVL(G_incl_rtm, 'Y') = 'Y') THEN
249:
250: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
251: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> call UPDATE_ROLL_TRANS -------->');
252: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_min_rec_nos = ' || to_char(x_min_rec_nos));
253: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_max_rec_nos = ' || to_char(x_max_rec_nos));
254: END IF;
255:

Line 252: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_min_rec_nos = ' || to_char(x_min_rec_nos));

248: IF (x_rec_num IS NOT NULL AND NVL(G_incl_rtm, 'Y') = 'Y') THEN
249:
250: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
251: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> call UPDATE_ROLL_TRANS -------->');
252: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_min_rec_nos = ' || to_char(x_min_rec_nos));
253: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_max_rec_nos = ' || to_char(x_max_rec_nos));
254: END IF;
255:
256: UPDATE_ROLL_TRANS( G_verification_method,

Line 253: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_max_rec_nos = ' || to_char(x_max_rec_nos));

249:
250: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
251: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '>> call UPDATE_ROLL_TRANS -------->');
252: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_min_rec_nos = ' || to_char(x_min_rec_nos));
253: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || 'x_max_rec_nos = ' || to_char(x_max_rec_nos));
254: END IF;
255:
256: UPDATE_ROLL_TRANS( G_verification_method,
257: x_min_rec_nos,

Line 262: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

258: x_max_rec_nos,
259: 'AUTO');
260: END IF;
261:
262: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
263: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> END LOOOP ');
264: END IF;
265: END LOOP;
266: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 263: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> END LOOOP ');

259: 'AUTO');
260: END IF;
261:
262: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
263: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> END LOOOP ');
264: END IF;
265: END LOOP;
266: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
267: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> CLOSE CURSOR ACCT_INFO');

Line 266: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

262: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
263: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> END LOOOP ');
264: END IF;
265: END LOOP;
266: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
267: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> CLOSE CURSOR ACCT_INFO');
268: END IF;
269: CLOSE ACCT_INFO;
270:

Line 267: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> CLOSE CURSOR ACCT_INFO');

263: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> END LOOOP ');
264: END IF;
265: END LOOP;
266: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
267: xtr_debug_pkg.debug('AUTO_RECONCILIATION: ' || '> CLOSE CURSOR ACCT_INFO');
268: END IF;
269: CLOSE ACCT_INFO;
270:
271: END IF;

Line 275: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

271: END IF;
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;

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 522: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

518: l_lowest_start := l_start_date;
519: END IF;
520:
521: -- Store previous deal to compare with the fetch for the next deal
522: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
523: xtr_debug_pkg.debug('UPDATE_ROLL_TRANS: ' || 'old_rec_ref = ' ||to_char(l_rec_ref));
524: END IF;
525: old_deal_no := l_deal_no;
526: old_trans_no := l_trans_no;

Line 523: xtr_debug_pkg.debug('UPDATE_ROLL_TRANS: ' || 'old_rec_ref = ' ||to_char(l_rec_ref));

519: END IF;
520:
521: -- Store previous deal to compare with the fetch for the next deal
522: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
523: xtr_debug_pkg.debug('UPDATE_ROLL_TRANS: ' || 'old_rec_ref = ' ||to_char(l_rec_ref));
524: END IF;
525: old_deal_no := l_deal_no;
526: old_trans_no := l_trans_no;
527: old_rec_ref :=l_rec_ref;

Line 550: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

546: --
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;

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 679: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

675: ELSIF l_start_date < l_lowest_start then
676: l_lowest_start := l_start_date;
677: END IF;
678: -- Store previous deal to compare with the fetch for the next deal
679: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
680: xtr_debug_pkg.debug('UPDATE_ROLL_TRANS: ' || 'old_rec_ref = ' ||to_char(l_rec_ref));
681: END IF;
682: old_deal_no := l_deal_no;
683: old_trans_no := l_trans_no;

Line 680: xtr_debug_pkg.debug('UPDATE_ROLL_TRANS: ' || 'old_rec_ref = ' ||to_char(l_rec_ref));

676: l_lowest_start := l_start_date;
677: END IF;
678: -- Store previous deal to compare with the fetch for the next deal
679: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
680: xtr_debug_pkg.debug('UPDATE_ROLL_TRANS: ' || 'old_rec_ref = ' ||to_char(l_rec_ref));
681: END IF;
682: old_deal_no := l_deal_no;
683: old_trans_no := l_trans_no;
684: old_rec_ref :=l_rec_ref;

Line 705: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

701: --
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;

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 808: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

804: l_limit_code);
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;

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 1431: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1427: close DT_ROW;
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;

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 1700: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1696:
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);

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 1702: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>> set parameteres ---------------->');

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));
1706: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_currency = ' || p_currency);

Line 1703: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_verification_method = ' || p_verification_method);

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));
1706: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_currency = ' || p_currency);
1707: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_account_number = ' || p_account_number);

Line 1704: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_pass_code = ' || p_pass_code);

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));
1706: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_currency = ' || p_currency);
1707: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_account_number = ' || p_account_number);
1708: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_incl_rtm = '|| p_incl_rtm);

Line 1705: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_import_reference = ' || to_char(p_import_reference));

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));
1706: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_currency = ' || p_currency);
1707: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_account_number = ' || p_account_number);
1708: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_incl_rtm = '|| p_incl_rtm);
1709: END IF;

Line 1706: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_currency = ' || p_currency);

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));
1706: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_currency = ' || p_currency);
1707: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_account_number = ' || p_account_number);
1708: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_incl_rtm = '|| p_incl_rtm);
1709: END IF;
1710:

Line 1707: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_account_number = ' || p_account_number);

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));
1706: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_currency = ' || p_currency);
1707: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_account_number = ' || p_account_number);
1708: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_incl_rtm = '|| p_incl_rtm);
1709: END IF;
1710:
1711: P_MIN_REC_NOS := NULL;

Line 1708: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_incl_rtm = '|| p_incl_rtm);

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));
1706: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_currency = ' || p_currency);
1707: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_account_number = ' || p_account_number);
1708: xtr_debug_pkg.debug('P_RECONCILE: ' || 'p_incl_rtm = '|| p_incl_rtm);
1709: END IF;
1710:
1711: P_MIN_REC_NOS := NULL;
1712: P_MAX_REC_NOS := NULL;

Line 1715: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1711: P_MIN_REC_NOS := NULL;
1712: P_MAX_REC_NOS := NULL;
1713: P_REC_NOS := NULL;
1714:
1715: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1716: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>> OPEN CURSOR PASSES ');
1717: END IF;
1718: open PASSES;
1719: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 1716: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>> OPEN CURSOR PASSES ');

1712: P_MAX_REC_NOS := NULL;
1713: P_REC_NOS := NULL;
1714:
1715: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1716: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>> OPEN CURSOR PASSES ');
1717: END IF;
1718: open PASSES;
1719: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1720: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>> LOOP --2 ');

Line 1719: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1715: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1716: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>> OPEN CURSOR PASSES ');
1717: END IF;
1718: open PASSES;
1719: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1720: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>> LOOP --2 ');
1721: END IF;
1722: LOOP -- 2
1723:

Line 1720: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>> LOOP --2 ');

1716: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>> OPEN CURSOR PASSES ');
1717: END IF;
1718: open PASSES;
1719: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1720: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>> LOOP --2 ');
1721: END IF;
1722: LOOP -- 2
1723:
1724: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 1724: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1720: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>> LOOP --2 ');
1721: END IF;
1722: LOOP -- 2
1723:
1724: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1725: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>> FETCH PASSES into P_PASS_CODE, l_days');
1726: END IF;
1727: fetch PASSES INTO P_PASS_CODE,l_days;
1728:

Line 1725: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>> FETCH PASSES into P_PASS_CODE, l_days');

1721: END IF;
1722: LOOP -- 2
1723:
1724: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1725: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>> FETCH PASSES into P_PASS_CODE, l_days');
1726: END IF;
1727: fetch PASSES INTO P_PASS_CODE,l_days;
1728:
1729: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 1729: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1725: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>> FETCH PASSES into P_PASS_CODE, l_days');
1726: END IF;
1727: fetch PASSES INTO P_PASS_CODE,l_days;
1728:
1729: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1730: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_PASS_CODE = ' || P_PASS_CODE);
1731: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_days = ' || to_char(l_days));
1732: END IF;
1733:

Line 1730: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_PASS_CODE = ' || P_PASS_CODE);

1726: END IF;
1727: fetch PASSES INTO P_PASS_CODE,l_days;
1728:
1729: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1730: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_PASS_CODE = ' || P_PASS_CODE);
1731: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_days = ' || to_char(l_days));
1732: END IF;
1733:
1734: EXIT WHEN PASSES%NOTFOUND;

Line 1731: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_days = ' || to_char(l_days));

1727: fetch PASSES INTO P_PASS_CODE,l_days;
1728:
1729: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1730: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_PASS_CODE = ' || P_PASS_CODE);
1731: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_days = ' || to_char(l_days));
1732: END IF;
1733:
1734: EXIT WHEN PASSES%NOTFOUND;
1735: l_bk_acct := NULL;l_party := NULL;l_deal_no := NULL;l_serial_ref := NULL;

Line 1739: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1735: l_bk_acct := NULL;l_party := NULL;l_deal_no := NULL;l_serial_ref := NULL;
1736: l_amount := NULL;l_sum_date := NULL;l_sum_range := NULL;l_date :=NULL;
1737: l_deal_type := NULL;
1738: l_subtype := NULL;l_product := NULL;l_portfolio := NULL; v_netoff_number := NULL;
1739: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1740: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>> OPEN CURSOR PASS_DETAILS ');
1741: END IF;
1742: open PASS_DETAILS;
1743: LOOP -- 3 (in 2)

Line 1740: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>> OPEN CURSOR PASS_DETAILS ');

1736: l_amount := NULL;l_sum_date := NULL;l_sum_range := NULL;l_date :=NULL;
1737: l_deal_type := NULL;
1738: l_subtype := NULL;l_product := NULL;l_portfolio := NULL; v_netoff_number := NULL;
1739: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1740: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>> OPEN CURSOR PASS_DETAILS ');
1741: END IF;
1742: open PASS_DETAILS;
1743: LOOP -- 3 (in 2)
1744: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 1744: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1740: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>> OPEN CURSOR PASS_DETAILS ');
1741: END IF;
1742: open PASS_DETAILS;
1743: LOOP -- 3 (in 2)
1744: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1745: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> LOOP --3 ');
1746: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> FETCH PASS_DETAILS into p_det');
1747: END IF;
1748: fetch PASS_DETAILS INTO p_det;

Line 1745: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> LOOP --3 ');

1741: END IF;
1742: open PASS_DETAILS;
1743: LOOP -- 3 (in 2)
1744: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1745: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> LOOP --3 ');
1746: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> FETCH PASS_DETAILS into p_det');
1747: END IF;
1748: fetch PASS_DETAILS INTO p_det;
1749:

Line 1746: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> FETCH PASS_DETAILS into p_det');

1742: open PASS_DETAILS;
1743: LOOP -- 3 (in 2)
1744: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1745: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> LOOP --3 ');
1746: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> FETCH PASS_DETAILS into p_det');
1747: END IF;
1748: fetch PASS_DETAILS INTO p_det;
1749:
1750: --xtr_debug_pkg.debug('p_det.RECONCILE_ON_COLUMN = ' || REOCNCILE_ON_COLUMN);

Line 1750: --xtr_debug_pkg.debug('p_det.RECONCILE_ON_COLUMN = ' || REOCNCILE_ON_COLUMN);

1746: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> FETCH PASS_DETAILS into p_det');
1747: END IF;
1748: fetch PASS_DETAILS INTO p_det;
1749:
1750: --xtr_debug_pkg.debug('p_det.RECONCILE_ON_COLUMN = ' || REOCNCILE_ON_COLUMN);
1751: EXIT WHEN PASS_DETAILS%NOTFOUND;
1752: if p_det.RECONCILE_ON_COLUMN = 'BANK ACCT' then
1753: if p_det.RECONCILE_DETAIL = 'MATCH' then
1754: l_bk_acct := 'Y'; -----FOR BUG 6664952--l_bk_acct := '%';

Line 1782: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1778: l_product := substr(p_det.RECONCILE_DETAIL,1,10);
1779: elsif p_det.RECONCILE_ON_COLUMN = 'SUBTYPE' then
1780: l_portfolio := substr(p_det.RECONCILE_DETAIL,1,7);
1781: end if;
1782: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1783: xtr_debug_pkg.debug('P_RECONCILE: ' || 'values----------------------');
1784: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_party = ' || l_party);
1785: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_serial_ref = ' || l_serial_ref);
1786: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_no = ' || l_deal_no);

Line 1783: xtr_debug_pkg.debug('P_RECONCILE: ' || 'values----------------------');

1779: elsif p_det.RECONCILE_ON_COLUMN = 'SUBTYPE' then
1780: l_portfolio := substr(p_det.RECONCILE_DETAIL,1,7);
1781: end if;
1782: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1783: xtr_debug_pkg.debug('P_RECONCILE: ' || 'values----------------------');
1784: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_party = ' || l_party);
1785: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_serial_ref = ' || l_serial_ref);
1786: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_no = ' || l_deal_no);
1787: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_amount = ' || l_amount);

Line 1784: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_party = ' || l_party);

1780: l_portfolio := substr(p_det.RECONCILE_DETAIL,1,7);
1781: end if;
1782: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1783: xtr_debug_pkg.debug('P_RECONCILE: ' || 'values----------------------');
1784: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_party = ' || l_party);
1785: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_serial_ref = ' || l_serial_ref);
1786: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_no = ' || l_deal_no);
1787: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_amount = ' || l_amount);
1788: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_date = ' || l_sum_date);

Line 1785: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_serial_ref = ' || l_serial_ref);

1781: end if;
1782: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1783: xtr_debug_pkg.debug('P_RECONCILE: ' || 'values----------------------');
1784: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_party = ' || l_party);
1785: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_serial_ref = ' || l_serial_ref);
1786: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_no = ' || l_deal_no);
1787: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_amount = ' || l_amount);
1788: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_date = ' || l_sum_date);
1789: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_range = ' || l_sum_range);

Line 1786: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_no = ' || l_deal_no);

1782: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1783: xtr_debug_pkg.debug('P_RECONCILE: ' || 'values----------------------');
1784: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_party = ' || l_party);
1785: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_serial_ref = ' || l_serial_ref);
1786: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_no = ' || l_deal_no);
1787: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_amount = ' || l_amount);
1788: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_date = ' || l_sum_date);
1789: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_range = ' || l_sum_range);
1790: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_date = ' || l_date);

Line 1787: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_amount = ' || l_amount);

1783: xtr_debug_pkg.debug('P_RECONCILE: ' || 'values----------------------');
1784: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_party = ' || l_party);
1785: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_serial_ref = ' || l_serial_ref);
1786: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_no = ' || l_deal_no);
1787: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_amount = ' || l_amount);
1788: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_date = ' || l_sum_date);
1789: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_range = ' || l_sum_range);
1790: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_date = ' || l_date);
1791: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_type = ' || l_deal_type);

Line 1788: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_date = ' || l_sum_date);

1784: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_party = ' || l_party);
1785: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_serial_ref = ' || l_serial_ref);
1786: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_no = ' || l_deal_no);
1787: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_amount = ' || l_amount);
1788: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_date = ' || l_sum_date);
1789: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_range = ' || l_sum_range);
1790: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_date = ' || l_date);
1791: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_type = ' || l_deal_type);
1792: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_subtype = ' || l_subtype);

Line 1789: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_range = ' || l_sum_range);

1785: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_serial_ref = ' || l_serial_ref);
1786: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_no = ' || l_deal_no);
1787: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_amount = ' || l_amount);
1788: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_date = ' || l_sum_date);
1789: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_range = ' || l_sum_range);
1790: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_date = ' || l_date);
1791: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_type = ' || l_deal_type);
1792: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_subtype = ' || l_subtype);
1793: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_product = ' || l_product);

Line 1790: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_date = ' || l_date);

1786: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_no = ' || l_deal_no);
1787: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_amount = ' || l_amount);
1788: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_date = ' || l_sum_date);
1789: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_range = ' || l_sum_range);
1790: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_date = ' || l_date);
1791: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_type = ' || l_deal_type);
1792: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_subtype = ' || l_subtype);
1793: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_product = ' || l_product);
1794: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_portfolio = ' || l_portfolio);

Line 1791: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_type = ' || l_deal_type);

1787: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_amount = ' || l_amount);
1788: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_date = ' || l_sum_date);
1789: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_range = ' || l_sum_range);
1790: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_date = ' || l_date);
1791: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_type = ' || l_deal_type);
1792: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_subtype = ' || l_subtype);
1793: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_product = ' || l_product);
1794: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_portfolio = ' || l_portfolio);
1795: xtr_debug_pkg.debug('P_RECONCILE: ' || '---------------------------');

Line 1792: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_subtype = ' || l_subtype);

1788: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_date = ' || l_sum_date);
1789: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_range = ' || l_sum_range);
1790: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_date = ' || l_date);
1791: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_type = ' || l_deal_type);
1792: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_subtype = ' || l_subtype);
1793: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_product = ' || l_product);
1794: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_portfolio = ' || l_portfolio);
1795: xtr_debug_pkg.debug('P_RECONCILE: ' || '---------------------------');
1796: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>> END LOOP --3 ');

Line 1793: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_product = ' || l_product);

1789: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_range = ' || l_sum_range);
1790: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_date = ' || l_date);
1791: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_type = ' || l_deal_type);
1792: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_subtype = ' || l_subtype);
1793: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_product = ' || l_product);
1794: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_portfolio = ' || l_portfolio);
1795: xtr_debug_pkg.debug('P_RECONCILE: ' || '---------------------------');
1796: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>> END LOOP --3 ');
1797: END IF;

Line 1794: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_portfolio = ' || l_portfolio);

1790: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_date = ' || l_date);
1791: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_type = ' || l_deal_type);
1792: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_subtype = ' || l_subtype);
1793: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_product = ' || l_product);
1794: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_portfolio = ' || l_portfolio);
1795: xtr_debug_pkg.debug('P_RECONCILE: ' || '---------------------------');
1796: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>> END LOOP --3 ');
1797: END IF;
1798: END LOOP; -- 3 (in 2)

Line 1795: xtr_debug_pkg.debug('P_RECONCILE: ' || '---------------------------');

1791: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_type = ' || l_deal_type);
1792: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_subtype = ' || l_subtype);
1793: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_product = ' || l_product);
1794: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_portfolio = ' || l_portfolio);
1795: xtr_debug_pkg.debug('P_RECONCILE: ' || '---------------------------');
1796: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>> END LOOP --3 ');
1797: END IF;
1798: END LOOP; -- 3 (in 2)
1799: close PASS_DETAILS;

Line 1796: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>> END LOOP --3 ');

1792: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_subtype = ' || l_subtype);
1793: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_product = ' || l_product);
1794: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_portfolio = ' || l_portfolio);
1795: xtr_debug_pkg.debug('P_RECONCILE: ' || '---------------------------');
1796: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>> END LOOP --3 ');
1797: END IF;
1798: END LOOP; -- 3 (in 2)
1799: close PASS_DETAILS;
1800: if l_days is NULL then

Line 1806: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1802: end if;
1803:
1804: open REC;
1805:
1806: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1807: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> LOOP --4 ');
1808: END IF;
1809: LOOP -- 4 (in 2)
1810: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 1807: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> LOOP --4 ');

1803:
1804: open REC;
1805:
1806: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1807: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> LOOP --4 ');
1808: END IF;
1809: LOOP -- 4 (in 2)
1810: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1811: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> FETCH REC into rec_det');

Line 1810: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1806: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1807: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> LOOP --4 ');
1808: END IF;
1809: LOOP -- 4 (in 2)
1810: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1811: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> FETCH REC into rec_det');
1812: END IF;
1813:
1814: fetch REC INTO rec_det;

Line 1811: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> FETCH REC into rec_det');

1807: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> LOOP --4 ');
1808: END IF;
1809: LOOP -- 4 (in 2)
1810: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1811: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> FETCH REC into rec_det');
1812: END IF;
1813:
1814: fetch REC INTO rec_det;
1815: EXIT WHEN REC%NOTFOUND;

Line 1822: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1818: P_SERIAL_REFERENCE := rec_det.SERIAL_REFERENCE;
1819: P_DEBIT_AMOUNT := rec_det.DEBIT_AMOUNT;
1820: P_CREDIT_AMOUNT := rec_det.CREDIT_AMOUNT;
1821: P_RECONCILED_YN := NULL;
1822: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1823: xtr_debug_pkg.debug('P_RECONCILE: ' || 'value--------------------');
1824: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_IMPORT_REFERENCE = ' || to_char(P_IMPORT_REFERENCE));
1825: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_RECORD_IN_PROCESS = ' || to_char(P_RECORD_IN_PROCESS));
1826: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_PARTY_NAME = ' || P_PARTY_NAME);

Line 1823: xtr_debug_pkg.debug('P_RECONCILE: ' || 'value--------------------');

1819: P_DEBIT_AMOUNT := rec_det.DEBIT_AMOUNT;
1820: P_CREDIT_AMOUNT := rec_det.CREDIT_AMOUNT;
1821: P_RECONCILED_YN := NULL;
1822: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1823: xtr_debug_pkg.debug('P_RECONCILE: ' || 'value--------------------');
1824: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_IMPORT_REFERENCE = ' || to_char(P_IMPORT_REFERENCE));
1825: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_RECORD_IN_PROCESS = ' || to_char(P_RECORD_IN_PROCESS));
1826: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_PARTY_NAME = ' || P_PARTY_NAME);
1827: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_SERIAL_REFERENCE = ' || P_SERIAL_REFERENCE);

Line 1824: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_IMPORT_REFERENCE = ' || to_char(P_IMPORT_REFERENCE));

1820: P_CREDIT_AMOUNT := rec_det.CREDIT_AMOUNT;
1821: P_RECONCILED_YN := NULL;
1822: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1823: xtr_debug_pkg.debug('P_RECONCILE: ' || 'value--------------------');
1824: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_IMPORT_REFERENCE = ' || to_char(P_IMPORT_REFERENCE));
1825: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_RECORD_IN_PROCESS = ' || to_char(P_RECORD_IN_PROCESS));
1826: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_PARTY_NAME = ' || P_PARTY_NAME);
1827: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_SERIAL_REFERENCE = ' || P_SERIAL_REFERENCE);
1828: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_DEBIT_AMOUNT = ' || to_char(P_DEBIT_AMOUNT));

Line 1825: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_RECORD_IN_PROCESS = ' || to_char(P_RECORD_IN_PROCESS));

1821: P_RECONCILED_YN := NULL;
1822: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1823: xtr_debug_pkg.debug('P_RECONCILE: ' || 'value--------------------');
1824: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_IMPORT_REFERENCE = ' || to_char(P_IMPORT_REFERENCE));
1825: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_RECORD_IN_PROCESS = ' || to_char(P_RECORD_IN_PROCESS));
1826: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_PARTY_NAME = ' || P_PARTY_NAME);
1827: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_SERIAL_REFERENCE = ' || P_SERIAL_REFERENCE);
1828: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_DEBIT_AMOUNT = ' || to_char(P_DEBIT_AMOUNT));
1829: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_CREDIT_AMOUNT = ' || to_char(P_CREDIT_AMOUNT));

Line 1826: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_PARTY_NAME = ' || P_PARTY_NAME);

1822: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1823: xtr_debug_pkg.debug('P_RECONCILE: ' || 'value--------------------');
1824: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_IMPORT_REFERENCE = ' || to_char(P_IMPORT_REFERENCE));
1825: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_RECORD_IN_PROCESS = ' || to_char(P_RECORD_IN_PROCESS));
1826: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_PARTY_NAME = ' || P_PARTY_NAME);
1827: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_SERIAL_REFERENCE = ' || P_SERIAL_REFERENCE);
1828: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_DEBIT_AMOUNT = ' || to_char(P_DEBIT_AMOUNT));
1829: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_CREDIT_AMOUNT = ' || to_char(P_CREDIT_AMOUNT));
1830: xtr_debug_pkg.debug('P_RECONCILED_YN = ' || P_RECONCILED_YN);

Line 1827: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_SERIAL_REFERENCE = ' || P_SERIAL_REFERENCE);

1823: xtr_debug_pkg.debug('P_RECONCILE: ' || 'value--------------------');
1824: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_IMPORT_REFERENCE = ' || to_char(P_IMPORT_REFERENCE));
1825: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_RECORD_IN_PROCESS = ' || to_char(P_RECORD_IN_PROCESS));
1826: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_PARTY_NAME = ' || P_PARTY_NAME);
1827: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_SERIAL_REFERENCE = ' || P_SERIAL_REFERENCE);
1828: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_DEBIT_AMOUNT = ' || to_char(P_DEBIT_AMOUNT));
1829: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_CREDIT_AMOUNT = ' || to_char(P_CREDIT_AMOUNT));
1830: xtr_debug_pkg.debug('P_RECONCILED_YN = ' || P_RECONCILED_YN);
1831: END IF;

Line 1828: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_DEBIT_AMOUNT = ' || to_char(P_DEBIT_AMOUNT));

1824: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_IMPORT_REFERENCE = ' || to_char(P_IMPORT_REFERENCE));
1825: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_RECORD_IN_PROCESS = ' || to_char(P_RECORD_IN_PROCESS));
1826: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_PARTY_NAME = ' || P_PARTY_NAME);
1827: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_SERIAL_REFERENCE = ' || P_SERIAL_REFERENCE);
1828: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_DEBIT_AMOUNT = ' || to_char(P_DEBIT_AMOUNT));
1829: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_CREDIT_AMOUNT = ' || to_char(P_CREDIT_AMOUNT));
1830: xtr_debug_pkg.debug('P_RECONCILED_YN = ' || P_RECONCILED_YN);
1831: END IF;
1832:

Line 1829: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_CREDIT_AMOUNT = ' || to_char(P_CREDIT_AMOUNT));

1825: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_RECORD_IN_PROCESS = ' || to_char(P_RECORD_IN_PROCESS));
1826: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_PARTY_NAME = ' || P_PARTY_NAME);
1827: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_SERIAL_REFERENCE = ' || P_SERIAL_REFERENCE);
1828: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_DEBIT_AMOUNT = ' || to_char(P_DEBIT_AMOUNT));
1829: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_CREDIT_AMOUNT = ' || to_char(P_CREDIT_AMOUNT));
1830: xtr_debug_pkg.debug('P_RECONCILED_YN = ' || P_RECONCILED_YN);
1831: END IF;
1832:
1833: /* dda_sum_date */

Line 1830: xtr_debug_pkg.debug('P_RECONCILED_YN = ' || P_RECONCILED_YN);

1826: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_PARTY_NAME = ' || P_PARTY_NAME);
1827: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_SERIAL_REFERENCE = ' || P_SERIAL_REFERENCE);
1828: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_DEBIT_AMOUNT = ' || to_char(P_DEBIT_AMOUNT));
1829: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_CREDIT_AMOUNT = ' || to_char(P_CREDIT_AMOUNT));
1830: xtr_debug_pkg.debug('P_RECONCILED_YN = ' || P_RECONCILED_YN);
1831: END IF;
1832:
1833: /* dda_sum_date */
1834: if nvl(l_sum_date,'N') = 'Y' then

Line 1835: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1831: END IF;
1832:
1833: /* dda_sum_date */
1834: if nvl(l_sum_date,'N') = 'Y' then
1835: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1836: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>>DDA_SUM_DATE..............');
1837: END IF;
1838:
1839: open DDA_SUM_DATE;

Line 1836: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>>DDA_SUM_DATE..............');

1832:
1833: /* dda_sum_date */
1834: if nvl(l_sum_date,'N') = 'Y' then
1835: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1836: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>>DDA_SUM_DATE..............');
1837: END IF;
1838:
1839: open DDA_SUM_DATE;
1840:

Line 1842: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1838:
1839: open DDA_SUM_DATE;
1840:
1841: LOOP -- 5 (in 4)
1842: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1843: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>>> LOOP --5 ');
1844: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>>> FETCH DDA_SUM_DATE into l_s_date, l_sum_amt, l_num_recs');
1845: END IF;
1846: fetch DDA_SUM_DATE INTO l_s_date,l_sum_amt,l_num_recs, v_netoff_number;

Line 1843: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>>> LOOP --5 ');

1839: open DDA_SUM_DATE;
1840:
1841: LOOP -- 5 (in 4)
1842: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1843: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>>> LOOP --5 ');
1844: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>>> FETCH DDA_SUM_DATE into l_s_date, l_sum_amt, l_num_recs');
1845: END IF;
1846: fetch DDA_SUM_DATE INTO l_s_date,l_sum_amt,l_num_recs, v_netoff_number;
1847: --dbms_output.put_line(' DDA_SUM_DATE date, amt, no-rec, net# '||l_s_date||' - '||l_sum_amt||' - '||l_num_recs||' - '||v_netoff_number);

Line 1844: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>>> FETCH DDA_SUM_DATE into l_s_date, l_sum_amt, l_num_recs');

1840:
1841: LOOP -- 5 (in 4)
1842: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1843: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>>> LOOP --5 ');
1844: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>>> FETCH DDA_SUM_DATE into l_s_date, l_sum_amt, l_num_recs');
1845: END IF;
1846: fetch DDA_SUM_DATE INTO l_s_date,l_sum_amt,l_num_recs, v_netoff_number;
1847: --dbms_output.put_line(' DDA_SUM_DATE date, amt, no-rec, net# '||l_s_date||' - '||l_sum_amt||' - '||l_num_recs||' - '||v_netoff_number);
1848:

Line 2189: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2185: end if;
2186: END LOOP; -- 5 (in 4)
2187: close DDA_SUM_DATE;
2188: elsif nvl(l_sum_range,'N') = 'Y' then
2189: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2190: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> DDA_SUM_RANGE .............');
2191: END IF;
2192:
2193: open DDA_SUM_RANGE;

Line 2190: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> DDA_SUM_RANGE .............');

2186: END LOOP; -- 5 (in 4)
2187: close DDA_SUM_DATE;
2188: elsif nvl(l_sum_range,'N') = 'Y' then
2189: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2190: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> DDA_SUM_RANGE .............');
2191: END IF;
2192:
2193: open DDA_SUM_RANGE;
2194: -- Sum records on Deal Date Amounts ACROSS a Range of Dates

Line 2196: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2192:
2193: open DDA_SUM_RANGE;
2194: -- Sum records on Deal Date Amounts ACROSS a Range of Dates
2195: LOOP -- 6 (in 4)
2196: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2197: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>>> LOOP --6 ');
2198: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>>> FETCH DDA_SUM_RANGE into l_sum_amt, l_num_recs');
2199: END IF;
2200: fetch DDA_SUM_RANGE INTO l_sum_amt,l_num_recs, v_netoff_number;

Line 2197: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>>> LOOP --6 ');

2193: open DDA_SUM_RANGE;
2194: -- Sum records on Deal Date Amounts ACROSS a Range of Dates
2195: LOOP -- 6 (in 4)
2196: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2197: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>>> LOOP --6 ');
2198: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>>> FETCH DDA_SUM_RANGE into l_sum_amt, l_num_recs');
2199: END IF;
2200: fetch DDA_SUM_RANGE INTO l_sum_amt,l_num_recs, v_netoff_number;
2201: --dbms_output.put_line('DDA_SUM_RANGE amt, no-recs, net# '||l_sum_amt||' - '||l_num_recs||' - '||v_netoff_number);

Line 2198: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>>> FETCH DDA_SUM_RANGE into l_sum_amt, l_num_recs');

2194: -- Sum records on Deal Date Amounts ACROSS a Range of Dates
2195: LOOP -- 6 (in 4)
2196: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2197: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>>> LOOP --6 ');
2198: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>>> FETCH DDA_SUM_RANGE into l_sum_amt, l_num_recs');
2199: END IF;
2200: fetch DDA_SUM_RANGE INTO l_sum_amt,l_num_recs, v_netoff_number;
2201: --dbms_output.put_line('DDA_SUM_RANGE amt, no-recs, net# '||l_sum_amt||' - '||l_num_recs||' - '||v_netoff_number);
2202:

Line 2550: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2546: END LOOP; -- 6 (in 4)
2547: close DDA_SUM_RANGE;
2548: else
2549: /* else check amount equal to each other --> no sum */
2550: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2551: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> ELSE check amount equal each other, NO SUM! ');
2552: END IF;
2553: -- Check amounts equal each other.Do Not Sum amounts for a date or range of dates.
2554: -- The imported amount has to equal a single transaction amount.

Line 2551: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> ELSE check amount equal each other, NO SUM! ');

2547: close DDA_SUM_RANGE;
2548: else
2549: /* else check amount equal to each other --> no sum */
2550: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2551: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> ELSE check amount equal each other, NO SUM! ');
2552: END IF;
2553: -- Check amounts equal each other.Do Not Sum amounts for a date or range of dates.
2554: -- The imported amount has to equal a single transaction amount.
2555: open DDA;

Line 2558: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2554: -- The imported amount has to equal a single transaction amount.
2555: open DDA;
2556: l_num_recs :=0;
2557:
2558: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2559: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> FETCH DDA into l_sum_amt, l_num_recs, l_one_date ');
2560: END IF;
2561: fetch DDA INTO l_sum_amt,l_num_recs,l_one_date, v_netoff_number;
2562: --dbms_output.put_line('DDA amt, no-recs, date, net# '||l_sum_amt||' - '||l_num_recs||' - '||l_one_date||' - '||v_netoff_number);

Line 2559: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> FETCH DDA into l_sum_amt, l_num_recs, l_one_date ');

2555: open DDA;
2556: l_num_recs :=0;
2557:
2558: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2559: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> FETCH DDA into l_sum_amt, l_num_recs, l_one_date ');
2560: END IF;
2561: fetch DDA INTO l_sum_amt,l_num_recs,l_one_date, v_netoff_number;
2562: --dbms_output.put_line('DDA amt, no-recs, date, net# '||l_sum_amt||' - '||l_num_recs||' - '||l_one_date||' - '||v_netoff_number);
2563: /***************/

Line 2569: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2565: utl_file.put_line (l_file,'>>----net#, date, amt, no-recs '||v_netoff_number||' - '||l_one_date||' - '||l_sum_amt||' - '||l_num_recs);
2566: utl_file.put_line (l_file,'>>------------------------------');
2567: /***************/
2568:
2569: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2570: xtr_debug_pkg.debug('P_RECONCILE: ' || 'value after fetch -----------------');
2571: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_no = ' || l_deal_no);
2572: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.value_date = ' || to_char(rec_det.value_date));
2573: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_date = ' || l_date);

Line 2570: xtr_debug_pkg.debug('P_RECONCILE: ' || 'value after fetch -----------------');

2566: utl_file.put_line (l_file,'>>------------------------------');
2567: /***************/
2568:
2569: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2570: xtr_debug_pkg.debug('P_RECONCILE: ' || 'value after fetch -----------------');
2571: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_no = ' || l_deal_no);
2572: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.value_date = ' || to_char(rec_det.value_date));
2573: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_date = ' || l_date);
2574: END IF;

Line 2571: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_no = ' || l_deal_no);

2567: /***************/
2568:
2569: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2570: xtr_debug_pkg.debug('P_RECONCILE: ' || 'value after fetch -----------------');
2571: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_no = ' || l_deal_no);
2572: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.value_date = ' || to_char(rec_det.value_date));
2573: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_date = ' || l_date);
2574: END IF;
2575: xtr_debug_pkg.debug('P_CGU$SYSDATE = ' || P_CGU$SYSDATE);

Line 2572: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.value_date = ' || to_char(rec_det.value_date));

2568:
2569: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2570: xtr_debug_pkg.debug('P_RECONCILE: ' || 'value after fetch -----------------');
2571: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_no = ' || l_deal_no);
2572: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.value_date = ' || to_char(rec_det.value_date));
2573: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_date = ' || l_date);
2574: END IF;
2575: xtr_debug_pkg.debug('P_CGU$SYSDATE = ' || P_CGU$SYSDATE);
2576: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 2573: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_date = ' || l_date);

2569: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2570: xtr_debug_pkg.debug('P_RECONCILE: ' || 'value after fetch -----------------');
2571: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_no = ' || l_deal_no);
2572: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.value_date = ' || to_char(rec_det.value_date));
2573: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_date = ' || l_date);
2574: END IF;
2575: xtr_debug_pkg.debug('P_CGU$SYSDATE = ' || P_CGU$SYSDATE);
2576: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2577: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_CURRENCY = ' || P_CURRENCY);

Line 2575: xtr_debug_pkg.debug('P_CGU$SYSDATE = ' || P_CGU$SYSDATE);

2571: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_deal_no = ' || l_deal_no);
2572: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.value_date = ' || to_char(rec_det.value_date));
2573: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_date = ' || l_date);
2574: END IF;
2575: xtr_debug_pkg.debug('P_CGU$SYSDATE = ' || P_CGU$SYSDATE);
2576: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2577: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_CURRENCY = ' || P_CURRENCY);
2578: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_bk_acct = ' || l_bk_acct);
2579: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.DEBIT_AMOUNT = ' || to_char(rec_det.DEBIT_AMOUNT));

Line 2576: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2572: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.value_date = ' || to_char(rec_det.value_date));
2573: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_date = ' || l_date);
2574: END IF;
2575: xtr_debug_pkg.debug('P_CGU$SYSDATE = ' || P_CGU$SYSDATE);
2576: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2577: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_CURRENCY = ' || P_CURRENCY);
2578: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_bk_acct = ' || l_bk_acct);
2579: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.DEBIT_AMOUNT = ' || to_char(rec_det.DEBIT_AMOUNT));
2580: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.CREDIT_AMOUNT = ' || to_char(rec_det.CREDIT_AMOUNT));

Line 2577: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_CURRENCY = ' || P_CURRENCY);

2573: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_date = ' || l_date);
2574: END IF;
2575: xtr_debug_pkg.debug('P_CGU$SYSDATE = ' || P_CGU$SYSDATE);
2576: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2577: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_CURRENCY = ' || P_CURRENCY);
2578: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_bk_acct = ' || l_bk_acct);
2579: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.DEBIT_AMOUNT = ' || to_char(rec_det.DEBIT_AMOUNT));
2580: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.CREDIT_AMOUNT = ' || to_char(rec_det.CREDIT_AMOUNT));
2581: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_amt = '|| to_char(l_sum_amt));

Line 2578: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_bk_acct = ' || l_bk_acct);

2574: END IF;
2575: xtr_debug_pkg.debug('P_CGU$SYSDATE = ' || P_CGU$SYSDATE);
2576: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2577: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_CURRENCY = ' || P_CURRENCY);
2578: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_bk_acct = ' || l_bk_acct);
2579: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.DEBIT_AMOUNT = ' || to_char(rec_det.DEBIT_AMOUNT));
2580: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.CREDIT_AMOUNT = ' || to_char(rec_det.CREDIT_AMOUNT));
2581: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_amt = '|| to_char(l_sum_amt));
2582: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_num_recs = '|| to_char(l_num_recs));

Line 2579: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.DEBIT_AMOUNT = ' || to_char(rec_det.DEBIT_AMOUNT));

2575: xtr_debug_pkg.debug('P_CGU$SYSDATE = ' || P_CGU$SYSDATE);
2576: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2577: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_CURRENCY = ' || P_CURRENCY);
2578: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_bk_acct = ' || l_bk_acct);
2579: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.DEBIT_AMOUNT = ' || to_char(rec_det.DEBIT_AMOUNT));
2580: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.CREDIT_AMOUNT = ' || to_char(rec_det.CREDIT_AMOUNT));
2581: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_amt = '|| to_char(l_sum_amt));
2582: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_num_recs = '|| to_char(l_num_recs));
2583: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_one_date = '|| to_char(l_one_date));

Line 2580: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.CREDIT_AMOUNT = ' || to_char(rec_det.CREDIT_AMOUNT));

2576: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2577: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_CURRENCY = ' || P_CURRENCY);
2578: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_bk_acct = ' || l_bk_acct);
2579: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.DEBIT_AMOUNT = ' || to_char(rec_det.DEBIT_AMOUNT));
2580: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.CREDIT_AMOUNT = ' || to_char(rec_det.CREDIT_AMOUNT));
2581: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_amt = '|| to_char(l_sum_amt));
2582: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_num_recs = '|| to_char(l_num_recs));
2583: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_one_date = '|| to_char(l_one_date));
2584: xtr_debug_pkg.debug('P_RECONCILE: ' || '-------------------------------');

Line 2581: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_amt = '|| to_char(l_sum_amt));

2577: xtr_debug_pkg.debug('P_RECONCILE: ' || 'P_CURRENCY = ' || P_CURRENCY);
2578: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_bk_acct = ' || l_bk_acct);
2579: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.DEBIT_AMOUNT = ' || to_char(rec_det.DEBIT_AMOUNT));
2580: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.CREDIT_AMOUNT = ' || to_char(rec_det.CREDIT_AMOUNT));
2581: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_amt = '|| to_char(l_sum_amt));
2582: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_num_recs = '|| to_char(l_num_recs));
2583: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_one_date = '|| to_char(l_one_date));
2584: xtr_debug_pkg.debug('P_RECONCILE: ' || '-------------------------------');
2585: END IF;

Line 2582: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_num_recs = '|| to_char(l_num_recs));

2578: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_bk_acct = ' || l_bk_acct);
2579: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.DEBIT_AMOUNT = ' || to_char(rec_det.DEBIT_AMOUNT));
2580: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.CREDIT_AMOUNT = ' || to_char(rec_det.CREDIT_AMOUNT));
2581: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_amt = '|| to_char(l_sum_amt));
2582: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_num_recs = '|| to_char(l_num_recs));
2583: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_one_date = '|| to_char(l_one_date));
2584: xtr_debug_pkg.debug('P_RECONCILE: ' || '-------------------------------');
2585: END IF;
2586:

Line 2583: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_one_date = '|| to_char(l_one_date));

2579: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.DEBIT_AMOUNT = ' || to_char(rec_det.DEBIT_AMOUNT));
2580: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.CREDIT_AMOUNT = ' || to_char(rec_det.CREDIT_AMOUNT));
2581: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_amt = '|| to_char(l_sum_amt));
2582: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_num_recs = '|| to_char(l_num_recs));
2583: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_one_date = '|| to_char(l_one_date));
2584: xtr_debug_pkg.debug('P_RECONCILE: ' || '-------------------------------');
2585: END IF;
2586:
2587: if nvl(l_num_recs,0) > 0 then --- bug 5353780

Line 2584: xtr_debug_pkg.debug('P_RECONCILE: ' || '-------------------------------');

2580: xtr_debug_pkg.debug('P_RECONCILE: ' || 'rec_det.CREDIT_AMOUNT = ' || to_char(rec_det.CREDIT_AMOUNT));
2581: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_sum_amt = '|| to_char(l_sum_amt));
2582: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_num_recs = '|| to_char(l_num_recs));
2583: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_one_date = '|| to_char(l_one_date));
2584: xtr_debug_pkg.debug('P_RECONCILE: ' || '-------------------------------');
2585: END IF;
2586:
2587: if nvl(l_num_recs,0) > 0 then --- bug 5353780
2588: p_tot_recon := nvl(p_tot_recon,0) + 1;

Line 2593: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2589: P_RECONCILED_YN :='Y';
2590: l_sum_amt := nvl(rec_det.DEBIT_AMOUNT,0) +
2591: nvl(rec_det.CREDIT_AMOUNT,0);
2592: open REC_NUM;
2593: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2594: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> FETCH REC_NUM into l_rec_nos');
2595: END IF;
2596: fetch REC_NUM INTO l_rec_nos;
2597: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 2594: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> FETCH REC_NUM into l_rec_nos');

2590: l_sum_amt := nvl(rec_det.DEBIT_AMOUNT,0) +
2591: nvl(rec_det.CREDIT_AMOUNT,0);
2592: open REC_NUM;
2593: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2594: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> FETCH REC_NUM into l_rec_nos');
2595: END IF;
2596: fetch REC_NUM INTO l_rec_nos;
2597: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2598: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_rec_nos = '|| to_char(l_rec_nos));

Line 2597: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2593: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2594: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> FETCH REC_NUM into l_rec_nos');
2595: END IF;
2596: fetch REC_NUM INTO l_rec_nos;
2597: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2598: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_rec_nos = '|| to_char(l_rec_nos));
2599: END IF;
2600: close REC_NUM;
2601: if nvl(P_MIN_REC_NOS,9999999) >= l_rec_nos then

Line 2598: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_rec_nos = '|| to_char(l_rec_nos));

2594: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> FETCH REC_NUM into l_rec_nos');
2595: END IF;
2596: fetch REC_NUM INTO l_rec_nos;
2597: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2598: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_rec_nos = '|| to_char(l_rec_nos));
2599: END IF;
2600: close REC_NUM;
2601: if nvl(P_MIN_REC_NOS,9999999) >= l_rec_nos then
2602: P_MIN_REC_NOS := l_rec_nos;

Line 2610: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2606: end if;
2607: if P_REC_NOS is NULL then
2608: P_REC_NOS := l_rec_nos;
2609: end if;
2610: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2611: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> UPDATE DDA >>>>>>>>>>>>>>');
2612: END IF;
2613:
2614: --dbms_output.put_line('bef UPD ');

Line 2611: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> UPDATE DDA >>>>>>>>>>>>>>');

2607: if P_REC_NOS is NULL then
2608: P_REC_NOS := l_rec_nos;
2609: end if;
2610: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2611: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> UPDATE DDA >>>>>>>>>>>>>>');
2612: END IF;
2613:
2614: --dbms_output.put_line('bef UPD ');
2615: If v_netoff_number is null then

Line 2766: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2762: End Loop;
2763: End if;
2764: End if;
2765:
2766: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2767: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> UPDATE XTR_PAY_REC_REOCNCILIATION ');
2768: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_rec_nos = ' || to_char(l_rec_nos));
2769: END IF;
2770: update XTR_PAY_REC_RECONCILIATION

Line 2767: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> UPDATE XTR_PAY_REC_REOCNCILIATION ');

2763: End if;
2764: End if;
2765:
2766: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2767: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> UPDATE XTR_PAY_REC_REOCNCILIATION ');
2768: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_rec_nos = ' || to_char(l_rec_nos));
2769: END IF;
2770: update XTR_PAY_REC_RECONCILIATION
2771: set RECONCILED_REFERENCE = l_rec_nos,

Line 2768: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_rec_nos = ' || to_char(l_rec_nos));

2764: End if;
2765:
2766: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2767: xtr_debug_pkg.debug('P_RECONCILE: ' || '>>>>> UPDATE XTR_PAY_REC_REOCNCILIATION ');
2768: xtr_debug_pkg.debug('P_RECONCILE: ' || 'l_rec_nos = ' || to_char(l_rec_nos));
2769: END IF;
2770: update XTR_PAY_REC_RECONCILIATION
2771: set RECONCILED_REFERENCE = l_rec_nos,
2772: RECONCILED_PASS_CODE = P_PASS_CODE

Line 2780: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2776: close DDA;
2777: end if;
2778:
2779: END LOOP; -- 4 (in 2)
2780: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2781: xtr_debug_pkg.debug('P_RECONCILE: ' || 'END LOOP -- 4 ');
2782: END IF;
2783: close REC;
2784: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 2781: xtr_debug_pkg.debug('P_RECONCILE: ' || 'END LOOP -- 4 ');

2777: end if;
2778:
2779: END LOOP; -- 4 (in 2)
2780: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2781: xtr_debug_pkg.debug('P_RECONCILE: ' || 'END LOOP -- 4 ');
2782: END IF;
2783: close REC;
2784: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2785: xtr_debug_pkg.debug('P_RECONCILE: ' || 'END LOOP -- 2 ');

Line 2784: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2780: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2781: xtr_debug_pkg.debug('P_RECONCILE: ' || 'END LOOP -- 4 ');
2782: END IF;
2783: close REC;
2784: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2785: xtr_debug_pkg.debug('P_RECONCILE: ' || 'END LOOP -- 2 ');
2786: END IF;
2787: END LOOP; -- 2
2788: close PASSES;

Line 2785: xtr_debug_pkg.debug('P_RECONCILE: ' || 'END LOOP -- 2 ');

2781: xtr_debug_pkg.debug('P_RECONCILE: ' || 'END LOOP -- 4 ');
2782: END IF;
2783: close REC;
2784: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2785: xtr_debug_pkg.debug('P_RECONCILE: ' || 'END LOOP -- 2 ');
2786: END IF;
2787: END LOOP; -- 2
2788: close PASSES;
2789: if PASSES%ISOPEN then close PASSES; end if;

Line 2796: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2792: if REC_NUM%ISOPEN then close REC_NUM; end if;
2793: if DDA%ISOPEN then close DDA; end if;
2794: if DDA_SUM_DATE%ISOPEN then close DDA_SUM_DATE; end if;
2795: if DDA_SUM_RANGE%ISOPEN then close DDA_SUM_RANGE; end if;
2796: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2797: xtr_debug_pkg.debug('END P_RECONCILE >>>>>>>>>>');
2798: END IF;
2799:
2800: utl_file.put_line (l_file,' ');

Line 2797: xtr_debug_pkg.debug('END P_RECONCILE >>>>>>>>>>');

2793: if DDA%ISOPEN then close DDA; end if;
2794: if DDA_SUM_DATE%ISOPEN then close DDA_SUM_DATE; end if;
2795: if DDA_SUM_RANGE%ISOPEN then close DDA_SUM_RANGE; end if;
2796: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2797: xtr_debug_pkg.debug('END P_RECONCILE >>>>>>>>>>');
2798: END IF;
2799:
2800: utl_file.put_line (l_file,' ');
2801: utl_file.put_line (l_file,'>> Log file is located at '||l_dirname||'/xtraurec.log');