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.
[Home] [Help]
APPS.LNS_APPL_ENGINE_PUB dependencies on LNS_REP_UTILS
Line 239: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_org_name) || ' ';
235: open org_cur(g_org_id);
236: fetch org_cur into l_org_name;
237: close org_cur;
238: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_org_name: ' || l_org_name);
239: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_org_name) || ' ';
240:
241: /* adding borrower to parameter list */
242: if P_SEARCH_REC.LOAN_BORROWER_ID is not null then
243: open borrower_cur(P_SEARCH_REC.LOAN_BORROWER_ID);
Line 248: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_borrower) || ' ';
244: fetch borrower_cur into l_borrower;
245: close borrower_cur;
246: end if;
247: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_borrower: ' || l_borrower);
248: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_borrower) || ' ';
249:
250: /* adding loan product to parameter list */
251: if P_SEARCH_REC.LOAN_PRODUCT_ID is not null then
252: open product_cur(P_SEARCH_REC.LOAN_PRODUCT_ID);
Line 257: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_product) || ' ';
253: fetch product_cur into l_product;
254: close product_cur;
255: end if;
256: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_product: ' || l_product);
257: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_product) || ' ';
258:
259: /* adding loan to parameter list */
260: if P_SEARCH_REC.LOAN_ID is not null then
261: open loan_cur(P_SEARCH_REC.LOAN_ID);
Line 266: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_loan) || ' ';
262: fetch loan_cur into l_loan;
263: close loan_cur;
264: end if;
265: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_loan: ' || l_loan);
266: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_loan) || ' ';
267:
268: /* adding receipt to parameter list */
269: if P_SEARCH_REC.RECEIPT_ID is not null then
270: open receipt_cur(P_SEARCH_REC.RECEIPT_ID);
Line 275: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_receipt) || ' ';
271: fetch receipt_cur into l_receipt;
272: close receipt_cur;
273: end if;
274: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_receipt: ' || l_receipt);
275: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_receipt) || ' ';
276:
277: /* adding receipt match criteria to parameter list */
278: if P_SEARCH_REC.RECEIPT_MATCH_CRITERIA is not null then
279: open receipt_match_cur(P_SEARCH_REC.RECEIPT_MATCH_CRITERIA);
Line 284: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_receipt_match_criteria) || ' ';
280: fetch receipt_match_cur into l_receipt_match_criteria;
281: close receipt_match_cur;
282: end if;
283: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_receipt_match_criteria: ' || l_receipt_match_criteria);
284: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_receipt_match_criteria) || ' ';
285:
286: --Converting the date format from YYYY/MM/DD to DD-MON-YYYY format in the report
287: l_fr_date := to_date(substr(P_SEARCH_REC.RC_FROM_DATE, 1, 10), 'YYYY/MM/DD');
288: l_to_date := to_date(substr(P_SEARCH_REC.RC_TO_DATE, 1, 10), 'YYYY/MM/DD');
Line 339: LNS_REP_UTILS.PRINT_CLOB(g_last_rc_appl_report);
335: dbms_lob.writeAppend(g_last_rc_appl_report, length(l_footer), l_footer);
336: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added footer to report');
337:
338: /* print report to output file */
339: LNS_REP_UTILS.PRINT_CLOB(g_last_rc_appl_report);
340: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Saved output file');
341:
342: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
343:
Line 410: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_REC.LOAN_NUMBER) || ' ' ||
406: ';
407: if P_OPEN_CLOSE_FLAG = 'OPEN' then
408: l_data := l_new_line || '' ||
409: l_new_line || '' || P_LOAN_REC.LOAN_ID || ' ' ||
410: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_REC.LOAN_NUMBER) || ' ' ||
411: l_new_line || '' || P_LOAN_REC.LOAN_BORROWER_ID || ' ' ||
412: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_REC.BORROWER_NAME) || ' ' ||
413: l_new_line || '' || P_LOAN_REC.LOAN_PRODUCT_ID || ' ' ||
414: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_REC.PRODUCT_NAME) || ' ' ||
Line 412: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_REC.BORROWER_NAME) || ' ' ||
408: l_data := l_new_line || '' ||
409: l_new_line || '' || P_LOAN_REC.LOAN_ID || ' ' ||
410: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_REC.LOAN_NUMBER) || ' ' ||
411: l_new_line || '' || P_LOAN_REC.LOAN_BORROWER_ID || ' ' ||
412: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_REC.BORROWER_NAME) || ' ' ||
413: l_new_line || '' || P_LOAN_REC.LOAN_PRODUCT_ID || ' ' ||
414: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_REC.PRODUCT_NAME) || ' ' ||
415: l_new_line || '' || P_LOAN_REC.LOAN_CURRENCY || ' ';
416: elsif P_OPEN_CLOSE_FLAG = 'CLOSE' then
Line 414: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_REC.PRODUCT_NAME) || ' ' ||
410: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_REC.LOAN_NUMBER) || ' ' ||
411: l_new_line || '' || P_LOAN_REC.LOAN_BORROWER_ID || ' ' ||
412: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_REC.BORROWER_NAME) || ' ' ||
413: l_new_line || '' || P_LOAN_REC.LOAN_PRODUCT_ID || ' ' ||
414: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_REC.PRODUCT_NAME) || ' ' ||
415: l_new_line || '' || P_LOAN_REC.LOAN_CURRENCY || ' ';
416: elsif P_OPEN_CLOSE_FLAG = 'CLOSE' then
417: l_data := l_new_line || '';
418: end if;
Line 602: l_application := l_application || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.LOAN_NUMBER) ||' ' ||
598: l_footer := l_new_line || '' || l_new_line;
599: end if;
600: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'Step1');
601:
602: l_application := l_application || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.LOAN_NUMBER) ||' ' ||
603: l_new_line || '' || P_LOAN_INVOICES_REC.PHASE ||' ' ||
604: l_new_line || '' || P_LOAN_INVOICES_REC.PAYMENT_NUMBER ||' ' ||
605: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.INVOICE_TYPE_CODE) ||' ' ||
606: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.INVOICE_TYPE_DESC) ||' ' ||
Line 605: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.INVOICE_TYPE_CODE) ||' ' ||
601:
602: l_application := l_application || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.LOAN_NUMBER) ||' ' ||
603: l_new_line || '' || P_LOAN_INVOICES_REC.PHASE ||' ' ||
604: l_new_line || '' || P_LOAN_INVOICES_REC.PAYMENT_NUMBER ||' ' ||
605: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.INVOICE_TYPE_CODE) ||' ' ||
606: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.INVOICE_TYPE_DESC) ||' ' ||
607: l_new_line || '' || P_LOAN_INVOICES_REC.CUST_TRX_ID || ' ' ||
608: l_new_line || '' || P_LOAN_INVOICES_REC.PAYMENT_SCHEDULE_ID || ' ' ||
609: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.TRX_NUMBER) || ' ' ||
Line 606: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.INVOICE_TYPE_DESC) ||' ' ||
602: l_application := l_application || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.LOAN_NUMBER) ||' ' ||
603: l_new_line || '' || P_LOAN_INVOICES_REC.PHASE ||' ' ||
604: l_new_line || '' || P_LOAN_INVOICES_REC.PAYMENT_NUMBER ||' ' ||
605: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.INVOICE_TYPE_CODE) ||' ' ||
606: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.INVOICE_TYPE_DESC) ||' ' ||
607: l_new_line || '' || P_LOAN_INVOICES_REC.CUST_TRX_ID || ' ' ||
608: l_new_line || '' || P_LOAN_INVOICES_REC.PAYMENT_SCHEDULE_ID || ' ' ||
609: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.TRX_NUMBER) || ' ' ||
610: l_new_line || '' || P_LOAN_INVOICES_REC.LOAN_BORROWER_ID ||' ' ||
Line 609: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.TRX_NUMBER) || ' ' ||
605: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.INVOICE_TYPE_CODE) ||' ' ||
606: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.INVOICE_TYPE_DESC) ||' ' ||
607: l_new_line || '' || P_LOAN_INVOICES_REC.CUST_TRX_ID || ' ' ||
608: l_new_line || '' || P_LOAN_INVOICES_REC.PAYMENT_SCHEDULE_ID || ' ' ||
609: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.TRX_NUMBER) || ' ' ||
610: l_new_line || '' || P_LOAN_INVOICES_REC.LOAN_BORROWER_ID ||' ' ||
611: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.BORROWER_NAME) ||' ' ||
612: l_new_line || '' || P_LOAN_INVOICES_REC.LOAN_PRODUCT_ID ||' ' ||
613: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.PRODUCT_NAME) ||' ' ||
Line 611: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.BORROWER_NAME) ||' ' ||
607: l_new_line || '' || P_LOAN_INVOICES_REC.CUST_TRX_ID || ' ' ||
608: l_new_line || '' || P_LOAN_INVOICES_REC.PAYMENT_SCHEDULE_ID || ' ' ||
609: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.TRX_NUMBER) || ' ' ||
610: l_new_line || '' || P_LOAN_INVOICES_REC.LOAN_BORROWER_ID ||' ' ||
611: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.BORROWER_NAME) ||' ' ||
612: l_new_line || '' || P_LOAN_INVOICES_REC.LOAN_PRODUCT_ID ||' ' ||
613: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.PRODUCT_NAME) ||' ' ||
614: l_new_line || '' || P_LOAN_INVOICES_REC.LOAN_ID ||' ' ||
615: l_new_line || '' || P_LOAN_INVOICES_REC.AMORTIZATION_ID ||' ' ||
Line 613: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.PRODUCT_NAME) ||' ' ||
609: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.TRX_NUMBER) || ' ' ||
610: l_new_line || '' || P_LOAN_INVOICES_REC.LOAN_BORROWER_ID ||' ' ||
611: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.BORROWER_NAME) ||' ' ||
612: l_new_line || '' || P_LOAN_INVOICES_REC.LOAN_PRODUCT_ID ||' ' ||
613: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_LOAN_INVOICES_REC.PRODUCT_NAME) ||' ' ||
614: l_new_line || '' || P_LOAN_INVOICES_REC.LOAN_ID ||' ' ||
615: l_new_line || '' || P_LOAN_INVOICES_REC.AMORTIZATION_ID ||' ' ||
616: l_new_line || '' || to_char(P_LOAN_INVOICES_REC.DUE_DATE,'YYYY-MM-DD') ||' ' ||
617: l_new_line || '' || to_char(P_LOAN_INVOICES_REC.BILL_DATE,'YYYY-MM-DD') ||' ' ||
Line 621: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_RECEIPT_REC.RECEIPT_NUMBER) ||' ' ||
617: l_new_line || '' || to_char(P_LOAN_INVOICES_REC.BILL_DATE,'YYYY-MM-DD') ||' ' ||
618: l_new_line || '' || P_LOAN_INVOICES_REC.INVOICE_CURRENCY ||' ' ||
619: l_new_line || '' || P_LOAN_INVOICES_REC.EXCHANGE_RATE ||' ' ||
620: l_new_line || '' || P_RECEIPT_REC.RECEIPT_ID ||' ' ||
621: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_RECEIPT_REC.RECEIPT_NUMBER) ||' ' ||
622: l_new_line || '' || to_char(P_RECEIPT_REC.RECEIPT_DATE,'YYYY-MM-DD') ||' ' ||
623: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_RECEIPT_REC.PARTY_NAME) ||' ' ||
624: l_new_line || '' || P_RECEIPT_REC.RECEIPT_CURRENCY || ' ';
625:
Line 623: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_RECEIPT_REC.PARTY_NAME) ||' ' ||
619: l_new_line || '' || P_LOAN_INVOICES_REC.EXCHANGE_RATE ||' ' ||
620: l_new_line || '' || P_RECEIPT_REC.RECEIPT_ID ||' ' ||
621: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_RECEIPT_REC.RECEIPT_NUMBER) ||' ' ||
622: l_new_line || '' || to_char(P_RECEIPT_REC.RECEIPT_DATE,'YYYY-MM-DD') ||' ' ||
623: l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_RECEIPT_REC.PARTY_NAME) ||' ' ||
624: l_new_line || '' || P_RECEIPT_REC.RECEIPT_CURRENCY || ' ';
625:
626: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'Step2');
627: if P_ACTION = 'APPLY' then