APPS.OTA_AR_DELETE dependencies on OTA_BOOKING_DEALS

Line 15: from ota_booking_deals

11: l_exists varchar2(1);
12: --
13: cursor c_booking_deals is
14: select null
15: from ota_booking_deals
16: where customer_id = p_customer_id;
17: --
18: cursor c_delegate_bookings1 is
19: select null

Line 86: fnd_message.set_token('TABLE','OTA_BOOKING_DEALS');

82: fetch c_booking_deals into l_exists;
83: if c_booking_deals%found then
84: close c_booking_deals;
85: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
86: fnd_message.set_token('TABLE','OTA_BOOKING_DEALS');
87: fnd_message.set_token('COLUMN','CUSTOMER_ID');
88: fnd_message.raise_error;
89: end if;
90: close c_booking_deals;

Line 98: fnd_message.set_token('TABLE','OTA_BOOKING_DEALS');

94: fetch c_delegate_bookings1 into l_exists;
95: if c_delegate_bookings1%found then
96: close c_delegate_bookings1;
97: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
98: fnd_message.set_token('TABLE','OTA_BOOKING_DEALS');
99: fnd_message.set_token('COLUMN','CUSTOMER_ID');
100: fnd_message.raise_error;
101: end if;
102: close c_delegate_bookings1;