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_CODE_CONVERSION_PVT dependencies on ECX_DEBUG

Line 4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;

1: PACKAGE BODY ecx_code_conversion_pvt AS
2: -- $Header: ECXXREFB.pls 120.2.12020000.4 2013/03/21 13:03:23 jmaddila 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_code_conversion_pvt AS
2: -- $Header: ECXXREFB.pls 120.2.12020000.4 2013/03/21 13:03:23 jmaddila 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: ECXXREFB.pls 120.2.12020000.4 2013/03/21 13:03:23 jmaddila 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: PROCEDURE populate_plsql_tbl_with_extval

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: PROCEDURE populate_plsql_tbl_with_extval
12: (p_api_version_number IN NUMBER,

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: PROCEDURE populate_plsql_tbl_with_extval
12: (p_api_version_number IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := G_FALSE,

Line 46: ecx_debug.push(i_method_name);

42: l_standard_type Varchar2(200);
43:
44: BEGIN
45: if (l_procedureEnabled) then
46: ecx_debug.push(i_method_name);
47: end if;
48: if(l_statementEnabled) then
49: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);
50: ecx_debug.log(l_statement, 'p_init_msg_list: ',p_init_msg_list,i_method_name);

Line 49: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);

45: if (l_procedureEnabled) then
46: ecx_debug.push(i_method_name);
47: end if;
48: if(l_statementEnabled) then
49: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);
50: ecx_debug.log(l_statement, 'p_init_msg_list: ',p_init_msg_list,i_method_name);
51: ecx_debug.log(l_statement, 'p_simulate: ',p_simulate,i_method_name);
52: ecx_debug.log(l_statement, 'p_commit: ',p_commit,i_method_name);
53: ecx_debug.log(l_statement, 'p_validation_level: ',p_validation_level,i_method_name);

Line 50: ecx_debug.log(l_statement, 'p_init_msg_list: ',p_init_msg_list,i_method_name);

46: ecx_debug.push(i_method_name);
47: end if;
48: if(l_statementEnabled) then
49: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);
50: ecx_debug.log(l_statement, 'p_init_msg_list: ',p_init_msg_list,i_method_name);
51: ecx_debug.log(l_statement, 'p_simulate: ',p_simulate,i_method_name);
52: ecx_debug.log(l_statement, 'p_commit: ',p_commit,i_method_name);
53: ecx_debug.log(l_statement, 'p_validation_level: ',p_validation_level,i_method_name);
54: end if;

Line 51: ecx_debug.log(l_statement, 'p_simulate: ',p_simulate,i_method_name);

47: end if;
48: if(l_statementEnabled) then
49: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);
50: ecx_debug.log(l_statement, 'p_init_msg_list: ',p_init_msg_list,i_method_name);
51: ecx_debug.log(l_statement, 'p_simulate: ',p_simulate,i_method_name);
52: ecx_debug.log(l_statement, 'p_commit: ',p_commit,i_method_name);
53: ecx_debug.log(l_statement, 'p_validation_level: ',p_validation_level,i_method_name);
54: end if;
55:

Line 52: ecx_debug.log(l_statement, 'p_commit: ',p_commit,i_method_name);

48: if(l_statementEnabled) then
49: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);
50: ecx_debug.log(l_statement, 'p_init_msg_list: ',p_init_msg_list,i_method_name);
51: ecx_debug.log(l_statement, 'p_simulate: ',p_simulate,i_method_name);
52: ecx_debug.log(l_statement, 'p_commit: ',p_commit,i_method_name);
53: ecx_debug.log(l_statement, 'p_validation_level: ',p_validation_level,i_method_name);
54: end if;
55:
56: -- Standard Start of API savepoint

Line 53: ecx_debug.log(l_statement, 'p_validation_level: ',p_validation_level,i_method_name);

49: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);
50: ecx_debug.log(l_statement, 'p_init_msg_list: ',p_init_msg_list,i_method_name);
51: ecx_debug.log(l_statement, 'p_simulate: ',p_simulate,i_method_name);
52: ecx_debug.log(l_statement, 'p_commit: ',p_commit,i_method_name);
53: ecx_debug.log(l_statement, 'p_validation_level: ',p_validation_level,i_method_name);
54: end if;
55:
56: -- Standard Start of API savepoint
57: SAVEPOINT populate_plsql_tbl_ext_PVT;

Line 96: ecx_debug.log(l_statement, 'Interface Column Name', p_tbl(i).attribute_name,i_method_name);

92: i := ecx_utils.g_source_levels(p_level).file_start_pos;
93: LOOP
94: IF (ecx_utils.g_source(i).external_level = p_level) then
95: if(l_statementEnabled) then
96: ecx_debug.log(l_statement, 'Interface Column Name', p_tbl(i).attribute_name,i_method_name);
97: end if;
98:
99: if (p_tbl(i).is_clob is null) then
100: if(l_statementEnabled) then

Line 101: ecx_debug.log(l_statement,'Value before code conversion:', p_tbl(i).value,i_method_name);

97: end if;
98:
99: if (p_tbl(i).is_clob is null) then
100: if(l_statementEnabled) then
101: ecx_debug.log(l_statement,'Value before code conversion:', p_tbl(i).value,i_method_name);
102: end if;
103: l_var_value := p_tbl(i).value;
104:
105: IF p_tbl(i).xref_category_id IS NOT NULL THEN

Line 130: ecx_debug.log(l_statement,'Using Standard Conversion',i_method_name);

126: WHERE standard_id = p_standard_id
127: AND xref_category_id = p_tbl(i).xref_category_id
128: AND xref_int_value = p_tbl(i).value;
129: if(l_statementEnabled) then
130: ecx_debug.log(l_statement,'Using Standard Conversion',i_method_name);
131: end if;
132: p_tbl(i).value := nvl(l_ext_val,l_var_value);
133: p_tbl(i).xref_retcode := xref_success;
134: EXCEPTION

Line 154: ecx_debug.log(l_statement,'Using Universal Conversion',i_method_name);

150: WHERE standard_id = l_univ_std_id
151: AND xref_category_id = p_tbl(i).xref_category_id
152: AND xref_int_value = p_tbl(i).value;
153: if(l_statementEnabled) then
154: ecx_debug.log(l_statement,'Using Universal Conversion',i_method_name);
155: end if;
156: p_tbl(i).value := nvl(l_ext_val,l_var_value);
157: p_tbl(i).xref_retcode := xref_success;
158: EXCEPTION

Line 162: ecx_debug.log(l_unexpected,'Data is Corrupted, Cannot resolve a unique' ||

158: EXCEPTION
159: /* Start of changes for Bug #2242061 */
160: WHEN TOO_MANY_ROWS THEN
161: if(l_unexpectedEnabled) then
162: ecx_debug.log(l_unexpected,'Data is Corrupted, Cannot resolve a unique' ||
163: ' universal code conversion value for '||
164: p_tbl(i).attribute_name, l_var_value,i_method_name);
165: end if;
166: p_tbl(i).value := l_var_value;

Line 178: ecx_debug.log(l_unexpected, 'Data is Corrupted, Cannot resolve a unique' ||

174: END;
175: /* Start of changes for Bug #2242061 */
176: WHEN TOO_MANY_ROWS THEN
177: if(l_unexpectedEnabled) then
178: ecx_debug.log(l_unexpected, 'Data is Corrupted, Cannot resolve a unique' ||
179: ' standard code conversion value for '||
180: p_tbl(i).attribute_name, l_var_value,i_method_name);
181: end if;
182: p_tbl(i).value := l_var_value;

Line 192: ecx_debug.log(l_unexpected, 'Data is corrupted, Cannot resolve a unique custom code' ||

188: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;
189: end;
190: WHEN TOO_MANY_ROWS THEN
191: if(l_unexpectedEnabled) then
192: ecx_debug.log(l_unexpected, 'Data is corrupted, Cannot resolve a unique custom code' ||
193: ' conversion value for' || p_tbl(i).attribute_name,l_var_value,i_method_name);
194: end if;
195: p_tbl(i).value := l_var_value;
196: p_tbl(i).xref_retcode := xref_warning;

Line 207: ecx_debug.log(l_statement, 'Value after code conversion:', p_tbl(i).value,i_method_name);

203: /* End of changes for Bug #2242061 */
204: END;
205: END IF;
206: if(l_statementEnabled) then
207: ecx_debug.log(l_statement, 'Value after code conversion:', p_tbl(i).value,i_method_name);
208: ecx_debug.log(l_statement, 'Code conversion return code:', p_tbl(i).xref_retcode,i_method_name);
209: end if;
210: END IF;
211: END IF;

Line 208: ecx_debug.log(l_statement, 'Code conversion return code:', p_tbl(i).xref_retcode,i_method_name);

204: END;
205: END IF;
206: if(l_statementEnabled) then
207: ecx_debug.log(l_statement, 'Value after code conversion:', p_tbl(i).value,i_method_name);
208: ecx_debug.log(l_statement, 'Code conversion return code:', p_tbl(i).xref_retcode,i_method_name);
209: end if;
210: END IF;
211: END IF;
212: EXIT WHEN i= ecx_utils.g_source_levels(p_level).file_end_pos;

Line 217: ecx_debug.pop(i_method_name);

213: i := ecx_utils.g_source.next(i);
214: END LOOP;
215:
216: if (l_procedureEnabled) then
217: ecx_debug.pop(i_method_name);
218: end if;
219: EXCEPTION
220: WHEN g_exc_error THEN
221: ROLLBACK TO populate_plsql_tbl_ext_PVT;

Line 224: ecx_debug.pop(i_method_name);

220: WHEN g_exc_error THEN
221: ROLLBACK TO populate_plsql_tbl_ext_PVT;
222: p_return_status := g_ret_sts_error;
223: if (l_procedureEnabled) then
224: ecx_debug.pop(i_method_name);
225: end if;
226: WHEN g_exc_unexpected_error THEN
227: ROLLBACK TO populate_plsql_tbl_ext_PVT;
228: p_return_status := g_ret_sts_error;

Line 230: ecx_debug.pop(i_method_name);

226: WHEN g_exc_unexpected_error THEN
227: ROLLBACK TO populate_plsql_tbl_ext_PVT;
228: p_return_status := g_ret_sts_error;
229: if (l_procedureEnabled) then
230: ecx_debug.pop(i_method_name);
231: end if;
232: WHEN OTHERS THEN
233: ROLLBACK TO populate_plsql_tbl_ext_PVT;
234: if(l_unexpectedEnabled) then

Line 235: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_CODE',i_method_name, 'ERROR_CODE',SQLCODE);

231: end if;
232: WHEN OTHERS THEN
233: ROLLBACK TO populate_plsql_tbl_ext_PVT;
234: if(l_unexpectedEnabled) then
235: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_CODE',i_method_name, 'ERROR_CODE',SQLCODE);
236: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
237: end if;
238: p_return_status := g_ret_sts_error;
239: if (l_procedureEnabled) then

Line 236: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);

232: WHEN OTHERS THEN
233: ROLLBACK TO populate_plsql_tbl_ext_PVT;
234: if(l_unexpectedEnabled) then
235: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_CODE',i_method_name, 'ERROR_CODE',SQLCODE);
236: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
237: end if;
238: p_return_status := g_ret_sts_error;
239: if (l_procedureEnabled) then
240: ecx_debug.pop(i_method_name);

Line 240: ecx_debug.pop(i_method_name);

236: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
237: end if;
238: p_return_status := g_ret_sts_error;
239: if (l_procedureEnabled) then
240: ecx_debug.pop(i_method_name);
241: end if;
242: END populate_plsql_tbl_with_extval;
243:
244:

Line 276: ecx_debug.push(i_method_name);

272: xref_warning CONSTANT VARCHAR2(1) := 1;
273:
274: BEGIN
275: if (l_procedureEnabled) then
276: ecx_debug.push(i_method_name);
277: end if;
278: if(l_statementEnabled) then
279: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);
280: ecx_debug.log(l_statement, 'p_init_msg_list: ',p_init_msg_list,i_method_name);

Line 279: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);

275: if (l_procedureEnabled) then
276: ecx_debug.push(i_method_name);
277: end if;
278: if(l_statementEnabled) then
279: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);
280: ecx_debug.log(l_statement, 'p_init_msg_list: ',p_init_msg_list,i_method_name);
281: ecx_debug.log(l_statement, 'p_simulate: ',p_simulate,i_method_name);
282: ecx_debug.log(l_statement, 'p_commit: ',p_commit,i_method_name);
283: ecx_debug.log(l_statement, 'p_validation_level: ',p_validation_level,i_method_name);

Line 280: ecx_debug.log(l_statement, 'p_init_msg_list: ',p_init_msg_list,i_method_name);

276: ecx_debug.push(i_method_name);
277: end if;
278: if(l_statementEnabled) then
279: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);
280: ecx_debug.log(l_statement, 'p_init_msg_list: ',p_init_msg_list,i_method_name);
281: ecx_debug.log(l_statement, 'p_simulate: ',p_simulate,i_method_name);
282: ecx_debug.log(l_statement, 'p_commit: ',p_commit,i_method_name);
283: ecx_debug.log(l_statement, 'p_validation_level: ',p_validation_level,i_method_name);
284: end if;

Line 281: ecx_debug.log(l_statement, 'p_simulate: ',p_simulate,i_method_name);

277: end if;
278: if(l_statementEnabled) then
279: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);
280: ecx_debug.log(l_statement, 'p_init_msg_list: ',p_init_msg_list,i_method_name);
281: ecx_debug.log(l_statement, 'p_simulate: ',p_simulate,i_method_name);
282: ecx_debug.log(l_statement, 'p_commit: ',p_commit,i_method_name);
283: ecx_debug.log(l_statement, 'p_validation_level: ',p_validation_level,i_method_name);
284: end if;
285: -- Standard Start of API savepoint

Line 282: ecx_debug.log(l_statement, 'p_commit: ',p_commit,i_method_name);

278: if(l_statementEnabled) then
279: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);
280: ecx_debug.log(l_statement, 'p_init_msg_list: ',p_init_msg_list,i_method_name);
281: ecx_debug.log(l_statement, 'p_simulate: ',p_simulate,i_method_name);
282: ecx_debug.log(l_statement, 'p_commit: ',p_commit,i_method_name);
283: ecx_debug.log(l_statement, 'p_validation_level: ',p_validation_level,i_method_name);
284: end if;
285: -- Standard Start of API savepoint
286: SAVEPOINT populate_plsql_tbl_int_PVT;

Line 283: ecx_debug.log(l_statement, 'p_validation_level: ',p_validation_level,i_method_name);

279: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);
280: ecx_debug.log(l_statement, 'p_init_msg_list: ',p_init_msg_list,i_method_name);
281: ecx_debug.log(l_statement, 'p_simulate: ',p_simulate,i_method_name);
282: ecx_debug.log(l_statement, 'p_commit: ',p_commit,i_method_name);
283: ecx_debug.log(l_statement, 'p_validation_level: ',p_validation_level,i_method_name);
284: end if;
285: -- Standard Start of API savepoint
286: SAVEPOINT populate_plsql_tbl_int_PVT;
287:

Line 295: ecx_debug.log(l_statement,'Interface Column Name', p_apps_tbl(j).attribute_name,i_method_name);

291: j := ecx_utils.g_source_levels(p_level).file_start_pos;
292: LOOP
293: IF (ecx_utils.g_source(j).external_level = p_level) THEN
294: if(l_statementEnabled) then
295: ecx_debug.log(l_statement,'Interface Column Name', p_apps_tbl(j).attribute_name,i_method_name);
296: ecx_debug.log(l_statement, 'Value before code conversion:', p_apps_tbl(j).value,i_method_name);
297: end if;
298: l_var_value := p_apps_tbl(j).value;
299:

Line 296: ecx_debug.log(l_statement, 'Value before code conversion:', p_apps_tbl(j).value,i_method_name);

292: LOOP
293: IF (ecx_utils.g_source(j).external_level = p_level) THEN
294: if(l_statementEnabled) then
295: ecx_debug.log(l_statement,'Interface Column Name', p_apps_tbl(j).attribute_name,i_method_name);
296: ecx_debug.log(l_statement, 'Value before code conversion:', p_apps_tbl(j).value,i_method_name);
297: end if;
298: l_var_value := p_apps_tbl(j).value;
299:
300: IF l_var_value IS NULL THEN

Line 317: ecx_debug.log(l_unexpected, 'Using Standard Conversion',i_method_name);

313: p_apps_tbl(j).xref_retcode := xref_success;
314: EXCEPTION
315: WHEN NO_DATA_FOUND THEN
316: if(l_unexpectedEnabled) then
317: ecx_debug.log(l_unexpected, 'Using Standard Conversion',i_method_name);
318: end if;
319: null;
320: BEGIN
321: SELECT xref_std_value

Line 340: ecx_debug.log(l_unexpected, 'Value after code conversion:', p_apps_tbl(j).value,i_method_name);

336: END;
337: END IF;
338:
339: if(l_unexpectedEnabled) then
340: ecx_debug.log(l_unexpected, 'Value after code conversion:', p_apps_tbl(j).value,i_method_name);
341: ecx_debug.log(l_unexpected, 'Code conversion return code:', p_apps_tbl(j).xref_retcode,i_method_name);
342: end if;
343: END IF;
344:

Line 341: ecx_debug.log(l_unexpected, 'Code conversion return code:', p_apps_tbl(j).xref_retcode,i_method_name);

337: END IF;
338:
339: if(l_unexpectedEnabled) then
340: ecx_debug.log(l_unexpected, 'Value after code conversion:', p_apps_tbl(j).value,i_method_name);
341: ecx_debug.log(l_unexpected, 'Code conversion return code:', p_apps_tbl(j).xref_retcode,i_method_name);
342: end if;
343: END IF;
344:
345: EXIT WHEN j= ecx_utils.g_source_levels(p_level).file_end_pos;

Line 354: ecx_debug.pop(i_method_name);

350: -- Standard check of p_simulate and p_commit parameters
351: -- *******************************************************
352:
353: if (l_procedureEnabled) then
354: ecx_debug.pop(i_method_name);
355: end if;
356:
357: EXCEPTION
358: WHEN g_exc_error THEN

Line 362: ecx_debug.pop(i_method_name);

358: WHEN g_exc_error THEN
359: ROLLBACK TO populate_plsql_tbl_int_PVT;
360: p_return_status := g_ret_sts_error;
361: if (l_procedureEnabled) then
362: ecx_debug.pop(i_method_name);
363: end if;
364: WHEN G_EXC_UNEXPECTED_ERROR THEN
365: ROLLBACK TO populate_plsql_tbl_int_PVT;
366: p_return_status := g_ret_sts_error;

Line 368: ecx_debug.pop(i_method_name);

364: WHEN G_EXC_UNEXPECTED_ERROR THEN
365: ROLLBACK TO populate_plsql_tbl_int_PVT;
366: p_return_status := g_ret_sts_error;
367: if (l_procedureEnabled) then
368: ecx_debug.pop(i_method_name);
369: end if;
370: WHEN OTHERS THEN
371: if(l_unexpectedEnabled) then
372: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_CODE',i_method_name,'ERROR_CODE',SQLCODE);

Line 372: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_CODE',i_method_name,'ERROR_CODE',SQLCODE);

368: ecx_debug.pop(i_method_name);
369: end if;
370: WHEN OTHERS THEN
371: if(l_unexpectedEnabled) then
372: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_CODE',i_method_name,'ERROR_CODE',SQLCODE);
373: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
374: end if;
375: ROLLBACK TO populate_plsql_tbl_int_PVT;
376: p_return_status := g_ret_sts_error;

Line 373: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);

369: end if;
370: WHEN OTHERS THEN
371: if(l_unexpectedEnabled) then
372: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_CODE',i_method_name,'ERROR_CODE',SQLCODE);
373: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
374: end if;
375: ROLLBACK TO populate_plsql_tbl_int_PVT;
376: p_return_status := g_ret_sts_error;
377: if (l_procedureEnabled) then

Line 378: ecx_debug.pop(i_method_name);

374: end if;
375: ROLLBACK TO populate_plsql_tbl_int_PVT;
376: p_return_status := g_ret_sts_error;
377: if (l_procedureEnabled) then
378: ecx_debug.pop(i_method_name);
379: end if;
380: END populate_plsql_tbl_with_intval;
381:
382: PROCEDURE convert_external_value

Line 418: ecx_debug.push(i_method_name);

414: l_standard_type varchar2(200);
415:
416: BEGIN
417: if (l_procedureEnabled) then
418: ecx_debug.push(i_method_name);
419: end if;
420: if(l_statementEnabled) then
421: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);
422: ecx_debug.log(l_statement, 'p_value: ',p_value,i_method_name);

Line 421: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);

417: if (l_procedureEnabled) then
418: ecx_debug.push(i_method_name);
419: end if;
420: if(l_statementEnabled) then
421: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);
422: ecx_debug.log(l_statement, 'p_value: ',p_value,i_method_name);
423: ecx_debug.log(l_statement, 'p_category_id: ',p_category_id,i_method_name);
424: ecx_debug.log(l_statement, 'p_snd_tp_id: ',p_snd_tp_id,i_method_name);
425: ecx_debug.log(l_statement, 'p_rec_tp_id: ',p_rec_tp_id,i_method_name);

Line 422: ecx_debug.log(l_statement, 'p_value: ',p_value,i_method_name);

418: ecx_debug.push(i_method_name);
419: end if;
420: if(l_statementEnabled) then
421: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);
422: ecx_debug.log(l_statement, 'p_value: ',p_value,i_method_name);
423: ecx_debug.log(l_statement, 'p_category_id: ',p_category_id,i_method_name);
424: ecx_debug.log(l_statement, 'p_snd_tp_id: ',p_snd_tp_id,i_method_name);
425: ecx_debug.log(l_statement, 'p_rec_tp_id: ',p_rec_tp_id,i_method_name);
426: end if;

Line 423: ecx_debug.log(l_statement, 'p_category_id: ',p_category_id,i_method_name);

419: end if;
420: if(l_statementEnabled) then
421: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);
422: ecx_debug.log(l_statement, 'p_value: ',p_value,i_method_name);
423: ecx_debug.log(l_statement, 'p_category_id: ',p_category_id,i_method_name);
424: ecx_debug.log(l_statement, 'p_snd_tp_id: ',p_snd_tp_id,i_method_name);
425: ecx_debug.log(l_statement, 'p_rec_tp_id: ',p_rec_tp_id,i_method_name);
426: end if;
427:

Line 424: ecx_debug.log(l_statement, 'p_snd_tp_id: ',p_snd_tp_id,i_method_name);

420: if(l_statementEnabled) then
421: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);
422: ecx_debug.log(l_statement, 'p_value: ',p_value,i_method_name);
423: ecx_debug.log(l_statement, 'p_category_id: ',p_category_id,i_method_name);
424: ecx_debug.log(l_statement, 'p_snd_tp_id: ',p_snd_tp_id,i_method_name);
425: ecx_debug.log(l_statement, 'p_rec_tp_id: ',p_rec_tp_id,i_method_name);
426: end if;
427:
428: -- Standard Start of API savepoint

Line 425: ecx_debug.log(l_statement, 'p_rec_tp_id: ',p_rec_tp_id,i_method_name);

421: ecx_debug.log(l_statement, 'API version : ',p_api_version_number,i_method_name);
422: ecx_debug.log(l_statement, 'p_value: ',p_value,i_method_name);
423: ecx_debug.log(l_statement, 'p_category_id: ',p_category_id,i_method_name);
424: ecx_debug.log(l_statement, 'p_snd_tp_id: ',p_snd_tp_id,i_method_name);
425: ecx_debug.log(l_statement, 'p_rec_tp_id: ',p_rec_tp_id,i_method_name);
426: end if;
427:
428: -- Standard Start of API savepoint
429: SAVEPOINT populate_value_extpt_PVT;

Line 435: ecx_debug.log(l_statement,'Value before code conversion:', p_value,i_method_name);

431: -- Initialize API return status to success
432: p_return_status := g_ret_sts_success;
433:
434: if(l_statementEnabled) then
435: ecx_debug.log(l_statement,'Value before code conversion:', p_value,i_method_name);
436: end if;
437: l_var_value := p_value;
438:
439: begin

Line 517: --ecx_debug.pop('ecx_code_conversion_PVT.convert_external_value');

513: when others then
514: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;
515: p_value := l_var_value;
516: l_int_val := l_var_value;
517: --ecx_debug.pop('ecx_code_conversion_PVT.convert_external_value');
518: --return;
519: end;
520: end;
521:

Line 525: ecx_debug.log(l_statement,'Value after ext to int code conversion:', p_value,i_method_name);

521:
522: END;
523: p_value := l_int_val;
524: if(l_statementEnabled) then
525: ecx_debug.log(l_statement,'Value after ext to int code conversion:', p_value,i_method_name);
526: end if;
527:
528: IF (l_int_val IS NOT NULL AND p_rec_tp_id IS NOT NULL) THEN
529: BEGIN

Line 566: ecx_debug.pop(i_method_name);

562: exception
563: when others then
564: p_return_status := ecx_code_conversion_PVT.g_recv_xref_not_found;
565: if (l_procedureEnabled) then
566: ecx_debug.pop(i_method_name);
567: end if;
568: return;
569: end;
570: end;

Line 575: ecx_debug.log(l_unexpected, 'Value after int to ext code conversion:',

571:
572: END;
573: p_value := l_ext_val;
574: if(l_unexpectedEnabled) then
575: ecx_debug.log(l_unexpected, 'Value after int to ext code conversion:',
576: p_value,i_method_name);
577: end if;
578: END IF;
579: END IF;

Line 581: ecx_debug.log(l_statement, 'Value after code conversion:', p_value,i_method_name);

577: end if;
578: END IF;
579: END IF;
580: if(l_statementEnabled) then
581: ecx_debug.log(l_statement, 'Value after code conversion:', p_value,i_method_name);
582: end if;
583:
584:
585: -- *******************************************************

Line 590: ecx_debug.pop(i_method_name);

586: -- Standard check of p_simulate and p_commit parameters
587: -- *******************************************************
588:
589: if (l_procedureEnabled) then
590: ecx_debug.pop(i_method_name);
591: end if;
592: EXCEPTION
593: WHEN g_exc_error THEN
594: ROLLBACK TO populate_value_extpt_PVT;

Line 596: ecx_debug.pop(i_method_name);

592: EXCEPTION
593: WHEN g_exc_error THEN
594: ROLLBACK TO populate_value_extpt_PVT;
595: if (l_procedureEnabled) then
596: ecx_debug.pop(i_method_name);
597: end if;
598: p_return_status := g_ret_sts_error;
599: WHEN g_exc_unexpected_error THEN
600: ROLLBACK TO populate_value_extpt_PVT;

Line 602: ecx_debug.pop(i_method_name);

598: p_return_status := g_ret_sts_error;
599: WHEN g_exc_unexpected_error THEN
600: ROLLBACK TO populate_value_extpt_PVT;
601: if (l_procedureEnabled) then
602: ecx_debug.pop(i_method_name);
603: end if;
604: p_return_status := g_ret_sts_error;
605: WHEN OTHERS THEN
606: if(l_unexpectedEnabled) then

Line 607: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_CODE',i_method_name,'ERROR_CODE',SQLCODE);

603: end if;
604: p_return_status := g_ret_sts_error;
605: WHEN OTHERS THEN
606: if(l_unexpectedEnabled) then
607: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_CODE',i_method_name,'ERROR_CODE',SQLCODE);
608: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
609: end if;
610: ROLLBACK TO populate_value_extpt_PVT;
611: if (l_procedureEnabled) then

Line 608: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);

604: p_return_status := g_ret_sts_error;
605: WHEN OTHERS THEN
606: if(l_unexpectedEnabled) then
607: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_CODE',i_method_name,'ERROR_CODE',SQLCODE);
608: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
609: end if;
610: ROLLBACK TO populate_value_extpt_PVT;
611: if (l_procedureEnabled) then
612: ecx_debug.pop(i_method_name);

Line 612: ecx_debug.pop(i_method_name);

608: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
609: end if;
610: ROLLBACK TO populate_value_extpt_PVT;
611: if (l_procedureEnabled) then
612: ecx_debug.pop(i_method_name);
613: end if;
614: p_return_status := g_ret_sts_error;
615: END convert_external_value;
616: /*