371: else
372: if (fnd_gfm.authenticate(confirm_upload.access_id)) then
373:
374: if (verify_file_type(file_name => confirm_upload.file_name) = 'Y') then
375: select fnd_lobs_s.nextval into fid from dual;
376:
377: fn := SUBSTR(confirm_upload.file_name, INSTR(confirm_upload.file_name,'/')+1);
378:
379: -- bug 3045375, added select to get length of BLOB.
1271: begin
1272:
1273: SELECT fnd_lobs_s.nextval
1274: INTO fid_to
1275: FROM dual;
1276:
1277: SELECT file_id,
1278: file_name,
1279: file_content_type,
1405: raise G_EXC_ERROR;
1406: end if;
1407:
1408: if fid is null then
1409: select fnd_lobs_s.nextval into fid from dual;
1410: end if;
1411:
1412: if file_content_type is null then
1413: v_content_type := 'text/plain';