DBA Data[Home] [Help]

APPS.PAY_US_ELEMENT_ENTRY_HOOK dependencies on PAY_CTY_SHD

Line 1149: pay_cty_shd.constraint_error

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

Line 1160: pay_cty_shd.constraint_error

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 */