DBA Data[Home] [Help]

PACKAGE: APPS.IEC_OCS_LOG_PVT

Source


1 PACKAGE      IEC_OCS_LOG_PVT AUTHID CURRENT_USER 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