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

Line 93: l_mail_conn UTL_SMTP.CONNECTION;

89: recipient4 IN VARCHAR2,
90: message IN VARCHAR2)
91: IS
92: l_mailhost VARCHAR2(32767);
93: l_mail_conn UTL_SMTP.CONNECTION;
94: l_email_addrs VARCHAR2(32767);
95: l_spr VARCHAR2(30) := ',';
96: l_start_pos NUMBER;
97: l_end_pos NUMBER;

Line 146: l_mail_conn := utl_smtp.open_connection(l_mailhost, 25);

142: IF l_mailhost IS NOT NULL
143: AND l_email_addrs IS NOT NULL
144: THEN
145: --{
146: l_mail_conn := utl_smtp.open_connection(l_mailhost, 25);
147: j := 1; l_start_pos := 1; l_end_pos := instrb(l_email_addrs, l_spr, 1, j);
148: if l_end_pos = 0 then
149: l_end_pos := lengthb(l_email_addrs) + 1;
150: end if;

Line 181: utl_smtp.helo(l_mail_conn, l_mailhost);

177: INV_LOG_UTIL.TRACE('Now recipient3: '||l_recipient3,l_module_name,'9');
178: INV_LOG_UTIL.TRACE('Now recipient4: '||l_recipient4,l_module_name,'9');
179: INV_LOG_UTIL.TRACE('Now recipient5: '||l_recipient5,l_module_name,'9');
180: END IF;
181: utl_smtp.helo(l_mail_conn, l_mailhost);
182: utl_smtp.mail(l_mail_conn, l_sender);
183: IF l_recipient1 IS NOT NULL THEN
184: utl_smtp.rcpt(l_mail_conn,l_recipient1);
185: END IF;

Line 182: utl_smtp.mail(l_mail_conn, l_sender);

178: INV_LOG_UTIL.TRACE('Now recipient4: '||l_recipient4,l_module_name,'9');
179: INV_LOG_UTIL.TRACE('Now recipient5: '||l_recipient5,l_module_name,'9');
180: END IF;
181: utl_smtp.helo(l_mail_conn, l_mailhost);
182: utl_smtp.mail(l_mail_conn, l_sender);
183: IF l_recipient1 IS NOT NULL THEN
184: utl_smtp.rcpt(l_mail_conn,l_recipient1);
185: END IF;
186: IF l_recipient2 IS NOT NULL THEN

Line 184: utl_smtp.rcpt(l_mail_conn,l_recipient1);

180: END IF;
181: utl_smtp.helo(l_mail_conn, l_mailhost);
182: utl_smtp.mail(l_mail_conn, l_sender);
183: IF l_recipient1 IS NOT NULL THEN
184: utl_smtp.rcpt(l_mail_conn,l_recipient1);
185: END IF;
186: IF l_recipient2 IS NOT NULL THEN
187: utl_smtp.rcpt(l_mail_conn,l_recipient2);
188: END IF;

Line 187: utl_smtp.rcpt(l_mail_conn,l_recipient2);

183: IF l_recipient1 IS NOT NULL THEN
184: utl_smtp.rcpt(l_mail_conn,l_recipient1);
185: END IF;
186: IF l_recipient2 IS NOT NULL THEN
187: utl_smtp.rcpt(l_mail_conn,l_recipient2);
188: END IF;
189: IF l_recipient3 IS NOT NULL THEN
190: utl_smtp.rcpt(l_mail_conn,l_recipient3);
191: END IF;

Line 190: utl_smtp.rcpt(l_mail_conn,l_recipient3);

186: IF l_recipient2 IS NOT NULL THEN
187: utl_smtp.rcpt(l_mail_conn,l_recipient2);
188: END IF;
189: IF l_recipient3 IS NOT NULL THEN
190: utl_smtp.rcpt(l_mail_conn,l_recipient3);
191: END IF;
192: IF l_recipient4 IS NOT NULL THEN
193: utl_smtp.rcpt(l_mail_conn,l_recipient4);
194: END IF;

Line 193: utl_smtp.rcpt(l_mail_conn,l_recipient4);

189: IF l_recipient3 IS NOT NULL THEN
190: utl_smtp.rcpt(l_mail_conn,l_recipient3);
191: END IF;
192: IF l_recipient4 IS NOT NULL THEN
193: utl_smtp.rcpt(l_mail_conn,l_recipient4);
194: END IF;
195: IF l_recipient5 IS NOT NULL THEN
196: utl_smtp.rcpt(l_mail_conn,l_recipient5);
197: END IF;

Line 196: utl_smtp.rcpt(l_mail_conn,l_recipient5);

192: IF l_recipient4 IS NOT NULL THEN
193: utl_smtp.rcpt(l_mail_conn,l_recipient4);
194: END IF;
195: IF l_recipient5 IS NOT NULL THEN
196: utl_smtp.rcpt(l_mail_conn,l_recipient5);
197: END IF;
198: utl_smtp.data(l_mail_conn,message);
199: utl_smtp.quit(l_mail_conn);
200: ELSE

Line 198: utl_smtp.data(l_mail_conn,message);

194: END IF;
195: IF l_recipient5 IS NOT NULL THEN
196: utl_smtp.rcpt(l_mail_conn,l_recipient5);
197: END IF;
198: utl_smtp.data(l_mail_conn,message);
199: utl_smtp.quit(l_mail_conn);
200: ELSE
201: IF l_debug_on THEN
202: INV_LOG_UTIL.TRACE('Not sending mail. Server Name or Email id is null',l_module_name,'9');

Line 199: utl_smtp.quit(l_mail_conn);

195: IF l_recipient5 IS NOT NULL THEN
196: utl_smtp.rcpt(l_mail_conn,l_recipient5);
197: END IF;
198: utl_smtp.data(l_mail_conn,message);
199: utl_smtp.quit(l_mail_conn);
200: ELSE
201: IF l_debug_on THEN
202: INV_LOG_UTIL.TRACE('Not sending mail. Server Name or Email id is null',l_module_name,'9');
203: END IF;