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

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

23:
24: -- Hint: Primary key needs to be returned.
25: PROCEDURE Create_Fnd_Attachment(
26: p_api_version_number IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
30:
31: x_return_status OUT NOCOPY VARCHAR2,

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

24: -- Hint: Primary key needs to be returned.
25: PROCEDURE Create_Fnd_Attachment(
26: p_api_version_number IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
30:
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,

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

25: PROCEDURE Create_Fnd_Attachment(
26: p_api_version_number IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
30:
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,
33: x_msg_data OUT NOCOPY VARCHAR2,

Line 67: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

63: -- Standard Start of API savepoint
64: SAVEPOINT CREATE_Fnd_Attachment_PVT;
65:
66: -- Standard call to check for call compatibility.
67: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
68: p_api_version_number,
69: l_api_name,
70: G_PKG_NAME)
71: THEN

Line 72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

68: p_api_version_number,
69: l_api_name,
70: G_PKG_NAME)
71: THEN
72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
73: END IF;
74:
75: -- Initialize message list if p_init_msg_list is set to TRUE.
76: IF FND_API.to_Boolean( p_init_msg_list )

Line 76: IF FND_API.to_Boolean( p_init_msg_list )

72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
73: END IF;
74:
75: -- Initialize message list if p_init_msg_list is set to TRUE.
76: IF FND_API.to_Boolean( p_init_msg_list )
77: THEN
78: FND_MSG_PUB.initialize;
79: END IF;
80:

Line 88: x_return_status := FND_API.G_RET_STS_SUCCESS;

84: END IF;
85:
86:
87: -- Initialize API return status to SUCCESS
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89:
90: -- Local variable initialization
91:
92: -- =========================================================================

Line 99: RAISE FND_API.G_EXC_ERROR;

95:
96: IF FND_GLOBAL.User_Id IS NULL
97: THEN
98: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
99: RAISE FND_API.G_EXC_ERROR;
100: END IF;
101:
102: -- Debug Message
103: IF (AMS_DEBUG_HIGH_ON) THEN

Line 145: Update fnd_documents_tl because FND_API inserts newly generated

141: p_Fnd_Attachment_rec.short_text
142: );
143: else
144: /*
145: Update fnd_documents_tl because FND_API inserts newly generated
146: media_id into that table.
147: */
148: update fnd_documents_tl
149: set media_id = p_Fnd_Attachment_rec.media_id

Line 246: IF FND_API.to_Boolean( p_commit )

242: end if;
243:
244:
245: -- Standard check for p_commit
246: IF FND_API.to_Boolean( p_commit )
247: THEN
248: COMMIT WORK;
249: END IF;
250:

Line 267: x_return_status := FND_API.g_ret_sts_error;

263:
264: EXCEPTION
265:
266: WHEN AMS_Utility_PVT.resource_locked THEN
267: x_return_status := FND_API.g_ret_sts_error;
268: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
269:
270: WHEN FND_API.G_EXC_ERROR THEN
271: ROLLBACK TO CREATE_Fnd_Attachment_PVT;

Line 270: WHEN FND_API.G_EXC_ERROR THEN

266: WHEN AMS_Utility_PVT.resource_locked THEN
267: x_return_status := FND_API.g_ret_sts_error;
268: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
269:
270: WHEN FND_API.G_EXC_ERROR THEN
271: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
272: x_return_status := FND_API.G_RET_STS_ERROR;
273: -- Standard call to get message count and if count=1, get the message
274: FND_MSG_PUB.Count_And_Get (

Line 272: x_return_status := FND_API.G_RET_STS_ERROR;

268: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
269:
270: WHEN FND_API.G_EXC_ERROR THEN
271: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
272: x_return_status := FND_API.G_RET_STS_ERROR;
273: -- Standard call to get message count and if count=1, get the message
274: FND_MSG_PUB.Count_And_Get (
275: p_encoded => FND_API.G_FALSE,
276: p_count => x_msg_count,

Line 275: p_encoded => FND_API.G_FALSE,

271: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
272: x_return_status := FND_API.G_RET_STS_ERROR;
273: -- Standard call to get message count and if count=1, get the message
274: FND_MSG_PUB.Count_And_Get (
275: p_encoded => FND_API.G_FALSE,
276: p_count => x_msg_count,
277: p_data => x_msg_data
278: );
279:

Line 280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

276: p_count => x_msg_count,
277: p_data => x_msg_data
278: );
279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
281: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: -- Standard call to get message count and if count=1, get the message
284: FND_MSG_PUB.Count_And_Get (

Line 282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

278: );
279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
281: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: -- Standard call to get message count and if count=1, get the message
284: FND_MSG_PUB.Count_And_Get (
285: p_encoded => FND_API.G_FALSE,
286: p_count => x_msg_count,

Line 285: p_encoded => FND_API.G_FALSE,

281: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: -- Standard call to get message count and if count=1, get the message
284: FND_MSG_PUB.Count_And_Get (
285: p_encoded => FND_API.G_FALSE,
286: p_count => x_msg_count,
287: p_data => x_msg_data
288: );
289:

Line 292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

288: );
289:
290: WHEN OTHERS THEN
291: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
293: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
294: THEN
295: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
296: END IF;

Line 299: p_encoded => FND_API.G_FALSE,

295: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
296: END IF;
297: -- Standard call to get message count and if count=1, get the message
298: FND_MSG_PUB.Count_And_Get (
299: p_encoded => FND_API.G_FALSE,
300: p_count => x_msg_count,
301: p_data => x_msg_data
302: );
303: End Create_Fnd_Attachment;

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

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

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

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

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

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

Line 346: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 355: IF FND_API.to_Boolean( p_init_msg_list )

351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353:
354: -- Initialize message list if p_init_msg_list is set to TRUE.
355: IF FND_API.to_Boolean( p_init_msg_list )
356: THEN
357: FND_MSG_PUB.initialize;
358: END IF;
359:

Line 367: x_return_status := FND_API.G_RET_STS_SUCCESS;

363: END IF;
364:
365:
366: -- Initialize API return status to SUCCESS
367: x_return_status := FND_API.G_RET_STS_SUCCESS;
368:
369: -- Debug Message
370: IF (AMS_DEBUG_HIGH_ON) THEN
371: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

Line 382: RAISE FND_API.G_EXC_ERROR;

378: If ( c_get_Fnd_Documents%NOTFOUND) THEN
379: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
380: p_token_name => 'INFO',
381: p_token_value => 'Fnd_Attachment') ;
382: RAISE FND_API.G_EXC_ERROR;
383: END IF;
384:
385:
386: IF (p_Fnd_Attachment_rec.concur_last_update_date <> l_ref_fnd_attachment_rec.last_update_date) THEN

Line 388: RAISE FND_API.G_EXC_ERROR;

384:
385:
386: IF (p_Fnd_Attachment_rec.concur_last_update_date <> l_ref_fnd_attachment_rec.last_update_date) THEN
387: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RECORD_NOT_FOUND') ;
388: RAISE FND_API.G_EXC_ERROR;
389: END IF;
390:
391: -- Debug Message
392: IF (AMS_DEBUG_HIGH_ON) THEN

Line 463: RAISE FND_API.G_EXC_ERROR;

459: AMS_Utility_PVT.Error_Message(
460: p_message_name => 'API_MISSING_UPDATE_TARGET',
461: p_token_name => 'INFO',
462: p_token_value => 'Fnd_Documents_Short_Text') ;
463: RAISE FND_API.G_EXC_ERROR;
464:
465: end if;
466:
467: end if;

Line 477: IF FND_API.to_Boolean( p_commit )

473: -- End of API body.
474: --
475:
476: -- Standard check for p_commit
477: IF FND_API.to_Boolean( p_commit )
478: THEN
479: COMMIT WORK;
480: END IF;
481:

Line 496: x_return_status := FND_API.g_ret_sts_error;

492: );
493: EXCEPTION
494:
495: WHEN AMS_Utility_PVT.resource_locked THEN
496: x_return_status := FND_API.g_ret_sts_error;
497: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
498:
499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO UPDATE_Fnd_Attachment_PVT;

Line 499: WHEN FND_API.G_EXC_ERROR THEN

495: WHEN AMS_Utility_PVT.resource_locked THEN
496: x_return_status := FND_API.g_ret_sts_error;
497: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
498:
499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO UPDATE_Fnd_Attachment_PVT;
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: -- Standard call to get message count and if count=1, get the message
503: FND_MSG_PUB.Count_And_Get (

Line 501: x_return_status := FND_API.G_RET_STS_ERROR;

497: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
498:
499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO UPDATE_Fnd_Attachment_PVT;
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: -- Standard call to get message count and if count=1, get the message
503: FND_MSG_PUB.Count_And_Get (
504: p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,

Line 504: p_encoded => FND_API.G_FALSE,

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

Line 509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

507: );
508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: ROLLBACK TO UPDATE_Fnd_Attachment_PVT;
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: -- Standard call to get message count and if count=1, get the message
513: FND_MSG_PUB.Count_And_Get (
514: p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,

Line 514: p_encoded => FND_API.G_FALSE,

510: ROLLBACK TO UPDATE_Fnd_Attachment_PVT;
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: -- Standard call to get message count and if count=1, get the message
513: FND_MSG_PUB.Count_And_Get (
514: p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,
516: p_data => x_msg_data
517: );
518:

Line 521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

517: );
518:
519: WHEN OTHERS THEN
520: ROLLBACK TO UPDATE_Fnd_Attachment_PVT;
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
523: THEN
524: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
525: END IF;

Line 528: p_encoded => FND_API.G_FALSE,

524: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
525: END IF;
526: -- Standard call to get message count and if count=1, get the message
527: FND_MSG_PUB.Count_And_Get (
528: p_encoded => FND_API.G_FALSE,
529: p_count => x_msg_count,
530: p_data => x_msg_data
531: );
532: End Update_Fnd_Attachment;

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

533:
534:
535: PROCEDURE Delete_Fnd_Attachment(
536: p_api_version_number IN NUMBER,
537: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
538: p_commit IN VARCHAR2 := FND_API.G_FALSE,
539: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
540: x_return_status OUT NOCOPY VARCHAR2,
541: x_msg_count OUT NOCOPY NUMBER,

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

534:
535: PROCEDURE Delete_Fnd_Attachment(
536: p_api_version_number IN NUMBER,
537: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
538: p_commit IN VARCHAR2 := FND_API.G_FALSE,
539: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
540: x_return_status OUT NOCOPY VARCHAR2,
541: x_msg_count OUT NOCOPY NUMBER,
542: x_msg_data OUT NOCOPY VARCHAR2,

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

535: PROCEDURE Delete_Fnd_Attachment(
536: p_api_version_number IN NUMBER,
537: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
538: p_commit IN VARCHAR2 := FND_API.G_FALSE,
539: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
540: x_return_status OUT NOCOPY VARCHAR2,
541: x_msg_count OUT NOCOPY NUMBER,
542: x_msg_data OUT NOCOPY VARCHAR2,
543: p_document_id IN NUMBER,

Line 555: l_use_fnd_api boolean;

551: l_datatype_id number;
552: l_media_id number;
553: l_datatype_id number;
554: l_media_exists number;
555: l_use_fnd_api boolean;
556:
557: cursor c_get_media_id(p_document_id number)
558: is
559: select media_id

Line 584: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

580: -- Standard Start of API savepoint
581: SAVEPOINT DELETE_Fnd_Attachment_PVT;
582:
583: -- Standard call to check for call compatibility.
584: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
585: p_api_version_number,
586: l_api_name,
587: G_PKG_NAME)
588: THEN

Line 589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

585: p_api_version_number,
586: l_api_name,
587: G_PKG_NAME)
588: THEN
589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
590: END IF;
591:
592: -- Initialize message list if p_init_msg_list is set to TRUE.
593: IF FND_API.to_Boolean( p_init_msg_list )

Line 593: IF FND_API.to_Boolean( p_init_msg_list )

589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
590: END IF;
591:
592: -- Initialize message list if p_init_msg_list is set to TRUE.
593: IF FND_API.to_Boolean( p_init_msg_list )
594: THEN
595: FND_MSG_PUB.initialize;
596: END IF;
597:

Line 605: x_return_status := FND_API.G_RET_STS_SUCCESS;

601: END IF;
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 617: l_use_fnd_api := false;

613: END IF;
614:
615: IF ((p_datatype_id = 6) OR (p_datatype_id = 1)) THEN
616:
617: l_use_fnd_api := false;
618:
619: open c_get_media_id(p_document_id);
620: fetch c_get_media_id into l_media_id;
621: close c_get_media_id;

Line 633: /* Call FND API to delete everything */

629: if so not deleting the lob/text but otherwise delete the content as well
630: */
631:
632: if (l_media_exists is null) then
633: /* Call FND API to delete everything */
634: l_use_fnd_api := true;
635: end if;
636:
637: if (l_use_fnd_api) then

Line 634: l_use_fnd_api := true;

630: */
631:
632: if (l_media_exists is null) then
633: /* Call FND API to delete everything */
634: l_use_fnd_api := true;
635: end if;
636:
637: if (l_use_fnd_api) then
638:

Line 637: if (l_use_fnd_api) then

633: /* Call FND API to delete everything */
634: l_use_fnd_api := true;
635: end if;
636:
637: if (l_use_fnd_api) then
638:
639: FND_DOCUMENTS_PKG.Delete_Row(
640: X_document_id => p_document_id,
641: X_datatype_id => p_datatype_id,

Line 659: /* For URL calling the FND API */

655: end if;
656:
657:
658: ELSE
659: /* For URL calling the FND API */
660: FND_DOCUMENTS_PKG.Delete_Row(
661: X_document_id => p_document_id,
662: X_datatype_id => p_datatype_id,
663: delete_ref_Flag => p_delete_attachment_ref_flag

Line 674: IF FND_API.to_Boolean( p_commit )

670: -- End of API body
671: --
672:
673: -- Standard check for p_commit
674: IF FND_API.to_Boolean( p_commit )
675: THEN
676: COMMIT WORK;
677: END IF;
678:

Line 693: x_return_status := FND_API.g_ret_sts_error;

689: );
690: EXCEPTION
691:
692: WHEN AMS_Utility_PVT.resource_locked THEN
693: x_return_status := FND_API.g_ret_sts_error;
694: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
695:
696: WHEN FND_API.G_EXC_ERROR THEN
697: ROLLBACK TO DELETE_Fnd_Attachment_PVT;

Line 696: WHEN FND_API.G_EXC_ERROR THEN

692: WHEN AMS_Utility_PVT.resource_locked THEN
693: x_return_status := FND_API.g_ret_sts_error;
694: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
695:
696: WHEN FND_API.G_EXC_ERROR THEN
697: ROLLBACK TO DELETE_Fnd_Attachment_PVT;
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: -- Standard call to get message count and if count=1, get the message
700: FND_MSG_PUB.Count_And_Get (

Line 698: x_return_status := FND_API.G_RET_STS_ERROR;

694: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
695:
696: WHEN FND_API.G_EXC_ERROR THEN
697: ROLLBACK TO DELETE_Fnd_Attachment_PVT;
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: -- Standard call to get message count and if count=1, get the message
700: FND_MSG_PUB.Count_And_Get (
701: p_encoded => FND_API.G_FALSE,
702: p_count => x_msg_count,

Line 701: p_encoded => FND_API.G_FALSE,

697: ROLLBACK TO DELETE_Fnd_Attachment_PVT;
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: -- Standard call to get message count and if count=1, get the message
700: FND_MSG_PUB.Count_And_Get (
701: p_encoded => FND_API.G_FALSE,
702: p_count => x_msg_count,
703: p_data => x_msg_data
704: );
705:

Line 706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

702: p_count => x_msg_count,
703: p_data => x_msg_data
704: );
705:
706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
707: ROLLBACK TO DELETE_Fnd_Attachment_PVT;
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709: -- Standard call to get message count and if count=1, get the message
710: FND_MSG_PUB.Count_And_Get (

Line 708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

704: );
705:
706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
707: ROLLBACK TO DELETE_Fnd_Attachment_PVT;
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709: -- Standard call to get message count and if count=1, get the message
710: FND_MSG_PUB.Count_And_Get (
711: p_encoded => FND_API.G_FALSE,
712: p_count => x_msg_count,

Line 711: p_encoded => FND_API.G_FALSE,

707: ROLLBACK TO DELETE_Fnd_Attachment_PVT;
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709: -- Standard call to get message count and if count=1, get the message
710: FND_MSG_PUB.Count_And_Get (
711: p_encoded => FND_API.G_FALSE,
712: p_count => x_msg_count,
713: p_data => x_msg_data
714: );
715:

Line 718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

714: );
715:
716: WHEN OTHERS THEN
717: ROLLBACK TO DELETE_Fnd_Attachment_PVT;
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
719: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
720: THEN
721: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
722: END IF;

Line 725: p_encoded => FND_API.G_FALSE,

721: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
722: END IF;
723: -- Standard call to get message count and if count=1, get the message
724: FND_MSG_PUB.Count_And_Get (
725: p_encoded => FND_API.G_FALSE,
726: p_count => x_msg_count,
727: p_data => x_msg_data
728: );
729: End Delete_Fnd_Attachment;

Line 754: IF p_Fnd_Attachment_rec.prompt_id = FND_API.g_miss_num THEN

750: FETCH c_complete INTO l_Fnd_Attachment_rec;
751: CLOSE c_complete;
752:
753: -- prompt_id
754: IF p_Fnd_Attachment_rec.prompt_id = FND_API.g_miss_num THEN
755: x_complete_rec.prompt_id := l_Fnd_Attachment_rec.prompt_id;
756: END IF;
757:
758: -- score

Line 759: IF p_Fnd_Attachment_rec.score = FND_API.g_miss_num THEN

755: x_complete_rec.prompt_id := l_Fnd_Attachment_rec.prompt_id;
756: END IF;
757:
758: -- score
759: IF p_Fnd_Attachment_rec.score = FND_API.g_miss_num THEN
760: x_complete_rec.score := l_Fnd_Attachment_rec.score;
761: END IF;
762:
763: -- icon_file_name

Line 764: IF p_Fnd_Attachment_rec.icon_file_name = FND_API.g_miss_char THEN

760: x_complete_rec.score := l_Fnd_Attachment_rec.score;
761: END IF;
762:
763: -- icon_file_name
764: IF p_Fnd_Attachment_rec.icon_file_name = FND_API.g_miss_char THEN
765: x_complete_rec.icon_file_name := l_Fnd_Attachment_rec.icon_file_name;
766: END IF;
767:
768: -- last_update_date

Line 769: IF p_Fnd_Attachment_rec.last_update_date = FND_API.g_miss_date THEN

765: x_complete_rec.icon_file_name := l_Fnd_Attachment_rec.icon_file_name;
766: END IF;
767:
768: -- last_update_date
769: IF p_Fnd_Attachment_rec.last_update_date = FND_API.g_miss_date THEN
770: x_complete_rec.last_update_date := l_Fnd_Attachment_rec.last_update_date;
771: END IF;
772:
773: -- last_updated_by

Line 774: IF p_Fnd_Attachment_rec.last_updated_by = FND_API.g_miss_num THEN

770: x_complete_rec.last_update_date := l_Fnd_Attachment_rec.last_update_date;
771: END IF;
772:
773: -- last_updated_by
774: IF p_Fnd_Attachment_rec.last_updated_by = FND_API.g_miss_num THEN
775: x_complete_rec.last_updated_by := l_Fnd_Attachment_rec.last_updated_by;
776: END IF;
777:
778: -- creation_date

Line 779: IF p_Fnd_Attachment_rec.creation_date = FND_API.g_miss_date THEN

775: x_complete_rec.last_updated_by := l_Fnd_Attachment_rec.last_updated_by;
776: END IF;
777:
778: -- creation_date
779: IF p_Fnd_Attachment_rec.creation_date = FND_API.g_miss_date THEN
780: x_complete_rec.creation_date := l_Fnd_Attachment_rec.creation_date;
781: END IF;
782:
783: -- created_by

Line 784: IF p_Fnd_Attachment_rec.created_by = FND_API.g_miss_num THEN

780: x_complete_rec.creation_date := l_Fnd_Attachment_rec.creation_date;
781: END IF;
782:
783: -- created_by
784: IF p_Fnd_Attachment_rec.created_by = FND_API.g_miss_num THEN
785: x_complete_rec.created_by := l_Fnd_Attachment_rec.created_by;
786: END IF;
787:
788: -- last_update_login

Line 789: IF p_Fnd_Attachment_rec.last_update_login = FND_API.g_miss_num THEN

785: x_complete_rec.created_by := l_Fnd_Attachment_rec.created_by;
786: END IF;
787:
788: -- last_update_login
789: IF p_Fnd_Attachment_rec.last_update_login = FND_API.g_miss_num THEN
790: x_complete_rec.last_update_login := l_Fnd_Attachment_rec.last_update_login;
791: END IF;
792:
793: -- object_version_number

Line 794: IF p_Fnd_Attachment_rec.object_version_number = FND_API.g_miss_num THEN

790: x_complete_rec.last_update_login := l_Fnd_Attachment_rec.last_update_login;
791: END IF;
792:
793: -- object_version_number
794: IF p_Fnd_Attachment_rec.object_version_number = FND_API.g_miss_num THEN
795: x_complete_rec.object_version_number := l_Fnd_Attachment_rec.object_version_number;
796: END IF;
797:
798: -- security_group_id

Line 799: IF p_Fnd_Attachment_rec.security_group_id = FND_API.g_miss_num THEN

795: x_complete_rec.object_version_number := l_Fnd_Attachment_rec.object_version_number;
796: END IF;
797:
798: -- security_group_id
799: IF p_Fnd_Attachment_rec.security_group_id = FND_API.g_miss_num THEN
800: x_complete_rec.security_group_id := l_Fnd_Attachment_rec.security_group_id;
801: END IF;
802: -- Note: Developers need to modify the procedure
803: -- to handle any business specific requirements.