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_REGISTRY_VALIDATE_V2PUB dependencies on FND_TERRITORIES

Line 415: ELSIF p_category = 'FND_TERRITORIES' THEN

411: END;
412: ELSE
413: l_return := FALSE;
414: END IF;
415: ELSIF p_category = 'FND_TERRITORIES' THEN
416:
417: l_position1 := INSTRB( p_val, G_SPECIAL_STRING, 1, 1 );
418: l_territory_code := SUBSTRB( p_val, 1, l_position1 - 1 );
419:

Line 422: FROM FND_TERRITORIES

418: l_territory_code := SUBSTRB( p_val, 1, l_position1 - 1 );
419:
420: BEGIN
421: SELECT null INTO l_dummy
422: FROM FND_TERRITORIES
423: WHERE TERRITORY_CODE = l_territory_code
424: AND OBSOLETE_FLAG = 'N';
425:
426: l_return := TRUE;

Line 1036: IF NOT search(p_column_value || G_SPECIAL_STRING, 'FND_TERRITORIES')

1032:
1033: IF p_column_value IS NOT NULL AND
1034: p_column_value <> FND_API.G_MISS_CHAR
1035: THEN
1036: IF NOT search(p_column_value || G_SPECIAL_STRING, 'FND_TERRITORIES')
1037: THEN
1038: fnd_message.set_name('AR', 'HZ_API_INVALID_COUNTRY_CODE');
1039: fnd_msg_pub.add;
1040: x_return_status := fnd_api.g_ret_sts_error;

Line 5739: -- home_country has foreign key fnd_territories.territory_code

5735: ---------------------------------------
5736: -- validation for home_country
5737: ---------------------------------------
5738:
5739: -- home_country has foreign key fnd_territories.territory_code
5740: validate_country_code(
5741: p_column => 'home_country',
5742: p_column_value => p_organization_rec.home_country,
5743: x_return_status => x_return_status);

Line 5748: p_message => 'home_country should be in fnd_territories.territory_code. ' ||

5744:
5745: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5746: hz_utility_v2pub.debug(
5747: p_prefix => l_debug_prefix,
5748: p_message => 'home_country should be in fnd_territories.territory_code. ' ||
5749: 'x_return_status = ' || x_return_status,
5750: p_msg_level => fnd_log.level_statement);
5751: END IF;
5752:

Line 8649: -- country has foreign key fnd_territories.territory_code

8645:
8646:
8647: END IF;
8648:
8649: -- country has foreign key fnd_territories.territory_code
8650: validate_country_code(
8651: p_column => 'country_code',
8652: p_column_value => p_citizenship_rec.country_code,
8653: x_return_status => x_return_status);

Line 8658: p_message => 'country_code should be in fnd_territories.territory_code. ' ||

8654:
8655: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8656: hz_utility_v2pub.debug(
8657: p_prefix => l_debug_prefix,
8658: p_message => 'country_code should be in fnd_territories.territory_code. ' ||
8659: 'x_return_status = ' || x_return_status,
8660: p_msg_level => fnd_log.level_statement);
8661: END IF;
8662:

Line 11173: -- country has foreign key fnd_territories.territory_code

11169: p_column => 'country',
11170: p_column_value => p_location_rec.country,
11171: x_return_status => x_return_status);
11172:
11173: -- country has foreign key fnd_territories.territory_code
11174: validate_country_code(
11175: p_column => 'country',
11176: p_column_value => p_location_rec.country,
11177: x_return_status => x_return_status);

Line 11182: p_message => 'country has foreign key fnd_territories.territory_code. ' ||

11178:
11179: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
11180: hz_utility_v2pub.debug(
11181: p_prefix => l_debug_prefix,
11182: p_message => 'country has foreign key fnd_territories.territory_code. ' ||
11183: 'x_return_status = ' || x_return_status,
11184: p_msg_level => fnd_log.level_statement);
11185: END IF;
11186: