[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';
806: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
807: RAISE WSH_XC_DEF_NOT_FOUND;
808: ELSIF l_exc_def_info.enabled = 'N' THEN
809: IF l_debug_on THEN
810: WSH_DEBUG_SV.logmsg(l_module_name,'Not logging exception since the exception is not enabled',WSH_DEBUG_SV.C_PROC_LEVEL);
811: END IF;
812: GOTO end_proc;
813: END IF;
814:
1250: END IF;
1251:
1252: IF l_debug_on THEN
1253:
1254: WSH_DEBUG_SV.log(l_module_name,'p_attribute15',p_attribute15);
1255: WSH_DEBUG_SV.log(l_module_name,'l_xcp_record.attribute15',l_xcp_record.attribute15);
1256: END IF;
1257: IF p_attribute15 IS NOT NULL THEN
1258:
1251:
1252: IF l_debug_on THEN
1253:
1254: WSH_DEBUG_SV.log(l_module_name,'p_attribute15',p_attribute15);
1255: WSH_DEBUG_SV.log(l_module_name,'l_xcp_record.attribute15',l_xcp_record.attribute15);
1256: END IF;
1257: IF p_attribute15 IS NOT NULL THEN
1258:
1259: IF l_xcp_record.attribute15 IS NULL THEN
1355: -- Raise Business Event , if exception is workflow enabled and Exception name is being passed first time
1356: IF p_exception_name IS NOT NULL AND NOT (l_exception_name_exists)
1357: AND nvl(l_exc_def_info.initiate_workflow,'N') = 'Y' THEN
1358: IF l_debug_on THEN
1359: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Business event for exception : '||l_exception_id,WSH_DEBUG_SV.C_PROC_LEVEL);
1360: END IF;
1361: l_event_key := x_exception_id;
1362: IF p_delivery_detail_id IS NOT NULL THEN
1363: l_p_entity_name := 'LINE';
1375: l_p_entity_name := NULL;
1376: l_p_entity_id := NULL;
1377: END IF;
1378: IF l_debug_on THEN
1379: 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);
1380: END IF;
1381: WF_EVENT.AddParameterToList ( p_name => 'EXCEPTION_NAME',
1382: p_value => p_exception_name,
1383: p_parameterlist => l_msg_parameter_list);
1393: WF_EVENT.AddParameterToList ( p_name => 'EXCEPTION_BEHAVIOR',
1394: p_value => l_severity,
1395: p_parameterlist => l_msg_parameter_list);
1396: IF l_debug_on THEN
1397: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_EVENT.RAISE' ,WSH_DEBUG_SV.C_PROC_LEVEL);
1398: END IF;
1399: WF_EVENT.Raise ( p_event_name => l_event_name,
1400: p_event_key => 'EXCP'||l_event_key,
1401: p_parameters => l_msg_parameter_list );
1405:
1406: WSH_UTIL_CORE.get_messages('N', l_msg_summary, l_msg_details, x_msg_count);
1407: if x_msg_count > 1 then
1408: IF l_debug_on THEN
1409: wsh_debug_sv.logmsg(l_module_name, 'x_msg_count > 1');
1410: END IF;
1411: x_msg_data := SUBSTRB((l_msg_summary || l_msg_details),1, 2000);
1412: else
1413: IF l_debug_on THEN
1410: END IF;
1411: x_msg_data := SUBSTRB((l_msg_summary || l_msg_details),1, 2000);
1412: else
1413: IF l_debug_on THEN
1414: wsh_debug_sv.logmsg(l_module_name, 'x_msg_count < 1');
1415: END IF;
1416: x_msg_data := SUBSTRB(l_msg_summary, 1, 2000);
1417: end if;
1418:
1419: --
1420: -- Debug Statements
1421: --
1422: IF l_debug_on THEN
1423: WSH_DEBUG_SV.pop(l_module_name);
1424: END IF;
1425: --
1426: EXCEPTION
1427:
1449: --
1450: -- Debug Statements
1451: --
1452: IF l_debug_on THEN
1453: WSH_DEBUG_SV.logmsg(l_module_name, L_MSG_SUMMARY );
1454: END IF;
1455: --
1456: if x_msg_count > 1 then
1457: x_msg_data := l_msg_summary || l_msg_details;
1462: --
1463: -- Debug Statements
1464: --
1465: IF l_debug_on THEN
1466: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_OPERATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1467: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_OPERATION');
1468: END IF;
1469: --
1470: WHEN WSH_XC_INVALID_LOGGING_ENTITY THEN
1463: -- Debug Statements
1464: --
1465: IF l_debug_on THEN
1466: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_OPERATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1467: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_OPERATION');
1468: END IF;
1469: --
1470: WHEN WSH_XC_INVALID_LOGGING_ENTITY THEN
1471: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_INVALID_LOGGING_ENTITY');
1478: --
1479: -- Debug Statements
1480: --
1481: IF l_debug_on THEN
1482: WSH_DEBUG_SV.logmsg(l_module_name, L_MSG_SUMMARY );
1483: END IF;
1484: --
1485: if x_msg_count > 1 then
1486: x_msg_data := l_msg_summary || l_msg_details;
1491: --
1492: -- Debug Statements
1493: --
1494: IF l_debug_on THEN
1495: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_LOGGING_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1496: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_LOGGING_ENTITY');
1497: END IF;
1498: --
1499: WHEN WSH_XC_INVALID_SEVERITY THEN
1492: -- Debug Statements
1493: --
1494: IF l_debug_on THEN
1495: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_LOGGING_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1496: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_LOGGING_ENTITY');
1497: END IF;
1498: --
1499: WHEN WSH_XC_INVALID_SEVERITY THEN
1500: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_INVALID_SEVERITY');
1507: --
1508: -- Debug Statements
1509: --
1510: IF l_debug_on THEN
1511: WSH_DEBUG_SV.logmsg(l_module_name, L_MSG_SUMMARY );
1512: END IF;
1513: --
1514: if x_msg_count > 1 then
1515: x_msg_data := l_msg_summary || l_msg_details;
1521: --
1522: -- Debug Statements
1523: --
1524: IF l_debug_on THEN
1525: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_SEVERITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_SEVERITY');
1527: END IF;
1528: --
1529: WHEN WSH_XC_INVALID_LOCATION THEN
1522: -- Debug Statements
1523: --
1524: IF l_debug_on THEN
1525: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_SEVERITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_SEVERITY');
1527: END IF;
1528: --
1529: WHEN WSH_XC_INVALID_LOCATION THEN
1530: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_INVALID_LOCATION');
1537: --
1538: -- Debug Statements
1539: --
1540: IF l_debug_on THEN
1541: WSH_DEBUG_SV.logmsg(l_module_name, L_MSG_SUMMARY );
1542: END IF;
1543: --
1544: if x_msg_count > 1 then
1545: x_msg_data := l_msg_summary || l_msg_details;
1551: --
1552: -- Debug Statements
1553: --
1554: IF l_debug_on THEN
1555: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_LOCATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_LOCATION');
1557: END IF;
1558: --
1559: WHEN WSH_XC_NOT_FOUND THEN
1552: -- Debug Statements
1553: --
1554: IF l_debug_on THEN
1555: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_LOCATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_LOCATION');
1557: END IF;
1558: --
1559: WHEN WSH_XC_NOT_FOUND THEN
1560: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_NOT_FOUND');
1567: --
1568: -- Debug Statements
1569: --
1570: IF l_debug_on THEN
1571: WSH_DEBUG_SV.logmsg(l_module_name, L_MSG_SUMMARY );
1572: END IF;
1573: --
1574: if x_msg_count > 1 then
1575: x_msg_data := l_msg_summary || l_msg_details;
1581: --
1582: -- Debug Statements
1583: --
1584: IF l_debug_on THEN
1585: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1586: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_NOT_FOUND');
1587: END IF;
1588: --
1589: WHEN WSH_XC_DEF_NOT_FOUND THEN
1582: -- Debug Statements
1583: --
1584: IF l_debug_on THEN
1585: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1586: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_NOT_FOUND');
1587: END IF;
1588: --
1589: WHEN WSH_XC_DEF_NOT_FOUND THEN
1590:
1594: --
1595: -- Debug Statements
1596: --
1597: IF l_debug_on THEN
1598: WSH_DEBUG_SV.logmsg(l_module_name, L_MSG_SUMMARY );
1599: END IF;
1600: --
1601: if x_msg_count > 1 then
1602: x_msg_data := l_msg_summary || l_msg_details;
1607: --
1608: -- Debug Statements
1609: --
1610: IF l_debug_on THEN
1611: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1612: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_NOT_FOUND');
1613: END IF;
1614: --
1615: WHEN WSH_XC_DATA_ERROR THEN
1608: -- Debug Statements
1609: --
1610: IF l_debug_on THEN
1611: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1612: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_NOT_FOUND');
1613: END IF;
1614: --
1615: WHEN WSH_XC_DATA_ERROR THEN
1616: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_DATA_ERROR');
1623: --
1624: -- Debug Statements
1625: --
1626: IF l_debug_on THEN
1627: WSH_DEBUG_SV.logmsg(l_module_name, L_MSG_SUMMARY );
1628: END IF;
1629: --
1630: if x_msg_count > 1 then
1631: x_msg_data := l_msg_summary || l_msg_details;
1637: --
1638: -- Debug Statements
1639: --
1640: IF l_debug_on THEN
1641: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DATA_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1642: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DATA_ERROR');
1643: END IF;
1644: --
1645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1638: -- Debug Statements
1639: --
1640: IF l_debug_on THEN
1641: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DATA_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1642: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DATA_ERROR');
1643: END IF;
1644: --
1645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1646: ROLLBACK TO Log_Exception_PUB ;
1649: --
1650: -- Debug Statements
1651: --
1652: IF l_debug_on THEN
1653: WSH_DEBUG_SV.logmsg(l_module_name, L_MSG_SUMMARY );
1654: END IF;
1655: --
1656:
1657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1666: --
1667: -- Debug Statements
1668: --
1669: IF l_debug_on THEN
1670: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1671: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1672: END IF;
1673: --
1674: WHEN OTHERS THEN
1667: -- Debug Statements
1668: --
1669: IF l_debug_on THEN
1670: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1671: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1672: END IF;
1673: --
1674: WHEN OTHERS THEN
1675: ROLLBACK TO Log_Exception_PUB ;
1684: --
1685: -- Debug Statements
1686: --
1687: IF l_debug_on THEN
1688: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1689: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1690: END IF;
1691: --
1692: END log_exception;
1685: -- Debug Statements
1686: --
1687: IF l_debug_on THEN
1688: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1689: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1690: END IF;
1691: --
1692: END log_exception;
1693:
1794: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1795: --
1796: IF l_debug_on IS NULL
1797: THEN
1798: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1799: END IF;
1800: --
1801: IF l_debug_on THEN
1802: WSH_DEBUG_SV.push(l_module_name);
1798: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1799: END IF;
1800: --
1801: IF l_debug_on THEN
1802: WSH_DEBUG_SV.push(l_module_name);
1803: --
1804: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1805: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1806: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1800: --
1801: IF l_debug_on THEN
1802: WSH_DEBUG_SV.push(l_module_name);
1803: --
1804: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1805: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1806: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1807: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1808: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_ID',P_EXCEPTION_ID);
1801: IF l_debug_on THEN
1802: WSH_DEBUG_SV.push(l_module_name);
1803: --
1804: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1805: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1806: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1807: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1808: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_ID',P_EXCEPTION_ID);
1809: WSH_DEBUG_SV.log(l_module_name,'P_OLD_STATUS',P_OLD_STATUS);
1802: WSH_DEBUG_SV.push(l_module_name);
1803: --
1804: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1805: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1806: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1807: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1808: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_ID',P_EXCEPTION_ID);
1809: WSH_DEBUG_SV.log(l_module_name,'P_OLD_STATUS',P_OLD_STATUS);
1810: WSH_DEBUG_SV.log(l_module_name,'P_SET_DEFAULT_STATUS',P_SET_DEFAULT_STATUS);
1803: --
1804: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1805: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1806: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1807: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1808: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_ID',P_EXCEPTION_ID);
1809: WSH_DEBUG_SV.log(l_module_name,'P_OLD_STATUS',P_OLD_STATUS);
1810: WSH_DEBUG_SV.log(l_module_name,'P_SET_DEFAULT_STATUS',P_SET_DEFAULT_STATUS);
1811: WSH_DEBUG_SV.log(l_module_name,'X_NEW_STATUS',X_NEW_STATUS);
1804: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
1805: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1806: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1807: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1808: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_ID',P_EXCEPTION_ID);
1809: WSH_DEBUG_SV.log(l_module_name,'P_OLD_STATUS',P_OLD_STATUS);
1810: WSH_DEBUG_SV.log(l_module_name,'P_SET_DEFAULT_STATUS',P_SET_DEFAULT_STATUS);
1811: WSH_DEBUG_SV.log(l_module_name,'X_NEW_STATUS',X_NEW_STATUS);
1812: END IF;
1805: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1806: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1807: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1808: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_ID',P_EXCEPTION_ID);
1809: WSH_DEBUG_SV.log(l_module_name,'P_OLD_STATUS',P_OLD_STATUS);
1810: WSH_DEBUG_SV.log(l_module_name,'P_SET_DEFAULT_STATUS',P_SET_DEFAULT_STATUS);
1811: WSH_DEBUG_SV.log(l_module_name,'X_NEW_STATUS',X_NEW_STATUS);
1812: END IF;
1813: --
1806: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1807: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1808: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_ID',P_EXCEPTION_ID);
1809: WSH_DEBUG_SV.log(l_module_name,'P_OLD_STATUS',P_OLD_STATUS);
1810: WSH_DEBUG_SV.log(l_module_name,'P_SET_DEFAULT_STATUS',P_SET_DEFAULT_STATUS);
1811: WSH_DEBUG_SV.log(l_module_name,'X_NEW_STATUS',X_NEW_STATUS);
1812: END IF;
1813: --
1814: SAVEPOINT Change_Status_PUB;
1807: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
1808: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_ID',P_EXCEPTION_ID);
1809: WSH_DEBUG_SV.log(l_module_name,'P_OLD_STATUS',P_OLD_STATUS);
1810: WSH_DEBUG_SV.log(l_module_name,'P_SET_DEFAULT_STATUS',P_SET_DEFAULT_STATUS);
1811: WSH_DEBUG_SV.log(l_module_name,'X_NEW_STATUS',X_NEW_STATUS);
1812: END IF;
1813: --
1814: SAVEPOINT Change_Status_PUB;
1815: -- Standard call to check for call compatibility.
1845: OPEN C1(p_exception_id);
1846: FETCH C1 INTO l_exception_name, l_old_status;
1847: IF (C1%FOUND) THEN
1848: IF l_debug_on THEN
1849: 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);
1850: END IF;
1851: IF l_old_status <> UPPER(l_p_old_status) THEN
1852: CLOSE C1;
1853: RAISE WSH_XC_STATUS_MISMATCH;
1928: --
1929: -- Debug Statements
1930: --
1931: IF l_debug_on THEN
1932: WSH_DEBUG_SV.pop(l_module_name);
1933: END IF;
1934: --
1935: EXCEPTION
1936:
1948: --
1949: -- Debug Statements
1950: --
1951: IF l_debug_on THEN
1952: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_OTM_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1953: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_OTM_ERROR');
1954: END IF;
1955: -- OTM R12 end of glog project
1956:
1949: -- Debug Statements
1950: --
1951: IF l_debug_on THEN
1952: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_OTM_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1953: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_OTM_ERROR');
1954: END IF;
1955: -- OTM R12 end of glog project
1956:
1957: WHEN WSH_XC_INVALID_STATUS THEN
1969: --
1970: -- Debug Statements
1971: --
1972: IF l_debug_on THEN
1973: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_STATUS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1974: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_STATUS');
1975: END IF;
1976: --
1977: WHEN WSH_XC_INVALID_OPERATION THEN
1970: -- Debug Statements
1971: --
1972: IF l_debug_on THEN
1973: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_STATUS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1974: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_STATUS');
1975: END IF;
1976: --
1977: WHEN WSH_XC_INVALID_OPERATION THEN
1978: FND_MESSAGE.SET_NAME('WSH', l_msg_name);
1988: --
1989: -- Debug Statements
1990: --
1991: IF l_debug_on THEN
1992: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_OPERATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1993: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_OPERATION');
1994: END IF;
1995: --
1996: WHEN WSH_XC_STATUS_MISMATCH THEN
1989: -- Debug Statements
1990: --
1991: IF l_debug_on THEN
1992: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_OPERATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1993: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_OPERATION');
1994: END IF;
1995: --
1996: WHEN WSH_XC_STATUS_MISMATCH THEN
1997: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_STATUS_MISMATCH');
2008: --
2009: -- Debug Statements
2010: --
2011: IF l_debug_on THEN
2012: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_STATUS_MISMATCH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2013: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_STATUS_MISMATCH');
2014: END IF;
2015: --
2016: WHEN WSH_XC_NOT_FOUND THEN
2009: -- Debug Statements
2010: --
2011: IF l_debug_on THEN
2012: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_STATUS_MISMATCH exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2013: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_STATUS_MISMATCH');
2014: END IF;
2015: --
2016: WHEN WSH_XC_NOT_FOUND THEN
2017: IF C1%ISOPEN THEN
2031: --
2032: -- Debug Statements
2033: --
2034: IF l_debug_on THEN
2035: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2036: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_NOT_FOUND');
2037: END IF;
2038: --
2039: WHEN WSH_XC_DATA_ERROR THEN
2032: -- Debug Statements
2033: --
2034: IF l_debug_on THEN
2035: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2036: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_NOT_FOUND');
2037: END IF;
2038: --
2039: WHEN WSH_XC_DATA_ERROR THEN
2040: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_DATA_ERROR');
2051: --
2052: -- Debug Statements
2053: --
2054: IF l_debug_on THEN
2055: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DATA_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2056: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DATA_ERROR');
2057: END IF;
2058: --
2059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2052: -- Debug Statements
2053: --
2054: IF l_debug_on THEN
2055: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DATA_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2056: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DATA_ERROR');
2057: END IF;
2058: --
2059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2060: ROLLBACK TO Change_Status_PUB ;
2070: --
2071: -- Debug Statements
2072: --
2073: IF l_debug_on THEN
2074: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2075: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2076: END IF;
2077: --
2078:
2071: -- Debug Statements
2072: --
2073: IF l_debug_on THEN
2074: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2075: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2076: END IF;
2077: --
2078:
2079: WHEN WSH_XC_EXCEPTION_CLOSED THEN
2089: end if;
2090:
2091:
2092: IF l_debug_on THEN
2093: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_EXCEPTION_CLOSED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2094: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_OPERATION');
2095: END IF;
2096:
2097:
2090:
2091:
2092: IF l_debug_on THEN
2093: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_EXCEPTION_CLOSED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2094: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_OPERATION');
2095: END IF;
2096:
2097:
2098: WHEN OTHERS THEN
2108: --
2109: -- Debug Statements
2110: --
2111: IF l_debug_on THEN
2112: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2113: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2114: END IF;
2115: --
2116: END change_status;
2109: -- Debug Statements
2110: --
2111: IF l_debug_on THEN
2112: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2113: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2114: END IF;
2115: --
2116: END change_status;
2117:
2193: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2194: --
2195: IF l_debug_on IS NULL
2196: THEN
2197: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2198: END IF;
2199: --
2200: IF l_debug_on THEN
2201: WSH_DEBUG_SV.push(l_module_name);
2197: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2198: END IF;
2199: --
2200: IF l_debug_on THEN
2201: WSH_DEBUG_SV.push(l_module_name);
2202: --
2203: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_DEFINITION_ID',X_EXCEPTION_DEFINITION_ID);
2204: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2205: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2199: --
2200: IF l_debug_on THEN
2201: WSH_DEBUG_SV.push(l_module_name);
2202: --
2203: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_DEFINITION_ID',X_EXCEPTION_DEFINITION_ID);
2204: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2205: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2206: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2207: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2200: IF l_debug_on THEN
2201: WSH_DEBUG_SV.push(l_module_name);
2202: --
2203: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_DEFINITION_ID',X_EXCEPTION_DEFINITION_ID);
2204: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2205: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2206: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2207: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2208: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2201: WSH_DEBUG_SV.push(l_module_name);
2202: --
2203: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_DEFINITION_ID',X_EXCEPTION_DEFINITION_ID);
2204: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2205: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2206: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2207: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2208: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2209: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2202: --
2203: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_DEFINITION_ID',X_EXCEPTION_DEFINITION_ID);
2204: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2205: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2206: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2207: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2208: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2209: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2210: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2203: WSH_DEBUG_SV.log(l_module_name,'X_EXCEPTION_DEFINITION_ID',X_EXCEPTION_DEFINITION_ID);
2204: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2205: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2206: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2207: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2208: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2209: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2210: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2211: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2204: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2205: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2206: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2207: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2208: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2209: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2210: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2211: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2212: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2205: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2206: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2207: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2208: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2209: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2210: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2211: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2212: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2213: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2206: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2207: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2208: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2209: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2210: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2211: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2212: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2213: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2214: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2207: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2208: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2209: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2210: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2211: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2212: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2213: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2214: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2215: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2208: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2209: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2210: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2211: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2212: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2213: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2214: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2215: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2216: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2209: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2210: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2211: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2212: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2213: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2214: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2215: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2216: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2217: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2210: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2211: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2212: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2213: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2214: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2215: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2216: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2217: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2218: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2211: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2212: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2213: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2214: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2215: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2216: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2217: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2218: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2219: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2212: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2213: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2214: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2215: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2216: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2217: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2218: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2219: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2220: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2213: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2214: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2215: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2216: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2217: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2218: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2219: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2220: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2221: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2214: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2215: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2216: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2217: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2218: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2219: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2220: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2221: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2222: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2215: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2216: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2217: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2218: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2219: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2220: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2221: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2222: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2223: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2216: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2217: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2218: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2219: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2220: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2221: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2222: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2223: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2224: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2217: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2218: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2219: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2220: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2221: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2222: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2223: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2224: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2225: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2218: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2219: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2220: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2221: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2222: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2223: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2224: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2225: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2226: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2219: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2220: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2221: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2222: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2223: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2224: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2225: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2226: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2227: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2220: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2221: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2222: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2223: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2224: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2225: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2226: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2227: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2228: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2221: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2222: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2223: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2224: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2225: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2226: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2227: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2228: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2229: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2222: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2223: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2224: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2225: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2226: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2227: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2228: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2229: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2230: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2223: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2224: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2225: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2226: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2227: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2228: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2229: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2230: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2231: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2224: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2225: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2226: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2227: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2228: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2229: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2230: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2231: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2232: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2225: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2226: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2227: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2228: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2229: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2230: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2231: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2232: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2233: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2226: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2227: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2228: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2229: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2230: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2231: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2232: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2233: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2234: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2227: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2228: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2229: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2230: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2231: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2232: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2233: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2234: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2235: END IF;
2228: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2229: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2230: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2231: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2232: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2233: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2234: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2235: END IF;
2236: --
2229: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2230: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2231: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2232: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2233: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2234: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2235: END IF;
2236: --
2237: open C1(p_exception_name);
2230: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2231: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2232: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2233: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2234: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2235: END IF;
2236: --
2237: open C1(p_exception_name);
2238: fetch C1 into l_exception_name;
2364: --
2365: -- Debug Statements
2366: --
2367: IF l_debug_on THEN
2368: WSH_DEBUG_SV.pop(l_module_name);
2369: END IF;
2370: --
2371: exception
2372:
2377: --
2378: -- Debug Statements
2379: --
2380: IF l_debug_on THEN
2381: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_DUP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2382: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_DUP');
2383: END IF;
2384: --
2385: WHEN WSH_XC_DEF_NOT_FOUND THEN
2378: -- Debug Statements
2379: --
2380: IF l_debug_on THEN
2381: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_DUP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2382: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_DUP');
2383: END IF;
2384: --
2385: WHEN WSH_XC_DEF_NOT_FOUND THEN
2386: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_NOT_FOUND');
2389: --
2390: -- Debug Statements
2391: --
2392: IF l_debug_on THEN
2393: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2394: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_NOT_FOUND');
2395: END IF;
2396: --
2397: end insert_xc_def_form;
2390: -- Debug Statements
2391: --
2392: IF l_debug_on THEN
2393: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2394: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_NOT_FOUND');
2395: END IF;
2396: --
2397: end insert_xc_def_form;
2398:
2467: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2468: --
2469: IF l_debug_on IS NULL
2470: THEN
2471: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2472: END IF;
2473: --
2474: -- 5986504
2475: open C2 (p_exception_definition_id);
2476: fetch C2 into l_update_allowed;
2477: close C2;
2478: --
2479: IF l_debug_on THEN
2480: WSH_DEBUG_SV.push(l_module_name);
2481: --
2482: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2483: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2484: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2478: --
2479: IF l_debug_on THEN
2480: WSH_DEBUG_SV.push(l_module_name);
2481: --
2482: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2483: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2484: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2485: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2486: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2479: IF l_debug_on THEN
2480: WSH_DEBUG_SV.push(l_module_name);
2481: --
2482: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2483: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2484: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2485: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2486: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2487: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2480: WSH_DEBUG_SV.push(l_module_name);
2481: --
2482: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2483: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2484: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2485: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2486: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2487: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2488: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2481: --
2482: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2483: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2484: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2485: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2486: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2487: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2488: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2489: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2482: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2483: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2484: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2485: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2486: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2487: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2488: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2489: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2490: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2483: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2484: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2485: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2486: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2487: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2488: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2489: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2490: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2491: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2484: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2485: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2486: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2487: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2488: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2489: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2490: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2491: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2492: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2485: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2486: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2487: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2488: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2489: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2490: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2491: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2492: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2493: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2486: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2487: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2488: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2489: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2490: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2491: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2492: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2493: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2494: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2487: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2488: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2489: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2490: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2491: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2492: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2493: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2494: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2495: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2488: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2489: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2490: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2491: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2492: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2493: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2494: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2495: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2496: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2489: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2490: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2491: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2492: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2493: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2494: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2495: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2496: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2497: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2490: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2491: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2492: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2493: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2494: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2495: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2496: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2497: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2498: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2491: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2492: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2493: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2494: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2495: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2496: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2497: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2498: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2499: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2492: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2493: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2494: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2495: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2496: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2497: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2498: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2499: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2500: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2493: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2494: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2495: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2496: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2497: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2498: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2499: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2500: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2501: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2494: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2495: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2496: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2497: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2498: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2499: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2500: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2501: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2502: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2495: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2496: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2497: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2498: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2499: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2500: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2501: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2502: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2503: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2496: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2497: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2498: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2499: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2500: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2501: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2502: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2503: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2504: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2497: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2498: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2499: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2500: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2501: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2502: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2503: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2504: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2505: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2498: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2499: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2500: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2501: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2502: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2503: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2504: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2505: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2506: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2499: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2500: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2501: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2502: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2503: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2504: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2505: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2506: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2507: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2500: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2501: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2502: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2503: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2504: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2505: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2506: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2507: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2508: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2501: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2502: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2503: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2504: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2505: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2506: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2507: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2508: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2509: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2502: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2503: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2504: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2505: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2506: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2507: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2508: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2509: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2510: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2503: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2504: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2505: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2506: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2507: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2508: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2509: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2510: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2511: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2504: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2505: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2506: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2507: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2508: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2509: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2510: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2511: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2512: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2505: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2506: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2507: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2508: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2509: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2510: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2511: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2512: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2513: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2506: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2507: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2508: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2509: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2510: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2511: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2512: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2513: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2514: WSH_DEBUG_SV.log(l_module_name,'L_UPDATE_ALLOWED -in Db ', L_UPDATE_ALLOWED); --5986504
2507: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2508: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2509: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2510: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2511: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2512: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2513: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2514: WSH_DEBUG_SV.log(l_module_name,'L_UPDATE_ALLOWED -in Db ', L_UPDATE_ALLOWED); --5986504
2515: WSH_DEBUG_SV.log(l_module_name,'L_CALLER -Loader / Form ', P_CALLER); --5986504
2508: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2509: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2510: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2511: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2512: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2513: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2514: WSH_DEBUG_SV.log(l_module_name,'L_UPDATE_ALLOWED -in Db ', L_UPDATE_ALLOWED); --5986504
2515: WSH_DEBUG_SV.log(l_module_name,'L_CALLER -Loader / Form ', P_CALLER); --5986504
2516: END IF;
2509: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2510: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2511: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2512: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2513: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2514: WSH_DEBUG_SV.log(l_module_name,'L_UPDATE_ALLOWED -in Db ', L_UPDATE_ALLOWED); --5986504
2515: WSH_DEBUG_SV.log(l_module_name,'L_CALLER -Loader / Form ', P_CALLER); --5986504
2516: END IF;
2517: -- 5986504{ If Caller is Loader then Either p_update_allowed should be N or a Flip (Y -> N or N-Y)
2510: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2511: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2512: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2513: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2514: WSH_DEBUG_SV.log(l_module_name,'L_UPDATE_ALLOWED -in Db ', L_UPDATE_ALLOWED); --5986504
2515: WSH_DEBUG_SV.log(l_module_name,'L_CALLER -Loader / Form ', P_CALLER); --5986504
2516: END IF;
2517: -- 5986504{ If Caller is Loader then Either p_update_allowed should be N or a Flip (Y -> N or N-Y)
2518: -- should have taken place to be Elligible for Update.
2511: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2512: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2513: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2514: WSH_DEBUG_SV.log(l_module_name,'L_UPDATE_ALLOWED -in Db ', L_UPDATE_ALLOWED); --5986504
2515: WSH_DEBUG_SV.log(l_module_name,'L_CALLER -Loader / Form ', P_CALLER); --5986504
2516: END IF;
2517: -- 5986504{ If Caller is Loader then Either p_update_allowed should be N or a Flip (Y -> N or N-Y)
2518: -- should have taken place to be Elligible for Update.
2519: -- If Caller is Form , then Updates are Elligible
2557: end if;
2558:
2559: -- 5986504
2560: IF l_debug_on THEN
2561: WSH_DEBUG_SV.log(l_module_name,'After Base Table Update ... ', P_CALLER);
2562: END IF;
2563:
2564: update WSH_EXCEPTION_DEFINITIONS_TL set
2565: EXCEPTION_NAME = p_exception_name,
2576: end if;
2577:
2578: -- 5986504
2579: IF l_debug_on THEN
2580: WSH_DEBUG_SV.log(l_module_name,'After TL Table Update ... ', P_CALLER);
2581: WSH_DEBUG_SV.logmsg(l_module_name,'After Updates '||P_EXCEPTION_DEFINITION_ID,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2582: WSH_DEBUG_SV.logmsg(l_module_name,'After Updates '||P_CALLER,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2583: END IF;
2584:
2577:
2578: -- 5986504
2579: IF l_debug_on THEN
2580: WSH_DEBUG_SV.log(l_module_name,'After TL Table Update ... ', P_CALLER);
2581: WSH_DEBUG_SV.logmsg(l_module_name,'After Updates '||P_EXCEPTION_DEFINITION_ID,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2582: WSH_DEBUG_SV.logmsg(l_module_name,'After Updates '||P_CALLER,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2583: END IF;
2584:
2585: end if; -- 5986504 }
2578: -- 5986504
2579: IF l_debug_on THEN
2580: WSH_DEBUG_SV.log(l_module_name,'After TL Table Update ... ', P_CALLER);
2581: WSH_DEBUG_SV.logmsg(l_module_name,'After Updates '||P_EXCEPTION_DEFINITION_ID,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2582: WSH_DEBUG_SV.logmsg(l_module_name,'After Updates '||P_CALLER,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2583: END IF;
2584:
2585: end if; -- 5986504 }
2586:
2587: --
2588: -- Debug Statements
2589: --
2590: IF l_debug_on THEN
2591: WSH_DEBUG_SV.pop(l_module_name);
2592: END IF;
2593: --
2594: exception
2595:
2595:
2596: WHEN WSH_XC_DEF_NOT_FOUND THEN
2597: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_DEF_NOT_FOUND');
2598: IF l_debug_on THEN
2599: WSH_DEBUG_SV.log(l_module_name,'- Failed in Update .. ', P_CALLER);
2600: END IF;
2601: APP_EXCEPTION.RAISE_EXCEPTION;
2602:
2603: --
2603: --
2604: -- Debug Statements
2605: --
2606: IF l_debug_on THEN
2607: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2608: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_NOT_FOUND');
2609: END IF;
2610: --
2611: end update_xc_def_form;
2604: -- Debug Statements
2605: --
2606: IF l_debug_on THEN
2607: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2608: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_NOT_FOUND');
2609: END IF;
2610: --
2611: end update_xc_def_form;
2612:
2683: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2684: --
2685: IF l_debug_on IS NULL
2686: THEN
2687: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2688: END IF;
2689: --
2690: IF l_debug_on THEN
2691: WSH_DEBUG_SV.push(l_module_name);
2687: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2688: END IF;
2689: --
2690: IF l_debug_on THEN
2691: WSH_DEBUG_SV.push(l_module_name);
2692: --
2693: WSH_DEBUG_SV.log(l_module_name,'P_LANGUAGE',P_LANGUAGE);
2694: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LANG',P_SOURCE_LANG);
2695: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2689: --
2690: IF l_debug_on THEN
2691: WSH_DEBUG_SV.push(l_module_name);
2692: --
2693: WSH_DEBUG_SV.log(l_module_name,'P_LANGUAGE',P_LANGUAGE);
2694: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LANG',P_SOURCE_LANG);
2695: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2696: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2697: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2690: IF l_debug_on THEN
2691: WSH_DEBUG_SV.push(l_module_name);
2692: --
2693: WSH_DEBUG_SV.log(l_module_name,'P_LANGUAGE',P_LANGUAGE);
2694: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LANG',P_SOURCE_LANG);
2695: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2696: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2697: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2698: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2691: WSH_DEBUG_SV.push(l_module_name);
2692: --
2693: WSH_DEBUG_SV.log(l_module_name,'P_LANGUAGE',P_LANGUAGE);
2694: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LANG',P_SOURCE_LANG);
2695: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2696: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2697: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2698: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2699: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2692: --
2693: WSH_DEBUG_SV.log(l_module_name,'P_LANGUAGE',P_LANGUAGE);
2694: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LANG',P_SOURCE_LANG);
2695: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2696: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2697: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2698: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2699: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2700: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2693: WSH_DEBUG_SV.log(l_module_name,'P_LANGUAGE',P_LANGUAGE);
2694: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LANG',P_SOURCE_LANG);
2695: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2696: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2697: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2698: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2699: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2700: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2701: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2694: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LANG',P_SOURCE_LANG);
2695: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2696: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2697: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2698: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2699: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2700: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2701: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2702: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2695: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2696: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2697: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2698: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2699: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2700: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2701: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2702: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2703: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2696: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2697: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2698: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2699: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2700: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2701: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2702: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2703: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2704: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2697: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2698: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2699: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2700: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2701: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2702: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2703: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2704: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2705: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2698: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
2699: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2700: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2701: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2702: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2703: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2704: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2705: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2706: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2699: WSH_DEBUG_SV.log(l_module_name,'P_DEFAULT_SEVERITY',P_DEFAULT_SEVERITY);
2700: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2701: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2702: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2703: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2704: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2705: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2706: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2707: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2700: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_HANDLING',P_EXCEPTION_HANDLING);
2701: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2702: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2703: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2704: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2705: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2706: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2707: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2708: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2701: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_ITEM_TYPE',P_WORKFLOW_ITEM_TYPE);
2702: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2703: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2704: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2705: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2706: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2707: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2708: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2709: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2702: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
2703: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2704: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2705: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2706: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2707: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2708: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2709: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2710: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2703: WSH_DEBUG_SV.log(l_module_name,'P_INITIATE_WORKFLOW',P_INITIATE_WORKFLOW);
2704: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2705: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2706: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2707: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2708: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2709: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2710: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2711: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2704: WSH_DEBUG_SV.log(l_module_name,'P_UPDATE_ALLOWED',P_UPDATE_ALLOWED);
2705: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2706: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2707: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2708: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2709: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2710: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2711: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2712: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2705: WSH_DEBUG_SV.log(l_module_name,'P_ENABLED',P_ENABLED);
2706: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2707: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2708: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2709: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2710: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2711: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2712: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2713: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2706: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2707: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2708: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2709: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2710: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2711: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2712: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2713: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2714: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2707: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2708: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2709: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2710: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2711: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2712: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2713: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2714: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2715: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2708: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2709: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2710: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2711: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2712: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2713: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2714: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2715: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2716: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2709: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2710: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2711: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2712: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2713: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2714: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2715: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2716: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2717: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2710: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2711: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2712: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2713: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2714: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2715: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2716: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2717: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2718: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2711: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2712: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2713: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2714: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2715: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2716: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2717: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2718: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2719: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2712: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2713: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2714: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2715: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2716: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2717: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2718: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2719: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2720: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2713: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2714: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2715: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2716: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2717: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2718: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2719: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2720: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2721: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2714: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2715: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2716: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2717: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2718: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2719: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2720: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2721: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2722: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2715: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2716: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2717: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2718: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2719: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2720: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2721: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2722: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2723: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2716: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2717: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2718: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2719: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2720: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2721: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2722: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2723: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2724: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2717: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2718: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2719: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2720: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2721: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2722: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2723: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2724: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2725: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2718: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2719: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2720: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2721: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2722: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2723: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2724: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2725: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2726: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2719: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2720: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2721: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2722: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2723: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2724: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2725: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2726: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2727: WSH_DEBUG_SV.log(l_module_name,'L_CALLER', l_caller); -- 5986504
2720: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2721: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2722: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2723: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2724: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2725: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2726: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2727: WSH_DEBUG_SV.log(l_module_name,'L_CALLER', l_caller); -- 5986504
2728: END IF;
2721: WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2722: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2723: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2724: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2725: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2726: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2727: WSH_DEBUG_SV.log(l_module_name,'L_CALLER', l_caller); -- 5986504
2728: END IF;
2729: --
2722: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
2723: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2724: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2725: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2726: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2727: WSH_DEBUG_SV.log(l_module_name,'L_CALLER', l_caller); -- 5986504
2728: END IF;
2729: --
2730: if (p_exception_name is not NULL ) then
2723: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
2724: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2725: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2726: WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2727: WSH_DEBUG_SV.log(l_module_name,'L_CALLER', l_caller); -- 5986504
2728: END IF;
2729: --
2730: if (p_exception_name is not NULL ) then
2731: if (p_source_lang = userenv('LANG')) then
2818: --
2819: -- Debug Statements
2820: --
2821: IF l_debug_on THEN
2822: WSH_DEBUG_SV.pop(l_module_name);
2823: END IF;
2824: --
2825: exception
2826:
2831: --
2832: -- Debug Statements
2833: --
2834: IF l_debug_on THEN
2835: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_DUP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2836: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_DUP');
2837: END IF;
2838: --
2839: end Load_Row;
2832: -- Debug Statements
2833: --
2834: IF l_debug_on THEN
2835: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_DUP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2836: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_DUP');
2837: END IF;
2838: --
2839: end Load_Row;
2840:
2867: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2868: --
2869: IF l_debug_on IS NULL
2870: THEN
2871: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2872: END IF;
2873: --
2874: IF l_debug_on THEN
2875: WSH_DEBUG_SV.push(l_module_name);
2871: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2872: END IF;
2873: --
2874: IF l_debug_on THEN
2875: WSH_DEBUG_SV.push(l_module_name);
2876: --
2877: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2878: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2879: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2873: --
2874: IF l_debug_on THEN
2875: WSH_DEBUG_SV.push(l_module_name);
2876: --
2877: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2878: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2879: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2880: WSH_DEBUG_SV.log(l_module_name,'P_OWNER',P_OWNER);
2881: END IF;
2874: IF l_debug_on THEN
2875: WSH_DEBUG_SV.push(l_module_name);
2876: --
2877: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2878: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2879: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2880: WSH_DEBUG_SV.log(l_module_name,'P_OWNER',P_OWNER);
2881: END IF;
2882: --
2875: WSH_DEBUG_SV.push(l_module_name);
2876: --
2877: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2878: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2879: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2880: WSH_DEBUG_SV.log(l_module_name,'P_OWNER',P_OWNER);
2881: END IF;
2882: --
2883: if p_exception_name is not NULL then
2876: --
2877: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2878: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
2879: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
2880: WSH_DEBUG_SV.log(l_module_name,'P_OWNER',P_OWNER);
2881: END IF;
2882: --
2883: if p_exception_name is not NULL then
2884: update WSH_EXCEPTION_DEFINITIONS_TL
2895: --
2896: -- Debug Statements
2897: --
2898: IF l_debug_on THEN
2899: WSH_DEBUG_SV.pop(l_module_name);
2900: END IF;
2901: --
2902: end Translate_Row;
2903:
2930: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2931: --
2932: IF l_debug_on IS NULL
2933: THEN
2934: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2935: END IF;
2936: --
2937: IF l_debug_on THEN
2938: WSH_DEBUG_SV.push(l_module_name);
2934: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2935: END IF;
2936: --
2937: IF l_debug_on THEN
2938: WSH_DEBUG_SV.push(l_module_name);
2939: --
2940: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2941: END IF;
2942: --
2936: --
2937: IF l_debug_on THEN
2938: WSH_DEBUG_SV.push(l_module_name);
2939: --
2940: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_DEFINITION_ID',P_EXCEPTION_DEFINITION_ID);
2941: END IF;
2942: --
2943: delete from WSH_EXCEPTION_DEFINITIONS_TL
2944: where EXCEPTION_DEFINITION_ID = p_exception_definition_id ;
2957: --
2958: -- Debug Statements
2959: --
2960: IF l_debug_on THEN
2961: WSH_DEBUG_SV.pop(l_module_name);
2962: END IF;
2963: --
2964: exception
2965:
2971: --
2972: -- Debug Statements
2973: --
2974: IF l_debug_on THEN
2975: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2976: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_NOT_FOUND');
2977: END IF;
2978: --
2979: end delete_xc_def_form ;
2972: -- Debug Statements
2973: --
2974: IF l_debug_on THEN
2975: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_DEF_NOT_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2976: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_DEF_NOT_FOUND');
2977: END IF;
2978: --
2979: end delete_xc_def_form ;
2980:
3000: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3001: --
3002: IF l_debug_on IS NULL
3003: THEN
3004: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3005: END IF;
3006: --
3007: IF l_debug_on THEN
3008: WSH_DEBUG_SV.push(l_module_name);
3004: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3005: END IF;
3006: --
3007: IF l_debug_on THEN
3008: WSH_DEBUG_SV.push(l_module_name);
3009: END IF;
3010: --
3011: delete from WSH_EXCEPTION_DEFINITIONS_TL T
3012: where not exists
3074: --
3075: -- Debug Statements
3076: --
3077: IF l_debug_on THEN
3078: WSH_DEBUG_SV.pop(l_module_name);
3079: END IF;
3080: --
3081: end ADD_LANGUAGE;
3082:
3113: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3114: --
3115: IF l_debug_on IS NULL
3116: THEN
3117: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3118: END IF;
3119: --
3120: IF l_debug_on THEN
3121: WSH_DEBUG_SV.push(l_module_name);
3117: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3118: END IF;
3119: --
3120: IF l_debug_on THEN
3121: WSH_DEBUG_SV.push(l_module_name);
3122: --
3123: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
3124: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
3125: END IF;
3119: --
3120: IF l_debug_on THEN
3121: WSH_DEBUG_SV.push(l_module_name);
3122: --
3123: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
3124: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
3125: END IF;
3126: --
3127: if p_lookup_code is NULL or p_lookup_type is NULL then
3120: IF l_debug_on THEN
3121: WSH_DEBUG_SV.push(l_module_name);
3122: --
3123: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
3124: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
3125: END IF;
3126: --
3127: if p_lookup_code is NULL or p_lookup_type is NULL then
3128: --
3128: --
3129: -- Debug Statements
3130: --
3131: IF l_debug_on THEN
3132: WSH_DEBUG_SV.pop(l_module_name);
3133: END IF;
3134: --
3135: return NULL;
3136: else
3141: --
3142: -- Debug Statements
3143: --
3144: IF l_debug_on THEN
3145: WSH_DEBUG_SV.pop(l_module_name);
3146: END IF;
3147: --
3148: return NULL;
3149: else
3151: --
3152: -- Debug Statements
3153: --
3154: IF l_debug_on THEN
3155: WSH_DEBUG_SV.pop(l_module_name);
3156: END IF;
3157: --
3158: return l_lookup_meaning;
3159: end if;
3339: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3340: --
3341: IF l_debug_on IS NULL
3342: THEN
3343: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3344: END IF;
3345: --
3346: IF l_debug_on THEN
3347: WSH_DEBUG_SV.push(l_module_name);
3343: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3344: END IF;
3345: --
3346: IF l_debug_on THEN
3347: WSH_DEBUG_SV.push(l_module_name);
3348: --
3349: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3350: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3351: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3345: --
3346: IF l_debug_on THEN
3347: WSH_DEBUG_SV.push(l_module_name);
3348: --
3349: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3350: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3351: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3352: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3353: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
3346: IF l_debug_on THEN
3347: WSH_DEBUG_SV.push(l_module_name);
3348: --
3349: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3350: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3351: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3352: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3353: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
3354: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
3347: WSH_DEBUG_SV.push(l_module_name);
3348: --
3349: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3350: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3351: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3352: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3353: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
3354: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
3355: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
3348: --
3349: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3350: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3351: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3352: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3353: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
3354: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
3355: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
3356: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
3349: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
3350: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3351: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3352: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3353: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
3354: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
3355: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
3356: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
3357: WSH_DEBUG_SV.log(l_module_name,'P_LOGGED_AT_LOCATION_ID',P_LOGGED_AT_LOCATION_ID);
3350: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3351: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3352: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3353: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
3354: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
3355: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
3356: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
3357: 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_INVENTORY_ORG_ID',P_INVENTORY_ORG_ID);
3351: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
3352: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3353: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
3354: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
3355: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
3356: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
3357: 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_INVENTORY_ORG_ID',P_INVENTORY_ORG_ID);
3359: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
3352: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
3353: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
3354: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
3355: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
3356: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
3357: 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_INVENTORY_ORG_ID',P_INVENTORY_ORG_ID);
3359: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
3360: WSH_DEBUG_SV.log(l_module_name,'P_SEVERITY',P_SEVERITY);
3353: WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
3354: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
3355: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
3356: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
3357: 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_INVENTORY_ORG_ID',P_INVENTORY_ORG_ID);
3359: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
3360: WSH_DEBUG_SV.log(l_module_name,'P_SEVERITY',P_SEVERITY);
3361: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
3354: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_NAME',P_EXCEPTION_NAME);
3355: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
3356: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
3357: 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_INVENTORY_ORG_ID',P_INVENTORY_ORG_ID);
3359: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
3360: WSH_DEBUG_SV.log(l_module_name,'P_SEVERITY',P_SEVERITY);
3361: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
3362: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_FROM',P_ARRIVAL_DATE_FROM);
3355: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY',P_LOGGING_ENTITY);
3356: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
3357: 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_INVENTORY_ORG_ID',P_INVENTORY_ORG_ID);
3359: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
3360: WSH_DEBUG_SV.log(l_module_name,'P_SEVERITY',P_SEVERITY);
3361: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
3362: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_FROM',P_ARRIVAL_DATE_FROM);
3363: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_TO',P_ARRIVAL_DATE_TO);
3356: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_LOCATION_ID',P_EXCEPTION_LOCATION_ID);
3357: 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_INVENTORY_ORG_ID',P_INVENTORY_ORG_ID);
3359: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
3360: WSH_DEBUG_SV.log(l_module_name,'P_SEVERITY',P_SEVERITY);
3361: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
3362: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_FROM',P_ARRIVAL_DATE_FROM);
3363: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_TO',P_ARRIVAL_DATE_TO);
3364: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_FROM',P_DEPARTURE_DATE_FROM);
3357: 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_INVENTORY_ORG_ID',P_INVENTORY_ORG_ID);
3359: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
3360: WSH_DEBUG_SV.log(l_module_name,'P_SEVERITY',P_SEVERITY);
3361: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
3362: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_FROM',P_ARRIVAL_DATE_FROM);
3363: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_TO',P_ARRIVAL_DATE_TO);
3364: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_FROM',P_DEPARTURE_DATE_FROM);
3365: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_TO',P_DEPARTURE_DATE_TO);
3358: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ORG_ID',P_INVENTORY_ORG_ID);
3359: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
3360: WSH_DEBUG_SV.log(l_module_name,'P_SEVERITY',P_SEVERITY);
3361: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
3362: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_FROM',P_ARRIVAL_DATE_FROM);
3363: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_TO',P_ARRIVAL_DATE_TO);
3364: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_FROM',P_DEPARTURE_DATE_FROM);
3365: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_TO',P_DEPARTURE_DATE_TO);
3366: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_FROM',P_CREATION_DATE_FROM);
3359: WSH_DEBUG_SV.log(l_module_name,'P_EXCEPTION_TYPE',P_EXCEPTION_TYPE);
3360: WSH_DEBUG_SV.log(l_module_name,'P_SEVERITY',P_SEVERITY);
3361: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
3362: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_FROM',P_ARRIVAL_DATE_FROM);
3363: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_TO',P_ARRIVAL_DATE_TO);
3364: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_FROM',P_DEPARTURE_DATE_FROM);
3365: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_TO',P_DEPARTURE_DATE_TO);
3366: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_FROM',P_CREATION_DATE_FROM);
3367: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_TO',P_CREATION_DATE_TO);
3360: WSH_DEBUG_SV.log(l_module_name,'P_SEVERITY',P_SEVERITY);
3361: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
3362: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_FROM',P_ARRIVAL_DATE_FROM);
3363: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_TO',P_ARRIVAL_DATE_TO);
3364: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_FROM',P_DEPARTURE_DATE_FROM);
3365: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_TO',P_DEPARTURE_DATE_TO);
3366: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_FROM',P_CREATION_DATE_FROM);
3367: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_TO',P_CREATION_DATE_TO);
3368: WSH_DEBUG_SV.log(l_module_name,'P_DATA_OLDER_NO_OF_DAYS',P_DATA_OLDER_NO_OF_DAYS);
3361: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
3362: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_FROM',P_ARRIVAL_DATE_FROM);
3363: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_TO',P_ARRIVAL_DATE_TO);
3364: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_FROM',P_DEPARTURE_DATE_FROM);
3365: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_TO',P_DEPARTURE_DATE_TO);
3366: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_FROM',P_CREATION_DATE_FROM);
3367: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_TO',P_CREATION_DATE_TO);
3368: 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_DELIVERY_ID',P_DELIVERY_ID);
3362: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_FROM',P_ARRIVAL_DATE_FROM);
3363: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_TO',P_ARRIVAL_DATE_TO);
3364: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_FROM',P_DEPARTURE_DATE_FROM);
3365: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_TO',P_DEPARTURE_DATE_TO);
3366: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_FROM',P_CREATION_DATE_FROM);
3367: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_TO',P_CREATION_DATE_TO);
3368: 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_DELIVERY_ID',P_DELIVERY_ID);
3370: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
3363: WSH_DEBUG_SV.log(l_module_name,'P_ARRIVAL_DATE_TO',P_ARRIVAL_DATE_TO);
3364: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_FROM',P_DEPARTURE_DATE_FROM);
3365: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_TO',P_DEPARTURE_DATE_TO);
3366: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_FROM',P_CREATION_DATE_FROM);
3367: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_TO',P_CREATION_DATE_TO);
3368: 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_DELIVERY_ID',P_DELIVERY_ID);
3370: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
3371: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
3364: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_FROM',P_DEPARTURE_DATE_FROM);
3365: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_TO',P_DEPARTURE_DATE_TO);
3366: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_FROM',P_CREATION_DATE_FROM);
3367: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_TO',P_CREATION_DATE_TO);
3368: 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_DELIVERY_ID',P_DELIVERY_ID);
3370: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
3371: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
3372: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
3365: WSH_DEBUG_SV.log(l_module_name,'P_DEPARTURE_DATE_TO',P_DEPARTURE_DATE_TO);
3366: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_FROM',P_CREATION_DATE_FROM);
3367: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_TO',P_CREATION_DATE_TO);
3368: 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_DELIVERY_ID',P_DELIVERY_ID);
3370: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
3371: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
3372: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
3373: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
3366: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_FROM',P_CREATION_DATE_FROM);
3367: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_TO',P_CREATION_DATE_TO);
3368: 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_DELIVERY_ID',P_DELIVERY_ID);
3370: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
3371: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
3372: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
3373: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
3374: END IF;
3367: WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE_TO',P_CREATION_DATE_TO);
3368: 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_DELIVERY_ID',P_DELIVERY_ID);
3370: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
3371: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
3372: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
3373: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
3374: END IF;
3375: --
3368: 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_DELIVERY_ID',P_DELIVERY_ID);
3370: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
3371: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
3372: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
3373: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
3374: END IF;
3375: --
3376: SAVEPOINT WSH_XC_UTIL;
3369: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
3370: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
3371: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_STOP_ID',P_TRIP_STOP_ID);
3372: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
3373: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
3374: END IF;
3375: --
3376: SAVEPOINT WSH_XC_UTIL;
3377: -- Standard call to check for call compatibility.
3793: --
3794: -- Debug Statements
3795: --
3796: IF l_debug_on THEN
3797: WSH_DEBUG_SV.log(l_module_name,'Count',x_no_of_recs_purged);
3798: WSH_DEBUG_SV.pop(l_module_name);
3799: END IF;
3800: --
3801: EXCEPTION
3794: -- Debug Statements
3795: --
3796: IF l_debug_on THEN
3797: WSH_DEBUG_SV.log(l_module_name,'Count',x_no_of_recs_purged);
3798: WSH_DEBUG_SV.pop(l_module_name);
3799: END IF;
3800: --
3801: EXCEPTION
3802: WHEN WSH_PURGE_FAILED THEN
3812: --
3813: -- Debug Statements
3814: --
3815: IF l_debug_on THEN
3816: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_PURGE_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3817: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_PURGE_FAILED');
3818: END IF;
3819: --
3820: WHEN FND_API.G_EXC_ERROR THEN
3813: -- Debug Statements
3814: --
3815: IF l_debug_on THEN
3816: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_PURGE_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3817: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_PURGE_FAILED');
3818: END IF;
3819: --
3820: WHEN FND_API.G_EXC_ERROR THEN
3821: ROLLBACK TO WSH_XC_UTIL;
3830: --
3831: -- Debug Statements
3832: --
3833: IF l_debug_on THEN
3834: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3835: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3836: END IF;
3837: --
3838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3831: -- Debug Statements
3832: --
3833: IF l_debug_on THEN
3834: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3835: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3836: END IF;
3837: --
3838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3839: ROLLBACK TO WSH_XC_UTIL;
3848: --
3849: -- Debug Statements
3850: --
3851: IF l_debug_on THEN
3852: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3853: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3854: END IF;
3855: --
3856: WHEN OTHERS THEN
3849: -- Debug Statements
3850: --
3851: IF l_debug_on THEN
3852: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3853: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3854: END IF;
3855: --
3856: WHEN OTHERS THEN
3857: ROLLBACK TO WSH_XC_UTIL;
3866: --
3867: -- Debug Statements
3868: --
3869: IF l_debug_on THEN
3870: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3871: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3872: END IF;
3873: --
3874: end;
3867: -- Debug Statements
3868: --
3869: IF l_debug_on THEN
3870: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3871: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3872: END IF;
3873: --
3874: end;
3875:
4033: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4034: --
4035: IF l_debug_on IS NULL
4036: THEN
4037: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4038: END IF;
4039: --
4040: --
4041: -- Debug Statements
4040: --
4041: -- Debug Statements
4042: --
4043: IF l_debug_on THEN
4044: WSH_DEBUG_SV.push(l_module_name);
4045: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4046: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4047: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4048: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4041: -- Debug Statements
4042: --
4043: IF l_debug_on THEN
4044: WSH_DEBUG_SV.push(l_module_name);
4045: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4046: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4047: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4048: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4049: WSH_DEBUG_SV.log(l_module_name,'P_CONSIDER_CONTENT',P_CONSIDER_CONTENT);
4042: --
4043: IF l_debug_on THEN
4044: WSH_DEBUG_SV.push(l_module_name);
4045: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4046: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4047: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4048: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4049: WSH_DEBUG_SV.log(l_module_name,'P_CONSIDER_CONTENT',P_CONSIDER_CONTENT);
4050: END IF;
4043: IF l_debug_on THEN
4044: WSH_DEBUG_SV.push(l_module_name);
4045: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4046: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4047: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4048: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4049: WSH_DEBUG_SV.log(l_module_name,'P_CONSIDER_CONTENT',P_CONSIDER_CONTENT);
4050: END IF;
4051:
4044: WSH_DEBUG_SV.push(l_module_name);
4045: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4046: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4047: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4048: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4049: WSH_DEBUG_SV.log(l_module_name,'P_CONSIDER_CONTENT',P_CONSIDER_CONTENT);
4050: END IF;
4051:
4052: IF NOT FND_API.compatible_api_call (
4045: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4046: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4047: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4048: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4049: WSH_DEBUG_SV.log(l_module_name,'P_CONSIDER_CONTENT',P_CONSIDER_CONTENT);
4050: END IF;
4051:
4052: IF NOT FND_API.compatible_api_call (
4053: l_api_version,
4097: p_caller => p_caller||c_trip
4098: );
4099: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4100: IF l_debug_on THEN
4101: WSH_DEBUG_SV.logmsg('Check Exception failed for Stop :'||stop_rec.stop_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4102: END IF;
4103: RAISE WSH_CHECK_EXCEPTIONS_FAILED;
4104: END IF;
4105:
4136: x_exceptions_tab => x_exceptions_tab
4137: );
4138: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4139: IF l_debug_on THEN
4140: WSH_DEBUG_SV.logmsg('Check Exception failed for Delivery :'||del_rec.delivery_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4141: END IF;
4142: RAISE WSH_CHECK_EXCEPTIONS_FAILED;
4143: END IF;
4144:
4166: p_caller => p_caller
4167: );
4168: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4169: IF l_debug_on THEN
4170: WSH_DEBUG_SV.logmsg('Check Exception failed for Stop :'||stop_rec.stop_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4171: END IF;
4172: RAISE WSH_CHECK_EXCEPTIONS_FAILED;
4173: END IF;
4174: IF l_exceptions_tab IS NOT NULL AND l_exceptions_tab.COUNT>0 THEN
4229: x_exceptions_tab => x_exceptions_tab
4230: );
4231: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4232: IF l_debug_on THEN
4233: WSH_DEBUG_SV.logmsg('Check Exception failed for Detail :'||detail_rec.delivery_detail_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4234: END IF;
4235: RAISE WSH_CHECK_EXCEPTIONS_FAILED;
4236: END IF;
4237:
4291: x_exceptions_tab => x_exceptions_tab
4292: );
4293: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4294: IF l_debug_on THEN
4295: WSH_DEBUG_SV.logmsg('Check Exception failed for Detail :'||detail_rec.delivery_detail_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4296: END IF;
4297: RAISE WSH_CHECK_EXCEPTIONS_FAILED;
4298: END IF;
4299:
4308: --
4309: -- Debug Statements
4310: --
4311: IF l_debug_on THEN
4312: WSH_DEBUG_SV.pop(l_module_name);
4313: END IF;
4314: --
4315:
4316: EXCEPTION
4325: --
4326: -- Debug Statements
4327: --
4328: IF l_debug_on THEN
4329: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CHECK_EXCEPTIONS_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4330: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CHECK_EXCEPTIONS_FAILED');
4331: END IF;
4332: --
4333:
4326: -- Debug Statements
4327: --
4328: IF l_debug_on THEN
4329: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CHECK_EXCEPTIONS_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4330: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CHECK_EXCEPTIONS_FAILED');
4331: END IF;
4332: --
4333:
4334: WHEN WSH_INVALID_LOGGING_ENTITY THEN
4343: --
4344: -- Debug Statements
4345: --
4346: IF l_debug_on THEN
4347: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_LOGGING_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4348: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_LOGGING_ENTITY');
4349: END IF;
4350: --
4351:
4344: -- Debug Statements
4345: --
4346: IF l_debug_on THEN
4347: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_XC_INVALID_LOGGING_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4348: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_XC_INVALID_LOGGING_ENTITY');
4349: END IF;
4350: --
4351:
4352: WHEN others THEN
4378: --
4379: -- Debug Statements
4380: --
4381: IF l_debug_on THEN
4382: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4383: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4384: END IF;
4385: --
4386:
4379: -- Debug Statements
4380: --
4381: IF l_debug_on THEN
4382: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4383: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4384: END IF;
4385: --
4386:
4387: END Check_Exceptions;
4490: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4491: --
4492: IF l_debug_on IS NULL
4493: THEN
4494: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4495: END IF;
4496: --
4497: --
4498: -- Debug Statements
4497: --
4498: -- Debug Statements
4499: --
4500: IF l_debug_on THEN
4501: WSH_DEBUG_SV.push(l_module_name);
4502: --
4503: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4504: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4505: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4499: --
4500: IF l_debug_on THEN
4501: WSH_DEBUG_SV.push(l_module_name);
4502: --
4503: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4504: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4505: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4506: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4507: END IF;
4500: IF l_debug_on THEN
4501: WSH_DEBUG_SV.push(l_module_name);
4502: --
4503: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4504: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4505: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4506: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4507: END IF;
4508:
4501: WSH_DEBUG_SV.push(l_module_name);
4502: --
4503: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4504: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4505: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4506: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4507: END IF;
4508:
4509: IF NOT FND_API.compatible_api_call (
4502: --
4503: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
4504: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
4505: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_NAME',P_LOGGING_ENTITY_NAME);
4506: WSH_DEBUG_SV.log(l_module_name,'P_LOGGING_ENTITY_ID',P_LOGGING_ENTITY_ID);
4507: END IF;
4508:
4509: IF NOT FND_API.compatible_api_call (
4510: l_api_version,
4532: p_action => C_ACTION_SEMICLOSED
4533: );
4534: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4535: IF l_debug_on THEN
4536: WSH_DEBUG_SV.logmsg('Purge failed for Trip :'||p_logging_entity_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4537: END IF;
4538: RAISE WSH_PURGE_FAILED;
4539: END IF;
4540:
4552: p_caller => p_caller||c_trip
4553: );
4554: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4555: IF l_debug_on THEN
4556: WSH_DEBUG_SV.logmsg('Close_Exception failed for Stop :'||stop_rec.stop_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4557: END IF;
4558: RAISE WSH_CLOSE_EXCEPTIONS_FAILED;
4559: END IF;
4560: END LOOP;
4562:
4563: ELSIF (p_logging_entity_name = 'STOP') THEN
4564:
4565: IF l_debug_on THEN
4566: WSH_DEBUG_SV.logmsg('Calling Purge for Stop '||p_logging_entity_id ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4567: END IF;
4568: WSH_XC_UTIL.Purge (
4569: p_api_version => p_api_version,
4570: x_return_status => x_return_status,
4575: p_action => C_ACTION_SEMICLOSED
4576: );
4577: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4578: IF l_debug_on THEN
4579: WSH_DEBUG_SV.logmsg('Purge failed for Stop :'||p_logging_entity_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4580: END IF;
4581: RAISE WSH_PURGE_FAILED;
4582: END IF;
4583:
4594: p_consider_content => p_consider_content
4595: );
4596: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4597: IF l_debug_on THEN
4598: WSH_DEBUG_SV.logmsg('Close_Exception failed for Delivery :'||del_rec.delivery_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4599: END IF;
4600: RAISE WSH_CLOSE_EXCEPTIONS_FAILED;
4601: END IF;
4602: END LOOP;
4620: p_caller => p_caller
4621: );
4622: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4623: IF l_debug_on THEN
4624: WSH_DEBUG_SV.logmsg('Close_Exception failed for Stop :'||stop_rec.stop_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4625: END IF;
4626: RAISE WSH_CLOSE_EXCEPTIONS_FAILED;
4627: END IF;
4628: END LOOP;
4639: p_action => C_ACTION_SEMICLOSED
4640: );
4641: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4642: IF l_debug_on THEN
4643: WSH_DEBUG_SV.logmsg('Purge failed for Delivery :'||p_logging_entity_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4644: END IF;
4645: RAISE WSH_PURGE_FAILED;
4646: END IF;
4647:
4656: p_action => C_ACTION_SEMICLOSED
4657: );
4658: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4659: IF l_debug_on THEN
4660: WSH_DEBUG_SV.logmsg('Purge failed for Detail/Container :'||p_logging_entity_id,WSH_DEBUG_SV.C_EXCEP_LEVEL);
4661: END IF;
4662: RAISE WSH_PURGE_FAILED;
4663: END IF;
4664:
4671: --
4672: -- Debug Statements
4673: --
4674: IF l_debug_on THEN
4675: WSH_DEBUG_SV.pop(l_module_name);
4676: END IF;
4677: --
4678:
4679: EXCEPTION
4689: --
4690: -- Debug Statements
4691: --
4692: IF l_debug_on THEN
4693: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CLOSE_EXCEPTIONS_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4694: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CLOSE_EXCEPTIONS_FAILED');
4695: END IF;
4696: --
4697:
4690: -- Debug Statements
4691: --
4692: IF l_debug_on THEN
4693: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CLOSE_EXCEPTIONS_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4694: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CLOSE_EXCEPTIONS_FAILED');
4695: END IF;
4696: --
4697:
4698: WHEN WSH_PURGE_FAILED THEN
4707: --
4708: -- Debug Statements
4709: --
4710: IF l_debug_on THEN
4711: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_PURGE_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4712: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_PURGE_FAILED');
4713: END IF;
4714: --
4715:
4708: -- Debug Statements
4709: --
4710: IF l_debug_on THEN
4711: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_PURGE_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4712: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_PURGE_FAILED');
4713: END IF;
4714: --
4715:
4716: WHEN WSH_INVALID_LOGGING_ENTITY THEN
4726: --
4727: -- Debug Statements
4728: --
4729: IF l_debug_on THEN
4730: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_LOGGING_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4731: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_LOGGING_ENTITY');
4732: END IF;
4733: --
4734:
4727: -- Debug Statements
4728: --
4729: IF l_debug_on THEN
4730: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_LOGGING_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4731: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_LOGGING_ENTITY');
4732: END IF;
4733: --
4734:
4735: WHEN others THEN
4739: --
4740: -- Debug Statements
4741: --
4742: IF l_debug_on THEN
4743: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4744: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4745: END IF;
4746: --
4747:
4740: -- Debug Statements
4741: --
4742: IF l_debug_on THEN
4743: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4744: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4745: END IF;
4746: --
4747:
4748: END Close_Exceptions;
4780: --
4781: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4782: --
4783: IF l_debug_on IS NULL THEN
4784: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4785: END IF;
4786: --
4787: IF l_debug_on THEN
4788: WSH_DEBUG_SV.push(l_module_name);
4784: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4785: END IF;
4786: --
4787: IF l_debug_on THEN
4788: WSH_DEBUG_SV.push(l_module_name);
4789: WSH_DEBUG_SV.log(l_module_name, 'delivery id', p_delivery_id);
4790: WSH_DEBUG_SV.log(l_module_name, 'number of exceptions to close', p_exceptions_to_close_tab.COUNT);
4791: END IF;
4792: --
4785: END IF;
4786: --
4787: IF l_debug_on THEN
4788: WSH_DEBUG_SV.push(l_module_name);
4789: WSH_DEBUG_SV.log(l_module_name, 'delivery id', p_delivery_id);
4790: WSH_DEBUG_SV.log(l_module_name, 'number of exceptions to close', p_exceptions_to_close_tab.COUNT);
4791: END IF;
4792: --
4793: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4786: --
4787: IF l_debug_on THEN
4788: WSH_DEBUG_SV.push(l_module_name);
4789: WSH_DEBUG_SV.log(l_module_name, 'delivery id', p_delivery_id);
4790: WSH_DEBUG_SV.log(l_module_name, 'number of exceptions to close', p_exceptions_to_close_tab.COUNT);
4791: END IF;
4792: --
4793: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4794: l_exception_name := NULL;
4806: l_exception_name := p_exceptions_to_close_tab(i);
4807:
4808: -- call purge with action 'CLOSED'
4809: IF l_debug_on THEN
4810: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.PURGE',WSH_DEBUG_SV.C_PROC_LEVEL);
4811: END IF;
4812:
4813: WSH_XC_UTIL.purge (
4814: p_api_version => 1.0,
4822: p_action => 'CLOSED'
4823: );
4824:
4825: IF l_debug_on THEN
4826: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.purge: ' || l_return_status);
4827: WSH_DEBUG_SV.log(l_module_name, 'number of exceptions purged', l_count);
4828: END IF;
4829:
4830: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
4823: );
4824:
4825: IF l_debug_on THEN
4826: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.purge: ' || l_return_status);
4827: WSH_DEBUG_SV.log(l_module_name, 'number of exceptions purged', l_count);
4828: END IF;
4829:
4830: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
4831: x_return_status := l_return_status;
4844:
4845: -- Debug Statements
4846: --
4847: IF l_debug_on THEN
4848: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
4849: WSH_DEBUG_SV.pop(l_module_name);
4850: END IF;
4851: --
4852:
4845: -- Debug Statements
4846: --
4847: IF l_debug_on THEN
4848: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
4849: WSH_DEBUG_SV.pop(l_module_name);
4850: END IF;
4851: --
4852:
4853: EXCEPTION
4855: WHEN OTHERS THEN
4856: wsh_util_core.default_handler('WSH_XC_UTIL.CLOSE_OTM_EXCEPTION', l_module_name);
4857: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4858: IF l_debug_on THEN
4859: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected error has occured. '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4860: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4861: END IF;
4862:
4863: END CLOSE_OTM_EXCEPTION;
4856: wsh_util_core.default_handler('WSH_XC_UTIL.CLOSE_OTM_EXCEPTION', l_module_name);
4857: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4858: IF l_debug_on THEN
4859: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected error has occured. '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4860: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4861: END IF;
4862:
4863: END CLOSE_OTM_EXCEPTION;
4864:
4906: --
4907: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4908: --
4909: IF l_debug_on IS NULL THEN
4910: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4911: END IF;
4912: --
4913: IF l_debug_on THEN
4914: WSH_DEBUG_SV.push(l_module_name);
4910: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4911: END IF;
4912: --
4913: IF l_debug_on THEN
4914: WSH_DEBUG_SV.push(l_module_name);
4915: WSH_DEBUG_SV.log(l_module_name, 'delivery record count', p_delivery_info_tab.COUNT);
4916: WSH_DEBUG_SV.log(l_module_name, 'interface flag count', p_new_interface_flag_tab.COUNT);
4917: END IF;
4918:
4911: END IF;
4912: --
4913: IF l_debug_on THEN
4914: WSH_DEBUG_SV.push(l_module_name);
4915: WSH_DEBUG_SV.log(l_module_name, 'delivery record count', p_delivery_info_tab.COUNT);
4916: WSH_DEBUG_SV.log(l_module_name, 'interface flag count', p_new_interface_flag_tab.COUNT);
4917: END IF;
4918:
4919: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4912: --
4913: IF l_debug_on THEN
4914: WSH_DEBUG_SV.push(l_module_name);
4915: WSH_DEBUG_SV.log(l_module_name, 'delivery record count', p_delivery_info_tab.COUNT);
4916: WSH_DEBUG_SV.log(l_module_name, 'interface flag count', p_new_interface_flag_tab.COUNT);
4917: END IF;
4918:
4919: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4920:
4927: i := 0;
4928:
4929: IF (p_delivery_info_tab.COUNT = 0) THEN
4930: IF l_debug_on THEN
4931: WSH_DEBUG_SV.logmsg(l_module_name, 'no delivery to log exceptions');
4932: END IF;
4933: END IF;
4934:
4935: i := p_delivery_info_tab.FIRST;
4953: l_new_interface_flag := p_new_interface_flag_tab(i);
4954: END IF;
4955:
4956: IF l_debug_on THEN
4957: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_id' , p_delivery_info_tab(i).delivery_id);
4958: WSH_DEBUG_SV.log(l_module_name, 'l_new_interface_flag', l_new_interface_flag);
4959: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_info_tab(i).tms_interface_flag', p_delivery_info_tab(i).tms_interface_flag);
4960: IF p_new_interface_flag_tab.COUNT > 0 THEN
4961: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_info_tab(i).tms_interface_flag', p_new_interface_flag_tab(i));
4954: END IF;
4955:
4956: IF l_debug_on THEN
4957: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_id' , p_delivery_info_tab(i).delivery_id);
4958: WSH_DEBUG_SV.log(l_module_name, 'l_new_interface_flag', l_new_interface_flag);
4959: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_info_tab(i).tms_interface_flag', p_delivery_info_tab(i).tms_interface_flag);
4960: IF p_new_interface_flag_tab.COUNT > 0 THEN
4961: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_info_tab(i).tms_interface_flag', p_new_interface_flag_tab(i));
4962: END IF;
4955:
4956: IF l_debug_on THEN
4957: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_id' , p_delivery_info_tab(i).delivery_id);
4958: WSH_DEBUG_SV.log(l_module_name, 'l_new_interface_flag', l_new_interface_flag);
4959: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_info_tab(i).tms_interface_flag', p_delivery_info_tab(i).tms_interface_flag);
4960: IF p_new_interface_flag_tab.COUNT > 0 THEN
4961: 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: END IF;
4957: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_id' , p_delivery_info_tab(i).delivery_id);
4958: WSH_DEBUG_SV.log(l_module_name, 'l_new_interface_flag', l_new_interface_flag);
4959: WSH_DEBUG_SV.log(l_module_name, 'p_delivery_info_tab(i).tms_interface_flag', p_delivery_info_tab(i).tms_interface_flag);
4960: IF p_new_interface_flag_tab.COUNT > 0 THEN
4961: 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: END IF;
4964:
4965: --log and close exceptions only if new status is different and not IN Process status
4993:
4994: IF l_exceptions_to_close_tab.COUNT > 0 THEN
4995:
4996: IF l_debug_on THEN
4997: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.CLOSE_OTM_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
4998: END IF;
4999:
5000: WSH_XC_UTIL.close_otm_exception(
5001: p_delivery_id => p_delivery_info_tab(i).delivery_id,
5003: x_return_status => l_return_status
5004: );
5005:
5006: IF l_debug_on THEN
5007: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.close_otm_exception: ' || l_return_status);
5008: END IF;
5009:
5010: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5011: l_num_error := l_num_error + 1;
5029: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', p_delivery_info_tab(i).name);
5030: l_exception_message := FND_MESSAGE.GET;
5031:
5032: IF l_debug_on THEN
5033: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
5034: END IF;
5035:
5036: WSH_XC_UTIL.log_exception(
5037: p_api_version => 1.0,
5048: p_message => l_exception_message);
5049:
5050:
5051: IF l_debug_on THEN
5052: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.log_exception: ' || l_return_status);
5053: END IF;
5054:
5055: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5056: l_num_error := l_num_error + 1;
5102:
5103: l_exception_message := FND_MESSAGE.GET;
5104:
5105: IF l_debug_on THEN
5106: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
5107: END IF;
5108:
5109: WSH_XC_UTIL.log_exception(
5110: p_api_version => 1.0,
5120: p_delivery_id => p_delivery_info_tab(i).delivery_id,
5121: p_message => l_exception_message);
5122:
5123: IF l_debug_on THEN
5124: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.log_exception: ' || l_return_status);
5125: END IF;
5126:
5127: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5128: l_num_error := l_num_error + 1;
5149: --
5150: -- Debug Statements
5151: --
5152: IF l_debug_on THEN
5153: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5154: WSH_DEBUG_SV.pop(l_module_name);
5155: END IF;
5156: --
5157:
5150: -- Debug Statements
5151: --
5152: IF l_debug_on THEN
5153: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5154: WSH_DEBUG_SV.pop(l_module_name);
5155: END IF;
5156: --
5157:
5158: EXCEPTION
5160: wsh_util_core.default_handler('WSH_XC_UTIL.LOG_OTM_EXCEPTION', l_module_name);
5161: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5162:
5163: IF l_debug_on THEN
5164: WSH_DEBUG_SV.logmsg(l_module_name,
5165: 'Unexpected error has occured. Oracle error message is '|| SQLERRM,
5166: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5167: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5168: END IF;
5162:
5163: IF l_debug_on THEN
5164: WSH_DEBUG_SV.logmsg(l_module_name,
5165: 'Unexpected error has occured. Oracle error message is '|| SQLERRM,
5166: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5167: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5168: END IF;
5169:
5170: END LOG_OTM_EXCEPTION;
5163: IF l_debug_on THEN
5164: WSH_DEBUG_SV.logmsg(l_module_name,
5165: 'Unexpected error has occured. Oracle error message is '|| SQLERRM,
5166: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5167: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5168: END IF;
5169:
5170: END LOG_OTM_EXCEPTION;
5171:
5214:
5215: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5216:
5217: IF l_debug_on IS NULL THEN
5218: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5219: END IF;
5220: --
5221: IF l_debug_on THEN
5222: WSH_DEBUG_SV.push(l_module_name);
5218: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5219: END IF;
5220: --
5221: IF l_debug_on THEN
5222: WSH_DEBUG_SV.push(l_module_name);
5223: WSH_DEBUG_SV.log(l_module_name, 'delivery id', p_delivery_id);
5224: END IF;
5225:
5226: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5219: END IF;
5220: --
5221: IF l_debug_on THEN
5222: WSH_DEBUG_SV.push(l_module_name);
5223: WSH_DEBUG_SV.log(l_module_name, 'delivery id', p_delivery_id);
5224: END IF;
5225:
5226: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5227:
5230: l_exception_name := NULL;
5231:
5232: IF (p_delivery_id IS NULL) THEN
5233: IF l_debug_on THEN
5234: WSH_DEBUG_SV.logmsg(l_module_name, 'delivery id is NULL');
5235: WSH_DEBUG_SV.pop(l_module_name);
5236: END IF;
5237: x_severity := l_severity;
5238: x_exception_name := l_exception_name;
5231:
5232: IF (p_delivery_id IS NULL) THEN
5233: IF l_debug_on THEN
5234: WSH_DEBUG_SV.logmsg(l_module_name, 'delivery id is NULL');
5235: WSH_DEBUG_SV.pop(l_module_name);
5236: END IF;
5237: x_severity := l_severity;
5238: x_exception_name := l_exception_name;
5239: RETURN;
5258: x_severity := l_severity;
5259: x_exception_name := l_exception_name;
5260:
5261: IF l_debug_on THEN
5262: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_severity);
5263: WSH_DEBUG_SV.log(l_module_name, 'x_exception_name', x_exception_name);
5264: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5265: WSH_DEBUG_SV.pop(l_module_name);
5266: END IF;
5259: x_exception_name := l_exception_name;
5260:
5261: IF l_debug_on THEN
5262: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_severity);
5263: WSH_DEBUG_SV.log(l_module_name, 'x_exception_name', x_exception_name);
5264: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5265: WSH_DEBUG_SV.pop(l_module_name);
5266: END IF;
5267:
5260:
5261: IF l_debug_on THEN
5262: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_severity);
5263: WSH_DEBUG_SV.log(l_module_name, 'x_exception_name', x_exception_name);
5264: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5265: WSH_DEBUG_SV.pop(l_module_name);
5266: END IF;
5267:
5268: EXCEPTION
5261: IF l_debug_on THEN
5262: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_severity);
5263: WSH_DEBUG_SV.log(l_module_name, 'x_exception_name', x_exception_name);
5264: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5265: WSH_DEBUG_SV.pop(l_module_name);
5266: END IF;
5267:
5268: EXCEPTION
5269: WHEN OTHERS THEN
5273: IF c_get_delivery_otm_exceptions%ISOPEN THEN
5274: CLOSE c_get_delivery_otm_exceptions;
5275: END IF;
5276: IF l_debug_on THEN
5277: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5278: WSH_DEBUG_SV.pop(l_module_name);
5279: END IF;
5280:
5281: END GET_OTM_DELIVERY_EXCEPTION;
5274: CLOSE c_get_delivery_otm_exceptions;
5275: END IF;
5276: IF l_debug_on THEN
5277: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5278: WSH_DEBUG_SV.pop(l_module_name);
5279: END IF;
5280:
5281: END GET_OTM_DELIVERY_EXCEPTION;
5282: --END OTM R12