1 package ecx_inbound_trig AUTHID CURRENT_USER as
2 -- $Header: ECXINBTS.pls 120.1.12020000.3 2013/04/30 18:17:44 jmaddila ship $
3
4 procedure getmsg_from_queue
5 (
6 i_queue_name IN varchar2,
7 i_msgid OUT NOCOPY RAW
8 );
9
10 procedure processmsg_from_queue
11 (
12 i_queue_name IN varchar2,
13 i_debug_level IN pls_integer
14 );
15
16 procedure processmsg_from_table
17 (
18 i_msgid IN RAW,
19 i_debug_level IN pls_integer
20 );
21
22 /** Old put_on_outbound**/
23 procedure put_on_outbound
24 (
25 i_xmldoc IN OUT NOCOPY CLOB,
26 i_document_number IN varchar2,
27 i_tp_detail_id IN pls_integer
28 );
29
30 procedure put_on_outbound
31 (
32 i_xmldoc IN OUT NOCOPY CLOB,
33 i_document_number IN varchar2,
34 i_tp_detail_id IN pls_integer,
35 i_msgid IN raw
36 );
37
38 procedure wrap_validate_message
39 (
40 i_msgid IN RAW,
41 i_debug_level IN pls_integer,
42 i_trigger_id OUT NOCOPY pls_integer
43 );
44
45 /** New wrap_validate_message - with BES **/
46 procedure wrap_validate_message
47 (
48 i_msgid IN RAW,
49 i_debug_level IN pls_integer
50 );
51
52 procedure validate_message
53 (
54 m_msgid IN raw,
55 m_message_standard IN varchar2,
56 m_ext_type in varchar2,
57 m_ext_subtype in varchar2,
58 m_party_ext_code IN varchar2,
59 m_document_number IN varchar2,
60 m_routing_ext_code IN varchar2,
61 m_payload IN clob,
62 m_message_type IN varchar2
63 );
64
65 procedure processXML
66 (
67 i_map_code IN varchar2,
68 i_payload IN CLOB,
69 i_debug_level IN pls_integer,
70 i_ret_code OUT NOCOPY pls_integer,
71 i_errbuf OUT NOCOPY varchar2,
72 i_log_file OUT NOCOPY varchar2,
73 o_payload OUT NOCOPY CLOB,
74 i_message_standard IN varchar2 default 'OAG',
75 i_message_type IN varchar2 default 'XML'
76 );
77
78 procedure reprocess
79 (
80 i_msgid IN RAW,
81 i_debug_level IN pls_integer,
82 i_trigger_id OUT NOCOPY number,
83 i_retcode OUT NOCOPY pls_integer,
84 i_errbuf OUT NOCOPY varchar2
85 );
86 /*
87 * Raising an event(oracle.apps.ecx.inbound.process_at_java)
88 * which has subscription to Java function which process
89 * the inbound message
90 */
91 procedure raiseEvent
92 (i_msgid IN raw,
93 i_document_number IN varchar2,
94 i_map_id IN pls_integer,
95 i_rcv_tp_id IN pls_integer,
96 i_payload IN clob,
97 i_no_routing IN varchar2);
98
99 /*
100 * This api is to set the notified WF process function to error with name
101 * and stack trace
102 */
103 procedure setWFFunctionErrorStatus(
104 i_itemtype IN varchar2,
105 i_itemkey IN varchar2,
106 i_actid IN varchar2,
107 i_errcode IN varchar2,
108 i_errmsg IN varchar2,
109 i_errparams IN varchar2,
110 i_logfile IN varchar2,
111 i_errorstack IN varchar2
112 );
113 end ecx_inbound_trig;