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

Line 142: p_log_level => FND_LOG.LEVEL_ERROR,

138: -- Log Error
139: -- dbms_output.put_line ('Desc flexfield conflict. OPM context: '|| l_opm_context ||', ODM context: '|| l_odm_context);
140: GMA_COMMON_LOGGING.gma_migration_central_log (
141: p_run_id => p_migration_run_id,
142: p_log_level => FND_LOG.LEVEL_ERROR,
143: p_message_token => 'GMI_MIG_DFLEX_CONTEXT_CONFLICT',
144: p_table_name => 'IC_ITEM_MST_B',
145: p_context => 'ITEMS',
146: p_param1 => l_opm_context,

Line 164: p_log_level => FND_LOG.LEVEL_ERROR,

160:
161: -- dbms_output.put_line ('Desc flexfield column conflict.' || conflict_columns.descriptive_flex_context_code ||', '||conflict_columns.end_user_column_name||', '||conflict_columns.application_column_name);
162: GMA_COMMON_LOGGING.gma_migration_central_log (
163: p_run_id => p_migration_run_id,
164: p_log_level => FND_LOG.LEVEL_ERROR,
165: p_message_token => 'GMI_MIG_DFLEX_COL_CONFLICT',
166: p_table_name => 'IC_ITEM_MST_B',
167: p_context => 'ITEMS',
168: p_param1 => conflict_columns.descriptive_flex_context_code,

Line 364: p_log_level => FND_LOG.LEVEL_PROCEDURE,

360: FOR i IN c_autolot LOOP
361: -- dbms_output.put_line ('Number of lot controlled items without autolot numbering setup : '|| to_char(i.item_count));
362: GMA_COMMON_LOGGING.gma_migration_central_log (
363: p_run_id => p_migration_run_id,
364: p_log_level => FND_LOG.LEVEL_PROCEDURE,
365: p_message_token => 'GMI_MIG_ITEM_AUTOLOT',
366: p_table_name => 'IC_ITEM_MST_B',
367: p_context => 'ITEMS',
368: p_param1 => to_char(i.item_count),

Line 390: p_log_level => FND_LOG.LEVEL_PROCEDURE,

386: END IF;
387: -- dbms_output.put_line ('Lot with multiple status. Item, Lot-Sublot, Whse, Location, Status : '|| ls.item_no||', '||ls.lot_no||l_delimiter||ls.sublot_no||', '||ls.whse_code||', '||ls.location||', '||ls.lot_status);
388: GMA_COMMON_LOGGING.gma_migration_central_log (
389: p_run_id => p_migration_run_id,
390: p_log_level => FND_LOG.LEVEL_PROCEDURE,
391: p_message_token => 'GMI_MIG_MULTIPLE_STATUS_LOT',
392: p_table_name => 'IC_LOTS_MST',
393: p_context => 'LOTS',
394: p_param1 => ls.item_no,

Line 408: p_log_level => FND_LOG.LEVEL_PROCEDURE,

404: FOR lu IN c_lot_uniqeness LOOP
405: -- dbms_output.put_line ('Lot uniqueness not set to NONE for the organization : '||lu.organization_code);
406: GMA_COMMON_LOGGING.gma_migration_central_log (
407: p_run_id => p_migration_run_id,
408: p_log_level => FND_LOG.LEVEL_PROCEDURE,
409: p_message_token => 'GMI_MIG_INCORRECT_LOT_UNIQ',
410: p_table_name => 'IC_LOTS_MST',
411: p_context => 'LOTS',
412: p_param1 => lu.organization_code,

Line 427: p_log_level => FND_LOG.LEVEL_PROCEDURE,

423: FOR dl1 IN c_org_locator_ctl1 LOOP
424: -- dbms_output.put_line ('Locator control not set to Determine at Subinventory for organization corresponding to location controlled OPM warehouses : '||dl1.organization_code);
425: GMA_COMMON_LOGGING.gma_migration_central_log (
426: p_run_id => p_migration_run_id,
427: p_log_level => FND_LOG.LEVEL_PROCEDURE,
428: p_message_token => 'GMI_MIG_INCORRECT_LOCT_CTL',
429: p_table_name => 'IC_LOCT_INV',
430: p_context => 'INVENTORY BALANCES',
431: p_param1 => dl1.organization_code,

Line 444: p_log_level => FND_LOG.LEVEL_PROCEDURE,

440: FOR dl1 IN c_sub_locator_ctl LOOP
441: -- dbms_output.put_line ('Locator control not set to Item Level for subinventory corresponding to OPM warehouse locators : '||dl1.organization_code||', '||dl1.secondary_inventory_name);
442: GMA_COMMON_LOGGING.gma_migration_central_log (
443: p_run_id => p_migration_run_id,
444: p_log_level => FND_LOG.LEVEL_PROCEDURE,
445: p_message_token => 'GMI_MIG_INCORRECT_SUB_LOCT_CTL',
446: p_table_name => 'IC_LOCT_INV',
447: p_context => 'INVENTORY BALANCES',
448: p_param1 => dl1.organization_code,

Line 461: p_log_level => FND_LOG.LEVEL_PROCEDURE,

457: FOR dl2 IN c_org_locator_ctl2 LOOP
458: -- dbms_output.put_line ('Locator control not set to None for organization corresponding to non-location controlled OPM warehouses : '||dl2.organization_code);
459: GMA_COMMON_LOGGING.gma_migration_central_log (
460: p_run_id => p_migration_run_id,
461: p_log_level => FND_LOG.LEVEL_PROCEDURE,
462: p_message_token => 'GMI_MIG_INCORRECT_NON_LOCT_CTL',
463: p_table_name => 'IC_LOCT_INV',
464: p_context => 'INVENTORY BALANCES',
465: p_param1 => dl2.organization_code,

Line 480: p_log_level => FND_LOG.LEVEL_PROCEDURE,

476: FOR nb IN c_neg_balances LOOP
477: -- dbms_output.put_line ('Negative balances exists for item, lot, sublot, whse, location : '||nb.item_no||', '||nb.lot_no||', '||nb.sublot_no||', '||nb.whse_code||', '||nb.location);
478: GMA_COMMON_LOGGING.gma_migration_central_log (
479: p_run_id => p_migration_run_id,
480: p_log_level => FND_LOG.LEVEL_PROCEDURE,
481: p_message_token => 'GMI_MIG_NEG_BALANCES',
482: p_table_name => 'IC_LOCT_INV',
483: p_context => 'INVENTORY BALANCES',
484: p_param1 => nb.item_no,

Line 500: p_log_level => FND_LOG.LEVEL_PROCEDURE,

496: FOR mb IN c_mix_balances LOOP
497: -- dbms_output.put_line ('Mixed balances for dual quantity exists for item, lot, sublot, whse, location : '||mb.item_no||', '||mb.lot_no||', '||mb.sublot_no||', '||mb.whse_code||', '||mb.location);
498: GMA_COMMON_LOGGING.gma_migration_central_log (
499: p_run_id => p_migration_run_id,
500: p_log_level => FND_LOG.LEVEL_PROCEDURE,
501: p_message_token => 'GMI_MIG_MIX_BALANCES',
502: p_table_name => 'IC_LOCT_INV',
503: p_context => 'INVENTORY BALANCES',
504: p_param1 => mb.item_no,

Line 520: p_log_level => FND_LOG.LEVEL_PROCEDURE,

516: FOR db IN c_decimal_dust_balances LOOP
517: -- dbms_output.put_line ('Decimal dust balances exists for item, lot, sublot, whse, location : '||db.item_no||', '||db.lot_no||', '||db.sublot_no||', '||db.whse_code||', '||db.location);
518: GMA_COMMON_LOGGING.gma_migration_central_log (
519: p_run_id => p_migration_run_id,
520: p_log_level => FND_LOG.LEVEL_PROCEDURE,
521: p_message_token => 'GMI_MIG_DUST_BALANCES',
522: p_table_name => 'IC_LOCT_INV',
523: p_context => 'INVENTORY BALANCES',
524: p_param1 => db.item_no,

Line 538: p_log_level => FND_LOG.LEVEL_PROCEDURE,

534: FOR nb IN c_non_inv_balances LOOP
535: -- dbms_output.put_line ('Inventory balances exists for non-inventory item, lot, sublot, whse, location : '||nb.item_no||', '||nb.lot_no||', '||nb.sublot_no||', '||nb.whse_code||', '||nb.location);
536: GMA_COMMON_LOGGING.gma_migration_central_log (
537: p_run_id => p_migration_run_id,
538: p_log_level => FND_LOG.LEVEL_PROCEDURE,
539: p_message_token => 'GMI_MIG_NEG_BALANCES',
540: p_table_name => 'IC_LOCT_INV',
541: p_context => 'INVENTORY BALANCES',
542: p_param1 => nb.item_no,

Line 556: p_log_level => FND_LOG.LEVEL_PROCEDURE,

552: FOR tb IN c_in_transit_transfers LOOP
553: -- dbms_output.put_line ('In Transit transfer exists : ' || tb.orgn_code ||' '||tb.transfer_no);
554: GMA_COMMON_LOGGING.gma_migration_central_log (
555: p_run_id => p_migration_run_id,
556: p_log_level => FND_LOG.LEVEL_PROCEDURE,
557: p_message_token => 'GMI_MIG_INTRANS_BALANCES',
558: p_table_name => 'IC_LOCT_INV',
559: p_context => 'INVENTORY BALANCES',
560: p_param1 => tb.orgn_code ||' '||tb.transfer_no,