DBA Data[Home] [Help]

APPS.INV_STATUS_PKG dependencies on FND_MESSAGE

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

181: lot_status_id := cc.status_id;
182: first_row := FALSE;
183: elsif cc.status_id <> lot_status_id then
184: x_Status := 'E';
185: FND_MESSAGE.SET_NAME('WMS','WMS_MULTI_STATUS');
186: x_Message := FND_MESSAGE.GET;
187: -- x_Message := 'Multiple lot status';
188: end if;
189: END LOOP;

Line 186: x_Message := FND_MESSAGE.GET;

182: first_row := FALSE;
183: elsif cc.status_id <> lot_status_id then
184: x_Status := 'E';
185: FND_MESSAGE.SET_NAME('WMS','WMS_MULTI_STATUS');
186: x_Message := FND_MESSAGE.GET;
187: -- x_Message := 'Multiple lot status';
188: end if;
189: END LOOP;
190:

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

262: serial_status_id := cc.status_id;
263: first_row := FALSE;
264: elsif cc.status_id <> serial_status_id then
265: x_Status := 'E';
266: FND_MESSAGE.SET_NAME('WMS','WMS_MULTI_STATUS');
267: x_Message := FND_MESSAGE.GET;
268: -- x_Message := 'Multiple serial status';
269: end if;
270: END LOOP;

Line 267: x_Message := FND_MESSAGE.GET;

263: first_row := FALSE;
264: elsif cc.status_id <> serial_status_id then
265: x_Status := 'E';
266: FND_MESSAGE.SET_NAME('WMS','WMS_MULTI_STATUS');
267: x_Message := FND_MESSAGE.GET;
268: -- x_Message := 'Multiple serial status';
269: end if;
270: END LOOP;
271:

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

556: EXCEPTION
557: WHEN OTHERS THEN
558: NULL ;
559: -- x_status := 'E';
560: -- FND_MESSAGE.SET_NAME('WMS','WMS_STATUS_UPDATE_FAILED');
561: -- x_Message := FND_MESSAGE.GET;
562: END;
563: --ERES Deferred
564:

Line 561: -- x_Message := FND_MESSAGE.GET;

557: WHEN OTHERS THEN
558: NULL ;
559: -- x_status := 'E';
560: -- FND_MESSAGE.SET_NAME('WMS','WMS_STATUS_UPDATE_FAILED');
561: -- x_Message := FND_MESSAGE.GET;
562: END;
563: --ERES Deferred
564:
565: PROCEDURE update_status(

Line 750: FND_MESSAGE.SET_NAME('INV','INV_ERES_IN_PROCESS');

746: END IF;
747:
748: EXCEPTION WHEN e_invalid_update THEN
749: mdebug(' IN e_invalid_update EXCEPTION ');
750: FND_MESSAGE.SET_NAME('INV','INV_ERES_IN_PROCESS');
751: x_message := FND_MESSAGE.GET;
752: x_status :='E';
753: RETURN;
754: END; */

Line 751: x_message := FND_MESSAGE.GET;

747:
748: EXCEPTION WHEN e_invalid_update THEN
749: mdebug(' IN e_invalid_update EXCEPTION ');
750: FND_MESSAGE.SET_NAME('INV','INV_ERES_IN_PROCESS');
751: x_message := FND_MESSAGE.GET;
752: x_status :='E';
753: RETURN;
754: END; */
755: --ERES Deferred

Line 786: FND_MESSAGE.SET_NAME('INV','INV_ERES_IN_PROCESS');

782: l_pending_eres_chk := 0;
783: END;
784: IF (l_pending_eres_chk = 1) THEN
785: mdebug(' IN e_invalid_update EXCEPTION ');
786: FND_MESSAGE.SET_NAME('INV','INV_ERES_IN_PROCESS');
787: x_message := FND_MESSAGE.GET;
788: x_status :='E';
789: RETURN;
790: END IF;

Line 787: x_message := FND_MESSAGE.GET;

783: END;
784: IF (l_pending_eres_chk = 1) THEN
785: mdebug(' IN e_invalid_update EXCEPTION ');
786: FND_MESSAGE.SET_NAME('INV','INV_ERES_IN_PROCESS');
787: x_message := FND_MESSAGE.GET;
788: x_status :='E';
789: RETURN;
790: END IF;
791:

Line 840: FND_MESSAGE.SET_NAME('INV','INV_ERES_IN_PROCESS');

836: END;
837:
838: IF (l_pending_eres_chk = 1) THEN
839: mdebug(' IN e_invalid_update EXCEPTION ');
840: FND_MESSAGE.SET_NAME('INV','INV_ERES_IN_PROCESS');
841: x_message := FND_MESSAGE.GET;
842: x_status :='E';
843: RETURN;
844: END IF;

Line 841: x_message := FND_MESSAGE.GET;

837:
838: IF (l_pending_eres_chk = 1) THEN
839: mdebug(' IN e_invalid_update EXCEPTION ');
840: FND_MESSAGE.SET_NAME('INV','INV_ERES_IN_PROCESS');
841: x_message := FND_MESSAGE.GET;
842: x_status :='E';
843: RETURN;
844: END IF;
845:

Line 898: FND_MESSAGE.SET_NAME('INV','INV_ERES_IN_PROCESS');

894:
895:
896: IF (l_pending_eres_chk = 1) THEN
897: mdebug(' IN e_invalid_update EXCEPTION ');
898: FND_MESSAGE.SET_NAME('INV','INV_ERES_IN_PROCESS');
899: x_message := FND_MESSAGE.GET;
900: x_status :='E';
901: RETURN;
902:

Line 899: x_message := FND_MESSAGE.GET;

895:
896: IF (l_pending_eres_chk = 1) THEN
897: mdebug(' IN e_invalid_update EXCEPTION ');
898: FND_MESSAGE.SET_NAME('INV','INV_ERES_IN_PROCESS');
899: x_message := FND_MESSAGE.GET;
900: x_status :='E';
901: RETURN;
902:
903: END IF;

Line 966: FND_MESSAGE.SET_NAME('INV','INV_ERES_IN_PROCESS');

962: END;
963:
964: IF (l_pending_eres_chk = 1) THEN
965: mdebug(' IN e_invalid_update EXCEPTION ');
966: FND_MESSAGE.SET_NAME('INV','INV_ERES_IN_PROCESS');
967: x_message := FND_MESSAGE.GET;
968: x_status :='E';
969: RETURN;
970: END IF;

Line 967: x_message := FND_MESSAGE.GET;

963:
964: IF (l_pending_eres_chk = 1) THEN
965: mdebug(' IN e_invalid_update EXCEPTION ');
966: FND_MESSAGE.SET_NAME('INV','INV_ERES_IN_PROCESS');
967: x_message := FND_MESSAGE.GET;
968: x_status :='E';
969: RETURN;
970: END IF;
971:

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

1036: l_serial_status_enabled := 1;
1037: --bug 6952533
1038: IF(l_serial_status_control = 2)THEN
1039: x_status := 'E';
1040: FND_MESSAGE.SET_NAME('WMS','WMS_STATUS_UPDATE_FAILED');
1041: x_Message := FND_MESSAGE.GET;
1042: RETURN;
1043: END IF;
1044: --end of bug 6952533

Line 1041: x_Message := FND_MESSAGE.GET;

1037: --bug 6952533
1038: IF(l_serial_status_control = 2)THEN
1039: x_status := 'E';
1040: FND_MESSAGE.SET_NAME('WMS','WMS_STATUS_UPDATE_FAILED');
1041: x_Message := FND_MESSAGE.GET;
1042: RETURN;
1043: END IF;
1044: --end of bug 6952533
1045: END IF;

Line 1160: FND_MESSAGE.SET_NAME('INV','INV_ERES_IN_PROCESS');

1156:
1157: END;
1158: IF (l_pending_eres_chk = 1) THEN
1159: mdebug(' IN e_invalid_update EXCEPTION ');
1160: FND_MESSAGE.SET_NAME('INV','INV_ERES_IN_PROCESS');
1161: x_message := FND_MESSAGE.GET;
1162: x_status :='E';
1163: RETURN;
1164: END IF;

Line 1161: x_message := FND_MESSAGE.GET;

1157: END;
1158: IF (l_pending_eres_chk = 1) THEN
1159: mdebug(' IN e_invalid_update EXCEPTION ');
1160: FND_MESSAGE.SET_NAME('INV','INV_ERES_IN_PROCESS');
1161: x_message := FND_MESSAGE.GET;
1162: x_status :='E';
1163: RETURN;
1164: END IF;
1165: --ERES Deferred

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

1294: mdebug(' update executed in sql: Onhand Serial');
1295:
1296: EXCEPTION WHEN OTHERS THEN
1297: mdebug(' IN OTHERS EXCEPTION '||sqlerrm);
1298: FND_MESSAGE.SET_NAME('FND','FLEX-HASH DEADLOCK');
1299: x_message := FND_MESSAGE.GET;
1300: x_status :='E';
1301: IF cur_onhand%ISOPEN THEN
1302: CLOSE cur_onhand;

Line 1299: x_message := FND_MESSAGE.GET;

1295:
1296: EXCEPTION WHEN OTHERS THEN
1297: mdebug(' IN OTHERS EXCEPTION '||sqlerrm);
1298: FND_MESSAGE.SET_NAME('FND','FLEX-HASH DEADLOCK');
1299: x_message := FND_MESSAGE.GET;
1300: x_status :='E';
1301: IF cur_onhand%ISOPEN THEN
1302: CLOSE cur_onhand;
1303: END IF;

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

1356: ROLLBACK TO INV_UPDATE_STATUS;
1357: END IF;
1358: --ROLLBACK TO INV_UPDATE_STATUS;
1359: --END SCHANDRU INVERES
1360: FND_MESSAGE.SET_NAME('WMS','WMS_WORKFLOW_CALL_FAIL');
1361: x_message := FND_MESSAGE.GET;
1362: end if;
1363: if p_sub_status_id <=0 and p_loc_status_id <=0 and
1364: p_lot_status_id <=0 and p_serial_status_id <=0

Line 1361: x_message := FND_MESSAGE.GET;

1357: END IF;
1358: --ROLLBACK TO INV_UPDATE_STATUS;
1359: --END SCHANDRU INVERES
1360: FND_MESSAGE.SET_NAME('WMS','WMS_WORKFLOW_CALL_FAIL');
1361: x_message := FND_MESSAGE.GET;
1362: end if;
1363: if p_sub_status_id <=0 and p_loc_status_id <=0 and
1364: p_lot_status_id <=0 and p_serial_status_id <=0
1365: and p_onhand_status_id<=0 and x_status ='C' then

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

1363: if p_sub_status_id <=0 and p_loc_status_id <=0 and
1364: p_lot_status_id <=0 and p_serial_status_id <=0
1365: and p_onhand_status_id<=0 and x_status ='C' then
1366: x_Status := 'E';
1367: FND_MESSAGE.SET_NAME('WMS','WMS_NO_STATUS_CHANGED');
1368: x_Message := FND_MESSAGE.GET;
1369: -- x_Message := 'No changes to update';
1370: else
1371: --BEGIN SCHANDRU INVERES

Line 1368: x_Message := FND_MESSAGE.GET;

1364: p_lot_status_id <=0 and p_serial_status_id <=0
1365: and p_onhand_status_id<=0 and x_status ='C' then
1366: x_Status := 'E';
1367: FND_MESSAGE.SET_NAME('WMS','WMS_NO_STATUS_CHANGED');
1368: x_Message := FND_MESSAGE.GET;
1369: -- x_Message := 'No changes to update';
1370: else
1371: --BEGIN SCHANDRU INVERES
1372: --commit; --For bug 5487508, the commit will be issued from Java

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

1384:
1385: --ROLLBACK TO INV_UPDATE_STATUS;
1386: --END SCHANDRU INVERES
1387: x_status := 'E';
1388: FND_MESSAGE.SET_NAME('WMS','WMS_STATUS_UPDATE_FAILED');
1389: x_Message := FND_MESSAGE.GET;
1390: END update_status;
1391:
1392:

Line 1389: x_Message := FND_MESSAGE.GET;

1385: --ROLLBACK TO INV_UPDATE_STATUS;
1386: --END SCHANDRU INVERES
1387: x_status := 'E';
1388: FND_MESSAGE.SET_NAME('WMS','WMS_STATUS_UPDATE_FAILED');
1389: x_Message := FND_MESSAGE.GET;
1390: END update_status;
1391:
1392:
1393: PROCEDURE invoke_reason_wf(