89: END IF;
90:
91: l_cln_params := wf_parameter_list_t();
92:
93: wf_event.addparametertolist('DOCUMENT_DIRECTION' , 'OUT',l_cln_params);
94: wf_event.addparametertolist('TRADING_PARTNER_TYPE' , m4u_ucc_utils.c_party_type,l_cln_params);
95: wf_event.addparametertolist('TRADING_PARTNER_ID' , m4u_ucc_utils.g_party_id,l_cln_params);
96: wf_event.addparametertolist('TRADING_PARTNER_SITE' , m4u_ucc_utils.g_party_site_id,l_cln_params);
97: wf_event.addparametertolist('COLLABORATION_ID' , a_cln_id,l_cln_params);
90:
91: l_cln_params := wf_parameter_list_t();
92:
93: wf_event.addparametertolist('DOCUMENT_DIRECTION' , 'OUT',l_cln_params);
94: wf_event.addparametertolist('TRADING_PARTNER_TYPE' , m4u_ucc_utils.c_party_type,l_cln_params);
95: wf_event.addparametertolist('TRADING_PARTNER_ID' , m4u_ucc_utils.g_party_id,l_cln_params);
96: wf_event.addparametertolist('TRADING_PARTNER_SITE' , m4u_ucc_utils.g_party_site_id,l_cln_params);
97: wf_event.addparametertolist('COLLABORATION_ID' , a_cln_id,l_cln_params);
98: wf_event.addparametertolist('DISPOSITION' , l_dsptn,l_cln_params);
91: l_cln_params := wf_parameter_list_t();
92:
93: wf_event.addparametertolist('DOCUMENT_DIRECTION' , 'OUT',l_cln_params);
94: wf_event.addparametertolist('TRADING_PARTNER_TYPE' , m4u_ucc_utils.c_party_type,l_cln_params);
95: wf_event.addparametertolist('TRADING_PARTNER_ID' , m4u_ucc_utils.g_party_id,l_cln_params);
96: wf_event.addparametertolist('TRADING_PARTNER_SITE' , m4u_ucc_utils.g_party_site_id,l_cln_params);
97: wf_event.addparametertolist('COLLABORATION_ID' , a_cln_id,l_cln_params);
98: wf_event.addparametertolist('DISPOSITION' , l_dsptn,l_cln_params);
99: wf_event.addparametertolist('ROSETTANET_CHECK_REQUIRED' , 'FALSE',l_cln_params);
92:
93: wf_event.addparametertolist('DOCUMENT_DIRECTION' , 'OUT',l_cln_params);
94: wf_event.addparametertolist('TRADING_PARTNER_TYPE' , m4u_ucc_utils.c_party_type,l_cln_params);
95: wf_event.addparametertolist('TRADING_PARTNER_ID' , m4u_ucc_utils.g_party_id,l_cln_params);
96: wf_event.addparametertolist('TRADING_PARTNER_SITE' , m4u_ucc_utils.g_party_site_id,l_cln_params);
97: wf_event.addparametertolist('COLLABORATION_ID' , a_cln_id,l_cln_params);
98: wf_event.addparametertolist('DISPOSITION' , l_dsptn,l_cln_params);
99: wf_event.addparametertolist('ROSETTANET_CHECK_REQUIRED' , 'FALSE',l_cln_params);
100: wf_event.addparametertolist('DOCUMENT_STATUS' , l_doc_sts,l_cln_params);
93: wf_event.addparametertolist('DOCUMENT_DIRECTION' , 'OUT',l_cln_params);
94: wf_event.addparametertolist('TRADING_PARTNER_TYPE' , m4u_ucc_utils.c_party_type,l_cln_params);
95: wf_event.addparametertolist('TRADING_PARTNER_ID' , m4u_ucc_utils.g_party_id,l_cln_params);
96: wf_event.addparametertolist('TRADING_PARTNER_SITE' , m4u_ucc_utils.g_party_site_id,l_cln_params);
97: wf_event.addparametertolist('COLLABORATION_ID' , a_cln_id,l_cln_params);
98: wf_event.addparametertolist('DISPOSITION' , l_dsptn,l_cln_params);
99: wf_event.addparametertolist('ROSETTANET_CHECK_REQUIRED' , 'FALSE',l_cln_params);
100: wf_event.addparametertolist('DOCUMENT_STATUS' , l_doc_sts,l_cln_params);
101: wf_event.addparametertolist('MESSAGE_TEXT' , l_msg_txt,l_cln_params);
94: wf_event.addparametertolist('TRADING_PARTNER_TYPE' , m4u_ucc_utils.c_party_type,l_cln_params);
95: wf_event.addparametertolist('TRADING_PARTNER_ID' , m4u_ucc_utils.g_party_id,l_cln_params);
96: wf_event.addparametertolist('TRADING_PARTNER_SITE' , m4u_ucc_utils.g_party_site_id,l_cln_params);
97: wf_event.addparametertolist('COLLABORATION_ID' , a_cln_id,l_cln_params);
98: wf_event.addparametertolist('DISPOSITION' , l_dsptn,l_cln_params);
99: wf_event.addparametertolist('ROSETTANET_CHECK_REQUIRED' , 'FALSE',l_cln_params);
100: wf_event.addparametertolist('DOCUMENT_STATUS' , l_doc_sts,l_cln_params);
101: wf_event.addparametertolist('MESSAGE_TEXT' , l_msg_txt,l_cln_params);
102: wf_event.addparametertolist('APPLICATION_ID' , m4u_ucc_utils.c_resp_appl_id,l_cln_params);
95: wf_event.addparametertolist('TRADING_PARTNER_ID' , m4u_ucc_utils.g_party_id,l_cln_params);
96: wf_event.addparametertolist('TRADING_PARTNER_SITE' , m4u_ucc_utils.g_party_site_id,l_cln_params);
97: wf_event.addparametertolist('COLLABORATION_ID' , a_cln_id,l_cln_params);
98: wf_event.addparametertolist('DISPOSITION' , l_dsptn,l_cln_params);
99: wf_event.addparametertolist('ROSETTANET_CHECK_REQUIRED' , 'FALSE',l_cln_params);
100: wf_event.addparametertolist('DOCUMENT_STATUS' , l_doc_sts,l_cln_params);
101: wf_event.addparametertolist('MESSAGE_TEXT' , l_msg_txt,l_cln_params);
102: wf_event.addparametertolist('APPLICATION_ID' , m4u_ucc_utils.c_resp_appl_id,l_cln_params);
103: wf_event.addparametertolist('COLLABORATION_STATUS' , l_cln_sts,l_cln_params);
96: wf_event.addparametertolist('TRADING_PARTNER_SITE' , m4u_ucc_utils.g_party_site_id,l_cln_params);
97: wf_event.addparametertolist('COLLABORATION_ID' , a_cln_id,l_cln_params);
98: wf_event.addparametertolist('DISPOSITION' , l_dsptn,l_cln_params);
99: wf_event.addparametertolist('ROSETTANET_CHECK_REQUIRED' , 'FALSE',l_cln_params);
100: wf_event.addparametertolist('DOCUMENT_STATUS' , l_doc_sts,l_cln_params);
101: wf_event.addparametertolist('MESSAGE_TEXT' , l_msg_txt,l_cln_params);
102: wf_event.addparametertolist('APPLICATION_ID' , m4u_ucc_utils.c_resp_appl_id,l_cln_params);
103: wf_event.addparametertolist('COLLABORATION_STATUS' , l_cln_sts,l_cln_params);
104:
97: wf_event.addparametertolist('COLLABORATION_ID' , a_cln_id,l_cln_params);
98: wf_event.addparametertolist('DISPOSITION' , l_dsptn,l_cln_params);
99: wf_event.addparametertolist('ROSETTANET_CHECK_REQUIRED' , 'FALSE',l_cln_params);
100: wf_event.addparametertolist('DOCUMENT_STATUS' , l_doc_sts,l_cln_params);
101: wf_event.addparametertolist('MESSAGE_TEXT' , l_msg_txt,l_cln_params);
102: wf_event.addparametertolist('APPLICATION_ID' , m4u_ucc_utils.c_resp_appl_id,l_cln_params);
103: wf_event.addparametertolist('COLLABORATION_STATUS' , l_cln_sts,l_cln_params);
104:
105: wf_event.raise( p_event_name =>'oracle.apps.cln.ch.collaboration.update',
98: wf_event.addparametertolist('DISPOSITION' , l_dsptn,l_cln_params);
99: wf_event.addparametertolist('ROSETTANET_CHECK_REQUIRED' , 'FALSE',l_cln_params);
100: wf_event.addparametertolist('DOCUMENT_STATUS' , l_doc_sts,l_cln_params);
101: wf_event.addparametertolist('MESSAGE_TEXT' , l_msg_txt,l_cln_params);
102: wf_event.addparametertolist('APPLICATION_ID' , m4u_ucc_utils.c_resp_appl_id,l_cln_params);
103: wf_event.addparametertolist('COLLABORATION_STATUS' , l_cln_sts,l_cln_params);
104:
105: wf_event.raise( p_event_name =>'oracle.apps.cln.ch.collaboration.update',
106: p_event_key =>l_key,
99: wf_event.addparametertolist('ROSETTANET_CHECK_REQUIRED' , 'FALSE',l_cln_params);
100: wf_event.addparametertolist('DOCUMENT_STATUS' , l_doc_sts,l_cln_params);
101: wf_event.addparametertolist('MESSAGE_TEXT' , l_msg_txt,l_cln_params);
102: wf_event.addparametertolist('APPLICATION_ID' , m4u_ucc_utils.c_resp_appl_id,l_cln_params);
103: wf_event.addparametertolist('COLLABORATION_STATUS' , l_cln_sts,l_cln_params);
104:
105: wf_event.raise( p_event_name =>'oracle.apps.cln.ch.collaboration.update',
106: p_event_key =>l_key,
107: p_parameters =>l_cln_params);
101: wf_event.addparametertolist('MESSAGE_TEXT' , l_msg_txt,l_cln_params);
102: wf_event.addparametertolist('APPLICATION_ID' , m4u_ucc_utils.c_resp_appl_id,l_cln_params);
103: wf_event.addparametertolist('COLLABORATION_STATUS' , l_cln_sts,l_cln_params);
104:
105: wf_event.raise( p_event_name =>'oracle.apps.cln.ch.collaboration.update',
106: p_event_key =>l_key,
107: p_parameters =>l_cln_params);
108:
109: commit;
127: -- Check if all the required parameters are not null
128: -- return error is any mandatory parameter is missing
129: -- return values of cln_id, tp_id, industry_list on success
130: PROCEDURE read_and_validate_inputs
131: ( a_evnt IN WF_EVENT_T,
132: x_cln_id OUT NOCOPY VARCHAR2,
133: x_tp_id OUT NOCOPY VARCHAR2,
134: x_indstry_list OUT NOCOPY VARCHAR2,
135: x_ret_sts OUT NOCOPY VARCHAR2,
193: --Raise exection on any errors and stop XML generation
194: --This api is called from m4u_230_cin_out.xgm extensions/extensionsHookTag
195: PROCEDURE get_xml_fragment
196: (
197: a_evnt IN WF_EVENT_T,
198: x_xml OUT NOCOPY VARCHAR2
199: ) AS
200: l_param_list wf_parameter_list_t;
201: l_cln_id NUMBER;