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 2319: insert into WSH_EXCEPTION_DEFINITIONS_TL (

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

Line 2345: from WSH_EXCEPTION_DEFINITIONS_TL T

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

Line 2565: update WSH_EXCEPTION_DEFINITIONS_TL set

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

Line 2666: select exception_definition_id , last_updated_by from WSH_EXCEPTION_DEFINITIONS_TL

2662:
2663: ) is
2664: --Bug 7694048: Modified the cursor C1 to read 'last_updated_by' as well.
2665: cursor C1 (c_exception_name VARCHAR2) is
2666: select exception_definition_id , last_updated_by from WSH_EXCEPTION_DEFINITIONS_TL
2667: where EXCEPTION_NAME = c_exception_name
2668: and SOURCE_LANG = userenv('LANG');
2669:
2670:

Line 2892: update WSH_EXCEPTION_DEFINITIONS_TL

2888: WSH_DEBUG_SV.log(l_module_name,'P_OWNER',P_OWNER);
2889: END IF;
2890: --
2891: if p_exception_name is not NULL then
2892: update WSH_EXCEPTION_DEFINITIONS_TL
2893: set
2894: EXCEPTION_NAME = p_exception_name,
2895: DESCRIPTION = p_description,
2896: LAST_UPDATE_DATE = sysdate,

Line 2951: delete from WSH_EXCEPTION_DEFINITIONS_TL

2947: --
2948: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2949: END IF;
2950: --
2951: delete from WSH_EXCEPTION_DEFINITIONS_TL
2952: where EXCEPTION_DEFINITION_ID = p_exception_definition_id ;
2953:
2954: if (sql%notfound) then
2955: raise WSH_XC_DEF_NOT_FOUND;

Line 3019: delete from WSH_EXCEPTION_DEFINITIONS_TL T

3015: IF l_debug_on THEN
3016: WSH_DEBUG_SV.push(l_module_name);
3017: END IF;
3018: --
3019: delete from WSH_EXCEPTION_DEFINITIONS_TL T
3020: where not exists
3021: (select to_char(NULL)
3022: from WSH_EXCEPTION_DEFINITIONS_B B
3023: where B.EXCEPTION_DEFINITION_ID = T.EXCEPTION_DEFINITION_ID

Line 3026: update WSH_EXCEPTION_DEFINITIONS_TL T set (

3022: from WSH_EXCEPTION_DEFINITIONS_B B
3023: where B.EXCEPTION_DEFINITION_ID = T.EXCEPTION_DEFINITION_ID
3024: );
3025:
3026: update WSH_EXCEPTION_DEFINITIONS_TL T set (
3027: EXCEPTION_NAME,
3028: DESCRIPTION
3029: ) = (select
3030: B.EXCEPTION_NAME,

Line 3032: from WSH_EXCEPTION_DEFINITIONS_TL B

3028: DESCRIPTION
3029: ) = (select
3030: B.EXCEPTION_NAME,
3031: B.DESCRIPTION
3032: from WSH_EXCEPTION_DEFINITIONS_TL B
3033: where B.EXCEPTION_DEFINITION_ID = T.EXCEPTION_DEFINITION_ID
3034: and B.LANGUAGE = T.SOURCE_LANG)
3035: where (
3036: T.EXCEPTION_DEFINITION_ID,

Line 3041: from WSH_EXCEPTION_DEFINITIONS_TL SUBB, WSH_EXCEPTION_DEFINITIONS_TL SUBT

3037: T.LANGUAGE
3038: ) in (select
3039: SUBT.EXCEPTION_DEFINITION_ID,
3040: SUBT.LANGUAGE
3041: from WSH_EXCEPTION_DEFINITIONS_TL SUBB, WSH_EXCEPTION_DEFINITIONS_TL SUBT
3042: where SUBB.EXCEPTION_DEFINITION_ID = SUBT.EXCEPTION_DEFINITION_ID
3043: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
3044: and (SUBB.EXCEPTION_NAME <> SUBT.EXCEPTION_NAME
3045: or (SUBB.EXCEPTION_NAME is null and SUBT.EXCEPTION_NAME is not null)

Line 3052: insert into WSH_EXCEPTION_DEFINITIONS_TL (

3048: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
3049: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
3050: ));
3051:
3052: insert into WSH_EXCEPTION_DEFINITIONS_TL (
3053: EXCEPTION_DEFINITION_ID,
3054: EXCEPTION_NAME,
3055: DESCRIPTION,
3056: CREATION_DATE,

Line 3074: from WSH_EXCEPTION_DEFINITIONS_TL B, FND_LANGUAGES L

3070: B.LAST_UPDATED_BY,
3071: B.LAST_UPDATE_LOGIN,
3072: L.LANGUAGE_CODE,
3073: B.SOURCE_LANG
3074: from WSH_EXCEPTION_DEFINITIONS_TL B, FND_LANGUAGES L
3075: where L.INSTALLED_FLAG in ('I', 'B')
3076: and B.LANGUAGE = userenv('LANG')
3077: and not exists
3078: (select to_char(NULL)

Line 3079: from WSH_EXCEPTION_DEFINITIONS_TL T

3075: where L.INSTALLED_FLAG in ('I', 'B')
3076: and B.LANGUAGE = userenv('LANG')
3077: and not exists
3078: (select to_char(NULL)
3079: from WSH_EXCEPTION_DEFINITIONS_TL T
3080: where T.EXCEPTION_DEFINITION_ID = B.EXCEPTION_DEFINITION_ID
3081: and T.LANGUAGE = L.LANGUAGE_CODE);
3082: --
3083: -- Debug Statements

Line 4775: l_exception_name WSH_EXCEPTION_DEFINITIONS_TL.EXCEPTION_NAME%TYPE;

4771: p_delivery_id IN WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE,
4772: p_exceptions_to_close_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,
4773: x_return_status OUT NOCOPY VARCHAR2) IS
4774:
4775: l_exception_name WSH_EXCEPTION_DEFINITIONS_TL.EXCEPTION_NAME%TYPE;
4776: l_debug_on BOOLEAN;
4777: l_count NUMBER;
4778: l_msg_count NUMBER;
4779: l_msg_data VARCHAR2(32767);

Line 4904: l_exception_name WSH_EXCEPTION_DEFINITIONS_TL.EXCEPTION_NAME%TYPE;

4900: l_num_warn NUMBER;
4901: l_return_status VARCHAR2(1);
4902:
4903: l_new_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
4904: l_exception_name WSH_EXCEPTION_DEFINITIONS_TL.EXCEPTION_NAME%TYPE;
4905: l_exceptions_to_close_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4906: i NUMBER;
4907: --
4908: l_debug_on BOOLEAN;