DBA Data[Home] [Help]

APPS.QA_CHAR_INDEXES_PKG dependencies on FND_FILE

Line 706: fnd_file.put_line(fnd_file.log, 'qa_char_indexes_pkg: entered the wrapper');

702: l_return NUMBER;
703:
704: BEGIN
705:
706: fnd_file.put_line(fnd_file.log, 'qa_char_indexes_pkg: entered the wrapper');
707:
708: l_type_of_action := to_number(argument1);
709: l_char_id := to_number(argument3);
710:

Line 712: fnd_file.put_line(fnd_file.log, 'Create or Regnerate the Index');

708: l_type_of_action := to_number(argument1);
709: l_char_id := to_number(argument3);
710:
711: IF l_type_of_action = 1 THEN
712: fnd_file.put_line(fnd_file.log, 'Create or Regnerate the Index');
713:
714: l_return := create_or_regenerate_index(
715: p_char_id => l_char_id,
716: p_index_name => argument2,

Line 720: fnd_file.put_line(fnd_file.log, 'Index successfully created');

716: p_index_name => argument2,
717: p_additional_parameters => argument4);
718:
719: IF (l_return = 0) THEN
720: fnd_file.put_line(fnd_file.log, 'Index successfully created');
721: errbuf := '';
722: retcode := 0;
723: ELSE
724: fnd_file.put_line(fnd_file.log, 'Index creation failed. ERROR:'||to_char(l_return));

Line 724: fnd_file.put_line(fnd_file.log, 'Index creation failed. ERROR:'||to_char(l_return));

720: fnd_file.put_line(fnd_file.log, 'Index successfully created');
721: errbuf := '';
722: retcode := 0;
723: ELSE
724: fnd_file.put_line(fnd_file.log, 'Index creation failed. ERROR:'||to_char(l_return));
725: errbuf := 'ERROR:'||to_char(l_return);
726: retcode := 2;
727: END IF;
728:

Line 731: fnd_file.put_line(fnd_file.log, 'Drop the Index');

727: END IF;
728:
729:
730: ELSIF (l_type_of_action = 2) THEN
731: fnd_file.put_line(fnd_file.log, 'Drop the Index');
732:
733: l_return := drop_index(
734: p_char_id => l_char_id);
735:

Line 737: fnd_file.put_line(fnd_file.log, 'Index successfully dropped');

733: l_return := drop_index(
734: p_char_id => l_char_id);
735:
736: IF (l_return = 0) THEN
737: fnd_file.put_line(fnd_file.log, 'Index successfully dropped');
738: errbuf := '';
739: retcode := 0;
740: ELSE
741: fnd_file.put_line(fnd_file.log, 'Index failed to drop. ERROR:'||to_char(l_return));

Line 741: fnd_file.put_line(fnd_file.log, 'Index failed to drop. ERROR:'||to_char(l_return));

737: fnd_file.put_line(fnd_file.log, 'Index successfully dropped');
738: errbuf := '';
739: retcode := 0;
740: ELSE
741: fnd_file.put_line(fnd_file.log, 'Index failed to drop. ERROR:'||to_char(l_return));
742: errbuf := 'ERROR:'||to_char(l_return);
743: retcode := 2;
744: END IF;
745: END IF;

Line 747: fnd_file.put_line(fnd_file.log, 'qa_char_indexes_pkg: exiting the wrapper');

743: retcode := 2;
744: END IF;
745: END IF;
746:
747: fnd_file.put_line(fnd_file.log, 'qa_char_indexes_pkg: exiting the wrapper');
748:
749: END wrapper;
750:
751: