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_FLEX_PKG dependencies on FA_RX_FLEX_PKG

Line 1: package body fa_rx_flex_pkg as

1: package body fa_rx_flex_pkg as
2: /* $Header: FARXFLXB.pls 120.7.12010000.2 2008/07/31 06:52:03 sbhaskar ship $ */
3:
4: ---------------------------------------------
5: -- Some global types, constants and cursors

Line 221: fa_rx_util_pkg.debug('fa_rx_flex_pkg.separate_segments('||p_values||')+');

217: next_sep number;
218: l_values varchar2(600);
219: begin
220: IF (g_print_debug) THEN
221: fa_rx_util_pkg.debug('fa_rx_flex_pkg.separate_segments('||p_values||')+');
222: END IF;
223:
224: l_values := p_values;
225: i := 1;

Line 239: fa_rx_util_pkg.debug('fa_rx_flex_pkg.separate_segments('||to_char(i-1)||')-');

235:
236: i := i+1;
237: end loop;
238:
239: fa_rx_util_pkg.debug('fa_rx_flex_pkg.separate_segments('||to_char(i-1)||')-');
240: end separate_segments;
241:
242:
243: -------------------------------------------------------------------------

Line 416: fa_rx_util_pkg.debug('fa_rx_flex_pkg.flex_sql()+');

412: l_segnum fnd_id_flex_segments.segment_num%type;
413: l_id_flex_num number;
414: begin
415: IF (g_print_debug) THEN
416: fa_rx_util_pkg.debug('fa_rx_flex_pkg.flex_sql()+');
417: END IF;
418:
419: --
420: -- Check the validity of some of the parameters

Line 518: fa_rx_util_pkg.debug('Error in fa_rx_flex_pkg.flex_sql()');

514: -- One of the arguments MUST be incorrect
515: -- Output the parameters and raise error
516: --
517: IF (g_print_debug) THEN
518: fa_rx_util_pkg.debug('Error in fa_rx_flex_pkg.flex_sql()');
519: fa_rx_util_pkg.debug('flex_sql: ' || 'Application ID = '||to_char(p_application_id));
520: fa_rx_util_pkg.debug('flex_sql: ' || 'ID Flex Code = '||p_id_flex_code);
521: fa_rx_util_pkg.debug('flex_sql: ' || 'ID Flex Num = '||to_char(l_id_flex_num));
522: fa_rx_util_pkg.debug('flex_sql: ' || 'Qualifier = '||p_qualifier);

Line 524: fa_rx_util_pkg.debug('fa_rx_flex_pkg.flex_sql(EXCEPTION)-');

520: fa_rx_util_pkg.debug('flex_sql: ' || 'ID Flex Code = '||p_id_flex_code);
521: fa_rx_util_pkg.debug('flex_sql: ' || 'ID Flex Num = '||to_char(l_id_flex_num));
522: fa_rx_util_pkg.debug('flex_sql: ' || 'Qualifier = '||p_qualifier);
523: fa_rx_util_pkg.debug('flex_sql: ' || ' **** No rows returned **** ');
524: fa_rx_util_pkg.debug('fa_rx_flex_pkg.flex_sql(EXCEPTION)-');
525: END IF;
526: raise invalid_argument;
527: end if;
528:

Line 530: fa_rx_util_pkg.debug('fa_rx_flex_pkg.flex_sql('||buffer||')-');

526: raise invalid_argument;
527: end if;
528:
529: IF (g_print_debug) THEN
530: fa_rx_util_pkg.debug('fa_rx_flex_pkg.flex_sql('||buffer||')-');
531: END IF;
532: return buffer;
533:
534: exception

Line 541: fa_rx_util_pkg.debug('Exception in fa_rx_flex_pkg.flex_sql()');

537: close cflex;
538: end if;
539:
540: IF (g_print_debug) THEN
541: fa_rx_util_pkg.debug('Exception in fa_rx_flex_pkg.flex_sql()');
542: fa_rx_util_pkg.debug('flex_sql: ' || 'Application ID = '||to_char(p_application_id));
543: fa_rx_util_pkg.debug('flex_sql: ' || 'ID Flex Code = '||p_id_flex_code);
544: fa_rx_util_pkg.debug('flex_sql: ' || 'ID Flex Num = '||to_char(l_id_flex_num));
545: fa_rx_util_pkg.debug('flex_sql: ' || 'Table Alias = '||p_table_alias);

Line 551: fa_rx_util_pkg.debug('fa_rx_flex_pkg.flex_sql(EXCEPTION)-');

547: fa_rx_util_pkg.debug('flex_sql: ' || 'Qualifier = '||p_qualifier);
548: fa_rx_util_pkg.debug('flex_sql: ' || 'Function = '||p_function);
549: fa_rx_util_pkg.debug('flex_sql: ' || 'Operand 1 = '||p_operand1);
550: fa_rx_util_pkg.debug('flex_sql: ' || 'Operand 2 = '||p_operand2);
551: fa_rx_util_pkg.debug('fa_rx_flex_pkg.flex_sql(EXCEPTION)-');
552: END IF;
553: raise;
554: end flex_sql;
555:

Line 609: fa_rx_util_pkg.debug('fa_rx_flex_pkg.get_value()+');

605: l_id_flex_num number;
606: l_counter number := 0;
607: begin
608: IF (g_print_debug) THEN
609: fa_rx_util_pkg.debug('fa_rx_flex_pkg.get_value()+');
610: END IF;
611:
612: IF(p_application_id IS NOT NULL AND p_id_flex_code IS NOT NULL AND p_id_flex_num
613: IS NOT NULL AND p_qualifier IS NOT NULL AND p_ccid IS NOT NULL ) THEN

Line 712: fa_rx_util_pkg.log('Error in fa_rx_flex_pkg.get_value()');

708: -- that cflex cursor returned no rows.
709: -- One of the arguments MUST be incorrect
710: -- Output the parameters and raise error
711: --
712: fa_rx_util_pkg.log('Error in fa_rx_flex_pkg.get_value()');
713: fa_rx_util_pkg.log('Application ID = '||to_char(p_application_id));
714: fa_rx_util_pkg.log('ID Flex Code = '||p_id_flex_code);
715: fa_rx_util_pkg.log('ID Flex Num = '||to_char(l_id_flex_num));
716: fa_rx_util_pkg.log('Qualifier = '||p_qualifier);

Line 720: fa_rx_util_pkg.debug('fa_rx_flex_pkg.get_value(EXCEPTION)-');

716: fa_rx_util_pkg.log('Qualifier = '||p_qualifier);
717: fa_rx_util_pkg.log(' **** No rows returned **** ');
718:
719: IF (g_print_debug) THEN
720: fa_rx_util_pkg.debug('fa_rx_flex_pkg.get_value(EXCEPTION)-');
721: END IF;
722: raise invalid_argument;
723: end if;
724:

Line 743: fa_rx_util_pkg.debug('Invalid CCID in fa_rx_flex_pkg.get_value()');

739: rows := dbms_sql.execute(c);
740: rows := dbms_sql.fetch_rows(c);
741: if rows <= 0 then
742: IF (g_print_debug) THEN
743: fa_rx_util_pkg.debug('Invalid CCID in fa_rx_flex_pkg.get_value()');
744: fa_rx_util_pkg.debug('get_value: ' || 'CCID = '||to_char(p_ccid));
745: fa_rx_util_pkg.debug('fa_rx_flex_pkg.get_value(NO_DATA_FOUND)-');
746: END IF;
747: raise no_data_found;

Line 745: fa_rx_util_pkg.debug('fa_rx_flex_pkg.get_value(NO_DATA_FOUND)-');

741: if rows <= 0 then
742: IF (g_print_debug) THEN
743: fa_rx_util_pkg.debug('Invalid CCID in fa_rx_flex_pkg.get_value()');
744: fa_rx_util_pkg.debug('get_value: ' || 'CCID = '||to_char(p_ccid));
745: fa_rx_util_pkg.debug('fa_rx_flex_pkg.get_value(NO_DATA_FOUND)-');
746: END IF;
747: raise no_data_found;
748: end if;
749: dbms_sql.column_value(c, 1, buffer);

Line 753: fa_rx_util_pkg.debug('fa_rx_flex_pkg.get_value('||buffer||')-');

749: dbms_sql.column_value(c, 1, buffer);
750: dbms_sql.close_cursor(c);
751:
752: IF (g_print_debug) THEN
753: fa_rx_util_pkg.debug('fa_rx_flex_pkg.get_value('||buffer||')-');
754: END IF;
755:
756:
757: IF (p_application_id IS NOT NULL AND p_id_flex_code IS NOT NULL AND p_id_flex_num

Line 789: fa_rx_util_pkg.log('Exception in fa_rx_flex_pkg.get_value()');

785: if dbms_sql.is_open(c) then
786: dbms_sql.close_cursor(c);
787: end if;
788:
789: fa_rx_util_pkg.log('Exception in fa_rx_flex_pkg.get_value()');
790: fa_rx_util_pkg.log('Application_ID = ' || to_char(p_Application_ID));
791: fa_rx_util_pkg.log('ID Flex Code = ' || p_ID_Flex_Code);
792: fa_rx_util_pkg.log('ID Flex Num = ' || to_char(l_id_flex_num));
793: fa_rx_util_pkg.log('Qualifier = ' || p_qualifier);

Line 797: fa_rx_util_pkg.debug('fa_rx_flex_pkg.get_value(EXCEPTION)-');

793: fa_rx_util_pkg.log('Qualifier = ' || p_qualifier);
794: fa_rx_util_pkg.log('CCID = ' || to_char(p_ccid));
795:
796: IF (g_print_debug) THEN
797: fa_rx_util_pkg.debug('fa_rx_flex_pkg.get_value(EXCEPTION)-');
798: END IF;
799: raise;
800: end get_value;
801:

Line 1020: end fa_rx_flex_pkg;

1016:
1017: end get_description;
1018:
1019:
1020: end fa_rx_flex_pkg;