DBA Data[Home] [Help]

APPS.WSH_MAPPING_DATA dependencies on FND_API

Line 289: raise fnd_api.g_exc_error;

285: WSH_DEBUG_SV.log(l_module_name, 'l_ship_to_loc_code', l_ship_to_loc_code);
286: END IF;
287:
288: IF l_ship_to_loc_code IS NULL THEN
289: raise fnd_api.g_exc_error;
290: END IF;
291:
292: IF (l_ship_to_site_contact_id is not null) THEN
293: --{

Line 301: RAISE FND_API.G_EXC_ERROR;

297: l_contact_person_name,
298: l_return_status
299: );
300: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;
303:
304: x_cnsgn_cont_per_name := l_contact_person_name;
305: x_cnsgn_cont_per_ph := l_per_ph_number;

Line 375: WHEN fnd_api.g_exc_error THEN

371: wsh_debug_sv.pop (l_module_name);
372: END IF;
373: EXCEPTION
374: --bug 3920178
375: WHEN fnd_api.g_exc_error THEN
376: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');

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

374: --bug 3920178
375: WHEN fnd_api.g_exc_error THEN
376: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
380: END IF;
381: WHEN wsh_invalid_delivery_id THEN
382: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

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

375: WHEN fnd_api.g_exc_error THEN
376: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
380: END IF;
381: WHEN wsh_invalid_delivery_id THEN
382: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
383: IF l_debug_on THEN

Line 1055: raise fnd_api.g_exc_error;

1051: end if;
1052:
1053: /* bug 4227777
1054: IF l_location IS NULL THEN
1055: raise fnd_api.g_exc_error;
1056: END IF;
1057: */
1058: x_location := l_location;
1059:

Line 1151: RAISE FND_API.G_EXC_ERROR;

1147: l_contact_person_name,
1148: l_return_status
1149: );
1150: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1151: RAISE FND_API.G_EXC_ERROR;
1152: END IF;
1153:
1154: x_cnsgn_cont_per_name := l_contact_person_name;
1155: x_cnsgn_cont_per_ph := l_per_ph_number;

Line 1169: WHEN FND_API.G_EXC_ERROR THEN

1165: wsh_debug_sv.pop(l_module_name);
1166: END IF;
1167:
1168: EXCEPTION
1169: WHEN FND_API.G_EXC_ERROR THEN
1170: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1171: wsh_util_core.add_message(x_return_status, l_module_name);
1172: --
1173: IF l_debug_on THEN

Line 1174: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1170: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1171: wsh_util_core.add_message(x_return_status, l_module_name);
1172: --
1173: IF l_debug_on THEN
1174: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1175: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1176: END IF;
1177: WHEN OTHERS THEN
1178: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

1171: wsh_util_core.add_message(x_return_status, l_module_name);
1172: --
1173: IF l_debug_on THEN
1174: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1175: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1176: END IF;
1177: WHEN OTHERS THEN
1178: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1179: IF l_debug_on THEN

Line 1563: raise fnd_api.g_exc_error;

1559: WSH_DEBUG_SV.log(l_module_name, 'l_ship_to_loc_code', l_ship_to_loc_code);
1560: END IF;
1561:
1562: IF l_ship_to_loc_code IS NULL THEN
1563: raise fnd_api.g_exc_error;
1564: END IF;
1565:
1566: x_ship_to_loc_code := l_ship_to_loc_code;
1567:

Line 1628: WHEN fnd_api.g_exc_error THEN

1624: wsh_debug_sv.pop (l_module_name);
1625: END IF;
1626: --
1627: EXCEPTION
1628: WHEN fnd_api.g_exc_error THEN
1629: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1630: IF l_debug_on THEN
1631: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1632: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');

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

1627: EXCEPTION
1628: WHEN fnd_api.g_exc_error THEN
1629: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1630: IF l_debug_on THEN
1631: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1632: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
1633: END IF;
1634: WHEN wsh_invalid_delivery_id THEN
1635: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

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

1628: WHEN fnd_api.g_exc_error THEN
1629: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1630: IF l_debug_on THEN
1631: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1632: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
1633: END IF;
1634: WHEN wsh_invalid_delivery_id THEN
1635: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1636: IF l_debug_on THEN

Line 1894: RAISE FND_API.G_EXC_ERROR;

1890: x_shipto_cont_per_name,
1891: l_return_status
1892: );
1893: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1894: RAISE FND_API.G_EXC_ERROR;
1895: END IF;
1896: x_shipto_cont_per_id := l_uniq_ship_to_contact_id;
1897:
1898: END IF; --}

Line 1959: WHEN FND_API.G_EXC_ERROR THEN

1955: wsh_debug_sv.pop(l_module_name);
1956: END IF;
1957:
1958: EXCEPTION
1959: WHEN FND_API.G_EXC_ERROR THEN
1960: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1961: wsh_util_core.add_message(x_return_status, l_module_name);
1962: --
1963: IF l_debug_on THEN

Line 1964: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1960: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1961: wsh_util_core.add_message(x_return_status, l_module_name);
1962: --
1963: IF l_debug_on THEN
1964: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1965: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1966: END IF;
1967: WHEN OTHERS THEN
1968: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

1961: wsh_util_core.add_message(x_return_status, l_module_name);
1962: --
1963: IF l_debug_on THEN
1964: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1965: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1966: END IF;
1967: WHEN OTHERS THEN
1968: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1969: IF l_debug_on THEN

Line 2184: WHEN FND_API.G_EXC_ERROR THEN

2180: wsh_debug_sv.pop(l_module_name);
2181: END IF;
2182:
2183: EXCEPTION
2184: WHEN FND_API.G_EXC_ERROR THEN
2185: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2186: wsh_util_core.add_message(x_return_status, l_module_name);
2187: --
2188: IF l_debug_on THEN

Line 2189: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2185: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2186: wsh_util_core.add_message(x_return_status, l_module_name);
2187: --
2188: IF l_debug_on THEN
2189: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2191: END IF;
2192: WHEN OTHERS THEN
2193: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

2186: wsh_util_core.add_message(x_return_status, l_module_name);
2187: --
2188: IF l_debug_on THEN
2189: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2191: END IF;
2192: WHEN OTHERS THEN
2193: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2194: IF l_debug_on THEN

Line 2310: RAISE FND_API.G_EXC_ERROR;

2306: x_contact_name,
2307: l_return_status
2308: );
2309: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2310: RAISE FND_API.G_EXC_ERROR;
2311: END IF;
2312: END IF;
2313:
2314: IF l_debug_on THEN

Line 2624: RAISE FND_API.G_EXC_ERROR;

2620: x_contact_name,
2621: l_return_status
2622: );
2623: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2624: RAISE FND_API.G_EXC_ERROR;
2625: END IF;
2626: END IF;
2627:
2628: IF l_debug_on THEN

Line 2684: RAISE FND_API.G_EXC_ERROR;

2680: x_contact_name,
2681: l_return_status
2682: );
2683: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2684: RAISE FND_API.G_EXC_ERROR;
2685: END IF;
2686: END IF; --}
2687:
2688: IF l_debug_on THEN

Line 3043: RAISE FND_API.G_EXC_ERROR;

3039: x_contact_person_name => x_contact_name,
3040: x_return_status => l_return_status );
3041:
3042: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3043: RAISE FND_API.G_EXC_ERROR;
3044: END IF;
3045: END IF;
3046: ELSIF p_partner_type = 'BillTo' THEN
3047: OPEN c_cust_site_location(l_invoice_to_site_use_id);

Line 3073: RAISE FND_API.G_EXC_ERROR;

3069: x_contact_person_name => x_contact_name,
3070: x_return_status => l_return_status );
3071:
3072: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3073: RAISE FND_API.G_EXC_ERROR;
3074: END IF;
3075: END IF;
3076: ELSIF p_partner_type = 'DeliverTo' THEN
3077: OPEN c_cust_site_location(l_deliver_to_site_use_id);

Line 3103: RAISE FND_API.G_EXC_ERROR;

3099: x_contact_person_name => x_contact_name,
3100: x_return_status => l_return_status );
3101:
3102: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3103: RAISE FND_API.G_EXC_ERROR;
3104: END IF;
3105: END IF;
3106: END IF;
3107:

Line 3115: WHEN FND_API.G_EXC_ERROR THEN

3111: WSH_DEBUG_SV.pop(l_module_name);
3112: END IF;
3113: --
3114: EXCEPTION
3115: WHEN FND_API.G_EXC_ERROR THEN
3116: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3117: --
3118: IF l_debug_on THEN
3119: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

3115: WHEN FND_API.G_EXC_ERROR THEN
3116: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3117: --
3118: IF l_debug_on THEN
3119: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3120: END IF;
3121: --
3122: WHEN others THEN
3123: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3256: WHEN FND_API.G_EXC_ERROR THEN

3252: WSH_DEBUG_SV.pop(l_module_name);
3253: END IF;
3254: --
3255: EXCEPTION
3256: WHEN FND_API.G_EXC_ERROR THEN
3257: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3258: --
3259: IF l_debug_on THEN
3260: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

3256: WHEN FND_API.G_EXC_ERROR THEN
3257: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3258: --
3259: IF l_debug_on THEN
3260: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3261: END IF;
3262: --
3263: WHEN others THEN
3264: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;