DBA Data[Home] [Help]

APPS.XNP_MESSAGE dependencies on XDP_UTILITIES

Line 545: (xdp_utilities.g_message_list.COUNT < 0)

541: END IF ;
542:
543: IF (((l_msg_header.direction_indr = 'I') OR
544: (l_msg_header.direction_indr IS NULL)) AND
545: (xdp_utilities.g_message_list.COUNT < 0)
546: ) THEN
547: decode_xnp_msgs(l_msg_header, p_body_text) ;
548: END IF ;
549:

Line 594: IF xdp_utilities.g_message_list.COUNT > 0 THEN

590: fnd_global.user_id,
591: SYSDATE )
592: RETURNING body_text INTO l_lob_loc ;
593:
594: IF xdp_utilities.g_message_list.COUNT > 0 THEN
595:
596: FOR i IN 1..xdp_utilities.g_message_list.COUNT
597: LOOP
598:

Line 596: FOR i IN 1..xdp_utilities.g_message_list.COUNT

592: RETURNING body_text INTO l_lob_loc ;
593:
594: IF xdp_utilities.g_message_list.COUNT > 0 THEN
595:
596: FOR i IN 1..xdp_utilities.g_message_list.COUNT
597: LOOP
598:
599: DBMS_LOB.WRITEAPPEND (lob_loc => l_lob_loc,
600: amount =>LENGTH(xdp_utilities.g_message_list(i)),

Line 600: amount =>LENGTH(xdp_utilities.g_message_list(i)),

596: FOR i IN 1..xdp_utilities.g_message_list.COUNT
597: LOOP
598:
599: DBMS_LOB.WRITEAPPEND (lob_loc => l_lob_loc,
600: amount =>LENGTH(xdp_utilities.g_message_list(i)),
601: buffer =>xdp_utilities.g_message_list(i));
602: END LOOP ;
603: ELSE
604: DBMS_LOB.WRITE (lob_loc => l_lob_loc,

Line 601: buffer =>xdp_utilities.g_message_list(i));

597: LOOP
598:
599: DBMS_LOB.WRITEAPPEND (lob_loc => l_lob_loc,
600: amount =>LENGTH(xdp_utilities.g_message_list(i)),
601: buffer =>xdp_utilities.g_message_list(i));
602: END LOOP ;
603: ELSE
604: DBMS_LOB.WRITE (lob_loc => l_lob_loc,
605: amount => LENGTH(p_body_text),

Line 1586: -- l_performer := xdp_utilities.get_wf_notifrecipient(l_role_name) ;

1582: IF l_performer IS NULL OR l_performer IN ('NP_SYSADMIN','OP_SYSADMIN') THEN
1583: l_performer := 'FND_RESP535:21704';
1584: END IF;
1585:
1586: -- l_performer := xdp_utilities.get_wf_notifrecipient(l_role_name) ;
1587:
1588: l_item_type := 'XDPWFSTD' ;
1589:
1590: xnp_message.get_sequence(l_msg_id) ;

Line 2059: XDP_UTILITIES.WRITE_TABLE_TO_CLOB(p_source_table => xdp_utilities.g_message_list,

2055: ELSE
2056: my_enqueue_options.visibility := DBMS_AQ.ON_COMMIT ;
2057: END IF ;
2058:
2059: XDP_UTILITIES.WRITE_TABLE_TO_CLOB(p_source_table => xdp_utilities.g_message_list,
2060: p_dest_clob => xdp_utilities.g_clob,
2061: x_error_code => x_error_code ,
2062: x_error_description => x_error_message );
2063: XNP_XML_UTILS.INITIALIZE_DOC;

Line 2060: p_dest_clob => xdp_utilities.g_clob,

2056: my_enqueue_options.visibility := DBMS_AQ.ON_COMMIT ;
2057: END IF ;
2058:
2059: XDP_UTILITIES.WRITE_TABLE_TO_CLOB(p_source_table => xdp_utilities.g_message_list,
2060: p_dest_clob => xdp_utilities.g_clob,
2061: x_error_code => x_error_code ,
2062: x_error_description => x_error_message );
2063: XNP_XML_UTILS.INITIALIZE_DOC;
2064:

Line 2072: l_event.EVENT_DATA := xdp_utilities.g_clob ;

2068: l_event.SEND_DATE := sysdate ;
2069: l_event.CORRELATION_ID := l_correlation_id ;
2070: l_event.EVENT_NAME := l_msg_header.message_code;
2071: l_event.EVENT_KEY := l_event_key ;
2072: l_event.EVENT_DATA := xdp_utilities.g_clob ;
2073:
2074: DBMS_AQ.ENQUEUE (
2075: queue_name => p_queue_name ,
2076: enqueue_options => my_enqueue_options,

Line 2081: DBMS_LOB.FREETEMPORARY(XDP_UTILITIES.G_CLOB);

2077: message_properties => message_properties,
2078: payload => l_event,
2079: msgid => message_handle ) ;
2080:
2081: DBMS_LOB.FREETEMPORARY(XDP_UTILITIES.G_CLOB);
2082:
2083: END PUSH_WF;
2084: --Package initialization code
2085: