DBA Data[Home] [Help]

APPS.QA_CHAR_INDEXES_PKG dependencies on FND_FILE

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

883: l_return NUMBER;
884:
885: BEGIN
886:
887: fnd_file.put_line(fnd_file.log, 'qa_char_indexes_pkg: entered the wrapper');
888:
889: l_type_of_action := to_number(argument1);
890: l_char_id := to_number(argument3);
891:

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

889: l_type_of_action := to_number(argument1);
890: l_char_id := to_number(argument3);
891:
892: IF l_type_of_action = 1 THEN
893: fnd_file.put_line(fnd_file.log, 'Create or Regnerate the Index');
894:
895: l_return := create_or_regenerate_index(
896: p_char_id => l_char_id,
897: p_index_name => argument2,

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

897: p_index_name => argument2,
898: p_additional_parameters => argument4);
899:
900: IF (l_return = 0) THEN
901: fnd_file.put_line(fnd_file.log, 'Index successfully created');
902: errbuf := '';
903: retcode := 0;
904: ELSE
905: fnd_file.put_line(fnd_file.log, 'Index creation failed. ERROR:'||to_char(l_return));

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

901: fnd_file.put_line(fnd_file.log, 'Index successfully created');
902: errbuf := '';
903: retcode := 0;
904: ELSE
905: fnd_file.put_line(fnd_file.log, 'Index creation failed. ERROR:'||to_char(l_return));
906: errbuf := 'ERROR:'||to_char(l_return);
907: retcode := 2;
908: END IF;
909:

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

908: END IF;
909:
910:
911: ELSIF (l_type_of_action = 2) THEN
912: fnd_file.put_line(fnd_file.log, 'Drop the Index');
913:
914: l_return := drop_index(
915: p_char_id => l_char_id);
916:

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

914: l_return := drop_index(
915: p_char_id => l_char_id);
916:
917: IF (l_return = 0) THEN
918: fnd_file.put_line(fnd_file.log, 'Index successfully dropped');
919: errbuf := '';
920: retcode := 0;
921: ELSE
922: fnd_file.put_line(fnd_file.log, 'Index failed to drop. ERROR:'||to_char(l_return));

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

918: fnd_file.put_line(fnd_file.log, 'Index successfully dropped');
919: errbuf := '';
920: retcode := 0;
921: ELSE
922: fnd_file.put_line(fnd_file.log, 'Index failed to drop. ERROR:'||to_char(l_return));
923: errbuf := 'ERROR:'||to_char(l_return);
924: retcode := 2;
925: END IF;
926: END IF;

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

924: retcode := 2;
925: END IF;
926: END IF;
927:
928: fnd_file.put_line(fnd_file.log, 'qa_char_indexes_pkg: exiting the wrapper');
929:
930: END wrapper;
931:
932: