DBA Data[Home] [Help]

APPS.WSH_CONTACT_PERSON_PKG dependencies on WSH_DEBUG_SV

Line 78: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 82: WSH_DEBUG_SV.push(l_module_name);

78: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
79: END IF;
80: --
81: IF l_debug_on THEN
82: WSH_DEBUG_SV.push(l_module_name);
83: --
84: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
85: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
86: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);

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

80: --
81: IF l_debug_on THEN
82: WSH_DEBUG_SV.push(l_module_name);
83: --
84: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
85: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
86: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
87: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
88: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);

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

81: IF l_debug_on THEN
82: WSH_DEBUG_SV.push(l_module_name);
83: --
84: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
85: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
86: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
87: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
88: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
89: END IF;

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

82: WSH_DEBUG_SV.push(l_module_name);
83: --
84: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
85: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
86: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
87: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
88: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
89: END IF;
90: --

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

83: --
84: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
85: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
86: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
87: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
88: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
89: END IF;
90: --
91:

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

84: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
85: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
86: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
87: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
88: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
89: END IF;
90: --
91:
92: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 116: WSH_DEBUG_SV.logmsg(l_module_name,'Setting profile option HZ_GENERATE_PARTY_NUMBER to Yes');

112: l_hz_profile_option := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');
113:
114: IF (l_hz_profile_option = 'N' or l_hz_profile_option is null ) THEN
115: IF l_debug_on THEN
116: WSH_DEBUG_SV.logmsg(l_module_name,'Setting profile option HZ_GENERATE_PARTY_NUMBER to Yes');
117: END IF;
118: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER','Y');
119: l_hz_profile_set := true;
120: END IF;

Line 126: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_V2PUB.CREATE_PERSON',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_PARTY_V2PUB.CREATE_PERSON',WSH_DEBUG_SV.C_PROC_LEVEL);
127: END IF;
128: --
129:
130: HZ_PARTY_V2PUB.Create_Person

Line 145: WSH_DEBUG_SV.logmsg(l_module_name,'Reverting the value of profile option HZ_GENERATE_PARTY_NUMBER');

141:
142: -- Bug 7391414 Setting the profile option 'HZ GENERATE PARTY NUMBER' to previous value
143: IF l_hz_profile_set THEN
144: IF l_debug_on THEN
145: WSH_DEBUG_SV.logmsg(l_module_name,'Reverting the value of profile option HZ_GENERATE_PARTY_NUMBER');
146: END IF;
147: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER',l_hz_profile_option);
148: END IF;
149:

Line 181: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_RELATIONSHIP_V2PUB.CREATE_RELATIONSHIP',WSH_DEBUG_SV.C_PROC_LEVEL);

177: --
178: -- Debug Statements
179: --
180: IF l_debug_on THEN
181: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_RELATIONSHIP_V2PUB.CREATE_RELATIONSHIP',WSH_DEBUG_SV.C_PROC_LEVEL);
182: END IF;
183: --
184:
185: HZ_RELATIONSHIP_V2PUB.Create_Relationship

Line 207: WSH_DEBUG_SV.pop(l_module_name);

203: --
204: -- Debug Statements
205: --
206: IF l_debug_on THEN
207: WSH_DEBUG_SV.pop(l_module_name);
208: END IF;
209: --
210:
211: EXCEPTION

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

219: --
220: -- Debug Statements
221: --
222: IF l_debug_on THEN
223: WSH_DEBUG_SV.logmsg(l_module_name,'HZ_FAIL_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
224: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:HZ_FAIL_EXCEPTION');
225: END IF;
226: --
227:

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

220: -- Debug Statements
221: --
222: IF l_debug_on THEN
223: WSH_DEBUG_SV.logmsg(l_module_name,'HZ_FAIL_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
224: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:HZ_FAIL_EXCEPTION');
225: END IF;
226: --
227:
228: END CREATE_CONTACTPERSON;

Line 280: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

276: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
277: --
278: IF l_debug_on IS NULL
279: THEN
280: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
281: END IF;
282: --
283: IF l_debug_on THEN
284: WSH_DEBUG_SV.push(l_module_name);

Line 284: WSH_DEBUG_SV.push(l_module_name);

280: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
281: END IF;
282: --
283: IF l_debug_on THEN
284: WSH_DEBUG_SV.push(l_module_name);
285: --
286: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
287: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_PARTY_ID',P_PERSON_PARTY_ID);
288: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);

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

282: --
283: IF l_debug_on THEN
284: WSH_DEBUG_SV.push(l_module_name);
285: --
286: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
287: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_PARTY_ID',P_PERSON_PARTY_ID);
288: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
289: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
290: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);

Line 287: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_PARTY_ID',P_PERSON_PARTY_ID);

283: IF l_debug_on THEN
284: WSH_DEBUG_SV.push(l_module_name);
285: --
286: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
287: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_PARTY_ID',P_PERSON_PARTY_ID);
288: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
289: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
290: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
291: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);

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

284: WSH_DEBUG_SV.push(l_module_name);
285: --
286: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
287: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_PARTY_ID',P_PERSON_PARTY_ID);
288: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
289: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
290: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
291: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
292: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);

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

285: --
286: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
287: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_PARTY_ID',P_PERSON_PARTY_ID);
288: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
289: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
290: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
291: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
292: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
293: END IF;

Line 290: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);

286: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
287: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_PARTY_ID',P_PERSON_PARTY_ID);
288: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
289: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
290: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
291: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
292: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
293: END IF;
294: --

Line 291: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);

287: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_PARTY_ID',P_PERSON_PARTY_ID);
288: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
289: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
290: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
291: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
292: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
293: END IF;
294: --
295:

Line 292: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);

288: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_POINT_ID',P_CONTACT_POINT_ID);
289: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
290: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
291: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
292: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
293: END IF;
294: --
295:
296: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 325: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_V2PUB.UPDATE_PERSON',WSH_DEBUG_SV.C_PROC_LEVEL);

321: --
322: -- Debug Statements
323: --
324: IF l_debug_on THEN
325: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_V2PUB.UPDATE_PERSON',WSH_DEBUG_SV.C_PROC_LEVEL);
326: END IF;
327: --
328:
329: HZ_PARTY_V2PUB.Update_Person

Line 349: WSH_DEBUG_SV.pop(l_module_name);

345: --
346: -- Debug Statements
347: --
348: IF l_debug_on THEN
349: WSH_DEBUG_SV.pop(l_module_name);
350: END IF;
351: --
352:
353: EXCEPTION

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

361: --
362: -- Debug Statements
363: --
364: IF l_debug_on THEN
365: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
366: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
367: END IF;
368: --
369:

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

362: -- Debug Statements
363: --
364: IF l_debug_on THEN
365: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
366: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
367: END IF;
368: --
369:
370:

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

378: --
379: -- Debug Statements
380: --
381: IF l_debug_on THEN
382: WSH_DEBUG_SV.logmsg(l_module_name,'HZ_FAIL_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
383: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:HZ_FAIL_EXCEPTION');
384: END IF;
385: --
386:

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

379: -- Debug Statements
380: --
381: IF l_debug_on THEN
382: WSH_DEBUG_SV.logmsg(l_module_name,'HZ_FAIL_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
383: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:HZ_FAIL_EXCEPTION');
384: END IF;
385: --
386:
387: WHEN OTHERS THEN

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

394: --
395: -- Debug Statements
396: --
397: IF l_debug_on THEN
398: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
399: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
400: END IF;
401: --
402:

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

395: -- Debug Statements
396: --
397: IF l_debug_on THEN
398: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
399: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
400: END IF;
401: --
402:
403: END UPDATE_CONTACTPERSON;