79: -- exceed limit on places
80: --
81: if l_max_places < (l_places_used + p_places) then
82: --
83: fnd_message.set_name('OTA','OTA_13606_BOOKING_DEAL_PLACES');
84: fnd_message.raise_error;
85: --
86: end if;
87: --
80: --
81: if l_max_places < (l_places_used + p_places) then
82: --
83: fnd_message.set_name('OTA','OTA_13606_BOOKING_DEAL_PLACES');
84: fnd_message.raise_error;
85: --
86: end if;
87: --
88: hr_utility.set_location('Leaving '||l_proc,10);
139: return;
140: end if;
141: --
142: if p_booking_contact_id is null then
143: fnd_message.set_name('OTA','OTA_13554_TEA_CONTACT_NULL');
144: fnd_message.raise_error;
145: end if;
146: --
147: if p_number_of_places is null then
140: end if;
141: --
142: if p_booking_contact_id is null then
143: fnd_message.set_name('OTA','OTA_13554_TEA_CONTACT_NULL');
144: fnd_message.raise_error;
145: end if;
146: --
147: if p_number_of_places is null then
148: fnd_message.set_name('OTA','OTA_13555_TEA_PLACES_NULL');
144: fnd_message.raise_error;
145: end if;
146: --
147: if p_number_of_places is null then
148: fnd_message.set_name('OTA','OTA_13555_TEA_PLACES_NULL');
149: fnd_message.raise_error;
150: end if;
151: --
152: -- Check if booking needs a place
145: end if;
146: --
147: if p_number_of_places is null then
148: fnd_message.set_name('OTA','OTA_13555_TEA_PLACES_NULL');
149: fnd_message.raise_error;
150: end if;
151: --
152: -- Check if booking needs a place
153: --