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_COPY_TRX_CODES_XML dependencies on CE_COPY_TRX_CODES_XML

Line 1: PACKAGE BODY CE_COPY_TRX_CODES_XML AS

1: PACKAGE BODY CE_COPY_TRX_CODES_XML AS
2: /* $Header: cecptxcb.pls 120.1.12010000.1 2009/07/31 08:39:23 vnetan noship $ */
3:
4: /*========================================================================+
5: | PRIVATE PROCEDURE |

Line 26: debug_log('>>CE_COPY_TRX_CODES_XML.init_variables');

22: | Procedure to initialize global variables. |
23: +========================================================================*/
24: PROCEDURE init_variables IS
25: BEGIN
26: debug_log('>>CE_COPY_TRX_CODES_XML.init_variables');
27:
28: -- source account
29: IF p_source_acct_id IS NOT NULL
30: THEN

Line 89: debug_log('<

85: --request_id
86: g_conc_request_id := FND_GLOBAL.CONC_REQUEST_ID;
87: debug_log('g_conc_request_id::'||g_conc_request_id);
88:
89: debug_log('< 90:
91: END init_variables;
92:
93: /*========================================================================+

Line 156: cep_standard.debug('>>CE_COPY_TRX_CODES_XML.check_unique_trxn_code');

152:
153: dummy VARCHAR2(100);
154: --
155: BEGIN
156: cep_standard.debug('>>CE_COPY_TRX_CODES_XML.check_unique_trxn_code');
157:
158: OPEN chk_duplicates;
159: FETCH chk_duplicates INTO dummy;
160:

Line 191: cep_standard.debug('<

187: END IF;
188:
189: CLOSE chk_duplicates2;
190:
191: cep_standard.debug('< 192: RETURN 'SUCCESS';
193: EXCEPTION
194: WHEN OTHERS THEN
195: cep_standard.debug('EXCEPTION: CE_COPY_TRX_CODES_XML.check_unique_trxn_code');

Line 195: cep_standard.debug('EXCEPTION: CE_COPY_TRX_CODES_XML.check_unique_trxn_code');

191: cep_standard.debug('< 192: RETURN 'SUCCESS';
193: EXCEPTION
194: WHEN OTHERS THEN
195: cep_standard.debug('EXCEPTION: CE_COPY_TRX_CODES_XML.check_unique_trxn_code');
196: IF ( chk_duplicates%ISOPEN ) THEN
197: CLOSE chk_duplicates;
198: END IF;
199: IF ( chk_duplicates2%ISOPEN ) THEN

Line 220: | CE_COPY_TRX_CODES_XML.check_unique_trxn_code |

216: | ARGUMENTS |
217: | |
218: | CALLS |
219: | CE_TRANSACTION_CODES_PKG.insert_row |
220: | CE_COPY_TRX_CODES_XML.check_unique_trxn_code |
221: +========================================================================*/
222: PROCEDURE copy_trx_codes
223: IS
224: -- cursor to fetch transaction codes

Line 279: debug_log('>>CE_COPY_TRX_CODES_XML.copy_trx_codes');

275: l_user_id NUMBER;
276:
277:
278: BEGIN
279: debug_log('>>CE_COPY_TRX_CODES_XML.copy_trx_codes');
280:
281: --parameter values
282: debug_log('p_source_acct_id::'||p_source_acct_id);
283: debug_log('p_dest_bank_id::'||p_dest_bank_id);

Line 378: debug_log('<

374: );
375: END IF;
376: END LOOP;
377: END LOOP;
378: debug_log('< 379:
380: END copy_trx_codes;
381:
382: /*========================================================================+

Line 390: | CE_COPY_TRX_CODES_XML.init_variables |

386: | DESCRIPTION |
387: | Before Report trigger for CECPTXCD. |
388: | |
389: | CALLS |
390: | CE_COPY_TRX_CODES_XML.init_variables |
391: | CE_COPY_TRX_CODES_XML.copy_trx_codes |
392: +========================================================================*/
393: FUNCTION beforeReport RETURN BOOLEAN IS
394: BEGIN

Line 391: | CE_COPY_TRX_CODES_XML.copy_trx_codes |

387: | Before Report trigger for CECPTXCD. |
388: | |
389: | CALLS |
390: | CE_COPY_TRX_CODES_XML.init_variables |
391: | CE_COPY_TRX_CODES_XML.copy_trx_codes |
392: +========================================================================*/
393: FUNCTION beforeReport RETURN BOOLEAN IS
394: BEGIN
395: debug_log('>>CE_COPY_TRX_CODES_XML.beforeReport');

Line 395: debug_log('>>CE_COPY_TRX_CODES_XML.beforeReport');

391: | CE_COPY_TRX_CODES_XML.copy_trx_codes |
392: +========================================================================*/
393: FUNCTION beforeReport RETURN BOOLEAN IS
394: BEGIN
395: debug_log('>>CE_COPY_TRX_CODES_XML.beforeReport');
396:
397: --initializations
398: cep_standard.init_security;
399: init_variables;

Line 411: debug_log('<

407: FROM ce_transaction_codes
408: WHERE request_id = G_CONC_REQUEST_ID;
409: debug_log('g_insert_count::'||g_insert_count);
410:
411: debug_log('< 412: RETURN (TRUE);
413: EXCEPTION
414: WHEN OTHERS THEN
415: ROLLBACK;

Line 416: debug_log('EXCEPTION: CE_COPY_TRX_CODES_XML.beforeReport trigger. Error : ' || SUBSTR(SQLERRM, 1, 200));

412: RETURN (TRUE);
413: EXCEPTION
414: WHEN OTHERS THEN
415: ROLLBACK;
416: debug_log('EXCEPTION: CE_COPY_TRX_CODES_XML.beforeReport trigger. Error : ' || SUBSTR(SQLERRM, 1, 200));
417: RETURN (FALSE);
418: END beforeReport;
419:
420: /*========================================================================+

Line 432: debug_log('>>CE_COPY_TRX_CODES_XML.afterReport');

428: | ARGUMENTS |
429: +========================================================================*/
430: FUNCTION afterReport RETURN BOOLEAN IS
431: BEGIN
432: debug_log('>>CE_COPY_TRX_CODES_XML.afterReport');
433: DELETE ce_trx_codes_util_gt;
434: COMMIT;
435: debug_log('< 436: RETURN (TRUE);

Line 435: debug_log('<

431: BEGIN
432: debug_log('>>CE_COPY_TRX_CODES_XML.afterReport');
433: DELETE ce_trx_codes_util_gt;
434: COMMIT;
435: debug_log('< 436: RETURN (TRUE);
437: END afterReport;
438:
439: END CE_COPY_TRX_CODES_XML;

Line 439: END CE_COPY_TRX_CODES_XML;

435: debug_log('< 436: RETURN (TRUE);
437: END afterReport;
438:
439: END CE_COPY_TRX_CODES_XML;