DBA Data[Home] [Help]

APPS.WSH_SHIPMENT_BATCH_PUB dependencies on FND_API

Line 141: IF FND_API.to_Boolean(p_init_msg_list) THEN

137: --
138:
139: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
140: -- Initialize Message List
141: IF FND_API.to_Boolean(p_init_msg_list) THEN
142: FND_MSG_PUB.initialize;
143: END IF;
144:
145: -- Standard call to check for call compatibility

Line 146: IF NOT FND_API.Compatible_API_Call (

142: FND_MSG_PUB.initialize;
143: END IF;
144:
145: -- Standard call to check for call compatibility
146: IF NOT FND_API.Compatible_API_Call (
147: l_api_version_number,
148: p_api_version_number,
149: l_api_name,
150: G_PKG_NAME )

Line 152: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

148: p_api_version_number,
149: l_api_name,
150: G_PKG_NAME )
151: THEN
152: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: RAISE FND_API.G_EXC_ERROR;
154: END IF;
155:
156: BEGIN

Line 153: RAISE FND_API.G_EXC_ERROR;

149: l_api_name,
150: G_PKG_NAME )
151: THEN
152: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: RAISE FND_API.G_EXC_ERROR;
154: END IF;
155:
156: BEGIN
157: select to_char(p_from_request_date, 'YYYY/MM/DD HH24:MI:SS'),

Line 173: RAISE FND_API.G_EXC_ERROR;

169: IF l_debug_on THEN
170: WSH_DEBUG_SV.log(l_module_name, 'Error: Invalid date format', sqlerrm);
171: END IF;
172: --
173: RAISE FND_API.G_EXC_ERROR;
174: END;
175:
176: IF p_process_mode = 'ONLINE' THEN
177: --

Line 210: RAISE FND_API.G_EXC_ERROR;

206: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
207: x_return_status := l_return_status;
208: -- Raise error, if return status is not Success/Warning
209: ELSE
210: RAISE FND_API.G_EXC_ERROR;
211: END IF;
212: ELSIF p_process_mode = 'CONCURRENT' THEN
213: --
214: IF l_debug_on THEN

Line 245: RAISE FND_API.G_EXC_ERROR;

241: WSH_DEBUG_SV.log(l_module_name, 'Request Id returned from FND_REQUEST.SUBMIT_REQUEST', x_request_id);
242: END IF;
243: --
244: IF (nvl(x_request_id,0) <= 0) THEN
245: RAISE FND_API.G_EXC_ERROR;
246: ELSE
247: FND_MESSAGE.Set_Name('WSH', 'WSH_REQUEST_SUBMITTED');
248: FND_MESSAGE.Set_Token('REQUEST_ID', x_request_id);
249: WSH_UTIL_CORE.Add_Message(x_return_status);

Line 261: RAISE FND_API.G_EXC_ERROR;

257: IF l_debug_on THEN
258: WSH_DEBUG_SV.logmsg(l_module_name, 'p_process_mode should be ONLINE/CONCURRENT');
259: END IF;
260: --
261: RAISE FND_API.G_EXC_ERROR;
262: END IF;
263:
264: IF p_commit = FND_API.G_TRUE THEN
265: COMMIT;

Line 264: IF p_commit = FND_API.G_TRUE THEN

260: --
261: RAISE FND_API.G_EXC_ERROR;
262: END IF;
263:
264: IF p_commit = FND_API.G_TRUE THEN
265: COMMIT;
266: END IF;
267:
268: --Set Msg. Count and Data from Msg. Stack

Line 272: p_encoded => fnd_api.g_false);

268: --Set Msg. Count and Data from Msg. Stack
269: FND_MSG_PUB.Count_And_Get(
270: p_count => x_msg_count,
271: p_data => x_msg_data,
272: p_encoded => fnd_api.g_false);
273:
274: --
275: IF l_debug_on THEN
276: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);

Line 281: WHEN FND_API.G_EXC_ERROR THEN

277: WSH_DEBUG_SV.pop(l_module_name);
278: END IF;
279: --
280: EXCEPTION
281: WHEN FND_API.G_EXC_ERROR THEN
282: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
283: --
284: IF l_debug_on THEN
285: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');

Line 292: p_encoded => fnd_api.g_false);

288: ROLLBACK;
289: FND_MSG_PUB.Count_And_Get(
290: p_count => x_msg_count,
291: p_data => x_msg_data,
292: p_encoded => fnd_api.g_false);
293: IF l_debug_on THEN
294: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured while creating Shipment Batch');
295: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
296: END IF;

Line 295: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

291: p_data => x_msg_data,
292: p_encoded => fnd_api.g_false);
293: IF l_debug_on THEN
294: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured while creating Shipment Batch');
295: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
296: END IF;
297: WHEN others THEN
298: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
299: --

Line 308: p_encoded => fnd_api.g_false);

304: ROLLBACK;
305: FND_MSG_PUB.Count_And_Get(
306: p_count => x_msg_count,
307: p_data => x_msg_data,
308: p_encoded => fnd_api.g_false);
309: --
310: IF l_debug_on THEN
311: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
312: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 393: IF FND_API.to_Boolean(p_init_msg_list) THEN

389: END IF;
390: --
391: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
392: -- Initialize Message List
393: IF FND_API.to_Boolean(p_init_msg_list) THEN
394: FND_MSG_PUB.initialize;
395: END IF;
396:
397: -- Standard call to check for call compatibility

Line 398: IF NOT FND_API.Compatible_API_Call (

394: FND_MSG_PUB.initialize;
395: END IF;
396:
397: -- Standard call to check for call compatibility
398: IF NOT FND_API.Compatible_API_Call (
399: l_api_version_number,
400: p_api_version_number,
401: l_api_name,
402: G_PKG_NAME )

Line 404: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

400: p_api_version_number,
401: l_api_name,
402: G_PKG_NAME )
403: THEN
404: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407:
408: IF l_debug_on THEN

Line 405: RAISE FND_API.G_EXC_ERROR;

401: l_api_name,
402: G_PKG_NAME )
403: THEN
404: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407:
408: IF l_debug_on THEN
409: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_SHIPMENT_BATCH_PKG.Cancel_Line', WSH_DEBUG_SV.C_PROC_LEVEL);

Line 425: RAISE FND_API.G_EXC_ERROR;

421: END IF;
422: --
423:
424: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;
427:
428: IF p_commit = FND_API.G_TRUE THEN
429: COMMIT;

Line 428: IF p_commit = FND_API.G_TRUE THEN

424: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;
427:
428: IF p_commit = FND_API.G_TRUE THEN
429: COMMIT;
430: END IF;
431:
432: --

Line 439: WHEN FND_API.G_EXC_ERROR THEN

435: WSH_DEBUG_SV.pop(l_module_name);
436: END IF;
437: --
438: EXCEPTION
439: WHEN FND_API.G_EXC_ERROR THEN
440: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
441: --
442: IF l_debug_on THEN
443: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');

Line 450: p_encoded => fnd_api.g_false);

446: ROLLBACK;
447: FND_MSG_PUB.Count_And_Get(
448: p_count => x_msg_count,
449: p_data => x_msg_data,
450: p_encoded => fnd_api.g_false);
451: IF l_debug_on THEN
452: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured while cancelling delivery line');
453: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
454: END IF;

Line 453: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

449: p_data => x_msg_data,
450: p_encoded => fnd_api.g_false);
451: IF l_debug_on THEN
452: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured while cancelling delivery line');
453: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
454: END IF;
455: WHEN others THEN
456: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
457: --

Line 466: p_encoded => fnd_api.g_false);

462: ROLLBACK;
463: FND_MSG_PUB.Count_And_Get(
464: p_count => x_msg_count,
465: p_data => x_msg_data,
466: p_encoded => fnd_api.g_false);
467: --
468: IF l_debug_on THEN
469: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
470: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');