APPS.PER_ADD_BUS dependencies on FND_TERRITORIES

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

561: -- |---------------------------< chk_country >------------------------------|
562: -- ---------------------------------------------------------------------------
563: --
564: -- Description:
565: -- Validates that a country code exists in table fnd_territories
566: -- for US, GB and GENERIC address styles.
567: --
568: -- Pre-conditions:
569: -- Style (p_style) must be valid.

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

573: -- p_address_id
574: -- p_object_version_number
575: --
576: -- Post Success:
577: -- If a row does exist in fnd_territories for the given country code then
578: -- processing continues.
579: --
580: -- Post Failure:
581: -- If a row does not exist in fnd_territories for the given country code then

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

577: -- If a row does exist in fnd_territories for the given country code then
578: -- processing continues.
579: --
580: -- Post Failure:
581: -- If a row does not exist in fnd_territories for the given country code then
582: -- an application error will be raised and processing is terminated.
583: --
584: -- Access Status:
585: -- Internal Table Handler Use Only.

Line 602: from fnd_territories ft

598: l_api_updating boolean;
599: --
600: cursor csr_valid_ctry is
601: select null
602: from fnd_territories ft
603: where ft.territory_code = p_country;
604: --
605: begin
606: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 623: -- country on fnd_territories

619: (NOT l_api_updating)) then
620: hr_utility.set_location(l_proc, 2);
621: --
622: -- Checks that value for country is a valid
623: -- country on fnd_territories
624: --
625: if p_style = 'US' or
626: p_style = 'GB' then
627: -- Bug 1677965