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_LOT_MIGRATION dependencies on FND_LOG

Line 147: p_log_level => FND_LOG.LEVEL_ERROR,

143: -- Log error
144: -- dbms_output.put_line ('Invalid Lot id : '||to_char(p_lot_id));
145: GMA_COMMON_LOGGING.gma_migration_central_log (
146: p_run_id => p_migration_run_id,
147: p_log_level => FND_LOG.LEVEL_ERROR,
148: p_message_token => 'GMI_MIG_INVALID_LOT_ID',
149: p_table_name => 'IC_LOTS_MST',
150: p_context => 'LOTS',
151: p_param1 => INV_GMI_Migration.lot(p_lot_id),

Line 177: p_log_level => FND_LOG.LEVEL_ERROR,

173: -- Log Error
174: -- dbms_output.put_line ('Item migration failed for Item id : '||to_char(p_item_id));
175: GMA_COMMON_LOGGING.gma_migration_central_log (
176: p_run_id => p_migration_run_id,
177: p_log_level => FND_LOG.LEVEL_ERROR,
178: p_message_token => 'GMI_MIG_ITEM_MIG_FAILED',
179: p_table_name => 'IC_LOTS_MST',
180: p_context => 'LOTS',
181: p_param1 => INV_GMI_Migration.org(p_organization_id),

Line 306: p_log_level => FND_LOG.LEVEL_ERROR,

302: WHEN NO_DATA_FOUND THEN
303: -- dbms_output.put_line ('Could not find '||l_field_name||' for '||l_field_value);
304: GMA_COMMON_LOGGING.gma_migration_central_log (
305: p_run_id => p_migration_run_id,
306: p_log_level => FND_LOG.LEVEL_ERROR,
307: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
308: p_table_name => 'IC_LOTS_MST',
309: p_context => 'LOTS',
310: p_param1 => l_field_name,

Line 413: p_log_level => FND_LOG.LEVEL_PROCEDURE,

409: -- Log error (warning)
410: -- dbms_output.put_line ('Lot already exists for org id, item id, lot num : '||to_char(p_organization_id)||', '||to_char(l_inventory_item_id)||', '||x_lot_number);
411: GMA_COMMON_LOGGING.gma_migration_central_log (
412: p_run_id => p_migration_run_id,
413: p_log_level => FND_LOG.LEVEL_PROCEDURE,
414: p_message_token => 'GMI_MIG_LOT_ALREADY_EXISTS',
415: p_table_name => 'IC_LOTS_MST',
416: p_context => 'LOTS',
417: p_param1 => INV_GMI_Migration.org(p_organization_id),

Line 445: p_log_level => FND_LOG.LEVEL_ERROR,

441: FOR i in 1..l_msg_count LOOP
442: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
443: GMA_COMMON_LOGGING.gma_migration_central_log (
444: p_run_id => p_migration_run_id,
445: p_log_level => FND_LOG.LEVEL_ERROR,
446: p_message_token => 'GMI_UNEXPECTED_ERROR',
447: p_table_name => 'IC_LOTS_MST',
448: p_context => 'LOTS',
449: p_token1 => 'ERROR',

Line 603: p_log_level => FND_LOG.LEVEL_ERROR,

599: -- Log Error
600: -- dbms_output.put_line ('Desc flexfield conflict. OPM context: '|| l_opm_context ||', ODM context: '|| l_odm_context);
601: GMA_COMMON_LOGGING.gma_migration_central_log (
602: p_run_id => p_migration_run_id,
603: p_log_level => FND_LOG.LEVEL_ERROR,
604: p_message_token => 'GMI_MIG_DFLEX_CONTEXT_CONFLICT',
605: p_table_name => 'IC_LOTS_MST',
606: p_context => 'LOTS',
607: p_param1 => l_opm_context,

Line 626: p_log_level => FND_LOG.LEVEL_ERROR,

622:
623: -- dbms_output.put_line ('Desc flexfield column conflict.');
624: GMA_COMMON_LOGGING.gma_migration_central_log (
625: p_run_id => p_migration_run_id,
626: p_log_level => FND_LOG.LEVEL_ERROR,
627: p_message_token => 'GMI_MIG_DFLEX_CONTEXT_CONFLICT',
628: p_table_name => 'IC_LOTS_MST',
629: p_context => 'LOTS',
630: p_param1 => conflict_columns.descriptive_flex_context_code,

Line 793: p_log_level => FND_LOG.LEVEL_ERROR,

789: -- Log Error
790: -- dbms_output.put_line ('Warehouse for the orgnization and loctor id do not match. org id, org_whse, locator id, whse :'||to_char(p_organization_id)||', '||l_whse_code||', '||to_char(p_locator_id)||', '||l_location_whse);
791: GMA_COMMON_LOGGING.gma_migration_central_log (
792: p_run_id => p_migration_run_id,
793: p_log_level => FND_LOG.LEVEL_ERROR,
794: p_message_token => 'GMI_MIG_DIFF_ORG_LOC_WHSE',
795: p_table_name => 'IC_LOTS_MST',
796: p_context => 'LOTS',
797: p_param1 => INV_GMI_Migration.org(p_organization_id),

Line 826: p_log_level => FND_LOG.LEVEL_ERROR,

822: WHEN NO_DATA_FOUND THEN
823: -- dbms_output.put_line ('Could not find '||l_field_name||' for '||l_field_value);
824: GMA_COMMON_LOGGING.gma_migration_central_log (
825: p_run_id => p_migration_run_id,
826: p_log_level => FND_LOG.LEVEL_ERROR,
827: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
828: p_table_name => 'IC_LOTS_MST',
829: p_context => 'LOTS',
830: p_param1 => l_field_name,

Line 933: p_log_level => FND_LOG.LEVEL_ERROR,

929: -- Log error
930: -- dbms_output.put_line ('Invalid OPM lot. Item id, lot no, sublot no : '||to_char(p_item_id)||', '||p_lot_no||', '||p_sublot_no);
931: GMA_COMMON_LOGGING.gma_migration_central_log (
932: p_run_id => p_migration_run_id,
933: p_log_level => FND_LOG.LEVEL_ERROR,
934: p_message_token => 'GMI_MIG_INVALID_LOT',
935: p_table_name => 'IC_LOTS_MST',
936: p_context => 'LOTS',
937: p_param1 => p_lot_no,

Line 962: p_log_level => FND_LOG.LEVEL_ERROR,

958: -- Log error
959: -- dbms_output.put_line ('No parent lot found for item id, whse_code, lot no : '||to_char(p_item_id)||', '||p_whse_code||', '||p_lot_no);
960: GMA_COMMON_LOGGING.gma_migration_central_log (
961: p_run_id => p_migration_run_id,
962: p_log_level => FND_LOG.LEVEL_ERROR,
963: p_message_token => 'GMI_MIG_NO_PARENT_LOT',
964: p_table_name => 'IC_LOTS_MST',
965: p_context => 'LOTS',
966: p_param1 => INV_GMI_Migration.item(p_item_id),

Line 1061: p_log_level => FND_LOG.LEVEL_ERROR,

1057: -- Log validation error
1058: -- dbms_output.put_line ('Invalid parameters');
1059: GMA_COMMON_LOGGING.gma_migration_central_log (
1060: p_run_id => p_migration_run_id,
1061: p_log_level => FND_LOG.LEVEL_ERROR,
1062: p_message_token => 'GMI_MIG_INVALID_PARAMS',
1063: p_table_name => 'IC_LOTS_MST',
1064: p_context => 'LOTS',
1065: p_param1 => NULL,

Line 1116: p_log_level => FND_LOG.LEVEL_ERROR,

1112: -- Log error
1113: -- dbms_output.put_line ('Warehouse not migrated : '||p_whse_code);
1114: GMA_COMMON_LOGGING.gma_migration_central_log (
1115: p_run_id => p_migration_run_id,
1116: p_log_level => FND_LOG.LEVEL_ERROR,
1117: p_message_token => 'GMI_MIG_WHSE_NOT_MIGRATED',
1118: p_table_name => 'IC_LOTS_MST',
1119: p_context => 'LOTS',
1120: p_param1 => p_whse_code,

Line 1136: p_log_level => FND_LOG.LEVEL_ERROR,

1132: -- Log error
1133: -- dbms_output.put_line ('Invalid warehouse : '||p_whse_code);
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_INVALID_WHSE',
1138: p_table_name => 'IC_LOTS_MST',
1139: p_context => 'LOTS',
1140: p_param1 => p_whse_code,

Line 1163: p_log_level => FND_LOG.LEVEL_ERROR,

1159: -- Log error
1160: -- dbms_output.put_line ('Organization not migrated : '||p_orgn_code);
1161: GMA_COMMON_LOGGING.gma_migration_central_log (
1162: p_run_id => p_migration_run_id,
1163: p_log_level => FND_LOG.LEVEL_ERROR,
1164: p_message_token => 'GMI_MIG_ORGN_NOT_MIGRATED',
1165: p_table_name => 'IC_LOTS_MST',
1166: p_context => 'LOTS',
1167: p_param1 => p_orgn_code,

Line 1183: p_log_level => FND_LOG.LEVEL_ERROR,

1179: -- Log error
1180: -- dbms_output.put_line ('Invalid organization : '||p_orgn_code);
1181: GMA_COMMON_LOGGING.gma_migration_central_log (
1182: p_run_id => p_migration_run_id,
1183: p_log_level => FND_LOG.LEVEL_ERROR,
1184: p_message_token => 'GMI_MIG_INVALID_ORGN',
1185: p_table_name => 'IC_LOTS_MST',
1186: p_context => 'LOTS',
1187: p_param1 => p_orgn_code,

Line 1273: p_log_level => FND_LOG.LEVEL_ERROR,

1269: IF (x_failure_count > 0) THEN
1270: -- dbms_output.put_line ('OPM Lot migration failed. item id, lot id, whse, location : '||to_char(p_item_id)||', '||to_char(p_lot_id)||', '||p_whse_code||', '||p_location);
1271: GMA_COMMON_LOGGING.gma_migration_central_log (
1272: p_run_id => p_migration_run_id,
1273: p_log_level => FND_LOG.LEVEL_ERROR,
1274: p_message_token => 'GMI_MIG_LOT_MIG_FAILED',
1275: p_table_name => 'IC_LOTS_MST',
1276: p_context => 'LOTS',
1277: p_param1 => INV_GMI_Migration.item(p_item_id),

Line 1297: p_log_level => FND_LOG.LEVEL_ERROR,

1293: FOR i in 1..l_msg_count LOOP
1294: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
1295: GMA_COMMON_LOGGING.gma_migration_central_log (
1296: p_run_id => P_migration_run_id,
1297: p_log_level => FND_LOG.LEVEL_ERROR,
1298: p_message_token => 'GMI_UNEXPECTED_ERROR',
1299: p_table_name => 'IC_LOTS_MST',
1300: p_context => 'LOTS',
1301: p_token1 => 'ERROR',

Line 1318: p_log_level => FND_LOG.LEVEL_ERROR,

1314: FOR i in 1..l_msg_count LOOP
1315: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
1316: GMA_COMMON_LOGGING.gma_migration_central_log (
1317: p_run_id => P_migration_run_id,
1318: p_log_level => FND_LOG.LEVEL_ERROR,
1319: p_message_token => 'GMI_UNEXPECTED_ERROR',
1320: p_table_name => 'IC_LOTS_MST',
1321: p_context => 'LOTS',
1322: p_token1 => 'ERROR',

Line 1339: p_log_level => FND_LOG.LEVEL_ERROR,

1335: FOR i in 1..l_msg_count LOOP
1336: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
1337: GMA_COMMON_LOGGING.gma_migration_central_log (
1338: p_run_id => P_migration_run_id,
1339: p_log_level => FND_LOG.LEVEL_ERROR,
1340: p_message_token => 'GMI_UNEXPECTED_ERROR',
1341: p_table_name => 'IC_LOTS_MST',
1342: p_context => 'LOTS',
1343: p_token1 => 'ERROR',

Line 1355: p_log_level => FND_LOG.LEVEL_ERROR,

1351: END LOOP;
1352: -- dbms_output.put_line (substr(SQLERRM,1,255));
1353: GMA_COMMON_LOGGING.gma_migration_central_log (
1354: p_run_id => P_migration_run_id,
1355: p_log_level => FND_LOG.LEVEL_ERROR,
1356: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1357: p_table_name => 'IC_LOTS_MST',
1358: p_context => 'LOTS',
1359: p_param1 => NULL,