APPS.FA_RX_SHARED_PKG dependencies on FA_RX_UTIL_PKG

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

1183:
1184: replace_string := replace_string||src;
1185:
1186: IF (g_print_debug) THEN
1187: fa_rx_util_pkg.debug('Initialize_Where: ' || src);
1188: END IF;
1189:
1190: where_clause := REPLACE(where_clause, replace_string, ''''||value||'''');
1191: END LOOP;

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

1190: where_clause := REPLACE(where_clause, replace_string, ''''||value||'''');
1191: END LOOP;
1192:
1193: IF (g_print_debug) THEN
1194: fa_rx_util_pkg.debug('Initialize_Where: ' || where_clause);
1195: END IF;
1196:
1197: if v_flex_value is Not null then
1198: fa_rx_util_pkg.debug('Initialize_Where: to change the where clause for long list ' ||where_clause);

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

1194: fa_rx_util_pkg.debug('Initialize_Where: ' || where_clause);
1195: END IF;
1196:
1197: if v_flex_value is Not null then
1198: fa_rx_util_pkg.debug('Initialize_Where: to change the where clause for long list ' ||where_clause);
1199: where_clause := upper(nvl(where_clause,'WHERE 1=1'));
1200: where_clause := substr(where_clause,instr(where_clause,'WHERE')+5);
1201: where_clause := ' WHERE to_char('||vset.table_info.value_column_name||') = '||''''||v_flex_value||''''||' AND '||where_clause;
1202: end if;

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

1200: where_clause := substr(where_clause,instr(where_clause,'WHERE')+5);
1201: where_clause := ' WHERE to_char('||vset.table_info.value_column_name||') = '||''''||v_flex_value||''''||' AND '||where_clause;
1202: end if;
1203:
1204: fa_rx_util_pkg.debug('Initialize_Where: after ** ' ||where_clause);
1205:
1206: vset.table_info.where_clause := where_clause;
1207:
1208: end initialize_where;

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

1273:
1274: end if;
1275:
1276: IF (g_print_debug) THEN
1277: fa_rx_util_pkg.debug('get_flex_val_meaning: ' || 'Caching values for value set '||vsname);
1278: END IF;
1279: /* Search PL/SQL tables for valuesets and values that have already been loaded */
1280:
1281: if (g_value_set_counter >= 1)

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

1322:
1323: g_value_counter := g_value_counter + 1;
1324:
1325: /* Store flex values away */
1326: fa_rx_util_pkg.debug(':Meaning = '||Nvl(value.meaning, '<<>>')||', Value = '||value.value||':');
1327: g_values_tab(g_value_counter).meaning := substr(nvl(value.meaning, value.value), 1, 240);
1328: g_values_tab(g_value_counter).value := substr(Nvl(value.id, value.value), 1, 150);
1329: g_value_set_tab(g_value_set_counter).to_counter := g_value_counter;
1330:

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

1358: fnd_vset.get_value_end(vset);
1359: return(v_flex_value);
1360: WHEN OTHERS THEN
1361: IF (g_print_debug) THEN
1362: fa_rx_util_pkg.debug('EXCEPTION in get_flex_val_meaning');
1363: fa_rx_util_pkg.debug('get_flex_val_meaning: ' || sqlerrm);
1364: END IF;
1365: -- return(NULL);
1366: return(v_flex_value);

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

1359: return(v_flex_value);
1360: WHEN OTHERS THEN
1361: IF (g_print_debug) THEN
1362: fa_rx_util_pkg.debug('EXCEPTION in get_flex_val_meaning');
1363: fa_rx_util_pkg.debug('get_flex_val_meaning: ' || sqlerrm);
1364: END IF;
1365: -- return(NULL);
1366: return(v_flex_value);
1367: END get_flex_val_meaning;