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_DM_IMP_ATTRIBUTE_PVT dependencies on FND_API

Line 50: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

46: -- Parameters
47: --
48: -- IN
49: -- p_api_version_number IN NUMBER Required
50: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
51: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
52: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
53: -- p_imp_attribute_rec IN imp_attribute_rec_type Required
54: --

Line 51: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

47: --
48: -- IN
49: -- p_api_version_number IN NUMBER Required
50: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
51: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
52: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
53: -- p_imp_attribute_rec IN imp_attribute_rec_type Required
54: --
55: -- OUT

Line 52: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

48: -- IN
49: -- p_api_version_number IN NUMBER Required
50: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
51: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
52: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
53: -- p_imp_attribute_rec IN imp_attribute_rec_type Required
54: --
55: -- OUT
56: -- x_return_status OUT VARCHAR2

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

68: -- ==============================================================================
69:
70: PROCEDURE Create_Imp_Attribute(
71: p_api_version_number IN NUMBER,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75:
76: x_return_status OUT NOCOPY VARCHAR2,

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

69:
70: PROCEDURE Create_Imp_Attribute(
71: p_api_version_number IN NUMBER,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75:
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,

Line 74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

70: PROCEDURE Create_Imp_Attribute(
71: p_api_version_number IN NUMBER,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75:
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_data OUT NOCOPY VARCHAR2,

Line 88: l_org_id NUMBER := FND_API.G_MISS_NUM;

84: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Imp_Attribute';
85: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
86: l_return_status_full VARCHAR2(1);
87: l_object_version_number NUMBER := 1;
88: l_org_id NUMBER := FND_API.G_MISS_NUM;
89: l_Dm_Imp_Attribute_id NUMBER;
90: l_dummy NUMBER;
91: l_imp_attribute_rec imp_attribute_rec_type;
92: BEGIN

Line 97: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

93: -- Standard Start of API savepoint
94: SAVEPOINT create_Dm_Imp_Attribute_pvt;
95:
96: -- Standard call to check for call compatibility.
97: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
98: p_api_version_number,
99: l_api_name,
100: G_PKG_NAME)
101: THEN

Line 102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

98: p_api_version_number,
99: l_api_name,
100: G_PKG_NAME)
101: THEN
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END IF;
104:
105: -- Initialize message list if p_init_msg_list is set to TRUE.
106: IF FND_API.to_Boolean( p_init_msg_list )

Line 106: IF FND_API.to_Boolean( p_init_msg_list )

102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END IF;
104:
105: -- Initialize message list if p_init_msg_list is set to TRUE.
106: IF FND_API.to_Boolean( p_init_msg_list )
107: THEN
108: FND_MSG_PUB.initialize;
109: END IF;
110:

Line 118: x_return_status := FND_API.G_RET_STS_SUCCESS;

114: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
115: END IF;
116:
117: -- Initialize API return status to SUCCESS
118: x_return_status := FND_API.G_RET_STS_SUCCESS;
119:
120: -- Local variable initialization
121: Default_Imp_Attribute_Items (
122: p_imp_attribute_rec => p_imp_attribute_rec,

Line 132: RAISE FND_API.G_EXC_ERROR;

128: -- =========================================================================
129:
130: IF FND_GLOBAL.USER_ID IS NULL THEN
131: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
136: -- Debug message

Line 135: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

131: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
136: -- Debug message
137: IF (AMS_DEBUG_HIGH_ON) THEN
138:
139: AMS_UTILITY_PVT.debug_message('Private API: Validate_Imp_Attribute');

Line 145: p_init_msg_list => FND_API.G_FALSE,

141:
142: -- Invoke validation procedures
143: Validate_imp_attribute(
144: p_api_version_number => 1.0,
145: p_init_msg_list => FND_API.G_FALSE,
146: p_validation_level => p_validation_level,
147: p_validation_mode => JTF_PLSQL_API.g_create,
148: p_imp_attribute_rec => l_imp_attribute_rec,
149: x_return_status => x_return_status,

Line 152: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

148: p_imp_attribute_rec => l_imp_attribute_rec,
149: x_return_status => x_return_status,
150: x_msg_count => x_msg_count,
151: x_msg_data => x_msg_data);
152: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
153: RAISE FND_API.G_EXC_ERROR;
154: END IF;
155: END IF;
156:

Line 153: RAISE FND_API.G_EXC_ERROR;

149: x_return_status => x_return_status,
150: x_msg_count => x_msg_count,
151: x_msg_data => x_msg_data);
152: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
153: RAISE FND_API.G_EXC_ERROR;
154: END IF;
155: END IF;
156:
157: -- Debug Message

Line 177: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

173: p_source_field_id => l_imp_attribute_rec.source_field_id,
174: p_rank => l_imp_attribute_rec.rank,
175: p_value => l_imp_attribute_rec.value
176: );
177: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180: --
181: -- End of API body

Line 178: RAISE FND_API.G_EXC_ERROR;

174: p_rank => l_imp_attribute_rec.rank,
175: p_value => l_imp_attribute_rec.value
176: );
177: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180: --
181: -- End of API body
182: --

Line 187: IF FND_API.to_Boolean( p_commit )

183:
184: x_Dm_Imp_Attribute_id := l_imp_attribute_rec.imp_attribute_id;
185:
186: -- Standard check for p_commit
187: IF FND_API.to_Boolean( p_commit )
188: THEN
189: COMMIT WORK;
190: END IF;
191:

Line 206: x_return_status := FND_API.g_ret_sts_error;

202: );
203: EXCEPTION
204:
205: WHEN AMS_Utility_PVT.resource_locked THEN
206: x_return_status := FND_API.g_ret_sts_error;
207: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
208:
209: WHEN FND_API.G_EXC_ERROR THEN
210: ROLLBACK TO CREATE_Dm_Imp_Attribute_PVT;

Line 209: WHEN FND_API.G_EXC_ERROR THEN

205: WHEN AMS_Utility_PVT.resource_locked THEN
206: x_return_status := FND_API.g_ret_sts_error;
207: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
208:
209: WHEN FND_API.G_EXC_ERROR THEN
210: ROLLBACK TO CREATE_Dm_Imp_Attribute_PVT;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: -- Standard call to get message count and if count=1, get the message
213: FND_MSG_PUB.Count_And_Get (

Line 211: x_return_status := FND_API.G_RET_STS_ERROR;

207: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
208:
209: WHEN FND_API.G_EXC_ERROR THEN
210: ROLLBACK TO CREATE_Dm_Imp_Attribute_PVT;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: -- Standard call to get message count and if count=1, get the message
213: FND_MSG_PUB.Count_And_Get (
214: p_encoded => FND_API.G_FALSE,
215: p_count => x_msg_count,

Line 214: p_encoded => FND_API.G_FALSE,

210: ROLLBACK TO CREATE_Dm_Imp_Attribute_PVT;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: -- Standard call to get message count and if count=1, get the message
213: FND_MSG_PUB.Count_And_Get (
214: p_encoded => FND_API.G_FALSE,
215: p_count => x_msg_count,
216: p_data => x_msg_data
217: );
218:

Line 219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

215: p_count => x_msg_count,
216: p_data => x_msg_data
217: );
218:
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: ROLLBACK TO CREATE_Dm_Imp_Attribute_PVT;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: -- Standard call to get message count and if count=1, get the message
223: FND_MSG_PUB.Count_And_Get (

Line 221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

217: );
218:
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: ROLLBACK TO CREATE_Dm_Imp_Attribute_PVT;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: -- Standard call to get message count and if count=1, get the message
223: FND_MSG_PUB.Count_And_Get (
224: p_encoded => FND_API.G_FALSE,
225: p_count => x_msg_count,

Line 224: p_encoded => FND_API.G_FALSE,

220: ROLLBACK TO CREATE_Dm_Imp_Attribute_PVT;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: -- Standard call to get message count and if count=1, get the message
223: FND_MSG_PUB.Count_And_Get (
224: p_encoded => FND_API.G_FALSE,
225: p_count => x_msg_count,
226: p_data => x_msg_data
227: );
228:

Line 231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

227: );
228:
229: WHEN OTHERS THEN
230: ROLLBACK TO CREATE_Dm_Imp_Attribute_PVT;
231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
232: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
233: THEN
234: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
235: END IF;

Line 238: p_encoded => FND_API.G_FALSE,

234: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
235: END IF;
236: -- Standard call to get message count and if count=1, get the message
237: FND_MSG_PUB.Count_And_Get (
238: p_encoded => FND_API.G_FALSE,
239: p_count => x_msg_count,
240: p_data => x_msg_data
241: );
242: End Create_Imp_Attribute;

Line 258: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

254: -- Parameters
255: --
256: -- IN
257: -- p_api_version_number IN NUMBER Required
258: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
259: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
260: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
261: -- p_imp_attribute_rec IN imp_attribute_rec_type Required
262: --

Line 259: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

255: --
256: -- IN
257: -- p_api_version_number IN NUMBER Required
258: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
259: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
260: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
261: -- p_imp_attribute_rec IN imp_attribute_rec_type Required
262: --
263: -- OUT

Line 260: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

256: -- IN
257: -- p_api_version_number IN NUMBER Required
258: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
259: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
260: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
261: -- p_imp_attribute_rec IN imp_attribute_rec_type Required
262: --
263: -- OUT
264: -- x_return_status OUT VARCHAR2

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

276: -- ==============================================================================
277:
278: PROCEDURE Update_Imp_Attribute(
279: p_api_version_number IN NUMBER,
280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
281: p_commit IN VARCHAR2 := FND_API.G_FALSE,
282: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
283:
284: x_return_status OUT NOCOPY VARCHAR2,

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

277:
278: PROCEDURE Update_Imp_Attribute(
279: p_api_version_number IN NUMBER,
280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
281: p_commit IN VARCHAR2 := FND_API.G_FALSE,
282: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
283:
284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,

Line 282: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

278: PROCEDURE Update_Imp_Attribute(
279: p_api_version_number IN NUMBER,
280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
281: p_commit IN VARCHAR2 := FND_API.G_FALSE,
282: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
283:
284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,
286: x_msg_data OUT NOCOPY VARCHAR2,

Line 312: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

308: -- Standard Start of API savepoint
309: SAVEPOINT update_Dm_Imp_Attribute_pvt;
310:
311: -- Standard call to check for call compatibility.
312: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
313: p_api_version_number,
314: l_api_name,
315: G_PKG_NAME)
316: THEN

Line 317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

313: p_api_version_number,
314: l_api_name,
315: G_PKG_NAME)
316: THEN
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: END IF;
319:
320:
321: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 322: IF FND_API.to_Boolean( p_init_msg_list ) THEN

318: END IF;
319:
320:
321: -- Initialize message list if p_init_msg_list is set to TRUE.
322: IF FND_API.to_Boolean( p_init_msg_list ) THEN
323: FND_MSG_PUB.initialize;
324: END IF;
325:
326: -- Debug Message

Line 333: x_return_status := FND_API.G_RET_STS_SUCCESS;

329: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
330: END IF;
331:
332: -- Initialize API return status to SUCCESS
333: x_return_status := FND_API.G_RET_STS_SUCCESS;
334:
335: -- Debug Message
336: IF (AMS_DEBUG_HIGH_ON) THEN
337:

Line 347: RAISE FND_API.G_EXC_ERROR;

343: If ( c_get_Imp_Attribute%NOTFOUND) THEN
344: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
345: p_token_name => 'INFO',
346: p_token_value => 'Imp_Attribute') ;
347: RAISE FND_API.G_EXC_ERROR;
348: END IF;
349: -- Debug Message
350: IF (AMS_DEBUG_HIGH_ON) THEN
351:

Line 358: l_tar_imp_attribute_rec.object_version_number = FND_API.G_MISS_NUM ) Then

354: CLOSE c_get_Imp_Attribute;
355:
356:
357: If (l_tar_imp_attribute_rec.object_version_number is NULL or
358: l_tar_imp_attribute_rec.object_version_number = FND_API.G_MISS_NUM ) Then
359: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
360: p_token_name => 'COLUMN',
361: p_token_value => 'Last_Update_Date') ;
362: RAISE FND_API.G_EXC_ERROR;

Line 362: RAISE FND_API.G_EXC_ERROR;

358: l_tar_imp_attribute_rec.object_version_number = FND_API.G_MISS_NUM ) Then
359: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
360: p_token_name => 'COLUMN',
361: p_token_value => 'Last_Update_Date') ;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364: -- Check Whether record has been changed by someone else
365: If (l_tar_imp_attribute_rec.object_version_number <> l_ref_imp_attribute_rec.object_version_number) Then
366: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

Line 369: RAISE FND_API.G_EXC_ERROR;

365: If (l_tar_imp_attribute_rec.object_version_number <> l_ref_imp_attribute_rec.object_version_number) Then
366: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
367: p_token_name => 'INFO',
368: p_token_value => 'Imp_Attribute') ;
369: RAISE FND_API.G_EXC_ERROR;
370: END IF;
371:
372: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
373: -- Debug message

Line 372: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

368: p_token_value => 'Imp_Attribute') ;
369: RAISE FND_API.G_EXC_ERROR;
370: END IF;
371:
372: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
373: -- Debug message
374: IF (AMS_DEBUG_HIGH_ON) THEN
375:
376: AMS_UTILITY_PVT.debug_message('Private API: Validate_Imp_Attribute');

Line 382: p_init_msg_list => FND_API.G_FALSE,

378:
379: -- Invoke validation procedures
380: Validate_imp_attribute(
381: p_api_version_number => 1.0,
382: p_init_msg_list => FND_API.G_FALSE,
383: p_validation_level => p_validation_level,
384: p_validation_mode => JTF_PLSQL_API.g_update,
385: p_imp_attribute_rec => p_imp_attribute_rec,
386: x_return_status => x_return_status,

Line 390: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

386: x_return_status => x_return_status,
387: x_msg_count => x_msg_count,
388: x_msg_data => x_msg_data);
389: END IF;
390: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: -- Debug Message

Line 391: RAISE FND_API.G_EXC_ERROR;

387: x_msg_count => x_msg_count,
388: x_msg_data => x_msg_data);
389: END IF;
390: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: -- Debug Message
395: IF (AMS_DEBUG_HIGH_ON) THEN

Line 419: IF FND_API.to_Boolean( p_commit )

415:
416: x_object_version_number := l_object_version_number;
417:
418: -- Standard check for p_commit
419: IF FND_API.to_Boolean( p_commit )
420: THEN
421: COMMIT WORK;
422: END IF;
423:

Line 438: x_return_status := FND_API.g_ret_sts_error;

434: );
435: EXCEPTION
436:
437: WHEN AMS_Utility_PVT.resource_locked THEN
438: x_return_status := FND_API.g_ret_sts_error;
439: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
440:
441: WHEN FND_API.G_EXC_ERROR THEN
442: ROLLBACK TO UPDATE_Dm_Imp_Attribute_PVT;

Line 441: WHEN FND_API.G_EXC_ERROR THEN

437: WHEN AMS_Utility_PVT.resource_locked THEN
438: x_return_status := FND_API.g_ret_sts_error;
439: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
440:
441: WHEN FND_API.G_EXC_ERROR THEN
442: ROLLBACK TO UPDATE_Dm_Imp_Attribute_PVT;
443: x_return_status := FND_API.G_RET_STS_ERROR;
444: -- Standard call to get message count and if count=1, get the message
445: FND_MSG_PUB.Count_And_Get (

Line 443: x_return_status := FND_API.G_RET_STS_ERROR;

439: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
440:
441: WHEN FND_API.G_EXC_ERROR THEN
442: ROLLBACK TO UPDATE_Dm_Imp_Attribute_PVT;
443: x_return_status := FND_API.G_RET_STS_ERROR;
444: -- Standard call to get message count and if count=1, get the message
445: FND_MSG_PUB.Count_And_Get (
446: p_encoded => FND_API.G_FALSE,
447: p_count => x_msg_count,

Line 446: p_encoded => FND_API.G_FALSE,

442: ROLLBACK TO UPDATE_Dm_Imp_Attribute_PVT;
443: x_return_status := FND_API.G_RET_STS_ERROR;
444: -- Standard call to get message count and if count=1, get the message
445: FND_MSG_PUB.Count_And_Get (
446: p_encoded => FND_API.G_FALSE,
447: p_count => x_msg_count,
448: p_data => x_msg_data
449: );
450:

Line 451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

447: p_count => x_msg_count,
448: p_data => x_msg_data
449: );
450:
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: ROLLBACK TO UPDATE_Dm_Imp_Attribute_PVT;
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454: -- Standard call to get message count and if count=1, get the message
455: FND_MSG_PUB.Count_And_Get (

Line 453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

449: );
450:
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: ROLLBACK TO UPDATE_Dm_Imp_Attribute_PVT;
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454: -- Standard call to get message count and if count=1, get the message
455: FND_MSG_PUB.Count_And_Get (
456: p_encoded => FND_API.G_FALSE,
457: p_count => x_msg_count,

Line 456: p_encoded => FND_API.G_FALSE,

452: ROLLBACK TO UPDATE_Dm_Imp_Attribute_PVT;
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454: -- Standard call to get message count and if count=1, get the message
455: FND_MSG_PUB.Count_And_Get (
456: p_encoded => FND_API.G_FALSE,
457: p_count => x_msg_count,
458: p_data => x_msg_data
459: );
460:

Line 463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

459: );
460:
461: WHEN OTHERS THEN
462: ROLLBACK TO UPDATE_Dm_Imp_Attribute_PVT;
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
465: THEN
466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
467: END IF;

Line 470: p_encoded => FND_API.G_FALSE,

466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
467: END IF;
468: -- Standard call to get message count and if count=1, get the message
469: FND_MSG_PUB.Count_And_Get (
470: p_encoded => FND_API.G_FALSE,
471: p_count => x_msg_count,
472: p_data => x_msg_data
473: );
474: End Update_Imp_Attribute;

Line 490: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

486: -- Parameters
487: --
488: -- IN
489: -- p_api_version_number IN NUMBER Required
490: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
491: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
492: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
493: -- p_Dm_Imp_Attribute_id IN NUMBER
494: -- p_object_version_number IN NUMBER Optional Default = NULL

Line 491: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

487: --
488: -- IN
489: -- p_api_version_number IN NUMBER Required
490: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
491: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
492: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
493: -- p_Dm_Imp_Attribute_id IN NUMBER
494: -- p_object_version_number IN NUMBER Optional Default = NULL
495: --

Line 492: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

488: -- IN
489: -- p_api_version_number IN NUMBER Required
490: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
491: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
492: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
493: -- p_Dm_Imp_Attribute_id IN NUMBER
494: -- p_object_version_number IN NUMBER Optional Default = NULL
495: --
496: -- OUT

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

509: -- ==============================================================================
510:
511: PROCEDURE Delete_Imp_Attribute(
512: p_api_version_number IN NUMBER,
513: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
514: p_commit IN VARCHAR2 := FND_API.G_FALSE,
515: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
516: x_return_status OUT NOCOPY VARCHAR2,
517: x_msg_count OUT NOCOPY NUMBER,

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

510:
511: PROCEDURE Delete_Imp_Attribute(
512: p_api_version_number IN NUMBER,
513: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
514: p_commit IN VARCHAR2 := FND_API.G_FALSE,
515: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
516: x_return_status OUT NOCOPY VARCHAR2,
517: x_msg_count OUT NOCOPY NUMBER,
518: x_msg_data OUT NOCOPY VARCHAR2,

Line 515: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

511: PROCEDURE Delete_Imp_Attribute(
512: p_api_version_number IN NUMBER,
513: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
514: p_commit IN VARCHAR2 := FND_API.G_FALSE,
515: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
516: x_return_status OUT NOCOPY VARCHAR2,
517: x_msg_count OUT NOCOPY NUMBER,
518: x_msg_data OUT NOCOPY VARCHAR2,
519: p_Dm_Imp_Attribute_id IN NUMBER,

Line 531: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

527: -- Standard Start of API savepoint
528: SAVEPOINT delete_Dm_Imp_Attribute_pvt;
529:
530: -- Standard call to check for call compatibility.
531: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
532: p_api_version_number,
533: l_api_name,
534: G_PKG_NAME)
535: THEN

Line 536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

532: p_api_version_number,
533: l_api_name,
534: G_PKG_NAME)
535: THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: END IF;
538:
539:
540: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 541: IF FND_API.to_Boolean( p_init_msg_list )

537: END IF;
538:
539:
540: -- Initialize message list if p_init_msg_list is set to TRUE.
541: IF FND_API.to_Boolean( p_init_msg_list )
542: THEN
543: FND_MSG_PUB.initialize;
544: END IF;
545:

Line 557: x_return_status := FND_API.G_RET_STS_SUCCESS;

553:
554:
555:
556: -- Initialize API return status to SUCCESS
557: x_return_status := FND_API.G_RET_STS_SUCCESS;
558:
559: --
560: -- Api body
561: --

Line 577: IF FND_API.to_Boolean( p_commit )

573: -- End of API body
574: --
575:
576: -- Standard check for p_commit
577: IF FND_API.to_Boolean( p_commit )
578: THEN
579: COMMIT WORK;
580: END IF;
581:

Line 598: x_return_status := FND_API.g_ret_sts_error;

594: );
595: EXCEPTION
596:
597: WHEN AMS_Utility_PVT.resource_locked THEN
598: x_return_status := FND_API.g_ret_sts_error;
599: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
600:
601: WHEN FND_API.G_EXC_ERROR THEN
602: ROLLBACK TO DELETE_Dm_Imp_Attribute_PVT;

Line 601: WHEN FND_API.G_EXC_ERROR THEN

597: WHEN AMS_Utility_PVT.resource_locked THEN
598: x_return_status := FND_API.g_ret_sts_error;
599: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
600:
601: WHEN FND_API.G_EXC_ERROR THEN
602: ROLLBACK TO DELETE_Dm_Imp_Attribute_PVT;
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: -- Standard call to get message count and if count=1, get the message
605: FND_MSG_PUB.Count_And_Get (

Line 603: x_return_status := FND_API.G_RET_STS_ERROR;

599: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
600:
601: WHEN FND_API.G_EXC_ERROR THEN
602: ROLLBACK TO DELETE_Dm_Imp_Attribute_PVT;
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: -- Standard call to get message count and if count=1, get the message
605: FND_MSG_PUB.Count_And_Get (
606: p_encoded => FND_API.G_FALSE,
607: p_count => x_msg_count,

Line 606: p_encoded => FND_API.G_FALSE,

602: ROLLBACK TO DELETE_Dm_Imp_Attribute_PVT;
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: -- Standard call to get message count and if count=1, get the message
605: FND_MSG_PUB.Count_And_Get (
606: p_encoded => FND_API.G_FALSE,
607: p_count => x_msg_count,
608: p_data => x_msg_data
609: );
610:

Line 611: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

607: p_count => x_msg_count,
608: p_data => x_msg_data
609: );
610:
611: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
612: ROLLBACK TO DELETE_Dm_Imp_Attribute_PVT;
613: x_return_status := FND_API.G_RET_STS_UNEXP_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_UNEXP_ERROR;

609: );
610:
611: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
612: ROLLBACK TO DELETE_Dm_Imp_Attribute_PVT;
613: x_return_status := FND_API.G_RET_STS_UNEXP_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 DELETE_Dm_Imp_Attribute_PVT;
613: x_return_status := FND_API.G_RET_STS_UNEXP_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 623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

619: );
620:
621: WHEN OTHERS THEN
622: ROLLBACK TO DELETE_Dm_Imp_Attribute_PVT;
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
625: THEN
626: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
627: END IF;

Line 630: p_encoded => FND_API.G_FALSE,

626: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
627: END IF;
628: -- Standard call to get message count and if count=1, get the message
629: FND_MSG_PUB.Count_And_Get (
630: p_encoded => FND_API.G_FALSE,
631: p_count => x_msg_count,
632: p_data => x_msg_data
633: );
634: End Delete_Imp_Attribute;

Line 652: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

648: -- Parameters
649: --
650: -- IN
651: -- p_api_version_number IN NUMBER Required
652: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
653: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
654: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
655: -- p_imp_attribute_rec IN imp_attribute_rec_type Required
656: --

Line 653: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

649: --
650: -- IN
651: -- p_api_version_number IN NUMBER Required
652: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
653: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
654: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
655: -- p_imp_attribute_rec IN imp_attribute_rec_type Required
656: --
657: -- OUT

Line 654: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

650: -- IN
651: -- p_api_version_number IN NUMBER Required
652: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
653: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
654: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
655: -- p_imp_attribute_rec IN imp_attribute_rec_type Required
656: --
657: -- OUT
658: -- x_return_status OUT VARCHAR2

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

670: -- ==============================================================================
671:
672: PROCEDURE Lock_Imp_Attribute(
673: p_api_version_number IN NUMBER,
674: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
675:
676: x_return_status OUT NOCOPY VARCHAR2,
677: x_msg_count OUT NOCOPY NUMBER,
678: x_msg_data OUT NOCOPY VARCHAR2,

Line 704: IF FND_API.to_Boolean( p_init_msg_list )

700: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
701: END IF;
702:
703: -- Initialize message list if p_init_msg_list is set to TRUE.
704: IF FND_API.to_Boolean( p_init_msg_list )
705: THEN
706: FND_MSG_PUB.initialize;
707: END IF;
708:

Line 710: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

706: FND_MSG_PUB.initialize;
707: END IF;
708:
709: -- Standard call to check for call compatibility.
710: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
711: p_api_version_number,
712: l_api_name,
713: G_PKG_NAME)
714: THEN

Line 715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

711: p_api_version_number,
712: l_api_name,
713: G_PKG_NAME)
714: THEN
715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
716: END IF;
717:
718: -- Initialize API return status to SUCCESS
719: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 719: x_return_status := FND_API.G_RET_STS_SUCCESS;

715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
716: END IF;
717:
718: -- Initialize API return status to SUCCESS
719: x_return_status := FND_API.G_RET_STS_SUCCESS;
720:
721: ------------------------ lock -------------------------
722:
723: IF (AMS_DEBUG_HIGH_ON) THEN

Line 735: RAISE FND_API.g_exc_error;

731: FETCH c_imp_attribute INTO l_Dm_Imp_Attribute_id;
732: IF (c_imp_attribute%NOTFOUND) THEN
733: CLOSE c_imp_attribute;
734: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
735: RAISE FND_API.g_exc_error;
736: END IF;
737: CLOSE c_imp_attribute;
738:
739: -------------------- finish --------------------------

Line 741: p_encoded => FND_API.g_false,

737: CLOSE c_imp_attribute;
738:
739: -------------------- finish --------------------------
740: FND_MSG_PUB.count_and_get(
741: p_encoded => FND_API.g_false,
742: p_count => x_msg_count,
743: p_data => x_msg_data);
744: IF (AMS_DEBUG_HIGH_ON) THEN
745:

Line 751: x_return_status := FND_API.g_ret_sts_error;

747: END IF;
748: EXCEPTION
749:
750: WHEN AMS_Utility_PVT.resource_locked THEN
751: x_return_status := FND_API.g_ret_sts_error;
752: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
753:
754: WHEN FND_API.G_EXC_ERROR THEN
755: ROLLBACK TO LOCK_Dm_Imp_Attribute_PVT;

Line 754: WHEN FND_API.G_EXC_ERROR THEN

750: WHEN AMS_Utility_PVT.resource_locked THEN
751: x_return_status := FND_API.g_ret_sts_error;
752: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
753:
754: WHEN FND_API.G_EXC_ERROR THEN
755: ROLLBACK TO LOCK_Dm_Imp_Attribute_PVT;
756: x_return_status := FND_API.G_RET_STS_ERROR;
757: -- Standard call to get message count and if count=1, get the message
758: FND_MSG_PUB.Count_And_Get (

Line 756: x_return_status := FND_API.G_RET_STS_ERROR;

752: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
753:
754: WHEN FND_API.G_EXC_ERROR THEN
755: ROLLBACK TO LOCK_Dm_Imp_Attribute_PVT;
756: x_return_status := FND_API.G_RET_STS_ERROR;
757: -- Standard call to get message count and if count=1, get the message
758: FND_MSG_PUB.Count_And_Get (
759: p_encoded => FND_API.G_FALSE,
760: p_count => x_msg_count,

Line 759: p_encoded => FND_API.G_FALSE,

755: ROLLBACK TO LOCK_Dm_Imp_Attribute_PVT;
756: x_return_status := FND_API.G_RET_STS_ERROR;
757: -- Standard call to get message count and if count=1, get the message
758: FND_MSG_PUB.Count_And_Get (
759: p_encoded => FND_API.G_FALSE,
760: p_count => x_msg_count,
761: p_data => x_msg_data
762: );
763:

Line 764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

760: p_count => x_msg_count,
761: p_data => x_msg_data
762: );
763:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: ROLLBACK TO LOCK_Dm_Imp_Attribute_PVT;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: -- Standard call to get message count and if count=1, get the message
768: FND_MSG_PUB.Count_And_Get (

Line 766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

762: );
763:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: ROLLBACK TO LOCK_Dm_Imp_Attribute_PVT;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: -- Standard call to get message count and if count=1, get the message
768: FND_MSG_PUB.Count_And_Get (
769: p_encoded => FND_API.G_FALSE,
770: p_count => x_msg_count,

Line 769: p_encoded => FND_API.G_FALSE,

765: ROLLBACK TO LOCK_Dm_Imp_Attribute_PVT;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: -- Standard call to get message count and if count=1, get the message
768: FND_MSG_PUB.Count_And_Get (
769: p_encoded => FND_API.G_FALSE,
770: p_count => x_msg_count,
771: p_data => x_msg_data
772: );
773:

Line 776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

772: );
773:
774: WHEN OTHERS THEN
775: ROLLBACK TO LOCK_Dm_Imp_Attribute_PVT;
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
778: THEN
779: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
780: END IF;

Line 783: p_encoded => FND_API.G_FALSE,

779: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
780: END IF;
781: -- Standard call to get message count and if count=1, get the message
782: FND_MSG_PUB.Count_And_Get (
783: p_encoded => FND_API.G_FALSE,
784: p_count => x_msg_count,
785: p_data => x_msg_data
786: );
787: End Lock_Imp_Attribute;

Line 797: x_return_status := FND_API.g_ret_sts_success;

793: x_return_status OUT NOCOPY VARCHAR2)
794: IS
795: l_valid_flag VARCHAR2(1);
796: BEGIN
797: x_return_status := FND_API.g_ret_sts_success;
798:
799: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
800: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
801: 'ams_dm_imp_attributes',

Line 805: IF l_valid_flag = FND_API.g_false THEN

801: 'ams_dm_imp_attributes',
802: 'model_id = ' || p_imp_attribute_rec.model_id ||
803: ' AND source_field_id = ' || p_imp_attribute_rec.source_field_id
804: );
805: IF l_valid_flag = FND_API.g_false THEN
806: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_DM_MODEL_FIELD_DUP');
807: x_return_status := FND_API.g_ret_sts_error;
808: END IF;
809: ELSE

Line 807: x_return_status := FND_API.g_ret_sts_error;

803: ' AND source_field_id = ' || p_imp_attribute_rec.source_field_id
804: );
805: IF l_valid_flag = FND_API.g_false THEN
806: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_DM_MODEL_FIELD_DUP');
807: x_return_status := FND_API.g_ret_sts_error;
808: END IF;
809: ELSE
810: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
811: 'ams_dm_imp_attributes',

Line 815: IF l_valid_flag = FND_API.g_false THEN

811: 'ams_dm_imp_attributes',
812: 'imp_attribute_id = ' || p_imp_attribute_rec.imp_attribute_id ||
813: ' AND imp_attribute_id <> ' || p_imp_attribute_rec.imp_attribute_id
814: );
815: IF l_valid_flag = FND_API.g_false THEN
816: AMS_Utility_PVT.Error_Message('AMS_API_DUPLICATE_ID', 'ID_FIELD','IMP_ATTRIBUTE_ID');
817: x_return_status := FND_API.g_ret_sts_error;
818: END IF;
819: END IF;

Line 817: x_return_status := FND_API.g_ret_sts_error;

813: ' AND imp_attribute_id <> ' || p_imp_attribute_rec.imp_attribute_id
814: );
815: IF l_valid_flag = FND_API.g_false THEN
816: AMS_Utility_PVT.Error_Message('AMS_API_DUPLICATE_ID', 'ID_FIELD','IMP_ATTRIBUTE_ID');
817: x_return_status := FND_API.g_ret_sts_error;
818: END IF;
819: END IF;
820: END check_Imp_Attribute_UK_Items;
821:

Line 830: x_return_status := FND_API.g_ret_sts_success;

826: x_return_status OUT NOCOPY VARCHAR2
827: )
828: IS
829: BEGIN
830: x_return_status := FND_API.g_ret_sts_success;
831:
832: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
833: IF p_imp_attribute_rec.model_id = FND_API.G_MISS_NUM OR p_imp_attribute_rec.model_id IS NULL THEN
834: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MODEL_ID');

Line 833: IF p_imp_attribute_rec.model_id = FND_API.G_MISS_NUM OR p_imp_attribute_rec.model_id IS NULL THEN

829: BEGIN
830: x_return_status := FND_API.g_ret_sts_success;
831:
832: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
833: IF p_imp_attribute_rec.model_id = FND_API.G_MISS_NUM OR p_imp_attribute_rec.model_id IS NULL THEN
834: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MODEL_ID');
835: x_return_status := FND_API.g_ret_sts_error;
836: END IF;
837:

Line 835: x_return_status := FND_API.g_ret_sts_error;

831:
832: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
833: IF p_imp_attribute_rec.model_id = FND_API.G_MISS_NUM OR p_imp_attribute_rec.model_id IS NULL THEN
834: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MODEL_ID');
835: x_return_status := FND_API.g_ret_sts_error;
836: END IF;
837:
838: IF p_imp_attribute_rec.source_field_id = FND_API.G_MISS_NUM OR p_imp_attribute_rec.source_field_id IS NULL THEN
839: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_FIELD_ID');

Line 838: IF p_imp_attribute_rec.source_field_id = FND_API.G_MISS_NUM OR p_imp_attribute_rec.source_field_id IS NULL THEN

834: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MODEL_ID');
835: x_return_status := FND_API.g_ret_sts_error;
836: END IF;
837:
838: IF p_imp_attribute_rec.source_field_id = FND_API.G_MISS_NUM OR p_imp_attribute_rec.source_field_id IS NULL THEN
839: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_FIELD_ID');
840: x_return_status := FND_API.g_ret_sts_error;
841: END IF;
842:

Line 840: x_return_status := FND_API.g_ret_sts_error;

836: END IF;
837:
838: IF p_imp_attribute_rec.source_field_id = FND_API.G_MISS_NUM OR p_imp_attribute_rec.source_field_id IS NULL THEN
839: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_FIELD_ID');
840: x_return_status := FND_API.g_ret_sts_error;
841: END IF;
842:
843: IF p_imp_attribute_rec.value = FND_API.G_MISS_NUM OR p_imp_attribute_rec.value IS NULL THEN
844: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'VALUE');

Line 843: IF p_imp_attribute_rec.value = FND_API.G_MISS_NUM OR p_imp_attribute_rec.value IS NULL THEN

839: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_FIELD_ID');
840: x_return_status := FND_API.g_ret_sts_error;
841: END IF;
842:
843: IF p_imp_attribute_rec.value = FND_API.G_MISS_NUM OR p_imp_attribute_rec.value IS NULL THEN
844: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'VALUE');
845: x_return_status := FND_API.g_ret_sts_error;
846: END IF;
847: ELSE

Line 845: x_return_status := FND_API.g_ret_sts_error;

841: END IF;
842:
843: IF p_imp_attribute_rec.value = FND_API.G_MISS_NUM OR p_imp_attribute_rec.value IS NULL THEN
844: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'VALUE');
845: x_return_status := FND_API.g_ret_sts_error;
846: END IF;
847: ELSE
848: IF p_imp_attribute_rec.model_id = FND_API.G_MISS_NUM THEN
849: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MODEL_ID');

Line 848: IF p_imp_attribute_rec.model_id = FND_API.G_MISS_NUM THEN

844: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'VALUE');
845: x_return_status := FND_API.g_ret_sts_error;
846: END IF;
847: ELSE
848: IF p_imp_attribute_rec.model_id = FND_API.G_MISS_NUM THEN
849: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MODEL_ID');
850: x_return_status := FND_API.g_ret_sts_error;
851: END IF;
852:

Line 850: x_return_status := FND_API.g_ret_sts_error;

846: END IF;
847: ELSE
848: IF p_imp_attribute_rec.model_id = FND_API.G_MISS_NUM THEN
849: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MODEL_ID');
850: x_return_status := FND_API.g_ret_sts_error;
851: END IF;
852:
853: IF p_imp_attribute_rec.source_field_id = FND_API.G_MISS_NUM THEN
854: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_FIELD_ID');

Line 853: IF p_imp_attribute_rec.source_field_id = FND_API.G_MISS_NUM THEN

849: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MODEL_ID');
850: x_return_status := FND_API.g_ret_sts_error;
851: END IF;
852:
853: IF p_imp_attribute_rec.source_field_id = FND_API.G_MISS_NUM THEN
854: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_FIELD_ID');
855: x_return_status := FND_API.g_ret_sts_error;
856: END IF;
857:

Line 855: x_return_status := FND_API.g_ret_sts_error;

851: END IF;
852:
853: IF p_imp_attribute_rec.source_field_id = FND_API.G_MISS_NUM THEN
854: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_FIELD_ID');
855: x_return_status := FND_API.g_ret_sts_error;
856: END IF;
857:
858: IF p_imp_attribute_rec.value = FND_API.G_MISS_NUM THEN
859: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'VALUE');

Line 858: IF p_imp_attribute_rec.value = FND_API.G_MISS_NUM THEN

854: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_FIELD_ID');
855: x_return_status := FND_API.g_ret_sts_error;
856: END IF;
857:
858: IF p_imp_attribute_rec.value = FND_API.G_MISS_NUM THEN
859: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'VALUE');
860: x_return_status := FND_API.g_ret_sts_error;
861: END IF;
862: END IF;

Line 860: x_return_status := FND_API.g_ret_sts_error;

856: END IF;
857:
858: IF p_imp_attribute_rec.value = FND_API.G_MISS_NUM THEN
859: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'VALUE');
860: x_return_status := FND_API.g_ret_sts_error;
861: END IF;
862: END IF;
863: END check_Imp_Attribute_Req_Items;
864:

Line 883: x_return_status := FND_API.g_ret_sts_success;

879: WHERE list_source_field_id = p_source_field_id;
880:
881: l_dummy NUMBER;
882: BEGIN
883: x_return_status := FND_API.g_ret_sts_success;
884:
885: OPEN c_model (p_imp_attribute_rec.model_id);
886: FETCH c_model INTO l_dummy;
887: IF c_model%NOTFOUND THEN

Line 889: x_return_status := FND_API.g_ret_sts_error;

885: OPEN c_model (p_imp_attribute_rec.model_id);
886: FETCH c_model INTO l_dummy;
887: IF c_model%NOTFOUND THEN
888: AMS_Utility_PVT.error_message ('AMS_DM_INVALID_MODEL_REF');
889: x_return_status := FND_API.g_ret_sts_error;
890: END IF;
891: CLOSE c_model;
892:
893: OPEN c_field (p_imp_attribute_rec.source_field_id);

Line 897: x_return_status := FND_API.g_ret_sts_error;

893: OPEN c_field (p_imp_attribute_rec.source_field_id);
894: FETCH c_field INTO l_dummy;
895: IF c_field%NOTFOUND THEN
896: AMS_Utility_PVT.error_message ('AMS_DM_INVALID_SOURCE_FIELD');
897: x_return_status := FND_API.g_ret_sts_error;
898: END IF;
899: CLOSE c_field;
900: END Check_Imp_Attribute_FK_Items;
901:

Line 909: x_return_status := FND_API.g_ret_sts_success;

905: x_return_status OUT NOCOPY VARCHAR2
906: )
907: IS
908: BEGIN
909: x_return_status := FND_API.g_ret_sts_success;
910:
911: -- no lookups for this object
912: END Check_Imp_Attrib_Lookup_Items;
913:

Line 929: l_return_status := FND_API.g_ret_sts_success;

925: )
926: IS
927: l_return_status VARCHAR2(1);
928: BEGIN
929: l_return_status := FND_API.g_ret_sts_success;
930:
931: -- Check Items Uniqueness API calls
932: check_Imp_Attribute_UK_Items(
933: p_imp_attribute_rec => p_imp_attribute_rec,

Line 936: IF x_return_status <> FND_API.g_ret_sts_success THEN

932: check_Imp_Attribute_UK_Items(
933: p_imp_attribute_rec => p_imp_attribute_rec,
934: p_validation_mode => p_validation_mode,
935: x_return_status => x_return_status);
936: IF x_return_status <> FND_API.g_ret_sts_success THEN
937: l_return_status := FND_API.g_ret_sts_error;
938: END IF;
939:
940: -- Check Items Required/NOT NULL API calls

Line 937: l_return_status := FND_API.g_ret_sts_error;

933: p_imp_attribute_rec => p_imp_attribute_rec,
934: p_validation_mode => p_validation_mode,
935: x_return_status => x_return_status);
936: IF x_return_status <> FND_API.g_ret_sts_success THEN
937: l_return_status := FND_API.g_ret_sts_error;
938: END IF;
939:
940: -- Check Items Required/NOT NULL API calls
941:

Line 946: IF x_return_status <> FND_API.g_ret_sts_success THEN

942: check_Imp_Attribute_Req_Items(
943: p_imp_attribute_rec => p_imp_attribute_rec,
944: p_validation_mode => p_validation_mode,
945: x_return_status => x_return_status);
946: IF x_return_status <> FND_API.g_ret_sts_success THEN
947: l_return_status := FND_API.g_ret_sts_error;
948: END IF;
949: -- Check Items Foreign Keys API calls
950:

Line 947: l_return_status := FND_API.g_ret_sts_error;

943: p_imp_attribute_rec => p_imp_attribute_rec,
944: p_validation_mode => p_validation_mode,
945: x_return_status => x_return_status);
946: IF x_return_status <> FND_API.g_ret_sts_success THEN
947: l_return_status := FND_API.g_ret_sts_error;
948: END IF;
949: -- Check Items Foreign Keys API calls
950:
951: Check_Imp_Attribute_FK_Items(

Line 954: IF x_return_status <> FND_API.g_ret_sts_success THEN

950:
951: Check_Imp_Attribute_FK_Items(
952: p_imp_attribute_rec => p_imp_attribute_rec,
953: x_return_status => x_return_status);
954: IF x_return_status <> FND_API.g_ret_sts_success THEN
955: l_return_status := FND_API.g_ret_sts_error;
956: END IF;
957: -- Check Items Lookups
958:

Line 955: l_return_status := FND_API.g_ret_sts_error;

951: Check_Imp_Attribute_FK_Items(
952: p_imp_attribute_rec => p_imp_attribute_rec,
953: x_return_status => x_return_status);
954: IF x_return_status <> FND_API.g_ret_sts_success THEN
955: l_return_status := FND_API.g_ret_sts_error;
956: END IF;
957: -- Check Items Lookups
958:
959: Check_Imp_Attrib_Lookup_Items(

Line 962: IF x_return_status <> FND_API.g_ret_sts_success THEN

958:
959: Check_Imp_Attrib_Lookup_Items(
960: p_imp_attribute_rec => p_imp_attribute_rec,
961: x_return_status => x_return_status);
962: IF x_return_status <> FND_API.g_ret_sts_success THEN
963: l_return_status := FND_API.g_ret_sts_error;
964: END IF;
965:
966: x_return_status := l_return_status;

Line 963: l_return_status := FND_API.g_ret_sts_error;

959: Check_Imp_Attrib_Lookup_Items(
960: p_imp_attribute_rec => p_imp_attribute_rec,
961: x_return_status => x_return_status);
962: IF x_return_status <> FND_API.g_ret_sts_success THEN
963: l_return_status := FND_API.g_ret_sts_error;
964: END IF;
965:
966: x_return_status := l_return_status;
967: END Check_Imp_Attribute_Items;

Line 1086: IF p_imp_attribute_rec.imp_attribute_id IS NULL OR p_imp_attribute_rec.imp_attribute_id = FND_API.g_miss_num THEN

1082: BEGIN
1083: x_imp_attribute_rec := p_imp_attribute_rec;
1084:
1085: -- default imp_attribute_id
1086: IF p_imp_attribute_rec.imp_attribute_id IS NULL OR p_imp_attribute_rec.imp_attribute_id = FND_API.g_miss_num THEN
1087: LOOP
1088: l_dummy := NULL;
1089: OPEN c_id;
1090: FETCH c_id INTO l_dm_imp_attribute_id;

Line 1103: IF p_imp_attribute_rec.source_field_name IS NOT NULL AND p_imp_attribute_rec.source_field_name <> FND_API.g_miss_char THEN

1099: l_dm_imp_attribute_id := p_imp_attribute_rec.imp_attribute_id;
1100: END IF;
1101:
1102: -- look up source_field_id for the source field name
1103: IF p_imp_attribute_rec.source_field_name IS NOT NULL AND p_imp_attribute_rec.source_field_name <> FND_API.g_miss_char THEN
1104:
1105: -- Open the cursor and fetch the source field id into a local variable
1106: OPEN c_lookup_field_id (p_imp_attribute_rec.model_id , p_imp_attribute_rec.source_field_name);
1107: FETCH c_lookup_field_id INTO l_source_field_id;

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

1116:
1117:
1118: PROCEDURE Validate_Imp_Attribute(
1119: p_api_version_number IN NUMBER,
1120: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1122: p_imp_attribute_rec IN imp_attribute_rec_type,
1123: p_validation_mode IN VARCHAR2,
1124: x_return_status OUT NOCOPY VARCHAR2,

Line 1121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1117:
1118: PROCEDURE Validate_Imp_Attribute(
1119: p_api_version_number IN NUMBER,
1120: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1122: p_imp_attribute_rec IN imp_attribute_rec_type,
1123: p_validation_mode IN VARCHAR2,
1124: x_return_status OUT NOCOPY VARCHAR2,
1125: x_msg_count OUT NOCOPY NUMBER,

Line 1138: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1134: -- Standard Start of API savepoint
1135: SAVEPOINT validate_Dm_Imp_Attribute_;
1136:
1137: -- Standard call to check for call compatibility.
1138: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1139: p_api_version_number,
1140: l_api_name,
1141: G_PKG_NAME)
1142: THEN

Line 1143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1139: p_api_version_number,
1140: l_api_name,
1141: G_PKG_NAME)
1142: THEN
1143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1144: END IF;
1145:
1146:
1147: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1148: IF FND_API.to_Boolean( p_init_msg_list )

1144: END IF;
1145:
1146:
1147: -- Initialize message list if p_init_msg_list is set to TRUE.
1148: IF FND_API.to_Boolean( p_init_msg_list )
1149: THEN
1150: FND_MSG_PUB.initialize;
1151: END IF;
1152:

Line 1160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1156: p_imp_attribute_rec => p_imp_attribute_rec,
1157: p_validation_mode => p_validation_mode,
1158: x_return_status => x_return_status
1159: );
1160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1164: END IF;

Line 1161: RAISE FND_API.G_EXC_ERROR;

1157: p_validation_mode => p_validation_mode,
1158: x_return_status => x_return_status
1159: );
1160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1164: END IF;
1165: END IF;

Line 1162: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1158: x_return_status => x_return_status
1159: );
1160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1164: END IF;
1165: END IF;
1166:

Line 1163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1159: );
1160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1164: END IF;
1165: END IF;
1166:
1167: Complete_Imp_Attribute_Rec(

Line 1175: p_init_msg_list => FND_API.G_FALSE,

1171:
1172: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1173: Validate_Imp_Attribute_Rec(
1174: p_api_version_number => 1.0,
1175: p_init_msg_list => FND_API.G_FALSE,
1176: x_return_status => x_return_status,
1177: x_msg_count => x_msg_count,
1178: x_msg_data => x_msg_data,
1179: p_imp_attribute_rec => l_imp_attribute_rec);

Line 1181: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1177: x_msg_count => x_msg_count,
1178: x_msg_data => x_msg_data,
1179: p_imp_attribute_rec => l_imp_attribute_rec);
1180:
1181: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1182: RAISE FND_API.G_EXC_ERROR;
1183: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1185: END IF;

Line 1182: RAISE FND_API.G_EXC_ERROR;

1178: x_msg_data => x_msg_data,
1179: p_imp_attribute_rec => l_imp_attribute_rec);
1180:
1181: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1182: RAISE FND_API.G_EXC_ERROR;
1183: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1185: END IF;
1186: END IF;

Line 1183: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1179: p_imp_attribute_rec => l_imp_attribute_rec);
1180:
1181: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1182: RAISE FND_API.G_EXC_ERROR;
1183: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1185: END IF;
1186: END IF;
1187:

Line 1184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1180:
1181: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1182: RAISE FND_API.G_EXC_ERROR;
1183: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1185: END IF;
1186: END IF;
1187:
1188: -- Debug Message

Line 1195: x_return_status := FND_API.G_RET_STS_SUCCESS;

1191: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1192: END IF;
1193:
1194: -- Initialize API return status to SUCCESS
1195: x_return_status := FND_API.G_RET_STS_SUCCESS;
1196:
1197: -- Debug Message
1198: IF (AMS_DEBUG_HIGH_ON) THEN
1199:

Line 1211: x_return_status := FND_API.g_ret_sts_error;

1207: );
1208: EXCEPTION
1209:
1210: WHEN AMS_Utility_PVT.resource_locked THEN
1211: x_return_status := FND_API.g_ret_sts_error;
1212: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1213:
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: ROLLBACK TO VALIDATE_Dm_Imp_Attribute_;

Line 1214: WHEN FND_API.G_EXC_ERROR THEN

1210: WHEN AMS_Utility_PVT.resource_locked THEN
1211: x_return_status := FND_API.g_ret_sts_error;
1212: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1213:
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: ROLLBACK TO VALIDATE_Dm_Imp_Attribute_;
1216: x_return_status := FND_API.G_RET_STS_ERROR;
1217: -- Standard call to get message count and if count=1, get the message
1218: FND_MSG_PUB.Count_And_Get (

Line 1216: x_return_status := FND_API.G_RET_STS_ERROR;

1212: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1213:
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: ROLLBACK TO VALIDATE_Dm_Imp_Attribute_;
1216: x_return_status := FND_API.G_RET_STS_ERROR;
1217: -- Standard call to get message count and if count=1, get the message
1218: FND_MSG_PUB.Count_And_Get (
1219: p_encoded => FND_API.G_FALSE,
1220: p_count => x_msg_count,

Line 1219: p_encoded => FND_API.G_FALSE,

1215: ROLLBACK TO VALIDATE_Dm_Imp_Attribute_;
1216: x_return_status := FND_API.G_RET_STS_ERROR;
1217: -- Standard call to get message count and if count=1, get the message
1218: FND_MSG_PUB.Count_And_Get (
1219: p_encoded => FND_API.G_FALSE,
1220: p_count => x_msg_count,
1221: p_data => x_msg_data
1222: );
1223:

Line 1224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1220: p_count => x_msg_count,
1221: p_data => x_msg_data
1222: );
1223:
1224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1225: ROLLBACK TO VALIDATE_Dm_Imp_Attribute_;
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1227: -- Standard call to get message count and if count=1, get the message
1228: FND_MSG_PUB.Count_And_Get (

Line 1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1222: );
1223:
1224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1225: ROLLBACK TO VALIDATE_Dm_Imp_Attribute_;
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1227: -- Standard call to get message count and if count=1, get the message
1228: FND_MSG_PUB.Count_And_Get (
1229: p_encoded => FND_API.G_FALSE,
1230: p_count => x_msg_count,

Line 1229: p_encoded => FND_API.G_FALSE,

1225: ROLLBACK TO VALIDATE_Dm_Imp_Attribute_;
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1227: -- Standard call to get message count and if count=1, get the message
1228: FND_MSG_PUB.Count_And_Get (
1229: p_encoded => FND_API.G_FALSE,
1230: p_count => x_msg_count,
1231: p_data => x_msg_data
1232: );
1233:

Line 1236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1232: );
1233:
1234: WHEN OTHERS THEN
1235: ROLLBACK TO VALIDATE_Dm_Imp_Attribute_;
1236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1237: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1238: THEN
1239: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1240: END IF;

Line 1243: p_encoded => FND_API.G_FALSE,

1239: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1240: END IF;
1241: -- Standard call to get message count and if count=1, get the message
1242: FND_MSG_PUB.Count_And_Get (
1243: p_encoded => FND_API.G_FALSE,
1244: p_count => x_msg_count,
1245: p_data => x_msg_data
1246: );
1247: End Validate_Imp_Attribute;

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

1248:
1249:
1250: PROCEDURE Validate_Imp_Attribute_Rec (
1251: p_api_version_number IN NUMBER,
1252: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1253: x_return_status OUT NOCOPY VARCHAR2,
1254: x_msg_count OUT NOCOPY NUMBER,
1255: x_msg_data OUT NOCOPY VARCHAR2,
1256: p_imp_attribute_rec IN imp_attribute_rec_type

Line 1261: IF FND_API.to_Boolean( p_init_msg_list )

1257: )
1258: IS
1259: BEGIN
1260: -- Initialize message list if p_init_msg_list is set to TRUE.
1261: IF FND_API.to_Boolean( p_init_msg_list )
1262: THEN
1263: FND_MSG_PUB.initialize;
1264: END IF;
1265:

Line 1267: x_return_status := FND_API.G_RET_STS_SUCCESS;

1263: FND_MSG_PUB.initialize;
1264: END IF;
1265:
1266: -- Initialize API return status to SUCCESS
1267: x_return_status := FND_API.G_RET_STS_SUCCESS;
1268:
1269: -- Hint: Validate data
1270: -- If data not valid
1271: -- THEN

Line 1272: -- x_return_status := FND_API.G_RET_STS_ERROR;

1268:
1269: -- Hint: Validate data
1270: -- If data not valid
1271: -- THEN
1272: -- x_return_status := FND_API.G_RET_STS_ERROR;
1273:
1274: -- Debug Message
1275: IF (AMS_DEBUG_HIGH_ON) THEN
1276: