220: iex_debug_pub.logmessage ('l_case_number ' ||l_case_number || 'l_case_owner' || l_case_owner
221: ||'<-----L_AMOUNT----->' ||l_amount);
222: END IF;
223:
224: wf_event.AddParameterToList('AMOUNT', to_char(l_amount), l_parameter_list);
225: --wf_event.AddParameterToList('CASE_OWNER', l_case_owner, l_parameter_list);
226: --wf_event.AddParameterToList('CASE_NUMBER', l_case_number, l_parameter_list);
227: wf_event.AddParameterToList('NOTIFY_AGENT', l_notification_agent, l_parameter_list);
228: wf_event.AddParameterToList('REQUEST_ID', p_request_ID, l_parameter_list);
221: ||'<-----L_AMOUNT----->' ||l_amount);
222: END IF;
223:
224: wf_event.AddParameterToList('AMOUNT', to_char(l_amount), l_parameter_list);
225: --wf_event.AddParameterToList('CASE_OWNER', l_case_owner, l_parameter_list);
226: --wf_event.AddParameterToList('CASE_NUMBER', l_case_number, l_parameter_list);
227: wf_event.AddParameterToList('NOTIFY_AGENT', l_notification_agent, l_parameter_list);
228: wf_event.AddParameterToList('REQUEST_ID', p_request_ID, l_parameter_list);
229: wf_event.AddParameterToList('WRITEOFF_ID', p_writeoff_ID, l_parameter_list);
222: END IF;
223:
224: wf_event.AddParameterToList('AMOUNT', to_char(l_amount), l_parameter_list);
225: --wf_event.AddParameterToList('CASE_OWNER', l_case_owner, l_parameter_list);
226: --wf_event.AddParameterToList('CASE_NUMBER', l_case_number, l_parameter_list);
227: wf_event.AddParameterToList('NOTIFY_AGENT', l_notification_agent, l_parameter_list);
228: wf_event.AddParameterToList('REQUEST_ID', p_request_ID, l_parameter_list);
229: wf_event.AddParameterToList('WRITEOFF_ID', p_writeoff_ID, l_parameter_list);
230: wf_event.AddParameterToList('OBJECT_ID', l_object_ID, l_parameter_list);
223:
224: wf_event.AddParameterToList('AMOUNT', to_char(l_amount), l_parameter_list);
225: --wf_event.AddParameterToList('CASE_OWNER', l_case_owner, l_parameter_list);
226: --wf_event.AddParameterToList('CASE_NUMBER', l_case_number, l_parameter_list);
227: wf_event.AddParameterToList('NOTIFY_AGENT', l_notification_agent, l_parameter_list);
228: wf_event.AddParameterToList('REQUEST_ID', p_request_ID, l_parameter_list);
229: wf_event.AddParameterToList('WRITEOFF_ID', p_writeoff_ID, l_parameter_list);
230: wf_event.AddParameterToList('OBJECT_ID', l_object_ID, l_parameter_list);
231: wf_event.AddParameterToList('WRITEOFF_TYPE', p_writeoff_type, l_parameter_list);
224: wf_event.AddParameterToList('AMOUNT', to_char(l_amount), l_parameter_list);
225: --wf_event.AddParameterToList('CASE_OWNER', l_case_owner, l_parameter_list);
226: --wf_event.AddParameterToList('CASE_NUMBER', l_case_number, l_parameter_list);
227: wf_event.AddParameterToList('NOTIFY_AGENT', l_notification_agent, l_parameter_list);
228: wf_event.AddParameterToList('REQUEST_ID', p_request_ID, l_parameter_list);
229: wf_event.AddParameterToList('WRITEOFF_ID', p_writeoff_ID, l_parameter_list);
230: wf_event.AddParameterToList('OBJECT_ID', l_object_ID, l_parameter_list);
231: wf_event.AddParameterToList('WRITEOFF_TYPE', p_writeoff_type, l_parameter_list);
232: wf_event.AddParameterToList('CURRENCY_CODE', l_currency_code, l_parameter_list);
225: --wf_event.AddParameterToList('CASE_OWNER', l_case_owner, l_parameter_list);
226: --wf_event.AddParameterToList('CASE_NUMBER', l_case_number, l_parameter_list);
227: wf_event.AddParameterToList('NOTIFY_AGENT', l_notification_agent, l_parameter_list);
228: wf_event.AddParameterToList('REQUEST_ID', p_request_ID, l_parameter_list);
229: wf_event.AddParameterToList('WRITEOFF_ID', p_writeoff_ID, l_parameter_list);
230: wf_event.AddParameterToList('OBJECT_ID', l_object_ID, l_parameter_list);
231: wf_event.AddParameterToList('WRITEOFF_TYPE', p_writeoff_type, l_parameter_list);
232: wf_event.AddParameterToList('CURRENCY_CODE', l_currency_code, l_parameter_list);
233:
226: --wf_event.AddParameterToList('CASE_NUMBER', l_case_number, l_parameter_list);
227: wf_event.AddParameterToList('NOTIFY_AGENT', l_notification_agent, l_parameter_list);
228: wf_event.AddParameterToList('REQUEST_ID', p_request_ID, l_parameter_list);
229: wf_event.AddParameterToList('WRITEOFF_ID', p_writeoff_ID, l_parameter_list);
230: wf_event.AddParameterToList('OBJECT_ID', l_object_ID, l_parameter_list);
231: wf_event.AddParameterToList('WRITEOFF_TYPE', p_writeoff_type, l_parameter_list);
232: wf_event.AddParameterToList('CURRENCY_CODE', l_currency_code, l_parameter_list);
233:
234: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
227: wf_event.AddParameterToList('NOTIFY_AGENT', l_notification_agent, l_parameter_list);
228: wf_event.AddParameterToList('REQUEST_ID', p_request_ID, l_parameter_list);
229: wf_event.AddParameterToList('WRITEOFF_ID', p_writeoff_ID, l_parameter_list);
230: wf_event.AddParameterToList('OBJECT_ID', l_object_ID, l_parameter_list);
231: wf_event.AddParameterToList('WRITEOFF_TYPE', p_writeoff_type, l_parameter_list);
232: wf_event.AddParameterToList('CURRENCY_CODE', l_currency_code, l_parameter_list);
233:
234: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
235: iex_debug_pub.logmessage ('before launching workflow');
228: wf_event.AddParameterToList('REQUEST_ID', p_request_ID, l_parameter_list);
229: wf_event.AddParameterToList('WRITEOFF_ID', p_writeoff_ID, l_parameter_list);
230: wf_event.AddParameterToList('OBJECT_ID', l_object_ID, l_parameter_list);
231: wf_event.AddParameterToList('WRITEOFF_TYPE', p_writeoff_type, l_parameter_list);
232: wf_event.AddParameterToList('CURRENCY_CODE', l_currency_code, l_parameter_list);
233:
234: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
235: iex_debug_pub.logmessage ('before launching workflow');
236: END IF;
234: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
235: iex_debug_pub.logmessage ('before launching workflow');
236: END IF;
237:
238: wf_event.raise(p_event_name => l_event_name
239: ,p_event_key => l_key
240: ,p_parameters => l_parameter_list);
241: COMMIT ;
242: l_parameter_list.DELETE;
327: IF l_notification_agent IS NULL THEN
328: l_notification_agent := 'SYSADMIN';
329: END IF;
330:
331: wf_event.AddParameterToList('NOTIFY_AGENT', l_notification_agent, l_parameter_list);
332: wf_event.AddParameterToList('CASE_OWNER', l_case_owner, l_parameter_list);
333: wf_event.AddParameterToList('CONTRACT_NUMBER', l_contract_number, l_parameter_list);
334:
335: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
328: l_notification_agent := 'SYSADMIN';
329: END IF;
330:
331: wf_event.AddParameterToList('NOTIFY_AGENT', l_notification_agent, l_parameter_list);
332: wf_event.AddParameterToList('CASE_OWNER', l_case_owner, l_parameter_list);
333: wf_event.AddParameterToList('CONTRACT_NUMBER', l_contract_number, l_parameter_list);
334:
335: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
336: iex_debug_pub.logmessage ('before launching workflow');
329: END IF;
330:
331: wf_event.AddParameterToList('NOTIFY_AGENT', l_notification_agent, l_parameter_list);
332: wf_event.AddParameterToList('CASE_OWNER', l_case_owner, l_parameter_list);
333: wf_event.AddParameterToList('CONTRACT_NUMBER', l_contract_number, l_parameter_list);
334:
335: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
336: iex_debug_pub.logmessage ('before launching workflow');
337: END IF;
335: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
336: iex_debug_pub.logmessage ('before launching workflow');
337: END IF;
338:
339: wf_event.raise(p_event_name => l_event_name
340: ,p_event_key => l_key
341: ,p_parameters => l_parameter_list);
342:
343: COMMIT ;