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.OKS_TAX_UTIL_PVT dependencies on FND_FILE

Line 2341: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting Concurrent Program: '|| G_PKG_NAME || '.' || l_module_name);

2337: l_module_name CONSTANT VARCHAR2(30) := 'TAX_MIGRATION';
2338:
2339: BEGIN
2340: RETCODE := 0; --0 for success, 1 for warning, 2 for error
2341: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting Concurrent Program: '|| G_PKG_NAME || '.' || l_module_name);
2342: FND_FILE.PUT_LINE(FND_FILE.LOG,'time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2343:
2344: --migrate the header level tax_exemption_id to exempt_certificate_number and exempt_reason_code
2345: --npalepu updating tax_code and tax_exemption_id to null for bug # 4908543

Line 2342: FND_FILE.PUT_LINE(FND_FILE.LOG,'time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));

2338:
2339: BEGIN
2340: RETCODE := 0; --0 for success, 1 for warning, 2 for error
2341: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting Concurrent Program: '|| G_PKG_NAME || '.' || l_module_name);
2342: FND_FILE.PUT_LINE(FND_FILE.LOG,'time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2343:
2344: --migrate the header level tax_exemption_id to exempt_certificate_number and exempt_reason_code
2345: --npalepu updating tax_code and tax_exemption_id to null for bug # 4908543
2346: UPDATE /*+ parallel(oks) */ OKS_K_HEADERS_B oks

Line 2357: FND_FILE.PUT_LINE(FND_FILE.LOG,'Finished migrating tax_exemption_id in OKS_K_HEADERS_B');

2353: WHERE oks.tax_exemption_id IS NOT NULL
2354: AND (oks.EXEMPT_CERTIFICATE_NUMBER IS NULL OR oks.EXEMPT_REASON_CODE IS NULL);
2355: --end npalepu
2356:
2357: FND_FILE.PUT_LINE(FND_FILE.LOG,'Finished migrating tax_exemption_id in OKS_K_HEADERS_B');
2358: FND_FILE.PUT_LINE(FND_FILE.LOG,'time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2359:
2360: /*npalepu added migration of tax_exemption_id to exempt_certificate_number and exempt_reason_code in oks_k_headers_bh table.
2361: updating tax_code and tax_exemption_id to null for bug # 4908543 */

Line 2358: FND_FILE.PUT_LINE(FND_FILE.LOG,'time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));

2354: AND (oks.EXEMPT_CERTIFICATE_NUMBER IS NULL OR oks.EXEMPT_REASON_CODE IS NULL);
2355: --end npalepu
2356:
2357: FND_FILE.PUT_LINE(FND_FILE.LOG,'Finished migrating tax_exemption_id in OKS_K_HEADERS_B');
2358: FND_FILE.PUT_LINE(FND_FILE.LOG,'time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2359:
2360: /*npalepu added migration of tax_exemption_id to exempt_certificate_number and exempt_reason_code in oks_k_headers_bh table.
2361: updating tax_code and tax_exemption_id to null for bug # 4908543 */
2362: UPDATE /*+ parallel(oks) */ OKS_K_HEADERS_BH oks

Line 2373: FND_FILE.PUT_LINE(FND_FILE.LOG,'Finished migrating tax_exemption_id in OKS_K_HEADERS_BH');

2369: WHERE oks.tax_exemption_id IS NOT NULL
2370: AND (oks.EXEMPT_CERTIFICATE_NUMBER IS NULL OR oks.EXEMPT_REASON_CODE IS NULL);
2371: --end npalepu
2372:
2373: FND_FILE.PUT_LINE(FND_FILE.LOG,'Finished migrating tax_exemption_id in OKS_K_HEADERS_BH');
2374: FND_FILE.PUT_LINE(FND_FILE.LOG,'time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2375: --end npalepu
2376:
2377: COMMIT;

Line 2374: FND_FILE.PUT_LINE(FND_FILE.LOG,'time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));

2370: AND (oks.EXEMPT_CERTIFICATE_NUMBER IS NULL OR oks.EXEMPT_REASON_CODE IS NULL);
2371: --end npalepu
2372:
2373: FND_FILE.PUT_LINE(FND_FILE.LOG,'Finished migrating tax_exemption_id in OKS_K_HEADERS_BH');
2374: FND_FILE.PUT_LINE(FND_FILE.LOG,'time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
2375: --end npalepu
2376:
2377: COMMIT;
2378:

Line 2379: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Concurrent Program - Success, time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') ||' ,retcode='|| retcode);

2375: --end npalepu
2376:
2377: COMMIT;
2378:
2379: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Concurrent Program - Success, time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') ||' ,retcode='|| retcode);
2380:
2381: EXCEPTION
2382: WHEN OTHERS THEN
2383: retcode := 2;

Line 2385: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Concurrent Program - Error, time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') ||' ,retcode='|| retcode);

2381: EXCEPTION
2382: WHEN OTHERS THEN
2383: retcode := 2;
2384: errbuf := SQLCODE || SQLERRM;
2385: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Concurrent Program - Error, time: '|| to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') ||' ,retcode='|| retcode);
2386:
2387: END TAX_MIGRATION;
2388:
2389:

Line 2400: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Tax_BMGR ');

2396: BEGIN
2397: --
2398: -- Manager processing for OKS_K_LINES_B table
2399: --
2400: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Tax_BMGR ');
2401: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
2402: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2403:
2404: fnd_file.put_line(FND_FILE.LOG, 'starting oks_k_lines_b update worker ');

Line 2401: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);

2397: --
2398: -- Manager processing for OKS_K_LINES_B table
2399: --
2400: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Tax_BMGR ');
2401: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
2402: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2403:
2404: fnd_file.put_line(FND_FILE.LOG, 'starting oks_k_lines_b update worker ');
2405:

Line 2402: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);

2398: -- Manager processing for OKS_K_LINES_B table
2399: --
2400: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Tax_BMGR ');
2401: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
2402: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2403:
2404: fnd_file.put_line(FND_FILE.LOG, 'starting oks_k_lines_b update worker ');
2405:
2406: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,

Line 2404: fnd_file.put_line(FND_FILE.LOG, 'starting oks_k_lines_b update worker ');

2400: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Tax_BMGR ');
2401: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
2402: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2403:
2404: fnd_file.put_line(FND_FILE.LOG, 'starting oks_k_lines_b update worker ');
2405:
2406: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,
2407: X_retcode,
2408: 'OKS',

Line 2413: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);

2409: 'OKSTAXBWKR',
2410: P_batch_size,
2411: P_Num_Workers);
2412:
2413: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);
2414: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);
2415:
2416: END Update_Tax_BMGR;
2417:

Line 2414: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);

2410: P_batch_size,
2411: P_Num_Workers);
2412:
2413: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);
2414: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);
2415:
2416: END Update_Tax_BMGR;
2417:
2418: PROCEDURE Update_Tax_HMGR(X_errbuf out NOCOPY varchar2,

Line 2427: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Tax_HMGR ');

2423: BEGIN
2424: --
2425: -- Manager processing for OKS_K_LINES_BH table
2426: --
2427: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Tax_HMGR ');
2428: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
2429: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2430:
2431: fnd_file.put_line(FND_FILE.LOG, 'starting oks_k_lines_bh update worker ');

Line 2428: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);

2424: --
2425: -- Manager processing for OKS_K_LINES_BH table
2426: --
2427: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Tax_HMGR ');
2428: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
2429: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2430:
2431: fnd_file.put_line(FND_FILE.LOG, 'starting oks_k_lines_bh update worker ');
2432:

Line 2429: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);

2425: -- Manager processing for OKS_K_LINES_BH table
2426: --
2427: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Tax_HMGR ');
2428: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
2429: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2430:
2431: fnd_file.put_line(FND_FILE.LOG, 'starting oks_k_lines_bh update worker ');
2432:
2433: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,

Line 2431: fnd_file.put_line(FND_FILE.LOG, 'starting oks_k_lines_bh update worker ');

2427: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Tax_HMGR ');
2428: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
2429: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2430:
2431: fnd_file.put_line(FND_FILE.LOG, 'starting oks_k_lines_bh update worker ');
2432:
2433: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,
2434: X_retcode,
2435: 'OKS',

Line 2440: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);

2436: 'OKSTAXHWKR',
2437: P_batch_size,
2438: P_Num_Workers);
2439:
2440: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);
2441: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);
2442:
2443: END Update_Tax_HMGR;
2444:

Line 2441: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);

2437: P_batch_size,
2438: P_Num_Workers);
2439:
2440: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);
2441: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);
2442:
2443: END Update_Tax_HMGR;
2444:
2445: /*

Line 2483: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKS_K_LINES_B table ');

2479: then
2480: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
2481: end if;
2482:
2483: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKS_K_LINES_B table ');
2484: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
2485: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2486:
2487: --

Line 2484: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);

2480: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
2481: end if;
2482:
2483: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKS_K_LINES_B table ');
2484: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
2485: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2486:
2487: --
2488: -- Worker processing

Line 2485: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);

2481: end if;
2482:
2483: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKS_K_LINES_B table ');
2484: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
2485: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2486:
2487: --
2488: -- Worker processing
2489: --

Line 2573: fnd_file.put_line(FND_FILE.LOG,'Upgrade for tax columns in OKS_K_LINES_B table completed successfully');

2569: l_any_rows_to_process,
2570: P_batch_size,
2571: FALSE);
2572: end loop;
2573: fnd_file.put_line(FND_FILE.LOG,'Upgrade for tax columns in OKS_K_LINES_B table completed successfully');
2574: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
2575: X_errbuf := ' ';
2576: EXCEPTION
2577: WHEN OTHERS THEN

Line 2580: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);

2576: EXCEPTION
2577: WHEN OTHERS THEN
2578: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
2579: X_errbuf := SQLERRM;
2580: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);
2581: fnd_file.put_line(FND_FILE.LOG,' ');
2582: raise;
2583: END;
2584: END Update_Tax_BWKR;

Line 2581: fnd_file.put_line(FND_FILE.LOG,' ');

2577: WHEN OTHERS THEN
2578: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
2579: X_errbuf := SQLERRM;
2580: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);
2581: fnd_file.put_line(FND_FILE.LOG,' ');
2582: raise;
2583: END;
2584: END Update_Tax_BWKR;
2585:

Line 2624: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKS_K_LINES_BH table ');

2620: then
2621: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
2622: end if;
2623:
2624: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKS_K_LINES_BH table ');
2625: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
2626: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2627:
2628: --

Line 2625: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);

2621: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
2622: end if;
2623:
2624: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKS_K_LINES_BH table ');
2625: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
2626: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2627:
2628: --
2629: -- Worker processing

Line 2626: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);

2622: end if;
2623:
2624: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKS_K_LINES_BH table ');
2625: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
2626: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
2627:
2628: --
2629: -- Worker processing
2630: --

Line 2713: fnd_file.put_line(FND_FILE.LOG,'Upgrade for tax columns in OKS_K_LINES_BH table completed successfully');

2709: l_any_rows_to_process,
2710: P_batch_size,
2711: FALSE);
2712: end loop;
2713: fnd_file.put_line(FND_FILE.LOG,'Upgrade for tax columns in OKS_K_LINES_BH table completed successfully');
2714: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
2715: X_errbuf := ' ';
2716: EXCEPTION
2717: WHEN OTHERS THEN

Line 2720: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);

2716: EXCEPTION
2717: WHEN OTHERS THEN
2718: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
2719: X_errbuf := SQLERRM;
2720: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);
2721: fnd_file.put_line(FND_FILE.LOG,' ');
2722: raise;
2723: END;
2724: END Update_Tax_HWKR;

Line 2721: fnd_file.put_line(FND_FILE.LOG,' ');

2717: WHEN OTHERS THEN
2718: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
2719: X_errbuf := SQLERRM;
2720: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);
2721: fnd_file.put_line(FND_FILE.LOG,' ');
2722: raise;
2723: END;
2724: END Update_Tax_HWKR;
2725: --end npalepu