DBA Data[Home] [Help]

APPS.OTA_AR_DELETE dependencies on FND_MESSAGE

Line 85: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');

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;

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 87: fnd_message.set_token('COLUMN','CUSTOMER_ID');

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: --

Line 88: fnd_message.raise_error;

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);

Line 97: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');

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;

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;

Line 99: fnd_message.set_token('COLUMN','CUSTOMER_ID');

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: --

Line 100: fnd_message.raise_error;

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);

Line 109: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');

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;

Line 110: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');

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;

Line 111: fnd_message.set_token('COLUMN','THIRD_PARTY_CUSTOMER_ID');

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: --

Line 112: fnd_message.raise_error;

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);

Line 121: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');

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;

Line 122: fnd_message.set_token('TABLE','OTA_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;
126: close c_event_associations;

Line 123: fnd_message.set_token('COLUMN','CUSTOMER_ID');

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: --

Line 124: fnd_message.raise_error;

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);

Line 133: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');

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;

Line 134: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');

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;

Line 135: fnd_message.set_token('COLUMN','CUSTOMER_ID');

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: --

Line 136: fnd_message.raise_error;

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

Line 147: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');

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;

Line 148: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');

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;

Line 149: fnd_message.set_token('COLUMN','CONTACT_ID');

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: --

Line 150: fnd_message.raise_error;

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);

Line 159: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');

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;

Line 160: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');

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;

Line 161: fnd_message.set_token('COLUMN','THIRD_PARTY_CONTACT_ID');

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: --

Line 162: fnd_message.raise_error;

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);

Line 171: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');

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;

Line 172: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');

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;

Line 173: fnd_message.set_token('COLUMN','DELEGATE_CONTACT_ID');

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: --

Line 174: fnd_message.raise_error;

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);

Line 183: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');

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;

Line 184: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');

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;

Line 185: fnd_message.set_token('COLUMN','CONTACT_ID');

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: --

Line 186: fnd_message.raise_error;

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

Line 197: fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');

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;

Line 198: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');

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;

Line 199: fnd_message.set_token('COLUMN','CONTACT_ADDRESS_ID');

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: --

Line 200: fnd_message.raise_error;

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);

Line 209: fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');

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;

Line 210: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');

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;

Line 211: fnd_message.set_token('COLUMN','THIRD_PARTY_ADDRESS_ID');

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: --

Line 212: fnd_message.raise_error;

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);

Line 221: fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');

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;

Line 222: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');

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;

Line 223: fnd_message.set_token('COLUMN','ADDRESS_ID');

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: --

Line 224: fnd_message.raise_error;

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;