APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_REP_UTILS

Line 3131: l_statement := l_statement || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_borrower) || '';

3127: l_statement := l_statement || l_new_line || '' || P_PRIN_AMOUNT_DUE || '';
3128: l_statement := l_statement || l_new_line || '' || P_INT_AMOUNT_DUE || '';
3129: l_statement := l_statement || l_new_line || '' || P_FEE_AMOUNT_DUE || '';
3130: l_statement := l_statement || l_new_line || '' || (P_PRIN_AMOUNT_DUE + P_INT_AMOUNT_DUE + P_FEE_AMOUNT_DUE) || '';
3131: l_statement := l_statement || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_borrower) || '';
3132: l_statement := l_statement || l_new_line || '' || l_currency || '';
3133:
3134: l_statement := l_statement || l_new_line || '' || l_new_line;
3135: while (l_indexNo <= P_ERR_COUNT ) loop

Line 3137: l_error := LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_error);

3133:
3134: l_statement := l_statement || l_new_line || '' || l_new_line;
3135: while (l_indexNo <= P_ERR_COUNT ) loop
3136: fnd_msg_pub.get(l_indexNo, 'F', l_error, l_index);
3137: l_error := LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_error);
3138: l_statement := l_statement || l_error;
3139: l_indexNo := l_indexNo + 1;
3140: End Loop;
3141: l_statement := l_statement || '';

Line 3270: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_org_name) || '';

3266: open org_cur(g_org_id);
3267: fetch org_cur into l_org_name;
3268: close org_cur;
3269: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_org_name: ' || l_org_name);
3270: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_org_name) || '';
3271:
3272: /* adding loan type to parameter list */
3273: if P_TYPE_ID is not null then
3274: open loan_type_cur(P_TYPE_ID);

Line 3279: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_type) || '';

3275: fetch loan_type_cur into l_type;
3276: close loan_type_cur;
3277: end if;
3278: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_type: ' || l_type);
3279: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_type) || '';
3280:
3281: /* adding loan product to parameter list */
3282: if P_PRODUCT_ID is not null then
3283: open loan_product_cur(P_PRODUCT_ID);

Line 3288: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_product) || '';

3284: fetch loan_product_cur into l_product;
3285: close loan_product_cur;
3286: end if;
3287: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_product: ' || l_product);
3288: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_product) || '';
3289:
3290: /* adding borrower to parameter list */
3291: if P_BORROWER_ID is not null then
3292: open borrower_cur(P_BORROWER_ID);

Line 3297: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_borrower) || '';

3293: fetch borrower_cur into l_borrower;
3294: close borrower_cur;
3295: end if;
3296: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_borrower: ' || l_borrower);
3297: l_parameters := l_parameters || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_borrower) || '';
3298:
3299: /* adding loan to parameter list */
3300: if P_LOAN_ID is not null then
3301: open loan_cur(P_LOAN_ID);

Line 3349: LNS_REP_UTILS.PRINT_CLOB(g_last_billing_report); -- fix for bug 6938098

3345: dbms_lob.writeAppend(g_last_billing_report, length(l_footer), l_footer);
3346: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added footer to report');
3347:
3348: /* print report to output file */
3349: LNS_REP_UTILS.PRINT_CLOB(g_last_billing_report); -- fix for bug 6938098
3350: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Printed report into output file.');
3351:
3352: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
3353: