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