DBA Data[Home] [Help]

APPS.WSH_INV_INTEGRATION_GRP dependencies on FND_API

Line 64: x_api_status := FND_API.G_RET_STS_SUCCESS;

60:
61:
62: BEGIN
63:
64: x_api_status := FND_API.G_RET_STS_SUCCESS;
65: x_error_message := NULL ;
66: --
67: --
68: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 184: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;

180: --
181: exception
182: when others then
183: x_error_message := 'Exception occurred in WSH_INV_INTEGRATION_GRP.Find_Printer';
184: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;
185: --
186: IF l_debug_on THEN
187: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
188: END IF;

Line 202: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

198: */
199: PROCEDURE Complete_Inv_Interface(
200: p_api_version_number IN NUMBER,
201: p_init_msg_list IN VARCHAR2,
202: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
203: p_txn_header_id IN NUMBER,
204: p_txn_batch_id IN NUMBER,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,

Line 308: IF NOT FND_API.Compatible_API_Call(l_api_version_number,p_api_version_number,l_api_name,G_PKG_NAME) THEN

304:
305: savepoint Complete_Inv_Interface;
306:
307: -- Standard call to check for call compatibility
308: IF NOT FND_API.Compatible_API_Call(l_api_version_number,p_api_version_number,l_api_name,G_PKG_NAME) THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: END IF;
311:
312: IF l_debug_on THEN

Line 309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

305: savepoint Complete_Inv_Interface;
306:
307: -- Standard call to check for call compatibility
308: IF NOT FND_API.Compatible_API_Call(l_api_version_number,p_api_version_number,l_api_name,G_PKG_NAME) THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: END IF;
311:
312: IF l_debug_on THEN
313: WSH_DEBUG_SV.logmsg(l_module_name,'Done Compatible_API_Call');

Line 317: IF FND_API.to_Boolean(p_init_msg_list) THEN

313: WSH_DEBUG_SV.logmsg(l_module_name,'Done Compatible_API_Call');
314: END IF;
315:
316: -- Initialize message stack if required
317: IF FND_API.to_Boolean(p_init_msg_list) THEN
318: FND_MSG_PUB.initialize;
319: END IF;
320:
321: IF l_debug_on THEN

Line 322: WSH_DEBUG_SV.logmsg(l_module_name,'Done FND_API.to_Boolean');

318: FND_MSG_PUB.initialize;
319: END IF;
320:
321: IF l_debug_on THEN
322: WSH_DEBUG_SV.logmsg(l_module_name,'Done FND_API.to_Boolean');
323: END IF;
324:
325: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
326:

Line 410: IF p_commit = FND_API.G_TRUE THEN

406: END IF; --}
407: l_index := l_det_rec.stop_id.NEXT(l_index);
408: END LOOP; --}
409:
410: IF p_commit = FND_API.G_TRUE THEN
411: COMMIT;
412: END IF;
413:
414:

Line 434: x_return_status := FND_API.G_RET_STS_ERROR ;

430: END IF;
431:
432:
433: WHEN trip_stop_locked THEN
434: x_return_status := FND_API.G_RET_STS_ERROR ;
435: IF l_debug_on THEN
436: WSH_DEBUG_SV.logmsg(l_module_name,'Could not locked the records for stop',WSH_DEBUG_SV.C_EXCEP_LEVEL);
437: WSH_DEBUG_SV.pop(l_module_name);
438: END IF;

Line 449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

445: END IF;
446:
447: rollback to savepoint Complete_Inv_Interface;
448:
449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
451: -- Get message count and data
452: FND_MSG_PUB.Count_And_Get
453: ( p_encoded => l_encoded

Line 450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

446:
447: rollback to savepoint Complete_Inv_Interface;
448:
449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
451: -- Get message count and data
452: FND_MSG_PUB.Count_And_Get
453: ( p_encoded => l_encoded
454: , p_count => x_msg_count

Line 458: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

454: , p_count => x_msg_count
455: , p_data => x_msg_data
456: );
457: IF l_debug_on THEN
458: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
459: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
460: END IF;
461: rollback to savepoint Complete_Inv_Interface;
462:

Line 459: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

455: , p_data => x_msg_data
456: );
457: IF l_debug_on THEN
458: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
459: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
460: END IF;
461: rollback to savepoint Complete_Inv_Interface;
462:
463: WHEN OTHERS THEN

Line 464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

460: END IF;
461: rollback to savepoint Complete_Inv_Interface;
462:
463: WHEN OTHERS THEN
464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
465: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
466: THEN
467: FND_MSG_PUB.Add_Exc_Msg
468: ( G_PKG_NAME