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_MESSAGE

Line 51: FND_MESSAGE.GET_STRING(G_APP_NAME,p_msg_token));

47:
48: BEGIN
49: RETURN (G_PKG_NAME || '.' || p_current_api || '::' ||
50: p_called_api || ':: ' ||
51: FND_MESSAGE.GET_STRING(G_APP_NAME,p_msg_token));
52:
53: END get_message;
54:
55:

Line 325: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_OKL_TITLE);

321: END IF;
322: END LOOP;
323:
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

Line 335: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_ADD_REPORT);

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

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 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 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 372: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_ELIGIBILITY_CRITERIA);

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:
376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 377: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMERS);

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:
381: -- Customer related parameters

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 402: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACTS);

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:
406: -- Contract related Parameters

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 436: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS);

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:
440: -- Stream related Parameters

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 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 467: l_content := RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ROW_NUMBER),l_row_num_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) || ' '
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) || ' '

Line 468: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACT_NUMBER),l_contract_num_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) || ' '
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);

Line 469: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_NUMBER),l_asset_num_len-1) || ' '

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) || ' '
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:

Line 470: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_LESSEE),l_lessee_len-1) || ' '

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) || ' '
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);

Line 471: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_sty_subclass_len-1) || ' '

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) || ' '
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:

Line 472: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_REJECT_REASON_CODE),l_reject_code_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) || ' '
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,'-') || ' '

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 580: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_ERRORS);

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,' ');
584:

Line 589: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_NONE);

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);
591:
592: x_retcode := 0;
593:

Line 1886: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_CLEANUP_HEAD) || ' : ';

1882: END IF;
1883: END LOOP;
1884:
1885: -- Header
1886: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_CLEANUP_HEAD) || ' : ';
1887: IF p_action_code = Okl_Pool_Pvt.G_ACTION_REPORT THEN
1888: l_content := l_content || FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_CLEANUP_REPORT);
1889: ELSIF p_action_code = Okl_Pool_Pvt.G_ACTION_REMOVE THEN
1890: l_content := l_content || FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_CLEANUP_REMOVE);

Line 1888: l_content := l_content || FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_CLEANUP_REPORT);

1884:
1885: -- Header
1886: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_CLEANUP_HEAD) || ' : ';
1887: IF p_action_code = Okl_Pool_Pvt.G_ACTION_REPORT THEN
1888: l_content := l_content || FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_CLEANUP_REPORT);
1889: ELSIF p_action_code = Okl_Pool_Pvt.G_ACTION_REMOVE THEN
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);

Line 1890: l_content := l_content || FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_CLEANUP_REMOVE);

1886: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_CLEANUP_HEAD) || ' : ';
1887: IF p_action_code = Okl_Pool_Pvt.G_ACTION_REPORT THEN
1888: l_content := l_content || FND_MESSAGE.GET_STRING(G_APP_NAME,G_POOL_CLEANUP_REPORT);
1889: ELSIF p_action_code = Okl_Pool_Pvt.G_ACTION_REMOVE THEN
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);

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 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 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 1962: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_SEARCH_PARAMETERS);

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:
1966: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 1967: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CUSTOMERS);

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:
1971: -- Customer related parameters

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 1991: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACTS);

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:
1995: -- Contract related Parameters

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 2050: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAMS);

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
2054: /*

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 2076: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_RESULTS);

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,' ');
2080: -- 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 2145: l_content := RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ROW_NUMBER),l_row_num_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:
2148: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_NUMBER),l_asset_num_len-1) || ' '
2149: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_LESSEE),l_lessee_len-1) || ' '

Line 2146: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACT_NUMBER),l_contract_num_len-1) || ' '

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:
2148: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_NUMBER),l_asset_num_len-1) || ' '
2149: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_LESSEE),l_lessee_len-1) || ' '
2150: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_sty_subclass_len-1) || ' '

Line 2148: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_NUMBER),l_asset_num_len-1) || ' '

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:
2148: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_NUMBER),l_asset_num_len-1) || ' '
2149: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_LESSEE),l_lessee_len-1) || ' '
2150: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_sty_subclass_len-1) || ' '
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) || ' '

Line 2149: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_LESSEE),l_lessee_len-1) || ' '

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:
2148: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_NUMBER),l_asset_num_len-1) || ' '
2149: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_LESSEE),l_lessee_len-1) || ' '
2150: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_sty_subclass_len-1) || ' '
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);

Line 2150: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_sty_subclass_len-1) || ' '

2146: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_CONTRACT_NUMBER),l_contract_num_len-1) || ' '
2147:
2148: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_NUMBER),l_asset_num_len-1) || ' '
2149: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_LESSEE),l_lessee_len-1) || ' '
2150: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_sty_subclass_len-1) || ' '
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:

Line 2151: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE),l_sty_name_len-1) || ' '

2147:
2148: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_NUMBER),l_asset_num_len-1) || ' '
2149: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_LESSEE),l_lessee_len-1) || ' '
2150: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_sty_subclass_len-1) || ' '
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);

Line 2152: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_PURPOSE),l_sty_purpose_len-1) || ' '

2148: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_ASSET_NUMBER),l_asset_num_len-1) || ' '
2149: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_LESSEE),l_lessee_len-1) || ' '
2150: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_sty_subclass_len-1) || ' '
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:

Line 2153: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_TOTAL_AMOUNT),l_amount_len);

2149: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_LESSEE),l_lessee_len-1) || ' '
2150: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_STREAM_TYPE_SUBCLASS),l_sty_subclass_len-1) || ' '
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,'-') || ' '

Line 2217: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_ERRORS);

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,' ');
2221:

Line 2226: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_NONE);

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);
2228:
2229:
2230: x_retcode := 0;