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.OKS_MAIL dependencies on FND_FILE

Line 23: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

19: END IF;
20:
21: EXCEPTION
22: WHEN OTHERS THEN
23: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
24: END;
25:
26: -- Write a MIME header
27: PROCEDURE write_mime_header(conn IN OUT NOCOPY utl_smtp.connection,

Line 35: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

31: utl_smtp.write_data(conn, name || ': ' || value || CRLF);
32:
33: EXCEPTION
34: WHEN OTHERS THEN
35: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
36: END;
37:
38: -- Mark a message-part boundary. Set to TRUE for the last boundary.
39: PROCEDURE write_boundary(conn IN OUT NOCOPY utl_smtp.connection,

Line 49: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

45: utl_smtp.write_data(conn, FIRST_BOUNDARY);
46: END IF;
47: EXCEPTION
48: WHEN OTHERS THEN
49: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
50: END;
51:
52: ------------------------------------------------------------------------
53: PROCEDURE mail(sender IN VARCHAR2,

Line 64: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

60: write_text(conn, message);
61: end_mail(conn);
62: EXCEPTION
63: WHEN OTHERS THEN
64: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
65: END;
66:
67: ------------------------------------------------------------------------
68: FUNCTION begin_mail(sender IN VARCHAR2,

Line 83: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

79: RETURN conn;
80:
81: EXCEPTION
82: WHEN OTHERS THEN
83: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
84: END;
85:
86: ------------------------------------------------------------------------
87: PROCEDURE write_text(conn IN OUT NOCOPY utl_smtp.connection,

Line 93: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

89: BEGIN
90: utl_smtp.write_data(conn, message);
91: EXCEPTION
92: WHEN OTHERS THEN
93: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
94: END;
95:
96: ------------------------------------------------------------------------
97: PROCEDURE write_mb_text(conn IN OUT NOCOPY utl_smtp.connection,

Line 106: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

102: --l_message := oks_base64.encode(message);
103: --utl_smtp.write_data(conn, l_message);
104: EXCEPTION
105: WHEN OTHERS THEN
106: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
107: END;
108:
109: ------------------------------------------------------------------------
110: PROCEDURE write_raw(conn IN OUT NOCOPY utl_smtp.connection,

Line 119: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

115: --l_message := oks_base64.encode(message);
116: --utl_smtp.write_data(conn, l_message);
117: EXCEPTION
118: WHEN OTHERS THEN
119: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
120: END;
121:
122: ------------------------------------------------------------------------
123: PROCEDURE attach_text(conn IN OUT NOCOPY utl_smtp.connection,

Line 135: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

131: write_text(conn, data);
132: end_attachment(conn, last);
133: EXCEPTION
134: WHEN OTHERS THEN
135: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
136: END;
137:
138: ------------------------------------------------------------------------
139: PROCEDURE attach_base64(conn IN OUT NOCOPY utl_smtp.connection,

Line 191: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

187: -- By MK -- end_attachment(conn, last);
188:
189: EXCEPTION
190: WHEN OTHERS THEN
191: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
192: END;
193:
194: ------------------------------------------------------------------------
195: PROCEDURE begin_attachment(conn IN OUT NOCOPY utl_smtp.connection,

Line 222: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

218: utl_smtp.write_data(conn, CRLF);
219:
220: EXCEPTION
221: WHEN OTHERS THEN
222: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
223: END;
224:
225: ------------------------------------------------------------------------
226: PROCEDURE end_attachment(conn IN OUT NOCOPY utl_smtp.connection,

Line 235: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

231: write_boundary(conn, last);
232: END IF;
233: EXCEPTION
234: WHEN OTHERS THEN
235: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
236: END;
237:
238: ------------------------------------------------------------------------
239: PROCEDURE end_mail(conn IN OUT NOCOPY utl_smtp.connection) IS

Line 245: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

241: end_mail_in_session(conn);
242: end_session(conn);
243: EXCEPTION
244: WHEN OTHERS THEN
245: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
246: END;
247:
248: ------------------------------------------------------------------------
249: FUNCTION begin_session RETURN utl_smtp.connection IS

Line 258: FND_FILE.PUT_LINE(FND_FILE.LOG, status.code || ': ' || status.text );

254: status := utl_smtp.open_connection(smtp_host, smtp_port, conn);
255:
256: -- Status code 220 - Service is ready
257: IF (status.code <> 220) THEN
258: FND_FILE.PUT_LINE(FND_FILE.LOG, status.code || ': ' || status.text );
259: END IF;
260:
261: status := utl_smtp.helo(conn, smtp_host); -- @@ or EHLO?
262:

Line 266: FND_FILE.PUT_LINE(FND_FILE.LOG, status.code || ': ' || status.text );

262:
263: -- Status code 250 - Requested mail action OKAY completed
264: -- Hand shaking working
265: IF (status.code <> 250) THEN
266: FND_FILE.PUT_LINE(FND_FILE.LOG, status.code || ': ' || status.text );
267: END IF;
268: RETURN conn;
269: EXCEPTION
270: WHEN OTHERS THEN

Line 271: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

267: END IF;
268: RETURN conn;
269: EXCEPTION
270: WHEN OTHERS THEN
271: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
272: END;
273:
274: ------------------------------------------------------------------------
275: PROCEDURE begin_mail_in_session(conn IN OUT NOCOPY utl_smtp.connection,

Line 346: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

342: END IF;
343:
344: EXCEPTION
345: WHEN OTHERS THEN
346: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
347: END;
348:
349: ------------------------------------------------------------------------
350: PROCEDURE end_mail_in_session(conn IN OUT NOCOPY utl_smtp.connection) IS

Line 355: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

351: BEGIN
352: utl_smtp.close_data(conn);
353: EXCEPTION
354: WHEN OTHERS THEN
355: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
356: END;
357:
358: ------------------------------------------------------------------------
359: PROCEDURE end_session(conn IN OUT NOCOPY utl_smtp.connection) IS

Line 364: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

360: BEGIN
361: utl_smtp.quit(conn);
362: EXCEPTION
363: WHEN OTHERS THEN
364: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
365: END;
366:
367: PROCEDURE send_binary_attachment(sender IN VARCHAR2,
368: recipient_tbl IN recipient_rec_tbl,

Line 423: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

419: end_mail(conn);
420:
421: EXCEPTION
422: WHEN OTHERS THEN
423: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
424: END;
425:
426:
427: --------------------------------------------------------------

Line 450: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Host name: ' || smtp_host);

446: j pls_integer;
447:
448: BEGIN
449:
450: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Host name: ' || smtp_host);
451: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Port : ' || smtp_port);
452:
453: conn := begin_mail(sender => sender,
454: recipient_tbl => recipient_tbl,

Line 451: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Port : ' || smtp_port);

447:
448: BEGIN
449:
450: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Host name: ' || smtp_host);
451: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Port : ' || smtp_port);
452:
453: conn := begin_mail(sender => sender,
454: recipient_tbl => recipient_tbl,
455: subject => subject,

Line 487: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET );

483: wallet_password => wallet_pswd
484: );
485: ELSE
486: FND_MESSAGE.SET_NAME ('OKS', 'OKS_INVALID_WALLET_PATH');
487: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET );
488: END IF;
489:
490: ELSE
491: pieces := UTL_HTTP.REQUEST_PIECES(

Line 522: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

518: end_mail(conn);
519:
520: EXCEPTION
521: WHEN OTHERS THEN
522: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
523: END;
524:
525: PROCEDURE send_text_attachment ( sender IN VARCHAR2,
526: recipient_tbl IN recipient_rec_tbl,

Line 566: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

562: end_mail(conn);
563:
564: EXCEPTION
565: WHEN OTHERS THEN
566: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
567: END;
568:
569: PROCEDURE send_attachment ( sender IN VARCHAR2,
570: recipient_tbl IN recipient_rec_tbl,

Line 636: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

632: end_mail(conn);
633:
634: EXCEPTION
635: WHEN OTHERS THEN
636: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
637: END;
638:
639: PROCEDURE send_attachment ( sender IN VARCHAR2,
640: recipient_tbl IN recipient_rec_tbl,

Line 718: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

714: end_mail(conn);
715:
716: EXCEPTION
717: WHEN OTHERS THEN
718: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
719: END;
720:
721: PROCEDURE send_attachment ( sender IN VARCHAR2,
722: recipient_tbl IN recipient_rec_tbl,

Line 777: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

773: end_mail(conn);
774:
775: EXCEPTION
776: WHEN OTHERS THEN
777: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
778: END;
779:
780: PROCEDURE send_mail (
781: sender IN VARCHAR2,

Line 809: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

805: end_mail(conn);
806:
807: EXCEPTION
808: WHEN OTHERS THEN
809: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
810: END;
811:
812: END OKS_MAIL;