DBA Data[Home] [Help]

APPS.INV_EBI_ITEM_HELPER dependencies on INV_EBI_ITEM_PUB

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

490: END IF;
491: WHEN OTHERS THEN
492: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
493: IF (x_out.output_status.msg_data IS NOT NULL) THEN
494: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_ITEM_PUB.populate_item_ids ';
495: ELSE
496: x_out.output_status.msg_data := SQLERRM||' INV_EBI_ITEM_PUB.populate_item_ids ';
497: END IF;
498: END populate_item_ids;

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

492: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
493: IF (x_out.output_status.msg_data IS NOT NULL) THEN
494: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_ITEM_PUB.populate_item_ids ';
495: ELSE
496: x_out.output_status.msg_data := SQLERRM||' INV_EBI_ITEM_PUB.populate_item_ids ';
497: END IF;
498: END populate_item_ids;
499: /************************************************************************************
500: -- API name : get_default_master_org

Line 1235: IF p_operation = INV_EBI_ITEM_PUB.g_otype_sync THEN

1231: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NUM_NULL');
1232: FND_MSG_PUB.add;
1233: RAISE FND_API.g_exc_error;
1234: END IF;
1235: IF p_operation = INV_EBI_ITEM_PUB.g_otype_sync THEN
1236: IF( is_item_exists (
1237: p_organization_id => l_item.main_obj_type.organization_id
1238: ,p_item_number => l_item_number
1239: ) = FND_API.g_true ) THEN

Line 1240: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_update;

1236: IF( is_item_exists (
1237: p_organization_id => l_item.main_obj_type.organization_id
1238: ,p_item_number => l_item_number
1239: ) = FND_API.g_true ) THEN
1240: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_update;
1241: ELSE
1242: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_create;
1243: l_item.main_obj_type.item_number := l_item_number;
1244: END IF;

Line 1242: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_create;

1238: ,p_item_number => l_item_number
1239: ) = FND_API.g_true ) THEN
1240: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_update;
1241: ELSE
1242: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_create;
1243: l_item.main_obj_type.item_number := l_item_number;
1244: END IF;
1245: ELSE
1246: l_transaction_type := p_operation;

Line 1306: IF(l_transaction_type = INV_EBI_ITEM_PUB.g_otype_create AND l_item.main_obj_type.description IS NULL OR l_item.main_obj_type.description = fnd_api.g_miss_char) THEN

1302: END IF;
1303: IF ((l_item.main_obj_type.apply_template IS NULL OR l_item.main_obj_type.apply_template = fnd_api.g_miss_char) AND (l_item.main_obj_type.template_id IS NOT NULL OR l_item.main_obj_type.template_name IS NOT NULL)) THEN
1304: l_item.main_obj_type.apply_template :='ALL';
1305: END IF;
1306: IF(l_transaction_type = INV_EBI_ITEM_PUB.g_otype_create AND l_item.main_obj_type.description IS NULL OR l_item.main_obj_type.description = fnd_api.g_miss_char) THEN
1307: 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
1308: l_item_desc_gen_method := get_desc_gen_method(l_item.main_obj_type.item_catalog_group_id);
1309: END IF;
1310: IF(l_item_desc_gen_method = 'U' OR l_item_desc_gen_method IS NULL OR l_item.main_obj_type.item_catalog_group_id IS NULL OR l_item.main_obj_type.item_catalog_group_id = fnd_api.g_miss_num) THEN

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

1341: END IF;
1342:
1343:
1344:
1345: IF(l_transaction_type = INV_EBI_ITEM_PUB.g_otype_update ) THEN
1346: l_apply_template_update := INV_EBI_UTIL.get_config_param_value(
1347: p_config_tbl => l_item.name_value_tbl
1348: ,p_config_param_name => 'TEMPLATE_FOR_ITEM_UPDATE_ALLOWED'
1349: );

Line 1372: ,p_transaction_type => INV_EBI_ITEM_PUB.g_otype_create

1368: EGO_ITEM_PUB.Process_Item_Revision(
1369: p_api_version => 1.0
1370: ,p_init_msg_list => FND_API.g_false
1371: ,p_commit => FND_API.g_false
1372: ,p_transaction_type => INV_EBI_ITEM_PUB.g_otype_create
1373: ,p_inventory_item_id => l_item.main_obj_type.inventory_item_id
1374: ,p_item_number => l_item.main_obj_type.item_number
1375: ,p_organization_id => l_item.main_obj_type.organization_id
1376: ,p_organization_code => l_item.main_obj_type.organization_code

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

1856: ,x_ouid => x_out.operating_unit_id
1857: );
1858:
1859:
1860: IF(l_transaction_type = INV_EBI_ITEM_PUB.g_otype_create) THEN
1861: MTL_CROSS_REFERENCES_PKG.insert_row(
1862: p_source_system_id => NULL,
1863: p_start_date_active => SYSDATE,
1864: p_end_date_active => NULL,

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

1984: FROM ego_obj_attr_grp_assocs_v
1985: WHERE attr_group_id = l_attributes_row_table(i).attr_group_id
1986: AND classification_code = TO_CHAR(p_item_catalog_group_id);
1987: END IF;
1988: IF (l_data_level = INV_EBI_ITEM_PUB.g_data_level_item_rev ) THEN
1989:
1990: IF p_revision_code IS NOT NULL AND p_revision_code <> fnd_api.g_miss_char THEN
1991: SELECT revision_id INTO l_revision_id
1992: FROM mtl_item_revisions

Line 3204: IF(attr_cursor.data_level_int_name = INV_EBI_ITEM_PUB.g_data_level_item_rev) THEN

3200: IF l_new_attr_in_tbl <> FND_API.G_TRUE THEN
3201:
3202: l_attr_grp_req_tbl.extend();
3203:
3204: IF(attr_cursor.data_level_int_name = INV_EBI_ITEM_PUB.g_data_level_item_rev) THEN
3205: l_data_level1 := p_revision_id;
3206: ELSE
3207: l_data_level1 := NULL;
3208: END IF;