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_FINANCIALS dependencies on DBMS_XSLPROCESSOR

Line 11870: l_nl := dbms_xslprocessor.selectNodes(dbms_xmldom.makeNode(l_doc),'/LNSAGREEMENT/ROWSET/ROW/RATE_SCHEDULE/RATE_SCHEDULE_ROW');

11866: get_char2num_conv_chars(l_chars_to_replace, l_replace_chars);
11867:
11868: -- Get a list of all the RATE_SCHEDULE_ROW nodes in the document using the XPATH syntax.
11869: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Getting a list of all the RATE_SCHEDULE_ROW nodes...');
11870: l_nl := dbms_xslprocessor.selectNodes(dbms_xmldom.makeNode(l_doc),'/LNSAGREEMENT/ROWSET/ROW/RATE_SCHEDULE/RATE_SCHEDULE_ROW');
11871: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, ' ');
11872: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Rate schedule:');
11873: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'FROM TO RATE');
11874: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, '---- ---- ----');

Line 11882: dbms_xslprocessor.valueOf(l_n,'INSTALLMENT_FROM/text()',l_data);

11878: FOR cur_emp IN 0 .. dbms_xmldom.getLength(l_nl) - 1 LOOP
11879: l_n := dbms_xmldom.item(l_nl, cur_emp);
11880: i := i+1;
11881:
11882: dbms_xslprocessor.valueOf(l_n,'INSTALLMENT_FROM/text()',l_data);
11883: l_rate_schedule(i).BEGIN_INSTALLMENT_NUMBER := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11884: dbms_xslprocessor.valueOf(l_n,'INSTALLMENT_TO/text()',l_data);
11885: l_rate_schedule(i).END_INSTALLMENT_NUMBER := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11886: dbms_xslprocessor.valueOf(l_n,'INTEREST_RATE/text()',l_data);

Line 11884: dbms_xslprocessor.valueOf(l_n,'INSTALLMENT_TO/text()',l_data);

11880: i := i+1;
11881:
11882: dbms_xslprocessor.valueOf(l_n,'INSTALLMENT_FROM/text()',l_data);
11883: l_rate_schedule(i).BEGIN_INSTALLMENT_NUMBER := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11884: dbms_xslprocessor.valueOf(l_n,'INSTALLMENT_TO/text()',l_data);
11885: l_rate_schedule(i).END_INSTALLMENT_NUMBER := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11886: dbms_xslprocessor.valueOf(l_n,'INTEREST_RATE/text()',l_data);
11887: l_rate_schedule(i).ANNUAL_RATE := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11888:

Line 11886: dbms_xslprocessor.valueOf(l_n,'INTEREST_RATE/text()',l_data);

11882: dbms_xslprocessor.valueOf(l_n,'INSTALLMENT_FROM/text()',l_data);
11883: l_rate_schedule(i).BEGIN_INSTALLMENT_NUMBER := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11884: dbms_xslprocessor.valueOf(l_n,'INSTALLMENT_TO/text()',l_data);
11885: l_rate_schedule(i).END_INSTALLMENT_NUMBER := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11886: dbms_xslprocessor.valueOf(l_n,'INTEREST_RATE/text()',l_data);
11887: l_rate_schedule(i).ANNUAL_RATE := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11888:
11889: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME,
11890: l_rate_schedule(i).BEGIN_INSTALLMENT_NUMBER || ' ' ||

Line 11897: l_nl := dbms_xslprocessor.selectNodes(dbms_xmldom.makeNode(l_doc),'/LNSAGREEMENT/ROWSET/ROW/AMORTIZATION/AMORTIZATION_ROW');

11893: END LOOP;
11894:
11895: -- Get a list of all the AMORTIZATION_ROW nodes in the document using the XPATH syntax.
11896: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Getting a list of all the AMORTIZATION_ROW nodes...');
11897: l_nl := dbms_xslprocessor.selectNodes(dbms_xmldom.makeNode(l_doc),'/LNSAGREEMENT/ROWSET/ROW/AMORTIZATION/AMORTIZATION_ROW');
11898:
11899: -- Loop through the list and create a new record in a tble collection
11900: -- for each EMP record.
11901:

Line 11912: dbms_xslprocessor.valueOf(l_n,'PAYMENT_NUMBER/text()',l_data);

11908:
11909: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, ' ');
11910:
11911: -- Use XPATH syntax to assign values to he elements of the collection.
11912: dbms_xslprocessor.valueOf(l_n,'PAYMENT_NUMBER/text()',l_data);
11913: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_NUMBER data = ' || l_data);
11914: l_amort_tbl(i).INSTALLMENT_NUMBER := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11915:
11916: dbms_xslprocessor.valueOf(l_n,'DUE_DATE/text()',l_data);

Line 11916: dbms_xslprocessor.valueOf(l_n,'DUE_DATE/text()',l_data);

11912: dbms_xslprocessor.valueOf(l_n,'PAYMENT_NUMBER/text()',l_data);
11913: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_NUMBER data = ' || l_data);
11914: l_amort_tbl(i).INSTALLMENT_NUMBER := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11915:
11916: dbms_xslprocessor.valueOf(l_n,'DUE_DATE/text()',l_data);
11917: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DUE_DATE data = ' || l_data);
11918:
11919: if l_date_format is null then
11920: -- convert due date logic:

Line 11963: dbms_xslprocessor.valueOf(l_n,'PAYMENT_PRINCIPAL/text()',l_data);

11959: l_amort_tbl(i).DUE_DATE := to_date(l_data, l_date_format);
11960: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Due date is converted successfully');
11961: end if;
11962:
11963: dbms_xslprocessor.valueOf(l_n,'PAYMENT_PRINCIPAL/text()',l_data);
11964: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_PRINCIPAL data = ' || l_data);
11965: l_amort_tbl(i).PRINCIPAL_AMOUNT := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11966:
11967: dbms_xslprocessor.valueOf(l_n,'PAYMENT_INTEREST/text()',l_data);

Line 11967: dbms_xslprocessor.valueOf(l_n,'PAYMENT_INTEREST/text()',l_data);

11963: dbms_xslprocessor.valueOf(l_n,'PAYMENT_PRINCIPAL/text()',l_data);
11964: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_PRINCIPAL data = ' || l_data);
11965: l_amort_tbl(i).PRINCIPAL_AMOUNT := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11966:
11967: dbms_xslprocessor.valueOf(l_n,'PAYMENT_INTEREST/text()',l_data);
11968: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_INTEREST data = ' || l_data);
11969: l_amort_tbl(i).INTEREST_AMOUNT := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11970:
11971: dbms_xslprocessor.valueOf(l_n,'PAYMENT_FEES/text()',l_data);

Line 11971: dbms_xslprocessor.valueOf(l_n,'PAYMENT_FEES/text()',l_data);

11967: dbms_xslprocessor.valueOf(l_n,'PAYMENT_INTEREST/text()',l_data);
11968: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_INTEREST data = ' || l_data);
11969: l_amort_tbl(i).INTEREST_AMOUNT := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11970:
11971: dbms_xslprocessor.valueOf(l_n,'PAYMENT_FEES/text()',l_data);
11972: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_FEES data = ' || l_data);
11973: l_amort_tbl(i).FEE_AMOUNT := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11974:
11975: dbms_xslprocessor.valueOf(l_n,'OTHER_AMOUNT/text()',l_data);

Line 11975: dbms_xslprocessor.valueOf(l_n,'OTHER_AMOUNT/text()',l_data);

11971: dbms_xslprocessor.valueOf(l_n,'PAYMENT_FEES/text()',l_data);
11972: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_FEES data = ' || l_data);
11973: l_amort_tbl(i).FEE_AMOUNT := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11974:
11975: dbms_xslprocessor.valueOf(l_n,'OTHER_AMOUNT/text()',l_data);
11976: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'OTHER_AMOUNT data = ' || l_data);
11977: l_amort_tbl(i).OTHER_AMOUNT := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11978:
11979: dbms_xslprocessor.valueOf(l_n,'PAYMENT_TOTAL/text()',l_data);

Line 11979: dbms_xslprocessor.valueOf(l_n,'PAYMENT_TOTAL/text()',l_data);

11975: dbms_xslprocessor.valueOf(l_n,'OTHER_AMOUNT/text()',l_data);
11976: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'OTHER_AMOUNT data = ' || l_data);
11977: l_amort_tbl(i).OTHER_AMOUNT := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11978:
11979: dbms_xslprocessor.valueOf(l_n,'PAYMENT_TOTAL/text()',l_data);
11980: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_TOTAL data = ' || l_data);
11981: l_amort_tbl(i).TOTAL := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11982:
11983: dbms_xslprocessor.valueOf(l_n,'BEGINNING_BALANCE/text()',l_data);

Line 11983: dbms_xslprocessor.valueOf(l_n,'BEGINNING_BALANCE/text()',l_data);

11979: dbms_xslprocessor.valueOf(l_n,'PAYMENT_TOTAL/text()',l_data);
11980: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_TOTAL data = ' || l_data);
11981: l_amort_tbl(i).TOTAL := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11982:
11983: dbms_xslprocessor.valueOf(l_n,'BEGINNING_BALANCE/text()',l_data);
11984: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BEGINNING_BALANCE data = ' || l_data);
11985: l_amort_tbl(i).BEGIN_BALANCE := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11986:
11987: dbms_xslprocessor.valueOf(l_n,'ENDING_BALANCE/text()',l_data);

Line 11987: dbms_xslprocessor.valueOf(l_n,'ENDING_BALANCE/text()',l_data);

11983: dbms_xslprocessor.valueOf(l_n,'BEGINNING_BALANCE/text()',l_data);
11984: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'BEGINNING_BALANCE data = ' || l_data);
11985: l_amort_tbl(i).BEGIN_BALANCE := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11986:
11987: dbms_xslprocessor.valueOf(l_n,'ENDING_BALANCE/text()',l_data);
11988: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ENDING_BALANCE data = ' || l_data);
11989: l_amort_tbl(i).END_BALANCE := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11990:
11991: dbms_xslprocessor.valueOf(l_n,'INTEREST_CUMULATIVE/text()',l_data);

Line 11991: dbms_xslprocessor.valueOf(l_n,'INTEREST_CUMULATIVE/text()',l_data);

11987: dbms_xslprocessor.valueOf(l_n,'ENDING_BALANCE/text()',l_data);
11988: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ENDING_BALANCE data = ' || l_data);
11989: l_amort_tbl(i).END_BALANCE := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11990:
11991: dbms_xslprocessor.valueOf(l_n,'INTEREST_CUMULATIVE/text()',l_data);
11992: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'INTEREST_CUMULATIVE data = ' || l_data);
11993: l_amort_tbl(i).INTEREST_CUMULATIVE := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11994:
11995: dbms_xslprocessor.valueOf(l_n,'PRINCIPAL_CUMULATIVE/text()',l_data);

Line 11995: dbms_xslprocessor.valueOf(l_n,'PRINCIPAL_CUMULATIVE/text()',l_data);

11991: dbms_xslprocessor.valueOf(l_n,'INTEREST_CUMULATIVE/text()',l_data);
11992: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'INTEREST_CUMULATIVE data = ' || l_data);
11993: l_amort_tbl(i).INTEREST_CUMULATIVE := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11994:
11995: dbms_xslprocessor.valueOf(l_n,'PRINCIPAL_CUMULATIVE/text()',l_data);
11996: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PRINCIPAL_CUMULATIVE data = ' || l_data);
11997: l_amort_tbl(i).PRINCIPAL_CUMULATIVE := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11998:
11999: dbms_xslprocessor.valueOf(l_n,'FEES_CUMULATIVE/text()',l_data);

Line 11999: dbms_xslprocessor.valueOf(l_n,'FEES_CUMULATIVE/text()',l_data);

11995: dbms_xslprocessor.valueOf(l_n,'PRINCIPAL_CUMULATIVE/text()',l_data);
11996: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PRINCIPAL_CUMULATIVE data = ' || l_data);
11997: l_amort_tbl(i).PRINCIPAL_CUMULATIVE := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
11998:
11999: dbms_xslprocessor.valueOf(l_n,'FEES_CUMULATIVE/text()',l_data);
12000: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'FEES_CUMULATIVE data = ' || l_data);
12001: l_amort_tbl(i).FEES_CUMULATIVE := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
12002:
12003: dbms_xslprocessor.valueOf(l_n,'OTHER_CUMULATIVE/text()',l_data);

Line 12003: dbms_xslprocessor.valueOf(l_n,'OTHER_CUMULATIVE/text()',l_data);

11999: dbms_xslprocessor.valueOf(l_n,'FEES_CUMULATIVE/text()',l_data);
12000: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'FEES_CUMULATIVE data = ' || l_data);
12001: l_amort_tbl(i).FEES_CUMULATIVE := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
12002:
12003: dbms_xslprocessor.valueOf(l_n,'OTHER_CUMULATIVE/text()',l_data);
12004: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'OTHER_CUMULATIVE data = ' || l_data);
12005: l_amort_tbl(i).OTHER_CUMULATIVE := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
12006:
12007: dbms_xslprocessor.valueOf(l_n,'SOURCE/text()',l_data);

Line 12007: dbms_xslprocessor.valueOf(l_n,'SOURCE/text()',l_data);

12003: dbms_xslprocessor.valueOf(l_n,'OTHER_CUMULATIVE/text()',l_data);
12004: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'OTHER_CUMULATIVE data = ' || l_data);
12005: l_amort_tbl(i).OTHER_CUMULATIVE := to_number(nvl(translate(l_data, l_chars_to_replace, l_replace_chars), 0));
12006:
12007: dbms_xslprocessor.valueOf(l_n,'SOURCE/text()',l_data);
12008: l_amort_tbl(i).SOURCE := l_data;
12009:
12010: dbms_xslprocessor.valueOf(l_n,'NORMAL_INT_AMOUNT/text()',l_data);
12011: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'NORMAL_INT_AMOUNT data = ' || l_data);

Line 12010: dbms_xslprocessor.valueOf(l_n,'NORMAL_INT_AMOUNT/text()',l_data);

12006:
12007: dbms_xslprocessor.valueOf(l_n,'SOURCE/text()',l_data);
12008: l_amort_tbl(i).SOURCE := l_data;
12009:
12010: dbms_xslprocessor.valueOf(l_n,'NORMAL_INT_AMOUNT/text()',l_data);
12011: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'NORMAL_INT_AMOUNT data = ' || l_data);
12012: l_value := translate(l_data, l_chars_to_replace, l_replace_chars);
12013: if l_value is not null then
12014: l_amort_tbl(i).NORMAL_INT_AMOUNT := to_number(l_value);

Line 12020: dbms_xslprocessor.valueOf(l_n,'PREV_DEFERRED_INT_AMOUNT/text()',l_data);

12016: l_amort_tbl(i).NORMAL_INT_AMOUNT := l_amort_tbl(i).INTEREST_AMOUNT;
12017: end if;
12018: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'NORMAL_INT_AMOUNT = ' || l_amort_tbl(i).NORMAL_INT_AMOUNT);
12019:
12020: dbms_xslprocessor.valueOf(l_n,'PREV_DEFERRED_INT_AMOUNT/text()',l_data);
12021: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PREV_DEFERRED_INT_AMOUNT data = ' || l_data);
12022: l_value := translate(l_data, l_chars_to_replace, l_replace_chars);
12023: if l_value is not null then
12024: l_amort_tbl(i).PREV_DEFERRED_INT_AMOUNT := to_number(l_value);

Line 12030: dbms_xslprocessor.valueOf(l_n,'DEFERRED_INT_AMOUNT/text()',l_data);

12026: l_amort_tbl(i).PREV_DEFERRED_INT_AMOUNT := 0;
12027: end if;
12028: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PREV_DEFERRED_INT_AMOUNT = ' || l_amort_tbl(i).PREV_DEFERRED_INT_AMOUNT);
12029:
12030: dbms_xslprocessor.valueOf(l_n,'DEFERRED_INT_AMOUNT/text()',l_data);
12031: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DEFERRED_INT_AMOUNT data = ' || l_data);
12032: l_value := translate(l_data, l_chars_to_replace, l_replace_chars);
12033: if l_value is not null then
12034: l_amort_tbl(i).DEFERRED_INT_AMOUNT := to_number(l_value);

Line 12040: dbms_xslprocessor.valueOf(l_n,'PREV_CAP_INT_AMOUNT/text()',l_data);

12036: l_amort_tbl(i).DEFERRED_INT_AMOUNT := 0;
12037: end if;
12038: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DEFERRED_INT_AMOUNT = ' || l_amort_tbl(i).DEFERRED_INT_AMOUNT);
12039:
12040: dbms_xslprocessor.valueOf(l_n,'PREV_CAP_INT_AMOUNT/text()',l_data);
12041: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PREV_CAP_INT_AMOUNT data = ' || l_data);
12042: l_value := translate(l_data, l_chars_to_replace, l_replace_chars);
12043: if l_value is not null then
12044: l_amort_tbl(i).PREV_CAP_INT_AMOUNT := to_number(l_value);

Line 12050: dbms_xslprocessor.valueOf(l_n,'CURR_CAP_INT_AMOUNT/text()',l_data);

12046: l_amort_tbl(i).PREV_CAP_INT_AMOUNT := 0;
12047: end if;
12048: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PREV_CAP_INT_AMOUNT = ' || l_amort_tbl(i).PREV_CAP_INT_AMOUNT);
12049:
12050: dbms_xslprocessor.valueOf(l_n,'CURR_CAP_INT_AMOUNT/text()',l_data);
12051: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CURR_CAP_INT_AMOUNT data = ' || l_data);
12052: l_value := translate(l_data, l_chars_to_replace, l_replace_chars);
12053: if l_value is not null then
12054: l_amort_tbl(i).CURR_CAP_INT_AMOUNT := to_number(l_value);

Line 12060: dbms_xslprocessor.valueOf(l_n,'CAP_INT_AMOUNT/text()',l_data);

12056: l_amort_tbl(i).CURR_CAP_INT_AMOUNT := 0;
12057: end if;
12058: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CURR_CAP_INT_AMOUNT = ' || l_amort_tbl(i).CURR_CAP_INT_AMOUNT);
12059:
12060: dbms_xslprocessor.valueOf(l_n,'CAP_INT_AMOUNT/text()',l_data);
12061: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CAP_INT_AMOUNT data = ' || l_data);
12062: l_value := translate(l_data, l_chars_to_replace, l_replace_chars);
12063: if l_value is not null then
12064: l_amort_tbl(i).CAP_INT_AMOUNT := to_number(l_value);

Line 12070: dbms_xslprocessor.valueOf(l_n,'NORMAL_INT_DETAILS/text()',l_data);

12066: l_amort_tbl(i).CAP_INT_AMOUNT := 0;
12067: end if;
12068: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CAP_INT_AMOUNT = ' || l_amort_tbl(i).CAP_INT_AMOUNT);
12069:
12070: dbms_xslprocessor.valueOf(l_n,'NORMAL_INT_DETAILS/text()',l_data);
12071: l_amort_tbl(i).NORMAL_INT_DETAILS := l_data;
12072: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'NORMAL_INT_DETAILS = ' || l_amort_tbl(i).NORMAL_INT_DETAILS);
12073:
12074: dbms_xslprocessor.valueOf(l_n,'DEFERRED_INT_DETAILS/text()',l_data);

Line 12074: dbms_xslprocessor.valueOf(l_n,'DEFERRED_INT_DETAILS/text()',l_data);

12070: dbms_xslprocessor.valueOf(l_n,'NORMAL_INT_DETAILS/text()',l_data);
12071: l_amort_tbl(i).NORMAL_INT_DETAILS := l_data;
12072: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'NORMAL_INT_DETAILS = ' || l_amort_tbl(i).NORMAL_INT_DETAILS);
12073:
12074: dbms_xslprocessor.valueOf(l_n,'DEFERRED_INT_DETAILS/text()',l_data);
12075: l_amort_tbl(i).DEFERRED_INT_DETAILS := l_data;
12076: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DEFERRED_INT_DETAILS = ' || l_amort_tbl(i).DEFERRED_INT_DETAILS);
12077:
12078: dbms_xslprocessor.valueOf(l_n,'CAP_INT_DETAILS/text()',l_data);

Line 12078: dbms_xslprocessor.valueOf(l_n,'CAP_INT_DETAILS/text()',l_data);

12074: dbms_xslprocessor.valueOf(l_n,'DEFERRED_INT_DETAILS/text()',l_data);
12075: l_amort_tbl(i).DEFERRED_INT_DETAILS := l_data;
12076: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DEFERRED_INT_DETAILS = ' || l_amort_tbl(i).DEFERRED_INT_DETAILS);
12077:
12078: dbms_xslprocessor.valueOf(l_n,'CAP_INT_DETAILS/text()',l_data);
12079: l_amort_tbl(i).CAP_INT_DETAILS := l_data;
12080: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CAP_INT_DETAILS = ' || l_amort_tbl(i).CAP_INT_DETAILS);
12081:
12082: dbms_xslprocessor.valueOf(l_n,'DISBURSEMENT_AMOUNT/text()',l_data);

Line 12082: dbms_xslprocessor.valueOf(l_n,'DISBURSEMENT_AMOUNT/text()',l_data);

12078: dbms_xslprocessor.valueOf(l_n,'CAP_INT_DETAILS/text()',l_data);
12079: l_amort_tbl(i).CAP_INT_DETAILS := l_data;
12080: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'CAP_INT_DETAILS = ' || l_amort_tbl(i).CAP_INT_DETAILS);
12081:
12082: dbms_xslprocessor.valueOf(l_n,'DISBURSEMENT_AMOUNT/text()',l_data);
12083: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'DISBURSEMENT_AMOUNT data = ' || l_data);
12084: l_value := translate(l_data, l_chars_to_replace, l_replace_chars);
12085: if l_value is not null then
12086: l_amort_tbl(i).DISBURSEMENT_AMOUNT := to_number(l_value);