61: raise too_many_match;
62: end if;
63: CLOSE c_pullSequence;
64:
65: wf_event.AddParameterToList(p_name=>'organization_id',
66: p_value=>l_pull_sequence.organization_id,
67: p_parameterlist=>l_parameter_list);
68: wf_event.AddParameterToList(p_name=>'pull_sequence_id',
69: p_value=>p_pull_Sequence_id,
64:
65: wf_event.AddParameterToList(p_name=>'organization_id',
66: p_value=>l_pull_sequence.organization_id,
67: p_parameterlist=>l_parameter_list);
68: wf_event.AddParameterToList(p_name=>'pull_sequence_id',
69: p_value=>p_pull_Sequence_id,
70: p_parameterlist=>l_parameter_list);
71: wf_event.AddParameterToList(p_name=>'inventory_item_id',
72: p_value=>l_pull_sequence.inventory_item_id,
67: p_parameterlist=>l_parameter_list);
68: wf_event.AddParameterToList(p_name=>'pull_sequence_id',
69: p_value=>p_pull_Sequence_id,
70: p_parameterlist=>l_parameter_list);
71: wf_event.AddParameterToList(p_name=>'inventory_item_id',
72: p_value=>l_pull_sequence.inventory_item_id,
73: p_parameterlist=>l_parameter_list);
74: wf_event.AddParameterToList(p_name=>'subinventory_name',
75: p_value=>l_pull_sequence.subinventory_name,
70: p_parameterlist=>l_parameter_list);
71: wf_event.AddParameterToList(p_name=>'inventory_item_id',
72: p_value=>l_pull_sequence.inventory_item_id,
73: p_parameterlist=>l_parameter_list);
74: wf_event.AddParameterToList(p_name=>'subinventory_name',
75: p_value=>l_pull_sequence.subinventory_name,
76: p_parameterlist=>l_parameter_list);
77: wf_event.AddParameterToList(p_name=>'locator_id',
78: p_value=>l_pull_sequence.locator_id,
73: p_parameterlist=>l_parameter_list);
74: wf_event.AddParameterToList(p_name=>'subinventory_name',
75: p_value=>l_pull_sequence.subinventory_name,
76: p_parameterlist=>l_parameter_list);
77: wf_event.AddParameterToList(p_name=>'locator_id',
78: p_value=>l_pull_sequence.locator_id,
79: p_parameterlist=>l_parameter_list);
80: wf_event.AddParameterToList(p_name=>'source_type',
81: p_value=>l_pull_sequence.source_type,
76: p_parameterlist=>l_parameter_list);
77: wf_event.AddParameterToList(p_name=>'locator_id',
78: p_value=>l_pull_sequence.locator_id,
79: p_parameterlist=>l_parameter_list);
80: wf_event.AddParameterToList(p_name=>'source_type',
81: p_value=>l_pull_sequence.source_type,
82: p_parameterlist=>l_parameter_list);
83: wf_event.AddParameterToList(p_name=>'kanban_size',
84: p_value=>l_pull_sequence.kanban_size,
79: p_parameterlist=>l_parameter_list);
80: wf_event.AddParameterToList(p_name=>'source_type',
81: p_value=>l_pull_sequence.source_type,
82: p_parameterlist=>l_parameter_list);
83: wf_event.AddParameterToList(p_name=>'kanban_size',
84: p_value=>l_pull_sequence.kanban_size,
85: p_parameterlist=>l_parameter_list);
86: wf_event.AddParameterToList(p_name=>'number_of_cards',
87: p_value=>l_pull_sequence.number_of_cards,
82: p_parameterlist=>l_parameter_list);
83: wf_event.AddParameterToList(p_name=>'kanban_size',
84: p_value=>l_pull_sequence.kanban_size,
85: p_parameterlist=>l_parameter_list);
86: wf_event.AddParameterToList(p_name=>'number_of_cards',
87: p_value=>l_pull_sequence.number_of_cards,
88: p_parameterlist=>l_parameter_list);
89:
90: if( l_event_name = 'oracle.apps.flm.ekanban.pullSeqUpdate') then
87: p_value=>l_pull_sequence.number_of_cards,
88: p_parameterlist=>l_parameter_list);
89:
90: if( l_event_name = 'oracle.apps.flm.ekanban.pullSeqUpdate') then
91: wf_event.AddParameterToList(p_name=>'update_from_planning',
92: p_value=>p_from_planning,
93: p_parameterlist=>l_parameter_list);
94: end if;
95:
92: p_value=>p_from_planning,
93: p_parameterlist=>l_parameter_list);
94: end if;
95:
96: WF_EVENT.Raise( p_event_name => l_event_name
97: ,p_event_key => l_event_key
98: ,p_event_data => l_event_data
99: ,p_parameters => l_parameter_list
100: ,p_send_date => l_send_date);
181:
182: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual;
183: l_event_key := SUBSTRB(l_event_name, 1, 255) || '-' || l_event_num;
184:
185: wf_event.AddParameterToList(p_name=>'kanban_card_id',
186: p_value=>p_kanban_card_id,
187: p_parameterlist=>l_parameter_list);
188: wf_event.AddParameterToList(p_name=>'organization_id',
189: p_value=>l_kanban_card.organization_id,
184:
185: wf_event.AddParameterToList(p_name=>'kanban_card_id',
186: p_value=>p_kanban_card_id,
187: p_parameterlist=>l_parameter_list);
188: wf_event.AddParameterToList(p_name=>'organization_id',
189: p_value=>l_kanban_card.organization_id,
190: p_parameterlist=>l_parameter_list);
191: wf_event.AddParameterToList(p_name=>'kanban_card_number',
192: p_value=>l_kanban_card.kanban_card_number,
187: p_parameterlist=>l_parameter_list);
188: wf_event.AddParameterToList(p_name=>'organization_id',
189: p_value=>l_kanban_card.organization_id,
190: p_parameterlist=>l_parameter_list);
191: wf_event.AddParameterToList(p_name=>'kanban_card_number',
192: p_value=>l_kanban_card.kanban_card_number,
193: p_parameterlist=>l_parameter_list);
194: wf_event.AddParameterToList(p_name=>'pull_sequence_id',
195: p_value=>l_kanban_card.pull_sequence_id,
190: p_parameterlist=>l_parameter_list);
191: wf_event.AddParameterToList(p_name=>'kanban_card_number',
192: p_value=>l_kanban_card.kanban_card_number,
193: p_parameterlist=>l_parameter_list);
194: wf_event.AddParameterToList(p_name=>'pull_sequence_id',
195: p_value=>l_kanban_card.pull_sequence_id,
196: p_parameterlist=>l_parameter_list);
197:
198:
195: p_value=>l_kanban_card.pull_sequence_id,
196: p_parameterlist=>l_parameter_list);
197:
198:
199: WF_EVENT.Raise( p_event_name => l_event_name
200: ,p_event_key => l_event_key
201: ,p_event_data => l_event_data
202: ,p_parameters => l_parameter_list
203: ,p_send_date => l_send_date);
279: raise too_many_match;
280: end if;
281: CLOSE c_kanbanCard;
282:
283: wf_event.AddParameterToList(p_name=>'kanban_card_id',
284: p_value=>p_kanban_card_id,
285: p_parameterlist=>l_parameter_list);
286: wf_event.AddParameterToList(p_name=>'kanban_card_number',
287: p_value=>l_kanban_card.kanban_card_number,
282:
283: wf_event.AddParameterToList(p_name=>'kanban_card_id',
284: p_value=>p_kanban_card_id,
285: p_parameterlist=>l_parameter_list);
286: wf_event.AddParameterToList(p_name=>'kanban_card_number',
287: p_value=>l_kanban_card.kanban_card_number,
288: p_parameterlist=>l_parameter_list);
289: wf_event.AddParameterToList(p_name=>'pull_sequence_id',
290: p_value=>l_kanban_card.pull_sequence_id,
285: p_parameterlist=>l_parameter_list);
286: wf_event.AddParameterToList(p_name=>'kanban_card_number',
287: p_value=>l_kanban_card.kanban_card_number,
288: p_parameterlist=>l_parameter_list);
289: wf_event.AddParameterToList(p_name=>'pull_sequence_id',
290: p_value=>l_kanban_card.pull_sequence_id,
291: p_parameterlist=>l_parameter_list);
292: wf_event.AddParameterToList(p_name=>'old_card_status',
293: p_value=>p_from_status,
288: p_parameterlist=>l_parameter_list);
289: wf_event.AddParameterToList(p_name=>'pull_sequence_id',
290: p_value=>l_kanban_card.pull_sequence_id,
291: p_parameterlist=>l_parameter_list);
292: wf_event.AddParameterToList(p_name=>'old_card_status',
293: p_value=>p_from_status,
294: p_parameterlist=>l_parameter_list);
295: wf_event.AddParameterToList(p_name=>'new_card_status',
296: p_value=>p_to_status,
291: p_parameterlist=>l_parameter_list);
292: wf_event.AddParameterToList(p_name=>'old_card_status',
293: p_value=>p_from_status,
294: p_parameterlist=>l_parameter_list);
295: wf_event.AddParameterToList(p_name=>'new_card_status',
296: p_value=>p_to_status,
297: p_parameterlist=>l_parameter_list);
298:
299:
296: p_value=>p_to_status,
297: p_parameterlist=>l_parameter_list);
298:
299:
300: WF_EVENT.Raise( p_event_name => l_event_name
301: ,p_event_key => l_event_key
302: ,p_event_data => l_event_data
303: ,p_parameters => l_parameter_list
304: ,p_send_date => l_send_date);
337:
338: /*For testing supscription and sending notificaiton internally. Need to remove it later*/
339:
340: function test_business_event (p_subscription_guid in raw,
341: p_event in out NOCOPY WF_EVENT_T) return varchar2 is
342: PRAGMA AUTONOMOUS_TRANSACTION;
343: l_return_status VARCHAR2(10);
344: l_msg_count NUMBER;
345: l_msg_data VARCHAR2(1000);
367: exception
368: when others then
369: WF_CORE.CONTEXT('FLM_EKB_BUSINESS_EVENT_PKG', 'test_business_event',
370: p_event.getEventName( ), p_subscription_guid);
371: WF_EVENT.setErrorInfo(p_event, 'ERROR');
372: return 'ERROR';
373: end;
374:
375: /*For testing supscription and sending notificaiton internally. Need to remove it later*/