eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_ADAPTER_PUB dependencies on FND_API

Line 28: x_return_status := FND_API.G_RET_STS_SUCCESS;

24:
25: l_adapter_rec := p_adapter_rec;
26:
27: --Initialize API return status to success.
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29:
30: validate_adapter(
31: p_create_update_flag => 'C'
32: ,p_adapter_rec => l_adapter_rec

Line 35: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

31: p_create_update_flag => 'C'
32: ,p_adapter_rec => l_adapter_rec
33: ,x_return_status => x_return_status );
34:
35: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
36: RAISE FND_API.G_EXC_ERROR;
37: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
39: END IF;

Line 36: RAISE FND_API.G_EXC_ERROR;

32: ,p_adapter_rec => l_adapter_rec
33: ,x_return_status => x_return_status );
34:
35: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
36: RAISE FND_API.G_EXC_ERROR;
37: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
39: END IF;
40:

Line 37: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

33: ,x_return_status => x_return_status );
34:
35: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
36: RAISE FND_API.G_EXC_ERROR;
37: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
39: END IF;
40:
41: HZ_ADAPTERS_PKG.Insert_Row (

Line 38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

34:
35: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
36: RAISE FND_API.G_EXC_ERROR;
37: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
39: END IF;
40:
41: HZ_ADAPTERS_PKG.Insert_Row (
42: x_adapter_id => l_adapter_rec.adapter_id

Line 96: WHEN FND_API.G_EXC_ERROR THEN

92: x_last_update_login => hz_utility_v2pub.last_update_login );
93:
94: EXCEPTION
95:
96: WHEN FND_API.G_EXC_ERROR THEN
97: ROLLBACK TO create_adapter_pub;
98: x_return_status := FND_API.G_RET_STS_ERROR;
99: FND_MSG_PUB.Count_And_Get(
100: p_encoded => FND_API.G_FALSE,

Line 98: x_return_status := FND_API.G_RET_STS_ERROR;

94: EXCEPTION
95:
96: WHEN FND_API.G_EXC_ERROR THEN
97: ROLLBACK TO create_adapter_pub;
98: x_return_status := FND_API.G_RET_STS_ERROR;
99: FND_MSG_PUB.Count_And_Get(
100: p_encoded => FND_API.G_FALSE,
101: p_count => x_msg_count,
102: p_data => x_msg_data);

Line 100: p_encoded => FND_API.G_FALSE,

96: WHEN FND_API.G_EXC_ERROR THEN
97: ROLLBACK TO create_adapter_pub;
98: x_return_status := FND_API.G_RET_STS_ERROR;
99: FND_MSG_PUB.Count_And_Get(
100: p_encoded => FND_API.G_FALSE,
101: p_count => x_msg_count,
102: p_data => x_msg_data);
103:
104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

100: p_encoded => FND_API.G_FALSE,
101: p_count => x_msg_count,
102: p_data => x_msg_data);
103:
104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
105: ROLLBACK TO create_adapter_pub;
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107: FND_MSG_PUB.Count_And_Get(
108: p_encoded => FND_API.G_FALSE,

Line 106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

102: p_data => x_msg_data);
103:
104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
105: ROLLBACK TO create_adapter_pub;
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107: FND_MSG_PUB.Count_And_Get(
108: p_encoded => FND_API.G_FALSE,
109: p_count => x_msg_count,
110: p_data => x_msg_data);

Line 108: p_encoded => FND_API.G_FALSE,

104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
105: ROLLBACK TO create_adapter_pub;
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107: FND_MSG_PUB.Count_And_Get(
108: p_encoded => FND_API.G_FALSE,
109: p_count => x_msg_count,
110: p_data => x_msg_data);
111:
112: WHEN OTHERS THEN

Line 114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

110: p_data => x_msg_data);
111:
112: WHEN OTHERS THEN
113: ROLLBACK TO create_adapter_pub;
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
116: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
117: FND_MSG_PUB.ADD;
118: FND_MSG_PUB.Count_And_Get(

Line 119: p_encoded => FND_API.G_FALSE,

115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
116: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
117: FND_MSG_PUB.ADD;
118: FND_MSG_PUB.Count_And_Get(
119: p_encoded => FND_API.G_FALSE,
120: p_count => x_msg_count,
121: p_data => x_msg_data);
122: END create_adapter;
123:

Line 139: x_return_status := FND_API.G_RET_STS_SUCCESS;

135: savepoint create_adapter_terr_pub;
136: FND_MSG_PUB.initialize;
137:
138: --Initialize API return status to success.
139: x_return_status := FND_API.G_RET_STS_SUCCESS;
140:
141: validate_adapter_terr(
142: p_create_update_flag => 'C'
143: ,p_adapter_terr_rec => p_adapter_terr_rec

Line 146: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

142: p_create_update_flag => 'C'
143: ,p_adapter_terr_rec => p_adapter_terr_rec
144: ,x_return_status => x_return_status );
145:
146: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
147: RAISE FND_API.G_EXC_ERROR;
148: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
150: END IF;

Line 147: RAISE FND_API.G_EXC_ERROR;

143: ,p_adapter_terr_rec => p_adapter_terr_rec
144: ,x_return_status => x_return_status );
145:
146: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
147: RAISE FND_API.G_EXC_ERROR;
148: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
150: END IF;
151:

Line 148: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

144: ,x_return_status => x_return_status );
145:
146: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
147: RAISE FND_API.G_EXC_ERROR;
148: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
150: END IF;
151:
152: HZ_ADAPTER_TERRITORIES_PKG.Insert_Row (

Line 149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

145:
146: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
147: RAISE FND_API.G_EXC_ERROR;
148: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
150: END IF;
151:
152: HZ_ADAPTER_TERRITORIES_PKG.Insert_Row (
153: x_adapter_id => p_adapter_terr_rec.adapter_id

Line 161: WHEN FND_API.G_EXC_ERROR THEN

157: ,x_object_version_number => 1 );
158:
159: EXCEPTION
160:
161: WHEN FND_API.G_EXC_ERROR THEN
162: ROLLBACK TO create_adapter_terr_pub;
163: x_return_status := FND_API.G_RET_STS_ERROR;
164: FND_MSG_PUB.Count_And_Get(
165: p_encoded => FND_API.G_FALSE,

Line 163: x_return_status := FND_API.G_RET_STS_ERROR;

159: EXCEPTION
160:
161: WHEN FND_API.G_EXC_ERROR THEN
162: ROLLBACK TO create_adapter_terr_pub;
163: x_return_status := FND_API.G_RET_STS_ERROR;
164: FND_MSG_PUB.Count_And_Get(
165: p_encoded => FND_API.G_FALSE,
166: p_count => x_msg_count,
167: p_data => x_msg_data);

Line 165: p_encoded => FND_API.G_FALSE,

161: WHEN FND_API.G_EXC_ERROR THEN
162: ROLLBACK TO create_adapter_terr_pub;
163: x_return_status := FND_API.G_RET_STS_ERROR;
164: FND_MSG_PUB.Count_And_Get(
165: p_encoded => FND_API.G_FALSE,
166: p_count => x_msg_count,
167: p_data => x_msg_data);
168:
169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

165: p_encoded => FND_API.G_FALSE,
166: p_count => x_msg_count,
167: p_data => x_msg_data);
168:
169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
170: ROLLBACK TO create_adapter_terr_pub;
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: FND_MSG_PUB.Count_And_Get(
173: p_encoded => FND_API.G_FALSE,

Line 171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

167: p_data => x_msg_data);
168:
169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
170: ROLLBACK TO create_adapter_terr_pub;
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: FND_MSG_PUB.Count_And_Get(
173: p_encoded => FND_API.G_FALSE,
174: p_count => x_msg_count,
175: p_data => x_msg_data);

Line 173: p_encoded => FND_API.G_FALSE,

169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
170: ROLLBACK TO create_adapter_terr_pub;
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: FND_MSG_PUB.Count_And_Get(
173: p_encoded => FND_API.G_FALSE,
174: p_count => x_msg_count,
175: p_data => x_msg_data);
176:
177: WHEN OTHERS THEN

Line 179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

175: p_data => x_msg_data);
176:
177: WHEN OTHERS THEN
178: ROLLBACK TO create_adapter_terr_pub;
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
180: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
181: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
182: FND_MSG_PUB.ADD;
183: FND_MSG_PUB.Count_And_Get(

Line 184: p_encoded => FND_API.G_FALSE,

180: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
181: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
182: FND_MSG_PUB.ADD;
183: FND_MSG_PUB.Count_And_Get(
184: p_encoded => FND_API.G_FALSE,
185: p_count => x_msg_count,
186: p_data => x_msg_data);
187: END create_adapter_terr;
188:

Line 207: x_return_status := FND_API.G_RET_STS_SUCCESS;

203: savepoint update_adapter_pub;
204: FND_MSG_PUB.initialize;
205:
206: --Initialize API return status to success.
207: x_return_status := FND_API.G_RET_STS_SUCCESS;
208:
209: -- Lock record.
210: BEGIN
211:

Line 229: RAISE FND_API.G_EXC_ERROR;

225: THEN
226: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
227: FND_MESSAGE.SET_TOKEN( 'TABLE', 'HZ_ADAPTERS' );
228: FND_MSG_PUB.ADD;
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;
231:
232: px_object_version_number := NVL(l_object_version_number,1)+1;
233:

Line 240: RAISE FND_API.G_EXC_ERROR;

236: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
237: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Adapter' );
238: FND_MESSAGE.SET_TOKEN( 'VALUE', l_adapter_id);
239: FND_MSG_PUB.ADD;
240: RAISE FND_API.G_EXC_ERROR;
241: END;
242:
243: validate_adapter(
244: p_create_update_flag => 'U'

Line 248: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

244: p_create_update_flag => 'U'
245: ,p_adapter_rec => p_adapter_rec
246: ,x_return_status => x_return_status );
247:
248: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
249: RAISE FND_API.G_EXC_ERROR;
250: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252: END IF;

Line 249: RAISE FND_API.G_EXC_ERROR;

245: ,p_adapter_rec => p_adapter_rec
246: ,x_return_status => x_return_status );
247:
248: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
249: RAISE FND_API.G_EXC_ERROR;
250: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252: END IF;
253:

Line 250: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

246: ,x_return_status => x_return_status );
247:
248: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
249: RAISE FND_API.G_EXC_ERROR;
250: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252: END IF;
253:
254: HZ_ADAPTERS_PKG.Update_Row(

Line 251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

247:
248: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
249: RAISE FND_API.G_EXC_ERROR;
250: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252: END IF;
253:
254: HZ_ADAPTERS_PKG.Update_Row(
255: x_rowid => l_rowid

Line 271: WHEN FND_API.G_EXC_ERROR THEN

267: ,x_default_replace_status_level => p_adapter_rec.default_replace_status_level
268: ,x_object_version_number => px_object_version_number );
269:
270: EXCEPTION
271: WHEN FND_API.G_EXC_ERROR THEN
272: ROLLBACK TO update_adapter_pub;
273: x_return_status := FND_API.G_RET_STS_ERROR;
274: FND_MSG_PUB.Count_And_Get(
275: p_encoded => FND_API.G_FALSE,

Line 273: x_return_status := FND_API.G_RET_STS_ERROR;

269:
270: EXCEPTION
271: WHEN FND_API.G_EXC_ERROR THEN
272: ROLLBACK TO update_adapter_pub;
273: x_return_status := FND_API.G_RET_STS_ERROR;
274: FND_MSG_PUB.Count_And_Get(
275: p_encoded => FND_API.G_FALSE,
276: p_count => x_msg_count,
277: p_data => x_msg_data);

Line 275: p_encoded => FND_API.G_FALSE,

271: WHEN FND_API.G_EXC_ERROR THEN
272: ROLLBACK TO update_adapter_pub;
273: x_return_status := FND_API.G_RET_STS_ERROR;
274: FND_MSG_PUB.Count_And_Get(
275: p_encoded => FND_API.G_FALSE,
276: p_count => x_msg_count,
277: p_data => x_msg_data);
278:
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

275: p_encoded => FND_API.G_FALSE,
276: p_count => x_msg_count,
277: p_data => x_msg_data);
278:
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: ROLLBACK TO update_adapter_pub;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: FND_MSG_PUB.Count_And_Get(
283: p_encoded => FND_API.G_FALSE,

Line 281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

277: p_data => x_msg_data);
278:
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: ROLLBACK TO update_adapter_pub;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: FND_MSG_PUB.Count_And_Get(
283: p_encoded => FND_API.G_FALSE,
284: p_count => x_msg_count,
285: p_data => x_msg_data);

Line 283: p_encoded => FND_API.G_FALSE,

279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: ROLLBACK TO update_adapter_pub;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: FND_MSG_PUB.Count_And_Get(
283: p_encoded => FND_API.G_FALSE,
284: p_count => x_msg_count,
285: p_data => x_msg_data);
286:
287: WHEN OTHERS THEN

Line 289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

285: p_data => x_msg_data);
286:
287: WHEN OTHERS THEN
288: ROLLBACK TO update_adapter_pub;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
291: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
292: FND_MSG_PUB.ADD;
293: FND_MSG_PUB.Count_And_Get(

Line 294: p_encoded => FND_API.G_FALSE,

290: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
291: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
292: FND_MSG_PUB.ADD;
293: FND_MSG_PUB.Count_And_Get(
294: p_encoded => FND_API.G_FALSE,
295: p_count => x_msg_count,
296: p_data => x_msg_data);
297: END update_adapter;
298:

Line 317: x_return_status := FND_API.G_RET_STS_SUCCESS;

313: savepoint update_adapter_terr_pub;
314: FND_MSG_PUB.initialize;
315:
316: --Initialize API return status to success.
317: x_return_status := FND_API.G_RET_STS_SUCCESS;
318:
319: -- Lock record.
320: BEGIN
321:

Line 341: RAISE FND_API.G_EXC_ERROR;

337: THEN
338: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
339: FND_MESSAGE.SET_TOKEN( 'TABLE', 'HZ_ADAPTERS' );
340: FND_MSG_PUB.ADD;
341: RAISE FND_API.G_EXC_ERROR;
342: END IF;
343:
344: px_object_version_number := NVL(l_object_version_number,1)+1;
345:

Line 352: RAISE FND_API.G_EXC_ERROR;

348: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
349: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Adapter' );
350: FND_MESSAGE.SET_TOKEN( 'VALUE', l_adapter_id);
351: FND_MSG_PUB.ADD;
352: RAISE FND_API.G_EXC_ERROR;
353: END;
354:
355: validate_adapter_terr(
356: p_create_update_flag => 'U'

Line 360: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

356: p_create_update_flag => 'U'
357: ,p_adapter_terr_rec => p_adapter_terr_rec
358: ,x_return_status => x_return_status );
359:
360: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
361: RAISE FND_API.G_EXC_ERROR;
362: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;

Line 361: RAISE FND_API.G_EXC_ERROR;

357: ,p_adapter_terr_rec => p_adapter_terr_rec
358: ,x_return_status => x_return_status );
359:
360: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
361: RAISE FND_API.G_EXC_ERROR;
362: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365:

Line 362: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

358: ,x_return_status => x_return_status );
359:
360: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
361: RAISE FND_API.G_EXC_ERROR;
362: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365:
366: HZ_ADAPTER_TERRITORIES_PKG.Update_Row(

Line 363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

359:
360: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
361: RAISE FND_API.G_EXC_ERROR;
362: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365:
366: HZ_ADAPTER_TERRITORIES_PKG.Update_Row(
367: x_rowid => l_rowid

Line 376: WHEN FND_API.G_EXC_ERROR THEN

372: ,x_object_version_number => px_object_version_number );
373:
374: EXCEPTION
375:
376: WHEN FND_API.G_EXC_ERROR THEN
377: ROLLBACK TO update_adapter_terr_pub;
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: FND_MSG_PUB.Count_And_Get(
380: p_encoded => FND_API.G_FALSE,

Line 378: x_return_status := FND_API.G_RET_STS_ERROR;

374: EXCEPTION
375:
376: WHEN FND_API.G_EXC_ERROR THEN
377: ROLLBACK TO update_adapter_terr_pub;
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: FND_MSG_PUB.Count_And_Get(
380: p_encoded => FND_API.G_FALSE,
381: p_count => x_msg_count,
382: p_data => x_msg_data);

Line 380: p_encoded => FND_API.G_FALSE,

376: WHEN FND_API.G_EXC_ERROR THEN
377: ROLLBACK TO update_adapter_terr_pub;
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: FND_MSG_PUB.Count_And_Get(
380: p_encoded => FND_API.G_FALSE,
381: p_count => x_msg_count,
382: p_data => x_msg_data);
383:
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

380: p_encoded => FND_API.G_FALSE,
381: p_count => x_msg_count,
382: p_data => x_msg_data);
383:
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: ROLLBACK TO update_adapter_terr_pub;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: FND_MSG_PUB.Count_And_Get(
388: p_encoded => FND_API.G_FALSE,

Line 386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

382: p_data => x_msg_data);
383:
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: ROLLBACK TO update_adapter_terr_pub;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: FND_MSG_PUB.Count_And_Get(
388: p_encoded => FND_API.G_FALSE,
389: p_count => x_msg_count,
390: p_data => x_msg_data);

Line 388: p_encoded => FND_API.G_FALSE,

384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: ROLLBACK TO update_adapter_terr_pub;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: FND_MSG_PUB.Count_And_Get(
388: p_encoded => FND_API.G_FALSE,
389: p_count => x_msg_count,
390: p_data => x_msg_data);
391:
392: WHEN OTHERS THEN

Line 394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

390: p_data => x_msg_data);
391:
392: WHEN OTHERS THEN
393: ROLLBACK TO update_adapter_terr_pub;
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
396: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
397: FND_MSG_PUB.ADD;
398: FND_MSG_PUB.Count_And_Get(

Line 399: p_encoded => FND_API.G_FALSE,

395: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
396: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
397: FND_MSG_PUB.ADD;
398: FND_MSG_PUB.Count_And_Get(
399: p_encoded => FND_API.G_FALSE,
400: p_count => x_msg_count,
401: p_data => x_msg_data);
402: END update_adapter_terr;
403:

Line 429: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

425: BEGIN
426: FND_MSG_PUB.Reset;
427:
428: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
429: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
430: END LOOP;
431: IF (SQLERRM IS NOT NULL) THEN
432: l_msg_data := l_msg_data || SQLERRM;
433: END IF;

Line 466: IF(l_adapter_content_source IS NULL OR l_adapter_content_source = FND_API.G_MISS_CHAR) THEN

462: l_maximum_batch_size := p_adapter_rec.maximum_batch_size;
463: l_default_batch_size := p_adapter_rec.default_batch_size;
464:
465: -- check not null first
466: IF(l_adapter_content_source IS NULL OR l_adapter_content_source = FND_API.G_MISS_CHAR) THEN
467: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
468: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ADAPTER_CONTENT_SOURCE');
469: FND_MSG_PUB.ADD;
470: RAISE FND_API.G_EXC_ERROR;

Line 470: RAISE FND_API.G_EXC_ERROR;

466: IF(l_adapter_content_source IS NULL OR l_adapter_content_source = FND_API.G_MISS_CHAR) THEN
467: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
468: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ADAPTER_CONTENT_SOURCE');
469: FND_MSG_PUB.ADD;
470: RAISE FND_API.G_EXC_ERROR;
471: END IF;
472:
473: IF(l_message_format_code IS NULL OR l_message_format_code = FND_API.G_MISS_CHAR) THEN
474: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

Line 473: IF(l_message_format_code IS NULL OR l_message_format_code = FND_API.G_MISS_CHAR) THEN

469: FND_MSG_PUB.ADD;
470: RAISE FND_API.G_EXC_ERROR;
471: END IF;
472:
473: IF(l_message_format_code IS NULL OR l_message_format_code = FND_API.G_MISS_CHAR) THEN
474: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
475: FND_MESSAGE.SET_TOKEN('COLUMN' ,'MESSAGE_FORMAT_CODE');
476: FND_MSG_PUB.ADD;
477: RAISE FND_API.G_EXC_ERROR;

Line 477: RAISE FND_API.G_EXC_ERROR;

473: IF(l_message_format_code IS NULL OR l_message_format_code = FND_API.G_MISS_CHAR) THEN
474: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
475: FND_MESSAGE.SET_TOKEN('COLUMN' ,'MESSAGE_FORMAT_CODE');
476: FND_MSG_PUB.ADD;
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479:
480: IF(l_invoke_method_code IS NULL OR l_invoke_method_code = FND_API.G_MISS_CHAR) THEN
481: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

Line 480: IF(l_invoke_method_code IS NULL OR l_invoke_method_code = FND_API.G_MISS_CHAR) THEN

476: FND_MSG_PUB.ADD;
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479:
480: IF(l_invoke_method_code IS NULL OR l_invoke_method_code = FND_API.G_MISS_CHAR) THEN
481: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
482: FND_MESSAGE.SET_TOKEN('COLUMN' ,'INVOKE_METHOD_CODE');
483: FND_MSG_PUB.ADD;
484: RAISE FND_API.G_EXC_ERROR;

Line 484: RAISE FND_API.G_EXC_ERROR;

480: IF(l_invoke_method_code IS NULL OR l_invoke_method_code = FND_API.G_MISS_CHAR) THEN
481: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
482: FND_MESSAGE.SET_TOKEN('COLUMN' ,'INVOKE_METHOD_CODE');
483: FND_MSG_PUB.ADD;
484: RAISE FND_API.G_EXC_ERROR;
485: END IF;
486:
487: IF(l_maximum_batch_size IS NULL OR l_maximum_batch_size = FND_API.G_MISS_NUM) THEN
488: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

Line 487: IF(l_maximum_batch_size IS NULL OR l_maximum_batch_size = FND_API.G_MISS_NUM) THEN

483: FND_MSG_PUB.ADD;
484: RAISE FND_API.G_EXC_ERROR;
485: END IF;
486:
487: IF(l_maximum_batch_size IS NULL OR l_maximum_batch_size = FND_API.G_MISS_NUM) THEN
488: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
489: FND_MESSAGE.SET_TOKEN('COLUMN' ,'MAXIMUM_BATCH_SIZE');
490: FND_MSG_PUB.ADD;
491: RAISE FND_API.G_EXC_ERROR;

Line 491: RAISE FND_API.G_EXC_ERROR;

487: IF(l_maximum_batch_size IS NULL OR l_maximum_batch_size = FND_API.G_MISS_NUM) THEN
488: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
489: FND_MESSAGE.SET_TOKEN('COLUMN' ,'MAXIMUM_BATCH_SIZE');
490: FND_MSG_PUB.ADD;
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:
494: IF(l_default_batch_size IS NULL OR l_default_batch_size = FND_API.G_MISS_NUM) THEN
495: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

Line 494: IF(l_default_batch_size IS NULL OR l_default_batch_size = FND_API.G_MISS_NUM) THEN

490: FND_MSG_PUB.ADD;
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:
494: IF(l_default_batch_size IS NULL OR l_default_batch_size = FND_API.G_MISS_NUM) THEN
495: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
496: FND_MESSAGE.SET_TOKEN('COLUMN' ,'DEFAULT_BATCH_SIZE');
497: FND_MSG_PUB.ADD;
498: RAISE FND_API.G_EXC_ERROR;

Line 498: RAISE FND_API.G_EXC_ERROR;

494: IF(l_default_batch_size IS NULL OR l_default_batch_size = FND_API.G_MISS_NUM) THEN
495: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
496: FND_MESSAGE.SET_TOKEN('COLUMN' ,'DEFAULT_BATCH_SIZE');
497: FND_MSG_PUB.ADD;
498: RAISE FND_API.G_EXC_ERROR;
499: END IF;
500:
501: -- check adapter_content_source
502: IF(p_create_update_flag = 'C') THEN

Line 510: RAISE FND_API.G_EXC_ERROR;

506: IF(check_lookup%FOUND) THEN
507: -- error saying that content source already exist
508: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_DUP_ADPT');
509: FND_MSG_PUB.ADD;
510: RAISE FND_API.G_EXC_ERROR;
511: END IF;
512: CLOSE check_lookup;
513: ELSIF(p_create_update_flag = 'U') THEN
514: OPEN check_lookup(l_adapter_content_source, 'CONTENT_SOURCE_TYPE');

Line 520: RAISE FND_API.G_EXC_ERROR;

516: IF(check_lookup%NOTFOUND) THEN
517: -- error saying that content source not found
518: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_ADAPTER');
519: FND_MSG_PUB.ADD;
520: RAISE FND_API.G_EXC_ERROR;
521: END IF;
522: CLOSE check_lookup;
523: END IF;
524:

Line 533: RAISE FND_API.G_EXC_ERROR;

529: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_LOOKUP');
530: FND_MESSAGE.SET_TOKEN('COLUMN' ,'MESSAGE_FORMAT_CODE');
531: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE' , 'HZ_MESSAGE_FORMAT');
532: FND_MSG_PUB.ADD;
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;
535: CLOSE check_lookup;
536:
537: -- check invoke_method_code

Line 545: RAISE FND_API.G_EXC_ERROR;

541: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_LOOKUP');
542: FND_MESSAGE.SET_TOKEN('COLUMN' ,'INVOKE_METHOD_CODE');
543: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE' , 'HZ_INVOKE_METHOD');
544: FND_MSG_PUB.ADD;
545: RAISE FND_API.G_EXC_ERROR;
546: END IF;
547: CLOSE check_lookup;
548:
549: -- check maximum_batch_size and default_batch_size

Line 553: RAISE FND_API.G_EXC_ERROR;

549: -- check maximum_batch_size and default_batch_size
550: IF((l_maximum_batch_size < 1) OR (l_default_batch_size < 1))THEN
551: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_BATCH_SIZE');
552: FND_MSG_PUB.ADD;
553: RAISE FND_API.G_EXC_ERROR;
554: END IF;
555:
556: EXCEPTION
557: WHEN FND_API.G_EXC_ERROR THEN

Line 557: WHEN FND_API.G_EXC_ERROR THEN

553: RAISE FND_API.G_EXC_ERROR;
554: END IF;
555:
556: EXCEPTION
557: WHEN FND_API.G_EXC_ERROR THEN
558: x_return_status := FND_API.G_RET_STS_ERROR;
559:
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 558: x_return_status := FND_API.G_RET_STS_ERROR;

554: END IF;
555:
556: EXCEPTION
557: WHEN FND_API.G_EXC_ERROR THEN
558: x_return_status := FND_API.G_RET_STS_ERROR;
559:
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562:

Line 560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

556: EXCEPTION
557: WHEN FND_API.G_EXC_ERROR THEN
558: x_return_status := FND_API.G_RET_STS_ERROR;
559:
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562:
563: WHEN OTHERS THEN
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

557: WHEN FND_API.G_EXC_ERROR THEN
558: x_return_status := FND_API.G_RET_STS_ERROR;
559:
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562:
563: WHEN OTHERS THEN
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562:
563: WHEN OTHERS THEN
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
566: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
567: FND_MSG_PUB.ADD;
568: END validate_adapter;

Line 609: IF(l_adapter_id IS NULL OR l_adapter_id = FND_API.G_MISS_NUM) THEN

605: l_enabled_flag := p_adapter_terr_rec.enabled_flag;
606: l_default_flag := p_adapter_terr_rec.default_flag;
607:
608: -- check not null
609: IF(l_adapter_id IS NULL OR l_adapter_id = FND_API.G_MISS_NUM) THEN
610: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
611: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ADAPTER_ID');
612: FND_MSG_PUB.ADD;
613: RAISE FND_API.G_EXC_ERROR;

Line 613: RAISE FND_API.G_EXC_ERROR;

609: IF(l_adapter_id IS NULL OR l_adapter_id = FND_API.G_MISS_NUM) THEN
610: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
611: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ADAPTER_ID');
612: FND_MSG_PUB.ADD;
613: RAISE FND_API.G_EXC_ERROR;
614: END IF;
615:
616: IF(l_territory_code IS NULL OR l_territory_code = FND_API.G_MISS_CHAR) THEN
617: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

Line 616: IF(l_territory_code IS NULL OR l_territory_code = FND_API.G_MISS_CHAR) THEN

612: FND_MSG_PUB.ADD;
613: RAISE FND_API.G_EXC_ERROR;
614: END IF;
615:
616: IF(l_territory_code IS NULL OR l_territory_code = FND_API.G_MISS_CHAR) THEN
617: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
618: FND_MESSAGE.SET_TOKEN('COLUMN' ,'TERRITORY_CODE');
619: FND_MSG_PUB.ADD;
620: RAISE FND_API.G_EXC_ERROR;

Line 620: RAISE FND_API.G_EXC_ERROR;

616: IF(l_territory_code IS NULL OR l_territory_code = FND_API.G_MISS_CHAR) THEN
617: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
618: FND_MESSAGE.SET_TOKEN('COLUMN' ,'TERRITORY_CODE');
619: FND_MSG_PUB.ADD;
620: RAISE FND_API.G_EXC_ERROR;
621: END IF;
622:
623: -- if create a loc adapter territory, it can't be disabled and set to default 'Y'
624: -- give message saying that this setting is not allowed

Line 629: RAISE FND_API.G_EXC_ERROR;

625: IF((l_enabled_flag = 'N') AND (l_default_flag = 'Y')) THEN
626: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
627: FND_MESSAGE.SET_TOKEN('COLUMN' ,'TERRITORY_CODE');
628: FND_MSG_PUB.ADD;
629: RAISE FND_API.G_EXC_ERROR;
630: END IF;
631:
632: -- check adapter_content_source
633: -- if not found, then raise error saying adapter_content_source not exist

Line 639: RAISE FND_API.G_EXC_ERROR;

635: FETCH check_adapter INTO l_dummy;
636: IF(check_adapter%NOTFOUND) THEN
637: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_ADAPTER');
638: FND_MSG_PUB.ADD;
639: RAISE FND_API.G_EXC_ERROR;
640: END IF;
641: CLOSE check_adapter;
642:
643: -- check territory_code

Line 650: RAISE FND_API.G_EXC_ERROR;

646: FETCH check_terr INTO l_dummy;
647: IF(check_terr%NOTFOUND) THEN
648: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_TERRITORY');
649: FND_MSG_PUB.ADD;
650: RAISE FND_API.G_EXC_ERROR;
651: END IF;
652: CLOSE check_terr;
653:
654: -- check default flag for this country. Only one active default adapter for each country

Line 661: RAISE FND_API.G_EXC_ERROR;

657: FETCH check_terr_default INTO l_dummy;
658: IF(check_terr_default%FOUND) THEN
659: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_DEFAULT');
660: FND_MSG_PUB.ADD;
661: RAISE FND_API.G_EXC_ERROR;
662: END IF;
663: CLOSE check_terr_default;
664: END IF;
665:

Line 667: WHEN FND_API.G_EXC_ERROR THEN

663: CLOSE check_terr_default;
664: END IF;
665:
666: EXCEPTION
667: WHEN FND_API.G_EXC_ERROR THEN
668: x_return_status := FND_API.G_RET_STS_ERROR;
669:
670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 668: x_return_status := FND_API.G_RET_STS_ERROR;

664: END IF;
665:
666: EXCEPTION
667: WHEN FND_API.G_EXC_ERROR THEN
668: x_return_status := FND_API.G_RET_STS_ERROR;
669:
670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672:

Line 670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

666: EXCEPTION
667: WHEN FND_API.G_EXC_ERROR THEN
668: x_return_status := FND_API.G_RET_STS_ERROR;
669:
670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672:
673: WHEN OTHERS THEN
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

667: WHEN FND_API.G_EXC_ERROR THEN
668: x_return_status := FND_API.G_RET_STS_ERROR;
669:
670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672:
673: WHEN OTHERS THEN
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672:
673: WHEN OTHERS THEN
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
676: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
677: FND_MSG_PUB.ADD;
678: