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 FND_LOG

Line 19: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

15: l_module CONSTANT VARCHAR2(30) := 'ADDRESS_VALIDATION';
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,

Line 23: p_msg_level => fnd_log.level_statement,

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,
25: p_module => l_module
26: );
27: END IF;

Line 31: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

27: END IF;
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,

Line 35: p_msg_level => fnd_log.level_statement,

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,
37: p_module => l_module
38: );
39: END IF;

Line 44: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

40:
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,

Line 49: p_msg_level => fnd_log.level_statement,

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,
50: p_module_prefix => l_module_prefix,
51: p_module => l_module
52: );
53: END IF;

Line 1782: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1778: WHERE location_id = p_loc_id;
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,

Line 1786: p_msg_level => fnd_log.level_procedure,

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,
1788: p_module => l_module
1789: );
1790: END IF;

Line 1794: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1790: END IF;
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,

Line 1798: p_msg_level => fnd_log.level_statement,

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,
1800: p_module => l_module
1801: );
1802: END IF;

Line 1804: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1800: p_module => l_module
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,

Line 1808: p_msg_level => fnd_log.level_statement,

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,
1810: p_module => l_module
1811: );
1812: END IF;

Line 1818: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1814: RAISE FND_API.G_EXC_ERROR;
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,

Line 1822: p_msg_level => fnd_log.level_procedure,

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,
1824: p_module => l_module
1825: );
1826: END IF;

Line 1832: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

1828: l_sql := 'BEGIN HZ_GNR_MAP'||l_map_id||'.validateHrLoc(:location_id,:status); END;';
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,

Line 1836: p_msg_level => fnd_log.level_exception,

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,
1838: p_module => l_module
1839: );
1840: END IF;

Line 1845: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1841: x_status := FND_API.G_RET_STS_ERROR;
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,

Line 1849: p_msg_level => fnd_log.level_procedure,

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,
1851: p_module => l_module
1852: );
1853: END IF;

Line 1855: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1851: p_module => l_module
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,

Line 1859: p_msg_level => fnd_log.level_procedure,

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,
1861: p_module => l_module
1862: );
1863: END IF;

Line 1943: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1939: -- of retaining connection pool. This is a workaround to trap the invalid package
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,

Line 1947: p_msg_level => fnd_log.level_procedure,

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,
1949: p_module => l_module
1950: );
1951: END IF;

Line 1956: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1952: recompile_pkg('HZ_GNR_MAP'||l_mapId);
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,

Line 1960: p_msg_level => fnd_log.level_procedure,

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,
1962: p_module => l_module
1963: );
1964: END IF;

Line 1970: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

1966: EXECUTE IMMEDIATE l_sql USING OUT l_usage_API,p_usage_code;
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,

Line 1974: p_msg_level => fnd_log.level_exception,

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,
1976: p_module => l_module
1977: );
1978: END IF;

Line 1989: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1985:
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,

Line 1993: p_msg_level => fnd_log.level_procedure,

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,
1995: p_module => l_module
1996: );
1997: END IF;

Line 2003: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1999: -- Get country code. It is possible in GNR that country name is passed.
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,

Line 2007: p_msg_level => fnd_log.level_statement,

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,
2009: p_module => l_module
2010: );
2011: END IF;

Line 2017: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2013: -- get the mapId
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,

Line 2021: p_msg_level => fnd_log.level_statement,

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,
2023: p_module => l_module
2024: );
2025: END IF;

Line 2029: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2025: END IF;
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,

Line 2033: p_msg_level => fnd_log.level_statement,

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,
2035: p_module => l_module
2036: );
2037: END IF;

Line 2041: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2037: END IF;
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,

Line 2045: p_msg_level => fnd_log.level_statement,

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,
2047: p_module => l_module
2048: );
2049: END IF;

Line 2057: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2053: FND_MSG_PUB.ADD;
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,

Line 2061: p_msg_level => fnd_log.level_statement,

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,
2063: p_module => l_module
2064: );
2065: END IF;

Line 2071: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2067: END IF;
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,

Line 2075: p_msg_level => fnd_log.level_statement,

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,
2077: p_module => l_module
2078: );
2079: END IF;

Line 2084: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2080: i := 0;
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,

Line 2088: p_msg_level => fnd_log.level_statement,

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,
2090: p_module => l_module
2091: );
2092: END IF;

Line 2095: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2091: );
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,

Line 2099: p_msg_level => fnd_log.level_statement,

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,
2101: p_module => l_module
2102: );
2103: END IF;

Line 2111: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2107: -- do processing only if there is any usage to be processed
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,

Line 2115: p_msg_level => fnd_log.level_statement,

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,
2117: p_module => l_module
2118: );
2119: END IF;

Line 2122: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2118: );
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,

Line 2126: p_msg_level => fnd_log.level_statement,

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,
2128: p_module => l_module
2129: );
2130: END IF;

Line 2148: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2144: END IF;
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,

Line 2152: p_msg_level => fnd_log.level_procedure,

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,
2154: p_module => l_module
2155: );
2156: END IF;

Line 2215: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2211: IN OUT L_STATUS;
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,

Line 2219: p_msg_level => fnd_log.level_procedure,

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,
2221: p_module => l_module
2222: );
2223: END IF;

Line 2225: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2221: p_module => l_module
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,

Line 2229: p_msg_level => fnd_log.level_procedure,

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,
2231: p_module => l_module
2232: );
2233: END IF;

Line 2237: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

2233: END IF;
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,

Line 2241: p_msg_level => fnd_log.level_exception,

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,
2243: p_module => l_module
2244: );
2245: END IF;

Line 2250: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2246: x_status := FND_API.G_RET_STS_ERROR;
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,

Line 2254: p_msg_level => fnd_log.level_statement,

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,
2256: p_module => l_module
2257: );
2258: END IF;

Line 2260: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2256: p_module => l_module
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,

Line 2264: p_msg_level => fnd_log.level_statement,

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,
2266: p_module => l_module
2267: );
2268: END IF;

Line 2273: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2269: IF l_usage_API IS NULL THEN -- there is no mapping for Tax and no GNR processing or TAX is required.
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,

Line 2277: p_msg_level => fnd_log.level_procedure,

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,
2279: p_module => l_module
2280: );
2281: END IF;

Line 2341: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2337: IN OUT L_STATUS;
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,

Line 2345: p_msg_level => fnd_log.level_procedure,

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,
2347: p_module => l_module
2348: );
2349: END IF;

Line 2351: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2347: p_module => l_module
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,

Line 2355: p_msg_level => fnd_log.level_procedure,

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,
2357: p_module => l_module
2358: );
2359: END IF;

Line 2362: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

2358: );
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,

Line 2366: p_msg_level => fnd_log.level_exception,

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,
2368: p_module => l_module
2369: );
2370: END IF;

Line 2376: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2372: END;
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,

Line 2380: p_msg_level => fnd_log.level_statement,

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,
2382: p_module => l_module
2383: );
2384: END IF;

Line 2390: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2386: -- we want to raise error message only if validation level is other than NONE
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,

Line 2394: p_msg_level => fnd_log.level_statement,

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,
2396: p_module => l_module
2397: );
2398: END IF;

Line 2408: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2404: ELSE
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,

Line 2412: p_msg_level => fnd_log.level_procedure,

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,
2414: p_module => l_module
2415: );
2416: END IF;