1 PACKAGE PO_WF_DEBUG_PKG AUTHID CURRENT_USER as
2 /* $Header: POXWDBGS.pls 120.1.12000000.1 2007/03/27 22:05:20 dedelgad noship $*/
3
4 /***************************************************************************************
5 *
6 * THis package is used to track the progress of all the functions in the workflow as
7 * they are invoked by the workflow process. It captures the following:
8 * - the Process Name
9 * - the unique ID of the Item going through the process
10 * - the Package.procedure name being executed
11 * - the progress within that Package.procedure
12 *
13 ***************************************************************************************/
14
15
16 procedure insert_debug (itemtype varchar2,
17 itemkey varchar2,
18 x_progress varchar2);
19
20 -- <PO OTM Integration FPJ>: Added BPEL debug procedures, since FND
21 -- logging does not currently support logging without an APPS context,
22 -- which is how calls from BPEL processes are executed.
23 PROCEDURE debug_stmt(
24 p_log_head IN VARCHAR2
25 , p_token IN VARCHAR2
26 , p_message IN VARCHAR2
27 );
28
29 PROCEDURE debug_begin(
30 p_log_head IN VARCHAR2
31 );
32
33 PROCEDURE debug_end(
34 p_log_head IN VARCHAR2
35 );
36
37 PROCEDURE debug_var(
38 p_log_head IN VARCHAR2
39 , p_progress IN VARCHAR2
40 , p_name IN VARCHAR2
41 , p_value IN VARCHAR2
42 );
43
44 PROCEDURE debug_var(
45 p_log_head IN VARCHAR2
46 , p_progress IN VARCHAR2
47 , p_name IN VARCHAR2
48 , p_value IN NUMBER
49 );
50
51 PROCEDURE debug_var(
52 p_log_head IN VARCHAR2
53 , p_progress IN VARCHAR2
54 , p_name IN VARCHAR2
55 , p_value IN DATE
56 );
57
58 PROCEDURE debug_var(
59 p_log_head IN VARCHAR2
60 , p_progress IN VARCHAR2
61 , p_name IN VARCHAR2
62 , p_value IN BOOLEAN
63 );
64
65 PROCEDURE debug_unexp(
66 p_log_head IN VARCHAR2
67 , p_progress IN VARCHAR2
68 , p_message IN VARCHAR2
69 DEFAULT NULL
70 );
71
72 END PO_WF_DEBUG_PKG;
73