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.

[Home] [Help]

APPS.GMD_QC_MIG12 dependencies on GMD_STORAGE_PLAN_DETAILS

Line 411: p_param1 => 'gmd_storage_plan_details',

407: p_token2 => 'PRO',
408: p_token3 => 'UPD',
409: p_token4 => 'INS',
410: p_token5 => 'ERR',
411: p_param1 => 'gmd_storage_plan_details',
412: p_param2 => to_char(GMD_QC_MIG12.g_store_plan_pro_count),
413: p_param3 => to_char(GMD_QC_MIG12.g_store_plan_upd_count),
414: p_param4 => 0,
415: p_param5 => to_char(GMD_QC_MIG12.g_store_plan_err_count),

Line 6973: Cursor for gmd_storage_plan_details.

6969: l_stab_org_id gmd_stability_studies_b.organization_id%TYPE;
6970:
6971:
6972: /*=====================================
6973: Cursor for gmd_storage_plan_details.
6974: Added storage_organization_id is null
6975: in order to ignore records created
6976: after migration has run.
6977: =====================================*/

Line 6981: FROM gmd_storage_plan_details

6977: =====================================*/
6978:
6979: CURSOR get_plan_details IS
6980: SELECT storage_plan_detail_id, whse_code, location
6981: FROM gmd_storage_plan_details
6982: WHERE migrated_ind IS NULL
6983: AND storage_organization_id IS NULL;
6984:
6985: l_plan_org_id gmd_storage_plan_details.storage_organization_id%TYPE;

Line 6985: l_plan_org_id gmd_storage_plan_details.storage_organization_id%TYPE;

6981: FROM gmd_storage_plan_details
6982: WHERE migrated_ind IS NULL
6983: AND storage_organization_id IS NULL;
6984:
6985: l_plan_org_id gmd_storage_plan_details.storage_organization_id%TYPE;
6986: l_plan_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
6987: l_plan_subinv gmd_storage_plan_details.storage_subinventory%TYPE;
6988: l_plan_locator_id ic_loct_mst.locator_id%TYPE;
6989:

Line 6987: l_plan_subinv gmd_storage_plan_details.storage_subinventory%TYPE;

6983: AND storage_organization_id IS NULL;
6984:
6985: l_plan_org_id gmd_storage_plan_details.storage_organization_id%TYPE;
6986: l_plan_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
6987: l_plan_subinv gmd_storage_plan_details.storage_subinventory%TYPE;
6988: l_plan_locator_id ic_loct_mst.locator_id%TYPE;
6989:
6990:
6991:

Line 7125: Log Start of gmd_storage_plan_details.

7121: x_exception_count := 0;
7122:
7123:
7124: /*==============================================
7125: Log Start of gmd_storage_plan_details.
7126: ==============================================*/
7127:
7128: GMA_COMMON_LOGGING.gma_migration_central_log (
7129: p_run_id => p_migration_run_id,

Line 7132: p_table_name => 'GMD_STORAGE_PLAN_DETAILS',

7128: GMA_COMMON_LOGGING.gma_migration_central_log (
7129: p_run_id => p_migration_run_id,
7130: p_log_level => FND_LOG.LEVEL_EVENT,
7131: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7132: p_table_name => 'GMD_STORAGE_PLAN_DETAILS',
7133: p_token1 => 'TABLE_NAME',
7134: p_param1 => 'GMD_STORAGE_PLAN_DETAILS',
7135: p_context => 'Quality Stability Studies',
7136: p_app_short_name => 'GMA');

Line 7134: p_param1 => 'GMD_STORAGE_PLAN_DETAILS',

7130: p_log_level => FND_LOG.LEVEL_EVENT,
7131: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7132: p_table_name => 'GMD_STORAGE_PLAN_DETAILS',
7133: p_token1 => 'TABLE_NAME',
7134: p_param1 => 'GMD_STORAGE_PLAN_DETAILS',
7135: p_context => 'Quality Stability Studies',
7136: p_app_short_name => 'GMA');
7137:
7138: /*===================================

Line 7139: Process gmd_storage_plan_details.

7135: p_context => 'Quality Stability Studies',
7136: p_app_short_name => 'GMA');
7137:
7138: /*===================================
7139: Process gmd_storage_plan_details.
7140: ====================================*/
7141:
7142: GMD_QC_MIG12.g_store_plan_upd_count := 0;
7143: GMD_QC_MIG12.g_store_plan_pro_count := 0;

Line 7242: Update gmd_storage_plan_details.

7238: l_plan_locator_id := NULL;
7239: END IF; -- plan whse code is null
7240:
7241: /*===================================
7242: Update gmd_storage_plan_details.
7243: ===================================*/
7244:
7245: UPDATE gmd_storage_plan_details
7246: SET storage_organization_id = l_plan_org_id,

Line 7245: UPDATE gmd_storage_plan_details

7241: /*===================================
7242: Update gmd_storage_plan_details.
7243: ===================================*/
7244:
7245: UPDATE gmd_storage_plan_details
7246: SET storage_organization_id = l_plan_org_id,
7247: storage_subinventory = l_plan_subinv,
7248: storage_locator_id = l_plan_locator_id,
7249: migrated_ind = 1

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

7261: GMA_COMMON_LOGGING.gma_migration_central_log (
7262: p_run_id => p_migration_run_id,
7263: p_log_level => FND_LOG.LEVEL_ERROR,
7264: p_message_token => 'GMD_MIG_WHSE_ERROR',
7265: p_context => 'Quality Stability Studies - gmd_storage_plan_details',
7266: p_token1 => 'WHSE',
7267: p_token2 => 'WNAME',
7268: p_token3 => 'ROWK',
7269: p_token4 => 'ROWV',

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

7279: GMA_COMMON_LOGGING.gma_migration_central_log (
7280: p_run_id => p_migration_run_id,
7281: p_log_level => FND_LOG.LEVEL_ERROR,
7282: p_message_token => 'GMD_MIG_NONLOC_FAILURE',
7283: p_context => 'Quality Stability Studies - gmd_storage_plan_details',
7284: p_token1 => 'ROWK',
7285: p_token2 => 'ROWV',
7286: p_token3 => 'FNAME',
7287: p_param1 => 'STORAGE_PLAN_DETAIL_ID',

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

7295: GMA_COMMON_LOGGING.gma_migration_central_log (
7296: p_run_id => p_migration_run_id,
7297: p_log_level => FND_LOG.LEVEL_ERROR,
7298: p_message_token => 'GMD_MIG_LOCATOR_ID',
7299: p_context => 'Quality Stability Studies - gmd_storage_plan_details',
7300: p_token1 => 'WHSE',
7301: p_token2 => 'LOCATION',
7302: p_token3 => 'LFIELD',
7303: p_token4 => 'ROWK',

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

7316: GMA_COMMON_LOGGING.gma_migration_central_log (
7317: p_run_id => p_migration_run_id,
7318: p_log_level => FND_LOG.LEVEL_ERROR,
7319: p_message_token => 'GMD_MIG_SUBINV',
7320: p_context => 'Quality Stability Studies - gmd_storage_plan_details',
7321: p_token1 => 'LOCATOR',
7322: p_token2 => 'ROWK',
7323: p_token3 => 'ROWV',
7324: p_param1 => to_char(l_plan_locator_id),

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

7333: GMA_COMMON_LOGGING.gma_migration_central_log (
7334: p_run_id => p_migration_run_id,
7335: p_log_level => FND_LOG.LEVEL_ERROR,
7336: p_message_token => 'GMD_MIG_DEF_SS_ORG_ERROR',
7337: p_context => 'Quality Stability Studies - gmd_storage_plan_details',
7338: p_app_short_name => 'GMD');
7339: GMD_QC_MIG12.g_store_plan_err_count := GMD_QC_MIG12.g_store_plan_err_count + 1;
7340: x_exception_count := x_exception_count + 1;
7341:

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

7344: GMA_COMMON_LOGGING.gma_migration_central_log (
7345: p_run_id => p_migration_run_id,
7346: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
7347: p_message_token => 'GMA_MIGRATION_DB_ERROR',
7348: p_context => 'Quality Stability Studies - gmd_storage_plan_details',
7349: p_db_error => SQLERRM,
7350: p_app_short_name => 'GMA');
7351: x_exception_count := x_exception_count + 1;
7352: ROLLBACK;

Line 7360: Log number of updates to gmd_storage_plan_details.

7356: END LOOP; -- end get plan details
7357:
7358:
7359: /*=====================================================
7360: Log number of updates to gmd_storage_plan_details.
7361: =====================================================*/
7362:
7363: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
7364: