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_GEOGRAPHY_PUB dependencies on HZ_GEOGRAPHY_VALIDATE_PVT

Line 633: HZ_GEOGRAPHY_VALIDATE_PVT.validate_master_relation(

629:
630: BEGIN
631: --dbms_output.put_line('before validate relation');
632: -- validate master relation record for create
633: HZ_GEOGRAPHY_VALIDATE_PVT.validate_master_relation(
634: p_master_relation_rec => p_master_relation_rec,
635: p_create_update_flag => 'C',
636: x_return_status => x_return_status
637: );

Line 647: /*l_geography_type := HZ_GEOGRAPHY_VALIDATE_PVT.get_geography_type(p_geography_id =>p_master_relation_rec.geography_id,

643:
644:
645: -- get geography types for geography_id and parent_geography_id
646:
647: /*l_geography_type := HZ_GEOGRAPHY_VALIDATE_PVT.get_geography_type(p_geography_id =>p_master_relation_rec.geography_id,
648: x_return_status => x_return_status);
649:
650: --dbms_output.put_line('geography_type in do_create_master_relation:'||l_geography_type);
651: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 655: l_parent_geography_type := HZ_GEOGRAPHY_VALIDATE_PVT.get_geography_type(p_geography_id => p_master_relation_rec.parent_geography_id,

651: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
652: RAISE FND_API.G_EXC_ERROR;
653: END IF;*/
654:
655: l_parent_geography_type := HZ_GEOGRAPHY_VALIDATE_PVT.get_geography_type(p_geography_id => p_master_relation_rec.parent_geography_id,
656: x_return_status => x_return_status);
657:
658: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
659: RAISE FND_API.G_EXC_ERROR;

Line 960: l_geography_type := HZ_GEOGRAPHY_VALIDATE_PVT.get_geography_type(

956: END IF;
957:
958:
959: ----dbms_output.put_line('l_end_date is '|| to_char(l_end_date));
960: l_geography_type := HZ_GEOGRAPHY_VALIDATE_PVT.get_geography_type(
961: p_geography_id => l_geography_id,
962: x_return_status => x_return_status);
963:
964: ----dbms_output.put_line('after getting geography type '||l_geography_type);

Line 1176: HZ_GEOGRAPHY_VALIDATE_PVT.validate_geo_identifier(

1172: --dbms_output.put_line ('Before validate geo identifier');
1173:
1174:
1175: -- validate geography identifier record for create
1176: HZ_GEOGRAPHY_VALIDATE_PVT.validate_geo_identifier(
1177: p_geo_identifier_rec => p_geo_identifier_rec,
1178: p_create_update_flag => 'C',
1179: x_return_status => x_return_status
1180: );

Line 1481: HZ_GEOGRAPHY_VALIDATE_PVT.validate_geo_identifier(

1477: BEGIN
1478:
1479: l_geo_identifier_subtype := p_geo_identifier_rec.identifier_subtype;
1480:
1481: HZ_GEOGRAPHY_VALIDATE_PVT.validate_geo_identifier(
1482: p_geo_identifier_rec => p_geo_identifier_rec,
1483: p_create_update_flag => 'U',
1484: x_return_status => x_return_status
1485: );

Line 1880: HZ_GEOGRAPHY_VALIDATE_PVT.validate_master_geography(

1876:
1877:
1878: -- dbms_output.put_line('In do_create_master_geography, before validate');
1879: -- validate master geography record
1880: HZ_GEOGRAPHY_VALIDATE_PVT.validate_master_geography(
1881: p_master_geography_rec => p_master_geography_rec,
1882: p_create_update_flag => 'C',
1883: x_return_status => x_return_status
1884: );

Line 2486: HZ_GEOGRAPHY_VALIDATE_PVT.validate_geography_range(

2482: END IF; */
2483:
2484:
2485: -- validate geography range
2486: HZ_GEOGRAPHY_VALIDATE_PVT.validate_geography_range(
2487: p_geography_range_rec => p_geography_range_rec,
2488: p_create_update_flag => 'C',
2489: x_return_status => x_return_status
2490: );

Line 2497: l_zone_type := hz_geography_validate_pvt.get_geography_type(p_geography_id => p_geography_range_rec.zone_id,

2493: RAISE FND_API.G_EXC_ERROR;
2494: END IF;
2495:
2496: -- get the geography_type of the zone_id
2497: l_zone_type := hz_geography_validate_pvt.get_geography_type(p_geography_id => p_geography_range_rec.zone_id,
2498: x_return_status => x_return_status);
2499:
2500: -- get geography use
2501: SELECT geography_use INTO l_geography_use

Line 2557: HZ_GEOGRAPHY_VALIDATE_PVT.validate_geography_range(

2553: l_geography_range_rec.geography_from := p_geography_from;
2554: l_geography_range_rec.start_date := p_start_date;
2555:
2556: -- validate geography range for update
2557: HZ_GEOGRAPHY_VALIDATE_PVT.validate_geography_range(
2558: p_geography_range_rec => l_geography_range_rec,
2559: p_create_update_flag => 'U',
2560: x_return_status => x_return_status
2561: );

Line 2657: l_zone_relation_rec HZ_GEOGRAPHY_VALIDATE_PVT.zone_relation_rec_type;

2653: l_count NUMBER;
2654: --l_parent_geography_type VARCHAR2(30);
2655: l_zone_type VARCHAR2(30);
2656: l_geography_use VARCHAR2(30);
2657: l_zone_relation_rec HZ_GEOGRAPHY_VALIDATE_PVT.zone_relation_rec_type;
2658: l_relationship_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
2659: l_geography_range_rec GEOGRAPHY_RANGE_REC_TYPE;
2660: l_incl_geo_type VARCHAR2(30);
2661: x_relationship_id NUMBER;

Line 2676: l_zone_type := HZ_GEOGRAPHY_VALIDATE_PVT.get_geography_type(p_geography_id =>p_geography_id,

2672:
2673: BEGIN
2674:
2675:
2676: l_zone_type := HZ_GEOGRAPHY_VALIDATE_PVT.get_geography_type(p_geography_id =>p_geography_id,
2677: x_return_status => x_return_status);
2678:
2679:
2680: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2697: hz_geography_validate_pvt.validate_zone_relation(

2693: l_zone_relation_rec.included_geography_id := p_zone_relation_tbl(i).included_geography_id;
2694: l_zone_relation_rec.start_date := p_zone_relation_tbl(i).start_date;
2695: l_zone_relation_rec.end_date := p_zone_relation_tbl(i).end_date;
2696:
2697: hz_geography_validate_pvt.validate_zone_relation(
2698: p_zone_relation_rec => l_zone_relation_rec,
2699: p_create_update_flag => 'C',
2700: x_return_status => x_return_status
2701: );

Line 2711: l_incl_geo_type := HZ_GEOGRAPHY_VALIDATE_PVT.get_geography_type(p_geography_id =>p_zone_relation_tbl(i).included_geography_id,

2707:
2708: --dbms_output.put_line('In loop after validate zone relaion '||x_return_status);
2709:
2710: --get geography_type of included_geography_id
2711: l_incl_geo_type := HZ_GEOGRAPHY_VALIDATE_PVT.get_geography_type(p_geography_id =>p_zone_relation_tbl(i).included_geography_id,
2712: x_return_status => x_return_status);
2713:
2714: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2715: RAISE FND_API.G_EXC_ERROR;