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 1077: RAISE fnd_api.g_exc_error;

1073: l_cancellation_in_progress);
1074: END IF;
1075:
1076: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1077: RAISE fnd_api.g_exc_error;
1078: END IF;
1079:
1080: IF l_cancellation_in_progress THEN
1081:

Line 1083: RAISE fnd_api.g_exc_error;

1079:
1080: IF l_cancellation_in_progress THEN
1081:
1082: update_atnms(l_txns_history_rec.transaction_id);
1083: RAISE fnd_api.g_exc_error;
1084:
1085: END IF;
1086:
1087: END IF; --}

Line 1145: WHEN fnd_api.g_exc_error THEN

1141: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_process_inbound exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1142: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_process_inbound');
1143: END IF;
1144: raise;
1145: WHEN fnd_api.g_exc_error THEN
1146: resultout := 'COMPLETE:FAILURE';
1147: IF l_debug_on THEN
1148: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1149: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');

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

1144: raise;
1145: WHEN fnd_api.g_exc_error THEN
1146: resultout := 'COMPLETE:FAILURE';
1147: IF l_debug_on THEN
1148: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1149: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
1150: END IF;
1151: raise;
1152: WHEN OTHERS THEN

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

1145: WHEN fnd_api.g_exc_error THEN
1146: resultout := 'COMPLETE:FAILURE';
1147: IF l_debug_on THEN
1148: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1149: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
1150: END IF;
1151: raise;
1152: WHEN OTHERS THEN
1153: resultout := 'COMPLETE:FAILURE';

Line 1628: RAISE fnd_api.g_exc_error;

1624: END IF;
1625: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_NOT_FOUND');
1626: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
1627: CLOSE c_del_status;
1628: RAISE fnd_api.g_exc_error;
1629: END IF;
1630: IF l_debug_on THEN
1631: wsh_debug_sv.log(l_module_name, 'l_status',l_status);
1632: END IF;

Line 1702: WHEN fnd_api.g_exc_error THEN

1698: x_cancellation_in_progress);
1699: wsh_debug_sv.pop(l_module_name);
1700: END IF;
1701:
1702: WHEN fnd_api.g_exc_error THEN
1703: x_return_status := fnd_api.g_ret_sts_error;
1704: --
1705: IF l_debug_on THEN
1706: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);

Line 1703: x_return_status := fnd_api.g_ret_sts_error;

1699: wsh_debug_sv.pop(l_module_name);
1700: END IF;
1701:
1702: WHEN fnd_api.g_exc_error THEN
1703: x_return_status := fnd_api.g_ret_sts_error;
1704: --
1705: IF l_debug_on THEN
1706: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
1707: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');

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

1702: WHEN fnd_api.g_exc_error THEN
1703: x_return_status := fnd_api.g_ret_sts_error;
1704: --
1705: IF l_debug_on THEN
1706: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
1707: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
1708: END IF;
1709: WHEN OTHERS THEN
1710: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

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

1703: x_return_status := fnd_api.g_ret_sts_error;
1704: --
1705: IF l_debug_on THEN
1706: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
1707: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
1708: END IF;
1709: WHEN OTHERS THEN
1710: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1711: wsh_util_core.default_handler('WSH_TRANSACTIONS_UTIL.check_cancellation_inprogress',l_module_name);

Line 1813: RAISE fnd_api.g_exc_error;

1809: IF l_debug_on THEN
1810: wsh_debug_sv.logmsg(l_module_name, 'Error, invalid interface delivery');
1811: END IF;
1812: CLOSE c_del_name_cur;
1813: RAISE fnd_api.g_exc_error;
1814: END IF;
1815: CLOSE c_del_name_cur;
1816:
1817: IF l_debug_on THEN

Line 1845: RAISE FND_API.g_exc_error;

1841:
1842: IF l_debug_on THEN
1843: wsh_debug_sv.log(l_module_name, 'Error in updating the transaction hsitory record to status AP',SQL%ROWCOUNT);
1844: END IF;
1845: RAISE FND_API.g_exc_error;
1846: END IF;
1847: RAISE e_send_yes;
1848:
1849: ELSE --}{

Line 1883: WHEN fnd_api.g_exc_unexpected_error THEN

1879: wsh_debug_sv.log(l_module_name, 'resultout', resultout);
1880: wsh_debug_sv.pop(l_module_name);
1881: END IF;
1882:
1883: WHEN fnd_api.g_exc_unexpected_error THEN
1884: --bmso how do we rollback;
1885: --also COMPLETE:FAILURE does not exist for this
1886: rollback to s_Check_cancellation_wf;
1887: resultout := 'COMPLETE:FAILURE';

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

1886: rollback to s_Check_cancellation_wf;
1887: resultout := 'COMPLETE:FAILURE';
1888: --
1889: IF l_debug_on THEN
1890: wsh_debug_sv.logmsg(l_module_name, 'fnd_api.g_exc_unexpected_error exception has occured.', wsh_debug_sv.c_excep_level);
1891: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:fnd_api.g_exc_unexpected_error');
1892: END IF;
1893: RAISE;
1894:

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

1887: resultout := 'COMPLETE:FAILURE';
1888: --
1889: IF l_debug_on THEN
1890: wsh_debug_sv.logmsg(l_module_name, 'fnd_api.g_exc_unexpected_error exception has occured.', wsh_debug_sv.c_excep_level);
1891: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:fnd_api.g_exc_unexpected_error');
1892: END IF;
1893: RAISE;
1894:
1895: WHEN fnd_api.g_exc_error THEN

Line 1895: WHEN fnd_api.g_exc_error THEN

1891: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:fnd_api.g_exc_unexpected_error');
1892: END IF;
1893: RAISE;
1894:
1895: WHEN fnd_api.g_exc_error THEN
1896: rollback to s_Check_cancellation_wf;
1897: resultout := 'COMPLETE:FAILURE';
1898: --
1899: IF l_debug_on THEN

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

1896: rollback to s_Check_cancellation_wf;
1897: resultout := 'COMPLETE:FAILURE';
1898: --
1899: IF l_debug_on THEN
1900: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
1901: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
1902: END IF;
1903:
1904: RAISE;

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

1897: resultout := 'COMPLETE:FAILURE';
1898: --
1899: IF l_debug_on THEN
1900: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
1901: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
1902: END IF;
1903:
1904: RAISE;
1905: WHEN OTHERS THEN