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.INV_GMI_MIGRATION dependencies on IC_LOCT_INV

Line 1893: p_table_name => 'IC_LOCT_INV',

1889: GMA_COMMON_LOGGING.gma_migration_central_log (
1890: p_run_id => p_migration_run_id,
1891: p_log_level => FND_LOG.LEVEL_ERROR,
1892: p_message_token => 'GMI_LOC_CREATION_FAILED',
1893: p_table_name => 'IC_LOCT_INV',
1894: p_context => 'INVENTORY BALANCE',
1895: p_param1 => adetail.whse_code,
1896: p_param2 => adetail.location,
1897: p_param3 => NULL,

Line 2194: CURSOR c_ic_loct_inv IS

2190:
2191:
2192: e_skip_whse EXCEPTION;
2193:
2194: CURSOR c_ic_loct_inv IS
2195: SELECT rowid, l.*
2196: FROM ic_loct_inv l
2197: WHERE migrated_ind is NULL AND
2198: ROUND(loct_onhand, 5) <> 0

Line 2196: FROM ic_loct_inv l

2192: e_skip_whse EXCEPTION;
2193:
2194: CURSOR c_ic_loct_inv IS
2195: SELECT rowid, l.*
2196: FROM ic_loct_inv l
2197: WHERE migrated_ind is NULL AND
2198: ROUND(loct_onhand, 5) <> 0
2199: ORDER by whse_code;
2200:

Line 2232: p_table_name => 'IC_LOCT_INV',

2228: GMA_COMMON_LOGGING.gma_migration_central_log (
2229: p_run_id => p_migration_run_id,
2230: p_log_level => FND_LOG.LEVEL_ERROR,
2231: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
2232: p_table_name => 'IC_LOCT_INV',
2233: p_context => 'INVENTORY BALANCE',
2234: p_param1 => NULL,
2235: p_param2 => NULL,
2236: p_param3 => NULL,

Line 2242: FOR bal in c_ic_loct_inv LOOP

2238: p_param5 => NULL,
2239: p_db_error => NULL,
2240: p_app_short_name => 'GMA');
2241:
2242: FOR bal in c_ic_loct_inv LOOP
2243: BEGIN
2244: -- SAVEPOINT bal_migration_start;
2245:
2246: IF (bal.whse_code = l_prev_whse_code and l_skip_to_next_whse = 1) THEN

Line 2270: p_table_name => 'IC_LOCT_INV',

2266: GMA_COMMON_LOGGING.gma_migration_central_log (
2267: p_run_id => p_migration_run_id,
2268: p_log_level => FND_LOG.LEVEL_ERROR,
2269: p_message_token => 'GMI_MIG_WHSE_NOT_MIGRATED',
2270: p_table_name => 'IC_LOCT_INV',
2271: p_context => 'INVENTORY BALANCE',
2272: p_param1 => bal.whse_code,
2273: p_param2 => NULL,
2274: p_param3 => NULL,

Line 2292: p_table_name => 'IC_LOCT_INV',

2288: GMA_COMMON_LOGGING.gma_migration_central_log (
2289: p_run_id => p_migration_run_id,
2290: p_log_level => FND_LOG.LEVEL_ERROR,
2291: p_message_token => 'INV_RETRIEVE_PERIOD',
2292: p_table_name => 'IC_LOCT_INV',
2293: p_context => 'INVENTORY BALANCE',
2294: p_param1 => NULL,
2295: p_param2 => NULL,
2296: p_param3 => NULL,

Line 2308: p_table_name => 'IC_LOCT_INV',

2304: GMA_COMMON_LOGGING.gma_migration_central_log (
2305: p_run_id => p_migration_run_id,
2306: p_log_level => FND_LOG.LEVEL_ERROR,
2307: p_message_token => 'GMI_MIG_NO_ODM_OPEN_PERIOD',
2308: p_table_name => 'IC_LOCT_INV',
2309: p_context => 'INVENTORY BALANCE',
2310: p_param1 => INV_GMI_Migration.org(l_organization_id),
2311: p_param2 => NULL,
2312: p_param3 => NULL,

Line 2343: p_table_name => 'IC_LOCT_INV',

2339: GMA_COMMON_LOGGING.gma_migration_central_log (
2340: p_run_id => p_migration_run_id,
2341: p_log_level => FND_LOG.LEVEL_ERROR,
2342: p_message_token => 'GMI_MIG_OPENING_ODM_PERIOD',
2343: p_table_name => 'IC_LOCT_INV',
2344: p_context => 'INVENTORY BALANCE',
2345: p_param1 => INV_GMI_Migration.org(l_organization_id),
2346: p_param2 => fp.period_year,
2347: p_param3 => fp.period_number,

Line 2377: p_table_name => 'IC_LOCT_INV',

2373: GMA_COMMON_LOGGING.gma_migration_central_log (
2374: p_run_id => p_migration_run_id,
2375: p_log_level => FND_LOG.LEVEL_ERROR,
2376: p_message_token => 'INV_PREV_PD_NOT_OPEN_10G',
2377: p_table_name => 'IC_LOCT_INV',
2378: p_context => 'INVENTORY BALANCE',
2379: p_param1 => NULL,
2380: p_param2 => NULL,
2381: p_param3 => NULL,

Line 2393: p_table_name => 'IC_LOCT_INV',

2389: GMA_COMMON_LOGGING.gma_migration_central_log (
2390: p_run_id => p_migration_run_id,
2391: p_log_level => FND_LOG.LEVEL_ERROR,
2392: p_message_token => 'INV_CANNOT_GET_NEXT_PERIOD',
2393: p_table_name => 'IC_LOCT_INV',
2394: p_context => 'INVENTORY BALANCE',
2395: p_param1 => NULL,
2396: p_param2 => NULL,
2397: p_param3 => NULL,

Line 2409: p_table_name => 'IC_LOCT_INV',

2405: GMA_COMMON_LOGGING.gma_migration_central_log (
2406: p_run_id => p_migration_run_id,
2407: p_log_level => FND_LOG.LEVEL_ERROR,
2408: p_message_token => 'INV_DUPLICATE_OPEN_PERIOD',
2409: p_table_name => 'IC_LOCT_INV',
2410: p_context => 'INVENTORY BALANCE',
2411: p_param1 => NULL,
2412: p_param2 => NULL,
2413: p_param3 => NULL,

Line 2425: p_table_name => 'IC_LOCT_INV',

2421: GMA_COMMON_LOGGING.gma_migration_central_log (
2422: p_run_id => p_migration_run_id,
2423: p_log_level => FND_LOG.LEVEL_ERROR,
2424: p_message_token => 'INV_NO_CHANGES',
2425: p_table_name => 'IC_LOCT_INV',
2426: p_context => 'INVENTORY BALANCE',
2427: p_param1 => NULL,
2428: p_param2 => NULL,
2429: p_param3 => NULL,

Line 2462: p_table_name => 'IC_LOCT_INV',

2458: GMA_COMMON_LOGGING.gma_migration_central_log (
2459: p_run_id => p_migration_run_id,
2460: p_log_level => FND_LOG.LEVEL_ERROR,
2461: p_message_token => 'GMI_MIG_ITEM_MIG_FAILED',
2462: p_table_name => 'IC_LOCT_INV',
2463: p_context => 'INVENTORY BALANCE',
2464: p_param1 => INV_GMI_Migration.org(l_organization_id),
2465: p_param2 => INV_GMI_Migration.item(bal.item_id),
2466: p_param3 => NULL,

Line 2490: p_table_name => 'IC_LOCT_INV',

2486: GMA_COMMON_LOGGING.gma_migration_central_log (
2487: p_run_id => p_migration_run_id,
2488: p_log_level => FND_LOG.LEVEL_ERROR,
2489: p_message_token => 'GMI_MIG_NONINV_ITEM',
2490: p_table_name => 'IC_LOCT_INV',
2491: p_context => 'INVENTORY BALANCE',
2492: p_param1 => l_item_no,
2493: p_param3 => NULL,
2494: p_param4 => NULL,

Line 2526: p_table_name => 'IC_LOCT_INV',

2522: GMA_COMMON_LOGGING.gma_migration_central_log (
2523: p_run_id => p_migration_run_id,
2524: p_log_level => FND_LOG.LEVEL_ERROR,
2525: p_message_token => 'GMI_MIG_LOT_MIG_FAILED',
2526: p_table_name => 'IC_LOCT_INV',
2527: p_context => 'INVENTORY BALANCE',
2528: p_param1 => INV_GMI_Migration.item(bal.item_id),
2529: p_param2 => INV_GMI_Migration.lot(bal.lot_id),
2530: p_param3 => bal.whse_code,

Line 2567: p_table_name => 'IC_LOCT_INV',

2563: GMA_COMMON_LOGGING.gma_migration_central_log (
2564: p_run_id => p_migration_run_id,
2565: p_log_level => FND_LOG.LEVEL_ERROR,
2566: p_message_token => 'GMI_MIG_LOC_NOT_MIGRATED',
2567: p_table_name => 'IC_LOCT_INV',
2568: p_context => 'INVENTORY BALANCE',
2569: p_param1 => bal.whse_code,
2570: p_param2 => bal.location,
2571: p_param3 => NULL,

Line 2628: p_table_name => 'IC_LOCT_INV',

2624: GMA_COMMON_LOGGING.gma_migration_central_log (
2625: p_run_id => p_migration_run_id,
2626: p_log_level => FND_LOG.LEVEL_ERROR,
2627: p_message_token => 'GMI_LOC_CREATION_FAILED',
2628: p_table_name => 'IC_LOCT_INV',
2629: p_context => 'INVENTORY BALANCE',
2630: p_param1 => bal.whse_code,
2631: p_param2 => bal.location,
2632: p_param3 => NULL,

Line 2726: p_table_name => 'IC_LOCT_INV',

2722: GMA_COMMON_LOGGING.gma_migration_central_log (
2723: p_run_id => p_migration_run_id,
2724: p_log_level => FND_LOG.LEVEL_ERROR,
2725: p_message_token => 'GMI_MIG_BALANCE_MIG_FAILED',
2726: p_table_name => 'IC_LOCT_INV',
2727: p_context => 'INVENTORY BALANCE',
2728: p_param1 => INV_GMI_Migration.item(bal.item_id),
2729: p_param2 => bal.whse_code,
2730: p_param3 => INV_GMI_Migration.lot(bal.lot_id),

Line 2742: p_table_name => 'IC_LOCT_INV',

2738: GMA_COMMON_LOGGING.gma_migration_central_log (
2739: p_run_id => p_migration_run_id,
2740: p_log_level => FND_LOG.LEVEL_ERROR,
2741: p_message_token => 'GMI_UNEXPECTED_ERROR',
2742: p_table_name => 'IC_LOCT_INV',
2743: p_context => 'INVENTORY BALANCE',
2744: p_token1 => 'ERROR',
2745: p_param1 => fnd_msg_pub.get_detail(i, NULL),
2746: p_param2 => NULL,

Line 2765: UPDATE ic_loct_inv

2761: WHERE
2762: transaction_set_id = l_transaction_set_id;
2763:
2764: -- Update mtl transaction id back in OPM table
2765: UPDATE ic_loct_inv
2766: SET migrated_ind = 1,
2767: material_transaction_id = l_transaction_set_id
2768: WHERE
2769: rowid = bal.rowid;

Line 2782: p_table_name => 'IC_LOCT_INV',

2778: GMA_COMMON_LOGGING.gma_migration_central_log (
2779: p_run_id => p_migration_run_id,
2780: p_log_level => FND_LOG.LEVEL_ERROR,
2781: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
2782: p_table_name => 'IC_LOCT_INV',
2783: p_context => 'INVENTORY BALANCE',
2784: p_param1 => l_field_name,
2785: p_param2 => l_field_value,
2786: p_param3 => NULL,

Line 2813: p_table_name => 'IC_LOCT_INV',

2809: GMA_COMMON_LOGGING.gma_migration_central_log (
2810: p_run_id => p_migration_run_id,
2811: p_log_level => FND_LOG.LEVEL_ERROR,
2812: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
2813: p_table_name => 'IC_LOCT_INV',
2814: p_context => 'INVENTORY BALANCE',
2815: p_param1 => l_migrate_count,
2816: p_param2 => x_failure_count,
2817: p_param3 => NULL,

Line 2830: p_table_name => 'IC_LOCT_INV',

2826: GMA_COMMON_LOGGING.gma_migration_central_log (
2827: p_run_id => p_migration_run_id,
2828: p_log_level => FND_LOG.LEVEL_ERROR,
2829: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2830: p_table_name => 'IC_LOCT_INV',
2831: p_context => 'INVENTORY BALANCE',
2832: p_param1 => NULL,
2833: p_param2 => NULL,
2834: p_param3 => NULL,