368: -----------------------------------------------------------
369: -- Non-CLN params
370: -----------------------------------------------------------
371:
372: wf_event.AddParameterToList(p_name=> 'ORDER_SOURCE_ID',
373: p_value=> p_order_source_id,
374: p_parameterlist=> l_parameter_list);
375:
376: wf_event.AddParameterToList(p_name=> 'SOLD_TO_ORG_ID',
372: wf_event.AddParameterToList(p_name=> 'ORDER_SOURCE_ID',
373: p_value=> p_order_source_id,
374: p_parameterlist=> l_parameter_list);
375:
376: wf_event.AddParameterToList(p_name=> 'SOLD_TO_ORG_ID',
377: p_value=> p_sold_to_org_id,
378: p_parameterlist=> l_parameter_list);
379:
380: wf_event.AddParameterToList(p_name=> 'PROCESSING_STAGE',
376: wf_event.AddParameterToList(p_name=> 'SOLD_TO_ORG_ID',
377: p_value=> p_sold_to_org_id,
378: p_parameterlist=> l_parameter_list);
379:
380: wf_event.AddParameterToList(p_name=> 'PROCESSING_STAGE',
381: p_value=> l_processing,
382: p_parameterlist=> l_parameter_list);
383:
384: IF l_document_id IS NULL THEN
385: l_document_id := to_number(l_eventkey); -- reuse the eventkey if necessary
386: END IF;
387:
388: IF l_transaction_type IN ('855','865') THEN
389: wf_event.AddParameterToList(p_name=> 'XMLG_DOCUMENT_ID',
390: p_value=> l_document_id,
391: p_parameterlist=> l_parameter_list);
392: l_order_processed_flag := 'Y';
393: ELSE
390: p_value=> l_document_id,
391: p_parameterlist=> l_parameter_list);
392: l_order_processed_flag := 'Y';
393: ELSE
394: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_CONTROL_NUMBER',
395: p_value=> l_document_id,
396: p_parameterlist=> l_parameter_list);
397: l_order_processed_flag := 'N';
398: END IF;
396: p_parameterlist=> l_parameter_list);
397: l_order_processed_flag := 'N';
398: END IF;
399:
400: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_TYPE',
401: p_value=> 'ONT',
402: p_parameterlist=> l_parameter_list);
403:
404: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_SUBTYPE',
400: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_TYPE',
401: p_value=> 'ONT',
402: p_parameterlist=> l_parameter_list);
403:
404: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_SUBTYPE',
405: p_value=> l_transaction_type,
406: p_parameterlist=> l_parameter_list);
407:
408: wf_event.AddParameterToList(p_name=> 'PARTNER_DOCUMENT_NO',
404: wf_event.AddParameterToList(p_name=> 'XMLG_INTERNAL_TXN_SUBTYPE',
405: p_value=> l_transaction_type,
406: p_parameterlist=> l_parameter_list);
407:
408: wf_event.AddParameterToList(p_name=> 'PARTNER_DOCUMENT_NO',
409: p_value=> p_orig_sys_document_ref,
410: p_parameterlist=> l_parameter_list);
411:
412: wf_event.AddParameterToList(p_name=> 'DOCUMENT_NO',
408: wf_event.AddParameterToList(p_name=> 'PARTNER_DOCUMENT_NO',
409: p_value=> p_orig_sys_document_ref,
410: p_parameterlist=> l_parameter_list);
411:
412: wf_event.AddParameterToList(p_name=> 'DOCUMENT_NO',
413: p_value=> l_order_number,
414: p_parameterlist=> l_parameter_list);
415:
416: wf_event.AddParameterToList(p_name=> 'DOCUMENT_REVISION_NO',
412: wf_event.AddParameterToList(p_name=> 'DOCUMENT_NO',
413: p_value=> l_order_number,
414: p_parameterlist=> l_parameter_list);
415:
416: wf_event.AddParameterToList(p_name=> 'DOCUMENT_REVISION_NO',
417: p_value=> p_change_sequence,
418: p_parameterlist=> l_parameter_list);
419:
420: IF l_org_id IS NULL THEN
423: INTO l_org_id
424: FROM DUAL;
425: END IF;
426:
427: wf_event.AddParameterToList(p_name=> 'ORG_ID',
428: p_value=> l_org_id,
429: p_parameterlist=> l_parameter_list);
430:
431:
428: p_value=> l_org_id,
429: p_parameterlist=> l_parameter_list);
430:
431:
432: wf_event.AddParameterToList(p_name=> 'ONT_DOC_STATUS',
433: p_value=> l_status,
434: p_parameterlist=> l_parameter_list);
435:
436: wf_event.AddParameterToList(p_name=> 'MESSAGE_TEXT',
432: wf_event.AddParameterToList(p_name=> 'ONT_DOC_STATUS',
433: p_value=> l_status,
434: p_parameterlist=> l_parameter_list);
435:
436: wf_event.AddParameterToList(p_name=> 'MESSAGE_TEXT',
437: p_value=> l_message_text,
438: p_parameterlist=> l_parameter_list);
439:
440: wf_event.AddParameterToList(p_name=> 'SUBSCRIBER_LIST',
436: wf_event.AddParameterToList(p_name=> 'MESSAGE_TEXT',
437: p_value=> l_message_text,
438: p_parameterlist=> l_parameter_list);
439:
440: wf_event.AddParameterToList(p_name=> 'SUBSCRIBER_LIST',
441: p_value=> 'ONT',
442: p_parameterlist=> l_parameter_list);
443:
444: wf_event.AddParameterToList(p_name=> 'ORDER_TYPE_ID',
440: wf_event.AddParameterToList(p_name=> 'SUBSCRIBER_LIST',
441: p_value=> 'ONT',
442: p_parameterlist=> l_parameter_list);
443:
444: wf_event.AddParameterToList(p_name=> 'ORDER_TYPE_ID',
445: p_value=> p_order_type_id,
446: p_parameterlist=> l_parameter_list);
447:
448: wf_event.AddParameterToList(p_name=> 'HEADER_ID',
444: wf_event.AddParameterToList(p_name=> 'ORDER_TYPE_ID',
445: p_value=> p_order_type_id,
446: p_parameterlist=> l_parameter_list);
447:
448: wf_event.AddParameterToList(p_name=> 'HEADER_ID',
449: p_value=> p_header_id,
450: p_parameterlist=> l_parameter_list);
451:
452: wf_event.AddParameterToList(p_name=> 'ORDER_PROCESSED_FLAG',
448: wf_event.AddParameterToList(p_name=> 'HEADER_ID',
449: p_value=> p_header_id,
450: p_parameterlist=> l_parameter_list);
451:
452: wf_event.AddParameterToList(p_name=> 'ORDER_PROCESSED_FLAG',
453: p_value=> l_order_processed_flag,
454: p_parameterlist=> l_parameter_list);
455:
456: wf_event.raise( p_event_name => 'oracle.apps.ont.oi.xml_int.status',
452: wf_event.AddParameterToList(p_name=> 'ORDER_PROCESSED_FLAG',
453: p_value=> l_order_processed_flag,
454: p_parameterlist=> l_parameter_list);
455:
456: wf_event.raise( p_event_name => 'oracle.apps.ont.oi.xml_int.status',
457: p_event_key => l_eventkey,
458: p_parameters => l_parameter_list);
459:
460: l_parameter_list.delete;