[Home] [Help]
1: PACKAGE BODY ecx_document AS
2: -- $Header: ECXSENDB.pls 120.10.12020000.4 2013/01/22 09:35:21 dhragarw 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_document AS
2: -- $Header: ECXSENDB.pls 120.10.12020000.4 2013/01/22 09:35:21 dhragarw 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: ECXSENDB.pls 120.10.12020000.4 2013/01/22 09:35:21 dhragarw 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: /**
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: /**
12: Get COnfirmation Document Data
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: /**
12: Get COnfirmation Document Data
13: **/
30: i_transaction_subtype varchar2(200);
31: i_confirmation pls_integer;
32: begin
33: if (l_procedureEnabled) then
34: ecx_debug.push(i_method_name);
35: end if;
36: if(l_statementEnabled) then
37: ecx_debug.log(l_statement,'transaction_type',p_transaction_type,i_method_name);
38: ecx_debug.log(l_statement,'transaction_subtype',p_transaction_subtype,i_method_name);
33: if (l_procedureEnabled) then
34: ecx_debug.push(i_method_name);
35: end if;
36: if(l_statementEnabled) then
37: ecx_debug.log(l_statement,'transaction_type',p_transaction_type,i_method_name);
38: ecx_debug.log(l_statement,'transaction_subtype',p_transaction_subtype,i_method_name);
39: ecx_debug.log(l_statement,'party type', p_party_type,i_method_name);
40: ecx_debug.log(l_statement,'document_id',p_document_id,i_method_name);
41: end if;
34: ecx_debug.push(i_method_name);
35: end if;
36: if(l_statementEnabled) then
37: ecx_debug.log(l_statement,'transaction_type',p_transaction_type,i_method_name);
38: ecx_debug.log(l_statement,'transaction_subtype',p_transaction_subtype,i_method_name);
39: ecx_debug.log(l_statement,'party type', p_party_type,i_method_name);
40: ecx_debug.log(l_statement,'document_id',p_document_id,i_method_name);
41: end if;
42:
35: end if;
36: if(l_statementEnabled) then
37: ecx_debug.log(l_statement,'transaction_type',p_transaction_type,i_method_name);
38: ecx_debug.log(l_statement,'transaction_subtype',p_transaction_subtype,i_method_name);
39: ecx_debug.log(l_statement,'party type', p_party_type,i_method_name);
40: ecx_debug.log(l_statement,'document_id',p_document_id,i_method_name);
41: end if;
42:
43:
36: if(l_statementEnabled) then
37: ecx_debug.log(l_statement,'transaction_type',p_transaction_type,i_method_name);
38: ecx_debug.log(l_statement,'transaction_subtype',p_transaction_subtype,i_method_name);
39: ecx_debug.log(l_statement,'party type', p_party_type,i_method_name);
40: ecx_debug.log(l_statement,'document_id',p_document_id,i_method_name);
41: end if;
42:
43:
44: begin
53: from ecx_doclogs
54: where internal_control_number = p_document_id;
55: exception
56: when no_data_found then
57: ecx_debug.setErrorInfo(2,30,'ECX_CONFIRM_DOC_NOT_FOUND');
58: raise ecx_utils.program_exit;
59: end;
60:
61: if i_transaction_type = 'BOD'
59: end;
60:
61: if i_transaction_type = 'BOD'
62: then
63: ecx_debug.setErrorInfo(2,30,'ECX_CONFIRM_GENERATE_FAILED');
64: raise ecx_utils.program_exit;
65: end if;
66:
67: if(l_statementEnabled) then
64: raise ecx_utils.program_exit;
65: end if;
66:
67: if(l_statementEnabled) then
68: ecx_debug.log(l_statement, 'Document Confirmation',i_confirmation,i_method_name);
69: end if;
70:
71: /* Here we are checking to see if the sender of the inbound requested confirmation
72: for the document */
71: /* Here we are checking to see if the sender of the inbound requested confirmation
72: for the document */
73: if i_confirmation = 0
74: then
75: ecx_debug.setErrorInfo(0,10,'ECX_CONFIRM_NOT_REQUESTED',
76: 'p_transaction_type',
77: i_transaction_type,
78: 'p_transaction_subtype',
79: i_transaction_subtype,
110: --and rownum < 2;
111:
112: exception
113: when no_data_found then
114: ecx_debug.setErrorInfo(2,30,'ECX_CONFIRM_TP_NOT_SETUP',
115: 'p_transaction_type',
116: p_transaction_type,
117: 'p_transaction_subtype',
118: p_transaction_subtype,
121: raise ecx_utils.program_exit;
122:
123: /* Start of bug #2183619*/
124: when too_many_rows then
125: ecx_debug.setErrorInfo(2,30,'ECX_PARTY_TYPE_NOT_SET ');
126: raise ecx_utils.program_exit;
127: /* End of bug #2183619 */
128:
129: end;
127: /* End of bug #2183619 */
128:
129: end;
130: if(l_statementEnabled) then
131: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name);
132: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name);
133: end if;
134: if (l_procedureEnabled) then
135: ecx_debug.pop(i_method_name);
128:
129: end;
130: if(l_statementEnabled) then
131: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name);
132: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name);
133: end if;
134: if (l_procedureEnabled) then
135: ecx_debug.pop(i_method_name);
136: end if;
131: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name);
132: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name);
133: end if;
134: if (l_procedureEnabled) then
135: ecx_debug.pop(i_method_name);
136: end if;
137: exception
138: when ecx_no_delivery_required then
139: if (l_procedureEnabled) then
136: end if;
137: exception
138: when ecx_no_delivery_required then
139: if (l_procedureEnabled) then
140: ecx_debug.pop(i_method_name);
141: end if;
142: raise;
143: when ecx_utils.program_exit then
144: if (l_procedureEnabled) then
141: end if;
142: raise;
143: when ecx_utils.program_exit then
144: if (l_procedureEnabled) then
145: ecx_debug.pop(i_method_name);
146: end if;
147: raise ecx_utils.program_exit;
148: when others then
149: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.getConfirmation');
145: ecx_debug.pop(i_method_name);
146: end if;
147: raise ecx_utils.program_exit;
148: when others then
149: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.getConfirmation');
150: if (l_procedureEnabled) then
151: ecx_debug.pop(i_method_name);
152: end if;
153: raise ecx_utils.program_exit;
147: raise ecx_utils.program_exit;
148: when others then
149: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.getConfirmation');
150: if (l_procedureEnabled) then
151: ecx_debug.pop(i_method_name);
152: end if;
153: raise ecx_utils.program_exit;
154: end getConfirmation;
155:
196: v_messageproperties dbms_aq.message_properties_t;
197:
198: begin
199: if (l_procedureEnabled) then
200: ecx_debug.push(i_method_name);
201: end if;
202:
203: if(l_statementEnabled) then
204: ecx_debug.log(l_statement,'p_queue_name',p_queue_name,i_method_name);
200: ecx_debug.push(i_method_name);
201: end if;
202:
203: if(l_statementEnabled) then
204: ecx_debug.log(l_statement,'p_queue_name',p_queue_name,i_method_name);
205: ecx_debug.log(l_statement,'p_transaction_type',p_transaction_type,i_method_name);
206: ecx_debug.log(l_statement,'p_transaction_subtype',p_transaction_subtype,i_method_name);
207: ecx_debug.log(l_statement,'p_document_id',p_document_id,i_method_name);
208: ecx_debug.log(l_statement,'p_map_code',p_map_code,i_method_name);
201: end if;
202:
203: if(l_statementEnabled) then
204: ecx_debug.log(l_statement,'p_queue_name',p_queue_name,i_method_name);
205: ecx_debug.log(l_statement,'p_transaction_type',p_transaction_type,i_method_name);
206: ecx_debug.log(l_statement,'p_transaction_subtype',p_transaction_subtype,i_method_name);
207: ecx_debug.log(l_statement,'p_document_id',p_document_id,i_method_name);
208: ecx_debug.log(l_statement,'p_map_code',p_map_code,i_method_name);
209: ecx_debug.log(l_statement,'p_message_type',p_message_type,i_method_name);
202:
203: if(l_statementEnabled) then
204: ecx_debug.log(l_statement,'p_queue_name',p_queue_name,i_method_name);
205: ecx_debug.log(l_statement,'p_transaction_type',p_transaction_type,i_method_name);
206: ecx_debug.log(l_statement,'p_transaction_subtype',p_transaction_subtype,i_method_name);
207: ecx_debug.log(l_statement,'p_document_id',p_document_id,i_method_name);
208: ecx_debug.log(l_statement,'p_map_code',p_map_code,i_method_name);
209: ecx_debug.log(l_statement,'p_message_type',p_message_type,i_method_name);
210: ecx_debug.log(l_statement,'p_message_standard',p_message_standard,i_method_name);
203: if(l_statementEnabled) then
204: ecx_debug.log(l_statement,'p_queue_name',p_queue_name,i_method_name);
205: ecx_debug.log(l_statement,'p_transaction_type',p_transaction_type,i_method_name);
206: ecx_debug.log(l_statement,'p_transaction_subtype',p_transaction_subtype,i_method_name);
207: ecx_debug.log(l_statement,'p_document_id',p_document_id,i_method_name);
208: ecx_debug.log(l_statement,'p_map_code',p_map_code,i_method_name);
209: ecx_debug.log(l_statement,'p_message_type',p_message_type,i_method_name);
210: ecx_debug.log(l_statement,'p_message_standard',p_message_standard,i_method_name);
211: ecx_debug.log(l_statement,'p_party_id',p_party_id,i_method_name);
204: ecx_debug.log(l_statement,'p_queue_name',p_queue_name,i_method_name);
205: ecx_debug.log(l_statement,'p_transaction_type',p_transaction_type,i_method_name);
206: ecx_debug.log(l_statement,'p_transaction_subtype',p_transaction_subtype,i_method_name);
207: ecx_debug.log(l_statement,'p_document_id',p_document_id,i_method_name);
208: ecx_debug.log(l_statement,'p_map_code',p_map_code,i_method_name);
209: ecx_debug.log(l_statement,'p_message_type',p_message_type,i_method_name);
210: ecx_debug.log(l_statement,'p_message_standard',p_message_standard,i_method_name);
211: ecx_debug.log(l_statement,'p_party_id',p_party_id,i_method_name);
212: ecx_debug.log(l_statement,'p_party_site_id',p_party_site_id,i_method_name);
205: ecx_debug.log(l_statement,'p_transaction_type',p_transaction_type,i_method_name);
206: ecx_debug.log(l_statement,'p_transaction_subtype',p_transaction_subtype,i_method_name);
207: ecx_debug.log(l_statement,'p_document_id',p_document_id,i_method_name);
208: ecx_debug.log(l_statement,'p_map_code',p_map_code,i_method_name);
209: ecx_debug.log(l_statement,'p_message_type',p_message_type,i_method_name);
210: ecx_debug.log(l_statement,'p_message_standard',p_message_standard,i_method_name);
211: ecx_debug.log(l_statement,'p_party_id',p_party_id,i_method_name);
212: ecx_debug.log(l_statement,'p_party_site_id',p_party_site_id,i_method_name);
213: ecx_debug.log(l_statement,'p_party_type',p_party_type,i_method_name);
206: ecx_debug.log(l_statement,'p_transaction_subtype',p_transaction_subtype,i_method_name);
207: ecx_debug.log(l_statement,'p_document_id',p_document_id,i_method_name);
208: ecx_debug.log(l_statement,'p_map_code',p_map_code,i_method_name);
209: ecx_debug.log(l_statement,'p_message_type',p_message_type,i_method_name);
210: ecx_debug.log(l_statement,'p_message_standard',p_message_standard,i_method_name);
211: ecx_debug.log(l_statement,'p_party_id',p_party_id,i_method_name);
212: ecx_debug.log(l_statement,'p_party_site_id',p_party_site_id,i_method_name);
213: ecx_debug.log(l_statement,'p_party_type',p_party_type,i_method_name);
214: ecx_debug.log(l_statement,'p_ext_type',p_ext_type,i_method_name);
207: ecx_debug.log(l_statement,'p_document_id',p_document_id,i_method_name);
208: ecx_debug.log(l_statement,'p_map_code',p_map_code,i_method_name);
209: ecx_debug.log(l_statement,'p_message_type',p_message_type,i_method_name);
210: ecx_debug.log(l_statement,'p_message_standard',p_message_standard,i_method_name);
211: ecx_debug.log(l_statement,'p_party_id',p_party_id,i_method_name);
212: ecx_debug.log(l_statement,'p_party_site_id',p_party_site_id,i_method_name);
213: ecx_debug.log(l_statement,'p_party_type',p_party_type,i_method_name);
214: ecx_debug.log(l_statement,'p_ext_type',p_ext_type,i_method_name);
215: ecx_debug.log(l_statement,'p_ext_subtype',p_ext_subtype,i_method_name);
208: ecx_debug.log(l_statement,'p_map_code',p_map_code,i_method_name);
209: ecx_debug.log(l_statement,'p_message_type',p_message_type,i_method_name);
210: ecx_debug.log(l_statement,'p_message_standard',p_message_standard,i_method_name);
211: ecx_debug.log(l_statement,'p_party_id',p_party_id,i_method_name);
212: ecx_debug.log(l_statement,'p_party_site_id',p_party_site_id,i_method_name);
213: ecx_debug.log(l_statement,'p_party_type',p_party_type,i_method_name);
214: ecx_debug.log(l_statement,'p_ext_type',p_ext_type,i_method_name);
215: ecx_debug.log(l_statement,'p_ext_subtype',p_ext_subtype,i_method_name);
216: ecx_debug.log(l_statement,'p_party_source_location_code',p_party_source_location_code,i_method_name);
209: ecx_debug.log(l_statement,'p_message_type',p_message_type,i_method_name);
210: ecx_debug.log(l_statement,'p_message_standard',p_message_standard,i_method_name);
211: ecx_debug.log(l_statement,'p_party_id',p_party_id,i_method_name);
212: ecx_debug.log(l_statement,'p_party_site_id',p_party_site_id,i_method_name);
213: ecx_debug.log(l_statement,'p_party_type',p_party_type,i_method_name);
214: ecx_debug.log(l_statement,'p_ext_type',p_ext_type,i_method_name);
215: ecx_debug.log(l_statement,'p_ext_subtype',p_ext_subtype,i_method_name);
216: ecx_debug.log(l_statement,'p_party_source_location_code',p_party_source_location_code,i_method_name);
217: ecx_debug.log(l_statement,'p_destination_type',p_destination_type,i_method_name);
210: ecx_debug.log(l_statement,'p_message_standard',p_message_standard,i_method_name);
211: ecx_debug.log(l_statement,'p_party_id',p_party_id,i_method_name);
212: ecx_debug.log(l_statement,'p_party_site_id',p_party_site_id,i_method_name);
213: ecx_debug.log(l_statement,'p_party_type',p_party_type,i_method_name);
214: ecx_debug.log(l_statement,'p_ext_type',p_ext_type,i_method_name);
215: ecx_debug.log(l_statement,'p_ext_subtype',p_ext_subtype,i_method_name);
216: ecx_debug.log(l_statement,'p_party_source_location_code',p_party_source_location_code,i_method_name);
217: ecx_debug.log(l_statement,'p_destination_type',p_destination_type,i_method_name);
218: ecx_debug.log(l_statement,'p_destination_address',p_destination_address,i_method_name);
211: ecx_debug.log(l_statement,'p_party_id',p_party_id,i_method_name);
212: ecx_debug.log(l_statement,'p_party_site_id',p_party_site_id,i_method_name);
213: ecx_debug.log(l_statement,'p_party_type',p_party_type,i_method_name);
214: ecx_debug.log(l_statement,'p_ext_type',p_ext_type,i_method_name);
215: ecx_debug.log(l_statement,'p_ext_subtype',p_ext_subtype,i_method_name);
216: ecx_debug.log(l_statement,'p_party_source_location_code',p_party_source_location_code,i_method_name);
217: ecx_debug.log(l_statement,'p_destination_type',p_destination_type,i_method_name);
218: ecx_debug.log(l_statement,'p_destination_address',p_destination_address,i_method_name);
219: ecx_debug.log(l_statement,'p_username',p_username,i_method_name);
212: ecx_debug.log(l_statement,'p_party_site_id',p_party_site_id,i_method_name);
213: ecx_debug.log(l_statement,'p_party_type',p_party_type,i_method_name);
214: ecx_debug.log(l_statement,'p_ext_type',p_ext_type,i_method_name);
215: ecx_debug.log(l_statement,'p_ext_subtype',p_ext_subtype,i_method_name);
216: ecx_debug.log(l_statement,'p_party_source_location_code',p_party_source_location_code,i_method_name);
217: ecx_debug.log(l_statement,'p_destination_type',p_destination_type,i_method_name);
218: ecx_debug.log(l_statement,'p_destination_address',p_destination_address,i_method_name);
219: ecx_debug.log(l_statement,'p_username',p_username,i_method_name);
220: ecx_debug.log(l_statement,'p_password',p_password,i_method_name);
213: ecx_debug.log(l_statement,'p_party_type',p_party_type,i_method_name);
214: ecx_debug.log(l_statement,'p_ext_type',p_ext_type,i_method_name);
215: ecx_debug.log(l_statement,'p_ext_subtype',p_ext_subtype,i_method_name);
216: ecx_debug.log(l_statement,'p_party_source_location_code',p_party_source_location_code,i_method_name);
217: ecx_debug.log(l_statement,'p_destination_type',p_destination_type,i_method_name);
218: ecx_debug.log(l_statement,'p_destination_address',p_destination_address,i_method_name);
219: ecx_debug.log(l_statement,'p_username',p_username,i_method_name);
220: ecx_debug.log(l_statement,'p_password',p_password,i_method_name);
221: ecx_debug.log(l_statement,'p_attribute1',p_attribute1,i_method_name);
214: ecx_debug.log(l_statement,'p_ext_type',p_ext_type,i_method_name);
215: ecx_debug.log(l_statement,'p_ext_subtype',p_ext_subtype,i_method_name);
216: ecx_debug.log(l_statement,'p_party_source_location_code',p_party_source_location_code,i_method_name);
217: ecx_debug.log(l_statement,'p_destination_type',p_destination_type,i_method_name);
218: ecx_debug.log(l_statement,'p_destination_address',p_destination_address,i_method_name);
219: ecx_debug.log(l_statement,'p_username',p_username,i_method_name);
220: ecx_debug.log(l_statement,'p_password',p_password,i_method_name);
221: ecx_debug.log(l_statement,'p_attribute1',p_attribute1,i_method_name);
222: ecx_debug.log(l_statement,'p_attribute2',p_attribute2,i_method_name);
215: ecx_debug.log(l_statement,'p_ext_subtype',p_ext_subtype,i_method_name);
216: ecx_debug.log(l_statement,'p_party_source_location_code',p_party_source_location_code,i_method_name);
217: ecx_debug.log(l_statement,'p_destination_type',p_destination_type,i_method_name);
218: ecx_debug.log(l_statement,'p_destination_address',p_destination_address,i_method_name);
219: ecx_debug.log(l_statement,'p_username',p_username,i_method_name);
220: ecx_debug.log(l_statement,'p_password',p_password,i_method_name);
221: ecx_debug.log(l_statement,'p_attribute1',p_attribute1,i_method_name);
222: ecx_debug.log(l_statement,'p_attribute2',p_attribute2,i_method_name);
223: ecx_debug.log(l_statement,'p_party_target_location_code',p_party_target_location_code,i_method_name);
216: ecx_debug.log(l_statement,'p_party_source_location_code',p_party_source_location_code,i_method_name);
217: ecx_debug.log(l_statement,'p_destination_type',p_destination_type,i_method_name);
218: ecx_debug.log(l_statement,'p_destination_address',p_destination_address,i_method_name);
219: ecx_debug.log(l_statement,'p_username',p_username,i_method_name);
220: ecx_debug.log(l_statement,'p_password',p_password,i_method_name);
221: ecx_debug.log(l_statement,'p_attribute1',p_attribute1,i_method_name);
222: ecx_debug.log(l_statement,'p_attribute2',p_attribute2,i_method_name);
223: ecx_debug.log(l_statement,'p_party_target_location_code',p_party_target_location_code,i_method_name);
224: ecx_debug.log(l_statement,'p_attribute4',p_attribute4,i_method_name);
217: ecx_debug.log(l_statement,'p_destination_type',p_destination_type,i_method_name);
218: ecx_debug.log(l_statement,'p_destination_address',p_destination_address,i_method_name);
219: ecx_debug.log(l_statement,'p_username',p_username,i_method_name);
220: ecx_debug.log(l_statement,'p_password',p_password,i_method_name);
221: ecx_debug.log(l_statement,'p_attribute1',p_attribute1,i_method_name);
222: ecx_debug.log(l_statement,'p_attribute2',p_attribute2,i_method_name);
223: ecx_debug.log(l_statement,'p_party_target_location_code',p_party_target_location_code,i_method_name);
224: ecx_debug.log(l_statement,'p_attribute4',p_attribute4,i_method_name);
225: ecx_debug.log(l_statement,'p_attribute5',p_attribute5,i_method_name);
218: ecx_debug.log(l_statement,'p_destination_address',p_destination_address,i_method_name);
219: ecx_debug.log(l_statement,'p_username',p_username,i_method_name);
220: ecx_debug.log(l_statement,'p_password',p_password,i_method_name);
221: ecx_debug.log(l_statement,'p_attribute1',p_attribute1,i_method_name);
222: ecx_debug.log(l_statement,'p_attribute2',p_attribute2,i_method_name);
223: ecx_debug.log(l_statement,'p_party_target_location_code',p_party_target_location_code,i_method_name);
224: ecx_debug.log(l_statement,'p_attribute4',p_attribute4,i_method_name);
225: ecx_debug.log(l_statement,'p_attribute5',p_attribute5,i_method_name);
226: ecx_debug.log(l_statement,'p_param1',p_param1,i_method_name);
219: ecx_debug.log(l_statement,'p_username',p_username,i_method_name);
220: ecx_debug.log(l_statement,'p_password',p_password,i_method_name);
221: ecx_debug.log(l_statement,'p_attribute1',p_attribute1,i_method_name);
222: ecx_debug.log(l_statement,'p_attribute2',p_attribute2,i_method_name);
223: ecx_debug.log(l_statement,'p_party_target_location_code',p_party_target_location_code,i_method_name);
224: ecx_debug.log(l_statement,'p_attribute4',p_attribute4,i_method_name);
225: ecx_debug.log(l_statement,'p_attribute5',p_attribute5,i_method_name);
226: ecx_debug.log(l_statement,'p_param1',p_param1,i_method_name);
227: ecx_debug.log(l_statement,'p_param2',p_param2,i_method_name);
220: ecx_debug.log(l_statement,'p_password',p_password,i_method_name);
221: ecx_debug.log(l_statement,'p_attribute1',p_attribute1,i_method_name);
222: ecx_debug.log(l_statement,'p_attribute2',p_attribute2,i_method_name);
223: ecx_debug.log(l_statement,'p_party_target_location_code',p_party_target_location_code,i_method_name);
224: ecx_debug.log(l_statement,'p_attribute4',p_attribute4,i_method_name);
225: ecx_debug.log(l_statement,'p_attribute5',p_attribute5,i_method_name);
226: ecx_debug.log(l_statement,'p_param1',p_param1,i_method_name);
227: ecx_debug.log(l_statement,'p_param2',p_param2,i_method_name);
228: ecx_debug.log(l_statement,'p_param3',p_param3,i_method_name);
221: ecx_debug.log(l_statement,'p_attribute1',p_attribute1,i_method_name);
222: ecx_debug.log(l_statement,'p_attribute2',p_attribute2,i_method_name);
223: ecx_debug.log(l_statement,'p_party_target_location_code',p_party_target_location_code,i_method_name);
224: ecx_debug.log(l_statement,'p_attribute4',p_attribute4,i_method_name);
225: ecx_debug.log(l_statement,'p_attribute5',p_attribute5,i_method_name);
226: ecx_debug.log(l_statement,'p_param1',p_param1,i_method_name);
227: ecx_debug.log(l_statement,'p_param2',p_param2,i_method_name);
228: ecx_debug.log(l_statement,'p_param3',p_param3,i_method_name);
229: ecx_debug.log(l_statement,'p_param4',p_param4,i_method_name);
222: ecx_debug.log(l_statement,'p_attribute2',p_attribute2,i_method_name);
223: ecx_debug.log(l_statement,'p_party_target_location_code',p_party_target_location_code,i_method_name);
224: ecx_debug.log(l_statement,'p_attribute4',p_attribute4,i_method_name);
225: ecx_debug.log(l_statement,'p_attribute5',p_attribute5,i_method_name);
226: ecx_debug.log(l_statement,'p_param1',p_param1,i_method_name);
227: ecx_debug.log(l_statement,'p_param2',p_param2,i_method_name);
228: ecx_debug.log(l_statement,'p_param3',p_param3,i_method_name);
229: ecx_debug.log(l_statement,'p_param4',p_param4,i_method_name);
230: ecx_debug.log(l_statement,'p_param5',p_param5,i_method_name);
223: ecx_debug.log(l_statement,'p_party_target_location_code',p_party_target_location_code,i_method_name);
224: ecx_debug.log(l_statement,'p_attribute4',p_attribute4,i_method_name);
225: ecx_debug.log(l_statement,'p_attribute5',p_attribute5,i_method_name);
226: ecx_debug.log(l_statement,'p_param1',p_param1,i_method_name);
227: ecx_debug.log(l_statement,'p_param2',p_param2,i_method_name);
228: ecx_debug.log(l_statement,'p_param3',p_param3,i_method_name);
229: ecx_debug.log(l_statement,'p_param4',p_param4,i_method_name);
230: ecx_debug.log(l_statement,'p_param5',p_param5,i_method_name);
231: end if;
224: ecx_debug.log(l_statement,'p_attribute4',p_attribute4,i_method_name);
225: ecx_debug.log(l_statement,'p_attribute5',p_attribute5,i_method_name);
226: ecx_debug.log(l_statement,'p_param1',p_param1,i_method_name);
227: ecx_debug.log(l_statement,'p_param2',p_param2,i_method_name);
228: ecx_debug.log(l_statement,'p_param3',p_param3,i_method_name);
229: ecx_debug.log(l_statement,'p_param4',p_param4,i_method_name);
230: ecx_debug.log(l_statement,'p_param5',p_param5,i_method_name);
231: end if;
232:
225: ecx_debug.log(l_statement,'p_attribute5',p_attribute5,i_method_name);
226: ecx_debug.log(l_statement,'p_param1',p_param1,i_method_name);
227: ecx_debug.log(l_statement,'p_param2',p_param2,i_method_name);
228: ecx_debug.log(l_statement,'p_param3',p_param3,i_method_name);
229: ecx_debug.log(l_statement,'p_param4',p_param4,i_method_name);
230: ecx_debug.log(l_statement,'p_param5',p_param5,i_method_name);
231: end if;
232:
233: v_message := system.ecx_outengobj
226: ecx_debug.log(l_statement,'p_param1',p_param1,i_method_name);
227: ecx_debug.log(l_statement,'p_param2',p_param2,i_method_name);
228: ecx_debug.log(l_statement,'p_param3',p_param3,i_method_name);
229: ecx_debug.log(l_statement,'p_param4',p_param4,i_method_name);
230: ecx_debug.log(l_statement,'p_param5',p_param5,i_method_name);
231: end if;
232:
233: v_message := system.ecx_outengobj
234: (
268: payload => v_message,
269: msgid => o_msgid
270: );
271: if(l_statementEnabled) then
272: ecx_debug.log(l_statement,'o_msgid',o_msgid,i_method_name);
273: end if;
274: if (l_procedureEnabled) then
275: ecx_debug.pop(i_method_name);
276: end if;
271: if(l_statementEnabled) then
272: ecx_debug.log(l_statement,'o_msgid',o_msgid,i_method_name);
273: end if;
274: if (l_procedureEnabled) then
275: ecx_debug.pop(i_method_name);
276: end if;
277: exception
278: when others then
279: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.PUT_ON_ENGQUEUE');
275: ecx_debug.pop(i_method_name);
276: end if;
277: exception
278: when others then
279: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.PUT_ON_ENGQUEUE');
280: if (l_procedureEnabled) then
281: ecx_debug.pop(i_method_name);
282: end if;
283: raise ecx_utils.program_exit;
277: exception
278: when others then
279: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.PUT_ON_ENGQUEUE');
280: if (l_procedureEnabled) then
281: ecx_debug.pop(i_method_name);
282: end if;
283: raise ecx_utils.program_exit;
284: end put_on_engqueue;
285:
314: i_hub_id number;
315: i_connection_type varchar2(30);
316: BEGIN
317: if (l_procedureEnabled) then
318: ecx_debug.push(i_method_name);
319: end if;
320:
321: if(l_statementEnabled) then
322: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
318: ecx_debug.push(i_method_name);
319: end if;
320:
321: if(l_statementEnabled) then
322: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
323: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
324: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name);
325: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name);
326: ecx_debug.log(l_statement,'party_type',i_party_type,i_method_name);
319: end if;
320:
321: if(l_statementEnabled) then
322: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
323: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
324: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name);
325: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name);
326: ecx_debug.log(l_statement,'party_type',i_party_type,i_method_name);
327: end if;
320:
321: if(l_statementEnabled) then
322: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
323: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
324: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name);
325: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name);
326: ecx_debug.log(l_statement,'party_type',i_party_type,i_method_name);
327: end if;
328:
321: if(l_statementEnabled) then
322: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
323: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
324: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name);
325: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name);
326: ecx_debug.log(l_statement,'party_type',i_party_type,i_method_name);
327: end if;
328:
329: /** Validate whether the transaction exists ... **/
322: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
323: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
324: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name);
325: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name);
326: ecx_debug.log(l_statement,'party_type',i_party_type,i_method_name);
327: end if;
328:
329: /** Validate whether the transaction exists ... **/
330: Begin
337: and (i_party_type is null or party_type = i_party_type);
338: Exception
339: /* Start of bug #2183619*/
340: when too_many_rows then
341: ecx_debug.setErrorInfo(2,30,'ECX_PARTY_TYPE_NOT_SET');
342: raise ecx_utils.program_exit;
343: /* End of bug #2183619 */
344: When Others then
345: /** Email goes to Sys Admin***/
342: raise ecx_utils.program_exit;
343: /* End of bug #2183619 */
344: When Others then
345: /** Email goes to Sys Admin***/
346: ecx_debug.setErrorInfo(1,30,'ECX_TRANSACTION_NOT_FOUND',
347: 'p_transaction_type',
348: i_transaction_type,
349: 'p_transaction_subtype',
350: i_transaction_subtype,
410: and em.map_id = etd.map_id;
411: exception
412: /* Start of bug #2183619*/
413: when too_many_rows then
414: ecx_debug.setErrorInfo(2,30,'ECX_PARTY_TYPE_NOT_SET');
415: raise ecx_utils.program_exit;
416: /* End of bug #2183619 */
417: when others then
418: /** Email goes to Sys Admin***/
415: raise ecx_utils.program_exit;
416: /* End of bug #2183619 */
417: when others then
418: /** Email goes to Sys Admin***/
419: ecx_debug.setErrorInfo(1,30,'ECX_DELIVERY_TP_NOT_SETUP',
420: 'p_transaction_type',
421: i_transaction_type,
422: 'p_transaction_subtype',
423: i_transaction_subtype,
459:
460: exception
461: when others then
462: /** Email goes to Sys Admin***/
463: ecx_debug.setErrorInfo(1,30,'ECX_DELIVERY_HUB_NOT_SETUP');
464: raise ecx_delivery_setup_error;
465: end;
466: end if;
467:
465: end;
466: end if;
467:
468: if(l_statementEnabled) then
469: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name);
470: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
471: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
472: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
473: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
466: end if;
467:
468: if(l_statementEnabled) then
469: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name);
470: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
471: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
472: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
473: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
474: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
467:
468: if(l_statementEnabled) then
469: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name);
470: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
471: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
472: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
473: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
474: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
475: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
468: if(l_statementEnabled) then
469: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name);
470: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
471: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
472: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
473: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
474: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
475: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
476: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
469: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name);
470: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
471: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
472: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
473: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
474: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
475: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
476: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
477: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
470: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
471: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
472: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
473: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
474: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
475: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
476: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
477: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
478: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
471: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
472: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
473: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
474: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
475: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
476: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
477: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
478: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
479: ecx_debug.log(l_statement,'i_password',i_password,i_method_name);
472: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
473: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
474: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
475: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
476: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
477: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
478: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
479: ecx_debug.log(l_statement,'i_password',i_password,i_method_name);
480: ecx_debug.log(l_statement,'i_queue_name',i_queue_name,i_method_name);
473: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
474: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
475: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
476: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
477: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
478: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
479: ecx_debug.log(l_statement,'i_password',i_password,i_method_name);
480: ecx_debug.log(l_statement,'i_queue_name',i_queue_name,i_method_name);
481: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
474: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
475: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
476: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
477: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
478: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
479: ecx_debug.log(l_statement,'i_password',i_password,i_method_name);
480: ecx_debug.log(l_statement,'i_queue_name',i_queue_name,i_method_name);
481: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
482: ecx_debug.log(l_statement,'i_tp_header_id',i_tp_header_id,i_method_name);
475: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);
476: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
477: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
478: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
479: ecx_debug.log(l_statement,'i_password',i_password,i_method_name);
480: ecx_debug.log(l_statement,'i_queue_name',i_queue_name,i_method_name);
481: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
482: ecx_debug.log(l_statement,'i_tp_header_id',i_tp_header_id,i_method_name);
483: end if;
476: ecx_debug.log(l_statement,'i_destination_type',i_destination_type,i_method_name);
477: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
478: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
479: ecx_debug.log(l_statement,'i_password',i_password,i_method_name);
480: ecx_debug.log(l_statement,'i_queue_name',i_queue_name,i_method_name);
481: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
482: ecx_debug.log(l_statement,'i_tp_header_id',i_tp_header_id,i_method_name);
483: end if;
484: if (l_procedureEnabled) then
477: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name);
478: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
479: ecx_debug.log(l_statement,'i_password',i_password,i_method_name);
480: ecx_debug.log(l_statement,'i_queue_name',i_queue_name,i_method_name);
481: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
482: ecx_debug.log(l_statement,'i_tp_header_id',i_tp_header_id,i_method_name);
483: end if;
484: if (l_procedureEnabled) then
485: ecx_debug.pop(i_method_name);
478: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
479: ecx_debug.log(l_statement,'i_password',i_password,i_method_name);
480: ecx_debug.log(l_statement,'i_queue_name',i_queue_name,i_method_name);
481: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
482: ecx_debug.log(l_statement,'i_tp_header_id',i_tp_header_id,i_method_name);
483: end if;
484: if (l_procedureEnabled) then
485: ecx_debug.pop(i_method_name);
486: end if;
481: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name);
482: ecx_debug.log(l_statement,'i_tp_header_id',i_tp_header_id,i_method_name);
483: end if;
484: if (l_procedureEnabled) then
485: ecx_debug.pop(i_method_name);
486: end if;
487: EXCEPTION
488: when ecx_transaction_not_defined then
489: if (l_procedureEnabled) then
486: end if;
487: EXCEPTION
488: when ecx_transaction_not_defined then
489: if (l_procedureEnabled) then
490: ecx_debug.pop(i_method_name);
491: end if;
492: raise;
493: when ecx_no_party_setup then
494: if (l_procedureEnabled) then
491: end if;
492: raise;
493: when ecx_no_party_setup then
494: if (l_procedureEnabled) then
495: ecx_debug.pop(i_method_name);
496: end if;
497: raise;
498: when ecx_no_delivery_required then
499: if (l_procedureEnabled) then
496: end if;
497: raise;
498: when ecx_no_delivery_required then
499: if (l_procedureEnabled) then
500: ecx_debug.pop(i_method_name);
501: end if;
502: raise;
503: when ecx_delivery_setup_error then
504: if (l_procedureEnabled) then
501: end if;
502: raise;
503: when ecx_delivery_setup_error then
504: if (l_procedureEnabled) then
505: ecx_debug.pop(i_method_name);
506: end if;
507: raise;
508: WHEN ECX_UTILS.PROGRAM_EXIT THEN
509: if (l_procedureEnabled) then
506: end if;
507: raise;
508: WHEN ECX_UTILS.PROGRAM_EXIT THEN
509: if (l_procedureEnabled) then
510: ecx_debug.pop(i_method_name);
511: end if;
512: raise ecx_utils.program_exit;
513: WHEN OTHERS THEN
514: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.GET_DELIVERY_ATTRIBS');
510: ecx_debug.pop(i_method_name);
511: end if;
512: raise ecx_utils.program_exit;
513: WHEN OTHERS THEN
514: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.GET_DELIVERY_ATTRIBS');
515: if (l_procedureEnabled) then
516: ecx_debug.pop(i_method_name);
517: end if;
518: raise ecx_utils.program_exit;
512: raise ecx_utils.program_exit;
513: WHEN OTHERS THEN
514: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.GET_DELIVERY_ATTRIBS');
515: if (l_procedureEnabled) then
516: ecx_debug.pop(i_method_name);
517: end if;
518: raise ecx_utils.program_exit;
519: END get_delivery_attribs;
520:
671: exception
672: /* raised only by getConfirmation at this point */
673: WHEN ECX_NO_DELIVERY_REQUIRED THEN
674: if (l_procedureEnabled) then
675: ecx_debug.pop(i_method_name);
676: end if;
677: raise;
678: when ecx_transaction_not_defined then
679: if (l_procedureEnabled) then
676: end if;
677: raise;
678: when ecx_transaction_not_defined then
679: if (l_procedureEnabled) then
680: ecx_debug.pop(i_method_name);
681: end if;
682: raise;
683: when ecx_no_party_setup then
684: if (l_procedureEnabled) then
681: end if;
682: raise;
683: when ecx_no_party_setup then
684: if (l_procedureEnabled) then
685: ecx_debug.pop(i_method_name);
686: end if;
687: raise;
688: when ecx_delivery_setup_error then
689: if (l_procedureEnabled) then
686: end if;
687: raise;
688: when ecx_delivery_setup_error then
689: if (l_procedureEnabled) then
690: ecx_debug.pop(i_method_name);
691: end if;
692: raise;
693: when ecx_utils.program_exit then
694: if (l_procedureEnabled) then
691: end if;
692: raise;
693: when ecx_utils.program_exit then
694: if (l_procedureEnabled) then
695: ecx_debug.pop(i_method_name);
696: end if;
697: raise ecx_utils.program_exit;
698: when others then
699: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.TRIGGER_OUTBOUND');
695: ecx_debug.pop(i_method_name);
696: end if;
697: raise ecx_utils.program_exit;
698: when others then
699: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.TRIGGER_OUTBOUND');
700: if (l_procedureEnabled) then
701: ecx_debug.pop(i_method_name);
702: end if;
703: raise ecx_utils.program_exit;
697: raise ecx_utils.program_exit;
698: when others then
699: ecx_debug.setErrorInfo(2,30,SQLERRM ||'- ECX_DOCUMENT.TRIGGER_OUTBOUND');
700: if (l_procedureEnabled) then
701: ecx_debug.pop(i_method_name);
702: end if;
703: raise ecx_utils.program_exit;
704: end trigger_outbound;
705:
765: logging_enabled varchar2(20);
766: module varchar2(2000);
767:
768: begin
769: --before calling this API we need to re-initialize ecx_debug.g_v_module_name
770: ecx_debug.g_v_module_name :='ecx.plsql.';
771: ecx_debug.module_enabled(transaction_type,transaction_subtype,document_id);
772: g_instlmode := wf_core.translate('WF_INSTALL');
773:
766: module varchar2(2000);
767:
768: begin
769: --before calling this API we need to re-initialize ecx_debug.g_v_module_name
770: ecx_debug.g_v_module_name :='ecx.plsql.';
771: ecx_debug.module_enabled(transaction_type,transaction_subtype,document_id);
772: g_instlmode := wf_core.translate('WF_INSTALL');
773:
774: if(g_instlmode = 'EMBEDDED')
767:
768: begin
769: --before calling this API we need to re-initialize ecx_debug.g_v_module_name
770: ecx_debug.g_v_module_name :='ecx.plsql.';
771: ecx_debug.module_enabled(transaction_type,transaction_subtype,document_id);
772: g_instlmode := wf_core.translate('WF_INSTALL');
773:
774: if(g_instlmode = 'EMBEDDED')
775: then
775: then
776: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
777: fnd_profile.get('AFLOG_MODULE',module);
778: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
779: AND instr(lower(ecx_debug.g_v_module_name),rtrim(lower(module),'%'))> 0)
780: OR module='%')
781: AND FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) then
782: ecx_logging_enabled := true;
783: end if;
814: p_aflog_module_name := p_aflog_module_name||trigger_id;
815: END IF;
816: p_aflog_module_name := p_aflog_module_name||'.log';
817:
818: ecx_debug.enable_debug_new(debug_mode, ecx_utils.g_logdir, 'TRIG'||transaction_type||transaction_subtype||
819: document_id||trigger_id||'.log', p_aflog_module_name);
820: END IF;
821:
822: /* Assign local variables with the ecx_debug global variables*/
818: ecx_debug.enable_debug_new(debug_mode, ecx_utils.g_logdir, 'TRIG'||transaction_type||transaction_subtype||
819: document_id||trigger_id||'.log', p_aflog_module_name);
820: END IF;
821:
822: /* Assign local variables with the ecx_debug global variables*/
823: l_procedure := ecx_debug.g_procedure;
824: l_statement := ecx_debug.g_statement;
825: l_unexpected := ecx_debug.g_unexpected;
826: l_procedureEnabled := ecx_debug.g_procedureEnabled;
819: document_id||trigger_id||'.log', p_aflog_module_name);
820: END IF;
821:
822: /* Assign local variables with the ecx_debug global variables*/
823: l_procedure := ecx_debug.g_procedure;
824: l_statement := ecx_debug.g_statement;
825: l_unexpected := ecx_debug.g_unexpected;
826: l_procedureEnabled := ecx_debug.g_procedureEnabled;
827: l_statementEnabled := ecx_debug.g_statementEnabled;
820: END IF;
821:
822: /* Assign local variables with the ecx_debug global variables*/
823: l_procedure := ecx_debug.g_procedure;
824: l_statement := ecx_debug.g_statement;
825: l_unexpected := ecx_debug.g_unexpected;
826: l_procedureEnabled := ecx_debug.g_procedureEnabled;
827: l_statementEnabled := ecx_debug.g_statementEnabled;
828: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
821:
822: /* Assign local variables with the ecx_debug global variables*/
823: l_procedure := ecx_debug.g_procedure;
824: l_statement := ecx_debug.g_statement;
825: l_unexpected := ecx_debug.g_unexpected;
826: l_procedureEnabled := ecx_debug.g_procedureEnabled;
827: l_statementEnabled := ecx_debug.g_statementEnabled;
828: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
829:
822: /* Assign local variables with the ecx_debug global variables*/
823: l_procedure := ecx_debug.g_procedure;
824: l_statement := ecx_debug.g_statement;
825: l_unexpected := ecx_debug.g_unexpected;
826: l_procedureEnabled := ecx_debug.g_procedureEnabled;
827: l_statementEnabled := ecx_debug.g_statementEnabled;
828: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
829:
830: if (l_procedureEnabled) then
823: l_procedure := ecx_debug.g_procedure;
824: l_statement := ecx_debug.g_statement;
825: l_unexpected := ecx_debug.g_unexpected;
826: l_procedureEnabled := ecx_debug.g_procedureEnabled;
827: l_statementEnabled := ecx_debug.g_statementEnabled;
828: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
829:
830: if (l_procedureEnabled) then
831: ecx_debug.push(i_method_name);
824: l_statement := ecx_debug.g_statement;
825: l_unexpected := ecx_debug.g_unexpected;
826: l_procedureEnabled := ecx_debug.g_procedureEnabled;
827: l_statementEnabled := ecx_debug.g_statementEnabled;
828: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
829:
830: if (l_procedureEnabled) then
831: ecx_debug.push(i_method_name);
832: end if;
827: l_statementEnabled := ecx_debug.g_statementEnabled;
828: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
829:
830: if (l_procedureEnabled) then
831: ecx_debug.push(i_method_name);
832: end if;
833:
834: if(l_statementEnabled) then
835: ecx_debug.log(l_statement,'transaction_type', transaction_type,i_method_name);
831: ecx_debug.push(i_method_name);
832: end if;
833:
834: if(l_statementEnabled) then
835: ecx_debug.log(l_statement,'transaction_type', transaction_type,i_method_name);
836: ecx_debug.log(l_statement,'transaction_subtype', transaction_subtype,i_method_name);
837: ecx_debug.log(l_statement,'party_id', party_id,i_method_name);
838: ecx_debug.log(l_statement,'party_site_id', party_site_id,i_method_name);
839: ecx_debug.log(l_statement,'document_id', document_id,i_method_name);
832: end if;
833:
834: if(l_statementEnabled) then
835: ecx_debug.log(l_statement,'transaction_type', transaction_type,i_method_name);
836: ecx_debug.log(l_statement,'transaction_subtype', transaction_subtype,i_method_name);
837: ecx_debug.log(l_statement,'party_id', party_id,i_method_name);
838: ecx_debug.log(l_statement,'party_site_id', party_site_id,i_method_name);
839: ecx_debug.log(l_statement,'document_id', document_id,i_method_name);
840: ecx_debug.log(l_statement,'parameter1', parameter1,i_method_name);
833:
834: if(l_statementEnabled) then
835: ecx_debug.log(l_statement,'transaction_type', transaction_type,i_method_name);
836: ecx_debug.log(l_statement,'transaction_subtype', transaction_subtype,i_method_name);
837: ecx_debug.log(l_statement,'party_id', party_id,i_method_name);
838: ecx_debug.log(l_statement,'party_site_id', party_site_id,i_method_name);
839: ecx_debug.log(l_statement,'document_id', document_id,i_method_name);
840: ecx_debug.log(l_statement,'parameter1', parameter1,i_method_name);
841: ecx_debug.log(l_statement,'parameter2', parameter2,i_method_name);
834: if(l_statementEnabled) then
835: ecx_debug.log(l_statement,'transaction_type', transaction_type,i_method_name);
836: ecx_debug.log(l_statement,'transaction_subtype', transaction_subtype,i_method_name);
837: ecx_debug.log(l_statement,'party_id', party_id,i_method_name);
838: ecx_debug.log(l_statement,'party_site_id', party_site_id,i_method_name);
839: ecx_debug.log(l_statement,'document_id', document_id,i_method_name);
840: ecx_debug.log(l_statement,'parameter1', parameter1,i_method_name);
841: ecx_debug.log(l_statement,'parameter2', parameter2,i_method_name);
842: ecx_debug.log(l_statement,'parameter3', parameter3,i_method_name);
835: ecx_debug.log(l_statement,'transaction_type', transaction_type,i_method_name);
836: ecx_debug.log(l_statement,'transaction_subtype', transaction_subtype,i_method_name);
837: ecx_debug.log(l_statement,'party_id', party_id,i_method_name);
838: ecx_debug.log(l_statement,'party_site_id', party_site_id,i_method_name);
839: ecx_debug.log(l_statement,'document_id', document_id,i_method_name);
840: ecx_debug.log(l_statement,'parameter1', parameter1,i_method_name);
841: ecx_debug.log(l_statement,'parameter2', parameter2,i_method_name);
842: ecx_debug.log(l_statement,'parameter3', parameter3,i_method_name);
843: ecx_debug.log(l_statement,'parameter4', parameter4,i_method_name);
836: ecx_debug.log(l_statement,'transaction_subtype', transaction_subtype,i_method_name);
837: ecx_debug.log(l_statement,'party_id', party_id,i_method_name);
838: ecx_debug.log(l_statement,'party_site_id', party_site_id,i_method_name);
839: ecx_debug.log(l_statement,'document_id', document_id,i_method_name);
840: ecx_debug.log(l_statement,'parameter1', parameter1,i_method_name);
841: ecx_debug.log(l_statement,'parameter2', parameter2,i_method_name);
842: ecx_debug.log(l_statement,'parameter3', parameter3,i_method_name);
843: ecx_debug.log(l_statement,'parameter4', parameter4,i_method_name);
844: ecx_debug.log(l_statement,'parameter5', parameter5,i_method_name);
837: ecx_debug.log(l_statement,'party_id', party_id,i_method_name);
838: ecx_debug.log(l_statement,'party_site_id', party_site_id,i_method_name);
839: ecx_debug.log(l_statement,'document_id', document_id,i_method_name);
840: ecx_debug.log(l_statement,'parameter1', parameter1,i_method_name);
841: ecx_debug.log(l_statement,'parameter2', parameter2,i_method_name);
842: ecx_debug.log(l_statement,'parameter3', parameter3,i_method_name);
843: ecx_debug.log(l_statement,'parameter4', parameter4,i_method_name);
844: ecx_debug.log(l_statement,'parameter5', parameter5,i_method_name);
845: ecx_debug.log(l_statement,'debug_mode',debug_mode,i_method_name);
838: ecx_debug.log(l_statement,'party_site_id', party_site_id,i_method_name);
839: ecx_debug.log(l_statement,'document_id', document_id,i_method_name);
840: ecx_debug.log(l_statement,'parameter1', parameter1,i_method_name);
841: ecx_debug.log(l_statement,'parameter2', parameter2,i_method_name);
842: ecx_debug.log(l_statement,'parameter3', parameter3,i_method_name);
843: ecx_debug.log(l_statement,'parameter4', parameter4,i_method_name);
844: ecx_debug.log(l_statement,'parameter5', parameter5,i_method_name);
845: ecx_debug.log(l_statement,'debug_mode',debug_mode,i_method_name);
846: end if;
839: ecx_debug.log(l_statement,'document_id', document_id,i_method_name);
840: ecx_debug.log(l_statement,'parameter1', parameter1,i_method_name);
841: ecx_debug.log(l_statement,'parameter2', parameter2,i_method_name);
842: ecx_debug.log(l_statement,'parameter3', parameter3,i_method_name);
843: ecx_debug.log(l_statement,'parameter4', parameter4,i_method_name);
844: ecx_debug.log(l_statement,'parameter5', parameter5,i_method_name);
845: ecx_debug.log(l_statement,'debug_mode',debug_mode,i_method_name);
846: end if;
847:
840: ecx_debug.log(l_statement,'parameter1', parameter1,i_method_name);
841: ecx_debug.log(l_statement,'parameter2', parameter2,i_method_name);
842: ecx_debug.log(l_statement,'parameter3', parameter3,i_method_name);
843: ecx_debug.log(l_statement,'parameter4', parameter4,i_method_name);
844: ecx_debug.log(l_statement,'parameter5', parameter5,i_method_name);
845: ecx_debug.log(l_statement,'debug_mode',debug_mode,i_method_name);
846: end if;
847:
848: /**
841: ecx_debug.log(l_statement,'parameter2', parameter2,i_method_name);
842: ecx_debug.log(l_statement,'parameter3', parameter3,i_method_name);
843: ecx_debug.log(l_statement,'parameter4', parameter4,i_method_name);
844: ecx_debug.log(l_statement,'parameter5', parameter5,i_method_name);
845: ecx_debug.log(l_statement,'debug_mode',debug_mode,i_method_name);
846: end if;
847:
848: /**
849: Initialize the ecx_utils.i_ret_code and i_errbuf variables;
855: i_count :=0;
856:
857: -- invoke trigger_outbound which will invoke outbound_trigger, getConfirmation and
858: -- get_delivery_attribs
859: ecx_debug.setErrorInfo(10,10,'ECX_TRIGGER_OUTBOUND');
860: trigger_outbound (transaction_type, transaction_subtype,
861: party_id, party_site_id,
862: document_id, ecx_utils.i_ret_code,
863: ecx_utils.i_errbuf, trigger_id,
869:
870: -- take appropriate action for destination_type
871: If p_destination_type = 'NONE' Then
872: /** No email Action required **/
873: ecx_debug.setErrorInfo(0,10,'ECX_DELIVERY_NOT_REQUIRED');
874: raise ecx_no_delivery_required;
875: Elsif p_destination_address is null
876: then
877: /** Email goes to Sys Admin***/
875: Elsif p_destination_address is null
876: then
877: /** Email goes to Sys Admin***/
878:
879: ecx_debug.setErrorInfo(1,30,'ECX_DESTINATION_ADDR_NULL',
880: 'p_party_site_id',
881: p_party_site_id,
882: 'p_source_code',
883: p_source_code);
920: retcode := ecx_utils.i_ret_code;
921: errmsg := ecx_utils.i_errbuf;
922:
923: if(l_statementEnabled) then
924: ecx_debug.log(l_statement,'trigger_id',trigger_id,i_method_name);
925: end if;
926: if(l_unexpectedEnabled) then
927: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
928: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
923: if(l_statementEnabled) then
924: ecx_debug.log(l_statement,'trigger_id',trigger_id,i_method_name);
925: end if;
926: if(l_unexpectedEnabled) then
927: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
928: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
929: ecx_utils.i_errparams),i_method_name); --MLS
930: end if;
931:
924: ecx_debug.log(l_statement,'trigger_id',trigger_id,i_method_name);
925: end if;
926: if(l_unexpectedEnabled) then
927: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
928: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
929: ecx_utils.i_errparams),i_method_name); --MLS
930: end if;
931:
932: if (l_procedureEnabled) then
929: ecx_utils.i_errparams),i_method_name); --MLS
930: end if;
931:
932: if (l_procedureEnabled) then
933: ecx_debug.pop(i_method_name);
934: end if;
935:
936: IF (ecx_logging_enabled ) THEN
937: ecx_debug.print_log;
933: ecx_debug.pop(i_method_name);
934: end if;
935:
936: IF (ecx_logging_enabled ) THEN
937: ecx_debug.print_log;
938: ecx_debug.disable_debug;
939: END IF;
940:
941: EXCEPTION
934: end if;
935:
936: IF (ecx_logging_enabled ) THEN
937: ecx_debug.print_log;
938: ecx_debug.disable_debug;
939: END IF;
940:
941: EXCEPTION
942: /* raised only by getConfirmation at this point */
943: WHEN ECX_NO_DELIVERY_REQUIRED THEN
944: retcode := ecx_utils.i_ret_code;
945: errmsg := ecx_utils.i_errbuf;
946: if(l_unexpectedEnabled) then
947: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
948: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SEND',
949: i_method_name);
950: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
951: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
944: retcode := ecx_utils.i_ret_code;
945: errmsg := ecx_utils.i_errbuf;
946: if(l_unexpectedEnabled) then
947: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
948: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SEND',
949: i_method_name);
950: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
951: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
952: ecx_utils.i_errparams),i_method_name); --MLS
946: if(l_unexpectedEnabled) then
947: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
948: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SEND',
949: i_method_name);
950: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
951: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
952: ecx_utils.i_errparams),i_method_name); --MLS
953: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
954: end if;
947: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
948: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SEND',
949: i_method_name);
950: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
951: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
952: ecx_utils.i_errparams),i_method_name); --MLS
953: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
954: end if;
955: if (l_procedureEnabled) then
949: i_method_name);
950: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
951: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
952: ecx_utils.i_errparams),i_method_name); --MLS
953: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
954: end if;
955: if (l_procedureEnabled) then
956: ecx_debug.pop(i_method_name);
957: end if;
952: ecx_utils.i_errparams),i_method_name); --MLS
953: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
954: end if;
955: if (l_procedureEnabled) then
956: ecx_debug.pop(i_method_name);
957: end if;
958:
959: IF (ecx_logging_enabled ) THEN
960: ecx_debug.print_log;
956: ecx_debug.pop(i_method_name);
957: end if;
958:
959: IF (ecx_logging_enabled ) THEN
960: ecx_debug.print_log;
961: ecx_debug.disable_debug;
962: END IF;
963:
964: ecx_errorlog.outbound_trigger
957: end if;
958:
959: IF (ecx_logging_enabled ) THEN
960: ecx_debug.print_log;
961: ecx_debug.disable_debug;
962: END IF;
963:
964: ecx_errorlog.outbound_trigger
965: (
977: WHEN ECX_UTILS.PROGRAM_EXIT THEN
978: retcode := ecx_utils.i_ret_code;
979: errmsg := ecx_utils.i_errbuf;
980: if(l_unexpectedEnabled) then
981: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
982: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf ||SQLERRM||' at ECX_DOCUMENT.SEND',
983: i_method_name);
984: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
985: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
978: retcode := ecx_utils.i_ret_code;
979: errmsg := ecx_utils.i_errbuf;
980: if(l_unexpectedEnabled) then
981: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
982: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf ||SQLERRM||' at ECX_DOCUMENT.SEND',
983: i_method_name);
984: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
985: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
986: ecx_utils.i_errparams),i_method_name); --MLS
980: if(l_unexpectedEnabled) then
981: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
982: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf ||SQLERRM||' at ECX_DOCUMENT.SEND',
983: i_method_name);
984: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
985: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
986: ecx_utils.i_errparams),i_method_name); --MLS
987: end if;
988: if (l_procedureEnabled) then
981: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
982: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf ||SQLERRM||' at ECX_DOCUMENT.SEND',
983: i_method_name);
984: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
985: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
986: ecx_utils.i_errparams),i_method_name); --MLS
987: end if;
988: if (l_procedureEnabled) then
989: ecx_debug.pop(i_method_name);
985: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
986: ecx_utils.i_errparams),i_method_name); --MLS
987: end if;
988: if (l_procedureEnabled) then
989: ecx_debug.pop(i_method_name);
990: end if;
991:
992: IF (ecx_logging_enabled ) THEN
993: ecx_debug.print_log;
989: ecx_debug.pop(i_method_name);
990: end if;
991:
992: IF (ecx_logging_enabled ) THEN
993: ecx_debug.print_log;
994: ecx_debug.disable_debug;
995: END IF;
996:
997:
990: end if;
991:
992: IF (ecx_logging_enabled ) THEN
993: ecx_debug.print_log;
994: ecx_debug.disable_debug;
995: END IF;
996:
997:
998: ecx_errorlog.outbound_trigger
1009: ecx_utils.i_errparams --MLS
1010: );
1011:
1012: WHEN OTHERS THEN
1013: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_DOCUMENT.SEND');
1014: retcode := ecx_utils.i_ret_code;
1015: errmsg := ecx_utils.i_errbuf;
1016: if(l_unexpectedEnabled) then
1017: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1013: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_DOCUMENT.SEND');
1014: retcode := ecx_utils.i_ret_code;
1015: errmsg := ecx_utils.i_errbuf;
1016: if(l_unexpectedEnabled) then
1017: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1018: ecx_debug.log(l_unexpected,'i_errmsg',SQLERRM||' at ECX_DOCUMENT.SEND',i_method_name);
1019: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name,i_method_name);
1020: ecx_debug.log(l_unexpected,'errmsg',errmsg,i_method_name,i_method_name);
1021: end if;
1014: retcode := ecx_utils.i_ret_code;
1015: errmsg := ecx_utils.i_errbuf;
1016: if(l_unexpectedEnabled) then
1017: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1018: ecx_debug.log(l_unexpected,'i_errmsg',SQLERRM||' at ECX_DOCUMENT.SEND',i_method_name);
1019: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name,i_method_name);
1020: ecx_debug.log(l_unexpected,'errmsg',errmsg,i_method_name,i_method_name);
1021: end if;
1022: if (l_procedureEnabled) then
1015: errmsg := ecx_utils.i_errbuf;
1016: if(l_unexpectedEnabled) then
1017: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1018: ecx_debug.log(l_unexpected,'i_errmsg',SQLERRM||' at ECX_DOCUMENT.SEND',i_method_name);
1019: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name,i_method_name);
1020: ecx_debug.log(l_unexpected,'errmsg',errmsg,i_method_name,i_method_name);
1021: end if;
1022: if (l_procedureEnabled) then
1023: ecx_debug.pop(i_method_name);
1016: if(l_unexpectedEnabled) then
1017: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1018: ecx_debug.log(l_unexpected,'i_errmsg',SQLERRM||' at ECX_DOCUMENT.SEND',i_method_name);
1019: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name,i_method_name);
1020: ecx_debug.log(l_unexpected,'errmsg',errmsg,i_method_name,i_method_name);
1021: end if;
1022: if (l_procedureEnabled) then
1023: ecx_debug.pop(i_method_name);
1024: end if;
1019: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name,i_method_name);
1020: ecx_debug.log(l_unexpected,'errmsg',errmsg,i_method_name,i_method_name);
1021: end if;
1022: if (l_procedureEnabled) then
1023: ecx_debug.pop(i_method_name);
1024: end if;
1025:
1026: IF (ecx_logging_enabled ) THEN
1027: ecx_debug.print_log;
1023: ecx_debug.pop(i_method_name);
1024: end if;
1025:
1026: IF (ecx_logging_enabled ) THEN
1027: ecx_debug.print_log;
1028: ecx_debug.disable_debug;
1029: END IF;
1030:
1031: ecx_errorlog.outbound_trigger
1024: end if;
1025:
1026: IF (ecx_logging_enabled ) THEN
1027: ecx_debug.print_log;
1028: ecx_debug.disable_debug;
1029: END IF;
1030:
1031: ecx_errorlog.outbound_trigger
1032: (
1104: logging_enabled varchar2(20);
1105: module varchar2(2000);
1106:
1107: begin
1108: --before calling this API we need to re-initialize ecx_debug.g_v_module_name
1109: ecx_debug.g_v_module_name :='ecx.plsql.';
1110: ecx_debug.module_enabled(transaction_type,transaction_subtype,document_id);
1111: g_instlmode := wf_core.translate('WF_INSTALL');
1112:
1105: module varchar2(2000);
1106:
1107: begin
1108: --before calling this API we need to re-initialize ecx_debug.g_v_module_name
1109: ecx_debug.g_v_module_name :='ecx.plsql.';
1110: ecx_debug.module_enabled(transaction_type,transaction_subtype,document_id);
1111: g_instlmode := wf_core.translate('WF_INSTALL');
1112:
1113: if(g_instlmode = 'EMBEDDED')
1106:
1107: begin
1108: --before calling this API we need to re-initialize ecx_debug.g_v_module_name
1109: ecx_debug.g_v_module_name :='ecx.plsql.';
1110: ecx_debug.module_enabled(transaction_type,transaction_subtype,document_id);
1111: g_instlmode := wf_core.translate('WF_INSTALL');
1112:
1113: if(g_instlmode = 'EMBEDDED')
1114: then
1114: then
1115: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
1116: fnd_profile.get('AFLOG_MODULE',module);
1117: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
1118: AND instr(lower(ecx_debug.g_v_module_name),rtrim(lower(module),'%'))> 0)
1119: OR module='%')
1120: AND FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) then
1121: ecx_logging_enabled := true;
1122: end if;
1156: END IF;
1157:
1158: p_aflog_module_name := p_aflog_module_name||'.log';
1159:
1160: ecx_debug.enable_debug_new(debug_mode, ecx_utils.g_logdir,ecx_utils.g_logfile, p_aflog_module_name);
1161: END IF;
1162:
1163: /* Assign local variables with the ecx_debug global variables*/
1164: l_procedure := ecx_debug.g_procedure;
1159:
1160: ecx_debug.enable_debug_new(debug_mode, ecx_utils.g_logdir,ecx_utils.g_logfile, p_aflog_module_name);
1161: END IF;
1162:
1163: /* Assign local variables with the ecx_debug global variables*/
1164: l_procedure := ecx_debug.g_procedure;
1165: l_statement := ecx_debug.g_statement;
1166: l_unexpected := ecx_debug.g_unexpected;
1167: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1160: ecx_debug.enable_debug_new(debug_mode, ecx_utils.g_logdir,ecx_utils.g_logfile, p_aflog_module_name);
1161: END IF;
1162:
1163: /* Assign local variables with the ecx_debug global variables*/
1164: l_procedure := ecx_debug.g_procedure;
1165: l_statement := ecx_debug.g_statement;
1166: l_unexpected := ecx_debug.g_unexpected;
1167: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1168: l_statementEnabled := ecx_debug.g_statementEnabled;
1161: END IF;
1162:
1163: /* Assign local variables with the ecx_debug global variables*/
1164: l_procedure := ecx_debug.g_procedure;
1165: l_statement := ecx_debug.g_statement;
1166: l_unexpected := ecx_debug.g_unexpected;
1167: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1168: l_statementEnabled := ecx_debug.g_statementEnabled;
1169: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1162:
1163: /* Assign local variables with the ecx_debug global variables*/
1164: l_procedure := ecx_debug.g_procedure;
1165: l_statement := ecx_debug.g_statement;
1166: l_unexpected := ecx_debug.g_unexpected;
1167: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1168: l_statementEnabled := ecx_debug.g_statementEnabled;
1169: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1170:
1163: /* Assign local variables with the ecx_debug global variables*/
1164: l_procedure := ecx_debug.g_procedure;
1165: l_statement := ecx_debug.g_statement;
1166: l_unexpected := ecx_debug.g_unexpected;
1167: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1168: l_statementEnabled := ecx_debug.g_statementEnabled;
1169: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1170:
1171: if (l_procedureEnabled) then
1164: l_procedure := ecx_debug.g_procedure;
1165: l_statement := ecx_debug.g_statement;
1166: l_unexpected := ecx_debug.g_unexpected;
1167: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1168: l_statementEnabled := ecx_debug.g_statementEnabled;
1169: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1170:
1171: if (l_procedureEnabled) then
1172: ecx_debug.push(i_method_name);
1165: l_statement := ecx_debug.g_statement;
1166: l_unexpected := ecx_debug.g_unexpected;
1167: l_procedureEnabled := ecx_debug.g_procedureEnabled;
1168: l_statementEnabled := ecx_debug.g_statementEnabled;
1169: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1170:
1171: if (l_procedureEnabled) then
1172: ecx_debug.push(i_method_name);
1173: end if;
1168: l_statementEnabled := ecx_debug.g_statementEnabled;
1169: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
1170:
1171: if (l_procedureEnabled) then
1172: ecx_debug.push(i_method_name);
1173: end if;
1174:
1175: if(l_statementEnabled) then
1176: ecx_debug.log(l_statement,'transaction_type', transaction_type,i_method_name);
1172: ecx_debug.push(i_method_name);
1173: end if;
1174:
1175: if(l_statementEnabled) then
1176: ecx_debug.log(l_statement,'transaction_type', transaction_type,i_method_name);
1177: ecx_debug.log(l_statement,'transaction_subtype', transaction_subtype,i_method_name);
1178: ecx_debug.log(l_statement,'party_id', party_id,i_method_name);
1179: ecx_debug.log(l_statement,'party_site_id', party_site_id,i_method_name);
1180: ecx_debug.log(l_statement,'document_id', document_id,i_method_name);
1173: end if;
1174:
1175: if(l_statementEnabled) then
1176: ecx_debug.log(l_statement,'transaction_type', transaction_type,i_method_name);
1177: ecx_debug.log(l_statement,'transaction_subtype', transaction_subtype,i_method_name);
1178: ecx_debug.log(l_statement,'party_id', party_id,i_method_name);
1179: ecx_debug.log(l_statement,'party_site_id', party_site_id,i_method_name);
1180: ecx_debug.log(l_statement,'document_id', document_id,i_method_name);
1181: ecx_debug.log(l_statement,'party_type', party_type,i_method_name);
1174:
1175: if(l_statementEnabled) then
1176: ecx_debug.log(l_statement,'transaction_type', transaction_type,i_method_name);
1177: ecx_debug.log(l_statement,'transaction_subtype', transaction_subtype,i_method_name);
1178: ecx_debug.log(l_statement,'party_id', party_id,i_method_name);
1179: ecx_debug.log(l_statement,'party_site_id', party_site_id,i_method_name);
1180: ecx_debug.log(l_statement,'document_id', document_id,i_method_name);
1181: ecx_debug.log(l_statement,'party_type', party_type,i_method_name);
1182: ecx_debug.log(l_statement,'debug_mode',debug_mode,i_method_name);
1175: if(l_statementEnabled) then
1176: ecx_debug.log(l_statement,'transaction_type', transaction_type,i_method_name);
1177: ecx_debug.log(l_statement,'transaction_subtype', transaction_subtype,i_method_name);
1178: ecx_debug.log(l_statement,'party_id', party_id,i_method_name);
1179: ecx_debug.log(l_statement,'party_site_id', party_site_id,i_method_name);
1180: ecx_debug.log(l_statement,'document_id', document_id,i_method_name);
1181: ecx_debug.log(l_statement,'party_type', party_type,i_method_name);
1182: ecx_debug.log(l_statement,'debug_mode',debug_mode,i_method_name);
1183: end if;
1176: ecx_debug.log(l_statement,'transaction_type', transaction_type,i_method_name);
1177: ecx_debug.log(l_statement,'transaction_subtype', transaction_subtype,i_method_name);
1178: ecx_debug.log(l_statement,'party_id', party_id,i_method_name);
1179: ecx_debug.log(l_statement,'party_site_id', party_site_id,i_method_name);
1180: ecx_debug.log(l_statement,'document_id', document_id,i_method_name);
1181: ecx_debug.log(l_statement,'party_type', party_type,i_method_name);
1182: ecx_debug.log(l_statement,'debug_mode',debug_mode,i_method_name);
1183: end if;
1184:
1177: ecx_debug.log(l_statement,'transaction_subtype', transaction_subtype,i_method_name);
1178: ecx_debug.log(l_statement,'party_id', party_id,i_method_name);
1179: ecx_debug.log(l_statement,'party_site_id', party_site_id,i_method_name);
1180: ecx_debug.log(l_statement,'document_id', document_id,i_method_name);
1181: ecx_debug.log(l_statement,'party_type', party_type,i_method_name);
1182: ecx_debug.log(l_statement,'debug_mode',debug_mode,i_method_name);
1183: end if;
1184:
1185: /** check for the Event Object. If null , initialize it **/
1178: ecx_debug.log(l_statement,'party_id', party_id,i_method_name);
1179: ecx_debug.log(l_statement,'party_site_id', party_site_id,i_method_name);
1180: ecx_debug.log(l_statement,'document_id', document_id,i_method_name);
1181: ecx_debug.log(l_statement,'party_type', party_type,i_method_name);
1182: ecx_debug.log(l_statement,'debug_mode',debug_mode,i_method_name);
1183: end if;
1184:
1185: /** check for the Event Object. If null , initialize it **/
1186: if ecx_utils.g_event is null
1193: then
1194: for i in i_parameterList.FIRST..i_parameterList.LAST
1195: loop
1196: i_parameter := i_parameterList(i);
1197: ecx_debug.log(l_statement,i_parameter.getName(),i_parameter.getValue(),i_method_name);
1198: end loop;
1199: end if;
1200: end if;
1201:
1208: ecx_utils.i_errparams := null;
1209:
1210: -- make a new procedure which will invoke outbound_trigger, getConfirmation and
1211: -- get_delivery_attribs
1212: ecx_debug.setErrorInfo(10,10,'ECX_TRIGGER_OUTBOUND');
1213: trigger_outbound (transaction_type, transaction_subtype,
1214: party_id, party_site_id,
1215: document_id, ecx_utils.i_ret_code,
1216: ecx_utils.i_errbuf, trigger_id,
1222:
1223: -- take appropriate action for destination_type
1224: If p_destination_type = 'NONE' Then
1225: /** No email Action required **/
1226: ecx_debug.setErrorInfo(0,10,'ECX_DELIVERY_NOT_REQUIRED');
1227: raise ecx_no_delivery_required;
1228: Elsif p_destination_address is null
1229: then
1230: ecx_debug.setErrorInfo(1,30,'ECX_DESTINATION_ADDR_NULL',
1226: ecx_debug.setErrorInfo(0,10,'ECX_DELIVERY_NOT_REQUIRED');
1227: raise ecx_no_delivery_required;
1228: Elsif p_destination_address is null
1229: then
1230: ecx_debug.setErrorInfo(1,30,'ECX_DESTINATION_ADDR_NULL',
1231: 'p_party_site_id',
1232: p_party_site_id,
1233: 'p_source_code',
1234: p_source_code);
1267: retcode := ecx_utils.i_ret_code;
1268: errmsg := ecx_utils.i_errbuf;
1269:
1270: if(l_unexpectedEnabled) then
1271: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1272: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1273: ecx_utils.i_errparams),i_method_name); --MLS
1274: end if;
1275: if(l_statementEnabled) then
1268: errmsg := ecx_utils.i_errbuf;
1269:
1270: if(l_unexpectedEnabled) then
1271: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1272: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1273: ecx_utils.i_errparams),i_method_name); --MLS
1274: end if;
1275: if(l_statementEnabled) then
1276: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
1272: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1273: ecx_utils.i_errparams),i_method_name); --MLS
1274: end if;
1275: if(l_statementEnabled) then
1276: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
1277: end if;
1278:
1279: if (l_procedureEnabled) then
1280: ecx_debug.pop(i_method_name);
1276: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
1277: end if;
1278:
1279: if (l_procedureEnabled) then
1280: ecx_debug.pop(i_method_name);
1281: end if;
1282:
1283: IF (ecx_logging_enabled ) THEN
1284: ecx_debug.print_log;
1280: ecx_debug.pop(i_method_name);
1281: end if;
1282:
1283: IF (ecx_logging_enabled ) THEN
1284: ecx_debug.print_log;
1285: ecx_debug.disable_debug;
1286: END IF;
1287:
1288:
1281: end if;
1282:
1283: IF (ecx_logging_enabled ) THEN
1284: ecx_debug.print_log;
1285: ecx_debug.disable_debug;
1286: END IF;
1287:
1288:
1289: EXCEPTION
1291: WHEN ECX_NO_DELIVERY_REQUIRED THEN
1292: retcode := ecx_utils.i_ret_code;
1293: errmsg := ecx_utils.i_errbuf;
1294: if(l_unexpectedEnabled) then
1295: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1296: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1297: i_method_name);
1298: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1299: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1292: retcode := ecx_utils.i_ret_code;
1293: errmsg := ecx_utils.i_errbuf;
1294: if(l_unexpectedEnabled) then
1295: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1296: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1297: i_method_name);
1298: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1299: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1300: ecx_utils.i_errparams),i_method_name); --MLS
1294: if(l_unexpectedEnabled) then
1295: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1296: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1297: i_method_name);
1298: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1299: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1300: ecx_utils.i_errparams),i_method_name); --MLS
1301: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1302: end if;
1295: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1296: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1297: i_method_name);
1298: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1299: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1300: ecx_utils.i_errparams),i_method_name); --MLS
1301: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1302: end if;
1303: if (l_procedureEnabled) then
1297: i_method_name);
1298: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1299: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1300: ecx_utils.i_errparams),i_method_name); --MLS
1301: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1302: end if;
1303: if (l_procedureEnabled) then
1304: ecx_debug.pop(i_method_name);
1305: end if;
1300: ecx_utils.i_errparams),i_method_name); --MLS
1301: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1302: end if;
1303: if (l_procedureEnabled) then
1304: ecx_debug.pop(i_method_name);
1305: end if;
1306:
1307: IF (ecx_logging_enabled ) THEN
1308: ecx_debug.print_log;
1304: ecx_debug.pop(i_method_name);
1305: end if;
1306:
1307: IF (ecx_logging_enabled ) THEN
1308: ecx_debug.print_log;
1309: ecx_debug.disable_debug;
1310: END IF;
1311:
1312: ecx_errorlog.outbound_trigger
1305: end if;
1306:
1307: IF (ecx_logging_enabled ) THEN
1308: ecx_debug.print_log;
1309: ecx_debug.disable_debug;
1310: END IF;
1311:
1312: ecx_errorlog.outbound_trigger
1313: (
1325: WHEN ECX_TRANSACTION_NOT_DEFINED THEN
1326: retcode := ecx_utils.i_ret_code;
1327: errmsg := ecx_utils.i_errbuf;
1328: if(l_unexpectedEnabled) then
1329: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1330: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1331: i_method_name);
1332: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1333: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1326: retcode := ecx_utils.i_ret_code;
1327: errmsg := ecx_utils.i_errbuf;
1328: if(l_unexpectedEnabled) then
1329: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1330: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1331: i_method_name);
1332: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1333: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1334: ecx_utils.i_errparams),i_method_name); --MLS
1328: if(l_unexpectedEnabled) then
1329: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1330: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1331: i_method_name);
1332: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1333: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1334: ecx_utils.i_errparams),i_method_name); --MLS
1335: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1336: end if;
1329: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1330: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1331: i_method_name);
1332: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1333: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1334: ecx_utils.i_errparams),i_method_name); --MLS
1335: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1336: end if;
1337: if (l_procedureEnabled) then
1331: i_method_name);
1332: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1333: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1334: ecx_utils.i_errparams),i_method_name); --MLS
1335: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1336: end if;
1337: if (l_procedureEnabled) then
1338: ecx_debug.pop(i_method_name);
1339: end if;
1334: ecx_utils.i_errparams),i_method_name); --MLS
1335: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1336: end if;
1337: if (l_procedureEnabled) then
1338: ecx_debug.pop(i_method_name);
1339: end if;
1340:
1341: IF (ecx_logging_enabled ) THEN
1342: ecx_debug.print_log;
1338: ecx_debug.pop(i_method_name);
1339: end if;
1340:
1341: IF (ecx_logging_enabled ) THEN
1342: ecx_debug.print_log;
1343: ecx_debug.disable_debug;
1344: END IF;
1345:
1346: ecx_errorlog.outbound_trigger
1339: end if;
1340:
1341: IF (ecx_logging_enabled ) THEN
1342: ecx_debug.print_log;
1343: ecx_debug.disable_debug;
1344: END IF;
1345:
1346: ecx_errorlog.outbound_trigger
1347: (
1361: retcode := ecx_utils.i_ret_code;
1362: errmsg := ecx_utils.i_errbuf;
1363:
1364: if(l_unexpectedEnabled) then
1365: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1366: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1367: i_method_name);
1368: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1369: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1362: errmsg := ecx_utils.i_errbuf;
1363:
1364: if(l_unexpectedEnabled) then
1365: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1366: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1367: i_method_name);
1368: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1369: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1370: ecx_utils.i_errparams),i_method_name); --MLS
1364: if(l_unexpectedEnabled) then
1365: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1366: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1367: i_method_name);
1368: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1369: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1370: ecx_utils.i_errparams),i_method_name); --MLS
1371: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1372: end if;
1365: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1366: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1367: i_method_name);
1368: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1369: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1370: ecx_utils.i_errparams),i_method_name); --MLS
1371: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1372: end if;
1373: if (l_procedureEnabled) then
1367: i_method_name);
1368: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1369: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1370: ecx_utils.i_errparams),i_method_name); --MLS
1371: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1372: end if;
1373: if (l_procedureEnabled) then
1374: ecx_debug.pop(i_method_name);
1375: end if;
1370: ecx_utils.i_errparams),i_method_name); --MLS
1371: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1372: end if;
1373: if (l_procedureEnabled) then
1374: ecx_debug.pop(i_method_name);
1375: end if;
1376:
1377: IF (ecx_logging_enabled ) THEN
1378: ecx_debug.print_log;
1374: ecx_debug.pop(i_method_name);
1375: end if;
1376:
1377: IF (ecx_logging_enabled ) THEN
1378: ecx_debug.print_log;
1379: ecx_debug.disable_debug;
1380: END IF;
1381:
1382:
1375: end if;
1376:
1377: IF (ecx_logging_enabled ) THEN
1378: ecx_debug.print_log;
1379: ecx_debug.disable_debug;
1380: END IF;
1381:
1382:
1383: ecx_errorlog.outbound_trigger
1398: retcode := ecx_utils.i_ret_code;
1399: errmsg := ecx_utils.i_errbuf;
1400:
1401: if(l_unexpectedEnabled) then
1402: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1403: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1404: i_method_name);
1405: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1406: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1399: errmsg := ecx_utils.i_errbuf;
1400:
1401: if(l_unexpectedEnabled) then
1402: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1403: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1404: i_method_name);
1405: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1406: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1407: ecx_utils.i_errparams),i_method_name); --MLS
1401: if(l_unexpectedEnabled) then
1402: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1403: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1404: i_method_name);
1405: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1406: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1407: ecx_utils.i_errparams),i_method_name); --MLS
1408: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1409: end if;
1402: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1403: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1404: i_method_name);
1405: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1406: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1407: ecx_utils.i_errparams),i_method_name); --MLS
1408: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1409: end if;
1410: if (l_procedureEnabled) then
1404: i_method_name);
1405: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1406: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1407: ecx_utils.i_errparams),i_method_name); --MLS
1408: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1409: end if;
1410: if (l_procedureEnabled) then
1411: ecx_debug.pop(i_method_name);
1412: end if;
1407: ecx_utils.i_errparams),i_method_name); --MLS
1408: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1409: end if;
1410: if (l_procedureEnabled) then
1411: ecx_debug.pop(i_method_name);
1412: end if;
1413:
1414: IF (ecx_logging_enabled ) THEN
1415: ecx_debug.print_log;
1411: ecx_debug.pop(i_method_name);
1412: end if;
1413:
1414: IF (ecx_logging_enabled ) THEN
1415: ecx_debug.print_log;
1416: ecx_debug.disable_debug;
1417: END IF;
1418:
1419: ecx_errorlog.outbound_trigger
1412: end if;
1413:
1414: IF (ecx_logging_enabled ) THEN
1415: ecx_debug.print_log;
1416: ecx_debug.disable_debug;
1417: END IF;
1418:
1419: ecx_errorlog.outbound_trigger
1420: (
1433: retcode := ecx_utils.i_ret_code;
1434: errmsg := ecx_utils.i_errbuf;
1435:
1436: if(l_unexpectedEnabled) then
1437: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1438: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1439: i_method_name);
1440: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1441: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1434: errmsg := ecx_utils.i_errbuf;
1435:
1436: if(l_unexpectedEnabled) then
1437: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1438: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1439: i_method_name);
1440: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1441: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1442: ecx_utils.i_errparams),i_method_name); --MLS
1436: if(l_unexpectedEnabled) then
1437: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1438: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1439: i_method_name);
1440: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1441: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1442: ecx_utils.i_errparams),i_method_name); --MLS
1443: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1444: end if;
1437: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1438: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1439: i_method_name);
1440: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1441: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1442: ecx_utils.i_errparams),i_method_name); --MLS
1443: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1444: end if;
1445: if (l_procedureEnabled) then
1439: i_method_name);
1440: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1441: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1442: ecx_utils.i_errparams),i_method_name); --MLS
1443: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1444: end if;
1445: if (l_procedureEnabled) then
1446: ecx_debug.pop(i_method_name);
1447: end if;
1442: ecx_utils.i_errparams),i_method_name); --MLS
1443: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1444: end if;
1445: if (l_procedureEnabled) then
1446: ecx_debug.pop(i_method_name);
1447: end if;
1448:
1449: IF (ecx_logging_enabled ) THEN
1450: ecx_debug.print_log;
1446: ecx_debug.pop(i_method_name);
1447: end if;
1448:
1449: IF (ecx_logging_enabled ) THEN
1450: ecx_debug.print_log;
1451: ecx_debug.disable_debug;
1452: END IF;
1453:
1454: ecx_errorlog.outbound_trigger
1447: end if;
1448:
1449: IF (ecx_logging_enabled ) THEN
1450: ecx_debug.print_log;
1451: ecx_debug.disable_debug;
1452: END IF;
1453:
1454: ecx_errorlog.outbound_trigger
1455: (
1464: ecx_utils.i_errbuf,
1465: ecx_utils.i_errparams --MLS
1466: );
1467: WHEN OTHERS THEN
1468: ecx_debug.setErrorInfo(2,30, SQLERRM||' - ECX_DOCUMENT.SENDDIRECT');
1469: retcode := ecx_utils.i_ret_code;
1470: errmsg := ecx_utils.i_errbuf;
1471: if(l_unexpectedEnabled) then
1472: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1468: ecx_debug.setErrorInfo(2,30, SQLERRM||' - ECX_DOCUMENT.SENDDIRECT');
1469: retcode := ecx_utils.i_ret_code;
1470: errmsg := ecx_utils.i_errbuf;
1471: if(l_unexpectedEnabled) then
1472: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1473: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1474: i_method_name);
1475: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1476: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1469: retcode := ecx_utils.i_ret_code;
1470: errmsg := ecx_utils.i_errbuf;
1471: if(l_unexpectedEnabled) then
1472: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1473: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1474: i_method_name);
1475: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1476: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1477: ecx_utils.i_errparams),i_method_name); --MLS
1471: if(l_unexpectedEnabled) then
1472: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1473: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1474: i_method_name);
1475: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1476: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1477: ecx_utils.i_errparams),i_method_name); --MLS
1478: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1479: end if;
1472: ecx_debug.log(l_unexpected,'i_ret_code',ecx_utils.i_ret_code,i_method_name);
1473: ecx_debug.log(l_unexpected,'i_errmsg',ecx_utils.i_errbuf || ' at ECX_DOCUMENT.SENDDIRECT',
1474: i_method_name);
1475: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1476: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1477: ecx_utils.i_errparams),i_method_name); --MLS
1478: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1479: end if;
1480: if (l_procedureEnabled) then
1474: i_method_name);
1475: ecx_debug.log(l_unexpected,'retcode',retcode,i_method_name);
1476: ecx_debug.log(l_unexpected,'errmsg',ecx_debug.getMessage(errmsg,
1477: ecx_utils.i_errparams),i_method_name); --MLS
1478: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1479: end if;
1480: if (l_procedureEnabled) then
1481: ecx_debug.pop(i_method_name);
1482: end if;
1477: ecx_utils.i_errparams),i_method_name); --MLS
1478: ecx_debug.log(l_unexpected,'errtype',ecx_utils.error_type,i_method_name);
1479: end if;
1480: if (l_procedureEnabled) then
1481: ecx_debug.pop(i_method_name);
1482: end if;
1483:
1484: IF (ecx_logging_enabled ) THEN
1485: ecx_debug.print_log;
1481: ecx_debug.pop(i_method_name);
1482: end if;
1483:
1484: IF (ecx_logging_enabled ) THEN
1485: ecx_debug.print_log;
1486: ecx_debug.disable_debug;
1487: END IF;
1488:
1489: ecx_errorlog.outbound_trigger
1482: end if;
1483:
1484: IF (ecx_logging_enabled ) THEN
1485: ecx_debug.print_log;
1486: ecx_debug.disable_debug;
1487: END IF;
1488:
1489: ecx_errorlog.outbound_trigger
1490: (
1553: );
1554: -- take appropriate action for destination_type
1555: If p_destination_type = 'NONE' Then
1556: /** No email Action required **/
1557: ecx_debug.setErrorInfo(0,10,'ECX_DELIVERY_NOT_REQUIRED');
1558: resultout := FALSE;
1559: raise ecx_no_delivery_required;
1560: Elsif p_destination_address is null and p_destination_type not in ('IAS', 'ITG03')
1561: then
1558: resultout := FALSE;
1559: raise ecx_no_delivery_required;
1560: Elsif p_destination_address is null and p_destination_type not in ('IAS', 'ITG03')
1561: then
1562: ecx_debug.setErrorInfo(1,30,'ECX_DESTINATION_ADDR_NULL',
1563: 'p_party_site_id',
1564: party_site_id,
1565: 'p_source_code',
1566: p_source_code);
1587: resultout := FALSE;
1588: raise ecx_utils.program_exit;
1589: end;
1590: -- Changed for MLS
1591: ecx_debug.setErrorInfo(0,10,'ECX_SUCCESSFUL_TP_LKP');
1592: errmsg:=ecx_utils.i_errbuf;
1593: retcode :=ecx_utils.i_ret_code;
1594:
1595: exception
1662:
1663: -- take appropriate action for destination_type
1664: If p_destination_type = 'NONE' Then
1665: /** No email Action required **/
1666: ecx_debug.setErrorInfo(0,10,'ECX_DELIVERY_NOT_REQUIRED');
1667: raise ecx_no_delivery_required;
1668: Elsif p_destination_address is null
1669: then
1670: ecx_debug.setErrorInfo(1,30,'ECX_DESTINATION_ADDR_NULL',
1666: ecx_debug.setErrorInfo(0,10,'ECX_DELIVERY_NOT_REQUIRED');
1667: raise ecx_no_delivery_required;
1668: Elsif p_destination_address is null
1669: then
1670: ecx_debug.setErrorInfo(1,30,'ECX_DESTINATION_ADDR_NULL',
1671: 'p_party_site_id',
1672: party_site_id,
1673: 'p_source_code',
1674: source_code);
1675: raise ecx_delivery_setup_error;
1676: end if;
1677:
1678: --Changed for MLS
1679: ecx_debug.setErrorInfo(0,10,'ECX_SUCCESSFUL_TP_LKP');
1680: retcode:=ecx_utils.i_ret_code;
1681: errmsg:=ecx_utils.i_errbuf;
1682: exception
1683: when ecx_no_party_setup then
1743: queue_name,
1744: tp_header_id
1745: );
1746: --Changed for MLS
1747: ecx_debug.setErrorInfo(0,10,'ECX_SUCCESSFUL_TP_LKP');
1748: retcode:=ecx_utils.i_ret_code;
1749: retmsg:=ecx_utils.i_errbuf;
1750: exception
1751: when ecx_no_party_setup then
1851: --- ate ecx_external_retry table before enqueueing
1852:
1853: If ( i_msgid is NULL ) Then
1854: -- MLS
1855: ecx_debug.setErrorInfo(1,30,'ECX_MSGID_NOT_NULL');
1856: retcode := ecx_utils.i_ret_code;
1857: errmsg := ecx_utils.i_errbuf;
1858: return;
1859: End If;
1862: Fetch c1 into c1_rec;
1863:
1864: If c1%NOTFOUND Then
1865: -- MLS
1866: ecx_debug.setErrorInfo(1,30,'ECX_MSGID_NOT_FOUND','p_msgid',i_msgid);
1867: retcode := ecx_utils.i_ret_code;
1868: errmsg := ecx_utils.i_errbuf;
1869: Close c1;
1870: return;
1876: c1_rec.transaction_type is NULL OR
1877: c1_rec.transaction_subtype is NULL )
1878: Then
1879: -- MLS
1880: ecx_debug.setErrorInfo(1,30,'ECX_INVALID_TXN_PARAMS');
1881: retcode := ecx_utils.i_ret_code;
1882: errmsg := ecx_utils.i_errbuf;
1883: return;
1884: End IF;
2004: i_from_agt.setsystem(i_system);
2005: i_event.setFromAgent(i_from_agt);
2006: wf_event.send(i_event);
2007: -- MLS
2008: ecx_debug.setErrorInfo(0,10,'ECX_RESEND_TRIGGERED');
2009: retcode := ecx_utils.i_ret_code;
2010: errmsg := ecx_utils.i_errbuf;
2011:
2012: ecx_errorlog.outbound_log(i_event);
2023:
2024: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)
2025: then
2026: -- MLS
2027: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_DOCUMENT.RESEND');
2028: retcode := ecx_utils.i_ret_code;
2029: errmsg := ecx_utils.i_errbuf;
2030: else
2031: -- MLS
2028: retcode := ecx_utils.i_ret_code;
2029: errmsg := ecx_utils.i_errbuf;
2030: else
2031: -- MLS
2032: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,
2033: ecx_out_wf_qh.retmsg);
2034: retcode := ecx_utils.i_ret_code;
2035: errmsg := ecx_utils.i_errbuf;
2036: end if;
2078:
2079:
2080: exception
2081: when no_data_found then
2082: ecx_debug.setErrorInfo(2,30,'ECX_CONFIRM_STATUS_NOT_FOUND');
2083: raise ecx_utils.program_exit;
2084:
2085:
2086: when too_many_rows then
2083: raise ecx_utils.program_exit;
2084:
2085:
2086: when too_many_rows then
2087: ecx_debug.setErrorInfo(2,30,'ECX_PARTY_TYPE_NOT_SET ');
2088: raise ecx_utils.program_exit;
2089:
2090:
2091: when others then
2088: raise ecx_utils.program_exit;
2089:
2090:
2091: when others then
2092: ecx_debug.setErrorInfo(2,30, SQLERRM ||'- ECX_DOCUMENT.getConfirmationstatus');
2093: raise ecx_utils.program_exit;
2094: end getConfirmationstatus;
2095:
2096: end ecx_document;