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_GNR_PKG dependencies on HZ_UTILITY_V2PUB

Line 20: hz_utility_v2pub.debug

16: l_debug_prefix CONSTANT VARCHAR2(30) := '';
17:
18: BEGIN
19: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
20: hz_utility_v2pub.debug
21: (p_message => 'Begin Compile Package '||p_pkg_name,
22: p_prefix => l_debug_prefix,
23: p_msg_level => fnd_log.level_statement,
24: p_module_prefix => l_module_prefix,

Line 32: hz_utility_v2pub.debug

28:
29: EXECUTE IMMEDIATE 'ALTER PACKAGE '||p_pkg_name||' COMPILE';
30:
31: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
32: hz_utility_v2pub.debug
33: (p_message => 'Completed Compiling Package '||p_pkg_name,
34: p_prefix => l_debug_prefix,
35: p_msg_level => fnd_log.level_statement,
36: p_module_prefix => l_module_prefix,

Line 45: hz_utility_v2pub.debug

41: COMMIT;
42: EXCEPTION WHEN OTHERS THEN
43:
44: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
45: hz_utility_v2pub.debug
46: (p_message => 'EXCEPTION during compiling Package '||p_pkg_name||
47: ':'||SQLERRM,
48: p_prefix => l_debug_prefix,
49: p_msg_level => fnd_log.level_statement,

Line 1783: hz_utility_v2pub.debug

1779: BEGIN
1780: x_status := fnd_api.g_ret_sts_success; -- defaulting the sucess status.
1781:
1782: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1783: hz_utility_v2pub.debug
1784: (p_message => 'Begin of validation procedure validateHrLoc',
1785: p_prefix => l_debug_prefix,
1786: p_msg_level => fnd_log.level_procedure,
1787: p_module_prefix => l_module_prefix,

Line 1795: hz_utility_v2pub.debug

1791:
1792: FOR l_c_loc in c_loc(P_LOCATION_ID) LOOP -- only one record will be featched.
1793: l_map_id := get_map_id(l_c_loc.country,'HR_LOCATIONS_ALL',l_c_loc.style);
1794: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1795: hz_utility_v2pub.debug
1796: (p_message => ' Map Id for the country : '||l_map_id,
1797: p_prefix => l_debug_prefix,
1798: p_msg_level => fnd_log.level_statement,
1799: p_module_prefix => l_module_prefix,

Line 1805: hz_utility_v2pub.debug

1801: );
1802: END IF;
1803: IF l_map_id IS NULL THEN
1804: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1805: hz_utility_v2pub.debug
1806: (p_message => ' No mapping exists for the country. Raise error and exit.',
1807: p_prefix => l_debug_prefix,
1808: p_msg_level => fnd_log.level_statement,
1809: p_module_prefix => l_module_prefix,

Line 1819: hz_utility_v2pub.debug

1815: END IF;
1816: END LOOP;
1817:
1818: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1819: hz_utility_v2pub.debug
1820: (p_message => 'Before calling HZ_GNR_MAP'||l_map_id||'.validateHrLoc',
1821: p_prefix => l_debug_prefix,
1822: p_msg_level => fnd_log.level_procedure,
1823: p_module_prefix => l_module_prefix,

Line 1833: hz_utility_v2pub.debug

1829: BEGIN
1830: EXECUTE IMMEDIATE l_sql USING P_LOCATION_ID,OUT l_status;
1831: EXCEPTION WHEN OTHERS THEN
1832: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1833: hz_utility_v2pub.debug
1834: (p_message => SUBSTR(' Exception when others in '||' HZ_GNR_MAP'||l_map_id||'.validateHrLoc ' ||SQLERRM,1,255),
1835: p_prefix => l_debug_prefix,
1836: p_msg_level => fnd_log.level_exception,
1837: p_module_prefix => l_module_prefix,

Line 1846: hz_utility_v2pub.debug

1842: RAISE FND_API.G_EXC_ERROR;
1843: END;
1844:
1845: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1846: hz_utility_v2pub.debug
1847: (p_message => 'After calling HZ_GNR_MAP'||l_map_id||'.validateHrLoc Return status : '||l_status,
1848: p_prefix => l_debug_prefix,
1849: p_msg_level => fnd_log.level_procedure,
1850: p_module_prefix => l_module_prefix,

Line 1856: hz_utility_v2pub.debug

1852: );
1853: END IF;
1854:
1855: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1856: hz_utility_v2pub.debug
1857: (p_message => 'End of validation procedure validateHrLoc',
1858: p_prefix => l_debug_prefix,
1859: p_msg_level => fnd_log.level_procedure,
1860: p_module_prefix => l_module_prefix,

Line 1944: hz_utility_v2pub.debug

1940: -- exception and recompile package (till OA provides fix)
1941: -- Fix done on 21-Sep-2006 (Nishant))
1942: WHEN ex_pkg_invalidated_state THEN
1943: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1944: hz_utility_v2pub.debug
1945: (p_message => ' Went in get_usage_API ex_pkg_invalidated_state EXCEPTION ',
1946: p_prefix => l_debug_prefix,
1947: p_msg_level => fnd_log.level_procedure,
1948: p_module_prefix => l_module_prefix,

Line 1957: hz_utility_v2pub.debug

1953: EXECUTE IMMEDIATE l_sql USING OUT l_usage_API,p_usage_code;
1954:
1955: WHEN ex_pkg_altered THEN
1956: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1957: hz_utility_v2pub.debug
1958: (p_message => ' Went in get_usage_API ex_pkg_altered EXCEPTION ',
1959: p_prefix => l_debug_prefix,
1960: p_msg_level => fnd_log.level_procedure,
1961: p_module_prefix => l_module_prefix,

Line 1971: hz_utility_v2pub.debug

1967: END;
1968:
1969: EXCEPTION WHEN OTHERS THEN
1970: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1971: hz_utility_v2pub.debug
1972: (p_message => SUBSTR(' Exception when others in get_usage_API : '||SQLERRM,1,255),
1973: p_prefix => l_debug_prefix,
1974: p_msg_level => fnd_log.level_exception,
1975: p_module_prefix => l_module_prefix,

Line 1990: hz_utility_v2pub.debug

1986: x_status := fnd_api.g_ret_sts_success; -- defaulting the sucess status.
1987: x_addr_val_status := FND_api.g_ret_sts_success; -- defaulting the sucess status.
1988:
1989: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1990: hz_utility_v2pub.debug
1991: (p_message => 'Begin of validation procedure validateLoc',
1992: p_prefix => l_debug_prefix,
1993: p_msg_level => fnd_log.level_procedure,
1994: p_module_prefix => l_module_prefix,

Line 2004: hz_utility_v2pub.debug

2000: -- It does not matter what is passed, based on passed value, get country code
2001: l_country_code := get_country_code(P_COUNTRY);
2002:
2003: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2004: hz_utility_v2pub.debug
2005: (p_message => ' Derived country code : '||l_country_code,
2006: p_prefix => l_debug_prefix,
2007: p_msg_level => fnd_log.level_statement,
2008: p_module_prefix => l_module_prefix,

Line 2018: hz_utility_v2pub.debug

2014: l_addr_val_level := HZ_GNR_PUB.GET_ADDR_VAL_LEVEL(l_country_code);
2015: x_addr_val_level := l_addr_val_level;
2016:
2017: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2018: hz_utility_v2pub.debug
2019: (p_message => ' Derived address validation level : '||l_addr_val_level,
2020: p_prefix => l_debug_prefix,
2021: p_msg_level => fnd_log.level_statement,
2022: p_module_prefix => l_module_prefix,

Line 2030: hz_utility_v2pub.debug

2026:
2027: l_mapid := get_map_id(l_country_code,'HZ_LOCATIONS',p_address_style);
2028:
2029: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2030: hz_utility_v2pub.debug
2031: (p_message => ' Map Id for the above country : '||l_mapid,
2032: p_prefix => l_debug_prefix,
2033: p_msg_level => fnd_log.level_statement,
2034: p_module_prefix => l_module_prefix,

Line 2042: hz_utility_v2pub.debug

2038:
2039: IF l_mapid IS NULL THEN
2040: IF l_addr_val_level <> 'NONE' OR p_called_from = 'GNR' THEN
2041: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2042: hz_utility_v2pub.debug
2043: (p_message => ' Validation level is not set to NONE or called from is GNR and no mapping for the country. ',
2044: p_prefix => l_debug_prefix,
2045: p_msg_level => fnd_log.level_statement,
2046: p_module_prefix => l_module_prefix,

Line 2058: hz_utility_v2pub.debug

2054: RAISE FND_API.G_EXC_ERROR;
2055: ELSIF l_addr_val_level = 'NONE' THEN -- Validation level is set to none and no mapping for the country
2056: -- It is not required to do any further processing even for TAX.
2057: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2058: hz_utility_v2pub.debug
2059: (p_message => ' Validation level is set to NONE and no mapping for the country. It is not required to do any further processing even for TAX ',
2060: p_prefix => l_debug_prefix,
2061: p_msg_level => fnd_log.level_statement,
2062: p_module_prefix => l_module_prefix,

Line 2072: hz_utility_v2pub.debug

2068: END IF;
2069:
2070: IF p_called_from = 'GNR' AND p_usage_code = 'ALL' THEN
2071: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2072: hz_utility_v2pub.debug
2073: (p_message => ' p_called_from is GNR and usage code is ALL. So, get all valid usages into l_usage_tbl',
2074: p_prefix => l_debug_prefix,
2075: p_msg_level => fnd_log.level_statement,
2076: p_module_prefix => l_module_prefix,

Line 2085: hz_utility_v2pub.debug

2081: FOR l_c_usage IN c_usage(l_mapid) LOOP
2082: i := i + 1;
2083: l_usage_tbl(i).USAGE_CODE := l_c_usage.USAGE_CODE;
2084: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2085: hz_utility_v2pub.debug
2086: (p_message => ' Usage code '|| i ||' : '||l_c_usage.USAGE_CODE,
2087: p_prefix => l_debug_prefix,
2088: p_msg_level => fnd_log.level_statement,
2089: p_module_prefix => l_module_prefix,

Line 2096: hz_utility_v2pub.debug

2092: END IF;
2093: END LOOP;
2094: ELSE
2095: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2096: hz_utility_v2pub.debug
2097: (p_message => ' p_called_from is not GNR and usage code is '||p_usage_code,
2098: p_prefix => l_debug_prefix,
2099: p_msg_level => fnd_log.level_statement,
2100: p_module_prefix => l_module_prefix,

Line 2112: hz_utility_v2pub.debug

2108: IF (l_usage_tbl.COUNT > 0) THEN
2109: FOR i in l_usage_tbl.FIRST .. l_usage_tbl.LAST LOOP
2110: l_usage_API := get_usage_API(l_mapid,l_usage_tbl(i).usage_code);
2111: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2112: hz_utility_v2pub.debug
2113: (p_message => ' Name of the usage API : '||l_usage_API,
2114: p_prefix => l_debug_prefix,
2115: p_msg_level => fnd_log.level_statement,
2116: p_module_prefix => l_module_prefix,

Line 2123: hz_utility_v2pub.debug

2119: END IF;
2120: IF l_usage_API IS NULL THEN
2121: IF l_addr_val_level <> 'NONE' OR p_called_from = 'GNR' THEN
2122: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2123: hz_utility_v2pub.debug
2124: (p_message => ' Raising the error because, validation level is other than NONE or it is called from GNR conc prog',
2125: p_prefix => l_debug_prefix,
2126: p_msg_level => fnd_log.level_statement,
2127: p_module_prefix => l_module_prefix,

Line 2149: hz_utility_v2pub.debug

2145:
2146: l_call_map := 'Y';
2147:
2148: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2149: hz_utility_v2pub.debug
2150: (p_message => 'Before calling HZ_GNR_MAP'||l_mapId||'.'||l_usage_API,
2151: p_prefix => l_debug_prefix,
2152: p_msg_level => fnd_log.level_procedure,
2153: p_module_prefix => l_module_prefix,

Line 2216: hz_utility_v2pub.debug

2212:
2213: x_status := L_STATUS;
2214:
2215: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2216: hz_utility_v2pub.debug
2217: (p_message => 'After calling HZ_GNR_MAP'||l_mapId||'.'||l_usage_API,
2218: p_prefix => l_debug_prefix,
2219: p_msg_level => fnd_log.level_procedure,
2220: p_module_prefix => l_module_prefix,

Line 2226: hz_utility_v2pub.debug

2222: );
2223: END IF;
2224:
2225: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2226: hz_utility_v2pub.debug
2227: (p_message => ' Return status : '||L_STATUS|| ' and address validation status : '||X_ADDR_VAL_STATUS,
2228: p_prefix => l_debug_prefix,
2229: p_msg_level => fnd_log.level_procedure,
2230: p_module_prefix => l_module_prefix,

Line 2238: hz_utility_v2pub.debug

2234:
2235: EXCEPTION
2236: WHEN OTHERS THEN
2237: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2238: hz_utility_v2pub.debug
2239: (p_message => SUBSTR(' Exception when others in '||' HZ_GNR_MAP'||l_mapId||'.'||l_usage_API ||' : ' ||SQLERRM,1,255),
2240: p_prefix => l_debug_prefix,
2241: p_msg_level => fnd_log.level_exception,
2242: p_module_prefix => l_module_prefix,

Line 2251: hz_utility_v2pub.debug

2247: END;
2248:
2249: IF p_called_from = 'VALIDATE' and l_usage_tbl(i).usage_code <> 'TAX' and p_location_id IS NOT NULL THEN
2250: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2251: hz_utility_v2pub.debug
2252: (p_message => 'p_called_from is VALIDATE and usage code is not TAX and location_id IS NOT NULL. So, call tax validation.',
2253: p_prefix => l_debug_prefix,
2254: p_msg_level => fnd_log.level_statement,
2255: p_module_prefix => l_module_prefix,

Line 2261: hz_utility_v2pub.debug

2257: );
2258: END IF;
2259: l_usage_API := get_usage_API(l_mapid,'TAX');
2260: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2261: hz_utility_v2pub.debug
2262: (p_message => ' Name of the usage API : '||l_usage_API,
2263: p_prefix => l_debug_prefix,
2264: p_msg_level => fnd_log.level_statement,
2265: p_module_prefix => l_module_prefix,

Line 2274: hz_utility_v2pub.debug

2270: RETURN;
2271: END IF;
2272:
2273: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2274: hz_utility_v2pub.debug
2275: (p_message => 'Before calling HZ_GNR_MAP'||l_mapId||'.'||l_usage_API,
2276: p_prefix => l_debug_prefix,
2277: p_msg_level => fnd_log.level_procedure,
2278: p_module_prefix => l_module_prefix,

Line 2342: hz_utility_v2pub.debug

2338:
2339: -- even if Tax validation fails no need to change the overall status x_status := L_STATUS;
2340:
2341: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2342: hz_utility_v2pub.debug
2343: (p_message => 'After calling HZ_GNR_MAP'||l_mapId||'.'||l_usage_API,
2344: p_prefix => l_debug_prefix,
2345: p_msg_level => fnd_log.level_procedure,
2346: p_module_prefix => l_module_prefix,

Line 2352: hz_utility_v2pub.debug

2348: );
2349: END IF;
2350:
2351: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2352: hz_utility_v2pub.debug
2353: (p_message => ' Return status : '||L_STATUS|| ' and address validation status : '||L_ADDR_VAL_STATUS,
2354: p_prefix => l_debug_prefix,
2355: p_msg_level => fnd_log.level_procedure,
2356: p_module_prefix => l_module_prefix,

Line 2363: hz_utility_v2pub.debug

2359: END IF;
2360:
2361: EXCEPTION WHEN OTHERS THEN
2362: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2363: hz_utility_v2pub.debug
2364: (p_message => SUBSTR(' Exception when others in '||' HZ_GNR_MAP'||l_mapId||'.'||l_usage_API ||' : ' ||SQLERRM,1,255),
2365: p_prefix => l_debug_prefix,
2366: p_msg_level => fnd_log.level_exception,
2367: p_module_prefix => l_module_prefix,

Line 2377: hz_utility_v2pub.debug

2373: END IF;
2374: END LOOP;
2375: ELSE
2376: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2377: hz_utility_v2pub.debug
2378: (p_message => ' There is no active usage available for validation',
2379: p_prefix => l_debug_prefix,
2380: p_msg_level => fnd_log.level_statement,
2381: p_module_prefix => l_module_prefix,

Line 2391: hz_utility_v2pub.debug

2387: -- If it is called from GNR conc prog, we will always try to create GNR
2388: -- irrespective of validation level.
2389: IF ((l_addr_val_level <> 'NONE') OR (p_called_from = 'GNR')) THEN
2390: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2391: hz_utility_v2pub.debug
2392: (p_message => ' Raising the error because, validation level is other than NONE or it is called from GNR conc prog',
2393: p_prefix => l_debug_prefix,
2394: p_msg_level => fnd_log.level_statement,
2395: p_module_prefix => l_module_prefix,

Line 2409: hz_utility_v2pub.debug

2405: NULL;
2406: END IF;
2407: END IF;
2408: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2409: hz_utility_v2pub.debug
2410: (p_message => 'End of validation procedure validateLoc',
2411: p_prefix => l_debug_prefix,
2412: p_msg_level => fnd_log.level_procedure,
2413: p_module_prefix => l_module_prefix,