APPS.CSFW_ATTACHMENT_PVT dependencies on FND_LOBS

Line 27: l_fnd_lobs_id number;

23: l_seq_num number;
24: l_category_id number;
25: l_msg_count NUMBER;
26: l_msg_data VARCHAR2(240);
27: l_fnd_lobs_id number;
28: l_fnd_text_id number;
29: l_language VARCHAR2(4);
30: l_error_msg varchar(1024);
31:

Line 63: -- get next sequence value for FND_LOBS

59: SELECT category_id
60: FROM fnd_document_categories_tl
61: WHERE user_name = p_category_user_name;
62:
63: -- get next sequence value for FND_LOBS
64: CURSOR l_fnd_lobs_s_cursor
65: IS
66: select fnd_lobs_s.nextval
67: from dual;

Line 64: CURSOR l_fnd_lobs_s_cursor

60: FROM fnd_document_categories_tl
61: WHERE user_name = p_category_user_name;
62:
63: -- get next sequence value for FND_LOBS
64: CURSOR l_fnd_lobs_s_cursor
65: IS
66: select fnd_lobs_s.nextval
67: from dual;
68:

Line 66: select fnd_lobs_s.nextval

62:
63: -- get next sequence value for FND_LOBS
64: CURSOR l_fnd_lobs_s_cursor
65: IS
66: select fnd_lobs_s.nextval
67: from dual;
68:
69: -- get next sequence value for fnd_documents_short_text
70: CURSOR fnd_short_text_s_cursor

Line 82: cursor l_lobs_fileid_csr (p_file_id fnd_lobs.file_id%TYPE) is

78: select userenv('LANG')
79: from dual;
80:
81: --to check if the record exists in the database
82: cursor l_lobs_fileid_csr (p_file_id fnd_lobs.file_id%TYPE) is
83: select 1
84: from fnd_lobs
85: where file_id = p_file_id;
86:

Line 84: from fnd_lobs

80:
81: --to check if the record exists in the database
82: cursor l_lobs_fileid_csr (p_file_id fnd_lobs.file_id%TYPE) is
83: select 1
84: from fnd_lobs
85: where file_id = p_file_id;
86:
87: RECORD_NOT_INSERTED EXCEPTION;
88: ATTACH_FAILED EXCEPTION;

Line 112: -- enter data into fnd_lobs

108:
109:
110: IF (p_datatype_id = 6) THEN
111: BEGIN
112: -- enter data into fnd_lobs
113: OPEN l_fnd_lobs_s_cursor;
114: FETCH l_fnd_lobs_s_cursor INTO l_fnd_lobs_id;
115: CLOSE l_fnd_lobs_s_cursor;
116:

Line 113: OPEN l_fnd_lobs_s_cursor;

109:
110: IF (p_datatype_id = 6) THEN
111: BEGIN
112: -- enter data into fnd_lobs
113: OPEN l_fnd_lobs_s_cursor;
114: FETCH l_fnd_lobs_s_cursor INTO l_fnd_lobs_id;
115: CLOSE l_fnd_lobs_s_cursor;
116:
117: INSERT INTO fnd_lobs(file_id, file_name, file_content_type, file_data, upload_date, language, file_format)

Line 114: FETCH l_fnd_lobs_s_cursor INTO l_fnd_lobs_id;

110: IF (p_datatype_id = 6) THEN
111: BEGIN
112: -- enter data into fnd_lobs
113: OPEN l_fnd_lobs_s_cursor;
114: FETCH l_fnd_lobs_s_cursor INTO l_fnd_lobs_id;
115: CLOSE l_fnd_lobs_s_cursor;
116:
117: INSERT INTO fnd_lobs(file_id, file_name, file_content_type, file_data, upload_date, language, file_format)
118: VALUES (l_fnd_lobs_id, p_file_name, p_file_content_type, empty_blob(), SYSDATE, l_language, 'binary')

Line 115: CLOSE l_fnd_lobs_s_cursor;

111: BEGIN
112: -- enter data into fnd_lobs
113: OPEN l_fnd_lobs_s_cursor;
114: FETCH l_fnd_lobs_s_cursor INTO l_fnd_lobs_id;
115: CLOSE l_fnd_lobs_s_cursor;
116:
117: INSERT INTO fnd_lobs(file_id, file_name, file_content_type, file_data, upload_date, language, file_format)
118: VALUES (l_fnd_lobs_id, p_file_name, p_file_content_type, empty_blob(), SYSDATE, l_language, 'binary')
119: RETURN file_data into l_attachment_loc;

Line 117: INSERT INTO fnd_lobs(file_id, file_name, file_content_type, file_data, upload_date, language, file_format)

113: OPEN l_fnd_lobs_s_cursor;
114: FETCH l_fnd_lobs_s_cursor INTO l_fnd_lobs_id;
115: CLOSE l_fnd_lobs_s_cursor;
116:
117: INSERT INTO fnd_lobs(file_id, file_name, file_content_type, file_data, upload_date, language, file_format)
118: VALUES (l_fnd_lobs_id, p_file_name, p_file_content_type, empty_blob(), SYSDATE, l_language, 'binary')
119: RETURN file_data into l_attachment_loc;
120:
121: l_attachment_size := dbms_lob.getLength(p_file_data);

Line 118: VALUES (l_fnd_lobs_id, p_file_name, p_file_content_type, empty_blob(), SYSDATE, l_language, 'binary')

114: FETCH l_fnd_lobs_s_cursor INTO l_fnd_lobs_id;
115: CLOSE l_fnd_lobs_s_cursor;
116:
117: INSERT INTO fnd_lobs(file_id, file_name, file_content_type, file_data, upload_date, language, file_format)
118: VALUES (l_fnd_lobs_id, p_file_name, p_file_content_type, empty_blob(), SYSDATE, l_language, 'binary')
119: RETURN file_data into l_attachment_loc;
120:
121: l_attachment_size := dbms_lob.getLength(p_file_data);
122: --insert into shakti_audit(msg) values('File size : '|| l_attachment_size);

Line 149: open l_lobs_fileid_csr(l_fnd_lobs_id) ;

145: when others then
146: --insert into shakti_audit(msg) values('Error');
147: --raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM);
148: -- check if the record exists
149: open l_lobs_fileid_csr(l_fnd_lobs_id) ;
150: fetch l_lobs_fileid_csr into l_dummy;
151: if l_lobs_fileid_csr%found then
152: --the record exists. Dont show any error.
153: null;

Line 194: media_id => l_fnd_lobs_id,

190: pk2_value => NULL,
191: pk3_value => NULL,
192: pk4_value => NULL,
193: pk5_value => NULL,
194: media_id => l_fnd_lobs_id,
195: user_id => fnd_global.login_id,
196: title => p_title);
197: EXCEPTION
198: WHEN OTHERS THEN

Line 210: p_error_msg := 'Attachment of BLOB:' || l_fnd_lobs_id || ' to Service Request Number:'|| p_incident_number || ' failed';

206: p_error_msg := 'Record not inserted';
207:
208: WHEN ATTACH_FAILED THEN
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: p_error_msg := 'Attachment of BLOB:' || l_fnd_lobs_id || ' to Service Request Number:'|| p_incident_number || ' failed';
211:
212: WHEN OTHERS THEN
213:
214: p_error_msg := SQLERRM;