405: FETCH get_event_key INTO l_event_key;
406: CLOSE get_event_key;
407:
408: -- Now add the parameters to the list to be passed to the workflow
409: wf_event.addparametertolist(
410: p_name => 'EVENT_NAME',
411: p_value => l_event_name,
412: p_parameterlist => l_parameter_list
413: );
410: p_name => 'EVENT_NAME',
411: p_value => l_event_name,
412: p_parameterlist => l_parameter_list
413: );
414: wf_event.addparametertolist(
415: p_name => 'EVENT_KEY',
416: p_value => l_event_key,
417: p_parameterlist => l_parameter_list
418: );
415: p_name => 'EVENT_KEY',
416: p_value => l_event_key,
417: p_parameterlist => l_parameter_list
418: );
419: wf_event.addparametertolist(
420: p_name => 'ECX_MAP_CODE',
421: p_value => l_map_code,
422: p_parameterlist => l_parameter_list
423: );
420: p_name => 'ECX_MAP_CODE',
421: p_value => l_map_code,
422: p_parameterlist => l_parameter_list
423: );
424: wf_event.addparametertolist(
425: p_name => 'ECX_PARAMETER1',
426: p_value => l_doc_id,
427: p_parameterlist => l_parameter_list
428: );
430: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
431: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','Raising business event with key: ' || l_event_key);
432: END IF;
433: -- raise the business event
434: wf_event.RAISE (
435: p_event_name => l_event_name,
436: p_event_key => l_event_key,
437: p_parameters => l_parameter_list
438: );
460: resultout OUT NOCOPY VARCHAR2
461: )
462: AS
463: l_doc_id VARCHAR2(30);
464: l_wf_event wf_event_t;
465: newxmldoc CLOB;
466: buffer VARCHAR2(32767);
467:
468: BEGIN
536: -- set the workflow attributes
537: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
538: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','Before setting workflow attributes');
539: END IF;
540: wf_event_t.Initialize(l_wf_event);
541: l_wf_event.setEventData(newxmldoc);
542: wf_engine.SetItemAttrEvent(itemtype,itemkey,'ECX_EVENT_MESSAGE',l_wf_event);
543: resultout := 'P';
544:
537: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
538: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','Before setting workflow attributes');
539: END IF;
540: wf_event_t.Initialize(l_wf_event);
541: l_wf_event.setEventData(newxmldoc);
542: wf_engine.SetItemAttrEvent(itemtype,itemkey,'ECX_EVENT_MESSAGE',l_wf_event);
543: resultout := 'P';
544:
545: EXCEPTION
538: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.upload_xml.debug','Before setting workflow attributes');
539: END IF;
540: wf_event_t.Initialize(l_wf_event);
541: l_wf_event.setEventData(newxmldoc);
542: wf_engine.SetItemAttrEvent(itemtype,itemkey,'ECX_EVENT_MESSAGE',l_wf_event);
543: resultout := 'P';
544:
545: EXCEPTION
546: WHEN OTHERS THEN