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.GR_MIGRATE_TO_12 dependencies on FND_LOG

Line 355: p_log_level => FND_LOG.LEVEL_PROCEDURE,

351: x_failure_count := 0;
352:
353: GMA_COMMON_LOGGING.gma_migration_central_log (
354: p_run_id => P_migration_run_id,
355: p_log_level => FND_LOG.LEVEL_PROCEDURE,
356: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
357: p_table_name => 'GR_ITEM_GENERAL_MIG',
358: p_context => 'GR_ITEM_MIGRATION_TABLE',
359: p_param1 => NULL,

Line 452: p_log_level => FND_LOG.LEVEL_PROCEDURE,

448: END IF;
449:
450: GMA_COMMON_LOGGING.gma_migration_central_log (
451: p_run_id => P_migration_run_id,
452: p_log_level => FND_LOG.LEVEL_PROCEDURE,
453: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
454: p_table_name => 'GR_ITEM_GENERAL_MIG',
455: p_context => 'GR_ITEM_MIGRATION_TABLE',
456: p_param1 => l_migration_count,

Line 471: p_log_level => FND_LOG.LEVEL_ERROR,

467: WHEN NO_REG_ORG THEN
468:
469: GMA_COMMON_LOGGING.gma_migration_central_log (
470: p_run_id => P_migration_run_id,
471: p_log_level => FND_LOG.LEVEL_ERROR,
472: p_message_token => 'GR_NO_REG_ORG',
473: p_table_name => 'GR_ITEM_GENERAL_MIG',
474: p_context => 'GR_ITEM_MIGRATION_TABLE',
475: p_app_short_name => 'GMA');

Line 483: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

479: x_failure_count := x_failure_count + 1;
480:
481: GMA_COMMON_LOGGING.gma_migration_central_log (
482: p_run_id => P_migration_run_id,
483: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
484: p_message_token => 'GMA_MIGRATION_DB_ERROR',
485: p_table_name => 'GR_ITEM_GENERAL_MIG',
486: p_context => 'GR_ITEM_MIGRATION_TABLE',
487: p_param1 => NULL,

Line 497: p_log_level => FND_LOG.LEVEL_PROCEDURE,

493: p_app_short_name => 'GMA');
494:
495: GMA_COMMON_LOGGING.gma_migration_central_log (
496: p_run_id => P_migration_run_id,
497: p_log_level => FND_LOG.LEVEL_PROCEDURE,
498: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
499: p_table_name => 'GR_ITEM_GENERAL_MIG',
500: p_context => 'GR_ITEM_MIGRATION_TABLE',
501: p_param1 => x_failure_count,

Line 641: p_log_level => FND_LOG.LEVEL_PROCEDURE,

637: x_failure_count := 0;
638:
639: GMA_COMMON_LOGGING.gma_migration_central_log (
640: p_run_id => P_migration_run_id,
641: p_log_level => FND_LOG.LEVEL_PROCEDURE,
642: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
643: p_table_name => 'GR_ITEM_GENERAL',
644: p_context => 'REGULATORY_ITEMS',
645: p_param1 => NULL,

Line 662: p_log_level => FND_LOG.LEVEL_PROCEDURE,

658: IF c_get_mig_rec%NOTFOUND THEN
659:
660: GMA_COMMON_LOGGING.gma_migration_central_log (
661: p_run_id => P_migration_run_id,
662: p_log_level => FND_LOG.LEVEL_PROCEDURE,
663: p_message_token => 'GR_NO_REGITEMS_TO_MIG',
664: p_table_name => 'GR_ITEM_GENERAL',
665: p_context => 'REGULATORY_ITEMS',
666: p_param1 => NULL,

Line 717: p_log_level => FND_LOG.LEVEL_PROCEDURE,

713: -- x_failure_count := x_failure_count + 1; -- 14067151
714:
715: GMA_COMMON_LOGGING.gma_migration_central_log (
716: p_run_id => P_migration_run_id,
717: p_log_level => FND_LOG.LEVEL_PROCEDURE,
718: p_message_token => 'GR_NO_CAS_NUMBER',
719: p_table_name => 'GR_ITEM_GENERAL',
720: p_context => 'Migrate_regulatory_items',
721: p_param1 => l_reg_item_rec.item_code,

Line 760: p_log_level => FND_LOG.LEVEL_PROCEDURE,

756: ELSE
757:
758: GMA_COMMON_LOGGING.gma_migration_central_log (
759: p_run_id => P_migration_run_id,
760: p_log_level => FND_LOG.LEVEL_PROCEDURE,
761: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
762: p_table_name => 'GR_ITEM_GENERAL',
763: p_context => 'REGULATORY_ITEMS',
764: p_param1 => NULL,

Line 1083: p_log_level => FND_LOG.LEVEL_EXCEPTION,

1079: WHEN INVALID_REG_ITEM THEN
1080: x_failure_count := x_failure_count + 1;
1081: GMA_COMMON_LOGGING.gma_migration_central_log (
1082: p_run_id => P_migration_run_id,
1083: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1084: p_message_token => 'GR_INVALID_REG_ITEM',
1085: p_table_name => 'GR_ITEM_GENERAL',
1086: p_context => 'REGULATORY_ITEMS',
1087: p_param1 => l_mig_rec.item_code,

Line 1101: p_log_level => FND_LOG.LEVEL_EXCEPTION,

1097: WHEN NO_CAS_NUMBER THEN
1098: x_failure_count := x_failure_count + 1;
1099: GMA_COMMON_LOGGING.gma_migration_central_log (
1100: p_run_id => P_migration_run_id,
1101: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1102: p_message_token => 'GR_NO_CAS_NUMBER',
1103: p_table_name => 'GR_ITEM_GENERAL',
1104: p_context => 'REGULATORY_ITEMS',
1105: p_param1 => l_mig_rec.item_code,

Line 1120: p_log_level => FND_LOG.LEVEL_EXCEPTION,

1116: WHEN ITEM_CREATE_ERROR THEN
1117: x_failure_count := x_failure_count + 1;
1118: GMA_COMMON_LOGGING.gma_migration_central_log (
1119: p_run_id => P_migration_run_id,
1120: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1121: p_message_token => 'GR_INV_ITEM_ERROR',
1122: p_table_name => 'GR_ITEM_GENERAL',
1123: p_context => 'REGULATORY_ITEMS',
1124: p_param1 => l_mig_rec.item_code,

Line 1138: p_log_level => FND_LOG.LEVEL_EXCEPTION,

1134: WHEN PROC_CALL_ERROR THEN
1135: x_failure_count := x_failure_count + 1;
1136: GMA_COMMON_LOGGING.gma_migration_central_log (
1137: p_run_id => P_migration_run_id,
1138: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1139: p_message_token => l_msg_data,
1140: p_table_name => 'GR_ITEM_GENERAL',
1141: p_context => 'REGULATORY_ITEMS',
1142: p_param1 => NULL,

Line 1156: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

1152: WHEN OTHERS THEN
1153: x_failure_count := x_failure_count + 1;
1154: GMA_COMMON_LOGGING.gma_migration_central_log (
1155: p_run_id => P_migration_run_id,
1156: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1157: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1158: p_table_name => 'GR_ITEM_GENERAL',
1159: p_context => 'REGULATORY_ITEMS',
1160: p_param1 => NULL,

Line 1181: p_log_level => FND_LOG.LEVEL_PROCEDURE,

1177: END IF; -- Unmigrated records found
1178:
1179: GMA_COMMON_LOGGING.gma_migration_central_log (
1180: p_run_id => P_migration_run_id,
1181: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1182: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1183: p_table_name => 'GR_ITEM_GENERAL',
1184: p_context => 'REGULATORY_ITEMS',
1185: p_param1 => l_migration_count,

Line 1198: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

1194: WHEN OTHERS THEN
1195: x_failure_count := x_failure_count + 1;
1196: GMA_COMMON_LOGGING.gma_migration_central_log (
1197: p_run_id => P_migration_run_id,
1198: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1199: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1200: p_table_name => 'GR_ITEM_GENERAL',
1201: p_context => 'REGULATORY_ITEMS',
1202: p_param1 => NULL,

Line 1212: p_log_level => FND_LOG.LEVEL_PROCEDURE,

1208: p_app_short_name => 'GMA');
1209:
1210: GMA_COMMON_LOGGING.gma_migration_central_log (
1211: p_run_id => P_migration_run_id,
1212: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1213: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
1214: p_table_name => 'GR_ITEM_GENERAL',
1215: p_context => 'REGULATORY_ITEMS',
1216: p_param1 => x_failure_count,

Line 1375: p_log_level => FND_LOG.LEVEL_PROCEDURE,

1371: x_failure_count := 0;
1372:
1373: GMA_COMMON_LOGGING.gma_migration_central_log (
1374: p_run_id => P_migration_run_id,
1375: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1376: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1377: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1378: p_context => 'STANDALONE_FORMULAS',
1379: p_param1 => NULL,

Line 1861: p_log_level => FND_LOG.LEVEL_EXCEPTION,

1857: x_failure_count := x_failure_count + 1;
1858:
1859: GMA_COMMON_LOGGING.gma_migration_central_log (
1860: p_run_id => P_migration_run_id,
1861: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1862: p_message_token => l_msg_data,
1863: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1864: p_context => 'STANDALONE_FORMULAS',
1865: p_param1 => NULL,

Line 1880: p_log_level => FND_LOG.LEVEL_EXCEPTION,

1876: x_failure_count := x_failure_count + 1;
1877:
1878: GMA_COMMON_LOGGING.gma_migration_central_log (
1879: p_run_id => P_migration_run_id,
1880: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1881: p_message_token => l_msg_data,
1882: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1883: p_context => 'STANDALONE_FORMULAS',
1884: p_param1 => NULL,

Line 1897: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

1893: x_failure_count := x_failure_count + 1;
1894:
1895: GMA_COMMON_LOGGING.gma_migration_central_log (
1896: p_run_id => P_migration_run_id,
1897: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1898: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1899: p_table_name => 'PO_HAZARD_CLASSES',
1900: p_context => 'HAZARD_CLASSES',
1901: p_param1 => NULL,

Line 1919: p_log_level => FND_LOG.LEVEL_PROCEDURE,

1915: CLOSE c_get_items;
1916:
1917: GMA_COMMON_LOGGING.gma_migration_central_log (
1918: p_run_id => P_migration_run_id,
1919: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1920: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1921: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1922: p_context => 'STANDALONE_FORMULAS',
1923: p_param1 => l_migration_count,

Line 1937: p_log_level => FND_LOG.LEVEL_ERROR,

1933: WHEN ORGN_NOT_MIGRATED THEN
1934: x_failure_count := x_failure_count + l_failure_count;
1935: GMA_COMMON_LOGGING.gma_migration_central_log (
1936: p_run_id => P_migration_run_id,
1937: p_log_level => FND_LOG.LEVEL_ERROR,
1938: p_message_token => 'GMA_ORG_NOT_MIGRATED',
1939: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1940: p_context => 'STANDALONE_FORMULAS',
1941: p_token1 => 'ORGANIZATION',

Line 1950: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

1946: x_failure_count := x_failure_count + 1;
1947:
1948: GMA_COMMON_LOGGING.gma_migration_central_log (
1949: p_run_id => P_migration_run_id,
1950: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1951: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1952: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1953: p_context => 'STANDALONE_FORMULAS',
1954: p_param1 => NULL,

Line 1964: p_log_level => FND_LOG.LEVEL_PROCEDURE,

1960: p_app_short_name => 'GMA');
1961:
1962: GMA_COMMON_LOGGING.gma_migration_central_log (
1963: p_run_id => P_migration_run_id,
1964: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1965: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
1966: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1967: p_context => 'STANDALONE_FORMULAS',
1968: p_param1 => x_failure_count,

Line 2059: p_log_level => FND_LOG.LEVEL_PROCEDURE,

2055: x_failure_count := 0;
2056:
2057: GMA_COMMON_LOGGING.gma_migration_central_log (
2058: p_run_id => P_migration_run_id,
2059: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2060: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
2061: p_table_name => 'GR_DISPATCH_HISTORY',
2062: p_context => 'UPDATE_DISPATCH_HISTORY',
2063: p_param1 => NULL,

Line 2135: p_log_level => FND_LOG.LEVEL_EXCEPTION,

2131: x_failure_count := x_failure_count + 1;
2132:
2133: GMA_COMMON_LOGGING.gma_migration_central_log (
2134: p_run_id => P_migration_run_id,
2135: p_log_level => FND_LOG.LEVEL_EXCEPTION,
2136: p_message_token => 'GR_INVALID_ORG_ITEM',
2137: p_table_name => 'GR_DISPATCH_HISTORY',
2138: p_context => 'UPDATE_DISPATCH_HISTORY',
2139: p_param1 => l_org_id,

Line 2152: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

2148: x_failure_count := x_failure_count + 1;
2149:
2150: GMA_COMMON_LOGGING.gma_migration_central_log (
2151: p_run_id => P_migration_run_id,
2152: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
2153: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2154: p_table_name => 'GR_DISPATCH_HISTORY',
2155: p_context => 'UPDATE_DISPATCH_HISTORY',
2156: p_param1 => NULL,

Line 2174: p_log_level => FND_LOG.LEVEL_PROCEDURE,

2170: CLOSE c_get_disp_rec;
2171:
2172: GMA_COMMON_LOGGING.gma_migration_central_log (
2173: p_run_id => P_migration_run_id,
2174: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2175: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
2176: p_table_name => 'GR_DISPATCH_HISTORY',
2177: p_context => 'UPDATE_DISPATCH_HISTORY',
2178: p_param1 => l_migration_count,

Line 2192: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

2188: x_failure_count := x_failure_count + 1;
2189:
2190: GMA_COMMON_LOGGING.gma_migration_central_log (
2191: p_run_id => P_migration_run_id,
2192: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
2193: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2194: p_table_name => 'GR_DISPATCH_HISTORY',
2195: p_context => 'UPDATE_DISPATCH_HISTORY',
2196: p_param1 => NULL,

Line 2206: p_log_level => FND_LOG.LEVEL_PROCEDURE,

2202: p_app_short_name => 'GMA');
2203:
2204: GMA_COMMON_LOGGING.gma_migration_central_log (
2205: p_run_id => P_migration_run_id,
2206: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2207: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
2208: p_table_name => 'GR_DISPATCH_HISTORY',
2209: p_context => 'UPDATE_DISPATCH_HISTORY',
2210: p_param1 => x_failure_count,