PACKAGE: APPS.ECX_UTIL_API

Source

1 PACKAGE ECX_UTIL_API AUTHID CURRENT_USER AS
2 -- $Header: ECXUTLAS.pls 120.1.12020000.2 2013/03/21 11:21:48 jmaddila ship $
3 
4 /**
5 API return codes
6 **/
7 
8 G_NO_ERROR      pls_integer := 0;          -- success without any error.
9 G_WARNING       pls_integer := 1;          -- generic warning.
10 G_UNEXP_ERROR   pls_integer := 2;          -- when others exception is raised, generic error.
11 G_NULL_PARAM    pls_integer := 3;          -- any of non-nullable parameters have null value.
12 G_INVALID_PARAM pls_integer := 4;          -- parameters have an invalid value.
13 G_DUP_ERROR     pls_integer := 5;          -- duplicate row when insert.
14 G_NO_DATA_ERROR pls_integer := 6;          -- no data found when retrieve/update/delete.
15 G_TOO_MANY_ROWS pls_integer := 7;          -- select returns more than 1 row.
16 G_REFER_ERROR   pls_integer := 8;          -- has other table refer to it when delete.
17 
18 
19 function validate_direction
20 	(
21    	p_direction in varchar2
22    	) return boolean;
23 
24 Function validate_party_type
25 	(
26        	p_party_type In Varchar2
27        	)  return boolean;
28 
29 /* Bug 2122579 */
30 Function validate_party_id
31 	(
32 	p_party_type In Varchar2,
33 	p_party_id In number
34 	) return boolean;
35 
36 Function validate_party_site_id
37 	(
38 	p_party_type In Varchar2,
39 	p_party_id   In number,
40 	p_party_site_id In number
41 	) return boolean;
42 
43 Function validate_email_address
44 	(
45 	p_email_addr In Varchar2
46 	) return boolean;
47 
48 Function validate_password_length
49 	(
50 	p_password In varchar2
51 	) return boolean;
52 
53 /* New function added for bug #2410173 to verify special characters
54    and to trim spaces in the password */
55 Function validate_password
56         (
57         x_password In Out NOCOPY varchar2
58 
59         ) return boolean;
60 
61 Function validate_confirmation_code
62 	(
63 	p_confirmation In Varchar2
64 	)  return boolean;
65 
66 Function validate_protocol_type
67 	(
68 	p_protocol_type In Varchar2
69 	)  return boolean;
70 
71 Function validate_queue_name
72 	(
73 	p_queue_name In Varchar2
74 	)  return boolean;
75 
76 Function validate_trading_partner
77         (
78         p_tp_header_id  In      Varchar2
79         )  return boolean;
80 
81 Function validate_data_seeded_flag(
82    p_data_seeded    In Varchar2
83    ) return boolean;
84 
85 
86 PROCEDURE validate_user(
87    p_username           IN  VARCHAR2,
88    p_password           IN  VARCHAR2,
89    p_party_id           IN  VARCHAR2,
90    p_party_site_id      IN  VARCHAR2,
91    p_party_type         IN  VARCHAR2,
92    x_ret_code           OUT NOCOPY PLS_INTEGER);
93 
94 PROCEDURE retrieve_customer_id(
95    p_username           IN  VARCHAR2,
96    p_description        IN  VARCHAR2,
97    x_person_party_id    OUT NOCOPY NUMBER);
98 
99 PROCEDURE retrieve_site_party_id(
100    p_person_party_id IN  NUMBER,
101    x_party_id        OUT NOCOPY VARCHAR2,
102    x_status          OUT NOCOPY VARCHAR2,
103    x_msg             OUT NOCOPY VARCHAR2);
104 
105 Function getIANACharset return varchar2;
106 Function getValidationFlag return boolean;
107 Function getMaximumXMLSize return Number;
108 
109 procedure parseXML(
110    p_parser     IN          xmlparser.parser,
111    p_xmlclob    IN          clob,
112    x_validate   OUT NOCOPY  boolean,
113    x_xmldoc     OUT NOCOPY  xmlDOM.DOMNode);
114 /*Returns true if value of profile ECX_IN_JAVA_PROCESSING is Y, else false*/
115 function isInJavaProcessEnabled return boolean;
116 
117 END ECX_UTIL_API;