80: BEGIN
81:
82: x_language := fnd_global.current_language;
83:
84: fnd_message.set_name ('OE','OE_GEN_NOTE_NAME');
85: fnd_message.set_token('DOCUMENT_ID',to_char(p_document_id));
86: x_note_name := fnd_message.get;
87:
88: -- get Description from document
81:
82: x_language := fnd_global.current_language;
83:
84: fnd_message.set_name ('OE','OE_GEN_NOTE_NAME');
85: fnd_message.set_token('DOCUMENT_ID',to_char(p_document_id));
86: x_note_name := fnd_message.get;
87:
88: -- get Description from document
89: OPEN doc;
82: x_language := fnd_global.current_language;
83:
84: fnd_message.set_name ('OE','OE_GEN_NOTE_NAME');
85: fnd_message.set_token('DOCUMENT_ID',to_char(p_document_id));
86: x_note_name := fnd_message.get;
87:
88: -- get Description from document
89: OPEN doc;
90: FETCH doc INTO x_doc_desc;
113: x_note_name VARCHAR2(2000);
114: BEGIN
115:
116: IF (p_msg_name = 'OE_NOT_UPDATE_NOTE') THEN
117: fnd_message.set_name('OE', p_msg_name);
118: x_note_name := fnd_message.get;
119: ELSIF (p_msg_name IN ('OE_NOT_NOTE_TOO_LONG','OE_NOT_DOCUMENT_TOO_LONG')
120: ) THEN
121: fnd_message.set_name ('OE', p_msg_name);
114: BEGIN
115:
116: IF (p_msg_name = 'OE_NOT_UPDATE_NOTE') THEN
117: fnd_message.set_name('OE', p_msg_name);
118: x_note_name := fnd_message.get;
119: ELSIF (p_msg_name IN ('OE_NOT_NOTE_TOO_LONG','OE_NOT_DOCUMENT_TOO_LONG')
120: ) THEN
121: fnd_message.set_name ('OE', p_msg_name);
122: fnd_message.set_token('DOCUMENT_ID',to_char(p_document_id));
117: fnd_message.set_name('OE', p_msg_name);
118: x_note_name := fnd_message.get;
119: ELSIF (p_msg_name IN ('OE_NOT_NOTE_TOO_LONG','OE_NOT_DOCUMENT_TOO_LONG')
120: ) THEN
121: fnd_message.set_name ('OE', p_msg_name);
122: fnd_message.set_token('DOCUMENT_ID',to_char(p_document_id));
123: x_note_name := fnd_message.get;
124: END IF;
125:
118: x_note_name := fnd_message.get;
119: ELSIF (p_msg_name IN ('OE_NOT_NOTE_TOO_LONG','OE_NOT_DOCUMENT_TOO_LONG')
120: ) THEN
121: fnd_message.set_name ('OE', p_msg_name);
122: fnd_message.set_token('DOCUMENT_ID',to_char(p_document_id));
123: x_note_name := fnd_message.get;
124: END IF;
125:
126: RETURN(x_note_name);
119: ELSIF (p_msg_name IN ('OE_NOT_NOTE_TOO_LONG','OE_NOT_DOCUMENT_TOO_LONG')
120: ) THEN
121: fnd_message.set_name ('OE', p_msg_name);
122: fnd_message.set_token('DOCUMENT_ID',to_char(p_document_id));
123: x_note_name := fnd_message.get;
124: END IF;
125:
126: RETURN(x_note_name);
127: