DBA Data[Home] [Help]

APPS.WSH_INTERFACE_VALIDATIONS_PKG dependencies on FND_API

Line 123: RAISE FND_API.G_EXC_ERROR;

119: IF l_debug_on THEN
120: wsh_debug_sv.logmsg(l_module_name, 'Inside No Data Found Exception to Derive TP ID');
121: END IF;
122: --
123: RAISE FND_API.G_EXC_ERROR;
124: --
125: WHEN TOO_MANY_ROWS THEN
126: --
127: IF l_debug_on THEN

Line 131: RAISE FND_API.G_EXC_ERROR;

127: IF l_debug_on THEN
128: wsh_debug_sv.logmsg (l_module_name, 'Inside Too many rows Exception to derive TP ID');
129: END IF;
130: --
131: RAISE FND_API.G_EXC_ERROR;
132: END;
133:
134: IF l_debug_on THEN
135: wsh_debug_sv.log(l_module_name, 'Derived TP ID successfully', x_trading_partner_ID);

Line 155: RAISE FND_API.G_EXC_ERROR;

151: --
152: IF l_debug_on THEN
153: wsh_debug_sv.log(l_module_name, 'EXCEPTION: Found duplicate', p_duplicate);
154: END IF;
155: RAISE FND_API.G_EXC_ERROR;
156: --
157: END IF;
158:
159: EXCEPTION

Line 163: x_valid_doc := fnd_api.g_true;

159: EXCEPTION
160: WHEN NO_DATA_FOUND THEN
161: --
162: x_return_status := wsh_util_core.g_ret_sts_success;
163: x_valid_doc := fnd_api.g_true;
164: --
165: WHEN TOO_MANY_ROWS THEN
166: --
167: IF l_debug_on THEN

Line 171: RAISE FND_API.G_EXC_ERROR;

167: IF l_debug_on THEN
168: wsh_debug_sv.logmsg(l_module_name, 'EXCEPTION: Too many rows when checking for duplicates');
169: END IF;
170: --
171: RAISE FND_API.G_EXC_ERROR;
172: --
173: END;
174:
175: IF l_debug_on THEN

Line 197: x_valid_doc := fnd_api.g_true;

193:
194: IF (p_940_exists = 'X')
195: THEN
196: x_return_status := wsh_util_core.g_ret_sts_success;
197: x_valid_doc := fnd_api.g_true;
198: IF l_debug_on THEN
199: wsh_debug_sv.log(l_module_name, '940 Add Exists for the 940 Cancellation sent, Return Status',X_Return_Status );
200: END IF;
201: END IF;

Line 209: RAISE FND_API.G_EXC_ERROR;

205: IF l_debug_on THEN
206: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION: No corresponding 940-Add exists');
207: END IF;
208: --
209: RAISE FND_API.G_EXC_ERROR;
210: END;
211: END IF; -- End of If (P_ACTION_TYPE = 'D') Then
212:
213: IF l_debug_on THEN

Line 236: x_valid_doc := fnd_api.g_true;

232:
233: IF (p_940_exists = 'X')
234: THEN
235: x_return_status := wsh_util_core.g_ret_sts_success;
236: x_valid_doc := fnd_api.g_true;
237: END IF;
238: EXCEPTION
239: WHEN NO_DATA_FOUND
240: THEN

Line 247: RAISE FND_API.G_EXC_ERROR;

243: wsh_debug_sv.logmsg(l_module_name, 'EXCEPTION: No data found when checking for 940-O when
244: 945-IN comes in');
245: END IF;
246: --
247: RAISE FND_API.G_EXC_ERROR;
248: --
249: END;
250: END IF; -- End of If (P_DOC_TYPE = 'SR') Then
251:

Line 258: WHEN FND_API.G_EXC_ERROR THEN

254: wsh_debug_sv.pop (l_module_name);
255: END IF;
256:
257: EXCEPTION
258: WHEN FND_API.G_EXC_ERROR THEN
259: --
260: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
261: x_Valid_Doc := FND_API.G_FALSE;
262: --

Line 261: x_Valid_Doc := FND_API.G_FALSE;

257: EXCEPTION
258: WHEN FND_API.G_EXC_ERROR THEN
259: --
260: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
261: x_Valid_Doc := FND_API.G_FALSE;
262: --
263: IF l_debug_on THEN
264: --
265: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Validate Document',X_Return_Status );

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

263: IF l_debug_on THEN
264: --
265: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Validate Document',X_Return_Status );
266: WSH_DEBUG_SV.log(l_module_name, 'x_valid_doc', x_Valid_Doc);
267: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
268: WSH_DEBUG_SV.C_EXCEP_LEVEL);
269: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
270: --
271: END IF;

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

265: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Validate Document',X_Return_Status );
266: WSH_DEBUG_SV.log(l_module_name, 'x_valid_doc', x_Valid_Doc);
267: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
268: WSH_DEBUG_SV.C_EXCEP_LEVEL);
269: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
270: --
271: END IF;
272: --
273: WHEN invalid_doc_number

Line 276: x_valid_doc := fnd_api.g_false;

272: --
273: WHEN invalid_doc_number
274: THEN
275: x_return_status := wsh_util_core.g_ret_sts_error;
276: x_valid_doc := fnd_api.g_false;
277: IF l_debug_on THEN
278: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_number exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
279: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_number');
280: END IF;

Line 284: x_valid_doc := fnd_api.g_false;

280: END IF;
281: WHEN invalid_tp
282: THEN
283: x_return_status := wsh_util_core.g_ret_sts_error;
284: x_valid_doc := fnd_api.g_false;
285: IF l_debug_on THEN
286: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_tp exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
287: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_tp');
288: END IF;

Line 292: x_valid_doc := fnd_api.g_false;

288: END IF;
289: WHEN invalid_doc_direction
290: THEN
291: x_return_status := wsh_util_core.g_ret_sts_error;
292: x_valid_doc := fnd_api.g_false;
293: IF l_debug_on THEN
294: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_direction exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
295: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_direction');
296: END IF;

Line 300: x_valid_doc := fnd_api.g_false;

296: END IF;
297: WHEN invalid_doc_type
298: THEN
299: x_return_status := wsh_util_core.g_ret_sts_error;
300: x_valid_doc := fnd_api.g_false;
301: IF l_debug_on THEN
302: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
303: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_type');
304: END IF;

Line 308: x_valid_doc := fnd_api.g_false;

304: END IF;
305: WHEN invalid_action_type
306: THEN
307: x_return_status := wsh_util_core.g_ret_sts_error;
308: x_valid_doc := fnd_api.g_false;
309: IF l_debug_on THEN
310: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
311: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_type');
312: END IF;

Line 316: x_valid_doc := fnd_api.g_false;

312: END IF;
313: WHEN OTHERS
314: THEN
315: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
316: x_valid_doc := fnd_api.g_false;
317: IF l_debug_on THEN
318: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
319: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
320: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');