32: open get_duplicate;
33: fetch get_duplicate into l_duplicate;
34: if get_duplicate%found then
35: close get_duplicate;
36: fnd_message.set_name('OTA','OTA_13428_PMM_DUPLICATE');
37: fnd_message.raise_error;
38: end if;
39: close get_duplicate;
40: end CHECK_DUPLICATE_MEMBER;
33: fetch get_duplicate into l_duplicate;
34: if get_duplicate%found then
35: close get_duplicate;
36: fnd_message.set_name('OTA','OTA_13428_PMM_DUPLICATE');
37: fnd_message.raise_error;
38: end if;
39: close get_duplicate;
40: end CHECK_DUPLICATE_MEMBER;
41: --
81: close c1;
82: --
83: if l_error then
84: --
85: fnd_message.set_name('OTA','OTA_13607_PMM_EVENT_PLANNED');
86: fnd_message.raise_error;
87: --
88: end if;
89: --
82: --
83: if l_error then
84: --
85: fnd_message.set_name('OTA','OTA_13607_PMM_EVENT_PLANNED');
86: fnd_message.raise_error;
87: --
88: end if;
89: --
90: hr_utility.set_location('Leaving :'||l_proc,10);