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_ENG_UTILS

Line 1: package body ecx_eng_utils as

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;

Line 17: i_method_name varchar2(2000) := 'ecx_eng_utils.generate_cXML_payloadID';

13: x_payload_id out NOCOPY varchar2)
14: is
15:
16:
17: i_method_name varchar2(2000) := 'ecx_eng_utils.generate_cXML_payloadID';
18:
19: random_number NUMBER := null;
20: logical_id VARCHAR2(2000) := null;
21: date_time VARCHAR2(100) := null;

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 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 87: i_method_name varchar2(2000) := 'ecx_eng_utils.convert_to_cxml_date';

83: x_cxml_date out NOCOPY varchar2
84: )
85: is
86:
87: i_method_name varchar2(2000) := 'ecx_eng_utils.convert_to_cxml_date';
88: l_year varchar2(200);
89: l_month varchar2(200);
90: l_day varchar2(200);
91: begin

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 130: i_method_name varchar2(2000) := 'ecx_eng_utils.convert_to_cXML_datetime';

126: x_cxml_date out NOCOPY varchar2
127: )
128: is
129:
130: i_method_name varchar2(2000) := 'ecx_eng_utils.convert_to_cXML_datetime';
131: l_ora_date varchar2(200);
132: l_install_mode varchar2(200);
133: l_year varchar2(200);
134: l_month varchar2(200);

Line 156: if (ecx_eng_utils.g_server_tz is null) then

152:
153: if (l_ora_date is not null)
154: then
155:
156: if (ecx_eng_utils.g_server_tz is null) then
157: -- get the timezone string
158: -- Check for the Installation Type ( Standalone or Embedded );
159: l_install_mode := wf_core.translate('WF_INSTALL');
160: if l_install_mode = 'EMBEDDED'

Line 163: fnd_profile.get(' || '''ECX_SERVER_TIMEZONE''' || ', ecx_eng_utils.g_server_tz);

159: l_install_mode := wf_core.translate('WF_INSTALL');
160: if l_install_mode = 'EMBEDDED'
161: then
162: l_string := 'begin
163: fnd_profile.get(' || '''ECX_SERVER_TIMEZONE''' || ', ecx_eng_utils.g_server_tz);
164: end;';
165: execute immediate l_string ;
166: else
167: ecx_eng_utils.g_server_tz:= wf_core.translate('ECX_SERVER_TIMEZONE');

Line 167: ecx_eng_utils.g_server_tz:= wf_core.translate('ECX_SERVER_TIMEZONE');

163: fnd_profile.get(' || '''ECX_SERVER_TIMEZONE''' || ', ecx_eng_utils.g_server_tz);
164: end;';
165: execute immediate l_string ;
166: else
167: ecx_eng_utils.g_server_tz:= wf_core.translate('ECX_SERVER_TIMEZONE');
168: end if;
169: end if;
170:
171: if (ecx_eng_utils.g_server_tz is null)

Line 171: if (ecx_eng_utils.g_server_tz is null)

167: ecx_eng_utils.g_server_tz:= wf_core.translate('ECX_SERVER_TIMEZONE');
168: end if;
169: end if;
170:
171: if (ecx_eng_utils.g_server_tz is null)
172: then
173: ecx_eng_utils.g_server_tz := 'GMT';
174: end if;
175:

Line 173: ecx_eng_utils.g_server_tz := 'GMT';

169: end if;
170:
171: if (ecx_eng_utils.g_server_tz is null)
172: then
173: ecx_eng_utils.g_server_tz := 'GMT';
174: end if;
175:
176: l_year := to_char(p_ora_date, 'YYYY');
177: l_month := to_char(p_ora_date, 'MM');

Line 187: ecx_eng_utils.g_server_tz);

183: -- get the deviation
184: l_offset := ecx_actions.getTimezoneOffset( to_number(l_year), to_number(l_month),
185: to_number(l_day), to_number(l_hour),
186: to_number(l_min), to_number(l_sec),
187: ecx_eng_utils.g_server_tz);
188:
189: if l_offset >= 0 then
190: l_timezone_sign := '+';
191: end if;

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 238: i_method_name varchar2(2000) := 'ecx_eng_utils.convert_from_cXML_datetime';

234: x_ora_date out NOCOPY date
235: )
236: is
237:
238: i_method_name varchar2(2000) := 'ecx_eng_utils.convert_from_cXML_datetime';
239: l_format_date varchar2(200);
240: l_string varchar2(2000);
241: l_install_mode varchar2(200);
242: begin

Line 249: if (ecx_eng_utils.g_server_tz is null) then

245: end if;
246: if (p_cxml_date is not null)
247: then
248:
249: if (ecx_eng_utils.g_server_tz is null) then
250: -- get the DB timezone ID
251: -- Check for the Installation Type ( Standalone or Embedded );
252: l_install_mode := wf_core.translate('WF_INSTALL');
253:

Line 257: fnd_profile.get(' || '''ECX_SERVER_TIMEZONE''' || ', ecx_eng_utils.g_server_tz);

253:
254: if l_install_mode = 'EMBEDDED'
255: then
256: l_string := 'begin
257: fnd_profile.get(' || '''ECX_SERVER_TIMEZONE''' || ', ecx_eng_utils.g_server_tz);
258: end;';
259: execute immediate l_string ;
260: else
261: ecx_eng_utils.g_server_tz:= wf_core.translate('ECX_SERVER_TIMEZONE');

Line 261: ecx_eng_utils.g_server_tz:= wf_core.translate('ECX_SERVER_TIMEZONE');

257: fnd_profile.get(' || '''ECX_SERVER_TIMEZONE''' || ', ecx_eng_utils.g_server_tz);
258: end;';
259: execute immediate l_string ;
260: else
261: ecx_eng_utils.g_server_tz:= wf_core.translate('ECX_SERVER_TIMEZONE');
262: end if;
263: end if;
264:
265: if (ecx_eng_utils.g_server_tz is null)

Line 265: if (ecx_eng_utils.g_server_tz is null)

261: ecx_eng_utils.g_server_tz:= wf_core.translate('ECX_SERVER_TIMEZONE');
262: end if;
263: end if;
264:
265: if (ecx_eng_utils.g_server_tz is null)
266: then
267: ecx_eng_utils.g_server_tz := 'GMT';
268: end if;
269:

Line 267: ecx_eng_utils.g_server_tz := 'GMT';

263: end if;
264:
265: if (ecx_eng_utils.g_server_tz is null)
266: then
267: ecx_eng_utils.g_server_tz := 'GMT';
268: end if;
269:
270: l_format_date := getDate(p_cxml_date, ecx_eng_utils.g_server_tz);
271:

Line 270: l_format_date := getDate(p_cxml_date, ecx_eng_utils.g_server_tz);

266: then
267: ecx_eng_utils.g_server_tz := 'GMT';
268: end if;
269:
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);

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 318: i_method_name varchar2(2000) := 'ecx_eng_utils.get_tp_pwd';

314: x_password OUT NOCOPY Varchar2
315: )
316: is
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;

Line 334: x_password := ecx_eng_utils.PWD_SPEC_CODE || x_password ||

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 ||
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);

Line 335: ecx_eng_utils.PWD_SPEC_CODE;

331:
332: if (x_password is not null)
333: then
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;

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 378: i_method_name varchar2(2000) := 'ecx_eng_utils.convertEncryCodeClob';

374: p_clob IN CLOB,
375: x_clob OUT NOCOPY CLOB
376: ) is
377:
378: i_method_name varchar2(2000) := 'ecx_eng_utils.convertEncryCodeClob';
379: l_in_clob_len number := 0;
380: l_start_code varchar2(50);
381: l_start_code_len pls_integer;
382: l_start_code_pos number := 0;

Line 409: l_start_code := ecx_eng_utils.PWD_SPEC_CODE;

405: if (l_in_clob_len = 0) then
406: return;
407: end if;
408:
409: l_start_code := ecx_eng_utils.PWD_SPEC_CODE;
410: l_start_code_len := length(l_start_code);
411: l_end_code := ecx_eng_utils.PWD_SPEC_CODE;
412: l_end_code_len := length(l_end_code);
413:

Line 411: l_end_code := ecx_eng_utils.PWD_SPEC_CODE;

407: end if;
408:
409: l_start_code := ecx_eng_utils.PWD_SPEC_CODE;
410: l_start_code_len := length(l_start_code);
411: l_end_code := ecx_eng_utils.PWD_SPEC_CODE;
412: l_end_code_len := length(l_end_code);
413:
414: if (x_clob is null) then
415: dbms_lob.createtemporary(x_clob, true, dbms_lob.session);

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

509: raise ecx_utils.program_exit;
510: end convertEncryCodeClob;
511:
512:
513: end ecx_eng_utils;