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