DBA Data[Home] [Help]

APPS.CE_CASHFLOW_PKG dependencies on CE_CASHFLOW_PKG

Line 1: package body CE_CASHFLOW_PKG as

1: package body CE_CASHFLOW_PKG as
2: /* $Header: cecashpb.pls 120.10 2011/02/17 08:31:26 talapati ship $ */
3:
4: l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
5: -- l_DEBUG varchar2(1) := 'Y';

Line 36: cep_standard.debug('>>CE_CASHFLOW_PKG.UPDATE_CE_CASHFLOWS');

32: X_PASSIN_MODE varchar2
33: ) IS
34: BEGIN
35: IF l_DEBUG in ('Y', 'C') THEN
36: cep_standard.debug('>>CE_CASHFLOW_PKG.UPDATE_CE_CASHFLOWS');
37: cep_standard.debug('X_PASSIN_MODE: '|| X_PASSIN_MODE ||
38: ', X_STATEMENT_LINE_ID: '|| X_STATEMENT_LINE_ID||
39: ', X_TRX_STATUS: '||X_TRX_STATUS||
40: ', X_NEW_TRX_STATUS: '|| X_NEW_TRX_STATUS

Line 86: cep_standard.debug('<

82:
83: END IF;
84:
85: IF l_DEBUG in ('Y', 'C') THEN
86: cep_standard.debug('< 87: END IF;
88:
89: EXCEPTION
90: WHEN OTHERS THEN

Line 92: cep_standard.debug('EXCEPTION: CE_CASHFLOW_PKG.UPDATE_CE_CASHFLOWS');

88:
89: EXCEPTION
90: WHEN OTHERS THEN
91: IF l_DEBUG in ('Y', 'C') THEN
92: cep_standard.debug('EXCEPTION: CE_CASHFLOW_PKG.UPDATE_CE_CASHFLOWS');
93: END IF;
94: RAISE;
95: END UPDATE_CE_CASHFLOWS;
96:

Line 112: cep_standard.debug('>>CE_CASHFLOW_PKG.RAISE_ACCT_EVENT');

108: X_EVENT_ID IN OUT NOCOPY NUMBER) IS
109: --x_event_id number;
110: BEGIN
111: IF l_DEBUG in ('Y', 'C') THEN
112: cep_standard.debug('>>CE_CASHFLOW_PKG.RAISE_ACCT_EVENT');
113: END IF;
114:
115: ce_xla_acct_events_pkg.create_event(
116: X_trx_id => X_CASHFLOW_ID,

Line 128: cep_standard.debug('<

124: X_event_status_code => X_EVENT_STATUS_CODE);
125:
126: */
127: IF l_DEBUG in ('Y', 'C') THEN
128: cep_standard.debug('< 129: END IF;
130:
131: EXCEPTION
132: WHEN OTHERS THEN

Line 134: cep_standard.debug('EXCEPTION: CE_CASHFLOW_PKG.RAISE_ACCT_EVENT');

130:
131: EXCEPTION
132: WHEN OTHERS THEN
133: IF l_DEBUG in ('Y', 'C') THEN
134: cep_standard.debug('EXCEPTION: CE_CASHFLOW_PKG.RAISE_ACCT_EVENT');
135: END IF;
136: RAISE;
137: END RAISE_ACCT_EVENT;
138:

Line 181: cep_standard.debug('>>CE_CASHFLOW_PKG.clear_cashflow');

177: l_err NUMBER;
178:
179: BEGIN
180: IF l_DEBUG in ('Y', 'C') THEN
181: cep_standard.debug('>>CE_CASHFLOW_PKG.clear_cashflow');
182: END IF;
183:
184: /* bug 7395052 - added CLEARED_BY_FLAG column which was earlier being
185: * fetched by a separate query after

Line 402: cep_standard.debug('<

398:
399: END IF;
400:
401: IF l_DEBUG in ('Y', 'C') THEN
402: cep_standard.debug('< 403: END IF;
404: EXCEPTION
405: WHEN OTHERS THEN
406: IF l_DEBUG in ('Y', 'C') THEN

Line 407: cep_standard.debug('EXCEPTION: CE_CASHFLOW_PKG.clear_cashflow');

403: END IF;
404: EXCEPTION
405: WHEN OTHERS THEN
406: IF l_DEBUG in ('Y', 'C') THEN
407: cep_standard.debug('EXCEPTION: CE_CASHFLOW_PKG.clear_cashflow');
408: END IF;
409: RAISE;
410: END clear_cashflow;
411:

Line 433: cep_standard.debug('>>CE_CASHFLOW_PKG.update_user_lines');

429: ) IS
430: l_amount NUMBER;
431: BEGIN
432: IF l_DEBUG in ('Y', 'C') THEN
433: cep_standard.debug('>>CE_CASHFLOW_PKG.update_user_lines');
434: END IF;
435:
436: IF X_SOURCE_TYPE = 'UDO' AND X_AMOUNT <0 THEN
437: l_amount := -1*X_AMOUNT;

Line 464: cep_standard.debug('<

460: Trunc(X_AS_OF_DATE),
461: l_amount
462: );
463: IF l_DEBUG in ('Y', 'C') THEN
464: cep_standard.debug('< 465: END IF;
466: EXCEPTION
467: WHEN Dup_Val_On_Index THEN
468: IF l_DEBUG in ('Y', 'C') THEN

Line 487: cep_standard.debug('<

483: WHERE WORKSHEET_HEADER_ID = X_WORKSHEET_HEADER_ID
484: AND WORKSHEET_LINE_ID = X_WORKSHEET_LINE_ID
485: AND Trunc(AS_OF_DATE) = Trunc(X_AS_OF_DATE);
486: IF l_DEBUG in ('Y', 'C') THEN
487: cep_standard.debug('< 488: END IF;
489: WHEN OTHERS THEN
490: IF l_DEBUG in ('Y', 'C') THEN
491: cep_standard.debug('EXCEPTION: CE_CASHFLOW_PKG.update_user_lines');

Line 491: cep_standard.debug('EXCEPTION: CE_CASHFLOW_PKG.update_user_lines');

487: cep_standard.debug('< 488: END IF;
489: WHEN OTHERS THEN
490: IF l_DEBUG in ('Y', 'C') THEN
491: cep_standard.debug('EXCEPTION: CE_CASHFLOW_PKG.update_user_lines');
492: END IF;
493: RAISE;
494: END UPDATE_USER_LINES;
495:

Line 496: END CE_CASHFLOW_PKG;

492: END IF;
493: RAISE;
494: END UPDATE_USER_LINES;
495:
496: END CE_CASHFLOW_PKG;