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.WSMPINVL dependencies on FND_MESSAGE

Line 424: fnd_message.set_name('WSM', 'WSM_REPRESENTATIVE_LOT');

420: where wsli.representative_flag='Y' and wsli.header_id=txn.header_id;
421:
422: IF rep_flag_count <> 1 THEN
423:
424: fnd_message.set_name('WSM', 'WSM_REPRESENTATIVE_LOT');
425: o_err_message:=fnd_message.get;
426: Error_All(txn.header_id, p_group_id,o_err_message);
427: x_header_id :=-1;
428: x_continue := FALSE;

Line 425: o_err_message:=fnd_message.get;

421:
422: IF rep_flag_count <> 1 THEN
423:
424: fnd_message.set_name('WSM', 'WSM_REPRESENTATIVE_LOT');
425: o_err_message:=fnd_message.get;
426: Error_All(txn.header_id, p_group_id,o_err_message);
427: x_header_id :=-1;
428: x_continue := FALSE;
429:

Line 894: /*fnd_message.set_name('INV',l_msg_data);

890: /* ST : bug fix 3732133 : Added condition to check for the return status and also nvl as the INV API returns msg_count as NULL in some cases */
891: IF ( nvl(l_msg_count,-1) = 1) THEN
892:
893: /* ST : bug fix 3732133 : commented out this code as l_msg_data will not be the message code */
894: /*fnd_message.set_name('INV',l_msg_data);
895: l_err_msg := fnd_message.get;*/
896: l_err_msg := l_msg_data;
897:
898: showProgress(

Line 895: l_err_msg := fnd_message.get;*/

891: IF ( nvl(l_msg_count,-1) = 1) THEN
892:
893: /* ST : bug fix 3732133 : commented out this code as l_msg_data will not be the message code */
894: /*fnd_message.set_name('INV',l_msg_data);
895: l_err_msg := fnd_message.get;*/
896: l_err_msg := l_msg_data;
897:
898: showProgress(
899: processingMode => p_process_status

Line 919: l_err_msg := fnd_message.get;

915:
916: FOR i IN 1..l_msg_count LOOP
917:
918: l_msg_data := fnd_msg_pub.get;
919: l_err_msg := fnd_message.get;
920:
921: showProgress(
922: processingMode => p_process_status
923: , headerId => l_header_id

Line 1057: --fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');

1053: WHERE wlsmi.header_id = p_header_id
1054: AND wlsmi.organization_id = crec.organization_id;
1055:
1056: EXCEPTION when others THEN
1057: --fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');
1058: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1059: FND_MESSAGE.SET_TOKEN('FLD_NAME',
1060: 'organization_id. Mismatch between Header and Starting Lot.');
1061: o_err_message:= fnd_message.get;

Line 1058: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

1054: AND wlsmi.organization_id = crec.organization_id;
1055:
1056: EXCEPTION when others THEN
1057: --fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');
1058: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1059: FND_MESSAGE.SET_TOKEN('FLD_NAME',
1060: 'organization_id. Mismatch between Header and Starting Lot.');
1061: o_err_message:= fnd_message.get;
1062: err_status := -1;

Line 1059: FND_MESSAGE.SET_TOKEN('FLD_NAME',

1055:
1056: EXCEPTION when others THEN
1057: --fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');
1058: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1059: FND_MESSAGE.SET_TOKEN('FLD_NAME',
1060: 'organization_id. Mismatch between Header and Starting Lot.');
1061: o_err_message:= fnd_message.get;
1062: err_status := -1;
1063: return;

Line 1061: o_err_message:= fnd_message.get;

1057: --fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');
1058: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1059: FND_MESSAGE.SET_TOKEN('FLD_NAME',
1060: 'organization_id. Mismatch between Header and Starting Lot.');
1061: o_err_message:= fnd_message.get;
1062: err_status := -1;
1063: return;
1064: END;
1065:

Line 1147: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

1143: AND sysdate between start_date
1144: and nvl(END_date, sysdate + 1);
1145:
1146: EXCEPTION when others THEN
1147: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1148: FND_MESSAGE.SET_TOKEN('FLD_NAME','created_by in Staring Lots');
1149: o_err_message:= fnd_message.get;
1150: err_status := -1;
1151: return;

Line 1148: FND_MESSAGE.SET_TOKEN('FLD_NAME','created_by in Staring Lots');

1144: and nvl(END_date, sysdate + 1);
1145:
1146: EXCEPTION when others THEN
1147: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1148: FND_MESSAGE.SET_TOKEN('FLD_NAME','created_by in Staring Lots');
1149: o_err_message:= fnd_message.get;
1150: err_status := -1;
1151: return;
1152: END;

Line 1149: o_err_message:= fnd_message.get;

1145:
1146: EXCEPTION when others THEN
1147: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1148: FND_MESSAGE.SET_TOKEN('FLD_NAME','created_by in Staring Lots');
1149: o_err_message:= fnd_message.get;
1150: err_status := -1;
1151: return;
1152: END;
1153: /*

Line 1163: fnd_message.set_name('WSM','WSM_ORG_LOT_NONUNIQUE');

1159: ,x_err_code
1160: ,x_err_msg );
1161:
1162: IF (x_return_code=0) then
1163: fnd_message.set_name('WSM','WSM_ORG_LOT_NONUNIQUE');
1164: FND_MESSAGE.SET_TOKEN('FLD_NAME','wsm_organization_id');
1165: o_err_message:= fnd_message.get;
1166: err_status := -1;
1167: --fnd_message.error;

Line 1164: FND_MESSAGE.SET_TOKEN('FLD_NAME','wsm_organization_id');

1160: ,x_err_msg );
1161:
1162: IF (x_return_code=0) then
1163: fnd_message.set_name('WSM','WSM_ORG_LOT_NONUNIQUE');
1164: FND_MESSAGE.SET_TOKEN('FLD_NAME','wsm_organization_id');
1165: o_err_message:= fnd_message.get;
1166: err_status := -1;
1167: --fnd_message.error;
1168: END IF;

Line 1165: o_err_message:= fnd_message.get;

1161:
1162: IF (x_return_code=0) then
1163: fnd_message.set_name('WSM','WSM_ORG_LOT_NONUNIQUE');
1164: FND_MESSAGE.SET_TOKEN('FLD_NAME','wsm_organization_id');
1165: o_err_message:= fnd_message.get;
1166: err_status := -1;
1167: --fnd_message.error;
1168: END IF;
1169: END;

Line 1167: --fnd_message.error;

1163: fnd_message.set_name('WSM','WSM_ORG_LOT_NONUNIQUE');
1164: FND_MESSAGE.SET_TOKEN('FLD_NAME','wsm_organization_id');
1165: o_err_message:= fnd_message.get;
1166: err_status := -1;
1167: --fnd_message.error;
1168: END IF;
1169: END;
1170: */
1171: -- check if this lot_number exists in mtl_transaction_lots_temp

Line 1215: fnd_message.set_name('WSM', 'WSM_NO_INV_LOT_TXN');

1211: WHERE organization_id = crec.organization_id
1212: AND inventory_item_id = crec.inventory_item_id;
1213:
1214: IF l_serial_ctrl <> 1 then
1215: fnd_message.set_name('WSM', 'WSM_NO_INV_LOT_TXN');
1216: o_err_message:= fnd_message.get;
1217: err_status := -1;
1218: return;
1219: END IF;

Line 1216: o_err_message:= fnd_message.get;

1212: AND inventory_item_id = crec.inventory_item_id;
1213:
1214: IF l_serial_ctrl <> 1 then
1215: fnd_message.set_name('WSM', 'WSM_NO_INV_LOT_TXN');
1216: o_err_message:= fnd_message.get;
1217: err_status := -1;
1218: return;
1219: END IF;
1220:

Line 1257: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');

1253: End If;
1254:
1255: If x_dummy <> 0 Then
1256:
1257: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
1258:
1259: FND_MESSAGE.SET_TOKEN('TABLE',
1260: 'Starting Lot:'||crec.lot_number
1261: ||'Table: mtl_transaction_lots_temp ');

Line 1259: FND_MESSAGE.SET_TOKEN('TABLE',

1255: If x_dummy <> 0 Then
1256:
1257: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
1258:
1259: FND_MESSAGE.SET_TOKEN('TABLE',
1260: 'Starting Lot:'||crec.lot_number
1261: ||'Table: mtl_transaction_lots_temp ');
1262:
1263: o_err_message:= substr(fnd_message.get, 1, 2000);

Line 1263: o_err_message:= substr(fnd_message.get, 1, 2000);

1259: FND_MESSAGE.SET_TOKEN('TABLE',
1260: 'Starting Lot:'||crec.lot_number
1261: ||'Table: mtl_transaction_lots_temp ');
1262:
1263: o_err_message:= substr(fnd_message.get, 1, 2000);
1264: err_status := -1;
1265: return;
1266:
1267: END IF;

Line 1291: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');

1287: FROM mtl_transaction_lots_temp
1288: WHERE lot_number=crec.lot_number;
1289:
1290: IF x_dummy <>0 then
1291: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
1292: FND_MESSAGE.SET_TOKEN('TABLE',
1293: 'Starting Lot:'||crec.lot_number
1294: ||'Table: mtl_transaction_lots_temp ');
1295: o_err_message:= substr(fnd_message.get(), 1, 2000);

Line 1292: FND_MESSAGE.SET_TOKEN('TABLE',

1288: WHERE lot_number=crec.lot_number;
1289:
1290: IF x_dummy <>0 then
1291: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
1292: FND_MESSAGE.SET_TOKEN('TABLE',
1293: 'Starting Lot:'||crec.lot_number
1294: ||'Table: mtl_transaction_lots_temp ');
1295: o_err_message:= substr(fnd_message.get(), 1, 2000);
1296: err_status := -1;

Line 1295: o_err_message:= substr(fnd_message.get(), 1, 2000);

1291: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
1292: FND_MESSAGE.SET_TOKEN('TABLE',
1293: 'Starting Lot:'||crec.lot_number
1294: ||'Table: mtl_transaction_lots_temp ');
1295: o_err_message:= substr(fnd_message.get(), 1, 2000);
1296: err_status := -1;
1297: return;
1298: END IF;
1299:

Line 1325: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

1321: AND sysdate between start_date
1322: and nvl(END_date, sysdate + 1);
1323:
1324: EXCEPTION when others THEN
1325: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1326: FND_MESSAGE.SET_TOKEN('FLD_NAME','last_updated_by in Starting Lots');
1327: o_err_message:= fnd_message.get;
1328: err_status := -1;
1329: return;

Line 1326: FND_MESSAGE.SET_TOKEN('FLD_NAME','last_updated_by in Starting Lots');

1322: and nvl(END_date, sysdate + 1);
1323:
1324: EXCEPTION when others THEN
1325: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1326: FND_MESSAGE.SET_TOKEN('FLD_NAME','last_updated_by in Starting Lots');
1327: o_err_message:= fnd_message.get;
1328: err_status := -1;
1329: return;
1330: END;

Line 1327: o_err_message:= fnd_message.get;

1323:
1324: EXCEPTION when others THEN
1325: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1326: FND_MESSAGE.SET_TOKEN('FLD_NAME','last_updated_by in Starting Lots');
1327: o_err_message:= fnd_message.get;
1328: err_status := -1;
1329: return;
1330: END;
1331: /*

Line 1339: --fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');

1335: FROM wsm_lot_split_merges_interface
1336: WHERE transaction_id = p_header_id
1337: AND organization_id = crec.organization_id;
1338: EXCEPTION when others THEN
1339: --fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');
1340: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1341: FND_MESSAGE.SET_TOKEN('FLD_NAME','organization_id in Starting Lots');
1342: o_err_message:= fnd_message.get;
1343: err_status := -1;

Line 1340: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

1336: WHERE transaction_id = p_header_id
1337: AND organization_id = crec.organization_id;
1338: EXCEPTION when others THEN
1339: --fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');
1340: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1341: FND_MESSAGE.SET_TOKEN('FLD_NAME','organization_id in Starting Lots');
1342: o_err_message:= fnd_message.get;
1343: err_status := -1;
1344: return;

Line 1341: FND_MESSAGE.SET_TOKEN('FLD_NAME','organization_id in Starting Lots');

1337: AND organization_id = crec.organization_id;
1338: EXCEPTION when others THEN
1339: --fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');
1340: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1341: FND_MESSAGE.SET_TOKEN('FLD_NAME','organization_id in Starting Lots');
1342: o_err_message:= fnd_message.get;
1343: err_status := -1;
1344: return;
1345: END;

Line 1342: o_err_message:= fnd_message.get;

1338: EXCEPTION when others THEN
1339: --fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');
1340: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1341: FND_MESSAGE.SET_TOKEN('FLD_NAME','organization_id in Starting Lots');
1342: o_err_message:= fnd_message.get;
1343: err_status := -1;
1344: return;
1345: END;
1346: */

Line 1372: fnd_message.set_name('WSM', 'WSM_ORG_LOT_NONUNIQUE');

1368: where organization_id = crec.organization_id;
1369:
1370: if mtl_unique <> 2 then
1371: --bugfix 1995378: changed message_name
1372: fnd_message.set_name('WSM', 'WSM_ORG_LOT_NONUNIQUE');
1373: --FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number in Starting Lots');
1374: o_err_message:= fnd_message.get;
1375: err_status := -1;
1376: return;

Line 1373: --FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number in Starting Lots');

1369:
1370: if mtl_unique <> 2 then
1371: --bugfix 1995378: changed message_name
1372: fnd_message.set_name('WSM', 'WSM_ORG_LOT_NONUNIQUE');
1373: --FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number in Starting Lots');
1374: o_err_message:= fnd_message.get;
1375: err_status := -1;
1376: return;
1377: else

Line 1374: o_err_message:= fnd_message.get;

1370: if mtl_unique <> 2 then
1371: --bugfix 1995378: changed message_name
1372: fnd_message.set_name('WSM', 'WSM_ORG_LOT_NONUNIQUE');
1373: --FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number in Starting Lots');
1374: o_err_message:= fnd_message.get;
1375: err_status := -1;
1376: return;
1377: else
1378: unique_lot := FALSE;

Line 1383: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

1379: end if;
1380:
1381:
1382: when others THEN
1383: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1384: FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number in Starting Lots');
1385: o_err_message:= fnd_message.get;
1386: err_status := -1;
1387: return;

Line 1384: FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number in Starting Lots');

1380:
1381:
1382: when others THEN
1383: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1384: FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number in Starting Lots');
1385: o_err_message:= fnd_message.get;
1386: err_status := -1;
1387: return;
1388: END;

Line 1385: o_err_message:= fnd_message.get;

1381:
1382: when others THEN
1383: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1384: FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number in Starting Lots');
1385: o_err_message:= fnd_message.get;
1386: err_status := -1;
1387: return;
1388: END;
1389: --bugfix 1823316 added condition to process multi-item or multi-subinventory lot

Line 1395: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

1391: if unique_lot then
1392: /*BA#1414465*/
1393:
1394: IF x_item_id <> crec.inventory_item_id THEN
1395: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1396: FND_MESSAGE.SET_TOKEN('FLD_NAME','Inventory Item in Starting Lots');
1397: o_err_message:= fnd_message.get;
1398: err_status := -1;
1399: return;

Line 1396: FND_MESSAGE.SET_TOKEN('FLD_NAME','Inventory Item in Starting Lots');

1392: /*BA#1414465*/
1393:
1394: IF x_item_id <> crec.inventory_item_id THEN
1395: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1396: FND_MESSAGE.SET_TOKEN('FLD_NAME','Inventory Item in Starting Lots');
1397: o_err_message:= fnd_message.get;
1398: err_status := -1;
1399: return;
1400: END IF;

Line 1397: o_err_message:= fnd_message.get;

1393:
1394: IF x_item_id <> crec.inventory_item_id THEN
1395: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1396: FND_MESSAGE.SET_TOKEN('FLD_NAME','Inventory Item in Starting Lots');
1397: o_err_message:= fnd_message.get;
1398: err_status := -1;
1399: return;
1400: END IF;
1401:

Line 1406: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

1402: /*EA#1414465*/
1403:
1404:
1405: IF nvl(x_revision,'@@@') <> nvl(crec.revision, '@@@') THEN
1406: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1407: FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Starting Lots');
1408: o_err_message:= fnd_message.get;
1409: err_status := -1;
1410: return;

Line 1407: FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Starting Lots');

1403:
1404:
1405: IF nvl(x_revision,'@@@') <> nvl(crec.revision, '@@@') THEN
1406: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1407: FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Starting Lots');
1408: o_err_message:= fnd_message.get;
1409: err_status := -1;
1410: return;
1411: END IF;

Line 1408: o_err_message:= fnd_message.get;

1404:
1405: IF nvl(x_revision,'@@@') <> nvl(crec.revision, '@@@') THEN
1406: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1407: FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Starting Lots');
1408: o_err_message:= fnd_message.get;
1409: err_status := -1;
1410: return;
1411: END IF;
1412:

Line 1414: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

1410: return;
1411: END IF;
1412:
1413: IF x_sub <> crec.subinventory_code THEN
1414: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1415: FND_MESSAGE.SET_TOKEN('FLD_NAME','subinventory_code in Starting Lots');
1416: o_err_message:= fnd_message.get;
1417: err_status := -1;
1418: return;

Line 1415: FND_MESSAGE.SET_TOKEN('FLD_NAME','subinventory_code in Starting Lots');

1411: END IF;
1412:
1413: IF x_sub <> crec.subinventory_code THEN
1414: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1415: FND_MESSAGE.SET_TOKEN('FLD_NAME','subinventory_code in Starting Lots');
1416: o_err_message:= fnd_message.get;
1417: err_status := -1;
1418: return;
1419: END IF;

Line 1416: o_err_message:= fnd_message.get;

1412:
1413: IF x_sub <> crec.subinventory_code THEN
1414: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1415: FND_MESSAGE.SET_TOKEN('FLD_NAME','subinventory_code in Starting Lots');
1416: o_err_message:= fnd_message.get;
1417: err_status := -1;
1418: return;
1419: END IF;
1420:

Line 1422: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

1418: return;
1419: END IF;
1420:
1421: IF nvl(x_locator_id, -9) <> nvl(crec.locator_id, -9) THEN
1422: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1423: FND_MESSAGE.SET_TOKEN('FLD_NAME','locator_id in Starting Lots');
1424: o_err_message:= fnd_message.get;
1425: err_status := -1;
1426: return;

Line 1423: FND_MESSAGE.SET_TOKEN('FLD_NAME','locator_id in Starting Lots');

1419: END IF;
1420:
1421: IF nvl(x_locator_id, -9) <> nvl(crec.locator_id, -9) THEN
1422: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1423: FND_MESSAGE.SET_TOKEN('FLD_NAME','locator_id in Starting Lots');
1424: o_err_message:= fnd_message.get;
1425: err_status := -1;
1426: return;
1427: END IF;

Line 1424: o_err_message:= fnd_message.get;

1420:
1421: IF nvl(x_locator_id, -9) <> nvl(crec.locator_id, -9) THEN
1422: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1423: FND_MESSAGE.SET_TOKEN('FLD_NAME','locator_id in Starting Lots');
1424: o_err_message:= fnd_message.get;
1425: err_status := -1;
1426: return;
1427: END IF;
1428:

Line 1438: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

1434: ** pending records the quantities might have changed.
1435: **
1436:
1437: IF x_quantity <> crec.quantity THEN
1438: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1439: FND_MESSAGE.SET_TOKEN('FLD_NAME','quantity in Starting Lots');
1440: o_err_message:= fnd_message.get;
1441: err_status := -1;
1442: return;

Line 1439: FND_MESSAGE.SET_TOKEN('FLD_NAME','quantity in Starting Lots');

1435: **
1436:
1437: IF x_quantity <> crec.quantity THEN
1438: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1439: FND_MESSAGE.SET_TOKEN('FLD_NAME','quantity in Starting Lots');
1440: o_err_message:= fnd_message.get;
1441: err_status := -1;
1442: return;
1443: END IF;

Line 1440: o_err_message:= fnd_message.get;

1436:
1437: IF x_quantity <> crec.quantity THEN
1438: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1439: FND_MESSAGE.SET_TOKEN('FLD_NAME','quantity in Starting Lots');
1440: o_err_message:= fnd_message.get;
1441: err_status := -1;
1442: return;
1443: END IF;
1444: **

Line 1490: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

1486:
1487: close lot;
1488:
1489: if valid_lot = FALSE then
1490: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1491: fnd_message.set_token('FLD_NAME', invalid_field||' in Starting Lots');
1492: o_err_message :=fnd_message.get;
1493: err_status :=-1;
1494: return;

Line 1491: fnd_message.set_token('FLD_NAME', invalid_field||' in Starting Lots');

1487: close lot;
1488:
1489: if valid_lot = FALSE then
1490: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1491: fnd_message.set_token('FLD_NAME', invalid_field||' in Starting Lots');
1492: o_err_message :=fnd_message.get;
1493: err_status :=-1;
1494: return;
1495: end if;

Line 1492: o_err_message :=fnd_message.get;

1488:
1489: if valid_lot = FALSE then
1490: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1491: fnd_message.set_token('FLD_NAME', invalid_field||' in Starting Lots');
1492: o_err_message :=fnd_message.get;
1493: err_status :=-1;
1494: return;
1495: end if;
1496:

Line 1613: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

1609: WHERE user_id = crec.created_by
1610: AND sysdate between start_date
1611: and nvl(END_date, sysdate + 1);
1612: EXCEPTION when others THEN
1613: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1614: FND_MESSAGE.SET_TOKEN('FLD_NAME','created_by in Resulting Lots');
1615: o_err_message:= fnd_message.get;
1616: err_status := -1;
1617: return;

Line 1614: FND_MESSAGE.SET_TOKEN('FLD_NAME','created_by in Resulting Lots');

1610: AND sysdate between start_date
1611: and nvl(END_date, sysdate + 1);
1612: EXCEPTION when others THEN
1613: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1614: FND_MESSAGE.SET_TOKEN('FLD_NAME','created_by in Resulting Lots');
1615: o_err_message:= fnd_message.get;
1616: err_status := -1;
1617: return;
1618: END;

Line 1615: o_err_message:= fnd_message.get;

1611: and nvl(END_date, sysdate + 1);
1612: EXCEPTION when others THEN
1613: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1614: FND_MESSAGE.SET_TOKEN('FLD_NAME','created_by in Resulting Lots');
1615: o_err_message:= fnd_message.get;
1616: err_status := -1;
1617: return;
1618: END;
1619:

Line 1632: fnd_message.set_name('WSM','WSM_ORG_LOT_NONUNIQUE');

1628: ,x_err_code
1629: ,x_err_msg );
1630:
1631: IF (x_return_code=0) then
1632: fnd_message.set_name('WSM','WSM_ORG_LOT_NONUNIQUE');
1633: FND_MESSAGE.SET_TOKEN('FLD_NAME','organization_id in Resulting Lots');
1634: o_err_message:= fnd_message.get;
1635: err_status := -1;
1636: return;

Line 1633: FND_MESSAGE.SET_TOKEN('FLD_NAME','organization_id in Resulting Lots');

1629: ,x_err_msg );
1630:
1631: IF (x_return_code=0) then
1632: fnd_message.set_name('WSM','WSM_ORG_LOT_NONUNIQUE');
1633: FND_MESSAGE.SET_TOKEN('FLD_NAME','organization_id in Resulting Lots');
1634: o_err_message:= fnd_message.get;
1635: err_status := -1;
1636: return;
1637: --fnd_message.error;

Line 1634: o_err_message:= fnd_message.get;

1630:
1631: IF (x_return_code=0) then
1632: fnd_message.set_name('WSM','WSM_ORG_LOT_NONUNIQUE');
1633: FND_MESSAGE.SET_TOKEN('FLD_NAME','organization_id in Resulting Lots');
1634: o_err_message:= fnd_message.get;
1635: err_status := -1;
1636: return;
1637: --fnd_message.error;
1638: END IF;

Line 1637: --fnd_message.error;

1633: FND_MESSAGE.SET_TOKEN('FLD_NAME','organization_id in Resulting Lots');
1634: o_err_message:= fnd_message.get;
1635: err_status := -1;
1636: return;
1637: --fnd_message.error;
1638: END IF;
1639: END;
1640:
1641:

Line 1676: fnd_message.set_name('WSM', 'WSM_NO_INV_LOT_TXN');

1672: WHERE organization_id = crec.organization_id
1673: AND inventory_item_id = crec.inventory_item_id;
1674:
1675: IF l_serial_ctrl <> 1 then
1676: fnd_message.set_name('WSM', 'WSM_NO_INV_LOT_TXN');
1677: o_err_message:= fnd_message.get;
1678: err_status := -1;
1679: return;
1680: END IF;

Line 1677: o_err_message:= fnd_message.get;

1673: AND inventory_item_id = crec.inventory_item_id;
1674:
1675: IF l_serial_ctrl <> 1 then
1676: fnd_message.set_name('WSM', 'WSM_NO_INV_LOT_TXN');
1677: o_err_message:= fnd_message.get;
1678: err_status := -1;
1679: return;
1680: END IF;
1681:

Line 1721: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');

1717:
1718: End If;
1719:
1720: If x_dummy <> 0 Then
1721: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
1722: FND_MESSAGE.SET_TOKEN('TABLE',
1723: 'Resulting Lot:'||crec.lot_number
1724: ||'Table: mtl_transaction_lots_temp ');
1725: o_err_message:= substr(fnd_message.get(), 1, 2000);

Line 1722: FND_MESSAGE.SET_TOKEN('TABLE',

1718: End If;
1719:
1720: If x_dummy <> 0 Then
1721: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
1722: FND_MESSAGE.SET_TOKEN('TABLE',
1723: 'Resulting Lot:'||crec.lot_number
1724: ||'Table: mtl_transaction_lots_temp ');
1725: o_err_message:= substr(fnd_message.get(), 1, 2000);
1726: err_status := -1;

Line 1725: o_err_message:= substr(fnd_message.get(), 1, 2000);

1721: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
1722: FND_MESSAGE.SET_TOKEN('TABLE',
1723: 'Resulting Lot:'||crec.lot_number
1724: ||'Table: mtl_transaction_lots_temp ');
1725: o_err_message:= substr(fnd_message.get(), 1, 2000);
1726: err_status := -1;
1727: return;
1728:
1729: END IF;

Line 1751: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');

1747: FROM mtl_transaction_lots_temp
1748: WHERE lot_number=crec.lot_number;
1749:
1750: IF x_cnt1<>0 THEN
1751: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
1752: FND_MESSAGE.SET_TOKEN('TABLE',
1753: 'Resulting Lot:'||crec.lot_number
1754: ||'Table: mtl_transaction_lots_temp ');
1755: o_err_message:= substr(fnd_message.get(), 1, 2000);

Line 1752: FND_MESSAGE.SET_TOKEN('TABLE',

1748: WHERE lot_number=crec.lot_number;
1749:
1750: IF x_cnt1<>0 THEN
1751: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
1752: FND_MESSAGE.SET_TOKEN('TABLE',
1753: 'Resulting Lot:'||crec.lot_number
1754: ||'Table: mtl_transaction_lots_temp ');
1755: o_err_message:= substr(fnd_message.get(), 1, 2000);
1756: err_status := -1;

Line 1755: o_err_message:= substr(fnd_message.get(), 1, 2000);

1751: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
1752: FND_MESSAGE.SET_TOKEN('TABLE',
1753: 'Resulting Lot:'||crec.lot_number
1754: ||'Table: mtl_transaction_lots_temp ');
1755: o_err_message:= substr(fnd_message.get(), 1, 2000);
1756: err_status := -1;
1757: showProgress(
1758: processingMode => CONCURRENT
1759: , headerId => p_header_id

Line 1790: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

1786: WHERE user_id = crec.last_updated_by
1787: AND sysdate between start_date
1788: and nvl(END_date, sysdate + 1);
1789: EXCEPTION when others THEN
1790: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1791: FND_MESSAGE.SET_TOKEN('FLD_NAME','last_updated_by in Resulting Lots');
1792: o_err_message:= fnd_message.get;
1793: err_status := -1;
1794: return;

Line 1791: FND_MESSAGE.SET_TOKEN('FLD_NAME','last_updated_by in Resulting Lots');

1787: AND sysdate between start_date
1788: and nvl(END_date, sysdate + 1);
1789: EXCEPTION when others THEN
1790: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1791: FND_MESSAGE.SET_TOKEN('FLD_NAME','last_updated_by in Resulting Lots');
1792: o_err_message:= fnd_message.get;
1793: err_status := -1;
1794: return;
1795: END;

Line 1792: o_err_message:= fnd_message.get;

1788: and nvl(END_date, sysdate + 1);
1789: EXCEPTION when others THEN
1790: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
1791: FND_MESSAGE.SET_TOKEN('FLD_NAME','last_updated_by in Resulting Lots');
1792: o_err_message:= fnd_message.get;
1793: err_status := -1;
1794: return;
1795: END;
1796:

Line 1807: fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');

1803: FROM wsm_lot_split_merges_interface
1804: WHERE header_id = p_header_id
1805: AND organization_id = crec.organization_id;
1806: EXCEPTION when others THEN
1807: fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');
1808: FND_MESSAGE.SET_TOKEN('FLD_NAME','Resulting Lot.organization_id');
1809: o_err_message:= fnd_message.get;
1810: err_status := -1;
1811: return;

Line 1808: FND_MESSAGE.SET_TOKEN('FLD_NAME','Resulting Lot.organization_id');

1804: WHERE header_id = p_header_id
1805: AND organization_id = crec.organization_id;
1806: EXCEPTION when others THEN
1807: fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');
1808: FND_MESSAGE.SET_TOKEN('FLD_NAME','Resulting Lot.organization_id');
1809: o_err_message:= fnd_message.get;
1810: err_status := -1;
1811: return;
1812: END;

Line 1809: o_err_message:= fnd_message.get;

1805: AND organization_id = crec.organization_id;
1806: EXCEPTION when others THEN
1807: fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');
1808: FND_MESSAGE.SET_TOKEN('FLD_NAME','Resulting Lot.organization_id');
1809: o_err_message:= fnd_message.get;
1810: err_status := -1;
1811: return;
1812: END;
1813:

Line 1818: fnd_message.set_name('WSM', 'WSM_QUANTITY_GREATER_THAN_ZERO');

1814: -- check if the Resulting quantity is Non-Zero.
1815: lprocLocation := 60;
1816:
1817: IF crec.quantity <= 0 THEN
1818: fnd_message.set_name('WSM', 'WSM_QUANTITY_GREATER_THAN_ZERO');
1819: o_err_message:= fnd_message.get;
1820: err_status := -1;
1821: return;
1822: END IF;

Line 1819: o_err_message:= fnd_message.get;

1815: lprocLocation := 60;
1816:
1817: IF crec.quantity <= 0 THEN
1818: fnd_message.set_name('WSM', 'WSM_QUANTITY_GREATER_THAN_ZERO');
1819: o_err_message:= fnd_message.get;
1820: err_status := -1;
1821: return;
1822: END IF;
1823:

Line 1844: ** fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');

1840: ** and s.lot_number = crec.lot_number);
1841: ** EXCEPTION
1842: **
1843: ** when others THEN
1844: ** fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');
1845: ** FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number');
1846: ** o_err_message:= fnd_message.get;
1847: ** err_status := -1;
1848: ** return;

Line 1845: ** FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number');

1841: ** EXCEPTION
1842: **
1843: ** when others THEN
1844: ** fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');
1845: ** FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number');
1846: ** o_err_message:= fnd_message.get;
1847: ** err_status := -1;
1848: ** return;
1849: **

Line 1846: ** o_err_message:= fnd_message.get;

1842: **
1843: ** when others THEN
1844: ** fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');
1845: ** FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number');
1846: ** o_err_message:= fnd_message.get;
1847: ** err_status := -1;
1848: ** return;
1849: **
1850: ** END;

Line 1875: fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');

1871:
1872: EXCEPTION
1873:
1874: when wsm_resulting_same_error THEN
1875: fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');
1876: FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number');
1877: o_err_message:= fnd_message.get;
1878: err_status := -1;
1879: return;

Line 1876: FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number');

1872: EXCEPTION
1873:
1874: when wsm_resulting_same_error THEN
1875: fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');
1876: FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number');
1877: o_err_message:= fnd_message.get;
1878: err_status := -1;
1879: return;
1880:

Line 1877: o_err_message:= fnd_message.get;

1873:
1874: when wsm_resulting_same_error THEN
1875: fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');
1876: FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number');
1877: o_err_message:= fnd_message.get;
1878: err_status := -1;
1879: return;
1880:
1881:

Line 1883: fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');

1879: return;
1880:
1881:
1882: when too_many_rows THEN
1883: fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');
1884: FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number');
1885: o_err_message:= fnd_message.get;
1886: err_status := -1;
1887: return;

Line 1884: FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number');

1880:
1881:
1882: when too_many_rows THEN
1883: fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');
1884: FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number');
1885: o_err_message:= fnd_message.get;
1886: err_status := -1;
1887: return;
1888:

Line 1885: o_err_message:= fnd_message.get;

1881:
1882: when too_many_rows THEN
1883: fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');
1884: FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number');
1885: o_err_message:= fnd_message.get;
1886: err_status := -1;
1887: return;
1888:
1889:

Line 1925: ** fnd_message.set_name('WSM', 'WSM_VALIDATE_LOT_DUP');

1921: ** FROM mtl_lot_numbers
1922: ** WHERE lot_number = crec.lot_number
1923: ** );
1924: ** EXCEPTION when others THEN
1925: ** fnd_message.set_name('WSM', 'WSM_VALIDATE_LOT_DUP');
1926: ** o_err_message:= fnd_message.get;
1927: ** err_status := -1;
1928: ** return;
1929: **

Line 1926: ** o_err_message:= fnd_message.get;

1922: ** WHERE lot_number = crec.lot_number
1923: ** );
1924: ** EXCEPTION when others THEN
1925: ** fnd_message.set_name('WSM', 'WSM_VALIDATE_LOT_DUP');
1926: ** o_err_message:= fnd_message.get;
1927: ** err_status := -1;
1928: ** return;
1929: **
1930: */

Line 1962: fnd_message.set_name('WSM', 'WSM_VALIDATE_LOT_DUP');

1958: EXCEPTION
1959:
1960:
1961: when validate_lot_dup_error THEN
1962: fnd_message.set_name('WSM', 'WSM_VALIDATE_LOT_DUP');
1963: o_err_message:= fnd_message.get;
1964: err_status := -1;
1965: return;
1966:

Line 1963: o_err_message:= fnd_message.get;

1959:
1960:
1961: when validate_lot_dup_error THEN
1962: fnd_message.set_name('WSM', 'WSM_VALIDATE_LOT_DUP');
1963: o_err_message:= fnd_message.get;
1964: err_status := -1;
1965: return;
1966:
1967:

Line 1970: fnd_message.set_name('WSM', 'WSM_VALIDATE_LOT_DUP');

1966:
1967:
1968:
1969: when too_many_rows THEN
1970: fnd_message.set_name('WSM', 'WSM_VALIDATE_LOT_DUP');
1971: o_err_message:= fnd_message.get;
1972: err_status := -1;
1973: return;
1974:

Line 1971: o_err_message:= fnd_message.get;

1967:
1968:
1969: when too_many_rows THEN
1970: fnd_message.set_name('WSM', 'WSM_VALIDATE_LOT_DUP');
1971: o_err_message:= fnd_message.get;
1972: err_status := -1;
1973: return;
1974:
1975:

Line 2010: fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');

2006: and lot_number = crec.lot_number;
2007:
2008:
2009: EXCEPTION when others THEN
2010: fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');
2011: FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number');
2012: o_err_message:= fnd_message.get;
2013: err_status := -1;
2014: return;

Line 2011: FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number');

2007:
2008:
2009: EXCEPTION when others THEN
2010: fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');
2011: FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number');
2012: o_err_message:= fnd_message.get;
2013: err_status := -1;
2014: return;
2015:

Line 2012: o_err_message:= fnd_message.get;

2008:
2009: EXCEPTION when others THEN
2010: fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');
2011: FND_MESSAGE.SET_TOKEN('FLD_NAME','lot_number');
2012: o_err_message:= fnd_message.get;
2013: err_status := -1;
2014: return;
2015:
2016: END;

Line 2038: fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');

2034: and lot_number = crec.lot_number
2035: and inventory_item_id = crec.inventory_item_id; --Bug#1844972
2036:
2037: IF (x_dummy = crec.inventory_item_id )then
2038: fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');
2039: FND_MESSAGE.SET_TOKEN('FLD_NAME','Both LotNumber and Assembly ');
2040: o_err_message:= fnd_message.get;
2041: err_status := -1;
2042: return;

Line 2039: FND_MESSAGE.SET_TOKEN('FLD_NAME','Both LotNumber and Assembly ');

2035: and inventory_item_id = crec.inventory_item_id; --Bug#1844972
2036:
2037: IF (x_dummy = crec.inventory_item_id )then
2038: fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');
2039: FND_MESSAGE.SET_TOKEN('FLD_NAME','Both LotNumber and Assembly ');
2040: o_err_message:= fnd_message.get;
2041: err_status := -1;
2042: return;
2043: END IF ;

Line 2040: o_err_message:= fnd_message.get;

2036:
2037: IF (x_dummy = crec.inventory_item_id )then
2038: fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');
2039: FND_MESSAGE.SET_TOKEN('FLD_NAME','Both LotNumber and Assembly ');
2040: o_err_message:= fnd_message.get;
2041: err_status := -1;
2042: return;
2043: END IF ;
2044:

Line 2072: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

2068: and mtl_transactions_enabled_flag = 'Y'
2069: and lot_control_code=2
2070: and inventory_item_flag = 'Y';
2071: EXCEPTION when others THEN
2072: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2073: FND_MESSAGE.SET_TOKEN('FLD_NAME','inventory_item_id in Resulting Lots');
2074: o_err_message:= fnd_message.get;
2075: err_status := -1;
2076: return;

Line 2073: FND_MESSAGE.SET_TOKEN('FLD_NAME','inventory_item_id in Resulting Lots');

2069: and lot_control_code=2
2070: and inventory_item_flag = 'Y';
2071: EXCEPTION when others THEN
2072: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2073: FND_MESSAGE.SET_TOKEN('FLD_NAME','inventory_item_id in Resulting Lots');
2074: o_err_message:= fnd_message.get;
2075: err_status := -1;
2076: return;
2077:

Line 2074: o_err_message:= fnd_message.get;

2070: and inventory_item_flag = 'Y';
2071: EXCEPTION when others THEN
2072: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2073: FND_MESSAGE.SET_TOKEN('FLD_NAME','inventory_item_id in Resulting Lots');
2074: o_err_message:= fnd_message.get;
2075: err_status := -1;
2076: return;
2077:
2078:

Line 2096: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

2092: ((crec.revision is null or
2093: crec.revision = '0')
2094: and revision_qty_control_code = 1));
2095: EXCEPTION when others THEN
2096: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2097: FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Resulting Lots');
2098: o_err_message:= fnd_message.get;
2099: err_status := -1;
2100:

Line 2097: FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Resulting Lots');

2093: crec.revision = '0')
2094: and revision_qty_control_code = 1));
2095: EXCEPTION when others THEN
2096: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2097: FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Resulting Lots');
2098: o_err_message:= fnd_message.get;
2099: err_status := -1;
2100:
2101: END;

Line 2098: o_err_message:= fnd_message.get;

2094: and revision_qty_control_code = 1));
2095: EXCEPTION when others THEN
2096: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2097: FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Resulting Lots');
2098: o_err_message:= fnd_message.get;
2099: err_status := -1;
2100:
2101: END;
2102:

Line 2123: ** fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

2119: ** and inventory_item_id = crec.inventory_item_id
2120: ** and organization_id = crec.organization_id
2121: ** and nvl(revision,'@@@') = nvl(crec.revision,'@@@'));
2122: ** EXCEPTION when others THEN
2123: ** fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2124: ** FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Resulting Lots');
2125: ** o_err_message:= fnd_message.get;
2126: ** err_status := -1;
2127: ** return;

Line 2124: ** FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Resulting Lots');

2120: ** and organization_id = crec.organization_id
2121: ** and nvl(revision,'@@@') = nvl(crec.revision,'@@@'));
2122: ** EXCEPTION when others THEN
2123: ** fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2124: ** FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Resulting Lots');
2125: ** o_err_message:= fnd_message.get;
2126: ** err_status := -1;
2127: ** return;
2128: **

Line 2125: ** o_err_message:= fnd_message.get;

2121: ** and nvl(revision,'@@@') = nvl(crec.revision,'@@@'));
2122: ** EXCEPTION when others THEN
2123: ** fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2124: ** FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Resulting Lots');
2125: ** o_err_message:= fnd_message.get;
2126: ** err_status := -1;
2127: ** return;
2128: **
2129: ** END;

Line 2151: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

2147: NULL;
2148:
2149:
2150: when others THEN
2151: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2152: FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Resulting Lots');
2153: o_err_message:= fnd_message.get;
2154: err_status := -1;
2155: return;

Line 2152: FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Resulting Lots');

2148:
2149:
2150: when others THEN
2151: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2152: FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Resulting Lots');
2153: o_err_message:= fnd_message.get;
2154: err_status := -1;
2155: return;
2156:

Line 2153: o_err_message:= fnd_message.get;

2149:
2150: when others THEN
2151: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2152: FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Resulting Lots');
2153: o_err_message:= fnd_message.get;
2154: err_status := -1;
2155: return;
2156:
2157: END;

Line 2175: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

2171: WHERE inventory_item_id = crec.inventory_item_id
2172: and organization_id = crec.organization_id
2173: and revision = crec.revision;
2174: EXCEPTION when others THEN
2175: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2176: FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Resulting Lots');
2177: o_err_message:= fnd_message.get;
2178: err_status := -1;
2179: return;

Line 2176: FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Resulting Lots');

2172: and organization_id = crec.organization_id
2173: and revision = crec.revision;
2174: EXCEPTION when others THEN
2175: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2176: FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Resulting Lots');
2177: o_err_message:= fnd_message.get;
2178: err_status := -1;
2179: return;
2180:

Line 2177: o_err_message:= fnd_message.get;

2173: and revision = crec.revision;
2174: EXCEPTION when others THEN
2175: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2176: FND_MESSAGE.SET_TOKEN('FLD_NAME','revision in Resulting Lots');
2177: o_err_message:= fnd_message.get;
2178: err_status := -1;
2179: return;
2180:
2181: END;

Line 2239: ** fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

2235: ** AND MSI.organization_id = crec.organization_id
2236: ** AND MSI.INVENTORY_ASSET_FLAG = 'N');
2237: **
2238: ** EXCEPTION when others THEN
2239: ** fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2240: ** FND_MESSAGE.SET_TOKEN('FLD_NAME','subinventory_code in Resulting Lots');
2241: ** o_err_message:= fnd_message.get;
2242: ** err_status := -1;
2243: ** return;

Line 2240: ** FND_MESSAGE.SET_TOKEN('FLD_NAME','subinventory_code in Resulting Lots');

2236: ** AND MSI.INVENTORY_ASSET_FLAG = 'N');
2237: **
2238: ** EXCEPTION when others THEN
2239: ** fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2240: ** FND_MESSAGE.SET_TOKEN('FLD_NAME','subinventory_code in Resulting Lots');
2241: ** o_err_message:= fnd_message.get;
2242: ** err_status := -1;
2243: ** return;
2244: */

Line 2241: ** o_err_message:= fnd_message.get;

2237: **
2238: ** EXCEPTION when others THEN
2239: ** fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2240: ** FND_MESSAGE.SET_TOKEN('FLD_NAME','subinventory_code in Resulting Lots');
2241: ** o_err_message:= fnd_message.get;
2242: ** err_status := -1;
2243: ** return;
2244: */
2245:

Line 2310: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

2306: when too_many_rows THEN
2307: NULL;
2308:
2309: when others THEN
2310: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2311: FND_MESSAGE.SET_TOKEN('FLD_NAME','subinventory_code in Resulting Lots');
2312: o_err_message:= fnd_message.get;
2313: err_status := -1;
2314: return;

Line 2311: FND_MESSAGE.SET_TOKEN('FLD_NAME','subinventory_code in Resulting Lots');

2307: NULL;
2308:
2309: when others THEN
2310: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2311: FND_MESSAGE.SET_TOKEN('FLD_NAME','subinventory_code in Resulting Lots');
2312: o_err_message:= fnd_message.get;
2313: err_status := -1;
2314: return;
2315:

Line 2312: o_err_message:= fnd_message.get;

2308:
2309: when others THEN
2310: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2311: FND_MESSAGE.SET_TOKEN('FLD_NAME','subinventory_code in Resulting Lots');
2312: o_err_message:= fnd_message.get;
2313: err_status := -1;
2314: return;
2315:
2316:

Line 2347: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

2343: x_loc_id := crec.locator_id;
2344:
2345: Exception
2346: When OThers Then
2347: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2348: FND_MESSAGE.SET_TOKEN('FLD_NAME','subinventory in Resulting Lots');
2349: o_err_message:= fnd_message.get;
2350: err_status := -1;
2351: return;

Line 2348: FND_MESSAGE.SET_TOKEN('FLD_NAME','subinventory in Resulting Lots');

2344:
2345: Exception
2346: When OThers Then
2347: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2348: FND_MESSAGE.SET_TOKEN('FLD_NAME','subinventory in Resulting Lots');
2349: o_err_message:= fnd_message.get;
2350: err_status := -1;
2351: return;
2352:

Line 2349: o_err_message:= fnd_message.get;

2345: Exception
2346: When OThers Then
2347: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2348: FND_MESSAGE.SET_TOKEN('FLD_NAME','subinventory in Resulting Lots');
2349: o_err_message:= fnd_message.get;
2350: err_status := -1;
2351: return;
2352:
2353: End;

Line 2373: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

2369: x_loc_success);
2370:
2371:
2372: IF not x_loc_success THEN
2373: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2374: FND_MESSAGE.SET_TOKEN('FLD_NAME','locator in Resulting Lots');
2375: o_err_message:= fnd_message.get;
2376: err_status := -1;
2377: return;

Line 2374: FND_MESSAGE.SET_TOKEN('FLD_NAME','locator in Resulting Lots');

2370:
2371:
2372: IF not x_loc_success THEN
2373: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2374: FND_MESSAGE.SET_TOKEN('FLD_NAME','locator in Resulting Lots');
2375: o_err_message:= fnd_message.get;
2376: err_status := -1;
2377: return;
2378: END IF;

Line 2375: o_err_message:= fnd_message.get;

2371:
2372: IF not x_loc_success THEN
2373: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2374: FND_MESSAGE.SET_TOKEN('FLD_NAME','locator in Resulting Lots');
2375: o_err_message:= fnd_message.get;
2376: err_status := -1;
2377: return;
2378: END IF;
2379:

Line 2458: fnd_message.set_name('WSM', 'WSM_VALIDATE_LOT_DUP');

2454: and lot_number = crec.lot_number
2455: )
2456: );
2457: EXCEPTION when others THEN
2458: fnd_message.set_name('WSM', 'WSM_VALIDATE_LOT_DUP');
2459: o_err_message:= fnd_message.get;
2460: err_status := -1;
2461: return;
2462: END;

Line 2459: o_err_message:= fnd_message.get;

2455: )
2456: );
2457: EXCEPTION when others THEN
2458: fnd_message.set_name('WSM', 'WSM_VALIDATE_LOT_DUP');
2459: o_err_message:= fnd_message.get;
2460: err_status := -1;
2461: return;
2462: END;
2463:

Line 2478: ** fnd_message.set_name('WSM', 'WSM_CHECK_STLOT_WHILE_MERGE');

2474: ** WHERE header_id = p_header_id
2475: ** group by lot_number
2476: ** having count(*) > 1);
2477: ** EXCEPTION when others THEN
2478: ** fnd_message.set_name('WSM', 'WSM_CHECK_STLOT_WHILE_MERGE');
2479: ** o_err_message:= fnd_message.get;
2480: ** err_status := -1;
2481: ** return;
2482: ** END;

Line 2479: ** o_err_message:= fnd_message.get;

2475: ** group by lot_number
2476: ** having count(*) > 1);
2477: ** EXCEPTION when others THEN
2478: ** fnd_message.set_name('WSM', 'WSM_CHECK_STLOT_WHILE_MERGE');
2479: ** o_err_message:= fnd_message.get;
2480: ** err_status := -1;
2481: ** return;
2482: ** END;
2483: */

Line 2506: fnd_message.set_name('WSM', 'WSM_CHECK_STLOT_WHILE_MERGE');

2502:
2503: EXCEPTION
2504:
2505: when check_stlot_merge_err THEN
2506: fnd_message.set_name('WSM', 'WSM_CHECK_STLOT_WHILE_MERGE');
2507: o_err_message:= fnd_message.get;
2508: err_status := -1;
2509: return;
2510:

Line 2507: o_err_message:= fnd_message.get;

2503: EXCEPTION
2504:
2505: when check_stlot_merge_err THEN
2506: fnd_message.set_name('WSM', 'WSM_CHECK_STLOT_WHILE_MERGE');
2507: o_err_message:= fnd_message.get;
2508: err_status := -1;
2509: return;
2510:
2511:

Line 2513: fnd_message.set_name('WSM', 'WSM_CHECK_STLOT_WHILE_MERGE');

2509: return;
2510:
2511:
2512: when too_many_rows THEN
2513: fnd_message.set_name('WSM', 'WSM_CHECK_STLOT_WHILE_MERGE');
2514: o_err_message:= fnd_message.get;
2515: err_status := -1;
2516: return;
2517:

Line 2514: o_err_message:= fnd_message.get;

2510:
2511:
2512: when too_many_rows THEN
2513: fnd_message.set_name('WSM', 'WSM_CHECK_STLOT_WHILE_MERGE');
2514: o_err_message:= fnd_message.get;
2515: err_status := -1;
2516: return;
2517:
2518:

Line 2552: fnd_message.set_name('WSM', 'WSM_ONE_SLOT');

2548:
2549: -- For Merge Txn, More than one Starting Lot should exist.
2550:
2551: IF x_transaction_type_id= 2 and x_start_ct <= 1 THEN
2552: fnd_message.set_name('WSM', 'WSM_ONE_SLOT');
2553: o_err_message:= fnd_message.get;
2554: err_status := -1;
2555: return;
2556: END IF;

Line 2553: o_err_message:= fnd_message.get;

2549: -- For Merge Txn, More than one Starting Lot should exist.
2550:
2551: IF x_transaction_type_id= 2 and x_start_ct <= 1 THEN
2552: fnd_message.set_name('WSM', 'WSM_ONE_SLOT');
2553: o_err_message:= fnd_message.get;
2554: err_status := -1;
2555: return;
2556: END IF;
2557:

Line 2562: fnd_message.set_name('WSM', 'WSM_ATLEAST_ONE_RSLT_WHIL_SPLIT');

2558: -- For Split Txn, More than one Resulting Lot should exist.
2559: -- Don't know why a Split condition is checked here (Bala).
2560:
2561: IF x_transaction_type_id = 1 and x_result_ct < 1 THEN
2562: fnd_message.set_name('WSM', 'WSM_ATLEAST_ONE_RSLT_WHIL_SPLIT');
2563: o_err_message:= fnd_message.get;
2564: err_status := -1;
2565: return;
2566: END IF;

Line 2563: o_err_message:= fnd_message.get;

2559: -- Don't know why a Split condition is checked here (Bala).
2560:
2561: IF x_transaction_type_id = 1 and x_result_ct < 1 THEN
2562: fnd_message.set_name('WSM', 'WSM_ATLEAST_ONE_RSLT_WHIL_SPLIT');
2563: o_err_message:= fnd_message.get;
2564: err_status := -1;
2565: return;
2566: END IF;
2567:

Line 2600: ** fnd_message.set_name('WSM', 'WSM_INCONSISTENT_SL');

2596: ** )
2597: ** );
2598: **
2599: ** EXCEPTION when others THEN
2600: ** fnd_message.set_name('WSM', 'WSM_INCONSISTENT_SL');
2601: ** o_err_message:= fnd_message.get;
2602: ** err_status := -1;
2603: ** return;
2604: **

Line 2601: ** o_err_message:= fnd_message.get;

2597: ** );
2598: **
2599: ** EXCEPTION when others THEN
2600: ** fnd_message.set_name('WSM', 'WSM_INCONSISTENT_SL');
2601: ** o_err_message:= fnd_message.get;
2602: ** err_status := -1;
2603: ** return;
2604: **
2605: ** END;

Line 2628: fnd_message.set_name('WSM', 'WSM_INCONSISTENT_SL');

2624:
2625: EXCEPTION
2626:
2627: when wsm_inconsitent_sl_error THEN
2628: fnd_message.set_name('WSM', 'WSM_INCONSISTENT_SL');
2629: o_err_message:= fnd_message.get;
2630: err_status := -1;
2631: return;
2632:

Line 2629: o_err_message:= fnd_message.get;

2625: EXCEPTION
2626:
2627: when wsm_inconsitent_sl_error THEN
2628: fnd_message.set_name('WSM', 'WSM_INCONSISTENT_SL');
2629: o_err_message:= fnd_message.get;
2630: err_status := -1;
2631: return;
2632:
2633:

Line 2635: fnd_message.set_name('WSM', 'WSM_INCONSISTENT_SL');

2631: return;
2632:
2633:
2634: when too_many_rows THEN
2635: fnd_message.set_name('WSM', 'WSM_INCONSISTENT_SL');
2636: o_err_message:= fnd_message.get;
2637: err_status := -1;
2638: return;
2639:

Line 2636: o_err_message:= fnd_message.get;

2632:
2633:
2634: when too_many_rows THEN
2635: fnd_message.set_name('WSM', 'WSM_INCONSISTENT_SL');
2636: o_err_message:= fnd_message.get;
2637: err_status := -1;
2638: return;
2639:
2640:

Line 2726: fnd_message.set_name('WSM','WSM_ORG_LOT_NONUNIQUE');

2722: x_org_id
2723: ,x_err_code
2724: ,x_err_msg );
2725: IF (x_return_code=0) then
2726: fnd_message.set_name('WSM','WSM_ORG_LOT_NONUNIQUE');
2727: o_err_message:= fnd_message.get;
2728: err_status := -1;
2729: return;
2730: --fnd_message.error;

Line 2727: o_err_message:= fnd_message.get;

2723: ,x_err_code
2724: ,x_err_msg );
2725: IF (x_return_code=0) then
2726: fnd_message.set_name('WSM','WSM_ORG_LOT_NONUNIQUE');
2727: o_err_message:= fnd_message.get;
2728: err_status := -1;
2729: return;
2730: --fnd_message.error;
2731: END IF;

Line 2730: --fnd_message.error;

2726: fnd_message.set_name('WSM','WSM_ORG_LOT_NONUNIQUE');
2727: o_err_message:= fnd_message.get;
2728: err_status := -1;
2729: return;
2730: --fnd_message.error;
2731: END IF;
2732: END;
2733:
2734:

Line 2759: fnd_message.set_name('WSM','WSM_ORG_WMS_ENABLED');

2755: WHERE mtl.organization_id = x_organization_id;
2756:
2757:
2758: IF (l_wmsEnabledFlag = 'Y') THEN
2759: fnd_message.set_name('WSM','WSM_ORG_WMS_ENABLED');
2760: o_err_message:= fnd_message.get;
2761: err_status := -1;
2762: return;
2763: --fnd_message.error;

Line 2760: o_err_message:= fnd_message.get;

2756:
2757:
2758: IF (l_wmsEnabledFlag = 'Y') THEN
2759: fnd_message.set_name('WSM','WSM_ORG_WMS_ENABLED');
2760: o_err_message:= fnd_message.get;
2761: err_status := -1;
2762: return;
2763: --fnd_message.error;
2764: END IF;

Line 2763: --fnd_message.error;

2759: fnd_message.set_name('WSM','WSM_ORG_WMS_ENABLED');
2760: o_err_message:= fnd_message.get;
2761: err_status := -1;
2762: return;
2763: --fnd_message.error;
2764: END IF;
2765: END;
2766:
2767:

Line 2786: fnd_message.set_name('WSM','WSM_INV_TXN_DISABLED');

2782: WHERE wp.organization_id = x_organization_id;
2783:
2784:
2785: IF (nvl(l_invTxnEnabledFlag,0) = 0) THEN
2786: fnd_message.set_name('WSM','WSM_INV_TXN_DISABLED');
2787: o_err_message:= fnd_message.get;
2788: err_status := -1;
2789: return;
2790: --fnd_message.error;

Line 2787: o_err_message:= fnd_message.get;

2783:
2784:
2785: IF (nvl(l_invTxnEnabledFlag,0) = 0) THEN
2786: fnd_message.set_name('WSM','WSM_INV_TXN_DISABLED');
2787: o_err_message:= fnd_message.get;
2788: err_status := -1;
2789: return;
2790: --fnd_message.error;
2791: END IF;

Line 2790: --fnd_message.error;

2786: fnd_message.set_name('WSM','WSM_INV_TXN_DISABLED');
2787: o_err_message:= fnd_message.get;
2788: err_status := -1;
2789: return;
2790: --fnd_message.error;
2791: END IF;
2792: END;
2793:
2794:

Line 2810: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

2806: WHERE user_id = x_created_by
2807: AND sysdate between start_date
2808: and nvl(END_date, sysdate + 1);
2809: EXCEPTION when others THEN
2810: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2811: FND_MESSAGE.SET_TOKEN('FLD_NAME','created_by');
2812: o_err_message:= fnd_message.get;
2813: err_status := -1;
2814: return;

Line 2811: FND_MESSAGE.SET_TOKEN('FLD_NAME','created_by');

2807: AND sysdate between start_date
2808: and nvl(END_date, sysdate + 1);
2809: EXCEPTION when others THEN
2810: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2811: FND_MESSAGE.SET_TOKEN('FLD_NAME','created_by');
2812: o_err_message:= fnd_message.get;
2813: err_status := -1;
2814: return;
2815: END;

Line 2812: o_err_message:= fnd_message.get;

2808: and nvl(END_date, sysdate + 1);
2809: EXCEPTION when others THEN
2810: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2811: FND_MESSAGE.SET_TOKEN('FLD_NAME','created_by');
2812: o_err_message:= fnd_message.get;
2813: err_status := -1;
2814: return;
2815: END;
2816: -- check if the last_updated_by is a valid user.

Line 2827: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

2823: WHERE user_id = x_last_updated_by
2824: AND sysdate between start_date
2825: and nvl(END_date, sysdate + 1);
2826: EXCEPTION when others THEN
2827: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2828: FND_MESSAGE.SET_TOKEN('FLD_NAME','last_updated_by');
2829: o_err_message:= fnd_message.get;
2830: err_status := -1;
2831: return;

Line 2828: FND_MESSAGE.SET_TOKEN('FLD_NAME','last_updated_by');

2824: AND sysdate between start_date
2825: and nvl(END_date, sysdate + 1);
2826: EXCEPTION when others THEN
2827: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2828: FND_MESSAGE.SET_TOKEN('FLD_NAME','last_updated_by');
2829: o_err_message:= fnd_message.get;
2830: err_status := -1;
2831: return;
2832: END;

Line 2829: o_err_message:= fnd_message.get;

2825: and nvl(END_date, sysdate + 1);
2826: EXCEPTION when others THEN
2827: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2828: FND_MESSAGE.SET_TOKEN('FLD_NAME','last_updated_by');
2829: o_err_message:= fnd_message.get;
2830: err_status := -1;
2831: return;
2832: END;
2833: /*

Line 2864: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

2860: WHERE organization_id = x_organization_id
2861: and trunc(sysdate) <= nvl(date_to, sysdate + 1);
2862: --bug 5051883
2863: EXCEPTION when others THEN
2864: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2865: FND_MESSAGE.SET_TOKEN('FLD_NAME',
2866: 'organization_id in Header in org.definitions');
2867: o_err_message:= fnd_message.get;
2868: err_status := -1;

Line 2865: FND_MESSAGE.SET_TOKEN('FLD_NAME',

2861: and trunc(sysdate) <= nvl(date_to, sysdate + 1);
2862: --bug 5051883
2863: EXCEPTION when others THEN
2864: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2865: FND_MESSAGE.SET_TOKEN('FLD_NAME',
2866: 'organization_id in Header in org.definitions');
2867: o_err_message:= fnd_message.get;
2868: err_status := -1;
2869: return;

Line 2867: o_err_message:= fnd_message.get;

2863: EXCEPTION when others THEN
2864: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2865: FND_MESSAGE.SET_TOKEN('FLD_NAME',
2866: 'organization_id in Header in org.definitions');
2867: o_err_message:= fnd_message.get;
2868: err_status := -1;
2869: return;
2870: END;
2871:

Line 2881: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

2877: into x_dummy
2878: FROM mtl_parameters
2879: WHERE organization_id = x_organization_id;
2880: EXCEPTION when others THEN
2881: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2882: FND_MESSAGE.SET_TOKEN('FLD_NAME','organization_id_mp');
2883: o_err_message:= fnd_message.get;
2884: err_status := -1;
2885: return;

Line 2882: FND_MESSAGE.SET_TOKEN('FLD_NAME','organization_id_mp');

2878: FROM mtl_parameters
2879: WHERE organization_id = x_organization_id;
2880: EXCEPTION when others THEN
2881: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2882: FND_MESSAGE.SET_TOKEN('FLD_NAME','organization_id_mp');
2883: o_err_message:= fnd_message.get;
2884: err_status := -1;
2885: return;
2886: END;

Line 2883: o_err_message:= fnd_message.get;

2879: WHERE organization_id = x_organization_id;
2880: EXCEPTION when others THEN
2881: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2882: FND_MESSAGE.SET_TOKEN('FLD_NAME','organization_id_mp');
2883: o_err_message:= fnd_message.get;
2884: err_status := -1;
2885: return;
2886: END;
2887:

Line 2898: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

2894: into x_dummy
2895: FROM mtl_transaction_reasons_val_v
2896: WHERE reason_id = x_reason_id;
2897: EXCEPTION when others THEN
2898: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2899: FND_MESSAGE.SET_TOKEN('FLD_NAME','reason_id');
2900: o_err_message:= fnd_message.get;
2901: err_status := -1;
2902: return;

Line 2899: FND_MESSAGE.SET_TOKEN('FLD_NAME','reason_id');

2895: FROM mtl_transaction_reasons_val_v
2896: WHERE reason_id = x_reason_id;
2897: EXCEPTION when others THEN
2898: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2899: FND_MESSAGE.SET_TOKEN('FLD_NAME','reason_id');
2900: o_err_message:= fnd_message.get;
2901: err_status := -1;
2902: return;
2903: END;

Line 2900: o_err_message:= fnd_message.get;

2896: WHERE reason_id = x_reason_id;
2897: EXCEPTION when others THEN
2898: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2899: FND_MESSAGE.SET_TOKEN('FLD_NAME','reason_id');
2900: o_err_message:= fnd_message.get;
2901: err_status := -1;
2902: return;
2903: END;
2904: END IF;

Line 2923: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

2919: FROM mfg_lookups
2920: WHERE lookup_type = 'WSM_INV_LOT_TXN_TYPE'
2921: and lookup_code = x_transaction_type_id;
2922: EXCEPTION when others THEN
2923: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2924: FND_MESSAGE.SET_TOKEN('FLD_NAME','transaction_type_id in Header.');
2925: o_err_message:= fnd_message.get;
2926: err_status := -1;
2927: return;

Line 2924: FND_MESSAGE.SET_TOKEN('FLD_NAME','transaction_type_id in Header.');

2920: WHERE lookup_type = 'WSM_INV_LOT_TXN_TYPE'
2921: and lookup_code = x_transaction_type_id;
2922: EXCEPTION when others THEN
2923: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2924: FND_MESSAGE.SET_TOKEN('FLD_NAME','transaction_type_id in Header.');
2925: o_err_message:= fnd_message.get;
2926: err_status := -1;
2927: return;
2928: END;

Line 2925: o_err_message:= fnd_message.get;

2921: and lookup_code = x_transaction_type_id;
2922: EXCEPTION when others THEN
2923: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2924: FND_MESSAGE.SET_TOKEN('FLD_NAME','transaction_type_id in Header.');
2925: o_err_message:= fnd_message.get;
2926: err_status := -1;
2927: return;
2928: END;
2929:

Line 2952: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

2948: p_organization_id => x_organization_id,
2949: p_date => x_transaction_date);
2950:
2951: IF (x_err_code <> 0) THEN
2952: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2953: FND_MESSAGE.SET_TOKEN('FLD_NAME','transaction_date in Header');
2954: o_err_message:= fnd_message.get;
2955: err_status := -1;
2956: return;

Line 2953: FND_MESSAGE.SET_TOKEN('FLD_NAME','transaction_date in Header');

2949: p_date => x_transaction_date);
2950:
2951: IF (x_err_code <> 0) THEN
2952: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2953: FND_MESSAGE.SET_TOKEN('FLD_NAME','transaction_date in Header');
2954: o_err_message:= fnd_message.get;
2955: err_status := -1;
2956: return;
2957: END IF;

Line 2954: o_err_message:= fnd_message.get;

2950:
2951: IF (x_err_code <> 0) THEN
2952: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
2953: FND_MESSAGE.SET_TOKEN('FLD_NAME','transaction_date in Header');
2954: o_err_message:= fnd_message.get;
2955: err_status := -1;
2956: return;
2957: END IF;
2958: -- END;

Line 2983: fnd_message.set_name('WSM', 'WSM_MULTIPLE_SLOTS');

2979: -- Check to see if the is a split txn then there should be only
2980: -- only one starting lot. BBK.
2981:
2982: IF x_transaction_type_id = 1 and x_start_ct <> 1 THEN
2983: fnd_message.set_name('WSM', 'WSM_MULTIPLE_SLOTS');
2984: o_err_message:= fnd_message.get;
2985: err_status := -1;
2986: return;
2987: END IF;

Line 2984: o_err_message:= fnd_message.get;

2980: -- only one starting lot. BBK.
2981:
2982: IF x_transaction_type_id = 1 and x_start_ct <> 1 THEN
2983: fnd_message.set_name('WSM', 'WSM_MULTIPLE_SLOTS');
2984: o_err_message:= fnd_message.get;
2985: err_status := -1;
2986: return;
2987: END IF;
2988:

Line 2994: fnd_message.set_name('WSM', 'WSM_ONE_RLOT');

2990: -- we must check number of resulting lot for split transaction.
2991: -- replace message name WSM_MORETHAN_ONE_RESLOT_SPLIT with WSM_ONE_RLOT
2992: -- as previous one does not exists anymore.
2993: IF x_transaction_type_id = 1 and x_result_ct < 1 THEN
2994: fnd_message.set_name('WSM', 'WSM_ONE_RLOT');
2995: o_err_message:= fnd_message.get;
2996: err_status := -1;
2997: return;
2998: END IF;

Line 2995: o_err_message:= fnd_message.get;

2991: -- replace message name WSM_MORETHAN_ONE_RESLOT_SPLIT with WSM_ONE_RLOT
2992: -- as previous one does not exists anymore.
2993: IF x_transaction_type_id = 1 and x_result_ct < 1 THEN
2994: fnd_message.set_name('WSM', 'WSM_ONE_RLOT');
2995: o_err_message:= fnd_message.get;
2996: err_status := -1;
2997: return;
2998: END IF;
2999:

Line 3004: fnd_message.set_name('WSM', 'WSM_MULTIPLE_SLOTS');

3000: -- Check to see if this is a XFR txn then there should be only
3001: -- only one starting lot and a resulting lot.
3002:
3003: IF x_transaction_type_id = 4 and x_start_ct <> 1 THEN
3004: fnd_message.set_name('WSM', 'WSM_MULTIPLE_SLOTS');
3005: o_err_message:= fnd_message.get;
3006: err_status := -1;
3007: return;
3008: END IF;

Line 3005: o_err_message:= fnd_message.get;

3001: -- only one starting lot and a resulting lot.
3002:
3003: IF x_transaction_type_id = 4 and x_start_ct <> 1 THEN
3004: fnd_message.set_name('WSM', 'WSM_MULTIPLE_SLOTS');
3005: o_err_message:= fnd_message.get;
3006: err_status := -1;
3007: return;
3008: END IF;
3009:

Line 3011: fnd_message.set_name('WSM', 'WSM_MULTIPLE_RLOTS');

3007: return;
3008: END IF;
3009:
3010: IF x_transaction_type_id = 4 and x_result_ct <> 1 THEN
3011: fnd_message.set_name('WSM', 'WSM_MULTIPLE_RLOTS');
3012: o_err_message:= fnd_message.get;
3013: err_status := -1;
3014: return;
3015: END IF;

Line 3012: o_err_message:= fnd_message.get;

3008: END IF;
3009:
3010: IF x_transaction_type_id = 4 and x_result_ct <> 1 THEN
3011: fnd_message.set_name('WSM', 'WSM_MULTIPLE_RLOTS');
3012: o_err_message:= fnd_message.get;
3013: err_status := -1;
3014: return;
3015: END IF;
3016:

Line 3021: fnd_message.set_name('WSM', 'WSM_MULTIPLE_SLOTS');

3017: -- Check to see if this is a TRANSLATE txn then there should be only
3018: -- only one starting lot and a resulting lot.
3019:
3020: IF x_transaction_type_id = 3 and x_start_ct <> 1 THEN
3021: fnd_message.set_name('WSM', 'WSM_MULTIPLE_SLOTS');
3022: o_err_message:= fnd_message.get;
3023: err_status := -1;
3024: return;
3025: END IF;

Line 3022: o_err_message:= fnd_message.get;

3018: -- only one starting lot and a resulting lot.
3019:
3020: IF x_transaction_type_id = 3 and x_start_ct <> 1 THEN
3021: fnd_message.set_name('WSM', 'WSM_MULTIPLE_SLOTS');
3022: o_err_message:= fnd_message.get;
3023: err_status := -1;
3024: return;
3025: END IF;
3026:

Line 3028: fnd_message.set_name('WSM', 'WSM_MULTIPLE_RLOTS');

3024: return;
3025: END IF;
3026:
3027: IF x_transaction_type_id = 3 and x_result_ct <> 1 THEN
3028: fnd_message.set_name('WSM', 'WSM_MULTIPLE_RLOTS');
3029: o_err_message:= fnd_message.get;
3030: err_status := -1;
3031: return;
3032: END IF;

Line 3029: o_err_message:= fnd_message.get;

3025: END IF;
3026:
3027: IF x_transaction_type_id = 3 and x_result_ct <> 1 THEN
3028: fnd_message.set_name('WSM', 'WSM_MULTIPLE_RLOTS');
3029: o_err_message:= fnd_message.get;
3030: err_status := -1;
3031: return;
3032: END IF;
3033:

Line 3039: fnd_message.set_name('WSM', 'WSM_MULTIPLE_RLOTS');

3035: -- only one resulting lot and morethan on Starting Lot.
3036:
3037:
3038: IF x_transaction_type_id = 2 and x_result_ct <> 1 THEN
3039: fnd_message.set_name('WSM', 'WSM_MULTIPLE_RLOTS');
3040: o_err_message:= fnd_message.get;
3041: err_status := -1;
3042: return;
3043: END IF;

Line 3040: o_err_message:= fnd_message.get;

3036:
3037:
3038: IF x_transaction_type_id = 2 and x_result_ct <> 1 THEN
3039: fnd_message.set_name('WSM', 'WSM_MULTIPLE_RLOTS');
3040: o_err_message:= fnd_message.get;
3041: err_status := -1;
3042: return;
3043: END IF;
3044:

Line 3046: fnd_message.set_name('WSM', 'WSM_ONE_SLOT');

3042: return;
3043: END IF;
3044:
3045: IF x_transaction_type_id = 2 and x_start_ct <= 1 THEN
3046: fnd_message.set_name('WSM', 'WSM_ONE_SLOT');
3047: o_err_message:= fnd_message.get;
3048: err_status := -1;
3049: return;
3050: END IF;

Line 3047: o_err_message:= fnd_message.get;

3043: END IF;
3044:
3045: IF x_transaction_type_id = 2 and x_start_ct <= 1 THEN
3046: fnd_message.set_name('WSM', 'WSM_ONE_SLOT');
3047: o_err_message:= fnd_message.get;
3048: err_status := -1;
3049: return;
3050: END IF;
3051:

Line 3070: fnd_message.set_name('WSM', 'WSM_RL_QUANTITY_SUM');

3066: -- Check to see if this is a SPLIT txn then
3067: -- StartQty should be GREATER than sumOfResultantQty
3068:
3069: IF x_transaction_type_id = 1 and x_start_ct1 < x_result_ct1 THEN
3070: fnd_message.set_name('WSM', 'WSM_RL_QUANTITY_SUM');
3071: o_err_message:= fnd_message.get;
3072: err_status := -1;
3073: return;
3074: END IF;

Line 3071: o_err_message:= fnd_message.get;

3067: -- StartQty should be GREATER than sumOfResultantQty
3068:
3069: IF x_transaction_type_id = 1 and x_start_ct1 < x_result_ct1 THEN
3070: fnd_message.set_name('WSM', 'WSM_RL_QUANTITY_SUM');
3071: o_err_message:= fnd_message.get;
3072: err_status := -1;
3073: return;
3074: END IF;
3075:

Line 3083: fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');

3079: IF x_transaction_type_id = 1 -- Split Txn.
3080: and x_start_ct1 = x_result_ct1 -- StartQty = SumResultingQty
3081: and x_result_ct=1 -- Only on Resulting Lot
3082: THEN
3083: fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');
3084: FND_MESSAGE.SET_TOKEN('FLD_NAME','quantity');
3085: o_err_message:= fnd_message.get;
3086: err_status := -1;
3087: return;

Line 3084: FND_MESSAGE.SET_TOKEN('FLD_NAME','quantity');

3080: and x_start_ct1 = x_result_ct1 -- StartQty = SumResultingQty
3081: and x_result_ct=1 -- Only on Resulting Lot
3082: THEN
3083: fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');
3084: FND_MESSAGE.SET_TOKEN('FLD_NAME','quantity');
3085: o_err_message:= fnd_message.get;
3086: err_status := -1;
3087: return;
3088: END IF;

Line 3085: o_err_message:= fnd_message.get;

3081: and x_result_ct=1 -- Only on Resulting Lot
3082: THEN
3083: fnd_message.set_name('WSM', 'WSM_RESULTING_SAME');
3084: FND_MESSAGE.SET_TOKEN('FLD_NAME','quantity');
3085: o_err_message:= fnd_message.get;
3086: err_status := -1;
3087: return;
3088: END IF;
3089:

Line 3095: fnd_message.set_name('WSM', 'WSM_RL_QUANTITY_SUM');

3091: -- and StartQty DOES NOT equal sumOfResultantQty, then also error.
3092:
3093:
3094: IF x_transaction_type_id <> 1 and x_start_ct1 <> x_result_ct1 THEN
3095: fnd_message.set_name('WSM', 'WSM_RL_QUANTITY_SUM');
3096: o_err_message:= fnd_message.get;
3097: err_status := -1;
3098: return;
3099: END IF;

Line 3096: o_err_message:= fnd_message.get;

3092:
3093:
3094: IF x_transaction_type_id <> 1 and x_start_ct1 <> x_result_ct1 THEN
3095: fnd_message.set_name('WSM', 'WSM_RL_QUANTITY_SUM');
3096: o_err_message:= fnd_message.get;
3097: err_status := -1;
3098: return;
3099: END IF;
3100:

Line 3190: fnd_message.set_name('WSM', 'WSM_QUANTITY_REMAINING');

3186:
3187: IF x_result < x_start THEN
3188: l_stmt_num :=23;
3189:
3190: fnd_message.set_name('WSM', 'WSM_QUANTITY_REMAINING');
3191: l_stmt_num :=24;
3192: x_err_msg:= substr(fnd_message.get, 1, 200);
3193: x_err_code := -10;
3194:

Line 3192: x_err_msg:= substr(fnd_message.get, 1, 200);

3188: l_stmt_num :=23;
3189:
3190: fnd_message.set_name('WSM', 'WSM_QUANTITY_REMAINING');
3191: l_stmt_num :=24;
3192: x_err_msg:= substr(fnd_message.get, 1, 200);
3193: x_err_code := -10;
3194:
3195: l_stmt_num :=30;
3196: INSERT INTO wsm_resulting_lots_interface

Line 3499: fnd_message.set_name('WSM', 'WSM_QUANTITY_LESS_OR_EQUAL');

3495: End if;
3496: -- The different checks on slot.quantity are present to give the user appropriate error message.
3497:
3498: if slot.quantity > l_qoh then -- Starting lot quantity is greater than on hand availability
3499: fnd_message.set_name('WSM', 'WSM_QUANTITY_LESS_OR_EQUAL');
3500: l_err_msg:=fnd_message.get;
3501: l_err_code:=1;
3502: raise e_proc_exception;
3503: End if;

Line 3500: l_err_msg:=fnd_message.get;

3496: -- The different checks on slot.quantity are present to give the user appropriate error message.
3497:
3498: if slot.quantity > l_qoh then -- Starting lot quantity is greater than on hand availability
3499: fnd_message.set_name('WSM', 'WSM_QUANTITY_LESS_OR_EQUAL');
3500: l_err_msg:=fnd_message.get;
3501: l_err_code:=1;
3502: raise e_proc_exception;
3503: End if;
3504:

Line 3506: fnd_message.set_name('WSM', 'WSM_USE_UNRESERVE');

3502: raise e_proc_exception;
3503: End if;
3504:
3505: if slot.quantity > l_att then -- Starting lot quantity is greater than unreserved quantity of the lot
3506: fnd_message.set_name('WSM', 'WSM_USE_UNRESERVE');
3507: l_err_msg:=fnd_message.get;
3508: l_err_code:=1;
3509: raise e_proc_exception;
3510: End if;

Line 3507: l_err_msg:=fnd_message.get;

3503: End if;
3504:
3505: if slot.quantity > l_att then -- Starting lot quantity is greater than unreserved quantity of the lot
3506: fnd_message.set_name('WSM', 'WSM_USE_UNRESERVE');
3507: l_err_msg:=fnd_message.get;
3508: l_err_code:=1;
3509: raise e_proc_exception;
3510: End if;
3511:

Line 3513: fnd_message.set_name('WSM', 'WSM_INVALID_TXN_QTY');

3509: raise e_proc_exception;
3510: End if;
3511:
3512: if slot.quantity <> l_att then -- user must transact the entire lot quantity
3513: fnd_message.set_name('WSM', 'WSM_INVALID_TXN_QTY');
3514: l_err_msg:=fnd_message.get;
3515: l_err_code:=1;
3516: raise e_proc_exception;
3517: End if;

Line 3514: l_err_msg:=fnd_message.get;

3510: End if;
3511:
3512: if slot.quantity <> l_att then -- user must transact the entire lot quantity
3513: fnd_message.set_name('WSM', 'WSM_INVALID_TXN_QTY');
3514: l_err_msg:=fnd_message.get;
3515: l_err_code:=1;
3516: raise e_proc_exception;
3517: End if;
3518:

Line 3642: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

3638:
3639: if ((x_rlot_context_code <> x_rlot_context_entered) AND
3640: ((x_rlot_context_code IS NOT NULL) OR (x_rlot_context_entered IS NOT NULL))) THEN
3641:
3642: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
3643: fnd_message.set_token('FLD_NAME', 'Lot Attribute Category');
3644: l_err_msg:=fnd_message.get;
3645: Error_All(p_header_id, null,l_err_msg);
3646: l_err_code:=1;

Line 3643: fnd_message.set_token('FLD_NAME', 'Lot Attribute Category');

3639: if ((x_rlot_context_code <> x_rlot_context_entered) AND
3640: ((x_rlot_context_code IS NOT NULL) OR (x_rlot_context_entered IS NOT NULL))) THEN
3641:
3642: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
3643: fnd_message.set_token('FLD_NAME', 'Lot Attribute Category');
3644: l_err_msg:=fnd_message.get;
3645: Error_All(p_header_id, null,l_err_msg);
3646: l_err_code:=1;
3647: raise e_proc_exception;

Line 3644: l_err_msg:=fnd_message.get;

3640: ((x_rlot_context_code IS NOT NULL) OR (x_rlot_context_entered IS NOT NULL))) THEN
3641:
3642: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
3643: fnd_message.set_token('FLD_NAME', 'Lot Attribute Category');
3644: l_err_msg:=fnd_message.get;
3645: Error_All(p_header_id, null,l_err_msg);
3646: l_err_code:=1;
3647: raise e_proc_exception;
3648: end if;

Line 3662: fnd_message.set_name('WSM', 'WSM_LOT_CONTEXT_DIFF');

3658: x_rlot_context_code is null) THEN
3659: l_copy_from_src:=TRUE;
3660: l_copy_inv_attr:=FALSE;
3661: else
3662: fnd_message.set_name('WSM', 'WSM_LOT_CONTEXT_DIFF');
3663: l_err_msg:=fnd_message.get;
3664: fnd_file.put_line(fnd_file.log,l_err_msg);
3665: l_copy_inv_attr:=TRUE;
3666: l_copy_from_src:=FALSE;

Line 3663: l_err_msg:=fnd_message.get;

3659: l_copy_from_src:=TRUE;
3660: l_copy_inv_attr:=FALSE;
3661: else
3662: fnd_message.set_name('WSM', 'WSM_LOT_CONTEXT_DIFF');
3663: l_err_msg:=fnd_message.get;
3664: fnd_file.put_line(fnd_file.log,l_err_msg);
3665: l_copy_inv_attr:=TRUE;
3666: l_copy_from_src:=FALSE;
3667:

Line 3700: fnd_message.set_name('WSM', 'WSM_REQUIRED_ATTR_NO_INTF');

3696: and (inv_lot_sel_attr.is_enabled('Lot Attributes',
3697: x_org_id,
3698: rlot.inventory_item_id) >= 2) THEN
3699:
3700: fnd_message.set_name('WSM', 'WSM_REQUIRED_ATTR_NO_INTF');
3701: l_err_msg:=fnd_message.get;
3702: Error_All(p_header_id, null,l_err_msg);
3703: l_err_code:=1;
3704: raise e_proc_exception;

Line 3701: l_err_msg:=fnd_message.get;

3697: x_org_id,
3698: rlot.inventory_item_id) >= 2) THEN
3699:
3700: fnd_message.set_name('WSM', 'WSM_REQUIRED_ATTR_NO_INTF');
3701: l_err_msg:=fnd_message.get;
3702: Error_All(p_header_id, null,l_err_msg);
3703: l_err_code:=1;
3704: raise e_proc_exception;
3705: end if;

Line 3712: fnd_message.set_name('WSM', 'WSM_LOT_CONTEXT_DIFF');

3708: x_rlot_context_code is null) THEN
3709: l_copy_from_src:=TRUE;
3710: l_copy_inv_attr:=FALSE;
3711: else
3712: fnd_message.set_name('WSM', 'WSM_LOT_CONTEXT_DIFF');
3713: l_err_msg:=fnd_message.get;
3714: fnd_file.put_line(fnd_file.log,l_err_msg);
3715: l_copy_inv_attr:=TRUE;
3716: l_copy_from_src:=FALSE;

Line 3713: l_err_msg:=fnd_message.get;

3709: l_copy_from_src:=TRUE;
3710: l_copy_inv_attr:=FALSE;
3711: else
3712: fnd_message.set_name('WSM', 'WSM_LOT_CONTEXT_DIFF');
3713: l_err_msg:=fnd_message.get;
3714: fnd_file.put_line(fnd_file.log,l_err_msg);
3715: l_copy_inv_attr:=TRUE;
3716: l_copy_from_src:=FALSE;
3717: end if;

Line 4371: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

4367:
4368:
4369: EXCEPTION when others THEN
4370:
4371: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
4372: FND_MESSAGE.SET_TOKEN('FLD_NAME','Transaction Account for the Organization');
4373: x_err_msg := fnd_message.get;
4374: x_err_code := SQLCODE;
4375: return;

Line 4372: FND_MESSAGE.SET_TOKEN('FLD_NAME','Transaction Account for the Organization');

4368:
4369: EXCEPTION when others THEN
4370:
4371: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
4372: FND_MESSAGE.SET_TOKEN('FLD_NAME','Transaction Account for the Organization');
4373: x_err_msg := fnd_message.get;
4374: x_err_code := SQLCODE;
4375: return;
4376:

Line 4373: x_err_msg := fnd_message.get;

4369: EXCEPTION when others THEN
4370:
4371: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
4372: FND_MESSAGE.SET_TOKEN('FLD_NAME','Transaction Account for the Organization');
4373: x_err_msg := fnd_message.get;
4374: x_err_code := SQLCODE;
4375: return;
4376:
4377: End;

Line 4590: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

4586:
4587:
4588: EXCEPTION when others THEN
4589:
4590: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
4591: FND_MESSAGE.SET_TOKEN('FLD_NAME','Transaction Account for the Organization');
4592: x_err_msg := fnd_message.get;
4593: x_err_code := SQLCODE;
4594: return;

Line 4591: FND_MESSAGE.SET_TOKEN('FLD_NAME','Transaction Account for the Organization');

4587:
4588: EXCEPTION when others THEN
4589:
4590: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
4591: FND_MESSAGE.SET_TOKEN('FLD_NAME','Transaction Account for the Organization');
4592: x_err_msg := fnd_message.get;
4593: x_err_code := SQLCODE;
4594: return;
4595:

Line 4592: x_err_msg := fnd_message.get;

4588: EXCEPTION when others THEN
4589:
4590: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
4591: FND_MESSAGE.SET_TOKEN('FLD_NAME','Transaction Account for the Organization');
4592: x_err_msg := fnd_message.get;
4593: x_err_code := SQLCODE;
4594: return;
4595:
4596: End;

Line 4926: X_Message := substr(FND_MESSAGE.get, 1, 2000);

4922: /* You must COMMIT to submit the request */
4923: COMMIT;
4924: /* If req_id = 0, the request could not be submitted */
4925: IF req_id = 0 THEN
4926: X_Message := substr(FND_MESSAGE.get, 1, 2000);
4927: return(FALSE);
4928: else
4929: /* Wait for the request to finish */
4930: -- modified the parameter passing as non-positional.