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.INV_OPM_LOT_MIGRATION dependencies on IC_LOTS_MST

Line 26: | Jatinder - 11/30/06 - Use correct balance status from ic_lots_mst_mig |

22: | |
23: | HISTORY |
24: | Created - Jatinder Gogna - 3/22/05 |
25: | |
26: | Jatinder - 11/30/06 - Use correct balance status from ic_lots_mst_mig |
27: | B5690654 |
28: | |
29: | Kedar Bavadekar 04/20/10 - Populate vendor_id, name and lot number |
30: | for Bug#9600386 in procedure |

Line 123: l_opm_lot ic_lots_mst%ROWTYPE;

119: l_lot_rec mtl_lot_numbers%ROWTYPE;
120: o_lot_rec mtl_lot_numbers%ROWTYPE;
121: o_item_rec INV_ITEM_API.Item_rec_type;
122: -- l_error_tbl INV_ITEM_API.Error_tbl_type;
123: l_opm_lot ic_lots_mst%ROWTYPE;
124: l_inventory_item_id NUMBER;
125: l_count NUMBER;
126: l_lot_number VARCHAR2(80);
127: l_parent_lot_number VARCHAR2(80);

Line 149: FROM ic_lots_mst

145: x_failure_count := 0;
146: -- Get the OPM Lot Master Details
147: BEGIN
148: SELECT * INTO l_opm_lot
149: FROM ic_lots_mst
150: WHERE item_id = p_item_id and
151: lot_id = p_lot_id;
152: EXCEPTION
153: WHEN NO_DATA_FOUND THEN

Line 160: p_table_name => 'IC_LOTS_MST',

156: GMA_COMMON_LOGGING.gma_migration_central_log (
157: p_run_id => p_migration_run_id,
158: p_log_level => FND_LOG.LEVEL_ERROR,
159: p_message_token => 'GMI_MIG_INVALID_LOT_ID',
160: p_table_name => 'IC_LOTS_MST',
161: p_context => 'LOTS',
162: p_param1 => INV_GMI_Migration.lot(p_lot_id),
163: p_param2 => INV_GMI_Migration.item(p_item_id),
164: p_param3 => NULL,

Line 190: p_table_name => 'IC_LOTS_MST',

186: GMA_COMMON_LOGGING.gma_migration_central_log (
187: p_run_id => p_migration_run_id,
188: p_log_level => FND_LOG.LEVEL_ERROR,
189: p_message_token => 'GMI_MIG_ITEM_MIG_FAILED',
190: p_table_name => 'IC_LOTS_MST',
191: p_context => 'LOTS',
192: p_param1 => INV_GMI_Migration.org(p_organization_id),
193: p_param2 => INV_GMI_Migration.item(p_item_id),
194: p_param3 => NULL,

Line 239: -- insert it into ic_lots_mst_mig table

235: WHEN NO_DATA_FOUND THEN
236: NULL;
237: END;
238: END IF;
239: -- insert it into ic_lots_mst_mig table
240: IF (l_lot_status is NULL) THEN
241: l_lot_status := l_default_status;
242: END IF;
243: INSERT into ic_lots_mst_mig (

Line 243: INSERT into ic_lots_mst_mig (

239: -- insert it into ic_lots_mst_mig table
240: IF (l_lot_status is NULL) THEN
241: l_lot_status := l_default_status;
242: END IF;
243: INSERT into ic_lots_mst_mig (
244: item_id,
245: lot_id,
246: organization_id,
247: whse_code,

Line 298: -- Jatinder - 11/30/06 - Use correct balance status from ic_lots_mst_mig B5690654

294:
295:
296: /* rlnagara 2 Material Status Migration ME - As we are passing status_id as NULL while creating the l_lot_rec, below code is not needed.
297: -- Get status id
298: -- Jatinder - 11/30/06 - Use correct balance status from ic_lots_mst_mig B5690654
299: l_status_id := NULL;
300: IF (l_lot_status IS NOT NULL) THEN
301: l_field_name := 'Lot Status Id';
302: l_field_value := l_lot_status;

Line 319: p_table_name => 'IC_LOTS_MST',

315: GMA_COMMON_LOGGING.gma_migration_central_log (
316: p_run_id => p_migration_run_id,
317: p_log_level => FND_LOG.LEVEL_ERROR,
318: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
319: p_table_name => 'IC_LOTS_MST',
320: p_context => 'LOTS',
321: p_param1 => l_field_name,
322: p_param2 => l_field_value,
323: p_param3 => NULL,

Line 377: p_table_name => 'IC_LOTS_MST',

373: GMA_COMMON_LOGGING.gma_migration_central_log (
374: p_run_id => p_migration_run_id,
375: p_log_level => FND_LOG.LEVEL_PROCEDURE,
376: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
377: p_table_name => 'IC_LOTS_MST',
378: p_context => 'LOTS',
379: p_param1 => 'Supplier Id/Name' ,
380: p_param2 => x_lot_number,
381: p_param3 => NULL,

Line 396: p_table_name => 'IC_LOTS_MST',

392: GMA_COMMON_LOGGING.gma_migration_central_log (
393: p_run_id => p_migration_run_id,
394: p_log_level => FND_LOG.LEVEL_PROCEDURE,
395: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
396: p_table_name => 'IC_LOTS_MST',
397: p_context => 'LOTS',
398: p_param1 => 'Supplier Id/Name' ,
399: p_param2 => x_lot_number,
400: p_param3 => NULL,

Line 491: p_table_name => 'IC_LOTS_MST',

487: GMA_COMMON_LOGGING.gma_migration_central_log (
488: p_run_id => p_migration_run_id,
489: p_log_level => FND_LOG.LEVEL_PROCEDURE,
490: p_message_token => 'GMI_MIG_LOT_ALREADY_EXISTS',
491: p_table_name => 'IC_LOTS_MST',
492: p_context => 'LOTS',
493: p_param1 => INV_GMI_Migration.org(p_organization_id),
494: p_param2 => INV_GMI_Migration.ditem(p_organization_id,l_inventory_item_id),
495: p_param3 => x_lot_number,

Line 539: p_table_name => 'IC_LOTS_MST',

535: GMA_COMMON_LOGGING.gma_migration_central_log (
536: p_run_id => p_migration_run_id,
537: p_log_level => FND_LOG.LEVEL_ERROR,
538: p_message_token => 'GMI_UNEXPECTED_ERROR',
539: p_table_name => 'IC_LOTS_MST',
540: p_context => 'LOTS',
541: p_token1 => 'ERROR',
542: p_param1 => fnd_msg_pub.get_detail(i, NULL),
543: p_param2 => NULL,

Line 565: UPDATE ic_lots_mst_mig

561: FROM ic_whse_mst
562: WHERE whse_code = p_whse_code;
563: END IF;
564:
565: UPDATE ic_lots_mst_mig
566: SET
567: organization_id = p_organization_id,
568: migrated_ind = 1,
569: last_update_date = sysdate,

Line 699: p_table_name => 'IC_LOTS_MST',

695: GMA_COMMON_LOGGING.gma_migration_central_log (
696: p_run_id => p_migration_run_id,
697: p_log_level => FND_LOG.LEVEL_ERROR,
698: p_message_token => 'GMI_MIG_DFLEX_COL_CONFLICT', -- Bug 5720001
699: p_table_name => 'IC_LOTS_MST',
700: p_context => 'LOTS',
701: p_param1 => l_opm_context,
702: p_param2 => l_odm_context,
703: p_param3 => NULL,

Line 722: p_table_name => 'IC_LOTS_MST',

718: GMA_COMMON_LOGGING.gma_migration_central_log (
719: p_run_id => p_migration_run_id,
720: p_log_level => FND_LOG.LEVEL_ERROR,
721: p_message_token => 'GMI_MIG_DFLEX_COL_CONFLICT', -- Bug 5720001
722: p_table_name => 'IC_LOTS_MST',
723: p_context => 'LOTS',
724: p_param1 => conflict_columns.descriptive_flex_context_code,
725: p_param2 => conflict_columns.end_user_column_name,
726: p_param3 => conflict_columns.application_column_name,

Line 845: FROM ic_lots_mst

841: l_field_name := 'OPM Lot id';
842: l_field_value := p_lot_no;
843: SELECT lot_id
844: INTO l_lot_id
845: FROM ic_lots_mst
846: WHERE
847: item_id = l_item_id AND
848: lot_no = p_lot_no AND
849: nvl(sublot_no, ' ') = nvl(p_sublot_no, ' ');

Line 889: p_table_name => 'IC_LOTS_MST',

885: GMA_COMMON_LOGGING.gma_migration_central_log (
886: p_run_id => p_migration_run_id,
887: p_log_level => FND_LOG.LEVEL_ERROR,
888: p_message_token => 'GMI_MIG_DIFF_ORG_LOC_WHSE',
889: p_table_name => 'IC_LOTS_MST',
890: p_context => 'LOTS',
891: p_param1 => INV_GMI_Migration.org(p_organization_id),
892: p_param2 => l_whse_code,
893: p_param3 => to_char(p_locator_id),

Line 922: p_table_name => 'IC_LOTS_MST',

918: GMA_COMMON_LOGGING.gma_migration_central_log (
919: p_run_id => p_migration_run_id,
920: p_log_level => FND_LOG.LEVEL_ERROR,
921: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
922: p_table_name => 'IC_LOTS_MST',
923: p_context => 'LOTS',
924: p_param1 => l_field_name,
925: p_param2 => l_field_value,
926: p_param3 => NULL,

Line 1004: FROM ic_lots_mst

1000: IF (p_get_parent_only <> 1) THEN
1001: BEGIN
1002: SELECT lot_id
1003: INTO l_lot_id
1004: FROM ic_lots_mst
1005: WHERE
1006: item_id = p_item_id AND
1007: lot_no = p_lot_no AND
1008: nvl(sublot_no, ' ') = nvl(p_sublot_no, ' ');

Line 1029: p_table_name => 'IC_LOTS_MST',

1025: GMA_COMMON_LOGGING.gma_migration_central_log (
1026: p_run_id => p_migration_run_id,
1027: p_log_level => FND_LOG.LEVEL_ERROR,
1028: p_message_token => 'GMI_MIG_INVALID_LOT',
1029: p_table_name => 'IC_LOTS_MST',
1030: p_context => 'LOTS',
1031: p_param1 => p_lot_no,
1032: p_param2 => p_sublot_no,
1033: p_param3 => INV_GMI_Migration.item(p_item_id),

Line 1045: FROM ic_lots_mst_mig

1041: END;
1042: ELSE -- Get the parent lot only
1043: SELECT count(*)
1044: INTO l_count
1045: FROM ic_lots_mst_mig
1046: WHERE
1047: item_id = p_item_id AND
1048: whse_code = p_whse_code AND
1049: parent_lot_number = p_lot_no AND

Line 1058: p_table_name => 'IC_LOTS_MST',

1054: GMA_COMMON_LOGGING.gma_migration_central_log (
1055: p_run_id => p_migration_run_id,
1056: p_log_level => FND_LOG.LEVEL_ERROR,
1057: p_message_token => 'GMI_MIG_NO_PARENT_LOT',
1058: p_table_name => 'IC_LOTS_MST',
1059: p_context => 'LOTS',
1060: p_param1 => INV_GMI_Migration.item(p_item_id),
1061: p_param2 => p_whse_code,
1062: p_param3 => p_lot_no,

Line 1157: p_table_name => 'IC_LOTS_MST',

1153: GMA_COMMON_LOGGING.gma_migration_central_log (
1154: p_run_id => p_migration_run_id,
1155: p_log_level => FND_LOG.LEVEL_ERROR,
1156: p_message_token => 'GMI_MIG_INVALID_PARAMS',
1157: p_table_name => 'IC_LOTS_MST',
1158: p_context => 'LOTS',
1159: p_param1 => NULL,
1160: p_param2 => NULL,
1161: p_param3 => NULL,

Line 1212: p_table_name => 'IC_LOTS_MST',

1208: GMA_COMMON_LOGGING.gma_migration_central_log (
1209: p_run_id => p_migration_run_id,
1210: p_log_level => FND_LOG.LEVEL_ERROR,
1211: p_message_token => 'GMI_MIG_WHSE_NOT_MIGRATED',
1212: p_table_name => 'IC_LOTS_MST',
1213: p_context => 'LOTS',
1214: p_param1 => p_whse_code,
1215: p_param2 => NULL,
1216: p_param3 => NULL,

Line 1232: p_table_name => 'IC_LOTS_MST',

1228: GMA_COMMON_LOGGING.gma_migration_central_log (
1229: p_run_id => p_migration_run_id,
1230: p_log_level => FND_LOG.LEVEL_ERROR,
1231: p_message_token => 'GMI_MIG_INVALID_WHSE',
1232: p_table_name => 'IC_LOTS_MST',
1233: p_context => 'LOTS',
1234: p_param1 => p_whse_code,
1235: p_param2 => NULL,
1236: p_param3 => NULL,

Line 1259: p_table_name => 'IC_LOTS_MST',

1255: GMA_COMMON_LOGGING.gma_migration_central_log (
1256: p_run_id => p_migration_run_id,
1257: p_log_level => FND_LOG.LEVEL_ERROR,
1258: p_message_token => 'GMI_MIG_ORGN_NOT_MIGRATED',
1259: p_table_name => 'IC_LOTS_MST',
1260: p_context => 'LOTS',
1261: p_param1 => p_orgn_code,
1262: p_param2 => NULL,
1263: p_param3 => NULL,

Line 1279: p_table_name => 'IC_LOTS_MST',

1275: GMA_COMMON_LOGGING.gma_migration_central_log (
1276: p_run_id => p_migration_run_id,
1277: p_log_level => FND_LOG.LEVEL_ERROR,
1278: p_message_token => 'GMI_MIG_INVALID_ORGN',
1279: p_table_name => 'IC_LOTS_MST',
1280: p_context => 'LOTS',
1281: p_param1 => p_orgn_code,
1282: p_param2 => NULL,
1283: p_param3 => NULL,

Line 1296: -- Check the value in ic_lots_mst_mig table

1292: ELSE
1293: l_organization_id := p_organization_id;
1294: END IF;
1295:
1296: -- Check the value in ic_lots_mst_mig table
1297: BEGIN
1298: g_item_id := p_item_id;
1299: g_lot_id := p_lot_id;
1300: g_whse_code := p_whse_code;

Line 1312: FROM ic_lots_mst_mig

1308: IF (g_location is not NULL) THEN
1309: BEGIN
1310: SELECT lot_number, parent_lot_number, status, nvl(migrated_ind, 0)
1311: INTO g_lot_number, g_parent_lot_number, l_lot_status, l_migrated_ind
1312: FROM ic_lots_mst_mig
1313: WHERE
1314: item_id = g_item_id AND
1315: lot_id = g_lot_id AND
1316: whse_code = g_whse_code AND -- only OPM whse

Line 1329: FROM ic_lots_mst_mig

1325: IF (g_location is NULL or l_migrated_ind = -1) THEN
1326:
1327: SELECT lot_number, parent_lot_number, status, migrated_ind
1328: INTO g_lot_number, g_parent_lot_number, l_lot_status, l_migrated_ind
1329: FROM ic_lots_mst_mig
1330: WHERE
1331: item_id = g_item_id AND
1332: lot_id = g_lot_id AND
1333: organization_id = g_organization_id AND -- for OPM whse or orgn

Line 1369: p_table_name => 'IC_LOTS_MST',

1365: GMA_COMMON_LOGGING.gma_migration_central_log (
1366: p_run_id => p_migration_run_id,
1367: p_log_level => FND_LOG.LEVEL_ERROR,
1368: p_message_token => 'GMI_MIG_LOT_MIG_FAILED',
1369: p_table_name => 'IC_LOTS_MST',
1370: p_context => 'LOTS',
1371: p_param1 => INV_GMI_Migration.item(p_item_id),
1372: p_param2 => INV_GMI_Migration.lot(p_lot_id),
1373: p_param3 => p_whse_code,

Line 1393: p_table_name => 'IC_LOTS_MST',

1389: GMA_COMMON_LOGGING.gma_migration_central_log (
1390: p_run_id => P_migration_run_id,
1391: p_log_level => FND_LOG.LEVEL_ERROR,
1392: p_message_token => 'GMI_UNEXPECTED_ERROR',
1393: p_table_name => 'IC_LOTS_MST',
1394: p_context => 'LOTS',
1395: p_token1 => 'ERROR',
1396: p_param1 => fnd_msg_pub.get_detail(i, NULL),
1397: p_param2 => NULL,

Line 1414: p_table_name => 'IC_LOTS_MST',

1410: GMA_COMMON_LOGGING.gma_migration_central_log (
1411: p_run_id => P_migration_run_id,
1412: p_log_level => FND_LOG.LEVEL_ERROR,
1413: p_message_token => 'GMI_UNEXPECTED_ERROR',
1414: p_table_name => 'IC_LOTS_MST',
1415: p_context => 'LOTS',
1416: p_token1 => 'ERROR',
1417: p_param1 => fnd_msg_pub.get_detail(i, NULL),
1418: p_param2 => NULL,

Line 1435: p_table_name => 'IC_LOTS_MST',

1431: GMA_COMMON_LOGGING.gma_migration_central_log (
1432: p_run_id => P_migration_run_id,
1433: p_log_level => FND_LOG.LEVEL_ERROR,
1434: p_message_token => 'GMI_UNEXPECTED_ERROR',
1435: p_table_name => 'IC_LOTS_MST',
1436: p_context => 'LOTS',
1437: p_token1 => 'ERROR',
1438: p_param1 => fnd_msg_pub.get_detail(i, NULL),
1439: p_param2 => NULL,

Line 1451: p_table_name => 'IC_LOTS_MST',

1447: GMA_COMMON_LOGGING.gma_migration_central_log (
1448: p_run_id => P_migration_run_id,
1449: p_log_level => FND_LOG.LEVEL_ERROR,
1450: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1451: p_table_name => 'IC_LOTS_MST',
1452: p_context => 'LOTS',
1453: p_param1 => NULL,
1454: p_param2 => NULL,
1455: p_param3 => NULL,