DBA Data[Home] [Help]

APPS.WSH_SITE_CONTACT_INFO_PKG dependencies on WSH_DEBUG_SV

Line 74: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 78: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

81: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
82: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
83: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
84: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
85: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_LINE_TYPE',P_PHONE_LINE_TYPE);
86: END IF;
87: --
88:
89: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

116: --
117: -- Debug Statements
118: --
119: IF l_debug_on THEN
120: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.CREATE_CONTACT_POINT',WSH_DEBUG_SV.C_PROC_LEVEL);
121: END IF;
122: --
123:
124: HZ_CONTACT_POINT_V2PUB.Create_Contact_Point

Line 145: WSH_DEBUG_SV.pop(l_module_name);

141: --
142: -- Debug Statements
143: --
144: IF l_debug_on THEN
145: WSH_DEBUG_SV.pop(l_module_name);
146: END IF;
147: --
148:
149:

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

158: --
159: -- Debug Statements
160: --
161: IF l_debug_on THEN
162: WSH_DEBUG_SV.logmsg(l_module_name,'HZ_FAIL_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
163: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:HZ_FAIL_EXCEPTION');
164: END IF;
165: --
166:

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

159: -- Debug Statements
160: --
161: IF l_debug_on THEN
162: WSH_DEBUG_SV.logmsg(l_module_name,'HZ_FAIL_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
163: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:HZ_FAIL_EXCEPTION');
164: END IF;
165: --
166:
167: END CREATE_CONTACTINFO;

Line 221: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

217: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
218: --
219: IF l_debug_on IS NULL
220: THEN
221: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
222: END IF;
223: --
224: IF l_debug_on THEN
225: WSH_DEBUG_SV.push(l_module_name);

Line 225: WSH_DEBUG_SV.push(l_module_name);

221: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
222: END IF;
223: --
224: IF l_debug_on THEN
225: WSH_DEBUG_SV.push(l_module_name);
226: --
227: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
228: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
229: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);

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

223: --
224: IF l_debug_on THEN
225: WSH_DEBUG_SV.push(l_module_name);
226: --
227: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
228: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
229: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
230: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
231: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);

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

224: IF l_debug_on THEN
225: WSH_DEBUG_SV.push(l_module_name);
226: --
227: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
228: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
229: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
230: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
231: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
232: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_LINE_TYPE',P_PHONE_LINE_TYPE);

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

225: WSH_DEBUG_SV.push(l_module_name);
226: --
227: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
228: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
229: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
230: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
231: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
232: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_LINE_TYPE',P_PHONE_LINE_TYPE);
233: END IF;

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

226: --
227: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
228: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
229: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
230: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
231: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
232: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_LINE_TYPE',P_PHONE_LINE_TYPE);
233: END IF;
234: --

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

227: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
228: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
229: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
230: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
231: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
232: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_LINE_TYPE',P_PHONE_LINE_TYPE);
233: END IF;
234: --
235:

Line 232: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_LINE_TYPE',P_PHONE_LINE_TYPE);

228: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY_CODE',P_COUNTRY_CODE);
229: WSH_DEBUG_SV.log(l_module_name,'P_AREA_CODE',P_AREA_CODE);
230: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_NUMBER',P_PHONE_NUMBER);
231: WSH_DEBUG_SV.log(l_module_name,'P_EXTENSION',P_EXTENSION);
232: WSH_DEBUG_SV.log(l_module_name,'P_PHONE_LINE_TYPE',P_PHONE_LINE_TYPE);
233: END IF;
234: --
235:
236: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

268: --
269: -- Debug Statements
270: --
271: IF l_debug_on THEN
272: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.UPDATE_CONTACT_POINT',WSH_DEBUG_SV.C_PROC_LEVEL);
273: END IF;
274: --
275:
276: HZ_CONTACT_POINT_V2PUB.Update_Contact_Point

Line 298: WSH_DEBUG_SV.pop(l_module_name);

294: --
295: -- Debug Statements
296: --
297: IF l_debug_on THEN
298: WSH_DEBUG_SV.pop(l_module_name);
299: END IF;
300: --
301:
302:

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

311: --
312: -- Debug Statements
313: --
314: IF l_debug_on THEN
315: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
316: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
317: END IF;
318: --
319:

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

312: -- Debug Statements
313: --
314: IF l_debug_on THEN
315: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
316: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
317: END IF;
318: --
319:
320: WHEN HZ_FAIL_EXCEPTION THEN

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

327: --
328: -- Debug Statements
329: --
330: IF l_debug_on THEN
331: WSH_DEBUG_SV.logmsg(l_module_name,'HZ_FAIL_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:HZ_FAIL_EXCEPTION');
333: END IF;
334: --
335:

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

328: -- Debug Statements
329: --
330: IF l_debug_on THEN
331: WSH_DEBUG_SV.logmsg(l_module_name,'HZ_FAIL_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:HZ_FAIL_EXCEPTION');
333: END IF;
334: --
335:
336: WHEN OTHERS THEN

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

343: --
344: -- Debug Statements
345: --
346: IF l_debug_on THEN
347: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
348: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
349: END IF;
350: --
351:

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

344: -- Debug Statements
345: --
346: IF l_debug_on THEN
347: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
348: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
349: END IF;
350: --
351:
352: END UPDATE_CONTACTINFO;