71:
72: ------------------------------------------------
73: -- Prepare a parameter list --
74: ------------------------------------------------
75: WF_EVENT.AddParameterToList('REQUEST_ID', to_char(p_request_id,'FM999999999999999'), v_params);
76: WF_EVENT.AddParameterToList('REQUESTED_BY', to_char(p_requested_by,'FM999999999999999'), v_params);
77: WF_EVENT.AddParameterToList('PROGRAM_APPLICATION_ID', to_char(p_program_application_id,'FM999999999999999'), v_params);
78: WF_EVENT.AddParameterToList('CONCURRENT_PROGRAM_ID', to_char(p_concurrent_program_id,'FM999999999999999'), v_params);
79: WF_EVENT.AddParameterToList('STATUS', p_status, v_params);
72: ------------------------------------------------
73: -- Prepare a parameter list --
74: ------------------------------------------------
75: WF_EVENT.AddParameterToList('REQUEST_ID', to_char(p_request_id,'FM999999999999999'), v_params);
76: WF_EVENT.AddParameterToList('REQUESTED_BY', to_char(p_requested_by,'FM999999999999999'), v_params);
77: WF_EVENT.AddParameterToList('PROGRAM_APPLICATION_ID', to_char(p_program_application_id,'FM999999999999999'), v_params);
78: WF_EVENT.AddParameterToList('CONCURRENT_PROGRAM_ID', to_char(p_concurrent_program_id,'FM999999999999999'), v_params);
79: WF_EVENT.AddParameterToList('STATUS', p_status, v_params);
80: WF_EVENT.AddParameterToList('COMPLETION_TEXT', p_completion_text, v_params);
73: -- Prepare a parameter list --
74: ------------------------------------------------
75: WF_EVENT.AddParameterToList('REQUEST_ID', to_char(p_request_id,'FM999999999999999'), v_params);
76: WF_EVENT.AddParameterToList('REQUESTED_BY', to_char(p_requested_by,'FM999999999999999'), v_params);
77: WF_EVENT.AddParameterToList('PROGRAM_APPLICATION_ID', to_char(p_program_application_id,'FM999999999999999'), v_params);
78: WF_EVENT.AddParameterToList('CONCURRENT_PROGRAM_ID', to_char(p_concurrent_program_id,'FM999999999999999'), v_params);
79: WF_EVENT.AddParameterToList('STATUS', p_status, v_params);
80: WF_EVENT.AddParameterToList('COMPLETION_TEXT', p_completion_text, v_params);
81: WF_EVENT.AddparameterToList('TIME_STAMP', to_char(p_time_stamp, 'MMDDYY HH24MISS'), v_params);
74: ------------------------------------------------
75: WF_EVENT.AddParameterToList('REQUEST_ID', to_char(p_request_id,'FM999999999999999'), v_params);
76: WF_EVENT.AddParameterToList('REQUESTED_BY', to_char(p_requested_by,'FM999999999999999'), v_params);
77: WF_EVENT.AddParameterToList('PROGRAM_APPLICATION_ID', to_char(p_program_application_id,'FM999999999999999'), v_params);
78: WF_EVENT.AddParameterToList('CONCURRENT_PROGRAM_ID', to_char(p_concurrent_program_id,'FM999999999999999'), v_params);
79: WF_EVENT.AddParameterToList('STATUS', p_status, v_params);
80: WF_EVENT.AddParameterToList('COMPLETION_TEXT', p_completion_text, v_params);
81: WF_EVENT.AddparameterToList('TIME_STAMP', to_char(p_time_stamp, 'MMDDYY HH24MISS'), v_params);
82:
75: WF_EVENT.AddParameterToList('REQUEST_ID', to_char(p_request_id,'FM999999999999999'), v_params);
76: WF_EVENT.AddParameterToList('REQUESTED_BY', to_char(p_requested_by,'FM999999999999999'), v_params);
77: WF_EVENT.AddParameterToList('PROGRAM_APPLICATION_ID', to_char(p_program_application_id,'FM999999999999999'), v_params);
78: WF_EVENT.AddParameterToList('CONCURRENT_PROGRAM_ID', to_char(p_concurrent_program_id,'FM999999999999999'), v_params);
79: WF_EVENT.AddParameterToList('STATUS', p_status, v_params);
80: WF_EVENT.AddParameterToList('COMPLETION_TEXT', p_completion_text, v_params);
81: WF_EVENT.AddparameterToList('TIME_STAMP', to_char(p_time_stamp, 'MMDDYY HH24MISS'), v_params);
82:
83: --------------------------------------------------------------------------------------
76: WF_EVENT.AddParameterToList('REQUESTED_BY', to_char(p_requested_by,'FM999999999999999'), v_params);
77: WF_EVENT.AddParameterToList('PROGRAM_APPLICATION_ID', to_char(p_program_application_id,'FM999999999999999'), v_params);
78: WF_EVENT.AddParameterToList('CONCURRENT_PROGRAM_ID', to_char(p_concurrent_program_id,'FM999999999999999'), v_params);
79: WF_EVENT.AddParameterToList('STATUS', p_status, v_params);
80: WF_EVENT.AddParameterToList('COMPLETION_TEXT', p_completion_text, v_params);
81: WF_EVENT.AddparameterToList('TIME_STAMP', to_char(p_time_stamp, 'MMDDYY HH24MISS'), v_params);
82:
83: --------------------------------------------------------------------------------------
84: -- create a unique key by tailing request_id with Julian date and event number --
77: WF_EVENT.AddParameterToList('PROGRAM_APPLICATION_ID', to_char(p_program_application_id,'FM999999999999999'), v_params);
78: WF_EVENT.AddParameterToList('CONCURRENT_PROGRAM_ID', to_char(p_concurrent_program_id,'FM999999999999999'), v_params);
79: WF_EVENT.AddParameterToList('STATUS', p_status, v_params);
80: WF_EVENT.AddParameterToList('COMPLETION_TEXT', p_completion_text, v_params);
81: WF_EVENT.AddparameterToList('TIME_STAMP', to_char(p_time_stamp, 'MMDDYY HH24MISS'), v_params);
82:
83: --------------------------------------------------------------------------------------
84: -- create a unique key by tailing request_id with Julian date and event number --
85: --------------------------------------------------------------------------------------
102: -- Raise an evnet FIRE! --
103: ------------------------------------------------
104: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
105: fnd_log.string(fnd_log.level_statement,'fnd.plsql.fnd_concurrent_business_event.raise_cp_bi_event',
106: 'called WF_EVENT.raise with '||
107: p_event_name||' '||v_event_key||' '||'v_params');
108: end if;
109:
110: WF_EVENT.raise(p_event_name,
106: 'called WF_EVENT.raise with '||
107: p_event_name||' '||v_event_key||' '||'v_params');
108: end if;
109:
110: WF_EVENT.raise(p_event_name,
111: v_event_key,
112: NULL,
113: v_params,
114: NULL);