27: p_message OUT NOCOPY VARCHAR2
28: )
29: IS
30: l_wf_event_t WF_EVENT_T;
31: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
32:
33: --
34: -- cursor to fetch the usec_occur_id
35: --
77: l_wf_event_t.setEventKey ( pEventKey => p_event_key||l_key );
78: --
79: -- set the parameter list
80: --
81: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
82: --
83: -- now add the parameters to the parameter list
84: --
85: l_wf_event_t.AddParameterToList ( pName => 'ORG_ID', pValue => FND_PROFILE.VALUE('ORG_ID'));
95: --
96: WF_EVENT.RAISE (p_event_name => p_event_name,
97: p_event_key => p_event_key||l_key,
98: p_event_data => NULL,
99: p_parameters => l_wf_parameter_list_t);
100: END raise_event;
101:
102: --
103: -- procedure to update igs_ps_usec_occurs
319: -------------------------------------------------------------------------------------
320: AS
321: l_n_key NUMBER;
322: l_wf_event_t WF_EVENT_T;
323: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
324:
325: l_c_user_name fnd_user.user_name%TYPE:=fnd_global.user_name;
326: l_c_cal_type igs_ca_inst.cal_type%TYPE;
327: l_n_cal_seq_num igs_ca_inst.sequence_number%TYPE;
378: CLOSE c_seq;
379: --
380: -- set the parameter list
381: --
382: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
383: --
384: -- now add the parameters to the parameter list
385:
386: wf_event.AddParameterToList ( p_name => 'IA_USER', p_value =>l_c_user_name , p_parameterlist => l_wf_parameter_list_t);
382: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
383: --
384: -- now add the parameters to the parameter list
385:
386: wf_event.AddParameterToList ( p_name => 'IA_USER', p_value =>l_c_user_name , p_parameterlist => l_wf_parameter_list_t);
387: wf_event.AddParameterToList ( p_name => 'IA_CAL_TYPE', p_value =>l_c_cal_type, p_parameterlist => l_wf_parameter_list_t);
388: wf_event.AddParameterToList ( p_name => 'IA_CAL_SEQ_NUM', p_value =>l_n_cal_seq_num, p_parameterlist => l_wf_parameter_list_t);
389: --
390: -- raise the event
383: --
384: -- now add the parameters to the parameter list
385:
386: wf_event.AddParameterToList ( p_name => 'IA_USER', p_value =>l_c_user_name , p_parameterlist => l_wf_parameter_list_t);
387: wf_event.AddParameterToList ( p_name => 'IA_CAL_TYPE', p_value =>l_c_cal_type, p_parameterlist => l_wf_parameter_list_t);
388: wf_event.AddParameterToList ( p_name => 'IA_CAL_SEQ_NUM', p_value =>l_n_cal_seq_num, p_parameterlist => l_wf_parameter_list_t);
389: --
390: -- raise the event
391:
384: -- now add the parameters to the parameter list
385:
386: wf_event.AddParameterToList ( p_name => 'IA_USER', p_value =>l_c_user_name , p_parameterlist => l_wf_parameter_list_t);
387: wf_event.AddParameterToList ( p_name => 'IA_CAL_TYPE', p_value =>l_c_cal_type, p_parameterlist => l_wf_parameter_list_t);
388: wf_event.AddParameterToList ( p_name => 'IA_CAL_SEQ_NUM', p_value =>l_n_cal_seq_num, p_parameterlist => l_wf_parameter_list_t);
389: --
390: -- raise the event
391:
392: wf_event.raise (
391:
392: wf_event.raise (
393: p_event_name => 'oracle.apps.igs.ps.fac_workload.exceed',
394: p_event_key => 'FACEXCEEDWL'||l_n_key,
395: p_parameters => l_wf_parameter_list_t
396: );
397: EXCEPTION
398: WHEN OTHERS THEN
399: ROLLBACK;