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.FA_RX_PUBLISH dependencies on FA_RX_UTIL_PKG

Line 216: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'populate_report()+');

212: is
213: appname varchar2(50);
214: begin
215: IF (g_print_debug) THEN
216: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'populate_report()+');
217: END IF;
218:
219: m_report.multiformat := is_multi_format_report(p_request_id);
220: if m_report.multiformat then

Line 242: fa_rx_util_pkg.debug('is_multi_format_report: ' ||

238: m_report.attribute_set := p_attribute_set;
239: end if;
240:
241: IF (g_print_debug) THEN
242: fa_rx_util_pkg.debug('is_multi_format_report: ' ||
243: 'Request ID = '||p_request_id||newline||
244: 'Report ID = '||p_report_id||newline||
245: 'Attribute Set = '||p_attribute_set||newline||
246: 'Output Format = '||p_output_format);

Line 247: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Getting attribute_set flags...');

243: 'Request ID = '||p_request_id||newline||
244: 'Report ID = '||p_report_id||newline||
245: 'Attribute Set = '||p_attribute_set||newline||
246: 'Output Format = '||p_output_format);
247: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Getting attribute_set flags...');
248: END IF;
249: select
250: nvl(print_title, 'Y') print_title,
251: nvl(print_sob_flag, 'Y') print_sob_flag,

Line 275: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Get report title...');

271: report_id = m_report.report_id and
272: attribute_set = m_report.attribute_set;
273:
274: IF (g_print_debug) THEN
275: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Get report title...');
276: END IF;
277: if m_report.report_title is null then
278: select distinct substrb (user_program_name, 1, 100)
279: into m_report.report_title

Line 290: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Get NLS flags...');

286: -- initialized until the format level
287: --
288:
289: IF (g_print_debug) THEN
290: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Get NLS flags...');
291: END IF;
292: select meaning into m_report.functional_currency_prompt
293: from fnd_lookups where lookup_type='FARX_NLS_PARAMS' and lookup_code = 'CURRENCY_PROMPT';
294:

Line 354: fa_rx_util_pkg.debug('is_multi_format_report: ' || sqlstmt);

350: sqlstmt := 'SELECT ORGANIZATION_NAME, FUNCTIONAL_CURRENCY_CODE '||NEWLINE||
351: Get_From_Clause||NEWLINE||get_where_clause;
352: c := dbms_sql.open_cursor;
353: IF (g_print_debug) THEN
354: fa_rx_util_pkg.debug('is_multi_format_report: ' || sqlstmt);
355: END IF;
356: fa_rx_util_pkg.debug('Parsing statement : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
357: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
358: IF (g_print_debug) THEN

Line 356: fa_rx_util_pkg.debug('Parsing statement : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));

352: c := dbms_sql.open_cursor;
353: IF (g_print_debug) THEN
354: fa_rx_util_pkg.debug('is_multi_format_report: ' || sqlstmt);
355: END IF;
356: fa_rx_util_pkg.debug('Parsing statement : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
357: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
358: IF (g_print_debug) THEN
359: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Binding statement');
360: END IF;

Line 359: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Binding statement');

355: END IF;
356: fa_rx_util_pkg.debug('Parsing statement : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
357: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
358: IF (g_print_debug) THEN
359: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Binding statement');
360: END IF;
361: bind_variables(c);
362: fa_rx_util_pkg.debug('Defining columns : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
363: dbms_sql.define_column(c, 1, m_report.set_of_books_name, 100);

Line 362: fa_rx_util_pkg.debug('Defining columns : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));

358: IF (g_print_debug) THEN
359: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Binding statement');
360: END IF;
361: bind_variables(c);
362: fa_rx_util_pkg.debug('Defining columns : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
363: dbms_sql.define_column(c, 1, m_report.set_of_books_name, 100);
364: dbms_sql.define_column(c, 2, m_report.functional_currency, 100);
365: fa_rx_util_pkg.debug('Executing : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
366: rows := dbms_sql.execute(c);

Line 365: fa_rx_util_pkg.debug('Executing : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));

361: bind_variables(c);
362: fa_rx_util_pkg.debug('Defining columns : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
363: dbms_sql.define_column(c, 1, m_report.set_of_books_name, 100);
364: dbms_sql.define_column(c, 2, m_report.functional_currency, 100);
365: fa_rx_util_pkg.debug('Executing : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
366: rows := dbms_sql.execute(c);
367: fa_rx_util_pkg.debug('Fetching : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
368: rows := dbms_sql.fetch_rows(c);
369: fa_rx_util_pkg.debug('Got '||To_char(rows)||' row(s) : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));

Line 367: fa_rx_util_pkg.debug('Fetching : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));

363: dbms_sql.define_column(c, 1, m_report.set_of_books_name, 100);
364: dbms_sql.define_column(c, 2, m_report.functional_currency, 100);
365: fa_rx_util_pkg.debug('Executing : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
366: rows := dbms_sql.execute(c);
367: fa_rx_util_pkg.debug('Fetching : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
368: rows := dbms_sql.fetch_rows(c);
369: fa_rx_util_pkg.debug('Got '||To_char(rows)||' row(s) : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
370: if rows = 0 then
371: --

Line 369: fa_rx_util_pkg.debug('Got '||To_char(rows)||' row(s) : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));

365: fa_rx_util_pkg.debug('Executing : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
366: rows := dbms_sql.execute(c);
367: fa_rx_util_pkg.debug('Fetching : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
368: rows := dbms_sql.fetch_rows(c);
369: fa_rx_util_pkg.debug('Got '||To_char(rows)||' row(s) : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
370: if rows = 0 then
371: --
372: -- The column did not exist in the database
373: -- Set SOB info to null;

Line 377: fa_rx_util_pkg.debug('is_multi_format_report: ' || fnd_message.get);

373: -- Set SOB info to null;
374: --
375: fnd_message.set_name('OFA', 'FA_RX_NO_SOB_COLUMN');
376: IF (g_print_debug) THEN
377: fa_rx_util_pkg.debug('is_multi_format_report: ' || fnd_message.get);
378: END IF;
379: m_report.display_set_of_books := 'N';
380: m_report.display_functional_currency := 'N';
381: m_report.set_of_books_name := null;

Line 397: fa_rx_util_pkg.debug('is_multi_format_report: ' || fnd_message.get);

393: when others then
394: -- no set of books
395: fnd_message.set_name('OFA', 'FA_RX_NO_SOB_COLUMN');
396: IF (g_print_debug) THEN
397: fa_rx_util_pkg.debug('is_multi_format_report: ' || fnd_message.get);
398: END IF;
399:
400: m_report.display_set_of_books := 'N';
401: m_report.display_functional_currency := 'N';

Line 549: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.populate_arguments()+');

545: l_column_name fnd_descr_flex_column_usages.end_user_column_name%type;
546: l_data_type varchar2(10);
547: begin
548: IF (g_print_debug) THEN
549: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.populate_arguments()+');
550: END IF;
551:
552: m_arguments(1).value := p_argument1;
553: m_arguments(2).value := p_argument2;

Line 677: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.populate_arguments()-');

673: end loop;
674: close cargs;
675:
676: IF (g_print_debug) THEN
677: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.populate_arguments()-');
678: END IF;
679: end populate_arguments;
680:
681:

Line 766: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'populate_formats()+');

762: l_formats formattab;
763: idx number;
764: begin
765: IF (g_print_debug) THEN
766: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'populate_formats()+');
767: END IF;
768:
769: m_format_count := 0;
770:

Line 824: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Complex format found - '||to_char(l_formats(idx).group_id));

820: end if;
821:
822: if l_formats(idx).complex_flag = 'Y' then
823: IF (g_print_debug) THEN
824: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Complex format found - '||to_char(l_formats(idx).group_id));
825: END IF;
826:
827: l_formats(idx).display_page_break := 'Y';
828: idx := idx + 1;

Line 831: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Regular format found - '||l_formats(idx).concurrent_program_name);

827: l_formats(idx).display_page_break := 'Y';
828: idx := idx + 1;
829: else
830: IF (g_print_debug) THEN
831: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Regular format found - '||l_formats(idx).concurrent_program_name);
832: END IF;
833: m_format_count := m_format_count + 1;
834: m_formats(m_format_count) := l_formats(1);
835: idx := 1;

Line 955: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Getting parameters for request - '||To_char(p_request_id));

951:
952: max_param_idx number := 0;
953: begin
954: IF (g_print_debug) THEN
955: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Getting parameters for request - '||To_char(p_request_id));
956: END IF;
957:
958: fa_rx_shared_pkg.clear_flex_val_cache;
959:

Line 994: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'There were no parameters for this report');

990: max_param_idx := idx;
991:
992: IF idx = 0 then
993: IF (g_print_debug) THEN
994: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'There were no parameters for this report');
995: END IF;
996: return;
997: ELSIF m_param_count = 0 then
998: IF (g_print_debug) THEN

Line 999: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'There were no displayed parameters for this report');

995: END IF;
996: return;
997: ELSIF m_param_count = 0 then
998: IF (g_print_debug) THEN
999: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'There were no displayed parameters for this report');
1000: END IF;
1001: return;
1002: end if;
1003: IF (g_print_debug) THEN

Line 1004: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Found '||to_char(m_param_count)||' parameter(s).');

1000: END IF;
1001: return;
1002: end if;
1003: IF (g_print_debug) THEN
1004: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Found '||to_char(m_param_count)||' parameter(s).');
1005: END IF;
1006:
1007:
1008: --

Line 1032: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'SQL Statement...'||NEWLINE||sqlstmt);

1028: end if;
1029:
1030:
1031: IF (g_print_debug) THEN
1032: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'SQL Statement...'||NEWLINE||sqlstmt);
1033: END IF;
1034:
1035: --
1036: -- Get the parameter values

Line 1107: fa_rx_util_pkg.debug('is_multi_format_report: ' || '--> '||to_char(idx)||' = '||m_params(idx).value);

1103: end if;
1104: end if;
1105:
1106: IF (g_print_debug) THEN
1107: fa_rx_util_pkg.debug('is_multi_format_report: ' || '--> '||to_char(idx)||' = '||m_params(idx).value);
1108: END IF;
1109: end loop;
1110: end populate_parameters;
1111:

Line 1167: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.populate_columns()+'||NEWLINE||

1163: l_current_break number;
1164: l_last_break number;
1165: begin
1166: IF (g_print_debug) THEN
1167: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.populate_columns()+'||NEWLINE||
1168: 'Getting columns for...'||NEWLINE||
1169: 'Format # = '||to_char(s_current_format_idx)||NEWLINE||
1170: 'Report ID = '||to_char(m_formats(s_current_format_idx).report_id)||NEWLINE||
1171: 'Attribute Set = '||m_formats(s_current_format_idx).attribute_set);

Line 1184: fa_rx_util_pkg.log(fnd_message.get);

1180:
1181: if (rcol.display_length = 0) then
1182: fnd_message.set_name('OFA', 'FA_RX_LENGTH_IS_ZERO');
1183: fnd_message.set_token('COLUMN_NAME', rcol.column_name);
1184: fa_rx_util_pkg.log(fnd_message.get);
1185: GOTO end_loop;
1186: end if;
1187:
1188: IF (rcol.display_length > 255) THEN

Line 1191: fa_rx_util_pkg.Log(fnd_message.get);

1187:
1188: IF (rcol.display_length > 255) THEN
1189: fnd_message.set_name('OFA', 'FA_RX_LENGTH_RESET');
1190: fnd_message.set_token('COLUMN_NAME', rcol.column_name);
1191: fa_rx_util_pkg.Log(fnd_message.get);
1192: rcol.display_length := 255;
1193: END IF;
1194:
1195: m_column_count := m_column_count + 1;

Line 1224: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Retrieved '||to_char(m_column_count)||' column(s)');

1220: NULL;
1221: end loop;
1222:
1223: IF (g_print_debug) THEN
1224: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Retrieved '||to_char(m_column_count)||' column(s)');
1225: END IF;
1226: IF (m_column_count = 0) THEN
1227: fnd_message.set_name('OFA', 'FA_RX_NO_DISPLAYED_COLUMNS');
1228: -- fa_rx_util_pkg.Log(fnd_message.get);

Line 1228: -- fa_rx_util_pkg.Log(fnd_message.get);

1224: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Retrieved '||to_char(m_column_count)||' column(s)');
1225: END IF;
1226: IF (m_column_count = 0) THEN
1227: fnd_message.set_name('OFA', 'FA_RX_NO_DISPLAYED_COLUMNS');
1228: -- fa_rx_util_pkg.Log(fnd_message.get);
1229: app_exception.raise_exception;
1230: END IF;
1231:
1232: --

Line 1263: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Retrieved '||to_char(m_column_count)||' column(s) with currency columns');

1259: end if;
1260: end loop;
1261:
1262: IF (g_print_debug) THEN
1263: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Retrieved '||to_char(m_column_count)||' column(s) with currency columns');
1264: END IF;
1265:
1266: --
1267: -- Reorder break level

Line 1291: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.populate_columns()-');

1287: m_columns(idx).break_group_level := l_current_break;
1288: end loop;
1289:
1290: IF (g_print_debug) THEN
1291: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.populate_columns()-');
1292: END IF;
1293: end populate_columns;
1294:
1295: ---------------------------------------------------------

Line 1341: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.populate_summaries()+

1337: order by print_level, compute_level, reset_level;
1338: rsum csum%rowtype;
1339: begin
1340: IF (g_print_debug) THEN
1341: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.populate_summaries()+
1342: report_id = '||to_char(m_formats(s_current_format_idx).report_id)||'
1343: attribute_set = '||m_formats(s_current_format_idx).attribute_set);
1344: END IF;
1345:

Line 1375: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.populate_summaries()-');

1371: end loop;
1372: close csum;
1373:
1374: IF (g_print_debug) THEN
1375: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.populate_summaries()-');
1376: END IF;
1377: end populate_summaries;
1378:
1379: ---------------------------------------------------------

Line 1447: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'idx='||To_char(idx)||', where_clause='||

1443: sep := 'WHERE '||NEWLINE||' ';
1444: l_where := NULL;
1445: for idx in 1..m_argument_count loop
1446: IF (g_print_debug) THEN
1447: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'idx='||To_char(idx)||', where_clause='||
1448: m_arguments(idx).where_clause||
1449: ', value='||m_arguments(idx).value);
1450: END IF;
1451: if m_arguments(idx).where_clause is not null

Line 1539: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.get_report_name('||to_char(p_report_id)||')+');

1535: p_concname out nocopy varchar2)
1536: is
1537: begin
1538: IF (g_print_debug) THEN
1539: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.get_report_name('||to_char(p_report_id)||')+');
1540: END IF;
1541:
1542: select a.application_short_name, c.concurrent_program_name
1543: into p_appname, p_concname

Line 1555: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.get_report_name('||p_appname||','||p_concname||')-');

1551: rx.application_id = a.application_id and
1552: rx.report_id = p_report_id;
1553:
1554: IF (g_print_debug) THEN
1555: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.get_report_name('||p_appname||','||p_concname||')-');
1556: END IF;
1557: exception
1558: when no_data_found then
1559: p_appname := null;

Line 1562: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.get_report_name('||p_appname||','||p_concname||')-');

1558: when no_data_found then
1559: p_appname := null;
1560: p_concname := null;
1561: IF (g_print_debug) THEN
1562: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.get_report_name('||p_appname||','||p_concname||')-');
1563: END IF;
1564: end get_report_name;
1565:
1566:

Line 1585: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.init_request()+'||NEWLINE||

1581: is
1582: l_request_id NUMBER;
1583: begin
1584: IF (g_print_debug) THEN
1585: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.init_request()+'||NEWLINE||
1586: 'P_Request_ID = '||to_char(p_request_id)||NEWLINE||
1587: 'P_Report_ID = '||to_char(p_report_id)||NEWLINE||
1588: 'P_Attribute_Set = '||p_attribute_set||NEWLINE||
1589: 'P_Output_Format = '||p_output_format);

Line 1600: fa_rx_util_pkg.debug('is_multi_format_report: ' || '** Populate parameters');

1596: populate_formats;
1597: populate_sob;
1598:
1599: IF (g_print_debug) THEN
1600: fa_rx_util_pkg.debug('is_multi_format_report: ' || '** Populate parameters');
1601: END IF;
1602: IF Upper(p_request_type) = 'PUBLISH' THEN
1603: populate_parameters('PUBLISH', p_request_id);
1604: ELSE

Line 1617: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.init_request()-');

1613:
1614: Validate_Report;
1615:
1616: IF (g_print_debug) THEN
1617: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.init_request()-');
1618: END IF;
1619: end init_request;
1620:
1621: ------------------------------------------------------------------

Line 1738: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Init_report()+');

1734: t_conc_request_id varchar2(20);
1735: conc_request_id number;
1736: begin
1737: IF (g_print_debug) THEN
1738: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Init_report()+');
1739: END IF;
1740: populate_report(
1741: null, -- Request ID
1742: p_report_id,

Line 1748: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Concurrent request_id = '||t_conc_request_id);

1744: p_output_format);
1745:
1746: fnd_profile.get('CONC_REQUEST_ID', t_conc_request_id);
1747: IF (g_print_debug) THEN
1748: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Concurrent request_id = '||t_conc_request_id);
1749: END IF;
1750:
1751: if t_conc_request_id is null then
1752: m_report.conc_appname := NULL;

Line 1878: fa_rx_util_pkg.debug('is_multi_format_report: ' || '** Populate parameters');

1874: populate_formats;
1875: populate_sob;
1876:
1877: IF (g_print_debug) THEN
1878: fa_rx_util_pkg.debug('is_multi_format_report: ' || '** Populate parameters');
1879: END IF;
1880: if t_conc_request_id is NOT null then
1881: -- If request ID is null then we just won't print the parameters.
1882: -- Include this form debuggin purposes

Line 1888: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Init_report()-');

1884: END IF;
1885:
1886: Validate_Report;
1887: IF (g_print_debug) THEN
1888: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Init_report()-');
1889: END IF;
1890: end init_report;
1891:
1892: ------------------------------------------------------------------

Line 2148: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.get_summary_column_count('||to_char(p_break_level)||')+');

2144: cnt number;
2145: idx number;
2146: begin
2147: IF (g_print_debug) THEN
2148: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.get_summary_column_count('||to_char(p_break_level)||')+');
2149: END IF;
2150:
2151: idx := 1;
2152: loop

Line 2163: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'idx = '||to_char(idx)||', summary_count='||to_char(m_summary_count));

2159: s_current_summary_idx := idx;
2160: loop
2161: if idx > m_summary_count then
2162: IF (g_print_debug) THEN
2163: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'idx = '||to_char(idx)||', summary_count='||to_char(m_summary_count));
2164: END IF;
2165: exit;
2166: end if;
2167: IF (g_print_debug) THEN

Line 2168: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Checking '||to_char(idx)||' with break level '||to_char(m_summaries(idx).print_level));

2164: END IF;
2165: exit;
2166: end if;
2167: IF (g_print_debug) THEN
2168: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Checking '||to_char(idx)||' with break level '||to_char(m_summaries(idx).print_level));
2169: END IF;
2170: exit when m_summaries(idx).print_level <> p_break_level;
2171:
2172: idx := idx + 1;

Line 2177: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.get_summary_column_count('||to_char(cnt)||')-');

2173: cnt := cnt + 1;
2174: end loop;
2175:
2176: IF (g_print_debug) THEN
2177: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.get_summary_column_count('||to_char(cnt)||')-');
2178: END IF;
2179: return cnt;
2180: end get_summary_column_count;
2181:

Line 2215: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.START_FORMAT()+');

2211: rows number;
2212: dummy varchar2(240);
2213: begin
2214: IF (g_print_debug) THEN
2215: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.START_FORMAT()+');
2216: END IF;
2217:
2218: --
2219: -- Initialize the date/time formats

Line 2232: fa_rx_util_pkg.debug('is_multi_format_report: ' || '-- Populate columns');

2228: else
2229: m_report.submission_date := fnd_date.date_to_displaydt(m_report.real_submission_date);
2230: end if;
2231: IF (g_print_debug) THEN
2232: fa_rx_util_pkg.debug('is_multi_format_report: ' || '-- Populate columns');
2233: END IF;
2234: populate_columns;
2235: IF (g_print_debug) THEN
2236: fa_rx_util_pkg.debug('is_multi_format_report: ' || '-- Populate summaries');

Line 2236: fa_rx_util_pkg.debug('is_multi_format_report: ' || '-- Populate summaries');

2232: fa_rx_util_pkg.debug('is_multi_format_report: ' || '-- Populate columns');
2233: END IF;
2234: populate_columns;
2235: IF (g_print_debug) THEN
2236: fa_rx_util_pkg.debug('is_multi_format_report: ' || '-- Populate summaries');
2237: END IF;
2238: populate_summaries;
2239:
2240: IF (g_print_debug) THEN

Line 2241: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.start_format()-');

2237: END IF;
2238: populate_summaries;
2239:
2240: IF (g_print_debug) THEN
2241: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.start_format()-');
2242: END IF;
2243: end start_format;
2244:
2245: ------------------------------------------------------------------

Line 2458: fa_rx_util_pkg.debug('Expand_Complex_Multiformat()+');

2454: invalid_result_columns exception;
2455: pragma exception_init(invalid_result_columns, -1789);
2456: begin
2457: IF (g_print_debug) THEN
2458: fa_rx_util_pkg.debug('Expand_Complex_Multiformat()+');
2459: END IF;
2460:
2461: sqlstmt := null;
2462: for idx in 1..p_count loop

Line 2495: fa_rx_util_pkg.debug('Expand_Complex_Multiformat: ' || '

2491: end loop;
2492:
2493:
2494: IF (g_print_debug) THEN
2495: fa_rx_util_pkg.debug('Expand_Complex_Multiformat: ' || '
2496: '||sqlstmt||'
2497: ');
2498: END IF;
2499:

Line 2506: fa_rx_util_pkg.debug('Expand_Complex_Multiformat: ' || 'Cannot use complex mode for these sets of reports');

2502: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
2503: exception
2504: when invalid_result_columns then
2505: IF (g_print_debug) THEN
2506: fa_rx_util_pkg.debug('Expand_Complex_Multiformat: ' || 'Cannot use complex mode for these sets of reports');
2507: END IF;
2508: fnd_message.set_name('OFA', 'FA_RX_INVALID_USE_OF_COMPLEX');
2509: app_exception.raise_exception;
2510: end;

Line 2547: fa_rx_util_pkg.debug('Expand_Complex_Multiformat: ' || where_clause);

2543: m_formats(m_format_count) := p_formats(idx);
2544: m_formats(m_format_count).where_clause := where_clause;
2545:
2546: IF (g_print_debug) THEN
2547: fa_rx_util_pkg.debug('Expand_Complex_Multiformat: ' || where_clause);
2548: END IF;
2549: end loop;
2550: end loop;
2551:

Line 2631: -- fa_rx_util_pkg.Log(fnd_message.get);

2627: for i in 1..m_format_count loop
2628: pos := 0;
2629: line := 0;
2630: if not calculate_pos(i, 'Y', m_report.page_width, last_pos, last_line) then
2631: -- fa_rx_util_pkg.Log(fnd_message.get);
2632: app_exception.raise_exception;
2633: end if;
2634: pos := last_pos;
2635: line := last_line;

Line 2639: fa_rx_util_pkg.debug(fnd_message.get);

2635: line := last_line;
2636:
2637: if m_formats(i).group_display_type = 'GROUP LEFT' then
2638: if not calculate_pos(i, 'N', m_report.page_width - 2 - pos, last_pos, last_line) then
2639: fa_rx_util_pkg.debug(fnd_message.get);
2640: fnd_message.set_name('OFA', 'FA_RX_GROUP_ABOVE_USED');
2641: fa_rx_util_pkg.log(fnd_message.get);
2642:
2643: m_formats(i).group_display_type := 'GROUP ABOVE';

Line 2641: fa_rx_util_pkg.log(fnd_message.get);

2637: if m_formats(i).group_display_type = 'GROUP LEFT' then
2638: if not calculate_pos(i, 'N', m_report.page_width - 2 - pos, last_pos, last_line) then
2639: fa_rx_util_pkg.debug(fnd_message.get);
2640: fnd_message.set_name('OFA', 'FA_RX_GROUP_ABOVE_USED');
2641: fa_rx_util_pkg.log(fnd_message.get);
2642:
2643: m_formats(i).group_display_type := 'GROUP ABOVE';
2644: else
2645: line := line + last_line - 1;

Line 2651: -- fa_rx_util_pkg.Log(fnd_message.get);

2647: end if;
2648:
2649: if m_formats(i).group_display_type = 'GROUP ABOVE' then
2650: if not calculate_pos(i, 'N', m_report.page_width, last_pos, last_line) then
2651: -- fa_rx_util_pkg.Log(fnd_message.get);
2652: app_exception.raise_exception;
2653: else
2654: line := line + last_line;
2655: end if;

Line 2668: -- fa_rx_util_pkg.Log(fnd_message.get);

2664: if m_report.page_height <> 0 then
2665: -- Check page height
2666: if max_lines*2 + 20 > m_report.page_height then
2667: fnd_message.set_name('OFA', 'FA_RX_PAGE_HEIGHT_TOO_SMALL');
2668: -- fa_rx_util_pkg.Log(fnd_message.get);
2669: app_exception.raise_exception;
2670: end if;
2671: end if;
2672:

Line 2703: fa_rx_util_pkg.debug('bind_variables: ' || 'Bind :b'||To_char(i)||' => '||v);

2699: BEGIN
2700: FOR i IN 1..get_bind_count LOOP
2701: v := get_bind_variable;
2702: IF (g_print_debug) THEN
2703: fa_rx_util_pkg.debug('bind_variables: ' || 'Bind :b'||To_char(i)||' => '||v);
2704: END IF;
2705: dbms_sql.bind_variable(c, ':b'||To_char(i), v);
2706: END LOOP;
2707: END bind_variables;

Line 2756: fa_rx_util_pkg.debug(' name = '||m_params_with_actual_value(s_current_param_idx).name );

2752: xMoac_Message := Null;
2753:
2754: for s_current_param_idx in m_params_with_actual_value.first..m_params_with_actual_value.last
2755: LOOP
2756: fa_rx_util_pkg.debug(' name = '||m_params_with_actual_value(s_current_param_idx).name );
2757: fa_rx_util_pkg.debug(' value = '||m_params_with_actual_value(s_current_param_idx).value );
2758: fa_rx_util_pkg.debug(' display_flag = '||m_params_with_actual_value(s_current_param_idx).display_flag );
2759: fa_rx_util_pkg.debug(' format_type = '||m_params_with_actual_value(s_current_param_idx).format_type );
2760: fa_rx_util_pkg.debug(' flex_value_set_id = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_id );

Line 2757: fa_rx_util_pkg.debug(' value = '||m_params_with_actual_value(s_current_param_idx).value );

2753:
2754: for s_current_param_idx in m_params_with_actual_value.first..m_params_with_actual_value.last
2755: LOOP
2756: fa_rx_util_pkg.debug(' name = '||m_params_with_actual_value(s_current_param_idx).name );
2757: fa_rx_util_pkg.debug(' value = '||m_params_with_actual_value(s_current_param_idx).value );
2758: fa_rx_util_pkg.debug(' display_flag = '||m_params_with_actual_value(s_current_param_idx).display_flag );
2759: fa_rx_util_pkg.debug(' format_type = '||m_params_with_actual_value(s_current_param_idx).format_type );
2760: fa_rx_util_pkg.debug(' flex_value_set_id = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_id );
2761: fa_rx_util_pkg.debug(' flex_value_set_name = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_name );

Line 2758: fa_rx_util_pkg.debug(' display_flag = '||m_params_with_actual_value(s_current_param_idx).display_flag );

2754: for s_current_param_idx in m_params_with_actual_value.first..m_params_with_actual_value.last
2755: LOOP
2756: fa_rx_util_pkg.debug(' name = '||m_params_with_actual_value(s_current_param_idx).name );
2757: fa_rx_util_pkg.debug(' value = '||m_params_with_actual_value(s_current_param_idx).value );
2758: fa_rx_util_pkg.debug(' display_flag = '||m_params_with_actual_value(s_current_param_idx).display_flag );
2759: fa_rx_util_pkg.debug(' format_type = '||m_params_with_actual_value(s_current_param_idx).format_type );
2760: fa_rx_util_pkg.debug(' flex_value_set_id = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_id );
2761: fa_rx_util_pkg.debug(' flex_value_set_name = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_name );
2762: fa_rx_util_pkg.debug(' param_idx = '||m_params_with_actual_value(s_current_param_idx).param_idx );

Line 2759: fa_rx_util_pkg.debug(' format_type = '||m_params_with_actual_value(s_current_param_idx).format_type );

2755: LOOP
2756: fa_rx_util_pkg.debug(' name = '||m_params_with_actual_value(s_current_param_idx).name );
2757: fa_rx_util_pkg.debug(' value = '||m_params_with_actual_value(s_current_param_idx).value );
2758: fa_rx_util_pkg.debug(' display_flag = '||m_params_with_actual_value(s_current_param_idx).display_flag );
2759: fa_rx_util_pkg.debug(' format_type = '||m_params_with_actual_value(s_current_param_idx).format_type );
2760: fa_rx_util_pkg.debug(' flex_value_set_id = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_id );
2761: fa_rx_util_pkg.debug(' flex_value_set_name = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_name );
2762: fa_rx_util_pkg.debug(' param_idx = '||m_params_with_actual_value(s_current_param_idx).param_idx );
2763: fa_rx_util_pkg.debug(' column_name = '||m_params_with_actual_value(s_current_param_idx).column_name );

Line 2760: fa_rx_util_pkg.debug(' flex_value_set_id = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_id );

2756: fa_rx_util_pkg.debug(' name = '||m_params_with_actual_value(s_current_param_idx).name );
2757: fa_rx_util_pkg.debug(' value = '||m_params_with_actual_value(s_current_param_idx).value );
2758: fa_rx_util_pkg.debug(' display_flag = '||m_params_with_actual_value(s_current_param_idx).display_flag );
2759: fa_rx_util_pkg.debug(' format_type = '||m_params_with_actual_value(s_current_param_idx).format_type );
2760: fa_rx_util_pkg.debug(' flex_value_set_id = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_id );
2761: fa_rx_util_pkg.debug(' flex_value_set_name = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_name );
2762: fa_rx_util_pkg.debug(' param_idx = '||m_params_with_actual_value(s_current_param_idx).param_idx );
2763: fa_rx_util_pkg.debug(' column_name = '||m_params_with_actual_value(s_current_param_idx).column_name );
2764: fa_rx_util_pkg.debug(' operator = '||m_params_with_actual_value(s_current_param_idx).operator );

Line 2761: fa_rx_util_pkg.debug(' flex_value_set_name = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_name );

2757: fa_rx_util_pkg.debug(' value = '||m_params_with_actual_value(s_current_param_idx).value );
2758: fa_rx_util_pkg.debug(' display_flag = '||m_params_with_actual_value(s_current_param_idx).display_flag );
2759: fa_rx_util_pkg.debug(' format_type = '||m_params_with_actual_value(s_current_param_idx).format_type );
2760: fa_rx_util_pkg.debug(' flex_value_set_id = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_id );
2761: fa_rx_util_pkg.debug(' flex_value_set_name = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_name );
2762: fa_rx_util_pkg.debug(' param_idx = '||m_params_with_actual_value(s_current_param_idx).param_idx );
2763: fa_rx_util_pkg.debug(' column_name = '||m_params_with_actual_value(s_current_param_idx).column_name );
2764: fa_rx_util_pkg.debug(' operator = '||m_params_with_actual_value(s_current_param_idx).operator );
2765:

Line 2762: fa_rx_util_pkg.debug(' param_idx = '||m_params_with_actual_value(s_current_param_idx).param_idx );

2758: fa_rx_util_pkg.debug(' display_flag = '||m_params_with_actual_value(s_current_param_idx).display_flag );
2759: fa_rx_util_pkg.debug(' format_type = '||m_params_with_actual_value(s_current_param_idx).format_type );
2760: fa_rx_util_pkg.debug(' flex_value_set_id = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_id );
2761: fa_rx_util_pkg.debug(' flex_value_set_name = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_name );
2762: fa_rx_util_pkg.debug(' param_idx = '||m_params_with_actual_value(s_current_param_idx).param_idx );
2763: fa_rx_util_pkg.debug(' column_name = '||m_params_with_actual_value(s_current_param_idx).column_name );
2764: fa_rx_util_pkg.debug(' operator = '||m_params_with_actual_value(s_current_param_idx).operator );
2765:
2766: If (m_params_with_actual_value(s_current_param_idx).flex_value_set_name = 'FND_MO_REPORTING_LEVEL') Then

Line 2763: fa_rx_util_pkg.debug(' column_name = '||m_params_with_actual_value(s_current_param_idx).column_name );

2759: fa_rx_util_pkg.debug(' format_type = '||m_params_with_actual_value(s_current_param_idx).format_type );
2760: fa_rx_util_pkg.debug(' flex_value_set_id = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_id );
2761: fa_rx_util_pkg.debug(' flex_value_set_name = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_name );
2762: fa_rx_util_pkg.debug(' param_idx = '||m_params_with_actual_value(s_current_param_idx).param_idx );
2763: fa_rx_util_pkg.debug(' column_name = '||m_params_with_actual_value(s_current_param_idx).column_name );
2764: fa_rx_util_pkg.debug(' operator = '||m_params_with_actual_value(s_current_param_idx).operator );
2765:
2766: If (m_params_with_actual_value(s_current_param_idx).flex_value_set_name = 'FND_MO_REPORTING_LEVEL') Then
2767: l_Reporting_Level := m_params_with_actual_value(s_current_param_idx).value;

Line 2764: fa_rx_util_pkg.debug(' operator = '||m_params_with_actual_value(s_current_param_idx).operator );

2760: fa_rx_util_pkg.debug(' flex_value_set_id = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_id );
2761: fa_rx_util_pkg.debug(' flex_value_set_name = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_name );
2762: fa_rx_util_pkg.debug(' param_idx = '||m_params_with_actual_value(s_current_param_idx).param_idx );
2763: fa_rx_util_pkg.debug(' column_name = '||m_params_with_actual_value(s_current_param_idx).column_name );
2764: fa_rx_util_pkg.debug(' operator = '||m_params_with_actual_value(s_current_param_idx).operator );
2765:
2766: If (m_params_with_actual_value(s_current_param_idx).flex_value_set_name = 'FND_MO_REPORTING_LEVEL') Then
2767: l_Reporting_Level := m_params_with_actual_value(s_current_param_idx).value;
2768: End If;

Line 2774: fa_rx_util_pkg.debug(' l_Reporting_Level = '||l_Reporting_Level);

2770: l_reporting_entity_id := m_params_with_actual_value(s_current_param_idx).value;
2771: End If;
2772: END LOOP;
2773:
2774: fa_rx_util_pkg.debug(' l_Reporting_Level = '||l_Reporting_Level);
2775: fa_rx_util_pkg.debug(' l_reporting_entity_id = '||l_reporting_entity_id);
2776:
2777: If to_number(l_Reporting_Level) = 1000 Then --* if 1000, then it means it is legal entity.
2778: l_ld_sp:= mo_utils.check_ledger_in_sp(TO_NUMBER(l_reporting_entity_id)); --* if 1000, then use the p_reporting_entity_id

Line 2775: fa_rx_util_pkg.debug(' l_reporting_entity_id = '||l_reporting_entity_id);

2771: End If;
2772: END LOOP;
2773:
2774: fa_rx_util_pkg.debug(' l_Reporting_Level = '||l_Reporting_Level);
2775: fa_rx_util_pkg.debug(' l_reporting_entity_id = '||l_reporting_entity_id);
2776:
2777: If to_number(l_Reporting_Level) = 1000 Then --* if 1000, then it means it is legal entity.
2778: l_ld_sp:= mo_utils.check_ledger_in_sp(TO_NUMBER(l_reporting_entity_id)); --* if 1000, then use the p_reporting_entity_id
2779: IF l_ld_sp = 'N' THEN

Line 2784: fa_rx_util_pkg.debug(' xMoac_Message = '||xMoac_Message);

2780: FND_MESSAGE.SET_NAME('FND','FND_MO_RPT_PARTIAL_LEDGER');
2781: xMoac_Message :=FND_MESSAGE.get;
2782: END IF;
2783: END IF;
2784: fa_rx_util_pkg.debug(' xMoac_Message = '||xMoac_Message);
2785: END IF; --if g_release = 12
2786: null;
2787: Exception
2788: When Others Then

Line 2790: fa_rx_util_pkg.debug(' In exception xMoac_Message = '||xMoac_Message);

2786: null;
2787: Exception
2788: When Others Then
2789: xMoac_Message := Null;
2790: fa_rx_util_pkg.debug(' In exception xMoac_Message = '||xMoac_Message);
2791: End get_Moac_Message;
2792:
2793:
2794: