APPS.HZ_GEOGRAPHY_PUB dependencies on HZ_UTILITY_V2PUB

Line 924: hz_utility_v2pub.validate_mandatory(

920: l_get_all_children c_get_all_children%ROWTYPE;
921: l_remove_denorm_flag VARCHAR2(1);
922: BEGIN
923:
924: hz_utility_v2pub.validate_mandatory(
925: p_create_update_flag => 'U',
926: p_column => 'object_version_number',
927: p_column_value => p_object_version_number,
928: x_return_status => x_return_status

Line 1491: hz_utility_v2pub.validate_mandatory(

1487: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1488: RAISE FND_API.G_EXC_ERROR;
1489: END IF;
1490:
1491: hz_utility_v2pub.validate_mandatory(
1492: p_create_update_flag => 'U',
1493: p_column => 'object_version_number',
1494: p_column_value => p_object_version_number,
1495: x_return_status => x_return_status

Line 1538: HZ_UTILITY_V2PUB.validate_lookup(

1534: IF (p_geo_identifier_rec.identifier_type = 'CODE') THEN
1535: l_new_geo_subtype := p_geo_identifier_rec.new_identifier_subtype;
1536: -- validate new subtype
1537: IF (l_new_geo_subtype IS NOT NULL) THEN
1538: HZ_UTILITY_V2PUB.validate_lookup(
1539: p_column => 'geography_code_type',
1540: p_lookup_type => 'HZ_GEO_IDENTIFIER_SUBTYPE',
1541: p_column_value => l_new_geo_subtype,
1542: x_return_status => x_return_status

Line 2097: hz_utility_v2pub.validate_mandatory(

2093: l_object_version_number NUMBER;
2094:
2095: BEGIN
2096:
2097: hz_utility_v2pub.validate_mandatory(
2098: p_create_update_flag => 'U',
2099: p_column => 'object_version_number',
2100: p_column_value => p_object_version_number,
2101: x_return_status => x_return_status

Line 2137: HZ_UTILITY_V2PUB.validate_start_end_date(

2133: END;
2134: --dbms_output.put_line('start date and old end date and end date '||to_char(l_start_date,'dd-mon-yyyy')||'*'||to_char(l_end_date,'dd-mon-yyyy')||'*'||to_char(p_end_date,'dd-mon-yyyy')||'*');
2135: --dbms_output.put_line('After date validation '|| x_return_status);
2136: -- check whether end_date >= start_date
2137: HZ_UTILITY_V2PUB.validate_start_end_date(
2138: p_create_update_flag => 'U',
2139: p_start_date_column_name => 'start_date',
2140: p_start_date => l_start_date,
2141: p_old_start_date => l_start_date,

Line 2567: hz_utility_v2pub.validate_mandatory(

2563: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2564: RAISE FND_API.G_EXC_ERROR;
2565: END IF;
2566:
2567: hz_utility_v2pub.validate_mandatory(
2568: p_create_update_flag => 'U',
2569: p_column => 'object_version_number',
2570: p_column_value => p_object_version_number,
2571: x_return_status => x_return_status

Line 2608: HZ_UTILITY_V2PUB.validate_start_end_date(

2604:
2605: END;
2606: -- check if start_date <= end_date
2607:
2608: HZ_UTILITY_V2PUB.validate_start_end_date(
2609: p_create_update_flag => 'U',
2610: p_start_date_column_name => 'start_date',
2611: p_start_date => p_start_date,
2612: p_old_start_date => l_start_date,

Line 2930: HZ_UTILITY_V2PUB.validate_mandatory (

2926: BEGIN
2927:
2928: l_end_date := to_date('31-12-4712','DD-MM-YYYY');
2929: -- validate for mandatory columns
2930: HZ_UTILITY_V2PUB.validate_mandatory (
2931: p_create_update_flag =>'C',
2932: p_column => 'zone_type',
2933: p_column_value => p_zone_type,
2934: p_restricted => 'N',

Line 2942: HZ_UTILITY_V2PUB.validate_mandatory (

2938: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2939: RAISE FND_API.G_EXC_ERROR;
2940: END IF;
2941:
2942: HZ_UTILITY_V2PUB.validate_mandatory (
2943: p_create_update_flag =>'C',
2944: p_column => 'zone_name',
2945: p_column_value => p_zone_name,
2946: p_restricted => 'N',

Line 3502: HZ_UTILITY_V2PUB.find_index_name(p_index_name);

3498:
3499: WHEN DUP_VAL_ON_INDEX THEN
3500: ROLLBACK TO create_geo_identifier;
3501: x_return_status := FND_API.G_RET_STS_ERROR;
3502: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
3503: IF p_index_name = 'HZ_GEOGRAPHY_IDENTIFIERS_U1' THEN
3504: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
3505: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,identifier_type,identifier_subtype,identifier_value,language_code');
3506: FND_MSG_PUB.ADD;

Line 4036: HZ_UTILITY_V2PUB.find_index_name(p_index_name);

4032:
4033: WHEN DUP_VAL_ON_INDEX THEN
4034: ROLLBACK TO create_geography_range;
4035: x_return_status := FND_API.G_RET_STS_ERROR;
4036: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
4037: IF p_index_name = 'HZ_GEOGRAPHY_RANGES_U1' THEN
4038: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
4039: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,geography_from and start_date');
4040: FND_MSG_PUB.ADD;