[Home] [Help]
1: package body ecx_inbound_trig as
2: -- $Header: ECXINBTB.pls 120.16.12000000.3 2007/09/18 15:35:00 cpeixoto ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
1: package body ecx_inbound_trig as
2: -- $Header: ECXINBTB.pls 120.16.12000000.3 2007/09/18 15:35:00 cpeixoto ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
2: -- $Header: ECXINBTB.pls 120.16.12000000.3 2007/09/18 15:35:00 cpeixoto ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
10:
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
10:
11: TYPE attribute_rec is RECORD
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
10:
11: TYPE attribute_rec is RECORD
12: (
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
10:
11: TYPE attribute_rec is RECORD
12: (
13: attribute_name varchar2(256),
42: end if;
43:
44: exception
45: when others then
46: ecx_debug.setErrorInfo(2, 30,
47: SQLERRM||' - ECX_INBOUND_TRIG.IS_ROUTING_SUPPORTED');
48: if(l_unexpectedEnabled) then
49: --ecx_debug.log(l_statement, ecx_utils.i_errbuf, i_method_name);
50: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
45: when others then
46: ecx_debug.setErrorInfo(2, 30,
47: SQLERRM||' - ECX_INBOUND_TRIG.IS_ROUTING_SUPPORTED');
48: if(l_unexpectedEnabled) then
49: --ecx_debug.log(l_statement, ecx_utils.i_errbuf, i_method_name);
50: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
51: end if;
52: raise ecx_utils.program_exit;
53: end is_routing_supported;
46: ecx_debug.setErrorInfo(2, 30,
47: SQLERRM||' - ECX_INBOUND_TRIG.IS_ROUTING_SUPPORTED');
48: if(l_unexpectedEnabled) then
49: --ecx_debug.log(l_statement, ecx_utils.i_errbuf, i_method_name);
50: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
51: end if;
52: raise ecx_utils.program_exit;
53: end is_routing_supported;
54:
68: pnode xmlDOM.DOMNode;
69: cnode xmlDOM.DOMNode;
70: begin
71: if (l_procedureEnabled) then
72: ecx_debug.push(i_method_name);
73: end if;
74: if(l_statementEnabled) then
75: ecx_debug.log(l_statement,'i_doc',i_doc.id,i_method_name);
76: ecx_debug.log(l_statement,'i_element',i_element,i_method_name);
71: if (l_procedureEnabled) then
72: ecx_debug.push(i_method_name);
73: end if;
74: if(l_statementEnabled) then
75: ecx_debug.log(l_statement,'i_doc',i_doc.id,i_method_name);
76: ecx_debug.log(l_statement,'i_element',i_element,i_method_name);
77: end if;
78: nl := xmlDOM.getElementsByTagName(i_doc,i_element);
79:
72: ecx_debug.push(i_method_name);
73: end if;
74: if(l_statementEnabled) then
75: ecx_debug.log(l_statement,'i_doc',i_doc.id,i_method_name);
76: ecx_debug.log(l_statement,'i_element',i_element,i_method_name);
77: end if;
78: nl := xmlDOM.getElementsByTagName(i_doc,i_element);
79:
80: if (not xmlDOM.isNull(nl))
90: end if;
91: end if;
92: end if;
93: if(l_statementEnabled) then
94: ecx_debug.log(l_statement,'i_value',i_value,i_method_name);
95: end if;
96: if (l_procedureEnabled) then
97: ecx_debug.pop(i_method_name);
98: end if;
93: if(l_statementEnabled) then
94: ecx_debug.log(l_statement,'i_value',i_value,i_method_name);
95: end if;
96: if (l_procedureEnabled) then
97: ecx_debug.pop(i_method_name);
98: end if;
99: exception
100: when others then
101: ecx_debug.setErrorInfo(2,30,
97: ecx_debug.pop(i_method_name);
98: end if;
99: exception
100: when others then
101: ecx_debug.setErrorInfo(2,30,
102: SQLERRM ||' - ECX_INBOUND_TRIG.GET_ELEMENT_VALUE');
103: if(l_unexpectedEnabled) then
104: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
105: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
100: when others then
101: ecx_debug.setErrorInfo(2,30,
102: SQLERRM ||' - ECX_INBOUND_TRIG.GET_ELEMENT_VALUE');
103: if(l_unexpectedEnabled) then
104: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
105: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
106: end if;
107: raise ecx_utils.program_exit;
108: end get_element_value;
101: ecx_debug.setErrorInfo(2,30,
102: SQLERRM ||' - ECX_INBOUND_TRIG.GET_ELEMENT_VALUE');
103: if(l_unexpectedEnabled) then
104: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
105: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
106: end if;
107: raise ecx_utils.program_exit;
108: end get_element_value;
109:
136:
137: i_single varchar2(3):= '''';
138: begin
139: if (l_procedureEnabled) then
140: ecx_debug.push(i_method_name);
141: end if;
142: if(l_statementEnabled) then
143: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
144: end if;
139: if (l_procedureEnabled) then
140: ecx_debug.push(i_method_name);
141: end if;
142: if(l_statementEnabled) then
143: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
144: end if;
145:
146: if i_standard_code is null
147: then
145:
146: if i_standard_code is null
147: then
148: if (l_procedureEnabled) then
149: ecx_debug.pop(i_method_name);
150: end if;
151: return;
152: end if;
153: /** Initialize the attr table **/
163:
164: /** Search for the attribute in the XML File **/
165: get_element_value(i_doc,c1.element_tag_name,i_attr_rec(i_attr_rec.COUNT).value);
166: if(l_statementEnabled) then
167: ecx_debug.log(l_statement,i_attr_rec(i_attr_rec.COUNT).attribute_name,
168: i_attr_rec(i_attr_rec.COUNT).value,i_method_name);
169: end if;
170: i_string := i_string ||' '||i_attr_rec(i_attr_rec.COUNT).attribute_name || ' = '||
171: i_single||i_attr_rec(i_attr_rec.COUNT).value || i_single||' ,';
178:
179: if i_attr_rec.count > 0
180: then
181: if(l_statementEnabled) then
182: ecx_debug.log(l_statement,'i_string',i_string,i_method_name);
183: end if;
184: execute immediate i_string;
185: end if;
186: if (l_procedureEnabled) then
183: end if;
184: execute immediate i_string;
185: end if;
186: if (l_procedureEnabled) then
187: ecx_debug.pop(i_method_name);
188: end if;
189: exception
190: when others then
191: ecx_debug.setErrorInfo(2,30,SQLERRM ||' - ECX_INBOUND_TRIG.getAttributes');
187: ecx_debug.pop(i_method_name);
188: end if;
189: exception
190: when others then
191: ecx_debug.setErrorInfo(2,30,SQLERRM ||' - ECX_INBOUND_TRIG.getAttributes');
192: if(l_unexpectedEnabled) then
193: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
194: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
195: end if;
189: exception
190: when others then
191: ecx_debug.setErrorInfo(2,30,SQLERRM ||' - ECX_INBOUND_TRIG.getAttributes');
192: if(l_unexpectedEnabled) then
193: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
194: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
195: end if;
196: raise ecx_utils.program_exit;
197: end getAttributes;
190: when others then
191: ecx_debug.setErrorInfo(2,30,SQLERRM ||' - ECX_INBOUND_TRIG.getAttributes');
192: if(l_unexpectedEnabled) then
193: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
194: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
195: end if;
196: raise ecx_utils.program_exit;
197: end getAttributes;
198:
208:
209: i_method_name varchar2(2000) := 'ecx_inbound_trig.parsepayload';
210: begin
211: if (l_procedureEnabled) then
212: ecx_debug.push(i_method_name);
213: end if;
214: xmlparser.parseCLOB(ecx_utils.g_parser,i_payload);
215: if (l_procedureEnabled) then
216: ecx_debug.pop(i_method_name);
212: ecx_debug.push(i_method_name);
213: end if;
214: xmlparser.parseCLOB(ecx_utils.g_parser,i_payload);
215: if (l_procedureEnabled) then
216: ecx_debug.pop(i_method_name);
217: end if;
218: exception
219: -- Put All DOM Parser Exceptions Here.
220: when xmlDOM.INDEX_SIZE_ERR then
217: end if;
218: exception
219: -- Put All DOM Parser Exceptions Here.
220: when xmlDOM.INDEX_SIZE_ERR then
221: ecx_debug.setErrorInfo(1,20,SQLERRM);
222: if(l_unexpectedEnabled) then
223: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
224: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
225: end if;
219: -- Put All DOM Parser Exceptions Here.
220: when xmlDOM.INDEX_SIZE_ERR then
221: ecx_debug.setErrorInfo(1,20,SQLERRM);
222: if(l_unexpectedEnabled) then
223: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
224: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
225: end if;
226: if (l_procedureEnabled) then
227: ecx_debug.pop(i_method_name);
220: when xmlDOM.INDEX_SIZE_ERR then
221: ecx_debug.setErrorInfo(1,20,SQLERRM);
222: if(l_unexpectedEnabled) then
223: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
224: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
225: end if;
226: if (l_procedureEnabled) then
227: ecx_debug.pop(i_method_name);
228: end if;
223: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
224: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
225: end if;
226: if (l_procedureEnabled) then
227: ecx_debug.pop(i_method_name);
228: end if;
229: raise ecx_utils.program_exit;
230: when xmlDOM.DOMSTRING_SIZE_ERR then
231: ecx_debug.setErrorInfo(1,20,SQLERRM);
227: ecx_debug.pop(i_method_name);
228: end if;
229: raise ecx_utils.program_exit;
230: when xmlDOM.DOMSTRING_SIZE_ERR then
231: ecx_debug.setErrorInfo(1,20,SQLERRM);
232: if(l_unexpectedEnabled) then
233: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
234: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
235: end if;
229: raise ecx_utils.program_exit;
230: when xmlDOM.DOMSTRING_SIZE_ERR then
231: ecx_debug.setErrorInfo(1,20,SQLERRM);
232: if(l_unexpectedEnabled) then
233: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
234: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
235: end if;
236: if (l_procedureEnabled) then
237: ecx_debug.pop(i_method_name);
230: when xmlDOM.DOMSTRING_SIZE_ERR then
231: ecx_debug.setErrorInfo(1,20,SQLERRM);
232: if(l_unexpectedEnabled) then
233: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
234: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
235: end if;
236: if (l_procedureEnabled) then
237: ecx_debug.pop(i_method_name);
238: end if;
233: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
234: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
235: end if;
236: if (l_procedureEnabled) then
237: ecx_debug.pop(i_method_name);
238: end if;
239: raise ecx_utils.program_exit;
240: when xmlDOM.HIERARCHY_REQUEST_ERR then
241: ecx_debug.setErrorInfo(1,20,SQLERRM);
237: ecx_debug.pop(i_method_name);
238: end if;
239: raise ecx_utils.program_exit;
240: when xmlDOM.HIERARCHY_REQUEST_ERR then
241: ecx_debug.setErrorInfo(1,20,SQLERRM);
242: if(l_unexpectedEnabled) then
243: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
244: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
245: end if;
239: raise ecx_utils.program_exit;
240: when xmlDOM.HIERARCHY_REQUEST_ERR then
241: ecx_debug.setErrorInfo(1,20,SQLERRM);
242: if(l_unexpectedEnabled) then
243: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
244: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
245: end if;
246: if (l_procedureEnabled) then
247: ecx_debug.pop(i_method_name);
240: when xmlDOM.HIERARCHY_REQUEST_ERR then
241: ecx_debug.setErrorInfo(1,20,SQLERRM);
242: if(l_unexpectedEnabled) then
243: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
244: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
245: end if;
246: if (l_procedureEnabled) then
247: ecx_debug.pop(i_method_name);
248: end if;
243: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
244: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
245: end if;
246: if (l_procedureEnabled) then
247: ecx_debug.pop(i_method_name);
248: end if;
249: raise ecx_utils.program_exit;
250: when xmlDOM.WRONG_DOCUMENT_ERR then
251: ecx_debug.setErrorInfo(1,20,SQLERRM);
247: ecx_debug.pop(i_method_name);
248: end if;
249: raise ecx_utils.program_exit;
250: when xmlDOM.WRONG_DOCUMENT_ERR then
251: ecx_debug.setErrorInfo(1,20,SQLERRM);
252: if(l_unexpectedEnabled) then
253: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
254: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
255: end if;
249: raise ecx_utils.program_exit;
250: when xmlDOM.WRONG_DOCUMENT_ERR then
251: ecx_debug.setErrorInfo(1,20,SQLERRM);
252: if(l_unexpectedEnabled) then
253: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
254: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
255: end if;
256: if (l_procedureEnabled) then
257: ecx_debug.pop(i_method_name);
250: when xmlDOM.WRONG_DOCUMENT_ERR then
251: ecx_debug.setErrorInfo(1,20,SQLERRM);
252: if(l_unexpectedEnabled) then
253: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
254: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
255: end if;
256: if (l_procedureEnabled) then
257: ecx_debug.pop(i_method_name);
258: end if;
253: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
254: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
255: end if;
256: if (l_procedureEnabled) then
257: ecx_debug.pop(i_method_name);
258: end if;
259: raise ecx_utils.program_exit;
260: when xmlDOM.INVALID_CHARACTER_ERR then
261: ecx_debug.setErrorInfo(1,20,SQLERRM);
257: ecx_debug.pop(i_method_name);
258: end if;
259: raise ecx_utils.program_exit;
260: when xmlDOM.INVALID_CHARACTER_ERR then
261: ecx_debug.setErrorInfo(1,20,SQLERRM);
262: if(l_unexpectedEnabled) then
263: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
264: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
265: end if;
259: raise ecx_utils.program_exit;
260: when xmlDOM.INVALID_CHARACTER_ERR then
261: ecx_debug.setErrorInfo(1,20,SQLERRM);
262: if(l_unexpectedEnabled) then
263: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
264: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
265: end if;
266: if (l_procedureEnabled) then
267: ecx_debug.pop(i_method_name);
260: when xmlDOM.INVALID_CHARACTER_ERR then
261: ecx_debug.setErrorInfo(1,20,SQLERRM);
262: if(l_unexpectedEnabled) then
263: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
264: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
265: end if;
266: if (l_procedureEnabled) then
267: ecx_debug.pop(i_method_name);
268: end if;
263: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
264: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
265: end if;
266: if (l_procedureEnabled) then
267: ecx_debug.pop(i_method_name);
268: end if;
269: raise ecx_utils.program_exit;
270: when xmlDOM.NO_DATA_ALLOWED_ERR then
271: ecx_debug.setErrorInfo(1,20,SQLERRM);
267: ecx_debug.pop(i_method_name);
268: end if;
269: raise ecx_utils.program_exit;
270: when xmlDOM.NO_DATA_ALLOWED_ERR then
271: ecx_debug.setErrorInfo(1,20,SQLERRM);
272: if(l_unexpectedEnabled) then
273: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
274: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
275: end if;
269: raise ecx_utils.program_exit;
270: when xmlDOM.NO_DATA_ALLOWED_ERR then
271: ecx_debug.setErrorInfo(1,20,SQLERRM);
272: if(l_unexpectedEnabled) then
273: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
274: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
275: end if;
276: if (l_procedureEnabled) then
277: ecx_debug.pop(i_method_name);
270: when xmlDOM.NO_DATA_ALLOWED_ERR then
271: ecx_debug.setErrorInfo(1,20,SQLERRM);
272: if(l_unexpectedEnabled) then
273: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
274: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
275: end if;
276: if (l_procedureEnabled) then
277: ecx_debug.pop(i_method_name);
278: end if;
273: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
274: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
275: end if;
276: if (l_procedureEnabled) then
277: ecx_debug.pop(i_method_name);
278: end if;
279: raise ecx_utils.program_exit;
280: when xmlDOM.No_MODIFICATION_ALLOWED_ERR then
281: ecx_debug.setErrorInfo(1,20,SQLERRM);
277: ecx_debug.pop(i_method_name);
278: end if;
279: raise ecx_utils.program_exit;
280: when xmlDOM.No_MODIFICATION_ALLOWED_ERR then
281: ecx_debug.setErrorInfo(1,20,SQLERRM);
282: if(l_unexpectedEnabled) then
283: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
284: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
285: end if;
279: raise ecx_utils.program_exit;
280: when xmlDOM.No_MODIFICATION_ALLOWED_ERR then
281: ecx_debug.setErrorInfo(1,20,SQLERRM);
282: if(l_unexpectedEnabled) then
283: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
284: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
285: end if;
286: if (l_procedureEnabled) then
287: ecx_debug.pop(i_method_name);
280: when xmlDOM.No_MODIFICATION_ALLOWED_ERR then
281: ecx_debug.setErrorInfo(1,20,SQLERRM);
282: if(l_unexpectedEnabled) then
283: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
284: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
285: end if;
286: if (l_procedureEnabled) then
287: ecx_debug.pop(i_method_name);
288: end if;
283: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
284: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
285: end if;
286: if (l_procedureEnabled) then
287: ecx_debug.pop(i_method_name);
288: end if;
289: raise ecx_utils.program_exit;
290: when xmlDOM.NOT_FOUND_ERR then
291: ecx_debug.setErrorInfo(1,20,SQLERRM);
287: ecx_debug.pop(i_method_name);
288: end if;
289: raise ecx_utils.program_exit;
290: when xmlDOM.NOT_FOUND_ERR then
291: ecx_debug.setErrorInfo(1,20,SQLERRM);
292: if(l_unexpectedEnabled) then
293: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
294: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
295: end if;
289: raise ecx_utils.program_exit;
290: when xmlDOM.NOT_FOUND_ERR then
291: ecx_debug.setErrorInfo(1,20,SQLERRM);
292: if(l_unexpectedEnabled) then
293: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
294: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
295: end if;
296: if (l_procedureEnabled) then
297: ecx_debug.pop(i_method_name);
290: when xmlDOM.NOT_FOUND_ERR then
291: ecx_debug.setErrorInfo(1,20,SQLERRM);
292: if(l_unexpectedEnabled) then
293: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
294: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
295: end if;
296: if (l_procedureEnabled) then
297: ecx_debug.pop(i_method_name);
298: end if;
293: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
294: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
295: end if;
296: if (l_procedureEnabled) then
297: ecx_debug.pop(i_method_name);
298: end if;
299: raise ecx_utils.program_exit;
300: when xmlDOM.NOT_SUPPORTED_ERR then
301: ecx_debug.setErrorInfo(1,20,SQLERRM);
297: ecx_debug.pop(i_method_name);
298: end if;
299: raise ecx_utils.program_exit;
300: when xmlDOM.NOT_SUPPORTED_ERR then
301: ecx_debug.setErrorInfo(1,20,SQLERRM);
302: if(l_unexpectedEnabled) then
303: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
304: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
305: end if;
299: raise ecx_utils.program_exit;
300: when xmlDOM.NOT_SUPPORTED_ERR then
301: ecx_debug.setErrorInfo(1,20,SQLERRM);
302: if(l_unexpectedEnabled) then
303: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
304: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
305: end if;
306: if (l_procedureEnabled) then
307: ecx_debug.pop(i_method_name);
300: when xmlDOM.NOT_SUPPORTED_ERR then
301: ecx_debug.setErrorInfo(1,20,SQLERRM);
302: if(l_unexpectedEnabled) then
303: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
304: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
305: end if;
306: if (l_procedureEnabled) then
307: ecx_debug.pop(i_method_name);
308: end if;
303: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
304: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
305: end if;
306: if (l_procedureEnabled) then
307: ecx_debug.pop(i_method_name);
308: end if;
309: raise ecx_utils.program_exit;
310: when xmlDOM.INUSE_ATTRIBUTE_ERR then
311: ecx_debug.setErrorInfo(1,20,SQLERRM);
307: ecx_debug.pop(i_method_name);
308: end if;
309: raise ecx_utils.program_exit;
310: when xmlDOM.INUSE_ATTRIBUTE_ERR then
311: ecx_debug.setErrorInfo(1,20,SQLERRM);
312: if(l_unexpectedEnabled) then
313: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
314: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
315: end if;
309: raise ecx_utils.program_exit;
310: when xmlDOM.INUSE_ATTRIBUTE_ERR then
311: ecx_debug.setErrorInfo(1,20,SQLERRM);
312: if(l_unexpectedEnabled) then
313: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
314: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
315: end if;
316: if (l_procedureEnabled) then
317: ecx_debug.pop(i_method_name);
310: when xmlDOM.INUSE_ATTRIBUTE_ERR then
311: ecx_debug.setErrorInfo(1,20,SQLERRM);
312: if(l_unexpectedEnabled) then
313: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
314: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
315: end if;
316: if (l_procedureEnabled) then
317: ecx_debug.pop(i_method_name);
318: end if;
313: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
314: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
315: end if;
316: if (l_procedureEnabled) then
317: ecx_debug.pop(i_method_name);
318: end if;
319: raise ecx_utils.program_exit;
320: when others then
321: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.PARSEPAYLOAD ');
317: ecx_debug.pop(i_method_name);
318: end if;
319: raise ecx_utils.program_exit;
320: when others then
321: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.PARSEPAYLOAD ');
322: if(l_unexpectedEnabled) then
323: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
324: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
325: end if;
319: raise ecx_utils.program_exit;
320: when others then
321: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.PARSEPAYLOAD ');
322: if(l_unexpectedEnabled) then
323: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
324: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
325: end if;
326: if (l_procedureEnabled) then
327: ecx_debug.pop(i_method_name);
320: when others then
321: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.PARSEPAYLOAD ');
322: if(l_unexpectedEnabled) then
323: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
324: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
325: end if;
326: if (l_procedureEnabled) then
327: ecx_debug.pop(i_method_name);
328: end if;
323: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
324: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
325: end if;
326: if (l_procedureEnabled) then
327: ecx_debug.pop(i_method_name);
328: end if;
329: raise ecx_utils.program_exit;
330: end parsepayload;
331:
350:
351: begin
352: g_instlmode := wf_core.translate('WF_INSTALL');
353: if (l_procedureEnabled) then
354: ecx_debug.push(i_method_name);
355: end if;
356: dbms_lob.createtemporary(i_xmldoc, TRUE,DBMS_LOB.SESSION);
357: dbms_lob.trim(i_xmldoc, 0);
358: xmlDOM.writetoCLOB(ecx_utils.g_xmldoc,i_xmldoc);
361: if (l_statementEnabled)
362: then
363: IF g_instlmode = 'EMBEDDED' THEN
364: fnd_message.set_name('ecx', 'XML File for logging');
365: attachment_id := fnd_log.message_with_attachment(fnd_log.level_statement, substr(ecx_debug.g_aflog_module_name,1,length(ecx_debug.g_aflog_module_name)-4)||'.xml', TRUE);
366: if(attachment_id <> -1 AND i_xmldoc is not null) then
367: clength := dbms_lob.getlength(i_xmldoc);
368: while clength >= offset LOOP
369: ctemp := dbms_lob.substr(i_xmldoc,g_varmaxlength,offset);
381: end if;
382:
383:
384: if (l_procedureEnabled) then
385: ecx_debug.pop(i_method_name);
386: end if;
387: end writeXMLToFile;
388:
389:
405: l_parseXML boolean;
406:
407: begin
408: if (l_procedureEnabled) then
409: ecx_debug.push(i_method_name);
410: end if;
411: if(l_statementEnabled) then
412: ecx_debug.log(l_statement,'ecx_utils.g_map_id',ecx_utils.g_map_id,i_method_name);
413: ecx_debug.log(l_statement,'i_map_id',i_map_id,i_method_name);
408: if (l_procedureEnabled) then
409: ecx_debug.push(i_method_name);
410: end if;
411: if(l_statementEnabled) then
412: ecx_debug.log(l_statement,'ecx_utils.g_map_id',ecx_utils.g_map_id,i_method_name);
413: ecx_debug.log(l_statement,'i_map_id',i_map_id,i_method_name);
414: ecx_debug.log(l_statement,'i_header_id',i_header_id,i_method_name);
415: ecx_debug.log(l_statement,'i_rcv_tp_id',i_rcv_tp_id,i_method_name);
416: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
409: ecx_debug.push(i_method_name);
410: end if;
411: if(l_statementEnabled) then
412: ecx_debug.log(l_statement,'ecx_utils.g_map_id',ecx_utils.g_map_id,i_method_name);
413: ecx_debug.log(l_statement,'i_map_id',i_map_id,i_method_name);
414: ecx_debug.log(l_statement,'i_header_id',i_header_id,i_method_name);
415: ecx_debug.log(l_statement,'i_rcv_tp_id',i_rcv_tp_id,i_method_name);
416: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
417: end if;
410: end if;
411: if(l_statementEnabled) then
412: ecx_debug.log(l_statement,'ecx_utils.g_map_id',ecx_utils.g_map_id,i_method_name);
413: ecx_debug.log(l_statement,'i_map_id',i_map_id,i_method_name);
414: ecx_debug.log(l_statement,'i_header_id',i_header_id,i_method_name);
415: ecx_debug.log(l_statement,'i_rcv_tp_id',i_rcv_tp_id,i_method_name);
416: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
417: end if;
418: -- Set the Transaction direction
411: if(l_statementEnabled) then
412: ecx_debug.log(l_statement,'ecx_utils.g_map_id',ecx_utils.g_map_id,i_method_name);
413: ecx_debug.log(l_statement,'i_map_id',i_map_id,i_method_name);
414: ecx_debug.log(l_statement,'i_header_id',i_header_id,i_method_name);
415: ecx_debug.log(l_statement,'i_rcv_tp_id',i_rcv_tp_id,i_method_name);
416: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
417: end if;
418: -- Set the Transaction direction
419: ecx_utils.g_rec_tp_id := i_rcv_tp_id;
412: ecx_debug.log(l_statement,'ecx_utils.g_map_id',ecx_utils.g_map_id,i_method_name);
413: ecx_debug.log(l_statement,'i_map_id',i_map_id,i_method_name);
414: ecx_debug.log(l_statement,'i_header_id',i_header_id,i_method_name);
415: ecx_debug.log(l_statement,'i_rcv_tp_id',i_rcv_tp_id,i_method_name);
416: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
417: end if;
418: -- Set the Transaction direction
419: ecx_utils.g_rec_tp_id := i_rcv_tp_id;
420: ecx_utils.g_direction := 'IN';
456: end if;
457:
458: if (ecx_utils.dom_printing or (ecx_utils.structure_printing and l_parseXML)) then
459: if(l_statementEnabled) then
460: ecx_debug.log(l_statement,'XML is validated by the parser.',i_method_name);
461: end if;
462: writeXMLToFile(i_xmldoc);
463:
464: begin
470: null;
471: end;
472: else
473: if(l_statementEnabled) then
474: ecx_debug.log(l_statement,'XML is not validated by the parser.',i_method_name);
475: end if;
476: end if;
477: --for bug 5609625
478: xmlparser.freeparser(ecx_utils.g_parser);
482: end if;
483: ---end of 5609625
484:
485: if (l_procedureEnabled) then
486: ecx_debug.pop(i_method_name);
487: end if;
488:
489: exception
490: when ecx_utils.program_exit then
488:
489: exception
490: when ecx_utils.program_exit then
491: if (l_procedureEnabled) then
492: ecx_debug.pop(i_method_name);
493: end if;
494: if(l_unexpectedEnabled) then
495: ecx_debug.log(l_unexpected,'Clean-up last_printed',i_method_name);
496: end if;
491: if (l_procedureEnabled) then
492: ecx_debug.pop(i_method_name);
493: end if;
494: if(l_unexpectedEnabled) then
495: ecx_debug.log(l_unexpected,'Clean-up last_printed',i_method_name);
496: end if;
497: ecx_print_local.last_printed := -1;
498:
499: begin
506: end;
507: raise ecx_utils.program_exit;
508:
509: when others then
510: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.processXMLData ');
511: if(l_unexpectedEnabled) then
512: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
513: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
514: ecx_debug.log(l_unexpected,'Clean-up last_printed',i_method_name);
508:
509: when others then
510: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.processXMLData ');
511: if(l_unexpectedEnabled) then
512: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
513: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
514: ecx_debug.log(l_unexpected,'Clean-up last_printed',i_method_name);
515: end if;
516: ecx_print_local.last_printed := -1;
509: when others then
510: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.processXMLData ');
511: if(l_unexpectedEnabled) then
512: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
513: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
514: ecx_debug.log(l_unexpected,'Clean-up last_printed',i_method_name);
515: end if;
516: ecx_print_local.last_printed := -1;
517: if (l_procedureEnabled) then
510: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.processXMLData ');
511: if(l_unexpectedEnabled) then
512: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
513: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
514: ecx_debug.log(l_unexpected,'Clean-up last_printed',i_method_name);
515: end if;
516: ecx_print_local.last_printed := -1;
517: if (l_procedureEnabled) then
518: ecx_debug.pop(i_method_name);
514: ecx_debug.log(l_unexpected,'Clean-up last_printed',i_method_name);
515: end if;
516: ecx_print_local.last_printed := -1;
517: if (l_procedureEnabled) then
518: ecx_debug.pop(i_method_name);
519: end if;
520:
521: begin
522: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then
625: where tp_detail_id = p_routing_id;
626:
627: begin
628: if (l_procedureEnabled) then
629: ecx_debug.push(i_method_name);
630: end if;
631: if(l_statementEnabled) then
632: ecx_debug.log(l_statement,'m_message_standard',m_message_standard,i_method_name);
633: ecx_debug.log(l_statement,'m_ext_type',m_ext_type,i_method_name);
628: if (l_procedureEnabled) then
629: ecx_debug.push(i_method_name);
630: end if;
631: if(l_statementEnabled) then
632: ecx_debug.log(l_statement,'m_message_standard',m_message_standard,i_method_name);
633: ecx_debug.log(l_statement,'m_ext_type',m_ext_type,i_method_name);
634: ecx_debug.log(l_statement,'m_ext_subtype',m_ext_subtype,i_method_name);
635: ecx_debug.log(l_statement,'m_party_ext_code',m_party_ext_code,i_method_name);
636: ecx_debug.log(l_statement,'m_document_number',m_document_number,i_method_name);
629: ecx_debug.push(i_method_name);
630: end if;
631: if(l_statementEnabled) then
632: ecx_debug.log(l_statement,'m_message_standard',m_message_standard,i_method_name);
633: ecx_debug.log(l_statement,'m_ext_type',m_ext_type,i_method_name);
634: ecx_debug.log(l_statement,'m_ext_subtype',m_ext_subtype,i_method_name);
635: ecx_debug.log(l_statement,'m_party_ext_code',m_party_ext_code,i_method_name);
636: ecx_debug.log(l_statement,'m_document_number',m_document_number,i_method_name);
637: ecx_debug.log(l_statement,'m_routing_ext_code',m_routing_ext_code,i_method_name);
630: end if;
631: if(l_statementEnabled) then
632: ecx_debug.log(l_statement,'m_message_standard',m_message_standard,i_method_name);
633: ecx_debug.log(l_statement,'m_ext_type',m_ext_type,i_method_name);
634: ecx_debug.log(l_statement,'m_ext_subtype',m_ext_subtype,i_method_name);
635: ecx_debug.log(l_statement,'m_party_ext_code',m_party_ext_code,i_method_name);
636: ecx_debug.log(l_statement,'m_document_number',m_document_number,i_method_name);
637: ecx_debug.log(l_statement,'m_routing_ext_code',m_routing_ext_code,i_method_name);
638: end if;
631: if(l_statementEnabled) then
632: ecx_debug.log(l_statement,'m_message_standard',m_message_standard,i_method_name);
633: ecx_debug.log(l_statement,'m_ext_type',m_ext_type,i_method_name);
634: ecx_debug.log(l_statement,'m_ext_subtype',m_ext_subtype,i_method_name);
635: ecx_debug.log(l_statement,'m_party_ext_code',m_party_ext_code,i_method_name);
636: ecx_debug.log(l_statement,'m_document_number',m_document_number,i_method_name);
637: ecx_debug.log(l_statement,'m_routing_ext_code',m_routing_ext_code,i_method_name);
638: end if;
639: ecx_utils.i_ret_code :=0;
632: ecx_debug.log(l_statement,'m_message_standard',m_message_standard,i_method_name);
633: ecx_debug.log(l_statement,'m_ext_type',m_ext_type,i_method_name);
634: ecx_debug.log(l_statement,'m_ext_subtype',m_ext_subtype,i_method_name);
635: ecx_debug.log(l_statement,'m_party_ext_code',m_party_ext_code,i_method_name);
636: ecx_debug.log(l_statement,'m_document_number',m_document_number,i_method_name);
637: ecx_debug.log(l_statement,'m_routing_ext_code',m_routing_ext_code,i_method_name);
638: end if;
639: ecx_utils.i_ret_code :=0;
640: ecx_utils.i_errbuf :=null;
633: ecx_debug.log(l_statement,'m_ext_type',m_ext_type,i_method_name);
634: ecx_debug.log(l_statement,'m_ext_subtype',m_ext_subtype,i_method_name);
635: ecx_debug.log(l_statement,'m_party_ext_code',m_party_ext_code,i_method_name);
636: ecx_debug.log(l_statement,'m_document_number',m_document_number,i_method_name);
637: ecx_debug.log(l_statement,'m_routing_ext_code',m_routing_ext_code,i_method_name);
638: end if;
639: ecx_utils.i_ret_code :=0;
640: ecx_utils.i_errbuf :=null;
641: --MLS
652: i_confirmation;
653:
654: if c_tp_details%NOTFOUND
655: then
656: ecx_debug.setErrorInfo(1,30,'ECX_TRANACTION_NOT_ENABLED',
657: 'p_ext_type',
658: m_ext_type,
659: 'p_ext_subtype',
660: m_ext_subtype,
661: 'p_party_ext_code',
662: m_party_ext_code);
663:
664: if(l_statementEnabled) then
665: ecx_debug.log(l_statement,'ECX','ECX_TRANACTION_NOT_ENABLED',
666: i_method_name,
667: 'p_ext_type',
668: m_ext_type,
669: 'p_ext_subtype',
679: close c_tp_details;
680: -- Set the Sender's tp_id
681: ecx_utils.g_snd_tp_id := i_header_id;
682: if(l_statementEnabled) then
683: ecx_debug.log(l_statement,'i_map_id',i_map_id,i_method_name);
684: ecx_debug.log(l_statement,'i_routing_id',i_routing_id,i_method_name);
685: ecx_debug.log(l_statement,'i_header_id',i_header_id,i_method_name);
686: ecx_debug.log(l_statement,'i_confirmation',i_confirmation,i_method_name);
687: end if;
680: -- Set the Sender's tp_id
681: ecx_utils.g_snd_tp_id := i_header_id;
682: if(l_statementEnabled) then
683: ecx_debug.log(l_statement,'i_map_id',i_map_id,i_method_name);
684: ecx_debug.log(l_statement,'i_routing_id',i_routing_id,i_method_name);
685: ecx_debug.log(l_statement,'i_header_id',i_header_id,i_method_name);
686: ecx_debug.log(l_statement,'i_confirmation',i_confirmation,i_method_name);
687: end if;
688:
681: ecx_utils.g_snd_tp_id := i_header_id;
682: if(l_statementEnabled) then
683: ecx_debug.log(l_statement,'i_map_id',i_map_id,i_method_name);
684: ecx_debug.log(l_statement,'i_routing_id',i_routing_id,i_method_name);
685: ecx_debug.log(l_statement,'i_header_id',i_header_id,i_method_name);
686: ecx_debug.log(l_statement,'i_confirmation',i_confirmation,i_method_name);
687: end if;
688:
689: if (i_routing_id is not null or m_routing_ext_code is not null) then if not (is_routing_supported(i_map_id)) then
682: if(l_statementEnabled) then
683: ecx_debug.log(l_statement,'i_map_id',i_map_id,i_method_name);
684: ecx_debug.log(l_statement,'i_routing_id',i_routing_id,i_method_name);
685: ecx_debug.log(l_statement,'i_header_id',i_header_id,i_method_name);
686: ecx_debug.log(l_statement,'i_confirmation',i_confirmation,i_method_name);
687: end if;
688:
689: if (i_routing_id is not null or m_routing_ext_code is not null) then if not (is_routing_supported(i_map_id)) then
690: ecx_debug.setErrorInfo(2, 25, 'ECX_ROUTING_NOT_SUPPORTED');
686: ecx_debug.log(l_statement,'i_confirmation',i_confirmation,i_method_name);
687: end if;
688:
689: if (i_routing_id is not null or m_routing_ext_code is not null) then if not (is_routing_supported(i_map_id)) then
690: ecx_debug.setErrorInfo(2, 25, 'ECX_ROUTING_NOT_SUPPORTED');
691: raise ecx_utils.program_exit;
692: end if;
693: end if;
694:
701: then
702: if m_routing_ext_code is not null
703: then
704: if(l_statementEnabled) then
705: ecx_debug.log(l_statement,'Dynamic Routing1',m_routing_ext_code,i_method_name);
706: end if;
707: open get_routing_for_extcode ( m_ext_type,m_ext_subtype,m_routing_ext_code,m_message_standard, m_message_type);
708: fetch get_routing_for_extcode
709: into i_rcv_tp_id,i_routing_id;
709: into i_rcv_tp_id,i_routing_id;
710:
711: if get_routing_for_extcode%NOTFOUND
712: then
713: ecx_debug.setErrorInfo(1,30,
714: 'ECX_DYN_ROUTING_NOT_ENABLED',
715: 'p_ext_type',
716: m_ext_type,
717: 'p_ext_subtype',
719: 'p_party_ext_code',
720: m_party_ext_code);
721:
722: if(l_statementEnabled) then
723: ecx_debug.log(l_statement,'ECX',
724: 'ECX_DYN_ROUTING_NOT_ENABLED',
725: i_method_name,
726: 'p_ext_type',
727: m_ext_type,
742: fetch get_receiver_tp_id into i_rcv_tp_id;
743:
744: if get_receiver_tp_id%NOTFOUND
745: then
746: ecx_debug.setErrorInfo(1,30,
747: 'ECX_STATIC_ROUTING_NOT_ENABLED',
748: 'p_ext_type',
749: m_ext_type,
750: 'p_ext_subtype',
752: 'p_party_ext_code',
753: m_party_ext_code);
754:
755: if(l_statementEnabled) then
756: ecx_debug.log(l_statement,'ECX',
757: 'ECX_STATIC_ROUTING_NOT_ENABLED',
758: i_method_name,
759: 'p_ext_type',
760: m_ext_type,
769: raise ecx_utils.program_exit;
770: end if;
771: close get_receiver_tp_id;
772: if(l_statementEnabled) then
773: ecx_debug.log(l_statement,'Static Routing',i_method_name);
774: end if;
775:
776: end if;
777: ecx_utils.g_rec_tp_id := i_rcv_tp_id;
775:
776: end if;
777: ecx_utils.g_rec_tp_id := i_rcv_tp_id;
778: if(l_statementEnabled) then
779: ecx_debug.log(l_statement,'Receiver Tp Id ',i_rcv_tp_id,i_method_name);
780: end if;
781:
782: else
783: --- Check for m_routing_ext_code if not null then use it
784:
785: if m_routing_ext_code is not null
786: then
787: if(l_statementEnabled) then
788: ecx_debug.log(l_statement,'Dynamic Routing2',m_routing_ext_code,i_method_name);
789: end if;
790: open get_routing_for_extcode ( m_ext_type,m_ext_subtype,m_routing_ext_code,m_message_standard, m_message_type);
791: fetch get_routing_for_extcode
792: into i_rcv_tp_id,i_routing_id;
792: into i_rcv_tp_id,i_routing_id;
793:
794: if get_routing_for_extcode%NOTFOUND
795: then
796: ecx_debug.setErrorInfo(1,30,
797: 'ECX_DYN_ROUTING_NOT_ENABLED',
798: 'p_ext_type',
799: m_ext_type,
800: 'p_ext_subtype',
802: 'p_party_ext_code',
803: m_party_ext_code);
804:
805: if(l_statementEnabled) then
806: ecx_debug.log(l_statement,'ECX',
807: 'ECX_DYN_ROUTING_NOT_ENABLED',
808: i_method_name,
809: 'p_ext_type',
810: m_ext_type,
828: -- Only if map is xml to xml or dtd to dtd type
829: -- Give warning message.
830: ecx_utils.g_ret_code := 1;
831: if(l_statementEnabled) then
832: ecx_debug.log(l_statement,'ecx_utils.g_ret_code',' 1',i_method_name);
833: end if;
834: end if;
835: end if;
836: end if;
838: -- need to set the g_routing_id here, so that it would set it
839: -- for both dynamic and static routing.
840: ecx_utils.g_routing_id := i_routing_id;
841: if(l_statementEnabled) then
842: ecx_debug.log(l_statement,'ecx_utils.g_routing_id',ecx_utils.g_routing_id,
843: i_method_name);
844: end if;
845:
846: /**
862: end if;
863:
864:
865: if(l_statementEnabled) then
866: ecx_debug.log(l_statement,'ECX','ECX_START_INBOUND',i_method_name, 'TRANSACTION_TYPE', m_ext_type);
867: end if;
868: processXMLData
869: (
870: i_map_id,
875: o_payload,
876: m_message_type
877: );
878: if(l_statementEnabled) then
879: ecx_debug.log(l_statement, 'ECX', 'ECX_END_INBOUND',i_method_name, 'TRANSACTION_TYPE', m_ext_type);
880: end if;
881:
882: savepoint save_xml_doc;
883:
884: --If it is a pass through transaction , then put the Message on the Outbound Queue
885: if i_routing_id is not null
886: then
887: if(l_statementEnabled) then
888: ecx_debug.log(l_statement,'Routing Enqueued for MSGID : '|| m_msgid,i_method_name);
889: end if;
890: put_on_outbound
891: (
892: o_payload,
896: );
897:
898: else
899: if(l_statementEnabled) then
900: ecx_debug.log(l_statement,'Update doclogs for Msg Id : ' , m_msgid,i_method_name);
901: end if;
902: ecx_errorlog.update_log_document
903: (
904: m_msgid,
913: then
914: dbms_lob.freetemporary (o_payload);
915: end if;
916: if (l_procedureEnabled) then
917: ecx_debug.pop(i_method_name);
918: end if;
919: exception
920: when ecx_utils.program_exit then
921: --ecx_utils.g_map_id := -1;
919: exception
920: when ecx_utils.program_exit then
921: --ecx_utils.g_map_id := -1;
922: if (l_procedureEnabled) then
923: ecx_debug.pop(i_method_name);
924: end if;
925:
926: if o_payload is not null
927: then
929: end if;
930: raise ecx_utils.program_exit;
931: when others then
932: --ecx_utils.g_map_id := -1;
933: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.VALIDATE_MESSAGE ');
934: if(l_unexpectedEnabled) then
935: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
936: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
937: end if;
931: when others then
932: --ecx_utils.g_map_id := -1;
933: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.VALIDATE_MESSAGE ');
934: if(l_unexpectedEnabled) then
935: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
936: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
937: end if;
938:
939: if o_payload is not null
932: --ecx_utils.g_map_id := -1;
933: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.VALIDATE_MESSAGE ');
934: if(l_unexpectedEnabled) then
935: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
936: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
937: end if;
938:
939: if o_payload is not null
940: then
940: then
941: dbms_lob.freetemporary (o_payload);
942: end if;
943: if (l_procedureEnabled) then
944: ecx_debug.pop(i_method_name);
945: end if;
946: raise ecx_utils.program_exit;
947: end validate_message;
948:
964: l_retmsg Varchar2(200) := null;
965:
966: begin
967: if (l_procedureEnabled) then
968: ecx_debug.push(i_method_name);
969: end if;
970:
971: if(l_statementEnabled) then
972: ecx_debug.log(l_statement,'i_queue_name',i_queue_name,i_method_name);
968: ecx_debug.push(i_method_name);
969: end if;
970:
971: if(l_statementEnabled) then
972: ecx_debug.log(l_statement,'i_queue_name',i_queue_name,i_method_name);
973: end if;
974:
975: v_dequeueoptions.navigation := dbms_aq.FIRST_MESSAGE;
976: v_dequeueoptions.dequeue_mode := dbms_aq.BROWSE;
989:
990: --Retrieve the Message Attributes
991:
992: if(l_statementEnabled) then
993: ecx_debug.log(l_statement,'Message Standard',v_message.message_standard,i_method_name);
994: ecx_debug.log(l_statement,'Message Type',v_message.message_type,i_method_name);
995: ecx_debug.log(l_statement,'Transaction Type',v_message.transaction_type,i_method_name);
996: ecx_debug.log(l_statement,'Transaction Sub Type',v_message.transaction_subtype,i_method_name);
997: ecx_debug.log(l_statement,'Party Id',v_message.partyid,i_method_name);
990: --Retrieve the Message Attributes
991:
992: if(l_statementEnabled) then
993: ecx_debug.log(l_statement,'Message Standard',v_message.message_standard,i_method_name);
994: ecx_debug.log(l_statement,'Message Type',v_message.message_type,i_method_name);
995: ecx_debug.log(l_statement,'Transaction Type',v_message.transaction_type,i_method_name);
996: ecx_debug.log(l_statement,'Transaction Sub Type',v_message.transaction_subtype,i_method_name);
997: ecx_debug.log(l_statement,'Party Id',v_message.partyid,i_method_name);
998: ecx_debug.log(l_statement,'party Site Id',v_message.party_site_id,i_method_name);
991:
992: if(l_statementEnabled) then
993: ecx_debug.log(l_statement,'Message Standard',v_message.message_standard,i_method_name);
994: ecx_debug.log(l_statement,'Message Type',v_message.message_type,i_method_name);
995: ecx_debug.log(l_statement,'Transaction Type',v_message.transaction_type,i_method_name);
996: ecx_debug.log(l_statement,'Transaction Sub Type',v_message.transaction_subtype,i_method_name);
997: ecx_debug.log(l_statement,'Party Id',v_message.partyid,i_method_name);
998: ecx_debug.log(l_statement,'party Site Id',v_message.party_site_id,i_method_name);
999: ecx_debug.log(l_statement,'party type',v_message.party_type,i_method_name);
992: if(l_statementEnabled) then
993: ecx_debug.log(l_statement,'Message Standard',v_message.message_standard,i_method_name);
994: ecx_debug.log(l_statement,'Message Type',v_message.message_type,i_method_name);
995: ecx_debug.log(l_statement,'Transaction Type',v_message.transaction_type,i_method_name);
996: ecx_debug.log(l_statement,'Transaction Sub Type',v_message.transaction_subtype,i_method_name);
997: ecx_debug.log(l_statement,'Party Id',v_message.partyid,i_method_name);
998: ecx_debug.log(l_statement,'party Site Id',v_message.party_site_id,i_method_name);
999: ecx_debug.log(l_statement,'party type',v_message.party_type,i_method_name);
1000: ecx_debug.log(l_statement,'protocol_type ',v_message.protocol_type,i_method_name);
993: ecx_debug.log(l_statement,'Message Standard',v_message.message_standard,i_method_name);
994: ecx_debug.log(l_statement,'Message Type',v_message.message_type,i_method_name);
995: ecx_debug.log(l_statement,'Transaction Type',v_message.transaction_type,i_method_name);
996: ecx_debug.log(l_statement,'Transaction Sub Type',v_message.transaction_subtype,i_method_name);
997: ecx_debug.log(l_statement,'Party Id',v_message.partyid,i_method_name);
998: ecx_debug.log(l_statement,'party Site Id',v_message.party_site_id,i_method_name);
999: ecx_debug.log(l_statement,'party type',v_message.party_type,i_method_name);
1000: ecx_debug.log(l_statement,'protocol_type ',v_message.protocol_type,i_method_name);
1001: ecx_debug.log(l_statement,'Protocol Address ',v_message.protocol_address,i_method_name);
994: ecx_debug.log(l_statement,'Message Type',v_message.message_type,i_method_name);
995: ecx_debug.log(l_statement,'Transaction Type',v_message.transaction_type,i_method_name);
996: ecx_debug.log(l_statement,'Transaction Sub Type',v_message.transaction_subtype,i_method_name);
997: ecx_debug.log(l_statement,'Party Id',v_message.partyid,i_method_name);
998: ecx_debug.log(l_statement,'party Site Id',v_message.party_site_id,i_method_name);
999: ecx_debug.log(l_statement,'party type',v_message.party_type,i_method_name);
1000: ecx_debug.log(l_statement,'protocol_type ',v_message.protocol_type,i_method_name);
1001: ecx_debug.log(l_statement,'Protocol Address ',v_message.protocol_address,i_method_name);
1002: ecx_debug.log(l_statement,'Username ',v_message.username,i_method_name);
995: ecx_debug.log(l_statement,'Transaction Type',v_message.transaction_type,i_method_name);
996: ecx_debug.log(l_statement,'Transaction Sub Type',v_message.transaction_subtype,i_method_name);
997: ecx_debug.log(l_statement,'Party Id',v_message.partyid,i_method_name);
998: ecx_debug.log(l_statement,'party Site Id',v_message.party_site_id,i_method_name);
999: ecx_debug.log(l_statement,'party type',v_message.party_type,i_method_name);
1000: ecx_debug.log(l_statement,'protocol_type ',v_message.protocol_type,i_method_name);
1001: ecx_debug.log(l_statement,'Protocol Address ',v_message.protocol_address,i_method_name);
1002: ecx_debug.log(l_statement,'Username ',v_message.username,i_method_name);
1003: ecx_debug.log(l_statement,'Password ',v_message.password,i_method_name);
996: ecx_debug.log(l_statement,'Transaction Sub Type',v_message.transaction_subtype,i_method_name);
997: ecx_debug.log(l_statement,'Party Id',v_message.partyid,i_method_name);
998: ecx_debug.log(l_statement,'party Site Id',v_message.party_site_id,i_method_name);
999: ecx_debug.log(l_statement,'party type',v_message.party_type,i_method_name);
1000: ecx_debug.log(l_statement,'protocol_type ',v_message.protocol_type,i_method_name);
1001: ecx_debug.log(l_statement,'Protocol Address ',v_message.protocol_address,i_method_name);
1002: ecx_debug.log(l_statement,'Username ',v_message.username,i_method_name);
1003: ecx_debug.log(l_statement,'Password ',v_message.password,i_method_name);
1004: end if;
997: ecx_debug.log(l_statement,'Party Id',v_message.partyid,i_method_name);
998: ecx_debug.log(l_statement,'party Site Id',v_message.party_site_id,i_method_name);
999: ecx_debug.log(l_statement,'party type',v_message.party_type,i_method_name);
1000: ecx_debug.log(l_statement,'protocol_type ',v_message.protocol_type,i_method_name);
1001: ecx_debug.log(l_statement,'Protocol Address ',v_message.protocol_address,i_method_name);
1002: ecx_debug.log(l_statement,'Username ',v_message.username,i_method_name);
1003: ecx_debug.log(l_statement,'Password ',v_message.password,i_method_name);
1004: end if;
1005: begin
998: ecx_debug.log(l_statement,'party Site Id',v_message.party_site_id,i_method_name);
999: ecx_debug.log(l_statement,'party type',v_message.party_type,i_method_name);
1000: ecx_debug.log(l_statement,'protocol_type ',v_message.protocol_type,i_method_name);
1001: ecx_debug.log(l_statement,'Protocol Address ',v_message.protocol_address,i_method_name);
1002: ecx_debug.log(l_statement,'Username ',v_message.username,i_method_name);
1003: ecx_debug.log(l_statement,'Password ',v_message.password,i_method_name);
1004: end if;
1005: begin
1006: ecx_errorlog.log_document (
999: ecx_debug.log(l_statement,'party type',v_message.party_type,i_method_name);
1000: ecx_debug.log(l_statement,'protocol_type ',v_message.protocol_type,i_method_name);
1001: ecx_debug.log(l_statement,'Protocol Address ',v_message.protocol_address,i_method_name);
1002: ecx_debug.log(l_statement,'Username ',v_message.username,i_method_name);
1003: ecx_debug.log(l_statement,'Password ',v_message.password,i_method_name);
1004: end if;
1005: begin
1006: ecx_errorlog.log_document (
1007: l_retcode,
1029: );
1030:
1031: if (l_retcode = 1) then
1032: if(l_unexpectedEnabled) then
1033: ecx_debug.log(l_unexpected, l_retmsg,i_method_name);
1034: end if;
1035: elsif (l_retcode >= 2 ) then
1036: if(l_unexpectedEnabled) then
1037: ecx_debug.log(l_unexpected,l_retmsg,i_method_name);
1033: ecx_debug.log(l_unexpected, l_retmsg,i_method_name);
1034: end if;
1035: elsif (l_retcode >= 2 ) then
1036: if(l_unexpectedEnabled) then
1037: ecx_debug.log(l_unexpected,l_retmsg,i_method_name);
1038: end if;
1039: raise ecx_utils.program_exit;
1040: end if;
1041: end;
1039: raise ecx_utils.program_exit;
1040: end if;
1041: end;
1042: if(l_statementEnabled) then
1043: ecx_debug.log(l_statement,'MessageId', i_msgid,i_method_name);
1044: end if;
1045:
1046: end loop;
1047: if(l_statementEnabled) then
1044: end if;
1045:
1046: end loop;
1047: if(l_statementEnabled) then
1048: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
1049: end if;
1050: if (l_procedureEnabled) then
1051: ecx_debug.pop(i_method_name);
1052: end if;
1047: if(l_statementEnabled) then
1048: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
1049: end if;
1050: if (l_procedureEnabled) then
1051: ecx_debug.pop(i_method_name);
1052: end if;
1053: exception
1054: when ecx_utils.program_exit then
1055: raise;
1053: exception
1054: when ecx_utils.program_exit then
1055: raise;
1056: when others then
1057: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.GETMSG_FROM_QUEUE');
1058: if(l_unexpectedEnabled) then
1059: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1060: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1061: end if;
1055: raise;
1056: when others then
1057: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.GETMSG_FROM_QUEUE');
1058: if(l_unexpectedEnabled) then
1059: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1060: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1061: end if;
1062: raise ecx_utils.program_exit;
1063: end getmsg_from_queue;
1056: when others then
1057: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.GETMSG_FROM_QUEUE');
1058: if(l_unexpectedEnabled) then
1059: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1060: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1061: end if;
1062: raise ecx_utils.program_exit;
1063: end getmsg_from_queue;
1064:
1100:
1101: begin
1102:
1103: if (l_procedureEnabled) then
1104: ecx_debug.push(i_method_name);
1105: end if;
1106: if(l_statementEnabled) then
1107: ecx_debug.log(l_statement,'i_document_number',i_document_number,i_method_name);
1108: ecx_debug.log(l_statement,'i_tp_detail_id',i_tp_detail_id,i_method_name);
1103: if (l_procedureEnabled) then
1104: ecx_debug.push(i_method_name);
1105: end if;
1106: if(l_statementEnabled) then
1107: ecx_debug.log(l_statement,'i_document_number',i_document_number,i_method_name);
1108: ecx_debug.log(l_statement,'i_tp_detail_id',i_tp_detail_id,i_method_name);
1109: end if;
1110:
1111: begin
1104: ecx_debug.push(i_method_name);
1105: end if;
1106: if(l_statementEnabled) then
1107: ecx_debug.log(l_statement,'i_document_number',i_document_number,i_method_name);
1108: ecx_debug.log(l_statement,'i_tp_detail_id',i_tp_detail_id,i_method_name);
1109: end if;
1110:
1111: begin
1112: select es.standard_type standard_type,
1153: and eep.direction = 'OUT'
1154: and etd.tp_header_id = eth.tp_header_id;
1155: exception
1156: when others then
1157: ecx_debug.setErrorInfo(1,25,'ECX_NO_UNIQUE_TP_SETUP');
1158: raise ecx_utils.program_exit;
1159: end;
1160:
1161: if i_hub_user_id is not null
1176: where eh.hub_id = ehu.hub_id
1177: and ehu.hub_user_id = i_hub_user_id;
1178: exception
1179: when others then
1180: ecx_debug.setErrorInfo(1,25,'ECX_DELIVERY_HUB_NOT_SETUP');
1181: raise ecx_utils.program_exit;
1182: end;
1183: end if;
1184:
1183: end if;
1184:
1185: if i_destination_address is null
1186: then
1187: ecx_debug.setErrorInfo(1,25,'ECX_PROTOCOL_ADDR_NULL',
1188: 'p_tp_location_code', i_source_code,
1189: 'p_transaction_type', i_ext_type,
1190: 'p_transaction_subtype', i_ext_subtype,
1191: 'p_standard', i_standard_code);
1192:
1193: raise ecx_utils.program_exit;
1194: end if;
1195: if (l_statementEnabled) then
1196: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1197: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1198: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1199: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1200: ecx_debug.log(l_statement,'i_int_type', i_int_type,i_method_name);
1193: raise ecx_utils.program_exit;
1194: end if;
1195: if (l_statementEnabled) then
1196: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1197: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1198: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1199: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1200: ecx_debug.log(l_statement,'i_int_type', i_int_type,i_method_name);
1201: ecx_debug.log(l_statement,'i_int_subtype', i_int_subtype,i_method_name);
1194: end if;
1195: if (l_statementEnabled) then
1196: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1197: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1198: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1199: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1200: ecx_debug.log(l_statement,'i_int_type', i_int_type,i_method_name);
1201: ecx_debug.log(l_statement,'i_int_subtype', i_int_subtype,i_method_name);
1202: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1195: if (l_statementEnabled) then
1196: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1197: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1198: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1199: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1200: ecx_debug.log(l_statement,'i_int_type', i_int_type,i_method_name);
1201: ecx_debug.log(l_statement,'i_int_subtype', i_int_subtype,i_method_name);
1202: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1203: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
1196: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1197: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1198: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1199: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1200: ecx_debug.log(l_statement,'i_int_type', i_int_type,i_method_name);
1201: ecx_debug.log(l_statement,'i_int_subtype', i_int_subtype,i_method_name);
1202: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1203: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
1204: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
1197: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1198: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1199: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1200: ecx_debug.log(l_statement,'i_int_type', i_int_type,i_method_name);
1201: ecx_debug.log(l_statement,'i_int_subtype', i_int_subtype,i_method_name);
1202: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1203: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
1204: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
1205: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
1198: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1199: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1200: ecx_debug.log(l_statement,'i_int_type', i_int_type,i_method_name);
1201: ecx_debug.log(l_statement,'i_int_subtype', i_int_subtype,i_method_name);
1202: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1203: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
1204: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
1205: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
1206: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
1199: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1200: ecx_debug.log(l_statement,'i_int_type', i_int_type,i_method_name);
1201: ecx_debug.log(l_statement,'i_int_subtype', i_int_subtype,i_method_name);
1202: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1203: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
1204: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
1205: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
1206: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
1207: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name);
1200: ecx_debug.log(l_statement,'i_int_type', i_int_type,i_method_name);
1201: ecx_debug.log(l_statement,'i_int_subtype', i_int_subtype,i_method_name);
1202: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1203: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
1204: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
1205: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
1206: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
1207: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name);
1208: ecx_debug.log(l_statement,'i_party_site_id', i_party_site_id,i_method_name);
1201: ecx_debug.log(l_statement,'i_int_subtype', i_int_subtype,i_method_name);
1202: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1203: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
1204: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
1205: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
1206: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
1207: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name);
1208: ecx_debug.log(l_statement,'i_party_site_id', i_party_site_id,i_method_name);
1209: ecx_debug.log(l_statement,'i_party_type', i_party_type,i_method_name);
1202: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1203: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
1204: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
1205: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
1206: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
1207: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name);
1208: ecx_debug.log(l_statement,'i_party_site_id', i_party_site_id,i_method_name);
1209: ecx_debug.log(l_statement,'i_party_type', i_party_type,i_method_name);
1210: end if;
1203: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
1204: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
1205: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
1206: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
1207: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name);
1208: ecx_debug.log(l_statement,'i_party_site_id', i_party_site_id,i_method_name);
1209: ecx_debug.log(l_statement,'i_party_type', i_party_type,i_method_name);
1210: end if;
1211: -- call ecx_out_wf_qh.enqueue with the correct parameters
1204: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
1205: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
1206: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
1207: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name);
1208: ecx_debug.log(l_statement,'i_party_site_id', i_party_site_id,i_method_name);
1209: ecx_debug.log(l_statement,'i_party_type', i_party_type,i_method_name);
1210: end if;
1211: -- call ecx_out_wf_qh.enqueue with the correct parameters
1212: wf_event_t.initialize(i_event);
1205: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
1206: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
1207: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name);
1208: ecx_debug.log(l_statement,'i_party_site_id', i_party_site_id,i_method_name);
1209: ecx_debug.log(l_statement,'i_party_type', i_party_type,i_method_name);
1210: end if;
1211: -- call ecx_out_wf_qh.enqueue with the correct parameters
1212: wf_event_t.initialize(i_event);
1213: i_event.addParameterToList('PARTY_TYPE', i_party_type);
1248:
1249: i_event.setFromAgent(i_from_agt);
1250:
1251: if(l_statementEnabled) then
1252: ecx_debug.log(l_statement,'Calling WF_EVENT.Send for Enqueue',i_method_name);
1253: end if;
1254: wf_event.send(i_event);
1255: ecx_errorlog.outbound_log(i_event);
1256:
1262: if (ecx_out_wf_qh.retmsg is not null) then
1263: --ecx_utils.error_type := 30;
1264: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1265: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1266: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1267: if(l_statementEnabled) then
1268: ecx_debug.log(l_statement,ecx_debug.getMessage(ecx_utils.i_errbuf,
1269: ecx_utils.i_errparams),i_method_name); -- MLS
1270: end if;
1264: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1265: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1266: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1267: if(l_statementEnabled) then
1268: ecx_debug.log(l_statement,ecx_debug.getMessage(ecx_utils.i_errbuf,
1269: ecx_utils.i_errparams),i_method_name); -- MLS
1270: end if;
1271: end if;
1272:
1270: end if;
1271: end if;
1272:
1273: if(l_statementEnabled) then
1274: ecx_debug.log(l_statement,'Routed MsgId',i_out_msgid,i_method_name);
1275: end if;
1276: if (l_procedureEnabled) then
1277: ecx_debug.pop(i_method_name);
1278: end if;
1273: if(l_statementEnabled) then
1274: ecx_debug.log(l_statement,'Routed MsgId',i_out_msgid,i_method_name);
1275: end if;
1276: if (l_procedureEnabled) then
1277: ecx_debug.pop(i_method_name);
1278: end if;
1279: exception
1280: WHEN ECX_UTILS.PROGRAM_EXIT THEN
1281: --dbms_lob.freetemporary(i_xmldoc);
1279: exception
1280: WHEN ECX_UTILS.PROGRAM_EXIT THEN
1281: --dbms_lob.freetemporary(i_xmldoc);
1282: if (l_procedureEnabled) then
1283: ecx_debug.pop(i_method_name);
1284: end if;
1285: raise ecx_utils.program_exit;
1286: when others then
1287: --dbms_lob.freetemporary(i_xmldoc);
1286: when others then
1287: --dbms_lob.freetemporary(i_xmldoc);
1288: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)
1289: then
1290: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1291: else
1292: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1293: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1294: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1290: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1291: else
1292: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1293: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1294: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1295: end if;
1296: --ecx_utils.error_type := 30;
1297: if(l_unexpectedEnabled) then
1298: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,
1294: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1295: end if;
1296: --ecx_utils.error_type := 30;
1297: if(l_unexpectedEnabled) then
1298: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,
1299: ecx_utils.i_errparams),i_method_name); -- MLS
1300: end if;
1301: raise ecx_utils.program_exit;
1302: end put_on_outbound;
1341: l_retmsg Varchar2(200) := null;
1342:
1343: begin
1344: if (l_procedureEnabled) then
1345: ecx_debug.push(i_method_name);
1346: end if;
1347: if(l_statementEnabled) then
1348: ecx_debug.log(l_statement,'i_document_number',i_document_number,i_method_name);
1349: ecx_debug.log(l_statement,'i_tp_detail_id',i_tp_detail_id,i_method_name);
1344: if (l_procedureEnabled) then
1345: ecx_debug.push(i_method_name);
1346: end if;
1347: if(l_statementEnabled) then
1348: ecx_debug.log(l_statement,'i_document_number',i_document_number,i_method_name);
1349: ecx_debug.log(l_statement,'i_tp_detail_id',i_tp_detail_id,i_method_name);
1350: end if;
1351:
1352: begin
1345: ecx_debug.push(i_method_name);
1346: end if;
1347: if(l_statementEnabled) then
1348: ecx_debug.log(l_statement,'i_document_number',i_document_number,i_method_name);
1349: ecx_debug.log(l_statement,'i_tp_detail_id',i_tp_detail_id,i_method_name);
1350: end if;
1351:
1352: begin
1353: select es.standard_type standard_type,
1380: and eep.ext_process_id = etd.ext_process_id;
1381:
1382: exception
1383: when others then
1384: ecx_debug.setErrorInfo(1,25,'ECX_NO_UNIQUE_TP_SETUP');
1385: raise ecx_utils.program_exit;
1386: end;
1387:
1388: if i_hub_user_id is not null
1404: and ehu.hub_user_id = i_hub_user_id;
1405:
1406: exception
1407: when others then
1408: ecx_debug.setErrorInfo(1,25,'ECX_DELIVERY_HUB_NOT_SETUP');
1409: if(l_unexpectedEnabled) then
1410: ecx_debug.log(l_unexpected,'ERROR', SQLERRM,i_method_name);
1411: end if;
1412: raise ecx_utils.program_exit;
1406: exception
1407: when others then
1408: ecx_debug.setErrorInfo(1,25,'ECX_DELIVERY_HUB_NOT_SETUP');
1409: if(l_unexpectedEnabled) then
1410: ecx_debug.log(l_unexpected,'ERROR', SQLERRM,i_method_name);
1411: end if;
1412: raise ecx_utils.program_exit;
1413: end;
1414: end if;
1415:
1416:
1417: if i_destination_address is null
1418: then
1419: ecx_debug.setErrorInfo(1,25,'ECX_PROTOCOL_ADDR_NULL',
1420: 'p_tp_location_code', i_source_code,
1421: 'p_transaction_type', i_ext_type,
1422: 'p_transaction_subtype', i_ext_subtype,
1423: 'p_standard', i_standard_code);
1437: then
1438: --ecx_utils.i_ret_code := o_retcode;
1439: --ecx_utils.i_errbuf := o_retmsg;
1440: --ecx_utils.error_type := 30;
1441: ecx_debug.setErrorInfo(o_retcode,30,o_retmsg);
1442: raise ecx_utils.program_exit;
1443: end if;
1444: if(l_statementEnabled) then
1445: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1441: ecx_debug.setErrorInfo(o_retcode,30,o_retmsg);
1442: raise ecx_utils.program_exit;
1443: end if;
1444: if(l_statementEnabled) then
1445: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1446: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1447: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1448: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1449: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1442: raise ecx_utils.program_exit;
1443: end if;
1444: if(l_statementEnabled) then
1445: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1446: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1447: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1448: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1449: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1450: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
1443: end if;
1444: if(l_statementEnabled) then
1445: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1446: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1447: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1448: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1449: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1450: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
1451: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
1444: if(l_statementEnabled) then
1445: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1446: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1447: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1448: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1449: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1450: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
1451: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
1452: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
1445: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1446: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1447: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1448: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1449: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1450: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
1451: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
1452: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
1453: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
1446: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1447: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1448: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1449: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1450: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
1451: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
1452: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
1453: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
1454: end if;
1447: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1448: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1449: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1450: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
1451: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
1452: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
1453: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
1454: end if;
1455: --ecx_debug.log(3,'i_password',i_password);
1448: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1449: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1450: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
1451: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
1452: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
1453: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
1454: end if;
1455: --ecx_debug.log(3,'i_password',i_password);
1456:
1449: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1450: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
1451: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
1452: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
1453: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
1454: end if;
1455: --ecx_debug.log(3,'i_password',i_password);
1456:
1457: v_message:=system.ecxmsg
1451: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
1452: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
1453: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
1454: end if;
1455: --ecx_debug.log(3,'i_password',i_password);
1456:
1457: v_message:=system.ecxmsg
1458: (
1459: i_standard_type,
1484: where eth.tp_header_id = etd.tp_header_id
1485: and etd.tp_detail_id = i_tp_detail_id;
1486: exception
1487: when others then
1488: ecx_debug.setErrorInfo(1,30, SQLERRM);
1489: raise ecx_utils.program_exit;
1490: end;
1491:
1492: v_message.party_type := i_party_type;
1532: );
1533:
1534: if (l_retcode = 1) then
1535: if(l_unexpectedEnabled) then
1536: ecx_debug.log(l_unexpected, l_retmsg,i_method_name);
1537: end if;
1538: elsif (l_retcode >= 2 ) then
1539: if(l_unexpectedEnabled) then
1540: ecx_debug.log(l_unexpected, l_retmsg,i_method_name);
1536: ecx_debug.log(l_unexpected, l_retmsg,i_method_name);
1537: end if;
1538: elsif (l_retcode >= 2 ) then
1539: if(l_unexpectedEnabled) then
1540: ecx_debug.log(l_unexpected, l_retmsg,i_method_name);
1541: end if;
1542: raise ecx_utils.program_exit;
1543: end if;
1544: end;
1546: -- maintain attachment mappings if this is a passthrough case
1547: ecx_attachment.remap_attachments(i_msgid);
1548:
1549: if(l_statementEnabled) then
1550: ecx_debug.log(l_statement,'Routed MsgId',i_msgid,i_method_name);
1551: end if;
1552: if (l_procedureEnabled) then
1553: ecx_debug.pop(i_method_name);
1554: end if;
1549: if(l_statementEnabled) then
1550: ecx_debug.log(l_statement,'Routed MsgId',i_msgid,i_method_name);
1551: end if;
1552: if (l_procedureEnabled) then
1553: ecx_debug.pop(i_method_name);
1554: end if;
1555: exception
1556: WHEN ECX_UTILS.PROGRAM_EXIT THEN
1557: i_hub_user_id := null;
1555: exception
1556: WHEN ECX_UTILS.PROGRAM_EXIT THEN
1557: i_hub_user_id := null;
1558: if (l_procedureEnabled) then
1559: ecx_debug.pop(i_method_name);
1560: end if;
1561: raise ecx_utils.program_exit;
1562: when others then
1563: i_hub_user_id := null;
1560: end if;
1561: raise ecx_utils.program_exit;
1562: when others then
1563: i_hub_user_id := null;
1564: ecx_debug.setErrorInfo(2,30, SQLERRM|| ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1565: if(l_unexpectedEnabled) then
1566: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1567: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1568: end if;
1562: when others then
1563: i_hub_user_id := null;
1564: ecx_debug.setErrorInfo(2,30, SQLERRM|| ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1565: if(l_unexpectedEnabled) then
1566: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1567: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1568: end if;
1569: raise ecx_utils.program_exit;
1570: end put_on_outbound;
1563: i_hub_user_id := null;
1564: ecx_debug.setErrorInfo(2,30, SQLERRM|| ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1565: if(l_unexpectedEnabled) then
1566: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1567: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1568: end if;
1569: raise ecx_utils.program_exit;
1570: end put_on_outbound;
1571:
1590:
1591: begin
1592: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
1593: fnd_profile.get('AFLOG_MODULE',module);
1594: if ecx_debug.g_v_module_name is null then
1595: ecx_debug.module_enabled;
1596: end if;
1597:
1598: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
1591: begin
1592: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
1593: fnd_profile.get('AFLOG_MODULE',module);
1594: if ecx_debug.g_v_module_name is null then
1595: ecx_debug.module_enabled;
1596: end if;
1597:
1598: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
1599: AND instr(lower(ecx_debug.g_v_module_name),rtrim(lower(module),'%'))> 0)
1595: ecx_debug.module_enabled;
1596: end if;
1597:
1598: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
1599: AND instr(lower(ecx_debug.g_v_module_name),rtrim(lower(module),'%'))> 0)
1600: OR module='%')
1601: AND FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) then
1602: ecx_logging_enabled := true;
1603: end if;
1604: -- /logging enabled
1605:
1606: IF (ecx_logging_enabled ) THEN
1607: ecx_utils.getLogDirectory;
1608: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir, 'IN'||i_queue_name||'.log', 'in.'||i_queue_name||'.log');
1609: END IF;
1610:
1611: /* Assign local variables with the ecx_debug global variables*/
1612: l_procedure := ecx_debug.g_procedure;
1607: ecx_utils.getLogDirectory;
1608: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir, 'IN'||i_queue_name||'.log', 'in.'||i_queue_name||'.log');
1609: END IF;
1610:
1611: /* Assign local variables with the ecx_debug global variables*/
1612: l_procedure := ecx_debug.g_procedure;
1613: l_statement := ecx_debug.g_statement;
1614: l_unexpected := ecx_debug.g_unexpected;
1615: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1608: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir, 'IN'||i_queue_name||'.log', 'in.'||i_queue_name||'.log');
1609: END IF;
1610:
1611: /* Assign local variables with the ecx_debug global variables*/
1612: l_procedure := ecx_debug.g_procedure;
1613: l_statement := ecx_debug.g_statement;
1614: l_unexpected := ecx_debug.g_unexpected;
1615: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1616: l_statementEnabled := ecx_debug.g_statementEnabled;
1609: END IF;
1610:
1611: /* Assign local variables with the ecx_debug global variables*/
1612: l_procedure := ecx_debug.g_procedure;
1613: l_statement := ecx_debug.g_statement;
1614: l_unexpected := ecx_debug.g_unexpected;
1615: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1616: l_statementEnabled := ecx_debug.g_statementEnabled;
1617: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1610:
1611: /* Assign local variables with the ecx_debug global variables*/
1612: l_procedure := ecx_debug.g_procedure;
1613: l_statement := ecx_debug.g_statement;
1614: l_unexpected := ecx_debug.g_unexpected;
1615: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1616: l_statementEnabled := ecx_debug.g_statementEnabled;
1617: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1618:
1611: /* Assign local variables with the ecx_debug global variables*/
1612: l_procedure := ecx_debug.g_procedure;
1613: l_statement := ecx_debug.g_statement;
1614: l_unexpected := ecx_debug.g_unexpected;
1615: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1616: l_statementEnabled := ecx_debug.g_statementEnabled;
1617: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1618:
1619: if (l_procedureEnabled) then
1612: l_procedure := ecx_debug.g_procedure;
1613: l_statement := ecx_debug.g_statement;
1614: l_unexpected := ecx_debug.g_unexpected;
1615: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1616: l_statementEnabled := ecx_debug.g_statementEnabled;
1617: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1618:
1619: if (l_procedureEnabled) then
1620: ecx_debug.push(i_method_name);
1613: l_statement := ecx_debug.g_statement;
1614: l_unexpected := ecx_debug.g_unexpected;
1615: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1616: l_statementEnabled := ecx_debug.g_statementEnabled;
1617: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1618:
1619: if (l_procedureEnabled) then
1620: ecx_debug.push(i_method_name);
1621: end if;
1616: l_statementEnabled := ecx_debug.g_statementEnabled;
1617: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1618:
1619: if (l_procedureEnabled) then
1620: ecx_debug.push(i_method_name);
1621: end if;
1622:
1623: if(l_statementEnabled) then
1624: ecx_debug.log(l_statement,'i_queue_name',i_queue_name,i_method_name);
1620: ecx_debug.push(i_method_name);
1621: end if;
1622:
1623: if(l_statementEnabled) then
1624: ecx_debug.log(l_statement,'i_queue_name',i_queue_name,i_method_name);
1625: ecx_debug.log(l_statement,'i_debug_level',i_debug_level,i_method_name);
1626: end if;
1627:
1628: getmsg_from_queue(i_queue_name,v_msgid);
1621: end if;
1622:
1623: if(l_statementEnabled) then
1624: ecx_debug.log(l_statement,'i_queue_name',i_queue_name,i_method_name);
1625: ecx_debug.log(l_statement,'i_debug_level',i_debug_level,i_method_name);
1626: end if;
1627:
1628: getmsg_from_queue(i_queue_name,v_msgid);
1629:
1629:
1630: --validate_message( v_msgid, i_debug_level,i_trigger_id);
1631:
1632: if (l_procedureEnabled) then
1633: ecx_debug.pop(i_method_name);
1634: end if;
1635: IF (ecx_logging_enabled ) THEN
1636: ecx_debug.print_log;
1637: ecx_debug.disable_debug;
1632: if (l_procedureEnabled) then
1633: ecx_debug.pop(i_method_name);
1634: end if;
1635: IF (ecx_logging_enabled ) THEN
1636: ecx_debug.print_log;
1637: ecx_debug.disable_debug;
1638: END IF;
1639:
1640: exception
1633: ecx_debug.pop(i_method_name);
1634: end if;
1635: IF (ecx_logging_enabled ) THEN
1636: ecx_debug.print_log;
1637: ecx_debug.disable_debug;
1638: END IF;
1639:
1640: exception
1641: when ecx_utils.program_exit then
1639:
1640: exception
1641: when ecx_utils.program_exit then
1642: if(l_unexpectedEnabled) then
1643: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1644: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1645: end if;
1646: IF (ecx_logging_enabled ) THEN
1647: ecx_debug.print_log;
1640: exception
1641: when ecx_utils.program_exit then
1642: if(l_unexpectedEnabled) then
1643: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1644: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1645: end if;
1646: IF (ecx_logging_enabled ) THEN
1647: ecx_debug.print_log;
1648: ecx_debug.disable_debug;
1643: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1644: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1645: end if;
1646: IF (ecx_logging_enabled ) THEN
1647: ecx_debug.print_log;
1648: ecx_debug.disable_debug;
1649: END IF;
1650: when others then
1651: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_QUEUE';
1644: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1645: end if;
1646: IF (ecx_logging_enabled ) THEN
1647: ecx_debug.print_log;
1648: ecx_debug.disable_debug;
1649: END IF;
1650: when others then
1651: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_QUEUE';
1652: if(l_unexpectedEnabled) then
1649: END IF;
1650: when others then
1651: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_QUEUE';
1652: if(l_unexpectedEnabled) then
1653: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1654: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1655: end if;
1656: IF (ecx_logging_enabled ) THEN
1657: ecx_debug.print_log;
1650: when others then
1651: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_QUEUE';
1652: if(l_unexpectedEnabled) then
1653: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1654: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1655: end if;
1656: IF (ecx_logging_enabled ) THEN
1657: ecx_debug.print_log;
1658: ecx_debug.disable_debug;
1653: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1654: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1655: end if;
1656: IF (ecx_logging_enabled ) THEN
1657: ecx_debug.print_log;
1658: ecx_debug.disable_debug;
1659: END IF;
1660: end processmsg_from_queue;
1661:
1654: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1655: end if;
1656: IF (ecx_logging_enabled ) THEN
1657: ecx_debug.print_log;
1658: ecx_debug.disable_debug;
1659: END IF;
1660: end processmsg_from_queue;
1661:
1662:
1679: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
1680: fnd_profile.get('AFLOG_MODULE',module);
1681:
1682: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
1683: AND instr(lower(ecx_debug.g_v_module_name),rtrim(lower(module),'%'))> 0)
1684: OR module='%')
1685: AND FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) then
1686: ecx_logging_enabled := true;
1687: end if;
1689:
1690: IF (ecx_logging_enabled ) THEN
1691: --get the Log directory from the Profile Option.
1692: ecx_utils.getLogDirectory;
1693: ecx_debug.enable_debug_new(i_debug_level, ecx_utils.g_logdir, 'IN' ||i_msgid||'.log', 'in.'||i_msgid||'.log');
1694: END IF;
1695:
1696: /* Assign local variables with the ecx_debug global variables*/
1697: l_procedure := ecx_debug.g_procedure;
1692: ecx_utils.getLogDirectory;
1693: ecx_debug.enable_debug_new(i_debug_level, ecx_utils.g_logdir, 'IN' ||i_msgid||'.log', 'in.'||i_msgid||'.log');
1694: END IF;
1695:
1696: /* Assign local variables with the ecx_debug global variables*/
1697: l_procedure := ecx_debug.g_procedure;
1698: l_statement := ecx_debug.g_statement;
1699: l_unexpected := ecx_debug.g_unexpected;
1700: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1693: ecx_debug.enable_debug_new(i_debug_level, ecx_utils.g_logdir, 'IN' ||i_msgid||'.log', 'in.'||i_msgid||'.log');
1694: END IF;
1695:
1696: /* Assign local variables with the ecx_debug global variables*/
1697: l_procedure := ecx_debug.g_procedure;
1698: l_statement := ecx_debug.g_statement;
1699: l_unexpected := ecx_debug.g_unexpected;
1700: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1701: l_statementEnabled := ecx_debug.g_statementEnabled;
1694: END IF;
1695:
1696: /* Assign local variables with the ecx_debug global variables*/
1697: l_procedure := ecx_debug.g_procedure;
1698: l_statement := ecx_debug.g_statement;
1699: l_unexpected := ecx_debug.g_unexpected;
1700: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1701: l_statementEnabled := ecx_debug.g_statementEnabled;
1702: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1695:
1696: /* Assign local variables with the ecx_debug global variables*/
1697: l_procedure := ecx_debug.g_procedure;
1698: l_statement := ecx_debug.g_statement;
1699: l_unexpected := ecx_debug.g_unexpected;
1700: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1701: l_statementEnabled := ecx_debug.g_statementEnabled;
1702: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1703:
1696: /* Assign local variables with the ecx_debug global variables*/
1697: l_procedure := ecx_debug.g_procedure;
1698: l_statement := ecx_debug.g_statement;
1699: l_unexpected := ecx_debug.g_unexpected;
1700: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1701: l_statementEnabled := ecx_debug.g_statementEnabled;
1702: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1703:
1704: if (l_procedureEnabled) then
1697: l_procedure := ecx_debug.g_procedure;
1698: l_statement := ecx_debug.g_statement;
1699: l_unexpected := ecx_debug.g_unexpected;
1700: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1701: l_statementEnabled := ecx_debug.g_statementEnabled;
1702: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1703:
1704: if (l_procedureEnabled) then
1705: ecx_debug.push(i_method_name);
1698: l_statement := ecx_debug.g_statement;
1699: l_unexpected := ecx_debug.g_unexpected;
1700: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1701: l_statementEnabled := ecx_debug.g_statementEnabled;
1702: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1703:
1704: if (l_procedureEnabled) then
1705: ecx_debug.push(i_method_name);
1706: end if;
1701: l_statementEnabled := ecx_debug.g_statementEnabled;
1702: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1703:
1704: if (l_procedureEnabled) then
1705: ecx_debug.push(i_method_name);
1706: end if;
1707:
1708: if(l_statementEnabled) then
1709: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
1705: ecx_debug.push(i_method_name);
1706: end if;
1707:
1708: if(l_statementEnabled) then
1709: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
1710: ecx_debug.log(l_statement,'i_debug_level',i_debug_level,i_method_name);
1711: end if;
1712:
1713: --validate_message( i_msgid, i_debug_level,i_trigger_id);
1706: end if;
1707:
1708: if(l_statementEnabled) then
1709: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
1710: ecx_debug.log(l_statement,'i_debug_level',i_debug_level,i_method_name);
1711: end if;
1712:
1713: --validate_message( i_msgid, i_debug_level,i_trigger_id);
1714:
1712:
1713: --validate_message( i_msgid, i_debug_level,i_trigger_id);
1714:
1715: if (l_procedureEnabled) then
1716: ecx_debug.pop(i_method_name);
1717: end if;
1718:
1719: IF (ecx_logging_enabled ) THEN
1720: ecx_debug.print_log;
1716: ecx_debug.pop(i_method_name);
1717: end if;
1718:
1719: IF (ecx_logging_enabled ) THEN
1720: ecx_debug.print_log;
1721: ecx_debug.disable_debug;
1722: END IF;
1723:
1724: exception
1717: end if;
1718:
1719: IF (ecx_logging_enabled ) THEN
1720: ecx_debug.print_log;
1721: ecx_debug.disable_debug;
1722: END IF;
1723:
1724: exception
1725: when ecx_utils.program_exit then
1723:
1724: exception
1725: when ecx_utils.program_exit then
1726: if(l_unexpectedEnabled) then
1727: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1728: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1729: end if;
1730: IF (ecx_logging_enabled ) THEN
1731: ecx_debug.print_log;
1724: exception
1725: when ecx_utils.program_exit then
1726: if(l_unexpectedEnabled) then
1727: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1728: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1729: end if;
1730: IF (ecx_logging_enabled ) THEN
1731: ecx_debug.print_log;
1732: ecx_debug.disable_debug;
1727: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1728: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1729: end if;
1730: IF (ecx_logging_enabled ) THEN
1731: ecx_debug.print_log;
1732: ecx_debug.disable_debug;
1733: END IF;
1734:
1735: when others then
1728: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1729: end if;
1730: IF (ecx_logging_enabled ) THEN
1731: ecx_debug.print_log;
1732: ecx_debug.disable_debug;
1733: END IF;
1734:
1735: when others then
1736: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_TABLE';
1734:
1735: when others then
1736: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_TABLE';
1737: if(l_unexpectedEnabled) then
1738: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1739: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1740: end if;
1741:
1742: IF (ecx_logging_enabled ) THEN
1735: when others then
1736: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_TABLE';
1737: if(l_unexpectedEnabled) then
1738: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1739: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1740: end if;
1741:
1742: IF (ecx_logging_enabled ) THEN
1743: ecx_debug.print_log;
1739: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1740: end if;
1741:
1742: IF (ecx_logging_enabled ) THEN
1743: ecx_debug.print_log;
1744: ecx_debug.disable_debug;
1745: END IF;
1746: end processmsg_from_table;
1747:
1740: end if;
1741:
1742: IF (ecx_logging_enabled ) THEN
1743: ecx_debug.print_log;
1744: ecx_debug.disable_debug;
1745: END IF;
1746: end processmsg_from_table;
1747:
1748: /** New wrap validate message for use with BES
1821:
1822: close get_msg;
1823: ecx_utils.g_direction := 'IN';
1824: ecx_utils.g_logfile :=null;
1825: ecx_debug.g_v_module_name :='ecx.plsql.';
1826: ecx_utils.g_transaction_type := m_transaction_type;
1827: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1828: ecx_utils.g_msgid := i_msgid;
1829: begin
1832: from ecx_standards
1833: where standard_code = m_message_standard
1834: and standard_type = nvl(m_message_type, 'XML');
1835: if(l_statementEnabled) then
1836: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1837: end if;
1838: exception
1839: when others then
1840: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
1836: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1837: end if;
1838: exception
1839: when others then
1840: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
1841: raise ecx_utils.program_exit;
1842: end;
1843: ecx_debug.module_enabled;
1844: g_instlmode := wf_core.translate('WF_INSTALL');
1839: when others then
1840: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
1841: raise ecx_utils.program_exit;
1842: end;
1843: ecx_debug.module_enabled;
1844: g_instlmode := wf_core.translate('WF_INSTALL');
1845:
1846: if(g_instlmode = 'EMBEDDED')
1847: THEN
1847: THEN
1848: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
1849: fnd_profile.get('AFLOG_MODULE',module);
1850: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
1851: AND instr(lower(ecx_debug.g_v_module_name),rtrim(lower(module),'%'))> 0)
1852: OR module='%')
1853: AND FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) then
1854: ecx_logging_enabled := true;
1855: end if;
1888: p_aflog_module_name := p_aflog_module_name||ecx_utils.g_run_id;
1889: END IF;
1890: p_aflog_module_name := p_aflog_module_name||'.log';
1891:
1892: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,i_logfile, p_aflog_module_name);
1893: END IF;
1894:
1895: /* Assign local variables with the ecx_debug global variables*/
1896: l_procedure := ecx_debug.g_procedure;
1891:
1892: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,i_logfile, p_aflog_module_name);
1893: END IF;
1894:
1895: /* Assign local variables with the ecx_debug global variables*/
1896: l_procedure := ecx_debug.g_procedure;
1897: l_statement := ecx_debug.g_statement;
1898: l_unexpected := ecx_debug.g_unexpected;
1899: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1892: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,i_logfile, p_aflog_module_name);
1893: END IF;
1894:
1895: /* Assign local variables with the ecx_debug global variables*/
1896: l_procedure := ecx_debug.g_procedure;
1897: l_statement := ecx_debug.g_statement;
1898: l_unexpected := ecx_debug.g_unexpected;
1899: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1900: l_statementEnabled := ecx_debug.g_statementEnabled;
1893: END IF;
1894:
1895: /* Assign local variables with the ecx_debug global variables*/
1896: l_procedure := ecx_debug.g_procedure;
1897: l_statement := ecx_debug.g_statement;
1898: l_unexpected := ecx_debug.g_unexpected;
1899: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1900: l_statementEnabled := ecx_debug.g_statementEnabled;
1901: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1894:
1895: /* Assign local variables with the ecx_debug global variables*/
1896: l_procedure := ecx_debug.g_procedure;
1897: l_statement := ecx_debug.g_statement;
1898: l_unexpected := ecx_debug.g_unexpected;
1899: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1900: l_statementEnabled := ecx_debug.g_statementEnabled;
1901: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1902:
1895: /* Assign local variables with the ecx_debug global variables*/
1896: l_procedure := ecx_debug.g_procedure;
1897: l_statement := ecx_debug.g_statement;
1898: l_unexpected := ecx_debug.g_unexpected;
1899: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1900: l_statementEnabled := ecx_debug.g_statementEnabled;
1901: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1902:
1903: if (l_procedureEnabled) then
1896: l_procedure := ecx_debug.g_procedure;
1897: l_statement := ecx_debug.g_statement;
1898: l_unexpected := ecx_debug.g_unexpected;
1899: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1900: l_statementEnabled := ecx_debug.g_statementEnabled;
1901: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1902:
1903: if (l_procedureEnabled) then
1904: ecx_debug.push(i_method_name);
1897: l_statement := ecx_debug.g_statement;
1898: l_unexpected := ecx_debug.g_unexpected;
1899: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1900: l_statementEnabled := ecx_debug.g_statementEnabled;
1901: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1902:
1903: if (l_procedureEnabled) then
1904: ecx_debug.push(i_method_name);
1905: end if;
1900: l_statementEnabled := ecx_debug.g_statementEnabled;
1901: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1902:
1903: if (l_procedureEnabled) then
1904: ecx_debug.push(i_method_name);
1905: end if;
1906:
1907: if(l_statementEnabled) then
1908: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
1904: ecx_debug.push(i_method_name);
1905: end if;
1906:
1907: if(l_statementEnabled) then
1908: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
1909: ecx_debug.log(l_statement,'i_debug_level',i_debug_level,i_method_name);
1910: end if;
1911: ecx_utils.g_document_id :=m_internal_control_number;
1912:
1905: end if;
1906:
1907: if(l_statementEnabled) then
1908: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
1909: ecx_debug.log(l_statement,'i_debug_level',i_debug_level,i_method_name);
1910: end if;
1911: ecx_utils.g_document_id :=m_internal_control_number;
1912:
1913: IF (ecx_logging_enabled and g_instlmode = 'STANDALONE') THEN
1926: from ecx_standards
1927: where standard_code = m_message_standard
1928: and standard_type = nvl(m_message_type, 'XML');
1929: if(l_statementEnabled) then
1930: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1931: end if;
1932: exception
1933: when others then
1934: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
1930: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1931: end if;
1932: exception
1933: when others then
1934: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
1935: raise ecx_utils.program_exit;
1936: enid;*/
1937: validate_message
1938: (
1947: m_message_type
1948: );
1949:
1950: if (l_procedureEnabled) then
1951: ecx_debug.pop(i_method_name);
1952: end if;
1953: IF (ecx_logging_enabled ) THEN
1954: ecx_debug.print_log;
1955: ecx_debug.disable_debug;
1950: if (l_procedureEnabled) then
1951: ecx_debug.pop(i_method_name);
1952: end if;
1953: IF (ecx_logging_enabled ) THEN
1954: ecx_debug.print_log;
1955: ecx_debug.disable_debug;
1956: END IF;
1957:
1958: exception
1951: ecx_debug.pop(i_method_name);
1952: end if;
1953: IF (ecx_logging_enabled ) THEN
1954: ecx_debug.print_log;
1955: ecx_debug.disable_debug;
1956: END IF;
1957:
1958: exception
1959: when ecx_utils.program_exit then
1958: exception
1959: when ecx_utils.program_exit then
1960: --ecx_utils.g_map_id := -1;
1961: if(l_unexpectedEnabled) then
1962: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1963: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1964: end if;
1965: if (l_procedureEnabled) then
1966: ecx_debug.pop(i_method_name);
1959: when ecx_utils.program_exit then
1960: --ecx_utils.g_map_id := -1;
1961: if(l_unexpectedEnabled) then
1962: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1963: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1964: end if;
1965: if (l_procedureEnabled) then
1966: ecx_debug.pop(i_method_name);
1967: end if;
1962: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1963: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1964: end if;
1965: if (l_procedureEnabled) then
1966: ecx_debug.pop(i_method_name);
1967: end if;
1968:
1969: IF (ecx_logging_enabled ) THEN
1970: ecx_debug.print_log;
1966: ecx_debug.pop(i_method_name);
1967: end if;
1968:
1969: IF (ecx_logging_enabled ) THEN
1970: ecx_debug.print_log;
1971: ecx_debug.disable_debug;
1972: END IF;
1973:
1974: raise;
1967: end if;
1968:
1969: IF (ecx_logging_enabled ) THEN
1970: ecx_debug.print_log;
1971: ecx_debug.disable_debug;
1972: END IF;
1973:
1974: raise;
1975: when msg_not_found then
1973:
1974: raise;
1975: when msg_not_found then
1976: --ecx_utils.g_map_id := -1;
1977: ecx_debug.setErrorInfo(1,30,'ECX_MSGID_NOT_FOUND',
1978: 'p_msgid',
1979: i_msgid);
1980: close get_msg;
1981: raise;
1980: close get_msg;
1981: raise;
1982: when others then
1983: --ecx_utils.g_map_id := -1;
1984: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
1985: if(l_unexpectedEnabled) then
1986: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1987: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1988: end if;
1982: when others then
1983: --ecx_utils.g_map_id := -1;
1984: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
1985: if(l_unexpectedEnabled) then
1986: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1987: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1988: end if;
1989: if (l_procedureEnabled) then
1990: ecx_debug.pop(i_method_name);
1983: --ecx_utils.g_map_id := -1;
1984: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
1985: if(l_unexpectedEnabled) then
1986: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1987: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1988: end if;
1989: if (l_procedureEnabled) then
1990: ecx_debug.pop(i_method_name);
1991: end if;
1986: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1987: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1988: end if;
1989: if (l_procedureEnabled) then
1990: ecx_debug.pop(i_method_name);
1991: end if;
1992:
1993: IF (ecx_logging_enabled ) THEN
1994: ecx_debug.print_log;
1990: ecx_debug.pop(i_method_name);
1991: end if;
1992:
1993: IF (ecx_logging_enabled ) THEN
1994: ecx_debug.print_log;
1995: ecx_debug.disable_debug;
1996: END IF;
1997:
1998: raise;
1991: end if;
1992:
1993: IF (ecx_logging_enabled ) THEN
1994: ecx_debug.print_log;
1995: ecx_debug.disable_debug;
1996: END IF;
1997:
1998: raise;
1999: end wrap_validate_message;
2056: module varchar2(2000);
2057:
2058: begin
2059: ecx_utils.g_logfile :=null;
2060: ecx_debug.g_v_module_name :='ecx.plsql.';
2061: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
2062: fnd_profile.get('AFLOG_MODULE',module);
2063: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
2064: AND instr(lower(ecx_debug.g_v_module_name),rtrim(lower(module),'%'))> 0)
2060: ecx_debug.g_v_module_name :='ecx.plsql.';
2061: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
2062: fnd_profile.get('AFLOG_MODULE',module);
2063: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
2064: AND instr(lower(ecx_debug.g_v_module_name),rtrim(lower(module),'%'))> 0)
2065: OR module='%')
2066: AND FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) then
2067: ecx_logging_enabled := true;
2068: end if;
2117: p_aflog_module_name := p_aflog_module_name||ecx_utils.g_run_id;
2118: END IF;
2119: p_aflog_module_name := p_aflog_module_name||'.log';
2120:
2121: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,i_logfile, p_aflog_module_name);
2122: END IF;
2123:
2124: /* Assign local variables with the ecx_debug global variables*/
2125: l_procedure := ecx_debug.g_procedure;
2120:
2121: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,i_logfile, p_aflog_module_name);
2122: END IF;
2123:
2124: /* Assign local variables with the ecx_debug global variables*/
2125: l_procedure := ecx_debug.g_procedure;
2126: l_statement := ecx_debug.g_statement;
2127: l_unexpected := ecx_debug.g_unexpected;
2128: l_procedureEnabled := ecx_debug.g_procedureEnabled;
2121: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,i_logfile, p_aflog_module_name);
2122: END IF;
2123:
2124: /* Assign local variables with the ecx_debug global variables*/
2125: l_procedure := ecx_debug.g_procedure;
2126: l_statement := ecx_debug.g_statement;
2127: l_unexpected := ecx_debug.g_unexpected;
2128: l_procedureEnabled := ecx_debug.g_procedureEnabled;
2129: l_statementEnabled := ecx_debug.g_statementEnabled;
2122: END IF;
2123:
2124: /* Assign local variables with the ecx_debug global variables*/
2125: l_procedure := ecx_debug.g_procedure;
2126: l_statement := ecx_debug.g_statement;
2127: l_unexpected := ecx_debug.g_unexpected;
2128: l_procedureEnabled := ecx_debug.g_procedureEnabled;
2129: l_statementEnabled := ecx_debug.g_statementEnabled;
2130: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
2123:
2124: /* Assign local variables with the ecx_debug global variables*/
2125: l_procedure := ecx_debug.g_procedure;
2126: l_statement := ecx_debug.g_statement;
2127: l_unexpected := ecx_debug.g_unexpected;
2128: l_procedureEnabled := ecx_debug.g_procedureEnabled;
2129: l_statementEnabled := ecx_debug.g_statementEnabled;
2130: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
2131:
2124: /* Assign local variables with the ecx_debug global variables*/
2125: l_procedure := ecx_debug.g_procedure;
2126: l_statement := ecx_debug.g_statement;
2127: l_unexpected := ecx_debug.g_unexpected;
2128: l_procedureEnabled := ecx_debug.g_procedureEnabled;
2129: l_statementEnabled := ecx_debug.g_statementEnabled;
2130: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
2131:
2132: if (l_procedureEnabled) then
2125: l_procedure := ecx_debug.g_procedure;
2126: l_statement := ecx_debug.g_statement;
2127: l_unexpected := ecx_debug.g_unexpected;
2128: l_procedureEnabled := ecx_debug.g_procedureEnabled;
2129: l_statementEnabled := ecx_debug.g_statementEnabled;
2130: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
2131:
2132: if (l_procedureEnabled) then
2133: ecx_debug.push(i_method_name);
2126: l_statement := ecx_debug.g_statement;
2127: l_unexpected := ecx_debug.g_unexpected;
2128: l_procedureEnabled := ecx_debug.g_procedureEnabled;
2129: l_statementEnabled := ecx_debug.g_statementEnabled;
2130: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
2131:
2132: if (l_procedureEnabled) then
2133: ecx_debug.push(i_method_name);
2134: end if;
2129: l_statementEnabled := ecx_debug.g_statementEnabled;
2130: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
2131:
2132: if (l_procedureEnabled) then
2133: ecx_debug.push(i_method_name);
2134: end if;
2135:
2136: if(l_statementEnabled) then
2137: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
2133: ecx_debug.push(i_method_name);
2134: end if;
2135:
2136: if(l_statementEnabled) then
2137: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
2138: ecx_debug.log(l_statement,'i_debug_level',i_debug_level,i_method_name);
2139: end if;
2140: ecx_utils.g_document_id :=m_internal_control_number;
2141:
2134: end if;
2135:
2136: if(l_statementEnabled) then
2137: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
2138: ecx_debug.log(l_statement,'i_debug_level',i_debug_level,i_method_name);
2139: end if;
2140: ecx_utils.g_document_id :=m_internal_control_number;
2141:
2142: IF (ecx_logging_enabled ) THEN
2155: from ecx_standards
2156: where standard_code = m_message_standard
2157: and standard_type = nvl(m_message_type, 'XML');
2158: if(l_statementEnabled) then
2159: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2160: end if;
2161: exception
2162: when others then
2163: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
2159: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2160: end if;
2161: exception
2162: when others then
2163: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
2164: raise ecx_utils.program_exit;
2165: end;
2166:
2167: validate_message
2177: m_message_type
2178: );
2179:
2180: if (l_procedureEnabled) then
2181: ecx_debug.pop(i_method_name);
2182: end if;
2183: IF (ecx_logging_enabled ) THEN
2184: ecx_debug.print_log;
2185: ecx_debug.disable_debug;
2180: if (l_procedureEnabled) then
2181: ecx_debug.pop(i_method_name);
2182: end if;
2183: IF (ecx_logging_enabled ) THEN
2184: ecx_debug.print_log;
2185: ecx_debug.disable_debug;
2186: END IF;
2187:
2188: commit;
2181: ecx_debug.pop(i_method_name);
2182: end if;
2183: IF (ecx_logging_enabled ) THEN
2184: ecx_debug.print_log;
2185: ecx_debug.disable_debug;
2186: END IF;
2187:
2188: commit;
2189: exception
2189: exception
2190: when ecx_utils.program_exit then
2191: --ecx_utils.g_map_id := -1;
2192: if(l_unexpectedEnabled) then
2193: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2194: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2195: end if;
2196: IF (ecx_logging_enabled ) THEN
2197: ecx_debug.print_log;
2190: when ecx_utils.program_exit then
2191: --ecx_utils.g_map_id := -1;
2192: if(l_unexpectedEnabled) then
2193: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2194: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2195: end if;
2196: IF (ecx_logging_enabled ) THEN
2197: ecx_debug.print_log;
2198: ecx_debug.disable_debug;
2193: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2194: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2195: end if;
2196: IF (ecx_logging_enabled ) THEN
2197: ecx_debug.print_log;
2198: ecx_debug.disable_debug;
2199: END IF;
2200: rollback;
2201: when msg_not_found then
2194: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2195: end if;
2196: IF (ecx_logging_enabled ) THEN
2197: ecx_debug.print_log;
2198: ecx_debug.disable_debug;
2199: END IF;
2200: rollback;
2201: when msg_not_found then
2202: --ecx_utils.g_map_id := -1;
2199: END IF;
2200: rollback;
2201: when msg_not_found then
2202: --ecx_utils.g_map_id := -1;
2203: ecx_debug.setErrorInfo(1,30,'ECX_MSGID_NOT_FOUND',
2204: 'p_msgid',
2205: i_msgid);
2206: close get_msg;
2207: rollback;
2206: close get_msg;
2207: rollback;
2208: when others then
2209: --ecx_utils.g_map_id := -1;
2210: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2211: if(l_unexpectedEnabled) then
2212: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2213: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2214: end if;
2208: when others then
2209: --ecx_utils.g_map_id := -1;
2210: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2211: if(l_unexpectedEnabled) then
2212: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2213: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2214: end if;
2215: IF (ecx_logging_enabled ) THEN
2216: ecx_debug.print_log;
2209: --ecx_utils.g_map_id := -1;
2210: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2211: if(l_unexpectedEnabled) then
2212: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2213: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2214: end if;
2215: IF (ecx_logging_enabled ) THEN
2216: ecx_debug.print_log;
2217: ecx_debug.disable_debug;
2212: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2213: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2214: end if;
2215: IF (ecx_logging_enabled ) THEN
2216: ecx_debug.print_log;
2217: ecx_debug.disable_debug;
2218: END IF;
2219:
2220: rollback;
2213: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2214: end if;
2215: IF (ecx_logging_enabled ) THEN
2216: ecx_debug.print_log;
2217: ecx_debug.disable_debug;
2218: END IF;
2219:
2220: rollback;
2221: end wrap_validate_message;
2255: THEN
2256: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
2257: fnd_profile.get('AFLOG_MODULE',module);
2258: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
2259: AND instr(lower(ecx_debug.g_v_module_name),rtrim(lower(module),'%'))> 0)
2260: OR module='%')
2261: AND FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) then
2262: ecx_logging_enabled := true;
2263: end if;
2283: END IF;
2284:
2285: IF g_instlmode = 'EMBEDDED' THEN
2286: IF (ecx_logging_enabled ) THEN
2287: i_log_file := ecx_debug.g_sqlprefix || 'in.'||ecx_utils.g_run_id||'.log';
2288: ELSE
2289: i_log_file := 'Please ensure that FND-Logging is enabled for module '||ecx_debug.g_sqlprefix||'%';
2290: END IF;
2291: ELSE
2285: IF g_instlmode = 'EMBEDDED' THEN
2286: IF (ecx_logging_enabled ) THEN
2287: i_log_file := ecx_debug.g_sqlprefix || 'in.'||ecx_utils.g_run_id||'.log';
2288: ELSE
2289: i_log_file := 'Please ensure that FND-Logging is enabled for module '||ecx_debug.g_sqlprefix||'%';
2290: END IF;
2291: ELSE
2292: IF (ecx_logging_enabled ) THEN
2293: i_log_file := ecx_utils.g_logdir||'/'||i_logfile;
2296: END IF;
2297: END IF;
2298:
2299: IF (ecx_logging_enabled ) THEN
2300: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,i_logfile, 'in.'||ecx_utils.g_run_id||'.log');
2301: END IF;
2302:
2303: /* Assign local variables with the ecx_debug global variables*/
2304: l_procedure := ecx_debug.g_procedure;
2299: IF (ecx_logging_enabled ) THEN
2300: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,i_logfile, 'in.'||ecx_utils.g_run_id||'.log');
2301: END IF;
2302:
2303: /* Assign local variables with the ecx_debug global variables*/
2304: l_procedure := ecx_debug.g_procedure;
2305: l_statement := ecx_debug.g_statement;
2306: l_unexpected := ecx_debug.g_unexpected;
2307: l_procedureEnabled := ecx_debug.g_procedureEnabled;
2300: ecx_debug.enable_debug_new(i_debug_level,ecx_utils.g_logdir,i_logfile, 'in.'||ecx_utils.g_run_id||'.log');
2301: END IF;
2302:
2303: /* Assign local variables with the ecx_debug global variables*/
2304: l_procedure := ecx_debug.g_procedure;
2305: l_statement := ecx_debug.g_statement;
2306: l_unexpected := ecx_debug.g_unexpected;
2307: l_procedureEnabled := ecx_debug.g_procedureEnabled;
2308: l_statementEnabled := ecx_debug.g_statementEnabled;
2301: END IF;
2302:
2303: /* Assign local variables with the ecx_debug global variables*/
2304: l_procedure := ecx_debug.g_procedure;
2305: l_statement := ecx_debug.g_statement;
2306: l_unexpected := ecx_debug.g_unexpected;
2307: l_procedureEnabled := ecx_debug.g_procedureEnabled;
2308: l_statementEnabled := ecx_debug.g_statementEnabled;
2309: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
2302:
2303: /* Assign local variables with the ecx_debug global variables*/
2304: l_procedure := ecx_debug.g_procedure;
2305: l_statement := ecx_debug.g_statement;
2306: l_unexpected := ecx_debug.g_unexpected;
2307: l_procedureEnabled := ecx_debug.g_procedureEnabled;
2308: l_statementEnabled := ecx_debug.g_statementEnabled;
2309: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
2310:
2303: /* Assign local variables with the ecx_debug global variables*/
2304: l_procedure := ecx_debug.g_procedure;
2305: l_statement := ecx_debug.g_statement;
2306: l_unexpected := ecx_debug.g_unexpected;
2307: l_procedureEnabled := ecx_debug.g_procedureEnabled;
2308: l_statementEnabled := ecx_debug.g_statementEnabled;
2309: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
2310:
2311: if (l_procedureEnabled) then
2304: l_procedure := ecx_debug.g_procedure;
2305: l_statement := ecx_debug.g_statement;
2306: l_unexpected := ecx_debug.g_unexpected;
2307: l_procedureEnabled := ecx_debug.g_procedureEnabled;
2308: l_statementEnabled := ecx_debug.g_statementEnabled;
2309: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
2310:
2311: if (l_procedureEnabled) then
2312: ecx_debug.push(i_method_name);
2305: l_statement := ecx_debug.g_statement;
2306: l_unexpected := ecx_debug.g_unexpected;
2307: l_procedureEnabled := ecx_debug.g_procedureEnabled;
2308: l_statementEnabled := ecx_debug.g_statementEnabled;
2309: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
2310:
2311: if (l_procedureEnabled) then
2312: ecx_debug.push(i_method_name);
2313: end if;
2308: l_statementEnabled := ecx_debug.g_statementEnabled;
2309: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
2310:
2311: if (l_procedureEnabled) then
2312: ecx_debug.push(i_method_name);
2313: end if;
2314:
2315: if(l_statementEnabled) then
2316: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
2312: ecx_debug.push(i_method_name);
2313: end if;
2314:
2315: if(l_statementEnabled) then
2316: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
2317: ecx_debug.log(l_statement,'i_debug_level',i_debug_level,i_method_name);
2318: end if;
2319:
2320: IF (ecx_logging_enabled ) THEN
2313: end if;
2314:
2315: if(l_statementEnabled) then
2316: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
2317: ecx_debug.log(l_statement,'i_debug_level',i_debug_level,i_method_name);
2318: end if;
2319:
2320: IF (ecx_logging_enabled ) THEN
2321: ecx_utils.g_logfile :=i_logfile;
2328: from ecx_mappings
2329: where map_code = i_map_code;
2330: exception
2331: when others then
2332: ecx_debug.setErrorInfo(2,30,'ECX_MAP_NOT_FOUND',
2333: 'MAP_CODE',
2334: i_map_code);
2335: raise ecx_utils.program_exit;
2336: end;
2341: from ecx_standards
2342: where standard_code = i_message_standard
2343: and standard_type = nvl(i_message_type, 'XML');
2344: if(l_statementEnabled) then
2345: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2346: end if;
2347: exception
2348: when others then
2349: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
2345: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2346: end if;
2347: exception
2348: when others then
2349: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
2350: raise ecx_utils.program_exit;
2351: end;
2352:
2353: processXMLData
2362: );
2363:
2364: --ecx_utils.i_ret_code :=0;
2365: --ecx_utils.i_errbuf := 'XML Document Successfully processed';
2366: ecx_debug.setErrorInfo(0,10,'ECX_DOCUMENT_PROCESSED');
2367:
2368: if(ecx_utils.i_ret_code = 0 ) then
2369: if(l_statementEnabled) then
2370: ecx_debug.log(l_statement, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
2366: ecx_debug.setErrorInfo(0,10,'ECX_DOCUMENT_PROCESSED');
2367:
2368: if(ecx_utils.i_ret_code = 0 ) then
2369: if(l_statementEnabled) then
2370: ecx_debug.log(l_statement, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
2371: ecx_debug.log(l_statement, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
2372: end if;
2373: else
2374: if(l_unexpectedEnabled) then
2367:
2368: if(ecx_utils.i_ret_code = 0 ) then
2369: if(l_statementEnabled) then
2370: ecx_debug.log(l_statement, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
2371: ecx_debug.log(l_statement, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
2372: end if;
2373: else
2374: if(l_unexpectedEnabled) then
2375: ecx_debug.log(l_unexpected, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
2371: ecx_debug.log(l_statement, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
2372: end if;
2373: else
2374: if(l_unexpectedEnabled) then
2375: ecx_debug.log(l_unexpected, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
2376: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
2377: end if;
2378: end if;
2379:
2372: end if;
2373: else
2374: if(l_unexpectedEnabled) then
2375: ecx_debug.log(l_unexpected, 'Ret Code',ecx_utils.i_ret_code,i_method_name);
2376: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_utils.i_errbuf,i_method_name);
2377: end if;
2378: end if;
2379:
2380: if (l_procedureEnabled) then
2377: end if;
2378: end if;
2379:
2380: if (l_procedureEnabled) then
2381: ecx_debug.pop(i_method_name);
2382: end if;
2383:
2384: IF (ecx_logging_enabled ) THEN
2385: ecx_debug.print_log;
2381: ecx_debug.pop(i_method_name);
2382: end if;
2383:
2384: IF (ecx_logging_enabled ) THEN
2385: ecx_debug.print_log;
2386: ecx_debug.disable_debug;
2387: END IF;
2388:
2389: i_ret_code := ecx_utils.i_ret_code;
2382: end if;
2383:
2384: IF (ecx_logging_enabled ) THEN
2385: ecx_debug.print_log;
2386: ecx_debug.disable_debug;
2387: END IF;
2388:
2389: i_ret_code := ecx_utils.i_ret_code;
2390: i_errbuf := ecx_utils.i_errbuf;
2393: when ecx_utils.program_exit then
2394: --dbms_lob.freetemporary(o_payload);
2395: --ecx_utils.g_map_id := -1;
2396: if(l_unexpectedEnabled) then
2397: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2398: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2399: ecx_utils.i_errparams),i_method_name);
2400: end if;
2401: if (l_procedureEnabled) then
2394: --dbms_lob.freetemporary(o_payload);
2395: --ecx_utils.g_map_id := -1;
2396: if(l_unexpectedEnabled) then
2397: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2398: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2399: ecx_utils.i_errparams),i_method_name);
2400: end if;
2401: if (l_procedureEnabled) then
2402: ecx_debug.pop(i_method_name);
2398: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2399: ecx_utils.i_errparams),i_method_name);
2400: end if;
2401: if (l_procedureEnabled) then
2402: ecx_debug.pop(i_method_name);
2403: end if;
2404: IF (ecx_logging_enabled ) THEN
2405: ecx_debug.print_log;
2406: ecx_debug.disable_debug;
2401: if (l_procedureEnabled) then
2402: ecx_debug.pop(i_method_name);
2403: end if;
2404: IF (ecx_logging_enabled ) THEN
2405: ecx_debug.print_log;
2406: ecx_debug.disable_debug;
2407: END IF;
2408: i_ret_code := ecx_utils.i_ret_code;
2409: i_errbuf := ecx_utils.i_errbuf;
2402: ecx_debug.pop(i_method_name);
2403: end if;
2404: IF (ecx_logging_enabled ) THEN
2405: ecx_debug.print_log;
2406: ecx_debug.disable_debug;
2407: END IF;
2408: i_ret_code := ecx_utils.i_ret_code;
2409: i_errbuf := ecx_utils.i_errbuf;
2410:
2410:
2411: when others then
2412: --dbms_lob.freetemporary(o_payload);
2413: --ecx_utils.g_map_id := -1;
2414: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2415: if(l_unexpectedEnabled) then
2416: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2417: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2418: ecx_utils.i_errparams),i_method_name);
2412: --dbms_lob.freetemporary(o_payload);
2413: --ecx_utils.g_map_id := -1;
2414: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2415: if(l_unexpectedEnabled) then
2416: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2417: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2418: ecx_utils.i_errparams),i_method_name);
2419: end if;
2420: if (l_procedureEnabled) then
2413: --ecx_utils.g_map_id := -1;
2414: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2415: if(l_unexpectedEnabled) then
2416: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2417: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2418: ecx_utils.i_errparams),i_method_name);
2419: end if;
2420: if (l_procedureEnabled) then
2421: ecx_debug.pop(i_method_name);
2417: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2418: ecx_utils.i_errparams),i_method_name);
2419: end if;
2420: if (l_procedureEnabled) then
2421: ecx_debug.pop(i_method_name);
2422: end if;
2423: IF (ecx_logging_enabled ) THEN
2424: ecx_debug.print_log;
2425: ecx_debug.disable_debug;
2420: if (l_procedureEnabled) then
2421: ecx_debug.pop(i_method_name);
2422: end if;
2423: IF (ecx_logging_enabled ) THEN
2424: ecx_debug.print_log;
2425: ecx_debug.disable_debug;
2426: END IF;
2427: i_ret_code := ecx_utils.i_ret_code;
2428: i_errbuf := ecx_utils.i_errbuf;
2421: ecx_debug.pop(i_method_name);
2422: end if;
2423: IF (ecx_logging_enabled ) THEN
2424: ecx_debug.print_log;
2425: ecx_debug.disable_debug;
2426: END IF;
2427: i_ret_code := ecx_utils.i_ret_code;
2428: i_errbuf := ecx_utils.i_errbuf;
2429: end processXML;
2447: begin
2448: /* open c_ecx_trigger_id;
2449: fetch c_ecx_trigger_id into i_trigger_id;
2450: close c_ecx_trigger_id;*/
2451: ecx_debug.setErrorInfo(10,10,'ECX_REPROCESSING_MESSAGE');
2452: /* ecx_errorlog.inbound_trigger
2453: (
2454: i_trigger_id,
2455: i_msgid,
2466: i_msgid,
2467: i_debug_level
2468: );
2469:
2470: ecx_debug.setErrorInfo(0,10,'ECX_MESSAGE_REPROCESSED');
2471: select process_id into i_process_id from ecx_inbound_logs where msgid=i_msgid;
2472: if(i_process_id is null) -- means TP setup wrong. Message never got into transaction queue.
2473: then
2474: return;
2484: ecx_utils.g_logfile := null;
2485: end;
2486:
2487: --Changed for MLS
2488: ecx_debug.setErrorInfo(0,10,'ECX_MESSAGE_REPROCESSED');
2489: i_retcode := ecx_utils.i_ret_code;
2490: i_errbuf := ecx_utils.i_errbuf;
2491: exception
2492: when others then