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_ELOCATION_PKG dependencies on FND_FILE

Line 86: fnd_file.put_line(fnd_file.output,v);

82: v := TRIM(v);
83: IF v IS NOT NULL THEN
84: -- Fix perf bug 3669930, 4220460, cache profile option value into global variable
85: IF g_cp_detail = 'Y' THEN
86: fnd_file.put_line(fnd_file.output,v);
87: END IF;
88: fnd_file.put_line(fnd_file.log,v);
89: END IF;
90: END trace_handler;

Line 88: fnd_file.put_line(fnd_file.log,v);

84: -- Fix perf bug 3669930, 4220460, cache profile option value into global variable
85: IF g_cp_detail = 'Y' THEN
86: fnd_file.put_line(fnd_file.output,v);
87: END IF;
88: fnd_file.put_line(fnd_file.log,v);
89: END IF;
90: END trace_handler;
91:
92: --------------------------------------

Line 105: fnd_file.put_line(fnd_file.log,

101: --------------------------------------
102: /*PROCEDURE time_put_line (msg IN VARCHAR2) IS
103: BEGIN
104: IF g_file_debug THEN
105: fnd_file.put_line(fnd_file.log,
106: TO_CHAR(SYSDATE, 'HH:MI:SS') ||
107: ': ' || SUBSTRB(msg, 1, 240));
108: ELSE
109: hz_utility_v2pub.debug(TO_CHAR(SYSDATE, 'HH:MI:SS') ||

Line 116: fnd_file.put_line(fnd_file.log,

112: END time_put_line;
113: */
114: PROCEDURE time_put_line (msg IN VARCHAR2) IS
115: BEGIN
116: fnd_file.put_line(fnd_file.log,
117: TO_CHAR(SYSDATE, 'HH:MI:SS') ||
118: ': ' || SUBSTRB(msg, 1, 240));
119: END time_put_line;
120:

Line 557: fnd_file.put_line(fnd_file.log,

553: l_return_status := fnd_api.g_ret_sts_success;
554: fnd_msg_pub.initialize;
555:
556: retcode := '0';
557: fnd_file.put_line(fnd_file.log,
558: fnd_message.get_string('FND',
559: 'CONC-START PROGRAM EXECUTION'));
560: fnd_file.put_line(fnd_file.log, '');
561:

Line 560: fnd_file.put_line(fnd_file.log, '');

556: retcode := '0';
557: fnd_file.put_line(fnd_file.log,
558: fnd_message.get_string('FND',
559: 'CONC-START PROGRAM EXECUTION'));
560: fnd_file.put_line(fnd_file.log, '');
561:
562: fnd_file.put_line(fnd_file.output,
563: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
564: fnd_file.put_line(fnd_file.output,

Line 562: fnd_file.put_line(fnd_file.output,

558: fnd_message.get_string('FND',
559: 'CONC-START PROGRAM EXECUTION'));
560: fnd_file.put_line(fnd_file.log, '');
561:
562: fnd_file.put_line(fnd_file.output,
563: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
564: fnd_file.put_line(fnd_file.output,
565: fnd_message.get_string('FND',
566: 'CONC-START PROGRAM EXECUTION'));

Line 564: fnd_file.put_line(fnd_file.output,

560: fnd_file.put_line(fnd_file.log, '');
561:
562: fnd_file.put_line(fnd_file.output,
563: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
564: fnd_file.put_line(fnd_file.output,
565: fnd_message.get_string('FND',
566: 'CONC-START PROGRAM EXECUTION'));
567:
568: IF hz_geocode_pkg.is_nls_num_char_pt_com <> 'Y' THEN

Line 628: fnd_file.put_line(fnd_file.log,

624: l_port := fnd_profile.value(l_port_var);
625: END IF;
626:
627: -- log the profile options that are being used to run this program.
628: fnd_file.put_line(fnd_file.log,
629: fnd_message.get_string('FND', 'PROFILES-VALUES'));
630: fnd_file.put_line(fnd_file.log, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
631: fnd_file.put_line(fnd_file.log, l_proxy_var || ': ' || l_proxy);
632: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);

Line 630: fnd_file.put_line(fnd_file.log, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);

626:
627: -- log the profile options that are being used to run this program.
628: fnd_file.put_line(fnd_file.log,
629: fnd_message.get_string('FND', 'PROFILES-VALUES'));
630: fnd_file.put_line(fnd_file.log, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
631: fnd_file.put_line(fnd_file.log, l_proxy_var || ': ' || l_proxy);
632: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);
633: fnd_file.put_line(fnd_file.log, '');
634:

Line 631: fnd_file.put_line(fnd_file.log, l_proxy_var || ': ' || l_proxy);

627: -- log the profile options that are being used to run this program.
628: fnd_file.put_line(fnd_file.log,
629: fnd_message.get_string('FND', 'PROFILES-VALUES'));
630: fnd_file.put_line(fnd_file.log, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
631: fnd_file.put_line(fnd_file.log, l_proxy_var || ': ' || l_proxy);
632: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);
633: fnd_file.put_line(fnd_file.log, '');
634:
635: -- repeat in the output file.

Line 632: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);

628: fnd_file.put_line(fnd_file.log,
629: fnd_message.get_string('FND', 'PROFILES-VALUES'));
630: fnd_file.put_line(fnd_file.log, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
631: fnd_file.put_line(fnd_file.log, l_proxy_var || ': ' || l_proxy);
632: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);
633: fnd_file.put_line(fnd_file.log, '');
634:
635: -- repeat in the output file.
636: fnd_file.put_line(fnd_file.output,

Line 633: fnd_file.put_line(fnd_file.log, '');

629: fnd_message.get_string('FND', 'PROFILES-VALUES'));
630: fnd_file.put_line(fnd_file.log, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
631: fnd_file.put_line(fnd_file.log, l_proxy_var || ': ' || l_proxy);
632: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);
633: fnd_file.put_line(fnd_file.log, '');
634:
635: -- repeat in the output file.
636: fnd_file.put_line(fnd_file.output,
637: fnd_message.get_string('FND', 'PROFILES-VALUES'));

Line 636: fnd_file.put_line(fnd_file.output,

632: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);
633: fnd_file.put_line(fnd_file.log, '');
634:
635: -- repeat in the output file.
636: fnd_file.put_line(fnd_file.output,
637: fnd_message.get_string('FND', 'PROFILES-VALUES'));
638: fnd_file.put_line(fnd_file.output, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
639: fnd_file.put_line(fnd_file.output, l_proxy_var || ': ' || l_proxy);
640: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);

Line 638: fnd_file.put_line(fnd_file.output, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);

634:
635: -- repeat in the output file.
636: fnd_file.put_line(fnd_file.output,
637: fnd_message.get_string('FND', 'PROFILES-VALUES'));
638: fnd_file.put_line(fnd_file.output, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
639: fnd_file.put_line(fnd_file.output, l_proxy_var || ': ' || l_proxy);
640: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);
641: fnd_file.put_line(fnd_file.output, '');
642:

Line 639: fnd_file.put_line(fnd_file.output, l_proxy_var || ': ' || l_proxy);

635: -- repeat in the output file.
636: fnd_file.put_line(fnd_file.output,
637: fnd_message.get_string('FND', 'PROFILES-VALUES'));
638: fnd_file.put_line(fnd_file.output, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
639: fnd_file.put_line(fnd_file.output, l_proxy_var || ': ' || l_proxy);
640: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);
641: fnd_file.put_line(fnd_file.output, '');
642:
643: -- repeat in debug output.

Line 640: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);

636: fnd_file.put_line(fnd_file.output,
637: fnd_message.get_string('FND', 'PROFILES-VALUES'));
638: fnd_file.put_line(fnd_file.output, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
639: fnd_file.put_line(fnd_file.output, l_proxy_var || ': ' || l_proxy);
640: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);
641: fnd_file.put_line(fnd_file.output, '');
642:
643: -- repeat in debug output.
644: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 641: fnd_file.put_line(fnd_file.output, '');

637: fnd_message.get_string('FND', 'PROFILES-VALUES'));
638: fnd_file.put_line(fnd_file.output, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
639: fnd_file.put_line(fnd_file.output, l_proxy_var || ': ' || l_proxy);
640: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);
641: fnd_file.put_line(fnd_file.output, '');
642:
643: -- repeat in debug output.
644: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
645: hz_utility_v2pub.debug(p_message=>'HZ_GEOCODE_WEBSITE: ' || l_http_ad,

Line 1305: fnd_file.put_line(fnd_file.log,

1301: l_array(cpt).country := l_countries(i);
1302: l_array(cpt).province := l_provinces(i);
1303: l_array(cpt).county := l_counties(i);
1304:
1305: fnd_file.put_line(fnd_file.log,
1306: 'Processing location '||l_array(cpt).location_id);
1307: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1308: hz_utility_v2pub.debug(p_message=>'Processing location ' || l_array(cpt).location_id,
1309: p_prefix =>l_debug_prefix,

Line 1450: fnd_file.put_line(fnd_file.log,'Process committed');

1446: COMMIT;
1447:
1448: -- Fix bug 3612034, close cursor and then reopen it again due to
1449: -- snapshot too old problem
1450: fnd_file.put_line(fnd_file.log,'Process committed');
1451:
1452: IF p_loc_type = 'P' THEN
1453: IF p_site_use_type IS NOT NULL AND p_incremental = 'N' THEN
1454: IF (p_country IS NULL) THEN

Line 1612: fnd_file.put_line(fnd_file.output, errbuf);

1608: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1609: retcode := '1';
1610: -- J. del Callar: instruct user to look at log if warnings are found.
1611: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1612: fnd_file.put_line(fnd_file.output, errbuf);
1613: END IF;
1614:
1615: -- J. del Callar: reflect successful program termination in output and
1616: -- log files.

Line 1617: fnd_file.put_line(fnd_file.output,

1613: END IF;
1614:
1615: -- J. del Callar: reflect successful program termination in output and
1616: -- log files.
1617: fnd_file.put_line(fnd_file.output,
1618: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
1619: fnd_file.put_line(fnd_file.output,
1620: fnd_message.get_string('FND',
1621: 'CONC-CP SUCCESSFUL TERMINATION'));

Line 1619: fnd_file.put_line(fnd_file.output,

1615: -- J. del Callar: reflect successful program termination in output and
1616: -- log files.
1617: fnd_file.put_line(fnd_file.output,
1618: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
1619: fnd_file.put_line(fnd_file.output,
1620: fnd_message.get_string('FND',
1621: 'CONC-CP SUCCESSFUL TERMINATION'));
1622: fnd_file.put_line(fnd_file.log,
1623: fnd_message.get_string('FND',

Line 1622: fnd_file.put_line(fnd_file.log,

1618: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
1619: fnd_file.put_line(fnd_file.output,
1620: fnd_message.get_string('FND',
1621: 'CONC-CP SUCCESSFUL TERMINATION'));
1622: fnd_file.put_line(fnd_file.log,
1623: fnd_message.get_string('FND',
1624: 'CONC-CP SUCCESSFUL TERMINATION'));
1625:
1626: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1744: fnd_file.put_line(fnd_file.log, SQLERRM);

1740: retcode := '2';
1741: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1742:
1743: WHEN OTHERS THEN
1744: fnd_file.put_line(fnd_file.log, SQLERRM);
1745: msg := SQLERRM;
1746: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1747: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (- others)',
1748: p_prefix=>'SQL ERROR',

Line 1916: fnd_file.put_line(fnd_file.log,

1912: -- notify the user that the spatial index was successfully rebuilt, and of
1913: -- successful concurrent program termination only if we are running as a
1914: -- concurrent program.
1915: IF p_concurrent_mode = 'Y' THEN
1916: fnd_file.put_line(fnd_file.log,
1917: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
1918: fnd_file.put_line(fnd_file.output,
1919: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
1920: fnd_file.put_line(fnd_file.log,

Line 1918: fnd_file.put_line(fnd_file.output,

1914: -- concurrent program.
1915: IF p_concurrent_mode = 'Y' THEN
1916: fnd_file.put_line(fnd_file.log,
1917: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
1918: fnd_file.put_line(fnd_file.output,
1919: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
1920: fnd_file.put_line(fnd_file.log,
1921: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));
1922: fnd_file.put_line(fnd_file.output,

Line 1920: fnd_file.put_line(fnd_file.log,

1916: fnd_file.put_line(fnd_file.log,
1917: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
1918: fnd_file.put_line(fnd_file.output,
1919: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
1920: fnd_file.put_line(fnd_file.log,
1921: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));
1922: fnd_file.put_line(fnd_file.output,
1923: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));
1924: ELSE

Line 1922: fnd_file.put_line(fnd_file.output,

1918: fnd_file.put_line(fnd_file.output,
1919: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
1920: fnd_file.put_line(fnd_file.log,
1921: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));
1922: fnd_file.put_line(fnd_file.output,
1923: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));
1924: ELSE
1925: -- otherwise, just push the error onto the stack.
1926: fnd_message.set_name('AR', 'HZ_GEO_INDEX_REBUILT');

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

1949:
1950: -- log the error only if we are running as a concurrent program.
1951: -- otherwise, push the error onto the stack.
1952: IF p_concurrent_mode = 'Y' THEN
1953: fnd_file.put_line(fnd_file.log, fnd_message.get);
1954: fnd_file.put_line(fnd_file.output,
1955: fnd_message.get_string('FND',
1956: 'CONC-CHECK LOG FOR DETAILS'));
1957: ELSE

Line 1954: fnd_file.put_line(fnd_file.output,

1950: -- log the error only if we are running as a concurrent program.
1951: -- otherwise, push the error onto the stack.
1952: IF p_concurrent_mode = 'Y' THEN
1953: fnd_file.put_line(fnd_file.log, fnd_message.get);
1954: fnd_file.put_line(fnd_file.output,
1955: fnd_message.get_string('FND',
1956: 'CONC-CHECK LOG FOR DETAILS'));
1957: ELSE
1958: fnd_msg_pub.add;