APPS.CE_STATEMENT_RECONS_PKG dependencies on CE_STATEMENT_RECONS_PKG

Line 1: PACKAGE BODY ce_statement_recons_pkg AS

1: PACKAGE BODY ce_statement_recons_pkg AS
2: /* $Header: cestmreb.pls 120.4.12010000.2 2008/11/04 04:46:15 csutaria ship $ */
3:
4: l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
5: --l_DEBUG varchar2(1) := 'Y';

Line 56: fnd_message.set_token('PROCEDURE', 'ce_statement_recons_pkg.check_unique');

52: WHEN app_exceptions.application_exception THEN
53: RAISE;
54: WHEN OTHERS THEN
55: fnd_message.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
56: fnd_message.set_token('PROCEDURE', 'ce_statement_recons_pkg.check_unique');
57: RAISE;
58: END check_unique;
59:
60: PROCEDURE Insert_Row( X_Row_id IN OUT NOCOPY VARCHAR2,

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

Line 574: END ce_statement_recons_pkg;

570: Raise NO_DATA_FOUND;
571: end if;
572: END Delete_Row;
573:
574: END ce_statement_recons_pkg;