eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_ACCTG_DATA_FIX_PKG dependencies on UTL_SMTP

Line 6392: v_smtp_connection utl_smtp.connection;

6388: v_attachment CLOB; -- Text that will be sent as an attached file
6389: v_offset NUMBER;
6390: v_amount NUMBER;
6391: -- variable to hold the smtp server connection
6392: v_smtp_connection utl_smtp.connection;
6393:
6394: -- variable to hold the smtp host name
6395: v_smtp_host VARCHAR2(100) DEFAULT 'localhost';
6396:

Line 6426: v_smtp_connection := utl_smtp.open_connection(v_smtp_host, v_smtp_port);

6422: WHEN OTHERS THEN
6423: Dbms_Output.put_line(SQLERRM);
6424: END;
6425: -- establish the connection to the smtp server
6426: v_smtp_connection := utl_smtp.open_connection(v_smtp_host, v_smtp_port);
6427:
6428: -- perform a handshake with the smtp server
6429: utl_smtp.helo(v_smtp_connection, v_smtp_host);
6430:

Line 6429: utl_smtp.helo(v_smtp_connection, v_smtp_host);

6425: -- establish the connection to the smtp server
6426: v_smtp_connection := utl_smtp.open_connection(v_smtp_host, v_smtp_port);
6427:
6428: -- perform a handshake with the smtp server
6429: utl_smtp.helo(v_smtp_connection, v_smtp_host);
6430:
6431: -- set the 'from' address of the message
6432: utl_smtp.mail(v_smtp_connection, v_sender);
6433:

Line 6432: utl_smtp.mail(v_smtp_connection, v_sender);

6428: -- perform a handshake with the smtp server
6429: utl_smtp.helo(v_smtp_connection, v_smtp_host);
6430:
6431: -- set the 'from' address of the message
6432: utl_smtp.mail(v_smtp_connection, v_sender);
6433:
6434: -- add the recipient to the message
6435: utl_smtp.rcpt(v_smtp_connection, v_recipient);
6436:

Line 6435: utl_smtp.rcpt(v_smtp_connection, v_recipient);

6431: -- set the 'from' address of the message
6432: utl_smtp.mail(v_smtp_connection, v_sender);
6433:
6434: -- add the recipient to the message
6435: utl_smtp.rcpt(v_smtp_connection, v_recipient);
6436:
6437: utl_smtp.open_data (v_smtp_connection);
6438:
6439:

Line 6437: utl_smtp.open_data (v_smtp_connection);

6433:
6434: -- add the recipient to the message
6435: utl_smtp.rcpt(v_smtp_connection, v_recipient);
6436:
6437: utl_smtp.open_data (v_smtp_connection);
6438:
6439:
6440: --writing headers of the message
6441: utl_smtp.write_data(v_smtp_connection,'Date: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || utl_tcp.crlf);

Line 6441: utl_smtp.write_data(v_smtp_connection,'Date: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || utl_tcp.crlf);

6437: utl_smtp.open_data (v_smtp_connection);
6438:
6439:
6440: --writing headers of the message
6441: utl_smtp.write_data(v_smtp_connection,'Date: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || utl_tcp.crlf);
6442: utl_smtp.write_data(v_smtp_connection,'From: ' || v_sender || utl_tcp.crlf);
6443: utl_smtp.write_data(v_smtp_connection,'Subject: '|| v_subject || utl_tcp.crlf);
6444: utl_smtp.write_data(v_smtp_connection,'To: ' || v_recipient || utl_tcp.crlf);
6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);

Line 6442: utl_smtp.write_data(v_smtp_connection,'From: ' || v_sender || utl_tcp.crlf);

6438:
6439:
6440: --writing headers of the message
6441: utl_smtp.write_data(v_smtp_connection,'Date: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || utl_tcp.crlf);
6442: utl_smtp.write_data(v_smtp_connection,'From: ' || v_sender || utl_tcp.crlf);
6443: utl_smtp.write_data(v_smtp_connection,'Subject: '|| v_subject || utl_tcp.crlf);
6444: utl_smtp.write_data(v_smtp_connection,'To: ' || v_recipient || utl_tcp.crlf);
6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);
6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type

Line 6443: utl_smtp.write_data(v_smtp_connection,'Subject: '|| v_subject || utl_tcp.crlf);

6439:
6440: --writing headers of the message
6441: utl_smtp.write_data(v_smtp_connection,'Date: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || utl_tcp.crlf);
6442: utl_smtp.write_data(v_smtp_connection,'From: ' || v_sender || utl_tcp.crlf);
6443: utl_smtp.write_data(v_smtp_connection,'Subject: '|| v_subject || utl_tcp.crlf);
6444: utl_smtp.write_data(v_smtp_connection,'To: ' || v_recipient || utl_tcp.crlf);
6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);
6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type
6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);

Line 6444: utl_smtp.write_data(v_smtp_connection,'To: ' || v_recipient || utl_tcp.crlf);

6440: --writing headers of the message
6441: utl_smtp.write_data(v_smtp_connection,'Date: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || utl_tcp.crlf);
6442: utl_smtp.write_data(v_smtp_connection,'From: ' || v_sender || utl_tcp.crlf);
6443: utl_smtp.write_data(v_smtp_connection,'Subject: '|| v_subject || utl_tcp.crlf);
6444: utl_smtp.write_data(v_smtp_connection,'To: ' || v_recipient || utl_tcp.crlf);
6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);
6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type
6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);
6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);

Line 6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);

6441: utl_smtp.write_data(v_smtp_connection,'Date: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || utl_tcp.crlf);
6442: utl_smtp.write_data(v_smtp_connection,'From: ' || v_sender || utl_tcp.crlf);
6443: utl_smtp.write_data(v_smtp_connection,'Subject: '|| v_subject || utl_tcp.crlf);
6444: utl_smtp.write_data(v_smtp_connection,'To: ' || v_recipient || utl_tcp.crlf);
6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);
6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type
6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);
6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);
6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);

Line 6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type

6442: utl_smtp.write_data(v_smtp_connection,'From: ' || v_sender || utl_tcp.crlf);
6443: utl_smtp.write_data(v_smtp_connection,'Subject: '|| v_subject || utl_tcp.crlf);
6444: utl_smtp.write_data(v_smtp_connection,'To: ' || v_recipient || utl_tcp.crlf);
6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);
6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type
6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);
6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);
6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);

Line 6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);

6443: utl_smtp.write_data(v_smtp_connection,'Subject: '|| v_subject || utl_tcp.crlf);
6444: utl_smtp.write_data(v_smtp_connection,'To: ' || v_recipient || utl_tcp.crlf);
6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);
6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type
6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);
6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);
6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);
6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);

Line 6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);

6444: utl_smtp.write_data(v_smtp_connection,'To: ' || v_recipient || utl_tcp.crlf);
6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);
6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type
6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);
6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);
6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);
6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);
6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);

Line 6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);

6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);
6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type
6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);
6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);
6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);
6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);
6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);

Line 6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);

6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type
6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);
6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);
6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);
6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);
6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);

Line 6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);

6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);
6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);
6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);
6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);
6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);
6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);

Line 6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);

6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);
6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);
6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);
6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);
6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);
6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);

Line 6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);

6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);
6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);
6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);
6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);
6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);
6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text

Line 6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);

6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);
6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);
6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);
6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);
6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);
6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text
6458: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);

Line 6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);

6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);
6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);
6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);
6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);
6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text
6458: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6459: utl_smtp.write_data(v_smtp_connection,'Content-Disposition: attachment;'|| utl_tcp.crlf);

Line 6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);

6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);
6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);
6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);
6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text
6458: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6459: utl_smtp.write_data(v_smtp_connection,'Content-Disposition: attachment;'|| utl_tcp.crlf);
6460: utl_smtp.write_data(v_smtp_connection,' filename="log.html"'|| utl_tcp.crlf);

Line 6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text

6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);
6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);
6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);
6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text
6458: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6459: utl_smtp.write_data(v_smtp_connection,'Content-Disposition: attachment;'|| utl_tcp.crlf);
6460: utl_smtp.write_data(v_smtp_connection,' filename="log.html"'|| utl_tcp.crlf);
6461: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);

Line 6458: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);

6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);
6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);
6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);
6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text
6458: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6459: utl_smtp.write_data(v_smtp_connection,'Content-Disposition: attachment;'|| utl_tcp.crlf);
6460: utl_smtp.write_data(v_smtp_connection,' filename="log.html"'|| utl_tcp.crlf);
6461: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6462:

Line 6459: utl_smtp.write_data(v_smtp_connection,'Content-Disposition: attachment;'|| utl_tcp.crlf);

6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);
6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);
6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text
6458: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6459: utl_smtp.write_data(v_smtp_connection,'Content-Disposition: attachment;'|| utl_tcp.crlf);
6460: utl_smtp.write_data(v_smtp_connection,' filename="log.html"'|| utl_tcp.crlf);
6461: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6462:
6463: -- writing data from clob

Line 6460: utl_smtp.write_data(v_smtp_connection,' filename="log.html"'|| utl_tcp.crlf);

6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);
6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text
6458: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6459: utl_smtp.write_data(v_smtp_connection,'Content-Disposition: attachment;'|| utl_tcp.crlf);
6460: utl_smtp.write_data(v_smtp_connection,' filename="log.html"'|| utl_tcp.crlf);
6461: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6462:
6463: -- writing data from clob
6464: BEGIN

Line 6461: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);

6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text
6458: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6459: utl_smtp.write_data(v_smtp_connection,'Content-Disposition: attachment;'|| utl_tcp.crlf);
6460: utl_smtp.write_data(v_smtp_connection,' filename="log.html"'|| utl_tcp.crlf);
6461: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6462:
6463: -- writing data from clob
6464: BEGIN
6465: v_offset := 1;

Line 6469: utl_smtp.write_data(v_smtp_connection,

6465: v_offset := 1;
6466: v_amount := 1900;
6467: WHILE v_offset < dbms_lob.getlength(v_attachment)
6468: LOOP
6469: utl_smtp.write_data(v_smtp_connection,
6470: dbms_lob.substr(v_attachment,v_amount,v_offset));
6471: v_offset := v_offset + v_amount ;
6472: v_amount := least(1900,dbms_lob.getlength(v_attachment) - v_amount);
6473: END LOOP;

Line 6475: utl_smtp.close_data(v_smtp_connection);

6471: v_offset := v_offset + v_amount ;
6472: v_amount := least(1900,dbms_lob.getlength(v_attachment) - v_amount);
6473: END LOOP;
6474: vNewLine := utl_tcp.crlf ||utl_tcp.crlf ||'-------SECBOUND--';
6475: utl_smtp.close_data(v_smtp_connection);
6476: utl_smtp.quit(v_smtp_connection);
6477: dbms_lob.freetemporary(v_attachment);
6478: END;
6479: RETURN TRUE;

Line 6476: utl_smtp.quit(v_smtp_connection);

6472: v_amount := least(1900,dbms_lob.getlength(v_attachment) - v_amount);
6473: END LOOP;
6474: vNewLine := utl_tcp.crlf ||utl_tcp.crlf ||'-------SECBOUND--';
6475: utl_smtp.close_data(v_smtp_connection);
6476: utl_smtp.quit(v_smtp_connection);
6477: dbms_lob.freetemporary(v_attachment);
6478: END;
6479: RETURN TRUE;
6480:

Line 6482: WHEN utl_smtp.invalid_operation THEN

6478: END;
6479: RETURN TRUE;
6480:
6481: EXCEPTION
6482: WHEN utl_smtp.invalid_operation THEN
6483: dbms_output.put_line('Invalid Operation in Mail attempt using UTL_SMTP.');
6484: RETURN FALSE;
6485: WHEN utl_smtp.transient_error THEN
6486: dbms_output.put_line(' Temporary e-mail issue - try again');

Line 6483: dbms_output.put_line('Invalid Operation in Mail attempt using UTL_SMTP.');

6479: RETURN TRUE;
6480:
6481: EXCEPTION
6482: WHEN utl_smtp.invalid_operation THEN
6483: dbms_output.put_line('Invalid Operation in Mail attempt using UTL_SMTP.');
6484: RETURN FALSE;
6485: WHEN utl_smtp.transient_error THEN
6486: dbms_output.put_line(' Temporary e-mail issue - try again');
6487: RETURN FALSE;

Line 6485: WHEN utl_smtp.transient_error THEN

6481: EXCEPTION
6482: WHEN utl_smtp.invalid_operation THEN
6483: dbms_output.put_line('Invalid Operation in Mail attempt using UTL_SMTP.');
6484: RETURN FALSE;
6485: WHEN utl_smtp.transient_error THEN
6486: dbms_output.put_line(' Temporary e-mail issue - try again');
6487: RETURN FALSE;
6488: WHEN utl_smtp.permanent_error THEN
6489: dbms_output.put_line(' Permanent Error Encountered.');

Line 6488: WHEN utl_smtp.permanent_error THEN

6484: RETURN FALSE;
6485: WHEN utl_smtp.transient_error THEN
6486: dbms_output.put_line(' Temporary e-mail issue - try again');
6487: RETURN FALSE;
6488: WHEN utl_smtp.permanent_error THEN
6489: dbms_output.put_line(' Permanent Error Encountered.');
6490: RETURN FALSE;
6491:
6492: END send_mail_clob_impl;