APPS.PER_KAD_BUS dependencies on FND_TERRITORIES

Line 181: -- Validates that a country code exists in table fnd_territories

177: -- |---------------------------< chk_country >------------------------------|
178: -- ---------------------------------------------------------------------------
179: --
180: -- Description:
181: -- Validates that a country code exists in table fnd_territories
182: -- for US, GB and GENERIC address styles.
183: --
184: -- Pre-conditions:
185: -- Style (p_style) must be valid.

Line 193: -- If a row does exist in fnd_territories for the given country code then

189: -- p_address_id
190: -- p_object_version_number
191: --
192: -- Post Success:
193: -- If a row does exist in fnd_territories for the given country code then
194: -- processing continues.
195: --
196: -- Post Failure:
197: -- If a row does not exist in fnd_territories for the given country code then

Line 197: -- If a row does not exist in fnd_territories for the given country code then

193: -- If a row does exist in fnd_territories for the given country code then
194: -- processing continues.
195: --
196: -- Post Failure:
197: -- If a row does not exist in fnd_territories for the given country code then
198: -- an application error will be raised and processing is terminated.
199: --
200: -- Access Status:
201: -- Internal Table Handler Use Only.

Line 218: from fnd_territories ft

214: l_api_updating boolean;
215: --
216: cursor csr_valid_ctry is
217: select null
218: from fnd_territories ft
219: where ft.territory_code = p_country;
220: --
221: begin
222: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 239: -- country on fnd_territories

235: (NOT l_api_updating)) then
236: hr_utility.set_location(l_proc, 2);
237: --
238: -- Checks that value for country is a valid
239: -- country on fnd_territories
240: --
241: if p_style = 'US' or
242: p_style = 'GB' then
243: /* (p_style = 'JP' and p_country is not null) then */