APPS.OTA_TRB_SHD dependencies on OTA_RESOURCE_BOOKINGS

Line 97: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK1') Then

93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','15');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK1') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','20');
101: fnd_message.raise_error;

Line 102: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK2') Then

98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','20');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_FK2') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','25');
106: fnd_message.raise_error;

Line 107: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_PK') Then

103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','25');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'OTA_RESOURCE_BOOKINGS_PK') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','30');
111: fnd_message.raise_error;

Line 228: from ota_resource_bookings

224: -- ,unbook_request_flag
225: ,chat_id
226: ,forum_id
227: ,timezone_code
228: from ota_resource_bookings
229: where resource_booking_id = p_resource_booking_id;
230: --
231: l_proc varchar2(72) := g_package||'api_updating';
232: l_fct_ret boolean;

Line 344: from ota_resource_bookings

340: -- ,unbook_request_flag
341: ,chat_id
342: ,forum_id
343: ,timezone_code
344: from ota_resource_bookings
345: where resource_booking_id = p_resource_booking_id
346: for update nowait;
347: --
348: l_proc varchar2(72) := g_package||'lck';

Line 387: hr_utility.set_message_token('TABLE_NAME', 'ota_resource_bookings');

383: -- The object is locked therefore we need to supply a meaningful
384: -- error message.
385: --
386: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
387: hr_utility.set_message_token('TABLE_NAME', 'ota_resource_bookings');
388: hr_utility.raise_error;
389: End lck;
390: --
391: -- ----------------------------------------------------------------------------