[Home] [Help]
PACKAGE: APPS.IEC_OCS_LOG_PVT
Source
1 PACKAGE IEC_OCS_LOG_PVT AS
2 /* $Header: IECOCLGS.pls 120.1 2006/03/28 07:44:08 minwang noship $ */
3
4 PROCEDURE LOG_LIST_STATUS_IEC_ERROR
5 ( P_PACKAGE IN VARCHAR2
6 , P_METHOD IN VARCHAR2
7 , P_SUB_METHOD IN VARCHAR2
8 , P_LIST_ID IN NUMBER
9 , P_STATUS_ID IN NUMBER
10 , X_ERROR_MESSAGE_STR OUT NOCOPY VARCHAR2
11 );
12
13 PROCEDURE LOG_LIST_STATUS_AMS_ERROR
14 ( P_PACKAGE IN VARCHAR2
15 , P_METHOD IN VARCHAR2
16 , P_SUB_METHOD IN VARCHAR2
17 , P_LIST_ID IN NUMBER
18 , P_STATUS_ID IN NUMBER
19 , X_ERROR_MESSAGE_STR OUT NOCOPY VARCHAR2
20 );
21
22 PROCEDURE LOG_LOCATE_LIST_DATA_ERROR
23 ( P_PACKAGE IN VARCHAR2
24 , P_METHOD IN VARCHAR2
25 , P_SUB_METHOD IN VARCHAR2
26 , P_LIST_ID IN NUMBER
27 , X_ERROR_MESSAGE_STR OUT NOCOPY VARCHAR2
28 );
29
30 PROCEDURE LOG_RECYCLE_MV_DUP_REC_STMT
31 ( P_PACKAGE IN VARCHAR2
32 , P_METHOD IN VARCHAR2
33 , P_SUB_METHOD IN VARCHAR2
34 , P_SOURCE_SCHED_ID IN NUMBER
35 , P_SOURCE_LIST_ID IN NUMBER
36 , P_SOURCE_LIST_ENTRY_ID IN NUMBER
37 , P_SOURCE_RETURNS_ID IN NUMBER
38 , P_PARTY_ID IN NUMBER
39 , P_DEST_SCHED_ID IN NUMBER
40 , X_ERROR_MESSAGE_STR OUT NOCOPY VARCHAR2
41 );
42
43 PROCEDURE LOG_INTERNAL_PLSQL_ERROR
44 ( P_PACKAGE IN VARCHAR2
45 , P_METHOD IN VARCHAR2
46 , P_SUB_METHOD IN VARCHAR2
47 , P_ACTIVITY IN VARCHAR2
48 , P_SQL_CODE IN NUMBER
49 , P_SQL_MESSAGE IN VARCHAR2
50 , X_ERROR_MESSAGE_STR OUT NOCOPY VARCHAR2
51 );
52
53 PROCEDURE LOG_INTERNAL_PLSQL_ERROR
54 ( P_PACKAGE IN VARCHAR2
55 , P_METHOD IN VARCHAR2
56 , P_SUB_METHOD IN VARCHAR2
57 , P_SQL_MESSAGE IN VARCHAR2
58 , X_ERROR_MESSAGE_STR OUT NOCOPY VARCHAR2
59 );
60
61 -- New Logging Procedures
62
63 PROCEDURE Get_EncodedMessage
64 ( x_message OUT NOCOPY VARCHAR2
65 , x_enc_message OUT NOCOPY VARCHAR2);
66
67 PROCEDURE Log_Message
68 ( p_module IN VARCHAR2);
69
70 PROCEDURE Get_Module
71 ( p_package IN VARCHAR2
72 , p_method IN VARCHAR2
73 , p_sub_method IN VARCHAR2
74 , x_module OUT NOCOPY VARCHAR2);
75
76 PROCEDURE Init_GetSubsetViewErrorMsg
77 ( p_subset_name IN VARCHAR2
78 , p_list_name IN VARCHAR2
79 , p_procedure_name IN VARCHAR2
80 , x_message OUT NOCOPY VARCHAR2
81 , x_enc_message OUT NOCOPY VARCHAR2);
82
83 PROCEDURE Init_NoEntriesFoundMsg
84 ( x_message OUT NOCOPY VARCHAR2
85 , x_enc_message OUT NOCOPY VARCHAR2);
86
87 PROCEDURE Init_SourceTypeDoesNotExistMsg
88 ( p_source_type IN VARCHAR2
89 , x_message OUT NOCOPY VARCHAR2
90 , x_enc_message OUT NOCOPY VARCHAR2);
91
92 PROCEDURE Init_SourceTypeMismatchAllMsg
93 ( p_source_type IN VARCHAR2
94 , p_source_type_dist IN VARCHAR2
95 , x_message OUT NOCOPY VARCHAR2
96 , x_enc_message OUT NOCOPY VARCHAR2);
97
98 PROCEDURE Init_SourceTypeMismatchSomeMsg
99 ( p_source_type IN VARCHAR2
100 , p_source_type_dist IN VARCHAR2
101 , x_message OUT NOCOPY VARCHAR2
102 , x_enc_message OUT NOCOPY VARCHAR2);
103
104 PROCEDURE Init_SourceTypeMissingColsMsg
105 ( p_source_type IN VARCHAR2
106 , p_missing_columns IN VARCHAR2
107 , x_message OUT NOCOPY VARCHAR2
108 , x_enc_message OUT NOCOPY VARCHAR2);
109
110 PROCEDURE Init_SourceTypeNotSupportedMsg
111 ( p_source_type IN VARCHAR2
112 , x_message OUT NOCOPY VARCHAR2
113 , x_enc_message OUT NOCOPY VARCHAR2);
114
115 PROCEDURE Init_SqlErrmMsg
116 ( p_sqlerrm IN VARCHAR2
117 , x_message OUT NOCOPY VARCHAR2
118 , x_enc_message OUT NOCOPY VARCHAR2);
119
120 PROCEDURE Init_StatusUpdateErrorMsg
121 ( p_list_name IN VARCHAR2
122 , p_procedure_name IN VARCHAR2
123 , x_message OUT NOCOPY VARCHAR2
124 , x_enc_message OUT NOCOPY VARCHAR2);
125
126 PROCEDURE Init_SubsetViewDoesNotExistMsg
127 ( p_subset_name IN VARCHAR2
128 , p_list_name IN VARCHAR2
129 , x_message OUT NOCOPY VARCHAR2
130 , x_enc_message OUT NOCOPY VARCHAR2);
131
132 PROCEDURE Init_TerritoryNotFoundMsg
133 ( p_territory_code IN VARCHAR2
134 , p_table_name IN VARCHAR2
135 , x_message OUT NOCOPY VARCHAR2
136 , x_enc_message OUT NOCOPY VARCHAR2);
137
138 PROCEDURE Init_TerritoryNotUniqueMsg
139 ( p_territory_code IN VARCHAR2
140 , p_table_name IN VARCHAR2
141 , x_message OUT NOCOPY VARCHAR2
142 , x_enc_message OUT NOCOPY VARCHAR2);
143
144 PROCEDURE Init_ValidationSuccessMsg
145 ( p_total_count IN VARCHAR2
146 , p_valid_count IN VARCHAR2
147 , x_message OUT NOCOPY VARCHAR2
148 , x_enc_message OUT NOCOPY VARCHAR2);
149
150 PROCEDURE Init_SubsetViewInvalidMsg
151 ( p_subset_name IN VARCHAR2
152 , p_list_name IN VARCHAR2
153 , x_message OUT NOCOPY VARCHAR2
154 , x_enc_message OUT NOCOPY VARCHAR2);
155
156 PROCEDURE Init_ValidationSqlErrmMsg
157 ( p_sqlerrm IN VARCHAR2
158 , p_module IN VARCHAR2
159 , x_message OUT NOCOPY VARCHAR2
160 , x_enc_message OUT NOCOPY VARCHAR2);
161
162 PROCEDURE Init_CopyDestListInvalidStaMsg
163 ( p_src_schedule_id IN VARCHAR2
164 , p_dest_schedule_id IN VARCHAR2
165 , x_message OUT NOCOPY VARCHAR2
166 , x_enc_message OUT NOCOPY VARCHAR2);
167
168 PROCEDURE Init_CopyDestListNotCCRMsg
169 ( p_src_schedule_id IN VARCHAR2
170 , p_dest_schedule_id IN VARCHAR2
171 , x_message OUT NOCOPY VARCHAR2
172 , x_enc_message OUT NOCOPY VARCHAR2);
173
174 PROCEDURE Init_CopyDestListNotValMsg
175 ( p_src_schedule_id IN VARCHAR2
176 , p_dest_schedule_id IN VARCHAR2
177 , x_message OUT NOCOPY VARCHAR2
178 , x_enc_message OUT NOCOPY VARCHAR2);
179
180 PROCEDURE Init_CopyDestListNullMsg
181 ( p_src_schedule_id IN VARCHAR2
182 , p_dest_schedule_id IN VARCHAR2
183 , x_message OUT NOCOPY VARCHAR2
184 , x_enc_message OUT NOCOPY VARCHAR2);
185
186 PROCEDURE Init_CopySrcListInvalidStatMsg
187 ( p_src_schedule_id IN VARCHAR2
188 , p_dest_schedule_id IN VARCHAR2
189 , x_message OUT NOCOPY VARCHAR2
190 , x_enc_message OUT NOCOPY VARCHAR2);
191
192 PROCEDURE Init_CopySrcListNotCCRMsg
193 ( p_src_schedule_id IN VARCHAR2
194 , p_dest_schedule_id IN VARCHAR2
195 , x_message OUT NOCOPY VARCHAR2
196 , x_enc_message OUT NOCOPY VARCHAR2);
197
198 PROCEDURE Init_CopySrcListNotValMsg
199 ( p_src_schedule_id IN VARCHAR2
200 , p_dest_schedule_id IN VARCHAR2
201 , x_message OUT NOCOPY VARCHAR2
202 , x_enc_message OUT NOCOPY VARCHAR2);
203
204 PROCEDURE Init_CopySrcListNullMsg
205 ( p_src_schedule_id IN VARCHAR2
206 , p_dest_schedule_id IN VARCHAR2
207 , x_message OUT NOCOPY VARCHAR2
208 , x_enc_message OUT NOCOPY VARCHAR2);
209
210 PROCEDURE Init_ListRtInfoDNEMsg
211 ( p_schedule_id IN VARCHAR2
212 , x_message OUT NOCOPY VARCHAR2
213 , x_enc_message OUT NOCOPY VARCHAR2);
214
215 PROCEDURE Init_PurgeListStatusInvMsg
216 ( p_schedule_id IN VARCHAR2
217 , x_message OUT NOCOPY VARCHAR2
218 , x_enc_message OUT NOCOPY VARCHAR2);
219
220 PROCEDURE Init_CannotStopScheduleMsg
221 ( p_schedule_id IN VARCHAR2
222 , x_message OUT NOCOPY VARCHAR2
223 , x_enc_message OUT NOCOPY VARCHAR2);
224
225 END IEC_OCS_LOG_PVT;
226