[Home] [Help]
68: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
69: --
70: IF l_debug_on IS NULL
71: THEN
72: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
73: END IF;
74: --
75: IF l_debug_on THEN
76: WSH_DEBUG_SV.push(l_module_name);
72: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
73: END IF;
74: --
75: IF l_debug_on THEN
76: WSH_DEBUG_SV.push(l_module_name);
77: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME', p_exception_name);
78: END IF;
79: --
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
73: END IF;
74: --
75: IF l_debug_on THEN
76: WSH_DEBUG_SV.push(l_module_name);
77: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME', p_exception_name);
78: END IF;
79: --
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
85:
86: x_exception_def_info := g_exception_defs(p_exception_name);
87:
88: IF l_debug_on THEN
89: WSH_DEBUG_SV.log(l_module_name,'CACHED:EXCEPTION_NAME ',p_exception_name);
90: WSH_DEBUG_SV.pop(l_module_name);
91: END IF;
92:
93: RETURN;
86: x_exception_def_info := g_exception_defs(p_exception_name);
87:
88: IF l_debug_on THEN
89: WSH_DEBUG_SV.log(l_module_name,'CACHED:EXCEPTION_NAME ',p_exception_name);
90: WSH_DEBUG_SV.pop(l_module_name);
91: END IF;
92:
93: RETURN;
94:
107: g_exception_defs(p_exception_name) := x_exception_def_info;
108:
109: -- Debug Statements
110: IF l_debug_on THEN
111: WSH_DEBUG_SV.log(l_module_name,'CACHING:EXCEPTION_NAME ',p_exception_name);
112: WSH_DEBUG_SV.log(l_module_name,'CACHING:EXCEPTION_HANDLING ',g_exception_defs(p_exception_name).exception_handling);
113: WSH_DEBUG_SV.log(l_module_name,'CACHING:INITIATE_WORKFLOW ',g_exception_defs(p_exception_name).initiate_workflow);
114: WSH_DEBUG_SV.log(l_module_name,'CACHING:DEFAULT_SEVERITY ',g_exception_defs(p_exception_name).default_severity);
115: WSH_DEBUG_SV.log(l_module_name,'CACHING:ENABLED ',g_exception_defs(p_exception_name).enabled);
108:
109: -- Debug Statements
110: IF l_debug_on THEN
111: WSH_DEBUG_SV.log(l_module_name,'CACHING:EXCEPTION_NAME ',p_exception_name);
112: WSH_DEBUG_SV.log(l_module_name,'CACHING:EXCEPTION_HANDLING ',g_exception_defs(p_exception_name).exception_handling);
113: WSH_DEBUG_SV.log(l_module_name,'CACHING:INITIATE_WORKFLOW ',g_exception_defs(p_exception_name).initiate_workflow);
114: WSH_DEBUG_SV.log(l_module_name,'CACHING:DEFAULT_SEVERITY ',g_exception_defs(p_exception_name).default_severity);
115: WSH_DEBUG_SV.log(l_module_name,'CACHING:ENABLED ',g_exception_defs(p_exception_name).enabled);
116: WSH_DEBUG_SV.pop(l_module_name);
109: -- Debug Statements
110: IF l_debug_on THEN
111: WSH_DEBUG_SV.log(l_module_name,'CACHING:EXCEPTION_NAME ',p_exception_name);
112: WSH_DEBUG_SV.log(l_module_name,'CACHING:EXCEPTION_HANDLING ',g_exception_defs(p_exception_name).exception_handling);
113: WSH_DEBUG_SV.log(l_module_name,'CACHING:INITIATE_WORKFLOW ',g_exception_defs(p_exception_name).initiate_workflow);
114: WSH_DEBUG_SV.log(l_module_name,'CACHING:DEFAULT_SEVERITY ',g_exception_defs(p_exception_name).default_severity);
115: WSH_DEBUG_SV.log(l_module_name,'CACHING:ENABLED ',g_exception_defs(p_exception_name).enabled);
116: WSH_DEBUG_SV.pop(l_module_name);
117: END IF;
110: IF l_debug_on THEN
111: WSH_DEBUG_SV.log(l_module_name,'CACHING:EXCEPTION_NAME ',p_exception_name);
112: WSH_DEBUG_SV.log(l_module_name,'CACHING:EXCEPTION_HANDLING ',g_exception_defs(p_exception_name).exception_handling);
113: WSH_DEBUG_SV.log(l_module_name,'CACHING:INITIATE_WORKFLOW ',g_exception_defs(p_exception_name).initiate_workflow);
114: WSH_DEBUG_SV.log(l_module_name,'CACHING:DEFAULT_SEVERITY ',g_exception_defs(p_exception_name).default_severity);
115: WSH_DEBUG_SV.log(l_module_name,'CACHING:ENABLED ',g_exception_defs(p_exception_name).enabled);
116: WSH_DEBUG_SV.pop(l_module_name);
117: END IF;
118:
111: WSH_DEBUG_SV.log(l_module_name,'CACHING:EXCEPTION_NAME ',p_exception_name);
112: WSH_DEBUG_SV.log(l_module_name,'CACHING:EXCEPTION_HANDLING ',g_exception_defs(p_exception_name).exception_handling);
113: WSH_DEBUG_SV.log(l_module_name,'CACHING:INITIATE_WORKFLOW ',g_exception_defs(p_exception_name).initiate_workflow);
114: WSH_DEBUG_SV.log(l_module_name,'CACHING:DEFAULT_SEVERITY ',g_exception_defs(p_exception_name).default_severity);
115: WSH_DEBUG_SV.log(l_module_name,'CACHING:ENABLED ',g_exception_defs(p_exception_name).enabled);
116: WSH_DEBUG_SV.pop(l_module_name);
117: END IF;
118:
119: EXCEPTION
112: WSH_DEBUG_SV.log(l_module_name,'CACHING:EXCEPTION_HANDLING ',g_exception_defs(p_exception_name).exception_handling);
113: WSH_DEBUG_SV.log(l_module_name,'CACHING:INITIATE_WORKFLOW ',g_exception_defs(p_exception_name).initiate_workflow);
114: WSH_DEBUG_SV.log(l_module_name,'CACHING:DEFAULT_SEVERITY ',g_exception_defs(p_exception_name).default_severity);
115: WSH_DEBUG_SV.log(l_module_name,'CACHING:ENABLED ',g_exception_defs(p_exception_name).enabled);
116: WSH_DEBUG_SV.pop(l_module_name);
117: END IF;
118:
119: EXCEPTION
120: WHEN NO_DATA_FOUND THEN
123: CLOSE c_exc_def;
124: END IF;
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: IF l_debug_on THEN
127: WSH_DEBUG_SV.log(l_module_name,'ERROR: ','Exception Not Defined:'||p_exception_name);
128: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
129: END IF;
130: -- end of NO_DATA_FOUND exception handling
131: WHEN OTHERS THEN
124: END IF;
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: IF l_debug_on THEN
127: WSH_DEBUG_SV.log(l_module_name,'ERROR: ','Exception Not Defined:'||p_exception_name);
128: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
129: END IF;
130: -- end of NO_DATA_FOUND exception handling
131: WHEN OTHERS THEN
132: FND_MESSAGE.Set_Name('WSH','WSH_UNEXP_ERROR');
140: --
141: -- Debug Statements
142: --
143: IF l_debug_on THEN
144: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
145: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
146: END IF;
147: -- end of OTHERS exception handling
148: END Get_Exception_Def;
141: -- Debug Statements
142: --
143: IF l_debug_on THEN
144: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
145: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
146: END IF;
147: -- end of OTHERS exception handling
148: END Get_Exception_Def;
149:
369: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
370: --
371: IF l_debug_on IS NULL
372: THEN
373: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
374: END IF;
375: --
376: IF l_debug_on THEN
377: WSH_DEBUG_SV.push(l_module_name);
373: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
374: END IF;
375: --
376: IF l_debug_on THEN
377: WSH_DEBUG_SV.push(l_module_name);
378: --
379: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
380: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
381: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
375: --
376: IF l_debug_on THEN
377: WSH_DEBUG_SV.push(l_module_name);
378: --
379: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
380: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
381: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
382: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
383: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_ID',X_EXCEPTION_ID);
376: IF l_debug_on THEN
377: WSH_DEBUG_SV.push(l_module_name);
378: --
379: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
380: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
381: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
382: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
383: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_ID',X_EXCEPTION_ID);
384: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
377: WSH_DEBUG_SV.push(l_module_name);
378: --
379: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
380: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
381: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
382: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
383: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_ID',X_EXCEPTION_ID);
384: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
385: WSH_DEBUG_SV.log(l_module_name,'P_LOGGED_AT_LOCATION_ID',P_LOGGED_AT_LOCATION_ID);
378: --
379: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
380: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
381: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
382: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
383: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_ID',X_EXCEPTION_ID);
384: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
385: WSH_DEBUG_SV.log(l_module_name,'P_LOGGED_AT_LOCATION_ID',P_LOGGED_AT_LOCATION_ID);
386: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
379: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
380: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
381: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
382: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
383: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_ID',X_EXCEPTION_ID);
384: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
385: WSH_DEBUG_SV.log(l_module_name,'P_LOGGED_AT_LOCATION_ID',P_LOGGED_AT_LOCATION_ID);
386: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
387: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
380: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
381: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
382: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
383: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_ID',X_EXCEPTION_ID);
384: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
385: WSH_DEBUG_SV.log(l_module_name,'P_LOGGED_AT_LOCATION_ID',P_LOGGED_AT_LOCATION_ID);
386: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
387: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
388: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
381: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
382: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
383: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_ID',X_EXCEPTION_ID);
384: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
385: WSH_DEBUG_SV.log(l_module_name,'P_LOGGED_AT_LOCATION_ID',P_LOGGED_AT_LOCATION_ID);
386: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
387: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
388: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
389: WSH_DEBUG_SV.log(l_module_name,'P_MESSAGE',P_MESSAGE);
382: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
383: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_ID',X_EXCEPTION_ID);
384: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
385: WSH_DEBUG_SV.log(l_module_name,'P_LOGGED_AT_LOCATION_ID',P_LOGGED_AT_LOCATION_ID);
386: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
387: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
388: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
389: WSH_DEBUG_SV.log(l_module_name,'P_MESSAGE',P_MESSAGE);
390: WSH_DEBUG_SV.log(l_module_name,'P_MANUALLY_LOGGED',P_MANUALLY_LOGGED);
383: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_ID',X_EXCEPTION_ID);
384: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
385: WSH_DEBUG_SV.log(l_module_name,'P_LOGGED_AT_LOCATION_ID',P_LOGGED_AT_LOCATION_ID);
386: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
387: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
388: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
389: WSH_DEBUG_SV.log(l_module_name,'P_MESSAGE',P_MESSAGE);
390: WSH_DEBUG_SV.log(l_module_name,'P_MANUALLY_LOGGED',P_MANUALLY_LOGGED);
391: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
384: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
385: WSH_DEBUG_SV.log(l_module_name,'P_LOGGED_AT_LOCATION_ID',P_LOGGED_AT_LOCATION_ID);
386: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
387: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
388: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
389: WSH_DEBUG_SV.log(l_module_name,'P_MESSAGE',P_MESSAGE);
390: WSH_DEBUG_SV.log(l_module_name,'P_MANUALLY_LOGGED',P_MANUALLY_LOGGED);
391: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
392: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
385: WSH_DEBUG_SV.log(l_module_name,'P_LOGGED_AT_LOCATION_ID',P_LOGGED_AT_LOCATION_ID);
386: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
387: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
388: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
389: WSH_DEBUG_SV.log(l_module_name,'P_MESSAGE',P_MESSAGE);
390: WSH_DEBUG_SV.log(l_module_name,'P_MANUALLY_LOGGED',P_MANUALLY_LOGGED);
391: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
392: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
393: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
386: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
387: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
388: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
389: WSH_DEBUG_SV.log(l_module_name,'P_MESSAGE',P_MESSAGE);
390: WSH_DEBUG_SV.log(l_module_name,'P_MANUALLY_LOGGED',P_MANUALLY_LOGGED);
391: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
392: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
393: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
394: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
387: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
388: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
389: WSH_DEBUG_SV.log(l_module_name,'P_MESSAGE',P_MESSAGE);
390: WSH_DEBUG_SV.log(l_module_name,'P_MANUALLY_LOGGED',P_MANUALLY_LOGGED);
391: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
392: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
393: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
394: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
395: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
388: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
389: WSH_DEBUG_SV.log(l_module_name,'P_MESSAGE',P_MESSAGE);
390: WSH_DEBUG_SV.log(l_module_name,'P_MANUALLY_LOGGED',P_MANUALLY_LOGGED);
391: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
392: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
393: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
394: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
395: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
396: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
389: WSH_DEBUG_SV.log(l_module_name,'P_MESSAGE',P_MESSAGE);
390: WSH_DEBUG_SV.log(l_module_name,'P_MANUALLY_LOGGED',P_MANUALLY_LOGGED);
391: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
392: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
393: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
394: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
395: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
396: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
397: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ASSIGNMENT_ID',P_DELIVERY_ASSIGNMENT_ID);
390: WSH_DEBUG_SV.log(l_module_name,'P_MANUALLY_LOGGED',P_MANUALLY_LOGGED);
391: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
392: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
393: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
394: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
395: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
396: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
397: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ASSIGNMENT_ID',P_DELIVERY_ASSIGNMENT_ID);
398: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
391: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
392: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
393: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
394: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
395: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
396: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
397: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ASSIGNMENT_ID',P_DELIVERY_ASSIGNMENT_ID);
398: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
399: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
392: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
393: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
394: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
395: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
396: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
397: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ASSIGNMENT_ID',P_DELIVERY_ASSIGNMENT_ID);
398: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
399: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
400: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
393: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
394: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
395: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
396: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
397: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ASSIGNMENT_ID',P_DELIVERY_ASSIGNMENT_ID);
398: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
399: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
400: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
401: -- HW OPMCONV - No need for sublot_number
394: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
395: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
396: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
397: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ASSIGNMENT_ID',P_DELIVERY_ASSIGNMENT_ID);
398: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
399: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
400: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
401: -- HW OPMCONV - No need for sublot_number
402: -- WSH_DEBUG_SV.log(l_module_name,'P_SUBLOT_NUMBER',P_SUBLOT_NUMBER);
395: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
396: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
397: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ASSIGNMENT_ID',P_DELIVERY_ASSIGNMENT_ID);
398: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
399: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
400: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
401: -- HW OPMCONV - No need for sublot_number
402: -- WSH_DEBUG_SV.log(l_module_name,'P_SUBLOT_NUMBER',P_SUBLOT_NUMBER);
403: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
396: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
397: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ASSIGNMENT_ID',P_DELIVERY_ASSIGNMENT_ID);
398: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
399: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
400: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
401: -- HW OPMCONV - No need for sublot_number
402: -- WSH_DEBUG_SV.log(l_module_name,'P_SUBLOT_NUMBER',P_SUBLOT_NUMBER);
403: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
404: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
398: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_NAME',P_CONTAINER_NAME);
399: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
400: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
401: -- HW OPMCONV - No need for sublot_number
402: -- WSH_DEBUG_SV.log(l_module_name,'P_SUBLOT_NUMBER',P_SUBLOT_NUMBER);
403: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
404: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
405: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE',P_UNIT_OF_MEASURE);
406: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY',P_QUANTITY);
399: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
400: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
401: -- HW OPMCONV - No need for sublot_number
402: -- WSH_DEBUG_SV.log(l_module_name,'P_SUBLOT_NUMBER',P_SUBLOT_NUMBER);
403: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
404: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
405: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE',P_UNIT_OF_MEASURE);
406: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY',P_QUANTITY);
407: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE2',P_UNIT_OF_MEASURE2);
400: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
401: -- HW OPMCONV - No need for sublot_number
402: -- WSH_DEBUG_SV.log(l_module_name,'P_SUBLOT_NUMBER',P_SUBLOT_NUMBER);
403: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
404: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
405: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE',P_UNIT_OF_MEASURE);
406: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY',P_QUANTITY);
407: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE2',P_UNIT_OF_MEASURE2);
408: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY2',P_QUANTITY2);
401: -- HW OPMCONV - No need for sublot_number
402: -- WSH_DEBUG_SV.log(l_module_name,'P_SUBLOT_NUMBER',P_SUBLOT_NUMBER);
403: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
404: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
405: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE',P_UNIT_OF_MEASURE);
406: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY',P_QUANTITY);
407: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE2',P_UNIT_OF_MEASURE2);
408: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY2',P_QUANTITY2);
409: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
402: -- WSH_DEBUG_SV.log(l_module_name,'P_SUBLOT_NUMBER',P_SUBLOT_NUMBER);
403: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
404: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
405: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE',P_UNIT_OF_MEASURE);
406: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY',P_QUANTITY);
407: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE2',P_UNIT_OF_MEASURE2);
408: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY2',P_QUANTITY2);
409: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
410: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
403: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
404: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
405: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE',P_UNIT_OF_MEASURE);
406: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY',P_QUANTITY);
407: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE2',P_UNIT_OF_MEASURE2);
408: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY2',P_QUANTITY2);
409: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
410: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
411: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE',P_ARRIVAL_DATE);
404: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
405: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE',P_UNIT_OF_MEASURE);
406: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY',P_QUANTITY);
407: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE2',P_UNIT_OF_MEASURE2);
408: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY2',P_QUANTITY2);
409: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
410: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
411: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE',P_ARRIVAL_DATE);
412: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE',P_DEPARTURE_DATE);
405: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE',P_UNIT_OF_MEASURE);
406: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY',P_QUANTITY);
407: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE2',P_UNIT_OF_MEASURE2);
408: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY2',P_QUANTITY2);
409: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
410: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
411: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE',P_ARRIVAL_DATE);
412: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE',P_DEPARTURE_DATE);
413: WSH_DEBUG_SV.log(l_module_name,'P_ERROR_MESSAGE',P_ERROR_MESSAGE);
406: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY',P_QUANTITY);
407: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE2',P_UNIT_OF_MEASURE2);
408: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY2',P_QUANTITY2);
409: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
410: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
411: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE',P_ARRIVAL_DATE);
412: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE',P_DEPARTURE_DATE);
413: WSH_DEBUG_SV.log(l_module_name,'P_ERROR_MESSAGE',P_ERROR_MESSAGE);
414: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
407: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE2',P_UNIT_OF_MEASURE2);
408: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY2',P_QUANTITY2);
409: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
410: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
411: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE',P_ARRIVAL_DATE);
412: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE',P_DEPARTURE_DATE);
413: WSH_DEBUG_SV.log(l_module_name,'P_ERROR_MESSAGE',P_ERROR_MESSAGE);
414: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
415: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
408: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY2',P_QUANTITY2);
409: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
410: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
411: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE',P_ARRIVAL_DATE);
412: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE',P_DEPARTURE_DATE);
413: WSH_DEBUG_SV.log(l_module_name,'P_ERROR_MESSAGE',P_ERROR_MESSAGE);
414: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
415: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
416: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
409: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
410: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
411: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE',P_ARRIVAL_DATE);
412: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE',P_DEPARTURE_DATE);
413: WSH_DEBUG_SV.log(l_module_name,'P_ERROR_MESSAGE',P_ERROR_MESSAGE);
414: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
415: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
416: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
417: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
410: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
411: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE',P_ARRIVAL_DATE);
412: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE',P_DEPARTURE_DATE);
413: WSH_DEBUG_SV.log(l_module_name,'P_ERROR_MESSAGE',P_ERROR_MESSAGE);
414: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
415: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
416: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
417: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
418: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
411: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE',P_ARRIVAL_DATE);
412: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE',P_DEPARTURE_DATE);
413: WSH_DEBUG_SV.log(l_module_name,'P_ERROR_MESSAGE',P_ERROR_MESSAGE);
414: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
415: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
416: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
417: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
418: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
419: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
412: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE',P_DEPARTURE_DATE);
413: WSH_DEBUG_SV.log(l_module_name,'P_ERROR_MESSAGE',P_ERROR_MESSAGE);
414: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
415: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
416: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
417: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
418: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
419: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
420: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
413: WSH_DEBUG_SV.log(l_module_name,'P_ERROR_MESSAGE',P_ERROR_MESSAGE);
414: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
415: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
416: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
417: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
418: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
419: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
420: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
421: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
414: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
415: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
416: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
417: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
418: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
419: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
420: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
421: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
422: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
415: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
416: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
417: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
418: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
419: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
420: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
421: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
422: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
423: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
416: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
417: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
418: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
419: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
420: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
421: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
422: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
423: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
424: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
417: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
418: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
419: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
420: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
421: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
422: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
423: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
424: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
425: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
418: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
419: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
420: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
421: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
422: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
423: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
424: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
425: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
426: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
419: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
420: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
421: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
422: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
423: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
424: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
425: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
426: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
427: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
420: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
421: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
422: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
423: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
424: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
425: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
426: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
427: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
428: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
421: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
422: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
423: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
424: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
425: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
426: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
427: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
428: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
429: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
422: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
423: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
424: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
425: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
426: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
427: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
428: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
429: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
430: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
423: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
424: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
425: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
426: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
427: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
428: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
429: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
430: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
431: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
424: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
425: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
426: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
427: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
428: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
429: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
430: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
431: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
432: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
425: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
426: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
427: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
428: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
429: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
430: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
431: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
432: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
433: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
426: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
427: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
428: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
429: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
430: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
431: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
432: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
433: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
434: END IF;
427: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
428: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
429: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
430: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
431: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
432: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
433: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
434: END IF;
435: --
428: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
429: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
430: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
431: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
432: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
433: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
434: END IF;
435: --
436: SAVEPOINT Log_Exception_PUB;
429: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
430: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
431: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
432: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
433: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
434: END IF;
435: --
436: SAVEPOINT Log_Exception_PUB;
437: -- Standard call to check for call compatibility.
478: --
479: -- Debug Statements
480: --
481: IF l_debug_on THEN
482: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
483: END IF;
484: --
485: WSH_UTIL_VALIDATE.Validate_Location (
486: p_location_id => l_location_id,
496: --
497: -- Debug Statements
498: --
499: IF l_debug_on THEN
500: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
501: END IF;
502: --
503: WSH_UTIL_VALIDATE.Validate_Location (
504: p_location_id => l_location_id,
547: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
548: RAISE WSH_XC_DEF_NOT_FOUND;
549: ELSIF l_exc_def_info.enabled = 'N' THEN
550: IF l_debug_on THEN
551: WSH_DEBUG_SV.logmsg(l_module_name,'Not logging exception since the exception is not enabled',WSH_DEBUG_SV.C_PROC_LEVEL);
552: END IF;
553: GOTO end_proc;
554: END IF;
555:
574: l_exception_name_exists := FALSE; -- since exception_name was NULL
575: END IF; -- check if exception name is NULL
576:
577: IF l_debug_on THEN
578: WSH_DEBUG_SV.logmsg(l_module_name,'Logging exception with severity '||l_severity||' , status '||l_status ,WSH_DEBUG_SV.C_PROC_LEVEL);
579: END IF;
580:
581: -- populate l_exception_id
582: -- Bug 6615016 using the wsh_exceptions_s.nextval directly in the insert statement.
582: -- Bug 6615016 using the wsh_exceptions_s.nextval directly in the insert statement.
583: -- SELECT wsh_exceptions_s.nextval INTO l_exception_id FROM SYS.DUAL;
584:
585: IF l_debug_on THEN
586: wsh_debug_sv.logmsg(l_module_name, '**** Actual values ****');
587: -- Bug 6615016
588: --wsh_debug_Sv.log(l_module_name, 'Exception ID', l_exception_id);
589: wsh_debug_sv.log(l_module_name, 'Exception Loc ID', p_exception_location_id);
590: wsh_debug_sv.log(l_module_name, 'Logged at loc Id', p_logged_at_location_id);
584:
585: IF l_debug_on THEN
586: wsh_debug_sv.logmsg(l_module_name, '**** Actual values ****');
587: -- Bug 6615016
588: --wsh_debug_Sv.log(l_module_name, 'Exception ID', l_exception_id);
589: wsh_debug_sv.log(l_module_name, 'Exception Loc ID', p_exception_location_id);
590: wsh_debug_sv.log(l_module_name, 'Logged at loc Id', p_logged_at_location_id);
591: wsh_debug_Sv.log(l_module_name, 'Logging Entity', p_logging_entity);
592: wsh_debug_Sv.log(l_module_name, 'Logging Entity ID', p_logging_entity_id);
585: IF l_debug_on THEN
586: wsh_debug_sv.logmsg(l_module_name, '**** Actual values ****');
587: -- Bug 6615016
588: --wsh_debug_Sv.log(l_module_name, 'Exception ID', l_exception_id);
589: wsh_debug_sv.log(l_module_name, 'Exception Loc ID', p_exception_location_id);
590: wsh_debug_sv.log(l_module_name, 'Logged at loc Id', p_logged_at_location_id);
591: wsh_debug_Sv.log(l_module_name, 'Logging Entity', p_logging_entity);
592: wsh_debug_Sv.log(l_module_name, 'Logging Entity ID', p_logging_entity_id);
593: wsh_debug_sv.log(l_module_name, 'Exception Name', l_exception_name);
586: wsh_debug_sv.logmsg(l_module_name, '**** Actual values ****');
587: -- Bug 6615016
588: --wsh_debug_Sv.log(l_module_name, 'Exception ID', l_exception_id);
589: wsh_debug_sv.log(l_module_name, 'Exception Loc ID', p_exception_location_id);
590: wsh_debug_sv.log(l_module_name, 'Logged at loc Id', p_logged_at_location_id);
591: wsh_debug_Sv.log(l_module_name, 'Logging Entity', p_logging_entity);
592: wsh_debug_Sv.log(l_module_name, 'Logging Entity ID', p_logging_entity_id);
593: wsh_debug_sv.log(l_module_name, 'Exception Name', l_exception_name);
594: wsh_debug_sv.log(l_module_name, 'Message', p_message);
587: -- Bug 6615016
588: --wsh_debug_Sv.log(l_module_name, 'Exception ID', l_exception_id);
589: wsh_debug_sv.log(l_module_name, 'Exception Loc ID', p_exception_location_id);
590: wsh_debug_sv.log(l_module_name, 'Logged at loc Id', p_logged_at_location_id);
591: wsh_debug_Sv.log(l_module_name, 'Logging Entity', p_logging_entity);
592: wsh_debug_Sv.log(l_module_name, 'Logging Entity ID', p_logging_entity_id);
593: wsh_debug_sv.log(l_module_name, 'Exception Name', l_exception_name);
594: wsh_debug_sv.log(l_module_name, 'Message', p_message);
595: wsh_debug_sv.log(l_module_name, 'Severity', l_severity);
588: --wsh_debug_Sv.log(l_module_name, 'Exception ID', l_exception_id);
589: wsh_debug_sv.log(l_module_name, 'Exception Loc ID', p_exception_location_id);
590: wsh_debug_sv.log(l_module_name, 'Logged at loc Id', p_logged_at_location_id);
591: wsh_debug_Sv.log(l_module_name, 'Logging Entity', p_logging_entity);
592: wsh_debug_Sv.log(l_module_name, 'Logging Entity ID', p_logging_entity_id);
593: wsh_debug_sv.log(l_module_name, 'Exception Name', l_exception_name);
594: wsh_debug_sv.log(l_module_name, 'Message', p_message);
595: wsh_debug_sv.log(l_module_name, 'Severity', l_severity);
596: wsh_debug_Sv.log(l_module_name, 'Manually Logged?', l_manually_logged);
589: wsh_debug_sv.log(l_module_name, 'Exception Loc ID', p_exception_location_id);
590: wsh_debug_sv.log(l_module_name, 'Logged at loc Id', p_logged_at_location_id);
591: wsh_debug_Sv.log(l_module_name, 'Logging Entity', p_logging_entity);
592: wsh_debug_Sv.log(l_module_name, 'Logging Entity ID', p_logging_entity_id);
593: wsh_debug_sv.log(l_module_name, 'Exception Name', l_exception_name);
594: wsh_debug_sv.log(l_module_name, 'Message', p_message);
595: wsh_debug_sv.log(l_module_name, 'Severity', l_severity);
596: wsh_debug_Sv.log(l_module_name, 'Manually Logged?', l_manually_logged);
597: wsh_debug_sv.log(l_module_name, 'Status', l_status);
590: wsh_debug_sv.log(l_module_name, 'Logged at loc Id', p_logged_at_location_id);
591: wsh_debug_Sv.log(l_module_name, 'Logging Entity', p_logging_entity);
592: wsh_debug_Sv.log(l_module_name, 'Logging Entity ID', p_logging_entity_id);
593: wsh_debug_sv.log(l_module_name, 'Exception Name', l_exception_name);
594: wsh_debug_sv.log(l_module_name, 'Message', p_message);
595: wsh_debug_sv.log(l_module_name, 'Severity', l_severity);
596: wsh_debug_Sv.log(l_module_name, 'Manually Logged?', l_manually_logged);
597: wsh_debug_sv.log(l_module_name, 'Status', l_status);
598: wsh_debug_sv.log(l_module_name, 'Trip ID', p_trip_id);
591: wsh_debug_Sv.log(l_module_name, 'Logging Entity', p_logging_entity);
592: wsh_debug_Sv.log(l_module_name, 'Logging Entity ID', p_logging_entity_id);
593: wsh_debug_sv.log(l_module_name, 'Exception Name', l_exception_name);
594: wsh_debug_sv.log(l_module_name, 'Message', p_message);
595: wsh_debug_sv.log(l_module_name, 'Severity', l_severity);
596: wsh_debug_Sv.log(l_module_name, 'Manually Logged?', l_manually_logged);
597: wsh_debug_sv.log(l_module_name, 'Status', l_status);
598: wsh_debug_sv.log(l_module_name, 'Trip ID', p_trip_id);
599: wsh_debug_sv.log(l_module_name, 'Trip Name', p_trip_name);
592: wsh_debug_Sv.log(l_module_name, 'Logging Entity ID', p_logging_entity_id);
593: wsh_debug_sv.log(l_module_name, 'Exception Name', l_exception_name);
594: wsh_debug_sv.log(l_module_name, 'Message', p_message);
595: wsh_debug_sv.log(l_module_name, 'Severity', l_severity);
596: wsh_debug_Sv.log(l_module_name, 'Manually Logged?', l_manually_logged);
597: wsh_debug_sv.log(l_module_name, 'Status', l_status);
598: wsh_debug_sv.log(l_module_name, 'Trip ID', p_trip_id);
599: wsh_debug_sv.log(l_module_name, 'Trip Name', p_trip_name);
600: wsh_debug_sv.log(l_module_name, 'Trip Stop Id', p_trip_stop_id);
593: wsh_debug_sv.log(l_module_name, 'Exception Name', l_exception_name);
594: wsh_debug_sv.log(l_module_name, 'Message', p_message);
595: wsh_debug_sv.log(l_module_name, 'Severity', l_severity);
596: wsh_debug_Sv.log(l_module_name, 'Manually Logged?', l_manually_logged);
597: wsh_debug_sv.log(l_module_name, 'Status', l_status);
598: wsh_debug_sv.log(l_module_name, 'Trip ID', p_trip_id);
599: wsh_debug_sv.log(l_module_name, 'Trip Name', p_trip_name);
600: wsh_debug_sv.log(l_module_name, 'Trip Stop Id', p_trip_stop_id);
601: wsh_debug_sv.log(l_module_name, 'Delivery Id', p_delivery_id);
594: wsh_debug_sv.log(l_module_name, 'Message', p_message);
595: wsh_debug_sv.log(l_module_name, 'Severity', l_severity);
596: wsh_debug_Sv.log(l_module_name, 'Manually Logged?', l_manually_logged);
597: wsh_debug_sv.log(l_module_name, 'Status', l_status);
598: wsh_debug_sv.log(l_module_name, 'Trip ID', p_trip_id);
599: wsh_debug_sv.log(l_module_name, 'Trip Name', p_trip_name);
600: wsh_debug_sv.log(l_module_name, 'Trip Stop Id', p_trip_stop_id);
601: wsh_debug_sv.log(l_module_name, 'Delivery Id', p_delivery_id);
602: wsh_debug_sv.log(l_module_name, 'Delivery name', p_delivery_name);
595: wsh_debug_sv.log(l_module_name, 'Severity', l_severity);
596: wsh_debug_Sv.log(l_module_name, 'Manually Logged?', l_manually_logged);
597: wsh_debug_sv.log(l_module_name, 'Status', l_status);
598: wsh_debug_sv.log(l_module_name, 'Trip ID', p_trip_id);
599: wsh_debug_sv.log(l_module_name, 'Trip Name', p_trip_name);
600: wsh_debug_sv.log(l_module_name, 'Trip Stop Id', p_trip_stop_id);
601: wsh_debug_sv.log(l_module_name, 'Delivery Id', p_delivery_id);
602: wsh_debug_sv.log(l_module_name, 'Delivery name', p_delivery_name);
603: wsh_debug_sv.log(l_module_name, 'Delivery Detail ID', p_delivery_detail_id);
596: wsh_debug_Sv.log(l_module_name, 'Manually Logged?', l_manually_logged);
597: wsh_debug_sv.log(l_module_name, 'Status', l_status);
598: wsh_debug_sv.log(l_module_name, 'Trip ID', p_trip_id);
599: wsh_debug_sv.log(l_module_name, 'Trip Name', p_trip_name);
600: wsh_debug_sv.log(l_module_name, 'Trip Stop Id', p_trip_stop_id);
601: wsh_debug_sv.log(l_module_name, 'Delivery Id', p_delivery_id);
602: wsh_debug_sv.log(l_module_name, 'Delivery name', p_delivery_name);
603: wsh_debug_sv.log(l_module_name, 'Delivery Detail ID', p_delivery_detail_id);
604: wsh_debug_Sv.log(l_module_name, 'Assignment Id', p_delivery_assignment_id);
597: wsh_debug_sv.log(l_module_name, 'Status', l_status);
598: wsh_debug_sv.log(l_module_name, 'Trip ID', p_trip_id);
599: wsh_debug_sv.log(l_module_name, 'Trip Name', p_trip_name);
600: wsh_debug_sv.log(l_module_name, 'Trip Stop Id', p_trip_stop_id);
601: wsh_debug_sv.log(l_module_name, 'Delivery Id', p_delivery_id);
602: wsh_debug_sv.log(l_module_name, 'Delivery name', p_delivery_name);
603: wsh_debug_sv.log(l_module_name, 'Delivery Detail ID', p_delivery_detail_id);
604: wsh_debug_Sv.log(l_module_name, 'Assignment Id', p_delivery_assignment_id);
605: wsh_debug_sv.log(l_module_name, 'Request Id', l_request_id); -- Bugfix 3711661, previously p_request_id was passed.
598: wsh_debug_sv.log(l_module_name, 'Trip ID', p_trip_id);
599: wsh_debug_sv.log(l_module_name, 'Trip Name', p_trip_name);
600: wsh_debug_sv.log(l_module_name, 'Trip Stop Id', p_trip_stop_id);
601: wsh_debug_sv.log(l_module_name, 'Delivery Id', p_delivery_id);
602: wsh_debug_sv.log(l_module_name, 'Delivery name', p_delivery_name);
603: wsh_debug_sv.log(l_module_name, 'Delivery Detail ID', p_delivery_detail_id);
604: wsh_debug_Sv.log(l_module_name, 'Assignment Id', p_delivery_assignment_id);
605: wsh_debug_sv.log(l_module_name, 'Request Id', l_request_id); -- Bugfix 3711661, previously p_request_id was passed.
606: wsh_debug_sv.log(l_module_name, 'Batch Id', l_batch_id); -- Bugfix 3711661, previously p_batch_id was passed.
599: wsh_debug_sv.log(l_module_name, 'Trip Name', p_trip_name);
600: wsh_debug_sv.log(l_module_name, 'Trip Stop Id', p_trip_stop_id);
601: wsh_debug_sv.log(l_module_name, 'Delivery Id', p_delivery_id);
602: wsh_debug_sv.log(l_module_name, 'Delivery name', p_delivery_name);
603: wsh_debug_sv.log(l_module_name, 'Delivery Detail ID', p_delivery_detail_id);
604: wsh_debug_Sv.log(l_module_name, 'Assignment Id', p_delivery_assignment_id);
605: wsh_debug_sv.log(l_module_name, 'Request Id', l_request_id); -- Bugfix 3711661, previously p_request_id was passed.
606: wsh_debug_sv.log(l_module_name, 'Batch Id', l_batch_id); -- Bugfix 3711661, previously p_batch_id was passed.
607: END IF;
600: wsh_debug_sv.log(l_module_name, 'Trip Stop Id', p_trip_stop_id);
601: wsh_debug_sv.log(l_module_name, 'Delivery Id', p_delivery_id);
602: wsh_debug_sv.log(l_module_name, 'Delivery name', p_delivery_name);
603: wsh_debug_sv.log(l_module_name, 'Delivery Detail ID', p_delivery_detail_id);
604: wsh_debug_Sv.log(l_module_name, 'Assignment Id', p_delivery_assignment_id);
605: wsh_debug_sv.log(l_module_name, 'Request Id', l_request_id); -- Bugfix 3711661, previously p_request_id was passed.
606: wsh_debug_sv.log(l_module_name, 'Batch Id', l_batch_id); -- Bugfix 3711661, previously p_batch_id was passed.
607: END IF;
608: --
601: wsh_debug_sv.log(l_module_name, 'Delivery Id', p_delivery_id);
602: wsh_debug_sv.log(l_module_name, 'Delivery name', p_delivery_name);
603: wsh_debug_sv.log(l_module_name, 'Delivery Detail ID', p_delivery_detail_id);
604: wsh_debug_Sv.log(l_module_name, 'Assignment Id', p_delivery_assignment_id);
605: wsh_debug_sv.log(l_module_name, 'Request Id', l_request_id); -- Bugfix 3711661, previously p_request_id was passed.
606: wsh_debug_sv.log(l_module_name, 'Batch Id', l_batch_id); -- Bugfix 3711661, previously p_batch_id was passed.
607: END IF;
608: --
609: IF (p_container_name is not null) and (p_delivery_detail_id is null) then --LPN Synch Up..samanna
602: wsh_debug_sv.log(l_module_name, 'Delivery name', p_delivery_name);
603: wsh_debug_sv.log(l_module_name, 'Delivery Detail ID', p_delivery_detail_id);
604: wsh_debug_Sv.log(l_module_name, 'Assignment Id', p_delivery_assignment_id);
605: wsh_debug_sv.log(l_module_name, 'Request Id', l_request_id); -- Bugfix 3711661, previously p_request_id was passed.
606: wsh_debug_sv.log(l_module_name, 'Batch Id', l_batch_id); -- Bugfix 3711661, previously p_batch_id was passed.
607: END IF;
608: --
609: IF (p_container_name is not null) and (p_delivery_detail_id is null) then --LPN Synch Up..samanna
610: l_msg_name := 'WSH_MISSING_DETAILS';
807: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
808: RAISE WSH_XC_DEF_NOT_FOUND;
809: ELSIF l_exc_def_info.enabled = 'N' THEN
810: IF l_debug_on THEN
811: WSH_DEBUG_SV.logmsg(l_module_name,'Not logging exception since the exception is not enabled',WSH_DEBUG_SV.C_PROC_LEVEL);
812: END IF;
813: GOTO end_proc;
814: END IF;
815:
1251: END IF;
1252:
1253: IF l_debug_on THEN
1254:
1255: WSH_DEBUG_SV.log(l_module_name,'p_attribute15',p_attribute15);
1256: WSH_DEBUG_SV.log(l_module_name,'l_xcp_record.attribute15',l_xcp_record.attribute15);
1257: END IF;
1258: IF p_attribute15 IS NOT NULL THEN
1259:
1252:
1253: IF l_debug_on THEN
1254:
1255: WSH_DEBUG_SV.log(l_module_name,'p_attribute15',p_attribute15);
1256: WSH_DEBUG_SV.log(l_module_name,'l_xcp_record.attribute15',l_xcp_record.attribute15);
1257: END IF;
1258: IF p_attribute15 IS NOT NULL THEN
1259:
1260: IF l_xcp_record.attribute15 IS NULL THEN
1356: -- Raise Business Event , if exception is workflow enabled and Exception name is being passed first time
1357: IF p_exception_name IS NOT NULL AND NOT (l_exception_name_exists)
1358: AND nvl(l_exc_def_info.initiate_workflow,'N') = 'Y' THEN
1359: IF l_debug_on THEN
1360: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Business event for exception : '||l_exception_id,WSH_DEBUG_SV.C_PROC_LEVEL);
1361: END IF;
1362: l_event_key := x_exception_id;
1363: IF p_delivery_detail_id IS NOT NULL THEN
1364: l_p_entity_name := 'LINE';
1376: l_p_entity_name := NULL;
1377: l_p_entity_id := NULL;
1378: END IF;
1379: IF l_debug_on THEN
1380: WSH_DEBUG_SV.logmsg(l_module_name,'Entity Name : '||l_p_entity_name||' Entity Id : '||l_p_entity_id ,WSH_DEBUG_SV.C_PROC_LEVEL);
1381: END IF;
1382: WF_EVENT.AddParameterToList ( p_name => 'EXCEPTION_NAME',
1383: p_value => p_exception_name,
1384: p_parameterlist => l_msg_parameter_list);
1394: WF_EVENT.AddParameterToList ( p_name => 'EXCEPTION_BEHAVIOR',
1395: p_value => l_severity,
1396: p_parameterlist => l_msg_parameter_list);
1397: IF l_debug_on THEN
1398: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_EVENT.RAISE' ,WSH_DEBUG_SV.C_PROC_LEVEL);
1399: END IF;
1400: WF_EVENT.Raise ( p_event_name => l_event_name,
1401: p_event_key => 'EXCP'||l_event_key,
1402: p_parameters => l_msg_parameter_list );
1406:
1407: WSH_UTIL_CORE.get_messages('N', l_msg_summary, l_msg_details, x_msg_count);
1408: if x_msg_count > 1 then
1409: IF l_debug_on THEN
1410: wsh_debug_sv.logmsg(l_module_name, 'x_msg_count > 1');
1411: END IF;
1412: x_msg_data := SUBSTRB((l_msg_summary || l_msg_details),1, 2000);
1413: else
1414: IF l_debug_on THEN
1411: END IF;
1412: x_msg_data := SUBSTRB((l_msg_summary || l_msg_details),1, 2000);
1413: else
1414: IF l_debug_on THEN
1415: wsh_debug_sv.logmsg(l_module_name, 'x_msg_count < 1');
1416: END IF;
1417: x_msg_data := SUBSTRB(l_msg_summary, 1, 2000);
1418: end if;
1419:
1420: --
1421: -- Debug Statements
1422: --
1423: IF l_debug_on THEN
1424: WSH_DEBUG_SV.pop(l_module_name);
1425: END IF;
1426: --
1427: EXCEPTION
1428:
1450: --
1451: -- Debug Statements
1452: --
1453: IF l_debug_on THEN
1454: WSH_DEBUG_SV.logmsg(l_module_name, L_MSG_SUMMARY );
1455: END IF;
1456: --
1457: if x_msg_count > 1 then
1458: x_msg_data := l_msg_summary || l_msg_details;
1463: --
1464: -- Debug Statements
1465: --
1466: IF l_debug_on THEN
1467: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_OPERATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1468: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_OPERATION');
1469: END IF;
1470: --
1471: WHEN WSH_XC_INVALID_LOGGING_ENTITY THEN
1464: -- Debug Statements
1465: --
1466: IF l_debug_on THEN
1467: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_OPERATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1468: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_OPERATION');
1469: END IF;
1470: --
1471: WHEN WSH_XC_INVALID_LOGGING_ENTITY THEN
1472: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_INVALID_LOGGING_ENTITY');
1479: --
1480: -- Debug Statements
1481: --
1482: IF l_debug_on THEN
1483: WSH_DEBUG_SV.logmsg(l_module_name, L_MSG_SUMMARY );
1484: END IF;
1485: --
1486: if x_msg_count > 1 then
1487: x_msg_data := l_msg_summary || l_msg_details;
1492: --
1493: -- Debug Statements
1494: --
1495: IF l_debug_on THEN
1496: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_LOGGING_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1497: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_LOGGING_ENTITY');
1498: END IF;
1499: --
1500: WHEN WSH_XC_INVALID_SEVERITY THEN
1493: -- Debug Statements
1494: --
1495: IF l_debug_on THEN
1496: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_LOGGING_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1497: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_LOGGING_ENTITY');
1498: END IF;
1499: --
1500: WHEN WSH_XC_INVALID_SEVERITY THEN
1501: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_INVALID_SEVERITY');
1508: --
1509: -- Debug Statements
1510: --
1511: IF l_debug_on THEN
1512: WSH_DEBUG_SV.logmsg(l_module_name, L_MSG_SUMMARY );
1513: END IF;
1514: --
1515: if x_msg_count > 1 then
1516: x_msg_data := l_msg_summary || l_msg_details;
1522: --
1523: -- Debug Statements
1524: --
1525: IF l_debug_on THEN
1526: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_SEVERITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1527: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_SEVERITY');
1528: END IF;
1529: --
1530: WHEN WSH_XC_INVALID_LOCATION THEN
1523: -- Debug Statements
1524: --
1525: IF l_debug_on THEN
1526: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_SEVERITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1527: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_SEVERITY');
1528: END IF;
1529: --
1530: WHEN WSH_XC_INVALID_LOCATION THEN
1531: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_INVALID_LOCATION');
1538: --
1539: -- Debug Statements
1540: --
1541: IF l_debug_on THEN
1542: WSH_DEBUG_SV.logmsg(l_module_name, L_MSG_SUMMARY );
1543: END IF;
1544: --
1545: if x_msg_count > 1 then
1546: x_msg_data := l_msg_summary || l_msg_details;
1552: --
1553: -- Debug Statements
1554: --
1555: IF l_debug_on THEN
1556: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_LOCATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_LOCATION');
1558: END IF;
1559: --
1560: WHEN WSH_XC_NOT_FOUND THEN
1553: -- Debug Statements
1554: --
1555: IF l_debug_on THEN
1556: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_LOCATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1557: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_LOCATION');
1558: END IF;
1559: --
1560: WHEN WSH_XC_NOT_FOUND THEN
1561: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_NOT_FOUND');
1568: --
1569: -- Debug Statements
1570: --
1571: IF l_debug_on THEN
1572: WSH_DEBUG_SV.logmsg(l_module_name, L_MSG_SUMMARY );
1573: END IF;
1574: --
1575: if x_msg_count > 1 then
1576: x_msg_data := l_msg_summary || l_msg_details;
1582: --
1583: -- Debug Statements
1584: --
1585: IF l_debug_on THEN
1586: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1587: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_NOT_FOUND');
1588: END IF;
1589: --
1590: WHEN WSH_XC_DEF_NOT_FOUND THEN
1583: -- Debug Statements
1584: --
1585: IF l_debug_on THEN
1586: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1587: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_NOT_FOUND');
1588: END IF;
1589: --
1590: WHEN WSH_XC_DEF_NOT_FOUND THEN
1591:
1595: --
1596: -- Debug Statements
1597: --
1598: IF l_debug_on THEN
1599: WSH_DEBUG_SV.logmsg(l_module_name, L_MSG_SUMMARY );
1600: END IF;
1601: --
1602: if x_msg_count > 1 then
1603: x_msg_data := l_msg_summary || l_msg_details;
1608: --
1609: -- Debug Statements
1610: --
1611: IF l_debug_on THEN
1612: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1613: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_NOT_FOUND');
1614: END IF;
1615: --
1616: WHEN WSH_XC_DATA_ERROR THEN
1609: -- Debug Statements
1610: --
1611: IF l_debug_on THEN
1612: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1613: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_NOT_FOUND');
1614: END IF;
1615: --
1616: WHEN WSH_XC_DATA_ERROR THEN
1617: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_DATA_ERROR');
1624: --
1625: -- Debug Statements
1626: --
1627: IF l_debug_on THEN
1628: WSH_DEBUG_SV.logmsg(l_module_name, L_MSG_SUMMARY );
1629: END IF;
1630: --
1631: if x_msg_count > 1 then
1632: x_msg_data := l_msg_summary || l_msg_details;
1638: --
1639: -- Debug Statements
1640: --
1641: IF l_debug_on THEN
1642: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DATA_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1643: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DATA_ERROR');
1644: END IF;
1645: --
1646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1639: -- Debug Statements
1640: --
1641: IF l_debug_on THEN
1642: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DATA_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1643: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DATA_ERROR');
1644: END IF;
1645: --
1646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1647: ROLLBACK TO Log_Exception_PUB ;
1650: --
1651: -- Debug Statements
1652: --
1653: IF l_debug_on THEN
1654: WSH_DEBUG_SV.logmsg(l_module_name, L_MSG_SUMMARY );
1655: END IF;
1656: --
1657:
1658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1667: --
1668: -- Debug Statements
1669: --
1670: IF l_debug_on THEN
1671: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1672: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1673: END IF;
1674: --
1675: WHEN OTHERS THEN
1668: -- Debug Statements
1669: --
1670: IF l_debug_on THEN
1671: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1672: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1673: END IF;
1674: --
1675: WHEN OTHERS THEN
1676: ROLLBACK TO Log_Exception_PUB ;
1685: --
1686: -- Debug Statements
1687: --
1688: IF l_debug_on THEN
1689: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1690: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1691: END IF;
1692: --
1693: END log_exception;
1686: -- Debug Statements
1687: --
1688: IF l_debug_on THEN
1689: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1690: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1691: END IF;
1692: --
1693: END log_exception;
1694:
1795: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1796: --
1797: IF l_debug_on IS NULL
1798: THEN
1799: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1800: END IF;
1801: --
1802: IF l_debug_on THEN
1803: WSH_DEBUG_SV.push(l_module_name);
1799: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1800: END IF;
1801: --
1802: IF l_debug_on THEN
1803: WSH_DEBUG_SV.push(l_module_name);
1804: --
1805: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1806: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1807: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1801: --
1802: IF l_debug_on THEN
1803: WSH_DEBUG_SV.push(l_module_name);
1804: --
1805: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1806: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1807: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1808: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1809: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_ID',P_EXCEPTION_ID);
1802: IF l_debug_on THEN
1803: WSH_DEBUG_SV.push(l_module_name);
1804: --
1805: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1806: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1807: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1808: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1809: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_ID',P_EXCEPTION_ID);
1810: WSH_DEBUG_SV.log(l_module_name,'P_OLD_STATUS',P_OLD_STATUS);
1803: WSH_DEBUG_SV.push(l_module_name);
1804: --
1805: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1806: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1807: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1808: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1809: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_ID',P_EXCEPTION_ID);
1810: WSH_DEBUG_SV.log(l_module_name,'P_OLD_STATUS',P_OLD_STATUS);
1811: WSH_DEBUG_SV.log(l_module_name,'P_SET_DEFAULT_STATUS',P_SET_DEFAULT_STATUS);
1804: --
1805: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1806: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1807: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1808: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1809: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_ID',P_EXCEPTION_ID);
1810: WSH_DEBUG_SV.log(l_module_name,'P_OLD_STATUS',P_OLD_STATUS);
1811: WSH_DEBUG_SV.log(l_module_name,'P_SET_DEFAULT_STATUS',P_SET_DEFAULT_STATUS);
1812: WSH_DEBUG_SV.log(l_module_name,'X_NEW_STATUS',X_NEW_STATUS);
1805: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1806: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1807: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1808: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1809: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_ID',P_EXCEPTION_ID);
1810: WSH_DEBUG_SV.log(l_module_name,'P_OLD_STATUS',P_OLD_STATUS);
1811: WSH_DEBUG_SV.log(l_module_name,'P_SET_DEFAULT_STATUS',P_SET_DEFAULT_STATUS);
1812: WSH_DEBUG_SV.log(l_module_name,'X_NEW_STATUS',X_NEW_STATUS);
1813: END IF;
1806: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1807: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1808: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1809: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_ID',P_EXCEPTION_ID);
1810: WSH_DEBUG_SV.log(l_module_name,'P_OLD_STATUS',P_OLD_STATUS);
1811: WSH_DEBUG_SV.log(l_module_name,'P_SET_DEFAULT_STATUS',P_SET_DEFAULT_STATUS);
1812: WSH_DEBUG_SV.log(l_module_name,'X_NEW_STATUS',X_NEW_STATUS);
1813: END IF;
1814: --
1807: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1808: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1809: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_ID',P_EXCEPTION_ID);
1810: WSH_DEBUG_SV.log(l_module_name,'P_OLD_STATUS',P_OLD_STATUS);
1811: WSH_DEBUG_SV.log(l_module_name,'P_SET_DEFAULT_STATUS',P_SET_DEFAULT_STATUS);
1812: WSH_DEBUG_SV.log(l_module_name,'X_NEW_STATUS',X_NEW_STATUS);
1813: END IF;
1814: --
1815: SAVEPOINT Change_Status_PUB;
1808: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1809: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_ID',P_EXCEPTION_ID);
1810: WSH_DEBUG_SV.log(l_module_name,'P_OLD_STATUS',P_OLD_STATUS);
1811: WSH_DEBUG_SV.log(l_module_name,'P_SET_DEFAULT_STATUS',P_SET_DEFAULT_STATUS);
1812: WSH_DEBUG_SV.log(l_module_name,'X_NEW_STATUS',X_NEW_STATUS);
1813: END IF;
1814: --
1815: SAVEPOINT Change_Status_PUB;
1816: -- Standard call to check for call compatibility.
1846: OPEN C1(p_exception_id);
1847: FETCH C1 INTO l_exception_name, l_old_status;
1848: IF (C1%FOUND) THEN
1849: IF l_debug_on THEN
1850: WSH_DEBUG_SV.logmsg(l_module_name,'l_old_status:'||l_old_status||' l_p_old_status:'||l_p_old_status, WSH_DEBUG_SV.C_PROC_LEVEL);
1851: END IF;
1852: IF l_old_status <> UPPER(l_p_old_status) THEN
1853: CLOSE C1;
1854: RAISE WSH_XC_STATUS_MISMATCH;
1929: --
1930: -- Debug Statements
1931: --
1932: IF l_debug_on THEN
1933: WSH_DEBUG_SV.pop(l_module_name);
1934: END IF;
1935: --
1936: EXCEPTION
1937:
1949: --
1950: -- Debug Statements
1951: --
1952: IF l_debug_on THEN
1953: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_OTM_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1954: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_OTM_ERROR');
1955: END IF;
1956: -- OTM R12 end of glog project
1957:
1950: -- Debug Statements
1951: --
1952: IF l_debug_on THEN
1953: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_OTM_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1954: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_OTM_ERROR');
1955: END IF;
1956: -- OTM R12 end of glog project
1957:
1958: WHEN WSH_XC_INVALID_STATUS THEN
1970: --
1971: -- Debug Statements
1972: --
1973: IF l_debug_on THEN
1974: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_STATUS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1975: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_STATUS');
1976: END IF;
1977: --
1978: WHEN WSH_XC_INVALID_OPERATION THEN
1971: -- Debug Statements
1972: --
1973: IF l_debug_on THEN
1974: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_STATUS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1975: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_STATUS');
1976: END IF;
1977: --
1978: WHEN WSH_XC_INVALID_OPERATION THEN
1979: FND_MESSAGE.SET_NAME('WSH', l_msg_name);
1989: --
1990: -- Debug Statements
1991: --
1992: IF l_debug_on THEN
1993: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_OPERATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1994: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_OPERATION');
1995: END IF;
1996: --
1997: WHEN WSH_XC_STATUS_MISMATCH THEN
1990: -- Debug Statements
1991: --
1992: IF l_debug_on THEN
1993: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_OPERATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1994: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_OPERATION');
1995: END IF;
1996: --
1997: WHEN WSH_XC_STATUS_MISMATCH THEN
1998: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_STATUS_MISMATCH');
2009: --
2010: -- Debug Statements
2011: --
2012: IF l_debug_on THEN
2013: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_STATUS_MISMATCH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2014: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_STATUS_MISMATCH');
2015: END IF;
2016: --
2017: WHEN WSH_XC_NOT_FOUND THEN
2010: -- Debug Statements
2011: --
2012: IF l_debug_on THEN
2013: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_STATUS_MISMATCH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2014: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_STATUS_MISMATCH');
2015: END IF;
2016: --
2017: WHEN WSH_XC_NOT_FOUND THEN
2018: IF C1%ISOPEN THEN
2032: --
2033: -- Debug Statements
2034: --
2035: IF l_debug_on THEN
2036: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2037: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_NOT_FOUND');
2038: END IF;
2039: --
2040: WHEN WSH_XC_DATA_ERROR THEN
2033: -- Debug Statements
2034: --
2035: IF l_debug_on THEN
2036: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2037: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_NOT_FOUND');
2038: END IF;
2039: --
2040: WHEN WSH_XC_DATA_ERROR THEN
2041: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_DATA_ERROR');
2052: --
2053: -- Debug Statements
2054: --
2055: IF l_debug_on THEN
2056: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DATA_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2057: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DATA_ERROR');
2058: END IF;
2059: --
2060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2053: -- Debug Statements
2054: --
2055: IF l_debug_on THEN
2056: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DATA_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2057: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DATA_ERROR');
2058: END IF;
2059: --
2060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2061: ROLLBACK TO Change_Status_PUB ;
2071: --
2072: -- Debug Statements
2073: --
2074: IF l_debug_on THEN
2075: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2076: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2077: END IF;
2078: --
2079:
2072: -- Debug Statements
2073: --
2074: IF l_debug_on THEN
2075: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2076: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2077: END IF;
2078: --
2079:
2080: WHEN WSH_XC_EXCEPTION_CLOSED THEN
2090: end if;
2091:
2092:
2093: IF l_debug_on THEN
2094: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_EXCEPTION_CLOSED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2095: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_OPERATION');
2096: END IF;
2097:
2098:
2091:
2092:
2093: IF l_debug_on THEN
2094: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_EXCEPTION_CLOSED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2095: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_OPERATION');
2096: END IF;
2097:
2098:
2099: WHEN OTHERS THEN
2109: --
2110: -- Debug Statements
2111: --
2112: IF l_debug_on THEN
2113: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2114: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2115: END IF;
2116: --
2117: END change_status;
2110: -- Debug Statements
2111: --
2112: IF l_debug_on THEN
2113: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2114: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2115: END IF;
2116: --
2117: END change_status;
2118:
2194: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2195: --
2196: IF l_debug_on IS NULL
2197: THEN
2198: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2199: END IF;
2200: --
2201: IF l_debug_on THEN
2202: WSH_DEBUG_SV.push(l_module_name);
2198: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2199: END IF;
2200: --
2201: IF l_debug_on THEN
2202: WSH_DEBUG_SV.push(l_module_name);
2203: --
2204: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_DEFINITION_ID',X_EXCEPTION_DEFINITION_ID);
2205: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2206: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2200: --
2201: IF l_debug_on THEN
2202: WSH_DEBUG_SV.push(l_module_name);
2203: --
2204: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_DEFINITION_ID',X_EXCEPTION_DEFINITION_ID);
2205: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2206: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2207: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2208: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2201: IF l_debug_on THEN
2202: WSH_DEBUG_SV.push(l_module_name);
2203: --
2204: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_DEFINITION_ID',X_EXCEPTION_DEFINITION_ID);
2205: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2206: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2207: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2208: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2209: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2202: WSH_DEBUG_SV.push(l_module_name);
2203: --
2204: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_DEFINITION_ID',X_EXCEPTION_DEFINITION_ID);
2205: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2206: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2207: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2208: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2209: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2210: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2203: --
2204: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_DEFINITION_ID',X_EXCEPTION_DEFINITION_ID);
2205: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2206: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2207: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2208: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2209: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2210: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2211: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2204: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_DEFINITION_ID',X_EXCEPTION_DEFINITION_ID);
2205: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2206: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2207: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2208: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2209: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2210: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2211: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2212: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2205: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2206: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2207: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2208: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2209: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2210: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2211: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2212: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2213: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2206: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2207: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2208: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2209: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2210: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2211: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2212: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2213: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2214: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2207: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2208: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2209: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2210: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2211: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2212: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2213: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2214: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2215: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2208: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2209: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2210: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2211: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2212: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2213: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2214: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2215: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2216: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2209: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2210: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2211: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2212: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2213: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2214: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2215: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2216: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2217: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2210: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2211: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2212: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2213: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2214: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2215: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2216: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2217: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2218: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2211: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2212: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2213: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2214: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2215: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2216: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2217: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2218: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2219: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2212: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2213: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2214: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2215: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2216: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2217: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2218: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2219: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2220: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2213: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2214: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2215: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2216: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2217: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2218: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2219: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2220: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2221: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2214: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2215: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2216: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2217: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2218: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2219: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2220: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2221: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2222: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2215: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2216: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2217: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2218: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2219: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2220: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2221: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2222: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2223: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2216: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2217: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2218: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2219: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2220: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2221: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2222: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2223: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2224: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2217: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2218: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2219: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2220: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2221: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2222: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2223: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2224: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2225: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2218: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2219: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2220: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2221: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2222: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2223: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2224: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2225: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2226: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2219: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2220: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2221: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2222: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2223: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2224: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2225: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2226: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2227: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2220: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2221: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2222: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2223: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2224: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2225: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2226: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2227: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2228: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2221: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2222: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2223: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2224: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2225: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2226: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2227: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2228: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2229: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2222: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2223: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2224: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2225: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2226: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2227: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2228: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2229: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2230: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2223: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2224: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2225: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2226: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2227: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2228: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2229: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2230: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2231: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2224: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2225: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2226: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2227: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2228: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2229: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2230: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2231: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2232: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2225: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2226: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2227: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2228: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2229: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2230: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2231: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2232: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2233: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2226: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2227: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2228: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2229: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2230: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2231: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2232: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2233: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2234: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2227: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2228: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2229: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2230: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2231: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2232: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2233: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2234: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2235: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2228: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2229: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2230: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2231: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2232: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2233: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2234: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2235: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2236: END IF;
2229: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2230: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2231: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2232: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2233: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2234: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2235: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2236: END IF;
2237: --
2230: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2231: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2232: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2233: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2234: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2235: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2236: END IF;
2237: --
2238: open C1(p_exception_name);
2231: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2232: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2233: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2234: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2235: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2236: END IF;
2237: --
2238: open C1(p_exception_name);
2239: fetch C1 into l_exception_name;
2365: --
2366: -- Debug Statements
2367: --
2368: IF l_debug_on THEN
2369: WSH_DEBUG_SV.pop(l_module_name);
2370: END IF;
2371: --
2372: exception
2373:
2378: --
2379: -- Debug Statements
2380: --
2381: IF l_debug_on THEN
2382: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_DUP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2383: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_DUP');
2384: END IF;
2385: --
2386: WHEN WSH_XC_DEF_NOT_FOUND THEN
2379: -- Debug Statements
2380: --
2381: IF l_debug_on THEN
2382: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_DUP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2383: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_DUP');
2384: END IF;
2385: --
2386: WHEN WSH_XC_DEF_NOT_FOUND THEN
2387: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_NOT_FOUND');
2390: --
2391: -- Debug Statements
2392: --
2393: IF l_debug_on THEN
2394: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2395: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_NOT_FOUND');
2396: END IF;
2397: --
2398: end insert_xc_def_form;
2391: -- Debug Statements
2392: --
2393: IF l_debug_on THEN
2394: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2395: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_NOT_FOUND');
2396: END IF;
2397: --
2398: end insert_xc_def_form;
2399:
2468: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2469: --
2470: IF l_debug_on IS NULL
2471: THEN
2472: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2473: END IF;
2474: --
2475: -- 5986504
2476: open C2 (p_exception_definition_id);
2477: fetch C2 into l_update_allowed;
2478: close C2;
2479: --
2480: IF l_debug_on THEN
2481: WSH_DEBUG_SV.push(l_module_name);
2482: --
2483: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2484: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2485: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2479: --
2480: IF l_debug_on THEN
2481: WSH_DEBUG_SV.push(l_module_name);
2482: --
2483: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2484: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2485: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2486: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2487: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2480: IF l_debug_on THEN
2481: WSH_DEBUG_SV.push(l_module_name);
2482: --
2483: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2484: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2485: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2486: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2487: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2488: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2481: WSH_DEBUG_SV.push(l_module_name);
2482: --
2483: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2484: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2485: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2486: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2487: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2488: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2489: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2482: --
2483: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2484: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2485: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2486: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2487: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2488: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2489: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2490: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2483: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2484: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2485: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2486: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2487: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2488: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2489: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2490: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2491: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2484: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2485: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2486: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2487: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2488: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2489: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2490: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2491: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2492: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2485: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2486: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2487: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2488: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2489: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2490: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2491: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2492: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2493: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2486: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2487: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2488: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2489: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2490: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2491: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2492: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2493: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2494: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2487: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2488: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2489: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2490: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2491: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2492: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2493: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2494: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2495: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2488: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2489: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2490: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2491: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2492: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2493: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2494: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2495: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2496: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2489: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2490: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2491: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2492: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2493: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2494: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2495: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2496: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2497: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2490: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2491: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2492: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2493: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2494: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2495: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2496: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2497: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2498: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2491: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2492: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2493: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2494: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2495: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2496: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2497: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2498: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2499: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2492: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2493: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2494: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2495: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2496: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2497: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2498: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2499: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2500: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2493: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2494: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2495: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2496: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2497: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2498: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2499: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2500: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2501: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2494: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2495: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2496: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2497: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2498: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2499: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2500: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2501: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2502: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2495: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2496: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2497: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2498: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2499: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2500: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2501: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2502: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2503: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2496: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2497: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2498: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2499: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2500: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2501: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2502: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2503: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2504: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2497: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2498: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2499: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2500: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2501: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2502: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2503: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2504: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2505: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2498: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2499: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2500: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2501: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2502: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2503: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2504: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2505: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2506: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2499: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2500: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2501: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2502: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2503: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2504: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2505: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2506: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2507: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2500: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2501: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2502: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2503: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2504: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2505: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2506: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2507: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2508: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2501: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2502: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2503: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2504: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2505: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2506: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2507: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2508: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2509: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2502: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2503: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2504: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2505: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2506: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2507: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2508: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2509: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2510: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2503: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2504: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2505: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2506: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2507: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2508: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2509: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2510: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2511: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2504: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2505: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2506: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2507: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2508: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2509: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2510: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2511: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2512: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2505: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2506: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2507: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2508: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2509: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2510: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2511: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2512: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2513: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2506: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2507: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2508: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2509: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2510: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2511: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2512: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2513: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2514: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2507: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2508: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2509: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2510: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2511: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2512: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2513: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2514: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2515: WSH_DEBUG_SV.log(l_module_name,'L_UPDATE_ALLOWED -in Db ', L_UPDATE_ALLOWED); --5986504
2508: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2509: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2510: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2511: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2512: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2513: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2514: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2515: WSH_DEBUG_SV.log(l_module_name,'L_UPDATE_ALLOWED -in Db ', L_UPDATE_ALLOWED); --5986504
2516: WSH_DEBUG_SV.log(l_module_name,'L_CALLER -Loader / Form ', P_CALLER); --5986504
2509: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2510: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2511: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2512: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2513: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2514: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2515: WSH_DEBUG_SV.log(l_module_name,'L_UPDATE_ALLOWED -in Db ', L_UPDATE_ALLOWED); --5986504
2516: WSH_DEBUG_SV.log(l_module_name,'L_CALLER -Loader / Form ', P_CALLER); --5986504
2517: END IF;
2510: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2511: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2512: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2513: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2514: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2515: WSH_DEBUG_SV.log(l_module_name,'L_UPDATE_ALLOWED -in Db ', L_UPDATE_ALLOWED); --5986504
2516: WSH_DEBUG_SV.log(l_module_name,'L_CALLER -Loader / Form ', P_CALLER); --5986504
2517: END IF;
2518: -- 5986504{ If Caller is Loader then Either p_update_allowed should be N or a Flip (Y -> N or N-Y)
2511: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2512: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2513: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2514: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2515: WSH_DEBUG_SV.log(l_module_name,'L_UPDATE_ALLOWED -in Db ', L_UPDATE_ALLOWED); --5986504
2516: WSH_DEBUG_SV.log(l_module_name,'L_CALLER -Loader / Form ', P_CALLER); --5986504
2517: END IF;
2518: -- 5986504{ If Caller is Loader then Either p_update_allowed should be N or a Flip (Y -> N or N-Y)
2519: -- should have taken place to be Elligible for Update.
2512: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2513: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2514: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2515: WSH_DEBUG_SV.log(l_module_name,'L_UPDATE_ALLOWED -in Db ', L_UPDATE_ALLOWED); --5986504
2516: WSH_DEBUG_SV.log(l_module_name,'L_CALLER -Loader / Form ', P_CALLER); --5986504
2517: END IF;
2518: -- 5986504{ If Caller is Loader then Either p_update_allowed should be N or a Flip (Y -> N or N-Y)
2519: -- should have taken place to be Elligible for Update.
2520: -- If Caller is Form , then Updates are Elligible
2558: end if;
2559:
2560: -- 5986504
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,
2577: end if;
2578:
2579: -- 5986504
2580: IF l_debug_on THEN
2581: WSH_DEBUG_SV.log(l_module_name,'After TL Table Update ... ', P_CALLER);
2582: WSH_DEBUG_SV.logmsg(l_module_name,'After Updates '||P_EXCEPTION_DEFINITION_ID,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2583: WSH_DEBUG_SV.logmsg(l_module_name,'After Updates '||P_CALLER,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2584: END IF;
2585:
2578:
2579: -- 5986504
2580: IF l_debug_on THEN
2581: WSH_DEBUG_SV.log(l_module_name,'After TL Table Update ... ', P_CALLER);
2582: WSH_DEBUG_SV.logmsg(l_module_name,'After Updates '||P_EXCEPTION_DEFINITION_ID,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2583: WSH_DEBUG_SV.logmsg(l_module_name,'After Updates '||P_CALLER,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2584: END IF;
2585:
2586: end if; -- 5986504 }
2579: -- 5986504
2580: IF l_debug_on THEN
2581: WSH_DEBUG_SV.log(l_module_name,'After TL Table Update ... ', P_CALLER);
2582: WSH_DEBUG_SV.logmsg(l_module_name,'After Updates '||P_EXCEPTION_DEFINITION_ID,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2583: WSH_DEBUG_SV.logmsg(l_module_name,'After Updates '||P_CALLER,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2584: END IF;
2585:
2586: end if; -- 5986504 }
2587:
2588: --
2589: -- Debug Statements
2590: --
2591: IF l_debug_on THEN
2592: WSH_DEBUG_SV.pop(l_module_name);
2593: END IF;
2594: --
2595: exception
2596:
2596:
2597: WHEN WSH_XC_DEF_NOT_FOUND THEN
2598: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_DEF_NOT_FOUND');
2599: IF l_debug_on THEN
2600: WSH_DEBUG_SV.log(l_module_name,'- Failed in Update .. ', P_CALLER);
2601: END IF;
2602: APP_EXCEPTION.RAISE_EXCEPTION;
2603:
2604: --
2604: --
2605: -- Debug Statements
2606: --
2607: IF l_debug_on THEN
2608: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2609: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_NOT_FOUND');
2610: END IF;
2611: --
2612: end update_xc_def_form;
2605: -- Debug Statements
2606: --
2607: IF l_debug_on THEN
2608: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2609: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_NOT_FOUND');
2610: END IF;
2611: --
2612: end update_xc_def_form;
2613:
2689: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2690: --
2691: IF l_debug_on IS NULL
2692: THEN
2693: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2694: END IF;
2695: --
2696: IF l_debug_on THEN
2697: WSH_DEBUG_SV.push(l_module_name);
2693: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2694: END IF;
2695: --
2696: IF l_debug_on THEN
2697: WSH_DEBUG_SV.push(l_module_name);
2698: --
2699: WSH_DEBUG_SV.log(l_module_name,'P_LANGUAGE',P_LANGUAGE);
2700: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LANG',P_SOURCE_LANG);
2701: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2695: --
2696: IF l_debug_on THEN
2697: WSH_DEBUG_SV.push(l_module_name);
2698: --
2699: WSH_DEBUG_SV.log(l_module_name,'P_LANGUAGE',P_LANGUAGE);
2700: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LANG',P_SOURCE_LANG);
2701: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2702: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2703: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2696: IF l_debug_on THEN
2697: WSH_DEBUG_SV.push(l_module_name);
2698: --
2699: WSH_DEBUG_SV.log(l_module_name,'P_LANGUAGE',P_LANGUAGE);
2700: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LANG',P_SOURCE_LANG);
2701: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2702: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2703: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2704: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2697: WSH_DEBUG_SV.push(l_module_name);
2698: --
2699: WSH_DEBUG_SV.log(l_module_name,'P_LANGUAGE',P_LANGUAGE);
2700: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LANG',P_SOURCE_LANG);
2701: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2702: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2703: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2704: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2705: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2698: --
2699: WSH_DEBUG_SV.log(l_module_name,'P_LANGUAGE',P_LANGUAGE);
2700: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LANG',P_SOURCE_LANG);
2701: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2702: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2703: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2704: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2705: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2706: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2699: WSH_DEBUG_SV.log(l_module_name,'P_LANGUAGE',P_LANGUAGE);
2700: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LANG',P_SOURCE_LANG);
2701: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2702: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2703: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2704: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2705: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2706: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2707: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2700: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LANG',P_SOURCE_LANG);
2701: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2702: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2703: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2704: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2705: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2706: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2707: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2708: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2701: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2702: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2703: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2704: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2705: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2706: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2707: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2708: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2709: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2702: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2703: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2704: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2705: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2706: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2707: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2708: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2709: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2710: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2703: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2704: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2705: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2706: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2707: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2708: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2709: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2710: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2711: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2704: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2705: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2706: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2707: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2708: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2709: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2710: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2711: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2712: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2705: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2706: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2707: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2708: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2709: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2710: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2711: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2712: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2713: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2706: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2707: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2708: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2709: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2710: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2711: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2712: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2713: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2714: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2707: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2708: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2709: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2710: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2711: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2712: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2713: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2714: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2715: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2708: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2709: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2710: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2711: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2712: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2713: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2714: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2715: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2716: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2709: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2710: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2711: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2712: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2713: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2714: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2715: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2716: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2717: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2710: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2711: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2712: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2713: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2714: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2715: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2716: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2717: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2718: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2711: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2712: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2713: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2714: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2715: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2716: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2717: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2718: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2719: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2712: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2713: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2714: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2715: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2716: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2717: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2718: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2719: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2720: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2713: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2714: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2715: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2716: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2717: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2718: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2719: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2720: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2721: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2714: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2715: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2716: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2717: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2718: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2719: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2720: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2721: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2722: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2715: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2716: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2717: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2718: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2719: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2720: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2721: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2722: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2723: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2716: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2717: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2718: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2719: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2720: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2721: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2722: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2723: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2724: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2717: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2718: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2719: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2720: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2721: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2722: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2723: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2724: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2725: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2718: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2719: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2720: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2721: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2722: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2723: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2724: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2725: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2726: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2719: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2720: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2721: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2722: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2723: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2724: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2725: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2726: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2727: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2720: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2721: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2722: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2723: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2724: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2725: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2726: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2727: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2728: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2721: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2722: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2723: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2724: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2725: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2726: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2727: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2728: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2729: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2722: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2723: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2724: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2725: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2726: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2727: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2728: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2729: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2730: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2723: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2724: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2725: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2726: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2727: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2728: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2729: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2730: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2731: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2724: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2725: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2726: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2727: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2728: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2729: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2730: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2731: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2732: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2725: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2726: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2727: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2728: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2729: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2730: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2731: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2732: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2733: WSH_DEBUG_SV.log(l_module_name,'L_CALLER', l_caller); -- 5986504
2726: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2727: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2728: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2729: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2730: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2731: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2732: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2733: WSH_DEBUG_SV.log(l_module_name,'L_CALLER', l_caller); -- 5986504
2734: END IF;
2727: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2728: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2729: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2730: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2731: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2732: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2733: WSH_DEBUG_SV.log(l_module_name,'L_CALLER', l_caller); -- 5986504
2734: END IF;
2735: --
2728: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2729: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2730: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2731: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2732: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2733: WSH_DEBUG_SV.log(l_module_name,'L_CALLER', l_caller); -- 5986504
2734: END IF;
2735: --
2736: if (p_exception_name is not NULL ) then
2729: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2730: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2731: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2732: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2733: WSH_DEBUG_SV.log(l_module_name,'L_CALLER', l_caller); -- 5986504
2734: END IF;
2735: --
2736: if (p_exception_name is not NULL ) then
2737: if (p_source_lang = userenv('LANG')) then
2826: --
2827: -- Debug Statements
2828: --
2829: IF l_debug_on THEN
2830: WSH_DEBUG_SV.pop(l_module_name);
2831: END IF;
2832: --
2833: exception
2834:
2839: --
2840: -- Debug Statements
2841: --
2842: IF l_debug_on THEN
2843: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_DUP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2844: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_DUP');
2845: END IF;
2846: --
2847: end Load_Row;
2840: -- Debug Statements
2841: --
2842: IF l_debug_on THEN
2843: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_DUP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2844: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_DUP');
2845: END IF;
2846: --
2847: end Load_Row;
2848:
2875: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2876: --
2877: IF l_debug_on IS NULL
2878: THEN
2879: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2880: END IF;
2881: --
2882: IF l_debug_on THEN
2883: WSH_DEBUG_SV.push(l_module_name);
2879: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2880: END IF;
2881: --
2882: IF l_debug_on THEN
2883: WSH_DEBUG_SV.push(l_module_name);
2884: --
2885: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2886: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2887: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2881: --
2882: IF l_debug_on THEN
2883: WSH_DEBUG_SV.push(l_module_name);
2884: --
2885: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2886: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2887: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2888: WSH_DEBUG_SV.log(l_module_name,'P_OWNER',P_OWNER);
2889: END IF;
2882: IF l_debug_on THEN
2883: WSH_DEBUG_SV.push(l_module_name);
2884: --
2885: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2886: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2887: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2888: WSH_DEBUG_SV.log(l_module_name,'P_OWNER',P_OWNER);
2889: END IF;
2890: --
2883: WSH_DEBUG_SV.push(l_module_name);
2884: --
2885: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2886: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2887: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
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
2884: --
2885: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2886: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2887: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
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
2903: --
2904: -- Debug Statements
2905: --
2906: IF l_debug_on THEN
2907: WSH_DEBUG_SV.pop(l_module_name);
2908: END IF;
2909: --
2910: end Translate_Row;
2911:
2938: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2939: --
2940: IF l_debug_on IS NULL
2941: THEN
2942: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2943: END IF;
2944: --
2945: IF l_debug_on THEN
2946: WSH_DEBUG_SV.push(l_module_name);
2942: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2943: END IF;
2944: --
2945: IF l_debug_on THEN
2946: WSH_DEBUG_SV.push(l_module_name);
2947: --
2948: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2949: END IF;
2950: --
2944: --
2945: IF l_debug_on THEN
2946: WSH_DEBUG_SV.push(l_module_name);
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 ;
2965: --
2966: -- Debug Statements
2967: --
2968: IF l_debug_on THEN
2969: WSH_DEBUG_SV.pop(l_module_name);
2970: END IF;
2971: --
2972: exception
2973:
2979: --
2980: -- Debug Statements
2981: --
2982: IF l_debug_on THEN
2983: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2984: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_NOT_FOUND');
2985: END IF;
2986: --
2987: end delete_xc_def_form ;
2980: -- Debug Statements
2981: --
2982: IF l_debug_on THEN
2983: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2984: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_NOT_FOUND');
2985: END IF;
2986: --
2987: end delete_xc_def_form ;
2988:
3008: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3009: --
3010: IF l_debug_on IS NULL
3011: THEN
3012: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3013: END IF;
3014: --
3015: IF l_debug_on THEN
3016: WSH_DEBUG_SV.push(l_module_name);
3012: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3013: END IF;
3014: --
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
3082: --
3083: -- Debug Statements
3084: --
3085: IF l_debug_on THEN
3086: WSH_DEBUG_SV.pop(l_module_name);
3087: END IF;
3088: --
3089: end ADD_LANGUAGE;
3090:
3121: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3122: --
3123: IF l_debug_on IS NULL
3124: THEN
3125: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3126: END IF;
3127: --
3128: IF l_debug_on THEN
3129: WSH_DEBUG_SV.push(l_module_name);
3125: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3126: END IF;
3127: --
3128: IF l_debug_on THEN
3129: WSH_DEBUG_SV.push(l_module_name);
3130: --
3131: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
3132: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
3133: END IF;
3127: --
3128: IF l_debug_on THEN
3129: WSH_DEBUG_SV.push(l_module_name);
3130: --
3131: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
3132: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
3133: END IF;
3134: --
3135: if p_lookup_code is NULL or p_lookup_type is NULL then
3128: IF l_debug_on THEN
3129: WSH_DEBUG_SV.push(l_module_name);
3130: --
3131: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
3132: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
3133: END IF;
3134: --
3135: if p_lookup_code is NULL or p_lookup_type is NULL then
3136: --
3136: --
3137: -- Debug Statements
3138: --
3139: IF l_debug_on THEN
3140: WSH_DEBUG_SV.pop(l_module_name);
3141: END IF;
3142: --
3143: return NULL;
3144: else
3149: --
3150: -- Debug Statements
3151: --
3152: IF l_debug_on THEN
3153: WSH_DEBUG_SV.pop(l_module_name);
3154: END IF;
3155: --
3156: return NULL;
3157: else
3159: --
3160: -- Debug Statements
3161: --
3162: IF l_debug_on THEN
3163: WSH_DEBUG_SV.pop(l_module_name);
3164: END IF;
3165: --
3166: return l_lookup_meaning;
3167: end if;
3347: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3348: --
3349: IF l_debug_on IS NULL
3350: THEN
3351: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3352: END IF;
3353: --
3354: IF l_debug_on THEN
3355: WSH_DEBUG_SV.push(l_module_name);
3351: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3352: END IF;
3353: --
3354: IF l_debug_on THEN
3355: WSH_DEBUG_SV.push(l_module_name);
3356: --
3357: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3358: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3359: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3353: --
3354: IF l_debug_on THEN
3355: WSH_DEBUG_SV.push(l_module_name);
3356: --
3357: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3358: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3359: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3360: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3361: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
3354: IF l_debug_on THEN
3355: WSH_DEBUG_SV.push(l_module_name);
3356: --
3357: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3358: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3359: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3360: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3361: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
3362: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
3355: WSH_DEBUG_SV.push(l_module_name);
3356: --
3357: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3358: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3359: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3360: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3361: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
3362: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
3363: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
3356: --
3357: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3358: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3359: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3360: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3361: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
3362: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
3363: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
3364: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
3357: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3358: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3359: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3360: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3361: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
3362: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
3363: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
3364: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
3365: WSH_DEBUG_SV.log(l_module_name,'P_LOGGED_AT_LOCATION_ID',P_LOGGED_AT_LOCATION_ID);
3358: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3359: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3360: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3361: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
3362: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
3363: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
3364: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
3365: WSH_DEBUG_SV.log(l_module_name,'P_LOGGED_AT_LOCATION_ID',P_LOGGED_AT_LOCATION_ID);
3366: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ORG_ID',P_INVENTORY_ORG_ID);
3359: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3360: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3361: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
3362: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
3363: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
3364: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
3365: WSH_DEBUG_SV.log(l_module_name,'P_LOGGED_AT_LOCATION_ID',P_LOGGED_AT_LOCATION_ID);
3366: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ORG_ID',P_INVENTORY_ORG_ID);
3367: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
3360: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3361: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
3362: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
3363: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
3364: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
3365: WSH_DEBUG_SV.log(l_module_name,'P_LOGGED_AT_LOCATION_ID',P_LOGGED_AT_LOCATION_ID);
3366: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ORG_ID',P_INVENTORY_ORG_ID);
3367: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
3368: WSH_DEBUG_SV.log(l_module_name,'P_SEVERITY',P_SEVERITY);
3361: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
3362: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
3363: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
3364: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
3365: WSH_DEBUG_SV.log(l_module_name,'P_LOGGED_AT_LOCATION_ID',P_LOGGED_AT_LOCATION_ID);
3366: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ORG_ID',P_INVENTORY_ORG_ID);
3367: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
3368: WSH_DEBUG_SV.log(l_module_name,'P_SEVERITY',P_SEVERITY);
3369: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
3362: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
3363: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
3364: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
3365: WSH_DEBUG_SV.log(l_module_name,'P_LOGGED_AT_LOCATION_ID',P_LOGGED_AT_LOCATION_ID);
3366: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ORG_ID',P_INVENTORY_ORG_ID);
3367: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
3368: WSH_DEBUG_SV.log(l_module_name,'P_SEVERITY',P_SEVERITY);
3369: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
3370: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_FROM',P_ARRIVAL_DATE_FROM);
3363: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
3364: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
3365: WSH_DEBUG_SV.log(l_module_name,'P_LOGGED_AT_LOCATION_ID',P_LOGGED_AT_LOCATION_ID);
3366: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ORG_ID',P_INVENTORY_ORG_ID);
3367: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
3368: WSH_DEBUG_SV.log(l_module_name,'P_SEVERITY',P_SEVERITY);
3369: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
3370: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_FROM',P_ARRIVAL_DATE_FROM);
3371: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_TO',P_ARRIVAL_DATE_TO);
3364: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
3365: WSH_DEBUG_SV.log(l_module_name,'P_LOGGED_AT_LOCATION_ID',P_LOGGED_AT_LOCATION_ID);
3366: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ORG_ID',P_INVENTORY_ORG_ID);
3367: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
3368: WSH_DEBUG_SV.log(l_module_name,'P_SEVERITY',P_SEVERITY);
3369: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
3370: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_FROM',P_ARRIVAL_DATE_FROM);
3371: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_TO',P_ARRIVAL_DATE_TO);
3372: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_FROM',P_DEPARTURE_DATE_FROM);
3365: WSH_DEBUG_SV.log(l_module_name,'P_LOGGED_AT_LOCATION_ID',P_LOGGED_AT_LOCATION_ID);
3366: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ORG_ID',P_INVENTORY_ORG_ID);
3367: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
3368: WSH_DEBUG_SV.log(l_module_name,'P_SEVERITY',P_SEVERITY);
3369: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
3370: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_FROM',P_ARRIVAL_DATE_FROM);
3371: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_TO',P_ARRIVAL_DATE_TO);
3372: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_FROM',P_DEPARTURE_DATE_FROM);
3373: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_TO',P_DEPARTURE_DATE_TO);
3366: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ORG_ID',P_INVENTORY_ORG_ID);
3367: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
3368: WSH_DEBUG_SV.log(l_module_name,'P_SEVERITY',P_SEVERITY);
3369: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
3370: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_FROM',P_ARRIVAL_DATE_FROM);
3371: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_TO',P_ARRIVAL_DATE_TO);
3372: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_FROM',P_DEPARTURE_DATE_FROM);
3373: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_TO',P_DEPARTURE_DATE_TO);
3374: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_FROM',P_CREATION_DATE_FROM);
3367: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
3368: WSH_DEBUG_SV.log(l_module_name,'P_SEVERITY',P_SEVERITY);
3369: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
3370: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_FROM',P_ARRIVAL_DATE_FROM);
3371: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_TO',P_ARRIVAL_DATE_TO);
3372: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_FROM',P_DEPARTURE_DATE_FROM);
3373: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_TO',P_DEPARTURE_DATE_TO);
3374: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_FROM',P_CREATION_DATE_FROM);
3375: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_TO',P_CREATION_DATE_TO);
3368: WSH_DEBUG_SV.log(l_module_name,'P_SEVERITY',P_SEVERITY);
3369: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
3370: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_FROM',P_ARRIVAL_DATE_FROM);
3371: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_TO',P_ARRIVAL_DATE_TO);
3372: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_FROM',P_DEPARTURE_DATE_FROM);
3373: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_TO',P_DEPARTURE_DATE_TO);
3374: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_FROM',P_CREATION_DATE_FROM);
3375: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_TO',P_CREATION_DATE_TO);
3376: WSH_DEBUG_SV.log(l_module_name,'P_DATA_OLDER_NO_OF_DAYS',P_DATA_OLDER_NO_OF_DAYS);
3369: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
3370: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_FROM',P_ARRIVAL_DATE_FROM);
3371: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_TO',P_ARRIVAL_DATE_TO);
3372: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_FROM',P_DEPARTURE_DATE_FROM);
3373: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_TO',P_DEPARTURE_DATE_TO);
3374: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_FROM',P_CREATION_DATE_FROM);
3375: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_TO',P_CREATION_DATE_TO);
3376: WSH_DEBUG_SV.log(l_module_name,'P_DATA_OLDER_NO_OF_DAYS',P_DATA_OLDER_NO_OF_DAYS);
3377: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
3370: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_FROM',P_ARRIVAL_DATE_FROM);
3371: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_TO',P_ARRIVAL_DATE_TO);
3372: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_FROM',P_DEPARTURE_DATE_FROM);
3373: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_TO',P_DEPARTURE_DATE_TO);
3374: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_FROM',P_CREATION_DATE_FROM);
3375: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_TO',P_CREATION_DATE_TO);
3376: WSH_DEBUG_SV.log(l_module_name,'P_DATA_OLDER_NO_OF_DAYS',P_DATA_OLDER_NO_OF_DAYS);
3377: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
3378: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
3371: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_TO',P_ARRIVAL_DATE_TO);
3372: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_FROM',P_DEPARTURE_DATE_FROM);
3373: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_TO',P_DEPARTURE_DATE_TO);
3374: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_FROM',P_CREATION_DATE_FROM);
3375: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_TO',P_CREATION_DATE_TO);
3376: WSH_DEBUG_SV.log(l_module_name,'P_DATA_OLDER_NO_OF_DAYS',P_DATA_OLDER_NO_OF_DAYS);
3377: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
3378: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
3379: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
3372: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_FROM',P_DEPARTURE_DATE_FROM);
3373: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_TO',P_DEPARTURE_DATE_TO);
3374: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_FROM',P_CREATION_DATE_FROM);
3375: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_TO',P_CREATION_DATE_TO);
3376: WSH_DEBUG_SV.log(l_module_name,'P_DATA_OLDER_NO_OF_DAYS',P_DATA_OLDER_NO_OF_DAYS);
3377: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
3378: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
3379: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
3380: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
3373: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_TO',P_DEPARTURE_DATE_TO);
3374: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_FROM',P_CREATION_DATE_FROM);
3375: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_TO',P_CREATION_DATE_TO);
3376: WSH_DEBUG_SV.log(l_module_name,'P_DATA_OLDER_NO_OF_DAYS',P_DATA_OLDER_NO_OF_DAYS);
3377: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
3378: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
3379: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
3380: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
3381: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
3374: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_FROM',P_CREATION_DATE_FROM);
3375: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_TO',P_CREATION_DATE_TO);
3376: WSH_DEBUG_SV.log(l_module_name,'P_DATA_OLDER_NO_OF_DAYS',P_DATA_OLDER_NO_OF_DAYS);
3377: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
3378: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
3379: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
3380: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
3381: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
3382: END IF;
3375: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_TO',P_CREATION_DATE_TO);
3376: WSH_DEBUG_SV.log(l_module_name,'P_DATA_OLDER_NO_OF_DAYS',P_DATA_OLDER_NO_OF_DAYS);
3377: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
3378: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
3379: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
3380: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
3381: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
3382: END IF;
3383: --
3376: WSH_DEBUG_SV.log(l_module_name,'P_DATA_OLDER_NO_OF_DAYS',P_DATA_OLDER_NO_OF_DAYS);
3377: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
3378: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
3379: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
3380: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
3381: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
3382: END IF;
3383: --
3384: SAVEPOINT WSH_XC_UTIL;
3377: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
3378: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
3379: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
3380: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
3381: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
3382: END IF;
3383: --
3384: SAVEPOINT WSH_XC_UTIL;
3385: -- Standard call to check for call compatibility.
3801: --
3802: -- Debug Statements
3803: --
3804: IF l_debug_on THEN
3805: WSH_DEBUG_SV.log(l_module_name,'Count',x_no_of_recs_purged);
3806: WSH_DEBUG_SV.pop(l_module_name);
3807: END IF;
3808: --
3809: EXCEPTION
3802: -- Debug Statements
3803: --
3804: IF l_debug_on THEN
3805: WSH_DEBUG_SV.log(l_module_name,'Count',x_no_of_recs_purged);
3806: WSH_DEBUG_SV.pop(l_module_name);
3807: END IF;
3808: --
3809: EXCEPTION
3810: WHEN WSH_PURGE_FAILED THEN
3820: --
3821: -- Debug Statements
3822: --
3823: IF l_debug_on THEN
3824: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_PURGE_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3825: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_PURGE_FAILED');
3826: END IF;
3827: --
3828: WHEN FND_API.G_EXC_ERROR THEN
3821: -- Debug Statements
3822: --
3823: IF l_debug_on THEN
3824: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_PURGE_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3825: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_PURGE_FAILED');
3826: END IF;
3827: --
3828: WHEN FND_API.G_EXC_ERROR THEN
3829: ROLLBACK TO WSH_XC_UTIL;
3838: --
3839: -- Debug Statements
3840: --
3841: IF l_debug_on THEN
3842: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3843: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3844: END IF;
3845: --
3846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3839: -- Debug Statements
3840: --
3841: IF l_debug_on THEN
3842: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3843: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3844: END IF;
3845: --
3846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3847: ROLLBACK TO WSH_XC_UTIL;
3856: --
3857: -- Debug Statements
3858: --
3859: IF l_debug_on THEN
3860: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3861: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3862: END IF;
3863: --
3864: WHEN OTHERS THEN
3857: -- Debug Statements
3858: --
3859: IF l_debug_on THEN
3860: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3861: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3862: END IF;
3863: --
3864: WHEN OTHERS THEN
3865: ROLLBACK TO WSH_XC_UTIL;
3874: --
3875: -- Debug Statements
3876: --
3877: IF l_debug_on THEN
3878: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3879: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3880: END IF;
3881: --
3882: end;
3875: -- Debug Statements
3876: --
3877: IF l_debug_on THEN
3878: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3879: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3880: END IF;
3881: --
3882: end;
3883:
4041: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4042: --
4043: IF l_debug_on IS NULL
4044: THEN
4045: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4046: END IF;
4047: --
4048: --
4049: -- Debug Statements
4048: --
4049: -- Debug Statements
4050: --
4051: IF l_debug_on THEN
4052: WSH_DEBUG_SV.push(l_module_name);
4053: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4054: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4055: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4056: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4049: -- Debug Statements
4050: --
4051: IF l_debug_on THEN
4052: WSH_DEBUG_SV.push(l_module_name);
4053: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4054: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4055: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4056: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4057: WSH_DEBUG_SV.log(l_module_name,'P_CONSIDER_CONTENT',P_CONSIDER_CONTENT);
4050: --
4051: IF l_debug_on THEN
4052: WSH_DEBUG_SV.push(l_module_name);
4053: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4054: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4055: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4056: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4057: WSH_DEBUG_SV.log(l_module_name,'P_CONSIDER_CONTENT',P_CONSIDER_CONTENT);
4058: END IF;
4051: IF l_debug_on THEN
4052: WSH_DEBUG_SV.push(l_module_name);
4053: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4054: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4055: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4056: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4057: WSH_DEBUG_SV.log(l_module_name,'P_CONSIDER_CONTENT',P_CONSIDER_CONTENT);
4058: END IF;
4059:
4052: WSH_DEBUG_SV.push(l_module_name);
4053: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4054: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4055: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4056: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4057: WSH_DEBUG_SV.log(l_module_name,'P_CONSIDER_CONTENT',P_CONSIDER_CONTENT);
4058: END IF;
4059:
4060: IF NOT FND_API.compatible_api_call (
4053: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4054: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4055: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4056: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4057: WSH_DEBUG_SV.log(l_module_name,'P_CONSIDER_CONTENT',P_CONSIDER_CONTENT);
4058: END IF;
4059:
4060: IF NOT FND_API.compatible_api_call (
4061: l_api_version,
4105: p_caller => p_caller||c_trip
4106: );
4107: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4108: IF l_debug_on THEN
4109: WSH_DEBUG_SV.logmsg('Check Exception failed for Stop :'||stop_rec.stop_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4110: END IF;
4111: RAISE WSH_CHECK_EXCEPTIONS_FAILED;
4112: END IF;
4113:
4144: x_exceptions_tab => x_exceptions_tab
4145: );
4146: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4147: IF l_debug_on THEN
4148: WSH_DEBUG_SV.logmsg('Check Exception failed for Delivery :'||del_rec.delivery_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4149: END IF;
4150: RAISE WSH_CHECK_EXCEPTIONS_FAILED;
4151: END IF;
4152:
4174: p_caller => p_caller
4175: );
4176: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4177: IF l_debug_on THEN
4178: WSH_DEBUG_SV.logmsg('Check Exception failed for Stop :'||stop_rec.stop_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4179: END IF;
4180: RAISE WSH_CHECK_EXCEPTIONS_FAILED;
4181: END IF;
4182: IF l_exceptions_tab IS NOT NULL AND l_exceptions_tab.COUNT>0 THEN
4237: x_exceptions_tab => x_exceptions_tab
4238: );
4239: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4240: IF l_debug_on THEN
4241: WSH_DEBUG_SV.logmsg('Check Exception failed for Detail :'||detail_rec.delivery_detail_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4242: END IF;
4243: RAISE WSH_CHECK_EXCEPTIONS_FAILED;
4244: END IF;
4245:
4299: x_exceptions_tab => x_exceptions_tab
4300: );
4301: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4302: IF l_debug_on THEN
4303: WSH_DEBUG_SV.logmsg('Check Exception failed for Detail :'||detail_rec.delivery_detail_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4304: END IF;
4305: RAISE WSH_CHECK_EXCEPTIONS_FAILED;
4306: END IF;
4307:
4316: --
4317: -- Debug Statements
4318: --
4319: IF l_debug_on THEN
4320: WSH_DEBUG_SV.pop(l_module_name);
4321: END IF;
4322: --
4323:
4324: EXCEPTION
4333: --
4334: -- Debug Statements
4335: --
4336: IF l_debug_on THEN
4337: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CHECK_EXCEPTIONS_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4338: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CHECK_EXCEPTIONS_FAILED');
4339: END IF;
4340: --
4341:
4334: -- Debug Statements
4335: --
4336: IF l_debug_on THEN
4337: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CHECK_EXCEPTIONS_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4338: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CHECK_EXCEPTIONS_FAILED');
4339: END IF;
4340: --
4341:
4342: WHEN WSH_INVALID_LOGGING_ENTITY THEN
4351: --
4352: -- Debug Statements
4353: --
4354: IF l_debug_on THEN
4355: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_LOGGING_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4356: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_LOGGING_ENTITY');
4357: END IF;
4358: --
4359:
4352: -- Debug Statements
4353: --
4354: IF l_debug_on THEN
4355: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_LOGGING_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4356: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_LOGGING_ENTITY');
4357: END IF;
4358: --
4359:
4360: WHEN others THEN
4386: --
4387: -- Debug Statements
4388: --
4389: IF l_debug_on THEN
4390: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4391: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4392: END IF;
4393: --
4394:
4387: -- Debug Statements
4388: --
4389: IF l_debug_on THEN
4390: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4391: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4392: END IF;
4393: --
4394:
4395: END Check_Exceptions;
4498: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4499: --
4500: IF l_debug_on IS NULL
4501: THEN
4502: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4503: END IF;
4504: --
4505: --
4506: -- Debug Statements
4505: --
4506: -- Debug Statements
4507: --
4508: IF l_debug_on THEN
4509: WSH_DEBUG_SV.push(l_module_name);
4510: --
4511: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4512: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4513: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4507: --
4508: IF l_debug_on THEN
4509: WSH_DEBUG_SV.push(l_module_name);
4510: --
4511: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4512: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4513: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4514: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4515: END IF;
4508: IF l_debug_on THEN
4509: WSH_DEBUG_SV.push(l_module_name);
4510: --
4511: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4512: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4513: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4514: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4515: END IF;
4516:
4509: WSH_DEBUG_SV.push(l_module_name);
4510: --
4511: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4512: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4513: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4514: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4515: END IF;
4516:
4517: IF NOT FND_API.compatible_api_call (
4510: --
4511: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4512: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4513: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4514: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4515: END IF;
4516:
4517: IF NOT FND_API.compatible_api_call (
4518: l_api_version,
4540: p_action => C_ACTION_SEMICLOSED
4541: );
4542: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4543: IF l_debug_on THEN
4544: WSH_DEBUG_SV.logmsg('Purge failed for Trip :'||p_logging_entity_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4545: END IF;
4546: RAISE WSH_PURGE_FAILED;
4547: END IF;
4548:
4560: p_caller => p_caller||c_trip
4561: );
4562: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4563: IF l_debug_on THEN
4564: WSH_DEBUG_SV.logmsg('Close_Exception failed for Stop :'||stop_rec.stop_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4565: END IF;
4566: RAISE WSH_CLOSE_EXCEPTIONS_FAILED;
4567: END IF;
4568: END LOOP;
4570:
4571: ELSIF (p_logging_entity_name = 'STOP') THEN
4572:
4573: IF l_debug_on THEN
4574: WSH_DEBUG_SV.logmsg('Calling Purge for Stop '||p_logging_entity_id ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4575: END IF;
4576: WSH_XC_UTIL.Purge (
4577: p_api_version => p_api_version,
4578: x_return_status => x_return_status,
4583: p_action => C_ACTION_SEMICLOSED
4584: );
4585: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4586: IF l_debug_on THEN
4587: WSH_DEBUG_SV.logmsg('Purge failed for Stop :'||p_logging_entity_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4588: END IF;
4589: RAISE WSH_PURGE_FAILED;
4590: END IF;
4591:
4602: p_consider_content => p_consider_content
4603: );
4604: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4605: IF l_debug_on THEN
4606: WSH_DEBUG_SV.logmsg('Close_Exception failed for Delivery :'||del_rec.delivery_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4607: END IF;
4608: RAISE WSH_CLOSE_EXCEPTIONS_FAILED;
4609: END IF;
4610: END LOOP;
4628: p_caller => p_caller
4629: );
4630: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4631: IF l_debug_on THEN
4632: WSH_DEBUG_SV.logmsg('Close_Exception failed for Stop :'||stop_rec.stop_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4633: END IF;
4634: RAISE WSH_CLOSE_EXCEPTIONS_FAILED;
4635: END IF;
4636: END LOOP;
4647: p_action => C_ACTION_SEMICLOSED
4648: );
4649: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4650: IF l_debug_on THEN
4651: WSH_DEBUG_SV.logmsg('Purge failed for Delivery :'||p_logging_entity_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4652: END IF;
4653: RAISE WSH_PURGE_FAILED;
4654: END IF;
4655:
4664: p_action => C_ACTION_SEMICLOSED
4665: );
4666: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4667: IF l_debug_on THEN
4668: WSH_DEBUG_SV.logmsg('Purge failed for Detail/Container :'||p_logging_entity_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4669: END IF;
4670: RAISE WSH_PURGE_FAILED;
4671: END IF;
4672:
4679: --
4680: -- Debug Statements
4681: --
4682: IF l_debug_on THEN
4683: WSH_DEBUG_SV.pop(l_module_name);
4684: END IF;
4685: --
4686:
4687: EXCEPTION
4697: --
4698: -- Debug Statements
4699: --
4700: IF l_debug_on THEN
4701: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CLOSE_EXCEPTIONS_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4702: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CLOSE_EXCEPTIONS_FAILED');
4703: END IF;
4704: --
4705:
4698: -- Debug Statements
4699: --
4700: IF l_debug_on THEN
4701: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CLOSE_EXCEPTIONS_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4702: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CLOSE_EXCEPTIONS_FAILED');
4703: END IF;
4704: --
4705:
4706: WHEN WSH_PURGE_FAILED THEN
4715: --
4716: -- Debug Statements
4717: --
4718: IF l_debug_on THEN
4719: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_PURGE_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4720: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_PURGE_FAILED');
4721: END IF;
4722: --
4723:
4716: -- Debug Statements
4717: --
4718: IF l_debug_on THEN
4719: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_PURGE_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4720: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_PURGE_FAILED');
4721: END IF;
4722: --
4723:
4724: WHEN WSH_INVALID_LOGGING_ENTITY THEN
4734: --
4735: -- Debug Statements
4736: --
4737: IF l_debug_on THEN
4738: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_LOGGING_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4739: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_LOGGING_ENTITY');
4740: END IF;
4741: --
4742:
4735: -- Debug Statements
4736: --
4737: IF l_debug_on THEN
4738: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_LOGGING_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4739: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_LOGGING_ENTITY');
4740: END IF;
4741: --
4742:
4743: WHEN others THEN
4747: --
4748: -- Debug Statements
4749: --
4750: IF l_debug_on THEN
4751: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4752: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4753: END IF;
4754: --
4755:
4748: -- Debug Statements
4749: --
4750: IF l_debug_on THEN
4751: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4752: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4753: END IF;
4754: --
4755:
4756: END Close_Exceptions;
4788: --
4789: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4790: --
4791: IF l_debug_on IS NULL THEN
4792: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4793: END IF;
4794: --
4795: IF l_debug_on THEN
4796: WSH_DEBUG_SV.push(l_module_name);
4792: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4793: END IF;
4794: --
4795: IF l_debug_on THEN
4796: WSH_DEBUG_SV.push(l_module_name);
4797: WSH_DEBUG_SV.log(l_module_name, 'delivery id', p_delivery_id);
4798: WSH_DEBUG_SV.log(l_module_name, 'number of exceptions to close', p_exceptions_to_close_tab.COUNT);
4799: END IF;
4800: --
4793: END IF;
4794: --
4795: IF l_debug_on THEN
4796: WSH_DEBUG_SV.push(l_module_name);
4797: WSH_DEBUG_SV.log(l_module_name, 'delivery id', p_delivery_id);
4798: WSH_DEBUG_SV.log(l_module_name, 'number of exceptions to close', p_exceptions_to_close_tab.COUNT);
4799: END IF;
4800: --
4801: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4794: --
4795: IF l_debug_on THEN
4796: WSH_DEBUG_SV.push(l_module_name);
4797: WSH_DEBUG_SV.log(l_module_name, 'delivery id', p_delivery_id);
4798: WSH_DEBUG_SV.log(l_module_name, 'number of exceptions to close', p_exceptions_to_close_tab.COUNT);
4799: END IF;
4800: --
4801: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4802: l_exception_name := NULL;
4814: l_exception_name := p_exceptions_to_close_tab(i);
4815:
4816: -- call purge with action 'CLOSED'
4817: IF l_debug_on THEN
4818: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.PURGE',WSH_DEBUG_SV.C_PROC_LEVEL);
4819: END IF;
4820:
4821: WSH_XC_UTIL.purge (
4822: p_api_version => 1.0,
4830: p_action => 'CLOSED'
4831: );
4832:
4833: IF l_debug_on THEN
4834: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.purge: ' || l_return_status);
4835: WSH_DEBUG_SV.log(l_module_name, 'number of exceptions purged', l_count);
4836: END IF;
4837:
4838: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
4831: );
4832:
4833: IF l_debug_on THEN
4834: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.purge: ' || l_return_status);
4835: WSH_DEBUG_SV.log(l_module_name, 'number of exceptions purged', l_count);
4836: END IF;
4837:
4838: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
4839: x_return_status := l_return_status;
4852:
4853: -- Debug Statements
4854: --
4855: IF l_debug_on THEN
4856: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
4857: WSH_DEBUG_SV.pop(l_module_name);
4858: END IF;
4859: --
4860:
4853: -- Debug Statements
4854: --
4855: IF l_debug_on THEN
4856: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
4857: WSH_DEBUG_SV.pop(l_module_name);
4858: END IF;
4859: --
4860:
4861: EXCEPTION
4863: WHEN OTHERS THEN
4864: wsh_util_core.default_handler('WSH_XC_UTIL.CLOSE_OTM_EXCEPTION', l_module_name);
4865: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4866: IF l_debug_on THEN
4867: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected error has occured. '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4868: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4869: END IF;
4870:
4871: END CLOSE_OTM_EXCEPTION;
4864: wsh_util_core.default_handler('WSH_XC_UTIL.CLOSE_OTM_EXCEPTION', l_module_name);
4865: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4866: IF l_debug_on THEN
4867: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected error has occured. '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4868: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4869: END IF;
4870:
4871: END CLOSE_OTM_EXCEPTION;
4872:
4914: --
4915: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4916: --
4917: IF l_debug_on IS NULL THEN
4918: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4919: END IF;
4920: --
4921: IF l_debug_on THEN
4922: WSH_DEBUG_SV.push(l_module_name);
4918: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4919: END IF;
4920: --
4921: IF l_debug_on THEN
4922: WSH_DEBUG_SV.push(l_module_name);
4923: WSH_DEBUG_SV.log(l_module_name, 'delivery record count', p_delivery_info_tab.COUNT);
4924: WSH_DEBUG_SV.log(l_module_name, 'interface flag count', p_new_interface_flag_tab.COUNT);
4925: END IF;
4926:
4919: END IF;
4920: --
4921: IF l_debug_on THEN
4922: WSH_DEBUG_SV.push(l_module_name);
4923: WSH_DEBUG_SV.log(l_module_name, 'delivery record count', p_delivery_info_tab.COUNT);
4924: WSH_DEBUG_SV.log(l_module_name, 'interface flag count', p_new_interface_flag_tab.COUNT);
4925: END IF;
4926:
4927: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4920: --
4921: IF l_debug_on THEN
4922: WSH_DEBUG_SV.push(l_module_name);
4923: WSH_DEBUG_SV.log(l_module_name, 'delivery record count', p_delivery_info_tab.COUNT);
4924: WSH_DEBUG_SV.log(l_module_name, 'interface flag count', p_new_interface_flag_tab.COUNT);
4925: END IF;
4926:
4927: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4928:
4935: i := 0;
4936:
4937: IF (p_delivery_info_tab.COUNT = 0) THEN
4938: IF l_debug_on THEN
4939: WSH_DEBUG_SV.logmsg(l_module_name, 'no delivery to log exceptions');
4940: END IF;
4941: END IF;
4942:
4943: i := p_delivery_info_tab.FIRST;
4961: l_new_interface_flag := p_new_interface_flag_tab(i);
4962: END IF;
4963:
4964: IF l_debug_on THEN
4965: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_id' , p_delivery_info_tab(i).delivery_id);
4966: WSH_DEBUG_SV.log(l_module_name, 'l_new_interface_flag', l_new_interface_flag);
4967: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_info_tab(i).tms_interface_flag', p_delivery_info_tab(i).tms_interface_flag);
4968: IF p_new_interface_flag_tab.COUNT > 0 THEN
4969: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_info_tab(i).tms_interface_flag', p_new_interface_flag_tab(i));
4962: END IF;
4963:
4964: IF l_debug_on THEN
4965: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_id' , p_delivery_info_tab(i).delivery_id);
4966: WSH_DEBUG_SV.log(l_module_name, 'l_new_interface_flag', l_new_interface_flag);
4967: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_info_tab(i).tms_interface_flag', p_delivery_info_tab(i).tms_interface_flag);
4968: IF p_new_interface_flag_tab.COUNT > 0 THEN
4969: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_info_tab(i).tms_interface_flag', p_new_interface_flag_tab(i));
4970: END IF;
4963:
4964: IF l_debug_on THEN
4965: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_id' , p_delivery_info_tab(i).delivery_id);
4966: WSH_DEBUG_SV.log(l_module_name, 'l_new_interface_flag', l_new_interface_flag);
4967: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_info_tab(i).tms_interface_flag', p_delivery_info_tab(i).tms_interface_flag);
4968: IF p_new_interface_flag_tab.COUNT > 0 THEN
4969: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_info_tab(i).tms_interface_flag', p_new_interface_flag_tab(i));
4970: END IF;
4971: END IF;
4965: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_id' , p_delivery_info_tab(i).delivery_id);
4966: WSH_DEBUG_SV.log(l_module_name, 'l_new_interface_flag', l_new_interface_flag);
4967: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_info_tab(i).tms_interface_flag', p_delivery_info_tab(i).tms_interface_flag);
4968: IF p_new_interface_flag_tab.COUNT > 0 THEN
4969: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_info_tab(i).tms_interface_flag', p_new_interface_flag_tab(i));
4970: END IF;
4971: END IF;
4972:
4973: --log and close exceptions only if new status is different and not IN Process status
5001:
5002: IF l_exceptions_to_close_tab.COUNT > 0 THEN
5003:
5004: IF l_debug_on THEN
5005: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.CLOSE_OTM_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
5006: END IF;
5007:
5008: WSH_XC_UTIL.close_otm_exception(
5009: p_delivery_id => p_delivery_info_tab(i).delivery_id,
5011: x_return_status => l_return_status
5012: );
5013:
5014: IF l_debug_on THEN
5015: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.close_otm_exception: ' || l_return_status);
5016: END IF;
5017:
5018: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5019: l_num_error := l_num_error + 1;
5037: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', p_delivery_info_tab(i).name);
5038: l_exception_message := FND_MESSAGE.GET;
5039:
5040: IF l_debug_on THEN
5041: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
5042: END IF;
5043:
5044: WSH_XC_UTIL.log_exception(
5045: p_api_version => 1.0,
5056: p_message => l_exception_message);
5057:
5058:
5059: IF l_debug_on THEN
5060: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.log_exception: ' || l_return_status);
5061: END IF;
5062:
5063: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5064: l_num_error := l_num_error + 1;
5110:
5111: l_exception_message := FND_MESSAGE.GET;
5112:
5113: IF l_debug_on THEN
5114: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
5115: END IF;
5116:
5117: WSH_XC_UTIL.log_exception(
5118: p_api_version => 1.0,
5128: p_delivery_id => p_delivery_info_tab(i).delivery_id,
5129: p_message => l_exception_message);
5130:
5131: IF l_debug_on THEN
5132: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.log_exception: ' || l_return_status);
5133: END IF;
5134:
5135: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5136: l_num_error := l_num_error + 1;
5157: --
5158: -- Debug Statements
5159: --
5160: IF l_debug_on THEN
5161: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5162: WSH_DEBUG_SV.pop(l_module_name);
5163: END IF;
5164: --
5165:
5158: -- Debug Statements
5159: --
5160: IF l_debug_on THEN
5161: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5162: WSH_DEBUG_SV.pop(l_module_name);
5163: END IF;
5164: --
5165:
5166: EXCEPTION
5168: wsh_util_core.default_handler('WSH_XC_UTIL.LOG_OTM_EXCEPTION', l_module_name);
5169: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5170:
5171: IF l_debug_on THEN
5172: WSH_DEBUG_SV.logmsg(l_module_name,
5173: 'Unexpected error has occured. Oracle error message is '|| SQLERRM,
5174: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5175: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5176: END IF;
5170:
5171: IF l_debug_on THEN
5172: WSH_DEBUG_SV.logmsg(l_module_name,
5173: 'Unexpected error has occured. Oracle error message is '|| SQLERRM,
5174: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5175: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5176: END IF;
5177:
5178: END LOG_OTM_EXCEPTION;
5171: IF l_debug_on THEN
5172: WSH_DEBUG_SV.logmsg(l_module_name,
5173: 'Unexpected error has occured. Oracle error message is '|| SQLERRM,
5174: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5175: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5176: END IF;
5177:
5178: END LOG_OTM_EXCEPTION;
5179:
5222:
5223: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5224:
5225: IF l_debug_on IS NULL THEN
5226: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5227: END IF;
5228: --
5229: IF l_debug_on THEN
5230: WSH_DEBUG_SV.push(l_module_name);
5226: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5227: END IF;
5228: --
5229: IF l_debug_on THEN
5230: WSH_DEBUG_SV.push(l_module_name);
5231: WSH_DEBUG_SV.log(l_module_name, 'delivery id', p_delivery_id);
5232: END IF;
5233:
5234: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5227: END IF;
5228: --
5229: IF l_debug_on THEN
5230: WSH_DEBUG_SV.push(l_module_name);
5231: WSH_DEBUG_SV.log(l_module_name, 'delivery id', p_delivery_id);
5232: END IF;
5233:
5234: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5235:
5238: l_exception_name := NULL;
5239:
5240: IF (p_delivery_id IS NULL) THEN
5241: IF l_debug_on THEN
5242: WSH_DEBUG_SV.logmsg(l_module_name, 'delivery id is NULL');
5243: WSH_DEBUG_SV.pop(l_module_name);
5244: END IF;
5245: x_severity := l_severity;
5246: x_exception_name := l_exception_name;
5239:
5240: IF (p_delivery_id IS NULL) THEN
5241: IF l_debug_on THEN
5242: WSH_DEBUG_SV.logmsg(l_module_name, 'delivery id is NULL');
5243: WSH_DEBUG_SV.pop(l_module_name);
5244: END IF;
5245: x_severity := l_severity;
5246: x_exception_name := l_exception_name;
5247: RETURN;
5266: x_severity := l_severity;
5267: x_exception_name := l_exception_name;
5268:
5269: IF l_debug_on THEN
5270: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_severity);
5271: WSH_DEBUG_SV.log(l_module_name, 'x_exception_name', x_exception_name);
5272: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5273: WSH_DEBUG_SV.pop(l_module_name);
5274: END IF;
5267: x_exception_name := l_exception_name;
5268:
5269: IF l_debug_on THEN
5270: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_severity);
5271: WSH_DEBUG_SV.log(l_module_name, 'x_exception_name', x_exception_name);
5272: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5273: WSH_DEBUG_SV.pop(l_module_name);
5274: END IF;
5275:
5268:
5269: IF l_debug_on THEN
5270: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_severity);
5271: WSH_DEBUG_SV.log(l_module_name, 'x_exception_name', x_exception_name);
5272: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5273: WSH_DEBUG_SV.pop(l_module_name);
5274: END IF;
5275:
5276: EXCEPTION
5269: IF l_debug_on THEN
5270: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_severity);
5271: WSH_DEBUG_SV.log(l_module_name, 'x_exception_name', x_exception_name);
5272: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5273: WSH_DEBUG_SV.pop(l_module_name);
5274: END IF;
5275:
5276: EXCEPTION
5277: WHEN OTHERS THEN
5281: IF c_get_delivery_otm_exceptions%ISOPEN THEN
5282: CLOSE c_get_delivery_otm_exceptions;
5283: END IF;
5284: IF l_debug_on THEN
5285: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5286: WSH_DEBUG_SV.pop(l_module_name);
5287: END IF;
5288:
5289: END GET_OTM_DELIVERY_EXCEPTION;
5282: CLOSE c_get_delivery_otm_exceptions;
5283: END IF;
5284: IF l_debug_on THEN
5285: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5286: WSH_DEBUG_SV.pop(l_module_name);
5287: END IF;
5288:
5289: END GET_OTM_DELIVERY_EXCEPTION;
5290: --END OTM R12