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 312: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 338: GMA_COMMON_LOGGING.gma_migration_central_log (

334: EXCEPTION
335: WHEN NO_DATA_FOUND THEN
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',

Line 454: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 619: GMA_COMMON_LOGGING.gma_migration_central_log (

615: EXCEPTION
616: WHEN NO_DATA_FOUND THEN
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',

Line 1005: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1028: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1050: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1066: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1134: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1252: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1275: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1392: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1621: GMA_COMMON_LOGGING.gma_migration_central_log (

1617: EXCEPTION
1618: WHEN OTHERS THEN
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',

Line 1753: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1769: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1793: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1821: GMA_COMMON_LOGGING.gma_migration_central_log (

1817: migrated_ind = 1;
1818:
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',

Line 1859: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1894: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 2028: GMA_COMMON_LOGGING.gma_migration_central_log (

2024: END IF;
2025: END LOOP;
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',

Line 2145: GMA_COMMON_LOGGING.gma_migration_central_log (

2141: l_failure_count2 := l_failure_count2 + 1 ;
2142:
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',

Line 2176: GMA_COMMON_LOGGING.gma_migration_central_log (

2172: END ;
2173:
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',