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

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

36: -- Parameters
37: --
38: -- IN
39: -- p_api_version_number IN NUMBER Required
40: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
41: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
42: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
43: -- p_imp_doc_rec IN imp_doccon_rec_type Required
44: --

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

37: --
38: -- IN
39: -- p_api_version_number IN NUMBER Required
40: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
41: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
42: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
43: -- p_imp_doc_rec IN imp_doccon_rec_type Required
44: --
45: -- OUT

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

38: -- IN
39: -- p_api_version_number IN NUMBER Required
40: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
41: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
42: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
43: -- p_imp_doc_rec IN imp_doccon_rec_type Required
44: --
45: -- OUT
46: -- x_return_status OUT VARCHAR2

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

62: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
63:
64: PROCEDURE Create_Imp_Doc_Content(
65: p_api_version_number IN NUMBER,
66: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
67: p_commit IN VARCHAR2 := FND_API.G_FALSE,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69:
70: x_return_status OUT NOCOPY VARCHAR2,

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

63:
64: PROCEDURE Create_Imp_Doc_Content(
65: p_api_version_number IN NUMBER,
66: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
67: p_commit IN VARCHAR2 := FND_API.G_FALSE,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69:
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,

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

64: PROCEDURE Create_Imp_Doc_Content(
65: p_api_version_number IN NUMBER,
66: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
67: p_commit IN VARCHAR2 := FND_API.G_FALSE,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69:
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
72: x_msg_data OUT NOCOPY VARCHAR2,

Line 83: l_org_id NUMBER := FND_API.G_MISS_NUM;

79: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Imp_Doc_Content';
80: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
81: l_return_status_full VARCHAR2(1);
82: l_object_version_number NUMBER := 1;
83: l_org_id NUMBER := FND_API.G_MISS_NUM;
84: l_imp_document_id NUMBER;
85: l_dummy NUMBER;
86:
87:

Line 102: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

98: -- Standard Start of API savepoint
99: SAVEPOINT create_imp_doc_pvt;
100:
101: -- Standard call to check for call compatibility.
102: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
103: p_api_version_number,
104: l_api_name,
105: G_PKG_NAME)
106: THEN

Line 107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

103: p_api_version_number,
104: l_api_name,
105: G_PKG_NAME)
106: THEN
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108: END IF;
109:
110: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message( 'The header id is:' || p_imp_doc_rec.import_list_header_id );END IF;
111:

Line 113: IF FND_API.to_Boolean( p_init_msg_list )

109:
110: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message( 'The header id is:' || p_imp_doc_rec.import_list_header_id );END IF;
111:
112: -- Initialize message list if p_init_msg_list is set to TRUE.
113: IF FND_API.to_Boolean( p_init_msg_list )
114: THEN
115: FND_MSG_PUB.initialize;
116: END IF;
117:

Line 130: x_return_status := FND_API.G_RET_STS_SUCCESS;

126:
127:
128:
129: -- Initialize API return status to SUCCESS
130: x_return_status := FND_API.G_RET_STS_SUCCESS;
131:
132: -- Local variable initialization
133:
134: IF p_imp_doc_rec.imp_doc_content_id IS NULL OR p_imp_doc_rec.imp_doc_content_id = FND_API.g_miss_num THEN

Line 134: IF p_imp_doc_rec.imp_doc_content_id IS NULL OR p_imp_doc_rec.imp_doc_content_id = FND_API.g_miss_num THEN

130: x_return_status := FND_API.G_RET_STS_SUCCESS;
131:
132: -- Local variable initialization
133:
134: IF p_imp_doc_rec.imp_doc_content_id IS NULL OR p_imp_doc_rec.imp_doc_content_id = FND_API.g_miss_num THEN
135: LOOP
136: l_dummy := NULL;
137: OPEN c_id;
138: FETCH c_id INTO l_imp_document_id;

Line 157: RAISE FND_API.G_EXC_ERROR;

153:
154: IF FND_GLOBAL.USER_ID IS NULL
155: THEN
156: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: IF ( p_validation_level IS NULL OR
161: P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 161: P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: IF ( p_validation_level IS NULL OR
161: P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
162: THEN
163: -- Debug message
164: IF (AMS_DEBUG_HIGH_ON) THEN
165:

Line 172: -- p_init_msg_list => FND_API.G_FALSE,

168:
169: -- Invoke validation procedures
170: --Validate_imp_doc(
171: --p_api_version_number => 1.0,
172: -- p_init_msg_list => FND_API.G_FALSE,
173: -- p_validation_level => p_validation_level,
174: -- p_validation_mode => JTF_PLSQL_API.g_create,
175: -- p_imp_doc_rec => p_imp_doc_rec,
176: -- x_return_status => x_return_status,

Line 182: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

178: -- x_msg_data => x_msg_data);
179: NULL;
180: END IF;
181:
182: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:
186:

Line 183: RAISE FND_API.G_EXC_ERROR;

179: NULL;
180: END IF;
181:
182: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:
186:
187: -- Debug Message

Line 209: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

205: p_file_name => p_imp_doc_rec.file_name
206: );
207:
208: x_imp_doccontent_id := l_imp_document_id;
209: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
210: RAISE FND_API.G_EXC_ERROR;
211: END IF;
212: --
213: -- End of API body

Line 210: RAISE FND_API.G_EXC_ERROR;

206: );
207:
208: x_imp_doccontent_id := l_imp_document_id;
209: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
210: RAISE FND_API.G_EXC_ERROR;
211: END IF;
212: --
213: -- End of API body
214: --

Line 217: IF FND_API.to_Boolean( p_commit )

213: -- End of API body
214: --
215:
216: -- Standard check for p_commit
217: IF FND_API.to_Boolean( p_commit )
218: THEN
219: COMMIT WORK;
220: END IF;
221:

Line 238: x_return_status := FND_API.g_ret_sts_error;

234: );
235: EXCEPTION
236:
237: WHEN AMS_Utility_PVT.resource_locked THEN
238: x_return_status := FND_API.g_ret_sts_error;
239: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
240:
241: WHEN FND_API.G_EXC_ERROR THEN
242: ROLLBACK TO CREATE_Imp_Doc_PVT;

Line 241: WHEN FND_API.G_EXC_ERROR THEN

237: WHEN AMS_Utility_PVT.resource_locked THEN
238: x_return_status := FND_API.g_ret_sts_error;
239: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
240:
241: WHEN FND_API.G_EXC_ERROR THEN
242: ROLLBACK TO CREATE_Imp_Doc_PVT;
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: -- Standard call to get message count and if count=1, get the message
245: FND_MSG_PUB.Count_And_Get (

Line 243: x_return_status := FND_API.G_RET_STS_ERROR;

239: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
240:
241: WHEN FND_API.G_EXC_ERROR THEN
242: ROLLBACK TO CREATE_Imp_Doc_PVT;
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: -- Standard call to get message count and if count=1, get the message
245: FND_MSG_PUB.Count_And_Get (
246: p_encoded => FND_API.G_FALSE,
247: p_count => x_msg_count,

Line 246: p_encoded => FND_API.G_FALSE,

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

Line 251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

247: p_count => x_msg_count,
248: p_data => x_msg_data
249: );
250:
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: ROLLBACK TO CREATE_Imp_Doc_PVT;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: -- Standard call to get message count and if count=1, get the message
255: FND_MSG_PUB.Count_And_Get (

Line 253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

249: );
250:
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: ROLLBACK TO CREATE_Imp_Doc_PVT;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: -- Standard call to get message count and if count=1, get the message
255: FND_MSG_PUB.Count_And_Get (
256: p_encoded => FND_API.G_FALSE,
257: p_count => x_msg_count,

Line 256: p_encoded => FND_API.G_FALSE,

252: ROLLBACK TO CREATE_Imp_Doc_PVT;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: -- Standard call to get message count and if count=1, get the message
255: FND_MSG_PUB.Count_And_Get (
256: p_encoded => FND_API.G_FALSE,
257: p_count => x_msg_count,
258: p_data => x_msg_data
259: );
260:

Line 263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

259: );
260:
261: WHEN OTHERS THEN
262: ROLLBACK TO CREATE_Imp_Doc_PVT;
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
265: THEN
266: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
267: END IF;

Line 270: p_encoded => FND_API.G_FALSE,

266: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
267: END IF;
268: -- Standard call to get message count and if count=1, get the message
269: FND_MSG_PUB.Count_And_Get (
270: p_encoded => FND_API.G_FALSE,
271: p_count => x_msg_count,
272: p_data => x_msg_data
273: );
274: End Create_Imp_Doc_Content;

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

286: -- Parameters
287: --
288: -- IN
289: -- p_api_version_number IN NUMBER Required
290: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
291: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
292: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
293: -- p_imp_doc_rec IN imp_doccon_rec_type Required
294: --

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

287: --
288: -- IN
289: -- p_api_version_number IN NUMBER Required
290: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
291: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
292: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
293: -- p_imp_doc_rec IN imp_doccon_rec_type Required
294: --
295: -- OUT

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

288: -- IN
289: -- p_api_version_number IN NUMBER Required
290: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
291: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
292: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
293: -- p_imp_doc_rec IN imp_doccon_rec_type Required
294: --
295: -- OUT
296: -- x_return_status OUT VARCHAR2

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

308: -- ==============================================================================
309:
310: PROCEDURE Update_Imp_Doc_Con(
311: p_api_version_number IN NUMBER,
312: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
313: p_commit IN VARCHAR2 := FND_API.G_FALSE,
314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
315:
316: x_return_status OUT NOCOPY VARCHAR2,

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

309:
310: PROCEDURE Update_Imp_Doc_Con(
311: p_api_version_number IN NUMBER,
312: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
313: p_commit IN VARCHAR2 := FND_API.G_FALSE,
314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
315:
316: x_return_status OUT NOCOPY VARCHAR2,
317: x_msg_count OUT NOCOPY NUMBER,

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

310: PROCEDURE Update_Imp_Doc_Con(
311: p_api_version_number IN NUMBER,
312: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
313: p_commit IN VARCHAR2 := FND_API.G_FALSE,
314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
315:
316: x_return_status OUT NOCOPY VARCHAR2,
317: x_msg_count OUT NOCOPY NUMBER,
318: x_msg_data OUT NOCOPY VARCHAR2,

Line 348: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

344: -- Standard Start of API savepoint
345: SAVEPOINT update_imp_doc_pvt;
346:
347: -- Standard call to check for call compatibility.
348: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
349: p_api_version_number,
350: l_api_name,
351: G_PKG_NAME)
352: THEN

Line 353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

349: p_api_version_number,
350: l_api_name,
351: G_PKG_NAME)
352: THEN
353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
354: END IF;
355:
356:
357: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 358: IF FND_API.to_Boolean( p_init_msg_list )

354: END IF;
355:
356:
357: -- Initialize message list if p_init_msg_list is set to TRUE.
358: IF FND_API.to_Boolean( p_init_msg_list )
359: THEN
360: FND_MSG_PUB.initialize;
361: END IF;
362:

Line 374: x_return_status := FND_API.G_RET_STS_SUCCESS;

370:
371:
372:
373: -- Initialize API return status to SUCCESS
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375:
376: -- Debug Message
377: IF (AMS_DEBUG_HIGH_ON) THEN
378:

Line 390: RAISE FND_API.G_EXC_ERROR;

386: If ( c_get_Imp_Doc%NOTFOUND) THEN
387: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
388: p_token_name => 'INFO',
389: p_token_value => 'Imp_Doc') ;
390: RAISE FND_API.G_EXC_ERROR;
391: END IF;
392: -- Debug Message
393: IF (AMS_DEBUG_HIGH_ON) THEN
394:

Line 401: l_tar_imp_doc_rec.object_version_number = FND_API.G_MISS_NUM ) Then

397: CLOSE c_get_Imp_Doc;
398:
399:
400: If (l_tar_imp_doc_rec.object_version_number is NULL or
401: l_tar_imp_doc_rec.object_version_number = FND_API.G_MISS_NUM ) Then
402: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
403: p_token_name => 'COLUMN',
404: p_token_value => 'Last_Update_Date') ;
405: raise FND_API.G_EXC_ERROR;

Line 405: raise FND_API.G_EXC_ERROR;

401: l_tar_imp_doc_rec.object_version_number = FND_API.G_MISS_NUM ) Then
402: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
403: p_token_name => 'COLUMN',
404: p_token_value => 'Last_Update_Date') ;
405: raise FND_API.G_EXC_ERROR;
406: End if;
407: -- Check Whether record has been changed by someone else
408: If (l_tar_imp_doc_rec.object_version_number <> l_ref_imp_doc_rec.object_version_number) Then
409: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

Line 412: raise FND_API.G_EXC_ERROR;

408: If (l_tar_imp_doc_rec.object_version_number <> l_ref_imp_doc_rec.object_version_number) Then
409: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
410: p_token_name => 'INFO',
411: p_token_value => 'Imp_Doc') ;
412: raise FND_API.G_EXC_ERROR;
413: End if;
414:
415:
416: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

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

412: raise FND_API.G_EXC_ERROR;
413: End if;
414:
415:
416: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
417: THEN
418: -- Debug message
419: IF (AMS_DEBUG_HIGH_ON) THEN
420:

Line 427: p_init_msg_list => FND_API.G_FALSE,

423:
424: -- Invoke validation procedures
425: Validate_imp_doc(
426: p_api_version_number => 1.0,
427: p_init_msg_list => FND_API.G_FALSE,
428: p_validation_level => p_validation_level,
429: p_validation_mode => JTF_PLSQL_API.g_update,
430: p_imp_doc_rec => p_imp_doc_rec,
431: x_return_status => x_return_status,

Line 436: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

432: x_msg_count => x_msg_count,
433: x_msg_data => x_msg_data);
434: END IF;
435:
436: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
437: RAISE FND_API.G_EXC_ERROR;
438: END IF;
439:
440:

Line 437: RAISE FND_API.G_EXC_ERROR;

433: x_msg_data => x_msg_data);
434: END IF;
435:
436: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
437: RAISE FND_API.G_EXC_ERROR;
438: END IF;
439:
440:
441: -- Debug Message

Line 463: IF FND_API.to_Boolean( p_commit )

459: -- End of API body.
460: --
461:
462: -- Standard check for p_commit
463: IF FND_API.to_Boolean( p_commit )
464: THEN
465: COMMIT WORK;
466: END IF;
467:

Line 484: x_return_status := FND_API.g_ret_sts_error;

480: );
481: EXCEPTION
482:
483: WHEN AMS_Utility_PVT.resource_locked THEN
484: x_return_status := FND_API.g_ret_sts_error;
485: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
486:
487: WHEN FND_API.G_EXC_ERROR THEN
488: ROLLBACK TO UPDATE_Imp_Doc_PVT;

Line 487: WHEN FND_API.G_EXC_ERROR THEN

483: WHEN AMS_Utility_PVT.resource_locked THEN
484: x_return_status := FND_API.g_ret_sts_error;
485: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
486:
487: WHEN FND_API.G_EXC_ERROR THEN
488: ROLLBACK TO UPDATE_Imp_Doc_PVT;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: -- Standard call to get message count and if count=1, get the message
491: FND_MSG_PUB.Count_And_Get (

Line 489: x_return_status := FND_API.G_RET_STS_ERROR;

485: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
486:
487: WHEN FND_API.G_EXC_ERROR THEN
488: ROLLBACK TO UPDATE_Imp_Doc_PVT;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: -- Standard call to get message count and if count=1, get the message
491: FND_MSG_PUB.Count_And_Get (
492: p_encoded => FND_API.G_FALSE,
493: p_count => x_msg_count,

Line 492: p_encoded => FND_API.G_FALSE,

488: ROLLBACK TO UPDATE_Imp_Doc_PVT;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: -- Standard call to get message count and if count=1, get the message
491: FND_MSG_PUB.Count_And_Get (
492: p_encoded => FND_API.G_FALSE,
493: p_count => x_msg_count,
494: p_data => x_msg_data
495: );
496:

Line 497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

493: p_count => x_msg_count,
494: p_data => x_msg_data
495: );
496:
497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
498: ROLLBACK TO UPDATE_Imp_Doc_PVT;
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: -- Standard call to get message count and if count=1, get the message
501: FND_MSG_PUB.Count_And_Get (

Line 499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

495: );
496:
497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
498: ROLLBACK TO UPDATE_Imp_Doc_PVT;
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: -- Standard call to get message count and if count=1, get the message
501: FND_MSG_PUB.Count_And_Get (
502: p_encoded => FND_API.G_FALSE,
503: p_count => x_msg_count,

Line 502: p_encoded => FND_API.G_FALSE,

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

Line 509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

505: );
506:
507: WHEN OTHERS THEN
508: ROLLBACK TO UPDATE_Imp_Doc_PVT;
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
511: THEN
512: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
513: END IF;

Line 516: p_encoded => FND_API.G_FALSE,

512: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
513: END IF;
514: -- Standard call to get message count and if count=1, get the message
515: FND_MSG_PUB.Count_And_Get (
516: p_encoded => FND_API.G_FALSE,
517: p_count => x_msg_count,
518: p_data => x_msg_data
519: );
520: End Update_Imp_Doc_Con;

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

532: -- Parameters
533: --
534: -- IN
535: -- p_api_version_number IN NUMBER Required
536: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
537: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
538: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
539: -- p_imp_document_id IN NUMBER
540: -- p_object_version_number IN NUMBER Optional Default = NULL

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

533: --
534: -- IN
535: -- p_api_version_number IN NUMBER Required
536: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
537: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
538: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
539: -- p_imp_document_id IN NUMBER
540: -- p_object_version_number IN NUMBER Optional Default = NULL
541: --

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

534: -- IN
535: -- p_api_version_number IN NUMBER Required
536: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
537: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
538: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
539: -- p_imp_document_id IN NUMBER
540: -- p_object_version_number IN NUMBER Optional Default = NULL
541: --
542: -- OUT

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

555: -- ==============================================================================
556:
557: PROCEDURE Delete_Imp_Doc_Con(
558: p_api_version_number IN NUMBER,
559: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
560: p_commit IN VARCHAR2 := FND_API.G_FALSE,
561: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
562: x_return_status OUT NOCOPY VARCHAR2,
563: x_msg_count OUT NOCOPY NUMBER,

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

556:
557: PROCEDURE Delete_Imp_Doc_Con(
558: p_api_version_number IN NUMBER,
559: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
560: p_commit IN VARCHAR2 := FND_API.G_FALSE,
561: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
562: x_return_status OUT NOCOPY VARCHAR2,
563: x_msg_count OUT NOCOPY NUMBER,
564: x_msg_data OUT NOCOPY VARCHAR2,

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

557: PROCEDURE Delete_Imp_Doc_Con(
558: p_api_version_number IN NUMBER,
559: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
560: p_commit IN VARCHAR2 := FND_API.G_FALSE,
561: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
562: x_return_status OUT NOCOPY VARCHAR2,
563: x_msg_count OUT NOCOPY NUMBER,
564: x_msg_data OUT NOCOPY VARCHAR2,
565: p_imp_doccontent_id IN NUMBER,

Line 579: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

575: -- Standard Start of API savepoint
576: SAVEPOINT delete_imp_doc_pvt;
577:
578: -- Standard call to check for call compatibility.
579: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
580: p_api_version_number,
581: l_api_name,
582: G_PKG_NAME)
583: THEN

Line 584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

580: p_api_version_number,
581: l_api_name,
582: G_PKG_NAME)
583: THEN
584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
585: END IF;
586:
587:
588: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 589: IF FND_API.to_Boolean( p_init_msg_list )

585: END IF;
586:
587:
588: -- Initialize message list if p_init_msg_list is set to TRUE.
589: IF FND_API.to_Boolean( p_init_msg_list )
590: THEN
591: FND_MSG_PUB.initialize;
592: END IF;
593:

Line 605: x_return_status := FND_API.G_RET_STS_SUCCESS;

601:
602:
603:
604: -- Initialize API return status to SUCCESS
605: x_return_status := FND_API.G_RET_STS_SUCCESS;
606:
607: --
608: -- Api body
609: --

Line 625: IF FND_API.to_Boolean( p_commit )

621: -- End of API body
622: --
623:
624: -- Standard check for p_commit
625: IF FND_API.to_Boolean( p_commit )
626: THEN
627: COMMIT WORK;
628: END IF;
629:

Line 646: x_return_status := FND_API.g_ret_sts_error;

642: );
643: EXCEPTION
644:
645: WHEN AMS_Utility_PVT.resource_locked THEN
646: x_return_status := FND_API.g_ret_sts_error;
647: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
648:
649: WHEN FND_API.G_EXC_ERROR THEN
650: ROLLBACK TO DELETE_Imp_Doc_PVT;

Line 649: WHEN FND_API.G_EXC_ERROR THEN

645: WHEN AMS_Utility_PVT.resource_locked THEN
646: x_return_status := FND_API.g_ret_sts_error;
647: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
648:
649: WHEN FND_API.G_EXC_ERROR THEN
650: ROLLBACK TO DELETE_Imp_Doc_PVT;
651: x_return_status := FND_API.G_RET_STS_ERROR;
652: -- Standard call to get message count and if count=1, get the message
653: FND_MSG_PUB.Count_And_Get (

Line 651: x_return_status := FND_API.G_RET_STS_ERROR;

647: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
648:
649: WHEN FND_API.G_EXC_ERROR THEN
650: ROLLBACK TO DELETE_Imp_Doc_PVT;
651: x_return_status := FND_API.G_RET_STS_ERROR;
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,

Line 654: p_encoded => FND_API.G_FALSE,

650: ROLLBACK TO DELETE_Imp_Doc_PVT;
651: x_return_status := FND_API.G_RET_STS_ERROR;
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:

Line 659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

655: p_count => x_msg_count,
656: p_data => x_msg_data
657: );
658:
659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
660: ROLLBACK TO DELETE_Imp_Doc_PVT;
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: -- Standard call to get message count and if count=1, get the message
663: FND_MSG_PUB.Count_And_Get (

Line 661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

657: );
658:
659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
660: ROLLBACK TO DELETE_Imp_Doc_PVT;
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: -- Standard call to get message count and if count=1, get the message
663: FND_MSG_PUB.Count_And_Get (
664: p_encoded => FND_API.G_FALSE,
665: p_count => x_msg_count,

Line 664: p_encoded => FND_API.G_FALSE,

660: ROLLBACK TO DELETE_Imp_Doc_PVT;
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: -- Standard call to get message count and if count=1, get the message
663: FND_MSG_PUB.Count_And_Get (
664: p_encoded => FND_API.G_FALSE,
665: p_count => x_msg_count,
666: p_data => x_msg_data
667: );
668:

Line 671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

667: );
668:
669: WHEN OTHERS THEN
670: ROLLBACK TO DELETE_Imp_Doc_PVT;
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
673: THEN
674: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
675: END IF;

Line 678: p_encoded => FND_API.G_FALSE,

674: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
675: END IF;
676: -- Standard call to get message count and if count=1, get the message
677: FND_MSG_PUB.Count_And_Get (
678: p_encoded => FND_API.G_FALSE,
679: p_count => x_msg_count,
680: p_data => x_msg_data
681: );
682: End Delete_Imp_Doc_Con;

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

696: -- Parameters
697: --
698: -- IN
699: -- p_api_version_number IN NUMBER Required
700: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
701: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
702: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
703: -- p_imp_doc_rec IN imp_doccon_rec_type Required
704: --

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

697: --
698: -- IN
699: -- p_api_version_number IN NUMBER Required
700: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
701: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
702: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
703: -- p_imp_doc_rec IN imp_doccon_rec_type Required
704: --
705: -- OUT

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

698: -- IN
699: -- p_api_version_number IN NUMBER Required
700: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
701: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
702: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
703: -- p_imp_doc_rec IN imp_doccon_rec_type Required
704: --
705: -- OUT
706: -- x_return_status OUT VARCHAR2

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

718: -- ==============================================================================
719:
720: PROCEDURE Lock_Imp_Doc_Con(
721: p_api_version_number IN NUMBER,
722: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
723:
724: x_return_status OUT NOCOPY VARCHAR2,
725: x_msg_count OUT NOCOPY NUMBER,
726: x_msg_data OUT NOCOPY VARCHAR2,

Line 755: IF FND_API.to_Boolean( p_init_msg_list )

751: END IF;
752:
753:
754: -- Initialize message list if p_init_msg_list is set to TRUE.
755: IF FND_API.to_Boolean( p_init_msg_list )
756: THEN
757: FND_MSG_PUB.initialize;
758: END IF;
759:

Line 763: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

759:
760:
761:
762: -- Standard call to check for call compatibility.
763: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
764: p_api_version_number,
765: l_api_name,
766: G_PKG_NAME)
767: THEN

Line 768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

764: p_api_version_number,
765: l_api_name,
766: G_PKG_NAME)
767: THEN
768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
769: END IF;
770:
771:
772:

Line 774: x_return_status := FND_API.G_RET_STS_SUCCESS;

770:
771:
772:
773: -- Initialize API return status to SUCCESS
774: x_return_status := FND_API.G_RET_STS_SUCCESS;
775:
776:
777: ------------------------ lock -------------------------
778:

Line 796: RAISE FND_API.g_exc_error;

792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
793: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
794: FND_MSG_PUB.add;
795: END IF;
796: RAISE FND_API.g_exc_error;
797: END IF;
798:
799: CLOSE c_imp_doc;
800:

Line 803: p_encoded => FND_API.g_false,

799: CLOSE c_imp_doc;
800:
801: -------------------- finish --------------------------
802: FND_MSG_PUB.count_and_get(
803: p_encoded => FND_API.g_false,
804: p_count => x_msg_count,
805: p_data => x_msg_data);
806: IF (AMS_DEBUG_HIGH_ON) THEN
807:

Line 813: x_return_status := FND_API.g_ret_sts_error;

809: END IF;
810: EXCEPTION
811:
812: WHEN AMS_Utility_PVT.resource_locked THEN
813: x_return_status := FND_API.g_ret_sts_error;
814: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
815:
816: WHEN FND_API.G_EXC_ERROR THEN
817: ROLLBACK TO LOCK_Imp_Doc_PVT;

Line 816: WHEN FND_API.G_EXC_ERROR THEN

812: WHEN AMS_Utility_PVT.resource_locked THEN
813: x_return_status := FND_API.g_ret_sts_error;
814: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
815:
816: WHEN FND_API.G_EXC_ERROR THEN
817: ROLLBACK TO LOCK_Imp_Doc_PVT;
818: x_return_status := FND_API.G_RET_STS_ERROR;
819: -- Standard call to get message count and if count=1, get the message
820: FND_MSG_PUB.Count_And_Get (

Line 818: x_return_status := FND_API.G_RET_STS_ERROR;

814: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
815:
816: WHEN FND_API.G_EXC_ERROR THEN
817: ROLLBACK TO LOCK_Imp_Doc_PVT;
818: x_return_status := FND_API.G_RET_STS_ERROR;
819: -- Standard call to get message count and if count=1, get the message
820: FND_MSG_PUB.Count_And_Get (
821: p_encoded => FND_API.G_FALSE,
822: p_count => x_msg_count,

Line 821: p_encoded => FND_API.G_FALSE,

817: ROLLBACK TO LOCK_Imp_Doc_PVT;
818: x_return_status := FND_API.G_RET_STS_ERROR;
819: -- Standard call to get message count and if count=1, get the message
820: FND_MSG_PUB.Count_And_Get (
821: p_encoded => FND_API.G_FALSE,
822: p_count => x_msg_count,
823: p_data => x_msg_data
824: );
825:

Line 826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

822: p_count => x_msg_count,
823: p_data => x_msg_data
824: );
825:
826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
827: ROLLBACK TO LOCK_Imp_Doc_PVT;
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829: -- Standard call to get message count and if count=1, get the message
830: FND_MSG_PUB.Count_And_Get (

Line 828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

824: );
825:
826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
827: ROLLBACK TO LOCK_Imp_Doc_PVT;
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829: -- Standard call to get message count and if count=1, get the message
830: FND_MSG_PUB.Count_And_Get (
831: p_encoded => FND_API.G_FALSE,
832: p_count => x_msg_count,

Line 831: p_encoded => FND_API.G_FALSE,

827: ROLLBACK TO LOCK_Imp_Doc_PVT;
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829: -- Standard call to get message count and if count=1, get the message
830: FND_MSG_PUB.Count_And_Get (
831: p_encoded => FND_API.G_FALSE,
832: p_count => x_msg_count,
833: p_data => x_msg_data
834: );
835:

Line 838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

834: );
835:
836: WHEN OTHERS THEN
837: ROLLBACK TO LOCK_Imp_Doc_PVT;
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
840: THEN
841: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
842: END IF;

Line 845: p_encoded => FND_API.G_FALSE,

841: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
842: END IF;
843: -- Standard call to get message count and if count=1, get the message
844: FND_MSG_PUB.Count_And_Get (
845: p_encoded => FND_API.G_FALSE,
846: p_count => x_msg_count,
847: p_data => x_msg_data
848: );
849: End Lock_Imp_Doc_Con;

Line 876: x_return_status := FND_API.g_ret_sts_success;

872: IS
873: l_valid_flag VARCHAR2(1);
874:
875: BEGIN
876: x_return_status := FND_API.g_ret_sts_success;
877: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
878: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
879: 'ams_imp_doc_content',
880: 'imp_doc_content_id = ''' || p_imp_doc_rec.imp_doc_content_id ||''''

Line 890: IF l_valid_flag = FND_API.g_false THEN

886: ''' AND imp_doc_content_id <> ' || p_imp_doc_rec.imp_doc_content_id
887: );
888: END IF;
889:
890: IF l_valid_flag = FND_API.g_false THEN
891: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_imp_document_id_DUPLICATE');
892: x_return_status := FND_API.g_ret_sts_error;
893: RETURN;
894: END IF;

Line 892: x_return_status := FND_API.g_ret_sts_error;

888: END IF;
889:
890: IF l_valid_flag = FND_API.g_false THEN
891: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_imp_document_id_DUPLICATE');
892: x_return_status := FND_API.g_ret_sts_error;
893: RETURN;
894: END IF;
895:
896: END check_Imp_Doc_Uk_Items;

Line 907: x_return_status := FND_API.g_ret_sts_success;

903: x_return_status OUT NOCOPY VARCHAR2
904: )
905: IS
906: BEGIN
907: x_return_status := FND_API.g_ret_sts_success;
908:
909: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
910:
911:

Line 912: IF p_imp_doc_rec.imp_doc_content_id = FND_API.G_MISS_NUM OR p_imp_doc_rec.imp_doc_content_id IS NULL THEN

908:
909: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
910:
911:
912: IF p_imp_doc_rec.imp_doc_content_id = FND_API.G_MISS_NUM OR p_imp_doc_rec.imp_doc_content_id IS NULL THEN
913: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
914: FND_MESSAGE.set_token('MISS_FIELD', 'imp_doc_content_id' );
915: x_return_status := FND_API.g_ret_sts_error;
916: END IF;

Line 915: x_return_status := FND_API.g_ret_sts_error;

911:
912: IF p_imp_doc_rec.imp_doc_content_id = FND_API.G_MISS_NUM OR p_imp_doc_rec.imp_doc_content_id IS NULL THEN
913: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
914: FND_MESSAGE.set_token('MISS_FIELD', 'imp_doc_content_id' );
915: x_return_status := FND_API.g_ret_sts_error;
916: END IF;
917:
918:
919: IF p_imp_doc_rec.last_updated_by = FND_API.G_MISS_NUM OR p_imp_doc_rec.last_updated_by IS NULL THEN

Line 919: IF p_imp_doc_rec.last_updated_by = FND_API.G_MISS_NUM OR p_imp_doc_rec.last_updated_by IS NULL THEN

915: x_return_status := FND_API.g_ret_sts_error;
916: END IF;
917:
918:
919: IF p_imp_doc_rec.last_updated_by = FND_API.G_MISS_NUM OR p_imp_doc_rec.last_updated_by IS NULL THEN
920: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
921: FND_MESSAGE.set_token('MISS_FIELD', 'LAST_UPDATED_BY' );
922: x_return_status := FND_API.g_ret_sts_error;
923: END IF;

Line 922: x_return_status := FND_API.g_ret_sts_error;

918:
919: IF p_imp_doc_rec.last_updated_by = FND_API.G_MISS_NUM OR p_imp_doc_rec.last_updated_by IS NULL THEN
920: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
921: FND_MESSAGE.set_token('MISS_FIELD', 'LAST_UPDATED_BY' );
922: x_return_status := FND_API.g_ret_sts_error;
923: END IF;
924:
925:
926: IF p_imp_doc_rec.created_by = FND_API.G_MISS_NUM OR p_imp_doc_rec.created_by IS NULL THEN

Line 926: IF p_imp_doc_rec.created_by = FND_API.G_MISS_NUM OR p_imp_doc_rec.created_by IS NULL THEN

922: x_return_status := FND_API.g_ret_sts_error;
923: END IF;
924:
925:
926: IF p_imp_doc_rec.created_by = FND_API.G_MISS_NUM OR p_imp_doc_rec.created_by IS NULL THEN
927: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
928: FND_MESSAGE.set_token('MISS_FIELD', 'CREATED_BY' );
929: x_return_status := FND_API.g_ret_sts_error;
930: END IF;

Line 929: x_return_status := FND_API.g_ret_sts_error;

925:
926: IF p_imp_doc_rec.created_by = FND_API.G_MISS_NUM OR p_imp_doc_rec.created_by IS NULL THEN
927: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
928: FND_MESSAGE.set_token('MISS_FIELD', 'CREATED_BY' );
929: x_return_status := FND_API.g_ret_sts_error;
930: END IF;
931:
932:
933: IF p_imp_doc_rec.last_update_login = FND_API.G_MISS_NUM OR p_imp_doc_rec.last_update_login IS NULL THEN

Line 933: IF p_imp_doc_rec.last_update_login = FND_API.G_MISS_NUM OR p_imp_doc_rec.last_update_login IS NULL THEN

929: x_return_status := FND_API.g_ret_sts_error;
930: END IF;
931:
932:
933: IF p_imp_doc_rec.last_update_login = FND_API.G_MISS_NUM OR p_imp_doc_rec.last_update_login IS NULL THEN
934: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
935: FND_MESSAGE.set_token('MISS_FIELD', 'LAST_UPDATE_LOGIN' );
936: x_return_status := FND_API.g_ret_sts_error;
937: END IF;

Line 936: x_return_status := FND_API.g_ret_sts_error;

932:
933: IF p_imp_doc_rec.last_update_login = FND_API.G_MISS_NUM OR p_imp_doc_rec.last_update_login IS NULL THEN
934: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
935: FND_MESSAGE.set_token('MISS_FIELD', 'LAST_UPDATE_LOGIN' );
936: x_return_status := FND_API.g_ret_sts_error;
937: END IF;
938:
939:
940: IF p_imp_doc_rec.last_update_date = FND_API.G_MISS_DATE OR p_imp_doc_rec.last_update_date IS NULL THEN

Line 940: IF p_imp_doc_rec.last_update_date = FND_API.G_MISS_DATE OR p_imp_doc_rec.last_update_date IS NULL THEN

936: x_return_status := FND_API.g_ret_sts_error;
937: END IF;
938:
939:
940: IF p_imp_doc_rec.last_update_date = FND_API.G_MISS_DATE OR p_imp_doc_rec.last_update_date IS NULL THEN
941: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
942: FND_MESSAGE.set_token('MISS_FIELD', 'LAST_UPDATE_DATE' );
943: x_return_status := FND_API.g_ret_sts_error;
944: END IF;

Line 943: x_return_status := FND_API.g_ret_sts_error;

939:
940: IF p_imp_doc_rec.last_update_date = FND_API.G_MISS_DATE OR p_imp_doc_rec.last_update_date IS NULL THEN
941: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
942: FND_MESSAGE.set_token('MISS_FIELD', 'LAST_UPDATE_DATE' );
943: x_return_status := FND_API.g_ret_sts_error;
944: END IF;
945:
946:
947: IF p_imp_doc_rec.creation_date = FND_API.G_MISS_DATE OR p_imp_doc_rec.creation_date IS NULL THEN

Line 947: IF p_imp_doc_rec.creation_date = FND_API.G_MISS_DATE OR p_imp_doc_rec.creation_date IS NULL THEN

943: x_return_status := FND_API.g_ret_sts_error;
944: END IF;
945:
946:
947: IF p_imp_doc_rec.creation_date = FND_API.G_MISS_DATE OR p_imp_doc_rec.creation_date IS NULL THEN
948: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
949: FND_MESSAGE.set_token('MISS_FIELD', 'CREATION_DATE' );
950: x_return_status := FND_API.g_ret_sts_error;
951: END IF;

Line 950: x_return_status := FND_API.g_ret_sts_error;

946:
947: IF p_imp_doc_rec.creation_date = FND_API.G_MISS_DATE OR p_imp_doc_rec.creation_date IS NULL THEN
948: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
949: FND_MESSAGE.set_token('MISS_FIELD', 'CREATION_DATE' );
950: x_return_status := FND_API.g_ret_sts_error;
951: END IF;
952:
953:
954: IF p_imp_doc_rec.import_list_header_id = FND_API.G_MISS_NUM OR p_imp_doc_rec.import_list_header_id IS NULL THEN

Line 954: IF p_imp_doc_rec.import_list_header_id = FND_API.G_MISS_NUM OR p_imp_doc_rec.import_list_header_id IS NULL THEN

950: x_return_status := FND_API.g_ret_sts_error;
951: END IF;
952:
953:
954: IF p_imp_doc_rec.import_list_header_id = FND_API.G_MISS_NUM OR p_imp_doc_rec.import_list_header_id IS NULL THEN
955: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
956: FND_MESSAGE.set_token('MISS_FIELD', 'IMPORT_LIST_HEADER_ID' );
957: x_return_status := FND_API.g_ret_sts_error;
958: END IF;

Line 957: x_return_status := FND_API.g_ret_sts_error;

953:
954: IF p_imp_doc_rec.import_list_header_id = FND_API.G_MISS_NUM OR p_imp_doc_rec.import_list_header_id IS NULL THEN
955: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
956: FND_MESSAGE.set_token('MISS_FIELD', 'IMPORT_LIST_HEADER_ID' );
957: x_return_status := FND_API.g_ret_sts_error;
958: END IF;
959:
960:
961: ELSE

Line 964: IF p_imp_doc_rec.imp_doc_content_id = FND_API.G_MISS_NUM THEN

960:
961: ELSE
962:
963:
964: IF p_imp_doc_rec.imp_doc_content_id = FND_API.G_MISS_NUM THEN
965: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
966: FND_MESSAGE.set_token('MISS_FIELD', 'imp_doc_content_id' );
967: x_return_status := FND_API.g_ret_sts_error;
968: RETURN;

Line 967: x_return_status := FND_API.g_ret_sts_error;

963:
964: IF p_imp_doc_rec.imp_doc_content_id = FND_API.G_MISS_NUM THEN
965: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
966: FND_MESSAGE.set_token('MISS_FIELD', 'imp_doc_content_id' );
967: x_return_status := FND_API.g_ret_sts_error;
968: RETURN;
969: END IF;
970:
971:

Line 972: IF p_imp_doc_rec.last_updated_by = FND_API.G_MISS_NUM THEN

968: RETURN;
969: END IF;
970:
971:
972: IF p_imp_doc_rec.last_updated_by = FND_API.G_MISS_NUM THEN
973: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
974: FND_MESSAGE.set_token('MISS_FIELD', 'LAST_UPDATED_BY' );
975: x_return_status := FND_API.g_ret_sts_error;
976: RETURN;

Line 975: x_return_status := FND_API.g_ret_sts_error;

971:
972: IF p_imp_doc_rec.last_updated_by = FND_API.G_MISS_NUM THEN
973: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
974: FND_MESSAGE.set_token('MISS_FIELD', 'LAST_UPDATED_BY' );
975: x_return_status := FND_API.g_ret_sts_error;
976: RETURN;
977: END IF;
978:
979:

Line 980: IF p_imp_doc_rec.created_by = FND_API.G_MISS_NUM THEN

976: RETURN;
977: END IF;
978:
979:
980: IF p_imp_doc_rec.created_by = FND_API.G_MISS_NUM THEN
981: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
982: FND_MESSAGE.set_token('MISS_FIELD', 'CREATED_BY' );
983: x_return_status := FND_API.g_ret_sts_error;
984: RETURN;

Line 983: x_return_status := FND_API.g_ret_sts_error;

979:
980: IF p_imp_doc_rec.created_by = FND_API.G_MISS_NUM THEN
981: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
982: FND_MESSAGE.set_token('MISS_FIELD', 'CREATED_BY' );
983: x_return_status := FND_API.g_ret_sts_error;
984: RETURN;
985: END IF;
986:
987:

Line 988: IF p_imp_doc_rec.last_update_login = FND_API.G_MISS_NUM THEN

984: RETURN;
985: END IF;
986:
987:
988: IF p_imp_doc_rec.last_update_login = FND_API.G_MISS_NUM THEN
989: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
990: FND_MESSAGE.set_token('MISS_FIELD', 'LAST_UPDATE_LOGIN' );
991: x_return_status := FND_API.g_ret_sts_error;
992: RETURN;

Line 991: x_return_status := FND_API.g_ret_sts_error;

987:
988: IF p_imp_doc_rec.last_update_login = FND_API.G_MISS_NUM THEN
989: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
990: FND_MESSAGE.set_token('MISS_FIELD', 'LAST_UPDATE_LOGIN' );
991: x_return_status := FND_API.g_ret_sts_error;
992: RETURN;
993: END IF;
994:
995:

Line 996: IF p_imp_doc_rec.last_update_date = FND_API.G_MISS_DATE THEN

992: RETURN;
993: END IF;
994:
995:
996: IF p_imp_doc_rec.last_update_date = FND_API.G_MISS_DATE THEN
997: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
998: FND_MESSAGE.set_token('MISS_FIELD', 'LAST_UPDATE_DATE' );
999: x_return_status := FND_API.g_ret_sts_error;
1000: RETURN;

Line 999: x_return_status := FND_API.g_ret_sts_error;

995:
996: IF p_imp_doc_rec.last_update_date = FND_API.G_MISS_DATE THEN
997: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
998: FND_MESSAGE.set_token('MISS_FIELD', 'LAST_UPDATE_DATE' );
999: x_return_status := FND_API.g_ret_sts_error;
1000: RETURN;
1001: END IF;
1002:
1003:

Line 1004: IF p_imp_doc_rec.creation_date = FND_API.G_MISS_DATE THEN

1000: RETURN;
1001: END IF;
1002:
1003:
1004: IF p_imp_doc_rec.creation_date = FND_API.G_MISS_DATE THEN
1005: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
1006: FND_MESSAGE.set_token('MISS_FIELD', 'CREATION_DATE' );
1007: x_return_status := FND_API.g_ret_sts_error;
1008: RETURN;

Line 1007: x_return_status := FND_API.g_ret_sts_error;

1003:
1004: IF p_imp_doc_rec.creation_date = FND_API.G_MISS_DATE THEN
1005: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
1006: FND_MESSAGE.set_token('MISS_FIELD', 'CREATION_DATE' );
1007: x_return_status := FND_API.g_ret_sts_error;
1008: RETURN;
1009: END IF;
1010:
1011:

Line 1012: IF p_imp_doc_rec.import_list_header_id = FND_API.G_MISS_NUM THEN

1008: RETURN;
1009: END IF;
1010:
1011:
1012: IF p_imp_doc_rec.import_list_header_id = FND_API.G_MISS_NUM THEN
1013: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
1014: FND_MESSAGE.set_token('MISS_FIELD', 'IMPORT_LIST_HEADER_ID' );
1015: x_return_status := FND_API.g_ret_sts_error;
1016: RETURN;

Line 1015: x_return_status := FND_API.g_ret_sts_error;

1011:
1012: IF p_imp_doc_rec.import_list_header_id = FND_API.G_MISS_NUM THEN
1013: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');
1014: FND_MESSAGE.set_token('MISS_FIELD', 'IMPORT_LIST_HEADER_ID' );
1015: x_return_status := FND_API.g_ret_sts_error;
1016: RETURN;
1017: END IF;
1018: END IF;
1019:

Line 1030: x_return_status := FND_API.g_ret_sts_success;

1026: x_return_status OUT NOCOPY VARCHAR2
1027: )
1028: IS
1029: BEGIN
1030: x_return_status := FND_API.g_ret_sts_success;
1031:
1032: -- Enter custom code here
1033:
1034: END check_Imp_Doc_Fk_Items;

Line 1044: x_return_status := FND_API.g_ret_sts_success;

1040: x_return_status OUT NOCOPY VARCHAR2
1041: )
1042: IS
1043: BEGIN
1044: x_return_status := FND_API.g_ret_sts_success;
1045:
1046: -- Enter custom code here
1047:
1048: END check_Imp_Doc_Lookup_Items;

Line 1066: IF x_return_status <> FND_API.g_ret_sts_success THEN

1062: check_Imp_doc_Uk_Items(
1063: p_imp_doc_rec => p_imp_doc_rec,
1064: p_validation_mode => p_validation_mode,
1065: x_return_status => x_return_status);
1066: IF x_return_status <> FND_API.g_ret_sts_success THEN
1067: RETURN;
1068: END IF;
1069:
1070: -- Check Items Required/NOT NULL API calls

Line 1076: IF x_return_status <> FND_API.g_ret_sts_success THEN

1072: check_imp_doc_req_items(
1073: p_imp_doc_rec => p_imp_doc_rec,
1074: p_validation_mode => p_validation_mode,
1075: x_return_status => x_return_status);
1076: IF x_return_status <> FND_API.g_ret_sts_success THEN
1077: RETURN;
1078: END IF;
1079: -- Check Items Foreign Keys API calls
1080:

Line 1084: IF x_return_status <> FND_API.g_ret_sts_success THEN

1080:
1081: check_imp_doc_FK_items(
1082: p_imp_doc_rec => p_imp_doc_rec,
1083: x_return_status => x_return_status);
1084: IF x_return_status <> FND_API.g_ret_sts_success THEN
1085: RETURN;
1086: END IF;
1087: -- Check Items Lookups
1088:

Line 1092: IF x_return_status <> FND_API.g_ret_sts_success THEN

1088:
1089: check_imp_doc_Lookup_items(
1090: p_imp_doc_rec => p_imp_doc_rec,
1091: x_return_status => x_return_status);
1092: IF x_return_status <> FND_API.g_ret_sts_success THEN
1093: RETURN;
1094: END IF;
1095:
1096: END Check_imp_doc_Items;

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

1225: l_imp_doc_rec imp_doccon_rec_type := p_imp_doc_rec;
1226: BEGIN
1227: -- Developers should put their code to default the record type
1228: -- e.g. IF p_campaign_rec.status_code IS NULL
1229: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN
1230: -- l_campaign_rec.status_code := 'NEW' ;
1231: -- END IF ;
1232: --
1233: NULL ;

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

1237:
1238:
1239: PROCEDURE Validate_Imp_Doc(
1240: p_api_version_number IN NUMBER,
1241: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1243: p_imp_doc_rec IN imp_doccon_rec_type,
1244: p_validation_mode IN VARCHAR2,
1245: x_return_status OUT NOCOPY VARCHAR2,

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

1238:
1239: PROCEDURE Validate_Imp_Doc(
1240: p_api_version_number IN NUMBER,
1241: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1243: p_imp_doc_rec IN imp_doccon_rec_type,
1244: p_validation_mode IN VARCHAR2,
1245: x_return_status OUT NOCOPY VARCHAR2,
1246: x_msg_count OUT NOCOPY NUMBER,

Line 1260: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1256: -- Standard Start of API savepoint
1257: SAVEPOINT validate_imp_doc_;
1258:
1259: -- Standard call to check for call compatibility.
1260: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1261: p_api_version_number,
1262: l_api_name,
1263: G_PKG_NAME)
1264: THEN

Line 1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1261: p_api_version_number,
1262: l_api_name,
1263: G_PKG_NAME)
1264: THEN
1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266: END IF;
1267:
1268:
1269: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1270: IF FND_API.to_Boolean( p_init_msg_list )

1266: END IF;
1267:
1268:
1269: -- Initialize message list if p_init_msg_list is set to TRUE.
1270: IF FND_API.to_Boolean( p_init_msg_list )
1271: THEN
1272: FND_MSG_PUB.initialize;
1273: END IF;
1274:

Line 1283: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1279: p_validation_mode => p_validation_mode,
1280: x_return_status => x_return_status
1281: );
1282:
1283: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1284: RAISE FND_API.G_EXC_ERROR;
1285: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1287: END IF;

Line 1284: RAISE FND_API.G_EXC_ERROR;

1280: x_return_status => x_return_status
1281: );
1282:
1283: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1284: RAISE FND_API.G_EXC_ERROR;
1285: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1287: END IF;
1288: END IF;

Line 1285: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1281: );
1282:
1283: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1284: RAISE FND_API.G_EXC_ERROR;
1285: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1287: END IF;
1288: END IF;
1289:

Line 1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1282:
1283: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1284: RAISE FND_API.G_EXC_ERROR;
1285: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1287: END IF;
1288: END IF;
1289:
1290: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 1304: p_init_msg_list => FND_API.G_FALSE,

1300:
1301: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1302: Validate_imp_doc_Rec(
1303: p_api_version_number => 1.0,
1304: p_init_msg_list => FND_API.G_FALSE,
1305: x_return_status => x_return_status,
1306: x_msg_count => x_msg_count,
1307: x_msg_data => x_msg_data,
1308: p_imp_doc_rec => l_imp_doc_rec);

Line 1310: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1306: x_msg_count => x_msg_count,
1307: x_msg_data => x_msg_data,
1308: p_imp_doc_rec => l_imp_doc_rec);
1309:
1310: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1311: RAISE FND_API.G_EXC_ERROR;
1312: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1314: END IF;

Line 1311: RAISE FND_API.G_EXC_ERROR;

1307: x_msg_data => x_msg_data,
1308: p_imp_doc_rec => l_imp_doc_rec);
1309:
1310: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1311: RAISE FND_API.G_EXC_ERROR;
1312: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1314: END IF;
1315: END IF;

Line 1312: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1308: p_imp_doc_rec => l_imp_doc_rec);
1309:
1310: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1311: RAISE FND_API.G_EXC_ERROR;
1312: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1314: END IF;
1315: END IF;
1316:

Line 1313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1309:
1310: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1311: RAISE FND_API.G_EXC_ERROR;
1312: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1314: END IF;
1315: END IF;
1316:
1317:

Line 1327: x_return_status := FND_API.G_RET_STS_SUCCESS;

1323:
1324:
1325:
1326: -- Initialize API return status to SUCCESS
1327: x_return_status := FND_API.G_RET_STS_SUCCESS;
1328:
1329:
1330: -- Debug Message
1331: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1345: x_return_status := FND_API.g_ret_sts_error;

1341: );
1342: EXCEPTION
1343:
1344: WHEN AMS_Utility_PVT.resource_locked THEN
1345: x_return_status := FND_API.g_ret_sts_error;
1346: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1347:
1348: WHEN FND_API.G_EXC_ERROR THEN
1349: ROLLBACK TO VALIDATE_Imp_Doc_;

Line 1348: WHEN FND_API.G_EXC_ERROR THEN

1344: WHEN AMS_Utility_PVT.resource_locked THEN
1345: x_return_status := FND_API.g_ret_sts_error;
1346: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1347:
1348: WHEN FND_API.G_EXC_ERROR THEN
1349: ROLLBACK TO VALIDATE_Imp_Doc_;
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: -- Standard call to get message count and if count=1, get the message
1352: FND_MSG_PUB.Count_And_Get (

Line 1350: x_return_status := FND_API.G_RET_STS_ERROR;

1346: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1347:
1348: WHEN FND_API.G_EXC_ERROR THEN
1349: ROLLBACK TO VALIDATE_Imp_Doc_;
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: -- Standard call to get message count and if count=1, get the message
1352: FND_MSG_PUB.Count_And_Get (
1353: p_encoded => FND_API.G_FALSE,
1354: p_count => x_msg_count,

Line 1353: p_encoded => FND_API.G_FALSE,

1349: ROLLBACK TO VALIDATE_Imp_Doc_;
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: -- Standard call to get message count and if count=1, get the message
1352: FND_MSG_PUB.Count_And_Get (
1353: p_encoded => FND_API.G_FALSE,
1354: p_count => x_msg_count,
1355: p_data => x_msg_data
1356: );
1357:

Line 1358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1354: p_count => x_msg_count,
1355: p_data => x_msg_data
1356: );
1357:
1358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1359: ROLLBACK TO VALIDATE_Imp_Doc_;
1360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1361: -- Standard call to get message count and if count=1, get the message
1362: FND_MSG_PUB.Count_And_Get (

Line 1360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1356: );
1357:
1358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1359: ROLLBACK TO VALIDATE_Imp_Doc_;
1360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1361: -- Standard call to get message count and if count=1, get the message
1362: FND_MSG_PUB.Count_And_Get (
1363: p_encoded => FND_API.G_FALSE,
1364: p_count => x_msg_count,

Line 1363: p_encoded => FND_API.G_FALSE,

1359: ROLLBACK TO VALIDATE_Imp_Doc_;
1360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1361: -- Standard call to get message count and if count=1, get the message
1362: FND_MSG_PUB.Count_And_Get (
1363: p_encoded => FND_API.G_FALSE,
1364: p_count => x_msg_count,
1365: p_data => x_msg_data
1366: );
1367:

Line 1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1366: );
1367:
1368: WHEN OTHERS THEN
1369: ROLLBACK TO VALIDATE_Imp_Doc_;
1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1371: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1372: THEN
1373: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1374: END IF;

Line 1377: p_encoded => FND_API.G_FALSE,

1373: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1374: END IF;
1375: -- Standard call to get message count and if count=1, get the message
1376: FND_MSG_PUB.Count_And_Get (
1377: p_encoded => FND_API.G_FALSE,
1378: p_count => x_msg_count,
1379: p_data => x_msg_data
1380: );
1381: End Validate_Imp_Doc;

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

1382:
1383:
1384: PROCEDURE Validate_Imp_Doc_Rec (
1385: p_api_version_number IN NUMBER,
1386: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1387: x_return_status OUT NOCOPY VARCHAR2,
1388: x_msg_count OUT NOCOPY NUMBER,
1389: x_msg_data OUT NOCOPY VARCHAR2,
1390: p_imp_doc_rec IN imp_doccon_rec_type

Line 1395: IF FND_API.to_Boolean( p_init_msg_list )

1391: )
1392: IS
1393: BEGIN
1394: -- Initialize message list if p_init_msg_list is set to TRUE.
1395: IF FND_API.to_Boolean( p_init_msg_list )
1396: THEN
1397: FND_MSG_PUB.initialize;
1398: END IF;
1399:

Line 1403: x_return_status := FND_API.G_RET_STS_SUCCESS;

1399:
1400:
1401:
1402: -- Initialize API return status to SUCCESS
1403: x_return_status := FND_API.G_RET_STS_SUCCESS;
1404:
1405: -- Hint: Validate data
1406: -- If data not valid
1407: -- THEN

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

1404:
1405: -- Hint: Validate data
1406: -- If data not valid
1407: -- THEN
1408: -- x_return_status := FND_API.G_RET_STS_ERROR;
1409:
1410: -- Debug Message
1411: IF (AMS_DEBUG_HIGH_ON) THEN
1412: