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_SHARED_PKG dependencies on FA_RX_UTIL_PKG

Line 1339: fa_rx_util_pkg.debug('Initialize_Where: ' || src);

1335:
1336: replace_string := replace_string||src;
1337:
1338: IF (g_print_debug) THEN
1339: fa_rx_util_pkg.debug('Initialize_Where: ' || src);
1340: END IF;
1341:
1342: where_clause := REPLACE(where_clause, replace_string, ''''||value||'''');
1343: END LOOP;

Line 1346: fa_rx_util_pkg.debug('Initialize_Where: ' || where_clause);

1342: where_clause := REPLACE(where_clause, replace_string, ''''||value||'''');
1343: END LOOP;
1344:
1345: IF (g_print_debug) THEN
1346: fa_rx_util_pkg.debug('Initialize_Where: ' || where_clause);
1347: END IF;
1348:
1349: if v_flex_value is Not null then
1350: fa_rx_util_pkg.debug('Initialize_Where: to change the where clause for long list ' ||where_clause);

Line 1350: fa_rx_util_pkg.debug('Initialize_Where: to change the where clause for long list ' ||where_clause);

1346: fa_rx_util_pkg.debug('Initialize_Where: ' || where_clause);
1347: END IF;
1348:
1349: if v_flex_value is Not null then
1350: fa_rx_util_pkg.debug('Initialize_Where: to change the where clause for long list ' ||where_clause);
1351: where_clause := upper(nvl(where_clause,'WHERE 1=1'));
1352: where_clause := substr(where_clause,instr(where_clause,'WHERE')+5);
1353: where_clause := ' WHERE to_char('||vset.table_info.value_column_name||') = '||''''||v_flex_value||''''||' AND '||where_clause;
1354: end if;

Line 1356: fa_rx_util_pkg.debug('Initialize_Where: after ** ' ||where_clause);

1352: where_clause := substr(where_clause,instr(where_clause,'WHERE')+5);
1353: where_clause := ' WHERE to_char('||vset.table_info.value_column_name||') = '||''''||v_flex_value||''''||' AND '||where_clause;
1354: end if;
1355:
1356: fa_rx_util_pkg.debug('Initialize_Where: after ** ' ||where_clause);
1357:
1358: vset.table_info.where_clause := where_clause;
1359:
1360: end initialize_where;

Line 1429: fa_rx_util_pkg.debug('get_flex_val_meaning: ' || 'Caching values for value set '||vsname);

1425:
1426: end if;
1427:
1428: IF (g_print_debug) THEN
1429: fa_rx_util_pkg.debug('get_flex_val_meaning: ' || 'Caching values for value set '||vsname);
1430: END IF;
1431: /* Search PL/SQL tables for valuesets and values that have already been loaded */
1432:
1433: if (g_value_set_counter >= 1)

Line 1478: fa_rx_util_pkg.debug(':Meaning = '||Nvl(value.meaning, '<<>>')||', Value = '||value.value||':');

1474:
1475: g_value_counter := g_value_counter + 1;
1476:
1477: /* Store flex values away */
1478: fa_rx_util_pkg.debug(':Meaning = '||Nvl(value.meaning, '<<>>')||', Value = '||value.value||':');
1479: g_values_tab(g_value_counter).meaning := substr(nvl(value.meaning, value.value), 1, 240);
1480: g_values_tab(g_value_counter).value := substr(Nvl(value.id, value.value), 1, 150);
1481: g_value_set_tab(g_value_set_counter).to_counter := g_value_counter;
1482:

Line 1514: fa_rx_util_pkg.debug('EXCEPTION in get_flex_val_meaning');

1510: fnd_vset.get_value_end(vset);
1511: return(v_flex_value);
1512: WHEN OTHERS THEN
1513: IF (g_print_debug) THEN
1514: fa_rx_util_pkg.debug('EXCEPTION in get_flex_val_meaning');
1515: fa_rx_util_pkg.debug('get_flex_val_meaning: ' || sqlerrm);
1516: END IF;
1517: -- return(NULL);
1518: return(v_flex_value);

Line 1515: fa_rx_util_pkg.debug('get_flex_val_meaning: ' || sqlerrm);

1511: return(v_flex_value);
1512: WHEN OTHERS THEN
1513: IF (g_print_debug) THEN
1514: fa_rx_util_pkg.debug('EXCEPTION in get_flex_val_meaning');
1515: fa_rx_util_pkg.debug('get_flex_val_meaning: ' || sqlerrm);
1516: END IF;
1517: -- return(NULL);
1518: return(v_flex_value);
1519: END get_flex_val_meaning;