DBA Data[Home] [Help]

APPS.WSH_INTERFACE_VALIDATIONS_PKG dependencies on FND_API

Line 162: RAISE FND_API.G_EXC_ERROR;

158: IF l_debug_on THEN
159: wsh_debug_sv.logmsg(l_module_name, 'Inside No Data Found Exception to Derive TP ID');
160: END IF;
161: --
162: RAISE FND_API.G_EXC_ERROR;
163: --
164: WHEN TOO_MANY_ROWS THEN
165: --
166: IF l_debug_on THEN

Line 170: RAISE FND_API.G_EXC_ERROR;

166: IF l_debug_on THEN
167: wsh_debug_sv.logmsg (l_module_name, 'Inside Too many rows Exception to derive TP ID');
168: END IF;
169: --
170: RAISE FND_API.G_EXC_ERROR;
171: END;
172:
173: IF l_debug_on THEN
174: wsh_debug_sv.log(l_module_name, 'Derived TP ID successfully', x_trading_partner_ID);

Line 198: RAISE FND_API.G_EXC_ERROR;

194: --
195: IF l_debug_on THEN
196: wsh_debug_sv.log(l_module_name, 'EXCEPTION: Found duplicate', p_duplicate);
197: END IF;
198: RAISE FND_API.G_EXC_ERROR;
199: --
200: END IF;
201:
202: EXCEPTION

Line 206: x_valid_doc := fnd_api.g_true;

202: EXCEPTION
203: WHEN NO_DATA_FOUND THEN
204: --
205: x_return_status := wsh_util_core.g_ret_sts_success;
206: x_valid_doc := fnd_api.g_true;
207: --
208: WHEN TOO_MANY_ROWS THEN
209: --
210: IF l_debug_on THEN

Line 214: RAISE FND_API.G_EXC_ERROR;

210: IF l_debug_on THEN
211: wsh_debug_sv.logmsg(l_module_name, 'EXCEPTION: Too many rows when checking for duplicates');
212: END IF;
213: --
214: RAISE FND_API.G_EXC_ERROR;
215: --
216: END;
217:
218: IF l_debug_on THEN

Line 253: x_valid_doc := fnd_api.g_true;

249:
250: IF (p_940_exists = 'X')
251: THEN
252: x_return_status := wsh_util_core.g_ret_sts_success;
253: x_valid_doc := fnd_api.g_true;
254: IF l_debug_on THEN
255: wsh_debug_sv.log(l_module_name, '940 Add Exists for the 940 Cancellation sent, Return Status',X_Return_Status );
256: END IF;
257: END IF;

Line 265: RAISE FND_API.G_EXC_ERROR;

261: IF l_debug_on THEN
262: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION: No corresponding 940-Add exists');
263: END IF;
264: --
265: RAISE FND_API.G_EXC_ERROR;
266: END;
267: END IF; -- End of If (P_ACTION_TYPE = 'D') Then
268:
269: IF l_debug_on THEN

Line 292: x_valid_doc := fnd_api.g_true;

288:
289: IF (p_940_exists = 'X')
290: THEN
291: x_return_status := wsh_util_core.g_ret_sts_success;
292: x_valid_doc := fnd_api.g_true;
293: END IF;
294: EXCEPTION
295: WHEN NO_DATA_FOUND
296: THEN

Line 303: RAISE FND_API.G_EXC_ERROR;

299: wsh_debug_sv.logmsg(l_module_name, 'EXCEPTION: No data found when checking for 940-O when
300: 945-IN comes in');
301: END IF;
302: --
303: RAISE FND_API.G_EXC_ERROR;
304: --
305: END;
306: END IF; -- }
307:

Line 314: WHEN FND_API.G_EXC_ERROR THEN

310: wsh_debug_sv.pop (l_module_name);
311: END IF;
312:
313: EXCEPTION
314: WHEN FND_API.G_EXC_ERROR THEN
315: --
316: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
317: x_Valid_Doc := FND_API.G_FALSE;
318: --

Line 317: x_Valid_Doc := FND_API.G_FALSE;

313: EXCEPTION
314: WHEN FND_API.G_EXC_ERROR THEN
315: --
316: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
317: x_Valid_Doc := FND_API.G_FALSE;
318: --
319: IF l_debug_on THEN
320: --
321: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Validate Document',X_Return_Status );

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

319: IF l_debug_on THEN
320: --
321: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Validate Document',X_Return_Status );
322: WSH_DEBUG_SV.log(l_module_name, 'x_valid_doc', x_Valid_Doc);
323: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
324: WSH_DEBUG_SV.C_EXCEP_LEVEL);
325: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
326: --
327: END IF;

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

321: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Validate Document',X_Return_Status );
322: WSH_DEBUG_SV.log(l_module_name, 'x_valid_doc', x_Valid_Doc);
323: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
324: WSH_DEBUG_SV.C_EXCEP_LEVEL);
325: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
326: --
327: END IF;
328: --
329: WHEN invalid_doc_number

Line 332: x_valid_doc := fnd_api.g_false;

328: --
329: WHEN invalid_doc_number
330: THEN
331: x_return_status := wsh_util_core.g_ret_sts_error;
332: x_valid_doc := fnd_api.g_false;
333: IF l_debug_on THEN
334: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_number exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
335: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_number');
336: END IF;

Line 341: x_valid_doc := fnd_api.g_false;

337: --R12.1.1 STANDALONE PROJECT
338: WHEN invalid_doc_revision
339: THEN
340: x_return_status := wsh_util_core.g_ret_sts_error;
341: x_valid_doc := fnd_api.g_false;
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_revision exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_revision');
345: END IF;

Line 349: x_valid_doc := fnd_api.g_false;

345: END IF;
346: WHEN invalid_tp
347: THEN
348: x_return_status := wsh_util_core.g_ret_sts_error;
349: x_valid_doc := fnd_api.g_false;
350: IF l_debug_on THEN
351: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_tp exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
352: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_tp');
353: END IF;

Line 357: x_valid_doc := fnd_api.g_false;

353: END IF;
354: WHEN invalid_doc_direction
355: THEN
356: x_return_status := wsh_util_core.g_ret_sts_error;
357: x_valid_doc := fnd_api.g_false;
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_direction exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
360: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_direction');
361: END IF;

Line 365: x_valid_doc := fnd_api.g_false;

361: END IF;
362: WHEN invalid_doc_type
363: THEN
364: x_return_status := wsh_util_core.g_ret_sts_error;
365: x_valid_doc := fnd_api.g_false;
366: IF l_debug_on THEN
367: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
368: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_type');
369: END IF;

Line 373: x_valid_doc := fnd_api.g_false;

369: END IF;
370: WHEN invalid_action_type
371: THEN
372: x_return_status := wsh_util_core.g_ret_sts_error;
373: x_valid_doc := fnd_api.g_false;
374: IF l_debug_on THEN
375: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
376: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_type');
377: END IF;

Line 381: x_valid_doc := fnd_api.g_false;

377: END IF;
378: WHEN OTHERS
379: THEN
380: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
381: x_valid_doc := fnd_api.g_false;
382: IF l_debug_on THEN
383: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
384: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
385: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 454: RAISE FND_API.G_EXC_ERROR;

450: IF l_debug_on THEN
451: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION: No corresponding client exists');
452: END IF;
453: --
454: RAISE FND_API.G_EXC_ERROR;
455: END;
456: --
457: -- Call inventory API to get the item delimiter..
458: IF p_client_code IS NOT NULL THEN

Line 475: WHEN FND_API.G_EXC_ERROR THEN

471: wsh_debug_sv.pop (l_module_name);
472: END IF;
473: --
474: EXCEPTION
475: WHEN FND_API.G_EXC_ERROR THEN
476: --
477: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
478: --
479: IF l_debug_on THEN

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

478: --
479: IF l_debug_on THEN
480: --
481: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Get_Client_details',X_Return_Status );
482: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
483: WSH_DEBUG_SV.C_EXCEP_LEVEL);
484: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
485: --
486: END IF;

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

480: --
481: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Get_Client_details',X_Return_Status );
482: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
483: WSH_DEBUG_SV.C_EXCEP_LEVEL);
484: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
485: --
486: END IF;
487: --
488: WHEN OTHERS THEN