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 217: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'populate_report()+');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

946:
947: max_param_idx number := 0;
948: begin
949: IF (g_print_debug) THEN
950: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Getting parameters for request - '||To_char(p_request_id));
951: END IF;
952:
953: fa_rx_shared_pkg.clear_flex_val_cache;
954:

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

985: max_param_idx := idx;
986:
987: IF idx = 0 then
988: IF (g_print_debug) THEN
989: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'There were no parameters for this report');
990: END IF;
991: return;
992: ELSIF m_param_count = 0 then
993: IF (g_print_debug) THEN

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

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

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

995: END IF;
996: return;
997: end if;
998: IF (g_print_debug) THEN
999: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Found '||to_char(m_param_count)||' parameter(s).');
1000: END IF;
1001:
1002:
1003: --

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

1023: end if;
1024:
1025:
1026: IF (g_print_debug) THEN
1027: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'SQL Statement...'||NEWLINE||sqlstmt);
1028: END IF;
1029:
1030: --
1031: -- Get the parameter values

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

1087: end if;
1088: end if;
1089:
1090: IF (g_print_debug) THEN
1091: fa_rx_util_pkg.debug('is_multi_format_report: ' || '--> '||to_char(idx)||' = '||m_params(idx).value);
1092: END IF;
1093: end loop;
1094: end populate_parameters;
1095:

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

1147: l_current_break number;
1148: l_last_break number;
1149: begin
1150: IF (g_print_debug) THEN
1151: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.populate_columns()+'||NEWLINE||
1152: 'Getting columns for...'||NEWLINE||
1153: 'Format # = '||to_char(s_current_format_idx)||NEWLINE||
1154: 'Report ID = '||to_char(m_formats(s_current_format_idx).report_id)||NEWLINE||
1155: 'Attribute Set = '||m_formats(s_current_format_idx).attribute_set);

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

1164:
1165: if (rcol.display_length = 0) then
1166: fnd_message.set_name('OFA', 'FA_RX_LENGTH_IS_ZERO');
1167: fnd_message.set_token('COLUMN_NAME', rcol.column_name);
1168: fa_rx_util_pkg.log(fnd_message.get);
1169: GOTO end_loop;
1170: end if;
1171:
1172: IF (rcol.display_length > 255) THEN

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

1171:
1172: IF (rcol.display_length > 255) THEN
1173: fnd_message.set_name('OFA', 'FA_RX_LENGTH_RESET');
1174: fnd_message.set_token('COLUMN_NAME', rcol.column_name);
1175: fa_rx_util_pkg.Log(fnd_message.get);
1176: rcol.display_length := 255;
1177: END IF;
1178:
1179: m_column_count := m_column_count + 1;

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

1204: NULL;
1205: end loop;
1206:
1207: IF (g_print_debug) THEN
1208: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Retrieved '||to_char(m_column_count)||' column(s)');
1209: END IF;
1210: IF (m_column_count = 0) THEN
1211: fnd_message.set_name('OFA', 'FA_RX_NO_DISPLAYED_COLUMNS');
1212: -- fa_rx_util_pkg.Log(fnd_message.get);

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

1208: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Retrieved '||to_char(m_column_count)||' column(s)');
1209: END IF;
1210: IF (m_column_count = 0) THEN
1211: fnd_message.set_name('OFA', 'FA_RX_NO_DISPLAYED_COLUMNS');
1212: -- fa_rx_util_pkg.Log(fnd_message.get);
1213: app_exception.raise_exception;
1214: END IF;
1215:
1216: --

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

1243: end if;
1244: end loop;
1245:
1246: IF (g_print_debug) THEN
1247: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Retrieved '||to_char(m_column_count)||' column(s) with currency columns');
1248: END IF;
1249:
1250: --
1251: -- Reorder break level

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

1271: m_columns(idx).break_group_level := l_current_break;
1272: end loop;
1273:
1274: IF (g_print_debug) THEN
1275: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.populate_columns()-');
1276: END IF;
1277: end populate_columns;
1278:
1279: ---------------------------------------------------------

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

1321: order by print_level, compute_level, reset_level;
1322: rsum csum%rowtype;
1323: begin
1324: IF (g_print_debug) THEN
1325: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.populate_summaries()+
1326: report_id = '||to_char(m_formats(s_current_format_idx).report_id)||'
1327: attribute_set = '||m_formats(s_current_format_idx).attribute_set);
1328: END IF;
1329:

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

1355: end loop;
1356: close csum;
1357:
1358: IF (g_print_debug) THEN
1359: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.populate_summaries()-');
1360: END IF;
1361: end populate_summaries;
1362:
1363: ---------------------------------------------------------

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

1427: sep := 'WHERE '||NEWLINE||' ';
1428: l_where := NULL;
1429: for idx in 1..m_argument_count loop
1430: IF (g_print_debug) THEN
1431: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'idx='||To_char(idx)||', where_clause='||
1432: m_arguments(idx).where_clause||
1433: ', value='||m_arguments(idx).value);
1434: END IF;
1435: if m_arguments(idx).where_clause is not null

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

1516: p_concname out nocopy varchar2)
1517: is
1518: begin
1519: IF (g_print_debug) THEN
1520: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.get_report_name('||to_char(p_report_id)||')+');
1521: END IF;
1522:
1523: select a.application_short_name, c.concurrent_program_name
1524: into p_appname, p_concname

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

1532: rx.application_id = a.application_id and
1533: rx.report_id = p_report_id;
1534:
1535: IF (g_print_debug) THEN
1536: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.get_report_name('||p_appname||','||p_concname||')-');
1537: END IF;
1538: exception
1539: when no_data_found then
1540: p_appname := null;

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

1539: when no_data_found then
1540: p_appname := null;
1541: p_concname := null;
1542: IF (g_print_debug) THEN
1543: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.get_report_name('||p_appname||','||p_concname||')-');
1544: END IF;
1545: end get_report_name;
1546:
1547:

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

1562: is
1563: l_request_id NUMBER;
1564: begin
1565: IF (g_print_debug) THEN
1566: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.init_request()+'||NEWLINE||
1567: 'P_Request_ID = '||to_char(p_request_id)||NEWLINE||
1568: 'P_Report_ID = '||to_char(p_report_id)||NEWLINE||
1569: 'P_Attribute_Set = '||p_attribute_set||NEWLINE||
1570: 'P_Output_Format = '||p_output_format);

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

1577: populate_formats;
1578: populate_sob;
1579:
1580: IF (g_print_debug) THEN
1581: fa_rx_util_pkg.debug('is_multi_format_report: ' || '** Populate parameters');
1582: END IF;
1583: IF Upper(p_request_type) = 'PUBLISH' THEN
1584: populate_parameters('PUBLISH', p_request_id);
1585: ELSE

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

1594:
1595: Validate_Report;
1596:
1597: IF (g_print_debug) THEN
1598: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.init_request()-');
1599: END IF;
1600: end init_request;
1601:
1602: ------------------------------------------------------------------

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

1715: t_conc_request_id varchar2(20);
1716: conc_request_id number;
1717: begin
1718: IF (g_print_debug) THEN
1719: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Init_report()+');
1720: END IF;
1721: populate_report(
1722: null, -- Request ID
1723: p_report_id,

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

1725: p_output_format);
1726:
1727: fnd_profile.get('CONC_REQUEST_ID', t_conc_request_id);
1728: IF (g_print_debug) THEN
1729: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Concurrent request_id = '||t_conc_request_id);
1730: END IF;
1731:
1732: if t_conc_request_id is null then
1733: m_report.conc_appname := NULL;

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

1855: populate_formats;
1856: populate_sob;
1857:
1858: IF (g_print_debug) THEN
1859: fa_rx_util_pkg.debug('is_multi_format_report: ' || '** Populate parameters');
1860: END IF;
1861: if t_conc_request_id is NOT null then
1862: -- If request ID is null then we just won't print the parameters.
1863: -- Include this form debuggin purposes

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

1865: END IF;
1866:
1867: Validate_Report;
1868: IF (g_print_debug) THEN
1869: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Init_report()-');
1870: END IF;
1871: end init_report;
1872:
1873: ------------------------------------------------------------------

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

2080: cnt number;
2081: idx number;
2082: begin
2083: IF (g_print_debug) THEN
2084: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.get_summary_column_count('||to_char(p_break_level)||')+');
2085: END IF;
2086:
2087: idx := 1;
2088: loop

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

2095: s_current_summary_idx := idx;
2096: loop
2097: if idx > m_summary_count then
2098: IF (g_print_debug) THEN
2099: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'idx = '||to_char(idx)||', summary_count='||to_char(m_summary_count));
2100: END IF;
2101: exit;
2102: end if;
2103: IF (g_print_debug) THEN

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

2100: END IF;
2101: exit;
2102: end if;
2103: IF (g_print_debug) THEN
2104: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Checking '||to_char(idx)||' with break level '||to_char(m_summaries(idx).print_level));
2105: END IF;
2106: exit when m_summaries(idx).print_level <> p_break_level;
2107:
2108: idx := idx + 1;

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

2109: cnt := cnt + 1;
2110: end loop;
2111:
2112: IF (g_print_debug) THEN
2113: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.get_summary_column_count('||to_char(cnt)||')-');
2114: END IF;
2115: return cnt;
2116: end get_summary_column_count;
2117:

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

2147: rows number;
2148: dummy varchar2(240);
2149: begin
2150: IF (g_print_debug) THEN
2151: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.START_FORMAT()+');
2152: END IF;
2153:
2154: --
2155: -- Initialize the date/time formats

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

2160: end if;
2161: m_report.submission_date := fnd_date.date_to_displaydt(m_report.real_submission_date);
2162:
2163: IF (g_print_debug) THEN
2164: fa_rx_util_pkg.debug('is_multi_format_report: ' || '-- Populate columns');
2165: END IF;
2166: populate_columns;
2167: IF (g_print_debug) THEN
2168: fa_rx_util_pkg.debug('is_multi_format_report: ' || '-- Populate summaries');

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

2164: fa_rx_util_pkg.debug('is_multi_format_report: ' || '-- Populate columns');
2165: END IF;
2166: populate_columns;
2167: IF (g_print_debug) THEN
2168: fa_rx_util_pkg.debug('is_multi_format_report: ' || '-- Populate summaries');
2169: END IF;
2170: populate_summaries;
2171:
2172: IF (g_print_debug) THEN

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

2169: END IF;
2170: populate_summaries;
2171:
2172: IF (g_print_debug) THEN
2173: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'FA_RX_PUBLISH.start_format()-');
2174: END IF;
2175: end start_format;
2176:
2177: ------------------------------------------------------------------

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

2386: invalid_result_columns exception;
2387: pragma exception_init(invalid_result_columns, -1789);
2388: begin
2389: IF (g_print_debug) THEN
2390: fa_rx_util_pkg.debug('Expand_Complex_Multiformat()+');
2391: END IF;
2392:
2393: sqlstmt := null;
2394: for idx in 1..p_count loop

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

2423: end loop;
2424:
2425:
2426: IF (g_print_debug) THEN
2427: fa_rx_util_pkg.debug('Expand_Complex_Multiformat: ' || '
2428: '||sqlstmt||'
2429: ');
2430: END IF;
2431:

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

2434: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
2435: exception
2436: when invalid_result_columns then
2437: IF (g_print_debug) THEN
2438: fa_rx_util_pkg.debug('Expand_Complex_Multiformat: ' || 'Cannot use complex mode for these sets of reports');
2439: END IF;
2440: fnd_message.set_name('OFA', 'FA_RX_INVALID_USE_OF_COMPLEX');
2441: app_exception.raise_exception;
2442: end;

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

2475: m_formats(m_format_count) := p_formats(idx);
2476: m_formats(m_format_count).where_clause := where_clause;
2477:
2478: IF (g_print_debug) THEN
2479: fa_rx_util_pkg.debug('Expand_Complex_Multiformat: ' || where_clause);
2480: END IF;
2481: end loop;
2482: end loop;
2483:

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

2559: for i in 1..m_format_count loop
2560: pos := 0;
2561: line := 0;
2562: if not calculate_pos(i, 'Y', m_report.page_width, last_pos, last_line) then
2563: -- fa_rx_util_pkg.Log(fnd_message.get);
2564: app_exception.raise_exception;
2565: end if;
2566: pos := last_pos;
2567: line := last_line;

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

2567: line := last_line;
2568:
2569: if m_formats(i).group_display_type = 'GROUP LEFT' then
2570: if not calculate_pos(i, 'N', m_report.page_width - 2 - pos, last_pos, last_line) then
2571: fa_rx_util_pkg.debug(fnd_message.get);
2572: fnd_message.set_name('OFA', 'FA_RX_GROUP_ABOVE_USED');
2573: fa_rx_util_pkg.log(fnd_message.get);
2574:
2575: m_formats(i).group_display_type := 'GROUP ABOVE';

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

2569: if m_formats(i).group_display_type = 'GROUP LEFT' then
2570: if not calculate_pos(i, 'N', m_report.page_width - 2 - pos, last_pos, last_line) then
2571: fa_rx_util_pkg.debug(fnd_message.get);
2572: fnd_message.set_name('OFA', 'FA_RX_GROUP_ABOVE_USED');
2573: fa_rx_util_pkg.log(fnd_message.get);
2574:
2575: m_formats(i).group_display_type := 'GROUP ABOVE';
2576: else
2577: line := line + last_line - 1;

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

2579: end if;
2580:
2581: if m_formats(i).group_display_type = 'GROUP ABOVE' then
2582: if not calculate_pos(i, 'N', m_report.page_width, last_pos, last_line) then
2583: -- fa_rx_util_pkg.Log(fnd_message.get);
2584: app_exception.raise_exception;
2585: else
2586: line := line + last_line;
2587: end if;

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

2596: if m_report.page_height <> 0 then
2597: -- Check page height
2598: if max_lines*2 + 20 > m_report.page_height then
2599: fnd_message.set_name('OFA', 'FA_RX_PAGE_HEIGHT_TOO_SMALL');
2600: -- fa_rx_util_pkg.Log(fnd_message.get);
2601: app_exception.raise_exception;
2602: end if;
2603: end if;
2604:

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

2631: BEGIN
2632: FOR i IN 1..get_bind_count LOOP
2633: v := get_bind_variable;
2634: IF (g_print_debug) THEN
2635: fa_rx_util_pkg.debug('bind_variables: ' || 'Bind :b'||To_char(i)||' => '||v);
2636: END IF;
2637: dbms_sql.bind_variable(c, ':b'||To_char(i), v);
2638: END LOOP;
2639: END bind_variables;

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

2677: xMoac_Message := Null;
2678:
2679: for s_current_param_idx in m_params_with_actual_value.first..m_params_with_actual_value.last
2680: LOOP
2681: fa_rx_util_pkg.debug(' name = '||m_params_with_actual_value(s_current_param_idx).name );
2682: fa_rx_util_pkg.debug(' value = '||m_params_with_actual_value(s_current_param_idx).value );
2683: fa_rx_util_pkg.debug(' display_flag = '||m_params_with_actual_value(s_current_param_idx).display_flag );
2684: fa_rx_util_pkg.debug(' format_type = '||m_params_with_actual_value(s_current_param_idx).format_type );
2685: fa_rx_util_pkg.debug(' flex_value_set_id = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_id );

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

2678:
2679: for s_current_param_idx in m_params_with_actual_value.first..m_params_with_actual_value.last
2680: LOOP
2681: fa_rx_util_pkg.debug(' name = '||m_params_with_actual_value(s_current_param_idx).name );
2682: fa_rx_util_pkg.debug(' value = '||m_params_with_actual_value(s_current_param_idx).value );
2683: fa_rx_util_pkg.debug(' display_flag = '||m_params_with_actual_value(s_current_param_idx).display_flag );
2684: fa_rx_util_pkg.debug(' format_type = '||m_params_with_actual_value(s_current_param_idx).format_type );
2685: fa_rx_util_pkg.debug(' flex_value_set_id = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_id );
2686: fa_rx_util_pkg.debug(' flex_value_set_name = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_name );

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

2679: for s_current_param_idx in m_params_with_actual_value.first..m_params_with_actual_value.last
2680: LOOP
2681: fa_rx_util_pkg.debug(' name = '||m_params_with_actual_value(s_current_param_idx).name );
2682: fa_rx_util_pkg.debug(' value = '||m_params_with_actual_value(s_current_param_idx).value );
2683: fa_rx_util_pkg.debug(' display_flag = '||m_params_with_actual_value(s_current_param_idx).display_flag );
2684: fa_rx_util_pkg.debug(' format_type = '||m_params_with_actual_value(s_current_param_idx).format_type );
2685: fa_rx_util_pkg.debug(' flex_value_set_id = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_id );
2686: fa_rx_util_pkg.debug(' flex_value_set_name = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_name );
2687: fa_rx_util_pkg.debug(' param_idx = '||m_params_with_actual_value(s_current_param_idx).param_idx );

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

2680: LOOP
2681: fa_rx_util_pkg.debug(' name = '||m_params_with_actual_value(s_current_param_idx).name );
2682: fa_rx_util_pkg.debug(' value = '||m_params_with_actual_value(s_current_param_idx).value );
2683: fa_rx_util_pkg.debug(' display_flag = '||m_params_with_actual_value(s_current_param_idx).display_flag );
2684: fa_rx_util_pkg.debug(' format_type = '||m_params_with_actual_value(s_current_param_idx).format_type );
2685: fa_rx_util_pkg.debug(' flex_value_set_id = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_id );
2686: fa_rx_util_pkg.debug(' flex_value_set_name = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_name );
2687: fa_rx_util_pkg.debug(' param_idx = '||m_params_with_actual_value(s_current_param_idx).param_idx );
2688: fa_rx_util_pkg.debug(' column_name = '||m_params_with_actual_value(s_current_param_idx).column_name );

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

2681: fa_rx_util_pkg.debug(' name = '||m_params_with_actual_value(s_current_param_idx).name );
2682: fa_rx_util_pkg.debug(' value = '||m_params_with_actual_value(s_current_param_idx).value );
2683: fa_rx_util_pkg.debug(' display_flag = '||m_params_with_actual_value(s_current_param_idx).display_flag );
2684: fa_rx_util_pkg.debug(' format_type = '||m_params_with_actual_value(s_current_param_idx).format_type );
2685: fa_rx_util_pkg.debug(' flex_value_set_id = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_id );
2686: fa_rx_util_pkg.debug(' flex_value_set_name = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_name );
2687: fa_rx_util_pkg.debug(' param_idx = '||m_params_with_actual_value(s_current_param_idx).param_idx );
2688: fa_rx_util_pkg.debug(' column_name = '||m_params_with_actual_value(s_current_param_idx).column_name );
2689: fa_rx_util_pkg.debug(' operator = '||m_params_with_actual_value(s_current_param_idx).operator );

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

2682: fa_rx_util_pkg.debug(' value = '||m_params_with_actual_value(s_current_param_idx).value );
2683: fa_rx_util_pkg.debug(' display_flag = '||m_params_with_actual_value(s_current_param_idx).display_flag );
2684: fa_rx_util_pkg.debug(' format_type = '||m_params_with_actual_value(s_current_param_idx).format_type );
2685: fa_rx_util_pkg.debug(' flex_value_set_id = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_id );
2686: fa_rx_util_pkg.debug(' flex_value_set_name = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_name );
2687: fa_rx_util_pkg.debug(' param_idx = '||m_params_with_actual_value(s_current_param_idx).param_idx );
2688: fa_rx_util_pkg.debug(' column_name = '||m_params_with_actual_value(s_current_param_idx).column_name );
2689: fa_rx_util_pkg.debug(' operator = '||m_params_with_actual_value(s_current_param_idx).operator );
2690:

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

2683: fa_rx_util_pkg.debug(' display_flag = '||m_params_with_actual_value(s_current_param_idx).display_flag );
2684: fa_rx_util_pkg.debug(' format_type = '||m_params_with_actual_value(s_current_param_idx).format_type );
2685: fa_rx_util_pkg.debug(' flex_value_set_id = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_id );
2686: fa_rx_util_pkg.debug(' flex_value_set_name = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_name );
2687: fa_rx_util_pkg.debug(' param_idx = '||m_params_with_actual_value(s_current_param_idx).param_idx );
2688: fa_rx_util_pkg.debug(' column_name = '||m_params_with_actual_value(s_current_param_idx).column_name );
2689: fa_rx_util_pkg.debug(' operator = '||m_params_with_actual_value(s_current_param_idx).operator );
2690:
2691: If (m_params_with_actual_value(s_current_param_idx).flex_value_set_name = 'FND_MO_REPORTING_LEVEL') Then

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

2684: fa_rx_util_pkg.debug(' format_type = '||m_params_with_actual_value(s_current_param_idx).format_type );
2685: fa_rx_util_pkg.debug(' flex_value_set_id = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_id );
2686: fa_rx_util_pkg.debug(' flex_value_set_name = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_name );
2687: fa_rx_util_pkg.debug(' param_idx = '||m_params_with_actual_value(s_current_param_idx).param_idx );
2688: fa_rx_util_pkg.debug(' column_name = '||m_params_with_actual_value(s_current_param_idx).column_name );
2689: fa_rx_util_pkg.debug(' operator = '||m_params_with_actual_value(s_current_param_idx).operator );
2690:
2691: If (m_params_with_actual_value(s_current_param_idx).flex_value_set_name = 'FND_MO_REPORTING_LEVEL') Then
2692: l_Reporting_Level := m_params_with_actual_value(s_current_param_idx).value;

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

2685: fa_rx_util_pkg.debug(' flex_value_set_id = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_id );
2686: fa_rx_util_pkg.debug(' flex_value_set_name = '||m_params_with_actual_value(s_current_param_idx).flex_value_set_name );
2687: fa_rx_util_pkg.debug(' param_idx = '||m_params_with_actual_value(s_current_param_idx).param_idx );
2688: fa_rx_util_pkg.debug(' column_name = '||m_params_with_actual_value(s_current_param_idx).column_name );
2689: fa_rx_util_pkg.debug(' operator = '||m_params_with_actual_value(s_current_param_idx).operator );
2690:
2691: If (m_params_with_actual_value(s_current_param_idx).flex_value_set_name = 'FND_MO_REPORTING_LEVEL') Then
2692: l_Reporting_Level := m_params_with_actual_value(s_current_param_idx).value;
2693: End If;

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

2695: l_reporting_entity_id := m_params_with_actual_value(s_current_param_idx).value;
2696: End If;
2697: END LOOP;
2698:
2699: fa_rx_util_pkg.debug(' l_Reporting_Level = '||l_Reporting_Level);
2700: fa_rx_util_pkg.debug(' l_reporting_entity_id = '||l_reporting_entity_id);
2701:
2702: If to_number(l_Reporting_Level) = 1000 Then --* if 1000, then it means it is legal entity.
2703: 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 2700: fa_rx_util_pkg.debug(' l_reporting_entity_id = '||l_reporting_entity_id);

2696: End If;
2697: END LOOP;
2698:
2699: fa_rx_util_pkg.debug(' l_Reporting_Level = '||l_Reporting_Level);
2700: fa_rx_util_pkg.debug(' l_reporting_entity_id = '||l_reporting_entity_id);
2701:
2702: If to_number(l_Reporting_Level) = 1000 Then --* if 1000, then it means it is legal entity.
2703: l_ld_sp:= mo_utils.check_ledger_in_sp(TO_NUMBER(l_reporting_entity_id)); --* if 1000, then use the p_reporting_entity_id
2704: IF l_ld_sp = 'N' THEN

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

2705: FND_MESSAGE.SET_NAME('FND','FND_MO_RPT_PARTIAL_LEDGER');
2706: xMoac_Message :=FND_MESSAGE.get;
2707: END IF;
2708: END IF;
2709: fa_rx_util_pkg.debug(' xMoac_Message = '||xMoac_Message);
2710: Exception
2711: When Others Then
2712: xMoac_Message := Null;
2713: fa_rx_util_pkg.debug(' In exception xMoac_Message = '||xMoac_Message);

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

2709: fa_rx_util_pkg.debug(' xMoac_Message = '||xMoac_Message);
2710: Exception
2711: When Others Then
2712: xMoac_Message := Null;
2713: fa_rx_util_pkg.debug(' In exception xMoac_Message = '||xMoac_Message);
2714: End get_Moac_Message;
2715:
2716: end fa_rx_publish;