DBA Data[Home] [Help]

APPS.WSH_DELIVERY_SPLITTER_PKG dependencies on WSH_EXCEPTIONS

Line 41: l_exception_id WSH_EXCEPTIONS.EXCEPTION_ID%TYPE;

37: p_exception_message IN VARCHAR2 DEFAULT NULL,
38: p_exception_name IN VARCHAR2,
39: x_return_status OUT NOCOPY VARCHAR2) IS
40:
41: l_exception_id WSH_EXCEPTIONS.EXCEPTION_ID%TYPE;
42: l_exception_message WSH_EXCEPTIONS.MESSAGE%TYPE;
43: l_num_error NUMBER;
44: l_num_warn NUMBER;
45: l_return_status VARCHAR2(1);

Line 42: l_exception_message WSH_EXCEPTIONS.MESSAGE%TYPE;

38: p_exception_name IN VARCHAR2,
39: x_return_status OUT NOCOPY VARCHAR2) IS
40:
41: l_exception_id WSH_EXCEPTIONS.EXCEPTION_ID%TYPE;
42: l_exception_message WSH_EXCEPTIONS.MESSAGE%TYPE;
43: l_num_error NUMBER;
44: l_num_warn NUMBER;
45: l_return_status VARCHAR2(1);
46: l_msg_count NUMBER;

Line 319: l_exception_name WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE;

315: i NUMBER;
316: j NUMBER;
317: k NUMBER;
318: z NUMBER;
319: l_exception_name WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE;
320:
321: l_debug_on BOOLEAN;
322: --
323: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || g_pkg_name ||