110: hr_utility.set_location('Entering:'||l_proc, 5);
111: --
112: if p_maximum_attendees is not null and p_maximum_internal_attendees is not null then
113: if p_maximum_internal_attendees > p_maximum_attendees then
114: fnd_message.set_name('OTA','OTA_13512_EVT_MAX_ATT');
115: fnd_message.raise_error;
116: end if;
117: end if;
118: --
111: --
112: if p_maximum_attendees is not null and p_maximum_internal_attendees is not null then
113: if p_maximum_internal_attendees > p_maximum_attendees then
114: fnd_message.set_name('OTA','OTA_13512_EVT_MAX_ATT');
115: fnd_message.raise_error;
116: end if;
117: end if;
118: --
119: if p_maximum_attendees is not null then
117: end if;
118: --
119: if p_maximum_attendees is not null then
120: if l_total_places > p_maximum_attendees then
121: fnd_message.set_name('OTA','OTA_13513_EVT_MAX_INT_ATT');
122: fnd_message.raise_error;
123: end if;
124: end if;
125: --
118: --
119: if p_maximum_attendees is not null then
120: if l_total_places > p_maximum_attendees then
121: fnd_message.set_name('OTA','OTA_13513_EVT_MAX_INT_ATT');
122: fnd_message.raise_error;
123: end if;
124: end if;
125: --
126: if p_maximum_internal_attendees is not null then
124: end if;
125: --
126: if p_maximum_internal_attendees is not null then
127: if l_total_internal_places > p_maximum_internal_attendees then
128: fnd_message.set_name('OTA','OTA_13514_EVT_MAX_NORM_ATT');
129: fnd_message.raise_error;
130: end if;
131: end if;
132: --
125: --
126: if p_maximum_internal_attendees is not null then
127: if l_total_internal_places > p_maximum_internal_attendees then
128: fnd_message.set_name('OTA','OTA_13514_EVT_MAX_NORM_ATT');
129: fnd_message.raise_error;
130: end if;
131: end if;
132: --
133: hr_utility.set_location('Leaving:'||l_proc, 10);
473: --
474: if p_maximum_attendees is not null or p_maximum_internal_attendees is not null then
475: if ((l_mandatory_association_exists and p_maximum_attendees >= 0) or
476: (l_mandatory_association_exists and p_maximum_internal_attendees >= 0)) then
477: fnd_message.set_name('OTA','OTA_467070_MANDATORY_ENR_ERR');
478: fnd_message.raise_error;
479: end if;
480:
481: end if;
474: if p_maximum_attendees is not null or p_maximum_internal_attendees is not null then
475: if ((l_mandatory_association_exists and p_maximum_attendees >= 0) or
476: (l_mandatory_association_exists and p_maximum_internal_attendees >= 0)) then
477: fnd_message.set_name('OTA','OTA_467070_MANDATORY_ENR_ERR');
478: fnd_message.raise_error;
479: end if;
480:
481: end if;
482: --