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.JTF_DIAGNOSTIC_COREAPI dependencies on UTL_SMTP

Line 1819: l_mail_conn utl_smtp.connection;

1815: , p_subject varchar2
1816: , p_message varchar2
1817: , p_mailhost varchar2) is
1818:
1819: l_mail_conn utl_smtp.connection;
1820: begin
1821: l_mail_conn := utl_smtp.open_connection(p_mailhost, 25);
1822: utl_smtp.helo(l_mail_conn, p_mailhost);
1823: utl_smtp.mail(l_mail_conn, p_sender);

Line 1821: l_mail_conn := utl_smtp.open_connection(p_mailhost, 25);

1817: , p_mailhost varchar2) is
1818:
1819: l_mail_conn utl_smtp.connection;
1820: begin
1821: l_mail_conn := utl_smtp.open_connection(p_mailhost, 25);
1822: utl_smtp.helo(l_mail_conn, p_mailhost);
1823: utl_smtp.mail(l_mail_conn, p_sender);
1824: utl_smtp.rcpt(l_mail_conn, p_recipient);
1825: utl_smtp.open_data(l_mail_conn);

Line 1822: utl_smtp.helo(l_mail_conn, p_mailhost);

1818:
1819: l_mail_conn utl_smtp.connection;
1820: begin
1821: l_mail_conn := utl_smtp.open_connection(p_mailhost, 25);
1822: utl_smtp.helo(l_mail_conn, p_mailhost);
1823: utl_smtp.mail(l_mail_conn, p_sender);
1824: utl_smtp.rcpt(l_mail_conn, p_recipient);
1825: utl_smtp.open_data(l_mail_conn);
1826: if p_subject is not null then

Line 1823: utl_smtp.mail(l_mail_conn, p_sender);

1819: l_mail_conn utl_smtp.connection;
1820: begin
1821: l_mail_conn := utl_smtp.open_connection(p_mailhost, 25);
1822: utl_smtp.helo(l_mail_conn, p_mailhost);
1823: utl_smtp.mail(l_mail_conn, p_sender);
1824: utl_smtp.rcpt(l_mail_conn, p_recipient);
1825: utl_smtp.open_data(l_mail_conn);
1826: if p_subject is not null then
1827: utl_smtp.write_data(l_mail_conn, 'Subject: ' || p_subject || utl_tcp.CRLF);

Line 1824: utl_smtp.rcpt(l_mail_conn, p_recipient);

1820: begin
1821: l_mail_conn := utl_smtp.open_connection(p_mailhost, 25);
1822: utl_smtp.helo(l_mail_conn, p_mailhost);
1823: utl_smtp.mail(l_mail_conn, p_sender);
1824: utl_smtp.rcpt(l_mail_conn, p_recipient);
1825: utl_smtp.open_data(l_mail_conn);
1826: if p_subject is not null then
1827: utl_smtp.write_data(l_mail_conn, 'Subject: ' || p_subject || utl_tcp.CRLF);
1828: end if;

Line 1825: utl_smtp.open_data(l_mail_conn);

1821: l_mail_conn := utl_smtp.open_connection(p_mailhost, 25);
1822: utl_smtp.helo(l_mail_conn, p_mailhost);
1823: utl_smtp.mail(l_mail_conn, p_sender);
1824: utl_smtp.rcpt(l_mail_conn, p_recipient);
1825: utl_smtp.open_data(l_mail_conn);
1826: if p_subject is not null then
1827: utl_smtp.write_data(l_mail_conn, 'Subject: ' || p_subject || utl_tcp.CRLF);
1828: end if;
1829: utl_smtp.write_data(l_mail_conn, utl_tcp.CRLF || p_mailhost);

Line 1827: utl_smtp.write_data(l_mail_conn, 'Subject: ' || p_subject || utl_tcp.CRLF);

1823: utl_smtp.mail(l_mail_conn, p_sender);
1824: utl_smtp.rcpt(l_mail_conn, p_recipient);
1825: utl_smtp.open_data(l_mail_conn);
1826: if p_subject is not null then
1827: utl_smtp.write_data(l_mail_conn, 'Subject: ' || p_subject || utl_tcp.CRLF);
1828: end if;
1829: utl_smtp.write_data(l_mail_conn, utl_tcp.CRLF || p_mailhost);
1830: utl_smtp.close_data(l_mail_conn);
1831: utl_smtp.quit(l_mail_conn);

Line 1829: utl_smtp.write_data(l_mail_conn, utl_tcp.CRLF || p_mailhost);

1825: utl_smtp.open_data(l_mail_conn);
1826: if p_subject is not null then
1827: utl_smtp.write_data(l_mail_conn, 'Subject: ' || p_subject || utl_tcp.CRLF);
1828: end if;
1829: utl_smtp.write_data(l_mail_conn, utl_tcp.CRLF || p_mailhost);
1830: utl_smtp.close_data(l_mail_conn);
1831: utl_smtp.quit(l_mail_conn);
1832: exception
1833: when others then

Line 1830: utl_smtp.close_data(l_mail_conn);

1826: if p_subject is not null then
1827: utl_smtp.write_data(l_mail_conn, 'Subject: ' || p_subject || utl_tcp.CRLF);
1828: end if;
1829: utl_smtp.write_data(l_mail_conn, utl_tcp.CRLF || p_mailhost);
1830: utl_smtp.close_data(l_mail_conn);
1831: utl_smtp.quit(l_mail_conn);
1832: exception
1833: when others then
1834: utl_smtp.quit(l_mail_conn);

Line 1831: utl_smtp.quit(l_mail_conn);

1827: utl_smtp.write_data(l_mail_conn, 'Subject: ' || p_subject || utl_tcp.CRLF);
1828: end if;
1829: utl_smtp.write_data(l_mail_conn, utl_tcp.CRLF || p_mailhost);
1830: utl_smtp.close_data(l_mail_conn);
1831: utl_smtp.quit(l_mail_conn);
1832: exception
1833: when others then
1834: utl_smtp.quit(l_mail_conn);
1835: ErrorPrint('
Error in Sending Mail' || sqlerrm);

Line 1834: utl_smtp.quit(l_mail_conn);

1830: utl_smtp.close_data(l_mail_conn);
1831: utl_smtp.quit(l_mail_conn);
1832: exception
1833: when others then
1834: utl_smtp.quit(l_mail_conn);
1835: ErrorPrint('
Error in Sending Mail' || sqlerrm);
1836: end Send_Email_html;
1837:
1838: -- Function Name: Get_Package_Version