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

Line 119: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

115: --
116: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
117: --
118: IF l_debug_on IS NULL THEN
119: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
120: END IF;
121:
122: IF l_debug_on THEN
123: WSH_DEBUG_SV.push(l_module_name);

Line 123: WSH_DEBUG_SV.push(l_module_name);

119: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
120: END IF;
121:
122: IF l_debug_on THEN
123: WSH_DEBUG_SV.push(l_module_name);
124: WSH_DEBUG_SV.log(l_module_name,' p_entity_in_rec.ENTITY_TYPE ', p_entity_in_rec.ENTITY_TYPE);
125: END IF;
126:
127: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 124: WSH_DEBUG_SV.log(l_module_name,' p_entity_in_rec.ENTITY_TYPE ', p_entity_in_rec.ENTITY_TYPE);

120: END IF;
121:
122: IF l_debug_on THEN
123: WSH_DEBUG_SV.push(l_module_name);
124: WSH_DEBUG_SV.log(l_module_name,' p_entity_in_rec.ENTITY_TYPE ', p_entity_in_rec.ENTITY_TYPE);
125: END IF;
126:
127: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
128:

Line 151: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_DOMAIN_NAME is set to NULL. Please correct the profile value');

147: FND_MESSAGE.SET_TOKEN('PRF_NAME','WSH_OTM_DOMAIN_NAME');
148: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
149: wsh_util_core.add_message(x_return_status, l_module_name);
150: IF l_debug_on THEN
151: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_DOMAIN_NAME is set to NULL. Please correct the profile value');
152: END IF;
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: --}
155: END IF;

Line 186: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_ITEM_PKG.REMOVE_DUPLICATE_ITEMS', WSH_DEBUG_SV.C_PROC_LEVEL);

182: END IF;
183:
184: --Search the table l_tbl_item for duplicates and if found then remove them.
185: IF l_debug_on THEN
186: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_ITEM_PKG.REMOVE_DUPLICATE_ITEMS', WSH_DEBUG_SV.C_PROC_LEVEL);
187: END IF;
188:
189: IF l_tbl_item.COUNT <> 0 THEN
190: remove_duplicate_items(p_item_tbl => l_tbl_item,

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

201: l_org_id := l_tbl_item(l_loop_index).org_id;
202:
203: --For each item find whether it has to be sent to GLOG
204: IF l_debug_on THEN
205: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.IS_REF_DATA_SEND_REQD', WSH_DEBUG_SV.C_PROC_LEVEL);
206: END IF;
207:
208: WSH_OTM_SYNC_REF_DATA_PKG.IS_REF_DATA_SEND_REQD(P_ENTITY_ID => l_item_id,
209: P_PARENT_ENTITY_ID => l_org_id,

Line 240: WSH_DEBUG_SV.pop(l_module_name);

236: --Delete the local table l_tbl_item.
237: l_tbl_item.DELETE;
238:
239: IF l_debug_on THEN
240: WSH_DEBUG_SV.pop(l_module_name);
241: END IF;
242:
243: --Check for the number of rows in the table.
244: IF l_send_count = 0 THEN

Line 257: WSH_DEBUG_SV.logmsg(l_module_name,'p_Ids cannot be null',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

253: EXCEPTION
254: WHEN e_null_id_error THEN
255: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
256: IF l_debug_on THEN
257: WSH_DEBUG_SV.logmsg(l_module_name,'p_Ids cannot be null',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
258: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NULL_IDS');
259: raise;
260: END IF;
261: WHEN e_entity_type_error THEN

Line 258: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NULL_IDS');

254: WHEN e_null_id_error THEN
255: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
256: IF l_debug_on THEN
257: WSH_DEBUG_SV.logmsg(l_module_name,'p_Ids cannot be null',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
258: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NULL_IDS');
259: raise;
260: END IF;
261: WHEN e_entity_type_error THEN
262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

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

260: END IF;
261: WHEN e_entity_type_error THEN
262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
263: IF l_debug_on THEN
264: WSH_DEBUG_SV.logmsg(l_module_name,'wrong entity type passed',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
265: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WRONG_ENTITY_TYPE');
266: raise;
267: END IF;
268: WHEN OTHERS THEN

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

261: WHEN e_entity_type_error THEN
262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
263: IF l_debug_on THEN
264: WSH_DEBUG_SV.logmsg(l_module_name,'wrong entity type passed',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
265: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WRONG_ENTITY_TYPE');
266: raise;
267: END IF;
268: WHEN OTHERS THEN
269: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

267: END IF;
268: WHEN OTHERS THEN
269: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
270: IF l_debug_on THEN
271: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
272: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
273: raise;
274: END IF;
275:

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

268: WHEN OTHERS THEN
269: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
270: IF l_debug_on THEN
271: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
272: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
273: raise;
274: END IF;
275:
276: END get_EBS_item_info;

Line 305: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

301: --
302: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
303: --
304: IF l_debug_on IS NULL THEN
305: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
306: END IF;
307:
308: IF l_debug_on THEN
309: WSH_DEBUG_SV.push(l_module_name);

Line 309: WSH_DEBUG_SV.push(l_module_name);

305: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
306: END IF;
307:
308: IF l_debug_on THEN
309: WSH_DEBUG_SV.push(l_module_name);
310: WSH_DEBUG_SV.log(l_module_name,'No of rows in item_info_tbl ',p_item_tbl.COUNT);
311: END IF;
312:
313: l_count := p_item_tbl.COUNT;

Line 310: WSH_DEBUG_SV.log(l_module_name,'No of rows in item_info_tbl ',p_item_tbl.COUNT);

306: END IF;
307:
308: IF l_debug_on THEN
309: WSH_DEBUG_SV.push(l_module_name);
310: WSH_DEBUG_SV.log(l_module_name,'No of rows in item_info_tbl ',p_item_tbl.COUNT);
311: END IF;
312:
313: l_count := p_item_tbl.COUNT;
314:

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

336: EXCEPTION
337: WHEN OTHERS THEN
338: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
339: IF l_debug_on THEN
340: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
341: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
342: raise;
343: END IF;
344: END remove_duplicate_items;

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

337: WHEN OTHERS THEN
338: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
339: IF l_debug_on THEN
340: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
341: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
342: raise;
343: END IF;
344: END remove_duplicate_items;
345: