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

Line 491: FND_FILE.close;

487: log('Error: Aborting Location Service');
488: ROLLBACK TO address_validation_pub;
489: Retcode := 2;
490: Errbuf := logerror(SQLERRM);
491: FND_FILE.close;
492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
493: log('Error: Aborting Location Service');
494: ROLLBACK TO address_validation_pub;
495: Retcode := 2;

Line 497: FND_FILE.close;

493: log('Error: Aborting Location Service');
494: ROLLBACK TO address_validation_pub;
495: Retcode := 2;
496: Errbuf := logerror(SQLERRM);
497: FND_FILE.close;
498: WHEN OTHERS THEN
499: log('Error: Aborting Location Service');
500: ROLLBACK TO address_validation_pub;
501: Retcode := 2;

Line 503: FND_FILE.close;

499: log('Error: Aborting Location Service');
500: ROLLBACK TO address_validation_pub;
501: Retcode := 2;
502: Errbuf := logerror(SQLERRM);
503: FND_FILE.close;
504: END address_validation;
505:
506: -----------------------------------------------------------------------
507: -- Called from address validation conc program (ARHADDRV)

Line 602: FND_FILE.close;

598: log('Error: Aborting Location Service at worker level');
599: ROLLBACK TO address_validation_w_pub;
600: Retcode := 2;
601: Errbuf := logerror(SQLERRM);
602: FND_FILE.close;
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
604: log('Error: Aborting Location Service at worker level');
605: ROLLBACK TO address_validation_w_pub;
606: Retcode := 2;

Line 608: FND_FILE.close;

604: log('Error: Aborting Location Service at worker level');
605: ROLLBACK TO address_validation_w_pub;
606: Retcode := 2;
607: Errbuf := logerror(SQLERRM);
608: FND_FILE.close;
609: WHEN OTHERS THEN
610: log('Error: Aborting Location Service at worker level');
611: ROLLBACK TO address_validation_w_pub;
612: Retcode := 2;

Line 614: FND_FILE.close;

610: log('Error: Aborting Location Service at worker level');
611: ROLLBACK TO address_validation_w_pub;
612: Retcode := 2;
613: Errbuf := logerror(SQLERRM);
614: FND_FILE.close;
615: END address_validation_worker;
616:
617: -----------------------------------------------------------------------
618: -- Called from function rule outdoc_rule

Line 1309: FND_FILE.close;

1305:
1306: EXCEPTION
1307: WHEN FND_API.G_EXC_ERROR THEN
1308: log('Error: Aborting Location Service at submit request: '||p_adapter_log_id);
1309: FND_FILE.close;
1310: -- Retcode := 2;
1311: -- Errbuf := logerror(SQLERRM);
1312:
1313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1315: FND_FILE.close;

1311: -- Errbuf := logerror(SQLERRM);
1312:
1313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1314: log('Error: Aborting Location Service at submit request: '||p_adapter_log_id);
1315: FND_FILE.close;
1316: -- Retcode := 2;
1317: -- Errbuf := logerror(SQLERRM);
1318:
1319: WHEN OTHERS THEN

Line 1322: FND_FILE.close;

1318:
1319: WHEN OTHERS THEN
1320: log('Error: Aborting Location Service at submit request: '||p_adapter_log_id);
1321: log('SQL Error: '||SQLERRM);
1322: FND_FILE.close;
1323: -- Retcode := 2;
1324: -- Errbuf := logerror(SQLERRM);
1325: */
1326: END submit_addrval_request;

Line 1592: --FND_FILE.close;

1588: Utl_Http.Set_Detailed_Excp_Support ( enable=>false )
1589: And it is NEVER raised after calling with enable=>true */
1590: WHEN UTL_HTTP.REQUEST_FAILED THEN
1591: log('REQUEST_FAILED: ' || UTL_HTTP.GET_DETAILED_SQLERRM);
1592: --FND_FILE.close;
1593: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');
1594: RAISE FND_API.G_EXC_ERROR;
1595:
1596: -- raised by URL http://xxx.oracle.com/

Line 1599: --FND_FILE.close;

1595:
1596: -- raised by URL http://xxx.oracle.com/
1597: WHEN UTL_HTTP.HTTP_SERVER_ERROR THEN
1598: log('HTTP_SERVER_ERROR: ' || UTL_HTTP.GET_DETAILED_SQLERRM);
1599: --FND_FILE.close;
1600: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');
1601: RAISE FND_API.G_EXC_ERROR;
1602:
1603: -- raised by URL http://otn.oracle.com/xxx

Line 1606: --FND_FILE.close;

1602:
1603: -- raised by URL http://otn.oracle.com/xxx
1604: WHEN UTL_HTTP.HTTP_CLIENT_ERROR THEN
1605: log('HTTP_CLIENT_ERROR: ' || UTL_HTTP.GET_DETAILED_SQLERRM);
1606: --FND_FILE.close;
1607: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');
1608: RAISE FND_API.G_EXC_ERROR;
1609:
1610: WHEN UTL_HTTP.TRANSFER_TIMEOUT THEN

Line 1612: --FND_FILE.close;

1608: RAISE FND_API.G_EXC_ERROR;
1609:
1610: WHEN UTL_HTTP.TRANSFER_TIMEOUT THEN
1611: log('HTTP TRANSFER TIMEOUT: '|| UTL_HTTP.GET_DETAILED_SQLERRM);
1612: --FND_FILE.close;
1613: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');
1614: RAISE FND_API.G_EXC_ERROR;
1615:
1616: WHEN OTHERS THEN

Line 1619: --FND_FILE.close;

1615:
1616: WHEN OTHERS THEN
1617: log('HTTP OTHER EXCEPTION: '|| UTL_HTTP.GET_DETAILED_SQLERRM);
1618: log('Check SQL EXCEPTION: '|| SQLERRM);
1619: --FND_FILE.close;
1620: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');
1621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1622: END;
1623:

Line 1645: --FND_FILE.close;

1641:
1642: EXCEPTION
1643: WHEN FND_API.G_EXC_ERROR THEN
1644: log('Error: Aborting Location Service');
1645: --FND_FILE.close;
1646: ROLLBACK TO submit_addrval_doc_pub;
1647: x_return_status := FND_API.G_RET_STS_ERROR;
1648: FND_MSG_PUB.Count_And_Get(
1649: p_encoded => FND_API.G_FALSE,

Line 1655: --FND_FILE.close;

1651: p_data => x_msg_data);
1652:
1653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1654: log('Error: Aborting Location Service');
1655: --FND_FILE.close;
1656: ROLLBACK TO submit_addrval_doc_pub;
1657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1658: FND_MSG_PUB.Count_And_Get(
1659: p_encoded => FND_API.G_FALSE,

Line 1666: --FND_FILE.close;

1662:
1663: WHEN OTHERS THEN
1664: log('Error: Aborting Location Service');
1665: log('SQL Error: '||SQLERRM);
1666: --FND_FILE.close;
1667: ROLLBACK TO submit_addrval_doc_pub;
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1669: FND_MSG_PUB.Count_And_Get(
1670: p_encoded => FND_API.G_FALSE,

Line 1914: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

1910: message IN VARCHAR2,
1911: newline IN BOOLEAN DEFAULT TRUE) IS
1912: BEGIN
1913: IF message = 'NEWLINE' THEN
1914: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
1915: ELSIF (newline) THEN
1916: FND_FILE.put_line(fnd_file.log,message);
1917: ELSE
1918: FND_FILE.put_line(fnd_file.log,message);

Line 1916: FND_FILE.put_line(fnd_file.log,message);

1912: BEGIN
1913: IF message = 'NEWLINE' THEN
1914: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
1915: ELSIF (newline) THEN
1916: FND_FILE.put_line(fnd_file.log,message);
1917: ELSE
1918: FND_FILE.put_line(fnd_file.log,message);
1919: END IF;
1920: END log;

Line 1918: FND_FILE.put_line(fnd_file.log,message);

1914: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
1915: ELSIF (newline) THEN
1916: FND_FILE.put_line(fnd_file.log,message);
1917: ELSE
1918: FND_FILE.put_line(fnd_file.log,message);
1919: END IF;
1920: END log;
1921:
1922: /*-----------------------------------------------------------------------