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_EBI_ITEM_HELPER dependencies on INV_EBI_ITEM_PUB

Line 546: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_ITEM_PUB.populate_item_ids ';

542: END IF;
543: WHEN OTHERS THEN
544: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
545: IF (x_out.output_status.msg_data IS NOT NULL) THEN
546: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_ITEM_PUB.populate_item_ids ';
547: ELSE
548: x_out.output_status.msg_data := SQLERRM||' INV_EBI_ITEM_PUB.populate_item_ids ';
549: END IF;
550: END populate_item_ids;

Line 548: x_out.output_status.msg_data := SQLERRM||' INV_EBI_ITEM_PUB.populate_item_ids ';

544: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
545: IF (x_out.output_status.msg_data IS NOT NULL) THEN
546: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_ITEM_PUB.populate_item_ids ';
547: ELSE
548: x_out.output_status.msg_data := SQLERRM||' INV_EBI_ITEM_PUB.populate_item_ids ';
549: END IF;
550: END populate_item_ids;
551: /************************************************************************************
552: -- API name : get_default_master_org

Line 1646: IF p_operation = INV_EBI_ITEM_PUB.g_otype_sync THEN

1642: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NUM_NULL');
1643: FND_MSG_PUB.add;
1644: RAISE FND_API.g_exc_error;
1645: END IF;
1646: IF p_operation = INV_EBI_ITEM_PUB.g_otype_sync THEN
1647: IF( is_item_exists (
1648: p_organization_id => l_item.main_obj_type.organization_id
1649: ,p_item_number => l_item_number
1650: ) = FND_API.g_true ) THEN

Line 1651: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_update;

1647: IF( is_item_exists (
1648: p_organization_id => l_item.main_obj_type.organization_id
1649: ,p_item_number => l_item_number
1650: ) = FND_API.g_true ) THEN
1651: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_update;
1652: ELSE
1653: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_create;
1654: l_item.main_obj_type.item_number := l_item_number;
1655: END IF;

Line 1653: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_create;

1649: ,p_item_number => l_item_number
1650: ) = FND_API.g_true ) THEN
1651: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_update;
1652: ELSE
1653: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_create;
1654: l_item.main_obj_type.item_number := l_item_number;
1655: END IF;
1656: ELSE
1657: l_transaction_type := p_operation;

Line 1739: IF(l_transaction_type = INV_EBI_ITEM_PUB.g_otype_create ) THEN

1735: l_item.main_obj_type.apply_template :='ALL';
1736:
1737: END IF;
1738:
1739: IF(l_transaction_type = INV_EBI_ITEM_PUB.g_otype_create ) THEN
1740:
1741: IF(l_item.main_obj_type.description IS NULL OR l_item.main_obj_type.description = fnd_api.g_miss_char) THEN
1742:
1743: IF(l_item.main_obj_type.item_catalog_group_id IS NOT NULL AND l_item.main_obj_type.item_catalog_group_id <> fnd_api.g_miss_num) THEN

Line 1843: IF(l_transaction_type = INV_EBI_ITEM_PUB.g_otype_update ) THEN

1839:
1840: END IF;
1841:
1842:
1843: IF(l_transaction_type = INV_EBI_ITEM_PUB.g_otype_update ) THEN
1844: l_apply_template_update := INV_EBI_UTIL.get_config_param_value(
1845: p_config_tbl => l_item.name_value_tbl
1846: ,p_config_param_name => 'TEMPLATE_FOR_ITEM_UPDATE_ALLOWED'
1847: );

Line 1874: ,p_transaction_type => INV_EBI_ITEM_PUB.g_otype_create

1870: EGO_ITEM_PUB.Process_Item_Revision(
1871: p_api_version => 1.0
1872: ,p_init_msg_list => FND_API.g_false
1873: ,p_commit => FND_API.g_false
1874: ,p_transaction_type => INV_EBI_ITEM_PUB.g_otype_create
1875: ,p_inventory_item_id => l_item.main_obj_type.inventory_item_id
1876: ,p_item_number => l_item.main_obj_type.item_number
1877: ,p_organization_id => l_item.main_obj_type.organization_id
1878: ,p_organization_code => l_item.main_obj_type.organization_code

Line 2441: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_update;

2437: IF (l_item.main_obj_type.item_desc_lang_obj_tbl_type.COUNT > 0)
2438: THEN
2439: /*Call the Process_item API for the same item in update mode for the different languages*/
2440:
2441: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_update;
2442:
2443: l_item.main_obj_type.inventory_item_id := x_out.inventory_item_id;
2444:
2445: l_orig_nls_lang := FND_GLOBAL.nls_language();

Line 2560: IF(l_transaction_type = INV_EBI_ITEM_PUB.g_otype_create) AND l_count=0 THEN

2556: WHEN NO_DATA_FOUND THEN
2557: l_count:=0;
2558: END;
2559:
2560: IF(l_transaction_type = INV_EBI_ITEM_PUB.g_otype_create) AND l_count=0 THEN
2561: INV_EBI_UTIL.debug_line('STEP 170: BEFORE CALLING MTL_CROSS_REFERENCES_PKG.insert_row');
2562:
2563: MTL_CROSS_REFERENCES_PKG.insert_row(
2564: p_source_system_id => l_source_system_id,

Line 2738: IF(l_data_level = INV_EBI_ITEM_PUB.G_DATA_LEVEL_ITEM) THEN

2734: INV_EBI_UTIL.debug_line('STEP 50: INSIDE Cursor Loop');
2735: l_data_level := cur_data_level.data_level_int_name;
2736: INV_EBI_UTIL.debug_line('STEP 60: l_data_level'|| l_data_level);
2737:
2738: IF(l_data_level = INV_EBI_ITEM_PUB.G_DATA_LEVEL_ITEM) THEN
2739:
2740: l_is_item_level := fnd_api.g_true;
2741: l_data_lvl := l_data_level;
2742: ELSIF

Line 2744: (l_data_level = INV_EBI_ITEM_PUB.G_DATA_LEVEL_ITEM_REV) THEN

2740: l_is_item_level := fnd_api.g_true;
2741: l_data_lvl := l_data_level;
2742: ELSIF
2743: -- Item Rev level is mutually exclusive with all other levels
2744: (l_data_level = INV_EBI_ITEM_PUB.G_DATA_LEVEL_ITEM_REV) THEN
2745: l_is_item_revision_level := fnd_api.g_true;
2746: l_data_lvl := l_data_level;
2747: END IF;
2748:

Line 2753: IF (l_data_lvl = INV_EBI_ITEM_PUB.g_data_level_item_rev ) THEN

2749: END LOOP;
2750: -- End of Bug 10378371
2751: END IF;
2752:
2753: IF (l_data_lvl = INV_EBI_ITEM_PUB.g_data_level_item_rev ) THEN
2754:
2755: IF p_revision_code IS NOT NULL AND p_revision_code <> fnd_api.g_miss_char THEN
2756: SELECT revision_id INTO l_revision_id
2757: FROM mtl_item_revisions

Line 3888: l_item_tbl(1).transaction_type := INV_EBI_ITEM_PUB.g_otype_update;

3884: l_new_phase_id <> fnd_api.g_miss_num OR
3885: l_new_status_code <> fnd_api.g_miss_char) THEN
3886:
3887: l_item_tbl.DELETE;
3888: l_item_tbl(1).transaction_type := INV_EBI_ITEM_PUB.g_otype_update;
3889: l_item_tbl(1).inventory_item_id := p_update_item_tbl(i).item_obj.main_obj_type.inventory_item_id;
3890: l_item_tbl(1).organization_id := p_update_item_tbl(i).item_obj.main_obj_type.organization_id;
3891: l_item_tbl(1).lifecycle_id := l_new_lifecycle_id;
3892: l_item_tbl(1).current_phase_id := l_new_phase_id;

Line 4649: IF(cur_data_level.data_level_int_name = INV_EBI_ITEM_PUB.G_DATA_LEVEL_ITEM) THEN

4645: p_attr_grp_id_tbl(i)
4646: )
4647: LOOP
4648:
4649: IF(cur_data_level.data_level_int_name = INV_EBI_ITEM_PUB.G_DATA_LEVEL_ITEM) THEN
4650:
4651: l_is_item_level := fnd_api.g_true;
4652: l_data_level := cur_data_level.data_level_int_name;
4653:

Line 4656: (cur_data_level.data_level_int_name = INV_EBI_ITEM_PUB.G_DATA_LEVEL_ITEM_REV) THEN

4652: l_data_level := cur_data_level.data_level_int_name;
4653:
4654: ELSIF
4655: -- Item Rev level is mutually exclusive with all other levels
4656: (cur_data_level.data_level_int_name = INV_EBI_ITEM_PUB.G_DATA_LEVEL_ITEM_REV) THEN
4657: l_is_item_revision_level := fnd_api.g_true;
4658: l_data_level := cur_data_level.data_level_int_name;
4659: END IF;
4660:

Line 4706: IF(l_data_level = INV_EBI_ITEM_PUB.g_data_level_item_rev) THEN

4702: IF l_new_attr_in_tbl <> FND_API.G_TRUE THEN
4703:
4704: l_attr_grp_req_tbl.extend();
4705:
4706: IF(l_data_level = INV_EBI_ITEM_PUB.g_data_level_item_rev) THEN
4707: l_data_level1 := p_revision_id;
4708: ELSE
4709: l_data_level1 := NULL;
4710: END IF;