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 || '
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);
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 || '
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);
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 || '
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);
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 || '
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);
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 || '
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);
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 || '
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');
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:
406: ';
407: if P_OPEN_CLOSE_FLAG = 'OPEN' then
408: l_data := l_new_line || '
409: l_new_line || '
410: l_new_line || '
411: l_new_line || '
412: l_new_line || '
413: l_new_line || '
414: l_new_line || '
408: l_data := l_new_line || '
409: l_new_line || '
410: l_new_line || '
411: l_new_line || '
412: l_new_line || '
413: l_new_line || '
414: l_new_line || '
415: l_new_line || '
416: elsif P_OPEN_CLOSE_FLAG = 'CLOSE' then
410: l_new_line || '
411: l_new_line || '
412: l_new_line || '
413: l_new_line || '
414: l_new_line || '
415: l_new_line || '
416: elsif P_OPEN_CLOSE_FLAG = 'CLOSE' then
417: l_data := l_new_line || '';
418: end if;
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 || '
603: l_new_line || '
604: l_new_line || '
605: l_new_line || '
606: l_new_line || '
601:
602: l_application := l_application || l_new_line || '
603: l_new_line || '
604: l_new_line || '
605: l_new_line || '
606: l_new_line || '
607: l_new_line || '
608: l_new_line || '
609: l_new_line || '
602: l_application := l_application || l_new_line || '
603: l_new_line || '
604: l_new_line || '
605: l_new_line || '
606: l_new_line || '
607: l_new_line || '
608: l_new_line || '
609: l_new_line || '
610: l_new_line || '
605: l_new_line || '
606: l_new_line || '
607: l_new_line || '
608: l_new_line || '
609: l_new_line || '
610: l_new_line || '
611: l_new_line || '
612: l_new_line || '
613: l_new_line || '
607: l_new_line || '
608: l_new_line || '
609: l_new_line || '
610: l_new_line || '
611: l_new_line || '
612: l_new_line || '
613: l_new_line || '
614: l_new_line || '
615: l_new_line || '
609: l_new_line || '
610: l_new_line || '
611: l_new_line || '
612: l_new_line || '
613: l_new_line || '
614: l_new_line || '
615: l_new_line || '
616: l_new_line || '
617: l_new_line || '
617: l_new_line || '
618: l_new_line || '
619: l_new_line || '
620: l_new_line || '
621: l_new_line || '
622: l_new_line || '
623: l_new_line || '
624: l_new_line || '
625:
619: l_new_line || '
620: l_new_line || '
621: l_new_line || '
622: l_new_line || '
623: l_new_line || '
624: l_new_line || '
625:
626: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'Step2');
627: if P_ACTION = 'APPLY' then