798: l_exists varchar2(1);
799: Cursor c_chk_leg_code
800: is
801: select '1'
802: from fnd_territories
803: where territory_code = p_legislation_code;
804: --
805: Begin
806: hr_utility.set_location('Entering:'||l_proc, 5);
813: --
814: Close c_chk_leg_code;
815: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
816: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
817: fnd_message.set_token('TABLE','FND_TERRITORIES');
818: fnd_message.raise_error;
819: --
820: End If;
821: Close c_chk_leg_code;