APPS.HZ_GEOGRAPHY_PUB dependencies on HZ_UTILITY_V2PUB

Line 929: hz_utility_v2pub.validate_mandatory(

925: l_get_all_children c_get_all_children%ROWTYPE;
926: l_remove_denorm_flag VARCHAR2(1);
927: BEGIN
928:
929: hz_utility_v2pub.validate_mandatory(
930: p_create_update_flag => 'U',
931: p_column => 'object_version_number',
932: p_column_value => p_object_version_number,
933: x_return_status => x_return_status

Line 1500: hz_utility_v2pub.validate_mandatory(

1496: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1497: RAISE FND_API.G_EXC_ERROR;
1498: END IF;
1499:
1500: hz_utility_v2pub.validate_mandatory(
1501: p_create_update_flag => 'U',
1502: p_column => 'object_version_number',
1503: p_column_value => p_object_version_number,
1504: x_return_status => x_return_status

Line 1547: HZ_UTILITY_V2PUB.validate_lookup(

1543: IF (p_geo_identifier_rec.identifier_type = 'CODE') THEN
1544: l_new_geo_subtype := p_geo_identifier_rec.new_identifier_subtype;
1545: -- validate new subtype
1546: IF (l_new_geo_subtype IS NOT NULL) THEN
1547: HZ_UTILITY_V2PUB.validate_lookup(
1548: p_column => 'geography_code_type',
1549: p_lookup_type => 'HZ_GEO_IDENTIFIER_SUBTYPE',
1550: p_column_value => l_new_geo_subtype,
1551: x_return_status => x_return_status

Line 2110: hz_utility_v2pub.validate_mandatory(

2106: l_object_version_number NUMBER;
2107:
2108: BEGIN
2109:
2110: hz_utility_v2pub.validate_mandatory(
2111: p_create_update_flag => 'U',
2112: p_column => 'object_version_number',
2113: p_column_value => p_object_version_number,
2114: x_return_status => x_return_status

Line 2150: HZ_UTILITY_V2PUB.validate_start_end_date(

2146: END;
2147: --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')||'*');
2148: --dbms_output.put_line('After date validation '|| x_return_status);
2149: -- check whether end_date >= start_date
2150: HZ_UTILITY_V2PUB.validate_start_end_date(
2151: p_create_update_flag => 'U',
2152: p_start_date_column_name => 'start_date',
2153: p_start_date => l_start_date,
2154: p_old_start_date => l_start_date,

Line 2580: hz_utility_v2pub.validate_mandatory(

2576: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2577: RAISE FND_API.G_EXC_ERROR;
2578: END IF;
2579:
2580: hz_utility_v2pub.validate_mandatory(
2581: p_create_update_flag => 'U',
2582: p_column => 'object_version_number',
2583: p_column_value => p_object_version_number,
2584: x_return_status => x_return_status

Line 2621: HZ_UTILITY_V2PUB.validate_start_end_date(

2617:
2618: END;
2619: -- check if start_date <= end_date
2620:
2621: HZ_UTILITY_V2PUB.validate_start_end_date(
2622: p_create_update_flag => 'U',
2623: p_start_date_column_name => 'start_date',
2624: p_start_date => p_start_date,
2625: p_old_start_date => l_start_date,

Line 2943: HZ_UTILITY_V2PUB.validate_mandatory (

2939: BEGIN
2940:
2941: l_end_date := to_date('31-12-4712','DD-MM-YYYY');
2942: -- validate for mandatory columns
2943: HZ_UTILITY_V2PUB.validate_mandatory (
2944: p_create_update_flag =>'C',
2945: p_column => 'zone_type',
2946: p_column_value => p_zone_type,
2947: p_restricted => 'N',

Line 2955: HZ_UTILITY_V2PUB.validate_mandatory (

2951: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2952: RAISE FND_API.G_EXC_ERROR;
2953: END IF;
2954:
2955: HZ_UTILITY_V2PUB.validate_mandatory (
2956: p_create_update_flag =>'C',
2957: p_column => 'zone_name',
2958: p_column_value => p_zone_name,
2959: p_restricted => 'N',

Line 3515: HZ_UTILITY_V2PUB.find_index_name(p_index_name);

3511:
3512: WHEN DUP_VAL_ON_INDEX THEN
3513: ROLLBACK TO create_geo_identifier;
3514: x_return_status := FND_API.G_RET_STS_ERROR;
3515: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
3516: IF p_index_name = 'HZ_GEOGRAPHY_IDENTIFIERS_U1' THEN
3517: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
3518: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,identifier_type,identifier_subtype,identifier_value,language_code');
3519: FND_MSG_PUB.ADD;

Line 4049: HZ_UTILITY_V2PUB.find_index_name(p_index_name);

4045:
4046: WHEN DUP_VAL_ON_INDEX THEN
4047: ROLLBACK TO create_geography_range;
4048: x_return_status := FND_API.G_RET_STS_ERROR;
4049: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
4050: IF p_index_name = 'HZ_GEOGRAPHY_RANGES_U1' THEN
4051: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
4052: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,geography_from and start_date');
4053: FND_MSG_PUB.ADD;