eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_SITE_CONTACT_PERSON_PKG dependencies on WSH_DEBUG_SV

Line 91: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

87: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
88: --
89: IF l_debug_on IS NULL
90: THEN
91: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
92: END IF;
93: --
94: IF l_debug_on THEN
95: WSH_DEBUG_SV.push(l_module_name);

Line 95: WSH_DEBUG_SV.push(l_module_name);

91: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
92: END IF;
93: --
94: IF l_debug_on THEN
95: WSH_DEBUG_SV.push(l_module_name);
96: --
97: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
98: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
99: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);

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

93: --
94: IF l_debug_on THEN
95: WSH_DEBUG_SV.push(l_module_name);
96: --
97: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
98: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
99: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
100: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
101: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);

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

94: IF l_debug_on THEN
95: WSH_DEBUG_SV.push(l_module_name);
96: --
97: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
98: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
99: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
100: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
101: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
102: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_SITE_ID',P_CARRIER_SITE_ID);

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

95: WSH_DEBUG_SV.push(l_module_name);
96: --
97: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
98: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
99: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
100: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
101: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
102: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_SITE_ID',P_CARRIER_SITE_ID);
103: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NUMBER',P_CONTACT_NUMBER);

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

96: --
97: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
98: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
99: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
100: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
101: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
102: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_SITE_ID',P_CARRIER_SITE_ID);
103: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NUMBER',P_CONTACT_NUMBER);
104: WSH_DEBUG_SV.log(l_module_name,'P_LOAD_TENDER_FLAG',P_LOAD_TENDER_FLAG);

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

97: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_PARTY_ID',P_CARRIER_PARTY_ID);
98: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
99: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
100: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
101: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
102: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_SITE_ID',P_CARRIER_SITE_ID);
103: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NUMBER',P_CONTACT_NUMBER);
104: WSH_DEBUG_SV.log(l_module_name,'P_LOAD_TENDER_FLAG',P_LOAD_TENDER_FLAG);
105: WSH_DEBUG_SV.log(l_module_name,'P_JOB_TITLE',P_JOB_TITLE);

Line 102: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_SITE_ID',P_CARRIER_SITE_ID);

98: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
99: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
100: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
101: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
102: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_SITE_ID',P_CARRIER_SITE_ID);
103: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NUMBER',P_CONTACT_NUMBER);
104: WSH_DEBUG_SV.log(l_module_name,'P_LOAD_TENDER_FLAG',P_LOAD_TENDER_FLAG);
105: WSH_DEBUG_SV.log(l_module_name,'P_JOB_TITLE',P_JOB_TITLE);
106: WSH_DEBUG_SV.log(l_module_name,'P_EMAIL_ADDRESS',P_EMAIL_ADDRESS);

Line 103: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NUMBER',P_CONTACT_NUMBER);

99: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
100: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
101: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
102: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_SITE_ID',P_CARRIER_SITE_ID);
103: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NUMBER',P_CONTACT_NUMBER);
104: WSH_DEBUG_SV.log(l_module_name,'P_LOAD_TENDER_FLAG',P_LOAD_TENDER_FLAG);
105: WSH_DEBUG_SV.log(l_module_name,'P_JOB_TITLE',P_JOB_TITLE);
106: WSH_DEBUG_SV.log(l_module_name,'P_EMAIL_ADDRESS',P_EMAIL_ADDRESS);
107: END IF;

Line 104: WSH_DEBUG_SV.log(l_module_name,'P_LOAD_TENDER_FLAG',P_LOAD_TENDER_FLAG);

100: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
101: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
102: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_SITE_ID',P_CARRIER_SITE_ID);
103: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NUMBER',P_CONTACT_NUMBER);
104: WSH_DEBUG_SV.log(l_module_name,'P_LOAD_TENDER_FLAG',P_LOAD_TENDER_FLAG);
105: WSH_DEBUG_SV.log(l_module_name,'P_JOB_TITLE',P_JOB_TITLE);
106: WSH_DEBUG_SV.log(l_module_name,'P_EMAIL_ADDRESS',P_EMAIL_ADDRESS);
107: END IF;
108: --

Line 105: WSH_DEBUG_SV.log(l_module_name,'P_JOB_TITLE',P_JOB_TITLE);

101: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
102: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_SITE_ID',P_CARRIER_SITE_ID);
103: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NUMBER',P_CONTACT_NUMBER);
104: WSH_DEBUG_SV.log(l_module_name,'P_LOAD_TENDER_FLAG',P_LOAD_TENDER_FLAG);
105: WSH_DEBUG_SV.log(l_module_name,'P_JOB_TITLE',P_JOB_TITLE);
106: WSH_DEBUG_SV.log(l_module_name,'P_EMAIL_ADDRESS',P_EMAIL_ADDRESS);
107: END IF;
108: --
109:

Line 106: WSH_DEBUG_SV.log(l_module_name,'P_EMAIL_ADDRESS',P_EMAIL_ADDRESS);

102: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_SITE_ID',P_CARRIER_SITE_ID);
103: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NUMBER',P_CONTACT_NUMBER);
104: WSH_DEBUG_SV.log(l_module_name,'P_LOAD_TENDER_FLAG',P_LOAD_TENDER_FLAG);
105: WSH_DEBUG_SV.log(l_module_name,'P_JOB_TITLE',P_JOB_TITLE);
106: WSH_DEBUG_SV.log(l_module_name,'P_EMAIL_ADDRESS',P_EMAIL_ADDRESS);
107: END IF;
108: --
109:
110: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

127: --
128: -- Debug Statements
129: --
130: IF l_debug_on THEN
131: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_V2PUB.Create_Person',WSH_DEBUG_SV.C_PROC_LEVEL);
132: END IF;
133: --
134: -- Set the Autogenerate Party Number to 'Yes'.
135: -- Bug 7391414 Setting the profile option 'HZ GENERATE PARTY NUMBER' to Yes if it is No or Null

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

137: l_hz_profile_option := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');
138:
139: IF (l_hz_profile_option = 'N' or l_hz_profile_option is null ) THEN
140: IF l_debug_on THEN
141: WSH_DEBUG_SV.logmsg(l_module_name,'Setting profile option HZ_GENERATE_PARTY_NUMBER to Yes');
142: END IF;
143: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER','Y');
144: l_hz_profile_set := true;
145: END IF;

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

158:
159: -- Bug 7391414 Setting the profile option 'HZ GENERATE PARTY NUMBER' to previous value
160: IF l_hz_profile_set THEN
161: IF l_debug_on THEN
162: WSH_DEBUG_SV.logmsg(l_module_name,'Reverting the value of profile option HZ_GENERATE_PARTY_NUMBER');
163: END IF;
164: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER',l_hz_profile_option);
165: END IF;
166:

Line 199: WSH_DEBUG_SV.logmsg(l_module_name,'Setting profile option HZ_GENERATE_CONTACT_NUMBER to No');

195: l_hz_profile_option := fnd_profile.value('HZ_GENERATE_CONTACT_NUMBER');
196:
197: IF (l_hz_profile_option = 'Y' or l_hz_profile_option is null ) THEN
198: IF l_debug_on THEN
199: WSH_DEBUG_SV.logmsg(l_module_name,'Setting profile option HZ_GENERATE_CONTACT_NUMBER to No');
200: END IF;
201: fnd_profile.put('HZ_GENERATE_CONTACT_NUMBER','N');
202: l_hz_profile_set := true;
203: END IF;

Line 212: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_CONTACT_V2PUB.create_org_contact',WSH_DEBUG_SV.C_PROC_LEVEL);

208: --
209: -- Debug Statements
210: --
211: IF l_debug_on THEN
212: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_CONTACT_V2PUB.create_org_contact',WSH_DEBUG_SV.C_PROC_LEVEL);
213: END IF;
214: --
215:
216: HZ_PARTY_CONTACT_V2PUB.create_org_contact (

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

225:
226: -- Bug 7391414 Setting the profile option 'HZ GENERATE CONTACT NUMBER' to previous value
227: IF l_hz_profile_set THEN
228: IF l_debug_on THEN
229: WSH_DEBUG_SV.logmsg(l_module_name,'Reverting the value of profile option HZ_GENERATE_CONTACT_NUMBER');
230: END IF;
231: fnd_profile.put('HZ_GENERATE_CONTACT_NUMBER',l_hz_profile_option);
232: END IF;
233:

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

251: --
252: -- Debug Statements
253: --
254: IF l_debug_on THEN
255: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.Create_Contact_Point',WSH_DEBUG_SV.C_PROC_LEVEL);
256: END IF;
257: --
258: -- Bug 2754631
259: HZ_CONTACT_POINT_V2PUB.Create_Contact_Point (

Line 281: WSH_DEBUG_SV.pop(l_module_name);

277: --
278: -- Debug Statements
279: --
280: IF l_debug_on THEN
281: WSH_DEBUG_SV.pop(l_module_name);
282: END IF;
283: --
284:
285: EXCEPTION

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

293: --
294: -- Debug Statements
295: --
296: IF l_debug_on THEN
297: WSH_DEBUG_SV.logmsg(l_module_name,'HZ_FAIL_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
298: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:HZ_FAIL_EXCEPTION');
299: END IF;
300: --
301:

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

294: -- Debug Statements
295: --
296: IF l_debug_on THEN
297: WSH_DEBUG_SV.logmsg(l_module_name,'HZ_FAIL_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
298: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:HZ_FAIL_EXCEPTION');
299: END IF;
300: --
301:
302: END CREATE_CONTACTPERSON;

Line 377: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

373: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
374: --
375: IF l_debug_on IS NULL
376: THEN
377: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
378: END IF;
379: --
380: IF l_debug_on THEN
381: WSH_DEBUG_SV.push(l_module_name);

Line 381: WSH_DEBUG_SV.push(l_module_name);

377: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
378: END IF;
379: --
380: IF l_debug_on THEN
381: WSH_DEBUG_SV.push(l_module_name);
382: --
383: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_PARTY_ID',P_PERSON_PARTY_ID);
384: WSH_DEBUG_SV.log(l_module_name,'P_ORG_CONTACT_ID',P_ORG_CONTACT_ID);
385: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);

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

379: --
380: IF l_debug_on THEN
381: WSH_DEBUG_SV.push(l_module_name);
382: --
383: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_PARTY_ID',P_PERSON_PARTY_ID);
384: WSH_DEBUG_SV.log(l_module_name,'P_ORG_CONTACT_ID',P_ORG_CONTACT_ID);
385: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
386: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
387: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);

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

380: IF l_debug_on THEN
381: WSH_DEBUG_SV.push(l_module_name);
382: --
383: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_PARTY_ID',P_PERSON_PARTY_ID);
384: WSH_DEBUG_SV.log(l_module_name,'P_ORG_CONTACT_ID',P_ORG_CONTACT_ID);
385: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
386: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
387: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
388: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);

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

381: WSH_DEBUG_SV.push(l_module_name);
382: --
383: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_PARTY_ID',P_PERSON_PARTY_ID);
384: WSH_DEBUG_SV.log(l_module_name,'P_ORG_CONTACT_ID',P_ORG_CONTACT_ID);
385: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
386: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
387: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
388: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
389: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NUMBER',P_CONTACT_NUMBER);

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

382: --
383: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_PARTY_ID',P_PERSON_PARTY_ID);
384: WSH_DEBUG_SV.log(l_module_name,'P_ORG_CONTACT_ID',P_ORG_CONTACT_ID);
385: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
386: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
387: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
388: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
389: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NUMBER',P_CONTACT_NUMBER);
390: WSH_DEBUG_SV.log(l_module_name,'P_LOAD_TENDER_FLAG',P_LOAD_TENDER_FLAG);

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

383: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_PARTY_ID',P_PERSON_PARTY_ID);
384: WSH_DEBUG_SV.log(l_module_name,'P_ORG_CONTACT_ID',P_ORG_CONTACT_ID);
385: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
386: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
387: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
388: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
389: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NUMBER',P_CONTACT_NUMBER);
390: WSH_DEBUG_SV.log(l_module_name,'P_LOAD_TENDER_FLAG',P_LOAD_TENDER_FLAG);
391: WSH_DEBUG_SV.log(l_module_name,'P_JOB_TITLE',P_JOB_TITLE);

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

384: WSH_DEBUG_SV.log(l_module_name,'P_ORG_CONTACT_ID',P_ORG_CONTACT_ID);
385: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
386: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
387: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
388: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
389: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NUMBER',P_CONTACT_NUMBER);
390: WSH_DEBUG_SV.log(l_module_name,'P_LOAD_TENDER_FLAG',P_LOAD_TENDER_FLAG);
391: WSH_DEBUG_SV.log(l_module_name,'P_JOB_TITLE',P_JOB_TITLE);
392: WSH_DEBUG_SV.log(l_module_name,'P_EMAIL_ADDRESS',P_EMAIL_ADDRESS);

Line 389: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NUMBER',P_CONTACT_NUMBER);

385: WSH_DEBUG_SV.log(l_module_name,'P_STATUS',P_STATUS);
386: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
387: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
388: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
389: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NUMBER',P_CONTACT_NUMBER);
390: WSH_DEBUG_SV.log(l_module_name,'P_LOAD_TENDER_FLAG',P_LOAD_TENDER_FLAG);
391: WSH_DEBUG_SV.log(l_module_name,'P_JOB_TITLE',P_JOB_TITLE);
392: WSH_DEBUG_SV.log(l_module_name,'P_EMAIL_ADDRESS',P_EMAIL_ADDRESS);
393: END IF;

Line 390: WSH_DEBUG_SV.log(l_module_name,'P_LOAD_TENDER_FLAG',P_LOAD_TENDER_FLAG);

386: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_NAME_PRE_ADJUNCT',P_PERSON_NAME_PRE_ADJUNCT);
387: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
388: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
389: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NUMBER',P_CONTACT_NUMBER);
390: WSH_DEBUG_SV.log(l_module_name,'P_LOAD_TENDER_FLAG',P_LOAD_TENDER_FLAG);
391: WSH_DEBUG_SV.log(l_module_name,'P_JOB_TITLE',P_JOB_TITLE);
392: WSH_DEBUG_SV.log(l_module_name,'P_EMAIL_ADDRESS',P_EMAIL_ADDRESS);
393: END IF;
394: --

Line 391: WSH_DEBUG_SV.log(l_module_name,'P_JOB_TITLE',P_JOB_TITLE);

387: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_FIRST_NAME',P_PERSON_FIRST_NAME);
388: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
389: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NUMBER',P_CONTACT_NUMBER);
390: WSH_DEBUG_SV.log(l_module_name,'P_LOAD_TENDER_FLAG',P_LOAD_TENDER_FLAG);
391: WSH_DEBUG_SV.log(l_module_name,'P_JOB_TITLE',P_JOB_TITLE);
392: WSH_DEBUG_SV.log(l_module_name,'P_EMAIL_ADDRESS',P_EMAIL_ADDRESS);
393: END IF;
394: --
395:

Line 392: WSH_DEBUG_SV.log(l_module_name,'P_EMAIL_ADDRESS',P_EMAIL_ADDRESS);

388: WSH_DEBUG_SV.log(l_module_name,'P_PERSON_LAST_NAME',P_PERSON_LAST_NAME);
389: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NUMBER',P_CONTACT_NUMBER);
390: WSH_DEBUG_SV.log(l_module_name,'P_LOAD_TENDER_FLAG',P_LOAD_TENDER_FLAG);
391: WSH_DEBUG_SV.log(l_module_name,'P_JOB_TITLE',P_JOB_TITLE);
392: WSH_DEBUG_SV.log(l_module_name,'P_EMAIL_ADDRESS',P_EMAIL_ADDRESS);
393: END IF;
394: --
395:
396: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

421: --
422: -- Debug Statements
423: --
424: IF l_debug_on THEN
425: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_V2PUB.Update_Person',WSH_DEBUG_SV.C_PROC_LEVEL);
426: END IF;
427: --
428:
429: HZ_PARTY_V2PUB.Update_Person

Line 464: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_CONTACT_V2PUB.Update_Org_Contact',WSH_DEBUG_SV.C_PROC_LEVEL);

460: --
461: -- Debug Statements
462: --
463: IF l_debug_on THEN
464: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_CONTACT_V2PUB.Update_Org_Contact',WSH_DEBUG_SV.C_PROC_LEVEL);
465: END IF;
466: --
467:
468: HZ_PARTY_CONTACT_V2PUB.Update_Org_Contact (

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

486: --
487: -- Debug Statements
488: --
489: IF l_debug_on THEN
490: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program Unit HZ_CONTACT_POINT_V2PUB.Update_Contact_Point',WSH_DEBUG_SV.C_PROC_LEVEL);
491: END IF;
492: --
493:
494: OPEN Get_Cont_Point_Version;

Line 516: WSH_DEBUG_SV.pop(l_module_name);

512: --
513: -- Debug Statements
514: --
515: IF l_debug_on THEN
516: WSH_DEBUG_SV.pop(l_module_name);
517: END IF;
518: --
519:
520: EXCEPTION

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

528: --
529: -- Debug Statements
530: --
531: IF l_debug_on THEN
532: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
533: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
534: END IF;
535: --
536:

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

529: -- Debug Statements
530: --
531: IF l_debug_on THEN
532: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
533: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
534: END IF;
535: --
536:
537: WHEN HZ_FAIL_EXCEPTION THEN

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

544: --
545: -- Debug Statements
546: --
547: IF l_debug_on THEN
548: WSH_DEBUG_SV.logmsg(l_module_name,'HZ_FAIL_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
549: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:HZ_FAIL_EXCEPTION');
550: END IF;
551: --
552:

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

545: -- Debug Statements
546: --
547: IF l_debug_on THEN
548: WSH_DEBUG_SV.logmsg(l_module_name,'HZ_FAIL_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
549: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:HZ_FAIL_EXCEPTION');
550: END IF;
551: --
552:
553: WHEN OTHERS THEN

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

560: --
561: -- Debug Statements
562: --
563: IF l_debug_on THEN
564: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
565: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
566: END IF;
567: --
568:

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

561: -- Debug Statements
562: --
563: IF l_debug_on THEN
564: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
565: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
566: END IF;
567: --
568:
569: END UPDATE_CONTACTPERSON;