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.FV_CFS_PKG dependencies on FND_FILE

Line 1322: fnd_file.put_line(fnd_file.log, v_errbuf);

1318: v_end_period_1_end_date := to_date('01/01/1900', 'mm/dd/yyyy');
1319: ELSE
1320: v_retcode := -1;
1321: v_errbuf := 'When no data found error in get_one_time_values, at stage: '||l_stage;
1322: fnd_file.put_line(fnd_file.log, v_errbuf);
1323: RETURN;
1324: END IF;
1325: WHEN OTHERS THEN
1326: v_retcode := -1;

Line 1328: fnd_file.put_line(fnd_file.log, v_errbuf);

1324: END IF;
1325: WHEN OTHERS THEN
1326: v_retcode := -1;
1327: v_errbuf := 'When others error in get_one_time_values, at stage: '||l_stage;
1328: fnd_file.put_line(fnd_file.log, v_errbuf);
1329: END get_one_time_values;
1330: -- =============================================================
1331: PROCEDURE process_detail_line
1332: IS

Line 1504: fnd_file.put_line(fnd_file.log, 'Warning: Accounting Flexfield - '||l_conc_segs||' needs further definition.');

1500: INTO l_conc_segs
1501: FROM dual;
1502: IF detail_rec.flex_further_def = 'Y' THEN --- 1
1503: l_log_mesg := 'Accounting Flexfield -1' || l_conc_segs || ' ' || 'Flexfield Needs Further Definition.' ;
1504: fnd_file.put_line(fnd_file.log, 'Warning: Accounting Flexfield - '||l_conc_segs||' needs further definition.');
1505: v_retcode := 1;
1506: ELSE --- 1
1507: IF v_by_recipient = 'Y' THEN --- 2
1508: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_id',v_line_id);

Line 1616: fnd_file.put_line(fnd_file.log, l_log_mesg);

1612: with balance type Net Increase or Net Decrease but
1613: has a blank Natural Balance in the Report Definitions form.
1614: Please select Natural Balance for any line with a Balance Type
1615: of Net Increase or Net Decrease.';
1616: fnd_file.put_line(fnd_file.log, l_log_mesg);
1617: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, l_log_mesg);
1618: v_retcode := -1 ;
1619: v_errbuf := l_log_mesg;
1620: ROLLBACK;

Line 2014: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_1_amt);

2010: END LOOP;
2011: END IF;
2012: IF calc_rec.operator = '+' THEN
2013: amt_array(amt_array_cnt).col_1_amt := NVL(temp_amt_low1, 0) + NVL(temp_amt_high1, 0);
2014: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_1_amt);
2015: amt_array(amt_array_cnt).col_2_amt := NVL(temp_amt_low2, 0) + NVL(temp_amt_high2, 0);
2016: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_2_amt);
2017: amt_array(amt_array_cnt).col_3_amt := NVL(temp_amt_low3, 0) + NVL(temp_amt_high3, 0);
2018: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);

Line 2016: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_2_amt);

2012: IF calc_rec.operator = '+' THEN
2013: amt_array(amt_array_cnt).col_1_amt := NVL(temp_amt_low1, 0) + NVL(temp_amt_high1, 0);
2014: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_1_amt);
2015: amt_array(amt_array_cnt).col_2_amt := NVL(temp_amt_low2, 0) + NVL(temp_amt_high2, 0);
2016: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_2_amt);
2017: amt_array(amt_array_cnt).col_3_amt := NVL(temp_amt_low3, 0) + NVL(temp_amt_high3, 0);
2018: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);
2019: amt_array(amt_array_cnt).col_4_amt := NVL(temp_amt_low4, 0) + NVL(temp_amt_high4, 0);
2020: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);

Line 2018: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);

2014: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_1_amt);
2015: amt_array(amt_array_cnt).col_2_amt := NVL(temp_amt_low2, 0) + NVL(temp_amt_high2, 0);
2016: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_2_amt);
2017: amt_array(amt_array_cnt).col_3_amt := NVL(temp_amt_low3, 0) + NVL(temp_amt_high3, 0);
2018: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);
2019: amt_array(amt_array_cnt).col_4_amt := NVL(temp_amt_low4, 0) + NVL(temp_amt_high4, 0);
2020: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);
2021: amt_array(amt_array_cnt).col_5_amt := NVL(temp_amt_low5, 0) + NVL(temp_amt_high5, 0);
2022: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_5_amt);

Line 2020: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);

2016: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_2_amt);
2017: amt_array(amt_array_cnt).col_3_amt := NVL(temp_amt_low3, 0) + NVL(temp_amt_high3, 0);
2018: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);
2019: amt_array(amt_array_cnt).col_4_amt := NVL(temp_amt_low4, 0) + NVL(temp_amt_high4, 0);
2020: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);
2021: amt_array(amt_array_cnt).col_5_amt := NVL(temp_amt_low5, 0) + NVL(temp_amt_high5, 0);
2022: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_5_amt);
2023: amt_array(amt_array_cnt).col_6_amt := NVL(temp_amt_low6, 0) + NVL(temp_amt_high6, 0);
2024: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_6_amt);

Line 2022: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_5_amt);

2018: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);
2019: amt_array(amt_array_cnt).col_4_amt := NVL(temp_amt_low4, 0) + NVL(temp_amt_high4, 0);
2020: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);
2021: amt_array(amt_array_cnt).col_5_amt := NVL(temp_amt_low5, 0) + NVL(temp_amt_high5, 0);
2022: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_5_amt);
2023: amt_array(amt_array_cnt).col_6_amt := NVL(temp_amt_low6, 0) + NVL(temp_amt_high6, 0);
2024: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_6_amt);
2025: amt_array(amt_array_cnt).col_7_amt := NVL(temp_amt_low7, 0) + NVL(temp_amt_high7, 0);
2026: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_7_amt);

Line 2024: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_6_amt);

2020: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);
2021: amt_array(amt_array_cnt).col_5_amt := NVL(temp_amt_low5, 0) + NVL(temp_amt_high5, 0);
2022: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_5_amt);
2023: amt_array(amt_array_cnt).col_6_amt := NVL(temp_amt_low6, 0) + NVL(temp_amt_high6, 0);
2024: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_6_amt);
2025: amt_array(amt_array_cnt).col_7_amt := NVL(temp_amt_low7, 0) + NVL(temp_amt_high7, 0);
2026: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_7_amt);
2027: amt_array(amt_array_cnt).col_8_amt := NVL(temp_amt_low8, 0) + NVL(temp_amt_high8, 0);
2028: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_8_amt);

Line 2026: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_7_amt);

2022: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_5_amt);
2023: amt_array(amt_array_cnt).col_6_amt := NVL(temp_amt_low6, 0) + NVL(temp_amt_high6, 0);
2024: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_6_amt);
2025: amt_array(amt_array_cnt).col_7_amt := NVL(temp_amt_low7, 0) + NVL(temp_amt_high7, 0);
2026: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_7_amt);
2027: amt_array(amt_array_cnt).col_8_amt := NVL(temp_amt_low8, 0) + NVL(temp_amt_high8, 0);
2028: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_8_amt);
2029:
2030: ELSIF calc_rec.operator = '-' THEN

Line 2028: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_8_amt);

2024: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_6_amt);
2025: amt_array(amt_array_cnt).col_7_amt := NVL(temp_amt_low7, 0) + NVL(temp_amt_high7, 0);
2026: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_7_amt);
2027: amt_array(amt_array_cnt).col_8_amt := NVL(temp_amt_low8, 0) + NVL(temp_amt_high8, 0);
2028: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_8_amt);
2029:
2030: ELSIF calc_rec.operator = '-' THEN
2031: amt_array(amt_array_cnt).col_1_amt := NVL(temp_amt_low1, 0) - NVL(temp_amt_high1, 0);
2032: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_1_amt);

Line 2032: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_1_amt);

2028: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_8_amt);
2029:
2030: ELSIF calc_rec.operator = '-' THEN
2031: amt_array(amt_array_cnt).col_1_amt := NVL(temp_amt_low1, 0) - NVL(temp_amt_high1, 0);
2032: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_1_amt);
2033: amt_array(amt_array_cnt).col_2_amt := NVL(temp_amt_low2, 0) - NVL(temp_amt_high2, 0);
2034: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_2_amt);
2035: amt_array(amt_array_cnt).col_3_amt := NVL(temp_amt_low3, 0) - NVL(temp_amt_high3, 0);
2036: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);

Line 2034: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_2_amt);

2030: ELSIF calc_rec.operator = '-' THEN
2031: amt_array(amt_array_cnt).col_1_amt := NVL(temp_amt_low1, 0) - NVL(temp_amt_high1, 0);
2032: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_1_amt);
2033: amt_array(amt_array_cnt).col_2_amt := NVL(temp_amt_low2, 0) - NVL(temp_amt_high2, 0);
2034: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_2_amt);
2035: amt_array(amt_array_cnt).col_3_amt := NVL(temp_amt_low3, 0) - NVL(temp_amt_high3, 0);
2036: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);
2037: amt_array(amt_array_cnt).col_4_amt := NVL(temp_amt_low4, 0) - NVL(temp_amt_high4, 0);
2038: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);

Line 2036: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);

2032: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_1_amt);
2033: amt_array(amt_array_cnt).col_2_amt := NVL(temp_amt_low2, 0) - NVL(temp_amt_high2, 0);
2034: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_2_amt);
2035: amt_array(amt_array_cnt).col_3_amt := NVL(temp_amt_low3, 0) - NVL(temp_amt_high3, 0);
2036: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);
2037: amt_array(amt_array_cnt).col_4_amt := NVL(temp_amt_low4, 0) - NVL(temp_amt_high4, 0);
2038: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);
2039: amt_array(amt_array_cnt).col_5_amt := NVL(temp_amt_low5, 0) - NVL(temp_amt_high5, 0);
2040: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_5_amt);

Line 2038: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);

2034: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_2_amt);
2035: amt_array(amt_array_cnt).col_3_amt := NVL(temp_amt_low3, 0) - NVL(temp_amt_high3, 0);
2036: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);
2037: amt_array(amt_array_cnt).col_4_amt := NVL(temp_amt_low4, 0) - NVL(temp_amt_high4, 0);
2038: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);
2039: amt_array(amt_array_cnt).col_5_amt := NVL(temp_amt_low5, 0) - NVL(temp_amt_high5, 0);
2040: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_5_amt);
2041: amt_array(amt_array_cnt).col_6_amt := NVL(temp_amt_low6, 0) - NVL(temp_amt_high6, 0);
2042: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_6_amt);

Line 2040: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_5_amt);

2036: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);
2037: amt_array(amt_array_cnt).col_4_amt := NVL(temp_amt_low4, 0) - NVL(temp_amt_high4, 0);
2038: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);
2039: amt_array(amt_array_cnt).col_5_amt := NVL(temp_amt_low5, 0) - NVL(temp_amt_high5, 0);
2040: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_5_amt);
2041: amt_array(amt_array_cnt).col_6_amt := NVL(temp_amt_low6, 0) - NVL(temp_amt_high6, 0);
2042: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_6_amt);
2043: amt_array(amt_array_cnt).col_7_amt := NVL(temp_amt_low7, 0) - NVL(temp_amt_high7, 0);
2044: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_7_amt);

Line 2042: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_6_amt);

2038: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);
2039: amt_array(amt_array_cnt).col_5_amt := NVL(temp_amt_low5, 0) - NVL(temp_amt_high5, 0);
2040: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_5_amt);
2041: amt_array(amt_array_cnt).col_6_amt := NVL(temp_amt_low6, 0) - NVL(temp_amt_high6, 0);
2042: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_6_amt);
2043: amt_array(amt_array_cnt).col_7_amt := NVL(temp_amt_low7, 0) - NVL(temp_amt_high7, 0);
2044: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_7_amt);
2045: amt_array(amt_array_cnt).col_8_amt := NVL(temp_amt_low8, 0) - NVL(temp_amt_high8, 0);
2046: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_8_amt);

Line 2044: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_7_amt);

2040: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_5_amt);
2041: amt_array(amt_array_cnt).col_6_amt := NVL(temp_amt_low6, 0) - NVL(temp_amt_high6, 0);
2042: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_6_amt);
2043: amt_array(amt_array_cnt).col_7_amt := NVL(temp_amt_low7, 0) - NVL(temp_amt_high7, 0);
2044: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_7_amt);
2045: amt_array(amt_array_cnt).col_8_amt := NVL(temp_amt_low8, 0) - NVL(temp_amt_high8, 0);
2046: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_8_amt);
2047:
2048: ELSE

Line 2046: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_8_amt);

2042: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_6_amt);
2043: amt_array(amt_array_cnt).col_7_amt := NVL(temp_amt_low7, 0) - NVL(temp_amt_high7, 0);
2044: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_7_amt);
2045: amt_array(amt_array_cnt).col_8_amt := NVL(temp_amt_low8, 0) - NVL(temp_amt_high8, 0);
2046: fnd_file.put_line(fnd_file.log, 'TestMod'||'Begin '|| amt_array(amt_array_cnt).col_8_amt);
2047:
2048: ELSE
2049: IF calc_rec.line_low_type = 'L' THEN
2050: FOR lines_rec IN fv_cfs_lines_cur(calc_rec.line_low, calc_rec.line_high)

Line 2263: fnd_file.put_line(fnd_file.log, 'TestMod col_1_amt '||'Begin '|| amt_array(amt_array_cnt).col_1_amt);

2259: END LOOP;
2260: END IF;
2261: IF calc_rec.operator = '+' THEN
2262: amt_array(amt_array_cnt).col_1_amt := NVL(temp_amt_low1, 0) + NVL(temp_amt_high1, 0);
2263: fnd_file.put_line(fnd_file.log, 'TestMod col_1_amt '||'Begin '|| amt_array(amt_array_cnt).col_1_amt);
2264: amt_array(amt_array_cnt).col_2_amt := NVL(temp_amt_low2, 0) + NVL(temp_amt_high2, 0);
2265: fnd_file.put_line(fnd_file.log, 'TestMod col_2_amt '||'Begin '|| amt_array(amt_array_cnt).col_2_amt);
2266: amt_array(amt_array_cnt).col_3_amt := NVL(temp_amt_low3, 0) + NVL(temp_amt_high3, 0);
2267: fnd_file.put_line(fnd_file.log, 'TestMod col_3_amt'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);

Line 2265: fnd_file.put_line(fnd_file.log, 'TestMod col_2_amt '||'Begin '|| amt_array(amt_array_cnt).col_2_amt);

2261: IF calc_rec.operator = '+' THEN
2262: amt_array(amt_array_cnt).col_1_amt := NVL(temp_amt_low1, 0) + NVL(temp_amt_high1, 0);
2263: fnd_file.put_line(fnd_file.log, 'TestMod col_1_amt '||'Begin '|| amt_array(amt_array_cnt).col_1_amt);
2264: amt_array(amt_array_cnt).col_2_amt := NVL(temp_amt_low2, 0) + NVL(temp_amt_high2, 0);
2265: fnd_file.put_line(fnd_file.log, 'TestMod col_2_amt '||'Begin '|| amt_array(amt_array_cnt).col_2_amt);
2266: amt_array(amt_array_cnt).col_3_amt := NVL(temp_amt_low3, 0) + NVL(temp_amt_high3, 0);
2267: fnd_file.put_line(fnd_file.log, 'TestMod col_3_amt'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);
2268: amt_array(amt_array_cnt).col_4_amt := NVL(temp_amt_low4, 0) + NVL(temp_amt_high4, 0);
2269: fnd_file.put_line(fnd_file.log, 'TestMod col_4_amt'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);

Line 2267: fnd_file.put_line(fnd_file.log, 'TestMod col_3_amt'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);

2263: fnd_file.put_line(fnd_file.log, 'TestMod col_1_amt '||'Begin '|| amt_array(amt_array_cnt).col_1_amt);
2264: amt_array(amt_array_cnt).col_2_amt := NVL(temp_amt_low2, 0) + NVL(temp_amt_high2, 0);
2265: fnd_file.put_line(fnd_file.log, 'TestMod col_2_amt '||'Begin '|| amt_array(amt_array_cnt).col_2_amt);
2266: amt_array(amt_array_cnt).col_3_amt := NVL(temp_amt_low3, 0) + NVL(temp_amt_high3, 0);
2267: fnd_file.put_line(fnd_file.log, 'TestMod col_3_amt'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);
2268: amt_array(amt_array_cnt).col_4_amt := NVL(temp_amt_low4, 0) + NVL(temp_amt_high4, 0);
2269: fnd_file.put_line(fnd_file.log, 'TestMod col_4_amt'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);
2270: ELSIF calc_rec.operator = '-' THEN
2271: amt_array(amt_array_cnt).col_1_amt := NVL(temp_amt_low1, 0) - NVL(temp_amt_high1, 0);

Line 2269: fnd_file.put_line(fnd_file.log, 'TestMod col_4_amt'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);

2265: fnd_file.put_line(fnd_file.log, 'TestMod col_2_amt '||'Begin '|| amt_array(amt_array_cnt).col_2_amt);
2266: amt_array(amt_array_cnt).col_3_amt := NVL(temp_amt_low3, 0) + NVL(temp_amt_high3, 0);
2267: fnd_file.put_line(fnd_file.log, 'TestMod col_3_amt'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);
2268: amt_array(amt_array_cnt).col_4_amt := NVL(temp_amt_low4, 0) + NVL(temp_amt_high4, 0);
2269: fnd_file.put_line(fnd_file.log, 'TestMod col_4_amt'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);
2270: ELSIF calc_rec.operator = '-' THEN
2271: amt_array(amt_array_cnt).col_1_amt := NVL(temp_amt_low1, 0) - NVL(temp_amt_high1, 0);
2272: fnd_file.put_line(fnd_file.log, 'TestMod col_1_amt'||'Begin '|| amt_array(amt_array_cnt).col_1_amt);
2273: amt_array(amt_array_cnt).col_2_amt := NVL(temp_amt_low2, 0) - NVL(temp_amt_high2, 0);

Line 2272: fnd_file.put_line(fnd_file.log, 'TestMod col_1_amt'||'Begin '|| amt_array(amt_array_cnt).col_1_amt);

2268: amt_array(amt_array_cnt).col_4_amt := NVL(temp_amt_low4, 0) + NVL(temp_amt_high4, 0);
2269: fnd_file.put_line(fnd_file.log, 'TestMod col_4_amt'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);
2270: ELSIF calc_rec.operator = '-' THEN
2271: amt_array(amt_array_cnt).col_1_amt := NVL(temp_amt_low1, 0) - NVL(temp_amt_high1, 0);
2272: fnd_file.put_line(fnd_file.log, 'TestMod col_1_amt'||'Begin '|| amt_array(amt_array_cnt).col_1_amt);
2273: amt_array(amt_array_cnt).col_2_amt := NVL(temp_amt_low2, 0) - NVL(temp_amt_high2, 0);
2274: fnd_file.put_line(fnd_file.log, 'TestMod col_2_amt'||'Begin '|| amt_array(amt_array_cnt).col_2_amt);
2275: amt_array(amt_array_cnt).col_3_amt := NVL(temp_amt_low3, 0) - NVL(temp_amt_high3, 0);
2276: fnd_file.put_line(fnd_file.log, 'TestMod col_3_amt'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);

Line 2274: fnd_file.put_line(fnd_file.log, 'TestMod col_2_amt'||'Begin '|| amt_array(amt_array_cnt).col_2_amt);

2270: ELSIF calc_rec.operator = '-' THEN
2271: amt_array(amt_array_cnt).col_1_amt := NVL(temp_amt_low1, 0) - NVL(temp_amt_high1, 0);
2272: fnd_file.put_line(fnd_file.log, 'TestMod col_1_amt'||'Begin '|| amt_array(amt_array_cnt).col_1_amt);
2273: amt_array(amt_array_cnt).col_2_amt := NVL(temp_amt_low2, 0) - NVL(temp_amt_high2, 0);
2274: fnd_file.put_line(fnd_file.log, 'TestMod col_2_amt'||'Begin '|| amt_array(amt_array_cnt).col_2_amt);
2275: amt_array(amt_array_cnt).col_3_amt := NVL(temp_amt_low3, 0) - NVL(temp_amt_high3, 0);
2276: fnd_file.put_line(fnd_file.log, 'TestMod col_3_amt'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);
2277: amt_array(amt_array_cnt).col_4_amt := NVL(temp_amt_low4, 0) - NVL(temp_amt_high4, 0);
2278: fnd_file.put_line(fnd_file.log, 'TestMod col_4_amt'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);

Line 2276: fnd_file.put_line(fnd_file.log, 'TestMod col_3_amt'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);

2272: fnd_file.put_line(fnd_file.log, 'TestMod col_1_amt'||'Begin '|| amt_array(amt_array_cnt).col_1_amt);
2273: amt_array(amt_array_cnt).col_2_amt := NVL(temp_amt_low2, 0) - NVL(temp_amt_high2, 0);
2274: fnd_file.put_line(fnd_file.log, 'TestMod col_2_amt'||'Begin '|| amt_array(amt_array_cnt).col_2_amt);
2275: amt_array(amt_array_cnt).col_3_amt := NVL(temp_amt_low3, 0) - NVL(temp_amt_high3, 0);
2276: fnd_file.put_line(fnd_file.log, 'TestMod col_3_amt'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);
2277: amt_array(amt_array_cnt).col_4_amt := NVL(temp_amt_low4, 0) - NVL(temp_amt_high4, 0);
2278: fnd_file.put_line(fnd_file.log, 'TestMod col_4_amt'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);
2279: ELSE
2280: IF calc_rec.line_low_type = 'L' THEN

Line 2278: fnd_file.put_line(fnd_file.log, 'TestMod col_4_amt'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);

2274: fnd_file.put_line(fnd_file.log, 'TestMod col_2_amt'||'Begin '|| amt_array(amt_array_cnt).col_2_amt);
2275: amt_array(amt_array_cnt).col_3_amt := NVL(temp_amt_low3, 0) - NVL(temp_amt_high3, 0);
2276: fnd_file.put_line(fnd_file.log, 'TestMod col_3_amt'||'Begin '|| amt_array(amt_array_cnt).col_3_amt);
2277: amt_array(amt_array_cnt).col_4_amt := NVL(temp_amt_low4, 0) - NVL(temp_amt_high4, 0);
2278: fnd_file.put_line(fnd_file.log, 'TestMod col_4_amt'||'Begin '|| amt_array(amt_array_cnt).col_4_amt);
2279: ELSE
2280: IF calc_rec.line_low_type = 'L' THEN
2281: FOR lines_rec IN fv_sbr_lines_cur(calc_rec.line_low, calc_rec.line_high)
2282: LOOP

Line 2309: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_1_amt-> '|| v_col_1_amt);

2305: v_col_1_amt := amt_array(amt_array_cnt - 1).col_1_amt;
2306: v_col_2_amt := amt_array(amt_array_cnt - 1).col_2_amt;
2307: v_col_3_amt := amt_array(amt_array_cnt - 1).col_3_amt;
2308: v_col_4_amt := amt_array(amt_array_cnt - 1).col_4_amt;
2309: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_1_amt-> '|| v_col_1_amt);
2310: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_2_amt-> '|| v_col_2_amt);
2311: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_3_amt-> '|| v_col_3_amt);
2312: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_4_amt-> '|| v_col_4_amt);
2313: populate_temp_table;

Line 2310: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_2_amt-> '|| v_col_2_amt);

2306: v_col_2_amt := amt_array(amt_array_cnt - 1).col_2_amt;
2307: v_col_3_amt := amt_array(amt_array_cnt - 1).col_3_amt;
2308: v_col_4_amt := amt_array(amt_array_cnt - 1).col_4_amt;
2309: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_1_amt-> '|| v_col_1_amt);
2310: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_2_amt-> '|| v_col_2_amt);
2311: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_3_amt-> '|| v_col_3_amt);
2312: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_4_amt-> '|| v_col_4_amt);
2313: populate_temp_table;
2314: EXCEPTION

Line 2311: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_3_amt-> '|| v_col_3_amt);

2307: v_col_3_amt := amt_array(amt_array_cnt - 1).col_3_amt;
2308: v_col_4_amt := amt_array(amt_array_cnt - 1).col_4_amt;
2309: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_1_amt-> '|| v_col_1_amt);
2310: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_2_amt-> '|| v_col_2_amt);
2311: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_3_amt-> '|| v_col_3_amt);
2312: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_4_amt-> '|| v_col_4_amt);
2313: populate_temp_table;
2314: EXCEPTION
2315: WHEN OTHERS THEN

Line 2312: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_4_amt-> '|| v_col_4_amt);

2308: v_col_4_amt := amt_array(amt_array_cnt - 1).col_4_amt;
2309: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_1_amt-> '|| v_col_1_amt);
2310: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_2_amt-> '|| v_col_2_amt);
2311: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_3_amt-> '|| v_col_3_amt);
2312: fnd_file.put_line(fnd_file.log, 'Before populate tables -> '||'v_col_4_amt-> '|| v_col_4_amt);
2313: populate_temp_table;
2314: EXCEPTION
2315: WHEN OTHERS THEN
2316: v_retcode := SQLCODE ;

Line 2505: fnd_file.put_line

2501: v_report_type,
2502: v_sob
2503: );
2504: END IF;
2505: fnd_file.put_line
2506: (
2507: fnd_file.log, 'TestMod'||'insert '|| ROUND(v_col_1_amt/v_units) ||' '|| ROUND(v_col_2_amt/v_units) ||' ' || ROUND(v_col_3_amt/v_units) ||' '|| ROUND(v_col_4_amt/v_units)
2508: ||' '||ROUND(v_col_5_amt/v_units) ||' '|| ROUND(v_col_6_amt/v_units) ||' ' || ROUND(v_col_7_amt/v_units) ||' '|| ROUND(v_col_8_amt/v_units)
2509: )

Line 2507: fnd_file.log, 'TestMod'||'insert '|| ROUND(v_col_1_amt/v_units) ||' '|| ROUND(v_col_2_amt/v_units) ||' ' || ROUND(v_col_3_amt/v_units) ||' '|| ROUND(v_col_4_amt/v_units)

2503: );
2504: END IF;
2505: fnd_file.put_line
2506: (
2507: fnd_file.log, 'TestMod'||'insert '|| ROUND(v_col_1_amt/v_units) ||' '|| ROUND(v_col_2_amt/v_units) ||' ' || ROUND(v_col_3_amt/v_units) ||' '|| ROUND(v_col_4_amt/v_units)
2508: ||' '||ROUND(v_col_5_amt/v_units) ||' '|| ROUND(v_col_6_amt/v_units) ||' ' || ROUND(v_col_7_amt/v_units) ||' '|| ROUND(v_col_8_amt/v_units)
2509: )
2510: ;
2511: ELSE

Line 2550: fnd_file.put_line

2546: v_report_type,
2547: v_sob
2548: );
2549:
2550: fnd_file.put_line
2551: (
2552: fnd_file.log, 'TestMod'||'insert '|| v_col_1_amt ||' '|| v_col_2_amt ||' ' || v_col_3_amt||' '|| v_col_4_amt
2553: || v_col_5_amt ||' '|| v_col_6_amt ||' ' || v_col_7_amt||' '|| v_col_8_amt
2554: )

Line 2552: fnd_file.log, 'TestMod'||'insert '|| v_col_1_amt ||' '|| v_col_2_amt ||' ' || v_col_3_amt||' '|| v_col_4_amt

2548: );
2549:
2550: fnd_file.put_line
2551: (
2552: fnd_file.log, 'TestMod'||'insert '|| v_col_1_amt ||' '|| v_col_2_amt ||' ' || v_col_3_amt||' '|| v_col_4_amt
2553: || v_col_5_amt ||' '|| v_col_6_amt ||' ' || v_col_7_amt||' '|| v_col_8_amt
2554: )
2555: ;
2556: END IF;

Line 2564: fnd_file.put_line

2560: UPDATE fv_cfs_rep_temp SET col_4_amt = NVL(col_1_amt,0) + NVL(col_2_amt,0) - NVL(col_3_amt,0),
2561: col_8_amt = NVL(col_5_amt,0) + NVL(col_6_amt,0) - NVL(col_7_amt,0)
2562: WHERE sequence_id = v_sequence_id AND line_id = v_line_id;
2563:
2564: fnd_file.put_line
2565: (
2566: fnd_file.log, 'TestMod'||'UPDATE STATEMENT TO SET CONSOLIDATED TOTAL FOR SCNP '|| v_col_1_amt ||' '|| v_col_2_amt ||' ' || v_col_3_amt||' '|| v_col_4_amt
2567: || v_col_5_amt ||' '|| v_col_6_amt ||' ' || v_col_7_amt||' '|| v_col_8_amt
2568: );

Line 2566: fnd_file.log, 'TestMod'||'UPDATE STATEMENT TO SET CONSOLIDATED TOTAL FOR SCNP '|| v_col_1_amt ||' '|| v_col_2_amt ||' ' || v_col_3_amt||' '|| v_col_4_amt

2562: WHERE sequence_id = v_sequence_id AND line_id = v_line_id;
2563:
2564: fnd_file.put_line
2565: (
2566: fnd_file.log, 'TestMod'||'UPDATE STATEMENT TO SET CONSOLIDATED TOTAL FOR SCNP '|| v_col_1_amt ||' '|| v_col_2_amt ||' ' || v_col_3_amt||' '|| v_col_4_amt
2567: || v_col_5_amt ||' '|| v_col_6_amt ||' ' || v_col_7_amt||' '|| v_col_8_amt
2568: );
2569: END IF;
2570: