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

Line 80: Fnd_File.PUT_LINE(Fnd_File.LOG,

76: l_ptm_code VARCHAR2(100);
77:
78: BEGIN
79:
80: Fnd_File.PUT_LINE(Fnd_File.LOG,
81: 'Start of process');
82:
83: l_current_date := p_report_date;
84: l_request_number := p_report_number;

Line 95: Fnd_File.PUT_LINE(Fnd_File.LOG,l_current_date|| 'Request ' ||

91:
92: l_agent_id:= to_number(fnd_profile.value('OKL_FULFILLMENT_USER'));
93: l_from := fnd_profile.value('OKL_EMAIL_IDENTITY');
94:
95: Fnd_File.PUT_LINE(Fnd_File.LOG,l_current_date|| 'Request ' ||
96: l_request_number|| 'Vendor '||
97: l_vendor_id );
98:
99: -- open cursor for requests to be processed

Line 106: Fnd_File.PUT_LINE(Fnd_File.LOG,'Email is '||l_email);

102: l_email := i.email_address;
103: IF (l_email = OKL_API.G_MISS_CHAR OR l_email IS NULL) THEN
104: RAISE G_MISSING_EMAIL_ID;
105: END IF;
106: Fnd_File.PUT_LINE(Fnd_File.LOG,'Email is '||l_email);
107:
108: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
109: l_bind_var(1) := 'p_report_id';
110: l_bind_val(1) := i.cure_report_id;

Line 131: Fnd_File.PUT_LINE(Fnd_File.LOG,'Process Code '

127: OPEN c_get_content_id (l_ptm_code);
128: FETCH c_get_content_id INTO l_content_id ,l_subject;
129: CLOSE c_get_content_id;
130:
131: Fnd_File.PUT_LINE(Fnd_File.LOG,'Process Code '
132: ||l_ptm_code ||' content_id '|| l_content_id);
133:
134: IF l_content_id is Null THEN
135: RAISE G_MISSING_TEMPLATE;

Line 159: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,

155: );
156: -- If the return status is error write to log and proceed
157: -- with the rest of the requests
158: IF (l_return_status <> okl_api.G_RET_STS_SUCCESS) THEN
159: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,
160: 'Cure Request could not be sent for request = '
161: || i.report_number);
162: IF l_msg_count IS NULL THEN
163: l_msg_count := 2;

Line 171: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, l_msg_data);

167: fnd_msg_pub.get (
168: p_encoded => 'F',
169: p_data => l_msg_data,
170: p_msg_index_out => l_msg_index_out);
171: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, l_msg_data);
172: END LOOP;
173: END IF;
174:
175: Fnd_File.PUT_LINE(Fnd_File.LOG,

Line 175: Fnd_File.PUT_LINE(Fnd_File.LOG,

171: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, l_msg_data);
172: END LOOP;
173: END IF;
174:
175: Fnd_File.PUT_LINE(Fnd_File.LOG,
176: 'After calling okl_fulfill api and return status is'
177: || l_return_status);
178:
179:

Line 199: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,

195: ,x_crtv_rec => lx_crtv_rec);
196: -- If the return status is error write to log and proceed
197: -- with the rest of the requests
198: IF (l_return_status <> okl_api.G_RET_STS_SUCCESS) THEN
199: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,
200: 'Cure Request Status could not be updated for request = '
201: || i.report_number);
202: IF l_msg_count IS NULL THEN
203: l_msg_count := 2;

Line 210: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, l_msg_data);

206: fnd_msg_pub.get (
207: p_encoded => 'F',
208: p_data => l_msg_data,
209: p_msg_index_out => l_msg_index_out);
210: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, l_msg_data);
211: END LOOP;
212: END IF; --return_status of update cure reports
213: Fnd_File.PUT_LINE(Fnd_File.LOG,
214: 'After calling update cure reports and return status is'

Line 213: Fnd_File.PUT_LINE(Fnd_File.LOG,

209: p_msg_index_out => l_msg_index_out);
210: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, l_msg_data);
211: END LOOP;
212: END IF; --return_status of update cure reports
213: Fnd_File.PUT_LINE(Fnd_File.LOG,
214: 'After calling update cure reports and return status is'
215: || l_return_status);
216:
217: END IF; --return of fulfil api

Line 220: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'Cure Request = ' || i.report_number);

216:
217: END IF; --return of fulfil api
218: END IF; --return of bind variable
219:
220: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'Cure Request = ' || i.report_number);
221: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'Request sent for Vendor = ' || to_char(l_vendor_id));
222: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'Request sent on Date = ' || SYSDATE);
223: l_return_status :=OKL_API.G_RET_STS_SUCCESS;
224:

Line 221: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'Request sent for Vendor = ' || to_char(l_vendor_id));

217: END IF; --return of fulfil api
218: END IF; --return of bind variable
219:
220: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'Cure Request = ' || i.report_number);
221: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'Request sent for Vendor = ' || to_char(l_vendor_id));
222: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'Request sent on Date = ' || SYSDATE);
223: l_return_status :=OKL_API.G_RET_STS_SUCCESS;
224:
225: END LOOP;

Line 222: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'Request sent on Date = ' || SYSDATE);

218: END IF; --return of bind variable
219:
220: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'Cure Request = ' || i.report_number);
221: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'Request sent for Vendor = ' || to_char(l_vendor_id));
222: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'Request sent on Date = ' || SYSDATE);
223: l_return_status :=OKL_API.G_RET_STS_SUCCESS;
224:
225: END LOOP;
226:

Line 239: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, FND_MESSAGE.GET );

235: errbuf := 'G_MISSING_EMAIL_ID';
236: retcode := 1;
237: FND_MESSAGE.SET_NAME('OKL', 'OKL_CO_MISSING_EMAIL_ID');
238: --dbms_output.put_line(FND_MESSAGE.GET);
239: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, FND_MESSAGE.GET );
240:
241: WHEN G_MISSING_TEMPLATE THEN
242: IF report_csr%ISOPEN THEN
243: CLOSE report_csr;

Line 250: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, FND_MESSAGE.GET );

246: errbuf := 'G_MISSING_TEMPLATE';
247: retcode := 1;
248: FND_MESSAGE.SET_NAME('OKL', 'OKL_CO_MISSING_FUL_TEMPLATE');
249: --dbms_output.put_line(FND_MESSAGE.GET);
250: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, FND_MESSAGE.GET );
251:
252: WHEN OTHERS THEN
253: IF report_csr%ISOPEN THEN
254: CLOSE report_csr;

Line 257: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS)IN SEND_CURE_REQUEST => '||SQLERRM);

253: IF report_csr%ISOPEN THEN
254: CLOSE report_csr;
255: END IF;
256:
257: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS)IN SEND_CURE_REQUEST => '||SQLERRM);
258: retcode :=2;
259: errbuf :=SQLERRM;
260:
261: END SEND_CURE_REQUEST;