APPS.HZ_GEO_STRUCTURE_VALIDATE_PVT dependencies on HZ_UTILITY_V2PUB

Line 181: hz_utility_v2pub.validate_mandatory(

177: BEGIN
178:
179: IF p_create_update_flag='C' THEN
180: -- validate mandatory columns
181: hz_utility_v2pub.validate_mandatory(
182: p_create_update_flag => 'C',
183: p_column => 'geography_type',
184: p_column_value => p_geo_rel_type_rec.geography_type,
185: x_return_status => x_return_status

Line 189: hz_utility_v2pub.validate_mandatory(

185: x_return_status => x_return_status
186: );
187:
188:
189: hz_utility_v2pub.validate_mandatory(
190: p_create_update_flag => 'C',
191: p_column => 'parent_geography_type',
192: p_column_value => p_geo_rel_type_rec.parent_geography_type,
193: x_return_status => x_return_status

Line 196: hz_utility_v2pub.validate_created_by_module(

192: p_column_value => p_geo_rel_type_rec.parent_geography_type,
193: x_return_status => x_return_status
194: );
195:
196: hz_utility_v2pub.validate_created_by_module(
197: p_create_update_flag => 'C',
198: p_created_by_module => p_geo_rel_type_rec.created_by_module,
199: p_old_created_by_module => null,
200: x_return_status => x_return_status);

Line 303: hz_utility_v2pub.validate_mandatory(

299: BEGIN
300:
301: -- validate mandatory columns
302: IF p_create_update_flag = 'C' THEN
303: hz_utility_v2pub.validate_mandatory(
304: p_create_update_flag => 'C',
305: p_column => 'geography_id',
306: p_column_value => p_geo_structure_rec.geography_id,
307: x_return_status => x_return_status

Line 310: hz_utility_v2pub.validate_mandatory(

306: p_column_value => p_geo_structure_rec.geography_id,
307: x_return_status => x_return_status
308: );
309:
310: hz_utility_v2pub.validate_mandatory(
311: p_create_update_flag => 'C',
312: p_column => 'geography_type',
313: p_column_value => p_geo_structure_rec.geography_type,
314: x_return_status => x_return_status

Line 317: hz_utility_v2pub.validate_mandatory(

313: p_column_value => p_geo_structure_rec.geography_type,
314: x_return_status => x_return_status
315: );
316:
317: hz_utility_v2pub.validate_mandatory(
318: p_create_update_flag => 'C',
319: p_column => 'parent_geography_type',
320: p_column_value => p_geo_structure_rec.parent_geography_type,
321: x_return_status => x_return_status

Line 325: hz_utility_v2pub.validate_mandatory(

321: x_return_status => x_return_status
322: );
323:
324: /* commented per bug : 2911108
325: hz_utility_v2pub.validate_mandatory(
326: p_create_update_flag => 'C',
327: p_column => 'geography_element_column',
328: p_column_value => p_geo_structure_rec.geography_element_column,
329: x_return_status => x_return_status

Line 332: hz_utility_v2pub.validate_created_by_module(

328: p_column_value => p_geo_structure_rec.geography_element_column,
329: x_return_status => x_return_status
330: );*/
331:
332: hz_utility_v2pub.validate_created_by_module(
333: p_create_update_flag => 'C',
334: p_created_by_module => p_geo_structure_rec.created_by_module,
335: p_old_created_by_module => null,
336: x_return_status => x_return_status);

Line 458: hz_utility_v2pub.validate_mandatory(

454:
455: IF p_create_update_flag = 'U' THEN
456:
457: -- validate mandatory for relationship_type_id
458: hz_utility_v2pub.validate_mandatory(
459: p_create_update_flag => 'U',
460: p_column => 'geography_id',
461: p_column_value => p_geo_structure_rec.geography_id,
462: x_return_status => x_return_status

Line 465: hz_utility_v2pub.validate_mandatory(

461: p_column_value => p_geo_structure_rec.geography_id,
462: x_return_status => x_return_status
463: );
464:
465: hz_utility_v2pub.validate_mandatory(
466: p_create_update_flag => 'U',
467: p_column => 'geography_type',
468: p_column_value => p_geo_structure_rec.geography_type,
469: x_return_status => x_return_status

Line 471: hz_utility_v2pub.validate_mandatory(

467: p_column => 'geography_type',
468: p_column_value => p_geo_structure_rec.geography_type,
469: x_return_status => x_return_status
470: );
471: hz_utility_v2pub.validate_mandatory(
472: p_create_update_flag => 'U',
473: p_column => 'parent_geography_type',
474: p_column_value => p_geo_structure_rec.parent_geography_type,
475: x_return_status => x_return_status

Line 585: hz_utility_v2pub.validate_mandatory(

581:
582: -- validate for mandatory columns
583:
584: IF p_create_update_flag = 'C' THEN
585: hz_utility_v2pub.validate_mandatory(
586: p_create_update_flag => 'C',
587: p_column => 'geography_type',
588: p_column_value => p_zone_type_rec.geography_type,
589: x_return_status => x_return_status

Line 592: hz_utility_v2pub.validate_mandatory(

588: p_column_value => p_zone_type_rec.geography_type,
589: x_return_status => x_return_status
590: );
591:
592: hz_utility_v2pub.validate_mandatory(
593: p_create_update_flag => 'C',
594: p_column => 'geography_use',
595: p_column_value => p_zone_type_rec.geography_use,
596: x_return_status => x_return_status

Line 599: hz_utility_v2pub.validate_created_by_module(

595: p_column_value => p_zone_type_rec.geography_use,
596: x_return_status => x_return_status
597: );
598:
599: hz_utility_v2pub.validate_created_by_module(
600: p_create_update_flag => 'C',
601: p_created_by_module => p_zone_type_rec.created_by_module,
602: p_old_created_by_module => null,
603: x_return_status => x_return_status);

Line 607: HZ_UTILITY_V2PUB.validate_lookup(

603: x_return_status => x_return_status);
604: END IF;
605:
606:
607: HZ_UTILITY_V2PUB.validate_lookup(
608: p_column => 'postal_code_range_flag',
609: p_lookup_type => 'HZ_GEO_POSTAL_CODE_RANGE_FLAG',
610: p_column_value => p_zone_type_rec.postal_code_range_flag,
611: x_return_status => x_return_status

Line 628: HZ_UTILITY_V2PUB.validate_lookup(

624: END IF;
625:
626:
627: IF p_create_update_flag = 'C' THEN
628: HZ_UTILITY_V2PUB.validate_lookup(
629: p_column => 'geography_use',
630: p_lookup_type => 'HZ_RELATIONSHIP_TYPE',
631: p_column_value => p_zone_type_rec.geography_use,
632: x_return_status => x_return_status