Attach files in FTP and email

Hi all,

Requirement : Send an email with all the attachments added in a Purchase Order / Purchase Order Line.

The files are stored in FTP, therefore I cant use the edm_file_storate_tab to get the BLOB.

So, I tried to use  Batch_Transfer_Handler_Api.Download_From_Ftp method  to get the files, and attach to email.

And it worked for one particular document, but its failling with the below error for other documents, which are in same class, same ftp location, attached to same Purchase Order Line. Details/setup in the Document Revision screen for both are also same.

The failling documents are viewable on the application without any error.

Debug information also showing the same path/fileName as in edm_file_tab for these failling documents.

Could you please advise on any possible reasons to failing the ftp download? or please suggest another option to attach these docs in FTP to an email.

Appreciate your help.

Thank you!