146: fnd_msg_pub.initialize;
147: open c_entry_exists;
148: fetch c_entry_exists into l_null;
149: if c_entry_exists%found then
150: hr_utility.set_message(801,'HR_7455_PLK_ELE_ENTRY_EXISTS');
151: hr_utility.raise_error;
152: end if;
153: close c_entry_exists;
154:
147: open c_entry_exists;
148: fetch c_entry_exists into l_null;
149: if c_entry_exists%found then
150: hr_utility.set_message(801,'HR_7455_PLK_ELE_ENTRY_EXISTS');
151: hr_utility.raise_error;
152: end if;
153: close c_entry_exists;
154:
155: INSERT INTO BEN_ICD_TRANSACTION
553: fnd_msg_pub.initialize;
554: open c_entry_exists;
555: fetch c_entry_exists into l_null;
556: if c_entry_exists%found then
557: hr_utility.set_message(801,'HR_7455_PLK_ELE_ENTRY_EXISTS');
558: hr_utility.raise_error;
559: end if;
560: close c_entry_exists;
561:
554: open c_entry_exists;
555: fetch c_entry_exists into l_null;
556: if c_entry_exists%found then
557: hr_utility.set_message(801,'HR_7455_PLK_ELE_ENTRY_EXISTS');
558: hr_utility.raise_error;
559: end if;
560: close c_entry_exists;
561:
562: update
722: fnd_msg_pub.initialize;
723: open c_entry_exists;
724: fetch c_entry_exists into l_null;
725: if c_entry_exists%found then
726: hr_utility.set_message(801,'HR_7455_PLK_ELE_ENTRY_EXISTS');
727: FND_MSG_PUB.ADD;
728: end if;
729: close c_entry_exists;
730: