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 287: p_log_level => FND_LOG.LEVEL_ERROR,

283: -- Log error
284: -- dbms_output.put_line ('Invalid Regulatory Item :' || p_item_code);
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',

Line 313: p_log_level => FND_LOG.LEVEL_ERROR,

309: -- Log error
310: -- dbms_output.put_line ('Invalid item id' || to_char(p_item_id));
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),

Line 386: p_log_level => FND_LOG.LEVEL_ERROR,

382: -- Log Error
383: -- dbms_output.put_line ('Cannot migrate discrete organization');
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),

Line 544: p_log_level => FND_LOG.LEVEL_ERROR,

540: -- Log error for l_field_name
541: -- dbms_output.put_line ('Could not find '||l_field_name||' for '||l_field_value);
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,

Line 920: p_log_level => FND_LOG.LEVEL_ERROR,

916: FOR i in 1..l_msg_count LOOP
917: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
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',

Line 943: p_log_level => FND_LOG.LEVEL_ERROR,

939: FOR i in 1..l_msg_count LOOP
940: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
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',

Line 965: p_log_level => FND_LOG.LEVEL_ERROR,

961: FOR i in 1..l_msg_count LOOP
962: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
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',

Line 981: p_log_level => FND_LOG.LEVEL_ERROR,

977: END LOOP;
978: -- dbms_output.put_line (substr(SQLERRM,1,255));
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,

Line 1049: p_log_level => FND_LOG.LEVEL_ERROR,

1045: FOR ia IN c_master_attributes LOOP
1046: -- 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');
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,

Line 1167: p_log_level => FND_LOG.LEVEL_ERROR,

1163: -- Log Error
1164: -- dbms_output.put_line ('Desc flexfield conflict. OPM context: '|| l_opm_context ||', ODM context: '|| l_odm_context);
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,

Line 1190: p_log_level => FND_LOG.LEVEL_ERROR,

1186:
1187: -- dbms_output.put_line ('Desc flexfield column conflict.');
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,

Line 1307: p_log_level => FND_LOG.LEVEL_ERROR,

1303: -- Log validation error
1304: -- dbms_output.put_line ('Invalid parameters for item migration');
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,

Line 1525: p_log_level => FND_LOG.LEVEL_ERROR,

1521: x_failure_count := x_failure_count + 1;
1522: -- dbms_output.put_line (substr(SQLERRM,1,255));
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,

Line 1657: p_log_level => FND_LOG.LEVEL_PROCEDURE,

1653: l_migrate_count := 0;
1654: -- dbms_output.put_line ('Started ITEM OBSOLETE COLUMNS migration');
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,

Line 1673: p_log_level => FND_LOG.LEVEL_ERROR,

1669: IF (p_obsolete_column_name is NULL or p_flexfield_column_name is NULL) THEN
1670: -- dbms_output.put_line ('Invalid parameters for obsolete column migration');
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,

Line 1697: p_log_level => FND_LOG.LEVEL_ERROR,

1693:
1694: -- dbms_output.put_line ('Invalid value for the obsolete column :' || p_obsolete_column_name);
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,

Line 1725: p_log_level => FND_LOG.LEVEL_ERROR,

1721: IF ( l_flexfield_column_name <> p_flexfield_column_name ) THEN
1722: -- dbms_output.put_line ('Obsolete column already migrated to different flexfield column :' || l_flexfield_column_name);
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,

Line 1763: p_log_level => FND_LOG.LEVEL_ERROR,

1759: WHEN NO_DATA_FOUND THEN
1760: -- dbms_output.put_line ('Invalid value for the flexfield column :' || p_flexfield_column_name);
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,

Line 1798: p_log_level => FND_LOG.LEVEL_ERROR,

1794: IF (l_end_user_column_name <> p_obsolete_column_name) THEN
1795: -- dbms_output.put_line ('Flexfield column is already in use : '||p_flexfield_column_name);
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,

Line 1932: p_log_level => FND_LOG.LEVEL_PROCEDURE,

1928:
1929: -- dbms_output.put_line ('Completed ITEM OBSOLETE COLUMNS migration. Migrated = '||to_char(l_migrate_count)||', Failed = '||to_char(x_failure_count));
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,