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 1985: p_table_name => 'IC_LOCT_INV',

1981: GMA_COMMON_LOGGING.gma_migration_central_log (
1982: p_run_id => p_migration_run_id,
1983: p_log_level => FND_LOG.LEVEL_ERROR,
1984: p_message_token => 'GMI_LOC_CREATION_FAILED',
1985: p_table_name => 'IC_LOCT_INV',
1986: p_context => 'INVENTORY BALANCE',
1987: p_param1 => adetail.whse_code,
1988: p_param2 => adetail.location,
1989: p_param3 => NULL,

Line 2303: CURSOR c_ic_loct_inv IS

2299: e_skip_whse EXCEPTION;
2300:
2301: -- Bug 8363586
2302: -- Added filter - and delete_mark = 0
2303: CURSOR c_ic_loct_inv IS
2304: SELECT l.rowid, l.*,itm.loct_ctl item_loct_ctl,
2305: itm.item_um, itm.lot_ctl,
2306: itm.noninv_ind, itm.item_no
2307: FROM ic_loct_inv l ,ic_item_mst_b itm

Line 2307: FROM ic_loct_inv l ,ic_item_mst_b itm

2303: CURSOR c_ic_loct_inv IS
2304: SELECT l.rowid, l.*,itm.loct_ctl item_loct_ctl,
2305: itm.item_um, itm.lot_ctl,
2306: itm.noninv_ind, itm.item_no
2307: FROM ic_loct_inv l ,ic_item_mst_b itm
2308: WHERE l.migrated_ind is NULL
2309: AND ROUND(l.loct_onhand, 5) <> 0
2310: AND l.delete_mark = 0
2311: AND l.rowid between p_start_rowid and p_end_rowid

Line 2346: p_table_name => 'IC_LOCT_INV',

2342: GMA_COMMON_LOGGING.gma_migration_central_log (
2343: p_run_id => p_migration_run_id,
2344: p_log_level => FND_LOG.LEVEL_ERROR,
2345: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
2346: p_table_name => 'IC_LOCT_INV',
2347: p_context => 'INVENTORY BALANCE',
2348: p_param1 => NULL,
2349: p_param2 => NULL,
2350: p_param3 => NULL,

Line 2356: FOR bal in c_ic_loct_inv LOOP

2352: p_param5 => NULL,
2353: p_db_error => NULL,
2354: p_app_short_name => 'GMA');
2355:
2356: FOR bal in c_ic_loct_inv LOOP
2357: BEGIN
2358: -- SAVEPOINT bal_migration_start;
2359:
2360: IF (bal.whse_code = l_prev_whse_code and l_skip_to_next_whse = 1) THEN

Line 2384: p_table_name => 'IC_LOCT_INV',

2380: GMA_COMMON_LOGGING.gma_migration_central_log (
2381: p_run_id => p_migration_run_id,
2382: p_log_level => FND_LOG.LEVEL_ERROR,
2383: p_message_token => 'GMI_MIG_WHSE_NOT_MIGRATED',
2384: p_table_name => 'IC_LOCT_INV',
2385: p_context => 'INVENTORY BALANCE',
2386: p_param1 => bal.whse_code,
2387: p_param2 => NULL,
2388: p_param3 => NULL,

Line 2406: p_table_name => 'IC_LOCT_INV',

2402: GMA_COMMON_LOGGING.gma_migration_central_log (
2403: p_run_id => p_migration_run_id,
2404: p_log_level => FND_LOG.LEVEL_ERROR,
2405: p_message_token => 'INV_RETRIEVE_PERIOD',
2406: p_table_name => 'IC_LOCT_INV',
2407: p_context => 'INVENTORY BALANCE',
2408: p_param1 => NULL,
2409: p_param2 => NULL,
2410: p_param3 => NULL,

Line 2422: p_table_name => 'IC_LOCT_INV',

2418: GMA_COMMON_LOGGING.gma_migration_central_log (
2419: p_run_id => p_migration_run_id,
2420: p_log_level => FND_LOG.LEVEL_ERROR,
2421: p_message_token => 'GMI_MIG_NO_ODM_OPEN_PERIOD',
2422: p_table_name => 'IC_LOCT_INV',
2423: p_context => 'INVENTORY BALANCE',
2424: p_param1 => INV_GMI_Migration.org(l_organization_id),
2425: p_param2 => NULL,
2426: p_param3 => NULL,

Line 2457: p_table_name => 'IC_LOCT_INV',

2453: GMA_COMMON_LOGGING.gma_migration_central_log (
2454: p_run_id => p_migration_run_id,
2455: p_log_level => FND_LOG.LEVEL_ERROR,
2456: p_message_token => 'GMI_MIG_OPENING_ODM_PERIOD',
2457: p_table_name => 'IC_LOCT_INV',
2458: p_context => 'INVENTORY BALANCE',
2459: p_param1 => INV_GMI_Migration.org(l_organization_id),
2460: p_param2 => fp.period_year,
2461: p_param3 => fp.period_number,

Line 2491: p_table_name => 'IC_LOCT_INV',

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

Line 2507: p_table_name => 'IC_LOCT_INV',

2503: GMA_COMMON_LOGGING.gma_migration_central_log (
2504: p_run_id => p_migration_run_id,
2505: p_log_level => FND_LOG.LEVEL_ERROR,
2506: p_message_token => 'INV_CANNOT_GET_NEXT_PERIOD',
2507: p_table_name => 'IC_LOCT_INV',
2508: p_context => 'INVENTORY BALANCE',
2509: p_param1 => NULL,
2510: p_param2 => NULL,
2511: p_param3 => NULL,

Line 2523: p_table_name => 'IC_LOCT_INV',

2519: GMA_COMMON_LOGGING.gma_migration_central_log (
2520: p_run_id => p_migration_run_id,
2521: p_log_level => FND_LOG.LEVEL_ERROR,
2522: p_message_token => 'INV_DUPLICATE_OPEN_PERIOD',
2523: p_table_name => 'IC_LOCT_INV',
2524: p_context => 'INVENTORY BALANCE',
2525: p_param1 => NULL,
2526: p_param2 => NULL,
2527: p_param3 => NULL,

Line 2539: p_table_name => 'IC_LOCT_INV',

2535: GMA_COMMON_LOGGING.gma_migration_central_log (
2536: p_run_id => p_migration_run_id,
2537: p_log_level => FND_LOG.LEVEL_ERROR,
2538: p_message_token => 'INV_NO_CHANGES',
2539: p_table_name => 'IC_LOCT_INV',
2540: p_context => 'INVENTORY BALANCE',
2541: p_param1 => NULL,
2542: p_param2 => NULL,
2543: p_param3 => NULL,

Line 2576: p_table_name => 'IC_LOCT_INV',

2572: GMA_COMMON_LOGGING.gma_migration_central_log (
2573: p_run_id => p_migration_run_id,
2574: p_log_level => FND_LOG.LEVEL_ERROR,
2575: p_message_token => 'GMI_MIG_ITEM_MIG_FAILED',
2576: p_table_name => 'IC_LOCT_INV',
2577: p_context => 'INVENTORY BALANCE',
2578: p_param1 => INV_GMI_Migration.org(l_organization_id),
2579: p_param2 => INV_GMI_Migration.item(bal.item_id),
2580: p_param3 => NULL,

Line 2605: p_table_name => 'IC_LOCT_INV',

2601: GMA_COMMON_LOGGING.gma_migration_central_log (
2602: p_run_id => p_migration_run_id,
2603: p_log_level => FND_LOG.LEVEL_ERROR,
2604: p_message_token => 'GMI_MIG_NONINV_ITEM',
2605: p_table_name => 'IC_LOCT_INV',
2606: p_context => 'INVENTORY BALANCE',
2607: p_param1 => bal.item_no,
2608: p_param3 => NULL,
2609: p_param4 => NULL,

Line 2641: p_table_name => 'IC_LOCT_INV',

2637: GMA_COMMON_LOGGING.gma_migration_central_log (
2638: p_run_id => p_migration_run_id,
2639: p_log_level => FND_LOG.LEVEL_ERROR,
2640: p_message_token => 'GMI_MIG_LOT_MIG_FAILED',
2641: p_table_name => 'IC_LOCT_INV',
2642: p_context => 'INVENTORY BALANCE',
2643: p_param1 => INV_GMI_Migration.item(bal.item_id),
2644: p_param2 => INV_GMI_Migration.lot(bal.lot_id),
2645: p_param3 => bal.whse_code,

Line 2687: p_table_name => 'IC_LOCT_INV',

2683: GMA_COMMON_LOGGING.gma_migration_central_log (
2684: p_run_id => p_migration_run_id,
2685: p_log_level => FND_LOG.LEVEL_ERROR,
2686: p_message_token => 'GMI_MIG_LOC_NOT_MIGRATED',
2687: p_table_name => 'IC_LOCT_INV',
2688: p_context => 'INVENTORY BALANCE',
2689: p_param1 => bal.whse_code,
2690: p_param2 => bal.location,
2691: p_param3 => NULL,

Line 2748: p_table_name => 'IC_LOCT_INV',

2744: GMA_COMMON_LOGGING.gma_migration_central_log (
2745: p_run_id => p_migration_run_id,
2746: p_log_level => FND_LOG.LEVEL_ERROR,
2747: p_message_token => 'GMI_LOC_CREATION_FAILED',
2748: p_table_name => 'IC_LOCT_INV',
2749: p_context => 'INVENTORY BALANCE',
2750: p_param1 => bal.whse_code,
2751: p_param2 => bal.location,
2752: p_param3 => NULL,

Line 2846: p_table_name => 'IC_LOCT_INV',

2842: GMA_COMMON_LOGGING.gma_migration_central_log (
2843: p_run_id => p_migration_run_id,
2844: p_log_level => FND_LOG.LEVEL_ERROR,
2845: p_message_token => 'GMI_MIG_BALANCE_MIG_FAILED',
2846: p_table_name => 'IC_LOCT_INV',
2847: p_context => 'INVENTORY BALANCE',
2848: p_param1 => INV_GMI_Migration.item(bal.item_id),
2849: p_param2 => bal.whse_code,
2850: p_param3 => INV_GMI_Migration.lot(bal.lot_id),

Line 2862: p_table_name => 'IC_LOCT_INV',

2858: GMA_COMMON_LOGGING.gma_migration_central_log (
2859: p_run_id => p_migration_run_id,
2860: p_log_level => FND_LOG.LEVEL_ERROR,
2861: p_message_token => 'GMI_UNEXPECTED_ERROR',
2862: p_table_name => 'IC_LOCT_INV',
2863: p_context => 'INVENTORY BALANCE',
2864: p_token1 => 'ERROR',
2865: p_param1 => fnd_msg_pub.get_detail(i, NULL),
2866: p_param2 => NULL,

Line 2885: UPDATE ic_loct_inv

2881: WHERE
2882: transaction_set_id = l_transaction_set_id; */
2883:
2884: -- Update mtl transaction id back in OPM table
2885: UPDATE ic_loct_inv
2886: SET migrated_ind = 1,
2887: material_transaction_id = l_transaction_set_id
2888: WHERE
2889: rowid = bal.rowid;

Line 2902: p_table_name => 'IC_LOCT_INV',

2898: GMA_COMMON_LOGGING.gma_migration_central_log (
2899: p_run_id => p_migration_run_id,
2900: p_log_level => FND_LOG.LEVEL_ERROR,
2901: p_message_token => 'GMI_MIG_NO_DATA_FOR_FIELD',
2902: p_table_name => 'IC_LOCT_INV',
2903: p_context => 'INVENTORY BALANCE',
2904: p_param1 => l_field_name,
2905: p_param2 => l_field_value,
2906: p_param3 => NULL,

Line 2933: p_table_name => 'IC_LOCT_INV',

2929: GMA_COMMON_LOGGING.gma_migration_central_log (
2930: p_run_id => p_migration_run_id,
2931: p_log_level => FND_LOG.LEVEL_ERROR,
2932: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
2933: p_table_name => 'IC_LOCT_INV',
2934: p_context => 'INVENTORY BALANCE',
2935: p_param1 => l_migrate_count,
2936: p_param2 => x_failure_count,
2937: p_param3 => NULL,

Line 2950: p_table_name => 'IC_LOCT_INV',

2946: GMA_COMMON_LOGGING.gma_migration_central_log (
2947: p_run_id => p_migration_run_id,
2948: p_log_level => FND_LOG.LEVEL_ERROR,
2949: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2950: p_table_name => 'IC_LOCT_INV',
2951: p_context => 'INVENTORY BALANCE',
2952: p_param1 => NULL,
2953: p_param2 => NULL,
2954: p_param3 => NULL,