259: -- parameters for raising event
260: l_update_cln_event VARCHAR2(100);
261: l_event_key VARCHAR2(100);
262: l_updtdlvy_seq NUMBER;
263: l_update_cln_parameter_list wf_parameter_list_t;
264: l_second_cln_parameter_list wf_parameter_list_t;
265: message_text varchar2(240);
266: b_is_valid_delivery_num BOOLEAN;
267: l_temp VARCHAR(10);
260: l_update_cln_event VARCHAR2(100);
261: l_event_key VARCHAR2(100);
262: l_updtdlvy_seq NUMBER;
263: l_update_cln_parameter_list wf_parameter_list_t;
264: l_second_cln_parameter_list wf_parameter_list_t;
265: message_text varchar2(240);
266: b_is_valid_delivery_num BOOLEAN;
267: l_temp VARCHAR(10);
268:
272: l_debug_level := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
273:
274: x_progress := '000';
275: l_update_cln_event := 'oracle.apps.cln.ch.collaboration.add';
276: l_update_cln_parameter_list := wf_parameter_list_t();
277: l_second_cln_parameter_list := wf_parameter_list_t();
278: message_text := 'CLN_UPDL_MESSAGE_RCVD';
279:
280: if (l_debug_level <= 2) then
273:
274: x_progress := '000';
275: l_update_cln_event := 'oracle.apps.cln.ch.collaboration.add';
276: l_update_cln_parameter_list := wf_parameter_list_t();
277: l_second_cln_parameter_list := wf_parameter_list_t();
278: message_text := 'CLN_UPDL_MESSAGE_RCVD';
279:
280: if (l_debug_level <= 2) then
281: cln_debug_pub.Add('Entering CLN_UPDTDLVY_PKG.Process_Update_Delivery', 1);