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,
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,
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,
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,
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,
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,
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,
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,
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,
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';
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';
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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.