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 965: l_geography_type := HZ_GEOGRAPHY_VALIDATE_PVT.get_geography_type(

961: END IF;
962:
963:
964: ----dbms_output.put_line('l_end_date is '|| to_char(l_end_date));
965: l_geography_type := HZ_GEOGRAPHY_VALIDATE_PVT.get_geography_type(
966: p_geography_id => l_geography_id,
967: x_return_status => x_return_status);
968:
969: ----dbms_output.put_line('after getting geography type '||l_geography_type);

Line 1181: HZ_GEOGRAPHY_VALIDATE_PVT.validate_geo_identifier(

1177: --dbms_output.put_line ('Before validate geo identifier');
1178:
1179:
1180: -- validate geography identifier record for create
1181: HZ_GEOGRAPHY_VALIDATE_PVT.validate_geo_identifier(
1182: p_geo_identifier_rec => p_geo_identifier_rec,
1183: p_create_update_flag => 'C',
1184: x_return_status => x_return_status
1185: );

Line 1490: HZ_GEOGRAPHY_VALIDATE_PVT.validate_geo_identifier(

1486: BEGIN
1487:
1488: l_geo_identifier_subtype := p_geo_identifier_rec.identifier_subtype;
1489:
1490: HZ_GEOGRAPHY_VALIDATE_PVT.validate_geo_identifier(
1491: p_geo_identifier_rec => p_geo_identifier_rec,
1492: p_create_update_flag => 'U',
1493: x_return_status => x_return_status
1494: );

Line 1893: HZ_GEOGRAPHY_VALIDATE_PVT.validate_master_geography(

1889:
1890:
1891: -- dbms_output.put_line('In do_create_master_geography, before validate');
1892: -- validate master geography record
1893: HZ_GEOGRAPHY_VALIDATE_PVT.validate_master_geography(
1894: p_master_geography_rec => p_master_geography_rec,
1895: p_create_update_flag => 'C',
1896: x_return_status => x_return_status
1897: );

Line 2499: HZ_GEOGRAPHY_VALIDATE_PVT.validate_geography_range(

2495: END IF; */
2496:
2497:
2498: -- validate geography range
2499: HZ_GEOGRAPHY_VALIDATE_PVT.validate_geography_range(
2500: p_geography_range_rec => p_geography_range_rec,
2501: p_create_update_flag => 'C',
2502: x_return_status => x_return_status
2503: );

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

2506: RAISE FND_API.G_EXC_ERROR;
2507: END IF;
2508:
2509: -- get the geography_type of the zone_id
2510: l_zone_type := hz_geography_validate_pvt.get_geography_type(p_geography_id => p_geography_range_rec.zone_id,
2511: x_return_status => x_return_status);
2512:
2513: -- get geography use
2514: SELECT geography_use INTO l_geography_use

Line 2570: HZ_GEOGRAPHY_VALIDATE_PVT.validate_geography_range(

2566: l_geography_range_rec.geography_from := p_geography_from;
2567: l_geography_range_rec.start_date := p_start_date;
2568:
2569: -- validate geography range for update
2570: HZ_GEOGRAPHY_VALIDATE_PVT.validate_geography_range(
2571: p_geography_range_rec => l_geography_range_rec,
2572: p_create_update_flag => 'U',
2573: x_return_status => x_return_status
2574: );

Line 2670: l_zone_relation_rec HZ_GEOGRAPHY_VALIDATE_PVT.zone_relation_rec_type;

2666: l_count NUMBER;
2667: --l_parent_geography_type VARCHAR2(30);
2668: l_zone_type VARCHAR2(30);
2669: l_geography_use VARCHAR2(30);
2670: l_zone_relation_rec HZ_GEOGRAPHY_VALIDATE_PVT.zone_relation_rec_type;
2671: l_relationship_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
2672: l_geography_range_rec GEOGRAPHY_RANGE_REC_TYPE;
2673: l_incl_geo_type VARCHAR2(30);
2674: x_relationship_id NUMBER;

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

2685:
2686: BEGIN
2687:
2688:
2689: l_zone_type := HZ_GEOGRAPHY_VALIDATE_PVT.get_geography_type(p_geography_id =>p_geography_id,
2690: x_return_status => x_return_status);
2691:
2692:
2693: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2710: hz_geography_validate_pvt.validate_zone_relation(

2706: l_zone_relation_rec.included_geography_id := p_zone_relation_tbl(i).included_geography_id;
2707: l_zone_relation_rec.start_date := p_zone_relation_tbl(i).start_date;
2708: l_zone_relation_rec.end_date := p_zone_relation_tbl(i).end_date;
2709:
2710: hz_geography_validate_pvt.validate_zone_relation(
2711: p_zone_relation_rec => l_zone_relation_rec,
2712: p_create_update_flag => 'C',
2713: x_return_status => x_return_status
2714: );

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

2720:
2721: --dbms_output.put_line('In loop after validate zone relaion '||x_return_status);
2722:
2723: --get geography_type of included_geography_id
2724: l_incl_geo_type := HZ_GEOGRAPHY_VALIDATE_PVT.get_geography_type(p_geography_id =>p_zone_relation_tbl(i).included_geography_id,
2725: x_return_status => x_return_status);
2726:
2727: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2728: RAISE FND_API.G_EXC_ERROR;