APPS.HZ_ADDRESS_USAGES_PUB dependencies on HZ_GNR_GEN_PKG

Line 260: hz_gnr_gen_pkg.genpkg(p_address_usages_rec.map_id,l_pkgname,l_status);

256:
257: IF p_address_usages_rec.status_flag = 'A' THEN
258: --dbms_output.put_line('Before Gen pkg Create usage : map id :'|| p_address_usages_rec.map_id);
259: BEGIN
260: hz_gnr_gen_pkg.genpkg(p_address_usages_rec.map_id,l_pkgname,l_status);
261: IF l_status = FND_API.G_RET_STS_ERROR THEN
262: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_PKG_ERR');
263: FND_MSG_PUB.ADD;
264: RAISE FND_API.G_EXC_ERROR;

Line 463: hz_gnr_gen_pkg.genpkg(db_map_id,l_pkgname,l_status);

459: -- If count is 0, that means there is no active usage details for this map_id
460: IF l_count > 0 THEN
461: --dbms_output.put_line('Before Gen pkg Create usage : map id :'|| p_address_usages_rec.map_id);
462: BEGIN
463: hz_gnr_gen_pkg.genpkg(db_map_id,l_pkgname,l_status);
464: IF l_status = FND_API.G_RET_STS_ERROR THEN
465: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_PKG_ERR');
466: FND_MSG_PUB.ADD;
467: RAISE FND_API.G_EXC_ERROR;

Line 647: hz_gnr_gen_pkg.genpkg(l_map_id,l_pkgname,l_status);

643:
644: IF l_status_flag = 'A' THEN
645: --dbms_output.put_line('Before Gen pkg Create usage dtls : map id :'|| l_map_id);
646: BEGIN
647: hz_gnr_gen_pkg.genpkg(l_map_id,l_pkgname,l_status);
648: IF l_status = FND_API.G_RET_STS_ERROR THEN
649: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_PKG_ERR');
650: FND_MSG_PUB.ADD;
651: RAISE FND_API.G_EXC_ERROR;

Line 882: hz_gnr_gen_pkg.genpkg(l_map_id,l_pkgname,l_status);

878: -- Checking whether the usage is active or not.
879: IF l_status_flag = 'A' THEN
880: --dbms_output.put_line('Before Gen pkg Delete usage : map id :'|| l_map_id);
881: BEGIN
882: hz_gnr_gen_pkg.genpkg(l_map_id,l_pkgname,l_status);
883: IF l_status = FND_API.G_RET_STS_ERROR THEN
884: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_PKG_ERR');
885: FND_MSG_PUB.ADD;
886: RAISE FND_API.G_EXC_ERROR;