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

Line 98: l_mail_conn UTL_SMTP.connection;

94: , recipient4 IN VARCHAR2
95: , MESSAGE IN VARCHAR2
96: ) IS
97: l_mailhost VARCHAR2(32767);
98: l_mail_conn UTL_SMTP.connection;
99: l_email_addrs VARCHAR2(32767);
100: l_spr VARCHAR2(30) := ',';
101: l_start_pos NUMBER;
102: l_end_pos NUMBER;

Line 150: l_mail_conn := UTL_SMTP.open_connection(l_mailhost, 25);

146: END IF;
147:
148: IF l_mailhost IS NOT NULL
149: AND l_email_addrs IS NOT NULL THEN
150: l_mail_conn := UTL_SMTP.open_connection(l_mailhost, 25);
151: j := 1;
152: l_start_pos := 1;
153: l_end_pos := INSTRB(l_email_addrs, l_spr, 1, j);
154:

Line 206: UTL_SMTP.helo(l_mail_conn, l_mailhost);

202: asn_debug.put_line('Now recipient4: ' || l_recipient4);
203: asn_debug.put_line('Now recipient5: ' || l_recipient5);
204: END IF;
205:
206: UTL_SMTP.helo(l_mail_conn, l_mailhost);
207: UTL_SMTP.mail(l_mail_conn, l_sender);
208:
209: IF l_recipient1 IS NOT NULL THEN
210: UTL_SMTP.rcpt(l_mail_conn, l_recipient1);

Line 207: UTL_SMTP.mail(l_mail_conn, l_sender);

203: asn_debug.put_line('Now recipient5: ' || l_recipient5);
204: END IF;
205:
206: UTL_SMTP.helo(l_mail_conn, l_mailhost);
207: UTL_SMTP.mail(l_mail_conn, l_sender);
208:
209: IF l_recipient1 IS NOT NULL THEN
210: UTL_SMTP.rcpt(l_mail_conn, l_recipient1);
211: END IF;

Line 210: UTL_SMTP.rcpt(l_mail_conn, l_recipient1);

206: UTL_SMTP.helo(l_mail_conn, l_mailhost);
207: UTL_SMTP.mail(l_mail_conn, l_sender);
208:
209: IF l_recipient1 IS NOT NULL THEN
210: UTL_SMTP.rcpt(l_mail_conn, l_recipient1);
211: END IF;
212:
213: IF l_recipient2 IS NOT NULL THEN
214: UTL_SMTP.rcpt(l_mail_conn, l_recipient2);

Line 214: UTL_SMTP.rcpt(l_mail_conn, l_recipient2);

210: UTL_SMTP.rcpt(l_mail_conn, l_recipient1);
211: END IF;
212:
213: IF l_recipient2 IS NOT NULL THEN
214: UTL_SMTP.rcpt(l_mail_conn, l_recipient2);
215: END IF;
216:
217: IF l_recipient3 IS NOT NULL THEN
218: UTL_SMTP.rcpt(l_mail_conn, l_recipient3);

Line 218: UTL_SMTP.rcpt(l_mail_conn, l_recipient3);

214: UTL_SMTP.rcpt(l_mail_conn, l_recipient2);
215: END IF;
216:
217: IF l_recipient3 IS NOT NULL THEN
218: UTL_SMTP.rcpt(l_mail_conn, l_recipient3);
219: END IF;
220:
221: IF l_recipient4 IS NOT NULL THEN
222: UTL_SMTP.rcpt(l_mail_conn, l_recipient4);

Line 222: UTL_SMTP.rcpt(l_mail_conn, l_recipient4);

218: UTL_SMTP.rcpt(l_mail_conn, l_recipient3);
219: END IF;
220:
221: IF l_recipient4 IS NOT NULL THEN
222: UTL_SMTP.rcpt(l_mail_conn, l_recipient4);
223: END IF;
224:
225: IF l_recipient5 IS NOT NULL THEN
226: UTL_SMTP.rcpt(l_mail_conn, l_recipient5);

Line 226: UTL_SMTP.rcpt(l_mail_conn, l_recipient5);

222: UTL_SMTP.rcpt(l_mail_conn, l_recipient4);
223: END IF;
224:
225: IF l_recipient5 IS NOT NULL THEN
226: UTL_SMTP.rcpt(l_mail_conn, l_recipient5);
227: END IF;
228:
229: UTL_SMTP.DATA(l_mail_conn, MESSAGE);
230: UTL_SMTP.quit(l_mail_conn);

Line 229: UTL_SMTP.DATA(l_mail_conn, MESSAGE);

225: IF l_recipient5 IS NOT NULL THEN
226: UTL_SMTP.rcpt(l_mail_conn, l_recipient5);
227: END IF;
228:
229: UTL_SMTP.DATA(l_mail_conn, MESSAGE);
230: UTL_SMTP.quit(l_mail_conn);
231: ELSE
232: IF l_debug_on THEN
233: asn_debug.put_line('Not sending mail. Server Name or Email id is null');

Line 230: UTL_SMTP.quit(l_mail_conn);

226: UTL_SMTP.rcpt(l_mail_conn, l_recipient5);
227: END IF;
228:
229: UTL_SMTP.DATA(l_mail_conn, MESSAGE);
230: UTL_SMTP.quit(l_mail_conn);
231: ELSE
232: IF l_debug_on THEN
233: asn_debug.put_line('Not sending mail. Server Name or Email id is null');
234: END IF;