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

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

50: -- Parameters
51: --
52: -- IN
53: -- p_api_version_number IN NUMBER Required
54: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
55: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
56: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
57: -- p_target_source_rec_type_rec IN target_source_rec_type Required
58: --

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

51: --
52: -- IN
53: -- p_api_version_number IN NUMBER Required
54: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
55: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
56: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
57: -- p_target_source_rec_type_rec IN target_source_rec_type Required
58: --
59: -- OUT

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

52: -- IN
53: -- p_api_version_number IN NUMBER Required
54: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
55: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
56: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
57: -- p_target_source_rec_type_rec IN target_source_rec_type Required
58: --
59: -- OUT
60: -- x_return_status OUT NOCOPY VARCHAR2

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

72: -- ==============================================================================
73:
74: PROCEDURE Create_Dm_Target_Sources(
75: p_api_version_number IN NUMBER,
76: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
77: p_commit IN VARCHAR2 := FND_API.G_FALSE,
78: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
79:
80: x_return_status OUT NOCOPY VARCHAR2,

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

73:
74: PROCEDURE Create_Dm_Target_Sources(
75: p_api_version_number IN NUMBER,
76: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
77: p_commit IN VARCHAR2 := FND_API.G_FALSE,
78: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
79:
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,

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

74: PROCEDURE Create_Dm_Target_Sources(
75: p_api_version_number IN NUMBER,
76: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
77: p_commit IN VARCHAR2 := FND_API.G_FALSE,
78: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
79:
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2,

Line 93: l_org_id NUMBER := FND_API.G_MISS_NUM;

89: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Dm_Target_Sources';
90: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
91: l_return_status_full VARCHAR2(1);
92: l_object_version_number NUMBER := 1;
93: l_org_id NUMBER := FND_API.G_MISS_NUM;
94: l_target_source_rec target_source_rec_type := p_target_source_rec_type_rec;
95: l_dummy NUMBER;
96: CURSOR c_id IS
97: SELECT ams_dm_target_sources_s.NEXTVAL

Line 109: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

105: -- Standard Start of API savepoint
106: SAVEPOINT create_dm_target_sources_pvt;
107:
108: -- Standard call to check for call compatibility.
109: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
110: p_api_version_number,
111: l_api_name,
112: G_PKG_NAME)
113: THEN

Line 114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

110: p_api_version_number,
111: l_api_name,
112: G_PKG_NAME)
113: THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116:
117:
118: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 119: IF FND_API.to_Boolean( p_init_msg_list )

115: END IF;
116:
117:
118: -- Initialize message list if p_init_msg_list is set to TRUE.
119: IF FND_API.to_Boolean( p_init_msg_list )
120: THEN
121: FND_MSG_PUB.initialize;
122: END IF;
123:

Line 132: x_return_status := FND_API.G_RET_STS_SUCCESS;

128:
129:
130:
131: -- Initialize API return status to SUCCESS
132: x_return_status := FND_API.G_RET_STS_SUCCESS;
133:
134: -- =========================================================================
135: -- Validate Environment
136: -- =========================================================================

Line 141: RAISE FND_API.G_EXC_ERROR;

137:
138: IF FND_GLOBAL.USER_ID IS NULL
139: THEN
140: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
141: RAISE FND_API.G_EXC_ERROR;
142: END IF;
143:
144:
145: -- Local variable initialization

Line 147: IF l_target_source_rec.target_source_id IS NULL OR l_target_source_rec.target_source_id = FND_API.g_miss_num THEN

143:
144:
145: -- Local variable initialization
146:
147: IF l_target_source_rec.target_source_id IS NULL OR l_target_source_rec.target_source_id = FND_API.g_miss_num THEN
148: LOOP
149: l_dummy := NULL;
150: OPEN c_id;
151: FETCH c_id INTO l_target_source_rec.target_source_id;

Line 161: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

157: EXIT WHEN l_dummy IS NULL;
158: END LOOP;
159: END IF;
160:
161: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
162: THEN
163: -- Debug message
164: AMS_UTILITY_PVT.debug_message('Private API: Validate_Dm_Target_Sources');
165:

Line 169: p_init_msg_list => FND_API.G_FALSE,

165:
166: -- Invoke validation procedures
167: Validate_dm_target_sources(
168: p_api_version_number => 1.0,
169: p_init_msg_list => FND_API.G_FALSE,
170: p_validation_level => p_validation_level,
171: p_validation_mode => JTF_PLSQL_API.g_create,
172: p_target_source_rec_type_rec => l_target_source_rec,
173: x_return_status => x_return_status,

Line 178: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

174: x_msg_count => x_msg_count,
175: x_msg_data => x_msg_data);
176: END IF;
177:
178: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
179: RAISE FND_API.G_EXC_ERROR;
180: END IF;
181:
182:

Line 179: RAISE FND_API.G_EXC_ERROR;

175: x_msg_data => x_msg_data);
176: END IF;
177:
178: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
179: RAISE FND_API.G_EXC_ERROR;
180: END IF;
181:
182:
183: -- Debug Message

Line 200: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

196: p_data_source_id => l_target_source_rec.data_source_id
197: );
198:
199: x_target_source_id := l_target_source_rec.target_source_id;
200: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
201: RAISE FND_API.G_EXC_ERROR;
202: END IF;
203: --
204: -- End of API body

Line 201: RAISE FND_API.G_EXC_ERROR;

197: );
198:
199: x_target_source_id := l_target_source_rec.target_source_id;
200: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
201: RAISE FND_API.G_EXC_ERROR;
202: END IF;
203: --
204: -- End of API body
205: --

Line 208: IF FND_API.to_Boolean( p_commit )

204: -- End of API body
205: --
206:
207: -- Standard check for p_commit
208: IF FND_API.to_Boolean( p_commit )
209: THEN
210: COMMIT WORK;
211: END IF;
212:

Line 226: x_return_status := FND_API.g_ret_sts_error;

222: );
223: EXCEPTION
224:
225: WHEN AMS_Utility_PVT.resource_locked THEN
226: x_return_status := FND_API.g_ret_sts_error;
227: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
228:
229: WHEN FND_API.G_EXC_ERROR THEN
230: ROLLBACK TO CREATE_Dm_Target_Sources_PVT;

Line 229: WHEN FND_API.G_EXC_ERROR THEN

225: WHEN AMS_Utility_PVT.resource_locked THEN
226: x_return_status := FND_API.g_ret_sts_error;
227: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
228:
229: WHEN FND_API.G_EXC_ERROR THEN
230: ROLLBACK TO CREATE_Dm_Target_Sources_PVT;
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: -- Standard call to get message count and if count=1, get the message
233: FND_MSG_PUB.Count_And_Get (

Line 231: x_return_status := FND_API.G_RET_STS_ERROR;

227: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
228:
229: WHEN FND_API.G_EXC_ERROR THEN
230: ROLLBACK TO CREATE_Dm_Target_Sources_PVT;
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: -- Standard call to get message count and if count=1, get the message
233: FND_MSG_PUB.Count_And_Get (
234: p_encoded => FND_API.G_FALSE,
235: p_count => x_msg_count,

Line 234: p_encoded => FND_API.G_FALSE,

230: ROLLBACK TO CREATE_Dm_Target_Sources_PVT;
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: -- Standard call to get message count and if count=1, get the message
233: FND_MSG_PUB.Count_And_Get (
234: p_encoded => FND_API.G_FALSE,
235: p_count => x_msg_count,
236: p_data => x_msg_data
237: );
238:

Line 239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

235: p_count => x_msg_count,
236: p_data => x_msg_data
237: );
238:
239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
240: ROLLBACK TO CREATE_Dm_Target_Sources_PVT;
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: -- Standard call to get message count and if count=1, get the message
243: FND_MSG_PUB.Count_And_Get (

Line 241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

237: );
238:
239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
240: ROLLBACK TO CREATE_Dm_Target_Sources_PVT;
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: -- Standard call to get message count and if count=1, get the message
243: FND_MSG_PUB.Count_And_Get (
244: p_encoded => FND_API.G_FALSE,
245: p_count => x_msg_count,

Line 244: p_encoded => FND_API.G_FALSE,

240: ROLLBACK TO CREATE_Dm_Target_Sources_PVT;
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: -- Standard call to get message count and if count=1, get the message
243: FND_MSG_PUB.Count_And_Get (
244: p_encoded => FND_API.G_FALSE,
245: p_count => x_msg_count,
246: p_data => x_msg_data
247: );
248:

Line 251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

247: );
248:
249: WHEN OTHERS THEN
250: ROLLBACK TO CREATE_Dm_Target_Sources_PVT;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
253: THEN
254: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
255: END IF;

Line 258: p_encoded => FND_API.G_FALSE,

254: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
255: END IF;
256: -- Standard call to get message count and if count=1, get the message
257: FND_MSG_PUB.Count_And_Get (
258: p_encoded => FND_API.G_FALSE,
259: p_count => x_msg_count,
260: p_data => x_msg_data
261: );
262: End Create_Dm_Target_Sources;

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

274: -- Parameters
275: --
276: -- IN
277: -- p_api_version_number IN NUMBER Required
278: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
279: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
280: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
281: -- p_target_source_rec_type_rec IN target_source_rec_type Required
282: --

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

275: --
276: -- IN
277: -- p_api_version_number IN NUMBER Required
278: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
279: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
280: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
281: -- p_target_source_rec_type_rec IN target_source_rec_type Required
282: --
283: -- OUT

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

276: -- IN
277: -- p_api_version_number IN NUMBER Required
278: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
279: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
280: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
281: -- p_target_source_rec_type_rec IN target_source_rec_type Required
282: --
283: -- OUT
284: -- x_return_status OUT NOCOPY VARCHAR2

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

298: -- ==============================================================================
299:
300: PROCEDURE Update_Dm_Target_Sources(
301: p_api_version_number IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
303: p_commit IN VARCHAR2 := FND_API.G_FALSE,
304: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
305:
306: x_return_status OUT NOCOPY VARCHAR2,

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

299:
300: PROCEDURE Update_Dm_Target_Sources(
301: p_api_version_number IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
303: p_commit IN VARCHAR2 := FND_API.G_FALSE,
304: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
305:
306: x_return_status OUT NOCOPY VARCHAR2,
307: x_msg_count OUT NOCOPY NUMBER,

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

300: PROCEDURE Update_Dm_Target_Sources(
301: p_api_version_number IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
303: p_commit IN VARCHAR2 := FND_API.G_FALSE,
304: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
305:
306: x_return_status OUT NOCOPY VARCHAR2,
307: x_msg_count OUT NOCOPY NUMBER,
308: x_msg_data OUT NOCOPY VARCHAR2,

Line 336: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

332: -- Standard Start of API savepoint
333: SAVEPOINT update_dm_target_sources_pvt;
334:
335: -- Standard call to check for call compatibility.
336: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
337: p_api_version_number,
338: l_api_name,
339: G_PKG_NAME)
340: THEN

Line 341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

337: p_api_version_number,
338: l_api_name,
339: G_PKG_NAME)
340: THEN
341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
342: END IF;
343:
344:
345: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 346: IF FND_API.to_Boolean( p_init_msg_list )

342: END IF;
343:
344:
345: -- Initialize message list if p_init_msg_list is set to TRUE.
346: IF FND_API.to_Boolean( p_init_msg_list )
347: THEN
348: FND_MSG_PUB.initialize;
349: END IF;
350:

Line 359: x_return_status := FND_API.G_RET_STS_SUCCESS;

355:
356:
357:
358: -- Initialize API return status to SUCCESS
359: x_return_status := FND_API.G_RET_STS_SUCCESS;
360:
361: -- Debug Message
362: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
363:

Line 372: RAISE FND_API.G_EXC_ERROR;

368: If ( c_get_Dm_Target_Sources%NOTFOUND) THEN
369: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
370: p_token_name => 'INFO',
371: p_token_value => 'Dm_Target_Sources') ;
372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
374: -- Debug Message
375: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
376: CLOSE c_get_Dm_Target_Sources;

Line 380: l_tar_target_source_rec.object_version_number = FND_API.G_MISS_NUM ) Then

376: CLOSE c_get_Dm_Target_Sources;
377:
378:
379: If (l_tar_target_source_rec.object_version_number is NULL or
380: l_tar_target_source_rec.object_version_number = FND_API.G_MISS_NUM ) Then
381: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
382: p_token_name => 'COLUMN',
383: p_token_value => 'Last_Update_Date') ;
384: raise FND_API.G_EXC_ERROR;

Line 384: raise FND_API.G_EXC_ERROR;

380: l_tar_target_source_rec.object_version_number = FND_API.G_MISS_NUM ) Then
381: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
382: p_token_name => 'COLUMN',
383: p_token_value => 'Last_Update_Date') ;
384: raise FND_API.G_EXC_ERROR;
385: End if;
386: -- Check Whether record has been changed by someone else
387: If (l_tar_target_source_rec.object_version_number <> l_ref_target_source_rec.object_version_number) Then
388: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

Line 391: raise FND_API.G_EXC_ERROR;

387: If (l_tar_target_source_rec.object_version_number <> l_ref_target_source_rec.object_version_number) Then
388: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
389: p_token_name => 'INFO',
390: p_token_value => 'Dm_Target_Sources') ;
391: raise FND_API.G_EXC_ERROR;
392: End if;
393:
394:
395: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 395: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

391: raise FND_API.G_EXC_ERROR;
392: End if;
393:
394:
395: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
396: THEN
397: -- Debug message
398: AMS_UTILITY_PVT.debug_message('Private API: Validate_Dm_Target_Sources');
399:

Line 403: p_init_msg_list => FND_API.G_FALSE,

399:
400: -- Invoke validation procedures
401: Validate_dm_target_sources(
402: p_api_version_number => 1.0,
403: p_init_msg_list => FND_API.G_FALSE,
404: p_validation_level => p_validation_level,
405: p_validation_mode => JTF_PLSQL_API.g_update,
406: p_target_source_rec_type_rec => p_target_source_rec_type_rec,
407: x_return_status => x_return_status,

Line 412: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

408: x_msg_count => x_msg_count,
409: x_msg_data => x_msg_data);
410: END IF;
411:
412: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
413: RAISE FND_API.G_EXC_ERROR;
414: END IF;
415:
416:

Line 413: RAISE FND_API.G_EXC_ERROR;

409: x_msg_data => x_msg_data);
410: END IF;
411:
412: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
413: RAISE FND_API.G_EXC_ERROR;
414: END IF;
415:
416:
417: -- Debug Message

Line 435: IF FND_API.to_Boolean( p_commit )

431: -- End of API body.
432: --
433:
434: -- Standard check for p_commit
435: IF FND_API.to_Boolean( p_commit )
436: THEN
437: COMMIT WORK;
438: END IF;
439:

Line 453: x_return_status := FND_API.g_ret_sts_error;

449: );
450: EXCEPTION
451:
452: WHEN AMS_Utility_PVT.resource_locked THEN
453: x_return_status := FND_API.g_ret_sts_error;
454: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
455:
456: WHEN FND_API.G_EXC_ERROR THEN
457: ROLLBACK TO UPDATE_Dm_Target_Sources_PVT;

Line 456: WHEN FND_API.G_EXC_ERROR THEN

452: WHEN AMS_Utility_PVT.resource_locked THEN
453: x_return_status := FND_API.g_ret_sts_error;
454: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
455:
456: WHEN FND_API.G_EXC_ERROR THEN
457: ROLLBACK TO UPDATE_Dm_Target_Sources_PVT;
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: -- Standard call to get message count and if count=1, get the message
460: FND_MSG_PUB.Count_And_Get (

Line 458: x_return_status := FND_API.G_RET_STS_ERROR;

454: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
455:
456: WHEN FND_API.G_EXC_ERROR THEN
457: ROLLBACK TO UPDATE_Dm_Target_Sources_PVT;
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: -- Standard call to get message count and if count=1, get the message
460: FND_MSG_PUB.Count_And_Get (
461: p_encoded => FND_API.G_FALSE,
462: p_count => x_msg_count,

Line 461: p_encoded => FND_API.G_FALSE,

457: ROLLBACK TO UPDATE_Dm_Target_Sources_PVT;
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: -- Standard call to get message count and if count=1, get the message
460: FND_MSG_PUB.Count_And_Get (
461: p_encoded => FND_API.G_FALSE,
462: p_count => x_msg_count,
463: p_data => x_msg_data
464: );
465:

Line 466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

462: p_count => x_msg_count,
463: p_data => x_msg_data
464: );
465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467: ROLLBACK TO UPDATE_Dm_Target_Sources_PVT;
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: -- Standard call to get message count and if count=1, get the message
470: FND_MSG_PUB.Count_And_Get (

Line 468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

464: );
465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467: ROLLBACK TO UPDATE_Dm_Target_Sources_PVT;
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: -- Standard call to get message count and if count=1, get the message
470: FND_MSG_PUB.Count_And_Get (
471: p_encoded => FND_API.G_FALSE,
472: p_count => x_msg_count,

Line 471: p_encoded => FND_API.G_FALSE,

467: ROLLBACK TO UPDATE_Dm_Target_Sources_PVT;
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: -- Standard call to get message count and if count=1, get the message
470: FND_MSG_PUB.Count_And_Get (
471: p_encoded => FND_API.G_FALSE,
472: p_count => x_msg_count,
473: p_data => x_msg_data
474: );
475:

Line 478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

474: );
475:
476: WHEN OTHERS THEN
477: ROLLBACK TO UPDATE_Dm_Target_Sources_PVT;
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
480: THEN
481: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
482: END IF;

Line 485: p_encoded => FND_API.G_FALSE,

481: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
482: END IF;
483: -- Standard call to get message count and if count=1, get the message
484: FND_MSG_PUB.Count_And_Get (
485: p_encoded => FND_API.G_FALSE,
486: p_count => x_msg_count,
487: p_data => x_msg_data
488: );
489: End Update_Dm_Target_Sources;

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

501: -- Parameters
502: --
503: -- IN
504: -- p_api_version_number IN NUMBER Required
505: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
506: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
507: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
508: -- p_target_source_id IN NUMBER
509: -- p_object_version_number IN NUMBER Optional Default = NULL

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

502: --
503: -- IN
504: -- p_api_version_number IN NUMBER Required
505: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
506: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
507: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
508: -- p_target_source_id IN NUMBER
509: -- p_object_version_number IN NUMBER Optional Default = NULL
510: --

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

503: -- IN
504: -- p_api_version_number IN NUMBER Required
505: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
506: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
507: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
508: -- p_target_source_id IN NUMBER
509: -- p_object_version_number IN NUMBER Optional Default = NULL
510: --
511: -- OUT

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

524: -- ==============================================================================
525:
526: PROCEDURE Delete_Dm_Target_Sources(
527: p_api_version_number IN NUMBER,
528: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
529: p_commit IN VARCHAR2 := FND_API.G_FALSE,
530: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
531: x_return_status OUT NOCOPY VARCHAR2,
532: x_msg_count OUT NOCOPY NUMBER,

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

525:
526: PROCEDURE Delete_Dm_Target_Sources(
527: p_api_version_number IN NUMBER,
528: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
529: p_commit IN VARCHAR2 := FND_API.G_FALSE,
530: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
531: x_return_status OUT NOCOPY VARCHAR2,
532: x_msg_count OUT NOCOPY NUMBER,
533: x_msg_data OUT NOCOPY VARCHAR2,

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

526: PROCEDURE Delete_Dm_Target_Sources(
527: p_api_version_number IN NUMBER,
528: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
529: p_commit IN VARCHAR2 := FND_API.G_FALSE,
530: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
531: x_return_status OUT NOCOPY VARCHAR2,
532: x_msg_count OUT NOCOPY NUMBER,
533: x_msg_data OUT NOCOPY VARCHAR2,
534: p_target_source_id IN NUMBER,

Line 556: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

552: -- Standard Start of API savepoint
553: SAVEPOINT delete_dm_target_sources_pvt;
554:
555: -- Standard call to check for call compatibility.
556: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
557: p_api_version_number,
558: l_api_name,
559: G_PKG_NAME)
560: THEN

Line 561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

557: p_api_version_number,
558: l_api_name,
559: G_PKG_NAME)
560: THEN
561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
562: END IF;
563:
564:
565: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 566: IF FND_API.to_Boolean( p_init_msg_list )

562: END IF;
563:
564:
565: -- Initialize message list if p_init_msg_list is set to TRUE.
566: IF FND_API.to_Boolean( p_init_msg_list )
567: THEN
568: FND_MSG_PUB.initialize;
569: END IF;
570:

Line 579: x_return_status := FND_API.G_RET_STS_SUCCESS;

575:
576:
577:
578: -- Initialize API return status to SUCCESS
579: x_return_status := FND_API.G_RET_STS_SUCCESS;
580:
581: OPEN c_target_source(p_target_source_id) ;
582: FETCH c_target_source INTO l_dummy;
583: CLOSE c_target_source ;

Line 587: RAISE FND_API.G_EXC_ERROR;

583: CLOSE c_target_source ;
584:
585: IF l_dummy IS NOT NULL THEN
586: AMS_Utility_PVT.error_message ('AMS_DM_CHLD_DS_DEL_ERR');
587: RAISE FND_API.G_EXC_ERROR;
588: END IF;
589: --
590: -- Api body
591: --

Line 604: IF FND_API.to_Boolean( p_commit )

600: -- End of API body
601: --
602:
603: -- Standard check for p_commit
604: IF FND_API.to_Boolean( p_commit )
605: THEN
606: COMMIT WORK;
607: END IF;
608:

Line 622: x_return_status := FND_API.g_ret_sts_error;

618: );
619: EXCEPTION
620:
621: WHEN AMS_Utility_PVT.resource_locked THEN
622: x_return_status := FND_API.g_ret_sts_error;
623: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
624:
625: WHEN FND_API.G_EXC_ERROR THEN
626: ROLLBACK TO DELETE_Dm_Target_Sources_PVT;

Line 625: WHEN FND_API.G_EXC_ERROR THEN

621: WHEN AMS_Utility_PVT.resource_locked THEN
622: x_return_status := FND_API.g_ret_sts_error;
623: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
624:
625: WHEN FND_API.G_EXC_ERROR THEN
626: ROLLBACK TO DELETE_Dm_Target_Sources_PVT;
627: x_return_status := FND_API.G_RET_STS_ERROR;
628: -- Standard call to get message count and if count=1, get the message
629: FND_MSG_PUB.Count_And_Get (

Line 627: x_return_status := FND_API.G_RET_STS_ERROR;

623: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
624:
625: WHEN FND_API.G_EXC_ERROR THEN
626: ROLLBACK TO DELETE_Dm_Target_Sources_PVT;
627: x_return_status := FND_API.G_RET_STS_ERROR;
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,

Line 630: p_encoded => FND_API.G_FALSE,

626: ROLLBACK TO DELETE_Dm_Target_Sources_PVT;
627: x_return_status := FND_API.G_RET_STS_ERROR;
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:

Line 635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

631: p_count => x_msg_count,
632: p_data => x_msg_data
633: );
634:
635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
636: ROLLBACK TO DELETE_Dm_Target_Sources_PVT;
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
638: -- Standard call to get message count and if count=1, get the message
639: FND_MSG_PUB.Count_And_Get (

Line 637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

633: );
634:
635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
636: ROLLBACK TO DELETE_Dm_Target_Sources_PVT;
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,

Line 640: p_encoded => FND_API.G_FALSE,

636: ROLLBACK TO DELETE_Dm_Target_Sources_PVT;
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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:

Line 647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

643: );
644:
645: WHEN OTHERS THEN
646: ROLLBACK TO DELETE_Dm_Target_Sources_PVT;
647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
648: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
649: THEN
650: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
651: END IF;

Line 654: p_encoded => FND_API.G_FALSE,

650: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
651: END IF;
652: -- Standard call to get message count and if count=1, get the message
653: FND_MSG_PUB.Count_And_Get (
654: p_encoded => FND_API.G_FALSE,
655: p_count => x_msg_count,
656: p_data => x_msg_data
657: );
658: End Delete_Dm_Target_Sources;

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

672: -- Parameters
673: --
674: -- IN
675: -- p_api_version_number IN NUMBER Required
676: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
677: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
678: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
679: -- p_target_source_rec_type_rec IN target_source_rec_type Required
680: --

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

673: --
674: -- IN
675: -- p_api_version_number IN NUMBER Required
676: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
677: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
678: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
679: -- p_target_source_rec_type_rec IN target_source_rec_type Required
680: --
681: -- OUT

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

674: -- IN
675: -- p_api_version_number IN NUMBER Required
676: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
677: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
678: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
679: -- p_target_source_rec_type_rec IN target_source_rec_type Required
680: --
681: -- OUT
682: -- x_return_status OUT NOCOPY VARCHAR2

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

694: -- ==============================================================================
695:
696: PROCEDURE Lock_Dm_Target_Sources(
697: p_api_version_number IN NUMBER,
698: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
699:
700: x_return_status OUT NOCOPY VARCHAR2,
701: x_msg_count OUT NOCOPY NUMBER,
702: x_msg_data OUT NOCOPY VARCHAR2,

Line 721: IF FND_API.to_Boolean( p_init_msg_list )

717: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
718:
719:
720: -- Initialize message list if p_init_msg_list is set to TRUE.
721: IF FND_API.to_Boolean( p_init_msg_list )
722: THEN
723: FND_MSG_PUB.initialize;
724: END IF;
725:

Line 729: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

725:
726:
727:
728: -- Standard call to check for call compatibility.
729: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
730: p_api_version_number,
731: l_api_name,
732: G_PKG_NAME)
733: THEN

Line 734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

730: p_api_version_number,
731: l_api_name,
732: G_PKG_NAME)
733: THEN
734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
735: END IF;
736:
737:
738:

Line 740: x_return_status := FND_API.G_RET_STS_SUCCESS;

736:
737:
738:
739: -- Initialize API return status to SUCCESS
740: x_return_status := FND_API.G_RET_STS_SUCCESS;
741:
742:
743: ------------------------ lock -------------------------
744: Ams_Dm_Target_Sources_Pkg.Lock_Row(l_target_source_id,p_object_version);

Line 749: p_encoded => FND_API.g_false,

745:
746:
747: -------------------- finish --------------------------
748: FND_MSG_PUB.count_and_get(
749: p_encoded => FND_API.g_false,
750: p_count => x_msg_count,
751: p_data => x_msg_data);
752: AMS_Utility_PVT.debug_message(l_full_name ||': end');
753: EXCEPTION

Line 756: x_return_status := FND_API.g_ret_sts_error;

752: AMS_Utility_PVT.debug_message(l_full_name ||': end');
753: EXCEPTION
754:
755: WHEN AMS_Utility_PVT.resource_locked THEN
756: x_return_status := FND_API.g_ret_sts_error;
757: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
758:
759: WHEN FND_API.G_EXC_ERROR THEN
760: ROLLBACK TO LOCK_Dm_Target_Sources_PVT;

Line 759: WHEN FND_API.G_EXC_ERROR THEN

755: WHEN AMS_Utility_PVT.resource_locked THEN
756: x_return_status := FND_API.g_ret_sts_error;
757: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
758:
759: WHEN FND_API.G_EXC_ERROR THEN
760: ROLLBACK TO LOCK_Dm_Target_Sources_PVT;
761: x_return_status := FND_API.G_RET_STS_ERROR;
762: -- Standard call to get message count and if count=1, get the message
763: FND_MSG_PUB.Count_And_Get (

Line 761: x_return_status := FND_API.G_RET_STS_ERROR;

757: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
758:
759: WHEN FND_API.G_EXC_ERROR THEN
760: ROLLBACK TO LOCK_Dm_Target_Sources_PVT;
761: x_return_status := FND_API.G_RET_STS_ERROR;
762: -- Standard call to get message count and if count=1, get the message
763: FND_MSG_PUB.Count_And_Get (
764: p_encoded => FND_API.G_FALSE,
765: p_count => x_msg_count,

Line 764: p_encoded => FND_API.G_FALSE,

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

Line 769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

767: );
768:
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: ROLLBACK TO LOCK_Dm_Target_Sources_PVT;
771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: -- Standard call to get message count and if count=1, get the message
773: FND_MSG_PUB.Count_And_Get (
774: p_encoded => FND_API.G_FALSE,
775: p_count => x_msg_count,

Line 774: p_encoded => FND_API.G_FALSE,

770: ROLLBACK TO LOCK_Dm_Target_Sources_PVT;
771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: -- Standard call to get message count and if count=1, get the message
773: FND_MSG_PUB.Count_And_Get (
774: p_encoded => FND_API.G_FALSE,
775: p_count => x_msg_count,
776: p_data => x_msg_data
777: );
778:

Line 781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

777: );
778:
779: WHEN OTHERS THEN
780: ROLLBACK TO LOCK_Dm_Target_Sources_PVT;
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
783: THEN
784: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
785: END IF;

Line 788: p_encoded => FND_API.G_FALSE,

784: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
785: END IF;
786: -- Standard call to get message count and if count=1, get the message
787: FND_MSG_PUB.Count_And_Get (
788: p_encoded => FND_API.G_FALSE,
789: p_count => x_msg_count,
790: p_data => x_msg_data
791: );
792: End Lock_Dm_Target_Sources;

Line 805: x_return_status := FND_API.g_ret_sts_success;

801: IS
802: l_valid_flag VARCHAR2(1);
803:
804: BEGIN
805: x_return_status := FND_API.g_ret_sts_success;
806: IF p_validation_mode = JTF_PLSQL_API.g_create
807: AND p_target_source_rec_type_rec.target_source_id IS NOT NULL
808: THEN
809: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 815: IF l_valid_flag = FND_API.g_false THEN

811: 'target_source_id = ''' || p_target_source_rec_type_rec.target_source_id ||''''
812: );
813: END IF;
814:
815: IF l_valid_flag = FND_API.g_false THEN
816: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_target_source_id_DUPLICATE');
817: x_return_status := FND_API.g_ret_sts_error;
818: END IF;
819:

Line 817: x_return_status := FND_API.g_ret_sts_error;

813: END IF;
814:
815: IF l_valid_flag = FND_API.g_false THEN
816: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_target_source_id_DUPLICATE');
817: x_return_status := FND_API.g_ret_sts_error;
818: END IF;
819:
820: END check_Target_Source_Uk_Items;
821:

Line 831: x_return_status := FND_API.g_ret_sts_success;

827: x_return_status OUT NOCOPY VARCHAR2
828: )
829: IS
830: BEGIN
831: x_return_status := FND_API.g_ret_sts_success;
832:
833: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
834:
835:

Line 836: IF p_target_source_rec_type_rec.target_source_id = FND_API.G_MISS_NUM OR p_target_source_rec_type_rec.target_source_id IS NULL THEN

832:
833: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
834:
835:
836: IF p_target_source_rec_type_rec.target_source_id = FND_API.G_MISS_NUM OR p_target_source_rec_type_rec.target_source_id IS NULL THEN
837: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TARGET_SOURCE_ID' );
838: x_return_status := FND_API.g_ret_sts_error;
839: END IF;
840:

Line 838: x_return_status := FND_API.g_ret_sts_error;

834:
835:
836: IF p_target_source_rec_type_rec.target_source_id = FND_API.G_MISS_NUM OR p_target_source_rec_type_rec.target_source_id IS NULL THEN
837: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TARGET_SOURCE_ID' );
838: x_return_status := FND_API.g_ret_sts_error;
839: END IF;
840:
841:
842: IF p_target_source_rec_type_rec.target_id = FND_API.G_MISS_NUM OR p_target_source_rec_type_rec.target_id IS NULL THEN

Line 842: IF p_target_source_rec_type_rec.target_id = FND_API.G_MISS_NUM OR p_target_source_rec_type_rec.target_id IS NULL THEN

838: x_return_status := FND_API.g_ret_sts_error;
839: END IF;
840:
841:
842: IF p_target_source_rec_type_rec.target_id = FND_API.G_MISS_NUM OR p_target_source_rec_type_rec.target_id IS NULL THEN
843: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TARGET_ID' );
844: x_return_status := FND_API.g_ret_sts_error;
845: END IF;
846:

Line 844: x_return_status := FND_API.g_ret_sts_error;

840:
841:
842: IF p_target_source_rec_type_rec.target_id = FND_API.G_MISS_NUM OR p_target_source_rec_type_rec.target_id IS NULL THEN
843: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TARGET_ID' );
844: x_return_status := FND_API.g_ret_sts_error;
845: END IF;
846:
847:
848: IF p_target_source_rec_type_rec.data_source_id = FND_API.G_MISS_NUM OR p_target_source_rec_type_rec.data_source_id IS NULL THEN

Line 848: IF p_target_source_rec_type_rec.data_source_id = FND_API.G_MISS_NUM OR p_target_source_rec_type_rec.data_source_id IS NULL THEN

844: x_return_status := FND_API.g_ret_sts_error;
845: END IF;
846:
847:
848: IF p_target_source_rec_type_rec.data_source_id = FND_API.G_MISS_NUM OR p_target_source_rec_type_rec.data_source_id IS NULL THEN
849: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'DATA_SOURCE_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:
847:
848: IF p_target_source_rec_type_rec.data_source_id = FND_API.G_MISS_NUM OR p_target_source_rec_type_rec.data_source_id IS NULL THEN
849: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'DATA_SOURCE_ID' );
850: x_return_status := FND_API.g_ret_sts_error;
851: END IF;
852:
853:
854: ELSE

Line 857: IF p_target_source_rec_type_rec.target_source_id = FND_API.G_MISS_NUM THEN

853:
854: ELSE
855:
856:
857: IF p_target_source_rec_type_rec.target_source_id = FND_API.G_MISS_NUM THEN
858: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TARGET_SOURCE_ID' );
859: x_return_status := FND_API.g_ret_sts_error;
860: END IF;
861:

Line 859: x_return_status := FND_API.g_ret_sts_error;

855:
856:
857: IF p_target_source_rec_type_rec.target_source_id = FND_API.G_MISS_NUM THEN
858: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TARGET_SOURCE_ID' );
859: x_return_status := FND_API.g_ret_sts_error;
860: END IF;
861:
862:
863: IF p_target_source_rec_type_rec.target_id = FND_API.G_MISS_NUM THEN

Line 863: IF p_target_source_rec_type_rec.target_id = FND_API.G_MISS_NUM THEN

859: x_return_status := FND_API.g_ret_sts_error;
860: END IF;
861:
862:
863: IF p_target_source_rec_type_rec.target_id = FND_API.G_MISS_NUM THEN
864: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TARGET_ID' );
865: x_return_status := FND_API.g_ret_sts_error;
866: END IF;
867:

Line 865: x_return_status := FND_API.g_ret_sts_error;

861:
862:
863: IF p_target_source_rec_type_rec.target_id = FND_API.G_MISS_NUM THEN
864: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TARGET_ID' );
865: x_return_status := FND_API.g_ret_sts_error;
866: END IF;
867:
868:
869: IF p_target_source_rec_type_rec.data_source_id = FND_API.G_MISS_NUM THEN

Line 869: IF p_target_source_rec_type_rec.data_source_id = FND_API.G_MISS_NUM THEN

865: x_return_status := FND_API.g_ret_sts_error;
866: END IF;
867:
868:
869: IF p_target_source_rec_type_rec.data_source_id = FND_API.G_MISS_NUM THEN
870: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'DATA_SOURCE_ID' );
871: x_return_status := FND_API.g_ret_sts_error;
872: END IF;
873: END IF;

Line 871: x_return_status := FND_API.g_ret_sts_error;

867:
868:
869: IF p_target_source_rec_type_rec.data_source_id = FND_API.G_MISS_NUM THEN
870: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'DATA_SOURCE_ID' );
871: x_return_status := FND_API.g_ret_sts_error;
872: END IF;
873: END IF;
874:
875: END check_Target_Source_Req_Items;

Line 889: x_return_status := FND_API.g_ret_sts_success;

885: IF (AMS_DEBUG_HIGH_ON) THEN
886:
887: AMS_UTILITY_PVT.debug_message('Private API:check_Target_Source_Fk_Items');
888: END IF;
889: x_return_status := FND_API.g_ret_sts_success;
890:
891: --------------------- data_source_id ------------------------
892: IF p_target_source_rec_type_rec.data_source_id <> FND_API.g_miss_num THEN
893: IF AMS_Utility_PVT.check_fk_exists(

Line 892: IF p_target_source_rec_type_rec.data_source_id <> FND_API.g_miss_num THEN

888: END IF;
889: x_return_status := FND_API.g_ret_sts_success;
890:
891: --------------------- data_source_id ------------------------
892: IF p_target_source_rec_type_rec.data_source_id <> FND_API.g_miss_num THEN
893: IF AMS_Utility_PVT.check_fk_exists(
894: 'ams_list_src_types',
895: 'LIST_SOURCE_TYPE_ID',
896: p_target_source_rec_type_rec.data_source_id

Line 897: ) = FND_API.g_false

893: IF AMS_Utility_PVT.check_fk_exists(
894: 'ams_list_src_types',
895: 'LIST_SOURCE_TYPE_ID',
896: p_target_source_rec_type_rec.data_source_id
897: ) = FND_API.g_false
898: THEN
899: AMS_Utility_PVT.error_message ('AMS_API_INVALID_FK', 'COLUMN_NAME', 'DATA_SOURCE_ID');
900: x_return_status := FND_API.g_ret_sts_error;
901: END IF;

Line 900: x_return_status := FND_API.g_ret_sts_error;

896: p_target_source_rec_type_rec.data_source_id
897: ) = FND_API.g_false
898: THEN
899: AMS_Utility_PVT.error_message ('AMS_API_INVALID_FK', 'COLUMN_NAME', 'DATA_SOURCE_ID');
900: x_return_status := FND_API.g_ret_sts_error;
901: END IF;
902: END IF;
903:
904: --------------------- target_id ------------------------

Line 905: IF p_target_source_rec_type_rec.target_id <> FND_API.g_miss_num THEN

901: END IF;
902: END IF;
903:
904: --------------------- target_id ------------------------
905: IF p_target_source_rec_type_rec.target_id <> FND_API.g_miss_num THEN
906: IF AMS_Utility_PVT.check_fk_exists(
907: 'ams_dm_targets_b',
908: 'target_id',
909: p_target_source_rec_type_rec.target_id

Line 910: ) = FND_API.g_false

906: IF AMS_Utility_PVT.check_fk_exists(
907: 'ams_dm_targets_b',
908: 'target_id',
909: p_target_source_rec_type_rec.target_id
910: ) = FND_API.g_false
911: THEN
912: AMS_Utility_PVT.error_message ('AMS_API_INVALID_FK', 'COLUMN_NAME', 'TARGET_ID');
913: x_return_status := FND_API.g_ret_sts_error;
914: END IF;

Line 913: x_return_status := FND_API.g_ret_sts_error;

909: p_target_source_rec_type_rec.target_id
910: ) = FND_API.g_false
911: THEN
912: AMS_Utility_PVT.error_message ('AMS_API_INVALID_FK', 'COLUMN_NAME', 'TARGET_ID');
913: x_return_status := FND_API.g_ret_sts_error;
914: END IF;
915: END IF;
916:
917: END check_Target_Source_Fk_Items;

Line 927: x_return_status := FND_API.g_ret_sts_success;

923: x_return_status OUT NOCOPY VARCHAR2
924: )
925: IS
926: BEGIN
927: x_return_status := FND_API.g_ret_sts_success;
928:
929: -- Enter custom code here
930:
931: END check_Tgt_Src_Lookup_Items;

Line 944: l_return_status := FND_API.g_ret_sts_success;

940: IS
941: l_return_status VARCHAR2(1);
942: BEGIN
943:
944: l_return_status := FND_API.g_ret_sts_success;
945: -- Check Items Uniqueness API calls
946:
947: check_Target_Source_Uk_Items(
948: p_target_source_rec_type_rec => p_target_source_rec_type_rec,

Line 951: IF x_return_status <> FND_API.g_ret_sts_success THEN

947: check_Target_Source_Uk_Items(
948: p_target_source_rec_type_rec => p_target_source_rec_type_rec,
949: p_validation_mode => p_validation_mode,
950: x_return_status => x_return_status);
951: IF x_return_status <> FND_API.g_ret_sts_success THEN
952: l_return_status := FND_API.g_ret_sts_error;
953: END IF;
954:
955: -- Check Items Required/NOT NULL API calls

Line 952: l_return_status := FND_API.g_ret_sts_error;

948: p_target_source_rec_type_rec => p_target_source_rec_type_rec,
949: p_validation_mode => p_validation_mode,
950: x_return_status => x_return_status);
951: IF x_return_status <> FND_API.g_ret_sts_success THEN
952: l_return_status := FND_API.g_ret_sts_error;
953: END IF;
954:
955: -- Check Items Required/NOT NULL API calls
956:

Line 961: IF x_return_status <> FND_API.g_ret_sts_success THEN

957: check_Target_Source_Req_Items(
958: p_target_source_rec_type_rec => p_target_source_rec_type_rec,
959: p_validation_mode => p_validation_mode,
960: x_return_status => x_return_status);
961: IF x_return_status <> FND_API.g_ret_sts_success THEN
962: l_return_status := FND_API.g_ret_sts_error;
963: END IF;
964: -- Check Items Foreign Keys API calls
965:

Line 962: l_return_status := FND_API.g_ret_sts_error;

958: p_target_source_rec_type_rec => p_target_source_rec_type_rec,
959: p_validation_mode => p_validation_mode,
960: x_return_status => x_return_status);
961: IF x_return_status <> FND_API.g_ret_sts_success THEN
962: l_return_status := FND_API.g_ret_sts_error;
963: END IF;
964: -- Check Items Foreign Keys API calls
965:
966: check_Target_Source_Fk_Items(

Line 969: IF x_return_status <> FND_API.g_ret_sts_success THEN

965:
966: check_Target_Source_Fk_Items(
967: p_target_source_rec_type_rec => p_target_source_rec_type_rec,
968: x_return_status => x_return_status);
969: IF x_return_status <> FND_API.g_ret_sts_success THEN
970: l_return_status := FND_API.g_ret_sts_error;
971: END IF;
972: -- Check Items Lookups
973:

Line 970: l_return_status := FND_API.g_ret_sts_error;

966: check_Target_Source_Fk_Items(
967: p_target_source_rec_type_rec => p_target_source_rec_type_rec,
968: x_return_status => x_return_status);
969: IF x_return_status <> FND_API.g_ret_sts_success THEN
970: l_return_status := FND_API.g_ret_sts_error;
971: END IF;
972: -- Check Items Lookups
973:
974: check_Tgt_Src_Lookup_Items(

Line 977: IF x_return_status <> FND_API.g_ret_sts_success THEN

973:
974: check_Tgt_Src_Lookup_Items(
975: p_target_source_rec_type_rec => p_target_source_rec_type_rec,
976: x_return_status => x_return_status);
977: IF x_return_status <> FND_API.g_ret_sts_success THEN
978: l_return_status := FND_API.g_ret_sts_error;
979: END IF;
980:
981: x_return_status := l_return_status;

Line 978: l_return_status := FND_API.g_ret_sts_error;

974: check_Tgt_Src_Lookup_Items(
975: p_target_source_rec_type_rec => p_target_source_rec_type_rec,
976: x_return_status => x_return_status);
977: IF x_return_status <> FND_API.g_ret_sts_success THEN
978: l_return_status := FND_API.g_ret_sts_error;
979: END IF;
980:
981: x_return_status := l_return_status;
982:

Line 1066: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN

1062: l_target_source_rec_type_rec target_source_rec_type := p_target_source_rec_type_rec;
1063: BEGIN
1064: -- Developers should put their code to default the record type
1065: -- e.g. IF p_campaign_rec.status_code IS NULL
1066: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN
1067: -- l_campaign_rec.status_code := 'NEW' ;
1068: -- END IF ;
1069: --
1070: NULL ;

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

1074:
1075:
1076: PROCEDURE Validate_Dm_Target_Sources(
1077: p_api_version_number IN NUMBER,
1078: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1079: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1080: p_target_source_rec_type_rec IN target_source_rec_type,
1081: p_validation_mode IN VARCHAR2,
1082: x_return_status OUT NOCOPY VARCHAR2,

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

1075:
1076: PROCEDURE Validate_Dm_Target_Sources(
1077: p_api_version_number IN NUMBER,
1078: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1079: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1080: p_target_source_rec_type_rec IN target_source_rec_type,
1081: p_validation_mode IN VARCHAR2,
1082: x_return_status OUT NOCOPY VARCHAR2,
1083: x_msg_count OUT NOCOPY NUMBER,

Line 1097: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1093: -- Standard Start of API savepoint
1094: SAVEPOINT validate_dm_target_sources_;
1095:
1096: -- Standard call to check for call compatibility.
1097: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1098: p_api_version_number,
1099: l_api_name,
1100: G_PKG_NAME)
1101: THEN

Line 1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1098: p_api_version_number,
1099: l_api_name,
1100: G_PKG_NAME)
1101: THEN
1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1103: END IF;
1104:
1105:
1106: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1107: IF FND_API.to_Boolean( p_init_msg_list )

1103: END IF;
1104:
1105:
1106: -- Initialize message list if p_init_msg_list is set to TRUE.
1107: IF FND_API.to_Boolean( p_init_msg_list )
1108: THEN
1109: FND_MSG_PUB.initialize;
1110: END IF;
1111:

Line 1120: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1116: p_validation_mode => p_validation_mode,
1117: x_return_status => x_return_status
1118: );
1119:
1120: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1121: RAISE FND_API.G_EXC_ERROR;
1122: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1124: END IF;

Line 1121: RAISE FND_API.G_EXC_ERROR;

1117: x_return_status => x_return_status
1118: );
1119:
1120: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1121: RAISE FND_API.G_EXC_ERROR;
1122: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1124: END IF;
1125: END IF;

Line 1122: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1118: );
1119:
1120: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1121: RAISE FND_API.G_EXC_ERROR;
1122: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1124: END IF;
1125: END IF;
1126:

Line 1123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1119:
1120: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1121: RAISE FND_API.G_EXC_ERROR;
1122: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1124: END IF;
1125: END IF;
1126:
1127: /*IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 1141: p_init_msg_list => FND_API.G_FALSE,

1137:
1138: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1139: Validate_Target_Source_Rec(
1140: p_api_version_number => 1.0,
1141: p_init_msg_list => FND_API.G_FALSE,
1142: p_validation_mode => p_validation_mode,
1143: x_return_status => x_return_status,
1144: x_msg_count => x_msg_count,
1145: x_msg_data => x_msg_data,

Line 1148: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1144: x_msg_count => x_msg_count,
1145: x_msg_data => x_msg_data,
1146: p_target_source_rec_type_rec => l_target_source_rec_type_rec);
1147:
1148: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1149: RAISE FND_API.G_EXC_ERROR;
1150: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: END IF;

Line 1149: RAISE FND_API.G_EXC_ERROR;

1145: x_msg_data => x_msg_data,
1146: p_target_source_rec_type_rec => l_target_source_rec_type_rec);
1147:
1148: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1149: RAISE FND_API.G_EXC_ERROR;
1150: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: END IF;
1153: END IF;

Line 1150: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1146: p_target_source_rec_type_rec => l_target_source_rec_type_rec);
1147:
1148: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1149: RAISE FND_API.G_EXC_ERROR;
1150: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: END IF;
1153: END IF;
1154:

Line 1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1147:
1148: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1149: RAISE FND_API.G_EXC_ERROR;
1150: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: END IF;
1153: END IF;
1154:
1155:

Line 1162: x_return_status := FND_API.G_RET_STS_SUCCESS;

1158:
1159:
1160:
1161: -- Initialize API return status to SUCCESS
1162: x_return_status := FND_API.G_RET_STS_SUCCESS;
1163:
1164:
1165: -- Debug Message
1166: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

Line 1177: x_return_status := FND_API.g_ret_sts_error;

1173: );
1174: EXCEPTION
1175:
1176: WHEN AMS_Utility_PVT.resource_locked THEN
1177: x_return_status := FND_API.g_ret_sts_error;
1178: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1179:
1180: WHEN FND_API.G_EXC_ERROR THEN
1181: ROLLBACK TO VALIDATE_Dm_Target_Sources_;

Line 1180: WHEN FND_API.G_EXC_ERROR THEN

1176: WHEN AMS_Utility_PVT.resource_locked THEN
1177: x_return_status := FND_API.g_ret_sts_error;
1178: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1179:
1180: WHEN FND_API.G_EXC_ERROR THEN
1181: ROLLBACK TO VALIDATE_Dm_Target_Sources_;
1182: x_return_status := FND_API.G_RET_STS_ERROR;
1183: -- Standard call to get message count and if count=1, get the message
1184: FND_MSG_PUB.Count_And_Get (

Line 1182: x_return_status := FND_API.G_RET_STS_ERROR;

1178: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1179:
1180: WHEN FND_API.G_EXC_ERROR THEN
1181: ROLLBACK TO VALIDATE_Dm_Target_Sources_;
1182: x_return_status := FND_API.G_RET_STS_ERROR;
1183: -- Standard call to get message count and if count=1, get the message
1184: FND_MSG_PUB.Count_And_Get (
1185: p_encoded => FND_API.G_FALSE,
1186: p_count => x_msg_count,

Line 1185: p_encoded => FND_API.G_FALSE,

1181: ROLLBACK TO VALIDATE_Dm_Target_Sources_;
1182: x_return_status := FND_API.G_RET_STS_ERROR;
1183: -- Standard call to get message count and if count=1, get the message
1184: FND_MSG_PUB.Count_And_Get (
1185: p_encoded => FND_API.G_FALSE,
1186: p_count => x_msg_count,
1187: p_data => x_msg_data
1188: );
1189:

Line 1190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1186: p_count => x_msg_count,
1187: p_data => x_msg_data
1188: );
1189:
1190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1191: ROLLBACK TO VALIDATE_Dm_Target_Sources_;
1192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1193: -- Standard call to get message count and if count=1, get the message
1194: FND_MSG_PUB.Count_And_Get (

Line 1192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1188: );
1189:
1190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1191: ROLLBACK TO VALIDATE_Dm_Target_Sources_;
1192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1193: -- Standard call to get message count and if count=1, get the message
1194: FND_MSG_PUB.Count_And_Get (
1195: p_encoded => FND_API.G_FALSE,
1196: p_count => x_msg_count,

Line 1195: p_encoded => FND_API.G_FALSE,

1191: ROLLBACK TO VALIDATE_Dm_Target_Sources_;
1192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1193: -- Standard call to get message count and if count=1, get the message
1194: FND_MSG_PUB.Count_And_Get (
1195: p_encoded => FND_API.G_FALSE,
1196: p_count => x_msg_count,
1197: p_data => x_msg_data
1198: );
1199:

Line 1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1198: );
1199:
1200: WHEN OTHERS THEN
1201: ROLLBACK TO VALIDATE_Dm_Target_Sources_;
1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1203: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1204: THEN
1205: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1206: END IF;

Line 1209: p_encoded => FND_API.G_FALSE,

1205: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1206: END IF;
1207: -- Standard call to get message count and if count=1, get the message
1208: FND_MSG_PUB.Count_And_Get (
1209: p_encoded => FND_API.G_FALSE,
1210: p_count => x_msg_count,
1211: p_data => x_msg_data
1212: );
1213: End Validate_Dm_Target_Sources;

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

1214:
1215:
1216: PROCEDURE Validate_Target_Source_Rec (
1217: p_api_version_number IN NUMBER,
1218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1219: p_validation_mode IN VARCHAR2,
1220: x_return_status OUT NOCOPY VARCHAR2,
1221: x_msg_count OUT NOCOPY NUMBER,
1222: x_msg_data OUT NOCOPY VARCHAR2,

Line 1239: IF FND_API.to_Boolean( p_init_msg_list )

1235:
1236: l_dummy NUMBER := 0;
1237: BEGIN
1238: -- Initialize message list if p_init_msg_list is set to TRUE.
1239: IF FND_API.to_Boolean( p_init_msg_list )
1240: THEN
1241: FND_MSG_PUB.initialize;
1242: END IF;
1243:

Line 1247: x_return_status := FND_API.G_RET_STS_SUCCESS;

1243:
1244:
1245:
1246: -- Initialize API return status to SUCCESS
1247: x_return_status := FND_API.G_RET_STS_SUCCESS;
1248:
1249: -- Hint: Validate data
1250: -- If data not valid
1251: -- THEN

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

1248:
1249: -- Hint: Validate data
1250: -- If data not valid
1251: -- THEN
1252: -- x_return_status := FND_API.G_RET_STS_ERROR;
1253:
1254: -- Debug Message
1255: IF (AMS_DEBUG_HIGH_ON) THEN
1256: AMS_UTILITY_PVT.debug_message('Private API: Validate_Target_Source_Rec');

Line 1267: x_return_status := FND_API.G_RET_STS_ERROR;

1263: CLOSE c_check_underlying_obj;
1264:
1265: IF l_dummy <> 0 THEN
1266: AMS_Utility_PVT.error_message ('AMS_DM_CHILD_OBJ_EXISTS');
1267: x_return_status := FND_API.G_RET_STS_ERROR;
1268: END IF;
1269:
1270: END IF;
1271: -- Standard call to get message count and if count is 1, get message info.

Line 1313: WHEN FND_API.G_EXC_ERROR THEN

1309:
1310: WHEN AMS_Utility_PVT.resource_locked THEN
1311: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1312:
1313: WHEN FND_API.G_EXC_ERROR THEN
1314: ROLLBACK TO delete_tgtsources_for_target;
1315:
1316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1317: ROLLBACK TO delete_tgtsources_for_target;

Line 1316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1312:
1313: WHEN FND_API.G_EXC_ERROR THEN
1314: ROLLBACK TO delete_tgtsources_for_target;
1315:
1316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1317: ROLLBACK TO delete_tgtsources_for_target;
1318:
1319: WHEN OTHERS THEN
1320: ROLLBACK TO delete_tgtsources_for_target;