DBA Data[Home] [Help]

APPS.WSH_CARRIER_CONTACT_INFO_PKG dependencies on WSH_DEBUG_SV

Line 76: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

72: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
73: --
74: IF l_debug_on IS NULL
75: THEN
76: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
77: END IF;
78: --
79: IF l_debug_on THEN
80: WSH_DEBUG_SV.push(l_module_name);

Line 80: WSH_DEBUG_SV.push(l_module_name);

76: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
77: END IF;
78: --
79: IF l_debug_on THEN
80: WSH_DEBUG_SV.push(l_module_name);
81: --
82: WSH_DEBUG_SV.log(l_module_name,'P_RELATIONSHIP_PARTY_ID',P_RELATIONSHIP_PARTY_ID);
83: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
84: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);

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

78: --
79: IF l_debug_on THEN
80: WSH_DEBUG_SV.push(l_module_name);
81: --
82: WSH_DEBUG_SV.log(l_module_name,'P_RELATIONSHIP_PARTY_ID',P_RELATIONSHIP_PARTY_ID);
83: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
84: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
85: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
86: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);

Line 83: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);

79: IF l_debug_on THEN
80: WSH_DEBUG_SV.push(l_module_name);
81: --
82: WSH_DEBUG_SV.log(l_module_name,'P_RELATIONSHIP_PARTY_ID',P_RELATIONSHIP_PARTY_ID);
83: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
84: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
85: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
86: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
87: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY',P_PRIMARY);

Line 84: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);

80: WSH_DEBUG_SV.push(l_module_name);
81: --
82: WSH_DEBUG_SV.log(l_module_name,'P_RELATIONSHIP_PARTY_ID',P_RELATIONSHIP_PARTY_ID);
83: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
84: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
85: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
86: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
87: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY',P_PRIMARY);
88: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);

Line 85: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);

81: --
82: WSH_DEBUG_SV.log(l_module_name,'P_RELATIONSHIP_PARTY_ID',P_RELATIONSHIP_PARTY_ID);
83: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
84: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
85: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
86: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
87: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY',P_PRIMARY);
88: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
89: -- Corrected Bug 5298638 - parameter value of contact type to be shown in log file.

Line 86: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);

82: WSH_DEBUG_SV.log(l_module_name,'P_RELATIONSHIP_PARTY_ID',P_RELATIONSHIP_PARTY_ID);
83: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
84: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
85: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
86: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
87: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY',P_PRIMARY);
88: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
89: -- Corrected Bug 5298638 - parameter value of contact type to be shown in log file.
90: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);

Line 87: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY',P_PRIMARY);

83: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
84: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
85: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
86: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
87: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY',P_PRIMARY);
88: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
89: -- Corrected Bug 5298638 - parameter value of contact type to be shown in log file.
90: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
91: -- Added Bug 5298638 - parameter value of status to be shown in log file.

Line 88: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);

84: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
85: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
86: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
87: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY',P_PRIMARY);
88: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
89: -- Corrected Bug 5298638 - parameter value of contact type to be shown in log file.
90: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
91: -- Added Bug 5298638 - parameter value of status to be shown in log file.
92: END IF;

Line 90: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);

86: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
87: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY',P_PRIMARY);
88: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
89: -- Corrected Bug 5298638 - parameter value of contact type to be shown in log file.
90: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
91: -- Added Bug 5298638 - parameter value of status to be shown in log file.
92: END IF;
93: --
94:

Line 126: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.Create_Contact_Point',WSH_DEBUG_SV.C_PROC_LEVEL);

122: --
123: -- Debug Statements
124: --
125: IF l_debug_on THEN
126: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.Create_Contact_Point',WSH_DEBUG_SV.C_PROC_LEVEL);
127: END IF;
128: --
129:
130: HZ_CONTACT_POINT_V2PUB.Create_Contact_Point

Line 155: WSH_DEBUG_SV.pop(l_module_name);

151: --
152: -- Debug Statements
153: --
154: IF l_debug_on THEN
155: WSH_DEBUG_SV.pop(l_module_name);
156: END IF;
157: --
158:
159:

Line 172: WSH_DEBUG_SV.logmsg(l_module_name,'HZ_FAIL_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

168: --
169: -- Debug Statements
170: --
171: IF l_debug_on THEN
172: WSH_DEBUG_SV.logmsg(l_module_name,'HZ_FAIL_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
173: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:HZ_FAIL_EXCEPTION');
174: END IF;
175: --
176:

Line 173: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:HZ_FAIL_EXCEPTION');

169: -- Debug Statements
170: --
171: IF l_debug_on THEN
172: WSH_DEBUG_SV.logmsg(l_module_name,'HZ_FAIL_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
173: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:HZ_FAIL_EXCEPTION');
174: END IF;
175: --
176:
177: END CREATE_CONTACTINFO;

Line 236: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

232: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
233: --
234: IF l_debug_on IS NULL
235: THEN
236: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
237: END IF;
238: --
239: IF l_debug_on THEN
240: WSH_DEBUG_SV.push(l_module_name);

Line 240: WSH_DEBUG_SV.push(l_module_name);

236: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
237: END IF;
238: --
239: IF l_debug_on THEN
240: WSH_DEBUG_SV.push(l_module_name);
241: --
242: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
243: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
244: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);

Line 242: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);

238: --
239: IF l_debug_on THEN
240: WSH_DEBUG_SV.push(l_module_name);
241: --
242: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
243: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
244: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
245: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
246: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);

Line 243: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);

239: IF l_debug_on THEN
240: WSH_DEBUG_SV.push(l_module_name);
241: --
242: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
243: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
244: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
245: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
246: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
247: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);

Line 244: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);

240: WSH_DEBUG_SV.push(l_module_name);
241: --
242: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
243: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
244: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
245: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
246: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
247: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
248: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY',P_PRIMARY);

Line 245: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);

241: --
242: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
243: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
244: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
245: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
246: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
247: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
248: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY',P_PRIMARY);
249: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);

Line 246: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);

242: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
243: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
244: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
245: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
246: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
247: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
248: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY',P_PRIMARY);
249: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
250: --Corrected Bug 5298638 - Parameter value of the contact type to be shown in log file.

Line 247: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);

243: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
244: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
245: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
246: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
247: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
248: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY',P_PRIMARY);
249: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
250: --Corrected Bug 5298638 - Parameter value of the contact type to be shown in log file.
251: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);

Line 248: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY',P_PRIMARY);

244: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
245: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
246: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
247: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
248: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY',P_PRIMARY);
249: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
250: --Corrected Bug 5298638 - Parameter value of the contact type to be shown in log file.
251: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
252: --Added Bug 5298638 - Parameter value of the status to be shown in log file.

Line 249: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);

245: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
246: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
247: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
248: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY',P_PRIMARY);
249: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
250: --Corrected Bug 5298638 - Parameter value of the contact type to be shown in log file.
251: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
252: --Added Bug 5298638 - Parameter value of the status to be shown in log file.
253: END IF;

Line 251: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);

247: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
248: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY',P_PRIMARY);
249: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
250: --Corrected Bug 5298638 - Parameter value of the contact type to be shown in log file.
251: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
252: --Added Bug 5298638 - Parameter value of the status to be shown in log file.
253: END IF;
254: --
255:

Line 293: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.Update_Contact_Point',WSH_DEBUG_SV.C_PROC_LEVEL);

289: --
290: -- Debug Statements
291: --
292: IF l_debug_on THEN
293: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.Update_Contact_Point',WSH_DEBUG_SV.C_PROC_LEVEL);
294: END IF;
295: --
296:
297: HZ_CONTACT_POINT_V2PUB.Update_Contact_Point

Line 319: WSH_DEBUG_SV.pop(l_module_name);

315: --
316: -- Debug Statements
317: --
318: IF l_debug_on THEN
319: WSH_DEBUG_SV.pop(l_module_name);
320: END IF;
321: --
322:
323: EXCEPTION

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

331: --
332: -- Debug Statements
333: --
334: IF l_debug_on THEN
335: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
336: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
337: END IF;
338: --
339:

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

332: -- Debug Statements
333: --
334: IF l_debug_on THEN
335: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
336: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
337: END IF;
338: --
339:
340:

Line 352: WSH_DEBUG_SV.logmsg(l_module_name,'HZ_FAIL_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

348: --
349: -- Debug Statements
350: --
351: IF l_debug_on THEN
352: WSH_DEBUG_SV.logmsg(l_module_name,'HZ_FAIL_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
353: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:HZ_FAIL_EXCEPTION');
354: END IF;
355: --
356:

Line 353: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:HZ_FAIL_EXCEPTION');

349: -- Debug Statements
350: --
351: IF l_debug_on THEN
352: WSH_DEBUG_SV.logmsg(l_module_name,'HZ_FAIL_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
353: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:HZ_FAIL_EXCEPTION');
354: END IF;
355: --
356:
357: WHEN OTHERS THEN

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

364: --
365: -- Debug Statements
366: --
367: IF l_debug_on THEN
368: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
369: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
370: END IF;
371: --
372:

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

365: -- Debug Statements
366: --
367: IF l_debug_on THEN
368: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
369: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
370: END IF;
371: --
372:
373: END UPDATE_CONTACTINFO;