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: +==========================================================================+
30: */

Line 112: l_opm_lot ic_lots_mst%ROWTYPE;

108: l_lot_rec mtl_lot_numbers%ROWTYPE;
109: o_lot_rec mtl_lot_numbers%ROWTYPE;
110: o_item_rec INV_ITEM_API.Item_rec_type;
111: -- l_error_tbl INV_ITEM_API.Error_tbl_type;
112: l_opm_lot ic_lots_mst%ROWTYPE;
113: l_inventory_item_id NUMBER;
114: l_count NUMBER;
115: l_lot_number VARCHAR2(80);
116: l_parent_lot_number VARCHAR2(80);

Line 138: FROM ic_lots_mst

134: x_failure_count := 0;
135: -- Get the OPM Lot Master Details
136: BEGIN
137: SELECT * INTO l_opm_lot
138: FROM ic_lots_mst
139: WHERE item_id = p_item_id and
140: lot_id = p_lot_id;
141: EXCEPTION
142: WHEN NO_DATA_FOUND THEN

Line 149: p_table_name => 'IC_LOTS_MST',

145: GMA_COMMON_LOGGING.gma_migration_central_log (
146: p_run_id => p_migration_run_id,
147: p_log_level => FND_LOG.LEVEL_ERROR,
148: p_message_token => 'GMI_MIG_INVALID_LOT_ID',
149: p_table_name => 'IC_LOTS_MST',
150: p_context => 'LOTS',
151: p_param1 => INV_GMI_Migration.lot(p_lot_id),
152: p_param2 => INV_GMI_Migration.item(p_item_id),
153: p_param3 => NULL,

Line 179: p_table_name => 'IC_LOTS_MST',

175: GMA_COMMON_LOGGING.gma_migration_central_log (
176: p_run_id => p_migration_run_id,
177: p_log_level => FND_LOG.LEVEL_ERROR,
178: p_message_token => 'GMI_MIG_ITEM_MIG_FAILED',
179: p_table_name => 'IC_LOTS_MST',
180: p_context => 'LOTS',
181: p_param1 => INV_GMI_Migration.org(p_organization_id),
182: p_param2 => INV_GMI_Migration.item(p_item_id),
183: p_param3 => NULL,

Line 228: -- insert it into ic_lots_mst_mig table

224: WHEN NO_DATA_FOUND THEN
225: NULL;
226: END;
227: END IF;
228: -- insert it into ic_lots_mst_mig table
229: IF (l_lot_status is NULL) THEN
230: l_lot_status := l_default_status;
231: END IF;
232: INSERT into ic_lots_mst_mig (

Line 232: INSERT into ic_lots_mst_mig (

228: -- insert it into ic_lots_mst_mig table
229: IF (l_lot_status is NULL) THEN
230: l_lot_status := l_default_status;
231: END IF;
232: INSERT into ic_lots_mst_mig (
233: item_id,
234: lot_id,
235: organization_id,
236: whse_code,

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

283:
284:
285: /* 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.
286: -- Get status id
287: -- Jatinder - 11/30/06 - Use correct balance status from ic_lots_mst_mig B5690654
288: l_status_id := NULL;
289: IF (l_lot_status IS NOT NULL) THEN
290: l_field_name := 'Lot Status Id';
291: l_field_value := l_lot_status;

Line 308: p_table_name => 'IC_LOTS_MST',

304: GMA_COMMON_LOGGING.gma_migration_central_log (
305: p_run_id => p_migration_run_id,
306: p_log_level => FND_LOG.LEVEL_ERROR,
307: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
308: p_table_name => 'IC_LOTS_MST',
309: p_context => 'LOTS',
310: p_param1 => l_field_name,
311: p_param2 => l_field_value,
312: p_param3 => NULL,

Line 415: p_table_name => 'IC_LOTS_MST',

411: GMA_COMMON_LOGGING.gma_migration_central_log (
412: p_run_id => p_migration_run_id,
413: p_log_level => FND_LOG.LEVEL_PROCEDURE,
414: p_message_token => 'GMI_MIG_LOT_ALREADY_EXISTS',
415: p_table_name => 'IC_LOTS_MST',
416: p_context => 'LOTS',
417: p_param1 => INV_GMI_Migration.org(p_organization_id),
418: p_param2 => INV_GMI_Migration.ditem(p_organization_id,l_inventory_item_id),
419: p_param3 => x_lot_number,

Line 447: p_table_name => 'IC_LOTS_MST',

443: GMA_COMMON_LOGGING.gma_migration_central_log (
444: p_run_id => p_migration_run_id,
445: p_log_level => FND_LOG.LEVEL_ERROR,
446: p_message_token => 'GMI_UNEXPECTED_ERROR',
447: p_table_name => 'IC_LOTS_MST',
448: p_context => 'LOTS',
449: p_token1 => 'ERROR',
450: p_param1 => fnd_msg_pub.get_detail(i, NULL),
451: p_param2 => NULL,

Line 473: UPDATE ic_lots_mst_mig

469: FROM ic_whse_mst
470: WHERE whse_code = p_whse_code;
471: END IF;
472:
473: UPDATE ic_lots_mst_mig
474: SET
475: organization_id = p_organization_id,
476: migrated_ind = 1,
477: last_update_date = sysdate,

Line 605: p_table_name => 'IC_LOTS_MST',

601: GMA_COMMON_LOGGING.gma_migration_central_log (
602: p_run_id => p_migration_run_id,
603: p_log_level => FND_LOG.LEVEL_ERROR,
604: p_message_token => 'GMI_MIG_DFLEX_CONTEXT_CONFLICT',
605: p_table_name => 'IC_LOTS_MST',
606: p_context => 'LOTS',
607: p_param1 => l_opm_context,
608: p_param2 => l_odm_context,
609: p_param3 => NULL,

Line 628: p_table_name => 'IC_LOTS_MST',

624: GMA_COMMON_LOGGING.gma_migration_central_log (
625: p_run_id => p_migration_run_id,
626: p_log_level => FND_LOG.LEVEL_ERROR,
627: p_message_token => 'GMI_MIG_DFLEX_CONTEXT_CONFLICT',
628: p_table_name => 'IC_LOTS_MST',
629: p_context => 'LOTS',
630: p_param1 => conflict_columns.descriptive_flex_context_code,
631: p_param2 => conflict_columns.end_user_column_name,
632: p_param3 => conflict_columns.application_column_name,

Line 751: FROM ic_lots_mst

747: l_field_name := 'OPM Lot id';
748: l_field_value := p_lot_no;
749: SELECT lot_id
750: INTO l_lot_id
751: FROM ic_lots_mst
752: WHERE
753: item_id = l_item_id AND
754: lot_no = p_lot_no AND
755: nvl(sublot_no, ' ') = nvl(p_sublot_no, ' ');

Line 795: p_table_name => 'IC_LOTS_MST',

791: GMA_COMMON_LOGGING.gma_migration_central_log (
792: p_run_id => p_migration_run_id,
793: p_log_level => FND_LOG.LEVEL_ERROR,
794: p_message_token => 'GMI_MIG_DIFF_ORG_LOC_WHSE',
795: p_table_name => 'IC_LOTS_MST',
796: p_context => 'LOTS',
797: p_param1 => INV_GMI_Migration.org(p_organization_id),
798: p_param2 => l_whse_code,
799: p_param3 => to_char(p_locator_id),

Line 828: p_table_name => 'IC_LOTS_MST',

824: GMA_COMMON_LOGGING.gma_migration_central_log (
825: p_run_id => p_migration_run_id,
826: p_log_level => FND_LOG.LEVEL_ERROR,
827: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
828: p_table_name => 'IC_LOTS_MST',
829: p_context => 'LOTS',
830: p_param1 => l_field_name,
831: p_param2 => l_field_value,
832: p_param3 => NULL,

Line 910: FROM ic_lots_mst

906: IF (p_get_parent_only <> 1) THEN
907: BEGIN
908: SELECT lot_id
909: INTO l_lot_id
910: FROM ic_lots_mst
911: WHERE
912: item_id = p_item_id AND
913: lot_no = p_lot_no AND
914: nvl(sublot_no, ' ') = nvl(p_sublot_no, ' ');

Line 935: p_table_name => 'IC_LOTS_MST',

931: GMA_COMMON_LOGGING.gma_migration_central_log (
932: p_run_id => p_migration_run_id,
933: p_log_level => FND_LOG.LEVEL_ERROR,
934: p_message_token => 'GMI_MIG_INVALID_LOT',
935: p_table_name => 'IC_LOTS_MST',
936: p_context => 'LOTS',
937: p_param1 => p_lot_no,
938: p_param2 => p_sublot_no,
939: p_param3 => INV_GMI_Migration.item(p_item_id),

Line 951: FROM ic_lots_mst_mig

947: END;
948: ELSE -- Get the parent lot only
949: SELECT count(*)
950: INTO l_count
951: FROM ic_lots_mst_mig
952: WHERE
953: item_id = p_item_id AND
954: whse_code = p_whse_code AND
955: parent_lot_number = p_lot_no AND

Line 964: p_table_name => 'IC_LOTS_MST',

960: GMA_COMMON_LOGGING.gma_migration_central_log (
961: p_run_id => p_migration_run_id,
962: p_log_level => FND_LOG.LEVEL_ERROR,
963: p_message_token => 'GMI_MIG_NO_PARENT_LOT',
964: p_table_name => 'IC_LOTS_MST',
965: p_context => 'LOTS',
966: p_param1 => INV_GMI_Migration.item(p_item_id),
967: p_param2 => p_whse_code,
968: p_param3 => p_lot_no,

Line 1063: p_table_name => 'IC_LOTS_MST',

1059: GMA_COMMON_LOGGING.gma_migration_central_log (
1060: p_run_id => p_migration_run_id,
1061: p_log_level => FND_LOG.LEVEL_ERROR,
1062: p_message_token => 'GMI_MIG_INVALID_PARAMS',
1063: p_table_name => 'IC_LOTS_MST',
1064: p_context => 'LOTS',
1065: p_param1 => NULL,
1066: p_param2 => NULL,
1067: p_param3 => NULL,

Line 1118: p_table_name => 'IC_LOTS_MST',

1114: GMA_COMMON_LOGGING.gma_migration_central_log (
1115: p_run_id => p_migration_run_id,
1116: p_log_level => FND_LOG.LEVEL_ERROR,
1117: p_message_token => 'GMI_MIG_WHSE_NOT_MIGRATED',
1118: p_table_name => 'IC_LOTS_MST',
1119: p_context => 'LOTS',
1120: p_param1 => p_whse_code,
1121: p_param2 => NULL,
1122: p_param3 => NULL,

Line 1138: p_table_name => 'IC_LOTS_MST',

1134: GMA_COMMON_LOGGING.gma_migration_central_log (
1135: p_run_id => p_migration_run_id,
1136: p_log_level => FND_LOG.LEVEL_ERROR,
1137: p_message_token => 'GMI_MIG_INVALID_WHSE',
1138: p_table_name => 'IC_LOTS_MST',
1139: p_context => 'LOTS',
1140: p_param1 => p_whse_code,
1141: p_param2 => NULL,
1142: p_param3 => NULL,

Line 1165: p_table_name => 'IC_LOTS_MST',

1161: GMA_COMMON_LOGGING.gma_migration_central_log (
1162: p_run_id => p_migration_run_id,
1163: p_log_level => FND_LOG.LEVEL_ERROR,
1164: p_message_token => 'GMI_MIG_ORGN_NOT_MIGRATED',
1165: p_table_name => 'IC_LOTS_MST',
1166: p_context => 'LOTS',
1167: p_param1 => p_orgn_code,
1168: p_param2 => NULL,
1169: p_param3 => NULL,

Line 1185: p_table_name => 'IC_LOTS_MST',

1181: GMA_COMMON_LOGGING.gma_migration_central_log (
1182: p_run_id => p_migration_run_id,
1183: p_log_level => FND_LOG.LEVEL_ERROR,
1184: p_message_token => 'GMI_MIG_INVALID_ORGN',
1185: p_table_name => 'IC_LOTS_MST',
1186: p_context => 'LOTS',
1187: p_param1 => p_orgn_code,
1188: p_param2 => NULL,
1189: p_param3 => NULL,

Line 1202: -- Check the value in ic_lots_mst_mig table

1198: ELSE
1199: l_organization_id := p_organization_id;
1200: END IF;
1201:
1202: -- Check the value in ic_lots_mst_mig table
1203: BEGIN
1204: g_item_id := p_item_id;
1205: g_lot_id := p_lot_id;
1206: g_whse_code := p_whse_code;

Line 1218: FROM ic_lots_mst_mig

1214: IF (g_location is not NULL) THEN
1215: BEGIN
1216: SELECT lot_number, parent_lot_number, status, nvl(migrated_ind, 0)
1217: INTO g_lot_number, g_parent_lot_number, l_lot_status, l_migrated_ind
1218: FROM ic_lots_mst_mig
1219: WHERE
1220: item_id = g_item_id AND
1221: lot_id = g_lot_id AND
1222: whse_code = g_whse_code AND -- only OPM whse

Line 1235: FROM ic_lots_mst_mig

1231: IF (g_location is NULL or l_migrated_ind = -1) THEN
1232:
1233: SELECT lot_number, parent_lot_number, status, migrated_ind
1234: INTO g_lot_number, g_parent_lot_number, l_lot_status, l_migrated_ind
1235: FROM ic_lots_mst_mig
1236: WHERE
1237: item_id = g_item_id AND
1238: lot_id = g_lot_id AND
1239: organization_id = g_organization_id AND -- for OPM whse or orgn

Line 1275: p_table_name => 'IC_LOTS_MST',

1271: GMA_COMMON_LOGGING.gma_migration_central_log (
1272: p_run_id => p_migration_run_id,
1273: p_log_level => FND_LOG.LEVEL_ERROR,
1274: p_message_token => 'GMI_MIG_LOT_MIG_FAILED',
1275: p_table_name => 'IC_LOTS_MST',
1276: p_context => 'LOTS',
1277: p_param1 => INV_GMI_Migration.item(p_item_id),
1278: p_param2 => INV_GMI_Migration.lot(p_lot_id),
1279: p_param3 => p_whse_code,

Line 1299: p_table_name => 'IC_LOTS_MST',

1295: GMA_COMMON_LOGGING.gma_migration_central_log (
1296: p_run_id => P_migration_run_id,
1297: p_log_level => FND_LOG.LEVEL_ERROR,
1298: p_message_token => 'GMI_UNEXPECTED_ERROR',
1299: p_table_name => 'IC_LOTS_MST',
1300: p_context => 'LOTS',
1301: p_token1 => 'ERROR',
1302: p_param1 => fnd_msg_pub.get_detail(i, NULL),
1303: p_param2 => NULL,

Line 1320: p_table_name => 'IC_LOTS_MST',

1316: GMA_COMMON_LOGGING.gma_migration_central_log (
1317: p_run_id => P_migration_run_id,
1318: p_log_level => FND_LOG.LEVEL_ERROR,
1319: p_message_token => 'GMI_UNEXPECTED_ERROR',
1320: p_table_name => 'IC_LOTS_MST',
1321: p_context => 'LOTS',
1322: p_token1 => 'ERROR',
1323: p_param1 => fnd_msg_pub.get_detail(i, NULL),
1324: p_param2 => NULL,

Line 1341: p_table_name => 'IC_LOTS_MST',

1337: GMA_COMMON_LOGGING.gma_migration_central_log (
1338: p_run_id => P_migration_run_id,
1339: p_log_level => FND_LOG.LEVEL_ERROR,
1340: p_message_token => 'GMI_UNEXPECTED_ERROR',
1341: p_table_name => 'IC_LOTS_MST',
1342: p_context => 'LOTS',
1343: p_token1 => 'ERROR',
1344: p_param1 => fnd_msg_pub.get_detail(i, NULL),
1345: p_param2 => NULL,

Line 1357: p_table_name => 'IC_LOTS_MST',

1353: GMA_COMMON_LOGGING.gma_migration_central_log (
1354: p_run_id => P_migration_run_id,
1355: p_log_level => FND_LOG.LEVEL_ERROR,
1356: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1357: p_table_name => 'IC_LOTS_MST',
1358: p_context => 'LOTS',
1359: p_param1 => NULL,
1360: p_param2 => NULL,
1361: p_param3 => NULL,