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.WMS_EXPRESS_PICK_TASK dependencies on FND_API

Line 49: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

45: IF (l_debug = 1) THEN
46: MYDEBUG('IN PROCEDURE PRINT_LABEL');
47: END IF;
48:
49: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
50:
51: SELECT TRANSACTION_TYPE_ID,
52: TRANSACTION_SOURCE_TYPE_ID
53: INTO L_TRANSACTION_TYPE_ID,

Line 94: WHEN FND_API.G_EXC_ERROR THEN

90: MYDEBUG('PRINT_LABEL : ' ||X_RETURN_STATUS||' LABEL:'||L_LABEL_STATUS);
91: END IF;
92:
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:

Line 96: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

92:
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:

Line 99: WHEN FND_API.G_EXC_UNEXPECTED_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;
102: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
103:

Line 101: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_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;
102: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
103:
104: WHEN OTHERS THEN
105:

Line 106: 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;
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 );

Line 139: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

135: AND STATUS <= 3
136: AND IS_EXPRESS_PICK_TASK(TASK_ID) = 'S'
137: AND ROWNUM < 2;
138:
139: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
140:
141: EXCEPTION
142: WHEN NO_DATA_FOUND THEN
143: RAISE FND_API.G_EXC_ERROR;

Line 143: RAISE FND_API.G_EXC_ERROR;

139: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
140:
141: EXCEPTION
142: WHEN NO_DATA_FOUND THEN
143: RAISE FND_API.G_EXC_ERROR;
144: END;
145:
146: EXCEPTION
147:

Line 148: WHEN FND_API.G_EXC_ERROR THEN

144: END;
145:
146: EXCEPTION
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:

Line 150: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

146: EXCEPTION
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:

Line 153: WHEN FND_API.G_EXC_UNEXPECTED_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;
156: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
157:

Line 155: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_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;
156: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
157:
158: WHEN OTHERS THEN
159:

Line 160: 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;
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 );

Line 172: X_RETURN_STATUS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

168: FUNCTION IS_EXPRESS_PICK_TASK(
169: P_TASK_ID IN NUMBER
170: ) RETURN VARCHAR2 IS
171:
172: X_RETURN_STATUS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
173:
174: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
175: BEGIN
176:

Line 186: WHEN FND_API.G_EXC_ERROR THEN

182: RETURN X_RETURN_STATUS;
183:
184: EXCEPTION
185:
186: WHEN FND_API.G_EXC_ERROR THEN
187:
188: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
189: RETURN X_RETURN_STATUS;
190:

Line 188: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

184: EXCEPTION
185:
186: WHEN FND_API.G_EXC_ERROR THEN
187:
188: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
189: RETURN X_RETURN_STATUS;
190:
191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
192:

Line 191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

187:
188: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
189: RETURN X_RETURN_STATUS;
190:
191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
192:
193: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
194: RETURN X_RETURN_STATUS;
195:

Line 193: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

189: RETURN X_RETURN_STATUS;
190:
191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
192:
193: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
194: RETURN X_RETURN_STATUS;
195:
196: WHEN OTHERS THEN
197:

Line 198: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

194: RETURN X_RETURN_STATUS;
195:
196: WHEN OTHERS THEN
197:
198: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
199: RETURN X_RETURN_STATUS;
200:
201: END IS_EXPRESS_PICK_TASK;
202:

Line 207: X_RETURN_STATUS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

203: FUNCTION IS_EXPRESS_PICK_TASK_ELIGIBLE(
204: P_TRANSACTION_TEMP_ID IN NUMBER
205: ) RETURN VARCHAR2 IS
206:
207: X_RETURN_STATUS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
208: L_SERIAL_CODE NUMBER := 1;
209: L_LOT_CODE NUMBER := 1;
210: L_DUMMY NUMBER := 1;
211: L_IS_BULK_PICK NUMBER := 0;

Line 216: l_init_msg_lst VARCHAR2(10) := fnd_api.g_false;

212: l_allocated_lpn_id NUMBER;
213:
214: -- Start of Bugfix 2244633
215: l_api_version_number CONSTANT NUMBER := 1.0;
216: l_init_msg_lst VARCHAR2(10) := fnd_api.g_false;
217: l_return_status VARCHAR2(10);
218: l_msg_count NUMBER;
219: l_msg_data VARCHAR2(5000);
220: l_organization_id NUMBER;

Line 290: RAISE fnd_api.g_exc_error;

286: IF (l_debug = 1) THEN
287: MYDEBUG('Pick from an LPN controlled sub. This task cannnot be express picked');
288: END IF;
289:
290: RAISE fnd_api.g_exc_error;
291: END IF;
292:
293: -- bug 2675498
294:

Line 301: RAISE FND_API.G_EXC_ERROR;

297: IF l_allocated_lpn_id IS NOT NULL THEN
298: IF (l_debug = 1) THEN
299: MYDEBUG('LPN Allocation is already done, Cannot Express Pick This Task');
300: END IF;
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;
303:
304: -- End of bugfix 2287341
305:

Line 310: RAISE FND_API.G_EXC_ERROR;

306: IF L_SERIAL_CODE NOT IN ( 1, 6 ) THEN
307: IF (l_debug = 1) THEN
308: MYDEBUG('SERIAL CONTROL CODE: '||TO_CHAR(L_SERIAL_CODE));
309: END IF;
310: RAISE FND_API.G_EXC_ERROR;
311: END IF;
312:
313: EXCEPTION
314: WHEN NO_DATA_FOUND THEN

Line 318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

314: WHEN NO_DATA_FOUND THEN
315: IF (l_debug = 1) THEN
316: MYDEBUG('INVALID MMTT: ');
317: END IF;
318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
319: END;
320:
321: IF L_LOT_CODE <> 1 THEN
322:

Line 335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

331: WHEN NO_DATA_FOUND THEN
332: IF (l_debug = 1) THEN
333: MYDEBUG('INVALID LOT MMTT: ');
334: END IF;
335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
336: WHEN TOO_MANY_ROWS THEN
337: IF (l_debug = 1) THEN
338: MYDEBUG('MULTIPLE LOTS FOR MMTT: ');
339: END IF;

Line 340: RAISE FND_API.G_EXC_ERROR;

336: WHEN TOO_MANY_ROWS THEN
337: IF (l_debug = 1) THEN
338: MYDEBUG('MULTIPLE LOTS FOR MMTT: ');
339: END IF;
340: RAISE FND_API.G_EXC_ERROR;
341: END;
342:
343: END IF;
344:

Line 356: RAISE FND_API.G_EXC_ERROR;

352:
353: IF (l_debug = 1) THEN
354: MYDEBUG('THIS IS A BULK PICK TASK');
355: END IF;
356: RAISE FND_API.G_EXC_ERROR;
357:
358: EXCEPTION
359: WHEN NO_DATA_FOUND THEN
360: IF (l_debug = 1) THEN

Line 429: p_init_msg_lst => fnd_api.g_true,

425: END IF;
426:
427: INV_TXN_VALIDATIONS.CHECK_LOOSE_QUANTITY
428: ( p_api_version_number => l_api_version_number,
429: p_init_msg_lst => fnd_api.g_true,
430: x_return_status => l_return_status,
431: x_msg_count => l_msg_count,
432: x_msg_data => l_msg_data,
433: p_organization_id => l_organization_id,

Line 453: IF l_return_status = fnd_api.g_ret_sts_error THEN

449: IF (l_debug = 1) THEN
450: MYDEBUG(' After Calling Check_Loose_Quantity');
451: END IF;
452:
453: IF l_return_status = fnd_api.g_ret_sts_error THEN
454: IF (l_debug = 1) THEN
455: MYDEBUG('return status = ' || l_return_status);
456: END IF;
457: RAISE fnd_api.g_exc_error;

Line 457: RAISE fnd_api.g_exc_error;

453: IF l_return_status = fnd_api.g_ret_sts_error THEN
454: IF (l_debug = 1) THEN
455: MYDEBUG('return status = ' || l_return_status);
456: END IF;
457: RAISE fnd_api.g_exc_error;
458: END IF ;
459:
460: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
461: IF (l_debug = 1) THEN

Line 460: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

456: END IF;
457: RAISE fnd_api.g_exc_error;
458: END IF ;
459:
460: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
461: IF (l_debug = 1) THEN
462: MYDEBUG('return status = ' || l_return_status);
463: END IF;
464: RAISE fnd_api.g_exc_unexpected_error;

Line 464: RAISE fnd_api.g_exc_unexpected_error;

460: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
461: IF (l_debug = 1) THEN
462: MYDEBUG('return status = ' || l_return_status);
463: END IF;
464: RAISE fnd_api.g_exc_unexpected_error;
465: END IF;
466:
467: IF (l_debug = 1) THEN
468: MYDEBUG('s_ok_to_process = ' || s_ok_to_process);

Line 475: RAISE fnd_api.g_exc_error;

471: IF s_ok_to_process <> 'true' THEN
472: IF (l_debug = 1) THEN
473: MYDEBUG(' Not Enough Loose Quantity. This task cannnot be express picked');
474: END IF;
475: RAISE fnd_api.g_exc_error;
476: END IF;
477:
478: X_RETURN_STATUS := l_return_status;
479:

Line 490: WHEN FND_API.G_EXC_ERROR THEN

486:
487:
488: EXCEPTION
489:
490: WHEN FND_API.G_EXC_ERROR THEN
491:
492: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
493: RETURN X_RETURN_STATUS;
494:

Line 492: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

488: EXCEPTION
489:
490: WHEN FND_API.G_EXC_ERROR THEN
491:
492: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
493: RETURN X_RETURN_STATUS;
494:
495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
496:

Line 495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

491:
492: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
493: RETURN X_RETURN_STATUS;
494:
495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
496:
497: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
498: RETURN X_RETURN_STATUS;
499:

Line 497: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

493: RETURN X_RETURN_STATUS;
494:
495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
496:
497: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
498: RETURN X_RETURN_STATUS;
499:
500: WHEN OTHERS THEN
501:

Line 502: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

498: RETURN X_RETURN_STATUS;
499:
500: WHEN OTHERS THEN
501:
502: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
503: RETURN X_RETURN_STATUS;
504:
505: END IS_EXPRESS_PICK_TASK_ELIGIBLE;
506:

Line 530: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

526:
527: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
528: BEGIN
529:
530: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
531:
532: BEGIN
533:
534: SELECT LPN_ID

Line 549: RAISE FND_API.G_EXC_ERROR;

545: WHEN NO_DATA_FOUND THEN
546: IF (l_debug = 1) THEN
547: MYDEBUG('INVALID LPN'||P_TO_LPN);
548: END IF;
549: RAISE FND_API.G_EXC_ERROR;
550: WHEN OTHERS THEN
551: IF (l_debug = 1) THEN
552: MYDEBUG('UNEXPECTED ERROR IN FETCHING LPN '||SQLERRM);
553: END IF;

Line 554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

550: WHEN OTHERS THEN
551: IF (l_debug = 1) THEN
552: MYDEBUG('UNEXPECTED ERROR IN FETCHING LPN '||SQLERRM);
553: END IF;
554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
555: END;
556:
557: IF (l_debug = 1) THEN
558: mydebug('current action is: ' || p_action);

Line 574: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

570: P_LPN_ID => L_LPN_ID,
571: P_USER_ID => P_USER_ID
572: );
573:
574: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
575: IF (l_debug = 1) THEN
576: MYDEBUG('ERROR IN LOAD_TASK ');
577: END IF;
578: RAISE FND_API.G_EXC_ERROR;

Line 578: RAISE FND_API.G_EXC_ERROR;

574: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
575: IF (l_debug = 1) THEN
576: MYDEBUG('ERROR IN LOAD_TASK ');
577: END IF;
578: RAISE FND_API.G_EXC_ERROR;
579: END IF;
580:
581: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
582: IF (l_debug = 1) THEN

Line 581: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

577: END IF;
578: RAISE FND_API.G_EXC_ERROR;
579: END IF;
580:
581: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
582: IF (l_debug = 1) THEN
583: MYDEBUG('UNEXPECTED ERROR IN LOAD_TASK ');
584: END IF;
585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

581: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
582: IF (l_debug = 1) THEN
583: MYDEBUG('UNEXPECTED ERROR IN LOAD_TASK ');
584: END IF;
585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
586: END IF;
587:
588: ELSIF (p_action = 'LOAD_AND_DROP') THEN
589:

Line 599: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

595: P_LPN_ID => L_LPN_ID,
596: P_USER_ID => P_USER_ID
597: );
598:
599: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
600: IF (l_debug = 1) THEN
601: MYDEBUG('ERROR IN LOAD_TASK ');
602: END IF;
603: RAISE FND_API.G_EXC_ERROR;

Line 603: RAISE FND_API.G_EXC_ERROR;

599: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
600: IF (l_debug = 1) THEN
601: MYDEBUG('ERROR IN LOAD_TASK ');
602: END IF;
603: RAISE FND_API.G_EXC_ERROR;
604: END IF;
605:
606: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
607: IF (l_debug = 1) THEN

Line 606: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

602: END IF;
603: RAISE FND_API.G_EXC_ERROR;
604: END IF;
605:
606: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
607: IF (l_debug = 1) THEN
608: MYDEBUG('UNEXPECTED ERROR IN LOAD_TASK ');
609: END IF;
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

606: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
607: IF (l_debug = 1) THEN
608: MYDEBUG('UNEXPECTED ERROR IN LOAD_TASK ');
609: END IF;
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: END IF;
612:
613: WMS_EXPRESS_PICK_TASK.DROP_TASK(
614: X_RETURN_STATUS => X_RETURN_STATUS,

Line 626: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

622: P_USER_ID => P_USER_ID,
623: P_TASK_TYPE => P_TASK_TYPE
624: );
625:
626: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
627: IF (l_debug = 1) THEN
628: MYDEBUG('ERROR IN DROP_TASK ');
629: END IF;
630: RAISE FND_API.G_EXC_ERROR;

Line 630: RAISE FND_API.G_EXC_ERROR;

626: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
627: IF (l_debug = 1) THEN
628: MYDEBUG('ERROR IN DROP_TASK ');
629: END IF;
630: RAISE FND_API.G_EXC_ERROR;
631: END IF;
632:
633: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
634: IF (l_debug = 1) THEN

Line 633: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

629: END IF;
630: RAISE FND_API.G_EXC_ERROR;
631: END IF;
632:
633: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
634: IF (l_debug = 1) THEN
635: MYDEBUG('UNEXPECTED ERROR IN DROP_TASK ');
636: END IF;
637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

633: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
634: IF (l_debug = 1) THEN
635: MYDEBUG('UNEXPECTED ERROR IN DROP_TASK ');
636: END IF;
637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
638: END IF;
639:
640: END IF;
641:

Line 644: WHEN FND_API.G_EXC_ERROR THEN

640: END IF;
641:
642: EXCEPTION
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:

Line 646: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

642: EXCEPTION
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:

Line 649: WHEN FND_API.G_EXC_UNEXPECTED_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;
652: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
653:

Line 651: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_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;
652: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
653:
654: WHEN OTHERS THEN
655:

Line 656: 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;
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 );

Line 679: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

675: BEGIN
676: IF (l_debug = 1) THEN
677: mydebug('in procedure load_task');
678: END IF;
679: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
680:
681: UPDATE mtl_material_transactions_temp
682: SET transfer_lpn_id = l_lpn_id,
683: last_update_date = SYSDATE,

Line 715: WHEN FND_API.G_EXC_ERROR THEN

711: MYDEBUG('IGNORE RETURN STATUS FOR LABEL PRINTING');
712: END IF;
713:
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:

Line 717: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

713:
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:

Line 720: WHEN FND_API.G_EXC_UNEXPECTED_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;
723: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
724:

Line 722: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_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;
723: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
724:
725: WHEN OTHERS THEN
726:

Line 727: 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;
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 );

Line 758: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

754: IF (l_debug = 1) THEN
755: mydebug('in prod drop_task');
756: END IF;
757:
758: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
759:
760: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
761: INTO L_TXN_HDR_ID
762: FROM DUAL;

Line 788: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

784: IF (l_debug = 1) THEN
785: MYDEBUG('Finished Complete Pick. p_ok_to_process =' || s_ok_to_process);
786: END IF;
787:
788: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
789: IF (l_debug = 1) THEN
790: MYDEBUG('ERROR IN COMPLETE PICK ');
791: END IF;
792: RAISE FND_API.G_EXC_ERROR;

Line 792: RAISE FND_API.G_EXC_ERROR;

788: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
789: IF (l_debug = 1) THEN
790: MYDEBUG('ERROR IN COMPLETE PICK ');
791: END IF;
792: RAISE FND_API.G_EXC_ERROR;
793: END IF;
794:
795: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
796: IF (l_debug = 1) THEN

Line 795: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

791: END IF;
792: RAISE FND_API.G_EXC_ERROR;
793: END IF;
794:
795: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
796: IF (l_debug = 1) THEN
797: MYDEBUG('UNEXPECTED ERROR IN COMPLETE PICK ');
798: END IF;
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

795: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
796: IF (l_debug = 1) THEN
797: MYDEBUG('UNEXPECTED ERROR IN COMPLETE PICK ');
798: END IF;
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: END IF;
801:
802:
803: WMS_TASK_DISPATCH_GEN.PICK_DROP(

Line 821: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

817: P_USER_ID => P_USER_ID,
818: P_TASK_TYPE => P_TASK_TYPE
819: );
820:
821: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
822: IF (l_debug = 1) THEN
823: MYDEBUG('ERROR IN PICK DROP ');
824: END IF;
825: RAISE FND_API.G_EXC_ERROR;

Line 825: RAISE FND_API.G_EXC_ERROR;

821: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
822: IF (l_debug = 1) THEN
823: MYDEBUG('ERROR IN PICK DROP ');
824: END IF;
825: RAISE FND_API.G_EXC_ERROR;
826: END IF;
827:
828: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
829: IF (l_debug = 1) THEN

Line 828: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

824: END IF;
825: RAISE FND_API.G_EXC_ERROR;
826: END IF;
827:
828: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
829: IF (l_debug = 1) THEN
830: MYDEBUG('UNEXPECTED ERROR IN PICK DROP ');
831: END IF;
832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

828: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
829: IF (l_debug = 1) THEN
830: MYDEBUG('UNEXPECTED ERROR IN PICK DROP ');
831: END IF;
832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
833: END IF;
834:
835: EXCEPTION
836:

Line 837: WHEN FND_API.G_EXC_ERROR THEN

833: END IF;
834:
835: EXCEPTION
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:

Line 839: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

835: EXCEPTION
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:

Line 842: WHEN FND_API.G_EXC_UNEXPECTED_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;
845: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
846:

Line 844: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_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;
845: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
846:
847: WHEN OTHERS THEN
848:

Line 849: 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;
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 );