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_MATERIAL_SOURCES

Line 457: p_param1 => 'gmd_ss_material_sources',

453: p_token2 => 'PRO',
454: p_token3 => 'UPD',
455: p_token4 => 'INS',
456: p_token5 => 'ERR',
457: p_param1 => 'gmd_ss_material_sources',
458: p_param2 => to_char(GMD_QC_MIG12.g_matl_source_pro_count),
459: p_param3 => to_char(GMD_QC_MIG12.g_matl_source_upd_count),
460: p_param4 => 0,
461: p_param5 => to_char(GMD_QC_MIG12.g_matl_source_err_count),

Line 7174: -- gmd_ss_material_sources source_organization_id

7170: --
7171: -- gmd_ss_storage_package quantity_uom
7172: -- gmd_stability_studies_b organization_id
7173: -- gmd_stability_studies_b lab_organization_id
7174: -- gmd_ss_material_sources source_organization_id
7175: -- gmd_ss_material_sources sample_quantity_uom
7176: -- gmd_ss_variants sample_quantity_uom
7177: --=========================================================================== */
7178:

Line 7175: -- gmd_ss_material_sources sample_quantity_uom

7171: -- gmd_ss_storage_package quantity_uom
7172: -- gmd_stability_studies_b organization_id
7173: -- gmd_stability_studies_b lab_organization_id
7174: -- gmd_ss_material_sources source_organization_id
7175: -- gmd_ss_material_sources sample_quantity_uom
7176: -- gmd_ss_variants sample_quantity_uom
7177: --=========================================================================== */
7178:
7179: PROCEDURE GMD_QC_MIGRATE_STABS

Line 7310: Cursor to get gmd_ss_material_sources.

7306: l_def_ss_org_id sy_orgn_mst.organization_id%TYPE;
7307: l_ss_org_id sy_orgn_mst.organization_id%TYPE;
7308:
7309: /*=========================================
7310: Cursor to get gmd_ss_material_sources.
7311: Get org id null to exclude records
7312: added after migration is run and then
7313: rerun.
7314: =========================================*/

Line 7321: FROM gmd_ss_material_sources

7317: -- Removed source_organization_id IS NULL from the where clause since lot info needs to be migrated.
7318: CURSOR get_matl_src IS
7319: SELECT plant_code, source_organization_id,
7320: lot_id, ss_id, source_id
7321: FROM gmd_ss_material_sources
7322: WHERE migrated_ind IS NULL;
7323: --AND source_organization_id IS NULL;
7324:
7325: l_plant_org_id gmd_ss_material_sources.source_organization_id%TYPE;

Line 7325: l_plant_org_id gmd_ss_material_sources.source_organization_id%TYPE;

7321: FROM gmd_ss_material_sources
7322: WHERE migrated_ind IS NULL;
7323: --AND source_organization_id IS NULL;
7324:
7325: l_plant_org_id gmd_ss_material_sources.source_organization_id%TYPE;
7326:
7327: /*===============================================
7328: Cursor to get stability study org and item.
7329: ===============================================*/

Line 7790: Log Start of gmd_ss_material_sources.

7786: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
7787:
7788:
7789: /*==============================================
7790: Log Start of gmd_ss_material_sources.
7791: ==============================================*/
7792:
7793: GMA_COMMON_LOGGING.gma_migration_central_log (
7794: p_run_id => p_migration_run_id,

Line 7797: p_table_name => 'GMD_SS_MATERIAL_SOURCES',

7793: GMA_COMMON_LOGGING.gma_migration_central_log (
7794: p_run_id => p_migration_run_id,
7795: p_log_level => FND_LOG.LEVEL_EVENT,
7796: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7797: p_table_name => 'GMD_SS_MATERIAL_SOURCES',
7798: p_token1 => 'TABLE_NAME',
7799: p_param1 => 'GMD_SS_MATERIAL_SOURCES',
7800: p_context => 'Quality Stability Studies',
7801: p_app_short_name => 'GMA');

Line 7799: p_param1 => 'GMD_SS_MATERIAL_SOURCES',

7795: p_log_level => FND_LOG.LEVEL_EVENT,
7796: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
7797: p_table_name => 'GMD_SS_MATERIAL_SOURCES',
7798: p_token1 => 'TABLE_NAME',
7799: p_param1 => 'GMD_SS_MATERIAL_SOURCES',
7800: p_context => 'Quality Stability Studies',
7801: p_app_short_name => 'GMA');
7802:
7803: /*=======================================

Line 7804: Migrate gmd_ss_material_sources.

7800: p_context => 'Quality Stability Studies',
7801: p_app_short_name => 'GMA');
7802:
7803: /*=======================================
7804: Migrate gmd_ss_material_sources.
7805: =======================================*/
7806:
7807: GMD_QC_MIG12.g_matl_source_pro_count := 0;
7808: GMD_QC_MIG12.g_matl_source_err_count := 0;

Line 7884: Update gmd_ss_material_sources.

7880: l_lot_number := NULL;
7881: END IF;
7882:
7883: /*==================================
7884: Update gmd_ss_material_sources.
7885: ==================================*/
7886:
7887: UPDATE gmd_ss_material_sources
7888: SET source_organization_id = l_plant_org_id,

Line 7887: UPDATE gmd_ss_material_sources

7883: /*==================================
7884: Update gmd_ss_material_sources.
7885: ==================================*/
7886:
7887: UPDATE gmd_ss_material_sources
7888: SET source_organization_id = l_plant_org_id,
7889: lot_number = l_lot_number,
7890: migrated_ind = 1
7891: WHERE source_id = l_matl_rec.source_id

Line 7905: p_context => 'Quality Stability Studies - gmd_ss_material_sources',

7901: GMA_COMMON_LOGGING.gma_migration_central_log (
7902: p_run_id => p_migration_run_id,
7903: p_log_level => FND_LOG.LEVEL_ERROR,
7904: p_message_token => 'GMD_MIG_NO_ORG',
7905: p_context => 'Quality Stability Studies - gmd_ss_material_sources',
7906: p_token1 => 'ORG',
7907: p_token2 => 'ONAME',
7908: p_token3 => 'ROWK',
7909: p_token4 => 'ROWV',

Line 7923: p_context => 'Quality Stability Studies - gmd_ss_material_sources',

7919: GMA_COMMON_LOGGING.gma_migration_central_log (
7920: p_run_id => p_migration_run_id,
7921: p_log_level => FND_LOG.LEVEL_ERROR,
7922: p_message_token => 'GMD_MIG_GET_SS_ERROR',
7923: p_context => 'Quality Stability Studies - gmd_ss_material_sources',
7924: p_token1 => 'STABID',
7925: p_token2 => 'ROWK',
7926: p_token3 => 'ROWV',
7927: p_param1 => to_char(l_matl_rec.ss_id),

Line 7939: p_context => 'Quality Stability Studies - gmd_ss_material_sources',

7935: GMA_COMMON_LOGGING.gma_migration_central_log (
7936: p_run_id => p_migration_run_id,
7937: p_log_level => FND_LOG.LEVEL_ERROR,
7938: p_message_token => 'GMD_MIG_PLANT_ORG_ID',
7939: p_context => 'Quality Stability Studies - gmd_ss_material_sources',
7940: p_token1 => 'ORG',
7941: p_token2 => 'SRC',
7942: p_token3 => 'ROWK',
7943: p_token4 => 'ROWV',

Line 7957: p_context => 'Quality Stability Studies - gmd_ss_material_sources',

7953: GMA_COMMON_LOGGING.gma_migration_central_log (
7954: p_run_id => p_migration_run_id,
7955: p_log_level => FND_LOG.LEVEL_ERROR,
7956: p_message_token => 'GMD_MIG_LOT',
7957: p_context => 'Quality Stability Studies - gmd_ss_material_sources',
7958: p_token1 => 'ROWK',
7959: p_token2 => 'ROWV',
7960: p_param1 => 'SOURCE_ID',
7961: p_param2 => to_char(l_matl_rec.source_id),

Line 7972: p_context => 'Quality Stability Studies - gmd_ss_material_sources',

7968: GMA_COMMON_LOGGING.gma_migration_central_log (
7969: p_run_id => p_migration_run_id,
7970: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
7971: p_message_token => 'GMA_MIGRATION_DB_ERROR',
7972: p_context => 'Quality Stability Studies - gmd_ss_material_sources',
7973: p_db_error => SQLERRM,
7974: p_app_short_name => 'GMA');
7975: x_exception_count := x_exception_count + 1;
7976: ROLLBACK;

Line 7985: Log End of gmd_ss_material_sources.

7981:
7982:
7983:
7984: /*==============================================
7985: Log End of gmd_ss_material_sources.
7986: ==============================================*/
7987:
7988: LOG_SS_COUNTS(p_migration_run_id, GMD_QC_MIG12.g_progress_ind);
7989: