[Home] [Help]
PACKAGE: APPS.CEP_STANDARD
Source
1 PACKAGE CEP_STANDARD AS
2 /* $Header: ceseutls.pls 120.10.12010000.2 2008/08/10 14:28:08 csutaria ship $ */
3 /*----------------------------------------------------------------------------*
4 | PUBLIC PROCEDURE |
5 | debug - Display text message if in debug mode |
6 | enable_debug - Enable run time debugging |
7 | disable_debug - Disable run time debugging |
8 | |
9 | DESCRIPTION |
10 | Generate standard debug information sending it to dbms_output so that |
11 | the client tool can log it for the user. |
12 | |
13 | REQUIRES |
14 | line_of_text The line of text that will be displayed. |
15 | |
16 | EXCEPTIONS RAISED |
17 | |
18 | KNOWN BUGS |
19 | |
20 | NOTES |
21 | |
22 | HISTORY |
23 | 26 Mar 93 Nigel Smith Created |
24 | 28 Jul 99 K Adams Added option to either send it to a file or |
25 | dbms_output. |
26 | If debug path and file name are passed, |
27 | it writes to the path/file_name instead |
28 | of dbms_output. |
29 | |
30 *----------------------------------------------------------------------------*/
31 --
32 G_patch_level VARCHAR2(30) := '11.5.CE.J';
33 G_debug Varchar2(1) := 'N' ; -- Bug 7125240
34
35 FUNCTION return_patch_level RETURN VARCHAR2;
36
37 procedure debug( line in varchar2 ) ;
38 procedure enable_debug( path_name in varchar2 default NULL,
39 file_name in varchar2 default NULL);
40 procedure disable_debug( display_debug in varchar2 );
41 --
42
43 FUNCTION Get_Window_Session_Title(p_org_id number default NULL,
44 p_legal_entity_id number default NULL) RETURN VARCHAR2;
45 --
46 function get_effective_date(p_bank_account_id NUMBER,
47 p_trx_code VARCHAR2,
48 p_receipt_date DATE) RETURN DATE;
49
50 /**
51 * PROCEDURE debug_msg_stack
52 *
53 * DESCRIPTION
54 * Show debug messages on message stack.
55 *
56 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
57 *
58 * ARGUMENTS
59 * IN:
60 * p_msg_count Message count in message stack.
61 * p_msg_data Message data if message count is 1.
62 *
63 * MODIFICATION HISTORY
64 *
65 * 15-SEP-2004 Xin Wang Created.
66 *
67 */
68 PROCEDURE debug_msg_stack(p_msg_count IN NUMBER,
69 p_msg_data IN VARCHAR2);
70
71
72 /*=======================================================================+
73 | PUBLIC PRECEDURE sql_error |
74 | |
75 | DESCRIPTION |
76 | This procedure sets the error message and raise an exception |
77 | for unhandled sql errors. |
78 | Called by other routines. |
79 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
80 | |
81 | ARGUMENTS |
82 | IN: |
83 | p_routine |
84 | p_errcode |
85 | p_errmsg |
86 +=======================================================================*/
87 PROCEDURE sql_error(p_routine IN VARCHAR2,
88 p_errcode IN NUMBER,
89 p_errmsg IN VARCHAR2);
90
91
92 /*=======================================================================+
93 | PUBLIC PRECEDURE get_umx_predicate |
94 | |
95 | DESCRIPTION |
96 | This procedure return where clause predicate generated from UMX API |
97 | to apply BA access security or BAT security |
98 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
99 | |
100 | ARGUMENTS |
101 | IN: |
102 | p_object_name: CEBAT, CEBAC |
103 +=======================================================================*/
104 FUNCTION get_umx_predicate(p_object_name IN VARCHAR2) RETURN VARCHAR2;
105
106 /*=======================================================================+
107 | PUBLIC PRECEDURE check_ba_security |
108 | |
109 | DESCRIPTION |
110 | This function checks if user has access to the input LE based on |
111 | Bank account Access or Bank Account Transfer security defined in UMX|
112 | ARGUMENTS |
113 | IN: |
114 | p_le_id: Legal Entity ID |
115 | p_security_mode: CEBAT, CEBAC |
116 | OUT: |
117 | 1: if user has access |
118 | 0: otherwise |
119 +=======================================================================*/
120 FUNCTION check_ba_security ( p_le_id NUMBER,
121 p_security_mode VARCHAR2) RETURN NUMBER;
122
123 FUNCTION get_conversion_rate ( p_ledger_id NUMBER,
124 p_currency_code VARCHAR2,
125 p_exchange_date DATE,
126 p_exchange_rate_type VARCHAR2) RETURN NUMBER;
127
128 PROCEDURE init_security;
129
130 PROCEDURE init_security_baui;
131
132 END CEP_STANDARD;