[Home] [Help]
PACKAGE: APPS.ECX_ERRORLOG
Source
1 package ecx_errorlog as
2 -- $Header: ECXERRS.pls 120.5 2005/11/08 21:15:41 susaha ship $
3 /*#
4 * This interface contains routines to track and report message delivery data.
5 * @rep:scope public
6 * @rep:product ECX
7 * @rep:lifecycle active
8 * @rep:displayname XML Gateway Message Delivery
9 * @rep:compatibility S
10 */
11
12 ecx_log_exit exception;
13 procedure inbound_engine
14 (
15 i_process_id IN RAW,
16 i_status IN varchar2,
17 i_errmsg IN varchar2,
18 i_errparams IN varchar2 default null
19 );
20
21 procedure outbound_engine
22 (
23 i_trigger_id IN number,
24 i_status IN varchar2,
25 i_errmsg IN varchar2,
26 i_outmsgid IN RAW,
27 i_errparams IN varchar2 default null,
28 i_party_type IN varchar2 default null
29 );
30
31 /*#
32 * Used by both Oracle and non Oracle messaging systems to report
33 * delivery status. The status information is written to the XML Gateway
34 * log tables to track and report transaction delivery data.
35 * @param i_outmsgid Message ID for the outbound message delivered by the messaging system
36 * @param i_status Message delivery status as reported by the messaging system.
37 * @param i_errmsg Error messages reported by the messaging system
38 * @param i_timestamp Time stamp from the messaging system indicating when it processed the outbound message
39 * @param o_ret_code Return code for the procedure
40 * @param o_ret_msg Return message for the procedure
41 * @param i_errparams Error Parameter
42 * @rep:scope public
43 * @rep:lifecycle active
44 * @rep:displayname XML Gateway Message Delivery
45 * @rep:compatibility S
46 * @rep:category BUSINESS_ENTITY ECX_MESSAGE_DELIVERY
47 */
48 procedure external_system
49 (
50 i_outmsgid IN RAW,
51 i_status In pls_integer,
52 i_errmsg IN varchar2,
53 i_timestamp IN date,
54 o_ret_code OUT NOCOPY pls_integer,
55 o_ret_msg OUT NOCOPY varchar2,
56 i_errparams IN varchar2 default null
57 );
58
59
60 procedure send_error
61 (
62 i_ret_code IN pls_integer,
63 i_errbuf IN varchar2,
64 i_snd_tp_id IN varchar2,
65 i_document_number In varchar2,
66 i_transaction_type IN varchar2,
67 o_ret_code OUT NOCOPY pls_integer,
68 o_ret_msg OUT NOCOPY varchar2
69 );
70
71 procedure send_msg_api
72 (
73 x_retcode OUT NOCOPY pls_integer,
74 x_retmsg OUT NOCOPY varchar2,
75 p_retcode IN pls_integer,
76 p_errbuf IN varchar2,
77 p_error_type IN pls_integer default 20,
78 p_party_id IN varchar2,
79 p_party_site_id IN varchar2,
80 p_transaction_type IN varchar2,
81 p_transaction_subtype IN varchar2,
82 p_party_type IN varchar2 default null,
83 p_document_number IN varchar2 default null
84 );
85
86 procedure inbound_trigger
87 (
88 i_trigger_id IN number,
89 i_msgid IN raw,
90 i_process_id IN raw,
91 i_status IN varchar2,
92 i_errmsg IN varchar2,
93 i_errparams IN varchar2 default null
94 );
95
96 procedure outbound_trigger
97 (
98 i_trigger_id IN number,
99 i_transaction_type IN varchar2,
100 i_transaction_subtype IN varchar2,
101 i_party_id IN number,
102 i_party_site_id IN varchar2,
103 i_party_type IN varchar2 default null,--bug #2183619
104 i_document_number IN varchar2,
105 i_status IN varchar2,
106 i_errmsg IN varchar2,
107 i_errparams IN varchar2 default null
108 );
109
110 procedure log_document
111 (
112 o_retcode OUT NOCOPY pls_integer,
113 o_retmsg OUT NOCOPY varchar2,
114 i_msgid IN raw,
115 i_message_type IN varchar2,
116 i_message_standard IN varchar2,
117 i_transaction_type IN varchar2,
118 i_transaction_subtype IN varchar2,
119 i_document_number IN varchar2,
120 i_partyid IN varchar2,
121 i_party_site_id IN varchar2,
122 i_party_type IN varchar2,
123 i_protocol_type IN varchar2,
124 i_protocol_address IN varchar2,
125 i_username IN varchar2,
126 i_password IN varchar2,
127 i_attribute1 IN varchar2,
128 i_attribute2 IN varchar2,
129 i_attribute3 IN varchar2,
130 i_attribute4 IN varchar2,
131 i_attribute5 IN varchar2,
132 i_payload IN clob,
133 i_internal_control_num IN number default null,
134 i_status IN varchar2 default null,
135 i_direction IN varchar2 default 'IN',
136 i_outmsgid IN raw default null,
137 i_logfile IN varchar2 default null,
138 i_item_type IN varchar2 default null,
139 i_item_key IN varchar2 default null,
140 i_activity_id IN varchar2 default null,
141 i_event_name IN varchar2 default null,
142 i_event_key IN varchar2 default null,
143 i_cb_event_name IN varchar2 default null,
144 i_cb_event_key IN varchar2 default null,
145 i_block_mode IN varchar2 default null
146 );
147
148
149 procedure update_log_document
150 (
151 i_msgid In raw,
152 i_outmsgid In raw,
153 i_status In varchar2,
154 i_logfile In varchar2,
155 i_update_type In varchar2
156 );
157 procedure getDoclogDetails
158 (
159 i_msgid in raw,
160 i_message_type OUT NOCOPY varchar2,
161 i_message_standard OUT NOCOPY varchar2,
162 i_transaction_type OUT NOCOPY varchar2,
163 i_transaction_subtype OUT NOCOPY varchar2,
164 i_document_number OUT NOCOPY varchar2,
165 i_party_id OUT NOCOPY varchar2,
166 i_party_site_id OUT NOCOPY varchar2,
167 i_protocol_type OUT NOCOPY varchar2,
168 i_protocol_address OUT NOCOPY varchar2,
169 i_username OUT NOCOPY varchar2,
170 i_password OUT NOCOPY varchar2,
171 i_attribute1 OUT NOCOPY varchar2,
172 i_attribute2 OUT NOCOPY varchar2,
173 i_attribute3 OUT NOCOPY varchar2,
174 i_attribute4 OUT NOCOPY varchar2,
175 i_attribute5 OUT NOCOPY varchar2,
176 i_logfile OUT NOCOPY varchar2,
177 i_internal_control_number OUT NOCOPY number,
178 i_status OUT NOCOPY varchar2,
179 i_time_stamp OUT NOCOPY date,
180 i_direction OUT NOCOPY varchar2,
181 /* Bug 2241292 */
182 o_retcode OUT NOCOPY pls_integer,
183 o_retmsg OUT NOCOPY varchar2
184
185 );
186
187 procedure log_resend(
188 o_retcode OUT NOCOPY pls_integer,
189 o_retmsg OUT NOCOPY varchar2,
190 i_resend_msgid IN raw,
191 i_msgid IN raw,
192 i_errmsg IN varchar2,
193 i_status IN varchar2,
194 i_timestamp IN date
195 );
196
197 procedure outbound_log (
198 p_event IN wf_event_t);
199
200 procedure log_receivemessage (
201 caller varchar2,
202 status_text varchar2,
203 err_msg varchar2,
204 receipt_msgid raw,
205 trigger_id pls_integer,
206 message_type varchar2,
207 message_standard varchar2,
208 transaction_type varchar2,
209 transaction_subtype varchar2,
210 document_number varchar2,
211 partyid varchar2,
212 party_site_id varchar2,
213 party_type varchar2,
214 protocol_type varchar2,
215 protocol_address varchar2,
216 username varchar2,
217 encrypt_password varchar2,
218 attribute1 varchar2,
219 attribute2 varchar2,
220 attribute3 varchar2,
221 attribute4 varchar2,
222 attribute5 varchar2,
223 payload clob,
224 returnval out nocopy varchar2);
225
226 end ecx_errorlog;