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_GEOCODE_PKG dependencies on HZ_GEOCODE_PKG

Line 1: PACKAGE BODY hz_geocode_pkg AS

1: PACKAGE BODY hz_geocode_pkg AS
2: /*$Header: ARHGEOCB.pls 120.22.12020000.2 2012/07/19 07:23:59 rgokavar ship $*/
3:
4: -- private global variables
5:

Line 279: p_lines IN OUT NOCOPY hz_geocode_pkg.array_t,

275: --
276:
277: PROCEDURE get_response_lines (
278: p_str IN VARCHAR2,
279: p_lines IN OUT NOCOPY hz_geocode_pkg.array_t,
280: p_loc_array IN OUT NOCOPY loc_array,
281: p_temp_sta IN VARCHAR2,
282: p_temp_end IN VARCHAR2 DEFAULT NULL,
283: p_root_text IN VARCHAR2 DEFAULT NULL,

Line 404: hz_utility_v2pub.debug(p_message=>'hz_geocode_pkg.set_matching_geometry (+)',

400: i NUMBER;
401: l_debug_prefix VARCHAR2(30) := '';
402: BEGIN
403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
404: hz_utility_v2pub.debug(p_message=>'hz_geocode_pkg.set_matching_geometry (+)',
405: p_prefix=>l_debug_prefix,
406: p_msg_level=>fnd_log.level_procedure);
407: END IF;
408: FOR i IN 1..p_loc_array.COUNT LOOP

Line 417: hz_utility_v2pub.debug(p_message=>'hz_geocode_pkg.set_matching_geometry (-)',

413: p_loc_array(i).geometry_status_code := p_geometry_status_code;
414: p_loc_array(i).geometry_accuracy := p_geometry_accuracy;
415: -- Debug info.
416: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
417: hz_utility_v2pub.debug(p_message=>'hz_geocode_pkg.set_matching_geometry (-)',
418: p_prefix=>l_debug_prefix,
419: p_msg_level=>fnd_log.level_procedure);
420: END IF;
421: RETURN;

Line 1133: hz_utility_v2pub.debug(p_message=>'hz_geocode_pkg.parse_one_response (+)',

1129: x_geo_status := g_good;
1130:
1131: -- Debug info.
1132: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1133: hz_utility_v2pub.debug(p_message=>'hz_geocode_pkg.parse_one_response (+)',
1134: p_prefix=>l_debug_prefix,
1135: p_msg_level=>fnd_log.level_procedure);
1136: END IF;
1137:

Line 1741: p_module_prefix => 'HZ_GEOCODE_PKG',

1737: hz_utility_v2pub.DEBUG
1738: (p_message=>'get_spatial_coords (+)',
1739: p_prefix=>l_debug_prefix,
1740: p_msg_level=>fnd_log.level_procedure,
1741: p_module_prefix => 'HZ_GEOCODE_PKG',
1742: p_module =>'HZ');
1743: END IF;
1744:
1745: l_return_status := fnd_api.g_ret_sts_success;

Line 1766: p_module_prefix => 'HZ_GEOCODE_PKG',

1762: hz_utility_v2pub.DEBUG
1763: (p_message=>'xml returned by location_xml is not null',
1764: p_prefix=>l_debug_prefix,
1765: p_msg_level=>fnd_log.level_procedure,
1766: p_module_prefix => 'HZ_GEOCODE_PKG',
1767: p_module =>'HZ');
1768: hz_utility_v2pub.DEBUG
1769: (p_message=>'bfr hz_http_pkg.post LOOP',
1770: p_prefix=>l_debug_prefix,

Line 1772: p_module_prefix => 'HZ_GEOCODE_PKG',

1768: hz_utility_v2pub.DEBUG
1769: (p_message=>'bfr hz_http_pkg.post LOOP',
1770: p_prefix=>l_debug_prefix,
1771: p_msg_level=>fnd_log.level_procedure,
1772: p_module_prefix => 'HZ_GEOCODE_PKG',
1773: p_module =>'HZ');
1774: END IF;
1775: cpt := 0;
1776: LOOP

Line 1796: p_module_prefix => 'HZ_GEOCODE_PKG',

1792: hz_utility_v2pub.DEBUG
1793: (p_message=>'hz_http_pkg.post failed - UNEXPECTED ERROR',
1794: p_prefix=>l_debug_prefix,
1795: p_msg_level=>fnd_log.level_error,
1796: p_module_prefix => 'HZ_GEOCODE_PKG',
1797: p_module =>'HZ');
1798: hz_utility_v2pub.DEBUG
1799: (p_message=>'hz_http_pkg.post (-)',
1800: p_prefix=>l_debug_prefix,

Line 1802: p_module_prefix => 'HZ_GEOCODE_PKG',

1798: hz_utility_v2pub.DEBUG
1799: (p_message=>'hz_http_pkg.post (-)',
1800: p_prefix=>l_debug_prefix,
1801: p_msg_level=>fnd_log.level_procedure,
1802: p_module_prefix => 'HZ_GEOCODE_PKG',
1803: p_module =>'HZ');
1804: END IF;
1805: RAISE exchttp;
1806: END IF;

Line 1813: p_module_prefix => 'HZ_GEOCODE_PKG',

1809: hz_utility_v2pub.DEBUG
1810: (p_message=>'hz_http_pkg.post failed - EXPECTED ERROR',
1811: p_prefix=>l_debug_prefix,
1812: p_msg_level=>fnd_log.level_error,
1813: p_module_prefix => 'HZ_GEOCODE_PKG',
1814: p_module =>'HZ');
1815: hz_utility_v2pub.DEBUG
1816: (p_message=>'hz_http_pkg.post (-)',
1817: p_prefix=>l_debug_prefix,

Line 1819: p_module_prefix => 'HZ_GEOCODE_PKG',

1815: hz_utility_v2pub.DEBUG
1816: (p_message=>'hz_http_pkg.post (-)',
1817: p_prefix=>l_debug_prefix,
1818: p_msg_level=>fnd_log.level_procedure,
1819: p_module_prefix => 'HZ_GEOCODE_PKG',
1820: p_module =>'HZ');
1821: END IF;
1822: RAISE exchttp;
1823: END IF;

Line 1830: p_module_prefix => 'HZ_GEOCODE_PKG',

1826: hz_utility_v2pub.DEBUG
1827: (p_message=>'hz_http_pkg.post SUCCESS',
1828: p_prefix=>l_debug_prefix,
1829: p_msg_level=>fnd_log.level_procedure,
1830: p_module_prefix => 'HZ_GEOCODE_PKG',
1831: p_module =>'HZ');
1832: END IF;
1833: END IF;
1834: EXIT WHEN lresp IS NOT NULL;

Line 1842: p_module_prefix => 'HZ_GEOCODE_PKG',

1838: hz_utility_v2pub.DEBUG
1839: (p_message=>'Outside hz_http_pkg.post LOOP',
1840: p_prefix=>l_debug_prefix,
1841: p_msg_level=>fnd_log.level_procedure,
1842: p_module_prefix => 'HZ_GEOCODE_PKG',
1843: p_module =>'HZ');
1844: END IF;
1845:
1846: IF ltrim(rtrim(lresp)) IS NULL THEN

Line 1852: p_module_prefix => 'HZ_GEOCODE_PKG',

1848: hz_utility_v2pub.DEBUG
1849: (p_message=>'respose from hz_http_pkg.post() is NULL',
1850: p_prefix=>l_debug_prefix,
1851: p_msg_level=>fnd_log.level_error,
1852: p_module_prefix => 'HZ_GEOCODE_PKG',
1853: p_module =>'HZ');
1854: hz_utility_v2pub.DEBUG
1855: (p_message=>'printing the error respose (if any)from hz_http_pkg.post',
1856: p_prefix=>l_debug_prefix,

Line 1858: p_module_prefix => 'HZ_GEOCODE_PKG',

1854: hz_utility_v2pub.DEBUG
1855: (p_message=>'printing the error respose (if any)from hz_http_pkg.post',
1856: p_prefix=>l_debug_prefix,
1857: p_msg_level=>fnd_log.level_error,
1858: p_module_prefix => 'HZ_GEOCODE_PKG',
1859: p_module =>'HZ');
1860: hz_utility_v2pub.DEBUG
1861: (p_message=> NVL(l_err_resp,''),
1862: p_prefix=>l_debug_prefix,

Line 1864: p_module_prefix => 'HZ_GEOCODE_PKG',

1860: hz_utility_v2pub.DEBUG
1861: (p_message=> NVL(l_err_resp,''),
1862: p_prefix=>l_debug_prefix,
1863: p_msg_level=>fnd_log.level_error,
1864: p_module_prefix => 'HZ_GEOCODE_PKG',
1865: p_module =>'HZ');
1866: END IF;
1867: -- The post did not succeed, even after several retries. This is an
1868: -- unrecoverable error.

Line 1895: p_module_prefix => 'HZ_GEOCODE_PKG',

1891: hz_utility_v2pub.DEBUG
1892: (p_message=>'Response from eLocation is NOT in GEOCODE format for below locations '||l_error_loc_ids,
1893: p_prefix=>l_debug_prefix,
1894: p_msg_level=>fnd_log.level_error,
1895: p_module_prefix => 'HZ_GEOCODE_PKG',
1896: p_module =>'HZ');
1897:
1898: hz_utility_v2pub.DEBUG
1899: (p_message=>'respose from hz_http_pkg.post()is NOT a GEOCODE RESP ',

Line 1902: p_module_prefix => 'HZ_GEOCODE_PKG',

1898: hz_utility_v2pub.DEBUG
1899: (p_message=>'respose from hz_http_pkg.post()is NOT a GEOCODE RESP ',
1900: p_prefix=>l_debug_prefix,
1901: p_msg_level=>fnd_log.level_error,
1902: p_module_prefix => 'HZ_GEOCODE_PKG',
1903: p_module =>'HZ');
1904: hz_utility_v2pub.DEBUG
1905: (p_message=>'printing the error respose (if any)from hz_http_pkg.post',
1906: p_prefix=>l_debug_prefix,

Line 1908: p_module_prefix => 'HZ_GEOCODE_PKG',

1904: hz_utility_v2pub.DEBUG
1905: (p_message=>'printing the error respose (if any)from hz_http_pkg.post',
1906: p_prefix=>l_debug_prefix,
1907: p_msg_level=>fnd_log.level_error,
1908: p_module_prefix => 'HZ_GEOCODE_PKG',
1909: p_module =>'HZ');
1910: hz_utility_v2pub.DEBUG
1911: (p_message=> NVL(l_err_resp,''),
1912: p_prefix=>l_debug_prefix,

Line 1914: p_module_prefix => 'HZ_GEOCODE_PKG',

1910: hz_utility_v2pub.DEBUG
1911: (p_message=> NVL(l_err_resp,''),
1912: p_prefix=>l_debug_prefix,
1913: p_msg_level=>fnd_log.level_error,
1914: p_module_prefix => 'HZ_GEOCODE_PKG',
1915: p_module =>'HZ');
1916: END IF;
1917: -- Spatial response was not parseable. This is an unrecoverable error.
1918: -- l_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1936: p_module_prefix => 'HZ_GEOCODE_PKG',

1932: hz_utility_v2pub.DEBUG
1933: (p_message=>'exception when handling resp from hz_http_pkg.post',
1934: p_prefix=>l_debug_prefix,
1935: p_msg_level=>fnd_log.level_error,
1936: p_module_prefix => 'HZ_GEOCODE_PKG',
1937: p_module =>'HZ');
1938: hz_utility_v2pub.DEBUG
1939: (p_message=>SQLERRM,
1940: p_prefix=>l_debug_prefix,

Line 1942: p_module_prefix => 'HZ_GEOCODE_PKG',

1938: hz_utility_v2pub.DEBUG
1939: (p_message=>SQLERRM,
1940: p_prefix=>l_debug_prefix,
1941: p_msg_level=>fnd_log.level_error,
1942: p_module_prefix => 'HZ_GEOCODE_PKG',
1943: p_module =>'HZ');
1944: END IF;
1945: fnd_message.set_token('RESP', 'Malformed response');
1946: END; -- end of anonymous block

Line 1980: p_module_prefix => 'HZ_GEOCODE_PKG',

1976: hz_utility_v2pub.DEBUG
1977: (p_message=>'before get_response_lines()',
1978: p_prefix=>l_debug_prefix,
1979: p_msg_level=>fnd_log.level_error,
1980: p_module_prefix => 'HZ_GEOCODE_PKG',
1981: p_module =>'HZ');
1982: END IF;
1983: get_response_lines(
1984: p_str => lresp,

Line 1999: p_module_prefix => 'HZ_GEOCODE_PKG',

1995: hz_utility_v2pub.DEBUG
1996: (p_message=>'get_response_lines() returned is zero rows',
1997: p_prefix=>l_debug_prefix,
1998: p_msg_level=>fnd_log.level_error,
1999: p_module_prefix => 'HZ_GEOCODE_PKG',
2000: p_module =>'HZ');
2001: END IF;
2002: -- Set the error status for all records in this batch since no rows
2003: -- were returned by the data provider.

Line 2013: p_module_prefix => 'HZ_GEOCODE_PKG',

2009: hz_utility_v2pub.DEBUG
2010: (p_message=>'before parse_responses()',
2011: p_prefix=>l_debug_prefix,
2012: p_msg_level=>fnd_log.level_procedure,
2013: p_module_prefix => 'HZ_GEOCODE_PKG',
2014: p_module =>'HZ');
2015: END IF;
2016: parse_responses(
2017: p_tab_address => ltab,

Line 2037: p_module_prefix => 'HZ_GEOCODE_PKG',

2033: hz_utility_v2pub.DEBUG
2034: (p_message=>'get_spatial_coords(-)',
2035: p_prefix=>l_debug_prefix,
2036: p_msg_level=>fnd_log.level_procedure,
2037: p_module_prefix => 'HZ_GEOCODE_PKG',
2038: p_module =>'HZ');
2039: END IF;
2040: EXCEPTION
2041: WHEN exchttp THEN

Line 2046: END hz_geocode_pkg;

2042: status_handler(l_return_status, x_return_status);
2043: END get_spatial_coords;
2044: ------------------------------------------------------------
2045: ------------------------------------------------------------
2046: END hz_geocode_pkg;