DBA Data[Home] [Help]

APPS.WSH_RCV_CORR_RTV_TXN_PKG dependencies on FND_API

Line 174: RAISE FND_API.G_EXC_ERROR;

170: --{
171: FND_MESSAGE.SET_NAME('WSH','WSH_UI_NEGATIVE_QTY');
172: x_return_status := wsh_util_core.g_ret_sts_error;
173: wsh_util_core.add_message(x_return_status, l_module_name);
174: RAISE FND_API.G_EXC_ERROR;
175: --}
176: END IF;
177: IF nvl(x_matched_detail_rec.received_qty_db_tab(p_matched_detail_index),0) > nvl(x_matched_detail_rec.received_qty_tab(p_matched_detail_index),0) THEN
178: --{

Line 221: RAISE FND_API.G_EXC_ERROR;

217: p_action => 'GET',
218: x_return_status => l_return_status);
219:
220: IF l_return_status IN (wsh_util_core.g_ret_sts_error, wsh_util_core.g_ret_sts_unexp_error) THEN
221: RAISE FND_API.G_EXC_ERROR;
222: END IF;
223:
224: IF (l_return_status = wsh_util_core.g_ret_sts_warning) THEN
225: --{

Line 396: RAISE FND_API.G_EXC_ERROR;

392: p_action => 'GET',
393: x_return_status => l_return_status);
394:
395: IF l_return_status IN (wsh_util_core.g_ret_sts_error, wsh_util_core.g_ret_sts_unexp_error) THEN
396: RAISE FND_API.G_EXC_ERROR;
397: END IF;
398:
399: IF (l_return_status = wsh_util_core.g_ret_sts_warning) THEN
400: --{

Line 452: WHEN FND_API.G_EXC_ERROR THEN

448: END IF;
449: --
450: EXCEPTION
451: --{
452: WHEN FND_API.G_EXC_ERROR THEN
453: ROLLBACK TO PROCESS_RCV;
454: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
455: --
456: -- Debug Statements

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

455: --
456: -- Debug Statements
457: --
458: IF l_debug_on THEN
459: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
460: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
461: END IF;
462: --
463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

456: -- Debug Statements
457: --
458: IF l_debug_on THEN
459: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
460: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
461: END IF;
462: --
463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
464: ROLLBACK TO PROCESS_RCV;

Line 463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

459: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
460: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
461: END IF;
462: --
463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
464: ROLLBACK TO PROCESS_RCV;
465: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
466: --
467: -- Debug Statements

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

466: --
467: -- Debug Statements
468: --
469: IF l_debug_on THEN
470: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
471: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
472: END IF;
473: --
474: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 471: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

467: -- Debug Statements
468: --
469: IF l_debug_on THEN
470: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
471: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
472: END IF;
473: --
474: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
475: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 578: RAISE FND_API.G_EXC_ERROR;

574: --{
575: FND_MESSAGE.SET_NAME('WSH','WSH_UI_NEGATIVE_QTY');
576: x_return_status := wsh_util_core.g_ret_sts_error;
577: wsh_util_core.add_message(x_return_status, l_module_name);
578: RAISE FND_API.G_EXC_ERROR;
579: --}
580: END IF;
581: IF nvl(x_matched_detail_rec.returned_qty_db_tab(p_matched_detail_index),0) <> nvl(x_matched_detail_rec.returned_qty_tab(p_matched_detail_index),0) THEN
582: --{

Line 624: WHEN FND_API.G_EXC_ERROR THEN

620: END IF;
621: --
622: EXCEPTION
623: --{
624: WHEN FND_API.G_EXC_ERROR THEN
625: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
626: --
627: -- Debug Statements
628: --

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

626: --
627: -- Debug Statements
628: --
629: IF l_debug_on THEN
630: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
631: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
632: END IF;
633: --
634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

627: -- Debug Statements
628: --
629: IF l_debug_on THEN
630: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
631: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
632: END IF;
633: --
634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
635: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

630: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
631: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
632: END IF;
633: --
634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
635: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
636: --
637: -- Debug Statements
638: --

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

636: --
637: -- Debug Statements
638: --
639: IF l_debug_on THEN
640: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
641: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
642: END IF;
643: --
644: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 641: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

637: -- Debug Statements
638: --
639: IF l_debug_on THEN
640: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
641: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
642: END IF;
643: --
644: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
645: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 676: -- p_init_msg_list FND_API.G_TRUE to reset list

672: -- Matching Algorithm to match the
673: -- Corrections and RTV transactions.
674: --
675: -- PARAMETERS: p_api_version Known api version error number
676: -- p_init_msg_list FND_API.G_TRUE to reset list
677: -- p_rtv_corr_in_rec global line rec type (not used)
678: -- p_matched_detail_rec record of matched delivery details
679: -- p_action_prms action parameters record type
680: -- p_rtv_corr_out_rec output record of the API (not used)

Line 1423: RAISE FND_API.G_EXC_ERROR;

1419: p_action => 'GET',
1420: x_return_status => l_return_status);
1421:
1422: IF l_return_status IN (wsh_util_core.g_ret_sts_error, wsh_util_core.g_ret_sts_unexp_error) THEN
1423: RAISE FND_API.G_EXC_ERROR;
1424: END IF;
1425:
1426: IF (l_return_status = wsh_util_core.g_ret_sts_warning) THEN
1427: --{

Line 1534: WHEN FND_API.G_EXC_ERROR THEN

1530: END IF;
1531: --
1532: EXCEPTION
1533: --{
1534: WHEN FND_API.G_EXC_ERROR THEN
1535: ROLLBACK TO process_corrections_and_rtv;
1536: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1537: --
1538: -- Debug Statements

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

1537: --
1538: -- Debug Statements
1539: --
1540: IF l_debug_on THEN
1541: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1542: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1543: END IF;
1544: --
1545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1538: -- Debug Statements
1539: --
1540: IF l_debug_on THEN
1541: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1542: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1543: END IF;
1544: --
1545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1546: ROLLBACK TO process_corrections_and_rtv;

Line 1545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1541: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1542: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1543: END IF;
1544: --
1545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1546: ROLLBACK TO process_corrections_and_rtv;
1547: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1548: --
1549: -- Debug Statements

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

1548: --
1549: -- Debug Statements
1550: --
1551: IF l_debug_on THEN
1552: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1553: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1554: END IF;
1555: --
1556: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 1553: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1549: -- Debug Statements
1550: --
1551: IF l_debug_on THEN
1552: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1553: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1554: END IF;
1555: --
1556: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1557: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

2217: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_LOCKED');
2218: wsh_util_core.add_message(x_return_status,l_module_name);
2219: IF l_debug_on THEN
2220: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2221: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2222: END IF;
2223: --
2224: WHEN FND_API.G_EXC_ERROR THEN
2225: ROLLBACK TO PR_REM_REQ_QTY;

Line 2224: WHEN FND_API.G_EXC_ERROR THEN

2220: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2221: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2222: END IF;
2223: --
2224: WHEN FND_API.G_EXC_ERROR THEN
2225: ROLLBACK TO PR_REM_REQ_QTY;
2226: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2227: --
2228: -- Debug Statements

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

2227: --
2228: -- Debug Statements
2229: --
2230: IF l_debug_on THEN
2231: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2232: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2233: END IF;
2234: --
2235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2228: -- Debug Statements
2229: --
2230: IF l_debug_on THEN
2231: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2232: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2233: END IF;
2234: --
2235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2236: ROLLBACK TO PR_REM_REQ_QTY;

Line 2235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2231: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2232: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2233: END IF;
2234: --
2235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2236: ROLLBACK TO PR_REM_REQ_QTY;
2237: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2238: --
2239: -- Debug Statements

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

2238: --
2239: -- Debug Statements
2240: --
2241: IF l_debug_on THEN
2242: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2243: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2244: END IF;
2245: --
2246: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 2243: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2239: -- Debug Statements
2240: --
2241: IF l_debug_on THEN
2242: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2243: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2244: END IF;
2245: --
2246: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2247: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;