APPS.HZ_GEO_STRUCTURE_VALIDATE_PVT dependencies on HZ_GEOGRAPHIES

Line 118: FROM HZ_GEOGRAPHIES

114:
115: BEGIN
116: SELECT count(*)
117: INTO l_count
118: FROM HZ_GEOGRAPHIES
119: WHERE GEOGRAPHY_ID = p_geography_id
120: AND GEOGRAPHY_USE = decode(p_master_ref_flag,'Y','MASTER_REF',GEOGRAPHY_USE);
121:
122: IF l_count = 0 THEN

Line 353: FROM HZ_GEOGRAPHIES

349:
350: -- validate whether geography_type of the above geography_id is 'COUNTRY'
351: SELECT geography_type
352: INTO l_geography_type
353: FROM HZ_GEOGRAPHIES
354: WHERE geography_id = p_geo_structure_rec.geography_id;
355:
356: IF l_geography_type <> 'COUNTRY' THEN
357: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_INVALID_TYPE' );

Line 442: -- validate geography_element_column to be one of geography_element1..10 columns of hz_geographies

438: END IF;
439: END IF;
440: END IF;
441:
442: -- validate geography_element_column to be one of geography_element1..10 columns of hz_geographies
443: -- commented as per the bug fix: 2911108
444: /* IF UPPER(p_geo_structure_rec.geography_element_column) NOT IN (
445: 'GEOGRAPHY_ELEMENT2','GEOGRAPHY_ELEMENT3','GEOGRAPHY_ELEMENT4','GEOGRAPHY_ELEMENT5',
446: 'GEOGRAPHY_ELEMENT6','GEOGRAPHY_ELEMENT7','GEOGRAPHY_ELEMENT8','GEOGRAPHY_ELEMENT9','GEOGRAPHY_ELEMENT10')

Line 651: FROM hz_geographies

647: END IF;
648:
649: IF (p_zone_type_rec.limited_by_geography_id IS NOT NULL AND p_zone_type_rec.limited_by_geography_id <> fnd_api.g_miss_num) THEN
650: SELECT count(*) INTO l_count
651: FROM hz_geographies
652: WHERE geography_id = p_zone_type_rec.limited_by_geography_id;
653:
654: IF l_count = 0 THEN
655: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 658: fnd_message.set_token('TABLE','hz_geographies');

654: IF l_count = 0 THEN
655: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
656: fnd_message.set_token('FK', 'limited_by_geography_id');
657: fnd_message.set_token('COLUMN','limited_by_geography_id');
658: fnd_message.set_token('TABLE','hz_geographies');
659: fnd_msg_pub.add;
660: x_return_status := fnd_api.g_ret_sts_error;
661: END IF;
662: END IF;