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_PURGE dependencies on CEP_STANDARD

Line 2142: cep_standard.debug('>>CE_PURGE.restore_statements ');

2138: l_No_data_flag VARCHAR2(1):='Y';
2139:
2140: BEGIN
2141:
2142: cep_standard.debug('>>CE_PURGE.restore_statements ');
2143:
2144: put_starttag('Statement');
2145:
2146: FOR r_stmt IN C_restore_stmts LOOP

Line 2147: cep_standard.debug('>>CE_PURGE.restore_statements C_restore_stmts: '||G_Archive_Stat_Headers);

2143:
2144: put_starttag('Statement');
2145:
2146: FOR r_stmt IN C_restore_stmts LOOP
2147: cep_standard.debug('>>CE_PURGE.restore_statements C_restore_stmts: '||G_Archive_Stat_Headers);
2148: G_Archive_Stat_Lines:=0;
2149: G_Archive_Stat_Rec:=0;
2150: G_Archive_Stat_Errors:=0;
2151:

Line 2251: cep_standard.debug('>>CE_PURGE.restore_statements G_Archive_Stat_Headers: '||G_Archive_Stat_Headers);

2247: r_stmt.LAST_UPDATE_DATE);
2248:
2249: G_Archive_Stat_Headers := G_Archive_Stat_Headers + SQL%ROWCOUNT;
2250:
2251: cep_standard.debug('>>CE_PURGE.restore_statements G_Archive_Stat_Headers: '||G_Archive_Stat_Headers);
2252:
2253: INSERT INTO ce_statement_lines
2254: (STATEMENT_LINE_ID,
2255: STATEMENT_HEADER_ID,

Line 2343: cep_standard.debug('>>CE_PURGE.restore_statements G_Archive_Stat_Lines: '||G_Archive_Stat_Lines);

2339:
2340:
2341: G_Archive_Stat_Lines := SQL%ROWCOUNT;
2342:
2343: cep_standard.debug('>>CE_PURGE.restore_statements G_Archive_Stat_Lines: '||G_Archive_Stat_Lines);
2344:
2345: INSERT INTO ce_statement_reconcils_all
2346: (STATEMENT_LINE_ID,
2347: REFERENCE_TYPE,

Line 2395: cep_standard.debug('>>CE_PURGE.restore_statements G_Archive_Stat_Rec: '||G_Archive_Stat_Rec);

2391: WHERE statement_header_id = r_stmt.STATEMENT_HEADER_ID );
2392:
2393: G_Archive_Stat_Rec := SQL%ROWCOUNT;
2394:
2395: cep_standard.debug('>>CE_PURGE.restore_statements G_Archive_Stat_Rec: '||G_Archive_Stat_Rec);
2396:
2397: INSERT INTO ce_reconciliation_errors
2398: (STATEMENT_LINE_ID,
2399: MESSAGE_NAME,

Line 2416: cep_standard.debug('>>CE_PURGE.restore_statements G_Archive_Stat_Errors: '||G_Archive_Stat_Errors);

2412: WHERE statement_header_id = r_stmt.STATEMENT_HEADER_ID;
2413:
2414: G_Archive_Stat_Errors := SQL%ROWCOUNT;
2415:
2416: cep_standard.debug('>>CE_PURGE.restore_statements G_Archive_Stat_Errors: '||G_Archive_Stat_Errors);
2417:
2418: put_starttag('StmtRestored') ;
2419: put_element('BANK_ACCOUNT_NUM',l_bank_account_num);
2420: put_element('BANK_ACCOUNT_NAME',l_bank_account_name);

Line 2456: cep_standard.debug('Restore Statements >>DUP_VAL_ON_INDEX: '||r_stmt.BANK_ACCOUNT_ID||', '||r_stmt.STATEMENT_NUMBER);

2452: put_element('STATEMENT_NUMBER',r_stmt.STATEMENT_NUMBER);
2453: put_element('STATEMENT_DATE',r_stmt.STATEMENT_DATE);
2454: put_element('ERROR_MSG',fnd_message.get_string('CE','CE_PREV_IMPORT'));
2455: put_endtag('StmtErrors');
2456: cep_standard.debug('Restore Statements >>DUP_VAL_ON_INDEX: '||r_stmt.BANK_ACCOUNT_ID||', '||r_stmt.STATEMENT_NUMBER);
2457: G_Archive_Stat_Headers := G_Archive_Stat_Headers + 1;
2458: END;
2459: END LOOP;
2460:

Line 2467: cep_standard.debug('G_Archive_Stat_Headers : '||G_Archive_Stat_Headers);

2463: end IF;
2464:
2465: put_endtag('Statement');
2466:
2467: cep_standard.debug('G_Archive_Stat_Headers : '||G_Archive_Stat_Headers);
2468:
2469: END restore_statements;
2470:
2471: /* ---------------------------------------------------------------------

Line 2551: cep_standard.debug('>> restore_intraday_statements');

2547: l_No_data_flag VARCHAR2(1):='Y';
2548: BEGIN
2549:
2550: IF l_DEBUG in ('Y', 'C') THEN
2551: cep_standard.debug('>> restore_intraday_statements');
2552: END IF;
2553:
2554:
2555: Put_starttag('IntraStatements');

Line 2660: cep_standard.debug('>> G_Archive_Stat_Headers2: '||G_Archive_Stat_Headers2);

2656: G_Archive_Stat_Headers2 :=G_Archive_Stat_Headers2+ SQL%ROWCOUNT;
2657:
2658:
2659: IF l_DEBUG in ('Y', 'C') THEN
2660: cep_standard.debug('>> G_Archive_Stat_Headers2: '||G_Archive_Stat_Headers2);
2661: END IF;
2662:
2663: INSERT INTO ce_intra_stmt_lines
2664: (STATEMENT_LINE_ID,

Line 2791: cep_standard.debug('>> G_Archive_Stat_Lines2: '||G_Archive_Stat_Lines2);

2787:
2788: put_endtag('IntraStatements');
2789:
2790: IF l_DEBUG in ('Y', 'C') THEN
2791: cep_standard.debug('>> G_Archive_Stat_Lines2: '||G_Archive_Stat_Lines2);
2792: cep_standard.debug('< 2793: END IF;
2794:
2795:

Line 2792: cep_standard.debug('<

2788: put_endtag('IntraStatements');
2789:
2790: IF l_DEBUG in ('Y', 'C') THEN
2791: cep_standard.debug('>> G_Archive_Stat_Lines2: '||G_Archive_Stat_Lines2);
2792: cep_standard.debug('< 2793: END IF;
2794:
2795:
2796: END restore_intraday_statements;

Line 2880: cep_standard.debug('>>CE_PURGE.restore_interface '||p_intra_day_flag);

2876: l_No_data_flag VARCHAR2(1):='Y';
2877: BEGIN
2878:
2879: IF l_DEBUG in ('Y', 'C') THEN
2880: cep_standard.debug('>>CE_PURGE.restore_interface '||p_intra_day_flag);
2881: END IF;
2882:
2883: IF ( p_intra_day_flag = 'Y' ) THEN
2884: put_starttag('INTERFACE_INTRADAY');

Line 3112: cep_standard.debug('>> G_Archive_Inf_Lines: '||G_Archive_Inf_Lines);

3108: put_element('STATEMENT_DATE',r_interface.statement_DATE);
3109: put_element('PREV_INF_LINES',Nvl(G_Archive_Inf_Lines,0));
3110: put_endtag('PrevInfRestored');
3111: IF l_DEBUG in ('Y', 'C') THEN
3112: cep_standard.debug('>> G_Archive_Inf_Lines: '||G_Archive_Inf_Lines);
3113: END IF;
3114: ELSE
3115: G_Archive_Inf_Lines2 := SQL%ROWCOUNT;
3116: put_starttag('IntraInfRestored');

Line 3125: cep_standard.debug('>> G_Archive_Inf_Lines2: '||G_Archive_Inf_Lines2);

3121: put_element('STATEMENT_DATE',r_interface.statement_DATE);
3122: put_element('INTRA_INF_LINES',Nvl(G_Archive_Inf_Lines2,0));
3123: put_endtag('IntraInfRestored');
3124: IF l_DEBUG in ('Y', 'C') THEN
3125: cep_standard.debug('>> G_Archive_Inf_Lines2: '||G_Archive_Inf_Lines2);
3126: END IF;
3127: END IF;
3128:
3129: DELETE FROM ce_arch_interface_headers

Line 3140: cep_standard.debug('<

3136:
3137: EXCEPTION
3138: WHEN Dup_Val_On_Index THEN
3139: IF l_DEBUG in ('Y', 'C') THEN
3140: cep_standard.debug('< 3141: END IF;
3142:
3143: IF ( p_intra_day_flag = 'Y' ) THEN
3144: put_starttag('IntraInfErrors');

Line 3179: cep_standard.debug('<

3175: put_endtag('INTERFACE_PREVIOUS');
3176: END IF;
3177:
3178: IF l_DEBUG in ('Y', 'C') THEN
3179: cep_standard.debug('< 3180: END IF;
3181: END restore_interface;
3182:
3183: /* ---------------------------------------------------------------------

Line 3219: cep_standard.debug('>>CE_PURGE.restore_stmts');

3215:
3216: BEGIN
3217:
3218: IF l_DEBUG in ('Y', 'C') THEN
3219: cep_standard.debug('>>CE_PURGE.restore_stmts');
3220: END IF;
3221:
3222: set_arch_purge_counts;
3223: CEP_STANDARD.init_security;

Line 3223: CEP_STANDARD.init_security;

3219: cep_standard.debug('>>CE_PURGE.restore_stmts');
3220: END IF;
3221:
3222: set_arch_purge_counts;
3223: CEP_STANDARD.init_security;
3224:
3225: --
3226: -- If the statement_date parameter is NULL, we default to sysdate
3227: --

Line 3255: cep_standard.debug('>>CE_PURGE.restore_stmts G_Statement_type: '||G_Statement_type);

3251: G_Statement_type := 'BOTH';
3252: END IF;
3253:
3254: IF l_DEBUG in ('Y', 'C') THEN
3255: cep_standard.debug('>>CE_PURGE.restore_stmts G_Statement_type: '||G_Statement_type);
3256: cep_standard.debug('>>CE_PURGE.restore_stmts G_BANK_ACCOUNT_ID: '||G_BANK_ACCOUNT_ID);
3257: cep_standard.debug('>>CE_PURGE.restore_stmts G_BANK_BRANCH_ID: '||G_BANK_BRANCH_ID||' p_BANK_BRANCH_ID: '||p_BANK_BRANCH_ID);
3258: cep_standard.debug('>>CE_PURGE.restore_stmts G_STATEMENT_DATE_FROM: '||G_STATEMENT_DATE_FROM);
3259: cep_standard.debug('>>CE_PURGE.restore_stmts G_STATEMENT_DATE_TO: '||G_STATEMENT_DATE_TO);

Line 3256: cep_standard.debug('>>CE_PURGE.restore_stmts G_BANK_ACCOUNT_ID: '||G_BANK_ACCOUNT_ID);

3252: END IF;
3253:
3254: IF l_DEBUG in ('Y', 'C') THEN
3255: cep_standard.debug('>>CE_PURGE.restore_stmts G_Statement_type: '||G_Statement_type);
3256: cep_standard.debug('>>CE_PURGE.restore_stmts G_BANK_ACCOUNT_ID: '||G_BANK_ACCOUNT_ID);
3257: cep_standard.debug('>>CE_PURGE.restore_stmts G_BANK_BRANCH_ID: '||G_BANK_BRANCH_ID||' p_BANK_BRANCH_ID: '||p_BANK_BRANCH_ID);
3258: cep_standard.debug('>>CE_PURGE.restore_stmts G_STATEMENT_DATE_FROM: '||G_STATEMENT_DATE_FROM);
3259: cep_standard.debug('>>CE_PURGE.restore_stmts G_STATEMENT_DATE_TO: '||G_STATEMENT_DATE_TO);
3260: cep_standard.debug('>>CE_PURGE.restore_stmts G_hdr_int_status: '||G_hdr_int_status);

Line 3257: cep_standard.debug('>>CE_PURGE.restore_stmts G_BANK_BRANCH_ID: '||G_BANK_BRANCH_ID||' p_BANK_BRANCH_ID: '||p_BANK_BRANCH_ID);

3253:
3254: IF l_DEBUG in ('Y', 'C') THEN
3255: cep_standard.debug('>>CE_PURGE.restore_stmts G_Statement_type: '||G_Statement_type);
3256: cep_standard.debug('>>CE_PURGE.restore_stmts G_BANK_ACCOUNT_ID: '||G_BANK_ACCOUNT_ID);
3257: cep_standard.debug('>>CE_PURGE.restore_stmts G_BANK_BRANCH_ID: '||G_BANK_BRANCH_ID||' p_BANK_BRANCH_ID: '||p_BANK_BRANCH_ID);
3258: cep_standard.debug('>>CE_PURGE.restore_stmts G_STATEMENT_DATE_FROM: '||G_STATEMENT_DATE_FROM);
3259: cep_standard.debug('>>CE_PURGE.restore_stmts G_STATEMENT_DATE_TO: '||G_STATEMENT_DATE_TO);
3260: cep_standard.debug('>>CE_PURGE.restore_stmts G_hdr_int_status: '||G_hdr_int_status);
3261: END IF;

Line 3258: cep_standard.debug('>>CE_PURGE.restore_stmts G_STATEMENT_DATE_FROM: '||G_STATEMENT_DATE_FROM);

3254: IF l_DEBUG in ('Y', 'C') THEN
3255: cep_standard.debug('>>CE_PURGE.restore_stmts G_Statement_type: '||G_Statement_type);
3256: cep_standard.debug('>>CE_PURGE.restore_stmts G_BANK_ACCOUNT_ID: '||G_BANK_ACCOUNT_ID);
3257: cep_standard.debug('>>CE_PURGE.restore_stmts G_BANK_BRANCH_ID: '||G_BANK_BRANCH_ID||' p_BANK_BRANCH_ID: '||p_BANK_BRANCH_ID);
3258: cep_standard.debug('>>CE_PURGE.restore_stmts G_STATEMENT_DATE_FROM: '||G_STATEMENT_DATE_FROM);
3259: cep_standard.debug('>>CE_PURGE.restore_stmts G_STATEMENT_DATE_TO: '||G_STATEMENT_DATE_TO);
3260: cep_standard.debug('>>CE_PURGE.restore_stmts G_hdr_int_status: '||G_hdr_int_status);
3261: END IF;
3262:

Line 3259: cep_standard.debug('>>CE_PURGE.restore_stmts G_STATEMENT_DATE_TO: '||G_STATEMENT_DATE_TO);

3255: cep_standard.debug('>>CE_PURGE.restore_stmts G_Statement_type: '||G_Statement_type);
3256: cep_standard.debug('>>CE_PURGE.restore_stmts G_BANK_ACCOUNT_ID: '||G_BANK_ACCOUNT_ID);
3257: cep_standard.debug('>>CE_PURGE.restore_stmts G_BANK_BRANCH_ID: '||G_BANK_BRANCH_ID||' p_BANK_BRANCH_ID: '||p_BANK_BRANCH_ID);
3258: cep_standard.debug('>>CE_PURGE.restore_stmts G_STATEMENT_DATE_FROM: '||G_STATEMENT_DATE_FROM);
3259: cep_standard.debug('>>CE_PURGE.restore_stmts G_STATEMENT_DATE_TO: '||G_STATEMENT_DATE_TO);
3260: cep_standard.debug('>>CE_PURGE.restore_stmts G_hdr_int_status: '||G_hdr_int_status);
3261: END IF;
3262:
3263: IF (G_BANK_ACCOUNT_ID IS NOT NULL) THEN

Line 3260: cep_standard.debug('>>CE_PURGE.restore_stmts G_hdr_int_status: '||G_hdr_int_status);

3256: cep_standard.debug('>>CE_PURGE.restore_stmts G_BANK_ACCOUNT_ID: '||G_BANK_ACCOUNT_ID);
3257: cep_standard.debug('>>CE_PURGE.restore_stmts G_BANK_BRANCH_ID: '||G_BANK_BRANCH_ID||' p_BANK_BRANCH_ID: '||p_BANK_BRANCH_ID);
3258: cep_standard.debug('>>CE_PURGE.restore_stmts G_STATEMENT_DATE_FROM: '||G_STATEMENT_DATE_FROM);
3259: cep_standard.debug('>>CE_PURGE.restore_stmts G_STATEMENT_DATE_TO: '||G_STATEMENT_DATE_TO);
3260: cep_standard.debug('>>CE_PURGE.restore_stmts G_hdr_int_status: '||G_hdr_int_status);
3261: END IF;
3262:
3263: IF (G_BANK_ACCOUNT_ID IS NOT NULL) THEN
3264: SELECT bb.bank_name,

Line 3364: cep_standard.debug('<

3360: ROLLBACK;
3361: END IF;
3362:
3363: IF l_DEBUG in ('Y', 'C') THEN
3364: cep_standard.debug('< 3365: END IF;
3366:
3367: EXCEPTION WHEN OTHERS THEN
3368: IF l_DEBUG in ('Y', 'C') THEN

Line 3369: cep_standard.debug('<

3365: END IF;
3366:
3367: EXCEPTION WHEN OTHERS THEN
3368: IF l_DEBUG in ('Y', 'C') THEN
3369: cep_standard.debug('< 3370: END IF;
3371:
3372: put_endtag('RESTORE_REPORT');
3373: END restore_Process;