[Home] [Help]
1982: -- update_dispatch_history
1983: --
1984: -- DESCRIPTION:
1985: -- This PL/SQL procedure is used to update the organization_id and
1986: -- inventory_item_id columns in the gr_dispatch_history table if the
1987: -- values are NULL.
1988: --
1989: -- PARAMETERS:
1990: -- p_migration_run_id - Migration run id to be used for writing to the message log
2035:
2036: /* Cursor used retrieve the records that don't have an organization id */
2037: CURSOR c_get_disp_rec IS
2038: SELECT dispatch_history_id, item, document_id
2039: FROM gr_dispatch_history
2040: WHERE organization_id is NULL;
2041: l_dispatch_rec c_get_disp_rec%ROWTYPE;
2042:
2043: /* Cursor used retrieve the organization_code from the document */
2057: GMA_COMMON_LOGGING.gma_migration_central_log (
2058: p_run_id => P_migration_run_id,
2059: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2060: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
2061: p_table_name => 'GR_DISPATCH_HISTORY',
2062: p_context => 'UPDATE_DISPATCH_HISTORY',
2063: p_param1 => NULL,
2064: p_param2 => NULL,
2065: p_param3 => NULL,
2112: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2113: RAISE INVALID_ORG_ITEM;
2114: END IF;
2115:
2116: UPDATE gr_dispatch_history
2117: SET organization_id = l_org_id,
2118: inventory_item_id = l_inv_item_id
2119: WHERE dispatch_history_id = l_dispatch_rec.dispatch_history_id;
2120:
2133: GMA_COMMON_LOGGING.gma_migration_central_log (
2134: p_run_id => P_migration_run_id,
2135: p_log_level => FND_LOG.LEVEL_EXCEPTION,
2136: p_message_token => 'GR_INVALID_ORG_ITEM',
2137: p_table_name => 'GR_DISPATCH_HISTORY',
2138: p_context => 'UPDATE_DISPATCH_HISTORY',
2139: p_param1 => l_org_id,
2140: p_param2 => l_dispatch_rec.item,
2141: p_param3 => NULL,
2150: GMA_COMMON_LOGGING.gma_migration_central_log (
2151: p_run_id => P_migration_run_id,
2152: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
2153: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2154: p_table_name => 'GR_DISPATCH_HISTORY',
2155: p_context => 'UPDATE_DISPATCH_HISTORY',
2156: p_param1 => NULL,
2157: p_param2 => NULL,
2158: p_param3 => NULL,
2172: GMA_COMMON_LOGGING.gma_migration_central_log (
2173: p_run_id => P_migration_run_id,
2174: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2175: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
2176: p_table_name => 'GR_DISPATCH_HISTORY',
2177: p_context => 'UPDATE_DISPATCH_HISTORY',
2178: p_param1 => l_migration_count,
2179: p_param2 => x_failure_count,
2180: p_param3 => NULL,
2190: GMA_COMMON_LOGGING.gma_migration_central_log (
2191: p_run_id => P_migration_run_id,
2192: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
2193: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2194: p_table_name => 'GR_DISPATCH_HISTORY',
2195: p_context => 'UPDATE_DISPATCH_HISTORY',
2196: p_param1 => NULL,
2197: p_param2 => NULL,
2198: p_param3 => NULL,
2204: GMA_COMMON_LOGGING.gma_migration_central_log (
2205: p_run_id => P_migration_run_id,
2206: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2207: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
2208: p_table_name => 'GR_DISPATCH_HISTORY',
2209: p_context => 'UPDATE_DISPATCH_HISTORY',
2210: p_param1 => x_failure_count,
2211: p_param2 => NULL,
2212: p_param3 => NULL,