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 FND_LOG

Line 314: p_log_level => FND_LOG.LEVEL_ERROR,

310: -- Log error
311: -- dbms_output.put_line ('Invalid Regulatory Item :' || p_item_code);
312: GMA_COMMON_LOGGING.gma_migration_central_log (
313: p_run_id => p_migration_run_id,
314: p_log_level => FND_LOG.LEVEL_ERROR,
315: p_message_token => 'GMI_UNEXPECTED_ERROR',
316: p_table_name => 'IC_ITEM_MST_B',
317: p_context => 'ITEMS',
318: p_token1 => 'ERROR',

Line 340: p_log_level => FND_LOG.LEVEL_ERROR,

336: -- Log error
337: -- dbms_output.put_line ('Invalid item id' || to_char(p_item_id));
338: GMA_COMMON_LOGGING.gma_migration_central_log (
339: p_run_id => p_migration_run_id,
340: p_log_level => FND_LOG.LEVEL_ERROR,
341: p_message_token => 'GMI_MIG_INVALID_ITEM_ID',
342: p_table_name => 'IC_ITEM_MST_B',
343: p_context => 'ITEMS',
344: p_param1 => INV_GMI_Migration.item(p_item_id),

Line 456: p_log_level => FND_LOG.LEVEL_ERROR,

452: -- Log Error
453: -- dbms_output.put_line ('Cannot migrate discrete organization');
454: GMA_COMMON_LOGGING.gma_migration_central_log (
455: p_run_id => p_migration_run_id,
456: p_log_level => FND_LOG.LEVEL_ERROR,
457: p_message_token => 'GMI_MIG_DISCRETE_ORG',
458: p_table_name => 'IC_ITEM_MST_B',
459: p_context => 'ITEMS',
460: p_param1 => INV_GMI_Migration.org(p_organization_id),

Line 621: p_log_level => FND_LOG.LEVEL_ERROR,

617: -- Log error for l_field_name
618: -- dbms_output.put_line ('Could not find '||l_field_name||' for '||l_field_value);
619: GMA_COMMON_LOGGING.gma_migration_central_log (
620: p_run_id => p_migration_run_id,
621: p_log_level => FND_LOG.LEVEL_ERROR,
622: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
623: p_table_name => 'IC_ITEM_MST_B',
624: p_context => 'ITEMS',
625: p_param1 => l_field_name,

Line 1007: p_log_level => FND_LOG.LEVEL_ERROR,

1003: FOR i in 1..l_msg_count LOOP
1004: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
1005: GMA_COMMON_LOGGING.gma_migration_central_log (
1006: p_run_id => p_migration_run_id,
1007: p_log_level => FND_LOG.LEVEL_ERROR,
1008: p_message_token => 'GMI_UNEXPECTED_ERROR',
1009: p_table_name => 'IC_ITEM_MST_B',
1010: p_context => 'ITEMS',
1011: p_token1 => 'ERROR',

Line 1030: p_log_level => FND_LOG.LEVEL_ERROR,

1026: FOR i in 1..l_msg_count LOOP
1027: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
1028: GMA_COMMON_LOGGING.gma_migration_central_log (
1029: p_run_id => p_migration_run_id,
1030: p_log_level => FND_LOG.LEVEL_ERROR,
1031: p_message_token => 'GMI_UNEXPECTED_ERROR',
1032: p_table_name => 'IC_ITEM_MST_B',
1033: p_context => 'ITEMS',
1034: p_token1 => 'ERROR',

Line 1052: p_log_level => FND_LOG.LEVEL_ERROR,

1048: FOR i in 1..l_msg_count LOOP
1049: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
1050: GMA_COMMON_LOGGING.gma_migration_central_log (
1051: p_run_id => p_migration_run_id,
1052: p_log_level => FND_LOG.LEVEL_ERROR,
1053: p_message_token => 'GMI_UNEXPECTED_ERROR',
1054: p_table_name => 'IC_ITEM_MST_B',
1055: p_context => 'ITEMS',
1056: p_token1 => 'ERROR',

Line 1068: p_log_level => FND_LOG.LEVEL_ERROR,

1064: END LOOP;
1065: -- dbms_output.put_line (substr(SQLERRM,1,255));
1066: GMA_COMMON_LOGGING.gma_migration_central_log (
1067: p_run_id => p_migration_run_id,
1068: p_log_level => FND_LOG.LEVEL_ERROR,
1069: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1070: p_table_name => 'IC_ITEM_MST_B',
1071: p_context => 'ITEMS',
1072: p_param1 => NULL,

Line 1136: p_log_level => FND_LOG.LEVEL_ERROR,

1132: FOR ia IN c_master_attributes LOOP
1133: -- dbms_output.put_line ('Attribute '|| ia.attribute_name || ' is controlled at master organization level and may result in migration issues if the attribute values are different for process and discrete organization');
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_ITEM_ATTRIBUTE',
1138: p_table_name => 'IC_ITEM_MST_B',
1139: p_context => 'ITEMS',
1140: p_param1 => ia.attribute_name,

Line 1254: p_log_level => FND_LOG.LEVEL_ERROR,

1250: -- Log Error
1251: -- dbms_output.put_line ('Desc flexfield conflict. OPM context: '|| l_opm_context ||', ODM context: '|| l_odm_context);
1252: GMA_COMMON_LOGGING.gma_migration_central_log (
1253: p_run_id => p_migration_run_id,
1254: p_log_level => FND_LOG.LEVEL_ERROR,
1255: p_message_token => 'GMI_MIG_DFLEX_CONTEXT_CONFLICT',
1256: p_table_name => 'IC_ITEM_MST_B',
1257: p_context => 'ITEMS',
1258: p_param1 => l_opm_context,

Line 1277: p_log_level => FND_LOG.LEVEL_ERROR,

1273:
1274: -- dbms_output.put_line ('Desc flexfield column conflict.');
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_DFLEX_COL_CONFLICT',
1279: p_table_name => 'IC_ITEM_MST_B',
1280: p_context => 'ITEMS',
1281: p_param1 => conflict_columns.descriptive_flex_context_code,

Line 1394: p_log_level => FND_LOG.LEVEL_ERROR,

1390: -- Log validation error
1391: -- dbms_output.put_line ('Invalid parameters for item migration');
1392: GMA_COMMON_LOGGING.gma_migration_central_log (
1393: p_run_id => p_migration_run_id,
1394: p_log_level => FND_LOG.LEVEL_ERROR,
1395: p_message_token => 'GMI_MIG_INVALID_PARAMS',
1396: p_table_name => 'IC_ITEM_MST_B',
1397: p_context => 'ITEMS',
1398: p_param1 => NULL,

Line 1623: p_log_level => FND_LOG.LEVEL_ERROR,

1619: x_failure_count := x_failure_count + 1;
1620: -- dbms_output.put_line (substr(SQLERRM,1,255));
1621: GMA_COMMON_LOGGING.gma_migration_central_log (
1622: p_run_id => p_migration_run_id,
1623: p_log_level => FND_LOG.LEVEL_ERROR,
1624: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1625: p_table_name => 'IC_ITEM_MST_B',
1626: p_context => 'ITEMS',
1627: p_param1 => NULL,

Line 1755: p_log_level => FND_LOG.LEVEL_PROCEDURE,

1751: l_migrate_count := 0;
1752: -- dbms_output.put_line ('Started ITEM OBSOLETE COLUMNS migration');
1753: GMA_COMMON_LOGGING.gma_migration_central_log (
1754: p_run_id => p_migration_run_id,
1755: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1756: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1757: p_table_name => 'IC_ITEM_MST_B',
1758: p_context => 'ITEM OBSOLETE COLUMNS',
1759: p_param1 => NULL,

Line 1771: p_log_level => FND_LOG.LEVEL_ERROR,

1767: IF (p_obsolete_column_name is NULL or p_flexfield_column_name is NULL) THEN
1768: -- dbms_output.put_line ('Invalid parameters for obsolete column migration');
1769: GMA_COMMON_LOGGING.gma_migration_central_log (
1770: p_run_id => p_migration_run_id,
1771: p_log_level => FND_LOG.LEVEL_ERROR,
1772: p_message_token => 'GMI_MIG_INVALID_PARAMS',
1773: p_table_name => 'IC_ITEM_MST_B',
1774: p_context => 'ITEM OBSOLETE COLUMNS',
1775: p_param1 => NULL,

Line 1795: p_log_level => FND_LOG.LEVEL_ERROR,

1791:
1792: -- dbms_output.put_line ('Invalid value for the obsolete column :' || p_obsolete_column_name);
1793: GMA_COMMON_LOGGING.gma_migration_central_log (
1794: p_run_id => p_migration_run_id,
1795: p_log_level => FND_LOG.LEVEL_ERROR,
1796: p_message_token => 'GMI_MIG_INVALID_OBS_COL',
1797: p_table_name => 'IC_ITEM_MST_B',
1798: p_context => 'ITEM OBSOLETE COLUMNS',
1799: p_param1 => p_obsolete_column_name,

Line 1823: p_log_level => FND_LOG.LEVEL_ERROR,

1819: IF ( l_flexfield_column_name <> p_flexfield_column_name ) THEN
1820: -- dbms_output.put_line ('Obsolete column already migrated to different flexfield column :' || l_flexfield_column_name);
1821: GMA_COMMON_LOGGING.gma_migration_central_log (
1822: p_run_id => p_migration_run_id,
1823: p_log_level => FND_LOG.LEVEL_ERROR,
1824: p_message_token => 'GMI_MIG_COL_ALREADY_MIGRATED',
1825: p_table_name => 'IC_ITEM_MST_B',
1826: p_context => 'ITEM OBSOLETE COLUMNS',
1827: p_param1 => p_obsolete_column_name,

Line 1861: p_log_level => FND_LOG.LEVEL_ERROR,

1857: WHEN NO_DATA_FOUND THEN
1858: -- dbms_output.put_line ('Invalid value for the flexfield column :' || p_flexfield_column_name);
1859: GMA_COMMON_LOGGING.gma_migration_central_log (
1860: p_run_id => p_migration_run_id,
1861: p_log_level => FND_LOG.LEVEL_ERROR,
1862: p_message_token => 'GMI_MIG_INVALID_FLEX_COL',
1863: p_table_name => 'IC_ITEM_MST_B',
1864: p_context => 'ITEM OBSOLETE COLUMNS',
1865: p_param1 => p_flexfield_column_name,

Line 1896: p_log_level => FND_LOG.LEVEL_ERROR,

1892: IF (l_end_user_column_name <> p_obsolete_column_name) THEN
1893: -- dbms_output.put_line ('Flexfield column is already in use : '||p_flexfield_column_name);
1894: GMA_COMMON_LOGGING.gma_migration_central_log (
1895: p_run_id => p_migration_run_id,
1896: p_log_level => FND_LOG.LEVEL_ERROR,
1897: p_message_token => 'GMI_MIG_FLEX_COL_IN_USE',
1898: p_table_name => 'IC_ITEM_MST_B',
1899: p_context => 'ITEM OBSOLETE COLUMNS',
1900: p_param1 => p_flexfield_column_name,

Line 2030: p_log_level => FND_LOG.LEVEL_PROCEDURE,

2026:
2027: -- dbms_output.put_line ('Completed ITEM OBSOLETE COLUMNS migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
2028: GMA_COMMON_LOGGING.gma_migration_central_log (
2029: p_run_id => p_migration_run_id,
2030: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2031: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
2032: p_table_name => 'IC_ITEM_MST_B',
2033: p_context => 'ITEM OBSOLETE COLUMNS',
2034: p_param1 => l_migrate_count,

Line 2147: p_log_level => FND_LOG.LEVEL_ERROR,

2143: -- Log Error
2144: -- dbms_output.put_line ('Item migration failed for Item id : '||to_char(p_item_id));
2145: GMA_COMMON_LOGGING.gma_migration_central_log (
2146: p_run_id => l_migration_run_id,
2147: p_log_level => FND_LOG.LEVEL_ERROR,
2148: p_message_token => 'GMI_MIG_ITEM_MIG_FAILED',
2149: p_table_name => 'IC_ITEM_MST_B',
2150: p_context => 'ITEMS',
2151: p_param1 => INV_GMI_Migration.org(cr_missing_items_rec.organization_id),

Line 2178: p_log_level => FND_LOG.LEVEL_PROCEDURE,

2174: END LOOP ;
2175:
2176: GMA_COMMON_LOGGING.gma_migration_central_log (
2177: p_run_id => l_migration_run_id,
2178: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2179: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
2180: p_table_name => 'IC_ITEM_MST_B',
2181: p_context => 'ITEMS',
2182: p_param1 => l_migrate_count,