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_STORAGE_PLAN_DETAILS

Line 419: p_param1 => 'gmd_storage_plan_details',

415: p_token2 => 'PRO',
416: p_token3 => 'UPD',
417: p_token4 => 'INS',
418: p_token5 => 'ERR',
419: p_param1 => 'gmd_storage_plan_details',
420: p_param2 => to_char(GMD_QC_MIG12.g_store_plan_pro_count),
421: p_param3 => to_char(GMD_QC_MIG12.g_store_plan_upd_count),
422: p_param4 => 0,
423: p_param5 => to_char(GMD_QC_MIG12.g_store_plan_err_count),

Line 7242: Cursor for gmd_storage_plan_details.

7238: l_stab_org_id gmd_stability_studies_b.organization_id%TYPE;
7239:
7240:
7241: /*=====================================
7242: Cursor for gmd_storage_plan_details.
7243: Added storage_organization_id is null
7244: in order to ignore records created
7245: after migration has run.
7246: =====================================*/

Line 7250: FROM gmd_storage_plan_details

7246: =====================================*/
7247:
7248: CURSOR get_plan_details IS
7249: SELECT storage_plan_detail_id, whse_code, location
7250: FROM gmd_storage_plan_details
7251: WHERE migrated_ind IS NULL
7252: AND storage_organization_id IS NULL;
7253:
7254: l_plan_org_id gmd_storage_plan_details.storage_organization_id%TYPE;

Line 7254: l_plan_org_id gmd_storage_plan_details.storage_organization_id%TYPE;

7250: FROM gmd_storage_plan_details
7251: WHERE migrated_ind IS NULL
7252: AND storage_organization_id IS NULL;
7253:
7254: l_plan_org_id gmd_storage_plan_details.storage_organization_id%TYPE;
7255: l_plan_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
7256: l_plan_subinv gmd_storage_plan_details.storage_subinventory%TYPE;
7257: l_plan_locator_id ic_loct_mst.locator_id%TYPE;
7258:

Line 7256: l_plan_subinv gmd_storage_plan_details.storage_subinventory%TYPE;

7252: AND storage_organization_id IS NULL;
7253:
7254: l_plan_org_id gmd_storage_plan_details.storage_organization_id%TYPE;
7255: l_plan_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
7256: l_plan_subinv gmd_storage_plan_details.storage_subinventory%TYPE;
7257: l_plan_locator_id ic_loct_mst.locator_id%TYPE;
7258:
7259:
7260:

Line 7394: Log Start of gmd_storage_plan_details.

7390: x_exception_count := 0;
7391:
7392:
7393: /*==============================================
7394: Log Start of gmd_storage_plan_details.
7395: ==============================================*/
7396:
7397: GMA_COMMON_LOGGING.gma_migration_central_log (
7398: p_run_id => p_migration_run_id,

Line 7401: p_table_name => 'GMD_STORAGE_PLAN_DETAILS',

7397: GMA_COMMON_LOGGING.gma_migration_central_log (
7398: p_run_id => p_migration_run_id,
7399: p_log_level => FND_LOG.LEVEL_EVENT,
7400: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7401: p_table_name => 'GMD_STORAGE_PLAN_DETAILS',
7402: p_token1 => 'TABLE_NAME',
7403: p_param1 => 'GMD_STORAGE_PLAN_DETAILS',
7404: p_context => 'Quality Stability Studies',
7405: p_app_short_name => 'GMA');

Line 7403: p_param1 => 'GMD_STORAGE_PLAN_DETAILS',

7399: p_log_level => FND_LOG.LEVEL_EVENT,
7400: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7401: p_table_name => 'GMD_STORAGE_PLAN_DETAILS',
7402: p_token1 => 'TABLE_NAME',
7403: p_param1 => 'GMD_STORAGE_PLAN_DETAILS',
7404: p_context => 'Quality Stability Studies',
7405: p_app_short_name => 'GMA');
7406:
7407: /*===================================

Line 7408: Process gmd_storage_plan_details.

7404: p_context => 'Quality Stability Studies',
7405: p_app_short_name => 'GMA');
7406:
7407: /*===================================
7408: Process gmd_storage_plan_details.
7409: ====================================*/
7410:
7411: GMD_QC_MIG12.g_store_plan_upd_count := 0;
7412: GMD_QC_MIG12.g_store_plan_pro_count := 0;

Line 7511: Update gmd_storage_plan_details.

7507: l_plan_locator_id := NULL;
7508: END IF; -- plan whse code is null
7509:
7510: /*===================================
7511: Update gmd_storage_plan_details.
7512: ===================================*/
7513:
7514: UPDATE gmd_storage_plan_details
7515: SET storage_organization_id = l_plan_org_id,

Line 7514: UPDATE gmd_storage_plan_details

7510: /*===================================
7511: Update gmd_storage_plan_details.
7512: ===================================*/
7513:
7514: UPDATE gmd_storage_plan_details
7515: SET storage_organization_id = l_plan_org_id,
7516: storage_subinventory = l_plan_subinv,
7517: storage_locator_id = l_plan_locator_id,
7518: migrated_ind = 1

Line 7534: p_context => 'Quality Stability Studies - gmd_storage_plan_details',

7530: GMA_COMMON_LOGGING.gma_migration_central_log (
7531: p_run_id => p_migration_run_id,
7532: p_log_level => FND_LOG.LEVEL_ERROR,
7533: p_message_token => 'GMD_MIG_WHSE_ERROR',
7534: p_context => 'Quality Stability Studies - gmd_storage_plan_details',
7535: p_token1 => 'WHSE',
7536: p_token2 => 'WNAME',
7537: p_token3 => 'ROWK',
7538: p_token4 => 'ROWV',

Line 7552: p_context => 'Quality Stability Studies - gmd_storage_plan_details',

7548: GMA_COMMON_LOGGING.gma_migration_central_log (
7549: p_run_id => p_migration_run_id,
7550: p_log_level => FND_LOG.LEVEL_ERROR,
7551: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
7552: p_context => 'Quality Stability Studies - gmd_storage_plan_details',
7553: p_token1 => 'ROWK',
7554: p_token2 => 'ROWV',
7555: p_token3 => 'FNAME',
7556: p_param1 => 'STORAGE_PLAN_DETAIL_ID',

Line 7568: p_context => 'Quality Stability Studies - gmd_storage_plan_details',

7564: GMA_COMMON_LOGGING.gma_migration_central_log (
7565: p_run_id => p_migration_run_id,
7566: p_log_level => FND_LOG.LEVEL_ERROR,
7567: p_message_token => 'GMD_MIG_LOCATOR_ID',
7568: p_context => 'Quality Stability Studies - gmd_storage_plan_details',
7569: p_token1 => 'WHSE',
7570: p_token2 => 'LOCATION',
7571: p_token3 => 'LFIELD',
7572: p_token4 => 'ROWK',

Line 7589: p_context => 'Quality Stability Studies - gmd_storage_plan_details',

7585: GMA_COMMON_LOGGING.gma_migration_central_log (
7586: p_run_id => p_migration_run_id,
7587: p_log_level => FND_LOG.LEVEL_ERROR,
7588: p_message_token => 'GMD_MIG_SUBINV',
7589: p_context => 'Quality Stability Studies - gmd_storage_plan_details',
7590: p_token1 => 'LOCATOR',
7591: p_token2 => 'ROWK',
7592: p_token3 => 'ROWV',
7593: p_param1 => to_char(l_plan_locator_id),

Line 7606: p_context => 'Quality Stability Studies - gmd_storage_plan_details',

7602: GMA_COMMON_LOGGING.gma_migration_central_log (
7603: p_run_id => p_migration_run_id,
7604: p_log_level => FND_LOG.LEVEL_ERROR,
7605: p_message_token => 'GMD_MIG_DEF_SS_ORG_ERROR',
7606: p_context => 'Quality Stability Studies - gmd_storage_plan_details',
7607: p_app_short_name => 'GMD');
7608: GMD_QC_MIG12.g_store_plan_err_count := GMD_QC_MIG12.g_store_plan_err_count + 1;
7609: x_exception_count := x_exception_count + 1;
7610:

Line 7617: p_context => 'Quality Stability Studies - gmd_storage_plan_details',

7613: GMA_COMMON_LOGGING.gma_migration_central_log (
7614: p_run_id => p_migration_run_id,
7615: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
7616: p_message_token => 'GMA_MIGRATION_DB_ERROR',
7617: p_context => 'Quality Stability Studies - gmd_storage_plan_details',
7618: p_db_error => SQLERRM,
7619: p_app_short_name => 'GMA');
7620: x_exception_count := x_exception_count + 1;
7621: ROLLBACK;

Line 7629: Log number of updates to gmd_storage_plan_details.

7625: END LOOP; -- end get plan details
7626:
7627:
7628: /*=====================================================
7629: Log number of updates to gmd_storage_plan_details.
7630: =====================================================*/
7631:
7632: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
7633: