APPS.CLN_SYNCCTLG_PKG dependencies on WF_EVENT

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

235: cln_debug_pub.Add('Failure point ' || x_progress, 1);
236: end if;
237:
238: -- add parameters to list for create collaboration event
239: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
240: p_value => transaction_type,
241: p_parameterlist => l_create_cln_parameter_list);
242: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
243: p_value => transaction_subtype,

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

238: -- add parameters to list for create collaboration event
239: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
240: p_value => transaction_type,
241: p_parameterlist => l_create_cln_parameter_list);
242: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
243: p_value => transaction_subtype,
244: p_parameterlist => l_create_cln_parameter_list);
245: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
246: p_value => document_direction,

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

241: p_parameterlist => l_create_cln_parameter_list);
242: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
243: p_value => transaction_subtype,
244: p_parameterlist => l_create_cln_parameter_list);
245: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
246: p_value => document_direction,
247: p_parameterlist => l_create_cln_parameter_list);
248: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
249: p_value => l_event_key,

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

244: p_parameterlist => l_create_cln_parameter_list);
245: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
246: p_value => document_direction,
247: p_parameterlist => l_create_cln_parameter_list);
248: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
249: p_value => l_event_key,
250: p_parameterlist => l_create_cln_parameter_list);
251: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
252: p_value => party_id,

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

247: p_parameterlist => l_create_cln_parameter_list);
248: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
249: p_value => l_event_key,
250: p_parameterlist => l_create_cln_parameter_list);
251: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
252: p_value => party_id,
253: p_parameterlist => l_create_cln_parameter_list);
254: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
255: p_value => party_site_id,

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

250: p_parameterlist => l_create_cln_parameter_list);
251: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
252: p_value => party_id,
253: p_parameterlist => l_create_cln_parameter_list);
254: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
255: p_value => party_site_id,
256: p_parameterlist => l_create_cln_parameter_list);
257: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
258: p_value => party_type,

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

253: p_parameterlist => l_create_cln_parameter_list);
254: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
255: p_value => party_site_id,
256: p_parameterlist => l_create_cln_parameter_list);
257: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
258: p_value => party_type,
259: p_parameterlist => l_create_cln_parameter_list);
260: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
261: p_value => l_event_key,

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

256: p_parameterlist => l_create_cln_parameter_list);
257: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
258: p_value => party_type,
259: p_parameterlist => l_create_cln_parameter_list);
260: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
261: p_value => l_event_key,
262: p_parameterlist => l_create_cln_parameter_list);
263: wf_event.AddParameterToList(p_name => 'ORG_ID',
264: p_value => l_operating_unit_id,

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

259: p_parameterlist => l_create_cln_parameter_list);
260: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
261: p_value => l_event_key,
262: p_parameterlist => l_create_cln_parameter_list);
263: wf_event.AddParameterToList(p_name => 'ORG_ID',
264: p_value => l_operating_unit_id,
265: p_parameterlist => l_create_cln_parameter_list);
266: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
267: p_value => l_canonical_date,

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

262: p_parameterlist => l_create_cln_parameter_list);
263: wf_event.AddParameterToList(p_name => 'ORG_ID',
264: p_value => l_operating_unit_id,
265: p_parameterlist => l_create_cln_parameter_list);
266: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
267: p_value => l_canonical_date,
268: p_parameterlist => l_create_cln_parameter_list);
269:
270: x_progress := 'CLN_SYNCCTLG_PKG.Syncctlg_Raise_Event : Initialize Create Event Parameters';

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

272: cln_debug_pub.Add('Failure point ' || x_progress, 1);
273: end if;
274:
275: -- raise create collaboration event
276: wf_event.raise(p_event_name => l_create_cln_event,
277: p_event_key => l_event_key,
278: p_parameters => l_create_cln_parameter_list);
279:
280: x_progress := 'CLN_SYNCCTLG_PKG.Syncctlg_Raise_Event : Create Event Raised';

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

307: cln_debug_pub.Add('Failure point ' || x_progress, 1);
308: end if;
309:
310: -- add parameters to list for send show shipment document
311: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
312: p_value => transaction_type,
313: p_parameterlist => l_send_syct_parameter_list);
314: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
315: p_value => transaction_subtype,

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

310: -- add parameters to list for send show shipment document
311: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
312: p_value => transaction_type,
313: p_parameterlist => l_send_syct_parameter_list);
314: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
315: p_value => transaction_subtype,
316: p_parameterlist => l_send_syct_parameter_list);
317: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
318: p_value => transaction_type,

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

313: p_parameterlist => l_send_syct_parameter_list);
314: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
315: p_value => transaction_subtype,
316: p_parameterlist => l_send_syct_parameter_list);
317: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
318: p_value => transaction_type,
319: p_parameterlist => l_send_syct_parameter_list);
320: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
321: p_value => transaction_subtype,

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

316: p_parameterlist => l_send_syct_parameter_list);
317: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
318: p_value => transaction_type,
319: p_parameterlist => l_send_syct_parameter_list);
320: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
321: p_value => transaction_subtype,
322: p_parameterlist => l_send_syct_parameter_list);
323: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
324: p_value => document_direction,

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

319: p_parameterlist => l_send_syct_parameter_list);
320: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
321: p_value => transaction_subtype,
322: p_parameterlist => l_send_syct_parameter_list);
323: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
324: p_value => document_direction,
325: p_parameterlist => l_send_syct_parameter_list);
326: wf_event.AddParameterToList(p_name => 'ECX_PARTY_ID',
327: p_value => party_id,

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

322: p_parameterlist => l_send_syct_parameter_list);
323: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
324: p_value => document_direction,
325: p_parameterlist => l_send_syct_parameter_list);
326: wf_event.AddParameterToList(p_name => 'ECX_PARTY_ID',
327: p_value => party_id,
328: p_parameterlist => l_send_syct_parameter_list);
329: wf_event.AddParameterToList(p_name => 'ECX_PARTY_SITE_ID',
330: p_value => party_site_id,

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

325: p_parameterlist => l_send_syct_parameter_list);
326: wf_event.AddParameterToList(p_name => 'ECX_PARTY_ID',
327: p_value => party_id,
328: p_parameterlist => l_send_syct_parameter_list);
329: wf_event.AddParameterToList(p_name => 'ECX_PARTY_SITE_ID',
330: p_value => party_site_id,
331: p_parameterlist => l_send_syct_parameter_list);
332: wf_event.AddParameterToList(p_name => 'ECX_PARTY_TYPE',
333: p_value => party_type,

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

328: p_parameterlist => l_send_syct_parameter_list);
329: wf_event.AddParameterToList(p_name => 'ECX_PARTY_SITE_ID',
330: p_value => party_site_id,
331: p_parameterlist => l_send_syct_parameter_list);
332: wf_event.AddParameterToList(p_name => 'ECX_PARTY_TYPE',
333: p_value => party_type,
334: p_parameterlist => l_send_syct_parameter_list);
335: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
336: p_value => party_id,

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

331: p_parameterlist => l_send_syct_parameter_list);
332: wf_event.AddParameterToList(p_name => 'ECX_PARTY_TYPE',
333: p_value => party_type,
334: p_parameterlist => l_send_syct_parameter_list);
335: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
336: p_value => party_id,
337: p_parameterlist => l_send_syct_parameter_list);
338: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
339: p_value => party_site_id,

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

334: p_parameterlist => l_send_syct_parameter_list);
335: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
336: p_value => party_id,
337: p_parameterlist => l_send_syct_parameter_list);
338: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
339: p_value => party_site_id,
340: p_parameterlist => l_send_syct_parameter_list);
341: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
342: p_value => party_type,

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

337: p_parameterlist => l_send_syct_parameter_list);
338: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
339: p_value => party_site_id,
340: p_parameterlist => l_send_syct_parameter_list);
341: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
342: p_value => party_type,
343: p_parameterlist => l_send_syct_parameter_list);
344: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
345: p_value => l_event_key,

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

340: p_parameterlist => l_send_syct_parameter_list);
341: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
342: p_value => party_type,
343: p_parameterlist => l_send_syct_parameter_list);
344: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
345: p_value => l_event_key,
346: p_parameterlist => l_send_syct_parameter_list);
347: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
348: p_value => l_event_key,

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

343: p_parameterlist => l_send_syct_parameter_list);
344: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
345: p_value => l_event_key,
346: p_parameterlist => l_send_syct_parameter_list);
347: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
348: p_value => l_event_key,
349: p_parameterlist => l_send_syct_parameter_list);
350: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
351: p_value => l_event_key,

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

346: p_parameterlist => l_send_syct_parameter_list);
347: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
348: p_value => l_event_key,
349: p_parameterlist => l_send_syct_parameter_list);
350: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
351: p_value => l_event_key,
352: p_parameterlist => l_send_syct_parameter_list);
353: wf_event.AddParameterToList(p_name => 'MESSAGE_TEXT',
354: p_value => message_text,

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

349: p_parameterlist => l_send_syct_parameter_list);
350: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
351: p_value => l_event_key,
352: p_parameterlist => l_send_syct_parameter_list);
353: wf_event.AddParameterToList(p_name => 'MESSAGE_TEXT',
354: p_value => message_text,
355: p_parameterlist => l_send_syct_parameter_list);
356: wf_event.AddParameterToList(p_name => 'ORG_ID',
357: p_value => l_inv_org_id,

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

352: p_parameterlist => l_send_syct_parameter_list);
353: wf_event.AddParameterToList(p_name => 'MESSAGE_TEXT',
354: p_value => message_text,
355: p_parameterlist => l_send_syct_parameter_list);
356: wf_event.AddParameterToList(p_name => 'ORG_ID',
357: p_value => l_inv_org_id,
358: p_parameterlist => l_send_syct_parameter_list);
359: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
360: p_value => l_canonical_date,

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

355: p_parameterlist => l_send_syct_parameter_list);
356: wf_event.AddParameterToList(p_name => 'ORG_ID',
357: p_value => l_inv_org_id,
358: p_parameterlist => l_send_syct_parameter_list);
359: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
360: p_value => l_canonical_date,
361: p_parameterlist => l_send_syct_parameter_list);
362: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER1',
363: p_value => NULL,

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

358: p_parameterlist => l_send_syct_parameter_list);
359: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
360: p_value => l_canonical_date,
361: p_parameterlist => l_send_syct_parameter_list);
362: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER1',
363: p_value => NULL,
364: p_parameterlist => l_send_syct_parameter_list);
365: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER2',
366: p_value => NULL,

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

361: p_parameterlist => l_send_syct_parameter_list);
362: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER1',
363: p_value => NULL,
364: p_parameterlist => l_send_syct_parameter_list);
365: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER2',
366: p_value => NULL,
367: p_parameterlist => l_send_syct_parameter_list);
368: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER3',
369: p_value => NULL,

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

364: p_parameterlist => l_send_syct_parameter_list);
365: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER2',
366: p_value => NULL,
367: p_parameterlist => l_send_syct_parameter_list);
368: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER3',
369: p_value => NULL,
370: p_parameterlist => l_send_syct_parameter_list);
371: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER4',
372: p_value => NULL,

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

367: p_parameterlist => l_send_syct_parameter_list);
368: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER3',
369: p_value => NULL,
370: p_parameterlist => l_send_syct_parameter_list);
371: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER4',
372: p_value => NULL,
373: p_parameterlist => l_send_syct_parameter_list);
374: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER5',
375: p_value => NULL,

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

370: p_parameterlist => l_send_syct_parameter_list);
371: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER4',
372: p_value => NULL,
373: p_parameterlist => l_send_syct_parameter_list);
374: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER5',
375: p_value => NULL,
376: p_parameterlist => l_send_syct_parameter_list);
377: wf_event.AddParameterToList(p_name => 'LIST_HEADER_ID',
378: p_value => p_list_header_id,

Line 377: wf_event.AddParameterToList(p_name => 'LIST_HEADER_ID',

373: p_parameterlist => l_send_syct_parameter_list);
374: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER5',
375: p_value => NULL,
376: p_parameterlist => l_send_syct_parameter_list);
377: wf_event.AddParameterToList(p_name => 'LIST_HEADER_ID',
378: p_value => p_list_header_id,
379: p_parameterlist => l_send_syct_parameter_list);
380: wf_event.AddParameterToList(p_name => 'CATEGORY_ID',
381: p_value => p_category_id,

Line 380: wf_event.AddParameterToList(p_name => 'CATEGORY_ID',

376: p_parameterlist => l_send_syct_parameter_list);
377: wf_event.AddParameterToList(p_name => 'LIST_HEADER_ID',
378: p_value => p_list_header_id,
379: p_parameterlist => l_send_syct_parameter_list);
380: wf_event.AddParameterToList(p_name => 'CATEGORY_ID',
381: p_value => p_category_id,
382: p_parameterlist => l_send_syct_parameter_list);
383: wf_event.AddParameterToList(p_name => 'FROM_ITEMS',
384: p_value => p_from_items,

Line 383: wf_event.AddParameterToList(p_name => 'FROM_ITEMS',

379: p_parameterlist => l_send_syct_parameter_list);
380: wf_event.AddParameterToList(p_name => 'CATEGORY_ID',
381: p_value => p_category_id,
382: p_parameterlist => l_send_syct_parameter_list);
383: wf_event.AddParameterToList(p_name => 'FROM_ITEMS',
384: p_value => p_from_items,
385: p_parameterlist => l_send_syct_parameter_list);
386: wf_event.AddParameterToList(p_name => 'TO_ITEMS',
387: p_value => p_to_items,

Line 386: wf_event.AddParameterToList(p_name => 'TO_ITEMS',

382: p_parameterlist => l_send_syct_parameter_list);
383: wf_event.AddParameterToList(p_name => 'FROM_ITEMS',
384: p_value => p_from_items,
385: p_parameterlist => l_send_syct_parameter_list);
386: wf_event.AddParameterToList(p_name => 'TO_ITEMS',
387: p_value => p_to_items,
388: p_parameterlist => l_send_syct_parameter_list);
389: wf_event.AddParameterToList(p_name => 'CURRENCY',
390: p_value => p_currency_detail_id,

Line 389: wf_event.AddParameterToList(p_name => 'CURRENCY',

385: p_parameterlist => l_send_syct_parameter_list);
386: wf_event.AddParameterToList(p_name => 'TO_ITEMS',
387: p_value => p_to_items,
388: p_parameterlist => l_send_syct_parameter_list);
389: wf_event.AddParameterToList(p_name => 'CURRENCY',
390: p_value => p_currency_detail_id,
391: p_parameterlist => l_send_syct_parameter_list);
392: wf_event.AddParameterToList(p_name => 'SUBSET_FROM',
393: p_value => l_subset_from,

Line 392: wf_event.AddParameterToList(p_name => 'SUBSET_FROM',

388: p_parameterlist => l_send_syct_parameter_list);
389: wf_event.AddParameterToList(p_name => 'CURRENCY',
390: p_value => p_currency_detail_id,
391: p_parameterlist => l_send_syct_parameter_list);
392: wf_event.AddParameterToList(p_name => 'SUBSET_FROM',
393: p_value => l_subset_from,
394: p_parameterlist => l_send_syct_parameter_list);
395: wf_event.AddParameterToList(p_name => 'SUBSET_TO',
396: p_value => l_subset_to,

Line 395: wf_event.AddParameterToList(p_name => 'SUBSET_TO',

391: p_parameterlist => l_send_syct_parameter_list);
392: wf_event.AddParameterToList(p_name => 'SUBSET_FROM',
393: p_value => l_subset_from,
394: p_parameterlist => l_send_syct_parameter_list);
395: wf_event.AddParameterToList(p_name => 'SUBSET_TO',
396: p_value => l_subset_to,
397: p_parameterlist => l_send_syct_parameter_list);
398: wf_event.AddParameterToList(p_name => 'AUTH_USER_NAME',
399: p_value => l_auth_user_name,

Line 398: wf_event.AddParameterToList(p_name => 'AUTH_USER_NAME',

394: p_parameterlist => l_send_syct_parameter_list);
395: wf_event.AddParameterToList(p_name => 'SUBSET_TO',
396: p_value => l_subset_to,
397: p_parameterlist => l_send_syct_parameter_list);
398: wf_event.AddParameterToList(p_name => 'AUTH_USER_NAME',
399: p_value => l_auth_user_name,
400: p_parameterlist => l_send_syct_parameter_list);
401: wf_event.AddParameterToList(p_name => 'PUBLISHER_NAME',
402: p_value => l_auth_user_name,

Line 401: wf_event.AddParameterToList(p_name => 'PUBLISHER_NAME',

397: p_parameterlist => l_send_syct_parameter_list);
398: wf_event.AddParameterToList(p_name => 'AUTH_USER_NAME',
399: p_value => l_auth_user_name,
400: p_parameterlist => l_send_syct_parameter_list);
401: wf_event.AddParameterToList(p_name => 'PUBLISHER_NAME',
402: p_value => l_auth_user_name,
403: p_parameterlist => l_send_syct_parameter_list);
404: wf_event.AddParameterToList(p_name => 'PUBLISHER_PARTNRIDX',
405: p_value => l_auth_user_name,

Line 404: wf_event.AddParameterToList(p_name => 'PUBLISHER_PARTNRIDX',

400: p_parameterlist => l_send_syct_parameter_list);
401: wf_event.AddParameterToList(p_name => 'PUBLISHER_NAME',
402: p_value => l_auth_user_name,
403: p_parameterlist => l_send_syct_parameter_list);
404: wf_event.AddParameterToList(p_name => 'PUBLISHER_PARTNRIDX',
405: p_value => l_auth_user_name,
406: p_parameterlist => l_send_syct_parameter_list);
407:
408: x_progress := 'CLN_SYNCCTLG_PKG.Syncctlg_Raise_Event : Send Document Event Parameters Initialized';

Line 414: wf_event.raise(p_event_name => l_send_syct_event,

410: cln_debug_pub.Add('Failure point ' || x_progress, 1);
411: end if;
412:
413: -- raise event for send show shipment document
414: wf_event.raise(p_event_name => l_send_syct_event,
415: p_event_key => l_event_key,
416: p_parameters => l_send_syct_parameter_list);
417:
418: -- Reached Here. Successful execution.

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

428: end if;
429:
430: -- add parameters to list for update collaboration event
431: l_update_cln_parameter_list := wf_parameter_list_t();
432: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
433: p_value => transaction_type,
434: p_parameterlist => l_update_cln_parameter_list);
435: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
436: p_value => transaction_subtype,

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

431: l_update_cln_parameter_list := wf_parameter_list_t();
432: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
433: p_value => transaction_type,
434: p_parameterlist => l_update_cln_parameter_list);
435: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
436: p_value => transaction_subtype,
437: p_parameterlist => l_update_cln_parameter_list);
438: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
439: p_value => document_direction,

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

434: p_parameterlist => l_update_cln_parameter_list);
435: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
436: p_value => transaction_subtype,
437: p_parameterlist => l_update_cln_parameter_list);
438: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
439: p_value => document_direction,
440: p_parameterlist => l_update_cln_parameter_list);
441: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
442: p_value => l_event_key,

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

437: p_parameterlist => l_update_cln_parameter_list);
438: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
439: p_value => document_direction,
440: p_parameterlist => l_update_cln_parameter_list);
441: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
442: p_value => l_event_key,
443: p_parameterlist => l_update_cln_parameter_list);
444: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
445: p_value => party_id,

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

440: p_parameterlist => l_update_cln_parameter_list);
441: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
442: p_value => l_event_key,
443: p_parameterlist => l_update_cln_parameter_list);
444: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
445: p_value => party_id,
446: p_parameterlist => l_update_cln_parameter_list);
447: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
448: p_value => party_site_id,

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

443: p_parameterlist => l_update_cln_parameter_list);
444: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
445: p_value => party_id,
446: p_parameterlist => l_update_cln_parameter_list);
447: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
448: p_value => party_site_id,
449: p_parameterlist => l_update_cln_parameter_list);
450: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
451: p_value => party_type,

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

446: p_parameterlist => l_update_cln_parameter_list);
447: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
448: p_value => party_site_id,
449: p_parameterlist => l_update_cln_parameter_list);
450: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
451: p_value => party_type,
452: p_parameterlist => l_update_cln_parameter_list);
453: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
454: p_value => l_event_key,

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

449: p_parameterlist => l_update_cln_parameter_list);
450: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
451: p_value => party_type,
452: p_parameterlist => l_update_cln_parameter_list);
453: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
454: p_value => l_event_key,
455: p_parameterlist => l_update_cln_parameter_list);
456: wf_event.AddParameterToList(p_name => 'ORG_ID',
457: p_value => l_operating_unit_id,

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

452: p_parameterlist => l_update_cln_parameter_list);
453: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
454: p_value => l_event_key,
455: p_parameterlist => l_update_cln_parameter_list);
456: wf_event.AddParameterToList(p_name => 'ORG_ID',
457: p_value => l_operating_unit_id,
458: p_parameterlist => l_update_cln_parameter_list);
459: wf_event.AddParameterToList(p_name => 'DOCUMENT_STATUS',
460: p_value => 'ERROR',

Line 459: wf_event.AddParameterToList(p_name => 'DOCUMENT_STATUS',

455: p_parameterlist => l_update_cln_parameter_list);
456: wf_event.AddParameterToList(p_name => 'ORG_ID',
457: p_value => l_operating_unit_id,
458: p_parameterlist => l_update_cln_parameter_list);
459: wf_event.AddParameterToList(p_name => 'DOCUMENT_STATUS',
460: p_value => 'ERROR',
461: p_parameterlist => l_update_cln_parameter_list);
462: wf_event.AddParameterToList(p_name => 'MESSAGE_TEXT',
463: p_value => no_items_message_text,

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

458: p_parameterlist => l_update_cln_parameter_list);
459: wf_event.AddParameterToList(p_name => 'DOCUMENT_STATUS',
460: p_value => 'ERROR',
461: p_parameterlist => l_update_cln_parameter_list);
462: wf_event.AddParameterToList(p_name => 'MESSAGE_TEXT',
463: p_value => no_items_message_text,
464: p_parameterlist => l_update_cln_parameter_list);
465: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
466: p_value => l_canonical_date,

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

461: p_parameterlist => l_update_cln_parameter_list);
462: wf_event.AddParameterToList(p_name => 'MESSAGE_TEXT',
463: p_value => no_items_message_text,
464: p_parameterlist => l_update_cln_parameter_list);
465: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
466: p_value => l_canonical_date,
467: p_parameterlist => l_update_cln_parameter_list);
468:
469: x_progress := 'CLN_SYNCITEM_PKG.Syncctlg_Raise_Event : Initialize update event parameters';

Line 475: wf_event.raise(p_event_name => l_update_cln_event,

471: cln_debug_pub.Add('Failure point ' || x_progress, 1);
472: end if;
473:
474: -- raise update collaboration event
475: wf_event.raise(p_event_name => l_update_cln_event,
476: p_event_key => l_event_key,
477: p_parameters => l_update_cln_parameter_list);
478:
479: x_progress := 'CLN_SYNCITEM_PKG.Syncctlg_Raise_Event : Update Event Raised';

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

568:
569: EXIT WHEN items_exist = FALSE; -- if we reached the end, then no items to send
570:
571: -- add parameters to list for create collaboration event
572: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
573: p_value => transaction_type,
574: p_parameterlist => l_create_cln_parameter_list);
575: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
576: p_value => transaction_subtype,

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

571: -- add parameters to list for create collaboration event
572: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
573: p_value => transaction_type,
574: p_parameterlist => l_create_cln_parameter_list);
575: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
576: p_value => transaction_subtype,
577: p_parameterlist => l_create_cln_parameter_list);
578: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
579: p_value => document_direction,

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

574: p_parameterlist => l_create_cln_parameter_list);
575: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
576: p_value => transaction_subtype,
577: p_parameterlist => l_create_cln_parameter_list);
578: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
579: p_value => document_direction,
580: p_parameterlist => l_create_cln_parameter_list);
581: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
582: p_value => l_event_key,

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

577: p_parameterlist => l_create_cln_parameter_list);
578: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
579: p_value => document_direction,
580: p_parameterlist => l_create_cln_parameter_list);
581: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
582: p_value => l_event_key,
583: p_parameterlist => l_create_cln_parameter_list);
584: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
585: p_value => party_id,

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

580: p_parameterlist => l_create_cln_parameter_list);
581: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
582: p_value => l_event_key,
583: p_parameterlist => l_create_cln_parameter_list);
584: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
585: p_value => party_id,
586: p_parameterlist => l_create_cln_parameter_list);
587: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
588: p_value => party_site_id,

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

583: p_parameterlist => l_create_cln_parameter_list);
584: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
585: p_value => party_id,
586: p_parameterlist => l_create_cln_parameter_list);
587: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
588: p_value => party_site_id,
589: p_parameterlist => l_create_cln_parameter_list);
590: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
591: p_value => party_type,

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

586: p_parameterlist => l_create_cln_parameter_list);
587: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
588: p_value => party_site_id,
589: p_parameterlist => l_create_cln_parameter_list);
590: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
591: p_value => party_type,
592: p_parameterlist => l_create_cln_parameter_list);
593: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
594: p_value => l_event_key,

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

589: p_parameterlist => l_create_cln_parameter_list);
590: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
591: p_value => party_type,
592: p_parameterlist => l_create_cln_parameter_list);
593: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
594: p_value => l_event_key,
595: p_parameterlist => l_create_cln_parameter_list);
596: wf_event.AddParameterToList(p_name => 'ORG_ID',
597: p_value => l_operating_unit_id,

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

592: p_parameterlist => l_create_cln_parameter_list);
593: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
594: p_value => l_event_key,
595: p_parameterlist => l_create_cln_parameter_list);
596: wf_event.AddParameterToList(p_name => 'ORG_ID',
597: p_value => l_operating_unit_id,
598: p_parameterlist => l_create_cln_parameter_list);
599: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
600: p_value => l_canonical_date,

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

595: p_parameterlist => l_create_cln_parameter_list);
596: wf_event.AddParameterToList(p_name => 'ORG_ID',
597: p_value => l_operating_unit_id,
598: p_parameterlist => l_create_cln_parameter_list);
599: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
600: p_value => l_canonical_date,
601: p_parameterlist => l_create_cln_parameter_list);
602:
603: x_progress := 'CLN_SYNCCTLG_PKG.Syncctlg_Raise_Event : Create Event Parameters Setup';

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

605: cln_debug_pub.Add('Failure point ' || x_progress, 1);
606: end if;
607:
608: -- raise create collaboration event
609: wf_event.raise(p_event_name => l_create_cln_event,
610: p_event_key => l_event_key,
611: p_parameters => l_create_cln_parameter_list);
612:
613: x_progress := 'CLN_SYNCCTLG_PKG.Syncctlg_Raise_Event : Create Event Raised';

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

615: cln_debug_pub.Add('Failure point ' || x_progress, 1);
616: end if;
617:
618: -- add parameters to list for send show shipment document
619: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
620: p_value => transaction_type,
621: p_parameterlist => l_send_syct_parameter_list);
622: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
623: p_value => transaction_subtype,

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

618: -- add parameters to list for send show shipment document
619: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
620: p_value => transaction_type,
621: p_parameterlist => l_send_syct_parameter_list);
622: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
623: p_value => transaction_subtype,
624: p_parameterlist => l_send_syct_parameter_list);
625: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
626: p_value => transaction_type,

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

621: p_parameterlist => l_send_syct_parameter_list);
622: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
623: p_value => transaction_subtype,
624: p_parameterlist => l_send_syct_parameter_list);
625: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
626: p_value => transaction_type,
627: p_parameterlist => l_send_syct_parameter_list);
628: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
629: p_value => transaction_subtype,

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

624: p_parameterlist => l_send_syct_parameter_list);
625: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
626: p_value => transaction_type,
627: p_parameterlist => l_send_syct_parameter_list);
628: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
629: p_value => transaction_subtype,
630: p_parameterlist => l_send_syct_parameter_list);
631: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
632: p_value => document_direction,

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

627: p_parameterlist => l_send_syct_parameter_list);
628: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
629: p_value => transaction_subtype,
630: p_parameterlist => l_send_syct_parameter_list);
631: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
632: p_value => document_direction,
633: p_parameterlist => l_send_syct_parameter_list);
634: wf_event.AddParameterToList(p_name => 'ECX_PARTY_ID',
635: p_value => party_id,

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

630: p_parameterlist => l_send_syct_parameter_list);
631: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
632: p_value => document_direction,
633: p_parameterlist => l_send_syct_parameter_list);
634: wf_event.AddParameterToList(p_name => 'ECX_PARTY_ID',
635: p_value => party_id,
636: p_parameterlist => l_send_syct_parameter_list);
637: wf_event.AddParameterToList(p_name => 'ECX_PARTY_SITE_ID',
638: p_value => party_site_id,

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

633: p_parameterlist => l_send_syct_parameter_list);
634: wf_event.AddParameterToList(p_name => 'ECX_PARTY_ID',
635: p_value => party_id,
636: p_parameterlist => l_send_syct_parameter_list);
637: wf_event.AddParameterToList(p_name => 'ECX_PARTY_SITE_ID',
638: p_value => party_site_id,
639: p_parameterlist => l_send_syct_parameter_list);
640: wf_event.AddParameterToList(p_name => 'ECX_PARTY_TYPE',
641: p_value => party_type,

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

636: p_parameterlist => l_send_syct_parameter_list);
637: wf_event.AddParameterToList(p_name => 'ECX_PARTY_SITE_ID',
638: p_value => party_site_id,
639: p_parameterlist => l_send_syct_parameter_list);
640: wf_event.AddParameterToList(p_name => 'ECX_PARTY_TYPE',
641: p_value => party_type,
642: p_parameterlist => l_send_syct_parameter_list);
643: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
644: p_value => party_id,

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

639: p_parameterlist => l_send_syct_parameter_list);
640: wf_event.AddParameterToList(p_name => 'ECX_PARTY_TYPE',
641: p_value => party_type,
642: p_parameterlist => l_send_syct_parameter_list);
643: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
644: p_value => party_id,
645: p_parameterlist => l_send_syct_parameter_list);
646: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
647: p_value => party_site_id,

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

642: p_parameterlist => l_send_syct_parameter_list);
643: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
644: p_value => party_id,
645: p_parameterlist => l_send_syct_parameter_list);
646: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
647: p_value => party_site_id,
648: p_parameterlist => l_send_syct_parameter_list);
649: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
650: p_value => party_type,

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

645: p_parameterlist => l_send_syct_parameter_list);
646: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
647: p_value => party_site_id,
648: p_parameterlist => l_send_syct_parameter_list);
649: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
650: p_value => party_type,
651: p_parameterlist => l_send_syct_parameter_list);
652: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
653: p_value => l_event_key,

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

648: p_parameterlist => l_send_syct_parameter_list);
649: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
650: p_value => party_type,
651: p_parameterlist => l_send_syct_parameter_list);
652: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
653: p_value => l_event_key,
654: p_parameterlist => l_send_syct_parameter_list);
655: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
656: p_value => l_event_key,

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

651: p_parameterlist => l_send_syct_parameter_list);
652: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
653: p_value => l_event_key,
654: p_parameterlist => l_send_syct_parameter_list);
655: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
656: p_value => l_event_key,
657: p_parameterlist => l_send_syct_parameter_list);
658: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
659: p_value => l_event_key,

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

654: p_parameterlist => l_send_syct_parameter_list);
655: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
656: p_value => l_event_key,
657: p_parameterlist => l_send_syct_parameter_list);
658: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
659: p_value => l_event_key,
660: p_parameterlist => l_send_syct_parameter_list);
661: wf_event.AddParameterToList(p_name => 'MESSAGE_TEXT',
662: p_value => message_text,

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

657: p_parameterlist => l_send_syct_parameter_list);
658: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
659: p_value => l_event_key,
660: p_parameterlist => l_send_syct_parameter_list);
661: wf_event.AddParameterToList(p_name => 'MESSAGE_TEXT',
662: p_value => message_text,
663: p_parameterlist => l_send_syct_parameter_list);
664: wf_event.AddParameterToList(p_name => 'ORG_ID',
665: p_value => l_inv_org_id,

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

660: p_parameterlist => l_send_syct_parameter_list);
661: wf_event.AddParameterToList(p_name => 'MESSAGE_TEXT',
662: p_value => message_text,
663: p_parameterlist => l_send_syct_parameter_list);
664: wf_event.AddParameterToList(p_name => 'ORG_ID',
665: p_value => l_inv_org_id,
666: p_parameterlist => l_send_syct_parameter_list);
667: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
668: p_value => l_canonical_date,

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

663: p_parameterlist => l_send_syct_parameter_list);
664: wf_event.AddParameterToList(p_name => 'ORG_ID',
665: p_value => l_inv_org_id,
666: p_parameterlist => l_send_syct_parameter_list);
667: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
668: p_value => l_canonical_date,
669: p_parameterlist => l_send_syct_parameter_list);
670: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER1',
671: p_value => NULL,

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

666: p_parameterlist => l_send_syct_parameter_list);
667: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
668: p_value => l_canonical_date,
669: p_parameterlist => l_send_syct_parameter_list);
670: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER1',
671: p_value => NULL,
672: p_parameterlist => l_send_syct_parameter_list);
673: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER2',
674: p_value => NULL,

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

669: p_parameterlist => l_send_syct_parameter_list);
670: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER1',
671: p_value => NULL,
672: p_parameterlist => l_send_syct_parameter_list);
673: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER2',
674: p_value => NULL,
675: p_parameterlist => l_send_syct_parameter_list);
676: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER3',
677: p_value => NULL,

Line 676: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER3',

672: p_parameterlist => l_send_syct_parameter_list);
673: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER2',
674: p_value => NULL,
675: p_parameterlist => l_send_syct_parameter_list);
676: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER3',
677: p_value => NULL,
678: p_parameterlist => l_send_syct_parameter_list);
679: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER4',
680: p_value => NULL,

Line 679: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER4',

675: p_parameterlist => l_send_syct_parameter_list);
676: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER3',
677: p_value => NULL,
678: p_parameterlist => l_send_syct_parameter_list);
679: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER4',
680: p_value => NULL,
681: p_parameterlist => l_send_syct_parameter_list);
682: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER5',
683: p_value => NULL,

Line 682: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER5',

678: p_parameterlist => l_send_syct_parameter_list);
679: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER4',
680: p_value => NULL,
681: p_parameterlist => l_send_syct_parameter_list);
682: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER5',
683: p_value => NULL,
684: p_parameterlist => l_send_syct_parameter_list);
685: wf_event.AddParameterToList(p_name => 'LIST_HEADER_ID',
686: p_value => p_list_header_id,

Line 685: wf_event.AddParameterToList(p_name => 'LIST_HEADER_ID',

681: p_parameterlist => l_send_syct_parameter_list);
682: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER5',
683: p_value => NULL,
684: p_parameterlist => l_send_syct_parameter_list);
685: wf_event.AddParameterToList(p_name => 'LIST_HEADER_ID',
686: p_value => p_list_header_id,
687: p_parameterlist => l_send_syct_parameter_list);
688: wf_event.AddParameterToList(p_name => 'CATEGORY_ID',
689: p_value => p_category_id,

Line 688: wf_event.AddParameterToList(p_name => 'CATEGORY_ID',

684: p_parameterlist => l_send_syct_parameter_list);
685: wf_event.AddParameterToList(p_name => 'LIST_HEADER_ID',
686: p_value => p_list_header_id,
687: p_parameterlist => l_send_syct_parameter_list);
688: wf_event.AddParameterToList(p_name => 'CATEGORY_ID',
689: p_value => p_category_id,
690: p_parameterlist => l_send_syct_parameter_list);
691: wf_event.AddParameterToList(p_name => 'FROM_ITEMS',
692: p_value => p_from_items,

Line 691: wf_event.AddParameterToList(p_name => 'FROM_ITEMS',

687: p_parameterlist => l_send_syct_parameter_list);
688: wf_event.AddParameterToList(p_name => 'CATEGORY_ID',
689: p_value => p_category_id,
690: p_parameterlist => l_send_syct_parameter_list);
691: wf_event.AddParameterToList(p_name => 'FROM_ITEMS',
692: p_value => p_from_items,
693: p_parameterlist => l_send_syct_parameter_list);
694: wf_event.AddParameterToList(p_name => 'TO_ITEMS',
695: p_value => p_to_items,

Line 694: wf_event.AddParameterToList(p_name => 'TO_ITEMS',

690: p_parameterlist => l_send_syct_parameter_list);
691: wf_event.AddParameterToList(p_name => 'FROM_ITEMS',
692: p_value => p_from_items,
693: p_parameterlist => l_send_syct_parameter_list);
694: wf_event.AddParameterToList(p_name => 'TO_ITEMS',
695: p_value => p_to_items,
696: p_parameterlist => l_send_syct_parameter_list);
697: wf_event.AddParameterToList(p_name => 'CURRENCY',
698: p_value => p_currency_detail_id,

Line 697: wf_event.AddParameterToList(p_name => 'CURRENCY',

693: p_parameterlist => l_send_syct_parameter_list);
694: wf_event.AddParameterToList(p_name => 'TO_ITEMS',
695: p_value => p_to_items,
696: p_parameterlist => l_send_syct_parameter_list);
697: wf_event.AddParameterToList(p_name => 'CURRENCY',
698: p_value => p_currency_detail_id,
699: p_parameterlist => l_send_syct_parameter_list);
700: wf_event.AddParameterToList(p_name => 'SUBSET_FROM',
701: p_value => l_subset_from,

Line 700: wf_event.AddParameterToList(p_name => 'SUBSET_FROM',

696: p_parameterlist => l_send_syct_parameter_list);
697: wf_event.AddParameterToList(p_name => 'CURRENCY',
698: p_value => p_currency_detail_id,
699: p_parameterlist => l_send_syct_parameter_list);
700: wf_event.AddParameterToList(p_name => 'SUBSET_FROM',
701: p_value => l_subset_from,
702: p_parameterlist => l_send_syct_parameter_list);
703: wf_event.AddParameterToList(p_name => 'SUBSET_TO',
704: p_value => l_subset_to,

Line 703: wf_event.AddParameterToList(p_name => 'SUBSET_TO',

699: p_parameterlist => l_send_syct_parameter_list);
700: wf_event.AddParameterToList(p_name => 'SUBSET_FROM',
701: p_value => l_subset_from,
702: p_parameterlist => l_send_syct_parameter_list);
703: wf_event.AddParameterToList(p_name => 'SUBSET_TO',
704: p_value => l_subset_to,
705: p_parameterlist => l_send_syct_parameter_list);
706: wf_event.AddParameterToList(p_name => 'AUTH_USER_NAME',
707: p_value => l_auth_user_name,

Line 706: wf_event.AddParameterToList(p_name => 'AUTH_USER_NAME',

702: p_parameterlist => l_send_syct_parameter_list);
703: wf_event.AddParameterToList(p_name => 'SUBSET_TO',
704: p_value => l_subset_to,
705: p_parameterlist => l_send_syct_parameter_list);
706: wf_event.AddParameterToList(p_name => 'AUTH_USER_NAME',
707: p_value => l_auth_user_name,
708: p_parameterlist => l_send_syct_parameter_list);
709: wf_event.AddParameterToList(p_name => 'PUBLISHER_NAME',
710: p_value => l_auth_user_name,

Line 709: wf_event.AddParameterToList(p_name => 'PUBLISHER_NAME',

705: p_parameterlist => l_send_syct_parameter_list);
706: wf_event.AddParameterToList(p_name => 'AUTH_USER_NAME',
707: p_value => l_auth_user_name,
708: p_parameterlist => l_send_syct_parameter_list);
709: wf_event.AddParameterToList(p_name => 'PUBLISHER_NAME',
710: p_value => l_auth_user_name,
711: p_parameterlist => l_send_syct_parameter_list);
712: wf_event.AddParameterToList(p_name => 'PUBLISHER_PARTNRIDX',
713: p_value => l_auth_user_name,

Line 712: wf_event.AddParameterToList(p_name => 'PUBLISHER_PARTNRIDX',

708: p_parameterlist => l_send_syct_parameter_list);
709: wf_event.AddParameterToList(p_name => 'PUBLISHER_NAME',
710: p_value => l_auth_user_name,
711: p_parameterlist => l_send_syct_parameter_list);
712: wf_event.AddParameterToList(p_name => 'PUBLISHER_PARTNRIDX',
713: p_value => l_auth_user_name,
714: p_parameterlist => l_send_syct_parameter_list);
715:
716: x_progress := 'CLN_SYNCCTLG_PKG.Syncctlg_Raise_Event : Initialize Send Document Parameters';

Line 722: wf_event.raise(p_event_name => l_send_syct_event,

718: cln_debug_pub.Add('Failure point ' || x_progress, 1);
719: end if;
720:
721: -- raise event for send show shipment document
722: wf_event.raise(p_event_name => l_send_syct_event,
723: p_event_key => l_event_key,
724: p_parameters => l_send_syct_parameter_list);
725:
726: -- set flag to say that at least one message was previously sent

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

746: end if;
747:
748: -- add parameters to list for update collaboration event
749: l_update_cln_parameter_list := wf_parameter_list_t();
750: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
751: p_value => transaction_type,
752: p_parameterlist => l_update_cln_parameter_list);
753: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
754: p_value => transaction_subtype,

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

749: l_update_cln_parameter_list := wf_parameter_list_t();
750: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',
751: p_value => transaction_type,
752: p_parameterlist => l_update_cln_parameter_list);
753: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
754: p_value => transaction_subtype,
755: p_parameterlist => l_update_cln_parameter_list);
756: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
757: p_value => document_direction,

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

752: p_parameterlist => l_update_cln_parameter_list);
753: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_SUBTYPE',
754: p_value => transaction_subtype,
755: p_parameterlist => l_update_cln_parameter_list);
756: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
757: p_value => document_direction,
758: p_parameterlist => l_update_cln_parameter_list);
759: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
760: p_value => l_event_key,

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

755: p_parameterlist => l_update_cln_parameter_list);
756: wf_event.AddParameterToList(p_name => 'DOCUMENT_DIRECTION',
757: p_value => document_direction,
758: p_parameterlist => l_update_cln_parameter_list);
759: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
760: p_value => l_event_key,
761: p_parameterlist => l_update_cln_parameter_list);
762: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
763: p_value => party_id,

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

758: p_parameterlist => l_update_cln_parameter_list);
759: wf_event.AddParameterToList(p_name => 'XMLG_DOCUMENT_ID',
760: p_value => l_event_key,
761: p_parameterlist => l_update_cln_parameter_list);
762: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
763: p_value => party_id,
764: p_parameterlist => l_update_cln_parameter_list);
765: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
766: p_value => party_site_id,

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

761: p_parameterlist => l_update_cln_parameter_list);
762: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_ID',
763: p_value => party_id,
764: p_parameterlist => l_update_cln_parameter_list);
765: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
766: p_value => party_site_id,
767: p_parameterlist => l_update_cln_parameter_list);
768: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
769: p_value => party_type,

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

764: p_parameterlist => l_update_cln_parameter_list);
765: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_SITE',
766: p_value => party_site_id,
767: p_parameterlist => l_update_cln_parameter_list);
768: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
769: p_value => party_type,
770: p_parameterlist => l_update_cln_parameter_list);
771: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
772: p_value => l_event_key,

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

767: p_parameterlist => l_update_cln_parameter_list);
768: wf_event.AddParameterToList(p_name => 'TRADING_PARTNER_TYPE',
769: p_value => party_type,
770: p_parameterlist => l_update_cln_parameter_list);
771: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
772: p_value => l_event_key,
773: p_parameterlist => l_update_cln_parameter_list);
774: wf_event.AddParameterToList(p_name => 'ORG_ID',
775: p_value => l_operating_unit_id,

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

770: p_parameterlist => l_update_cln_parameter_list);
771: wf_event.AddParameterToList(p_name => 'DOCUMENT_NO',
772: p_value => l_event_key,
773: p_parameterlist => l_update_cln_parameter_list);
774: wf_event.AddParameterToList(p_name => 'ORG_ID',
775: p_value => l_operating_unit_id,
776: p_parameterlist => l_update_cln_parameter_list);
777: wf_event.AddParameterToList(p_name => 'DOCUMENT_STATUS',
778: p_value => 'ERROR',

Line 777: wf_event.AddParameterToList(p_name => 'DOCUMENT_STATUS',

773: p_parameterlist => l_update_cln_parameter_list);
774: wf_event.AddParameterToList(p_name => 'ORG_ID',
775: p_value => l_operating_unit_id,
776: p_parameterlist => l_update_cln_parameter_list);
777: wf_event.AddParameterToList(p_name => 'DOCUMENT_STATUS',
778: p_value => 'ERROR',
779: p_parameterlist => l_update_cln_parameter_list);
780: wf_event.AddParameterToList(p_name => 'MESSAGE_TEXT',
781: p_value => no_items_message_text,

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

776: p_parameterlist => l_update_cln_parameter_list);
777: wf_event.AddParameterToList(p_name => 'DOCUMENT_STATUS',
778: p_value => 'ERROR',
779: p_parameterlist => l_update_cln_parameter_list);
780: wf_event.AddParameterToList(p_name => 'MESSAGE_TEXT',
781: p_value => no_items_message_text,
782: p_parameterlist => l_update_cln_parameter_list);
783: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
784: p_value => l_canonical_date,

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

779: p_parameterlist => l_update_cln_parameter_list);
780: wf_event.AddParameterToList(p_name => 'MESSAGE_TEXT',
781: p_value => no_items_message_text,
782: p_parameterlist => l_update_cln_parameter_list);
783: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
784: p_value => l_canonical_date,
785: p_parameterlist => l_update_cln_parameter_list);
786:
787: x_progress := 'CLN_SYNCCTLG_PKG.Syncctlg_Raise_Event : Initialized update event parameters';

Line 793: wf_event.raise(p_event_name => l_update_cln_event,

789: cln_debug_pub.Add('Failure point ' || x_progress, 1);
790: end if;
791:
792: -- raise update collaboration event
793: wf_event.raise(p_event_name => l_update_cln_event,
794: p_event_key => l_event_key,
795: p_parameters => l_update_cln_parameter_list);
796:
797: x_progress := 'CLN_SYNCCTLG_PKG.Syncctlg_Raise_Event : Update Event Raised';