40: end if;
41: end;
42:
43: function otaCallBackRule(p_subscription_guid in raw,
44: p_event in out nocopy wf_event_t) return varchar2 is
45: l_msgid raw(16);
46: l_extType varchar2(80);
47: l_extSubType varchar2(80);
48: l_msg varchar2(4000);
274: end if;
275: l_itemkey := to_char(p_doc_transfer_id)||':'||to_char(sysdate, 'DD-MON-RRRR-HHMISS');
276: if isDebugOn then debug('l_itemkey:'||l_itemkey); end if;
277:
278: wf_event.AddParameterToList (
279: p_name => 'ECX_TRANSACTION_TYPE',
280: p_value => p_trx_type,
281: p_parameterlist => l_parameter_list );
282:
279: p_name => 'ECX_TRANSACTION_TYPE',
280: p_value => p_trx_type,
281: p_parameterlist => l_parameter_list );
282:
283: wf_event.AddParameterToList (
284: p_name => 'ECX_TRANSACTION_SUBTYPE',
285: p_value => p_trx_sub_type,
286: p_parameterlist => l_parameter_list );
287:
284: p_name => 'ECX_TRANSACTION_SUBTYPE',
285: p_value => p_trx_sub_type,
286: p_parameterlist => l_parameter_list );
287:
288: wf_event.AddParameterToList (
289: p_name => 'ECX_PARTY_ID',
290: p_value => NULL,
291: p_parameterlist => l_parameter_list );
292:
289: p_name => 'ECX_PARTY_ID',
290: p_value => NULL,
291: p_parameterlist => l_parameter_list );
292:
293: wf_event.AddParameterToList(
294: p_name => 'ECX_PARTY_SITE_ID',
295: p_value => p_party_site_id,
296: p_parameterlist => l_parameter_list );
297:
294: p_name => 'ECX_PARTY_SITE_ID',
295: p_value => p_party_site_id,
296: p_parameterlist => l_parameter_list );
297:
298: wf_event.AddParameterToList(
299: p_name => 'ECX_PARTY_TYPE',
300: p_value => p_party_type,
301: p_parameterlist => l_parameter_list );
302:
299: p_name => 'ECX_PARTY_TYPE',
300: p_value => p_party_type,
301: p_parameterlist => l_parameter_list );
302:
303: wf_event.AddParameterToList (
304: p_name => 'ECX_DOCUMENT_ID',
305: p_value => p_doc_transfer_id,
306: p_parameterlist => l_parameter_list );
307:
304: p_name => 'ECX_DOCUMENT_ID',
305: p_value => p_doc_transfer_id,
306: p_parameterlist => l_parameter_list );
307:
308: wf_event.AddParameterToList (
309: p_name => 'ORG_ID',
310: p_value => fnd_global.org_id,
311: p_parameterlist => l_parameter_list );
312:
309: p_name => 'ORG_ID',
310: p_value => fnd_global.org_id,
311: p_parameterlist => l_parameter_list );
312:
313: wf_event.raise(
314: p_event_name => p_event_name,
315: p_event_key => l_itemkey,
316: p_parameters => l_parameter_list);
317: