eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ECX_ENG_UTILS dependencies on ECX_DEBUG

Line 4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;

1: package body ecx_eng_utils as
2: -- $Header: ECXENUTB.pls 120.3 2006/05/24 16:24:01 susaha ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;

Line 5: l_statement PLS_INTEGER := ecx_debug.g_statement;

1: package body ecx_eng_utils as
2: -- $Header: ECXENUTB.pls 120.3 2006/05/24 16:24:01 susaha ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;

Line 6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;

2: -- $Header: ECXENUTB.pls 120.3 2006/05/24 16:24:01 susaha ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
10:

Line 7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;

3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
10:
11: -- generates a cXML standard conforming payloadID

Line 8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;

4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
10:
11: -- generates a cXML standard conforming payloadID
12: procedure generate_cXML_payloadID (p_document_number in varchar2,

Line 9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;

5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
10:
11: -- generates a cXML standard conforming payloadID
12: procedure generate_cXML_payloadID (p_document_number in varchar2,
13: x_payload_id out NOCOPY varchar2)

Line 27: ecx_debug.push(i_method_name);

23:
24: begin
25:
26: if (l_procedureEnabled) then
27: ecx_debug.push(i_method_name);
28: end if;
29:
30: if (p_document_number is null) then
31: raise invalid_input;

Line 41: ecx_debug.pop(i_method_name);

37:
38: x_payload_id := (date_time || '.' || p_document_number || '.' || random_number || '@' || logical_id);
39:
40: if (l_procedureEnabled) then
41: ecx_debug.pop(i_method_name);
42: end if;
43:
44: exception
45:

Line 47: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.GENERATE_CXML_PAYLOADID INVALID INPUT DOCUMENT NUMBER');

43:
44: exception
45:
46: when invalid_input then
47: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.GENERATE_CXML_PAYLOADID INVALID INPUT DOCUMENT NUMBER');
48: if(l_unexpectedEnabled) then
49: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.GENERATE_CXML_PAYLOADID',
50: i_method_name);
51: end if;

Line 49: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.GENERATE_CXML_PAYLOADID',

45:
46: when invalid_input then
47: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.GENERATE_CXML_PAYLOADID INVALID INPUT DOCUMENT NUMBER');
48: if(l_unexpectedEnabled) then
49: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.GENERATE_CXML_PAYLOADID',
50: i_method_name);
51: end if;
52: if (l_procedureEnabled) then
53: ecx_debug.pop(i_method_name);

Line 53: ecx_debug.pop(i_method_name);

49: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.GENERATE_CXML_PAYLOADID',
50: i_method_name);
51: end if;
52: if (l_procedureEnabled) then
53: ecx_debug.pop(i_method_name);
54: end if;
55: raise ecx_utils.program_exit;
56:
57: when others then

Line 58: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.GENERATE_CXML_PAYLOADID');

54: end if;
55: raise ecx_utils.program_exit;
56:
57: when others then
58: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.GENERATE_CXML_PAYLOADID');
59: if(l_unexpectedEnabled) then
60: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.GENERATE_CXML_PAYLOADID',
61: i_method_name);
62: end if;

Line 60: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.GENERATE_CXML_PAYLOADID',

56:
57: when others then
58: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.GENERATE_CXML_PAYLOADID');
59: if(l_unexpectedEnabled) then
60: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.GENERATE_CXML_PAYLOADID',
61: i_method_name);
62: end if;
63: if (l_procedureEnabled) then
64: ecx_debug.pop(i_method_name);

Line 64: ecx_debug.pop(i_method_name);

60: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.GENERATE_CXML_PAYLOADID',
61: i_method_name);
62: end if;
63: if (l_procedureEnabled) then
64: ecx_debug.pop(i_method_name);
65: end if;
66: raise ecx_utils.program_exit;
67:
68:

Line 93: ecx_debug.push(i_method_name);

89: l_month varchar2(200);
90: l_day varchar2(200);
91: begin
92: if (l_procedureEnabled) then
93: ecx_debug.push(i_method_name);
94: end if;
95: if (p_ora_date is not null)
96: then
97: l_year := to_char(p_ora_date, 'YYYY');

Line 107: ecx_debug.pop(i_method_name);

103: x_cxml_date := null;
104: end if;
105:
106: if (l_procedureEnabled) then
107: ecx_debug.pop(i_method_name);
108: end if;
109:
110: exception
111: when others then

Line 112: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.CONVERT_TO_CXML_DATE');

108: end if;
109:
110: exception
111: when others then
112: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.CONVERT_TO_CXML_DATE');
113: if(l_unexpectedEnabled) then
114: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.CONVERT_TO_CXML_DATE',
115: i_method_name);
116: end if;

Line 114: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.CONVERT_TO_CXML_DATE',

110: exception
111: when others then
112: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.CONVERT_TO_CXML_DATE');
113: if(l_unexpectedEnabled) then
114: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.CONVERT_TO_CXML_DATE',
115: i_method_name);
116: end if;
117: if (l_procedureEnabled) then
118: ecx_debug.pop(i_method_name);

Line 118: ecx_debug.pop(i_method_name);

114: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.CONVERT_TO_CXML_DATE',
115: i_method_name);
116: end if;
117: if (l_procedureEnabled) then
118: ecx_debug.pop(i_method_name);
119: end if;
120: raise ecx_utils.program_exit;
121: end convert_to_cxml_date;
122:

Line 148: ecx_debug.push(i_method_name);

144: l_timezone_sign varchar2(200);
145:
146: begin
147: if (l_procedureEnabled) then
148: ecx_debug.push(i_method_name);
149: end if;
150:
151: l_ora_date := to_char(p_ora_date, 'YYYYMMDD HH24MISS');
152:

Line 211: ecx_debug.pop(i_method_name);

207: else
208: x_cxml_date := null;
209: end if;
210: if (l_procedureEnabled) then
211: ecx_debug.pop(i_method_name);
212: end if;
213: exception
214: when ecx_utils.program_exit then
215: if (l_procedureEnabled) then

Line 216: ecx_debug.pop(i_method_name);

212: end if;
213: exception
214: when ecx_utils.program_exit then
215: if (l_procedureEnabled) then
216: ecx_debug.pop(i_method_name);
217: end if;
218: raise ecx_utils.program_exit;
219: when others then
220: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.CONVERT_TO_CXML_DATETIME');

Line 220: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.CONVERT_TO_CXML_DATETIME');

216: ecx_debug.pop(i_method_name);
217: end if;
218: raise ecx_utils.program_exit;
219: when others then
220: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.CONVERT_TO_CXML_DATETIME');
221: if(l_unexpectedEnabled) then
222: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.CONVERT_TO_CXML_DATETIME',
223: i_method_name);
224: end if;

Line 222: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.CONVERT_TO_CXML_DATETIME',

218: raise ecx_utils.program_exit;
219: when others then
220: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.CONVERT_TO_CXML_DATETIME');
221: if(l_unexpectedEnabled) then
222: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.CONVERT_TO_CXML_DATETIME',
223: i_method_name);
224: end if;
225: if (l_procedureEnabled) then
226: ecx_debug.pop(i_method_name);

Line 226: ecx_debug.pop(i_method_name);

222: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.CONVERT_TO_CXML_DATETIME',
223: i_method_name);
224: end if;
225: if (l_procedureEnabled) then
226: ecx_debug.pop(i_method_name);
227: end if;
228: raise ecx_utils.program_exit;
229: end convert_to_cXML_datetime;
230:

Line 244: ecx_debug.push(i_method_name);

240: l_string varchar2(2000);
241: l_install_mode varchar2(200);
242: begin
243: if (l_procedureEnabled) then
244: ecx_debug.push(i_method_name);
245: end if;
246: if (p_cxml_date is not null)
247: then
248:

Line 274: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_CXML_DATE_FORMAT', 'DATE', p_cxml_date);

270: l_format_date := getDate(p_cxml_date, ecx_eng_utils.g_server_tz);
271:
272: if (l_format_date is null)
273: then
274: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_CXML_DATE_FORMAT', 'DATE', p_cxml_date);
275:
276: if(l_unexpectedEnabled) then
277: ecx_debug.log(l_unexpected, 'ECX', 'ECX_INVALID_CXML_DATE_FORMAT', i_method_name, 'DATE', p_cxml_date);
278: end if;

Line 277: ecx_debug.log(l_unexpected, 'ECX', 'ECX_INVALID_CXML_DATE_FORMAT', i_method_name, 'DATE', p_cxml_date);

273: then
274: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_CXML_DATE_FORMAT', 'DATE', p_cxml_date);
275:
276: if(l_unexpectedEnabled) then
277: ecx_debug.log(l_unexpected, 'ECX', 'ECX_INVALID_CXML_DATE_FORMAT', i_method_name, 'DATE', p_cxml_date);
278: end if;
279:
280: raise ecx_utils.program_exit;
281: else

Line 288: ecx_debug.pop(i_method_name);

284: else
285: x_ora_date := null;
286: end if;
287: if (l_procedureEnabled) then
288: ecx_debug.pop(i_method_name);
289: end if;
290: exception
291: when ecx_utils.program_exit then
292: if (l_procedureEnabled) then

Line 293: ecx_debug.pop(i_method_name);

289: end if;
290: exception
291: when ecx_utils.program_exit then
292: if (l_procedureEnabled) then
293: ecx_debug.pop(i_method_name);
294: end if;
295: raise ecx_utils.program_exit;
296:
297: when others then

Line 298: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.CONVERT_FROM_CXML_DATETIME');

294: end if;
295: raise ecx_utils.program_exit;
296:
297: when others then
298: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.CONVERT_FROM_CXML_DATETIME');
299: if(l_unexpectedEnabled) then
300: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.CONVERT_FROM_CXML_DATETIME',i_method_name);
301: end if;
302: if (l_procedureEnabled) then

Line 300: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.CONVERT_FROM_CXML_DATETIME',i_method_name);

296:
297: when others then
298: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.CONVERT_FROM_CXML_DATETIME');
299: if(l_unexpectedEnabled) then
300: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.CONVERT_FROM_CXML_DATETIME',i_method_name);
301: end if;
302: if (l_procedureEnabled) then
303: ecx_debug.pop(i_method_name);
304: end if;

Line 303: ecx_debug.pop(i_method_name);

299: if(l_unexpectedEnabled) then
300: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.CONVERT_FROM_CXML_DATETIME',i_method_name);
301: end if;
302: if (l_procedureEnabled) then
303: ecx_debug.pop(i_method_name);
304: end if;
305: raise ecx_utils.program_exit;
306: end convert_from_cXML_datetime;
307:

Line 321: ecx_debug.push(i_method_name);

317:
318: i_method_name varchar2(2000) := 'ecx_eng_utils.get_tp_pwd';
319: begin
320: if (l_procedureEnabled) then
321: ecx_debug.push(i_method_name);
322: end if;
323:
324: if(l_statementEnabled) then
325: ecx_debug.log(l_statement, 'tp_detail_id', ecx_utils.g_tp_dtl_id,i_method_name);

Line 325: ecx_debug.log(l_statement, 'tp_detail_id', ecx_utils.g_tp_dtl_id,i_method_name);

321: ecx_debug.push(i_method_name);
322: end if;
323:
324: if(l_statementEnabled) then
325: ecx_debug.log(l_statement, 'tp_detail_id', ecx_utils.g_tp_dtl_id,i_method_name);
326: end if;
327: select password
328: into x_password
329: from ecx_tp_details

Line 338: ecx_debug.log(l_statement,'password', x_password,i_method_name);

334: x_password := ecx_eng_utils.PWD_SPEC_CODE || x_password ||
335: ecx_eng_utils.PWD_SPEC_CODE;
336: end if;
337: if(l_statementEnabled) then
338: ecx_debug.log(l_statement,'password', x_password,i_method_name);
339: end if;
340: if (l_procedureEnabled) then
341: ecx_debug.pop(i_method_name);
342: end if;

Line 341: ecx_debug.pop(i_method_name);

337: if(l_statementEnabled) then
338: ecx_debug.log(l_statement,'password', x_password,i_method_name);
339: end if;
340: if (l_procedureEnabled) then
341: ecx_debug.pop(i_method_name);
342: end if;
343: exception
344: when no_data_found then
345: ecx_debug.setErrorInfo(1, 30, 'ECX_TP_DTL_ID_NOT_FOUND', 'TP_DTL_ID', ecx_utils.g_tp_dtl_id);

Line 345: ecx_debug.setErrorInfo(1, 30, 'ECX_TP_DTL_ID_NOT_FOUND', 'TP_DTL_ID', ecx_utils.g_tp_dtl_id);

341: ecx_debug.pop(i_method_name);
342: end if;
343: exception
344: when no_data_found then
345: ecx_debug.setErrorInfo(1, 30, 'ECX_TP_DTL_ID_NOT_FOUND', 'TP_DTL_ID', ecx_utils.g_tp_dtl_id);
346: if(l_unexpectedEnabled) then
347: ecx_debug.log(l_unexpected,'ECX', 'ECX_TP_DTL_ID_NOT_FOUND', 'TP_DTL_ID', ecx_utils.g_tp_dtl_id,i_method_name);
348: end if;
349: if (l_procedureEnabled) then

Line 347: ecx_debug.log(l_unexpected,'ECX', 'ECX_TP_DTL_ID_NOT_FOUND', 'TP_DTL_ID', ecx_utils.g_tp_dtl_id,i_method_name);

343: exception
344: when no_data_found then
345: ecx_debug.setErrorInfo(1, 30, 'ECX_TP_DTL_ID_NOT_FOUND', 'TP_DTL_ID', ecx_utils.g_tp_dtl_id);
346: if(l_unexpectedEnabled) then
347: ecx_debug.log(l_unexpected,'ECX', 'ECX_TP_DTL_ID_NOT_FOUND', 'TP_DTL_ID', ecx_utils.g_tp_dtl_id,i_method_name);
348: end if;
349: if (l_procedureEnabled) then
350: ecx_debug.pop(i_method_name);
351: end if;

Line 350: ecx_debug.pop(i_method_name);

346: if(l_unexpectedEnabled) then
347: ecx_debug.log(l_unexpected,'ECX', 'ECX_TP_DTL_ID_NOT_FOUND', 'TP_DTL_ID', ecx_utils.g_tp_dtl_id,i_method_name);
348: end if;
349: if (l_procedureEnabled) then
350: ecx_debug.pop(i_method_name);
351: end if;
352: raise ecx_utils.program_exit;
353:
354: when ecx_utils.program_exit then

Line 356: ecx_debug.pop(i_method_name);

352: raise ecx_utils.program_exit;
353:
354: when ecx_utils.program_exit then
355: if (l_procedureEnabled) then
356: ecx_debug.pop(i_method_name);
357: end if;
358: raise ecx_utils.program_exit;
359:
360: when others then

Line 361: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.GET_TP_PASSWORD');

357: end if;
358: raise ecx_utils.program_exit;
359:
360: when others then
361: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.GET_TP_PASSWORD');
362: if(l_unexpectedEnabled) then
363: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.GET_TP_PASSWORD',i_method_name);
364: end if;
365: if (l_procedureEnabled) then

Line 363: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.GET_TP_PASSWORD',i_method_name);

359:
360: when others then
361: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.GET_TP_PASSWORD');
362: if(l_unexpectedEnabled) then
363: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.GET_TP_PASSWORD',i_method_name);
364: end if;
365: if (l_procedureEnabled) then
366: ecx_debug.pop(i_method_name);
367: end if;

Line 366: ecx_debug.pop(i_method_name);

362: if(l_unexpectedEnabled) then
363: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.GET_TP_PASSWORD',i_method_name);
364: end if;
365: if (l_procedureEnabled) then
366: ecx_debug.pop(i_method_name);
367: end if;
368: raise ecx_utils.program_exit;
369:
370: end get_tp_pwd;

Line 397: ecx_debug.push(i_method_name);

393:
394: begin
395:
396: if (l_procedureEnabled) then
397: ecx_debug.push(i_method_name);
398: end if;
399:
400: if (p_clob is null) then
401: return;

Line 427: ecx_debug.log(l_statement,'l_start_code_pos', l_start_code_pos,i_method_name);

423: -- Get the start offset of special character field.
424: l_start_code_pos := dbms_lob.instr(p_clob, l_start_code, l_offset);
425:
426: if(l_statementEnabled) then
427: ecx_debug.log(l_statement,'l_start_code_pos', l_start_code_pos,i_method_name);
428: end if;
429:
430: -- if cannot find the special char anymore, then write the rest of the clob.
431: if (l_start_code_pos = 0 or l_start_code_pos is null) then

Line 448: ecx_debug.log(l_statement,'l_end_code_pos', l_end_code_pos,i_method_name);

444: l_end_code_pos := dbms_lob.instr(p_clob, l_end_code,
445: l_start_code_pos + l_start_code_len);
446:
447: if(l_statementEnabled) then
448: ecx_debug.log(l_statement,'l_end_code_pos', l_end_code_pos,i_method_name);
449: end if;
450: l_spec_str_len := l_end_code_pos - (l_start_code_pos + l_start_code_len);
451:
452: if (l_spec_str_len > 0) then

Line 464: ecx_debug.log(l_statement,'String before decryption', l_spec_str,i_method_name);

460: ecx_print_local.replace_spec_char(p_value => l_out_string,
461: x_value => l_spec_str);
462:
463: if(l_statementEnabled) then
464: ecx_debug.log(l_statement,'String before decryption', l_spec_str,i_method_name);
465: end if;
466: ecx_obfuscate.ecx_data_encrypt(l_input_string => l_spec_str,
467: l_qual_code => 'D',
468: l_output_string => l_out_string,

Line 474: ecx_debug.log(l_unexpected,'Decryption API Error', l_errmsg,i_method_name);

470: retcode => l_errcode);
471:
472: if (l_errcode <> 0) then
473: if(l_unexpectedEnabled) then
474: ecx_debug.log(l_unexpected,'Decryption API Error', l_errmsg,i_method_name);
475: end if;
476: ecx_debug.setErrorInfo(l_errcode, ecx_utils.error_type, l_errmsg);
477: raise ecx_utils.program_exit;
478: end if;

Line 476: ecx_debug.setErrorInfo(l_errcode, ecx_utils.error_type, l_errmsg);

472: if (l_errcode <> 0) then
473: if(l_unexpectedEnabled) then
474: ecx_debug.log(l_unexpected,'Decryption API Error', l_errmsg,i_method_name);
475: end if;
476: ecx_debug.setErrorInfo(l_errcode, ecx_utils.error_type, l_errmsg);
477: raise ecx_utils.program_exit;
478: end if;
479:
480: -- if it is not a valid encrypted password, ecx_data_encrypt returns null.

Line 496: ecx_debug.pop(i_method_name);

492: l_offset := l_end_code_pos + l_end_code_len;
493: end if;
494: end loop;
495: if (l_procedureEnabled) then
496: ecx_debug.pop(i_method_name);
497: end if;
498:
499: exception
500: when others then

Line 501: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.convertEncryCodeClob');

497: end if;
498:
499: exception
500: when others then
501: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.convertEncryCodeClob');
502: if(l_unexpectedEnabled) then
503: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.convertEncryCodeClob',
504: i_method_name);
505: end if;

Line 503: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.convertEncryCodeClob',

499: exception
500: when others then
501: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.convertEncryCodeClob');
502: if(l_unexpectedEnabled) then
503: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.convertEncryCodeClob',
504: i_method_name);
505: end if;
506: if (l_procedureEnabled) then
507: ecx_debug.pop(i_method_name);

Line 507: ecx_debug.pop(i_method_name);

503: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.convertEncryCodeClob',
504: i_method_name);
505: end if;
506: if (l_procedureEnabled) then
507: ecx_debug.pop(i_method_name);
508: end if;
509: raise ecx_utils.program_exit;
510: end convertEncryCodeClob;
511: