56: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
57: --
58: IF l_debug_on IS NULL
59: THEN
60: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
61: END IF;
62: --
63: IF l_debug_on THEN
64: WSH_DEBUG_SV.push(l_module_name);
60: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
61: END IF;
62: --
63: IF l_debug_on THEN
64: WSH_DEBUG_SV.push(l_module_name);
65: WSH_DEBUG_SV.log(l_module_name,'Carrier_Site_ID',p_org_Carrier_site_Info.Carrier_Site_ID);
66: WSH_DEBUG_SV.log(l_module_name,'Organization_ID',p_org_Carrier_site_Info.Organization_id);
67: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',p_org_Carrier_site_Info.Attribute_Category);
68: WSH_DEBUG_SV.log(l_module_name,'attribute1',p_org_Carrier_site_Info.attribute1);
61: END IF;
62: --
63: IF l_debug_on THEN
64: WSH_DEBUG_SV.push(l_module_name);
65: WSH_DEBUG_SV.log(l_module_name,'Carrier_Site_ID',p_org_Carrier_site_Info.Carrier_Site_ID);
66: WSH_DEBUG_SV.log(l_module_name,'Organization_ID',p_org_Carrier_site_Info.Organization_id);
67: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',p_org_Carrier_site_Info.Attribute_Category);
68: WSH_DEBUG_SV.log(l_module_name,'attribute1',p_org_Carrier_site_Info.attribute1);
69: WSH_DEBUG_SV.log(l_module_name,'attribute2',p_org_Carrier_site_Info.attribute2);
62: --
63: IF l_debug_on THEN
64: WSH_DEBUG_SV.push(l_module_name);
65: WSH_DEBUG_SV.log(l_module_name,'Carrier_Site_ID',p_org_Carrier_site_Info.Carrier_Site_ID);
66: WSH_DEBUG_SV.log(l_module_name,'Organization_ID',p_org_Carrier_site_Info.Organization_id);
67: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',p_org_Carrier_site_Info.Attribute_Category);
68: WSH_DEBUG_SV.log(l_module_name,'attribute1',p_org_Carrier_site_Info.attribute1);
69: WSH_DEBUG_SV.log(l_module_name,'attribute2',p_org_Carrier_site_Info.attribute2);
70: WSH_DEBUG_SV.log(l_module_name,'attribute3',p_org_Carrier_site_Info.attribute3);
63: IF l_debug_on THEN
64: WSH_DEBUG_SV.push(l_module_name);
65: WSH_DEBUG_SV.log(l_module_name,'Carrier_Site_ID',p_org_Carrier_site_Info.Carrier_Site_ID);
66: WSH_DEBUG_SV.log(l_module_name,'Organization_ID',p_org_Carrier_site_Info.Organization_id);
67: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',p_org_Carrier_site_Info.Attribute_Category);
68: WSH_DEBUG_SV.log(l_module_name,'attribute1',p_org_Carrier_site_Info.attribute1);
69: WSH_DEBUG_SV.log(l_module_name,'attribute2',p_org_Carrier_site_Info.attribute2);
70: WSH_DEBUG_SV.log(l_module_name,'attribute3',p_org_Carrier_site_Info.attribute3);
71: WSH_DEBUG_SV.log(l_module_name,'attribute4',p_org_Carrier_site_Info.attribute4);
64: WSH_DEBUG_SV.push(l_module_name);
65: WSH_DEBUG_SV.log(l_module_name,'Carrier_Site_ID',p_org_Carrier_site_Info.Carrier_Site_ID);
66: WSH_DEBUG_SV.log(l_module_name,'Organization_ID',p_org_Carrier_site_Info.Organization_id);
67: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',p_org_Carrier_site_Info.Attribute_Category);
68: WSH_DEBUG_SV.log(l_module_name,'attribute1',p_org_Carrier_site_Info.attribute1);
69: WSH_DEBUG_SV.log(l_module_name,'attribute2',p_org_Carrier_site_Info.attribute2);
70: WSH_DEBUG_SV.log(l_module_name,'attribute3',p_org_Carrier_site_Info.attribute3);
71: WSH_DEBUG_SV.log(l_module_name,'attribute4',p_org_Carrier_site_Info.attribute4);
72: WSH_DEBUG_SV.log(l_module_name,'attribute5',p_org_Carrier_site_Info.attribute5);
65: WSH_DEBUG_SV.log(l_module_name,'Carrier_Site_ID',p_org_Carrier_site_Info.Carrier_Site_ID);
66: WSH_DEBUG_SV.log(l_module_name,'Organization_ID',p_org_Carrier_site_Info.Organization_id);
67: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',p_org_Carrier_site_Info.Attribute_Category);
68: WSH_DEBUG_SV.log(l_module_name,'attribute1',p_org_Carrier_site_Info.attribute1);
69: WSH_DEBUG_SV.log(l_module_name,'attribute2',p_org_Carrier_site_Info.attribute2);
70: WSH_DEBUG_SV.log(l_module_name,'attribute3',p_org_Carrier_site_Info.attribute3);
71: WSH_DEBUG_SV.log(l_module_name,'attribute4',p_org_Carrier_site_Info.attribute4);
72: WSH_DEBUG_SV.log(l_module_name,'attribute5',p_org_Carrier_site_Info.attribute5);
73: WSH_DEBUG_SV.log(l_module_name,'attribute6',p_org_Carrier_site_Info.attribute6);
66: WSH_DEBUG_SV.log(l_module_name,'Organization_ID',p_org_Carrier_site_Info.Organization_id);
67: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',p_org_Carrier_site_Info.Attribute_Category);
68: WSH_DEBUG_SV.log(l_module_name,'attribute1',p_org_Carrier_site_Info.attribute1);
69: WSH_DEBUG_SV.log(l_module_name,'attribute2',p_org_Carrier_site_Info.attribute2);
70: WSH_DEBUG_SV.log(l_module_name,'attribute3',p_org_Carrier_site_Info.attribute3);
71: WSH_DEBUG_SV.log(l_module_name,'attribute4',p_org_Carrier_site_Info.attribute4);
72: WSH_DEBUG_SV.log(l_module_name,'attribute5',p_org_Carrier_site_Info.attribute5);
73: WSH_DEBUG_SV.log(l_module_name,'attribute6',p_org_Carrier_site_Info.attribute6);
74: WSH_DEBUG_SV.log(l_module_name,'attribute7',p_org_Carrier_site_Info.attribute7);
67: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',p_org_Carrier_site_Info.Attribute_Category);
68: WSH_DEBUG_SV.log(l_module_name,'attribute1',p_org_Carrier_site_Info.attribute1);
69: WSH_DEBUG_SV.log(l_module_name,'attribute2',p_org_Carrier_site_Info.attribute2);
70: WSH_DEBUG_SV.log(l_module_name,'attribute3',p_org_Carrier_site_Info.attribute3);
71: WSH_DEBUG_SV.log(l_module_name,'attribute4',p_org_Carrier_site_Info.attribute4);
72: WSH_DEBUG_SV.log(l_module_name,'attribute5',p_org_Carrier_site_Info.attribute5);
73: WSH_DEBUG_SV.log(l_module_name,'attribute6',p_org_Carrier_site_Info.attribute6);
74: WSH_DEBUG_SV.log(l_module_name,'attribute7',p_org_Carrier_site_Info.attribute7);
75: WSH_DEBUG_SV.log(l_module_name,'attribute8',p_org_Carrier_site_Info.attribute8);
68: WSH_DEBUG_SV.log(l_module_name,'attribute1',p_org_Carrier_site_Info.attribute1);
69: WSH_DEBUG_SV.log(l_module_name,'attribute2',p_org_Carrier_site_Info.attribute2);
70: WSH_DEBUG_SV.log(l_module_name,'attribute3',p_org_Carrier_site_Info.attribute3);
71: WSH_DEBUG_SV.log(l_module_name,'attribute4',p_org_Carrier_site_Info.attribute4);
72: WSH_DEBUG_SV.log(l_module_name,'attribute5',p_org_Carrier_site_Info.attribute5);
73: WSH_DEBUG_SV.log(l_module_name,'attribute6',p_org_Carrier_site_Info.attribute6);
74: WSH_DEBUG_SV.log(l_module_name,'attribute7',p_org_Carrier_site_Info.attribute7);
75: WSH_DEBUG_SV.log(l_module_name,'attribute8',p_org_Carrier_site_Info.attribute8);
76: WSH_DEBUG_SV.log(l_module_name,'attribute9',p_org_Carrier_site_Info.attribute9);
69: WSH_DEBUG_SV.log(l_module_name,'attribute2',p_org_Carrier_site_Info.attribute2);
70: WSH_DEBUG_SV.log(l_module_name,'attribute3',p_org_Carrier_site_Info.attribute3);
71: WSH_DEBUG_SV.log(l_module_name,'attribute4',p_org_Carrier_site_Info.attribute4);
72: WSH_DEBUG_SV.log(l_module_name,'attribute5',p_org_Carrier_site_Info.attribute5);
73: WSH_DEBUG_SV.log(l_module_name,'attribute6',p_org_Carrier_site_Info.attribute6);
74: WSH_DEBUG_SV.log(l_module_name,'attribute7',p_org_Carrier_site_Info.attribute7);
75: WSH_DEBUG_SV.log(l_module_name,'attribute8',p_org_Carrier_site_Info.attribute8);
76: WSH_DEBUG_SV.log(l_module_name,'attribute9',p_org_Carrier_site_Info.attribute9);
77: WSH_DEBUG_SV.log(l_module_name,'attribute10',p_org_Carrier_site_Info.attribute10);
70: WSH_DEBUG_SV.log(l_module_name,'attribute3',p_org_Carrier_site_Info.attribute3);
71: WSH_DEBUG_SV.log(l_module_name,'attribute4',p_org_Carrier_site_Info.attribute4);
72: WSH_DEBUG_SV.log(l_module_name,'attribute5',p_org_Carrier_site_Info.attribute5);
73: WSH_DEBUG_SV.log(l_module_name,'attribute6',p_org_Carrier_site_Info.attribute6);
74: WSH_DEBUG_SV.log(l_module_name,'attribute7',p_org_Carrier_site_Info.attribute7);
75: WSH_DEBUG_SV.log(l_module_name,'attribute8',p_org_Carrier_site_Info.attribute8);
76: WSH_DEBUG_SV.log(l_module_name,'attribute9',p_org_Carrier_site_Info.attribute9);
77: WSH_DEBUG_SV.log(l_module_name,'attribute10',p_org_Carrier_site_Info.attribute10);
78: WSH_DEBUG_SV.log(l_module_name,'attribute11',p_org_Carrier_site_Info.attribute11);
71: WSH_DEBUG_SV.log(l_module_name,'attribute4',p_org_Carrier_site_Info.attribute4);
72: WSH_DEBUG_SV.log(l_module_name,'attribute5',p_org_Carrier_site_Info.attribute5);
73: WSH_DEBUG_SV.log(l_module_name,'attribute6',p_org_Carrier_site_Info.attribute6);
74: WSH_DEBUG_SV.log(l_module_name,'attribute7',p_org_Carrier_site_Info.attribute7);
75: WSH_DEBUG_SV.log(l_module_name,'attribute8',p_org_Carrier_site_Info.attribute8);
76: WSH_DEBUG_SV.log(l_module_name,'attribute9',p_org_Carrier_site_Info.attribute9);
77: WSH_DEBUG_SV.log(l_module_name,'attribute10',p_org_Carrier_site_Info.attribute10);
78: WSH_DEBUG_SV.log(l_module_name,'attribute11',p_org_Carrier_site_Info.attribute11);
79: WSH_DEBUG_SV.log(l_module_name,'attribute12',p_org_Carrier_site_Info.attribute12);
72: WSH_DEBUG_SV.log(l_module_name,'attribute5',p_org_Carrier_site_Info.attribute5);
73: WSH_DEBUG_SV.log(l_module_name,'attribute6',p_org_Carrier_site_Info.attribute6);
74: WSH_DEBUG_SV.log(l_module_name,'attribute7',p_org_Carrier_site_Info.attribute7);
75: WSH_DEBUG_SV.log(l_module_name,'attribute8',p_org_Carrier_site_Info.attribute8);
76: WSH_DEBUG_SV.log(l_module_name,'attribute9',p_org_Carrier_site_Info.attribute9);
77: WSH_DEBUG_SV.log(l_module_name,'attribute10',p_org_Carrier_site_Info.attribute10);
78: WSH_DEBUG_SV.log(l_module_name,'attribute11',p_org_Carrier_site_Info.attribute11);
79: WSH_DEBUG_SV.log(l_module_name,'attribute12',p_org_Carrier_site_Info.attribute12);
80: WSH_DEBUG_SV.log(l_module_name,'attribute13',p_org_Carrier_site_Info.attribute13);
73: WSH_DEBUG_SV.log(l_module_name,'attribute6',p_org_Carrier_site_Info.attribute6);
74: WSH_DEBUG_SV.log(l_module_name,'attribute7',p_org_Carrier_site_Info.attribute7);
75: WSH_DEBUG_SV.log(l_module_name,'attribute8',p_org_Carrier_site_Info.attribute8);
76: WSH_DEBUG_SV.log(l_module_name,'attribute9',p_org_Carrier_site_Info.attribute9);
77: WSH_DEBUG_SV.log(l_module_name,'attribute10',p_org_Carrier_site_Info.attribute10);
78: WSH_DEBUG_SV.log(l_module_name,'attribute11',p_org_Carrier_site_Info.attribute11);
79: WSH_DEBUG_SV.log(l_module_name,'attribute12',p_org_Carrier_site_Info.attribute12);
80: WSH_DEBUG_SV.log(l_module_name,'attribute13',p_org_Carrier_site_Info.attribute13);
81: WSH_DEBUG_SV.log(l_module_name,'attribute14',p_org_Carrier_site_Info.attribute14);
74: WSH_DEBUG_SV.log(l_module_name,'attribute7',p_org_Carrier_site_Info.attribute7);
75: WSH_DEBUG_SV.log(l_module_name,'attribute8',p_org_Carrier_site_Info.attribute8);
76: WSH_DEBUG_SV.log(l_module_name,'attribute9',p_org_Carrier_site_Info.attribute9);
77: WSH_DEBUG_SV.log(l_module_name,'attribute10',p_org_Carrier_site_Info.attribute10);
78: WSH_DEBUG_SV.log(l_module_name,'attribute11',p_org_Carrier_site_Info.attribute11);
79: WSH_DEBUG_SV.log(l_module_name,'attribute12',p_org_Carrier_site_Info.attribute12);
80: WSH_DEBUG_SV.log(l_module_name,'attribute13',p_org_Carrier_site_Info.attribute13);
81: WSH_DEBUG_SV.log(l_module_name,'attribute14',p_org_Carrier_site_Info.attribute14);
82: WSH_DEBUG_SV.log(l_module_name,'attribute15',p_org_Carrier_site_Info.attribute15);
75: WSH_DEBUG_SV.log(l_module_name,'attribute8',p_org_Carrier_site_Info.attribute8);
76: WSH_DEBUG_SV.log(l_module_name,'attribute9',p_org_Carrier_site_Info.attribute9);
77: WSH_DEBUG_SV.log(l_module_name,'attribute10',p_org_Carrier_site_Info.attribute10);
78: WSH_DEBUG_SV.log(l_module_name,'attribute11',p_org_Carrier_site_Info.attribute11);
79: WSH_DEBUG_SV.log(l_module_name,'attribute12',p_org_Carrier_site_Info.attribute12);
80: WSH_DEBUG_SV.log(l_module_name,'attribute13',p_org_Carrier_site_Info.attribute13);
81: WSH_DEBUG_SV.log(l_module_name,'attribute14',p_org_Carrier_site_Info.attribute14);
82: WSH_DEBUG_SV.log(l_module_name,'attribute15',p_org_Carrier_site_Info.attribute15);
83: END IF;
76: WSH_DEBUG_SV.log(l_module_name,'attribute9',p_org_Carrier_site_Info.attribute9);
77: WSH_DEBUG_SV.log(l_module_name,'attribute10',p_org_Carrier_site_Info.attribute10);
78: WSH_DEBUG_SV.log(l_module_name,'attribute11',p_org_Carrier_site_Info.attribute11);
79: WSH_DEBUG_SV.log(l_module_name,'attribute12',p_org_Carrier_site_Info.attribute12);
80: WSH_DEBUG_SV.log(l_module_name,'attribute13',p_org_Carrier_site_Info.attribute13);
81: WSH_DEBUG_SV.log(l_module_name,'attribute14',p_org_Carrier_site_Info.attribute14);
82: WSH_DEBUG_SV.log(l_module_name,'attribute15',p_org_Carrier_site_Info.attribute15);
83: END IF;
84: --
77: WSH_DEBUG_SV.log(l_module_name,'attribute10',p_org_Carrier_site_Info.attribute10);
78: WSH_DEBUG_SV.log(l_module_name,'attribute11',p_org_Carrier_site_Info.attribute11);
79: WSH_DEBUG_SV.log(l_module_name,'attribute12',p_org_Carrier_site_Info.attribute12);
80: WSH_DEBUG_SV.log(l_module_name,'attribute13',p_org_Carrier_site_Info.attribute13);
81: WSH_DEBUG_SV.log(l_module_name,'attribute14',p_org_Carrier_site_Info.attribute14);
82: WSH_DEBUG_SV.log(l_module_name,'attribute15',p_org_Carrier_site_Info.attribute15);
83: END IF;
84: --
85: --
78: WSH_DEBUG_SV.log(l_module_name,'attribute11',p_org_Carrier_site_Info.attribute11);
79: WSH_DEBUG_SV.log(l_module_name,'attribute12',p_org_Carrier_site_Info.attribute12);
80: WSH_DEBUG_SV.log(l_module_name,'attribute13',p_org_Carrier_site_Info.attribute13);
81: WSH_DEBUG_SV.log(l_module_name,'attribute14',p_org_Carrier_site_Info.attribute14);
82: WSH_DEBUG_SV.log(l_module_name,'attribute15',p_org_Carrier_site_Info.attribute15);
83: END IF;
84: --
85: --
86:
97: --
98: -- Debug Statements
99: --
100: IF l_debug_on THEN
101: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into WSH_ORG_CARRIER_SITES',WSH_DEBUG_SV.C_PROC_LEVEL);
102: END IF;
103: --
104:
105: INSERT INTO WSH_ORG_CARRIER_SITES
172: --
173: -- Debug Statements
174: --
175: IF l_debug_on THEN
176: WSH_DEBUG_SV.logmsg(l_module_name,'Updating WSH_ORG_CARRIER_SITES',WSH_DEBUG_SV.C_PROC_LEVEL);
177: END IF;
178: --
179:
180: UPDATE WSH_ORG_CARRIER_SITES
213: --
214: -- Debug Statements
215: --
216: IF l_debug_on THEN
217: WSH_DEBUG_SV.pop(l_module_name);
218: END IF;
219: --
220:
221: EXCEPTION
230: --
231: -- Debug Statements
232: --
233: IF l_debug_on THEN
234: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
236: END IF;
237: --
238:
231: -- Debug Statements
232: --
233: IF l_debug_on THEN
234: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
236: END IF;
237: --
238:
239: WHEN OTHERS THEN
247: --
248: -- Debug Statements
249: --
250: IF l_debug_on THEN
251: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
252: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
253: END IF;
254: --
255:
248: -- Debug Statements
249: --
250: IF l_debug_on THEN
251: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
252: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
253: END IF;
254: --
255:
256: END Assign_Org_Carrier_Site;
285: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
286: --
287: IF l_debug_on IS NULL
288: THEN
289: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
290: END IF;
291: --
292: IF l_debug_on THEN
293: WSH_DEBUG_SV.push(l_module_name);
289: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
290: END IF;
291: --
292: IF l_debug_on THEN
293: WSH_DEBUG_SV.push(l_module_name);
294: --
295: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
296: END IF;
297: --
291: --
292: IF l_debug_on THEN
293: WSH_DEBUG_SV.push(l_module_name);
294: --
295: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
296: END IF;
297: --
298:
299: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
309: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
310:
311: --
312: IF l_debug_on THEN
313: WSH_DEBUG_SV.pop(l_module_name,'x_return_status');
314: END IF;
315: --
316: RETURN;
317: END IF;
370: ) THEN
371:
372: --
373: IF l_debug_on THEN
374: WSH_DEBUG_SV.pop(l_module_name,'Nothing changed');
375: END IF;
376: --
377: RETURN;
378:
380:
381: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
382:
383: IF l_debug_on THEN
384: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_CHANGED');
385: END IF;
386:
387: APP_EXCEPTION.Raise_Exception;
388: END IF;
389: END IF;
390:
391: --
392: IF l_debug_on THEN
393: WSH_DEBUG_SV.pop(l_module_name);
394: END IF;
395: --
396:
397: EXCEPTION
400: WSH_UTIL_CORE.Default_Handler('WSH_ORG_CARRIER_SITES_PKG.Lock_Org_Carrier_Site',l_module_name);
401:
402: --
403: IF l_debug_on THEN
404: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
405: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
406: END IF;
407: --
408:
401:
402: --
403: IF l_debug_on THEN
404: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
405: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
406: END IF;
407: --
408:
409: END Lock_Org_Carrier_Site;