[Home] [Help]
1958: -- update_dispatch_history
1959: --
1960: -- DESCRIPTION:
1961: -- This PL/SQL procedure is used to update the organization_id and
1962: -- inventory_item_id columns in the gr_dispatch_history table if the
1963: -- values are NULL.
1964: --
1965: -- PARAMETERS:
1966: -- p_migration_run_id - Migration run id to be used for writing to the message log
2011:
2012: /* Cursor used retrieve the records that don't have an organization id */
2013: CURSOR c_get_disp_rec IS
2014: SELECT dispatch_history_id, item, document_id
2015: FROM gr_dispatch_history
2016: WHERE organization_id is NULL;
2017: l_dispatch_rec c_get_disp_rec%ROWTYPE;
2018:
2019: /* Cursor used retrieve the organization_code from the document */
2033: GMA_COMMON_LOGGING.gma_migration_central_log (
2034: p_run_id => P_migration_run_id,
2035: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2036: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
2037: p_table_name => 'GR_DISPATCH_HISTORY',
2038: p_context => 'UPDATE_DISPATCH_HISTORY',
2039: p_param1 => NULL,
2040: p_param2 => NULL,
2041: p_param3 => NULL,
2088: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2089: RAISE INVALID_ORG_ITEM;
2090: END IF;
2091:
2092: UPDATE gr_dispatch_history
2093: SET organization_id = l_org_id,
2094: inventory_item_id = l_inv_item_id
2095: WHERE dispatch_history_id = l_dispatch_rec.dispatch_history_id;
2096:
2109: GMA_COMMON_LOGGING.gma_migration_central_log (
2110: p_run_id => P_migration_run_id,
2111: p_log_level => FND_LOG.LEVEL_EXCEPTION,
2112: p_message_token => 'GR_INVALID_ORG_ITEM',
2113: p_table_name => 'GR_DISPATCH_HISTORY',
2114: p_context => 'UPDATE_DISPATCH_HISTORY',
2115: p_param1 => l_org_id,
2116: p_param2 => l_dispatch_rec.item,
2117: p_param3 => NULL,
2126: GMA_COMMON_LOGGING.gma_migration_central_log (
2127: p_run_id => P_migration_run_id,
2128: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
2129: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2130: p_table_name => 'GR_DISPATCH_HISTORY',
2131: p_context => 'UPDATE_DISPATCH_HISTORY',
2132: p_param1 => NULL,
2133: p_param2 => NULL,
2134: p_param3 => NULL,
2148: GMA_COMMON_LOGGING.gma_migration_central_log (
2149: p_run_id => P_migration_run_id,
2150: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2151: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
2152: p_table_name => 'GR_DISPATCH_HISTORY',
2153: p_context => 'UPDATE_DISPATCH_HISTORY',
2154: p_param1 => l_migration_count,
2155: p_param2 => x_failure_count,
2156: p_param3 => NULL,
2166: GMA_COMMON_LOGGING.gma_migration_central_log (
2167: p_run_id => P_migration_run_id,
2168: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
2169: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2170: p_table_name => 'GR_DISPATCH_HISTORY',
2171: p_context => 'UPDATE_DISPATCH_HISTORY',
2172: p_param1 => NULL,
2173: p_param2 => NULL,
2174: p_param3 => NULL,
2180: GMA_COMMON_LOGGING.gma_migration_central_log (
2181: p_run_id => P_migration_run_id,
2182: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2183: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
2184: p_table_name => 'GR_DISPATCH_HISTORY',
2185: p_context => 'UPDATE_DISPATCH_HISTORY',
2186: p_param1 => x_failure_count,
2187: p_param2 => NULL,
2188: p_param3 => NULL,