APPS.XDP_ERRORS_PKG dependencies on XDP_ERROR_LOG

Line 13: l_message_parameters xdp_error_log.message_parameters%TYPE;

9: p_message_name IN VARCHAR2,
10: p_message_parameters IN VARCHAR2,
11: p_error_type IN VARCHAR2 DEFAULT pv_typeSystem)
12: IS
13: l_message_parameters xdp_error_log.message_parameters%TYPE;
14: MSG varchar2(2000);
15: begin
16:
17: --

Line 35: insert into XDP_ERROR_LOG (

31: l_message_parameters := REPLACE(p_message_parameters, chr(0));
32:
33: if ((MSG is NOT NULL) AND (LENGTH(MSG) <> 0)) then
34:
35: insert into XDP_ERROR_LOG (
36: ERROR_ID,
37: OBJECT_TYPE,
38: OBJECT_KEY,
39: ERROR_TIMESTAMP,

Line 130: l_message_params xdp_error_log.message_parameters%TYPE;

126: l_pkg_count NUMBER;
127: l_workitem_count NUMBER;
128: l_fa_count NUMBER;
129: l_message_type VARCHAR2(100);
130: l_message_params xdp_error_log.message_parameters%TYPE;
131: l_message xdp_error_log.message_parameters%TYPE;
132: l_error_type VARCHAR2(100);
133:
134: BEGIN

Line 131: l_message xdp_error_log.message_parameters%TYPE;

127: l_workitem_count NUMBER;
128: l_fa_count NUMBER;
129: l_message_type VARCHAR2(100);
130: l_message_params xdp_error_log.message_parameters%TYPE;
131: l_message xdp_error_log.message_parameters%TYPE;
132: l_error_type VARCHAR2(100);
133:
134: BEGIN
135:

Line 206: l_temp_1 xdp_error_log.message_parameters%TYPE;

202: p_message_name IN VARCHAR2,
203: p_message_parameters IN VARCHAR2)
204: return VARCHAR2
205: is
206: l_temp_1 xdp_error_log.message_parameters%TYPE;
207: l_temp_2 xdp_error_log.message_parameters%TYPE;
208: l_name xdp_error_log.message_parameters%TYPE;
209: l_value xdp_error_log.message_parameters%TYPE;
210: l_offset NUMBER;

Line 207: l_temp_2 xdp_error_log.message_parameters%TYPE;

203: p_message_parameters IN VARCHAR2)
204: return VARCHAR2
205: is
206: l_temp_1 xdp_error_log.message_parameters%TYPE;
207: l_temp_2 xdp_error_log.message_parameters%TYPE;
208: l_name xdp_error_log.message_parameters%TYPE;
209: l_value xdp_error_log.message_parameters%TYPE;
210: l_offset NUMBER;
211: l_offset1 NUMBER;

Line 208: l_name xdp_error_log.message_parameters%TYPE;

204: return VARCHAR2
205: is
206: l_temp_1 xdp_error_log.message_parameters%TYPE;
207: l_temp_2 xdp_error_log.message_parameters%TYPE;
208: l_name xdp_error_log.message_parameters%TYPE;
209: l_value xdp_error_log.message_parameters%TYPE;
210: l_offset NUMBER;
211: l_offset1 NUMBER;
212: l_last_offset NUMBER;

Line 209: l_value xdp_error_log.message_parameters%TYPE;

205: is
206: l_temp_1 xdp_error_log.message_parameters%TYPE;
207: l_temp_2 xdp_error_log.message_parameters%TYPE;
208: l_name xdp_error_log.message_parameters%TYPE;
209: l_value xdp_error_log.message_parameters%TYPE;
210: l_offset NUMBER;
211: l_offset1 NUMBER;
212: l_last_offset NUMBER;
213: l_message_text xdp_error_log.message_parameters%TYPE;

Line 213: l_message_text xdp_error_log.message_parameters%TYPE;

209: l_value xdp_error_log.message_parameters%TYPE;
210: l_offset NUMBER;
211: l_offset1 NUMBER;
212: l_last_offset NUMBER;
213: l_message_text xdp_error_log.message_parameters%TYPE;
214:
215: BEGIN
216: l_message_text := '';
217:

Line 277: from XDP_ERROR_LOG_V

273: BEGIN
274: begin
275: select message, error_type, MAX(error_timestamp)
276: into p_message, p_error_type, p_message_timestamp
277: from XDP_ERROR_LOG_V
278: where object_type = p_object_type and object_key = p_object_key;
279: exception
280: WHEN NO_DATA_FOUND then
281: null;