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_GNR_PKG

Line 1: PACKAGE BODY HZ_GNR_PKG AS

1: PACKAGE BODY HZ_GNR_PKG AS
2: /*$Header: ARHGNRCB.pls 120.28 2008/03/11 08:36:57 nshinde ship $ */
3:
4: -- G_SUCCESS varchar2(30) := 'SUCCESS';
5: -- G_ERROR varchar2(30) := 'ERROR';

Line 14: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRCB:HZ_GNR_PKG';

10: -- and then tries to create address. (21-Sep-2006 Nishant)
11: PROCEDURE recompile_pkg (p_pkg_name IN VARCHAR2)IS
12: PRAGMA AUTONOMOUS_TRANSACTION;
13:
14: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRCB:HZ_GNR_PKG';
15: l_module CONSTANT VARCHAR2(30) := 'ADDRESS_VALIDATION';
16: l_debug_prefix CONSTANT VARCHAR2(30) := '';
17:
18: BEGIN

Line 931: HZ_GNR_PKG.G_API_PURPOSE := 'GNR';

927: -- This variable is checked in HZ_GNR_UTIL_PKG.create_gnr procedure
928: -- For any address validation call from GNR this variable will be set at
929: -- PROCEDURE level to 'GNR'
930: -- Nishant (Perf Bug 5881539 16-APR-2007)
931: HZ_GNR_PKG.G_API_PURPOSE := 'GNR';
932:
933: -- Initialize return status and message stack
934: FND_MSG_PUB.initialize;
935:

Line 986: HZ_GNR_PKG.delete_gnr(p_locId => l_cur_location_id,

982:
983: -- HZ_GNR_UTIL_PKG.log('Current location ' || l_cur_location_id);
984:
985: BEGIN
986: HZ_GNR_PKG.delete_gnr(p_locId => l_cur_location_id,
987: p_locTbl => p_location_table_name,
988: x_status => l_return_status
989: );
990:

Line 991: HZ_GNR_PKG.validateHrLoc(l_cur_location_id,

987: p_locTbl => p_location_table_name,
988: x_status => l_return_status
989: );
990:
991: HZ_GNR_PKG.validateHrLoc(l_cur_location_id,
992: l_return_status
993: );
994: EXCEPTION
995: WHEN FND_API.G_EXC_ERROR THEN

Line 1076: HZ_GNR_PKG.validateHrLoc(l_cur_location_id,

1072:
1073: -- HZ_GNR_UTIL_PKG.log('Current location ' || l_cur_location_id);
1074:
1075: BEGIN
1076: HZ_GNR_PKG.validateHrLoc(l_cur_location_id,
1077: l_return_status
1078: );
1079: EXCEPTION
1080: WHEN FND_API.G_EXC_ERROR THEN

Line 1161: HZ_GNR_PKG.validateHrLoc(l_cur_location_id,

1157:
1158: -- HZ_GNR_UTIL_PKG.log('Current location ' || l_cur_location_id);
1159:
1160: BEGIN
1161: HZ_GNR_PKG.validateHrLoc(l_cur_location_id,
1162: l_return_status
1163: );
1164: EXCEPTION
1165: WHEN FND_API.G_EXC_ERROR THEN

Line 1253: -- HZ_GNR_PKG.delete_gnr(p_locId => l_cur_location_id,

1249: BEGIN
1250: -- delete for all usages (l_usage_code is set to ALL for runtype ALL)
1251: -- Commented the below code for bug to handle "DUMMY" locations. Bug # 5022121
1252: -- This delete gnr will take place inside create gnr.
1253: -- HZ_GNR_PKG.delete_gnr(p_locId => l_cur_location_id,
1254: -- p_locTbl => p_location_table_name,
1255: -- x_status => l_return_status
1256: -- );
1257:

Line 1258: HZ_GNR_PKG.validateLoc(

1254: -- p_locTbl => p_location_table_name,
1255: -- x_status => l_return_status
1256: -- );
1257:
1258: HZ_GNR_PKG.validateLoc(
1259: P_LOCATION_ID => l_cur_location_id,
1260: P_USAGE_CODE => l_usage_code,
1261: P_ADDRESS_STYLE => l_c_loc_hz.ADDRESS_STYLE,
1262: P_COUNTRY => l_c_loc_hz.COUNTRY,

Line 1379: HZ_GNR_PKG.validateLoc(

1375: l_cur_location_id := l_c_loc_hz.LOCATION_ID;
1376: -- HZ_GNR_UTIL_PKG.log('Current location ' || l_cur_location_id);
1377:
1378: BEGIN
1379: HZ_GNR_PKG.validateLoc(
1380: P_LOCATION_ID => l_cur_location_id,
1381: P_USAGE_CODE => l_usage_code,
1382: P_ADDRESS_STYLE => l_c_loc_hz.ADDRESS_STYLE,
1383: P_COUNTRY => l_c_loc_hz.COUNTRY,

Line 1483: HZ_GNR_PKG.validateLoc(

1479: l_cur_location_id := l_c_loc_hz.LOCATION_ID;
1480: -- HZ_GNR_UTIL_PKG.log('Current location ' || l_cur_location_id);
1481:
1482: BEGIN
1483: HZ_GNR_PKG.validateLoc(
1484: P_LOCATION_ID => l_cur_location_id,
1485: P_USAGE_CODE => l_usage_code,
1486: P_ADDRESS_STYLE => l_c_loc_hz.ADDRESS_STYLE,
1487: P_COUNTRY => l_c_loc_hz.COUNTRY,

Line 1570: -- Replaced by HZ_GNR_PKG.G_API_PURPOSE

1566: -- Initialize Global Variable so that later update location is avoided
1567: -- This variable is checked in HZ_GNR_UTIL_PKG.create_gnr procedure
1568: -- Nishant (Perf Bug 5407103 4-AUG-2006)
1569: ------------------------------------------------------------------------
1570: -- Replaced by HZ_GNR_PKG.G_API_PURPOSE
1571: -- Nishant (Perf Bug 5881539 16-APR-2007)
1572: ------------------------------------------------------------------------
1573: -- HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := 'R12UPGRADE';
1574: HZ_GNR_PKG.G_API_PURPOSE := 'R12UPGRADE';

Line 1574: HZ_GNR_PKG.G_API_PURPOSE := 'R12UPGRADE';

1570: -- Replaced by HZ_GNR_PKG.G_API_PURPOSE
1571: -- Nishant (Perf Bug 5881539 16-APR-2007)
1572: ------------------------------------------------------------------------
1573: -- HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := 'R12UPGRADE';
1574: HZ_GNR_PKG.G_API_PURPOSE := 'R12UPGRADE';
1575:
1576: -- populate plsql table with mapped countries info
1577: FOR c_map_cnt_rec IN c_r12_upg_map_cnt LOOP
1578: mapped_country_list(mapped_country_list.COUNT+1) := c_map_cnt_rec.country_code;

Line 1597: HZ_GNR_PKG.validateLoc(

1593: -- HZ_GNR_UTIL_PKG.log('Current location ' || l_cur_location_id);
1594:
1595: BEGIN
1596:
1597: HZ_GNR_PKG.validateLoc(
1598: P_LOCATION_ID => l_c_loc_hz.LOCATION_ID,
1599: P_USAGE_CODE => l_usage_code,
1600: P_ADDRESS_STYLE => l_c_loc_hz.ADDRESS_STYLE,
1601: P_COUNTRY => l_c_loc_hz.COUNTRY,

Line 1676: HZ_GNR_PKG.G_API_PURPOSE := NULL;

1672: HZ_GNR_UTIL_PKG.log('Geo Name Referencing process completed successfully');
1673: END IF;
1674:
1675: -- Reset Global variable
1676: HZ_GNR_PKG.G_API_PURPOSE := NULL;
1677:
1678: -- IF (TO_NUMBER(p_worker_number)= 1) THEN
1679: -- execute IMMEDIATE 'ALTER SESSION SET SQL_TRACE = FALSE';
1680: -- END IF;

Line 1689: HZ_GNR_PKG.G_API_PURPOSE := NULL;

1685: -- execute IMMEDIATE 'ALTER SESSION SET SQL_TRACE = FALSE';
1686: --END IF;
1687:
1688: -- Reset Global variable
1689: HZ_GNR_PKG.G_API_PURPOSE := NULL;
1690:
1691: HZ_GNR_UTIL_PKG.outandlog('Unknown Error at Location ID: ' || l_cur_location_id || ' : ' || SQLERRM);
1692: HZ_GNR_UTIL_PKG.outandlog('Error: Aborting Geo Name Referencing');
1693: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 1771: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRCB:HZ_GNR_PKG';

1767: l_sql VARCHAR2(2000);
1768: l_status VARCHAR2(1);
1769: l_map_id number;
1770:
1771: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRCB:HZ_GNR_PKG';
1772: l_module CONSTANT VARCHAR2(30) := 'ADDRESS_VALIDATION';
1773: l_debug_prefix VARCHAR2(30) := p_location_id;
1774:
1775: CURSOR c_loc(p_loc_id in number) IS

Line 1908: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRCB:HZ_GNR_PKG';

1904: l_addr_warn_msg varchar2(2000);
1905: l_country_code VARCHAR2(10);
1906: l_usage_tbl HZ_GNR_UTIL_PKG.usage_tbl_type;
1907:
1908: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRCB:HZ_GNR_PKG';
1909: l_module CONSTANT VARCHAR2(30) := 'ADDRESS_VALIDATION';
1910: l_debug_prefix VARCHAR2(30) := p_location_id;
1911:
1912: --------