DBA Data[Home] [Help]

APPS.OTA_TDB_API_UPD2 dependencies on FND_MESSAGE

Line 65: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');

61: ( p_event_status = 'F' or
62: ota_evt_bus2.get_vacancies(p_event_id) <
63: p_number_of_places ) then
64:
65: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
66: fnd_message.raise_error;
67: --
68: end if;
69: --

Line 66: fnd_message.raise_error;

62: ota_evt_bus2.get_vacancies(p_event_id) <
63: p_number_of_places ) then
64:
65: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
66: fnd_message.raise_error;
67: --
68: end if;
69: --
70: -- Check for exceeding max attendees.

Line 80: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');

76: (l_booking_status in ('A','P','E') and
77: l_old_booking_status not in ('A','P','E') and
78: ota_evt_bus2.get_vacancies(p_event_id) < p_number_of_places) then
79: --
80: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
81: fnd_message.raise_error;
82: --
83: end if;
84: --

Line 81: fnd_message.raise_error;

77: l_old_booking_status not in ('A','P','E') and
78: ota_evt_bus2.get_vacancies(p_event_id) < p_number_of_places) then
79: --
80: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
81: fnd_message.raise_error;
82: --
83: end if;
84: --
85: -- Check booking status, if amended.

Line 104: fnd_message.set_name('OTA','OTA_13521_TDB_CH_STATUS_FP');

100: l_booking_status in ('P','A','E') and
101: ota_evt_bus2.get_vacancies(p_event_id) >= p_number_of_places then
102: null;
103: else
104: fnd_message.set_name('OTA','OTA_13521_TDB_CH_STATUS_FP');
105: fnd_message.raise_error;
106: end if;
107: --
108: end if;

Line 105: fnd_message.raise_error;

101: ota_evt_bus2.get_vacancies(p_event_id) >= p_number_of_places then
102: null;
103: else
104: fnd_message.set_name('OTA','OTA_13521_TDB_CH_STATUS_FP');
105: fnd_message.raise_error;
106: end if;
107: --
108: end if;
109: --

Line 119: fnd_message.set_name('OTA','OTA_13522_TDB_CH_STATUS_C');

115: if p_event_status in ('A') then
116: --
117: if l_booking_status <> 'C' then
118: --
119: fnd_message.set_name('OTA','OTA_13522_TDB_CH_STATUS_C');
120: fnd_message.raise_error;
121: --
122: end if;
123: --

Line 120: fnd_message.raise_error;

116: --
117: if l_booking_status <> 'C' then
118: --
119: fnd_message.set_name('OTA','OTA_13522_TDB_CH_STATUS_C');
120: fnd_message.raise_error;
121: --
122: end if;
123: --
124: end if;

Line 529: l_evt_status_chg_comments varchar2(1000) := fnd_message.get_string('OTA','OTA_13523_TDB_STATUS_COMMENTS');

525:
526: l_enr_details_rec csr_get_enr_details%ROWTYPE;
527:
528: l_old_booking_status varchar2(30);
529: l_evt_status_chg_comments varchar2(1000) := fnd_message.get_string('OTA','OTA_13523_TDB_STATUS_COMMENTS');
530: */
531: --
532: begin
533:

Line 1373: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');

1369: commit;
1370: --
1371: else
1372: --
1373: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
1374: fnd_message.raise_error;
1375: --
1376: end if;
1377: --

Line 1374: fnd_message.raise_error;

1370: --
1371: else
1372: --
1373: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
1374: fnd_message.raise_error;
1375: --
1376: end if;
1377: --
1378: if g_debug then