eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ECX_INBOUND_LISTENER_QH dependencies on ECXMSG

Line 50: x_ecxmsg system.ecxmsg;

46: x_msgid RAW(16);
47: x_clob clob;
48: no_messages exception;
49: pragma exception_init (no_messages, -25228);
50: x_ecxmsg system.ecxmsg;
51: x_sys_guid RAW(16);
52: x_sys_name VARCHAR2(30);
53: x_from_agt wf_agent_t := wf_agent_t(null,null);
54: x_to_agt wf_agent_t := wf_agent_t(null,null);

Line 100: payload => x_ecxmsg,

96: (
97: queue_name => x_queue_name,
98: dequeue_options => x_dequeue_options,
99: message_properties => x_message_properties,
100: payload => x_ecxmsg,
101: msgid => x_msgid
102: );
103:
104: --- bug#2016123. If the transaction subtype is null ,

Line 106: if x_ecxmsg.transaction_subtype is null

102: );
103:
104: --- bug#2016123. If the transaction subtype is null ,
105: --- default it to the transaction_type
106: if x_ecxmsg.transaction_subtype is null
107: then
108: x_ecxmsg.transaction_subtype := x_ecxmsg.transaction_type;
109: end if;
110:

Line 108: x_ecxmsg.transaction_subtype := x_ecxmsg.transaction_type;

104: --- bug#2016123. If the transaction subtype is null ,
105: --- default it to the transaction_type
106: if x_ecxmsg.transaction_subtype is null
107: then
108: x_ecxmsg.transaction_subtype := x_ecxmsg.transaction_type;
109: end if;
110:
111: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
112: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'after dequeue');

Line 116: 'Message Type: ' || x_ecxmsg.message_type);

112: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'after dequeue');
113: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
114: 'Message Id: ' || x_msgid);
115: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
116: 'Message Type: ' || x_ecxmsg.message_type);
117: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
118: 'Message Standard: ' || x_ecxmsg.message_standard);
119: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
120: 'transaction type: ' || x_ecxmsg.transaction_type);

Line 118: 'Message Standard: ' || x_ecxmsg.message_standard);

114: 'Message Id: ' || x_msgid);
115: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
116: 'Message Type: ' || x_ecxmsg.message_type);
117: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
118: 'Message Standard: ' || x_ecxmsg.message_standard);
119: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
120: 'transaction type: ' || x_ecxmsg.transaction_type);
121: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
122: 'transaction subtype: '|| x_ecxmsg.transaction_subtype);

Line 120: 'transaction type: ' || x_ecxmsg.transaction_type);

116: 'Message Type: ' || x_ecxmsg.message_type);
117: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
118: 'Message Standard: ' || x_ecxmsg.message_standard);
119: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
120: 'transaction type: ' || x_ecxmsg.transaction_type);
121: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
122: 'transaction subtype: '|| x_ecxmsg.transaction_subtype);
123: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
124: ' Defaulted transaction subtype: '|| x_ecxmsg.transaction_subtype);

Line 122: 'transaction subtype: '|| x_ecxmsg.transaction_subtype);

118: 'Message Standard: ' || x_ecxmsg.message_standard);
119: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
120: 'transaction type: ' || x_ecxmsg.transaction_type);
121: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
122: 'transaction subtype: '|| x_ecxmsg.transaction_subtype);
123: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
124: ' Defaulted transaction subtype: '|| x_ecxmsg.transaction_subtype);
125: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
126: 'Party Site Id: '|| x_ecxmsg.party_site_id);

Line 124: ' Defaulted transaction subtype: '|| x_ecxmsg.transaction_subtype);

120: 'transaction type: ' || x_ecxmsg.transaction_type);
121: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
122: 'transaction subtype: '|| x_ecxmsg.transaction_subtype);
123: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
124: ' Defaulted transaction subtype: '|| x_ecxmsg.transaction_subtype);
125: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
126: 'Party Site Id: '|| x_ecxmsg.party_site_id);
127: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
128: 'From: '|| x_ecxmsg.attribute1);

Line 126: 'Party Site Id: '|| x_ecxmsg.party_site_id);

122: 'transaction subtype: '|| x_ecxmsg.transaction_subtype);
123: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
124: ' Defaulted transaction subtype: '|| x_ecxmsg.transaction_subtype);
125: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
126: 'Party Site Id: '|| x_ecxmsg.party_site_id);
127: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
128: 'From: '|| x_ecxmsg.attribute1);
129: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
130: 'Final Destination: '|| x_ecxmsg.attribute3);

Line 128: 'From: '|| x_ecxmsg.attribute1);

124: ' Defaulted transaction subtype: '|| x_ecxmsg.transaction_subtype);
125: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
126: 'Party Site Id: '|| x_ecxmsg.party_site_id);
127: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
128: 'From: '|| x_ecxmsg.attribute1);
129: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
130: 'Final Destination: '|| x_ecxmsg.attribute3);
131: end if;
132:

Line 130: 'Final Destination: '|| x_ecxmsg.attribute3);

126: 'Party Site Id: '|| x_ecxmsg.party_site_id);
127: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
128: 'From: '|| x_ecxmsg.attribute1);
129: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
130: 'Final Destination: '|| x_ecxmsg.attribute3);
131: end if;
132:
133: x_from_agt := wf_agent_t(substr(x_ecxmsg.party_site_id,1,30),
134: 'EXTERNAL_PARTY_SITEID');

Line 133: x_from_agt := wf_agent_t(substr(x_ecxmsg.party_site_id,1,30),

129: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
130: 'Final Destination: '|| x_ecxmsg.attribute3);
131: end if;
132:
133: x_from_agt := wf_agent_t(substr(x_ecxmsg.party_site_id,1,30),
134: 'EXTERNAL_PARTY_SITEID');
135:
136: wf_event_t.initialize(p_event);
137:

Line 139: get_event_name(x_ecxmsg.attribute4, p_event.event_name);

135:
136: wf_event_t.initialize(p_event);
137:
138: -- get the correct event name
139: get_event_name(x_ecxmsg.attribute4, p_event.event_name);
140: p_event.priority := 1;
141: p_event.event_key := x_msgid;
142: p_event.from_agent := x_from_agt ;
143: p_event.to_agent := x_to_agt ;

Line 158: l_input_string => x_ecxmsg.password,

154: end if;
155:
156: --- Encrypt the password
157: ecx_obfuscate.ecx_data_encrypt(
158: l_input_string => x_ecxmsg.password,
159: l_output_string => encrypt_password,
160: errmsg => l_retmsg,
161: retcode => l_retcode);
162:

Line 164: p_event.AddParameterToList('ECX_TRANSACTION_TYPE', x_ecxmsg.transaction_type);

160: errmsg => l_retmsg,
161: retcode => l_retcode);
162:
163: p_event.AddParameterToList('ECX_MSGID', x_msgid);
164: p_event.AddParameterToList('ECX_TRANSACTION_TYPE', x_ecxmsg.transaction_type);
165: p_event.AddParameterToList('ECX_TRANSACTION_SUBTYPE', x_ecxmsg.transaction_subtype);
166: p_event.AddParameterToList('ECX_MESSAGE_STANDARD', x_ecxmsg.message_standard);
167: p_event.AddParameterToList('ECX_MESSAGE_TYPE', x_ecxmsg.message_type);
168: p_event.AddParameterToList('ECX_DOCUMENT_NUMBER', x_ecxmsg.document_number);

Line 165: p_event.AddParameterToList('ECX_TRANSACTION_SUBTYPE', x_ecxmsg.transaction_subtype);

161: retcode => l_retcode);
162:
163: p_event.AddParameterToList('ECX_MSGID', x_msgid);
164: p_event.AddParameterToList('ECX_TRANSACTION_TYPE', x_ecxmsg.transaction_type);
165: p_event.AddParameterToList('ECX_TRANSACTION_SUBTYPE', x_ecxmsg.transaction_subtype);
166: p_event.AddParameterToList('ECX_MESSAGE_STANDARD', x_ecxmsg.message_standard);
167: p_event.AddParameterToList('ECX_MESSAGE_TYPE', x_ecxmsg.message_type);
168: p_event.AddParameterToList('ECX_DOCUMENT_NUMBER', x_ecxmsg.document_number);
169: p_event.AddParameterToList('ECX_PARTY_ID', x_ecxmsg.partyid);

Line 166: p_event.AddParameterToList('ECX_MESSAGE_STANDARD', x_ecxmsg.message_standard);

162:
163: p_event.AddParameterToList('ECX_MSGID', x_msgid);
164: p_event.AddParameterToList('ECX_TRANSACTION_TYPE', x_ecxmsg.transaction_type);
165: p_event.AddParameterToList('ECX_TRANSACTION_SUBTYPE', x_ecxmsg.transaction_subtype);
166: p_event.AddParameterToList('ECX_MESSAGE_STANDARD', x_ecxmsg.message_standard);
167: p_event.AddParameterToList('ECX_MESSAGE_TYPE', x_ecxmsg.message_type);
168: p_event.AddParameterToList('ECX_DOCUMENT_NUMBER', x_ecxmsg.document_number);
169: p_event.AddParameterToList('ECX_PARTY_ID', x_ecxmsg.partyid);
170: p_event.AddParameterToList('ECX_PARTY_SITE_ID', x_ecxmsg.party_site_id);

Line 167: p_event.AddParameterToList('ECX_MESSAGE_TYPE', x_ecxmsg.message_type);

163: p_event.AddParameterToList('ECX_MSGID', x_msgid);
164: p_event.AddParameterToList('ECX_TRANSACTION_TYPE', x_ecxmsg.transaction_type);
165: p_event.AddParameterToList('ECX_TRANSACTION_SUBTYPE', x_ecxmsg.transaction_subtype);
166: p_event.AddParameterToList('ECX_MESSAGE_STANDARD', x_ecxmsg.message_standard);
167: p_event.AddParameterToList('ECX_MESSAGE_TYPE', x_ecxmsg.message_type);
168: p_event.AddParameterToList('ECX_DOCUMENT_NUMBER', x_ecxmsg.document_number);
169: p_event.AddParameterToList('ECX_PARTY_ID', x_ecxmsg.partyid);
170: p_event.AddParameterToList('ECX_PARTY_SITE_ID', x_ecxmsg.party_site_id);
171: p_event.AddParameterToList('ECX_PARTY_TYPE', x_ecxmsg.party_type);

Line 168: p_event.AddParameterToList('ECX_DOCUMENT_NUMBER', x_ecxmsg.document_number);

164: p_event.AddParameterToList('ECX_TRANSACTION_TYPE', x_ecxmsg.transaction_type);
165: p_event.AddParameterToList('ECX_TRANSACTION_SUBTYPE', x_ecxmsg.transaction_subtype);
166: p_event.AddParameterToList('ECX_MESSAGE_STANDARD', x_ecxmsg.message_standard);
167: p_event.AddParameterToList('ECX_MESSAGE_TYPE', x_ecxmsg.message_type);
168: p_event.AddParameterToList('ECX_DOCUMENT_NUMBER', x_ecxmsg.document_number);
169: p_event.AddParameterToList('ECX_PARTY_ID', x_ecxmsg.partyid);
170: p_event.AddParameterToList('ECX_PARTY_SITE_ID', x_ecxmsg.party_site_id);
171: p_event.AddParameterToList('ECX_PARTY_TYPE', x_ecxmsg.party_type);
172: p_event.AddParameterToList('ECX_PROTOCOL_TYPE', x_ecxmsg.protocol_type);

Line 169: p_event.AddParameterToList('ECX_PARTY_ID', x_ecxmsg.partyid);

165: p_event.AddParameterToList('ECX_TRANSACTION_SUBTYPE', x_ecxmsg.transaction_subtype);
166: p_event.AddParameterToList('ECX_MESSAGE_STANDARD', x_ecxmsg.message_standard);
167: p_event.AddParameterToList('ECX_MESSAGE_TYPE', x_ecxmsg.message_type);
168: p_event.AddParameterToList('ECX_DOCUMENT_NUMBER', x_ecxmsg.document_number);
169: p_event.AddParameterToList('ECX_PARTY_ID', x_ecxmsg.partyid);
170: p_event.AddParameterToList('ECX_PARTY_SITE_ID', x_ecxmsg.party_site_id);
171: p_event.AddParameterToList('ECX_PARTY_TYPE', x_ecxmsg.party_type);
172: p_event.AddParameterToList('ECX_PROTOCOL_TYPE', x_ecxmsg.protocol_type);
173: p_event.AddParameterToList('ECX_PROTOCOL_ADDRESS', x_ecxmsg.protocol_ADDRESS);

Line 170: p_event.AddParameterToList('ECX_PARTY_SITE_ID', x_ecxmsg.party_site_id);

166: p_event.AddParameterToList('ECX_MESSAGE_STANDARD', x_ecxmsg.message_standard);
167: p_event.AddParameterToList('ECX_MESSAGE_TYPE', x_ecxmsg.message_type);
168: p_event.AddParameterToList('ECX_DOCUMENT_NUMBER', x_ecxmsg.document_number);
169: p_event.AddParameterToList('ECX_PARTY_ID', x_ecxmsg.partyid);
170: p_event.AddParameterToList('ECX_PARTY_SITE_ID', x_ecxmsg.party_site_id);
171: p_event.AddParameterToList('ECX_PARTY_TYPE', x_ecxmsg.party_type);
172: p_event.AddParameterToList('ECX_PROTOCOL_TYPE', x_ecxmsg.protocol_type);
173: p_event.AddParameterToList('ECX_PROTOCOL_ADDRESS', x_ecxmsg.protocol_ADDRESS);
174: p_event.AddParameterToList('ECX_USERNAME', x_ecxmsg.username);

Line 171: p_event.AddParameterToList('ECX_PARTY_TYPE', x_ecxmsg.party_type);

167: p_event.AddParameterToList('ECX_MESSAGE_TYPE', x_ecxmsg.message_type);
168: p_event.AddParameterToList('ECX_DOCUMENT_NUMBER', x_ecxmsg.document_number);
169: p_event.AddParameterToList('ECX_PARTY_ID', x_ecxmsg.partyid);
170: p_event.AddParameterToList('ECX_PARTY_SITE_ID', x_ecxmsg.party_site_id);
171: p_event.AddParameterToList('ECX_PARTY_TYPE', x_ecxmsg.party_type);
172: p_event.AddParameterToList('ECX_PROTOCOL_TYPE', x_ecxmsg.protocol_type);
173: p_event.AddParameterToList('ECX_PROTOCOL_ADDRESS', x_ecxmsg.protocol_ADDRESS);
174: p_event.AddParameterToList('ECX_USERNAME', x_ecxmsg.username);
175: p_event.AddParameterToList('ECX_PASSWORD', encrypt_password);

Line 172: p_event.AddParameterToList('ECX_PROTOCOL_TYPE', x_ecxmsg.protocol_type);

168: p_event.AddParameterToList('ECX_DOCUMENT_NUMBER', x_ecxmsg.document_number);
169: p_event.AddParameterToList('ECX_PARTY_ID', x_ecxmsg.partyid);
170: p_event.AddParameterToList('ECX_PARTY_SITE_ID', x_ecxmsg.party_site_id);
171: p_event.AddParameterToList('ECX_PARTY_TYPE', x_ecxmsg.party_type);
172: p_event.AddParameterToList('ECX_PROTOCOL_TYPE', x_ecxmsg.protocol_type);
173: p_event.AddParameterToList('ECX_PROTOCOL_ADDRESS', x_ecxmsg.protocol_ADDRESS);
174: p_event.AddParameterToList('ECX_USERNAME', x_ecxmsg.username);
175: p_event.AddParameterToList('ECX_PASSWORD', encrypt_password);
176: p_event.AddParameterToList('ECX_ATTRIBUTE1', x_ecxmsg.attribute1);

Line 173: p_event.AddParameterToList('ECX_PROTOCOL_ADDRESS', x_ecxmsg.protocol_ADDRESS);

169: p_event.AddParameterToList('ECX_PARTY_ID', x_ecxmsg.partyid);
170: p_event.AddParameterToList('ECX_PARTY_SITE_ID', x_ecxmsg.party_site_id);
171: p_event.AddParameterToList('ECX_PARTY_TYPE', x_ecxmsg.party_type);
172: p_event.AddParameterToList('ECX_PROTOCOL_TYPE', x_ecxmsg.protocol_type);
173: p_event.AddParameterToList('ECX_PROTOCOL_ADDRESS', x_ecxmsg.protocol_ADDRESS);
174: p_event.AddParameterToList('ECX_USERNAME', x_ecxmsg.username);
175: p_event.AddParameterToList('ECX_PASSWORD', encrypt_password);
176: p_event.AddParameterToList('ECX_ATTRIBUTE1', x_ecxmsg.attribute1);
177: p_event.AddParameterToList('ECX_ATTRIBUTE2', nvl(to_number(x_ecxmsg.attribute2),0));

Line 174: p_event.AddParameterToList('ECX_USERNAME', x_ecxmsg.username);

170: p_event.AddParameterToList('ECX_PARTY_SITE_ID', x_ecxmsg.party_site_id);
171: p_event.AddParameterToList('ECX_PARTY_TYPE', x_ecxmsg.party_type);
172: p_event.AddParameterToList('ECX_PROTOCOL_TYPE', x_ecxmsg.protocol_type);
173: p_event.AddParameterToList('ECX_PROTOCOL_ADDRESS', x_ecxmsg.protocol_ADDRESS);
174: p_event.AddParameterToList('ECX_USERNAME', x_ecxmsg.username);
175: p_event.AddParameterToList('ECX_PASSWORD', encrypt_password);
176: p_event.AddParameterToList('ECX_ATTRIBUTE1', x_ecxmsg.attribute1);
177: p_event.AddParameterToList('ECX_ATTRIBUTE2', nvl(to_number(x_ecxmsg.attribute2),0));
178: p_event.AddParameterToList('ECX_ATTRIBUTE3', x_ecxmsg.attribute3);

Line 176: p_event.AddParameterToList('ECX_ATTRIBUTE1', x_ecxmsg.attribute1);

172: p_event.AddParameterToList('ECX_PROTOCOL_TYPE', x_ecxmsg.protocol_type);
173: p_event.AddParameterToList('ECX_PROTOCOL_ADDRESS', x_ecxmsg.protocol_ADDRESS);
174: p_event.AddParameterToList('ECX_USERNAME', x_ecxmsg.username);
175: p_event.AddParameterToList('ECX_PASSWORD', encrypt_password);
176: p_event.AddParameterToList('ECX_ATTRIBUTE1', x_ecxmsg.attribute1);
177: p_event.AddParameterToList('ECX_ATTRIBUTE2', nvl(to_number(x_ecxmsg.attribute2),0));
178: p_event.AddParameterToList('ECX_ATTRIBUTE3', x_ecxmsg.attribute3);
179: p_event.AddParameterToList('ECX_ATTRIBUTE4', x_ecxmsg.attribute4);
180: p_event.AddParameterToList('ECX_ATTRIBUTE5', x_ecxmsg.attribute5);

Line 177: p_event.AddParameterToList('ECX_ATTRIBUTE2', nvl(to_number(x_ecxmsg.attribute2),0));

173: p_event.AddParameterToList('ECX_PROTOCOL_ADDRESS', x_ecxmsg.protocol_ADDRESS);
174: p_event.AddParameterToList('ECX_USERNAME', x_ecxmsg.username);
175: p_event.AddParameterToList('ECX_PASSWORD', encrypt_password);
176: p_event.AddParameterToList('ECX_ATTRIBUTE1', x_ecxmsg.attribute1);
177: p_event.AddParameterToList('ECX_ATTRIBUTE2', nvl(to_number(x_ecxmsg.attribute2),0));
178: p_event.AddParameterToList('ECX_ATTRIBUTE3', x_ecxmsg.attribute3);
179: p_event.AddParameterToList('ECX_ATTRIBUTE4', x_ecxmsg.attribute4);
180: p_event.AddParameterToList('ECX_ATTRIBUTE5', x_ecxmsg.attribute5);
181: p_event.AddParameterToList('ECX_ICN', i_message_counter);

Line 178: p_event.AddParameterToList('ECX_ATTRIBUTE3', x_ecxmsg.attribute3);

174: p_event.AddParameterToList('ECX_USERNAME', x_ecxmsg.username);
175: p_event.AddParameterToList('ECX_PASSWORD', encrypt_password);
176: p_event.AddParameterToList('ECX_ATTRIBUTE1', x_ecxmsg.attribute1);
177: p_event.AddParameterToList('ECX_ATTRIBUTE2', nvl(to_number(x_ecxmsg.attribute2),0));
178: p_event.AddParameterToList('ECX_ATTRIBUTE3', x_ecxmsg.attribute3);
179: p_event.AddParameterToList('ECX_ATTRIBUTE4', x_ecxmsg.attribute4);
180: p_event.AddParameterToList('ECX_ATTRIBUTE5', x_ecxmsg.attribute5);
181: p_event.AddParameterToList('ECX_ICN', i_message_counter);
182: open c_ecx_trigger_id;

Line 179: p_event.AddParameterToList('ECX_ATTRIBUTE4', x_ecxmsg.attribute4);

175: p_event.AddParameterToList('ECX_PASSWORD', encrypt_password);
176: p_event.AddParameterToList('ECX_ATTRIBUTE1', x_ecxmsg.attribute1);
177: p_event.AddParameterToList('ECX_ATTRIBUTE2', nvl(to_number(x_ecxmsg.attribute2),0));
178: p_event.AddParameterToList('ECX_ATTRIBUTE3', x_ecxmsg.attribute3);
179: p_event.AddParameterToList('ECX_ATTRIBUTE4', x_ecxmsg.attribute4);
180: p_event.AddParameterToList('ECX_ATTRIBUTE5', x_ecxmsg.attribute5);
181: p_event.AddParameterToList('ECX_ICN', i_message_counter);
182: open c_ecx_trigger_id;
183: fetch c_ecx_trigger_id into x_trigger_id;

Line 180: p_event.AddParameterToList('ECX_ATTRIBUTE5', x_ecxmsg.attribute5);

176: p_event.AddParameterToList('ECX_ATTRIBUTE1', x_ecxmsg.attribute1);
177: p_event.AddParameterToList('ECX_ATTRIBUTE2', nvl(to_number(x_ecxmsg.attribute2),0));
178: p_event.AddParameterToList('ECX_ATTRIBUTE3', x_ecxmsg.attribute3);
179: p_event.AddParameterToList('ECX_ATTRIBUTE4', x_ecxmsg.attribute4);
180: p_event.AddParameterToList('ECX_ATTRIBUTE5', x_ecxmsg.attribute5);
181: p_event.AddParameterToList('ECX_ICN', i_message_counter);
182: open c_ecx_trigger_id;
183: fetch c_ecx_trigger_id into x_trigger_id;
184: close c_ecx_trigger_id;

Line 193: p_event.setEventData(x_ecxmsg.payload);

189: --p_event.AddParameterToList('ECX_DEBUG_LEVEL', 0);
190: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
191: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'Setting payload');
192: end if;
193: p_event.setEventData(x_ecxmsg.payload);
194:
195: exception
196: when no_messages then
197: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

Line 236: x_ecxmsg SYSTEM.ecxmsg ;

232: x_out_queue varchar2(80);
233: x_enqueue_options dbms_aq.enqueue_options_t;
234: x_message_properties dbms_aq.message_properties_t;
235: x_msgid RAW(16);
236: x_ecxmsg SYSTEM.ecxmsg ;
237: l_module varchar2(2000);
238:
239: begin
240: l_module := 'ecx.plsql.ecx_inbound_listener_qh.enqueue';

Line 248: x_ecxmsg := SYSTEM.ecxmsg(null,null,null,null, null,null,null,null,

244: end if;
245:
246: x_out_queue := 'APPLSYS.ECX_INBOUND';
247:
248: x_ecxmsg := SYSTEM.ecxmsg(null,null,null,null, null,null,null,null,
249: null,null,null,null, null,null,
250: null,null,null,null);
251:
252: x_ecxmsg.message_type := p_event.getValueForParameter('ECX_MESSAGE_TYPE');

Line 252: x_ecxmsg.message_type := p_event.getValueForParameter('ECX_MESSAGE_TYPE');

248: x_ecxmsg := SYSTEM.ecxmsg(null,null,null,null, null,null,null,null,
249: null,null,null,null, null,null,
250: null,null,null,null);
251:
252: x_ecxmsg.message_type := p_event.getValueForParameter('ECX_MESSAGE_TYPE');
253: x_ecxmsg.message_standard := p_event.getValueForParameter('ECX_MESSAGE_STANDARD');
254: x_ecxmsg.transaction_type := p_event.getValueForParameter('ECX_TRANSACTION_TYPE');
255: x_ecxmsg.transaction_subtype := p_event.getValueForParameter('ECX_TRANSACTION_SUBTYPE');
256: x_ecxmsg.document_number := p_event.getValueForParameter('ECX_DOCUMENT_NUMBER');

Line 253: x_ecxmsg.message_standard := p_event.getValueForParameter('ECX_MESSAGE_STANDARD');

249: null,null,null,null, null,null,
250: null,null,null,null);
251:
252: x_ecxmsg.message_type := p_event.getValueForParameter('ECX_MESSAGE_TYPE');
253: x_ecxmsg.message_standard := p_event.getValueForParameter('ECX_MESSAGE_STANDARD');
254: x_ecxmsg.transaction_type := p_event.getValueForParameter('ECX_TRANSACTION_TYPE');
255: x_ecxmsg.transaction_subtype := p_event.getValueForParameter('ECX_TRANSACTION_SUBTYPE');
256: x_ecxmsg.document_number := p_event.getValueForParameter('ECX_DOCUMENT_NUMBER');
257: x_ecxmsg.partyid := p_event.getValueForParameter('ECX_PARTY_ID');

Line 254: x_ecxmsg.transaction_type := p_event.getValueForParameter('ECX_TRANSACTION_TYPE');

250: null,null,null,null);
251:
252: x_ecxmsg.message_type := p_event.getValueForParameter('ECX_MESSAGE_TYPE');
253: x_ecxmsg.message_standard := p_event.getValueForParameter('ECX_MESSAGE_STANDARD');
254: x_ecxmsg.transaction_type := p_event.getValueForParameter('ECX_TRANSACTION_TYPE');
255: x_ecxmsg.transaction_subtype := p_event.getValueForParameter('ECX_TRANSACTION_SUBTYPE');
256: x_ecxmsg.document_number := p_event.getValueForParameter('ECX_DOCUMENT_NUMBER');
257: x_ecxmsg.partyid := p_event.getValueForParameter('ECX_PARTY_ID');
258: x_ecxmsg.party_site_id := p_event.getValueForParameter('ECX_PARTY_SITE_ID');

Line 255: x_ecxmsg.transaction_subtype := p_event.getValueForParameter('ECX_TRANSACTION_SUBTYPE');

251:
252: x_ecxmsg.message_type := p_event.getValueForParameter('ECX_MESSAGE_TYPE');
253: x_ecxmsg.message_standard := p_event.getValueForParameter('ECX_MESSAGE_STANDARD');
254: x_ecxmsg.transaction_type := p_event.getValueForParameter('ECX_TRANSACTION_TYPE');
255: x_ecxmsg.transaction_subtype := p_event.getValueForParameter('ECX_TRANSACTION_SUBTYPE');
256: x_ecxmsg.document_number := p_event.getValueForParameter('ECX_DOCUMENT_NUMBER');
257: x_ecxmsg.partyid := p_event.getValueForParameter('ECX_PARTY_ID');
258: x_ecxmsg.party_site_id := p_event.getValueForParameter('ECX_PARTY_SITE_ID');
259: x_ecxmsg.protocol_type := p_event.getValueForParameter('ECX_PROTOCOL_TYPE');

Line 256: x_ecxmsg.document_number := p_event.getValueForParameter('ECX_DOCUMENT_NUMBER');

252: x_ecxmsg.message_type := p_event.getValueForParameter('ECX_MESSAGE_TYPE');
253: x_ecxmsg.message_standard := p_event.getValueForParameter('ECX_MESSAGE_STANDARD');
254: x_ecxmsg.transaction_type := p_event.getValueForParameter('ECX_TRANSACTION_TYPE');
255: x_ecxmsg.transaction_subtype := p_event.getValueForParameter('ECX_TRANSACTION_SUBTYPE');
256: x_ecxmsg.document_number := p_event.getValueForParameter('ECX_DOCUMENT_NUMBER');
257: x_ecxmsg.partyid := p_event.getValueForParameter('ECX_PARTY_ID');
258: x_ecxmsg.party_site_id := p_event.getValueForParameter('ECX_PARTY_SITE_ID');
259: x_ecxmsg.protocol_type := p_event.getValueForParameter('ECX_PROTOCOL_TYPE');
260: x_ecxmsg.protocol_address := p_event.getValueForParameter('ECX_PROTOCOL_ADDRESS');

Line 257: x_ecxmsg.partyid := p_event.getValueForParameter('ECX_PARTY_ID');

253: x_ecxmsg.message_standard := p_event.getValueForParameter('ECX_MESSAGE_STANDARD');
254: x_ecxmsg.transaction_type := p_event.getValueForParameter('ECX_TRANSACTION_TYPE');
255: x_ecxmsg.transaction_subtype := p_event.getValueForParameter('ECX_TRANSACTION_SUBTYPE');
256: x_ecxmsg.document_number := p_event.getValueForParameter('ECX_DOCUMENT_NUMBER');
257: x_ecxmsg.partyid := p_event.getValueForParameter('ECX_PARTY_ID');
258: x_ecxmsg.party_site_id := p_event.getValueForParameter('ECX_PARTY_SITE_ID');
259: x_ecxmsg.protocol_type := p_event.getValueForParameter('ECX_PROTOCOL_TYPE');
260: x_ecxmsg.protocol_address := p_event.getValueForParameter('ECX_PROTOCOL_ADDRESS');
261: x_ecxmsg.username := p_event.getValueForParameter('ECX_USERNAME');

Line 258: x_ecxmsg.party_site_id := p_event.getValueForParameter('ECX_PARTY_SITE_ID');

254: x_ecxmsg.transaction_type := p_event.getValueForParameter('ECX_TRANSACTION_TYPE');
255: x_ecxmsg.transaction_subtype := p_event.getValueForParameter('ECX_TRANSACTION_SUBTYPE');
256: x_ecxmsg.document_number := p_event.getValueForParameter('ECX_DOCUMENT_NUMBER');
257: x_ecxmsg.partyid := p_event.getValueForParameter('ECX_PARTY_ID');
258: x_ecxmsg.party_site_id := p_event.getValueForParameter('ECX_PARTY_SITE_ID');
259: x_ecxmsg.protocol_type := p_event.getValueForParameter('ECX_PROTOCOL_TYPE');
260: x_ecxmsg.protocol_address := p_event.getValueForParameter('ECX_PROTOCOL_ADDRESS');
261: x_ecxmsg.username := p_event.getValueForParameter('ECX_USERNAME');
262: x_ecxmsg.password := p_event.getValueForParameter('ECX_PASSWORD');

Line 259: x_ecxmsg.protocol_type := p_event.getValueForParameter('ECX_PROTOCOL_TYPE');

255: x_ecxmsg.transaction_subtype := p_event.getValueForParameter('ECX_TRANSACTION_SUBTYPE');
256: x_ecxmsg.document_number := p_event.getValueForParameter('ECX_DOCUMENT_NUMBER');
257: x_ecxmsg.partyid := p_event.getValueForParameter('ECX_PARTY_ID');
258: x_ecxmsg.party_site_id := p_event.getValueForParameter('ECX_PARTY_SITE_ID');
259: x_ecxmsg.protocol_type := p_event.getValueForParameter('ECX_PROTOCOL_TYPE');
260: x_ecxmsg.protocol_address := p_event.getValueForParameter('ECX_PROTOCOL_ADDRESS');
261: x_ecxmsg.username := p_event.getValueForParameter('ECX_USERNAME');
262: x_ecxmsg.password := p_event.getValueForParameter('ECX_PASSWORD');
263: x_ecxmsg.attribute1 := p_event.getValueForParameter('ECX_ATTRIBUTE1');

Line 260: x_ecxmsg.protocol_address := p_event.getValueForParameter('ECX_PROTOCOL_ADDRESS');

256: x_ecxmsg.document_number := p_event.getValueForParameter('ECX_DOCUMENT_NUMBER');
257: x_ecxmsg.partyid := p_event.getValueForParameter('ECX_PARTY_ID');
258: x_ecxmsg.party_site_id := p_event.getValueForParameter('ECX_PARTY_SITE_ID');
259: x_ecxmsg.protocol_type := p_event.getValueForParameter('ECX_PROTOCOL_TYPE');
260: x_ecxmsg.protocol_address := p_event.getValueForParameter('ECX_PROTOCOL_ADDRESS');
261: x_ecxmsg.username := p_event.getValueForParameter('ECX_USERNAME');
262: x_ecxmsg.password := p_event.getValueForParameter('ECX_PASSWORD');
263: x_ecxmsg.attribute1 := p_event.getValueForParameter('ECX_ATTRIBUTE1');
264: x_ecxmsg.attribute2 := p_event.getValueForParameter('ECX_ATTRIBUTE2');

Line 261: x_ecxmsg.username := p_event.getValueForParameter('ECX_USERNAME');

257: x_ecxmsg.partyid := p_event.getValueForParameter('ECX_PARTY_ID');
258: x_ecxmsg.party_site_id := p_event.getValueForParameter('ECX_PARTY_SITE_ID');
259: x_ecxmsg.protocol_type := p_event.getValueForParameter('ECX_PROTOCOL_TYPE');
260: x_ecxmsg.protocol_address := p_event.getValueForParameter('ECX_PROTOCOL_ADDRESS');
261: x_ecxmsg.username := p_event.getValueForParameter('ECX_USERNAME');
262: x_ecxmsg.password := p_event.getValueForParameter('ECX_PASSWORD');
263: x_ecxmsg.attribute1 := p_event.getValueForParameter('ECX_ATTRIBUTE1');
264: x_ecxmsg.attribute2 := p_event.getValueForParameter('ECX_ATTRIBUTE2');
265: x_ecxmsg.attribute3 := p_event.getValueForParameter('ECX_ATTRIBUTE3');

Line 262: x_ecxmsg.password := p_event.getValueForParameter('ECX_PASSWORD');

258: x_ecxmsg.party_site_id := p_event.getValueForParameter('ECX_PARTY_SITE_ID');
259: x_ecxmsg.protocol_type := p_event.getValueForParameter('ECX_PROTOCOL_TYPE');
260: x_ecxmsg.protocol_address := p_event.getValueForParameter('ECX_PROTOCOL_ADDRESS');
261: x_ecxmsg.username := p_event.getValueForParameter('ECX_USERNAME');
262: x_ecxmsg.password := p_event.getValueForParameter('ECX_PASSWORD');
263: x_ecxmsg.attribute1 := p_event.getValueForParameter('ECX_ATTRIBUTE1');
264: x_ecxmsg.attribute2 := p_event.getValueForParameter('ECX_ATTRIBUTE2');
265: x_ecxmsg.attribute3 := p_event.getValueForParameter('ECX_ATTRIBUTE3');
266: x_ecxmsg.attribute4 := p_event.getValueForParameter('ECX_ATTRIBUTE4');

Line 263: x_ecxmsg.attribute1 := p_event.getValueForParameter('ECX_ATTRIBUTE1');

259: x_ecxmsg.protocol_type := p_event.getValueForParameter('ECX_PROTOCOL_TYPE');
260: x_ecxmsg.protocol_address := p_event.getValueForParameter('ECX_PROTOCOL_ADDRESS');
261: x_ecxmsg.username := p_event.getValueForParameter('ECX_USERNAME');
262: x_ecxmsg.password := p_event.getValueForParameter('ECX_PASSWORD');
263: x_ecxmsg.attribute1 := p_event.getValueForParameter('ECX_ATTRIBUTE1');
264: x_ecxmsg.attribute2 := p_event.getValueForParameter('ECX_ATTRIBUTE2');
265: x_ecxmsg.attribute3 := p_event.getValueForParameter('ECX_ATTRIBUTE3');
266: x_ecxmsg.attribute4 := p_event.getValueForParameter('ECX_ATTRIBUTE4');
267: x_ecxmsg.attribute5 := p_event.getValueForParameter('ECX_ATTRIBUTE5');

Line 264: x_ecxmsg.attribute2 := p_event.getValueForParameter('ECX_ATTRIBUTE2');

260: x_ecxmsg.protocol_address := p_event.getValueForParameter('ECX_PROTOCOL_ADDRESS');
261: x_ecxmsg.username := p_event.getValueForParameter('ECX_USERNAME');
262: x_ecxmsg.password := p_event.getValueForParameter('ECX_PASSWORD');
263: x_ecxmsg.attribute1 := p_event.getValueForParameter('ECX_ATTRIBUTE1');
264: x_ecxmsg.attribute2 := p_event.getValueForParameter('ECX_ATTRIBUTE2');
265: x_ecxmsg.attribute3 := p_event.getValueForParameter('ECX_ATTRIBUTE3');
266: x_ecxmsg.attribute4 := p_event.getValueForParameter('ECX_ATTRIBUTE4');
267: x_ecxmsg.attribute5 := p_event.getValueForParameter('ECX_ATTRIBUTE5');
268: x_ecxmsg.payload := p_event.getEventData();

Line 265: x_ecxmsg.attribute3 := p_event.getValueForParameter('ECX_ATTRIBUTE3');

261: x_ecxmsg.username := p_event.getValueForParameter('ECX_USERNAME');
262: x_ecxmsg.password := p_event.getValueForParameter('ECX_PASSWORD');
263: x_ecxmsg.attribute1 := p_event.getValueForParameter('ECX_ATTRIBUTE1');
264: x_ecxmsg.attribute2 := p_event.getValueForParameter('ECX_ATTRIBUTE2');
265: x_ecxmsg.attribute3 := p_event.getValueForParameter('ECX_ATTRIBUTE3');
266: x_ecxmsg.attribute4 := p_event.getValueForParameter('ECX_ATTRIBUTE4');
267: x_ecxmsg.attribute5 := p_event.getValueForParameter('ECX_ATTRIBUTE5');
268: x_ecxmsg.payload := p_event.getEventData();
269:

Line 266: x_ecxmsg.attribute4 := p_event.getValueForParameter('ECX_ATTRIBUTE4');

262: x_ecxmsg.password := p_event.getValueForParameter('ECX_PASSWORD');
263: x_ecxmsg.attribute1 := p_event.getValueForParameter('ECX_ATTRIBUTE1');
264: x_ecxmsg.attribute2 := p_event.getValueForParameter('ECX_ATTRIBUTE2');
265: x_ecxmsg.attribute3 := p_event.getValueForParameter('ECX_ATTRIBUTE3');
266: x_ecxmsg.attribute4 := p_event.getValueForParameter('ECX_ATTRIBUTE4');
267: x_ecxmsg.attribute5 := p_event.getValueForParameter('ECX_ATTRIBUTE5');
268: x_ecxmsg.payload := p_event.getEventData();
269:
270: x_message_properties.priority := p_event.GetPriority();

Line 267: x_ecxmsg.attribute5 := p_event.getValueForParameter('ECX_ATTRIBUTE5');

263: x_ecxmsg.attribute1 := p_event.getValueForParameter('ECX_ATTRIBUTE1');
264: x_ecxmsg.attribute2 := p_event.getValueForParameter('ECX_ATTRIBUTE2');
265: x_ecxmsg.attribute3 := p_event.getValueForParameter('ECX_ATTRIBUTE3');
266: x_ecxmsg.attribute4 := p_event.getValueForParameter('ECX_ATTRIBUTE4');
267: x_ecxmsg.attribute5 := p_event.getValueForParameter('ECX_ATTRIBUTE5');
268: x_ecxmsg.payload := p_event.getEventData();
269:
270: x_message_properties.priority := p_event.GetPriority();
271:

Line 268: x_ecxmsg.payload := p_event.getEventData();

264: x_ecxmsg.attribute2 := p_event.getValueForParameter('ECX_ATTRIBUTE2');
265: x_ecxmsg.attribute3 := p_event.getValueForParameter('ECX_ATTRIBUTE3');
266: x_ecxmsg.attribute4 := p_event.getValueForParameter('ECX_ATTRIBUTE4');
267: x_ecxmsg.attribute5 := p_event.getValueForParameter('ECX_ATTRIBUTE5');
268: x_ecxmsg.payload := p_event.getEventData();
269:
270: x_message_properties.priority := p_event.GetPriority();
271:
272:

Line 278: payload => x_ecxmsg,

274: (
275: queue_name => x_out_queue,
276: enqueue_options => x_enqueue_options,
277: message_properties => x_message_properties,
278: payload => x_ecxmsg,
279: msgid => x_msgid
280: );
281:
282: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then