52: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
53: --
54: IF l_debug_on IS NULL
55: THEN
56: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
57: END IF;
58: --
59: IF l_debug_on THEN
60: WSH_DEBUG_SV.push(l_module_name);
56: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
57: END IF;
58: --
59: IF l_debug_on THEN
60: WSH_DEBUG_SV.push(l_module_name);
61: --
62: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
63: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
64: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_TYPE',p_cal_asg_info.CALENDAR_TYPE);
58: --
59: IF l_debug_on THEN
60: WSH_DEBUG_SV.push(l_module_name);
61: --
62: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
63: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
64: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_TYPE',p_cal_asg_info.CALENDAR_TYPE);
65: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ASSOCIATION_TYPE',p_cal_asg_info.ASSOCIATION_TYPE);
66: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
59: IF l_debug_on THEN
60: WSH_DEBUG_SV.push(l_module_name);
61: --
62: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
63: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
64: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_TYPE',p_cal_asg_info.CALENDAR_TYPE);
65: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ASSOCIATION_TYPE',p_cal_asg_info.ASSOCIATION_TYPE);
66: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
67: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
60: WSH_DEBUG_SV.push(l_module_name);
61: --
62: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
63: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
64: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_TYPE',p_cal_asg_info.CALENDAR_TYPE);
65: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ASSOCIATION_TYPE',p_cal_asg_info.ASSOCIATION_TYPE);
66: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
67: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
68: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ORGANIZATION_ID',p_cal_asg_info.ORGANIZATION_ID);
61: --
62: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
63: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
64: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_TYPE',p_cal_asg_info.CALENDAR_TYPE);
65: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ASSOCIATION_TYPE',p_cal_asg_info.ASSOCIATION_TYPE);
66: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
67: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
68: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ORGANIZATION_ID',p_cal_asg_info.ORGANIZATION_ID);
69: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.LOCATION_ID',p_cal_asg_info.LOCATION_ID);
62: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
63: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
64: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_TYPE',p_cal_asg_info.CALENDAR_TYPE);
65: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ASSOCIATION_TYPE',p_cal_asg_info.ASSOCIATION_TYPE);
66: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
67: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
68: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ORGANIZATION_ID',p_cal_asg_info.ORGANIZATION_ID);
69: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.LOCATION_ID',p_cal_asg_info.LOCATION_ID);
70: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.VENDOR_ID',p_cal_asg_info.VENDOR_ID);
63: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
64: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_TYPE',p_cal_asg_info.CALENDAR_TYPE);
65: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ASSOCIATION_TYPE',p_cal_asg_info.ASSOCIATION_TYPE);
66: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
67: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
68: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ORGANIZATION_ID',p_cal_asg_info.ORGANIZATION_ID);
69: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.LOCATION_ID',p_cal_asg_info.LOCATION_ID);
70: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.VENDOR_ID',p_cal_asg_info.VENDOR_ID);
71: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.VENDOR_SITE_ID',p_cal_asg_info.VENDOR_SITE_ID);
64: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_TYPE',p_cal_asg_info.CALENDAR_TYPE);
65: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ASSOCIATION_TYPE',p_cal_asg_info.ASSOCIATION_TYPE);
66: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
67: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
68: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ORGANIZATION_ID',p_cal_asg_info.ORGANIZATION_ID);
69: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.LOCATION_ID',p_cal_asg_info.LOCATION_ID);
70: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.VENDOR_ID',p_cal_asg_info.VENDOR_ID);
71: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.VENDOR_SITE_ID',p_cal_asg_info.VENDOR_SITE_ID);
72: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CUSTOMER_ID',p_cal_asg_info.CUSTOMER_ID);
65: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ASSOCIATION_TYPE',p_cal_asg_info.ASSOCIATION_TYPE);
66: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
67: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
68: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ORGANIZATION_ID',p_cal_asg_info.ORGANIZATION_ID);
69: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.LOCATION_ID',p_cal_asg_info.LOCATION_ID);
70: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.VENDOR_ID',p_cal_asg_info.VENDOR_ID);
71: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.VENDOR_SITE_ID',p_cal_asg_info.VENDOR_SITE_ID);
72: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CUSTOMER_ID',p_cal_asg_info.CUSTOMER_ID);
73: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CUSTOMER_SITE_USE_ID',p_cal_asg_info.CUSTOMER_SITE_USE_ID);
66: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
67: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
68: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ORGANIZATION_ID',p_cal_asg_info.ORGANIZATION_ID);
69: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.LOCATION_ID',p_cal_asg_info.LOCATION_ID);
70: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.VENDOR_ID',p_cal_asg_info.VENDOR_ID);
71: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.VENDOR_SITE_ID',p_cal_asg_info.VENDOR_SITE_ID);
72: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CUSTOMER_ID',p_cal_asg_info.CUSTOMER_ID);
73: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CUSTOMER_SITE_USE_ID',p_cal_asg_info.CUSTOMER_SITE_USE_ID);
74: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.REIGHT_CODE',p_cal_asg_info.FREIGHT_CODE);
67: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
68: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ORGANIZATION_ID',p_cal_asg_info.ORGANIZATION_ID);
69: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.LOCATION_ID',p_cal_asg_info.LOCATION_ID);
70: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.VENDOR_ID',p_cal_asg_info.VENDOR_ID);
71: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.VENDOR_SITE_ID',p_cal_asg_info.VENDOR_SITE_ID);
72: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CUSTOMER_ID',p_cal_asg_info.CUSTOMER_ID);
73: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CUSTOMER_SITE_USE_ID',p_cal_asg_info.CUSTOMER_SITE_USE_ID);
74: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.REIGHT_CODE',p_cal_asg_info.FREIGHT_CODE);
75: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.FREIGHT_ORG_ID',p_cal_asg_info.FREIGHT_ORG_ID);
68: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ORGANIZATION_ID',p_cal_asg_info.ORGANIZATION_ID);
69: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.LOCATION_ID',p_cal_asg_info.LOCATION_ID);
70: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.VENDOR_ID',p_cal_asg_info.VENDOR_ID);
71: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.VENDOR_SITE_ID',p_cal_asg_info.VENDOR_SITE_ID);
72: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CUSTOMER_ID',p_cal_asg_info.CUSTOMER_ID);
73: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CUSTOMER_SITE_USE_ID',p_cal_asg_info.CUSTOMER_SITE_USE_ID);
74: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.REIGHT_CODE',p_cal_asg_info.FREIGHT_CODE);
75: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.FREIGHT_ORG_ID',p_cal_asg_info.FREIGHT_ORG_ID);
76: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CARRIER_ID',p_cal_asg_info.VENDOR_ID);
69: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.LOCATION_ID',p_cal_asg_info.LOCATION_ID);
70: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.VENDOR_ID',p_cal_asg_info.VENDOR_ID);
71: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.VENDOR_SITE_ID',p_cal_asg_info.VENDOR_SITE_ID);
72: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CUSTOMER_ID',p_cal_asg_info.CUSTOMER_ID);
73: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CUSTOMER_SITE_USE_ID',p_cal_asg_info.CUSTOMER_SITE_USE_ID);
74: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.REIGHT_CODE',p_cal_asg_info.FREIGHT_CODE);
75: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.FREIGHT_ORG_ID',p_cal_asg_info.FREIGHT_ORG_ID);
76: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CARRIER_ID',p_cal_asg_info.VENDOR_ID);
77: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CARRIER_SITE_ID',p_cal_asg_info.VENDOR_SITE_ID);
70: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.VENDOR_ID',p_cal_asg_info.VENDOR_ID);
71: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.VENDOR_SITE_ID',p_cal_asg_info.VENDOR_SITE_ID);
72: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CUSTOMER_ID',p_cal_asg_info.CUSTOMER_ID);
73: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CUSTOMER_SITE_USE_ID',p_cal_asg_info.CUSTOMER_SITE_USE_ID);
74: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.REIGHT_CODE',p_cal_asg_info.FREIGHT_CODE);
75: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.FREIGHT_ORG_ID',p_cal_asg_info.FREIGHT_ORG_ID);
76: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CARRIER_ID',p_cal_asg_info.VENDOR_ID);
77: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CARRIER_SITE_ID',p_cal_asg_info.VENDOR_SITE_ID);
78: END IF;
71: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.VENDOR_SITE_ID',p_cal_asg_info.VENDOR_SITE_ID);
72: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CUSTOMER_ID',p_cal_asg_info.CUSTOMER_ID);
73: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CUSTOMER_SITE_USE_ID',p_cal_asg_info.CUSTOMER_SITE_USE_ID);
74: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.REIGHT_CODE',p_cal_asg_info.FREIGHT_CODE);
75: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.FREIGHT_ORG_ID',p_cal_asg_info.FREIGHT_ORG_ID);
76: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CARRIER_ID',p_cal_asg_info.VENDOR_ID);
77: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CARRIER_SITE_ID',p_cal_asg_info.VENDOR_SITE_ID);
78: END IF;
79: --
72: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CUSTOMER_ID',p_cal_asg_info.CUSTOMER_ID);
73: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CUSTOMER_SITE_USE_ID',p_cal_asg_info.CUSTOMER_SITE_USE_ID);
74: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.REIGHT_CODE',p_cal_asg_info.FREIGHT_CODE);
75: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.FREIGHT_ORG_ID',p_cal_asg_info.FREIGHT_ORG_ID);
76: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CARRIER_ID',p_cal_asg_info.VENDOR_ID);
77: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CARRIER_SITE_ID',p_cal_asg_info.VENDOR_SITE_ID);
78: END IF;
79: --
80: IF NOT FND_API.Compatible_API_Call
73: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CUSTOMER_SITE_USE_ID',p_cal_asg_info.CUSTOMER_SITE_USE_ID);
74: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.REIGHT_CODE',p_cal_asg_info.FREIGHT_CODE);
75: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.FREIGHT_ORG_ID',p_cal_asg_info.FREIGHT_ORG_ID);
76: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CARRIER_ID',p_cal_asg_info.VENDOR_ID);
77: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CARRIER_SITE_ID',p_cal_asg_info.VENDOR_SITE_ID);
78: END IF;
79: --
80: IF NOT FND_API.Compatible_API_Call
81: ( l_api_version_number
188: --
189: -- Debug Statements
190: --
191: IF l_debug_on THEN
192: WSH_DEBUG_SV.pop(l_module_name);
193: END IF;
194: --
195: EXCEPTION
196:
205: --
206: -- Debug Statements
207: --
208: IF l_debug_on THEN
209: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
210: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
211: END IF;
212: --
213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
206: -- Debug Statements
207: --
208: IF l_debug_on THEN
209: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
210: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
211: END IF;
212: --
213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
221: --
222: -- Debug Statements
223: --
224: IF l_debug_on THEN
225: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
226: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
227: END IF;
228: --
229: WHEN OTHERS THEN
222: -- Debug Statements
223: --
224: IF l_debug_on THEN
225: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
226: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
227: END IF;
228: --
229: WHEN OTHERS THEN
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
243: --
244: -- Debug Statements
245: --
246: IF l_debug_on THEN
247: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
248: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
249: END IF;
250: --
251: END Create_Cal_Asg;
244: -- Debug Statements
245: --
246: IF l_debug_on THEN
247: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
248: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
249: END IF;
250: --
251: END Create_Cal_Asg;
252: --========================================================================
289: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
290: --
291: IF l_debug_on IS NULL
292: THEN
293: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
294: END IF;
295: --
296: IF l_debug_on THEN
297: WSH_DEBUG_SV.push(l_module_name);
293: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
294: END IF;
295: --
296: IF l_debug_on THEN
297: WSH_DEBUG_SV.push(l_module_name);
298: --
299: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
300: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
301: WSH_DEBUG_SV.log(l_module_name,'p_calendar_asgmt_id',p_calendar_asgmt_id);
295: --
296: IF l_debug_on THEN
297: WSH_DEBUG_SV.push(l_module_name);
298: --
299: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
300: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
301: WSH_DEBUG_SV.log(l_module_name,'p_calendar_asgmt_id',p_calendar_asgmt_id);
302: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
303: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
296: IF l_debug_on THEN
297: WSH_DEBUG_SV.push(l_module_name);
298: --
299: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
300: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
301: WSH_DEBUG_SV.log(l_module_name,'p_calendar_asgmt_id',p_calendar_asgmt_id);
302: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
303: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
304: END IF;
297: WSH_DEBUG_SV.push(l_module_name);
298: --
299: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
300: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
301: WSH_DEBUG_SV.log(l_module_name,'p_calendar_asgmt_id',p_calendar_asgmt_id);
302: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
303: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
304: END IF;
305: --
298: --
299: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
300: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
301: WSH_DEBUG_SV.log(l_module_name,'p_calendar_asgmt_id',p_calendar_asgmt_id);
302: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
303: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
304: END IF;
305: --
306: IF NOT FND_API.Compatible_API_Call
299: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
300: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
301: WSH_DEBUG_SV.log(l_module_name,'p_calendar_asgmt_id',p_calendar_asgmt_id);
302: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
303: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
304: END IF;
305: --
306: IF NOT FND_API.Compatible_API_Call
307: ( l_api_version_number
357: --
358: -- Debug Statements
359: --
360: IF l_debug_on THEN
361: WSH_DEBUG_SV.pop(l_module_name);
362: END IF;
363: --
364: EXCEPTION
365: WHEN FND_API.G_EXC_ERROR THEN
372: --
373: -- Debug Statements
374: --
375: IF l_debug_on THEN
376: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
377: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
378: END IF;
379: --
380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
373: -- Debug Statements
374: --
375: IF l_debug_on THEN
376: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
377: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
378: END IF;
379: --
380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
388: --
389: -- Debug Statements
390: --
391: IF l_debug_on THEN
392: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
393: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
394: END IF;
395: --
396: WHEN OTHERS THEN
389: -- Debug Statements
390: --
391: IF l_debug_on THEN
392: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
393: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
394: END IF;
395: --
396: WHEN OTHERS THEN
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
410: --
411: -- Debug Statements
412: --
413: IF l_debug_on THEN
414: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
415: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
416: END IF;
417: --
418: END Update_Cal_Asg;
411: -- Debug Statements
412: --
413: IF l_debug_on THEN
414: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
415: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
416: END IF;
417: --
418: END Update_Cal_Asg;
419: --========================================================================
465: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
466: --
467: IF l_debug_on IS NULL
468: THEN
469: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
470: END IF;
471: --
472: IF l_debug_on THEN
473: WSH_DEBUG_SV.push(l_module_name);
469: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
470: END IF;
471: --
472: IF l_debug_on THEN
473: WSH_DEBUG_SV.push(l_module_name);
474: --
475: WSH_DEBUG_SV.log(l_module_name,'P_CALENDAR_ASSIGNMENT_ID',P_CALENDAR_ASSIGNMENT_ID);
476: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
477: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
471: --
472: IF l_debug_on THEN
473: WSH_DEBUG_SV.push(l_module_name);
474: --
475: WSH_DEBUG_SV.log(l_module_name,'P_CALENDAR_ASSIGNMENT_ID',P_CALENDAR_ASSIGNMENT_ID);
476: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
477: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
478: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE_CATEGORY',p_cal_asg_info.ATTRIBUTE_CATEGORY);
479: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE1',p_cal_asg_info.ATTRIBUTE1);
472: IF l_debug_on THEN
473: WSH_DEBUG_SV.push(l_module_name);
474: --
475: WSH_DEBUG_SV.log(l_module_name,'P_CALENDAR_ASSIGNMENT_ID',P_CALENDAR_ASSIGNMENT_ID);
476: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
477: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
478: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE_CATEGORY',p_cal_asg_info.ATTRIBUTE_CATEGORY);
479: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE1',p_cal_asg_info.ATTRIBUTE1);
480: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE2',p_cal_asg_info.ATTRIBUTE2);
473: WSH_DEBUG_SV.push(l_module_name);
474: --
475: WSH_DEBUG_SV.log(l_module_name,'P_CALENDAR_ASSIGNMENT_ID',P_CALENDAR_ASSIGNMENT_ID);
476: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
477: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
478: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE_CATEGORY',p_cal_asg_info.ATTRIBUTE_CATEGORY);
479: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE1',p_cal_asg_info.ATTRIBUTE1);
480: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE2',p_cal_asg_info.ATTRIBUTE2);
481: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE3',p_cal_asg_info.ATTRIBUTE3);
474: --
475: WSH_DEBUG_SV.log(l_module_name,'P_CALENDAR_ASSIGNMENT_ID',P_CALENDAR_ASSIGNMENT_ID);
476: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
477: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
478: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE_CATEGORY',p_cal_asg_info.ATTRIBUTE_CATEGORY);
479: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE1',p_cal_asg_info.ATTRIBUTE1);
480: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE2',p_cal_asg_info.ATTRIBUTE2);
481: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE3',p_cal_asg_info.ATTRIBUTE3);
482: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE4',p_cal_asg_info.ATTRIBUTE4);
475: WSH_DEBUG_SV.log(l_module_name,'P_CALENDAR_ASSIGNMENT_ID',P_CALENDAR_ASSIGNMENT_ID);
476: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
477: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
478: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE_CATEGORY',p_cal_asg_info.ATTRIBUTE_CATEGORY);
479: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE1',p_cal_asg_info.ATTRIBUTE1);
480: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE2',p_cal_asg_info.ATTRIBUTE2);
481: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE3',p_cal_asg_info.ATTRIBUTE3);
482: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE4',p_cal_asg_info.ATTRIBUTE4);
483: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE5',p_cal_asg_info.ATTRIBUTE5);
476: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
477: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
478: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE_CATEGORY',p_cal_asg_info.ATTRIBUTE_CATEGORY);
479: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE1',p_cal_asg_info.ATTRIBUTE1);
480: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE2',p_cal_asg_info.ATTRIBUTE2);
481: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE3',p_cal_asg_info.ATTRIBUTE3);
482: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE4',p_cal_asg_info.ATTRIBUTE4);
483: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE5',p_cal_asg_info.ATTRIBUTE5);
484: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE6',p_cal_asg_info.ATTRIBUTE6);
477: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
478: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE_CATEGORY',p_cal_asg_info.ATTRIBUTE_CATEGORY);
479: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE1',p_cal_asg_info.ATTRIBUTE1);
480: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE2',p_cal_asg_info.ATTRIBUTE2);
481: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE3',p_cal_asg_info.ATTRIBUTE3);
482: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE4',p_cal_asg_info.ATTRIBUTE4);
483: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE5',p_cal_asg_info.ATTRIBUTE5);
484: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE6',p_cal_asg_info.ATTRIBUTE6);
485: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE7',p_cal_asg_info.ATTRIBUTE7);
478: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE_CATEGORY',p_cal_asg_info.ATTRIBUTE_CATEGORY);
479: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE1',p_cal_asg_info.ATTRIBUTE1);
480: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE2',p_cal_asg_info.ATTRIBUTE2);
481: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE3',p_cal_asg_info.ATTRIBUTE3);
482: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE4',p_cal_asg_info.ATTRIBUTE4);
483: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE5',p_cal_asg_info.ATTRIBUTE5);
484: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE6',p_cal_asg_info.ATTRIBUTE6);
485: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE7',p_cal_asg_info.ATTRIBUTE7);
486: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE8',p_cal_asg_info.ATTRIBUTE8);
479: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE1',p_cal_asg_info.ATTRIBUTE1);
480: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE2',p_cal_asg_info.ATTRIBUTE2);
481: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE3',p_cal_asg_info.ATTRIBUTE3);
482: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE4',p_cal_asg_info.ATTRIBUTE4);
483: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE5',p_cal_asg_info.ATTRIBUTE5);
484: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE6',p_cal_asg_info.ATTRIBUTE6);
485: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE7',p_cal_asg_info.ATTRIBUTE7);
486: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE8',p_cal_asg_info.ATTRIBUTE8);
487: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE9',p_cal_asg_info.ATTRIBUTE9);
480: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE2',p_cal_asg_info.ATTRIBUTE2);
481: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE3',p_cal_asg_info.ATTRIBUTE3);
482: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE4',p_cal_asg_info.ATTRIBUTE4);
483: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE5',p_cal_asg_info.ATTRIBUTE5);
484: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE6',p_cal_asg_info.ATTRIBUTE6);
485: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE7',p_cal_asg_info.ATTRIBUTE7);
486: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE8',p_cal_asg_info.ATTRIBUTE8);
487: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE9',p_cal_asg_info.ATTRIBUTE9);
488: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE10',p_cal_asg_info.ATTRIBUTE10);
481: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE3',p_cal_asg_info.ATTRIBUTE3);
482: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE4',p_cal_asg_info.ATTRIBUTE4);
483: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE5',p_cal_asg_info.ATTRIBUTE5);
484: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE6',p_cal_asg_info.ATTRIBUTE6);
485: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE7',p_cal_asg_info.ATTRIBUTE7);
486: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE8',p_cal_asg_info.ATTRIBUTE8);
487: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE9',p_cal_asg_info.ATTRIBUTE9);
488: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE10',p_cal_asg_info.ATTRIBUTE10);
489: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE11',p_cal_asg_info.ATTRIBUTE11);
482: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE4',p_cal_asg_info.ATTRIBUTE4);
483: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE5',p_cal_asg_info.ATTRIBUTE5);
484: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE6',p_cal_asg_info.ATTRIBUTE6);
485: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE7',p_cal_asg_info.ATTRIBUTE7);
486: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE8',p_cal_asg_info.ATTRIBUTE8);
487: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE9',p_cal_asg_info.ATTRIBUTE9);
488: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE10',p_cal_asg_info.ATTRIBUTE10);
489: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE11',p_cal_asg_info.ATTRIBUTE11);
490: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE12',p_cal_asg_info.ATTRIBUTE12);
483: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE5',p_cal_asg_info.ATTRIBUTE5);
484: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE6',p_cal_asg_info.ATTRIBUTE6);
485: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE7',p_cal_asg_info.ATTRIBUTE7);
486: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE8',p_cal_asg_info.ATTRIBUTE8);
487: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE9',p_cal_asg_info.ATTRIBUTE9);
488: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE10',p_cal_asg_info.ATTRIBUTE10);
489: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE11',p_cal_asg_info.ATTRIBUTE11);
490: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE12',p_cal_asg_info.ATTRIBUTE12);
491: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE13',p_cal_asg_info.ATTRIBUTE13);
484: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE6',p_cal_asg_info.ATTRIBUTE6);
485: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE7',p_cal_asg_info.ATTRIBUTE7);
486: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE8',p_cal_asg_info.ATTRIBUTE8);
487: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE9',p_cal_asg_info.ATTRIBUTE9);
488: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE10',p_cal_asg_info.ATTRIBUTE10);
489: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE11',p_cal_asg_info.ATTRIBUTE11);
490: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE12',p_cal_asg_info.ATTRIBUTE12);
491: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE13',p_cal_asg_info.ATTRIBUTE13);
492: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE14',p_cal_asg_info.ATTRIBUTE14);
485: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE7',p_cal_asg_info.ATTRIBUTE7);
486: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE8',p_cal_asg_info.ATTRIBUTE8);
487: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE9',p_cal_asg_info.ATTRIBUTE9);
488: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE10',p_cal_asg_info.ATTRIBUTE10);
489: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE11',p_cal_asg_info.ATTRIBUTE11);
490: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE12',p_cal_asg_info.ATTRIBUTE12);
491: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE13',p_cal_asg_info.ATTRIBUTE13);
492: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE14',p_cal_asg_info.ATTRIBUTE14);
493: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE15',p_cal_asg_info.ATTRIBUTE15);
486: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE8',p_cal_asg_info.ATTRIBUTE8);
487: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE9',p_cal_asg_info.ATTRIBUTE9);
488: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE10',p_cal_asg_info.ATTRIBUTE10);
489: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE11',p_cal_asg_info.ATTRIBUTE11);
490: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE12',p_cal_asg_info.ATTRIBUTE12);
491: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE13',p_cal_asg_info.ATTRIBUTE13);
492: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE14',p_cal_asg_info.ATTRIBUTE14);
493: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE15',p_cal_asg_info.ATTRIBUTE15);
494: END IF;
487: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE9',p_cal_asg_info.ATTRIBUTE9);
488: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE10',p_cal_asg_info.ATTRIBUTE10);
489: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE11',p_cal_asg_info.ATTRIBUTE11);
490: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE12',p_cal_asg_info.ATTRIBUTE12);
491: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE13',p_cal_asg_info.ATTRIBUTE13);
492: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE14',p_cal_asg_info.ATTRIBUTE14);
493: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE15',p_cal_asg_info.ATTRIBUTE15);
494: END IF;
495: --
488: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE10',p_cal_asg_info.ATTRIBUTE10);
489: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE11',p_cal_asg_info.ATTRIBUTE11);
490: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE12',p_cal_asg_info.ATTRIBUTE12);
491: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE13',p_cal_asg_info.ATTRIBUTE13);
492: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE14',p_cal_asg_info.ATTRIBUTE14);
493: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE15',p_cal_asg_info.ATTRIBUTE15);
494: END IF;
495: --
496: OPEN lock_row;
489: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE11',p_cal_asg_info.ATTRIBUTE11);
490: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE12',p_cal_asg_info.ATTRIBUTE12);
491: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE13',p_cal_asg_info.ATTRIBUTE13);
492: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE14',p_cal_asg_info.ATTRIBUTE14);
493: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ATTRIBUTE15',p_cal_asg_info.ATTRIBUTE15);
494: END IF;
495: --
496: OPEN lock_row;
497: FETCH lock_row INTO Recinfo;
542: --
543: -- Debug Statements
544: --
545: IF l_debug_on THEN
546: WSH_DEBUG_SV.pop(l_module_name);
547: END IF;
548: --
549: RETURN;
550: ELSE
555: --
556: -- Debug Statements
557: --
558: IF l_debug_on THEN
559: WSH_DEBUG_SV.pop(l_module_name);
560: END IF;
561: --
562: END Lock_Cal_Asg;
563: --========================================================================
598: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
599: --
600: IF l_debug_on IS NULL
601: THEN
602: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
603: END IF;
604: --
605: IF l_debug_on THEN
606: WSH_DEBUG_SV.push(l_module_name);
602: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
603: END IF;
604: --
605: IF l_debug_on THEN
606: WSH_DEBUG_SV.push(l_module_name);
607: --
608: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
609: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
610: WSH_DEBUG_SV.log(l_module_name,'P_CALENDAR_ASSIGNMENT_ID',P_CALENDAR_ASSIGNMENT_ID);
604: --
605: IF l_debug_on THEN
606: WSH_DEBUG_SV.push(l_module_name);
607: --
608: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
609: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
610: WSH_DEBUG_SV.log(l_module_name,'P_CALENDAR_ASSIGNMENT_ID',P_CALENDAR_ASSIGNMENT_ID);
611: END IF;
612: --
605: IF l_debug_on THEN
606: WSH_DEBUG_SV.push(l_module_name);
607: --
608: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
609: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
610: WSH_DEBUG_SV.log(l_module_name,'P_CALENDAR_ASSIGNMENT_ID',P_CALENDAR_ASSIGNMENT_ID);
611: END IF;
612: --
613: IF p_calendar_assignment_id IS NOT NULL THEN
606: WSH_DEBUG_SV.push(l_module_name);
607: --
608: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
609: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
610: WSH_DEBUG_SV.log(l_module_name,'P_CALENDAR_ASSIGNMENT_ID',P_CALENDAR_ASSIGNMENT_ID);
611: END IF;
612: --
613: IF p_calendar_assignment_id IS NOT NULL THEN
614: DELETE FROM wsh_calendar_assignments
617: --
618: -- Debug Statements
619: --
620: IF l_debug_on THEN
621: WSH_DEBUG_SV.pop(l_module_name);
622: END IF;
623: --
624: END Delete_Cal_Asg;
625: