DBA Data[Home] [Help]

APPS.ECX_ENG_UTILS dependencies on ECX_UTILS

Line 55: raise ecx_utils.program_exit;

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
58: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.GENERATE_CXML_PAYLOADID');
59: if(l_unexpectedEnabled) then

Line 66: raise ecx_utils.program_exit;

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:
69: end generate_cXML_payloadID;
70:

Line 120: raise ecx_utils.program_exit;

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:
123:
124: -- converts oracle date into cXML datetime format

Line 214: when ecx_utils.program_exit then

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
216: ecx_debug.pop(i_method_name);
217: end if;
218: raise ecx_utils.program_exit;

Line 218: raise ecx_utils.program_exit;

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');
221: if(l_unexpectedEnabled) then
222: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_ENG_UTILS.CONVERT_TO_CXML_DATETIME',

Line 228: raise ecx_utils.program_exit;

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:
231:
232: -- converts the cxml datetime to oracle date

Line 280: raise ecx_utils.program_exit;

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
282: x_ora_date := to_date(l_format_date, 'YYYYMMDD HH24MISS');
283: end if;
284: else

Line 291: when ecx_utils.program_exit then

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
293: ecx_debug.pop(i_method_name);
294: end if;
295: raise ecx_utils.program_exit;

Line 295: raise ecx_utils.program_exit;

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
298: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.CONVERT_FROM_CXML_DATETIME');
299: if(l_unexpectedEnabled) then

Line 305: raise ecx_utils.program_exit;

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:
308:
309: /*

Line 311: stored in ecx_utils.g_tp_dtl_id

307:
308:
309: /*
310: Return the password from ecx_tp_details based on the tp_detail_id
311: stored in ecx_utils.g_tp_dtl_id
312: */
313: procedure get_tp_pwd (
314: x_password OUT NOCOPY Varchar2
315: )

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 330: where tp_detail_id = ecx_utils.g_tp_dtl_id;

326: end if;
327: select password
328: into x_password
329: from ecx_tp_details
330: where tp_detail_id = ecx_utils.g_tp_dtl_id;
331:
332: if (x_password is not null)
333: then
334: x_password := ecx_eng_utils.PWD_SPEC_CODE || x_password ||

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 352: raise ecx_utils.program_exit;

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
355: if (l_procedureEnabled) then
356: ecx_debug.pop(i_method_name);

Line 354: when ecx_utils.program_exit 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
355: if (l_procedureEnabled) then
356: ecx_debug.pop(i_method_name);
357: end if;
358: raise ecx_utils.program_exit;

Line 358: raise ecx_utils.program_exit;

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
361: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_ENG_UTILS.GET_TP_PASSWORD');
362: if(l_unexpectedEnabled) then

Line 368: raise ecx_utils.program_exit;

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;
371:
372:

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 477: raise ecx_utils.program_exit;

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.
481: -- we want to keep the same value if this is not able to decrypt.

Line 509: raise ecx_utils.program_exit;

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:
512:
513: end ecx_eng_utils;