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 GMA_COMMON_LOGGING

Line 285: GMA_COMMON_LOGGING.gma_migration_central_log (

281: x_msg_data => l_msg_data);
282: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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',

Line 311: GMA_COMMON_LOGGING.gma_migration_central_log (

307: EXCEPTION
308: WHEN NO_DATA_FOUND THEN
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',

Line 384: GMA_COMMON_LOGGING.gma_migration_central_log (

380: IF ( l_process_enabled_flag <> 'Y') THEN
381: IF (p_organization_type = 'C') THEN
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',

Line 542: GMA_COMMON_LOGGING.gma_migration_central_log (

538: EXCEPTION
539: WHEN NO_DATA_FOUND THEN
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',

Line 918: GMA_COMMON_LOGGING.gma_migration_central_log (

914: x_failure_count := x_failure_count + 1;
915: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
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',

Line 941: GMA_COMMON_LOGGING.gma_migration_central_log (

937: x_failure_count := x_failure_count + 1;
938: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
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',

Line 963: GMA_COMMON_LOGGING.gma_migration_central_log (

959: x_failure_count := x_failure_count + 1;
960: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
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',

Line 979: GMA_COMMON_LOGGING.gma_migration_central_log (

975: p_db_error => NULL,
976: p_app_short_name => 'FND');
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',

Line 1047: GMA_COMMON_LOGGING.gma_migration_central_log (

1043: -- Check if certain item attributes are set to be controlled at master level
1044: -- Just log error. Do not stop the migration for this 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',

Line 1165: GMA_COMMON_LOGGING.gma_migration_central_log (

1161: IF (l_opm_context is not NULL and l_odm_context is not NULL) THEN
1162: g_desc_flex_conflict := 1;
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',

Line 1188: GMA_COMMON_LOGGING.gma_migration_central_log (

1184: -- If we are here, that means we have a conflict
1185: g_desc_flex_conflict := 1;
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',

Line 1305: GMA_COMMON_LOGGING.gma_migration_central_log (

1301: (p_item_source = 'GR' and p_item_code is NULL) or
1302: p_organization_id < 1 or p_organization_id is NULL ) THEN
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',

Line 1523: GMA_COMMON_LOGGING.gma_migration_central_log (

1519: EXCEPTION
1520: WHEN OTHERS THEN
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',

Line 1655: GMA_COMMON_LOGGING.gma_migration_central_log (

1651: BEGIN
1652: x_failure_count := 0;
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',

Line 1671: GMA_COMMON_LOGGING.gma_migration_central_log (

1667: p_app_short_name => 'GMA');
1668:
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',

Line 1695: GMA_COMMON_LOGGING.gma_migration_central_log (

1691: p_obsolete_column_name <> 'QCITEM_ID' AND
1692: p_obsolete_column_name <> 'QCHOLD_RES_CODE') THEN
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',

Line 1723: GMA_COMMON_LOGGING.gma_migration_central_log (

1719: migrated_ind = 1;
1720:
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',

Line 1761: GMA_COMMON_LOGGING.gma_migration_central_log (

1757: c.column_name = p_flexfield_column_name;
1758: EXCEPTION
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',

Line 1796: GMA_COMMON_LOGGING.gma_migration_central_log (

1792: col2.application_column_name = p_flexfield_column_name;
1793:
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',

Line 1930: GMA_COMMON_LOGGING.gma_migration_central_log (

1926: END IF;
1927: END LOOP;
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',