233: END IF;
234:
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
234:
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
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;
244: END IF;
245:
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
245:
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
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;