81: open c_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;
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;
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;
91: --
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;
91: --
92: hr_utility.set_location('Entering:'||l_proc, 20);
93: open c_delegate_bookings1;
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;
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;
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;
103: --
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;
103: --
104: hr_utility.set_location('Entering:'||l_proc, 25);
105: open c_delegate_bookings2;
106: fetch c_delegate_bookings2 into l_exists;
107: if c_delegate_bookings2%found then
108: close c_delegate_bookings2;
109: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
110: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
111: fnd_message.set_token('COLUMN','THIRD_PARTY_CUSTOMER_ID');
112: fnd_message.raise_error;
113: end if;
106: fetch c_delegate_bookings2 into l_exists;
107: if c_delegate_bookings2%found then
108: close c_delegate_bookings2;
109: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
110: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
111: fnd_message.set_token('COLUMN','THIRD_PARTY_CUSTOMER_ID');
112: fnd_message.raise_error;
113: end if;
114: close c_delegate_bookings2;
107: if c_delegate_bookings2%found then
108: close c_delegate_bookings2;
109: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
110: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
111: fnd_message.set_token('COLUMN','THIRD_PARTY_CUSTOMER_ID');
112: fnd_message.raise_error;
113: end if;
114: close c_delegate_bookings2;
115: --
108: close c_delegate_bookings2;
109: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
110: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
111: fnd_message.set_token('COLUMN','THIRD_PARTY_CUSTOMER_ID');
112: fnd_message.raise_error;
113: end if;
114: close c_delegate_bookings2;
115: --
116: hr_utility.set_location('Entering:'||l_proc, 30);
117: open c_event_associations;
118: fetch c_event_associations into l_exists;
119: if c_event_associations%found then
120: close c_event_associations;
121: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
122: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');
123: fnd_message.set_token('COLUMN','CUSTOMER_ID');
124: fnd_message.raise_error;
125: end if;
118: fetch c_event_associations into l_exists;
119: if c_event_associations%found then
120: close c_event_associations;
121: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
122: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');
123: fnd_message.set_token('COLUMN','CUSTOMER_ID');
124: fnd_message.raise_error;
125: end if;
126: close c_event_associations;
119: if c_event_associations%found then
120: close c_event_associations;
121: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
122: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');
123: fnd_message.set_token('COLUMN','CUSTOMER_ID');
124: fnd_message.raise_error;
125: end if;
126: close c_event_associations;
127: --
120: close c_event_associations;
121: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
122: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');
123: fnd_message.set_token('COLUMN','CUSTOMER_ID');
124: fnd_message.raise_error;
125: end if;
126: close c_event_associations;
127: --
128: hr_utility.set_location('Entering:'||l_proc, 35);
129: open c_finance_headers1;
130: fetch c_finance_headers1 into l_exists;
131: if c_finance_headers1%found then
132: close c_finance_headers1;
133: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
134: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
135: fnd_message.set_token('COLUMN','CUSTOMER_ID');
136: fnd_message.raise_error;
137: end if;
130: fetch c_finance_headers1 into l_exists;
131: if c_finance_headers1%found then
132: close c_finance_headers1;
133: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
134: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
135: fnd_message.set_token('COLUMN','CUSTOMER_ID');
136: fnd_message.raise_error;
137: end if;
138: close c_finance_headers1;
131: if c_finance_headers1%found then
132: close c_finance_headers1;
133: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
134: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
135: fnd_message.set_token('COLUMN','CUSTOMER_ID');
136: fnd_message.raise_error;
137: end if;
138: close c_finance_headers1;
139: --
132: close c_finance_headers1;
133: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
134: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
135: fnd_message.set_token('COLUMN','CUSTOMER_ID');
136: fnd_message.raise_error;
137: end if;
138: close c_finance_headers1;
139: --
140: elsif p_contact_id is not null then
143: open c_delegate_bookings3;
144: fetch c_delegate_bookings3 into l_exists;
145: if c_delegate_bookings3%found then
146: close c_delegate_bookings3;
147: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
148: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
149: fnd_message.set_token('COLUMN','CONTACT_ID');
150: fnd_message.raise_error;
151: end if;
144: fetch c_delegate_bookings3 into l_exists;
145: if c_delegate_bookings3%found then
146: close c_delegate_bookings3;
147: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
148: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
149: fnd_message.set_token('COLUMN','CONTACT_ID');
150: fnd_message.raise_error;
151: end if;
152: close c_delegate_bookings3;
145: if c_delegate_bookings3%found then
146: close c_delegate_bookings3;
147: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
148: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
149: fnd_message.set_token('COLUMN','CONTACT_ID');
150: fnd_message.raise_error;
151: end if;
152: close c_delegate_bookings3;
153: --
146: close c_delegate_bookings3;
147: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
148: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
149: fnd_message.set_token('COLUMN','CONTACT_ID');
150: fnd_message.raise_error;
151: end if;
152: close c_delegate_bookings3;
153: --
154: hr_utility.set_location('Entering:'||l_proc, 45);
155: open c_delegate_bookings4;
156: fetch c_delegate_bookings4 into l_exists;
157: if c_delegate_bookings4%found then
158: close c_delegate_bookings4;
159: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
160: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
161: fnd_message.set_token('COLUMN','THIRD_PARTY_CONTACT_ID');
162: fnd_message.raise_error;
163: end if;
156: fetch c_delegate_bookings4 into l_exists;
157: if c_delegate_bookings4%found then
158: close c_delegate_bookings4;
159: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
160: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
161: fnd_message.set_token('COLUMN','THIRD_PARTY_CONTACT_ID');
162: fnd_message.raise_error;
163: end if;
164: close c_delegate_bookings4;
157: if c_delegate_bookings4%found then
158: close c_delegate_bookings4;
159: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
160: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
161: fnd_message.set_token('COLUMN','THIRD_PARTY_CONTACT_ID');
162: fnd_message.raise_error;
163: end if;
164: close c_delegate_bookings4;
165: --
158: close c_delegate_bookings4;
159: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
160: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
161: fnd_message.set_token('COLUMN','THIRD_PARTY_CONTACT_ID');
162: fnd_message.raise_error;
163: end if;
164: close c_delegate_bookings4;
165: --
166: hr_utility.set_location('Entering:'||l_proc, 50);
167: open c_delegate_bookings5;
168: fetch c_delegate_bookings5 into l_exists;
169: if c_delegate_bookings5%found then
170: close c_delegate_bookings5;
171: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
172: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
173: fnd_message.set_token('COLUMN','DELEGATE_CONTACT_ID');
174: fnd_message.raise_error;
175: end if;
168: fetch c_delegate_bookings5 into l_exists;
169: if c_delegate_bookings5%found then
170: close c_delegate_bookings5;
171: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
172: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
173: fnd_message.set_token('COLUMN','DELEGATE_CONTACT_ID');
174: fnd_message.raise_error;
175: end if;
176: close c_delegate_bookings5;
169: if c_delegate_bookings5%found then
170: close c_delegate_bookings5;
171: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
172: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
173: fnd_message.set_token('COLUMN','DELEGATE_CONTACT_ID');
174: fnd_message.raise_error;
175: end if;
176: close c_delegate_bookings5;
177: --
170: close c_delegate_bookings5;
171: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
172: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
173: fnd_message.set_token('COLUMN','DELEGATE_CONTACT_ID');
174: fnd_message.raise_error;
175: end if;
176: close c_delegate_bookings5;
177: --
178: hr_utility.set_location('Entering:'||l_proc, 55);
179: open c_finance_headers2;
180: fetch c_finance_headers2 into l_exists;
181: if c_finance_headers2%found then
182: close c_finance_headers2;
183: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
184: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
185: fnd_message.set_token('COLUMN','CONTACT_ID');
186: fnd_message.raise_error;
187: end if;
180: fetch c_finance_headers2 into l_exists;
181: if c_finance_headers2%found then
182: close c_finance_headers2;
183: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
184: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
185: fnd_message.set_token('COLUMN','CONTACT_ID');
186: fnd_message.raise_error;
187: end if;
188: close c_finance_headers2;
181: if c_finance_headers2%found then
182: close c_finance_headers2;
183: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
184: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
185: fnd_message.set_token('COLUMN','CONTACT_ID');
186: fnd_message.raise_error;
187: end if;
188: close c_finance_headers2;
189: --
182: close c_finance_headers2;
183: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
184: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
185: fnd_message.set_token('COLUMN','CONTACT_ID');
186: fnd_message.raise_error;
187: end if;
188: close c_finance_headers2;
189: --
190: elsif p_address_id is not null then
193: open c_delegate_bookings6;
194: fetch c_delegate_bookings6 into l_exists;
195: if c_delegate_bookings6%found then
196: close c_delegate_bookings6;
197: fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');
198: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
199: fnd_message.set_token('COLUMN','CONTACT_ADDRESS_ID');
200: fnd_message.raise_error;
201: end if;
194: fetch c_delegate_bookings6 into l_exists;
195: if c_delegate_bookings6%found then
196: close c_delegate_bookings6;
197: fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');
198: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
199: fnd_message.set_token('COLUMN','CONTACT_ADDRESS_ID');
200: fnd_message.raise_error;
201: end if;
202: close c_delegate_bookings6;
195: if c_delegate_bookings6%found then
196: close c_delegate_bookings6;
197: fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');
198: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
199: fnd_message.set_token('COLUMN','CONTACT_ADDRESS_ID');
200: fnd_message.raise_error;
201: end if;
202: close c_delegate_bookings6;
203: --
196: close c_delegate_bookings6;
197: fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');
198: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
199: fnd_message.set_token('COLUMN','CONTACT_ADDRESS_ID');
200: fnd_message.raise_error;
201: end if;
202: close c_delegate_bookings6;
203: --
204: hr_utility.set_location('Entering:'||l_proc, 65);
205: open c_delegate_bookings7;
206: fetch c_delegate_bookings7 into l_exists;
207: if c_delegate_bookings7%found then
208: close c_delegate_bookings7;
209: fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');
210: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
211: fnd_message.set_token('COLUMN','THIRD_PARTY_ADDRESS_ID');
212: fnd_message.raise_error;
213: end if;
206: fetch c_delegate_bookings7 into l_exists;
207: if c_delegate_bookings7%found then
208: close c_delegate_bookings7;
209: fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');
210: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
211: fnd_message.set_token('COLUMN','THIRD_PARTY_ADDRESS_ID');
212: fnd_message.raise_error;
213: end if;
214: close c_delegate_bookings7;
207: if c_delegate_bookings7%found then
208: close c_delegate_bookings7;
209: fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');
210: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
211: fnd_message.set_token('COLUMN','THIRD_PARTY_ADDRESS_ID');
212: fnd_message.raise_error;
213: end if;
214: close c_delegate_bookings7;
215: --
208: close c_delegate_bookings7;
209: fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');
210: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
211: fnd_message.set_token('COLUMN','THIRD_PARTY_ADDRESS_ID');
212: fnd_message.raise_error;
213: end if;
214: close c_delegate_bookings7;
215: --
216: hr_utility.set_location('Entering:'||l_proc, 70);
217: open c_finance_headers3;
218: fetch c_finance_headers3 into l_exists;
219: if c_finance_headers3%found then
220: close c_finance_headers3;
221: fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');
222: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
223: fnd_message.set_token('COLUMN','ADDRESS_ID');
224: fnd_message.raise_error;
225: end if;
218: fetch c_finance_headers3 into l_exists;
219: if c_finance_headers3%found then
220: close c_finance_headers3;
221: fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');
222: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
223: fnd_message.set_token('COLUMN','ADDRESS_ID');
224: fnd_message.raise_error;
225: end if;
226: close c_finance_headers3;
219: if c_finance_headers3%found then
220: close c_finance_headers3;
221: fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');
222: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
223: fnd_message.set_token('COLUMN','ADDRESS_ID');
224: fnd_message.raise_error;
225: end if;
226: close c_finance_headers3;
227: --
220: close c_finance_headers3;
221: fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');
222: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
223: fnd_message.set_token('COLUMN','ADDRESS_ID');
224: fnd_message.raise_error;
225: end if;
226: close c_finance_headers3;
227: --
228: end if;