DBA Data[Home] [Help]

APPS.WSH_BULK_PROCESS_GRP dependencies on FND_API

Line 10: -- p_init_msg_list FND_API.G_TRUE to reset list

6: --========================================================================
7: -- PROCEDURE : Create_update_delivery_details
8: --
9: -- PARAMETERS: p_api_version_number known api versionerror buffer
10: -- p_init_msg_list FND_API.G_TRUE to reset list
11: -- x_return_status return status
12: -- x_msg_count number of messages in the list
13: -- x_msg_data text of messages
14: -- p_commit FND_API.G_TRUE to perform a commit

Line 14: -- p_commit FND_API.G_TRUE to perform a commit

10: -- p_init_msg_list FND_API.G_TRUE to reset list
11: -- x_return_status return status
12: -- x_msg_count number of messages in the list
13: -- x_msg_data text of messages
14: -- p_commit FND_API.G_TRUE to perform a commit
15: -- p_action_prms Additional attributes needed
16: -- x_Out_Rec Place holder
17: -- p_line_rec Line record
18: -- VERSION : current version 1.0

Line 73: IF FND_API.to_Boolean(p_init_msg_list) THEN

69: END IF;
70:
71: SAVEPOINT S_CREATE_UPDATE_DETAILS_BULK;
72:
73: IF FND_API.to_Boolean(p_init_msg_list) THEN
74: FND_MSG_PUB.initialize;
75: END IF;
76: --
77: IF l_debug_on THEN

Line 87: IF NOT FND_API.Compatible_API_Call

83: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);
84: wsh_debug_sv.log (l_module_name,'Org_id',p_action_prms.Org_id);
85: END IF;
86:
87: IF NOT FND_API.Compatible_API_Call
88: ( l_api_version_number,
89: p_api_version_number,
90: l_api_name,
91: G_PKG_NAME

Line 94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

90: l_api_name,
91: G_PKG_NAME
92: )
93: THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96: --
97: IF p_action_prms.caller IS NULL THEN
98: l_token_name := 'p_action_prms.caller';

Line 108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; --bms should we raise unexpected??

104: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
105: FND_MESSAGE.SET_TOKEN('FIELD_NAME',l_token_name);
106: l_return_status:=wsh_util_core.g_ret_sts_unexp_error;
107: wsh_util_core.add_message(x_return_status,l_module_name);
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; --bms should we raise unexpected??
109: END IF;
110:
111: -- IF caller is neither 'OM' or 'PO', raise an exception.
112: IF p_action_prms.caller NOT IN ('OM','PO') THEN

Line 116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

112: IF p_action_prms.caller NOT IN ('OM','PO') THEN
113: IF l_debug_on THEN
114: wsh_debug_sv.log (l_module_name,'bad caller',p_action_prms.Caller);
115: END IF;
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: END IF;
118:
119: l_otm_installed := WSH_UTIL_CORE.Get_Otm_Install_Profile_Value;
120: IF l_otm_installed IN ( 'Y','P')

Line 199: RAISE FND_API.G_EXC_ERROR;

195: wsh_debug_sv.log (l_module_name,'after api_post_call');
196: END IF;
197:
198: IF (l_num_errors > 0 ) THEN
199: RAISE FND_API.G_EXC_ERROR;
200: ELSE
201: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
202: END IF;
203:

Line 205: IF FND_API.To_Boolean( p_commit ) THEN

201: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
202: END IF;
203:
204:
205: IF FND_API.To_Boolean( p_commit ) THEN
206:
207: --bug 4070732
208: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
209: --{

Line 225: RAISE FND_API.G_EXC_ERROR;

221: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
222: END IF;
223:
224: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
225: RAISE FND_API.G_EXC_ERROR;
226: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
229: RAISE WSH_UTIL_CORE.G_EXC_WARNING;

Line 227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

223:
224: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
225: RAISE FND_API.G_EXC_ERROR;
226: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
229: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
230: END IF;
231:

Line 245: IF FND_API.To_Boolean( p_commit ) THEN

241: --{
242: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
243: --{
244:
245: IF FND_API.To_Boolean( p_commit ) THEN
246: IF l_debug_on THEN
247: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
248: END IF;
249:

Line 274: IF NOT FND_API.To_Boolean( p_commit ) THEN

270: x_return_status := l_return_status;
271: END IF;
272:
273: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
274: IF NOT FND_API.To_Boolean( p_commit ) THEN
275: ROLLBACK TO S_CREATE_UPDATE_DETAILS_BULK;
276: END IF;
277: END IF;
278:

Line 293: p_encoded => FND_API.G_FALSE

289: FND_MSG_PUB.Count_And_Get
290: (
291: p_count => x_msg_count,
292: p_data => x_msg_data,
293: p_encoded => FND_API.G_FALSE
294: );
295: --
296: IF l_debug_on THEN
297: WSH_DEBUG_SV.pop(l_module_name);

Line 312: p_encoded => FND_API.G_FALSE

308: FND_MSG_PUB.Count_And_Get
309: (
310: p_count => x_msg_count,
311: p_data => x_msg_data,
312: p_encoded => FND_API.G_FALSE
313: );
314: */
315: IF l_debug_on THEN
316: WSH_DEBUG_SV.pop(l_module_name,'e_success');

Line 319: WHEN FND_API.G_EXC_ERROR THEN

315: IF l_debug_on THEN
316: WSH_DEBUG_SV.pop(l_module_name,'e_success');
317: END IF;
318:
319: WHEN FND_API.G_EXC_ERROR THEN
320: --ROLLBACK TO S_CREATE_UPDATE_DETAILS; bms
321: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
322: --
323: --

Line 356: p_encoded => FND_API.G_FALSE

352: FND_MSG_PUB.Count_And_Get
353: (
354: p_count => x_msg_count,
355: p_data => x_msg_data,
356: p_encoded => FND_API.G_FALSE
357: );
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
360: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 359: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

355: p_data => x_msg_data,
356: p_encoded => FND_API.G_FALSE
357: );
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
360: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
361: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
362: END IF;
363:

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

357: );
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
360: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
361: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
362: END IF;
363:
364:
365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

361: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
362: END IF;
363:
364:
365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
366: ROLLBACK TO S_CREATE_UPDATE_DETAILS_BULK;
367: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
368: --
369: --

Line 402: p_encoded => FND_API.G_FALSE

398: FND_MSG_PUB.Count_And_Get
399: (
400: p_count => x_msg_count,
401: p_data => x_msg_data,
402: p_encoded => FND_API.G_FALSE
403: );
404: IF l_debug_on THEN
405: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. ' ||
406: 'Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

403: );
404: IF l_debug_on THEN
405: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. ' ||
406: 'Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
407: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
408: END IF;
409:
410: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
411: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 452: p_encoded => FND_API.G_FALSE

448: FND_MSG_PUB.Count_And_Get
449: (
450: p_count => x_msg_count,
451: p_data => x_msg_data,
452: p_encoded => FND_API.G_FALSE
453: );
454: IF l_debug_on THEN
455: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING '||
456: 'exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 499: p_encoded => FND_API.G_FALSE

495: FND_MSG_PUB.Count_And_Get
496: (
497: p_count => x_msg_count,
498: p_data => x_msg_data,
499: p_encoded => FND_API.G_FALSE
500: );
501: IF l_debug_on THEN
502: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
503: 'Oracle error message is '||

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

501: IF l_debug_on THEN
502: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
503: 'Oracle error message is '||
504: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
505: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
506: END IF;
507:
508: END Create_update_delivery_details;
509: