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_ITEM_MIGRATION dependencies on IC_ITEM_MST_B

Line 59: -- in ic_item_mst_b table.

55: -- get_reg_item_info
56: --
57: -- DESCRIPTION:
58: -- This PL/SQL procedure is used to build a record to simulate data
59: -- in ic_item_mst_b table.
60: --
61: -- PARAMETERS:
62: -- p_item_code - Item_code to use to retrieve Regulatory item values
63: -- x_reg_item_rec - Record in the format of ic_item_mst_b

Line 63: -- x_reg_item_rec - Record in the format of ic_item_mst_b

59: -- in ic_item_mst_b table.
60: --
61: -- PARAMETERS:
62: -- p_item_code - Item_code to use to retrieve Regulatory item values
63: -- x_reg_item_rec - Record in the format of ic_item_mst_b
64: -- x_return_status - Returns the status of the function (success, failure, etc.)
65: -- x_msg_data - Returns message data if an error occurred
66: --
67: -- SYNOPSIS:

Line 80: x_reg_item_rec OUT NOCOPY IC_ITEM_MST_B%ROWTYPE,

76: --=========================================================================== */
77: PROCEDURE get_reg_item_info
78: (
79: p_item_code IN VARCHAR2,
80: x_reg_item_rec OUT NOCOPY IC_ITEM_MST_B%ROWTYPE,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_data OUT NOCOPY VARCHAR2
83: ) IS
84:

Line 222: l_opm_item IC_ITEM_MST_B%ROWTYPE;

218: , x_failure_count OUT NOCOPY NUMBER
219: ) IS
220: l_item_rec INV_ITEM_API.Item_rec_type;
221: o_item_rec INV_ITEM_API.Item_rec_type;
222: l_opm_item IC_ITEM_MST_B%ROWTYPE;
223: l_inventory_item_id NUMBER;
224: l_organization_code VARCHAR2(3);
225: l_action VARCHAR2(1);
226: l_event VARCHAR(20);

Line 289: p_table_name => 'IC_ITEM_MST_B',

285: GMA_COMMON_LOGGING.gma_migration_central_log (
286: p_run_id => p_migration_run_id,
287: p_log_level => FND_LOG.LEVEL_ERROR,
288: p_message_token => 'GMI_UNEXPECTED_ERROR',
289: p_table_name => 'IC_ITEM_MST_B',
290: p_context => 'ITEMS',
291: p_token1 => 'ERROR',
292: p_param1 => l_msg_data,
293: p_param2 => NULL,

Line 304: FROM ic_item_mst_b

300: RAISE e_error;
301: END IF;
302: ELSE
303: SELECT * INTO l_opm_item
304: FROM ic_item_mst_b
305: WHERE item_id = p_item_id;
306: END IF;
307: EXCEPTION
308: WHEN NO_DATA_FOUND THEN

Line 315: p_table_name => 'IC_ITEM_MST_B',

311: GMA_COMMON_LOGGING.gma_migration_central_log (
312: p_run_id => p_migration_run_id,
313: p_log_level => FND_LOG.LEVEL_ERROR,
314: p_message_token => 'GMI_MIG_INVALID_ITEM_ID',
315: p_table_name => 'IC_ITEM_MST_B',
316: p_context => 'ITEMS',
317: p_param1 => INV_GMI_Migration.item(p_item_id),
318: p_param2 => NULL,
319: p_param3 => NULL,

Line 388: p_table_name => 'IC_ITEM_MST_B',

384: GMA_COMMON_LOGGING.gma_migration_central_log (
385: p_run_id => p_migration_run_id,
386: p_log_level => FND_LOG.LEVEL_ERROR,
387: p_message_token => 'GMI_MIG_DISCRETE_ORG',
388: p_table_name => 'IC_ITEM_MST_B',
389: p_context => 'ITEMS',
390: p_param1 => INV_GMI_Migration.org(p_organization_id),
391: p_param2 => INV_GMI_Migration.item(p_item_id),
392: p_param3 => NULL,

Line 546: p_table_name => 'IC_ITEM_MST_B',

542: GMA_COMMON_LOGGING.gma_migration_central_log (
543: p_run_id => p_migration_run_id,
544: p_log_level => FND_LOG.LEVEL_ERROR,
545: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
546: p_table_name => 'IC_ITEM_MST_B',
547: p_context => 'ITEMS',
548: p_param1 => l_field_name,
549: p_param2 => l_field_value,
550: p_param3 => NULL,

Line 874: UPDATE ic_item_mst_b_mig

870: language = d.language;
871: END LOOP;
872:
873: -- Bug 5489195 - Added migrated_ind in the update
874: UPDATE ic_item_mst_b_mig
875: SET
876: inventory_item_id = x_inventory_item_id,
877: migrated_ind = 1,
878: last_update_date = sysdate,

Line 885: INSERT INTO ic_item_mst_b_mig(

881: item_id = p_item_id AND
882: organization_id = p_organization_id;
883:
884: IF SQL%ROWCOUNT = 0 THEN
885: INSERT INTO ic_item_mst_b_mig(
886: item_id,
887: organization_id,
888: inventory_item_id,
889: migrated_ind,

Line 922: p_table_name => 'IC_ITEM_MST_B',

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_UNEXPECTED_ERROR',
922: p_table_name => 'IC_ITEM_MST_B',
923: p_context => 'ITEMS',
924: p_token1 => 'ERROR',
925: p_param1 => fnd_msg_pub.get_detail(i, NULL),
926: p_param2 => NULL,

Line 945: p_table_name => 'IC_ITEM_MST_B',

941: GMA_COMMON_LOGGING.gma_migration_central_log (
942: p_run_id => p_migration_run_id,
943: p_log_level => FND_LOG.LEVEL_ERROR,
944: p_message_token => 'GMI_UNEXPECTED_ERROR',
945: p_table_name => 'IC_ITEM_MST_B',
946: p_context => 'ITEMS',
947: p_token1 => 'ERROR',
948: p_param1 => fnd_msg_pub.get_detail(i, NULL),
949: p_param2 => NULL,

Line 967: p_table_name => 'IC_ITEM_MST_B',

963: GMA_COMMON_LOGGING.gma_migration_central_log (
964: p_run_id => p_migration_run_id,
965: p_log_level => FND_LOG.LEVEL_ERROR,
966: p_message_token => 'GMI_UNEXPECTED_ERROR',
967: p_table_name => 'IC_ITEM_MST_B',
968: p_context => 'ITEMS',
969: p_token1 => 'ERROR',
970: p_param1 => fnd_msg_pub.get_detail(i, NULL),
971: p_param2 => NULL,

Line 983: p_table_name => 'IC_ITEM_MST_B',

979: GMA_COMMON_LOGGING.gma_migration_central_log (
980: p_run_id => p_migration_run_id,
981: p_log_level => FND_LOG.LEVEL_ERROR,
982: p_message_token => 'GMA_MIGRATION_DB_ERROR',
983: p_table_name => 'IC_ITEM_MST_B',
984: p_context => 'ITEMS',
985: p_param1 => NULL,
986: p_param2 => NULL,
987: p_param3 => NULL,

Line 1051: p_table_name => 'IC_ITEM_MST_B',

1047: GMA_COMMON_LOGGING.gma_migration_central_log (
1048: p_run_id => p_migration_run_id,
1049: p_log_level => FND_LOG.LEVEL_ERROR,
1050: p_message_token => 'GMI_MIG_ITEM_ATTRIBUTE',
1051: p_table_name => 'IC_ITEM_MST_B',
1052: p_context => 'ITEMS',
1053: p_param1 => ia.attribute_name,
1054: p_param2 => NULL,
1055: p_param3 => NULL,

Line 1169: p_table_name => 'IC_ITEM_MST_B',

1165: GMA_COMMON_LOGGING.gma_migration_central_log (
1166: p_run_id => p_migration_run_id,
1167: p_log_level => FND_LOG.LEVEL_ERROR,
1168: p_message_token => 'GMI_MIG_DFLEX_CONTEXT_CONFLICT',
1169: p_table_name => 'IC_ITEM_MST_B',
1170: p_context => 'ITEMS',
1171: p_param1 => l_opm_context,
1172: p_param2 => l_odm_context,
1173: p_param3 => NULL,

Line 1192: p_table_name => 'IC_ITEM_MST_B',

1188: GMA_COMMON_LOGGING.gma_migration_central_log (
1189: p_run_id => p_migration_run_id,
1190: p_log_level => FND_LOG.LEVEL_ERROR,
1191: p_message_token => 'GMI_MIG_DFLEX_COL_CONFLICT',
1192: p_table_name => 'IC_ITEM_MST_B',
1193: p_context => 'ITEMS',
1194: p_param1 => conflict_columns.descriptive_flex_context_code,
1195: p_param2 => conflict_columns.end_user_column_name,
1196: p_param3 => conflict_columns.application_column_name,

Line 1309: p_table_name => 'IC_ITEM_MST_B',

1305: GMA_COMMON_LOGGING.gma_migration_central_log (
1306: p_run_id => p_migration_run_id,
1307: p_log_level => FND_LOG.LEVEL_ERROR,
1308: p_message_token => 'GMI_MIG_INVALID_PARAMS',
1309: p_table_name => 'IC_ITEM_MST_B',
1310: p_context => 'ITEMS',
1311: p_param1 => NULL,
1312: p_param2 => NULL,
1313: p_param3 => NULL,

Line 1342: -- for GMI items check the value in ic_item_mst_b_mig table

1338: x_failure_count := x_failure_count + 1;
1339: RETURN;
1340: END IF;
1341:
1342: -- for GMI items check the value in ic_item_mst_b_mig table
1343: IF (p_item_source = 'GMI') THEN
1344: BEGIN
1345: g_item_id := p_item_id;
1346: g_organization_id := p_organization_id;

Line 1354: FROM ic_item_mst_b_mig

1350: -- Select and lock the row to avoid errors associated with running this routine in
1351: -- parallel from routines using AD parrallel update logic.
1352: SELECT inventory_item_id, migrated_ind
1353: INTO g_inventory_item_id, l_migrated_ind
1354: FROM ic_item_mst_b_mig
1355: WHERE
1356: item_id = g_item_id AND
1357: organization_id = g_organization_id
1358: FOR UPDATE;

Line 1368: INSERT INTO ic_item_mst_b_mig(

1364: END IF;
1365: EXCEPTION
1366: WHEN NO_DATA_FOUND THEN
1367: BEGIN
1368: INSERT INTO ic_item_mst_b_mig(
1369: item_id,
1370: organization_id,
1371: inventory_item_id,
1372: migrated_ind,

Line 1397: FROM ic_item_mst_b_mig

1393:
1394: -- Lock this row for the parrallel run of this routine.
1395: SELECT 1
1396: INTO dv
1397: FROM ic_item_mst_b_mig
1398: WHERE
1399: item_id = g_item_id AND
1400: organization_id = g_organization_id
1401: FOR UPDATE;

Line 1420: FROM ic_item_mst_b_mig i

1416: -- Select and lock the row to avoid errors associated with running this routine in
1417: -- parallel from routines using AD parrallel update logic.
1418: SELECT i.migrated_ind
1419: INTO l_migrated_ind_m
1420: FROM ic_item_mst_b_mig i
1421: WHERE
1422: i.organization_id = l_master_organization_id and
1423: i.item_id = p_item_id
1424: FOR UPDATE;

Line 1430: INSERT INTO ic_item_mst_b_mig(

1426: WHEN NO_DATA_FOUND THEN
1427: -- Jatinder - 11/30/06 - Use correct organization to lock migration records. 5690686.
1428: IF (p_item_source = 'GMI') THEN
1429: BEGIN
1430: INSERT INTO ic_item_mst_b_mig(
1431: item_id,
1432: organization_id,
1433: inventory_item_id,
1434: migrated_ind,

Line 1459: FROM ic_item_mst_b_mig

1455:
1456: -- Lock this row for the parrallel run of this routine.
1457: SELECT 1
1458: INTO dv
1459: FROM ic_item_mst_b_mig
1460: WHERE
1461: item_id = p_item_id AND
1462: organization_id = l_master_organization_id
1463: FOR UPDATE;

Line 1527: p_table_name => 'IC_ITEM_MST_B',

1523: GMA_COMMON_LOGGING.gma_migration_central_log (
1524: p_run_id => p_migration_run_id,
1525: p_log_level => FND_LOG.LEVEL_ERROR,
1526: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1527: p_table_name => 'IC_ITEM_MST_B',
1528: p_context => 'ITEMS',
1529: p_param1 => NULL,
1530: p_param2 => NULL,
1531: p_param3 => NULL,

Line 1646: FROM ic_item_mst_b i, ic_item_mst_b_mig m

1642: CURSOR c_item IS
1643: SELECT m.organization_id, m.inventory_item_id, i.alt_itema,
1644: i.alt_itemb, i.match_type, i.upc_code, i.qcitem_id,
1645: i.qchold_res_code
1646: FROM ic_item_mst_b i, ic_item_mst_b_mig m
1647: WHERE
1648: i.item_id = m.item_id AND
1649: m.migrated_ind = 1;
1650:

Line 1659: p_table_name => 'IC_ITEM_MST_B',

1655: GMA_COMMON_LOGGING.gma_migration_central_log (
1656: p_run_id => p_migration_run_id,
1657: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1658: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1659: p_table_name => 'IC_ITEM_MST_B',
1660: p_context => 'ITEM OBSOLETE COLUMNS',
1661: p_param1 => NULL,
1662: p_param2 => NULL,
1663: p_param3 => NULL,

Line 1675: p_table_name => 'IC_ITEM_MST_B',

1671: GMA_COMMON_LOGGING.gma_migration_central_log (
1672: p_run_id => p_migration_run_id,
1673: p_log_level => FND_LOG.LEVEL_ERROR,
1674: p_message_token => 'GMI_MIG_INVALID_PARAMS',
1675: p_table_name => 'IC_ITEM_MST_B',
1676: p_context => 'ITEM OBSOLETE COLUMNS',
1677: p_param1 => NULL,
1678: p_param2 => NULL,
1679: p_param3 => NULL,

Line 1699: p_table_name => 'IC_ITEM_MST_B',

1695: GMA_COMMON_LOGGING.gma_migration_central_log (
1696: p_run_id => p_migration_run_id,
1697: p_log_level => FND_LOG.LEVEL_ERROR,
1698: p_message_token => 'GMI_MIG_INVALID_OBS_COL',
1699: p_table_name => 'IC_ITEM_MST_B',
1700: p_context => 'ITEM OBSOLETE COLUMNS',
1701: p_param1 => p_obsolete_column_name,
1702: p_param2 => NULL,
1703: p_param3 => NULL,

Line 1727: p_table_name => 'IC_ITEM_MST_B',

1723: GMA_COMMON_LOGGING.gma_migration_central_log (
1724: p_run_id => p_migration_run_id,
1725: p_log_level => FND_LOG.LEVEL_ERROR,
1726: p_message_token => 'GMI_MIG_COL_ALREADY_MIGRATED',
1727: p_table_name => 'IC_ITEM_MST_B',
1728: p_context => 'ITEM OBSOLETE COLUMNS',
1729: p_param1 => p_obsolete_column_name,
1730: p_param2 => NULL,
1731: p_param3 => NULL,

Line 1765: p_table_name => 'IC_ITEM_MST_B',

1761: GMA_COMMON_LOGGING.gma_migration_central_log (
1762: p_run_id => p_migration_run_id,
1763: p_log_level => FND_LOG.LEVEL_ERROR,
1764: p_message_token => 'GMI_MIG_INVALID_FLEX_COL',
1765: p_table_name => 'IC_ITEM_MST_B',
1766: p_context => 'ITEM OBSOLETE COLUMNS',
1767: p_param1 => p_flexfield_column_name,
1768: p_param2 => NULL,
1769: p_param3 => NULL,

Line 1800: p_table_name => 'IC_ITEM_MST_B',

1796: GMA_COMMON_LOGGING.gma_migration_central_log (
1797: p_run_id => p_migration_run_id,
1798: p_log_level => FND_LOG.LEVEL_ERROR,
1799: p_message_token => 'GMI_MIG_FLEX_COL_IN_USE',
1800: p_table_name => 'IC_ITEM_MST_B',
1801: p_context => 'ITEM OBSOLETE COLUMNS',
1802: p_param1 => p_flexfield_column_name,
1803: p_param2 => NULL,
1804: p_param3 => NULL,

Line 1934: p_table_name => 'IC_ITEM_MST_B',

1930: GMA_COMMON_LOGGING.gma_migration_central_log (
1931: p_run_id => p_migration_run_id,
1932: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1933: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1934: p_table_name => 'IC_ITEM_MST_B',
1935: p_context => 'ITEM OBSOLETE COLUMNS',
1936: p_param1 => l_migrate_count,
1937: p_param2 => x_failure_count,
1938: p_param3 => NULL,