APPS.WSH_INV_INTEGRATION_GRP dependencies on FND_API

Line 54: x_api_status := FND_API.G_RET_STS_SUCCESS;

50: order by decode ( nvl( wrp.default_printer_flag ,2) ,
51: 'Y' ,1 , 2 ) ;
52:
53: BEGIN
54: x_api_status := FND_API.G_RET_STS_SUCCESS;
55: x_error_message := NULL ;
56: --
57: --
58:

Line 126: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;

122:
123: exception
124: when others then
125: x_error_message := 'Exception occurred in WSH_INV_INTEGRATION_GRP.Find_Printer';
126: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;
127: --
128:
129: END Find_Printer ;
130:

Line 142: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

138: */
139: PROCEDURE Complete_Inv_Interface(
140: p_api_version_number IN NUMBER,
141: p_init_msg_list IN VARCHAR2,
142: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
143: p_txn_header_id IN NUMBER,
144: p_txn_batch_id IN NUMBER,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,

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

244:
245: savepoint Complete_Inv_Interface;
246:
247: -- Standard call to check for call compatibility
248: IF NOT FND_API.Compatible_API_Call(l_api_version_number,p_api_version_number,l_api_name,G_PKG_NAME) THEN
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END IF;
251:
252: IF l_debug_on THEN

Line 249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

245: savepoint Complete_Inv_Interface;
246:
247: -- Standard call to check for call compatibility
248: IF NOT FND_API.Compatible_API_Call(l_api_version_number,p_api_version_number,l_api_name,G_PKG_NAME) THEN
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END IF;
251:
252: IF l_debug_on THEN
253: WSH_DEBUG_SV.logmsg(l_module_name,'Done Compatible_API_Call');

Line 257: IF FND_API.to_Boolean(p_init_msg_list) THEN

253: WSH_DEBUG_SV.logmsg(l_module_name,'Done Compatible_API_Call');
254: END IF;
255:
256: -- Initialize message stack if required
257: IF FND_API.to_Boolean(p_init_msg_list) THEN
258: FND_MSG_PUB.initialize;
259: END IF;
260:
261: IF l_debug_on THEN

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

258: FND_MSG_PUB.initialize;
259: END IF;
260:
261: IF l_debug_on THEN
262: WSH_DEBUG_SV.logmsg(l_module_name,'Done FND_API.to_Boolean');
263: END IF;
264:
265: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
266:

Line 350: IF p_commit = FND_API.G_TRUE THEN

346: END IF; --}
347: l_index := l_det_rec.stop_id.NEXT(l_index);
348: END LOOP; --}
349:
350: IF p_commit = FND_API.G_TRUE THEN
351: COMMIT;
352: END IF;
353:
354:

Line 374: x_return_status := FND_API.G_RET_STS_ERROR ;

370: END IF;
371:
372:
373: WHEN trip_stop_locked THEN
374: x_return_status := FND_API.G_RET_STS_ERROR ;
375: IF l_debug_on THEN
376: WSH_DEBUG_SV.logmsg(l_module_name,'Could not locked the records for stop',WSH_DEBUG_SV.C_EXCEP_LEVEL);
377: WSH_DEBUG_SV.pop(l_module_name);
378: END IF;

Line 389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

385: END IF;
386:
387: rollback to savepoint Complete_Inv_Interface;
388:
389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
391: -- Get message count and data
392: FND_MSG_PUB.Count_And_Get
393: ( p_encoded => l_encoded

Line 390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

386:
387: rollback to savepoint Complete_Inv_Interface;
388:
389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
391: -- Get message count and data
392: FND_MSG_PUB.Count_And_Get
393: ( p_encoded => l_encoded
394: , p_count => x_msg_count

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

394: , p_count => x_msg_count
395: , p_data => x_msg_data
396: );
397: IF l_debug_on THEN
398: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
399: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
400: END IF;
401: rollback to savepoint Complete_Inv_Interface;
402:

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

395: , p_data => x_msg_data
396: );
397: IF l_debug_on THEN
398: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
399: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
400: END IF;
401: rollback to savepoint Complete_Inv_Interface;
402:
403: WHEN OTHERS THEN

Line 404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

400: END IF;
401: rollback to savepoint Complete_Inv_Interface;
402:
403: WHEN OTHERS THEN
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
405: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
406: THEN
407: FND_MSG_PUB.Add_Exc_Msg
408: ( G_PKG_NAME