1 PACKAGE GME_DEBUG AS
2 /* $Header: GMEUDBGS.pls 120.2 2005/10/03 07:31:45 creddy noship $ */
3 /*
4 REM *********************************************************************
5 REM *
6 REM * FILE: GMEUDBGS.pls
7 REM * PURPOSE: Package Specification for the GME degug utilities
8 REM * AUTHOR: Olivier DABOVAL, OPM Development
9 REM * DATE: 27th May 2001
10 REM *
11 REM * PROCEDURE log_initialize
12 REM * PROCEDURE put_line
13 REM *
14 REM *
15 REM * HISTORY:
16 REM * ========
17 REM * 31-May-2001 Olivier DABOVAL
18 REM * Created
19 REM *
20 REM **********************************************************************
21 */
22
23 --===================
24 -- CONSTANTS
25 --===================
26
27 G_LOG_ERROR CONSTANT NUMBER := 5;
28 G_LOG_EXCEPTION CONSTANT NUMBER := 4;
29 G_LOG_EVENT CONSTANT NUMBER := 3;
30 G_LOG_PROCEDURE CONSTANT NUMBER := 2;
31 G_LOG_STATEMENT CONSTANT NUMBER := 1;
32 --Rishi Varma B3865212 30/09/2004.
33 G_LOG_UNEXPECTED CONSTANT NUMBER := 6;
34
35 G_LOG_LEVEL NUMBER := NULL;
36 G_LOG_MODE VARCHAR2(3) := 'OFF'; -- possible values: OFF, SQL, SRS
37 G_LOG_LOCATION VARCHAR2(500) := '.';
38 G_LOG_USERNAME VARCHAR2(50);
39 G_FILE_NAME VARCHAR2(50) := 'DEBUGLOG';
40
41 --========================================================================
42 -- PROCEDURE : Log_Initialize PUBLIC
43 -- COMMENT : Initializes the log facility. It should be called from
44 -- the top level procedure of each concurrent program
45 --=======================================================================--
46 PROCEDURE Log_Initialize
47 ( p_file_name IN VARCHAR2 DEFAULT '0'
48 ,p_override IN NUMBER DEFAULT 0
49 );
50
51 --========================================================================
52 -- PROCEDURE : Log PUBLIC
53 -- PARAMETERS: p_level IN priority of the message - from
54 -- highest to lowest:
55 -- -- G_LOG_ERROR
56 -- -- G_LOG_EXCEPTION
57 -- -- G_LOG_EVENT
58 -- -- G_LOG_PROCEDURE
59 -- -- G_LOG_STATEMENT
60 -- p_msg IN message to be print on the log
61 -- file
62 -- COMMENT : Add an entry to the log
63 --=======================================================================--
64 PROCEDURE put_line
65 ( p_msg IN VARCHAR2
66 , p_priority IN NUMBER DEFAULT 100
67 , p_file_name IN VARCHAR2 DEFAULT '0'
68 );
69
70 PROCEDURE display_messages
71 ( p_msg_count IN NUMBER
72 );
73
74 PROCEDURE display_inventory_gtmp
75 ( p_material_detail_id IN NUMBER
76 ,p_batch_id IN NUMBER
77 ,p_delete_mark IN NUMBER DEFAULT 0
78 );
79
80 PROCEDURE display_resource_gtmp
81 ( p_batchstep_resource_id IN NUMBER
82 ,p_batchstep_id IN NUMBER
83 ,p_batch_id IN NUMBER
84 ,p_delete_mark IN NUMBER DEFAULT 0
85 );
86
87 PROCEDURE display_exceptions_gtmp (
88 p_organization_id IN NUMBER
89 ,p_material_detail_id IN NUMBER
90 ,p_batch_id IN NUMBER);
91
92 PROCEDURE dump_temp_txns_exceptions;
93 END GME_DEBUG;