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_UTIL_PKG dependencies on HZ_GNR_UTIL_PKG

Line 1: PACKAGE BODY HZ_GNR_UTIL_PKG AS

1: PACKAGE BODY HZ_GNR_UTIL_PKG AS
2: /*$Header: ARHGNRUB.pls 120.35 2011/05/05 07:40:25 rgokavar ship $ */
3:
4:
5: --------------------------------------

Line 154: IN OUT p_other_location_params HZ_GNR_UTIL_PKG.location_other_param_rec_type

150: ARGUMENTS :
151: IN p_old_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
152:
153: IN OUT p_new_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
154: IN OUT p_other_location_params HZ_GNR_UTIL_PKG.location_other_param_rec_type
155: (extendible - for future use)
156:
157: MODIFICATION HISTORY:
158: 16-FEB-2006 Nishant Singhai Created

Line 163: p_other_location_params IN OUT NOCOPY HZ_GNR_UTIL_PKG.loc_other_param_rec_type,

159: **/
160: PROCEDURE pre_location_update (
161: p_old_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
162: p_new_location_rec IN OUT NOCOPY HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
163: p_other_location_params IN OUT NOCOPY HZ_GNR_UTIL_PKG.loc_other_param_rec_type,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2
167: ) IS

Line 259: IN OUT p_other_location_params HZ_GNR_UTIL_PKG.location_other_param_rec_type

255: ARGUMENTS :
256: IN p_old_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
257:
258: IN OUT p_new_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
259: IN OUT p_other_location_params HZ_GNR_UTIL_PKG.location_other_param_rec_type
260: (extendible - for future use)
261:
262: MODIFICATION HISTORY:
263: 16-FEB-2006 Nishant Singhai Created

Line 268: p_other_location_params IN OUT NOCOPY HZ_GNR_UTIL_PKG.loc_other_param_rec_type,

264: **/
265: PROCEDURE post_location_update (
266: p_old_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
267: p_new_location_rec IN OUT NOCOPY HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
268: p_other_location_params IN OUT NOCOPY HZ_GNR_UTIL_PKG.loc_other_param_rec_type,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
271: x_msg_data OUT NOCOPY VARCHAR2
272: ) IS

Line 518: hz_gnr_util_pkg.getcntrystyle(p_locid,p_loctbl,x_cntry,l_addrstyle,x_status);

514: 2. if both addrstyle and country are not null,
515: get mapId using both else use country
516: */
517: --dbms_output.put_line('***bfr getcntrystyle');
518: hz_gnr_util_pkg.getcntrystyle(p_locid,p_loctbl,x_cntry,l_addrstyle,x_status);
519:
520: IF (x_status <> fnd_api.g_ret_sts_success) THEN
521: -- there is some error in getcntrystyle(), hence exit
522: RAISE FND_API.G_EXC_ERROR;

Line 657: hz_gnr_util_pkg.getMapId(p_locid, p_loctbl, x_cntry, x_mapId, x_status );

653: p_prefix =>l_debug_prefix,
654: p_msg_level=>fnd_log.level_statement);
655: END IF;
656:
657: hz_gnr_util_pkg.getMapId(p_locid, p_loctbl, x_cntry, x_mapId, x_status );
658:
659: -- given a mapid, get the details of the map
660: IF (x_status <> fnd_api.g_ret_sts_success) THEN
661: -- Debug info.

Line 1432: --hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,G_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));

1428:
1429: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1430: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1431: END LOOP;
1432: --hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,G_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));
1433: hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,FND_API.G_RET_STS_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));
1434: END mesglog;
1435: ----------------------------------------------
1436: FUNCTION getQuery(

Line 1433: hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,FND_API.G_RET_STS_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));

1429: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1430: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1431: END LOOP;
1432: --hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,G_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));
1433: hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,FND_API.G_RET_STS_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));
1434: END mesglog;
1435: ----------------------------------------------
1436: FUNCTION getQuery(
1437: p_map_dtls_tbl IN maploc_rec_tbl_type,

Line 1642: PROCEDURE reverse_tbl(P_MAP_DTLS_TBL IN HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE,

1638: RETURN l_query;
1639: END getQueryforMultiMatch;
1640: --------------------------------------
1641: --------------------------------------
1642: PROCEDURE reverse_tbl(P_MAP_DTLS_TBL IN HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE,
1643: X_MAP_DTLS_TBL IN OUT NOCOPY HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE) IS
1644:
1645: l_map_dtls_tbl HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
1646: i number;

Line 1643: X_MAP_DTLS_TBL IN OUT NOCOPY HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE) IS

1639: END getQueryforMultiMatch;
1640: --------------------------------------
1641: --------------------------------------
1642: PROCEDURE reverse_tbl(P_MAP_DTLS_TBL IN HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE,
1643: X_MAP_DTLS_TBL IN OUT NOCOPY HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE) IS
1644:
1645: l_map_dtls_tbl HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
1646: i number;
1647: j number;

Line 1645: l_map_dtls_tbl HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;

1641: --------------------------------------
1642: PROCEDURE reverse_tbl(P_MAP_DTLS_TBL IN HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE,
1643: X_MAP_DTLS_TBL IN OUT NOCOPY HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE) IS
1644:
1645: l_map_dtls_tbl HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
1646: i number;
1647: j number;
1648: BEGIN
1649: l_map_dtls_tbl := P_MAP_DTLS_TBL;

Line 1726: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRUB:HZ_GNR_UTIL_PKG';

1722: l_missing_elements VARCHAR2(2000);
1723: l_invalid_elements VARCHAR2(2000);
1724: l_addr_warn_msg VARCHAR2(2000);
1725:
1726: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRUB:HZ_GNR_UTIL_PKG';
1727: l_module CONSTANT VARCHAR2(30) := 'ADDRESS_VALIDATION';
1728: l_debug_prefix VARCHAR2(30);
1729: BEGIN
1730:

Line 2047: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRUB:HZ_GNR_UTIL_PKG';

2043: PROCEDURE fill_values(
2044: x_map_dtls_tbl IN OUT NOCOPY maploc_rec_tbl_type
2045: ) IS
2046: i number;
2047: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRUB:HZ_GNR_UTIL_PKG';
2048: l_module CONSTANT VARCHAR2(30) := 'ADDRESS_VALIDATION';
2049: l_debug_prefix VARCHAR2(30);
2050: BEGIN
2051:

Line 2142: IF(HZ_GNR_UTIL_PKG.postal_code_to_validate(x_loc_components_rec.COUNTRY,x_loc_components_rec.POSTAL_CODE)=getValue('POSTAL_CODE',p_map_dtls_tbl)) THEN

2138: x_loc_components_rec.CITY := getValue('CITY',p_map_dtls_tbl);
2139: END IF;
2140: --Bug 8241862
2141: IF map_exists ('POSTAL_CODE',p_map_dtls_tbl) = TRUE THEN
2142: IF(HZ_GNR_UTIL_PKG.postal_code_to_validate(x_loc_components_rec.COUNTRY,x_loc_components_rec.POSTAL_CODE)=getValue('POSTAL_CODE',p_map_dtls_tbl)) THEN
2143: NULL;
2144: ELSE
2145: x_loc_components_rec.POSTAL_CODE := getValue('POSTAL_CODE',p_map_dtls_tbl);
2146: END IF;

Line 2225: l_other_param_rec HZ_GNR_UTIL_PKG.loc_other_param_rec_type;

2221: l_location_profile_rec hz_location_profile_pvt.location_profile_rec_type;
2222: l_loc_components_rec loc_components_rec_type;
2223: l_old_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
2224: l_new_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
2225: l_other_param_rec HZ_GNR_UTIL_PKG.loc_other_param_rec_type;
2226: l_wh_update_date DATE;
2227: l_address1 VARCHAR2(240);
2228: l_address2 VARCHAR2(240);
2229: l_address3 VARCHAR2(240);

Line 2555: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRUB:HZ_GNR_UTIL_PKG';

2551: p_map_dtls_tbl IN maploc_rec_tbl_type,
2552: x_status OUT NOCOPY varchar2
2553: ) IS
2554: i number;
2555: l_module_prefix CONSTANT VARCHAR2(30) := 'HZ:ARHGNRUB:HZ_GNR_UTIL_PKG';
2556: l_module CONSTANT VARCHAR2(30) := 'ADDRESS_VALIDATION';
2557: l_debug_prefix VARCHAR2(30) := p_location_id;
2558: l_retain_flag VARCHAR2(10);
2559: l_map_dtls_tbl maploc_rec_tbl_type;

Line 3687: END hz_gnr_util_pkg;

3683: errbuf := SQLERRM;
3684: END conc_gen_pkg;
3685:
3686:
3687: END hz_gnr_util_pkg;