DBA Data[Home] [Help]

APPS.OTA_TDB_API_INS2 dependencies on FND_MESSAGE

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

36: --
37: if (ota_evt_bus2.get_vacancies(p_event_id) < p_number_of_places) and
38: l_booking_status in ('P','A','E') then
39: --
40: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
41: fnd_message.raise_error;
42: --
43: end if;
44: --

Line 41: fnd_message.raise_error;

37: if (ota_evt_bus2.get_vacancies(p_event_id) < p_number_of_places) and
38: l_booking_status in ('P','A','E') then
39: --
40: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
41: fnd_message.raise_error;
42: --
43: end if;
44: --
45: end if;

Line 53: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');

49: --
50:
51: if p_event_status = 'F' and l_booking_status in ('P','A','E','C') then
52: --
53: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');
54: fnd_message.raise_error;
55: --
56: end if;
57:

Line 54: fnd_message.raise_error;

50:
51: if p_event_status = 'F' and l_booking_status in ('P','A','E','C') then
52: --
53: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');
54: fnd_message.raise_error;
55: --
56: end if;
57:
58: --

Line 64: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');

60: --
61:
62: if p_event_status = 'P' and l_booking_status not in ('W','R') then
63: --
64: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');
65: fnd_message.raise_error;
66: --
67: end if;
68:

Line 65: fnd_message.raise_error;

61:
62: if p_event_status = 'P' and l_booking_status not in ('W','R') then
63: --
64: fnd_message.set_name('OTA','OTA_13518_TDB_NEW_STATUS_P');
65: fnd_message.raise_error;
66: --
67: end if;
68:
69: --

Line 74: fnd_message.set_name('OTA','OTA_13519_TDB_NEW_STATUS_A');

70: -- Check new status for Cancelled or Closed Events.
71: --
72: if p_event_status in ('A','C') and l_booking_status is not null then
73: --
74: fnd_message.set_name('OTA','OTA_13519_TDB_NEW_STATUS_A');
75: fnd_message.raise_error;
76: --
77: end if;
78:

Line 75: fnd_message.raise_error;

71: --
72: if p_event_status in ('A','C') and l_booking_status is not null then
73: --
74: fnd_message.set_name('OTA','OTA_13519_TDB_NEW_STATUS_A');
75: fnd_message.raise_error;
76: --
77: end if;
78:
79: --

Line 84: fnd_message.set_name('OTA','OTA_13520_TDB_NEW_STATUS_N');

80: -- Check new status for Normal Events.
81: --
82: if p_event_status = 'N' and l_booking_status in ('C') then
83: --
84: fnd_message.set_name('OTA','OTA_13520_TDB_NEW_STATUS_N');
85: fnd_message.raise_error;
86: --
87: end if;
88:

Line 85: fnd_message.raise_error;

81: --
82: if p_event_status = 'N' and l_booking_status in ('C') then
83: --
84: fnd_message.set_name('OTA','OTA_13520_TDB_NEW_STATUS_N');
85: fnd_message.raise_error;
86: --
87: end if;
88:
89: --