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.GMD_QC_MIG12 dependencies on GMD_SS_STORAGE_HISTORY

Line 506: p_param1 => 'gmd_ss_storage_history',

502: p_token2 => 'PRO',
503: p_token3 => 'UPD',
504: p_token4 => 'INS',
505: p_token5 => 'ERR',
506: p_param1 => 'gmd_ss_storage_history',
507: p_param2 => to_char(GMD_QC_MIG12.g_ss_storehist_pro_count),
508: p_param3 => to_char(GMD_QC_MIG12.g_ss_storehist_upd_count),
509: p_param4 => 0,
510: p_param5 => to_char(GMD_QC_MIG12.g_ss_storehist_err_count),

Line 7097: Cursor to get gmd_ss_storage_history.

7093: l_storage_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7094: l_storage_locator_id gmd_ss_variants.storage_locator_id%TYPE;
7095:
7096: /*=========================================
7097: Cursor to get gmd_ss_storage_history.
7098: Select also where organization id is
7099: null to not affect records added after
7100: the migration in case migration is
7101: run again out of sequence.

Line 7107: FROM gmd_ss_storage_history

7103:
7104: CURSOR get_ss_history IS
7105: SELECT storage_history_id, whse_code, location,
7106: organization_id, subinventory, locator_id
7107: FROM gmd_ss_storage_history
7108: WHERE migrated_ind IS NULL
7109: AND organization_id IS NULL;
7110:
7111: l_hist_org_id gmd_ss_storage_history.organization_id%TYPE;

Line 7111: l_hist_org_id gmd_ss_storage_history.organization_id%TYPE;

7107: FROM gmd_ss_storage_history
7108: WHERE migrated_ind IS NULL
7109: AND organization_id IS NULL;
7110:
7111: l_hist_org_id gmd_ss_storage_history.organization_id%TYPE;
7112: l_hist_subinventory gmd_ss_storage_history.subinventory%TYPE;
7113: l_hist_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7114: l_hist_locator_id gmd_ss_storage_history.locator_id%TYPE;
7115:

Line 7112: l_hist_subinventory gmd_ss_storage_history.subinventory%TYPE;

7108: WHERE migrated_ind IS NULL
7109: AND organization_id IS NULL;
7110:
7111: l_hist_org_id gmd_ss_storage_history.organization_id%TYPE;
7112: l_hist_subinventory gmd_ss_storage_history.subinventory%TYPE;
7113: l_hist_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7114: l_hist_locator_id gmd_ss_storage_history.locator_id%TYPE;
7115:
7116: l_text_code NUMBER;

Line 7114: l_hist_locator_id gmd_ss_storage_history.locator_id%TYPE;

7110:
7111: l_hist_org_id gmd_ss_storage_history.organization_id%TYPE;
7112: l_hist_subinventory gmd_ss_storage_history.subinventory%TYPE;
7113: l_hist_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7114: l_hist_locator_id gmd_ss_storage_history.locator_id%TYPE;
7115:
7116: l_text_code NUMBER;
7117:
7118: BEGIN

Line 8340: Log Start of gmd_ss_storage_history.

8336: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
8337:
8338:
8339: /*==============================================
8340: Log Start of gmd_ss_storage_history.
8341: ==============================================*/
8342:
8343: GMA_COMMON_LOGGING.gma_migration_central_log (
8344: p_run_id => p_migration_run_id,

Line 8347: p_table_name => 'GMD_SS_STORAGE_HISTORY',

8343: GMA_COMMON_LOGGING.gma_migration_central_log (
8344: p_run_id => p_migration_run_id,
8345: p_log_level => FND_LOG.LEVEL_EVENT,
8346: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
8347: p_table_name => 'GMD_SS_STORAGE_HISTORY',
8348: p_token1 => 'TABLE_NAME',
8349: p_param1 => 'GMD_SS_STORAGE_HISTORY',
8350: p_context => 'Quality Stability Studies',
8351: p_app_short_name => 'GMA');

Line 8349: p_param1 => 'GMD_SS_STORAGE_HISTORY',

8345: p_log_level => FND_LOG.LEVEL_EVENT,
8346: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
8347: p_table_name => 'GMD_SS_STORAGE_HISTORY',
8348: p_token1 => 'TABLE_NAME',
8349: p_param1 => 'GMD_SS_STORAGE_HISTORY',
8350: p_context => 'Quality Stability Studies',
8351: p_app_short_name => 'GMA');
8352:
8353: GMD_QC_MIG12.g_ss_storehist_pro_count := 0;

Line 8359: Migrate gmd_ss_storage_history.

8355: GMD_QC_MIG12.g_ss_storehist_upd_count := 0;
8356: GMD_QC_MIG12.g_progress_ind := 6;
8357:
8358: /*====================================
8359: Migrate gmd_ss_storage_history.
8360: ====================================*/
8361:
8362: FOR l_hist_rec IN get_ss_history LOOP
8363: BEGIN -- end get_ss_hist subprogram

Line 8445: Update gmd_ss_storage_history.

8441: l_hist_locator_id := l_hist_rec.locator_id;
8442: END IF;
8443:
8444: /*===================================
8445: Update gmd_ss_storage_history.
8446: *===================================*/
8447:
8448: UPDATE gmd_ss_storage_history
8449: SET subinventory = l_hist_subinventory,

Line 8448: UPDATE gmd_ss_storage_history

8444: /*===================================
8445: Update gmd_ss_storage_history.
8446: *===================================*/
8447:
8448: UPDATE gmd_ss_storage_history
8449: SET subinventory = l_hist_subinventory,
8450: locator_id = l_hist_locator_id,
8451: organization_id = l_hist_org_id,
8452: migrated_ind = 1

Line 8467: p_context => 'Quality Stability Studies - gmd_ss_storage_history',

8463: GMA_COMMON_LOGGING.gma_migration_central_log (
8464: p_run_id => p_migration_run_id,
8465: p_log_level => FND_LOG.LEVEL_ERROR,
8466: p_message_token => 'GMD_MIG_WHSE_ERROR',
8467: p_context => 'Quality Stability Studies - gmd_ss_storage_history',
8468: p_token1 => 'WHSE',
8469: p_token2 => 'WNAME',
8470: p_token3 => 'ROWK',
8471: p_token4 => 'ROWV',

Line 8485: p_context => 'Quality Stability Studies - gmd_ss_storage_history',

8481: GMA_COMMON_LOGGING.gma_migration_central_log (
8482: p_run_id => p_migration_run_id,
8483: p_log_level => FND_LOG.LEVEL_ERROR,
8484: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
8485: p_context => 'Quality Stability Studies - gmd_ss_storage_history',
8486: p_token1 => 'ROWK',
8487: p_token2 => 'ROWV',
8488: p_token3 => 'FNAME',
8489: p_param1 => 'STORAGE_HISTORY_ID',

Line 8501: p_context => 'Quality Stability Studies - gmd_ss_storage_history',

8497: GMA_COMMON_LOGGING.gma_migration_central_log (
8498: p_run_id => p_migration_run_id,
8499: p_log_level => FND_LOG.LEVEL_ERROR,
8500: p_message_token => 'GMD_MIG_LOCATOR_ID',
8501: p_context => 'Quality Stability Studies - gmd_ss_storage_history',
8502: p_token1 => 'WHSE',
8503: p_token2 => 'LOCATION',
8504: p_token3 => 'LFIELD',
8505: p_token4 => 'ROWK',

Line 8521: p_context => 'Quality Stability Studies - gmd_ss_storage_history',

8517: GMA_COMMON_LOGGING.gma_migration_central_log (
8518: p_run_id => p_migration_run_id,
8519: p_log_level => FND_LOG.LEVEL_ERROR,
8520: p_message_token => 'GMD_MIG_SUBINV',
8521: p_context => 'Quality Stability Studies - gmd_ss_storage_history',
8522: p_token1 => 'LOCATOR',
8523: p_token2 => 'ROWK',
8524: p_token3 => 'ROWV',
8525: p_param1 => to_char(l_hist_locator_id),

Line 8538: p_context => 'Quality Stability Studies - gmd_ss_storage_history',

8534: GMA_COMMON_LOGGING.gma_migration_central_log (
8535: p_run_id => p_migration_run_id,
8536: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
8537: p_message_token => 'GMA_MIGRATION_DB_ERROR',
8538: p_context => 'Quality Stability Studies - gmd_ss_storage_history',
8539: p_db_error => SQLERRM,
8540: p_app_short_name => 'GMA');
8541: x_exception_count := x_exception_count + 1;
8542: ROLLBACK;

Line 8550: Log End of gmd_ss_storage_history.

8546: END LOOP; -- end get_ss_history
8547:
8548:
8549: /*==============================================
8550: Log End of gmd_ss_storage_history.
8551: ==============================================*/
8552:
8553: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
8554: