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_CODE_CONVERSION_PVT

Line 1: PACKAGE BODY ecx_code_conversion_pvt AS

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;

Line 25: i_method_name varchar2(2000) := 'ecx_code_conversion_pvt.populate_plsql_tbl_with_extval';

21: p_level IN PLS_INTEGER,
22: p_tbl IN OUT NOCOPY ecx_utils.dtd_node_tbl,
23: p_tp_id IN PLS_INTEGER) IS
24:
25: i_method_name varchar2(2000) := 'ecx_code_conversion_pvt.populate_plsql_tbl_with_extval';
26:
27: l_api_name CONSTANT VARCHAR2(30) := 'populate_plsql_tbl_with_extval';
28: l_api_version_number CONSTANT NUMBER := 1.0;
29:

Line 168: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;

164: p_tbl(i).attribute_name, l_var_value,i_method_name);
165: end if;
166: p_tbl(i).value := l_var_value;
167: p_tbl(i).xref_retcode := xref_warning;
168: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;
169: /* End of changes for Bug #2242061 */
170: WHEN OTHERS THEN
171: p_tbl(i).value := l_var_value;
172: p_tbl(i).xref_retcode := xref_warning;

Line 173: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;

169: /* End of changes for Bug #2242061 */
170: WHEN OTHERS THEN
171: p_tbl(i).value := l_var_value;
172: p_tbl(i).xref_retcode := xref_warning;
173: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;
174: END;
175: /* Start of changes for Bug #2242061 */
176: WHEN TOO_MANY_ROWS THEN
177: if(l_unexpectedEnabled) then

Line 184: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;

180: p_tbl(i).attribute_name, l_var_value,i_method_name);
181: end if;
182: p_tbl(i).value := l_var_value;
183: p_tbl(i).xref_retcode := xref_warning;
184: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;
185: WHEN OTHERS THEN
186: p_tbl(i).value := l_var_value;
187: p_tbl(i).xref_retcode := xref_warning;
188: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;

Line 188: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;

184: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;
185: WHEN OTHERS THEN
186: p_tbl(i).value := l_var_value;
187: p_tbl(i).xref_retcode := xref_warning;
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' ||

Line 197: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;

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;
197: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;
198: WHEN OTHERS THEN
199: p_tbl(i).value := l_var_value;
200: p_tbl(i).xref_retcode := xref_warning;
201: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;

Line 201: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;

197: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;
198: WHEN OTHERS THEN
199: p_tbl(i).value := l_var_value;
200: p_tbl(i).xref_retcode := xref_warning;
201: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;
202:
203: /* End of changes for Bug #2242061 */
204: END;
205: END IF;

Line 261: i_method_name varchar2(2000) := 'ecx_code_conversion_pvt.populate_plsql_tbl_with_intval';

257: p_apps_tbl IN OUT NOCOPY ecx_utils.dtd_node_tbl,
258: p_tp_id IN PLS_INTEGER
259: ) IS
260:
261: i_method_name varchar2(2000) := 'ecx_code_conversion_pvt.populate_plsql_tbl_with_intval';
262: l_api_name CONSTANT VARCHAR2(30) := 'populate_plsql_tbl_with_intval';
263: l_api_version_number CONSTANT NUMBER := 1.0;
264:
265: l_msg_count NUMBER;

Line 333: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;

329: p_apps_tbl(j).xref_retcode := xref_success;
330: EXCEPTION
331: WHEN OTHERS THEN
332: p_apps_tbl(j).value := l_var_value;
333: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;
334: p_apps_tbl(j).xref_retcode := xref_warning;
335: END;
336: END;
337: END IF;

Line 400: i_method_name varchar2(2000) := 'ecx_code_conversion_pvt.convert_external_value';

396: p_rec_tp_id IN PLS_INTEGER
397: ) IS
398:
399:
400: i_method_name varchar2(2000) := 'ecx_code_conversion_pvt.convert_external_value';
401:
402: l_api_name CONSTANT VARCHAR2(30) := 'convert_external_value';
403: l_api_version_number CONSTANT NUMBER := 1.0;
404:

Line 514: p_return_status := ecx_code_conversion_PVT.g_xref_not_found;

510: AND xref_std_value = rtrim(p_value);
511: p_return_status := 0;
512: exception
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;

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 564: p_return_status := ecx_code_conversion_PVT.g_recv_xref_not_found;

560: AND xref_int_value = p_value;
561: p_return_status := 0;
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;

Line 713: o_return_status := ecx_code_conversion_PVT.g_xref_not_found;

709: AND xref_std_value = rtrim(io_value);
710: o_return_status := 0;
711: EXCEPTION
712: WHEN OTHERS THEN
713: o_return_status := ecx_code_conversion_PVT.g_xref_not_found;
714: io_value := l_var_value;
715: l_int_val := l_var_value;
716: END;
717: END;

Line 757: o_return_status := ecx_code_conversion_PVT.g_recv_xref_not_found;

753: AND xref_int_value = io_value;
754: o_return_status := 0;
755: EXCEPTION
756: WHEN OTHERS THEN
757: o_return_status := ecx_code_conversion_PVT.g_recv_xref_not_found;
758: RETURN;
759: END;
760: END;
761: END;

Line 774: END ecx_code_conversion_PVT;

770: o_return_status := g_ret_sts_error;
771: WHEN OTHERS THEN
772: o_return_status := g_ret_sts_error;
773: END convert_external_value_java;
774: END ecx_code_conversion_PVT;