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.AMS_DMMODEL_PUB dependencies on FND_API

Line 34: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

30: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
31:
32: PROCEDURE Create_Model(
33: p_api_version_number IN NUMBER,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE,
36:
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,

Line 35: p_commit IN VARCHAR2 := FND_API.G_FALSE,

31:
32: PROCEDURE Create_Model(
33: p_api_version_number IN NUMBER,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE,
36:
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2,

Line 53: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

49: -- Standard Start of API savepoint
50: SAVEPOINT Create_Model_PUB;
51:
52: -- Standard call to check for call compatibility.
53: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
54: p_api_version_number,
55: l_api_name,
56: G_PKG_NAME)
57: THEN

Line 58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

54: p_api_version_number,
55: l_api_name,
56: G_PKG_NAME)
57: THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60:
61: -- Initialize message list if p_init_msg_list is set to TRUE.
62: IF FND_API.to_Boolean( p_init_msg_list )

Line 62: IF FND_API.to_Boolean( p_init_msg_list )

58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60:
61: -- Initialize message list if p_init_msg_list is set to TRUE.
62: IF FND_API.to_Boolean( p_init_msg_list )
63: THEN
64: FND_MSG_PUB.initialize;
65: END IF;
66:

Line 75: x_return_status := FND_API.G_RET_STS_SUCCESS;

71: END IF;
72:
73:
74: -- Initialize API return status to SUCCESS
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:
77: --
78: -- API body
79: --

Line 130: p_init_msg_list => FND_API.G_FALSE,

126:
127: -- Calling Private package: Create_Model
128: AMS_Dm_model_PVT.Create_DM_Model(
129: p_api_version_number => 1.0,
130: p_init_msg_list => FND_API.G_FALSE,
131: p_commit => FND_API.G_FALSE,
132: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
133: x_return_status => x_return_status,
134: x_msg_count => x_msg_count,

Line 131: p_commit => FND_API.G_FALSE,

127: -- Calling Private package: Create_Model
128: AMS_Dm_model_PVT.Create_DM_Model(
129: p_api_version_number => 1.0,
130: p_init_msg_list => FND_API.G_FALSE,
131: p_commit => FND_API.G_FALSE,
132: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
133: x_return_status => x_return_status,
134: x_msg_count => x_msg_count,
135: x_msg_data => x_msg_data,

Line 132: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

128: AMS_Dm_model_PVT.Create_DM_Model(
129: p_api_version_number => 1.0,
130: p_init_msg_list => FND_API.G_FALSE,
131: p_commit => FND_API.G_FALSE,
132: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
133: x_return_status => x_return_status,
134: x_msg_count => x_msg_count,
135: x_msg_data => x_msg_data,
136: p_dm_model_rec => l_pvt_model_rec,

Line 141: IF x_return_status = FND_API.G_RET_STS_ERROR then

137: x_custom_setup_id => l_pvt_model_rec.custom_setup_id,
138: x_model_id => x_model_id
139: );
140: -- Check return status from the above procedure call
141: IF x_return_status = FND_API.G_RET_STS_ERROR then
142: RAISE FND_API.G_EXC_ERROR;
143: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: END IF;

Line 142: RAISE FND_API.G_EXC_ERROR;

138: x_model_id => x_model_id
139: );
140: -- Check return status from the above procedure call
141: IF x_return_status = FND_API.G_RET_STS_ERROR then
142: RAISE FND_API.G_EXC_ERROR;
143: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: END IF;
146: --

Line 143: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

139: );
140: -- Check return status from the above procedure call
141: IF x_return_status = FND_API.G_RET_STS_ERROR then
142: RAISE FND_API.G_EXC_ERROR;
143: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: END IF;
146: --
147: -- End of API body.

Line 144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

140: -- Check return status from the above procedure call
141: IF x_return_status = FND_API.G_RET_STS_ERROR then
142: RAISE FND_API.G_EXC_ERROR;
143: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: END IF;
146: --
147: -- End of API body.
148: --

Line 151: IF FND_API.to_Boolean( p_commit )

147: -- End of API body.
148: --
149:
150: -- Standard check for p_commit
151: IF FND_API.to_Boolean( p_commit )
152: THEN
153: COMMIT WORK;
154: END IF;
155:

Line 171: x_return_status := FND_API.g_ret_sts_error;

167: );
168: EXCEPTION
169:
170: WHEN AMS_Utility_PVT.resource_locked THEN
171: x_return_status := FND_API.g_ret_sts_error;
172: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
173: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
174: FND_MSG_PUB.add;
175: END IF;

Line 177: WHEN FND_API.G_EXC_ERROR THEN

173: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
174: FND_MSG_PUB.add;
175: END IF;
176:
177: WHEN FND_API.G_EXC_ERROR THEN
178: ROLLBACK TO Create_Model_PUB;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: -- Standard call to get message count and if count=1, get the message
181: FND_MSG_PUB.Count_And_Get (

Line 179: x_return_status := FND_API.G_RET_STS_ERROR;

175: END IF;
176:
177: WHEN FND_API.G_EXC_ERROR THEN
178: ROLLBACK TO Create_Model_PUB;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: -- Standard call to get message count and if count=1, get the message
181: FND_MSG_PUB.Count_And_Get (
182: p_encoded => FND_API.G_FALSE,
183: p_count => x_msg_count,

Line 182: p_encoded => FND_API.G_FALSE,

178: ROLLBACK TO Create_Model_PUB;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: -- Standard call to get message count and if count=1, get the message
181: FND_MSG_PUB.Count_And_Get (
182: p_encoded => FND_API.G_FALSE,
183: p_count => x_msg_count,
184: p_data => x_msg_data
185: );
186:

Line 187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

183: p_count => x_msg_count,
184: p_data => x_msg_data
185: );
186:
187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO Create_Model_PUB;
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: -- Standard call to get message count and if count=1, get the message
191: FND_MSG_PUB.Count_And_Get (

Line 189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

185: );
186:
187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO Create_Model_PUB;
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: -- Standard call to get message count and if count=1, get the message
191: FND_MSG_PUB.Count_And_Get (
192: p_encoded => FND_API.G_FALSE,
193: p_count => x_msg_count,

Line 192: p_encoded => FND_API.G_FALSE,

188: ROLLBACK TO Create_Model_PUB;
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: -- Standard call to get message count and if count=1, get the message
191: FND_MSG_PUB.Count_And_Get (
192: p_encoded => FND_API.G_FALSE,
193: p_count => x_msg_count,
194: p_data => x_msg_data
195: );
196:

Line 199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

195: );
196:
197: WHEN OTHERS THEN
198: ROLLBACK TO Create_Model_PUB;
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
201: THEN
202: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
203: END IF;

Line 206: p_encoded => FND_API.G_FALSE,

202: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
203: END IF;
204: -- Standard call to get message count and if count=1, get the message
205: FND_MSG_PUB.Count_And_Get (
206: p_encoded => FND_API.G_FALSE,
207: p_count => x_msg_count,
208: p_data => x_msg_data
209: );
210: End Create_Model;

Line 215: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

211:
212:
213: PROCEDURE Update_Model(
214: p_api_version_number IN NUMBER,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
217:
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,

Line 216: p_commit IN VARCHAR2 := FND_API.G_FALSE,

212:
213: PROCEDURE Update_Model(
214: p_api_version_number IN NUMBER,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
217:
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,

Line 236: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

232: -- Standard Start of API savepoint
233: SAVEPOINT Update_Model_PUB;
234:
235: -- Standard call to check for call compatibility.
236: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
237: p_api_version_number,
238: l_api_name,
239: G_PKG_NAME)
240: THEN

Line 241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

237: p_api_version_number,
238: l_api_name,
239: G_PKG_NAME)
240: THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: END IF;
243:
244: -- Initialize message list if p_init_msg_list is set to TRUE.
245: IF FND_API.to_Boolean( p_init_msg_list )

Line 245: IF FND_API.to_Boolean( p_init_msg_list )

241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: END IF;
243:
244: -- Initialize message list if p_init_msg_list is set to TRUE.
245: IF FND_API.to_Boolean( p_init_msg_list )
246: THEN
247: FND_MSG_PUB.initialize;
248: END IF;
249:

Line 258: x_return_status := FND_API.G_RET_STS_SUCCESS;

254: END IF;
255:
256:
257: -- Initialize API return status to SUCCESS
258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259:
260: --
261: -- API body
262: --

Line 313: p_init_msg_list => FND_API.G_FALSE,

309: l_pvt_model_rec.description := p_model_rec.description;
310:
311: AMS_DM_Model_PVT.Update_DM_Model(
312: p_api_version_number => 1.0,
313: p_init_msg_list => FND_API.G_FALSE,
314: p_commit => p_commit,
315: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
316: x_return_status => x_return_status,
317: x_msg_count => x_msg_count,

Line 315: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

311: AMS_DM_Model_PVT.Update_DM_Model(
312: p_api_version_number => 1.0,
313: p_init_msg_list => FND_API.G_FALSE,
314: p_commit => p_commit,
315: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
316: x_return_status => x_return_status,
317: x_msg_count => x_msg_count,
318: x_msg_data => x_msg_data,
319: p_dm_model_rec => l_pvt_model_rec,

Line 323: IF x_return_status = FND_API.G_RET_STS_ERROR then

319: p_dm_model_rec => l_pvt_model_rec,
320: x_object_version_number => l_object_version_number
321: );
322: -- Check return status from the above procedure call
323: IF x_return_status = FND_API.G_RET_STS_ERROR then
324: RAISE FND_API.G_EXC_ERROR;
325: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;

Line 324: RAISE FND_API.G_EXC_ERROR;

320: x_object_version_number => l_object_version_number
321: );
322: -- Check return status from the above procedure call
323: IF x_return_status = FND_API.G_RET_STS_ERROR then
324: RAISE FND_API.G_EXC_ERROR;
325: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328: --

Line 325: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

321: );
322: -- Check return status from the above procedure call
323: IF x_return_status = FND_API.G_RET_STS_ERROR then
324: RAISE FND_API.G_EXC_ERROR;
325: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328: --
329: -- End of API body

Line 326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

322: -- Check return status from the above procedure call
323: IF x_return_status = FND_API.G_RET_STS_ERROR then
324: RAISE FND_API.G_EXC_ERROR;
325: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328: --
329: -- End of API body
330: --

Line 333: IF FND_API.to_Boolean( p_commit )

329: -- End of API body
330: --
331:
332: -- Standard check for p_commit
333: IF FND_API.to_Boolean( p_commit )
334: THEN
335: COMMIT WORK;
336: END IF;
337:

Line 353: x_return_status := FND_API.g_ret_sts_error;

349: );
350: EXCEPTION
351:
352: WHEN AMS_Utility_PVT.resource_locked THEN
353: x_return_status := FND_API.g_ret_sts_error;
354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
355: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
356: FND_MSG_PUB.add;
357: END IF;

Line 359: WHEN FND_API.G_EXC_ERROR THEN

355: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
356: FND_MSG_PUB.add;
357: END IF;
358:
359: WHEN FND_API.G_EXC_ERROR THEN
360: ROLLBACK TO Update_Model_PUB;
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: -- Standard call to get message count and if count=1, get the message
363: FND_MSG_PUB.Count_And_Get (

Line 361: x_return_status := FND_API.G_RET_STS_ERROR;

357: END IF;
358:
359: WHEN FND_API.G_EXC_ERROR THEN
360: ROLLBACK TO Update_Model_PUB;
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: -- Standard call to get message count and if count=1, get the message
363: FND_MSG_PUB.Count_And_Get (
364: p_encoded => FND_API.G_FALSE,
365: p_count => x_msg_count,

Line 364: p_encoded => FND_API.G_FALSE,

360: ROLLBACK TO Update_Model_PUB;
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: -- Standard call to get message count and if count=1, get the message
363: FND_MSG_PUB.Count_And_Get (
364: p_encoded => FND_API.G_FALSE,
365: p_count => x_msg_count,
366: p_data => x_msg_data
367: );
368:

Line 369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

365: p_count => x_msg_count,
366: p_data => x_msg_data
367: );
368:
369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370: ROLLBACK TO Update_Model_PUB;
371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
372: -- Standard call to get message count and if count=1, get the message
373: FND_MSG_PUB.Count_And_Get (

Line 371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

367: );
368:
369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370: ROLLBACK TO Update_Model_PUB;
371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
372: -- Standard call to get message count and if count=1, get the message
373: FND_MSG_PUB.Count_And_Get (
374: p_encoded => FND_API.G_FALSE,
375: p_count => x_msg_count,

Line 374: p_encoded => FND_API.G_FALSE,

370: ROLLBACK TO Update_Model_PUB;
371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
372: -- Standard call to get message count and if count=1, get the message
373: FND_MSG_PUB.Count_And_Get (
374: p_encoded => FND_API.G_FALSE,
375: p_count => x_msg_count,
376: p_data => x_msg_data
377: );
378:

Line 381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

377: );
378:
379: WHEN OTHERS THEN
380: ROLLBACK TO Update_Model_PUB;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
383: THEN
384: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
385: END IF;

Line 388: p_encoded => FND_API.G_FALSE,

384: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
385: END IF;
386: -- Standard call to get message count and if count=1, get the message
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: End Update_Model;

Line 397: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

393:
394:
395: PROCEDURE Delete_Model(
396: p_api_version_number IN NUMBER,
397: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
398: p_commit IN VARCHAR2 := FND_API.G_FALSE,
399: x_return_status OUT NOCOPY VARCHAR2,
400: x_msg_count OUT NOCOPY NUMBER,
401: x_msg_data OUT NOCOPY VARCHAR2,

Line 398: p_commit IN VARCHAR2 := FND_API.G_FALSE,

394:
395: PROCEDURE Delete_Model(
396: p_api_version_number IN NUMBER,
397: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
398: p_commit IN VARCHAR2 := FND_API.G_FALSE,
399: x_return_status OUT NOCOPY VARCHAR2,
400: x_msg_count OUT NOCOPY NUMBER,
401: x_msg_data OUT NOCOPY VARCHAR2,
402: p_model_id IN NUMBER,

Line 417: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

413: -- Standard Start of API savepoint
414: SAVEPOINT Delete_Model_PUB;
415:
416: -- Standard call to check for call compatibility.
417: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
418: p_api_version_number,
419: l_api_name,
420: G_PKG_NAME)
421: THEN

Line 422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

418: p_api_version_number,
419: l_api_name,
420: G_PKG_NAME)
421: THEN
422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
423: END IF;
424:
425: -- Initialize message list if p_init_msg_list is set to TRUE.
426: IF FND_API.to_Boolean( p_init_msg_list )

Line 426: IF FND_API.to_Boolean( p_init_msg_list )

422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
423: END IF;
424:
425: -- Initialize message list if p_init_msg_list is set to TRUE.
426: IF FND_API.to_Boolean( p_init_msg_list )
427: THEN
428: FND_MSG_PUB.initialize;
429: END IF;
430:

Line 439: x_return_status := FND_API.G_RET_STS_SUCCESS;

435: END IF;
436:
437:
438: -- Initialize API return status to SUCCESS
439: x_return_status := FND_API.G_RET_STS_SUCCESS;
440:
441: --
442: -- API body
443: --

Line 446: p_init_msg_list => FND_API.G_FALSE,

442: -- API body
443: --
444: AMS_DM_Model_PVT.Delete_DM_Model(
445: p_api_version_number => 1.0,
446: p_init_msg_list => FND_API.G_FALSE,
447: p_commit => p_commit,
448: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
449: x_return_status => x_return_status,
450: x_msg_count => x_msg_count,

Line 448: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

444: AMS_DM_Model_PVT.Delete_DM_Model(
445: p_api_version_number => 1.0,
446: p_init_msg_list => FND_API.G_FALSE,
447: p_commit => p_commit,
448: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
449: x_return_status => x_return_status,
450: x_msg_count => x_msg_count,
451: x_msg_data => x_msg_data,
452: p_model_id => l_model_id,

Line 457: IF x_return_status = FND_API.G_RET_STS_ERROR then

453: p_object_version_number => l_object_version_number );
454:
455:
456: -- Check return status from the above procedure call
457: IF x_return_status = FND_API.G_RET_STS_ERROR then
458: RAISE FND_API.G_EXC_ERROR;
459: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: END IF;

Line 458: RAISE FND_API.G_EXC_ERROR;

454:
455:
456: -- Check return status from the above procedure call
457: IF x_return_status = FND_API.G_RET_STS_ERROR then
458: RAISE FND_API.G_EXC_ERROR;
459: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: END IF;
462: --

Line 459: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

455:
456: -- Check return status from the above procedure call
457: IF x_return_status = FND_API.G_RET_STS_ERROR then
458: RAISE FND_API.G_EXC_ERROR;
459: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: END IF;
462: --
463: -- End of API body

Line 460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

456: -- Check return status from the above procedure call
457: IF x_return_status = FND_API.G_RET_STS_ERROR then
458: RAISE FND_API.G_EXC_ERROR;
459: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: END IF;
462: --
463: -- End of API body
464: --

Line 467: IF FND_API.to_Boolean( p_commit )

463: -- End of API body
464: --
465:
466: -- Standard check for p_commit
467: IF FND_API.to_Boolean( p_commit )
468: THEN
469: COMMIT WORK;
470: END IF;
471:

Line 487: x_return_status := FND_API.g_ret_sts_error;

483: );
484: EXCEPTION
485:
486: WHEN AMS_Utility_PVT.resource_locked THEN
487: x_return_status := FND_API.g_ret_sts_error;
488: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
489: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
490: FND_MSG_PUB.add;
491: END IF;

Line 493: WHEN FND_API.G_EXC_ERROR THEN

489: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
490: FND_MSG_PUB.add;
491: END IF;
492:
493: WHEN FND_API.G_EXC_ERROR THEN
494: ROLLBACK TO Delete_Model_PUB;
495: x_return_status := FND_API.G_RET_STS_ERROR;
496: -- Standard call to get message count and if count=1, get the message
497: FND_MSG_PUB.Count_And_Get (

Line 495: x_return_status := FND_API.G_RET_STS_ERROR;

491: END IF;
492:
493: WHEN FND_API.G_EXC_ERROR THEN
494: ROLLBACK TO Delete_Model_PUB;
495: x_return_status := FND_API.G_RET_STS_ERROR;
496: -- Standard call to get message count and if count=1, get the message
497: FND_MSG_PUB.Count_And_Get (
498: p_encoded => FND_API.G_FALSE,
499: p_count => x_msg_count,

Line 498: p_encoded => FND_API.G_FALSE,

494: ROLLBACK TO Delete_Model_PUB;
495: x_return_status := FND_API.G_RET_STS_ERROR;
496: -- Standard call to get message count and if count=1, get the message
497: FND_MSG_PUB.Count_And_Get (
498: p_encoded => FND_API.G_FALSE,
499: p_count => x_msg_count,
500: p_data => x_msg_data
501: );
502:

Line 503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

499: p_count => x_msg_count,
500: p_data => x_msg_data
501: );
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: ROLLBACK TO Delete_Model_PUB;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: -- Standard call to get message count and if count=1, get the message
507: FND_MSG_PUB.Count_And_Get (

Line 505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

501: );
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: ROLLBACK TO Delete_Model_PUB;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: -- Standard call to get message count and if count=1, get the message
507: FND_MSG_PUB.Count_And_Get (
508: p_encoded => FND_API.G_FALSE,
509: p_count => x_msg_count,

Line 508: p_encoded => FND_API.G_FALSE,

504: ROLLBACK TO Delete_Model_PUB;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: -- Standard call to get message count and if count=1, get the message
507: FND_MSG_PUB.Count_And_Get (
508: p_encoded => FND_API.G_FALSE,
509: p_count => x_msg_count,
510: p_data => x_msg_data
511: );
512:

Line 515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

511: );
512:
513: WHEN OTHERS THEN
514: ROLLBACK TO Delete_Model_PUB;
515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
516: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
517: THEN
518: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
519: END IF;

Line 522: p_encoded => FND_API.G_FALSE,

518: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
519: END IF;
520: -- Standard call to get message count and if count=1, get the message
521: FND_MSG_PUB.Count_And_Get (
522: p_encoded => FND_API.G_FALSE,
523: p_count => x_msg_count,
524: p_data => x_msg_data
525: );
526: End Delete_Model;

Line 531: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

527:
528:
529: PROCEDURE Lock_Model(
530: p_api_version_number IN NUMBER,
531: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
532: x_return_status OUT NOCOPY VARCHAR2,
533: x_msg_count OUT NOCOPY NUMBER,
534: x_msg_data OUT NOCOPY VARCHAR2,
535:

Line 547: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

543: l_pvt_model_rec AMS_DM_Model_PVT.dm_model_rec_type;
544: BEGIN
545:
546: -- Standard call to check for call compatibility.
547: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
548: p_api_version_number,
549: l_api_name,
550: G_PKG_NAME)
551: THEN

Line 552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

548: p_api_version_number,
549: l_api_name,
550: G_PKG_NAME)
551: THEN
552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
553: END IF;
554:
555: -- Initialize message list if p_init_msg_list is set to TRUE.
556: IF FND_API.to_Boolean( p_init_msg_list )

Line 556: IF FND_API.to_Boolean( p_init_msg_list )

552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
553: END IF;
554:
555: -- Initialize message list if p_init_msg_list is set to TRUE.
556: IF FND_API.to_Boolean( p_init_msg_list )
557: THEN
558: FND_MSG_PUB.initialize;
559: END IF;
560:

Line 569: x_return_status := FND_API.G_RET_STS_SUCCESS;

565: END IF;
566:
567:
568: -- Initialize API return status to SUCCESS
569: x_return_status := FND_API.G_RET_STS_SUCCESS;
570:
571: --
572: -- API body
573: --

Line 578: p_init_msg_list => FND_API.G_FALSE,

574: -- Calling Private package: Create_Model
575: -- Hint: Primary key needs to be returned
576: AMS_DM_Model_PVT.Lock_DM_Model(
577: p_api_version_number => 1.0,
578: p_init_msg_list => FND_API.G_FALSE,
579: x_return_status => x_return_status,
580: x_msg_count => x_msg_count,
581: x_msg_data => x_msg_data,
582: p_model_id => p_model_id,

Line 587: IF x_return_status = FND_API.G_RET_STS_ERROR then

583: p_object_version => p_object_version);
584:
585:
586: -- Check return status from the above procedure call
587: IF x_return_status = FND_API.G_RET_STS_ERROR then
588: RAISE FND_API.G_EXC_ERROR;
589: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
591: END IF;

Line 588: RAISE FND_API.G_EXC_ERROR;

584:
585:
586: -- Check return status from the above procedure call
587: IF x_return_status = FND_API.G_RET_STS_ERROR then
588: RAISE FND_API.G_EXC_ERROR;
589: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
591: END IF;
592: --

Line 589: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

585:
586: -- Check return status from the above procedure call
587: IF x_return_status = FND_API.G_RET_STS_ERROR then
588: RAISE FND_API.G_EXC_ERROR;
589: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
591: END IF;
592: --
593: -- End of API body.

Line 590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

586: -- Check return status from the above procedure call
587: IF x_return_status = FND_API.G_RET_STS_ERROR then
588: RAISE FND_API.G_EXC_ERROR;
589: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
591: END IF;
592: --
593: -- End of API body.
594: --

Line 605: x_return_status := FND_API.g_ret_sts_error;

601:
602: EXCEPTION
603:
604: WHEN AMS_Utility_PVT.resource_locked THEN
605: x_return_status := FND_API.g_ret_sts_error;
606: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
607: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
608: FND_MSG_PUB.add;
609: END IF;

Line 611: WHEN FND_API.G_EXC_ERROR THEN

607: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
608: FND_MSG_PUB.add;
609: END IF;
610:
611: WHEN FND_API.G_EXC_ERROR THEN
612: ROLLBACK TO Lock_Model_PUB;
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: -- Standard call to get message count and if count=1, get the message
615: FND_MSG_PUB.Count_And_Get (

Line 613: x_return_status := FND_API.G_RET_STS_ERROR;

609: END IF;
610:
611: WHEN FND_API.G_EXC_ERROR THEN
612: ROLLBACK TO Lock_Model_PUB;
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: -- Standard call to get message count and if count=1, get the message
615: FND_MSG_PUB.Count_And_Get (
616: p_encoded => FND_API.G_FALSE,
617: p_count => x_msg_count,

Line 616: p_encoded => FND_API.G_FALSE,

612: ROLLBACK TO Lock_Model_PUB;
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: -- Standard call to get message count and if count=1, get the message
615: FND_MSG_PUB.Count_And_Get (
616: p_encoded => FND_API.G_FALSE,
617: p_count => x_msg_count,
618: p_data => x_msg_data
619: );
620:

Line 621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

617: p_count => x_msg_count,
618: p_data => x_msg_data
619: );
620:
621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
622: ROLLBACK TO Lock_Model_PUB;
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: -- Standard call to get message count and if count=1, get the message
625: FND_MSG_PUB.Count_And_Get (

Line 623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

619: );
620:
621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
622: ROLLBACK TO Lock_Model_PUB;
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: -- Standard call to get message count and if count=1, get the message
625: FND_MSG_PUB.Count_And_Get (
626: p_encoded => FND_API.G_FALSE,
627: p_count => x_msg_count,

Line 626: p_encoded => FND_API.G_FALSE,

622: ROLLBACK TO Lock_Model_PUB;
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: -- Standard call to get message count and if count=1, get the message
625: FND_MSG_PUB.Count_And_Get (
626: p_encoded => FND_API.G_FALSE,
627: p_count => x_msg_count,
628: p_data => x_msg_data
629: );
630:

Line 633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

629: );
630:
631: WHEN OTHERS THEN
632: ROLLBACK TO Lock_Model_PUB;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
635: THEN
636: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
637: END IF;

Line 640: p_encoded => FND_API.G_FALSE,

636: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
637: END IF;
638: -- Standard call to get message count and if count=1, get the message
639: FND_MSG_PUB.Count_And_Get (
640: p_encoded => FND_API.G_FALSE,
641: p_count => x_msg_count,
642: p_data => x_msg_data
643: );
644: End Lock_Model;

Line 700: x_return_status := FND_API.g_ret_sts_success;

696: WHERE model_id = p_model_id)
697: ;
698: BEGIN
699: -- Initialize return status
700: x_return_status := FND_API.g_ret_sts_success;
701:
702: -- Initialize message buffer
703: FND_MSG_PUB.initialize;
704:

Line 749: p_init_msg_list => FND_API.G_FALSE,

745:
746: -- validate input
747: AMS_DM_Model_PVT.Validate_dm_model(
748: p_api_version_number => 1.0,
749: p_init_msg_list => FND_API.G_FALSE,
750: p_validation_mode => JTF_PLSQL_API.g_create,
751: p_dm_model_rec => l_model_rec,
752: x_return_status => x_return_status,
753: x_msg_count => l_msg_count,

Line 756: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

752: x_return_status => x_return_status,
753: x_msg_count => l_msg_count,
754: x_msg_data => l_msg_data
755: );
756: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
757: RAISE FND_API.G_EXC_ERROR;
758: END IF;
759:
760: -- call the table handler

Line 757: RAISE FND_API.G_EXC_ERROR;

753: x_msg_count => l_msg_count,
754: x_msg_data => l_msg_data
755: );
756: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
757: RAISE FND_API.G_EXC_ERROR;
758: END IF;
759:
760: -- call the table handler
761: --AMS_dm_models_b_pkg.insert_row (

Line 820: WHEN FND_API.G_EXC_ERROR THEN

816:
817: x_model_id := l_model_rec.model_id;
818:
819: EXCEPTION
820: WHEN FND_API.G_EXC_ERROR THEN
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: WHEN OTHERS THEN

Line 821: x_return_status := FND_API.G_RET_STS_ERROR;

817: x_model_id := l_model_rec.model_id;
818:
819: EXCEPTION
820: WHEN FND_API.G_EXC_ERROR THEN
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: WHEN OTHERS THEN
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

818:
819: EXCEPTION
820: WHEN FND_API.G_EXC_ERROR THEN
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: WHEN OTHERS THEN
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
826: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

819: EXCEPTION
820: WHEN FND_API.G_EXC_ERROR THEN
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: WHEN OTHERS THEN
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
826: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
827: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

821: x_return_status := FND_API.G_RET_STS_ERROR;
822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: WHEN OTHERS THEN
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
826: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
827: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
828: END IF;
829: END Create_Model;