93: EXCEPTION
94: WHEN FND_API.G_EXC_ERROR THEN
95:
96: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
97: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
98:
99: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
100:
101: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
98:
99: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
100:
101: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
102: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
103:
104: WHEN OTHERS THEN
105:
106: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
103:
104: WHEN OTHERS THEN
105:
106: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
107: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
108: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'PRINT_LABEL');
109: END IF;
110: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
111:
104: WHEN OTHERS THEN
105:
106: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
107: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
108: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'PRINT_LABEL');
109: END IF;
110: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
111:
112: END PRINT_LABEL;
106: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
107: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
108: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'PRINT_LABEL');
109: END IF;
110: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
111:
112: END PRINT_LABEL;
113:
114: PROCEDURE HAS_EXPRESS_PICK_TASKS(
147:
148: WHEN FND_API.G_EXC_ERROR THEN
149:
150: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
151: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
152:
153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
154:
155: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
152:
153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
154:
155: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
156: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
157:
158: WHEN OTHERS THEN
159:
160: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
157:
158: WHEN OTHERS THEN
159:
160: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
161: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
162: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'HAS_EXPRESS_PICK_TASKS');
163: END IF;
164: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
165:
158: WHEN OTHERS THEN
159:
160: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
161: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
162: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'HAS_EXPRESS_PICK_TASKS');
163: END IF;
164: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
165:
166: END HAS_EXPRESS_PICK_TASKS;
160: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
161: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
162: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'HAS_EXPRESS_PICK_TASKS');
163: END IF;
164: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
165:
166: END HAS_EXPRESS_PICK_TASKS;
167:
168: FUNCTION IS_EXPRESS_PICK_TASK(
643:
644: WHEN FND_API.G_EXC_ERROR THEN
645:
646: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
647: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
648:
649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
650:
651: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
648:
649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
650:
651: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
652: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
653:
654: WHEN OTHERS THEN
655:
656: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
653:
654: WHEN OTHERS THEN
655:
656: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
657: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
658: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'LOAD_AND_DROP');
659: END IF;
660: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
661:
654: WHEN OTHERS THEN
655:
656: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
657: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
658: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'LOAD_AND_DROP');
659: END IF;
660: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
661:
662: END LOAD_AND_DROP;
656: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
657: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
658: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'LOAD_AND_DROP');
659: END IF;
660: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
661:
662: END LOAD_AND_DROP;
663:
664: PROCEDURE LOAD_TASK(
714: EXCEPTION
715: WHEN FND_API.G_EXC_ERROR THEN
716:
717: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
718: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
719:
720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
721:
722: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
719:
720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
721:
722: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
723: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
724:
725: WHEN OTHERS THEN
726:
727: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
724:
725: WHEN OTHERS THEN
726:
727: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
728: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
729: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'LOAD_TASK');
730: END IF;
731: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
732:
725: WHEN OTHERS THEN
726:
727: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
728: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
729: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'LOAD_TASK');
730: END IF;
731: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
732:
733: END LOAD_TASK;
727: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
728: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
729: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'LOAD_TASK');
730: END IF;
731: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
732:
733: END LOAD_TASK;
734:
735: PROCEDURE DROP_TASK(
836:
837: WHEN FND_API.G_EXC_ERROR THEN
838:
839: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
840: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
841:
842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
843:
844: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
841:
842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
843:
844: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
845: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
846:
847: WHEN OTHERS THEN
848:
849: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
846:
847: WHEN OTHERS THEN
848:
849: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
850: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
851: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'DROP_TASK');
852: END IF;
853: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
854:
847: WHEN OTHERS THEN
848:
849: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
850: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
851: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'DROP_TASK');
852: END IF;
853: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
854:
855: END DROP_TASK;
849: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
850: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
851: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'DROP_TASK');
852: END IF;
853: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
854:
855: END DROP_TASK;
856:
857: END WMS_EXPRESS_PICK_TASK;