DBA Data[Home] [Help]

APPS.CLN_SHOWSHIP_PKG dependencies on WF_EVENT

Line 273: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',

269: cln_debug_pub.Add('Failure point ' || x_progress, 1);
270: end if;
271:
272: -- add parameters to list for create collaboration event
273: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
274: p_value => transaction_type,
275: p_parameterlist => l_create_cln_parameter_list);
276: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
277: p_value => transaction_subtype,

Line 276: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',

272: -- add parameters to list for create collaboration event
273: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
274: p_value => transaction_type,
275: p_parameterlist => l_create_cln_parameter_list);
276: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
277: p_value => transaction_subtype,
278: p_parameterlist => l_create_cln_parameter_list);
279: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
280: p_value => document_direction,

Line 279: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',

275: p_parameterlist => l_create_cln_parameter_list);
276: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
277: p_value => transaction_subtype,
278: p_parameterlist => l_create_cln_parameter_list);
279: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
280: p_value => document_direction,
281: p_parameterlist => l_create_cln_parameter_list);
282: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
283: p_value => l_event_key,

Line 282: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',

278: p_parameterlist => l_create_cln_parameter_list);
279: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
280: p_value => document_direction,
281: p_parameterlist => l_create_cln_parameter_list);
282: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
283: p_value => l_event_key,
284: p_parameterlist => l_create_cln_parameter_list);
285: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
286: p_value => party_id,

Line 285: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',

281: p_parameterlist => l_create_cln_parameter_list);
282: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
283: p_value => l_event_key,
284: p_parameterlist => l_create_cln_parameter_list);
285: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
286: p_value => party_id,
287: p_parameterlist => l_create_cln_parameter_list);
288: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
289: p_value => party_site_id,

Line 288: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',

284: p_parameterlist => l_create_cln_parameter_list);
285: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
286: p_value => party_id,
287: p_parameterlist => l_create_cln_parameter_list);
288: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
289: p_value => party_site_id,
290: p_parameterlist => l_create_cln_parameter_list);
291: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
292: p_value => party_type,

Line 291: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',

287: p_parameterlist => l_create_cln_parameter_list);
288: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
289: p_value => party_site_id,
290: p_parameterlist => l_create_cln_parameter_list);
291: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
292: p_value => party_type,
293: p_parameterlist => l_create_cln_parameter_list);
294: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
295: p_value => p_delivery_id,

Line 294: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',

290: p_parameterlist => l_create_cln_parameter_list);
291: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
292: p_value => party_type,
293: p_parameterlist => l_create_cln_parameter_list);
294: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
295: p_value => p_delivery_id,
296: p_parameterlist => l_create_cln_parameter_list);
297: wf_event.AddParameterToList(p_name => 'ORG_ID',
298: p_value => l_organization_id,

Line 297: wf_event.AddParameterToList(p_name => 'ORG_ID',

293: p_parameterlist => l_create_cln_parameter_list);
294: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
295: p_value => p_delivery_id,
296: p_parameterlist => l_create_cln_parameter_list);
297: wf_event.AddParameterToList(p_name => 'ORG_ID',
298: p_value => l_organization_id,
299: p_parameterlist => l_create_cln_parameter_list);
300: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
301: p_value => l_canonical_date,

Line 300: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',

296: p_parameterlist => l_create_cln_parameter_list);
297: wf_event.AddParameterToList(p_name => 'ORG_ID',
298: p_value => l_organization_id,
299: p_parameterlist => l_create_cln_parameter_list);
300: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
301: p_value => l_canonical_date,
302: p_parameterlist => l_create_cln_parameter_list);
303:
304: x_progress := 'CLN_SHOWSHIP_PKG.Showship_Raise_Event : 10';

Line 310: wf_event.raise(p_event_name => l_create_cln_event,

306: cln_debug_pub.Add('Failure point ' || x_progress, 1);
307: end if;
308:
309: -- raise create collaboration event
310: wf_event.raise(p_event_name => l_create_cln_event,
311: p_event_key => l_event_key,
312: p_parameters => l_create_cln_parameter_list);
313:
314: x_progress := 'CLN_SHOWSHIP_PKG.Showship_Raise_Event : 11';

Line 320: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_TYPE',

316: cln_debug_pub.Add('Failure point ' || x_progress, 1);
317: end if;
318:
319: -- add parameters to list for send show shipment document
320: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
321: p_value => transaction_type,
322: p_parameterlist => l_send_shsp_parameter_list);
323: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
324: p_value => transaction_subtype,

Line 323: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',

319: -- add parameters to list for send show shipment document
320: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
321: p_value => transaction_type,
322: p_parameterlist => l_send_shsp_parameter_list);
323: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
324: p_value => transaction_subtype,
325: p_parameterlist => l_send_shsp_parameter_list);
326: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
327: p_value => transaction_type,

Line 326: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',

322: p_parameterlist => l_send_shsp_parameter_list);
323: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
324: p_value => transaction_subtype,
325: p_parameterlist => l_send_shsp_parameter_list);
326: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
327: p_value => transaction_type,
328: p_parameterlist => l_send_shsp_parameter_list);
329: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
330: p_value => transaction_subtype,

Line 329: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',

325: p_parameterlist => l_send_shsp_parameter_list);
326: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
327: p_value => transaction_type,
328: p_parameterlist => l_send_shsp_parameter_list);
329: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
330: p_value => transaction_subtype,
331: p_parameterlist => l_send_shsp_parameter_list);
332: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
333: p_value => document_direction,

Line 332: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',

328: p_parameterlist => l_send_shsp_parameter_list);
329: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
330: p_value => transaction_subtype,
331: p_parameterlist => l_send_shsp_parameter_list);
332: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
333: p_value => document_direction,
334: p_parameterlist => l_send_shsp_parameter_list);
335: wf_event.AddParameterToList(p_name => 'ECX_PARTY_ID',
336: p_value => party_id,

Line 335: wf_event.AddParameterToList(p_name => 'ECX_PARTY_ID',

331: p_parameterlist => l_send_shsp_parameter_list);
332: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
333: p_value => document_direction,
334: p_parameterlist => l_send_shsp_parameter_list);
335: wf_event.AddParameterToList(p_name => 'ECX_PARTY_ID',
336: p_value => party_id,
337: p_parameterlist => l_send_shsp_parameter_list);
338: wf_event.AddParameterToList(p_name => 'ECX_PARTY_SITE_ID',
339: p_value => party_site_id,

Line 338: wf_event.AddParameterToList(p_name => 'ECX_PARTY_SITE_ID',

334: p_parameterlist => l_send_shsp_parameter_list);
335: wf_event.AddParameterToList(p_name => 'ECX_PARTY_ID',
336: p_value => party_id,
337: p_parameterlist => l_send_shsp_parameter_list);
338: wf_event.AddParameterToList(p_name => 'ECX_PARTY_SITE_ID',
339: p_value => party_site_id,
340: p_parameterlist => l_send_shsp_parameter_list);
341: wf_event.AddParameterToList(p_name => 'ECX_PARTY_TYPE',
342: p_value => party_type,

Line 341: wf_event.AddParameterToList(p_name => 'ECX_PARTY_TYPE',

337: p_parameterlist => l_send_shsp_parameter_list);
338: wf_event.AddParameterToList(p_name => 'ECX_PARTY_SITE_ID',
339: p_value => party_site_id,
340: p_parameterlist => l_send_shsp_parameter_list);
341: wf_event.AddParameterToList(p_name => 'ECX_PARTY_TYPE',
342: p_value => party_type,
343: p_parameterlist => l_send_shsp_parameter_list);
344: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
345: p_value => party_id,

Line 344: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',

340: p_parameterlist => l_send_shsp_parameter_list);
341: wf_event.AddParameterToList(p_name => 'ECX_PARTY_TYPE',
342: p_value => party_type,
343: p_parameterlist => l_send_shsp_parameter_list);
344: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
345: p_value => party_id,
346: p_parameterlist => l_send_shsp_parameter_list);
347: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
348: p_value => party_site_id,

Line 347: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',

343: p_parameterlist => l_send_shsp_parameter_list);
344: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
345: p_value => party_id,
346: p_parameterlist => l_send_shsp_parameter_list);
347: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
348: p_value => party_site_id,
349: p_parameterlist => l_send_shsp_parameter_list);
350: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
351: p_value => party_type,

Line 350: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',

346: p_parameterlist => l_send_shsp_parameter_list);
347: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
348: p_value => party_site_id,
349: p_parameterlist => l_send_shsp_parameter_list);
350: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
351: p_value => party_type,
352: p_parameterlist => l_send_shsp_parameter_list);
353: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
354: p_value => l_event_key,

Line 353: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',

349: p_parameterlist => l_send_shsp_parameter_list);
350: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
351: p_value => party_type,
352: p_parameterlist => l_send_shsp_parameter_list);
353: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
354: p_value => l_event_key,
355: p_parameterlist => l_send_shsp_parameter_list);
356: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
357: p_value => l_event_key,

Line 356: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',

352: p_parameterlist => l_send_shsp_parameter_list);
353: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
354: p_value => l_event_key,
355: p_parameterlist => l_send_shsp_parameter_list);
356: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
357: p_value => l_event_key,
358: p_parameterlist => l_send_shsp_parameter_list);
359: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
360: p_value => p_delivery_id,

Line 359: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',

355: p_parameterlist => l_send_shsp_parameter_list);
356: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
357: p_value => l_event_key,
358: p_parameterlist => l_send_shsp_parameter_list);
359: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
360: p_value => p_delivery_id,
361: p_parameterlist => l_send_shsp_parameter_list);
362: wf_event.AddParameterToList(p_name => 'MESSAGE_TEXT',
363: p_value => message_text,

Line 362: wf_event.AddParameterToList(p_name => 'MESSAGE_TEXT',

358: p_parameterlist => l_send_shsp_parameter_list);
359: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
360: p_value => p_delivery_id,
361: p_parameterlist => l_send_shsp_parameter_list);
362: wf_event.AddParameterToList(p_name => 'MESSAGE_TEXT',
363: p_value => message_text,
364: p_parameterlist => l_send_shsp_parameter_list);
365: wf_event.AddParameterToList(p_name => 'ORG_ID',
366: p_value => l_organization_id,

Line 365: wf_event.AddParameterToList(p_name => 'ORG_ID',

361: p_parameterlist => l_send_shsp_parameter_list);
362: wf_event.AddParameterToList(p_name => 'MESSAGE_TEXT',
363: p_value => message_text,
364: p_parameterlist => l_send_shsp_parameter_list);
365: wf_event.AddParameterToList(p_name => 'ORG_ID',
366: p_value => l_organization_id,
367: p_parameterlist => l_send_shsp_parameter_list);
368: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
369: p_value => l_canonical_date,

Line 368: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',

364: p_parameterlist => l_send_shsp_parameter_list);
365: wf_event.AddParameterToList(p_name => 'ORG_ID',
366: p_value => l_organization_id,
367: p_parameterlist => l_send_shsp_parameter_list);
368: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
369: p_value => l_canonical_date,
370: p_parameterlist => l_send_shsp_parameter_list);
371: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER1',
372: p_value => l_time_stamp_date_new,

Line 371: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER1',

367: p_parameterlist => l_send_shsp_parameter_list);
368: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
369: p_value => l_canonical_date,
370: p_parameterlist => l_send_shsp_parameter_list);
371: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER1',
372: p_value => l_time_stamp_date_new,
373: p_parameterlist => l_send_shsp_parameter_list);
374: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER2',
375: p_value => p_delivery_id,

Line 374: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER2',

370: p_parameterlist => l_send_shsp_parameter_list);
371: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER1',
372: p_value => l_time_stamp_date_new,
373: p_parameterlist => l_send_shsp_parameter_list);
374: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER2',
375: p_value => p_delivery_id,
376: p_parameterlist => l_send_shsp_parameter_list);
377:
378: -- raise event for send show shipment document

Line 379: wf_event.raise(p_event_name => l_send_shsp_event,

375: p_value => p_delivery_id,
376: p_parameterlist => l_send_shsp_parameter_list);
377:
378: -- raise event for send show shipment document
379: wf_event.raise(p_event_name => l_send_shsp_event,
380: p_event_key => l_event_key,
381: p_parameters => l_send_shsp_parameter_list);
382:
383: -- Reached Here. Successful execution.