33: IF G_DEBUG THEN
34: ozf_utility_pvt.debug_message(' Request Header Id :'||p_request_header_id );
35: END IF;
36:
37: wf_event.AddParameterToList(p_name => 'OZF_SDR_HEADER_ID',
38: p_value => p_request_header_id,
39: p_parameterlist => l_parameter_list);
40:
41: wf_event.AddParameterToList(p_name => 'OZF_SDR_FROM_STATUS',
37: wf_event.AddParameterToList(p_name => 'OZF_SDR_HEADER_ID',
38: p_value => p_request_header_id,
39: p_parameterlist => l_parameter_list);
40:
41: wf_event.AddParameterToList(p_name => 'OZF_SDR_FROM_STATUS',
42: p_value => p_from_status,
43: p_parameterlist => l_parameter_list);
44:
45: wf_event.AddParameterToList(p_name => 'OZF_SDR_TO_STATUS',
41: wf_event.AddParameterToList(p_name => 'OZF_SDR_FROM_STATUS',
42: p_value => p_from_status,
43: p_parameterlist => l_parameter_list);
44:
45: wf_event.AddParameterToList(p_name => 'OZF_SDR_TO_STATUS',
46: p_value => p_to_status,
47: p_parameterlist => l_parameter_list);
48:
49: IF G_DEBUG THEN
49: IF G_DEBUG THEN
50: ozf_utility_pvt.debug_message('Item Key is :'||l_item_key);
51: END IF;
52:
53: wf_event.raise( p_event_name =>l_event_name,
54: p_event_key => l_item_key,
55: p_parameters => l_parameter_list);
56:
57: EXCEPTION
90: IF G_DEBUG THEN
91: ozf_utility_pvt.debug_message(' Request Header Id :'||p_request_header_id );
92: END IF;
93:
94: wf_event.AddParameterToList(p_name => 'ECX_MAP_CODE',
95: p_value => 'OZF_SD_REQ_OUT',
96: p_parameterlist => l_parameter_list);
97:
98: wf_event.AddParameterToList(p_name => 'ECX_PARTY_ID',
94: wf_event.AddParameterToList(p_name => 'ECX_MAP_CODE',
95: p_value => 'OZF_SD_REQ_OUT',
96: p_parameterlist => l_parameter_list);
97:
98: wf_event.AddParameterToList(p_name => 'ECX_PARTY_ID',
99: p_value => p_supplier_id,
100: p_parameterlist => l_parameter_list);
101:
102: wf_event.AddParameterToList(p_name => 'ECX_PARTY_SITE_ID',
98: wf_event.AddParameterToList(p_name => 'ECX_PARTY_ID',
99: p_value => p_supplier_id,
100: p_parameterlist => l_parameter_list);
101:
102: wf_event.AddParameterToList(p_name => 'ECX_PARTY_SITE_ID',
103: p_value => p_supplier_site_id,
104: p_parameterlist => l_parameter_list);
105:
106: wf_event.AddParameterToList(p_name => 'ECX_PARTY_TYPE',
102: wf_event.AddParameterToList(p_name => 'ECX_PARTY_SITE_ID',
103: p_value => p_supplier_site_id,
104: p_parameterlist => l_parameter_list);
105:
106: wf_event.AddParameterToList(p_name => 'ECX_PARTY_TYPE',
107: p_value => 'S',
108: p_parameterlist => l_parameter_list);
109:
110: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
106: wf_event.AddParameterToList(p_name => 'ECX_PARTY_TYPE',
107: p_value => 'S',
108: p_parameterlist => l_parameter_list);
109:
110: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
111: p_value => p_request_header_id,
112: p_parameterlist => l_parameter_list);
113:
114: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
110: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
111: p_value => p_request_header_id,
112: p_parameterlist => l_parameter_list);
113:
114: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
115: p_value => 'OZF',
116: p_parameterlist => l_parameter_list);
117:
118: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
114: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
115: p_value => 'OZF',
116: p_parameterlist => l_parameter_list);
117:
118: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
119: p_value => 'SDRO',
120: p_parameterlist => l_parameter_list);
121:
122: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER1',
118: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
119: p_value => 'SDRO',
120: p_parameterlist => l_parameter_list);
121:
122: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER1',
123: p_value => NULL,
124: p_parameterlist => l_parameter_list);
125:
126: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER2',
122: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER1',
123: p_value => NULL,
124: p_parameterlist => l_parameter_list);
125:
126: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER2',
127: p_value => NULL,
128: p_parameterlist => l_parameter_list);
129:
130: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER3',
126: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER2',
127: p_value => NULL,
128: p_parameterlist => l_parameter_list);
129:
130: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER3',
131: p_value => NULL,
132: p_parameterlist => l_parameter_list);
133:
134: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER4',
130: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER3',
131: p_value => NULL,
132: p_parameterlist => l_parameter_list);
133:
134: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER4',
135: p_value => NULL,
136: p_parameterlist => l_parameter_list);
137:
138: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER5',
134: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER4',
135: p_value => NULL,
136: p_parameterlist => l_parameter_list);
137:
138: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER5',
139: p_value => NULL,
140: p_parameterlist => l_parameter_list);
141:
142: wf_event.AddParameterToList(p_name => 'ECX_DEBUG_LEVEL',
138: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER5',
139: p_value => NULL,
140: p_parameterlist => l_parameter_list);
141:
142: wf_event.AddParameterToList(p_name => 'ECX_DEBUG_LEVEL',
143: p_value => 3,
144: p_parameterlist => l_parameter_list);
145:
146: IF G_DEBUG THEN
146: IF G_DEBUG THEN
147: ozf_utility_pvt.debug_message('Item Key is :'||l_item_key);
148: END IF;
149:
150: wf_event.raise( p_event_name =>l_event_name,
151: p_event_key => l_item_key,
152: p_parameters => l_parameter_list);
153:
154: EXCEPTION