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_SEC_CONCURRENT_PVT dependencies on FND_FILE

Line 235: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));

231: p_api_type => G_API_TYPE,
232: x_return_status => l_return_status);
233:
234: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
235: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
236: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
237: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
238: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
239: RAISE G_EXCEPTION_ERROR;

Line 238: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));

234: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
235: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
236: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
237: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
238: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
239: RAISE G_EXCEPTION_ERROR;
240: END IF;
241:
242: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

Line 242: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

238: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
239: RAISE G_EXCEPTION_ERROR;
240: END IF;
241:
242: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
243: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
244:
245: -- Printing the values in the log file.
246:

Line 243: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

239: RAISE G_EXCEPTION_ERROR;
240: END IF;
241:
242: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
243: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
244:
245: -- Printing the values in the log file.
246:
247: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 247: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

243: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
244:
245: -- Printing the values in the log file.
246:
247: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_khr_id : ' || p_khr_id);
249: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
250:
251: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));

Line 248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_khr_id : ' || p_khr_id);

244:
245: -- Printing the values in the log file.
246:
247: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_khr_id : ' || p_khr_id);
249: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
250:
251: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));
252:

Line 249: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

245: -- Printing the values in the log file.
246:
247: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_khr_id : ' || p_khr_id);
249: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
250:
251: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));
252:
253: -- Header

Line 251: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));

247: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_khr_id : ' || p_khr_id);
249: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
250:
251: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));
252:
253: -- Header
254: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_BUYBACK_AGREEMENT_HEAD);
255: l_header_len := LENGTH(l_content);

Line 257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

253: -- Header
254: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_BUYBACK_AGREEMENT_HEAD);
255: l_header_len := LENGTH(l_content);
256: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2); -- center align header
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
258:
259: l_content := RPAD('=',l_header_len,'='); -- underline header
260: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2,'='); -- center align
261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

Line 261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
258:
259: l_content := RPAD('=',l_header_len,'='); -- underline header
260: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2,'='); -- center align
261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
262:
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
264: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
265:

Line 263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

259: l_content := RPAD('=',l_header_len,'='); -- underline header
260: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2,'='); -- center align
261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
262:
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
264: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
265:
266: -- Set of Books, Operating Unit
267: FOR l_okl_set_of_books_rec IN l_okl_set_of_books_csr

Line 264: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

260: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2,'='); -- center align
261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
262:
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
264: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
265:
266: -- Set of Books, Operating Unit
267: FOR l_okl_set_of_books_rec IN l_okl_set_of_books_csr
268: LOOP

Line 269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_SET_OF_BOOKS),l_prompt_len) || ' : ' || l_okl_set_of_books_rec.set_of_books_name);

265:
266: -- Set of Books, Operating Unit
267: FOR l_okl_set_of_books_rec IN l_okl_set_of_books_csr
268: LOOP
269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_SET_OF_BOOKS),l_prompt_len) || ' : ' || l_okl_set_of_books_rec.set_of_books_name);
270: END LOOP;
271: FOR l_okl_operating_unit_rec IN l_okl_operating_unit_csr
272: LOOP
273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_OPERATING_UNIT),l_prompt_len) || ' : ' || l_okl_operating_unit_rec.name);

Line 273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_OPERATING_UNIT),l_prompt_len) || ' : ' || l_okl_operating_unit_rec.name);

269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_SET_OF_BOOKS),l_prompt_len) || ' : ' || l_okl_set_of_books_rec.set_of_books_name);
270: END LOOP;
271: FOR l_okl_operating_unit_rec IN l_okl_operating_unit_csr
272: LOOP
273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_OPERATING_UNIT),l_prompt_len) || ' : ' || l_okl_operating_unit_rec.name);
274: END LOOP;
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
276:
277: -- Investor Agreement Number, Pool Number, Buyback Date

Line 275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

271: FOR l_okl_operating_unit_rec IN l_okl_operating_unit_csr
272: LOOP
273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_OPERATING_UNIT),l_prompt_len) || ' : ' || l_okl_operating_unit_rec.name);
274: END LOOP;
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
276:
277: -- Investor Agreement Number, Pool Number, Buyback Date
278: FOR l_okl_pol_khr_rec IN l_okl_pol_khr_csr(p_khr_id)
279: LOOP

Line 280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_INVESTOR_AGREEMENT_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_khr_rec.agreement_number);

276:
277: -- Investor Agreement Number, Pool Number, Buyback Date
278: FOR l_okl_pol_khr_rec IN l_okl_pol_khr_csr(p_khr_id)
279: LOOP
280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_INVESTOR_AGREEMENT_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_khr_rec.agreement_number);
281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_khr_rec.pool_number);
282: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_BUYBACK_DATE),l_prompt_len) || ' : ' || lp_effective_date);
283:
284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_khr_rec.pool_number);

277: -- Investor Agreement Number, Pool Number, Buyback Date
278: FOR l_okl_pol_khr_rec IN l_okl_pol_khr_csr(p_khr_id)
279: LOOP
280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_INVESTOR_AGREEMENT_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_khr_rec.agreement_number);
281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_khr_rec.pool_number);
282: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_BUYBACK_DATE),l_prompt_len) || ' : ' || lp_effective_date);
283:
284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
285: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CURRENCY),l_prompt_len) || ' : ' || l_okl_pol_khr_rec.currency_code);

Line 282: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_BUYBACK_DATE),l_prompt_len) || ' : ' || lp_effective_date);

278: FOR l_okl_pol_khr_rec IN l_okl_pol_khr_csr(p_khr_id)
279: LOOP
280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_INVESTOR_AGREEMENT_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_khr_rec.agreement_number);
281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_khr_rec.pool_number);
282: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_BUYBACK_DATE),l_prompt_len) || ' : ' || lp_effective_date);
283:
284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
285: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CURRENCY),l_prompt_len) || ' : ' || l_okl_pol_khr_rec.currency_code);
286: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_PROGRAM_RUN_DATE),l_prompt_len) || ' : ' || SYSDATE);

Line 284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_INVESTOR_AGREEMENT_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_khr_rec.agreement_number);
281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_khr_rec.pool_number);
282: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_BUYBACK_DATE),l_prompt_len) || ' : ' || lp_effective_date);
283:
284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
285: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CURRENCY),l_prompt_len) || ' : ' || l_okl_pol_khr_rec.currency_code);
286: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_PROGRAM_RUN_DATE),l_prompt_len) || ' : ' || SYSDATE);
287: END LOOP;
288:

Line 285: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CURRENCY),l_prompt_len) || ' : ' || l_okl_pol_khr_rec.currency_code);

281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_khr_rec.pool_number);
282: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_BUYBACK_DATE),l_prompt_len) || ' : ' || lp_effective_date);
283:
284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
285: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CURRENCY),l_prompt_len) || ' : ' || l_okl_pol_khr_rec.currency_code);
286: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_PROGRAM_RUN_DATE),l_prompt_len) || ' : ' || SYSDATE);
287: END LOOP;
288:
289: -- sub head (Details)

Line 286: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_PROGRAM_RUN_DATE),l_prompt_len) || ' : ' || SYSDATE);

282: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_BUYBACK_DATE),l_prompt_len) || ' : ' || lp_effective_date);
283:
284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
285: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CURRENCY),l_prompt_len) || ' : ' || l_okl_pol_khr_rec.currency_code);
286: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_PROGRAM_RUN_DATE),l_prompt_len) || ' : ' || SYSDATE);
287: END LOOP;
288:
289: -- sub head (Details)
290: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 290: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

286: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_PROGRAM_RUN_DATE),l_prompt_len) || ' : ' || SYSDATE);
287: END LOOP;
288:
289: -- sub head (Details)
290: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
291: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_DETAILS);
292: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
293: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
294: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 292: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

288:
289: -- sub head (Details)
290: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
291: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_DETAILS);
292: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
293: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
294: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
295:
296:

Line 293: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));

289: -- sub head (Details)
290: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
291: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_DETAILS);
292: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
293: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
294: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
295:
296:
297:

Line 294: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

290: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
291: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_DETAILS);
292: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
293: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
294: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
295:
296:
297:
298: l_total_rec_count := 0;

Line 311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

307: || RPAD('-',l_sty_subclass_len-1,'-') || ' '
308: || RPAD('-',l_amount_len,'-') || ' '
309: || RPAD('-',l_amount_len,'-');
310:
311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
312:
313: l_content := RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ROW_NUMBER),l_row_num_len-1) || ' '
314: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACT_NUMBER),l_contract_num_len-1) || ' '
315: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_sty_subclass_len-1) || ' '

Line 319: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

315: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_sty_subclass_len-1) || ' '
316: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_AMOUNT),l_amount_len) || ' '
317: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_BUYBACK_AMOUNT),l_amount_len);
318:
319: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
320:
321: l_content := RPAD('-',l_row_num_len-1,'-') || ' '
322: || RPAD('-',l_contract_num_len-1,'-') || ' '
323: || RPAD('-',l_sty_subclass_len-1,'-') || ' '

Line 327: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

323: || RPAD('-',l_sty_subclass_len-1,'-') || ' '
324: || RPAD('-',l_amount_len,'-') || ' '
325: || RPAD('-',l_amount_len,'-');
326:
327: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
328:
329: END IF; -- l_total_rec_count
330:
331: Okl_Securitization_Pvt.calculate_buyback_amount(p_api_version => l_api_version

Line 349: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

345: || RPAD(l_okl_poc_rec.sty_subclass ,l_sty_subclass_len)
346: || LPAD(okl_accounting_util.format_amount(l_okl_poc_rec.streams_amount,l_okl_poc_rec.currency_code),l_amount_len)
347: || LPAD(okl_accounting_util.format_amount(l_buyback_amount,l_okl_poc_rec.currency_code),l_amount_len);
348:
349: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
350:
351: l_buyback_amount := NULL;
352:
353: Okl_Securitization_Pvt.buyback_pool_contents(p_api_version => l_api_version

Line 364: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Securitization_Pvt.buyback_pool_contents',G_UNEXPECTED_ERROR));

360: ,p_stream_type_subclass => l_okl_poc_rec.sty_subclass_code
361: ,p_effective_date => lp_effective_date);
362:
363: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
364: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Securitization_Pvt.buyback_pool_contents',G_UNEXPECTED_ERROR));
365: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
366: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
367: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Securitization_Pvt.buyback_pool_contents',G_EXPECTED_ERROR));
368: RAISE G_EXCEPTION_ERROR;

Line 367: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Securitization_Pvt.buyback_pool_contents',G_EXPECTED_ERROR));

363: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
364: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Securitization_Pvt.buyback_pool_contents',G_UNEXPECTED_ERROR));
365: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
366: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
367: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Securitization_Pvt.buyback_pool_contents',G_EXPECTED_ERROR));
368: RAISE G_EXCEPTION_ERROR;
369: END IF;
370:
371:

Line 388: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Securitization_Pvt.BUYBACK_POOL_CONTENT',G_UNEXPECTED_ERROR));

384: ,p_effective_date => lp_effective_date
385: ,x_investor_shares_tbl => lx_investor_shares_tbl);
386:
387: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
388: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Securitization_Pvt.BUYBACK_POOL_CONTENT',G_UNEXPECTED_ERROR));
389: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
390: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
391: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Securitization_Pvt.BUYBACK_POOL_CONTENT',G_EXPECTED_ERROR));
392: RAISE G_EXCEPTION_ERROR;

Line 391: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Securitization_Pvt.BUYBACK_POOL_CONTENT',G_EXPECTED_ERROR));

387: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
388: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Securitization_Pvt.BUYBACK_POOL_CONTENT',G_UNEXPECTED_ERROR));
389: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
390: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
391: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Securitization_Pvt.BUYBACK_POOL_CONTENT',G_EXPECTED_ERROR));
392: RAISE G_EXCEPTION_ERROR;
393: END IF;
394:
395: FOR l_row_count IN 1..lx_investor_shares_tbl.COUNT

Line 407: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

403: || RPAD('-',l_sty_name_len-1,'-') || ' '
404: || RPAD('-',l_investor_len-1,'-') || ' '
405: || RPAD('-',l_amount_len,'-');
406:
407: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
408:
409: l_content := RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ROW_NUMBER),l_row_num_len-1) || ' '
410: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACT_NUMBER),l_contract_num_len-1) || ' '
411: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_NUMBER),l_asset_num_len-1) || ' '

Line 416: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

412: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE),l_sty_name_len-1) || ' '
413: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_INVESTOR),l_investor_len-1) || ' '
414: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_AMOUNT_DUE),l_amount_len);
415:
416: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
417:
418: l_content := RPAD('-',l_row_num_len-1,'-') || ' '
419: || RPAD('-',l_contract_num_len-1,'-') || ' '
420: || RPAD('-',l_asset_num_len-1,'-') || ' '

Line 425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

421: || RPAD('-',l_sty_name_len-1,'-') || ' '
422: || RPAD('-',l_investor_len-1,'-') || ' '
423: || RPAD('-',l_amount_len,'-');
424:
425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
426:
427: END IF; -- l_total_rec_count
428:
429: l_total_rec_count := l_total_rec_count+1;

Line 441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);

437: l_content := l_content || RPAD(l_okl_investor_names_rec.name ,l_investor_len)
438: || LPAD(okl_accounting_util.format_amount(lx_investor_shares_tbl(l_row_count).amount,l_okl_investor_names_rec.currency_code),l_amount_len);
439: END LOOP; -- l_okl_investor_names_csr
440:
441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);
442:
443: END LOOP; -- lx_investor_shares_tbl
444:
445: END LOOP; -- l_okl_pocs_csr

Line 451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_filler || l_content);

447:
448: IF l_total_rec_count = 0 THEN
449: -- "No Records"
450: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_NONE);
451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_filler || l_content);
452: ELSE
453: FOR l_okl_dnz_chrs_rec IN l_okl_dnz_chrs_csr(p_khr_id)
454: LOOP
455: okl_accrual_sec_pvt.cancel_streams(p_api_version => l_api_version

Line 465: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'okl_accrual_sec_pvt.cancel_streams',G_UNEXPECTED_ERROR));

461: ,p_cancel_date => lp_effective_date);
462:
463:
464: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
465: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'okl_accrual_sec_pvt.cancel_streams',G_UNEXPECTED_ERROR));
466: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
468: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'okl_accrual_sec_pvt.cancel_streams',G_EXPECTED_ERROR));
469: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 468: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'okl_accrual_sec_pvt.cancel_streams',G_EXPECTED_ERROR));

464: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
465: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'okl_accrual_sec_pvt.cancel_streams',G_UNEXPECTED_ERROR));
466: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
468: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'okl_accrual_sec_pvt.cancel_streams',G_EXPECTED_ERROR));
469: RAISE OKL_API.G_EXCEPTION_ERROR;
470: END IF;
471: END LOOP; -- l_okl_dnz_chrs_csr
472:

Line 475: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));

471: END LOOP; -- l_okl_dnz_chrs_csr
472:
473: END IF; -- l_total_rec_count
474: */
475: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
476:
477: -- Errors
478: -- sub head
479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

475: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
476:
477: -- Errors
478: -- sub head
479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
480: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_ERRORS);
481: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
482: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 481: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

477: -- Errors
478: -- sub head
479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
480: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_ERRORS);
481: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
482: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
484:
485:

Line 482: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));

478: -- sub head
479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
480: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_ERRORS);
481: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
482: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
484:
485:
486: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);

Line 483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
480: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_ERRORS);
481: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
482: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
484:
485:
486: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
487: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));

Line 487: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));

483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
484:
485:
486: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
487: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
488:
489: -- "No Errors"
490: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_NONE);
491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_filler || l_content);

Line 491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_filler || l_content);

487: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
488:
489: -- "No Errors"
490: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_NONE);
491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_filler || l_content);
492:
493: x_retcode := 0;
494:
495: EXCEPTION

Line 509: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));

505: GET_ERROR_MESSAGE(l_error_msg_rec);
506: IF (l_error_msg_rec.COUNT > 0) THEN
507: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
508: LOOP
509: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
510: END LOOP;
511: END IF;
512: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
513: x_retcode := 2;

Line 525: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));

521: GET_ERROR_MESSAGE(l_error_msg_rec);
522: IF (l_error_msg_rec.COUNT > 0) THEN
523: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
524: LOOP
525: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
526: END LOOP;
527: END IF;
528: WHEN OTHERS THEN
529: x_errbuf := SQLERRM;

Line 542: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));

538: GET_ERROR_MESSAGE(l_error_msg_rec);
539: IF (l_error_msg_rec.COUNT > 0) THEN
540: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
541: LOOP
542: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
543: END LOOP;
544: END IF;
545:
546: END buyback_agreement;

Line 699: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));

695: x_return_status => l_return_status);
696:
697:
698: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
699: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
700: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
701: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
702: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
703: RAISE G_EXCEPTION_ERROR;

Line 702: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));

698: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
699: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
700: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
701: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
702: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
703: RAISE G_EXCEPTION_ERROR;
704: END IF;
705:
706: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

Line 706: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

702: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
703: RAISE G_EXCEPTION_ERROR;
704: END IF;
705:
706: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
707: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
708:
709: -- Printing the values in the log file.
710:

Line 707: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

703: RAISE G_EXCEPTION_ERROR;
704: END IF;
705:
706: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
707: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
708:
709: -- Printing the values in the log file.
710:
711: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 711: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

707: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
708:
709: -- Printing the values in the log file.
710:
711: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
712: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_chr_id : ' || p_chr_id);
713: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
714:
715: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));

Line 712: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_chr_id : ' || p_chr_id);

708:
709: -- Printing the values in the log file.
710:
711: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
712: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_chr_id : ' || p_chr_id);
713: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
714:
715: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));
716:

Line 713: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

709: -- Printing the values in the log file.
710:
711: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
712: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_chr_id : ' || p_chr_id);
713: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
714:
715: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));
716:
717: l_chr_id := TO_NUMBER(p_chr_id);

Line 715: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));

711: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
712: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_chr_id : ' || p_chr_id);
713: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
714:
715: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));
716:
717: l_chr_id := TO_NUMBER(p_chr_id);
718:
719: --Bug 6691554 - Start of Changes

Line 736: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Sec_Concurrent_Pvt.Activate_Agreement',G_UNEXPECTED_ERROR));

732: ,p_khr_id => l_chr_id
733: );
734:
735: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
736: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Sec_Concurrent_Pvt.Activate_Agreement',G_UNEXPECTED_ERROR));
737: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
738: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
739: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Sec_Concurrent_Pvt.Activate_Agreement',G_EXPECTED_ERROR));
740: RAISE G_EXCEPTION_ERROR;

Line 739: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Sec_Concurrent_Pvt.Activate_Agreement',G_EXPECTED_ERROR));

735: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
736: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Sec_Concurrent_Pvt.Activate_Agreement',G_UNEXPECTED_ERROR));
737: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
738: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
739: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Sec_Concurrent_Pvt.Activate_Agreement',G_EXPECTED_ERROR));
740: RAISE G_EXCEPTION_ERROR;
741: END IF;
742:
743: ELSE

Line 754: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Sec_Concurrent_Pvt.Activate_Agreement',G_UNEXPECTED_ERROR));

750: ,p_khr_id => l_chr_id
751: );
752:
753: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
754: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Sec_Concurrent_Pvt.Activate_Agreement',G_UNEXPECTED_ERROR));
755: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
756: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
757: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Sec_Concurrent_Pvt.Activate_Agreement',G_EXPECTED_ERROR));
758: RAISE G_EXCEPTION_ERROR;

Line 757: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Sec_Concurrent_Pvt.Activate_Agreement',G_EXPECTED_ERROR));

753: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
754: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Sec_Concurrent_Pvt.Activate_Agreement',G_UNEXPECTED_ERROR));
755: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
756: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
757: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Sec_Concurrent_Pvt.Activate_Agreement',G_EXPECTED_ERROR));
758: RAISE G_EXCEPTION_ERROR;
759: END IF;
760:
761: END IF;

Line 763: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));

759: END IF;
760:
761: END IF;
762: --Bug 6691554 - End of Changes
763: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
764:
765: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
766: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
767:

Line 766: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));

762: --Bug 6691554 - End of Changes
763: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
764:
765: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
766: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
767:
768: x_retcode := 0;
769:
770: EXCEPTION

Line 787: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));

783: GET_ERROR_MESSAGE(l_error_msg_rec);
784: IF (l_error_msg_rec.COUNT > 0) THEN
785: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
786: LOOP
787: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
788: END LOOP;
789: END IF;
790:
791: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 805: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));

801: GET_ERROR_MESSAGE(l_error_msg_rec);
802: IF (l_error_msg_rec.COUNT > 0) THEN
803: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
804: LOOP
805: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
806: END LOOP;
807: END IF;
808:
809: WHEN OTHERS THEN

Line 825: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));

821: GET_ERROR_MESSAGE(l_error_msg_rec);
822: IF (l_error_msg_rec.COUNT > 0) THEN
823: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
824: LOOP
825: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
826: END LOOP;
827: END IF;
828:
829: END activate_agreement;