[Home] [Help]
131: if (p_Fnd_Attachment_rec.media_id is null) then
132: /* It means that a new text needs to be created, otherwise not */
133: /* Populate Short Text */
134: insert into
135: fnd_documents_short_text
136: (media_id,
137: short_text
138: )
139: values
398: --IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');END IF;
399:
400: if (p_Fnd_Attachment_rec.datatype_id = 1) then
401: if (p_Fnd_Attachment_rec.media_id is null) then
402: SELECT fnd_documents_short_text_s.nextval
403: INTO l_media_id
404: from dual;
405: end if;
406: end if;
428: );
429:
430: /* Bug# 2072584 */
431: /* Need to call the previous method call before actually updating
432: FND_DOCUMENTS_SHORT_TEXT in case of text - otherwise
433: the trigger was failing */
434:
435: -- Update fnd_documents_short_text based on the datatype_id
436: if (p_Fnd_Attachment_rec.datatype_id = 1) then
431: /* Need to call the previous method call before actually updating
432: FND_DOCUMENTS_SHORT_TEXT in case of text - otherwise
433: the trigger was failing */
434:
435: -- Update fnd_documents_short_text based on the datatype_id
436: if (p_Fnd_Attachment_rec.datatype_id = 1) then
437:
438: if (p_Fnd_Attachment_rec.media_id is null) then
439: -- Create a record
439: -- Create a record
440:
441: /* Populate Short Text */
442: insert into
443: fnd_documents_short_text
444: (media_id,
445: short_text
446: )
447: values
449: p_Fnd_Attachment_rec.short_text
450: );
451:
452: else
453: update fnd_documents_short_text
454: set short_text = p_Fnd_Attachment_rec.short_text
455: where media_id = p_Fnd_Attachment_rec.media_id;
456:
457: if SQL%NOTFOUND then
458:
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: