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_VALIDATE_PVT dependencies on HZ_UTILITY_V2PUB

Line 203: HZ_UTILITY_V2PUB.validate_start_end_date(

199: l_end_date:=NULL;
200:
201: IF p_create_update_flag = 'C' THEN
202: -- validate start_date and end_date
203: HZ_UTILITY_V2PUB.validate_start_end_date(
204: p_create_update_flag => p_create_update_flag,
205: p_start_date_column_name => 'start_date',
206: p_start_date => p_master_relation_rec.start_date,
207: p_old_start_date => l_start_date,

Line 364: HZ_UTILITY_V2PUB.validate_lookup(

360: -- validate identifier_subtype,identifier_type and geo_data_provider lookups
361:
362: IF p_geo_identifier_rec.identifier_type='CODE' THEN
363:
364: HZ_UTILITY_V2PUB.validate_lookup(
365: p_column => 'geography_code_type',
366: p_lookup_type => 'HZ_GEO_IDENTIFIER_SUBTYPE',
367: p_column_value => p_geo_identifier_rec.identifier_subtype,
368: x_return_status => x_return_status

Line 386: HZ_UTILITY_V2PUB.validate_lookup(

382: END IF;
383: -- this will not be called as only NAME and CODE are valid identifier type
384: -- but keeping it as 'catch all' condition to validate what is passed in
385: ELSE
386: HZ_UTILITY_V2PUB.validate_lookup(
387: p_column => 'identifier_subtype',
388: p_lookup_type => 'HZ_GEO_IDENTIFIER_SUBTYPE',
389: p_column_value => p_geo_identifier_rec.identifier_subtype,
390: x_return_status => x_return_status

Line 394: HZ_UTILITY_V2PUB.validate_lookup(

390: x_return_status => x_return_status
391: );
392: END IF;
393:
394: HZ_UTILITY_V2PUB.validate_lookup(
395: p_column => 'identifier_type',
396: p_lookup_type => 'HZ_GEO_IDENTIFIER_TYPE',
397: p_column_value => p_geo_identifier_rec.identifier_type,
398: x_return_status => x_return_status

Line 439: HZ_UTILITY_V2PUB.validate_lookup(

435: x_return_status := fnd_api.g_ret_sts_error;
436: END IF;
437: END IF; */
438:
439: HZ_UTILITY_V2PUB.validate_lookup(
440: p_column => 'geo_data_provider',
441: p_lookup_type => 'HZ_GEO_DATA_PROVIDER',
442: p_column_value => p_geo_identifier_rec.geo_data_provider,
443: x_return_status => x_return_status

Line 449: hz_utility_v2pub.validate_created_by_module(

445:
446: IF p_create_update_flag = 'C' THEN
447: -- Bug 4591502 : ISSUE # 16 : validate only in create
448:
449: hz_utility_v2pub.validate_created_by_module(
450: p_create_update_flag => 'C',
451: p_created_by_module => p_geo_identifier_rec.created_by_module,
452: p_old_created_by_module => null,
453: x_return_status => x_return_status);

Line 550: HZ_UTILITY_V2PUB.validate_start_end_date(

546: l_end_date:=NULL;
547:
548:
549: -- check whether end_date >= start_date
550: HZ_UTILITY_V2PUB.validate_start_end_date(
551: p_create_update_flag => p_create_update_flag,
552: p_start_date_column_name => 'start_date',
553: p_start_date => p_master_geography_rec.start_date,
554: p_old_start_date => l_start_date,

Line 579: HZ_UTILITY_V2PUB.validate_mandatory (

575: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
576: RAISE FND_API.G_EXC_ERROR;
577: END IF;
578: -- validate geography name for mandatory
579: HZ_UTILITY_V2PUB.validate_mandatory (
580: p_create_update_flag =>'C',
581: p_column => 'geography_name',
582: p_column_value => p_master_geography_rec.geography_name,
583: p_restricted => 'N',

Line 591: hz_utility_v2pub.validate_created_by_module(

587: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
588: RAISE FND_API.G_EXC_ERROR;
589: END IF;
590:
591: hz_utility_v2pub.validate_created_by_module(
592: p_create_update_flag => 'C',
593: p_created_by_module => p_master_geography_rec.created_by_module,
594: p_old_created_by_module => null,
595: x_return_status => x_return_status);

Line 738: HZ_UTILITY_V2PUB.validate_mandatory (

734:
735: BEGIN
736:
737: -- validate for mandatory columns
738: HZ_UTILITY_V2PUB.validate_mandatory (
739: p_create_update_flag =>p_create_update_flag,
740: p_column => 'zone_id',
741: p_column_value => p_geography_range_rec.zone_id,
742: p_restricted => 'N',

Line 747: HZ_UTILITY_V2PUB.validate_mandatory (

743: x_return_status => x_return_status
744: );
745:
746:
747: HZ_UTILITY_V2PUB.validate_mandatory (
748: p_create_update_flag =>p_create_update_flag,
749: p_column => 'geography_from',
750: p_column_value => p_geography_range_rec.geography_from,
751: p_restricted => 'N',

Line 756: HZ_UTILITY_V2PUB.validate_mandatory (

752: x_return_status => x_return_status
753: );
754:
755: IF p_create_update_flag = 'C' THEN
756: HZ_UTILITY_V2PUB.validate_mandatory (
757: p_create_update_flag =>p_create_update_flag,
758: p_column => 'master_ref_geography_id',
759: p_column_value => p_geography_range_rec.master_ref_geography_id,
760: p_restricted => 'N',

Line 764: HZ_UTILITY_V2PUB.validate_mandatory (

760: p_restricted => 'N',
761: x_return_status => x_return_status
762: );
763:
764: HZ_UTILITY_V2PUB.validate_mandatory (
765: p_create_update_flag =>p_create_update_flag,
766: p_column => 'geography_to',
767: p_column_value => p_geography_range_rec.geography_to,
768: p_restricted => 'N',

Line 772: HZ_UTILITY_V2PUB.validate_mandatory (

768: p_restricted => 'N',
769: x_return_status => x_return_status
770: );
771:
772: HZ_UTILITY_V2PUB.validate_mandatory (
773: p_create_update_flag =>p_create_update_flag,
774: p_column => 'identifier_type',
775: p_column_value => p_geography_range_rec.identifier_type,
776: p_restricted => 'N',

Line 780: hz_utility_v2pub.validate_created_by_module(

776: p_restricted => 'N',
777: x_return_status => x_return_status
778: );
779:
780: hz_utility_v2pub.validate_created_by_module(
781: p_create_update_flag => 'C',
782: p_created_by_module => p_geography_range_rec.created_by_module,
783: p_old_created_by_module => null,
784: x_return_status => x_return_status);

Line 790: HZ_UTILITY_V2PUB.validate_mandatory (

786: END IF;
787:
788: IF p_create_update_flag = 'U' THEN
789:
790: HZ_UTILITY_V2PUB.validate_mandatory (
791: p_create_update_flag =>'U',
792: p_column => 'start_date',
793: p_column_value => p_geography_range_rec.start_date,
794: p_restricted => 'N',

Line 798: HZ_UTILITY_V2PUB.validate_mandatory (

794: p_restricted => 'N',
795: x_return_status => x_return_status
796: );
797:
798: HZ_UTILITY_V2PUB.validate_mandatory (
799: p_create_update_flag =>'U',
800: p_column => 'end_date',
801: p_column_value => p_geography_range_rec.end_date,
802: p_restricted => 'N',

Line 811: HZ_UTILITY_V2PUB.validate_start_end_date(

807:
808:
809: IF p_create_update_flag = 'C' THEN
810: -- validate for start_date and end_date
811: HZ_UTILITY_V2PUB.validate_start_end_date(
812: p_create_update_flag => p_create_update_flag,
813: p_start_date_column_name => 'start_date',
814: p_start_date => p_geography_range_rec.start_date,
815: p_old_start_date => NULL,

Line 923: HZ_UTILITY_V2PUB.validate_start_end_date(

919: BEGIN
920:
921:
922: -- validate start_date and end_date
923: HZ_UTILITY_V2PUB.validate_start_end_date(
924: p_create_update_flag => p_create_update_flag,
925: p_start_date_column_name => 'start_date',
926: p_start_date => p_zone_relation_rec.start_date,
927: p_old_start_date => NULL,