DBA Data[Home] [Help]

APPS.SO_ATT dependencies on SO_ATT

Line 1: PACKAGE BODY so_att AS

1: PACKAGE BODY so_att AS
2: /* $Header: oeatt04b.pls 115.2 99/07/16 08:25:20 porting shi $ */
3: PROCEDURE mark_record (
4: p_src_id NUMBER, -- media_id | document_id
5: p_short_long VARCHAR2, -- 'S' | 'L'

Line 450: x_note := so_att.get_note_error('OE_NOT_UPDATE_NOTE');

446:
447: x_datatype_id := 1; -- default is short text;
448:
449: IF (x_note IS NULL) THEN
450: x_note := so_att.get_note_error('OE_NOT_UPDATE_NOTE');
451: ELSIF length (x_note) >= 2000 THEN
452: x_datatype_id := 2; -- long text
453: END IF;
454:

Line 457: x_note := so_att.get_note_error('OE_NOT_NOTE_TOO_LONG',p_document_id);

453: END IF;
454:
455: EXCEPTION
456: WHEN VALUE_ERROR THEN -- long exceeds 32760
457: x_note := so_att.get_note_error('OE_NOT_NOTE_TOO_LONG',p_document_id);
458: x_datatype_id := 2;
459: WHEN OTHERS THEN
460: RAISE;
461: END;

Line 629: x_note := so_att.get_note_error('OE_NOT_NOTE_TOO_LONG',p_document_id);

625: WHERE document_id = p_document_id;
626:
627: EXCEPTION
628: WHEN VALUE_ERROR THEN -- long exceeds 32760
629: x_note := so_att.get_note_error('OE_NOT_NOTE_TOO_LONG',p_document_id);
630: WHEN OTHERS THEN
631: RAISE;
632: END;
633: