DBA Data[Home] [Help]

APPS.OTA_EVT_API_UPD2 dependencies on FND_MESSAGE

Line 55: fnd_message.set_name('OTA','OTA_13537_EVT_SAME_STATUS');

51: --
52: -- Check event status change for No change.
53: --
54: if l_event_rec.event_status = p_event_status then
55: fnd_message.set_name('OTA','OTA_13537_EVT_SAME_STATUS');
56: fnd_message.raise_error;
57: end if;
58: --
59: -- Check event status change for Full Events.

Line 56: fnd_message.raise_error;

52: -- Check event status change for No change.
53: --
54: if l_event_rec.event_status = p_event_status then
55: fnd_message.set_name('OTA','OTA_13537_EVT_SAME_STATUS');
56: fnd_message.raise_error;
57: end if;
58: --
59: -- Check event status change for Full Events.
60: --

Line 62: fnd_message.set_name('OTA','OTA_13515_EVT_STATUS_F');

58: --
59: -- Check event status change for Full Events.
60: --
61: if p_event_status = 'F' then
62: fnd_message.set_name('OTA','OTA_13515_EVT_STATUS_F');
63: fnd_message.raise_error;
64: end if;
65: --
66: -- Cannot set a full event to Normal via change status.

Line 63: fnd_message.raise_error;

59: -- Check event status change for Full Events.
60: --
61: if p_event_status = 'F' then
62: fnd_message.set_name('OTA','OTA_13515_EVT_STATUS_F');
63: fnd_message.raise_error;
64: end if;
65: --
66: -- Cannot set a full event to Normal via change status.
67: --

Line 69: fnd_message.set_name('OTA','OTA_13556_EVT_NORMAL_STATUS');

65: --
66: -- Cannot set a full event to Normal via change status.
67: --
68: if p_event_status = 'N'and l_event_rec.event_status = 'F' then
69: fnd_message.set_name('OTA','OTA_13556_EVT_NORMAL_STATUS');
70: fnd_message.raise_error;
71: end if;
72: --
73: -- Check enrollment status change for Planned Events.

Line 70: fnd_message.raise_error;

66: -- Cannot set a full event to Normal via change status.
67: --
68: if p_event_status = 'N'and l_event_rec.event_status = 'F' then
69: fnd_message.set_name('OTA','OTA_13556_EVT_NORMAL_STATUS');
70: fnd_message.raise_error;
71: end if;
72: --
73: -- Check enrollment status change for Planned Events.
74: --

Line 76: fnd_message.set_name('OTA','OTA_13516_EVT_STATUS_P');

72: --
73: -- Check enrollment status change for Planned Events.
74: --
75: if p_event_status in ('P') and l_booking_status not in ('W') then
76: fnd_message.set_name('OTA','OTA_13516_EVT_STATUS_P');
77: fnd_message.raise_error;
78: end if;
79: --
80: -- Check enrollment status change for Cancelled or Closed Events.

Line 77: fnd_message.raise_error;

73: -- Check enrollment status change for Planned Events.
74: --
75: if p_event_status in ('P') and l_booking_status not in ('W') then
76: fnd_message.set_name('OTA','OTA_13516_EVT_STATUS_P');
77: fnd_message.raise_error;
78: end if;
79: --
80: -- Check enrollment status change for Cancelled or Closed Events.
81: --

Line 83: fnd_message.set_name('OTA','OTA_13517_EVT_STATUS_AC');

79: --
80: -- Check enrollment status change for Cancelled or Closed Events.
81: --
82: if p_event_status in ('A','C') and l_booking_status not in ('C') then
83: fnd_message.set_name('OTA','OTA_13517_EVT_STATUS_AC');
84: fnd_message.raise_error;
85: end if;
86:
87: --Bug 3493695

Line 84: fnd_message.raise_error;

80: -- Check enrollment status change for Cancelled or Closed Events.
81: --
82: if p_event_status in ('A','C') and l_booking_status not in ('C') then
83: fnd_message.set_name('OTA','OTA_13517_EVT_STATUS_AC');
84: fnd_message.raise_error;
85: end if;
86:
87: --Bug 3493695
88: -- Check if there are any attended enrollments for a class being cancelled

Line 94: fnd_message.set_name('OTA','OTA_13067_EVT_ATT_ENR_EXISTS');

90: OPEN c_attended_enr;
91: FETCH c_attended_enr INTO l_att_enr_exists;
92: IF c_attended_enr%FOUND THEN
93: CLOSE c_attended_enr;
94: fnd_message.set_name('OTA','OTA_13067_EVT_ATT_ENR_EXISTS');
95: fnd_message.raise_error;
96: END IF;
97: CLOSE c_attended_enr;
98: END IF;

Line 95: fnd_message.raise_error;

91: FETCH c_attended_enr INTO l_att_enr_exists;
92: IF c_attended_enr%FOUND THEN
93: CLOSE c_attended_enr;
94: fnd_message.set_name('OTA','OTA_13067_EVT_ATT_ENR_EXISTS');
95: fnd_message.raise_error;
96: END IF;
97: CLOSE c_attended_enr;
98: END IF;
99: -- Bug 3493695

Line 157: /*fnd_message.set_name('OTA','OTA_13553_MAND_MAX_ATTENDEES');

153: --
154: if p_maximum_attendees is null then
155: --Bug 6640334/6705591:Admin should be able to nullify the maximum attendees set previously.
156: --As maximum attendees is set to null,the class status is changed to Normal,if it was Full previously.
157: /*fnd_message.set_name('OTA','OTA_13553_MAND_MAX_ATTENDEES');
158: fnd_message.raise_error;*/
159: if p_event_status = 'F' then
160: p_event_status := 'N';
161: end if;

Line 158: fnd_message.raise_error;*/

154: if p_maximum_attendees is null then
155: --Bug 6640334/6705591:Admin should be able to nullify the maximum attendees set previously.
156: --As maximum attendees is set to null,the class status is changed to Normal,if it was Full previously.
157: /*fnd_message.set_name('OTA','OTA_13553_MAND_MAX_ATTENDEES');
158: fnd_message.raise_error;*/
159: if p_event_status = 'F' then
160: p_event_status := 'N';
161: end if;
162: else

Line 243: l_status_change_comments varchar(1000) := fnd_message.get_string('OTA','OTA_13523_TDB_STATUS_COMMENTS');

239: where booking_status_type_id = p_booking_status_type_id;
240:
241:
242: --
243: l_status_change_comments varchar(1000) := fnd_message.get_string('OTA','OTA_13523_TDB_STATUS_COMMENTS');
244: l_proc varchar2(72) := g_package||'process_event_change';
245: --
246: begin
247: --