APPS.HZ_GEOGRAPHY_VALIDATE_PVT dependencies on HZ_GEOGRAPHIES

Line 62: FROM hz_geographies

58: BEGIN
59:
60: -- check whether the country structure is defined
61: SELECT geography_id INTO l_geography_id
62: FROM hz_geographies
63: WHERE country_code = p_country_code
64: AND geography_type = 'COUNTRY';
65:
66: BEGIN

Line 141: FROM HZ_GEOGRAPHIES

137: BEGIN
138:
139: SELECT geography_type
140: INTO l_geography_type
141: FROM HZ_GEOGRAPHIES
142: WHERE geography_id = p_geography_id;
143:
144: RETURN l_geography_type;
145:

Line 151: fnd_message.set_token('TABLE','HZ_GEOGRAPHIES');

147: WHEN NO_DATA_FOUND THEN
148: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
149: fnd_message.set_token('FK','geography_id');
150: fnd_message.set_token('COLUMN', 'geography_id');
151: fnd_message.set_token('TABLE','HZ_GEOGRAPHIES');
152: fnd_msg_pub.add;
153: x_return_status := fnd_api.g_ret_sts_error;
154: END get_geography_type;
155:

Line 259: FROM HZ_GEOGRAPHIES

255: --dbms_output.put_line('In validate relation after get geography type');
256: -- get country code for geography_id
257:
258: SELECT country_code INTO l_country_code
259: FROM HZ_GEOGRAPHIES
260: WHERE geography_id=p_master_relation_rec.parent_geography_id;
261: IF l_country_code IS NULL THEN
262: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');
263: fnd_message.set_token('TOKEN1', 'country_code');

Line 646: FROM hz_geographies

642:
643: --validate for duplicate country
644: IF p_master_geography_rec.geography_type = 'COUNTRY' THEN
645: SELECT count(*) INTO l_count
646: FROM hz_geographies
647: WHERE geography_code=p_master_geography_rec.geography_code
648: AND geography_type='COUNTRY';
649:
650: IF l_count > 0 THEN

Line 846: FROM hz_geographies

842:
843: -- validate zone_id
844: BEGIN
845: SELECT 1 INTO l_count
846: FROM hz_geographies
847: WHERE geography_id = p_geography_range_rec.zone_id
848: AND geography_use <> 'MASTER_REF';
849:
850:

Line 855: fnd_message.set_token('TABLE','HZ_GEOGRAPHIES');

851: EXCEPTION WHEN NO_DATA_FOUND THEN
852: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
853: fnd_message.set_token('FK','geography_id');
854: fnd_message.set_token('COLUMN', 'zone_id');
855: fnd_message.set_token('TABLE','HZ_GEOGRAPHIES');
856: fnd_msg_pub.add;
857: x_return_status := fnd_api.g_ret_sts_error;
858: END;
859:

Line 866: FROM hz_geographies

862: IF p_create_update_flag = 'C' THEN
863: BEGIN
864:
865: SELECT 1 INTO l_count
866: FROM hz_geographies
867: WHERE geography_id = p_geography_range_rec.master_ref_geography_id
868: AND geography_use = 'MASTER_REF';
869:
870:

Line 875: fnd_message.set_token('TABLE','HZ_GEOGRAPHIES');

871: EXCEPTION WHEN NO_DATA_FOUND THEN
872: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
873: fnd_message.set_token('FK','geography_id');
874: fnd_message.set_token('COLUMN', 'master_ref_geography_id');
875: fnd_message.set_token('TABLE','HZ_GEOGRAPHIES');
876: fnd_msg_pub.add;
877: x_return_status := fnd_api.g_ret_sts_error;
878: END;
879: END IF;

Line 937: FROM hz_geographies

933:
934:
935: -- validate geography_id
936: SELECT count(*) INTO l_count
937: FROM hz_geographies
938: WHERE geography_id = p_zone_relation_rec.geography_id;
939:
940: IF l_count = 0 THEN
941: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 944: fnd_message.set_token('TABLE','HZ_GEOGRAPHIES');

940: IF l_count = 0 THEN
941: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
942: fnd_message.set_token('FK', 'geography_id');
943: fnd_message.set_token('COLUMN','geography_id');
944: fnd_message.set_token('TABLE','HZ_GEOGRAPHIES');
945: fnd_msg_pub.add;
946: x_return_status := fnd_api.g_ret_sts_error;
947: END IF;
948:

Line 951: FROM hz_geographies

947: END IF;
948:
949: --validate included_geography_id
950: SELECT count(*) INTO l_count
951: FROM hz_geographies
952: WHERE geography_id = p_zone_relation_rec.included_geography_id;
953:
954: IF l_count = 0 THEN
955: fnd_message.set_name('AR', 'HZ_GEO_INVALID_VALUE');