DBA Data[Home] [Help]

APPS.FII_RECONVERSION_PKG dependencies on FND_MESSAGE

Line 88: FII_UTIL.put_line(FND_MESSAGE.get_string('FND', 'CONC-PARAMETERS') || ':');

84:
85: -- LOG: List all passed parameters
86: l_process_step := 'LOG_LIST_PARAMS';
87: FII_UTIL.put_line(' ');
88: FII_UTIL.put_line(FND_MESSAGE.get_string('FND', 'CONC-PARAMETERS') || ':');
89: FII_UTIL.put_line(FII_MESSAGE.get_message(
90: 'FII_RECONV_TRX_TYPE_PARAM_P', NULL
91: , 'P_VALUE', p_transaction_type));
92: FII_UTIL.put_line(FII_MESSAGE.get_message(

Line 858: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');

854: IF (l_cached_rate_count > 0)
855: THEN
856: l_cached_rate_flag := TRUE;
857: END IF;
858: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
859: FND_MESSAGE.set_token('ROWS', l_cached_rate_count);
860: FII_UTIL.put_timestamp(FND_MESSAGE.get);
861: END IF; -- IF (p_cache_for_gl_flag = 'Y')
862:

Line 859: FND_MESSAGE.set_token('ROWS', l_cached_rate_count);

855: THEN
856: l_cached_rate_flag := TRUE;
857: END IF;
858: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
859: FND_MESSAGE.set_token('ROWS', l_cached_rate_count);
860: FII_UTIL.put_timestamp(FND_MESSAGE.get);
861: END IF; -- IF (p_cache_for_gl_flag = 'Y')
862:
863: IF (p_cache_for_ap_flag = 'Y')

Line 860: FII_UTIL.put_timestamp(FND_MESSAGE.get);

856: l_cached_rate_flag := TRUE;
857: END IF;
858: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
859: FND_MESSAGE.set_token('ROWS', l_cached_rate_count);
860: FII_UTIL.put_timestamp(FND_MESSAGE.get);
861: END IF; -- IF (p_cache_for_gl_flag = 'Y')
862:
863: IF (p_cache_for_ap_flag = 'Y')
864: THEN

Line 907: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');

903: IF (l_cached_rate_count > 0)
904: THEN
905: l_cached_rate_flag := TRUE;
906: END IF;
907: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
908: FND_MESSAGE.set_token('ROWS', l_cached_rate_count);
909: FII_UTIL.put_timestamp(FND_MESSAGE.get);
910: END IF; -- IF (p_cache_for_ap_flag = 'Y')
911:

Line 908: FND_MESSAGE.set_token('ROWS', l_cached_rate_count);

904: THEN
905: l_cached_rate_flag := TRUE;
906: END IF;
907: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
908: FND_MESSAGE.set_token('ROWS', l_cached_rate_count);
909: FII_UTIL.put_timestamp(FND_MESSAGE.get);
910: END IF; -- IF (p_cache_for_ap_flag = 'Y')
911:
912: IF (p_cache_for_ar_flag = 'Y')

Line 909: FII_UTIL.put_timestamp(FND_MESSAGE.get);

905: l_cached_rate_flag := TRUE;
906: END IF;
907: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
908: FND_MESSAGE.set_token('ROWS', l_cached_rate_count);
909: FII_UTIL.put_timestamp(FND_MESSAGE.get);
910: END IF; -- IF (p_cache_for_ap_flag = 'Y')
911:
912: IF (p_cache_for_ar_flag = 'Y')
913: THEN

Line 956: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');

952: IF (l_cached_rate_count > 0)
953: THEN
954: l_cached_rate_flag := TRUE;
955: END IF;
956: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
957: FND_MESSAGE.set_token('ROWS', l_cached_rate_count);
958: FII_UTIL.put_timestamp(FND_MESSAGE.get);
959: END IF; -- IF (p_cache_for_ar_flag = 'Y')
960:

Line 957: FND_MESSAGE.set_token('ROWS', l_cached_rate_count);

953: THEN
954: l_cached_rate_flag := TRUE;
955: END IF;
956: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
957: FND_MESSAGE.set_token('ROWS', l_cached_rate_count);
958: FII_UTIL.put_timestamp(FND_MESSAGE.get);
959: END IF; -- IF (p_cache_for_ar_flag = 'Y')
960:
961: --

Line 958: FII_UTIL.put_timestamp(FND_MESSAGE.get);

954: l_cached_rate_flag := TRUE;
955: END IF;
956: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
957: FND_MESSAGE.set_token('ROWS', l_cached_rate_count);
958: FII_UTIL.put_timestamp(FND_MESSAGE.get);
959: END IF; -- IF (p_cache_for_ar_flag = 'Y')
960:
961: --
962: -- 2.4 Determine the caching rate status

Line 1310: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');

1306:
1307: -- Execute the SQL
1308: l_process_step := 'RUN_DAILY_SQL';
1309: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1310: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1311: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1312: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1313:
1314: -- Close cursor

Line 1311: FND_MESSAGE.set_token('ROWS', l_processed_rows);

1307: -- Execute the SQL
1308: l_process_step := 'RUN_DAILY_SQL';
1309: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1310: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1311: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1312: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1313:
1314: -- Close cursor
1315: l_process_step := 'CLOSE_DAILY_SQL';

Line 1312: FII_UTIL.put_timestamp(FND_MESSAGE.get);

1308: l_process_step := 'RUN_DAILY_SQL';
1309: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1310: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1311: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1312: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1313:
1314: -- Close cursor
1315: l_process_step := 'CLOSE_DAILY_SQL';
1316: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

Line 1446: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');

1442:
1443: -- Execute the SQL
1444: l_process_step := 'RUN_WEEKLY_SQL';
1445: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1446: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1447: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1448: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1449:
1450: -- Close cursor

Line 1447: FND_MESSAGE.set_token('ROWS', l_processed_rows);

1443: -- Execute the SQL
1444: l_process_step := 'RUN_WEEKLY_SQL';
1445: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1446: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1447: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1448: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1449:
1450: -- Close cursor
1451: l_process_step := 'CLOSE_WEEKLY_SQL';

Line 1448: FII_UTIL.put_timestamp(FND_MESSAGE.get);

1444: l_process_step := 'RUN_WEEKLY_SQL';
1445: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1446: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1447: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1448: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1449:
1450: -- Close cursor
1451: l_process_step := 'CLOSE_WEEKLY_SQL';
1452: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

Line 1588: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');

1584:
1585: -- Execute the SQL
1586: l_process_step := 'RUN_OTHER_SQL';
1587: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1588: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1589: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1590: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1591:
1592: -- Close cursor

Line 1589: FND_MESSAGE.set_token('ROWS', l_processed_rows);

1585: -- Execute the SQL
1586: l_process_step := 'RUN_OTHER_SQL';
1587: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1588: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1589: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1590: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1591:
1592: -- Close cursor
1593: l_process_step := 'CLOSE_OTHER_SQL';

Line 1590: FII_UTIL.put_timestamp(FND_MESSAGE.get);

1586: l_process_step := 'RUN_OTHER_SQL';
1587: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1588: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1589: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1590: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1591:
1592: -- Close cursor
1593: l_process_step := 'CLOSE_OTHER_SQL';
1594: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

Line 1779: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');

1775: -- Execute the SQL
1776: l_process_step := 'RUN_UPDATE_SQL';
1777: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1778: COMMIT;
1779: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1780: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1781: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1782:
1783: -- Close cursor

Line 1780: FND_MESSAGE.set_token('ROWS', l_processed_rows);

1776: l_process_step := 'RUN_UPDATE_SQL';
1777: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1778: COMMIT;
1779: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1780: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1781: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1782:
1783: -- Close cursor
1784: l_process_step := 'CLOSE_UPDATE_SQL';

Line 1781: FII_UTIL.put_timestamp(FND_MESSAGE.get);

1777: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1778: COMMIT;
1779: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1780: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1781: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1782:
1783: -- Close cursor
1784: l_process_step := 'CLOSE_UPDATE_SQL';
1785: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

Line 2364: l_message := FND_MESSAGE.get_string('FND', 'DATE') || ': '

2360:
2361: -- 6.1.2 Print 1 report header line
2362:
2363: -- Set the line starting with the report date (i.e. current date)
2364: l_message := FND_MESSAGE.get_string('FND', 'DATE') || ': '
2365: || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MM:SS');
2366: l_line_text := RPAD(l_message, 36, ' ');
2367:
2368: -- Append report title

Line 2370: l_message := FND_MESSAGE.get_string('FII', 'FII_RECONV_REPORT_TITLE');

2366: l_line_text := RPAD(l_message, 36, ' ');
2367:
2368: -- Append report title
2369: l_process_step := 'APPEND_TITLE';
2370: l_message := FND_MESSAGE.get_string('FII', 'FII_RECONV_REPORT_TITLE');
2371: l_line_text := l_line_text || LPAD(l_message, 48, ' ');
2372:
2373: -- Append page number
2374: l_process_step := 'APPEND_PAGE_NUMBER';