APPS.WSMPINVL dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 1171: -- check if this lot_number exists in mtl_transaction_lots_temp

1167: --fnd_message.error;
1168: END IF;
1169: END;
1170: */
1171: -- check if this lot_number exists in mtl_transaction_lots_temp
1172:
1173:
1174: /*
1175: ** To process the same Lot Numbers for different Inventory Lot Txns

Line 1226: From mtl_transaction_lots_temp

1222:
1223: SELECT 1 into x_dummy
1224: FROM DUAL
1225: Where exists (select 1
1226: From mtl_transaction_lots_temp
1227: WHERE lot_number=crec.lot_number);
1228:
1229: IF x_dummy <>0 then
1230: lProcLocation := 30;

Line 1261: ||'Table: mtl_transaction_lots_temp ');

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);
1264: err_status := -1;
1265: return;

Line 1287: FROM mtl_transaction_lots_temp

1283: **
1284:
1285: BEGIN
1286: SELECT count(*) into x_dummy
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');

Line 1294: ||'Table: mtl_transaction_lots_temp ');

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;
1297: return;
1298: END IF;

Line 1689: From mtl_transaction_lots_temp

1685:
1686: SELECT 1 into x_dummy
1687: FROM DUAL
1688: Where exists (select 1
1689: From mtl_transaction_lots_temp
1690: WHERE lot_number=crec.lot_number);
1691:
1692: IF x_dummy <>0 then
1693:

Line 1724: ||'Table: mtl_transaction_lots_temp ');

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;
1727: return;
1728:

Line 1743: -- check if this lot_number exists in mtl_transaction_lots_temp

1739: /*BD#1549476*/
1740: /*
1741: **
1742:
1743: -- check if this lot_number exists in mtl_transaction_lots_temp
1744:
1745: BEGIN
1746: SELECT count(*) into x_cnt1
1747: FROM mtl_transaction_lots_temp

Line 1747: FROM mtl_transaction_lots_temp

1743: -- check if this lot_number exists in mtl_transaction_lots_temp
1744:
1745: BEGIN
1746: SELECT count(*) into x_cnt1
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');

Line 1754: ||'Table: mtl_transaction_lots_temp ');

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;
1757: showProgress(
1758: processingMode => CONCURRENT

Line 4460: INSERT INTO MTL_TRANSACTION_LOTS_TEMP

4456: , procLocation => l_stmt_num
4457: , showMessage => 'Sucessful insert to MMTT for Misc.Issue');
4458: /*EA#IIIP*/
4459:
4460: INSERT INTO MTL_TRANSACTION_LOTS_TEMP
4461: (
4462: transaction_temp_id,
4463: last_update_date,
4464: creation_date,

Line 4849: INSERT INTO MTL_TRANSACTION_LOTS_TEMP

4845: /*EA#IIIP*/
4846:
4847: l_stmt_num :=50;
4848:
4849: INSERT INTO MTL_TRANSACTION_LOTS_TEMP
4850: (
4851: transaction_temp_id,
4852: last_update_date,
4853: creation_date,