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.FII_RECONVERSION_PKG dependencies on FII_RECONVERSION_PKG

Line 1: PACKAGE BODY FII_RECONVERSION_PKG AS

1: PACKAGE BODY FII_RECONVERSION_PKG AS
2: /* $Header: FIICRECB.pls 120.2 2005/10/14 18:21:44 lpoon noship $ */
3:
4: g_page_line_no NUMBER := 65;
5: INVALID_SETUP EXCEPTION;

Line 81: NULL, 'FII_RECONVERSION_PKG');

77: -- 1.1 Initialize the logging
78: --
79: FII_UTIL.initialize(p_log_filename || '.log',
80: p_output_filename || '.out',
81: NULL, 'FII_RECONVERSION_PKG');
82: -- LOG: Function enter
83: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
84:
85: -- LOG: List all passed parameters

Line 83: FII_RECONVERSION_PKG.func_enter(l_procedure_name);

79: FII_UTIL.initialize(p_log_filename || '.log',
80: p_output_filename || '.out',
81: NULL, 'FII_RECONVERSION_PKG');
82: -- LOG: Function enter
83: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
84:
85: -- LOG: List all passed parameters
86: l_process_step := 'LOG_LIST_PARAMS';
87: FII_UTIL.put_line(' ');

Line 415: l_caching_status := FII_RECONVERSION_PKG.cache_rates(

411: -- ===========================
412: -- 2. Cache reconversion rates
413: -- ===========================
414: l_process_step := 'CACHE_RATES';
415: l_caching_status := FII_RECONVERSION_PKG.cache_rates(
416: l_conc_req_id, l_gl_name, l_ap_name, l_ar_name
417: , l_primary_currency, p_primary_rate_type
418: , l_secondary_currency, p_secondary_rate_type
419: , l_reconv_gl_flag, l_reconv_ap_flag, l_reconv_ar_flag

Line 672: FII_RECONVERSION_PKG.print_report( l_conc_req_id

668: -- LOG: FII_RECONV_PRINT_RPT_STEP || time stamp
669: FII_UTIL.put_line(' ');
670: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
671: 'FII_RECONV_PRINT_RPT_STEP', NULL));
672: FII_RECONVERSION_PKG.print_report( l_conc_req_id
673: , p_transaction_type
674: , p_currency_type
675: , p_primary_rate_type
676: , p_secondary_rate_type

Line 719: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, errbuf);

715: errbuf := l_err_msg;
716: l_process_step := 'CACHE_RATES';
717: END IF;
718: -- Print error messages to log
719: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, errbuf);
720: -- Set the concurrent program completion status to ERROR
721: l_return_val := FND_CONCURRENT.set_completion_status('ERROR', NULL);
722: -- Raise application error
723: RAISE_APPLICATION_ERROR(-20010, errbuf);

Line 732: FII_RECONVERSION_PKG.func_succ(l_procedure_name);

728: -- Commit changes to the database
729: FND_CONCURRENT.af_commit;
730: -- Set the concurrent program completion status
731: l_return_val := FND_CONCURRENT.set_completion_status('COMPLETE', NULL);
732: FII_RECONVERSION_PKG.func_succ(l_procedure_name);
733: END IF;
734:
735: EXCEPTION
736: WHEN INVALID_SETUP THEN

Line 741: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, l_err_msg);

737: -- Process fails because of invalid setup
738: -- Note: We don't need to rollback since there are no updates/insert
739: FII_UTIL.debug_line('This process errors out because of invalid setup');
740: -- Print error messages to log
741: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, l_err_msg);
742: -- Set the concurrent program completion status to ERROR
743: l_return_val := FND_CONCURRENT.set_completion_status('ERROR', NULL);
744: -- Raise application error
745: errbuf := l_err_msg;

Line 755: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step);

751: FII_UTIL.debug_line('This process errors out because of other functions');
752: -- Rollback
753: FND_CONCURRENT.af_rollback;
754: -- Print error messages to log file
755: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step);
756: -- Set the concurrent program completion status to ERROR
757: l_return_val := FND_CONCURRENT.set_completion_status('ERROR', NULL);
758: -- Raise application error
759: errbuf := sqlerrm;

Line 771: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, errbuf);

767: FND_CONCURRENT.af_rollback;
768: -- Print error messages to log file
769: errbuf := sqlerrm;
770: retcode := sqlcode;
771: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, errbuf);
772: -- Set the concurrent program completion status to ERROR
773: l_return_val := FND_CONCURRENT.set_completion_status('ERROR', NULL);
774: -- Raise application error
775: RAISE_APPLICATION_ERROR(-20040, errbuf);

Line 814: FII_RECONVERSION_PKG.func_enter(l_procedure_name);

810:
811: l_process_step VARCHAR2(50) := 'INIT_CACHE_RATES';
812: l_procedure_name VARCHAR2(30) := 'cache_rates';
813: BEGIN
814: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
815:
816: IF (p_cache_for_gl_flag = 'Y')
817: THEN
818: --

Line 995: FII_RECONVERSION_PKG.func_succ(l_procedure_name);

991: l_status := 'N';
992:
993: END IF;
994:
995: FII_RECONVERSION_PKG.func_succ(l_procedure_name);
996: RETURN l_status;
997:
998: EXCEPTION
999: WHEN OTHERS THEN

Line 1001: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, sqlerrm);

997:
998: EXCEPTION
999: WHEN OTHERS THEN
1000: -- Print error code and messages to log file and raise error
1001: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, sqlerrm);
1002: -- Raise RECONV_ERROR which will be handled in reconvert_amounts()
1003: RAISE RECONV_ERROR;
1004:
1005: END cache_rates;

Line 1043: NULL, 'FII_RECONVERSION_PKG');

1039: -- 3.1 Initialize the logging for this child request
1040: --
1041: FII_UTIL.initialize(p_log_filename || '_GL.log',
1042: p_output_filename || '_GL.out',
1043: NULL, 'FII_RECONVERSION_PKG');
1044: -- LOG: Function enter
1045: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
1046: -- LOG: FII_RECONV_INIT_STEP || time stamp
1047: FII_UTIL.put_line(' ');

Line 1045: FII_RECONVERSION_PKG.func_enter(l_procedure_name);

1041: FII_UTIL.initialize(p_log_filename || '_GL.log',
1042: p_output_filename || '_GL.out',
1043: NULL, 'FII_RECONVERSION_PKG');
1044: -- LOG: Function enter
1045: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
1046: -- LOG: FII_RECONV_INIT_STEP || time stamp
1047: FII_UTIL.put_line(' ');
1048: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));
1049: -- LOG: State debug mode is on if it does

Line 1250: FII_RECONVERSION_PKG.print_sql(

1246: l_processSQL(i) := l_processSQL(i) || '))';
1247:
1248: -- Print the dynamic SQL only when debug is on
1249: l_process_step := 'PRINT_DAILY_SQL';
1250: FII_RECONVERSION_PKG.print_sql(
1251: 'Insert daily differences SQL:', l_processSQL, i);
1252:
1253: -- Open cursor
1254: l_process_step := 'OPEN_DAILY_SQL';

Line 1432: FII_RECONVERSION_PKG.print_sql(

1428: -- Bug fix 4637659: END
1429:
1430: -- Print the dynamic SQL only when debug is on
1431: l_process_step := 'PRINT_WEEKLY_SQL';
1432: FII_RECONVERSION_PKG.print_sql(
1433: 'Rollup weekly differences SQL:', l_processSQL, i);
1434:
1435: -- Open cursor
1436: l_process_step := 'OPEN_WEEKLY_SQL';

Line 1574: FII_RECONVERSION_PKG.print_sql(

1570: l_processSQL(i) := ' , ROLLUP(t.ent_qtr_id, t.ent_period_id))';
1571:
1572: -- Print the dynamic SQL only when debug is on
1573: l_process_step := 'PRINT_OTHER_SQL';
1574: FII_RECONVERSION_PKG.print_sql(
1575: 'Rollup other differences SQL:', l_processSQL, i);
1576:
1577: -- Open cursor
1578: l_process_step := 'OPEN_OTHER_SQL';

Line 1759: FII_RECONVERSION_PKG.print_sql(

1755: l_processSQL(i) := ' FROM FII_RECONV_GL_ROLLUP_GT r2)';
1756:
1757: -- Print the dynamic SQL only when debug is on
1758: l_process_step := 'PRINT_UPDATE_SQL';
1759: FII_RECONVERSION_PKG.print_sql(
1760: 'Update GL differences SQL:', l_processSQL, i);
1761:
1762: -- Open cursor
1763: l_process_step := 'OPEN_UPDATE_SQL';

Line 1810: FII_RECONVERSION_PKG.func_succ(l_procedure_name);

1806: FND_CONCURRENT.af_commit;
1807: -- Set the concurrent program completion status to COMPLETE
1808: l_return_val := FND_CONCURRENT.set_completion_status('COMPLETE', l_message);
1809:
1810: FII_RECONVERSION_PKG.func_succ(l_procedure_name);
1811:
1812: EXCEPTION
1813: WHEN RECONV_ERROR THEN
1814: -- Process fails because of exceptions raised from other functions

Line 1820: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step);

1816: FII_UTIL.debug_line('Proces errors out because of other functions'' error');
1817: -- Rollback
1818: FND_CONCURRENT.af_rollback;
1819: -- Print error messages to log file
1820: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step);
1821: -- Set the concurrent program completion status to ERROR
1822: l_return_val := FND_CONCURRENT.set_completion_status('ERROR', NULL);
1823: -- Raise application error
1824: errbuf := sqlerrm;

Line 1836: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, errbuf);

1832: FND_CONCURRENT.af_rollback;
1833: -- Print error messages to log file
1834: errbuf := sqlerrm;
1835: retcode := sqlcode;
1836: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, errbuf);
1837: -- Set the concurrent program completion status to ERROR
1838: l_return_val := FND_CONCURRENT.set_completion_status('ERROR', NULL);
1839: -- Raise application error
1840: RAISE_APPLICATION_ERROR(-20060, errbuf);

Line 1876: NULL, 'FII_RECONVERSION_PKG');

1872: -- 4.1 Initialize the logging for this child request
1873: --
1874: FII_UTIL.initialize(p_log_filename || '_AP.log',
1875: p_output_filename || '_AP.out',
1876: NULL, 'FII_RECONVERSION_PKG');
1877: FII_UTIL.put_line(' ');
1878: -- LOG: Function enter
1879: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
1880: -- LOG: FII_RECONV_INIT_STEP || time stamp

Line 1879: FII_RECONVERSION_PKG.func_enter(l_procedure_name);

1875: p_output_filename || '_AP.out',
1876: NULL, 'FII_RECONVERSION_PKG');
1877: FII_UTIL.put_line(' ');
1878: -- LOG: Function enter
1879: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
1880: -- LOG: FII_RECONV_INIT_STEP || time stamp
1881: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));
1882: -- LOG: State debug mode is on if it does
1883: FII_UTIL.debug_line('This process is running in debug mode');

Line 1954: FII_RECONVERSION_PKG.func_succ(l_procedure_name);

1950: FND_CONCURRENT.af_commit;
1951: -- Set the concurrent program completion status to COMPLETE
1952: l_return_val := FND_CONCURRENT.set_completion_status('COMPLETE', l_message);
1953:
1954: FII_RECONVERSION_PKG.func_succ(l_procedure_name);
1955:
1956: EXCEPTION
1957: WHEN OTHERS THEN
1958: -- Process fails because of other exceptions and we need to rollback

Line 1965: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, errbuf);

1961: FND_CONCURRENT.af_rollback;
1962: -- Print error messages to log file
1963: errbuf := sqlerrm;
1964: retcode := sqlcode;
1965: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, errbuf);
1966: -- Set the concurrent program completion status to ERROR
1967: l_return_val := FND_CONCURRENT.set_completion_status('ERROR', NULL);
1968: -- Raise application error
1969: RAISE_APPLICATION_ERROR(-20070, errbuf);

Line 2005: NULL, 'FII_RECONVERSION_PKG');

2001: -- 5.1 Initialize the logging for this child request
2002: --
2003: FII_UTIL.initialize(p_log_filename || '_AR.log',
2004: p_output_filename || '_AR.out',
2005: NULL, 'FII_RECONVERSION_PKG');
2006: FII_UTIL.put_line(' ');
2007: -- LOG: Function enter
2008: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
2009: -- LOG: FII_RECONV_INIT_STEP || time stamp

Line 2008: FII_RECONVERSION_PKG.func_enter(l_procedure_name);

2004: p_output_filename || '_AR.out',
2005: NULL, 'FII_RECONVERSION_PKG');
2006: FII_UTIL.put_line(' ');
2007: -- LOG: Function enter
2008: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
2009: -- LOG: FII_RECONV_INIT_STEP || time stamp
2010: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));
2011: -- LOG: State debug mode is on if it does
2012: FII_UTIL.debug_line('This process is running in debug mode');

Line 2080: FII_RECONVERSION_PKG.func_succ(l_procedure_name);

2076: FND_CONCURRENT.af_commit;
2077: -- Set the concurrent program completion status to COMPLETE
2078: l_return_val := FND_CONCURRENT.set_completion_status('COMPLETE', l_message);
2079:
2080: FII_RECONVERSION_PKG.func_succ(l_procedure_name);
2081:
2082: EXCEPTION
2083: WHEN OTHERS THEN
2084: -- Process fails because of other exceptions and we need to rollback

Line 2091: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, errbuf);

2087: FND_CONCURRENT.af_rollback;
2088: -- Print error messages to log file
2089: errbuf := sqlerrm;
2090: retcode := sqlcode;
2091: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, errbuf);
2092: -- Set the concurrent program completion status to ERROR
2093: l_return_val := FND_CONCURRENT.set_completion_status('ERROR', NULL);
2094: -- Raise application error
2095: RAISE_APPLICATION_ERROR(-20080, errbuf);

Line 2168: FII_RECONVERSION_PKG.func_enter(l_procedure_name);

2164:
2165: l_process_step VARCHAR2(50) := 'PRINT_REPORT_HDR';
2166: l_procedure_name VARCHAR2(30) := 'print_report';
2167: BEGIN
2168: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
2169:
2170: --
2171: -- 6.1 Print the report header
2172: --

Line 2173: FII_RECONVERSION_PKG.print_report_hdr(l_line_count, l_page_count);

2169:
2170: --
2171: -- 6.1 Print the report header
2172: --
2173: FII_RECONVERSION_PKG.print_report_hdr(l_line_count, l_page_count);
2174:
2175: --
2176: -- 6.2 List the passed IN parameters
2177: --

Line 2224: FII_RECONVERSION_PKG.print_mtable_hdr(l_line_count);

2220: l_line_count := l_line_count + 4;
2221:
2222: -- Print Missing Rates table header
2223: l_process_step := 'PRINT_MTABLE_HDR';
2224: FII_RECONVERSION_PKG.print_mtable_hdr(l_line_count);
2225:
2226: -- List SOB Currency, Global Currency, and Rate Date for missing rates
2227:
2228: -- Open c_mrate_lines cursor

Line 2240: FII_RECONVERSION_PKG.print_report_hdr(l_line_count, l_page_count);

2236: EXIT WHEN c_mrate_lines%NOTFOUND;
2237:
2238: IF (l_line_count = 1)
2239: THEN
2240: FII_RECONVERSION_PKG.print_report_hdr(l_line_count, l_page_count);
2241: FII_RECONVERSION_PKG.print_mtable_hdr(l_line_count);
2242: END IF;
2243:
2244: FND_FILE.put_line(FND_FILE.output, l_line_text);

Line 2241: FII_RECONVERSION_PKG.print_mtable_hdr(l_line_count);

2237:
2238: IF (l_line_count = 1)
2239: THEN
2240: FII_RECONVERSION_PKG.print_report_hdr(l_line_count, l_page_count);
2241: FII_RECONVERSION_PKG.print_mtable_hdr(l_line_count);
2242: END IF;
2243:
2244: FND_FILE.put_line(FND_FILE.output, l_line_text);
2245: l_line_count := l_line_count + 1;

Line 2295: FII_RECONVERSION_PKG.print_ctable_hdr(l_line_count);

2291: FII_MESSAGE.write_output('FII_RECONV_CRATE_LIST_PROMPT');
2292: l_line_count := l_line_count + 2;
2293:
2294: -- Print Cached Rates table header
2295: FII_RECONVERSION_PKG.print_ctable_hdr(l_line_count);
2296:
2297: -- Set it to FALSE such that it won't print these again
2298: l_print_common_msg := FALSE;
2299: END IF; -- IF (l_print_common_msg)

Line 2303: FII_RECONVERSION_PKG.print_report_hdr(l_line_count, l_page_count);

2299: END IF; -- IF (l_print_common_msg)
2300:
2301: IF (l_line_count = 1)
2302: THEN
2303: FII_RECONVERSION_PKG.print_report_hdr(l_line_count, l_page_count);
2304: FII_RECONVERSION_PKG.print_ctable_hdr(l_line_count);
2305: END IF;
2306:
2307: FND_FILE.put_line(FND_FILE.output, l_line_text);

Line 2304: FII_RECONVERSION_PKG.print_ctable_hdr(l_line_count);

2300:
2301: IF (l_line_count = 1)
2302: THEN
2303: FII_RECONVERSION_PKG.print_report_hdr(l_line_count, l_page_count);
2304: FII_RECONVERSION_PKG.print_ctable_hdr(l_line_count);
2305: END IF;
2306:
2307: FND_FILE.put_line(FND_FILE.output, l_line_text);
2308: l_line_count := l_line_count + 1;

Line 2324: FII_RECONVERSION_PKG.func_succ(l_procedure_name);

2320: CLOSE c_crate_lines;
2321:
2322: END IF; -- IF (p_cache_rate_status = 'N')
2323:
2324: FII_RECONVERSION_PKG.func_succ(l_procedure_name);
2325: EXCEPTION
2326: WHEN RECONV_ERROR THEN
2327: -- Print error code and messages to log file and raise error
2328: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step);

Line 2328: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step);

2324: FII_RECONVERSION_PKG.func_succ(l_procedure_name);
2325: EXCEPTION
2326: WHEN RECONV_ERROR THEN
2327: -- Print error code and messages to log file and raise error
2328: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step);
2329: -- Raise RECONV_ERROR which will be handled in reconvert_amounts()
2330: RAISE RECONV_ERROR;
2331:
2332: WHEN OTHERS THEN

Line 2334: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, sqlerrm);

2330: RAISE RECONV_ERROR;
2331:
2332: WHEN OTHERS THEN
2333: -- Print error code and messages to log file and raise error
2334: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, sqlerrm);
2335: -- Raise RECONV_ERROR which will be handled in reconvert_amounts()
2336: RAISE RECONV_ERROR;
2337:
2338: END print_report;

Line 2356: FII_RECONVERSION_PKG.func_enter(l_procedure_name);

2352:
2353: l_process_step VARCHAR2(50) := 'APPEND_CURRENT_DATE';
2354: l_procedure_name VARCHAR2(30) := 'print_report_hdr';
2355: BEGIN
2356: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
2357:
2358: -- 6.1.1 Print 1 blank line
2359: FND_FILE.new_line(FND_FILE.output, 1);
2360:

Line 2386: FII_RECONVERSION_PKG.func_succ(l_procedure_name);

2382:
2383: -- Added 2 more lines
2384: p_line_count := p_line_count + 2;
2385:
2386: FII_RECONVERSION_PKG.func_succ(l_procedure_name);
2387: EXCEPTION
2388: WHEN OTHERS THEN
2389: -- Print error code and messages to log file and raise error
2390: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, sqlerrm);

Line 2390: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, sqlerrm);

2386: FII_RECONVERSION_PKG.func_succ(l_procedure_name);
2387: EXCEPTION
2388: WHEN OTHERS THEN
2389: -- Print error code and messages to log file and raise error
2390: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, sqlerrm);
2391: -- Raise RECONV_ERROR which will be handled in reconvert_amounts()
2392: RAISE RECONV_ERROR;
2393:
2394: END print_report_hdr;

Line 2409: FII_RECONVERSION_PKG.func_enter(l_procedure_name);

2405: PROCEDURE print_mtable_hdr (p_line_count IN OUT NOCOPY NUMBER) IS
2406: l_process_step VARCHAR2(50) := 'PRINT_MISSING_RATES_HDR';
2407: l_procedure_name VARCHAR2(30) := 'print_mtable_hdr';
2408: BEGIN
2409: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
2410:
2411: -- 6.3.1 Print 1 blank line
2412: FND_FILE.new_line(FND_FILE.output, 1);
2413: -- 6.3.2 Print missing rate table column header

Line 2419: FII_RECONVERSION_PKG.func_succ(l_procedure_name);

2415: -- 6.3.3 Print missing rate table column line header
2416: FII_MESSAGE.write_output('FII_RECONV_MTABLE_COL_LINE');
2417: p_line_count := p_line_count + 3;
2418:
2419: FII_RECONVERSION_PKG.func_succ(l_procedure_name);
2420: EXCEPTION
2421: WHEN OTHERS THEN
2422: -- Print error code and messages to log file and raise error
2423: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, sqlerrm);

Line 2423: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, sqlerrm);

2419: FII_RECONVERSION_PKG.func_succ(l_procedure_name);
2420: EXCEPTION
2421: WHEN OTHERS THEN
2422: -- Print error code and messages to log file and raise error
2423: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, sqlerrm);
2424: -- Raise RECONV_ERROR which will be handled in reconvert_amounts()
2425: RAISE RECONV_ERROR;
2426:
2427: END print_mtable_hdr;

Line 2442: FII_RECONVERSION_PKG.func_enter(l_procedure_name);

2438: PROCEDURE print_ctable_hdr (p_line_count IN OUT NOCOPY NUMBER) IS
2439: l_process_step VARCHAR2(50) := 'PRINT_CACHED_RATES_HDR';
2440: l_procedure_name VARCHAR2(30) := 'print_ctable_hdr';
2441: BEGIN
2442: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
2443:
2444: -- 6.4.1 Print 1 blank line
2445: FND_FILE.new_line(FND_FILE.output, 1);
2446: -- 6.4.2 Print cached rate table column header

Line 2452: FII_RECONVERSION_PKG.func_succ(l_procedure_name);

2448: -- 6.4.3 Print cached rate table column line header
2449: FII_MESSAGE.write_output('FII_RECONV_CTABLE_COL_LINE');
2450: p_line_count := p_line_count + 3;
2451:
2452: FII_RECONVERSION_PKG.func_succ(l_procedure_name);
2453: EXCEPTION
2454: WHEN OTHERS THEN
2455: -- Print error code and messages to log file and raise error
2456: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, sqlerrm);

Line 2456: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, sqlerrm);

2452: FII_RECONVERSION_PKG.func_succ(l_procedure_name);
2453: EXCEPTION
2454: WHEN OTHERS THEN
2455: -- Print error code and messages to log file and raise error
2456: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, sqlerrm);
2457: -- Raise RECONV_ERROR which will be handled in reconvert_amounts()
2458: RAISE RECONV_ERROR;
2459:
2460: END print_ctable_hdr;

Line 2486: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, sqlerrm);

2482: FII_UTIL.debug_line(' ');
2483: EXCEPTION
2484: WHEN OTHERS THEN
2485: -- Print error code and messages to log file and raise error
2486: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, sqlerrm);
2487: -- Raise RECONV_ERROR which will be handled in reconvert_amounts()
2488: RAISE RECONV_ERROR;
2489:
2490: END print_sql;

Line 2550: END FII_RECONVERSION_PKG;

2546: FII_MESSAGE.func_fail(p_func_name);
2547: FII_UTIL.put_line(' ');
2548: END func_fail;
2549:
2550: END FII_RECONVERSION_PKG;