APPS.HZ_GEOGRAPHY_VALIDATE_PVT dependencies on HZ_GEO_STRUCTURE_VALIDATE_PVT

Line 224: HZ_GEO_STRUCTURE_VALIDATE_PVT.validate_geography_id(

220: --dbms_output.put_line('In validate relatio after date validate');
221:
222: -- validate geography_id and parent_geography_id
223: IF p_create_update_flag = 'C' THEN
224: HZ_GEO_STRUCTURE_VALIDATE_PVT.validate_geography_id(
225: p_geography_id => p_master_relation_rec.geography_id,
226: p_master_ref_flag => 'Y',
227: x_return_status => x_return_status
228: );

Line 234: HZ_GEO_STRUCTURE_VALIDATE_PVT.validate_geography_id(

230: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
231: RAISE FND_API.G_EXC_ERROR;
232: END IF;
233:
234: HZ_GEO_STRUCTURE_VALIDATE_PVT.validate_geography_id(
235: p_geography_id => p_master_relation_rec.parent_geography_id,
236: p_master_ref_flag => 'Y',
237: x_return_status => x_return_status
238: );

Line 354: HZ_GEO_STRUCTURE_VALIDATE_PVT.validate_geography_id(

350:
351: BEGIN
352:
353: IF p_create_update_flag = 'C' THEN
354: HZ_GEO_STRUCTURE_VALIDATE_PVT.validate_geography_id(
355: p_geography_id => p_geo_identifier_rec.geography_id,
356: p_master_ref_flag => 'N',
357: x_return_status => x_return_status
358: );

Line 569: HZ_GEO_STRUCTURE_VALIDATE_PVT.validate_geography_type(

565:
566:
567: IF p_create_update_flag = 'C' THEN
568: -- validate geography_type
569: HZ_GEO_STRUCTURE_VALIDATE_PVT.validate_geography_type(
570: p_geography_type => p_master_geography_rec.geography_type,
571: p_master_ref_flag => 'Y',
572: x_return_status => x_return_status
573: );

Line 664: hz_geo_structure_validate_pvt.validate_geography_id (

660: l_last := l_parent_geography_tbl.last;
661: IF l_last > 0 THEN
662: FOR i in 1 .. l_last loop
663: IF l_parent_geography_tbl.exists(i)= TRUE THEN
664: hz_geo_structure_validate_pvt.validate_geography_id (
665: p_geography_id => l_parent_geography_tbl(i),
666: p_master_ref_flag => 'Y',
667: x_return_status => x_return_status);
668: END IF;