eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_STATEMENT_RECONS_PKG dependencies on CEP_STANDARD

Line 111: cep_standard.debug('>>CE_STATEMENT_RECONS_PKG.insert_row 1');

107: current_record_flag = 'Y'
108: FOR UPDATE of current_record_flag NOWAIT;
109: BEGIN
110: IF l_DEBUG in ('Y', 'C') THEN
111: cep_standard.debug('>>CE_STATEMENT_RECONS_PKG.insert_row 1');
112: cep_standard.debug('X_Row_id = '|| X_Row_id || ', X_statement_line_id = ' || X_statement_line_id);
113: cep_standard.debug('X_reference_type ='|| X_reference_type ||', X_reference_id = '|| X_reference_id ||
114: ', X_org_id = '||X_org_id || ', X_legal_entity_id = '||X_legal_entity_id ||
115: ', X_reference_status ='|| X_reference_status);

Line 112: cep_standard.debug('X_Row_id = '|| X_Row_id || ', X_statement_line_id = ' || X_statement_line_id);

108: FOR UPDATE of current_record_flag NOWAIT;
109: BEGIN
110: IF l_DEBUG in ('Y', 'C') THEN
111: cep_standard.debug('>>CE_STATEMENT_RECONS_PKG.insert_row 1');
112: cep_standard.debug('X_Row_id = '|| X_Row_id || ', X_statement_line_id = ' || X_statement_line_id);
113: cep_standard.debug('X_reference_type ='|| X_reference_type ||', X_reference_id = '|| X_reference_id ||
114: ', X_org_id = '||X_org_id || ', X_legal_entity_id = '||X_legal_entity_id ||
115: ', X_reference_status ='|| X_reference_status);
116: cep_standard.debug('X_amount = ' || X_amount ||', X_status_flag = ' || X_status_flag ||

Line 113: cep_standard.debug('X_reference_type ='|| X_reference_type ||', X_reference_id = '|| X_reference_id ||

109: BEGIN
110: IF l_DEBUG in ('Y', 'C') THEN
111: cep_standard.debug('>>CE_STATEMENT_RECONS_PKG.insert_row 1');
112: cep_standard.debug('X_Row_id = '|| X_Row_id || ', X_statement_line_id = ' || X_statement_line_id);
113: cep_standard.debug('X_reference_type ='|| X_reference_type ||', X_reference_id = '|| X_reference_id ||
114: ', X_org_id = '||X_org_id || ', X_legal_entity_id = '||X_legal_entity_id ||
115: ', X_reference_status ='|| X_reference_status);
116: cep_standard.debug('X_amount = ' || X_amount ||', X_status_flag = ' || X_status_flag ||
117: ', X_action_flag ='|| X_action_flag ||', X_current_record_flag = '|| X_current_record_flag ||

Line 116: cep_standard.debug('X_amount = ' || X_amount ||', X_status_flag = ' || X_status_flag ||

112: cep_standard.debug('X_Row_id = '|| X_Row_id || ', X_statement_line_id = ' || X_statement_line_id);
113: cep_standard.debug('X_reference_type ='|| X_reference_type ||', X_reference_id = '|| X_reference_id ||
114: ', X_org_id = '||X_org_id || ', X_legal_entity_id = '||X_legal_entity_id ||
115: ', X_reference_status ='|| X_reference_status);
116: cep_standard.debug('X_amount = ' || X_amount ||', X_status_flag = ' || X_status_flag ||
117: ', X_action_flag ='|| X_action_flag ||', X_current_record_flag = '|| X_current_record_flag ||
118: ', X_auto_reconciled_flag = ' ||X_auto_reconciled_flag);
119: END IF;
120:

Line 156: cep_standard.debug( ' reference_type_tmp ='||reference_type_tmp);

152: ELSE
153: reference_type_tmp := X_reference_type;
154: END IF;
155:
156: cep_standard.debug( ' reference_type_tmp ='||reference_type_tmp);
157:
158: --
159: -- Lock the 'Y' in the CE_STATEMENT_RECONCILIATIONS
160: -- to make sure that there is not anybody else matcing this transaction

Line 185: cep_standard.debug('INSERT INTO CE_STATEMENT_RECON_GT_V');

181: END IF;
182: END IF;
183:
184: IF l_DEBUG in ('Y', 'C') THEN
185: cep_standard.debug('INSERT INTO CE_STATEMENT_RECON_GT_V');
186: END IF;
187:
188: cep_standard.debug( ' X_org_id_tmp ='||X_org_id_tmp );
189: cep_standard.debug( ' X_legal_entity_id_tmp ='||X_legal_entity_id_tmp );

Line 188: cep_standard.debug( ' X_org_id_tmp ='||X_org_id_tmp );

184: IF l_DEBUG in ('Y', 'C') THEN
185: cep_standard.debug('INSERT INTO CE_STATEMENT_RECON_GT_V');
186: END IF;
187:
188: cep_standard.debug( ' X_org_id_tmp ='||X_org_id_tmp );
189: cep_standard.debug( ' X_legal_entity_id_tmp ='||X_legal_entity_id_tmp );
190:
191: IF (X_org_id is null) THEN
192: Y_org_id := X_org_id_tmp;

Line 189: cep_standard.debug( ' X_legal_entity_id_tmp ='||X_legal_entity_id_tmp );

185: cep_standard.debug('INSERT INTO CE_STATEMENT_RECON_GT_V');
186: END IF;
187:
188: cep_standard.debug( ' X_org_id_tmp ='||X_org_id_tmp );
189: cep_standard.debug( ' X_legal_entity_id_tmp ='||X_legal_entity_id_tmp );
190:
191: IF (X_org_id is null) THEN
192: Y_org_id := X_org_id_tmp;
193: ELSE

Line 202: cep_standard.debug( ' Y_org_id ='||Y_org_id);

198: ELSE
199: Y_legal_entity_id := X_legal_entity_id;
200: END IF;
201:
202: cep_standard.debug( ' Y_org_id ='||Y_org_id);
203: cep_standard.debug( ' Y_legal_entity_id ='||Y_legal_entity_id);
204:
205: INSERT INTO CE_STATEMENT_RECONCILS_ALL(
206: statement_line_id,

Line 203: cep_standard.debug( ' Y_legal_entity_id ='||Y_legal_entity_id);

199: Y_legal_entity_id := X_legal_entity_id;
200: END IF;
201:
202: cep_standard.debug( ' Y_org_id ='||Y_org_id);
203: cep_standard.debug( ' Y_legal_entity_id ='||Y_legal_entity_id);
204:
205: INSERT INTO CE_STATEMENT_RECONCILS_ALL(
206: statement_line_id,
207: reference_type,

Line 251: cep_standard.debug('end INSERT INTO CE_STATEMENT_RECON_GT_V');

247: X_program_update_date,
248: NULL));
249:
250: IF l_DEBUG in ('Y', 'C') THEN
251: cep_standard.debug('end INSERT INTO CE_STATEMENT_RECON_GT_V');
252: END IF;
253:
254:
255:

Line 259: cep_standard.debug(' fetch X_Row_Id ' ||X_Row_Id);

255:
256: OPEN C_ROWID;
257: FETCH C_ROWID INTO X_Row_Id;
258: IF l_DEBUG in ('Y', 'C') THEN
259: cep_standard.debug(' fetch X_Row_Id ' ||X_Row_Id);
260: END IF;
261: --if (C_ROWID%NOTFOUND) then
262: if (X_Row_Id is null ) then
263: CLOSE C_ROWID;

Line 266: cep_standard.debug('Raise NO_DATA_FOUND');

262: if (X_Row_Id is null ) then
263: CLOSE C_ROWID;
264:
265: IF l_DEBUG in ('Y', 'C') THEN
266: cep_standard.debug('Raise NO_DATA_FOUND');
267: END IF;
268:
269: Raise NO_DATA_FOUND;
270:

Line 272: cep_standard.debug('end Raise NO_DATA_FOUND');

268:
269: Raise NO_DATA_FOUND;
270:
271: IF l_DEBUG in ('Y', 'C') THEN
272: cep_standard.debug('end Raise NO_DATA_FOUND');
273: END IF;
274: end if;
275: IF l_DEBUG in ('Y', 'C') THEN
276: cep_standard.debug(' xx2 ');

Line 276: cep_standard.debug(' xx2 ');

272: cep_standard.debug('end Raise NO_DATA_FOUND');
273: END IF;
274: end if;
275: IF l_DEBUG in ('Y', 'C') THEN
276: cep_standard.debug(' xx2 ');
277: END IF;
278: IF (X_status_flag = 'M') THEN
279: DELETE from CE_RECONCILIATION_ERRORS
280: WHERE statement_line_id = X_statement_line_id;

Line 284: cep_standard.debug('<

280: WHERE statement_line_id = X_statement_line_id;
281: END IF;
282: CLOSE C_ROWID;
283: IF l_DEBUG in ('Y', 'C') THEN
284: cep_standard.debug('< 285: END IF;
286: END Insert_Row;
287:
288: PROCEDURE Insert_Row( X_Row_id IN OUT NOCOPY VARCHAR2,

Line 334: cep_standard.debug('>>CE_STATEMENT_RECONS_PKG.insert_row 2');

330: current_record_flag = 'Y'
331: FOR UPDATE of current_record_flag NOWAIT;
332: BEGIN
333: IF l_DEBUG in ('Y', 'C') THEN
334: cep_standard.debug('>>CE_STATEMENT_RECONS_PKG.insert_row 2');
335: END IF;
336: --
337: -- Map AR transactions types 'MISC' and 'CASH' to 'RECEIPT'
338: --

Line 371: cep_standard.debug( ' reference_type_tmp ='||reference_type_tmp);

367: ELSE
368: reference_type_tmp := X_reference_type;
369: END IF;
370:
371: cep_standard.debug( ' reference_type_tmp ='||reference_type_tmp);
372:
373:
374: --
375: -- Lock the 'Y' in the CE_STATEMENT_RECONCILIATIONS

Line 388: cep_standard.debug('INSERT INTO CE_STATEMENT_RECONCILS_ALL 2');

384: WHERE rowid = X_Row_id;
385: CLOSE C_LOCK;
386: END IF;
387: IF l_DEBUG in ('Y', 'C') THEN
388: cep_standard.debug('INSERT INTO CE_STATEMENT_RECONCILS_ALL 2');
389: END IF;
390:
391: cep_standard.debug( ' X_org_id_tmp ='||X_org_id_tmp );
392: cep_standard.debug( ' X_legal_entity_id_tmp ='||X_legal_entity_id_tmp );

Line 391: cep_standard.debug( ' X_org_id_tmp ='||X_org_id_tmp );

387: IF l_DEBUG in ('Y', 'C') THEN
388: cep_standard.debug('INSERT INTO CE_STATEMENT_RECONCILS_ALL 2');
389: END IF;
390:
391: cep_standard.debug( ' X_org_id_tmp ='||X_org_id_tmp );
392: cep_standard.debug( ' X_legal_entity_id_tmp ='||X_legal_entity_id_tmp );
393:
394: IF (X_org_id is null) THEN
395: Y_org_id := X_org_id_tmp;

Line 392: cep_standard.debug( ' X_legal_entity_id_tmp ='||X_legal_entity_id_tmp );

388: cep_standard.debug('INSERT INTO CE_STATEMENT_RECONCILS_ALL 2');
389: END IF;
390:
391: cep_standard.debug( ' X_org_id_tmp ='||X_org_id_tmp );
392: cep_standard.debug( ' X_legal_entity_id_tmp ='||X_legal_entity_id_tmp );
393:
394: IF (X_org_id is null) THEN
395: Y_org_id := X_org_id_tmp;
396: ELSE

Line 405: cep_standard.debug( ' reference_type_tmp ='||reference_type_tmp);

401: ELSE
402: Y_legal_entity_id := X_legal_entity_id;
403: END IF;
404:
405: cep_standard.debug( ' reference_type_tmp ='||reference_type_tmp);
406: cep_standard.debug( ' Y_org_id ='||Y_org_id);
407: cep_standard.debug( ' Y_legal_entity_id ='||Y_legal_entity_id);
408:
409:

Line 406: cep_standard.debug( ' Y_org_id ='||Y_org_id);

402: Y_legal_entity_id := X_legal_entity_id;
403: END IF;
404:
405: cep_standard.debug( ' reference_type_tmp ='||reference_type_tmp);
406: cep_standard.debug( ' Y_org_id ='||Y_org_id);
407: cep_standard.debug( ' Y_legal_entity_id ='||Y_legal_entity_id);
408:
409:
410: INSERT INTO CE_STATEMENT_RECONCILS_ALL(

Line 407: cep_standard.debug( ' Y_legal_entity_id ='||Y_legal_entity_id);

403: END IF;
404:
405: cep_standard.debug( ' reference_type_tmp ='||reference_type_tmp);
406: cep_standard.debug( ' Y_org_id ='||Y_org_id);
407: cep_standard.debug( ' Y_legal_entity_id ='||Y_legal_entity_id);
408:
409:
410: INSERT INTO CE_STATEMENT_RECONCILS_ALL(
411: statement_line_id,

Line 458: cep_standard.debug('end INSERT INTO CE_STATEMENT_RECONCILS_ALL 2');

454: X_program_update_date,
455: NULL));
456:
457: IF l_DEBUG in ('Y', 'C') THEN
458: cep_standard.debug('end INSERT INTO CE_STATEMENT_RECONCILS_ALL 2');
459: END IF;
460: OPEN C_ROWID;
461: FETCH C_ROWID INTO X_Row_Id;
462: if (C_ROWID%NOTFOUND) then

Line 472: cep_standard.debug('<

468: WHERE statement_line_id = X_statement_line_id;
469: END IF;
470: CLOSE C_ROWID;
471: IF l_DEBUG in ('Y', 'C') THEN
472: cep_standard.debug('< 473: END IF;
474: END Insert_Row;
475:
476: