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.LNS_REP_UTILS dependencies on FND_LOG

Line 103: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);

99: IS
100: BEGIN
101: if (p_msg_level >= G_MSG_LEVEL) then
102:
103: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);
104:
105: end if;
106:
107: if FND_GLOBAL.Conc_Request_Id is not null then

Line 113: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);

109: end if;
110:
111: EXCEPTION
112: WHEN OTHERS THEN
113: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);
114: END;
115:
116:
117:

Line 138: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

134: /*-----------------------------------------------------------------------+
135: | Cursor Declarations |
136: +-----------------------------------------------------------------------*/
137: BEGIN
138: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
139:
140: LOOP
141: l_end :=
142: DBMS_LOB.INSTR (lob_loc => lob_loc,

Line 163: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

159: --Fnd_File.PUT_line(Fnd_File.LOG,l_one_line);
160: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);
161:
162: END LOOP;
163: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
164: END PRINT_CLOB;
165:
166: FUNCTION REPLACE_SPECIAL_CHARS(P_XML_DATA IN VARCHAR2)
167: RETURN VARCHAR2

Line 174: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

170: l_api_name CONSTANT VARCHAR2(30) := 'REPLACE_SPECIAL_CHARS';
171: l_xml VARCHAR2(32767);
172:
173: BEGIN
174: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
175: l_xml := REPLACE(P_XML_DATA,'&','&');
176: l_xml := REPLACE(l_xml,'&','&');
177: RETURN l_xml;
178:

Line 181: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name

177: RETURN l_xml;
178:
179: EXCEPTION
180: WHEN OTHERS THEN
181: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
182: || ' -');
183: RAISE;
184: END REPLACE_SPECIAL_CHARS;
185:

Line 330: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

326: 'lh.loan_currency = :CURRENCY_CODE and ' ||
327: 'lh.org_id = :ORG_ID';
328: l_temp_where_clause VARCHAR2(200);
329: BEGIN
330: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
331:
332: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters: ');
333: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_CLASS = ' || LOAN_CLASS);
334: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_TYPE_ID = ' || LOAN_TYPE_ID);

Line 332: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters: ');

328: l_temp_where_clause VARCHAR2(200);
329: BEGIN
330: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
331:
332: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters: ');
333: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_CLASS = ' || LOAN_CLASS);
334: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_TYPE_ID = ' || LOAN_TYPE_ID);
335: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CURRENCY_CODE = ' || CURRENCY_CODE);
336: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_NUMBER = ' || LOAN_NUMBER);

Line 333: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_CLASS = ' || LOAN_CLASS);

329: BEGIN
330: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
331:
332: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters: ');
333: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_CLASS = ' || LOAN_CLASS);
334: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_TYPE_ID = ' || LOAN_TYPE_ID);
335: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CURRENCY_CODE = ' || CURRENCY_CODE);
336: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_NUMBER = ' || LOAN_NUMBER);
337: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORROWER_ID = ' || BORROWER_ID);

Line 334: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_TYPE_ID = ' || LOAN_TYPE_ID);

330: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
331:
332: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters: ');
333: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_CLASS = ' || LOAN_CLASS);
334: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_TYPE_ID = ' || LOAN_TYPE_ID);
335: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CURRENCY_CODE = ' || CURRENCY_CODE);
336: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_NUMBER = ' || LOAN_NUMBER);
337: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORROWER_ID = ' || BORROWER_ID);
338: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CUST_ACCOUNT_ID = ' || CUST_ACCOUNT_ID);

Line 335: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CURRENCY_CODE = ' || CURRENCY_CODE);

331:
332: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters: ');
333: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_CLASS = ' || LOAN_CLASS);
334: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_TYPE_ID = ' || LOAN_TYPE_ID);
335: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CURRENCY_CODE = ' || CURRENCY_CODE);
336: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_NUMBER = ' || LOAN_NUMBER);
337: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORROWER_ID = ' || BORROWER_ID);
338: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CUST_ACCOUNT_ID = ' || CUST_ACCOUNT_ID);
339: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_FROM = ' || LOAN_START_DATE_FROM);

Line 336: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_NUMBER = ' || LOAN_NUMBER);

332: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters: ');
333: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_CLASS = ' || LOAN_CLASS);
334: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_TYPE_ID = ' || LOAN_TYPE_ID);
335: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CURRENCY_CODE = ' || CURRENCY_CODE);
336: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_NUMBER = ' || LOAN_NUMBER);
337: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORROWER_ID = ' || BORROWER_ID);
338: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CUST_ACCOUNT_ID = ' || CUST_ACCOUNT_ID);
339: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_FROM = ' || LOAN_START_DATE_FROM);
340: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_TO = ' || LOAN_START_DATE_TO);

Line 337: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORROWER_ID = ' || BORROWER_ID);

333: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_CLASS = ' || LOAN_CLASS);
334: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_TYPE_ID = ' || LOAN_TYPE_ID);
335: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CURRENCY_CODE = ' || CURRENCY_CODE);
336: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_NUMBER = ' || LOAN_NUMBER);
337: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORROWER_ID = ' || BORROWER_ID);
338: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CUST_ACCOUNT_ID = ' || CUST_ACCOUNT_ID);
339: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_FROM = ' || LOAN_START_DATE_FROM);
340: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_TO = ' || LOAN_START_DATE_TO);
341: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LEGAL_ENTITY_ID = ' || LEGAL_ENTITY_ID);

Line 338: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CUST_ACCOUNT_ID = ' || CUST_ACCOUNT_ID);

334: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_TYPE_ID = ' || LOAN_TYPE_ID);
335: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CURRENCY_CODE = ' || CURRENCY_CODE);
336: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_NUMBER = ' || LOAN_NUMBER);
337: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORROWER_ID = ' || BORROWER_ID);
338: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CUST_ACCOUNT_ID = ' || CUST_ACCOUNT_ID);
339: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_FROM = ' || LOAN_START_DATE_FROM);
340: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_TO = ' || LOAN_START_DATE_TO);
341: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LEGAL_ENTITY_ID = ' || LEGAL_ENTITY_ID);
342: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRODUCT_ID = ' || PRODUCT_ID);

Line 339: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_FROM = ' || LOAN_START_DATE_FROM);

335: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CURRENCY_CODE = ' || CURRENCY_CODE);
336: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_NUMBER = ' || LOAN_NUMBER);
337: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORROWER_ID = ' || BORROWER_ID);
338: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CUST_ACCOUNT_ID = ' || CUST_ACCOUNT_ID);
339: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_FROM = ' || LOAN_START_DATE_FROM);
340: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_TO = ' || LOAN_START_DATE_TO);
341: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LEGAL_ENTITY_ID = ' || LEGAL_ENTITY_ID);
342: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRODUCT_ID = ' || PRODUCT_ID);
343: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ASSIGNED_TO = ' || LOAN_ASSIGNED_TO);

Line 340: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_TO = ' || LOAN_START_DATE_TO);

336: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_NUMBER = ' || LOAN_NUMBER);
337: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORROWER_ID = ' || BORROWER_ID);
338: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CUST_ACCOUNT_ID = ' || CUST_ACCOUNT_ID);
339: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_FROM = ' || LOAN_START_DATE_FROM);
340: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_TO = ' || LOAN_START_DATE_TO);
341: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LEGAL_ENTITY_ID = ' || LEGAL_ENTITY_ID);
342: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRODUCT_ID = ' || PRODUCT_ID);
343: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ASSIGNED_TO = ' || LOAN_ASSIGNED_TO);
344: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS1 = ' || LOAN_STATUS1);

Line 341: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LEGAL_ENTITY_ID = ' || LEGAL_ENTITY_ID);

337: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORROWER_ID = ' || BORROWER_ID);
338: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CUST_ACCOUNT_ID = ' || CUST_ACCOUNT_ID);
339: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_FROM = ' || LOAN_START_DATE_FROM);
340: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_TO = ' || LOAN_START_DATE_TO);
341: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LEGAL_ENTITY_ID = ' || LEGAL_ENTITY_ID);
342: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRODUCT_ID = ' || PRODUCT_ID);
343: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ASSIGNED_TO = ' || LOAN_ASSIGNED_TO);
344: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS1 = ' || LOAN_STATUS1);
345: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS2 = ' || LOAN_STATUS2);

Line 342: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRODUCT_ID = ' || PRODUCT_ID);

338: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CUST_ACCOUNT_ID = ' || CUST_ACCOUNT_ID);
339: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_FROM = ' || LOAN_START_DATE_FROM);
340: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_TO = ' || LOAN_START_DATE_TO);
341: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LEGAL_ENTITY_ID = ' || LEGAL_ENTITY_ID);
342: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRODUCT_ID = ' || PRODUCT_ID);
343: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ASSIGNED_TO = ' || LOAN_ASSIGNED_TO);
344: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS1 = ' || LOAN_STATUS1);
345: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS2 = ' || LOAN_STATUS2);
346: LogMessage(FND_LOG.LEVEL_STATEMENT, 'INCLUDE_CHARTS = ' || INCLUDE_CHARTS);

Line 343: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ASSIGNED_TO = ' || LOAN_ASSIGNED_TO);

339: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_FROM = ' || LOAN_START_DATE_FROM);
340: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_TO = ' || LOAN_START_DATE_TO);
341: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LEGAL_ENTITY_ID = ' || LEGAL_ENTITY_ID);
342: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRODUCT_ID = ' || PRODUCT_ID);
343: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ASSIGNED_TO = ' || LOAN_ASSIGNED_TO);
344: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS1 = ' || LOAN_STATUS1);
345: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS2 = ' || LOAN_STATUS2);
346: LogMessage(FND_LOG.LEVEL_STATEMENT, 'INCLUDE_CHARTS = ' || INCLUDE_CHARTS);
347:

Line 344: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS1 = ' || LOAN_STATUS1);

340: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_START_DATE_TO = ' || LOAN_START_DATE_TO);
341: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LEGAL_ENTITY_ID = ' || LEGAL_ENTITY_ID);
342: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRODUCT_ID = ' || PRODUCT_ID);
343: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ASSIGNED_TO = ' || LOAN_ASSIGNED_TO);
344: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS1 = ' || LOAN_STATUS1);
345: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS2 = ' || LOAN_STATUS2);
346: LogMessage(FND_LOG.LEVEL_STATEMENT, 'INCLUDE_CHARTS = ' || INCLUDE_CHARTS);
347:
348: l_loan_type_id := loan_type_id;

Line 345: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS2 = ' || LOAN_STATUS2);

341: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LEGAL_ENTITY_ID = ' || LEGAL_ENTITY_ID);
342: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRODUCT_ID = ' || PRODUCT_ID);
343: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ASSIGNED_TO = ' || LOAN_ASSIGNED_TO);
344: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS1 = ' || LOAN_STATUS1);
345: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS2 = ' || LOAN_STATUS2);
346: LogMessage(FND_LOG.LEVEL_STATEMENT, 'INCLUDE_CHARTS = ' || INCLUDE_CHARTS);
347:
348: l_loan_type_id := loan_type_id;
349: l_legal_entity_id := legal_entity_id;

Line 346: LogMessage(FND_LOG.LEVEL_STATEMENT, 'INCLUDE_CHARTS = ' || INCLUDE_CHARTS);

342: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRODUCT_ID = ' || PRODUCT_ID);
343: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ASSIGNED_TO = ' || LOAN_ASSIGNED_TO);
344: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS1 = ' || LOAN_STATUS1);
345: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS2 = ' || LOAN_STATUS2);
346: LogMessage(FND_LOG.LEVEL_STATEMENT, 'INCLUDE_CHARTS = ' || INCLUDE_CHARTS);
347:
348: l_loan_type_id := loan_type_id;
349: l_legal_entity_id := legal_entity_id;
350: g_loan_start_date_from := trunc(fnd_date.canonical_to_date(loan_start_date_from));

Line 360: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_org_id = ' || l_org_id);

356: ELSE
357: l_include_charts := 'No';
358: END IF;
359:
360: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_org_id = ' || l_org_id);
361: LogMessage(FND_LOG.LEVEL_STATEMENT, 'g_loan_start_date_from = ' || g_loan_start_date_from);
362: LogMessage(FND_LOG.LEVEL_STATEMENT, 'g_loan_start_date_to = ' || g_loan_start_date_to);
363:
364: BEGIN

Line 361: LogMessage(FND_LOG.LEVEL_STATEMENT, 'g_loan_start_date_from = ' || g_loan_start_date_from);

357: l_include_charts := 'No';
358: END IF;
359:
360: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_org_id = ' || l_org_id);
361: LogMessage(FND_LOG.LEVEL_STATEMENT, 'g_loan_start_date_from = ' || g_loan_start_date_from);
362: LogMessage(FND_LOG.LEVEL_STATEMENT, 'g_loan_start_date_to = ' || g_loan_start_date_to);
363:
364: BEGIN
365: SELECT loan_type_desc

Line 362: LogMessage(FND_LOG.LEVEL_STATEMENT, 'g_loan_start_date_to = ' || g_loan_start_date_to);

358: END IF;
359:
360: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_org_id = ' || l_org_id);
361: LogMessage(FND_LOG.LEVEL_STATEMENT, 'g_loan_start_date_from = ' || g_loan_start_date_from);
362: LogMessage(FND_LOG.LEVEL_STATEMENT, 'g_loan_start_date_to = ' || g_loan_start_date_to);
363:
364: BEGIN
365: SELECT loan_type_desc
366: into l_loan_type_desc

Line 372: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_loan_type_desc = ' || l_loan_type_desc);

368: where loan_type_id = l_loan_type_id;
369: EXCEPTION
370: WHEN NO_DATA_FOUND THEN null;
371: END;
372: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_loan_type_desc = ' || l_loan_type_desc);
373:
374: -- Build Bind Placeholders for all non-mandatory parameters
375: IF loan_number IS NOT NULL
376: THEN

Line 422: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Final query = ' || l_query);

418: --l_query := l_query || ' and (lh.loan_status = :LOAN_STATUS1 or lh.loan_status = :LOAN_STATUS2)';
419: l_query := l_query || ' and (lh.loan_status = ''' || LOAN_STATUS1 ||''' or lh.loan_status = ''' || LOAN_STATUS2 ||''')';
420: END IF;
421:
422: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Final query = ' || l_query);
423:
424: -- Start Getting Parameter Display Values
425: SELECT name
426: INTO l_org_name

Line 484: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQUERY.newContext');

480: FROM jtf_rs_resource_extns
481: WHERE resource_id = loan_assigned_to;
482: END IF;
483: ctx := DBMS_XMLQUERY.newContext(l_query);
484: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQUERY.newContext');
485:
486: -- Bind Mandatory Variables
487: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_CLASS', loan_class);
488: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_TYPE_ID', loan_type_id);

Line 491: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQuery.setBindValue');

487: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_CLASS', loan_class);
488: DBMS_XMLQuery.setBindValue(ctx, 'LOAN_TYPE_ID', loan_type_id);
489: DBMS_XMLQuery.setBindValue(ctx, 'CURRENCY_CODE', currency_code);
490: DBMS_XMLQuery.setBindValue(ctx, 'ORG_ID', l_org_id);
491: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQuery.setBindValue');
492:
493: -- Bind Optional Variables if they are NOT NULL
494: IF borrower_id is NOT NULL
495: THEN

Line 522: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQUERY.getXML');

518:
519: -- now get the result
520: BEGIN
521: l_result := DBMS_XMLQUERY.getXML(ctx);
522: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQUERY.getXML');
523: DBMS_XMLQuery.closeContext(ctx);
524: l_rows_processed := 1;
525: EXCEPTION
526: WHEN OTHERS THEN

Line 527: LogMessage(FND_LOG.LEVEL_STATEMENT, 'in exception');

523: DBMS_XMLQuery.closeContext(ctx);
524: l_rows_processed := 1;
525: EXCEPTION
526: WHEN OTHERS THEN
527: LogMessage(FND_LOG.LEVEL_STATEMENT, 'in exception');
528: DBMS_XMLQuery.getExceptionContent(ctx,l_errNo,l_errMsg);
529: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_errNo = ' || l_errNo);
530: IF l_errNo = 1403 THEN
531: l_rows_processed := 0;

Line 529: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_errNo = ' || l_errNo);

525: EXCEPTION
526: WHEN OTHERS THEN
527: LogMessage(FND_LOG.LEVEL_STATEMENT, 'in exception');
528: DBMS_XMLQuery.getExceptionContent(ctx,l_errNo,l_errMsg);
529: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_errNo = ' || l_errNo);
530: IF l_errNo = 1403 THEN
531: l_rows_processed := 0;
532: END IF;
533: DBMS_XMLQuery.closeContext(ctx);

Line 568: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added parameters');

564: l_xml_header := l_xml_header ||l_new_line||' ' ||l_include_charts ||'';
565: l_xml_header := l_xml_header ||l_new_line||' ' || to_char(sysdate,'YYYY-MM-DD') || '';
566: l_xml_header := l_xml_header ||l_new_line||' ';
567: l_close_tag := l_new_line||''||l_new_line;
568: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added parameters');
569:
570: l_xml_header_length := length(l_xml_header);
571: IF l_rows_processed <> 0 THEN
572: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);

Line 581: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added content');

577: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
578: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
579: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
580: END IF;
581: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added content');
582:
583: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
584: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added closing tag');
585:

Line 584: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added closing tag');

580: END IF;
581: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added content');
582:
583: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
584: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added closing tag');
585:
586: print_clob(lob_loc => tempResult);
587: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
588: EXCEPTION

Line 587: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

583: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
584: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added closing tag');
585:
586: print_clob(lob_loc => tempResult);
587: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
588: EXCEPTION
589: WHEN OTHERS THEN
590: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
591: || ' -');

Line 590: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name

586: print_clob(lob_loc => tempResult);
587: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
588: EXCEPTION
589: WHEN OTHERS THEN
590: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
591: || ' -');
592: RAISE;
593: END PROCESS_PORTFOLIO_REPORT;
594: PROCEDURE PROCESS_RECON_REPORT(ERRBUF OUT NOCOPY VARCHAR2

Line 885: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

881: ' trunc(am.DUE_DATE) between lns_rep_utils.get_bill_due_date_from() ' ||
882: ' and lns_rep_utils.get_bill_due_date_to())';
883: l_temp_where_clause VARCHAR2(200);
884: BEGIN
885: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
886: l_loan_type_id := loan_type_id;
887: l_legal_entity_id := legal_entity_id;
888: g_bill_due_date_from := trunc(fnd_date.canonical_to_date(bill_due_date_from));
889: g_bill_due_date_to := trunc(fnd_date.canonical_to_date(bill_due_date_to));

Line 1045: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

1041: END IF;
1042:
1043: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
1044: print_clob(lob_loc => tempResult);
1045: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
1046: EXCEPTION
1047: WHEN OTHERS THEN
1048: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
1049: || ' -');

Line 1048: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name

1044: print_clob(lob_loc => tempResult);
1045: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
1046: EXCEPTION
1047: WHEN OTHERS THEN
1048: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
1049: || ' -');
1050: RAISE;
1051: END PROCESS_RECON_REPORT;
1052:

Line 1702: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

1698: terr.language = userenv('LANG') and
1699: lh.loan_id = X_Loan_Id and
1700: lh.org_id = lh.org_id;
1701: BEGIN
1702: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1703:
1704: lns_financials.runAmortization(p_api_version => 1.0
1705: ,p_init_msg_list => 'T'
1706: ,p_commit => 'F'

Line 1713: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Returned amortization schedule count: ' || l_amort_tbl.count);

1709: ,x_amort_tbl => l_amort_tbl
1710: ,x_return_status => l_return_Status
1711: ,x_msg_count => l_msg_count
1712: ,x_msg_data => l_msg_data);
1713: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Returned amortization schedule count: ' || l_amort_tbl.count);
1714:
1715:
1716: FOR j in 1..l_amort_tbl.count
1717: LOOP

Line 1746: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting into lns_amort_scheds_gt...');

1742: v_DEFERRED_INT_DETAILS(j) := l_amort_tbl(j).DEFERRED_INT_DETAILS;
1743: v_CAP_INT_DETAILS(j) := l_amort_tbl(j).CAP_INT_DETAILS;
1744: END LOOP;
1745:
1746: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting into lns_amort_scheds_gt...');
1747: IF (v_INSTALLMENT_NUMBER.first iS NOT NULL) THEN
1748: FORALL j in v_INSTALLMENT_NUMBER.first..v_INSTALLMENT_NUMBER.last
1749: insert into lns_amort_scheds_gt
1750: (

Line 1810: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Opening c_get_principal_balance');

1806: ,v_CAP_INT_DETAILS(j)
1807: );
1808: end IF;
1809:
1810: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Opening c_get_principal_balance');
1811: open c_get_principal_balance(p_loan_id);
1812: fetch c_get_principal_balance into l_total_principal_balance;
1813: close c_get_principal_balance;
1814:

Line 1815: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Opening C_agreement');

1811: open c_get_principal_balance(p_loan_id);
1812: fetch c_get_principal_balance into l_total_principal_balance;
1813: close c_get_principal_balance;
1814:
1815: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Opening C_agreement');
1816: OPEN C_agreement(X_Loan_Id => p_loan_id,
1817: pTotalPrincipalBalance => l_total_principal_balance);
1818: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Fetching C_agreement');
1819: FETCH C_agreement INTO l_result;

Line 1818: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Fetching C_agreement');

1814:
1815: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Opening C_agreement');
1816: OPEN C_agreement(X_Loan_Id => p_loan_id,
1817: pTotalPrincipalBalance => l_total_principal_balance);
1818: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Fetching C_agreement');
1819: FETCH C_agreement INTO l_result;
1820: IF C_agreement%ROWCOUNT <> 0 THEN
1821: l_rows_processed := 1;
1822: END IF;

Line 1823: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'C_agreement%ROWCOUNT ' || C_agreement%ROWCOUNT);

1819: FETCH C_agreement INTO l_result;
1820: IF C_agreement%ROWCOUNT <> 0 THEN
1821: l_rows_processed := 1;
1822: END IF;
1823: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'C_agreement%ROWCOUNT ' || C_agreement%ROWCOUNT);
1824: CLOSE C_agreement;
1825: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_rows_processed ' || l_rows_processed);
1826:
1827: -- We are adding the LNSAGREEMENT and PARAMETERS TAGs so we have

Line 1825: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_rows_processed ' || l_rows_processed);

1821: l_rows_processed := 1;
1822: END IF;
1823: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'C_agreement%ROWCOUNT ' || C_agreement%ROWCOUNT);
1824: CLOSE C_agreement;
1825: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_rows_processed ' || l_rows_processed);
1826:
1827: -- We are adding the LNSAGREEMENT and PARAMETERS TAGs so we have
1828: -- to offset the first line.
1829: IF l_rows_processed <> 0 THEN

Line 1834: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_resultOffset ' || l_resultOffset);

1830: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
1831: ELSE
1832: l_resultOffset := 0;
1833: END IF;
1834: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'l_resultOffset ' || l_resultOffset);
1835:
1836: -- Start Getting Parameter Display Values
1837: SELECT hou.name, gsb.currency_code
1838: INTO l_org_name, l_sob_currency_code

Line 1860: LogMessage(FND_LOG.LEVEL_PROCEDURE, ' l_xml_header_length ' || l_xml_header_length);

1856: l_xml_header := l_xml_header ||l_new_line||' ';
1857: l_close_tag := l_new_line||''||l_new_line;
1858: l_xml_header_length := length(l_xml_header);
1859: IF l_rows_processed <> 0 THEN
1860: LogMessage(FND_LOG.LEVEL_PROCEDURE, ' l_xml_header_length ' || l_xml_header_length);
1861: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
1862: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
1863: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1864:

Line 1865: LogMessage(FND_LOG.LEVEL_PROCEDURE, ' before dbms_lob.copy ' );

1861: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
1862: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
1863: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1864:
1865: LogMessage(FND_LOG.LEVEL_PROCEDURE, ' before dbms_lob.copy ' );
1866: dbms_lob.copy(tempResult,l_result
1867: ,dbms_lob.getlength(l_result)-l_resultOffset
1868: ,l_xml_header_length,l_resultOffset);
1869: ELSE

Line 1877: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

1873: END IF;
1874:
1875: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
1876: p_AgreementXML := tempResult;
1877: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
1878: EXCEPTION
1879:
1880: WHEN OTHERS THEN
1881: RAISE;

Line 1897: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

1893: l_api_name CONSTANT VARCHAR2(30) := 'CLOB_TO_FILE';
1894:
1895: BEGIN
1896:
1897: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1898: -- get length of internal lob and open the dest. file.
1899: l_clob_size := dbms_lob.getlength(p_clob);
1900:
1901: IF (l_clob_size = 0) THEN

Line 1902: LogMessage(FND_LOG.LEVEL_PROCEDURE,'CLOB is empty');

1898: -- get length of internal lob and open the dest. file.
1899: l_clob_size := dbms_lob.getlength(p_clob);
1900:
1901: IF (l_clob_size = 0) THEN
1902: LogMessage(FND_LOG.LEVEL_PROCEDURE,'CLOB is empty');
1903: RETURN;
1904: END IF;
1905:
1906: l_offset := 1;

Line 1917: LogMessage(FND_LOG.LEVEL_PROCEDURE,'chunk limit size is '||l_chunk_limit_size);

1913: l_chunk_limit_size := l_chunk_limit_size + l_chunk_size;
1914: END LOOP;
1915: l_chunk_limit_size := l_chunk_limit_size - l_chunk_size;
1916:
1917: LogMessage(FND_LOG.LEVEL_PROCEDURE,'chunk limit size is '||l_chunk_limit_size);
1918:
1919: l_new_line := '
1920: ';
1921:

Line 1922: LogMessage(FND_LOG.LEVEL_PROCEDURE,'Unloading... ' || l_clob_size);

1918:
1919: l_new_line := '
1920: ';
1921:
1922: LogMessage(FND_LOG.LEVEL_PROCEDURE,'Unloading... ' || l_clob_size);
1923:
1924: WHILE (l_clob_size > 0) LOOP
1925:
1926: -- LogMessage(FND_LOG.LEVEL_PROCEDURE,'Off Set: ' || l_offset);

Line 1926: -- LogMessage(FND_LOG.LEVEL_PROCEDURE,'Off Set: ' || l_offset);

1922: LogMessage(FND_LOG.LEVEL_PROCEDURE,'Unloading... ' || l_clob_size);
1923:
1924: WHILE (l_clob_size > 0) LOOP
1925:
1926: -- LogMessage(FND_LOG.LEVEL_PROCEDURE,'Off Set: ' || l_offset);
1927:
1928: l_chunk := dbms_lob.substr (p_clob, l_chunk_size, l_offset);
1929:
1930: --LogMessage(FND_LOG.LEVEL_PROCEDURE,'Off Set: ' || l_offset);

Line 1930: --LogMessage(FND_LOG.LEVEL_PROCEDURE,'Off Set: ' || l_offset);

1926: -- LogMessage(FND_LOG.LEVEL_PROCEDURE,'Off Set: ' || l_offset);
1927:
1928: l_chunk := dbms_lob.substr (p_clob, l_chunk_size, l_offset);
1929:
1930: --LogMessage(FND_LOG.LEVEL_PROCEDURE,'Off Set: ' || l_offset);
1931: --LogMessage(FND_LOG.LEVEL_PROCEDURE,'l_chunk ' || l_chunk);
1932:
1933: -- There should be one new line character(chr(10)) for every 32k when
1934: -- writing into the file using 'utl_file' package.

Line 1931: --LogMessage(FND_LOG.LEVEL_PROCEDURE,'l_chunk ' || l_chunk);

1927:
1928: l_chunk := dbms_lob.substr (p_clob, l_chunk_size, l_offset);
1929:
1930: --LogMessage(FND_LOG.LEVEL_PROCEDURE,'Off Set: ' || l_offset);
1931: --LogMessage(FND_LOG.LEVEL_PROCEDURE,'l_chunk ' || l_chunk);
1932:
1933: -- There should be one new line character(chr(10)) for every 32k when
1934: -- writing into the file using 'utl_file' package.
1935:

Line 1937: LogMessage(FND_LOG.LEVEL_PROCEDURE,'Reached into the Limit Size');

1933: -- There should be one new line character(chr(10)) for every 32k when
1934: -- writing into the file using 'utl_file' package.
1935:
1936: if((mod(l_offset,l_chunk_limit_size) = 1) AND (l_offset <> 1)) then
1937: LogMessage(FND_LOG.LEVEL_PROCEDURE,'Reached into the Limit Size');
1938:
1939: -- Inserting new line character(chr(10)) after the first appearing
1940: -- closing XML tag
1941: l_res_offset := instr(l_chunk,'>');

Line 1943: LogMessage(FND_LOG.LEVEL_PROCEDURE,'result Offset is '||l_res_offset);

1939: -- Inserting new line character(chr(10)) after the first appearing
1940: -- closing XML tag
1941: l_res_offset := instr(l_chunk,'>');
1942:
1943: LogMessage(FND_LOG.LEVEL_PROCEDURE,'result Offset is '||l_res_offset);
1944:
1945: if(l_res_offset > 0) then
1946: l_chunk := substr(l_chunk,1,l_res_offset)||l_new_line||substr(l_chunk,(l_res_offset+1),length(l_chunk));
1947: end if;

Line 1960: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

1956:
1957: END LOOP;
1958:
1959: fnd_file.new_line(fnd_file.output,1);
1960: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1961:
1962: EXCEPTION
1963: WHEN OTHERS THEN
1964: LogMessage(FND_LOG.LEVEL_PROCEDURE,'EXCEPTION: OTHERS clob_to_file');

Line 1964: LogMessage(FND_LOG.LEVEL_PROCEDURE,'EXCEPTION: OTHERS clob_to_file');

1960: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1961:
1962: EXCEPTION
1963: WHEN OTHERS THEN
1964: LogMessage(FND_LOG.LEVEL_PROCEDURE,'EXCEPTION: OTHERS clob_to_file');
1965: LogMessage(FND_LOG.LEVEL_PROCEDURE,sqlcode);
1966: LogMessage(FND_LOG.LEVEL_PROCEDURE,sqlerrm);
1967: RAISE;
1968:

Line 1965: LogMessage(FND_LOG.LEVEL_PROCEDURE,sqlcode);

1961:
1962: EXCEPTION
1963: WHEN OTHERS THEN
1964: LogMessage(FND_LOG.LEVEL_PROCEDURE,'EXCEPTION: OTHERS clob_to_file');
1965: LogMessage(FND_LOG.LEVEL_PROCEDURE,sqlcode);
1966: LogMessage(FND_LOG.LEVEL_PROCEDURE,sqlerrm);
1967: RAISE;
1968:
1969: END;

Line 1966: LogMessage(FND_LOG.LEVEL_PROCEDURE,sqlerrm);

1962: EXCEPTION
1963: WHEN OTHERS THEN
1964: LogMessage(FND_LOG.LEVEL_PROCEDURE,'EXCEPTION: OTHERS clob_to_file');
1965: LogMessage(FND_LOG.LEVEL_PROCEDURE,sqlcode);
1966: LogMessage(FND_LOG.LEVEL_PROCEDURE,sqlerrm);
1967: RAISE;
1968:
1969: END;
1970:

Line 1993: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

1989: l_count NUMBER;
1990: l_agreement_exist_flag VARCHAR2(1) := 'Y';
1991:
1992: BEGIN
1993: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1994:
1995: l_loan_id := LOAN_ID;
1996:
1997: select lh.loan_status into l_loan_status

Line 2001: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Loan Id = ' || LOAN_ID);

1997: select lh.loan_status into l_loan_status
1998: from lns_loan_headers_all lh
1999: where lh.loan_id = l_loan_id;
2000:
2001: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Loan Id = ' || LOAN_ID);
2002: LogMessage(FND_LOG.LEVEL_STATEMENT, 'REASON = ' || P_REASON);
2003: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS = ' || l_loan_status);
2004:
2005: IF (l_loan_status <> 'DELETED' AND l_loan_status <> 'PAIDOFF' AND l_loan_status <> 'REJECTED') THEN

Line 2002: LogMessage(FND_LOG.LEVEL_STATEMENT, 'REASON = ' || P_REASON);

1998: from lns_loan_headers_all lh
1999: where lh.loan_id = l_loan_id;
2000:
2001: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Loan Id = ' || LOAN_ID);
2002: LogMessage(FND_LOG.LEVEL_STATEMENT, 'REASON = ' || P_REASON);
2003: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS = ' || l_loan_status);
2004:
2005: IF (l_loan_status <> 'DELETED' AND l_loan_status <> 'PAIDOFF' AND l_loan_status <> 'REJECTED') THEN
2006:

Line 2003: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS = ' || l_loan_status);

1999: where lh.loan_id = l_loan_id;
2000:
2001: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Loan Id = ' || LOAN_ID);
2002: LogMessage(FND_LOG.LEVEL_STATEMENT, 'REASON = ' || P_REASON);
2003: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS = ' || l_loan_status);
2004:
2005: IF (l_loan_status <> 'DELETED' AND l_loan_status <> 'PAIDOFF' AND l_loan_status <> 'REJECTED') THEN
2006:
2007: select max(version) into l_version

Line 2021: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Version = ' || l_version);

2017: l_version := l_version+1;
2018: l_object_version_number := l_version;
2019: end if;
2020:
2021: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Version = ' || l_version);
2022:
2023: IF(P_REASON IS NULL OR P_REASON = '') THEN
2024: -- Retrieve default agreement reason
2025: FND_MESSAGE.SET_NAME('LNS', 'LNS_ORIG_AGR_REASON');

Line 2035: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Generating agreement report1...in process agreement report');

2031: END IF;
2032:
2033: IF(l_loan_status = 'INCOMPLETE' or l_loan_status = 'PENDING') THEN
2034:
2035: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Generating agreement report1...in process agreement report');
2036: GEN_AGREEMENT_XML(p_AgreementXML=> l_result_xml,
2037: p_loan_id => l_loan_id,
2038: p_based_on_terms => 'ORIGINAL');
2039:

Line 2045: LogMessage(FND_LOG.LEVEL_STATEMENT,'For incomplete loan, inserting loan agreement for first time');

2041: from lns_loan_documents
2042: where source_id = l_loan_id;
2043:
2044: IF(l_count = 0) THEN
2045: LogMessage(FND_LOG.LEVEL_STATEMENT,'For incomplete loan, inserting loan agreement for first time');
2046: LNS_LOAN_DOCUMENTS_PKG.Insert_Row(X_DOCUMENT_ID => l_document_id
2047: ,P_SOURCE_ID => l_loan_id
2048: ,P_SOURCE_TABLE =>'LNS_LOAN_HEADERS_ALL'
2049: ,P_DOCUMENT_TYPE => 'LOAN_AGREEMENT'

Line 2055: LogMessage(FND_LOG.LEVEL_STATEMENT,'Updating the existing agreement instead of creating a new record in DB');

2051: ,P_DOCUMENT_XML => l_result_xml
2052: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
2053: ,P_REASON => l_reason);
2054: ELSE
2055: LogMessage(FND_LOG.LEVEL_STATEMENT,'Updating the existing agreement instead of creating a new record in DB');
2056: LNS_LOAN_DOCUMENTS_PKG.Update_Row(X_DOCUMENT_ID => l_document_id
2057: ,P_SOURCE_ID => l_loan_id
2058: ,P_SOURCE_TABLE =>'LNS_LOAN_HEADERS_ALL'
2059: ,P_DOCUMENT_TYPE => 'LOAN_AGREEMENT'

Line 2068: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Generating agreement report2...in process agreement report');

2064: END IF;
2065:
2066: ELSE
2067:
2068: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Generating agreement report2...in process agreement report');
2069: GEN_AGREEMENT_XML(p_AgreementXML=> l_result_xml,
2070: p_loan_id => l_loan_id,
2071: p_based_on_terms => 'CURRENT');
2072:

Line 2073: LogMessage(FND_LOG.LEVEL_STATEMENT,'Creating a new Agreement record in DB');

2069: GEN_AGREEMENT_XML(p_AgreementXML=> l_result_xml,
2070: p_loan_id => l_loan_id,
2071: p_based_on_terms => 'CURRENT');
2072:
2073: LogMessage(FND_LOG.LEVEL_STATEMENT,'Creating a new Agreement record in DB');
2074: LNS_LOAN_DOCUMENTS_PKG.Insert_Row(X_DOCUMENT_ID => l_document_id
2075: ,P_SOURCE_ID => l_loan_id
2076: ,P_SOURCE_TABLE =>'LNS_LOAN_HEADERS_ALL'
2077: ,P_DOCUMENT_TYPE => 'LOAN_AGREEMENT'

Line 2084: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Printing...');

2080: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
2081: ,P_REASON => l_reason);
2082: END IF;
2083:
2084: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Printing...');
2085: clob_to_file(l_result_xml);
2086:
2087: ELSE
2088: LogMessage(FND_LOG.LEVEL_STATEMENT, 'No agreement report will be generated');

Line 2088: LogMessage(FND_LOG.LEVEL_STATEMENT, 'No agreement report will be generated');

2084: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Printing...');
2085: clob_to_file(l_result_xml);
2086:
2087: ELSE
2088: LogMessage(FND_LOG.LEVEL_STATEMENT, 'No agreement report will be generated');
2089: END IF;
2090: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2091:
2092: EXCEPTION

Line 2090: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

2086:
2087: ELSE
2088: LogMessage(FND_LOG.LEVEL_STATEMENT, 'No agreement report will be generated');
2089: END IF;
2090: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2091:
2092: EXCEPTION
2093: WHEN OTHERS THEN
2094: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' - In exception');

Line 2094: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' - In exception');

2090: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2091:
2092: EXCEPTION
2093: WHEN OTHERS THEN
2094: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' - In exception');
2095: RAISE;
2096: END PROCESS_AGREEMENT_REPORT;
2097:
2098: PROCEDURE STORE_LOAN_AGREEMENT (P_LOAN_ID IN NUMBER

Line 2119: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

2115: and document_type = 'LOAN_AGREEMENT';
2116:
2117: BEGIN
2118:
2119: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2120:
2121: select lh.loan_status into l_loan_status
2122: from lns_loan_headers_all lh
2123: where lh.loan_id = P_LOAN_ID;

Line 2125: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_ID = ' || P_LOAN_ID);

2121: select lh.loan_status into l_loan_status
2122: from lns_loan_headers_all lh
2123: where lh.loan_id = P_LOAN_ID;
2124:
2125: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_ID = ' || P_LOAN_ID);
2126: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_AGREEMENT_REASON = ' || P_AGREEMENT_REASON);
2127: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS = ' || l_loan_status);
2128:
2129: IF(P_AGREEMENT_REASON IS NULL OR P_AGREEMENT_REASON = '') THEN

Line 2126: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_AGREEMENT_REASON = ' || P_AGREEMENT_REASON);

2122: from lns_loan_headers_all lh
2123: where lh.loan_id = P_LOAN_ID;
2124:
2125: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_ID = ' || P_LOAN_ID);
2126: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_AGREEMENT_REASON = ' || P_AGREEMENT_REASON);
2127: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS = ' || l_loan_status);
2128:
2129: IF(P_AGREEMENT_REASON IS NULL OR P_AGREEMENT_REASON = '') THEN
2130: -- Retrieve default agreement reason

Line 2127: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS = ' || l_loan_status);

2123: where lh.loan_id = P_LOAN_ID;
2124:
2125: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_ID = ' || P_LOAN_ID);
2126: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_AGREEMENT_REASON = ' || P_AGREEMENT_REASON);
2127: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS = ' || l_loan_status);
2128:
2129: IF(P_AGREEMENT_REASON IS NULL OR P_AGREEMENT_REASON = '') THEN
2130: -- Retrieve default agreement reason
2131: FND_MESSAGE.SET_NAME('LNS', 'LNS_ORIG_AGR_REASON');

Line 2147: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Generating agreement report1...');

2143: INTO l_result_xml;
2144:
2145: IF(l_loan_status = 'INCOMPLETE' or l_loan_status = 'PENDING') THEN
2146:
2147: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Generating agreement report1...');
2148: GEN_AGREEMENT_XML(p_AgreementXML=> l_result_xml,
2149: p_loan_id => p_loan_id,
2150: p_based_on_terms => 'ORIGINAL');
2151:

Line 2154: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Generating agreement report2...');

2150: p_based_on_terms => 'ORIGINAL');
2151:
2152: ELSE
2153:
2154: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Generating agreement report2...');
2155: GEN_AGREEMENT_XML(p_AgreementXML=> l_result_xml,
2156: p_loan_id => p_loan_id,
2157: p_based_on_terms => 'CURRENT');
2158:

Line 2163: LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting loan agreement for first time...');

2159: END IF;
2160:
2161: IF csr_loan_agreement%NOTFOUND THEN
2162:
2163: LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting loan agreement for first time...');
2164: LNS_LOAN_DOCUMENTS_PKG.Insert_Row(X_DOCUMENT_ID => l_document_id
2165: ,P_SOURCE_ID => p_loan_id
2166: ,P_SOURCE_TABLE =>'LNS_LOAN_HEADERS_ALL'
2167: ,P_DOCUMENT_TYPE => 'LOAN_AGREEMENT'

Line 2175: LogMessage(FND_LOG.LEVEL_STATEMENT,'Updating the existing agreement...');

2171: ,P_REASON => l_reason);
2172:
2173: ELSE
2174:
2175: LogMessage(FND_LOG.LEVEL_STATEMENT,'Updating the existing agreement...');
2176: LNS_LOAN_DOCUMENTS_PKG.Update_Row(X_DOCUMENT_ID => l_document_id
2177: ,P_SOURCE_ID => p_loan_id
2178: ,P_SOURCE_TABLE =>'LNS_LOAN_HEADERS_ALL'
2179: ,P_DOCUMENT_TYPE => 'LOAN_AGREEMENT'

Line 2188: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

2184:
2185: END IF;
2186: CLOSE csr_loan_agreement;
2187:
2188: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2189:
2190: EXCEPTION
2191: WHEN OTHERS THEN
2192: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name

Line 2192: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name

2188: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2189:
2190: EXCEPTION
2191: WHEN OTHERS THEN
2192: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name
2193: || ' -');
2194: RAISE;
2195: END STORE_LOAN_AGREEMENT;
2196:

Line 2214: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

2210: select org_id from lns_loan_headers_all where loan_id = P_LOAN_ID;
2211:
2212: BEGIN
2213:
2214: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2215:
2216: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_ID = ' || P_LOAN_ID);
2217: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_AGREEMENT_REASON = ' || P_AGREEMENT_REASON);
2218:

Line 2216: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_ID = ' || P_LOAN_ID);

2212: BEGIN
2213:
2214: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2215:
2216: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_ID = ' || P_LOAN_ID);
2217: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_AGREEMENT_REASON = ' || P_AGREEMENT_REASON);
2218:
2219: /* verify input parameters */
2220: if P_LOAN_ID is null then

Line 2217: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_AGREEMENT_REASON = ' || P_AGREEMENT_REASON);

2213:
2214: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2215:
2216: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_LOAN_ID = ' || P_LOAN_ID);
2217: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_AGREEMENT_REASON = ' || P_AGREEMENT_REASON);
2218:
2219: /* verify input parameters */
2220: if P_LOAN_ID is null then
2221:

Line 2225: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

2221:
2222: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2223: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_ID' );
2224: FND_MSG_PUB.Add;
2225: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2226: RAISE FND_API.G_EXC_ERROR;
2227:
2228: end if;
2229:

Line 2235: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

2231:
2232: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
2233: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_AGREEMENT_REASON' );
2234: FND_MSG_PUB.Add;
2235: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2236: RAISE FND_API.G_EXC_ERROR;
2237:
2238: end if;
2239:

Line 2258: logMessage(FND_LOG.LEVEL_STATEMENT, 'Calling fnd_request.add_layout...');

2254: FND_LANGUAGES
2255: WHERE
2256: language_code = USERENV('LANG');
2257:
2258: logMessage(FND_LOG.LEVEL_STATEMENT, 'Calling fnd_request.add_layout...');
2259: l_xml_output:= fnd_request.add_layout(
2260: template_appl_name => 'LNS',
2261: template_code => 'LNSRPTAG',
2262: template_language => l_iso_language,

Line 2267: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_iso_language = ' || l_iso_language);

2263: template_territory => l_iso_territory,
2264: output_format => 'PDF'
2265: );
2266:
2267: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_iso_language = ' || l_iso_language);
2268: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_iso_territory = ' || l_iso_territory);
2269:
2270: logMessage(FND_LOG.LEVEL_STATEMENT, 'Submitting LNS_AGREEMENT cp...');
2271: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'

Line 2268: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_iso_territory = ' || l_iso_territory);

2264: output_format => 'PDF'
2265: );
2266:
2267: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_iso_language = ' || l_iso_language);
2268: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_iso_territory = ' || l_iso_territory);
2269:
2270: logMessage(FND_LOG.LEVEL_STATEMENT, 'Submitting LNS_AGREEMENT cp...');
2271: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'
2272: ,'LNS_AGREEMENT'

Line 2270: logMessage(FND_LOG.LEVEL_STATEMENT, 'Submitting LNS_AGREEMENT cp...');

2266:
2267: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_iso_language = ' || l_iso_language);
2268: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_iso_territory = ' || l_iso_territory);
2269:
2270: logMessage(FND_LOG.LEVEL_STATEMENT, 'Submitting LNS_AGREEMENT cp...');
2271: l_request_id := FND_REQUEST.SUBMIT_REQUEST('LNS'
2272: ,'LNS_AGREEMENT'
2273: ,'', '', FALSE
2274: ,P_LOAN_ID

Line 2283: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully submited Loan Agreement Report Generation Concurrent Program. Request id: ' || l_request_id);

2279: FND_MESSAGE.SET_NAME('LNS', 'LNS_AGREEMENT_REQUEST_FAILED');
2280: FND_MSG_PUB.Add;
2281: RAISE FND_API.G_EXC_ERROR;
2282: end if;
2283: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully submited Loan Agreement Report Generation Concurrent Program. Request id: ' || l_request_id);
2284:
2285: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2286:
2287: EXCEPTION

Line 2285: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

2281: RAISE FND_API.G_EXC_ERROR;
2282: end if;
2283: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully submited Loan Agreement Report Generation Concurrent Program. Request id: ' || l_request_id);
2284:
2285: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2286:
2287: EXCEPTION
2288: WHEN OTHERS THEN
2289: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' -');

Line 2289: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' -');

2285: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2286:
2287: EXCEPTION
2288: WHEN OTHERS THEN
2289: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' -');
2290: END;
2291:
2292:
2293:

Line 2367: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

2363: BEGIN
2364:
2365: g_cr_return_status := 'NORMAL';
2366:
2367: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2368: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters:');
2369: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_FROM_LOAN_OFFICER = ' || P_FROM_LOAN_OFFICER);
2370: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_TO_LOAN_OFFICER = ' || P_TO_LOAN_OFFICER);
2371:

Line 2368: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters:');

2364:
2365: g_cr_return_status := 'NORMAL';
2366:
2367: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2368: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters:');
2369: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_FROM_LOAN_OFFICER = ' || P_FROM_LOAN_OFFICER);
2370: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_TO_LOAN_OFFICER = ' || P_TO_LOAN_OFFICER);
2371:
2372: if P_FROM_LOAN_OFFICER is null then

Line 2369: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_FROM_LOAN_OFFICER = ' || P_FROM_LOAN_OFFICER);

2365: g_cr_return_status := 'NORMAL';
2366:
2367: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2368: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters:');
2369: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_FROM_LOAN_OFFICER = ' || P_FROM_LOAN_OFFICER);
2370: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_TO_LOAN_OFFICER = ' || P_TO_LOAN_OFFICER);
2371:
2372: if P_FROM_LOAN_OFFICER is null then
2373: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

Line 2370: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_TO_LOAN_OFFICER = ' || P_TO_LOAN_OFFICER);

2366:
2367: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2368: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters:');
2369: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_FROM_LOAN_OFFICER = ' || P_FROM_LOAN_OFFICER);
2370: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_TO_LOAN_OFFICER = ' || P_TO_LOAN_OFFICER);
2371:
2372: if P_FROM_LOAN_OFFICER is null then
2373: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2374: FND_MESSAGE.SET_TOKEN('PARAMETER', 'P_FROM_LOAN_OFFICER');

Line 2377: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

2373: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2374: FND_MESSAGE.SET_TOKEN('PARAMETER', 'P_FROM_LOAN_OFFICER');
2375: FND_MESSAGE.SET_TOKEN('VALUE', P_FROM_LOAN_OFFICER);
2376: FND_MSG_PUB.ADD;
2377: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2378: RAISE FND_API.G_EXC_ERROR;
2379: end if;
2380:
2381: if P_TO_LOAN_OFFICER is null then

Line 2386: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

2382: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2383: FND_MESSAGE.SET_TOKEN('PARAMETER', 'P_TO_LOAN_OFFICER');
2384: FND_MESSAGE.SET_TOKEN('VALUE', P_TO_LOAN_OFFICER);
2385: FND_MSG_PUB.ADD;
2386: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2387: RAISE FND_API.G_EXC_ERROR;
2388: end if;
2389:
2390: /* init variables */

Line 2407: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');

2403: l_loan_number;
2404: exit when loans_to_be_transferred_cur%NOTFOUND;
2405:
2406: l_count := l_count + 1;
2407: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2408: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Processing Loan ' || l_loan_number || ' id ' || l_loan_id);
2409:
2410: BEGIN
2411: /* updating loan header table */

Line 2408: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Processing Loan ' || l_loan_number || ' id ' || l_loan_id);

2404: exit when loans_to_be_transferred_cur%NOTFOUND;
2405:
2406: l_count := l_count + 1;
2407: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2408: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Processing Loan ' || l_loan_number || ' id ' || l_loan_id);
2409:
2410: BEGIN
2411: /* updating loan header table */
2412: l_loan_header_rec.loan_id := l_loan_id;

Line 2424: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_return_status: ' || l_return_status);

2420: X_MSG_DATA => l_msg_data);
2421:
2422:
2423: IF l_return_status <> 'S' THEN
2424: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_return_status: ' || l_return_status);
2425: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
2426: FND_MSG_PUB.Add;
2427: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2428: RAISE FND_API.G_EXC_ERROR;

Line 2427: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

2423: IF l_return_status <> 'S' THEN
2424: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'l_return_status: ' || l_return_status);
2425: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
2426: FND_MSG_PUB.Add;
2427: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2428: RAISE FND_API.G_EXC_ERROR;
2429: END IF;
2430:
2431: --Everything successful here then go ahead and commit the updates

Line 2433: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully processed loan ' || l_loan_number);

2429: END IF;
2430:
2431: --Everything successful here then go ahead and commit the updates
2432: COMMIT WORK;
2433: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully processed loan ' || l_loan_number);
2434:
2435:
2436: EXCEPTION
2437: WHEN OTHERS THEN

Line 2438: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Failed to process loan ' || l_loan_number);

2434:
2435:
2436: EXCEPTION
2437: WHEN OTHERS THEN
2438: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Failed to process loan ' || l_loan_number);
2439: g_cr_return_status := 'WARNING';
2440: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
2441: status => g_cr_return_status,
2442: message => 'Not all loans were transfered successfully. Please review log file.');

Line 2451: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '______________');

2447: close loans_to_be_transferred_cur;
2448:
2449: end if;
2450:
2451: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '______________');
2452: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' loan(s)');
2453: l_end := sysdate;
2454: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Timing: ' || round((l_end - l_start)*86400, 2) || ' sec');
2455:

Line 2452: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' loan(s)');

2448:
2449: end if;
2450:
2451: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '______________');
2452: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' loan(s)');
2453: l_end := sysdate;
2454: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Timing: ' || round((l_end - l_start)*86400, 2) || ' sec');
2455:
2456: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

Line 2454: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Timing: ' || round((l_end - l_start)*86400, 2) || ' sec');

2450:
2451: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '______________');
2452: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' loan(s)');
2453: l_end := sysdate;
2454: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Timing: ' || round((l_end - l_start)*86400, 2) || ' sec');
2455:
2456: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2457:
2458: EXCEPTION

Line 2456: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

2452: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' loan(s)');
2453: l_end := sysdate;
2454: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Timing: ' || round((l_end - l_start)*86400, 2) || ' sec');
2455:
2456: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2457:
2458: EXCEPTION
2459: WHEN OTHERS THEN
2460: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to Transfer Loans');

Line 2460: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to Transfer Loans');

2456: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2457:
2458: EXCEPTION
2459: WHEN OTHERS THEN
2460: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to Transfer Loans');
2461: g_cr_return_status := 'ERROR';
2462: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
2463: status => g_cr_return_status,
2464: message => 'Failed to Transfer Loans. Please review log file.');

Line 2558: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

2554: order by parts.LOAN_ID, parts.PARTICIPANT_ID;
2555:
2556: BEGIN
2557:
2558: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2559: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters:');
2560: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ORG_ID = ' || ORG_ID);
2561: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORROWER_ID = ' || BORROWER_ID);
2562: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRODUCT_ID = ' || PRODUCT_ID);

Line 2559: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters:');

2555:
2556: BEGIN
2557:
2558: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2559: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters:');
2560: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ORG_ID = ' || ORG_ID);
2561: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORROWER_ID = ' || BORROWER_ID);
2562: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRODUCT_ID = ' || PRODUCT_ID);
2563: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORR_ACCESS_LEVEL = ' || BORR_ACCESS_LEVEL);

Line 2560: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ORG_ID = ' || ORG_ID);

2556: BEGIN
2557:
2558: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2559: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters:');
2560: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ORG_ID = ' || ORG_ID);
2561: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORROWER_ID = ' || BORROWER_ID);
2562: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRODUCT_ID = ' || PRODUCT_ID);
2563: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORR_ACCESS_LEVEL = ' || BORR_ACCESS_LEVEL);
2564: LogMessage(FND_LOG.LEVEL_STATEMENT, 'COBORR_ACCESS_LEVEL = ' || COBORR_ACCESS_LEVEL);

Line 2561: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORROWER_ID = ' || BORROWER_ID);

2557:
2558: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2559: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters:');
2560: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ORG_ID = ' || ORG_ID);
2561: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORROWER_ID = ' || BORROWER_ID);
2562: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRODUCT_ID = ' || PRODUCT_ID);
2563: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORR_ACCESS_LEVEL = ' || BORR_ACCESS_LEVEL);
2564: LogMessage(FND_LOG.LEVEL_STATEMENT, 'COBORR_ACCESS_LEVEL = ' || COBORR_ACCESS_LEVEL);
2565: LogMessage(FND_LOG.LEVEL_STATEMENT, 'GUAR_ACCESS_LEVEL = ' || GUAR_ACCESS_LEVEL);

Line 2562: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRODUCT_ID = ' || PRODUCT_ID);

2558: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2559: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters:');
2560: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ORG_ID = ' || ORG_ID);
2561: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORROWER_ID = ' || BORROWER_ID);
2562: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRODUCT_ID = ' || PRODUCT_ID);
2563: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORR_ACCESS_LEVEL = ' || BORR_ACCESS_LEVEL);
2564: LogMessage(FND_LOG.LEVEL_STATEMENT, 'COBORR_ACCESS_LEVEL = ' || COBORR_ACCESS_LEVEL);
2565: LogMessage(FND_LOG.LEVEL_STATEMENT, 'GUAR_ACCESS_LEVEL = ' || GUAR_ACCESS_LEVEL);
2566:

Line 2563: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORR_ACCESS_LEVEL = ' || BORR_ACCESS_LEVEL);

2559: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input parameters:');
2560: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ORG_ID = ' || ORG_ID);
2561: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORROWER_ID = ' || BORROWER_ID);
2562: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRODUCT_ID = ' || PRODUCT_ID);
2563: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORR_ACCESS_LEVEL = ' || BORR_ACCESS_LEVEL);
2564: LogMessage(FND_LOG.LEVEL_STATEMENT, 'COBORR_ACCESS_LEVEL = ' || COBORR_ACCESS_LEVEL);
2565: LogMessage(FND_LOG.LEVEL_STATEMENT, 'GUAR_ACCESS_LEVEL = ' || GUAR_ACCESS_LEVEL);
2566:
2567: /* init variables */

Line 2564: LogMessage(FND_LOG.LEVEL_STATEMENT, 'COBORR_ACCESS_LEVEL = ' || COBORR_ACCESS_LEVEL);

2560: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ORG_ID = ' || ORG_ID);
2561: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORROWER_ID = ' || BORROWER_ID);
2562: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRODUCT_ID = ' || PRODUCT_ID);
2563: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORR_ACCESS_LEVEL = ' || BORR_ACCESS_LEVEL);
2564: LogMessage(FND_LOG.LEVEL_STATEMENT, 'COBORR_ACCESS_LEVEL = ' || COBORR_ACCESS_LEVEL);
2565: LogMessage(FND_LOG.LEVEL_STATEMENT, 'GUAR_ACCESS_LEVEL = ' || GUAR_ACCESS_LEVEL);
2566:
2567: /* init variables */
2568: l_start := sysdate;

Line 2565: LogMessage(FND_LOG.LEVEL_STATEMENT, 'GUAR_ACCESS_LEVEL = ' || GUAR_ACCESS_LEVEL);

2561: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORROWER_ID = ' || BORROWER_ID);
2562: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRODUCT_ID = ' || PRODUCT_ID);
2563: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BORR_ACCESS_LEVEL = ' || BORR_ACCESS_LEVEL);
2564: LogMessage(FND_LOG.LEVEL_STATEMENT, 'COBORR_ACCESS_LEVEL = ' || COBORR_ACCESS_LEVEL);
2565: LogMessage(FND_LOG.LEVEL_STATEMENT, 'GUAR_ACCESS_LEVEL = ' || GUAR_ACCESS_LEVEL);
2566:
2567: /* init variables */
2568: l_start := sysdate;
2569: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Start time: ' || to_char(l_start, 'DD-MON-YYYY HH24:MI:SS'));

Line 2569: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Start time: ' || to_char(l_start, 'DD-MON-YYYY HH24:MI:SS'));

2565: LogMessage(FND_LOG.LEVEL_STATEMENT, 'GUAR_ACCESS_LEVEL = ' || GUAR_ACCESS_LEVEL);
2566:
2567: /* init variables */
2568: l_start := sysdate;
2569: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Start time: ' || to_char(l_start, 'DD-MON-YYYY HH24:MI:SS'));
2570:
2571: -- processing co-borrowers
2572: if BORR_ACCESS_LEVEL is not null then
2573:

Line 2574: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');

2570:
2571: -- processing co-borrowers
2572: if BORR_ACCESS_LEVEL is not null then
2573:
2574: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2575: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Processing borrowers...');
2576: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Assigning new access level ' || BORR_ACCESS_LEVEL);
2577: l_count := 0;
2578: open part_to_be_updated_cur(ORG_ID, BORROWER_ID, PRODUCT_ID, 'PRIMARY_BORROWER', BORR_ACCESS_LEVEL);

Line 2575: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Processing borrowers...');

2571: -- processing co-borrowers
2572: if BORR_ACCESS_LEVEL is not null then
2573:
2574: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2575: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Processing borrowers...');
2576: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Assigning new access level ' || BORR_ACCESS_LEVEL);
2577: l_count := 0;
2578: open part_to_be_updated_cur(ORG_ID, BORROWER_ID, PRODUCT_ID, 'PRIMARY_BORROWER', BORR_ACCESS_LEVEL);
2579: LOOP

Line 2576: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Assigning new access level ' || BORR_ACCESS_LEVEL);

2572: if BORR_ACCESS_LEVEL is not null then
2573:
2574: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2575: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Processing borrowers...');
2576: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Assigning new access level ' || BORR_ACCESS_LEVEL);
2577: l_count := 0;
2578: open part_to_be_updated_cur(ORG_ID, BORROWER_ID, PRODUCT_ID, 'PRIMARY_BORROWER', BORR_ACCESS_LEVEL);
2579: LOOP
2580:

Line 2592: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');

2588:
2589: BEGIN
2590:
2591: l_count := l_count+1;
2592: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2593: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);
2594: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);
2595: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);
2596: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);

Line 2593: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);

2589: BEGIN
2590:
2591: l_count := l_count+1;
2592: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2593: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);
2594: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);
2595: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);
2596: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);
2597: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);

Line 2594: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);

2590:
2591: l_count := l_count+1;
2592: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2593: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);
2594: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);
2595: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);
2596: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);
2597: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);
2598:

Line 2595: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);

2591: l_count := l_count+1;
2592: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2593: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);
2594: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);
2595: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);
2596: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);
2597: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);
2598:
2599: if BORR_ACCESS_LEVEL = 'GLOBAL' then

Line 2596: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);

2592: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2593: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);
2594: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);
2595: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);
2596: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);
2597: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);
2598:
2599: if BORR_ACCESS_LEVEL = 'GLOBAL' then
2600: l_participant_rec.ACCESS_LEVEL := FND_API.G_MISS_CHAR;

Line 2597: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);

2593: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);
2594: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);
2595: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);
2596: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);
2597: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);
2598:
2599: if BORR_ACCESS_LEVEL = 'GLOBAL' then
2600: l_participant_rec.ACCESS_LEVEL := FND_API.G_MISS_CHAR;
2601: else

Line 2605: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');

2601: else
2602: l_participant_rec.ACCESS_LEVEL := BORR_ACCESS_LEVEL;
2603: end if;
2604:
2605: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');
2606: LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT (
2607: p_init_msg_list => FND_API.G_TRUE
2608: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2609: ,p_loan_participant_rec => l_participant_rec

Line 2620: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Participant updated successfully');

2616: RAISE FND_API.G_EXC_ERROR;
2617: END IF;
2618:
2619: COMMIT WORK;
2620: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Participant updated successfully');
2621:
2622: EXCEPTION
2623: WHEN OTHERS THEN
2624: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to process participant ' || l_participant_rec.PARTICIPANT_ID);

Line 2624: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to process participant ' || l_participant_rec.PARTICIPANT_ID);

2620: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Participant updated successfully');
2621:
2622: EXCEPTION
2623: WHEN OTHERS THEN
2624: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to process participant ' || l_participant_rec.PARTICIPANT_ID);
2625: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
2626: status => 'WARNING',
2627: message => 'Not all Loan Access Levels were assigned successfully. Please review log file.');
2628: END;

Line 2634: LogMessage(FND_LOG.LEVEL_STATEMENT, '______________');

2630: END LOOP;
2631:
2632: close part_to_be_updated_cur;
2633:
2634: LogMessage(FND_LOG.LEVEL_STATEMENT, '______________');
2635: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' borrowers');
2636:
2637: else
2638: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');

Line 2635: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' borrowers');

2631:
2632: close part_to_be_updated_cur;
2633:
2634: LogMessage(FND_LOG.LEVEL_STATEMENT, '______________');
2635: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' borrowers');
2636:
2637: else
2638: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2639: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Will not process borrowers access levels.');

Line 2638: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');

2634: LogMessage(FND_LOG.LEVEL_STATEMENT, '______________');
2635: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' borrowers');
2636:
2637: else
2638: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2639: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Will not process borrowers access levels.');
2640: end if;
2641:
2642: l_end := sysdate;

Line 2639: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Will not process borrowers access levels.');

2635: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' borrowers');
2636:
2637: else
2638: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2639: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Will not process borrowers access levels.');
2640: end if;
2641:
2642: l_end := sysdate;
2643: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Current time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));

Line 2643: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Current time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));

2639: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Will not process borrowers access levels.');
2640: end if;
2641:
2642: l_end := sysdate;
2643: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Current time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));
2644: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Borrowers processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');
2645:
2646:
2647: -- processing co-borrowers

Line 2644: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Borrowers processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');

2640: end if;
2641:
2642: l_end := sysdate;
2643: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Current time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));
2644: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Borrowers processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');
2645:
2646:
2647: -- processing co-borrowers
2648: if COBORR_ACCESS_LEVEL is not null then

Line 2650: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');

2646:
2647: -- processing co-borrowers
2648: if COBORR_ACCESS_LEVEL is not null then
2649:
2650: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2651: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Processing co-borrowers...');
2652: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Assigning new access level ' || COBORR_ACCESS_LEVEL);
2653: l_count := 0;
2654: open part_to_be_updated_cur(ORG_ID, BORROWER_ID, PRODUCT_ID, 'COBORROWER', COBORR_ACCESS_LEVEL);

Line 2651: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Processing co-borrowers...');

2647: -- processing co-borrowers
2648: if COBORR_ACCESS_LEVEL is not null then
2649:
2650: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2651: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Processing co-borrowers...');
2652: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Assigning new access level ' || COBORR_ACCESS_LEVEL);
2653: l_count := 0;
2654: open part_to_be_updated_cur(ORG_ID, BORROWER_ID, PRODUCT_ID, 'COBORROWER', COBORR_ACCESS_LEVEL);
2655: LOOP

Line 2652: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Assigning new access level ' || COBORR_ACCESS_LEVEL);

2648: if COBORR_ACCESS_LEVEL is not null then
2649:
2650: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2651: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Processing co-borrowers...');
2652: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Assigning new access level ' || COBORR_ACCESS_LEVEL);
2653: l_count := 0;
2654: open part_to_be_updated_cur(ORG_ID, BORROWER_ID, PRODUCT_ID, 'COBORROWER', COBORR_ACCESS_LEVEL);
2655: LOOP
2656:

Line 2668: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');

2664:
2665: BEGIN
2666:
2667: l_count := l_count+1;
2668: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2669: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);
2670: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);
2671: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);
2672: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);

Line 2669: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);

2665: BEGIN
2666:
2667: l_count := l_count+1;
2668: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2669: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);
2670: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);
2671: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);
2672: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);
2673: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);

Line 2670: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);

2666:
2667: l_count := l_count+1;
2668: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2669: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);
2670: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);
2671: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);
2672: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);
2673: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);
2674:

Line 2671: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);

2667: l_count := l_count+1;
2668: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2669: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);
2670: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);
2671: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);
2672: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);
2673: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);
2674:
2675: if COBORR_ACCESS_LEVEL = 'GLOBAL' then

Line 2672: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);

2668: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2669: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);
2670: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);
2671: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);
2672: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);
2673: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);
2674:
2675: if COBORR_ACCESS_LEVEL = 'GLOBAL' then
2676: l_participant_rec.ACCESS_LEVEL := FND_API.G_MISS_CHAR;

Line 2673: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);

2669: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);
2670: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);
2671: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);
2672: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);
2673: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);
2674:
2675: if COBORR_ACCESS_LEVEL = 'GLOBAL' then
2676: l_participant_rec.ACCESS_LEVEL := FND_API.G_MISS_CHAR;
2677: else

Line 2681: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');

2677: else
2678: l_participant_rec.ACCESS_LEVEL := COBORR_ACCESS_LEVEL;
2679: end if;
2680:
2681: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');
2682: LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT (
2683: p_init_msg_list => FND_API.G_TRUE
2684: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2685: ,p_loan_participant_rec => l_participant_rec

Line 2696: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Participant updated successfully');

2692: RAISE FND_API.G_EXC_ERROR;
2693: END IF;
2694:
2695: COMMIT WORK;
2696: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Participant updated successfully');
2697:
2698: EXCEPTION
2699: WHEN OTHERS THEN
2700: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to process participant ' || l_participant_rec.PARTICIPANT_ID);

Line 2700: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to process participant ' || l_participant_rec.PARTICIPANT_ID);

2696: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Participant updated successfully');
2697:
2698: EXCEPTION
2699: WHEN OTHERS THEN
2700: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to process participant ' || l_participant_rec.PARTICIPANT_ID);
2701: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
2702: status => 'WARNING',
2703: message => 'Not all Loan Access Levels were assigned successfully. Please review log file.');
2704: END;

Line 2710: LogMessage(FND_LOG.LEVEL_STATEMENT, '______________');

2706: END LOOP;
2707:
2708: close part_to_be_updated_cur;
2709:
2710: LogMessage(FND_LOG.LEVEL_STATEMENT, '______________');
2711: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' co-borrowers');
2712:
2713: else
2714: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');

Line 2711: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' co-borrowers');

2707:
2708: close part_to_be_updated_cur;
2709:
2710: LogMessage(FND_LOG.LEVEL_STATEMENT, '______________');
2711: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' co-borrowers');
2712:
2713: else
2714: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2715: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Will not process co-borrowers.');

Line 2714: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');

2710: LogMessage(FND_LOG.LEVEL_STATEMENT, '______________');
2711: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' co-borrowers');
2712:
2713: else
2714: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2715: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Will not process co-borrowers.');
2716: end if;
2717: l_end := sysdate;
2718: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Current time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));

Line 2715: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Will not process co-borrowers.');

2711: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' co-borrowers');
2712:
2713: else
2714: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2715: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Will not process co-borrowers.');
2716: end if;
2717: l_end := sysdate;
2718: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Current time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));
2719: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Co-borrowers processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');

Line 2718: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Current time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));

2714: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2715: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Will not process co-borrowers.');
2716: end if;
2717: l_end := sysdate;
2718: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Current time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));
2719: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Co-borrowers processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');
2720:
2721:
2722: -- processing guarantors

Line 2719: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Co-borrowers processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');

2715: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Will not process co-borrowers.');
2716: end if;
2717: l_end := sysdate;
2718: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Current time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));
2719: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Co-borrowers processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');
2720:
2721:
2722: -- processing guarantors
2723: if GUAR_ACCESS_LEVEL is not null then

Line 2725: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');

2721:
2722: -- processing guarantors
2723: if GUAR_ACCESS_LEVEL is not null then
2724:
2725: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2726: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Processing guarantors...');
2727: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Assigning new access level ' || GUAR_ACCESS_LEVEL);
2728: l_count := 0;
2729: open part_to_be_updated_cur(ORG_ID, BORROWER_ID, PRODUCT_ID, 'GUARANTOR', GUAR_ACCESS_LEVEL);

Line 2726: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Processing guarantors...');

2722: -- processing guarantors
2723: if GUAR_ACCESS_LEVEL is not null then
2724:
2725: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2726: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Processing guarantors...');
2727: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Assigning new access level ' || GUAR_ACCESS_LEVEL);
2728: l_count := 0;
2729: open part_to_be_updated_cur(ORG_ID, BORROWER_ID, PRODUCT_ID, 'GUARANTOR', GUAR_ACCESS_LEVEL);
2730: LOOP

Line 2727: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Assigning new access level ' || GUAR_ACCESS_LEVEL);

2723: if GUAR_ACCESS_LEVEL is not null then
2724:
2725: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2726: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Processing guarantors...');
2727: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Assigning new access level ' || GUAR_ACCESS_LEVEL);
2728: l_count := 0;
2729: open part_to_be_updated_cur(ORG_ID, BORROWER_ID, PRODUCT_ID, 'GUARANTOR', GUAR_ACCESS_LEVEL);
2730: LOOP
2731:

Line 2743: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');

2739:
2740: BEGIN
2741:
2742: l_count := l_count+1;
2743: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2744: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);
2745: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);
2746: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);
2747: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);

Line 2744: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);

2740: BEGIN
2741:
2742: l_count := l_count+1;
2743: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2744: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);
2745: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);
2746: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);
2747: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);
2748: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);

Line 2745: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);

2741:
2742: l_count := l_count+1;
2743: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2744: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);
2745: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);
2746: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);
2747: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);
2748: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);
2749:

Line 2746: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);

2742: l_count := l_count+1;
2743: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2744: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);
2745: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);
2746: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);
2747: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);
2748: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);
2749:
2750: if GUAR_ACCESS_LEVEL = 'GLOBAL' then

Line 2747: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);

2743: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2744: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);
2745: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);
2746: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);
2747: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);
2748: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);
2749:
2750: if GUAR_ACCESS_LEVEL = 'GLOBAL' then
2751: l_participant_rec.ACCESS_LEVEL := FND_API.G_MISS_CHAR;

Line 2748: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);

2744: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Record #' || l_count);
2745: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN: ' || l_loan_number);
2746: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_id);
2747: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARTICIPANT_ID: ' || l_participant_rec.PARTICIPANT_ID);
2748: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Current ACCESS_LEVEL: ' || l_ACCESS_LEVEL);
2749:
2750: if GUAR_ACCESS_LEVEL = 'GLOBAL' then
2751: l_participant_rec.ACCESS_LEVEL := FND_API.G_MISS_CHAR;
2752: else

Line 2756: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');

2752: else
2753: l_participant_rec.ACCESS_LEVEL := GUAR_ACCESS_LEVEL;
2754: end if;
2755:
2756: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT...');
2757: LNS_PARTICIPANTS_PUB.UPDATEPARTICIPANT (
2758: p_init_msg_list => FND_API.G_TRUE
2759: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2760: ,p_loan_participant_rec => l_participant_rec

Line 2771: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Participant updated successfully');

2767: RAISE FND_API.G_EXC_ERROR;
2768: END IF;
2769:
2770: COMMIT WORK;
2771: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Participant updated successfully');
2772:
2773: EXCEPTION
2774: WHEN OTHERS THEN
2775: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to process participant ' || l_participant_rec.PARTICIPANT_ID);

Line 2775: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to process participant ' || l_participant_rec.PARTICIPANT_ID);

2771: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Participant updated successfully');
2772:
2773: EXCEPTION
2774: WHEN OTHERS THEN
2775: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to process participant ' || l_participant_rec.PARTICIPANT_ID);
2776: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
2777: status => 'WARNING',
2778: message => 'Not all Loan Access Levels were assigned successfully. Please review log file.');
2779: END;

Line 2785: LogMessage(FND_LOG.LEVEL_STATEMENT, '______________');

2781: END LOOP;
2782:
2783: close part_to_be_updated_cur;
2784:
2785: LogMessage(FND_LOG.LEVEL_STATEMENT, '______________');
2786: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' guarantors');
2787:
2788: else
2789: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');

Line 2786: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' guarantors');

2782:
2783: close part_to_be_updated_cur;
2784:
2785: LogMessage(FND_LOG.LEVEL_STATEMENT, '______________');
2786: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' guarantors');
2787:
2788: else
2789: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2790: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Will not process guarantors.');

Line 2789: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');

2785: LogMessage(FND_LOG.LEVEL_STATEMENT, '______________');
2786: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' guarantors');
2787:
2788: else
2789: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2790: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Will not process guarantors.');
2791: end if;
2792: l_end := sysdate;
2793: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'End time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));

Line 2790: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Will not process guarantors.');

2786: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_count || ' guarantors');
2787:
2788: else
2789: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2790: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Will not process guarantors.');
2791: end if;
2792: l_end := sysdate;
2793: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'End time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));
2794: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Guarantors processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');

Line 2793: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'End time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));

2789: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2790: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Will not process guarantors.');
2791: end if;
2792: l_end := sysdate;
2793: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'End time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));
2794: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Guarantors processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');
2795:
2796: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2797: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');

Line 2794: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Guarantors processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');

2790: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Will not process guarantors.');
2791: end if;
2792: l_end := sysdate;
2793: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'End time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));
2794: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Guarantors processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');
2795:
2796: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2797: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');
2798:

Line 2796: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');

2792: l_end := sysdate;
2793: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'End time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));
2794: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Guarantors processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');
2795:
2796: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2797: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');
2798:
2799: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2800: COMMIT WORK;

Line 2797: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');

2793: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'End time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));
2794: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Guarantors processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');
2795:
2796: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2797: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');
2798:
2799: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2800: COMMIT WORK;
2801:

Line 2799: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

2795:
2796: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2797: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');
2798:
2799: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2800: COMMIT WORK;
2801:
2802: EXCEPTION
2803: WHEN OTHERS THEN

Line 2804: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to Assign Loan Access Levels');

2800: COMMIT WORK;
2801:
2802: EXCEPTION
2803: WHEN OTHERS THEN
2804: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to Assign Loan Access Levels');
2805: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
2806: status => 'ERROR',
2807: message => 'Failed to Assign Loan Access Levels. Please review log file.');
2808:

Line 2900: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

2896: v_DEFERRED_INT_AMOUNT DEFERRED_INT_AMOUNT_tab_t;
2897:
2898: BEGIN
2899:
2900: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2901:
2902: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Exporting loans amortization schedules...');
2903: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Input parameters:');
2904: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ORG_ID = ' || ORG_ID);

Line 2902: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Exporting loans amortization schedules...');

2898: BEGIN
2899:
2900: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2901:
2902: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Exporting loans amortization schedules...');
2903: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Input parameters:');
2904: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ORG_ID = ' || ORG_ID);
2905: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'BORROWER_ID = ' || BORROWER_ID);
2906: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRODUCT_ID = ' || PRODUCT_ID);

Line 2903: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Input parameters:');

2899:
2900: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2901:
2902: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Exporting loans amortization schedules...');
2903: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Input parameters:');
2904: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ORG_ID = ' || ORG_ID);
2905: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'BORROWER_ID = ' || BORROWER_ID);
2906: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRODUCT_ID = ' || PRODUCT_ID);
2907: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID = ' || LOAN_ID);

Line 2904: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ORG_ID = ' || ORG_ID);

2900: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2901:
2902: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Exporting loans amortization schedules...');
2903: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Input parameters:');
2904: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ORG_ID = ' || ORG_ID);
2905: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'BORROWER_ID = ' || BORROWER_ID);
2906: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRODUCT_ID = ' || PRODUCT_ID);
2907: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID = ' || LOAN_ID);
2908: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS1 = ' || LOAN_STATUS1);

Line 2905: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'BORROWER_ID = ' || BORROWER_ID);

2901:
2902: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Exporting loans amortization schedules...');
2903: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Input parameters:');
2904: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ORG_ID = ' || ORG_ID);
2905: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'BORROWER_ID = ' || BORROWER_ID);
2906: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRODUCT_ID = ' || PRODUCT_ID);
2907: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID = ' || LOAN_ID);
2908: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS1 = ' || LOAN_STATUS1);
2909: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS2 = ' || LOAN_STATUS2);

Line 2906: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRODUCT_ID = ' || PRODUCT_ID);

2902: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Exporting loans amortization schedules...');
2903: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Input parameters:');
2904: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ORG_ID = ' || ORG_ID);
2905: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'BORROWER_ID = ' || BORROWER_ID);
2906: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRODUCT_ID = ' || PRODUCT_ID);
2907: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID = ' || LOAN_ID);
2908: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS1 = ' || LOAN_STATUS1);
2909: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS2 = ' || LOAN_STATUS2);
2910: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS3 = ' || LOAN_STATUS3);

Line 2907: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID = ' || LOAN_ID);

2903: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Input parameters:');
2904: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ORG_ID = ' || ORG_ID);
2905: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'BORROWER_ID = ' || BORROWER_ID);
2906: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRODUCT_ID = ' || PRODUCT_ID);
2907: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID = ' || LOAN_ID);
2908: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS1 = ' || LOAN_STATUS1);
2909: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS2 = ' || LOAN_STATUS2);
2910: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS3 = ' || LOAN_STATUS3);
2911: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'SCHEDULE_TYPE = ' || SCHEDULE_TYPE);

Line 2908: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS1 = ' || LOAN_STATUS1);

2904: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ORG_ID = ' || ORG_ID);
2905: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'BORROWER_ID = ' || BORROWER_ID);
2906: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRODUCT_ID = ' || PRODUCT_ID);
2907: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID = ' || LOAN_ID);
2908: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS1 = ' || LOAN_STATUS1);
2909: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS2 = ' || LOAN_STATUS2);
2910: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS3 = ' || LOAN_STATUS3);
2911: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'SCHEDULE_TYPE = ' || SCHEDULE_TYPE);
2912: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'TRUNCATE_HISTORY = ' || TRUNCATE_HISTORY);

Line 2909: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS2 = ' || LOAN_STATUS2);

2905: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'BORROWER_ID = ' || BORROWER_ID);
2906: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRODUCT_ID = ' || PRODUCT_ID);
2907: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID = ' || LOAN_ID);
2908: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS1 = ' || LOAN_STATUS1);
2909: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS2 = ' || LOAN_STATUS2);
2910: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS3 = ' || LOAN_STATUS3);
2911: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'SCHEDULE_TYPE = ' || SCHEDULE_TYPE);
2912: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'TRUNCATE_HISTORY = ' || TRUNCATE_HISTORY);
2913:

Line 2910: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS3 = ' || LOAN_STATUS3);

2906: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRODUCT_ID = ' || PRODUCT_ID);
2907: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID = ' || LOAN_ID);
2908: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS1 = ' || LOAN_STATUS1);
2909: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS2 = ' || LOAN_STATUS2);
2910: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS3 = ' || LOAN_STATUS3);
2911: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'SCHEDULE_TYPE = ' || SCHEDULE_TYPE);
2912: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'TRUNCATE_HISTORY = ' || TRUNCATE_HISTORY);
2913:
2914: /* init variables */

Line 2911: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'SCHEDULE_TYPE = ' || SCHEDULE_TYPE);

2907: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID = ' || LOAN_ID);
2908: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS1 = ' || LOAN_STATUS1);
2909: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS2 = ' || LOAN_STATUS2);
2910: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS3 = ' || LOAN_STATUS3);
2911: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'SCHEDULE_TYPE = ' || SCHEDULE_TYPE);
2912: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'TRUNCATE_HISTORY = ' || TRUNCATE_HISTORY);
2913:
2914: /* init variables */
2915: l_start := sysdate;

Line 2912: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'TRUNCATE_HISTORY = ' || TRUNCATE_HISTORY);

2908: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS1 = ' || LOAN_STATUS1);
2909: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS2 = ' || LOAN_STATUS2);
2910: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_STATUS3 = ' || LOAN_STATUS3);
2911: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'SCHEDULE_TYPE = ' || SCHEDULE_TYPE);
2912: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'TRUNCATE_HISTORY = ' || TRUNCATE_HISTORY);
2913:
2914: /* init variables */
2915: l_start := sysdate;
2916: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Start time: ' || to_char(l_start, 'DD-MON-YYYY HH24:MI:SS'));

Line 2916: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Start time: ' || to_char(l_start, 'DD-MON-YYYY HH24:MI:SS'));

2912: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'TRUNCATE_HISTORY = ' || TRUNCATE_HISTORY);
2913:
2914: /* init variables */
2915: l_start := sysdate;
2916: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Start time: ' || to_char(l_start, 'DD-MON-YYYY HH24:MI:SS'));
2917:
2918: if SCHEDULE_TYPE is null or SCHEDULE_TYPE = 'CURRENT' or SCHEDULE_TYPE = 'BOTH' then
2919: l_BASED_ON_TERMS := 'CURRENT';
2920: elsif SCHEDULE_TYPE = 'ORIGINAL' then

Line 2929: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Truncating table...');

2925: l_TRUNCATE_HISTORY := 'NO';
2926: elsif TRUNCATE_HISTORY = 'YES' then
2927: l_TRUNCATE_HISTORY := 'YES';
2928: elsif TRUNCATE_HISTORY = 'ALL' then
2929: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Truncating table...');
2930: begin
2931: execute Immediate 'TRUNCATE TABLE lns.lns_am_scheds_exports';
2932: end;
2933: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done');

Line 2933: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done');

2929: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Truncating table...');
2930: begin
2931: execute Immediate 'TRUNCATE TABLE lns.lns_am_scheds_exports';
2932: end;
2933: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done');
2934: end if;
2935:
2936: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2937: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Querying loans...');

Line 2936: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');

2932: end;
2933: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done');
2934: end if;
2935:
2936: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2937: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Querying loans...');
2938: l_count := 0;
2939: l_failed_count := 0;
2940: l_succeed_count := 0;

Line 2937: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Querying loans...');

2933: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done');
2934: end if;
2935:
2936: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
2937: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Querying loans...');
2938: l_count := 0;
2939: l_failed_count := 0;
2940: l_succeed_count := 0;
2941:

Line 3022: LogMessage(FND_LOG.LEVEL_STATEMENT, l_sql);

3018: end if;
3019:
3020: l_sql := l_sql || l_where || ' order by LOAN_ID';
3021:
3022: LogMessage(FND_LOG.LEVEL_STATEMENT, l_sql);
3023:
3024: OPEN l_cursor FOR l_sql;
3025: LOOP
3026:

Line 3042: LogMessage(FND_LOG.LEVEL_UNEXPECTED, ' ');

3038: exit when l_cursor%NOTFOUND;
3039:
3040: l_start1 := sysdate;
3041: l_count := l_count+1;
3042: LogMessage(FND_LOG.LEVEL_UNEXPECTED, ' ');
3043: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Processing loan #' || l_count);
3044: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start time: ' || to_char(l_start1, 'DD-MON-YYYY HH24:MI:SS'));
3045: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_NUMBER: ' || l_LOAN_NUMBER);
3046: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID: ' || l_LOAN_ID);

Line 3043: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Processing loan #' || l_count);

3039:
3040: l_start1 := sysdate;
3041: l_count := l_count+1;
3042: LogMessage(FND_LOG.LEVEL_UNEXPECTED, ' ');
3043: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Processing loan #' || l_count);
3044: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start time: ' || to_char(l_start1, 'DD-MON-YYYY HH24:MI:SS'));
3045: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_NUMBER: ' || l_LOAN_NUMBER);
3046: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID: ' || l_LOAN_ID);
3047: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_DESCRIPTION: ' || l_LOAN_DESCRIPTION);

Line 3044: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start time: ' || to_char(l_start1, 'DD-MON-YYYY HH24:MI:SS'));

3040: l_start1 := sysdate;
3041: l_count := l_count+1;
3042: LogMessage(FND_LOG.LEVEL_UNEXPECTED, ' ');
3043: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Processing loan #' || l_count);
3044: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start time: ' || to_char(l_start1, 'DD-MON-YYYY HH24:MI:SS'));
3045: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_NUMBER: ' || l_LOAN_NUMBER);
3046: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID: ' || l_LOAN_ID);
3047: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_DESCRIPTION: ' || l_LOAN_DESCRIPTION);
3048: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRIMARY_BORROWER_ID: ' || l_PRIMARY_BORROWER_ID);

Line 3045: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_NUMBER: ' || l_LOAN_NUMBER);

3041: l_count := l_count+1;
3042: LogMessage(FND_LOG.LEVEL_UNEXPECTED, ' ');
3043: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Processing loan #' || l_count);
3044: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start time: ' || to_char(l_start1, 'DD-MON-YYYY HH24:MI:SS'));
3045: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_NUMBER: ' || l_LOAN_NUMBER);
3046: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID: ' || l_LOAN_ID);
3047: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_DESCRIPTION: ' || l_LOAN_DESCRIPTION);
3048: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRIMARY_BORROWER_ID: ' || l_PRIMARY_BORROWER_ID);
3049: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_AMOUNT: ' || l_LOAN_AMOUNT);

Line 3046: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID: ' || l_LOAN_ID);

3042: LogMessage(FND_LOG.LEVEL_UNEXPECTED, ' ');
3043: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Processing loan #' || l_count);
3044: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start time: ' || to_char(l_start1, 'DD-MON-YYYY HH24:MI:SS'));
3045: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_NUMBER: ' || l_LOAN_NUMBER);
3046: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID: ' || l_LOAN_ID);
3047: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_DESCRIPTION: ' || l_LOAN_DESCRIPTION);
3048: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRIMARY_BORROWER_ID: ' || l_PRIMARY_BORROWER_ID);
3049: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_AMOUNT: ' || l_LOAN_AMOUNT);
3050: LogMessage(FND_LOG.LEVEL_STATEMENT, 'FUNDED_AMOUNT: ' || l_FUNDED_AMOUNT);

Line 3047: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_DESCRIPTION: ' || l_LOAN_DESCRIPTION);

3043: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Processing loan #' || l_count);
3044: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start time: ' || to_char(l_start1, 'DD-MON-YYYY HH24:MI:SS'));
3045: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_NUMBER: ' || l_LOAN_NUMBER);
3046: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID: ' || l_LOAN_ID);
3047: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_DESCRIPTION: ' || l_LOAN_DESCRIPTION);
3048: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRIMARY_BORROWER_ID: ' || l_PRIMARY_BORROWER_ID);
3049: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_AMOUNT: ' || l_LOAN_AMOUNT);
3050: LogMessage(FND_LOG.LEVEL_STATEMENT, 'FUNDED_AMOUNT: ' || l_FUNDED_AMOUNT);
3051: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_CURRENCY: ' || l_LOAN_CURRENCY);

Line 3048: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRIMARY_BORROWER_ID: ' || l_PRIMARY_BORROWER_ID);

3044: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start time: ' || to_char(l_start1, 'DD-MON-YYYY HH24:MI:SS'));
3045: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_NUMBER: ' || l_LOAN_NUMBER);
3046: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID: ' || l_LOAN_ID);
3047: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_DESCRIPTION: ' || l_LOAN_DESCRIPTION);
3048: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRIMARY_BORROWER_ID: ' || l_PRIMARY_BORROWER_ID);
3049: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_AMOUNT: ' || l_LOAN_AMOUNT);
3050: LogMessage(FND_LOG.LEVEL_STATEMENT, 'FUNDED_AMOUNT: ' || l_FUNDED_AMOUNT);
3051: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_CURRENCY: ' || l_LOAN_CURRENCY);
3052: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ORG_ID: ' || l_ORG_ID);

Line 3049: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_AMOUNT: ' || l_LOAN_AMOUNT);

3045: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_NUMBER: ' || l_LOAN_NUMBER);
3046: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID: ' || l_LOAN_ID);
3047: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_DESCRIPTION: ' || l_LOAN_DESCRIPTION);
3048: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRIMARY_BORROWER_ID: ' || l_PRIMARY_BORROWER_ID);
3049: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_AMOUNT: ' || l_LOAN_AMOUNT);
3050: LogMessage(FND_LOG.LEVEL_STATEMENT, 'FUNDED_AMOUNT: ' || l_FUNDED_AMOUNT);
3051: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_CURRENCY: ' || l_LOAN_CURRENCY);
3052: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ORG_ID: ' || l_ORG_ID);
3053: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LEGAL_ENTITY_ID: ' || l_LEGAL_ENTITY_ID);

Line 3050: LogMessage(FND_LOG.LEVEL_STATEMENT, 'FUNDED_AMOUNT: ' || l_FUNDED_AMOUNT);

3046: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN_ID: ' || l_LOAN_ID);
3047: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_DESCRIPTION: ' || l_LOAN_DESCRIPTION);
3048: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRIMARY_BORROWER_ID: ' || l_PRIMARY_BORROWER_ID);
3049: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_AMOUNT: ' || l_LOAN_AMOUNT);
3050: LogMessage(FND_LOG.LEVEL_STATEMENT, 'FUNDED_AMOUNT: ' || l_FUNDED_AMOUNT);
3051: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_CURRENCY: ' || l_LOAN_CURRENCY);
3052: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ORG_ID: ' || l_ORG_ID);
3053: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LEGAL_ENTITY_ID: ' || l_LEGAL_ENTITY_ID);
3054: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS: ' || l_LOAN_STATUS);

Line 3051: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_CURRENCY: ' || l_LOAN_CURRENCY);

3047: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_DESCRIPTION: ' || l_LOAN_DESCRIPTION);
3048: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRIMARY_BORROWER_ID: ' || l_PRIMARY_BORROWER_ID);
3049: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_AMOUNT: ' || l_LOAN_AMOUNT);
3050: LogMessage(FND_LOG.LEVEL_STATEMENT, 'FUNDED_AMOUNT: ' || l_FUNDED_AMOUNT);
3051: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_CURRENCY: ' || l_LOAN_CURRENCY);
3052: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ORG_ID: ' || l_ORG_ID);
3053: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LEGAL_ENTITY_ID: ' || l_LEGAL_ENTITY_ID);
3054: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS: ' || l_LOAN_STATUS);
3055: BEGIN

Line 3052: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ORG_ID: ' || l_ORG_ID);

3048: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PRIMARY_BORROWER_ID: ' || l_PRIMARY_BORROWER_ID);
3049: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_AMOUNT: ' || l_LOAN_AMOUNT);
3050: LogMessage(FND_LOG.LEVEL_STATEMENT, 'FUNDED_AMOUNT: ' || l_FUNDED_AMOUNT);
3051: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_CURRENCY: ' || l_LOAN_CURRENCY);
3052: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ORG_ID: ' || l_ORG_ID);
3053: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LEGAL_ENTITY_ID: ' || l_LEGAL_ENTITY_ID);
3054: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS: ' || l_LOAN_STATUS);
3055: BEGIN
3056:

Line 3053: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LEGAL_ENTITY_ID: ' || l_LEGAL_ENTITY_ID);

3049: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_AMOUNT: ' || l_LOAN_AMOUNT);
3050: LogMessage(FND_LOG.LEVEL_STATEMENT, 'FUNDED_AMOUNT: ' || l_FUNDED_AMOUNT);
3051: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_CURRENCY: ' || l_LOAN_CURRENCY);
3052: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ORG_ID: ' || l_ORG_ID);
3053: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LEGAL_ENTITY_ID: ' || l_LEGAL_ENTITY_ID);
3054: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS: ' || l_LOAN_STATUS);
3055: BEGIN
3056:
3057:

Line 3054: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS: ' || l_LOAN_STATUS);

3050: LogMessage(FND_LOG.LEVEL_STATEMENT, 'FUNDED_AMOUNT: ' || l_FUNDED_AMOUNT);
3051: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_CURRENCY: ' || l_LOAN_CURRENCY);
3052: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ORG_ID: ' || l_ORG_ID);
3053: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LEGAL_ENTITY_ID: ' || l_LEGAL_ENTITY_ID);
3054: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS: ' || l_LOAN_STATUS);
3055: BEGIN
3056:
3057:
3058: if l_TRUNCATE_HISTORY = 'YES' then

Line 3060: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Deleting history...');

3056:
3057:
3058: if l_TRUNCATE_HISTORY = 'YES' then
3059:
3060: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Deleting history...');
3061:
3062: delete from lns_am_scheds_exports
3063: where loan_id = l_LOAN_ID
3064: and SCHEDULE_TYPE = l_BASED_ON_TERMS;

Line 3072: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done');

3068: where loan_id = l_LOAN_ID
3069: and SCHEDULE_TYPE = 'ORIGINAL';
3070: end if;
3071:
3072: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done');
3073:
3074: end if;
3075:
3076: l_amort_tbl.delete;

Line 3077: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_FINANCIALS.runAmortization for ' || l_BASED_ON_TERMS || ' SCHEDULE_TYPE...');

3073:
3074: end if;
3075:
3076: l_amort_tbl.delete;
3077: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_FINANCIALS.runAmortization for ' || l_BASED_ON_TERMS || ' SCHEDULE_TYPE...');
3078: LNS_FINANCIALS.runAmortization(
3079: P_API_VERSION => 1.0,
3080: P_INIT_MSG_LIST => FND_API.G_TRUE,
3081: P_COMMIT => FND_API.G_FALSE,

Line 3089: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);

3085: x_return_status => l_return_status,
3086: x_msg_count => l_msg_count,
3087: x_msg_data => l_msg_data);
3088:
3089: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
3090: IF l_return_status <> 'S' THEN
3091: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: ' || FND_MSG_PUB.Get(p_encoded => 'F'));
3092: RAISE FND_API.G_EXC_ERROR;
3093: END IF;

Line 3091: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: ' || FND_MSG_PUB.Get(p_encoded => 'F'));

3087: x_msg_data => l_msg_data);
3088:
3089: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
3090: IF l_return_status <> 'S' THEN
3091: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: ' || FND_MSG_PUB.Get(p_encoded => 'F'));
3092: RAISE FND_API.G_EXC_ERROR;
3093: END IF;
3094:
3095: LogMessage(FND_LOG.LEVEL_UNEXPECTED, l_BASED_ON_TERMS || ' amortization schedule:');

Line 3095: LogMessage(FND_LOG.LEVEL_UNEXPECTED, l_BASED_ON_TERMS || ' amortization schedule:');

3091: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: ' || FND_MSG_PUB.Get(p_encoded => 'F'));
3092: RAISE FND_API.G_EXC_ERROR;
3093: END IF;
3094:
3095: LogMessage(FND_LOG.LEVEL_UNEXPECTED, l_BASED_ON_TERMS || ' amortization schedule:');
3096: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '# DD RATE BB UP UI PAY PRIN INT FEE EB');
3097: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '--- ------- ---- ------ ----- ----- ------- ------ ------ ------ ------');
3098: if l_amort_tbl.count > 0 then
3099:

Line 3096: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '# DD RATE BB UP UI PAY PRIN INT FEE EB');

3092: RAISE FND_API.G_EXC_ERROR;
3093: END IF;
3094:
3095: LogMessage(FND_LOG.LEVEL_UNEXPECTED, l_BASED_ON_TERMS || ' amortization schedule:');
3096: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '# DD RATE BB UP UI PAY PRIN INT FEE EB');
3097: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '--- ------- ---- ------ ----- ----- ------- ------ ------ ------ ------');
3098: if l_amort_tbl.count > 0 then
3099:
3100: v_INSTALLMENT_NUMBER.delete;

Line 3097: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '--- ------- ---- ------ ----- ----- ------- ------ ------ ------ ------');

3093: END IF;
3094:
3095: LogMessage(FND_LOG.LEVEL_UNEXPECTED, l_BASED_ON_TERMS || ' amortization schedule:');
3096: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '# DD RATE BB UP UI PAY PRIN INT FEE EB');
3097: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '--- ------- ---- ------ ----- ----- ------- ------ ------ ------ ------');
3098: if l_amort_tbl.count > 0 then
3099:
3100: v_INSTALLMENT_NUMBER.delete;
3101: v_DUE_DATE.delete;

Line 3139: LogMessage(FND_LOG.LEVEL_UNEXPECTED,

3135: v_INTEREST_RATE(i) := l_amort_tbl(i).INTEREST_RATE;
3136: v_PERIOD(i) := l_amort_tbl(i).PERIOD;
3137: v_DEFERRED_INT_AMOUNT(i) := l_amort_tbl(i).DEFERRED_INT_AMOUNT;
3138:
3139: LogMessage(FND_LOG.LEVEL_UNEXPECTED,
3140: l_amort_tbl(i).INSTALLMENT_NUMBER || ' ' ||
3141: l_amort_tbl(i).DUE_DATE || ' ' ||
3142: l_amort_tbl(i).INTEREST_RATE || ' ' ||
3143: l_amort_tbl(i).BEGIN_BALANCE || ' ' ||

Line 3153: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting records...');

3149: l_amort_tbl(i).FEE_AMOUNT || ' ' ||
3150: l_amort_tbl(i).END_BALANCE);
3151: end loop;
3152:
3153: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting records...');
3154: FORALL i in v_INSTALLMENT_NUMBER.first..v_INSTALLMENT_NUMBER.last
3155: insert into lns_am_scheds_exports
3156: (
3157: LOAN_ID

Line 3205: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done');

3201: ,v_PERIOD(i)
3202: ,v_DEFERRED_INT_AMOUNT(i)
3203: ,FND_GLOBAL.Conc_Request_Id
3204: );
3205: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done');
3206:
3207: end if;
3208:
3209: if SCHEDULE_TYPE = 'BOTH' then

Line 3212: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_FINANCIALS.runAmortization for ORIGINAL SCHEDULE_TYPE...');

3208:
3209: if SCHEDULE_TYPE = 'BOTH' then
3210:
3211: l_amort_tbl.delete;
3212: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_FINANCIALS.runAmortization for ORIGINAL SCHEDULE_TYPE...');
3213: LNS_FINANCIALS.runAmortization(
3214: P_API_VERSION => 1.0,
3215: P_INIT_MSG_LIST => FND_API.G_TRUE,
3216: P_COMMIT => FND_API.G_FALSE,

Line 3224: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);

3220: x_return_status => l_return_status,
3221: x_msg_count => l_msg_count,
3222: x_msg_data => l_msg_data);
3223:
3224: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
3225: IF l_return_status <> 'S' THEN
3226: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: ' || FND_MSG_PUB.Get(p_encoded => 'F'));
3227: RAISE FND_API.G_EXC_ERROR;
3228: END IF;

Line 3226: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: ' || FND_MSG_PUB.Get(p_encoded => 'F'));

3222: x_msg_data => l_msg_data);
3223:
3224: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
3225: IF l_return_status <> 'S' THEN
3226: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: ' || FND_MSG_PUB.Get(p_encoded => 'F'));
3227: RAISE FND_API.G_EXC_ERROR;
3228: END IF;
3229:
3230: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ORIGINAL amortization schedule:');

Line 3230: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ORIGINAL amortization schedule:');

3226: LogMessage(FND_LOG.LEVEL_STATEMENT, 'ERROR: ' || FND_MSG_PUB.Get(p_encoded => 'F'));
3227: RAISE FND_API.G_EXC_ERROR;
3228: END IF;
3229:
3230: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ORIGINAL amortization schedule:');
3231: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '# DD RATE BB UP UI PAY PRIN INT FEE EB');
3232: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '--- ------- ---- ------ ----- ----- ------- ------ ------ ------ ------');
3233: if l_amort_tbl.count > 0 then
3234:

Line 3231: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '# DD RATE BB UP UI PAY PRIN INT FEE EB');

3227: RAISE FND_API.G_EXC_ERROR;
3228: END IF;
3229:
3230: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ORIGINAL amortization schedule:');
3231: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '# DD RATE BB UP UI PAY PRIN INT FEE EB');
3232: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '--- ------- ---- ------ ----- ----- ------- ------ ------ ------ ------');
3233: if l_amort_tbl.count > 0 then
3234:
3235: v_INSTALLMENT_NUMBER.delete;

Line 3232: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '--- ------- ---- ------ ----- ----- ------- ------ ------ ------ ------');

3228: END IF;
3229:
3230: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ORIGINAL amortization schedule:');
3231: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '# DD RATE BB UP UI PAY PRIN INT FEE EB');
3232: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '--- ------- ---- ------ ----- ----- ------- ------ ------ ------ ------');
3233: if l_amort_tbl.count > 0 then
3234:
3235: v_INSTALLMENT_NUMBER.delete;
3236: v_DUE_DATE.delete;

Line 3274: LogMessage(FND_LOG.LEVEL_UNEXPECTED,

3270: v_INTEREST_RATE(i) := l_amort_tbl(i).INTEREST_RATE;
3271: v_PERIOD(i) := l_amort_tbl(i).PERIOD;
3272: v_DEFERRED_INT_AMOUNT(i) := l_amort_tbl(i).DEFERRED_INT_AMOUNT;
3273:
3274: LogMessage(FND_LOG.LEVEL_UNEXPECTED,
3275: l_amort_tbl(i).INSTALLMENT_NUMBER || ' ' ||
3276: l_amort_tbl(i).DUE_DATE || ' ' ||
3277: l_amort_tbl(i).INTEREST_RATE || ' ' ||
3278: l_amort_tbl(i).BEGIN_BALANCE || ' ' ||

Line 3288: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting records...');

3284: l_amort_tbl(i).FEE_AMOUNT || ' ' ||
3285: l_amort_tbl(i).END_BALANCE);
3286: end loop;
3287:
3288: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting records...');
3289: FORALL i in v_INSTALLMENT_NUMBER.first..v_INSTALLMENT_NUMBER.last
3290: insert into lns_am_scheds_exports
3291: (
3292: LOAN_ID

Line 3340: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done');

3336: ,v_PERIOD(i)
3337: ,v_DEFERRED_INT_AMOUNT(i)
3338: ,FND_GLOBAL.Conc_Request_Id
3339: );
3340: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done');
3341: end if;
3342:
3343: end if;
3344:

Line 3346: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully processed loan ' || l_LOAN_NUMBER);

3342:
3343: end if;
3344:
3345: --Everything successful here then go ahead and commit the updates
3346: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully processed loan ' || l_LOAN_NUMBER);
3347: l_succeed_count := l_succeed_count + 1;
3348:
3349: EXCEPTION
3350: WHEN OTHERS THEN

Line 3352: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to process loan ' || l_LOAN_NUMBER || '. ERROR: ' || sqlerrm);

3348:
3349: EXCEPTION
3350: WHEN OTHERS THEN
3351: l_failed_count := l_failed_count + 1;
3352: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to process loan ' || l_LOAN_NUMBER || '. ERROR: ' || sqlerrm);
3353: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
3354: status => 'WARNING',
3355: message => 'Not all amortization schedules exported successfully. Please review log file.');
3356: END;

Line 3359: LogMessage(FND_LOG.LEVEL_STATEMENT, 'End time: ' || to_char(l_end1, 'DD-MON-YYYY HH24:MI:SS'));

3355: message => 'Not all amortization schedules exported successfully. Please review log file.');
3356: END;
3357:
3358: l_end1 := sysdate;
3359: LogMessage(FND_LOG.LEVEL_STATEMENT, 'End time: ' || to_char(l_end1, 'DD-MON-YYYY HH24:MI:SS'));
3360: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Loan processing time: ' || round((l_end1 - l_start1)*86400, 2) || ' sec');
3361: COMMIT WORK;
3362:
3363: END LOOP;

Line 3360: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Loan processing time: ' || round((l_end1 - l_start1)*86400, 2) || ' sec');

3356: END;
3357:
3358: l_end1 := sysdate;
3359: LogMessage(FND_LOG.LEVEL_STATEMENT, 'End time: ' || to_char(l_end1, 'DD-MON-YYYY HH24:MI:SS'));
3360: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Loan processing time: ' || round((l_end1 - l_start1)*86400, 2) || ' sec');
3361: COMMIT WORK;
3362:
3363: END LOOP;
3364:

Line 3367: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '______________');

3363: END LOOP;
3364:
3365: close l_cursor;
3366:
3367: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '______________');
3368: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed loans: ' || l_failed_count);
3369: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Succeeded loans: ' || l_succeed_count);
3370: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed loans: ' || l_count);
3371:

Line 3368: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed loans: ' || l_failed_count);

3364:
3365: close l_cursor;
3366:
3367: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '______________');
3368: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed loans: ' || l_failed_count);
3369: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Succeeded loans: ' || l_succeed_count);
3370: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed loans: ' || l_count);
3371:
3372: l_end := sysdate;

Line 3369: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Succeeded loans: ' || l_succeed_count);

3365: close l_cursor;
3366:
3367: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '______________');
3368: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed loans: ' || l_failed_count);
3369: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Succeeded loans: ' || l_succeed_count);
3370: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed loans: ' || l_count);
3371:
3372: l_end := sysdate;
3373: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'End time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));

Line 3370: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed loans: ' || l_count);

3366:
3367: LogMessage(FND_LOG.LEVEL_UNEXPECTED, '______________');
3368: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed loans: ' || l_failed_count);
3369: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Succeeded loans: ' || l_succeed_count);
3370: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed loans: ' || l_count);
3371:
3372: l_end := sysdate;
3373: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'End time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));
3374: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');

Line 3373: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'End time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));

3369: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Succeeded loans: ' || l_succeed_count);
3370: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed loans: ' || l_count);
3371:
3372: l_end := sysdate;
3373: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'End time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));
3374: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');
3375:
3376: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
3377:

Line 3374: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');

3370: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed loans: ' || l_count);
3371:
3372: l_end := sysdate;
3373: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'End time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));
3374: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');
3375:
3376: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
3377:
3378: EXCEPTION

Line 3376: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

3372: l_end := sysdate;
3373: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'End time: ' || to_char(l_end, 'DD-MON-YYYY HH24:MI:SS'));
3374: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processing time: ' || round((l_end - l_start)*86400, 2) || ' sec');
3375:
3376: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
3377:
3378: EXCEPTION
3379: WHEN OTHERS THEN
3380: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to Export Loans Amortization Schedules. ERROR: ' || sqlerrm);

Line 3380: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to Export Loans Amortization Schedules. ERROR: ' || sqlerrm);

3376: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
3377:
3378: EXCEPTION
3379: WHEN OTHERS THEN
3380: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to Export Loans Amortization Schedules. ERROR: ' || sqlerrm);
3381: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(
3382: status => 'ERROR',
3383: message => 'Failed to Export Loans Amortization Schedules. Please review log file.');
3384:

Line 3391: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

3387:
3388:
3389: BEGIN
3390: G_LOG_ENABLED := 'N';
3391: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
3392:
3393: /* getting msg logging info */
3394: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
3395: if (G_LOG_ENABLED = 'N') then

Line 3396: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

3392:
3393: /* getting msg logging info */
3394: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
3395: if (G_LOG_ENABLED = 'N') then
3396: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
3397: else
3398: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
3399: end if;
3400:

Line 3398: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);

3394: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
3395: if (G_LOG_ENABLED = 'N') then
3396: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
3397: else
3398: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
3399: end if;
3400:
3401: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
3402: END LNS_REP_UTILS;

Line 3401: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);

3397: else
3398: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
3399: end if;
3400:
3401: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
3402: END LNS_REP_UTILS;