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_OTM_SYNC_REF_DATA_PKG dependencies on WSH_DEBUG_SV

Line 72: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

68: --
69: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
70: --
71: IF l_debug_on IS NULL THEN
72: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
73: END IF;
74:
75: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
76: x_send_allowed := FALSE;

Line 79: WSH_DEBUG_SV.push(l_module_name);

75: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
76: x_send_allowed := FALSE;
77:
78: IF l_debug_on THEN
79: WSH_DEBUG_SV.push(l_module_name);
80: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID ',p_entity_id);
81: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ENTITY_ID ',p_parent_entity_id);
82: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE ',p_entity_type);
83: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_UPDATED_DATE ',p_entity_updated_date);

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

76: x_send_allowed := FALSE;
77:
78: IF l_debug_on THEN
79: WSH_DEBUG_SV.push(l_module_name);
80: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID ',p_entity_id);
81: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ENTITY_ID ',p_parent_entity_id);
82: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE ',p_entity_type);
83: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_UPDATED_DATE ',p_entity_updated_date);
84: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);

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

77:
78: IF l_debug_on THEN
79: WSH_DEBUG_SV.push(l_module_name);
80: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID ',p_entity_id);
81: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ENTITY_ID ',p_parent_entity_id);
82: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE ',p_entity_type);
83: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_UPDATED_DATE ',p_entity_updated_date);
84: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);
85: END IF;

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

78: IF l_debug_on THEN
79: WSH_DEBUG_SV.push(l_module_name);
80: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID ',p_entity_id);
81: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ENTITY_ID ',p_parent_entity_id);
82: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE ',p_entity_type);
83: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_UPDATED_DATE ',p_entity_updated_date);
84: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);
85: END IF;
86:

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

79: WSH_DEBUG_SV.push(l_module_name);
80: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID ',p_entity_id);
81: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ENTITY_ID ',p_parent_entity_id);
82: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE ',p_entity_type);
83: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_UPDATED_DATE ',p_entity_updated_date);
84: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);
85: END IF;
86:
87: --Check whether the entity exists in wosrd

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

80: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID ',p_entity_id);
81: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ENTITY_ID ',p_parent_entity_id);
82: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE ',p_entity_type);
83: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_UPDATED_DATE ',p_entity_updated_date);
84: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);
85: END IF;
86:
87: --Check whether the entity exists in wosrd
88: OPEN c_entity_exists(p_entity_id, p_entity_type, p_parent_entity_id);

Line 100: WSH_DEBUG_SV.log(l_module_name,'l_sync_ref_id IS NULL');

96: --If its null that means the entity has never been sent to GLOG
97: --and we have to make and entry both in WOSRD and WOSRDL.
98: IF l_sync_ref_id is null THEN
99: IF l_debug_on THEN
100: WSH_DEBUG_SV.log(l_module_name,'l_sync_ref_id IS NULL');
101: END IF;
102:
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.INSERT_ROW_SYNC_REF_DATA',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 104: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.INSERT_ROW_SYNC_REF_DATA',WSH_DEBUG_SV.C_PROC_LEVEL);

100: WSH_DEBUG_SV.log(l_module_name,'l_sync_ref_id IS NULL');
101: END IF;
102:
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.INSERT_ROW_SYNC_REF_DATA',WSH_DEBUG_SV.C_PROC_LEVEL);
105: END IF;
106: insert_row_sync_ref_data(p_entity_id => p_entity_id ,
107: p_parent_entity_id => p_parent_entity_id,
108: p_entity_type => p_entity_type,

Line 115: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

111: x_substitute_entity => l_substitute_entity,
112: x_return_status => l_return_status
113: );
114: IF l_debug_on THEN
115: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
116: END IF;
117: --
118: wsh_util_core.api_post_call(
119: p_return_status => l_return_status,

Line 124: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.INSERT_ROW_SYNC_REF_DATA_LOG',WSH_DEBUG_SV.C_PROC_LEVEL);

120: x_num_warnings => l_num_warnings,
121: x_num_errors => l_num_errors);
122:
123: IF l_debug_on THEN
124: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.INSERT_ROW_SYNC_REF_DATA_LOG',WSH_DEBUG_SV.C_PROC_LEVEL);
125: END IF;
126: insert_row_sync_ref_data_log (p_sync_ref_id => l_sync_ref_id,
127: p_transmission_id => p_transmission_id,
128: p_entity_type => p_entity_type,

Line 132: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

128: p_entity_type => p_entity_type,
129: x_return_status => l_return_status
130: );
131: IF l_debug_on THEN
132: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
133: END IF;
134: --
135: wsh_util_core.api_post_call(
136: p_return_status => l_return_status,

Line 143: WSH_DEBUG_SV.log(l_module_name,'l_sync_ref_id ', l_sync_ref_id);

139:
140: x_send_allowed := true;
141: ELSE --means that entry in WOSRD is already there and just have to check the dates.
142: IF l_debug_on THEN
143: WSH_DEBUG_SV.log(l_module_name,'l_sync_ref_id ', l_sync_ref_id);
144: WSH_DEBUG_SV.log(l_module_name,'p_entity_updated_date ', p_entity_updated_date);
145: WSH_DEBUG_SV.log(l_module_name,'l_last_sent_date ', l_last_sent_date);
146: END IF;
147:

Line 144: WSH_DEBUG_SV.log(l_module_name,'p_entity_updated_date ', p_entity_updated_date);

140: x_send_allowed := true;
141: ELSE --means that entry in WOSRD is already there and just have to check the dates.
142: IF l_debug_on THEN
143: WSH_DEBUG_SV.log(l_module_name,'l_sync_ref_id ', l_sync_ref_id);
144: WSH_DEBUG_SV.log(l_module_name,'p_entity_updated_date ', p_entity_updated_date);
145: WSH_DEBUG_SV.log(l_module_name,'l_last_sent_date ', l_last_sent_date);
146: END IF;
147:
148: IF p_entity_updated_date >= l_last_sent_date THEN

Line 145: WSH_DEBUG_SV.log(l_module_name,'l_last_sent_date ', l_last_sent_date);

141: ELSE --means that entry in WOSRD is already there and just have to check the dates.
142: IF l_debug_on THEN
143: WSH_DEBUG_SV.log(l_module_name,'l_sync_ref_id ', l_sync_ref_id);
144: WSH_DEBUG_SV.log(l_module_name,'p_entity_updated_date ', p_entity_updated_date);
145: WSH_DEBUG_SV.log(l_module_name,'l_last_sent_date ', l_last_sent_date);
146: END IF;
147:
148: IF p_entity_updated_date >= l_last_sent_date THEN
149: -- OR to_number(sysdate - l_last_sent_date) <= 1 THEN -- Bugfix 14526032

Line 152: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.INSERT_ROW_SYNC_REF_DATA_LOG',WSH_DEBUG_SV.C_PROC_LEVEL);

148: IF p_entity_updated_date >= l_last_sent_date THEN
149: -- OR to_number(sysdate - l_last_sent_date) <= 1 THEN -- Bugfix 14526032
150:
151: IF l_debug_on THEN
152: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.INSERT_ROW_SYNC_REF_DATA_LOG',WSH_DEBUG_SV.C_PROC_LEVEL);
153: END IF;
154:
155: insert_row_sync_ref_data_log (p_sync_ref_id => l_sync_ref_id,
156: p_transmission_id => p_transmission_id,

Line 161: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

157: p_entity_type => p_entity_type,
158: x_return_status => l_return_status
159: );
160: IF l_debug_on THEN
161: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
162: END IF;
163: --
164: wsh_util_core.api_post_call(
165: p_return_status => l_return_status,

Line 182: WSH_DEBUG_SV.pop(l_module_name);

178: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
179: END IF;
180:
181: IF l_debug_on THEN
182: WSH_DEBUG_SV.pop(l_module_name);
183: END IF;
184:
185: EXCEPTION
186: WHEN e_entity_type_error THEN

Line 189: WSH_DEBUG_SV.logmsg(l_module_name,'wrong entity type passed',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

185: EXCEPTION
186: WHEN e_entity_type_error THEN
187: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
188: IF l_debug_on THEN
189: WSH_DEBUG_SV.logmsg(l_module_name,'wrong entity type passed',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WRONG_ENTITY_TYPE');
191: raise;
192: END IF;
193: WHEN OTHERS THEN

Line 190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WRONG_ENTITY_TYPE');

186: WHEN e_entity_type_error THEN
187: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
188: IF l_debug_on THEN
189: WSH_DEBUG_SV.logmsg(l_module_name,'wrong entity type passed',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WRONG_ENTITY_TYPE');
191: raise;
192: END IF;
193: WHEN OTHERS THEN
194: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

192: END IF;
193: WHEN OTHERS THEN
194: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
195: IF l_debug_on THEN
196: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
197: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
198: raise;
199: END IF;
200:

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

193: WHEN OTHERS THEN
194: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
195: IF l_debug_on THEN
196: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
197: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
198: raise;
199: END IF;
200:
201: END is_ref_data_send_reqd;

Line 248: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

244: --
245: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
246: --
247: IF l_debug_on IS NULL THEN
248: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
249: END IF;
250:
251: IF l_debug_on THEN
252: WSH_DEBUG_SV.push(l_module_name);

Line 252: WSH_DEBUG_SV.push(l_module_name);

248: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
249: END IF;
250:
251: IF l_debug_on THEN
252: WSH_DEBUG_SV.push(l_module_name);
253: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);
254: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_STATUS ',p_transmission_status);
255: END IF;
256:

Line 253: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);

249: END IF;
250:
251: IF l_debug_on THEN
252: WSH_DEBUG_SV.push(l_module_name);
253: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);
254: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_STATUS ',p_transmission_status);
255: END IF;
256:
257: IF p_transmission_status = 'S' THEN

Line 254: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_STATUS ',p_transmission_status);

250:
251: IF l_debug_on THEN
252: WSH_DEBUG_SV.push(l_module_name);
253: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);
254: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_STATUS ',p_transmission_status);
255: END IF;
256:
257: IF p_transmission_status = 'S' THEN
258: --Get the sync ref ids for the transmission id

Line 278: WSH_DEBUG_SV.log(l_module_name,'Obtained the lock for l_sync_ref_id ', l_sync_ref_id);

274:
275: CLOSE c_lock_parent_table;
276:
277: IF l_debug_on THEN
278: WSH_DEBUG_SV.log(l_module_name,'Obtained the lock for l_sync_ref_id ', l_sync_ref_id);
279: END IF;
280:
281: --Obtain the first sent_date for the l_sync_ref_id
282: OPEN c_get_sent_date(l_sync_ref_id);

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

283: FETCH c_get_sent_date into l_sent_date;
284: CLOSE c_get_sent_date;
285:
286: IF l_debug_on THEN
287: WSH_DEBUG_SV.log(l_module_name,'sent_date', l_sent_date);
288: END IF;
289:
290: --Update last_sent_date of WOSRD with sent_date of WOSRDL.sent_date
291: UPDATE wsh_otm_sync_ref_data

Line 296: WSH_DEBUG_SV.log(l_module_name,'Updated ', SQL%ROWCOUNT);

292: SET last_sent_date = l_sent_date
293: WHERE sync_ref_id = l_sync_ref_id;
294:
295: IF l_debug_on THEN
296: WSH_DEBUG_SV.log(l_module_name,'Updated ', SQL%ROWCOUNT);
297: END IF;
298:
299: --Delete data from WOSRDL for l_sync_ref_id
300: DELETE

Line 317: WSH_DEBUG_SV.log(l_module_name,'Error case. So deleting all the data from WOSRDL for transmission_id ', p_transmission_id);

313: CLOSE c_get_sync_ref_id;
314: ELSE
315: --Since this is an error case delete all the data from WOSRDL for given transmission_id
316: IF l_debug_on THEN
317: WSH_DEBUG_SV.log(l_module_name,'Error case. So deleting all the data from WOSRDL for transmission_id ', p_transmission_id);
318: END IF;
319:
320: DELETE
321: FROM wsh_otm_sync_ref_data_log

Line 328: WSH_DEBUG_SV.pop(l_module_name);

324:
325: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
326:
327: IF l_debug_on THEN
328: WSH_DEBUG_SV.pop(l_module_name);
329: END IF;
330:
331: EXCEPTION
332: WHEN OTHERS THEN

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

331: EXCEPTION
332: WHEN OTHERS THEN
333: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
334: IF l_debug_on THEN
335: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
336: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
337: raise;
338: END IF;
339:

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

332: WHEN OTHERS THEN
333: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
334: IF l_debug_on THEN
335: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
336: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
337: raise;
338: END IF;
339:
340: END update_ref_data;

Line 377: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

373: --
374: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
375: --
376: IF l_debug_on IS NULL 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: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID ',p_entity_id);
383: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ENTITY_ID ',p_parent_entity_id);
384: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE ',p_entity_type);
385: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);

Line 382: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID ',p_entity_id);

378: END IF;
379:
380: IF l_debug_on THEN
381: WSH_DEBUG_SV.push(l_module_name);
382: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID ',p_entity_id);
383: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ENTITY_ID ',p_parent_entity_id);
384: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE ',p_entity_type);
385: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);
386: END IF;

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

379:
380: IF l_debug_on THEN
381: WSH_DEBUG_SV.push(l_module_name);
382: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID ',p_entity_id);
383: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ENTITY_ID ',p_parent_entity_id);
384: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE ',p_entity_type);
385: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);
386: END IF;
387:

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

380: IF l_debug_on THEN
381: WSH_DEBUG_SV.push(l_module_name);
382: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID ',p_entity_id);
383: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ENTITY_ID ',p_parent_entity_id);
384: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE ',p_entity_type);
385: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);
386: END IF;
387:
388: --Check whether the input entity id and type exists or not

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

381: WSH_DEBUG_SV.push(l_module_name);
382: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID ',p_entity_id);
383: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ENTITY_ID ',p_parent_entity_id);
384: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE ',p_entity_type);
385: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);
386: END IF;
387:
388: --Check whether the input entity id and type exists or not
389: OPEN c_entity_exists(p_entity_id, p_entity_type);

Line 397: WSH_DEBUG_SV.logmsg(l_module_name,'After opening cursor c_entity_exists');

393: END LOOP;
394: CLOSE c_entity_exists;
395:
396: IF l_debug_on THEN
397: WSH_DEBUG_SV.logmsg(l_module_name,'After opening cursor c_entity_exists');
398: WSH_DEBUG_SV.log(l_module_name,'l_entity_id ', l_entity_id);
399: WSH_DEBUG_SV.log(l_module_name,'l_parent_entity_id ', l_parent_entity_id);
400: END IF;
401:

Line 398: WSH_DEBUG_SV.log(l_module_name,'l_entity_id ', l_entity_id);

394: CLOSE c_entity_exists;
395:
396: IF l_debug_on THEN
397: WSH_DEBUG_SV.logmsg(l_module_name,'After opening cursor c_entity_exists');
398: WSH_DEBUG_SV.log(l_module_name,'l_entity_id ', l_entity_id);
399: WSH_DEBUG_SV.log(l_module_name,'l_parent_entity_id ', l_parent_entity_id);
400: END IF;
401:
402: --Bug#11695906

Line 399: WSH_DEBUG_SV.log(l_module_name,'l_parent_entity_id ', l_parent_entity_id);

395:
396: IF l_debug_on THEN
397: WSH_DEBUG_SV.logmsg(l_module_name,'After opening cursor c_entity_exists');
398: WSH_DEBUG_SV.log(l_module_name,'l_entity_id ', l_entity_id);
399: WSH_DEBUG_SV.log(l_module_name,'l_parent_entity_id ', l_parent_entity_id);
400: END IF;
401:
402: --Bug#11695906
403: --get the value for substitute_entity. Also check the value of p_parent_entity_id here.

Line 459: WSH_DEBUG_SV.logmsg(l_module_name,'Exception while inserting data into WOSRD ' || SQLERRM);

455: EXCEPTION
456: WHEN OTHERS THEN
457:
458: IF l_debug_on THEN
459: WSH_DEBUG_SV.logmsg(l_module_name,'Exception while inserting data into WOSRD ' || SQLERRM);
460: END IF;
461:
462: SELECT substitute_entity
463: INTO l_substitute_entity

Line 474: WSH_DEBUG_SV.pop(l_module_name);

470: x_substitute_entity := l_substitute_entity;
471: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
472:
473: IF l_debug_on THEN
474: WSH_DEBUG_SV.pop(l_module_name);
475: END IF;
476: COMMIT;
477:
478: EXCEPTION

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

478: EXCEPTION
479: WHEN OTHERS THEN
480: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
481: IF l_debug_on THEN
482: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
483: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
484: raise;
485: END IF;
486: ROLLBACK;

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

479: WHEN OTHERS THEN
480: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
481: IF l_debug_on THEN
482: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
483: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
484: raise;
485: END IF;
486: ROLLBACK;
487: END insert_row_sync_ref_data;

Line 505: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

501: --
502: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
503: --
504: IF l_debug_on IS NULL THEN
505: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
506: END IF;
507:
508: IF l_debug_on THEN
509: WSH_DEBUG_SV.push(l_module_name);

Line 509: WSH_DEBUG_SV.push(l_module_name);

505: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
506: END IF;
507:
508: IF l_debug_on THEN
509: WSH_DEBUG_SV.push(l_module_name);
510: WSH_DEBUG_SV.log(l_module_name,'P_SYNC_REF_ID ',p_sync_ref_id);
511: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);
512: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE ',P_ENTITY_TYPE);
513: END IF;

Line 510: WSH_DEBUG_SV.log(l_module_name,'P_SYNC_REF_ID ',p_sync_ref_id);

506: END IF;
507:
508: IF l_debug_on THEN
509: WSH_DEBUG_SV.push(l_module_name);
510: WSH_DEBUG_SV.log(l_module_name,'P_SYNC_REF_ID ',p_sync_ref_id);
511: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);
512: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE ',P_ENTITY_TYPE);
513: END IF;
514:

Line 511: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);

507:
508: IF l_debug_on THEN
509: WSH_DEBUG_SV.push(l_module_name);
510: WSH_DEBUG_SV.log(l_module_name,'P_SYNC_REF_ID ',p_sync_ref_id);
511: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);
512: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE ',P_ENTITY_TYPE);
513: END IF;
514:
515: --Inset data into the table

Line 512: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE ',P_ENTITY_TYPE);

508: IF l_debug_on THEN
509: WSH_DEBUG_SV.push(l_module_name);
510: WSH_DEBUG_SV.log(l_module_name,'P_SYNC_REF_ID ',p_sync_ref_id);
511: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);
512: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE ',P_ENTITY_TYPE);
513: END IF;
514:
515: --Inset data into the table
516: INSERT INTO wsh_otm_sync_ref_data_log (transmission_id,

Line 540: WSH_DEBUG_SV.pop(l_module_name);

536:
537: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
538:
539: IF l_debug_on THEN
540: WSH_DEBUG_SV.pop(l_module_name);
541: END IF;
542:
543: EXCEPTION
544: WHEN OTHERS THEN

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

543: EXCEPTION
544: WHEN OTHERS THEN
545: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
546: IF l_debug_on THEN
547: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
548: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
549: raise;
550: END IF;
551:

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

544: WHEN OTHERS THEN
545: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
546: IF l_debug_on THEN
547: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
548: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
549: raise;
550: END IF;
551:
552: END insert_row_sync_ref_data_log;