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 514: p_param1 => 'gmd_ss_storage_history',

510: p_token2 => 'PRO',
511: p_token3 => 'UPD',
512: p_token4 => 'INS',
513: p_token5 => 'ERR',
514: p_param1 => 'gmd_ss_storage_history',
515: p_param2 => to_char(GMD_QC_MIG12.g_ss_storehist_pro_count),
516: p_param3 => to_char(GMD_QC_MIG12.g_ss_storehist_upd_count),
517: p_param4 => 0,
518: p_param5 => to_char(GMD_QC_MIG12.g_ss_storehist_err_count),

Line 7366: Cursor to get gmd_ss_storage_history.

7362: l_storage_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7363: l_storage_locator_id gmd_ss_variants.storage_locator_id%TYPE;
7364:
7365: /*=========================================
7366: Cursor to get gmd_ss_storage_history.
7367: Select also where organization id is
7368: null to not affect records added after
7369: the migration in case migration is
7370: run again out of sequence.

Line 7376: FROM gmd_ss_storage_history

7372:
7373: CURSOR get_ss_history IS
7374: SELECT storage_history_id, whse_code, location,
7375: organization_id, subinventory, locator_id
7376: FROM gmd_ss_storage_history
7377: WHERE migrated_ind IS NULL
7378: AND organization_id IS NULL;
7379:
7380: l_hist_org_id gmd_ss_storage_history.organization_id%TYPE;

Line 7380: l_hist_org_id gmd_ss_storage_history.organization_id%TYPE;

7376: FROM gmd_ss_storage_history
7377: WHERE migrated_ind IS NULL
7378: AND organization_id IS NULL;
7379:
7380: l_hist_org_id gmd_ss_storage_history.organization_id%TYPE;
7381: l_hist_subinventory gmd_ss_storage_history.subinventory%TYPE;
7382: l_hist_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7383: l_hist_locator_id gmd_ss_storage_history.locator_id%TYPE;
7384:

Line 7381: l_hist_subinventory gmd_ss_storage_history.subinventory%TYPE;

7377: WHERE migrated_ind IS NULL
7378: AND organization_id IS NULL;
7379:
7380: l_hist_org_id gmd_ss_storage_history.organization_id%TYPE;
7381: l_hist_subinventory gmd_ss_storage_history.subinventory%TYPE;
7382: l_hist_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7383: l_hist_locator_id gmd_ss_storage_history.locator_id%TYPE;
7384:
7385: l_text_code NUMBER;

Line 7383: l_hist_locator_id gmd_ss_storage_history.locator_id%TYPE;

7379:
7380: l_hist_org_id gmd_ss_storage_history.organization_id%TYPE;
7381: l_hist_subinventory gmd_ss_storage_history.subinventory%TYPE;
7382: l_hist_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7383: l_hist_locator_id gmd_ss_storage_history.locator_id%TYPE;
7384:
7385: l_text_code NUMBER;
7386:
7387: BEGIN

Line 8609: Log Start of gmd_ss_storage_history.

8605: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
8606:
8607:
8608: /*==============================================
8609: Log Start of gmd_ss_storage_history.
8610: ==============================================*/
8611:
8612: GMA_COMMON_LOGGING.gma_migration_central_log (
8613: p_run_id => p_migration_run_id,

Line 8616: p_table_name => 'GMD_SS_STORAGE_HISTORY',

8612: GMA_COMMON_LOGGING.gma_migration_central_log (
8613: p_run_id => p_migration_run_id,
8614: p_log_level => FND_LOG.LEVEL_EVENT,
8615: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
8616: p_table_name => 'GMD_SS_STORAGE_HISTORY',
8617: p_token1 => 'TABLE_NAME',
8618: p_param1 => 'GMD_SS_STORAGE_HISTORY',
8619: p_context => 'Quality Stability Studies',
8620: p_app_short_name => 'GMA');

Line 8618: p_param1 => 'GMD_SS_STORAGE_HISTORY',

8614: p_log_level => FND_LOG.LEVEL_EVENT,
8615: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
8616: p_table_name => 'GMD_SS_STORAGE_HISTORY',
8617: p_token1 => 'TABLE_NAME',
8618: p_param1 => 'GMD_SS_STORAGE_HISTORY',
8619: p_context => 'Quality Stability Studies',
8620: p_app_short_name => 'GMA');
8621:
8622: GMD_QC_MIG12.g_ss_storehist_pro_count := 0;

Line 8628: Migrate gmd_ss_storage_history.

8624: GMD_QC_MIG12.g_ss_storehist_upd_count := 0;
8625: GMD_QC_MIG12.g_progress_ind := 6;
8626:
8627: /*====================================
8628: Migrate gmd_ss_storage_history.
8629: ====================================*/
8630:
8631: FOR l_hist_rec IN get_ss_history LOOP
8632: BEGIN -- end get_ss_hist subprogram

Line 8714: Update gmd_ss_storage_history.

8710: l_hist_locator_id := l_hist_rec.locator_id;
8711: END IF;
8712:
8713: /*===================================
8714: Update gmd_ss_storage_history.
8715: *===================================*/
8716:
8717: UPDATE gmd_ss_storage_history
8718: SET subinventory = l_hist_subinventory,

Line 8717: UPDATE gmd_ss_storage_history

8713: /*===================================
8714: Update gmd_ss_storage_history.
8715: *===================================*/
8716:
8717: UPDATE gmd_ss_storage_history
8718: SET subinventory = l_hist_subinventory,
8719: locator_id = l_hist_locator_id,
8720: organization_id = l_hist_org_id,
8721: migrated_ind = 1

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

8732: GMA_COMMON_LOGGING.gma_migration_central_log (
8733: p_run_id => p_migration_run_id,
8734: p_log_level => FND_LOG.LEVEL_ERROR,
8735: p_message_token => 'GMD_MIG_WHSE_ERROR',
8736: p_context => 'Quality Stability Studies - gmd_ss_storage_history',
8737: p_token1 => 'WHSE',
8738: p_token2 => 'WNAME',
8739: p_token3 => 'ROWK',
8740: p_token4 => 'ROWV',

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

8750: GMA_COMMON_LOGGING.gma_migration_central_log (
8751: p_run_id => p_migration_run_id,
8752: p_log_level => FND_LOG.LEVEL_ERROR,
8753: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
8754: p_context => 'Quality Stability Studies - gmd_ss_storage_history',
8755: p_token1 => 'ROWK',
8756: p_token2 => 'ROWV',
8757: p_token3 => 'FNAME',
8758: p_param1 => 'STORAGE_HISTORY_ID',

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

8766: GMA_COMMON_LOGGING.gma_migration_central_log (
8767: p_run_id => p_migration_run_id,
8768: p_log_level => FND_LOG.LEVEL_ERROR,
8769: p_message_token => 'GMD_MIG_LOCATOR_ID',
8770: p_context => 'Quality Stability Studies - gmd_ss_storage_history',
8771: p_token1 => 'WHSE',
8772: p_token2 => 'LOCATION',
8773: p_token3 => 'LFIELD',
8774: p_token4 => 'ROWK',

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

8786: GMA_COMMON_LOGGING.gma_migration_central_log (
8787: p_run_id => p_migration_run_id,
8788: p_log_level => FND_LOG.LEVEL_ERROR,
8789: p_message_token => 'GMD_MIG_SUBINV',
8790: p_context => 'Quality Stability Studies - gmd_ss_storage_history',
8791: p_token1 => 'LOCATOR',
8792: p_token2 => 'ROWK',
8793: p_token3 => 'ROWV',
8794: p_param1 => to_char(l_hist_locator_id),

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

8803: GMA_COMMON_LOGGING.gma_migration_central_log (
8804: p_run_id => p_migration_run_id,
8805: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
8806: p_message_token => 'GMA_MIGRATION_DB_ERROR',
8807: p_context => 'Quality Stability Studies - gmd_ss_storage_history',
8808: p_db_error => SQLERRM,
8809: p_app_short_name => 'GMA');
8810: x_exception_count := x_exception_count + 1;
8811: ROLLBACK;

Line 8819: Log End of gmd_ss_storage_history.

8815: END LOOP; -- end get_ss_history
8816:
8817:
8818: /*==============================================
8819: Log End of gmd_ss_storage_history.
8820: ==============================================*/
8821:
8822: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
8823: