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 INV_GMI_MIGRATION

Line 1: PACKAGE BODY INV_GMI_Migration AS

1: PACKAGE BODY INV_GMI_Migration AS
2: /* $Header: INVGMIMB.pls 120.27.12020000.2 2012/07/09 08:06:20 asugandh ship $
3: +==========================================================================+
4: | Copyright (c) 1998 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 728: p_param1 => INV_GMI_Migration.org(r.organization_id),

724: p_log_level => FND_LOG.LEVEL_PROCEDURE,
725: p_message_token => 'GMI_MIG_ITEM_CAT_EXISTS',
726: p_table_name => 'GMI_ITEM_CATEGORIES',
727: p_context => 'ITEM CATEGORIES',
728: p_param1 => INV_GMI_Migration.org(r.organization_id),
729: p_param2 => INV_GMI_Migration.ditem(r.organization_id, r.inventory_item_id),
730: p_param3 => to_char(r.category_set_id),
731: p_param4 => NULL,
732: p_param5 => NULL,

Line 729: p_param2 => INV_GMI_Migration.ditem(r.organization_id, r.inventory_item_id),

725: p_message_token => 'GMI_MIG_ITEM_CAT_EXISTS',
726: p_table_name => 'GMI_ITEM_CATEGORIES',
727: p_context => 'ITEM CATEGORIES',
728: p_param1 => INV_GMI_Migration.org(r.organization_id),
729: p_param2 => INV_GMI_Migration.ditem(r.organization_id, r.inventory_item_id),
730: p_param3 => to_char(r.category_set_id),
731: p_param4 => NULL,
732: p_param5 => NULL,
733: p_db_error => NULL,

Line 1725: p_param1 => INV_GMI_Migration.org(c.organization_id),

1721: p_log_level => FND_LOG.LEVEL_ERROR,
1722: p_message_token => 'GMI_MIG_ITEM_MIG_FAILED',
1723: p_table_name => 'IC_ITEM_CNV',
1724: p_context => 'LOT CONVERSION',
1725: p_param1 => INV_GMI_Migration.org(c.organization_id),
1726: p_param2 => INV_GMI_Migration.item(c.item_id),
1727: p_param3 => NULL,
1728: p_param4 => NULL,
1729: p_param5 => NULL,

Line 1726: p_param2 => INV_GMI_Migration.item(c.item_id),

1722: p_message_token => 'GMI_MIG_ITEM_MIG_FAILED',
1723: p_table_name => 'IC_ITEM_CNV',
1724: p_context => 'LOT CONVERSION',
1725: p_param1 => INV_GMI_Migration.org(c.organization_id),
1726: p_param2 => INV_GMI_Migration.item(c.item_id),
1727: p_param3 => NULL,
1728: p_param4 => NULL,
1729: p_param5 => NULL,
1730: p_db_error => NULL,

Line 1782: p_param1 => INV_GMI_Migration.org(c.organization_id),

1778: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1779: p_message_token => 'GMI_MIG_LOT_CONV_EXISTS',
1780: p_table_name => 'IC_ITEM_CNV',
1781: p_context => 'LOT CONVERSIONS',
1782: p_param1 => INV_GMI_Migration.org(c.organization_id),
1783: p_param2 => INV_GMI_Migration.ditem(c.organization_id, l_inventory_item_id),
1784: p_param3 => c.lot_number,
1785: p_param4 => l_from_uom_class,
1786: p_param5 => c.um_type,

Line 1783: p_param2 => INV_GMI_Migration.ditem(c.organization_id, l_inventory_item_id),

1779: p_message_token => 'GMI_MIG_LOT_CONV_EXISTS',
1780: p_table_name => 'IC_ITEM_CNV',
1781: p_context => 'LOT CONVERSIONS',
1782: p_param1 => INV_GMI_Migration.org(c.organization_id),
1783: p_param2 => INV_GMI_Migration.ditem(c.organization_id, l_inventory_item_id),
1784: p_param3 => c.lot_number,
1785: p_param4 => l_from_uom_class,
1786: p_param5 => c.um_type,
1787: p_db_error => NULL,

Line 2424: p_param1 => INV_GMI_Migration.org(l_organization_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,
2427: p_param4 => NULL,
2428: p_param5 => NULL,

Line 2434: l_field_value := INV_GMI_Migration.org(l_organization_id);

2430: p_app_short_name => 'GMI');
2431:
2432: -- Try to open the period
2433: l_field_name := 'Organization Definition';
2434: l_field_value := INV_GMI_Migration.org(l_organization_id);
2435: l_skip_to_next_whse := 1;
2436: SELECT b.period_set_name, b.accounted_period_type
2437: INTO l_period_set_name, l_accounted_period_type
2438: FROM org_organization_definitions a,

Line 2459: p_param1 => INV_GMI_Migration.org(l_organization_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,
2462: p_param4 => fp.period_name,
2463: p_param5 => NULL,

Line 2578: p_param1 => INV_GMI_Migration.org(l_organization_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,
2581: p_param4 => NULL,
2582: p_param5 => NULL,

Line 2579: p_param2 => INV_GMI_Migration.item(bal.item_id),

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,
2581: p_param4 => NULL,
2582: p_param5 => NULL,
2583: p_db_error => NULL,

Line 2643: p_param1 => INV_GMI_Migration.item(bal.item_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,
2646: p_param4 => bal.location,
2647: p_param5 => NULL,

Line 2644: p_param2 => INV_GMI_Migration.lot(bal.lot_id),

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,
2646: p_param4 => bal.location,
2647: p_param5 => NULL,
2648: p_db_error => NULL,

Line 2848: p_param1 => INV_GMI_Migration.item(bal.item_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),
2851: p_param4 => bal.location,
2852: p_param5 => NULL,

Line 2850: p_param3 => INV_GMI_Migration.lot(bal.lot_id),

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),
2851: p_param4 => bal.location,
2852: p_param5 => NULL,
2853: p_db_error => NULL,
2854: p_app_short_name => 'GMI');

Line 2962: END INV_GMI_Migration;

2958: p_app_short_name => 'GMA');
2959: ROLLBACK ;
2960: END;
2961:
2962: END INV_GMI_Migration;