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.

[Home] [Help]

APPS.IBY_CREDITCARD_PKG dependencies on FND_FILE

Line 2313: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Enter..');

2309:
2310: l_dbg_mod VARCHAR2(100) := 'iby.plsql.IBY_CREDITCARD_PKG' || '.' || 'Upgrade_Risky_Instruments';
2311:
2312: BEGIN
2313: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Enter..');
2314: no_cc := 0;
2315: no_acct := 0;
2316: --Get each risky instrument
2317: FOR risky_instr_rec IN get_risky_instruments

Line 2376: fnd_file.put_line(fnd_file.log,l_dbg_mod||': No. of cards updated: '|| no_cc);

2372: END LOOP;
2373: -- DBMS_OUTPUT.PUT_LINE('complete..: ');
2374: -- DBMS_OUTPUT.PUT_LINE('No. of cards updated: '|| no_cc);
2375: -- DBMS_OUTPUT.PUT_LINE('No. of accounts updated: '|| no_acct);
2376: fnd_file.put_line(fnd_file.log,l_dbg_mod||': No. of cards updated: '|| no_cc);
2377: fnd_file.put_line(fnd_file.log,l_dbg_mod||': No. of accounts updated: '|| no_acct);
2378: IF FND_API.to_Boolean( p_commit ) THEN
2379: COMMIT;
2380: END IF;

Line 2377: fnd_file.put_line(fnd_file.log,l_dbg_mod||': No. of accounts updated: '|| no_acct);

2373: -- DBMS_OUTPUT.PUT_LINE('complete..: ');
2374: -- DBMS_OUTPUT.PUT_LINE('No. of cards updated: '|| no_cc);
2375: -- DBMS_OUTPUT.PUT_LINE('No. of accounts updated: '|| no_acct);
2376: fnd_file.put_line(fnd_file.log,l_dbg_mod||': No. of cards updated: '|| no_cc);
2377: fnd_file.put_line(fnd_file.log,l_dbg_mod||': No. of accounts updated: '|| no_acct);
2378: IF FND_API.to_Boolean( p_commit ) THEN
2379: COMMIT;
2380: END IF;
2381: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exit.');

Line 2381: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exit.');

2377: fnd_file.put_line(fnd_file.log,l_dbg_mod||': No. of accounts updated: '|| no_acct);
2378: IF FND_API.to_Boolean( p_commit ) THEN
2379: COMMIT;
2380: END IF;
2381: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exit.');
2382: EXCEPTION
2383: WHEN others THEN
2384: -- DBMS_OUTPUT.PUT_LINE('SQLCODE is: ' || SQLCODE);
2385: -- DBMS_OUTPUT.PUT_LINE('SQLERRM is: ' || sqlerrm);

Line 2387: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exception thrown: '|| SQLERRM);

2383: WHEN others THEN
2384: -- DBMS_OUTPUT.PUT_LINE('SQLCODE is: ' || SQLCODE);
2385: -- DBMS_OUTPUT.PUT_LINE('SQLERRM is: ' || sqlerrm);
2386: ROLLBACK;
2387: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exception thrown: '|| SQLERRM);
2388: END Upgrade_Risky_Instruments;
2389:
2390: PROCEDURE Purge_Sensitive_Data
2391: (x_errbuf OUT NOCOPY VARCHAR2,

Line 2408: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Enter.');

2404: l_dev_phase VARCHAR2(30);
2405: l_dev_status VARCHAR2(30);
2406: l_message VARCHAR2(500);
2407: BEGIN
2408: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Enter.');
2409: req_id := fnd_global.CONC_REQUEST_ID;
2410: BEGIN
2411: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Invoking APXCCUPGMGR. Timestamp: '|| TO_CHAR(systimestamp,'SSSSS.FF'));
2412: BEGIN

Line 2411: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Invoking APXCCUPGMGR. Timestamp: '|| TO_CHAR(systimestamp,'SSSSS.FF'));

2407: BEGIN
2408: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Enter.');
2409: req_id := fnd_global.CONC_REQUEST_ID;
2410: BEGIN
2411: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Invoking APXCCUPGMGR. Timestamp: '|| TO_CHAR(systimestamp,'SSSSS.FF'));
2412: BEGIN
2413: x_req_id := fnd_request.submit_request(
2414: APPLICATION=>'SQLAP',
2415: PROGRAM=>'APXCCUPGMGR',

Line 2427: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Request_id of the APXCCUPGMGR instance = '||x_req_id||'. Timestamp: '|| TO_CHAR(systimestamp,'SSSSS.FF'));

2423: -- the 1st CP (APXCCUPGMGR) completes.
2424: -- Need to commit before waiting for the CP completion
2425: COMMIT;
2426: END;
2427: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Request_id of the APXCCUPGMGR instance = '||x_req_id||'. Timestamp: '|| TO_CHAR(systimestamp,'SSSSS.FF'));
2428: l_call_status := fnd_concurrent.wait_for_request(x_req_id,60,0,l_phase,l_status,l_dev_phase,l_dev_status,l_message);
2429:
2430: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Invoking APXCCTRXUPG. Timestamp: '|| TO_CHAR(systimestamp,'SSSSS.FF'));
2431: BEGIN

Line 2430: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Invoking APXCCTRXUPG. Timestamp: '|| TO_CHAR(systimestamp,'SSSSS.FF'));

2426: END;
2427: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Request_id of the APXCCUPGMGR instance = '||x_req_id||'. Timestamp: '|| TO_CHAR(systimestamp,'SSSSS.FF'));
2428: l_call_status := fnd_concurrent.wait_for_request(x_req_id,60,0,l_phase,l_status,l_dev_phase,l_dev_status,l_message);
2429:
2430: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Invoking APXCCTRXUPG. Timestamp: '|| TO_CHAR(systimestamp,'SSSSS.FF'));
2431: BEGIN
2432: x_req_id := fnd_request.submit_request(
2433: APPLICATION=>'SQLAP',
2434: PROGRAM=>'APXCCTRXUPGMGR',

Line 2441: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Request_id of the APXCCTRXUPGMGR instance = '||x_req_id||'. Timestamp: '|| TO_CHAR(systimestamp,'SSSSS.FF'));

2437: ARGUMENT1=>x_batch_size,
2438: ARGUMENT2=>x_num_workers,
2439: ARGUMENT3=>req_id);
2440: END;
2441: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Request_id of the APXCCTRXUPGMGR instance = '||x_req_id||'. Timestamp: '|| TO_CHAR(systimestamp,'SSSSS.FF'));
2442:
2443: EXCEPTION
2444: WHEN OTHERS THEN
2445: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exception thrown during OIE module execution! '|| SQLERRM);

Line 2445: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exception thrown during OIE module execution! '|| SQLERRM);

2441: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Request_id of the APXCCTRXUPGMGR instance = '||x_req_id||'. Timestamp: '|| TO_CHAR(systimestamp,'SSSSS.FF'));
2442:
2443: EXCEPTION
2444: WHEN OTHERS THEN
2445: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exception thrown during OIE module execution! '|| SQLERRM);
2446: END;
2447:
2448: -- Invoke the AP Upgrade routine
2449: -- Signature of the AP routine is as follows

Line 2455: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Invoking AP_CARDS_PKG.UPG_HISTORICAL_TRANSACTIONS. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));

2451: -- (errbuf => x_errbuf,
2452: -- retcode => x_retcode
2453: -- );
2454: BEGIN
2455: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Invoking AP_CARDS_PKG.UPG_HISTORICAL_TRANSACTIONS. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2456: plsql_block := 'CALL AP_CARDS_PKG.UPG_HISTORICAL_TRANSACTIONS(:1,:2)';
2457: EXECUTE IMMEDIATE plsql_block USING OUT x_errbuf, OUT x_retcode;
2458: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Return status frm AP_CARDS_PKG.UPG_HISTORICAL_TRANSACTIONS: '||x_retcode||'. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2459: EXCEPTION

Line 2458: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Return status frm AP_CARDS_PKG.UPG_HISTORICAL_TRANSACTIONS: '||x_retcode||'. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));

2454: BEGIN
2455: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Invoking AP_CARDS_PKG.UPG_HISTORICAL_TRANSACTIONS. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2456: plsql_block := 'CALL AP_CARDS_PKG.UPG_HISTORICAL_TRANSACTIONS(:1,:2)';
2457: EXECUTE IMMEDIATE plsql_block USING OUT x_errbuf, OUT x_retcode;
2458: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Return status frm AP_CARDS_PKG.UPG_HISTORICAL_TRANSACTIONS: '||x_retcode||'. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2459: EXCEPTION
2460: WHEN OTHERS THEN
2461: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exception thrown during AP_CARDS_PKG.UPG_HISTORICAL_TRANSACTIONS invocation. '|| SQLERRM);
2462: END;

Line 2461: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exception thrown during AP_CARDS_PKG.UPG_HISTORICAL_TRANSACTIONS invocation. '|| SQLERRM);

2457: EXECUTE IMMEDIATE plsql_block USING OUT x_errbuf, OUT x_retcode;
2458: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Return status frm AP_CARDS_PKG.UPG_HISTORICAL_TRANSACTIONS: '||x_retcode||'. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2459: EXCEPTION
2460: WHEN OTHERS THEN
2461: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exception thrown during AP_CARDS_PKG.UPG_HISTORICAL_TRANSACTIONS invocation. '|| SQLERRM);
2462: END;
2463:
2464: -- Invoke ASO Upgrade routine
2465: -- Signature of the AP routine is as follows

Line 2468: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Invoking ASO_PAYMENT_INT.PURGE_ASO_PAYMENTS_DATA. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));

2464: -- Invoke ASO Upgrade routine
2465: -- Signature of the AP routine is as follows
2466: -- ASO_PAYMENT_INT.PURGE_ASO_PAYMENTS_DATA
2467: BEGIN
2468: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Invoking ASO_PAYMENT_INT.PURGE_ASO_PAYMENTS_DATA. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2469: plsql_block := 'CALL ASO_PAYMENT_INT.PURGE_ASO_PAYMENTS_DATA()';
2470: EXECUTE IMMEDIATE plsql_block;
2471: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Return status frm ASO_PAYMENT_INT.PURGE_ASO_PAYMENTS_DATA: '||x_retcode||'. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2472: EXCEPTION

Line 2471: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Return status frm ASO_PAYMENT_INT.PURGE_ASO_PAYMENTS_DATA: '||x_retcode||'. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));

2467: BEGIN
2468: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Invoking ASO_PAYMENT_INT.PURGE_ASO_PAYMENTS_DATA. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2469: plsql_block := 'CALL ASO_PAYMENT_INT.PURGE_ASO_PAYMENTS_DATA()';
2470: EXECUTE IMMEDIATE plsql_block;
2471: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Return status frm ASO_PAYMENT_INT.PURGE_ASO_PAYMENTS_DATA: '||x_retcode||'. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2472: EXCEPTION
2473: WHEN OTHERS THEN
2474: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exception thrown during ASO_PAYMENT_INT.PURGE_ASO_PAYMENTS_DATA invocation. '|| SQLERRM);
2475: END;

Line 2474: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exception thrown during ASO_PAYMENT_INT.PURGE_ASO_PAYMENTS_DATA invocation. '|| SQLERRM);

2470: EXECUTE IMMEDIATE plsql_block;
2471: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Return status frm ASO_PAYMENT_INT.PURGE_ASO_PAYMENTS_DATA: '||x_retcode||'. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2472: EXCEPTION
2473: WHEN OTHERS THEN
2474: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exception thrown during ASO_PAYMENT_INT.PURGE_ASO_PAYMENTS_DATA invocation. '|| SQLERRM);
2475: END;
2476:
2477: -- Upgrade the data in IBY_IRF_RISKY_INSTR
2478: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Upgrading Data in IBY_IRF_RISKY_INSTR. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));

Line 2478: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Upgrading Data in IBY_IRF_RISKY_INSTR. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));

2474: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exception thrown during ASO_PAYMENT_INT.PURGE_ASO_PAYMENTS_DATA invocation. '|| SQLERRM);
2475: END;
2476:
2477: -- Upgrade the data in IBY_IRF_RISKY_INSTR
2478: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Upgrading Data in IBY_IRF_RISKY_INSTR. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2479: Upgrade_Risky_Instruments('T');
2480: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Finshed Upgrading Data in IBY_IRF_RISKY_INSTR. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2481: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exit.');
2482:

Line 2480: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Finshed Upgrading Data in IBY_IRF_RISKY_INSTR. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));

2476:
2477: -- Upgrade the data in IBY_IRF_RISKY_INSTR
2478: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Upgrading Data in IBY_IRF_RISKY_INSTR. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2479: Upgrade_Risky_Instruments('T');
2480: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Finshed Upgrading Data in IBY_IRF_RISKY_INSTR. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2481: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exit.');
2482:
2483:
2484: END Purge_Sensitive_Data;

Line 2481: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exit.');

2477: -- Upgrade the data in IBY_IRF_RISKY_INSTR
2478: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Upgrading Data in IBY_IRF_RISKY_INSTR. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2479: Upgrade_Risky_Instruments('T');
2480: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Finshed Upgrading Data in IBY_IRF_RISKY_INSTR. Timestamp: '||TO_CHAR(systimestamp,'SSSSS.FF'));
2481: fnd_file.put_line(fnd_file.log,l_dbg_mod||': Exit.');
2482:
2483:
2484: END Purge_Sensitive_Data;
2485: