DBA Data[Home] [Help]

APPS.WSH_IB_TXN_MATCH_PKG dependencies on FND_API

Line 285: RAISE FND_API.G_EXC_ERROR;

281: --{
282: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
283: FND_MESSAGE.SET_TOKEN('FIELD_NAME',l_fieldName);
284: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
285: RAISE FND_API.G_EXC_ERROR;
286: --}
287: END IF;
288: --
289: --

Line 316: WHEN FND_API.G_EXC_ERROR THEN

312: --
313: --}
314: EXCEPTION
315: --{
316: WHEN FND_API.G_EXC_ERROR THEN
317: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
318: --
319: -- Debug Statements
320: --

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

318: --
319: -- Debug Statements
320: --
321: IF l_debug_on THEN
322: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
323: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
324: END IF;
325: --
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

319: -- Debug Statements
320: --
321: IF l_debug_on THEN
322: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
323: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
324: END IF;
325: --
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

322: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
323: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
324: END IF;
325: --
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
328: --
329: -- Debug Statements
330: --

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

328: --
329: -- Debug Statements
330: --
331: IF l_debug_on THEN
332: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
333: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
334: END IF;
335: --
336: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

329: -- Debug Statements
330: --
331: IF l_debug_on THEN
332: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
333: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
334: END IF;
335: --
336: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
337: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 509: WHEN FND_API.G_EXC_ERROR THEN

505: --
506: --}
507: EXCEPTION
508: --{
509: WHEN FND_API.G_EXC_ERROR THEN
510: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
511: --
512: -- Debug Statements
513: --

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

511: --
512: -- Debug Statements
513: --
514: IF l_debug_on THEN
515: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
516: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
517: END IF;
518: --
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

512: -- Debug Statements
513: --
514: IF l_debug_on THEN
515: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
516: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
517: END IF;
518: --
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
520: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

515: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
516: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
517: END IF;
518: --
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
520: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
521: --
522: -- Debug Statements
523: --

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

521: --
522: -- Debug Statements
523: --
524: IF l_debug_on THEN
525: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
527: END IF;
528: --
529: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

522: -- Debug Statements
523: --
524: IF l_debug_on THEN
525: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
527: END IF;
528: --
529: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
530: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 703: RAISE FND_API.G_EXC_ERROR;

699: THEN
700: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_UPDATE_ERROR');
701: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_headerTransactionId);
702: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
703: RAISE FND_API.G_EXC_ERROR;
704: END IF;
705: --
706: --
707: --

Line 746: RAISE FND_API.G_EXC_ERROR;

742: IF l_eventKey IS NULL
743: THEN
744: FND_MESSAGE.SET_NAME('WSH','WSH_IB_EVENT_KEY_ERROR');
745: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
746: RAISE FND_API.G_EXC_ERROR;
747: END IF;
748: --
749: --
750: --

Line 894: WHEN FND_API.G_EXC_ERROR THEN

890: --
891: --}
892: EXCEPTION
893: --{
894: WHEN FND_API.G_EXC_ERROR THEN
895: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
896: --
897: -- Debug Statements
898: --

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

896: --
897: -- Debug Statements
898: --
899: IF l_debug_on THEN
900: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
901: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
902: END IF;
903: --
904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

897: -- Debug Statements
898: --
899: IF l_debug_on THEN
900: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
901: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
902: END IF;
903: --
904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
905: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

900: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
901: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
902: END IF;
903: --
904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
905: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
906: --
907: -- Debug Statements
908: --

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

906: --
907: -- Debug Statements
908: --
909: IF l_debug_on THEN
910: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
911: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
912: END IF;
913: --
914: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

907: -- Debug Statements
908: --
909: IF l_debug_on THEN
910: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
911: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
912: END IF;
913: --
914: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
915: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1044: RAISE FND_API.G_EXC_ERROR;

1040: --{
1041: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_TXN_TYPE');
1042: FND_MESSAGE.SET_TOKEN('TXN_TYPE',p_transactionType);
1043: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1044: RAISE FND_API.G_EXC_ERROR;
1045: --}
1046: END IF;
1047: --
1048: --

Line 1073: WHEN FND_API.G_EXC_ERROR THEN

1069: --
1070: --}
1071: EXCEPTION
1072: --{
1073: WHEN FND_API.G_EXC_ERROR THEN
1074: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1075: --
1076: -- Debug Statements
1077: --

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

1075: --
1076: -- Debug Statements
1077: --
1078: IF l_debug_on THEN
1079: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1080: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1081: END IF;
1082: --
1083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1076: -- Debug Statements
1077: --
1078: IF l_debug_on THEN
1079: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1080: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1081: END IF;
1082: --
1083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1084: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 1083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1079: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1080: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1081: END IF;
1082: --
1083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1084: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1085: --
1086: -- Debug Statements
1087: --

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

1085: --
1086: -- Debug Statements
1087: --
1088: IF l_debug_on THEN
1089: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1090: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1091: END IF;
1092: --
1093: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

1086: -- Debug Statements
1087: --
1088: IF l_debug_on THEN
1089: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1090: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1091: END IF;
1092: --
1093: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1094: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1244: WHEN FND_API.G_EXC_ERROR THEN

1240: --
1241: --}
1242: EXCEPTION
1243: --{
1244: WHEN FND_API.G_EXC_ERROR THEN
1245: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1246: --
1247: -- Debug Statements
1248: --

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

1246: --
1247: -- Debug Statements
1248: --
1249: IF l_debug_on THEN
1250: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1251: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1252: END IF;
1253: --
1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1247: -- Debug Statements
1248: --
1249: IF l_debug_on THEN
1250: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1251: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1252: END IF;
1253: --
1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1255: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1250: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1251: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1252: END IF;
1253: --
1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1255: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1256: --
1257: -- Debug Statements
1258: --

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

1256: --
1257: -- Debug Statements
1258: --
1259: IF l_debug_on THEN
1260: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1261: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1262: END IF;
1263: --
1264: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

1257: -- Debug Statements
1258: --
1259: IF l_debug_on THEN
1260: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1261: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1262: END IF;
1263: --
1264: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1265: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1461: WHEN FND_API.G_EXC_ERROR THEN

1457: --
1458: --}
1459: EXCEPTION
1460: --{
1461: WHEN FND_API.G_EXC_ERROR THEN
1462: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1463: --
1464: -- Debug Statements
1465: --

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

1463: --
1464: -- Debug Statements
1465: --
1466: IF l_debug_on THEN
1467: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1468: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1469: END IF;
1470: --
1471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1464: -- Debug Statements
1465: --
1466: IF l_debug_on THEN
1467: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1468: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1469: END IF;
1470: --
1471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1472: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 1471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1467: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1468: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1469: END IF;
1470: --
1471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1472: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1473: --
1474: -- Debug Statements
1475: --

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

1473: --
1474: -- Debug Statements
1475: --
1476: IF l_debug_on THEN
1477: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1478: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1479: END IF;
1480: --
1481: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

1474: -- Debug Statements
1475: --
1476: IF l_debug_on THEN
1477: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1478: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1479: END IF;
1480: --
1481: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1482: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1637: RAISE FND_API.G_EXC_ERROR;

1633: FND_MESSAGE.SET_TOKEN('RECEIPT_NUMBER',l_txnHistoryRec.RECEIPT_NUMBER);
1634: END IF;
1635: --
1636: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1637: RAISE FND_API.G_EXC_ERROR;
1638: --}
1639: ELSE
1640: --{
1641: x_transactionId := l_txnHistoryRec.transaction_id;

Line 1776: RAISE FND_API.G_EXC_ERROR;

1772: --{
1773: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_TXN_TYPE');
1774: FND_MESSAGE.SET_TOKEN('TXN_TYPE',p_transactionType);
1775: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1776: RAISE FND_API.G_EXC_ERROR;
1777: --}
1778: END IF;
1779: --
1780: --

Line 1856: WHEN FND_API.G_EXC_ERROR THEN

1852: --
1853: --}
1854: EXCEPTION
1855: --{
1856: WHEN FND_API.G_EXC_ERROR THEN
1857: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1858: --
1859: -- Debug Statements
1860: --

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

1858: --
1859: -- Debug Statements
1860: --
1861: IF l_debug_on THEN
1862: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1863: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1864: END IF;
1865: --
1866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1859: -- Debug Statements
1860: --
1861: IF l_debug_on THEN
1862: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1863: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1864: END IF;
1865: --
1866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1867: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 1866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1862: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1863: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1864: END IF;
1865: --
1866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1867: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1868: --
1869: -- Debug Statements
1870: --

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

1868: --
1869: -- Debug Statements
1870: --
1871: IF l_debug_on THEN
1872: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1873: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1874: END IF;
1875: --
1876: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

1869: -- Debug Statements
1870: --
1871: IF l_debug_on THEN
1872: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1873: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1874: END IF;
1875: --
1876: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1877: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1967: RAISE FND_API.G_EXC_ERROR;

1963: --{
1964: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DUP_CANCEL_ASN_ERROR');
1965: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER',x_parentTxnHistoryRec.SHIPMENT_NUMBER);
1966: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1967: RAISE FND_API.G_EXC_ERROR;
1968: --}
1969: END IF;
1970: --
1971: --

Line 2084: RAISE FND_API.G_EXC_ERROR;

2080: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning);
2081: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',x_parentTxnHistoryRec.RECEIPT_NUMBER);
2082: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',x_parentTxnHistoryRec.SHIPMENT_NUMBER);
2083: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
2084: RAISE FND_API.G_EXC_ERROR;
2085: --}
2086: END IF;
2087: --}
2088: END IF;

Line 2117: WHEN FND_API.G_EXC_ERROR THEN

2113: --
2114: --}
2115: EXCEPTION
2116: --{
2117: WHEN FND_API.G_EXC_ERROR THEN
2118: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2119: --
2120: -- Debug Statements
2121: --

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

2119: --
2120: -- Debug Statements
2121: --
2122: IF l_debug_on THEN
2123: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2124: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2125: END IF;
2126: --
2127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2120: -- Debug Statements
2121: --
2122: IF l_debug_on THEN
2123: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2124: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2125: END IF;
2126: --
2127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2128: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 2127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2123: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2124: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2125: END IF;
2126: --
2127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2128: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2129: --
2130: -- Debug Statements
2131: --

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

2129: --
2130: -- Debug Statements
2131: --
2132: IF l_debug_on THEN
2133: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2134: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2135: END IF;
2136: --
2137: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

2130: -- Debug Statements
2131: --
2132: IF l_debug_on THEN
2133: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2134: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2135: END IF;
2136: --
2137: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2138: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2224: WHEN FND_API.G_EXC_ERROR THEN

2220: --
2221: --}
2222: EXCEPTION
2223: --{
2224: WHEN FND_API.G_EXC_ERROR THEN
2225: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2226: --
2227: -- Debug Statements
2228: --

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

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

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

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

Line 2234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

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

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

Line 2353: WHEN FND_API.G_EXC_ERROR THEN

2349: --
2350: --}
2351: EXCEPTION
2352: --{
2353: WHEN FND_API.G_EXC_ERROR THEN
2354: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2355: --
2356: -- Debug Statements
2357: --

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

2355: --
2356: -- Debug Statements
2357: --
2358: IF l_debug_on THEN
2359: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2360: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2361: END IF;
2362: --
2363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2356: -- Debug Statements
2357: --
2358: IF l_debug_on THEN
2359: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2360: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2361: END IF;
2362: --
2363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2364: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 2363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2359: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2360: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2361: END IF;
2362: --
2363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2364: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2365: --
2366: -- Debug Statements
2367: --

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

2365: --
2366: -- Debug Statements
2367: --
2368: IF l_debug_on THEN
2369: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2370: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2371: END IF;
2372: --
2373: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

2366: -- Debug Statements
2367: --
2368: IF l_debug_on THEN
2369: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2370: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2371: END IF;
2372: --
2373: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2374: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2521: WHEN FND_API.G_EXC_ERROR THEN

2517: --
2518: --}
2519: EXCEPTION
2520: --{
2521: WHEN FND_API.G_EXC_ERROR THEN
2522: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2523: --
2524: -- Debug Statements
2525: --

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

2523: --
2524: -- Debug Statements
2525: --
2526: IF l_debug_on THEN
2527: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2528: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2529: END IF;
2530: --
2531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2524: -- Debug Statements
2525: --
2526: IF l_debug_on THEN
2527: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2528: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2529: END IF;
2530: --
2531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2532: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 2531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2527: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2528: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2529: END IF;
2530: --
2531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2532: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2533: --
2534: -- Debug Statements
2535: --

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

2533: --
2534: -- Debug Statements
2535: --
2536: IF l_debug_on THEN
2537: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2538: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2539: END IF;
2540: --
2541: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

2534: -- Debug Statements
2535: --
2536: IF l_debug_on THEN
2537: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2538: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2539: END IF;
2540: --
2541: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2542: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2679: WHEN FND_API.G_EXC_ERROR THEN

2675: --
2676: --}
2677: EXCEPTION
2678: --{
2679: WHEN FND_API.G_EXC_ERROR THEN
2680: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2681: --
2682: -- Debug Statements
2683: --

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

2681: --
2682: -- Debug Statements
2683: --
2684: IF l_debug_on THEN
2685: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2686: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2687: END IF;
2688: --
2689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2682: -- Debug Statements
2683: --
2684: IF l_debug_on THEN
2685: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2686: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2687: END IF;
2688: --
2689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2690: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 2689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2685: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2686: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2687: END IF;
2688: --
2689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2690: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2691: --
2692: -- Debug Statements
2693: --

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

2691: --
2692: -- Debug Statements
2693: --
2694: IF l_debug_on THEN
2695: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2696: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2697: END IF;
2698: --
2699: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

2692: -- Debug Statements
2693: --
2694: IF l_debug_on THEN
2695: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2696: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2697: END IF;
2698: --
2699: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2700: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2899: WHEN FND_API.G_EXC_ERROR THEN

2895: --
2896: --}
2897: EXCEPTION
2898: --{
2899: WHEN FND_API.G_EXC_ERROR THEN
2900: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2901: --
2902: -- Debug Statements
2903: --

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

2901: --
2902: -- Debug Statements
2903: --
2904: IF l_debug_on THEN
2905: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2906: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2907: END IF;
2908: --
2909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2902: -- Debug Statements
2903: --
2904: IF l_debug_on THEN
2905: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2906: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2907: END IF;
2908: --
2909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2910: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 2909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2905: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2906: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2907: END IF;
2908: --
2909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2910: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2911: --
2912: -- Debug Statements
2913: --

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

2911: --
2912: -- Debug Statements
2913: --
2914: IF l_debug_on THEN
2915: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2916: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2917: END IF;
2918: --
2919: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

2912: -- Debug Statements
2913: --
2914: IF l_debug_on THEN
2915: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2916: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2917: END IF;
2918: --
2919: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2920: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 3109: WHEN FND_API.G_EXC_ERROR THEN

3105: --
3106: --}
3107: EXCEPTION
3108: --{
3109: WHEN FND_API.G_EXC_ERROR THEN
3110: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3111: --
3112: -- Debug Statements
3113: --

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

3111: --
3112: -- Debug Statements
3113: --
3114: IF l_debug_on THEN
3115: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3116: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3117: END IF;
3118: --
3119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3112: -- Debug Statements
3113: --
3114: IF l_debug_on THEN
3115: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3116: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3117: END IF;
3118: --
3119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3120: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 3119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3115: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3116: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3117: END IF;
3118: --
3119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3120: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3121: --
3122: -- Debug Statements
3123: --

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

3121: --
3122: -- Debug Statements
3123: --
3124: IF l_debug_on THEN
3125: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3126: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3127: END IF;
3128: --
3129: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

3122: -- Debug Statements
3123: --
3124: IF l_debug_on THEN
3125: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3126: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3127: END IF;
3128: --
3129: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3130: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 3548: WHEN FND_API.G_EXC_ERROR THEN

3544: --
3545: --}
3546: EXCEPTION
3547: --{
3548: WHEN FND_API.G_EXC_ERROR THEN
3549: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3550: --
3551: -- Debug Statements
3552: --

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

3550: --
3551: -- Debug Statements
3552: --
3553: IF l_debug_on THEN
3554: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3555: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3556: END IF;
3557: --
3558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3551: -- Debug Statements
3552: --
3553: IF l_debug_on THEN
3554: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3555: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3556: END IF;
3557: --
3558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3559: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 3558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3554: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3555: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3556: END IF;
3557: --
3558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3559: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3560: --
3561: -- Debug Statements
3562: --

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

3560: --
3561: -- Debug Statements
3562: --
3563: IF l_debug_on THEN
3564: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3565: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3566: END IF;
3567: --
3568: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

3561: -- Debug Statements
3562: --
3563: IF l_debug_on THEN
3564: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3565: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3566: END IF;
3567: --
3568: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3569: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 3810: WHEN FND_API.G_EXC_ERROR THEN

3806: --
3807: --}
3808: EXCEPTION
3809: --{
3810: WHEN FND_API.G_EXC_ERROR THEN
3811: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3812: --
3813: -- Debug Statements
3814: --

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

3812: --
3813: -- Debug Statements
3814: --
3815: IF l_debug_on THEN
3816: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3817: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3818: END IF;
3819: --
3820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3813: -- Debug Statements
3814: --
3815: IF l_debug_on THEN
3816: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3817: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3818: END IF;
3819: --
3820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3821: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 3820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3816: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3817: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3818: END IF;
3819: --
3820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3821: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3822: --
3823: -- Debug Statements
3824: --

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

3822: --
3823: -- Debug Statements
3824: --
3825: IF l_debug_on THEN
3826: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3827: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3828: END IF;
3829: --
3830: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

3823: -- Debug Statements
3824: --
3825: IF l_debug_on THEN
3826: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3827: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3828: END IF;
3829: --
3830: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3831: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 4054: WHEN FND_API.G_EXC_ERROR THEN

4050: --
4051: --}
4052: EXCEPTION
4053: --{
4054: WHEN FND_API.G_EXC_ERROR THEN
4055: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4056: --
4057: -- Debug Statements
4058: --

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

4056: --
4057: -- Debug Statements
4058: --
4059: IF l_debug_on THEN
4060: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4061: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4062: END IF;
4063: --
4064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

4057: -- Debug Statements
4058: --
4059: IF l_debug_on THEN
4060: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4061: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4062: END IF;
4063: --
4064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4065: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 4064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4060: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4061: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4062: END IF;
4063: --
4064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4065: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4066: --
4067: -- Debug Statements
4068: --

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

4066: --
4067: -- Debug Statements
4068: --
4069: IF l_debug_on THEN
4070: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4071: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4072: END IF;
4073: --
4074: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

4067: -- Debug Statements
4068: --
4069: IF l_debug_on THEN
4070: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4071: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4072: END IF;
4073: --
4074: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4075: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 4326: RAISE FND_API.G_EXC_ERROR;

4322: THEN
4323: FND_MESSAGE.SET_NAME('WSH','WSH_IB_PO_WDD_LINK_ERROR');
4324: FND_MESSAGE.SET_TOKEN('KEY',l_key);
4325: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4326: RAISE FND_API.G_EXC_ERROR;
4327: --Should we raise some error insteaD?
4328: -- This may fail parent txn.....check again
4329: END IF;
4330: --

Line 4760: RAISE FND_API.G_EXC_ERROR;

4756: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
4757: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
4758: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4759: --
4760: RAISE FND_API.G_EXC_ERROR;
4761: --}
4762: END IF;
4763: --
4764: --

Line 4952: RAISE FND_API.G_EXC_ERROR;

4948: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
4949: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
4950: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4951: --
4952: RAISE FND_API.G_EXC_ERROR;
4953: --}
4954: END IF;
4955: --}
4956: ELSE

Line 4960: RAISE FND_API.G_EXC_ERROR;

4956: ELSE
4957: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_NO_MATCH_ERROR');
4958: FND_MESSAGE.SET_TOKEN('KEY',l_key);
4959: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4960: RAISE FND_API.G_EXC_ERROR;
4961: END IF;
4962: --}
4963: END IF;
4964: --

Line 5043: WHEN FND_API.G_EXC_ERROR THEN

5039: EXCEPTION
5040: --{
5041: --WHEN e_notMatched THEN
5042: --RAISE e_notMatched;
5043: WHEN FND_API.G_EXC_ERROR THEN
5044: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5045: --
5046: -- Debug Statements
5047: --

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

5045: --
5046: -- Debug Statements
5047: --
5048: IF l_debug_on THEN
5049: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5050: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5051: END IF;
5052: --
5053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

5046: -- Debug Statements
5047: --
5048: IF l_debug_on THEN
5049: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5050: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5051: END IF;
5052: --
5053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5054: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 5053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5049: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5050: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5051: END IF;
5052: --
5053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5054: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5055: --
5056: -- Debug Statements
5057: --

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

5055: --
5056: -- Debug Statements
5057: --
5058: IF l_debug_on THEN
5059: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5060: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
5061: END IF;
5062: --
5063: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

5056: -- Debug Statements
5057: --
5058: IF l_debug_on THEN
5059: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5060: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
5061: END IF;
5062: --
5063: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
5064: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 5403: RAISE FND_API.G_EXC_ERROR;

5399: --
5400: --
5401: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
5402: THEN
5403: RAISE FND_API.G_EXC_ERROR;
5404: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
5405: THEN
5406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5407: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

Line 5406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5402: THEN
5403: RAISE FND_API.G_EXC_ERROR;
5404: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
5405: THEN
5406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5407: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
5408: THEN
5409: l_deliveryRecString := NULL;
5410: END IF;

Line 5442: RAISE FND_API.G_EXC_ERROR;

5438: --{
5439: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_NOT_EXIST');
5440: FND_MESSAGE.SET_TOKEN('DELIVERY_ID',l_deliveryId);
5441: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
5442: RAISE FND_API.G_EXC_ERROR;
5443: --}
5444: END IF;
5445: --
5446: --

Line 5697: WHEN FND_API.G_EXC_ERROR THEN

5693: END IF;
5694: --
5695: RAISE e_notMatched;
5696: --}
5697: WHEN FND_API.G_EXC_ERROR THEN
5698: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5699: --
5700: -- Debug Statements
5701: --

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

5699: --
5700: -- Debug Statements
5701: --
5702: IF l_debug_on THEN
5703: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5704: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5705: END IF;
5706: --
5707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

5700: -- Debug Statements
5701: --
5702: IF l_debug_on THEN
5703: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5704: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5705: END IF;
5706: --
5707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5708: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 5707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5703: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5704: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5705: END IF;
5706: --
5707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5708: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5709: --
5710: -- Debug Statements
5711: --

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

5709: --
5710: -- Debug Statements
5711: --
5712: IF l_debug_on THEN
5713: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5714: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
5715: END IF;
5716: --
5717: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

5710: -- Debug Statements
5711: --
5712: IF l_debug_on THEN
5713: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5714: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
5715: END IF;
5716: --
5717: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
5718: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 6295: RAISE FND_API.G_EXC_ERROR;

6291: IF l_trx_wsh_location_id IS NULL
6292: THEN
6293: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_WSH_LOC');
6294: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
6295: RAISE FND_API.G_EXC_ERROR;
6296: END IF;
6297: END IF;
6298: -- } IB-Phase-2
6299: --

Line 6675: RAISE FND_API.G_EXC_ERROR;

6671: THEN
6672: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_HDR_UPD_ERROR');
6673: FND_MESSAGE.SET_TOKEN('SHIPMENT_HEADER_ID',l_RCVShipmentHeaderId);
6674: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
6675: RAISE FND_API.G_EXC_ERROR;
6676: END IF;
6677: --
6678: --
6679: IF l_parentTransactionMatched

Line 6832: RAISE FND_API.G_EXC_ERROR;

6828: --{
6829: FND_MESSAGE.SET_NAME('WSH','WSH_IB_RSL_NOT_FOUND');
6830: FND_MESSAGE.SET_TOKEN('RCV_SHIPMENT_LINE_ID',p_line_rec.shipment_line_id(l_index));
6831: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
6832: RAISE FND_API.G_EXC_ERROR;
6833: --}
6834: END IF;
6835: --
6836: --

Line 6981: RAISE FND_API.G_EXC_ERROR;

6977: END IF;
6978: --
6979: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
6980: THEN
6981: RAISE FND_API.G_EXC_ERROR;
6982: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
6983: THEN
6984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6985: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

Line 6984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6980: THEN
6981: RAISE FND_API.G_EXC_ERROR;
6982: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
6983: THEN
6984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6985: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
6986: THEN
6987: --{
6988: -- Since key is not already processed in the current call(execution),

Line 7444: RAISE FND_API.G_EXC_ERROR;

7440: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
7441: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
7442: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
7443: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
7444: RAISE FND_API.G_EXC_ERROR;
7445: --}
7446: END IF;
7447: --
7448: /*

Line 7637: RAISE FND_API.G_EXC_ERROR;

7633: --
7634: --
7635: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
7636: THEN
7637: RAISE FND_API.G_EXC_ERROR;
7638: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
7639: THEN
7640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7641: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

Line 7640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7636: THEN
7637: RAISE FND_API.G_EXC_ERROR;
7638: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
7639: THEN
7640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7641: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
7642: THEN
7643: l_shipFromLocationIdLineCount := 1;
7644: ELSE

Line 8901: RAISE FND_API.G_EXC_ERROR;

8897: THEN
8898: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_UPDATE_ERROR');
8899: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',l_headerTransactionId);
8900: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
8901: RAISE FND_API.G_EXC_ERROR;
8902: END IF;
8903: --
8904: --
8905: IF l_transactionType = WSH_INBOUND_TXN_HISTORY_PKG.C_RECEIPT

Line 8929: RAISE FND_API.G_EXC_ERROR;

8925: THEN
8926: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_UPDATE_ERROR');
8927: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',l_parentTxnHistoryRec.transaction_id);
8928: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
8929: RAISE FND_API.G_EXC_ERROR;
8930: END IF;
8931: --}
8932: END IF;
8933: --

Line 8985: WHEN FND_API.G_EXC_ERROR

8981: */
8982: --}
8983: EXCEPTION
8984: --{
8985: WHEN FND_API.G_EXC_ERROR
8986: OR FND_API.G_EXC_UNEXPECTED_ERROR
8987: OR e_NotMatched
8988: THEN
8989: --{

Line 8986: OR FND_API.G_EXC_UNEXPECTED_ERROR

8982: --}
8983: EXCEPTION
8984: --{
8985: WHEN FND_API.G_EXC_ERROR
8986: OR FND_API.G_EXC_UNEXPECTED_ERROR
8987: OR e_NotMatched
8988: THEN
8989: --{
8990: IF l_MatchedTxnHistory_recTbl.shipment_header_id.COUNT > 0

Line 9132: WHEN FND_API.G_EXC_ERROR THEN

9128: WSH_DEBUG_SV.logmsg(l_module_name,'E_NOTMATCHED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9129: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_NOTMATCHED');
9130: END IF;
9131: --
9132: WHEN FND_API.G_EXC_ERROR THEN
9133: ROLLBACK TO matchTransaction_sp;
9134: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9135: --
9136: -- Debug Statements

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

9135: --
9136: -- Debug Statements
9137: --
9138: IF l_debug_on THEN
9139: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9140: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9141: END IF;
9142: --
9143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

9136: -- Debug Statements
9137: --
9138: IF l_debug_on THEN
9139: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9140: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9141: END IF;
9142: --
9143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9144: ROLLBACK TO matchTransaction_sp;

Line 9143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9139: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9140: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9141: END IF;
9142: --
9143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9144: ROLLBACK TO matchTransaction_sp;
9145: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
9146: --
9147: -- Debug Statements

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

9146: --
9147: -- Debug Statements
9148: --
9149: IF l_debug_on THEN
9150: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9151: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9152: END IF;
9153: --
9154: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

9147: -- Debug Statements
9148: --
9149: IF l_debug_on THEN
9150: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9151: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9152: END IF;
9153: --
9154: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9155: --ROLLBACK TO matchTransaction_sp;

Line 9247: p_init_msg_list => FND_API.G_FALSE ,

9243: --
9244: WSH_IB_UI_RECON_GRP.get_shipment_lines
9245: (
9246: p_api_version_number => 1.0 ,
9247: p_init_msg_list => FND_API.G_FALSE ,
9248: p_commit => FND_API.G_FALSE ,
9249: p_shipment_header_id => p_shipmentHeaderId ,
9250: p_transaction_type => p_transactionType ,
9251: p_view_only_flag => 'Y' ,

Line 9248: p_commit => FND_API.G_FALSE ,

9244: WSH_IB_UI_RECON_GRP.get_shipment_lines
9245: (
9246: p_api_version_number => 1.0 ,
9247: p_init_msg_list => FND_API.G_FALSE ,
9248: p_commit => FND_API.G_FALSE ,
9249: p_shipment_header_id => p_shipmentHeaderId ,
9250: p_transaction_type => p_transactionType ,
9251: p_view_only_flag => 'Y' ,
9252: x_shpmt_lines_out_rec => l_shpmt_lines_out_rec ,

Line 9490: RAISE FND_API.G_EXC_ERROR;

9486: THEN
9487: IF l_debug_on THEN
9488: WSH_DEBUG_SV.logmsg(l_module_name,'Entry not found in l_rslId_cache');
9489: END IF;
9490: RAISE FND_API.G_EXC_ERROR;
9491: END IF;
9492: --
9493: --
9494: IF l_debug_on THEN

Line 9575: WHEN FND_API.G_EXC_ERROR THEN

9571: END IF;
9572: --}
9573: EXCEPTION
9574: --{
9575: WHEN FND_API.G_EXC_ERROR THEN
9576: --ROLLBACK TO matchTransaction_sp;
9577: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9578: --
9579: -- Debug Statements

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

9578: --
9579: -- Debug Statements
9580: --
9581: IF l_debug_on THEN
9582: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9583: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9584: END IF;
9585: --
9586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

9579: -- Debug Statements
9580: --
9581: IF l_debug_on THEN
9582: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9583: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9584: END IF;
9585: --
9586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9587: --ROLLBACK TO matchTransaction_sp;

Line 9586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9582: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9583: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9584: END IF;
9585: --
9586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9587: --ROLLBACK TO matchTransaction_sp;
9588: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
9589: --
9590: -- Debug Statements

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

9589: --
9590: -- Debug Statements
9591: --
9592: IF l_debug_on THEN
9593: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9594: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9595: END IF;
9596: --
9597: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

9590: -- Debug Statements
9591: --
9592: IF l_debug_on THEN
9593: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9594: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9595: END IF;
9596: --
9597: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9598: --ROLLBACK TO matchTransaction_sp;

Line 10018: RAISE FND_API.G_EXC_ERROR;

10014: THEN
10015: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_UPDATE_ERROR');
10016: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',l_txnHistoryRec.transaction_id);
10017: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
10018: RAISE FND_API.G_EXC_ERROR;
10019: END IF;
10020: --}
10021: END IF;
10022: --}

Line 10141: WHEN FND_API.G_EXC_ERROR THEN

10137: END IF;
10138: --}
10139: EXCEPTION
10140: --{
10141: WHEN FND_API.G_EXC_ERROR THEN
10142: --ROLLBACK TO matchTransaction_sp;
10143: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10144: --
10145: -- Debug Statements

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

10144: --
10145: -- Debug Statements
10146: --
10147: IF l_debug_on THEN
10148: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10149: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10150: END IF;
10151: --
10152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

10145: -- Debug Statements
10146: --
10147: IF l_debug_on THEN
10148: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10149: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10150: END IF;
10151: --
10152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10153: --ROLLBACK TO matchTransaction_sp;

Line 10152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

10148: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10149: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10150: END IF;
10151: --
10152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10153: --ROLLBACK TO matchTransaction_sp;
10154: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10155: --
10156: -- Debug Statements

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

10155: --
10156: -- Debug Statements
10157: --
10158: IF l_debug_on THEN
10159: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10160: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10161: END IF;
10162: --
10163: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

10156: -- Debug Statements
10157: --
10158: IF l_debug_on THEN
10159: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10160: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10161: END IF;
10162: --
10163: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10164: --ROLLBACK TO matchTransaction_sp;