Fixed orphaned error nodes

Modified   database/LOGGER/Packages/ms_logger.pkb
--FIX PROCEDURE log_node - passed i_parent_index - uses to find parent_traversal_id
--FIX PROCEDURE dump_nodes - passes i_parent_index to log_node (using g_nodes.PRIOR(i_index))
--FIX PROCEDURE create_traversal - passes i_parent_index to log_node (using f_index)
NEW Patch: LOG-01_08A_08B_LOGGER - Fixed orphaned error nodes
Create message mode "Disabled"

Modified   apex/f104/application/pages/page_00008.sql
--ADD P8_SHOW_MODULE_YN and use it to display modules optionally in the tree.
Modified   apex/f104/application/pages/page_00009.sql
--Add to 'MODULE_TYPE' list "Disabled"
--Enhance Std Report mode to
--Set Report Library Modules to Disabled
--Set Report Library Units to Overridden
--"Reports are now in Standard mode.
--IE Reports will open processes in Normal mode, and 'get_parameters' is set to Debug.
--Report Libraries are set to disabled, to keep the tree neater."

Modified   apex/f104/application/pages/page_00010.sql
--Add to 'UNIT_TYPE' list "Disabled"

Modified   database/LOGGER/Packages/ms_logger.pkb
Modified   database/LOGGER/Packages/ms_logger.pks
--NEW constant G_UNIT_TYPE_SQL, G_MODULE_TYPE_SQL
--MOD PROCEDURE  log_message - skip disabled nodes.
--MOD PROCEDURE create_ref   - skip disabled nodes.
--NEW PROCEDURE  set_unit_disabled
--MOD PROCEDURE create_traversal - create disabled nodes, but don't log them or stack them
--NEW FUNCTION new_script
NEW Patch: LOG-04_01A_01B_LOGGER - Create message mode
Fix patch LOG-04_01A_01B_LOGGER

Was not writing any messages as it was testing wrong msg_mode, now deleted.

Modified   database/LOGGER/Packages/ms_logger.pkb
Modified   database/LOGGER/Packages/ms_logger.pks
Modified   patch/feature/logger/LOG-04/LOG-04_01A_01B_LOGGER/ms_logger.pkb
Modified   patch/feature/logger/LOG-04/LOG-04_01A_01B_LOGGER/ms_logger.pks
--FIX TYPE node_typ - DEL msg_mode, tests now check i_node.traversal.msg_mode
Add an Owner selector to the Logger Control

Modified   apex/f104/application/pages/page_00009.sql
--Add an Owner selector - defaults to MIN not LOGGER schema
--Module list will show nothing if no owner selected. (which should be rare)
--Add an 'ALL_DISABLED' button.
--Limit processes that update records to the selected owner.
Drop tables to recreate with new constraints

Modified   database/LOGGER/Tables/ms_tables.tab
Refactor with just 1 message Tables/ms_tables.tab

1st draft

Modified   database/LOGGER/Packages/ms_logger.pks
--REPLACE TYPE ref_list with TYPE message_list
--MOD TYPE node_typ now has a unlogged_messages list
--NEW Constants
--  G_MSG_TYPE_PARAM
--  G_MSG_TYPE_NOTE
--  G_MSG_TYPE_MESSAGE
Modified   database/LOGGER/Packages/ms_logger.pkb
--MOD PROCEDURE err_create_internal_error - i_message now CLOB, inserts into ms_message
--MOD PROCEDURE log_node - now handles unlogged_messages
--REPLACE PROCEDURE log_ref with PROCEDURE log_message (DEL former log_message after incorporating some of its logic)
--REPLACE PROCEDURE push_ref with PROCEDURE push_message
--REPLACE PROCEDURE create_ref with PROCEDURE create_message
--MOD PROCEDURE debug_error - uses message create_message
--MOD PROCEDURE create_ref - now simply calls create_message
--MOD PROCEDURE purge_old_processes - now deletes from just ms_process
--MOD PROCEDUREs comment, info, warning, fatal uses create_message.
--  Remove i_raise_app_error param. and PROCEDURE app_error
--MOD ref procedures, removed i_desc param - not needed.
Modified   database/LOGGER/Tables/ms_tables.tab
--MOD TABLE MS_MESSAGE - now includes NAME and MSG_TYPE. TIME_NOW is a timestamp
--DEL TABLE MS_REFERENCE
--DEL TABLE MS_LARGE_MESSAGE
--DEL TABLE MS_INTERNAL_ERROR
Modified   database/LOGGER/Views/ms_views.vw
--MOD ms_message_vw - now only needs ms_message.
--separates message field into value and message based on length of message and presence of NL
--TEMP MOD ms_unit_vw and ms_module_vw, comment out ms_metacode calls that have been replaced in branch LOG-01 already.
--DEL ms_traversal_ref_vw
--MOD ms_traversal_message_vw - now REPLACES ms_traversal_message_ref_vw
Refactor with just 1 message Tables/ms_tables.tab

Final version

Modified   database/LOGGER/Packages/ms_logger.pkb
--ADD constant G_REF_VALUE_WIDTH
--MOD PROCEDURE create_message - added param - i_value, written to ms_message
--MOD PROCEDURE warn_user_source_error_lines
--Write the source line to a message in the format "LINE NO"  X  TEXT
--Highlight the error line as a WARNING, lines above and below as COMMENT
--PROCEDURE create_ref - decides whether to use the CLOB field or not.
--Short, single line value, so just put it in the value column
--Longer or multi-line value, put it in the message column
Modified   database/LOGGER/Tables/ms_tables.tab
--MOD TABLE MS_MESSAGE - ADD value column
Modified   database/LOGGER/Views/ms_views.vw
--MOD VIEW ms_message_vw - output value and message without CASE.
Finish previous changes - ensure messages and refs logged when message level is reached.

Modified   database/LOGGER/Packages/ms_logger.pkb
--CONVERT PROCEDURE log_message to FUNCTION log_message - returns true if message was logged
--  passed i_node, and uses this to determine whether to log message or not
--  log message when - Node is logged and the message's msg_level is at least as great as node's msg_mode
--MOD PROCEDURE create_message - calls log_message and then push_message if that returns false.
--MOD PROCEDURE log_node
--  Loop thru any unlogged messages, attempting to log each.
--  if successful, then remove message from the list.
Modified   database/LOGGER/UnitTest/ms_test.pkb
--MOD PROCEDURE test_unit_msg_mode - to test changes above
Modified   database/LOGGER/UnitTest/ms_test3.sql
--MOD to test changes above
Remove g_debug_mode, now assume that compile to intlog:true is for debugging

Modified   database/LOGGER/Packages/ms_logger.pkb
Modified   database/LOGGER/Packages/ms_logger.pks
--DEL g_debug_mode
--WRAP COMPILER FLAGGED PROCEDURES in intlog flags
--DEL PROCEDURE set_internal_debug
--DEL PROCEDURE reset_internal_debug
--ADD initialisation --Enable DBMS_OUTPUT when compiled for INTLOG
Modified   database/LOGGER/UnitTest/ms_test3.sql
--Remove calls to set_internal_debug, reset_internal_debug
APEX PX_NUM_ROWS to use a std static rowcount list 1,5,10,15,20,25,30,50,100,200,500,1000,5000

Modified   apex/f104/application/pages/page_00008.sql
--ADD 'P8_NUM_ROWS' with std static list to Process Traces report
Modified   apex/f104/application/pages/page_00009.sql
--MOD 'P9_NUM_ROWS' with std static list, submit on change
--DEL 'P9_GO'
Modified   apex/f104/application/pages/page_00010.sql
--MOD 'P10_NUM_ROWS' with std static list, submit on change
--DEL 'P10_GO'
Modified   database/LOGGER/Tables/ms_tables.tab
--FIX msg_mode on MS_UNIT and MS_MODULE
quick changes to fix last patch.

Modified   database/LOGGER/Packages/aop_processor.pkb --comment out trigger
Modified   database/LOGGER/Packages/aop_processor.pks --comment out trigger
Modified   database/LOGGER/Tables/ms_tables.tab       --Drop tables first
Modified   patch/feature/logger/LOG-01/LOG-01_01A_01B_SYS/install.sql

Conflicts:
	database/LOGGER/Tables/ms_tables.tab
3 Patches
LOG-01_01A_08B_SUN
LOG-01_01A_09B_LOGGER
LOG-01_01A_09B_SYS
Clean up getting rid of ms_metacode and ms_feedback

Modified   database/LOGGER/Packages/aop_processor.pkb
--INC timeout to 60secs per 1000 lines
--fatal errors added to main exceptions.
Modified   database/LOGGER/Packages/ms_logger.pkb
Modified   database/LOGGER/Packages/ms_logger.pks
--MOD FUNCTION object_owner and FUNCTION object_type - exclude SYNONYM
-- FUNCTIONS USED IN VIEWS (copied from ms_metacode)
--NEW FUNCTION msg_level_string
--NEW FUNCTION unit_message_count
--NEW FUNCTION unit_traversal_count
Modified   database/LOGGER/Synonyms/dba_source.syn - include a drop.
Modified   database/LOGGER/Tables/ms_tables.tab - drop in the right order...
Modified   database/LOGGER/UnitTest/aop_test.pkb
Modified   database/LOGGER/UnitTest/aop_test.pks
--Remove ms_feedback
Modified   database/LOGGER/UnitTest/aop_test.sql
--Remove register calls and use new_process as function
Modified   database/LOGGER/UnitTest/ms_test.sql
--Remove register calls and use new_process as function
Modified   database/LOGGER/Views/ms_views.vw
--Remove ms_metacode and reorder views.
Modified   patch/feature/logger/LOG-01/LOG-01_01A_01B_SYS/install.sql
--fixed for unix.

Conflicts:
	database/LOGGER/Packages/ms_logger.pkb
	database/LOGGER/Packages/ms_logger.pks
	database/LOGGER/Tables/ms_tables.tab
	database/LOGGER/Views/ms_views.vw
APEX fix regions in P8

Modified   apex/f104/application/pages/page_00008.sql
--Remove desc from Messages report.
--Add a parent region for processes and traversals regions.
Clean up in prep for full release

Deleted    database/LOGGER/Functions/supported_data_type.fnc - no longer required
Modified   database/LOGGER/Grants/sun.grt
Deleted    database/LOGGER/Packages/ms_feedback.pkb - no longer required
Deleted    database/LOGGER/Packages/ms_feedback.pks - no longer required
Deleted    database/LOGGER/Packages/ms_metacode.pkb - no longer required
Deleted    database/LOGGER/Packages/ms_metacode.pks - no longer required
Deleted    database/LOGGER/Types/sm_types.typ       - no longer required
Modified   database/SUN/Synonyms/logger.syn  - added ms_api, removed ms_feedback
Modified   database/SYS/Users/logger.user    - removed unused and already commented stuff.
Merge branch 'feature/logger/LOG-01' of H:/GitRepos/SmartLogger into feature/logger/LOG-01
NEW Patch: LOG-01_01A_10B_SYS - Install Logger schema
NEW Patch: LOG-01_01A_10B_LOGGER - Install Logger objects