28: /* This procedure needs to be deleted once the SEED data is fixed
29: -- x_error_code := 0 ;
30: -- x_error_message := NULL ;
31: --
32: -- xnp_xml_utils.initialize_doc ;
33: -- xnp_xml_utils.write_element('FE_NAME', p_fe_name) ;
34: --
35: -- FND_PROFILE.GET( NAME => 'SP_NAME',
36: -- VAL => l_sp_name ) ;
29: -- x_error_code := 0 ;
30: -- x_error_message := NULL ;
31: --
32: -- xnp_xml_utils.initialize_doc ;
33: -- xnp_xml_utils.write_element('FE_NAME', p_fe_name) ;
34: --
35: -- FND_PROFILE.GET( NAME => 'SP_NAME',
36: -- VAL => l_sp_name ) ;
37: --
34: --
35: -- FND_PROFILE.GET( NAME => 'SP_NAME',
36: -- VAL => l_sp_name ) ;
37: --
38: -- xnp_xml_utils.write_element('SP_NAME', l_sp_name) ;
39: --
40: --
41: -- --Get all FE attributes for the given FE
42: --
44: --
45: --
46: -- FOR i IN 1..l_fe_attr_list.COUNT LOOP
47: --
48: -- xnp_xml_utils.write_element(
49: -- l_fe_attr_list(i).parameter_name,
50: -- l_fe_attr_list(i).parameter_value ) ;
51: --
52: -- END LOOP ;
50: -- l_fe_attr_list(i).parameter_value ) ;
51: --
52: -- END LOOP ;
53: --
54: -- xnp_xml_utils.get_document(l_op_data) ;
55: --
56: -- xnp_control_u.create_msg(xnp$operation=>'OPEN',
57: -- xnp$op_data=>l_op_data,
58: -- x_msg_header=>l_msg_header,
222: l_count NUMBER ;
223:
224: BEGIN
225:
226: xnp_xml_utils.initialize_doc ;
227: xnp_xml_utils.write_element('FE_NAME', p_fe_name) ;
228:
229: /* generate XML for the rest of the attributes */
230:
223:
224: BEGIN
225:
226: xnp_xml_utils.initialize_doc ;
227: xnp_xml_utils.write_element('FE_NAME', p_fe_name) ;
228:
229: /* generate XML for the rest of the attributes */
230:
231: l_count := p_operation_data.COUNT ;
231: l_count := p_operation_data.COUNT ;
232:
233: FOR i IN 1..l_count LOOP
234:
235: xnp_xml_utils.write_element (
236: p_operation_data(i).attribute_name,
237: p_operation_data(i).attribute_value
238: );
239:
238: );
239:
240: END LOOP;
241:
242: xnp_xml_utils.get_document(l_op_data) ;
243:
244: xnp_control_u.create_msg(xnp$operation=>p_operation,
245: xnp$op_data=>l_op_data,
246: x_msg_header=>l_msg_header,
276: l_file_attr fe_data ;
277:
278: BEGIN
279:
280: xnp_xml_utils.initialize_doc ;
281: xnp_xml_utils.write_element('FE_NAME', p_fe_name) ;
282:
283: /* generate XML for the rest of the attributes */
284:
277:
278: BEGIN
279:
280: xnp_xml_utils.initialize_doc ;
281: xnp_xml_utils.write_element('FE_NAME', p_fe_name) ;
282:
283: /* generate XML for the rest of the attributes */
284:
285: l_file_attr(1).attribute_name := 'FILE_NAME' ;
345: -- l_file_attr fe_data ;
346:
347: BEGIN
348:
349: -- xnp_xml_utils.initialize_doc ;
350: -- xnp_xml_utils.write_element('FE_NAME', p_fe_name) ;
351: --
352: -- /* generate XML for the rest of the attributes */
353: --
346:
347: BEGIN
348:
349: -- xnp_xml_utils.initialize_doc ;
350: -- xnp_xml_utils.write_element('FE_NAME', p_fe_name) ;
351: --
352: -- /* generate XML for the rest of the attributes */
353: --
354: -- l_file_attr(1).attribute_name := 'FILE_NAME' ;
404:
405: /* get adapter status on successful Pipe Reads */
406:
407: IF (x_error_code = 0) THEN
408: xnp_xml_utils.decode(l_msg_text,'STATUS_CODE',
409: x_error_code) ;
410: xnp_xml_utils.decode(l_msg_text,'DESCRIPTION',
411: x_error_message) ;
412: END IF ;
406:
407: IF (x_error_code = 0) THEN
408: xnp_xml_utils.decode(l_msg_text,'STATUS_CODE',
409: x_error_code) ;
410: xnp_xml_utils.decode(l_msg_text,'DESCRIPTION',
411: x_error_message) ;
412: END IF ;
413: END IF;
414:
466:
467: l_item_type := 'XDPWFSTD' ;
468: l_item_key := 'MESSAGE_' || TO_CHAR(p_msg_header.message_id) ;
469:
470: xnp_xml_utils.decode(p_msg_text,'FE_NAME',l_fe_name) ;
471: xnp_xml_utils.decode(p_msg_text,'CHANNEL_NAME',l_channel_name) ;
472: xnp_xml_utils.decode(p_msg_text,'DESCRIPTION',l_description) ;
473:
474: wf_core.context('XDP_WF_STANDARD',
467: l_item_type := 'XDPWFSTD' ;
468: l_item_key := 'MESSAGE_' || TO_CHAR(p_msg_header.message_id) ;
469:
470: xnp_xml_utils.decode(p_msg_text,'FE_NAME',l_fe_name) ;
471: xnp_xml_utils.decode(p_msg_text,'CHANNEL_NAME',l_channel_name) ;
472: xnp_xml_utils.decode(p_msg_text,'DESCRIPTION',l_description) ;
473:
474: wf_core.context('XDP_WF_STANDARD',
475: 'ADAPTER_ERROR',
468: l_item_key := 'MESSAGE_' || TO_CHAR(p_msg_header.message_id) ;
469:
470: xnp_xml_utils.decode(p_msg_text,'FE_NAME',l_fe_name) ;
471: xnp_xml_utils.decode(p_msg_text,'CHANNEL_NAME',l_channel_name) ;
472: xnp_xml_utils.decode(p_msg_text,'DESCRIPTION',l_description) ;
473:
474: wf_core.context('XDP_WF_STANDARD',
475: 'ADAPTER_ERROR',
476: l_item_type,