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_INBOUND_TXN_HISTORY_PKG dependencies on FND_API

Line 84: RAISE FND_API.G_EXC_ERROR;

80: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
81: FND_MESSAGE.SET_TOKEN('FIELD_NAME',l_param_name);
82: x_return_status := wsh_util_core.g_ret_sts_error;
83: wsh_util_core.add_message(x_return_status,l_module_name);
84: RAISE FND_API.G_EXC_ERROR;
85: END IF;
86: --
87: --
88: l_index := x_inboundTxnHistory_recTbl.transaction_type.NEXT(l_index);

Line 159: RAISE FND_API.G_EXC_ERROR;

155: END IF;
156: --
157: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_BULK_INSERT_ERROR');
158: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
159: RAISE FND_API.G_EXC_ERROR;
160: --}
161: END IF;
162: --}
163: --

Line 172: WHEN FND_API.G_EXC_ERROR THEN

168: END IF;
169: --
170: EXCEPTION
171: --{
172: WHEN FND_API.G_EXC_ERROR THEN
173: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
174: --
175: -- Debug Statements
176: --

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

174: --
175: -- Debug Statements
176: --
177: IF l_debug_on THEN
178: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
179: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
180: END IF;
181: --
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

175: -- Debug Statements
176: --
177: IF l_debug_on THEN
178: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
179: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
180: END IF;
181: --
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
183: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

178: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
179: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
180: END IF;
181: --
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
183: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
184: --
185: -- Debug Statements
186: --

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

184: --
185: -- Debug Statements
186: --
187: IF l_debug_on THEN
188: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
189: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
190: END IF;
191: --
192: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

185: -- Debug Statements
186: --
187: IF l_debug_on THEN
188: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
189: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
190: END IF;
191: --
192: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
193: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 300: WHEN FND_API.G_EXC_ERROR THEN

296: --
297: --}
298: EXCEPTION
299: --{
300: WHEN FND_API.G_EXC_ERROR THEN
301: ROLLBACK;
302: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
303: --
304: -- Debug Statements

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

303: --
304: -- Debug Statements
305: --
306: IF l_debug_on THEN
307: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
308: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
309: END IF;
310: --
311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

304: -- Debug Statements
305: --
306: IF l_debug_on THEN
307: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
308: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
309: END IF;
310: --
311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
312: ROLLBACK;

Line 311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

307: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
308: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
309: END IF;
310: --
311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
312: ROLLBACK;
313: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
314: --
315: -- Debug Statements

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

314: --
315: -- Debug Statements
316: --
317: IF l_debug_on THEN
318: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
320: END IF;
321: --
322: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

315: -- Debug Statements
316: --
317: IF l_debug_on THEN
318: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
320: END IF;
321: --
322: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
323: COMMIT;

Line 434: RAISE FND_API.G_EXC_ERROR;

430: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
431: FND_MESSAGE.SET_TOKEN('FIELD_NAME',l_param_name);
432: x_return_status := wsh_util_core.g_ret_sts_error;
433: wsh_util_core.add_message(x_return_status,l_module_name);
434: RAISE FND_API.G_EXC_ERROR;
435: END IF;
436:
437: --select wsh_inbound_txn_history_s.nextval into l_txn_id from dual;
438: --l_txn_id := wsh_inbound_txn_history_s.nextval;

Line 500: WHEN FND_API.G_EXC_ERROR THEN

496: END IF;
497: --
498: EXCEPTION
499: --{
500: WHEN FND_API.G_EXC_ERROR THEN
501: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
502: --
503: -- Debug Statements
504: --

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

502: --
503: -- Debug Statements
504: --
505: IF l_debug_on THEN
506: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
507: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
508: END IF;
509: --
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

503: -- Debug Statements
504: --
505: IF l_debug_on THEN
506: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
507: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
508: END IF;
509: --
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

506: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
507: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
508: END IF;
509: --
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
512: --
513: -- Debug Statements
514: --

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

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

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

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

Line 628: WHEN FND_API.G_EXC_ERROR THEN

624: --
625: --}
626: EXCEPTION
627: --{
628: WHEN FND_API.G_EXC_ERROR THEN
629: ROLLBACK;
630: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
631: --
632: -- Debug Statements

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

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

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

632: -- Debug Statements
633: --
634: IF l_debug_on THEN
635: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
636: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
637: END IF;
638: --
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK;

Line 639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

635: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
636: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
637: END IF;
638: --
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK;
641: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
642: --
643: -- Debug Statements

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

642: --
643: -- Debug Statements
644: --
645: IF l_debug_on THEN
646: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
648: END IF;
649: --
650: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

643: -- Debug Statements
644: --
645: IF l_debug_on THEN
646: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
648: END IF;
649: --
650: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
651: COMMIT;

Line 723: FND_API.G_MISS_CHAR,NULL,

719: update wsh_inbound_txn_history
720: set RECEIPT_NUMBER = DECODE
721: (
722: p_txn_history_rec.RECEIPT_NUMBER,
723: FND_API.G_MISS_CHAR,NULL,
724: NULL,RECEIPT_NUMBER,
725: p_txn_history_rec.RECEIPT_NUMBER),
726: REVISION_NUMBER = DECODE
727: (

Line 729: FND_API.G_MISS_CHAR,NULL,

725: p_txn_history_rec.RECEIPT_NUMBER),
726: REVISION_NUMBER = DECODE
727: (
728: p_txn_history_rec.REVISION_NUMBER,
729: FND_API.G_MISS_CHAR,NULL,
730: NULL,REVISION_NUMBER,
731: p_txn_history_rec.REVISION_NUMBER),
732: SHIPMENT_NUMBER = DECODE
733: (

Line 735: FND_API.G_MISS_CHAR,NULL,

731: p_txn_history_rec.REVISION_NUMBER),
732: SHIPMENT_NUMBER = DECODE
733: (
734: p_txn_history_rec.SHIPMENT_NUMBER,
735: FND_API.G_MISS_CHAR,NULL,
736: NULL,SHIPMENT_NUMBER,
737: p_txn_history_rec.SHIPMENT_NUMBER),
738: TRANSACTION_TYPE = DECODE
739: (

Line 741: FND_API.G_MISS_CHAR,NULL,

737: p_txn_history_rec.SHIPMENT_NUMBER),
738: TRANSACTION_TYPE = DECODE
739: (
740: p_txn_history_rec.TRANSACTION_TYPE,
741: FND_API.G_MISS_CHAR,NULL,
742: NULL,TRANSACTION_TYPE,
743: p_txn_history_rec.TRANSACTION_TYPE),
744: SHIPMENT_HEADER_ID = DECODE
745: (

Line 747: FND_API.G_MISS_NUM,NULL,

743: p_txn_history_rec.TRANSACTION_TYPE),
744: SHIPMENT_HEADER_ID = DECODE
745: (
746: p_txn_history_rec.SHIPMENT_HEADER_ID,
747: FND_API.G_MISS_NUM,NULL,
748: NULL,SHIPMENT_HEADER_ID,
749: p_txn_history_rec.SHIPMENT_HEADER_ID),
750: PARENT_SHIPMENT_HEADER_ID = DECODE
751: (

Line 753: FND_API.G_MISS_NUM,NULL,

749: p_txn_history_rec.SHIPMENT_HEADER_ID),
750: PARENT_SHIPMENT_HEADER_ID = DECODE
751: (
752: p_txn_history_rec.PARENT_SHIPMENT_HEADER_ID,
753: FND_API.G_MISS_NUM,NULL,
754: NULL,PARENT_SHIPMENT_HEADER_ID,
755: p_txn_history_rec.PARENT_SHIPMENT_HEADER_ID),
756: ORGANIZATION_ID = DECODE
757: (

Line 759: FND_API.G_MISS_NUM,NULL,

755: p_txn_history_rec.PARENT_SHIPMENT_HEADER_ID),
756: ORGANIZATION_ID = DECODE
757: (
758: p_txn_history_rec.ORGANIZATION_ID,
759: FND_API.G_MISS_NUM,NULL,
760: NULL,ORGANIZATION_ID,
761: p_txn_history_rec.ORGANIZATION_ID),
762: SUPPLIER_ID = DECODE
763: (

Line 765: FND_API.G_MISS_NUM,NULL,

761: p_txn_history_rec.ORGANIZATION_ID),
762: SUPPLIER_ID = DECODE
763: (
764: p_txn_history_rec.SUPPLIER_ID,
765: FND_API.G_MISS_NUM,NULL,
766: NULL,SUPPLIER_ID,
767: p_txn_history_rec.SUPPLIER_ID),
768: SHIPPED_DATE = DECODE
769: (

Line 771: FND_API.G_MISS_DATE,NULL,

767: p_txn_history_rec.SUPPLIER_ID),
768: SHIPPED_DATE = DECODE
769: (
770: p_txn_history_rec.SHIPPED_DATE,
771: FND_API.G_MISS_DATE,NULL,
772: NULL,SHIPPED_DATE,
773: p_txn_history_rec.SHIPPED_DATE),
774: RECEIPT_DATE = DECODE
775: (

Line 777: FND_API.G_MISS_DATE,NULL,

773: p_txn_history_rec.SHIPPED_DATE),
774: RECEIPT_DATE = DECODE
775: (
776: p_txn_history_rec.RECEIPT_DATE,
777: FND_API.G_MISS_DATE,NULL,
778: NULL,RECEIPT_DATE,
779: p_txn_history_rec.RECEIPT_DATE),
780: STATUS = DECODE
781: (

Line 783: FND_API.G_MISS_CHAR,NULL,

779: p_txn_history_rec.RECEIPT_DATE),
780: STATUS = DECODE
781: (
782: p_txn_history_rec.STATUS,
783: FND_API.G_MISS_CHAR,NULL,
784: NULL,STATUS,
785: p_txn_history_rec.STATUS),
786: MAX_RCV_TRANSACTION_ID = DECODE
787: (

Line 789: FND_API.G_MISS_NUM,NULL,

785: p_txn_history_rec.STATUS),
786: MAX_RCV_TRANSACTION_ID = DECODE
787: (
788: p_txn_history_rec.MAX_RCV_TRANSACTION_ID,
789: FND_API.G_MISS_NUM,NULL,
790: NULL,MAX_RCV_TRANSACTION_ID,
791: p_txn_history_rec.MAX_RCV_TRANSACTION_ID),
792: CARRIER_ID = DECODE
793: (

Line 795: FND_API.G_MISS_NUM,NULL,

791: p_txn_history_rec.MAX_RCV_TRANSACTION_ID),
792: CARRIER_ID = DECODE
793: (
794: p_txn_history_rec.CARRIER_ID,
795: FND_API.G_MISS_NUM,NULL,
796: NULL,CARRIER_ID,
797: p_txn_history_rec.CARRIER_ID),
798: MATCH_REVERTED_BY = DECODE
799: (

Line 801: FND_API.G_MISS_NUM,NULL,

797: p_txn_history_rec.CARRIER_ID),
798: MATCH_REVERTED_BY = DECODE
799: (
800: p_txn_history_rec.MATCH_REVERTED_BY,
801: FND_API.G_MISS_NUM,NULL,
802: NULL,MATCH_REVERTED_BY,
803: p_txn_history_rec.MATCH_REVERTED_BY),
804: MATCHED_BY = DECODE
805: (

Line 807: FND_API.G_MISS_NUM,NULL,

803: p_txn_history_rec.MATCH_REVERTED_BY),
804: MATCHED_BY = DECODE
805: (
806: p_txn_history_rec.MATCHED_BY,
807: FND_API.G_MISS_NUM,NULL,
808: NULL,MATCHED_BY,
809: p_txn_history_rec.MATCHED_BY),
810: SHIPMENT_LINE_ID = DECODE
811: (

Line 813: FND_API.G_MISS_NUM,NULL,

809: p_txn_history_rec.MATCHED_BY),
810: SHIPMENT_LINE_ID = DECODE
811: (
812: p_txn_history_rec.SHIPMENT_LINE_ID,
813: FND_API.G_MISS_NUM,NULL,
814: NULL,SHIPMENT_LINE_ID,
815: p_txn_history_rec.SHIPMENT_LINE_ID),
816: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
817: -- { IB-Phase-2

Line 821: FND_API.G_MISS_NUM,NULL,

817: -- { IB-Phase-2
818: SHIP_FROM_LOCATION_ID = DECODE
819: (
820: p_txn_history_rec.SHIP_FROM_LOCATION_ID,
821: FND_API.G_MISS_NUM,NULL,
822: NULL,SHIP_FROM_LOCATION_ID,
823: p_txn_history_rec.SHIP_FROM_LOCATION_ID),
824: -- } IB-Phase-2
825: LAST_UPDATE_DATE = SYSDATE,

Line 839: WHEN FND_API.G_EXC_ERROR THEN

835: END IF;
836: --
837: EXCEPTION
838: --{
839: WHEN FND_API.G_EXC_ERROR THEN
840: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
841: --
842: -- Debug Statements
843: --

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

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

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

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

Line 849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

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

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

Line 941: WHEN FND_API.G_EXC_ERROR THEN

937: END IF;
938: --
939: EXCEPTION
940: --{
941: WHEN FND_API.G_EXC_ERROR THEN
942: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
943: --
944: -- Debug Statements
945: --

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

943: --
944: -- Debug Statements
945: --
946: IF l_debug_on THEN
947: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
948: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
949: END IF;
950: --
951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

944: -- Debug Statements
945: --
946: IF l_debug_on THEN
947: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
948: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
949: END IF;
950: --
951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
952: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

947: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
948: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
949: END IF;
950: --
951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
952: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
953: --
954: -- Debug Statements
955: --

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

953: --
954: -- Debug Statements
955: --
956: IF l_debug_on THEN
957: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
958: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
959: END IF;
960: --
961: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

954: -- Debug Statements
955: --
956: IF l_debug_on THEN
957: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
958: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
959: END IF;
960: --
961: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
962: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1070: RAISE FND_API.G_EXC_ERROR;

1066: --
1067: x_return_status := wsh_util_core.g_ret_sts_success;
1068: IF (p_transaction_id IS NULL AND (p_shipment_header_id IS NULL or p_transaction_type is NULL) ) THEN
1069: --{
1070: RAISE FND_API.G_EXC_ERROR;
1071: --}
1072: END IF;
1073: open l_txn_history_csr;
1074: fetch l_txn_history_csr into x_txn_history_rec;

Line 1086: WHEN FND_API.G_EXC_ERROR THEN

1082: END IF;
1083: --
1084: EXCEPTION
1085: --{
1086: WHEN FND_API.G_EXC_ERROR THEN
1087: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1088: --
1089: -- Debug Statements
1090: --

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

1088: --
1089: -- Debug Statements
1090: --
1091: IF l_debug_on THEN
1092: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1093: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1094: END IF;
1095: --
1096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1089: -- Debug Statements
1090: --
1091: IF l_debug_on THEN
1092: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1093: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1094: END IF;
1095: --
1096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1097: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 1096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1092: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1093: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1094: END IF;
1095: --
1096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1097: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1098: --
1099: -- Debug Statements
1100: --

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

1098: --
1099: -- Debug Statements
1100: --
1101: IF l_debug_on THEN
1102: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1103: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1104: END IF;
1105: --
1106: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

1099: -- Debug Statements
1100: --
1101: IF l_debug_on THEN
1102: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1103: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1104: END IF;
1105: --
1106: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1107: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1276: WHEN FND_API.G_EXC_ERROR THEN

1272: END IF;
1273: --
1274: EXCEPTION
1275: --{
1276: WHEN FND_API.G_EXC_ERROR THEN
1277: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1278: --
1279: -- Debug Statements
1280: --

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

1278: --
1279: -- Debug Statements
1280: --
1281: IF l_debug_on THEN
1282: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1283: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1284: END IF;
1285: --
1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1279: -- Debug Statements
1280: --
1281: IF l_debug_on THEN
1282: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1283: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1284: END IF;
1285: --
1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1287: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1282: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1283: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1284: END IF;
1285: --
1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1287: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1288: --
1289: -- Debug Statements
1290: --

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

1288: --
1289: -- Debug Statements
1290: --
1291: IF l_debug_on THEN
1292: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1293: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1294: END IF;
1295: --
1296: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

1289: -- Debug Statements
1290: --
1291: IF l_debug_on THEN
1292: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1293: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1294: END IF;
1295: --
1296: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1297: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1455: RAISE FND_API.G_EXC_ERROR;

1451: --{
1452: FND_MESSAGE.SET_NAME('WSH','WSH_ASN_REVERT_ERROR');
1453: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER',l_txn_history_rec.shipment_number);
1454: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1455: RAISE FND_API.G_EXC_ERROR;
1456: --}
1457: END IF;
1458: --}
1459: END IF;

Line 1468: RAISE FND_API.G_EXC_ERROR;

1464: THEN
1465: --{
1466: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_LOCK_ERROR');
1467: wsh_util_core.add_message(x_return_status,l_module_name);
1468: RAISE FND_API.G_EXC_ERROR;
1469: --}
1470: END IF;
1471: */
1472: --

Line 1479: RAISE FND_API.G_EXC_ERROR;

1475: THEN
1476: --{
1477: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_CHANGE_ERROR');
1478: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1479: RAISE FND_API.G_EXC_ERROR;
1480: --}
1481: END IF;
1482: --
1483: --

Line 1626: WHEN FND_API.G_EXC_ERROR THEN

1622: --
1623: --}
1624: EXCEPTION
1625: --{
1626: WHEN FND_API.G_EXC_ERROR THEN
1627: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1628: --
1629: -- Debug Statements
1630: --

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

1628: --
1629: -- Debug Statements
1630: --
1631: IF l_debug_on THEN
1632: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1633: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1634: END IF;
1635: --
1636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1629: -- Debug Statements
1630: --
1631: IF l_debug_on THEN
1632: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1633: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1634: END IF;
1635: --
1636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1637: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 1636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1632: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1633: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1634: END IF;
1635: --
1636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1637: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1638: --
1639: -- Debug Statements
1640: --

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

1638: --
1639: -- Debug Statements
1640: --
1641: IF l_debug_on THEN
1642: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1643: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1644: END IF;
1645: --
1646: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

1639: -- Debug Statements
1640: --
1641: IF l_debug_on THEN
1642: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1643: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1644: END IF;
1645: --
1646: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1647: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1758: RAISE FND_API.G_EXC_ERROR;

1754: THEN
1755: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
1756: FND_MESSAGE.SET_TOKEN('FIELD_NAME',l_param_name);
1757: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1758: RAISE FND_API.G_EXC_ERROR;
1759: END IF;
1760: --
1761: --
1762: IF p_transaction_type NOT IN ( C_ASN, C_RECEIPT )

Line 1768: RAISE FND_API.G_EXC_ERROR;

1764: --{
1765: FND_MESSAGE.SET_NAME('WSH','WSH_PUB_INVALID_PARAMETER');
1766: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_transaction_type');
1767: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1768: RAISE FND_API.G_EXC_ERROR;
1769: --}
1770: END IF;
1771: --
1772: --

Line 1779: RAISE FND_API.G_EXC_ERROR;

1775: --{
1776: FND_MESSAGE.SET_NAME('WSH','WSH_PUB_INVALID_PARAMETER');
1777: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_on_error');
1778: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1779: RAISE FND_API.G_EXC_ERROR;
1780: --}
1781: END IF;
1782: --
1783: --

Line 1790: RAISE FND_API.G_EXC_ERROR;

1786: --{
1787: FND_MESSAGE.SET_NAME('WSH','WSH_PUB_INVALID_PARAMETER');
1788: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_on_noDataFound');
1789: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1790: RAISE FND_API.G_EXC_ERROR;
1791: --}
1792: END IF;
1793: --
1794: --

Line 1815: RAISE FND_API.G_EXC_ERROR;

1811: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_NOT_FOUND');
1812: FND_MESSAGE.SET_TOKEN('TXN_TYPE',p_transaction_type);
1813: FND_MESSAGE.SET_TOKEN('SHIPMENT_HEADER_ID',p_shipment_header_id);
1814: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1815: RAISE FND_API.G_EXC_ERROR;
1816: END IF;
1817: --
1818: EXIT;
1819: --}

Line 1846: WHEN FND_API.G_EXC_ERROR THEN

1842: --
1843: --}
1844: EXCEPTION
1845: --{
1846: WHEN FND_API.G_EXC_ERROR THEN
1847: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1848: --
1849: -- Debug Statements
1850: --

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

1848: --
1849: -- Debug Statements
1850: --
1851: IF l_debug_on THEN
1852: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1853: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1854: END IF;
1855: --
1856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1849: -- Debug Statements
1850: --
1851: IF l_debug_on THEN
1852: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1853: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1854: END IF;
1855: --
1856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1857: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 1856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1852: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1853: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1854: END IF;
1855: --
1856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1857: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1858: --
1859: -- Debug Statements
1860: --

Line 1862: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_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_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1863: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1864: END IF;
1865: --
1866: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

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

Line 1950: RAISE FND_API.G_EXC_ERROR;

1946: THEN
1947: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
1948: FND_MESSAGE.SET_TOKEN('FIELD_NAME',l_param_name);
1949: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1950: RAISE FND_API.G_EXC_ERROR;
1951: END IF;
1952: --
1953: --
1954: OPEN txn_csr;

Line 1968: RAISE FND_API.G_EXC_ERROR;

1964: ELSE
1965: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_UPDATE_ERROR');
1966: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_transaction_id);
1967: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1968: RAISE FND_API.G_EXC_ERROR;
1969: END IF;
1970: --
1971: -- Debug Statements
1972: --

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

1982: WHEN RECORD_LOCKED THEN
1983: ROLLBACK TO SAVEPOINT lock_n_roll_sp;
1984: IF l_debug_on THEN
1985: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1986: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1987: END IF;
1988: --
1989: WHEN FND_API.G_EXC_ERROR THEN
1990: ROLLBACK TO SAVEPOINT lock_n_roll_sp;

Line 1989: WHEN FND_API.G_EXC_ERROR THEN

1985: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1986: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1987: END IF;
1988: --
1989: WHEN FND_API.G_EXC_ERROR THEN
1990: ROLLBACK TO SAVEPOINT lock_n_roll_sp;
1991: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1992: --
1993: -- Debug Statements

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

1992: --
1993: -- Debug Statements
1994: --
1995: IF l_debug_on THEN
1996: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1997: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1998: END IF;
1999: --
2000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1993: -- Debug Statements
1994: --
1995: IF l_debug_on THEN
1996: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1997: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1998: END IF;
1999: --
2000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2001: ROLLBACK TO SAVEPOINT lock_n_roll_sp;

Line 2000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1996: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1997: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1998: END IF;
1999: --
2000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2001: ROLLBACK TO SAVEPOINT lock_n_roll_sp;
2002: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2003: --
2004: -- Debug Statements

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

2003: --
2004: -- Debug Statements
2005: --
2006: IF l_debug_on THEN
2007: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2008: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2009: END IF;
2010: --
2011: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

2004: -- Debug Statements
2005: --
2006: IF l_debug_on THEN
2007: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2008: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2009: END IF;
2010: --
2011: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2012: ROLLBACK TO SAVEPOINT lock_n_roll_sp;

Line 2093: RAISE FND_API.G_EXC_ERROR;

2089: THEN
2090: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_TXN_TYPE');
2091: FND_MESSAGE.SET_TOKEN('TXN_TYPE',p_transactionType);
2092: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
2093: RAISE FND_API.G_EXC_ERROR;
2094: END IF;
2095: --
2096: --
2097: IF l_debug_on THEN

Line 2104: WHEN FND_API.G_EXC_ERROR THEN

2100: --
2101: --}
2102: EXCEPTION
2103: --{
2104: WHEN FND_API.G_EXC_ERROR THEN
2105: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2106: --
2107: -- Debug Statements
2108: --

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

2106: --
2107: -- Debug Statements
2108: --
2109: IF l_debug_on THEN
2110: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2111: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2112: END IF;
2113: --
2114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2107: -- Debug Statements
2108: --
2109: IF l_debug_on THEN
2110: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2111: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2112: END IF;
2113: --
2114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2115: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 2114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2110: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2111: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2112: END IF;
2113: --
2114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2115: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2116: --
2117: -- Debug Statements
2118: --

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

2116: --
2117: -- Debug Statements
2118: --
2119: IF l_debug_on THEN
2120: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2121: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2122: END IF;
2123: --
2124: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

2117: -- Debug Statements
2118: --
2119: IF l_debug_on THEN
2120: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2121: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2122: END IF;
2123: --
2124: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2125: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;