25: l_msg_header XNP_MESSAGE.MSG_HEADER_REC_TYPE ;
26: BEGIN
27: x_error_code := 0 ;
28: x_error_message := NULL ;
29: XNP_XML_UTILS.initialize_doc ( ) ;
30: /* construct the message body */
31: XNP_XML_UTILS.begin_segment ( 'SYNC' ) ;
32: IF ( XNP$SYNC_LABEL IS NULL) THEN
33: x_error_message :='Missing Mandatory Attribute - SYNC_LABEL' ;
27: x_error_code := 0 ;
28: x_error_message := NULL ;
29: XNP_XML_UTILS.initialize_doc ( ) ;
30: /* construct the message body */
31: XNP_XML_UTILS.begin_segment ( 'SYNC' ) ;
32: IF ( XNP$SYNC_LABEL IS NULL) THEN
33: x_error_message :='Missing Mandatory Attribute - SYNC_LABEL' ;
34: RAISE e_MISSING_MANDATORY_DATA ;
35: END IF ;
32: IF ( XNP$SYNC_LABEL IS NULL) THEN
33: x_error_message :='Missing Mandatory Attribute - SYNC_LABEL' ;
34: RAISE e_MISSING_MANDATORY_DATA ;
35: END IF ;
36: XNP_XML_UTILS.write_element ( 'SYNC_LABEL', XNP$SYNC_LABEL ) ;
37: XNP_XML_UTILS.end_segment ( 'SYNC' ) ;
38: /* get the message body */
39: XNP_XML_UTILS.get_document ( l_xml_body ) ;
40: IF (l_xml_body IS NULL) THEN
33: x_error_message :='Missing Mandatory Attribute - SYNC_LABEL' ;
34: RAISE e_MISSING_MANDATORY_DATA ;
35: END IF ;
36: XNP_XML_UTILS.write_element ( 'SYNC_LABEL', XNP$SYNC_LABEL ) ;
37: XNP_XML_UTILS.end_segment ( 'SYNC' ) ;
38: /* get the message body */
39: XNP_XML_UTILS.get_document ( l_xml_body ) ;
40: IF (l_xml_body IS NULL) THEN
41: XNP_XML_UTILS.write_element('SYNC',l_xml_body );
35: END IF ;
36: XNP_XML_UTILS.write_element ( 'SYNC_LABEL', XNP$SYNC_LABEL ) ;
37: XNP_XML_UTILS.end_segment ( 'SYNC' ) ;
38: /* get the message body */
39: XNP_XML_UTILS.get_document ( l_xml_body ) ;
40: IF (l_xml_body IS NULL) THEN
41: XNP_XML_UTILS.write_element('SYNC',l_xml_body );
42: XNP_XML_UTILS.get_document( l_xml_body ) ;
43: END IF;
37: XNP_XML_UTILS.end_segment ( 'SYNC' ) ;
38: /* get the message body */
39: XNP_XML_UTILS.get_document ( l_xml_body ) ;
40: IF (l_xml_body IS NULL) THEN
41: XNP_XML_UTILS.write_element('SYNC',l_xml_body );
42: XNP_XML_UTILS.get_document( l_xml_body ) ;
43: END IF;
44: /* initialize the XML header variable */
45: XNP_XML_UTILS.initialize_doc ( ) ;
38: /* get the message body */
39: XNP_XML_UTILS.get_document ( l_xml_body ) ;
40: IF (l_xml_body IS NULL) THEN
41: XNP_XML_UTILS.write_element('SYNC',l_xml_body );
42: XNP_XML_UTILS.get_document( l_xml_body ) ;
43: END IF;
44: /* initialize the XML header variable */
45: XNP_XML_UTILS.initialize_doc ( ) ;
46: /*construct the XML header */
41: XNP_XML_UTILS.write_element('SYNC',l_xml_body );
42: XNP_XML_UTILS.get_document( l_xml_body ) ;
43: END IF;
44: /* initialize the XML header variable */
45: XNP_XML_UTILS.initialize_doc ( ) ;
46: /*construct the XML header */
47: /* retreive the next message ID */
48: XNP_MESSAGE.get_sequence ( l_msg_header.message_id ) ;
49: IF (p_reference_id IS NULL) THEN
51: ELSE
52: l_msg_header.reference_id := p_reference_id ;
53: END IF ;
54: /* append header parameters to make header */
55: XNP_XML_UTILS.write_element ( 'MESSAGE_ID',l_msg_header.message_id ) ;
56: XNP_XML_UTILS.write_element ( 'REFERENCE_ID',l_msg_header.reference_id ) ;
57: l_msg_header.opp_reference_id := p_opp_reference_id ;
58: XNP_XML_UTILS.write_element ( 'OPP_REFERENCE_ID',l_msg_header.opp_reference_id ) ;
59: l_msg_header.message_code := 'SYNC' ;
52: l_msg_header.reference_id := p_reference_id ;
53: END IF ;
54: /* append header parameters to make header */
55: XNP_XML_UTILS.write_element ( 'MESSAGE_ID',l_msg_header.message_id ) ;
56: XNP_XML_UTILS.write_element ( 'REFERENCE_ID',l_msg_header.reference_id ) ;
57: l_msg_header.opp_reference_id := p_opp_reference_id ;
58: XNP_XML_UTILS.write_element ( 'OPP_REFERENCE_ID',l_msg_header.opp_reference_id ) ;
59: l_msg_header.message_code := 'SYNC' ;
60: XNP_XML_UTILS.write_element ( 'MESSAGE_CODE',l_msg_header.message_code ) ;
54: /* append header parameters to make header */
55: XNP_XML_UTILS.write_element ( 'MESSAGE_ID',l_msg_header.message_id ) ;
56: XNP_XML_UTILS.write_element ( 'REFERENCE_ID',l_msg_header.reference_id ) ;
57: l_msg_header.opp_reference_id := p_opp_reference_id ;
58: XNP_XML_UTILS.write_element ( 'OPP_REFERENCE_ID',l_msg_header.opp_reference_id ) ;
59: l_msg_header.message_code := 'SYNC' ;
60: XNP_XML_UTILS.write_element ( 'MESSAGE_CODE',l_msg_header.message_code ) ;
61: l_msg_header.version := p_version ;
62: XNP_XML_UTILS.write_element ( 'VERSION',l_msg_header.version ) ;
56: XNP_XML_UTILS.write_element ( 'REFERENCE_ID',l_msg_header.reference_id ) ;
57: l_msg_header.opp_reference_id := p_opp_reference_id ;
58: XNP_XML_UTILS.write_element ( 'OPP_REFERENCE_ID',l_msg_header.opp_reference_id ) ;
59: l_msg_header.message_code := 'SYNC' ;
60: XNP_XML_UTILS.write_element ( 'MESSAGE_CODE',l_msg_header.message_code ) ;
61: l_msg_header.version := p_version ;
62: XNP_XML_UTILS.write_element ( 'VERSION',l_msg_header.version ) ;
63: l_msg_header.creation_date := SYSDATE ;
64: l_msg_header.recipient_name := p_recipient_list ;
58: XNP_XML_UTILS.write_element ( 'OPP_REFERENCE_ID',l_msg_header.opp_reference_id ) ;
59: l_msg_header.message_code := 'SYNC' ;
60: XNP_XML_UTILS.write_element ( 'MESSAGE_CODE',l_msg_header.message_code ) ;
61: l_msg_header.version := p_version ;
62: XNP_XML_UTILS.write_element ( 'VERSION',l_msg_header.version ) ;
63: l_msg_header.creation_date := SYSDATE ;
64: l_msg_header.recipient_name := p_recipient_list ;
65: XNP_XML_UTILS.write_element ( 'CREATION_DATE',l_msg_header.creation_date ) ;
66: l_msg_header.sender_name := p_sender_name ;
61: l_msg_header.version := p_version ;
62: XNP_XML_UTILS.write_element ( 'VERSION',l_msg_header.version ) ;
63: l_msg_header.creation_date := SYSDATE ;
64: l_msg_header.recipient_name := p_recipient_list ;
65: XNP_XML_UTILS.write_element ( 'CREATION_DATE',l_msg_header.creation_date ) ;
66: l_msg_header.sender_name := p_sender_name ;
67: XNP_XML_UTILS.write_element ( 'SENDER_NAME',l_msg_header.sender_name ) ;
68: XNP_XML_UTILS.write_element ( 'RECIPIENT_NAME',l_msg_header.recipient_name ) ;
69: l_msg_header.direction_indr := 'E' ;
63: l_msg_header.creation_date := SYSDATE ;
64: l_msg_header.recipient_name := p_recipient_list ;
65: XNP_XML_UTILS.write_element ( 'CREATION_DATE',l_msg_header.creation_date ) ;
66: l_msg_header.sender_name := p_sender_name ;
67: XNP_XML_UTILS.write_element ( 'SENDER_NAME',l_msg_header.sender_name ) ;
68: XNP_XML_UTILS.write_element ( 'RECIPIENT_NAME',l_msg_header.recipient_name ) ;
69: l_msg_header.direction_indr := 'E' ;
70: l_msg_header.order_id := p_order_id ;
71: l_msg_header.wi_instance_id := p_wi_instance_id ;
64: l_msg_header.recipient_name := p_recipient_list ;
65: XNP_XML_UTILS.write_element ( 'CREATION_DATE',l_msg_header.creation_date ) ;
66: l_msg_header.sender_name := p_sender_name ;
67: XNP_XML_UTILS.write_element ( 'SENDER_NAME',l_msg_header.sender_name ) ;
68: XNP_XML_UTILS.write_element ( 'RECIPIENT_NAME',l_msg_header.recipient_name ) ;
69: l_msg_header.direction_indr := 'E' ;
70: l_msg_header.order_id := p_order_id ;
71: l_msg_header.wi_instance_id := p_wi_instance_id ;
72: l_msg_header.fa_instance_id := p_fa_instance_id ;
69: l_msg_header.direction_indr := 'E' ;
70: l_msg_header.order_id := p_order_id ;
71: l_msg_header.wi_instance_id := p_wi_instance_id ;
72: l_msg_header.fa_instance_id := p_fa_instance_id ;
73: XNP_XML_UTILS.write_element ( 'SYNC_LABEL', XNP$SYNC_LABEL );
74: XNP_XML_UTILS.write_element ( 'SDP_RESULT_CODE', XNP$SDP_RESULT_CODE );
75: /* retreieve the XML header */
76: XNP_XML_UTILS.get_document ( l_xml_header ) ;
77: /* append the XML headerto message */
70: l_msg_header.order_id := p_order_id ;
71: l_msg_header.wi_instance_id := p_wi_instance_id ;
72: l_msg_header.fa_instance_id := p_fa_instance_id ;
73: XNP_XML_UTILS.write_element ( 'SYNC_LABEL', XNP$SYNC_LABEL );
74: XNP_XML_UTILS.write_element ( 'SDP_RESULT_CODE', XNP$SDP_RESULT_CODE );
75: /* retreieve the XML header */
76: XNP_XML_UTILS.get_document ( l_xml_header ) ;
77: /* append the XML headerto message */
78: XNP_XML_UTILS.initialize_doc ( ) ;
72: l_msg_header.fa_instance_id := p_fa_instance_id ;
73: XNP_XML_UTILS.write_element ( 'SYNC_LABEL', XNP$SYNC_LABEL );
74: XNP_XML_UTILS.write_element ( 'SDP_RESULT_CODE', XNP$SDP_RESULT_CODE );
75: /* retreieve the XML header */
76: XNP_XML_UTILS.get_document ( l_xml_header ) ;
77: /* append the XML headerto message */
78: XNP_XML_UTILS.initialize_doc ( ) ;
79: XNP_XML_UTILS.xml_decl ;
80: XNP_XML_UTILS.begin_segment ( 'MESSAGE') ;
74: XNP_XML_UTILS.write_element ( 'SDP_RESULT_CODE', XNP$SDP_RESULT_CODE );
75: /* retreieve the XML header */
76: XNP_XML_UTILS.get_document ( l_xml_header ) ;
77: /* append the XML headerto message */
78: XNP_XML_UTILS.initialize_doc ( ) ;
79: XNP_XML_UTILS.xml_decl ;
80: XNP_XML_UTILS.begin_segment ( 'MESSAGE') ;
81: XNP_XML_UTILS.write_element( 'HEADER', l_xml_header );
82: XNP_XML_UTILS.append ( l_xml_body ) ;
75: /* retreieve the XML header */
76: XNP_XML_UTILS.get_document ( l_xml_header ) ;
77: /* append the XML headerto message */
78: XNP_XML_UTILS.initialize_doc ( ) ;
79: XNP_XML_UTILS.xml_decl ;
80: XNP_XML_UTILS.begin_segment ( 'MESSAGE') ;
81: XNP_XML_UTILS.write_element( 'HEADER', l_xml_header );
82: XNP_XML_UTILS.append ( l_xml_body ) ;
83: XNP_XML_UTILS.end_segment ( 'MESSAGE') ;
76: XNP_XML_UTILS.get_document ( l_xml_header ) ;
77: /* append the XML headerto message */
78: XNP_XML_UTILS.initialize_doc ( ) ;
79: XNP_XML_UTILS.xml_decl ;
80: XNP_XML_UTILS.begin_segment ( 'MESSAGE') ;
81: XNP_XML_UTILS.write_element( 'HEADER', l_xml_header );
82: XNP_XML_UTILS.append ( l_xml_body ) ;
83: XNP_XML_UTILS.end_segment ( 'MESSAGE') ;
84: XNP_XML_UTILS.get_document( l_xml_doc ) ;
77: /* append the XML headerto message */
78: XNP_XML_UTILS.initialize_doc ( ) ;
79: XNP_XML_UTILS.xml_decl ;
80: XNP_XML_UTILS.begin_segment ( 'MESSAGE') ;
81: XNP_XML_UTILS.write_element( 'HEADER', l_xml_header );
82: XNP_XML_UTILS.append ( l_xml_body ) ;
83: XNP_XML_UTILS.end_segment ( 'MESSAGE') ;
84: XNP_XML_UTILS.get_document( l_xml_doc ) ;
85: /* assign the header and msg text to output parameters */
78: XNP_XML_UTILS.initialize_doc ( ) ;
79: XNP_XML_UTILS.xml_decl ;
80: XNP_XML_UTILS.begin_segment ( 'MESSAGE') ;
81: XNP_XML_UTILS.write_element( 'HEADER', l_xml_header );
82: XNP_XML_UTILS.append ( l_xml_body ) ;
83: XNP_XML_UTILS.end_segment ( 'MESSAGE') ;
84: XNP_XML_UTILS.get_document( l_xml_doc ) ;
85: /* assign the header and msg text to output parameters */
86: x_msg_header := l_msg_header ;
79: XNP_XML_UTILS.xml_decl ;
80: XNP_XML_UTILS.begin_segment ( 'MESSAGE') ;
81: XNP_XML_UTILS.write_element( 'HEADER', l_xml_header );
82: XNP_XML_UTILS.append ( l_xml_body ) ;
83: XNP_XML_UTILS.end_segment ( 'MESSAGE') ;
84: XNP_XML_UTILS.get_document( l_xml_doc ) ;
85: /* assign the header and msg text to output parameters */
86: x_msg_header := l_msg_header ;
87: x_msg_text := l_xml_doc ;
80: XNP_XML_UTILS.begin_segment ( 'MESSAGE') ;
81: XNP_XML_UTILS.write_element( 'HEADER', l_xml_header );
82: XNP_XML_UTILS.append ( l_xml_body ) ;
83: XNP_XML_UTILS.end_segment ( 'MESSAGE') ;
84: XNP_XML_UTILS.get_document( l_xml_doc ) ;
85: /* assign the header and msg text to output parameters */
86: x_msg_header := l_msg_header ;
87: x_msg_text := l_xml_doc ;
88: /* handle exceptions */