1145:
1146: --Bug:7269277 Jurisdiction code length check
1147: elsif length(lv_jurisdiction_code) > 11 then
1148: --Jurisdiction code cannot have size more than 11
1149: pay_cty_shd.constraint_error
1150: (p_constraint_name => 'PAY_US_EMP_CITY_TAX_RULES_FK3');
1151:
1152: end if;
1153: -- Check if Jurisdiction is specified
1156: --jurisdiction_code length = 11. Checking only for the format xx-xxx-xxxx
1157: if instr(lv_jurisdiction_code,'-', 1,1) <> 3
1158: or instr(lv_jurisdiction_code,'-', 1,2) <> 7 then
1159:
1160: pay_cty_shd.constraint_error
1161: (p_constraint_name => 'PAY_US_EMP_CITY_TAX_RULES_FK3');
1162: end if;
1163:
1164: /*Changes for Bug#9270887 */