1: PACKAGE BODY ECX_UTIL_API AS
2: -- $Header: ECXUTLAB.pls 120.3 2006/06/07 07:54:06 susaha ship $
3:
4:
5: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
6: l_statement PLS_INTEGER := ecx_debug.g_statement;
7: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
8: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
9: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
2: -- $Header: ECXUTLAB.pls 120.3 2006/06/07 07:54:06 susaha ship $
3:
4:
5: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
6: l_statement PLS_INTEGER := ecx_debug.g_statement;
7: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
8: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
9: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
10: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
3:
4:
5: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
6: l_statement PLS_INTEGER := ecx_debug.g_statement;
7: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
8: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
9: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
10: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
11:
4:
5: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
6: l_statement PLS_INTEGER := ecx_debug.g_statement;
7: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
8: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
9: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
10: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
11:
12: function validate_direction
5: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
6: l_statement PLS_INTEGER := ecx_debug.g_statement;
7: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
8: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
9: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
10: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
11:
12: function validate_direction
13: (
6: l_statement PLS_INTEGER := ecx_debug.g_statement;
7: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
8: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
9: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
10: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
11:
12: function validate_direction
13: (
14: p_direction in varchar2
847: end If;
848:
849: exception
850: when others then
851: ecx_debug.setErrorInfo(1, 30, SQLERRM);
852: if(l_statementEnabled) then
853: ecx_debug.log(l_statement,'ECX', SQLERRM,i_method_name);
854: end if;
855: if NOT xmlDOM.isNull(l_ndoc) then
849: exception
850: when others then
851: ecx_debug.setErrorInfo(1, 30, SQLERRM);
852: if(l_statementEnabled) then
853: ecx_debug.log(l_statement,'ECX', SQLERRM,i_method_name);
854: end if;
855: if NOT xmlDOM.isNull(l_ndoc) then
856: xmlDOM.freeDocument(l_ndoc);
857: end if;