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

Line 1430: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Creating Referral Category for referral name: ' || l_ref_name);

1426: l_ref_name := SUBSTR (l_ref_url, 1,LENGTH (l_ref_url));
1427: ELSE
1428: l_ref_name := SUBSTR (l_ref_url, 1,INSTR(l_ref_url, '/',1,3)-1 );
1429: END IF;
1430: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Creating Referral Category for referral name: ' || l_ref_name);
1431:
1432: IBW_REFERRAL_PVT.INSERT_row(x_ref_id,l_ref_name,l_ref_name,l_error_message);
1433: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1434: THEN

Line 1873: -- Procedure printLog uses FND_FILE.PUT_LINE to write in the

1869: errbuf := ' errbuf' || ' '||SQLCODE||'-'||SQLERRM;
1870: END offline_engine;
1871:
1872: -- ===========================================================
1873: -- Procedure printLog uses FND_FILE.PUT_LINE to write in the
1874: -- "log" file of a concurrent program
1875: -- ===========================================================
1876: PROCEDURE printLog(p_message IN VARCHAR2)
1877: IS

Line 1880: FND_FILE.PUT_LINE(FND_FILE.LOG,p_message);

1876: PROCEDURE printLog(p_message IN VARCHAR2)
1877: IS
1878: pragma AUTONOMOUS_TRANSACTION;
1879: BEGIN
1880: FND_FILE.PUT_LINE(FND_FILE.LOG,p_message);
1881: commit;
1882: EXCEPTION
1883: WHEN OTHERS THEN
1884: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception :'||sqlerrm);

Line 1884: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception :'||sqlerrm);

1880: FND_FILE.PUT_LINE(FND_FILE.LOG,p_message);
1881: commit;
1882: EXCEPTION
1883: WHEN OTHERS THEN
1884: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception :'||sqlerrm);
1885: END printLog;
1886:
1887: -- ===========================================================
1888: -- Procedure printOutput uses FND_FILE.PUT_LINE to write in the

Line 1888: -- Procedure printOutput uses FND_FILE.PUT_LINE to write in the

1884: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception :'||sqlerrm);
1885: END printLog;
1886:
1887: -- ===========================================================
1888: -- Procedure printOutput uses FND_FILE.PUT_LINE to write in the
1889: -- "Output" file of a concurrent program
1890: -- ===========================================================
1891: PROCEDURE printOutput(p_message IN VARCHAR2)
1892: IS

Line 1895: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_message);

1891: PROCEDURE printOutput(p_message IN VARCHAR2)
1892: IS
1893: pragma AUTONOMOUS_TRANSACTION;
1894: BEGIN
1895: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_message);
1896: printLog(p_message);
1897: commit;
1898: EXCEPTION
1899: WHEN OTHERS THEN

Line 1900: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception :'||sqlerrm);

1896: printLog(p_message);
1897: commit;
1898: EXCEPTION
1899: WHEN OTHERS THEN
1900: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception :'||sqlerrm);
1901: END printOutput;
1902:
1903:
1904: --=================================================================================

Line 2107: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Page created page id ' || pageid);

2103: );
2104: END IF;
2105: pageid := x_page_id;
2106: END IF;
2107: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Page created page id ' || pageid);
2108: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2109: fnd_message.set_name('IBW','IBW_OE_PAGE_NOT_FOUND');
2110: fnd_message.set_token('PAGE_NAME',pagename);
2111: fnd_log.string(FND_LOG.LEVEL_EVENT,'IBW.PLSQL.IBWOE_PVT',fnd_message.get);

Line 2112: fnd_file.put_line(fnd_file.log,fnd_message.get);

2108: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2109: fnd_message.set_name('IBW','IBW_OE_PAGE_NOT_FOUND');
2110: fnd_message.set_token('PAGE_NAME',pagename);
2111: fnd_log.string(FND_LOG.LEVEL_EVENT,'IBW.PLSQL.IBWOE_PVT',fnd_message.get);
2112: fnd_file.put_line(fnd_file.log,fnd_message.get);
2113: END IF;
2114: END IF;
2115: pageid := pageid;
2116: IF pageid is null then

Line 2123: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception :'||sqlerrm);

2119: EXCEPTION
2120: WHEN NO_DATA_FOUND THEN
2121: pageid := -1;
2122: WHEN OTHERS THEN
2123: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception :'||sqlerrm);
2124: pageid := -1;
2125: END createpage;
2126:
2127:

Line 2179: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception :'||sqlerrm);

2175: printLog('Done Referral Category Concurrent Program');
2176: printOutput('Recategorization of Referrals successful');
2177: EXCEPTION
2178: WHEN OTHERS THEN
2179: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception :'||sqlerrm);
2180: retcode := 2;
2181: END recategorize_referrals;
2182:
2183: --------------------------------------------------------------------------------------------------

Line 2287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in Context Load Program - NONE Context :' || sqlerrm);

2283: WHEN OTHERS THEN
2284: ROLLBACK;
2285: --dbms_output.put_line('CONTEXT_LOAD:' || sqlerrm);
2286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in Context Load Program - NONE Context :' || sqlerrm);
2288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Context Load Program Return Status: - NONE Context' || x_return_status );
2289: END;
2290:
2291:

Line 2288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Context Load Program Return Status: - NONE Context' || x_return_status );

2284: ROLLBACK;
2285: --dbms_output.put_line('CONTEXT_LOAD:' || sqlerrm);
2286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in Context Load Program - NONE Context :' || sqlerrm);
2288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Context Load Program Return Status: - NONE Context' || x_return_status );
2289: END;
2290:
2291:
2292: -- For populating the IBW_CONTEXT_INTERFACE_B table with the Section related data

Line 2363: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in Context Load Program-Merge of ibw_context_interface_b :' || sqlerrm);

2359: WHEN OTHERS THEN
2360: ROLLBACK;
2361: --dbms_output.put_line('CONTEXT_LOAD:' || sqlerrm);
2362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2363: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in Context Load Program-Merge of ibw_context_interface_b :' || sqlerrm);
2364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Context Load Program Return Status 1:' || x_return_status );
2365:
2366: end;
2367:

Line 2364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Context Load Program Return Status 1:' || x_return_status );

2360: ROLLBACK;
2361: --dbms_output.put_line('CONTEXT_LOAD:' || sqlerrm);
2362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2363: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in Context Load Program-Merge of ibw_context_interface_b :' || sqlerrm);
2364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Context Load Program Return Status 1:' || x_return_status );
2365:
2366: end;
2367:
2368: -- For populating the IBW_CONTEXT_INTERFACE_TL table

Line 2436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in Context Load Program -Merge of ibw_context_interface_tl :' || sqlerrm);

2432: WHEN OTHERS THEN
2433: ROLLBACK;
2434: --dbms_output.put_line('CONTEXT_LOAD:' || sqlerrm);
2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in Context Load Program -Merge of ibw_context_interface_tl :' || sqlerrm);
2437: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Context Load Program Return Status 2:' || x_return_status );
2438: end;
2439: COMMIT;
2440:

Line 2437: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Context Load Program Return Status 2:' || x_return_status );

2433: ROLLBACK;
2434: --dbms_output.put_line('CONTEXT_LOAD:' || sqlerrm);
2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in Context Load Program -Merge of ibw_context_interface_tl :' || sqlerrm);
2437: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Context Load Program Return Status 2:' || x_return_status );
2438: end;
2439: COMMIT;
2440:
2441: EXCEPTION

Line 2447: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in Context Load Program :' || sqlerrm);

2443: WHEN OTHERS THEN
2444: ROLLBACK;
2445: --dbms_output.put_line('CONTEXT_LOAD:' || sqlerrm);
2446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2447: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in Context Load Program :' || sqlerrm);
2448: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Context Load Program Return Status:' || x_return_status );
2449: END CONTEXT_LOAD;
2450:
2451: END IBW_OE_PVT;

Line 2448: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Context Load Program Return Status:' || x_return_status );

2444: ROLLBACK;
2445: --dbms_output.put_line('CONTEXT_LOAD:' || sqlerrm);
2446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2447: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in Context Load Program :' || sqlerrm);
2448: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Context Load Program Return Status:' || x_return_status );
2449: END CONTEXT_LOAD;
2450:
2451: END IBW_OE_PVT;