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.WSH_XC_UTIL dependencies on WSH_EXCEPTION_DEFINITIONS_TL

Line 2318: insert into WSH_EXCEPTION_DEFINITIONS_TL (

2314: p_last_update_login
2315: );
2316:
2317:
2318: insert into WSH_EXCEPTION_DEFINITIONS_TL (
2319: EXCEPTION_DEFINITION_ID,
2320: EXCEPTION_NAME,
2321: DESCRIPTION,
2322: CREATION_DATE,

Line 2344: from WSH_EXCEPTION_DEFINITIONS_TL T

2340: from FND_LANGUAGES L
2341: where L.INSTALLED_FLAG in ('I', 'B')
2342: and not exists
2343: (select NULL
2344: from WSH_EXCEPTION_DEFINITIONS_TL T
2345: where T.EXCEPTION_DEFINITION_ID = l_exception_definition_id
2346: and T.LANGUAGE = L.LANGUAGE_CODE);
2347:
2348:

Line 2564: update WSH_EXCEPTION_DEFINITIONS_TL set

2560: IF l_debug_on THEN
2561: WSH_DEBUG_SV.log(l_module_name,'After Base Table Update ... ', P_CALLER);
2562: END IF;
2563:
2564: update WSH_EXCEPTION_DEFINITIONS_TL set
2565: EXCEPTION_NAME = p_exception_name,
2566: DESCRIPTION = p_description,
2567: LAST_UPDATE_DATE = p_last_update_date,
2568: LAST_UPDATED_BY = p_last_updated_by,

Line 2661: select exception_definition_id from WSH_EXCEPTION_DEFINITIONS_TL

2657: p_last_update_login in NUMBER
2658:
2659: ) is
2660: cursor C1 (c_exception_name VARCHAR2) is
2661: select exception_definition_id from WSH_EXCEPTION_DEFINITIONS_TL
2662: where EXCEPTION_NAME = c_exception_name
2663: and SOURCE_LANG = userenv('LANG');
2664:
2665:

Line 2884: update WSH_EXCEPTION_DEFINITIONS_TL

2880: WSH_DEBUG_SV.log(l_module_name,'P_OWNER',P_OWNER);
2881: END IF;
2882: --
2883: if p_exception_name is not NULL then
2884: update WSH_EXCEPTION_DEFINITIONS_TL
2885: set
2886: EXCEPTION_NAME = p_exception_name,
2887: DESCRIPTION = p_description,
2888: LAST_UPDATE_DATE = sysdate,

Line 2943: delete from WSH_EXCEPTION_DEFINITIONS_TL

2939: --
2940: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2941: END IF;
2942: --
2943: delete from WSH_EXCEPTION_DEFINITIONS_TL
2944: where EXCEPTION_DEFINITION_ID = p_exception_definition_id ;
2945:
2946: if (sql%notfound) then
2947: raise WSH_XC_DEF_NOT_FOUND;

Line 3011: delete from WSH_EXCEPTION_DEFINITIONS_TL T

3007: IF l_debug_on THEN
3008: WSH_DEBUG_SV.push(l_module_name);
3009: END IF;
3010: --
3011: delete from WSH_EXCEPTION_DEFINITIONS_TL T
3012: where not exists
3013: (select to_char(NULL)
3014: from WSH_EXCEPTION_DEFINITIONS_B B
3015: where B.EXCEPTION_DEFINITION_ID = T.EXCEPTION_DEFINITION_ID

Line 3018: update WSH_EXCEPTION_DEFINITIONS_TL T set (

3014: from WSH_EXCEPTION_DEFINITIONS_B B
3015: where B.EXCEPTION_DEFINITION_ID = T.EXCEPTION_DEFINITION_ID
3016: );
3017:
3018: update WSH_EXCEPTION_DEFINITIONS_TL T set (
3019: EXCEPTION_NAME,
3020: DESCRIPTION
3021: ) = (select
3022: B.EXCEPTION_NAME,

Line 3024: from WSH_EXCEPTION_DEFINITIONS_TL B

3020: DESCRIPTION
3021: ) = (select
3022: B.EXCEPTION_NAME,
3023: B.DESCRIPTION
3024: from WSH_EXCEPTION_DEFINITIONS_TL B
3025: where B.EXCEPTION_DEFINITION_ID = T.EXCEPTION_DEFINITION_ID
3026: and B.LANGUAGE = T.SOURCE_LANG)
3027: where (
3028: T.EXCEPTION_DEFINITION_ID,

Line 3033: from WSH_EXCEPTION_DEFINITIONS_TL SUBB, WSH_EXCEPTION_DEFINITIONS_TL SUBT

3029: T.LANGUAGE
3030: ) in (select
3031: SUBT.EXCEPTION_DEFINITION_ID,
3032: SUBT.LANGUAGE
3033: from WSH_EXCEPTION_DEFINITIONS_TL SUBB, WSH_EXCEPTION_DEFINITIONS_TL SUBT
3034: where SUBB.EXCEPTION_DEFINITION_ID = SUBT.EXCEPTION_DEFINITION_ID
3035: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
3036: and (SUBB.EXCEPTION_NAME <> SUBT.EXCEPTION_NAME
3037: or (SUBB.EXCEPTION_NAME is null and SUBT.EXCEPTION_NAME is not null)

Line 3044: insert into WSH_EXCEPTION_DEFINITIONS_TL (

3040: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
3041: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
3042: ));
3043:
3044: insert into WSH_EXCEPTION_DEFINITIONS_TL (
3045: EXCEPTION_DEFINITION_ID,
3046: EXCEPTION_NAME,
3047: DESCRIPTION,
3048: CREATION_DATE,

Line 3066: from WSH_EXCEPTION_DEFINITIONS_TL B, FND_LANGUAGES L

3062: B.LAST_UPDATED_BY,
3063: B.LAST_UPDATE_LOGIN,
3064: L.LANGUAGE_CODE,
3065: B.SOURCE_LANG
3066: from WSH_EXCEPTION_DEFINITIONS_TL B, FND_LANGUAGES L
3067: where L.INSTALLED_FLAG in ('I', 'B')
3068: and B.LANGUAGE = userenv('LANG')
3069: and not exists
3070: (select to_char(NULL)

Line 3071: from WSH_EXCEPTION_DEFINITIONS_TL T

3067: where L.INSTALLED_FLAG in ('I', 'B')
3068: and B.LANGUAGE = userenv('LANG')
3069: and not exists
3070: (select to_char(NULL)
3071: from WSH_EXCEPTION_DEFINITIONS_TL T
3072: where T.EXCEPTION_DEFINITION_ID = B.EXCEPTION_DEFINITION_ID
3073: and T.LANGUAGE = L.LANGUAGE_CODE);
3074: --
3075: -- Debug Statements

Line 4767: l_exception_name WSH_EXCEPTION_DEFINITIONS_TL.EXCEPTION_NAME%TYPE;

4763: p_delivery_id IN WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE,
4764: p_exceptions_to_close_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,
4765: x_return_status OUT NOCOPY VARCHAR2) IS
4766:
4767: l_exception_name WSH_EXCEPTION_DEFINITIONS_TL.EXCEPTION_NAME%TYPE;
4768: l_debug_on BOOLEAN;
4769: l_count NUMBER;
4770: l_msg_count NUMBER;
4771: l_msg_data VARCHAR2(32767);

Line 4896: l_exception_name WSH_EXCEPTION_DEFINITIONS_TL.EXCEPTION_NAME%TYPE;

4892: l_num_warn NUMBER;
4893: l_return_status VARCHAR2(1);
4894:
4895: l_new_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
4896: l_exception_name WSH_EXCEPTION_DEFINITIONS_TL.EXCEPTION_NAME%TYPE;
4897: l_exceptions_to_close_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4898: i NUMBER;
4899: --
4900: l_debug_on BOOLEAN;