DBA Data[Home] [Help]

APPS.INV_STATUS_PKG dependencies on FND_MESSAGE

Line 129: FND_MESSAGE.SET_NAME('WMS','WMS_MULTI_STATUS');

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;

Line 130: x_Message := FND_MESSAGE.GET;

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:

Line 210: FND_MESSAGE.SET_NAME('WMS','WMS_MULTI_STATUS');

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;

Line 211: x_Message := FND_MESSAGE.GET;

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:

Line 517: FND_MESSAGE.SET_NAME('WMS','WMS_STATUS_UPDATE_FAILED');

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

Line 518: x_Message := FND_MESSAGE.GET;

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;

Line 676: FND_MESSAGE.SET_NAME('FND','FLEX-HASH DEADLOCK');

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;

Line 677: x_message := FND_MESSAGE.GET;

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;

Line 738: FND_MESSAGE.SET_NAME('WMS','WMS_WORKFLOW_CALL_FAIL');

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

Line 739: x_message := FND_MESSAGE.GET;

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

Line 745: FND_MESSAGE.SET_NAME('WMS','WMS_NO_STATUS_CHANGED');

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

Line 746: x_Message := FND_MESSAGE.GET;

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

Line 766: FND_MESSAGE.SET_NAME('WMS','WMS_STATUS_UPDATE_FAILED');

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:

Line 767: x_Message := FND_MESSAGE.GET;

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(