[Home] [Help]
PACKAGE: APPS.XLA_EXCEPTIONS_PKG
Source
1 PACKAGE xla_exceptions_pkg AUTHID CURRENT_USER AS
2 /* $Header: xlacmexc.pkh 120.2 2003/04/07 18:37:55 wychan ship $ */
3 /*======================================================================+
4 | Copyright (c) 1995-2001 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | PACKAGE NAME |
9 | xla_exceptions_pkg |
10 | |
11 | DESCRIPTION |
12 | XLA Exceptions Package |
13 | |
14 | HISTORY |
15 | 02-Jan-95 P. Juvara Created |
16 | 08-Feb-01 P. Labrevois Adapted for XLA |
17 | |
18 +======================================================================*/
19
20
21 /*======================================================================+
22 | |
23 | Constants |
24 | |
25 +======================================================================*/
26 C_STANDARD_MESSAGE VARCHAR2(1) := 'S';
27 C_OA_MESSAGE VARCHAR2(1) := 'O';
28
29 /*======================================================================+
30 | |
31 | Variables |
32 | |
33 +======================================================================*/
34 exception_text VARCHAR2(2000);
35
36
37 /*======================================================================+
38 | |
39 | Exceptions |
40 | |
41 +======================================================================*/
42 application_exception EXCEPTION;
43 resource_busy EXCEPTION;
44 too_many_rows EXCEPTION;
45
46 PRAGMA exception_init(application_exception, -20001);
47 PRAGMA exception_init(resource_busy , -00054);
48 PRAGMA exception_init(too_many_rows , -01422);
49
50
51 /*======================================================================+
52 | |
53 | Public Function |
54 | |
55 | raise_exception |
56 | |
57 | Raise the standard exception. |
58 | |
59 +======================================================================*/
60 PROCEDURE raise_exception;
61
62
63 /*======================================================================+
64 | |
65 | Public Function |
66 | |
67 | raise_message |
68 | |
69 | Raise the standard exception with a generic text associated. This |
70 | procedure is usually called from the all the exceptions blocks. |
71 | |
72 +======================================================================*/
73 PROCEDURE raise_message
74 (p_location IN VARCHAR2
75 ,p_msg_mode IN VARCHAR2 DEFAULT C_STANDARD_MESSAGE);
76
77 /*======================================================================+
78 | |
79 | Public Function |
80 | |
81 | raise_message |
82 | |
83 | Raise an exception with a message text. The function can accpt up to |
84 | 6 tokens. |
85 | |
86 +======================================================================*/
87 PROCEDURE raise_message
88 (p_appli_s_name IN VARCHAR2
89 ,p_msg_name IN VARCHAR2
90 ,p_msg_mode IN VARCHAR2 DEFAULT C_STANDARD_MESSAGE);
91
92 PROCEDURE raise_message
93 (p_appli_s_name IN VARCHAR2
94 ,p_msg_name IN VARCHAR2
95 ,p_token_1 IN VARCHAR2
96 ,p_value_1 IN VARCHAR2
97 ,p_msg_mode IN VARCHAR2 DEFAULT C_STANDARD_MESSAGE);
98
99 PROCEDURE raise_message
100 (p_appli_s_name IN VARCHAR2
101 ,p_msg_name IN VARCHAR2
102 ,p_token_1 IN VARCHAR2
103 ,p_value_1 IN VARCHAR2
104 ,p_token_2 IN VARCHAR2
105 ,p_value_2 IN VARCHAR2
106 ,p_msg_mode IN VARCHAR2 DEFAULT C_STANDARD_MESSAGE);
107
108 PROCEDURE raise_message
109 (p_appli_s_name IN VARCHAR2
110 ,p_msg_name IN VARCHAR2
111 ,p_token_1 IN VARCHAR2
112 ,p_value_1 IN VARCHAR2
113 ,p_token_2 IN VARCHAR2
114 ,p_value_2 IN VARCHAR2
115 ,p_token_3 IN VARCHAR2
116 ,p_value_3 IN VARCHAR2
117 ,p_msg_mode IN VARCHAR2 DEFAULT C_STANDARD_MESSAGE);
118
119 PROCEDURE raise_message
120 (p_appli_s_name IN VARCHAR2
121 ,p_msg_name IN VARCHAR2
122 ,p_token_1 IN VARCHAR2
123 ,p_value_1 IN VARCHAR2
124 ,p_token_2 IN VARCHAR2
125 ,p_value_2 IN VARCHAR2
126 ,p_token_3 IN VARCHAR2
127 ,p_value_3 IN VARCHAR2
128 ,p_token_4 IN VARCHAR2
129 ,p_value_4 IN VARCHAR2
130 ,p_msg_mode IN VARCHAR2 DEFAULT C_STANDARD_MESSAGE);
131
132 PROCEDURE raise_message
133 (p_appli_s_name IN VARCHAR2
134 ,p_msg_name IN VARCHAR2
135 ,p_token_1 IN VARCHAR2
136 ,p_value_1 IN VARCHAR2
137 ,p_token_2 IN VARCHAR2
138 ,p_value_2 IN VARCHAR2
139 ,p_token_3 IN VARCHAR2
140 ,p_value_3 IN VARCHAR2
141 ,p_token_4 IN VARCHAR2
142 ,p_value_4 IN VARCHAR2
143 ,p_token_5 IN VARCHAR2
144 ,p_value_5 IN VARCHAR2
145 ,p_msg_mode IN VARCHAR2 DEFAULT C_STANDARD_MESSAGE);
146
147 PROCEDURE raise_message
148 (p_appli_s_name IN VARCHAR2
149 ,p_msg_name IN VARCHAR2
150 ,p_token_1 IN VARCHAR2
151 ,p_value_1 IN VARCHAR2
152 ,p_token_2 IN VARCHAR2
153 ,p_value_2 IN VARCHAR2
154 ,p_token_3 IN VARCHAR2
155 ,p_value_3 IN VARCHAR2
156 ,p_token_4 IN VARCHAR2
157 ,p_value_4 IN VARCHAR2
158 ,p_token_5 IN VARCHAR2
159 ,p_value_5 IN VARCHAR2
160 ,p_token_6 IN VARCHAR2
161 ,p_value_6 IN VARCHAR2
162 ,p_msg_mode IN VARCHAR2 DEFAULT C_STANDARD_MESSAGE);
163
164 END xla_exceptions_pkg ;