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_UTIL_PKG

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 288: fa_rx_util_pkg.debug('get_id_flex_num: ' || 'EXCEPTION ==> Too many structures for APP_ID='||to_char(p_application_id)||', ID_FLEX_CODE='||p_id_flex_code);

284: return l_id_flex_num;
285: exception
286: when too_many_rows then
287: IF (g_print_debug) THEN
288: fa_rx_util_pkg.debug('get_id_flex_num: ' || 'EXCEPTION ==> Too many structures for APP_ID='||to_char(p_application_id)||', ID_FLEX_CODE='||p_id_flex_code);
289: END IF;
290: raise;
291: end get_id_flex_num;
292:

Line 333: fa_rx_util_pkg.debug('get_segment_delimiter: ' || 'EXCEPTION ==> Unable to find segment delimiter!');

329:
330: exception
331: when no_data_found then
332: IF (g_print_debug) THEN
333: fa_rx_util_pkg.debug('get_segment_delimiter: ' || 'EXCEPTION ==> Unable to find segment delimiter!');
334: END IF;
335: raise;
336: end get_segment_delimiter;
337:

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 519: fa_rx_util_pkg.debug('flex_sql: ' || 'Application ID = '||to_char(p_application_id));

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);
523: fa_rx_util_pkg.debug('flex_sql: ' || ' **** No rows returned **** ');

Line 520: fa_rx_util_pkg.debug('flex_sql: ' || 'ID Flex Code = '||p_id_flex_code);

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);
523: fa_rx_util_pkg.debug('flex_sql: ' || ' **** No rows returned **** ');
524: fa_rx_util_pkg.debug('fa_rx_flex_pkg.flex_sql(EXCEPTION)-');

Line 521: fa_rx_util_pkg.debug('flex_sql: ' || 'ID Flex Num = '||to_char(l_id_flex_num));

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);
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;

Line 522: fa_rx_util_pkg.debug('flex_sql: ' || 'Qualifier = '||p_qualifier);

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);
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;

Line 523: fa_rx_util_pkg.debug('flex_sql: ' || ' No rows returned ');

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);
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;

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 542: fa_rx_util_pkg.debug('flex_sql: ' || 'Application ID = '||to_char(p_application_id));

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);
546: fa_rx_util_pkg.debug('flex_sql: ' || 'Mode = '||p_mode);

Line 543: fa_rx_util_pkg.debug('flex_sql: ' || 'ID Flex Code = '||p_id_flex_code);

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);
546: fa_rx_util_pkg.debug('flex_sql: ' || 'Mode = '||p_mode);
547: fa_rx_util_pkg.debug('flex_sql: ' || 'Qualifier = '||p_qualifier);

Line 544: fa_rx_util_pkg.debug('flex_sql: ' || 'ID Flex Num = '||to_char(l_id_flex_num));

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);
546: fa_rx_util_pkg.debug('flex_sql: ' || 'Mode = '||p_mode);
547: fa_rx_util_pkg.debug('flex_sql: ' || 'Qualifier = '||p_qualifier);
548: fa_rx_util_pkg.debug('flex_sql: ' || 'Function = '||p_function);

Line 545: fa_rx_util_pkg.debug('flex_sql: ' || 'Table Alias = '||p_table_alias);

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);
546: fa_rx_util_pkg.debug('flex_sql: ' || 'Mode = '||p_mode);
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);

Line 546: fa_rx_util_pkg.debug('flex_sql: ' || 'Mode = '||p_mode);

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);
546: fa_rx_util_pkg.debug('flex_sql: ' || 'Mode = '||p_mode);
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);

Line 547: fa_rx_util_pkg.debug('flex_sql: ' || 'Qualifier = '||p_qualifier);

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);
546: fa_rx_util_pkg.debug('flex_sql: ' || 'Mode = '||p_mode);
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)-');

Line 548: fa_rx_util_pkg.debug('flex_sql: ' || 'Function = '||p_function);

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);
546: fa_rx_util_pkg.debug('flex_sql: ' || 'Mode = '||p_mode);
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;

Line 549: fa_rx_util_pkg.debug('flex_sql: ' || 'Operand 1 = '||p_operand1);

545: fa_rx_util_pkg.debug('flex_sql: ' || 'Table Alias = '||p_table_alias);
546: fa_rx_util_pkg.debug('flex_sql: ' || 'Mode = '||p_mode);
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;

Line 550: fa_rx_util_pkg.debug('flex_sql: ' || 'Operand 2 = '||p_operand2);

546: fa_rx_util_pkg.debug('flex_sql: ' || 'Mode = '||p_mode);
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;

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 713: fa_rx_util_pkg.log('Application ID = '||to_char(p_application_id));

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);
717: fa_rx_util_pkg.log(' **** No rows returned **** ');

Line 714: fa_rx_util_pkg.log('ID Flex Code = '||p_id_flex_code);

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);
717: fa_rx_util_pkg.log(' **** No rows returned **** ');
718:

Line 715: fa_rx_util_pkg.log('ID Flex Num = '||to_char(l_id_flex_num));

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);
717: fa_rx_util_pkg.log(' **** No rows returned **** ');
718:
719: IF (g_print_debug) THEN

Line 716: fa_rx_util_pkg.log('Qualifier = '||p_qualifier);

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);
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)-');

Line 717: fa_rx_util_pkg.log(' No rows returned ');

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);
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;

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 728: fa_rx_util_pkg.debug('get_value: ' || 'Executing SELECT...');

724:
725: sqlstmt := 'SELECT '||sqlstmt||' FROM '||l_table_name||' WHERE '||l_unique_id_column_name||' = :ccid';
726: close cflex;
727: IF (g_print_debug) THEN
728: fa_rx_util_pkg.debug('get_value: ' || 'Executing SELECT...');
729: fa_rx_util_pkg.debug('get_value: ' || sqlstmt);
730: END IF;
731:
732: --

Line 729: fa_rx_util_pkg.debug('get_value: ' || sqlstmt);

725: sqlstmt := 'SELECT '||sqlstmt||' FROM '||l_table_name||' WHERE '||l_unique_id_column_name||' = :ccid';
726: close cflex;
727: IF (g_print_debug) THEN
728: fa_rx_util_pkg.debug('get_value: ' || 'Executing SELECT...');
729: fa_rx_util_pkg.debug('get_value: ' || sqlstmt);
730: END IF;
731:
732: --
733: -- We have the SELECT statement.

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 744: fa_rx_util_pkg.debug('get_value: ' || 'CCID = '||to_char(p_ccid));

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;
748: end if;

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 790: fa_rx_util_pkg.log('Application_ID = ' || to_char(p_Application_ID));

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);
794: fa_rx_util_pkg.log('CCID = ' || to_char(p_ccid));

Line 791: fa_rx_util_pkg.log('ID Flex Code = ' || p_ID_Flex_Code);

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);
794: fa_rx_util_pkg.log('CCID = ' || to_char(p_ccid));
795:

Line 792: fa_rx_util_pkg.log('ID Flex Num = ' || to_char(l_id_flex_num));

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);
794: fa_rx_util_pkg.log('CCID = ' || to_char(p_ccid));
795:
796: IF (g_print_debug) THEN

Line 793: fa_rx_util_pkg.log('Qualifier = ' || p_qualifier);

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);
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)-');

Line 794: fa_rx_util_pkg.log('CCID = ' || to_char(p_ccid));

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);
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;

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: