125: lot_status_id := cc.status_id;
126: first_row := FALSE;
127: elsif cc.status_id <> lot_status_id then
128: x_Status := 'E';
129: FND_MESSAGE.SET_NAME('WMS','WMS_MULTI_STATUS');
130: x_Message := FND_MESSAGE.GET;
131: -- x_Message := 'Multiple lot status';
132: end if;
133: END LOOP;
126: first_row := FALSE;
127: elsif cc.status_id <> lot_status_id then
128: x_Status := 'E';
129: FND_MESSAGE.SET_NAME('WMS','WMS_MULTI_STATUS');
130: x_Message := FND_MESSAGE.GET;
131: -- x_Message := 'Multiple lot status';
132: end if;
133: END LOOP;
134:
206: serial_status_id := cc.status_id;
207: first_row := FALSE;
208: elsif cc.status_id <> serial_status_id then
209: x_Status := 'E';
210: FND_MESSAGE.SET_NAME('WMS','WMS_MULTI_STATUS');
211: x_Message := FND_MESSAGE.GET;
212: -- x_Message := 'Multiple serial status';
213: end if;
214: END LOOP;
207: first_row := FALSE;
208: elsif cc.status_id <> serial_status_id then
209: x_Status := 'E';
210: FND_MESSAGE.SET_NAME('WMS','WMS_MULTI_STATUS');
211: x_Message := FND_MESSAGE.GET;
212: -- x_Message := 'Multiple serial status';
213: end if;
214: END LOOP;
215:
513: l_serial_status_enabled := 1;
514: --bug 6952533
515: IF(l_serial_status_control = 2)THEN
516: x_status := 'E';
517: FND_MESSAGE.SET_NAME('WMS','WMS_STATUS_UPDATE_FAILED');
518: x_Message := FND_MESSAGE.GET;
519: RETURN;
520: END IF;
521: --end of bug 6952533
514: --bug 6952533
515: IF(l_serial_status_control = 2)THEN
516: x_status := 'E';
517: FND_MESSAGE.SET_NAME('WMS','WMS_STATUS_UPDATE_FAILED');
518: x_Message := FND_MESSAGE.GET;
519: RETURN;
520: END IF;
521: --end of bug 6952533
522: END IF;
672: INV_MATERIAL_STATUS_PKG.Insert_status_history(l_status_rec);
673: end if;
674: EXCEPTION WHEN OTHERS THEN
675: mdebug(' IN OTHERS EXCEPTION '||sqlerrm);
676: FND_MESSAGE.SET_NAME('FND','FLEX-HASH DEADLOCK');
677: x_message := FND_MESSAGE.GET;
678: x_status :='E';
679: IF cur_onhand%ISOPEN THEN
680: CLOSE cur_onhand;
673: end if;
674: EXCEPTION WHEN OTHERS THEN
675: mdebug(' IN OTHERS EXCEPTION '||sqlerrm);
676: FND_MESSAGE.SET_NAME('FND','FLEX-HASH DEADLOCK');
677: x_message := FND_MESSAGE.GET;
678: x_status :='E';
679: IF cur_onhand%ISOPEN THEN
680: CLOSE cur_onhand;
681: END IF;
734: ROLLBACK TO INV_UPDATE_STATUS;
735: END IF;
736: --ROLLBACK TO INV_UPDATE_STATUS;
737: --END SCHANDRU INVERES
738: FND_MESSAGE.SET_NAME('WMS','WMS_WORKFLOW_CALL_FAIL');
739: x_message := FND_MESSAGE.GET;
740: end if;
741: if p_sub_status_id <=0 and p_loc_status_id <=0 and
742: p_lot_status_id <=0 and p_serial_status_id <=0
735: END IF;
736: --ROLLBACK TO INV_UPDATE_STATUS;
737: --END SCHANDRU INVERES
738: FND_MESSAGE.SET_NAME('WMS','WMS_WORKFLOW_CALL_FAIL');
739: x_message := FND_MESSAGE.GET;
740: end if;
741: if p_sub_status_id <=0 and p_loc_status_id <=0 and
742: p_lot_status_id <=0 and p_serial_status_id <=0
743: and p_onhand_status_id<=0 and x_status ='C' then
741: if p_sub_status_id <=0 and p_loc_status_id <=0 and
742: p_lot_status_id <=0 and p_serial_status_id <=0
743: and p_onhand_status_id<=0 and x_status ='C' then
744: x_Status := 'E';
745: FND_MESSAGE.SET_NAME('WMS','WMS_NO_STATUS_CHANGED');
746: x_Message := FND_MESSAGE.GET;
747: -- x_Message := 'No changes to update';
748: else
749: --BEGIN SCHANDRU INVERES
742: p_lot_status_id <=0 and p_serial_status_id <=0
743: and p_onhand_status_id<=0 and x_status ='C' then
744: x_Status := 'E';
745: FND_MESSAGE.SET_NAME('WMS','WMS_NO_STATUS_CHANGED');
746: x_Message := FND_MESSAGE.GET;
747: -- x_Message := 'No changes to update';
748: else
749: --BEGIN SCHANDRU INVERES
750: --commit; --For bug 5487508, the commit will be issued from Java
762:
763: --ROLLBACK TO INV_UPDATE_STATUS;
764: --END SCHANDRU INVERES
765: x_status := 'E';
766: FND_MESSAGE.SET_NAME('WMS','WMS_STATUS_UPDATE_FAILED');
767: x_Message := FND_MESSAGE.GET;
768: END update_status;
769:
770:
763: --ROLLBACK TO INV_UPDATE_STATUS;
764: --END SCHANDRU INVERES
765: x_status := 'E';
766: FND_MESSAGE.SET_NAME('WMS','WMS_STATUS_UPDATE_FAILED');
767: x_Message := FND_MESSAGE.GET;
768: END update_status;
769:
770:
771: PROCEDURE invoke_reason_wf(