eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_ASN_RECEIPT_PVT dependencies on FND_API

Line 121: RAISE FND_API.G_EXC_ERROR;

117: --
118: --
119: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
120: THEN
121: RAISE FND_API.G_EXC_ERROR;
122: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
123: THEN
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

Line 124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

120: THEN
121: RAISE FND_API.G_EXC_ERROR;
122: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
123: THEN
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
126: THEN
127: l_value := 0;
128: END IF;

Line 186: WHEN FND_API.G_EXC_ERROR THEN

182: --
183: --}
184: EXCEPTION
185: --{
186: WHEN FND_API.G_EXC_ERROR THEN
187: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
188: --
189: -- Debug Statements
190: --

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

188: --
189: -- Debug Statements
190: --
191: IF l_debug_on THEN
192: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
193: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
194: END IF;
195: --
196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

189: -- Debug Statements
190: --
191: IF l_debug_on THEN
192: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
193: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
194: END IF;
195: --
196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
197: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

192: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
193: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
194: END IF;
195: --
196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
197: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
198: --
199: -- Debug Statements
200: --

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

198: --
199: -- Debug Statements
200: --
201: IF l_debug_on THEN
202: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
203: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
204: END IF;
205: --
206: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

199: -- Debug Statements
200: --
201: IF l_debug_on THEN
202: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
203: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
204: END IF;
205: --
206: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
207: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 458: WHEN FND_API.G_EXC_ERROR THEN

454: --
455: --}
456: EXCEPTION
457: --{
458: WHEN FND_API.G_EXC_ERROR THEN
459: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
460: --
461: -- Debug Statements
462: --

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

460: --
461: -- Debug Statements
462: --
463: IF l_debug_on THEN
464: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
465: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
466: END IF;
467: --
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

Line 468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

464: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
465: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
466: END IF;
467: --
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
469: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
470: --
471: -- Debug Statements
472: --

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

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

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

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

Line 608: RAISE FND_API.G_EXC_ERROR;

604: --
605: --
606: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
607: THEN
608: RAISE FND_API.G_EXC_ERROR;
609: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
610: THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

Line 611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

607: THEN
608: RAISE FND_API.G_EXC_ERROR;
609: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
610: THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
613: THEN
614: x_diff_net_weight := 0;
615: END IF;

Line 641: RAISE FND_API.G_EXC_ERROR;

637: --
638: --
639: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
640: THEN
641: RAISE FND_API.G_EXC_ERROR;
642: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
643: THEN
644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

Line 644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

640: THEN
641: RAISE FND_API.G_EXC_ERROR;
642: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
643: THEN
644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
646: THEN
647: x_diff_volume := 0;
648: END IF;

Line 675: WHEN FND_API.G_EXC_ERROR THEN

671: --
672: --}
673: EXCEPTION
674: --{
675: WHEN FND_API.G_EXC_ERROR THEN
676: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
677: --
678: -- Debug Statements
679: --

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

677: --
678: -- Debug Statements
679: --
680: IF l_debug_on THEN
681: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
682: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
683: END IF;
684: --
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

678: -- Debug Statements
679: --
680: IF l_debug_on THEN
681: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
682: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
683: END IF;
684: --
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
686: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

681: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
682: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
683: END IF;
684: --
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
686: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
687: --
688: -- Debug Statements
689: --

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

687: --
688: -- Debug Statements
689: --
690: IF l_debug_on THEN
691: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
692: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
693: END IF;
694: --
695: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

688: -- Debug Statements
689: --
690: IF l_debug_on THEN
691: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
692: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
693: END IF;
694: --
695: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
696: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 842: WHEN FND_API.G_EXC_ERROR THEN

838: --
839: --}
840: EXCEPTION
841: --{
842: WHEN FND_API.G_EXC_ERROR THEN
843: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
844: --
845: -- Debug Statements
846: --

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

844: --
845: -- Debug Statements
846: --
847: IF l_debug_on THEN
848: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
849: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
850: END IF;
851: --
852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

845: -- Debug Statements
846: --
847: IF l_debug_on THEN
848: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
849: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
850: END IF;
851: --
852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
853: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

848: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
849: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
850: END IF;
851: --
852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
853: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
854: --
855: -- Debug Statements
856: --

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

854: --
855: -- Debug Statements
856: --
857: IF l_debug_on THEN
858: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
859: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
860: END IF;
861: --
862: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

855: -- Debug Statements
856: --
857: IF l_debug_on THEN
858: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
859: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
860: END IF;
861: --
862: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
863: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1009: WHEN FND_API.G_EXC_ERROR THEN

1005: --
1006: --}
1007: EXCEPTION
1008: --{
1009: WHEN FND_API.G_EXC_ERROR THEN
1010: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1011: --
1012: -- Debug Statements
1013: --

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

1011: --
1012: -- Debug Statements
1013: --
1014: IF l_debug_on THEN
1015: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1016: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1017: END IF;
1018: --
1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1012: -- Debug Statements
1013: --
1014: IF l_debug_on THEN
1015: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1016: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1017: END IF;
1018: --
1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1020: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1015: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1016: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1017: END IF;
1018: --
1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1020: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1021: --
1022: -- Debug Statements
1023: --

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

1021: --
1022: -- Debug Statements
1023: --
1024: IF l_debug_on THEN
1025: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1026: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1027: END IF;
1028: --
1029: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

1022: -- Debug Statements
1023: --
1024: IF l_debug_on THEN
1025: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1026: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1027: END IF;
1028: --
1029: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1030: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1384: WHEN FND_API.G_EXC_ERROR THEN

1380: --
1381: --}
1382: EXCEPTION
1383: --{
1384: WHEN FND_API.G_EXC_ERROR THEN
1385: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1386: --
1387: -- Debug Statements
1388: --

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

1386: --
1387: -- Debug Statements
1388: --
1389: IF l_debug_on THEN
1390: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1391: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1392: END IF;
1393: --
1394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1387: -- Debug Statements
1388: --
1389: IF l_debug_on THEN
1390: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1391: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1392: END IF;
1393: --
1394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1395: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 1394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1390: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1391: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1392: END IF;
1393: --
1394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1395: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1396: --
1397: -- Debug Statements
1398: --

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

1396: --
1397: -- Debug Statements
1398: --
1399: IF l_debug_on THEN
1400: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1401: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1402: END IF;
1403: --
1404: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

1397: -- Debug Statements
1398: --
1399: IF l_debug_on THEN
1400: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1401: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1402: END IF;
1403: --
1404: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1405: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1886: raise FND_API.G_EXC_ERROR;

1882: p_key => p_dd_rec.shipment_line_id_tab(i),
1883: p_action => 'PUT',
1884: x_return_status => l_cache_return_status);
1885: IF l_cache_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1886: raise FND_API.G_EXC_ERROR;
1887: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
1888: THEN
1889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1890: END IF;

Line 1889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1885: IF l_cache_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1886: raise FND_API.G_EXC_ERROR;
1887: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
1888: THEN
1889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1890: END IF;
1891: --}
1892: END IF;
1893:

Line 1895: raise FND_API.G_EXC_ERROR;

1891: --}
1892: END IF;
1893:
1894: ElSIF l_cache_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1895: raise FND_API.G_EXC_ERROR;
1896: ELSIF l_cache_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1897: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1898: END IF;
1899:

Line 1897: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1893:
1894: ElSIF l_cache_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1895: raise FND_API.G_EXC_ERROR;
1896: ELSIF l_cache_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1897: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1898: END IF;
1899:
1900: --}
1901:

Line 2275: p_dd_info.picked_quantity :=FND_API.G_MISS_NUM;

2271:
2272: p_dd_info.rcv_shipment_line_id := p_dd_rec.shipment_line_id_tab(p_dd_rec.child_index_tab(k));
2273: --p_dd_info.requested_quantity:= p_dd_rec.shipped_qty_tab(p_dd_rec.child_index_tab(k));
2274: p_dd_info.requested_quantity:= p_dd_rec.requested_qty_tab(p_dd_rec.child_index_tab(k));
2275: p_dd_info.picked_quantity :=FND_API.G_MISS_NUM;
2276: p_dd_info.picked_quantity2 :=FND_API.G_MISS_NUM;
2277: p_dd_info.shipped_quantity:=p_dd_rec.shipped_qty_tab(p_dd_rec.child_index_tab(k));
2278: p_dd_info.returned_quantity:= p_dd_rec.returned_qty_tab(p_dd_rec.child_index_tab(k));
2279: p_dd_info.received_quantity:=p_dd_rec.received_qty_tab(p_dd_rec.child_index_tab(k));

Line 2276: p_dd_info.picked_quantity2 :=FND_API.G_MISS_NUM;

2272: p_dd_info.rcv_shipment_line_id := p_dd_rec.shipment_line_id_tab(p_dd_rec.child_index_tab(k));
2273: --p_dd_info.requested_quantity:= p_dd_rec.shipped_qty_tab(p_dd_rec.child_index_tab(k));
2274: p_dd_info.requested_quantity:= p_dd_rec.requested_qty_tab(p_dd_rec.child_index_tab(k));
2275: p_dd_info.picked_quantity :=FND_API.G_MISS_NUM;
2276: p_dd_info.picked_quantity2 :=FND_API.G_MISS_NUM;
2277: p_dd_info.shipped_quantity:=p_dd_rec.shipped_qty_tab(p_dd_rec.child_index_tab(k));
2278: p_dd_info.returned_quantity:= p_dd_rec.returned_qty_tab(p_dd_rec.child_index_tab(k));
2279: p_dd_info.received_quantity:=p_dd_rec.received_qty_tab(p_dd_rec.child_index_tab(k));
2280: p_dd_info.requested_quantity2:=p_dd_rec.requested_qty2_tab(p_dd_rec.child_index_tab(k));

Line 3119: raise FND_API.G_EXC_ERROR;

3115: p_key => kk,
3116: p_action => 'PUT',
3117: x_return_status => l_return_status);
3118: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3119: raise FND_API.G_EXC_ERROR;
3120: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
3121: THEN
3122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3123: END IF;

Line 3122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3118: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3119: raise FND_API.G_EXC_ERROR;
3120: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
3121: THEN
3122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3123: END IF;
3124:
3125: ELSIF l_local_dd_rec(kk).trip_id IS NULL THEN
3126: --COOLECTING ALL THOSE DELIVERY IDS WHICH HAVE NULL TRIP IDS

Line 3152: raise FND_API.G_EXC_ERROR;

3148: p_key => kk,
3149: p_action => 'PUT',
3150: x_return_status => l_return_status);
3151: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3152: raise FND_API.G_EXC_ERROR;
3153: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
3154: THEN
3155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3156: END IF;

Line 3155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3151: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3152: raise FND_API.G_EXC_ERROR;
3153: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
3154: THEN
3155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3156: END IF;
3157:
3158:
3159:

Line 3175: raise FND_API.G_EXC_ERROR;

3171: p_key => l_local_dd_rec(kk).delivery_id,
3172: p_action => 'PUT',
3173: x_return_status => l_return_status);
3174: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3175: raise FND_API.G_EXC_ERROR;
3176: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
3177: THEN
3178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3179: END IF;

Line 3178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3174: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3175: raise FND_API.G_EXC_ERROR;
3176: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
3177: THEN
3178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3179: END IF;
3180: END IF;
3181:
3182:

Line 3206: raise FND_API.G_EXC_ERROR;

3202: p_key => l_local_dd_rec(kk).delivery_id,
3203: p_action => 'PUT',
3204: x_return_status => l_return_status);
3205: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3206: raise FND_API.G_EXC_ERROR;
3207: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
3208: THEN
3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3210: END IF;

Line 3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3205: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3206: raise FND_API.G_EXC_ERROR;
3207: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
3208: THEN
3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3210: END IF;
3211: END IF;
3212:
3213: --

Line 3325: RAISE FND_API.G_EXC_ERROR;

3321: END IF;
3322:
3323: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');
3324: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3325: RAISE FND_API.G_EXC_ERROR;
3326: END IF;
3327: --
3328: -- DBI Project
3329: -- Update of wsh_delivery_details where requested_quantity/released_status

Line 3428: raise FND_API.G_EXC_ERROR;

3424: p_key => p_line_rec.po_shipment_line_id(l_index),
3425: p_action => 'PUT',
3426: x_return_status => l_return_status );
3427: ElSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3428: raise FND_API.G_EXC_ERROR;
3429: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3430: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3431: END IF;
3432: ElSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

Line 3430: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3426: x_return_status => l_return_status );
3427: ElSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3428: raise FND_API.G_EXC_ERROR;
3429: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3430: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3431: END IF;
3432: ElSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3433: raise FND_API.G_EXC_ERROR;
3434: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

Line 3433: raise FND_API.G_EXC_ERROR;

3429: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3430: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3431: END IF;
3432: ElSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3433: raise FND_API.G_EXC_ERROR;
3434: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3435: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3436: END IF;
3437:

Line 3435: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3431: END IF;
3432: ElSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3433: raise FND_API.G_EXC_ERROR;
3434: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3435: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3436: END IF;
3437:
3438: OPEN c_src_qty2(p_line_rec.line_id(l_index),p_line_rec.po_shipment_line_id(l_index)); --performance
3439: FETCH c_src_qty2

Line 3681: WHEN FND_API.G_EXC_ERROR THEN

3677: END IF;
3678:
3679:
3680: EXCEPTION
3681: WHEN FND_API.G_EXC_ERROR THEN
3682: ROLLBACK TO Process_Matched_Txns_PVT;
3683: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3684: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
3685:

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

3686: --
3687: -- Debug Statements
3688: --
3689: IF l_debug_on THEN
3690: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3691: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3692: END IF;
3693: --
3694: WHEN OTHERS THEN

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

3687: -- Debug Statements
3688: --
3689: IF l_debug_on THEN
3690: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3691: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3692: END IF;
3693: --
3694: WHEN OTHERS THEN
3695: ROLLBACK TO Process_Matched_Txns_PVT;

Line 3696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3692: END IF;
3693: --
3694: WHEN OTHERS THEN
3695: ROLLBACK TO Process_Matched_Txns_PVT;
3696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3697: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_ASN_RECEIPT_PVT.Process_Matched_Txns',l_module_name);
3698:
3699:
3700: --

Line 4199: WHEN FND_API.G_EXC_ERROR THEN

4195: END IF;
4196:
4197:
4198: EXCEPTION
4199: WHEN FND_API.G_EXC_ERROR THEN
4200: ROLLBACK TO Cancel_ASN_PVT;
4201: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4202: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4203:

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

4204: --
4205: -- Debug Statements
4206: --
4207: IF l_debug_on THEN
4208: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4209: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4210: END IF;
4211: --
4212: WHEN OTHERS THEN

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

4205: -- Debug Statements
4206: --
4207: IF l_debug_on THEN
4208: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4209: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4210: END IF;
4211: --
4212: WHEN OTHERS THEN
4213: ROLLBACK TO Cancel_ASN_PVT;

Line 4214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4210: END IF;
4211: --
4212: WHEN OTHERS THEN
4213: ROLLBACK TO Cancel_ASN_PVT;
4214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4215: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_ASN_RECEIPT_PVT.Cancel_ASN');
4216:
4217: --
4218: -- Debug Statements

Line 5071: WHEN FND_API.G_EXC_ERROR THEN

5067: END IF;
5068:
5069:
5070: EXCEPTION
5071: WHEN FND_API.G_EXC_ERROR THEN
5072: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5073: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
5074:
5075: --

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

5075: --
5076: -- Debug Statements
5077: --
5078: IF l_debug_on THEN
5079: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5080: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5081: END IF;
5082: --
5083: WHEN OTHERS THEN

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

5076: -- Debug Statements
5077: --
5078: IF l_debug_on THEN
5079: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5080: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5081: END IF;
5082: --
5083: WHEN OTHERS THEN
5084: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 5905: WHEN FND_API.G_EXC_ERROR THEN

5901: END IF;
5902:
5903:
5904: EXCEPTION
5905: WHEN FND_API.G_EXC_ERROR THEN
5906: ROLLBACK TO RECONFIG_DEL_TRIPS_PVT;
5907: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5908: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
5909:

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

5910: --
5911: -- Debug Statements
5912: --
5913: IF l_debug_on THEN
5914: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5915: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5916: END IF;
5917: --
5918: WHEN OTHERS THEN

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

5911: -- Debug Statements
5912: --
5913: IF l_debug_on THEN
5914: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5915: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5916: END IF;
5917: --
5918: WHEN OTHERS THEN
5919: ROLLBACK TO RECONFIG_DEL_TRIPS_PVT;

Line 6280: WHEN FND_API.G_EXC_ERROR THEN

6276: END IF;
6277:
6278:
6279: EXCEPTION
6280: WHEN FND_API.G_EXC_ERROR THEN
6281: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6282: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
6283:
6284: --

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

6284: --
6285: -- Debug Statements
6286: --
6287: IF l_debug_on THEN
6288: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6289: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6290: END IF;
6291: --
6292: WHEN OTHERS THEN

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

6285: -- Debug Statements
6286: --
6287: IF l_debug_on THEN
6288: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6289: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6290: END IF;
6291: --
6292: WHEN OTHERS THEN
6293: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 6891: raise FND_API.G_EXC_ERROR;

6887: --TO IT..AND ADD THE CONSILADTED QTY BACK TO THE CACHE FOR THIS PO_LINE_LOCATION_ID
6888: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
6889: p_remaining_qty := p_remaining_qty + l_new_qty;
6890: ElSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
6891: raise FND_API.G_EXC_ERROR;
6892: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
6893: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6894: END IF;
6895:

Line 6893: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6889: p_remaining_qty := p_remaining_qty + l_new_qty;
6890: ElSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
6891: raise FND_API.G_EXC_ERROR;
6892: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
6893: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6894: END IF;
6895:
6896: IF l_debug_on THEN
6897: WSH_DEBUG_SV.log(l_module_name,'final-p_remaining_qty',p_remaining_qty);

Line 6916: raise FND_API.G_EXC_ERROR;

6912: p_action => 'PUT',
6913: x_return_status => l_return_status );
6914:
6915: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
6916: raise FND_API.G_EXC_ERROR;
6917: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
6918: THEN
6919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6920: END IF;

Line 6919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6915: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
6916: raise FND_API.G_EXC_ERROR;
6917: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR -- Added by NPARIKH
6918: THEN
6919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6920: END IF;
6921:
6922:
6923:

Line 6937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6933:
6934:
6935: EXCEPTION
6936: WHEN OTHERS THEN
6937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6938: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.CONSOLIDATE_QTY',l_module_name);
6939:
6940: --
6941: -- Debug Statements

Line 7179: RAISE FND_API.G_EXC_ERROR;

7175: --
7176: --
7177: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
7178: THEN
7179: RAISE FND_API.G_EXC_ERROR;
7180: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
7181: THEN
7182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7183: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

Line 7182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7178: THEN
7179: RAISE FND_API.G_EXC_ERROR;
7180: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
7181: THEN
7182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7183: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
7184: THEN
7185: --{
7186: IF l_debug_on THEN

Line 7286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7282:
7283:
7284: EXCEPTION
7285: WHEN OTHERS THEN
7286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7287: WSH_UTIL_CORE.Default_Handler('WSH_ASN_RECEIPT_PVT.POPULATE_UPDATE_DD_REC',l_module_name);
7288:
7289: --
7290: -- Debug Statements

Line 7704: WHEN FND_API.G_EXC_ERROR THEN

7700: END IF;
7701:
7702:
7703: EXCEPTION
7704: WHEN FND_API.G_EXC_ERROR THEN
7705: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7706: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
7707:
7708: --

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

7708: --
7709: -- Debug Statements
7710: --
7711: IF l_debug_on THEN
7712: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7713: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
7714: END IF;
7715: --
7716: WHEN OTHERS THEN

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

7709: -- Debug Statements
7710: --
7711: IF l_debug_on THEN
7712: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7713: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
7714: END IF;
7715: --
7716: WHEN OTHERS THEN
7717: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 7887: raise FND_API.G_EXC_ERROR;

7883: FND_MESSAGE.SET_NAME('WSH','WSH_LEDGER_NOT_FOUND');
7884:
7885:
7886:
7887: raise FND_API.G_EXC_ERROR;
7888: END IF;
7889:
7890: CLOSE get_ledger_id;
7891:

Line 8053: WHEN FND_API.G_EXC_ERROR THEN

8049: END IF;
8050:
8051:
8052: EXCEPTION
8053: WHEN FND_API.G_EXC_ERROR THEN
8054: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8055: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
8056:
8057: --

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

8057: --
8058: -- Debug Statements
8059: --
8060: IF l_debug_on THEN
8061: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
8062: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
8063: END IF;
8064: --
8065: WHEN OTHERS THEN

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

8058: -- Debug Statements
8059: --
8060: IF l_debug_on THEN
8061: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
8062: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
8063: END IF;
8064: --
8065: WHEN OTHERS THEN
8066: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 8226: WHEN FND_API.G_EXC_ERROR THEN

8222: END IF;
8223:
8224:
8225: EXCEPTION
8226: WHEN FND_API.G_EXC_ERROR THEN
8227: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8228: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
8229:
8230: --

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

8230: --
8231: -- Debug Statements
8232: --
8233: IF l_debug_on THEN
8234: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
8235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
8236: END IF;
8237: --
8238: WHEN OTHERS THEN

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

8231: -- Debug Statements
8232: --
8233: IF l_debug_on THEN
8234: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
8235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
8236: END IF;
8237: --
8238: WHEN OTHERS THEN
8239: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;