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_UTIL_CORE

Line 12: -- x_return_status Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

8: -- Function :get_EBS_item_info
9: -- Parameters :p_entity_in_rec is the input rec type.
10: -- It has the entity_type, entity id and parent entity id
11: -- x_transmission_id Transmission id passed to the caller
12: -- x_return_status Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
13: -- Description :This Function takes input from the txn service and passes
14: -- the item data back. The item data is passed in the form of
15: -- of collection WSH_OTM_GLOG_ITEM_TBL thats maps to
16: -- GLOG Schema ITEMMASTER

Line 127: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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:
129: --Check for number of ids in the input table and if 0 then raise error.
130: IF p_entity_in_rec.entity_id_tbl.COUNT = 0 THEN
131: RAISE e_null_id_error;

Line 148: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;

144: IF (l_domain_name IS NULL) THEN
145: --{
146: FND_MESSAGE.SET_NAME('WSH','WSH_PROFILE_NOT_SET_ERR');
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;

Line 149: wsh_util_core.add_message(x_return_status, l_module_name);

145: --{
146: FND_MESSAGE.SET_NAME('WSH','WSH_PROFILE_NOT_SET_ERR');
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;

Line 255: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

251: return l_tbl_send_item_info;
252:
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;

Line 262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

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 ;
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;

Line 269: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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;
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;

Line 283: -- x_return_status Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success

279: -----------------------------------------------------------------------------
280: --
281: -- Procedure :remove_duplicate_items
282: -- Parameters :p_item_tbl is the input table of item_info_tbl.
283: -- x_return_status Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
284: -- Description :This procedure take in the input table and removes all the
285: -- duplicate rows.
286: -----------------------------------------------------------------------------
287: PROCEDURE remove_duplicate_items(p_item_tbl IN OUT NOCOPY item_info_tbl,

Line 315: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

311: END IF;
312:
313: l_count := p_item_tbl.COUNT;
314:
315: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
316:
317: FOR l_loop_count IN p_item_tbl.FIRST .. p_item_tbl.LAST
318: LOOP
319: l_item_id := p_item_tbl(l_loop_count).item_id;

Line 338: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

334: p_item_tbl := l_item_tbl;
335:
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;