DBA Data[Home] [Help]

APPS.WSH_TRANSACTIONS_UTIL dependencies on FND_API

Line 354: IF ( nvl(l_valid_del_tmp,FND_API.G_MISS_CHAR) = 'X' ) THEN

350: open valid_del_cur(p_entity_id);
351: Fetch valid_del_cur into l_valid_del_tmp;
352: close valid_del_cur;
353:
354: IF ( nvl(l_valid_del_tmp,FND_API.G_MISS_CHAR) = 'X' ) THEN
355: raise wsh_invalid_delivery;
356: END IF;
357: */
358:

Line 1120: RAISE fnd_api.g_exc_error;

1116: l_cancellation_in_progress);
1117: END IF;
1118:
1119: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1120: RAISE fnd_api.g_exc_error;
1121: END IF;
1122:
1123: IF l_cancellation_in_progress THEN
1124:

Line 1126: RAISE fnd_api.g_exc_error;

1122:
1123: IF l_cancellation_in_progress THEN
1124:
1125: update_atnms(l_txns_history_rec.transaction_id);
1126: RAISE fnd_api.g_exc_error;
1127:
1128: END IF;
1129:
1130: END IF; --}

Line 1200: WHEN fnd_api.g_exc_error THEN

1196: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_process_inbound exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1197: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_process_inbound');
1198: END IF;
1199: raise;
1200: WHEN fnd_api.g_exc_error THEN
1201: resultout := 'COMPLETE:FAILURE';
1202: IF l_debug_on THEN
1203: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1204: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');

Line 1203: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1199: raise;
1200: WHEN fnd_api.g_exc_error THEN
1201: resultout := 'COMPLETE:FAILURE';
1202: IF l_debug_on THEN
1203: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1204: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
1205: END IF;
1206: raise;
1207: WHEN OTHERS THEN

Line 1204: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');

1200: WHEN fnd_api.g_exc_error THEN
1201: resultout := 'COMPLETE:FAILURE';
1202: IF l_debug_on THEN
1203: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1204: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
1205: END IF;
1206: raise;
1207: WHEN OTHERS THEN
1208: resultout := 'COMPLETE:FAILURE';

Line 1317: WHEN fnd_api.g_exc_error THEN

1313: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_process_inbound exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1314: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_process_inbound');
1315: END IF;
1316: -- raise;
1317: WHEN fnd_api.g_exc_error THEN
1318: resultout := 'COMPLETE:ERROR';
1319: IF l_debug_on THEN
1320: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1321: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');

Line 1320: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1316: -- raise;
1317: WHEN fnd_api.g_exc_error THEN
1318: resultout := 'COMPLETE:ERROR';
1319: IF l_debug_on THEN
1320: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1321: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
1322: END IF;
1323: -- raise;
1324: WHEN OTHERS THEN

Line 1321: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');

1317: WHEN fnd_api.g_exc_error THEN
1318: resultout := 'COMPLETE:ERROR';
1319: IF l_debug_on THEN
1320: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1321: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
1322: END IF;
1323: -- raise;
1324: WHEN OTHERS THEN
1325: resultout := 'COMPLETE:ERROR';

Line 1910: RAISE fnd_api.g_exc_error;

1906: END IF;
1907: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_NOT_FOUND');
1908: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
1909: CLOSE c_del_status;
1910: RAISE fnd_api.g_exc_error;
1911: END IF;
1912: IF l_debug_on THEN
1913: wsh_debug_sv.log(l_module_name, 'l_status',l_status);
1914: END IF;

Line 1984: WHEN fnd_api.g_exc_error THEN

1980: x_cancellation_in_progress);
1981: wsh_debug_sv.pop(l_module_name);
1982: END IF;
1983:
1984: WHEN fnd_api.g_exc_error THEN
1985: x_return_status := fnd_api.g_ret_sts_error;
1986: --
1987: IF l_debug_on THEN
1988: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);

Line 1985: x_return_status := fnd_api.g_ret_sts_error;

1981: wsh_debug_sv.pop(l_module_name);
1982: END IF;
1983:
1984: WHEN fnd_api.g_exc_error THEN
1985: x_return_status := fnd_api.g_ret_sts_error;
1986: --
1987: IF l_debug_on THEN
1988: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
1989: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');

Line 1988: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);

1984: WHEN fnd_api.g_exc_error THEN
1985: x_return_status := fnd_api.g_ret_sts_error;
1986: --
1987: IF l_debug_on THEN
1988: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
1989: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
1990: END IF;
1991: WHEN OTHERS THEN
1992: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

Line 1989: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');

1985: x_return_status := fnd_api.g_ret_sts_error;
1986: --
1987: IF l_debug_on THEN
1988: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
1989: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
1990: END IF;
1991: WHEN OTHERS THEN
1992: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1993: wsh_util_core.default_handler('WSH_TRANSACTIONS_UTIL.check_cancellation_inprogress',l_module_name);

Line 2095: RAISE fnd_api.g_exc_error;

2091: IF l_debug_on THEN
2092: wsh_debug_sv.logmsg(l_module_name, 'Error, invalid interface delivery');
2093: END IF;
2094: CLOSE c_del_name_cur;
2095: RAISE fnd_api.g_exc_error;
2096: END IF;
2097: CLOSE c_del_name_cur;
2098:
2099: IF l_debug_on THEN

Line 2127: RAISE FND_API.g_exc_error;

2123:
2124: IF l_debug_on THEN
2125: wsh_debug_sv.log(l_module_name, 'Error in updating the transaction hsitory record to status AP',SQL%ROWCOUNT);
2126: END IF;
2127: RAISE FND_API.g_exc_error;
2128: END IF;
2129: RAISE e_send_yes;
2130:
2131: ELSE --}{

Line 2165: WHEN fnd_api.g_exc_unexpected_error THEN

2161: wsh_debug_sv.log(l_module_name, 'resultout', resultout);
2162: wsh_debug_sv.pop(l_module_name);
2163: END IF;
2164:
2165: WHEN fnd_api.g_exc_unexpected_error THEN
2166: --bmso how do we rollback;
2167: --also COMPLETE:FAILURE does not exist for this
2168: rollback to s_Check_cancellation_wf;
2169: resultout := 'COMPLETE:FAILURE';

Line 2172: wsh_debug_sv.logmsg(l_module_name, 'fnd_api.g_exc_unexpected_error exception has occured.', wsh_debug_sv.c_excep_level);

2168: rollback to s_Check_cancellation_wf;
2169: resultout := 'COMPLETE:FAILURE';
2170: --
2171: IF l_debug_on THEN
2172: wsh_debug_sv.logmsg(l_module_name, 'fnd_api.g_exc_unexpected_error exception has occured.', wsh_debug_sv.c_excep_level);
2173: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:fnd_api.g_exc_unexpected_error');
2174: END IF;
2175: RAISE;
2176:

Line 2173: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:fnd_api.g_exc_unexpected_error');

2169: resultout := 'COMPLETE:FAILURE';
2170: --
2171: IF l_debug_on THEN
2172: wsh_debug_sv.logmsg(l_module_name, 'fnd_api.g_exc_unexpected_error exception has occured.', wsh_debug_sv.c_excep_level);
2173: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:fnd_api.g_exc_unexpected_error');
2174: END IF;
2175: RAISE;
2176:
2177: WHEN fnd_api.g_exc_error THEN

Line 2177: WHEN fnd_api.g_exc_error THEN

2173: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:fnd_api.g_exc_unexpected_error');
2174: END IF;
2175: RAISE;
2176:
2177: WHEN fnd_api.g_exc_error THEN
2178: rollback to s_Check_cancellation_wf;
2179: resultout := 'COMPLETE:FAILURE';
2180: --
2181: IF l_debug_on THEN

Line 2182: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);

2178: rollback to s_Check_cancellation_wf;
2179: resultout := 'COMPLETE:FAILURE';
2180: --
2181: IF l_debug_on THEN
2182: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
2183: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
2184: END IF;
2185:
2186: RAISE;

Line 2183: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');

2179: resultout := 'COMPLETE:FAILURE';
2180: --
2181: IF l_debug_on THEN
2182: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
2183: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
2184: END IF;
2185:
2186: RAISE;
2187: WHEN OTHERS THEN