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: END IF;
145:
146: IF p_entity_updated_date >= l_last_sent_date OR
147: to_number(sysdate - l_last_sent_date) <= 1 THEN

Line 150: 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);

146: IF p_entity_updated_date >= l_last_sent_date OR
147: to_number(sysdate - l_last_sent_date) <= 1 THEN
148:
149: IF l_debug_on THEN
150: 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);
151: END IF;
152:
153: insert_row_sync_ref_data_log (p_sync_ref_id => l_sync_ref_id,
154: p_transmission_id => p_transmission_id,

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

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

Line 180: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

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

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

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

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

Line 246: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 250: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 326: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

Line 375: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 379: WSH_DEBUG_SV.push(l_module_name);

375: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
376: END IF;
377:
378: IF l_debug_on THEN
379: WSH_DEBUG_SV.push(l_module_name);
380: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID ',p_entity_id);
381: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ENTITY_ID ',p_parent_entity_id);
382: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE ',p_entity_type);
383: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID ',p_transmission_id);

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

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

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

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

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

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

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

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

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

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

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

392: CLOSE c_entity_exists;
393:
394: IF l_debug_on THEN
395: WSH_DEBUG_SV.logmsg(l_module_name,'After opening cursor c_entity_exists');
396: WSH_DEBUG_SV.log(l_module_name,'l_entity_id ', l_entity_id);
397: WSH_DEBUG_SV.log(l_module_name,'l_parent_entity_id ', l_parent_entity_id);
398: END IF;
399:
400: --get the value for substitute_entity. Also check the value of p_parent_entity_id here.

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

393:
394: IF l_debug_on THEN
395: WSH_DEBUG_SV.logmsg(l_module_name,'After opening cursor c_entity_exists');
396: WSH_DEBUG_SV.log(l_module_name,'l_entity_id ', l_entity_id);
397: WSH_DEBUG_SV.log(l_module_name,'l_parent_entity_id ', l_parent_entity_id);
398: END IF;
399:
400: --get the value for substitute_entity. Also check the value of p_parent_entity_id here.
401: IF l_entity_id is not null THEN

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

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

Line 471: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

Line 502: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 506: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

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

Line 537: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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