APPS.GMI_PRE_MIGRATION dependencies on GMA_COMMON_LOGGING

Line 140: GMA_COMMON_LOGGING.gma_migration_central_log (

136: END;
137: IF (l_opm_context is not NULL and l_odm_context is not NULL) THEN
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',

Line 162: GMA_COMMON_LOGGING.gma_migration_central_log (

158: FOR conflict_columns in c_get_desc_flex_col_conflict LOOP
159: -- If we are here, that means we have a conflict
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',

Line 362: GMA_COMMON_LOGGING.gma_migration_central_log (

358: BEGIN
359: -- Check the items which do not have auto lot numbering setup
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',

Line 388: GMA_COMMON_LOGGING.gma_migration_central_log (

384: IF ls.sublot_no is not NULL THEN
385: l_delimiter := '-';
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',

Line 406: GMA_COMMON_LOGGING.gma_migration_central_log (

402:
403: -- Validate the lot uniqueness for the existing process enabled organizations.
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',

Line 425: GMA_COMMON_LOGGING.gma_migration_central_log (

421: -- Validate the discrete locator control
422:
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',

Line 442: GMA_COMMON_LOGGING.gma_migration_central_log (

438: END LOOP;
439:
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',

Line 459: GMA_COMMON_LOGGING.gma_migration_central_log (

455: END LOOP;
456:
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',

Line 478: GMA_COMMON_LOGGING.gma_migration_central_log (

474: -- Show the negative OPM inventory balances.
475:
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',

Line 498: GMA_COMMON_LOGGING.gma_migration_central_log (

494: -- primary and negative for secondary or vice-versa.
495:
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',

Line 518: GMA_COMMON_LOGGING.gma_migration_central_log (

514: -- Show any decimal dust kind of balances that will not be migrated for convergence.
515:
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',

Line 536: GMA_COMMON_LOGGING.gma_migration_central_log (

532:
533: -- Display balances for non-inv items
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',

Line 554: GMA_COMMON_LOGGING.gma_migration_central_log (

550:
551: -- Display in-transit transfers
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',