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

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

257: p_api_type => G_API_TYPE,
258: x_return_status => l_return_status);
259:
260: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
261: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
262: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
263: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
264: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
265: RAISE G_EXCEPTION_ERROR;

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

260: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
261: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
262: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
263: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
264: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
265: RAISE G_EXCEPTION_ERROR;
266: END IF;
267:
268: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

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

264: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
265: RAISE G_EXCEPTION_ERROR;
266: END IF;
267:
268: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
269: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
270:
271: -- Printing the values in the log file.
272:

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

265: RAISE G_EXCEPTION_ERROR;
266: END IF;
267:
268: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
269: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
270:
271: -- Printing the values in the log file.
272:
273: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

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

269: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
270:
271: -- Printing the values in the log file.
272:
273: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
274: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_currency_code : ' || p_currency_code);
275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pol_id : ' || p_pol_id);
276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_multi_org : ' || p_multi_org);
277:

Line 274: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_currency_code : ' || p_currency_code);

270:
271: -- Printing the values in the log file.
272:
273: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
274: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_currency_code : ' || p_currency_code);
275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pol_id : ' || p_pol_id);
276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_multi_org : ' || p_multi_org);
277:
278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_object1_id1 : ' || p_cust_object1_id1);

Line 275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pol_id : ' || p_pol_id);

271: -- Printing the values in the log file.
272:
273: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
274: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_currency_code : ' || p_currency_code);
275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pol_id : ' || p_pol_id);
276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_multi_org : ' || p_multi_org);
277:
278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_object1_id1 : ' || p_cust_object1_id1);
279:

Line 276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_multi_org : ' || p_multi_org);

272:
273: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
274: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_currency_code : ' || p_currency_code);
275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pol_id : ' || p_pol_id);
276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_multi_org : ' || p_multi_org);
277:
278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_object1_id1 : ' || p_cust_object1_id1);
279:
280: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sic_code : ' || p_sic_code);

Line 278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_object1_id1 : ' || p_cust_object1_id1);

274: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_currency_code : ' || p_currency_code);
275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pol_id : ' || p_pol_id);
276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_multi_org : ' || p_multi_org);
277:
278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_object1_id1 : ' || p_cust_object1_id1);
279:
280: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sic_code : ' || p_sic_code);
281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_khr_id : ' || p_dnz_chr_id);
282:

Line 280: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sic_code : ' || p_sic_code);

276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_multi_org : ' || p_multi_org);
277:
278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_object1_id1 : ' || p_cust_object1_id1);
279:
280: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sic_code : ' || p_sic_code);
281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_khr_id : ' || p_dnz_chr_id);
282:
283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_from : ' || p_pre_tax_yield_from);
284: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_to : ' || p_pre_tax_yield_to);

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

277:
278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_object1_id1 : ' || p_cust_object1_id1);
279:
280: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sic_code : ' || p_sic_code);
281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_khr_id : ' || p_dnz_chr_id);
282:
283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_from : ' || p_pre_tax_yield_from);
284: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_to : ' || p_pre_tax_yield_to);
285: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_book_classification : ' || p_book_classification);

Line 283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_from : ' || p_pre_tax_yield_from);

279:
280: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sic_code : ' || p_sic_code);
281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_khr_id : ' || p_dnz_chr_id);
282:
283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_from : ' || p_pre_tax_yield_from);
284: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_to : ' || p_pre_tax_yield_to);
285: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_book_classification : ' || p_book_classification);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_tax_owner : ' || p_tax_owner);
287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pdt_id : ' || p_pdt_id);

Line 284: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_to : ' || p_pre_tax_yield_to);

280: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sic_code : ' || p_sic_code);
281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_khr_id : ' || p_dnz_chr_id);
282:
283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_from : ' || p_pre_tax_yield_from);
284: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_to : ' || p_pre_tax_yield_to);
285: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_book_classification : ' || p_book_classification);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_tax_owner : ' || p_tax_owner);
287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pdt_id : ' || p_pdt_id);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date_from : ' || p_start_from_date);

Line 285: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_book_classification : ' || p_book_classification);

281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_khr_id : ' || p_dnz_chr_id);
282:
283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_from : ' || p_pre_tax_yield_from);
284: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_to : ' || p_pre_tax_yield_to);
285: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_book_classification : ' || p_book_classification);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_tax_owner : ' || p_tax_owner);
287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pdt_id : ' || p_pdt_id);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date_from : ' || p_start_from_date);
289: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date_to : ' || p_start_to_date);

Line 286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_tax_owner : ' || p_tax_owner);

282:
283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_from : ' || p_pre_tax_yield_from);
284: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_to : ' || p_pre_tax_yield_to);
285: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_book_classification : ' || p_book_classification);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_tax_owner : ' || p_tax_owner);
287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pdt_id : ' || p_pdt_id);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date_from : ' || p_start_from_date);
289: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date_to : ' || p_start_to_date);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date_from : ' || p_end_from_date);

Line 287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pdt_id : ' || p_pdt_id);

283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_from : ' || p_pre_tax_yield_from);
284: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_to : ' || p_pre_tax_yield_to);
285: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_book_classification : ' || p_book_classification);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_tax_owner : ' || p_tax_owner);
287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pdt_id : ' || p_pdt_id);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date_from : ' || p_start_from_date);
289: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date_to : ' || p_start_to_date);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date_from : ' || p_end_from_date);
291: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date_to : ' || p_end_to_date);

Line 288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date_from : ' || p_start_from_date);

284: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_to : ' || p_pre_tax_yield_to);
285: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_book_classification : ' || p_book_classification);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_tax_owner : ' || p_tax_owner);
287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pdt_id : ' || p_pdt_id);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date_from : ' || p_start_from_date);
289: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date_to : ' || p_start_to_date);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date_from : ' || p_end_from_date);
291: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date_to : ' || p_end_to_date);
292:

Line 289: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date_to : ' || p_start_to_date);

285: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_book_classification : ' || p_book_classification);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_tax_owner : ' || p_tax_owner);
287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pdt_id : ' || p_pdt_id);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date_from : ' || p_start_from_date);
289: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date_to : ' || p_start_to_date);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date_from : ' || p_end_from_date);
291: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date_to : ' || p_end_to_date);
292:
293: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_asset_id : ' || p_asset_id);

Line 290: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date_from : ' || p_end_from_date);

286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_tax_owner : ' || p_tax_owner);
287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pdt_id : ' || p_pdt_id);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date_from : ' || p_start_from_date);
289: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date_to : ' || p_start_to_date);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date_from : ' || p_end_from_date);
291: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date_to : ' || p_end_to_date);
292:
293: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_asset_id : ' || p_asset_id);
294:

Line 291: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date_to : ' || p_end_to_date);

287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pdt_id : ' || p_pdt_id);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date_from : ' || p_start_from_date);
289: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date_to : ' || p_start_to_date);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date_from : ' || p_end_from_date);
291: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date_to : ' || p_end_to_date);
292:
293: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_asset_id : ' || p_asset_id);
294:
295: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_item_id1 : ' || p_item_id1);

Line 293: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_asset_id : ' || p_asset_id);

289: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date_to : ' || p_start_to_date);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date_from : ' || p_end_from_date);
291: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date_to : ' || p_end_to_date);
292:
293: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_asset_id : ' || p_asset_id);
294:
295: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_item_id1 : ' || p_item_id1);
296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_model_number : ' || p_model_number);
297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_manufacturer_name : ' || p_manufacturer_name);

Line 295: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_item_id1 : ' || p_item_id1);

291: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date_to : ' || p_end_to_date);
292:
293: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_asset_id : ' || p_asset_id);
294:
295: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_item_id1 : ' || p_item_id1);
296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_model_number : ' || p_model_number);
297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_manufacturer_name : ' || p_manufacturer_name);
298: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_vendor_id1 : ' || p_vendor_id1);
299:

Line 296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_model_number : ' || p_model_number);

292:
293: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_asset_id : ' || p_asset_id);
294:
295: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_item_id1 : ' || p_item_id1);
296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_model_number : ' || p_model_number);
297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_manufacturer_name : ' || p_manufacturer_name);
298: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_vendor_id1 : ' || p_vendor_id1);
299:
300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_from : ' || p_oec_from);

Line 297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_manufacturer_name : ' || p_manufacturer_name);

293: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_asset_id : ' || p_asset_id);
294:
295: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_item_id1 : ' || p_item_id1);
296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_model_number : ' || p_model_number);
297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_manufacturer_name : ' || p_manufacturer_name);
298: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_vendor_id1 : ' || p_vendor_id1);
299:
300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_from : ' || p_oec_from);
301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_to : ' || p_oec_to);

Line 298: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_vendor_id1 : ' || p_vendor_id1);

294:
295: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_item_id1 : ' || p_item_id1);
296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_model_number : ' || p_model_number);
297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_manufacturer_name : ' || p_manufacturer_name);
298: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_vendor_id1 : ' || p_vendor_id1);
299:
300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_from : ' || p_oec_from);
301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_to : ' || p_oec_to);
302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_residual_percentage : ' || p_residual_percentage);

Line 300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_from : ' || p_oec_from);

296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_model_number : ' || p_model_number);
297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_manufacturer_name : ' || p_manufacturer_name);
298: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_vendor_id1 : ' || p_vendor_id1);
299:
300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_from : ' || p_oec_from);
301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_to : ' || p_oec_to);
302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_residual_percentage : ' || p_residual_percentage);
303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id1 : ' || p_sty_id1);
304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id2 : ' || p_sty_id2);

Line 301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_to : ' || p_oec_to);

297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_manufacturer_name : ' || p_manufacturer_name);
298: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_vendor_id1 : ' || p_vendor_id1);
299:
300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_from : ' || p_oec_from);
301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_to : ' || p_oec_to);
302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_residual_percentage : ' || p_residual_percentage);
303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id1 : ' || p_sty_id1);
304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id2 : ' || p_sty_id2);
305: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_from_date : ' || p_streams_from_date);

Line 302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_residual_percentage : ' || p_residual_percentage);

298: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_vendor_id1 : ' || p_vendor_id1);
299:
300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_from : ' || p_oec_from);
301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_to : ' || p_oec_to);
302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_residual_percentage : ' || p_residual_percentage);
303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id1 : ' || p_sty_id1);
304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id2 : ' || p_sty_id2);
305: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_from_date : ' || p_streams_from_date);
306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_to_date : ' || p_streams_to_date);

Line 303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id1 : ' || p_sty_id1);

299:
300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_from : ' || p_oec_from);
301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_to : ' || p_oec_to);
302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_residual_percentage : ' || p_residual_percentage);
303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id1 : ' || p_sty_id1);
304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id2 : ' || p_sty_id2);
305: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_from_date : ' || p_streams_from_date);
306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_to_date : ' || p_streams_to_date);
307: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_payment_freq : ' || p_stream_element_payment_freq);

Line 304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id2 : ' || p_sty_id2);

300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_from : ' || p_oec_from);
301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_to : ' || p_oec_to);
302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_residual_percentage : ' || p_residual_percentage);
303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id1 : ' || p_sty_id1);
304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id2 : ' || p_sty_id2);
305: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_from_date : ' || p_streams_from_date);
306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_to_date : ' || p_streams_to_date);
307: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_payment_freq : ' || p_stream_element_payment_freq);
308: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_type_subclass : ' || p_stream_type_subclass);

Line 305: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_from_date : ' || p_streams_from_date);

301: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_to : ' || p_oec_to);
302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_residual_percentage : ' || p_residual_percentage);
303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id1 : ' || p_sty_id1);
304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id2 : ' || p_sty_id2);
305: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_from_date : ' || p_streams_from_date);
306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_to_date : ' || p_streams_to_date);
307: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_payment_freq : ' || p_stream_element_payment_freq);
308: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_type_subclass : ' || p_stream_type_subclass);
309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_crd_clf_code : ' || p_cust_crd_clf_code);

Line 306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_to_date : ' || p_streams_to_date);

302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_residual_percentage : ' || p_residual_percentage);
303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id1 : ' || p_sty_id1);
304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id2 : ' || p_sty_id2);
305: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_from_date : ' || p_streams_from_date);
306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_to_date : ' || p_streams_to_date);
307: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_payment_freq : ' || p_stream_element_payment_freq);
308: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_type_subclass : ' || p_stream_type_subclass);
309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_crd_clf_code : ' || p_cust_crd_clf_code);
310: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 307: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_payment_freq : ' || p_stream_element_payment_freq);

303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id1 : ' || p_sty_id1);
304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id2 : ' || p_sty_id2);
305: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_from_date : ' || p_streams_from_date);
306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_to_date : ' || p_streams_to_date);
307: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_payment_freq : ' || p_stream_element_payment_freq);
308: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_type_subclass : ' || p_stream_type_subclass);
309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_crd_clf_code : ' || p_cust_crd_clf_code);
310: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
311:

Line 308: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_type_subclass : ' || p_stream_type_subclass);

304: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id2 : ' || p_sty_id2);
305: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_from_date : ' || p_streams_from_date);
306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_to_date : ' || p_streams_to_date);
307: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_payment_freq : ' || p_stream_element_payment_freq);
308: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_type_subclass : ' || p_stream_type_subclass);
309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_crd_clf_code : ' || p_cust_crd_clf_code);
310: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
311:
312: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));

Line 309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_crd_clf_code : ' || p_cust_crd_clf_code);

305: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_from_date : ' || p_streams_from_date);
306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_to_date : ' || p_streams_to_date);
307: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_payment_freq : ' || p_stream_element_payment_freq);
308: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_type_subclass : ' || p_stream_type_subclass);
309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_crd_clf_code : ' || p_cust_crd_clf_code);
310: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
311:
312: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));
313:

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

306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_to_date : ' || p_streams_to_date);
307: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_element_payment_freq : ' || p_stream_element_payment_freq);
308: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_type_subclass : ' || p_stream_type_subclass);
309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_crd_clf_code : ' || p_cust_crd_clf_code);
310: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
311:
312: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));
313:
314: -- Bug#2829983, v115.13

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

308: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_type_subclass : ' || p_stream_type_subclass);
309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_crd_clf_code : ' || p_cust_crd_clf_code);
310: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
311:
312: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));
313:
314: -- Bug#2829983, v115.13
315: FOR l_okl_pol_status_rec IN l_okl_pol_status_csr(p_pol_id)
316: LOOP

Line 319: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_POOL_NO_MODIFY));

315: FOR l_okl_pol_status_rec IN l_okl_pol_status_csr(p_pol_id)
316: LOOP
317: IF l_okl_pol_status_rec.status_code NOT IN (Okl_Pool_Pvt.G_POL_STS_NEW,Okl_Pool_Pvt.G_POL_STS_ACTIVE)
318: THEN
319: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_POOL_NO_MODIFY));
320: RAISE G_EXCEPTION_ERROR;
321: END IF;
322: END LOOP;
323:

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

324: -- Product Title
325: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_OKL_TITLE);
326: l_header_len := LENGTH(l_content);
327: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2); -- center align header
328: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
329: l_content := RPAD('-',l_header_len,'-'); -- underline header
330: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2,'='); -- center align
331: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
332: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

327: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2); -- center align header
328: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
329: l_content := RPAD('-',l_header_len,'-'); -- underline header
330: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2,'='); -- center align
331: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
332: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
333:
334: -- Header
335: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_ADD_REPORT);

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

328: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
329: l_content := RPAD('-',l_header_len,'-'); -- underline header
330: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2,'='); -- center align
331: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
332: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
333:
334: -- Header
335: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_ADD_REPORT);
336: l_header_len := LENGTH(l_content);

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

334: -- Header
335: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_ADD_REPORT);
336: l_header_len := LENGTH(l_content);
337: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2); -- center align header
338: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
339:
340: l_content := RPAD('=',l_header_len,'='); -- underline header
341: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2,'='); -- center align
342: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

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

338: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
339:
340: l_content := RPAD('=',l_header_len,'='); -- underline header
341: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2,'='); -- center align
342: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
343:
344: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
346:

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

340: l_content := RPAD('=',l_header_len,'='); -- underline header
341: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2,'='); -- center align
342: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
343:
344: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
346:
347: -- Set of Books, Operating Unit
348: FOR l_okl_set_of_books_rec IN l_okl_set_of_books_csr

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

341: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2,'='); -- center align
342: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
343:
344: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
346:
347: -- Set of Books, Operating Unit
348: FOR l_okl_set_of_books_rec IN l_okl_set_of_books_csr
349: LOOP

Line 350: 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);

346:
347: -- Set of Books, Operating Unit
348: FOR l_okl_set_of_books_rec IN l_okl_set_of_books_csr
349: LOOP
350: 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);
351: END LOOP;
352: FOR l_okl_operating_unit_rec IN l_okl_operating_unit_csr
353: LOOP
354: 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 354: 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);

350: 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);
351: END LOOP;
352: FOR l_okl_operating_unit_rec IN l_okl_operating_unit_csr
353: LOOP
354: 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);
355: END LOOP;
356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_PROGRAM_RUN_DATE),l_prompt_len) || ' : ' || SYSDATE);
357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
358:

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

352: FOR l_okl_operating_unit_rec IN l_okl_operating_unit_csr
353: LOOP
354: 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);
355: END LOOP;
356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_PROGRAM_RUN_DATE),l_prompt_len) || ' : ' || SYSDATE);
357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
358:
359: -- Pool Details
360: FOR l_okl_pol_rec IN l_okl_pol_csr

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

353: LOOP
354: 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);
355: END LOOP;
356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_PROGRAM_RUN_DATE),l_prompt_len) || ' : ' || SYSDATE);
357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
358:
359: -- Pool Details
360: FOR l_okl_pol_rec IN l_okl_pol_csr
361: LOOP

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

358:
359: -- Pool Details
360: FOR l_okl_pol_rec IN l_okl_pol_csr
361: LOOP
362: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_number);
363: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_STATUS),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_status);
364: END LOOP;
365:
366: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 363: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_STATUS),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_status);

359: -- Pool Details
360: FOR l_okl_pol_rec IN l_okl_pol_csr
361: LOOP
362: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_number);
363: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_STATUS),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_status);
364: END LOOP;
365:
366: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
367: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CURRENCY),l_prompt_len) || ' : ' || p_currency_code);

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

362: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_number);
363: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_STATUS),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_status);
364: END LOOP;
365:
366: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
367: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CURRENCY),l_prompt_len) || ' : ' || p_currency_code);
368:
369: -- Search Parameters
370: -- sub head

Line 367: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CURRENCY),l_prompt_len) || ' : ' || p_currency_code);

363: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_STATUS),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_status);
364: END LOOP;
365:
366: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
367: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CURRENCY),l_prompt_len) || ' : ' || p_currency_code);
368:
369: -- Search Parameters
370: -- sub head
371: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

367: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CURRENCY),l_prompt_len) || ' : ' || p_currency_code);
368:
369: -- Search Parameters
370: -- sub head
371: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
372: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_ELIGIBILITY_CRITERIA);
373: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
375:

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

369: -- Search Parameters
370: -- sub head
371: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
372: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_ELIGIBILITY_CRITERIA);
373: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
375:
376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
377: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMERS);

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

370: -- sub head
371: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
372: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_ELIGIBILITY_CRITERIA);
373: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
375:
376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
377: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMERS);
378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

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

372: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_ELIGIBILITY_CRITERIA);
373: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
375:
376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
377: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMERS);
378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
379: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));
380:

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

374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
375:
376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
377: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMERS);
378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
379: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));
380:
381: -- Customer related parameters
382: FOR l_okl_customer_rec IN l_okl_customer_csr

Line 379: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));

375:
376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
377: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMERS);
378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
379: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));
380:
381: -- Customer related parameters
382: FOR l_okl_customer_rec IN l_okl_customer_csr
383: LOOP

Line 396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER),l_prompt_len) || ' : ' || l_customer);

392: LOOP
393: l_cust_crd_clf := l_okl_cust_crdt_clsf_rec.CREDITCXLSSFCTN;
394: END LOOP;
395:
396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER),l_prompt_len) || ' : ' || l_customer);
397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER_INDUSTRY_CODE),l_prompt_len) || ' : ' || l_customer_industry);
398:
399: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUST_CRDT_CLASSIFICATION),l_prompt_len) || ' : ' || l_cust_crd_clf);
400:

Line 397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER_INDUSTRY_CODE),l_prompt_len) || ' : ' || l_customer_industry);

393: l_cust_crd_clf := l_okl_cust_crdt_clsf_rec.CREDITCXLSSFCTN;
394: END LOOP;
395:
396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER),l_prompt_len) || ' : ' || l_customer);
397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER_INDUSTRY_CODE),l_prompt_len) || ' : ' || l_customer_industry);
398:
399: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUST_CRDT_CLASSIFICATION),l_prompt_len) || ' : ' || l_cust_crd_clf);
400:
401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 399: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUST_CRDT_CLASSIFICATION),l_prompt_len) || ' : ' || l_cust_crd_clf);

395:
396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER),l_prompt_len) || ' : ' || l_customer);
397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER_INDUSTRY_CODE),l_prompt_len) || ' : ' || l_customer_industry);
398:
399: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUST_CRDT_CLASSIFICATION),l_prompt_len) || ' : ' || l_cust_crd_clf);
400:
401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
402: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACTS);
403: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

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

397: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER_INDUSTRY_CODE),l_prompt_len) || ' : ' || l_customer_industry);
398:
399: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUST_CRDT_CLASSIFICATION),l_prompt_len) || ' : ' || l_cust_crd_clf);
400:
401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
402: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACTS);
403: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
404: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));
405:

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

399: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUST_CRDT_CLASSIFICATION),l_prompt_len) || ' : ' || l_cust_crd_clf);
400:
401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
402: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACTS);
403: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
404: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));
405:
406: -- Contract related Parameters
407: FOR l_okl_chr_rec IN l_okl_chr_csr

Line 404: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));

400:
401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
402: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACTS);
403: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
404: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));
405:
406: -- Contract related Parameters
407: FOR l_okl_chr_rec IN l_okl_chr_csr
408: LOOP

Line 424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACT_NUMBER),l_prompt_len) || ' : ' || l_contract_number);

420: LOOP
421: l_product := l_okl_pdt_rec.name;
422: END LOOP;
423:
424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACT_NUMBER),l_prompt_len) || ' : ' || l_contract_number);
425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_FROM),l_prompt_len) || ' : ' || p_pre_tax_yield_from);
426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_TO),l_prompt_len) || ' : ' || p_pre_tax_yield_to);
427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_BOOK_CLASS),l_prompt_len) || ' : ' || l_book_class);
428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);

Line 425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_FROM),l_prompt_len) || ' : ' || p_pre_tax_yield_from);

421: l_product := l_okl_pdt_rec.name;
422: END LOOP;
423:
424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACT_NUMBER),l_prompt_len) || ' : ' || l_contract_number);
425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_FROM),l_prompt_len) || ' : ' || p_pre_tax_yield_from);
426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_TO),l_prompt_len) || ' : ' || p_pre_tax_yield_to);
427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_BOOK_CLASS),l_prompt_len) || ' : ' || l_book_class);
428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);
429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);

Line 426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_TO),l_prompt_len) || ' : ' || p_pre_tax_yield_to);

422: END LOOP;
423:
424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACT_NUMBER),l_prompt_len) || ' : ' || l_contract_number);
425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_FROM),l_prompt_len) || ' : ' || p_pre_tax_yield_from);
426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_TO),l_prompt_len) || ' : ' || p_pre_tax_yield_to);
427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_BOOK_CLASS),l_prompt_len) || ' : ' || l_book_class);
428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);
429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);
430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_TO_DATE),l_prompt_len) || ' : ' || p_start_to_date);

Line 427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_BOOK_CLASS),l_prompt_len) || ' : ' || l_book_class);

423:
424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACT_NUMBER),l_prompt_len) || ' : ' || l_contract_number);
425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_FROM),l_prompt_len) || ' : ' || p_pre_tax_yield_from);
426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_TO),l_prompt_len) || ' : ' || p_pre_tax_yield_to);
427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_BOOK_CLASS),l_prompt_len) || ' : ' || l_book_class);
428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);
429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);
430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_TO_DATE),l_prompt_len) || ' : ' || p_start_to_date);
431: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_FROM_DATE),l_prompt_len) || ' : ' || p_end_from_date);

Line 428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);

424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACT_NUMBER),l_prompt_len) || ' : ' || l_contract_number);
425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_FROM),l_prompt_len) || ' : ' || p_pre_tax_yield_from);
426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_TO),l_prompt_len) || ' : ' || p_pre_tax_yield_to);
427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_BOOK_CLASS),l_prompt_len) || ' : ' || l_book_class);
428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);
429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);
430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_TO_DATE),l_prompt_len) || ' : ' || p_start_to_date);
431: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_FROM_DATE),l_prompt_len) || ' : ' || p_end_from_date);
432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_TO_DATE),l_prompt_len) || ' : ' || p_end_to_date);

Line 429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);

425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_FROM),l_prompt_len) || ' : ' || p_pre_tax_yield_from);
426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_TO),l_prompt_len) || ' : ' || p_pre_tax_yield_to);
427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_BOOK_CLASS),l_prompt_len) || ' : ' || l_book_class);
428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);
429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);
430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_TO_DATE),l_prompt_len) || ' : ' || p_start_to_date);
431: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_FROM_DATE),l_prompt_len) || ' : ' || p_end_from_date);
432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_TO_DATE),l_prompt_len) || ' : ' || p_end_to_date);
433: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PRODUCT),l_prompt_len) || ' : ' || l_product);

Line 430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_TO_DATE),l_prompt_len) || ' : ' || p_start_to_date);

426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_TO),l_prompt_len) || ' : ' || p_pre_tax_yield_to);
427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_BOOK_CLASS),l_prompt_len) || ' : ' || l_book_class);
428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);
429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);
430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_TO_DATE),l_prompt_len) || ' : ' || p_start_to_date);
431: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_FROM_DATE),l_prompt_len) || ' : ' || p_end_from_date);
432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_TO_DATE),l_prompt_len) || ' : ' || p_end_to_date);
433: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PRODUCT),l_prompt_len) || ' : ' || l_product);
434:

Line 431: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_FROM_DATE),l_prompt_len) || ' : ' || p_end_from_date);

427: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_BOOK_CLASS),l_prompt_len) || ' : ' || l_book_class);
428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);
429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);
430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_TO_DATE),l_prompt_len) || ' : ' || p_start_to_date);
431: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_FROM_DATE),l_prompt_len) || ' : ' || p_end_from_date);
432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_TO_DATE),l_prompt_len) || ' : ' || p_end_to_date);
433: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PRODUCT),l_prompt_len) || ' : ' || l_product);
434:
435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_TO_DATE),l_prompt_len) || ' : ' || p_end_to_date);

428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);
429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);
430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_TO_DATE),l_prompt_len) || ' : ' || p_start_to_date);
431: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_FROM_DATE),l_prompt_len) || ' : ' || p_end_from_date);
432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_TO_DATE),l_prompt_len) || ' : ' || p_end_to_date);
433: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PRODUCT),l_prompt_len) || ' : ' || l_product);
434:
435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
436: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS);

Line 433: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PRODUCT),l_prompt_len) || ' : ' || l_product);

429: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);
430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_TO_DATE),l_prompt_len) || ' : ' || p_start_to_date);
431: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_FROM_DATE),l_prompt_len) || ' : ' || p_end_from_date);
432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_TO_DATE),l_prompt_len) || ' : ' || p_end_to_date);
433: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PRODUCT),l_prompt_len) || ' : ' || l_product);
434:
435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
436: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS);
437: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

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

431: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_FROM_DATE),l_prompt_len) || ' : ' || p_end_from_date);
432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_TO_DATE),l_prompt_len) || ' : ' || p_end_to_date);
433: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PRODUCT),l_prompt_len) || ' : ' || l_product);
434:
435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
436: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS);
437: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));
439:

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

433: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PRODUCT),l_prompt_len) || ' : ' || l_product);
434:
435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
436: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS);
437: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));
439:
440: -- Stream related Parameters
441: IF p_stream_type_subclass IS NOT NULL THEN

Line 438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));

434:
435: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
436: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS);
437: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));
439:
440: -- Stream related Parameters
441: IF p_stream_type_subclass IS NOT NULL THEN
442: FOR l_okl_sty_subclass_rec IN l_okl_sty_subclass_csr

Line 448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_prompt_len) || ' : ' || l_stream_type_subclass);

444: l_stream_type_subclass := l_okl_sty_subclass_rec.meaning;
445: END LOOP;
446: END IF;
447:
448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_prompt_len) || ' : ' || l_stream_type_subclass);
449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_FROM_DATE),l_prompt_len) || ' : ' || p_streams_from_date);
450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_TO_DATE),l_prompt_len) || ' : ' || p_streams_to_date);
451:
452: /*

Line 449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_FROM_DATE),l_prompt_len) || ' : ' || p_streams_from_date);

445: END LOOP;
446: END IF;
447:
448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_prompt_len) || ' : ' || l_stream_type_subclass);
449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_FROM_DATE),l_prompt_len) || ' : ' || p_streams_from_date);
450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_TO_DATE),l_prompt_len) || ' : ' || p_streams_to_date);
451:
452: /*
453: -- Note preceding Table Header

Line 450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_TO_DATE),l_prompt_len) || ' : ' || p_streams_to_date);

446: END IF;
447:
448: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_prompt_len) || ' : ' || l_stream_type_subclass);
449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_FROM_DATE),l_prompt_len) || ' : ' || p_streams_from_date);
450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_TO_DATE),l_prompt_len) || ' : ' || p_streams_to_date);
451:
452: /*
453: -- Note preceding Table Header
454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_TO_DATE),l_prompt_len) || ' : ' || p_streams_to_date);
451:
452: /*
453: -- Note preceding Table Header
454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_ADD_TBL_HDR));
456:
457: -- Table header
458: l_content := RPAD('-',l_row_num_len-1,'-') || ' '

Line 455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_ADD_TBL_HDR));

451:
452: /*
453: -- Note preceding Table Header
454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_ADD_TBL_HDR));
456:
457: -- Table header
458: l_content := RPAD('-',l_row_num_len-1,'-') || ' '
459: || RPAD('-',l_contract_num_len-1,'-') || ' '

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

461: || RPAD('-',l_lessee_len-1,'-') || ' '
462: || RPAD('-',l_sty_subclass_len-1,'-') || ' '
463: || RPAD('-',l_reject_code_len-1,'-');
464:
465: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
466:
467: l_content := RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ROW_NUMBER),l_row_num_len-1) || ' '
468: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACT_NUMBER),l_contract_num_len-1) || ' '
469: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_NUMBER),l_asset_num_len-1) || ' '

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

470: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_LESSEE),l_lessee_len-1) || ' '
471: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_sty_subclass_len-1) || ' '
472: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_REJECT_REASON_CODE),l_reject_code_len-1);
473:
474: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
475:
476: l_content := RPAD('-',l_row_num_len-1,'-') || ' '
477: || RPAD('-',l_contract_num_len-1,'-') || ' '
478: || RPAD('-',l_asset_num_len-1,'-') || ' '

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

479: || RPAD('-',l_lessee_len-1,'-') || ' '
480: || RPAD('-',l_sty_subclass_len-1,'-') || ' '
481: || RPAD('-',l_reject_code_len-1,'-');
482:
483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
484:
485: */
486: Okl_Pool_Pvt.add_pool_contents(
487: p_api_version => l_api_version

Line 525: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || l_row_count);

521: ,p_stream_type_subclass => p_stream_type_subclass
522: ,p_cust_crd_clf_code => p_cust_crd_clf_code);
523:
524:
525: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || l_row_count);
526:
527: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
528: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.ADD_POOL_CONTENTS',G_UNEXPECTED_ERROR));
529: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 528: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.ADD_POOL_CONTENTS',G_UNEXPECTED_ERROR));

524:
525: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || l_row_count);
526:
527: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
528: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.ADD_POOL_CONTENTS',G_UNEXPECTED_ERROR));
529: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
530: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
531: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.ADD_POOL_CONTENTS',G_EXPECTED_ERROR));
532: RAISE G_EXCEPTION_ERROR;

Line 531: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.ADD_POOL_CONTENTS',G_EXPECTED_ERROR));

527: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
528: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.ADD_POOL_CONTENTS',G_UNEXPECTED_ERROR));
529: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
530: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
531: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.ADD_POOL_CONTENTS',G_EXPECTED_ERROR));
532: RAISE G_EXCEPTION_ERROR;
533: END IF;
534: /*
535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

531: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.ADD_POOL_CONTENTS',G_EXPECTED_ERROR));
532: RAISE G_EXCEPTION_ERROR;
533: END IF;
534: /*
535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING(G_APP_NAME,G_REJECT_REASON_CODES));
537:
538: -- Listing Reason Code Meaning-s
539: FOR l_okl_reject_codes_rec IN l_okl_reject_codes_csr

Line 536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING(G_APP_NAME,G_REJECT_REASON_CODES));

532: RAISE G_EXCEPTION_ERROR;
533: END IF;
534: /*
535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING(G_APP_NAME,G_REJECT_REASON_CODES));
537:
538: -- Listing Reason Code Meaning-s
539: FOR l_okl_reject_codes_rec IN l_okl_reject_codes_csr
540: LOOP

Line 541: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_filler || l_okl_reject_codes_rec.lookup_code

537:
538: -- Listing Reason Code Meaning-s
539: FOR l_okl_reject_codes_rec IN l_okl_reject_codes_csr
540: LOOP
541: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_filler || l_okl_reject_codes_rec.lookup_code
542: || ' => '
543: || l_okl_reject_codes_rec.meaning);
544: END LOOP; */
545:

Line 551: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message('Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT','',G_PROCESS_START));

547: /* v115.16, mvasudev
548: --
549: -- update total principal amount at okl_pools
550: --
551: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message('Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT','',G_PROCESS_START));
552:
553: Okl_Pool_Pvt.recal_tot_princ_amt(
554: p_api_version => l_api_version
555: ,p_init_msg_list => l_init_msg_list

Line 563: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: p_pol_id : ' || p_pol_id);

559: ,x_value => l_amount
560: ,p_pol_id => p_pol_id);
561:
562:
563: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: p_pol_id : ' || p_pol_id);
564: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: x_value : ' || l_amount);
565:
566: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
567: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));

Line 564: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: x_value : ' || l_amount);

560: ,p_pol_id => p_pol_id);
561:
562:
563: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: p_pol_id : ' || p_pol_id);
564: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: x_value : ' || l_amount);
565:
566: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
567: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
568: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 567: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));

563: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: p_pol_id : ' || p_pol_id);
564: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: x_value : ' || l_amount);
565:
566: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
567: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
568: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
569: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
570: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));
571: RAISE G_EXCEPTION_ERROR;

Line 570: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));

566: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
567: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
568: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
569: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
570: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));
571: RAISE G_EXCEPTION_ERROR;
572: END IF;
573: */
574:

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

571: RAISE G_EXCEPTION_ERROR;
572: END IF;
573: */
574:
575: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
576:
577: -- Errors
578: -- sub head
579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

575: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
576:
577: -- Errors
578: -- sub head
579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
580: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_ERRORS);
581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
582: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
583: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

577: -- Errors
578: -- sub head
579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
580: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_ERRORS);
581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
582: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
583: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
584:
585: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);

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

578: -- sub head
579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
580: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_ERRORS);
581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
582: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
583: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
584:
585: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
586: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));

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

579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
580: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_ERRORS);
581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
582: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
583: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
584:
585: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
586: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
587:

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

582: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
583: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
584:
585: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
586: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
587:
588: -- "No Errors"
589: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_NONE);
590: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_filler || l_content);

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

586: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
587:
588: -- "No Errors"
589: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_NONE);
590: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_filler || l_content);
591:
592: x_retcode := 0;
593:
594: EXCEPTION

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

607: GET_ERROR_MESSAGE(l_error_msg_rec);
608: IF (l_error_msg_rec.COUNT > 0) THEN
609: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
610: LOOP
611: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
612: END LOOP;
613: END IF;
614:
615: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN

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

625: GET_ERROR_MESSAGE(l_error_msg_rec);
626: IF (l_error_msg_rec.COUNT > 0) THEN
627: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
628: LOOP
629: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
630: END LOOP;
631: END IF;
632:
633: WHEN OTHERS THEN

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

645: GET_ERROR_MESSAGE(l_error_msg_rec);
646: IF (l_error_msg_rec.COUNT > 0) THEN
647: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
648: LOOP
649: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
650: END LOOP;
651: END IF;
652: END add_pool_contents;
653:

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

838: p_api_type => G_API_TYPE,
839: x_return_status => l_return_status);
840:
841: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
842: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
843: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
844: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
845: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
846: RAISE G_EXCEPTION_ERROR;

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

841: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
842: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
843: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
844: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
845: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
846: RAISE G_EXCEPTION_ERROR;
847: END IF;
848: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
849: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

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

844: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
845: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
846: RAISE G_EXCEPTION_ERROR;
847: END IF;
848: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
849: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
850:
851: -- Printing the values in the log file.
852: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

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

845: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
846: RAISE G_EXCEPTION_ERROR;
847: END IF;
848: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
849: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
850:
851: -- Printing the values in the log file.
852: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pool_number : ' || p_pool_number);

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

848: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
849: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
850:
851: -- Printing the values in the log file.
852: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pool_number : ' || p_pool_number);
854: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
855:
856:

Line 853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pool_number : ' || p_pool_number);

849: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
850:
851: -- Printing the values in the log file.
852: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pool_number : ' || p_pool_number);
854: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
855:
856:
857: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));

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

850:
851: -- Printing the values in the log file.
852: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pool_number : ' || p_pool_number);
854: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
855:
856:
857: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));
858:

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

853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pool_number : ' || p_pool_number);
854: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
855:
856:
857: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));
858:
859: IF (p_pool_number IS NOT NULL) THEN
860:
861: OPEN c_pool;

Line 875: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));

871: ,x_value => l_amount
872: ,p_pol_id => l_pol_id);
873:
874: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
875: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
876: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
877: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
878: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));
879: RAISE G_EXCEPTION_ERROR;

Line 878: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));

874: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
875: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
876: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
877: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
878: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));
879: RAISE G_EXCEPTION_ERROR;
880: END IF;
881:
882: i := 1; -- default

Line 883: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_pol_id);

879: RAISE G_EXCEPTION_ERROR;
880: END IF;
881:
882: i := 1; -- default
883: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_pol_id);
884: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: x_value : ' || l_amount);
885:
886: ELSE
887: OPEN c_pol;

Line 884: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: x_value : ' || l_amount);

880: END IF;
881:
882: i := 1; -- default
883: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_pol_id);
884: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: x_value : ' || l_amount);
885:
886: ELSE
887: OPEN c_pol;
888: i := 0;

Line 906: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));

902: ,x_value => l_amount
903: ,p_pol_id => l_pol_id);
904:
905: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
906: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
907: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
908: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
909: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));
910: RAISE G_EXCEPTION_ERROR;

Line 909: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));

905: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
906: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
907: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
908: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
909: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));
910: RAISE G_EXCEPTION_ERROR;
911: END IF;
912:
913: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_pol_id);

Line 913: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_pol_id);

909: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));
910: RAISE G_EXCEPTION_ERROR;
911: END IF;
912:
913: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_pol_id);
914: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: x_value : ' || l_amount);
915:
916: i := i+1;
917: END LOOP;

Line 914: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: x_value : ' || l_amount);

910: RAISE G_EXCEPTION_ERROR;
911: END IF;
912:
913: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_pol_id);
914: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: x_value : ' || l_amount);
915:
916: i := i+1;
917: END LOOP;
918: CLOSE c_pol;

Line 922: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || i);

918: CLOSE c_pol;
919:
920: END IF;
921:
922: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || i);
923: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));
924: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
925:
926: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);

Line 923: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));

919:
920: END IF;
921:
922: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || i);
923: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));
924: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
925:
926: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
927: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));

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

920: END IF;
921:
922: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || i);
923: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));
924: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
925:
926: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
927: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
928:

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

923: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));
924: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
925:
926: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
927: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
928:
929: x_retcode := 0;
930:
931: EXCEPTION

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

941: GET_ERROR_MESSAGE(l_error_msg_rec);
942: IF (l_error_msg_rec.COUNT > 0) THEN
943: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
944: LOOP
945: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
946: END LOOP;
947: END IF;
948: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
949: x_retcode := 2;

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

957: GET_ERROR_MESSAGE(l_error_msg_rec);
958: IF (l_error_msg_rec.COUNT > 0) THEN
959: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
960: LOOP
961: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
962: END LOOP;
963: END IF;
964: WHEN OTHERS THEN
965: x_errbuf := SQLERRM;

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

974: GET_ERROR_MESSAGE(l_error_msg_rec);
975: IF (l_error_msg_rec.COUNT > 0) THEN
976: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
977: LOOP
978: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
979: END LOOP;
980: END IF;
981: END recal_tot_princ_amt;
982:

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

1138: p_api_type => G_API_TYPE,
1139: x_return_status => l_return_status);
1140:
1141: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1142: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
1143: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1144: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1145: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
1146: RAISE G_EXCEPTION_ERROR;

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

1141: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1142: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
1143: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1144: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1145: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
1146: RAISE G_EXCEPTION_ERROR;
1147: END IF;
1148:
1149: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

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

1145: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
1146: RAISE G_EXCEPTION_ERROR;
1147: END IF;
1148:
1149: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
1150: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1151:
1152: -- Printing the values in the log file.
1153:

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

1146: RAISE G_EXCEPTION_ERROR;
1147: END IF;
1148:
1149: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
1150: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1151:
1152: -- Printing the values in the log file.
1153:
1154: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

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

1150: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1151:
1152: -- Printing the values in the log file.
1153:
1154: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1155: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pool_number : ' || p_pool_number);
1156: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1157:
1158: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));

Line 1155: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pool_number : ' || p_pool_number);

1151:
1152: -- Printing the values in the log file.
1153:
1154: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1155: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pool_number : ' || p_pool_number);
1156: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1157:
1158: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));
1159:

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

1152: -- Printing the values in the log file.
1153:
1154: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1155: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pool_number : ' || p_pool_number);
1156: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1157:
1158: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));
1159:
1160:

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

1154: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1155: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pool_number : ' || p_pool_number);
1156: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1157:
1158: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));
1159:
1160:
1161: -- Reconcile the specified Pool
1162: IF (p_pool_number IS NOT NULL) THEN

Line 1177: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));

1173: ,x_msg_data => l_msg_data
1174: ,x_reconciled => l_reconciled);
1175:
1176: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1177: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));
1178: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1179: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1180: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1181: RAISE G_EXCEPTION_ERROR;

Line 1180: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));

1176: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1177: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));
1178: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1179: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1180: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1181: RAISE G_EXCEPTION_ERROR;
1182: END IF;
1183:
1184: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pol_rec.id);

Line 1184: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pol_rec.id);

1180: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1181: RAISE G_EXCEPTION_ERROR;
1182: END IF;
1183:
1184: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pol_rec.id);
1185: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: x_reconciled : ' || l_reconciled);
1186:
1187: i := i + 1;
1188: END LOOP;

Line 1185: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: x_reconciled : ' || l_reconciled);

1181: RAISE G_EXCEPTION_ERROR;
1182: END IF;
1183:
1184: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pol_rec.id);
1185: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: x_reconciled : ' || l_reconciled);
1186:
1187: i := i + 1;
1188: END LOOP;
1189:

Line 1191: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_RECONCILE_ERROR));

1187: i := i + 1;
1188: END LOOP;
1189:
1190: IF i = 0 THEN
1191: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_RECONCILE_ERROR));
1192: RAISE G_EXCEPTION_ERROR;
1193: END IF;
1194: -- Reconcile all non-attached Pools
1195: ELSE

Line 1208: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));

1204: ,x_msg_data => l_msg_data
1205: ,x_reconciled => l_reconciled);
1206:
1207: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1208: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));
1209: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1210: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1211: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1212: RAISE G_EXCEPTION_ERROR;

Line 1211: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));

1207: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1208: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));
1209: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1210: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1211: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1212: RAISE G_EXCEPTION_ERROR;
1213: END IF;
1214:
1215: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pols_rec.id);

Line 1215: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pols_rec.id);

1211: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1212: RAISE G_EXCEPTION_ERROR;
1213: END IF;
1214:
1215: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pols_rec.id);
1216: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: x_reconciled : ' || l_reconciled);
1217:
1218: i := i + 1;
1219: END LOOP;

Line 1216: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: x_reconciled : ' || l_reconciled);

1212: RAISE G_EXCEPTION_ERROR;
1213: END IF;
1214:
1215: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pols_rec.id);
1216: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: x_reconciled : ' || l_reconciled);
1217:
1218: i := i + 1;
1219: END LOOP;
1220: END IF;

Line 1222: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || i);

1218: i := i + 1;
1219: END LOOP;
1220: END IF;
1221:
1222: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || i);
1223: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));
1224: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
1225:
1226: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);

Line 1223: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));

1219: END LOOP;
1220: END IF;
1221:
1222: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || i);
1223: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));
1224: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
1225:
1226: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));

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

1220: END IF;
1221:
1222: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || i);
1223: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));
1224: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
1225:
1226: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
1228:

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

1223: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));
1224: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
1225:
1226: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
1228:
1229: EXCEPTION
1230: WHEN G_EXCEPTION_ERROR THEN
1231: x_retcode := 2;

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

1239: GET_ERROR_MESSAGE(l_error_msg_rec);
1240: IF (l_error_msg_rec.COUNT > 0) THEN
1241: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
1242: LOOP
1243: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
1244: END LOOP;
1245: END IF;
1246: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1247: x_retcode := 2;

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

1255: GET_ERROR_MESSAGE(l_error_msg_rec);
1256: IF (l_error_msg_rec.COUNT > 0) THEN
1257: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
1258: LOOP
1259: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
1260: END LOOP;
1261: END IF;
1262: WHEN OTHERS THEN
1263: x_errbuf := SQLERRM;

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

1272: GET_ERROR_MESSAGE(l_error_msg_rec);
1273: IF (l_error_msg_rec.COUNT > 0) THEN
1274: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
1275: LOOP
1276: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
1277: END LOOP;
1278: END IF;
1279:
1280: END reconcile_pool_contents;

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

1341: p_api_type => G_API_TYPE,
1342: x_return_status => l_return_status);
1343:
1344: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1345: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
1346: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1347: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1348: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
1349: RAISE G_EXCEPTION_ERROR;

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

1344: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1345: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
1346: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1347: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1348: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
1349: RAISE G_EXCEPTION_ERROR;
1350: END IF;
1351:
1352: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

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

1348: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
1349: RAISE G_EXCEPTION_ERROR;
1350: END IF;
1351:
1352: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
1353: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1354:
1355: -- Printing the values in the log file.
1356:

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

1349: RAISE G_EXCEPTION_ERROR;
1350: END IF;
1351:
1352: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
1353: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1354:
1355: -- Printing the values in the log file.
1356:
1357: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

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

1353: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1354:
1355: -- Printing the values in the log file.
1356:
1357: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1358: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pool_number : ' || p_pool_number);
1359: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1360:
1361: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));

Line 1358: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pool_number : ' || p_pool_number);

1354:
1355: -- Printing the values in the log file.
1356:
1357: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1358: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pool_number : ' || p_pool_number);
1359: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1360:
1361: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));
1362:

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

1355: -- Printing the values in the log file.
1356:
1357: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1358: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pool_number : ' || p_pool_number);
1359: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1360:
1361: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));
1362:
1363:

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

1357: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1358: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pool_number : ' || p_pool_number);
1359: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1360:
1361: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));
1362:
1363:
1364: -- Reconcile the specified Pool
1365: IF (p_pool_number IS NOT NULL) THEN

Line 1372: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'','OKL_NO_PENDING_POC'));

1368:
1369: FOR l_okl_pol_rec IN l_okl_pol_csr(p_pool_number)
1370: LOOP
1371: IF l_okl_pol_csr%NOTFOUND THEN
1372: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'','OKL_NO_PENDING_POC'));
1373: ELSE
1374: Okl_Pool_Pvt.reconcile_contents(p_api_version => l_api_version
1375: ,p_init_msg_list => l_init_msg_list
1376: ,p_pol_id => l_okl_pol_rec.id

Line 1384: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));

1380: ,x_msg_data => l_msg_data
1381: ,x_reconciled => l_reconciled);
1382:
1383: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1384: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));
1385: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1386: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1387: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1388: RAISE G_EXCEPTION_ERROR;

Line 1387: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));

1383: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1384: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));
1385: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1386: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1387: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1388: RAISE G_EXCEPTION_ERROR;
1389: END IF;
1390:
1391: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pol_rec.id);

Line 1391: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pol_rec.id);

1387: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1388: RAISE G_EXCEPTION_ERROR;
1389: END IF;
1390:
1391: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pol_rec.id);
1392: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: x_reconciled : ' || l_reconciled);
1393:
1394: i := i + 1;
1395: END IF;

Line 1392: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: x_reconciled : ' || l_reconciled);

1388: RAISE G_EXCEPTION_ERROR;
1389: END IF;
1390:
1391: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pol_rec.id);
1392: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: x_reconciled : ' || l_reconciled);
1393:
1394: i := i + 1;
1395: END IF;
1396: END LOOP;

Line 1399: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_RECONCILE_ERROR));

1395: END IF;
1396: END LOOP;
1397:
1398: IF i = 0 THEN
1399: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_RECONCILE_ERROR));
1400: RAISE G_EXCEPTION_ERROR;
1401: END IF;
1402: -- Reconcile all non-attached Pools
1403: ELSE

Line 1408: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'','OKL_NO_PENDING_POC'));

1404: i := 0;
1405: FOR l_okl_pols_rec IN l_okl_pols_csr
1406: LOOP
1407: IF l_okl_pol_csr%NOTFOUND THEN
1408: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'','OKL_NO_PENDING_POC'));
1409: ELSE
1410: Okl_Pool_Pvt.reconcile_contents(p_api_version => l_api_version
1411: ,p_init_msg_list => l_init_msg_list
1412: ,p_pol_id => l_okl_pols_rec.id

Line 1420: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));

1416: ,x_msg_data => l_msg_data
1417: ,x_reconciled => l_reconciled);
1418:
1419: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1420: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));
1421: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1422: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1423: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1424: RAISE G_EXCEPTION_ERROR;

Line 1423: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));

1419: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1420: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_UNEXPECTED_ERROR));
1421: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1422: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1423: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1424: RAISE G_EXCEPTION_ERROR;
1425: END IF;
1426:
1427: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pols_rec.id);

Line 1427: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pols_rec.id);

1423: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECONCILE_CONTENTS',G_EXPECTED_ERROR));
1424: RAISE G_EXCEPTION_ERROR;
1425: END IF;
1426:
1427: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pols_rec.id);
1428: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: x_reconciled : ' || l_reconciled);
1429:
1430: i := i + 1;
1431: END IF;

Line 1428: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: x_reconciled : ' || l_reconciled);

1424: RAISE G_EXCEPTION_ERROR;
1425: END IF;
1426:
1427: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: p_pol_id : ' || l_okl_pols_rec.id);
1428: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME || '.' || l_api_name || ':: x_reconciled : ' || l_reconciled);
1429:
1430: i := i + 1;
1431: END IF;
1432: END LOOP;

Line 1435: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || i);

1431: END IF;
1432: END LOOP;
1433: END IF;
1434:
1435: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || i);
1436: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));
1437: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
1438:
1439: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);

Line 1436: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));

1432: END LOOP;
1433: END IF;
1434:
1435: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || i);
1436: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));
1437: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
1438:
1439: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
1440: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));

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

1433: END IF;
1434:
1435: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || i);
1436: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));
1437: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
1438:
1439: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
1440: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
1441:

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

1436: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));
1437: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
1438:
1439: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
1440: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
1441:
1442: EXCEPTION
1443: WHEN G_EXCEPTION_ERROR THEN
1444: x_retcode := 2;

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

1452: GET_ERROR_MESSAGE(l_error_msg_rec);
1453: IF (l_error_msg_rec.COUNT > 0) THEN
1454: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
1455: LOOP
1456: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
1457: END LOOP;
1458: END IF;
1459: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1460: x_retcode := 2;

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

1468: GET_ERROR_MESSAGE(l_error_msg_rec);
1469: IF (l_error_msg_rec.COUNT > 0) THEN
1470: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
1471: LOOP
1472: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
1473: END LOOP;
1474: END IF;
1475: WHEN OTHERS THEN
1476: x_errbuf := SQLERRM;

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

1485: GET_ERROR_MESSAGE(l_error_msg_rec);
1486: IF (l_error_msg_rec.COUNT > 0) THEN
1487: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
1488: LOOP
1489: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
1490: END LOOP;
1491: END IF;
1492:
1493: END recon_pnd_pool_con;

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

1824: p_api_type => G_API_TYPE,
1825: x_return_status => l_return_status);
1826:
1827: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1828: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
1829: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1830: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1831: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
1832: RAISE G_EXCEPTION_ERROR;

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

1827: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1828: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
1829: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1830: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1831: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
1832: RAISE G_EXCEPTION_ERROR;
1833: END IF;
1834:
1835: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

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

1831: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
1832: RAISE G_EXCEPTION_ERROR;
1833: END IF;
1834:
1835: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
1836: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1837:
1838: -- Printing the values in the log file.
1839:

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

1832: RAISE G_EXCEPTION_ERROR;
1833: END IF;
1834:
1835: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
1836: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1837:
1838: -- Printing the values in the log file.
1839:
1840: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

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

1836: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1837:
1838: -- Printing the values in the log file.
1839:
1840: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1841: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pol_id : ' || p_pol_id);
1842: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_multi_org : ' || p_multi_org);
1843: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_object1_id1 : ' || p_cust_object1_id1);
1844:

Line 1841: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pol_id : ' || p_pol_id);

1837:
1838: -- Printing the values in the log file.
1839:
1840: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1841: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pol_id : ' || p_pol_id);
1842: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_multi_org : ' || p_multi_org);
1843: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_object1_id1 : ' || p_cust_object1_id1);
1844:
1845: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sic_code : ' || p_sic_code);

Line 1842: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_multi_org : ' || p_multi_org);

1838: -- Printing the values in the log file.
1839:
1840: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1841: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pol_id : ' || p_pol_id);
1842: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_multi_org : ' || p_multi_org);
1843: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_object1_id1 : ' || p_cust_object1_id1);
1844:
1845: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sic_code : ' || p_sic_code);
1846: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dnz_chr_id : ' || p_dnz_chr_id);

Line 1843: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_object1_id1 : ' || p_cust_object1_id1);

1839:
1840: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1841: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pol_id : ' || p_pol_id);
1842: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_multi_org : ' || p_multi_org);
1843: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_object1_id1 : ' || p_cust_object1_id1);
1844:
1845: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sic_code : ' || p_sic_code);
1846: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dnz_chr_id : ' || p_dnz_chr_id);
1847: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_from : ' || p_pre_tax_yield_from);

Line 1845: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sic_code : ' || p_sic_code);

1841: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pol_id : ' || p_pol_id);
1842: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_multi_org : ' || p_multi_org);
1843: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_object1_id1 : ' || p_cust_object1_id1);
1844:
1845: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sic_code : ' || p_sic_code);
1846: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dnz_chr_id : ' || p_dnz_chr_id);
1847: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_from : ' || p_pre_tax_yield_from);
1848: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_to : ' || p_pre_tax_yield_to);
1849: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_book_classification : ' || p_book_classification);

Line 1846: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dnz_chr_id : ' || p_dnz_chr_id);

1842: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_multi_org : ' || p_multi_org);
1843: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_object1_id1 : ' || p_cust_object1_id1);
1844:
1845: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sic_code : ' || p_sic_code);
1846: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dnz_chr_id : ' || p_dnz_chr_id);
1847: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_from : ' || p_pre_tax_yield_from);
1848: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_to : ' || p_pre_tax_yield_to);
1849: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_book_classification : ' || p_book_classification);
1850: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_tax_owner : ' || p_tax_owner);

Line 1847: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_from : ' || p_pre_tax_yield_from);

1843: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_object1_id1 : ' || p_cust_object1_id1);
1844:
1845: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sic_code : ' || p_sic_code);
1846: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dnz_chr_id : ' || p_dnz_chr_id);
1847: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_from : ' || p_pre_tax_yield_from);
1848: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_to : ' || p_pre_tax_yield_to);
1849: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_book_classification : ' || p_book_classification);
1850: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_tax_owner : ' || p_tax_owner);
1851: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_from_date : ' || p_start_from_date);

Line 1848: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_to : ' || p_pre_tax_yield_to);

1844:
1845: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sic_code : ' || p_sic_code);
1846: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dnz_chr_id : ' || p_dnz_chr_id);
1847: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_from : ' || p_pre_tax_yield_from);
1848: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_to : ' || p_pre_tax_yield_to);
1849: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_book_classification : ' || p_book_classification);
1850: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_tax_owner : ' || p_tax_owner);
1851: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_from_date : ' || p_start_from_date);
1852: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_to_date : ' || p_start_to_date);

Line 1849: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_book_classification : ' || p_book_classification);

1845: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sic_code : ' || p_sic_code);
1846: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dnz_chr_id : ' || p_dnz_chr_id);
1847: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_from : ' || p_pre_tax_yield_from);
1848: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_to : ' || p_pre_tax_yield_to);
1849: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_book_classification : ' || p_book_classification);
1850: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_tax_owner : ' || p_tax_owner);
1851: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_from_date : ' || p_start_from_date);
1852: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_to_date : ' || p_start_to_date);
1853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_from_date : ' || p_end_from_date);

Line 1850: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_tax_owner : ' || p_tax_owner);

1846: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dnz_chr_id : ' || p_dnz_chr_id);
1847: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_from : ' || p_pre_tax_yield_from);
1848: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_to : ' || p_pre_tax_yield_to);
1849: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_book_classification : ' || p_book_classification);
1850: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_tax_owner : ' || p_tax_owner);
1851: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_from_date : ' || p_start_from_date);
1852: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_to_date : ' || p_start_to_date);
1853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_from_date : ' || p_end_from_date);
1854: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_to_date : ' || p_end_to_date);

Line 1851: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_from_date : ' || p_start_from_date);

1847: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_from : ' || p_pre_tax_yield_from);
1848: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_to : ' || p_pre_tax_yield_to);
1849: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_book_classification : ' || p_book_classification);
1850: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_tax_owner : ' || p_tax_owner);
1851: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_from_date : ' || p_start_from_date);
1852: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_to_date : ' || p_start_to_date);
1853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_from_date : ' || p_end_from_date);
1854: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_to_date : ' || p_end_to_date);
1855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_asset_id : ' || p_asset_id);

Line 1852: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_to_date : ' || p_start_to_date);

1848: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_pre_tax_yield_to : ' || p_pre_tax_yield_to);
1849: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_book_classification : ' || p_book_classification);
1850: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_tax_owner : ' || p_tax_owner);
1851: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_from_date : ' || p_start_from_date);
1852: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_to_date : ' || p_start_to_date);
1853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_from_date : ' || p_end_from_date);
1854: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_to_date : ' || p_end_to_date);
1855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_asset_id : ' || p_asset_id);
1856: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_item_id1 : ' || p_item_id1);

Line 1853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_from_date : ' || p_end_from_date);

1849: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_book_classification : ' || p_book_classification);
1850: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_tax_owner : ' || p_tax_owner);
1851: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_from_date : ' || p_start_from_date);
1852: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_to_date : ' || p_start_to_date);
1853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_from_date : ' || p_end_from_date);
1854: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_to_date : ' || p_end_to_date);
1855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_asset_id : ' || p_asset_id);
1856: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_item_id1 : ' || p_item_id1);
1857: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_model_number : ' || p_model_number);

Line 1854: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_to_date : ' || p_end_to_date);

1850: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_tax_owner : ' || p_tax_owner);
1851: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_from_date : ' || p_start_from_date);
1852: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_to_date : ' || p_start_to_date);
1853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_from_date : ' || p_end_from_date);
1854: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_to_date : ' || p_end_to_date);
1855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_asset_id : ' || p_asset_id);
1856: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_item_id1 : ' || p_item_id1);
1857: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_model_number : ' || p_model_number);
1858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_manufacturer_name : ' || p_manufacturer_name);

Line 1855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_asset_id : ' || p_asset_id);

1851: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_from_date : ' || p_start_from_date);
1852: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_to_date : ' || p_start_to_date);
1853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_from_date : ' || p_end_from_date);
1854: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_to_date : ' || p_end_to_date);
1855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_asset_id : ' || p_asset_id);
1856: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_item_id1 : ' || p_item_id1);
1857: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_model_number : ' || p_model_number);
1858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_manufacturer_name : ' || p_manufacturer_name);
1859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_vendor_id1 : ' || p_vendor_id1);

Line 1856: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_item_id1 : ' || p_item_id1);

1852: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_to_date : ' || p_start_to_date);
1853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_from_date : ' || p_end_from_date);
1854: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_to_date : ' || p_end_to_date);
1855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_asset_id : ' || p_asset_id);
1856: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_item_id1 : ' || p_item_id1);
1857: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_model_number : ' || p_model_number);
1858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_manufacturer_name : ' || p_manufacturer_name);
1859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_vendor_id1 : ' || p_vendor_id1);
1860: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_from : ' || p_oec_from);

Line 1857: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_model_number : ' || p_model_number);

1853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_from_date : ' || p_end_from_date);
1854: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_to_date : ' || p_end_to_date);
1855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_asset_id : ' || p_asset_id);
1856: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_item_id1 : ' || p_item_id1);
1857: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_model_number : ' || p_model_number);
1858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_manufacturer_name : ' || p_manufacturer_name);
1859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_vendor_id1 : ' || p_vendor_id1);
1860: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_from : ' || p_oec_from);
1861: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_to : ' || p_oec_to);

Line 1858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_manufacturer_name : ' || p_manufacturer_name);

1854: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_to_date : ' || p_end_to_date);
1855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_asset_id : ' || p_asset_id);
1856: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_item_id1 : ' || p_item_id1);
1857: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_model_number : ' || p_model_number);
1858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_manufacturer_name : ' || p_manufacturer_name);
1859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_vendor_id1 : ' || p_vendor_id1);
1860: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_from : ' || p_oec_from);
1861: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_to : ' || p_oec_to);
1862: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_residual_percentage : ' || p_residual_percentage);

Line 1859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_vendor_id1 : ' || p_vendor_id1);

1855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_asset_id : ' || p_asset_id);
1856: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_item_id1 : ' || p_item_id1);
1857: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_model_number : ' || p_model_number);
1858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_manufacturer_name : ' || p_manufacturer_name);
1859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_vendor_id1 : ' || p_vendor_id1);
1860: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_from : ' || p_oec_from);
1861: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_to : ' || p_oec_to);
1862: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_residual_percentage : ' || p_residual_percentage);
1863: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id : ' || p_sty_id);

Line 1860: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_from : ' || p_oec_from);

1856: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_item_id1 : ' || p_item_id1);
1857: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_model_number : ' || p_model_number);
1858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_manufacturer_name : ' || p_manufacturer_name);
1859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_vendor_id1 : ' || p_vendor_id1);
1860: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_from : ' || p_oec_from);
1861: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_to : ' || p_oec_to);
1862: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_residual_percentage : ' || p_residual_percentage);
1863: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id : ' || p_sty_id);
1864: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_type_subclass : ' || p_stream_type_subclass);

Line 1861: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_to : ' || p_oec_to);

1857: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_model_number : ' || p_model_number);
1858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_manufacturer_name : ' || p_manufacturer_name);
1859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_vendor_id1 : ' || p_vendor_id1);
1860: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_from : ' || p_oec_from);
1861: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_to : ' || p_oec_to);
1862: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_residual_percentage : ' || p_residual_percentage);
1863: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id : ' || p_sty_id);
1864: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_type_subclass : ' || p_stream_type_subclass);
1865: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_streams_from_date : ' || p_streams_from_date);

Line 1862: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_residual_percentage : ' || p_residual_percentage);

1858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_manufacturer_name : ' || p_manufacturer_name);
1859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_vendor_id1 : ' || p_vendor_id1);
1860: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_from : ' || p_oec_from);
1861: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_to : ' || p_oec_to);
1862: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_residual_percentage : ' || p_residual_percentage);
1863: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id : ' || p_sty_id);
1864: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_type_subclass : ' || p_stream_type_subclass);
1865: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_streams_from_date : ' || p_streams_from_date);
1866: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_streams_to_date : ' || p_streams_to_date);

Line 1863: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id : ' || p_sty_id);

1859: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_vendor_id1 : ' || p_vendor_id1);
1860: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_from : ' || p_oec_from);
1861: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_to : ' || p_oec_to);
1862: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_residual_percentage : ' || p_residual_percentage);
1863: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id : ' || p_sty_id);
1864: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_type_subclass : ' || p_stream_type_subclass);
1865: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_streams_from_date : ' || p_streams_from_date);
1866: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_streams_to_date : ' || p_streams_to_date);
1867: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_action_code : ' || p_action_code);

Line 1864: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_type_subclass : ' || p_stream_type_subclass);

1860: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_from : ' || p_oec_from);
1861: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_to : ' || p_oec_to);
1862: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_residual_percentage : ' || p_residual_percentage);
1863: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id : ' || p_sty_id);
1864: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_type_subclass : ' || p_stream_type_subclass);
1865: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_streams_from_date : ' || p_streams_from_date);
1866: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_streams_to_date : ' || p_streams_to_date);
1867: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_action_code : ' || p_action_code);
1868: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_crd_clf_code : ' || p_cust_crd_clf_code);

Line 1865: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_streams_from_date : ' || p_streams_from_date);

1861: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_oec_to : ' || p_oec_to);
1862: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_residual_percentage : ' || p_residual_percentage);
1863: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id : ' || p_sty_id);
1864: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_type_subclass : ' || p_stream_type_subclass);
1865: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_streams_from_date : ' || p_streams_from_date);
1866: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_streams_to_date : ' || p_streams_to_date);
1867: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_action_code : ' || p_action_code);
1868: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_crd_clf_code : ' || p_cust_crd_clf_code);
1869: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 1866: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_streams_to_date : ' || p_streams_to_date);

1862: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_residual_percentage : ' || p_residual_percentage);
1863: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id : ' || p_sty_id);
1864: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_type_subclass : ' || p_stream_type_subclass);
1865: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_streams_from_date : ' || p_streams_from_date);
1866: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_streams_to_date : ' || p_streams_to_date);
1867: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_action_code : ' || p_action_code);
1868: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_crd_clf_code : ' || p_cust_crd_clf_code);
1869: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1870:

Line 1867: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_action_code : ' || p_action_code);

1863: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_sty_id : ' || p_sty_id);
1864: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_type_subclass : ' || p_stream_type_subclass);
1865: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_streams_from_date : ' || p_streams_from_date);
1866: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_streams_to_date : ' || p_streams_to_date);
1867: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_action_code : ' || p_action_code);
1868: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_crd_clf_code : ' || p_cust_crd_clf_code);
1869: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1870:
1871:

Line 1868: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_crd_clf_code : ' || p_cust_crd_clf_code);

1864: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_stream_type_subclass : ' || p_stream_type_subclass);
1865: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_streams_from_date : ' || p_streams_from_date);
1866: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_streams_to_date : ' || p_streams_to_date);
1867: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_action_code : ' || p_action_code);
1868: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_crd_clf_code : ' || p_cust_crd_clf_code);
1869: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1870:
1871:
1872: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));

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

1865: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_streams_from_date : ' || p_streams_from_date);
1866: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_streams_to_date : ' || p_streams_to_date);
1867: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_action_code : ' || p_action_code);
1868: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_crd_clf_code : ' || p_cust_crd_clf_code);
1869: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1870:
1871:
1872: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));
1873:

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

1868: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_cust_crd_clf_code : ' || p_cust_crd_clf_code);
1869: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1870:
1871:
1872: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_START));
1873:
1874: -- Bug#2829983, v115.13
1875: FOR l_okl_pol_status_rec IN l_okl_pol_status_csr(p_pol_id)
1876: LOOP

Line 1880: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_POOL_NO_MODIFY));

1876: LOOP
1877: --Included 'Active' status to allow clean up adjustment pool contents -- varangan-29-11-2007
1878: IF l_okl_pol_status_rec.status_code NOT IN (Okl_Pool_Pvt.G_POL_STS_NEW,Okl_Pool_Pvt.G_POL_STS_ACTIVE)
1879: THEN
1880: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_POOL_NO_MODIFY));
1881: RAISE G_EXCEPTION_ERROR;
1882: END IF;
1883: END LOOP;
1884:

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

1890: l_content := l_content || FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_CLEANUP_REMOVE);
1891: END IF;
1892: l_header_len := LENGTH(l_content);
1893: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2); -- center align header
1894: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
1895:
1896: l_content := RPAD('=',l_header_len,'='); -- underline header
1897: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2,'='); -- center align
1898: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

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

1894: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
1895:
1896: l_content := RPAD('=',l_header_len,'='); -- underline header
1897: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2,'='); -- center align
1898: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
1899:
1900: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1901: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1902:

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

1896: l_content := RPAD('=',l_header_len,'='); -- underline header
1897: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2,'='); -- center align
1898: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
1899:
1900: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1901: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1902:
1903: -- Set of Books, Operating Unit
1904: FOR l_okl_set_of_books_rec IN l_okl_set_of_books_csr

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

1897: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2,'='); -- center align
1898: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
1899:
1900: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1901: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1902:
1903: -- Set of Books, Operating Unit
1904: FOR l_okl_set_of_books_rec IN l_okl_set_of_books_csr
1905: LOOP

Line 1906: 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);

1902:
1903: -- Set of Books, Operating Unit
1904: FOR l_okl_set_of_books_rec IN l_okl_set_of_books_csr
1905: LOOP
1906: 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);
1907: END LOOP;
1908: FOR l_okl_operating_unit_rec IN l_okl_operating_unit_csr
1909: LOOP
1910: 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 1910: 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);

1906: 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);
1907: END LOOP;
1908: FOR l_okl_operating_unit_rec IN l_okl_operating_unit_csr
1909: LOOP
1910: 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);
1911: END LOOP;
1912: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1913:
1914: -- Pool Details

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

1908: FOR l_okl_operating_unit_rec IN l_okl_operating_unit_csr
1909: LOOP
1910: 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);
1911: END LOOP;
1912: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1913:
1914: -- Pool Details
1915: FOR l_okl_pol_rec IN l_okl_pol_csr
1916: LOOP

Line 1935: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.get_tot_recei_amt',G_UNEXPECTED_ERROR));

1931: ,x_value => l_amount
1932: ,p_pol_id => p_pol_id);
1933: END IF;
1934: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1935: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.get_tot_recei_amt',G_UNEXPECTED_ERROR));
1936: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1937: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1938: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.get_tot_recei_amt',G_EXPECTED_ERROR));
1939: RAISE G_EXCEPTION_ERROR;

Line 1938: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.get_tot_recei_amt',G_EXPECTED_ERROR));

1934: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1935: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.get_tot_recei_amt',G_UNEXPECTED_ERROR));
1936: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1937: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1938: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.get_tot_recei_amt',G_EXPECTED_ERROR));
1939: RAISE G_EXCEPTION_ERROR;
1940: END IF;
1941:
1942: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_number);

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

1938: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.get_tot_recei_amt',G_EXPECTED_ERROR));
1939: RAISE G_EXCEPTION_ERROR;
1940: END IF;
1941:
1942: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_number);
1943: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_STATUS),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_status);
1944: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_DATE_CREATED),l_prompt_len) || ' : ' || l_okl_pol_rec.date_created);
1945: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_LAST_UPDATE_DATE),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_updated);
1946: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_DATE_LAST_RECONCILED),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_reconciled);

Line 1943: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_STATUS),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_status);

1939: RAISE G_EXCEPTION_ERROR;
1940: END IF;
1941:
1942: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_number);
1943: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_STATUS),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_status);
1944: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_DATE_CREATED),l_prompt_len) || ' : ' || l_okl_pol_rec.date_created);
1945: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_LAST_UPDATE_DATE),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_updated);
1946: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_DATE_LAST_RECONCILED),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_reconciled);
1947: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_VALUE_OF_STREAMS),l_prompt_len) || ' : ' || Okl_Accounting_Util.format_amount(l_amount,p_currency_code));

Line 1944: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_DATE_CREATED),l_prompt_len) || ' : ' || l_okl_pol_rec.date_created);

1940: END IF;
1941:
1942: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_number);
1943: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_STATUS),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_status);
1944: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_DATE_CREATED),l_prompt_len) || ' : ' || l_okl_pol_rec.date_created);
1945: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_LAST_UPDATE_DATE),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_updated);
1946: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_DATE_LAST_RECONCILED),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_reconciled);
1947: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_VALUE_OF_STREAMS),l_prompt_len) || ' : ' || Okl_Accounting_Util.format_amount(l_amount,p_currency_code));
1948:

Line 1945: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_LAST_UPDATE_DATE),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_updated);

1941:
1942: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_number);
1943: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_STATUS),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_status);
1944: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_DATE_CREATED),l_prompt_len) || ' : ' || l_okl_pol_rec.date_created);
1945: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_LAST_UPDATE_DATE),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_updated);
1946: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_DATE_LAST_RECONCILED),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_reconciled);
1947: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_VALUE_OF_STREAMS),l_prompt_len) || ' : ' || Okl_Accounting_Util.format_amount(l_amount,p_currency_code));
1948:
1949: -- mvasudev, 4/29/2003, v115.15, Bug#2924696

Line 1946: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_DATE_LAST_RECONCILED),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_reconciled);

1942: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_NUMBER),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_number);
1943: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_STATUS),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_status);
1944: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_DATE_CREATED),l_prompt_len) || ' : ' || l_okl_pol_rec.date_created);
1945: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_LAST_UPDATE_DATE),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_updated);
1946: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_DATE_LAST_RECONCILED),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_reconciled);
1947: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_VALUE_OF_STREAMS),l_prompt_len) || ' : ' || Okl_Accounting_Util.format_amount(l_amount,p_currency_code));
1948:
1949: -- mvasudev, 4/29/2003, v115.15, Bug#2924696
1950: -- "Total Asset Net Investment" , "Date Last Calculated" not displayed any more

Line 1947: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_VALUE_OF_STREAMS),l_prompt_len) || ' : ' || Okl_Accounting_Util.format_amount(l_amount,p_currency_code));

1943: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_STATUS),l_prompt_len) || ' : ' || l_okl_pol_rec.pool_status);
1944: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_DATE_CREATED),l_prompt_len) || ' : ' || l_okl_pol_rec.date_created);
1945: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_LAST_UPDATE_DATE),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_updated);
1946: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_DATE_LAST_RECONCILED),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_reconciled);
1947: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_VALUE_OF_STREAMS),l_prompt_len) || ' : ' || Okl_Accounting_Util.format_amount(l_amount,p_currency_code));
1948:
1949: -- mvasudev, 4/29/2003, v115.15, Bug#2924696
1950: -- "Total Asset Net Investment" , "Date Last Calculated" not displayed any more
1951: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_TOTAL_ASSET_NET_INVESTMENT),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(l_okl_pol_rec.total_net_asset_net_investment,p_currency_code));

Line 1951: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_TOTAL_ASSET_NET_INVESTMENT),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(l_okl_pol_rec.total_net_asset_net_investment,p_currency_code));

1947: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_VALUE_OF_STREAMS),l_prompt_len) || ' : ' || Okl_Accounting_Util.format_amount(l_amount,p_currency_code));
1948:
1949: -- mvasudev, 4/29/2003, v115.15, Bug#2924696
1950: -- "Total Asset Net Investment" , "Date Last Calculated" not displayed any more
1951: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_TOTAL_ASSET_NET_INVESTMENT),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(l_okl_pol_rec.total_net_asset_net_investment,p_currency_code));
1952: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_DATE_LAST_CALCULATED),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_calculated);
1953: END LOOP;
1954:
1955: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 1952: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_DATE_LAST_CALCULATED),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_calculated);

1948:
1949: -- mvasudev, 4/29/2003, v115.15, Bug#2924696
1950: -- "Total Asset Net Investment" , "Date Last Calculated" not displayed any more
1951: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_TOTAL_ASSET_NET_INVESTMENT),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(l_okl_pol_rec.total_net_asset_net_investment,p_currency_code));
1952: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_DATE_LAST_CALCULATED),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_calculated);
1953: END LOOP;
1954:
1955: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1956: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CURRENCY),l_prompt_len) || ' : ' || p_currency_code);

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

1951: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_TOTAL_ASSET_NET_INVESTMENT),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(l_okl_pol_rec.total_net_asset_net_investment,p_currency_code));
1952: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_DATE_LAST_CALCULATED),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_calculated);
1953: END LOOP;
1954:
1955: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1956: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CURRENCY),l_prompt_len) || ' : ' || p_currency_code);
1957: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_PROGRAM_RUN_DATE),l_prompt_len) || ' : ' || SYSDATE);
1958:
1959: -- Search Parameters

Line 1956: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CURRENCY),l_prompt_len) || ' : ' || p_currency_code);

1952: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_DATE_LAST_CALCULATED),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_calculated);
1953: END LOOP;
1954:
1955: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1956: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CURRENCY),l_prompt_len) || ' : ' || p_currency_code);
1957: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_PROGRAM_RUN_DATE),l_prompt_len) || ' : ' || SYSDATE);
1958:
1959: -- Search Parameters
1960: -- sub head

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

1953: END LOOP;
1954:
1955: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1956: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CURRENCY),l_prompt_len) || ' : ' || p_currency_code);
1957: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_PROGRAM_RUN_DATE),l_prompt_len) || ' : ' || SYSDATE);
1958:
1959: -- Search Parameters
1960: -- sub head
1961: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

1957: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_PROGRAM_RUN_DATE),l_prompt_len) || ' : ' || SYSDATE);
1958:
1959: -- Search Parameters
1960: -- sub head
1961: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1962: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_SEARCH_PARAMETERS);
1963: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
1964: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
1965:

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

1959: -- Search Parameters
1960: -- sub head
1961: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1962: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_SEARCH_PARAMETERS);
1963: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
1964: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
1965:
1966: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1967: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMERS);

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

1960: -- sub head
1961: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1962: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_SEARCH_PARAMETERS);
1963: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
1964: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
1965:
1966: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1967: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMERS);
1968: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

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

1962: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_SEARCH_PARAMETERS);
1963: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
1964: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
1965:
1966: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1967: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMERS);
1968: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
1969: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));
1970:

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

1964: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
1965:
1966: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1967: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMERS);
1968: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
1969: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));
1970:
1971: -- Customer related parameters
1972: FOR l_okl_customer_rec IN l_okl_customer_csr

Line 1969: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));

1965:
1966: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1967: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMERS);
1968: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
1969: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));
1970:
1971: -- Customer related parameters
1972: FOR l_okl_customer_rec IN l_okl_customer_csr
1973: LOOP

Line 1986: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER),l_prompt_len) || ' : ' || l_customer);

1982: LOOP
1983: l_cust_crd_clf := l_okl_cust_crdt_clsf_rec.CREDITCXLSSFCTN;
1984: END LOOP;
1985:
1986: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER),l_prompt_len) || ' : ' || l_customer);
1987: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER_INDUSTRY_CODE),l_prompt_len) || ' : ' || l_customer_industry);
1988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER_INDUSTRY_CODE),l_prompt_len) || ' : ' || l_cust_crd_clf);
1989:
1990: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 1987: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER_INDUSTRY_CODE),l_prompt_len) || ' : ' || l_customer_industry);

1983: l_cust_crd_clf := l_okl_cust_crdt_clsf_rec.CREDITCXLSSFCTN;
1984: END LOOP;
1985:
1986: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER),l_prompt_len) || ' : ' || l_customer);
1987: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER_INDUSTRY_CODE),l_prompt_len) || ' : ' || l_customer_industry);
1988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER_INDUSTRY_CODE),l_prompt_len) || ' : ' || l_cust_crd_clf);
1989:
1990: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1991: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACTS);

Line 1988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER_INDUSTRY_CODE),l_prompt_len) || ' : ' || l_cust_crd_clf);

1984: END LOOP;
1985:
1986: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER),l_prompt_len) || ' : ' || l_customer);
1987: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER_INDUSTRY_CODE),l_prompt_len) || ' : ' || l_customer_industry);
1988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER_INDUSTRY_CODE),l_prompt_len) || ' : ' || l_cust_crd_clf);
1989:
1990: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1991: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACTS);
1992: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

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

1986: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER),l_prompt_len) || ' : ' || l_customer);
1987: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER_INDUSTRY_CODE),l_prompt_len) || ' : ' || l_customer_industry);
1988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER_INDUSTRY_CODE),l_prompt_len) || ' : ' || l_cust_crd_clf);
1989:
1990: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1991: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACTS);
1992: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
1993: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));
1994:

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

1988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMER_INDUSTRY_CODE),l_prompt_len) || ' : ' || l_cust_crd_clf);
1989:
1990: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1991: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACTS);
1992: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
1993: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));
1994:
1995: -- Contract related Parameters
1996: FOR l_okl_chr_rec IN l_okl_chr_csr

Line 1993: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));

1989:
1990: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1991: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACTS);
1992: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
1993: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));
1994:
1995: -- Contract related Parameters
1996: FOR l_okl_chr_rec IN l_okl_chr_csr
1997: LOOP

Line 2013: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACT_NUMBER),l_prompt_len) || ' : ' || l_contract_number);

2009: LOOP
2010: l_product := l_okl_pdt_rec.name;
2011: END LOOP;
2012:
2013: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACT_NUMBER),l_prompt_len) || ' : ' || l_contract_number);
2014: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_FROM),l_prompt_len) || ' : ' || p_pre_tax_yield_from);
2015: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_TO),l_prompt_len) || ' : ' || p_pre_tax_yield_to);
2016: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_BOOK_CLASS),l_prompt_len) || ' : ' || l_book_class);
2017: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);

Line 2014: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_FROM),l_prompt_len) || ' : ' || p_pre_tax_yield_from);

2010: l_product := l_okl_pdt_rec.name;
2011: END LOOP;
2012:
2013: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACT_NUMBER),l_prompt_len) || ' : ' || l_contract_number);
2014: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_FROM),l_prompt_len) || ' : ' || p_pre_tax_yield_from);
2015: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_TO),l_prompt_len) || ' : ' || p_pre_tax_yield_to);
2016: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_BOOK_CLASS),l_prompt_len) || ' : ' || l_book_class);
2017: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);
2018: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);

Line 2015: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_TO),l_prompt_len) || ' : ' || p_pre_tax_yield_to);

2011: END LOOP;
2012:
2013: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACT_NUMBER),l_prompt_len) || ' : ' || l_contract_number);
2014: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_FROM),l_prompt_len) || ' : ' || p_pre_tax_yield_from);
2015: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_TO),l_prompt_len) || ' : ' || p_pre_tax_yield_to);
2016: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_BOOK_CLASS),l_prompt_len) || ' : ' || l_book_class);
2017: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);
2018: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);
2019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_TO_DATE),l_prompt_len) || ' : ' || p_start_to_date);

Line 2016: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_BOOK_CLASS),l_prompt_len) || ' : ' || l_book_class);

2012:
2013: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACT_NUMBER),l_prompt_len) || ' : ' || l_contract_number);
2014: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_FROM),l_prompt_len) || ' : ' || p_pre_tax_yield_from);
2015: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_TO),l_prompt_len) || ' : ' || p_pre_tax_yield_to);
2016: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_BOOK_CLASS),l_prompt_len) || ' : ' || l_book_class);
2017: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);
2018: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);
2019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_TO_DATE),l_prompt_len) || ' : ' || p_start_to_date);
2020: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_FROM_DATE),l_prompt_len) || ' : ' || p_end_from_date);

Line 2017: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);

2013: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACT_NUMBER),l_prompt_len) || ' : ' || l_contract_number);
2014: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_FROM),l_prompt_len) || ' : ' || p_pre_tax_yield_from);
2015: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_TO),l_prompt_len) || ' : ' || p_pre_tax_yield_to);
2016: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_BOOK_CLASS),l_prompt_len) || ' : ' || l_book_class);
2017: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);
2018: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);
2019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_TO_DATE),l_prompt_len) || ' : ' || p_start_to_date);
2020: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_FROM_DATE),l_prompt_len) || ' : ' || p_end_from_date);
2021: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_TO_DATE),l_prompt_len) || ' : ' || p_end_to_date);

Line 2018: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);

2014: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_FROM),l_prompt_len) || ' : ' || p_pre_tax_yield_from);
2015: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_TO),l_prompt_len) || ' : ' || p_pre_tax_yield_to);
2016: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_BOOK_CLASS),l_prompt_len) || ' : ' || l_book_class);
2017: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);
2018: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);
2019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_TO_DATE),l_prompt_len) || ' : ' || p_start_to_date);
2020: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_FROM_DATE),l_prompt_len) || ' : ' || p_end_from_date);
2021: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_TO_DATE),l_prompt_len) || ' : ' || p_end_to_date);
2022: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PRODUCT),l_prompt_len) || ' : ' || l_product);

Line 2019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_TO_DATE),l_prompt_len) || ' : ' || p_start_to_date);

2015: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PTY_TO),l_prompt_len) || ' : ' || p_pre_tax_yield_to);
2016: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_BOOK_CLASS),l_prompt_len) || ' : ' || l_book_class);
2017: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);
2018: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);
2019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_TO_DATE),l_prompt_len) || ' : ' || p_start_to_date);
2020: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_FROM_DATE),l_prompt_len) || ' : ' || p_end_from_date);
2021: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_TO_DATE),l_prompt_len) || ' : ' || p_end_to_date);
2022: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PRODUCT),l_prompt_len) || ' : ' || l_product);
2023:

Line 2020: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_FROM_DATE),l_prompt_len) || ' : ' || p_end_from_date);

2016: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_BOOK_CLASS),l_prompt_len) || ' : ' || l_book_class);
2017: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);
2018: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);
2019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_TO_DATE),l_prompt_len) || ' : ' || p_start_to_date);
2020: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_FROM_DATE),l_prompt_len) || ' : ' || p_end_from_date);
2021: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_TO_DATE),l_prompt_len) || ' : ' || p_end_to_date);
2022: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PRODUCT),l_prompt_len) || ' : ' || l_product);
2023:
2024: /*

Line 2021: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_TO_DATE),l_prompt_len) || ' : ' || p_end_to_date);

2017: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_TAX_OWNER),l_prompt_len) || ' : ' || l_tax_owner);
2018: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);
2019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_TO_DATE),l_prompt_len) || ' : ' || p_start_to_date);
2020: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_FROM_DATE),l_prompt_len) || ' : ' || p_end_from_date);
2021: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_TO_DATE),l_prompt_len) || ' : ' || p_end_to_date);
2022: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PRODUCT),l_prompt_len) || ' : ' || l_product);
2023:
2024: /*
2025: -- Asset related Parameters

Line 2022: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PRODUCT),l_prompt_len) || ' : ' || l_product);

2018: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_FROM_DATE),l_prompt_len) || ' : ' || p_start_from_date);
2019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_START_TO_DATE),l_prompt_len) || ' : ' || p_start_to_date);
2020: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_FROM_DATE),l_prompt_len) || ' : ' || p_end_from_date);
2021: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_END_TO_DATE),l_prompt_len) || ' : ' || p_end_to_date);
2022: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_PRODUCT),l_prompt_len) || ' : ' || l_product);
2023:
2024: /*
2025: -- Asset related Parameters
2026: FOR l_okl_asset_rec IN l_okl_asset_csr

Line 2039: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_NUMBER),l_prompt_len) || ' : ' || l_asset_number);

2035: LOOP
2036: l_vendor := l_okl_vendor_rec.name;
2037: END LOOP;
2038:
2039: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_NUMBER),l_prompt_len) || ' : ' || l_asset_number);
2040: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ITEM_NUMBER),l_prompt_len) || ' : ' || l_item);
2041: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_MODEL_NUMBER),l_prompt_len) || ' : ' || p_model_number);
2042: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_MANUFACTURER),l_prompt_len) || ' : ' || p_manufacturer_name);
2043: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_VENDOR),l_prompt_len) || ' : ' || l_vendor);

Line 2040: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ITEM_NUMBER),l_prompt_len) || ' : ' || l_item);

2036: l_vendor := l_okl_vendor_rec.name;
2037: END LOOP;
2038:
2039: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_NUMBER),l_prompt_len) || ' : ' || l_asset_number);
2040: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ITEM_NUMBER),l_prompt_len) || ' : ' || l_item);
2041: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_MODEL_NUMBER),l_prompt_len) || ' : ' || p_model_number);
2042: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_MANUFACTURER),l_prompt_len) || ' : ' || p_manufacturer_name);
2043: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_VENDOR),l_prompt_len) || ' : ' || l_vendor);
2044: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_COST_FROM),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(p_oec_from,p_currency_code));

Line 2041: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_MODEL_NUMBER),l_prompt_len) || ' : ' || p_model_number);

2037: END LOOP;
2038:
2039: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_NUMBER),l_prompt_len) || ' : ' || l_asset_number);
2040: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ITEM_NUMBER),l_prompt_len) || ' : ' || l_item);
2041: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_MODEL_NUMBER),l_prompt_len) || ' : ' || p_model_number);
2042: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_MANUFACTURER),l_prompt_len) || ' : ' || p_manufacturer_name);
2043: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_VENDOR),l_prompt_len) || ' : ' || l_vendor);
2044: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_COST_FROM),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(p_oec_from,p_currency_code));
2045: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_COST_TO),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(p_oec_to,p_currency_code));

Line 2042: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_MANUFACTURER),l_prompt_len) || ' : ' || p_manufacturer_name);

2038:
2039: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_NUMBER),l_prompt_len) || ' : ' || l_asset_number);
2040: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ITEM_NUMBER),l_prompt_len) || ' : ' || l_item);
2041: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_MODEL_NUMBER),l_prompt_len) || ' : ' || p_model_number);
2042: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_MANUFACTURER),l_prompt_len) || ' : ' || p_manufacturer_name);
2043: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_VENDOR),l_prompt_len) || ' : ' || l_vendor);
2044: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_COST_FROM),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(p_oec_from,p_currency_code));
2045: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_COST_TO),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(p_oec_to,p_currency_code));
2046: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_RESIDUAL_PERCENTAGE),l_prompt_len) || ' : ' || p_residual_percentage);

Line 2043: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_VENDOR),l_prompt_len) || ' : ' || l_vendor);

2039: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_NUMBER),l_prompt_len) || ' : ' || l_asset_number);
2040: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ITEM_NUMBER),l_prompt_len) || ' : ' || l_item);
2041: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_MODEL_NUMBER),l_prompt_len) || ' : ' || p_model_number);
2042: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_MANUFACTURER),l_prompt_len) || ' : ' || p_manufacturer_name);
2043: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_VENDOR),l_prompt_len) || ' : ' || l_vendor);
2044: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_COST_FROM),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(p_oec_from,p_currency_code));
2045: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_COST_TO),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(p_oec_to,p_currency_code));
2046: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_RESIDUAL_PERCENTAGE),l_prompt_len) || ' : ' || p_residual_percentage);
2047: */

Line 2044: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_COST_FROM),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(p_oec_from,p_currency_code));

2040: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ITEM_NUMBER),l_prompt_len) || ' : ' || l_item);
2041: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_MODEL_NUMBER),l_prompt_len) || ' : ' || p_model_number);
2042: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_MANUFACTURER),l_prompt_len) || ' : ' || p_manufacturer_name);
2043: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_VENDOR),l_prompt_len) || ' : ' || l_vendor);
2044: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_COST_FROM),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(p_oec_from,p_currency_code));
2045: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_COST_TO),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(p_oec_to,p_currency_code));
2046: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_RESIDUAL_PERCENTAGE),l_prompt_len) || ' : ' || p_residual_percentage);
2047: */
2048:

Line 2045: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_COST_TO),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(p_oec_to,p_currency_code));

2041: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_MODEL_NUMBER),l_prompt_len) || ' : ' || p_model_number);
2042: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_MANUFACTURER),l_prompt_len) || ' : ' || p_manufacturer_name);
2043: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_VENDOR),l_prompt_len) || ' : ' || l_vendor);
2044: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_COST_FROM),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(p_oec_from,p_currency_code));
2045: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_COST_TO),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(p_oec_to,p_currency_code));
2046: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_RESIDUAL_PERCENTAGE),l_prompt_len) || ' : ' || p_residual_percentage);
2047: */
2048:
2049: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 2046: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_RESIDUAL_PERCENTAGE),l_prompt_len) || ' : ' || p_residual_percentage);

2042: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_MANUFACTURER),l_prompt_len) || ' : ' || p_manufacturer_name);
2043: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_VENDOR),l_prompt_len) || ' : ' || l_vendor);
2044: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_COST_FROM),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(p_oec_from,p_currency_code));
2045: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_COST_TO),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(p_oec_to,p_currency_code));
2046: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_RESIDUAL_PERCENTAGE),l_prompt_len) || ' : ' || p_residual_percentage);
2047: */
2048:
2049: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2050: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS);

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

2045: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_COST_TO),l_prompt_len) || ' : ' || okl_accounting_util.format_amount(p_oec_to,p_currency_code));
2046: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_RESIDUAL_PERCENTAGE),l_prompt_len) || ' : ' || p_residual_percentage);
2047: */
2048:
2049: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2050: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS);
2051: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2052: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));
2053: -- Stream related Parameters

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

2047: */
2048:
2049: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2050: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS);
2051: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2052: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));
2053: -- Stream related Parameters
2054: /*
2055: FOR l_okl_strm_type_rec IN l_okl_strm_type_csr

Line 2052: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));

2048:
2049: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2050: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS);
2051: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2052: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',LENGTH(l_content),'-'));
2053: -- Stream related Parameters
2054: /*
2055: FOR l_okl_strm_type_rec IN l_okl_strm_type_csr
2056: LOOP

Line 2068: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE),l_prompt_len) || ' : ' || l_stream_type);

2064: l_stream_type_subclass := l_okl_sty_subclass_rec.meaning;
2065: END LOOP;
2066: END IF;
2067:
2068: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE),l_prompt_len) || ' : ' || l_stream_type);
2069: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_prompt_len) || ' : ' || l_stream_type_subclass);
2070: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_FROM_DATE),l_prompt_len) || ' : ' || p_streams_from_date);
2071: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_TO_DATE),l_prompt_len) || ' : ' || p_streams_to_date);
2072:

Line 2069: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_prompt_len) || ' : ' || l_stream_type_subclass);

2065: END LOOP;
2066: END IF;
2067:
2068: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE),l_prompt_len) || ' : ' || l_stream_type);
2069: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_prompt_len) || ' : ' || l_stream_type_subclass);
2070: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_FROM_DATE),l_prompt_len) || ' : ' || p_streams_from_date);
2071: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_TO_DATE),l_prompt_len) || ' : ' || p_streams_to_date);
2072:
2073: -- Results

Line 2070: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_FROM_DATE),l_prompt_len) || ' : ' || p_streams_from_date);

2066: END IF;
2067:
2068: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE),l_prompt_len) || ' : ' || l_stream_type);
2069: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_prompt_len) || ' : ' || l_stream_type_subclass);
2070: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_FROM_DATE),l_prompt_len) || ' : ' || p_streams_from_date);
2071: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_TO_DATE),l_prompt_len) || ' : ' || p_streams_to_date);
2072:
2073: -- Results
2074: -- sub head

Line 2071: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_TO_DATE),l_prompt_len) || ' : ' || p_streams_to_date);

2067:
2068: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE),l_prompt_len) || ' : ' || l_stream_type);
2069: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_prompt_len) || ' : ' || l_stream_type_subclass);
2070: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_FROM_DATE),l_prompt_len) || ' : ' || p_streams_from_date);
2071: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_TO_DATE),l_prompt_len) || ' : ' || p_streams_to_date);
2072:
2073: -- Results
2074: -- sub head
2075: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

2071: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_filler || FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS_TO_DATE),l_prompt_len) || ' : ' || p_streams_to_date);
2072:
2073: -- Results
2074: -- sub head
2075: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2076: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_RESULTS);
2077: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2078: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
2079: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

2073: -- Results
2074: -- sub head
2075: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2076: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_RESULTS);
2077: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2078: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
2079: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2080: -- count
2081:

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

2074: -- sub head
2075: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2076: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_RESULTS);
2077: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2078: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
2079: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2080: -- count
2081:
2082: Okl_Pool_Pvt.cleanup_pool_contents(p_api_version => l_api_version

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

2075: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2076: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_RESULTS);
2077: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2078: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
2079: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2080: -- count
2081:
2082: Okl_Pool_Pvt.cleanup_pool_contents(p_api_version => l_api_version
2083: ,p_init_msg_list => l_init_msg_list

Line 2121: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.CLEANUP_POOL_CONTENTS',G_UNEXPECTED_ERROR));

2117: ,x_poc_uv_tbl => lx_poc_uv_tbl
2118: ,p_cust_crd_clf_code => p_cust_crd_clf_code);
2119:
2120: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2121: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.CLEANUP_POOL_CONTENTS',G_UNEXPECTED_ERROR));
2122: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2123: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
2124: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.CLEANUP_POOL_CONTENTS',G_EXPECTED_ERROR));
2125: RAISE G_EXCEPTION_ERROR;

Line 2124: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.CLEANUP_POOL_CONTENTS',G_EXPECTED_ERROR));

2120: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2121: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.CLEANUP_POOL_CONTENTS',G_UNEXPECTED_ERROR));
2122: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2123: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
2124: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.CLEANUP_POOL_CONTENTS',G_EXPECTED_ERROR));
2125: RAISE G_EXCEPTION_ERROR;
2126: END IF;
2127:
2128: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(fnd_message.get_string(G_APP_NAME,G_TOTAL_ROWS_PROCESSED),l_prompt_len) || ' : ' || lx_poc_uv_tbl.COUNT);

Line 2128: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(fnd_message.get_string(G_APP_NAME,G_TOTAL_ROWS_PROCESSED),l_prompt_len) || ' : ' || lx_poc_uv_tbl.COUNT);

2124: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.CLEANUP_POOL_CONTENTS',G_EXPECTED_ERROR));
2125: RAISE G_EXCEPTION_ERROR;
2126: END IF;
2127:
2128: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(fnd_message.get_string(G_APP_NAME,G_TOTAL_ROWS_PROCESSED),l_prompt_len) || ' : ' || lx_poc_uv_tbl.COUNT);
2129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2130:
2131: IF lx_poc_uv_tbl.COUNT > 0 THEN
2132:

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

2125: RAISE G_EXCEPTION_ERROR;
2126: END IF;
2127:
2128: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(fnd_message.get_string(G_APP_NAME,G_TOTAL_ROWS_PROCESSED),l_prompt_len) || ' : ' || lx_poc_uv_tbl.COUNT);
2129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2130:
2131: IF lx_poc_uv_tbl.COUNT > 0 THEN
2132:
2133:

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

2139: || RPAD('-',l_sty_name_len-1,'-') || ' '
2140: || RPAD('-',l_sty_purpose_len-1,'-') || ' '
2141: || RPAD('-',l_amount_len,'-');
2142:
2143: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2144:
2145: l_content := RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ROW_NUMBER),l_row_num_len-1) || ' '
2146: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACT_NUMBER),l_contract_num_len-1) || ' '
2147:

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

2151: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE),l_sty_name_len-1) || ' '
2152: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_PURPOSE),l_sty_purpose_len-1) || ' '
2153: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_TOTAL_AMOUNT),l_amount_len);
2154:
2155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2156:
2157: l_content := RPAD('-',l_row_num_len-1,'-') || ' '
2158: || RPAD('-',l_contract_num_len-1,'-') || ' '
2159: || RPAD('-',l_asset_num_len-1,'-') || ' '

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

2162: || RPAD('-',l_sty_name_len-1,'-') || ' '
2163: || RPAD('-',l_sty_purpose_len-1,'-') || ' '
2164: || RPAD('-',l_amount_len,'-');
2165:
2166: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2167:
2168:
2169: FOR l_row_count IN 1..lx_poc_uv_tbl.COUNT
2170: LOOP

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

2176: || RPAD(lx_poc_uv_tbl(l_row_count).stream_type_name ,l_sty_name_len)
2177: || RPAD(lx_poc_uv_tbl(l_row_count).stream_type_purpose ,l_sty_purpose_len)
2178: || LPAD(Okl_Accounting_Util.format_amount(lx_poc_uv_tbl(l_row_count).pool_amount,p_currency_code),l_amount_len);
2179:
2180: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);
2181:
2182: END LOOP;
2183:
2184: /* v115.16 , mvasudev

Line 2186: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message('Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT','',G_PROCESS_START));

2182: END LOOP;
2183:
2184: /* v115.16 , mvasudev
2185: IF p_action_code = Okl_Pool_Pvt.G_ACTION_REMOVE THEN
2186: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message('Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT','',G_PROCESS_START));
2187: Okl_Pool_Pvt.recal_tot_princ_amt(p_api_version => l_api_version
2188: ,p_init_msg_list => l_init_msg_list
2189: ,x_return_status => l_return_status
2190: ,x_msg_count => l_msg_count

Line 2195: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: p_pol_id : ' || p_pol_id);

2191: ,x_msg_data => l_msg_data
2192: ,x_value => l_amount
2193: ,p_pol_id => p_pol_id);
2194:
2195: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: p_pol_id : ' || p_pol_id);
2196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: x_value : ' || okl_accounting_util.format_amount(l_amount,p_currency_code));
2197:
2198: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2199: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));

Line 2196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: x_value : ' || okl_accounting_util.format_amount(l_amount,p_currency_code));

2192: ,x_value => l_amount
2193: ,p_pol_id => p_pol_id);
2194:
2195: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: p_pol_id : ' || p_pol_id);
2196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: x_value : ' || okl_accounting_util.format_amount(l_amount,p_currency_code));
2197:
2198: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2199: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
2200: RAISE G_EXCEPTION_UNEXPECTED_ERROR;

Line 2199: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));

2195: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: p_pol_id : ' || p_pol_id);
2196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT:: x_value : ' || okl_accounting_util.format_amount(l_amount,p_currency_code));
2197:
2198: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2199: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
2200: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2201: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
2202: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));
2203: RAISE G_EXCEPTION_ERROR;

Line 2202: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));

2198: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2199: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_UNEXPECTED_ERROR));
2200: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2201: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
2202: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'Okl_Pool_Pvt.RECAL_TOT_PRINC_AMT',G_EXPECTED_ERROR));
2203: RAISE G_EXCEPTION_ERROR;
2204: END IF; -- status
2205:
2206: END IF; -- action_code

Line 2210: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || ' : ' || lx_poc_uv_tbl.COUNT);

2206: END IF; -- action_code
2207: */
2208: END IF; -- count > 0
2209:
2210: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || ' : ' || lx_poc_uv_tbl.COUNT);
2211: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
2212:
2213:
2214: -- Errors

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

2207: */
2208: END IF; -- count > 0
2209:
2210: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || ' : ' || lx_poc_uv_tbl.COUNT);
2211: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
2212:
2213:
2214: -- Errors
2215: -- sub head

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

2212:
2213:
2214: -- Errors
2215: -- sub head
2216: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2217: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_ERRORS);
2218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2219: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
2220: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

2214: -- Errors
2215: -- sub head
2216: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2217: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_ERRORS);
2218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2219: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
2220: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2221:
2222: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);

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

2215: -- sub head
2216: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2217: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_ERRORS);
2218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2219: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
2220: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2221:
2222: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
2223: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));

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

2216: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2217: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_ERRORS);
2218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2219: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
2220: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2221:
2222: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
2223: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
2224:

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

2219: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
2220: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2221:
2222: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
2223: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
2224:
2225: -- "No Errors"
2226: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_NONE);
2227: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_filler || l_content);

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

2223: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
2224:
2225: -- "No Errors"
2226: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_NONE);
2227: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_filler || l_content);
2228:
2229:
2230: x_retcode := 0;
2231:

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

2246: GET_ERROR_MESSAGE(l_error_msg_rec);
2247: IF (l_error_msg_rec.COUNT > 0) THEN
2248: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
2249: LOOP
2250: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
2251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error_msg_rec(i));
2252: END LOOP;
2253: END IF;
2254:

Line 2251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error_msg_rec(i));

2247: IF (l_error_msg_rec.COUNT > 0) THEN
2248: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
2249: LOOP
2250: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
2251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error_msg_rec(i));
2252: END LOOP;
2253: END IF;
2254:
2255: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN

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

2265: GET_ERROR_MESSAGE(l_error_msg_rec);
2266: IF (l_error_msg_rec.COUNT > 0) THEN
2267: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
2268: LOOP
2269: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
2270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error_msg_rec(i));
2271: END LOOP;
2272: END IF;
2273:

Line 2270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error_msg_rec(i));

2266: IF (l_error_msg_rec.COUNT > 0) THEN
2267: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
2268: LOOP
2269: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
2270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error_msg_rec(i));
2271: END LOOP;
2272: END IF;
2273:
2274: WHEN OTHERS THEN

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

2286: GET_ERROR_MESSAGE(l_error_msg_rec);
2287: IF (l_error_msg_rec.COUNT > 0) THEN
2288: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
2289: LOOP
2290: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
2291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error_msg_rec(i));
2292: END LOOP;
2293: END IF;
2294:

Line 2291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error_msg_rec(i));

2287: IF (l_error_msg_rec.COUNT > 0) THEN
2288: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST
2289: LOOP
2290: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_msg_rec(i));
2291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error_msg_rec(i));
2292: END LOOP;
2293: END IF;
2294:
2295: END cleanup_pool_contents;