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_MESSAGE

Line 150: fnd_message.set_name('AR', 'HZ_NO_LOCATION_FOUND');

146: OPEN curowid;
147: FETCH curowid INTO l_rowid;
148: IF curowid%NOTFOUND THEN
149: x_return_status := fnd_api.g_ret_sts_error;
150: fnd_message.set_name('AR', 'HZ_NO_LOCATION_FOUND');
151: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
152: fnd_msg_pub.add;
153: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
154: hz_utility_v2pub.debug(p_message=>'No Record found : Error',

Line 151: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));

147: FETCH curowid INTO l_rowid;
148: IF curowid%NOTFOUND THEN
149: x_return_status := fnd_api.g_ret_sts_error;
150: fnd_message.set_name('AR', 'HZ_NO_LOCATION_FOUND');
151: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
152: fnd_msg_pub.add;
153: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
154: hz_utility_v2pub.debug(p_message=>'No Record found : Error',
155: p_prefix=>'ERROR',

Line 251: fnd_message.set_name('AR','HZ_LOCATION_UPDATED');

247: END IF;
248:
249: -- Fix perf bug 3669930, 4220460, cache profile option value into global variable
250: IF g_cp_detail = 'Y' THEN
251: fnd_message.set_name('AR','HZ_LOCATION_UPDATED');
252: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
253: fnd_msg_pub.add;
254: END IF;
255: END IF;

Line 252: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));

248:
249: -- Fix perf bug 3669930, 4220460, cache profile option value into global variable
250: IF g_cp_detail = 'Y' THEN
251: fnd_message.set_name('AR','HZ_LOCATION_UPDATED');
252: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
253: fnd_msg_pub.add;
254: END IF;
255: END IF;
256: CLOSE curowid;

Line 278: -- fnd_message

274: -- Synchronized geometry in hz_locations with latitude and longitude from
275: -- Oracle's eLocation service.
276: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
277: -- hz_utility_v2pub
278: -- fnd_message
279: -- fnd_msg_pub
280: -- MODIFICATION HISTORY
281: -- 01-10-2002 H. Yu Created.
282: -- 03-21-2002 J. del Callar Bug 2252141: Added call to spatial index

Line 562: fnd_message.get_string('FND',

558: fnd_msg_pub.initialize;
559:
560: retcode := '0';
561: fnd_file.put_line(fnd_file.log,
562: fnd_message.get_string('FND',
563: 'CONC-START PROGRAM EXECUTION'));
564: fnd_file.put_line(fnd_file.log, '');
565:
566: fnd_file.put_line(fnd_file.output,

Line 569: fnd_message.get_string('FND',

565:
566: fnd_file.put_line(fnd_file.output,
567: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
568: fnd_file.put_line(fnd_file.output,
569: fnd_message.get_string('FND',
570: 'CONC-START PROGRAM EXECUTION'));
571:
572: IF hz_geocode_pkg.is_nls_num_char_pt_com <> 'Y' THEN
573: l_str_exe := 'ALTER SESSION SET nls_numeric_characters = ''.,''';

Line 633: fnd_message.get_string('FND', 'PROFILES-VALUES'));

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

Line 641: fnd_message.get_string('FND', 'PROFILES-VALUES'));

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

Line 1610: fnd_message.clear;

1606: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256)
1607: || fnd_global.local_chr(10);
1608: trace_handler(msg);
1609: END LOOP;
1610: fnd_message.clear;
1611:
1612: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1613: retcode := '1';
1614: -- J. del Callar: instruct user to look at log if warnings are found.

Line 1615: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

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

Line 1624: fnd_message.get_string('FND',

1620: -- log files.
1621: fnd_file.put_line(fnd_file.output,
1622: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
1623: fnd_file.put_line(fnd_file.output,
1624: fnd_message.get_string('FND',
1625: 'CONC-CP SUCCESSFUL TERMINATION'));
1626: fnd_file.put_line(fnd_file.log,
1627: fnd_message.get_string('FND',
1628: 'CONC-CP SUCCESSFUL TERMINATION'));

Line 1627: fnd_message.get_string('FND',

1623: fnd_file.put_line(fnd_file.output,
1624: fnd_message.get_string('FND',
1625: 'CONC-CP SUCCESSFUL TERMINATION'));
1626: fnd_file.put_line(fnd_file.log,
1627: fnd_message.get_string('FND',
1628: 'CONC-CP SUCCESSFUL TERMINATION'));
1629:
1630: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1631: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (-)',

Line 1640: fnd_message.set_name('AR','HZ_MISSING_HTTP_SITE');

1636: --disable_debug;
1637:
1638: EXCEPTION
1639: WHEN expect_http_ad THEN
1640: fnd_message.set_name('AR','HZ_MISSING_HTTP_SITE');
1641: fnd_msg_pub.add;
1642: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1643: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1644: fnd_global.local_chr(10);

Line 1647: fnd_message.clear;

1643: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1644: fnd_global.local_chr(10);
1645: trace_handler(msg);
1646: END LOOP;
1647: fnd_message.clear;
1648: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1649: hz_utility_v2pub.debug(p_message=>g_pkg_name ||'.update_geometry (- expect_http_ad)',
1650: p_prefix=>'ERROR',
1651: p_msg_level=>fnd_log.level_error);

Line 1655: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

1651: p_msg_level=>fnd_log.level_error);
1652: END IF;
1653: --disable_debug;
1654: retcode := '2';
1655: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1656:
1657: WHEN port_number THEN
1658: fnd_message.set_name('AR','HZ_PORT_NUMBER_EXPECTED');
1659: fnd_message.set_token('PORT', l_port);

Line 1658: fnd_message.set_name('AR','HZ_PORT_NUMBER_EXPECTED');

1654: retcode := '2';
1655: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1656:
1657: WHEN port_number THEN
1658: fnd_message.set_name('AR','HZ_PORT_NUMBER_EXPECTED');
1659: fnd_message.set_token('PORT', l_port);
1660: fnd_msg_pub.add;
1661: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1662: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||

Line 1659: fnd_message.set_token('PORT', l_port);

1655: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1656:
1657: WHEN port_number THEN
1658: fnd_message.set_name('AR','HZ_PORT_NUMBER_EXPECTED');
1659: fnd_message.set_token('PORT', l_port);
1660: fnd_msg_pub.add;
1661: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1662: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1663: fnd_global.local_chr(10);

Line 1666: fnd_message.clear;

1662: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1663: fnd_global.local_chr(10);
1664: trace_handler(msg);
1665: END LOOP;
1666: fnd_message.clear;
1667: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1668: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (- port_number)',
1669: p_prefix=>'ERROR',
1670: p_msg_level=>fnd_log.level_error);

Line 1674: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

1670: p_msg_level=>fnd_log.level_error);
1671: END IF;
1672: --disable_debug;
1673: retcode := '2';
1674: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1675:
1676: WHEN nlsnumexp THEN
1677: fnd_message.set_name('AR','HZ_NUMERIC_CHAR_SET');
1678: fnd_msg_pub.add;

Line 1677: fnd_message.set_name('AR','HZ_NUMERIC_CHAR_SET');

1673: retcode := '2';
1674: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1675:
1676: WHEN nlsnumexp THEN
1677: fnd_message.set_name('AR','HZ_NUMERIC_CHAR_SET');
1678: fnd_msg_pub.add;
1679: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1680: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1681: fnd_global.local_chr(10);

Line 1684: fnd_message.clear;

1680: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1681: fnd_global.local_chr(10);
1682: trace_handler(msg);
1683: END LOOP;
1684: fnd_message.clear;
1685: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1686: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (- nlsnumexp)',
1687: p_prefix=>'ERROR',
1688: p_msg_level=>fnd_log.level_error);

Line 1692: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

1688: p_msg_level=>fnd_log.level_error);
1689: END IF;
1690: --disable_debug;
1691: retcode := '2';
1692: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1693:
1694: WHEN atleastonerow THEN
1695: fnd_message.set_name('AR','HZ_AT_LEAST_ONE_ROW');
1696: fnd_msg_pub.add;

Line 1695: fnd_message.set_name('AR','HZ_AT_LEAST_ONE_ROW');

1691: retcode := '2';
1692: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1693:
1694: WHEN atleastonerow THEN
1695: fnd_message.set_name('AR','HZ_AT_LEAST_ONE_ROW');
1696: fnd_msg_pub.add;
1697: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1698: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1699: fnd_global.local_chr(10);

Line 1702: fnd_message.clear;

1698: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1699: fnd_global.local_chr(10);
1700: trace_handler(msg);
1701: END LOOP;
1702: fnd_message.clear;
1703: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1704: hz_utility_v2pub.debug(p_message=>g_pkg_name ||'.update_geometry (- atleastonerow)',
1705: p_prefix=>'ERROR',
1706: p_msg_level=>fnd_log.level_error);

Line 1710: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

1706: p_msg_level=>fnd_log.level_error);
1707: END IF;
1708: --disable_debug;
1709: retcode := '2';
1710: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1711:
1712: WHEN morethanmaxrow THEN
1713: fnd_message.set_name('AR','HZ_MAX_BATCH_SIZE_EXCEEDED');
1714: fnd_message.set_token('MAX', hz_geocode_pkg.g_max_rows);

Line 1713: fnd_message.set_name('AR','HZ_MAX_BATCH_SIZE_EXCEEDED');

1709: retcode := '2';
1710: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1711:
1712: WHEN morethanmaxrow THEN
1713: fnd_message.set_name('AR','HZ_MAX_BATCH_SIZE_EXCEEDED');
1714: fnd_message.set_token('MAX', hz_geocode_pkg.g_max_rows);
1715: fnd_msg_pub.add;
1716: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1717: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||

Line 1714: fnd_message.set_token('MAX', hz_geocode_pkg.g_max_rows);

1710: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1711:
1712: WHEN morethanmaxrow THEN
1713: fnd_message.set_name('AR','HZ_MAX_BATCH_SIZE_EXCEEDED');
1714: fnd_message.set_token('MAX', hz_geocode_pkg.g_max_rows);
1715: fnd_msg_pub.add;
1716: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1717: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1718: fnd_global.local_chr(10);

Line 1721: fnd_message.clear;

1717: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1718: fnd_global.local_chr(10);
1719: trace_handler(msg);
1720: END LOOP;
1721: fnd_message.clear;
1722: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1723: hz_utility_v2pub.debug(p_message=>g_pkg_name ||'.update_geometry (- morethanmaxrow)',
1724: p_prefix=>'ERROR',
1725: p_msg_level=>fnd_log.level_error);

Line 1729: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

1725: p_msg_level=>fnd_log.level_error);
1726: END IF;
1727: --disable_debug;
1728: retcode := '2';
1729: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1730:
1731: WHEN exchttp THEN
1732: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1733: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||

Line 1737: fnd_message.clear;

1733: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1734: fnd_global.local_chr(10);
1735: trace_handler(msg);
1736: END LOOP;
1737: fnd_message.clear;
1738: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1739: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (- exchttp)',
1740: p_prefix=>'ERROR',
1741: p_msg_level=>fnd_log.level_error);

Line 1745: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

1741: p_msg_level=>fnd_log.level_error);
1742: END IF;
1743: --disable_debug;
1744: retcode := '2';
1745: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1746:
1747: WHEN OTHERS THEN
1748: fnd_file.put_line(fnd_file.log, SQLERRM);
1749: msg := SQLERRM;

Line 1760: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

1756: p_msg_level=>fnd_log.level_error);
1757: END IF;
1758: --disable_debug;
1759: retcode := '2';
1760: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1761:
1762: */
1763: NULL;
1764: END update_geometry;

Line 1920: -- fnd_message

1916: -- Synchronized geometry in hz_locations with latitude,longitude and accuracy from
1917: -- Oracle's eLocation service.
1918: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1919: -- hz_utility_v2pub
1920: -- fnd_message
1921: -- fnd_msg_pub
1922: -- MODIFICATION HISTORY
1923: -- 29-11-2010 Sudhir Gokavarapu Created - ER10211310
1924: -- Bug12386319 default value of p_nb_row is changed to 10.

Line 2039: fnd_message.get_string('FND',

2035: fnd_msg_pub.initialize;
2036:
2037: retcode := '0';
2038: fnd_file.put_line(fnd_file.log,
2039: fnd_message.get_string('FND',
2040: 'CONC-START PROGRAM EXECUTION'));
2041: fnd_file.put_line(fnd_file.log, '');
2042:
2043: fnd_file.put_line(fnd_file.output,

Line 2046: fnd_message.get_string('FND',

2042:
2043: fnd_file.put_line(fnd_file.output,
2044: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
2045: fnd_file.put_line(fnd_file.output,
2046: fnd_message.get_string('FND',
2047: 'CONC-START PROGRAM EXECUTION'));
2048:
2049: IF hz_geocode_pkg.is_nls_num_char_pt_com <> 'Y' THEN
2050: l_str_exe := 'ALTER SESSION SET nls_numeric_characters = ''.,''';

Line 2111: fnd_message.get_string('FND', 'PROFILES-VALUES'));

2107: END IF;
2108:
2109: -- log the profile options that are being used to run this program.
2110: fnd_file.put_line(fnd_file.log,
2111: fnd_message.get_string('FND', 'PROFILES-VALUES'));
2112: fnd_file.put_line(fnd_file.log, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
2113: fnd_file.put_line(fnd_file.log, l_proxy_var || ': ' || l_proxy);
2114: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);
2115: fnd_file.put_line(fnd_file.log, '');

Line 2119: fnd_message.get_string('FND', 'PROFILES-VALUES'));

2115: fnd_file.put_line(fnd_file.log, '');
2116:
2117: -- repeat in the output file.
2118: fnd_file.put_line(fnd_file.output,
2119: fnd_message.get_string('FND', 'PROFILES-VALUES'));
2120: fnd_file.put_line(fnd_file.output, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
2121: fnd_file.put_line(fnd_file.output, l_proxy_var || ': ' || l_proxy);
2122: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);
2123: fnd_file.put_line(fnd_file.output, '');

Line 2519: fnd_message.clear;

2515: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256)
2516: || fnd_global.local_chr(10);
2517: trace_handler(msg);
2518: END LOOP;
2519: fnd_message.clear;
2520: */
2521: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2522: retcode := '1';
2523: -- Instruct user to look at log if warnings are found.

Line 2524: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

2520: */
2521: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2522: retcode := '1';
2523: -- Instruct user to look at log if warnings are found.
2524: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2525: fnd_file.put_line(fnd_file.output, errbuf);
2526: END IF;
2527:
2528: -- Reflect successful program termination in output and

Line 2533: fnd_message.get_string('FND',

2529: -- log files.
2530: fnd_file.put_line(fnd_file.output,
2531: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
2532: fnd_file.put_line(fnd_file.output,
2533: fnd_message.get_string('FND',
2534: 'CONC-CP SUCCESSFUL TERMINATION'));
2535: fnd_file.put_line(fnd_file.log,
2536: fnd_message.get_string('FND',
2537: 'CONC-CP SUCCESSFUL TERMINATION'));

Line 2536: fnd_message.get_string('FND',

2532: fnd_file.put_line(fnd_file.output,
2533: fnd_message.get_string('FND',
2534: 'CONC-CP SUCCESSFUL TERMINATION'));
2535: fnd_file.put_line(fnd_file.log,
2536: fnd_message.get_string('FND',
2537: 'CONC-CP SUCCESSFUL TERMINATION'));
2538:
2539: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2540: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (-)',

Line 2553: fnd_message.set_name('AR','HZ_MISSING_HTTP_SITE');

2549: END IF;
2550:
2551: EXCEPTION
2552: WHEN expect_http_ad THEN
2553: fnd_message.set_name('AR','HZ_MISSING_HTTP_SITE');
2554: fnd_msg_pub.add;
2555: FOR j IN 1..fnd_msg_pub.count_msg LOOP
2556: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
2557: fnd_global.local_chr(10);

Line 2560: fnd_message.clear;

2556: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
2557: fnd_global.local_chr(10);
2558: trace_handler(msg);
2559: END LOOP;
2560: fnd_message.clear;
2561: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2562: hz_utility_v2pub.debug(p_message=>g_pkg_name ||'.update_geometry_all (- expect_http_ad)',
2563: p_prefix=>'ERROR',
2564: p_msg_level=>fnd_log.level_error);

Line 2568: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

2564: p_msg_level=>fnd_log.level_error);
2565: END IF;
2566: --disable_debug;
2567: retcode := '2';
2568: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2569:
2570: WHEN port_number THEN
2571: fnd_message.set_name('AR','HZ_PORT_NUMBER_EXPECTED');
2572: fnd_message.set_token('PORT', l_port);

Line 2571: fnd_message.set_name('AR','HZ_PORT_NUMBER_EXPECTED');

2567: retcode := '2';
2568: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2569:
2570: WHEN port_number THEN
2571: fnd_message.set_name('AR','HZ_PORT_NUMBER_EXPECTED');
2572: fnd_message.set_token('PORT', l_port);
2573: fnd_msg_pub.add;
2574: FOR j IN 1..fnd_msg_pub.count_msg LOOP
2575: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||

Line 2572: fnd_message.set_token('PORT', l_port);

2568: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2569:
2570: WHEN port_number THEN
2571: fnd_message.set_name('AR','HZ_PORT_NUMBER_EXPECTED');
2572: fnd_message.set_token('PORT', l_port);
2573: fnd_msg_pub.add;
2574: FOR j IN 1..fnd_msg_pub.count_msg LOOP
2575: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
2576: fnd_global.local_chr(10);

Line 2579: fnd_message.clear;

2575: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
2576: fnd_global.local_chr(10);
2577: trace_handler(msg);
2578: END LOOP;
2579: fnd_message.clear;
2580: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2581: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry_all (- port_number)',
2582: p_prefix=>'ERROR',
2583: p_msg_level=>fnd_log.level_error);

Line 2587: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

2583: p_msg_level=>fnd_log.level_error);
2584: END IF;
2585: --disable_debug;
2586: retcode := '2';
2587: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2588:
2589: WHEN nlsnumexp THEN
2590: fnd_message.set_name('AR','HZ_NUMERIC_CHAR_SET');
2591: fnd_msg_pub.add;

Line 2590: fnd_message.set_name('AR','HZ_NUMERIC_CHAR_SET');

2586: retcode := '2';
2587: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2588:
2589: WHEN nlsnumexp THEN
2590: fnd_message.set_name('AR','HZ_NUMERIC_CHAR_SET');
2591: fnd_msg_pub.add;
2592: FOR j IN 1..fnd_msg_pub.count_msg LOOP
2593: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
2594: fnd_global.local_chr(10);

Line 2597: fnd_message.clear;

2593: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
2594: fnd_global.local_chr(10);
2595: trace_handler(msg);
2596: END LOOP;
2597: fnd_message.clear;
2598: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2599: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry_all (- nlsnumexp)',
2600: p_prefix=>'ERROR',
2601: p_msg_level=>fnd_log.level_error);

Line 2605: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

2601: p_msg_level=>fnd_log.level_error);
2602: END IF;
2603: --disable_debug;
2604: retcode := '2';
2605: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2606:
2607: WHEN atleastonerow THEN
2608: fnd_message.set_name('AR','HZ_AT_LEAST_ONE_ROW');
2609: fnd_msg_pub.add;

Line 2608: fnd_message.set_name('AR','HZ_AT_LEAST_ONE_ROW');

2604: retcode := '2';
2605: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2606:
2607: WHEN atleastonerow THEN
2608: fnd_message.set_name('AR','HZ_AT_LEAST_ONE_ROW');
2609: fnd_msg_pub.add;
2610: FOR j IN 1..fnd_msg_pub.count_msg LOOP
2611: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
2612: fnd_global.local_chr(10);

Line 2615: fnd_message.clear;

2611: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
2612: fnd_global.local_chr(10);
2613: trace_handler(msg);
2614: END LOOP;
2615: fnd_message.clear;
2616: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2617: hz_utility_v2pub.debug(p_message=>g_pkg_name ||'.update_geometry_all (- atleastonerow)',
2618: p_prefix=>'ERROR',
2619: p_msg_level=>fnd_log.level_error);

Line 2623: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

2619: p_msg_level=>fnd_log.level_error);
2620: END IF;
2621: --disable_debug;
2622: retcode := '2';
2623: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2624:
2625: WHEN morethanmaxrow THEN
2626: fnd_message.set_name('AR','HZ_MAX_BATCH_SIZE_EXCEEDED');
2627: fnd_message.set_token('MAX', hz_geocode_pkg.g_max_rows);

Line 2626: fnd_message.set_name('AR','HZ_MAX_BATCH_SIZE_EXCEEDED');

2622: retcode := '2';
2623: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2624:
2625: WHEN morethanmaxrow THEN
2626: fnd_message.set_name('AR','HZ_MAX_BATCH_SIZE_EXCEEDED');
2627: fnd_message.set_token('MAX', hz_geocode_pkg.g_max_rows);
2628: fnd_msg_pub.add;
2629: FOR j IN 1..fnd_msg_pub.count_msg LOOP
2630: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||

Line 2627: fnd_message.set_token('MAX', hz_geocode_pkg.g_max_rows);

2623: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2624:
2625: WHEN morethanmaxrow THEN
2626: fnd_message.set_name('AR','HZ_MAX_BATCH_SIZE_EXCEEDED');
2627: fnd_message.set_token('MAX', hz_geocode_pkg.g_max_rows);
2628: fnd_msg_pub.add;
2629: FOR j IN 1..fnd_msg_pub.count_msg LOOP
2630: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
2631: fnd_global.local_chr(10);

Line 2634: fnd_message.clear;

2630: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
2631: fnd_global.local_chr(10);
2632: trace_handler(msg);
2633: END LOOP;
2634: fnd_message.clear;
2635: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2636: hz_utility_v2pub.debug(p_message=>g_pkg_name ||'.update_geometry_all (- morethanmaxrow)',
2637: p_prefix=>'ERROR',
2638: p_msg_level=>fnd_log.level_error);

Line 2642: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

2638: p_msg_level=>fnd_log.level_error);
2639: END IF;
2640: --disable_debug;
2641: retcode := '2';
2642: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2643:
2644: WHEN exchttp THEN
2645: FOR j IN 1..fnd_msg_pub.count_msg LOOP
2646: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||

Line 2650: fnd_message.clear;

2646: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
2647: fnd_global.local_chr(10);
2648: trace_handler(msg);
2649: END LOOP;
2650: fnd_message.clear;
2651: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2652: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry_all (- exchttp)',
2653: p_prefix=>'ERROR',
2654: p_msg_level=>fnd_log.level_error);

Line 2658: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

2654: p_msg_level=>fnd_log.level_error);
2655: END IF;
2656: --disable_debug;
2657: retcode := '2';
2658: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2659:
2660: WHEN OTHERS THEN
2661: fnd_file.put_line(fnd_file.log, SQLERRM);
2662: msg := SQLERRM;

Line 2673: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

2669: p_msg_level=>fnd_log.level_error);
2670: END IF;
2671: --disable_debug;
2672: retcode := '2';
2673: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2674:
2675: END update_geometry_all;
2676:
2677:

Line 2686: -- fnd_message

2682: -- spatial index is required so that the index performs adequately and
2683: -- that queries can accurately extract the spatial data.
2684: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2685: -- hz_utility_v2pub
2686: -- fnd_message
2687: -- fnd_msg_pub
2688: -- ARGUMENTS
2689: -- IN:
2690: -- p_concurrent_mode Set to 'Y' if the rebuild is running

Line 2845: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));

2841: -- successful concurrent program termination only if we are running as a
2842: -- concurrent program.
2843: IF p_concurrent_mode = 'Y' THEN
2844: fnd_file.put_line(fnd_file.log,
2845: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
2846: fnd_file.put_line(fnd_file.output,
2847: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
2848: fnd_file.put_line(fnd_file.log,
2849: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));

Line 2847: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));

2843: IF p_concurrent_mode = 'Y' THEN
2844: fnd_file.put_line(fnd_file.log,
2845: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
2846: fnd_file.put_line(fnd_file.output,
2847: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
2848: fnd_file.put_line(fnd_file.log,
2849: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));
2850: fnd_file.put_line(fnd_file.output,
2851: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));

Line 2849: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));

2845: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
2846: fnd_file.put_line(fnd_file.output,
2847: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
2848: fnd_file.put_line(fnd_file.log,
2849: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));
2850: fnd_file.put_line(fnd_file.output,
2851: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));
2852: ELSE
2853: -- otherwise, just push the error onto the stack.

Line 2851: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));

2847: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
2848: fnd_file.put_line(fnd_file.log,
2849: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));
2850: fnd_file.put_line(fnd_file.output,
2851: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));
2852: ELSE
2853: -- otherwise, just push the error onto the stack.
2854: fnd_message.set_name('AR', 'HZ_GEO_INDEX_REBUILT');
2855: fnd_msg_pub.add;

Line 2854: fnd_message.set_name('AR', 'HZ_GEO_INDEX_REBUILT');

2850: fnd_file.put_line(fnd_file.output,
2851: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));
2852: ELSE
2853: -- otherwise, just push the error onto the stack.
2854: fnd_message.set_name('AR', 'HZ_GEO_INDEX_REBUILT');
2855: fnd_msg_pub.add;
2856: END IF;
2857: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2858: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.rebuild_location_index (-)',

Line 2875: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

2871: l_objects.DELETE;
2872: l_policies.DELETE;
2873: EXCEPTION
2874: WHEN OTHERS THEN
2875: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2876: fnd_message.set_token('ERROR', SQLERRM);
2877:
2878: -- log the error only if we are running as a concurrent program.
2879: -- otherwise, push the error onto the stack.

Line 2876: fnd_message.set_token('ERROR', SQLERRM);

2872: l_policies.DELETE;
2873: EXCEPTION
2874: WHEN OTHERS THEN
2875: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2876: fnd_message.set_token('ERROR', SQLERRM);
2877:
2878: -- log the error only if we are running as a concurrent program.
2879: -- otherwise, push the error onto the stack.
2880: IF p_concurrent_mode = 'Y' THEN

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

2877:
2878: -- log the error only if we are running as a concurrent program.
2879: -- otherwise, push the error onto the stack.
2880: IF p_concurrent_mode = 'Y' THEN
2881: fnd_file.put_line(fnd_file.log, fnd_message.get);
2882: fnd_file.put_line(fnd_file.output,
2883: fnd_message.get_string('FND',
2884: 'CONC-CHECK LOG FOR DETAILS'));
2885: ELSE

Line 2883: fnd_message.get_string('FND',

2879: -- otherwise, push the error onto the stack.
2880: IF p_concurrent_mode = 'Y' THEN
2881: fnd_file.put_line(fnd_file.log, fnd_message.get);
2882: fnd_file.put_line(fnd_file.output,
2883: fnd_message.get_string('FND',
2884: 'CONC-CHECK LOG FOR DETAILS'));
2885: ELSE
2886: fnd_msg_pub.add;
2887: END IF;