DBA Data[Home] [Help]

APPS.WSH_ORG_CARRIER_SITES_PKG dependencies on WSH_DEBUG_SV

Line 60: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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);

Line 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);

Line 65: WSH_DEBUG_SV.log(l_module_name,'Carrier_Site_ID',p_org_Carrier_site_Info.Carrier_Site_ID);

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);

Line 66: WSH_DEBUG_SV.log(l_module_name,'Organization_ID',p_org_Carrier_site_Info.Organization_id);

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);

Line 67: WSH_DEBUG_SV.log(l_module_name,'Attribute_Category',p_org_Carrier_site_Info.Attribute_Category);

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);

Line 68: WSH_DEBUG_SV.log(l_module_name,'attribute1',p_org_Carrier_site_Info.attribute1);

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);

Line 69: WSH_DEBUG_SV.log(l_module_name,'attribute2',p_org_Carrier_site_Info.attribute2);

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);

Line 70: WSH_DEBUG_SV.log(l_module_name,'attribute3',p_org_Carrier_site_Info.attribute3);

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);

Line 71: WSH_DEBUG_SV.log(l_module_name,'attribute4',p_org_Carrier_site_Info.attribute4);

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);

Line 72: WSH_DEBUG_SV.log(l_module_name,'attribute5',p_org_Carrier_site_Info.attribute5);

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);

Line 73: WSH_DEBUG_SV.log(l_module_name,'attribute6',p_org_Carrier_site_Info.attribute6);

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);

Line 74: WSH_DEBUG_SV.log(l_module_name,'attribute7',p_org_Carrier_site_Info.attribute7);

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);

Line 75: WSH_DEBUG_SV.log(l_module_name,'attribute8',p_org_Carrier_site_Info.attribute8);

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);

Line 76: WSH_DEBUG_SV.log(l_module_name,'attribute9',p_org_Carrier_site_Info.attribute9);

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);

Line 77: WSH_DEBUG_SV.log(l_module_name,'attribute10',p_org_Carrier_site_Info.attribute10);

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);

Line 78: WSH_DEBUG_SV.log(l_module_name,'attribute11',p_org_Carrier_site_Info.attribute11);

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);

Line 79: WSH_DEBUG_SV.log(l_module_name,'attribute12',p_org_Carrier_site_Info.attribute12);

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;

Line 80: WSH_DEBUG_SV.log(l_module_name,'attribute13',p_org_Carrier_site_Info.attribute13);

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: --

Line 81: WSH_DEBUG_SV.log(l_module_name,'attribute14',p_org_Carrier_site_Info.attribute14);

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: --

Line 82: WSH_DEBUG_SV.log(l_module_name,'attribute15',p_org_Carrier_site_Info.attribute15);

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:

Line 101: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into WSH_ORG_CARRIER_SITES',WSH_DEBUG_SV.C_PROC_LEVEL);

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

Line 176: WSH_DEBUG_SV.logmsg(l_module_name,'Updating WSH_ORG_CARRIER_SITES',WSH_DEBUG_SV.C_PROC_LEVEL);

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

Line 217: WSH_DEBUG_SV.pop(l_module_name);

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

Line 234: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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:

Line 235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

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

Line 251: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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:

Line 252: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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;

Line 289: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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);

Line 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: --

Line 295: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);

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;

Line 313: WSH_DEBUG_SV.pop(l_module_name,'x_return_status');

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;

Line 374: WSH_DEBUG_SV.pop(l_module_name,'Nothing changed');

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:

Line 384: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_CHANGED');

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;

Line 393: WSH_DEBUG_SV.pop(l_module_name);

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

Line 404: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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:

Line 405: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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;