1 PACKAGE IBC_DEBUG_PVT AUTHID CURRENT_USER AS
2 /* $Header: ibcdbugs.pls 115.2 2003/08/14 18:35:09 enunez ship $ */
3
4 -- --------------------------------------------------------------------
5 -- FUNCTION: Debug_Enabled
6 -- DESCRIPTION: Returns TRUE if debug is enabled for current user
7 -- based upon profile values, FALSE otherwise.
8 -- --------------------------------------------------------------------
9 FUNCTION Debug_Enabled
10 RETURN BOOLEAN;
11
12 -- --------------------------------------------------------------------
13 -- PROCEDURE: Start_Process
14 -- DESCRIPTION: Marks the begin point of a procedure/function,
15 -- This is used to keep a stack of calls.
16 -- This procedure should be called at the begining of a
17 -- procedure or function.
18 -- --------------------------------------------------------------------
19 PROCEDURE Start_Process(p_proc_type IN VARCHAR2,
20 p_proc_name IN VARCHAR2,
21 p_parms IN VARCHAR2 := NULL);
22
23 -- --------------------------------------------------------------------
24 -- FUNCTION: Make_List
25 -- DESCRIPTION: Makes a list of values (enclosed in [] and separated
26 -- commas) from a JTF table being passed.
27 -- Useful when debugging the content of JTF tables being
28 -- passed as parameters.
29 -- Returns the list.
30 -- --------------------------------------------------------------------
31 FUNCTION Make_List(p_values IN JTF_NUMBER_TABLE)
32 RETURN VARCHAR2;
33
34 -- Overloaded
35 FUNCTION Make_List(p_values IN JTF_VARCHAR2_TABLE_100)
36 RETURN VARCHAR2;
37
38 -- Overloaded
39 FUNCTION Make_List(p_values IN JTF_VARCHAR2_TABLE_300)
40 RETURN VARCHAR2;
41
42 -- Overloaded
43 FUNCTION Make_List(p_values IN JTF_VARCHAR2_TABLE_4000)
44 RETURN VARCHAR2;
45
46 -- Overloaded
47 FUNCTION Make_List_VC32767(p_values IN JTF_VARCHAR2_TABLE_32767)
48 RETURN VARCHAR2;
49
50 -- --------------------------------------------------------------------
51 -- FUNCTION: Make_Parameter_List
52 -- DESCRIPTION: Creates a parameter list (with tags for each parameter)
53 -- Useful when calling Start_PRocess for "parms" parameter
54 -- --------------------------------------------------------------------
55 FUNCTION Make_Parameter_List(p_tag IN VARCHAR2,
56 p_parms IN JTF_VARCHAR2_TABLE_4000)
57 RETURN VARCHAR2;
58
59 -- Overloaded
60 FUNCTION Make_Parameter_List(p_tag IN VARCHAR2,
61 p_parms IN JTF_VARCHAR2_TABLE_32767)
62 RETURN VARCHAR2;
63
64 -- --------------------------------------------------------------------
65 -- PROCEDURE: Debug_Message
66 -- DESCRIPTION: Outputs p_message in case debug is enabled.
67 -- --------------------------------------------------------------------
68 PROCEDURE Debug_Message(p_message IN VARCHAR2);
69
70 -- --------------------------------------------------------------------
71 -- PROCEDURE: End_Process
72 -- DESCRIPTION: Signals the end of a process (PROCEDURE or FUNCTION)
73 -- This procedure should be called at the end of a
74 -- procedure or function.
75 -- --------------------------------------------------------------------
76 PROCEDURE End_Process(p_output_list IN VARCHAR2 := NULL);
77
78 -- --------------------------------------------------------------------
79 -- PROCEDURE: Terminate_Stack
80 -- DESCRIPTION: Flushes all Processes in the stack
81 -- Useful when catching exceptions, and finishing the
82 -- debugging.
83 -- --------------------------------------------------------------------
84 PROCEDURE Terminate_Stack;
85
86 END IBC_DEBUG_PVT;