APPS.ASG_HELPER dependencies on WF_EVENT

Line 985: l_wf_param wf_event_t;

981:
982: --api to raise sync error event oracle.apps.asg.sync.failure
983: PROCEDURE raise_sync_error_event(p_user_name IN VARCHAR2,p_message IN VARCHAR2)
984: IS
985: l_wf_param wf_event_t;
986: l_sql VARCHAR2(400);
987: l_device_type VARCHAR2(20);
988: l_session_id NUMBER;
989: l_sync_date DATE;

Line 1000: wf_event_t.initialize(l_wf_param);

996: from '||asg_base.G_OLITE_SCHEMA||'.c$sync_history where client_id=:1 order by start_time desc) where rownum<2';
997:
998: EXECUTE IMMEDIATE l_sql INTO l_session_id,l_sync_date,l_device_type using p_user_name;
999:
1000: wf_event_t.initialize(l_wf_param);
1001: l_wf_param.AddParameterToList('SESSION_ID',to_char(l_session_id));
1002: l_wf_param.AddParameterToList('TRAN_ID',asg_base.get_current_tranid);
1003: l_wf_param.AddParameterToList('CLIENT_ID',p_user_name);
1004: l_wf_param.AddParameterToList('ERROR_MSG',p_message);

Line 1007: wf_event.raise(p_event_name=>'oracle.apps.asg.sync.failure',

1003: l_wf_param.AddParameterToList('CLIENT_ID',p_user_name);
1004: l_wf_param.AddParameterToList('ERROR_MSG',p_message);
1005: l_wf_param.AddParameterToList('DEVICE_TYPE',l_device_type);
1006: l_wf_param.AddParameterToList('SYNC_DATE',to_char(l_sync_date,'DD-MM-RRRR HH24:MI:SS'));
1007: wf_event.raise(p_event_name=>'oracle.apps.asg.sync.failure',
1008: p_event_key=>to_char(l_session_id),p_parameters=>l_wf_param.getParameterList,
1009: p_event_data=>null,p_send_date=>null);
1010:
1011: log('Raised event oracle.apps.asg.sync.failure','asg_helper.raise_sync_error_event',g_stmt_level);